Manipulate Database

From de1de1d9de9a3b3945db4b87f045f6e3288244c0 Mon Sep 17 00:00:00 2001 From: Stefan Suhren Date: Mon, 13 Apr 2015 13:35:23 +0200 Subject: 4th task sql and forms --- Aufgabe04/catalog.sql | 128 ++++++++++++++++++++++++++++++++++++++++++++++++++ Aufgabe04/index.html | 37 +++++++++++++++ 2 files changed, 165 insertions(+) create mode 100644 Aufgabe04/catalog.sql create mode 100644 Aufgabe04/index.html (limited to 'Aufgabe04') diff --git a/Aufgabe04/catalog.sql b/Aufgabe04/catalog.sql new file mode 100644 index 0000000..a149a4f --- /dev/null +++ b/Aufgabe04/catalog.sql @@ -0,0 +1,128 @@ +-- phpMyAdmin SQL Dump +-- version 4.4.1.1 +-- http://www.phpmyadmin.net +-- +-- Host: localhost +-- Erstellungszeit: 13. Apr 2015 um 11:33 +-- Server-Version: 10.0.17-MariaDB-log +-- PHP-Version: 5.6.7 + +SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; +SET time_zone = "+00:00"; + + +/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; +/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; +/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; +/*!40101 SET NAMES utf8 */; + +-- +-- Datenbank: `catalog` +-- + +-- -------------------------------------------------------- + +-- +-- Tabellenstruktur für Tabelle `category` +-- + +CREATE TABLE IF NOT EXISTS `category` ( + `id` int(11) NOT NULL, + `name` varchar(100) NOT NULL, + `description` varchar(1000) DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Tabellenstruktur für Tabelle `product` +-- + +CREATE TABLE IF NOT EXISTS `product` ( + `id` int(11) NOT NULL, + `name` varchar(100) NOT NULL, + `price` int(11) NOT NULL, + `width` int(11) NOT NULL, + `height` int(11) NOT NULL, + `description` varchar(1000) DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Tabellenstruktur für Tabelle `product_category` +-- + +CREATE TABLE IF NOT EXISTS `product_category` ( + `product_id` int(11) NOT NULL, + `category_id` int(11) NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Tabellenstruktur für Tabelle `user` +-- + +CREATE TABLE IF NOT EXISTS `user` ( + `username` varchar(100) NOT NULL, + `password` char(40) NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Indizes der exportierten Tabellen +-- + +-- +-- Indizes für die Tabelle `category` +-- +ALTER TABLE `category` + ADD PRIMARY KEY (`id`); + +-- +-- Indizes für die Tabelle `product` +-- +ALTER TABLE `product` + ADD PRIMARY KEY (`id`); + +-- +-- Indizes für die Tabelle `product_category` +-- +ALTER TABLE `product_category` + ADD PRIMARY KEY (`product_id`,`category_id`), + ADD KEY `category_id` (`category_id`); + +-- +-- Indizes für die Tabelle `user` +-- +ALTER TABLE `user` + ADD PRIMARY KEY (`username`); + +-- +-- AUTO_INCREMENT für exportierte Tabellen +-- + +-- +-- AUTO_INCREMENT für Tabelle `category` +-- +ALTER TABLE `category` + MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; +-- +-- AUTO_INCREMENT für Tabelle `product` +-- +ALTER TABLE `product` + MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; +-- +-- Constraints der exportierten Tabellen +-- + +-- +-- Constraints der Tabelle `product_category` +-- +ALTER TABLE `product_category` + ADD CONSTRAINT `product_category_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`), + ADD CONSTRAINT `product_category_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `product` (`id`); + +/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; +/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; +/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; diff --git a/Aufgabe04/index.html b/Aufgabe04/index.html new file mode 100644 index 0000000..38dbccb --- /dev/null +++ b/Aufgabe04/index.html @@ -0,0 +1,37 @@ + + + + +Manipulate Database + + + + + + + + + \ No newline at end of file -- cgit v1.2.3-70-g09d2

Product

Category

User