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

Subversion URL: http://proj.badc.rl.ac.uk/svn/ndg/TI01-discovery-Ingest/trunk/v4.3.0/ingestAutomation-upgrade/ingestLoggingDatabase/HiStatus.sql@7409
Revision 7409, 843 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_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');
Note: See TracBrowser for help on using the repository browser.