CalibTracker/Configuration/test/MonitorOfflineDBs/CreateSqliteTable.sql - master - githubmirror/cmssw

CalibTracker/Configuration/test/MonitorOfflineDBs/CreateSqliteTable.sql

13 строк375 B

Giulio Eulisse

Snapshot of CMSSW_6_2_0_pre8.

26 июн 2013, 18:12

26 июн 2013, 18:12214ab73

DROP TABLE DBtags;
CREATE TABLE DBtags(
db  VARCHAR2(200) NOT NULL,
account  VARCHAR2(200) NOT NULL,
tag   VARCHAR2(200) NOT NULL,
PRIMARY KEY(db, account, tag)
);

---INSERT INTO DBtags values('A' , 'A1');
---INSERT INTO DBtags values('A' , 'A2');
---INSERT INTO DBtags values('B' , 'B1');
---INSERT INTO DBtags values('C' , 'B1');
---INSERT INTO DBtags values('A' , 'A1');