CREATE INDEX inx8 ON Media (PoolId);
CREATE TABLE MediaType (
- MediaTypeId INTERGER,
+ MediaTypeId INTEGER,
MediaType VARCHAR(128) NOT NULL,
ReadOnly TINYINT DEFAULT 0,
PRIMARY KEY(MediaTypeId)
);
+CREATE TABLE Storage (
+ StorageId INTEGER,
+ Name VARCHAR(128) NOT NULL,
+ AutoChanger TINYINT DEFAULT 0,
+ PRIMARY KEY(StorageId)
+ );
+
CREATE TABLE Device (
DeviceId INTEGER,
Name VARCHAR(128) NOT NULL,
PRIMARY KEY(DeviceId)
);
-CREATE TABLE Storage (
- StorageId INTEGER,
- Name VARCHAR(128) NOT NULL,
- AutoChanger TINYINT DEFAULT 0,
- PRIMARY KEY(StorageId)
- );
-
CREATE TABLE Pool (
PoolId INTEGER,