X-Git-Url: http://git.annexia.org/?a=blobdiff_plain;f=cocanwiki.sql;h=f9199204defdcb5ffa248c3ff3b48f159a232c7f;hb=0d88075fa62c0a801ea1e9246d85389f9161a4e1;hp=ac847309bfb26a2a6f199f0a63dd12d9be2631f3;hpb=5def59b20559a1d352d0d9c3304d9b09c2523b41;p=cocanwiki.git diff --git a/cocanwiki.sql b/cocanwiki.sql index ac84730..f919920 100644 --- 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 );