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,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'2112 2112 2112 2112 26'
SET TABLE "MimeType" INDEX'5568 3'
SET TABLE "Subject" INDEX'5992 10'
SET TABLE "Category" INDEX'6792 10'
SET TABLE "Tag" INDEX'7736 16'
SET TABLE "TagDocument" INDEX'9480 9880 9960 47'
SET TABLE "TagSubject" INDEX'12120 12120 12120 3'
ALTER TABLE "Document" ALTER COLUMN "Id" RESTART WITH 26
ALTER TABLE "MimeType" ALTER COLUMN "Id" RESTART WITH 3
ALTER TABLE "Subject" ALTER COLUMN "Id" RESTART WITH 10
ALTER TABLE "Category" ALTER COLUMN "Id" RESTART WITH 10
ALTER TABLE "Tag" ALTER COLUMN "Id" RESTART WITH 16
ALTER TABLE "TagDocument" ALTER COLUMN "Id" RESTART WITH 47
ALTER TABLE "TagSubject" ALTER COLUMN "Id" RESTART WITH 3
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 60
