From 58d910d191250748ef08e34b7a6de357d56d0197 Mon Sep 17 00:00:00 2001
From: megamage <none@none>
Date: Tue, 2 Jun 2009 17:42:28 -0500
Subject: [7938] Use same type for account ids in different tables related to
 used in code uint32 type for it. Author: charlie2025

--HG--
branch : trunk
---
 sql/realmd.sql | 22 +++++++++++++++++++++-
 1 file changed, 21 insertions(+), 1 deletion(-)

(limited to 'sql/realmd.sql')

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',
-- 
cgit v1.2.3

