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

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

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

Line 
1-- Table: hi_process
2
3-- DROP TABLE hi_process;
4
5CREATE TABLE hi_process
6(
7  harvest_dir character varying,
8  status character varying(15),
9  id integer NOT NULL,
10  provider_id integer,
11  CONSTRAINT hi_process_pkey PRIMARY KEY (id),
12  CONSTRAINT hi_process_status_fkey FOREIGN KEY (status)
13      REFERENCES hi_status (id) MATCH SIMPLE
14      ON UPDATE NO ACTION ON DELETE NO ACTION
15)
16WITH (
17  OIDS=FALSE
18);
19ALTER TABLE hi_process OWNER TO badc;
Note: See TracBrowser for help on using the repository browser.