1 -- this stuff is not used anymore...
7 -- Table structure for table components_by_project
9 CREATE TABLE mtrack_project_reference (
10 id int(11) NOT NULL AUTO_INCREMENT,
11 project_id int(11) NOT NULL,
12 enum_id int(11) NOT NULL,
20 -- reports??? - may change quite a bit later?
21 -- change/update etc are references to mtrack_changes
23 CREATE TABLE mtrack_report (
24 id int(11) NOT NULL AUTO_INCREMENT,
25 summary varchar(128) NOT NULL,
26 description text NOT NULL,
28 changed int(11) NOT NULL,
32 -- Table structure for table repos
36 CREATE TABLE mtrack_snippet (
37 id int(11) NOT NULL AUTO_INCREMENT,
38 created int(11) NOT NULL DEFAULT 0,
39 updated int(11) NOT NULL,
41 lang varchar(32) NOT NULL,
46 -- Table structure for table ticket_changeset_hashes
48 -- CREATE TABLE ticket_changeset_hashes (
49 -- tid char(32) NOT NULL,
50 -- hash varchar(128) NOT NULL DEFAULT '',
51 -- PRIMARY KEY (tid,hash)
54 -- Table structure for table ticket_components
56 CREATE TABLE mtrack_ticket_reference (
57 id int(11) NOT NULL AUTO_INCREMENT,
58 ticket_id int(11) NOT NULL,
59 enum_id int(11) NOT NULL,
66 CREATE TABLE mtrack_desktop_activity (
67 id int(11) NOT NULL AUTO_INCREMENT,
68 cmd_id int(11) NOT NULL,
69 title_id int(11) NOT NULL,
70 start_dt datetime NOT NULL,
71 end_dt datetime NOT NULL,
72 person_id int(11) NOT NULL,
74 INDEX lookup(person_id, start_dt, end_dt)
77 CREATE TABLE mtrack_desktop_cmd (
78 id int(11) NOT NULL AUTO_INCREMENT,
79 name varchar(255) NOT NULL,