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