diff options
| -rw-r--r-- | sql/realmd.sql | 22 | ||||
| -rw-r--r-- | sql/updates/7938_01_realmd_account.sql | 4 |
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 |