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,
46 -- TOC entry 6 (OID 536004)
47 -- Name: pages; Type: ACL; Schema: public; Owner: rich
50 REVOKE ALL ON TABLE pages FROM PUBLIC;
51 GRANT ALL ON TABLE pages TO "www-data";
55 -- TOC entry 23 (OID 536004)
56 -- Name: pages_id_seq; Type: ACL; Schema: public; Owner: rich
59 REVOKE ALL ON TABLE pages_id_seq FROM PUBLIC;
60 GRANT ALL ON TABLE pages_id_seq TO "www-data";
64 -- TOC entry 7 (OID 536021)
65 -- Name: contents; Type: TABLE; Schema: public; Owner: rich
68 CREATE TABLE contents (
70 pageid integer NOT NULL,
71 ordering integer NOT NULL,
72 sectionname text NOT NULL,
73 content text NOT NULL,
79 -- TOC entry 8 (OID 536021)
80 -- Name: contents; Type: ACL; Schema: public; Owner: rich
83 REVOKE ALL ON TABLE contents FROM PUBLIC;
84 GRANT ALL ON TABLE contents TO "www-data";
88 -- TOC entry 24 (OID 536021)
89 -- Name: contents_id_seq; Type: ACL; Schema: public; Owner: rich
92 REVOKE ALL ON TABLE contents_id_seq FROM PUBLIC;
93 GRANT ALL ON TABLE contents_id_seq TO "www-data";
97 -- TOC entry 9 (OID 536371)
98 -- Name: hosts; Type: TABLE; Schema: public; Owner: rich
103 canonical_hostname text NOT NULL,
105 edit_anon boolean DEFAULT true NOT NULL,
106 create_account_anon boolean DEFAULT true NOT NULL
111 -- TOC entry 10 (OID 536371)
112 -- Name: hosts; Type: ACL; Schema: public; Owner: rich
115 REVOKE ALL ON TABLE hosts FROM PUBLIC;
116 GRANT ALL ON TABLE hosts TO "www-data";
120 -- TOC entry 25 (OID 536371)
121 -- Name: hosts_id_seq; Type: ACL; Schema: public; Owner: rich
124 REVOKE ALL ON TABLE hosts_id_seq FROM PUBLIC;
125 GRANT ALL ON TABLE hosts_id_seq TO "www-data";
129 -- TOC entry 11 (OID 536379)
130 -- Name: hostnames; Type: TABLE; Schema: public; Owner: rich
133 CREATE TABLE hostnames (
134 hostid integer NOT NULL,
140 -- TOC entry 12 (OID 536379)
141 -- Name: hostnames; Type: ACL; Schema: public; Owner: rich
144 REVOKE ALL ON TABLE hostnames FROM PUBLIC;
145 GRANT ALL ON TABLE hostnames TO "www-data";
149 -- TOC entry 13 (OID 536915)
150 -- Name: email_notify; Type: TABLE; Schema: public; Owner: rich
153 CREATE TABLE email_notify (
154 hostid integer NOT NULL,
161 -- TOC entry 14 (OID 536915)
162 -- Name: email_notify; Type: ACL; Schema: public; Owner: rich
165 REVOKE ALL ON TABLE email_notify FROM PUBLIC;
166 GRANT ALL ON TABLE email_notify TO "www-data";
170 -- TOC entry 15 (OID 537151)
171 -- Name: images; Type: TABLE; Schema: public; Owner: rich
174 CREATE TABLE images (
176 hostid integer NOT NULL,
179 image bytea NOT NULL,
180 width integer NOT NULL,
181 height integer NOT NULL,
186 mime_type text NOT NULL,
191 upload_date timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone NOT NULL
196 -- TOC entry 16 (OID 537151)
197 -- Name: images; Type: ACL; Schema: public; Owner: rich
200 REVOKE ALL ON TABLE images FROM PUBLIC;
201 GRANT ALL ON TABLE images TO "www-data";
205 -- TOC entry 26 (OID 537151)
206 -- Name: images_id_seq; Type: ACL; Schema: public; Owner: rich
209 REVOKE ALL ON TABLE images_id_seq FROM PUBLIC;
210 GRANT ALL ON TABLE images_id_seq TO "www-data";
214 -- TOC entry 17 (OID 537166)
215 -- Name: files; Type: TABLE; Schema: public; Owner: rich
220 hostid integer NOT NULL,
223 content bytea NOT NULL,
225 mime_type text NOT NULL,
226 upload_date timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone NOT NULL
231 -- TOC entry 18 (OID 537166)
232 -- Name: files; Type: ACL; Schema: public; Owner: rich
235 REVOKE ALL ON TABLE files FROM PUBLIC;
236 GRANT ALL ON TABLE files TO "www-data";
240 -- TOC entry 27 (OID 537166)
241 -- Name: files_id_seq; Type: ACL; Schema: public; Owner: rich
244 REVOKE ALL ON TABLE files_id_seq FROM PUBLIC;
245 GRANT ALL ON TABLE files_id_seq TO "www-data";
249 -- TOC entry 19 (OID 540816)
250 -- Name: users; Type: TABLE; Schema: public; Owner: rich
255 hostid integer NOT NULL,
257 "password" text NOT NULL,
259 registration_date date DEFAULT ('now'::text)::date NOT NULL,
260 can_edit boolean DEFAULT true NOT NULL,
261 can_manage_users boolean DEFAULT false NOT NULL
266 -- TOC entry 20 (OID 540816)
267 -- Name: users; Type: ACL; Schema: public; Owner: rich
270 REVOKE ALL ON TABLE users FROM PUBLIC;
271 GRANT ALL ON TABLE users TO "www-data";
275 -- TOC entry 28 (OID 540816)
276 -- Name: users_id_seq; Type: ACL; Schema: public; Owner: rich
279 REVOKE ALL ON TABLE users_id_seq FROM PUBLIC;
280 GRANT ALL ON TABLE users_id_seq TO "www-data";
284 -- TOC entry 21 (OID 540832)
285 -- Name: usercookies; Type: TABLE; Schema: public; Owner: rich
288 CREATE TABLE usercookies (
289 userid integer NOT NULL,
295 -- TOC entry 22 (OID 540832)
296 -- Name: usercookies; Type: ACL; Schema: public; Owner: rich
299 REVOKE ALL ON TABLE usercookies FROM PUBLIC;
300 GRANT ALL ON TABLE usercookies TO "www-data";
304 -- TOC entry 33 (OID 536388)
305 -- Name: hostnames_hostid_name_uq; Type: INDEX; Schema: public; Owner: rich
308 CREATE UNIQUE INDEX hostnames_hostid_name_uq ON hostnames USING btree (hostid, name);
312 -- TOC entry 34 (OID 536389)
313 -- Name: hostnams_name_uq; Type: INDEX; Schema: public; Owner: rich
316 CREATE UNIQUE INDEX hostnams_name_uq ON hostnames USING btree (name);
320 -- TOC entry 30 (OID 536419)
321 -- Name: pages_url_uq; Type: INDEX; Schema: public; Owner: rich
324 CREATE UNIQUE INDEX pages_url_uq ON pages USING btree (hostid, url);
328 -- TOC entry 35 (OID 536924)
329 -- Name: email_notify_email_uq; Type: INDEX; Schema: public; Owner: rich
332 CREATE UNIQUE INDEX email_notify_email_uq ON email_notify USING btree (hostid, email);
336 -- TOC entry 36 (OID 540251)
337 -- Name: images_name_uq; Type: INDEX; Schema: public; Owner: rich
340 CREATE UNIQUE INDEX images_name_uq ON images USING btree (hostid, name);
344 -- TOC entry 38 (OID 540252)
345 -- Name: files_name_uq; Type: INDEX; Schema: public; Owner: rich
348 CREATE UNIQUE INDEX files_name_uq ON files USING btree (hostid, name);
352 -- TOC entry 41 (OID 540831)
353 -- Name: users_name_uq; Type: INDEX; Schema: public; Owner: rich
356 CREATE UNIQUE INDEX users_name_uq ON users USING btree (hostid, name);
360 -- TOC entry 40 (OID 540946)
361 -- Name: users_id_uq; Type: INDEX; Schema: public; Owner: rich
364 CREATE UNIQUE INDEX users_id_uq ON users USING btree (hostid, id);
368 -- TOC entry 29 (OID 536012)
369 -- Name: pages_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
372 ALTER TABLE ONLY pages
373 ADD CONSTRAINT pages_pkey PRIMARY KEY (id);
377 -- TOC entry 31 (OID 536027)
378 -- Name: contents_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
381 ALTER TABLE ONLY contents
382 ADD CONSTRAINT contents_pkey PRIMARY KEY (id);
386 -- TOC entry 32 (OID 536377)
387 -- Name: hosts_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
390 ALTER TABLE ONLY hosts
391 ADD CONSTRAINT hosts_pkey PRIMARY KEY (id);
395 -- TOC entry 37 (OID 537158)
396 -- Name: images_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
399 ALTER TABLE ONLY images
400 ADD CONSTRAINT images_pkey PRIMARY KEY (id);
404 -- TOC entry 39 (OID 537173)
405 -- Name: files_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
408 ALTER TABLE ONLY files
409 ADD CONSTRAINT files_pkey PRIMARY KEY (id);
413 -- TOC entry 42 (OID 540825)
414 -- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
417 ALTER TABLE ONLY users
418 ADD CONSTRAINT users_pkey PRIMARY KEY (id);
422 -- TOC entry 47 (OID 536029)
423 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
426 ALTER TABLE ONLY contents
427 ADD CONSTRAINT "$1" FOREIGN KEY (pageid) REFERENCES pages(id);
431 -- TOC entry 49 (OID 536384)
432 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
435 ALTER TABLE ONLY hostnames
436 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
440 -- TOC entry 48 (OID 536394)
441 -- Name: hosts_hostname_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
444 ALTER TABLE ONLY hosts
445 ADD CONSTRAINT hosts_hostname_cn FOREIGN KEY (id, canonical_hostname) REFERENCES hostnames(hostid, name) DEFERRABLE;
449 -- TOC entry 43 (OID 536404)
450 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
453 ALTER TABLE ONLY pages
454 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
458 -- TOC entry 50 (OID 536920)
459 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
462 ALTER TABLE ONLY email_notify
463 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
467 -- TOC entry 51 (OID 537160)
468 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
471 ALTER TABLE ONLY images
472 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
476 -- TOC entry 52 (OID 537175)
477 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
480 ALTER TABLE ONLY files
481 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
485 -- TOC entry 44 (OID 539155)
486 -- Name: pages_redirect_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
489 ALTER TABLE ONLY pages
490 ADD CONSTRAINT pages_redirect_cn FOREIGN KEY (hostid, redirect) REFERENCES pages(hostid, url) DEFERRABLE;
494 -- TOC entry 53 (OID 540827)
495 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
498 ALTER TABLE ONLY users
499 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
503 -- TOC entry 54 (OID 540837)
504 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
507 ALTER TABLE ONLY usercookies
508 ADD CONSTRAINT "$1" FOREIGN KEY (userid) REFERENCES users(id);
512 -- TOC entry 45 (OID 540942)
513 -- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: rich
516 ALTER TABLE ONLY pages
517 ADD CONSTRAINT "$2" FOREIGN KEY (logged_user) REFERENCES users(id);
521 -- TOC entry 46 (OID 540947)
522 -- Name: pages_user_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
525 ALTER TABLE ONLY pages
526 ADD CONSTRAINT pages_user_cn FOREIGN KEY (hostid, logged_user) REFERENCES users(hostid, id);
529 SET SESSION AUTHORIZATION 'postgres';
532 -- TOC entry 3 (OID 2200)
533 -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
536 COMMENT ON SCHEMA public IS 'Standard public namespace';