2 CREATE TEMPORARY TABLE Tickets_backup (
3 id INTEGER PRIMARY KEY ,
4 EffectiveId integer NULL ,
6 Type varchar(16) NULL ,
7 IssueStatement integer NULL ,
8 Resolution integer NULL ,
10 Subject varchar(200) NULL DEFAULT '[no subject]' ,
11 InitialPriority integer NULL ,
12 FinalPriority integer NULL ,
13 Priority integer NULL ,
14 TimeEstimated integer NULL ,
15 TimeWorked integer NULL ,
16 Status varchar(64) NULL ,
17 TimeLeft integer NULL ,
19 Starts DATETIME NULL ,
20 Started DATETIME NULL ,
22 Resolved DATETIME NULL ,
23 LastUpdatedBy integer NULL ,
24 LastUpdated DATETIME NULL ,
25 Creator integer NULL ,
26 Created DATETIME NULL ,
27 Disabled int2 NOT NULL DEFAULT 0
30 INSERT INTO Tickets_backup SELECT * FROM Tickets;
33 CREATE TABLE Tickets (
34 id INTEGER PRIMARY KEY ,
35 EffectiveId integer NULL ,
37 Type varchar(16) NULL ,
38 IssueStatement integer NULL ,
39 Resolution integer NULL ,
41 Subject varchar(200) NULL DEFAULT '[no subject]' ,
42 InitialPriority integer NULL ,
43 FinalPriority integer NULL ,
44 Priority integer NULL ,
45 TimeEstimated integer NULL ,
46 TimeWorked integer NULL ,
47 Status varchar(64) NULL ,
48 TimeLeft integer NULL ,
50 Starts DATETIME NULL ,
51 Started DATETIME NULL ,
53 Resolved DATETIME NULL ,
54 LastUpdatedBy integer NULL ,
55 LastUpdated DATETIME NULL ,
56 Creator integer NULL ,
57 Created DATETIME NULL ,
58 Disabled int2 NOT NULL DEFAULT 0
61 CREATE INDEX Tickets1 ON Tickets (Queue, Status) ;
62 CREATE INDEX Tickets2 ON Tickets (Owner) ;
63 CREATE INDEX Tickets3 ON Tickets (EffectiveId) ;
64 CREATE INDEX Tickets4 ON Tickets (id, Status) ;
65 CREATE INDEX Tickets5 ON Tickets (id, EffectiveId) ;
67 INSERT INTO Tickets SELECT * FROM Tickets_backup;
68 DROP TABLE Tickets_backup;