【研究中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作为锁对象)，会遇到的问题 问题一：若直接使用：将获取锁的对象和设置的超时的时间分开，则不能控…...
大数据学习栈记——Neo4j的安装与使用
本文介绍图数据库Neofj的安装与使用，操作系统：Ubuntu24.04，Neofj版本：2025.04.0。 Apt安装 Neofj可以进行官网安装：Neo4j Deployment Center - Graph Database & Analytics 我这里安装是添加软件源的方法 最新版…...
盘古信息PCB行业解决方案：以全域场景重构，激活智造新未来
一、破局：PCB行业的时代之问 在数字经济蓬勃发展的浪潮中，PCB（印制电路板）作为 “电子产品之母”，其重要性愈发凸显。随着 5G、人工智能等新兴技术的加速渗透，PCB行业面临着前所未有的挑战与机遇。产品迭代…...
基于Uniapp开发HarmonyOS 5.0旅游应用技术实践
一、技术选型背景 1.跨平台优势 Uniapp采用Vue.js框架，支持"一次开发，多端部署"，可同步生成HarmonyOS、iOS、Android等多平台应用。 2.鸿蒙特性融合 HarmonyOS 5.0的分布式能力与原子化服务，为旅游应用带来…...
-----深度优先搜索（DFS）实现)
c++ 面试题(1)-----深度优先搜索（DFS）实现
操作系统：ubuntu22.04 IDE:Visual Studio Code 编程语言：C11 题目描述 地上有一个 m 行 n 列的方格，从坐标 [0,0] 起始。一个机器人可以从某一格移动到上下左右四个格子，但不能进入行坐标和列坐标的数位之和大于 k 的格子。 例…...
Mac软件卸载指南，简单易懂！
刚和Adobe分手，它却总在Library里给你写"回忆录"？卸载的Final Cut Pro像电子幽灵般阴魂不散？总是会有残留文件，别慌！这份Mac软件卸载指南，将用最硬核的方式教你"数字分手术"࿰…...
蓝桥杯 冶炼金属
原题目链接 🔧 冶炼金属转换率推测题解 📜 原题描述 小蓝有一个神奇的炉子用于将普通金属 O O O 冶炼成为一种特殊金属 X X X。这个炉子有一个属性叫转换率 V V V，是一个正整数，表示每 V V V 个普通金属 O O O 可以冶炼出 …...
AGain DB和倍数增益的关系
我在设置一款索尼CMOS芯片时，Again增益0db变化为6DB，画面的变化只有2倍DN的增益，比如10变为20。 这与dB和线性增益的关系以及传感器处理流程有关。以下是具体原因分析： 1. dB与线性增益的换算关系 6dB对应的理论线性增益应为&…...
力扣热题100 k个一组反转链表题解
题目: 代码: func reverseKGroup(head *ListNode, k int) *ListNode {cur : headfor i : 0; i < k; i {if cur nil {return head}cur cur.Next}newHead : reverse(head, cur)head.Next reverseKGroup(cur, k)return newHead }func reverse(start, end *ListNode) *ListN…...
搭建DNS域名解析服务器(正向解析资源文件)
正向解析资源文件 1）准备工作 服务端及客户端都关闭安全软件 [rootlocalhost ~]# systemctl stop firewalld [rootlocalhost ~]# setenforce 0 2）服务端安装软件：bind 1.配置yum源 [rootlocalhost ~]# cat /etc/yum.repos.d/base.repo [Base…...
掌握 HTTP 请求：理解 cURL GET 语法
cURL 是一个强大的命令行工具，用于发送 HTTP 请求和与 Web 服务器交互。在 Web 开发和测试中，cURL 经常用于发送 GET 请求来获取服务器资源。本文将详细介绍 cURL GET 请求的语法和使用方法。 一、cURL 基本概念 cURL 是 "Client URL" 的缩写…...