LumiDB/doc/trgtables.sql

0001 /*========================TRGDATA========================*/
0002 begin execute immediate 'drop table TRGDATA';exception when others then null;end;
0003 CREATE TABLE "TRGDATA"
0004 ("DATA_ID" NUMBER(20,0),
0005 "ENTRY_ID" NUMBER(20,0),
0006 "ENTRY_NAME" VARCHAR2(56),
0007 "SOURCE" VARCHAR2(128),
0008 "RUNNUM" NUMBER(10,0),
0009 "BITZERONAME" VARCHAR2(56),
0010 "BITNAMECLOB" CLOB,
0011 "ALGOMASK_H" NUMBER(20,0),
0012 "ALGOMASK_L" NUMBER(20,0),
0013 "TECHMASK" NUMBER(20,0),
0014 CONSTRAINT "TRGDATA_PK" PRIMARY KEY ("DATA_ID")
0015 )
0016 PARTITION BY RANGE(RUNNUM)
0017 (
0018 PARTITION THEREST VALUES LESS THAN(MAXVALUE)
0019 );
0020 GRANT SELECT ON "TRGDATA" TO PUBLIC;
0021 GRANT SELECT,INSERT,DELETE,UPDATE ON "TRGDATA" TO CMS_LUMI_WRITER;
0022 /*========================TRGDATA_ID========================*/
0023 begin execute immediate 'drop table TRGDATA_ID';exception when others then null;end;
0024 CREATE TABLE "TRGDATA_ID"
0025 ("NEXTID" NUMBER(20,0),
0026 CONSTRAINT "TRGDATA_ID_PK" PRIMARY KEY ("NEXTID")
0027 );
0028 INSERT INTO "TRGDATA_ID"("NEXTID") VALUES(0);
0029 GRANT SELECT ON "TRGDATA_ID" TO PUBLIC;
0030 GRANT SELECT,INSERT,DELETE,UPDATE ON "TRGDATA_ID" TO CMS_LUMI_WRITER;
0031 /*========================TRGDATA_ENTRIES========================*/
0032 begin execute immediate 'drop table TRGDATA_ENTRIES';exception when others then null;end;
0033 CREATE TABLE "TRGDATA_ENTRIES"
0034 ("ENTRY_ID" NUMBER(20,0),
0035 "REVISION_ID" NUMBER(20,0),
0036 "NAME" VARCHAR2(56),
0037 CONSTRAINT "TRGDATA_ENTRIES_PK" PRIMARY KEY ("ENTRY_ID")
0038 )
0039 GRANT SELECT ON "TRGDATA_ENTRIES" TO PUBLIC;
0040 GRANT SELECT,INSERT,DELETE,UPDATE ON "TRGDATA_ENTRIES" TO CMS_LUMI_WRITER;
0041 /*========================TRGDATA_ENTRIES_ID========================*/
0042 begin execute immediate 'drop table TRGDATA_ENTRIES_ID';exception when others then null;end;
0043 CREATE TABLE "TRGDATA_ENTRIES_ID"
0044 ("NEXTID" NUMBER(20,0),
0045 CONSTRAINT "TRGDATA_ENTRIES_ID_PK" PRIMARY KEY ("NEXTID")
0046 );
0047 INSERT INTO "TRGDATA_ENTRIES_ID"("NEXTID") VALUES(0);
0048 GRANT SELECT ON "TRGDATA_ENTRIES_ID" TO PUBLIC;
0049 GRANT SELECT,INSERT,DELETE,UPDATE ON "TRGDATA_ENTRIES_ID" TO CMS_LUMI_WRITER;
0050 /*========================TRGDATA_REV========================*/
0051 begin execute immediate 'drop table TRGDATA_REV';exception when others then null;end;
0052 CREATE TABLE "TRGDATA_REV"
0053 ("DATA_ID" NUMBER(20,0),
0054 "REVISION_ID" NUMBER(20,0),
0055 CONSTRAINT "TRGDATA_REV_PK" PRIMARY KEY("DATA_ID","REVISION_ID")
0056 );
0057 GRANT SELECT ON "TRGDATA_REV" TO PUBLIC;
0058 GRANT SELECT,INSERT,DELETE,UPDATE ON "TRGDATA_REV" TO CMS_LUMI_WRITER;
0059
0060 /*========================LSTRG========================*/
0061 begin execute immediate 'drop table LSTRG';exception when others then null;end;
0062 CREATE TABLE ""LSTRG"
0063 ("DATA_ID" NUMBER(20,0),
0064 "RUNNUM" NUMBER(10,0),
0065 "CMSLSNUM" NUMBER(10,0),
0066 "DEADTIMECOUNT" NUMBER(20,0),
0067 "BITZEROCOUNT" NUMBER(10,0),
0068 "BITZEROPRESCALE" NUMBER(10,0),
0069 "DEADFRAC" BINARY_FLOAT,
0070 "PRESCALEBLOB" BLOB,
0071 "TRGCOUNTBLOB" BLOB,
0072  CONSTRAINT "LSTRG_PK" PRIMARY KEY ("DATA_ID","CMSLSNUM")
0073 )
0074 PARTITION BY RANGE(DATA_ID)
0075 (
0076 PARTITION THEREST VALUES LESS THAN(MAXVALUE)
0077 );
0078 GRANT SELECT ON "LSTRG" TO PUBLIC;
0079 GRANT SELECT,INSERT,DELETE,UPDATE ON "LSTRG" TO CMS_LUMI_WRITER;