Back to home page

Project CMSSW displayed by LXR

 
 

    


File indexing completed on 2021-02-14 14:25:19

0001 CREATE TABLE "HFLUMIRESULT"
0002 (       "RUNNUM" NUMBER(10,0) NOT NULL,
0003         "LS" NUMBER(10,0) NOT NULL ,
0004         "CMSLS" NUMBER(10,0) NOT NULL ,
0005         "FILLNUM" NUMBER(10,0) NOT NULL ,
0006         "TIME" TIMESTAMP(6) NOT NULL ,
0007         "BEAM_STATUS" VARCHAR2(50) NOT NULL,
0008         "ENERGY" NUMBER(10,0) NOT NULL,
0009         "DELIVERED" BINARY_FLOAT, 
0010         "RECORDED" BINARY_FLOAT,
0011         "AVG_PU" BINARY_FLOAT,
0012         "DATA_VERSION" VARCHAR2(50) NOT NULL ,
0013         "NORM_VERSION" VARCHAR2(50) NOT NULL ,
0014         "INSERT_TIME" TIMESTAMP NOT NULL ,      
0015         CONSTRAINT "HFLUMIRESULT_PK" PRIMARY KEY ("RUNNUM","LS")
0016 )
0017 PARTITION BY RANGE(RUNNUM)
0018 (
0019 PARTITION YEAR2010 VALUES LESS THAN(153368),
0020 PARTITION YEAR2011 VALUES LESS THAN(183338),
0021 PARTITION YEAR2012 VALUES LESS THAN(209310),
0022 PARTITION THEREST VALUES LESS THAN(MAXVALUE)
0023 )
0024 ;
0025 GRANT SELECT ON "HFLUMIRESULT" TO PUBLIC;
0026 GRANT SELECT,INSERT,DELETE,UPDATE ON "HFLUMIRESULT" TO CMS_LUMI_WRITER;
0027 CREATE INDEX HFLUMIRESULT_RUNNUM_IDX ON HFLUMIRESULT(RUNNUM) LOCAL;
0028 
0029