WKtN1g7Q

1/*
2Navicat MySQL Data Transfer
3
4Source Server         : Private - SW1
5Source Server Version : 50505
6Source Host           : localhost:3306
7Source Database       : wow_characters
8
9Target Server Type    : MYSQL
10Target Server Version : 50505
11File Encoding         : 65001
12
13Date: 2017-11-30 16:40:37
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for character_bonus_codes
20-- ----------------------------
21DROP TABLE IF EXISTS `character_bonus_codes`;
22CREATE TABLE `character_bonus_codes` (
23  `account_id` bigint(20) unsigned NOT NULL,
24  `player_name` varchar(12) CHARACTER SET utf8 NOT NULL DEFAULT '',
25  `bonus_code` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
26  `status` tinyint(3) unsigned NOT NULL,
27  PRIMARY KEY (`account_id`)
28) ENGINE=InnoDB DEFAULT CHARSET=latin1;