X-Git-Url: http://git.pk910.de/?a=blobdiff_plain;f=database.upgrade.sql;h=7d08cd83a6961e598437faaf093626b217d40b51;hb=406c308308e4d131475a692cd425cb156e0776f1;hp=4f4697dccf9da46b841813e021034bb701aa7eda;hpb=b013fcf166b6b84f7b946412dacfe84ba5cfe6b6;p=NeonServV5.git diff --git a/database.upgrade.sql b/database.upgrade.sql index 4f4697d..7d08cd8 100644 --- a/database.upgrade.sql +++ b/database.upgrade.sql @@ -134,3 +134,16 @@ 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