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

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

Update of the tables underlying the DPWS's BETA-0.0.1 version

Line 
1-- Table: oai_provider
2
3-- DROP TABLE oai_provider;
4
5CREATE TABLE oai_provider
6(
7  "set" character varying,
8  split_by_set boolean DEFAULT false,
9  format character varying,
10  common_id integer NOT NULL DEFAULT -1,
11  CONSTRAINT oai_provider_pkey PRIMARY KEY (common_id),
12  CONSTRAINT oai_provider_common_id_fkey FOREIGN KEY (common_id)
13      REFERENCES provider_common (id) MATCH SIMPLE
14      ON UPDATE NO ACTION ON DELETE NO ACTION
15)
16WITH (
17  OIDS=FALSE
18);
19ALTER TABLE oai_provider OWNER TO badc;
20
21INSERT INTO oai_provider (set, split_by_set, format, common_id) VALUES (NULL, true, 'dif', -1);
Note: See TracBrowser for help on using the repository browser.