· 7 years ago · Nov 07, 2018, 09:52 AM
1SET FOREIGN_KEY_CHECKS=0;
2
3DROP TABLE IF EXISTS `offline_shop_log`;
4CREATE TABLE `offline_shop_log` (
5 `player_name` varchar(99) NOT NULL,
6 `account_id` int(11) NOT NULL,
7 `shop_id` int(11) NOT NULL,
8 `action` varchar(255) NOT NULL,
9 `data` datetime NOT NULL,
10 `player_ip` varchar(15) NOT NULL,
11 `channel_id` int(3) NOT NULL
12) ENGINE=InnoDB DEFAULT CHARSET=latin1;