text: -- SQL definition for module ticket
  -- Copyright (C) 2013  Jean-François FERRY <hello@librethic.io>
  --
  -- This program is free software: you can redistribute it and/or modify
  -- it under the terms of the GNU General Public License as published by
  -- the Free Software Foundation, either version 3 of the License, or
  -- (at your option) any later version.
  --
  -- This program is distributed in the hope that it will be useful,
  -- but WITHOUT ANY WARRANTY; without even the implied warranty of
  -- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  -- GNU General Public License for more details.
  --
  -- You should have received a copy of the GNU General Public License
  -- along with this program.  If not, see <http://www.gnu.org/licenses/>.
  
  CREATE TABLE llx_ticket
  (
  	rowid       integer AUTO_INCREMENT PRIMARY KEY,
  	entity		integer DEFAULT 1,
  	ref			varchar(128) NOT NULL,
  	track_id    varchar(128) NOT NULL,
  	fk_soc		integer DEFAULT 0,
  	fk_project	integer DEFAULT 0,
  	origin_email   varchar(128),
  	fk_user_create	integer,
  	fk_user_assign	integer,
  	subject	varchar(255),
  	message	text,
  	fk_statut integer,
  	resolution integer,
  	progress varchar(100),
  	timing varchar(20),
  	type_code varchar(32),
  	category_code varchar(32),
  	severity_code varchar(32),
  	datec datetime,
  	date_read datetime,
  	date_close datetime,
  	notify_tiers_at_create tinyint,
  	tms timestamp
  )ENGINE=innodb;
  