-- phpMyAdmin SQL Dump
-- version 5.0.2
-- https://www.phpmyadmin.net/
--
-- 主机： localhost
-- 生成日期： 2021-09-02 15:12:09
-- 服务器版本： 5.7.31-log
-- PHP 版本： 7.4.11

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- 数据库： `dancephp`
--

-- --------------------------------------------------------

--
-- 表的结构 `dance_aaaa`
--

CREATE TABLE `dance_aaaa` (
  `id` int(11) UNSIGNED NOT NULL,
  `space` varchar(40) NOT NULL DEFAULT '',
  `module` varchar(40) NOT NULL DEFAULT '',
  `flag` varchar(40) NOT NULL DEFAULT '',
  `content` text CHARACTER SET utf8mb4,
  `extra` text CHARACTER SET utf8mb4,
  `extra2` text CHARACTER SET utf8mb4,
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `dance_admin_log`
--

CREATE TABLE `dance_admin_log` (
  `id` int(11) UNSIGNED NOT NULL,
  `uid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `username` varchar(40) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
  `origin_credit` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '原始积分',
  `change_type` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '变动状态',
  `change_credit` int(10) NOT NULL DEFAULT '0' COMMENT '变动积分',
  `change_give` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '赠送积分',
  `content` varchar(255) NOT NULL DEFAULT '',
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `order_id` int(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `dance_admin_user`
--

CREATE TABLE `dance_admin_user` (
  `id` int(11) UNSIGNED NOT NULL,
  `username` varchar(40) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '用户名',
  `password` char(32) NOT NULL DEFAULT '' COMMENT '登录密码',
  `groupid` smallint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户组',
  `realname` varchar(40) NOT NULL DEFAULT '' COMMENT '姓名',
  `mobile` varchar(20) DEFAULT '' COMMENT '手机号',
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '注册时间',
  `last_login_ip` varchar(16) DEFAULT '' COMMENT '最后登录ip',
  `last_login_time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '最后登录时间',
  `status` tinyint(1) UNSIGNED NOT NULL DEFAULT '1' COMMENT '用户状态',
  `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='管理员';

--
-- 转存表中的数据 `dance_admin_user`
--

INSERT INTO `dance_admin_user` (`id`, `username`, `password`, `groupid`, `realname`, `mobile`, `create_time`, `last_login_ip`, `last_login_time`, `status`, `remark`) VALUES
(1, 'admin', '0199ec7910e09ba263ed6ab5a4dddf2c', 1, '', '', 1567490764, '', 1604378932, 1, ''),
(3, 'hduxg', '080891345a84a03f036d91daf7a21162', 1, '', '', 1567691486, '', 1630482691, 1, '');

-- --------------------------------------------------------

--
-- 表的结构 `dance_article`
--

CREATE TABLE `dance_article` (
  `id` int(11) NOT NULL,
  `status` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `uid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `title` varchar(100) NOT NULL DEFAULT '',
  `content` mediumtext NOT NULL,
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `share_title` varchar(100) NOT NULL DEFAULT '',
  `share_desc` varchar(255) NOT NULL DEFAULT '',
  `share_icon` varchar(255) NOT NULL DEFAULT '',
  `hit_num` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `like_num` int(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `dance_article`
--

INSERT INTO `dance_article` (`id`, `status`, `uid`, `title`, `content`, `create_time`, `share_title`, `share_desc`, `share_icon`, `hit_num`, `like_num`) VALUES
(1, 1, 0, '商城公告', '<p><font color=\"#ff0000\"><b>哈哈哈</b></font></p><p><font color=\"#ff0000\"><b><br/></b></font></p>', 1545728474, '', '', '', 41, 0);

-- --------------------------------------------------------

--
-- 表的结构 `dance_auth_access`
--

CREATE TABLE `dance_auth_access` (
  `groupid` smallint(6) UNSIGNED NOT NULL,
  `m` varchar(20) NOT NULL COMMENT '模块',
  `c` varchar(20) NOT NULL COMMENT '控制器',
  `a` varchar(20) NOT NULL COMMENT '操作'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `dance_auth_access`
--

INSERT INTO `dance_auth_access` (`groupid`, `m`, `c`, `a`) VALUES
(5, 'manage', 'article', 'index'),
(5, 'zhengzhan', 'index', 'index'),
(5, 'weiyingyong', 'index', 'index'),
(5, 'manage', 'bargain', 'index'),
(7, 'mobmall_manage', 'template', 'index'),
(7, 'mobmall_manage', 'subset', 'index'),
(4, 'mobmall_manage', 'orderRefund', 'index'),
(4, 'mobmall_manage', 'order', 'index'),
(2, 'mobmall_manage', 'category', 'index'),
(2, 'mobmall_manage', 'dataParent', 'index'),
(2, 'mobmall_manage', 'placeUpload', 'index'),
(2, 'mobmall_manage', 'productUpload', 'index'),
(2, 'mobmall_manage', 'source', 'index'),
(2, 'mobmall_manage', 'product', 'index'),
(2, 'mobmall_manage', 'place', 'index'),
(2, 'mobmall_manage', 'company', 'index'),
(2, 'admin', 'enterpriseRule', 'index'),
(2, 'admin', 'vip', 'index'),
(2, 'admin', 'enterpriseGroup', 'index'),
(2, 'admin', 'article', 'index'),
(2, 'admin', 'enterpriseCate', 'index'),
(2, 'mobmall_manage', 'productParent', 'index'),
(2, 'admin', 'authGroup', 'index'),
(2, 'admin', 'authRule', 'index'),
(2, 'admin', 'authCate', 'index'),
(2, 'admin', 'auth', 'index'),
(6, 'mobmall_manage', 'live', 'index'),
(6, 'mobmall_manage', 'process', 'index'),
(6, 'mobmall_manage', 'template', 'index'),
(6, 'mobmall_manage', 'subset', 'index'),
(6, 'mobmall_manage', 'placeUpload', 'index'),
(6, 'mobmall_manage', 'productUpload', 'index'),
(6, 'mobmall_manage', 'source', 'index'),
(6, 'mobmall_manage', 'assemblage', 'index'),
(6, 'mobmall_manage', 'product', 'index'),
(6, 'mobmall_manage', 'place', 'index'),
(6, 'mobmall_manage', 'company', 'index'),
(6, 'mobmall_manage', 'code', 'index'),
(6, 'admin', 'article', 'index'),
(6, 'mobmall_manage', 'productParent', 'index'),
(6, 'admin', 'system', 'index'),
(6, 'admin', 'youku', 'index'),
(6, 'mobmall_manage', 'companyParent', 'index'),
(6, 'mobmall_manage', 'exhibition', 'index'),
(6, 'mobmall_manage', 'placeVideo', 'index'),
(1, 'mobmall_manage', 'slide', 'index'),
(1, 'mobmall_manage', 'navigation', 'index'),
(1, 'mobmall_manage', 'announce', 'index'),
(1, 'mobmall_manage', 'articleCategory', 'index'),
(1, 'mobmallParent', 'index', 'index'),
(1, 'mobmall_manage', 'index', 'index'),
(4, 'mobmall_manage', 'slide', 'index'),
(4, 'mobmall_manage', 'delivery', 'index'),
(4, 'mobmall_manage', 'selfpickup', 'index'),
(4, 'mobmall_manage', 'expressCompany', 'index'),
(4, 'mobmall_manage', 'help', 'index'),
(7, 'mobmall_manage', 'category', 'index'),
(7, 'mobmall_manage', 'placeUpload', 'index'),
(7, 'mobmall_manage', 'productUpload', 'index'),
(7, 'mobmall_manage', 'source', 'index'),
(1, 'mobmall_manage', 'article', 'index'),
(7, 'mobmall_manage', 'assemblage', 'index'),
(7, 'mobmall_manage', 'product', 'index'),
(7, 'mobmall_manage', 'place', 'index'),
(7, 'mobmall_manage', 'company', 'index'),
(7, 'mobmall_manage', 'selfpickup', 'index'),
(7, 'mobmall_manage', 'productParent', 'index'),
(2, 'mobmall_manage', 'process', 'index'),
(2, 'mobmall_manage', 'orderParent', 'index'),
(2, 'mobmall_manage', 'order', 'index'),
(2, 'mobmall_manage', 'orderRefund', 'index'),
(2, 'mobmall_manage', 'live', 'index'),
(2, 'mobmall_manage', 'placeVideo', 'index'),
(2, 'mobmall_manage', 'leaveword', 'index'),
(7, 'mobmall_manage', 'process', 'index'),
(7, 'mobmall_manage', 'live', 'index'),
(7, 'mobmall_manage', 'exhibition', 'index'),
(7, 'mobmall_manage', 'placeVideo', 'index'),
(7, 'mobmall_manage', 'leaveword', 'index'),
(8, 'mobmall_manage', 'leaveword', 'index'),
(1, 'weixin_manage', 'firstpush', 'index'),
(8, 'mobmall_manage', 'delivery', 'index'),
(8, 'mobmall_manage', 'slide', 'index'),
(8, 'mobmall_manage', 'live', 'index'),
(1, 'weixin_manage', 'event', 'index'),
(8, 'mobmall_manage', 'otherParent', 'index'),
(8, 'mobmall_manage', 'orderRefund', 'index'),
(8, 'mobmall_manage', 'order', 'index'),
(8, 'mobmall_manage', 'orderParent', 'index'),
(8, 'mobmall_manage', 'process', 'index'),
(8, 'mobmall_manage', 'evaluation', 'index'),
(8, 'mobmall_manage', 'subset', 'index'),
(8, 'mobmall_manage', 'category', 'index'),
(8, 'mobmall_manage', 'productUpload', 'index'),
(1, 'admin', 'config', 'index'),
(1, 'admin', 'weixinAccount', 'index'),
(1, 'admin', 'weixinApplet', 'index'),
(8, 'mobmall_manage', 'source', 'index'),
(8, 'mobmall_manage', 'assemblage', 'index'),
(8, 'mobmall_manage', 'product', 'index'),
(1, 'weixin_manage', 'menu', 'index'),
(8, 'mobmall_manage', 'company', 'index'),
(8, 'mobmall_manage', 'selfpickup', 'index'),
(8, 'admin', 'youku', 'index'),
(8, 'mobmall_manage', 'help', 'index'),
(8, 'mobmall_manage', 'expressCompany', 'index'),
(8, 'mobmall_manage', 'hotline', 'index'),
(1, 'admin', 'system', 'index'),
(1, 'admin', 'adminUser', 'index'),
(1, 'admin', 'authGroup', 'index'),
(1, 'admin', 'authRule', 'index'),
(1, 'admin', 'authCate', 'index'),
(1, 'admin', 'auth', 'index');

-- --------------------------------------------------------

--
-- 表的结构 `dance_auth_cate`
--

CREATE TABLE `dance_auth_cate` (
  `id` mediumint(5) NOT NULL,
  `name` varchar(255) NOT NULL,
  `status` int(1) NOT NULL DEFAULT '1',
  `descrip` varchar(255) NOT NULL DEFAULT '',
  `vieworder` smallint(3) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `dance_auth_cate`
--

INSERT INTO `dance_auth_cate` (`id`, `name`, `status`, `descrip`, `vieworder`) VALUES
(1, '系统', 1, '', 1),
(2, '网站', 1, '', 0);

-- --------------------------------------------------------

--
-- 表的结构 `dance_auth_cate_access`
--

CREATE TABLE `dance_auth_cate_access` (
  `groupid` smallint(6) UNSIGNED NOT NULL,
  `cid` int(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `dance_auth_cate_access`
--

INSERT INTO `dance_auth_cate_access` (`groupid`, `cid`) VALUES
(8, 4),
(8, 2),
(8, 1),
(7, 4),
(7, 2),
(4, 2),
(6, 2),
(6, 1),
(2, 4),
(2, 2),
(2, 1),
(4, 4),
(1, 2),
(1, 1);

-- --------------------------------------------------------

--
-- 表的结构 `dance_auth_group`
--

CREATE TABLE `dance_auth_group` (
  `id` mediumint(8) UNSIGNED NOT NULL,
  `name` char(100) NOT NULL DEFAULT '' COMMENT '用户组中文名称',
  `description` varchar(80) DEFAULT NULL COMMENT '描述信息',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态。1启用，0禁用',
  `vieworder` smallint(3) UNSIGNED NOT NULL DEFAULT '0',
  `allow_admin` tinyint(1) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用户组表';

--
-- 转存表中的数据 `dance_auth_group`
--

INSERT INTO `dance_auth_group` (`id`, `name`, `description`, `status`, `vieworder`, `allow_admin`) VALUES
(1, '超级管理员', '拥有网站的最高权限', 1, 0, 1),
(2, '部门经理', '拥有网站的部分权限', 1, 0, 1),
(3, '商城客服', '客服处理订单发货，只能看到商城', 1, 0, 0),
(4, '业务员', '业务员账号，帮客户系统输入，客户资料查询', 1, 0, 1),
(5, '会计', '订单相关权限', 1, 0, 1);

-- --------------------------------------------------------

--
-- 表的结构 `dance_auth_rule`
--

CREATE TABLE `dance_auth_rule` (
  `id` smallint(6) NOT NULL,
  `cid` smallint(3) UNSIGNED NOT NULL DEFAULT '0',
  `name` char(80) NOT NULL DEFAULT '' COMMENT '导航名称',
  `module` varchar(20) NOT NULL DEFAULT '',
  `controller` varchar(20) NOT NULL DEFAULT '',
  `action` varchar(20) NOT NULL DEFAULT '',
  `subsidiary` varchar(255) NOT NULL DEFAULT '' COMMENT '附属菜单',
  `depend_type` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '来源类型。1module，2plugin，3theme',
  `depend_flag` varchar(30) NOT NULL DEFAULT '' COMMENT '来源标记。如：模块或插件标识',
  `pid` smallint(6) UNSIGNED DEFAULT '0' COMMENT '上级id',
  `has_sub` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `icon` varchar(50) DEFAULT '' COMMENT '图标',
  `btn_class` varchar(40) NOT NULL DEFAULT '',
  `position` varchar(20) DEFAULT 'left' COMMENT '菜单显示位置。left:左边，top:头部',
  `vieworder` smallint(5) UNSIGNED DEFAULT '99' COMMENT '排序，值越小越靠前',
  `update_time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '更新时间',
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否有效(0:无效,1:有效)',
  `display` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '是否显示',
  `is_selfmenu` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否独立菜单'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='规则表（前台菜单）';

--
-- 转存表中的数据 `dance_auth_rule`
--

INSERT INTO `dance_auth_rule` (`id`, `cid`, `name`, `module`, `controller`, `action`, `subsidiary`, `depend_type`, `depend_flag`, `pid`, `has_sub`, `icon`, `btn_class`, `position`, `vieworder`, `update_time`, `create_time`, `status`, `display`, `is_selfmenu`) VALUES
(1, 1, '权限管理', 'admin', 'auth', 'index', '', 0, '', 0, 1, '', '', 'left', 0, 0, 1520931080, 1, 1, 0),
(2, 1, '菜单分类', 'admin', 'authCate', 'index', '', 0, '', 1, 0, '', 'btn-success', 'left', 0, 0, 1520938748, 1, 1, 0),
(3, 1, '规则管理', 'admin', 'authRule', 'index', '', 0, '', 1, 0, '', '', 'left', 0, 0, 1533195302, 1, 1, 0),
(4, 1, '角色组', 'admin', 'authGroup', 'index', '', 0, '', 1, 0, '', '', 'left', 0, 0, 1521098220, 1, 1, 0),
(5, 1, '账号管理', 'admin', 'adminUser', 'index', '', 0, '', 1, 0, '', '', 'left', 0, 0, 0, 1, 1, 0),
(6, 1, '常规管理', 'admin', 'system', 'index', '', 0, '', 0, 1, '', '', 'left', 0, 0, 1523599229, 1, 1, 0),
(7, 1, '系统配置', 'admin', 'config', 'index', '', 0, '', 6, 0, '', 'btn-danger', 'left', 0, 0, 1527582991, 1, 1, 0),
(11, 1, '公众号管理', 'admin', 'weixinAccount', 'index', '', 0, '', 6, 0, '', '', 'left', 0, 0, 0, 1, 1, 0),
(12, 1, '小程序管理', 'admin', 'weixinApplet', 'index', '', 0, '', 6, 0, '', '', 'left', 0, 0, 0, 1, 1, 0),
(13, 1, '微信菜单', 'weixin_manage', 'menu', 'index', '', 0, '', 6, 0, '', '', 'left', 0, 0, 0, 1, 0, 0),
(14, 1, '触发事件', 'weixin_manage', 'event', 'index', '', 0, '', 6, 0, '', '', 'left', 0, 0, 0, 1, 0, 0),
(15, 1, '关注推送', 'weixin_manage', 'firstpush', 'index', '', 0, '', 6, 0, '', '', 'left', 0, 0, 0, 1, 0, 0),
(21, 2, '网站管理', 'mobmallParent', 'index', 'index', '', 0, '', 0, 1, '', '', 'left', 0, 0, 0, 1, 1, 0),
(22, 2, '首页', 'mobmall_manage', 'index', 'index', '', 0, '', 21, 0, '', '', 'left', 0, 0, 0, 1, 1, 0),
(23, 2, '文章管理', 'mobmall_manage', 'article', 'index', '', 0, '', 21, 0, '', '', 'left', 0, 0, 0, 1, 1, 0),
(24, 2, '文章分类', 'mobmall_manage', 'articleCategory', 'index', '', 0, '', 21, 0, '', '', 'left', 0, 0, 0, 1, 1, 0),
(25, 2, '公告管理', 'mobmall_manage', 'announce', 'index', '', 0, '', 21, 0, '', '', 'left', 0, 0, 0, 1, 1, 0),
(26, 2, '导航管理', 'mobmall_manage', 'navigation', 'index', '', 0, '', 21, 0, '', '', 'left', 0, 0, 0, 1, 1, 0),
(27, 2, '图片轮播', 'mobmall_manage', 'slide', 'index', '', 0, '', 21, 0, '', '', 'left', 0, 0, 0, 1, 1, 0);

-- --------------------------------------------------------

--
-- 表的结构 `dance_config`
--

CREATE TABLE `dance_config` (
  `config_name` varchar(30) NOT NULL DEFAULT '' COMMENT '配置名称',
  `config_space` varchar(20) NOT NULL DEFAULT '',
  `config_value` text NOT NULL COMMENT '缓存值',
  `vtype` enum('string','array','object') NOT NULL DEFAULT 'string' COMMENT '配置值类型',
  `description` text NOT NULL COMMENT '配置介绍'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `dance_config`
--

INSERT INTO `dance_config` (`config_name`, `config_space`, `config_value`, `vtype`, `description`) VALUES
('site_title', 'global', 'dancePHP后台管理系统', 'string', ''),
('site_icp', 'global', '', 'string', ''),
('toggle_web_site', 'global', '1', 'string', ''),
('site_domain', 'global', 'http://demo.uucms.com', 'string', ''),
('evaluation_check', 'global', '0', 'string', ''),
('site_share_domain', 'global', 'http://xdd.uucms.com', 'string', ''),
('is_verify_open', 'global', '0', 'string', ''),
('vip_edit_check', 'global', '0', 'string', ''),
('content', 'affiliate', '<p>欢迎来到蟹多多商城<br/></p>', 'string', ''),
('wxname', 'weixinxcx', '蟹多多生鲜交易平台', 'string', ''),
('appid', 'weixinxcx', 'wx1c3410aa5850f807', 'string', ''),
('appsecret', 'weixinxcx', 'afcc4e3edb073e630fd6590131d590a0', 'string', ''),
('mchid', 'weixinxcx', '1529547301', 'string', ''),
('mchkey', 'weixinxcx', '813c32e3ffdbec2e02d5a04d3dd1b4a2', 'string', ''),
('weixin', 'weixinxcx', 'wuyuan', 'string', ''),
('pay_over_time', 'global', '86400', 'string', ''),
('receive_over_time', 'global', '1209600', 'string', ''),
('allow_pay_method', 'global', '0', 'string', ''),
('site_https_domain', 'global', 'https://xdd.uucms.com', 'string', ''),
('kefu_ewm', 'global', 'config/Mon_1907/5d20aa4737d68.jpg', 'string', ''),
('kefu_qq', 'global', '', 'string', ''),
('kefu_tel', 'global', '', 'string', ''),
('category_sub', 'global', '1', 'string', ''),
('authorize_wid', 'global', '8', 'string', ''),
('is_wxtemplate_open', 'global', '1', 'string', ''),
('is_default_city', 'global', '0', 'string', ''),
('province', 'global', '', 'string', ''),
('city', 'global', '', 'string', ''),
('district', 'global', '', 'string', ''),
('isopen_footermenu', 'global', '0', 'string', ''),
('agreement', 'agreement', '', 'string', ''),
('content', 'agreement', '', 'string', ''),
('site_title', 'system', 'dancephp', 'string', ''),
('site_domain', 'system', '', 'string', ''),
('site_share_domain', 'system', '', 'string', ''),
('site_https_domain', 'system', '', 'string', ''),
('site_icp', 'system', '苏ICP备19011842号-5', 'string', ''),
('toggle_web_site', 'system', '1', 'string', ''),
('kefu_wxid', 'system', '', 'string', ''),
('kefu_qq', 'system', '', 'string', ''),
('kefu_info', 'system', '', 'string', ''),
('kefu_tel', 'system', '', 'string', ''),
('is_verify_open', 'system', '0', 'string', ''),
('province', 'system', '', 'string', ''),
('city', 'system', '', 'string', ''),
('district', 'system', '', 'string', '');

-- --------------------------------------------------------

--
-- 表的结构 `dance_help`
--

CREATE TABLE `dance_help` (
  `id` int(11) NOT NULL,
  `status` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `vieworder` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  `title` varchar(100) NOT NULL DEFAULT '',
  `link` varchar(255) NOT NULL DEFAULT '',
  `content` mediumtext NOT NULL,
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `dance_help`
--

INSERT INTO `dance_help` (`id`, `status`, `vieworder`, `title`, `link`, `content`, `create_time`) VALUES
(1, 1, 0, '关于我们', '', '<p><span style=\"font-family: \"Microsoft YaHei\", YaHei, SimHei, Hei, Arial, tahoma, arial, sans-serif; font-size: 24px;\">关于我们</span><span style=\"font-family: \"Microsoft YaHei\", YaHei, SimHei, Hei, Arial, tahoma, arial, sans-serif; font-size: 24px;\">关于我们</span><span style=\"font-family: \"Microsoft YaHei\", YaHei, SimHei, Hei, Arial, tahoma, arial, sans-serif; font-size: 24px;\">关于我们</span><span style=\"font-family: \"Microsoft YaHei\", YaHei, SimHei, Hei, Arial, tahoma, arial, sans-serif; font-size: 24px;\">关于我们</span><span style=\"font-family: \"Microsoft YaHei\", YaHei, SimHei, Hei, Arial, tahoma, arial, sans-serif; font-size: 24px;\">关于我们</span></p>', 1543020401),
(2, 1, 0, '免责条款', '', '<p>免责条款\n免责条款\n免责条款\n免责条款</p>', 1543020813);

-- --------------------------------------------------------

--
-- 表的结构 `dance_hotline`
--

CREATE TABLE `dance_hotline` (
  `id` int(11) NOT NULL,
  `status` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `vieworder` smallint(3) UNSIGNED NOT NULL DEFAULT '0',
  `title` varchar(100) NOT NULL DEFAULT '',
  `page_flag` varchar(40) NOT NULL DEFAULT '',
  `page_name` varchar(40) NOT NULL DEFAULT '',
  `page_data` varchar(255) NOT NULL DEFAULT '',
  `page_extra` varchar(40) NOT NULL DEFAULT '',
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `color` varchar(10) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `dance_hotline`
--

INSERT INTO `dance_hotline` (`id`, `status`, `vieworder`, `title`, `page_flag`, `page_name`, `page_data`, `page_extra`, `create_time`, `color`) VALUES
(1, 1, 0, '热烈欢迎来到商城，商城试运行，如遇问题请联系客服。17505129563', 'index', '首页', '', '', 1548059441, '');

-- --------------------------------------------------------

--
-- 表的结构 `dance_nav`
--

CREATE TABLE `dance_nav` (
  `id` smallint(6) UNSIGNED NOT NULL,
  `title` varchar(60) NOT NULL DEFAULT '' COMMENT '标题',
  `value` varchar(120) DEFAULT '' COMMENT 'url地址',
  `pid` smallint(6) UNSIGNED NOT NULL DEFAULT '0' COMMENT '父级',
  `position` varchar(20) NOT NULL DEFAULT '' COMMENT '位置。头部：header，我的：my',
  `target` varchar(15) DEFAULT '_self' COMMENT '打开方式。',
  `depend_type` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '来源类型。0普通外链http，1模块扩展，2插件扩展，3主题扩展',
  `depend_flag` varchar(30) NOT NULL DEFAULT '' COMMENT '来源标记。如：模块或插件标识',
  `icon` varchar(120) NOT NULL DEFAULT '' COMMENT '图标',
  `sort` tinyint(3) UNSIGNED NOT NULL DEFAULT '99' COMMENT '排序',
  `update_time` int(10) UNSIGNED NOT NULL COMMENT '更新时间',
  `create_time` int(10) UNSIGNED NOT NULL COMMENT '创建时间',
  `status` tinyint(1) UNSIGNED NOT NULL DEFAULT '1' COMMENT '状态。0禁用，1启用'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='前台导航';

--
-- 转存表中的数据 `dance_nav`
--

INSERT INTO `dance_nav` (`id`, `title`, `value`, `pid`, `position`, `target`, `depend_type`, `depend_flag`, `icon`, `sort`, `update_time`, `create_time`, `status`) VALUES
(1, '主页', '/', 0, 'header', '_self', 1, 'home', 'fa fa-home', 10, 1517978360, 1516206948, 1),
(2, '会员', 'user/index/index', 0, 'header', '_self', 1, 'user', '', 99, 1516245690, 1516245690, 1),
(3, '下载', 'https://gitee.com/ZhaoJunfeng/EacooPHP/attach_files', 0, 'header', '_blank', 0, '', '', 99, 1520574029, 1516245884, 0),
(4, '社区', 'http://forum.eacoo123.com', 0, 'header', '_blank', 0, '', '', 99, 1520574036, 1516246000, 0),
(5, '文档', 'https://www.kancloud.cn/youpzt/eacoo', 0, 'header', '_blank', 0, '', '', 99, 1520574041, 1516249947, 0);

-- --------------------------------------------------------

--
-- 表的结构 `dance_proclock`
--

CREATE TABLE `dance_proclock` (
  `uid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `action` varchar(20) NOT NULL DEFAULT '',
  `time` int(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `dance_slide`
--

CREATE TABLE `dance_slide` (
  `id` int(11) UNSIGNED NOT NULL,
  `title` varchar(100) NOT NULL DEFAULT '',
  `picurl` varchar(255) NOT NULL DEFAULT '',
  `link` varchar(255) NOT NULL DEFAULT '',
  `vieworder` smallint(3) UNSIGNED NOT NULL DEFAULT '0',
  `status` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `dance_user`
--

CREATE TABLE `dance_user` (
  `id` int(11) UNSIGNED NOT NULL,
  `username` varchar(40) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '用户名',
  `password` char(32) NOT NULL DEFAULT '' COMMENT '登录密码',
  `openid` varchar(40) NOT NULL DEFAULT '',
  `openidxcx` varchar(40) NOT NULL DEFAULT '',
  `unionid` varchar(40) NOT NULL DEFAULT '',
  `type` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `enterprise_groupid` smallint(3) UNSIGNED NOT NULL DEFAULT '0',
  `shid` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '店铺ID',
  `shop_name` varchar(100) NOT NULL DEFAULT '' COMMENT '店铺名称',
  `realamount` decimal(10,2) UNSIGNED NOT NULL DEFAULT '0.00',
  `email` varchar(100) NOT NULL DEFAULT '' COMMENT '登录邮箱',
  `realname` varchar(20) NOT NULL DEFAULT '' COMMENT '姓名',
  `mobile` varchar(20) DEFAULT '' COMMENT '手机号',
  `avatar` varchar(255) DEFAULT '' COMMENT '用户头像，相对于uploads/avatar目录',
  `gender` smallint(1) UNSIGNED DEFAULT '0' COMMENT '性别；0：保密，1：男；2：女',
  `country` varchar(40) NOT NULL DEFAULT '',
  `province` varchar(40) NOT NULL DEFAULT '',
  `city` varchar(40) NOT NULL DEFAULT '',
  `birthday` date DEFAULT '0000-00-00' COMMENT '生日',
  `description` varchar(200) DEFAULT '' COMMENT '个人描述',
  `register_ip` varchar(16) DEFAULT '' COMMENT '注册IP',
  `reg_method` varchar(30) NOT NULL DEFAULT '' COMMENT '注册方式。wechat,sina,等',
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '注册时间',
  `last_login_ip` varchar(16) DEFAULT '' COMMENT '最后登录ip',
  `last_login_time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '最后登录时间',
  `subscribe` tinyint(1) UNSIGNED DEFAULT '0' COMMENT '是否关注',
  `login_num` tinyint(1) UNSIGNED DEFAULT '0' COMMENT '登录次数',
  `status` tinyint(1) UNSIGNED NOT NULL DEFAULT '2' COMMENT '用户状态 0：禁用； 1：正常 ；2：待验证',
  `remark` varchar(255) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用户表';

-- --------------------------------------------------------

--
-- 表的结构 `dance_visit`
--

CREATE TABLE `dance_visit` (
  `id` int(11) UNSIGNED NOT NULL,
  `ipaddr` varchar(40) NOT NULL DEFAULT '',
  `create_date` date NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `dance_weixin_account`
--

CREATE TABLE `dance_weixin_account` (
  `id` int(11) UNSIGNED NOT NULL,
  `wxname` varchar(60) NOT NULL COMMENT '名称',
  `wxid` varchar(20) NOT NULL DEFAULT '' COMMENT '原始ID',
  `wxnumber` char(20) NOT NULL DEFAULT '' COMMENT '微信号',
  `wxtype` tinyint(1) NOT NULL DEFAULT '1',
  `t` varchar(50) NOT NULL DEFAULT '',
  `aeskey` varchar(45) NOT NULL DEFAULT '',
  `encode` tinyint(1) NOT NULL DEFAULT '0',
  `token` char(255) NOT NULL,
  `appid` varchar(50) NOT NULL DEFAULT '',
  `appsecret` varchar(50) NOT NULL DEFAULT '',
  `mchid` varchar(20) NOT NULL DEFAULT '',
  `mchkey` varchar(40) NOT NULL DEFAULT '',
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `ewmurl` varchar(255) NOT NULL DEFAULT '',
  `apiclient_cert` text,
  `apiclient_key` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='微信公众帐号';

--
-- 转存表中的数据 `dance_weixin_account`
--

INSERT INTO `dance_weixin_account` (`id`, `wxname`, `wxid`, `wxnumber`, `wxtype`, `t`, `aeskey`, `encode`, `token`, `appid`, `appsecret`, `mchid`, `mchkey`, `create_time`, `ewmurl`, `apiclient_cert`, `apiclient_key`) VALUES
(8, '(服务号)', 'gh_9d7d116be224', 'test', 1, 'nuitlo1537345772', 'wolniMMWvJ0WUfpSJcLzXgAaARG2JEy94PbyjQ9BvLi', 0, 'wykeji', 'wx9c3ccacb2836da23', '513c3ee3ffdbec2e02d5a04d3cd1b4a1', '1529547301', '813c32e3ffdbec2e02d5a04d3dd1b4a2', 1537345770, '', '-----BEGIN CERTIFICATE-----\r\nMIID/zCCAuegAwIBAgIUbHTEKpq4GCdkvzRIrHhBnoYqn8gwDQYJKoZIhvcNAQEL\r\nBQAwXjELMAkGA1UEBhMCQ04xEzARBgNVBAoTClRlbnBheS5jb20xHTAbBgNVBAsT\r\nFFRlbnBheS5jb20gQ0EgQ2VudGVyMRswGQYDVQQDExJUZW5wYXkuY29tIFJvb3Qg\r\nQ0EwHhcNMjAwOTI3MDc0MzIxWhcNMjUwOTI2MDc0MzIxWjCBkDETMBEGA1UEAwwK\r\nMTUyMzA4Nzg2MTEbMBkGA1UECgwS5b6u5L+h5ZWG5oi357O757ufMTwwOgYDVQQL\r\nDDPmmIblsbHluILnjonlsbHplYflpKflkpblsI/nvo7lub/lkYrorr7orqHlt6Xk\r\nvZzlrqQxCzAJBgNVBAYMAkNOMREwDwYDVQQHDAhTaGVuWmhlbjCCASIwDQYJKoZI\r\nhvcNAQEBBQADggEPADCCAQoCggEBAJuMpwdOY50vvwFyhg04Y3LrKSDtDogp6wdM\r\nKp8IQFl4RbmJ2I3ojsvR00Ad0qQ+Y4XV9jcc8K+K6xu9bDhu/0SPs/PHj4LWz5L3\r\nVaTxGRz1Z/elwJt5vd8ssnWW95niED0VEKUg4SxU31iXCkepyImMK4wIxfWfZHhj\r\n2pQcmtid1mKUW9172qbzPZTQkWeJ+eOx7aWIB4p2m6oy7hYEa6Qh+JaX+WWd5She\r\nBJUadZi/CVMuJfX29wV3aV2EhX9zYcE7dNEIMQZ4yS32NZ9rn1DPFujF+mB7rOOS\r\n+s+neKvzqPn5N2GSL4nJkMVoRPsqfOrWv2r1nfODj1qpyY9scV0CAwEAAaOBgTB/\r\nMAkGA1UdEwQCMAAwCwYDVR0PBAQDAgTwMGUGA1UdHwReMFwwWqBYoFaGVGh0dHA6\r\nLy9ldmNhLml0cnVzLmNvbS5jbi9wdWJsaWMvaXRydXNjcmw/Q0E9MUJENDIyMEU1\r\nMERCQzA0QjA2QUQzOTc1NDk4NDZDMDFDM0U4RUJEMjANBgkqhkiG9w0BAQsFAAOC\r\nAQEAaKRQ2ivRWn0XyeeyCdG0Hlp3MFdVTgEI13EicufUsnYrd8ldj14PiGBiMVas\r\nG7yohZLNrhEoN8L6gJHBhvx95UcH5mxnwxlmjUnDSZpqsNrehfamIhUdrT6NGZfI\r\nbaPTTwZgqAXStsQh+kB06YkwhEZO9Ki/QCOaIMy/yqwp7FPG3r9YmhfcQ8oePo/3\r\nlb2nI80trPs0+eZ5YID+KJFFuVYyOemZD7NJXRJJFEm0GioteIFGmgwHfqG9zF3/\r\nmUCk52k1QDbWrnUUcO0D8T4OiV1kOoaGMP9xe1XDfLScj3CXlXMilg/v/FuZrRtM\r\nrsSTSJPeTL+AHj4jhOYQHuo2qg==\r\n-----END CERTIFICATE-----\r\n', '-----BEGIN PRIVATE KEY-----\r\nMIIEvgIBADANBgkqhkiG9w0BAQEFAASCBKgwggSkAgEAAoIBAQCbjKcHTmOdL78B\r\ncoYNOGNy6ykg7Q6IKesHTCqfCEBZeEW5idiN6I7L0dNAHdKkPmOF1fY3HPCviusb\r\nvWw4bv9Ej7Pzx4+C1s+S91Wk8Rkc9Wf3pcCbeb3fLLJ1lveZ4hA9FRClIOEsVN9Y\r\nlwpHqciJjCuMCMX1n2R4Y9qUHJrYndZilFvde9qm8z2U0JFnifnjse2liAeKdpuq\r\nMu4WBGukIfiWl/llneUoXgSVGnWYvwlTLiX19vcFd2ldhIV/c2HBO3TRCDEGeMkt\r\n9jWfa59Qzxboxfpge6zjkvrPp3ir86j5+Tdhki+JyZDFaET7Knzq1r9q9Z3zg49a\r\nqcmPbHFdAgMBAAECggEBAIH2qdPT7iz2KKvn6RMAqy7oRqvpBTxFccbeH7pSZZmb\r\ngP49qz8eMLkhLlUi1c0/B15aX+a6emrhMgEyakpYi1XYj20+rqyOGE7d8qPmgaoN\r\nbPmgduYweLEQImdXZLchB5pRkF+3sgudOiNFx2QK+q/Z+sR8zBGmRIbGP2mC4Onc\r\n4T3uStAlPuu6KtIzeBocUmr3Vh7o9jGA03fq2NLzp6TU8GL6OLht8Zaqx/0crI8T\r\ngIkgC8OUO7VIWoCYBDc4EYGaK8+tmxQDjTYG56flCmLyEilYdAXzKI3q3knUcd7n\r\nwYpyXODN3yXdH9Ca6L34c0PLPaCfhML4qtosiUJmUQECgYEAx/plDxce6G00PToh\r\n7CMJOLiIl/IRDmYeXrT3yizYXwt5Vj580wcoiV7QLCTA+ycPvcdZucyz0JUEPLeU\r\nKqZje9eWr+0W/C2jkAO5ijpD5bOy5Qw3QiMIMVqQNeAMABgluTvJLM2LRyoRy5G7\r\nTBRnuIW6oUwxT45oYHo5qLDN/sECgYEAxyAED2bE2iv6Kw0WJzK1B7rlof1ksCHB\r\nKLv1VNVEeqEsmZx8xP2nwKDpLCYarrpf3rMtoDinMFMsao61xoaqPxkti3v7hDJA\r\npiaMNwHGnXlG+h8x5+bexXpS8+Py17KG5Qy+2mnczZYTPMpD5Azya58AIBDR7Fzv\r\nxR/Yj57pdZ0CgYAcvnUAMkaTCf9UPaLamj6dFIktrfGdrDf5TPHA8ak4ICIUr26p\r\ntoGxHRu2/KFweDDfCmRvPGksNf8h6xE1AC2Ug2x5ZQ7EuJql/KMSp0VTIv03xwW6\r\nT+bBkU7hL48KBG6HrXxBIFpApF9ib1QIn3Y5I5+rx5Pe541BMNBQ2vkBAQKBgQDG\r\ntK04jU5NhOsdQO7laNV8BEaY0xtCJDz0IDSeVkACu4mdNKrRjWp0cF6e/ttLl5KJ\r\n0nXqV/6G28kMAKNmnAWR99caRTvlXJxk8Tyku7HufRKWEMElcJ7Ho9zZopQ4KOAx\r\n+/kMTe3YfjVuSU1caosTWFSwqvhBDTD7nl7mWycPhQKBgFpux0RnAftUSrKy7G5I\r\n0NVd0BwBu7Y/wjchQ6slK42/9e8IvQtmar0w7URCMBwQLioUyp9XkSQrTDrKHETt\r\nYYi6DN6LGw5iUvprRVtW7zfgwND7Y/cjHN7A54P7kjfBm3AC4dSSpveMEdRpSMVA\r\nwhBlP+u3ennFJYXRh56Pv6K6\r\n-----END PRIVATE KEY-----\r\n');

-- --------------------------------------------------------

--
-- 表的结构 `dance_weixin_applet`
--

CREATE TABLE `dance_weixin_applet` (
  `id` int(11) UNSIGNED NOT NULL,
  `wxname` varchar(60) NOT NULL COMMENT '名称',
  `wxid` varchar(20) NOT NULL DEFAULT '' COMMENT '原始ID',
  `wxnumber` char(20) NOT NULL DEFAULT '' COMMENT '微信号',
  `appid` varchar(50) NOT NULL DEFAULT '',
  `appsecret` varchar(50) NOT NULL DEFAULT '',
  `mchid` varchar(20) NOT NULL DEFAULT '',
  `mchkey` varchar(40) NOT NULL DEFAULT '',
  `headerpic` varchar(255) NOT NULL DEFAULT '' COMMENT '头像地址',
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `ewmurl` varchar(255) NOT NULL DEFAULT '',
  `apiclient_cert` varchar(255) NOT NULL DEFAULT '',
  `apiclient_key` varchar(255) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='微信小程序帐号';

-- --------------------------------------------------------

--
-- 表的结构 `dance_weixin_event`
--

CREATE TABLE `dance_weixin_event` (
  `id` smallint(6) UNSIGNED NOT NULL,
  `uid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `wid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `event_text` varchar(50) NOT NULL DEFAULT '',
  `is_regular` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `event_key` varchar(255) NOT NULL DEFAULT '',
  `event_type` smallint(3) UNSIGNED NOT NULL DEFAULT '0',
  `event_app` smallint(3) UNSIGNED NOT NULL DEFAULT '0',
  `title` varchar(100) NOT NULL DEFAULT '',
  `descrip` varchar(255) NOT NULL DEFAULT '',
  `link` varchar(255) NOT NULL DEFAULT '',
  `picurl` varchar(255) NOT NULL DEFAULT '',
  `is_append_openid` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `isopen` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '是否开启',
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='微信事件';

-- --------------------------------------------------------

--
-- 表的结构 `dance_weixin_firstpush`
--

CREATE TABLE `dance_weixin_firstpush` (
  `id` int(10) UNSIGNED NOT NULL,
  `uid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `wid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `title` varchar(50) NOT NULL DEFAULT '',
  `descrip` varchar(100) NOT NULL DEFAULT '',
  `picurl` varchar(255) NOT NULL DEFAULT '',
  `url` varchar(255) NOT NULL DEFAULT '',
  `vieworder` smallint(3) NOT NULL DEFAULT '0',
  `isopen` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `dance_weixin_firsttext`
--

CREATE TABLE `dance_weixin_firsttext` (
  `id` mediumint(5) UNSIGNED NOT NULL,
  `uid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `wid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `type` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `descrip` text NOT NULL,
  `picurl` varchar(255) NOT NULL DEFAULT '',
  `media_id` varchar(100) NOT NULL DEFAULT '',
  `isopen` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `dance_weixin_menu`
--

CREATE TABLE `dance_weixin_menu` (
  `id` smallint(6) UNSIGNED NOT NULL,
  `wid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `parentid` smallint(6) UNSIGNED NOT NULL DEFAULT '0',
  `event` varchar(30) NOT NULL DEFAULT '',
  `name` varchar(50) NOT NULL DEFAULT '',
  `keyword` varchar(255) NOT NULL DEFAULT '',
  `appid` varchar(40) NOT NULL DEFAULT '',
  `pagepath` varchar(40) NOT NULL DEFAULT '',
  `isopen` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '是否开启',
  `vieworder` smallint(3) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `dance_weixin_menu`
--

INSERT INTO `dance_weixin_menu` (`id`, `wid`, `parentid`, `event`, `name`, `keyword`, `appid`, `pagepath`, `isopen`, `vieworder`) VALUES
(1, 8, 0, '', '商城', '', '', '', 1, 0),
(2, 8, 1, 'view', '商城首页', 'http://xdd.uucms.com/mobmall', '', '', 1, 0),
(3, 8, 0, '', '商家后台', '', '', '', 1, 0),
(4, 8, 3, 'view', '后台管理', 'http://xdd.uucms.com/mobvip/order/index.html', '', '', 1, 0);

-- --------------------------------------------------------

--
-- 表的结构 `dance_weixin_user`
--

CREATE TABLE `dance_weixin_user` (
  `id` int(10) UNSIGNED NOT NULL,
  `wid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `openid` varchar(100) NOT NULL DEFAULT '',
  `nickname` varchar(30) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
  `sex` tinyint(1) NOT NULL DEFAULT '0',
  `city` varchar(20) NOT NULL DEFAULT '',
  `province` varchar(20) NOT NULL DEFAULT '',
  `country` varchar(20) NOT NULL DEFAULT '',
  `headimgurl` varchar(255) NOT NULL DEFAULT '',
  `subscribe_time` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `unionid` varchar(40) NOT NULL DEFAULT '',
  `credit` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `last_login_time` int(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转储表的索引
--

--
-- 表的索引 `dance_aaaa`
--
ALTER TABLE `dance_aaaa`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `dance_admin_log`
--
ALTER TABLE `dance_admin_log`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `dance_admin_user`
--
ALTER TABLE `dance_admin_user`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_username` (`username`);

--
-- 表的索引 `dance_article`
--
ALTER TABLE `dance_article`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `dance_auth_access`
--
ALTER TABLE `dance_auth_access`
  ADD KEY `groupId` (`groupid`);

--
-- 表的索引 `dance_auth_cate`
--
ALTER TABLE `dance_auth_cate`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `dance_auth_group`
--
ALTER TABLE `dance_auth_group`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `dance_auth_rule`
--
ALTER TABLE `dance_auth_rule`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `dance_config`
--
ALTER TABLE `dance_config`
  ADD PRIMARY KEY (`config_name`,`config_space`) USING BTREE;

--
-- 表的索引 `dance_help`
--
ALTER TABLE `dance_help`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `dance_hotline`
--
ALTER TABLE `dance_hotline`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `dance_nav`
--
ALTER TABLE `dance_nav`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `dance_proclock`
--
ALTER TABLE `dance_proclock`
  ADD UNIQUE KEY `uid` (`uid`,`action`);

--
-- 表的索引 `dance_slide`
--
ALTER TABLE `dance_slide`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `dance_user`
--
ALTER TABLE `dance_user`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_username` (`username`);

--
-- 表的索引 `dance_visit`
--
ALTER TABLE `dance_visit`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `dance_weixin_account`
--
ALTER TABLE `dance_weixin_account`
  ADD PRIMARY KEY (`id`),
  ADD KEY `token` (`token`);

--
-- 表的索引 `dance_weixin_applet`
--
ALTER TABLE `dance_weixin_applet`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `dance_weixin_event`
--
ALTER TABLE `dance_weixin_event`
  ADD PRIMARY KEY (`id`),
  ADD KEY `parentid` (`event_text`);

--
-- 表的索引 `dance_weixin_firstpush`
--
ALTER TABLE `dance_weixin_firstpush`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `dance_weixin_firsttext`
--
ALTER TABLE `dance_weixin_firsttext`
  ADD PRIMARY KEY (`id`);

--
-- 表的索引 `dance_weixin_menu`
--
ALTER TABLE `dance_weixin_menu`
  ADD PRIMARY KEY (`id`),
  ADD KEY `parentid` (`parentid`);

--
-- 表的索引 `dance_weixin_user`
--
ALTER TABLE `dance_weixin_user`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_wid_openid` (`wid`,`openid`);

--
-- 在导出的表使用AUTO_INCREMENT
--

--
-- 使用表AUTO_INCREMENT `dance_aaaa`
--
ALTER TABLE `dance_aaaa`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `dance_admin_log`
--
ALTER TABLE `dance_admin_log`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `dance_admin_user`
--
ALTER TABLE `dance_admin_user`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- 使用表AUTO_INCREMENT `dance_article`
--
ALTER TABLE `dance_article`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- 使用表AUTO_INCREMENT `dance_auth_cate`
--
ALTER TABLE `dance_auth_cate`
  MODIFY `id` mediumint(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- 使用表AUTO_INCREMENT `dance_auth_group`
--
ALTER TABLE `dance_auth_group`
  MODIFY `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- 使用表AUTO_INCREMENT `dance_auth_rule`
--
ALTER TABLE `dance_auth_rule`
  MODIFY `id` smallint(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- 使用表AUTO_INCREMENT `dance_help`
--
ALTER TABLE `dance_help`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- 使用表AUTO_INCREMENT `dance_hotline`
--
ALTER TABLE `dance_hotline`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- 使用表AUTO_INCREMENT `dance_nav`
--
ALTER TABLE `dance_nav`
  MODIFY `id` smallint(6) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- 使用表AUTO_INCREMENT `dance_slide`
--
ALTER TABLE `dance_slide`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- 使用表AUTO_INCREMENT `dance_user`
--
ALTER TABLE `dance_user`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `dance_visit`
--
ALTER TABLE `dance_visit`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `dance_weixin_account`
--
ALTER TABLE `dance_weixin_account`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- 使用表AUTO_INCREMENT `dance_weixin_applet`
--
ALTER TABLE `dance_weixin_applet`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `dance_weixin_event`
--
ALTER TABLE `dance_weixin_event`
  MODIFY `id` smallint(6) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `dance_weixin_firstpush`
--
ALTER TABLE `dance_weixin_firstpush`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `dance_weixin_firsttext`
--
ALTER TABLE `dance_weixin_firsttext`
  MODIFY `id` mediumint(5) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- 使用表AUTO_INCREMENT `dance_weixin_menu`
--
ALTER TABLE `dance_weixin_menu`
  MODIFY `id` smallint(6) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- 使用表AUTO_INCREMENT `dance_weixin_user`
--
ALTER TABLE `dance_weixin_user`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;