File indexing completed on 2024-04-06 12:26:34
0001 CREATE TABLE "REVISIONS"
0002 ("REVISION_ID" NUMBER(20,0),
0003 "BRANCH_ID" NUMBER(20,0),
0004 "NAME" VARCHAR2(56),
0005 "BRANCH_NAME" VARCHAR2(4000),
0006 "COMMENT" VARCHAR2(1024),
0007 "CTIME" TIMESTAMP (6),
0008 CONSTRAINT "REVISIONS_PK" PRIMARY KEY ("REVISION_ID")
0009 );
0010 GRANT SELECT ON "REVISIONS" TO PUBLIC;
0011 GRANT SELECT,INSERT,DELETE,UPDATE ON "REVISIONS" TO CMS_LUMI_WRITER;
0012 create index REVISIONS_BRANCH_NAME_IDX on REVISIONS(BRANCH_NAME);
