added stats module for neonserv.krypton-bouncer.de stats

[NeonServV5.git] / database.upgrade.sql

diff --git a/database.upgrade.sql b/database.upgrade.sql
index 4f4697dccf9da46b841813e021034bb701aa7eda..7d08cd83a6961e598437faaf093626b217d40b51 100644 (file)
--- 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