2 -- Table structure for table tickets
4 CREATE TABLE mtrack_ticket (
5 id int(11) NOT NULL AUTO_INCREMENT,
6 project_id int(11) NOT NULL DEFAULT 0,
10 created int(11) NOT NULL DEFAULT 0,
11 updated int(11) NOT NULL DEFAULT 0,
12 owner_id int(11) NOT NULL DEFAULT 0,
13 priority_id int(11) NOT NULL DEFAULT 0,
14 severity_id int(11) NOT NULL DEFAULT 0,
15 classification_id int(11) NOT NULL DEFAULT 0,
16 resolution_id int(11) NOT NULL DEFAULT 0,
18 status int(11) NOT NULL DEFAULT 0,
19 estimated double DEFAULT NULL,
20 spent double DEFAULT NULL,
25 ALTER TABLE mtrack_ticket ADD COLUMN project_id int(11) NOT NULL DEFAULT 0;
26 ALTER TABLE mtrack_ticket ADD COLUMN developer_id int(11) NOT NULL DEFAULT 0;
27 ALTER TABLE mtrack_ticket ADD COLUMN milestone_id int(11) NOT NULL DEFAULT 0;
28 ALTER TABLE mtrack_ticket ADD COLUMN act_now int(11) NOT NULL DEFAULT 0;
29 ALTER TABLE mtrack_ticket ADD COLUMN seqid int(11) NOT NULL DEFAULT 0;