DataObjects/mtrack.sql

sql/mtrack_jira.sql

diff --git a/DataObjects/mtrack.sql b/DataObjects/mtrack.sql
index f73c807..36aa9c6 100644 (file)
--- a/DataObjects/mtrack.sql
+++ b/DataObjects/mtrack.sql
@@ -49,14 +49,14 @@ CREATE TABLE mtrack_snippet (
 
 -- Table structure for table ticket_changeset_hashes
 
-#CREATE TABLE ticket_changeset_hashes (
-#tid char(32) NOT NULL,
-#  hash varchar(128) NOT NULL DEFAULT '',
-#  PRIMARY KEY (tid,hash)
-#) ;
+-- CREATE TABLE ticket_changeset_hashes (
+-- tid char(32) NOT NULL,
+--  hash varchar(128) NOT NULL DEFAULT '',
+--  PRIMARY KEY (tid,hash)
+--) ;
 
 -- Table structure for table ticket_components
-
+-- not used
 CREATE TABLE mtrack_ticket_reference (
    id int(11) NOT NULL AUTO_INCREMENT,
    ticket_id  int(11) NOT NULL,
@@ -85,14 +85,6 @@ CREATE TABLE  mtrack_desktop_cmd (
   INDEX lookup(name)
 ) ;
 
-CREATE  TABLE mtrack_jira (
-  id INT NOT NULL AUTO_INCREMENT ,
-  project_id INT(11) NOT NULL DEFAULT 0 ,
-  jira_url TEXT NOT NULL ,
-  username VARCHAR(128) NOT NULL ,
-  passwd VARCHAR(128) NOT NULL ,
-  PRIMARY KEY (id)
-);
 
 
 CREATE  TABLE  mtrack_jira_object (

diff --git a/sql/mtrack_jira.sql b/sql/mtrack_jira.sql
index e69de29..214996a 100644 (file)
--- a/sql/mtrack_jira.sql
+++ b/sql/mtrack_jira.sql
@@ -0,0 +1,9 @@
+
+CREATE  TABLE mtrack_jira (
+  id INT NOT NULL AUTO_INCREMENT ,
+  project_id INT(11) NOT NULL DEFAULT 0 ,
+  jira_url TEXT NOT NULL ,
+  username VARCHAR(128) NOT NULL ,
+  passwd VARCHAR(128) NOT NULL ,
+  PRIMARY KEY (id)
+);
\ No newline at end of file