ygTsULxU

1-- Table structure for payment_codes
2-- ----------------------------
3DROP TABLE IF EXISTS `payment_codes`;
4CREATE TABLE `payment_codes`  (
5  `id` int(255) NOT NULL AUTO_INCREMENT,
6  `code` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
7  `amount` int(255) NULL DEFAULT 1,
8  `timeAdd` int(30) NULL DEFAULT NULL,
9  `whoAdd` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
10  `user` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
11  `giveTime` int(30) NULL DEFAULT NULL,
12  `status` int(5) NULL DEFAULT 0,
13  PRIMARY KEY (`id`, `code`) USING BTREE
14) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
15
16-- ----------------------------
17-- Table structure for payment_codes_items
18-- ----------------------------
19DROP TABLE IF EXISTS `payment_codes_items`;
20CREATE TABLE `payment_codes_items`  (
21  `id` int(255) NOT NULL AUTO_INCREMENT,
22  `code` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
23  `vnum` int(255) NULL DEFAULT 1,
24  `timeAdd` int(30) NULL DEFAULT NULL,
25  `whoAdd` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
26  `user` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
27  `giveTime` int(30) NULL DEFAULT NULL,
28  `status` int(5) NULL DEFAULT 0,
29  PRIMARY KEY (`id`, `code`) USING BTREE
30) ENGINE = InnoDB AUTO_INCREMENT = 942 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;