lywsvip/likeadmin_php_saas
1
0
Fork 0
mirror of https://gitee.com/likeadmin/likeadmin_php_saas.git synced 2026-09-06 06:48:00 +08:00
Code Issues Packages Projects Releases Wiki Activity
Files
develop
likeadmin_php_saas/server/app/platformapi/db/tenant.sql
dong-yifan9 ec12532eb6 feat: 租户允许分表策略
2024-10-05 21:18:33 +08:00

455 lines
38 KiB
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
/*
Target Server Type : MySQL
Target Server Version : 50729 (5.7.29)
File Encoding : 65001
Date: 01/10/2024 14:18:29
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for la_tenant_admin
-- ----------------------------
DROP TABLE IF EXISTS `la_tenant_admin_{tenantSn}`;
CREATE TABLE `la_tenant_admin_{tenantSn}` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`tenant_id` int(10) NOT NULL COMMENT '租户ID',
`root` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否超级管理员 0-否 1-是',
`name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '名称',
`avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户头像',
`account` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '账号',
`password` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密码',
`login_time` int(10) NULL DEFAULT NULL COMMENT '最后登录时间',
`login_ip` varchar(39) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '最后登录ip',
`multipoint_login` tinyint(1) UNSIGNED NULL DEFAULT 1 COMMENT '是否支持多处登录：1-是；0-否；',
`disable` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT '是否禁用：0-否；1-是；',
`create_time` int(10) NOT NULL COMMENT '创建时间',
`update_time` int(10) NULL DEFAULT NULL COMMENT '修改时间',
`delete_time` int(10) NULL DEFAULT NULL COMMENT '删除时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '租户管理员表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for la_tenant_admin_dept
-- ----------------------------
DROP TABLE IF EXISTS `la_tenant_admin_dept_{tenantSn}`;
CREATE TABLE `la_tenant_admin_dept_{tenantSn}` (
`admin_id` int(10) NOT NULL DEFAULT 0 COMMENT '管理员id',
`dept_id` int(10) NOT NULL DEFAULT 0 COMMENT '部门id',
PRIMARY KEY (`admin_id`, `dept_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '部门关联表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for la_tenant_admin_jobs
-- ----------------------------
DROP TABLE IF EXISTS `la_tenant_admin_jobs_{tenantSn}`;
CREATE TABLE `la_tenant_admin_jobs_{tenantSn}` (
`admin_id` int(10) NOT NULL COMMENT '管理员id',
`jobs_id` int(10) NOT NULL COMMENT '岗位id',
PRIMARY KEY (`admin_id`, `jobs_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '岗位关联表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for la_tenant_admin_role
-- ----------------------------
DROP TABLE IF EXISTS `la_tenant_admin_role_{tenantSn}`;
CREATE TABLE `la_tenant_admin_role_{tenantSn}` (
`admin_id` int(10) NOT NULL COMMENT '管理员id',
`role_id` int(10) NOT NULL COMMENT '角色id',
PRIMARY KEY (`admin_id`, `role_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色关联表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for la_tenant_admin_session
-- ----------------------------
DROP TABLE IF EXISTS `la_tenant_admin_session_{tenantSn}`;
CREATE TABLE `la_tenant_admin_session_{tenantSn}` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`admin_id` int(11) UNSIGNED NOT NULL COMMENT '租户id',
`terminal` tinyint(1) NOT NULL DEFAULT 1 COMMENT '客户端类型：1-pc管理后台 2-mobile手机管理后台',
`token` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '令牌',
`update_time` int(10) NULL DEFAULT NULL COMMENT '更新时间',
`expire_time` int(10) NOT NULL COMMENT '到期时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `admin_id_client`(`admin_id`, `terminal`) USING BTREE COMMENT '一个用户在一个终端只有一个token',
UNIQUE INDEX `token`(`token`) USING BTREE COMMENT 'token是唯一的'
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '管理员会话表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for la_tenant_config
-- ----------------------------
DROP TABLE IF EXISTS `la_tenant_config_{tenantSn}`;
CREATE TABLE `la_tenant_config_{tenantSn}` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`tenant_id` int(11) NOT NULL COMMENT '租户ID',
`type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '类型',
`name` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '名称',
`value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '值',
`create_time` int(10) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` int(10) NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '配置表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for la_tenant_dept
-- ----------------------------
DROP TABLE IF EXISTS `la_tenant_dept_{tenantSn}`;
CREATE TABLE `la_tenant_dept_{tenantSn}` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
`tenant_id` int(11) NOT NULL COMMENT '租户ID',
`name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '部门名称',
`pid` bigint(20) NOT NULL DEFAULT 0 COMMENT '上级部门id',
`sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序',
`leader` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '负责人',
`mobile` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系电话',
`status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '部门状态（0停用 1正常）',
`create_time` int(10) NOT NULL COMMENT '创建时间',
`update_time` int(10) NULL DEFAULT NULL COMMENT '修改时间',
`delete_time` int(10) NULL DEFAULT NULL COMMENT '删除时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '租户部门表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for la_tenant_file
-- ----------------------------
DROP TABLE IF EXISTS `la_tenant_file_{tenantSn}`;
CREATE TABLE `la_tenant_file_{tenantSn}` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`tenant_id` int(11) NOT NULL COMMENT '租户ID',
`cid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '类目ID',
`source_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '上传者id',
`source` tinyint(1) NOT NULL DEFAULT 0 COMMENT '来源类型[0-后台,1-用户]',
`type` tinyint(2) UNSIGNED NOT NULL DEFAULT 10 COMMENT '类型[10=图片, 20=视频]',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '文件名称',
`uri` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文件路径',
`create_time` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '创建时间',
`update_time` int(10) NULL DEFAULT NULL COMMENT '更新时间',
`delete_time` int(10) NULL DEFAULT NULL COMMENT '删除时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '文件表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for la_tenant_file_cate
-- ----------------------------
DROP TABLE IF EXISTS `la_tenant_file_cate_{tenantSn}`;
CREATE TABLE `la_tenant_file_cate_{tenantSn}` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`tenant_id` int(11) NOT NULL COMMENT '租户ID',
`pid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '父级ID',
`type` tinyint(2) UNSIGNED NOT NULL DEFAULT 10 COMMENT '类型[10=图片，20=视频，30=文件]',
`name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '分类名称',
`create_time` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '创建时间',
`update_time` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '更新时间',
`delete_time` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '删除时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '文件分类表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for la_tenant_jobs
-- ----------------------------
DROP TABLE IF EXISTS `la_tenant_jobs_{tenantSn}`;
CREATE TABLE `la_tenant_jobs_{tenantSn}` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
`tenant_id` int(11) NOT NULL COMMENT '租户ID',
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '岗位名称',
`code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '岗位编码',
`sort` int(11) NULL DEFAULT 0 COMMENT '显示顺序',
`status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态（0停用 1正常）',
`remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
`create_time` int(10) NOT NULL COMMENT '创建时间',
`update_time` int(10) NULL DEFAULT NULL COMMENT '修改时间',
`delete_time` int(10) NULL DEFAULT NULL COMMENT '删除时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '岗位表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for la_tenant_notice_record
-- ----------------------------
DROP TABLE IF EXISTS `la_tenant_notice_record_{tenantSn}`;
CREATE TABLE `la_tenant_notice_record_{tenantSn}` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
`tenant_id` int(11) NOT NULL COMMENT '租户ID',
`user_id` int(10) UNSIGNED NOT NULL COMMENT '用户id',
`title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '标题',
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '内容',
`scene_id` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '场景',
`read` tinyint(1) NULL DEFAULT 0 COMMENT '已读状态;0-未读,1-已读',
`recipient` tinyint(1) NULL DEFAULT 0 COMMENT '通知接收对象类型;1-会员;2-商家;3-平台;4-游客(未注册用户)',
`send_type` tinyint(1) NULL DEFAULT 0 COMMENT '通知发送类型 1-系统通知 2-短信通知 3-微信模板 4-微信小程序',
`notice_type` tinyint(1) NULL DEFAULT NULL COMMENT '通知类型 1-业务通知 2-验证码',
`extra` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '其他',
`create_time` int(10) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` int(10) NULL DEFAULT NULL COMMENT '更新时间',
`delete_time` int(10) NULL DEFAULT NULL COMMENT '删除时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '通知记录表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for la_tenant_notice_setting
-- ----------------------------
DROP TABLE IF EXISTS `la_tenant_notice_setting_{tenantSn}`;
CREATE TABLE `la_tenant_notice_setting_{tenantSn}` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`tenant_id` int(11) NOT NULL COMMENT '租户ID',
`scene_id` int(10) NOT NULL COMMENT '场景id',
`scene_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '场景名称',
`scene_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '场景描述',
`recipient` tinyint(1) NOT NULL DEFAULT 1 COMMENT '接收者 1-用户 2-平台',
`type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '通知类型: 1-业务通知 2-验证码',
`system_notice` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '系统通知设置',
`sms_notice` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '短信通知设置',
`oa_notice` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '公众号通知设置',
`mnp_notice` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '小程序通知设置',
`support` char(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '支持的发送类型 1-系统通知 2-短信通知 3-微信模板消息 4-小程序提醒',
`update_time` int(10) NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '通知设置表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for la_tenant_pay_config
-- ----------------------------
DROP TABLE IF EXISTS `la_tenant_pay_config_{tenantSn}`;
CREATE TABLE `la_tenant_pay_config_{tenantSn}` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`tenant_id` int(11) NOT NULL COMMENT '租户ID',
`name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '模版名称',
`pay_way` tinyint(1) NOT NULL COMMENT '支付方式:1-余额支付;2-微信支付;3-支付宝支付;',
`config` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '对应支付配置(json字符串)',
`icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图标',
`sort` int(5) NULL DEFAULT NULL COMMENT '排序',
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '支付配置表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for la_tenant_pay_way
-- ----------------------------
DROP TABLE IF EXISTS `la_tenant_pay_way_{tenantSn}`;
CREATE TABLE `la_tenant_pay_way_{tenantSn}` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`tenant_id` int(11) NOT NULL COMMENT '租户ID',
`pay_config_id` int(11) NOT NULL COMMENT '支付配置ID',
`scene` tinyint(1) NOT NULL COMMENT '场景:1-微信小程序;2-微信公众号;3-H5;4-PC;5-APP;',
`is_default` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否默认支付:0-否;1-是;',
`status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态:0-关闭;1-开启;',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '支付方式表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for la_tenant_system_menu
-- ----------------------------
DROP TABLE IF EXISTS `la_tenant_system_menu_{tenantSn}`;
CREATE TABLE `la_tenant_system_menu_{tenantSn}` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
`tenant_id` int(11) NOT NULL COMMENT '租户ID',
`pid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '上级菜单',
`type` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '权限类型: M=目录，C=菜单，A=按钮',
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '菜单名称',
`icon` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '菜单图标',
`sort` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT '菜单排序',
`perms` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '权限标识',
`paths` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '路由地址',
`component` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '前端组件',
`selected` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '选中路径',
`params` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '路由参数',
`is_cache` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否缓存: 0=否, 1=是',
`is_show` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否显示: 0=否, 1=是',
`is_disable` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否禁用: 0=否, 1=是',
`create_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 301 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统菜单表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for la_tenant_system_role
-- ----------------------------
DROP TABLE IF EXISTS `la_tenant_system_role_{tenantSn}`;
CREATE TABLE `la_tenant_system_role_{tenantSn}` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`tenant_id` int(11) NOT NULL COMMENT '租户ID',
`name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '名称',
`desc` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '描述',
`sort` int(11) NULL DEFAULT 0 COMMENT '排序',
`create_time` int(10) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` int(10) NULL DEFAULT NULL COMMENT '更新时间',
`delete_time` int(10) NULL DEFAULT NULL COMMENT '删除时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for la_tenant_system_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `la_tenant_system_role_menu_{tenantSn}`;
CREATE TABLE `la_tenant_system_role_menu_{tenantSn}` (
`role_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '角色ID',
`menu_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '菜单ID',
PRIMARY KEY (`role_id`, `menu_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色菜单关系表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for la_user
-- ----------------------------
DROP TABLE IF EXISTS `la_user_{tenantSn}`;
CREATE TABLE `la_user_{tenantSn}` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
`tenant_id` int(11) NOT NULL COMMENT '租户ID',
`sn` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '编号',
`avatar` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '头像',
`real_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '真实姓名',
`nickname` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户昵称',
`account` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户账号',
`password` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户密码',
`mobile` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户电话',
`sex` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户性别: [1=男, 2=女]',
`channel` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '注册渠道: [1-微信小程序 2-微信公众号 3-手机H5 4-电脑PC 5-苹果APP 6-安卓APP]',
`is_disable` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否禁用: [0=否, 1=是]',
`login_ip` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '最后登录IP',
`login_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '最后登录时间',
`is_new_user` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否是新注册用户: [1-是, 0-否]',
`user_money` decimal(10, 2) UNSIGNED NULL DEFAULT 0.00 COMMENT '用户余额',
`total_recharge_amount` decimal(10, 2) UNSIGNED NULL DEFAULT 0.00 COMMENT '累计充值',
`create_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',
`delete_time` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '删除时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `sn`(`sn`) USING BTREE COMMENT '编号唯一',
UNIQUE INDEX `account`(`account`) USING BTREE COMMENT '账号唯一'
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for la_user_account_log
-- ----------------------------
DROP TABLE IF EXISTS `la_user_account_log_{tenantSn}`;
CREATE TABLE `la_user_account_log_{tenantSn}` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`tenant_id` int(11) NOT NULL COMMENT '租户ID',
`sn` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '流水号',
`user_id` int(11) NOT NULL COMMENT '用户id',
`change_object` tinyint(1) NOT NULL DEFAULT 0 COMMENT '变动对象',
`change_type` smallint(5) NOT NULL COMMENT '变动类型',
`action` tinyint(1) NOT NULL DEFAULT 0 COMMENT '动作 1-增加 2-减少',
`change_amount` decimal(10, 2) NOT NULL COMMENT '变动数量',
`left_amount` decimal(10, 2) NOT NULL DEFAULT 100.00 COMMENT '变动后数量',
`source_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关联单号',
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '备注',
`extra` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '预留扩展字段',
`create_time` int(10) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` int(10) NULL DEFAULT NULL COMMENT '更新时间',
`delete_time` int(10) NULL DEFAULT NULL COMMENT '删除时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户账户变动记录表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for la_user_auth
-- ----------------------------
DROP TABLE IF EXISTS `la_user_auth_{tenantSn}`;
CREATE TABLE `la_user_auth_{tenantSn}` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`tenant_id` int(11) NOT NULL COMMENT '租户ID',
`user_id` int(11) NOT NULL COMMENT '用户id',
`openid` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '微信openid',
`unionid` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '微信unionid',
`terminal` tinyint(1) NOT NULL DEFAULT 1 COMMENT '客户端类型：1-微信小程序；2-微信公众号；3-手机H5；4-电脑PC；5-苹果APP；6-安卓APP',
`create_time` int(10) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` int(10) NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `openid`(`openid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户授权表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for la_user_session
-- ----------------------------
DROP TABLE IF EXISTS `la_user_session_{tenantSn}`;
CREATE TABLE `la_user_session_{tenantSn}` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`tenant_id` int(11) NOT NULL COMMENT '租户ID',
`user_id` int(11) NOT NULL COMMENT '用户id',
`terminal` tinyint(1) NOT NULL DEFAULT 1 COMMENT '客户端类型：1-微信小程序；2-微信公众号；3-手机H5；4-电脑PC；5-苹果APP；6-安卓APP',
`token` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '令牌',
`update_time` int(10) NULL DEFAULT NULL COMMENT '更新时间',
`expire_time` int(10) NOT NULL COMMENT '到期时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `admin_id_client`(`user_id`, `terminal`) USING BTREE COMMENT '一个用户在一个终端只有一个token',
UNIQUE INDEX `token`(`token`) USING BTREE COMMENT 'token是唯一的'
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户会话表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for la_article
-- ----------------------------
DROP TABLE IF EXISTS `la_article_{tenantSn}`;
CREATE TABLE `la_article_{tenantSn}` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '文章id',
`tenant_id` int(11) NOT NULL COMMENT '租户ID',
`cid` int(11) NOT NULL COMMENT '文章分类',
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文章标题',
`desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '简介',
`abstract` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '文章摘要',
`image` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文章图片',
`author` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '作者',
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '文章内容',
`click_virtual` int(10) NULL DEFAULT 0 COMMENT '虚拟浏览量',
`click_actual` int(11) NULL DEFAULT 0 COMMENT '实际浏览量',
`is_show` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否显示:1-是.0-否',
`sort` int(5) NULL DEFAULT 0 COMMENT '排序',
`create_time` int(11) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` int(11) NULL DEFAULT NULL COMMENT '更新时间',
`delete_time` int(11) NULL DEFAULT NULL COMMENT '删除时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '文章表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for la_article_cate
-- ----------------------------
DROP TABLE IF EXISTS `la_article_cate_{tenantSn}`;
CREATE TABLE `la_article_cate_{tenantSn}` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '文章分类id',
`tenant_id` int(11) NOT NULL COMMENT '租户ID',
`name` varchar(90) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '分类名称',
`sort` int(11) NULL DEFAULT 0 COMMENT '排序',
`is_show` tinyint(1) NULL DEFAULT 1 COMMENT '是否显示:1-是;0-否',
`create_time` int(10) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` int(10) NULL DEFAULT NULL COMMENT '更新时间',
`delete_time` int(10) NULL DEFAULT NULL COMMENT '删除时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '文章分类表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for la_decorate_page_copy1
-- ----------------------------
DROP TABLE IF EXISTS `la_decorate_page_{tenantSn}`;
CREATE TABLE `la_decorate_page_{tenantSn}` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
`tenant_id` int(10) NOT NULL COMMENT '租户ID',
`type` tinyint(2) UNSIGNED NOT NULL DEFAULT 10 COMMENT '页面类型 1=商城首页, 2=个人中心, 3=客服设置 4-PC首页',
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '页面名称',
`data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '页面数据',
`meta` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '页面设置',
`create_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(10) UNSIGNED NOT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 46 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '装修页面配置表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for la_decorate_tabbar
-- ----------------------------
DROP TABLE IF EXISTS `la_decorate_tabbar_{tenantSn}`;
CREATE TABLE `la_decorate_tabbar_{tenantSn}` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
`tenant_id` int(10) NOT NULL COMMENT '租户ID',
`name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '导航名称',
`selected` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '未选图标',
`unselected` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '已选图标',
`link` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '链接地址',
`is_show` tinyint(255) UNSIGNED NOT NULL DEFAULT 1 COMMENT '显示状态',
`create_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 28 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '装修底部导航表' ROW_FORMAT = DYNAMIC;
SET FOREIGN_KEY_CHECKS = 1;
Reference in New Issue View Git Blame Copy Permalink