2vE1NfBt

1DROP TABLE IF EXISTS `auction_house`;
2CREATE TABLE `auction_house` (
3  `itemId` int(10) unsigned NOT NULL DEFAULT '0',
4  `ownerId` int(10) unsigned NOT NULL DEFAULT '0',
5  `count` mediumint(8) unsigned NOT NULL DEFAULT '0',
6  `sale_price` bigint(20) unsigned NOT NULL DEFAULT '0',
7  `expiration_time` bigint(20) unsigned NOT NULL DEFAULT '0',
8  PRIMARY KEY (`itemId`)
9) ENGINE=InnoDB DEFAULT CHARSET=utf8;
10
11DROP TABLE IF EXISTS `character_votes`;
12CREATE TABLE `character_votes` (
13  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
14  `data` varchar(255) NOT NULL,
15  `scope` varchar(255) NOT NULL,
16  `time` bigint(20) unsigned NOT NULL,
17  PRIMARY KEY (`id`)
18) ENGINE=InnoDB DEFAULT CHARSET=utf8;