CondTools/DT/test/DT-payload.sql - master - githubmirror/cmssw

CondTools/DT/test/DT-payload.sql

5 строк907 B

Giulio Eulisse

Snapshot of CMSSW_6_2_0_pre8.

26 июн 2013, 18:12

26 июн 2013, 18:12214ab73

CREATE TABLE "DTREADOUTMAPPING" ( "IOV_VALUE_ID" NUMBER(10), "CELL_MAP_VERSION" VARCHAR2(4000) NOT NULL, "ROB_MAP_VERSION" VARCHAR2(4000) NOT NULL, CONSTRAINT "DTREADOUTMAPPING_PK" PRIMARY KEY ( "IOV_VALUE_ID" ) );

CREATE TABLE "DTREADOUTCONNECTION" ( "CONNECTION_ID" NUMBER(10) NOT NULL, "IOV_VALUE_ID" NUMBER(10) NOT NULL, "CELL" NUMBER(10) NOT NULL, "CHANNEL" NUMBER(10) NOT NULL, "DDU" NUMBER(10) NOT NULL, "LAYER" NUMBER(10) NOT NULL, "ROB" NUMBER(10) NOT NULL, "ROS" NUMBER(10) NOT NULL, "SECTOR" NUMBER(10) NOT NULL, "SUPERLAYER" NUMBER(10) NOT NULL, "STATION" NUMBER(10) NOT NULL, "TDC" NUMBER(10) NOT NULL, "WHEEL" NUMBER(10) NOT NULL, CONSTRAINT "DTREADOUTCONNECTION_PK" PRIMARY KEY ( "IOV_VALUE_ID","CONNECTION_ID" ), CONSTRAINT "DTREADOUTCONNECTION_ID_FK" FOREIGN KEY ( "IOV_VALUE_ID" ) REFERENCES "DTREADOUTMAPPING" ( "IOV_VALUE_ID" ) );

ALTER TABLE "DTREADOUTMAPPING" ADD "TIME" NUMBER(10);