当前位置： 首页 > news >正文

flash网站规划网站建设 教学视频

news 2025/10/3 5:34:28
flash网站规划,网站建设 教学视频,网站群建设路径,辽宁建设工程（C#）用户、角色、权限 https://www.cnblogs.com/huangwen/articles/638050.html 权限管理系统——数据库的设计（一） https://www.cnblogs.com/cmsdn/p/3371576.html 权限管理系统——菜单模块的实现（二） …

（C#）用户、角色、权限

https://www.cnblogs.com/huangwen/articles/638050.html

权限管理系统——数据库的设计（一）

https://www.cnblogs.com/cmsdn/p/3371576.html

权限管理系统——菜单模块的实现（二）

https://www.cnblogs.com/cmsdn/p/3433995.html

-- 生成日期: 2024-01-08 23:25:34--
-- 表的结构 `ay_role`
--DROP TABLE IF EXISTS `ay_role`;
CREATE TABLE `ay_role` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '角色编号',`rcode` varchar(20) NOT NULL COMMENT '角色编码',`name` varchar(30) NOT NULL COMMENT '角色名称',`description` varchar(50) NOT NULL COMMENT '角色描述',`create_user` varchar(30) NOT NULL COMMENT '创建人员',`update_user` varchar(30) NOT NULL COMMENT '更新人员',`create_time` datetime NOT NULL COMMENT '创建时间',`update_time` datetime NOT NULL COMMENT '更新时间',PRIMARY KEY (`id`),UNIQUE KEY `ay_role_rcode` (`rcode`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;--
-- 转存表中的数据 `ay_role`
--INSERT INTO `ay_role` (`id`,`rcode`,`name`,`description`,`create_user`,`update_user`,`create_time`,`update_time`) VALUES
('1','R101','系统管理员','系统管理员具有所有权限','admin','admin','2017-03-22 11:33:32','2019-08-05 11:22:02'),
('2','R102','内容管理员','内容管理员具有基本内容管理权限','admin','admin','2017-06-01 00:32:02','2019-08-05 11:22:12');--
-- 表的结构 `ay_user`
--DROP TABLE IF EXISTS `ay_user`;
CREATE TABLE `ay_user` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户编号',`ucode` varchar(20) NOT NULL COMMENT '用户编码',`username` varchar(30) NOT NULL COMMENT '用户账号',`realname` varchar(30) NOT NULL COMMENT '真实名字',`password` char(32) NOT NULL COMMENT '用户密码',`status` char(1) NOT NULL DEFAULT '1' COMMENT '是否启用',`login_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '登录次数',`last_login_ip` varchar(11) NOT NULL DEFAULT '0' COMMENT '最后登录IP',`create_user` varchar(30) NOT NULL COMMENT '添加人员',`update_user` varchar(30) NOT NULL COMMENT '更新用户',`create_time` datetime NOT NULL COMMENT '创建时间',`update_time` datetime NOT NULL COMMENT '更新时间',PRIMARY KEY (`id`),UNIQUE KEY `ay_user_ucode` (`ucode`),KEY `ay_user_username` (`username`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;--
-- 转存表中的数据 `ay_user`
--INSERT INTO `ay_user` (`id`,`ucode`,`username`,`realname`,`password`,`status`,`login_count`,`last_login_ip`,`create_user`,`update_user`,`create_time`,`update_time`) VALUES
('1','10001','admin','超级管理员','14e1b600b1fd579f47433b88e8d85291','1','0','2130706433','admin','admin','2017-05-08 18:50:30','2018-07-17 15:47:27');-- ----------------------------------------------------------
-- 表的结构 `ay_user_role`
--DROP TABLE IF EXISTS `ay_user_role`;
CREATE TABLE `ay_user_role` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',`ucode` varchar(20) NOT NULL COMMENT '用户编码',`rcode` varchar(20) NOT NULL COMMENT '角色编码',PRIMARY KEY (`id`),KEY `ay_user_role_ucode` (`ucode`),KEY `ay_user_role_rcode` (`rcode`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;--
-- 转存表中的数据 `ay_user_role`
--INSERT INTO `ay_user_role` (`id`,`ucode`,`rcode`) VALUES
('1','10001','R101');-- ----------------------------------------------------------
-- 表的结构 `ay_role_level`
--DROP TABLE IF EXISTS `ay_role_level`;
CREATE TABLE `ay_role_level` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',`rcode` varchar(20) NOT NULL COMMENT '角色编码',`level` varchar(50) NOT NULL COMMENT '权限地址',PRIMARY KEY (`id`),KEY `ay_role_level_rcode` (`rcode`)
) ENGINE=MyISAM AUTO_INCREMENT=216 DEFAULT CHARSET=utf8;--
-- 转存表中的数据 `ay_role_level`
--INSERT INTO `ay_role_level` (`id`,`rcode`,`level`) VALUES
('165','R101','/admin/Role/index'),
('164','R101','/admin/Menu/mod'),
('163','R101','/admin/Menu/del'),
('162','R101','/admin/Menu/add'),
('161','R101','/admin/Menu/index'),
('160','R101','/admin/Area/mod'),
('159','R101','/admin/Area/del'),
('158','R101','/admin/Area/add'),
('157','R101','/admin/Area/index'),
('156','R101','/admin/M101/index'),
('155','R101','/admin/Tags/mod'),
('154','R101','/admin/Tags/del'),
('153','R101','/admin/Tags/add'),
('152','R101','/admin/Tags/index'),
('151','R101','/admin/Form/mod'),
('150','R101','/admin/Form/del'),
('149','R101','/admin/Form/add'),
('148','R101','/admin/Form/index'),
('147','R101','/admin/Link/mod'),
('146','R101','/admin/Link/del'),
('145','R101','/admin/Link/add'),
('144','R101','/admin/Link/index'),
('143','R101','/admin/Slide/mod'),
('142','R101','/admin/Slide/del'),
('141','R101','/admin/Slide/add'),
('140','R101','/admin/Slide/index'),
('139','R101','/admin/Message/mod'),
('138','R101','/admin/Message/del'),
('137','R101','/admin/Message/index'),
('136','R101','/admin/M157/index'),
('135','R101','/admin/Content/mod'),
('134','R101','/admin/Content/del'),
('133','R101','/admin/Content/add'),
('132','R101','/admin/Content/index'),
('131','R101','/admin/Single/mod'),
('130','R101','/admin/Single/index'),
('129','R101','/admin/M130/index'),
('128','R101','/admin/ContentSort/mod'),
('127','R101','/admin/ContentSort/del'),
('126','R101','/admin/ContentSort/add'),
('125','R101','/admin/ContentSort/index'),
('124','R101','/admin/Company/mod'),
('123','R101','/admin/Company/index'),
('122','R101','/admin/Site/mod'),
('121','R101','/admin/Site/index'),
('120','R101','/admin/M110/index'),
('119','R101','/admin/ExtField/mod'),
('118','R101','/admin/ExtField/del'),
('117','R101','/admin/ExtField/add'),
('116','R101','/admin/ExtField/index'),
('115','R101','/admin/Model/mod'),
('114','R101','/admin/Model/del'),
('113','R101','/admin/Model/add'),
('112','R101','/admin/Model/index'),
('111','R101','/admin/Label/mod'),
('110','R101','/admin/Label/del'),
('109','R101','/admin/Label/add'),
('108','R101','/admin/Label/index'),
('107','R101','/admin/Config/index'),
('106','R101','/admin/M156/index'),
('205','R102','/admin/Link/add'),
('204','R102','/admin/Link/index'),
('203','R102','/admin/Slide/mod'),
('202','R102','/admin/Slide/del'),
('201','R102','/admin/Slide/add'),
('200','R102','/admin/Slide/index'),
('199','R102','/admin/Message/mod'),
('198','R102','/admin/Message/del'),
('197','R102','/admin/Message/index'),
('196','R102','/admin/M157/index'),
('195','R102','/admin/Content/mod'),
('194','R102','/admin/Content/del'),
('193','R102','/admin/Content/add'),
('192','R102','/admin/Content/index'),
('191','R102','/admin/Single/mod'),
('190','R102','/admin/Single/index'),
('189','R102','/admin/M130/index'),
('188','R102','/admin/ContentSort/mod'),
('187','R102','/admin/ContentSort/del'),
('186','R102','/admin/ContentSort/add'),
('185','R102','/admin/ContentSort/index'),
('184','R102','/admin/Company/mod'),
('183','R102','/admin/Company/index'),
('182','R102','/admin/Site/mod'),
('181','R102','/admin/Site/index'),
('180','R102','/admin/M110/index'),
('166','R101','/admin/Role/add'),
('167','R101','/admin/Role/del'),
('168','R101','/admin/Role/mod'),
('169','R101','/admin/User/index'),
('170','R101','/admin/User/add'),
('171','R101','/admin/User/del'),
('172','R101','/admin/User/mod'),
('173','R101','/admin/Syslog/index'),
('174','R101','/admin/Type/index'),
('175','R101','/admin/Type/add'),
('176','R101','/admin/Type/del'),
('177','R101','/admin/Type/mod'),
('178','R101','/admin/Database/index'),
('179','R101','/admin/Site/server'),
('206','R102','/admin/Link/del'),
('207','R102','/admin/Link/mod'),
('208','R102','/admin/Form/index'),
('209','R102','/admin/Form/add'),
('210','R102','/admin/Form/del'),
('211','R102','/admin/Form/mod'),
('212','R102','/admin/Tags/index'),
('213','R102','/admin/Tags/add'),
('214','R102','/admin/Tags/del'),
('215','R102','/admin/Tags/mod');-- ----------------------------------------------------------
-- 表的结构 `ay_type`
--DROP TABLE IF EXISTS `ay_type`;
CREATE TABLE `ay_type` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '类型编号',`tcode` varchar(20) NOT NULL COMMENT '类型编码',`name` varchar(30) NOT NULL COMMENT '类型名称',`item` varchar(30) NOT NULL COMMENT '类型项',`value` varchar(20) NOT NULL DEFAULT '0' COMMENT '类型值',`sorting` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序',`create_user` varchar(30) NOT NULL COMMENT '添加人员',`update_user` varchar(30) NOT NULL COMMENT '更新时间',`create_time` datetime NOT NULL COMMENT '添加时间',`update_time` datetime NOT NULL COMMENT '更新时间',PRIMARY KEY (`id`),KEY `ay_type_tcode` (`tcode`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;--
-- 转存表中的数据 `ay_type`
--INSERT INTO `ay_type` (`id`,`tcode`,`name`,`item`,`value`,`sorting`,`create_user`,`update_user`,`create_time`,`update_time`) VALUES
('1','T101','菜单功能','新增','add','1','admin','admin','2017-04-27 07:28:34','2017-08-09 15:25:56'),
('2','T101','菜单功能','删除','del','2','admin','admin','2017-04-27 07:29:08','2017-08-09 15:23:34'),
('3','T101','菜单功能','修改','mod','3','admin','admin','2017-04-27 07:29:34','2017-08-09 15:23:32'),
('4','T101','菜单功能','导出','export','4','admin','admin','2017-04-27 07:30:42','2017-08-09 15:23:29'),
('5','T101','菜单功能','导入','import','5','admin','admin','2017-04-27 07:31:38','2017-08-09 15:23:27');-- ----------------------------------------------------------
-- 表的结构 `ay_menu`
--DROP TABLE IF EXISTS `ay_menu`;
CREATE TABLE `ay_menu` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '菜单编号',`mcode` varchar(20) NOT NULL COMMENT '菜单编码',`pcode` varchar(20) NOT NULL COMMENT '上级菜单',`name` varchar(50) NOT NULL COMMENT '菜单名称',`url` varchar(100) NOT NULL COMMENT '菜单地址',`sorting` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '菜单排序',`status` char(1) NOT NULL DEFAULT '1' COMMENT '是否启用',`shortcut` char(1) NOT NULL DEFAULT '0' COMMENT '桌面图标',`ico` varchar(30) NOT NULL COMMENT '菜单图标',`create_user` varchar(30) NOT NULL COMMENT '创建人员',`update_user` varchar(30) NOT NULL COMMENT '更新人员',`create_time` datetime NOT NULL COMMENT '创建时间',`update_time` datetime NOT NULL COMMENT '更新时间',PRIMARY KEY (`id`),UNIQUE KEY `ay_menu_mcode` (`mcode`),KEY `ay_menu_pcode` (`pcode`),KEY `ay_menu_sorting` (`sorting`)
) ENGINE=MyISAM AUTO_INCREMENT=67 DEFAULT CHARSET=utf8;--
-- 转存表中的数据 `ay_menu`
--INSERT INTO `ay_menu` (`id`,`mcode`,`pcode`,`name`,`url`,`sorting`,`status`,`shortcut`,`ico`,`create_user`,`update_user`,`create_time`,`update_time`) VALUES
('1','M101','0','系统管理','/admin/M101/index','900','1','0','fa-cog','admin','admin','0000-00-00 00:00:00','2018-04-30 14:52:57'),
('2','M102','M101','数据区域','/admin/Area/index','901','1','1','fa-sitemap','admin','admin','0000-00-00 00:00:00','2018-04-30 14:54:23'),
('3','M103','M101','系统菜单','/admin/Menu/index','902','0','0','fa-bars','admin','admin','0000-00-00 00:00:00','2018-04-30 14:54:35'),
('4','M104','M101','系统角色','/admin/Role/index','903','1','1','fa-hand-stop-o','admin','admin','0000-00-00 00:00:00','2018-04-30 14:54:43'),
('5','M105','M101','系统用户','/admin/User/index','904','1','1','fa-users','admin','admin','0000-00-00 00:00:00','2018-04-30 14:54:51'),
('6','M106','M101','系统日志','/admin/Syslog/index','905','1','1','fa-history','admin','admin','0000-00-00 00:00:00','2018-04-30 14:55:00'),
('7','M107','M101','类型管理','/admin/Type/index','906','0','0','fa-tags','admin','admin','0000-00-00 00:00:00','2018-04-30 14:55:13'),
('8','M108','M101','数据库管理','/admin/Database/index','907','1','1','fa-database','admin','admin','0000-00-00 00:00:00','2018-04-30 14:55:24'),
('9','M109','M101','服务器信息','/admin/Site/server','908','1','1','fa-info-circle','admin','admin','0000-00-00 00:00:00','2018-04-30 14:55:34'),
('10','M1101', 'M101', '图片清理', '/admin/ImageExt/index', '909', '1', '1', 'fa-trash', 'admin', 'admin', '0000-00-00 00:00:00', '2022-09-19 13:44:59'),
('11','M110','0','基础内容','/admin/M110/index','300','1','0','fa-sliders','admin','admin','2017-11-28 11:13:05','2018-04-30 14:48:29'),
('12','M112','M110','站点信息','/admin/Site/index','301','1','1','fa-cog','admin','admin','0000-00-00 00:00:00','2018-04-07 18:45:57'),
('13','M113','M110','公司信息','/admin/Company/index','302','1','1','fa-copyright','admin','admin','0000-00-00 00:00:00','2018-04-07 18:46:09'),
('29','M129','M110','内容栏目','/admin/ContentSort/index','303','1','1','fa-bars','admin','admin','2017-12-26 10:42:40','2018-04-07 18:46:25'),
('30','M130','0','文章内容','/admin/M130/index','400','1','0','fa-file-text-o','admin','admin','2017-12-26 10:45:36','2018-04-30 14:49:47'),
('31','M131','M130','单页内容','/admin/Single/index','401','0','0','fa-file-o','admin','admin','2017-12-26 10:46:35','2018-04-07 18:46:35'),
('32','M132','M130','列表内容','/admin/Content/index','402','0','0','fa-file-text-o','admin','admin','2017-12-26 10:48:17','2018-04-07 21:52:15'),
('36','M136','M156','定制标签','/admin/Label/index','203','1','1','fa-wrench','admin','admin','2018-01-03 11:52:40','2018-04-07 18:44:31'),
('50','M150','M157','留言信息','/admin/Message/index','501','1','1','fa-question-circle-o','admin','admin','2018-02-01 13:20:17','2018-07-07 23:45:09'),
('51','M151','M157','轮播图片','/admin/Slide/index','502','1','1','fa-picture-o','admin','admin','2018-03-01 14:57:41','2018-04-07 18:47:07'),
('52','M152','M157','友情链接','/admin/Link/index','503','1','1','fa-link','admin','admin','2018-03-01 14:58:45','2018-04-07 18:47:16'),
('53','M153','M156','配置参数','/admin/Config/index','201','1','1','fa-sliders','admin','admin','2018-03-21 14:52:05','2018-04-07 18:44:02'),
('61','M1000','M157','文章内链','/admin/Tags/index','505','1','0','fa-random','admin','admin','2019-07-12 08:25:41','2019-07-12 08:26:23'),
('55','M155','M156','模型管理','/admin/Model/index','204','1','1','fa-codepen','admin','admin','2018-03-25 17:16:06','2018-04-07 18:44:40'),
('56','M156','0','全局配置','/admin/M156/index','200','1','0','fa-globe','admin','admin','2018-03-25 17:20:43','2018-04-30 14:43:56'),
('58','M158','M156','模型字段','/admin/ExtField/index','205','1','1','fa-external-link','admin','admin','2018-03-25 21:24:43','2018-04-07 18:44:49'),
('57','M157','0','扩展内容','/admin/M157/index','500','1','0','fa-arrows-alt','admin','admin','2018-03-25 17:27:57','2018-04-30 14:50:34'),
('60','M160','M157','自定义表单','/admin/Form/index','504','1','1','fa-plus-square-o','admin','admin','2018-05-30 18:25:41','2018-05-31 23:55:10'),
('62','M1001','0','会员中心','/admin/M1001/index','600','1','0','fa-user-o','admin','admin','2019-10-04 08:25:41','2019-10-04 08:26:23'),
('63','M1002','M1001','会员等级','/admin/MemberGroup/index','601','1','0','fa-signal','admin','admin','2019-10-04 08:25:41','2019-10-04 08:26:23'),
('64','M1003','M1001','会员字段','/admin/MemberField/index','602','1','0','fa-wpforms','admin','admin','2019-10-04 08:25:41','2019-10-04 08:26:23'),
('65','M1004','M1001','会员管理','/admin/Member/index','603','1','0','fa-users','admin','admin','2019-10-04 08:25:41','2019-10-04 08:26:23'),
('66','M1005','M1001','文章评论','/admin/MemberComment/index','604','1','0','fa-commenting-o','admin','admin','2019-10-04 08:25:41','2019-10-04 08:26:23');-- ----------------------------------------------------------
-- 表的结构 `ay_menu_action`
--DROP TABLE IF EXISTS `ay_menu_action`;
CREATE TABLE `ay_menu_action` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT,`mcode` varchar(20) NOT NULL COMMENT '菜单编码',`action` varchar(20) NOT NULL COMMENT '类型编码',PRIMARY KEY (`id`),KEY `ay_menu_action_mcode` (`mcode`)
) ENGINE=MyISAM AUTO_INCREMENT=79 DEFAULT CHARSET=utf8;--
-- 转存表中的数据 `ay_menu_action`
--INSERT INTO `ay_menu_action` (`id`,`mcode`,`action`) VALUES
('1','M102','mod'),
('2','M102','del'),
('3','M102','add'),
('4','M103','mod'),
('5','M103','del'),
('6','M103','add'),
('7','M104','mod'),
('8','M104','del'),
('9','M104','add'),
('10','M105','mod'),
('11','M105','del'),
('12','M105','add'),
('13','M107','mod'),
('14','M107','del'),
('15','M107','add'),
('16','M111','mod'),
('17','M112','mod'),
('18','M114','mod'),
('19','M114','del'),
('20','M114','add'),
('21','M120','mod'),
('22','M120','del'),
('23','M120','add'),
('24','M129','mod'),
('25','M129','del'),
('26','M129','add'),
('27','M131','mod'),
('28','M132','mod'),
('29','M132','del'),
('30','M132','add'),
('31','M136','mod'),
('32','M136','del'),
('33','M136','add'),
('34','M141','mod'),
('35','M141','del'),
('36','M141','add'),
('37','M142','mod'),
('38','M142','del'),
('39','M142','add'),
('40','M143','mod'),
('41','M143','del'),
('42','M143','add'),
('43','M144','mod'),
('44','M144','del'),
('45','M144','add'),
('46','M145','mod'),
('47','M145','del'),
('48','M145','add'),
('49','M150','del'),
('50','M150','mod'),
('51','M151','mod'),
('52','M151','del'),
('53','M151','add'),
('54','M152','mod'),
('55','M152','del'),
('56','M152','add'),
('57','M155','mod'),
('58','M155','del'),
('59','M155','add'),
('60','M158','mod'),
('61','M158','del'),
('62','M158','add'),
('63','M160','add'),
('64','M160','del'),
('65','M160','mod'),
('66','M1000','add'),
('67','M1000','del'),
('68','M1000','mod'),
('69','M1002','add'),
('70','M1002','del'),
('71','M1002','mod'),
('72','M1003','add'),
('73','M1003','del'),
('74','M1003','mod'),
('75','M1004','add'),
('76','M1004','del'),
('77','M1004','mod'),
('78','M1005','del');-- --------------------------------------------------------

菜单模块的实现，两种菜单，方便操作，先看整体结构图

http://www.yayakq.cn/news/564392/

相关文章：

  • 建设网站能自学吗邢台市教育考试院
  • 西安的网站建设网站艺术网站定制
  • 汕头有建网站公司吗图片文字制作
  • 深圳公司网站开发wordpress采集站源码
  • wordpress多站点优缺点自己可以做小程序商城吗
  • 深圳建设交易网站网站备案号有效期
  • 泉州网站建设托管wordpress 支持多域名
  • 做HH的网站网站死链检查
  • 网站如何提高流量做放单主持的网站
  • 辽宁省建设厅网站官网有中文网站 怎么做英文网站
  • 怎么查网站的空间商新河网站
  • 巴塘网站建设乐清北白象网络怎么装
  • 资溪做面包招聘的网站广告联盟app
  • 哈尔滨企业自助建站莱芜网站优化加徽信xiala5
  • 路由器通过域名解析做网站产品推广广告
  • 企业网站发展趋势河北邢台移动网站建设
  • 做网络推广的网站有哪些漳州市城乡和住房建设局网站
  • 苏宁易购网站建设怎样做读书会网站
  • 网站有源代码如何做seo淘宝网页版官网入口
  • 西部数码网站源码怀仁网站建设
  • 做网站赚钱全攻略ftp网站怎么看后台的代码
  • 怎么开网站 第一步怎么做wordpress主题文件夹
  • 网站制作公司网站建设手机响应式网站
  • 建设银行广州招聘网站播放视频网站怎么做
  • 淮安新港建设有限公司网站网站目录有什么意义
  • 专业网站定制公司wordpress wiki 皮肤
  • 知名网站建设是哪家网上做室内设计的网站
  • 购物网站流量怎么做大连做网站团队
  • 郑州网站制作费用积极做好门户网站建设工作
  • 个人两字印章在线制作网站网站开发vue