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

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

New tables for the service

Line 
1--
2-- PostgreSQL database dump
3--
4
5-- Started on 2010-07-21 15:57:29 BST
6DROP TABLE HarvestType
7
8SET statement_timeout = 0;
9SET client_encoding = 'UTF8';
10SET standard_conforming_strings = off;
11SET check_function_bodies = false;
12SET client_min_messages = warning;
13SET escape_string_warning = off;
14
15SET search_path = public, pg_catalog;
16
17SET default_tablespace = '';
18
19SET default_with_oids = false;
20
21--
22-- TOC entry 2204 (class 1259 OID 1161529)
23-- Dependencies: 6
24-- Name: HarvestType; Type: TABLE; Schema: public; Owner: badc; Tablespace:
25--
26
27CREATE TABLE "HarvestType" (
28    "ID" smallint NOT NULL,
29    name character varying,
30    table_name character varying
31);
32
33
34ALTER TABLE public."HarvestType" OWNER TO badc;
35
36--
37-- TOC entry 2487 (class 0 OID 1161529)
38-- Dependencies: 2204
39-- Data for Name: HarvestType; Type: TABLE DATA; Schema: public; Owner: badc
40--
41
42INSERT INTO "HarvestType" ("ID", name, table_name) VALUES (1, 'OAI', 'OAIProvider');
43INSERT INTO "HarvestType" ("ID", name, table_name) VALUES (2, 'CSW', 'CSWProvider');
44
45
46--
47-- TOC entry 2486 (class 2606 OID 1161536)
48-- Dependencies: 2204 2204
49-- Name: harvestType_pk; Type: CONSTRAINT; Schema: public; Owner: badc; Tablespace:
50--
51
52ALTER TABLE ONLY "HarvestType"
53    ADD CONSTRAINT "harvestType_pk" PRIMARY KEY ("ID");
54
55
56-- Completed on 2010-07-21 15:57:29 BST
57
58--
59-- PostgreSQL database dump complete
60--
Note: See TracBrowser for help on using the repository browser.