summaryrefslogtreecommitdiffstats
path: root/setup/pbs.sql
diff options
context:
space:
mode:
Diffstat (limited to 'setup/pbs.sql')
-rw-r--r--setup/pbs.sql8
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'),