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 67'
SET TABLE "MimeType" INDEX'15792 4'
SET TABLE "Subject" INDEX'16712 18'
SET TABLE "Category" INDEX'18064 17'
SET TABLE "Tag" INDEX'19680 28'
SET TABLE "TagDocument" INDEX'25568 22688 24688 176'
SET TABLE "TagSubject" INDEX'34608 34608 34608 3'
ALTER TABLE "Document" ALTER COLUMN "Id" RESTART WITH 67
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 176
ALTER TABLE "TagSubject" ALTER COLUMN "Id" RESTART WITH 3
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 60
