【研究中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作为锁对象)，会遇到的问题 问题一：若直接使用：将获取锁的对象和设置的超时的时间分开，则不能控…...
智慧医疗能源事业线深度画像分析（上）
引言 医疗行业作为现代社会的关键基础设施，其能源消耗与环境影响正日益受到关注。随着全球"双碳"目标的推进和可持续发展理念的深入，智慧医疗能源事业线应运而生，致力于通过创新技术与管理方案，重构医疗领域的能源使用模式。这一事业线融合了能源管理、可持续发…...
【力扣数据库知识手册笔记】索引
索引 索引的优缺点 优点1. 通过创建唯一性索引，可以保证数据库表中每一行数据的唯一性。2. 可以加快数据的检索速度（创建索引的主要原因）。3. 可以加速表和表之间的连接，实现数据的参考完整性。4. 可以在查询过程中，…...
1.3 VSCode安装与环境配置
进入网址Visual Studio Code - Code Editing. Redefined下载.deb文件，然后打开终端，进入下载文件夹，键入命令 sudo dpkg -i code_1.100.3-1748872405_amd64.deb 在终端键入命令code即启动vscode 需要安装插件列表 1.Chinese简化 2.ros …...
PAN/FPN
import torch import torch.nn as nn import torch.nn.functional as F import mathclass LowResQueryHighResKVAttention(nn.Module):"""方案 1: 低分辨率特征 (Query) 查询高分辨率特征 (Key, Value).输出分辨率与低分辨率输入相同。"""def __…...
AirSim/Cosys-AirSim 游戏开发（四）外部固定位置监控相机
这个博客介绍了如何通过 settings.json 文件添加一个无人机外的 固定位置监控相机，因为在使用过程中发现 Airsim 对外部监控相机的描述模糊，而 Cosys-Airsim 在官方文档中没有提供外部监控相机设置，最后在源码示例中找到了，所以感…...
PHP 8.5 即将发布：管道操作符、强力调试
前不久，PHP宣布了即将在 2025 年 11 月 20 日 正式发布的 PHP 8.5！作为 PHP 语言的又一次重要迭代，PHP 8.5 承诺带来一系列旨在提升代码可读性、健壮性以及开发者效率的改进。而更令人兴奋的是，借助强大的本地开发环境 ServBay&am…...
通过 Ansible 在 Windows 2022 上安装 IIS Web 服务器
拓扑结构 这是一个用于通过 Ansible 部署 IIS Web 服务器的实验室拓扑。 前提条件： 在被管理的节点上安装WinRm 准备一张自签名的证书 开放防火墙入站tcp 5985 5986端口 准备自签名证书 PS C:\Users\azureuser> $cert New-SelfSignedCertificate -DnsName &…...
自然语言处理——文本分类
文本分类 传统机器学习方法文本表示向量空间模型 特征选择文档频率互信息信息增益（IG） 分类器设计贝叶斯理论：线性判别函数 文本分类性能评估P-R曲线ROC曲线 将文本文档或句子分类为预定义的类或类别， 有单标签多类别文本分类和多…...
【深度学习新浪潮】什么是credit assignment problem？
Credit Assignment Problem（信用分配问题） 是机器学习，尤其是强化学习（RL）中的核心挑战之一，指的是如何将最终的奖励或惩罚准确地分配给导致该结果的各个中间动作或决策。在序列决策任务中，智能体执行一系列动作后获得一个最终奖励，但每个动作对最终结果的贡献程度往往…...
深入理解 React 样式方案
React 的样式方案较多，在应用开发初期，开发者需要根据项目业务具体情况选择对应样式方案。React 样式方案主要有： 1. 内联样式 2. module css 3. css in js 4. tailwind css 这些方案中，均有各自的优势和缺点。 1. 方案优劣势 1. 内联样式: 简单直观，适合动态样式和…...