1-- Fix bad index on Media table
2DROP INDEX inx8 ON Media;
3CREATE UNIQUE INDEX inx8 ON Media (VolumeName(128));
4ALTER TABLE File CHANGE FileId FileId BIGINT UNSIGNED NOT NULL AUTO_INCREMENT;
5ALTER TABLE BaseFiles CHANGE FileId FileId BIGINT UNSIGNED NOT NULL;
6ALTER TABLE Job ADD ReadBytes BIGINT UNSIGNED DEFAULT 0 AFTER JobBytes;
7ALTER TABLE Media ADD ActionOnPurge TINYINT DEFAULT 0 AFTER Recycle;
8ALTER TABLE Pool ADD ActionOnPurge TINYINT DEFAULT 0 AFTER Recycle;
9
10DROP TABLE IF EXISTS JobHistory;
11
12-- Create a table like Job for long term statistics
13CREATE TABLE JobHisto (
14   JobId INTEGER UNSIGNED NOT NULL,
15   Job TINYBLOB NOT NULL,
16   Name TINYBLOB NOT NULL,
17   Type BINARY(1) NOT NULL,
18   Level BINARY(1) NOT NULL,
19   ClientId INTEGER DEFAULT 0,
20   JobStatus BINARY(1) NOT NULL,
21   SchedTime DATETIME DEFAULT 0,
22   StartTime DATETIME DEFAULT 0,
23   EndTime DATETIME DEFAULT 0,
24   RealEndTime DATETIME DEFAULT 0,
25   JobTDate BIGINT UNSIGNED DEFAULT 0,
26   VolSessionId INTEGER UNSIGNED DEFAULT 0,
27   VolSessionTime INTEGER UNSIGNED DEFAULT 0,
28   JobFiles INTEGER UNSIGNED DEFAULT 0,
29   JobBytes BIGINT UNSIGNED DEFAULT 0,
30   ReadBytes BIGINT UNSIGNED DEFAULT 0,
31   JobErrors INTEGER UNSIGNED DEFAULT 0,
32   JobMissingFiles INTEGER UNSIGNED DEFAULT 0,
33   PoolId INTEGER UNSIGNED DEFAULT 0,
34   FileSetId INTEGER UNSIGNED DEFAULT 0,
35   PriorJobId INTEGER UNSIGNED DEFAULT 0,
36   PurgedFiles TINYINT DEFAULT 0,
37   HasBase TINYINT DEFAULT 0,
38   INDEX (StartTime)
39);
40
41UPDATE Version SET VersionId = 11;
42