-
-CREATE TEMPORARY TABLE JobMedia_backup (
- JobMediaId INTEGER,
- JobId INTEGER UNSIGNED REFERENCES Job NOT NULL,
- MediaId INTEGER UNSIGNED REFERENCES Media NOT NULL,
- FirstIndex INTEGER UNSIGNED NOT NULL,
- LastIndex INTEGER UNSIGNED NOT NULL,
- StartFile INTEGER UNSIGNED DEFAULT 0,
- EndFile INTEGER UNSIGNED DEFAULT 0,
- StartBlock INTEGER UNSIGNED DEFAULT 0,
- EndBlock INTEGER UNSIGNED DEFAULT 0,
- VolIndex INTEGER UNSIGNED DEFAULT 0,
- Copy INTEGER UNSIGNED DEFAULT 0,
- Stripe INTEGER UNSIGNED DEFAULT 0,
- PRIMARY KEY(JobMediaId)
- );
-
-INSERT INTO JobMedia_backup SELECT
- JobMediaId, JobId, MediaId,
- FirstIndex, LastIndex, StartFile,
- EndFile, StartBlock, EndBlock,
- VolIndex, 0, 0
- FROM JobMedia;
-
-DROP TABLE JobMedia;
-
-CREATE TABLE JobMedia (
- JobMediaId INTEGER,
- JobId INTEGER UNSIGNED REFERENCES Job NOT NULL,
- MediaId INTEGER UNSIGNED REFERENCES Media NOT NULL,
- FirstIndex INTEGER UNSIGNED NOT NULL,
- LastIndex INTEGER UNSIGNED NOT NULL,
- StartFile INTEGER UNSIGNED DEFAULT 0,
- EndFile INTEGER UNSIGNED DEFAULT 0,
- StartBlock INTEGER UNSIGNED DEFAULT 0,
- EndBlock INTEGER UNSIGNED DEFAULT 0,
- VolIndex INTEGER UNSIGNED DEFAULT 0,
- Copy INTEGER UNSIGNED DEFAULT 0,
- Stripe INTEGER UNSIGNED DEFAULT 0,
- PRIMARY KEY(JobMediaId)
- );
-
-INSERT INTO JobMedia (
- JobMediaId, JobId, MediaId,
- FirstIndex, LastIndex, StartFile,
- EndFile, StartBlock, EndBlock,
- VolIndex, Copy, Stripe)
- SELECT * FROM JobMedia_backup;
-
-DROP TABLE JobMedia_backup;
-
-CREATE TEMPORARY TABLE Pool_backup (
- PoolId INTEGER,
- Name VARCHAR(128) NOT NULL,
- NumVols INTEGER UNSIGNED DEFAULT 0,
- MaxVols INTEGER UNSIGNED DEFAULT 0,
- UseOnce TINYINT DEFAULT 0,
- UseCatalog TINYINT DEFAULT 1,
- AcceptAnyVolume TINYINT DEFAULT 0,
- VolRetention BIGINT UNSIGNED DEFAULT 0,
- VolUseDuration BIGINT UNSIGNED DEFAULT 0,
- MaxVolJobs INTEGER UNSIGNED DEFAULT 0,
- MaxVolFiles INTEGER UNSIGNED DEFAULT 0,
- MaxVolBytes BIGINT UNSIGNED DEFAULT 0,
- AutoPrune TINYINT DEFAULT 0,
- Recycle TINYINT DEFAULT 0,
- PoolType VARCHAR(20) NOT NULL,
- LabelType TINYINT DEFAULT 0,
- LabelFormat VARCHAR(128) NOT NULL,
- Enabled TINYINT DEFAULT 1,
- ScratchPoolId INTEGER UNSIGNED REFERENCES Pool DEFAULT 0,
- RecyclePoolId INTEGER UNSIGNED REFERENCES Pool DEFAULT 0,
- NextPoolId INTEGER UNSIGNED REFERENCES Pool DEFAULT 0,
- MigrationHighBytes BIGINT UNSIGNED DEFAULT 0,
- MigrationLowBytes BIGINT UNSIGNED DEFAULT 0,
- MigrationTime BIGINT UNSIGNED DEFAULT 0,
- UNIQUE (Name),
- PRIMARY KEY (PoolId)
- );
-
-INSERT INTO Pool_backup SELECT
- PoolId, Name, NumVols, MaxVols,
- UseOnce, UseCatalog, AcceptAnyVolume,
- VolRetention, VolUseDuration, MaxVolJobs,
- MaxVolFiles, MaxVolBytes, AutoPrune,
- Recycle, PoolType, 0, LabelFormat,
- Enabled, ScratchPoolId, RecyclePoolId,
- 0, 0, 0, 0
- FROM Pool;
-
-DROP TABLE Pool;
-
-CREATE TABLE Pool (
- PoolId INTEGER,