diff options
Diffstat (limited to 'sql/characters.sql')
-rw-r--r-- | sql/characters.sql | 28 |
1 files changed, 4 insertions, 24 deletions
diff --git a/sql/characters.sql b/sql/characters.sql index aad75e81ee3..3e740d7876c 100644 --- a/sql/characters.sql +++ b/sql/characters.sql @@ -224,7 +224,7 @@ CREATE TABLE `characters` ( `zone` int(11) unsigned NOT NULL default '0', `death_expire_time` bigint(20) unsigned NOT NULL default '0', `taxi_path` text, - `arena_pending_points` int(10) UNSIGNED NOT NULL default '0', + `arena_pending_points` int(10) UNSIGNED NOT NULL default '0', `latency` int(11) unsigned NOT NULL default '0', PRIMARY KEY (`guid`), KEY `idx_account` (`account`), @@ -1297,6 +1297,7 @@ LOCK TABLES `petition_sign` WRITE; /*!40000 ALTER TABLE `petition_sign` DISABLE KEYS */; /*!40000 ALTER TABLE `petition_sign` ENABLE KEYS */; UNLOCK TABLES; +/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; -- -- Table structure for table `saved_variables` @@ -1305,7 +1306,7 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `saved_variables`; CREATE TABLE `saved_variables` ( `NextArenaPointDistributionTime` bigint(40) UNSIGNED NOT NULL DEFAULT '0' -) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Variable Saves'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Variable Saves'; -- -- Dumping data for table `saved_variables` @@ -1315,6 +1316,7 @@ LOCK TABLES `saved_variables` WRITE; /*!40000 ALTER TABLE `saved_variables` DISABLE KEYS */; /*!40000 ALTER TABLE `saved_variables` ENABLE KEYS */; UNLOCK TABLES; +/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; -- -- Table structure for table `game_event_condition_save` @@ -1377,28 +1379,6 @@ LOCK TABLES `has_logged_in_before` WRITE; /*!40000 ALTER TABLE `has_logged_in_before` ENABLE KEYS */; UNLOCK TABLES; -/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; - --- --- Table structure for table `saved_variables` --- - -DROP TABLE IF EXISTS `saved_variables`; -CREATE TABLE `saved_variables` ( - `NextArenaPointDistributionTime` bigint(40) UNSIGNED NOT NULL DEFAULT '0' -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Variable Saves'; - --- --- Dumping data for table `saved_variables` --- - -LOCK TABLES `saved_variables` WRITE; -/*!40000 ALTER TABLE `saved_variables` DISABLE KEYS */; -/*!40000 ALTER TABLE `saved_variables` ENABLE KEYS */; -UNLOCK TABLES; -/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; - - /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; |