From 084be628972bef5eeb3b671547d68e6cae4d918b Mon Sep 17 00:00:00 2001
From: michael pereira
Date: Tue, 26 Apr 2011 16:44:32 +0200
Subject: fixes

---
 setup/pbs.sql | 8 +++++++-
 1 file changed, 7 insertions(+), 1 deletion(-)

(limited to 'setup/pbs.sql')

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'),
-- 
cgit v1.2.3-55-g7522

