-- Table structure for table `ey_search_word`
--

CREATE TABLE `ey_search_word` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `word` varchar(255) DEFAULT '' COMMENT '关键词',
  `searchNum` int(10) DEFAULT '1' COMMENT '搜索次数',
  `sort_order` int(10) DEFAULT '0' COMMENT '排序号',
  `lang` varchar(30) DEFAULT 'cn' COMMENT '语言标识',
  `add_time` int(11) DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `word` (`word`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='搜索词统计表';

--
-- Dumping data for table `ey_search_word`
--


--
-- Table structure for table `ey_setting`
--

CREATE TABLE `ey_setting` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT '' COMMENT '配置的key键名',
  `value` text,
  `inc_type` varchar(64) DEFAULT '' COMMENT '配置分组',
  `lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `inc_type` (`inc_type`,`lang`)
) ENGINE=MyISAM AUTO_INCREMENT=48 DEFAULT CHARSET=utf8 COMMENT='系统非全局配置表';

--
-- Dumping data for table `ey_setting`
--

INSERT INTO `ey_setting` VALUES (1,'adminlogin_427d1aac31a93d744edd637f1fbbf00c','0','adminlogin','cn',1720403666),(2,'adminlogin_a62896d354440964bb1db242596917b1','0','adminlogin','cn',1720403666),(3,'adminlogin_99ae1cc546e0ed202a83693c75f1afe0','0','adminlogin','cn',1720403666),(4,'ask_ques_steps','1、写问题标题，描述具体现象。杜绝 “求救，大佬，小白…” 等和问题无关的词汇。\r\n2、选择问题的分类，选择正确的内容分类，能更快的得到其他人的回复。\r\n3、遇到的问题比较急需解决，可以给问题悬赏一定的金额报酬，能让更多同行参与进来出谋策划，从中选择自己心仪的答案。\r\n4、写问题内容详细描述你碰到的困难，写清楚你尝试了什么方法，错误代码，软件的版本等，更容易得到答案。\r\n5、点击发布。','ask','cn',1711520788),(5,'admin_logic_1649299958','1','syn','cn',1711520788),(6,'system_old_product_attr','0','system','cn',1711604663),(7,'syn_admin_logic_1625725290','1','syn','cn',1711520789),(8,'syn_admin_logic_1629252424','1','syn','cn',1711520789),(9,'admin_logic_1634204189','1','syn','cn',1711520789),(10,'admin_logic_1634280892','1','syn','cn',1711520789),(11,'admin_logic_1635326854','1','syn','cn',1711520789),(12,'admin_logic_1635389623','1','syn','cn',1711520789),(13,'admin_logic_1636875693','1','syn','cn',1711520789),(14,'admin_logic_1637033990','1','syn','cn',1711520789),(15,'admin_logic_1640918327','1','syn','cn',1711520789),(16,'admin_logic_1638857408','1','syn','cn',1711520789),(17,'admin_logic_1643352860','2','syn','cn',1711520789),(18,'admin_logic_1643352862','1','syn','cn',1711520789),(19,'admin_logic_1643352863','1','syn','cn',1711520789),(20,'security_askanswer_list','[\"\\u60a8\\u5e38\\u7528\\u7684\\u624b\\u673a\\u53f7\\u7801\\u662f\\uff1f\",\"\\u60a8\\u5e38\\u7528\\u7684\\u7535\\u5b50\\u90ae\\u7bb1\\u662f\\uff1f\",\"\\u60a8\\u771f\\u5b9e\\u7684\\u59d3\\u540d\\u662f\\uff1f\",\"\\u60a8\\u521d\\u4e2d\\u5b66\\u6821\\u540d\\u662f\\uff1f\",\"\\u60a8\\u7684\\u51fa\\u751f\\u5730\\u540d\\u662f\\uff1f\",\"\\u60a8\\u914d\\u5076\\u7684\\u59d3\\u540d\\u662f\\uff1f\",\"\\u60a8\\u7684\\u8eab\\u4efd\\u8bc1\\u53f7\\u540e\\u516b\\u4f4d\\u662f\\uff1f\",\"\\u60a8\\u9ad8\\u4e2d\\u73ed\\u4e3b\\u4efb\\u7684\\u540d\\u5b57\\u662f\\uff1f\",\"\\u60a8\\u521d\\u4e2d\\u73ed\\u4e3b\\u4efb\\u7684\\u540d\\u5b57\\u662f\\uff1f\",\"\\u60a8\\u6700\\u559c\\u6b22\\u7684\\u660e\\u661f\\u540d\\u5b57\\u662f\\uff1f\",\"\\u5bf9\\u60a8\\u5f71\\u54cd\\u6700\\u5927\\u7684\\u4eba\\u540d\\u5b57\\u662f\\uff1f\"]','security','cn',1711520789),(21,'admin_logic_1643352864','1','syn','cn',1711520789),(22,'admin_logic_1647918733','1','syn','cn',1711520789),(23,'system_originlist','[\"\\u7f51\\u7edc\"]','system','cn',1711520789),(24,'admin_logic_1648435161','1','syn','cn',1711520789),(25,'admin_logic_1648882158','1','syn','cn',1711520789),(26,'admin_logic_1649399344','1','syn','cn',1711520789),(27,'adminlogin_69b603004c871191c464ee87b59dcdf0','5','adminlogin','cn',1719555947),(28,'adminlogin_a4ab76d0c3fa2269c91f4a8b1dfa29f3','1719555947','adminlogin','cn',1719555947),(29,'adminlogin_c15108ec3d1556279ea8544b93102ea4','1','adminlogin','cn',1719555947),(30,'adminlogin_2215e9001dfda84a6a3ea126d61846be','5','adminlogin','cn',1719555988),(31,'adminlogin_7518083beaab74df852c8b92b686ed8c','1719555988','adminlogin','cn',1719555988),(32,'adminlogin_fb9347d1e345c480aa1479890f4a4289','1','adminlogin','cn',1719555988),(33,'adminlogin_eae6341dd69a1fffba4c637bbcb0e0ab','5','adminlogin','cn',1719556029),(34,'adminlogin_df836d63c334566467ac1f00a3cb0061','1719556029','adminlogin','cn',1719556029),(35,'adminlogin_272d6f61c7b08ee4d24bd25e731f285b','1','adminlogin','cn',1719556029),(36,'adminlogin_c156051e02fc823b26c0f7c7e8734689','5','adminlogin','cn',1719556071),(37,'adminlogin_2692d00c5a78f1a9ad50d0ed937d3853','1719556071','adminlogin','cn',1719556071),(38,'adminlogin_f2c5251e3e9b85d57fda8718422376f0','1','adminlogin','cn',1719556071),(39,'adminlogin_99dd0819e11d2177a0ffc01ddbec2907','5','adminlogin','cn',1719556115),(40,'adminlogin_2a3ca41b2503035f3341cc19d2492387','1719556115','adminlogin','cn',1719556115),(41,'adminlogin_05845e70ddba6304140c7609a705982e','1','adminlogin','cn',1719556115),(42,'adminlogin_e4261b928cd9e13ecb5aee904c650246','5','adminlogin','cn',1719556156),(43,'adminlogin_49b9e1d0cc3ecb9825a12183b3c7943d','1719556156','adminlogin','cn',1719556156),(44,'adminlogin_e195475e0668232027e36ad7d70dca84','1','adminlogin','cn',1719556156),(45,'adminlogin_58a23765647fa2392aeb9b9532eb1242','5','adminlogin','cn',1719554299),(46,'adminlogin_bfb08358f37bf12c48189e80f9471d09','1719554299','adminlogin','cn',1719554299),(47,'adminlogin_3d1ec4a899683991dd25e1b463f7a338','1','adminlogin','cn',1719554299);

--
-- Table structure for table `ey_sharp_active`
--

CREATE TABLE `ey_sharp_active` (
  `active_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '活动会场ID',
  `active_date` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '活动日期',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '活动状态(0禁用 1启用)',
  `is_del` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除',
  `lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
  `add_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`active_id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='整点秒杀-活动会场表';

--
-- Dumping data for table `ey_sharp_active`
--


--
-- Table structure for table `ey_sharp_active_goods`
--

CREATE TABLE `ey_sharp_active_goods` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `active_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '活动会场ID',
  `active_time_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '活动场次ID',
  `aid` int(11) NOT NULL DEFAULT '0' COMMENT '文档id',
  `sharp_goods_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '秒杀商品ID',
  `sales_actual` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '实际销量',
  `lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
  `add_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='整点秒杀-活动会场与商品关联表';

--
-- Dumping data for table `ey_sharp_active_goods`
--


--
-- Table structure for table `ey_sharp_active_time`
--

CREATE TABLE `ey_sharp_active_time` (
  `active_time_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '场次ID',
  `active_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '活动会场ID',
  `active_time` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '场次时间(0点-23点)',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '活动状态(0禁用 1启用)',
  `lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
  `add_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`active_time_id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='整点秒杀-活动会场场次表';

--
-- Dumping data for table `ey_sharp_active_time`
--


--
-- Table structure for table `ey_sharp_goods`
--

CREATE TABLE `ey_sharp_goods` (
  `sharp_goods_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '秒杀商品ID',
  `aid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '商品ID->aid',
  `limit` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '限购数量',
  `seckill_stock` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '秒杀商品库存总量',
  `seckill_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '秒杀价格',
  `sales` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '累积销量',
  `virtual_sales` int(11) NOT NULL DEFAULT '0' COMMENT '虚拟销量',
  `sort_order` int(11) unsigned NOT NULL DEFAULT '100' COMMENT '商品排序(数字越小越靠前)',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '商品状态(0下架 1上架)',
  `is_del` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除',
  `is_sku` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1-多规格商品',
  `lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
  `add_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`sharp_goods_id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='整点秒杀-商品表';

--
-- Dumping data for table `ey_sharp_goods`
--


--
-- Table structure for table `ey_sharp_setting`
--

CREATE TABLE `ey_sharp_setting` (
  `key` varchar(30) NOT NULL DEFAULT '' COMMENT '设置项标示',
  `describe` varchar(255) NOT NULL DEFAULT '' COMMENT '设置项描述',
  `values` mediumtext NOT NULL COMMENT '设置内容(json格式)',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  UNIQUE KEY `unique_key` (`key`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='整点秒杀设置表';

--
-- Dumping data for table `ey_sharp_setting`
--


--
-- Table structure for table `ey_shop_address`
--

CREATE TABLE `ey_shop_address` (
  `addr_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '地址id',
  `users_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员id',
  `consignee` varchar(60) NOT NULL DEFAULT '' COMMENT '收货人',
  `country` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '国家',
  `province` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '省份',
  `city` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '城市',
  `district` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '县区',
  `address` varchar(500) NOT NULL DEFAULT '' COMMENT '详细地址',
  `zipcode` varchar(10) NOT NULL DEFAULT '' COMMENT '邮政编码',
  `mobile` varchar(20) NOT NULL DEFAULT '' COMMENT '手机',
  `is_default` tinyint(1) DEFAULT '0' COMMENT '是否默认，0否，1是。',
  `lang` varchar(30) DEFAULT 'cn' COMMENT '语言标识',
  `add_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`addr_id`),
  KEY `users_id` (`users_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='收货地址表';

--
-- Dumping data for table `ey_shop_address`
--


--
-- Table structure for table `ey_shop_cart`
--

CREATE TABLE `ey_shop_cart` (
  `cart_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '购物车表',
  `users_id` int(10) unsigned DEFAULT '0' COMMENT '会员id',
  `product_id` int(10) unsigned DEFAULT '0' COMMENT '产品id',
  `product_num` int(10) unsigned DEFAULT '0' COMMENT '购买数量',
  `spec_value_id` varchar(100) DEFAULT '' COMMENT '规格值ID',
  `selected` tinyint(1) DEFAULT '1' COMMENT '购物车选中状态：0未选中，1选中',
  `lang` varchar(30) DEFAULT 'cn' COMMENT '语言标识',
  `add_time` int(11) DEFAULT '0' COMMENT '加入购物车的时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`cart_id`),
  KEY `users_id` (`users_id`,`product_id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='购物车表';

--
-- Dumping data for table `ey_shop_cart`
--


--
-- Table structure for table `ey_shop_coupon`
--

CREATE TABLE `ey_shop_coupon` (
  `coupon_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `coupon_code` varchar(100) NOT NULL DEFAULT '' COMMENT '优惠券编号',
  `coupon_name` varchar(100) NOT NULL DEFAULT '' COMMENT '优惠券名称',
  `coupon_color` varchar(25) NOT NULL DEFAULT '' COMMENT '优惠券颜色',
  `coupon_form` tinyint(1) NOT NULL DEFAULT '1' COMMENT '优惠券类型 1-满减券',
  `coupon_type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '可使用商品(1全站通用，2指定商品，3指定商品分类)',
  `product_id` varchar(255) NOT NULL DEFAULT '' COMMENT '指定商品ID，在coupon_type=2时使用',
  `arctype_id` varchar(255) NOT NULL DEFAULT '' COMMENT '指定商品分类ID，在coupon_type=3时使用',
  `coupon_price` decimal(10,0) NOT NULL DEFAULT '0' COMMENT '优惠券金额，例如10',
  `conditions_use` decimal(10,0) NOT NULL DEFAULT '0' COMMENT '优惠券使用条件，例如300',
  `coupon_stock` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '优惠券库存，例如100',
  `redeem_points` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '兑换优惠券所需积分，为0则表示免费兑换',
  `redeem_authority` varchar(10) NOT NULL DEFAULT '' COMMENT '兑换权限，存入多个会员等级组ID',
  `valid_days` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '有效天数，例如30',
  `start_date` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '优惠券开放领取时间',
  `end_date` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '优惠券结束领取时间',
  `sort_order` int(11) unsigned NOT NULL DEFAULT '100' COMMENT '规格排序号',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '优惠券状态(0=关闭，1=开启)',
  `use_type` int(1) NOT NULL DEFAULT '1' COMMENT '使用期限 \r\n1-固定日期\r\n 2-领取后当天开始N(valid_days)天内有效\r\n 2-领取后次日开始N(valid_days)天内有效',
  `use_start_time` int(11) NOT NULL COMMENT '使用期限开始时间',
  `use_end_time` int(11) NOT NULL COMMENT '使用期限结束时间',
  `is_del` tinyint(1) DEFAULT '0' COMMENT '0-未删除 1-已删除',
  `lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
  `add_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`coupon_id`),
  KEY `product_id` (`product_id`) USING BTREE,
  KEY `arctype_id` (`arctype_id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='优惠券主表';

--
-- Dumping data for table `ey_shop_coupon`
--


--
-- Table structure for table `ey_shop_coupon_use`
--

CREATE TABLE `ey_shop_coupon_use` (
  `use_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `users_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '会员ID',
  `coupon_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '优惠券ID',
  `coupon_code` varchar(100) NOT NULL DEFAULT '' COMMENT '优惠券编号',
  `get_ip` varchar(15) NOT NULL DEFAULT '' COMMENT '领取时的IP地址',
  `get_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '优惠券领取时的时间',
  `use_status` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '优惠券使用状态(0未使用，1已使用，2已过期，3已冻结)',
  `use_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '优惠券使用时的时间',
  `start_time` int(10) NOT NULL DEFAULT '0' COMMENT '优惠券有效开始时间',
  `end_time` int(10) NOT NULL DEFAULT '0' COMMENT '优惠券有效结束时间',
  `lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
  `add_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`use_id`),
  KEY `coupon_id` (`coupon_id`) USING BTREE,
  KEY `coupon_code` (`coupon_code`) USING BTREE,
  KEY `users_id` (`users_id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='优惠券-领取记录表';

--
-- Dumping data for table `ey_shop_coupon_use`
--


--
-- Table structure for table `ey_shop_express`
--

CREATE TABLE `ey_shop_express` (
  `express_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `express_code` varchar(32) NOT NULL DEFAULT '' COMMENT '物流code',
  `express_name` varchar(32) NOT NULL DEFAULT '' COMMENT '物流名称',
  `express_lnitials` varchar(5) NOT NULL DEFAULT '' COMMENT '首字母',
  `is_choose` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '快递公司是否选中(0=否，1=是)',
  `sort_order` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序号',
  `add_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`express_id`)
) ENGINE=MyISAM AUTO_INCREMENT=597 DEFAULT CHARSET=utf8 COMMENT='快递公司表';

--
-- Dumping data for table `ey_shop_express`
--

INSERT INTO `ey_shop_express` VALUES (1,'yuantong','圆通快递','Y',1,97,1553911076,1554974797),(2,'shentong','申通快递','S',1,98,1553911076,1554974707),(3,'shunfeng','顺丰快递','S',1,98,1553911076,1554974710),(4,'yunda','韵达快递','Y',1,99,1553911076,1553911076),(5,'debangwuliu','德邦快递','D',1,99,1553911076,1553911076),(6,'zhongtong','中通快递','Z',1,99,1553911076,1553911076),(7,'huitongkuaidi','百世快递','B',1,99,1553911076,1553911076),(8,'youzhengguonei','邮政包裹','Y',1,99,1553911076,1553911076),(9,'ems','EMS','E',1,99,1553911076,1553911076),(10,'youzhengguoji','邮政国际','Y',1,99,1553911076,1553911076),(11,'aolau','AOL澳通速递','A',1,100,1553911076,1553911076),(12,'a2u','A2U速递','A',1,100,1553911076,1553911076),(13,'aae','AAE快递','A',1,100,1553911076,1553911076),(14,'annengwuliu','安能物流','A',1,100,1553911076,1553911076),(15,'anxl','安迅物流','A',1,100,1553911076,1553911076),(16,'auexpress','澳邮中国快运','A',1,100,1553911076,1553911076),(17,'exfresh','安鲜达','A',1,100,1553911076,1553911076),(18,'anjie88','安捷物流','A',1,100,1553911076,1553911076),(19,'adodoxm','澳多多国际速递','A',1,100,1553911076,1553911076),(20,'ariesfar','艾瑞斯远','A',1,100,1553911076,1553911076),(21,'qdants','ANTS EXPRESS','A',1,100,1553911076,1553911076),(22,'astexpress','安世通快递','A',1,100,1553911076,1553911076),(23,'gda','安的快递','A',1,100,1553911076,1553911076),(24,'ausexpress','澳世速递','A',1,100,1553911076,1553911076),(25,'ibuy8','爱拜物流','A',1,100,1553911076,1553911076),(26,'aplusex','Aplus物流','A',1,100,1553911076,1553911076),(27,'adapost','安达速递','A',1,100,1553911076,1553911076),(28,'adiexpress','安达易国际速递','A',1,100,1553911076,1553911076),(29,'maxeedexpress','澳洲迈速快递','A',1,100,1553911076,1553911076),(30,'onway','昂威物流','A',1,100,1553911076,1553911076),(31,'bcwelt','BCWELT','B',1,100,1553911076,1553911076),(32,'balunzhi','巴伦支快递','B',1,100,1553911076,1553911076),(33,'xiaohongmao','北青小红帽','B',1,100,1553911076,1553911076),(34,'bfdf','百福东方物流','B',1,100,1553911076,1553911076),(35,'bangsongwuliu','邦送物流','B',1,100,1553911076,1553911076),(36,'lbbk','宝凯物流','B',1,100,1553911076,1553911076),(37,'bqcwl','百千诚物流','B',1,100,1553911076,1553911076),(38,'idada','百成大达物流','B',1,100,1553911076,1553911076),(39,'baishiwuliu','百世快运','B',1,100,1553911076,1553911076),(40,'baitengwuliu','百腾物流','B',1,100,1553911076,1553911076),(41,'birdex','笨鸟海淘','B',1,100,1553911076,1553911076),(42,'bsht','百事亨通','B',1,100,1553911076,1553911076),(43,'benteng','奔腾物流','B',1,100,1553911076,1553911076),(44,'cuckooexpess','布谷鸟速递','B',1,100,1553911076,1553911076),(45,'bgky100','邦工快运','B',1,100,1553911076,1553911076),(46,'bosind','堡昕德速递','B',1,100,1553911076,1553911076),(47,'banma','斑马物联网','B',1,100,1553911076,1553911076),(48,'polarisexpress','北极星快运','B',1,100,1553911076,1553911076),(49,'beijingfengyue','北京丰越供应链','B',1,100,1553911076,1553911076),(50,'europe8','败欧洲','B',1,100,1553911076,1553911076),(51,'bmlchina','标杆物流','B',1,100,1553911076,1553911076),(52,'comexpress','邦通国际','B',1,100,1553911076,1553911076),(53,'baotongkd','宝通快递','B',1,100,1553911076,1553911076),(54,'beckygo','佰麒快递','B',1,100,1553911076,1553911076),(55,'boyol','贝业物流','B',1,100,1553911076,1553911076),(56,'bdatong','八达通快递','B',1,100,1553911076,1553911076),(57,'bangbangpost','帮帮发','B',1,100,1553911076,1553911076),(58,'baoxianda','报通快递','B',1,100,1553911076,1553911076),(59,'coe','中国东方(COE)','Z',1,100,1553911076,1553911076),(60,'cloudexpress','CE易欧通国际速递','C',1,100,1553911076,1553911076),(61,'city100','城市100','C',1,100,1553911076,1553911076),(62,'chuanxiwuliu','传喜物流','C',1,100,1553911076,1553911076),(63,'chengjisudi','城际速递','C',1,100,1553911076,1553911076),(64,'lijisong','立即送','L',1,100,1553911076,1553911076),(65,'chukou1','出口易','C',1,100,1553911076,1553911076),(66,'nanjingshengbang','晟邦物流','C',1,100,1553911076,1553911076),(67,'flyway','程光快递','C',1,100,1553911076,1553911076),(68,'cbo56','钏博物流','C',1,100,1553911076,1553911076),(69,'cex','城铁速递','C',1,100,1553911076,1553911076),(70,'cnup','CNUP 中联邮','C',1,100,1553911076,1553911076),(71,'clsp','CL日中速运','C',1,100,1553911076,1553911076),(72,'cnair','CNAIR','C',1,100,1553911076,1553911076),(73,'cangspeed','仓鼠快递','C',1,100,1553911076,1553911076),(74,'spring56','春风物流','C',1,100,1553911076,1553911076),(75,'cunto','村通快递','C',1,100,1553911076,1553911076),(76,'longvast','长风物流','C',1,100,1553911076,1553911076),(77,'changjiang','长江国际速递','C',1,100,1553911076,1553911076),(78,'cncexp','C&C国际速递','C',1,100,1553911076,1553911076),(79,'parcelchina','诚一物流','C',1,100,1553911076,1553911076),(80,'chengtong','城通物流','C',1,100,1553911076,1553911076),(81,'otpexpress','承诺达','C',1,100,1553911076,1553911076),(82,'sfpost','曹操到','C',1,100,1553911076,1553911076),(83,'changwooair','昌宇国际','C',1,100,1553911076,1553911076),(84,'dhl','DHL快递（中国件）','D',1,100,1553911076,1553911076),(85,'dhlen','DHL（国际件）','D',1,100,1553911076,1553911076),(86,'dhlde','DHL（德国件）','D',1,100,1553911076,1553911076),(87,'dtwl','大田物流','D',1,100,1553911076,1553911076),(88,'disifang','递四方','D',1,100,1553911076,1553911076),(89,'dayangwuliu','大洋物流','D',1,100,1553911076,1553911076),(90,'dechuangwuliu','德创物流','D',1,100,1553911076,1553911076),(91,'dskd','D速物流','D',1,100,1553911076,1553911076),(92,'donghanwl','东瀚物流','D',1,100,1553911076,1553911076),(93,'dfpost','达方物流','D',1,100,1553911076,1553911076),(94,'dongjun','东骏快捷物流','D',1,100,1553911076,1553911076),(95,'dindon','叮咚澳洲转运','D',1,100,1553911076,1553911076),(96,'dazhong','大众佐川急便','D',1,100,1553911076,1553911076),(97,'ahdf','德方物流','D',1,100,1553911076,1553911076),(98,'dehaoyi','德豪驿','D',1,100,1553911076,1553911076),(99,'dhlpaket','DHL Paket','D',1,100,1553911076,1553911076),(100,'ubuy','德国优拜物流','D',1,100,1553911076,1553911076),(101,'adlerlogi','德国雄鹰速递','D',1,100,1553911076,1553911076),(102,'yunexpress','德国云快递','D',1,100,1553911076,1553911076),(103,'di5pll','递五方云仓','D',1,100,1553911076,1553911076),(104,'deguo8elog','德国八易转运','D',1,100,1553911076,1553911076),(105,'camekong','到了港','D',1,100,1553911076,1553911076),(106,'dbstation','db-station','D',1,100,1553911076,1553911076),(107,'dadaoex','大道物流','D',1,100,1553911076,1553911076),(108,'dekuncn','德坤物流','D',1,100,1553911076,1553911076),(109,'twkd56','缔惠盛合','D',1,100,1553911076,1553911076),(110,'gslexpress','德尚国际速递','D',1,100,1553911076,1553911076),(111,'eucpost','德国 EUC POST','D',1,100,1553911076,1553911076),(112,'est365','东方汇','D',1,100,1553911076,1553911076),(113,'ecotransite','东西E全运','D',1,100,1553911076,1553911076),(114,'euexpress','EU-EXPRESS','E',1,100,1553911076,1553911076),(115,'emsguoji','EMS国际快递查询','E',1,100,1553911076,1553911076),(116,'eshunda','俄顺达','E',1,100,1553911076,1553911076),(117,'ewe','EWE全球快递','E',1,100,1553911076,1553911076),(118,'easyexpress','EASYEXPRESS国际速递','E',1,100,1553911076,1553911076),(119,'edtexpress','e直运','E',1,100,1553911076,1553911076),(120,'ecallturn','E跨通','E',1,100,1553911076,1553911076),(121,'fedex','FedEx快递查询','F',1,100,1553911076,1553911076),(122,'fedexus','FedEx（美国）','F',1,100,1553911076,1553911076),(123,'fox','FOX国际速递','F',1,100,1553911076,1553911076),(124,'rufengda','如风达快递','R',1,100,1553911076,1553911076),(125,'fkd','飞康达物流','F',1,100,1553911076,1553911076),(126,'feibaokuaidi','飞豹快递','F',1,100,1553911076,1553911076),(127,'fandaguoji','颿达国际','F',1,100,1553911076,1553911076),(128,'feiyuanvipshop','飞远配送','F',1,100,1553911076,1553911076),(129,'hnfy','飞鹰物流','F',1,100,1553911076,1553911076),(130,'fengxingtianxia','风行天下','F',1,100,1553911076,1553911076),(131,'flysman','飞力士物流','F',1,100,1553911076,1553911076),(132,'fbkd','飞邦快递','F',1,100,1553911076,1553911076),(133,'sccod','丰程物流','F',1,100,1553911076,1553911076),(134,'crazyexpress','疯狂快递','F',1,100,1553911076,1553911076),(135,'ftlexpress','法翔速运','F',1,100,1553911076,1553911076),(136,'ftd','富腾达快递','F',1,100,1553911076,1553911076),(137,'arkexpress','方舟国际速递','F',1,100,1553911076,1553911076),(138,'fedroad','FedRoad 联邦转运','F',1,100,1553911076,1553911076),(139,'freakyquick','FQ狂派速递','F',1,100,1553911076,1553911076),(140,'fecobv','丰客物流','F',1,100,1553911076,1553911076),(141,'fyex','飞云快递系统','F',1,100,1553911076,1553911076),(142,'beebird','锋鸟物流','F',1,100,1553911076,1553911076),(143,'shipgce','飞洋快递','F',1,100,1553911076,1553911076),(144,'koali','番薯国际货运','F',1,100,1553911076,1553911076),(145,'epanex','泛捷国际速递','F',1,100,1553911076,1553911076),(146,'gaticn','GATI快递','G',1,100,1553911076,1553911076),(147,'gts','GTS快递','G',1,100,1553911076,1553911076),(148,'guotongkuaidi','国通快递','G',1,100,1553911076,1553911076),(149,'ndkd','能达速递','N',1,100,1553911076,1553911076),(150,'gongsuda','共速达','G',1,100,1553911076,1553911076),(151,'gtongsudi','广通速递（山东）','G',1,100,1553911076,1553911076),(152,'suteng','速腾物流','S',1,100,1553911076,1553911076),(153,'gdkd','港快速递','G',1,100,1553911076,1553911076),(154,'hre','高铁速递','G',1,100,1553911076,1553911076),(155,'gscq365','哥士传奇速递','G',1,100,1553911076,1553911076),(156,'gjwl','冠捷物流','G',1,100,1553911076,1553911076),(157,'xdshipping','国晶物流','G',1,100,1553911076,1553911076),(158,'ge2d','GE2D跨境物流','G',1,100,1553911076,1553911076),(159,'gaotieex','高铁快运','G',1,100,1553911076,1553911076),(160,'gansuandi','甘肃安的快递','G',1,100,1553911076,1553911076),(161,'gdct56','广东诚通物流','G',1,100,1553911076,1553911076),(162,'ghtexpress','GHT物流','G',1,100,1553911076,1553911076),(163,'goldjet','高捷快运','G',1,100,1553911076,1553911076),(164,'gtgogo','GT国际快运','G',1,100,1553911076,1553911076),(165,'gxwl','光线速递','G',1,100,1553911076,1553911076),(166,'tdhy','华宇物流','H',1,100,1553911076,1553911076),(167,'hl','恒路物流','H',1,100,1553911076,1553911076),(168,'hlyex','好来运快递','H',1,100,1553911076,1553911076),(169,'hebeijianhua','河北建华','H',1,100,1553911076,1553911076),(170,'huaqikuaiyun','华企快运','H',1,100,1553911076,1553911076),(171,'haosheng','昊盛物流','H',1,100,1553911076,1553911076),(172,'hutongwuliu','户通物流','H',1,100,1553911076,1553911076),(173,'hzpl','华航快递','H',1,100,1553911076,1553911076),(174,'huangmajia','黄马甲快递','H',1,100,1553911076,1553911076),(175,'ucs','合众速递（UCS）','H',1,100,1553911076,1553911076),(176,'pfcexpress','皇家物流','H',1,100,1553911076,1553911076),(177,'huoban','伙伴物流','H',1,100,1553911076,1553911076),(178,'nedahm','红马速递','H',1,100,1553911076,1553911076),(179,'huiwen','汇文配送','H',1,100,1553911076,1553911076),(180,'nmhuahe','华赫物流','H',1,100,1553911076,1553911076),(181,'hjs','猴急送','H',1,100,1553911076,1553911076),(182,'hangyu','航宇快递','H',1,100,1553911076,1553911076),(183,'huilian','辉联物流','H',1,100,1553911076,1553911076),(184,'huanqiu','环球速运','H',1,100,1553911076,1553911076),(185,'htwd','华通务达物流','H',1,100,1553911076,1553911076),(186,'hipito','海派通','H',1,100,1553911076,1553911076),(187,'hqtd','环球通达','H',1,100,1553911076,1553911076),(188,'airgtc','航空快递','H',1,100,1553911076,1553911076),(189,'haoyoukuai','好又快物流','H',1,100,1553911076,1553911076),(190,'ccd','河南次晨达','H',1,100,1553911076,1553911076),(191,'hfwuxi','和丰同城','H',1,100,1553911076,1553911076),(192,'higo','黑狗物流','H',1,100,1553911076,1553911076),(193,'hyytes','恒宇运通','H',1,100,1553911076,1553911076),(194,'hengrui56','恒瑞物流','H',1,100,1553911076,1553911076),(195,'hangrui','上海航瑞货运','S',1,100,1553911076,1553911076),(196,'ghl','环创物流','H',1,100,1553911076,1553911076),(197,'hnqst','河南全速通','H',1,100,1553911076,1553911076),(198,'hitaoe','Hi淘易快递','H',1,100,1553911076,1553911076),(199,'hhair56','华瀚快递','H',1,100,1553911076,1553911076),(200,'haimibuy','海米派物流','H',1,100,1553911076,1553911076),(201,'ht22','海淘物流','H',1,100,1553911076,1553911076),(202,'hivewms','海沧无忧','H',1,100,1553911076,1553911076),(203,'hnht56','鸿泰物流','H',1,100,1553911076,1553911076),(204,'hsgtsd','海硕高铁速递','H',1,100,1553911076,1553911076),(205,'hltop','海联快递','H',1,100,1553911076,1553911076),(206,'hlkytj','互联快运','H',1,100,1553911076,1553911076),(207,'haidaibao','海带宝转运','H',1,100,1553911076,1553911076),(208,'flowerkd','花瓣转运','H',1,100,1553911076,1553911076),(209,'heimao56','黑猫速运','H',1,100,1553911076,1553911076),(210,'logistics','華信物流WTO','H',1,100,1553911076,1553911076),(211,'hgy56','环国运物流','H',1,100,1553911076,1553911076),(212,'iparcel','i-parcel','I',1,100,1553911076,1553911076),(213,'jjwl','佳吉物流','J',1,100,1553911076,1553911076),(214,'jywl','佳怡物流','J',1,100,1553911076,1553911076),(215,'jymwl','加运美快递','J',1,100,1553911076,1553911076),(216,'jxd','急先达物流','J',1,100,1553911076,1553911076),(217,'jgsd','京广速递快件','J',1,100,1553911076,1553911076),(218,'jykd','晋越快递','J',1,100,1553911076,1553911076),(219,'jd','京东物流','J',1,100,1553911076,1553911076),(220,'jietekuaidi','捷特快递','J',1,100,1553911076,1553911076),(221,'jiuyicn','久易快递','J',1,100,1553911076,1553911076),(222,'jiuyescm','九曳供应链','J',1,100,1553911076,1553911076),(223,'junfengguoji','骏丰国际速递','J',1,100,1553911076,1553911076),(224,'jiajiatong56','佳家通','J',1,100,1553911076,1553911076),(225,'jrypex','吉日优派','J',1,100,1553911076,1553911076),(226,'jinchengwuliu','锦程国际物流','J',1,100,1553911076,1553911076),(227,'jgwl','景光物流','J',1,100,1553911076,1553911076),(228,'pzhjst','急顺通','J',1,100,1553911076,1553911076),(229,'ruexp','捷网俄全通','J',1,100,1553911076,1553911076),(230,'jialidatong','嘉里大通','J',1,100,1553911076,1553911076),(231,'jmjss','金马甲','J',1,100,1553911076,1553911076),(232,'jiacheng','佳成快递','J',1,100,1553911076,1553911076),(233,'jsexpress','骏绅物流','J',1,100,1553911076,1553911076),(234,'hrex','锦程快递','J',1,100,1553911076,1553911076),(235,'jieanda','捷安达国际速递','J',1,100,1553911076,1553911076),(236,'newsway','家家通快递','J',1,100,1553911076,1553911076),(237,'mapleexpress','今枫国际快运','J',1,100,1553911076,1553911076),(238,'jixiangyouau','吉祥邮（澳洲）','J',1,100,1553911076,1553911076),(239,'jjx888','佳捷翔物流','J',1,100,1553911076,1553911076),(240,'polarexpress','极地快递','J',1,100,1553911076,1553911076),(241,'jiazhoumao','加州猫速递','J',1,100,1553911076,1553911076),(242,'juzhongda','聚中大','J',1,100,1553911076,1553911076),(243,'jieborne','捷邦物流','J',1,100,1553911076,1553911076),(244,'jxfex','集先锋速递','J',1,100,1553911076,1553911076),(245,'jiugong','九宫物流','J',1,100,1553911076,1553911076),(246,'jiujiuwl','久久物流','J',1,100,1553911076,1553911076),(247,'jintongkd','劲通快递','J',1,100,1553911076,1553911076),(248,'jcsuda','嘉诚速达','J',1,100,1553911076,1553911076),(249,'jingshun','景顺物流','J',1,100,1553911076,1553911076),(250,'fastontime','加拿大联通快运','J',1,100,1553911076,1553911076),(251,'khzto','柬埔寨中通','J',1,100,1553911076,1553911076),(252,'kjkd','快捷快递','K',1,100,1553911076,1553911076),(253,'kangliwuliu','康力物流','K',1,100,1553911076,1553911076),(254,'kuayue','跨越速运','K',1,100,1553911076,1553911076),(255,'kuaiyouda','快优达速递','K',1,100,1553911076,1553911076),(256,'happylink','开心快递','K',1,100,1553911076,1553911076),(257,'ksudi','快速递','K',1,100,1553911076,1553911076),(258,'kyue','跨跃国际','K',1,100,1553911076,1553911076),(259,'kfwnet','快服务','K',1,100,1553911076,1553911076),(260,'kuai8','快8速运','K',1,100,1553911076,1553911076),(261,'kuaidawuliu','快达物流','K',1,100,1553911076,1553911076),(262,'lianb','联邦快递（国内）','L',1,100,1553911076,1553911076),(263,'lhtwl','联昊通物流','L',1,100,1553911076,1553911076),(264,'lb','龙邦速递','L',1,100,1553911076,1553911076),(265,'lejiedi','乐捷递','L',1,100,1553911076,1553911076),(266,'lanhukuaidi','蓝弧快递','L',1,100,1553911076,1553911076),(267,'ltexp','乐天速递','L',1,100,1553911076,1553911076),(268,'lutong','鲁通快运','L',1,100,1553911076,1553911076),(269,'ledii','乐递供应链','L',1,100,1553911076,1553911076),(270,'lundao','论道国际物流','L',1,100,1553911076,1553911076),(271,'lasy56','林安物流','L',1,100,1553911076,1553911076),(272,'lsexpress','6LS EXPRESS','L',1,100,1553911076,1553911076),(273,'szuem','联运通物流','L',1,100,1553911076,1553911076),(274,'blueskyexpress','蓝天国际航空快递','L',1,100,1553911076,1553911076),(275,'lfexpress','龙枫国际速递','L',1,100,1553911076,1553911076),(276,'gslhkd','联合快递','L',1,100,1553911076,1553911076),(277,'longfx','龙飞祥快递','L',1,100,1553911076,1553911076),(278,'luben','陆本速递 LUBEN EXPRESS','L',1,100,1553911076,1553911076),(279,'unitedex','联合速运','L',1,100,1553911076,1553911076),(280,'lbex','龙邦物流','L',1,100,1553911076,1553911076),(281,'ltparcel','联通快递','L',1,100,1553911076,1553911076),(282,'macroexpressco','ME物流','M',1,100,1553911076,1553911076),(283,'mh','民航快递','M',1,100,1553911076,1553911076),(284,'meiguokuaidi','美国快递','M',1,100,1553911076,1553911076),(285,'menduimen','门对门','M',1,100,1553911076,1553911076),(286,'mingliangwuliu','明亮物流','M',1,100,1553911076,1553911076),(287,'minbangsudi','民邦速递','M',1,100,1553911076,1553911076),(288,'minshengkuaidi','闽盛快递','M',1,100,1553911076,1553911076),(289,'yundaexus','美国韵达','M',1,100,1553911076,1553911076),(290,'mchy','木春货运','M',1,100,1553911076,1553911076),(291,'meiquick','美快国际物流','M',1,100,1553911076,1553911076),(292,'valueway','美通快递','M',1,100,1553911076,1553911076),(293,'cnmcpl','马珂博逻','M',1,100,1553911076,1553911076),(294,'mailongdy','迈隆递运','M',1,100,1553911076,1553911076),(295,'zsmhwl','明辉物流','M',1,100,1553911076,1553911076),(296,'mosuda','魔速达','M',1,100,1553911076,1553911076),(297,'meibang','美邦国际快递','M',1,100,1553911076,1553911076),(298,'nuoyaao','偌亚奥国际','N',1,100,1553911076,1553911076),(299,'nuoer','诺尔国际物流','N',1,100,1553911076,1553911076),(300,'nell','尼尔快递','N',1,100,1553911076,1553911076),(301,'ndwl','南方传媒物流','N',1,100,1553911076,1553911076),(302,'canhold','能装能送','N',1,100,1553911076,1553911076),(303,'wanjiatong','宁夏万家通','N',1,100,1553911076,1553911076),(304,'nlebv','欧亚专线','O',1,100,1553911076,1553911076),(305,'oborexpress','OBOR Express','O',1,100,1553911076,1553911076),(306,'pcaexpress','PCA Express','P',1,100,1553911076,1553911076),(307,'pingandatengfei','平安达腾飞','P',1,100,1553911076,1553911076),(308,'peixingwuliu','陪行物流','P',1,100,1553911076,1553911076),(309,'pengyuanexpress','鹏远国际速递','P',1,100,1553911076,1553911076),(310,'postelbe','PostElbe','P',1,100,1553911076,1553911076),(311,'papascm','啪啪供应链','P',1,100,1553911076,1553911076),(312,'bazirim','皮牙子快递','P',1,100,1553911076,1553911076),(313,'qfkd','全峰快递','Q',1,100,1553911076,1553911076),(314,'qy','全一快递','Q',1,100,1553911076,1553911076),(315,'qrt','全日通快递','Q',1,100,1553911076,1553911076),(316,'qckd','全晨快递','Q',1,100,1553911076,1553911076),(317,'sevendays','7天连锁物流','Q',1,100,1553911076,1553911076),(318,'qbexpress','秦邦快运','Q',1,100,1553911076,1553911076),(319,'quanxintong','全信通快递','Q',1,100,1553911076,1553911076),(320,'quansutong','全速通国际快递','Q',1,100,1553911076,1553911076),(321,'qinyuan','秦远物流','Q',1,100,1553911076,1553911076),(322,'qichen','启辰国际物流','Q',1,100,1553911076,1553911076),(323,'quansu','全速快运','Q',1,100,1553911076,1553911076),(324,'qzx56','全之鑫物流','Q',1,100,1553911076,1553911076),(325,'qskdyxgs','千顺快递','Q',1,100,1553911076,1553911076),(326,'zqlwl','青旅物流','Q',1,100,1553911076,1553911076),(327,'quanchuan56','全川物流','Q',1,100,1553911076,1553911076),(328,'quantwl','全通快运','Q',1,100,1553911076,1553911076),(329,'yatexpress','乾坤物流','Q',1,100,1553911076,1553911076),(330,'guexp','全联速运','Q',1,100,1553911076,1553911076),(331,'bjqywl','青云物流','Q',1,100,1553911076,1553911076),(332,'signedexpress','签收快递','Q',1,100,1553911076,1553911076),(333,'express7th','7号速递','Q',1,100,1553911076,1553911076),(334,'riyuwuliu','日昱物流','R',1,100,1553911076,1553911076),(335,'rfsd','瑞丰速递','R',1,100,1553911076,1553911076),(336,'rrs','日日顺物流','R',1,100,1553911076,1553911076),(337,'rytsd','日益通速递','R',1,100,1553911076,1553911076),(338,'rrskx','日日顺快线','R',1,100,1553911076,1553911076),(339,'gdrz58','容智快运','R',1,100,1553911076,1553911076),(340,'rrthk','日日通国际','R',1,100,1553911076,1553911076),(341,'homecourier','如家国际快递','R',1,100,1553911076,1553911076),(342,'sewl','速尔快递','S',1,100,1553911076,1553911076),(343,'haihongwangsong','山东海红','S',1,100,1553911076,1553911076),(344,'sh','盛辉物流','S',1,100,1553911076,1553911076),(345,'sfwl','盛丰物流','S',1,100,1553911076,1553911076),(346,'shiyunkuaidi','世运快递','S',1,100,1553911076,1553911076),(347,'shangda','上大物流','S',1,100,1553911076,1553911076),(348,'stsd','三态速递','S',1,100,1553911076,1553911076),(349,'saiaodi','赛澳递','S',1,100,1553911076,1553911076),(350,'ewl','申通E物流','S',1,100,1553911076,1553911076),(351,'shenganwuliu','圣安物流','S',1,100,1553911076,1553911076),(352,'sxhongmajia','山西红马甲','S',1,100,1553911076,1553911076),(353,'suijiawuliu','穗佳物流','S',1,100,1553911076,1553911076),(354,'syjiahuier','沈阳佳惠尔','S',1,100,1553911076,1553911076),(355,'shlindao','上海林道货运','S',1,100,1553911076,1553911076),(356,'sfift','十方通物流','S',1,100,1553911076,1553911076),(357,'shunjiefengda','顺捷丰达','S',1,100,1553911076,1553911076),(358,'subida','速必达物流','S',1,100,1553911076,1553911076),(359,'stcd','速通成达物流','S',1,100,1553911076,1553911076),(360,'stkd','顺通快递','S',1,100,1553911076,1553911076),(361,'sendtochina','速递中国','S',1,100,1553911076,1553911076),(362,'sihaiet','四海快递','S',1,100,1553911076,1553911076),(363,'staky','首通快运','S',1,100,1553911076,1553911076),(364,'hnssd56','顺时达物流','S',1,100,1553911076,1553911076),(365,'superb','Superb Grace','S',1,100,1553911076,1553911076),(366,'sfjhd','圣飞捷快递','S',1,100,1553911076,1553911076),(367,'sofast56','嗖一下同城快递','S',1,100,1553911076,1553911076),(368,'s2c','S2C','S',1,100,1553911076,1553911076),(369,'chinasqk','SQK国际速递','S',1,100,1553911076,1553911076),(370,'shunshid','顺士达速运','S',1,100,1553911076,1553911076),(371,'synship','SYNSHIP快递','S',1,100,1553911076,1553911076),(372,'shandiantu','闪电兔','S',1,100,1553911076,1553911076),(373,'sdsy888','首达速运','S',1,100,1553911076,1553911076),(374,'sczpds','速呈宅配','S',1,100,1553911076,1553911076),(375,'sureline','Sureline冠泰','S',1,100,1553911076,1553911076),(376,'stosolution','申通国际','S',1,100,1553911076,1553911076),(377,'sycawl','狮爱高铁物流','S',1,100,1553911076,1553911076),(378,'sxexpress','三象速递','S',1,100,1553911076,1553911076),(379,'shangqiao56','商桥物流','S',1,100,1553911076,1553911076),(380,'shd56','商海德物流','S',1,100,1553911076,1553911076),(381,'shenma','神马快递','S',1,100,1553911076,1553911076),(382,'sihiexpress','四海捷运','S',1,100,1553911076,1553911076),(383,'superoz','速配鸥翼','S',1,100,1553911076,1553911076),(384,'fastgoexpress','速派快递','S',1,100,1553911076,1553911076),(385,'zjstky','苏通快运','S',1,100,1553911076,1553911076),(386,'suning','苏宁物流','S',1,100,1553911076,1553911076),(387,'shaoke','捎客物流','S',1,100,1553911076,1553911076),(388,'sdto','速达通跨境物流','S',1,100,1553911076,1553911076),(389,'sut56','速通物流','S',1,100,1553911076,1553911076),(390,'sundarexpress','顺达快递','S',1,100,1553911076,1553911076),(391,'sxjdfreight','顺心捷达','S',1,100,1553911076,1553911076),(392,'shengtongscm','盛通快递','S',1,100,1553911076,1553911076),(393,'tnt','TNT快递','T',1,100,1553911076,1553911076),(394,'tt','天天快递','T',1,100,1553911076,1553911076),(395,'tianzong','天纵物流','T',1,100,1553911076,1553911076),(396,'chinatzx','同舟行物流','T',1,100,1553911076,1553911076),(397,'nntengda','腾达速递','T',1,100,1553911076,1553911076),(398,'sd138','泰国138','T',1,100,1553911076,1553911076),(399,'tongdaxing','通达兴物流','T',1,100,1553911076,1553911076),(400,'tlky','天联快运','T',1,100,1553911076,1553911076),(401,'ibenben','途鲜物流','T',1,100,1553911076,1553911076),(402,'krtao','淘韩国际快递','T',1,100,1553911076,1553911076),(403,'lntjs','特急送','T',1,100,1553911076,1553911076),(404,'tny','TNY物流','T',1,100,1553911076,1553911076),(405,'djy56','天翔东捷运','T',1,100,1553911076,1553911076),(406,'guoeryue','天天快物流','T',1,100,1553911076,1553911076),(407,'tianma','天马迅达','T',1,100,1553911076,1553911076),(408,'surpassgo','天越物流','T',1,100,1553911076,1553911076),(409,'tianxiang','天翔快递','T',1,100,1553911076,1553911076),(410,'tywl99','天翼物流','T',1,100,1553911076,1553911076),(411,'shpost','同城快寄','T',1,100,1553911076,1553911076),(412,'humpline','驼峰国际','T',1,100,1553911076,1553911076),(413,'transrush','TransRush','T',1,100,1553911076,1553911076),(414,'tstexp','TST速运通','T',1,100,1553911076,1553911076),(415,'ctoexp','泰国中通CTO','T',1,100,1553911076,1553911076),(416,'thaizto','泰国中通ZTO','T',1,100,1553911076,1553911076),(417,'tswlcloud','天使物流云','T',1,100,1553911076,1553911076),(418,'tzky','铁中快运','T',1,100,1553911076,1553911076),(419,'tcxbthai','TCXB国际物流','T',1,100,1553911076,1553911076),(420,'taimek','天美快递','T',1,100,1553911076,1553911076),(421,'taoplus','淘布斯国际物流','T',1,100,1553911076,1553911076),(422,'ups','UPS快递查询','U',1,100,1553911076,1553911076),(423,'yskd','优速快递','Y',1,100,1553911076,1553911076),(424,'usps','USPS美国邮政','U',1,100,1553911076,1553911076),(425,'ueq','UEQ快递','U',1,100,1553911076,1553911076),(426,'uex','UEX国际物流','U',1,100,1553911076,1553911076),(427,'utaoscm','UTAO 优到','U',1,100,1553911076,1553911076),(428,'wxwl','万象物流','W',1,100,1553911076,1553911076),(429,'weitepai','微特派','W',1,100,1553911076,1553911076),(430,'wjwl','万家物流','W',1,100,1553911076,1553911076),(431,'wanboex','万博快递','W',1,100,1553911076,1553911076),(432,'wtdchina','威时沛运','W',1,100,1553911076,1553911076),(433,'wzhaunyun','微转运','W',1,100,1553911076,1553911076),(434,'gswtkd','万通快递','W',1,100,1553911076,1553911076),(435,'wandougongzhu','豌豆物流','W',1,100,1553911076,1553911076),(436,'wjkwl','万家康物流','W',1,100,1553911076,1553911076),(437,'vps','维普恩物流','W',1,100,1553911076,1553911076),(438,'wykjt','51跨境通','W',1,100,1553911076,1553911076),(439,'wherexpess','威盛快递','W',1,100,1553911076,1553911076),(440,'weilaimingtian','未来明天快递','W',1,100,1553911076,1553911076),(441,'wdm','万达美','W',1,100,1553911076,1553911076),(442,'wto56kj','温通物流','W',1,100,1553911076,1553911076),(443,'56kuaiyun','五六快运','W',1,100,1553911076,1553911076),(444,'wowvip','沃埃家','W',1,100,1553911076,1553911076),(445,'grivertek','潍鸿','W',1,100,1553911076,1553911076),(446,'xbwl','新邦物流','X',1,100,1553911076,1553911076),(447,'xfwl','信丰物流','X',1,100,1553911076,1553911076),(448,'newegg','新蛋物流','X',1,100,1553911076,1553911076),(449,'xianglongyuntong','祥龙运通物流','X',1,100,1553911076,1553911076),(450,'xianchengliansudi','西安城联速递','X',1,100,1553911076,1553911076),(451,'xilaikd','喜来快递','X',1,100,1553911076,1553911076),(452,'xsrd','鑫世锐达','X',1,100,1553911076,1553911076),(453,'xtb','鑫通宝物流','X',1,100,1553911076,1553911076),(454,'xintianjie','信天捷快递','X',1,100,1553911076,1553911076),(455,'xaetc','西安胜峰','X',1,100,1553911076,1553911076),(456,'xianfeng','先锋快递','X',1,100,1553911076,1553911076),(457,'sunspeedy','新速航','X',1,100,1553911076,1553911076),(458,'xipost','西邮寄','X',1,100,1553911076,1553911076),(459,'sinatone','信联通','X',1,100,1553911076,1553911076),(460,'sunjex','新杰物流','X',1,100,1553911076,1553911076),(461,'alog','心怡物流','X',1,100,1553911076,1553911076),(462,'csxss','新时速物流','X',1,100,1553911076,1553911076),(463,'xiangteng','翔腾物流','X',1,100,1553911076,1553911076),(464,'westwing','西翼物流','X',1,100,1553911076,1553911076),(465,'littlebearbear','小熊物流','X',1,100,1553911076,1553911076),(466,'huanqiuabc','中国香港环球快运','Z',1,100,1553911076,1553911076),(467,'xinning','新宁物流','X',1,100,1553911076,1553911076),(468,'wlwex','星空国际','X',1,100,1553911076,1553911076),(469,'yyexp','西安运逸快递','X',1,100,1553911076,1553911076),(470,'xiyoug','西游寄','X',1,100,1553911076,1553911076),(471,'xlobo','xLobo','X',1,100,1553911076,1553911076),(472,'xunsuexpress','迅速快递','X',1,100,1553911076,1553911076),(473,'whgjkd','香港伟豪国际物流','X',1,100,1553911076,1553911076),(474,'xyd666','鑫远东速运','X',1,100,1553911076,1553911076),(475,'xdexpress','迅达速递','X',1,100,1553911076,1553911076),(476,'ytkd','运通快递','Y',1,100,1553911076,1553911076),(477,'ycwl','远成物流','Y',1,100,1553911076,1553911076),(478,'yfsd','亚风速递','Y',1,100,1553911076,1553911076),(479,'yishunhang','亿顺航','Y',1,100,1553911076,1553911076),(480,'yfwl','越丰物流','Y',1,100,1553911076,1553911076),(481,'yad','源安达快递','Y',1,100,1553911076,1553911076),(482,'yfh','原飞航物流','Y',1,100,1553911076,1553911076),(483,'yinjiesudi','银捷速递','Y',1,100,1553911076,1553911076),(484,'yitongfeihong','一统飞鸿','Y',1,100,1553911076,1553911076),(485,'yuxinwuliu','宇鑫物流','Y',1,100,1553911076,1553911076),(486,'yitongda','易通达','Y',1,100,1553911076,1553911076),(487,'youbijia','邮必佳','Y',1,100,1553911076,1553911076),(488,'yiqiguojiwuliu','一柒物流','Y',1,100,1553911076,1553911076),(489,'yinsu','音素快运','Y',1,100,1553911076,1553911076),(490,'yilingsuyun','亿领速运','Y',1,100,1553911076,1553911076),(491,'yujiawuliu','煜嘉物流','Y',1,100,1553911076,1553911076),(492,'gml','英脉物流','Y',1,100,1553911076,1553911076),(493,'leopard','云豹国际货运','Y',1,100,1553911076,1553911076),(494,'czwlyn','云南中诚','Y',1,100,1553911076,1553911076),(495,'sdyoupei','优配速运','Y',1,100,1553911076,1553911076),(496,'yongchang','永昌物流','Y',1,100,1553911076,1553911076),(497,'yufeng','御风速运','Y',1,100,1553911076,1553911076),(498,'yousutongda','优速通达','Y',1,100,1553911076,1553911076),(499,'yongwangda','永旺达快递','Y',1,100,1553911076,1553911076),(500,'yingchao','英超物流','Y',1,100,1553911076,1553911076),(501,'edlogistics','益递物流','Y',1,100,1553911076,1553911076),(502,'yjxlm','宜家行','Y',1,100,1553911076,1553911076),(503,'onehcang','一号仓','Y',1,100,1553911076,1553911076),(504,'ycgky','远成快运','Y',1,100,1553911076,1553911076),(505,'yunfeng56','韵丰物流','Y',1,100,1553911076,1553911076),(506,'iyoungspeed','驿扬国际速运','Y',1,100,1553911076,1553911076),(507,'zgyzt','一站通快递','Y',1,100,1553911076,1553911076),(508,'eupackage','易优包裹','Y',1,100,1553911076,1553911076),(509,'ydglobe','云达通','Y',1,100,1553911076,1553911076),(510,'el56','YLTD','Y',1,100,1553911076,1553911076),(511,'yundx','运东西','Y',1,100,1553911076,1553911076),(512,'yangbaoguo','洋包裹','Y',1,100,1553911076,1553911076),(513,'uluckex','优联吉运','Y',1,100,1553911076,1553911076),(514,'ecmscn','易客满','Y',1,100,1553911076,1553911076),(515,'ubonex','优邦速运','Y',1,100,1553911076,1553911076),(516,'yue777','玥玛速运','Y',1,100,1553911076,1553911076),(517,'ywexpress','远为快递','Y',1,100,1553911076,1553911076),(518,'ezhuanyuan','易转运','Y',1,100,1553911076,1553911076),(519,'yiqisong','一起送','Y',1,100,1553911076,1553911076),(520,'yongbangwuliu','永邦国际物流','Y',1,100,1553911076,1553911076),(521,'yyox','邮客全球速递','Y',1,100,1553911076,1553911076),(522,'yihangmall','易航物流','Y',1,100,1553911076,1553911076),(523,'yiouzhou','易欧洲国际物流','Y',1,100,1553911076,1553911076),(524,'ykouan','洋口岸','Y',1,100,1553911076,1553911076),(525,'youyou','优优速递','Y',1,100,1553911076,1553911076),(526,'ytky168','运通快运','Y',1,100,1553911076,1553911076),(527,'sixroad','易普递','Y',1,100,1553911076,1553911076),(528,'yourscm','雅澳物流','Y',1,100,1553911076,1553911076),(529,'euguoji','易邮国际','Y',1,100,1553911076,1553911076),(530,'uscbexpress','易境达国际物流','Y',1,100,1553911076,1553911076),(531,'yfsuyun','驭丰速运','Y',1,100,1553911076,1553911076),(532,'yimidida','壹米滴答','Y',1,100,1553911076,1553911076),(533,'ugoexpress','邮鸽速运','Y',1,100,1553911076,1553911076),(534,'youban','邮邦国际','Y',1,100,1553911076,1553911076),(535,'hkems','云邮跨境快递','Y',1,100,1553911076,1553911076),(536,'youlai','邮来速递','Y',1,100,1553911076,1553911076),(537,'eta100','易达国际速递','Y',1,100,1553911076,1553911076),(538,'yatfai','一辉物流','Y',1,100,1553911076,1553911076),(539,'yzswuliu','亚洲顺物流','Y',1,100,1553911076,1553911076),(540,'yifankd','艺凡快递','Y',1,100,1553911076,1553911076),(541,'mantoo','优能物流','Y',1,100,1553911076,1553911076),(542,'vctrans','越中国际物流','Y',1,100,1553911076,1553911076),(543,'yhtlogistics','宇航通物流','Y',1,100,1553911076,1553911076),(544,'ycgglobal','YCG物流','Y',1,100,1553911076,1553911076),(545,'yidihui','驿递汇速递','Y',1,100,1553911076,1553911076),(546,'yuanhhk','远航国际快运','Y',1,100,1553911076,1553911076),(547,'yiyou','易邮速运','Y',1,100,1553911076,1553911076),(548,'eusacn','优莎速运','Y',1,100,1553911076,1553911076),(549,'uhi','优海国际速递','Y',1,100,1553911076,1553911076),(550,'zjs','宅急送','Z',1,100,1553911076,1553911076),(551,'ztky','中铁快运','Z',1,100,1553911076,1553911076),(552,'ztwl','中铁物流','Z',1,100,1553911076,1553911076),(553,'zywl','中邮物流','Z',1,100,1553911076,1553911076),(554,'zhimakaimen','芝麻开门','Z',1,100,1553911076,1553911076),(555,'zhengzhoujianhua','郑州建华','Z',1,100,1553911076,1553911076),(556,'zhongsukuaidi','中速快件','Z',1,100,1553911076,1553911076),(557,'zhongtianwanyun','中天万运','Z',1,100,1553911076,1553911076),(558,'zhongruisudi','中睿速递','Z',1,100,1553911076,1553911076),(559,'zhongwaiyun','中外运速递','Z',1,100,1553911076,1553911076),(560,'zengyisudi','增益速递','Z',1,100,1553911076,1553911076),(561,'sujievip','郑州速捷','Z',1,100,1553911076,1553911076),(562,'ztong','智通物流','Z',1,100,1553911076,1553911076),(563,'zhichengtongda','至诚通达快递','Z',1,100,1553911076,1553911076),(564,'zhdwl','众辉达物流','Z',1,100,1553911076,1553911076),(565,'kuachangwuliu','直邮易','Z',1,100,1553911076,1553911076),(566,'topspeedex','中运全速','Z',1,100,1553911076,1553911076),(567,'otobv','中欧快运','Z',1,100,1553911076,1553911076),(568,'zsky123','准实快运','Z',1,100,1553911076,1553911076),(569,'cnws','中国翼','Z',1,100,1553911076,1553911076),(570,'zytdscm','中宇天地','Z',1,100,1553911076,1553911076),(571,'zhuanyunsifang','转运四方','Z',1,100,1553911076,1553911076),(572,'hrbzykd','卓烨快递','Z',1,100,1553911076,1553911076),(573,'zhuoshikuaiyun','卓实快运','Z',1,100,1553911076,1553911076),(574,'chinaicip','卓志速运','Z',1,100,1553911076,1553911076),(575,'ynztsy','纵通速运','Z',1,100,1553911076,1553911076),(576,'zdepost','直德邮','Z',1,100,1553911076,1553911076),(577,'chinapostcb','中邮电商','Z',1,100,1553911076,1553911076),(578,'chunghwa56','中骅物流','Z',1,100,1553911076,1553911076),(579,'cosco','中远e环球','Z',1,100,1553911076,1553911076),(580,'zf365','珠峰速运','Z',1,100,1553911076,1553911076),(581,'zhongtongkuaiyun','中通快运','Z',1,100,1553911076,1553911076),(582,'eucnrail','中欧国际物流','Z',1,100,1553911076,1553911076),(583,'chnexp','中翼国际物流','Z',1,100,1553911076,1553911076),(584,'cccc58','中集冷云','Z',1,100,1553911076,1553911076),(585,'auvanda','中联速递','Z',1,100,1553911076,1553911076),(586,'zyzoom','增速跨境','Z',1,100,1553911076,1553911076),(587,'zhpex','众派速递','Z',1,100,1553911076,1553911076),(588,'byht','展勤快递','Z',1,100,1553911076,1553911076),(589,'zhongchuan','众川国际','Z',1,100,1553911076,1553911076),(590,'zhonghuanus','中环转运','Z',1,100,1553911076,1553911076),(591,'zhonghuan','中环快递','Z',1,100,1553911076,1553911076),(592,'uszcn','转运中国','Z',1,100,1553911076,1553911076),(593,'zhitengwuliu','志腾物流','Z',1,100,1553911076,1553911076),(594,'zsda56','转瞬达集运','Z',1,100,1553911076,1553911076),(595,'zjgj56','振捷国际货运','Z',1,100,1553911076,1553911076),(596,'jtexpress','极兔速递','J',1,100,1553911076,1553911076);

--
-- Table structure for table `ey_shop_order`
--

CREATE TABLE `ey_shop_order` (
  `order_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '订单id',
  `order_code` varchar(50) NOT NULL DEFAULT '' COMMENT '订单编号',
  `users_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '会员id',
  `order_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '订单状态：0未付款(已下单)，1已付款(待发货)，2已发货(待收货)，3已完成(确认收货)，-1订单取消(已关闭)，4订单过期',
  `payment_method` tinyint(1) DEFAULT '0' COMMENT '订单支付方式，0为在线支付，1为货到付款，默认0',
  `pay_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '支付时间',
  `pay_name` varchar(20) NOT NULL DEFAULT '' COMMENT '支付方式名称',
  `wechat_pay_type` varchar(20) NOT NULL DEFAULT '' COMMENT '微信支付时，标记使用的支付类型（扫码支付，微信内部，微信H5页面）',
  `order_terminal` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '订单终端(1=电脑端、2=手机端、3微信小程序)',
  `contains_virtual` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '订单是否包含虚拟商品(1=不包含、2=包含)',
  `manual_refund` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '订单是否被手动关闭并退款',
  `refund_note` varchar(500) NOT NULL DEFAULT '' COMMENT '订单手动退款原因',
  `pay_details` text COMMENT '支付时返回的数据，以serialize序列化后存入，用于后续查询。',
  `express_order` varchar(50) DEFAULT '' COMMENT '发货物流单号',
  `express_name` varchar(32) DEFAULT '' COMMENT '发货物流名称',
  `express_code` varchar(32) DEFAULT '' COMMENT '发货物流code',
  `express_time` int(11) DEFAULT '0' COMMENT '发货时间',
  `consignee` varchar(30) NOT NULL DEFAULT '' COMMENT '收货人',
  `confirm_time` int(11) DEFAULT '0' COMMENT '收货确认时间',
  `shipping_fee` decimal(10,2) DEFAULT '0.00' COMMENT '订单运费',
  `order_total_amount` decimal(10,2) DEFAULT '0.00' COMMENT '订单总价',
  `order_amount` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '应付款金额',
  `order_total_num` int(10) DEFAULT '0' COMMENT '订单总数',
  `country` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '国家',
  `province` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '省份',
  `city` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '城市',
  `district` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '县区',
  `address` varchar(500) NOT NULL DEFAULT '' COMMENT '收货地址',
  `mobile` varchar(20) DEFAULT '' COMMENT '手机',
  `prom_type` tinyint(1) unsigned DEFAULT '0' COMMENT '订单类型：0普通订单，1虚拟订单',
  `virtual_delivery` text COMMENT '虚拟订单时，卖家发货给买家的回复',
  `admin_note` text COMMENT '管理员操作备注',
  `is_comment` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否已评论，0为否，1为是，默认0',
  `user_note` text COMMENT '会员备注',
  `group` varchar(50) DEFAULT '' COMMENT '订单分组',
  `order_md5` varchar(50) DEFAULT '' COMMENT '订单标识串，删除未付款的重复订单',
  `order_source` tinyint(3) DEFAULT '10' COMMENT '10-普通订单 20-秒杀订单',
  `order_source_id` int(10) DEFAULT '0' COMMENT '来源id(秒杀订单:active_time_id)',
  `lang` varchar(30) DEFAULT 'cn' COMMENT '语言标识',
  `add_time` int(11) unsigned DEFAULT '0' COMMENT '下单时间',
  `update_time` int(11) unsigned DEFAULT '0' COMMENT '更新时间',
  `coupon_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '优惠券数据表ID',
  `use_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '会员的优惠券数据表ID',
  `coupon_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '使用的优惠券金额',
  PRIMARY KEY (`order_id`),
  UNIQUE KEY `order_code` (`order_code`),
  KEY `users_id` (`users_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='订单主表';

--
-- Dumping data for table `ey_shop_order`
--


--
-- Table structure for table `ey_shop_order_comment`
--

CREATE TABLE `ey_shop_order_comment` (
  `comment_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `users_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员ID',
  `order_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '订单ID',
  `order_code` varchar(50) NOT NULL DEFAULT '' COMMENT '订单编号',
  `details_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '订单明细表ID',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商品ID',
  `total_score` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '总评分，1：好评，2中评，3差评',
  `content` varchar(1000) NOT NULL DEFAULT '' COMMENT '评论内容',
  `upload_img` varchar(3000) NOT NULL DEFAULT '' COMMENT '晒单图片',
  `admin_reply` varchar(1000) NOT NULL DEFAULT '' COMMENT '管理员回复',
  `ip_address` varchar(15) NOT NULL DEFAULT '' COMMENT 'IP地址',
  `is_show` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否显示：0否，1是',
  `is_anonymous` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否匿名评价：0否，1是',
  `lang` varchar(30) NOT NULL DEFAULT 'cn' COMMENT '语言标识',
  `add_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`comment_id`),
  KEY `users_id` (`users_id`),
  KEY `order_id` (`order_id`),
  KEY `details_id` (`details_id`),
  KEY `product_id` (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='商品评价表';

--
-- Dumping data for table `ey_shop_order_comment`
--


--
-- Table structure for table `ey_shop_order_details`
--

CREATE TABLE `ey_shop_order_details` (
  `details_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `order_id` int(10) NOT NULL DEFAULT '0' COMMENT '订单ID',
  `users_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '产品id',
  `product_name` varchar(100) NOT NULL DEFAULT '' COMMENT '产品名称',
  `num` int(10) NOT NULL DEFAULT '0' COMMENT '单个产品数量',
  `data` text COMMENT '序列化额外数据',
  `product_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '产品单价',
  `prom_type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '产品类型：0普通产品，1虚拟产品',
  `litpic` varchar(500) NOT NULL DEFAULT '' COMMENT '封面图片',
  `apply_service` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否申请退换货服务：0 未申请、1已申请',
  `is_comment` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否已评论，0为否，1为是，默认0',
  `lang` varchar(30) NOT NULL DEFAULT 'cn' COMMENT '语言标识',
  `add_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '下单时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`details_id`),
  KEY `users_id` (`users_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='订单详情表';

--
-- Dumping data for table `ey_shop_order_details`
--


--
-- Table structure for table `ey_shop_order_log`
--

CREATE TABLE `ey_shop_order_log` (
  `action_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `order_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '订单ID',
  `users_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员ID',
  `action_user` int(10) DEFAULT '0' COMMENT '操作人；0:用户操作；1以上:管理员id',
  `order_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '订单状态，单条记录状态',
  `express_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '物流状态，0:未发货，1:已发货',
  `pay_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '支付状态，0:未支付，1:已支付',
  `action_desc` varchar(255) DEFAULT '' COMMENT '状态描述',
  `action_note` varchar(255) NOT NULL DEFAULT '' COMMENT '操作备注',
  `lang` varchar(30) DEFAULT 'cn' COMMENT '语言标识',
  `add_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '操作时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '操作时间',
  PRIMARY KEY (`action_id`),
  KEY `order_id` (`order_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='订单操作记录表';

--
-- Dumping data for table `ey_shop_order_log`
--


--
-- Table structure for table `ey_shop_order_service`
--

CREATE TABLE `ey_shop_order_service` (
  `service_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `service_type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '类型：1换货，2退货，3维修',
  `users_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员id',
  `order_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '订单ID',
  `order_code` varchar(50) NOT NULL DEFAULT '' COMMENT '订单编号',
  `details_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '订单明细表ID',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '产品ID',
  `product_name` varchar(200) NOT NULL DEFAULT '' COMMENT '产品名称',
  `product_spec` varchar(200) NOT NULL DEFAULT '' COMMENT '产品规格',
  `product_num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '产品数量',
  `product_img` varchar(500) NOT NULL DEFAULT '' COMMENT '产品图片',
  `content` varchar(500) NOT NULL DEFAULT '' COMMENT '退换货描述',
  `upload_img` varchar(3000) NOT NULL DEFAULT '' COMMENT '上传的图片',
  `address` varchar(500) NOT NULL DEFAULT '' COMMENT '退货的收货地址',
  `consignee` varchar(30) NOT NULL DEFAULT '' COMMENT '收货人',
  `mobile` varchar(20) NOT NULL DEFAULT '' COMMENT '手机',
  `manual_refund` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '服务单是否被手动关闭并退款',
  `refund_note` varchar(500) NOT NULL DEFAULT '' COMMENT '服务单手动退款原因',
  `refund_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '退还金额',
  `refund_balance` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '退还余额',
  `refund_code` varchar(40) NOT NULL DEFAULT '' COMMENT '退款单号',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态：1审核中 2审核通过 3审核不通过 4已发货 5已收货 6换货完成 7退款完成 8服务取消',
  `users_delivery` varchar(500) NOT NULL DEFAULT '' COMMENT '会员发货信息',
  `admin_delivery` varchar(500) NOT NULL DEFAULT '' COMMENT '管理员发货信息',
  `admin_note` varchar(1000) NOT NULL DEFAULT '' COMMENT '管理员操作备注',
  `lang` varchar(30) NOT NULL DEFAULT 'cn' COMMENT '语言标识',
  `add_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '申请时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`service_id`),
  KEY `users_id` (`users_id`) USING BTREE,
  KEY `order_id` (`order_id`) USING BTREE,
  KEY `order_code` (`order_code`) USING BTREE,
  KEY `product_id` (`product_id`) USING BTREE,
  KEY `details_id` (`details_id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='订单退换货服务表';

--
-- Dumping data for table `ey_shop_order_service`
--


--
-- Table structure for table `ey_shop_order_service_log`
--

CREATE TABLE `ey_shop_order_service_log` (
  `log_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `service_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '服务表ID',
  `order_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '订单ID',
  `users_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员ID',
  `admin_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '管理员ID',
  `log_note` varchar(500) NOT NULL DEFAULT '' COMMENT '记录备注',
  `lang` varchar(30) NOT NULL DEFAULT 'cn' COMMENT '语言标识',
  `add_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '操作时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '操作时间',
  PRIMARY KEY (`log_id`),
  KEY `service_id` (`service_id`) USING BTREE,
  KEY `order_id` (`order_id`) USING BTREE,
  KEY `users_id` (`users_id`) USING BTREE,
  KEY `admin_id` (`admin_id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='订单退换货服务记录表';

--
-- Dumping data for table `ey_shop_order_service_log`
--


--
-- Table structure for table `ey_shop_product_attr`
--

CREATE TABLE `ey_shop_product_attr` (
  `product_attr_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '产品属性id自增',
  `aid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '产品id',
  `attr_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '属性id',
  `attr_value` text NOT NULL COMMENT '属性值',
  `attr_price` varchar(255) DEFAULT '' COMMENT '属性价格',
  `add_time` int(11) DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`product_attr_id`),
  KEY `aid` (`aid`) USING BTREE,
  KEY `attr_id` (`attr_id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ey_shop_product_attr`
--


--
-- Table structure for table `ey_shop_product_attribute`
--

CREATE TABLE `ey_shop_product_attribute` (
  `attr_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '属性id',
  `attr_name` varchar(60) NOT NULL DEFAULT '' COMMENT '属性名称',
  `list_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '栏目id',
  `attr_index` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0不需要检索 1关键字检索 2范围检索',
  `attr_input_type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT ' 0=文本框，1=下拉框，2=多行文本框',
  `attr_values` text NOT NULL COMMENT '可选值列表',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态(0=禁用，1=启用)',
  `sort_order` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '属性排序',
  `lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
  `is_del` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否已删除，0=否，1=是',
  `add_time` int(11) NOT NULL DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`attr_id`),
  KEY `cat_id` (`list_id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ey_shop_product_attribute`
--


--
-- Table structure for table `ey_shop_product_attrlist`
--

CREATE TABLE `ey_shop_product_attrlist` (
  `list_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '列表id',
  `list_name` varchar(60) NOT NULL DEFAULT '' COMMENT '列表名称',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态(0=禁用，1=启用)',
  `attr_count` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '参数数量',
  `desc` text NOT NULL COMMENT '描述备注',
  `is_del` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否已删除，0=否，1=是',
  `sort_order` int(11) unsigned NOT NULL DEFAULT '100' COMMENT '列表排序',
  `lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
  `add_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`list_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ey_shop_product_attrlist`
--


--
-- Table structure for table `ey_shop_shipping_template`
--

CREATE TABLE `ey_shop_shipping_template` (
  `template_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '运费模板ID',
  `template_region` varchar(255) NOT NULL DEFAULT '' COMMENT '模板运送区域',
  `template_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '模板运费',
  `province_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'region表id',
  `lang` varchar(30) DEFAULT 'cn' COMMENT '语言标识',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`template_id`)
) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 COMMENT='运费模板表';

--
-- Dumping data for table `ey_shop_shipping_template`
--

INSERT INTO `ey_shop_shipping_template` VALUES (1,'北京市',0.00,1,'cn',1554775610),(2,'天津市',0.00,338,'cn',1554775610),(3,'河北省',0.00,636,'cn',1554775610),(4,'山西省',0.00,3102,'cn',1554775610),(5,'内蒙古自治区',0.00,4670,'cn',1554775610),(6,'辽宁省',0.00,5827,'cn',1554775610),(7,'吉林省',0.00,7531,'cn',1554775921),(8,'黑龙江省',0.00,8558,'cn',1554775610),(9,'上海市',0.00,10543,'cn',1554775610),(10,'江苏省',0.00,10808,'cn',1554775610),(11,'浙江省',0.00,12596,'cn',1554775610),(12,'安徽省',0.00,14234,'cn',1554775610),(13,'福建省',0.00,16068,'cn',1554775610),(14,'江西省',0.00,17359,'cn',1554775962),(15,'山东省',0.00,19280,'cn',1554775610),(16,'河南省',0.00,21387,'cn',1554775610),(17,'湖北省',0.00,24022,'cn',1554775610),(18,'湖南省',0.00,25579,'cn',1554775610),(19,'广东省',0.00,28240,'cn',1554775610),(20,'广西壮族自治区',0.00,30164,'cn',1554775610),(21,'海南省',0.00,31563,'cn',1555483193),(22,'重庆市',0.00,31929,'cn',1554775610),(23,'四川省',0.00,33007,'cn',1554775610),(24,'贵州省',0.00,37906,'cn',1554775610),(25,'云南省',0.00,39556,'cn',1554775610),(26,'西藏自治区',0.00,41103,'cn',1554775610),(27,'陕西省',0.00,41877,'cn',1554775610),(28,'甘肃省',0.00,43776,'cn',1554775610),(29,'青海省',0.00,45286,'cn',1554775610),(30,'宁夏回族自治区',0.00,45753,'cn',1554775610),(31,'新疆维吾尔自治区',0.00,46047,'cn',1554775610),(32,'台湾省',0.00,47493,'cn',1554775610),(33,'香港特别行政区',0.00,47494,'cn',1554775610),(34,'澳门特别行政区',0.00,47495,'cn',1554775610),(35,'统一配送价格',0.00,100000,'cn',1556618311);

--
-- Table structure for table `ey_single_content`
--

CREATE TABLE `ey_single_content` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文档ID',
  `typeid` int(10) DEFAULT '0' COMMENT '栏目ID',
  `content` longtext COMMENT '内容详情',
  `content_ey_m` longtext COMMENT '手机端内容详情',
  `add_time` int(11) DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `aid` (`aid`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ey_single_content`
--

INSERT INTO `ey_single_content` VALUES (1,1,1,'&lt;p&gt;&lt;span style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;, Helvetica, &amp;quot;PingFang SC&amp;quot;, &amp;quot;Hiragino Sans GB&amp;quot;, &amp;quot;Microsoft YaHei&amp;quot;, 微软雅黑, Arial, sans-serif; font-size: 14px; text-wrap: wrap; background-color: rgb(255, 255, 255);&quot;&gt;北京徕茵医药科技有限公司成立于2021年11月26日，注册地位于北京市丰台区丽泽路24号院1号楼-5至32层101内4层402-1B，法定代表人为许江波。经营范围包括技术服务、技术开发、技术咨询、技术交流、技术转让、技术推广；信息咨询服务（不含许可类信息咨询服务）；市场调查；健康咨询（不含诊疗服务）；远程健康管理服务；会议及展览服务；设计、制作、代理、发布广告；医学研究和试验发展；数据处理（数据服务中的数据中心只允许建设PUE值在1.4以下的云计算数据中心）；计算机系统服务；信息系统集成服务；数据处理和储存支持服务；物联网技术研发；软件开发；专业设计服务；企业管理；市场营销策划；企业形象策划；咨询策划服务；组织文化艺术交流活动；销售计算机软硬件及辅助设备；基础电信业务；互联网信息服务；第二类增值电信业务；第一类增值电信业务。（市场主体依法自主选择经营项目，开展经营活动；基础电信业务、互联网信息服务、第二类增值电信业务、第一类增值电信业务以及依法须经批准的项目，经相关部门批准后依批准的内容开展经营活动；不得从事国家和本市产业政策禁止和限制类项目的经营活动。）&amp;nbsp;&lt;/span&gt;&lt;/p&gt;','',1720403883,1720403883),(2,2,5,'&lt;p style=&quot;text-align: center;&quot;&gt;&amp;nbsp; 地址:北京市丰台区丽泽路24号院1号楼-5至32层101内4层402-1B&lt;/p&gt;&lt;p style=&quot;text-align: center;&quot;&gt;电话：&lt;span style=&quot;color: rgba(0, 0, 0, 0.85); font-family: &amp;quot;Lucida Grande&amp;quot;, &amp;quot;Lucida Sans Unicode&amp;quot;, &amp;quot;Helvetica Neue&amp;quot;, &amp;quot;Hiragino Sans GB&amp;quot;, &amp;quot;Microsoft Yahei&amp;quot;, sans-serif; font-size: 14px; text-wrap: wrap; background-color: rgb(255, 255, 255);&quot;&gt;010-87505168&lt;/span&gt;&lt;/p&gt;&lt;p style=&quot;text-align: center;&quot;&gt;&amp;nbsp;邮箱：&lt;span style=&quot;color: rgba(0, 0, 0, 0.85); font-family: &amp;quot;Lucida Grande&amp;quot;, &amp;quot;Lucida Sans Unicode&amp;quot;, &amp;quot;Helvetica Neue&amp;quot;, &amp;quot;Hiragino Sans GB&amp;quot;, &amp;quot;Microsoft Yahei&amp;quot;, sans-serif; font-size: 14px; text-wrap: wrap; background-color: rgb(255, 255, 255);&quot;&gt;caiwu@epatient.cn&lt;/span&gt;&lt;/p&gt;&lt;p style=&quot;text-align: center;&quot;&gt;&lt;br/&gt;&lt;/p&gt;','',1720403987,1720403987),(3,3,6,'&lt;p&gt;&lt;span style=&quot;font-family: &amp;quot;Helvetica Neue&amp;quot;, Helvetica, &amp;quot;PingFang SC&amp;quot;, &amp;quot;Hiragino Sans GB&amp;quot;, &amp;quot;Microsoft YaHei&amp;quot;, 微软雅黑, Arial, sans-serif; font-size: 14px; text-wrap: wrap; background-color: rgb(255, 255, 255);&quot;&gt;北京徕茵医药科技有限公司成立于2021年11月26日，注册地位于北京市丰台区丽泽路24号院1号楼-5至32层101内4层402-1B，法定代表人为许江波。经营范围包括技术服务、技术开发、技术咨询、技术交流、技术转让、技术推广；信息咨询服务（不含许可类信息咨询服务）；市场调查；健康咨询（不含诊疗服务）；远程健康管理服务；会议及展览服务；设计、制作、代理、发布广告；医学研究和试验发展；数据处理（数据服务中的数据中心只允许建设PUE值在1.4以下的云计算数据中心）；计算机系统服务；信息系统集成服务；数据处理和储存支持服务；物联网技术研发；软件开发；专业设计服务；企业管理；市场营销策划；企业形象策划；咨询策划服务；组织文化艺术交流活动；销售计算机软硬件及辅助设备；基础电信业务；互联网信息服务；第二类增值电信业务；第一类增值电信业务。（市场主体依法自主选择经营项目，开展经营活动；基础电信业务、互联网信息服务、第二类增值电信业务、第一类增值电信业务以及依法须经批准的项目，经相关部门批准后依批准的内容开展经营活动；不得从事国家和本市产业政策禁止和限制类项目的经营活动。）&amp;nbsp;&lt;/span&gt;&lt;/p&gt;','',1720403897,1720403897),(4,4,7,'&lt;p&gt;医药厂家都是全民所有制企业，在计划经济体制下产量都是国家统一制定的。明显存在着生产与销售不匹配，对于医药的需求不能达到及时性。药品流通领域也全部是全民所有制，计划经济的弊病直接影响到医药的发展。这之后的很多年依然保留着每年两次全国医药成品会议和原料会议。会议中制定生产计划，按照计划完成产量，按计划流通，按计划临床用药。&lt;/p&gt;&lt;p&gt;在特定的历史条件下，一些崭新的符合市场经济的新的因素开始萌芽。由于还有相当的人群不享受公费医疗待遇、计划经济的严重滞后性、人民生活的改变都使得医药方面产生了大量的需求。医药市场出现了供远远小于求的局面，时代的发展和国家政策的帮助下，一种中国特色的企业形式——集体所有制企业给前进发展中的医药行业注入了新的力量。很多的市、县、区政府都相继开办了药品生产企业，甚至很多地方军队系统也参与了进来。开办这些药厂跟当时的历史背景有着很大的关系，由于在***结束后大批的知青上山下乡返乡后待业，一部分没有下乡的知青也处于待业状态，社会出现了大量的剩余劳动力。而处于长期计划经济体制下的百废待兴的社会从编制等多方面容纳不下这么多的劳动力。然而这些知青的父母、伴侣一般都有国家正式编制的工作岗位。另外军队系统中大量的工作人员的伴侣大多没有正式的工作，有的更是长期生活在农村。为了解决很多单位的子女、伴侣的工作和两地生活问题，中国这种特殊的集体企业体制如雨后春笋般的产生了。全民所有制企业是由国家开办并直属于国家的职能管理机构的，而这些新开办的集体企业并没有计划经济专有的直属性，人员编制自然也就不隶属于国家，而直接直属于开办的机构。这时候的集体企业体制上是这样的，由开办单位出资，人员一般优先安排本系统的亲属，如有剩余从社会上招募。在经营上属于自负盈亏，而不是国有企业的国家大包大揽。在厂房建设上，多数属于类似于手工作坊式的厂房。生产范围也多数集中在投资小、技术含量低的制剂上。技术人员也远远落后于全民所有制企业。这些集体企业在创建之初就与大型国有企业相比有着先天不足，生存的环境受到很大的制约。但也许就是由于一直处于危机下，这些医药集体企业迅速的找到了一条求生之路，在后来激烈的市场竞争下很多都存活下来。由于医药的需求大，销售不是核心问题，然而原料药的购入成为了制约集体企业发展的一个突出问题。原料药的生产都控制在全民所有制企业，传统计划经济的体制一直是主旋律，全民所有制的大企业生产的原料药都是优先按照计划供应的，集体企业只能争夺大企业计划外剩余有限的原料。就是在这样一种环境下，集体企业发展着自己。集体企业虽然最后逐渐转化甚至绝大多数现在已经退出历史舞台，然而就是这部分企业基本形成了今天医药企业的基本框架。可是说，集体医药企业对于后世的影响是深远的。套用国家领导人的评价，集体企业是对全民所有制的一个有益的补充。&lt;/p&gt;&lt;p&gt;&lt;br/&gt;&lt;/p&gt;','',1550044592,1550044592),(5,5,8,'','',1550048860,1550048860);

--
-- Table structure for table `ey_sms_log`
--

CREATE TABLE `ey_sms_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '表id',
  `source` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '发送来源，与场景ID对应：0=注册，1=绑定，2=登录密码，3=支付密码，4=找回密码',
  `sms_type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '短信服务商类型，1---阿里云短信， 2---腾讯云短信',
  `mobile` varchar(11) NOT NULL DEFAULT '' COMMENT '手机号',
  `add_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '发送时间',
  `code` varchar(10) NOT NULL DEFAULT '' COMMENT '验证码',
  `status` int(1) unsigned NOT NULL DEFAULT '0' COMMENT '发送状态,1:成功,0:失败',
  `is_use` int(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否使用，1:是，0:否',
  `msg` varchar(255) NOT NULL DEFAULT '' COMMENT '短信内容',
  `ip` varchar(20) DEFAULT 'IP地址',
  `lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
  `error_msg` text NOT NULL COMMENT '发送短信异常内容',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='手机短信发送记录';

--
-- Dumping data for table `ey_sms_log`
--


--
-- Table structure for table `ey_sms_template`
--

CREATE TABLE `ey_sms_template` (
  `tpl_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `sms_type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '短信服务商类型，1---阿里云短信， 2---腾讯云短信',
  `tpl_title` varchar(128) NOT NULL DEFAULT '' COMMENT '短信标题',
  `sms_sign` varchar(50) NOT NULL DEFAULT '' COMMENT '短信签名',
  `sms_tpl_code` varchar(100) NOT NULL DEFAULT '' COMMENT '短信模板ID',
  `tpl_content` varchar(1000) NOT NULL DEFAULT '' COMMENT '发送短信内容',
  `send_scene` varchar(100) NOT NULL DEFAULT '' COMMENT '短信发送场景',
  `is_open` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否开启使用这个模板，1为是，0为否。',
  `lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
  `add_time` int(11) NOT NULL COMMENT '添加时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`tpl_id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='手机短信发送模板';

--
-- Dumping data for table `ey_sms_template`
--

INSERT INTO `ey_sms_template` VALUES (1,1,'账号注册','','','验证码为 ${content} ，请在30分钟内输入验证。','0',1,'cn',1614147717,1614147717),(2,1,'手机绑定','','','验证码为 ${content} ，请在30分钟内输入验证。','1',1,'cn',1614147717,1614147717),(3,1,'找回密码','','','验证码为 ${content} ，请在30分钟内输入验证。','4',1,'cn',1614147717,1614147717),(4,1,'订单付款','','','您有新的消息：您有新的${content}订单，请注意查收！','5',1,'cn',1614147717,1711520788),(5,2,'账号注册','','','验证码为 {1} ，请在30分钟内输入验证。','0',1,'cn',1614147751,1614147751),(6,2,'手机绑定','','','验证码为 {1} ，请在30分钟内输入验证。','1',1,'cn',1614147751,1614147751),(7,2,'找回密码','','','验证码为 {1} ，请在30分钟内输入验证。','4',1,'cn',1614147751,1614147751),(8,2,'订单付款','','','您有新的消息：您有新的{1}订单，请注意查收！','5',1,'cn',1614147751,1711520788),(9,1,'订单发货','','','您有新的消息：您有新的${content}订单，请注意查收！','6',1,'cn',1614147717,1711520788),(10,2,'订单发货','','','您有新的消息：您有新的{1}订单，请注意查收！','6',1,'cn',1614147751,1711520788);

--
-- Table structure for table `ey_smtp_record`
--

CREATE TABLE `ey_smtp_record` (
  `record_id` int(10) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `source` tinyint(1) DEFAULT '0' COMMENT '来源，与场景ID对应：0=默认，2=注册，3=绑定邮箱，4=找回密码',
  `email` varchar(50) DEFAULT '' COMMENT '邮件地址',
  `users_id` int(10) DEFAULT '0' COMMENT '用户ID',
  `code` varchar(20) DEFAULT '' COMMENT '发送邮件内容',
  `status` tinyint(1) DEFAULT '0' COMMENT '是否使用，默认0，0为未使用，1为使用',
  `lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
  `add_time` int(11) DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`record_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='邮件发送记录表';

--
-- Dumping data for table `ey_smtp_record`
--


--
-- Table structure for table `ey_smtp_tpl`
--

CREATE TABLE `ey_smtp_tpl` (
  `tpl_id` int(10) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `tpl_name` varchar(200) DEFAULT '' COMMENT '模板名称',
  `tpl_title` varchar(200) DEFAULT '' COMMENT '邮件标题',
  `tpl_content` text COMMENT '发送邮件内容',
  `send_scene` tinyint(1) DEFAULT '0' COMMENT '邮件发送场景(1=留言表单）',
  `is_open` tinyint(1) DEFAULT '0' COMMENT '是否开启使用这个模板，1为是，0为否。',
  `lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
  `add_time` int(11) DEFAULT '0' COMMENT '添加时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`tpl_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='邮件模板表';

--
-- Dumping data for table `ey_smtp_tpl`
--

INSERT INTO `ey_smtp_tpl` VALUES (1,'留言表单','您有新的留言消息，请查收！','${content}',1,1,'cn',1544763495,1552638302),(2,'会员注册','验证码已发送至您的邮箱，请登录邮箱查看验证码！','${content}',2,1,'cn',1544763495,1552667056),(3,'绑定邮箱','验证码已发送至您的邮箱，请登录邮箱查看验证码！','${content}',3,1,'cn',1544763495,1552667400),(4,'找回密码','验证码已发送至您的邮箱，请登录邮箱查看验证码！','${content}',4,1,'cn',1544763495,1552663577),(5,'订单付款','您有新的待发货订单消息，请到商城订单查看！','${content}',5,1,'cn',1614147717,1711520788),(6,'订单发货','您有新的待收货订单消息，请到会员订单查看！','${content}',6,1,'cn',1711520788,1711520788);

--
-- Table structure for table `ey_special_content`
--

CREATE TABLE `ey_special_content` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `aid` int(10) DEFAULT '0' COMMENT '文档ID',
  `content` longtext COMMENT '内容详情',
  `content_ey_m` longtext COMMENT '手机端内容详情',
  `add_time` int(11) DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `aid` (`aid`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='专题附加表';

--
-- Dumping data for table `ey_special_content`
--


--
-- Table structure for table `ey_special_node`
--

CREATE TABLE `ey_special_node` (
  `node_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文档ID',
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT '节点名称',
  `code` varchar(50) NOT NULL DEFAULT '' COMMENT '节点标识',
  `isauto` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否自动获取文档',
  `keywords` varchar(200) NOT NULL DEFAULT '' COMMENT '关键字（多个中间用'',''分开）',
  `typeid` int(10) NOT NULL DEFAULT '0' COMMENT '栏目ID',
  `aidlist` text NOT NULL COMMENT '关联文章列表（多个中间用'',''分开）',
  `row` int(5) NOT NULL DEFAULT '10' COMMENT '文档数',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态',
  `is_del` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `sort_order` int(11) DEFAULT '0' COMMENT '排序',
  `lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
  `add_time` int(11) DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`node_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='专题节点表';

--
-- Dumping data for table `ey_special_node`
--


--
-- Table structure for table `ey_sql_cache_table`
--

CREATE TABLE `ey_sql_cache_table` (
  `cache_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `sql_name` varchar(60) NOT NULL DEFAULT '' COMMENT 'mysql语句的标识名称，目前由模型名称+模型ID组成',
  `sql_result` text NOT NULL COMMENT 'mysql执行结果',
  `sql_md5` varchar(60) NOT NULL DEFAULT '' COMMENT 'mysql语句MD5的值',
  `sql_query` text NOT NULL COMMENT '完整mysql语句',
  `add_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`cache_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='mysql缓存表';

--
-- Dumping data for table `ey_sql_cache_table`
--

INSERT INTO `ey_sql_cache_table` VALUES (1,'ArchivesMaxID','33','494a17e43cff13eeb4b9c9837c29026c','SELECT MAX(aid) AS tp_max FROM `ey_archives` LIMIT 1',1720404550,1720404550),(2,'|model|all|count|','{\"1\":{\"channel\":1,\"total\":8},\"2\":{\"channel\":2,\"total\":5},\"6\":{\"channel\":6,\"total\":3}}','d5ac17fe5649c6d04f4b174c42f2d535','SELECT channel, count(aid) as total FROM `ey_archives` WHERE  `lang` = \'cn\'  AND `status` = 1  AND `is_del` = 0  AND (  (users_id = 0 OR (users_id > 0 AND arcrank >= 0)) ) GROUP BY `channel`',1720404552,1720404552),(3,'|arctype|all|count|','{\"9\":{\"typeid\":9,\"num\":3},\"10\":{\"typeid\":10,\"num\":5},\"12\":{\"typeid\":12,\"num\":5}}','9f6b5e62b9b8456535e5881c8b05072f','SELECT typeid, count(typeid) as num FROM `ey_archives` WHERE  `channel` IN (1,2,3,4,5,7,51)  AND `lang` = \'cn\'  AND `is_del` = 0  AND (  (users_id = 0 OR (users_id > 0 AND arcrank >= 0)) ) GROUP BY `typeid`',1720404731,1720404731);

--
-- Table structure for table `ey_tagindex`
--

CREATE TABLE `ey_tagindex` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'tagid',
  `tag` varchar(50) NOT NULL DEFAULT '' COMMENT 'tag内容',
  `typeid` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '栏目ID',
  `litpic` varchar(250) DEFAULT '' COMMENT '封面图',
  `seo_title` varchar(200) DEFAULT '' COMMENT 'SEO标题',
  `seo_keywords` varchar(200) DEFAULT '' COMMENT 'SEO关键词',
  `seo_description` text COMMENT 'SEO描述',
  `count` int(10) unsigned DEFAULT '0' COMMENT '点击',
  `total` int(10) unsigned DEFAULT '0' COMMENT '文档数',
  `weekcc` int(10) unsigned DEFAULT '0' COMMENT '周统计',
  `monthcc` int(10) unsigned DEFAULT '0' COMMENT '月统计',
  `weekup` int(10) unsigned DEFAULT '0' COMMENT '每周更新',
  `monthup` int(10) unsigned DEFAULT '0' COMMENT '每月更新',
  `is_common` tinyint(1) DEFAULT '0' COMMENT '是否常用标签，0=否，1=是',
  `sort_order` int(10) DEFAULT '100' COMMENT '排序号',
  `lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
  `add_time` int(10) unsigned DEFAULT '0' COMMENT '添加时间',
  `update_time` int(10) DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `typeid` (`typeid`) USING BTREE,
  KEY `count` (`count`,`total`,`weekcc`,`monthcc`,`weekup`,`monthup`,`add_time`) USING BTREE,
  KEY `tag` (`tag`) USING BTREE,
  KEY `lang` (`lang`,`add_time`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='标签索引表';

--
-- Dumping data for table `ey_tagindex`
--


--
-- Table structure for table `ey_taglist`
--

CREATE TABLE `ey_taglist` (
  `tid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'tagid',
  `aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文档ID',
  `typeid` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '栏目ID',
  `tag` varchar(50) DEFAULT '' COMMENT 'tag内容',
  `arcrank` tinyint(1) DEFAULT '0' COMMENT '阅读权限',
  `lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
  `add_time` int(11) DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`tid`,`aid`),
  KEY `aid` (`aid`,`typeid`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='文章标签表';

--
-- Dumping data for table `ey_taglist`
--


--
-- Table structure for table `ey_tuadui_content`
--

CREATE TABLE `ey_tuadui_content` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `aid` int(10) DEFAULT '0' COMMENT '文档ID',
  `add_time` int(11) DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  `zhicheng1` varchar(200) NOT NULL DEFAULT '' COMMENT '职称一',
  `zhicheng2` varchar(200) NOT NULL DEFAULT '' COMMENT '职称二',
  `zhicheng3` varchar(200) NOT NULL DEFAULT '' COMMENT '职称三',
  `zhicheng4` varchar(200) NOT NULL DEFAULT '' COMMENT '职称四',
  `jianjie` longtext COMMENT '个人简介',
  `zhiwei` varchar(200) NOT NULL DEFAULT '' COMMENT '职位',
  PRIMARY KEY (`id`),
  KEY `aid` (`aid`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='附加表';

--
-- Dumping data for table `ey_tuadui_content`
--

INSERT INTO `ey_tuadui_content` VALUES (1,12,1561625442,1561625442,'高级专业会计硕士','中国注册资产评估师','中国注册会计师','','&lt;p&gt;会计师事务所股权合伙人，具有近30年执业经验，长期从事会计、审计行业积累了丰富的执业经验，使得他十分擅长于企业财务咨询、税收筹划、重组改制等业务，对现代独立审计和企业管理有着独到见解。&lt;/p&gt;&lt;p&gt;&lt;br/&gt;&lt;/p&gt;&lt;p&gt;联系电话：+86 123-4567&lt;/p&gt;&lt;p&gt;电子邮箱： admin@youweb.com&lt;/p&gt;&lt;p&gt;&lt;br/&gt;&lt;/p&gt;','高级合伙人'),(2,13,1561625619,1561625619,'中国注册会计师','中国注册资产评估师','中国注册税务师','高级专业会计硕士','&lt;p&gt;会计师事务所股权合伙人，具有近30年执业经验，长期从事会计、审计行业积累了丰富的执业经验，使得他十分擅长于企业财务咨询、税收筹划、重组改制等业务，对现代独立审计和企业管理有着独到见解。&lt;/p&gt;&lt;p&gt;&lt;br/&gt;&lt;/p&gt;&lt;p&gt;联系电话：+86 123-4567&lt;/p&gt;&lt;p&gt;电子邮箱： admin@youweb.com&lt;/p&gt;','高级合伙人'),(3,14,1561625700,1561625700,'中国注册会计师','澳洲会计师公会会员','美国注册会计师','英国特许公认会计师公会资深会员','&lt;p&gt;拥有二十年丰富的审计及财务咨询经验，曾服务包括香港及美国上市公司在内的不同类型的客户，善长于国际准则审计、商定程序的审计及相关服务。为全国注册会计师行业领军人才、英国特许公认会计师公会资深会员、澳洲会计师公会会员、《小型企业财务报表审计工作底稿编制指南》编写组成员。&lt;/p&gt;&lt;p&gt;&lt;br/&gt;&lt;/p&gt;&lt;p&gt;联系电话：+86 400-123-4567&lt;/p&gt;&lt;p&gt;电子邮箱：admin@youweb.com&lt;/p&gt;&lt;p&gt;&lt;br/&gt;&lt;/p&gt;','高级合伙人'),(4,15,1561625764,1561625764,'中国注册会计师','中国注册资产评估师','中国注册税务师','','&lt;p&gt;执业超过二十五年，多年来致力于为外商投资企业和国有企业的客户提供专业服务，涉及行业包括制造、地产、交通运输、酒店及旅游等。她在会计、审计、税务、外汇、咨询方面具备丰富的实务经验。&lt;/p&gt;&lt;p&gt;&lt;br/&gt;&lt;/p&gt;&lt;p&gt;联系电话：+86 400-123-4567&lt;/p&gt;&lt;p&gt;电子邮箱：admin@youweb.com&lt;/p&gt;&lt;p&gt;&lt;br/&gt;&lt;/p&gt;','合伙人'),(5,45,1561689749,1561689749,'CICPA','CCPV','Master of Professional Accounting','','&lt;p&gt;Equity partners of accounting firms, with nearly 30 years of practice experience, have accumulated rich experience in accounting and auditing industry for a long time, which makes him very good at business such as enterprise financial consultation, tax planning, restructuring and restructuring, and has unique views on modern independent auditing and enterprise management.&lt;/p&gt;&lt;p&gt;&lt;br/&gt;&lt;/p&gt;&lt;p&gt;Contact number: +86 123-4567&lt;/p&gt;&lt;p&gt;E-mail: admin@youweb.com&lt;/p&gt;&lt;p&gt;&lt;br/&gt;&lt;/p&gt;','senior partner'),(6,46,1561689834,1561689834,'CICPA','CCPV','CICTA','Master of Professional Accounting','&lt;p&gt;Equity partners of accounting firms, with nearly 30 years of practice experience, have accumulated rich experience in accounting and auditing industry for a long time, which makes him very good at business such as enterprise financial consultation, tax planning, restructuring and restructuring, and has unique views on modern independent auditing and enterprise management.&lt;/p&gt;&lt;p&gt;&lt;br/&gt;&lt;/p&gt;&lt;p&gt;Contact number: +86 123-4567&lt;/p&gt;&lt;p&gt;E-mail: admin@youweb.com&lt;/p&gt;&lt;p&gt;&lt;br/&gt;&lt;/p&gt;','senior partner'),(7,47,1561689943,1561689943,'CICPA','CCPV','CICTA','Master of Professional Accounting','&lt;p&gt;Equity partners of accounting firms, with nearly 30 years of practice experience, have accumulated rich experience in accounting and auditing industry for a long time, which makes him very good at business such as enterprise financial consultation, tax planning, restructuring and restructuring, and has unique views on modern independent auditing and enterprise management.&lt;/p&gt;&lt;p&gt;&lt;br/&gt;&lt;/p&gt;&lt;p&gt;Contact number: +86 123-4567&lt;/p&gt;&lt;p&gt;E-mail: admin@youweb.com&lt;/p&gt;&lt;p&gt;&lt;br/&gt;&lt;/p&gt;','senior partner'),(8,48,1561689988,1561689988,'CICPA','CCPV','Master of Professional Accounting','','&lt;p&gt;Equity partners of accounting firms, with nearly 30 years of practice experience, have accumulated rich experience in accounting and auditing industry for a long time, which makes him very good at business such as enterprise financial consultation, tax planning, restructuring and restructuring, and has unique views on modern independent auditing and enterprise management.&lt;/p&gt;&lt;p&gt;&lt;br/&gt;&lt;/p&gt;&lt;p&gt;Contact number: +86 123-4567&lt;/p&gt;&lt;p&gt;E-mail: admin@youweb.com&lt;/p&gt;&lt;p&gt;&lt;br/&gt;&lt;/p&gt;','Partner');

--
-- Table structure for table `ey_ui_config`
--

CREATE TABLE `ey_ui_config` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '表id',
  `md5key` varchar(100) NOT NULL DEFAULT '' COMMENT '唯一键值（由 theme_style、page、name）组成',
  `theme_style` varchar(200) DEFAULT 'pc' COMMENT '模板风格',
  `page` varchar(64) DEFAULT '' COMMENT '页面分组',
  `type` varchar(50) DEFAULT '' COMMENT '编辑类型',
  `name` varchar(50) DEFAULT '' COMMENT '与页面的e-id对应',
  `value` text COMMENT '页面美化的val值',
  `idcode` varchar(50) DEFAULT '' COMMENT '页面唯一id标识（由 标识符+栏目id或文档id等）组成',
  `lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
  `add_time` int(11) DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `md5key` (`md5key`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='可视化参数设置';

--
-- Dumping data for table `ey_ui_config`
--


--
-- Table structure for table `ey_uploads`
--

CREATE TABLE `ey_uploads` (
  `img_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `type_id` int(10) NOT NULL DEFAULT '0' COMMENT '分组ID',
  `aid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '文档ID',
  `title` varchar(200) DEFAULT '' COMMENT '文档标题',
  `image_url` varchar(255) DEFAULT '' COMMENT '文件存储路径',
  `intro` varchar(500) DEFAULT '' COMMENT '图集描述',
  `width` int(11) DEFAULT '0' COMMENT '图片宽度',
  `height` int(11) DEFAULT '0' COMMENT '图片高度',
  `filesize` int(11) unsigned DEFAULT '0' COMMENT '文件大小',
  `mime` varchar(50) DEFAULT '' COMMENT '图片类型',
  `users_id` int(11) DEFAULT '0' COMMENT '用户ID',
  `sort_order` smallint(5) DEFAULT '100' COMMENT '排序',
  `is_del` tinyint(1) DEFAULT '0' COMMENT '1已删除 0未删除',
  `add_time` int(10) unsigned DEFAULT '0' COMMENT '上传时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`img_id`),
  KEY `aid` (`aid`) USING BTREE,
  KEY `add_time` (`add_time`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=utf8 COMMENT='上传记录表';

--
-- Dumping data for table `ey_uploads`
--

INSERT INTO `ey_uploads` VALUES (1,0,0,'副本_医疗保险宣传2.5D横版插画__2024-03-27+14_54_00.png','/uploads/allimg/20240327/1-24032G4545Q53.png','',1920,789,235025,'image/png',1,100,0,1711522498,1711522498),(2,0,0,'副本_医院服务图片素材模板__2024-03-27+14_53_53.png','/uploads/allimg/20240327/1-24032G4545Y29.png','',1920,789,1237901,'image/png',1,100,0,1711522498,1711522498),(3,0,0,'9d960f66f7697df6.jpg','/uploads/allimg/20240327/1-24032GA30aF.jpg','',800,800,49261,'image/jpeg',1,100,0,1711529589,1711529589),(4,0,0,'45e5b139cdbb7021.jpg','/uploads/allimg/20240327/1-24032GA30c57.jpg','',800,800,59754,'image/jpeg',1,100,0,1711529589,1711529589),(5,0,0,'49ac79be7a4602cd.jpg','/uploads/allimg/20240327/1-24032GA309523.jpg','',800,800,43035,'image/jpeg',1,100,0,1711529589,1711529589),(6,0,0,'75d9f53c497d59f0.jpg','/uploads/allimg/20240327/1-24032GA309610.jpg','',800,800,100722,'image/jpeg',1,100,0,1711529589,1711529589),(7,0,0,'0abffcf0e6da091e.jpg','/uploads/allimg/20240327/1-24032GA409496.jpg','',800,800,96916,'image/jpeg',1,100,0,1711529649,1711529649),(8,0,0,'1f7facbd6b75b664.jpg','/uploads/allimg/20240327/1-24032GA409454.jpg','',800,800,100256,'image/jpeg',1,100,0,1711529649,1711529649),(9,0,0,'44d5153853185314.jpg','/uploads/allimg/20240327/1-24032GA40b28.jpg','',800,800,61021,'image/jpeg',1,100,0,1711529649,1711529649),(10,0,0,'5517d878a12d27b4.jpg','/uploads/allimg/20240327/1-24032GA4092E.jpg','',800,800,65314,'image/jpeg',1,100,0,1711529649,1711529649),(11,0,0,'717580302a6a2aa7.jpg','/uploads/allimg/20240327/1-24032GA409215.jpg','',800,800,62932,'image/jpeg',1,100,0,1711529649,1711529649),(12,0,0,'72c0a30a44bb6cdd.jpg','/uploads/allimg/20240327/1-24032GA509E0.jpg','',800,800,42299,'image/jpeg',1,100,0,1711529709,1711529709),(13,0,0,'246d8bb9a3c932ad.jpg','/uploads/allimg/20240327/1-24032GA509610.jpg','',800,800,36146,'image/jpeg',1,100,0,1711529709,1711529709),(14,0,0,'581ed46dfb102e97.jpg','/uploads/allimg/20240327/1-24032GA5091b.jpg','',800,800,39488,'image/jpeg',1,100,0,1711529709,1711529709),(15,0,0,'fac25ff0d60533b4.jpg','/uploads/allimg/20240327/1-24032GA509513.jpg','',800,800,191889,'image/jpeg',1,100,0,1711529709,1711529709),(16,0,0,'0c2afd93390850f0.png','/uploads/allimg/20240327/1-24032GA555J7.png','',818,822,528394,'image/png',1,100,0,1711529755,1711529755),(17,0,0,'15103f6b4b385e90.png','/uploads/allimg/20240327/1-24032GA555926.png','',686,565,153227,'image/png',1,100,0,1711529755,1711529755),(18,0,0,'d047c1c4665b43b7.png','/uploads/allimg/20240327/1-24032GA555N9.png','',680,708,561812,'image/png',1,100,0,1711529755,1711529755),(19,0,0,'e98a89e37fbc7f98.png','/uploads/allimg/20240327/1-24032GA555400.png','',436,661,129807,'image/png',1,100,0,1711529755,1711529755),(20,0,0,'f9490532bf2bbb8f.png','/uploads/allimg/20240327/1-24032GA5555b.png','',389,718,141112,'image/png',1,100,0,1711529755,1711529755),(21,0,0,'5d181ecd1ad63e8f.jpg','/uploads/allimg/20240327/1-24032GAA35U.jpg','',750,750,51500,'image/jpeg',1,100,0,1711529813,1711529813),(22,0,0,'06bc59b4afa525e0.jpg','/uploads/allimg/20240327/1-24032GAA3K3.jpg','',750,750,125099,'image/jpeg',1,100,0,1711529813,1711529813),(23,0,0,'6a5ba88e31a81d66.jpg','/uploads/allimg/20240327/1-24032GAA3140.jpg','',750,750,145742,'image/jpeg',1,100,0,1711529813,1711529813),(24,0,0,'99f6b1c79dd4a969.jpg','/uploads/allimg/20240327/1-24032GAA3C8.jpg','',750,750,53437,'image/jpeg',1,100,0,1711529813,1711529813),(25,0,0,'be09f4f30e33a597.jpg','/uploads/allimg/20240327/1-24032GAA3a9.jpg','',750,750,44534,'image/jpeg',1,100,0,1711529813,1711529813),(26,0,0,'9ababd5ab93e9b23.jpg','/uploads/allimg/20240327/1-24032GAS1D6.jpg','',790,787,110943,'image/jpeg',1,100,0,1711529911,1711529911),(27,0,0,'87a7823c6fb7823a.jpg','/uploads/allimg/20240327/1-24032GAS15V.jpg','',790,1269,197084,'image/jpeg',1,100,0,1711529911,1711529911),(28,0,0,'529a47f3d34fe386.jpg','/uploads/allimg/20240327/1-24032GAS1157.jpg','',790,664,137268,'image/jpeg',1,100,0,1711529911,1711529911),(29,0,0,'c7839eab7bb7d127.jpg','/uploads/allimg/20240327/1-24032GAS1335.jpg','',790,1178,82385,'image/jpeg',1,100,0,1711529911,1711529911),(30,0,0,'企业微信截图_17115308323219.png','/uploads/allimg/20240327/1-24032GG414N2.png','',1198,777,222103,'image/png',1,100,0,1711530854,1711530854),(31,0,0,'副本_清新简约早教logo__2024-07-08+09_53_51.png','/uploads/allimg/20240708/1-240FP955525K.png','',302,73,11727,'image/png',1,100,0,1720403752,1720403752),(32,0,0,'1720404104884.jpg','/uploads/allimg/20240708/1-240FQ00212262.jpg','',1056,635,224367,'image/png',1,100,0,1720404132,1720404132),(33,0,0,'副本_医院服务图片素材模板__2024-07-08+10_04_56.png','/uploads/allimg/20240708/1-240FQ00520Z5.png','',1920,789,1035470,'image/png',1,100,0,1720404320,1720404320);

--
-- Table structure for table `ey_uploads_type`
--

CREATE TABLE `ey_uploads_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `upload_type` varchar(50) NOT NULL DEFAULT '' COMMENT '名称',
  `add_time` int(10) NOT NULL DEFAULT '0' COMMENT '新增时间',
  `update_time` int(10) NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='上传分组表';

--
-- Dumping data for table `ey_uploads_type`
--


--
-- Table structure for table `ey_users`
--

CREATE TABLE `ey_users` (
  `users_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '表id',
  `username` varchar(30) NOT NULL DEFAULT '' COMMENT '用户名',
  `password` varchar(255) NOT NULL DEFAULT '' COMMENT '登录密码',
  `nickname` varchar(50) NOT NULL DEFAULT '' COMMENT '昵称',
  `is_mobile` tinyint(1) DEFAULT '0' COMMENT '绑定手机号，0为不绑定，1为绑定',
  `mobile` varchar(20) NOT NULL DEFAULT '' COMMENT '手机号码（仅用于登录）',
  `is_email` tinyint(1) DEFAULT '0' COMMENT '绑定邮箱，0为不绑定，1为绑定',
  `email` varchar(60) NOT NULL DEFAULT '' COMMENT '电子邮件（仅用于登录）',
  `paypwd` varchar(255) DEFAULT '' COMMENT '支付密码，暂时未用到，可保留。',
  `users_money` decimal(10,2) DEFAULT '0.00' COMMENT '用户金额',
  `frozen_money` decimal(10,2) DEFAULT '0.00' COMMENT '冻结金额',
  `scores` int(10) DEFAULT '0' COMMENT '积分',
  `devote` int(10) DEFAULT '0' COMMENT '贡献值',
  `reg_time` int(11) unsigned DEFAULT '0' COMMENT '注册时间',
  `last_login` int(11) unsigned DEFAULT '0' COMMENT '最后登录时间',
  `last_ip` varchar(15) DEFAULT '' COMMENT '最后登录ip',
  `login_count` int(11) DEFAULT '0' COMMENT '登陆次数',
  `head_pic` varchar(255) DEFAULT '' COMMENT '头像',
  `province` int(6) DEFAULT '0' COMMENT '省份',
  `city` int(6) DEFAULT '0' COMMENT '市区',
  `district` int(6) DEFAULT '0' COMMENT '县',
  `level` smallint(5) DEFAULT '0' COMMENT '会员等级',
  `open_level_time` int(11) unsigned DEFAULT '0' COMMENT '开通会员级别时间',
  `level_maturity_days` varchar(20) DEFAULT '' COMMENT '会员级别到期天数',
  `discount` decimal(10,2) DEFAULT '1.00' COMMENT '会员折扣，默认1不享受',
  `total_amount` decimal(10,2) DEFAULT '0.00' COMMENT '消费累计额度',
  `is_activation` tinyint(1) DEFAULT '1' COMMENT '是否激活，0否，1是。\r\n后台注册默认为1激活。\r\n前台注册时，当会员功能设置选择后台审核，需后台激活才可以登陆。',
  `register_place` tinyint(1) DEFAULT '2' COMMENT '注册位置。后台注册不受注册验证影响，1为后台注册，2为前台注册。默认为2。',
  `open_id` varchar(50) NOT NULL DEFAULT '' COMMENT '第三方唯一标识openid',
  `thirdparty` tinyint(1) DEFAULT '0' COMMENT '第三方注册类型：0=普通，1=微信，2=QQ',
  `is_lock` tinyint(1) DEFAULT '0' COMMENT '是否被锁定冻结',
  `admin_id` int(10) DEFAULT '0' COMMENT '关联管理员ID',
  `lang` varchar(20) DEFAULT 'cn' COMMENT '语言标识',
  `is_del` tinyint(1) DEFAULT '0' COMMENT '伪删除，1=是，0=否',
  `unread_notice_num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '未读消息数量',
  `update_time` int(11) unsigned DEFAULT '0' COMMENT '更新时间',
  `sex` varchar(10) DEFAULT '保密' COMMENT '性别- 男,女,保密',
  `coin` int(11) unsigned DEFAULT '0' COMMENT '金币',
  `union_id` varchar(50) NOT NULL DEFAULT '' COMMENT '微信用户的unionId',
  PRIMARY KEY (`users_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='会员信息表';

--
-- Dumping data for table `ey_users`
--

INSERT INTO `ey_users` VALUES (1,'admin','185d0272d8bff6f935edba3dbfc1cd90','admin',0,'',0,'','',0.00,0.00,0,0,1614147675,1720403666,'',0,'/public/static/common/images/dfboy.png',0,0,0,1,0,'',1.00,0.00,1,1,'',0,0,1,'cn',0,0,1720403666,'保密',0,'');

--
-- Table structure for table `ey_users_bottom_menu`
--

CREATE TABLE `ey_users_bottom_menu` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `title` varchar(30) DEFAULT '' COMMENT '导航名称',
  `mca` varchar(50) DEFAULT '' COMMENT '分组/控制器/操作名',
  `icon` varchar(255) NOT NULL DEFAULT '' COMMENT '图标',
  `sort_order` int(10) DEFAULT '100' COMMENT '排序号',
  `status` tinyint(1) DEFAULT '1' COMMENT '功能开关状态，1=开启，0=关闭',
  `display` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否显示, 1--是, 0--否',
  `lang` varchar(20) DEFAULT 'cn' COMMENT '语言标识',
  `add_time` int(11) DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='会员中心移动端底部菜单表';

--
-- Dumping data for table `ey_users_bottom_menu`
--

INSERT INTO `ey_users_bottom_menu` VALUES (1,'首页','home/Index/index','shouye',100,1,1,'cn',1614147751,1614147751),(2,'下载','user/Download/index','xiazai',100,1,1,'cn',1614147751,1614147751),(3,'发布','user/UsersRelease/article_add','fabu',100,1,1,'cn',1614147751,1614147751),(4,'我的','user/Users/centre','geren',100,1,1,'cn',1614147751,1614147751);

--
-- Table structure for table `ey_users_collection`
--

CREATE TABLE `ey_users_collection` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `users_id` int(10) DEFAULT '0',
  `aid` int(10) DEFAULT '0' COMMENT '文档id',
  `channel` int(10) DEFAULT '0' COMMENT '模型',
  `typeid` int(10) DEFAULT '0' COMMENT '栏目',
  `title` varchar(200) DEFAULT '' COMMENT '网站标题',
  `litpic` varchar(255) DEFAULT '' COMMENT '缩略图',
  `lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
  `add_time` int(11) DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='我的收藏';

--
-- Dumping data for table `ey_users_collection`
--


--
-- Table structure for table `ey_users_config`
--

CREATE TABLE `ey_users_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '会员功能配置表ID',
  `name` varchar(50) DEFAULT '' COMMENT '配置的key键名',
  `value` text COMMENT '配置的value值',
  `desc` varchar(100) DEFAULT '' COMMENT '键名说明',
  `inc_type` varchar(64) DEFAULT '' COMMENT '配置分组',
  `lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='会员功能配置表';

--
-- Dumping data for table `ey_users_config`
--

INSERT INTO `ey_users_config` VALUES (1,'users_reg_notallow','www,bbs,ftp,mail,user,users,admin,administrator,eyoucms','不允许注册的会员名','users','cn',1547890773),(2,'score_signin_status','1','','score','cn',1614147751),(3,'score_signin_score','3','','score','cn',1614147751),(4,'shop_open','0','','shop','cn',1651053470),(5,'pay_balance_open','1','','pay','cn',1711520788),(6,'users_login_expiretime','3600','','users','cn',1711520789);

--
-- Table structure for table `ey_users_footprint`
--

CREATE TABLE `ey_users_footprint` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `channel` int(10) DEFAULT '0' COMMENT '频道模型',
  `typeid` int(10) DEFAULT '0' COMMENT '栏目id',
  `aid` int(10) DEFAULT '0' COMMENT '文档id',
  `title` varchar(100) DEFAULT '' COMMENT '网站标题',
  `litpic` varchar(255) DEFAULT '' COMMENT '缩略图',
  `users_id` int(10) DEFAULT '0',
  `lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
  `add_time` int(11) DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `users_id` (`users_id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='我的足迹';

--
-- Dumping data for table `ey_users_footprint`
--

INSERT INTO `ey_users_footprint` VALUES (1,1,10,15,'正确使用电子血压计应注意哪些问题？','/uploads/allimg/20190213/b13ec3351ccc257c704a93723dcc6eb9.jpg',1,'cn',1711604759,1711604759),(2,2,12,23,'汾河 扑尔敏 马来酸氯苯那敏片100片 抗过敏药荨麻疹皮炎鼻炎皮肤过敏 1盒','/uploads/allimg/20240327/1-24032GA409496.jpg',1,'cn',1711604887,1711604887),(3,2,12,24,'999]糠酸莫米松乳膏 0.1%10g支','/uploads/allimg/20240327/1-24032GA30c57.jpg',1,'cn',1711604894,1720404394);

--
-- Table structure for table `ey_users_forward`
--

CREATE TABLE `ey_users_forward` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `users_id` int(10) DEFAULT '0',
  `aid` int(10) DEFAULT '0' COMMENT '文档id',
  `channel` int(10) DEFAULT '0' COMMENT '模型',
  `typeid` int(10) DEFAULT '0' COMMENT '栏目',
  `title` varchar(200) DEFAULT '' COMMENT '网站标题',
  `litpic` varchar(255) DEFAULT '' COMMENT '缩略图',
  `lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
  `add_time` int(11) DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='转发记录';

--
-- Dumping data for table `ey_users_forward`
--


--
-- Table structure for table `ey_users_level`
--

CREATE TABLE `ey_users_level` (
  `level_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `level_name` varchar(30) DEFAULT '' COMMENT '级别名称',
  `level_value` int(10) DEFAULT '0' COMMENT '会员等级值',
  `is_system` tinyint(1) DEFAULT '0' COMMENT '类型，1=系统，0=用户',
  `amount` decimal(10,2) DEFAULT '0.00' COMMENT '消费额度',
  `down_count` int(10) DEFAULT '0' COMMENT '每天下载次数限制',
  `discount` float(10,2) DEFAULT '100.00' COMMENT '折扣率，初始值为100即100%，无折扣',
  `posts_count` int(10) DEFAULT '5' COMMENT '会员投稿次数限制',
  `ask_is_release` tinyint(1) DEFAULT '1' COMMENT '允许在问答中发布问题，1=是，0=否',
  `ask_is_review` tinyint(1) DEFAULT '0' COMMENT '在问答中发布问题或回答是否需要审核，1=是，0=否',
  `lang` varchar(20) DEFAULT 'cn' COMMENT '语言标识',
  `add_time` int(11) DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`level_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='会员级别表';

--
-- Dumping data for table `ey_users_level`
--

INSERT INTO `ey_users_level` VALUES (1,'注册会员',10,1,0.00,100,100.00,5,1,0,'cn',0,1551151513),(2,'中级会员',50,0,0.00,100,100.00,10,1,0,'cn',1568887454,1568887454),(3,'高级会员',100,0,0.00,100,100.00,20,1,0,'cn',1568887454,1568887454);

--
-- Table structure for table `ey_users_like`
--

CREATE TABLE `ey_users_like` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `users_id` int(10) DEFAULT '0',
  `aid` int(10) DEFAULT '0' COMMENT '文档id',
  `channel` int(10) DEFAULT '0' COMMENT '模型',
  `typeid` int(10) DEFAULT '0' COMMENT '栏目',
  `title` varchar(200) DEFAULT '' COMMENT '网站标题',
  `litpic` varchar(255) DEFAULT '' COMMENT '缩略图',
  `lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
  `add_time` int(11) DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='我喜欢的';

--
-- Dumping data for table `ey_users_like`
--


--
-- Table structure for table `ey_users_list`
--

CREATE TABLE `ey_users_list` (
  `list_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `users_id` int(10) NOT NULL DEFAULT '0' COMMENT '会员ID',
  `para_id` int(10) NOT NULL DEFAULT '0' COMMENT '属性ID',
  `info` text COMMENT '属性值',
  `lang` varchar(50) NOT NULL DEFAULT 'cn' COMMENT '语言标识',
  `add_time` int(11) NOT NULL DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`list_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='会员属性表(信息）';

--
-- Dumping data for table `ey_users_list`
--


--
-- Table structure for table `ey_users_menu`
--

CREATE TABLE `ey_users_menu` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `title` varchar(30) DEFAULT '' COMMENT '导航名称',
  `version` varchar(10) DEFAULT 'weapp' COMMENT '分组',
  `mca` varchar(50) DEFAULT '' COMMENT '分组/控制器/操作名',
  `active_url` varchar(500) DEFAULT '' COMMENT '标记为选中的url',
  `is_userpage` tinyint(1) DEFAULT '0' COMMENT '默认会员首页',
  `sort_order` int(10) DEFAULT '0' COMMENT '排序号',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态，1=显示，0=隐藏',
  `lang` varchar(20) DEFAULT 'cn' COMMENT '语言标识',
  `add_time` int(11) DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='会员菜单表';

--
-- Dumping data for table `ey_users_menu`
--

INSERT INTO `ey_users_menu` VALUES (1,'个人信息','v1','user/Users/index','',1,100,1,'cn',1555904190,1555917737),(2,'账户充值','v1','user/Pay/pay_consumer_details','',0,100,1,'cn',1555904190,1555917761),(3,'商城中心','v1','user/Shop/shop_centre','',0,100,0,'cn',1555904190,1555917761),(4,'会员升级','v1','user/Level/level_centre','',0,100,0,'cn',1555904190,1555917761),(5,'会员投稿','v1','user/UsersRelease/release_centre','',0,100,0,'cn',1555904190,1555917761),(6,'我的下载','v1','user/Download/index','',0,100,0,'cn',1590484667,1614147751),(7,'个人中心','v2','user/Users/index','user/Users/index|user/Pay/pay_account_recharge|user/Users/footprint_index|user/Level/level_centre|user/Download/index|user/Users/media_index',1,100,1,'cn',1608708057,1609385363),(8,'我的信息','v2','user/Users/info','user/Users/info',0,100,1,'cn',1608709100,1609385363),(9,'我的收藏','v2','user/Users/collection_index','user/Users/collection_index',0,100,1,'cn',1608708100,1609385363),(10,'财务明细','v2','user/Pay/pay_consumer_details','user/Pay/pay_consumer_details|user/Users/score_index',0,100,1,'cn',1608709000,1609387813);

--
-- Table structure for table `ey_users_money`
--

CREATE TABLE `ey_users_money` (
  `moneyid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '金额明细表ID',
  `users_id` int(10) DEFAULT '0' COMMENT '会员表ID',
  `money` decimal(10,2) DEFAULT '0.00' COMMENT '金额',
  `users_money` decimal(10,2) DEFAULT '0.00' COMMENT '此条记录的账户金额',
  `cause` text COMMENT '事由，暂时在升级消费中使用到，以serialize序列化后存入，用于后续查询。',
  `cause_type` tinyint(1) DEFAULT '0' COMMENT '数据类型，0为消费，1为充值。其余后续添加。',
  `status` tinyint(1) DEFAULT '1' COMMENT '是否成功，默认1，0失败，1未付款，2已付款，3已完成，4订单取消。',
  `pay_method` varchar(50) DEFAULT '' COMMENT '支付方式，wechat为微信支付，alipay为支付宝支付',
  `wechat_pay_type` varchar(20) NOT NULL DEFAULT '' COMMENT '微信支付时，标记使用的支付类型（扫码支付，微信内部，微信H5页面）',
  `pay_details` text COMMENT '支付时返回的数据，以serialize序列化后存入，用于后续查询。',
  `order_number` varchar(30) DEFAULT '' COMMENT '订单号',
  `level_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '会员升级时所升级的会员级别ID，默认0',
  `lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
  `add_time` int(11) DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`moneyid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='金额明细表';

--
-- Dumping data for table `ey_users_money`
--


--
-- Table structure for table `ey_users_notice`
--

CREATE TABLE `ey_users_notice` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) DEFAULT '' COMMENT '通知标题',
  `users_id` text NOT NULL COMMENT '用户id',
  `usernames` text NOT NULL COMMENT '用户名字符串',
  `remark` text COMMENT '通知信息',
  `lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
  `add_time` int(11) DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='站内通知';

--
-- Dumping data for table `ey_users_notice`
--


--
-- Table structure for table `ey_users_notice_read`
--

CREATE TABLE `ey_users_notice_read` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `users_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
  `notice_id` int(10) DEFAULT NULL COMMENT '站内信id',
  `is_read` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否已读, 1---是, 0---否',
  `is_del` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除, 1---是, 0---否',
  `lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
  `add_time` int(11) DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用户已读站内通知';

--
-- Dumping data for table `ey_users_notice_read`
--


--
-- Table structure for table `ey_users_notice_tpl`
--

CREATE TABLE `ey_users_notice_tpl` (
  `tpl_id` int(10) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `tpl_name` varchar(200) DEFAULT '' COMMENT '模板名称',
  `tpl_title` varchar(200) DEFAULT '' COMMENT '站内信标题',
  `tpl_content` text COMMENT '发送内容',
  `send_scene` tinyint(1) DEFAULT '0' COMMENT '站内信发送场景(1=留言表单）',
  `is_open` tinyint(1) DEFAULT '0' COMMENT '是否开启使用这个模板，1为是，0为否。',
  `lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
  `add_time` int(11) DEFAULT '0' COMMENT '添加时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`tpl_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='站内信模板表';

--
-- Dumping data for table `ey_users_notice_tpl`
--

INSERT INTO `ey_users_notice_tpl` VALUES (1,'留言表单','您有新的留言消息，请到内容管理中查看！','${content}',1,1,'cn',1711520788,1711520788),(5,'订单付款','您有新的待发货订单消息，请到商城订单查看！','${content}',5,1,'cn',1711520788,1711520788),(6,'订单发货','您有新的待收货订单消息，请到会员订单查看！','${content}',6,1,'cn',1711520788,1711520788);

--
-- Table structure for table `ey_users_notice_tpl_content`
--

CREATE TABLE `ey_users_notice_tpl_content` (
  `content_id` int(10) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `source` tinyint(1) DEFAULT '0' COMMENT '来源，对应 users_notice_tpl 表 send_scene 字段',
  `admin_id` int(10) DEFAULT '0' COMMENT '管理员ID，不为空则表示管理员接收信息',
  `users_id` int(10) DEFAULT '0' COMMENT '用户ID，不为空则表示会员接收信息，暂未使用',
  `content_title` varchar(200) DEFAULT '' COMMENT '通知标题',
  `content` text COMMENT '接收的通知内容',
  `is_read` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否已读，默认0，1是，0否',
  `lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
  `add_time` int(11) DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`content_id`),
  KEY `admin_id` (`admin_id`) USING BTREE,
  KEY `users_id` (`users_id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='站内信发送接收记录表';

--
-- Dumping data for table `ey_users_notice_tpl_content`
--


--
-- Table structure for table `ey_users_parameter`
--

CREATE TABLE `ey_users_parameter` (
  `para_id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT '标题',
  `name` varchar(100) NOT NULL DEFAULT '' COMMENT '名称',
  `dtype` varchar(32) NOT NULL DEFAULT '' COMMENT '字段类型',
  `dfvalue` varchar(1000) NOT NULL DEFAULT '' COMMENT '默认值',
  `is_system` tinyint(1) DEFAULT '0' COMMENT '是否为系统属性，系统属性不可删除，1为是，0为否，默认0。',
  `is_hidden` tinyint(1) DEFAULT '0' COMMENT '是否禁用属性，1为是，0为否',
  `is_required` tinyint(1) DEFAULT '0' COMMENT '是否为必填属性，1为是，0为否，默认0。',
  `is_reg` tinyint(1) DEFAULT '1' COMMENT '是否为注册表单，1为是，0为否',
  `placeholder` varchar(255) DEFAULT '' COMMENT '提示文字',
  `sort_order` smallint(5) NOT NULL DEFAULT '0' COMMENT '排序',
  `lang` varchar(50) NOT NULL DEFAULT 'cn' COMMENT '语言标识',
  `add_time` int(11) NOT NULL DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`para_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='会员属性表(字段)';

--
-- Dumping data for table `ey_users_parameter`
--

INSERT INTO `ey_users_parameter` VALUES (1,'手机号码','mobile_1','mobile','',1,0,0,1,'',1,'cn',0,1614147751),(2,'邮箱地址','email_2','email','',1,0,1,1,'',1,'cn',0,1614147751);

--
-- Table structure for table `ey_users_score`
--

CREATE TABLE `ey_users_score` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '积分明细表',
  `type` tinyint(1) DEFAULT '1' COMMENT '类型:1-提问,2-回答,3-最佳答案4-悬赏退回,5-每日签到',
  `users_id` int(10) DEFAULT '0' COMMENT '用户id',
  `ask_id` int(10) DEFAULT '0' COMMENT '问题id',
  `reply_id` int(10) DEFAULT '0' COMMENT '回答id',
  `score` int(10) DEFAULT '0' COMMENT '积分',
  `devote` int(10) DEFAULT '0' COMMENT '贡献值,同score',
  `money` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '余额',
  `info` varchar(255) DEFAULT '' COMMENT '说明',
  `lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
  `add_time` int(10) DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='积分详情表';

--
-- Dumping data for table `ey_users_score`
--


--
-- Table structure for table `ey_users_signin`
--

CREATE TABLE `ey_users_signin` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `users_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
  `lang` varchar(50) NOT NULL DEFAULT 'cn' COMMENT '语言标识',
  `add_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '签到时间',
  PRIMARY KEY (`id`),
  KEY `users_id` (`users_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用户签到表';

--
-- Dumping data for table `ey_users_signin`
--


--
-- Table structure for table `ey_users_type_manage`
--

CREATE TABLE `ey_users_type_manage` (
  `type_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `type_name` varchar(30) DEFAULT '' COMMENT '类型名称',
  `level_id` int(10) DEFAULT '0' COMMENT '会员等级ID',
  `price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '价格',
  `limit_id` int(10) DEFAULT '0' COMMENT '会员期限限制，存储ID，值对应常量表的admin_member_limit_arr数组',
  `activity` varchar(30) DEFAULT '' COMMENT '活动文案',
  `sort_order` smallint(5) NOT NULL DEFAULT '0' COMMENT '排序',
  `lang` varchar(20) DEFAULT 'cn' COMMENT '语言标识',
  `add_time` int(11) DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`type_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='会员产品类型表';

--
-- Dumping data for table `ey_users_type_manage`
--

INSERT INTO `ey_users_type_manage` VALUES (1,'升级为本站中级会员',2,100.00,2,'',100,'cn',1568887454,1568887454),(2,'升级为本站高级会员',3,200.00,3,'',100,'cn',1568887454,1568887454);

--
-- Table structure for table `ey_video_content`
--

CREATE TABLE `ey_video_content` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `aid` int(10) DEFAULT '0' COMMENT '文档ID',
  `add_time` int(11) DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  `vdsrc` varchar(200) NOT NULL DEFAULT '' COMMENT '视频地址',
  PRIMARY KEY (`id`),
  KEY `aid` (`aid`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='附加表';

--
-- Dumping data for table `ey_video_content`
--

INSERT INTO `ey_video_content` VALUES (1,13,1552364595,1552364595,'http://player.youku.com/embed/XMzU1NzU5MzM4MA=='),(2,14,1552364689,1552364689,'http://player.youku.com/embed/XMzYyOTQ2MjA5Mg=='),(3,52,1552382177,1552382177,'http://player.youku.com/embed/XMzU1NzU5MzM4MA=='),(4,53,1552382208,1552382208,'http://player.youku.com/embed/XMzYyOTQ2MjA5Mg==');

--
-- Table structure for table `ey_weapp`
--

CREATE TABLE `ey_weapp` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(50) DEFAULT '' COMMENT '插件标识',
  `name` varchar(55) DEFAULT '' COMMENT '中文名字',
  `config` text COMMENT '配置信息',
  `data` text COMMENT '额外序列化存储数据，简单插件可以不创建表，存储这里即可',
  `status` tinyint(1) DEFAULT '0' COMMENT '状态：0=未安装，1=启用，-1=禁用',
  `tag_weapp` tinyint(1) DEFAULT '1' COMMENT '1=自动绑定，2=手工调用。关联模板标签weapp，自动调用内置的show钩子方法',
  `thorough` tinyint(1) DEFAULT '0' COMMENT '彻底卸载：0=是，1=否',
  `position` varchar(30) DEFAULT 'default' COMMENT '插件位置',
  `is_buy` tinyint(1) DEFAULT '0' COMMENT '0-本地,1-线上购买 2-线上购买,但已删除,不显示在我的插件列表',
  `is_upgrade` tinyint(1) DEFAULT '1' COMMENT '是否提示升级',
  `sort_order` int(10) DEFAULT '100' COMMENT '排序号',
  `add_time` int(11) DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `code` (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='插件应用表';

--
-- Dumping data for table `ey_weapp`
--


--
-- Table structure for table `ey_weapp_ask`
--

CREATE TABLE `ey_weapp_ask` (
  `ask_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `type_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '问题栏目ID',
  `users_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员ID',
  `ask_title` varchar(80) NOT NULL DEFAULT '' COMMENT '问题标题',
  `is_recom` tinyint(1) NOT NULL DEFAULT '0' COMMENT '问题是否推荐',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '问题状态：0未解决，1已解决，2已关闭',
  `click` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '浏览点击量',
  `replies` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '问题回复量',
  `content` text NOT NULL COMMENT '问题内容',
  `url` varchar(255) NOT NULL DEFAULT '' COMMENT '问题网址',
  `users_ip` varchar(50) NOT NULL DEFAULT '' COMMENT '问题发布时IP地址',
  `is_review` tinyint(1) NOT NULL DEFAULT '1' COMMENT '问题是否审核，1是，0否',
  `follow` tinyint(1) NOT NULL DEFAULT '0' COMMENT '关注问题则表示有回复时发送邮件通知到问题发布人',
  `solve_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '解决时间(这个问题存在最佳答案则表示已解决)',
  `bestanswer_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最佳答案',
  `sort_order` int(10) NOT NULL DEFAULT '100' COMMENT '排序号',
  `add_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '新增时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`ask_id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='问题表';

--
-- Dumping data for table `ey_weapp_ask`
--


--
-- Table structure for table `ey_weapp_ask_answer`
--

CREATE TABLE `ey_weapp_ask_answer` (
  `answer_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `ask_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '问题ID',
  `is_bestanswer` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否最佳答案，0否，1是',
  `is_review` tinyint(1) NOT NULL DEFAULT '1' COMMENT '问题是否审核，1是，0否',
  `type_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '问题栏目ID',
  `users_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
  `username` varchar(50) NOT NULL DEFAULT '' COMMENT '用户名',
  `click_like` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '点赞量',
  `users_ip` varchar(30) NOT NULL DEFAULT '' COMMENT '用户IP地址',
  `content` text NOT NULL COMMENT '内容',
  `ifcheck` tinyint(1) NOT NULL DEFAULT '1',
  `answer_pid` int(10) NOT NULL DEFAULT '0' COMMENT '子答案的父答案',
  `at_users_id` int(10) NOT NULL DEFAULT '0' COMMENT '被@的用户ID',
  `at_answer_id` int(10) NOT NULL DEFAULT '0' COMMENT '@答案ID',
  `add_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '新增时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`answer_id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='答案表';

--
-- Dumping data for table `ey_weapp_ask_answer`
--


--
-- Table structure for table `ey_weapp_ask_answer_like`
--

CREATE TABLE `ey_weapp_ask_answer_like` (
  `like_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `ask_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '问题ID',
  `answer_id` int(10) NOT NULL DEFAULT '0' COMMENT '答案ID',
  `users_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
  `click_like` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '点赞',
  `users_ip` varchar(30) NOT NULL DEFAULT '' COMMENT '用户IP地址',
  `add_time` int(10) unsigned NOT NULL DEFAULT '0',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`like_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='答案点赞表';

--
-- Dumping data for table `ey_weapp_ask_answer_like`
--


--
-- Table structure for table `ey_weapp_ask_type`
--

CREATE TABLE `ey_weapp_ask_type` (
  `type_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '栏目自增',
  `type_name` varchar(100) NOT NULL DEFAULT '' COMMENT '栏目名称',
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上级ID',
  `sort_order` int(10) unsigned NOT NULL DEFAULT '100' COMMENT '排序号',
  `add_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '新增时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`type_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='问题栏目分类表';

--
-- Dumping data for table `ey_weapp_ask_type`
--

INSERT INTO `ey_weapp_ask_type` VALUES (1,'问题求助',0,100,1565770890,1648617311),(2,'功能建议',0,100,1565770890,1648617311),(3,'业务咨询',0,100,1565770890,1648617311),(4,'BUG反馈',1,100,1565771021,1648617311),(5,'其他问题',1,100,1565771021,1648617311);

--
-- Table structure for table `ey_weapp_bshoucang`
--

CREATE TABLE `ey_weapp_bshoucang` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) DEFAULT '' COMMENT '网站标题',
  `url` varchar(100) DEFAULT '' COMMENT '网站地址',
  `logo` varchar(255) DEFAULT '' COMMENT '网站LOGO',
  `sort_order` int(11) DEFAULT '0' COMMENT '排序号',
  `target` tinyint(1) DEFAULT '0' COMMENT '是否开启浏览器新窗口',
  `intro` text COMMENT '网站简况',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态(1=显示，0=屏蔽)',
  `add_time` int(11) DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ey_weapp_bshoucang`
--


--
-- Table structure for table `ey_weapp_collection`
--

CREATE TABLE `ey_weapp_collection` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `users_id` int(10) DEFAULT NULL,
  `title` varchar(50) DEFAULT '' COMMENT '网站标题',
  `url` varchar(100) DEFAULT '' COMMENT '网站地址',
  `lang` varchar(50) DEFAULT '' COMMENT '语言标识',
  `add_time` int(11) DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ey_weapp_collection`
--

INSERT INTO `ey_weapp_collection` VALUES (2,2,'袋式除尘器处理风量是怎么计算','29','cn',1609829251,1609829251);

--
-- Table structure for table `ey_weapp_comment`
--

CREATE TABLE `ey_weapp_comment` (
  `comment_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文档ID',
  `is_bestanswer` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否最佳答案，0否，1是',
  `is_review` tinyint(1) NOT NULL DEFAULT '1' COMMENT '问题是否审核，1是，0否',
  `users_id` int(10) NOT NULL DEFAULT '0' COMMENT '评论用户ID',
  `username` varchar(50) NOT NULL DEFAULT '' COMMENT '评论用户名',
  `click_like` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '点赞量',
  `users_ip` varchar(30) NOT NULL DEFAULT '' COMMENT '用户IP地址',
  `content` text NOT NULL COMMENT '内容',
  `pid` int(10) NOT NULL DEFAULT '0' COMMENT '子评论的父评论',
  `at_users_id` int(10) NOT NULL DEFAULT '0' COMMENT '被@的用户ID',
  `at_comment_id` int(10) NOT NULL DEFAULT '0' COMMENT '@答案ID',
  `add_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '新增时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`comment_id`),
  KEY `aid` (`aid`),
  KEY `users_id` (`users_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='文档评论回复表';

--
-- Dumping data for table `ey_weapp_comment`
--

INSERT INTO `ey_weapp_comment` VALUES (1,439,0,1,1,'admin',1,'127.0.0.1','&lt;p&gt;&lt;span style=&quot;font-family: &amp;quot;Microsoft YaHei&amp;quot;, Arial, Helvetica, sans-serif; font-size: 15px; background-color: rgb(255, 255, 255);&quot;&gt;网站经过优化稳定后，在网站可用数据稳定上升的前提下，可以考虑增加交换更多的高权重友情链接。此时，友情链接的交换不能是单一的关键词链接，而是可以扩展网站的权限，追求多词多页权重的平均增加，从而帮助更多的收录和原创内容再次被收录到页面的内容排名中。&lt;/span&gt;&lt;/p&gt;',0,0,0,1627893894,1628058396);

--
-- Table structure for table `ey_weapp_comment_level`
--

CREATE TABLE `ey_weapp_comment_level` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `users_level_id` int(10) NOT NULL DEFAULT '0' COMMENT '会员级别ID',
  `is_comment` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否允许评论文档',
  `is_review` tinyint(1) NOT NULL DEFAULT '0' COMMENT '评论是否需要审核',
  `add_time` int(10) NOT NULL DEFAULT '0' COMMENT '新增时间',
  `update_time` int(10) NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='评论级别表';

--
-- Dumping data for table `ey_weapp_comment_level`
--

INSERT INTO `ey_weapp_comment_level` VALUES (1,0,0,1,1572418214,1572418214),(2,1,1,0,1626925386,0),(3,2,1,0,1626925386,0),(4,3,1,0,1626925386,0);

--
-- Table structure for table `ey_weapp_comment_like`
--

CREATE TABLE `ey_weapp_comment_like` (
  `like_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文档ID',
  `comment_id` int(10) NOT NULL DEFAULT '0' COMMENT '评论ID',
  `users_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '点赞用户ID',
  `click_like` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '点赞',
  `users_ip` varchar(20) NOT NULL DEFAULT '' COMMENT '用户IP地址',
  `add_time` int(10) unsigned NOT NULL DEFAULT '0',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`like_id`),
  KEY `aid` (`aid`,`comment_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='文档评论点赞表';

--
-- Dumping data for table `ey_weapp_comment_like`
--

INSERT INTO `ey_weapp_comment_like` VALUES (1,439,1,1,1,'127.0.0.1',1628058396,1628058396);

--
-- Table structure for table `ey_weapp_demo`
--

CREATE TABLE `ey_weapp_demo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `typeid` tinyint(1) DEFAULT '1' COMMENT '类型：1=文字链接，2=图片链接',
  `title` varchar(50) DEFAULT '' COMMENT '网站标题',
  `url` varchar(100) DEFAULT '' COMMENT '网站地址',
  `logo` varchar(255) DEFAULT '' COMMENT '网站LOGO',
  `sort_order` int(11) DEFAULT '0' COMMENT '排序号',
  `target` tinyint(1) DEFAULT '0' COMMENT '是否开启浏览器新窗口',
  `email` varchar(50) DEFAULT NULL,
  `intro` text COMMENT '网站简况',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态(1=显示，0=屏蔽)',
  `delete_time` int(11) DEFAULT '0' COMMENT '软删除时间',
  `add_time` int(11) DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ey_weapp_demo`
--

INSERT INTO `ey_weapp_demo` VALUES (2,1,'易优CMS','http://www.eyoucms.com','',100,1,'','',1,0,1524975826,0),(3,2,'织梦58','http://www.dede58.com','http://www.eyoucms.dev/public/upload/system/2018/04/29/814ece093a0ba636209255dc20bd6e62.png',100,0,'','',1,0,1524976095,1524976135),(4,1,'ThinkPHP官网','http://www.thinkphp.cn','',100,1,'','',1,0,1525266497,1525266608),(5,1,'微信小程序开发教程','http://www.yiyongtong.com','',100,1,'','',1,0,1525748425,0);

--
-- Table structure for table `ey_weapp_linkkeyword`
--

CREATE TABLE `ey_weapp_linkkeyword` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT '关键词',
  `url` varchar(200) NOT NULL DEFAULT '' COMMENT '链接地址',
  `target` tinyint(1) NOT NULL DEFAULT '0' COMMENT '新窗口',
  `sort_order` int(10) NOT NULL DEFAULT '0' COMMENT '排序号',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态(1=启用，0=禁用)',
  `add_time` int(11) NOT NULL DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ey_weapp_linkkeyword`
--


--
-- Table structure for table `ey_weapp_messages`
--

CREATE TABLE `ey_weapp_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) DEFAULT '' COMMENT '通知标题',
  `users_id` text COMMENT '通知用户账号',
  `remark` text COMMENT '通知信息',
  `add_time` int(11) DEFAULT '0' COMMENT '新增时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ey_weapp_messages`
--


--
-- Table structure for table `ey_weapp_messages_read`
--

CREATE TABLE `ey_weapp_messages_read` (
  `messages_id` int(11) NOT NULL AUTO_INCREMENT,
  `users_id` varchar(50) DEFAULT NULL COMMENT '用户账号',
  `id` int(10) DEFAULT NULL COMMENT '站内信id',
  `add_time` int(11) DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`messages_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ey_weapp_messages_read`
--


--
-- Table structure for table `ey_weapp_minicount`
--

CREATE TABLE `ey_weapp_minicount` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `day` int(10) DEFAULT '0' COMMENT '今天流量',
  `total` int(10) DEFAULT '0' COMMENT '总流量',
  `dayline` int(10) DEFAULT '0',
  `add_time` int(11) DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `users_id` (`dayline`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ey_weapp_minicount`
--

INSERT INTO `ey_weapp_minicount` VALUES (1,3,3,1,1524975826,1600738692);

--
-- Table structure for table `ey_weapp_minicount_log`
--

CREATE TABLE `ey_weapp_minicount_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip` varchar(20) DEFAULT '',
  `add_time` int(11) DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `ip` (`ip`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ey_weapp_minicount_log`
--

INSERT INTO `ey_weapp_minicount_log` VALUES (1,'127.0.0.1',1600738682,1600738692);

--
-- Table structure for table `ey_weapp_pushall`
--

CREATE TABLE `ey_weapp_pushall` (
  `aid` int(100) NOT NULL COMMENT '文章ID',
  `baidupushzt` int(1) NOT NULL DEFAULT '0' COMMENT '百度推送状态',
  `shenmapushzt` int(1) NOT NULL DEFAULT '0' COMMENT '神马推送状态',
  `sogoupushzt` int(1) NOT NULL DEFAULT '0' COMMENT '搜狗推送状态',
  `toutiaopushzt` int(1) NOT NULL DEFAULT '0' COMMENT '头条推送状态',
  PRIMARY KEY (`aid`),
  UNIQUE KEY `aid` (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ey_weapp_pushall`
--


--
-- Table structure for table `ey_weapp_pushalltag`
--

CREATE TABLE `ey_weapp_pushalltag` (
  `aid` int(100) NOT NULL COMMENT '文章ID',
  `baidupushzt` int(1) NOT NULL DEFAULT '0' COMMENT '百度推送状态',
  `shenmapushzt` int(1) NOT NULL DEFAULT '0' COMMENT '神马推送状态',
  `sogoupushzt` int(1) NOT NULL DEFAULT '0' COMMENT '搜狗推送状态',
  `toutiaopushzt` int(1) NOT NULL DEFAULT '0' COMMENT '头条推送状态',
  PRIMARY KEY (`aid`),
  UNIQUE KEY `aid` (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ey_weapp_pushalltag`
--


--
-- Table structure for table `ey_weapp_sitecollect`
--

CREATE TABLE `ey_weapp_sitecollect` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) DEFAULT '' COMMENT '任务名称',
  `typeid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '采集栏目',
  `add_time` int(11) DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  `is_desc` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否倒序采集',
  `is_status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '入库状态(1=显示，0=屏蔽(草稿))',
  `is_litpic` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否获取第一张图片为封面',
  `is_filt_repet` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否过滤重复标题',
  `is_local` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '图片是否本地保存',
  `filt_iframe` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否过滤Iframe',
  `filt_js` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `filt_a` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `filt_style` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `filt_object` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `filt_note` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `filt_table` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `filt_img` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `filt_embed` tinyint(1) NOT NULL DEFAULT '0',
  `filt_param` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `filt_div_b` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `filt_div_e` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `get_style` tinyint(1) unsigned NOT NULL DEFAULT '2' COMMENT '获取方式，1：手工输入，2：批量生成',
  `url_rule` varchar(255) NOT NULL DEFAULT '' COMMENT '网址规则',
  `min_id` int(6) unsigned NOT NULL DEFAULT '1' COMMENT '最小值页码',
  `max_id` int(6) unsigned NOT NULL DEFAULT '0' COMMENT '最大值页码',
  `list_rule` varchar(255) NOT NULL DEFAULT '' COMMENT '列表规则',
  `a_rule` varchar(255) NOT NULL DEFAULT '' COMMENT '页面链接规则',
  `a_involve` varchar(100) NOT NULL DEFAULT '' COMMENT '必须包含',
  `a_exclusive` varchar(100) NOT NULL DEFAULT '' COMMENT '不能包含',
  `is_list_litpic` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '获取列表缩略图',
  `litpic_rule` varchar(255) NOT NULL DEFAULT '' COMMENT '列表缩略图规则',
  `is_page` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否文章分页',
  `page_a_rule` varchar(255) NOT NULL DEFAULT '' COMMENT '页面正则代码',
  `page_list_rule` varchar(255) NOT NULL DEFAULT '' COMMENT '分页正则代码',
  `sort_order` int(6) unsigned NOT NULL DEFAULT '100',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态，1：启用，0：锁定',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='文章采集任务列表';

--
-- Dumping data for table `ey_weapp_sitecollect`
--

INSERT INTO `ey_weapp_sitecollect` VALUES (1,'示例任务(示例网址：http://www.zzfrjt.com/nba/index_2.html)',10,1589179925,1589179925,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,2,'http://www.zzfrjt.com/nba/index_{{id}}.html',2,3,'&lt;ul id=\'listNewsTimeLy\' class=&quot;listNewsTimeLy&quot;&gt;[内容]&lt;div class=&quot;pagnation&quot; id=&quot;pagnation&quot; style=&quot;padding-bottom:30px;&quot;&gt;','&lt;a class=&quot;J-share-a&quot; href=&quot;[内容]&quot; target=&quot;_blank&quot;&gt;','','',1,'&lt;img class=&quot;animation&quot; src=&quot;[内容]&quot;',0,'','',100,1),(2,'电脑站模板采集',13,1589179954,1589338310,1,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,'',1,0,'&lt;ul class=&quot;blocks-2 blocks-lg-3 met-pager-ajax met-grid&quot;&gt;\r\n[内容]\r\n        &lt;/ul&gt;\r\n      &lt;/div&gt;\r\n    &lt;/div&gt;\r\n  &lt;/div&gt;\r\n&lt;/div&gt;\r\n','&lt;figure class=&quot;widget-header cover&quot;&gt; &lt;a href=&quot;[内容]&quot;','','',1,'&lt;img class=&quot;cover-image&quot; data-original=&quot;[内容]&quot;',0,'','',100,1),(4,'新闻采集',24,1589330098,1589330918,1,1,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,'https://www.shwlz.com/jzzx.html?pagesize=10&amp;p=3',1,0,'&lt;ul class=&quot;textlist&quot;&gt;[内容]&lt;/ul&gt;','','','',0,'',0,'','',100,1);

--
-- Table structure for table `ey_weapp_sitecollet_record`
--

CREATE TABLE `ey_weapp_sitecollet_record` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `collectid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '采集列表id',
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT '标题',
  `url_list` text NOT NULL COMMENT '执行url集合（json格式）',
  `add_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `collectid` (`collectid`)
) ENGINE=MyISAM AUTO_INCREMENT=46 DEFAULT CHARSET=utf8 COMMENT='文章采集记录列表';

--
-- Dumping data for table `ey_weapp_sitecollet_record`
--

INSERT INTO `ey_weapp_sitecollet_record` VALUES (37,2,'电脑站模板采集','[\"https:\\/\\/www.eyoucms.com\\/moban\\/\"]',1589186342,1589186342),(38,3,'案例采集','[\"https:\\/\\/www.eyoucms.com\\/anli\\/list_4_15.html\",\"https:\\/\\/www.eyoucms.com\\/anli\\/list_4_14.html\"]',1589188627,1589188627),(39,2,'电脑站模板采集','[\"https:\\/\\/www.eyoucms.com\\/moban\\/list_3_2.html\"]',1589251086,1589251086),(40,4,'新闻采集','[\"https:\\/\\/www.shwlz.com\\/jzzx.html?pagesize=10&amp;p=3\"]',1589330331,1589330331),(41,4,'新闻采集','[\"https:\\/\\/www.shwlz.com\\/seo.html?pagesize=10&amp;p=1\"]',1589330512,1589330512),(42,4,'新闻采集','[\"https:\\/\\/www.shwlz.com\\/wxyx.html\"]',1589330764,1589330764),(43,4,'新闻采集','[\"https:\\/\\/www.shwlz.com\\/xwdt.html\"]',1589330842,1589330842),(44,4,'新闻采集','[\"https:\\/\\/www.shwlz.com\\/faq.html?pagesize=20&amp;p=1\"]',1589330945,1589330945),(45,2,'电脑站模板采集','[\"https:\\/\\/www.eyoucms.com\\/moban\\/list_3_21.html\"]',1589338349,1589338349);

--
-- Table structure for table `ey_weapp_sitecollet_rule`
--

CREATE TABLE `ey_weapp_sitecollet_rule` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `collectid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '采集列表id',
  `name` varchar(50) NOT NULL DEFAULT '' COMMENT '字段名称',
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT '字段别名（中文）',
  `rule` varchar(255) NOT NULL DEFAULT '' COMMENT '采集规则',
  `origin` varchar(255) NOT NULL DEFAULT '' COMMENT '初始字符串',
  `replace` varchar(255) NOT NULL DEFAULT '' COMMENT '替换字符串',
  `default` varchar(255) NOT NULL DEFAULT '' COMMENT '默认值（不采集）',
  `is_page` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否应用于分页',
  `add_time` int(11) unsigned DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) unsigned DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `collectid` (`collectid`)
) ENGINE=MyISAM AUTO_INCREMENT=359 DEFAULT CHARSET=utf8 COMMENT='文章采集规则列表';

--
-- Dumping data for table `ey_weapp_sitecollet_rule`
--

INSERT INTO `ey_weapp_sitecollet_rule` VALUES (37,1,'seo_description','SEO描述','','','','',0,1589179925,1589179925),(38,1,'seo_keywords','SEO关键词','','','','',0,1589179925,1589179925),(39,1,'seo_title','SEO标题','','','','',0,1589179925,1589179925),(40,1,'litpic','缩略图','','','','',0,1589179925,1589179925),(41,1,'title','标题','&lt;h1&gt;&lt;span&gt;[内容]&lt;/span&gt;&lt;/h1&gt;','','','',0,1589179925,1589179925),(42,1,'content','内容详情','&lt;div class=&quot;J-contain_detail_cnt contain_detail_cnt&quot;&gt;[内容]&lt;p&gt;上一篇','','','',1,1589179925,1589179925),(43,1,'add_time','新增时间','','','','',0,1589179925,1589179925),(44,1,'duoxuan','多选项测试','','','','',0,1589179925,1589179925),(45,1,'xialakuang','下拉框测试','','','','',0,1589179925,1589179925),(46,1,'danxuan','但选项测试','','','','',0,1589179925,1589179925),(358,2,'users_price','价格','','','','',0,1589338310,1589338310),(356,2,'diy_mbbh','模板编号','&lt;dd&gt;模板编号：[内容]&lt;/dd&gt;','','','',0,1589338310,1589338310),(357,2,'diy_webewm','网站二维码','','','','',0,1589338310,1589338310),(355,2,'diy_pcys','电脑站演示地址','&lt;a id=&quot;collect-btn&quot; class=&quot;collect-btn nonofavV3&quot; href=&quot;[内容]&quot; target=&quot;_blank&quot;  rel=&quot;nofollow&quot;&gt;模板演示&lt;/a&gt;\r\n','/plus/','https://www.eyoucms.com/plus/','',0,1589338310,1589338310),(354,2,'diy_mbys','手机站演示地址','&lt;a id=&quot;collect-btn&quot; class=&quot;collect-btn nonofavV3&quot; href=&quot;[内容]&quot; target=&quot;_blank&quot;  rel=&quot;nofollow&quot;&gt;模板演示&lt;/a&gt;\r\n','/plus/','https://www.eyoucms.com/plus/','',0,1589338310,1589338310),(349,2,'seo_keywords','SEO关键词','','','','',0,1589338310,1589338310),(352,2,'yanse','颜色','&lt;dd&gt;模板颜色：[内容]&lt;/dd&gt;','','','',0,1589338310,1589338310),(353,2,'sshy','所属行业','class=&quot;cjzy&quot;&gt;[内容]&lt;/a&gt;','','','',0,1589338310,1589338310),(347,2,'litpic','缩略图','','','','',0,1589338310,1589338310),(348,2,'seo_title','SEO标题','','','','',0,1589338310,1589338310),(302,4,'alwz','案例网址','','','','',0,1589330918,1589330918),(299,4,'seo_keywords','SEO关键词','','东莞建站公司,企业网站建设,公司网站定制,企业网站优化,网络','企业网站建设','',0,1589330918,1589330918),(300,4,'seo_description','SEO描述','','','','',0,1589330918,1589330918),(301,4,'add_time','新增时间','','','','',0,1589330918,1589330918),(297,4,'litpic','缩略图','','','','',0,1589330918,1589330918),(298,4,'seo_title','SEO标题','','','','',0,1589330918,1589330918),(296,4,'content','内容详情','&lt;div class=&quot;InfoContent&quot;&gt;[内容]&lt;div class=&quot;Tag&quot;&gt;','','','',1,1589330918,1589330918),(295,4,'title','标题','&lt;div class=&quot;InfoTitle&quot;&gt;&lt;h1&gt;[内容]&lt;/h1&gt;&lt;/div&gt;\r\n','东莞','','',0,1589330918,1589330918),(351,2,'add_time','新增时间','','','','',0,1589338310,1589338310),(350,2,'seo_description','SEO描述','','','','',0,1589338310,1589338310),(346,2,'content','内容详情','&lt;div class=&quot;clearfix&quot;&gt;[内容]&lt;/div&gt;\r\n','','','',1,1589338310,1589338310),(345,2,'title','标题','&lt;h1&gt;\r\n            [内容]\r\n            &lt;/h1&gt;','','','',0,1589338310,1589338310);

--
-- Table structure for table `ey_weapp_sitecollet_urllist`
--

CREATE TABLE `ey_weapp_sitecollet_urllist` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `collectid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '采集列表id',
  `url` varchar(512) NOT NULL DEFAULT '' COMMENT '文章url',
  `add_time` int(11) unsigned DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) unsigned DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `collectid` (`collectid`)
) ENGINE=MyISAM AUTO_INCREMENT=63 DEFAULT CHARSET=utf8 COMMENT='文章采集链接列表';

--
-- Dumping data for table `ey_weapp_sitecollet_urllist`
--

INSERT INTO `ey_weapp_sitecollet_urllist` VALUES (37,1,'http://www.zzfrjt.com/nba/index_3.html',1589179925,1589179925),(38,1,'http://www.zzfrjt.com/nba/index_2.html',1589179925,1589179925),(62,2,'https://www.eyoucms.com/moban/list_3_21.html',1589338258,1589338258),(61,4,'https://www.shwlz.com/faq.html?pagesize=20&amp;p=1',1589330889,1589330889);

--
-- Table structure for table `ey_wx_users`
--

CREATE TABLE `ey_wx_users` (
  `wxuser_id` int(11) NOT NULL AUTO_INCREMENT,
  `users_id` int(11) NOT NULL DEFAULT '0' COMMENT '用户id',
  `openid` varchar(100) NOT NULL DEFAULT '' COMMENT 'openid',
  `nickname` varchar(100) NOT NULL DEFAULT '' COMMENT '微信昵称',
  `headimgurl` varchar(200) NOT NULL DEFAULT '' COMMENT '头像',
  `add_time` int(11) NOT NULL DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`wxuser_id`),
  KEY `openid` (`openid`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='微信小程序用户表';

--
-- Dumping data for table `ey_wx_users`
--


--
-- Table structure for table `ey_ygmx_content`
--

CREATE TABLE `ey_ygmx_content` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `aid` int(10) DEFAULT '0' COMMENT '文档ID',
  `add_time` int(11) DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  `zc` varchar(200) NOT NULL DEFAULT '' COMMENT '职称',
  PRIMARY KEY (`id`),
  KEY `aid` (`aid`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='附加表';

--
-- Dumping data for table `ey_ygmx_content`
--

INSERT INTO `ey_ygmx_content` VALUES (1,12,1621334700,1621334700,'三级技术研发人员'),(2,13,1621334729,1621334729,'一级技术研发人员'),(3,14,1621334745,1621334745,'一级技术研发人员'),(4,15,1621334766,1621334766,'二级技术研发人员');

--
-- Table structure for table `ey_zaopin_content`
--

CREATE TABLE `ey_zaopin_content` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `aid` int(10) DEFAULT '0' COMMENT '文档ID',
  `add_time` int(11) DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  `yaoqiu` varchar(200) NOT NULL DEFAULT '' COMMENT '要求',
  `gznr` longtext COMMENT '工作内容',
  `gongxin` varchar(200) NOT NULL DEFAULT '' COMMENT '工薪',
  PRIMARY KEY (`id`),
  KEY `aid` (`aid`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='附加表';

--
-- Dumping data for table `ey_zaopin_content`
--

INSERT INTO `ey_zaopin_content` VALUES (1,38,1621473850,1621473850,'经验3-4年 / 大专','&lt;p&gt;岗位职责：&lt;/p&gt;&lt;p&gt;1、挖掘当地预付货市场，搜集当地市场信息；&lt;/p&gt;&lt;p&gt;2、开发并维护货代同行，做好业务的报价、揽取和跟踪；&lt;/p&gt;&lt;p&gt;3、根据公司战略和销售目标完成销售任务；&lt;/p&gt;&lt;p&gt;4、协助财务把与客户达成的各项交易款项收回公司，做好工作流程的预防与控制工作。&lt;/p&gt;&lt;p&gt;任职要求：&lt;/p&gt;&lt;p&gt;1、大专及以上学历；&lt;/p&gt;&lt;p&gt;2、有美加线且三年以上开发经验，有一定的客户资源和人脉者优先；&lt;/p&gt;&lt;p&gt;3、沟通能力强，吃苦耐劳有韧性；&lt;/p&gt;&lt;p&gt;4、优秀的执行力及自律性。&lt;/p&gt;&lt;p&gt;&lt;br/&gt;&lt;/p&gt;','4.5-6K'),(2,39,1621473969,1621473969,'经验2年 / 大专','&lt;p&gt;岗位职责：&lt;/p&gt;&lt;p&gt;1. 根据公司发展规划及产品定位，从客户的需求角度出发，深度挖掘现有产品卖点，制作海报/ 文案/ 视频/ 动图等将优点充分展示，提升核心竞争力；&lt;/p&gt;&lt;p&gt;2. 撰写和优化不同销售渠道/平台的 产品内容介绍（主要文字性内容，软文，事件营销等等）, 吸引潜在客户的注意力;&lt;/p&gt;&lt;p&gt;3. 分析国内沿海主要口岸城市的FBA物流市场竞争特点，和产品差异化竞争策略，并按深圳统筹指示，为上海/宁波/青岛站点推广FBA物流服务制作营销材料；&lt;/p&gt;&lt;p&gt;4. 管理并按要求定期更新，维护公司官网、微信公众号等对外宣传平台；&lt;/p&gt;&lt;p&gt;5, 联系协调相关合作单位，协助策划和实施公司的线上品牌宣传工作（如各类促销引流），线下各类现场活动（如展会，沙龙论坛），总结评估活动效果并持续改进；&lt;/p&gt;&lt;p&gt;6. 定期关注了解竞争对手，市场趋势，需求转化收集；并及时提出有效的推广策略方案和测算成本，全面提升公司及产品之品牌知名度；&lt;/p&gt;&lt;p&gt;7. 完成领导交办的其它相关工作。&lt;/p&gt;&lt;p&gt;&lt;br/&gt;&lt;/p&gt;&lt;p&gt;任职要求：&lt;/p&gt;&lt;p&gt;1： 熟练使用Photoshop、Coreldraw、AI 等设计软件, 熟悉P图工具, 熟练使用MS日常办公软件（Word、Excel、PPT），&lt;/p&gt;&lt;p&gt;2：有较强的文字功底，能将文案创意与图片视频等工具结合起来，精准传达到位；&lt;/p&gt;&lt;p&gt;3： 熟悉口碑/生态圈营销、论坛营销等各类网络营销方法，具体较为敏锐的新闻热点捕捉能力；&lt;/p&gt;&lt;p&gt;4：专科及以上学历，美术/ 动画设计/ 计算机设计专业优先；次之市场营销、广告策划专业且有上述专业技能优先；&lt;/p&gt;&lt;p&gt;5：跨界学习能力强；有较强的沟通表达能力和协调能力；较强的抗压能力和时间管理能力；&lt;/p&gt;&lt;p&gt;&lt;br/&gt;&lt;/p&gt;','5-7k'),(3,40,1621474004,1621474004,'经验2年 / 大专','&lt;p&gt;岗位职责：&lt;/p&gt;&lt;p&gt;1、根据销售/客服提供的客户委托书联系安排客户出货事宜&lt;/p&gt;&lt;p&gt;2、根据船卡要求安排订舱&lt;/p&gt;&lt;p&gt;3、安排客户做箱报关计划并通知车队与报关行&lt;/p&gt;&lt;p&gt;4、文件制作:提单制作/AMS.ACI发送/ISF发送&lt;/p&gt;&lt;p&gt;5、费用账单制作及发送&lt;/p&gt;&lt;p&gt;6、确认付款后签发派送提单给客户&lt;/p&gt;&lt;p&gt;7、保持与客户/销售/商务各窗口的及时操作信息沟通&lt;/p&gt;&lt;p&gt;8、根据系统要求规范完成操作各项工作&lt;/p&gt;&lt;p&gt;9、及时与上级沟通操作中遇到的问题以便上级落实应对措施&lt;/p&gt;&lt;p&gt;10、完成上级交办的其他相关工作&lt;/p&gt;&lt;p&gt;&lt;br/&gt;&lt;/p&gt;&lt;p&gt;岗位要求：&lt;/p&gt;&lt;p&gt;1、专科以上学历，大学英语四级；&lt;/p&gt;&lt;p&gt;2、具有2年以上美加线或欧地线工作经验，熟悉各种形式的出口操作流程，包括指定货/自揽货，能独立完成操作、一票到底、能及时迅速的处理突发事件；&lt;/p&gt;&lt;p&gt;3、工作态度积极，品行端正，细心认真，条理清楚，责任心强，有一定抗压能力及较强的沟通协调能力，并具有有良好的客户维护意识，工作稳定性高，善于学习新的事物，愿与公司共同发展。&lt;/p&gt;&lt;p&gt;&lt;br/&gt;&lt;/p&gt;&lt;p microsoft=&quot;&quot; font-size:=&quot;&quot; white-space:=&quot;&quot; background-color:=&quot;&quot;&gt;&lt;br/&gt;&lt;/p&gt;','5-7K');

--
-- Table structure for table `ey_zpmx_content`
--

CREATE TABLE `ey_zpmx_content` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `aid` int(10) DEFAULT '0' COMMENT '文档ID',
  `add_time` int(11) DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  `zwms` longtext COMMENT '职位描述',
  `rzyq` longtext COMMENT '入职要求',
  PRIMARY KEY (`id`),
  KEY `aid` (`aid`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='附加表';

--
-- Dumping data for table `ey_zpmx_content`
--

INSERT INTO `ey_zpmx_content` VALUES (1,9,1621334422,1621334422,'&lt;p&gt;1.负责项目客户文案整理；&lt;/p&gt;&lt;p&gt;2.负责协调项目时间进度安排，编写项目时间表，并安排设计师开展设计工作；&lt;/p&gt;&lt;p&gt;3.负责与客户电话、邮件沟通协调项目时间，并组织设计师进行设计方案提案；&lt;/p&gt;&lt;p&gt;4.能正确理解客户需求，向设计师转达客户设计要求或方案修改意见；&lt;/p&gt;&lt;p&gt;&lt;br/&gt;&lt;/p&gt;','&lt;p&gt;1.专科以上学历，有过项目跟踪经验，能熟练梳理文字整理，邮件收发、电话预约沟通等一系列工作；&lt;/p&gt;&lt;p&gt;2.能熟练操作office办公软件，并懂得制作等后期环节；&lt;/p&gt;&lt;p&gt;3.能适应多任务处理的工作压力；&lt;/p&gt;&lt;p&gt;4.工作积极，理解能力强，能主动思考，具有良好的沟通能力及团队协作精神；&lt;/p&gt;&lt;p&gt;5.有设计公司1-2年项目跟踪工作经验优先考虑；&lt;/p&gt;&lt;p&gt;&lt;br/&gt;&lt;/p&gt;'),(2,10,1621334444,1621334444,'&lt;p&gt;1.负责项目客户文案整理；&lt;/p&gt;&lt;p&gt;2.负责协调项目时间进度安排，编写项目时间表，并安排设计师开展设计工作；&lt;/p&gt;&lt;p&gt;3.负责与客户电话、邮件沟通协调项目时间，并组织设计师进行设计方案提案；&lt;/p&gt;&lt;p&gt;4.能正确理解客户需求，向设计师转达客户设计要求或方案修改意见；&lt;/p&gt;&lt;p&gt;&lt;br/&gt;&lt;/p&gt;','&lt;p&gt;1.专科以上学历，有过项目跟踪经验，能熟练梳理文字整理，邮件收发、电话预约沟通等一系列工作；&lt;/p&gt;&lt;p&gt;2.能熟练操作office办公软件，并懂得制作等后期环节；&lt;/p&gt;&lt;p&gt;3.能适应多任务处理的工作压力；&lt;/p&gt;&lt;p&gt;4.工作积极，理解能力强，能主动思考，具有良好的沟通能力及团队协作精神；&lt;/p&gt;&lt;p&gt;5.有设计公司1-2年项目跟踪工作经验优先考虑；&lt;/p&gt;&lt;p&gt;&lt;br/&gt;&lt;/p&gt;'),(3,11,1621334461,1621334461,'&lt;p&gt;1.专科以上学历，有过项目跟踪经验，能熟练梳理文字整理，邮件收发、电话预约沟通等一系列工作；&lt;/p&gt;&lt;p&gt;2.能熟练操作office办公软件，并懂得制作等后期环节；&lt;/p&gt;&lt;p&gt;3.能适应多任务处理的工作压力；&lt;/p&gt;&lt;p&gt;4.工作积极，理解能力强，能主动思考，具有良好的沟通能力及团队协作精神；&lt;/p&gt;&lt;p&gt;5.有设计公司1-2年项目跟踪工作经验优先考虑；&lt;/p&gt;&lt;p&gt;&lt;br/&gt;&lt;/p&gt;','&lt;p&gt;1.负责项目客户文案整理；&lt;/p&gt;&lt;p&gt;2.负责协调项目时间进度安排，编写项目时间表，并安排设计师开展设计工作；&lt;/p&gt;&lt;p&gt;3.负责与客户电话、邮件沟通协调项目时间，并组织设计师进行设计方案提案；&lt;/p&gt;&lt;p&gt;4.能正确理解客户需求，向设计师转达客户设计要求或方案修改意见；&lt;/p&gt;&lt;p&gt;&lt;br/&gt;&lt;/p&gt;');

--
-- Table structure for table `ey_zt_content`
--

CREATE TABLE `ey_zt_content` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `aid` int(10) DEFAULT '0' COMMENT '文档ID',
  `add_time` int(11) DEFAULT '0' COMMENT '新增时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  `daodu` text COMMENT '导读',
  PRIMARY KEY (`id`),
  KEY `aid` (`aid`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='附加表';

--
-- Dumping data for table `ey_zt_content`
--

INSERT INTO `ey_zt_content` VALUES (1,122,1641347764,1641347764,'这里汇总了本站所有悬赏任务兼职平台，方便大家按需要下载或了解这些悬赏任务接单平台。'),(2,123,1641347764,1641347764,'苹果手机最新ios试玩平台赚钱软件汇总\r\n查看苹果手机最新ios试玩平台赚钱软件汇总详情'),(3,124,1641347764,1641347764,'本专题精选了应用试客、巨宝朋、体验达人、欢乐试玩等微信赚钱公众号平台。'),(4,125,1641347764,1641347764,'这里汇总下手机转发、分享和阅读赚钱的手机赚钱应用或微信公众号，包括转发分享文章赚钱和转发分享广告活动信息的微信公众号和赚钱应用。'),(5,126,1641347764,1641347764,'精选1元提现、实时到账的平台。'),(6,127,1641347764,1641347764,'精选新锐苹果应用试玩手赚平台'),(7,128,1641347764,1641347764,'苹果iOS系统赚钱软件精彩推荐'),(8,129,1641347764,1641347764,'精品手机看广告、看资讯和转发文章等赚钱APP汇总');

--
-- Dumping events for database 'linematch_bjqizh'
--

--
-- Dumping routines for database 'linematch_bjqizh'
--


