X-Git-Url: http://git.pk910.de/?a=blobdiff_plain;f=database.upgrade.sql;h=7d08cd83a6961e598437faaf093626b217d40b51;hb=406c308308e4d131475a692cd425cb156e0776f1;hp=7051a441f05fa12b9bfba4fd6b20632cbb6bca5e;hpb=abb1f08cf0b36ffd7ad54252a6893236dc274aff;p=NeonServV5.git

diff --git a/database.upgrade.sql b/database.upgrade.sql
index 7051a44..7d08cd8 100644
--- a/database.upgrade.sql
+++ b/database.upgrade.sql
@@ -118,4 +118,32 @@ CREATE TABLE IF NOT EXISTS `helpserv_settings` (
   PRIMARY KEY (`helpserv_botid`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
--- version: 11
\ No newline at end of file
+-- version: 11
+
+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
+
+CREATE TABLE IF NOT EXISTS `settings` (
+  `name` varchar(100) NOT NULL,
+  `value` text NOT NULL,
+  PRIMARY KEY (`name`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+-- version: 16