From 74f927890b640611f7aabe2806e9271601a60d28 Mon Sep 17 00:00:00 2001 From: pk910 Date: Wed, 5 Oct 2011 22:14:45 +0200 Subject: [PATCH] added version table to database.upgrade_v4_v5.sql --- database.upgrade_v4_v5.sql | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) 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 -- 2.20.1