diff options
| author | michael pereira | 2011-04-26 16:44:32 +0200 |
|---|---|---|
| committer | michael pereira | 2011-04-26 16:44:32 +0200 |
| commit | 084be628972bef5eeb3b671547d68e6cae4d918b (patch) | |
| tree | 8d25fbfe1a53ff99708b5548e06b19d8c4c4f6ce /setup/pbs.sql | |
| parent | Merge branch 'master' of openslx.org:lsfks/master-teamprojekt/pbs2 (diff) | |
| download | pbs2-084be628972bef5eeb3b671547d68e6cae4d918b.tar.gz pbs2-084be628972bef5eeb3b671547d68e6cae4d918b.tar.xz pbs2-084be628972bef5eeb3b671547d68e6cae4d918b.zip | |
fixes
Diffstat (limited to 'setup/pbs.sql')
| -rw-r--r-- | setup/pbs.sql | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/setup/pbs.sql b/setup/pbs.sql index d2bdeda..6d5dbb3 100644 --- a/setup/pbs.sql +++ b/setup/pbs.sql @@ -119,7 +119,7 @@ ALTER TABLE `pbs_membership` ADD CONSTRAINT `pbs_membership_ibfk_3` FOREIGN KEY (`roleID`) REFERENCES `pbs_role` (`roleID`) ON DELETE CASCADE; CREATE TABLE IF NOT EXISTS `pbs_hometype` ( - `hometypeID` int(11) NOT NULL AUTO_INCREMENT, + `hometypeID` int(11) NOT NULL, `name` varchar(30) NOT NULL, PRIMARY KEY (`hometypeID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1; @@ -379,6 +379,12 @@ INSERT INTO `pbs_filtertype` (`filtertypeID`, `filtertypename`) VALUES (10, 'Weekday'), (11, 'Date'); +-- Adding hometype +INSERT INTO `pbs_hometype` (`hometypeID`, `name`) VALUES +(0, 'standard'), +(1, 'usbstick'), +(2, 'custom path'); + -- Insert rightcategorys INSERT INTO `pbs_rightcategory` (`rightcategoryID`, `title`) VALUES (1, 'Person'), |