X-Git-Url: http://git.pk910.de/?a=blobdiff_plain;f=database.upgrade.sql;h=cad2b7310784cf5c478b4dc8c9753335534606ef;hb=c32e8254ec4ed0d77757e32f8aa5aabcdb494057;hp=8b2fa16521082fe17e8ea23f0bfdb41ebbee3930;hpb=7c5dd19f4e89530ce6d7825252aed4e9c57e8505;p=NeonServV5.git diff --git a/database.upgrade.sql b/database.upgrade.sql index 8b2fa16..cad2b73 100644 --- a/database.upgrade.sql +++ b/database.upgrade.sql @@ -123,3 +123,20 @@ CREATE TABLE IF NOT EXISTS `helpserv_settings` ( ALTER TABLE `helpserv_requests` ADD `botid` INT( 11 ) NOT NULL AFTER `id`; -- version: 12 + +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 + +ALTER TABLE `users` ADD `user_registered` INT( 20 ) NOT NULL , +ADD `user_lastcheck` INT( 20 ) NOT NULL; + +-- version: 15 +