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),"Ext" VARCHAR(10) NOT NULL)
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,CONSTRAINT SYS_FK_69 FOREIGN KEY("TagId") REFERENCES "Tag"("Id"),CONSTRAINT SYS_FK_74 FOREIGN KEY("DocumentId") REFERENCES "Document"("Id"))
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,CONSTRAINT SYS_FK_77 FOREIGN KEY("TagId") REFERENCES "Tag"("Id"),CONSTRAINT SYS_FK_80 FOREIGN KEY("SubjectId") REFERENCES "Subject"("Id"))
ALTER TABLE "Document" ADD CONSTRAINT SYS_FK_83 FOREIGN KEY("MimeTypeId") REFERENCES "MimeType"("Id")
ALTER TABLE "Document" ADD CONSTRAINT SYS_FK_86 FOREIGN KEY("PublisherSubjectId") REFERENCES "Subject"("Id")
ALTER TABLE "Document" ADD CONSTRAINT SYS_FK_89 FOREIGN KEY("CategoryId") REFERENCES "Category"("Id")
SET TABLE "Document" INDEX'8464 8464 3320 3648 78'
SET TABLE "MimeType" INDEX'19224 5'
SET TABLE "Subject" INDEX'20216 22'
SET TABLE "Category" INDEX'21928 19'
SET TABLE "Tag" INDEX'23656 31'
SET TABLE "TagDocument" INDEX'34848 26848 33648 221'
SET TABLE "TagSubject" INDEX'42368 42368 42368 3'
ALTER TABLE "Document" ALTER COLUMN "Id" RESTART WITH 78
ALTER TABLE "MimeType" ALTER COLUMN "Id" RESTART WITH 5
ALTER TABLE "Subject" ALTER COLUMN "Id" RESTART WITH 22
ALTER TABLE "Category" ALTER COLUMN "Id" RESTART WITH 19
ALTER TABLE "Tag" ALTER COLUMN "Id" RESTART WITH 31
ALTER TABLE "TagDocument" ALTER COLUMN "Id" RESTART WITH 221
ALTER TABLE "TagSubject" ALTER COLUMN "Id" RESTART WITH 3
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 60
