2 -- PostgreSQL database dump
5 SET client_encoding = 'UNICODE';
6 SET check_function_bodies = false;
8 SET SESSION AUTHORIZATION 'postgres';
11 -- TOC entry 4 (OID 2200)
12 -- Name: public; Type: ACL; Schema: -; Owner: postgres
15 REVOKE ALL ON SCHEMA public FROM PUBLIC;
16 REVOKE ALL ON SCHEMA public FROM postgres;
17 GRANT ALL ON SCHEMA public TO PUBLIC;
20 SET SESSION AUTHORIZATION 'rich';
22 SET search_path = public, pg_catalog;
25 -- TOC entry 5 (OID 536004)
26 -- Name: pages; Type: TABLE; Schema: public; Owner: rich
34 description text NOT NULL,
35 creation_date timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone NOT NULL,
36 last_modified_date timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone NOT NULL,
37 hostid integer NOT NULL,
45 -- TOC entry 6 (OID 536004)
46 -- Name: pages; Type: ACL; Schema: public; Owner: rich
49 REVOKE ALL ON TABLE pages FROM PUBLIC;
50 GRANT ALL ON TABLE pages TO "www-data";
54 -- TOC entry 19 (OID 536004)
55 -- Name: pages_id_seq; Type: ACL; Schema: public; Owner: rich
58 REVOKE ALL ON TABLE pages_id_seq FROM PUBLIC;
59 GRANT ALL ON TABLE pages_id_seq TO "www-data";
63 -- TOC entry 7 (OID 536021)
64 -- Name: contents; Type: TABLE; Schema: public; Owner: rich
67 CREATE TABLE contents (
69 pageid integer NOT NULL,
70 ordering integer NOT NULL,
71 sectionname text NOT NULL,
72 content text NOT NULL,
78 -- TOC entry 8 (OID 536021)
79 -- Name: contents; Type: ACL; Schema: public; Owner: rich
82 REVOKE ALL ON TABLE contents FROM PUBLIC;
83 GRANT ALL ON TABLE contents TO "www-data";
87 -- TOC entry 20 (OID 536021)
88 -- Name: contents_id_seq; Type: ACL; Schema: public; Owner: rich
91 REVOKE ALL ON TABLE contents_id_seq FROM PUBLIC;
92 GRANT ALL ON TABLE contents_id_seq TO "www-data";
96 -- TOC entry 9 (OID 536371)
97 -- Name: hosts; Type: TABLE; Schema: public; Owner: rich
102 canonical_hostname text NOT NULL,
108 -- TOC entry 10 (OID 536371)
109 -- Name: hosts; Type: ACL; Schema: public; Owner: rich
112 REVOKE ALL ON TABLE hosts FROM PUBLIC;
113 GRANT ALL ON TABLE hosts TO "www-data";
117 -- TOC entry 21 (OID 536371)
118 -- Name: hosts_id_seq; Type: ACL; Schema: public; Owner: rich
121 REVOKE ALL ON TABLE hosts_id_seq FROM PUBLIC;
122 GRANT ALL ON TABLE hosts_id_seq TO "www-data";
126 -- TOC entry 11 (OID 536379)
127 -- Name: hostnames; Type: TABLE; Schema: public; Owner: rich
130 CREATE TABLE hostnames (
131 hostid integer NOT NULL,
137 -- TOC entry 12 (OID 536379)
138 -- Name: hostnames; Type: ACL; Schema: public; Owner: rich
141 REVOKE ALL ON TABLE hostnames FROM PUBLIC;
142 GRANT ALL ON TABLE hostnames TO "www-data";
146 -- TOC entry 13 (OID 536915)
147 -- Name: email_notify; Type: TABLE; Schema: public; Owner: rich
150 CREATE TABLE email_notify (
151 hostid integer NOT NULL,
158 -- TOC entry 14 (OID 536915)
159 -- Name: email_notify; Type: ACL; Schema: public; Owner: rich
162 REVOKE ALL ON TABLE email_notify FROM PUBLIC;
163 GRANT ALL ON TABLE email_notify TO "www-data";
167 -- TOC entry 15 (OID 537151)
168 -- Name: images; Type: TABLE; Schema: public; Owner: rich
171 CREATE TABLE images (
173 hostid integer NOT NULL,
176 image bytea NOT NULL,
177 width integer NOT NULL,
178 height integer NOT NULL,
183 mime_type text NOT NULL,
188 upload_date timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone NOT NULL
193 -- TOC entry 16 (OID 537151)
194 -- Name: images; Type: ACL; Schema: public; Owner: rich
197 REVOKE ALL ON TABLE images FROM PUBLIC;
198 GRANT ALL ON TABLE images TO "www-data";
202 -- TOC entry 22 (OID 537151)
203 -- Name: images_id_seq; Type: ACL; Schema: public; Owner: rich
206 REVOKE ALL ON TABLE images_id_seq FROM PUBLIC;
207 GRANT ALL ON TABLE images_id_seq TO "www-data";
211 -- TOC entry 17 (OID 537166)
212 -- Name: files; Type: TABLE; Schema: public; Owner: rich
217 hostid integer NOT NULL,
220 content bytea NOT NULL,
222 mime_type text NOT NULL,
223 upload_date timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone NOT NULL
228 -- TOC entry 18 (OID 537166)
229 -- Name: files; Type: ACL; Schema: public; Owner: rich
232 REVOKE ALL ON TABLE files FROM PUBLIC;
233 GRANT ALL ON TABLE files TO "www-data";
237 -- TOC entry 23 (OID 537166)
238 -- Name: files_id_seq; Type: ACL; Schema: public; Owner: rich
241 REVOKE ALL ON TABLE files_id_seq FROM PUBLIC;
242 GRANT ALL ON TABLE files_id_seq TO "www-data";
246 -- TOC entry 28 (OID 536388)
247 -- Name: hostnames_hostid_name_uq; Type: INDEX; Schema: public; Owner: rich
250 CREATE UNIQUE INDEX hostnames_hostid_name_uq ON hostnames USING btree (hostid, name);
254 -- TOC entry 29 (OID 536389)
255 -- Name: hostnams_name_uq; Type: INDEX; Schema: public; Owner: rich
258 CREATE UNIQUE INDEX hostnams_name_uq ON hostnames USING btree (name);
262 -- TOC entry 25 (OID 536419)
263 -- Name: pages_url_uq; Type: INDEX; Schema: public; Owner: rich
266 CREATE UNIQUE INDEX pages_url_uq ON pages USING btree (hostid, url);
270 -- TOC entry 30 (OID 536924)
271 -- Name: email_notify_email_uq; Type: INDEX; Schema: public; Owner: rich
274 CREATE UNIQUE INDEX email_notify_email_uq ON email_notify USING btree (hostid, email);
278 -- TOC entry 31 (OID 540251)
279 -- Name: images_name_uq; Type: INDEX; Schema: public; Owner: rich
282 CREATE UNIQUE INDEX images_name_uq ON images USING btree (hostid, name);
286 -- TOC entry 33 (OID 540252)
287 -- Name: files_name_uq; Type: INDEX; Schema: public; Owner: rich
290 CREATE UNIQUE INDEX files_name_uq ON files USING btree (hostid, name);
294 -- TOC entry 24 (OID 536012)
295 -- Name: pages_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
298 ALTER TABLE ONLY pages
299 ADD CONSTRAINT pages_pkey PRIMARY KEY (id);
303 -- TOC entry 26 (OID 536027)
304 -- Name: contents_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
307 ALTER TABLE ONLY contents
308 ADD CONSTRAINT contents_pkey PRIMARY KEY (id);
312 -- TOC entry 27 (OID 536377)
313 -- Name: hosts_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
316 ALTER TABLE ONLY hosts
317 ADD CONSTRAINT hosts_pkey PRIMARY KEY (id);
321 -- TOC entry 32 (OID 537158)
322 -- Name: images_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
325 ALTER TABLE ONLY images
326 ADD CONSTRAINT images_pkey PRIMARY KEY (id);
330 -- TOC entry 34 (OID 537173)
331 -- Name: files_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
334 ALTER TABLE ONLY files
335 ADD CONSTRAINT files_pkey PRIMARY KEY (id);
339 -- TOC entry 37 (OID 536029)
340 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
343 ALTER TABLE ONLY contents
344 ADD CONSTRAINT "$1" FOREIGN KEY (pageid) REFERENCES pages(id);
348 -- TOC entry 39 (OID 536384)
349 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
352 ALTER TABLE ONLY hostnames
353 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
357 -- TOC entry 38 (OID 536394)
358 -- Name: hosts_hostname_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
361 ALTER TABLE ONLY hosts
362 ADD CONSTRAINT hosts_hostname_cn FOREIGN KEY (id, canonical_hostname) REFERENCES hostnames(hostid, name) DEFERRABLE;
366 -- TOC entry 35 (OID 536404)
367 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
370 ALTER TABLE ONLY pages
371 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
375 -- TOC entry 40 (OID 536920)
376 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
379 ALTER TABLE ONLY email_notify
380 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
384 -- TOC entry 41 (OID 537160)
385 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
388 ALTER TABLE ONLY images
389 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
393 -- TOC entry 42 (OID 537175)
394 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
397 ALTER TABLE ONLY files
398 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
402 -- TOC entry 36 (OID 539155)
403 -- Name: pages_redirect_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
406 ALTER TABLE ONLY pages
407 ADD CONSTRAINT pages_redirect_cn FOREIGN KEY (hostid, redirect) REFERENCES pages(hostid, url) DEFERRABLE;
410 SET SESSION AUTHORIZATION 'postgres';
413 -- TOC entry 3 (OID 2200)
414 -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
417 COMMENT ON SCHEMA public IS 'Standard public namespace';