DROP TABLE IF EXISTS `ad`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `ad` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `title` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '标题', `type_id` int DEFAULT NULL COMMENT '广告类型', `code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '调用别名', `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'url', `img` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '图片', `sort` int DEFAULT '0' COMMENT '排序', `create_time` int DEFAULT NULL COMMENT '创建时间', `update_time` int DEFAULT '0' COMMENT '更新时间', `status` int unsigned DEFAULT '0' COMMENT '状态', `action_type` int DEFAULT '1' COMMENT '跳转类型 0 不跳转 1webview 2小程序页面', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='广告'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ad` -- -- -- Table structure for table `ad_type` -- DROP TABLE IF EXISTS `ad_type`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `ad_type` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '类型名称', `code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '调用别名', `remark` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注', `create_time` int unsigned DEFAULT NULL COMMENT '创建时间', `update_time` int unsigned DEFAULT NULL COMMENT '更新时间', `status` int DEFAULT '0' COMMENT '状态', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='广告类型'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ad_type` -- -- -- Dumping data for table `agent` -- -- -- Table structure for table `card` -- DROP TABLE IF EXISTS `card`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `card` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `agent_id` int DEFAULT NULL, `card_type` int DEFAULT NULL COMMENT '1盛京通卡 2通用联名电子卡', `card_no` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '卡号', `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `create_time` int unsigned NOT NULL DEFAULT '0' COMMENT '创建时间', `update_time` int unsigned NOT NULL DEFAULT '0' COMMENT '修改时间', `state` int unsigned NOT NULL DEFAULT '1' COMMENT '状态 1绑定 2解绑 通用联名电子卡不可解绑', `face_value` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '面值', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `card_no` (`card_no`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT COMMENT='卡'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `card` -- -- -- Table structure for table `category` -- DROP TABLE IF EXISTS `category`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `category` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '类别id', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '类别名称', `parent_id` int DEFAULT '0' COMMENT '上级id', `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '分类图片', `level` int DEFAULT '0' COMMENT '层级', `state` int DEFAULT '1' COMMENT '状态1可用2不可用', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=777709 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='分类表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `category` -- -- -- Table structure for table `city` -- DROP TABLE IF EXISTS `city`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `city` ( `id` bigint DEFAULT NULL COMMENT '地区id', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '地区名称', `level` int DEFAULT '0' COMMENT '层级省市区县1,2,3,4', `parent_id` bigint DEFAULT '0' COMMENT '上级id', `state` int DEFAULT '1' COMMENT '状态1可用', `sort` int DEFAULT '0' COMMENT '排序数值越大越靠前' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT COMMENT='省、市、区、街道'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `city` -- -- -- Table structure for table `config` -- DROP TABLE IF EXISTS `config`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `config` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `key` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '名称', `value` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '值', `state` int DEFAULT '2' COMMENT '状态 1可用 2禁用', PRIMARY KEY (`id`), UNIQUE KEY `key_state` (`key`,`state`) USING BTREE COMMENT 'key_state唯一' ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `config` -- -- -- Table structure for table `delivery_address` -- DROP TABLE IF EXISTS `delivery_address`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `delivery_address` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '收货地址id', `user_id` int DEFAULT '0' COMMENT '用户id', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '姓名', `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '手机号', `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '详细地址', `receiver_province` bigint DEFAULT '0' COMMENT '省', `receiver_city` bigint DEFAULT '0' COMMENT '市', `receiver_district` bigint DEFAULT '0' COMMENT '区', `receiver_town` bigint DEFAULT '0' COMMENT '街道', `state` int DEFAULT '1' COMMENT '是否可用1正常2禁用3删除（不显示）', `is_default` int DEFAULT '0' COMMENT '是否常用1是 2否', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='用户收货地址表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `delivery_address` -- -- -- Table structure for table `express_company` -- DROP TABLE IF EXISTS `express_company`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `express_company` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '表序号', `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '物流公司名称', `code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '物流编号', `state` int NOT NULL DEFAULT '1' COMMENT '使用状态 1可用 2禁用', `sort` int DEFAULT NULL COMMENT '优先级 值越大越优先', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci AVG_ROW_LENGTH=420 ROW_FORMAT=COMPACT COMMENT='物流公司'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `express_company` -- -- -- Table structure for table `goods` -- DROP TABLE IF EXISTS `goods`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `goods` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '商品名称', `price` decimal(10,2) DEFAULT '0.00' COMMENT '售卖价', `cost_price` decimal(10,2) DEFAULT '0.00' COMMENT '成本价', `sales_num` bigint DEFAULT '0' COMMENT '销售数量', `click_num` bigint DEFAULT '0' COMMENT '点击次数', `category_id1` int DEFAULT '0' COMMENT '一级类别id', `category_id2` int DEFAULT '0' COMMENT '二级类别id', `category_id3` int DEFAULT '0' COMMENT '三级类别id', `goods_type` int DEFAULT '1' COMMENT '订单类型 1实物产品 2虚拟产品', `supplier_id` int DEFAULT NULL COMMENT '所属供应商id', `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '商品主图', `slide_image` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '商品轮播(多个用,隔开)', `detail` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '商品详情', `instructions` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '简介', `sort` int DEFAULT '0' COMMENT '排序', `state` int DEFAULT '1' COMMENT '状态1可用2不可用', `stock` bigint DEFAULT '0' COMMENT '库存', `spu_id` int DEFAULT '0' COMMENT '主商品ID', `spu_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '主商品名称', `lowest_buy` int DEFAULT '1' COMMENT '最小起购量', `create_time` int DEFAULT '0' COMMENT '创建时间', `update_time` int DEFAULT '0' COMMENT '修改时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=10007 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='商品表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `goods` -- -- -- Table structure for table `merchant` -- DROP TABLE IF EXISTS `merchant`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `merchant` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `number` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '编号', `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '名称', `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密码', `salt` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '随机码', `login_num` int DEFAULT '0' COMMENT '登录次数', `login_time` int unsigned NOT NULL DEFAULT '0' COMMENT '登录时间', `login_ip` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '登录ip', `last_login_time` int unsigned NOT NULL DEFAULT '0' COMMENT '上次登录时间', `last_login_ip` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '上次登录ip', `rsa_public_key` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '公钥', `aes_key` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'aes秘钥', `create_time` int unsigned DEFAULT NULL COMMENT '创建时间', `update_time` int unsigned DEFAULT '0' COMMENT '修改时间', `state` int DEFAULT NULL COMMENT '状态 1可用 2禁用', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `number` (`number`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT COMMENT='商户'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `merchant` -- -- -- Table structure for table `orders` -- DROP TABLE IF EXISTS `orders`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `orders` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '订单id', `order_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '订单号', `user_id` int DEFAULT '0' COMMENT '用户ID', `auth_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '付款码', `card_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '卡号', `sjt_card_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '盛京通卡号', `amount` decimal(10,2) DEFAULT '0.00' COMMENT '订单金额', `cost_amount` decimal(10,2) DEFAULT '0.00' COMMENT '成本金额', `freight_amount` decimal(10,2) DEFAULT '0.00' COMMENT '运费', `discount_amount` decimal(10,2) DEFAULT '0.00' COMMENT '优惠金额', `pay_amount` decimal(10,2) DEFAULT '0.00' COMMENT '实际支付金额', `device_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '设备编号', `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '订单描述', `goods_detail` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '订单详情 json', `goods_tag` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '订单优惠标记', `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '地址', `order_type` int DEFAULT '1' COMMENT '订单类型 1实物订单 2虚拟订单', `pay_type` int DEFAULT '0' COMMENT '支付类型1积分2礼券', `pay_state` int DEFAULT '0' COMMENT '0未支付1支付中2支付成功3已退款4支付失败5订单关闭', `state` int DEFAULT '0' COMMENT '订单状态0未发货1已发货2收货成功3已退货', `user_phone` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户手机号', `merchant_id` int DEFAULT '0' COMMENT '商户id', `merchant_no` int DEFAULT NULL COMMENT '商户号', `supplier_id` int DEFAULT '0' COMMENT '供货商id', `address_id` int DEFAULT '0' COMMENT '地址id', `receiver_mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '收货人手机号', `recevier_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '收货人姓名', `recevier_province` bigint DEFAULT '0' COMMENT '收货人所在省', `recevier_city` bigint DEFAULT '0' COMMENT '收货人所在市', `recevier_district` bigint DEFAULT '0' COMMENT '收货人所在区', `recevier_town` bigint DEFAULT '0' COMMENT '收货人所在街道', `create_time` int DEFAULT '0' COMMENT '创建时间', `update_time` int DEFAULT '0' COMMENT '更新时间', `refund_time` int DEFAULT '0' COMMENT '退款时间', `close_time` int DEFAULT '0' COMMENT '订单关闭时间', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '管理员备注信息', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `order_no` (`order_no`) USING BTREE COMMENT '订单号唯一' ) ENGINE=InnoDB AUTO_INCREMENT=114 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='订单表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orders` -- -- -- Table structure for table `orders_goods` -- DROP TABLE IF EXISTS `orders_goods`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `orders_goods` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '订单商品表id', `order_id` int DEFAULT '0' COMMENT '订单表id', `order_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '订单号', `goods_id` int DEFAULT '0' COMMENT '商品id', `goods_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '商品名称', `goods_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '商品图片', `goods_type` int DEFAULT '1' COMMENT '1实物产品2虚拟订单', `supplier_id` int DEFAULT '0' COMMENT '供货商id', `cost_price` decimal(10,2) DEFAULT '0.00' COMMENT '成本价', `price` decimal(10,2) DEFAULT '0.00' COMMENT '售价', `num` int DEFAULT '0' COMMENT '数量', `freight_amount` decimal(10,2) DEFAULT '0.00' COMMENT '运费', `state` int DEFAULT '0' COMMENT '状态(0未发货、1已发货)', `express_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '快递名称', `express_no` int DEFAULT NULL COMMENT '单号', `create_time` int DEFAULT '0' COMMENT '创建时间', `update_time` int DEFAULT '0' COMMENT '修改时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='订单商品表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orders_goods` -- -- -- Table structure for table `orders_refund` -- DROP TABLE IF EXISTS `orders_refund`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `orders_refund` ( `id` int NOT NULL COMMENT 'id', `order_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '订单号', `refund_order_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '退款订单号', `refund_amount` decimal(10,2) DEFAULT NULL COMMENT '退款金额', `create_time` int DEFAULT NULL COMMENT '退款时间', `update_time` int DEFAULT NULL COMMENT '更新时间', `state` int DEFAULT NULL COMMENT '0未退款1退款中2退款成功3退款失败', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `refund_order_no` (`refund_order_no`) USING BTREE COMMENT 'refund_order_no' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT COMMENT='退款'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orders_refund` -- -- -- Table structure for table `organization` -- DROP TABLE IF EXISTS `organization`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `organization` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '分行网点id', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '分行网点名称', `parent_id` int DEFAULT '0' COMMENT '上级id', `level` int DEFAULT '4' COMMENT '层级', `create_time` int DEFAULT '0' COMMENT '床渐渐时间', `update_time` int DEFAULT '0' COMMENT '修改时间', `state` int DEFAULT '1' COMMENT '状态1可用2不可用', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='组织架构表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `organization` -- -- -- Table structure for table `supplier` -- DROP TABLE IF EXISTS `supplier`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `supplier` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '供货商名称', `username` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户名', `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密码', `salt` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '随机码', `phone` char(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '手机号码', `realname` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '姓名', `login_num` int DEFAULT '0' COMMENT '登录次数', `login_time` int unsigned NOT NULL DEFAULT '0' COMMENT '登录时间', `login_ip` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '登录ip', `last_login_time` int unsigned NOT NULL DEFAULT '0' COMMENT '上次登录时间', `last_login_ip` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '上次登录ip', `create_time` int unsigned NOT NULL COMMENT '创建时间', `update_time` int unsigned NOT NULL DEFAULT '0' COMMENT '修改时间', `state` tinyint unsigned DEFAULT '2' COMMENT '1 启用 2 禁用', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `username` (`username`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT COMMENT='管理员'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `supplier` -- -- -- Table structure for table `user` -- -- Dumping data for table `user` -- -- -- Table structure for table `user_card` -- DROP TABLE IF EXISTS `user_card`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user_card` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `user_id` int unsigned NOT NULL COMMENT '用户id', `agent_id` int DEFAULT NULL COMMENT '代理商', `card_no` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '卡号', `sjt_card_no` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '盛京通卡卡号', `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密码', `auth_code` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '付款码70_75开头16位随机数', `create_time` int unsigned NOT NULL DEFAULT '0' COMMENT '创建时间', `update_time` int unsigned NOT NULL DEFAULT '0' COMMENT '修改时间', `state` int unsigned NOT NULL DEFAULT '1' COMMENT '状态 1绑定 2解绑 通用联名电子卡不可解绑', `balance` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '余额', `is_default` int DEFAULT '2' COMMENT '默认 1 是 2否', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT COMMENT='用户卡'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_card` -- -- -- Table structure for table `user_card_balance_record` -- DROP TABLE IF EXISTS `user_card_balance_record`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user_card_balance_record` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `user_id` int unsigned NOT NULL COMMENT '用户id', `card_no` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '卡号', `amount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '变动金额', `amount_before` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '变动前金额', `amount_after` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '变动后金额', `order_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '订单号', `type` int NOT NULL COMMENT '类型 1消费 2退款', `remark` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注', `create_time` int unsigned NOT NULL COMMENT '创建时间', `update_time` int unsigned NOT NULL DEFAULT '0' COMMENT '修改时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT COMMENT='卡余额变动'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_card_balance_record` -- -- -- Table structure for table `xt_orders` -- DROP TABLE IF EXISTS `xt_orders`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `xt_orders` ( `id` int NOT NULL COMMENT 'id', `order_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '订单号', `order_no_sort` varchar(34) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '子订单号', `card_no` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '卡号', `amount` decimal(10,2) DEFAULT NULL COMMENT '金额', `create_time` int DEFAULT NULL COMMENT '创建时间', `update_time` int DEFAULT NULL COMMENT '更新时间', `state` int DEFAULT NULL COMMENT '支付状态 1待处理 2处理中 3支付成功 4支付失败', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT COMMENT='新天订单'; /*!40101 SET character_set_client = @saved_cs_client */;