1 -- Table structure for table milestones
2 -- change/update etc are references to mtrack_changes
3 CREATE TABLE mtrack_milestone (
4 id int(11) NOT NULL AUTO_INCREMENT,
5 name varchar(128) DEFAULT NULL,
7 startdate datetime DEFAULT NULL,
8 duedate datetime DEFAULT NULL,
9 completed datetime DEFAULT NULL,
10 deleted int(11) NOT NULL DEFAULT '0',
11 created int(11) NOT NULL,
12 updated int(11) NOT NULL,
13 project_id int(11) DEFAULT 0,
17 ALTER TABLE mtrack_milestone CHANGE column pmid project_id int (11) DEFAULT 0;
18 ALTER TABLE mtrack_milestone CHANGE column completed completed int (11) NOT NULL DEFAULT 0;
19 ALTER TABLE mtrack_milestone ADD column on_hold int (2) NOT NULL DEFAULT 0;