--- Table structure for table tickets
-
-CREATE TABLE mtrack_ticket (
- id int(11) NOT NULL AUTO_INCREMENT,
- project_id int(11) NOT NULL DEFAULT 0,
- summary longtext,
- description longtext,
- changelog longtext,
- created int(11) NOT NULL DEFAULT 0,
- updated int(11) NOT NULL DEFAULT 0,
- owner_id int(11) NOT NULL DEFAULT 0,
- priority_id int(11) NOT NULL DEFAULT 0,
- severity_id int(11) NOT NULL DEFAULT 0,
- classification_id int(11) NOT NULL DEFAULT 0,
- resolution_id int(11) NOT NULL DEFAULT 0,
- cc text,
- status int(11) NOT NULL DEFAULT 0,
- estimated double DEFAULT NULL,
- spent double DEFAULT NULL,
- x_fieldname text,
- PRIMARY KEY (id)
-) ;
-
-ALTER TABLE mtrack_ticket ADD COLUMN project_id int(11) NOT NULL DEFAULT 0;
-ALTER TABLE mtrack_ticket ADD COLUMN developer_id int(11) NOT NULL DEFAULT 0;
-ALTER TABLE mtrack_ticket ADD COLUMN milestone_id int(11) NOT NULL DEFAULT 0;
-ALTER TABLE mtrack_ticket ADD COLUMN act_now int(11) NOT NULL DEFAULT 0;
-ALTER TABLE mtrack_ticket ADD COLUMN seqid int(11) NOT NULL DEFAULT 0;
-
-
-
-CREATE TABLE mtrack_wiki (
- id int(11) NOT NULL AUTO_INCREMENT,
- project_id int(11) NOT NULL DEFAULT 0,
- path varchar(128) NOT NULL DEFAULT '',
- wikidata longtext NOT NULL,
- created_id int(11) NOT NULL DEFAULT 0,
- updated_id int(11) NOT NULL DEFAULT 0,
- is_protected int(2) NOT NULL COMMENT 'if so team only',
- is_protected_company int(2) NOT NULL DEFAULT 0,
- protected_group text NOT NULL,
- PRIMARY KEY (id),
- INDEX lookup(project_id, path)
-);
-
-CREATE TABLE mtrack_desktop_activity (