From 4a27b517fc52dde60e5c1837860e4785317490a6 Mon Sep 17 00:00:00 2001 From: Antonio Gallo Date: Tue, 15 Feb 2011 17:06:09 +0000 Subject: improved wiki --- h-source/tables.sql | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) (limited to 'h-source/tables.sql') diff --git a/h-source/tables.sql b/h-source/tables.sql index c59cf23..b22e0be 100644 --- a/h-source/tables.sql +++ b/h-source/tables.sql @@ -224,7 +224,7 @@ create table history ( created_by int not null, creation_date timestamp default CURRENT_TIMESTAMP, type char(10) not null, - action char(10) not null, + action char(15) not null, id INT UNSIGNED NOT NULL, message text CHARACTER SET utf8 not null, gr char(15) not null @@ -233,6 +233,8 @@ create table history ( insert into reggroups (name) values ('moderator'); +insert into reggroups (name) values ('admin'); + create table wiki ( id_wiki INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, created_by int not null, @@ -242,6 +244,7 @@ create table wiki ( title_clean varchar(100) CHARACTER SET utf8 not null, page text CHARACTER SET utf8 not null, deleted char(3) not null default 'no', + blocked CHAR(3) NOT NULL default 'no', is_main char(3) not null default 'no' )engine=innodb; -- cgit v1.2.3