Nicht benötigte Tabellen entfernt, Diagramm wird automatisch generiert, Stats-Controller um Url für Bilder

1 files changed, 0 insertions, 22 deletions

diff --git a/pbs.sql b/pbs.sql
index 1cbc9c3..9d5d57d 100644
--- a/pbs.sql
+++ b/pbs.sql
@@ -295,29 +295,7 @@ ALTER TABLE `pbs_filter`
   ADD CONSTRAINT `pbs_filter_ibfk_2` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE,
   ADD CONSTRAINT `pbs_filter_ibfk_3` FOREIGN KEY (`bootmenuID`) REFERENCES `pbs_bootmenu` (`bootmenuID`) ON DELETE CASCADE;
 
-CREATE TABLE IF NOT EXISTS `pbs_membershipfilters` (
-  `membershipID` int(11) NOT NULL,
-  `filterID` int(11) NOT NULL,
-  PRIMARY KEY (`membershipID`,`filterID`),
-  KEY `membershipID` (`membershipID`),
-  KEY `filterID` (`filterID`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-
-ALTER TABLE `pbs_membershipfilters`
-  ADD CONSTRAINT `pbs_membershipfilters_ibfk_1` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`) ON DELETE CASCADE,
-  ADD CONSTRAINT `pbs_membershipfilters_ibfk_2` FOREIGN KEY (`filterID`) REFERENCES `pbs_filter` (`filterID`) ON DELETE CASCADE;
-
-CREATE TABLE IF NOT EXISTS `pbs_poolfilters` (
-  `poolID` int(11) NOT NULL,
-  `filterID` int(11) NOT NULL,
-  PRIMARY KEY (`poolID`,`filterID`),
-  KEY `poolID` (`poolID`),
-  KEY `filterID` (`filterID`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
 
-ALTER TABLE `pbs_poolfilters`
-  ADD CONSTRAINT `pbs_poolfilters_ibfk_1` FOREIGN KEY (`poolID`) REFERENCES `pbs_pool` (`poolID`) ON DELETE CASCADE,
-  ADD CONSTRAINT `pbs_poolfilters_ibfk_2` FOREIGN KEY (`filterID`) REFERENCES `pbs_filter` (`filterID`) ON DELETE CASCADE;
 
 CREATE TABLE IF NOT EXISTS `pbs_filtertype` (
   `filtertypeID` int(11) NOT NULL AUTO_INCREMENT,