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

Subversion URL: http://proj.badc.rl.ac.uk/svn/ndg/TI01-discovery-Ingest/trunk/v4.3.0/ingestAutomation-upgrade/ingestLoggingDatabase/provider.sql@7241
Revision 7241, 1.4 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 16:22:12 BST
6
7DROP TABLE "provider";
8
9SET statement_timeout = 0;
10SET client_encoding = 'UTF8';
11SET standard_conforming_strings = off;
12SET check_function_bodies = false;
13SET client_min_messages = warning;
14SET escape_string_warning = off;
15
16SET search_path = public, pg_catalog;
17
18SET default_tablespace = '';
19
20SET default_with_oids = false;
21
22--
23-- TOC entry 2205 (class 1259 OID 1161537)
24-- Dependencies: 6
25-- Name: provider; Type: TABLE; Schema: public; Owner: badc; Tablespace:
26--
27
28CREATE TABLE provider (
29    "ID" integer NOT NULL,
30    harvest_type_id smallint
31);
32
33
34ALTER TABLE public.provider OWNER TO badc;
35
36--
37-- TOC entry 2488 (class 0 OID 1161537)
38-- Dependencies: 2205
39-- Data for Name: provider; Type: TABLE DATA; Schema: public; Owner: badc
40--
41
42INSERT INTO provider ("ID", harvest_type_id) VALUES (1, 1);
43
44
45--
46-- TOC entry 2486 (class 2606 OID 1161541)
47-- Dependencies: 2205 2205
48-- Name: provider_pk; Type: CONSTRAINT; Schema: public; Owner: badc; Tablespace:
49--
50
51ALTER TABLE ONLY provider
52    ADD CONSTRAINT provider_pk PRIMARY KEY ("ID");
53
54
55--
56-- TOC entry 2487 (class 2606 OID 1161542)
57-- Dependencies: 2205 2204
58-- Name: provider_ht_fk; Type: FK CONSTRAINT; Schema: public; Owner: badc
59--
60
61ALTER TABLE ONLY provider
62    ADD CONSTRAINT provider_ht_fk FOREIGN KEY (harvest_type_id) REFERENCES "HarvestType"("ID");
63
64
65-- Completed on 2010-07-21 16:22:12 BST
66
67--
68-- PostgreSQL database dump complete
69--
70
Note: See TracBrowser for help on using the repository browser.