root/wifidogadmin/sql/wifidog-postgres-initial-data.sql

Revision 479, 8.6 kB (checked in by insultant, 8 months ago)

--

Line 
1 BEGIN;
2 --
3 -- PostgreSQL database dump
4 --
5
6 SET client_encoding = 'UTF8';
7 SET standard_conforming_strings = off;
8 SET check_function_bodies = false;
9 SET client_min_messages = warning;
10 SET escape_string_warning = off;
11
12 SET search_path = public, pg_catalog;
13
14 --
15 -- Data for Name: token_status; Type: TABLE DATA; Schema: public; Owner: wifidog
16 --
17
18 INSERT INTO token_status (token_status) VALUES ('UNUSED');
19 INSERT INTO token_status (token_status) VALUES ('INUSE');
20 INSERT INTO token_status (token_status) VALUES ('USED');
21
22
23 --
24 -- PostgreSQL database dump complete
25 --
26
27 --
28 -- PostgreSQL database dump
29 --
30
31 SET client_encoding = 'UTF8';
32 SET standard_conforming_strings = off;
33 SET check_function_bodies = false;
34 SET client_min_messages = warning;
35 SET escape_string_warning = off;
36
37 SET search_path = public, pg_catalog;
38
39 --
40 -- Data for Name: venue_types; Type: TABLE DATA; Schema: public; Owner: wifidog
41 --
42
43 INSERT INTO venue_types (venue_type) VALUES ('Airline');
44 INSERT INTO venue_types (venue_type) VALUES ('Airport Terminal/Lounge');
45 INSERT INTO venue_types (venue_type) VALUES ('Bus Station');
46 INSERT INTO venue_types (venue_type) VALUES ('Business/Conference Center');
47 INSERT INTO venue_types (venue_type) VALUES ('Cafe/Coffee Shop');
48 INSERT INTO venue_types (venue_type) VALUES ('Camp Ground');
49 INSERT INTO venue_types (venue_type) VALUES ('Community Network');
50 INSERT INTO venue_types (venue_type) VALUES ('Convention Center');
51 INSERT INTO venue_types (venue_type) VALUES ('Cruise Ship');
52 INSERT INTO venue_types (venue_type) VALUES ('Copy Center/Business Services');
53 INSERT INTO venue_types (venue_type) VALUES ('Entertainment Venues');
54 INSERT INTO venue_types (venue_type) VALUES ('Gas/Petrol Station');
55 INSERT INTO venue_types (venue_type) VALUES ('Hospital');
56 INSERT INTO venue_types (venue_type) VALUES ('Hotel');
57 INSERT INTO venue_types (venue_type) VALUES ('Internet Cafe');
58 INSERT INTO venue_types (venue_type) VALUES ('Kiosk');
59 INSERT INTO venue_types (venue_type) VALUES ('Library');
60 INSERT INTO venue_types (venue_type) VALUES ('Marina/Harbour');
61 INSERT INTO venue_types (venue_type) VALUES ('Motorway Travel Center/TruckStop');
62 INSERT INTO venue_types (venue_type) VALUES ('Office Building/Complex');
63 INSERT INTO venue_types (venue_type) VALUES ('Other');
64 INSERT INTO venue_types (venue_type) VALUES ('Park');
65 INSERT INTO venue_types (venue_type) VALUES ('Pay Phone/Booth');
66 INSERT INTO venue_types (venue_type) VALUES ('Port/Ferry Terminal');
67 INSERT INTO venue_types (venue_type) VALUES ('Residential Housing/Apt Bldg');
68 INSERT INTO venue_types (venue_type) VALUES ('Restaurant/Bar/Pub');
69 INSERT INTO venue_types (venue_type) VALUES ('School/University');
70 INSERT INTO venue_types (venue_type) VALUES ('Shopping Center');
71 INSERT INTO venue_types (venue_type) VALUES ('Sports Arena/Venue');
72 INSERT INTO venue_types (venue_type) VALUES ('Store/Retail Shop');
73 INSERT INTO venue_types (venue_type) VALUES ('Train');
74 INSERT INTO venue_types (venue_type) VALUES ('Train/Rail Station');
75 INSERT INTO venue_types (venue_type) VALUES ('Water Travel');
76 INSERT INTO venue_types (venue_type) VALUES ('Wi-Fi Zone');
77
78
79 --
80 -- PostgreSQL database dump complete
81 --
82
83 --
84 -- PostgreSQL database dump
85 --
86
87 SET client_encoding = 'UTF8';
88 SET standard_conforming_strings = off;
89 SET check_function_bodies = false;
90 SET client_min_messages = warning;
91 SET escape_string_warning = off;
92
93 SET search_path = public, pg_catalog;
94
95 --
96 -- Data for Name: node_deployment_status; Type: TABLE DATA; Schema: public; Owner: wifidog
97 --
98
99 INSERT INTO node_deployment_status (node_deployment_status) VALUES ('DEPLOYED');
100 INSERT INTO node_deployment_status (node_deployment_status) VALUES ('IN_PLANNING');
101 INSERT INTO node_deployment_status (node_deployment_status) VALUES ('IN_TESTING');
102 INSERT INTO node_deployment_status (node_deployment_status) VALUES ('NON_WIFIDOG_NODE');
103 INSERT INTO node_deployment_status (node_deployment_status) VALUES ('PERMANENTLY_CLOSED');
104 INSERT INTO node_deployment_status (node_deployment_status) VALUES ('TEMPORARILY_CLOSED');
105
106
107 --
108 -- PostgreSQL database dump complete
109 --
110
111 --
112 -- PostgreSQL database dump
113 --
114
115 SET client_encoding = 'UTF8';
116 SET standard_conforming_strings = off;
117 SET check_function_bodies = false;
118 SET client_min_messages = warning;
119 SET escape_string_warning = off;
120
121 SET search_path = public, pg_catalog;
122
123 --
124 -- Data for Name: content_available_display_areas; Type: TABLE DATA; Schema: public; Owner: wifidog
125 --
126
127 INSERT INTO content_available_display_areas (display_area) VALUES ('page_header');
128 INSERT INTO content_available_display_areas (display_area) VALUES ('page_footer');
129 INSERT INTO content_available_display_areas (display_area) VALUES ('left_area_middle');
130 INSERT INTO content_available_display_areas (display_area) VALUES ('left_area_bottom');
131 INSERT INTO content_available_display_areas (display_area) VALUES ('main_area_top');
132 INSERT INTO content_available_display_areas (display_area) VALUES ('main_area_middle');
133 INSERT INTO content_available_display_areas (display_area) VALUES ('main_area_bottom');
134 INSERT INTO content_available_display_areas (display_area) VALUES ('right_area_top');
135 INSERT INTO content_available_display_areas (display_area) VALUES ('right_area_middle');
136 INSERT INTO content_available_display_areas (display_area) VALUES ('right_area_bottom');
137 INSERT INTO content_available_display_areas (display_area) VALUES ('left_area_top');
138
139
140 --
141 -- PostgreSQL database dump complete
142 --
143
144 --
145 -- PostgreSQL database dump
146 --
147
148 SET client_encoding = 'UTF8';
149 SET standard_conforming_strings = off;
150 SET check_function_bodies = false;
151 SET client_min_messages = warning;
152 SET escape_string_warning = off;
153
154 SET search_path = public, pg_catalog;
155
156 --
157 -- Data for Name: content_available_display_pages; Type: TABLE DATA; Schema: public; Owner: wifidog
158 --
159
160 INSERT INTO content_available_display_pages (display_page) VALUES ('login');
161 INSERT INTO content_available_display_pages (display_page) VALUES ('portal');
162 INSERT INTO content_available_display_pages (display_page) VALUES ('everywhere');
163
164
165 --
166 -- PostgreSQL database dump complete
167 --
168
169 --
170 -- PostgreSQL database dump
171 --
172
173 SET client_encoding = 'UTF8';
174 SET standard_conforming_strings = off;
175 SET check_function_bodies = false;
176 SET client_min_messages = warning;
177 SET escape_string_warning = off;
178
179 SET search_path = public, pg_catalog;
180
181 --
182 -- Data for Name: stakeholder_types; Type: TABLE DATA; Schema: public; Owner: wifidog
183 --
184
185 INSERT INTO stakeholder_types (stakeholder_type_id) VALUES ('Node');
186 INSERT INTO stakeholder_types (stakeholder_type_id) VALUES ('Network');
187 INSERT INTO stakeholder_types (stakeholder_type_id) VALUES ('Server');
188 INSERT INTO stakeholder_types (stakeholder_type_id) VALUES ('Content');
189
190
191 --
192 -- PostgreSQL database dump complete
193 --
194
195 INSERT INTO networks (network_id, network_authenticator_class, network_authenticator_params) VALUES ('default-network', 'AuthenticatorLocalUser', '\'default-network\'');
196 INSERT INTO nodes (network_id, node_id, gw_id, name) VALUES ('default-network', 'default', 'default', 'My first node');
197 INSERT INTO virtual_hosts (virtual_host_id, hostname, default_network) VALUES ('DEFAULT_VHOST', 'localhost', 'default-network');
198 INSERT INTO server (server_id, default_virtual_host) VALUES ('SERVER_ID', 'DEFAULT_VHOST');
199 INSERT into roles (role_id, stakeholder_type_id) VALUES ('SERVER_SYSADMIN', 'Server');
200 INSERT into roles (role_id, stakeholder_type_id) VALUES ('NETWORK_SYSADMIN', 'Network');
201 --
202 -- PostgreSQL database dump
203 --
204
205 SET client_encoding = 'UTF8';
206 SET standard_conforming_strings = off;
207 SET check_function_bodies = false;
208 SET client_min_messages = warning;
209 SET escape_string_warning = off;
210
211 SET search_path = public, pg_catalog;
212
213 --
214 -- Data for Name: schema_info; Type: TABLE DATA; Schema: public; Owner: wifidog
215 --
216
217 INSERT INTO schema_info (tag, value) VALUES ('schema_version', '56');
218
219
220 --
221 -- PostgreSQL database dump complete
222 --
223
224 --
225 -- PostgreSQL database dump
226 --
227
228 SET client_encoding = 'UTF8';
229 SET standard_conforming_strings = off;
230 SET check_function_bodies = false;
231 SET client_min_messages = warning;
232 SET escape_string_warning = off;
233
234 SET search_path = public, pg_catalog;
235
236 --
237 -- Data for Name: locales; Type: TABLE DATA; Schema: public; Owner: wifidog
238 --
239
240 INSERT INTO locales (locales_id) VALUES ('fr');
241 INSERT INTO locales (locales_id) VALUES ('en');
242 INSERT INTO locales (locales_id) VALUES ('de');
243 INSERT INTO locales (locales_id) VALUES ('pt');
244 INSERT INTO locales (locales_id) VALUES ('ja');
245 INSERT INTO locales (locales_id) VALUES ('es');
246
247
248 --
249 -- PostgreSQL database dump complete
250 --
251
252 COMMIT;
Note: See TracBrowser for help on using the browser.