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

Subversion URL: http://proj.badc.rl.ac.uk/svn/ndg/TI01-discovery-Ingest/trunk/v4.3.0/ingestAutomation-upgrade/ingestLoggingDatabase/HiStatus.sql@7470
Revision 7470, 1.0 KB 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_status
2
3-- DROP TABLE hi_status;
4
5CREATE TABLE hi_status
6(
7  description character varying,
8  id character varying(255) NOT NULL,
9  CONSTRAINT hi_status_name_key UNIQUE (id)
10)
11WITH (
12  OIDS=FALSE
13);
14ALTER TABLE hi_status OWNER TO badc;
15
16INSERT INTO hi_status (description, id) VALUES ('The harvesting process is starting', 'start_harv');
17INSERT INTO hi_status (description, id) VALUES ('The harvesting process is running', 'run_harv');
18INSERT INTO hi_status (description, id) VALUES ('The harvesting process is terminated', 'end_harv');
19INSERT INTO hi_status (description, id) VALUES ('The ingest process is starting', 'start_ingest');
20INSERT INTO hi_status (description, id) VALUES ('The ingest process is running', 'run_ingest');
21INSERT INTO hi_status (description, id) VALUES ('The ingest process is terminated', 'end_ingest');
22INSERT INTO hi_status (description, id) VALUES ('The Harvesting process has failed', 'failed_harv');
23INSERT INTO hi_status (description, id) VALUES ('The Ingest process has failed', 'failed_ingest');
Note: See TracBrowser for help on using the repository browser.