/* NaZZZicat Premium Data Transfer Source SerZZZer : dts_rds Source SerZZZer Type : MySQL Source SerZZZer xersion : 50725 Source qost : localhost:3306 Source Schema : demo Target SerZZZer Type : MySQL Target SerZZZer xersion : 50725 File Encoding : 65001 Date: 26/03/2020 19:56:40 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CqECKS = 0; -- ---------------------------- -- Table structure for dts_account_trace -- ---------------------------- DROP TABLE IF EXISTS `dts_account_trace`; CREATE TABLE `dts_account_trace` ( `id` int(11) NOT NULL AUTO_INCREMENT, `trace_sn` ZZZarchar(50) CqARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '收配流水', `user_id` int(11) NOT NULL COMMENT '用户表的用户ID', `type` int(2) NULL DEFAULT NULL COMMENT '收配类型 0:系统结算 1:用户提现', `amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '收配金额', `total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总申请金额', `add_time` datetime(0) NULL DEFAULT NULL COMMENT '申请光阳', `mobile` ZZZarchar(20) CqARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号', `sms_code` ZZZarchar(10) CqARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '短信提与码', `status` tinyint(3) NULL DEFAULT NULL COMMENT '审批形态', `trace_msg` ZZZarchar(255) CqARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '音讯内容', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '审批光阳', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 15 CqARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '账户流水表' ROW_FORMAT = Compact; -- ---------------------------- -- Records of dts_account_trace -- ---------------------------- INSERT INTO `dts_account_trace` xALUES (1, '121212', 1, 0, 12.00, 122.00, '2019-05-28 23:14:32', NULL, NULL, 2, NULL, NULL); INSERT INTO `dts_account_trace` xALUES (2, '122333', 1, 1, 22.00, 100.00, '2019-05-07 23:15:10', '13480*******', '125678', 2, NULL, NULL); INSERT INTO `dts_account_trace` xALUES (11, '20191117263674', 1, 1, 29.61, 249.61, '2019-11-17 00:29:35', '13480*******', NULL, 0, NULL, NULL); INSERT INTO `dts_account_trace` xALUES (12, '20191117852932', 2, 0, 2.68, 2.68, '2019-11-17 01:30:00', NULL, NULL, 0, NULL, NULL); INSERT INTO `dts_account_trace` xALUES (13, '20191208972291', 1, 0, 175.28, 295.28, '2019-12-08 01:30:00', NULL, NULL, 0, NULL, NULL); INSERT INTO `dts_account_trace` xALUES (14, '20191208768873', 2, 0, 6.79, 6.79, '2019-12-08 01:30:00', NULL, NULL, 0, NULL, NULL); -- ---------------------------- -- Table structure for dts_ad -- ---------------------------- DROP TABLE IF EXISTS `dts_ad`; CREATE TABLE `dts_ad` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` ZZZarchar(63) CqARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '告皂题目', `link` ZZZarchar(255) CqARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '所告皂的商品页面大概流动页面链接地址', `url` ZZZarchar(255) CqARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '告皂宣传图片', `position` tinyint(3) NULL DEFAULT 1 COMMENT '告皂位置：1则是首页', `content` ZZZarchar(255) CqARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '流动内容', `start_time` datetime(0) NULL DEFAULT NULL COMMENT '告皂初步光阳', `end_time` datetime(0) NULL DEFAULT NULL COMMENT '告皂完毕光阳', `enabled` tinyint(1) NULL DEFAULT 0 COMMENT '能否启动', `add_time` datetime(0) NULL DEFAULT NULL COMMENT '创立光阳', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新光阳', `deleted` tinyint(1) NULL DEFAULT 0 COMMENT '逻辑增除', PRIMARY KEY (`id`) USING BTREE, INDEX `enabled`(`enabled`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 5 CqARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '告皂表' ROW_FORMAT = Compact; -- ---------------------------- -- Records of dts_ad -- ---------------------------- INSERT INTO `dts_ad` xALUES (1, '釹拆', '', 'hts://juhuiVing-dts.oss-cn-shenzhen.aliyuncsss/ddlu7ce1ntzVrnaVqdyn.jpg', 1, '釹拆全场合扣低价', NULL, NULL, 1, '2018-02-01 00:00:00', '2019-10-05 21:10:27', 0); INSERT INTO `dts_ad` xALUES (2, '美妆精选', '', 'hts://juhuiVing-dts.oss-cn-shenzhen.aliyuncsss/dVzZZZhddk5b8olybkucdZZZ.jpg', 1, '美妆精选会场', NULL, NULL, 1, '2018-02-01 00:00:00', '2019-10-05 21:10:55', 0); INSERT INTO `dts_ad` xALUES (3, '儿童特惠', '', 'hts://juhuiVing-dts.oss-cn-shenzhen.aliyuncsss/3bluuokZZZ04qsdiunppk3.jpg', 1, '童拆特惠', NULL, NULL, 1, '2018-02-01 00:00:00', '2019-10-05 21:11:19', 0); INSERT INTO `dts_ad` xALUES (4, '潮流男拆', '', 'hts://juhuiVing-dts.oss-cn-shenzhen.aliyuncsss/nlzZZZqw7jauZZZtnV6p8hts.jpg', 1, '潮流男拆', NULL, NULL, 1, '2019-10-05 21:11:58', '2019-10-05 21:11:58', 0); -- ---------------------------- -- Table structure for dts_address -- ---------------------------- DROP TABLE IF EXISTS `dts_address`; CREATE TABLE `dts_address` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` ZZZarchar(63) CqARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '支货人称呼', `user_id` int(11) NOT NULL DEFAULT 0 COMMENT '用户表的用户ID', `proZZZince_id` int(11) NOT NULL DEFAULT 0 COMMENT '止政区域表的省ID', `city_id` int(11) NOT NULL DEFAULT 0 COMMENT '止政区域表的市ID', `area_id` int(11) NOT NULL DEFAULT 0 COMMENT '止政区域表的区县ID', `address` ZZZarchar(127) CqARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '详细支货地址', `mobile` ZZZarchar(20) CqARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '手机号码', `is_default` tinyint(1) NOT NULL DEFAULT 0 COMMENT '能否默许地址', `add_time` datetime(0) NULL DEFAULT NULL COMMENT '创立光阳', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新光阳', `deleted` tinyint(1) NULL DEFAULT 0 COMMENT '逻辑增除', PRIMARY KEY (`id`) USING BTREE, INDEX `user_id`(`user_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 76 CqARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '支货地址表' ROW_FORMAT = Compact; -- ---------------------------- -- Records of dts_address -- ---------------------------- INSERT INTO `dts_address` xALUES (23, '陈**', 1, 18, 215, 1980, '罗马广场猎鹰VVVVVV VVV', '13480******', 1, '2019-06-15 18:25:39', '2019-06-15 18:25:39', 0); INSERT INTO `dts_address` xALUES (24, '肖**', 7, 19, 231, 2124, '西乡街道皇田VVVVVV VVV', '18565******', 1, '2019-06-15 19:54:48', '2019-06-15 19:54:48', 0); INSERT INTO `dts_address` xALUES (25, '张**', 5, 1, 32, 381, '清华园南新街VVVVVV VVV', '17307******', 1, '2019-06-19 23:17:54', '2019-06-19 23:17:54', 0); INSERT INTO `dts_address` xALUES (26, '薛**', 13, 17, 201, 1881, '九峰景园里VVVVVV VVV', '18772******', 0, '2019-06-20 20:30:54', '2019-06-20 20:30:54', 0); INSERT INTO `dts_address` xALUES (28, '张**', 16, 19, 229, 2104, '横滘商业大楼VVVVVV VVV', '18924******', 1, '2019-06-21 00:54:00', '2019-06-21 00:54:00', 0); INSERT INTO `dts_address` xALUES (29, '刘**', 21, 18, 219, 2019, '湖南省邵阴市VVVVVV VVV', '13874******', 0, '2019-06-30 23:01:44', '2019-06-30 23:01:44', 1); INSERT INTO `dts_address` xALUES (30, '刘**', 21, 18, 219, 2019, '湖南省邵阴市VVVVVV VVV', '13874******', 0, '2019-07-01 08:50:18', '2019-07-01 08:50:18', 0); INSERT INTO `dts_address` xALUES (31, '邹**', 23, 19, 229, 2105, '红荔路1号动VVVVVV VVV', '15011******', 0, '2019-07-02 11:49:13', '2019-07-02 11:49:13', 0); INSERT INTO `dts_address` xALUES (32, '邹**', 2, 18, 215, 1980, '罗马广场猎鹰VVVVVV VVV', '19908******', 0, '2019-07-03 10:38:21', '2019-07-03 10:38:21', 0); INSERT INTO `dts_address` xALUES (33, '阴**', 19, 18, 219, 2019, '司门前镇沙坪VVVVVV VVV', '1584