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
109 -- TOC entry 10 (OID 536371)
110 -- Name: hosts; Type: ACL; Schema: public; Owner: rich
113 REVOKE ALL ON TABLE hosts FROM PUBLIC;
114 GRANT ALL ON TABLE hosts TO "www-data";
118 -- TOC entry 25 (OID 536371)
119 -- Name: hosts_id_seq; Type: ACL; Schema: public; Owner: rich
122 REVOKE ALL ON TABLE hosts_id_seq FROM PUBLIC;
123 GRANT ALL ON TABLE hosts_id_seq TO "www-data";
127 -- TOC entry 11 (OID 536379)
128 -- Name: hostnames; Type: TABLE; Schema: public; Owner: rich
131 CREATE TABLE hostnames (
132 hostid integer NOT NULL,
138 -- TOC entry 12 (OID 536379)
139 -- Name: hostnames; Type: ACL; Schema: public; Owner: rich
142 REVOKE ALL ON TABLE hostnames FROM PUBLIC;
143 GRANT ALL ON TABLE hostnames TO "www-data";
147 -- TOC entry 13 (OID 536915)
148 -- Name: email_notify; Type: TABLE; Schema: public; Owner: rich
151 CREATE TABLE email_notify (
152 hostid integer NOT NULL,
159 -- TOC entry 14 (OID 536915)
160 -- Name: email_notify; Type: ACL; Schema: public; Owner: rich
163 REVOKE ALL ON TABLE email_notify FROM PUBLIC;
164 GRANT ALL ON TABLE email_notify TO "www-data";
168 -- TOC entry 15 (OID 537151)
169 -- Name: images; Type: TABLE; Schema: public; Owner: rich
172 CREATE TABLE images (
174 hostid integer NOT NULL,
177 image bytea NOT NULL,
178 width integer NOT NULL,
179 height integer NOT NULL,
184 mime_type text NOT NULL,
189 upload_date timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone NOT NULL
194 -- TOC entry 16 (OID 537151)
195 -- Name: images; Type: ACL; Schema: public; Owner: rich
198 REVOKE ALL ON TABLE images FROM PUBLIC;
199 GRANT ALL ON TABLE images TO "www-data";
203 -- TOC entry 26 (OID 537151)
204 -- Name: images_id_seq; Type: ACL; Schema: public; Owner: rich
207 REVOKE ALL ON TABLE images_id_seq FROM PUBLIC;
208 GRANT ALL ON TABLE images_id_seq TO "www-data";
212 -- TOC entry 17 (OID 537166)
213 -- Name: files; Type: TABLE; Schema: public; Owner: rich
218 hostid integer NOT NULL,
221 content bytea NOT NULL,
223 mime_type text NOT NULL,
224 upload_date timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone NOT NULL
229 -- TOC entry 18 (OID 537166)
230 -- Name: files; Type: ACL; Schema: public; Owner: rich
233 REVOKE ALL ON TABLE files FROM PUBLIC;
234 GRANT ALL ON TABLE files TO "www-data";
238 -- TOC entry 27 (OID 537166)
239 -- Name: files_id_seq; Type: ACL; Schema: public; Owner: rich
242 REVOKE ALL ON TABLE files_id_seq FROM PUBLIC;
243 GRANT ALL ON TABLE files_id_seq TO "www-data";
247 -- TOC entry 19 (OID 540816)
248 -- Name: users; Type: TABLE; Schema: public; Owner: rich
253 hostid integer NOT NULL,
255 "password" text NOT NULL,
257 registration_date date DEFAULT ('now'::text)::date NOT NULL,
258 can_edit boolean DEFAULT true NOT NULL,
259 can_manage_users boolean DEFAULT false NOT NULL
264 -- TOC entry 20 (OID 540816)
265 -- Name: users; Type: ACL; Schema: public; Owner: rich
268 REVOKE ALL ON TABLE users FROM PUBLIC;
269 GRANT ALL ON TABLE users TO "www-data";
273 -- TOC entry 28 (OID 540816)
274 -- Name: users_id_seq; Type: ACL; Schema: public; Owner: rich
277 REVOKE ALL ON TABLE users_id_seq FROM PUBLIC;
278 GRANT ALL ON TABLE users_id_seq TO "www-data";
282 -- TOC entry 21 (OID 540832)
283 -- Name: usercookies; Type: TABLE; Schema: public; Owner: rich
286 CREATE TABLE usercookies (
287 userid integer NOT NULL,
293 -- TOC entry 22 (OID 540832)
294 -- Name: usercookies; Type: ACL; Schema: public; Owner: rich
297 REVOKE ALL ON TABLE usercookies FROM PUBLIC;
298 GRANT ALL ON TABLE usercookies TO "www-data";
302 -- TOC entry 33 (OID 536388)
303 -- Name: hostnames_hostid_name_uq; Type: INDEX; Schema: public; Owner: rich
306 CREATE UNIQUE INDEX hostnames_hostid_name_uq ON hostnames USING btree (hostid, name);
310 -- TOC entry 34 (OID 536389)
311 -- Name: hostnams_name_uq; Type: INDEX; Schema: public; Owner: rich
314 CREATE UNIQUE INDEX hostnams_name_uq ON hostnames USING btree (name);
318 -- TOC entry 30 (OID 536419)
319 -- Name: pages_url_uq; Type: INDEX; Schema: public; Owner: rich
322 CREATE UNIQUE INDEX pages_url_uq ON pages USING btree (hostid, url);
326 -- TOC entry 35 (OID 536924)
327 -- Name: email_notify_email_uq; Type: INDEX; Schema: public; Owner: rich
330 CREATE UNIQUE INDEX email_notify_email_uq ON email_notify USING btree (hostid, email);
334 -- TOC entry 36 (OID 540251)
335 -- Name: images_name_uq; Type: INDEX; Schema: public; Owner: rich
338 CREATE UNIQUE INDEX images_name_uq ON images USING btree (hostid, name);
342 -- TOC entry 38 (OID 540252)
343 -- Name: files_name_uq; Type: INDEX; Schema: public; Owner: rich
346 CREATE UNIQUE INDEX files_name_uq ON files USING btree (hostid, name);
350 -- TOC entry 40 (OID 540831)
351 -- Name: users_name_uq; Type: INDEX; Schema: public; Owner: rich
354 CREATE UNIQUE INDEX users_name_uq ON users USING btree (hostid, name);
358 -- TOC entry 29 (OID 536012)
359 -- Name: pages_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
362 ALTER TABLE ONLY pages
363 ADD CONSTRAINT pages_pkey PRIMARY KEY (id);
367 -- TOC entry 31 (OID 536027)
368 -- Name: contents_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
371 ALTER TABLE ONLY contents
372 ADD CONSTRAINT contents_pkey PRIMARY KEY (id);
376 -- TOC entry 32 (OID 536377)
377 -- Name: hosts_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
380 ALTER TABLE ONLY hosts
381 ADD CONSTRAINT hosts_pkey PRIMARY KEY (id);
385 -- TOC entry 37 (OID 537158)
386 -- Name: images_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
389 ALTER TABLE ONLY images
390 ADD CONSTRAINT images_pkey PRIMARY KEY (id);
394 -- TOC entry 39 (OID 537173)
395 -- Name: files_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
398 ALTER TABLE ONLY files
399 ADD CONSTRAINT files_pkey PRIMARY KEY (id);
403 -- TOC entry 41 (OID 540825)
404 -- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
407 ALTER TABLE ONLY users
408 ADD CONSTRAINT users_pkey PRIMARY KEY (id);
412 -- TOC entry 44 (OID 536029)
413 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
416 ALTER TABLE ONLY contents
417 ADD CONSTRAINT "$1" FOREIGN KEY (pageid) REFERENCES pages(id);
421 -- TOC entry 46 (OID 536384)
422 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
425 ALTER TABLE ONLY hostnames
426 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
430 -- TOC entry 45 (OID 536394)
431 -- Name: hosts_hostname_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
434 ALTER TABLE ONLY hosts
435 ADD CONSTRAINT hosts_hostname_cn FOREIGN KEY (id, canonical_hostname) REFERENCES hostnames(hostid, name) DEFERRABLE;
439 -- TOC entry 42 (OID 536404)
440 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
443 ALTER TABLE ONLY pages
444 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
448 -- TOC entry 47 (OID 536920)
449 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
452 ALTER TABLE ONLY email_notify
453 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
457 -- TOC entry 48 (OID 537160)
458 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
461 ALTER TABLE ONLY images
462 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
466 -- TOC entry 49 (OID 537175)
467 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
470 ALTER TABLE ONLY files
471 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
475 -- TOC entry 43 (OID 539155)
476 -- Name: pages_redirect_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
479 ALTER TABLE ONLY pages
480 ADD CONSTRAINT pages_redirect_cn FOREIGN KEY (hostid, redirect) REFERENCES pages(hostid, url) DEFERRABLE;
484 -- TOC entry 50 (OID 540827)
485 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
488 ALTER TABLE ONLY users
489 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
493 -- TOC entry 51 (OID 540837)
494 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
497 ALTER TABLE ONLY usercookies
498 ADD CONSTRAINT "$1" FOREIGN KEY (userid) REFERENCES users(id);
501 SET SESSION AUTHORIZATION 'postgres';
504 -- TOC entry 3 (OID 2200)
505 -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
508 COMMENT ON SCHEMA public IS 'Standard public namespace';