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

CondTools/DT/test/CondIOV.sql

3 строки363 B

Giulio Eulisse

Snapshot of CMSSW_6_2_0_pre8.

26 июн 2013, 18:12

26 июн 2013, 18:12214ab73

CREATE TABLE "IOV" ( "ID" NUMBER(10), CONSTRAINT "IOV_PK" PRIMARY KEY ( "ID" ) );

CREATE TABLE "IOV_DATA" ( "POS" NUMBER(10) NOT NULL, "ID" NUMBER(10) NOT NULL, "IOV_TOKEN" VARCHAR2(4000) NOT NULL, "IOV_TIME" NUMBER(10) NOT NULL, CONSTRAINT "IOV_DATA_PK" PRIMARY KEY ( "ID","POS" ), CONSTRAINT "IOV_DATA_ID_FK" FOREIGN KEY ( "ID" ) REFERENCES "IOV" ( "ID" ) );