mirror of
https://gitee.com/luojinyi/likeadmin_go.git
synced 2025-09-27 04:36:22 +08:00
1321 lines
210 KiB
PL/PgSQL
1321 lines
210 KiB
PL/PgSQL
/*
|
||
Navicat Premium Data Transfer
|
||
|
||
Source Server : mooc.love本地
|
||
Source Server Type : MySQL
|
||
Source Server Version : 80028
|
||
Source Host : localhost:3306
|
||
Source Schema : byteadmin
|
||
|
||
Target Server Type : MySQL
|
||
Target Server Version : 80028
|
||
File Encoding : 65001
|
||
|
||
Date: 24/11/2023 00:54:25
|
||
*/
|
||
|
||
SET NAMES utf8mb4;
|
||
SET FOREIGN_KEY_CHECKS = 0;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_album
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_album`;
|
||
CREATE TABLE `la_album` (
|
||
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`cid` int unsigned NOT NULL DEFAULT '0' COMMENT '类目ID',
|
||
`aid` int unsigned NOT NULL DEFAULT '0' COMMENT '管理员ID',
|
||
`uid` int unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
|
||
`type` tinyint unsigned NOT NULL DEFAULT '10' COMMENT '文件类型: [10=图片, 20=视频]',
|
||
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '文件名称',
|
||
`uri` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文件路径',
|
||
`ext` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '文件扩展',
|
||
`size` int unsigned NOT NULL DEFAULT '0' COMMENT '文件大小',
|
||
`is_delete` int unsigned NOT NULL DEFAULT '0' COMMENT '是否删除: 0=否, 1=是',
|
||
`create_time` int unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
|
||
`update_time` int unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`delete_time` int unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `idx_cid` (`cid`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='相册管理表';
|
||
|
||
-- ----------------------------
|
||
-- Records of la_album
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `la_album` (`id`, `cid`, `aid`, `uid`, `type`, `name`, `uri`, `ext`, `size`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (1, 0, 1, 0, 10, '1.jpeg', 'image/20230711/e10e78f505a2403488b41b57a6e34777.jpeg', 'jpeg', 9416, 1, 1699287308, 1699287319, 1699287319);
|
||
INSERT INTO `la_album` (`id`, `cid`, `aid`, `uid`, `type`, `name`, `uri`, `ext`, `size`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (2, 0, 1, 0, 10, 'bytedotslogo.png', 'image/20230711/0a8143ea83244c74a6c456786a792988.png', 'png', 68390, 1, 1699287365, 1699540260, 1699540260);
|
||
INSERT INTO `la_album` (`id`, `cid`, `aid`, `uid`, `type`, `name`, `uri`, `ext`, `size`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (3, 0, 1, 0, 10, 'u=2725031792,168326554&fm=30&app=106&f=JPEG.jpeg', 'image/20230711/04706cf14a6e4161bac53822de1f166e.jpeg', 'jpeg', 44356, 1, 1699334610, 1699540257, 1699540257);
|
||
INSERT INTO `la_album` (`id`, `cid`, `aid`, `uid`, `type`, `name`, `uri`, `ext`, `size`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (4, 0, 1, 0, 10, 'backend_backdrop2.png', 'image/20230711/9678a22c7c4b40669354b5d88347c465.png', 'png', 193510, 1, 1699336440, 1699540253, 1699540253);
|
||
INSERT INTO `la_album` (`id`, `cid`, `aid`, `uid`, `type`, `name`, `uri`, `ext`, `size`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (5, 0, 1, 0, 10, 'metamaskico.png', 'image/20230911/7761e1fad64d4d849e476d35679797c7.png', 'png', 10830, 1, 1699512751, 1699540263, 1699540263);
|
||
INSERT INTO `la_album` (`id`, `cid`, `aid`, `uid`, `type`, `name`, `uri`, `ext`, `size`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (6, 0, 1, 0, 10, 'backend_backdrop2.png', 'image/20230911/7b289c2c902d45dda676044d6cd14439.png', 'png', 193510, 1, 1699540290, 1699552406, 1699552406);
|
||
INSERT INTO `la_album` (`id`, `cid`, `aid`, `uid`, `type`, `name`, `uri`, `ext`, `size`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (7, 2, 1, 0, 10, 'backend_backdrop2.png', 'image/20230911/c88ec3f53dd0425899682e56b11002d5.png', 'png', 193510, 1, 1699540355, 1700729562, 1700729562);
|
||
INSERT INTO `la_album` (`id`, `cid`, `aid`, `uid`, `type`, `name`, `uri`, `ext`, `size`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (8, 0, 1, 0, 10, 'WX20230811-010416@2x.png', 'image/20231611/872472ee657a4a4f9ae8aace06961b8d.png', 'png', 154496, 0, 1700113950, 1700113950, 0);
|
||
INSERT INTO `la_album` (`id`, `cid`, `aid`, `uid`, `type`, `name`, `uri`, `ext`, `size`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (9, 0, 1, 0, 10, 'WX20230811-005953@2x.png', 'image/20231611/dd2adfb1df364ec4ba2483297aead3e0.png', 'png', 166065, 0, 1700115795, 1700115795, 0);
|
||
INSERT INTO `la_album` (`id`, `cid`, `aid`, `uid`, `type`, `name`, `uri`, `ext`, `size`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (10, 0, 1, 0, 10, 'balance_pay.png', 'image/20231611/e037db90197c4a9a9a911ea7d75db690.png', 'png', 4362, 1, 1700130866, 1700132220, 1700132220);
|
||
INSERT INTO `la_album` (`id`, `cid`, `aid`, `uid`, `type`, `name`, `uri`, `ext`, `size`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (11, 0, 1, 0, 10, 'wechat_pay.png', 'image/20231611/f2b1e19d6e22463abfb161f1d87544fb.png', 'png', 6483, 1, 1700131773, 1700132223, 1700132223);
|
||
INSERT INTO `la_album` (`id`, `cid`, `aid`, `uid`, `type`, `name`, `uri`, `ext`, `size`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (12, 0, 1, 0, 10, 'alipay.png', 'image/20231611/a3f22d1b805c43d483e063399c846c40.png', 'png', 3204, 0, 1700132228, 1700132228, 0);
|
||
INSERT INTO `la_album` (`id`, `cid`, `aid`, `uid`, `type`, `name`, `uri`, `ext`, `size`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (13, 0, 1, 0, 10, 'balance.png', 'image/20231611/f15d9858074e4aa5ac99536f0c45a285.png', 'png', 3491, 0, 1700132264, 1700132264, 0);
|
||
INSERT INTO `la_album` (`id`, `cid`, `aid`, `uid`, `type`, `name`, `uri`, `ext`, `size`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (14, 0, 1, 0, 10, 'wechat.png', 'image/20231611/1022529df4d34afcb34d8624db3202ed.png', 'png', 2424, 0, 1700132313, 1700132313, 0);
|
||
INSERT INTO `la_album` (`id`, `cid`, `aid`, `uid`, `type`, `name`, `uri`, `ext`, `size`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (15, 0, 1, 0, 10, 'backend_backdrop.png', 'image/20232311/02b7e14dd1d1491a9907e98c8b35fb20.png', 'png', 85612, 1, 1700730929, 1700732213, 1700732213);
|
||
INSERT INTO `la_album` (`id`, `cid`, `aid`, `uid`, `type`, `name`, `uri`, `ext`, `size`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (16, 0, 1, 0, 10, 'backend_backdrop.png', 'image/20232311/c7f1a07a085e4da8b83e51701353f83e.png', 'png', 85612, 1, 1700732219, 1700735943, 1700735943);
|
||
INSERT INTO `la_album` (`id`, `cid`, `aid`, `uid`, `type`, `name`, `uri`, `ext`, `size`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (17, 0, 1, 0, 10, 'backend_backdrop.png', 'image/20232311/0541ca0252a048b9923d6b59ba7c98fb.png', 'png', 85612, 1, 1700749117, 1700749130, 1700749130);
|
||
INSERT INTO `la_album` (`id`, `cid`, `aid`, `uid`, `type`, `name`, `uri`, `ext`, `size`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (18, 0, 1, 0, 10, 'backend_backdrop.png', 'image/20232311/a2198101191a41f3ac16e98979aefbc1.png', 'png', 85612, 1, 1700749382, 1700749389, 1700749389);
|
||
INSERT INTO `la_album` (`id`, `cid`, `aid`, `uid`, `type`, `name`, `uri`, `ext`, `size`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (19, 0, 1, 0, 10, 'backend_backdrop2.png', 'image/20232311/c866ad10b2eb49d6af6f10d6ac706ade.png', 'png', 193510, 1, 1700749895, 1700749904, 1700749904);
|
||
INSERT INTO `la_album` (`id`, `cid`, `aid`, `uid`, `type`, `name`, `uri`, `ext`, `size`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (20, 0, 1, 0, 10, 'backend_backdrop.png', 'image/20232311/761d1722ce924c0a99ce1da4b460ac2c.png', 'png', 85612, 1, 1700749929, 1700749992, 1700749992);
|
||
INSERT INTO `la_album` (`id`, `cid`, `aid`, `uid`, `type`, `name`, `uri`, `ext`, `size`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (21, 0, 1, 0, 10, 'WX20230811-002454@2x.png', 'image/20232311/81326b3eff654735bfd91069248609ff.png', 'png', 158426, 1, 1700754054, 1700754137, 1700754137);
|
||
INSERT INTO `la_album` (`id`, `cid`, `aid`, `uid`, `type`, `name`, `uri`, `ext`, `size`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (22, 0, 1, 0, 10, 'WX20230811-003408@2x.png', 'image/20232311/ac3004cd8e434cd38cf85e5ded07bc02.png', 'png', 165623, 1, 1700754357, 1700754440, 1700754440);
|
||
INSERT INTO `la_album` (`id`, `cid`, `aid`, `uid`, `type`, `name`, `uri`, `ext`, `size`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (23, 0, 1, 0, 10, '04879a5cb178389f2c549ef42c2800c2.JPG', 'image/20232411/cbaf09afb2b346a6994d430ccd8894e8.jpg', 'jpg', 174997, 1, 1700757960, 1700758006, 1700758006);
|
||
INSERT INTO `la_album` (`id`, `cid`, `aid`, `uid`, `type`, `name`, `uri`, `ext`, `size`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (24, 0, 1, 0, 20, '19323.MP4', 'video/20232411/887a68c3399044848514975353a3b3e7.mp4', 'mp4', 6150581, 1, 1700758134, 1700758213, 1700758213);
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_album_cate
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_album_cate`;
|
||
CREATE TABLE `la_album_cate` (
|
||
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`pid` int unsigned NOT NULL DEFAULT '0' COMMENT '父级ID',
|
||
`type` tinyint unsigned NOT NULL DEFAULT '10' COMMENT '类型: [10=图片, 20=视频]',
|
||
`name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '分类名称',
|
||
`is_delete` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否删除: [0=否, 1=是]',
|
||
`create_time` int unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
|
||
`update_time` int unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`delete_time` int unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='相册分类表';
|
||
|
||
-- ----------------------------
|
||
-- Records of la_album_cate
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `la_album_cate` (`id`, `pid`, `type`, `name`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (1, 0, 10, '系统图片', 1, 1699540160, 1699540188, 1699540188);
|
||
INSERT INTO `la_album_cate` (`id`, `pid`, `type`, `name`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (2, 0, 10, '系统默认图片', 0, 1699540272, 1699540272, 0);
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_article
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_article`;
|
||
CREATE TABLE `la_article` (
|
||
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`cid` int unsigned NOT NULL COMMENT '分类',
|
||
`title` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '标题',
|
||
`intro` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '简介',
|
||
`summary` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '摘要',
|
||
`image` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '封面',
|
||
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '内容',
|
||
`author` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '作者',
|
||
`visit` int unsigned NOT NULL DEFAULT '0' COMMENT '浏览',
|
||
`sort` int unsigned NOT NULL DEFAULT '50' COMMENT '排序',
|
||
`is_show` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否显示: 0=否, 1=是',
|
||
`is_delete` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否删除: 0=否, 1=是',
|
||
`create_time` int unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
|
||
`update_time` int unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`delete_time` int unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `cid_idx` (`cid`) USING BTREE COMMENT '分类索引'
|
||
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='文章资讯表';
|
||
|
||
-- ----------------------------
|
||
-- Records of la_article
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `la_article` (`id`, `cid`, `title`, `intro`, `summary`, `image`, `content`, `author`, `visit`, `sort`, `is_show`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (1, 1, '让生活更精致！五款居家好物推荐，实用性超高', '##好物推荐🔥', '随着当代生活节奏的忙碌，很多人在闲暇之余都想好好的享受生活。随着科技的发展，也出现了越来越多可以帮助我们提升幸福感，让生活变得更精致的产品，下面周周就给大家盘点五款居家必备的好物，都是实用性很高的产品，周周可以保证大家买了肯定会喜欢。', '/api/static/article01.png', '<p><img src=\"https://likeadmin-java.yixiangonline.com/api/uploads/image/20220916/46d29489-4260-4917-8eca-d0f6cba6af23.png\" alt=\"\" data-href=\"\" style=\"\"/></p><p>拥有一台投影仪，闲暇时可以在家里直接看影院级别的大片，光是想想都觉得超级爽。市面上很多投影仪大几千，其实周周觉得没必要，选泰捷这款一千多的足够了，性价比非常高。</p><p>泰捷的专业度很高，在电视TV领域研发已经十年，有诸多专利和技术创新，荣获国内外多项技术奖项，拿下了腾讯创新工场投资，打造的泰捷视频TV端和泰捷电视盒子都获得了极高评价。</p><p>这款投影仪的分辨率在3000元内无敌，做到了真1080P高分辨率，也就是跟市场售价三千DLP投影仪一样的分辨率，真正做到了分毫毕现，像桌布的花纹、天空的云彩等，这些细节都清晰可见。</p><p>亮度方面，泰捷达到了850ANSI流明，同价位一般是200ANSI。这是因为泰捷为了提升亮度和LCD技术透射率低的问题，首创高功率LED灯源，让其亮度做到同价位最好。专业媒体也进行了多次对比，效果与3000元价位投影仪相当。</p><p>操作系统周周也很喜欢，完全不卡。泰捷作为资深音视频品牌，在系统优化方面有十年的研发经验，打造出的“零极”系统是业内公认效率最高、速度最快的系统，用户也评价它流畅度能一台顶三台，而且为了解决行业广告多这一痛点，系统内不植入任何广告。</p>', '红花', 9, 0, 1, 0, 1663317759, 1663322726, 0);
|
||
INSERT INTO `la_article` (`id`, `cid`, `title`, `intro`, `summary`, `image`, `content`, `author`, `visit`, `sort`, `is_show`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (2, 1, '埋葬UI设计师的坟墓不是内卷，而是免费模式', '', '本文从另外一个角度，聊聊作者对UI设计师职业发展前景的担忧，欢迎从事UI设计的同学来参与讨论，会有赠书哦', '/api/static/article02.jpeg', '<p><br></p><p style=\"text-align: justify;\">一个职业，卷，根本就没什么大不了的，尤其是成熟且收入高的职业，不卷才不符合事物发展的规律。何况 UI 设计师的人力市场到今天也和 5 年前一样，还是停留在大型菜鸡互啄的场面。远不能和医疗、证券、教师或者演艺练习生相提并论。</p><p style=\"text-align: justify;\">真正会让我对 <a href=\"https://www.uisdc.com/tag/ui\" target=\"_blank\">UI</a> 设计师发展前景觉得悲观的事情就只有一件 —— 国内的互联网产品免费机制。这也是一个我一直以来想讨论的话题，就在这次写一写。</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>', '一一', 23, 0, 1, 0, 1663320938, 1663322854, 0);
|
||
INSERT INTO `la_article` (`id`, `cid`, `title`, `intro`, `summary`, `image`, `content`, `author`, `visit`, `sort`, `is_show`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (3, 2, '金山电池公布“沪广深市民绿色生活方式”调查结果', '', '60%以上受访者认为高质量的10分钟足以完成“自我充电”', '/api/static/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>', '中网资讯科技', 3, 0, 1, 0, 1663322665, 1663322665, 0);
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_article_category
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_article_category`;
|
||
CREATE TABLE `la_article_category` (
|
||
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`name` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '名称',
|
||
`sort` smallint unsigned NOT NULL DEFAULT '50' COMMENT '排序',
|
||
`is_show` tinyint unsigned NOT NULL DEFAULT '1' COMMENT '是否显示: 0=否, 1=是',
|
||
`is_delete` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否删除: 0=否, 1=是',
|
||
`create_time` int unsigned DEFAULT '0' COMMENT '创建时间',
|
||
`update_time` int unsigned DEFAULT '0' COMMENT '更新时间',
|
||
`delete_time` int unsigned DEFAULT '0' COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='文章分类表';
|
||
|
||
-- ----------------------------
|
||
-- Records of la_article_category
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `la_article_category` (`id`, `name`, `sort`, `is_show`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (1, '文章资讯', 0, 1, 0, 1663317280, 1663317282, 0);
|
||
INSERT INTO `la_article_category` (`id`, `name`, `sort`, `is_show`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (2, '社会热点', 0, 1, 0, 1663321464, 1663321494, 0);
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_article_collect
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_article_collect`;
|
||
CREATE TABLE `la_article_collect` (
|
||
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`user_id` int unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
|
||
`article_id` int unsigned NOT NULL DEFAULT '0' COMMENT '文章ID',
|
||
`is_delete` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否删除',
|
||
`create_time` int unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
|
||
`update_time` int unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`delete_time` int unsigned NOT NULL DEFAULT '0' COMMENT '是否删除',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='文章收藏表';
|
||
|
||
-- ----------------------------
|
||
-- Records of la_article_collect
|
||
-- ----------------------------
|
||
BEGIN;
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_decorate_page
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_decorate_page`;
|
||
CREATE TABLE `la_decorate_page` (
|
||
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`page_type` tinyint unsigned NOT NULL DEFAULT '10' COMMENT '页面类型',
|
||
`page_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '页面名称',
|
||
`page_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '页面数据',
|
||
`create_time` int unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
|
||
`update_time` int unsigned NOT NULL COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='页面装修表';
|
||
|
||
-- ----------------------------
|
||
-- Records of la_decorate_page
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `la_decorate_page` (`id`, `page_type`, `page_name`, `page_data`, `create_time`, `update_time`) VALUES (1, 1, '商城首页', '[{\"title\":\"搜索\",\"name\":\"search\",\"disabled\":1,\"content\":{},\"styles\":{}},{\"title\":\"首页轮播图\",\"name\":\"banner\",\"content\":{\"enabled\":1,\"data\":[{\"image\":\"/api/static/banner01.png\",\"name\":\"\",\"link\":{\"path\":\"/pages/index/index\",\"name\":\"商城首页\",\"type\":\"shop\"}},{\"image\":\"/api/static/banner02.png\",\"name\":\"\",\"link\":{}}]},\"styles\":{}},{\"title\":\"导航菜单\",\"name\":\"nav\",\"content\":{\"enabled\":1,\"data\":[{\"image\":\"/api/static/nav01.png\",\"name\":\"资讯中心\",\"link\":{\"path\":\"/pages/news/news\",\"name\":\"文章资讯\",\"type\":\"shop\"}},{\"image\":\"/api/static/nav02.png\",\"name\":\"我的收藏\",\"link\":{\"path\":\"/pages/collection/collection\",\"name\":\"我的收藏\",\"type\":\"shop\"}},{\"image\":\"/api/static/nav03.png\",\"name\":\"个人设置\",\"link\":{\"path\":\"/pages/user_set/user_set\",\"name\":\"个人设置\",\"type\":\"shop\"}},{\"image\":\"/api/static/nav04.png\",\"name\":\"联系客服\",\"link\":{\"path\":\"/pages/customer_service/customer_service\",\"name\":\"联系客服\",\"type\":\"shop\"}},{\"image\":\"/api/static/nav05.png\",\"name\":\"关于我们\",\"link\":{\"path\":\"/pages/as_us/as_us\",\"name\":\"关于我们\",\"type\":\"shop\"}}]},\"styles\":{}},{\"id\":\"l84almsk2uhyf\",\"title\":\"资讯\",\"name\":\"news\",\"disabled\":1,\"content\":{},\"styles\":{}}]', 1661757188, 1663321380);
|
||
INSERT INTO `la_decorate_page` (`id`, `page_type`, `page_name`, `page_data`, `create_time`, `update_time`) VALUES (2, 2, '个人中心', '[{\"title\":\"用户信息\",\"name\":\"user-info\",\"disabled\":1,\"content\":{},\"styles\":{}},{\"title\":\"我的服务\",\"name\":\"my-service\",\"content\":{\"style\":2,\"title\":\"服务中心\",\"data\":[{\"image\":\"/api/static/user_collect.png\",\"name\":\"我的收藏\",\"link\":{\"path\":\"/pages/collection/collection\",\"name\":\"我的收藏\",\"type\":\"shop\"}},{\"image\":\"/api/static/user_setting.png\",\"name\":\"个人设置\",\"link\":{\"path\":\"/pages/user_set/user_set\",\"name\":\"个人设置\",\"type\":\"shop\"}},{\"image\":\"/api/static/user_kefu.png\",\"name\":\"联系客服\",\"link\":{\"path\":\"/pages/customer_service/customer_service\",\"name\":\"联系客服\",\"type\":\"shop\"}}]},\"styles\":{}},{\"title\":\"个人中心广告图\",\"name\":\"user-banner\",\"content\":{\"enabled\":1,\"data\":[{\"image\":\"/api/static/ad01.jpg\",\"name\":\"\",\"link\":{}}]},\"styles\":{}}]', 1661757188, 1663320728);
|
||
INSERT INTO `la_decorate_page` (`id`, `page_type`, `page_name`, `page_data`, `create_time`, `update_time`) VALUES (3, 3, '客服设置', '[{\"title\":\"客服设置\",\"name\":\"customer-service\",\"content\":{\"title\":\"添加客服二维码\",\"time\":\"早上 9:00 - 22:00\",\"mobile\":\"13800138000\",\"qrcode\":\"\"},\"styles\":{}}]', 1661757188, 1662689155);
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_decorate_tabbar
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_decorate_tabbar`;
|
||
CREATE TABLE `la_decorate_tabbar` (
|
||
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`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 NOT NULL COMMENT '链接地址',
|
||
`create_time` int unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
|
||
`update_time` int unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='底部装修表';
|
||
|
||
-- ----------------------------
|
||
-- Records of la_decorate_tabbar
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `la_decorate_tabbar` (`id`, `name`, `selected`, `unselected`, `link`, `create_time`, `update_time`) VALUES (13, '首页', '/api/static/tabbar_home_sel.png', '/api/static/tabbar_home.png', '{\"path\":\"/pages/index/index\",\"name\":\"商城首页\",\"type\":\"shop\"}', 1662688157, 1662688157);
|
||
INSERT INTO `la_decorate_tabbar` (`id`, `name`, `selected`, `unselected`, `link`, `create_time`, `update_time`) VALUES (14, '资讯', '/api/static/tabbar_text_sel.png', '/api/static/tabbar_text.png', '{\"path\":\"/pages/news/news\",\"name\":\"文章资讯\",\"type\":\"shop\"}', 1662688157, 1662688157);
|
||
INSERT INTO `la_decorate_tabbar` (`id`, `name`, `selected`, `unselected`, `link`, `create_time`, `update_time`) VALUES (15, '我的', '/api/static/tabbar_me_sel.png', '/api/static/tabbar_me.png', '{\"path\":\"/pages/user/user\",\"name\":\"个人中心\",\"type\":\"shop\"}', 1662688157, 1662688157);
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_dict_data
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_dict_data`;
|
||
CREATE TABLE `la_dict_data` (
|
||
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`type_id` int unsigned NOT NULL DEFAULT '0' COMMENT '类型',
|
||
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '键名',
|
||
`value` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '数值',
|
||
`remark` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '备注',
|
||
`sort` smallint unsigned NOT NULL DEFAULT '0' COMMENT '排序',
|
||
`status` tinyint(1) NOT NULL COMMENT '状态: 0=停用, 1=正常',
|
||
`is_delete` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否删除: 0=否, 1=是',
|
||
`create_time` int unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
|
||
`update_time` int unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`delete_time` int unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='字典数据表';
|
||
|
||
-- ----------------------------
|
||
-- Records of la_dict_data
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `la_dict_data` (`id`, `type_id`, `name`, `value`, `remark`, `sort`, `status`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (1, 1, '男', '1', '', 1, 1, 0, 0, 1699031384, 0);
|
||
INSERT INTO `la_dict_data` (`id`, `type_id`, `name`, `value`, `remark`, `sort`, `status`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (2, 1, '女', '2', '', 2, 1, 0, 0, 1699031391, 0);
|
||
INSERT INTO `la_dict_data` (`id`, `type_id`, `name`, `value`, `remark`, `sort`, `status`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (3, 1, '未知', '0', '', 3, 1, 0, 0, 1699031396, 0);
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_dict_type
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_dict_type`;
|
||
CREATE TABLE `la_dict_type` (
|
||
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`dict_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '字典名称',
|
||
`dict_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '字典类型',
|
||
`dict_remark` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '字典备注',
|
||
`dict_status` tinyint unsigned NOT NULL DEFAULT '1' COMMENT '字典状态: 0=停用, 1=正常',
|
||
`is_delete` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否删除: 0=否, 1=是',
|
||
`create_time` int unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
|
||
`update_time` int unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`delete_time` int unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='字典类型表';
|
||
|
||
-- ----------------------------
|
||
-- Records of la_dict_type
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `la_dict_type` (`id`, `dict_name`, `dict_type`, `dict_remark`, `dict_status`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (1, '性别', 'sex', '', 1, 0, 0, 1699031424, 0);
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_gen_table
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_gen_table`;
|
||
CREATE TABLE `la_gen_table` (
|
||
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`table_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '表名称',
|
||
`table_comment` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '表描述',
|
||
`sub_table_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '关联表名称',
|
||
`sub_table_fk` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '关联表外键',
|
||
`author_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '作者的名称',
|
||
`entity_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '实体的名称',
|
||
`module_name` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '生成模块名',
|
||
`function_name` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '生成功能名',
|
||
`tree_primary` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '树主键字段',
|
||
`tree_parent` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '树父级字段',
|
||
`tree_name` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '树显示字段',
|
||
`gen_tpl` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'crud' COMMENT '生成模板方式: [crud=单表, tree=树表]',
|
||
`gen_type` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '生成代码方式: [0=zip压缩包, 1=自定义路径]',
|
||
`gen_path` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '/' COMMENT '生成代码路径: [不填默认项目路径]',
|
||
`remarks` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '备注信息',
|
||
`create_time` int unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
|
||
`update_time` int unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='代码生成业务表';
|
||
|
||
-- ----------------------------
|
||
-- Records of la_gen_table
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `la_gen_table` (`id`, `table_name`, `table_comment`, `sub_table_name`, `sub_table_fk`, `author_name`, `entity_name`, `module_name`, `function_name`, `tree_primary`, `tree_parent`, `tree_name`, `gen_tpl`, `gen_type`, `gen_path`, `remarks`, `create_time`, `update_time`) VALUES (37, 'la_album', '相册管理表', '', '', 'sss', 'album', 'album', '相册管理', '', '', '', 'crud', 0, '/', '', 1700497021, 1700498569);
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_gen_table_column
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_gen_table_column`;
|
||
CREATE TABLE `la_gen_table_column` (
|
||
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '列主键',
|
||
`table_id` int unsigned NOT NULL DEFAULT '0' COMMENT '表外键',
|
||
`column_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '列名称',
|
||
`column_comment` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '列描述',
|
||
`column_length` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '列长度',
|
||
`column_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '列类型 ',
|
||
`go_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'JAVA类型',
|
||
`go_field` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'JAVA字段',
|
||
`is_pk` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否主键: [1=是, 0=否]',
|
||
`is_increment` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否自增: [1=是, 0=否]',
|
||
`is_required` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否必填: [1=是, 0=否]',
|
||
`is_insert` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否插入字段: [1=是, 0=否]',
|
||
`is_edit` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否编辑字段: [1=是, 0=否]',
|
||
`is_list` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否列表字段: [1=是, 0=否]',
|
||
`is_query` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否查询字段: [1=是, 0=否]',
|
||
`query_type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'EQ' COMMENT '查询方式: [等于、不等于、大于、小于、范围]',
|
||
`html_type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '显示类型: [文本框、文本域、下拉框、复选框、单选框、日期控件]',
|
||
`dict_type` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '字典类型',
|
||
`sort` smallint unsigned NOT NULL DEFAULT '0' COMMENT '排序编号',
|
||
`create_time` int unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
|
||
`update_time` int unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=481 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='代码生成字段表';
|
||
|
||
-- ----------------------------
|
||
-- Records of la_gen_table_column
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `la_gen_table_column` (`id`, `table_id`, `column_name`, `column_comment`, `column_length`, `column_type`, `go_type`, `go_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_time`, `update_time`) VALUES (468, 37, 'id', '主键ID', '0', 'int unsigned', 'int32', 'id', 1, 1, 1, 0, 1, 0, 0, '=', 'input', '', 1, 1700497322, 1700498569);
|
||
INSERT INTO `la_gen_table_column` (`id`, `table_id`, `column_name`, `column_comment`, `column_length`, `column_type`, `go_type`, `go_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_time`, `update_time`) VALUES (469, 37, 'cid', '类目ID', '0', 'int unsigned', 'int32', 'cid', 0, 0, 1, 1, 1, 1, 1, '=', 'input', '', 2, 1700497322, 1700498569);
|
||
INSERT INTO `la_gen_table_column` (`id`, `table_id`, `column_name`, `column_comment`, `column_length`, `column_type`, `go_type`, `go_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_time`, `update_time`) VALUES (470, 37, 'aid', '管理员ID', '0', 'int unsigned', 'int32', 'aid', 0, 0, 1, 1, 1, 1, 1, '=', 'input', '', 3, 1700497322, 1700498569);
|
||
INSERT INTO `la_gen_table_column` (`id`, `table_id`, `column_name`, `column_comment`, `column_length`, `column_type`, `go_type`, `go_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_time`, `update_time`) VALUES (471, 37, 'uid', '用户ID', '0', 'int unsigned', 'int32', 'uid', 0, 0, 1, 1, 1, 1, 1, '=', 'input', '', 4, 1700497322, 1700498569);
|
||
INSERT INTO `la_gen_table_column` (`id`, `table_id`, `column_name`, `column_comment`, `column_length`, `column_type`, `go_type`, `go_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_time`, `update_time`) VALUES (472, 37, 'type', '文件类型: [10=图片, 20=视频]', '0', 'tinyint unsigned', 'string', 'type', 0, 0, 1, 1, 1, 1, 1, '=', 'select', '', 5, 1700497322, 1700498569);
|
||
INSERT INTO `la_gen_table_column` (`id`, `table_id`, `column_name`, `column_comment`, `column_length`, `column_type`, `go_type`, `go_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_time`, `update_time`) VALUES (473, 37, 'name', '文件名称', '100', 'varchar', 'string', 'name', 0, 0, 1, 1, 1, 1, 1, 'LIKE', 'input', '', 6, 1700497322, 1700498569);
|
||
INSERT INTO `la_gen_table_column` (`id`, `table_id`, `column_name`, `column_comment`, `column_length`, `column_type`, `go_type`, `go_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_time`, `update_time`) VALUES (474, 37, 'uri', '文件路径', '200', 'varchar', 'string', 'uri', 0, 0, 1, 1, 1, 1, 1, '=', 'input', '', 7, 1700497322, 1700498569);
|
||
INSERT INTO `la_gen_table_column` (`id`, `table_id`, `column_name`, `column_comment`, `column_length`, `column_type`, `go_type`, `go_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_time`, `update_time`) VALUES (475, 37, 'ext', '文件扩展', '10', 'varchar', 'string', 'ext', 0, 0, 1, 1, 1, 1, 1, '=', 'input', '', 8, 1700497322, 1700498569);
|
||
INSERT INTO `la_gen_table_column` (`id`, `table_id`, `column_name`, `column_comment`, `column_length`, `column_type`, `go_type`, `go_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_time`, `update_time`) VALUES (476, 37, 'size', '文件大小', '0', 'int unsigned', 'int32', 'size', 0, 0, 1, 1, 1, 1, 1, '=', 'input', '', 9, 1700497322, 1700498569);
|
||
INSERT INTO `la_gen_table_column` (`id`, `table_id`, `column_name`, `column_comment`, `column_length`, `column_type`, `go_type`, `go_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_time`, `update_time`) VALUES (477, 37, 'is_delete', '是否删除: 0=否, 1=是', '0', 'int unsigned', 'int32', 'is_delete', 0, 0, 0, 0, 0, 0, 0, '=', 'input', '', 10, 1700497322, 1700498569);
|
||
INSERT INTO `la_gen_table_column` (`id`, `table_id`, `column_name`, `column_comment`, `column_length`, `column_type`, `go_type`, `go_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_time`, `update_time`) VALUES (478, 37, 'create_time', '创建时间', '0', 'int unsigned', 'core.TsTime', 'create_time', 0, 0, 0, 0, 0, 1, 0, '=', 'datetime', '', 11, 1700497322, 1700498569);
|
||
INSERT INTO `la_gen_table_column` (`id`, `table_id`, `column_name`, `column_comment`, `column_length`, `column_type`, `go_type`, `go_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_time`, `update_time`) VALUES (479, 37, 'update_time', '更新时间', '0', 'int unsigned', 'core.TsTime', 'update_time', 0, 0, 0, 0, 0, 1, 0, '=', 'datetime', '', 12, 1700497322, 1700498569);
|
||
INSERT INTO `la_gen_table_column` (`id`, `table_id`, `column_name`, `column_comment`, `column_length`, `column_type`, `go_type`, `go_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_time`, `update_time`) VALUES (480, 37, 'delete_time', '删除时间', '0', 'int unsigned', 'core.TsTime', 'delete_time', 0, 0, 0, 0, 0, 0, 0, '=', 'datetime', '', 13, 1700497322, 1700498569);
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_hot_search
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_hot_search`;
|
||
CREATE TABLE `la_hot_search` (
|
||
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '关键词',
|
||
`sort` smallint unsigned NOT NULL DEFAULT '0' COMMENT '排序号',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='热门搜索配置表';
|
||
|
||
-- ----------------------------
|
||
-- Records of la_hot_search
|
||
-- ----------------------------
|
||
BEGIN;
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_notice_record
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_notice_record`;
|
||
CREATE TABLE `la_notice_record` (
|
||
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`user_id` int 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 unsigned DEFAULT '0' COMMENT '场景',
|
||
`read` tinyint(1) DEFAULT '0' COMMENT '已读状态;0-未读,1-已读',
|
||
`recipient` tinyint(1) DEFAULT '0' COMMENT '通知接收对象类型;1-会员;2-商家;3-平台;4-游客(未注册用户)',
|
||
`send_type` tinyint(1) DEFAULT '0' COMMENT '通知发送类型 1-系统通知 2-短信通知 3-微信模板 4-微信小程序',
|
||
`notice_type` tinyint(1) DEFAULT NULL COMMENT '通知类型 1-业务通知 2-验证码',
|
||
`extra` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '其他',
|
||
`create_time` int DEFAULT NULL COMMENT '创建时间',
|
||
`update_time` int DEFAULT NULL COMMENT '更新时间',
|
||
`delete_time` int DEFAULT NULL COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='通知记录表';
|
||
|
||
-- ----------------------------
|
||
-- Records of la_notice_record
|
||
-- ----------------------------
|
||
BEGIN;
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_notice_setting
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_notice_setting`;
|
||
CREATE TABLE `la_notice_setting` (
|
||
`id` int NOT NULL AUTO_INCREMENT,
|
||
`scene_id` int 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 NOT NULL DEFAULT '1' COMMENT '接收者 1-用户 2-平台',
|
||
`type` tinyint NOT NULL DEFAULT '1' COMMENT '通知类型: 1-业务通知 2-验证码',
|
||
`system_notice` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '系统通知设置',
|
||
`sms_notice` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '短信通知设置',
|
||
`oa_notice` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '公众号通知设置',
|
||
`mnp_notice` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '小程序通知设置',
|
||
`support` char(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '支持的发送类型 1-系统通知 2-短信通知 3-微信模板消息 4-小程序提醒',
|
||
`update_time` int DEFAULT NULL COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='通知设置表';
|
||
|
||
-- ----------------------------
|
||
-- Records of la_notice_setting
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `la_notice_setting` (`id`, `scene_id`, `scene_name`, `scene_desc`, `recipient`, `type`, `system_notice`, `sms_notice`, `oa_notice`, `mnp_notice`, `support`, `update_time`) VALUES (1, 101, '登录验证码', '用户手机号码登录时发送', 1, 2, '{\"type\":\"system\",\"title\":\"\",\"content\":\"\",\"status\":\"0\",\"is_show\":\"\",\"tips\":[\"可选变量 验证码:code\"]}', '{\"content\":\"您正在登录，验证码${code}，切勿将验证码泄露于他人，本条验证码有效期5分钟。\",\"is_show\":\"1\",\"status\":\"1\",\"template_id\":\"SMS_123456\",\"tips\":[\"可选变量 用户昵称:nickname\",\"示例：亲爱的${user_name}，您的订单${order_sn}已支付成功，商家正在快马加鞭为您安排发货。\",\"示例：亲爱的${nickname}，您的订单可以取货啦，请前往自提点取货。\",\"生效条件：1、管理后台完成短信设置。 2、第三方短信平台申请模板 3、若是腾讯云模板变量名须换成变量名出现顺序对应的数字(例：您好{nickname},您的订单{order_sn}已发货! 须改为 您好{1},您的订单{2}已发货!)\"],\"type\":\"sms\"}', '{\"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` (`id`, `scene_id`, `scene_name`, `scene_desc`, `recipient`, `type`, `system_notice`, `sms_notice`, `oa_notice`, `mnp_notice`, `support`, `update_time`) 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\",\"tips\":[\"可选变量 用户昵称:nickname\",\"示例：亲爱的${user_name}，您的订单${order_sn}已支付成功，商家正在快马加鞭为您安排发货。\",\"示例：亲爱的${nickname}，您的订单可以取货啦，请前往自提点取货。\",\"生效条件：1、管理后台完成短信设置。 2、第三方短信平台申请模板 3、若是腾讯云模板变量名须换成变量名出现顺序对应的数字(例：您好{nickname},您的订单{order_sn}已发货! 须改为 您好{1},您的订单{2}已发货!)\"]}', '{\"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` (`id`, `scene_id`, `scene_name`, `scene_desc`, `recipient`, `type`, `system_notice`, `sms_notice`, `oa_notice`, `mnp_notice`, `support`, `update_time`) 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` (`id`, `scene_id`, `scene_name`, `scene_desc`, `recipient`, `type`, `system_notice`, `sms_notice`, `oa_notice`, `mnp_notice`, `support`, `update_time`) VALUES (4, 104, '找回登录密码验证码', '用户找回登录密码号码时发送', 1, 2, '{\"type\":\"system\",\"title\":\"\",\"content\":\"\",\"status\":\"0\",\"is_show\":\"\",\"tips\":[\"可选变量 验证码:code\"]}', '{\"content\":\"您正在找回登录密码，验证码${code}，切勿将验证码泄露于他人，本条验证码有效期5分钟。\",\"is_show\":\"1\",\"status\":\"1\",\"template_id\":\"SMS_123456\",\"tips\":null,\"type\":\"sms\"}', '{\"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_reply
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_official_reply`;
|
||
CREATE TABLE `la_official_reply` (
|
||
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`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 unsigned NOT NULL DEFAULT '0' COMMENT '回复类型: [1=关注回复 2=关键字回复, 3=默认回复]',
|
||
`matching_type` tinyint unsigned NOT NULL DEFAULT '1' COMMENT '匹配方式: [1=全匹配, 2=模糊匹配]',
|
||
`content_type` tinyint unsigned NOT NULL DEFAULT '1' COMMENT '内容类型: [1=文本]',
|
||
`status` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '启动状态: [1=启动, 0=关闭]',
|
||
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '回复内容',
|
||
`sort` int unsigned NOT NULL DEFAULT '50' COMMENT '排序编号',
|
||
`is_delete` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否删除',
|
||
`create_time` int unsigned DEFAULT '0' COMMENT '创建时间',
|
||
`update_time` int unsigned DEFAULT '0' COMMENT '更新时间',
|
||
`delete_time` int unsigned DEFAULT '0' COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='公众号的回复表';
|
||
|
||
-- ----------------------------
|
||
-- Records of la_official_reply
|
||
-- ----------------------------
|
||
BEGIN;
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_recharge_order
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_recharge_order`;
|
||
CREATE TABLE `la_recharge_order` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
`sn` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '订单编号',
|
||
`user_id` int NOT NULL COMMENT '用户id',
|
||
`user_sn` bigint unsigned NOT NULL COMMENT '用户编号',
|
||
`mobile` varchar(11) COLLATE utf8mb4_general_ci DEFAULT NULL,
|
||
`pay_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '支付编号-冗余字段，针对微信同一主体不同客户端支付需用不同订单号预留。',
|
||
`pay_way` tinyint NOT NULL DEFAULT '2' COMMENT '支付方式 2-微信支付 3-支付宝支付',
|
||
`pay_status` tinyint NOT NULL DEFAULT '2' COMMENT '支付状态：2-待支付；1-已支付',
|
||
`pay_time` int DEFAULT NULL COMMENT '支付时间',
|
||
`order_amount` decimal(10,2) NOT NULL COMMENT '充值金额',
|
||
`order_terminal` tinyint DEFAULT '1' COMMENT '终端',
|
||
`transaction_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '第三方平台交易流水号',
|
||
`refund_status` tinyint DEFAULT '0' COMMENT '退款状态 0-未退款 1-已退款',
|
||
`create_time` int DEFAULT NULL COMMENT '创建时间',
|
||
`update_time` int DEFAULT NULL COMMENT '更新时间',
|
||
`delete_time` int DEFAULT NULL COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `idx_user_sn` (`user_sn`),
|
||
KEY `idx_user_id` (`user_id`),
|
||
KEY `idx_sn` (`sn`),
|
||
KEY `idx_mobile` (`mobile`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='充值订单表';
|
||
|
||
-- ----------------------------
|
||
-- Records of la_recharge_order
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `la_recharge_order` (`id`, `sn`, `user_id`, `user_sn`, `mobile`, `pay_sn`, `pay_way`, `pay_status`, `pay_time`, `order_amount`, `order_terminal`, `transaction_id`, `refund_status`, `create_time`, `update_time`, `delete_time`) VALUES (1, 'RC987698767', 1, 234234, '13555555555', 'fdgdfg34543534', 2, 1, 1699274409, 20.00, 1, NULL, 1, 1699274409, 1699274409, NULL);
|
||
INSERT INTO `la_recharge_order` (`id`, `sn`, `user_id`, `user_sn`, `mobile`, `pay_sn`, `pay_way`, `pay_status`, `pay_time`, `order_amount`, `order_terminal`, `transaction_id`, `refund_status`, `create_time`, `update_time`, `delete_time`) VALUES (2, 'r32423', 2, 5343, '13777777777', '2323', 3, 2, 1699274409, 4.00, 1, NULL, 0, 1699274409, 1699274409, NULL);
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_refund_log
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_refund_log`;
|
||
CREATE TABLE `la_refund_log` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
`sn` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '编号',
|
||
`record_id` int NOT NULL COMMENT '退款记录id',
|
||
`user_id` int NOT NULL DEFAULT '0' COMMENT '关联用户',
|
||
`handle_id` int 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 NOT NULL DEFAULT '0' COMMENT '退款状态，0退款中，1退款成功，2退款失败',
|
||
`refund_msg` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '退款信息',
|
||
`create_time` int unsigned DEFAULT '0' COMMENT '创建时间',
|
||
`update_time` int DEFAULT NULL COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `idx_sn` (`sn`),
|
||
KEY `idx_record_id` (`record_id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='退款日志表';
|
||
|
||
-- ----------------------------
|
||
-- Records of la_refund_log
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `la_refund_log` (`id`, `sn`, `record_id`, `user_id`, `handle_id`, `order_amount`, `refund_amount`, `refund_status`, `refund_msg`, `create_time`, `update_time`) VALUES (1, 'RL202311160147072820', 1, 1, 1, 20.00, 20.00, 0, '', 1700070427, 0);
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_refund_record
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_refund_record`;
|
||
CREATE TABLE `la_refund_record` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
`sn` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '退款编号',
|
||
`user_id` int NOT NULL DEFAULT '0' COMMENT '关联用户',
|
||
`user_sn` bigint DEFAULT NULL,
|
||
`order_id` int 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 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 DEFAULT NULL COMMENT '第三方平台交易流水号',
|
||
`refund_way` tinyint NOT NULL COMMENT '退款方式 1-线上退款 2-线下退款',
|
||
`refund_type` tinyint NOT NULL COMMENT '退款类型 1-后台退款',
|
||
`refund_status` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '退款状态，0退款中，1退款成功，2退款失败',
|
||
`create_time` int unsigned DEFAULT '0' COMMENT '创建时间',
|
||
`update_time` int DEFAULT NULL COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `idx_sn` (`sn`),
|
||
UNIQUE KEY `idx_order_sn` (`order_sn`) USING BTREE,
|
||
KEY `idx_user_sn` (`user_sn`),
|
||
KEY `idx_refund_type` (`refund_type`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='退款记录表';
|
||
|
||
-- ----------------------------
|
||
-- Records of la_refund_record
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `la_refund_record` (`id`, `sn`, `user_id`, `user_sn`, `order_id`, `order_sn`, `order_type`, `order_amount`, `refund_amount`, `transaction_id`, `refund_way`, `refund_type`, `refund_status`, `create_time`, `update_time`) VALUES (1, 'RF202311160147078497125433', 1, 23230, 1, 'RC987698767', 'recharge', 20.00, 20.00, '', 1, 1, 0, 1700070427, 0);
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_system_auth_admin
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_system_auth_admin`;
|
||
CREATE TABLE `la_system_auth_admin` (
|
||
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`dept_id` int unsigned NOT NULL DEFAULT '0' COMMENT '部门ID',
|
||
`post_id` int unsigned NOT NULL DEFAULT '0' COMMENT '岗位ID',
|
||
`username` 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 '用户昵称',
|
||
`password` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户密码',
|
||
`avatar` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户头像',
|
||
`role` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '角色主键',
|
||
`salt` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '加密盐巴',
|
||
`sort` smallint unsigned NOT NULL DEFAULT '0' COMMENT '排序编号',
|
||
`is_multipoint` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '多端登录: 0=否, 1=是',
|
||
`is_disable` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否禁用: 0=否, 1=是',
|
||
`is_delete` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否删除: 0=否, 1=是',
|
||
`last_login_ip` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '最后登录IP',
|
||
`last_login_time` int unsigned NOT NULL DEFAULT '0' COMMENT '最后登录',
|
||
`create_time` int unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
|
||
`update_time` int unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`delete_time` int unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='系统管理成员表';
|
||
|
||
-- ----------------------------
|
||
-- Records of la_system_auth_admin
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `la_system_auth_admin` (`id`, `dept_id`, `post_id`, `username`, `nickname`, `password`, `avatar`, `role`, `salt`, `sort`, `is_multipoint`, `is_disable`, `is_delete`, `last_login_ip`, `last_login_time`, `create_time`, `update_time`, `delete_time`) VALUES (1, 1, 1, 'admin', 'admin', '338b491c378a6dd0f90ed7c0e00fcf8d', '/image/20231611/872472ee657a4a4f9ae8aace06961b8d.png', '0', 'YuAz7', 1, 1, 0, 0, '::1', 1700744919, 1642321599, 1700744919, 0);
|
||
INSERT INTO `la_system_auth_admin` (`id`, `dept_id`, `post_id`, `username`, `nickname`, `password`, `avatar`, `role`, `salt`, `sort`, `is_multipoint`, `is_disable`, `is_delete`, `last_login_ip`, `last_login_time`, `create_time`, `update_time`, `delete_time`) VALUES (2, 1, 1, 'luojinyi', '罗锦毅', '8c0c364e4da86805b610239918d985cf', '/image/20231611/dd2adfb1df364ec4ba2483297aead3e0.png', '2', 'Akqd7', 1, 1, 0, 0, '::1', 1700116411, 1700115994, 1700122235, 0);
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_system_auth_dept
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_system_auth_dept`;
|
||
CREATE TABLE `la_system_auth_dept` (
|
||
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`pid` int unsigned NOT NULL DEFAULT '0' COMMENT '上级主键',
|
||
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '部门名称',
|
||
`duty` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '负责人名',
|
||
`mobile` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '联系电话',
|
||
`sort` smallint unsigned NOT NULL DEFAULT '0' COMMENT '排序编号',
|
||
`is_stop` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否禁用: 0=否, 1=是',
|
||
`is_delete` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否删除: 0=否, 1=是',
|
||
`create_time` int unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
|
||
`update_time` int unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`delete_time` int unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='系统部门管理表';
|
||
|
||
-- ----------------------------
|
||
-- Records of la_system_auth_dept
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `la_system_auth_dept` (`id`, `pid`, `name`, `duty`, `mobile`, `sort`, `is_stop`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (1, 0, '默认部门', '康明', '18327647788', 10, 0, 0, 1649841995, 1660190949, 0);
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_system_auth_menu
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_system_auth_menu`;
|
||
CREATE TABLE `la_system_auth_menu` (
|
||
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`pid` int unsigned NOT NULL DEFAULT '0' COMMENT '上级菜单',
|
||
`menu_type` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '权限类型: M=目录，C=菜单，A=按钮',
|
||
`menu_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '菜单名称',
|
||
`menu_icon` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '菜单图标',
|
||
`menu_sort` smallint 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 unsigned NOT NULL DEFAULT '0' COMMENT '是否缓存: 0=否, 1=是',
|
||
`is_show` tinyint unsigned NOT NULL DEFAULT '1' COMMENT '是否显示: 0=否, 1=是',
|
||
`is_disable` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否禁用: 0=否, 1=是',
|
||
`create_time` int unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
|
||
`update_time` int unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=825 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='系统菜单管理表';
|
||
|
||
-- ----------------------------
|
||
-- Records of la_system_auth_menu
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (1, 0, 'C', '工作台', 'el-icon-Monitor', 50, 'common:index:console', 'workbench', 'workbench/index', '', '', 1, 1, 0, 1650341765, 1668672757);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (100, 0, 'M', '权限管理', 'el-icon-Lock', 44, '', 'permission', '', '', '', 0, 1, 0, 1650341765, 1662626201);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (101, 100, 'C', '管理员', 'local-icon-wode', 0, 'system:admin:list', 'admin', 'permission/admin/index', '', '', 1, 1, 0, 1650341765, 1663301404);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (102, 101, 'A', '管理员详情', '', 0, 'system:admin:detail', '', '', '', '', 0, 1, 0, 1650341765, 1660201785);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (103, 101, 'A', '管理员新增', '', 0, 'system:admin:add', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (104, 101, 'A', '管理员编辑', '', 0, 'system:admin:edit', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (105, 101, 'A', '管理员删除', '', 0, 'system:admin:del', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (106, 101, 'A', '管理员状态', '', 0, 'system:admin:disable', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (110, 100, 'C', '角色管理', 'el-icon-Female', 0, 'system:role:list', 'role', 'permission/role/index', '', '', 1, 1, 0, 1650341765, 1663301451);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (111, 110, 'A', '角色详情', '', 0, 'system:role:detail', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (112, 110, 'A', '角色新增', '', 0, 'system:role:add', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (113, 110, 'A', '角色编辑', '', 0, 'system:role:edit', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (114, 110, 'A', '角色删除', '', 0, 'system:role:del', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (120, 100, 'C', '菜单管理', 'el-icon-Operation', 0, 'system:menu:list', 'menu', 'permission/menu/index', '', '', 1, 1, 0, 1650341765, 1663301388);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (121, 120, 'A', '菜单详情', '', 0, 'system:menu:detail', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (122, 120, 'A', '菜单新增', '', 0, 'system:menu:add', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (123, 120, 'A', '菜单编辑', '', 0, 'system:menu:edit', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (124, 120, 'A', '菜单删除', '', 0, 'system:menu:del', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (130, 0, 'M', '组织管理', 'el-icon-OfficeBuilding', 45, '', 'organization', '', '', '', 0, 1, 0, 1650341765, 1664416715);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (131, 130, 'C', '部门管理', 'el-icon-Coordinate', 0, 'system:dept:list', 'department', 'organization/department/index', '', '', 1, 1, 0, 1650341765, 1660201994);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (132, 131, 'A', '部门详情', '', 0, 'system:dept:detail', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (133, 131, 'A', '部门新增', '', 0, 'system:dept:add', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (134, 131, 'A', '部门编辑', '', 0, 'system:dept:edit', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (135, 131, 'A', '部门删除', '', 0, 'system:dept:del', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (140, 130, 'C', '岗位管理', 'el-icon-PriceTag', 0, 'system:post:list', 'post', 'organization/post/index', '', '', 1, 1, 0, 1650341765, 1660202057);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (141, 140, 'A', '岗位详情', '', 0, 'system:post:detail', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (142, 140, 'A', '岗位新增', '', 0, 'system:post:add', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (143, 140, 'A', '岗位编辑', '', 0, 'system:post:edit', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (144, 140, 'A', '岗位删除', '', 0, 'system:post:del', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (200, 0, 'M', '其它管理', '', 0, '', '', '', '', '', 0, 0, 0, 1650341765, 1660636870);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (201, 200, 'M', '图库管理', '', 0, '', '', '', '', '', 0, 0, 0, 1650341765, 1650341765);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (202, 201, 'A', '文件列表', '', 0, 'albums:albumList', '', '', '', '', 0, 0, 0, 1650341765, 1650341765);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (203, 201, 'A', '文件命名', '', 0, 'albums:albumRename', '', '', '', '', 0, 0, 0, 1650341765, 1650341765);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (204, 201, 'A', '文件移动', '', 0, 'albums:albumMove', '', '', '', '', 0, 0, 0, 1650341765, 1650341765);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (205, 201, 'A', '文件删除', '', 0, 'albums:albumDel', '', '', '', '', 0, 0, 0, 1650341765, 1650341765);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (206, 201, 'A', '分类列表', '', 0, 'albums:cateList', '', '', '', '', 0, 0, 0, 1650341765, 1650341765);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (207, 201, 'A', '分类新增', '', 0, 'albums:cateAdd', '', '', '', '', 0, 0, 0, 1650341765, 1650341765);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (208, 201, 'A', '分类命名', '', 0, 'albums:cateRename', '', '', '', '', 0, 0, 0, 1650341765, 1650341765);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (209, 201, 'A', '分类删除', '', 0, 'albums:cateDel', '', '', '', '', 0, 0, 0, 1650341765, 1650341765);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (215, 200, 'M', '上传管理', '', 0, '', '', '', '', '', 0, 0, 0, 1650341765, 1650341765);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (216, 215, 'A', '上传图片', '', 0, 'upload:image', '', '', '', '', 0, 0, 0, 1650341765, 1650341765);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (217, 215, 'A', '上传视频', '', 0, 'upload:video', '', '', '', '', 0, 0, 0, 1650341765, 1650341765);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (500, 0, 'M', '系统设置', 'el-icon-Setting', 0, '', 'setting', '', '', '', 0, 1, 0, 1650341765, 1662626322);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (501, 500, 'M', '网站设置', 'el-icon-Basketball', 10, '', 'website', '', '', '', 0, 1, 0, 1650341765, 1663233572);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (502, 501, 'C', '网站信息', '', 0, 'setting:website:detail', 'information', 'setting/website/information', '', '', 0, 1, 0, 1650341765, 1660202218);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (503, 502, 'A', '保存配置', '', 0, 'setting:website:save', '', '', '', '', 0, 0, 0, 1650341765, 1650341765);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (505, 501, 'C', '网站备案', '', 0, 'setting:copyright:detail', 'filing', 'setting/website/filing', '', '', 0, 1, 0, 1650341765, 1660202294);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (506, 505, 'A', '备案保存', '', 0, 'setting:copyright:save', '', 'setting/website/protocol', '', '', 0, 0, 0, 1650341765, 1650341765);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (510, 501, 'C', '政策协议', '', 0, 'setting:protocol:detail', 'protocol', 'setting/website/protocol', '', '', 0, 1, 0, 1660027606, 1660202312);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (511, 510, 'A', '协议保存', '', 0, 'setting:protocol:save', '', '', '', '', 0, 0, 0, 1660027606, 1663670865);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (515, 600, 'C', '字典管理', 'el-icon-Box', 0, 'setting:dict:type:list', 'dict', 'setting/dict/type/index', '', '', 0, 1, 0, 1660035436, 1663226087);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (516, 515, 'A', '字典类型新增', '', 0, 'setting:dict:type:add', '', '', '', '', 0, 1, 0, 1660202761, 1660202761);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (517, 515, 'A', '字典类型编辑', '', 0, 'setting:dict:type:edit', '', '', '', '', 0, 1, 0, 1660202842, 1660202842);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (518, 515, 'A', '字典类型删除', '', 0, 'setting:dict:type:del', '', '', '', '', 0, 1, 0, 1660202903, 1660202903);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (519, 600, 'C', '字典数据管理', '', 0, 'setting:dict:data:list', 'dict/data', 'setting/dict/data/index', '/dev_tools/dict', '', 0, 0, 0, 1660202948, 1663309252);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (520, 515, 'A', '字典数据新增', '', 0, 'setting:dict:data:add', '', '', '', '', 0, 1, 0, 1660203117, 1660203117);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (521, 515, 'A', '字典数据编辑', '', 0, 'setting:dict:data:edit', '', '', '', '', 0, 1, 0, 1660203142, 1660203142);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (522, 515, 'A', '字典数据删除', '', 0, 'setting:dict:data:del', '', '', '', '', 0, 1, 0, 1660203159, 1660203159);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (550, 500, 'M', '系统维护', 'el-icon-SetUp', 0, '', 'system', '', '', '', 0, 1, 0, 1650341765, 1660202466);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (551, 550, 'C', '系统环境', '', 0, 'monitor:server', 'environment', 'setting/system/environment', '', '', 0, 1, 0, 1650341765, 1650341765);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (552, 550, 'C', '系统缓存', '', 0, 'monitor:cache', 'cache', 'setting/system/cache', '', '', 0, 1, 0, 1650341765, 1650341765);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (553, 550, 'C', '系统日志', '', 0, 'system:log:operate', 'journal', 'setting/system/journal', '', '', 0, 1, 0, 1650341765, 1650341765);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (555, 500, 'C', '存储设置', 'el-icon-FolderOpened', 6, 'setting:storage:list', 'storage', 'setting/storage/index', '', '', 0, 1, 0, 1650341765, 1663312996);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (556, 555, 'A', '保存配置', '', 0, 'setting:storage:edit', '', '', '', '', 0, 1, 0, 1650341765, 1650341765);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (600, 0, 'M', '开发工具', 'el-icon-EditPen', 0, '', 'dev_tools', '', '', '', 0, 1, 0, 1660027606, 1664335701);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (610, 600, 'C', '代码生成器', 'el-icon-DocumentAdd', 0, 'gen:list', 'code', 'dev_tools/code/index', '', '', 0, 1, 0, 1660028954, 1660532510);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (611, 610, 'A', '导入数据表', '', 0, 'gen:importTable', '', '', '', '', 0, 1, 0, 1660532389, 1660532389);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (612, 610, 'A', '生成代码', '', 0, 'gen:genCode', '', '', '', '', 0, 1, 0, 1660532421, 1660532421);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (613, 610, 'A', '下载代码', '', 0, 'gen:downloadCode', '', '', '', '', 0, 1, 0, 1660532437, 1660532437);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (614, 610, 'A', '预览代码', '', 0, 'gen:previewCode', '', '', '', '', 0, 1, 0, 1660532549, 1660532549);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (616, 610, 'A', '同步表结构', '', 0, 'gen:syncTable', '', '', '', '', 0, 1, 0, 1660532781, 1660532781);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (617, 610, 'A', '删除数据表', '', 0, 'gen:delTable', '', '', '', '', 0, 1, 0, 1660532800, 1660532800);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (618, 610, 'A', '数据表详情', '', 0, 'gen:detail', '', '', '', '', 0, 1, 0, 1660532964, 1660532977);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (700, 0, 'M', '素材管理', 'el-icon-Picture', 43, '', 'material', '', '', '', 0, 1, 0, 1660203293, 1663300847);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (701, 700, 'C', '素材中心', 'el-icon-PictureRounded', 0, '', 'index', 'material/index', '', '', 0, 1, 0, 1660203402, 1663301493);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (775, 0, 'M', '用户管理', 'el-icon-User', 48, '', 'consumer', '', '', '', 1, 1, 0, 1699108472, 1699108472);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (776, 775, 'C', '用户列表', 'el-icon-UserFilled', 0, 'system:user:list', 'lists', 'consumer/lists/index', '', '', 1, 1, 0, 1699108637, 1699108637);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (777, 775, 'C', '用户详情', '', 0, 'system:user:detail', 'lists/detail', 'consumer/lists/detail', '/consumer/lists', '', 0, 0, 0, 1699110322, 1699110322);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (778, 777, 'A', '编辑', '', 0, 'system:user:edit', '', '', '', '', 1, 1, 0, 1699110358, 1699110358);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (779, 777, 'A', '余额调整', '', 0, 'system:user:adjustMoney', '', '', '', '', 1, 1, 0, 1699110420, 1699110420);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (780, 0, 'M', '应用管理', 'el-icon-Apple', 47, '', 'app', '', '', '', 1, 1, 0, 1699283441, 1699283441);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (781, 500, 'M', '消息管理', 'el-icon-ChatDotRound', 10, '', 'message', '', '', '', 1, 1, 0, 1699283522, 1699283522);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (782, 781, 'C', '通知设置', '', 0, 'setting:notice:list', 'notice', 'message/notice/index', '', '', 0, 1, 0, 1699283689, 1699283689);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (784, 781, 'C', '设置页面', '', 0, 'setting:notice:detail', 'notice/edit', 'message/notice/edit', '/message/notice', '', 0, 0, 0, 1699283822, 1699283822);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (785, 781, 'C', '短信设置', '', 0, 'setting:sms:list', 'short_letter', 'message/short_letter/index', '', '', 0, 1, 0, 1699283880, 1699283880);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (786, 785, 'A', '设置', '', 0, 'setting:sms:detail', '', '', '', '', 1, 1, 0, 1699283943, 1699283943);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (787, 785, 'A', '保存', '', 0, 'setting:sms:save', '', '', '', '', 1, 1, 0, 1699283982, 1699283982);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (789, 780, 'C', '用户充值', 'local-icon-caiwu', 0, 'setting:recharge:get', 'recharge', 'app/recharge/index', '', '', 0, 1, 0, 1699284506, 1699284506);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (790, 789, 'A', '保存', '', 0, 'setting:recharge:set', '', '', '', '', 1, 1, 0, 1699284606, 1699284606);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (791, 0, 'M', '财务管理', 'local-icon-yinhangka', 46, '', 'finance', '', '', '', 1, 1, 0, 1699284810, 1699284810);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (792, 791, 'C', '充值记录', 'el-icon-Tickets', 0, 'finance:recharge:lists', 'recharge_record', 'finance/recharge_record', '', '', 0, 1, 0, 1699284903, 1699284903);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (793, 792, 'A', '退款', '', 0, 'finance:recharge:refund', '', '', '', '', 1, 1, 0, 1699284937, 1699284937);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (794, 791, 'C', '余额明细', 'el-icon-Wallet', 0, 'finance:account_log:lists', 'balance_details', 'finance/balance_details', '', '', 0, 1, 0, 1699285037, 1699285037);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (795, 791, 'C', '退款记录', 'el-icon-SwitchFilled', 0, 'finance:refund:record:list', 'refund_record', 'finance/refund_record', '', '', 0, 1, 0, 1699285131, 1699285131);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (796, 795, 'A', '重新退款', '', 0, 'finance:recharge:refundAgain', '', '', '', '', 1, 1, 0, 1699285165, 1699285165);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (797, 795, 'A', '退款日志', '', 0, 'finance:refund:log', '', '', '', '', 1, 1, 0, 1699285187, 1699285187);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (798, 0, 'M', '渠道设置', 'el-icon-Box', 46, '', 'channel', '', '', '', 1, 1, 0, 1699285293, 1699285293);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (799, 798, 'C', 'h5设置', 'el-icon-Iphone', 0, 'channel.web_page_setting/getConfig', 'h5', 'channel/h5', '', '', 0, 1, 0, 1699285358, 1699285358);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (800, 799, 'A', '保存', '', 0, 'channel.web_page_setting/setConfig', '', '', '', '', 1, 1, 0, 1699285385, 1699285385);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (801, 798, 'M', '微信公众号', 'el-icon-Sunset', 0, '', 'wx_oa', '', '', '', 1, 1, 0, 1699285472, 1699285472);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (802, 801, 'C', '公众号配置', '', 0, 'channel.official_account_setting/getConfig', 'config', 'channel/wx_oa/config', '', '', 0, 1, 0, 1699285618, 1699285618);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (803, 802, 'A', '保存', '', 0, 'channel.official_account_setting/setConfig', '', '', '', '', 1, 1, 0, 1699285654, 1699285654);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (804, 802, 'A', '保存并发布', '', 0, 'channel.official_account_menu/save', 'channel.official_account_menu/save', '', '', '', 1, 1, 0, 1699285686, 1699285686);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (805, 801, 'C', '菜单管理', '', 0, 'channel.official_account_menu/detail', 'menu', 'channel/wx_oa/menu', '', '', 0, 1, 0, 1699285757, 1699285757);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (806, 801, 'C', '关注回复', '', 0, 'channel.official_account_reply/lists', 'follow', 'channel/wx_oa/reply/follow_reply', '', '', 0, 1, 0, 1699285806, 1699285806);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (807, 801, 'C', '关键字回复', '', 0, '', 'keyword', 'channel/wx_oa/reply/keyword_reply', '', '', 0, 1, 0, 1699285856, 1699285856);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (808, 801, 'C', '默认回复', '', 0, '', 'default', 'channel/wx_oa/reply/default_reply', '', '', 0, 1, 0, 1699285894, 1699285894);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (809, 798, 'C', '微信小程序', 'local-icon-qudao_xiaochengxu', 0, 'channel.mnp_settings/getConfig', 'weapp', 'channel/weapp', '', '', 0, 1, 0, 1699286034, 1699286034);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (810, 809, 'A', '保存', '', 0, 'channel.mnp_settings/setConfig', '', '', '', '', 1, 1, 0, 1699286061, 1699286061);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (811, 798, 'C', '微信开发平台', 'el-icon-DataBoard', 0, 'channel.open_setting/getConfig', 'open_setting', 'channel/open_setting', '', '', 0, 1, 0, 1699286133, 1699286133);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (812, 811, 'A', '保存', '', 0, 'channel.open_setting/setConfig', '', '', '', '', 1, 1, 0, 1699286161, 1699286161);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (813, 500, 'M', '用户设置', 'local-icon-user_biaoqian', 0, '', 'user', '', '', '', 1, 1, 0, 1699512447, 1699512447);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (814, 813, 'C', '用户设置', '', 0, 'setting:user:detail', 'setup', 'setting/user/setup', '', '', 0, 1, 0, 1699512529, 1699512529);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (815, 814, 'A', '保存', '', 0, 'setting:user:save', '', '', '', '', 1, 1, 0, 1699512563, 1699512563);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (816, 813, 'C', '登录注册', '', 0, 'setting:login:detail', 'login_register', 'setting/user/login_register', '', '', 0, 1, 0, 1699512617, 1699512617);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (817, 816, 'A', '保存', '', 0, 'setting:login:save', '', '', '', '', 1, 1, 0, 1699512640, 1699512640);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (818, 784, 'A', '保存', '', 0, 'setting:notice:save', '', '', '', '', 1, 1, 0, 1700112233, 1700112233);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (819, 500, 'M', '支付设置', 'el-icon-Wallet', 0, '', 'pay', '', '', '', 1, 1, 0, 1700122816, 1700122816);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (820, 819, 'C', '支付方式', '', 0, 'setting:pay:way:get', 'method', 'setting/pay/method/index', '', '', 0, 1, 0, 1700122914, 1700122914);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (821, 820, 'A', '设置支付方式', '', 0, 'setting:pay:way:set', '', '', '', '', 1, 1, 0, 1700123024, 1700123024);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (822, 819, 'C', '支付配置', '', 0, 'setting:pay:config:lists', 'config', 'setting/pay/config/index', '', '', 0, 1, 0, 1700123171, 1700123171);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (823, 822, 'A', '配置', '', 0, 'setting:pay:config:set', '', '', '', '', 1, 1, 0, 1700123221, 1700123221);
|
||
INSERT INTO `la_system_auth_menu` (`id`, `pid`, `menu_type`, `menu_name`, `menu_icon`, `menu_sort`, `perms`, `paths`, `component`, `selected`, `params`, `is_cache`, `is_show`, `is_disable`, `create_time`, `update_time`) VALUES (824, 600, 'C', '编辑数据表', '', 0, 'gen:edit', 'code/edit', 'dev_tools/code/edit', '/dev_tools/code', '', 1, 0, 0, 1700196667, 1700196667);
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_system_auth_perm
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_system_auth_perm`;
|
||
CREATE TABLE `la_system_auth_perm` (
|
||
`id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '主键',
|
||
`role_id` int unsigned NOT NULL DEFAULT '0' COMMENT '角色ID',
|
||
`menu_id` int unsigned NOT NULL DEFAULT '0' COMMENT '菜单ID',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='系统角色菜单表';
|
||
|
||
-- ----------------------------
|
||
-- Records of la_system_auth_perm
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `la_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('0a60250dc8534f6595de4ebcd0ee09ee', 2, 780);
|
||
INSERT INTO `la_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('1d59ac4c7b584f52864829771cab25c5', 2, 777);
|
||
INSERT INTO `la_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('1d619e0cce9d4f4f88080c14df935704', 2, 779);
|
||
INSERT INTO `la_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('36d751304f6f404fb06f27e6dc53880d', 2, 789);
|
||
INSERT INTO `la_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('376f5491169449f88b7e0e88aa122a7c', 2, 778);
|
||
INSERT INTO `la_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('6c9af3efb19348fb94a8aaa808c97997', 2, 775);
|
||
INSERT INTO `la_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('ad527b12ba2b46a1ba1582cafc5c2c91', 2, 776);
|
||
INSERT INTO `la_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('c4d2a2cd96b54b05ae79f36957d27d70', 2, 1);
|
||
INSERT INTO `la_system_auth_perm` (`id`, `role_id`, `menu_id`) VALUES ('f1c30e8f22894012afd740929c19a1e7', 2, 790);
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_system_auth_post
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_system_auth_post`;
|
||
CREATE TABLE `la_system_auth_post` (
|
||
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`code` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '岗位编码',
|
||
`name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '岗位名称',
|
||
`remarks` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '岗位备注',
|
||
`sort` smallint unsigned NOT NULL DEFAULT '0' COMMENT '岗位排序',
|
||
`is_stop` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否停用: 0=否, 1=是',
|
||
`is_delete` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否删除: 0=否, 1=是',
|
||
`create_time` int unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
|
||
`update_time` int unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`delete_time` int unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='系统岗位管理表';
|
||
|
||
-- ----------------------------
|
||
-- Records of la_system_auth_post
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `la_system_auth_post` (`id`, `code`, `name`, `remarks`, `sort`, `is_stop`, `is_delete`, `create_time`, `update_time`, `delete_time`) VALUES (1, '0032', '研发工程师', '', 6, 0, 0, 1699286468, 1699286468, 0);
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_system_auth_role
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_system_auth_role`;
|
||
CREATE TABLE `la_system_auth_role` (
|
||
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '角色名称',
|
||
`remark` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '备注信息',
|
||
`sort` smallint unsigned NOT NULL DEFAULT '0' COMMENT '角色排序',
|
||
`is_disable` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否禁用: 0=否, 1=是',
|
||
`create_time` int unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
|
||
`update_time` int unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='系统角色管理表';
|
||
|
||
-- ----------------------------
|
||
-- Records of la_system_auth_role
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `la_system_auth_role` (`id`, `name`, `remark`, `sort`, `is_disable`, `create_time`, `update_time`) VALUES (1, '审核员', '审核数据', 0, 0, 1668679451, 1668679468);
|
||
INSERT INTO `la_system_auth_role` (`id`, `name`, `remark`, `sort`, `is_disable`, `create_time`, `update_time`) VALUES (2, '开发人员', '', 0, 0, 1700071890, 1700116399);
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_system_config
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_system_config`;
|
||
CREATE TABLE `la_system_config` (
|
||
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '类型',
|
||
`name` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '键',
|
||
`value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '值',
|
||
`create_time` int unsigned DEFAULT '0' COMMENT '创建时间',
|
||
`update_time` int unsigned DEFAULT '0' COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `idx_type` (`type`),
|
||
KEY `idx_name` (`name`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=98 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='系统全局配置表';
|
||
|
||
-- ----------------------------
|
||
-- Records of la_system_config
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (1, 'storage', 'default', 'local', 1660620367, 1700758251);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (2, 'storage', 'local', '{\"engine\":\"local\",\"name\":\"本地存储\",\"describe\":\"存储在本地服务器\"}', 1660620367, 1700758251);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (3, 'storage', 'qiniu', '{\"engine\":\"qiniu\",\"name\":\"七牛云存储\",\"describe\":\"存储在七牛云，请前往七牛云开通存储服务\",\"bucket\":\"my-test-0100\",\"secret_key\":\"nWnLYSpEG9lex5r\",\"access_key\":\"t6011E0TdX3ou-azuAZN4CTDiULlGdjKExlmuGvA\",\"domain\":\"http://s4l2ga4ln.hd-bkt.clouddn.com\"}', 1660620367, 1700758430);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (4, 'storage', 'aliyun', '{\"engine\":\"aliyun\",\"name\":\"阿里云存储\",\"describe\":\"存储在阿里云，请前往阿里云开通存储服务\",\"bucket\":\"mooc-love-storage\",\"endpoint\":\"oss-cn-beijing.aliyuncs.com\",\"secret_key\":\"XktkXBR6NYShP\",\"access_key\":\"LTAI5tRm3YWuGVpjLTsz4RHs\",\"domain\":\"https://mooc-love-storage.oss-cn-beijing.aliyuncs.com\"}', 1660620367, 1700758434);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (5, 'storage', 'qcloud', '{\"engine\":\"qcloud\",\"name\":\"腾讯云存储\",\"describe\":\"存储在腾讯云，请前往腾讯云开通存储服务\",\"bucket\":\"mytest-1252415727\",\"secret_key\":\"LUdk4ShkeLsCR\",\"access_key\":\"AKID364qQq1558PXUFoAKNGiwvumX8XicOj5\",\"domain\":\"https://mytest-1252415727.cos.ap-shanghai.myqcloud.com\",\"region\":\"ap-shanghai\"}', 1660620367, 1700758438);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (6, 'sms', 'default', 'aliyun', 1660620367, 1700112398);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (7, 'sms', 'aliyun', '{\"name\":\"阿里云短信\",\"alias\":\"aliyun\",\"sign\":\"dfsdf\",\"appKey\":\"sdfsdf\",\"appId\":\"\",\"secretKey\":\"dsfdsfdssssssssss\",\"secretId\":\"\",\"status\":1}', 1660620367, 1700112398);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (10, 'website', 'name', 'Byteadmin管理系统', 1660620367, 1699336964);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (11, 'website', 'logo', '/image/20230711/0a8143ea83244c74a6c456786a792988.png', 1660620367, 1699336964);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (12, 'website', 'favicon', '/image/20230711/0a8143ea83244c74a6c456786a792988.png', 1660620367, 1699336964);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (13, 'website', 'backdrop', '/image/20230711/9678a22c7c4b40669354b5d88347c465.png', 1660620367, 1699336964);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (14, 'website', 'copyright', '[{\"name\":\"字节点点 提供技术支持\",\"link\":\"http://bytedots.cn\"}]', 1660620367, 1699337046);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (15, 'website', 'shopName', 'LikeAdmin开源系统', 1631255140, 1699336964);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (16, 'website', 'shopLogo', '/api/static/shop_logo.png', 1631255140, 1699336964);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (17, 'protocol', 'service', '{\"name\":\"服务协议\",\"content\":\"\"}', 1660620367, 1660620367);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (18, 'protocol', 'privacy', '{\"name\":\"隐私协议\",\"content\":\"\"}', 1660620367, 1660620367);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (19, 'tabbar', 'style', '{\"defaultColor\":\"#4A5DFF\",\"selectedColor\":\"#EA5455\"}', 1660620367, 1662544900);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (20, 'search', 'isHotSearch', '0', 1660620367, 1662546997);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (30, 'h5_channel', 'status', '1', 1660620367, 1660620367);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (31, 'h5_channel', 'close', '0', 1660620367, 1660620367);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (32, 'h5_channel', 'url', '', 1660620367, 1660620367);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (40, 'mp_channel', 'name', '', 1660620367, 1662551403);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (41, 'mp_channel', 'primaryId', '', 1660620367, 1662551403);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (42, 'mp_channel', 'appId', '', 1660620367, 1662551403);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (43, 'mp_channel', 'appSecret', '', 1660620367, 1662551403);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (44, 'mp_channel', 'qrCode', '', 1660620367, 1662551403);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (50, 'wx_channel', 'appId', '', 1660620367, 1660620367);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (51, 'wx_channel', 'appSecret', '', 1660620367, 1660620367);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (55, 'oa_channel', 'name', '', 1660620367, 1662551337);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (56, 'oa_channel', 'primaryId', ' ', 1660620367, 1662551337);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (57, 'oa_channel', 'qrCode', '', 1662551337, 1662551337);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (58, 'oa_channel', 'appId', '', 1660620367, 1662551337);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (59, 'oa_channel', 'appSecret', '', 1660620367, 1662551337);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (60, 'oa_channel', 'url', '', 1660620367, 1662551337);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (61, 'oa_channel', 'token', '', 1660620367, 1662551337);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (62, 'oa_channel', 'encodingAesKey', '', 1660620367, 1662551337);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (63, 'oa_channel', 'encryptionType', '1', 1660620367, 1662551337);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (64, 'oa_channel', 'menus', '[]', 1631255140, 1663118712);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (70, 'login', 'config', '{\"loginWay\":[1,2],\"forceBindMobile\":1,\"openAgreement\":1,\"openOtherAuth\":1,\"autoLoginAuth\":[1]}', 1660620367, 1700109725);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (80, 'user', 'defaultAvatar', '/api/static/default_avatar.png', 1660620367, 1700109615);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (90, 'recharge', 'config', '{\"status\":1,\"min_amount\":1}', 1699517800, 1700116427);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (91, 'pay_config', 'balance', '{\"name\":\"balance\",\"display_name\":\"余额支付\",\"icon\":\"/image/20232311/ac3004cd8e434cd38cf85e5ded07bc02.png\",\"remark\":\"\",\"domain\":\"\",\"sort\":1,\"config\":{}}', 0, 1700754397);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (92, 'pay_config', 'wechat', '{\"name\":\"wechat\",\"display_name\":\"微信支付\",\"icon\":\"/image/20231611/1022529df4d34afcb34d8624db3202ed.png\",\"remark\":\"\",\"domain\":\"\",\"sort\":2,\"config\":{\"api_client_cert\":\"dsfsdfsdfsd\",\"api_client_key\":\"cccccccccccc\",\"interface_version\":\"v3\",\"mch_id\":\"dddddddd\",\"merchant_type\":\"ordinary_merchant\",\"pay_sign_key\":\"ssssssssss\"}}', 0, 1700132322);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (93, 'pay_config', 'alipay', '{\"name\":\"alipay\",\"display_name\":\"支付宝\",\"icon\":\"/image/20231611/a3f22d1b805c43d483e063399c846c40.png\",\"remark\":\"\",\"domain\":\"\",\"sort\":3,\"config\":{\"merchant_type\":\"ordinary_merchant\",\"ali_public_key\":\"adsfadsfasdfasdfsadfsda\",\"app_id\":\"sdfsdfssdfsdfsd\",\"mode\":\"normal_mode\",\"private_key\":\"sdfsdfsdfsdfsdfsdfsdfds\"}}', 0, 1700135011);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (94, 'pay_scene', 'oa', '[{\"scene\":\"oa\",\"is_default\":0,\"status\":1,\"payment_name\":\"balance\"},{\"scene\":\"oa\",\"is_default\":1,\"status\":1,\"payment_name\":\"wechat\"},{\"scene\":\"oa\",\"is_default\":0,\"status\":0,\"payment_name\":\"alipay\"}]', 0, 1700152551);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (95, 'pay_scene', 'applet', '[{\"scene\":\"applet\",\"is_default\":0,\"status\":1,\"payment_name\":\"balance\"},{\"scene\":\"applet\",\"is_default\":1,\"status\":1,\"payment_name\":\"wechat\"},{\"scene\":\"applet\",\"is_default\":0,\"status\":0,\"payment_name\":\"alipay\"}]', 0, 1700152551);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (96, 'pay_scene', 'h5', '[{\"scene\":\"h5\",\"is_default\":0,\"status\":1,\"payment_name\":\"balance\"},{\"scene\":\"h5\",\"is_default\":1,\"status\":1,\"payment_name\":\"wechat\"},{\"scene\":\"h5\",\"is_default\":0,\"status\":0,\"payment_name\":\"alipay\"}]', 0, 1700152551);
|
||
INSERT INTO `la_system_config` (`id`, `type`, `name`, `value`, `create_time`, `update_time`) VALUES (97, 'pay_scene', 'app', '[{\"scene\":\"app\",\"is_default\":0,\"status\":1,\"payment_name\":\"balance\"},{\"scene\":\"app\",\"is_default\":1,\"status\":1,\"payment_name\":\"wechat\"},{\"scene\":\"app\",\"is_default\":0,\"status\":0,\"payment_name\":\"alipay\"}]', 0, 1700152551);
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_system_log_login
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_system_log_login`;
|
||
CREATE TABLE `la_system_log_login` (
|
||
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '注解',
|
||
`admin_id` int unsigned NOT NULL DEFAULT '0' COMMENT '管理员ID',
|
||
`username` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '登录账号',
|
||
`ip` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '登录地址',
|
||
`os` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '操作系统',
|
||
`browser` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '浏览器',
|
||
`status` tinyint unsigned NOT NULL DEFAULT '1' COMMENT '操作状态: 1=成功, 2=失败',
|
||
`create_time` int unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=92 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='系统登录日志表';
|
||
|
||
-- ----------------------------
|
||
-- Records of la_system_log_login
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (1, 1, 'admin', '::1', 'Other', 'Other', 1, 1698988134);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (2, 1, 'admin', '::1', 'Other', 'Other', 1, 1698988142);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (3, 1, 'admin', '::1', 'Other', 'Other', 1, 1698988143);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (4, 1, 'admin', '::1', 'Other', 'Other', 1, 1698988143);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (5, 1, 'admin', '::1', 'Other', 'Other', 1, 1698988145);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (6, 1, 'admin', '::1', 'Other', 'Other', 1, 1698988147);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (7, 1, 'admin', '::1', 'Other', 'Other', 1, 1698988148);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (8, 1, 'admin', '::1', 'Other', 'Other', 1, 1698988148);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (9, 1, 'admin', '::1', 'Other', 'Other', 1, 1698988149);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (10, 1, 'admin', '::1', 'Other', 'Other', 1, 1698988150);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (11, 1, 'admin', '::1', 'Other', 'Other', 1, 1698988151);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (12, 1, 'admin', '::1', 'Other', 'Other', 1, 1698988152);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (13, 1, 'admin', '::1', 'Other', 'Other', 1, 1698988490);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (14, 1, 'admin', '::1', 'Other', 'Other', 1, 1698988493);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (15, 1, 'admin', '::1', 'Other', 'Other', 1, 1698988494);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (16, 1, 'admin', '::1', 'Other', 'Other', 1, 1698988496);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (17, 1, 'admin', '::1', 'Other', 'Other', 1, 1698988497);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (18, 1, 'admin', '::1', 'Other', 'Other', 1, 1698988498);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (19, 1, 'admin', '::1', 'Other', 'Other', 1, 1698988499);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (20, 1, 'admin', '::1', 'Other', 'Other', 1, 1698988501);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (21, 1, 'admin', '::1', 'Other', 'Other', 1, 1698988502);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (22, 1, 'admin', '::1', 'Other', 'Other', 1, 1698988502);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (23, 1, 'admin', '::1', 'Other', 'Other', 1, 1698988503);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (24, 1, 'admin', '::1', 'Other', 'Other', 1, 1698988504);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (25, 1, 'admin', '::1', 'Other', 'Other', 1, 1698988505);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (26, 1, 'admin', '::1', 'Other', 'Other', 1, 1698998719);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (27, 1, 'admin', '::1', 'Other', 'Other', 1, 1698998721);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (28, 1, 'admin', '::1', 'Other', 'Other', 1, 1698998722);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (29, 1, 'admin', '::1', 'Other', 'Other', 1, 1698998723);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (30, 1, 'admin', '::1', 'Other', 'Other', 1, 1698998724);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (31, 1, 'admin', '::1', 'Other', 'Other', 1, 1699001318);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (32, 1, 'admin', '::1', 'Other', 'Other', 1, 1699010414);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (33, 1, 'admin', '::1', 'Other', 'Other', 1, 1699010621);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (34, 1, 'admin', '::1', 'Other', 'Other', 1, 1699010624);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (35, 1, 'admin', '::1', 'Other', 'Other', 1, 1699010625);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (36, 1, 'admin', '::1', 'Other', 'Other', 1, 1699010713);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (37, 1, 'admin', '::1', 'Other', 'Other', 1, 1699010806);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (38, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1699012576);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (39, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1699031159);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (40, 1, 'admin', '::1', 'Other', 'Other', 1, 1699031657);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (41, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1699072364);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (42, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1699091529);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (43, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1699091539);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (44, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1699108387);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (45, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1699159960);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (46, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1699168337);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (47, 1, 'admin', '::1', 'Other', 'Other', 1, 1699168787);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (48, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1699188807);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (49, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1699262532);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (50, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1699334569);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (51, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1699334594);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (52, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1699336429);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (53, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1699336490);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (54, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1699336943);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (55, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1699337015);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (56, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1699337179);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (57, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1699369842);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (58, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1699420576);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (59, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1699507950);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (60, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1699595112);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (61, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1699608612);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (62, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1699679548);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (63, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1699775186);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (64, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1699790637);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (65, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1699938846);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (66, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1700029047);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (67, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1700043216);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (68, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1700072435);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (69, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1700106120);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (70, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1700113894);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (71, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1700113969);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (72, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1700115630);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (73, 2, 'luojinyi', '::1', 'Mac OS X', 'Chrome', 0, 1700116026);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (74, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1700116035);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (75, 2, 'luojinyi', '::1', 'Mac OS X', 'Chrome', 1, 1700116124);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (76, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1700116148);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (77, 2, 'luojinyi', '::1', 'Mac OS X', 'Chrome', 1, 1700116179);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (78, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1700116246);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (79, 2, 'luojinyi', '::1', 'Mac OS X', 'Chrome', 1, 1700116411);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (80, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1700116477);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (81, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1700195859);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (82, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1700230033);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (83, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1700288875);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (84, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1700483424);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (85, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1700540875);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (86, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1700631255);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (87, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1700639672);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (88, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1700669898);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (89, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1700711588);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (90, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1700726062);
|
||
INSERT INTO `la_system_log_login` (`id`, `admin_id`, `username`, `ip`, `os`, `browser`, `status`, `create_time`) VALUES (91, 1, 'admin', '::1', 'Mac OS X', 'Chrome', 1, 1700744919);
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_system_log_operate
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_system_log_operate`;
|
||
CREATE TABLE `la_system_log_operate` (
|
||
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`admin_id` int unsigned NOT NULL DEFAULT '0' COMMENT '操作人ID',
|
||
`type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '请求类型: GET/POST/PUT',
|
||
`title` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '操作标题',
|
||
`ip` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '请求IP',
|
||
`url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '请求接口',
|
||
`method` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '请求方法',
|
||
`args` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '请求参数',
|
||
`error` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '错误信息',
|
||
`status` tinyint unsigned NOT NULL DEFAULT '1' COMMENT '执行状态: 1=成功, 2=失败',
|
||
`start_time` int unsigned NOT NULL DEFAULT '0' COMMENT '开始时间',
|
||
`end_time` int unsigned NOT NULL DEFAULT '0' COMMENT '结束时间',
|
||
`task_time` int unsigned NOT NULL DEFAULT '0' COMMENT '执行耗时',
|
||
`create_time` int unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=123 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='系统操作日志表';
|
||
|
||
-- ----------------------------
|
||
-- Records of la_system_log_operate
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (1, 1, 'GET', '角色列表', '::1', '/api/system/role/list', 'likeadmin/admin/routers/system.roleHandler.list-fm', 'pageNo=1&pageSize=15', '', 1, 1699013212, 1699013212, 17, 1699013212);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (2, 1, 'POST', '相册分类新增', '::1', '/api/common/album/cateAdd', 'likeadmin/admin/routers/common.albumHandler.cateAdd-fm', '{\"pid\":0,\"type\":10}', 'Error #01: 310:参数校验错误\n', 2, 1699013232, 1699013232, 1, 1699013232);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (3, 1, 'GET', '服务监控', '::1', '/api/monitor/server', 'likeadmin/admin/routers/monitor.monitorHandler.server-fm', '', '', 1, 1699013370, 1699013370, 62, 1699013370);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (4, 1, 'GET', '服务监控', '::1', '/api/monitor/server', 'likeadmin/admin/routers/monitor.monitorHandler.server-fm', '', '', 1, 1699013386, 1699013386, 59, 1699013386);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (5, 1, 'GET', '缓存监控', '::1', '/api/monitor/cache', 'likeadmin/admin/routers/monitor.monitorHandler.cache-fm', '', '', 1, 1699013396, 1699013396, 14, 1699013396);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (6, 1, 'GET', '服务监控', '::1', '/api/monitor/server', 'likeadmin/admin/routers/monitor.monitorHandler.server-fm', '', '', 1, 1699013401, 1699013401, 55, 1699013401);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (7, 1, 'GET', '缓存监控', '::1', '/api/monitor/cache', 'likeadmin/admin/routers/monitor.monitorHandler.cache-fm', '', '', 1, 1699013461, 1699013461, 4, 1699013461);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (8, 1, 'GET', '角色列表', '::1', '/api/system/role/list', 'likeadmin/admin/routers/system.roleHandler.list-fm', 'pageNo=1&pageSize=15', '', 1, 1699091567, 1699091567, 9, 1699091567);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (9, 1, 'GET', '服务监控', '::1', '/api/monitor/server', 'likeadmin/admin/routers/monitor.monitorHandler.server-fm', '', '', 1, 1699281079, 1699281079, 101, 1699281079);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (10, 1, 'GET', '缓存监控', '::1', '/api/monitor/cache', 'likeadmin/admin/routers/monitor.monitorHandler.cache-fm', '', '', 1, 1699281081, 1699281081, 3, 1699281081);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (11, 1, 'POST', '上传图片', '::1', '/api/common/upload/image', 'likeadmin/admin/routers/common.uploadHandler.uploadImage-fm', 'bytedotslogo.png', 'Error #01: 300:创建上传目录失败!\n', 2, 1699287048, 1699287048, 1, 1699287048);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (12, 1, 'POST', '上传图片', '::1', '/api/common/upload/image', 'likeadmin/admin/routers/common.uploadHandler.uploadImage-fm', '_DSC0185.JPG', 'Error #01: 300:创建上传目录失败!\n', 2, 1699287059, 1699287059, 20, 1699287059);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (13, 1, 'POST', '上传图片', '::1', '/api/common/upload/image', 'likeadmin/admin/routers/common.uploadHandler.uploadImage-fm', '1.jpeg', 'Error #01: 300:创建上传目录失败!\n', 2, 1699287160, 1699287160, 1, 1699287160);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (14, 1, 'POST', '上传图片', '::1', '/api/common/upload/image', 'likeadmin/admin/routers/common.uploadHandler.uploadImage-fm', '1.jpeg', 'Error #01: 300:创建上传目录失败!\n', 2, 1699287170, 1699287170, 1, 1699287170);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (15, 1, 'POST', '上传图片', '::1', '/api/common/upload/image', 'likeadmin/admin/routers/common.uploadHandler.uploadImage-fm', '1.jpeg', 'Error #01: 300:创建上传目录失败!\n', 2, 1699287287, 1699287287, 1, 1699287287);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (16, 1, 'POST', '上传图片', '::1', '/api/common/upload/image', 'likeadmin/admin/routers/common.uploadHandler.uploadImage-fm', '2.jpg', 'Error #01: 300:上传图片不能超出限制: 10M\n', 2, 1699287302, 1699287302, 29, 1699287302);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (17, 1, 'POST', '上传图片', '::1', '/api/common/upload/image', 'likeadmin/admin/routers/common.uploadHandler.uploadImage-fm', '1.jpeg', '', 1, 1699287308, 1699287308, 14, 1699287308);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (18, 1, 'POST', '相册文件删除', '::1', '/api/common/album/albumDel', 'likeadmin/admin/routers/common.albumHandler.albumDel-fm', '{\"ids\":[1]}', '', 1, 1699287319, 1699287319, 10, 1699287319);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (19, 1, 'POST', '上传图片', '::1', '/api/common/upload/image', 'likeadmin/admin/routers/common.uploadHandler.uploadImage-fm', 'bytedotslogo.png', '', 1, 1699287365, 1699287365, 8, 1699287365);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (20, 1, 'GET', '服务监控', '::1', '/api/monitor/server', 'likeadmin/admin/routers/monitor.monitorHandler.server-fm', '', '', 1, 1699287807, 1699287807, 62, 1699287807);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (21, 1, 'GET', '缓存监控', '::1', '/api/monitor/cache', 'likeadmin/admin/routers/monitor.monitorHandler.cache-fm', '', '', 1, 1699287808, 1699287808, 4, 1699287808);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (22, 1, 'GET', '缓存监控', '::1', '/api/monitor/cache', 'likeadmin/admin/routers/monitor.monitorHandler.cache-fm', '', '', 1, 1699287845, 1699287845, 9, 1699287845);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (23, 1, 'GET', '服务监控', '::1', '/api/monitor/server', 'likeadmin/admin/routers/monitor.monitorHandler.server-fm', '', '', 1, 1699287859, 1699287859, 58, 1699287859);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (24, 1, 'POST', '上传图片', '::1', '/api/common/upload/image', 'likeadmin/admin/routers/common.uploadHandler.uploadImage-fm', 'u=2725031792,168326554&fm=30&app=106&f=JPEG.jpeg', '', 1, 1699334610, 1699334610, 8, 1699334610);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (25, 1, 'POST', '上传图片', '::1', '/api/common/upload/image', 'likeadmin/admin/routers/common.uploadHandler.uploadImage-fm', 'backend_backdrop2.png', '', 1, 1699336440, 1699336440, 23, 1699336440);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (26, 1, 'POST', '管理员新增', '::1', '/api/system/admin/add', 'likeadmin/admin/routers/system.adminHandler.add-fm', '{\"avatar\":\"http://127.0.0.1:8001/api/uploads/image/20230711/0a8143ea83244c74a6c456786a792988.png\",\"deptId\":1,\"id\":\"\",\"isDisable\":0,\"isMultipoint\":1,\"nickname\":\"太枯燥时\",\"password\":\"123456\",\"passwordConfirm\":\"123456\",\"postId\":[1],\"role\":[1],\"sort\":1,\"username\":\"del\"}', 'Error #01: 310:参数校验错误\n', 2, 1699375053, 1699375053, 1, 1699375053);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (27, 1, 'POST', '管理员新增', '::1', '/api/system/admin/add', 'likeadmin/admin/routers/system.adminHandler.add-fm', '{\"avatar\":\"http://127.0.0.1:8001/api/uploads/image/20230711/0a8143ea83244c74a6c456786a792988.png\",\"deptId\":1,\"id\":\"\",\"isDisable\":0,\"isMultipoint\":1,\"nickname\":\"太枯燥时\",\"password\":\"123456\",\"passwordConfirm\":\"123456\",\"postId\":[1],\"role\":[1],\"sort\":1,\"username\":\"del\"}', 'Error #01: 310:参数校验错误\n', 2, 1699375065, 1699375065, 1, 1699375065);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (28, 1, 'GET', '角色列表', '::1', '/api/system/role/list', 'likeadmin/admin/routers/system.roleHandler.list-fm', 'pageNo=1&pageSize=15', '', 1, 1699508078, 1699508078, 9, 1699508078);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (29, 1, 'POST', '上传图片', '::1', '/api/common/upload/image', 'likeadmin/admin/routers/common.uploadHandler.uploadImage-fm', 'metamaskico.png', '', 1, 1699512751, 1699512751, 11, 1699512751);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (30, 1, 'GET', '角色列表', '::1', '/api/system/role/list', 'likeadmin/admin/routers/system.roleHandler.list-fm', 'pageNo=1&pageSize=15', '', 1, 1699524368, 1699524368, 16, 1699524368);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (31, 1, 'POST', '相册分类新增', '::1', '/api/common/album/cateAdd', 'likeadmin/admin/routers/common.albumHandler.cateAdd-fm', '{\"name\":\"系统图片\",\"pid\":0,\"type\":10}', '', 1, 1699540160, 1699540160, 11, 1699540160);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (32, 1, 'POST', '相册分类删除', '::1', '/api/common/album/cateDel', 'likeadmin/admin/routers/common.albumHandler.cateDel-fm', '{\"id\":1}', '', 1, 1699540188, 1699540188, 15, 1699540188);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (33, 1, 'POST', '相册文件删除', '::1', '/api/common/album/albumDel', 'likeadmin/admin/routers/common.albumHandler.albumDel-fm', '{\"ids\":[4]}', '', 1, 1699540253, 1699540253, 20, 1699540253);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (34, 1, 'POST', '相册文件删除', '::1', '/api/common/album/albumDel', 'likeadmin/admin/routers/common.albumHandler.albumDel-fm', '{\"ids\":[3]}', '', 1, 1699540257, 1699540257, 16, 1699540257);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (35, 1, 'POST', '相册文件删除', '::1', '/api/common/album/albumDel', 'likeadmin/admin/routers/common.albumHandler.albumDel-fm', '{\"ids\":[2]}', '', 1, 1699540260, 1699540260, 9, 1699540260);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (36, 1, 'POST', '相册文件删除', '::1', '/api/common/album/albumDel', 'likeadmin/admin/routers/common.albumHandler.albumDel-fm', '{\"ids\":[5]}', '', 1, 1699540263, 1699540263, 14, 1699540263);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (37, 1, 'POST', '相册分类新增', '::1', '/api/common/album/cateAdd', 'likeadmin/admin/routers/common.albumHandler.cateAdd-fm', '{\"name\":\"系统默认图片\",\"pid\":0,\"type\":10}', '', 1, 1699540272, 1699540272, 11, 1699540272);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (38, 1, 'POST', '上传图片', '::1', '/api/common/upload/image', 'likeadmin/admin/routers/common.uploadHandler.uploadImage-fm', 'backend_backdrop2.png', '', 1, 1699540290, 1699540290, 11, 1699540290);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (39, 1, 'POST', '上传图片', '::1', '/api/common/upload/image', 'likeadmin/admin/routers/common.uploadHandler.uploadImage-fm', 'backend_backdrop2.png', '', 1, 1699540355, 1699540355, 7, 1699540355);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (40, 1, 'POST', '相册分类删除', '::1', '/api/common/album/cateDel', 'likeadmin/admin/routers/common.albumHandler.cateDel-fm', '{\"id\":2}', 'Error #01: 313:当前分类正被使用中,不能删除！\n', 2, 1699549541, 1699549541, 12, 1699549541);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (41, 1, 'POST', '相册分类删除', '::1', '/api/common/album/cateDel', 'likeadmin/admin/routers/common.albumHandler.cateDel-fm', '{\"id\":2}', 'Error #01: 313:当前分类正被使用中,不能删除！\n', 2, 1699549549, 1699549549, 6, 1699549549);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (42, 1, 'POST', '相册文件删除', '::1', '/api/common/album/albumDel', 'likeadmin/admin/routers/common.albumHandler.albumDel-fm', '{\"ids\":[6]}', '', 1, 1699552406, 1699552406, 17, 1699552406);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (43, 1, 'GET', '角色列表', '::1', '/api/system/role/list', 'likeadmin/admin/routers/system.roleHandler.list-fm', 'pageNo=1&pageSize=15', '', 1, 1700071840, 1700071840, 7, 1700071840);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (44, 1, 'GET', '角色详情', '::1', '/api/system/role/detail', 'likeadmin/admin/routers/system.roleHandler.detail-fm', 'id=1', '', 1, 1700071844, 1700071844, 8, 1700071844);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (45, 1, 'POST', '角色新增', '::1', '/api/system/role/add', 'likeadmin/admin/routers/system.roleHandler.add-fm', '{\"id\":\"\",\"isDisable\":0,\"menuIds\":\"\",\"menus\":[],\"name\":\"开发人员\",\"remark\":\"\",\"sort\":0}', '', 1, 1700071890, 1700071890, 20, 1700071890);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (46, 1, 'GET', '角色列表', '::1', '/api/system/role/list', 'likeadmin/admin/routers/system.roleHandler.list-fm', 'pageNo=1&pageSize=15', '', 1, 1700071890, 1700071890, 9, 1700071890);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (47, 1, 'GET', '角色详情', '::1', '/api/system/role/detail', 'likeadmin/admin/routers/system.roleHandler.detail-fm', 'id=2', '', 1, 1700071898, 1700071898, 9, 1700071898);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (48, 1, 'GET', '角色列表', '::1', '/api/system/role/list', 'likeadmin/admin/routers/system.roleHandler.list-fm', 'pageNo=1&pageSize=15', '', 1, 1700112744, 1700112744, 15, 1700112744);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (49, 1, 'GET', '角色详情', '::1', '/api/system/role/detail', 'likeadmin/admin/routers/system.roleHandler.detail-fm', 'id=1', '', 1, 1700112746, 1700112746, 9, 1700112746);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (50, 1, 'POST', '管理员编辑', '::1', '/api/system/admin/edit', 'likeadmin/admin/routers/system.adminHandler.edit-fm', '{\"avatar\":\"\",\"deptId\":1,\"id\":1,\"isDisable\":0,\"isMultipoint\":1,\"nickname\":\"admin\",\"password\":\"123456\",\"passwordConfirm\":\"123456\",\"postId\":[1],\"role\":0,\"sort\":1,\"username\":\"admin\"}', 'Error #01: 310:参数校验错误\n', 2, 1700112960, 1700112960, 0, 1700112960);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (51, 1, 'POST', '管理员编辑', '::1', '/api/system/admin/edit', 'likeadmin/admin/routers/system.adminHandler.edit-fm', '{\"avatar\":\"\",\"deptId\":1,\"id\":1,\"isDisable\":0,\"isMultipoint\":1,\"nickname\":\"admin\",\"password\":\"123456\",\"passwordConfirm\":\"123456\",\"postId\":1,\"role\":0,\"sort\":1,\"username\":\"admin\"}', '', 1, 1700113887, 1700113887, 31, 1700113887);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (52, 1, 'POST', '上传图片', '::1', '/api/common/upload/image', 'likeadmin/admin/routers/common.uploadHandler.uploadImage-fm', 'WX20230811-010416@2x.png', '', 1, 1700113950, 1700113950, 19, 1700113950);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (53, 1, 'POST', '管理员编辑', '::1', '/api/system/admin/edit', 'likeadmin/admin/routers/system.adminHandler.edit-fm', '{\"avatar\":\"http://127.0.0.1:8001/api/uploads/image/20231611/872472ee657a4a4f9ae8aace06961b8d.png\",\"deptId\":1,\"id\":1,\"isDisable\":0,\"isMultipoint\":1,\"nickname\":\"admin\",\"password\":\"123456\",\"passwordConfirm\":\"123456\",\"postId\":1,\"role\":0,\"sort\":1,\"username\":\"admin\"}', '', 1, 1700113965, 1700113965, 53, 1700113965);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (54, 1, 'POST', '管理员编辑', '::1', '/api/system/admin/edit', 'likeadmin/admin/routers/system.adminHandler.edit-fm', '{\"avatar\":\"http://127.0.0.1:8001/api/uploads/image/20231611/872472ee657a4a4f9ae8aace06961b8d.png\",\"deptId\":1,\"id\":1,\"isDisable\":0,\"isMultipoint\":1,\"nickname\":\"admin\",\"password\":\"123456\",\"passwordConfirm\":\"123456\",\"postId\":1,\"role\":0,\"sort\":1,\"username\":\"admin\"}', '', 1, 1700115624, 1700115624, 61, 1700115624);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (55, 1, 'POST', '上传图片', '::1', '/api/common/upload/image', 'likeadmin/admin/routers/common.uploadHandler.uploadImage-fm', 'WX20230811-005953@2x.png', '', 1, 1700115795, 1700115795, 14, 1700115795);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (56, 1, 'POST', '管理员新增', '::1', '/api/system/admin/add', 'likeadmin/admin/routers/system.adminHandler.add-fm', '{\"avatar\":\"http://127.0.0.1:8001/api/uploads/image/20231611/dd2adfb1df364ec4ba2483297aead3e0.png\",\"deptId\":1,\"id\":\"\",\"isDisable\":0,\"isMultipoint\":1,\"nickname\":\"罗锦毅\",\"password\":\"123456\",\"passwordConfirm\":\"123456\",\"postId\":1,\"role\":[2,1],\"sort\":1,\"username\":\"luojinyi\"}', 'Error #01: 310:参数校验错误\n', 2, 1700115830, 1700115830, 0, 1700115830);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (57, 1, 'POST', '管理员新增', '::1', '/api/system/admin/add', 'likeadmin/admin/routers/system.adminHandler.add-fm', '{\"avatar\":\"http://127.0.0.1:8001/api/uploads/image/20231611/dd2adfb1df364ec4ba2483297aead3e0.png\",\"deptId\":1,\"id\":\"\",\"isDisable\":0,\"isMultipoint\":1,\"nickname\":\"罗锦毅\",\"password\":\"123456\",\"passwordConfirm\":\"123456\",\"postId\":1,\"role\":2,\"sort\":1,\"username\":\"luojinyi\"}', '', 1, 1700115994, 1700115994, 29, 1700115994);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (58, 1, 'POST', '管理员状态切换', '::1', '/api/system/admin/disable', 'likeadmin/admin/routers/system.adminHandler.disable-fm', '{\"id\":2}', '', 1, 1700116001, 1700116001, 18, 1700116001);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (59, 1, 'POST', '管理员状态切换', '::1', '/api/system/admin/disable', 'likeadmin/admin/routers/system.adminHandler.disable-fm', '{\"id\":2}', '', 1, 1700116046, 1700116046, 29, 1700116046);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (60, 1, 'POST', '管理员状态切换', '::1', '/api/system/admin/disable', 'likeadmin/admin/routers/system.adminHandler.disable-fm', '{\"id\":2}', '', 1, 1700116054, 1700116054, 15, 1700116054);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (61, 1, 'POST', '管理员状态切换', '::1', '/api/system/admin/disable', 'likeadmin/admin/routers/system.adminHandler.disable-fm', '{\"id\":2}', '', 1, 1700116070, 1700116070, 10, 1700116070);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (62, 1, 'GET', '角色列表', '::1', '/api/system/role/list', 'likeadmin/admin/routers/system.roleHandler.list-fm', 'pageNo=1&pageSize=15', '', 1, 1700116158, 1700116158, 16, 1700116158);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (63, 1, 'GET', '角色详情', '::1', '/api/system/role/detail', 'likeadmin/admin/routers/system.roleHandler.detail-fm', 'id=2', '', 1, 1700116160, 1700116160, 16, 1700116160);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (64, 1, 'POST', '角色编辑', '::1', '/api/system/role/edit', 'likeadmin/admin/routers/system.roleHandler.edit-fm', '{\"id\":2,\"isDisable\":0,\"menuIds\":\"1,775,776,777,778,779,780,789,790\",\"menus\":[1,775,776,777,778,779,780,789,790],\"name\":\"开发人员\",\"remark\":\"\",\"sort\":0}', '', 1, 1700116168, 1700116168, 49, 1700116168);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (65, 1, 'GET', '角色列表', '::1', '/api/system/role/list', 'likeadmin/admin/routers/system.roleHandler.list-fm', 'pageNo=1&pageSize=15', '', 1, 1700116168, 1700116168, 11, 1700116168);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (66, 1, 'GET', '角色列表', '::1', '/api/system/role/list', 'likeadmin/admin/routers/system.roleHandler.list-fm', 'pageNo=1&pageSize=15', '', 1, 1700116389, 1700116389, 12, 1700116389);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (67, 1, 'GET', '角色详情', '::1', '/api/system/role/detail', 'likeadmin/admin/routers/system.roleHandler.detail-fm', 'id=2', '', 1, 1700116391, 1700116391, 13, 1700116391);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (68, 1, 'POST', '角色编辑', '::1', '/api/system/role/edit', 'likeadmin/admin/routers/system.roleHandler.edit-fm', '{\"id\":2,\"isDisable\":0,\"menuIds\":\"1,775,776,777,778,779,780,789,790\",\"menus\":[1,775,776,777,778,779,780,789,790],\"name\":\"开发人员\",\"remark\":\"\",\"sort\":0}', '', 1, 1700116399, 1700116399, 46, 1700116399);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (69, 1, 'GET', '角色列表', '::1', '/api/system/role/list', 'likeadmin/admin/routers/system.roleHandler.list-fm', 'pageNo=1&pageSize=15', '', 1, 1700116399, 1700116399, 9, 1700116399);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (70, 1, 'POST', '管理员状态切换', '::1', '/api/system/admin/disable', 'likeadmin/admin/routers/system.adminHandler.disable-fm', '{\"id\":2}', '', 1, 1700116566, 1700116566, 14, 1700116566);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (71, 1, 'POST', '管理员状态切换', '::1', '/api/system/admin/disable', 'likeadmin/admin/routers/system.adminHandler.disable-fm', '{\"id\":2}', '', 1, 1700116578, 1700116578, 11, 1700116578);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (72, 1, 'POST', '管理员状态切换', '::1', '/api/system/admin/disable', 'likeadmin/admin/routers/system.adminHandler.disable-fm', '{\"id\":2}', '', 1, 1700116830, 1700116830, 15, 1700116830);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (73, 1, 'POST', '管理员状态切换', '::1', '/api/system/admin/disable', 'likeadmin/admin/routers/system.adminHandler.disable-fm', '{\"id\":2}', '', 1, 1700116834, 1700116834, 12, 1700116834);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (74, 1, 'POST', '管理员状态切换', '::1', '/api/system/admin/disable', 'likeadmin/admin/routers/system.adminHandler.disable-fm', '{\"id\":2}', '', 1, 1700116837, 1700116837, 14, 1700116837);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (75, 1, 'POST', '管理员状态切换', '::1', '/api/system/admin/disable', 'likeadmin/admin/routers/system.adminHandler.disable-fm', '{\"id\":2}', '', 1, 1700122222, 1700122222, 32, 1700122222);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (76, 1, 'POST', '管理员状态切换', '::1', '/api/system/admin/disable', 'likeadmin/admin/routers/system.adminHandler.disable-fm', '{\"id\":2}', '', 1, 1700122228, 1700122228, 12, 1700122228);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (77, 1, 'POST', '管理员状态切换', '::1', '/api/system/admin/disable', 'likeadmin/admin/routers/system.adminHandler.disable-fm', '{\"id\":2}', '', 1, 1700122232, 1700122232, 16, 1700122232);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (78, 1, 'POST', '管理员状态切换', '::1', '/api/system/admin/disable', 'likeadmin/admin/routers/system.adminHandler.disable-fm', '{\"id\":2}', '', 1, 1700122235, 1700122235, 15, 1700122235);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (79, 1, 'GET', '角色列表', '::1', '/api/system/role/list', 'likeadmin/admin/routers/system.roleHandler.list-fm', 'pageNo=1&pageSize=15', '', 1, 1700122266, 1700122266, 9, 1700122266);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (80, 1, 'GET', '角色详情', '::1', '/api/system/role/detail', 'likeadmin/admin/routers/system.roleHandler.detail-fm', 'id=2', '', 1, 1700122272, 1700122272, 9, 1700122272);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (81, 1, 'GET', '角色详情', '::1', '/api/system/role/detail', 'likeadmin/admin/routers/system.roleHandler.detail-fm', 'id=1', '', 1, 1700122276, 1700122276, 16, 1700122276);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (82, 1, 'GET', '服务监控', '::1', '/api/monitor/server', 'likeadmin/admin/routers/monitor.monitorHandler.server-fm', '', '', 1, 1700122365, 1700122365, 84, 1700122365);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (83, 1, 'GET', '缓存监控', '::1', '/api/monitor/cache', 'likeadmin/admin/routers/monitor.monitorHandler.cache-fm', '', '', 1, 1700122369, 1700122369, 8, 1700122369);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (84, 1, 'GET', '缓存监控', '::1', '/api/monitor/cache', 'likeadmin/admin/routers/monitor.monitorHandler.cache-fm', '', '', 1, 1700122439, 1700122439, 11, 1700122439);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (85, 1, 'GET', '服务监控', '::1', '/api/monitor/server', 'likeadmin/admin/routers/monitor.monitorHandler.server-fm', '', '', 1, 1700122449, 1700122449, 67, 1700122449);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (86, 1, 'POST', '上传图片', '::1', '/api/common/upload/image', 'likeadmin/admin/routers/common.uploadHandler.uploadImage-fm', 'balance_pay.png', '', 1, 1700130866, 1700130866, 18, 1700130866);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (87, 1, 'POST', '上传图片', '::1', '/api/common/upload/image', 'likeadmin/admin/routers/common.uploadHandler.uploadImage-fm', 'wechat_pay.png', '', 1, 1700131773, 1700131773, 8, 1700131773);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (88, 1, 'POST', '相册文件删除', '::1', '/api/common/album/albumDel', 'likeadmin/admin/routers/common.albumHandler.albumDel-fm', '{\"ids\":[10]}', '', 1, 1700132220, 1700132220, 41, 1700132220);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (89, 1, 'POST', '相册文件删除', '::1', '/api/common/album/albumDel', 'likeadmin/admin/routers/common.albumHandler.albumDel-fm', '{\"ids\":[11]}', '', 1, 1700132223, 1700132223, 20, 1700132223);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (90, 1, 'POST', '上传图片', '::1', '/api/common/upload/image', 'likeadmin/admin/routers/common.uploadHandler.uploadImage-fm', 'alipay.png', '', 1, 1700132228, 1700132228, 8, 1700132228);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (91, 1, 'POST', '上传图片', '::1', '/api/common/upload/image', 'likeadmin/admin/routers/common.uploadHandler.uploadImage-fm', 'balance.png', '', 1, 1700132264, 1700132264, 8, 1700132264);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (92, 1, 'POST', '上传图片', '::1', '/api/common/upload/image', 'likeadmin/admin/routers/common.uploadHandler.uploadImage-fm', 'wechat.png', '', 1, 1700132313, 1700132313, 8, 1700132313);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (93, 1, 'GET', '角色列表', '::1', '/api/system/role/list', 'likeadmin/admin/routers/system.roleHandler.list-fm', 'pageNo=1&pageSize=15', '', 1, 1700722072, 1700722072, 8, 1700722072);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (94, 1, 'POST', '上传图片', '::1', '/api/common/upload/image', 'likeadmin/admin/routers/common.uploadHandler.uploadImage-fm', '04879a5cb178389f2c549ef42c2800c2.JPG', 'Error #01: 500:系统错误\n', 2, 1700729500, 1700729500, 113, 1700729500);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (95, 1, 'POST', '相册文件删除', '::1', '/api/common/album/albumDel', 'likeadmin/admin/routers/common.albumHandler.albumDel-fm', '{\"ids\":[7]}', '', 1, 1700729562, 1700729562, 15, 1700729562);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (96, 1, 'POST', '上传图片', '::1', '/api/common/upload/image', 'likeadmin/admin/routers/common.uploadHandler.uploadImage-fm', 'u=2725031792,168326554&fm=30&app=106&f=JPEG.jpeg', 'Error #01: 500:系统错误\n', 2, 1700729793, 1700729793, 135, 1700729793);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (97, 1, 'POST', '上传图片', '::1', '/api/common/upload/image', 'likeadmin/admin/routers/common.uploadHandler.uploadImage-fm', 'u=2725031792,168326554&fm=30&app=106&f=JPEG.jpeg', 'Error #01: 500:系统错误\n', 2, 1700729990, 1700729990, 218, 1700729990);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (98, 1, 'POST', '上传图片', '::1', '/api/common/upload/image', 'likeadmin/admin/routers/common.uploadHandler.uploadImage-fm', 'backend_backdrop.png', 'Error #01: 500:系统错误\n', 2, 1700730032, 1700730032, 18, 1700730032);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (99, 1, 'POST', '上传图片', '::1', '/api/common/upload/image', 'likeadmin/admin/routers/common.uploadHandler.uploadImage-fm', 'backend_backdrop.png', 'Error #01: 500:系统错误\n', 2, 1700730065, 1700730065, 4, 1700730065);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (100, 1, 'POST', '上传图片', '::1', '/api/common/upload/image', 'likeadmin/admin/routers/common.uploadHandler.uploadImage-fm', 'backend_backdrop.png', 'Error #01: 500:系统错误\n', 2, 1700730217, 1700730217, 7, 1700730217);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (101, 1, 'POST', '上传图片', '::1', '/api/common/upload/image', 'likeadmin/admin/routers/common.uploadHandler.uploadImage-fm', 'backend_backdrop.png', 'Error #01: 500:系统错误\n', 2, 1700730252, 1700730252, 7, 1700730252);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (102, 1, 'POST', '上传图片', '::1', '/api/common/upload/image', 'likeadmin/admin/routers/common.uploadHandler.uploadImage-fm', 'backend_backdrop2.png', 'Error #01: 500:系统错误\n', 2, 1700730416, 1700730417, 534, 1700730417);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (103, 1, 'POST', '上传图片', '::1', '/api/common/upload/image', 'likeadmin/admin/routers/common.uploadHandler.uploadImage-fm', 'backend_backdrop.png', '', 1, 1700730928, 1700730929, 601, 1700730929);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (104, 1, 'POST', '相册文件删除', '::1', '/api/common/album/albumDel', 'likeadmin/admin/routers/common.albumHandler.albumDel-fm', '{\"ids\":[15]}', '', 1, 1700732213, 1700732213, 24, 1700732213);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (105, 1, 'POST', '上传图片', '::1', '/api/common/upload/image', 'likeadmin/admin/routers/common.uploadHandler.uploadImage-fm', 'backend_backdrop.png', '', 1, 1700732218, 1700732219, 692, 1700732219);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (106, 1, 'POST', '相册文件删除', '::1', '/api/common/album/albumDel', 'likeadmin/admin/routers/common.albumHandler.albumDel-fm', '{\"ids\":[16]}', '', 1, 1700735943, 1700735943, 27, 1700735943);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (107, 1, 'POST', '上传图片', '::1', '/api/common/upload/image', 'likeadmin/admin/routers/common.uploadHandler.uploadImage-fm', 'backend_backdrop.png', '', 1, 1700749117, 1700749117, 17, 1700749117);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (108, 1, 'POST', '相册文件删除', '::1', '/api/common/album/albumDel', 'likeadmin/admin/routers/common.albumHandler.albumDel-fm', '{\"ids\":[17]}', '', 1, 1700749130, 1700749130, 21, 1700749130);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (109, 1, 'POST', '上传图片', '::1', '/api/common/upload/image', 'likeadmin/admin/routers/common.uploadHandler.uploadImage-fm', 'backend_backdrop.png', '', 1, 1700749382, 1700749382, 15, 1700749382);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (110, 1, 'POST', '相册文件删除', '::1', '/api/common/album/albumDel', 'likeadmin/admin/routers/common.albumHandler.albumDel-fm', '{\"ids\":[18]}', '', 1, 1700749389, 1700749389, 20, 1700749389);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (111, 1, 'POST', '上传图片', '::1', '/api/common/upload/image', 'likeadmin/admin/routers/common.uploadHandler.uploadImage-fm', 'backend_backdrop2.png', '', 1, 1700749895, 1700749895, 13, 1700749895);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (112, 1, 'POST', '相册文件删除', '::1', '/api/common/album/albumDel', 'likeadmin/admin/routers/common.albumHandler.albumDel-fm', '{\"ids\":[19]}', '', 1, 1700749904, 1700749904, 40, 1700749904);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (113, 1, 'POST', '上传图片', '::1', '/api/common/upload/image', 'likeadmin/admin/routers/common.uploadHandler.uploadImage-fm', 'backend_backdrop.png', '', 1, 1700749929, 1700749929, 353, 1700749929);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (114, 1, 'POST', '相册文件删除', '::1', '/api/common/album/albumDel', 'likeadmin/admin/routers/common.albumHandler.albumDel-fm', '{\"ids\":[20]}', '', 1, 1700749992, 1700749992, 212, 1700749992);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (115, 1, 'POST', '上传图片', '::1', '/api/common/upload/image', 'likeadmin/admin/routers/common.uploadHandler.uploadImage-fm', 'WX20230811-002454@2x.png', '', 1, 1700754054, 1700754054, 476, 1700754054);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (116, 1, 'POST', '相册文件删除', '::1', '/api/common/album/albumDel', 'likeadmin/admin/routers/common.albumHandler.albumDel-fm', '{\"ids\":[21]}', '', 1, 1700754137, 1700754137, 359, 1700754137);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (117, 1, 'POST', '上传图片', '::1', '/api/common/upload/image', 'likeadmin/admin/routers/common.uploadHandler.uploadImage-fm', 'WX20230811-003408@2x.png', '', 1, 1700754357, 1700754357, 560, 1700754357);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (118, 1, 'POST', '相册文件删除', '::1', '/api/common/album/albumDel', 'likeadmin/admin/routers/common.albumHandler.albumDel-fm', '{\"ids\":[22]}', '', 1, 1700754440, 1700754440, 326, 1700754440);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (119, 1, 'POST', '上传图片', '::1', '/api/common/upload/image', 'likeadmin/admin/routers/common.uploadHandler.uploadImage-fm', '04879a5cb178389f2c549ef42c2800c2.JPG', '', 1, 1700757959, 1700757960, 791, 1700757960);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (120, 1, 'POST', '相册文件删除', '::1', '/api/common/album/albumDel', 'likeadmin/admin/routers/common.albumHandler.albumDel-fm', '{\"ids\":[23]}', '', 1, 1700758006, 1700758006, 347, 1700758006);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (121, 1, 'POST', '上传视频', '::1', '/api/common/upload/video', 'likeadmin/admin/routers/common.uploadHandler.uploadVideo-fm', '19323.MP4', '', 1, 1700758133, 1700758134, 1067, 1700758134);
|
||
INSERT INTO `la_system_log_operate` (`id`, `admin_id`, `type`, `title`, `ip`, `url`, `method`, `args`, `error`, `status`, `start_time`, `end_time`, `task_time`, `create_time`) VALUES (122, 1, 'POST', '相册文件删除', '::1', '/api/common/album/albumDel', 'likeadmin/admin/routers/common.albumHandler.albumDel-fm', '{\"ids\":[24]}', '', 1, 1700758213, 1700758213, 310, 1700758213);
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_system_log_sms
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_system_log_sms`;
|
||
CREATE TABLE `la_system_log_sms` (
|
||
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
`scene` int unsigned NOT NULL DEFAULT '0' COMMENT '场景编号',
|
||
`mobile` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '手机号码',
|
||
`content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '发送内容',
|
||
`status` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '发送状态：[0=发送中, 1=发送成功, 2=发送失败]',
|
||
`results` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '短信结果',
|
||
`send_time` int unsigned NOT NULL DEFAULT '0' COMMENT '发送时间',
|
||
`create_time` int unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
|
||
`update_time` int unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='系统短信日志表';
|
||
|
||
-- ----------------------------
|
||
-- Records of la_system_log_sms
|
||
-- ----------------------------
|
||
BEGIN;
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_user
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_user`;
|
||
CREATE TABLE `la_user` (
|
||
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`sn` bigint 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 unsigned NOT NULL DEFAULT '0' COMMENT '用户性别: [1=男, 2=女]',
|
||
`channel` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '注册渠道: [1-微信小程序 2-微信公众号 3-手机H5 4-电脑PC 5-苹果APP 6-安卓APP]',
|
||
`is_disable` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '是否禁用: [0=否, 1=是]',
|
||
`login_ip` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '最后登录IP',
|
||
`login_time` int unsigned NOT NULL DEFAULT '0' COMMENT '最后登录时间',
|
||
`is_new_user` tinyint NOT NULL DEFAULT '0' COMMENT '是否是新注册用户: [1-是, 0-否]',
|
||
`user_money` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '用户余额',
|
||
`total_recharge_amount` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '累计充值',
|
||
`create_time` int unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
|
||
`update_time` int unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`delete_time` int unsigned DEFAULT NULL COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `sn` (`sn`) USING BTREE COMMENT '编号唯一',
|
||
UNIQUE KEY `account` (`account`) USING BTREE COMMENT '账号唯一',
|
||
KEY `idx_mobile` (`mobile`),
|
||
KEY `idx_nickname` (`nickname`),
|
||
KEY `idx_real_name` (`real_name`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户表';
|
||
|
||
-- ----------------------------
|
||
-- Records of la_user
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `la_user` (`id`, `sn`, `avatar`, `real_name`, `nickname`, `account`, `password`, `mobile`, `sex`, `channel`, `is_disable`, `login_ip`, `login_time`, `is_new_user`, `user_money`, `total_recharge_amount`, `create_time`, `update_time`, `delete_time`) VALUES (1, 23230, '/api/static/default_avatar.png', '时代发生的d', 'wewe', '是多大的的', 'ere', '13880000000', 1, 0, 0, '', 1699274409, 0, 2129.00, 0.00, 1699274409, 1700108468, NULL);
|
||
INSERT INTO `la_user` (`id`, `sn`, `avatar`, `real_name`, `nickname`, `account`, `password`, `mobile`, `sex`, `channel`, `is_disable`, `login_ip`, `login_time`, `is_new_user`, `user_money`, `total_recharge_amount`, `create_time`, `update_time`, `delete_time`) VALUES (2, 5454, '/api/static/default_avatar.png', 'sdfsd', '3434', 'dsfdsf', '', '13788888888', 2, 0, 0, '', 1699274409, 0, 5405.00, 0.00, 1699274409, 1700500980, NULL);
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_user_account_log
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_user_account_log`;
|
||
CREATE TABLE `la_user_account_log` (
|
||
`id` int unsigned NOT NULL AUTO_INCREMENT,
|
||
`sn` bigint unsigned NOT NULL COMMENT '用户编号',
|
||
`user_id` int NOT NULL COMMENT '用户id',
|
||
`change_object` tinyint NOT NULL DEFAULT '0' COMMENT '变动对象',
|
||
`change_type` smallint NOT NULL COMMENT '变动类型',
|
||
`action` tinyint NOT NULL DEFAULT '0' COMMENT '动作 1-增加 2-减少',
|
||
`change_amount` decimal(10,2) NOT NULL COMMENT '变动数量',
|
||
`left_amount` decimal(10,2) NOT NULL COMMENT '变动后数量',
|
||
`source_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '关联单号',
|
||
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '备注',
|
||
`extra` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '预留扩展字段',
|
||
`create_time` int DEFAULT NULL COMMENT '创建时间',
|
||
`update_time` int DEFAULT NULL COMMENT '更新时间',
|
||
`delete_time` int DEFAULT NULL COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `idx_user_id` (`user_id`),
|
||
KEY `idx_sn` (`sn`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户余额变动日志';
|
||
|
||
-- ----------------------------
|
||
-- Records of la_user_account_log
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `la_user_account_log` (`id`, `sn`, `user_id`, `change_object`, `change_type`, `action`, `change_amount`, `left_amount`, `source_sn`, `remark`, `extra`, `create_time`, `update_time`, `delete_time`) VALUES (1, 483, 1, 1, 200, 1, 34.00, 34.00, '', '', '', 0, 0, 0);
|
||
INSERT INTO `la_user_account_log` (`id`, `sn`, `user_id`, `change_object`, `change_type`, `action`, `change_amount`, `left_amount`, `source_sn`, `remark`, `extra`, `create_time`, `update_time`, `delete_time`) VALUES (2, 8488, 1, 1, 100, 2, 34.00, 0.00, '', '', '', 0, 0, 0);
|
||
INSERT INTO `la_user_account_log` (`id`, `sn`, `user_id`, `change_object`, `change_type`, `action`, `change_amount`, `left_amount`, `source_sn`, `remark`, `extra`, `create_time`, `update_time`, `delete_time`) VALUES (3, 4490, 1, 1, 200, 1, 100.00, 100.00, '', '', '', 0, 0, 0);
|
||
INSERT INTO `la_user_account_log` (`id`, `sn`, `user_id`, `change_object`, `change_type`, `action`, `change_amount`, `left_amount`, `source_sn`, `remark`, `extra`, `create_time`, `update_time`, `delete_time`) VALUES (4, 3073579, 1, 1, 100, 2, 47.00, 53.00, '', '', '', 0, 0, 0);
|
||
INSERT INTO `la_user_account_log` (`id`, `sn`, `user_id`, `change_object`, `change_type`, `action`, `change_amount`, `left_amount`, `source_sn`, `remark`, `extra`, `create_time`, `update_time`, `delete_time`) VALUES (5, 8217, 1, 1, 100, 2, 53.00, 0.00, '', '', '', 0, 0, 0);
|
||
INSERT INTO `la_user_account_log` (`id`, `sn`, `user_id`, `change_object`, `change_type`, `action`, `change_amount`, `left_amount`, `source_sn`, `remark`, `extra`, `create_time`, `update_time`, `delete_time`) VALUES (6, 2117490236, 1, 1, 200, 1, 11.00, 11.00, '', '', '', 0, 0, 0);
|
||
INSERT INTO `la_user_account_log` (`id`, `sn`, `user_id`, `change_object`, `change_type`, `action`, `change_amount`, `left_amount`, `source_sn`, `remark`, `extra`, `create_time`, `update_time`, `delete_time`) VALUES (7, 538904, 1, 1, 200, 1, 11.00, 22.00, '', '', '', 0, 0, 0);
|
||
INSERT INTO `la_user_account_log` (`id`, `sn`, `user_id`, `change_object`, `change_type`, `action`, `change_amount`, `left_amount`, `source_sn`, `remark`, `extra`, `create_time`, `update_time`, `delete_time`) VALUES (8, 9386004, 1, 1, 200, 1, 33.00, 55.00, '', ' 需要考核期械', '', 0, 0, 0);
|
||
INSERT INTO `la_user_account_log` (`id`, `sn`, `user_id`, `change_object`, `change_type`, `action`, `change_amount`, `left_amount`, `source_sn`, `remark`, `extra`, `create_time`, `update_time`, `delete_time`) VALUES (9, 6787629, 1, 1, 100, 2, 55.00, 0.00, '', '时代发生的工枯', '', 0, 0, 0);
|
||
INSERT INTO `la_user_account_log` (`id`, `sn`, `user_id`, `change_object`, `change_type`, `action`, `change_amount`, `left_amount`, `source_sn`, `remark`, `extra`, `create_time`, `update_time`, `delete_time`) VALUES (10, 3128, 1, 1, 200, 1, 232.00, 232.00, '', '', '', 0, 0, 0);
|
||
INSERT INTO `la_user_account_log` (`id`, `sn`, `user_id`, `change_object`, `change_type`, `action`, `change_amount`, `left_amount`, `source_sn`, `remark`, `extra`, `create_time`, `update_time`, `delete_time`) VALUES (11, 8215480, 1, 1, 200, 1, 2342342.00, 2342574.00, '', '', '', 0, 0, 0);
|
||
INSERT INTO `la_user_account_log` (`id`, `sn`, `user_id`, `change_object`, `change_type`, `action`, `change_amount`, `left_amount`, `source_sn`, `remark`, `extra`, `create_time`, `update_time`, `delete_time`) VALUES (12, 4701887, 1, 1, 100, 2, 2323222.00, 19352.00, '', '', '', 0, 0, 0);
|
||
INSERT INTO `la_user_account_log` (`id`, `sn`, `user_id`, `change_object`, `change_type`, `action`, `change_amount`, `left_amount`, `source_sn`, `remark`, `extra`, `create_time`, `update_time`, `delete_time`) VALUES (13, 69550707, 1, 1, 200, 1, 3.00, 19355.00, '', '', '', 1699274136, 0, 0);
|
||
INSERT INTO `la_user_account_log` (`id`, `sn`, `user_id`, `change_object`, `change_type`, `action`, `change_amount`, `left_amount`, `source_sn`, `remark`, `extra`, `create_time`, `update_time`, `delete_time`) VALUES (14, 800, 1, 1, 100, 2, 11111.00, 8244.00, '', '', '', 1699274169, 0, 0);
|
||
INSERT INTO `la_user_account_log` (`id`, `sn`, `user_id`, `change_object`, `change_type`, `action`, `change_amount`, `left_amount`, `source_sn`, `remark`, `extra`, `create_time`, `update_time`, `delete_time`) VALUES (15, 478868, 1, 1, 100, 2, 3333.00, 4911.00, '', '', '', 1699274183, 0, 0);
|
||
INSERT INTO `la_user_account_log` (`id`, `sn`, `user_id`, `change_object`, `change_type`, `action`, `change_amount`, `left_amount`, `source_sn`, `remark`, `extra`, `create_time`, `update_time`, `delete_time`) VALUES (16, 2946432, 1, 1, 100, 2, 4566.00, 345.00, '', '', '', 1699274192, 0, 0);
|
||
INSERT INTO `la_user_account_log` (`id`, `sn`, `user_id`, `change_object`, `change_type`, `action`, `change_amount`, `left_amount`, `source_sn`, `remark`, `extra`, `create_time`, `update_time`, `delete_time`) VALUES (17, 454, 1, 1, 100, 2, 345.00, 0.00, '', '', '', 1699274206, 0, 0);
|
||
INSERT INTO `la_user_account_log` (`id`, `sn`, `user_id`, `change_object`, `change_type`, `action`, `change_amount`, `left_amount`, `source_sn`, `remark`, `extra`, `create_time`, `update_time`, `delete_time`) VALUES (18, 8508, 1, 1, 200, 1, 323.00, 323.00, '', '', '', 1699277952, 0, 0);
|
||
INSERT INTO `la_user_account_log` (`id`, `sn`, `user_id`, `change_object`, `change_type`, `action`, `change_amount`, `left_amount`, `source_sn`, `remark`, `extra`, `create_time`, `update_time`, `delete_time`) VALUES (20, 32236, 1, 1, 101, 2, 20.00, 303.00, '', '', '', 1699981383, 0, 0);
|
||
INSERT INTO `la_user_account_log` (`id`, `sn`, `user_id`, `change_object`, `change_type`, `action`, `change_amount`, `left_amount`, `source_sn`, `remark`, `extra`, `create_time`, `update_time`, `delete_time`) VALUES (21, 591719, 1, 1, 101, 2, 20.00, 283.00, '', '', '', 1699982460, 0, 0);
|
||
INSERT INTO `la_user_account_log` (`id`, `sn`, `user_id`, `change_object`, `change_type`, `action`, `change_amount`, `left_amount`, `source_sn`, `remark`, `extra`, `create_time`, `update_time`, `delete_time`) VALUES (22, 2323, 1, 1, 101, 2, 20.00, 263.00, 'sdfsdfs23423423', '', '', 1700051309, 0, 0);
|
||
INSERT INTO `la_user_account_log` (`id`, `sn`, `user_id`, `change_object`, `change_type`, `action`, `change_amount`, `left_amount`, `source_sn`, `remark`, `extra`, `create_time`, `update_time`, `delete_time`) VALUES (23, 23230, 1, 1, 101, 2, 20.00, 243.00, 'sdfsdfs23423423', '', '', 1700052247, 0, 0);
|
||
INSERT INTO `la_user_account_log` (`id`, `sn`, `user_id`, `change_object`, `change_type`, `action`, `change_amount`, `left_amount`, `source_sn`, `remark`, `extra`, `create_time`, `update_time`, `delete_time`) VALUES (24, 23230, 1, 1, 101, 2, 20.00, 223.00, 'sdfsdfs23423423', '', '', 1700057488, 0, 0);
|
||
INSERT INTO `la_user_account_log` (`id`, `sn`, `user_id`, `change_object`, `change_type`, `action`, `change_amount`, `left_amount`, `source_sn`, `remark`, `extra`, `create_time`, `update_time`, `delete_time`) VALUES (25, 23230, 1, 1, 101, 2, 20.00, 203.00, 'sdfsdfs23423423', '', '', 1700060061, 0, 0);
|
||
INSERT INTO `la_user_account_log` (`id`, `sn`, `user_id`, `change_object`, `change_type`, `action`, `change_amount`, `left_amount`, `source_sn`, `remark`, `extra`, `create_time`, `update_time`, `delete_time`) VALUES (33, 23230, 1, 1, 101, 2, 20.00, 183.00, 'RC987698767', '', '', 1700067525, 0, 0);
|
||
INSERT INTO `la_user_account_log` (`id`, `sn`, `user_id`, `change_object`, `change_type`, `action`, `change_amount`, `left_amount`, `source_sn`, `remark`, `extra`, `create_time`, `update_time`, `delete_time`) VALUES (35, 23230, 1, 1, 101, 2, 20.00, 163.00, 'RC987698767', '', '', 1700067885, 0, 0);
|
||
INSERT INTO `la_user_account_log` (`id`, `sn`, `user_id`, `change_object`, `change_type`, `action`, `change_amount`, `left_amount`, `source_sn`, `remark`, `extra`, `create_time`, `update_time`, `delete_time`) VALUES (36, 23230, 1, 1, 101, 2, 20.00, 143.00, 'RC987698767', '', '', 1700067991, 0, 0);
|
||
INSERT INTO `la_user_account_log` (`id`, `sn`, `user_id`, `change_object`, `change_type`, `action`, `change_amount`, `left_amount`, `source_sn`, `remark`, `extra`, `create_time`, `update_time`, `delete_time`) VALUES (37, 23230, 1, 1, 101, 2, 20.00, 123.00, 'RC987698767', '', '', 1700070427, 0, 0);
|
||
INSERT INTO `la_user_account_log` (`id`, `sn`, `user_id`, `change_object`, `change_type`, `action`, `change_amount`, `left_amount`, `source_sn`, `remark`, `extra`, `create_time`, `update_time`, `delete_time`) VALUES (38, 23230, 1, 1, 200, 1, 2000.00, 2123.00, '', '抵用', '', 1700106331, 0, 0);
|
||
INSERT INTO `la_user_account_log` (`id`, `sn`, `user_id`, `change_object`, `change_type`, `action`, `change_amount`, `left_amount`, `source_sn`, `remark`, `extra`, `create_time`, `update_time`, `delete_time`) VALUES (39, 5454, 2, 1, 100, 2, 50.00, 5405.00, '', '', '', 1700106633, 0, 0);
|
||
INSERT INTO `la_user_account_log` (`id`, `sn`, `user_id`, `change_object`, `change_type`, `action`, `change_amount`, `left_amount`, `source_sn`, `remark`, `extra`, `create_time`, `update_time`, `delete_time`) VALUES (40, 23230, 1, 1, 200, 1, 3.00, 2126.00, '', '', '', 1700108492, 0, 0);
|
||
INSERT INTO `la_user_account_log` (`id`, `sn`, `user_id`, `change_object`, `change_type`, `action`, `change_amount`, `left_amount`, `source_sn`, `remark`, `extra`, `create_time`, `update_time`, `delete_time`) VALUES (41, 23230, 1, 1, 200, 1, 3.00, 2129.00, '', '', '', 1700116190, 0, 0);
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for la_user_auth
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `la_user_auth`;
|
||
CREATE TABLE `la_user_auth` (
|
||
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`user_id` int unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
|
||
`openid` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'Openid',
|
||
`unionid` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'Unionid',
|
||
`client` tinyint unsigned NOT NULL DEFAULT '1' COMMENT '客户端类型: [1=微信小程序, 2=微信公众号, 3=手机H5, 4=电脑PC, 5=苹果APP, 6=安卓APP]',
|
||
`create_time` int unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
|
||
`update_time` int unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `openid` (`openid`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='用户授权表';
|
||
|
||
-- ----------------------------
|
||
-- Records of la_user_auth
|
||
-- ----------------------------
|
||
BEGIN;
|
||
COMMIT;
|
||
|
||
SET FOREIGN_KEY_CHECKS = 1;
|