Back to home page

Project CMSSW displayed by LXR

 
 

    


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

0001 CREATE TABLE "CMSRUNSUMMARY"
0002    (    "RUNNUM" NUMBER(10,0),
0003         "HLTKEY" VARCHAR2(128) NOT NULL ENABLE,
0004         "FILLNUM" NUMBER(10,0),
0005         "SEQUENCE" VARCHAR2(56) NOT NULL ENABLE,
0006         "STARTTIME" TIMESTAMP (6),
0007         "STOPTIME" TIMESTAMP (6),
0008         "L1KEY" VARCHAR2(128),
0009         "AMODETAG" VARCHAR2(28),
0010         "EGEV" NUMBER(10,0),
0011         "FILLSCHEME" VARCHAR2(128),
0012         "NCOLLIDINGBUNCHES" NUMBER(10,0),
0013          CONSTRAINT "CMSRUNSUMMARY_PK" PRIMARY KEY ("RUNNUM")
0014 )
0015 PARTITION BY RANGE(RUNNUM)
0016 (
0017 PARTITION THEREST VALUES LESS THAN(MAXVALUE)
0018 );
0019 GRANT SELECT ON "CMSRUNSUMMARY" TO PUBLIC;      
0020 GRANT SELECT,INSERT,DELETE,UPDATE ON "CMSRUNSUMMARY" TO CMS_LUMI_WRITER;