#
# bakfile
# Time: 2020-11-04 10:07:29
# --------------------------------------------------------


DROP TABLE IF EXISTS web_admin;
CREATE TABLE web_admin (
  admin_username varchar(50) NOT NULL,
  admin_password varchar(50) NOT NULL,
  admin_logincount int(11) DEFAULT '0',
  admin_ip varchar(50) DEFAULT '',
  admin_lastlogintime int(11) DEFAULT '0',
  admin_addtime int(11) DEFAULT '0',
  PRIMARY KEY (admin_username) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

DROP TABLE IF EXISTS web_attachment;
CREATE TABLE web_attachment (
  atta_id int(11) NOT NULL AUTO_INCREMENT,
  atta_systype int(11) DEFAULT '0',
  atta_type int(11) DEFAULT '0',
  atta_oldname varchar(50) DEFAULT '',
  atta_newname varchar(50) DEFAULT '',
  atta_infoid int(11) DEFAULT '0',
  atta_ip varchar(50) DEFAULT '',
  atta_addtime int(11) DEFAULT '0',
  PRIMARY KEY (atta_id) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

DROP TABLE IF EXISTS web_cat;
CREATE TABLE web_cat (
  cat_id int(11) NOT NULL AUTO_INCREMENT,
  cat_pid int(11) unsigned NOT NULL DEFAULT '0' COMMENT '上级id',
  cat_channelid int(11) DEFAULT '0',
  cat_chain varchar(255) DEFAULT '',
  cat_name varchar(100) NOT NULL,
  cat_ord int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (cat_id) USING BTREE,
  KEY cat_channelid (cat_channelid) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

DROP TABLE IF EXISTS web_catdata;
CREATE TABLE web_catdata (
  catdata_id int(11) NOT NULL AUTO_INCREMENT,
  cat_pid int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'web_cat表pid',
  cat_id int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'web_cat表id',
  cat_chain varchar(255) DEFAULT '',
  catdata_channelid int(11) NOT NULL DEFAULT '0',
  catdata_name varchar(100) NOT NULL,
  catdata_lang varchar(10) DEFAULT '',
  catdata_ord int(11) NOT NULL DEFAULT '0',
  catdata_ispass tinyint(4) DEFAULT '0',
  catdata_password varchar(50) DEFAULT '',
  catdata_isshow tinyint(4) DEFAULT '0',
  catdata_row int(11) NOT NULL DEFAULT '10',
  catdata_col int(11) NOT NULL DEFAULT '1',
  catdata_smallimgw int(11) NOT NULL DEFAULT '100',
  catdata_smallimgh int(11) NOT NULL DEFAULT '100',
  catdata_bigimgw int(11) NOT NULL DEFAULT '100',
  catdata_bigimgh int(11) NOT NULL DEFAULT '100',
  catdata_isturn tinyint(4) DEFAULT '0',
  catdata_turnurl varchar(300) DEFAULT '',
  catdata_seotitle text,
  catdata_seokeyword text,
  catdata_seodes text,
  catdata_img varchar(50) DEFAULT '',
  catdata_des text,
  PRIMARY KEY (catdata_id) USING BTREE,
  KEY catdata_channelid (catdata_channelid) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

DROP TABLE IF EXISTS web_channel;
CREATE TABLE web_channel (
  channel_id int(11) NOT NULL AUTO_INCREMENT,
  channel_moduleid int(11) DEFAULT '0',
  channel_modulename varchar(30) DEFAULT '',
  channel_modulefolder varchar(30) DEFAULT '',
  channel_name varchar(50) DEFAULT '',
  channel_ord int(11) NOT NULL,
  PRIMARY KEY (channel_id) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

DROP TABLE IF EXISTS web_channeldata;
CREATE TABLE web_channeldata (
  channeldata_id int(11) NOT NULL AUTO_INCREMENT,
  channeldata_channelid int(11) DEFAULT '0',
  channeldata_moduleid int(11) DEFAULT '0',
  channeldata_modulename varchar(30) DEFAULT '',
  channeldata_modulefolder varchar(30) DEFAULT '',
  channeldata_lang varchar(10) NOT NULL,
  channeldata_name varchar(50) DEFAULT '',
  channeldata_ord int(11) NOT NULL,
  channeldata_directory varchar(30) DEFAULT '',
  channeldata_istop tinyint(4) DEFAULT '0',
  channeldata_isbottom tinyint(4) DEFAULT '0',
  channeldata_isturn tinyint(4) DEFAULT '0',
  channeldata_url varchar(100) DEFAULT '',
  channeldata_seotitle text,
  channeldata_seokeyword text,
  channeldata_seodes text,
  channeldata_seocatedestempl text,
  channeldata_seoinfodestempl text,
  channeldata_row int(11) DEFAULT '0',
  channeldata_col int(11) DEFAULT '0',
  channeldata_smallimgw int(11) DEFAULT '0',
  channeldata_smallimgh int(11) DEFAULT '0',
  channeldata_bigimgw int(11) DEFAULT '0',
  channeldata_bigimgh int(11) DEFAULT '0',
  channeldata_isorder tinyint(4) DEFAULT '0',
  channeldata_ordersize int(11) DEFAULT '0',
  channeldata_commentpagesize int(11) DEFAULT '0',
  channeldata_iscomment tinyint(4) DEFAULT '0',
  channeldata_isdirect tinyint(4) DEFAULT '0',
  channeldata_messagelevel int(11) DEFAULT '0',
  channeldata_afname1 varchar(30) DEFAULT '',
  channeldata_afisshow1 tinyint(4) DEFAULT '0',
  channeldata_afisnotnull1 tinyint(4) DEFAULT '0',
  channeldata_afname2 varchar(30) DEFAULT '',
  channeldata_afisshow2 tinyint(4) DEFAULT '0',
  channeldata_afisnotnull2 tinyint(4) DEFAULT '0',
  channeldata_afname3 varchar(30) DEFAULT '',
  channeldata_afisshow3 tinyint(4) DEFAULT '0',
  channeldata_afisnotnull3 tinyint(4) DEFAULT '0',
  channeldata_afname4 varchar(30) DEFAULT '',
  channeldata_afisshow4 tinyint(4) DEFAULT '0',
  channeldata_afisnotnull4 tinyint(4) DEFAULT '0',
  channeldata_afname5 varchar(30) DEFAULT '',
  channeldata_afisshow5 tinyint(4) DEFAULT '0',
  channeldata_afisnotnull5 tinyint(4) DEFAULT '0',
  channeldata_afname6 varchar(30) DEFAULT '',
  channeldata_afisshow6 tinyint(4) DEFAULT '0',
  channeldata_afisnotnull6 tinyint(4) DEFAULT '0',
  channeldata_afname7 varchar(30) DEFAULT '',
  channeldata_afisshow7 tinyint(4) DEFAULT '0',
  channeldata_afisnotnull7 tinyint(4) DEFAULT '0',
  channeldata_afname8 varchar(30) DEFAULT '',
  channeldata_afisshow8 tinyint(4) DEFAULT '0',
  channeldata_afisnotnull8 tinyint(4) DEFAULT '0',
  channeldata_afname9 varchar(30) DEFAULT '',
  channeldata_afisshow9 tinyint(4) DEFAULT '0',
  channeldata_afisnotnull9 tinyint(4) DEFAULT '0',
  channeldata_afname10 varchar(30) DEFAULT '',
  channeldata_afisshow10 tinyint(4) DEFAULT '0',
  channeldata_afisnotnull10 tinyint(4) DEFAULT '0',
  PRIMARY KEY (channeldata_id) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

DROP TABLE IF EXISTS web_comment;
CREATE TABLE web_comment (
  comment_id int(11) NOT NULL AUTO_INCREMENT,
  comment_channelid int(11) DEFAULT '0',
  comment_infoid int(11) DEFAULT '0',
  comment_infodataid int(11) DEFAULT '0',
  comment_lang varchar(10) DEFAULT '',
  comment_name varchar(100) DEFAULT '',
  comment_content text,
  comment_ip varchar(50) DEFAULT '',
  comment_ispublish tinyint(4) DEFAULT '0',
  comment_addtime int(11) DEFAULT '0',
  PRIMARY KEY (comment_id) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

DROP TABLE IF EXISTS web_db;
CREATE TABLE web_db (
  db_id int(11) NOT NULL AUTO_INCREMENT,
  db_pre varchar(50) DEFAULT '',
  db_count int(11) DEFAULT '1',
  db_time int(11) DEFAULT '0',
  PRIMARY KEY (db_id) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

DROP TABLE IF EXISTS web_info;
CREATE TABLE web_info (
  info_id int(11) NOT NULL AUTO_INCREMENT,
  info_channelid int(11) DEFAULT '0',
  info_catid int(11) DEFAULT '0',
  info_ord int(11) NOT NULL,
  info_title varchar(200) DEFAULT '',
  info_addtime int(11) DEFAULT '0',
  PRIMARY KEY (info_ord) USING BTREE,
  UNIQUE KEY info_id (info_id) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

DROP TABLE IF EXISTS web_infodata;
CREATE TABLE web_infodata (
  infodata_id int(11) NOT NULL AUTO_INCREMENT,
  infodata_channelid int(11) DEFAULT '0',
  infodata_catid int(11) DEFAULT '0',
  infodata_infoid int(11) DEFAULT '0',
  infodata_lang varchar(10) NOT NULL,
  infodata_issingle tinyint(4) DEFAULT '0',
  infodata_isshow tinyint(4) DEFAULT '0',
  infodata_istop tinyint(4) DEFAULT '0',
  infodata_ishot tinyint(4) DEFAULT '0',
  infodata_isrec tinyint(4) DEFAULT '0',
  infodata_isrec2 tinyint(4) DEFAULT '0',
  infodata_isrec3 tinyint(4) DEFAULT '0',
  infodata_isrec4 tinyint(4) DEFAULT '0',
  infodata_isrec5 tinyint(4) DEFAULT '0',
  infodata_iscomment tinyint(4) DEFAULT '0',
  infodata_title varchar(200) DEFAULT '',
  infodata_ord int(11) NOT NULL,
  infodata_price int(11) DEFAULT '0',
  infodata_images text,
  infodata_seotitle text,
  infodata_seokeyword text,
  infodata_seodes text,
  infodata_nlkeyword varchar(50) DEFAULT '',
  infodata_nlkeyword2 varchar(50) DEFAULT '',
  infodata_nlkeyword3 varchar(50) DEFAULT '',
  infodata_summary text,
  infodata_content longtext,
  infodata_mcontent longtext,
  infodata_pagecount int(11) DEFAULT '0',
  infodata_filesname text,
  infodata_filesvalue text,
  infodata_name1 varchar(255) DEFAULT '',
  infodata_name2 varchar(255) DEFAULT '',
  infodata_name3 varchar(255) DEFAULT '',
  infodata_name4 varchar(255) DEFAULT '',
  infodata_name5 varchar(255) DEFAULT '',
  infodata_name6 varchar(255) DEFAULT '',
  infodata_name7 varchar(255) DEFAULT '',
  infodata_name8 varchar(255) DEFAULT '',
  infodata_name9 varchar(255) DEFAULT '',
  infodata_name10 varchar(255) DEFAULT '',
  infodata_views int(11) DEFAULT '0',
  infodata_addtime int(11) DEFAULT '0',
  PRIMARY KEY (infodata_ord,infodata_lang) USING BTREE,
  UNIQUE KEY infodata_id (infodata_id) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

DROP TABLE IF EXISTS web_job_info;
CREATE TABLE web_job_info (
  info_id int(11) NOT NULL AUTO_INCREMENT,
  info_channelid int(11) DEFAULT '0',
  info_catid int(11) DEFAULT '0',
  info_ord int(11) NOT NULL,
  info_title varchar(200) DEFAULT '',
  info_addtime int(11) DEFAULT '0',
  PRIMARY KEY (info_ord) USING BTREE,
  UNIQUE KEY info_id (info_id) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

DROP TABLE IF EXISTS web_job_infodata;
CREATE TABLE web_job_infodata (
  infodata_id int(11) NOT NULL AUTO_INCREMENT,
  infodata_channelid int(11) DEFAULT '0',
  infodata_catid int(11) DEFAULT '0',
  infodata_infoid int(11) DEFAULT '0',
  infodata_lang varchar(10) NOT NULL,
  infodata_isshow tinyint(4) DEFAULT '0',
  infodata_isrec tinyint(4) DEFAULT '0',
  infodata_ishot tinyint(4) DEFAULT '0',
  infodata_istop tinyint(4) DEFAULT '0',
  infodata_title varchar(100) DEFAULT '',
  infodata_ord int(11) NOT NULL,
  infodata_seokeyword text,
  infodata_seodes text,
  infodata_summary text,
  infodata_depname varchar(50) DEFAULT '',
  infodata_number varchar(50) DEFAULT '',
  infodata_workaddress varchar(100) DEFAULT '',
  infodata_salary varchar(50) DEFAULT '',
  infodata_eduname varchar(50) DEFAULT '',
  infodata_specialty varchar(100) DEFAULT '',
  infodata_sex varchar(50) DEFAULT '',
  infodata_age varchar(50) DEFAULT '',
  infodata_content text,
  infodata_pagecount int(11) DEFAULT '0',
  infodata_name1 varchar(100) DEFAULT '',
  infodata_name2 varchar(100) DEFAULT '',
  infodata_name3 varchar(100) DEFAULT '',
  infodata_name4 varchar(100) DEFAULT '',
  infodata_name5 varchar(100) DEFAULT '',
  infodata_name6 varchar(100) DEFAULT '',
  infodata_name7 varchar(100) DEFAULT '',
  infodata_name8 varchar(100) DEFAULT '',
  infodata_name9 varchar(100) DEFAULT '',
  infodata_name10 varchar(100) DEFAULT '',
  infodata_views int(11) DEFAULT '0',
  infodata_addtime int(11) DEFAULT '0',
  PRIMARY KEY (infodata_ord,infodata_lang) USING BTREE,
  UNIQUE KEY infodata_id (infodata_id) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

DROP TABLE IF EXISTS web_job_join;
CREATE TABLE web_job_join (
  join_id int(11) NOT NULL AUTO_INCREMENT,
  join_channelid int(11) DEFAULT '0',
  join_infodataid int(11) DEFAULT '0',
  join_lang varchar(10) DEFAULT '',
  join_post varchar(50) DEFAULT '',
  join_name varchar(50) DEFAULT '',
  join_age varchar(50) DEFAULT '',
  join_sex varchar(50) DEFAULT '',
  join_photo varchar(50) DEFAULT '',
  join_address varchar(100) DEFAULT '',
  join_tel varchar(50) DEFAULT '',
  join_mobile varchar(50) DEFAULT '',
  join_email varchar(50) DEFAULT '',
  join_eduname varchar(50) DEFAULT '',
  join_specialty varchar(100) DEFAULT '',
  join_school varchar(100) DEFAULT '',
  join_edu varchar(50) DEFAULT '',
  join_workinfo text,
  join_strong text,
  join_need text,
  join_isview tinyint(4) DEFAULT '0',
  join_ip varchar(50) DEFAULT '',
  join_addtime int(11) DEFAULT '0',
  PRIMARY KEY (join_id) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

DROP TABLE IF EXISTS web_message;
CREATE TABLE web_message (
  message_id int(11) NOT NULL AUTO_INCREMENT,
  message_channelid int(11) DEFAULT '0',
  message_lang varchar(10) DEFAULT '',
  message_title varchar(100) DEFAULT '',
  message_memo text,
  message_nickname varchar(50) DEFAULT '',
  message_address varchar(50) DEFAULT '',
  message_tel varchar(50) DEFAULT '',
  message_email varchar(50) DEFAULT '',
  message_url varchar(50) DEFAULT '',
  message_qq varchar(50) DEFAULT '',
  message_msn varchar(50) DEFAULT '',
  message_name1 varchar(100) DEFAULT '',
  message_name2 varchar(100) DEFAULT '',
  message_name3 varchar(100) DEFAULT '',
  message_name4 varchar(100) DEFAULT '',
  message_name5 varchar(100) DEFAULT '',
  message_name6 varchar(100) DEFAULT '',
  message_name7 varchar(100) DEFAULT '',
  message_name8 varchar(100) DEFAULT '',
  message_name9 varchar(100) DEFAULT '',
  message_name10 varchar(100) DEFAULT '',
  message_isview tinyint(4) DEFAULT '0',
  message_ispublish tinyint(4) DEFAULT '0',
  message_ishidden tinyint(4) DEFAULT '0',
  message_isreply tinyint(4) DEFAULT '0',
  message_replymemo text,
  message_replydate int(11) DEFAULT '0',
  message_ip varchar(50) DEFAULT '',
  message_addtime int(11) DEFAULT '0',
  PRIMARY KEY (message_id) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

DROP TABLE IF EXISTS web_order;
CREATE TABLE web_order (
  order_id int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  user_id int(11) DEFAULT '0' COMMENT '用户id',
  trade_no varchar(64) DEFAULT '' COMMENT '订单号',
  order_channelid int(11) DEFAULT '0',
  order_lang varchar(10) DEFAULT '',
  order_isview tinyint(4) DEFAULT '0',
  order_name varchar(50) DEFAULT '',
  order_email varchar(50) DEFAULT '',
  order_tel varchar(50) DEFAULT '',
  order_mobile varchar(50) DEFAULT '',
  order_address varchar(50) DEFAULT '',
  order_city varchar(50) DEFAULT '',
  order_province varchar(50) DEFAULT '',
  order_postcode varchar(50) DEFAULT '',
  order_country varchar(50) DEFAULT '',
  order_memo text,
  order_addtime int(11) DEFAULT '0',
  PRIMARY KEY (order_id) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

DROP TABLE IF EXISTS web_orderdetail;
CREATE TABLE web_orderdetail (
  detail_id int(11) NOT NULL AUTO_INCREMENT,
  detail_orderid int(11) DEFAULT '0',
  detail_infodataid int(11) DEFAULT '0',
  detail_infotitle varchar(100) DEFAULT '',
  detail_infoprice int(11) DEFAULT '0',
  detail_infocount int(11) DEFAULT '0',
  PRIMARY KEY (detail_id) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

DROP TABLE IF EXISTS web_pay;
CREATE TABLE web_pay (
  id int(10) unsigned NOT NULL AUTO_INCREMENT,
  order_id int(10) unsigned NOT NULL DEFAULT '0' COMMENT '订单ID',
  trade_no varchar(64) NOT NULL DEFAULT '' COMMENT '订单号',
  pay_no varchar(32) NOT NULL DEFAULT '' COMMENT '支付平台支付订单号',
  prepay_id varchar(64) NOT NULL DEFAULT '' COMMENT '预支付交易会话标识',
  code_url varchar(64) NOT NULL DEFAULT '' COMMENT '二维码链接',
  total_fee decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '支付金额',
  pay_type tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '支付类型:1:微信支付',
  pay_time int(10) unsigned NOT NULL DEFAULT '0' COMMENT '支付时间',
  pay_status tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '支付状态',
  add_time int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  remark varchar(255) NOT NULL DEFAULT '' COMMENT '支付说明',
  PRIMARY KEY (id) USING BTREE,
  KEY order_id (order_id) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

DROP TABLE IF EXISTS web_pay_refund;
CREATE TABLE web_pay_refund (
  id int(10) unsigned NOT NULL AUTO_INCREMENT,
  order_id int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商户订单ID',
  trade_no varchar(32) NOT NULL DEFAULT '' COMMENT '商户订单号',
  refund_no varchar(64) NOT NULL DEFAULT '' COMMENT '商户退款单号',
  pay_type tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '支付方式',
  pay_no varchar(32) NOT NULL DEFAULT '' COMMENT '支付平台订单号',
  refund_id varchar(32) NOT NULL DEFAULT '' COMMENT '支付平台退款单号',
  total_fee decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '总金额(元)',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态',
  reason varchar(255) NOT NULL COMMENT '退款原因',
  remark varchar(255) NOT NULL DEFAULT '' COMMENT '备注信息',
  add_time int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  refund_time int(10) NOT NULL DEFAULT '0' COMMENT '退款时间',
  PRIMARY KEY (id) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='订单支付退款记录';

DROP TABLE IF EXISTS web_user;
CREATE TABLE web_user (
  id int(10) unsigned NOT NULL AUTO_INCREMENT,
  user_name varchar(50) NOT NULL DEFAULT '' COMMENT '用户名',
  user_email varchar(50) NOT NULL COMMENT '用户邮箱',
  `password` varchar(50) NOT NULL DEFAULT '' COMMENT '密码',
  ip varchar(30) NOT NULL DEFAULT '' COMMENT '最后一次登录IP',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态：0:冻结；1:正常',
  openid varchar(64) NOT NULL DEFAULT '' COMMENT '微信用户唯一标识',
  add_time int(10) unsigned NOT NULL COMMENT '注册时间',
  PRIMARY KEY (id) USING BTREE,
  UNIQUE KEY user_name (user_name) USING BTREE,
  KEY user_email (user_email) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户表';

DROP TABLE IF EXISTS web_vote_info;
CREATE TABLE web_vote_info (
  info_id int(11) NOT NULL AUTO_INCREMENT,
  info_channelid int(11) DEFAULT '0',
  info_catid int(11) DEFAULT '0',
  info_ord int(11) NOT NULL,
  info_title varchar(200) DEFAULT '',
  info_addtime int(11) DEFAULT '0',
  PRIMARY KEY (info_ord) USING BTREE,
  UNIQUE KEY info_id (info_id) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

DROP TABLE IF EXISTS web_vote_infodata;
CREATE TABLE web_vote_infodata (
  infodata_id int(11) NOT NULL AUTO_INCREMENT,
  infodata_channelid int(11) DEFAULT '0',
  infodata_catid int(11) DEFAULT '0',
  infodata_infoid int(11) DEFAULT '0',
  infodata_lang varchar(10) NOT NULL,
  infodata_type tinyint(4) DEFAULT '0',
  infodata_title varchar(200) DEFAULT '',
  infodata_ord int(11) NOT NULL,
  infodata_addtime int(11) DEFAULT '0',
  PRIMARY KEY (infodata_ord,infodata_lang) USING BTREE,
  UNIQUE KEY infodata_id (infodata_id) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

DROP TABLE IF EXISTS web_vote_option;
CREATE TABLE web_vote_option (
  option_id int(11) NOT NULL AUTO_INCREMENT,
  option_infoid int(11) DEFAULT '0',
  option_infodataid int(11) DEFAULT '0',
  option_lang varchar(10) DEFAULT '',
  option_name varchar(100) DEFAULT '',
  option_views int(11) DEFAULT '0',
  PRIMARY KEY (option_id) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

DROP TABLE IF EXISTS web_wx_appid;
CREATE TABLE web_wx_appid (
  id int(10) unsigned NOT NULL AUTO_INCREMENT,
  app_name varchar(64) NOT NULL COMMENT '公众号名称',
  appid varchar(64) NOT NULL COMMENT '公众号APPID',
  appsecret varchar(64) NOT NULL COMMENT '公众号APPSECRET',
  add_time int(10) NOT NULL DEFAULT '0' COMMENT '添加时间',
  PRIMARY KEY (id) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='公众号配置表';

DROP TABLE IF EXISTS web_wx_article;
CREATE TABLE web_wx_article (
  id int(10) unsigned NOT NULL AUTO_INCREMENT,
  title varchar(64) NOT NULL COMMENT '标题',
  content text NOT NULL COMMENT '内容',
  digest varchar(64) NOT NULL COMMENT '图文消息的描述，如本字段为空，则默认抓取正文前64个字',
  cover_img_url varchar(255) NOT NULL COMMENT '封面图片',
  show_cover_pic varchar(64) NOT NULL COMMENT '是否显示封面，1为显示，0为不显示',
  update_time int(10) NOT NULL DEFAULT '0' COMMENT '编辑时间',
  add_time int(10) NOT NULL DEFAULT '0' COMMENT '添加时间',
  PRIMARY KEY (id) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='公众号文章表';

DROP TABLE IF EXISTS web_wx_send;
CREATE TABLE web_wx_send (
  id int(10) unsigned NOT NULL AUTO_INCREMENT,
  msg_id varchar(20) NOT NULL DEFAULT '' COMMENT '消息发送任务的ID',
  msg_data_id varchar(20) NOT NULL DEFAULT '' COMMENT '消息的数据ID',
  appsecret varchar(64) NOT NULL COMMENT 'appsecret',
  appid varchar(64) NOT NULL COMMENT 'appid',
  is_deleted tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '1:已删除0未删除',
  add_time int(10) NOT NULL COMMENT '发送时间',
  PRIMARY KEY (id) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='图文消息发送记录表';

DROP TABLE IF EXISTS `web_question`;
CREATE TABLE `web_question`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `answer` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `type_id` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `sort_order` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `add_time` int(10) UNSIGNED NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `type_id`(`type_id`) USING BTREE,
  INDEX `add_time`(`add_time`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

DROP TABLE IF EXISTS `web_question_type`;
CREATE TABLE `web_question_type`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `sort_order` int(10) UNSIGNED NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

DROP TABLE IF EXISTS web_wx_log;
CREATE TABLE web_wx_log (
  id int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(20) NOT NULL DEFAULT '',
  `data` text,
  add_time int(11) DEFAULT '0',
  PRIMARY KEY (id) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

INSERT INTO `web_question` VALUES (1, '基础设置各字段用途', '<p>1、</p><p><img border=\"0\" src=\"../pictures/20210105161215710.png\" /></p><p>2.</p><p><img border=\"0\" src=\"../pictures/20210105161215441.png\" /></p><p>3.图片和附件上传限制：<img border=\"0\" src=\"../pictures/20210105161215282.png\" /></p><p>4.电脑端网站前台头部ico:<img border=\"0\" src=\"../pictures/20210105161215103.png\" /></p><p><img border=\"0\" src=\"../pictures/20210105161358760.png\" /></p><p>5.网站防复制:</p><p><img border=\"0\" src=\"../pictures/20210105161215954.png\" /></p><p>6.客服：</p><p><img border=\"0\" src=\"../pictures/20210105161215875.png\" /></p><p>7.网站首页SEO信息：</p><p><img border=\"0\" src=\"../pictures/20210105161215846.png\" /></p><p>8.其他字段根据字段名称理解</p>', 1, 10, 1609834495);
INSERT INTO `web_question` VALUES (2, '数据库备份', '<p>数据库用来存储网站动态数据，数据丢失或遭到破坏时网站可能发生严重错误;</p><p>备份数据数据库可以在数据用备份的数据重新初始化网站;</p><p>1.备份还原：使用备份的数据重新初始化网站;在备份后添加的数据将会丢失，不建议使用此操作;</p><p>2.删除：删除备份的数据库文件；</p><p><img border=\"0\" src=\"../pictures/20210105161831340.png\" /></p>', 2, 15, 1609835684);
INSERT INTO `web_question` VALUES (3, '极限词说明及使用', '<p>《中华人民共和国广告法》中对&ldquo;极限化违禁词&rdquo;有相关规定。</p><p>因为滥用广告词，夸大产品的真实性，误导消费者，为保障消费者权益，国家实施了被商家号称史上最严的新广告法,新广告法对明星代言,虚假广告,极限用词等都作了规定。一旦违反罚款数万元！！！！！！</p><p>1.使用说明：</p><p>点击左侧导航栏目&lsquo;极限词&rsquo;，可配置网站极限词；极限词之间使用<span style=\"color:#FF0000;\">英文逗号</span>隔开;</p><p>因为极限词不是一成不变的，所以您要根据国家最新的&lsquo;极限词&rsquo;进行完善;</p><p>在添加或编辑新闻，商品，信息类数据时如果检测到您的内容中包含设置的&lsquo;极限词&rsquo;时，会弹出提示框告知，此时要仔细检查本次编辑的内容并修改；</p><p><img border=\"0\" src=\"../pictures/20210105164413290.png\" /></p><p>&nbsp;</p>', 3, 20, 1609836257);
INSERT INTO `web_question` VALUES (4, '屏蔽过滤用途', '<p>当新闻模块的文章允许评论时，用户可在文章下方填写任意评论，当用的提交的数据中包含一些不良词语时会被替过滤为后台设置的内容或禁止提交；</p><p>非法文字过滤和非法文字屏蔽的内容您可自行修改；</p><p>1.非法文字过滤</p><p><img border=\"0\" src=\"../pictures/20210105165132790.png\" /></p><p>用户评论内容:</p><p><img border=\"0\" src=\"../pictures/20210105165435950.png\" /></p><p>后台显示</p><p><img border=\"0\" src=\"../pictures/2021010516515460.png\" /></p><p>后台公开后，前台显示：</p><p><img border=\"0\" src=\"../pictures/20210105165248600.png\" /></p><p>2.非法文字屏蔽：</p><p><img border=\"0\" src=\"../pictures/20210105165335452.png\" /></p><p>前台&nbsp;</p><p><img border=\"0\" src=\"../pictures/20210105165335680.png\" /></p><p>点击&#39;发表评论&#39;，禁止提交</p><p><img border=\"0\" src=\"../pictures/20210105165335721.png\" /></p><p>&nbsp;</p>', 4, 25, 1609836936);
INSERT INTO `web_question` VALUES (5, '如何修改密码', '<p>点击导航栏目&#39;<span style=\"color:#FF0000;\">密码保护</span>&#39;，可修改用户名和密码</p>', 5, 30, 1609836992);
INSERT INTO `web_question` VALUES (8, 'SEO说明', '<p>1.列表页：在每个栏目的基本设置中设置，在页面上右击，点击&quot;查看网页源代码&quot;,进行查看</p>\r\n\r\n<p><img src=\"../pictures/03601a4f7a96cab.png\" style=\"border-width: 0px; border-style: solid; height: 338px; width: 600px;\" /></p>\r\n\r\n<p><img border=\"0\" src=\"../pictures/03601a4f8d8360f.png\" /></p>\r\n\r\n<p>2.详情页：</p>\r\n\r\n<p>每条数据添加页面关键词，页面描述;</p>\r\n\r\n<p>如果数据没有填写页面关键词，会显示这条数据所属分类的页面关键词；所属分类没填写分类关键词，则源代码中keywords为空；</p>\r\n\r\n<p>如果数据没有填写页面描述，会显示这条数据所属分类的页面描述；所属分类没填写页面描述，则源代码中description为空；</p>\r\n\r\n<p>3.首页SEO配置：</p>\r\n\r\n<p>基础配置-&gt;基础配置：点击上方seo配置，填写后点击&#39;提交，编辑&#39;按钮；</p>\r\n\r\n<p>&nbsp;</p>\r\n', 7, 45, 1612337260);

INSERT INTO `web_question_type` VALUES (1, '基础设置-基础设置', 10);
INSERT INTO `web_question_type` VALUES (2, '基础设置-数据库', 15);
INSERT INTO `web_question_type` VALUES (3, '基础设置-极限词', 20);
INSERT INTO `web_question_type` VALUES (4, '基础设置-屏蔽过滤', 25);
INSERT INTO `web_question_type` VALUES (5, '基础设置-修改密码', 30);
INSERT INTO `web_question_type` VALUES (6, '产品中心', 35);
INSERT INTO `web_question_type` VALUES (7, 'SEO说明', 40);
INSERT INTO `web_question_type` VALUES (10, '特别提醒', 3);

INSERT INTO web_admin VALUES('admin8','I87I75CN5C9HFI2477F245H942J5478J','64','::1','1604051939','0');