-- phpMyAdmin SQL Dump
-- version 4.7.0
-- https://www.phpmyadmin.net/
--
-- Host: diemanu.lima-db.de:3306
-- Erstellungszeit: 26. Jul 2017 um 14:19
-- Server-Version: 5.6.34-79.1-log
-- PHP-Version: 5.6.31

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
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 utf8mb4 */;

--
-- Datenbank: `db_187920_3`
--
CREATE DATABASE IF NOT EXISTS `db_187920_3` DEFAULT CHARACTER SET latin1 COLLATE latin1_german1_ci;
USE `db_187920_3`;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `Abwandlungen`
--

CREATE TABLE `Abwandlungen` (
  `ID_Abw` int(11) NOT NULL,
  `Abwandlung` varchar(255) COLLATE latin1_german1_ci NOT NULL COMMENT 'A-Linie, Vokuhila, Langarm,...'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `Designer`
--

CREATE TABLE `Designer` (
  `ID_Designer` int(11) NOT NULL,
  `Designer` varchar(255) COLLATE latin1_german1_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;

--
-- Daten für Tabelle `Designer`
--

INSERT INTO `Designer` (`ID_Designer`, `Designer`) VALUES
(1, 'Pattydoo'),
(2, 'Hamburgerliebe'),
(3, 'Lolletroll'),
(4, 'leni pepunkt'),
(5, 'Lybstes'),
(6, 'Näähglück'),
(7, 'Fadenkäfer'),
(8, 'textilsucht'),
(9, 'nEmadA'),
(10, 'So pattern'),
(11, 'mooibymama'),
(12, 'Romy Nähwerk'),
(13, 'Saba Style'),
(14, 'Drei eMs'),
(15, 'Yva R.'),
(16, 'Sachsenmuddi'),
(17, 'Schnittgeflüster'),
(18, 'TINAlisa'),
(19, 'Virginie'),
(20, 'Rockerbuben'),
(21, 'sisterMAG'),
(22, 'Schneidern nähen'),
(23, 'So sew easy'),
(24, 'Goldkrönchen'),
(25, 'Le Krimi'),
(26, 'Erbsünde'),
(27, 'DaWanda'),
(28, 'Sara & Julez'),
(29, 'MoiraLita'),
(30, 'Lillestoff'),
(31, 'klecks MACS'),
(32, 'Lilabrombeerwölkchen'),
(33, 'Pech & Schwefel'),
(34, 'Crafthabit'),
(35, 'Konfetti'),
(36, 'Anni Nanni'),
(37, 'Edel Books Verlag'),
(38, 'Mrs Schablona'),
(39, 'Lin-Kim'),
(40, 'Lorena Buck'),
(41, 'Prince and Princess'),
(42, 'My Image'),
(43, 'Bernina'),
(44, 'made for motti'),
(45, 'Frau Ninchen'),
(46, 'mamili1910'),
(47, 'Piranhakids'),
(48, 'Prülla'),
(49, 'Schnittchen'),
(50, 'Sewera'),
(51, 'verflixt und zugenäht'),
(52, 'Feefeefashion'),
(53, 'Freestyle Rocker'),
(54, 'Lekala'),
(55, 'muckelie'),
(56, 'Annas Country'),
(57, 'Mamahoch2'),
(58, 'Follow Me Design'),
(59, 'Tites Mains'),
(60, 'Maria Denmark'),
(61, 'Mialuna'),
(62, 'Tragmal'),
(63, 'Jojolino'),
(64, 'PiexSu'),
(65, 'Maluri'),
(66, 'addiek'),
(67, 'Simply JANuARy'),
(68, 'Hedi'),
(69, 'sew desu ne'),
(70, 'Min Ziari'),
(71, 'Saba Style'),
(72, 'Montag'),
(73, 'Lilawieliebe'),
(74, 'Shesmile'),
(75, 'Schnittenliebe'),
(76, 'Im sew happy'),
(77, 'Traumfaden Werkstatt'),
(78, 'Kunst und MArkt'),
(79, 'Farbenmix'),
(80, 'Stoffe.de'),
(81, 'Haus mit dem Rosensofa'),
(82, 'Kreativlabor Berlin'),
(83, 'Minaa'),
(84, 'ubidu'),
(85, 'The Inspired Wren'),
(86, 'lillyella'),
(87, 'Lenemenemuh'),
(88, 'Schnabelina'),
(89, 'Lapika'),
(90, 'liveit loveit makeit'),
(91, 'Tikata'),
(92, 'DIY Eule'),
(93, 'Stoffperlen'),
(94, 'Two Pretty Poppets'),
(95, 'Frau Scheiner'),
(96, 'The Inspired Wren'),
(97, 'Liebedinge'),
(98, 'Initiative Handarbeit'),
(99, 'Unikat'),
(100, 'Steffi Falk'),
(101, 'two sew'),
(102, 'Sew Simple'),
(103, 'Sperling'),
(104, 'be.geistert'),
(105, 'Schwalbenliebe'),
(106, 'Socken die Rocken'),
(107, 'M Do & B'),
(108, 'Dots Designs'),
(109, 'Lindaloves'),
(110, 'Schniggschnag'),
(111, 'Cherry Picking'),
(112, 'Nähfrosch'),
(113, 'Makerist');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `employee_table`
--

CREATE TABLE `employee_table` (
  `userName` varchar(225) COLLATE latin1_bin DEFAULT NULL,
  `userProfession` varchar(225) COLLATE latin1_bin DEFAULT NULL,
  `userPic` varchar(225) COLLATE latin1_bin DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_bin;

--
-- Daten für Tabelle `employee_table`
--

INSERT INTO `employee_table` (`userName`, `userProfession`, `userPic`) VALUES
('dieMAnu', 'chef', '97476.jpg'),
('bla', 'nix', '83039.jpg'),
('bla', 'nix', '289369.jpg');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `Farbe`
--

CREATE TABLE `Farbe` (
  `ID_Farbe` int(11) NOT NULL,
  `Farbe` varchar(255) COLLATE latin1_german1_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;

--
-- Daten für Tabelle `Farbe`
--

INSERT INTO `Farbe` (`ID_Farbe`, `Farbe`) VALUES
(1, '#aa0000'),
(2, 'blau');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `Groesse`
--

CREATE TABLE `Groesse` (
  `ID_Groesse` int(11) NOT NULL,
  `Groesse` varchar(100) COLLATE latin1_german1_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `Kategorie`
--

CREATE TABLE `Kategorie` (
  `ID_Kat` int(11) NOT NULL,
  `Kategorie` varchar(255) COLLATE latin1_german1_ci NOT NULL COMMENT 'Frauen, Männer, Taschen, ...'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `Material`
--

CREATE TABLE `Material` (
  `ID_Material` int(11) NOT NULL,
  `Faser` varchar(255) CHARACTER SET utf8 COLLATE utf8_german2_ci NOT NULL COMMENT 'Baumwolle, Polyester, ...'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;

--
-- Daten für Tabelle `Material`
--

INSERT INTO `Material` (`ID_Material`, `Faser`) VALUES
(1, 'Baumwolle'),
(2, 'Elasthan'),
(3, 'Baumwollsatin'),
(4, 'Denim Slub Stretch'),
(5, 'Feinstrick'),
(6, 'Fleece'),
(7, 'Jersey'),
(8, 'Kunstleder'),
(9, 'Kuschelsweat'),
(10, 'Leinen'),
(11, 'Lycra'),
(12, 'Polyester'),
(13, 'Polyethylen'),
(14, 'Punta di Roma'),
(15, 'Sommersweat'),
(16, 'Spitze'),
(17, 'Styvlin'),
(18, 'Tüll'),
(19, 'Viskose'),
(20, 'Wasserdicht'),
(21, 'Wolle');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `Materialverbrauch`
--

CREATE TABLE `Materialverbrauch` (
  `ID_Verbrauch` int(11) NOT NULL,
  `Verbrauch` decimal(10,0) NOT NULL,
  `Material` int(11) NOT NULL COMMENT 'ID-Material',
  `Groesse` tinyint(4) NOT NULL COMMENT 'ID-Groesse',
  `Schnittmuster` int(11) NOT NULL COMMENT 'ID-Schnittmuster'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `Nutzung`
--

CREATE TABLE `Nutzung` (
  `ID_Nutz` int(11) NOT NULL,
  `Nutzung` varchar(255) COLLATE latin1_german1_ci NOT NULL COMMENT 'privat, gewerblich, ...'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `Schnittmuster`
--

CREATE TABLE `Schnittmuster` (
  `ID_Schnitt` int(11) NOT NULL,
  `Name` varchar(255) COLLATE latin1_german1_ci NOT NULL,
  `Designer` int(11) NOT NULL,
  `Groessen` varchar(255) COLLATE latin1_german1_ci DEFAULT NULL COMMENT 'ID-Groessen',
  `Schnittteile` tinyint(4) DEFAULT NULL,
  `Materialvorschlag` int(11) DEFAULT NULL,
  `Abwandlungen` smallint(6) DEFAULT NULL COMMENT 'ID-Abwandlungen',
  `Bild` varchar(255) COLLATE latin1_german1_ci DEFAULT NULL,
  `Kategorie` smallint(6) DEFAULT NULL COMMENT 'ID-Kategorie',
  `Materialverbrauch` smallint(6) DEFAULT NULL COMMENT 'ID-Materialverbrauch',
  `Nutzung` tinyint(4) DEFAULT NULL COMMENT 'ID-Nutzung',
  `Nahtzugabe` float DEFAULT NULL COMMENT 'enthaltene NZ'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;

--
-- Daten für Tabelle `Schnittmuster`
--

INSERT INTO `Schnittmuster` (`ID_Schnitt`, `Name`, `Designer`, `Groessen`, `Schnittteile`, `Materialvorschlag`, `Abwandlungen`, `Bild`, `Kategorie`, `Materialverbrauch`, `Nutzung`, `Nahtzugabe`) VALUES
(1, 'Beanie Mütze', 1, '', 0, 0, 0, '', 0, 0, 0, 0),
(2, 'Jersey Beanie', 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(3, 'Mütze Toni', 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4, 'Mützen.schal', 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(5, 'Schlupfmütze', 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(6, 'Wellenmütze', 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(7, 'Boyfriend Hose', 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(8, 'Pamina', 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(9, 'Kinderhose Steppo', 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(10, 'Babyhose RAS', 112, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(11, 'Dinah Lady', 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(12, 'Girlfriend', 11, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(13, 'Leggings Essi', 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(14, 'Leggins Cathy', 12, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(15, 'Mama Marlene', 13, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(16, 'Seya', 14, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(17, 'Sommerhose Flotte Beinfreiheit', 15, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(18, 'Trilümm', 16, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(19, 'Velara', 17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(20, 'Velara Overall', 17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(21, 'Big Leg Love', 9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(22, 'Damenhose RAS', 112, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(23, 'Blazer', 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(24, 'Chill.Jacke', 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(25, 'Jape', 18, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(26, 'Ladies kunterbunter Jackenwahnsinn', 19, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(27, 'Sweatjacke für Damen', 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(28, 'Sweatjacke für Herren', 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(29, 'Viktor', 20, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(30, 'Blazer', 21, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(31, 'Cardigan', 22, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(32, 'Clarice', 17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(33, 'Easy Long Cardigan', 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(34, 'Flekaloo', 24, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(35, 'Hazel', 25, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(36, 'Jacke Ira', 26, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(37, 'Jedi Robe', 27, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(38, 'La Jazida', 17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(39, 'Mr Naveen', 28, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(40, 'Nara', 29, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(41, 'Neesha', 28, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(42, 'Regenparka', 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(43, 'Strickjacke Halja', 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(44, 'The Hoodie', 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(45, 'Blowing up 4 me', 31, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(46, 'Bohemian Summer', 32, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(47, 'Fannikleid', 33, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(48, 'Faux Wrap Dress', 34, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(49, 'Jenny Curvy Flair', 18, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(50, 'Jenny Flair', 18, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(51, 'Kleid Aito', 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(52, 'Evchen', 35, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(53, 'Rainbow for me', 31, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(54, 'Rock Nappi', 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(55, 'Tellerrock', 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(56, 'Wear Everywhere Dress', 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(57, 'Winterhude', 33, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(58, '30 Minute Skirt', 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(59, 'Anni Nanni Kleid', 36, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(60, 'Ärmelloses Kleid', 37, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(61, 'Beachdress', 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(62, 'Brief encounter dress', 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(63, 'Cross My Heart Dress', 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(64, 'Empire of the sun dress', 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(65, 'Enya', 29, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(66, 'Fit And Flare Dress', 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(67, 'Flouncy Bouncy Skirt', 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(68, 'Gathered Summer Skirt', 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(69, 'Graffiti Dress', 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(70, 'Jersey Rock', 38, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(71, 'Jerseyrock Lisa', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(72, 'Kezia', 17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(73, 'Kleid Eva', 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(74, 'Lady Sweat Skirt', 39, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(75, 'Maxi Skirt', 40, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(76, 'Mittelalterkleid', 41, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(77, 'Pam', 42, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(78, 'Perfect For Work Dress', 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(79, 'Sarah', 42, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(80, 'Simple Summer Skirt', 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(81, 'Sommerkleid', 43, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(82, 'Sommerkleid', 44, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(83, 'Two Become One Dress', 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(84, 'Wrap Dress', 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(85, 'Wrap Skirt', 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(86, 'Big Poldi', 45, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(87, 'Henning', 46, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(88, 'Hennja', 46, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(89, 'La Silla', 17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(90, 'Mr Klassik', 35, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(91, 'Mrs Klassik', 35, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(92, 'Sunny Boy', 47, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(93, 'Alice', 48, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(94, 'Catrin', 49, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(95, 'Cosmo', 29, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(96, 'Co-Z Men', 50, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(97, 'Co-Z Woman', 50, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(98, 'Fledermauspulli', 51, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(99, 'Hoody Damen', 36, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(100, 'Issy Kids', 52, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(101, 'Kalinda', 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(102, 'Kaloopu', 24, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(103, 'Oversized Pulli', 22, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(104, 'Pulli-Poncho Leyla', 53, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(105, 'Bellah', 48, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(106, 'Blouse', 54, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(107, '20 Minuten Shirt', 55, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(108, '20 Minuten Shirt Mini', 55, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(109, 'Fennja', 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(110, 'Lennja', 46, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(111, 'Malte', 20, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(112, 'Mutti Shirt', 56, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(113, 'Summer', 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(114, 'Twist Front Top', 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(115, 'Bohotunic', 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(116, 'Comfort Rockers', 57, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(117, 'Cross Over Shirt', 58, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(118, 'Draped Top Woven', 59, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(119, 'Easy Tunic', 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(120, 'Ebby', 17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(121, 'Efiara', 17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(122, 'Elsa', 42, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(123, 'It\'s A Wrap Top', 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(124, 'Jenny Curvy A-Line', 18, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(125, 'Jenny Curvy Line', 18, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(126, 'Jenny Line', 18, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(127, 'Kimono Tee', 60, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(128, 'Kimono Top', 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(129, 'La Beliana', 17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(130, 'Lady Rockers', 57, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(131, 'Lady Topas', 61, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(132, 'Lasca', 62, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(133, 'Longtop Luft & Liebe', 63, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(134, 'Maikika', 17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(135, 'Nameless Bluse', 50, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(136, 'On A Roll T-Shirt', 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(137, 'PinUp Pulli', 64, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(138, 'Raglan Shirt', 57, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(139, 'relax.me', 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(140, 'Sommertop Hetta', 65, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(141, 'Square Shirt', 12, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(142, 'Summer Drape Top', 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(143, 'The Natty Top', 66, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(144, 'Tunika Anki', 14, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(145, 'Unterhemd Alla', 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(146, 'Valerie', 113, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(147, 'Spielkartenhalter', 67, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(148, 'Patchwork Schal Jannika', 46, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(149, 'Baby Chaning Mat', 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(150, 'Badeponcho', 68, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(151, 'Bat Plush', 69, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(152, 'Conne', 70, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(153, 'Cool Fingers', 71, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(154, 'Easy Glove', 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(155, 'Fabric Covered Basket', 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(156, 'Federmappe mit Umschlag', 72, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(157, 'Fußsack für den Buggy', 73, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(158, 'Geldbeutel Frauenkram', 74, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(159, 'Geldbörse Kerstin', 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(160, 'Hängeutensilo', 75, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(161, 'Herbstgesang & Blättertanz', 63, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(162, 'Jumpsuit Chayenne', 42, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(163, 'Käferkissen Hildegard', 74, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(164, 'Kameragurt', 76, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(165, 'Kingerwagen Muff', 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(166, 'Kosmetik Trio', 77, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(167, 'Kulturbeutel Nina', 78, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(168, 'Kulturtasche Hanging 3', 74, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(169, 'Kuschelsack', 79, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(170, 'Leseknochen', 80, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(171, 'Leseknochen', 81, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(172, 'Loopschal Marlene', 82, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(173, 'Monster Lesezeichen', 83, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(174, 'Kinderwagenmuff', 81, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(175, 'Mutterpasshülle', 84, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(176, 'Overlock Matte', 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(177, 'Portemonnaie', 113, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(178, 'Stillschal', 56, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(179, 'Stulpen', 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(180, 'Tablet Case', 85, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(181, 'Undercover Maker Mat', 86, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(182, 'Utensilo', 79, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(183, 'Wellentuch', 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(184, 'Fold & Roll', 55, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(185, 'Kameratasche Klein Smilla', 82, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(186, 'Kameratasche Smilla', 82, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(187, 'Milana', 87, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(188, 'Schnabelina Bag', 88, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(189, 'Anti Pickpocket Bag', 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(190, 'Bibis Big Bag', 89, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(191, 'Bullibag', 73, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(192, 'Cablecosy', 90, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(193, 'Claire', 91, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(194, 'Cosmetic Bag', 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(195, 'Dufflebag Sporttasche', 92, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(196, 'Einkaufstasche', 93, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(197, 'Falten.Liebe', 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(198, 'Good To Go Messenger Bag', 94, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(199, 'Handy Purse Organizer', 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(200, 'Ice Ice Baby', 16, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(201, 'Kinderrucksack', 95, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(202, 'Leyla', 17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(203, 'Lined Tote Bag', 96, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(204, 'Messenger Bag', 92, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(205, 'October Lady', 97, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(206, 'Reisetasche', 98, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(207, 'SchickiMicki FlapBag', 99, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(208, 'Schwimmflügeltasche', 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(209, 'Sweet Big Bag', 101, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(210, 'Taco-Tasche', 102, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(211, 'Taco-Tasche mit 2 Wege-Zipper', 102, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(212, 'Tasche Hanna', 103, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(213, 'Zipper Top Tote', 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(214, 'Das für Untendrunter', 55, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(215, 'Höschenset Alice', 104, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(216, 'OHA Lingerie', 105, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(217, 'Sockenliebe', 106, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(218, 'Body', 50, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(219, 'Boxer Shorts', 107, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(220, 'Boxershort Levitas', 26, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(221, 'Boxershorts', 108, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(222, 'Bralette', 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(223, 'Damenslip', 110, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(224, 'Lace Undies', 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(225, 'Mens Pajamashorts', 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(226, 'Panty Eve', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(227, 'Sockenliebe', 111, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `Schnittmuster_Abwandlungen`
--

CREATE TABLE `Schnittmuster_Abwandlungen` (
  `ID_SA` int(11) NOT NULL,
  `ID_Schnitt` int(11) NOT NULL,
  `ID_Abw` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `Schnittmuster_Groesse`
--

CREATE TABLE `Schnittmuster_Groesse` (
  `ID_SG` int(11) NOT NULL,
  `ID_Schnitt` int(11) NOT NULL,
  `ID_Groesse` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `Schnittmuster_Kategorie`
--

CREATE TABLE `Schnittmuster_Kategorie` (
  `ID_SK` int(11) NOT NULL,
  `ID_Schnitt` int(11) NOT NULL,
  `ID_Kat` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `Schnittmuster_Material`
--

CREATE TABLE `Schnittmuster_Material` (
  `ID_SM` int(11) NOT NULL,
  `ID_Schnitt` int(11) NOT NULL,
  `ID_Fas` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `Schnittmuster_Nutzung`
--

CREATE TABLE `Schnittmuster_Nutzung` (
  `ID_SN` int(11) NOT NULL,
  `ID_Schnitt` int(11) NOT NULL,
  `ID_Nutz` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `tbl_users`
--

CREATE TABLE `tbl_users` (
  `userID` int(11) NOT NULL,
  `userName` varchar(20) NOT NULL,
  `userProfession` varchar(50) NOT NULL,
  `userPic` varchar(200) NOT NULL,
  `Bild` varchar(225) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Daten für Tabelle `tbl_users`
--

INSERT INTO `tbl_users` (`userID`, `userName`, `userProfession`, `userPic`, `Bild`) VALUES
(42, 'dwayne johnson', 'actor, wrestler', '380289.jpg', ''),
(43, 'justin bieber', 'singer', '995062.jpg', ''),
(44, 'chris hemsworth', 'actor', '98661.jpg', '531098.jpg'),
(41, 'john cena', 'wrestler', '200379.jpg', '');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `todo`
--

CREATE TABLE `todo` (
  `id` int(11) NOT NULL,
  `title` text COLLATE latin1_german1_ci NOT NULL,
  `description` text COLLATE latin1_german1_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;

--
-- Daten für Tabelle `todo`
--

INSERT INTO `todo` (`id`, `title`, `description`) VALUES
(1, 'Baumwolle', '90'),
(2, 'Polyester', '10');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `Vorrat`
--

CREATE TABLE `Vorrat` (
  `ID_Vorrat` int(11) NOT NULL,
  `Meter` float NOT NULL,
  `Gekauft` int(255) DEFAULT NULL COMMENT 'Stoffkeller, Stoffschwester,...',
  `Farbe` int(11) NOT NULL COMMENT 'ID-Farbe',
  `Notizen` varchar(2000) COLLATE latin1_german1_ci NOT NULL,
  `PPM` float NOT NULL COMMENT 'Preis pro Meter 9.95, 10.90,...',
  `Hersteller` varchar(255) COLLATE latin1_german1_ci NOT NULL COMMENT 'Swafing, Lilestoff,...',
  `Zertifizierung` int(11) DEFAULT NULL COMMENT 'ID-Zertifizierung',
  `Materialzusammensetzung` int(11) DEFAULT NULL COMMENT 'ID-Material',
  `Materialzusammensetzung_Prozent` tinyint(4) DEFAULT NULL COMMENT '5% {Elasthan},...',
  `Kaufdatum` date NOT NULL,
  `VB` smallint(6) NOT NULL COMMENT '145cm Volle breite,...',
  `Gewicht_qm` smallint(6) NOT NULL COMMENT '230g, 195g,...',
  `Beschreibung` varchar(2000) COLLATE latin1_german1_ci NOT NULL COMMENT 'Besonders kuscheliges Wellnessfleece, Ideal geeignet für Pullover, Decken, Schals, Hauben, zum füttern von Jacken, ...',
  `Bild` varchar(255) COLLATE latin1_german1_ci NOT NULL,
  `Waschanleitung` int(11) DEFAULT NULL COMMENT 'ID-Waschanleitung',
  `Farbcode` char(255) COLLATE latin1_german1_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;

--
-- Daten für Tabelle `Vorrat`
--

INSERT INTO `Vorrat` (`ID_Vorrat`, `Meter`, `Gekauft`, `Farbe`, `Notizen`, `PPM`, `Hersteller`, `Zertifizierung`, `Materialzusammensetzung`, `Materialzusammensetzung_Prozent`, `Kaufdatum`, `VB`, `Gewicht_qm`, `Beschreibung`, `Bild`, `Waschanleitung`, `Farbcode`) VALUES
(6, 10, 2, 0, '', 5, 'Swafing', NULL, NULL, NULL, '2017-07-25', 14, 130, '', '542897.jpg', NULL, '#00ff00'),
(7, 1, 6, 0, '', 10.9, 'bla', NULL, NULL, NULL, '2017-07-20', 150, 230, '', '881693.jpg', NULL, '#00ff40');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `Vorrat_Farbe`
--

CREATE TABLE `Vorrat_Farbe` (
  `ID_VF` int(11) NOT NULL,
  `ID_Vorrat` int(11) DEFAULT NULL,
  `ID_Farbe` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `Vorrat_Gekauft`
--

CREATE TABLE `Vorrat_Gekauft` (
  `ID_Gekauft` int(11) NOT NULL,
  `Name` varchar(255) COLLATE latin1_german1_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;

--
-- Daten für Tabelle `Vorrat_Gekauft`
--

INSERT INTO `Vorrat_Gekauft` (`ID_Gekauft`, `Name`) VALUES
(1, 'Driessenstoffen'),
(2, 'Eurostoffe'),
(3, 'Ikea'),
(4, 'Lieblingsstücke'),
(5, 'Lillestoff'),
(6, 'Mein Stoffmarkt'),
(7, 'Die Stoffecke'),
(8, 'Stoffkeller'),
(9, 'Stoffschwester'),
(10, 'Wien2002'),
(11, 'Biostoff');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `Vorrat_Material`
--

CREATE TABLE `Vorrat_Material` (
  `ID_VM` int(11) NOT NULL,
  `ID_Vorrat` int(11) DEFAULT NULL,
  `ID_Material` varchar(225) COLLATE latin1_german1_ci DEFAULT NULL,
  `Prozent` tinyint(4) NOT NULL COMMENT '5% Elasthan, ...'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;

--
-- Daten für Tabelle `Vorrat_Material`
--

INSERT INTO `Vorrat_Material` (`ID_VM`, `ID_Vorrat`, `ID_Material`, `Prozent`) VALUES
(6, 6, 'Baumwolle', 99),
(7, 6, 'Elasthan', 1),
(8, 7, 'Baumwolle', 85),
(9, 7, 'Lycra', 22);

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `Vorrat_Wasch`
--

CREATE TABLE `Vorrat_Wasch` (
  `ID_VW` int(11) NOT NULL,
  `ID_Vorrat` int(11) DEFAULT NULL,
  `ID_Wasch` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `Waschanleitung`
--

CREATE TABLE `Waschanleitung` (
  `ID_Wasch` int(11) NOT NULL,
  `Anleitung` varchar(255) CHARACTER SET utf8 COLLATE utf8_german2_ci NOT NULL COMMENT '30°, Handwäsche, nicht bleichen, ...'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;

--
-- Daten für Tabelle `Waschanleitung`
--

INSERT INTO `Waschanleitung` (`ID_Wasch`, `Anleitung`) VALUES
(1, '40°'),
(2, 'Wollwaschprogramm');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `WIP`
--

CREATE TABLE `WIP` (
  `ID_WIP` int(11) NOT NULL,
  `Schnittmuster` smallint(6) NOT NULL COMMENT 'ID-Schnittmuster',
  `Groesse` smallint(6) NOT NULL COMMENT 'ID-Groesse',
  `Gekauft` int(11) NOT NULL COMMENT 'Stoff gekauft',
  `Verwendet` int(11) NOT NULL COMMENT 'Stoff verwendet',
  `Sonstiges_Material` varchar(2000) COLLATE latin1_german1_ci NOT NULL COMMENT 'Klettverschluss, Reißverschluss,...',
  `Notizen` varchar(2000) COLLATE latin1_german1_ci NOT NULL,
  `Arbeitszeit` decimal(10,0) NOT NULL COMMENT 'in Stunden',
  `Bild` varchar(255) COLLATE latin1_german1_ci NOT NULL,
  `Schwierigkeitsgrad` tinyint(4) NOT NULL COMMENT '1-5'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `WIP_Gekauft`
--

CREATE TABLE `WIP_Gekauft` (
  `ID_WGe` int(11) NOT NULL,
  `ID_WIP` int(11) NOT NULL,
  `ID_Vorrat` int(11) NOT NULL COMMENT 'Stoff geplant',
  `ID_Verwendet` int(11) NOT NULL COMMENT 'Stoff verwendet'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `WIP_Groesse`
--

CREATE TABLE `WIP_Groesse` (
  `ID_WG` int(11) NOT NULL,
  `ID_WIP` int(11) NOT NULL,
  `ID_Groesse` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `Zertifizierung`
--

CREATE TABLE `Zertifizierung` (
  `ID_Zert` int(11) NOT NULL,
  `Zertifierung` varchar(255) COLLATE latin1_german1_ci NOT NULL COMMENT 'Öko-Tex, ...'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;

--
-- Indizes der exportierten Tabellen
--

--
-- Indizes für die Tabelle `Abwandlungen`
--
ALTER TABLE `Abwandlungen`
  ADD PRIMARY KEY (`ID_Abw`);

--
-- Indizes für die Tabelle `Designer`
--
ALTER TABLE `Designer`
  ADD PRIMARY KEY (`ID_Designer`);

--
-- Indizes für die Tabelle `Farbe`
--
ALTER TABLE `Farbe`
  ADD PRIMARY KEY (`ID_Farbe`);

--
-- Indizes für die Tabelle `Groesse`
--
ALTER TABLE `Groesse`
  ADD PRIMARY KEY (`ID_Groesse`);

--
-- Indizes für die Tabelle `Kategorie`
--
ALTER TABLE `Kategorie`
  ADD PRIMARY KEY (`ID_Kat`);

--
-- Indizes für die Tabelle `Material`
--
ALTER TABLE `Material`
  ADD PRIMARY KEY (`ID_Material`) USING BTREE;

--
-- Indizes für die Tabelle `Materialverbrauch`
--
ALTER TABLE `Materialverbrauch`
  ADD PRIMARY KEY (`ID_Verbrauch`);

--
-- Indizes für die Tabelle `Nutzung`
--
ALTER TABLE `Nutzung`
  ADD PRIMARY KEY (`ID_Nutz`);

--
-- Indizes für die Tabelle `Schnittmuster`
--
ALTER TABLE `Schnittmuster`
  ADD PRIMARY KEY (`ID_Schnitt`);

--
-- Indizes für die Tabelle `Schnittmuster_Abwandlungen`
--
ALTER TABLE `Schnittmuster_Abwandlungen`
  ADD PRIMARY KEY (`ID_SA`),
  ADD KEY `ID_Schnitt` (`ID_Schnitt`),
  ADD KEY `ID_Abw` (`ID_Abw`);

--
-- Indizes für die Tabelle `Schnittmuster_Groesse`
--
ALTER TABLE `Schnittmuster_Groesse`
  ADD PRIMARY KEY (`ID_SG`),
  ADD KEY `ID_Schnitt` (`ID_Schnitt`),
  ADD KEY `ID_Groesse` (`ID_Groesse`);

--
-- Indizes für die Tabelle `Schnittmuster_Kategorie`
--
ALTER TABLE `Schnittmuster_Kategorie`
  ADD PRIMARY KEY (`ID_SK`),
  ADD KEY `ID_Schnitt` (`ID_Schnitt`),
  ADD KEY `ID_Kat` (`ID_Kat`);

--
-- Indizes für die Tabelle `Schnittmuster_Material`
--
ALTER TABLE `Schnittmuster_Material`
  ADD PRIMARY KEY (`ID_SM`),
  ADD KEY `ID_Schnitt` (`ID_Schnitt`),
  ADD KEY `ID_Fas` (`ID_Fas`);

--
-- Indizes für die Tabelle `Schnittmuster_Nutzung`
--
ALTER TABLE `Schnittmuster_Nutzung`
  ADD PRIMARY KEY (`ID_SN`),
  ADD KEY `ID_Schnitt` (`ID_Schnitt`),
  ADD KEY `ID_Nutz` (`ID_Nutz`);

--
-- Indizes für die Tabelle `tbl_users`
--
ALTER TABLE `tbl_users`
  ADD PRIMARY KEY (`userID`);

--
-- Indizes für die Tabelle `todo`
--
ALTER TABLE `todo`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `Vorrat`
--
ALTER TABLE `Vorrat`
  ADD PRIMARY KEY (`ID_Vorrat`),
  ADD KEY `Zertifizierung` (`Zertifizierung`),
  ADD KEY `Materialzusammensetzung` (`Materialzusammensetzung`),
  ADD KEY `Waschanleitung` (`Waschanleitung`);

--
-- Indizes für die Tabelle `Vorrat_Farbe`
--
ALTER TABLE `Vorrat_Farbe`
  ADD PRIMARY KEY (`ID_VF`),
  ADD KEY `ID_Vorrat` (`ID_Vorrat`),
  ADD KEY `ID_Farbe` (`ID_Farbe`);

--
-- Indizes für die Tabelle `Vorrat_Gekauft`
--
ALTER TABLE `Vorrat_Gekauft`
  ADD PRIMARY KEY (`ID_Gekauft`);

--
-- Indizes für die Tabelle `Vorrat_Material`
--
ALTER TABLE `Vorrat_Material`
  ADD PRIMARY KEY (`ID_VM`),
  ADD KEY `ID_Vorrat` (`ID_Vorrat`),
  ADD KEY `ID_Material` (`ID_Material`);

--
-- Indizes für die Tabelle `Vorrat_Wasch`
--
ALTER TABLE `Vorrat_Wasch`
  ADD PRIMARY KEY (`ID_VW`),
  ADD KEY `ID_Vorrat` (`ID_Vorrat`),
  ADD KEY `ID_Wasch` (`ID_Wasch`);

--
-- Indizes für die Tabelle `Waschanleitung`
--
ALTER TABLE `Waschanleitung`
  ADD PRIMARY KEY (`ID_Wasch`);

--
-- Indizes für die Tabelle `WIP`
--
ALTER TABLE `WIP`
  ADD PRIMARY KEY (`ID_WIP`);

--
-- Indizes für die Tabelle `WIP_Gekauft`
--
ALTER TABLE `WIP_Gekauft`
  ADD PRIMARY KEY (`ID_WGe`),
  ADD KEY `ID_WIP` (`ID_WIP`),
  ADD KEY `ID_Vorrat` (`ID_Vorrat`),
  ADD KEY `ID_Verwendet` (`ID_Verwendet`);

--
-- Indizes für die Tabelle `WIP_Groesse`
--
ALTER TABLE `WIP_Groesse`
  ADD PRIMARY KEY (`ID_WG`),
  ADD KEY `ID_WIP` (`ID_WIP`),
  ADD KEY `ID_Groesse` (`ID_Groesse`);

--
-- Indizes für die Tabelle `Zertifizierung`
--
ALTER TABLE `Zertifizierung`
  ADD PRIMARY KEY (`ID_Zert`);

--
-- AUTO_INCREMENT für exportierte Tabellen
--

--
-- AUTO_INCREMENT für Tabelle `Abwandlungen`
--
ALTER TABLE `Abwandlungen`
  MODIFY `ID_Abw` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT für Tabelle `Designer`
--
ALTER TABLE `Designer`
  MODIFY `ID_Designer` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=114;
--
-- AUTO_INCREMENT für Tabelle `Farbe`
--
ALTER TABLE `Farbe`
  MODIFY `ID_Farbe` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT für Tabelle `Groesse`
--
ALTER TABLE `Groesse`
  MODIFY `ID_Groesse` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT für Tabelle `Kategorie`
--
ALTER TABLE `Kategorie`
  MODIFY `ID_Kat` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT für Tabelle `Material`
--
ALTER TABLE `Material`
  MODIFY `ID_Material` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;
--
-- AUTO_INCREMENT für Tabelle `Materialverbrauch`
--
ALTER TABLE `Materialverbrauch`
  MODIFY `ID_Verbrauch` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT für Tabelle `Nutzung`
--
ALTER TABLE `Nutzung`
  MODIFY `ID_Nutz` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT für Tabelle `Schnittmuster`
--
ALTER TABLE `Schnittmuster`
  MODIFY `ID_Schnitt` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=228;
--
-- AUTO_INCREMENT für Tabelle `Schnittmuster_Abwandlungen`
--
ALTER TABLE `Schnittmuster_Abwandlungen`
  MODIFY `ID_SA` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT für Tabelle `Schnittmuster_Groesse`
--
ALTER TABLE `Schnittmuster_Groesse`
  MODIFY `ID_SG` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT für Tabelle `Schnittmuster_Kategorie`
--
ALTER TABLE `Schnittmuster_Kategorie`
  MODIFY `ID_SK` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT für Tabelle `Schnittmuster_Material`
--
ALTER TABLE `Schnittmuster_Material`
  MODIFY `ID_SM` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT für Tabelle `Schnittmuster_Nutzung`
--
ALTER TABLE `Schnittmuster_Nutzung`
  MODIFY `ID_SN` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT für Tabelle `tbl_users`
--
ALTER TABLE `tbl_users`
  MODIFY `userID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51;
--
-- AUTO_INCREMENT für Tabelle `todo`
--
ALTER TABLE `todo`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT für Tabelle `Vorrat`
--
ALTER TABLE `Vorrat`
  MODIFY `ID_Vorrat` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT für Tabelle `Vorrat_Farbe`
--
ALTER TABLE `Vorrat_Farbe`
  MODIFY `ID_VF` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT für Tabelle `Vorrat_Gekauft`
--
ALTER TABLE `Vorrat_Gekauft`
  MODIFY `ID_Gekauft` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT für Tabelle `Vorrat_Material`
--
ALTER TABLE `Vorrat_Material`
  MODIFY `ID_VM` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT für Tabelle `Vorrat_Wasch`
--
ALTER TABLE `Vorrat_Wasch`
  MODIFY `ID_VW` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT für Tabelle `Waschanleitung`
--
ALTER TABLE `Waschanleitung`
  MODIFY `ID_Wasch` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT für Tabelle `WIP`
--
ALTER TABLE `WIP`
  MODIFY `ID_WIP` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT für Tabelle `WIP_Gekauft`
--
ALTER TABLE `WIP_Gekauft`
  MODIFY `ID_WGe` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT für Tabelle `WIP_Groesse`
--
ALTER TABLE `WIP_Groesse`
  MODIFY `ID_WG` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT für Tabelle `Zertifizierung`
--
ALTER TABLE `Zertifizierung`
  MODIFY `ID_Zert` int(11) NOT NULL AUTO_INCREMENT;
--
-- Constraints der exportierten Tabellen
--

--
-- Constraints der Tabelle `Schnittmuster_Abwandlungen`
--
ALTER TABLE `Schnittmuster_Abwandlungen`
  ADD CONSTRAINT `Schnittmuster_Abwandlungen_ibfk_1` FOREIGN KEY (`ID_Schnitt`) REFERENCES `Schnittmuster` (`ID_Schnitt`),
  ADD CONSTRAINT `Schnittmuster_Abwandlungen_ibfk_2` FOREIGN KEY (`ID_Abw`) REFERENCES `Abwandlungen` (`ID_Abw`);

--
-- Constraints der Tabelle `Schnittmuster_Groesse`
--
ALTER TABLE `Schnittmuster_Groesse`
  ADD CONSTRAINT `Schnittmuster_Groesse_ibfk_1` FOREIGN KEY (`ID_Schnitt`) REFERENCES `Schnittmuster` (`ID_Schnitt`),
  ADD CONSTRAINT `Schnittmuster_Groesse_ibfk_2` FOREIGN KEY (`ID_Groesse`) REFERENCES `Groesse` (`ID_Groesse`);

--
-- Constraints der Tabelle `Schnittmuster_Kategorie`
--
ALTER TABLE `Schnittmuster_Kategorie`
  ADD CONSTRAINT `Schnittmuster_Kategorie_ibfk_1` FOREIGN KEY (`ID_Schnitt`) REFERENCES `Schnittmuster` (`ID_Schnitt`),
  ADD CONSTRAINT `Schnittmuster_Kategorie_ibfk_2` FOREIGN KEY (`ID_Kat`) REFERENCES `Kategorie` (`ID_Kat`);

--
-- Constraints der Tabelle `Schnittmuster_Material`
--
ALTER TABLE `Schnittmuster_Material`
  ADD CONSTRAINT `Schnittmuster_Material_ibfk_1` FOREIGN KEY (`ID_Schnitt`) REFERENCES `Schnittmuster` (`ID_Schnitt`),
  ADD CONSTRAINT `Schnittmuster_Material_ibfk_2` FOREIGN KEY (`ID_Fas`) REFERENCES `Material` (`ID_Material`);

--
-- Constraints der Tabelle `Schnittmuster_Nutzung`
--
ALTER TABLE `Schnittmuster_Nutzung`
  ADD CONSTRAINT `Schnittmuster_Nutzung_ibfk_1` FOREIGN KEY (`ID_Schnitt`) REFERENCES `Schnittmuster` (`ID_Schnitt`),
  ADD CONSTRAINT `Schnittmuster_Nutzung_ibfk_2` FOREIGN KEY (`ID_Nutz`) REFERENCES `Nutzung` (`ID_Nutz`);

--
-- Constraints der Tabelle `Vorrat_Material`
--
ALTER TABLE `Vorrat_Material`
  ADD CONSTRAINT `Vorrat_Material_ibfk_1` FOREIGN KEY (`ID_Vorrat`) REFERENCES `Vorrat` (`ID_Vorrat`);

--
-- Constraints der Tabelle `Vorrat_Wasch`
--
ALTER TABLE `Vorrat_Wasch`
  ADD CONSTRAINT `Vorrat_Wasch_ibfk_1` FOREIGN KEY (`ID_Vorrat`) REFERENCES `Vorrat` (`ID_Vorrat`),
  ADD CONSTRAINT `Vorrat_Wasch_ibfk_2` FOREIGN KEY (`ID_Wasch`) REFERENCES `Waschanleitung` (`ID_Wasch`);

--
-- Constraints der Tabelle `WIP_Gekauft`
--
ALTER TABLE `WIP_Gekauft`
  ADD CONSTRAINT `WIP_Gekauft_ibfk_1` FOREIGN KEY (`ID_WIP`) REFERENCES `WIP` (`ID_WIP`),
  ADD CONSTRAINT `WIP_Gekauft_ibfk_2` FOREIGN KEY (`ID_Vorrat`) REFERENCES `Vorrat` (`ID_Vorrat`),
  ADD CONSTRAINT `WIP_Gekauft_ibfk_3` FOREIGN KEY (`ID_Verwendet`) REFERENCES `Vorrat` (`ID_Vorrat`);

--
-- Constraints der Tabelle `WIP_Groesse`
--
ALTER TABLE `WIP_Groesse`
  ADD CONSTRAINT `WIP_Groesse_ibfk_1` FOREIGN KEY (`ID_WIP`) REFERENCES `WIP` (`ID_WIP`),
  ADD CONSTRAINT `WIP_Groesse_ibfk_2` FOREIGN KEY (`ID_Groesse`) REFERENCES `Groesse` (`ID_Groesse`);
COMMIT;

/*!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 */;
