1-- Copyright (C) 2013  Jean-François FERRY <hello@librethic.io>
2--
3-- This program is free software; you can redistribute it and/or modify
4-- it under the terms of the GNU General Public License as published by
5-- the Free Software Foundation; either version 2 of the License, or
6-- (at your option) any later version.
7--
8-- This program is distributed in the hope that it will be useful,
9-- but WITHOUT ANY WARRANTY; without even the implied warranty of
10-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
11-- GNU General Public License for more details.
12--
13-- You should have received a copy of the GNU General Public License
14-- along with this program. If not, see <https://www.gnu.org/licenses/>.
15--
16-- Type of ticket. For example: COM, ISSUE, REQUEST, PROJECT, OTHER, ...
17
18create table llx_c_ticket_type
19(
20  rowid			integer AUTO_INCREMENT PRIMARY KEY,
21  entity		integer DEFAULT 1,
22  code			varchar(32)				NOT NULL,
23  pos			varchar(32)				NOT NULL,
24  label			varchar(128)			NOT NULL,
25  active		integer DEFAULT 1,
26  use_default	integer DEFAULT 1,
27  description	varchar(255)
28)ENGINE=innodb;
29