X-Git-Url: http://git.pk910.de/?p=NeonServV5.git;a=blobdiff_plain;f=database.upgrade.sql;h=4f4697dccf9da46b841813e021034bb701aa7eda;hp=fcbb93685347553a7cf3f40d69cd3a98624eff9a;hb=b013fcf166b6b84f7b946412dacfe84ba5cfe6b6;hpb=cb3a4cb7d17ae071499ce4a1030e95e1eb356100

diff --git a/database.upgrade.sql b/database.upgrade.sql
index fcbb936..4f4697d 100644
--- a/database.upgrade.sql
+++ b/database.upgrade.sql
@@ -127,3 +127,10 @@ ALTER TABLE `helpserv_requests` ADD `botid` INT( 11 ) NOT NULL AFTER `id`;
 ALTER TABLE `helpserv_settings` ADD `helpserv_intern_announce` TINYINT( 1 ) NOT NULL;
 
 -- version: 13
+
+ALTER TABLE `channels` ADD `channel_canhalfop` SMALLINT( 3 ) NULL AFTER `channel_canop`;
+ALTER TABLE `channels` ADD `channel_gethalfop` SMALLINT( 3 ) NULL AFTER `channel_getop`;
+UPDATE `channels` SET `channel_canhalfop` = '150',
+`channel_gethalfop` = '150' WHERE `channel_name` = 'defaults';
+
+-- version: 14