【研究中2】sql server权限用户设置
--更新时间2023.11.26 21：30 负责人：jerrysuse DBAliCMSIF EXISTS (select * from sysobjects where name='hkcms_admin')--判断是否存在此表DROP TABLE hkcms_adminCREATE TABLE hkcms_admin (id int identity(1, 1),--id int primary key identity(1, 1)username varchar(20) NOT NULL ,-- '登录名称',nickname varchar(50) NOT NULL DEFAULT '' ,-- '昵称',email varchar(50) NOT NULL DEFAULT '' ,-- '邮箱',password varchar(32) NOT NULL ,-- '密码',salt varchar(10) NOT NULL ,-- '密码盐',avatar varchar(255) NOT NULL DEFAULT '' ,-- '头像',remark varchar(255) NOT NULL DEFAULT '' ,-- '备注',logintime datetime DEFAULT NULL ,-- '登录时间',loginip varchar(40) NOT NULL DEFAULT '' ,-- '登录IP',status varchar(20) NOT NULL DEFAULT 'normal' ,-- '状态:normal-正常,hidden-禁用',create_time datetime DEFAULT NULL ,-- '创建时间',update_time datetime DEFAULT NULL , -- '更新时间',PRIMARY KEY(id)) --='后台管理员';IF EXISTS (select * from sysobjects where name='hkcms_admin_log')--判断是否存在此表DROP TABLE hkcms_admin_log
CREATE TABLE hkcms_admin_log (id int identity(1, 1),admin_id int NOT NULL ,-- '用户id',username varchar(30) NOT NULL DEFAULT '' ,-- '用户名',useragent varchar(255) NOT NULL DEFAULT '' ,-- 'useragent',title varchar(100) NOT NULL ,-- '标题',url varchar(1500) NOT NULL ,-- 'URL',ip varchar(20) NOT NULL ,-- 'IP地址',content text NOT NULL ,-- '内容',create_time datetime NOT NULL, -- '操作时间',PRIMARY KEY(id)
) --='后台操作日志';IF EXISTS (select * from sysobjects where name='hkcms_auth_group')--判断是否存在此表DROP TABLE hkcms_auth_group
CREATE TABLE hkcms_auth_group (id int primary key identity(1, 1) ,-- 'ID',name varchar(20) NOT NULL DEFAULT '' ,-- '名称',parent_id int NOT NULL DEFAULT '0' ,-- '父级',rules text NOT NULL ,-- '规则',remark varchar(255) NOT NULL DEFAULT '' ,-- '备注',status varchar(20) NOT NULL DEFAULT 'normal' ,-- '状态:normal-正常,hidden-禁用',create_time datetime DEFAULT NULL ,-- '创建时间',update_time datetime DEFAULT NULL ,-- '更新时间',) --='角色管理';insert into hkcms_auth_group values ('超级管理员',0,'*','','normal',GETDATE(),GETDATE());IF EXISTS (select * from sysobjects where name='hkcms_auth_group_access')--判断是否存在此表DROP TABLE hkcms_auth_group_access
CREATE TABLE hkcms_auth_group_access (admin_id int primary key identity(1, 1) ,-- '管理员ID',group_id int NOT NULL ,-- '角色组ID',create_time datetime DEFAULT NULL ,-- '创建时间',update_time datetime DEFAULT NULL ,-- '更新时间',) --='权限分组表';insert into hkcms_auth_group_access values (1,GETDATE(),GETDATE());IF EXISTS (select * from sysobjects where name='hkcms_auth_rule')--判断是否存在此表DROP TABLE hkcms_auth_rule
CREATE TABLE hkcms_auth_rule (id int primary key identity(1, 1) ,-- 'ID',parent_id int NOT NULL DEFAULT '0' ,-- '父级',name char(80) NOT NULL unique DEFAULT '' ,-- '规则',title char(50) NOT NULL DEFAULT '' ,-- '标题',route char(80) NOT NULL ,-- '路由',app char(20) NOT NULL DEFAULT '' ,-- '所属应用',icon char(50) NOT NULL DEFAULT '' ,-- '图标',remark char(250) NOT NULL DEFAULT '' ,-- '备注',weigh int NOT NULL DEFAULT '0' ,-- '排序',type int NOT NULL DEFAULT '1' ,-- '类型:0-权限规则,1-菜单,2-菜单头',status varchar(20) NOT NULL DEFAULT 'normal' ,-- '状态:normal-正常,hidden-禁用',is_nav int NOT NULL DEFAULT '0' ,-- '快速导航:1-是,0-否',condition char(100) NOT NULL DEFAULT '' ,-- '附加条件',create_time datetime DEFAULT NULL ,-- '创建时间',update_time datetime DEFAULT NULL ,-- '更新时间',)--='菜单规则';--set IDENTITY_INSERT hkcms_auth_rule ON ----设置标识列可以显示添加数据
--SET IDENTITY_INSERT hkcms_auth_rule OFF ----设置标识列不可以显示添加数据 insert into hkcms_auth_rule values (0,'index/dashboard','Dashboard','','','fas fa-tachometer-alt','',5,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (58,'auth','Auth','','','fas fa-user-alt','',17,1,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (34,'auth/rule','Menu','auth.rule/index','','far fa-circle','',20,1,'normal',1,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (35,'auth/rule/index','View','auth.rule/index','','far fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (35,'auth/rule/add','Add','auth.rule/add','','far fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (35,'auth/rule/edit','Edit','auth.rule/edit','','far fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (35,'auth/rule/del','Delete','auth.rule/del','','far fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());insert into hkcms_auth_rule values (34,'auth/admin','Admin','auth.admin/index','','far fa-circle','',18,1,'normal',1,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (34,'auth/group','Group','auth.group/index','','far fa-circle','',19,1,'normal',1,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (34,'auth/adminlog','Admin log','auth.adminlog/index','','far fa-circle','',21,1,'normal',1,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (57,'appcenter','Application','','','fas fa-th','',31,1,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (58,'cms/model','Model','cms.model/index','','fas fa-database','',16,1,'normal',1,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (0,'cms/category','Category','cms.category/index','','fas fa-list','',7,1,'normal',1,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (0,'cms/content/index','Content','cms.content/index','','fas fa-file','',6,1,'normal',1,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (35,'auth/rule/batches','Batch edit','auth.rule/batches','','far fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (108,'routine/config','Site config','routine.config/index','','fas fa-globe','',11,1,'normal',1,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (42,'auth/adminlog/index','View','auth.adminlog/index','','far fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (58,'routine/attachment','Attachment','routine.Attachment/index','','fas fa-folder','',15,1,'normal',1,'',GETDATE(),GETDATE());insert into hkcms_auth_rule values (50,'routine/config/edit','Edit','routine.config/edit','','far fa-circle','',20,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (0,'cms/recommend','Site module','cms.recommend/index','','fas fa-cubes','',8,1,'normal',1,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (0,'more','More','','','far fa-circle','',30,2,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (0,'setting','Setting','','','far fa-circle','',9,2,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (40,'auth/admin/edit','Edit','auth.admin/edit','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (40,'auth/admin/index','View','auth.admin/index','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (40,'auth/admin/add','Add','auth.admin/admin','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (40,'auth/admin/del','Delete','auth.admin/del','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (40,'auth/admin/batches','Batch edit','auth.admin/batches','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (41,'auth/group/index','View','auth.group/index','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (41,'auth/group/add','Add','auth.group/add','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (41,'auth/group/edit','Edit','auth.group/edit','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (41,'auth/group/del','Delete','auth.group/del','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (41,'auth/group/batches','Batch edit','auth.group/batches','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (42,'auth/adminlog/del','Delete','auth.adminlog/del','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (52,'common/upload','Upload','','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (52,'routine/attachment/del','Delete','routine.attachment/del','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (52,'routine/attachment/index','View','routine.attachment/index','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (45,'cms/model/index','View','cms.model/index','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (45,'cms/model/add','Add','cms.model/add','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (45,'cms/model/edit','Edit','cms.model/edit','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (45,'cms/model/del','Delete','cms.model/del','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (745,'cms/modelfield/index','Model field view','cms.model_field/index','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (45,'cms/modelfield/add','Model field add','cms.model_field/add','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (45,'cms/modelfield/edit','Model field edit','cms.model_field/edit','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (45,'cms/modelfield/del','Model field delete','cms.model_field/del','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (45,'cms/model/batches','Batch edit','cms.model/batches','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (45,'cms/modelfield/batches','Model field batch edit','cms.model_field/batches','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (55,'cms/recommend/index','View','cms.recommend/index','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (55,'cms/recommend/add','Add','cms.recommend/add','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (55,'cms/recommend/edit','Edit','cms.recommend/edit','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (55,'cms/recommend/del','Delete','cms.recommend/del','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (55,'cms/recommend/batches','Batch edit','cms.recommend/batches','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (46,'cms/category/index','View','cms.category/index','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (46,'cms/category/add','Add','cms.category/add','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (46,'cms/category/del','Delete','cms.category/del','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (46,'cms/category/edit','Edit','cms.category/edit','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (46,'cms/category/batches','Batch edit','cms.category/batches','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (46,'cms/category/recycle','Recycle','cms.category/recycle','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (46,'cms/category/destroy','Destroy','cms.category/destroy','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (46,'cms/category/restore','Restore','cms.category/restore','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (43,'appcenter/index','Local','','','fa fa-cloud-download-alt','',32,1,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (43,'appcenter/online','Online','','','fas fa-cloud','',33,1,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (46,'cms/category/auth','Column auth','cms.ategory/auth','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (45,'cms/modelfield/fieldcategory', 'Designated column', 'cms.model_field/fieldcategory', '','fas fa-circle', '', 0, 0, 'normal', 0, '', GETDATE(),GETDATE());
insert into hkcms_auth_rule values (46,'cms/category/fields','Extended field','cms/category/fields','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (45,'cms/model/export','Model export','cms.model/export','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (45,'cms/model/import','Model import','cms.model/import','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (45,'cms/model/copy','Model copy','cms.model/copy','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (52,'routine/attachment/edit','Edit','routine.attachment/edit','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (108,'routine/seo/index','SEO Setting','routine.Seo/index','','fas fa-link','',12,1,'normal',1,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (108,'cms/flags','Flag','cms.flags/index','','fas fa-file-alt','',13,1,'normal',1,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (58,'config','Configure','','','fas fa-cog','',10,1,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (107,'cms/flags/index','View','cms.flag/index','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (107,'cms/flags/add','Add','cms.flags/add','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (107,'cms/flags/edit','Edit','cms.flags/edit','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (107,'cms/flags/del','Delete','cms.flags/del','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());
insert into hkcms_auth_rule values (107,'cms/flags/batches','Batch edit','cms.flags/batches','','fas fa-circle','',0,0,'normal',0,'',GETDATE(),GETDATE());/*
insert into hkcms_auth_rule values (114,52,'routine/attachment/water','Watermark','routine.attachment/water','','fas fa-tint','',0,0,'normal',1,'',1658593132,1658593132);
insert into hkcms_auth_rule values (115,52,'routine/attachment/thumb','Thumbnail','routine.attachment/thumb','','far fa-image','',0,0,'normal',1,'',1658593175,1658593175);
insert into hkcms_auth_rule values (116,0,'index/clearcache','Clean cache','','','fas fa-circle','',5,0,'normal',0,'',1594779897,1617268812);
insert into hkcms_auth_rule values (117,108,'tags/index','Tags manage','','','fas fa-tags','',15,1,'normal',1,'',1666665197,1666665361);
insert into hkcms_auth_rule values (118,117,'tags/add','Add','','','far fa-circle','',100,0,'normal',0,'',1666665197,1666665197);
insert into hkcms_auth_rule values (119,117,'tags/edit','Edit','','','far fa-circle','',100,0,'normal',0,'',1666665197,1666665197);
insert into hkcms_auth_rule values (120,117,'tags/delete','Delete','','','far fa-circle','',100,0,'normal',0,'',1666665197,1666665197);
insert into hkcms_auth_rule values (123,58,'user','Member','','','fas fa-user-tie','',100,1,'normal',0,'',1669370924,1669371783);
insert into hkcms_auth_rule values (124,123,'user/user','Member','user.user/index','','far fa-user-circle','',0,1,'normal',1,'',1669370924,1669371278);
insert into hkcms_auth_rule values (125,124,'user/user/index','View','user.user/index','','fas fa-circle','',0,0,'normal',0,'',1669370924,1669370924);
insert into hkcms_auth_rule values (126,124,'user/user/edit','Edit','user.user/edit','','fas fa-circle','',0,0,'normal',0,'',1669370924,1669370924);
insert into hkcms_auth_rule values (127,124,'user/user/del','Delete','user.user/del','','fas fa-circle','',0,0,'normal',0,'',1669370924,1669370924);
insert into hkcms_auth_rule values (128,124,'user/user/batches','Batch edit','user.user/batches','','fas fa-circle','',0,0,'normal',0,'',1669370924,1669370924);
insert into hkcms_auth_rule values (129,123,'user/group','Member group','user.group/index','','fas fa-users','',0,1,'normal',1,'',1669370924,1669371795);
insert into hkcms_auth_rule values (130,129,'user/group/index','View','user.group/index','','fas fa-circle','',0,0,'normal',0,'',1669370924,1669370924);
insert into hkcms_auth_rule values (131,129,'user/group/edit','Edit','user.group/edit','','fas fa-circle','',0,0,'normal',0,'',1669370924,1669370924);
insert into hkcms_auth_rule values (132,129,'user/group/add','Add','user.group/add','','fas fa-circle','',0,0,'normal',0,'',1669370924,1669370924);
insert into hkcms_auth_rule values (133,129,'user/group/del','Delete','user.group/del','','fas fa-circle','',0,0,'normal',0,'',1669370924,1669370924);
insert into hkcms_auth_rule values (134,129,'user/group/batches','Batch edit','user.group/batches','','fas fa-circle','',0,0,'normal',0,'',1669370924,1669370924);
insert into hkcms_auth_rule values (135,123,'user/rule','Member rule','user.rule/index','','fas fa-user-lock','',0,1,'normal',1,'',1669370924,1669371418);
insert into hkcms_auth_rule values (136,135,'user/rule/index','View','user.rule/index','','fas fa-circle','',0,0,'normal',0,'',1669370924,1669370924);
insert into hkcms_auth_rule values (137,135,'user/rule/edit','Edit','user.rule/edit','','fas fa-circle','',0,0,'normal',0,'',1669370924,1669370924);
insert into hkcms_auth_rule values (138,135,'user/rule/add','Add','user.rule/add','','fas fa-circle','',0,0,'normal',0,'',1669370924,1669370924);
insert into hkcms_auth_rule values (139,135,'user/rule/del','Delete','user.rule/del','','fas fa-circle','',0,0,'normal',0,'',1669370924,1669370924);
insert into hkcms_auth_rule values (140,135,'user/rule/batches','Batch edit','user.rule/batches','','fas fa-circle','',0,0,'normal',0,'',1669370924,1669371448);
insert into hkcms_auth_rule values (141,50,'routine/lang','Lang management','routine.Lang','','fas fa-language','',100,0,'normal',1,'',1682150648,1682151957);
insert into hkcms_auth_rule values (142,141,'routine/lang/index','View','routine.Lang/index','','fas fa-circle','',100,0,'normal',0,'',1682150953,1682150953);
insert into hkcms_auth_rule values (143,141,'routine/lang/add','Add','routine.Lang/add','','fas fa-circle','',100,0,'normal',0,'',1682151046,1682151046);
insert into hkcms_auth_rule values (144,141,'routine/lang/edit','Edit','routine.Lang/edit','','fas fa-circle','',100,0,'normal',0,'',1682151102,1682151102);
insert into hkcms_auth_rule values (145,141,'routine/lang/del','Delete','routine.Lang/del','','fas fa-circle','',100,0,'normal',0,'',1682151166,1682152133);
insert into hkcms_auth_rule values (146,141,'routine/lang/batches','Batch edit','routine.Lang/batches','','fas fa-circle','',100,0,'normal',0,'',1682151621,1682151621);
insert into hkcms_auth_rule values (147,141,'routine/lang/setdefault','Set default','routine.Lang/setDefault','','fas fa-circle','',100,0,'normal',0,'',1682151785,1682152199);
insert into hkcms_auth_rule values (148,50,'routine/config/index','View','routine.config/index','','fas fa-circle','',10,0,'normal',0,'',1682152458,1682152494);
insert into hkcms_auth_rule values (149,50,'routine/config/add','Add','routine.config/edit','','fas fa-circle','',30,0,'normal',0,'',1682152809,1682152816);*/
IF EXISTS (select * from sysobjects where name='hkcms_auth_rule')--判断是否存在此表DROP TABLE hkcms_auth_rule
CREATE TABLE hkcms_auth_rule (id int primary key identity(1, 1) ,-- 'ID',parent_id int NOT NULL DEFAULT '0' ,-- '父级',name char(80) NOT NULL unique DEFAULT '' ,-- '规则',title char(50) NOT NULL DEFAULT '' ,-- '标题',route char(80) NOT NULL ,-- '路由',app char(20) NOT NULL DEFAULT '' ,-- '所属应用',icon char(50) NOT NULL DEFAULT '' ,-- '图标',remark char(250) NOT NULL DEFAULT '' ,-- '备注',weigh int NOT NULL DEFAULT '0' ,-- '排序',type int NOT NULL DEFAULT '1' ,-- '类型:0-权限规则,1-菜单,2-菜单头',status varchar(20) NOT NULL DEFAULT 'normal' ,-- '状态:normal-正常,hidden-禁用',is_nav int NOT NULL DEFAULT '0' ,-- '快速导航:1-是,0-否',condition char(100) NOT NULL DEFAULT '' ,-- '附加条件',create_time datetime DEFAULT NULL ,-- '创建时间',update_time datetime DEFAULT NULL ,-- '更新时间',)--='菜单规则';相关文章：
【研究中2】sql server权限用户设置
--更新时间2023.11.26 21：30 负责人：jerrysuse DBAliCMSIF EXISTS (select * from sysobjects where namehkcms_admin)--判断是否存在此表DROP TABLE hkcms_adminCREATE TABLE hkcms_admin (id int identity(1, 1),--id int primary key identity…...
从零开始学习管道：管道程序的优化和文件描述符继承问题
📟作者主页：慢热的陕西人 🌴专栏链接：Linux 📣欢迎各位大佬👍点赞🔥关注🚓收藏，🍉留言 本博客主要内容管道后续的完善，以及解决管道继承多个文件描…...
【JavaWeb】HTMLCSSJavaScript
HTML&CSS&JavaScript 文章目录 HTML&CSS&JavaScript一、开发工具及在线帮助文档二、 HTML2.1 HTML&CSS&JavaScript的作用2.2 HTML基础结构2.3 HTML概念词汇解释2.4 HTML的语法规则2.5 常用标签 三、CSS3.1 引入方式3.2 CSS选择器3.3 CSS浮动3.4 CSS定位…...
如何在没有备份的情况下恢复 iPhone 上已删除的短信
要在没有备份的情况下恢复 iPhone 上已删除的消息，您可以从“消息”应用程序恢复它们或使用第三方数据恢复工具。 虽然我们的 iPhone 可以做很多事情，但我在设备上最常做的事情之一就是文本。无论我是与朋友或家人联系，还是分享重要信息&…...
tomcat-pass-getshell 弱口令 漏洞复现
tomcat-pass-getshell 弱口令 漏洞复现 名称: tomcat-pass-getshell 弱口令 描述: Tomcat是Apache 软件基金会（Apache Software Foundation）的Jakarta 项目中的一个核心项目，由Apache、Sun 和其他一些公司及个人共同开发而成。 通过弱口令登…...
利用 LD_PRELOAD 环境变量
文章目录 原理LD_PRELOAD介绍如何上传.so文件 例题 [虎符CTF 2022]ezphp 原理 LD_PRELOAD介绍 LD_PRELOAD是Linux系统的一个环境变量，它可以影响程序的运行时的链接（Runtime linker），它允许你定义在程序运行前优先加载的动态链接…...
黑马点评-Feed流的实现方案,基于推拉结合模式实现笔记推送
Feed流实现方案 我们关注了博主之后,当用户发布了动态后我们应该把这些数据推送给粉丝,关注推送也叫作Feed(投喂)流,通过无限下拉刷新获取新的信息 传统的模式内容检索: 粉丝需要主动通过搜索引擎或者是其他方式去查找想看的内容新型Feed流的效果: 系统分析用户到底想看什么,…...
Re53：读论文 How Can We Know What Language Models Know?
诸神缄默不语-个人CSDN博文目录 诸神缄默不语的论文阅读笔记和分类 论文名称：How Can We Know What Language Models Know? ArXiv网址：https://arxiv.org/abs/1911.12543 官方GitHub项目（prompt之类的都有）：https:…...
YARN工作流程详解
图1 图2 图1 -作业提交阶段： 1、client 提交job,向 ResourceManager【RM】 申请job_id; 2、RM 返回 job_id 及资源提交路径 给 client 3、client 把job所需的资源提交 到 3中指定的路径中 4、client 上传完成资源后，向RM 发送执行作业请求，RM…...
力扣373场周赛题解
第一题： 这个题是一个简单题，数据范围也特别小，所以直接使用模拟方式暴力解答。 直接进行行移动的过程，然后检查移动后的结果是否与移动前相同。 代码： public class Solution {// 将指定行循环右移k次pri…...
编程语言发展史：Rust语言的出现和特点
一、Rust语言的出现 Rust语言是一种由Mozilla开发的系统级编程语言，该语言于2010年首次公布，由Graydon Hoare在Mozilla的工作期间开发，最初是为了替代C而设计的。Rust语言的目标是提供一种安全、高效、并发性强的编程语言，同时保…...
Centos Bind安装与排错
1.配置Centos系统静态IP vi/etc/sysconfig/network-scripts/ifcfg-ens33BOOTPROTOstaticIPADDR192.168.1.100NETMASK255.255.255.0GATEWAY192.168.1.1DNS18.8.8.8:wqsudo systemctl restart network.service 2.安装BIND（需要服务器连接互联网，如果服务…...
spark中write算子和format算子详解
在spark中，想要往数据库或者某sink路径里面写数据，存到外部存储系统，如文件系统、数据库或数据仓库，经常会用到write算子。 具体来说，write算子通常与DataFrame或Dataset API一起使用，用于将数据写入持久化…...
设计模式—接口隔离原则（ISP）
1.背景 2002 年罗伯特C.马丁给“接口隔离原则”的定义是：客户端不应该被迫依赖于它不使用的方法（Clients should not be forced to depend on methods they do not use）。该原则还有另外一个定义：一个类对另一个类的依赖应该建立…...
Jenkins用126邮箱发邮件为什么发不出去
1、检查 Jenkins Location中的邮件地址配置与发邮件的地址配置是否一致 Manage Jenkins -》 system 2、检查地址和端口号 3、检查邮箱的登录配置是否正确（这个地方的配置方式网上一抓一大把，自己搜一下就好） 4、126邮箱发邮件不需要勾选ssl协…...
怎么给数据库某个字段建立一个前缀索引
说明：SQL调优中重要的一个环节是建立索引，其中有一条是字段值过长字段应该建立前缀索引，即根据字段值的前几位建立索引，像数据库中的密码字段、UUID字段。 因为其随机性，其实根据前几位就可以锁定某一条记录了。前缀索…...
C# 图片下载工具类
写在前面 从浏览器的Html文本中获取图片链接并保存到本地，同时对图片的分辨率和品质进行处理，以满足某些平台的规格需求；可以放到多线程中调用以提高下载效率。 代码实现 public class ImageDownloader{private int minImageSize 1024 * 1…...
嵌入式硬件电路·电平
目录 1. 电平的概念 1.1 高电平 1.2 低电平 2. 电平的使用场景 2.1 高电平使能 2.2 低电平使能 2.3 失能 1. 电平的概念 电平是指电信号电压的大小或高低状态。在数字电子学中，电平有两种状态，高电平和低电平，用来表示二进制中…...
Python文件路径常用操作
1 文件路径 在进行数据处理时，经常要用代码去读文件里的数据，那么首先就得知道这个文件的文件路径。文件路径简单地说就是文件的存放位置。文件路径分为两块：文件夹路径和文件名，文件名又分为文件基本名和扩展名。 举例说明&…...
Redis-Redis 高并发分布式锁
集群分布式场景高并发 1.negix配置代理和路由 高并发场景超卖问题 1.使用原生redis控制超卖时(若是商品，则可以将商品id作为锁对象)，会遇到的问题 问题一：若直接使用：将获取锁的对象和设置的超时的时间分开，则不能控…...
AI-调查研究-01-正念冥想有用吗？对健康的影响及科学指南
点一下关注吧！！！非常感谢！！持续更新！！！ 🚀 AI篇持续更新中！（长期更新） 目前2025年06月05日更新到： AI炼丹日志-28 - Aud…...
黑马Mybatis
Mybatis 表现层：页面展示 业务层：逻辑处理 持久层：持久数据化保存 在这里插入图片描述 Mybatis快速入门 
MMaDA: Multimodal Large Diffusion Language Models
CODE ： https://github.com/Gen-Verse/MMaDA Abstract 我们介绍了一种新型的多模态扩散基础模型MMaDA，它被设计用于在文本推理、多模态理解和文本到图像生成等不同领域实现卓越的性能。该方法的特点是三个关键创新:(i) MMaDA采用统一的扩散架构…...
linux arm系统烧录
1、打开瑞芯微程序 2、按住linux arm 的 recover按键 插入电源 3、当瑞芯微检测到有设备 4、松开recover按键 5、选择升级固件 6、点击固件选择本地刷机的linux arm 镜像 7、点击升级 （忘了有没有这步了 估计有） 刷机程序 和 镜像 就不提供了。要刷的时…...
12.找到字符串中所有字母异位词
🧠 题目解析 题目描述： 给定两个字符串 s 和 p，找出 s 中所有 p 的字母异位词的起始索引。 返回的答案以数组形式表示。 字母异位词定义： 若两个字符串包含的字符种类和出现次数完全相同，顺序无所谓，则互为…...
Spring AI与Spring Modulith核心技术解析
Spring AI核心架构解析 Spring AI（https://spring.io/projects/spring-ai）作为Spring生态中的AI集成框架，其核心设计理念是通过模块化架构降低AI应用的开发复杂度。与Python生态中的LangChain/LlamaIndex等工具类似，但特别为多语…...
企业如何增强终端安全？
在数字化转型加速的今天，企业的业务运行越来越依赖于终端设备。从员工的笔记本电脑、智能手机，到工厂里的物联网设备、智能传感器，这些终端构成了企业与外部世界连接的 “神经末梢”。然而，随着远程办公的常态化和设备接入的爆炸式…...
有限自动机到正规文法转换器v1.0
1 项目简介 这是一个功能强大的有限自动机（Finite Automaton, FA）到正规文法（Regular Grammar）转换器，它配备了一个直观且完整的图形用户界面，使用户能够轻松地进行操作和观察。该程序基于编译原理中的经典…...
HarmonyOS运动开发：如何用mpchart绘制运动配速图表
##鸿蒙核心技术##运动开发##Sensor Service Kit（传感器服务）# 前言 在运动类应用中，运动数据的可视化是提升用户体验的重要环节。通过直观的图表展示运动过程中的关键数据，如配速、距离、卡路里消耗等，用户可以更清晰…...
LabVIEW双光子成像系统技术
双光子成像技术的核心特性 双光子成像通过双低能量光子协同激发机制，展现出显著的技术优势： 深层组织穿透能力：适用于活体组织深度成像 高分辨率观测性能：满足微观结构的精细研究需求 低光毒性特点：减少对样本的损伤…...