LumiDB/doc/hlttables.sql

0001 /*========================HLTDATA========================*/
0002 begin execute immediate 'drop table HLTDATA';exception when others then null;end;
0003 CREATE TABLE "HLTDATA"
0004 ("DATA_ID" NUMBER(20,0),
0005 "ENTRY_ID" NUMBER(20,0),
0006 "ENTRY_NAME" VARCHAR2(56),
0007 "RUNNUM" NUMBER(10,0),
0008 "SOURCE" VARCHAR2(128),
0009 "NPATH" NUMBER(10,0),
0010 "PATHNAMECLOB" CLOB,
0011  CONSTRAINT "HLTDATA_PK" PRIMARY KEY ("DATA_ID")
0012 )
0013 PARTITION BY RANGE(RUNNUM)
0014 (
0015 PARTITION THEREST VALUES LESS THAN(MAXVALUE)
0016 );
0017 GRANT SELECT ON "HLTDATA" TO PUBLIC;
0018 GRANT SELECT,INSERT,DELETE,UPDATE ON "HLTDATA" TO CMS_LUMI_WRITER;
0019 /*========================HLTDATA_ID========================*/
0020 begin execute immediate 'drop table HLTDATA_ID';exception when others then null;end;
0021 CREATE TABLE "HLTDATA_ID"
0022 ("NEXTID" NUMBER(20,0),
0023 CONSTRAINT "HLTDATA_ID_PK" PRIMARY KEY ("NEXTID")
0024 );
0025 INSERT INTO "HLTDATA_ID"("NEXTID") VALUES(0);
0026 GRANT SELECT ON "HLTDATA_ID" TO PUBLIC;
0027 GRANT SELECT,INSERT,DELETE,UPDATE ON "HLTDATA_ID" TO CMS_LUMI_WRITER;
0028 /*========================HLTDATA_ENTRIES========================*/
0029 begin execute immediate 'drop table HLTDATA_ENTRIES';exception when others then null;end;
0030 CREATE TABLE "HLTDATA_ENTRIES"
0031 ("ENTRY_ID" NUMBER(20,0),
0032 "REVISION_ID" NUMBER(20,0),
0033 "NAME" VARCHAR2(56),
0034 CONSTRAINT "HLTDATA_ENTRIES_PK" PRIMARY KEY ("ENTRY_ID")
0035 )
0036 GRANT SELECT ON "HLTDATA_ENTRIES" TO PUBLIC;
0037 GRANT SELECT,INSERT,DELETE,UPDATE ON "HLTDATA_ENTRIES" TO CMS_LUMI_WRITER;
0038 /*========================HLTDATA_ENTRIES_ID========================*/
0039 begin execute immediate 'drop table HLTDATA_ENTRIES_ID';exception when others then null;end;
0040 CREATE TABLE "HLTDATA_ENTRIES_ID"
0041 ("NEXTID" NUMBER(20,0),
0042 CONSTRAINT "HLTDATA_ENTRIES_ID_PK" PRIMARY KEY ("NEXTID")
0043 );
0044 INSERT INTO "HLTDATA_ENTRIES_ID"("NEXTID") VALUES(0);
0045 GRANT SELECT ON "HLTDATA_ENTRIES_ID" TO PUBLIC;
0046 GRANT SELECT,INSERT,DELETE,UPDATE ON "HLTDATA_ENTRIES_ID" TO CMS_LUMI_WRITER;
0047 /*========================HLTDATA_REV========================*/
0048 begin execute immediate 'drop table HLTDATA_REV';exception when others then null;end;
0049 CREATE TABLE "HLTDATA_REV"
0050 ("DATA_ID" NUMBER(20,0),
0051 "REVISION_ID" NUMBER(20,0),
0052 CONSTRAINT "HLTDATA_REV_PK" PRIMARY KEY("DATA_ID","REVISION_ID")
0053 );
0054 GRANT SELECT ON "HLTDATA_REV" TO PUBLIC;
0055 GRANT SELECT,INSERT,DELETE,UPDATE ON "HLTDATA_REV" TO CMS_LUMI_WRITER;
0056 /*========================LSHLT========================*/
0057 begin execute immediate 'drop table LSHLT';exception when others then null;end;
0058 CREATE TABLE "LSHLT"
0059 ("DATA_ID" NUMBER(20,0),
0060 "RUNNUM" NUMBER(10,0),
0061 "CMSLSNUM" NUMBER(10,0),
0062 "PRESCALEBLOB" BLOB,
0063 "HLTCOUNTBLOB" BLOB,
0064 "HLTACCEPTBLOB" BLOB,
0065 CONSTRAINT "LSHLT_PK" PRIMARY KEY ("DATA_ID","CMSLSNUM")
0066 )
0067 PARTITION BY RANGE(DATA_ID)
0068 (
0069 PARTITION THEREST VALUES LESS THAN(MAXVALUE)
0070 );
0071 GRANT SELECT ON "HLTDATA" TO PUBLIC;
0072 GRANT SELECT,INSERT,DELETE,UPDATE ON "HLTDATA" TO CMS_LUMI_WRITER;