X-Git-Url: http://git.pk910.de/?p=NeonServV5.git;a=blobdiff_plain;f=database.sql;h=2047290e00d50e71b17c93a5d5722052ac532916;hp=718b05877b0e6523a3a91a518c816949682315cd;hb=b013fcf166b6b84f7b946412dacfe84ba5cfe6b6;hpb=abb1f08cf0b36ffd7ad54252a6893236dc274aff diff --git a/database.sql b/database.sql index 718b058..2047290 100644 --- a/database.sql +++ b/database.sql @@ -102,8 +102,10 @@ CREATE TABLE IF NOT EXISTS `channels` ( `channel_staticban` smallint(3) DEFAULT NULL, `channel_protect` tinyint(1) DEFAULT NULL, `channel_canop` smallint(3) DEFAULT NULL, + `channel_canhalfop` smallint(3) DEFAULT NULL, `channel_canvoice` smallint(3) DEFAULT NULL, `channel_getop` smallint(3) DEFAULT NULL, + `channel_gethalfop` smallint(3) DEFAULT NULL, `channel_getvoice` smallint(3) DEFAULT NULL, `channel_greeting` varchar(512) NOT NULL, `channel_usergreeting` varchar(512) NOT NULL, @@ -369,6 +371,7 @@ UNIQUE ( CREATE TABLE IF NOT EXISTS `helpserv_requests` ( `id` int(11) NOT NULL AUTO_INCREMENT, + `botid` INT(11) NOT NULL, `host` varchar(200) NOT NULL, `hand` varchar(50) NOT NULL, `nick` varchar(50) NOT NULL, @@ -392,6 +395,7 @@ CREATE TABLE IF NOT EXISTS `helpserv_settings` ( `helpserv_support` varchar(256) NOT NULL, `helpserv_public` varchar(256) DEFAULT NULL, `helpserv_intern` varchar(256) DEFAULT NULL, + `helpserv_intern_announce` TINYINT(1) NOT NULL, PRIMARY KEY (`helpserv_botid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;