API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 28th, 2023
464
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.02 KB | None | 0 0
raw download clone embed print report
  1. -- AUTH DB
  2.  
  3. -- --------------------------------------------------------
  4. -- Host: 127.0.0.1
  5. -- Server version: 5.5.9-log - MySQL Community Server (GPL)
  6. -- Server OS: Win32
  7. -- HeidiSQL Version: 11.1.0.6116
  8. -- --------------------------------------------------------
  9.  
  10. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  11. /*!40101 SET NAMES utf8 */;
  12. /*!50503 SET NAMES utf8mb4 */;
  13. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  14. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  15. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  16.  
  17. -- Dumping structure for table mop_auth.member_premiums
  18. CREATE TABLE IF NOT EXISTS `member_premiums` (
  19. `id` int(11) NOT NULL AUTO_INCREMENT,
  20. `member_id` mediumint(8) NOT NULL,
  21. `setdate` bigint(40) NOT NULL,
  22. `unsetdate` bigint(40) NOT NULL,
  23. `active` tinyint(1) NOT NULL DEFAULT '1',
  24. `card_id` int(11) DEFAULT NULL,
  25. PRIMARY KEY (`id`),
  26. KEY `fk__nighthold_member_premium__members1_idx` (`member_id`),
  27. KEY `fk__nighthold_member_premiums__nighthold_member_items1_idx` (`card_id`)
  28. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='lotus Premium Members';
  29.  
  30. -- Dumping data for table mop_auth.member_premiums: ~0 rows (approximately)
  31. /*!40000 ALTER TABLE `member_premiums` DISABLE KEYS */;
  32. /*!40000 ALTER TABLE `member_premiums` ENABLE KEYS */;
  33.  
  34. -- Dumping structure for table mop_auth.member_rewards
  35. CREATE TABLE IF NOT EXISTS `member_rewards` (
  36. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  37. `member_id` int(10) unsigned NOT NULL,
  38. `character_guid` int(10) unsigned NOT NULL,
  39. `account_id` int(10) unsigned NOT NULL,
  40. `realmid` int(10) unsigned NOT NULL,
  41. `source_type` tinyint(3) unsigned NOT NULL,
  42. `source_id` int(10) unsigned NOT NULL,
  43. `reward_amount` int(10) unsigned NOT NULL,
  44. `reward_date` int(10) unsigned NOT NULL,
  45. `reward_day` int(10) unsigned NOT NULL COMMENT 'Used only for indexing purposes',
  46. `processed` tinyint(3) unsigned NOT NULL DEFAULT '0',
  47. `process_date` int(10) unsigned NOT NULL DEFAULT '0',
  48. PRIMARY KEY (`id`),
  49. KEY `member_id_reward_day_source_type` (`member_id`,`reward_day`,`source_type`),
  50. KEY `idx__member_id` (`member_id`),
  51. KEY `idx__processed` (`processed`)
  52. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='lotus Member Rewards';
  53.  
  54. -- Dumping data for table mop_auth.member_rewards: ~1 rows (approximately)
  55. /*!40000 ALTER TABLE `member_rewards` DISABLE KEYS */;
  56. INSERT INTO `member_rewards` (`id`, `member_id`, `character_guid`, `account_id`, `realmid`, `source_type`, `source_id`, `reward_amount`, `reward_date`, `reward_day`, `processed`, `process_date`) VALUES
  57. (1, 0, 247, 2, 1, 10, 247, 1, 1643275122, 19019, 0, 0);
  58. /*!40000 ALTER TABLE `member_rewards` ENABLE KEYS */;
  59.  
  60. -- Dumping structure for table mop_auth.member_settings
  61. CREATE TABLE IF NOT EXISTS `member_settings` (
  62. `member_id` int(10) unsigned NOT NULL,
  63. `setting` int(10) unsigned NOT NULL COMMENT 'nightholdMemberInfo::Setting in core',
  64. `value` varchar(255) NOT NULL,
  65. PRIMARY KEY (`member_id`,`setting`)
  66. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='lotus Member Settings';
  67.  
  68. -- Dumping data for table mop_auth.member_settings: ~0 rows (approximately)
  69. /*!40000 ALTER TABLE `member_settings` DISABLE KEYS */;
  70. /*!40000 ALTER TABLE `member_settings` ENABLE KEYS */;
  71.  
  72. /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
  73. /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
  74. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  75. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  76.  
  77. -- --------------------------------------------------------
  78. -- Host: 127.0.0.1
  79. -- Server version: 5.5.9-log - MySQL Community Server (GPL)
  80. -- Server OS: Win32
  81. -- HeidiSQL Version: 11.1.0.6116
  82. -- --------------------------------------------------------
  83.  
  84. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  85. /*!40101 SET NAMES utf8 */;
  86. /*!50503 SET NAMES utf8mb4 */;
  87. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  88. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  89. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  90.  
  91. -- Dumping structure for table mop_auth.autobroadcast
  92. DROP TABLE IF EXISTS `autobroadcast`;
  93. CREATE TABLE IF NOT EXISTS `autobroadcast` (
  94. `id` int(10) DEFAULT NULL,
  95. `weight` int(10) DEFAULT NULL,
  96. `text` longtext,
  97. `text_1` longtext,
  98. `text_2` longtext,
  99. `text_3` longtext,
  100. `text_4` longtext,
  101. `text_5` longtext,
  102. `text_6` longtext,
  103. `text_7` longtext,
  104. `RealmID` int(11) DEFAULT NULL
  105. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  106.  
  107. -- Dumping data for table mop_auth.autobroadcast: ~2 rows (approximately)
  108. /*!40000 ALTER TABLE `autobroadcast` DISABLE KEYS */;
  109. INSERT INTO `autobroadcast` (`id`, `weight`, `text`, `text_1`, `text_2`, `text_3`, `text_4`, `text_5`, `text_6`, `text_7`, `RealmID`) VALUES
  110. (1, 1, 'Welcome to Emucoach\'s official Mists of Pandaria Repack. This is running on the paid version. ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
  111. (2, 1, 'You can always post questions, submit bugs and join the conversations at the Emucoach forum (Emucoach.com)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1);
  112. /*!40000 ALTER TABLE `autobroadcast` ENABLE KEYS */;
  113.  
  114. /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
  115. /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
  116. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  117. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  118.  
  119.  
  120. ALTER TABLE battlenet_accounts
  121. CHANGE COLUMN emucoach_member_id member_id INT(10) UNSIGNED NULL DEFAULT NULL;
  122.  
  123. ALTER TABLE battlenet_accounts
  124. CHANGE COLUMN emucoach_is_temp is_temp TINYINT(1) NULL DEFAULT '0' COMMENT 'nighthold';
  125.  
  126.  
  127. ALTER TABLE account
  128. CHANGE COLUMN emucoach_member_id member_id INT(30) UNSIGNED NOT NULL DEFAULT '0',
  129. CHANGE COLUMN emucoach_verified verified TINYINT(1) NOT NULL DEFAULT '0',
  130. CHANGE COLUMN emucoach_is_free is_free TINYINT(1) NOT NULL DEFAULT '0',
  131. CHANGE COLUMN emucoach_is_temp is_temp TINYINT(1) NOT NULL DEFAULT '0',
  132. CHANGE COLUMN emucoach_unban_count unban_count TINYINT(4) NOT NULL DEFAULT '0',
  133. CHANGE COLUMN emucoach_antierror antierror INT(10) UNSIGNED NULL DEFAULT NULL,
  134. CHANGE COLUMN emucoach_attached attached INT(10) UNSIGNED NULL DEFAULT NULL,
  135. CHANGE COLUMN emucoach_passchange passchange INT(10) UNSIGNED NOT NULL DEFAULT '0',
  136. CHANGE COLUMN emucoach_vote_time vote_time BIGINT(20) NOT NULL DEFAULT '0',
  137. CHANGE COLUMN emucoach_hwid hwid VARCHAR(40) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci';
  138.  
  139.  
  140. ALTER TABLE realmlist
  141. CHANGE COLUMN emucoach_shortname shortname VARCHAR(32) NOT NULL COLLATE 'utf8_general_ci',
  142. ADD COLUMN `hidden` TINYINT(1) NULL DEFAULT NULL,
  143. ADD COLUMN `enabled` TINYINT(1) NULL DEFAULT NULL,
  144. ADD COLUMN `dbname` VARCHAR(32) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
  145. ADD COLUMN `dbworld` VARCHAR(32) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
  146. ADD COLUMN `dbarchive` VARCHAR(32) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
  147. ADD COLUMN `rates_min` TINYINT(4) NULL DEFAULT NULL,
  148. ADD COLUMN `rates_max` TINYINT(4) NULL DEFAULT NULL,
  149. ADD COLUMN `transfer_level_max` TINYINT(4) NULL DEFAULT NULL,
  150. ADD COLUMN `transfer_items` ENUM('IGNORE','IMPORT','REPLACE','SELECT') NULL DEFAULT NULL COLLATE 'utf8_general_ci',
  151. ADD COLUMN `transfer_skills_spells` ENUM('IGNORE','IMPORT','REPLACE','SELECT') NULL DEFAULT NULL COLLATE 'utf8_general_ci',
  152. ADD COLUMN `transfer_glyphs` ENUM('IGNORE','IMPORT') NULL DEFAULT NULL COLLATE 'utf8_general_ci',
  153. ADD COLUMN `transfer_achievements` ENUM('IGNORE','IMPORT') NULL DEFAULT NULL COLLATE 'utf8_general_ci',
  154. ADD COLUMN `server_same` TINYINT(1) NULL DEFAULT NULL,
  155. ADD COLUMN `server_settings` VARCHAR(32) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
  156. ADD COLUMN `server_remote_path` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
  157. ADD COLUMN `accounts_detach` TINYINT(1) NULL DEFAULT NULL,
  158. ADD COLUMN `setskills_value_max` SMALLINT(6) NULL DEFAULT NULL,
  159. ADD COLUMN `chat_enabled` TINYINT(1) NULL DEFAULT NULL,
  160. ADD COLUMN `statistics_enabled` TINYINT(1) NULL DEFAULT NULL;
  161.  
  162. -- Dumping structure for table mop_auth.betatesters
  163. CREATE TABLE IF NOT EXISTS `betatesters` (
  164. `id` int(11) NOT NULL,
  165. `betatest_id` int(11) NOT NULL,
  166. `member_id` mediumint(8) NOT NULL,
  167. `account_id` int(11) unsigned NOT NULL,
  168. PRIMARY KEY (`id`),
  169. KEY `fk__isengard_betatesters__members1_idx` (`member_id`) USING BTREE,
  170. KEY `fk__isengard_betatesters__account1_idx` (`account_id`) USING BTREE,
  171. KEY `fk__isengard_betatesters__isengard_betatests1_idx` (`betatest_id`) USING BTREE,
  172. KEY `fk__isengard_betatesters__isengard_betatest_accounts1_idx` (`id`) USING BTREE
  173. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
  174.  
  175. -- Dumping data for table mop_auth.betatesters: ~0 rows (approximately)
  176. /*!40000 ALTER TABLE `betatesters` DISABLE KEYS */;
  177. /*!40000 ALTER TABLE `betatesters` ENABLE KEYS */;
  178.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!