【研究中2】sql server权限用户设置




--更新时间2023.11.26 21：30   负责人：jerrys


use DBAliCMS






IF EXISTS (select * from sysobjects where name='hkcms_admin')--判断是否存在此表
    DROP TABLE hkcms_admin

CREATE 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 ,-- '更新时间',

)--='菜单规则';

本文来自互联网用户投稿，该文观点仅代表作者本人，不代表本站立场。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如若转载，请注明出处：http://www.mfbz.cn/a/191026.html

如若内容造成侵权/违法违规/事实不符，请联系我们进行投诉反馈qq邮箱809451989@qq.com，一经查实，立即删除！

相关文章

本地运行“李开复”的零一万物 34B 大模型

本地运行“李开复”的零一万物 34B 大模型

这篇文章，我们来聊聊如何本地运行最近争议颇多的，李开复带队的国产大模型：零一万物 34B。 写在前面 零一万物的模型争议有很多，不论是在海外的社交媒体平台，还是在国内的知乎和一种科技媒体上，不论是针对…
阅读更多...
【Spring】Spring事务失效问题

【Spring】Spring事务失效问题

📫作者简介：小明java问道之路，2022年度博客之星全国TOP3，专注于后端、中间件、计算机底层、架构设计演进与稳定性建设优化，文章内容兼具广度、深度、大厂技术方案，对待技术喜欢推理加验证，就职于…
阅读更多...
058-第三代软件开发-文件Model

058-第三代软件开发-文件Model

第三代软件开发-文件Model 文章目录 第三代软件开发-文件Model项目介绍文件Model 关键字： Qt、 Qml、 关键字3、 关键字4、 关键字5 项目介绍 欢迎来到我们的 QML & C 项目！这个项目结合了 QML（Qt Meta-Object Language）…
阅读更多...
智能头盔天眼摄像头、单兵执法记录仪等配合MESH自组网在应急指挥调度中的应用

智能头盔天眼摄像头、单兵执法记录仪等配合MESH自组网在应急指挥调度中的应用

智能头盔、天眼摄像头、头盔记录仪、头盔摄像头、单兵执法记录仪等配合MESH自组网在应急指挥调度中的应用。 20人背负单兵自组网（带手咪）到训练场，戴头盔，头盔上放头盔式摄像头，大功率自组网设置在制高点，…
阅读更多...
【办公软件】电脑开机密码忘记了如何重置？

【办公软件】电脑开机密码忘记了如何重置？

这个案例是家人的电脑，已经使用多年，又是有小孩操作过的，所以电脑密码根本不记得是什么了？那难道这台电脑就废了吗？需要重新装机吗？那里面的资料不是没有了？ 为了解决以上问题，一般…
阅读更多...
数据结构——哈夫曼树结构总结

数据结构——哈夫曼树结构总结

一直在找工作，没时间写博客，现在找到工作了，博客回归~ 哈夫曼树定义及构建教程
阅读更多...
C#，《小白学程序》第三课：类class，类的数组及类数组的排序

C#，《小白学程序》第三课：类class，类的数组及类数组的排序

类class把数值与功能巧妙的进行了结合&#xff0c;是编程技术的主要进步。 下面的程序你可以确立 分数 与 姓名 之间关系&#xff0c;并排序。 1 文本格式 /// <summary> /// 同学信息类 /// </summary> public class Classmate { /// <summary> /…
阅读更多...
IDM（Internet Download Manager）PC版提升下载速度与效率的利器

IDM（Internet Download Manager）PC版提升下载速度与效率的利器

你是否曾经因为下载速度慢而感到烦恼&#xff1f;或者在下载大型文件时&#xff0c;经历了长时间的等待&#xff1f;如果你有这样的困扰&#xff0c;那么IDM&#xff08;Internet Download Manager&#xff09;就是你的救星&#xff01; IDM是一款高效、实用的下载管理器&…
阅读更多...
Day42力扣打卡

Day42力扣打卡

打卡记录 统计子串中的唯一字符&#xff08;找规律&#xff09; 链接 大佬的题解 class Solution:def uniqueLetterString(self, s: str) -> int:ans total 0last0, last1 {}, {}for i, c in enumerate(s):total i - 2 * last0.get(c, -1) last1.get(c, -1)ans tot…
阅读更多...
如何深刻理解从二项式分布到泊松分布

如何深刻理解从二项式分布到泊松分布

泊松镇贴 二项分布和泊松分布的表达式 二项分布&#xff1a; P ( x k ) C n k p k ( 1 − p ) n − k P(xk) C_n^kp^k(1-p)^{n-k} P(xk)Cnk​pk(1−p)n−k 泊松分布&#xff1a; P ( x k ) λ k k ! e − λ P(xk) \frac{\lambda^k}{k!}e^{-\lambda} P(xk)k!λk​e−…
阅读更多...
NX二次开发UF_CURVE_ask_trim 函数介绍

NX二次开发UF_CURVE_ask_trim 函数介绍

文章作者&#xff1a;里海 来源网站&#xff1a;https://blog.csdn.net/WangPaiFeiXingYuan UF_CURVE_ask_trim Defined in: uf_curve.h int UF_CURVE_ask_trim(tag_t trim_feature, UF_CURVE_trim_p_t trim_info ) overview 概述 Retrieve the current parameters of an a…
阅读更多...
车载通信架构 —— 传统车内通信网络CAN（可靠性为王）

车载通信架构 —— 传统车内通信网络CAN（可靠性为王）

车载通信架构 —— 传统车内通信网络CAN（可靠性为王） 我是穿拖鞋的汉子，魔都中坚持长期主义的汽车电子工程师。 老规矩，分享一段喜欢的文字，避免自己成为高知识低文化的工程师： 屏蔽力是信息过载时代一个人的特殊竞争力，任何消耗你的人和事，多看一眼都是你的不对。非…
阅读更多...
自建CA实战之 《0x03 代码签名》

自建CA实战之 《0x03 代码签名》

自建CA实战之 《0x03 代码签名》 本文针对Windows平台&#xff0c;介绍如何使用自建CA来签发代码签名证书。 之前的文章中&#xff0c;我们介绍了如何自建CA&#xff0c;以及如何使用自建CA来签发Web服务器证书、客户端证书。 本文将介绍如何使用自建CA来签发代码签名证书。…
阅读更多...
二叉树算法—后继节点

二叉树算法—后继节点

与其明天开始&#xff0c;不如现在行动&#xff01; 文章目录 1 后继节点1.1 解题思路1.2 代码实现 &#x1f48e;总结 1 后继节点 1.1 解题思路 二叉树节点结构定义如下&#xff1a; public static class Node { public int cal; public Node left; public Node right; public…
阅读更多...
【C++初阶】STL之学习string的用法

【C++初阶】STL之学习string的用法

目录 前言&#xff1a;一、认识下string1.1 什么是string1.2 为什么要有string 二、string 类的接口使用2.1 初始化与析构2.1.1 初始化2.1.2 析构 2.2 容量操作2.2.1 长度大小——size和length2.2.2 空间总大小——capacity2.2.3 判空——empty2.2.4 清空——clear2.2.5 预留空…
阅读更多...
C语言之内存函数

C语言之内存函数

C语言之内存函数 文章目录 C语言之内存函数1. memcpy 使⽤和模拟实现1.1 memcpy 函数的使用1.3 memcpy的模拟实现 2. memmove 使⽤和模拟实现2.1 memmove 函数的使用2.2 memmove的模拟实现 3. memset 函数的使用4. memcmp 函数的使⽤ 1. memcpy 使⽤和模拟实现 函数声明如下&a…
阅读更多...
【python】Python将100个PDF文件对应的json文件存储到MySql数据库（源码）【独一无二】

【python】Python将100个PDF文件对应的json文件存储到MySql数据库（源码）【独一无二】

&#x1f449;博__主&#x1f448;&#xff1a;米码收割机 &#x1f449;技__能&#x1f448;&#xff1a;C/Python语言 &#x1f449;公众号&#x1f448;&#xff1a;测试开发自动化【获取源码商业合作】 &#x1f449;荣__誉&#x1f448;&#xff1a;阿里云博客专家博主、5…
阅读更多...
video标签在h5中被劫持问题

video标签在h5中被劫持问题

将video的视频链接转为blob export const encryptionVideo (options: URL) > {return new Promise((resolve, reject) > {window.URL window.URL || window.webkitURL;var xhr new XMLHttpRequest();xhr.open(GET, options.url, true);xhr.responseType blob;xhr.onl…
阅读更多...
Windows 7隐藏用户测试

Windows 7隐藏用户测试

请注意Window 7是在虚拟机上安装的&#xff0c;ip是192.168.0.108。 下边都是在虚拟机Window 7上操作&#xff0c;直到最后远程连接才在自己本机Windows 11上操作。 需要同时按下Windowsr,然后输入cmd&#xff0c;再点击确定。 在命令上里边输入net user可以显示一下用户。 …
阅读更多...
Unity阻止射线穿透UI的方法之一

Unity阻止射线穿透UI的方法之一

if(UnityEngine.EventSystems.EventSystem.current.IsPointerOverGameObject()) return; 作者&#xff1a;StormerZ https://www.bilibili.com/read/cv27797873/ 出处&#xff1a;bilibili
阅读更多...
最新文章

Copyright @ 2022~2023

友情链接： 我的编程经验分享 一条长河网 尧图网站开发 尧图建网站