-CREATE TABLE LocationLog (
- LocLogId SERIAL NOT NULL,
- Date timestamp without time zone,
- Comment TEXT NOT NULL,
- MediaId INTEGER DEFAULT 0,
- LocationId INTEGER DEFAULT 0,
- newvolstatus text not null
- check (newvolstatus in ('Full','Archive','Append',
- 'Recycle','Purged','Read-Only','Disabled',
- 'Error','Busy','Used','Cleaning','Scratch')),
- newenabled smallint,
- PRIMARY KEY(LocLogId)
-);
-
-
-CREATE TABLE Log
-(
- LogId serial not null,
- JobId integer not null,
- Time timestamp without time zone,
- LogText text not null,
- primary key (LogId)
-);
-create index log_name_idx on Log (JobId);
-
-
-DELETE FROM version;
-INSERT INTO version (versionId) VALUES (10);
-
-vacuum;
+-- If you have already this table, you can remove it with:
+-- DROP TABLE JobHistory;