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 71'
SET TABLE "MimeType" INDEX'17176 4'
SET TABLE "Subject" INDEX'18096 18'
SET TABLE "Category" INDEX'19448 17'
SET TABLE "Tag" INDEX'21064 28'
SET TABLE "TagDocument" INDEX'32072 24072 30872 195'
SET TABLE "TagSubject" INDEX'37512 37512 37512 3'
ALTER TABLE "Document" ALTER COLUMN "Id" RESTART WITH 71
ALTER TABLE "MimeType" ALTER COLUMN "Id" RESTART WITH 4
ALTER TABLE "Subject" ALTER COLUMN "Id" RESTART WITH 18
ALTER TABLE "Category" ALTER COLUMN "Id" RESTART WITH 17
ALTER TABLE "Tag" ALTER COLUMN "Id" RESTART WITH 28
ALTER TABLE "TagDocument" ALTER COLUMN "Id" RESTART WITH 195
ALTER TABLE "TagSubject" ALTER COLUMN "Id" RESTART WITH 3
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 60
