Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

[45d05f]: ddl / update5.sql Maximize Restore History

Download this file

update5.sql    35 lines (31 with data), 950 Bytes

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
CREATE TABLE Patches
(
Id INT(7) NOT NULL AUTO_INCREMENT,
Received DATETIME NOT NULL,
Disposition VARCHAR(40) NOT NULL,
FromName VARCHAR(40) NULL,
FromEMail VARCHAR(40) NULL,
Subject VARCHAR(120) NULL,
PRIMARY KEY (Id)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE PendingPatchSeries
(
EMail VARCHAR(40) NOT NULL,
TotalParts INT(2) NOT NULL,
PRIMARY KEY (EMail)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE PendingPatches
(
PendingPatchSeriesEMail VARCHAR(40) NOT NULL,
No INT(2) NOT NULL,
PatchId INT(7) NOT NULL,
FOREIGN KEY (PendingPatchSeriesEMail) REFERENCES PendingPatchSeries(EMail),
FOREIGN KEY (PatchId) REFERENCES Patches(Id),
PRIMARY KEY (PendingPatchSeriesEMail, No)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE Jobs
ADD PatchId INT(7) NULL,
ADD FOREIGN KEY (PatchId) REFERENCES Patches(Id);