· 5 years ago · Nov 23, 2020, 08:58 AM
1DROP TABLE IF EXISTS `offline_shop_npc`;
2CREATE TABLE `offline_shop_npc` (
3 `owner_id` int(11) NOT NULL DEFAULT 0,
4 `sign` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
5 `name` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
6 `time` int(11) NULL DEFAULT NULL,
7 `x` int(11) NULL DEFAULT NULL,
8 `y` int(11) NULL DEFAULT NULL,
9 `z` int(11) NULL DEFAULT NULL,
10 `mapIndex` int(11) NULL DEFAULT NULL,
11 `channel` int(2) NULL DEFAULT NULL,
12 PRIMARY KEY (`owner_id`) USING BTREE
13) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
14
15