-- this stuff is not used anymore...


 


-- Table structure for table components_by_project
-- ?? not used?
CREATE TABLE mtrack_project_reference (
   id int(11) NOT NULL AUTO_INCREMENT,
   project_id  int(11) NOT NULL,
   enum_id int(11) NOT NULL,
   PRIMARY KEY (id)
) ;
 

  


-- reports??? - may change quite a bit later?
-- change/update etc are references to mtrack_changes
-- not used?
CREATE TABLE mtrack_report (
  id int(11) NOT NULL AUTO_INCREMENT,
  summary varchar(128) NOT NULL,
  description text NOT NULL,
  query text,
  changed int(11) NOT NULL,
  PRIMARY KEY (id)
) ;

-- Table structure for table repos


-- not used?
CREATE TABLE mtrack_snippet (
  id int(11) NOT NULL AUTO_INCREMENT,
  created int(11) NOT NULL DEFAULT 0,
  updated int(11) NOT NULL,
  description text,
  lang varchar(32) NOT NULL,
  snippet longtext,
  PRIMARY KEY (id)
) ;

-- 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)
-- ) ;

-- 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,
   enum_id int(11) NOT NULL,
   PRIMARY KEY (id)
) ;

 

-- not used?
 CREATE TABLE mtrack_desktop_activity (
  id int(11)  NOT NULL AUTO_INCREMENT,
  cmd_id int(11)  NOT NULL,
  title_id int(11)  NOT NULL,
  start_dt datetime  NOT NULL,
  end_dt datetime  NOT NULL,
  person_id int(11)  NOT NULL,
  PRIMARY KEY (id),
  INDEX lookup(person_id, start_dt, end_dt)
) ;

CREATE TABLE  mtrack_desktop_cmd (
  id int(11)  NOT NULL AUTO_INCREMENT,
  name varchar(255)  NOT NULL,
  PRIMARY KEY (id),
  INDEX lookup(name)
) ;



