SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for broker
-- ----------------------------
DROP TABLE IF EXISTS `broker`;
CREATE TABLE `broker` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`item_pointer` int(11) NOT NULL DEFAULT '0',
`item_id` int(11) NOT NULL,
`item_count` bigint(20) NOT NULL,
`item_creator` varchar(50) DEFAULT NULL,
`seller` varchar(50) DEFAULT NULL,
`price` bigint(20) NOT NULL DEFAULT '0',
`broker_race` enum('ELYOS','ASMODIAN') NOT NULL,
`expire_time` timestamp NOT NULL DEFAULT '2010-01-01 02:00:00',
`settle_time` timestamp NOT NULL DEFAULT '2010-01-01 02:00:00',
`seller_id` int(11) NOT NULL,
`is_sold` tinyint(1) NOT NULL,
`is_settled` tinyint(1) NOT NULL,
`is_splitsell` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
KEY `seller_id` (`seller_id`),
CONSTRAINT `broker_ibfk_1` FOREIGN KEY (`seller_id`) REFERENCES `players` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;