-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathschema.sql
More file actions
148 lines (106 loc) · 2.99 KB
/
Copy pathschema.sql
File metadata and controls
148 lines (106 loc) · 2.99 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
--
-- PostgreSQL database dump
--
SET client_encoding = 'SQL_ASCII';
SET check_function_bodies = false;
SET client_min_messages = warning;
--
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
--
COMMENT ON SCHEMA public IS 'Standard public schema';
SET search_path = public, pg_catalog;
SET default_tablespace = '';
SET default_with_oids = false;
--
-- Name: custom_property; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
CREATE TABLE custom_property (
id serial NOT NULL,
search_type character varying(256),
name character varying(256),
description text,
"login" character varying(256)
);
ALTER TABLE public.custom_property OWNER TO postgres;
--
-- Name: naming; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
CREATE TABLE naming (
id serial NOT NULL,
search_type character varying(100),
dir_naming text,
file_naming text
);
ALTER TABLE public.naming OWNER TO postgres;
--
-- Name: person; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
CREATE TABLE person (
id serial NOT NULL,
code character varying(256),
name_first character varying(100),
name_last character varying(100),
nationality character varying(100),
description text,
picture text,
discussion text,
approval text,
city_code character varying(256)
);
ALTER TABLE public.person OWNER TO postgres;
CREATE TABLE city (
id serial NOT NULL,
code character varying(256),
name character varying(256),
country_code character varying(256),
s_status character varying(32)
);
CREATE TABLE country (
id serial NOT NULL,
code character varying(256),
name character varying(256),
s_status character varying(32)
);
--
-- Name: prod_setting; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
CREATE TABLE prod_setting (
id serial NOT NULL,
"code" character varying(256),
"key" character varying(100),
value text,
description text,
"type" character varying(30),
search_type character varying(200)
);
ALTER TABLE public.prod_setting OWNER TO postgres;
--
-- Name: status; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
CREATE TABLE status (
id serial NOT NULL,
status text,
"timestamp" timestamp without time zone DEFAULT now(),
name character varying(128)
);
ALTER TABLE public.status OWNER TO postgres;
--
-- Name: custom_property_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--
ALTER TABLE ONLY custom_property
ADD CONSTRAINT custom_property_pkey PRIMARY KEY (id);
--
-- Name: status_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--
ALTER TABLE ONLY status
ADD CONSTRAINT status_pkey PRIMARY KEY (id);
--
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--
REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;
--
-- PostgreSQL database dump complete
--