DataObjects/mtrack.sql

diff --git a/DataObjects/mtrack.sql b/DataObjects/mtrack.sql
index 06ad43e..25004b2 100644 (file)
--- a/DataObjects/mtrack.sql
+++ b/DataObjects/mtrack.sql
@@ -2,36 +2,8 @@
 -- Change tracking.. - may be moved up later???
 
 
-CREATE TABLE mtrack_change_audit (
-  id int(11) NOT NULL AUTO_INCREMENT,
-  change_id int(11) NOT NULL DEFAULT 0,
-  fieldname varchar(128) DEFAULT '',
-  action varchar(16) DEFAULT '',
-  oldvalue text,
-  value text,
-  PRIMARY KEY(id)
-) ;
-ALTER TABLE mtrack_change_audit ADD COLUMN ticket_change_id int(11) NOT NULL DEFAULT 0;
-
-ALTER TABLE mtrack_change_audit ADD INDEX change_id_lookup (change_id);
-ALTER TABLE mtrack_change_audit ADD INDEX ticket_change_id_lookup (ticket_change_id);
-
-
 
 
-CREATE TABLE mtrack_change (
-  id int(11) NOT NULL AUTO_INCREMENT,
-  person_id int(11) DEFAULT 0,
-  ontable varchar(128) DEFAULT '',
-  onid int(11) NOT NULL DEFAULT 0,
-  changedate datetime NOT NULL,
-  rev varchar(32) NOT NULL DEFAULT '',
-  reason text ,
-  PRIMARY KEY (id)
-) ;
-
-ALTER TABLE mtrack_change ADD COLUMN rev varchar(64) NOT NULL DEFAULT '';
-
 -- Caching??? - go back to file baseD?
  
 CREATE TABLE mtrack_clcache (
@@ -57,25 +29,7 @@ CREATE TABLE mtrack_project_reference (
  
 
   
--- 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;
 
 -- reports??? - may change quite a bit later?
 -- change/update etc are references to mtrack_changes
@@ -91,23 +45,7 @@ CREATE TABLE mtrack_report (
 
 -- Table structure for table repos
 
-CREATE TABLE mtrack_repos (
-  id int(11) NOT NULL AUTO_INCREMENT,
-  shortname varchar(64)  NOT NULL DEFAULT '',
-  scmtype varchar(16) NOT NULL DEFAULT '',
-  repopath varchar(255) NOT NULL DEFAULT '',
-  browserurl varchar(255) DEFAULT NULL DEFAULT '',
-  browsertype varchar(255) DEFAULT NULL DEFAULT '',
-  description text,
-  serverurl varchar(255) DEFAULT NULL DEFAULT '',
-  parent varchar(255) NOT NULL DEFAULT '',
-  clonedfrom int(11) DEFAULT NULL,
-  PRIMARY KEY (id)
-) ;
-ALTER TABLE mtrack_repos ADD COLUMN project_id INT(11) DEFAULT 0;
-ALTER TABLE mtrack_repos ADD INDEX plookup(project_id);
 
- 
 
 CREATE TABLE mtrack_snippet (
   id int(11) NOT NULL AUTO_INCREMENT,
@@ -138,51 +76,8 @@ CREATE TABLE mtrack_ticket_reference (
 
  
 
--- 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;
-
-
-
-CREATE TABLE  mtrack_wiki (
-  id int(11)  NOT NULL AUTO_INCREMENT,
-  project_id int(11)  NOT NULL  DEFAULT 0,
-  path varchar(128)  NOT NULL  DEFAULT '',
-  wikidata longtext  NOT NULL,
-  created_id int(11)  NOT NULL  DEFAULT 0,
-  updated_id int(11)  NOT NULL  DEFAULT 0,
-  is_protected int(2)  NOT NULL COMMENT 'if so team only',
-  is_protected_company int(2)  NOT NULL  DEFAULT 0,
-  protected_group text  NOT NULL,
-  PRIMARY KEY (id),
-  INDEX lookup(project_id, path)
-);
 
+DROP TABLE mtrack_desktop_activity;
 CREATE TABLE mtrack_desktop_activity (
   id int(11)  NOT NULL AUTO_INCREMENT,
   cmd_id int(11)  NOT NULL,