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

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

new field in HiProcess? to log the process progression status.
Add two new status: failed_harv, failed_ingest

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  info character varying,
12  CONSTRAINT hi_process_pkey PRIMARY KEY (id),
13  CONSTRAINT hi_process_status_fkey FOREIGN KEY (status)
14      REFERENCES hi_status (id) MATCH SIMPLE
15      ON UPDATE NO ACTION ON DELETE NO ACTION
16)
17WITH (
18  OIDS=FALSE
19);
20ALTER TABLE hi_process OWNER TO badc;
Note: See TracBrowser for help on using the repository browser.