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

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

Insert the tables for the Timer service and the trigger to handle how remove a provider from the the services

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_common_idkey FOREIGN KEY (common_id)
13      REFERENCES provider_common (id) MATCH SIMPLE
14      ON UPDATE NO ACTION ON DELETE CASCADE
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.