EcalCondDB/sql/create_offline_core.sql

0001 -- IOV tables
0002 CREATE TABLE "IOV" ( "ID" NUMBER(10), CONSTRAINT "IOV_PK" PRIMARY KEY ( "ID" ) );
0003 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" ) );
0004
0005 -- Metadata table
0006 CREATE TABLE "METADATA" ( "NAME" VARCHAR2(4000), "TOKEN" VARCHAR2(4000) NOT NULL, CONSTRAINT "METADATA_PK" PRIMARY KEY ( "NAME" ));