qazk4pLW

1-- phpMyAdmin SQL Dump
2-- version 4.8.3
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1:3306
6-- Gegenereerd op: 28 nov 2018 om 23:59
7-- Serverversie: 5.7.23
8-- PHP-versie: 7.2.10
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Database: `webshop`
23--
24
25-- --------------------------------------------------------
26
27--
28-- Tabelstructuur voor tabel `admins`
29--
30
31DROP TABLE IF EXISTS `admins`;
32CREATE TABLE IF NOT EXISTS `admins` (
33  `userid` int(30) NOT NULL AUTO_INCREMENT,
34  `username` varchar(50) NOT NULL,
35  `password` varchar(50) NOT NULL,
36  PRIMARY KEY (`userid`)
37) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
38
39--
40-- Gegevens worden geëxporteerd voor tabel `admins`
41--
42
43INSERT INTO `admins` (`userid`, `username`, `password`) VALUES
44(1, 'Kelly', 'Kelly'),
45(2, 'Kelsey', 'Kelsey');
46
47-- --------------------------------------------------------
48
49--
50-- Tabelstructuur voor tabel `orders`
51--
52
53DROP TABLE IF EXISTS `orders`;
54CREATE TABLE IF NOT EXISTS `orders` (
55  `id` int(30) NOT NULL AUTO_INCREMENT,
56  `user` int(11) NOT NULL,
57  PRIMARY KEY (`id`)
58) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
59
60--
61-- Gegevens worden geëxporteerd voor tabel `orders`
62--
63
64INSERT INTO `orders` (`id`, `user`) VALUES
65(10, 24),
66(11, 25),
67(12, 25);
68
69-- --------------------------------------------------------
70
71--
72-- Tabelstructuur voor tabel `order_product`
73--
74
75DROP TABLE IF EXISTS `order_product`;
76CREATE TABLE IF NOT EXISTS `order_product` (
77  `product` int(250) NOT NULL,
78  `order` int(30) NOT NULL,
79  `price` double NOT NULL,
80  `count` int(11) NOT NULL
81) ENGINE=MyISAM DEFAULT CHARSET=latin1;
82
83--
84-- Gegevens worden geëxporteerd voor tabel `order_product`
85--
86
87INSERT INTO `order_product` (`product`, `order`, `price`, `count`) VALUES
88(1, 10, 13, 1),
89(2, 10, 0.5, 2),
90(3, 10, 400, 1),
91(3, 0, 400, 1),
92(2, 0, 0.5, 3),
93(2, 0, 0.5, 2),
94(3, 0, 400, 2),
95(3, 0, 400, 1),
96(3, 0, 400, 5),
97(2, 0, 0.5, 1),
98(3, 0, 400, 2),
99(2, 11, 0.5, 10),
100(3, 11, 400, 10);
101
102-- --------------------------------------------------------
103
104--
105-- Tabelstructuur voor tabel `products`
106--
107
108DROP TABLE IF EXISTS `products`;
109CREATE TABLE IF NOT EXISTS `products` (
110  `id` int(250) NOT NULL AUTO_INCREMENT,
111  `name` varchar(250) NOT NULL,
112  `description` text NOT NULL,
113  `image` varchar(255) NOT NULL,
114  `price` double NOT NULL,
115  PRIMARY KEY (`id`)
116) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
117
118--
119-- Gegevens worden geëxporteerd voor tabel `products`
120--
121
122INSERT INTO `products` (`id`, `name`, `description`, `image`, `price`) VALUES
123(15, 'Retro Packsds', 'Retro PackRetro PackRetro PackRetro PackRetro PackRetro PackRetro PackRetro PackRetro PackRetro PackRetro PackRetro PackRetro PackRetro PackRetro PackRetro PackRetro PackRetro PackRetro PackRetro PackRetro PackRetro PackRetro PackRetro PackRetro PackRetro PackRetro PackRetro Pack', '2.png', 25);
124
125-- --------------------------------------------------------
126
127--
128-- Tabelstructuur voor tabel `users`
129--
130
131DROP TABLE IF EXISTS `users`;
132CREATE TABLE IF NOT EXISTS `users` (
133  `userid` int(30) NOT NULL AUTO_INCREMENT,
134  `username` varchar(50) NOT NULL,
135  `password` varchar(50) NOT NULL,
136  `email` varchar(50) NOT NULL,
137  PRIMARY KEY (`userid`)
138) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;
139
140--
141-- Gegevens worden geëxporteerd voor tabel `users`
142--
143
144INSERT INTO `users` (`userid`, `username`, `password`, `email`) VALUES
145(24, 'KlantEen', 'KlantKlant', 'KlantEen@gmail.com'),
146(23, 'Bonnie Timmerman', 'Bonnie', 'bonnietimmerman@gmail.com'),
147(22, 'Darren Timmerman', 'Timmerman', 'darrentimmerman@gmail.com'),
148(25, 'kip', 'kip', 'kip@hotmail.com'),
149(26, 'a', 'a', 'a'),
150(27, 'ksdksjd', 'ksjdsk', 'sfkjnsdf@gmail.com'),
151(28, 'sdfsdgf', 'sdfsdf', 'sdsdfs@gmail.com'),
152(29, 'sdfsdfsf', 'sdfsdfs', 'sdfdsf'),
153(30, 'sdfsf', 'sdfsfs', 'sdfsdf');
154COMMIT;
155
156/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
157/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
158/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;