Added the can_manage_site and can_edit_global_css permissions.

[cocanwiki.git] / cocanwiki.sql

diff --git a/cocanwiki.sql b/cocanwiki.sql
index ac84730..f919920 100644 (file)
--- a/cocanwiki.sql
+++ b/cocanwiki.sql
@@ -73,7 +73,7 @@ CREATE TABLE contents (
     id serial NOT NULL,
     pageid integer NOT NULL,
     ordering integer NOT NULL,
-    sectionname text NOT NULL,
+    sectionname text,
     content text NOT NULL,
     divname text
 );
@@ -112,7 +112,8 @@ CREATE TABLE hosts (
     css text,
     edit_anon boolean DEFAULT true NOT NULL,
     create_account_anon boolean DEFAULT true NOT NULL,
-    theme_css text
+    theme_css text,
+    feedback_email text
 );
 
 
@@ -284,7 +285,9 @@ CREATE TABLE users (
     registration_date date DEFAULT ('now'::text)::date NOT NULL,
     can_edit boolean DEFAULT true NOT NULL,
     can_manage_users boolean DEFAULT false NOT NULL,
-    can_manage_contacts boolean DEFAULT false NOT NULL
+    can_manage_contacts boolean DEFAULT false NOT NULL,
+    can_manage_site boolean DEFAULT false NOT NULL,
+    can_edit_global_css boolean DEFAULT false NOT NULL
 );