dFdLqVnN

1-- phpMyAdmin SQL Dump
2-- version 4.2.12deb2+deb8u2
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Jan 10, 2017 at 12:09 PM
7-- Server version: 5.5.53-0+deb8u1
8-- PHP Version: 5.6.27-0+deb8u1
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `PeDeWatches`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `order`
27--
28
29CREATE TABLE IF NOT EXISTS `order` (
30`id` int(4) NOT NULL,
31  `user_id` int(4) NOT NULL
32) ENGINE=InnoDB DEFAULT CHARSET=latin1;
33
34-- --------------------------------------------------------
35
36--
37-- Table structure for table `order_rule`
38--
39
40CREATE TABLE IF NOT EXISTS `order_rule` (
41`id` int(4) NOT NULL,
42  `order_id` int(4) NOT NULL,
43  `product_id` int(4) NOT NULL,
44  `amount` int(4) DEFAULT NULL,
45  `total_price` float DEFAULT NULL
46) ENGINE=InnoDB DEFAULT CHARSET=latin1;
47
48-- --------------------------------------------------------
49
50--
51-- Table structure for table `product`
52--
53
54CREATE TABLE IF NOT EXISTS `product` (
55`id` int(4) NOT NULL,
56  `name` varchar(255) DEFAULT NULL,
57  `clock_color` varchar(255) DEFAULT NULL,
58  `band_color` varchar(255) DEFAULT NULL,
59  `clock_material` varchar(255) DEFAULT NULL,
60  `band_material` varchar(255) DEFAULT NULL,
61  `watch_face` varchar(255) DEFAULT NULL,
62  `price` float NOT NULL,
63  `gender` varchar(255) NOT NULL,
64  `stock` int(4) DEFAULT NULL,
65  `img_url` varchar(255) DEFAULT NULL,
66  `is_custom` tinyint(4) NOT NULL
67) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
68
69--
70-- Dumping data for table `product`
71--
72
73INSERT INTO `product` (`id`, `name`, `clock_color`, `band_color`, `clock_material`, `band_material`, `watch_face`, `price`, `gender`, `stock`, `img_url`, `is_custom`) VALUES
74(1, 'Bram', 'Gold', 'Black', NULL, 'Leather', NULL, 1999.99, 'Woman', NULL, 'images/products/watch1.jpg', 0),
75(4, 'TW STEEL Canteen Leather CS2', 'Black', 'Black', 'Aluminium', 'Leather', NULL, 279, 'Men', 5, 'images/products/watch4.jpg', 0),
76(5, 'PDTX 310', 'White', 'Black', 'Aluminium', 'Plastic', NULL, 299.95, 'Unisex', 10, 'images/products/watch5.jpg', 0),
77(6, 'PDM 32005', 'White', 'Blue', 'Aluminium', 'Rubber', NULL, 94.99, 'Men', 0, NULL, 0),
78(7, 'Test watch 1', NULL, NULL, NULL, NULL, NULL, 10, 'male', NULL, NULL, 0),
79(8, 'Test watch 2', NULL, NULL, NULL, NULL, NULL, 10, 'male', NULL, NULL, 0),
80(9, 'Test watch 3', NULL, NULL, NULL, NULL, NULL, 10, 'male', NULL, NULL, 0),
81(10, 'Test watch 4', NULL, NULL, NULL, NULL, NULL, 10, 'male', NULL, NULL, 0),
82(11, 'Test watch 5', NULL, NULL, NULL, NULL, NULL, 10, 'male', NULL, NULL, 0),
83(12, 'Test watch 6', NULL, NULL, NULL, NULL, NULL, 10, 'male', NULL, NULL, 0),
84(13, 'Custom Watch', NULL, NULL, NULL, NULL, NULL, 50, 'Unisex', NULL, NULL, 1);
85
86-- --------------------------------------------------------
87
88--
89-- Table structure for table `user`
90--
91
92CREATE TABLE IF NOT EXISTS `user` (
93`id` int(4) NOT NULL,
94  `first_name` varchar(255) NOT NULL,
95  `middle_name` varchar(255) DEFAULT NULL,
96  `last_name` varchar(255) NOT NULL,
97  `email` varchar(255) NOT NULL,
98  `password` varchar(255) DEFAULT NULL,
99  `zip_code` varchar(10) NOT NULL,
100  `street` varchar(255) NOT NULL,
101  `street_nr` int(4) NOT NULL,
102  `state` varchar(255) NOT NULL,
103  `country` varchar(255) NOT NULL,
104  `is_Admin` tinyint(1) DEFAULT '0'
105) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
106
107--
108-- Dumping data for table `user`
109--
110
111INSERT INTO `user` (`id`, `first_name`, `middle_name`, `last_name`, `email`, `password`, `zip_code`, `street`, `street_nr`, `state`, `country`, `is_Admin`) VALUES
112(1, 'Demi', NULL, 'Pasman', 'demi-pasman@hotmail.com', '4216455ceebbc3038bd0550c85b6a3bf', '7161JD', 'Kievitstraat', 14, 'Neede', 'Nederland', 1),
113(2, 'Peter', NULL, 'Wientjes', 'peter.wientjes@alwiecom.nl', '4216455ceebbc3038bd0550c85b6a3bf', '7161HD', 'Rapenburg', 2, 'Neede', 'Nederland', 1),
114(5, 'Karel', '', 'Ankerman', 'Karel@ankerman.nl', '5f4dcc3b5aa765d61d8327deb882cf99', '1234AB', 'Karelslaan', 3, 'Nee', 'Netherlands', 0),
115(6, 'Bas', '', 'Nottrot', 'bas@nottrot.nl', '4216455ceebbc3038bd0550c85b6a3bf', '1234XD', 'Weet', 3, 'ik', 'niet', 0);
116
117--
118-- Indexes for dumped tables
119--
120
121--
122-- Indexes for table `order`
123--
124ALTER TABLE `order`
125 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `user_id` (`user_id`);
126
127--
128-- Indexes for table `order_rule`
129--
130ALTER TABLE `order_rule`
131 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `user_id` (`order_id`), ADD UNIQUE KEY `product_id` (`product_id`);
132
133--
134-- Indexes for table `product`
135--
136ALTER TABLE `product`
137 ADD PRIMARY KEY (`id`);
138
139--
140-- Indexes for table `user`
141--
142ALTER TABLE `user`
143 ADD PRIMARY KEY (`id`);
144
145--
146-- AUTO_INCREMENT for dumped tables
147--
148
149--
150-- AUTO_INCREMENT for table `order`
151--
152ALTER TABLE `order`
153MODIFY `id` int(4) NOT NULL AUTO_INCREMENT;
154--
155-- AUTO_INCREMENT for table `order_rule`
156--
157ALTER TABLE `order_rule`
158MODIFY `id` int(4) NOT NULL AUTO_INCREMENT;
159--
160-- AUTO_INCREMENT for table `product`
161--
162ALTER TABLE `product`
163MODIFY `id` int(4) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=14;
164--
165-- AUTO_INCREMENT for table `user`
166--
167ALTER TABLE `user`
168MODIFY `id` int(4) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
169--
170-- Constraints for dumped tables
171--
172
173--
174-- Constraints for table `order`
175--
176ALTER TABLE `order`
177ADD CONSTRAINT `Order_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`);
178
179--
180-- Constraints for table `order_rule`
181--
182ALTER TABLE `order_rule`
183ADD CONSTRAINT `Order_Rule_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `order` (`id`),
184ADD CONSTRAINT `Order_Rule_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `product` (`id`);
185
186/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
187/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
188/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;