From: pk910 Date: Wed, 5 Oct 2011 20:14:45 +0000 (+0200) Subject: added version table to database.upgrade_v4_v5.sql X-Git-Tag: v5.3~304 X-Git-Url: http://git.pk910.de/?p=NeonServV5.git;a=commitdiff_plain;h=74f927890b640611f7aabe2806e9271601a60d28;hp=2d9db1adb1946aba00b203f40eff7d5db8163f01 added version table to database.upgrade_v4_v5.sql --- diff --git a/database.upgrade_v4_v5.sql b/database.upgrade_v4_v5.sql index 5dff298..86c6387 100644 --- a/database.upgrade_v4_v5.sql +++ b/database.upgrade_v4_v5.sql @@ -62,4 +62,11 @@ ALTER TABLE `bot_channels` ADD `suspended` TINYINT( 1 ) NOT NULL; ALTER TABLE `users` ADD UNIQUE (`user_user`); -ALTER TABLE `noinvite` ADD INDEX ( `cid`, `uid` ); \ No newline at end of file +ALTER TABLE `noinvite` ADD INDEX ( `cid`, `uid` ); + +CREATE TABLE IF NOT EXISTS `version` ( + `database_version` int(5) NOT NULL, + PRIMARY KEY (`database_version`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +INSERT INTO `version` (`database_version`) VALUES (1); \ No newline at end of file