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 23 (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 24 (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,
104 edit_anon boolean DEFAULT true NOT NULL,
105 create_account_anon boolean DEFAULT true NOT NULL
110 -- TOC entry 10 (OID 536371)
111 -- Name: hosts; Type: ACL; Schema: public; Owner: rich
114 REVOKE ALL ON TABLE hosts FROM PUBLIC;
115 GRANT ALL ON TABLE hosts TO "www-data";
119 -- TOC entry 25 (OID 536371)
120 -- Name: hosts_id_seq; Type: ACL; Schema: public; Owner: rich
123 REVOKE ALL ON TABLE hosts_id_seq FROM PUBLIC;
124 GRANT ALL ON TABLE hosts_id_seq TO "www-data";
128 -- TOC entry 11 (OID 536379)
129 -- Name: hostnames; Type: TABLE; Schema: public; Owner: rich
132 CREATE TABLE hostnames (
133 hostid integer NOT NULL,
139 -- TOC entry 12 (OID 536379)
140 -- Name: hostnames; Type: ACL; Schema: public; Owner: rich
143 REVOKE ALL ON TABLE hostnames FROM PUBLIC;
144 GRANT ALL ON TABLE hostnames TO "www-data";
148 -- TOC entry 13 (OID 536915)
149 -- Name: email_notify; Type: TABLE; Schema: public; Owner: rich
152 CREATE TABLE email_notify (
153 hostid integer NOT NULL,
160 -- TOC entry 14 (OID 536915)
161 -- Name: email_notify; Type: ACL; Schema: public; Owner: rich
164 REVOKE ALL ON TABLE email_notify FROM PUBLIC;
165 GRANT ALL ON TABLE email_notify TO "www-data";
169 -- TOC entry 15 (OID 537151)
170 -- Name: images; Type: TABLE; Schema: public; Owner: rich
173 CREATE TABLE images (
175 hostid integer NOT NULL,
178 image bytea NOT NULL,
179 width integer NOT NULL,
180 height integer NOT NULL,
185 mime_type text NOT NULL,
190 upload_date timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone NOT NULL
195 -- TOC entry 16 (OID 537151)
196 -- Name: images; Type: ACL; Schema: public; Owner: rich
199 REVOKE ALL ON TABLE images FROM PUBLIC;
200 GRANT ALL ON TABLE images TO "www-data";
204 -- TOC entry 26 (OID 537151)
205 -- Name: images_id_seq; Type: ACL; Schema: public; Owner: rich
208 REVOKE ALL ON TABLE images_id_seq FROM PUBLIC;
209 GRANT ALL ON TABLE images_id_seq TO "www-data";
213 -- TOC entry 17 (OID 537166)
214 -- Name: files; Type: TABLE; Schema: public; Owner: rich
219 hostid integer NOT NULL,
222 content bytea NOT NULL,
224 mime_type text NOT NULL,
225 upload_date timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone NOT NULL
230 -- TOC entry 18 (OID 537166)
231 -- Name: files; Type: ACL; Schema: public; Owner: rich
234 REVOKE ALL ON TABLE files FROM PUBLIC;
235 GRANT ALL ON TABLE files TO "www-data";
239 -- TOC entry 27 (OID 537166)
240 -- Name: files_id_seq; Type: ACL; Schema: public; Owner: rich
243 REVOKE ALL ON TABLE files_id_seq FROM PUBLIC;
244 GRANT ALL ON TABLE files_id_seq TO "www-data";
248 -- TOC entry 19 (OID 540816)
249 -- Name: users; Type: TABLE; Schema: public; Owner: rich
254 hostid integer NOT NULL,
256 "password" text NOT NULL,
258 registration_date date DEFAULT ('now'::text)::date NOT NULL,
259 can_edit boolean DEFAULT true NOT NULL,
260 can_manage_users boolean DEFAULT false NOT NULL
265 -- TOC entry 20 (OID 540816)
266 -- Name: users; Type: ACL; Schema: public; Owner: rich
269 REVOKE ALL ON TABLE users FROM PUBLIC;
270 GRANT ALL ON TABLE users TO "www-data";
274 -- TOC entry 28 (OID 540816)
275 -- Name: users_id_seq; Type: ACL; Schema: public; Owner: rich
278 REVOKE ALL ON TABLE users_id_seq FROM PUBLIC;
279 GRANT ALL ON TABLE users_id_seq TO "www-data";
283 -- TOC entry 21 (OID 540832)
284 -- Name: usercookies; Type: TABLE; Schema: public; Owner: rich
287 CREATE TABLE usercookies (
288 userid integer NOT NULL,
294 -- TOC entry 22 (OID 540832)
295 -- Name: usercookies; Type: ACL; Schema: public; Owner: rich
298 REVOKE ALL ON TABLE usercookies FROM PUBLIC;
299 GRANT ALL ON TABLE usercookies TO "www-data";
303 -- TOC entry 33 (OID 536388)
304 -- Name: hostnames_hostid_name_uq; Type: INDEX; Schema: public; Owner: rich
307 CREATE UNIQUE INDEX hostnames_hostid_name_uq ON hostnames USING btree (hostid, name);
311 -- TOC entry 34 (OID 536389)
312 -- Name: hostnams_name_uq; Type: INDEX; Schema: public; Owner: rich
315 CREATE UNIQUE INDEX hostnams_name_uq ON hostnames USING btree (name);
319 -- TOC entry 30 (OID 536419)
320 -- Name: pages_url_uq; Type: INDEX; Schema: public; Owner: rich
323 CREATE UNIQUE INDEX pages_url_uq ON pages USING btree (hostid, url);
327 -- TOC entry 35 (OID 536924)
328 -- Name: email_notify_email_uq; Type: INDEX; Schema: public; Owner: rich
331 CREATE UNIQUE INDEX email_notify_email_uq ON email_notify USING btree (hostid, email);
335 -- TOC entry 36 (OID 540251)
336 -- Name: images_name_uq; Type: INDEX; Schema: public; Owner: rich
339 CREATE UNIQUE INDEX images_name_uq ON images USING btree (hostid, name);
343 -- TOC entry 38 (OID 540252)
344 -- Name: files_name_uq; Type: INDEX; Schema: public; Owner: rich
347 CREATE UNIQUE INDEX files_name_uq ON files USING btree (hostid, name);
351 -- TOC entry 40 (OID 540831)
352 -- Name: users_name_uq; Type: INDEX; Schema: public; Owner: rich
355 CREATE UNIQUE INDEX users_name_uq ON users USING btree (hostid, name);
359 -- TOC entry 29 (OID 536012)
360 -- Name: pages_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
363 ALTER TABLE ONLY pages
364 ADD CONSTRAINT pages_pkey PRIMARY KEY (id);
368 -- TOC entry 31 (OID 536027)
369 -- Name: contents_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
372 ALTER TABLE ONLY contents
373 ADD CONSTRAINT contents_pkey PRIMARY KEY (id);
377 -- TOC entry 32 (OID 536377)
378 -- Name: hosts_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
381 ALTER TABLE ONLY hosts
382 ADD CONSTRAINT hosts_pkey PRIMARY KEY (id);
386 -- TOC entry 37 (OID 537158)
387 -- Name: images_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
390 ALTER TABLE ONLY images
391 ADD CONSTRAINT images_pkey PRIMARY KEY (id);
395 -- TOC entry 39 (OID 537173)
396 -- Name: files_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
399 ALTER TABLE ONLY files
400 ADD CONSTRAINT files_pkey PRIMARY KEY (id);
404 -- TOC entry 41 (OID 540825)
405 -- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
408 ALTER TABLE ONLY users
409 ADD CONSTRAINT users_pkey PRIMARY KEY (id);
413 -- TOC entry 44 (OID 536029)
414 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
417 ALTER TABLE ONLY contents
418 ADD CONSTRAINT "$1" FOREIGN KEY (pageid) REFERENCES pages(id);
422 -- TOC entry 46 (OID 536384)
423 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
426 ALTER TABLE ONLY hostnames
427 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
431 -- TOC entry 45 (OID 536394)
432 -- Name: hosts_hostname_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
435 ALTER TABLE ONLY hosts
436 ADD CONSTRAINT hosts_hostname_cn FOREIGN KEY (id, canonical_hostname) REFERENCES hostnames(hostid, name) DEFERRABLE;
440 -- TOC entry 42 (OID 536404)
441 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
444 ALTER TABLE ONLY pages
445 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
449 -- TOC entry 47 (OID 536920)
450 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
453 ALTER TABLE ONLY email_notify
454 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
458 -- TOC entry 48 (OID 537160)
459 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
462 ALTER TABLE ONLY images
463 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
467 -- TOC entry 49 (OID 537175)
468 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
471 ALTER TABLE ONLY files
472 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
476 -- TOC entry 43 (OID 539155)
477 -- Name: pages_redirect_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
480 ALTER TABLE ONLY pages
481 ADD CONSTRAINT pages_redirect_cn FOREIGN KEY (hostid, redirect) REFERENCES pages(hostid, url) DEFERRABLE;
485 -- TOC entry 50 (OID 540827)
486 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
489 ALTER TABLE ONLY users
490 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
494 -- TOC entry 51 (OID 540837)
495 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
498 ALTER TABLE ONLY usercookies
499 ADD CONSTRAINT "$1" FOREIGN KEY (userid) REFERENCES users(id);
502 SET SESSION AUTHORIZATION 'postgres';
505 -- TOC entry 3 (OID 2200)
506 -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
509 COMMENT ON SCHEMA public IS 'Standard public namespace';