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 4168 3320 2720 29'
SET TABLE "MimeType" INDEX'6600 3'
SET TABLE "Subject" INDEX'7400 13'
SET TABLE "Category" INDEX'8360 12'
SET TABLE "Tag" INDEX'9200 21'
SET TABLE "TagDocument" INDEX'12544 11664 11744 59'
SET TABLE "TagSubject" INDEX'14864 14864 14864 3'
ALTER TABLE "Document" ALTER COLUMN "Id" RESTART WITH 29
ALTER TABLE "MimeType" ALTER COLUMN "Id" RESTART WITH 3
ALTER TABLE "Subject" ALTER COLUMN "Id" RESTART WITH 13
ALTER TABLE "Category" ALTER COLUMN "Id" RESTART WITH 12
ALTER TABLE "Tag" ALTER COLUMN "Id" RESTART WITH 21
ALTER TABLE "TagDocument" ALTER COLUMN "Id" RESTART WITH 59
ALTER TABLE "TagSubject" ALTER COLUMN "Id" RESTART WITH 3
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 60
