summaryrefslogtreecommitdiffstats
path: root/setup
diff options
context:
space:
mode:
authorBjörn Geiger2011-10-06 13:37:16 +0200
committerBjörn Geiger2011-10-06 13:37:16 +0200
commita3045d9ec3ebbb77a6112f8ce4315b7b3ce80acf (patch)
treeccc8c2430650de6e2b36ed524ffb6ecf8824a3be /setup
parentsome statistic changes (diff)
downloadpoolctrl-a3045d9ec3ebbb77a6112f8ce4315b7b3ce80acf.tar.gz
poolctrl-a3045d9ec3ebbb77a6112f8ce4315b7b3ce80acf.tar.xz
poolctrl-a3045d9ec3ebbb77a6112f8ce4315b7b3ce80acf.zip
PBS Tabellen aus DB entfernt
Diffstat (limited to 'setup')
-rwxr-xr-xsetup/poolctrl.sql77
1 files changed, 2 insertions, 75 deletions
diff --git a/setup/poolctrl.sql b/setup/poolctrl.sql
index c3bf12f..070c79d 100755
--- a/setup/poolctrl.sql
+++ b/setup/poolctrl.sql
@@ -77,82 +77,7 @@ CREATE TABLE IF NOT EXISTS `poolctrl_eventreport` (
KEY `type` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;
--- PBS2 Tabellen
--- TO DO: Tabellen an dieser Stelle nicht per Hand erzeugen sondern von der PBS2-Datenbank kopieren, sodass diese auf dem neusten Stand sind
-CREATE TABLE IF NOT EXISTS `pbs_bootos` (
- `bootosID` int(11) NOT NULL AUTO_INCREMENT,
- `groupID` int(11) NOT NULL,
- `membershipID` int(11),
- `title` varchar(30) NOT NULL,
- `description` varchar(140),
- `distro` varchar(30),
- `distroversion` varchar(30),
- `source` varchar(140),
- `share` varchar(30),
- `shortname` varchar(30),
- `defaultkcl` varchar(255),
- `created` VARCHAR(14) NOT NULL,
- `expires` VARCHAR(14),
- `public` int(11) NOT NULL DEFAULT '-1',
- PRIMARY KEY (`bootosID`),
- KEY `groupID` (`groupID`),
- KEY `membershipID` (`membershipID`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-
-CREATE TABLE IF NOT EXISTS `pbs_config` (
- `configID` int(11) NOT NULL AUTO_INCREMENT,
- `title` varchar(30) NOT NULL,
- `description` varchar(140),
- `groupID` int(11),
- `membershipID` int(11),
- `visible` tinyint(1) DEFAULT '0',
- `created` VARCHAR(14) NOT NULL,
- `bootosID` int(11) NOT NULL,
- PRIMARY KEY (`configID`),
- KEY `bootosID` (`bootosID`),
- KEY `groupID` (`groupID`),
- KEY `membershipID` (`membershipID`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-
-CREATE TABLE IF NOT EXISTS `pbs_pool` (
- `poolID` int(11) NOT NULL AUTO_INCREMENT,
- `groupID` int(11) NOT NULL,
- `title` varchar(30) NOT NULL,
- `description` varchar(140),
- `location` varchar(30),
- PRIMARY KEY (`poolID`),
- KEY `groupID` (`groupID`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;
-
-CREATE TABLE IF NOT EXISTS `pbs_client` (
- `clientID` int(11) NOT NULL AUTO_INCREMENT,
- `groupID` int(11) NOT NULL,
- `macadress` varchar(17) NOT NULL,
- `hardwarehash` varchar(32),
- `ip` varchar(15) NOT NULL,
- `ip6` varchar(45),
- `created` int(15),
- PRIMARY KEY (`clientID`),
- KEY `groupID` (`groupID`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;
-
-CREATE TABLE IF NOT EXISTS `pbs_poolentries` (
- `poolentriesID` INT NOT NULL AUTO_INCREMENT,
- `poolID` int(11) NOT NULL,
- `clientID` int(11) NOT NULL,
- PRIMARY KEY (`poolentriesID`),
- KEY `poolID` (`poolID`),
- KEY `clientID` (`clientID`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;
-
-- Constraints
-ALTER TABLE `pbs_config`
- ADD CONSTRAINT `pbs_config_ibfk` FOREIGN KEY (`bootosID`) REFERENCES `pbs_bootos` (`bootosID`) ON DELETE CASCADE;
-
-ALTER TABLE `pbs_poolentries`
- ADD CONSTRAINT `pbs_poolentries_ibfk_1` FOREIGN KEY (`poolID`) REFERENCES `pbs_pool` (`poolID`) ON DELETE CASCADE,
- ADD CONSTRAINT `pbs_poolentries_ibfk_2` FOREIGN KEY (`clientID`) REFERENCES `pbs_client` (`clientID`) ON DELETE CASCADE;
-
ALTER TABLE `poolctrl_eventreport`
ADD CONSTRAINT `pbs_eventreport_eventidC` FOREIGN KEY (`eventID`) REFERENCES `poolctrl_event` (`eventID`) ON DELETE CASCADE,
ADD CONSTRAINT `pbs_eventreport_typeidC` FOREIGN KEY (`type`) REFERENCES `poolctrl_runningtype` (`runningtypeID`) ON DELETE CASCADE;
@@ -165,6 +90,8 @@ ALTER TABLE `poolctrl_event`
ADD CONSTRAINT `poolctrl_event_startC` CHECK (start > CURRENT_TIMESTAMP()),
ADD CONSTRAINT `poolctrl_event_endC` CHECK (end > start);
+-- Insert Data
+
-- Adding eventcategories
INSERT INTO `poolctrl_eventcategory` (`eventcategoryID`, `title`, `color`) VALUES
(1, 'Lecture', 'green'),