diff options
| author | Simon | 2011-03-21 10:57:32 +0100 |
|---|---|---|
| committer | Simon | 2011-03-21 10:57:32 +0100 |
| commit | 6311b5b8af2403e4da5beb2c369e535c55ebd19b (patch) | |
| tree | 4479a70b8b0164245f0d2adf0e77da4001f5cc20 | |
| parent | zfproject (diff) | |
| download | pbs2-6311b5b8af2403e4da5beb2c369e535c55ebd19b.tar.gz pbs2-6311b5b8af2403e4da5beb2c369e535c55ebd19b.tar.xz pbs2-6311b5b8af2403e4da5beb2c369e535c55ebd19b.zip | |
pbs.sql reihenfolge des einfügens korrigiert
| -rw-r--r-- | pbs.sql | 31 | ||||
| -rw-r--r-- | send-post.html | 6 |
2 files changed, 19 insertions, 18 deletions
@@ -182,7 +182,22 @@ ALTER TABLE `pbs_bootmenuentries` ADD CONSTRAINT `pbs_bootmenuentries_ibfk_3` FOREIGN KEY (`configID`) REFERENCES `pbs_config` (`configID`) ON DELETE SET NULL, ADD CONSTRAINT `pbs_bootmenuentries_ibfk_4` FOREIGN KEY (`kcl`) REFERENCES `pbs_bootos` (`defaultkcl`) ON DELETE CASCADE, ADD CONSTRAINT `pbs_bootmenuentries_ibfk_5` FOREIGN KEY (`kcl`) REFERENCES `pbs_bootos` (`defaultkcl`) ON UPDATE CASCADE; - + +CREATE TABLE IF NOT EXISTS `pbs_preboot` ( + `prebootID` int(11) NOT NULL AUTO_INCREMENT, + `title` varchar(30) NOT NULL, + `membershipID` int(11), + `groupID` int(11) NOT NULL, + `path_preboot` varchar(30) NOT NULL, + PRIMARY KEY (`prebootID`), + KEY `membershipID` (`membershipID`), + KEY `groupID` (`groupID`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; + +ALTER TABLE `pbs_preboot` + ADD CONSTRAINT `pbs_preboot_ibfk_1` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`) ON DELETE SET NULL, + ADD CONSTRAINT `pbs_preboot_ibfk_2` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE; + CREATE TABLE IF NOT EXISTS `pbs_bootiso` ( `bootisoID` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(30) NOT NULL, @@ -203,20 +218,6 @@ ALTER TABLE `pbs_bootiso` ADD CONSTRAINT `pbs_bootiso_ibfk_2` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE, ADD CONSTRAINT `pbs_bootiso_ibfk_3` FOREIGN KEY (`prebootID`) REFERENCES `pbs_preboot` (`prebootID`) ON DELETE CASCADE; -CREATE TABLE IF NOT EXISTS `pbs_preboot` ( - `prebootID` int(11) NOT NULL AUTO_INCREMENT, - `title` varchar(30) NOT NULL, - `membershipID` int(11), - `groupID` int(11) NOT NULL, - `path_preboot` varchar(30) NOT NULL, - PRIMARY KEY (`prebootID`), - KEY `membershipID` (`membershipID`), - KEY `groupID` (`groupID`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; - -ALTER TABLE `pbs_preboot` - ADD CONSTRAINT `pbs_preboot_ibfk_1` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`) ON DELETE SET NULL, - ADD CONSTRAINT `pbs_preboot_ibfk_2` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE; CREATE TABLE IF NOT EXISTS `pbs_client` ( `clientID` int(11) NOT NULL AUTO_INCREMENT, diff --git a/send-post.html b/send-post.html index d657552..fd5752d 100644 --- a/send-post.html +++ b/send-post.html @@ -7,8 +7,8 @@ </style> <body> <fieldset> - <legend>localhost</legend> - <form action='http://localhost/' method='post'> + <legend>http://pbs2.local/</legend> + <form action='http://pbs2.local/' method='post'> <label>BootisoID</label> <input type='text' name='bootisoID' value='1'></br> <label>Mac</label> @@ -19,7 +19,7 @@ </form> </fieldset> <fieldset> - <legend>localhost:81</legend> + <legend>http://localhost:81/</legend> <form action='http://localhost:81/' method='post'> <label>BootisoID</label> <input type='text' name='bootisoID' value='1'></br> |