sql korrigiert, layout angepasst, .htaccess angepasst

1 files changed, 2 insertions, 8 deletions

diff --git a/pbs.sql b/pbs.sql
index 15d8fe3..9a14bb2 100644
--- a/pbs.sql
+++ b/pbs.sql
@@ -235,10 +235,7 @@ CREATE TABLE IF NOT EXISTS `pbs_pool` (
 
 CREATE TABLE IF NOT EXISTS `pbs_poolentries` (
   `poolID` int(11) NOT NULL,
-  `clientID` int(11) NOT NULL,
-  PRIMARY KEY (`poolID`,`clientID`),
-  KEY `poolID` (`poolID`),
-  KEY `clientID` (`clientID`)
+  `clientID` int(11) NOT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
 ALTER TABLE `pbs_poolentries` ADD `poolentriesID` INT NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
 
@@ -300,10 +297,7 @@ CREATE TABLE IF NOT EXISTS `pbs_filterentries` (
   `filterID` int(11) NOT NULL,
   `filtertypeID` int(11) NOT NULL,
   `filtervalue` varchar(140) NOT NULL,
-  `filtervalue2` varchar(140) NOT NULL,
-  PRIMARY KEY (`filterID`,`filtertypeID`),
-  KEY `filterID` (`filterID`),
-  KEY `filtertypeID` (`filtertypeID`)
+  `filtervalue2` varchar(140) NOT NULL 
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
 
 ALTER TABLE `pbs_filterentries` ADD `filterentriesID` INT NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;