added full half-op support

[NeonServV5.git] / database.sql

diff --git a/database.sql b/database.sql
index 718b05877b0e6523a3a91a518c816949682315cd..2047290e00d50e71b17c93a5d5722052ac532916 100644 (file)
--- 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;