-- phpMyAdmin SQL Dump
-- version 4.4.14
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Jan 15, 2016 at 03:23 PM
-- Server version: 5.6.26
-- PHP Version: 5.6.12

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

--
-- Database: `stoffig`
--

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

--
-- Table structure for table `gebruiker`
--

CREATE TABLE IF NOT EXISTS `gebruiker` (
  `ID` int(11) NOT NULL,
  `Naam` varchar(100) NOT NULL DEFAULT 'Uw naam',
  `Wachtwoord` varchar(100) NOT NULL,
  `Email` varchar(200) NOT NULL,
  `Beschrijving` text NOT NULL,
  `Foto` varchar(200) NOT NULL DEFAULT 'default.png',
  `Admin` int(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `gebruiker`
--

INSERT INTO `gebruiker` (`ID`, `Naam`, `Wachtwoord`, `Email`, `Beschrijving`, `Foto`, `Admin`) VALUES
(1, 'Uw naam', '$2y$10$kE31i.7pll5Ag6ippoLsr.U.Vt/7KdhOhY4mTGrUzymwRfIt/1T6K', 'admin@admin.nl', '', 'default.png', 1),
(9, 'Uw naam', '$2y$10$hRQj79TH8Qa2GQbNcZgS/enth0uq68Nak.otWhfE46mVCsiipY9ZO', 'test1@test2.test3', '', 'default.png', 0),
(10, 'Uw naam', '$2y$10$x1JvX98QgQZ3OEnVtT1J4eUkxMjUlCZG64pLJgrCucx3nTu52p1UW', 'test0@test0.test0', '', 'default.png', 0),
(11, 'Uw naam', '$2y$10$IfsGFk6uDWMwqrqcu.26IOk8SQ0YF55U7JJJnAhNFBN.Ms0x.GC2a', 'test6@test6.test6', '', 'default.png', 0),
(12, 'Uw naam', '$2y$10$JDuj8y1pNsUHjhs.Q7DtAug2mIhLrKBHTY3M2TzM69wUdd2g6Tyn.', 'romanornr@gmail.com', '', 'default.png', 0),
(13, 'Uw naam', '$2y$10$VmnrJGJDf5N4Pqv4YD5OIOqZScuM809W1.jrdeaKblCPuGZgH0gAK', 'test3@test3.test3', '', 'default.png', 0),
(14, 'Uw naam', '$2y$10$/UDqoPhEIRDyzWuvRXKOkeSUJCEGB6/h1WyZ.0.MXZHM/9J3zIizS', 'test7@test7.test7', '', 'default.png', 0),
(15, 'Uw naam', '$2y$10$LPwtYCS5FJxCNtwE5KVFhONpIxjLkMrydqniFcKJnR17QU1KjgA0a', 'ik@live.com', '', 'default.png', 0);

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

--
-- Table structure for table `gereserveerd`
--

CREATE TABLE IF NOT EXISTS `gereserveerd` (
  `ID` int(11) NOT NULL,
  `StofID` int(11) NOT NULL,
  `GebruikerID` int(11) NOT NULL,
  `Meters` float NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `gereserveerd`
--

INSERT INTO `gereserveerd` (`ID`, `StofID`, `GebruikerID`, `Meters`) VALUES
(1, 1, 1, 3.46),
(10, 1, 2, 7.5);

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

--
-- Table structure for table `stoffen`
--

CREATE TABLE IF NOT EXISTS `stoffen` (
  `ID` int(11) NOT NULL,
  `Naam` varchar(500) NOT NULL,
  `Type` int(11) NOT NULL,
  `Meters` float NOT NULL,
  `Beschrijving` text NOT NULL,
  `Plaatje` varchar(200) NOT NULL DEFAULT 'default.jpg',
  `Prijs` float NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `stoffen`
--

INSERT INTO `stoffen` (`ID`, `Naam`, `Type`, `Meters`, `Beschrijving`, `Plaatje`, `Prijs`) VALUES
(1, 'Testing stof 1', 1, 18.78, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Curabitur lacinia felis leo, sed lobortis nibh egestas vitae. Nullam quis eros eros. Nam tellus est, eleifend vitae odio nec, cursus varius orci. Aenean aliquet nisl non lectus convallis lacinia. Curabitur in ante nunc. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Suspendisse gravida porttitor turpis et hendrerit. Integer et viverra diam, eget semper turpis. Fusce mi velit, vestibulum sed felis ac, imperdiet hendrerit nunc.\n\nMauris gravida egestas justo ut pulvinar. Nam porttitor velit nec risus fermentum facilisis. Curabitur porttitor egestas massa, vitae feugiat elit dignissim in. Interdum et malesuada fames ac ante ipsum primis in faucibus. Mauris dictum mollis dictum. Vestibulum bibendum imperdiet nulla nec aliquam. Maecenas ullamcorper enim non massa imperdiet, ac blandit odio lacinia. Aliquam ultricies, purus eu vestibulum faucibus, diam ex mollis tortor, ac finibus orci ex a dui. Proin auctor sollicitudin velit, non venenatis orci pretium eu. Praesent tristique imperdiet enim, nec feugiat massa lacinia eu. Sed feugiat, ligula eget tristique fermentum, felis eros venenatis erat, at fringilla mauris elit eu dolor. Nunc in hendrerit lectus. Aenean id velit tristique, vehicula diam in, viverra dolor. Nulla in sapien eu tortor dapibus molestie. Etiam nulla odio, facilisis nec maximus sit amet, luctus non sem. Fusce non metus lorem.\n\nVivamus pretium tellus et elit luctus facilisis. Cras in cursus lacus. Etiam sed felis fringilla, dictum felis in, congue orci. Nullam aliquet, purus eget accumsan tincidunt, lacus arcu faucibus odio, ut malesuada mauris enim ut tellus. Nulla ullamcorper ornare nisi nec luctus. Nam eu porttitor ligula, in bibendum urna. Nullam convallis sem ac velit ultrices, in feugiat orci ornare. Morbi ac eros lobortis, commodo ex a, tincidunt justo. Donec porttitor orci nisl, id pulvinar neque porta euismod. Duis nulla felis, tempor ac tempus laoreet, pulvinar lacinia risus. Nam pellentesque mi nec ex facilisis, nec tincidunt orci vulputate.\n\nSed dapibus, dolor a venenatis dignissim, ligula turpis molestie metus, id laoreet nunc eros eget ipsum. Morbi nulla augue, lobortis at erat et, tincidunt suscipit dui. Integer quis velit ac felis bibendum vulputate eget non mauris. Nullam mollis iaculis nulla, in mattis orci porttitor nec. Cras in velit lorem. Maecenas et porta tellus, vel vulputate neque. Interdum et malesuada fames ac ante ipsum primis in faucibus.\n\nQuisque arcu orci, congue eget enim vel, varius condimentum felis. Aliquam erat volutpat. Maecenas lacus neque, rutrum ac malesuada at, scelerisque quis metus. Pellentesque vulputate tellus in erat feugiat tempus. Nullam porta a metus et mollis. Quisque sagittis mi et molestie volutpat. Praesent eget tellus sit amet est consectetur dapibus ut in dui. Nullam diam elit, sodales eu nulla non, iaculis molestie sapien. In ornare nulla at neque fringilla, ac consectetur ipsum facilisis. Praesent eu facilisis odio. Quisque mollis gravida urna ac ornare. Etiam vitae magna accumsan, ornare est sed, semper tortor. Nam sagittis pretium tortor, sit amet malesuada risus semper et. Curabitur efficitur dui vitae enim accumsan egestas.', 'default.jpg', 17.25),
(2, 'Testing stof 2', 3, 12.42, 'Test', 'default.jpg', 1.5),
(3, 'Test 3', 2, 9.3, 'test 3', 'default.jpg', 5.5),
(5, 'Test 4', 1, 17.89, 'test 4, Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.', 'default.jpg', 2.83);

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

--
-- Table structure for table `stoftype`
--

CREATE TABLE IF NOT EXISTS `stoftype` (
  `ID` int(11) NOT NULL,
  `Naam` varchar(500) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `stoffen`
--

INSERT INTO `stoftype` (`ID`, `Naam`) VALUES
(1, 'Dikke stof'),
(2, 'Dunne stof'),
(3, 'Waterdicht');

-- --------------------------------------------------------
--
-- Indexes for table `gebruiker`
--
ALTER TABLE `gebruiker`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `gereserveerd`
--
ALTER TABLE `gereserveerd`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `stoffen`
--
ALTER TABLE `stoffen`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `stoftype`
--
ALTER TABLE `stoftype`
  ADD PRIMARY KEY (`ID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `gebruiker`
--
ALTER TABLE `gebruiker`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=16;
--
-- AUTO_INCREMENT for table `gereserveerd`
--
ALTER TABLE `gereserveerd`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `stoffen`
--
ALTER TABLE `stoffen`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `stoftype`
--
ALTER TABLE `stoftype`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
/*!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 */;
