SHARE
TWEET

Untitled

a guest Jun 19th, 2017 48 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. UPDATE
  2. ALTER TABLE realmcharacters DROP INDEX acctid;
  3. ALTER TABLE realmcharacters ADD KEY (acctid);
  4.  
  5.  
  6. UPDATE
  7. SET NAMES utf8;
  8. SET FOREIGN_KEY_CHECKS = 0;
  9.  
  10. DROP TABLE IF EXISTS `mail_external`;
  11.  
  12. CREATE TABLE `mail_external` (
  13.   `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  14.   `receiver` BIGINT(20) UNSIGNED NOT NULL,
  15.   `subject` VARCHAR(200) DEFAULT 'Support Message',
  16.   `message` VARCHAR(500) DEFAULT 'Support Message',
  17.   `money` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  18.   `item` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  19.   `item_count` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  20.   PRIMARY KEY (`id`)
  21. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  22.  
  23.  
  24. SET FOREIGN_KEY_CHECKS = 1;
  25.  
  26.  
  27. UPDATE
  28. ALTER TABLE realmlist
  29.   ADD COLUMN realmbuilds VARCHAR(64) NOT NULL DEFAULT '' AFTER population;
  30.  
  31.  
  32. ALTER TABLE realmlist
  33.   CHANGE COLUMN color realmflags tinyint(3) UNSIGNED NOT NULL DEFAULT '2'
  34.   COMMENT 'Supported masks: 0x1 (invalid, not show in realm list), 0x2 (offline, set by mangosd), 0x4 (show version and build), 0x20 (new players), 0x40 (recommended)';
  35.  
  36. UPDATE realmlist
  37.   SET realmflags = realmflags & ~(0x01 | 0x04 | 0x20 | 0x40) ;
  38.  
  39. UPDATE realmlist
  40.   SET realmflags = realmflags | 0x02;
RAW Paste Data
Top