|
发表于 2014-8-28 14:17:25
|
显示全部楼层
感觉基于角色的访问控制(Role-Based Access Control)会是一种更成熟的解决方案。
- DROP TABLE IF EXISTS `authassignment`;
- CREATE TABLE `authassignment` (
- `itemname` varchar(64) NOT NULL,
- `userid` varchar(64) NOT NULL,
- `bizrule` text,
- `data` text,
- PRIMARY KEY (`itemname`,`userid`),
- CONSTRAINT `authassignment_ibfk_1` FOREIGN KEY (`itemname`) REFERENCES `authitem` (`name`) ON DELETE CASCADE ON UPDATE CASCADE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- DROP TABLE IF EXISTS `authitem`;
- CREATE TABLE `authitem` (
- `name` varchar(64) NOT NULL,
- `type` int(11) NOT NULL,
- `description` text,
- `bizrule` text,
- `data` text,
- PRIMARY KEY (`name`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- DROP TABLE IF EXISTS `authitemchild`;
- CREATE TABLE `authitemchild` (
- `parent` varchar(64) NOT NULL,
- `child` varchar(64) NOT NULL,
- PRIMARY KEY (`parent`,`child`),
- KEY `child` (`child`),
- CONSTRAINT `authitemchild_ibfk_1` FOREIGN KEY (`parent`) REFERENCES `authitem` (`name`) ON DELETE CASCADE ON UPDATE CASCADE,
- CONSTRAINT `authitemchild_ibfk_2` FOREIGN KEY (`child`) REFERENCES `authitem` (`name`) ON DELETE CASCADE ON UPDATE CASCADE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
复制代码
上面SQL来自YII |
|