Dropped links_to constraint.

[cocanwiki.git] / cocanwiki.sql

diff --git a/cocanwiki.sql b/cocanwiki.sql
index 785ac70..850cb67 100644 (file)
--- a/cocanwiki.sql
+++ b/cocanwiki.sql
@@ -104,7 +104,8 @@ CREATE TABLE hosts (
     feedback_email text,
     mailing_list boolean DEFAULT false NOT NULL,
     is_template boolean DEFAULT false NOT NULL,
-    search_box boolean DEFAULT true NOT NULL
+    search_box boolean DEFAULT true NOT NULL,
+    view_anon boolean DEFAULT true NOT NULL
 );
 
 
@@ -880,15 +881,6 @@ ALTER TABLE ONLY links
 
 
 --
--- TOC entry 92 (OID 544459)
--- Name: links_to_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
---
-
-ALTER TABLE ONLY links
-    ADD CONSTRAINT links_to_cn FOREIGN KEY (hostid, to_url) REFERENCES pages(hostid, url) DEFERRABLE;
-
-
---
 -- TOC entry 3 (OID 2200)
 -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
 --
@@ -904,3 +896,22 @@ COMMENT ON SCHEMA public IS 'Standard public namespace';
 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.';
 
 
+--
+-- PostgreSQL database dump
+--
+
+SET client_encoding = 'UNICODE';
+SET check_function_bodies = false;
+
+SET search_path = public, pg_catalog;
+
+--
+-- Data for TOC entry 2 (OID 543499)
+-- Name: themes; Type: TABLE DATA; Schema: public; Owner: rich
+--
+
+COPY themes (theme_css, name, description) FROM stdin;
+/_css/easyweb.css      Merjis Easy Web Marketing       This is the easy web marketing stylesheet developed by Merjis Ltd.  Please see http://www.merjis.com/
+\.
+
+