master

分支 (1)

管理

管理

master

sunphp
/
sunphp.sql

/*
 Navicat Premium Data Transfer

 Source Server         : 127.0.0.1本地开发
 Source Server Type    : MySQL
 Source Server Version : 50726
 Source Host           : 127.0.0.1:3306
 Source Schema         : sunphp

 Target Server Type    : MySQL
 Target Server Version : 50726
 File Encoding         : 65001

 Date: 10/04/2023 16:34:17
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sun_core_account
-- ----------------------------
DROP TABLE IF EXISTS `sun_core_account`;
CREATE TABLE `sun_core_account`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` tinyint(1) NOT NULL COMMENT '平台类型',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '平台名称',
  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '平台头像',
  `appid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'appid',
  `secret` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'secret',
  `level` tinyint(1) DEFAULT NULL COMMENT '公众号级别',
  `end_time` datetime DEFAULT NULL COMMENT '到期时间',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注信息',
  `api_url` varchar(255) NULL COMMENT '消息推送url',
  `api_token` varchar(255) NULL COMMENT '消息推送token',
  `api_key` varchar(255) NULL COMMENT '消息加密密钥',
  `wx_menu` text NULL COMMENT '微信公众号菜单',
  `is_delete` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0正常1回收站2删除',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sun_core_app
-- ----------------------------
DROP TABLE IF EXISTS `sun_core_app`;
CREATE TABLE `sun_core_app`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dir` varchar(50) NOT NULL DEFAULT 'app' COMMENT '模块安装目录' ,
  `identity` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '应用唯一标识',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '应用名称',
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '应用图标',
  `logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '自定义图标',
  `version` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '应用版本',
  `new_version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '扫描本地新版本',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `author` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开发者名称',
  `admin` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '管理后台地址',
  `cover` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '入口地址',
  `type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1框架应用2微擎应用',
  `is_delete` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0正常1回收站2未安装',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `index_i` (`identity`) USING BTREE COMMENT '唯一标识'
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sun_core_bindapp
-- ----------------------------
DROP TABLE IF EXISTS `sun_core_bindapp`;
CREATE TABLE `sun_core_bindapp`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `acid` int(11) NOT NULL COMMENT 'account平台id',
  `sid` int(11) NOT NULL COMMENT 'supports应用分支id',
  `order` int(11) NOT NULL DEFAULT 1 COMMENT '排序大靠前',
  `end_time` datetime DEFAULT NULL COMMENT '绑定app到期时间',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `index_aa`(`acid`, `sid`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for sun_core_create
-- ----------------------------
DROP TABLE IF EXISTS `sun_core_create`;
CREATE TABLE `sun_core_create`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL COMMENT '用户id',
  `wx_gzh` int(11) NOT NULL DEFAULT 0 COMMENT '微信公众号',
  `wx_xcx` int(11) NOT NULL DEFAULT 0 COMMENT '微信小程序',
  `zjtd_xcx` int(11) NOT NULL DEFAULT 0 COMMENT '字节跳动小程序',
  `pc` int(11) NOT NULL DEFAULT 0 COMMENT 'PC网站',
  `app` int(11) NOT NULL DEFAULT 0 COMMENT 'APP应用',
  `zfb_xcx` int(11) NOT NULL DEFAULT 0 COMMENT '支付宝小程序',
  `bd_xcx` int(11) NOT NULL DEFAULT 0 COMMENT '百度小程序',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `index_u`(`uid`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for sun_core_email
-- ----------------------------
DROP TABLE IF EXISTS `sun_core_email`;
CREATE TABLE `sun_core_email`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `acid` int(11) NOT NULL COMMENT '绑定的平台id',
  `email_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发件人名称',
  `email_sender` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发件人邮箱',
  `email_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'smtp授权码',
  `email_smtp` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'smtp服务器',
  `email_sign` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮件末尾签名',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `index_acid`(`acid`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sun_core_menu
-- ----------------------------
DROP TABLE IF EXISTS `sun_core_menu`;
CREATE TABLE `sun_core_menu`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `app_id` int(11) NOT NULL COMMENT 'app应用id',
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '菜单地址',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单标题',
  `do` varchar(255) NULL ,
  `state` varchar(255) NULL ,
  `direct` varchar(255) NULL ,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;


-- ----------------------------
-- Table structure for sun_core_order
-- ----------------------------
DROP TABLE IF EXISTS `sun_core_order`;
CREATE TABLE `sun_core_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` varchar(50) NOT NULL COMMENT '系统订单out_trade_no',
  `tid` varchar(255) NOT NULL COMMENT '模块订单号',
  `money` decimal(10,2) NOT NULL COMMENT '订单金额',
  `title` varchar(255) NOT NULL COMMENT '订单标题',
  `module` varchar(255) NOT NULL COMMENT '模块标识',
  `acid` int(11) NOT NULL COMMENT '平台id',
  `pay_acid` int(11) NOT NULL COMMENT '实际使用支付配置平台id',
  `pay_method` varchar(50) NOT NULL COMMENT '支付方式wechat/alipay/unipay',
  `type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0待回调1支付回调成功',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `index_o` (`order_id`) USING HASH
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;


-- ----------------------------
-- Table structure for sun_core_pay
-- ----------------------------
DROP TABLE IF EXISTS `sun_core_pay`;
CREATE TABLE `sun_core_pay` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `acid` int(11) NOT NULL COMMENT '绑定的平台id',
  `wx_mchid` varchar(50) DEFAULT NULL COMMENT '微信商户号',
  `wx_apikey` varchar(255) DEFAULT NULL COMMENT '微信支付api秘钥V3',
  `wx_cert` varchar(255) DEFAULT NULL COMMENT '微信商户私钥证书',
  `wx_public_cert` varchar(255) DEFAULT NULL COMMENT '微信商户公钥证书',
  `wechat_public_cert` varchar(255) DEFAULT NULL COMMENT '微信平台公钥证书',
  `wx_switch` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1启用0关闭',
  `ali_switch` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1启用0关闭',
  `ali_appid` varchar(50) DEFAULT NULL COMMENT '支付宝应用id',
  `ali_appkey` text COMMENT '支付宝应用私钥',
  `ali_app_cert` varchar(255) DEFAULT NULL COMMENT '支付宝应用私钥证书',
  `ali_public_cert` varchar(255) DEFAULT NULL COMMENT '支付宝公钥证书',
  `ali_root_cert` varchar(255) DEFAULT NULL COMMENT '支付宝根证书',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `index_acid` (`acid`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT = 1 DEFAULT CHARSET=utf8mb4;


DROP TABLE IF EXISTS `sun_core_member`;
CREATE TABLE `sun_core_member` (
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  `uniacid` int(11) NOT NULL,
  `openid` varchar(50) NOT NULL,
  `unionid` varchar(50) DEFAULT NULL,
  `nickname` varchar(50) DEFAULT NULL,
  `avatar` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `salt` varchar(50) DEFAULT NULL,
  `mobile` varchar(50) DEFAULT NULL COMMENT '手机号',
  `email` varchar(50) DEFAULT NULL,
  `credit1` decimal(10,2) DEFAULT NULL COMMENT '积分',
  `credit2` decimal(10,2) DEFAULT NULL COMMENT '余额',
  `credit3` decimal(10,2) DEFAULT NULL COMMENT '自定义',
  `credit4` decimal(10,2) DEFAULT NULL COMMENT '自定义',
  `credit5` decimal(10,2) DEFAULT NULL COMMENT '自定义',
  `credit6` decimal(10,2) DEFAULT NULL COMMENT '自定义',
  `realname` varchar(50) DEFAULT NULL COMMENT '真是姓名',
  `idcard` varchar(30) DEFAULT NULL COMMENT '身份证号码',
  `gender` tinyint(1) DEFAULT NULL COMMENT '1男；2女',
  `birthday` datetime DEFAULT NULL COMMENT '生日',
  `address` varchar(255) DEFAULT NULL COMMENT '地址',
  `alipay` varchar(50) DEFAULT NULL COMMENT '支付宝',
  `wechat` varchar(50) DEFAULT NULL COMMENT '微信号',
  `qq` varchar(50) DEFAULT NULL COMMENT 'QQ号',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`uid`),
  KEY `index_o` (`openid`) USING HASH,
  KEY `index_m` (`mobile`) USING BTREE,
  KEY `index_e` (`email`) USING HASH,
  KEY `index_u` (`unionid`) USING HASH
) ENGINE=InnoDB AUTO_INCREMENT = 1 DEFAULT CHARSET=utf8mb4;


DROP TABLE IF EXISTS `sun_core_attachment`;
CREATE TABLE `sun_core_attachment` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uniacid` int(11) unsigned NOT NULL,
  `uid` int(11) unsigned NOT NULL,
  `filename` varchar(255) NOT NULL,
  `attachment` varchar(255) NOT NULL,
  `type` tinyint(1) unsigned NOT NULL,
  `createtime` int(11) unsigned NOT NULL,
  `module_upload_dir` varchar(100) DEFAULT NULL,
  `group_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT = 1  DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `sun_core_cache`;
CREATE TABLE `sun_core_cache` (
  `key` varchar(100) NOT NULL,
  `value` text,
  PRIMARY KEY (`key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;


-- ----------------------------
-- Table structure for sun_core_sms
-- ----------------------------
DROP TABLE IF EXISTS `sun_core_sms`;
CREATE TABLE `sun_core_sms`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `acid` int(11) NOT NULL COMMENT '绑定的平台id',
  `type` tinyint(1) NULL DEFAULT NULL COMMENT '短信类型，默认关闭',
  `ali_sms` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '阿里云短信',
  `tencent_sms` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '腾讯云短信',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `index_acid`(`acid`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sun_core_storage
-- ----------------------------
DROP TABLE IF EXISTS `sun_core_storage`;
CREATE TABLE `sun_core_storage`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `acid` int(11) NOT NULL COMMENT '绑定的平台id',
  `type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '存储类型，默认本地',
  `ali_oss` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '阿里云',
  `tencent_cos` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '腾讯云',
  `qiniu` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '七牛云',
  `censor` text NULL COMMENT '内容安全配置',
  `suffix` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '后缀名称限制',
  `img_size` int(11) NOT NULL DEFAULT 5000 COMMENT '图片大小限制',
  `video_size` int(11) NOT NULL DEFAULT 5000 COMMENT '音视频大小限制',
  `file_size` int(11) NOT NULL DEFAULT 5000 COMMENT '文件大小限制',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `index_acid`(`acid`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sun_core_supports
-- ----------------------------
DROP TABLE IF EXISTS `sun_core_supports`;
CREATE TABLE `sun_core_supports`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `app_id` int(11) NOT NULL COMMENT '应用id',
  `type` tinyint(1) NOT NULL COMMENT '支持的平台类型',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `index_at`(`app_id`, `type`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for sun_core_system
-- ----------------------------
DROP TABLE IF EXISTS `sun_core_system`;
CREATE TABLE `sun_core_system`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sys_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '系统名称',
  `sys_logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '系统logo',
  `sys_version` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '系统版本',
  `sys_domain` varchar(255) DEFAULT NULL COMMENT '安装域名',
  `sys_type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1普通2会员',
  `sys_mall` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1显示市场2隐藏',
  `sys_upgrade` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1显示升级2隐藏',
  `activate_key` varchar(255) DEFAULT NULL COMMENT '高级版激活秘钥',
  `sys_secret` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '系统密钥',
  `sys_sign` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '系统签名',
  `register` tinyint(1) NOT NULL DEFAULT 0 COMMENT '能否注册，默认0禁止',
  `check` tinyint(1) NOT NULL DEFAULT 1 COMMENT '注册审核，默认1审核',
  `bind_phone` tinyint(1) NOT NULL DEFAULT 0 COMMENT '默认0不绑定，1绑定',
  `record_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备案号',
  `record_security` varchar(255) NULL COMMENT '公安备案号',
  `record_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备案公司名称',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sun_core_useaccount
-- ----------------------------
DROP TABLE IF EXISTS `sun_core_useaccount`;
CREATE TABLE `sun_core_useaccount`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL COMMENT '用户id',
  `acid` int(11) NOT NULL COMMENT '平台id',
  `role` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1操作员2平台所有者',
  `order` int(11) NOT NULL DEFAULT 1 COMMENT '排序大靠前',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `index_ua`(`uid`, `acid`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for sun_core_useapp
-- ----------------------------
DROP TABLE IF EXISTS `sun_core_useapp`;
CREATE TABLE `sun_core_useapp`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL COMMENT '用户id',
  `sid` int(11) NOT NULL COMMENT 'app支持类型id',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `index_us`(`uid`, `sid`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for sun_core_user
-- ----------------------------
DROP TABLE IF EXISTS `sun_core_user`;
CREATE TABLE `sun_core_user`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `session_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '临时访问id',
  `type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1用户2管理员',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '昵称',
  `pwd` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密码',
  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '头像',
  `phone` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号',
  `wechat` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '微信号',
  `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮箱',
  `ip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '登录ip',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户备注信息',
  `is_delete` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0正常1回收站2待审核',
  `login_time` datetime DEFAULT NULL COMMENT '上次登录时间',
  `end_time` datetime DEFAULT NULL COMMENT '到期时间',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `index_s`(`session_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for sun_core_usermenu
-- ----------------------------
DROP TABLE IF EXISTS `sun_core_usermenu`;
CREATE TABLE `sun_core_usermenu`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uaid` int(11) NOT NULL COMMENT '使用平台表id',
  `menu_id` int(11) NOT NULL COMMENT '应用菜单id',
  `can_use` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1可用0禁止',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `index_um`(`uaid`, `menu_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Fixed;

SET FOREIGN_KEY_CHECKS = 1;