[7938] Use same type for account ids in different tables related to used in code uint32 type for it. Author: charlie2025

--HG--
branch : trunk

2 files changed, 25 insertions, 1 deletions

diff --git a/sql/realmd.sql b/sql/realmd.sql
index fcd7d166359..f9d49de526c 100644
--- a/sql/realmd.sql
+++ b/sql/realmd.sql
@@ -15,13 +15,33 @@
 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
 
+/*
+--
+-- Table structure for table `realmd_db_version`
+--
+
+DROP TABLE IF EXISTS `realmd_db_version`;
+CREATE TABLE `realmd_db_version` (
+  `required_7938_01_realmd_account` bit(1) default NULL
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Last applied sql update to DB';
+
+--
+-- Dumping data for table `realmd_db_version`
+--
+
+LOCK TABLES `realmd_db_version` WRITE;
+INSERT INTO `realmd_db_version` VALUES
+(NULL);
+UNLOCK TABLES;
+*/
+
 --
 -- Table structure for table `account`
 --
 
 DROP TABLE IF EXISTS `account`;
 CREATE TABLE `account` (
-  `id` bigint(20) unsigned NOT NULL auto_increment COMMENT 'Identifier',
+  `id` int(11) unsigned NOT NULL auto_increment COMMENT 'Identifier',
   `username`      varchar(32) NOT NULL default '',
   `sha_pass_hash` varchar(40) NOT NULL default '',
   `gmlevel` tinyint(3) unsigned NOT NULL default '0',
diff --git a/sql/updates/7938_01_realmd_account.sql b/sql/updates/7938_01_realmd_account.sql
new file mode 100644
index 00000000000..e0658b68cd4
--- /dev/null
+++ b/sql/updates/7938_01_realmd_account.sql
@@ -0,0 +1,4 @@
+ALTER TABLE realmd_db_version CHANGE COLUMN required_7867_01_realmd_account required_7938_01_realmd_account bit;
+
+ALTER TABLE account
+  CHANGE id id int(11) unsigned NOT NULL auto_increment COMMENT 'Identifier';
\ No newline at end of file