mirror of
https://gitee.com/likeadmin/likeadmin_php_saas.git
synced 2026-09-06 14:59:19 +08:00
2119 lines
154 KiB
PL/PgSQL
2119 lines
154 KiB
PL/PgSQL
SET NAMES utf8mb4;
|
||
SET
|
||
FOREIGN_KEY_CHECKS = 0;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_admin
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_admin`;
|
||
CREATE TABLE `la_admin`
|
||
(
|
||
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`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 = 1
|
||
CHARACTER SET = utf8mb4
|
||
COLLATE = utf8mb4_general_ci COMMENT = '管理员表'
|
||
ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_admin_dept
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_admin_dept`;
|
||
CREATE TABLE `la_admin_dept`
|
||
(
|
||
`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_admin_jobs
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_admin_jobs`;
|
||
CREATE TABLE `la_admin_jobs`
|
||
(
|
||
`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_admin_role
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_admin_role`;
|
||
CREATE TABLE `la_admin_role`
|
||
(
|
||
`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_admin_session
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_admin_session`;
|
||
CREATE TABLE `la_admin_session`
|
||
(
|
||
`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_article
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_article`;
|
||
CREATE TABLE `la_article`
|
||
(
|
||
`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 = 4
|
||
CHARACTER SET = utf8mb4
|
||
COLLATE = utf8mb4_general_ci COMMENT = '文章表'
|
||
ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of la_article
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `la_article`
|
||
VALUES (1, 0, 3, '让生活更精致！五款居家好物推荐，实用性超高', '##好物推荐🔥',
|
||
'随着当代生活节奏的忙碌，很多人在闲暇之余都想好好的享受生活。随着科技的发展，也出现了越来越多可以帮助我们提升幸福感，让生活变得更精致的产品，下面周周就给大家盘点五款居家必备的好物，都是实用性很高的产品，周周可以保证大家买了肯定会喜欢。',
|
||
'resource/image/tenantapi/default/article01.png', '红花',
|
||
'<p>拥有一台投影仪，闲暇时可以在家里直接看影院级别的大片，光是想想都觉得超级爽。市面上很多投影仪大几千，其实周周觉得没必要，选泰捷这款一千多的足够了，性价比非常高。</p><p>泰捷的专业度很高，在电视TV领域研发已经十年，有诸多专利和技术创新，荣获国内外多项技术奖项，拿下了腾讯创新工场投资，打造的泰捷视频TV端和泰捷电视盒子都获得了极高评价。</p><p>这款投影仪的分辨率在3000元内无敌，做到了真1080P高分辨率，也就是跟市场售价三千DLP投影仪一样的分辨率，真正做到了分毫毕现，像桌布的花纹、天空的云彩等，这些细节都清晰可见。</p><p>亮度方面，泰捷达到了850ANSI流明，同价位一般是200ANSI。这是因为泰捷为了提升亮度和LCD技术透射率低的问题，首创高功率LED灯源，让其亮度做到同价位最好。专业媒体也进行了多次对比，效果与3000元价位投影仪相当。</p><p>操作系统周周也很喜欢，完全不卡。泰捷作为资深音视频品牌，在系统优化方面有十年的研发经验，打造出的“零极”系统是业内公认效率最高、速度最快的系统，用户也评价它流畅度能一台顶三台，而且为了解决行业广告多这一痛点，系统内不植入任何广告。</p>',
|
||
1, 2, 1, 0, 1663317759, 1727070911, NULL),
|
||
(2, 0, 2, '埋葬UI设计师的坟墓不是内卷，而是免费模式', '',
|
||
'本文从另外一个角度，聊聊作者对UI设计师职业发展前景的担忧，欢迎从事UI设计的同学来参与讨论，会有赠书哦',
|
||
'resource/image/tenantapi/default/article02.jpeg', '小明',
|
||
'<p><br></p><p style=\"text-align: justify;\">一个职业，卷，根本就没什么大不了的，尤其是成熟且收入高的职业，不卷才不符合事物发展的规律。何况 UI 设计师的人力市场到今天也和 5 年前一样，还是停留在大型菜鸡互啄的场面。远不能和医疗、证券、教师或者演艺练习生相提并论。</p><p style=\"text-align: justify;\">真正会让我对UI设计师发展前景觉得悲观的事情就只有一件 —— 国内的互联网产品免费机制。这也是一个我一直以来想讨论的话题，就在这次写一写。</p><p style=\"text-align: justify;\">国内互联网市场的发展，是一部浩瀚的 “免费经济” 发展史。虽然今天免费已经是深入国内民众骨髓的认知，但最早的中文互联网也是需要付费的，网游也都是要花钱的。</p><p style=\"text-align: justify;\">只是自有国情在此，付费确实阻碍了互联网行业的扩张和普及，一批创业家就开始通过免费的模式为用户提供服务，从而扩大了自己的产品覆盖面和普及程度。</p><p style=\"text-align: justify;\">印象最深的就是免费急先锋周鸿祎，和现在鲜少出现在公众视野不同，一零年前他是当之无愧的互联网教主，因为他开发出了符合中国国情的互联网产品 “打法”，让 360 的发展如日中天。</p><p style=\"text-align: justify;\">就是他在自传中提到：</p><p style=\"text-align: justify;\">只要是在互联网上每个人都需要的服务，我们就认为它是基础服务，基础服务一定是免费的，这样的话不会形成价值歧视。就是说，只要这种服务是每个人都一定要用的，我一定免费提供，而且是无条件免费。增值服务不是所有人都需要的，这个比例可能会相当低，它只是百分之几甚至更少比例的人需要，所以这种服务一定要收费……</p><p style=\"text-align: justify;\">这就是互联网的游戏规则，它决定了要想建立一个有效的商业模式，就一定要有海量的用户基数……</p>',
|
||
2, 4, 1, 0, 1663322854, 1727071178, NULL),
|
||
(3, 0, 1, '金山电池公布“沪广深市民绿色生活方式”调查结果', '',
|
||
'60%以上受访者认为高质量的10分钟足以完成“自我充电”', 'resource/image/tenantapi/default/article03.png',
|
||
'中网资讯科技',
|
||
'<p style=\"text-align: left;\"><strong>深圳，2021年10月22日）</strong>生活在一线城市的沪广深市民一向以效率见称，工作繁忙和快节奏的生活容易缺乏充足的休息。近日，一项针对沪广深市民绿色生活方式而展开的网络问卷调查引起了大家的注意。问卷的问题设定集中于市民对休息时间的看法，以及从对循环充电电池的使用方面了解其对绿色生活方式的态度。该调查采用随机抽样的模式，并对最终收集的1,500份有效问卷进行专业分析后发现，超过60%的受访者表示，在每天的工作时段能拥有10分钟高质量的休息时间，就可以高效“自我充电”。该调查结果反映出，在快节奏时代下，人们需要高质量的休息时间，也要学会利用高效率的休息方式和工具来应对快节奏的生活，以时刻保持“满电”状态。</p><p style=\"text-align: left;\"> <strong>60%以上受访者认为高质量的10分钟足以完成“自我充电”</strong></p><p style=\"text-align: left;\"> 这次调查超过1,500人，主要聚焦18至85岁的沪广深市民，了解他们对于休息时间的观念及使用充电电池的习惯，结果发现：</p><p style=\"text-align: left;\"> · 90%以上有工作受访者每天工作时间在7小时以上，平均工作时间为8小时，其中43%以上的受访者工作时间超过9小时</p><p style=\"text-align: left;\"> · 70%受访者认为在工作期间拥有10分钟“自我充电”时间不是一件困难的事情</p><p style=\"text-align: left;\"> · 60%受访者认为在工作期间有10分钟休息时间足以为自己快速充电</p><p style=\"text-align: left;\"> 临床心理学家黄咏诗女士在发布会上分享为自己快速充电的实用技巧，她表示：“事实上，只要选择正确的休息方法，10分钟也足以为自己充电。以喝咖啡为例，我们可以使用心灵休息法 ── 静观呼吸，慢慢感受咖啡的温度和气味，如果能配合着聆听流水或海洋的声音，能够有效放松大脑及心灵。”</p><p style=\"text-align: left;\"> 这次调查结果反映出沪广深市民的希望在繁忙的工作中适时停下来，抽出10分钟喝杯咖啡、聆听音乐或小睡片刻，为自己充电。金山电池全新推出的“绿再十分充”超快速充电器仅需10分钟就能充好电，喝一杯咖啡的时间既能完成“自我充电”，也满足设备使用的用电需求，为提升工作效率和放松身心注入新能量。</p><p style=\"text-align: left;\"> <strong>金山电池推出10分钟超快电池充电器*绿再十分充，以创新科技为市场带来革新体验</strong></p><p style=\"text-align: left;\"> 该问卷同时从沪广深市民对循环充电电池的使用方面进行了调查，以了解其对绿色生活方式的态度：</p><p style=\"text-align: left;\"> · 87%受访者目前没有使用充电电池，其中61%表示会考虑使用充电电池</p><p style=\"text-align: left;\"> · 58%受访者过往曾使用过充电电池，却只有20%左右市民仍在使用</p><p style=\"text-align: left;\"> · 60%左右受访者认为充电电池尚未被广泛使用，主要障碍来自于充电时间过长、缺乏相关教育</p><p style=\"text-align: left;\"> · 90%以上受访者认为充电电池充满电需要1小时或更长的时间</p><p style=\"text-align: left;\"> 金山电池一直致力于为大众提供安全可靠的充电电池，并与消费者的需求和生活方式一起演变及进步。今天，金山电池宣布推出10分钟超快电池充电器*绿再十分充，只需10分钟*即可将4粒绿再十分充充电电池充好电，充电速度比其他品牌提升3倍**。充电器的LED灯可以显示每粒电池的充电状态和模式，并提示用户是否错误插入已损坏电池或一次性电池。尽管其体型小巧，却具备多项创新科技 ，如拥有独特的充电算法以优化充电电流，并能根据各个电池类型、状况和温度用最短的时间为充电电池充好电;绿再十分充内置横流扇，有效防止电池温度过热和提供低噪音的充电环境等。<br></p>',
|
||
11, 4, 1, 0, 1663322665, 1727071154, NULL);
|
||
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_article_cate
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_article_cate`;
|
||
CREATE TABLE `la_article_cate`
|
||
(
|
||
`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 = 3
|
||
CHARACTER SET = utf8mb4
|
||
COLLATE = utf8mb4_general_ci COMMENT = '文章分类表'
|
||
ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of la_article_cate
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `la_article_cate`
|
||
VALUES (1, 0, '科技', 0, 1, 1663317280, 1663317280, NULL),
|
||
(2, 0, '生活', 0, 1, 1663317280, 1663321464, NULL),
|
||
(3, 0, '好物', 0, 1, 1727070858, 1727070858, NULL);
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_article_collect
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_article_collect`;
|
||
CREATE TABLE `la_article_collect`
|
||
(
|
||
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`tenant_id` int(11) NOT NULL COMMENT '租户ID',
|
||
`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
|
||
AUTO_INCREMENT = 1
|
||
CHARACTER SET = utf8mb4
|
||
COLLATE = utf8mb4_general_ci COMMENT = '文章收藏表'
|
||
ROW_FORMAT = Dynamic;
|
||
-- ----------------------------
|
||
-- Table structure for la_config
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_config`;
|
||
CREATE TABLE `la_config`
|
||
(
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`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_decorate_page
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_decorate_page`;
|
||
CREATE TABLE `la_decorate_page`
|
||
(
|
||
`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 = 6
|
||
CHARACTER SET = utf8mb4
|
||
COLLATE = utf8mb4_general_ci COMMENT = '装修页面配置表'
|
||
ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of la_decorate_page
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `la_decorate_page`
|
||
VALUES (1, 0, 1, '商城首页',
|
||
'[{\"title\":\"搜索\",\"name\":\"search\",\"disabled\":1,\"content\":{},\"styles\":{}},{\"title\":\"首页轮播图\",\"name\":\"banner\",\"content\":{\"enabled\":1,\"data\":[{\"image\":\"/resource/image/tenantapi/default/banner001.png\",\"name\":\"\",\"link\":{\"id\":6,\"name\":\"来自瓷器的爱\",\"path\":\"/pages/news_detail/news_detail\",\"query\":{\"id\":6},\"type\":\"article\"},\"is_show\":\"1\",\"bg\":\"/resource/image/tenantapi/default/banner001_bg.png\"},{\"image\":\"/resource/image/tenantapi/default/banner002.png\",\"name\":\"\",\"link\":{\"id\":3,\"name\":\"金山电池公布“沪广深市民绿色生活方式”调查结果\",\"path\":\"/pages/news_detail/news_detail\",\"query\":{\"id\":3},\"type\":\"article\"},\"is_show\":\"1\",\"bg\":\"/resource/image/tenantapi/default/banner002_bg.png\"},{\"is_show\":\"1\",\"image\":\"/resource/image/tenantapi/default/banner003.png\",\"name\":\"\",\"link\":{\"id\":1,\"name\":\"让生活更精致！五款居家好物推荐，实用性超高\",\"path\":\"/pages/news_detail/news_detail\",\"query\":{\"id\":1},\"type\":\"article\"},\"bg\":\"/resource/image/tenantapi/default/banner003_bg.png\"}],\"style\":1,\"bg_style\":1},\"styles\":{}},{\"title\":\"导航菜单\",\"name\":\"nav\",\"content\":{\"enabled\":1,\"data\":[{\"image\":\"/resource/image/tenantapi/default/nav01.png\",\"name\":\"资讯中心\",\"link\":{\"path\":\"/pages/news/news\",\"name\":\"文章资讯\",\"type\":\"shop\",\"canTab\":true},\"is_show\":\"1\"},{\"image\":\"/resource/image/tenantapi/default/nav03.png\",\"name\":\"个人设置\",\"link\":{\"path\":\"/pages/user_set/user_set\",\"name\":\"个人设置\",\"type\":\"shop\"},\"is_show\":\"1\"},{\"image\":\"/resource/image/tenantapi/default/nav02.png\",\"name\":\"我的收藏\",\"link\":{\"path\":\"/pages/collection/collection\",\"name\":\"我的收藏\",\"type\":\"shop\"},\"is_show\":\"1\"},{\"image\":\"/resource/image/tenantapi/default/nav05.png\",\"name\":\"关于我们\",\"link\":{\"path\":\"/pages/as_us/as_us\",\"name\":\"关于我们\",\"type\":\"shop\"},\"is_show\":\"1\"},{\"image\":\"/resource/image/tenantapi/default/nav04.png\",\"name\":\"联系客服\",\"link\":{\"path\":\"/pages/customer_service/customer_service\",\"name\":\"联系客服\",\"type\":\"shop\"},\"is_show\":\"1\"}],\"style\":2,\"per_line\":5,\"show_line\":2},\"styles\":{}},{\"title\":\"首页中部轮播图\",\"name\":\"middle-banner\",\"content\":{\"enabled\":1,\"data\":[{\"is_show\":\"1\",\"image\":\"/resource/image/tenantapi/default/index_ad01.png\",\"name\":\"\",\"link\":{\"path\":\"/pages/agreement/agreement\",\"name\":\"隐私政策\",\"query\":{\"type\":\"privacy\"},\"type\":\"shop\"}}]},\"styles\":{}},{\"id\":\"l84almsk2uhyf\",\"title\":\"资讯\",\"name\":\"news\",\"disabled\":1,\"content\":{},\"styles\":{}}]',
|
||
'[{\"title\":\"页面设置\",\"name\":\"page-meta\",\"content\":{\"title\":\"首页\",\"bg_type\":\"2\",\"bg_color\":\"#2F80ED\",\"bg_image\":\"/resource/image/tenantapi/default/page_meta_bg01.png\",\"text_color\":\"2\",\"title_type\":\"2\",\"title_img\":\"/resource/image/tenantapi/default/page_mate_title.png\"},\"styles\":{}}]',
|
||
1661757188, 1710989700);
|
||
INSERT INTO `la_decorate_page`
|
||
VALUES (2, 0, 2, '个人中心',
|
||
'[{\"title\":\"用户信息\",\"name\":\"user-info\",\"disabled\":1,\"content\":{},\"styles\":{}},{\"title\":\"我的服务\",\"name\":\"my-service\",\"content\":{\"style\":1,\"title\":\"我的服务\",\"data\":[{\"image\":\"/resource/image/tenantapi/default/user_collect.png\",\"name\":\"我的收藏\",\"link\":{\"path\":\"/pages/collection/collection\",\"name\":\"我的收藏\",\"type\":\"shop\"},\"is_show\":\"1\"},{\"image\":\"/resource/image/tenantapi/default/user_setting.png\",\"name\":\"个人设置\",\"link\":{\"path\":\"/pages/user_set/user_set\",\"name\":\"个人设置\",\"type\":\"shop\"},\"is_show\":\"1\"},{\"image\":\"/resource/image/tenantapi/default/user_kefu.png\",\"name\":\"联系客服\",\"link\":{\"path\":\"/pages/customer_service/customer_service\",\"name\":\"联系客服\",\"type\":\"shop\"},\"is_show\":\"1\"},{\"image\":\"/resource/image/tenantapi/default/wallet.png\",\"name\":\"我的钱包\",\"link\":{\"path\":\"/packages/pages/user_wallet/user_wallet\",\"name\":\"我的钱包\",\"type\":\"shop\"},\"is_show\":\"1\"}],\"enabled\":1},\"styles\":{}},{\"title\":\"个人中心广告图\",\"name\":\"user-banner\",\"content\":{\"enabled\":1,\"data\":[{\"image\":\"/resource/image/tenantapi/default/user_ad01.png\",\"name\":\"\",\"link\":{\"path\":\"/pages/customer_service/customer_service\",\"name\":\"联系客服\",\"type\":\"shop\"},\"is_show\":\"1\"},{\"image\":\"/resource/image/tenantapi/default/user_ad02.png\",\"name\":\"\",\"link\":{\"path\":\"/pages/customer_service/customer_service\",\"name\":\"联系客服\",\"type\":\"shop\"},\"is_show\":\"1\"}]},\"styles\":{}}]',
|
||
'[{\"title\":\"页面设置\",\"name\":\"page-meta\",\"content\":{\"title\":\"个人中心\",\"bg_type\":\"1\",\"bg_color\":\"#2F80ED\",\"bg_image\":\"\",\"text_color\":\"1\",\"title_type\":\"2\",\"title_img\":\"/resource/image/tenantapi/default/page_mate_title.png\"},\"styles\":{}}]',
|
||
1661757188, 1710933097);
|
||
INSERT INTO `la_decorate_page`
|
||
VALUES (3, 0, 3, '客服设置',
|
||
'[{\"title\":\"客服设置\",\"name\":\"customer-service\",\"content\":{\"title\":\"添加客服二维码\",\"time\":\"早上 9:30 - 19:00\",\"mobile\":\"1888888888\",\"qrcode\":\"/resource/image/common/kefu01.png\",\"remark\":\"长按添加客服或拨打客服热线\"},\"styles\":{}}]',
|
||
'', 1661757188, 1710929953);
|
||
INSERT INTO `la_decorate_page`
|
||
VALUES (4, 0, 4, 'PC设置',
|
||
'[{\"id\":\"lajcn8d0hzhed\",\"title\":\"首页轮播图\",\"name\":\"pc-banner\",\"content\":{\"enabled\":1,\"data\":[{\"image\":\"/resource/image/tenantapi/default/banner003.png\",\"name\":\"\",\"link\":{\"path\":\"/pages/news/news\",\"name\":\"文章资讯\",\"type\":\"shop\"}},{\"image\":\"/resource/image/tenantapi/default/banner002.png\",\"name\":\"\",\"link\":{\"path\":\"/pages/collection/collection\",\"name\":\"我的收藏\",\"type\":\"shop\"}},{\"image\":\"/resource/image/tenantapi/default/banner001.png\",\"name\":\"\",\"link\":{}}]},\"styles\":{\"position\":\"absolute\",\"left\":\"40\",\"top\":\"75px\",\"width\":\"750px\",\"height\":\"340px\"}}]',
|
||
'', 1661757188, 1710990175);
|
||
INSERT INTO `la_decorate_page`
|
||
VALUES (5, 0, 5, '系统风格',
|
||
'{\"themeColorId\":3,\"topTextColor\":\"white\",\"navigationBarColor\":\"#A74BFD\",\"themeColor1\":\"#A74BFD\",\"themeColor2\":\"#CB60FF\",\"buttonColor\":\"white\"}',
|
||
'', 1710410915, 1710990415);
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_decorate_tabbar
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_decorate_tabbar`;
|
||
CREATE TABLE `la_decorate_tabbar`
|
||
(
|
||
`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 = 4
|
||
CHARACTER SET = utf8mb4
|
||
COLLATE = utf8mb4_general_ci COMMENT = '装修底部导航表'
|
||
ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of la_decorate_tabbar
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `la_decorate_tabbar`
|
||
VALUES (1, 0, '首页', 'resource/image/tenantapi/default/tabbar_home_sel.png',
|
||
'resource/image/tenantapi/default/tabbar_home.png',
|
||
'{\"path\":\"/pages/index/index\",\"name\":\"商城首页\",\"type\":\"shop\"}', 1, 1662688157, 1662688157);
|
||
INSERT INTO `la_decorate_tabbar`
|
||
VALUES (2, 0, '资讯', 'resource/image/tenantapi/default/tabbar_text_sel.png',
|
||
'resource/image/tenantapi/default/tabbar_text.png',
|
||
'{\"path\":\"/pages/news/news\",\"name\":\"文章资讯\",\"type\":\"shop\",\"canTab\":\"1\"}', 1, 1662688157,
|
||
1662688157);
|
||
INSERT INTO `la_decorate_tabbar`
|
||
VALUES (3, 0, '我的', 'resource/image/tenantapi/default/tabbar_me_sel.png',
|
||
'resource/image/tenantapi/default/tabbar_me.png',
|
||
'{\"path\":\"/pages/user/user\",\"name\":\"个人中心\",\"type\":\"shop\",\"canTab\":\"1\"}', 1, 1662688157,
|
||
1662688157);
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_dept
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_dept`;
|
||
CREATE TABLE `la_dept`
|
||
(
|
||
`id` int(11) NOT NULL AUTO_INCREMENT 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 = 2
|
||
CHARACTER SET = utf8mb4
|
||
COLLATE = utf8mb4_general_ci COMMENT = '部门表'
|
||
ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of la_dept
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `la_dept`
|
||
VALUES (1, '公司', 0, 0, 'boss', '12345698745', 1, 1650592684, 1653640368, NULL);
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_dev_crontab
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_dev_crontab`;
|
||
CREATE TABLE `la_dev_crontab`
|
||
(
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`name` varchar(32) NOT NULL COMMENT '定时任务名称',
|
||
`type` tinyint(1) NOT NULL COMMENT '类型 1-定时任务',
|
||
`system` tinyint(4) DEFAULT '0' COMMENT '是否系统任务 0-否 1-是',
|
||
`remark` varchar(255) DEFAULT '' COMMENT '备注',
|
||
`command` varchar(64) NOT NULL COMMENT '命令内容',
|
||
`params` varchar(64) DEFAULT '' COMMENT '参数',
|
||
`status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态 1-运行 2-停止 3-错误',
|
||
`expression` varchar(64) NOT NULL COMMENT '运行规则',
|
||
`error` varchar(256) DEFAULT NULL COMMENT '运行失败原因',
|
||
`last_time` int(11) DEFAULT NULL COMMENT '最后执行时间',
|
||
`time` varchar(64) DEFAULT '0' COMMENT '实时执行时长',
|
||
`max_time` varchar(64) DEFAULT '0' COMMENT '最大执行时长',
|
||
`create_time` int(10) DEFAULT NULL COMMENT '创建时间',
|
||
`update_time` int(10) DEFAULT NULL COMMENT '更新时间',
|
||
`delete_time` int(10) DEFAULT NULL COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB
|
||
DEFAULT CHARSET = utf8mb4 COMMENT ='计划任务表';
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_dict_data
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_dict_data`;
|
||
CREATE TABLE `la_dict_data`
|
||
(
|
||
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '数据名称',
|
||
`value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '数据值',
|
||
`type_id` int(11) NOT NULL COMMENT '字典类型id',
|
||
`type_value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典类型',
|
||
`sort` int(10) NULL DEFAULT 0 COMMENT '排序值',
|
||
`status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态 0-停用 1-正常',
|
||
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' 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 = 14
|
||
CHARACTER SET = utf8mb4
|
||
COLLATE = utf8mb4_general_ci COMMENT = '字典数据表'
|
||
ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of la_dict_data
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `la_dict_data`
|
||
VALUES (1, '隐藏', '0', 1, 'show_status', 0, 1, '', 1656381543, 1656381543, NULL);
|
||
INSERT INTO `la_dict_data`
|
||
VALUES (2, '显示', '1', 1, 'show_status', 0, 1, '', 1656381550, 1656381550, NULL);
|
||
INSERT INTO `la_dict_data`
|
||
VALUES (3, '进行中', '0', 2, 'business_status', 0, 1, '', 1656381410, 1656381410, NULL);
|
||
INSERT INTO `la_dict_data`
|
||
VALUES (4, '成功', '1', 2, 'business_status', 0, 1, '', 1656381437, 1656381437, NULL);
|
||
INSERT INTO `la_dict_data`
|
||
VALUES (5, '失败', '2', 2, 'business_status', 0, 1, '', 1656381449, 1656381449, NULL);
|
||
INSERT INTO `la_dict_data`
|
||
VALUES (6, '待处理', '0', 3, 'event_status', 0, 1, '', 1656381212, 1656381212, NULL);
|
||
INSERT INTO `la_dict_data`
|
||
VALUES (7, '已处理', '1', 3, 'event_status', 0, 1, '', 1656381315, 1656381315, NULL);
|
||
INSERT INTO `la_dict_data`
|
||
VALUES (8, '拒绝处理', '2', 3, 'event_status', 0, 1, '', 1656381331, 1656381331, NULL);
|
||
INSERT INTO `la_dict_data`
|
||
VALUES (9, '禁用', '1', 4, 'system_disable', 0, 1, '', 1656312030, 1656312030, NULL);
|
||
INSERT INTO `la_dict_data`
|
||
VALUES (10, '正常', '0', 4, 'system_disable', 0, 1, '', 1656312040, 1656312040, NULL);
|
||
INSERT INTO `la_dict_data`
|
||
VALUES (11, '未知', '0', 5, 'sex', 0, 1, '', 1656062988, 1656062988, NULL);
|
||
INSERT INTO `la_dict_data`
|
||
VALUES (12, '男', '1', 5, 'sex', 0, 1, '', 1656062999, 1656062999, NULL);
|
||
INSERT INTO `la_dict_data`
|
||
VALUES (13, '女', '2', 5, 'sex', 0, 1, '', 1656063009, 1656063009, NULL);
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_dict_type
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_dict_type`;
|
||
CREATE TABLE `la_dict_type`
|
||
(
|
||
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '字典名称',
|
||
`type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '字典类型名称',
|
||
`status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态 0-停用 1-正常',
|
||
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' 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 = 6
|
||
CHARACTER SET = utf8mb4
|
||
COLLATE = utf8mb4_general_ci COMMENT = '字典类型表'
|
||
ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of la_dict_type
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `la_dict_type`
|
||
VALUES (1, '显示状态', 'show_status', 1, '', 1656381520, 1656381520, NULL);
|
||
INSERT INTO `la_dict_type`
|
||
VALUES (2, '业务状态', 'business_status', 1, '', 1656381393, 1656381393, NULL);
|
||
INSERT INTO `la_dict_type`
|
||
VALUES (3, '事件状态', 'event_status', 1, '', 1656381075, 1656381075, NULL);
|
||
INSERT INTO `la_dict_type`
|
||
VALUES (4, '禁用状态', 'system_disable', 1, '', 1656311838, 1656311838, NULL);
|
||
INSERT INTO `la_dict_type`
|
||
VALUES (5, '用户性别', 'sex', 1, '', 1656062946, 1656380925, NULL);
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_file
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_file`;
|
||
CREATE TABLE `la_file`
|
||
(
|
||
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT 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_file_cate
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_file_cate`;
|
||
CREATE TABLE `la_file_cate`
|
||
(
|
||
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT 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_generate_column
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_generate_column`;
|
||
CREATE TABLE `la_generate_column`
|
||
(
|
||
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
`table_id` int(11) NOT NULL DEFAULT 0 COMMENT '表id',
|
||
`column_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '字段名称',
|
||
`column_comment` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '字段描述',
|
||
`column_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '字段类型',
|
||
`is_required` tinyint(1) NULL DEFAULT 0 COMMENT '是否必填 0-非必填 1-必填',
|
||
`is_pk` tinyint(1) NULL DEFAULT 0 COMMENT '是否为主键 0-不是 1-是',
|
||
`is_insert` tinyint(1) NULL DEFAULT 0 COMMENT '是否为插入字段 0-不是 1-是',
|
||
`is_update` tinyint(1) NULL DEFAULT 0 COMMENT '是否为更新字段 0-不是 1-是',
|
||
`is_lists` tinyint(1) NULL DEFAULT 0 COMMENT '是否为列表字段 0-不是 1-是',
|
||
`is_query` tinyint(1) NULL DEFAULT 0 COMMENT '是否为查询字段 0-不是 1-是',
|
||
`query_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '=' COMMENT '查询类型',
|
||
`view_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'input' COMMENT '显示类型',
|
||
`dict_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '字典类型',
|
||
`create_time` int(10) NOT 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_generate_table
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_generate_table`;
|
||
CREATE TABLE `la_generate_table`
|
||
(
|
||
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
`table_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '表名称',
|
||
`table_comment` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '表描述',
|
||
`template_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '模板类型 0-单表(curd) 1-树表(curd)',
|
||
`author` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '作者',
|
||
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '备注',
|
||
`generate_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '生成方式 0-压缩包下载 1-生成到模块',
|
||
`module_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '模块名',
|
||
`class_dir` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '类目录名',
|
||
`class_comment` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '类描述',
|
||
`admin_id` int(11) NULL DEFAULT 0 COMMENT '管理员id',
|
||
`menu` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '菜单配置',
|
||
`delete` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '删除配置',
|
||
`tree` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '树表配置',
|
||
`relations` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '关联配置',
|
||
`create_time` int(10) NOT 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_hot_search
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_hot_search`;
|
||
CREATE TABLE `la_hot_search`
|
||
(
|
||
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`tenant_id` int(11) NOT NULL COMMENT '租户ID',
|
||
`name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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
|
||
AUTO_INCREMENT = 1
|
||
CHARACTER SET = utf8mb4
|
||
COLLATE = utf8mb4_general_ci COMMENT = '热门搜索表'
|
||
ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_jobs
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_jobs`;
|
||
CREATE TABLE `la_jobs`
|
||
(
|
||
`id` int(11) NOT NULL AUTO_INCREMENT 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_notice_record
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_notice_record`;
|
||
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) 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_notice_setting
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_notice_setting`;
|
||
CREATE TABLE `la_notice_setting`
|
||
(
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`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 = 5
|
||
CHARACTER SET = utf8mb4
|
||
COLLATE = utf8mb4_general_ci COMMENT = '通知设置表'
|
||
ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of la_notice_setting
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `la_notice_setting`
|
||
VALUES (1, 101, '登录验证码', '用户手机号码登录时发送', 1, 2,
|
||
'{\"type\":\"system\",\"title\":\"\",\"content\":\"\",\"status\":\"0\",\"is_show\":\"\",\"tips\":[\"可选变量 验证码:code\"]}',
|
||
'{\"type\":\"sms\",\"template_id\":\"SMS_123456\",\"content\":\"您正在登录，验证码${code}，切勿将验证码泄露于他人，本条验证码有效期5分钟。\",\"status\":\"1\",\"is_show\":\"1\"}',
|
||
'{\"type\":\"oa\",\"template_id\":\"\",\"template_sn\":\"\",\"name\":\"\",\"first\":\"\",\"remark\":\"\",\"tpl\":[],\"status\":\"0\",\"is_show\":\"\",\"tips\":[\"可选变量 验证码:code\",\"配置路径：小程序后台 > 功能 > 订阅消息\"]}',
|
||
'{\"type\":\"mnp\",\"template_id\":\"\",\"template_sn\":\"\",\"name\":\"\",\"tpl\":[],\"status\":\"0\",\"is_show\":\"\",\"tips\":[\"可选变量 验证码:code\",\"配置路径：小程序后台 > 功能 > 订阅消息\"]}',
|
||
'2', NULL);
|
||
INSERT INTO `la_notice_setting`
|
||
VALUES (2, 102, '绑定手机验证码', '用户绑定手机号码时发送', 1, 2,
|
||
'{\"type\":\"system\",\"title\":\"\",\"content\":\"\",\"status\":\"0\",\"is_show\":\"\"}',
|
||
'{\"type\":\"sms\",\"template_id\":\"SMS_123456\",\"content\":\"您正在绑定手机号，验证码${code}，切勿将验证码泄露于他人，本条验证码有效期5分钟。\",\"status\":\"1\",\"is_show\":\"1\"}',
|
||
'{\"type\":\"oa\",\"template_id\":\"\",\"template_sn\":\"\",\"name\":\"\",\"first\":\"\",\"remark\":\"\",\"tpl\":[],\"status\":\"0\",\"is_show\":\"\"}',
|
||
'{\"type\":\"mnp\",\"template_id\":\"\",\"template_sn\":\"\",\"name\":\"\",\"tpl\":[],\"status\":\"0\",\"is_show\":\"\"}',
|
||
'2', NULL);
|
||
INSERT INTO `la_notice_setting`
|
||
VALUES (3, 103, '变更手机验证码', '用户变更手机号码时发送', 1, 2,
|
||
'{\"type\":\"system\",\"title\":\"\",\"content\":\"\",\"status\":\"0\",\"is_show\":\"\",\"tips\":[\"可选变量 验证码:code\"]}',
|
||
'{\"type\":\"sms\",\"template_id\":\"SMS_123456\",\"content\":\"您正在变更手机号，验证码${code}，切勿将验证码泄露于他人，本条验证码有效期5分钟。\",\"status\":\"1\",\"is_show\":\"1\"}',
|
||
'{\"type\":\"oa\",\"template_id\":\"\",\"template_sn\":\"\",\"name\":\"\",\"first\":\"\",\"remark\":\"\",\"tpl\":[],\"status\":\"0\",\"is_show\":\"\",\"tips\":[\"可选变量 验证码:code\",\"配置路径：小程序后台 > 功能 > 订阅消息\"]}',
|
||
'{\"type\":\"mnp\",\"template_id\":\"\",\"template_sn\":\"\",\"name\":\"\",\"tpl\":[],\"status\":\"0\",\"is_show\":\"\",\"tips\":[\"可选变量 验证码:code\",\"配置路径：小程序后台 > 功能 > 订阅消息\"]}',
|
||
'2', NULL);
|
||
INSERT INTO `la_notice_setting`
|
||
VALUES (4, 104, '找回登录密码验证码', '用户找回登录密码号码时发送', 1, 2,
|
||
'{\"type\":\"system\",\"title\":\"\",\"content\":\"\",\"status\":\"0\",\"is_show\":\"\",\"tips\":[\"可选变量 验证码:code\"]}',
|
||
'{\"type\":\"sms\",\"template_id\":\"SMS_123456\",\"content\":\"您正在找回登录密码，验证码${code}，切勿将验证码泄露于他人，本条验证码有效期5分钟。\",\"status\":\"0\",\"is_show\":\"1\",\"tips\":[\"可选变量 验证码:code\",\"示例：您正在找回登录密码，验证码${code}，切勿将验证码泄露于他人，本条验证码有效期5分钟。\",\"生效条件：1、管理后台完成短信设置。 2、第三方短信平台申请模板。\"]}',
|
||
'{\"type\":\"oa\",\"template_id\":\"\",\"template_sn\":\"\",\"name\":\"\",\"first\":\"\",\"remark\":\"\",\"tpl\":[],\"status\":\"0\",\"is_show\":\"\",\"tips\":[\"可选变量 验证码:code\",\"配置路径：小程序后台 > 功能 > 订阅消息\"]}',
|
||
'{\"type\":\"mnp\",\"template_id\":\"\",\"template_sn\":\"\",\"name\":\"\",\"tpl\":[],\"status\":\"0\",\"is_show\":\"\",\"tips\":[\"可选变量 验证码:code\",\"配置路径：小程序后台 > 功能 > 订阅消息\"]}',
|
||
'2', NULL);
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_official_account_reply
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_official_account_reply`;
|
||
CREATE TABLE `la_official_account_reply`
|
||
(
|
||
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`tenant_id` int(11) NOT NULL COMMENT '租户ID',
|
||
`name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '规则名称',
|
||
`keyword` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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
|
||
AUTO_INCREMENT = 1
|
||
CHARACTER SET = utf8mb4
|
||
COLLATE = utf8mb4_general_ci COMMENT = '公众号消息回调表'
|
||
ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_operation_log
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_operation_log`;
|
||
CREATE TABLE `la_operation_log`
|
||
(
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`admin_id` int(11) NOT NULL COMMENT '管理员ID',
|
||
`admin_name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '管理员名称',
|
||
`account` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '管理员账号',
|
||
`action` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '操作名称',
|
||
`type` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '请求方式',
|
||
`url` varchar(600) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '访问链接',
|
||
`params` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '请求数据',
|
||
`result` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '请求结果',
|
||
`ip` varchar(39) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'ip地址',
|
||
`create_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_pay_config
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_pay_config`;
|
||
CREATE TABLE `la_pay_config`
|
||
(
|
||
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`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 = 4
|
||
CHARACTER SET = utf8mb4
|
||
COLLATE = utf8mb4_general_ci COMMENT = '支付配置表'
|
||
ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of la_pay_config
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `la_pay_config`
|
||
VALUES (1, '余额支付', 1, '', 'resource/image/common/balance_pay.png', 128, '余额支付备注');
|
||
INSERT INTO `la_pay_config`
|
||
VALUES (2, '微信支付', 2,
|
||
'{\"interface_version\":\"v3\",\"merchant_type\":\"ordinary_merchant\",\"mch_id\":\"\",\"pay_sign_key\":\"\",\"apiclient_cert\":\"\",\"apiclient_key\":\"\"}',
|
||
'/resource/image/common/wechat_pay.png', 123, '微信支付备注');
|
||
INSERT INTO `la_pay_config`
|
||
VALUES (3, '支付宝支付', 3,
|
||
'{\"mode\":\"normal_mode\",\"merchant_type\":\"ordinary_merchant\",\"app_id\":\"\",\"private_key\":\"\",\"ali_public_key\":\"\"}',
|
||
'/resource/image/common/ali_pay.png', 123, '支付宝支付');
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_pay_way
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_pay_way`;
|
||
CREATE TABLE `la_pay_way`
|
||
(
|
||
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`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 = 8
|
||
CHARACTER SET = utf8mb4
|
||
COLLATE = utf8mb4_general_ci COMMENT = '支付方式表'
|
||
ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of la_pay_way
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `la_pay_way`
|
||
VALUES (1, 1, 1, 0, 1);
|
||
INSERT INTO `la_pay_way`
|
||
VALUES (2, 2, 1, 1, 1);
|
||
INSERT INTO `la_pay_way`
|
||
VALUES (3, 1, 2, 0, 1);
|
||
INSERT INTO `la_pay_way`
|
||
VALUES (4, 2, 2, 1, 1);
|
||
INSERT INTO `la_pay_way`
|
||
VALUES (5, 1, 3, 0, 1);
|
||
INSERT INTO `la_pay_way`
|
||
VALUES (6, 2, 3, 1, 1);
|
||
INSERT INTO `la_pay_way`
|
||
VALUES (7, 3, 3, 0, 1);
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_recharge_order
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_recharge_order`;
|
||
CREATE TABLE `la_recharge_order`
|
||
(
|
||
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
`tenant_id` int(11) NOT NULL COMMENT '租户ID',
|
||
`sn` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '订单编号',
|
||
`user_id` int(11) NOT NULL COMMENT '用户id',
|
||
`pay_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '支付编号-冗余字段，针对微信同一主体不同客户端支付需用不同订单号预留。',
|
||
`pay_way` tinyint(2) NOT NULL DEFAULT 2 COMMENT '支付方式 2-微信支付 3-支付宝支付',
|
||
`pay_status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '支付状态：0-待支付；1-已支付',
|
||
`pay_time` int(10) NULL DEFAULT NULL COMMENT '支付时间',
|
||
`order_amount` decimal(10, 2) NOT NULL COMMENT '充值金额',
|
||
`order_terminal` tinyint(1) NULL DEFAULT 1 COMMENT '终端',
|
||
`transaction_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方平台交易流水号',
|
||
`refund_status` tinyint(1) NULL DEFAULT 0 COMMENT '退款状态 0-未退款 1-已退款',
|
||
`refund_transaction_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 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_refund_log
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_refund_log`;
|
||
CREATE TABLE `la_refund_log`
|
||
(
|
||
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
`tenant_id` int(11) NOT NULL COMMENT '租户ID',
|
||
`sn` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '编号',
|
||
`record_id` int(11) NOT NULL COMMENT '退款记录id',
|
||
`user_id` int(11) NOT NULL DEFAULT 0 COMMENT '关联用户',
|
||
`handle_id` int(11) NOT NULL DEFAULT 0 COMMENT '处理人id（管理员id）',
|
||
`order_amount` decimal(10, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '订单总的应付款金额，冗余字段',
|
||
`refund_amount` decimal(10, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '本次退款金额',
|
||
`refund_status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '退款状态，0退款中，1退款成功，2退款失败',
|
||
`refund_msg` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '退款信息',
|
||
`create_time` int(10) UNSIGNED NULL DEFAULT 0 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_refund_record
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_refund_record`;
|
||
CREATE TABLE `la_refund_record`
|
||
(
|
||
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
`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 DEFAULT 0 COMMENT '关联用户',
|
||
`order_id` int(11) NOT NULL DEFAULT 0 COMMENT '来源订单id',
|
||
`order_sn` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '来源单号',
|
||
`order_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'order' COMMENT '订单来源 order-商品订单 recharge-充值订单',
|
||
`order_amount` decimal(10, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '订单总的应付款金额，冗余字段',
|
||
`refund_amount` decimal(10, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '本次退款金额',
|
||
`transaction_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方平台交易流水号',
|
||
`refund_way` tinyint(1) NOT NULL DEFAULT 1 COMMENT '退款方式 1-线上退款 2-线下退款',
|
||
`refund_type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '退款类型 1-后台退款',
|
||
`refund_status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '退款状态，0退款中，1退款成功，2退款失败',
|
||
`create_time` int(10) UNSIGNED NULL DEFAULT 0 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_sms_log
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_sms_log`;
|
||
CREATE TABLE `la_sms_log`
|
||
(
|
||
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
`tenant_id` int(11) NOT NULL COMMENT '租户ID',
|
||
`scene_id` int(11) NOT NULL COMMENT '场景id',
|
||
`mobile` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '手机号码',
|
||
`content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '发送内容',
|
||
`code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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 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_system_menu
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_system_menu`;
|
||
CREATE TABLE `la_system_menu`
|
||
(
|
||
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`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 = 166
|
||
CHARACTER SET = utf8mb4
|
||
COLLATE = utf8mb4_general_ci COMMENT = '系统菜单表'
|
||
ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of la_system_menu
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (4, 0, 'M', '权限管理', 'el-icon-Lock', 300, '', 'permission', '', '', '', 0, 1, 0, 1656664556, 1710472802);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (5, 0, 'C', '工作台', 'el-icon-Monitor', 1000, 'workbench/index', 'workbench', 'workbench/index', '', '', 0, 1,
|
||
0, 1656664793, 1664354981);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (6, 4, 'C', '菜单', 'el-icon-Operation', 100, 'auth.menu/lists', 'menu', 'permission/menu/index', '', '', 1, 1,
|
||
0, 1656664960, 1710472994);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (7, 4, 'C', '管理员', 'local-icon-shouyiren', 80, 'auth.admin/lists', 'admin', 'permission/admin/index', '', '',
|
||
0, 1, 0, 1656901567, 1710473013);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (8, 4, 'C', '角色', 'el-icon-Female', 90, 'auth.role/lists', 'role', 'permission/role/index', '', '', 0, 1, 0,
|
||
1656901660, 1710473000);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (12, 8, 'A', '新增', '', 1, 'auth.role/add', '', '', '', '', 0, 1, 0, 1657001790, 1663750625);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (14, 8, 'A', '编辑', '', 1, 'auth.role/edit', '', '', '', '', 0, 1, 0, 1657001924, 1663750631);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (15, 8, 'A', '删除', '', 1, 'auth.role/delete', '', '', '', '', 0, 1, 0, 1657001982, 1663750637);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (16, 6, 'A', '新增', '', 1, 'auth.menu/add', '', '', '', '', 0, 1, 0, 1657072523, 1663750565);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (17, 6, 'A', '编辑', '', 1, 'auth.menu/edit', '', '', '', '', 0, 1, 0, 1657073955, 1663750570);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (18, 6, 'A', '删除', '', 1, 'auth.menu/delete', '', '', '', '', 0, 1, 0, 1657073987, 1663750578);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (19, 7, 'A', '新增', '', 1, 'auth.admin/add', '', '', '', '', 0, 1, 0, 1657074035, 1663750596);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (20, 7, 'A', '编辑', '', 1, 'auth.admin/edit', '', '', '', '', 0, 1, 0, 1657074071, 1663750603);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (21, 7, 'A', '删除', '', 1, 'auth.admin/delete', '', '', '', '', 0, 1, 0, 1657074108, 1663750609);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (23, 28, 'M', '开发工具', 'el-icon-EditPen', 40, '', 'dev_tools', '', '', '', 0, 1, 0, 1657097744, 1710473127);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (24, 23, 'C', '代码生成器', 'el-icon-DocumentAdd', 1, 'tools.generator/generateTable', 'code',
|
||
'dev_tools/code/index', '', '', 0, 1, 0, 1657098110, 1658989423);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (25, 0, 'M', '组织管理', 'el-icon-OfficeBuilding', 400, '', 'organization', '', '', '', 0, 1, 0, 1657099914,
|
||
1710472797);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (26, 25, 'C', '部门管理', 'el-icon-Coordinate', 100, 'dept.dept/lists', 'department',
|
||
'organization/department/index', '', '', 1, 1, 0, 1657099989, 1710472962);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (27, 25, 'C', '岗位管理', 'el-icon-PriceTag', 90, 'dept.jobs/lists', 'post', 'organization/post/index', '', '',
|
||
0, 1, 0, 1657100044, 1710472967);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (28, 0, 'M', '系统设置', 'el-icon-Setting', 200, '', 'setting', '', '', '', 0, 1, 0, 1657100164, 1710472807);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (29, 28, 'M', '网站设置', 'el-icon-Basketball', 100, '', 'website', '', '', '', 0, 1, 0, 1657100230, 1710473049);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (30, 29, 'C', '网站信息', '', 1, 'setting.web.web_setting/getWebsite', 'information',
|
||
'setting/website/information', '', '', 0, 1, 0, 1657100306, 1657164412);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (31, 29, 'C', '网站备案', '', 1, 'setting.web.web_setting/getCopyright', 'filing', 'setting/website/filing', '',
|
||
'', 0, 1, 1, 1657100434, 1657164723);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (32, 29, 'C', '政策协议', '', 1, 'setting.web.web_setting/getAgreement', 'protocol', 'setting/website/protocol',
|
||
'', '', 0, 1, 1, 1657100571, 1657164770);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (33, 28, 'C', '存储设置', 'el-icon-FolderOpened', 70, 'setting.storage/lists', 'storage',
|
||
'setting/storage/index', '', '', 0, 1, 0, 1657160959, 1710473095);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (34, 23, 'C', '字典管理', 'el-icon-Box', 1, 'setting.dict.dict_type/lists', 'dict', 'setting/dict/type/index',
|
||
'', '', 0, 1, 0, 1657161211, 1663225935);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (35, 28, 'M', '系统维护', 'el-icon-SetUp', 50, '', 'system', '', '', '', 0, 1, 0, 1657161569, 1710473122);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (36, 35, 'C', '系统日志', '', 90, 'setting.system.log/lists', 'journal', 'setting/system/journal', '', '', 0, 1,
|
||
0, 1657161696, 1710473253);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (37, 35, 'C', '系统缓存', '', 80, '', 'cache', 'setting/system/cache', '', '', 0, 1, 0, 1657161896, 1710473258);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (38, 35, 'C', '系统环境', '', 70, 'setting.system.system/info', 'environment', 'setting/system/environment', '',
|
||
'', 0, 1, 0, 1657162000, 1710473265);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (39, 24, 'A', '导入数据表', '', 1, 'tools.generator/selectTable', '', '', '', '', 0, 1, 0, 1657162736,
|
||
1657162736);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (40, 24, 'A', '代码生成', '', 1, 'tools.generator/generate', '', '', '', '', 0, 1, 0, 1657162806, 1657162806);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (41, 23, 'C', '编辑数据表', '', 1, 'tools.generator/edit', 'code/edit', 'dev_tools/code/edit', '/dev_tools/code',
|
||
'', 1, 0, 0, 1657162866, 1663748668);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (42, 24, 'A', '同步表结构', '', 1, 'tools.generator/syncColumn', '', '', '', '', 0, 1, 0, 1657162934,
|
||
1657162934);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (43, 24, 'A', '删除数据表', '', 1, 'tools.generator/delete', '', '', '', '', 0, 1, 0, 1657163015, 1657163015);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (44, 24, 'A', '预览代码', '', 1, 'tools.generator/preview', '', '', '', '', 0, 1, 0, 1657163263, 1657163263);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (51, 30, 'A', '保存', '', 1, 'setting.web.web_setting/setWebsite', '', '', '', '', 0, 1, 0, 1657164469,
|
||
1663750649);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (52, 31, 'A', '保存', '', 1, 'setting.web.web_setting/setCopyright', '', '', '', '', 0, 1, 0, 1657164692,
|
||
1663750657);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (53, 32, 'A', '保存', '', 1, 'setting.web.web_setting/setAgreement', '', '', '', '', 0, 1, 0, 1657164824,
|
||
1663750665);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (54, 33, 'A', '设置', '', 1, 'setting.storage/setup', '', '', '', '', 0, 1, 0, 1657165303, 1663750673);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (55, 34, 'A', '新增', '', 1, 'setting.dict.dict_type/add', '', '', '', '', 0, 1, 0, 1657166966, 1663750783);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (56, 34, 'A', '编辑', '', 1, 'setting.dict.dict_type/edit', '', '', '', '', 0, 1, 0, 1657166997, 1663750789);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (57, 34, 'A', '删除', '', 1, 'setting.dict.dict_type/delete', '', '', '', '', 0, 1, 0, 1657167038, 1663750796);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (58, 62, 'A', '新增', '', 1, 'setting.dict.dict_data/add', '', '', '', '', 0, 1, 0, 1657167317, 1663750758);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (59, 62, 'A', '编辑', '', 1, 'setting.dict.dict_data/edit', '', '', '', '', 0, 1, 0, 1657167371, 1663750751);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (60, 62, 'A', '删除', '', 1, 'setting.dict.dict_data/delete', '', '', '', '', 0, 1, 0, 1657167397, 1663750768);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (61, 37, 'A', '清除系统缓存', '', 1, 'setting.system.cache/clear', '', '', '', '', 0, 1, 0, 1657173837,
|
||
1657173939);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (62, 23, 'C', '字典数据管理', '', 1, 'setting.dict.dict_data/lists', 'dict/data', 'setting/dict/data/index',
|
||
'/dev_tools/dict', '', 1, 0, 0, 1657174351, 1663745617);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (63, 158, 'M', '素材管理', 'el-icon-Picture', 0, '', 'material', '', '', '', 0, 1, 0, 1657507133, 1710472243);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (64, 63, 'C', '素材中心', 'el-icon-PictureRounded', 0, '', 'index', 'material/index', '', '', 0, 1, 0,
|
||
1657507296, 1664355653);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (68, 6, 'A', '详情', '', 0, 'auth.menu/detail', '', '', '', '', 0, 1, 0, 1663725564, 1663750584);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (69, 7, 'A', '详情', '', 0, 'auth.admin/detail', '', '', '', '', 0, 1, 0, 1663725623, 1663750615);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (101, 158, 'M', '消息管理', 'el-icon-ChatDotRound', 80, '', 'message', '', '', '', 0, 1, 0, 1663838602,
|
||
1710471874);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (102, 101, 'C', '通知设置', '', 0, 'notice.notice/settingLists', 'notice', 'message/notice/index', '', '', 0, 1,
|
||
0, 1663839195, 1663839195);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (103, 102, 'A', '详情', '', 0, 'notice.notice/detail', '', '', '', '', 0, 1, 0, 1663839537, 1663839537);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (104, 101, 'C', '通知设置编辑', '', 0, 'notice.notice/set', 'notice/edit', 'message/notice/edit',
|
||
'/message/notice', '', 0, 0, 0, 1663839873, 1663898477);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (107, 101, 'C', '短信设置', '', 0, 'notice.sms_config/getConfig', 'short_letter', 'message/short_letter/index',
|
||
'', '', 0, 1, 0, 1663898591, 1664355708);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (108, 107, 'A', '设置', '', 0, 'notice.sms_config/setConfig', '', '', '', '', 0, 1, 0, 1663898644, 1663898644);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (109, 107, 'A', '详情', '', 0, 'notice.sms_config/detail', '', '', '', '', 0, 1, 0, 1663898661, 1663898661);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (112, 28, 'M', '用户设置', 'local-icon-keziyuyue', 90, '', 'user', '', '', '', 0, 1, 1, 1663903302, 1710473056);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (113, 112, 'C', '用户设置', '', 0, 'setting.user.user/getConfig', 'setup', 'setting/user/setup', '', '', 0, 1, 1,
|
||
1663903506, 1663903506);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (114, 113, 'A', '保存', '', 0, 'setting.user.user/setConfig', '', '', '', '', 0, 1, 0, 1663903522, 1663903522);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (115, 112, 'C', '登录注册', '', 0, 'setting.user.user/getRegisterConfig', 'login_register',
|
||
'setting/user/login_register', '', '', 0, 1, 0, 1663903832, 1663903832);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (116, 115, 'A', '保存', '', 0, 'setting.user.user/setRegisterConfig', '', '', '', '', 0, 1, 0, 1663903852,
|
||
1663903852);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (117, 0, 'M', '租户管理', 'local-icon-user_biaoqian', 900, '', 'tenant', '', '', '', 0, 1, 0, 1663904351,
|
||
1724998415);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (118, 117, 'C', '租户列表', 'local-icon-user_guanli', 100, 'user.user/lists', 'lists', 'tenant/lists/index',
|
||
'', '', 0, 1, 0, 1663904392, 1724998428);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (143, 35, 'C', '定时任务', '', 100, 'crontab.crontab/lists', 'scheduled_task',
|
||
'setting/system/scheduled_task/index', '', '', 0, 1, 0, 1669357509, 1710473246);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (144, 35, 'C', '定时任务添加/编辑', '', 0, 'crontab.crontab/add:edit', 'scheduled_task/edit',
|
||
'setting/system/scheduled_task/edit', '/setting/system/scheduled_task', '', 0, 0, 0, 1669357670, 1669357765);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (145, 143, 'A', '添加', '', 0, 'crontab.crontab/add', '', '', '', '', 0, 1, 0, 1669358282, 1669358282);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (146, 143, 'A', '编辑', '', 0, 'crontab.crontab/edit', '', '', '', '', 0, 1, 0, 1669358303, 1669358303);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (147, 143, 'A', '删除', '', 0, 'crontab.crontab/delete', '', '', '', '', 0, 1, 0, 1669358334, 1669358334);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (158, 0, 'M', '应用管理', 'el-icon-Postcard', 800, '', 'app', '', '', '', 0, 1, 0, 1677143430, 1710472079);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (161, 28, 'M', '支付设置', 'local-icon-set_pay', 80, '', 'pay', '', '', '', 0, 1, 1, 1677148075, 1710473061);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (162, 161, 'C', '支付方式', '', 0, 'setting.pay.pay_way/getPayWay', 'method', 'setting/pay/method/index', '', '',
|
||
0, 1, 0, 1677148207, 1677148207);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (163, 161, 'C', '支付配置', '', 0, 'setting.pay.pay_config/lists', 'config', 'setting/pay/config/index', '', '',
|
||
0, 1, 0, 1677148260, 1677148374);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (164, 162, 'A', '设置支付方式', '', 0, 'setting.pay.pay_way/setPayWay', '', '', '', '', 0, 1, 0, 1677219624,
|
||
1677219624);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (165, 163, 'A', '配置', '', 0, 'setting.pay.pay_config/setConfig', '', '', '', '', 0, 1, 0, 1677219655,
|
||
1677219655);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (166, 118, 'A', '新增租户', '', 0, 'tenant.tenant/add', '', '', '', '', 1, 1, 0, 1726822307, 1726822435);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (167, 118, 'A', '编辑租户', '', 0, 'tenant.tenant/edit', '', '', '', '', 1, 1, 0, 1726822372, 1726822440);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (168, 118, 'A', '租户详情', '', 0, 'tenant.tenant/detail', '', '', '', '', 1, 1, 0, 1726822396, 1726822444);
|
||
INSERT INTO `la_system_menu`
|
||
VALUES (169, 118, 'A', '删除租户', '', 0, 'tenant.tenant/delete', '', '', '', '', 1, 1, 0, 1726822416, 1726822449);
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_system_role
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_system_role`;
|
||
CREATE TABLE `la_system_role`
|
||
(
|
||
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`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_system_role_menu
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_system_role_menu`;
|
||
CREATE TABLE `la_system_role_menu`
|
||
(
|
||
`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_tenant
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_tenant`;
|
||
CREATE TABLE `la_tenant`
|
||
(
|
||
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`sn` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '编号',
|
||
`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 '租户头像',
|
||
`tel` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系方式',
|
||
`disable` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT '是否禁用：0-否；1-是；',
|
||
`tactics` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '分表策略: [0=否, 1=是]',
|
||
`notes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '租户备注',
|
||
`domain_alias` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '域名别名',
|
||
`domain_alias_enable` tinyint(10) NOT NULL DEFAULT 1 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 = 1
|
||
CHARACTER SET = utf8mb4
|
||
COLLATE = utf8mb4_general_ci COMMENT = '租户表'
|
||
ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_tenant_admin
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_tenant_admin`;
|
||
CREATE TABLE `la_tenant_admin`
|
||
(
|
||
`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 = 1
|
||
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`;
|
||
CREATE TABLE `la_tenant_admin_dept`
|
||
(
|
||
`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`;
|
||
CREATE TABLE `la_tenant_admin_jobs`
|
||
(
|
||
`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`;
|
||
CREATE TABLE `la_tenant_admin_role`
|
||
(
|
||
`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`;
|
||
CREATE TABLE `la_tenant_admin_session`
|
||
(
|
||
`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`;
|
||
CREATE TABLE `la_tenant_config`
|
||
(
|
||
`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`;
|
||
CREATE TABLE `la_tenant_dept`
|
||
(
|
||
`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 = 2
|
||
CHARACTER SET = utf8mb4
|
||
COLLATE = utf8mb4_general_ci COMMENT = '租户部门表'
|
||
ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of la_tenant_dept
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `la_tenant_dept`
|
||
VALUES (1, 0, '公司', 0, 0, 'boss', '12345698745', 1, 1650592684, 1653640368, NULL);
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_tenant_file
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_tenant_file`;
|
||
CREATE TABLE `la_tenant_file`
|
||
(
|
||
`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`;
|
||
CREATE TABLE `la_tenant_file_cate`
|
||
(
|
||
`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`;
|
||
CREATE TABLE `la_tenant_jobs`
|
||
(
|
||
`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`;
|
||
CREATE TABLE `la_tenant_notice_record`
|
||
(
|
||
`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`;
|
||
CREATE TABLE `la_tenant_notice_setting`
|
||
(
|
||
`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 = 6
|
||
CHARACTER SET = utf8mb4
|
||
COLLATE = utf8mb4_general_ci COMMENT = '通知设置表'
|
||
ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of la_tenant_notice_setting
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `la_tenant_notice_setting`
|
||
VALUES (1, 0, 101, '登录验证码', '用户手机号码登录时发送', 1, 2,
|
||
'{\"type\":\"system\",\"title\":\"\",\"content\":\"\",\"status\":\"0\",\"is_show\":\"\",\"tips\":[\"可选变量 验证码:code\"]}',
|
||
'{\"type\":\"sms\",\"template_id\":\"SMS_123456\",\"content\":\"您正在登录，验证码${code}，切勿将验证码泄露于他人，本条验证码有效期5分钟。\",\"status\":\"1\",\"is_show\":\"1\"}',
|
||
'{\"type\":\"oa\",\"template_id\":\"\",\"template_sn\":\"\",\"name\":\"\",\"first\":\"\",\"remark\":\"\",\"tpl\":[],\"status\":\"0\",\"is_show\":\"\",\"tips\":[\"可选变量 验证码:code\",\"配置路径：小程序后台 > 功能 > 订阅消息\"]}',
|
||
'{\"type\":\"mnp\",\"template_id\":\"\",\"template_sn\":\"\",\"name\":\"\",\"tpl\":[],\"status\":\"0\",\"is_show\":\"\",\"tips\":[\"可选变量 验证码:code\",\"配置路径：小程序后台 > 功能 > 订阅消息\"]}',
|
||
'2', NULL);
|
||
INSERT INTO `la_tenant_notice_setting`
|
||
VALUES (2, 0, 102, '绑定手机验证码', '用户绑定手机号码时发送', 1, 2,
|
||
'{\"type\":\"system\",\"title\":\"\",\"content\":\"\",\"status\":\"0\",\"is_show\":\"\"}',
|
||
'{\"type\":\"sms\",\"template_id\":\"SMS_123456\",\"content\":\"您正在绑定手机号，验证码${code}，切勿将验证码泄露于他人，本条验证码有效期5分钟。\",\"status\":\"1\",\"is_show\":\"1\"}',
|
||
'{\"type\":\"oa\",\"template_id\":\"\",\"template_sn\":\"\",\"name\":\"\",\"first\":\"\",\"remark\":\"\",\"tpl\":[],\"status\":\"0\",\"is_show\":\"\"}',
|
||
'{\"type\":\"mnp\",\"template_id\":\"\",\"template_sn\":\"\",\"name\":\"\",\"tpl\":[],\"status\":\"0\",\"is_show\":\"\"}',
|
||
'2', NULL);
|
||
INSERT INTO `la_tenant_notice_setting`
|
||
VALUES (3, 0, 103, '变更手机验证码', '用户变更手机号码时发送', 1, 2,
|
||
'{\"type\":\"system\",\"title\":\"\",\"content\":\"\",\"status\":\"0\",\"is_show\":\"\",\"tips\":[\"可选变量 验证码:code\"]}',
|
||
'{\"type\":\"sms\",\"template_id\":\"SMS_123456\",\"content\":\"您正在变更手机号，验证码${code}，切勿将验证码泄露于他人，本条验证码有效期5分钟。\",\"status\":\"1\",\"is_show\":\"1\"}',
|
||
'{\"type\":\"oa\",\"template_id\":\"\",\"template_sn\":\"\",\"name\":\"\",\"first\":\"\",\"remark\":\"\",\"tpl\":[],\"status\":\"0\",\"is_show\":\"\",\"tips\":[\"可选变量 验证码:code\",\"配置路径：小程序后台 > 功能 > 订阅消息\"]}',
|
||
'{\"type\":\"mnp\",\"template_id\":\"\",\"template_sn\":\"\",\"name\":\"\",\"tpl\":[],\"status\":\"0\",\"is_show\":\"\",\"tips\":[\"可选变量 验证码:code\",\"配置路径：小程序后台 > 功能 > 订阅消息\"]}',
|
||
'2', NULL);
|
||
INSERT INTO `la_tenant_notice_setting`
|
||
VALUES (4, 0, 104, '找回登录密码验证码', '用户找回登录密码号码时发送', 1, 2,
|
||
'{\"type\":\"system\",\"title\":\"\",\"content\":\"\",\"status\":\"0\",\"is_show\":\"\",\"tips\":[\"可选变量 验证码:code\"]}',
|
||
'{\"type\":\"sms\",\"template_id\":\"SMS_123456\",\"content\":\"您正在找回登录密码，验证码${code}，切勿将验证码泄露于他人，本条验证码有效期5分钟。\",\"status\":\"0\",\"is_show\":\"1\",\"tips\":[\"可选变量 验证码:code\",\"示例：您正在找回登录密码，验证码${code}，切勿将验证码泄露于他人，本条验证码有效期5分钟。\",\"生效条件：1、管理后台完成短信设置。 2、第三方短信平台申请模板。\"]}',
|
||
'{\"type\":\"oa\",\"template_id\":\"\",\"template_sn\":\"\",\"name\":\"\",\"first\":\"\",\"remark\":\"\",\"tpl\":[],\"status\":\"0\",\"is_show\":\"\",\"tips\":[\"可选变量 验证码:code\",\"配置路径：小程序后台 > 功能 > 订阅消息\"]}',
|
||
'{\"type\":\"mnp\",\"template_id\":\"\",\"template_sn\":\"\",\"name\":\"\",\"tpl\":[],\"status\":\"0\",\"is_show\":\"\",\"tips\":[\"可选变量 验证码:code\",\"配置路径：小程序后台 > 功能 > 订阅消息\"]}',
|
||
'2', NULL);
|
||
INSERT INTO `la_tenant_notice_setting`
|
||
VALUES (5, 0, 105, '注册验证码', '用户注册账号时发送', 1, 2,
|
||
'{\"type\":\"system\",\"title\":\"\",\"content\":\"\",\"status\":\"0\",\"is_show\":\"\",\"tips\":[\"可选变量 验证码:code\"]}',
|
||
'{\"type\":\"sms\",\"template_id\":\"SMS_175615071\",\"content\":\"验证码${code}，您正在注册成为新用户，感谢您的支持！\",\"status\":\"1\",\"is_show\":\"1\",\"tips\":[\"可选变量 验证码:code\",\"示例：您正在申请注册，验证码${code}，切勿将验证码泄露于他人，本条验证码有效期5分钟。\",\"生效条件：1、管理后台完成短信设置。 2、第三方短信平台申请模板。\"]}',
|
||
'{\"type\":\"oa\",\"template_id\":\"\",\"template_sn\":\"\",\"name\":\"\",\"first\":\"\",\"remark\":\"\",\"tpl\":[],\"status\":\"0\",\"is_show\":\"\",\"tips\":[\"可选变量 验证码:code\",\"配置路径：小程序后台 > 功能 > 订阅消息\"]}',
|
||
'{\"type\":\"mnp\",\"template_id\":\"\",\"template_sn\":\"\",\"name\":\"\",\"tpl\":[],\"status\":\"0\",\"is_show\":\"\",\"tips\":[\"可选变量 验证码:code\",\"配置路径：小程序后台 > 功能 > 订阅消息\"]}',
|
||
'2', NULL);
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_tenant_pay_config
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_tenant_pay_config`;
|
||
CREATE TABLE `la_tenant_pay_config`
|
||
(
|
||
`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 = 4
|
||
CHARACTER SET = utf8mb4
|
||
COLLATE = utf8mb4_general_ci COMMENT = '支付配置表'
|
||
ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of la_tenant_pay_config
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `la_tenant_pay_config`
|
||
VALUES (1, 0, '余额支付', 1, '', 'resource/image/common/balance_pay.png', 128, '余额支付备注');
|
||
INSERT INTO `la_tenant_pay_config`
|
||
VALUES (2, 0, '微信支付', 2,
|
||
'{\"interface_version\":\"v3\",\"merchant_type\":\"ordinary_merchant\",\"mch_id\":\"\",\"pay_sign_key\":\"\",\"apiclient_cert\":\"\",\"apiclient_key\":\"\"}',
|
||
'/resource/image/common/wechat_pay.png', 123, '微信支付备注');
|
||
INSERT INTO `la_tenant_pay_config`
|
||
VALUES (3, 0, '支付宝支付', 3,
|
||
'{\"mode\":\"normal_mode\",\"merchant_type\":\"ordinary_merchant\",\"app_id\":\"\",\"private_key\":\"\",\"ali_public_key\":\"\"}',
|
||
'/resource/image/common/ali_pay.png', 123, '支付宝支付');
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_tenant_pay_way
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_tenant_pay_way`;
|
||
CREATE TABLE `la_tenant_pay_way`
|
||
(
|
||
`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 = 8
|
||
CHARACTER SET = utf8mb4
|
||
COLLATE = utf8mb4_general_ci COMMENT = '支付方式表'
|
||
ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_tenant_sms_log
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_tenant_sms_log`;
|
||
CREATE TABLE `la_tenant_sms_log`
|
||
(
|
||
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
`tenant_id` int(11) NOT NULL 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) DEFAULT NULL COMMENT '发送关键字（注册、找回密码）',
|
||
`is_verify` tinyint(1) DEFAULT '0' COMMENT '是否已验证；0-否；1-是',
|
||
`check_num` int(5) DEFAULT '0' COMMENT '验证次数',
|
||
`send_status` tinyint(1) NOT NULL COMMENT '发送状态：0-发送中；1-发送成功；2-发送失败',
|
||
`send_time` int(10) NOT NULL COMMENT '发送时间',
|
||
`results` text COMMENT '短信结果',
|
||
`create_time` int(10) DEFAULT NULL COMMENT '创建时间',
|
||
`update_time` int(10) DEFAULT NULL COMMENT '更新时间',
|
||
`delete_time` int(10) DEFAULT NULL COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='租户短信记录表';
|
||
|
||
-- ----------------------------
|
||
-- Records of la_tenant_pay_way
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `la_tenant_pay_way`
|
||
VALUES (1, 0, 1, 1, 0, 1);
|
||
INSERT INTO `la_tenant_pay_way`
|
||
VALUES (2, 0, 2, 1, 1, 1);
|
||
INSERT INTO `la_tenant_pay_way`
|
||
VALUES (3, 0, 1, 2, 0, 1);
|
||
INSERT INTO `la_tenant_pay_way`
|
||
VALUES (4, 0, 2, 2, 1, 1);
|
||
INSERT INTO `la_tenant_pay_way`
|
||
VALUES (5, 0, 1, 3, 0, 1);
|
||
INSERT INTO `la_tenant_pay_way`
|
||
VALUES (6, 0, 2, 3, 1, 1);
|
||
INSERT INTO `la_tenant_pay_way`
|
||
VALUES (7, 0, 3, 3, 0, 1);
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_tenant_system_menu
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_tenant_system_menu`;
|
||
CREATE TABLE `la_tenant_system_menu`
|
||
(
|
||
`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 = 178
|
||
CHARACTER SET = utf8mb4
|
||
COLLATE = utf8mb4_general_ci COMMENT = '系统菜单表'
|
||
ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of la_tenant_system_menu
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (4, 0, 0, 'M', '权限管理', 'el-icon-Lock', 300, '', 'permission', '', '', '', 0, 1, 0, 1656664556, 1710472802);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (5, 0, 0, 'C', '工作台', 'el-icon-Monitor', 1000, 'workbench/index', 'workbench', 'workbench/index', '', '', 0,
|
||
1, 0, 1656664793, 1664354981);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (6, 0, 4, 'C', '菜单', 'el-icon-Operation', 100, 'auth.menu/lists', 'menu', 'permission/menu/index', '', '', 1,
|
||
1, 0, 1656664960, 1710472994);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (7, 0, 4, 'C', '管理员', 'local-icon-shouyiren', 80, 'auth.admin/lists', 'admin', 'permission/admin/index', '',
|
||
'', 0, 1, 0, 1656901567, 1710473013);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (8, 0, 4, 'C', '角色', 'el-icon-Female', 90, 'auth.role/lists', 'role', 'permission/role/index', '', '', 0, 1, 0,
|
||
1656901660, 1710473000);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (12, 0, 8, 'A', '新增', '', 1, 'auth.role/add', '', '', '', '', 0, 1, 0, 1657001790, 1663750625);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (14, 0, 8, 'A', '编辑', '', 1, 'auth.role/edit', '', '', '', '', 0, 1, 0, 1657001924, 1663750631);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (15, 0, 8, 'A', '删除', '', 1, 'auth.role/delete', '', '', '', '', 0, 1, 0, 1657001982, 1663750637);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (16, 0, 6, 'A', '新增', '', 1, 'auth.menu/add', '', '', '', '', 0, 1, 0, 1657072523, 1663750565);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (17, 0, 6, 'A', '编辑', '', 1, 'auth.menu/edit', '', '', '', '', 0, 1, 0, 1657073955, 1663750570);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (18, 0, 6, 'A', '删除', '', 1, 'auth.menu/delete', '', '', '', '', 0, 1, 0, 1657073987, 1663750578);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (19, 0, 7, 'A', '新增', '', 1, 'auth.admin/add', '', '', '', '', 0, 1, 0, 1657074035, 1663750596);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (20, 0, 7, 'A', '编辑', '', 1, 'auth.admin/edit', '', '', '', '', 0, 1, 0, 1657074071, 1663750603);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (21, 0, 7, 'A', '删除', '', 1, 'auth.admin/delete', '', '', '', '', 0, 1, 0, 1657074108, 1663750609);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (25, 0, 0, 'M', '组织管理', 'el-icon-OfficeBuilding', 400, '', 'organization', '', '', '', 0, 1, 0, 1657099914,
|
||
1710472797);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (26, 0, 25, 'C', '部门管理', 'el-icon-Coordinate', 100, 'dept.dept/lists', 'department',
|
||
'organization/department/index', '', '', 1, 1, 0, 1657099989, 1710472962);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (27, 0, 25, 'C', '岗位管理', 'el-icon-PriceTag', 90, 'dept.jobs/lists', 'post', 'organization/post/index', '',
|
||
'', 0, 1, 0, 1657100044, 1710472967);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (28, 0, 0, 'M', '系统设置', 'el-icon-Setting', 200, '', 'setting', '', '', '', 0, 1, 0, 1657100164, 1710472807);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (29, 0, 28, 'M', '网站设置', 'el-icon-Basketball', 100, '', 'website', '', '', '', 0, 1, 0, 1657100230,
|
||
1710473049);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (30, 0, 29, 'C', '网站信息', '', 1, 'setting.web.web_setting/getWebsite', 'information',
|
||
'setting/website/information', '', '', 0, 1, 0, 1657100306, 1657164412);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (31, 0, 29, 'C', '网站备案', '', 1, 'setting.web.web_setting/getCopyright', 'filing', 'setting/website/filing',
|
||
'', '', 0, 1, 0, 1657100434, 1657164723);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (32, 0, 29, 'C', '政策协议', '', 1, 'setting.web.web_setting/getAgreement', 'protocol',
|
||
'setting/website/protocol', '', '', 0, 1, 0, 1657100571, 1657164770);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (35, 0, 28, 'M', '系统维护', 'el-icon-SetUp', 50, '', 'system', '', '', '', 0, 1, 0, 1657161569, 1710473122);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (37, 0, 35, 'C', '系统缓存', '', 80, '', 'cache', 'setting/system/cache', '', '', 0, 1, 0, 1657161896,
|
||
1710473258);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (45, 0, 26, 'A', '新增', '', 1, 'dept.dept/add', '', '', '', '', 0, 1, 0, 1657163548, 1663750492);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (46, 0, 26, 'A', '编辑', '', 1, 'dept.dept/edit', '', '', '', '', 0, 1, 0, 1657163599, 1663750498);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (47, 0, 26, 'A', '删除', '', 1, 'dept.dept/delete', '', '', '', '', 0, 1, 0, 1657163687, 1663750504);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (48, 0, 27, 'A', '新增', '', 1, 'dept.jobs/add', '', '', '', '', 0, 1, 0, 1657163778, 1663750524);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (49, 0, 27, 'A', '编辑', '', 1, 'dept.jobs/edit', '', '', '', '', 0, 1, 0, 1657163800, 1663750530);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (50, 0, 27, 'A', '删除', '', 1, 'dept.jobs/delete', '', '', '', '', 0, 1, 0, 1657163820, 1663750535);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (51, 0, 30, 'A', '保存', '', 1, 'setting.web.web_setting/setWebsite', '', '', '', '', 0, 1, 0, 1657164469,
|
||
1663750649);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (52, 0, 31, 'A', '保存', '', 1, 'setting.web.web_setting/setCopyright', '', '', '', '', 0, 1, 0, 1657164692,
|
||
1663750657);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (53, 0, 32, 'A', '保存', '', 1, 'setting.web.web_setting/setAgreement', '', '', '', '', 0, 1, 0, 1657164824,
|
||
1663750665);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (61, 0, 37, 'A', '清除系统缓存', '', 1, 'setting.system.cache/clear', '', '', '', '', 0, 1, 0, 1657173837,
|
||
1657173939);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (63, 0, 158, 'M', '素材管理', 'el-icon-Picture', 0, '', 'material', '', '', '', 0, 1, 0, 1657507133, 1710472243);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (64, 0, 63, 'C', '素材中心', 'el-icon-PictureRounded', 0, '', 'index', 'material/index', '', '', 0, 1, 0,
|
||
1657507296, 1664355653);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (66, 0, 26, 'A', '详情', '', 0, 'dept.dept/detail', '', '', '', '', 0, 1, 0, 1663725459, 1663750516);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (67, 0, 27, 'A', '详情', '', 0, 'dept.jobs/detail', '', '', '', '', 0, 1, 0, 1663725514, 1663750559);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (68, 0, 6, 'A', '详情', '', 0, 'auth.menu/detail', '', '', '', '', 0, 1, 0, 1663725564, 1663750584);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (69, 0, 7, 'A', '详情', '', 0, 'auth.admin/detail', '', '', '', '', 0, 1, 0, 1663725623, 1663750615);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (70, 0, 158, 'M', '文章资讯', 'el-icon-ChatLineSquare', 90, '', 'article', '', '', '', 0, 1, 0, 1663749965,
|
||
1710471867);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (71, 0, 70, 'C', '文章管理', 'el-icon-ChatDotSquare', 0, 'article.article/lists', 'lists', 'article/lists/index',
|
||
'', '', 0, 1, 0, 1663750101, 1664354615);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (72, 0, 70, 'C', '文章添加/编辑', '', 0, 'article.article/add:edit', 'lists/edit', 'article/lists/edit',
|
||
'/article/lists', '', 0, 0, 0, 1663750153, 1664356275);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (73, 0, 70, 'C', '文章栏目', 'el-icon-CollectionTag', 0, 'article.articleCate/lists', 'column',
|
||
'article/column/index', '', '', 1, 1, 0, 1663750287, 1664354678);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (74, 0, 71, 'A', '新增', '', 0, 'article.article/add', '', '', '', '', 0, 1, 0, 1663750335, 1663750335);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (75, 0, 71, 'A', '详情', '', 0, 'article.article/detail', '', '', '', '', 0, 1, 0, 1663750354, 1663750383);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (76, 0, 71, 'A', '删除', '', 0, 'article.article/delete', '', '', '', '', 0, 1, 0, 1663750413, 1663750413);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (77, 0, 71, 'A', '修改状态', '', 0, 'article.article/updateStatus', '', '', '', '', 0, 1, 0, 1663750442,
|
||
1663750442);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (78, 0, 73, 'A', '添加', '', 0, 'article.articleCate/add', '', '', '', '', 0, 1, 0, 1663750483, 1663750483);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (79, 0, 73, 'A', '删除', '', 0, 'article.articleCate/delete', '', '', '', '', 0, 1, 0, 1663750895, 1663750895);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (80, 0, 73, 'A', '详情', '', 0, 'article.articleCate/detail', '', '', '', '', 0, 1, 0, 1663750913, 1663750913);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (81, 0, 73, 'A', '修改状态', '', 0, 'article.articleCate/updateStatus', '', '', '', '', 0, 1, 0, 1663750936,
|
||
1663750936);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (82, 0, 0, 'M', '渠道设置', 'el-icon-Message', 500, '', 'channel', '', '', '', 0, 1, 0, 1663754084, 1710472649);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (83, 0, 82, 'C', 'h5设置', 'el-icon-Cellphone', 100, 'channel.web_page_setting/getConfig', 'h5', 'channel/h5',
|
||
'', '', 0, 1, 0, 1663754158, 1710472929);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (84, 0, 83, 'A', '保存', '', 0, 'channel.web_page_setting/setConfig', '', '', '', '', 0, 1, 0, 1663754259,
|
||
1663754259);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (85, 0, 82, 'M', '微信公众号', 'local-icon-dingdan', 80, '', 'wx_oa', '', '', '', 0, 1, 0, 1663755470,
|
||
1710472946);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (86, 0, 85, 'C', '公众号配置', '', 0, 'channel.official_account_setting/getConfig', 'config',
|
||
'channel/wx_oa/config', '', '', 0, 1, 0, 1663755663, 1664355450);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (87, 0, 85, 'C', '菜单管理', '', 0, 'channel.official_account_menu/detail', 'menu', 'channel/wx_oa/menu', '', '',
|
||
0, 1, 0, 1663755767, 1664355456);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (88, 0, 86, 'A', '保存', '', 0, 'channel.official_account_setting/setConfig', '', '', '', '', 0, 1, 0,
|
||
1663755799, 1663755799);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (89, 0, 86, 'A', '保存并发布', '', 0, 'channel.official_account_menu/save', '', '', '', '', 0, 1, 0, 1663756490,
|
||
1663756490);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (90, 0, 85, 'C', '关注回复', '', 0, 'channel.official_account_reply/lists', 'follow',
|
||
'channel/wx_oa/reply/follow_reply', '', '', 0, 1, 0, 1663818358, 1663818366);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (91, 0, 85, 'C', '关键字回复', '', 0, '', 'keyword', 'channel/wx_oa/reply/keyword_reply', '', '', 0, 1, 0,
|
||
1663818445, 1663818445);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (93, 0, 85, 'C', '默认回复', '', 0, '', 'default', 'channel/wx_oa/reply/default_reply', '', '', 0, 1, 0,
|
||
1663818580, 1663818580);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (94, 0, 82, 'C', '微信小程序', 'local-icon-weixin', 90, 'channel.mnp_settings/getConfig', 'weapp',
|
||
'channel/weapp', '', '', 0, 1, 0, 1663831396, 1710472941);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (95, 0, 94, 'A', '保存', '', 0, 'channel.mnp_settings/setConfig', '', '', '', '', 0, 1, 0, 1663831436,
|
||
1663831436);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (96, 0, 0, 'M', '装修管理', 'el-icon-Brush', 600, '', 'decoration', '', '', '', 0, 1, 0, 1663834825, 1710472099);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (97, 0, 175, 'C', '页面装修', 'el-icon-CopyDocument', 100, 'decorate.page/detail', 'pages',
|
||
'decoration/pages/index', '', '', 0, 1, 0, 1663834879, 1710929256);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (98, 0, 97, 'A', '保存', '', 0, 'decorate.page/save', '', '', '', '', 0, 1, 0, 1663834956, 1663834956);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (99, 0, 175, 'C', '底部导航', 'el-icon-Position', 90, 'decorate.tabbar/detail', 'tabbar', 'decoration/tabbar',
|
||
'', '', 0, 1, 0, 1663835004, 1710929262);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (100, 0, 99, 'A', '保存', '', 0, 'decorate.tabbar/save', '', '', '', '', 0, 1, 0, 1663835018, 1663835018);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (101, 0, 158, 'M', '消息管理', 'el-icon-ChatDotRound', 80, '', 'message', '', '', '', 0, 1, 0, 1663838602,
|
||
1710471874);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (102, 0, 101, 'C', '通知设置', '', 0, 'notice.notice/settingLists', 'notice', 'message/notice/index', '', '', 0,
|
||
1, 0, 1663839195, 1663839195);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (103, 0, 102, 'A', '详情', '', 0, 'notice.notice/detail', '', '', '', '', 0, 1, 0, 1663839537, 1663839537);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (104, 0, 101, 'C', '通知设置编辑', '', 0, 'notice.notice/set', 'notice/edit', 'message/notice/edit',
|
||
'/message/notice', '', 0, 0, 0, 1663839873, 1663898477);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (105, 0, 71, 'A', '编辑', '', 0, 'article.article/edit', '', '', '', '', 0, 1, 0, 1663840043, 1663840053);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (107, 0, 101, 'C', '短信设置', '', 0, 'notice.sms_config/getConfig', 'short_letter',
|
||
'message/short_letter/index', '', '', 0, 1, 0, 1663898591, 1664355708);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (108, 0, 107, 'A', '设置', '', 0, 'notice.sms_config/setConfig', '', '', '', '', 0, 1, 0, 1663898644,
|
||
1663898644);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (109, 0, 107, 'A', '详情', '', 0, 'notice.sms_config/detail', '', '', '', '', 0, 1, 0, 1663898661, 1663898661);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (110, 0, 28, 'C', '热门搜索', 'el-icon-Search', 60, 'setting.hot_search/getConfig', 'search',
|
||
'setting/search/index', '', '', 0, 1, 0, 1663901821, 1710473109);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (111, 0, 110, 'A', '保存', '', 0, 'setting.hot_search/setConfig', '', '', '', '', 0, 1, 0, 1663901856,
|
||
1663901856);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (112, 0, 28, 'M', '用户设置', 'local-icon-keziyuyue', 90, '', 'user', '', '', '', 0, 1, 0, 1663903302,
|
||
1710473056);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (113, 0, 112, 'C', '用户设置', '', 0, 'setting.user.user/getConfig', 'setup', 'setting/user/setup', '', '', 0, 1,
|
||
0, 1663903506, 1663903506);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (114, 0, 113, 'A', '保存', '', 0, 'setting.user.user/setConfig', '', '', '', '', 0, 1, 0, 1663903522,
|
||
1663903522);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (115, 0, 112, 'C', '登录注册', '', 0, 'setting.user.user/getRegisterConfig', 'login_register',
|
||
'setting/user/login_register', '', '', 0, 1, 0, 1663903832, 1663903832);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (116, 0, 115, 'A', '保存', '', 0, 'setting.user.user/setRegisterConfig', '', '', '', '', 0, 1, 0, 1663903852,
|
||
1663903852);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (117, 0, 0, 'M', '用户管理', 'el-icon-User', 900, '', 'consumer', '', '', '', 0, 1, 0, 1663904351, 1710472074);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (118, 0, 117, 'C', '用户列表', 'local-icon-user_guanli', 100, 'user.user/lists', 'lists', 'consumer/lists/index',
|
||
'', '', 0, 1, 0, 1663904392, 1710471845);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (119, 0, 117, 'C', '用户详情', '', 90, 'user.user/detail', 'lists/detail', 'consumer/lists/detail',
|
||
'/consumer/lists', '', 0, 0, 0, 1663904470, 1710471851);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (120, 0, 119, 'A', '编辑', '', 0, 'user.user/edit', '', '', '', '', 0, 1, 0, 1663904499, 1663904499);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (140, 0, 82, 'C', '微信开放平台', 'local-icon-notice_buyer', 70, 'channel.open_setting/getConfig',
|
||
'open_setting', 'channel/open_setting', '', '', 0, 1, 0, 1666085713, 1710472951);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (141, 0, 140, 'A', '保存', '', 0, 'channel.open_setting/setConfig', '', '', '', '', 0, 1, 0, 1666085751,
|
||
1666085776);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (142, 0, 176, 'C', 'PC端装修', 'el-icon-Monitor', 8, '', 'pc', 'decoration/pc', '', '', 0, 1, 0, 1668423284,
|
||
1710901602);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (148, 0, 0, 'M', '模板示例', 'el-icon-SetUp', 100, '', 'template', '', '', '', 0, 1, 0, 1670206819, 1710472811);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (149, 0, 148, 'M', '组件示例', 'el-icon-Coin', 0, '', 'component', '', '', '', 0, 1, 0, 1670207182, 1670207244);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (150, 0, 149, 'C', '富文本', '', 90, '', 'rich_text', 'template/component/rich_text', '', '', 0, 1, 0,
|
||
1670207751, 1710473315);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (151, 0, 149, 'C', '上传文件', '', 80, '', 'upload', 'template/component/upload', '', '', 0, 1, 0, 1670208925,
|
||
1710473322);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (152, 0, 149, 'C', '图标', '', 100, '', 'icon', 'template/component/icon', '', '', 0, 1, 0, 1670230069,
|
||
1710473306);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (153, 0, 149, 'C', '文件选择器', '', 60, '', 'file', 'template/component/file', '', '', 0, 1, 0, 1670232129,
|
||
1710473341);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (154, 0, 149, 'C', '链接选择器', '', 50, '', 'link', 'template/component/link', '', '', 0, 1, 0, 1670292636,
|
||
1710473346);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (155, 0, 149, 'C', '超出自动打点', '', 40, '', 'overflow', 'template/component/overflow', '', '', 0, 1, 0,
|
||
1670292883, 1710473351);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (156, 0, 149, 'C', '悬浮input', '', 70, '', 'popover_input', 'template/component/popover_input', '', '', 0, 1, 0,
|
||
1670293336, 1710473329);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (157, 0, 119, 'A', '余额调整', '', 0, 'user.user/adjustMoney', '', '', '', '', 0, 1, 0, 1677143088, 1677143088);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (158, 0, 0, 'M', '应用管理', 'el-icon-Postcard', 800, '', 'app', '', '', '', 0, 1, 0, 1677143430, 1710472079);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (159, 0, 158, 'C', '用户充值', 'local-icon-fukuan', 100, 'recharge.recharge/getConfig', 'recharge',
|
||
'app/recharge/index', '', '', 0, 1, 0, 1677144284, 1710471860);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (160, 0, 159, 'A', '保存', '', 0, 'recharge.recharge/setConfig', '', '', '', '', 0, 1, 0, 1677145012,
|
||
1677145012);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (161, 0, 28, 'M', '支付设置', 'local-icon-set_pay', 80, '', 'pay', '', '', '', 0, 1, 0, 1677148075, 1710473061);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (162, 0, 161, 'C', '支付方式', '', 0, 'setting.pay.pay_way/getPayWay', 'method', 'setting/pay/method/index', '',
|
||
'', 0, 1, 0, 1677148207, 1677148207);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (163, 0, 161, 'C', '支付配置', '', 0, 'setting.pay.pay_config/lists', 'config', 'setting/pay/config/index', '',
|
||
'', 0, 1, 0, 1677148260, 1677148374);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (164, 0, 162, 'A', '设置支付方式', '', 0, 'setting.pay.pay_way/setPayWay', '', '', '', '', 0, 1, 0, 1677219624,
|
||
1677219624);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (165, 0, 163, 'A', '配置', '', 0, 'setting.pay.pay_config/setConfig', '', '', '', '', 0, 1, 0, 1677219655,
|
||
1677219655);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (166, 0, 0, 'M', '财务管理', 'local-icon-user_gaikuang', 700, '', 'finance', '', '', '', 0, 1, 0, 1677552269,
|
||
1710472085);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (167, 0, 166, 'C', '充值记录', 'el-icon-Wallet', 90, 'recharge.recharge/lists', 'recharge_record',
|
||
'finance/recharge_record', '', '', 0, 1, 0, 1677552757, 1710472902);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (168, 0, 166, 'C', '余额明细', 'local-icon-qianbao', 100, 'finance.account_log/lists', 'balance_details',
|
||
'finance/balance_details', '', '', 0, 1, 0, 1677552976, 1710472894);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (169, 0, 167, 'A', '退款', '', 0, 'recharge.recharge/refund', '', '', '', '', 0, 1, 0, 1677809715, 1677809715);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (170, 0, 166, 'C', '退款记录', 'local-icon-heshoujilu', 0, 'finance.refund/record', 'refund_record',
|
||
'finance/refund_record', '', '', 0, 1, 0, 1677811271, 1677811271);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (171, 0, 170, 'A', '重新退款', '', 0, 'recharge.recharge/refundAgain', '', '', '', '', 0, 1, 0, 1677811295,
|
||
1677811295);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (172, 0, 170, 'A', '退款日志', '', 0, 'finance.refund/log', '', '', '', '', 0, 1, 0, 1677811361, 1677811361);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (173, 0, 175, 'C', '系统风格', 'el-icon-Brush', 80, '', 'style', 'decoration/style/style', '', '', 0, 1, 0,
|
||
1681635044, 1710929278);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (175, 0, 96, 'M', '移动端', '', 100, '', 'mobile', '', '', '', 0, 1, 0, 1710901543, 1710929294);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (176, 0, 96, 'M', 'PC端', '', 90, '', 'pc', '', '', '', 0, 1, 0, 1710901592, 1710929299);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (177, 0,29, 'C', '站点统计', '', 0, 'setting.web.web_setting/getSiteStatistics', 'statistics', 'setting/website/statistics', '', '', 0, 1, 0, 1726841481, 1726843434);
|
||
INSERT INTO `la_tenant_system_menu`
|
||
VALUES (178, 0,177, 'A', '保存', '', 0, 'setting.web.web_setting/saveSiteStatistics', '', '', '', '', 1, 1, 0, 1726841507, 1726841507);
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_tenant_system_role
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_tenant_system_role`;
|
||
CREATE TABLE `la_tenant_system_role`
|
||
(
|
||
`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`;
|
||
CREATE TABLE `la_tenant_system_role_menu`
|
||
(
|
||
`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`;
|
||
CREATE TABLE `la_user`
|
||
(
|
||
`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`;
|
||
CREATE TABLE `la_user_account_log`
|
||
(
|
||
`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`;
|
||
CREATE TABLE `la_user_auth`
|
||
(
|
||
`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`;
|
||
CREATE TABLE `la_user_session`
|
||
(
|
||
`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;
|
||
|
||
-- ----------------------------
|
||
-- Records of la_user_session
|
||
-- ----------------------------
|
||
|
||
SET
|
||
FOREIGN_KEY_CHECKS = 1;
|