About to remove the links_to constraint from the links table.

[cocanwiki.git] / cocanwiki.sql

diff --git a/cocanwiki.sql b/cocanwiki.sql
index af3ac70..d4b9514 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
 );
 
 
@@ -476,7 +477,8 @@ GRANT ALL ON TABLE mailing_lists TO "www-data";
 CREATE TABLE links (
     hostid integer NOT NULL,
     from_url text NOT NULL,
-    to_url text NOT NULL
+    to_url text NOT NULL,
+    CONSTRAINT links_not_selfref_cn CHECK ((from_url <> to_url))
 );
 
 
@@ -903,3 +905,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/
+\.
+
+