SET DATABASE COLLATION "Latin1_General"
CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE CACHED TABLE "Document"("Id" BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"MimeTypeId" BIGINT NOT NULL,"PublisherSubjectId" BIGINT NOT NULL,"CategoryId" BIGINT NOT NULL,"FileName" VARCHAR(255) NOT NULL,"Location" VARCHAR(500) NOT NULL,"DocumentNumber" VARCHAR(100),"Description" VARCHAR(500),"Type" INTEGER NOT NULL,"DateReceive" TIMESTAMP(0) NOT NULL,"DateScan" TIMESTAMP(0) NOT NULL,"DateCreated" TIMESTAMP(0),"ReceiverSubjectId" BIGINT NOT NULL)
CREATE CACHED TABLE "MimeType"("Id" BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"MIME" VARCHAR(255) NOT NULL,"Description" VARCHAR(500))
CREATE CACHED TABLE "Subject"("Id" BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"Name" VARCHAR(100) NOT NULL,"Description" VARCHAR(500),"Type" INTEGER NOT NULL)
CREATE CACHED TABLE "Category"("Id" BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"Name" VARCHAR(255) NOT NULL,"Description" VARCHAR(500))
CREATE CACHED TABLE "Tag"("Id" BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"Name" VARCHAR(100),"Description" VARCHAR(255) NOT NULL,"Order" INTEGER NOT NULL)
CREATE CACHED TABLE "TagDocument"("Id" BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"TagId" BIGINT NOT NULL,"DocumentId" BIGINT)
CREATE CACHED TABLE "TagSubject"("Id" BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"TagId" BIGINT NOT NULL,"SubjectId" BIGINT NOT NULL)
SET TABLE "Document" INDEX'32 2'
SET TABLE "MimeType" INDEX'312 2'
SET TABLE "Subject" INDEX'440 2'
SET TABLE "Category" INDEX'640 2'
SET TABLE "Tag" INDEX'856 4'
SET TABLE "TagSubject" INDEX'1096 3'
ALTER TABLE "Document" ALTER COLUMN "Id" RESTART WITH 2
ALTER TABLE "MimeType" ALTER COLUMN "Id" RESTART WITH 2
ALTER TABLE "Subject" ALTER COLUMN "Id" RESTART WITH 2
ALTER TABLE "Category" ALTER COLUMN "Id" RESTART WITH 2
ALTER TABLE "Tag" ALTER COLUMN "Id" RESTART WITH 4
ALTER TABLE "TagDocument" ALTER COLUMN "Id" RESTART WITH 0
ALTER TABLE "TagSubject" ALTER COLUMN "Id" RESTART WITH 3
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 60
