From 4a27b517fc52dde60e5c1837860e4785317490a6 Mon Sep 17 00:00:00 2001
From: Antonio Gallo <tonicucoz@gmail.com>
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

