sql/mtrack_jira_object.sql

DataObjects/mtrack.sql

diff --git a/DataObjects/mtrack.sql b/DataObjects/mtrack.sql
index 36aa9c6..307a7ee 100644 (file)
--- a/DataObjects/mtrack.sql
+++ b/DataObjects/mtrack.sql
@@ -87,13 +87,3 @@ CREATE TABLE  mtrack_desktop_cmd (
 
 
 
-CREATE  TABLE  mtrack_jira_object (
-  id INT NOT NULL AUTO_INCREMENT ,
-  on_table VARCHAR(64) NOT NULL ,
-  on_id INT NOT NULL DEFAULT 0 ,
-  jira_ref VARCHAR(64) NOT NULL ,
-  PRIMARY KEY (id)
-  );
-  
- alter table  mtrack_jira_object add column jira_key VARCHAR(64) NOT NULL;
-

diff --git a/sql/mtrack_jira_object.sql b/sql/mtrack_jira_object.sql
new file mode 100644 (file)
index 0000000..76ef3e2
--- /dev/null
+++ b/sql/mtrack_jira_object.sql
@@ -0,0 +1,10 @@
+CREATE  TABLE  mtrack_jira_object (
+  id INT NOT NULL AUTO_INCREMENT ,
+  on_table VARCHAR(64) NOT NULL ,
+  on_id INT NOT NULL DEFAULT 0 ,
+  jira_ref VARCHAR(64) NOT NULL ,
+  PRIMARY KEY (id)
+  );
+  
+ alter table  mtrack_jira_object add column jira_key VARCHAR(64) NOT NULL;
+