sql/mtrack_ticket.sql

diff --git a/sql/mtrack_ticket.sql b/sql/mtrack_ticket.sql
new file mode 100644 (file)
index 0000000..853f918
--- /dev/null
+++ b/sql/mtrack_ticket.sql
@@ -0,0 +1,30 @@
+
+-- 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;
+