212 lines
12 KiB
SQL
Executable File
212 lines
12 KiB
SQL
Executable File
ALTER TABLE ls_admin RENAME TO la_admin;
|
||
ALTER TABLE ls_admin_session RENAME TO la_admin_session;
|
||
ALTER TABLE ls_config RENAME TO la_config;
|
||
ALTER TABLE ls_dept RENAME TO la_dept;
|
||
ALTER TABLE ls_dict_data RENAME TO la_dict_data;
|
||
ALTER TABLE ls_dict_type RENAME TO la_dict_type;
|
||
ALTER TABLE ls_file RENAME TO la_file;
|
||
ALTER TABLE ls_file_cate RENAME TO la_file_cate;
|
||
ALTER TABLE ls_generate_column RENAME TO la_generate_column;
|
||
ALTER TABLE ls_generate_table RENAME TO la_generate_table;
|
||
ALTER TABLE ls_jobs RENAME TO la_jobs;
|
||
ALTER TABLE ls_operation_log RENAME TO la_operation_log;
|
||
ALTER TABLE ls_role RENAME TO la_system_role;
|
||
ALTER TABLE ls_system_menu RENAME TO la_system_menu;
|
||
ALTER TABLE ls_system_role_menu RENAME TO la_system_role_menu;
|
||
|
||
|
||
SET FOREIGN_KEY_CHECKS=0;
|
||
|
||
CREATE TABLE `la_article` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '文章id',
|
||
`cid` int(11) NOT NULL COMMENT '文章分类',
|
||
`title` varchar(255) NOT NULL COMMENT '文章标题',
|
||
`desc` varchar(255) NULL DEFAULT '' COMMENT '简介',
|
||
`abstract` text NULL COMMENT '文章摘要',
|
||
`image` varchar(128) NULL DEFAULT NULL COMMENT '文章图片',
|
||
`author` varchar(255) NULL DEFAULT '' COMMENT '作者',
|
||
`content` text 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 COMMENT = '文章表' ROW_FORMAT = Dynamic;
|
||
|
||
CREATE TABLE `la_article_cate` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '文章分类id',
|
||
`name` varchar(90) 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 COMMENT = '文章分类表' ROW_FORMAT = Dynamic;
|
||
|
||
CREATE TABLE `la_article_collect` (
|
||
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`user_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户ID',
|
||
`article_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '文章ID',
|
||
`status` 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 '更新时间',
|
||
`delete_time` int(10) NULL DEFAULT NULL COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB COMMENT = '文章收藏表' ROW_FORMAT = Dynamic;
|
||
|
||
CREATE TABLE `la_decorate_page` (
|
||
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`type` tinyint(2) UNSIGNED NOT NULL DEFAULT 10 COMMENT '页面类型',
|
||
`name` varchar(100) NOT NULL DEFAULT '' COMMENT '页面名称',
|
||
`data` text 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 COMMENT = '装修页面配置表' ROW_FORMAT = Dynamic;
|
||
|
||
CREATE TABLE `la_decorate_tabbar` (
|
||
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`name` varchar(20) NOT NULL DEFAULT '' COMMENT '导航名称',
|
||
`selected` varchar(200) NOT NULL DEFAULT '' COMMENT '未选图标',
|
||
`unselected` varchar(200) NOT NULL DEFAULT '' COMMENT '已选图标',
|
||
`link` varchar(200) NULL DEFAULT NULL 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 COMMENT = '装修底部导航表' ROW_FORMAT = Dynamic;
|
||
|
||
ALTER TABLE `la_file` ADD COLUMN `source_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '上传者id' AFTER `cid`;
|
||
|
||
ALTER TABLE `la_file` ADD COLUMN `source` tinyint(1) NOT NULL DEFAULT 0 COMMENT '来源类型[0-后台,1-用户]' AFTER `source_id`;
|
||
|
||
ALTER TABLE `la_file` DROP COLUMN `user_id`;
|
||
|
||
CREATE TABLE `la_hot_search` (
|
||
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`name` varchar(200) NOT NULL DEFAULT '' COMMENT '关键词',
|
||
`sort` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序号',
|
||
`create_time` int(10) NULL DEFAULT NULL COMMENT '创建时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB COMMENT = '热门搜索表' ROW_FORMAT = Dynamic;
|
||
|
||
CREATE TABLE `la_notice_record` (
|
||
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`user_id` int(10) UNSIGNED NOT NULL COMMENT '用户id',
|
||
`title` varchar(50) NOT NULL DEFAULT '' COMMENT '标题',
|
||
`content` text 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) 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 COMMENT = '通知记录表' ROW_FORMAT = Dynamic;
|
||
|
||
CREATE TABLE `la_notice_setting` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`scene_id` int(10) NOT NULL COMMENT '场景id',
|
||
`scene_name` varchar(255) NOT NULL DEFAULT '' COMMENT '场景名称',
|
||
`scene_desc` varchar(255) 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 NULL COMMENT '系统通知设置',
|
||
`sms_notice` text NULL COMMENT '短信通知设置',
|
||
`oa_notice` text NULL COMMENT '公众号通知设置',
|
||
`mnp_notice` text NULL COMMENT '小程序通知设置',
|
||
`support` char(10) NOT NULL DEFAULT '' COMMENT '支持的发送类型 1-系统通知 2-短信通知 3-微信模板消息 4-小程序提醒',
|
||
`update_time` int(10) NULL DEFAULT NULL COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB COMMENT = '通知设置表' ROW_FORMAT = Dynamic;
|
||
|
||
CREATE TABLE `la_official_account_reply` (
|
||
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`name` varchar(64) NOT NULL DEFAULT '' COMMENT '规则名称',
|
||
`keyword` varchar(64) NOT NULL DEFAULT '' COMMENT '关键词',
|
||
`reply_type` tinyint(1) NOT NULL COMMENT '回复类型 1-关注回复 2-关键字回复 3-默认回复',
|
||
`matching_type` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '匹配方式：1-全匹配；2-模糊匹配',
|
||
`content_type` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '内容类型：1-文本',
|
||
`content` text NOT NULL COMMENT '回复内容',
|
||
`status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '启动状态：1-启动；0-关闭',
|
||
`sort` int(11) UNSIGNED NOT NULL DEFAULT 50 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 COMMENT = '公众号消息回调表' ROW_FORMAT = Dynamic;
|
||
|
||
CREATE TABLE `la_sms_log` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
`scene_id` int(11) NOT NULL COMMENT '场景id',
|
||
`mobile` varchar(11) NOT NULL COMMENT '手机号码',
|
||
`content` varchar(255) NOT NULL COMMENT '发送内容',
|
||
`code` varchar(32) NULL DEFAULT NULL COMMENT '发送关键字（注册、找回密码）',
|
||
`is_verify` tinyint(1) NULL DEFAULT 0 COMMENT '是否已验证；0-否；1-是',
|
||
`check_num` int(5) NULL DEFAULT 0 COMMENT '验证次数',
|
||
`send_status` tinyint(1) NOT NULL COMMENT '发送状态：0-发送中；1-发送成功；2-发送失败',
|
||
`send_time` int(10) NOT NULL COMMENT '发送时间',
|
||
`results` text 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 COMMENT = '短信记录表' ROW_FORMAT = Dynamic;
|
||
|
||
ALTER TABLE `la_system_menu` COMMENT = '系统菜单表';
|
||
|
||
CREATE TABLE `la_user` (
|
||
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`sn` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '编号',
|
||
`avatar` varchar(200) NOT NULL DEFAULT '' COMMENT '头像',
|
||
`real_name` varchar(32) NOT NULL DEFAULT '' COMMENT '真实姓名',
|
||
`nickname` varchar(32) NOT NULL DEFAULT '' COMMENT '用户昵称',
|
||
`account` varchar(32) NOT NULL DEFAULT '' COMMENT '用户账号',
|
||
`password` varchar(32) NOT NULL DEFAULT '' COMMENT '用户密码',
|
||
`mobile` varchar(32) 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(30) NOT NULL DEFAULT '' COMMENT '最后登录IP',
|
||
`login_time` int(10) UNSIGNED NOT NULL DEFAULT 0 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 COMMENT = '用户表' ROW_FORMAT = Dynamic;
|
||
|
||
CREATE TABLE `la_user_auth` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(11) NOT NULL COMMENT '用户id',
|
||
`openid` varchar(255) NOT NULL COMMENT '微信openid',
|
||
`unionid` varchar(255) 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 COMMENT = '用户授权表' ROW_FORMAT = Dynamic;
|
||
|
||
CREATE TABLE `la_user_session` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`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) 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 COMMENT = '用户会话表' ROW_FORMAT = Dynamic;
|
||
|
||
SET FOREIGN_KEY_CHECKS=1;
|
||
|