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";
54 SET SESSION AUTHORIZATION 'rich';
57 -- TOC entry 38 (OID 536004)
58 -- Name: pages_id_seq; Type: ACL; Schema: public; Owner: rich
61 REVOKE ALL ON TABLE pages_id_seq FROM PUBLIC;
62 GRANT ALL ON TABLE pages_id_seq TO "www-data";
65 SET SESSION AUTHORIZATION 'rich';
68 -- TOC entry 7 (OID 536021)
69 -- Name: contents; Type: TABLE; Schema: public; Owner: rich
72 CREATE TABLE contents (
74 pageid integer NOT NULL,
75 ordering integer NOT NULL,
77 content text NOT NULL,
83 -- TOC entry 8 (OID 536021)
84 -- Name: contents; Type: ACL; Schema: public; Owner: rich
87 REVOKE ALL ON TABLE contents FROM PUBLIC;
88 GRANT ALL ON TABLE contents TO "www-data";
91 SET SESSION AUTHORIZATION 'rich';
94 -- TOC entry 39 (OID 536021)
95 -- Name: contents_id_seq; Type: ACL; Schema: public; Owner: rich
98 REVOKE ALL ON TABLE contents_id_seq FROM PUBLIC;
99 GRANT ALL ON TABLE contents_id_seq TO "www-data";
102 SET SESSION AUTHORIZATION 'rich';
105 -- TOC entry 9 (OID 536371)
106 -- Name: hosts; Type: TABLE; Schema: public; Owner: rich
111 canonical_hostname text NOT NULL,
113 edit_anon boolean DEFAULT true NOT NULL,
114 create_account_anon boolean DEFAULT true NOT NULL,
117 mailing_list boolean DEFAULT false NOT NULL
122 -- TOC entry 10 (OID 536371)
123 -- Name: hosts; Type: ACL; Schema: public; Owner: rich
126 REVOKE ALL ON TABLE hosts FROM PUBLIC;
127 GRANT ALL ON TABLE hosts TO "www-data";
130 SET SESSION AUTHORIZATION 'rich';
133 -- TOC entry 40 (OID 536371)
134 -- Name: hosts_id_seq; Type: ACL; Schema: public; Owner: rich
137 REVOKE ALL ON TABLE hosts_id_seq FROM PUBLIC;
138 GRANT ALL ON TABLE hosts_id_seq TO "www-data";
141 SET SESSION AUTHORIZATION 'rich';
144 -- TOC entry 11 (OID 536379)
145 -- Name: hostnames; Type: TABLE; Schema: public; Owner: rich
148 CREATE TABLE hostnames (
149 hostid integer NOT NULL,
155 -- TOC entry 12 (OID 536379)
156 -- Name: hostnames; Type: ACL; Schema: public; Owner: rich
159 REVOKE ALL ON TABLE hostnames FROM PUBLIC;
160 GRANT ALL ON TABLE hostnames TO "www-data";
163 SET SESSION AUTHORIZATION 'rich';
166 -- TOC entry 13 (OID 536915)
167 -- Name: email_notify; Type: TABLE; Schema: public; Owner: rich
170 CREATE TABLE email_notify (
171 hostid integer NOT NULL,
178 -- TOC entry 14 (OID 536915)
179 -- Name: email_notify; Type: ACL; Schema: public; Owner: rich
182 REVOKE ALL ON TABLE email_notify FROM PUBLIC;
183 GRANT ALL ON TABLE email_notify TO "www-data";
186 SET SESSION AUTHORIZATION 'rich';
189 -- TOC entry 15 (OID 537151)
190 -- Name: images; Type: TABLE; Schema: public; Owner: rich
193 CREATE TABLE images (
195 hostid integer NOT NULL,
198 image bytea NOT NULL,
199 width integer NOT NULL,
200 height integer NOT NULL,
205 mime_type text NOT NULL,
210 upload_date timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone NOT NULL
215 -- TOC entry 16 (OID 537151)
216 -- Name: images; Type: ACL; Schema: public; Owner: rich
219 REVOKE ALL ON TABLE images FROM PUBLIC;
220 GRANT ALL ON TABLE images TO "www-data";
223 SET SESSION AUTHORIZATION 'rich';
226 -- TOC entry 41 (OID 537151)
227 -- Name: images_id_seq; Type: ACL; Schema: public; Owner: rich
230 REVOKE ALL ON TABLE images_id_seq FROM PUBLIC;
231 GRANT ALL ON TABLE images_id_seq TO "www-data";
234 SET SESSION AUTHORIZATION 'rich';
237 -- TOC entry 17 (OID 537166)
238 -- Name: files; Type: TABLE; Schema: public; Owner: rich
243 hostid integer NOT NULL,
246 content bytea NOT NULL,
248 mime_type text NOT NULL,
249 upload_date timestamp without time zone DEFAULT ('now'::text)::timestamp(6) with time zone NOT NULL
254 -- TOC entry 18 (OID 537166)
255 -- Name: files; Type: ACL; Schema: public; Owner: rich
258 REVOKE ALL ON TABLE files FROM PUBLIC;
259 GRANT ALL ON TABLE files TO "www-data";
262 SET SESSION AUTHORIZATION 'rich';
265 -- TOC entry 42 (OID 537166)
266 -- Name: files_id_seq; Type: ACL; Schema: public; Owner: rich
269 REVOKE ALL ON TABLE files_id_seq FROM PUBLIC;
270 GRANT ALL ON TABLE files_id_seq TO "www-data";
273 SET SESSION AUTHORIZATION 'rich';
276 -- TOC entry 19 (OID 540816)
277 -- Name: users; Type: TABLE; Schema: public; Owner: rich
282 hostid integer NOT NULL,
284 "password" text NOT NULL,
286 registration_date date DEFAULT ('now'::text)::date NOT NULL,
287 can_edit boolean DEFAULT true NOT NULL,
288 can_manage_users boolean DEFAULT false NOT NULL,
289 can_manage_contacts boolean DEFAULT false NOT NULL,
290 can_manage_site boolean DEFAULT false NOT NULL,
291 can_edit_global_css boolean DEFAULT false NOT NULL
296 -- TOC entry 20 (OID 540816)
297 -- Name: users; Type: ACL; Schema: public; Owner: rich
300 REVOKE ALL ON TABLE users FROM PUBLIC;
301 GRANT ALL ON TABLE users TO "www-data";
304 SET SESSION AUTHORIZATION 'rich';
307 -- TOC entry 43 (OID 540816)
308 -- Name: users_id_seq; Type: ACL; Schema: public; Owner: rich
311 REVOKE ALL ON TABLE users_id_seq FROM PUBLIC;
312 GRANT ALL ON TABLE users_id_seq TO "www-data";
315 SET SESSION AUTHORIZATION 'rich';
318 -- TOC entry 21 (OID 540832)
319 -- Name: usercookies; Type: TABLE; Schema: public; Owner: rich
322 CREATE TABLE usercookies (
323 userid integer NOT NULL,
329 -- TOC entry 22 (OID 540832)
330 -- Name: usercookies; Type: ACL; Schema: public; Owner: rich
333 REVOKE ALL ON TABLE usercookies FROM PUBLIC;
334 GRANT ALL ON TABLE usercookies TO "www-data";
337 SET SESSION AUTHORIZATION 'rich';
340 -- TOC entry 23 (OID 540961)
341 -- Name: sitemenu; Type: TABLE; Schema: public; Owner: rich
344 CREATE TABLE sitemenu (
345 hostid integer NOT NULL,
348 ordering integer NOT NULL
353 -- TOC entry 24 (OID 540961)
354 -- Name: sitemenu; Type: ACL; Schema: public; Owner: rich
357 REVOKE ALL ON TABLE sitemenu FROM PUBLIC;
358 GRANT ALL ON TABLE sitemenu TO "www-data";
361 SET SESSION AUTHORIZATION 'rich';
364 -- TOC entry 25 (OID 542605)
365 -- Name: contacts; Type: TABLE; Schema: public; Owner: rich
368 CREATE TABLE contacts (
370 hostid integer NOT NULL,
372 subject text NOT NULL
377 -- TOC entry 26 (OID 542605)
378 -- Name: contacts; Type: ACL; Schema: public; Owner: rich
381 REVOKE ALL ON TABLE contacts FROM PUBLIC;
382 GRANT ALL ON TABLE contacts TO "www-data";
385 SET SESSION AUTHORIZATION 'rich';
388 -- TOC entry 44 (OID 542605)
389 -- Name: contacts_id_seq; Type: ACL; Schema: public; Owner: rich
392 REVOKE ALL ON TABLE contacts_id_seq FROM PUBLIC;
393 GRANT ALL ON TABLE contacts_id_seq TO "www-data";
396 SET SESSION AUTHORIZATION 'rich';
399 -- TOC entry 27 (OID 542617)
400 -- Name: contact_emails; Type: TABLE; Schema: public; Owner: rich
403 CREATE TABLE contact_emails (
404 contactid integer NOT NULL,
410 -- TOC entry 28 (OID 542617)
411 -- Name: contact_emails; Type: ACL; Schema: public; Owner: rich
414 REVOKE ALL ON TABLE contact_emails FROM PUBLIC;
415 GRANT ALL ON TABLE contact_emails TO "www-data";
418 SET SESSION AUTHORIZATION 'rich';
421 -- TOC entry 29 (OID 543499)
422 -- Name: themes; Type: TABLE; Schema: public; Owner: rich
425 CREATE TABLE themes (
426 theme_css text NOT NULL,
428 description text NOT NULL
433 -- TOC entry 30 (OID 543499)
434 -- Name: themes; Type: ACL; Schema: public; Owner: rich
437 REVOKE ALL ON TABLE themes FROM PUBLIC;
438 GRANT SELECT ON TABLE themes TO "www-data";
441 SET SESSION AUTHORIZATION 'rich';
444 -- TOC entry 31 (OID 543592)
445 -- Name: server_settings; Type: TABLE; Schema: public; Owner: rich
448 CREATE TABLE server_settings (
449 "version" integer NOT NULL,
455 -- TOC entry 33 (OID 543592)
456 -- Name: server_settings; Type: ACL; Schema: public; Owner: rich
459 REVOKE ALL ON TABLE server_settings FROM PUBLIC;
460 GRANT SELECT ON TABLE server_settings TO "www-data";
463 SET SESSION AUTHORIZATION 'rich';
466 -- TOC entry 34 (OID 543754)
467 -- Name: page_emails; Type: TABLE; Schema: public; Owner: rich
470 CREATE TABLE page_emails (
471 hostid integer NOT NULL,
474 entry_date date DEFAULT ('now'::text)::date NOT NULL,
475 last_sent date DEFAULT ('now'::text)::date NOT NULL,
477 opt_out text NOT NULL
482 -- TOC entry 35 (OID 543754)
483 -- Name: page_emails; Type: ACL; Schema: public; Owner: rich
486 REVOKE ALL ON TABLE page_emails FROM PUBLIC;
487 GRANT ALL ON TABLE page_emails TO "www-data";
490 SET SESSION AUTHORIZATION 'rich';
493 -- TOC entry 36 (OID 543785)
494 -- Name: mailing_lists; Type: TABLE; Schema: public; Owner: rich
497 CREATE TABLE mailing_lists (
498 hostid integer NOT NULL,
500 entry_date date DEFAULT ('now'::text)::date NOT NULL,
502 opt_out text NOT NULL
507 -- TOC entry 37 (OID 543785)
508 -- Name: mailing_lists; Type: ACL; Schema: public; Owner: rich
511 REVOKE ALL ON TABLE mailing_lists FROM PUBLIC;
512 GRANT ALL ON TABLE mailing_lists TO "www-data";
515 SET SESSION AUTHORIZATION 'rich';
518 -- TOC entry 49 (OID 536388)
519 -- Name: hostnames_hostid_name_uq; Type: INDEX; Schema: public; Owner: rich
522 CREATE UNIQUE INDEX hostnames_hostid_name_uq ON hostnames USING btree (hostid, name);
526 -- TOC entry 50 (OID 536389)
527 -- Name: hostnams_name_uq; Type: INDEX; Schema: public; Owner: rich
530 CREATE UNIQUE INDEX hostnams_name_uq ON hostnames USING btree (name);
534 -- TOC entry 46 (OID 536419)
535 -- Name: pages_url_uq; Type: INDEX; Schema: public; Owner: rich
538 CREATE UNIQUE INDEX pages_url_uq ON pages USING btree (hostid, url);
542 -- TOC entry 51 (OID 536924)
543 -- Name: email_notify_email_uq; Type: INDEX; Schema: public; Owner: rich
546 CREATE UNIQUE INDEX email_notify_email_uq ON email_notify USING btree (hostid, email);
550 -- TOC entry 52 (OID 540251)
551 -- Name: images_name_uq; Type: INDEX; Schema: public; Owner: rich
554 CREATE UNIQUE INDEX images_name_uq ON images USING btree (hostid, name);
558 -- TOC entry 54 (OID 540252)
559 -- Name: files_name_uq; Type: INDEX; Schema: public; Owner: rich
562 CREATE UNIQUE INDEX files_name_uq ON files USING btree (hostid, name);
566 -- TOC entry 57 (OID 540831)
567 -- Name: users_name_uq; Type: INDEX; Schema: public; Owner: rich
570 CREATE UNIQUE INDEX users_name_uq ON users USING btree (hostid, name);
574 -- TOC entry 56 (OID 540946)
575 -- Name: users_id_uq; Type: INDEX; Schema: public; Owner: rich
578 CREATE UNIQUE INDEX users_id_uq ON users USING btree (hostid, id);
582 -- TOC entry 59 (OID 540970)
583 -- Name: sitemenu_ordering_uq; Type: INDEX; Schema: public; Owner: rich
586 CREATE UNIQUE INDEX sitemenu_ordering_uq ON sitemenu USING btree (hostid, ordering);
590 -- TOC entry 60 (OID 540971)
591 -- Name: sitemenu_url_uq; Type: INDEX; Schema: public; Owner: rich
594 CREATE UNIQUE INDEX sitemenu_url_uq ON sitemenu USING btree (hostid, url);
598 -- TOC entry 62 (OID 542626)
599 -- Name: contact_emails_uq; Type: INDEX; Schema: public; Owner: rich
602 CREATE UNIQUE INDEX contact_emails_uq ON contact_emails USING btree (contactid, email);
606 -- TOC entry 63 (OID 543505)
607 -- Name: themes_theme_css_uq; Type: INDEX; Schema: public; Owner: rich
610 CREATE UNIQUE INDEX themes_theme_css_uq ON themes USING btree (theme_css);
614 -- TOC entry 64 (OID 543763)
615 -- Name: page_emails_email_uq; Type: INDEX; Schema: public; Owner: rich
618 CREATE UNIQUE INDEX page_emails_email_uq ON page_emails USING btree (hostid, url, email);
622 -- TOC entry 65 (OID 543795)
623 -- Name: mailing_lists_email_uq; Type: INDEX; Schema: public; Owner: rich
626 CREATE UNIQUE INDEX mailing_lists_email_uq ON mailing_lists USING btree (hostid, email);
630 -- TOC entry 45 (OID 536012)
631 -- Name: pages_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
634 ALTER TABLE ONLY pages
635 ADD CONSTRAINT pages_pkey PRIMARY KEY (id);
639 -- TOC entry 47 (OID 536027)
640 -- Name: contents_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
643 ALTER TABLE ONLY contents
644 ADD CONSTRAINT contents_pkey PRIMARY KEY (id);
648 -- TOC entry 48 (OID 536377)
649 -- Name: hosts_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
652 ALTER TABLE ONLY hosts
653 ADD CONSTRAINT hosts_pkey PRIMARY KEY (id);
657 -- TOC entry 53 (OID 537158)
658 -- Name: images_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
661 ALTER TABLE ONLY images
662 ADD CONSTRAINT images_pkey PRIMARY KEY (id);
666 -- TOC entry 55 (OID 537173)
667 -- Name: files_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
670 ALTER TABLE ONLY files
671 ADD CONSTRAINT files_pkey PRIMARY KEY (id);
675 -- TOC entry 58 (OID 540825)
676 -- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
679 ALTER TABLE ONLY users
680 ADD CONSTRAINT users_pkey PRIMARY KEY (id);
684 -- TOC entry 61 (OID 542611)
685 -- Name: contacts_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
688 ALTER TABLE ONLY contacts
689 ADD CONSTRAINT contacts_pkey PRIMARY KEY (id);
693 -- TOC entry 70 (OID 536029)
694 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
697 ALTER TABLE ONLY contents
698 ADD CONSTRAINT "$1" FOREIGN KEY (pageid) REFERENCES pages(id);
702 -- TOC entry 73 (OID 536384)
703 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
706 ALTER TABLE ONLY hostnames
707 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
711 -- TOC entry 71 (OID 536394)
712 -- Name: hosts_hostname_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
715 ALTER TABLE ONLY hosts
716 ADD CONSTRAINT hosts_hostname_cn FOREIGN KEY (id, canonical_hostname) REFERENCES hostnames(hostid, name) DEFERRABLE;
720 -- TOC entry 66 (OID 536404)
721 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
724 ALTER TABLE ONLY pages
725 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
729 -- TOC entry 74 (OID 536920)
730 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
733 ALTER TABLE ONLY email_notify
734 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
738 -- TOC entry 75 (OID 537160)
739 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
742 ALTER TABLE ONLY images
743 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
747 -- TOC entry 76 (OID 537175)
748 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
751 ALTER TABLE ONLY files
752 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
756 -- TOC entry 67 (OID 539155)
757 -- Name: pages_redirect_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
760 ALTER TABLE ONLY pages
761 ADD CONSTRAINT pages_redirect_cn FOREIGN KEY (hostid, redirect) REFERENCES pages(hostid, url) DEFERRABLE;
765 -- TOC entry 77 (OID 540827)
766 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
769 ALTER TABLE ONLY users
770 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
774 -- TOC entry 78 (OID 540837)
775 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
778 ALTER TABLE ONLY usercookies
779 ADD CONSTRAINT "$1" FOREIGN KEY (userid) REFERENCES users(id);
783 -- TOC entry 68 (OID 540942)
784 -- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: rich
787 ALTER TABLE ONLY pages
788 ADD CONSTRAINT "$2" FOREIGN KEY (logged_user) REFERENCES users(id);
792 -- TOC entry 69 (OID 540947)
793 -- Name: pages_user_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
796 ALTER TABLE ONLY pages
797 ADD CONSTRAINT pages_user_cn FOREIGN KEY (hostid, logged_user) REFERENCES users(hostid, id);
801 -- TOC entry 79 (OID 540966)
802 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
805 ALTER TABLE ONLY sitemenu
806 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
810 -- TOC entry 80 (OID 540972)
811 -- Name: sitemenu_url_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
814 ALTER TABLE ONLY sitemenu
815 ADD CONSTRAINT sitemenu_url_cn FOREIGN KEY (hostid, url) REFERENCES pages(hostid, url) DEFERRABLE;
819 -- TOC entry 81 (OID 542613)
820 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
823 ALTER TABLE ONLY contacts
824 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
828 -- TOC entry 82 (OID 542622)
829 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
832 ALTER TABLE ONLY contact_emails
833 ADD CONSTRAINT "$1" FOREIGN KEY (contactid) REFERENCES contacts(id);
837 -- TOC entry 72 (OID 543506)
838 -- Name: hosts_theme_css_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
841 ALTER TABLE ONLY hosts
842 ADD CONSTRAINT hosts_theme_css_cn FOREIGN KEY (theme_css) REFERENCES themes(theme_css);
846 -- TOC entry 83 (OID 543759)
847 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
850 ALTER TABLE ONLY page_emails
851 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
855 -- TOC entry 84 (OID 543764)
856 -- Name: page_emails_url_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
859 ALTER TABLE ONLY page_emails
860 ADD CONSTRAINT page_emails_url_cn FOREIGN KEY (hostid, url) REFERENCES pages(hostid, url) DEFERRABLE;
864 -- TOC entry 85 (OID 543791)
865 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
868 ALTER TABLE ONLY mailing_lists
869 ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
872 SET SESSION AUTHORIZATION 'postgres';
875 -- TOC entry 3 (OID 2200)
876 -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
879 COMMENT ON SCHEMA public IS 'Standard public namespace';
882 SET SESSION AUTHORIZATION 'rich';
885 -- TOC entry 32 (OID 543592)
886 -- Name: TABLE server_settings; Type: COMMENT; Schema: public; Owner: rich
889 COMMENT ON TABLE server_settings IS 'This table contains global settings for the server. There should be only one row in this table. If you modify any setting, you must restart the webserver for the change to take effect. The "version" field is intended to be some sort of database version, but is currently unused.';