sql/mtrack_milestone.sql

diff --git a/sql/mtrack_milestone.sql b/sql/mtrack_milestone.sql
new file mode 100644 (file)
index 0000000..ca15e48
--- /dev/null
+++ b/sql/mtrack_milestone.sql
@@ -0,0 +1,19 @@
+-- Table structure for table milestones
+-- change/update etc are references to mtrack_changes
+CREATE TABLE mtrack_milestone (
+  id int(11) NOT NULL AUTO_INCREMENT,
+  name varchar(128) DEFAULT NULL,
+  description text,
+  startdate datetime DEFAULT NULL,
+  duedate datetime DEFAULT NULL,
+  completed datetime DEFAULT NULL,
+  deleted int(11) NOT NULL DEFAULT '0',
+  created int(11) NOT NULL,
+  updated int(11) NOT NULL,
+  project_id int(11) DEFAULT 0,
+  PRIMARY KEY (id)
+);
+
+ALTER TABLE mtrack_milestone CHANGE column pmid project_id int (11) DEFAULT 0;
+ALTER TABLE mtrack_milestone CHANGE column completed completed int (11) NOT NULL DEFAULT 0;
+ALTER TABLE mtrack_milestone ADD column on_hold int (2) NOT NULL DEFAULT 0;
\ No newline at end of file