added new auth-check security feature

[NeonServV5.git] / database.upgrade.sql

diff --git a/database.upgrade.sql b/database.upgrade.sql
index 8b2fa16521082fe17e8ea23f0bfdb41ebbee3930..cad2b7310784cf5c478b4dc8c9753335534606ef 100644 (file)
--- 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
+