众筹商城源码 众筹商品平台 商城加共识元富之路 网上商城众筹 前端是编译后的,后端PHP,带商城
运行截图
源码贡献
gitee典康姆/lz-code/php_code_mulshop.git 注意修改典康姆
部分数据库表
CREATE TABLE `ti_shopro_store` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`name` varchar(50) NOT NULL COMMENT '门店名称',
`images` varchar(2500) NOT NULL COMMENT '门店图片',
`realname` varchar(50) NOT NULL COMMENT '联系人',
`phone` varchar(20) NOT NULL COMMENT '联系电话',
`province_name` varchar(50) NOT NULL COMMENT '省',
`city_name` varchar(50) NOT NULL COMMENT '市',
`area_name` varchar(50) NOT NULL COMMENT '区',
`province_id` int(11) NOT NULL COMMENT '省ID',
`city_id` int(11) NOT NULL COMMENT '市ID',
`area_id` int(11) NOT NULL COMMENT '区ID',
`address` varchar(255) NOT NULL COMMENT '详细地址',
`latitude` decimal(10,6) DEFAULT NULL COMMENT '纬度',
`longitude` decimal(10,6) DEFAULT NULL COMMENT '经度',
`store` enum('0','1') NOT NULL DEFAULT '0' COMMENT '支持配送:0=否,1=是',
`selfetch` enum('0','1') NOT NULL DEFAULT '0' COMMENT '支持自提:0=否,1=是',
`service_type` varchar(20) NOT NULL COMMENT '服务范围',
`service_radius` int(11) NOT NULL DEFAULT '0' COMMENT '服务半径',
`service_province_ids` varchar(1200) DEFAULT NULL COMMENT '服务行政省',
`service_city_ids` varchar(1200) DEFAULT NULL COMMENT '服务行政市',
`service_area_ids` varchar(1200) DEFAULT NULL COMMENT '服务行政区',
`openhours` varchar(20) NOT NULL COMMENT '营业时间',
`openweeks` set('1','2','3','4','5','6','7') NOT NULL DEFAULT '1,2,3,4,5,6,7' COMMENT '营业天数',
`status` enum('0','1') NOT NULL DEFAULT '1' COMMENT '门店状态:0=禁用,1=启用',
`createtime` int(11) NOT NULL COMMENT '创建时间',
`updatetime` int(11) NOT NULL COMMENT '更新时间',
`deletetime` int(11) DEFAULT NULL COMMENT '删除时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='门店';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ti_shopro_store`
--
LOCK TABLES `ti_shopro_store` WRITE;
/*!40000 ALTER TABLE `ti_shopro_store` DISABLE KEYS */;
/*!40000 ALTER TABLE `ti_shopro_store` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ti_shopro_store_apply`
--
DROP TABLE IF EXISTS `ti_shopro_store_apply`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ti_shopro_store_apply` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL COMMENT '用户',
`name` varchar(50) NOT NULL COMMENT '门店名称',
`images` varchar(2500) NOT NULL COMMENT '门店图片',
`realname` varchar(50) NOT NULL COMMENT '联系人',
`phone` varchar(20) NOT NULL COMMENT '联系电话',
`province_name` varchar(50) NOT NULL COMMENT '省',
`city_name` varchar(50) NOT NULL COMMENT '市',
`area_name` varchar(50) NOT NULL COMMENT '区',
`province_id` int(11) NOT NULL COMMENT '省ID',
`city_id` int(11) NOT NULL COMMENT '市ID',
`area_id` int(11) NOT NULL COMMENT '区ID',
`address` varchar(255) NOT NULL COMMENT '详细地址',
`latitude` decimal(10,6) NOT NULL DEFAULT '0.000000' COMMENT '纬度',
`longitude` decimal(10,6) NOT NULL DEFAULT '0.000000' COMMENT '经度',
`openhours` varchar(20) NOT NULL COMMENT '营业时间',
`openweeks` set('1','2','3','4','5','6','7') NOT NULL DEFAULT '1,2,3,4,5,6,7' COMMENT '营业天数',
`apply_num` int(10) NOT NULL DEFAULT '0' COMMENT '申请次数',
`status` enum('-1','0','1') NOT NULL DEFAULT '0' COMMENT '审核状态:-1驳回,0=未审核,1=已通过',
`status_msg` varchar(255) DEFAULT NULL COMMENT '驳回原因',
`createtime` int(11) NOT NULL COMMENT '创建时间',
`updatetime` int(11) NOT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='门店入驻';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ti_shopro_store_apply`
--
LOCK TABLES `ti_shopro_store_apply` WRITE;
/*!40000 ALTER TABLE `ti_shopro_store_apply` DISABLE KEYS */;
/*!40000 ALTER TABLE `ti_shopro_store_apply` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ti_shopro_user_address`
--
DROP TABLE IF EXISTS `ti_shopro_user_address`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ti_shopro_user_address` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`is_default` enum('0','1') DEFAULT '0' COMMENT '默认',
`user_id` int(11) DEFAULT NULL COMMENT '用户',
`consignee` varchar(20) DEFAULT NULL COMMENT '收货人',
`phone` varchar(20) DEFAULT NULL COMMENT '联系电话',
`province_name` varchar(20) DEFAULT NULL COMMENT '省',
`city_name` varchar(20) DEFAULT NULL COMMENT '市',
`area_name` varchar(20) DEFAULT NULL COMMENT '区',
`address` varchar(255) DEFAULT NULL COMMENT '详细地址',
`province_id` int(11) DEFAULT NULL,
`city_id` int(11) DEFAULT NULL,
`area_id` int(11) DEFAULT NULL,
`latitude` decimal(10,6) DEFAULT NULL COMMENT '纬度',
`longitude` decimal(10,6) DEFAULT NULL COMMENT '经度',
`createtime` int(11) DEFAULT NULL,
`updatetime` int(11) DEFAULT NULL,
`deletetime` int(11) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户地址';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ti_shopro_user_address`
--
LOCK TABLES `ti_shopro_user_address` WRITE;
/*!40000 ALTER TABLE `ti_shopro_user_address` DISABLE KEYS */;
/*!40000 ALTER TABLE `ti_shopro_user_address` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ti_shopro_user_bank`
--
DROP TABLE IF EXISTS `ti_shopro_user_bank`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ti_shopro_user_bank` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL COMMENT '用户id',
`type` enum('bank','alipay') DEFAULT NULL COMMENT '账户类型:bank=银行卡,alipay=支付宝账户',
`real_name` varchar(191) DEFAULT NULL COMMENT '真实姓名',
`bank_name` varchar(191) DEFAULT NULL COMMENT '银行名',
`card_no` varchar(191) DEFAULT NULL COMMENT '卡号',
`is_default` tinyint(1) unsigned DEFAULT '0' COMMENT '是否默认',
`createtime` int(11) DEFAULT NULL COMMENT '创建时间',
`updatetime` int(11) DEFAULT NULL COMMENT '更新时间',
`deletetime` int(11) DEFAULT NULL COMMENT '删除时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='提现银行卡';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ti_shopro_user_bank`
--
LOCK TABLES `ti_shopro_user_bank` WRITE;
/*!40000 ALTER TABLE `ti_shopro_user_bank` DISABLE KEYS */;
INSERT INTO `ti_shopro_user_bank` VALUES (1,33,'bank','你不','ffghh','568999',0,1652075864,1652075864,NULL);
/*!40000 ALTER TABLE `ti_shopro_user_bank` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ti_shopro_user_coupons`
--
DROP TABLE IF EXISTS `ti_shopro_user_coupons`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ti_shopro_user_coupons` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) DEFAULT NULL COMMENT '用户',
`coupons_id` int(11) DEFAULT NULL COMMENT '优惠券',
`use_order_id` int(11) NOT NULL DEFAULT '0' COMMENT '订单 id',
`usetime` int(11) DEFAULT NULL COMMENT '使用时间',
`createtime` int(11) DEFAULT NULL COMMENT '领取时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户优惠券';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ti_shopro_user_coupons`
--
LOCK TABLES `ti_shopro_user_coupons` WRITE;
/*!40000 ALTER TABLE `ti_shopro_user_coupons` DISABLE KEYS */;
/*!40000 ALTER TABLE `ti_shopro_user_coupons` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ti_shopro_user_fake`
--
DROP TABLE IF EXISTS `ti_shopro_user_fake`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ti_shopro_user_fake` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nickname` varchar(20) NOT NULL COMMENT '昵称',
`avatar` varchar(255) NOT NULL COMMENT '头像',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='虚拟用户';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ti_shopro_user_fake`
--
LOCK TABLES `ti_shopro_user_fake` WRITE;
/*!40000 ALTER TABLE `ti_shopro_user_fake` DISABLE KEYS */;
/*!40000 ALTER TABLE `ti_shopro_user_fake` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ti_shopro_user_favorite`
--
DROP TABLE IF EXISTS `ti_shopro_user_favorite`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ti_shopro_user_favorite` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) DEFAULT NULL COMMENT '用户',
`goods_id` int(11) DEFAULT NULL COMMENT '商品',
`createtime` int(11) DEFAULT NULL,
`updatetime` int(11) DEFAULT NULL,
`deletetime` int(11) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户收藏';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ti_shopro_user_favorite`
--
LOCK TABLES `ti_shopro_user_favorite` WRITE;
/*!40000 ALTER TABLE `ti_shopro_user_favorite` DISABLE KEYS */;
/*!40000 ALTER TABLE `ti_shopro_user_favorite` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ti_shopro_user_oauth`
--
DROP TABLE IF EXISTS `ti_shopro_user_oauth`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ti_shopro_user_oauth` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned DEFAULT '0' COMMENT '用户',
`provider` varchar(50) NOT NULL COMMENT '厂商',
`platform` varchar(50) NOT NULL COMMENT '平台',
`unionid` varchar(50) DEFAULT NULL COMMENT '厂商ID',
`openid` varchar(50) NOT NULL COMMENT '平台ID',
`nickname` varchar(255) DEFAULT '' COMMENT '昵称',
`sex` tinyint(1) DEFAULT '0' COMMENT '性别',
`country` varchar(50) DEFAULT NULL COMMENT '国家',
`province` varchar(50) DEFAULT NULL COMMENT '省',
`city` varchar(50) DEFAULT NULL COMMENT '市',
`headimgurl` varchar(500) DEFAULT '' COMMENT '头像',
`logintime` int(11) DEFAULT NULL COMMENT '登录时间',
`logincount` int(11) DEFAULT '0' COMMENT '累计登陆',
`expire_in` int(11) DEFAULT NULL COMMENT '过期周期(s)',
`expiretime` int(11) DEFAULT NULL COMMENT '过期时间',
`session_key` varchar(45) DEFAULT '' COMMENT 'session_key',
`refresh_token` varchar(110) DEFAULT NULL COMMENT 'refresh_token',
`access_token` varchar(110) DEFAULT NULL COMMENT 'access_token',
`createtime` int(10) DEFAULT '0' COMMENT '创建时间',
`updatetime` int(10) DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
KEY `openid` (`openid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='第三方授权';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ti_shopro_user_oauth`
--
LOCK TABLES `ti_shopro_user_oauth` WRITE;
/*!40000 ALTER TABLE `ti_shopro_user_oauth` DISABLE KEYS */;
/*!40000 ALTER TABLE `ti_shopro_user_oauth` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ti_shopro_user_sign`
--
DROP TABLE IF EXISTS `ti_shopro_user_sign`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ti_shopro_user_sign` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL DEFAULT '0' COMMENT '用户',
`date` varchar(30) DEFAULT NULL COMMENT '签到日期',
`score` int(11) NOT NULL DEFAULT '0' COMMENT '所得积分',
`is_replenish` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否补签:0=正常,1=补签',
`createtime` int(11) DEFAULT NULL COMMENT '创建时间',
`updatetime` int(11) DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
KEY `date` (`date`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户签到';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ti_shopro_user_sign`
--
LOCK TABLES `ti_shopro_user_sign` WRITE;
/*!40000 ALTER TABLE `ti_shopro_user_sign` DISABLE KEYS */;
/*!40000 ALTER TABLE `ti_shopro_user_sign` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ti_shopro_user_store`
--
DROP TABLE IF EXISTS `ti_shopro_user_store`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ti_shopro_user_store` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL COMMENT '用户',
`store_id` int(11) NOT NULL COMMENT '门店',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='门店管理员';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ti_shopro_user_store`
--
LOCK TABLES `ti_shopro_user_store` WRITE;
/*!40000 ALTER TABLE `ti_shopro_user_store` DISABLE KEYS */;
/*!40000 ALTER TABLE `ti_shopro_user_store` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ti_shopro_user_view`
--
DROP TABLE IF EXISTS `ti_shopro_user_view`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ti_shopro_user_view` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL DEFAULT '0' COMMENT '用户',
`goods_id` int(11) NOT NULL DEFAULT '0' COMMENT '商品',
`createtime` int(11) DEFAULT NULL COMMENT '添加时间',
`updatetime` int(11) DEFAULT NULL COMMENT '更新时间',
`deletetime` int(11) DEFAULT NULL COMMENT '删除时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='用户浏览记录';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ti_shopro_user_view`
--
LOCK TABLES `ti_shopro_user_view` WRITE;
/*!40000 ALTER TABLE `ti_shopro_user_view` DISABLE KEYS */;
INSERT INTO `ti_shopro_user_view` VALUES (1,23,3,1648550453,1648550453,NULL);
/*!40000 ALTER TABLE `ti_shopro_user_view` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ti_shopro_user_wallet_apply`
--
DROP TABLE IF EXISTS `ti_shopro_user_wallet_apply`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ti_shopro_user_wallet_apply` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL COMMENT '提现用户',
`apply_sn` varchar(60) DEFAULT NULL COMMENT '提现单号',
`apply_type` enum('bank','wechat','alipay') DEFAULT NULL COMMENT '收款类型:bank=银行卡,wechat=微信零钱,alipay=支付宝',
`money` decimal(10,2) NOT NULL COMMENT '提现金额',
`actual_money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '实际到账',
`charge_money` decimal(10,2) NOT NULL COMMENT '手续费',
`service_fee` decimal(10,3) DEFAULT NULL COMMENT '手续费率',
`apply_info` varchar(255) DEFAULT NULL COMMENT '打款信息',
`status` tinyint(1) DEFAULT '0' COMMENT '提现状态:-1=已拒绝,0=待审核,1=处理中,2=已处理',
`platform` varchar(20) DEFAULT NULL COMMENT '平台',
`payment_json` varchar(2500) DEFAULT NULL COMMENT '交易原始数据',
`createtime` int(11) DEFAULT NULL COMMENT '申请时间',
`updatetime` int(11) DEFAULT NULL COMMENT '操作时间',
`log` text COMMENT '操作日志',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `apply_sn` (`apply_sn`) USING BTREE COMMENT '提现单号'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户提现';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ti_shopro_user_wallet_apply`
--
LOCK TABLES `ti_shopro_user_wallet_apply` WRITE;
/*!40000 ALTER TABLE `ti_shopro_user_wallet_apply` DISABLE KEYS */;
/*!40000 ALTER TABLE `ti_shopro_user_wallet_apply` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ti_shopro_user_wallet_log`
--
DROP TABLE IF EXISTS `ti_shopro_user_wallet_log`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ti_shopro_user_wallet_log` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '日志 id',
`user_id` int(11) NOT NULL DEFAULT '0' COMMENT '用户',
`wallet` decimal(10,2) NOT NULL COMMENT '变动金额',
`wallet_type` enum('money','score') NOT NULL COMMENT '日志类型:money=余额,score=积分',
`type` varchar(30) NOT NULL COMMENT '变动类型',
`before` decimal(10,2) NOT NULL COMMENT '变动前',
`after` decimal(10,2) NOT NULL COMMENT '变动后',
`item_id` varchar(60) DEFAULT NULL COMMENT '项目 id',
`memo` varchar(255) DEFAULT '' COMMENT '备注',
`ext` varchar(512) DEFAULT NULL COMMENT '附加字段',
`oper_type` enum('user','store','admin','system') NOT NULL DEFAULT 'user' COMMENT '操作人类型',
`oper_id` int(11) NOT NULL DEFAULT '0' COMMENT '操作人',
`createtime` int(11) DEFAULT NULL COMMENT '创建时间',
`updatetime` int(11) DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='钱包日志';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ti_shopro_user_wallet_log`
--
LOCK TABLES `ti_shopro_user_wallet_log` WRITE;
/*!40000 ALTER TABLE `ti_shopro_user_wallet_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `ti_shopro_user_wallet_log` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ti_shopro_verify`
--
DROP TABLE IF EXISTS `ti_shopro_verify`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ti_shopro_verify` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL COMMENT '用户',
`type` varchar(30) DEFAULT 'verify' COMMENT '类型:verify=核销券',
`code` varchar(20) NOT NULL COMMENT '核销码',
`order_id` int(11) NOT NULL DEFAULT '0' COMMENT '订单',
`order_item_id` int(11) NOT NULL DEFAULT '0' COMMENT '订单商品',
`usetime` int(11) DEFAULT NULL COMMENT '使用时间',
`expiretime` int(11) DEFAULT NULL COMMENT '过期时间',
`oper_type` enum('user','store','admin','system') DEFAULT NULL COMMENT '操作人类型',
`oper_id` int(11) NOT NULL DEFAULT '0' COMMENT '操作人',
`createtime` int(11) DEFAULT NULL COMMENT '添加时间',
`updatetime` int(11) DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `code` (`code`) USING BTREE COMMENT '核销码'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='二维码';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ti_shopro_verify`
--
LOCK TABLES `ti_shopro_verify` WRITE;
/*!40000 ALTER TABLE `ti_shopro_verify` DISABLE KEYS */;
/*!40000 ALTER TABLE `ti_shopro_verify` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ti_shopro_wechat`
--
DROP TABLE IF EXISTS `ti_shopro_wechat`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ti_shopro_wechat` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`type` varchar(50) NOT NULL COMMENT '配置类型',
`name` varchar(50) NOT NULL COMMENT '名称',
`rules` varchar(255) DEFAULT NULL COMMENT '规则',
`content` text NOT NULL COMMENT '内容',
`createtime` int(11) NOT NULL COMMENT '创建时间',
`updatetime` int(11) NOT NULL COMMENT '更新时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='微信管理';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ti_shopro_wechat`
--
LOCK TABLES `ti_shopro_wechat` WRITE;
/*!40000 ALTER TABLE `ti_shopro_wechat` DISABLE KEYS */;
/*!40000 ALTER TABLE `ti_shopro_wechat` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ti_shopro_wechat_fans`
--
DROP TABLE IF EXISTS `ti_shopro_wechat_fans`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ti_shopro_wechat_fans` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`nickname` varchar(50) DEFAULT NULL COMMENT '粉丝昵称',
`headimgurl` varchar(255) DEFAULT NULL COMMENT '粉丝头像',
`openid` varchar(30) DEFAULT NULL COMMENT 'openid',
`sex` int(11) DEFAULT '0' COMMENT '性别',
`country` varchar(50) DEFAULT NULL COMMENT '国家',
`province` varchar(50) DEFAULT NULL COMMENT '省',
`city` varchar(50) DEFAULT NULL COMMENT '市',
`subscribe` enum('0','1') DEFAULT NULL COMMENT '关注状态:0=取消关注,1=已关注',
`subscribe_time` int(11) DEFAULT NULL COMMENT '关注时间',
`createtime` int(11) DEFAULT NULL COMMENT '创建时间',
`updatetime` int(11) DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='粉丝管理';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ti_shopro_wechat_fans`
--
LOCK TABLES `ti_shopro_wechat_fans` WRITE;
/*!40000 ALTER TABLE `ti_shopro_wechat_fans` DISABLE KEYS */;
/*!40000 ALTER TABLE `ti_shopro_wechat_fans` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ti_sms`
--
DROP TABLE IF EXISTS `ti_sms`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ti_sms` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
`event` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '事件',
`mobile` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '手机号',
`code` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '验证码',
`times` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '验证次数',
`ip` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'IP',
`createtime` int(10) unsigned DEFAULT '0' COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='短信验证码表';