diff options
| -rw-r--r-- | sql/realmd.sql | 23 | ||||
| -rw-r--r-- | sql/updates/4859_8332_01_realmd_realmcharacters.sql | 4 |
2 files changed, 26 insertions, 1 deletions
diff --git a/sql/realmd.sql b/sql/realmd.sql index a57e244d760..effad3d3e32 100644 --- a/sql/realmd.sql +++ b/sql/realmd.sql @@ -16,6 +16,26 @@ /*!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_8332_01_realmd_realmcharacters` 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; +/*!40000 ALTER TABLE `realmd_db_version` DISABLE KEYS */; +INSERT INTO `realmd_db_version` VALUES +(NULL); +/*!40000 ALTER TABLE `realmd_db_version` ENABLE KEYS */; +UNLOCK TABLES; + +-- -- Table structure for table `account` -- @@ -134,7 +154,8 @@ CREATE TABLE `realmcharacters` ( `realmid` int(11) unsigned NOT NULL default '0', `acctid` bigint(20) unsigned NOT NULL, `numchars` tinyint(3) unsigned NOT NULL default '0', - PRIMARY KEY (`realmid`,`acctid`) + PRIMARY KEY (`realmid`,`acctid`), + KEY (acctid) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Realm Character Tracker'; -- diff --git a/sql/updates/4859_8332_01_realmd_realmcharacters.sql b/sql/updates/4859_8332_01_realmd_realmcharacters.sql new file mode 100644 index 00000000000..c7adb23d890 --- /dev/null +++ b/sql/updates/4859_8332_01_realmd_realmcharacters.sql @@ -0,0 +1,4 @@ +-- ALTER TABLE realmd_db_version CHANGE COLUMN required_7938_01_realmd_account required_8332_01_realmd_realmcharacters bit; + +ALTER TABLE realmcharacters + ADD KEY (acctid); |