diff options
author | Björn Geiger | 2011-03-28 14:38:51 +0200 |
---|---|---|
committer | Björn Geiger | 2011-03-28 14:38:51 +0200 |
commit | 49ebfec064bb6d7a732466fa2071778665beb184 (patch) | |
tree | 98895379ee4152b7312bc415cfc6e2f3dd305faf /pbs.sql | |
parent | Einführung einer Rightcategory (diff) | |
download | pbs2-49ebfec064bb6d7a732466fa2071778665beb184.tar.gz pbs2-49ebfec064bb6d7a732466fa2071778665beb184.tar.xz pbs2-49ebfec064bb6d7a732466fa2071778665beb184.zip |
Einführung von Vererbung von Rollen
Diffstat (limited to 'pbs.sql')
-rw-r--r-- | pbs.sql | 5 |
1 files changed, 3 insertions, 2 deletions
@@ -31,10 +31,11 @@ CREATE TABLE IF NOT EXISTS `pbs_role` ( `roleID` int(11) NOT NULL AUTO_INCREMENT, `groupID` int(11) NOT NULL, `title` varchar(30) COLLATE utf8_unicode_ci NOT NULL, - `description` varchar(140) COLLATE utf8_unicode_ci, + `description` varchar(140) COLLATE utf8_unicode_ci DEFAULT NULL, + `inheritance` tinyint(1) NOT NULL, PRIMARY KEY (`roleID`), KEY `groupID` (`groupID`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ; ALTER TABLE `pbs_role` ADD CONSTRAINT `pbs_role_ibfk_1` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE; |