diff options
author | Antonio Gallo <tonicucoz@gmail.com> | 2011-02-15 17:06:09 +0000 |
---|---|---|
committer | Antonio Gallo <tonicucoz@gmail.com> | 2011-02-15 17:06:09 +0000 |
commit | 4a27b517fc52dde60e5c1837860e4785317490a6 (patch) | |
tree | 73b91c5d212f1bb67eb83fea9694cf8d1a360846 /h-source/tables.sql | |
parent | d85570c9946aef61d8d935d9f50169215338d665 (diff) |
improved wiki
Diffstat (limited to 'h-source/tables.sql')
-rw-r--r-- | h-source/tables.sql | 5 |
1 files changed, 4 insertions, 1 deletions
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; |