diff options
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'), |
