X-Git-Url: http://git.pk910.de/?p=NeonServV5.git;a=blobdiff_plain;f=database.upgrade_v4_v5.sql;h=86c63873d31c0dee7e13ea4bdfcbfec783e0ab08;hp=5dff29802fde055d35870c78ab6dd2b6b102192c;hb=74f927890b640611f7aabe2806e9271601a60d28;hpb=2d9db1adb1946aba00b203f40eff7d5db8163f01 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