Back to home page

Project CMSSW displayed by LXR

 
 

    


File indexing completed on 2021-02-14 13:31:55

0001 -- Create payload object tables generated from EcalPedestals-mapping-custom.xml
0002 CREATE TABLE CMS_ECAL."ECALPEDESTALS" ( "IOV_VALUE_ID" NUMBER(10), CONSTRAINT "ECALPEDESTALS_PK" PRIMARY KEY ( "IOV_VALUE_ID" ) );
0003 CREATE TABLE CMS_ECAL."ECALPEDESTALS_ITEM" ( "POS" NUMBER(10) NOT NULL, "IOV_VALUE_ID" NUMBER(10) NOT NULL, "MEAN_X1" BINARY_FLOAT NOT NULL, "MEAN_X12" BINARY_FLOAT NOT NULL, "MEAN_X6" BINARY_FLOAT NOT NULL, "RMS_X1" BINARY_FLOAT NOT NULL, "RMS_X12" BINARY_FLOAT NOT NULL, "RMS_X6" BINARY_FLOAT NOT NULL, "DET_ID" NUMBER(10) NOT NULL, CONSTRAINT "ECALPEDESTALS_ITEM_PK" PRIMARY KEY ( "IOV_VALUE_ID","POS" ), CONSTRAINT "ECALPEDESTALS_ITEM_ID_FK" FOREIGN KEY ( "IOV_VALUE_ID" ) REFERENCES CMS_ECAL."ECALPEDESTALS" ( "IOV_VALUE_ID" ) );
0004 
0005 -- Add TIME column for IOV
0006 ALTER TABLE CMS_ECAL."ECALPEDESTALS" ADD "TIME" NUMBER(10);