3 DROP TABLE IF EXISTS MAC;
\r
4 DROP TABLE IF EXISTS Log;
\r
5 DROP TABLE IF EXISTS Location;
\r
6 DROP TABLE IF EXISTS LocationLog;
\r
9 LogId INTEGER UNSIGNED AUTO_INCREMENT,
\r
10 JobId INTEGER UNSIGNED DEFAULT 0 REFERENCES Job,
\r
11 Time DATETIME DEFAULT 0,
\r
12 LogText BLOB NOT NULL,
\r
17 CREATE TABLE Location (
\r
18 LocationId INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
\r
19 Location TINYBLOB NOT NULL,
\r
20 Cost INTEGER DEFAULT 0,
\r
22 PRIMARY KEY(LocationId)
\r
25 CREATE TABLE LocationLog (
\r
26 LocLogId INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
\r
27 Date DATETIME DEFAULT 0,
\r
29 MediaId INTEGER UNSIGNED DEFAULT 0 REFERENCES Media,
\r
30 LocationId INTEGER UNSIGNED DEFAULT 0 REFERENCES Location,
\r
31 NewVolStatus ENUM('Full', 'Archive', 'Append', 'Recycle', 'Purged',
\r
32 'Read-Only', 'Disabled', 'Error', 'Busy', 'Used', 'Cleaning') NOT NULL,
\r
34 PRIMARY KEY(LocLogId)
\r
37 ALTER TABLE Media ADD COLUMN MediaTypeId INTEGER UNSIGNED DEFAULT 0 REFERENCES MediaType;
\r
38 ALTER TABLE Media ADD COLUMN DeviceId INTEGER UNSIGNED DEFAULT 0 REFERENCES Device;
\r
39 ALTER TABLE Media ADD COLUMN LocationId INTEGER UNSIGNED DEFAULT 0 REFERENCES Location;
\r
40 ALTER TABLE Media ADD COLUMN RecycleCount INTEGER UNSIGNED DEFAULT 0;
\r
41 ALTER TABLE Media ADD COLUMN InitialWrite DATETIME DEFAULT 0;
\r
42 ALTER TABLE Media ADD COLUMN ScratchPoolId INTEGER UNSIGNED DEFAULT 0 REFERENCES Pool;
\r
43 ALTER TABLE Media ADD COLUMN RecyclePoolId INTEGER UNSIGNED DEFAULT 0 REFERENCES Pool;
\r
44 ALTER TABLE Media ADD COLUMN Enabled TINYINT DEFAULT 1;
\r
45 ALTER TABLE Media ADD COLUMN Comment BLOB;
\r
47 ALTER TABLE JobMedia DROP COLUMN Stripe;
\r
49 ALTER TABLE Job ADD COLUMN PriorJobId INTEGER UNSIGNED DEFAULT 0 REFERENCES Job;
\r
50 ALTER TABLE Job ADD COLUMN RealEndTime DATETIME DEFAULT 0;
\r
54 DELETE FROM Version;
\r
55 INSERT INTO Version (VersionId) VALUES (10);
\r