source: TI01-discovery-Ingest/trunk/v4.3.0/ingestAutomation-upgrade/ingestLoggingDatabase/OAIProvider.sql @ 7241

Subversion URL: http://proj.badc.rl.ac.uk/svn/ndg/TI01-discovery-Ingest/trunk/v4.3.0/ingestAutomation-upgrade/ingestLoggingDatabase/OAIProvider.sql@7241
Revision 7241, 435 bytes checked in by mnagni, 11 years ago (diff)

New tables for the service

Line 
1-- Table: "OAIProvider"
2
3DROP TABLE "OAIProvider";
4
5CREATE TABLE "OAIProvider"
6(
7  "ID" integer NOT NULL,
8  "baseURL" character varying,
9  "set" character varying,
10  "formatID" smallint,
11  "splitBySet" boolean DEFAULT false,
12  CONSTRAINT frgn_key_format FOREIGN KEY ("formatID")
13      REFERENCES format ("ID") MATCH SIMPLE
14      ON UPDATE NO ACTION ON DELETE NO ACTION
15)
16WITH (
17  OIDS=FALSE
18);
19ALTER TABLE "OAIProvider" OWNER TO badc;
Note: See TracBrowser for help on using the repository browser.