· 6 years ago · Dec 19, 2019, 02:26 PM
1/*
2 Navicat Premium Data Transfer
3
4 Source Server : localhost_3306
5 Source Server Type : MySQL
6 Source Server Version : 80013
7 Source Host : localhost:3306
8 Source Schema : themold
9
10 Target Server Type : MySQL
11 Target Server Version : 80013
12 File Encoding : 65001
13
14 Date: 19/12/2019 15:22:43
15*/
16
17SET NAMES utf8mb4;
18SET FOREIGN_KEY_CHECKS = 0;
19
20-- ----------------------------
21-- Table structure for gebruikersaccount
22-- ----------------------------
23DROP TABLE IF EXISTS `gebruikersaccount`;
24CREATE TABLE `gebruikersaccount` (
25 `Gebruikerscode` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
26 `Gebruikersnaam` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
27 `Wachtwoord` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
28 PRIMARY KEY (`Gebruikerscode`) USING BTREE
29) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
30
31-- ----------------------------
32-- Records of gebruikersaccount
33-- ----------------------------
34INSERT INTO `gebruikersaccount` VALUES ('GC01', 'test', 'test01');
35
36-- ----------------------------
37-- Table structure for klant
38-- ----------------------------
39DROP TABLE IF EXISTS `klant`;
40CREATE TABLE `klant` (
41 `Klantcode` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
42 `Voornaam` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
43 `Achternaam` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
44 `Adres` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
45 `Huisnummer` int(11) NOT NULL,
46 `Postcode` char(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
47 `Woonplaats` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
48 `Telefoonnummer` int(11) NOT NULL,
49 `Land` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
50 `Email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
51 `Gebruikerscode` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
52 PRIMARY KEY (`Klantcode`) USING BTREE,
53 INDEX `Gebruikerscode`(`Gebruikerscode`) USING BTREE,
54 CONSTRAINT `klant_ibfk_1` FOREIGN KEY (`Gebruikerscode`) REFERENCES `gebruikersaccount` (`gebruikerscode`) ON DELETE CASCADE ON UPDATE CASCADE
55) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
56
57-- ----------------------------
58-- Records of klant
59-- ----------------------------
60INSERT INTO `klant` VALUES ('KC01', 'test', 'tset', 'Test', 1, '1111GE', 'Den Haag', 987654321, 'NL', 'test@test.nl', 'GC01');
61
62-- ----------------------------
63-- Table structure for logbook
64-- ----------------------------
65DROP TABLE IF EXISTS `logbook`;
66CREATE TABLE `logbook` (
67 `Logcode` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
68 `CO2_meting` int(11) NOT NULL,
69 `Temperatuur_meting` int(11) NOT NULL,
70 `Microbitcode` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
71 PRIMARY KEY (`Logcode`) USING BTREE,
72 INDEX `Microbitcode`(`Microbitcode`) USING BTREE,
73 CONSTRAINT `logbook_ibfk_1` FOREIGN KEY (`Microbitcode`) REFERENCES `microbit` (`microbitcode`) ON DELETE RESTRICT ON UPDATE CASCADE
74) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
75
76-- ----------------------------
77-- Records of logbook
78-- ----------------------------
79INSERT INTO `logbook` VALUES ('LC01', 1, 19, 'MBC01');
80
81-- ----------------------------
82-- Table structure for melding
83-- ----------------------------
84DROP TABLE IF EXISTS `melding`;
85CREATE TABLE `melding` (
86 `Gebruikerscode` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
87 `Productcode` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
88 PRIMARY KEY (`Gebruikerscode`, `Productcode`) USING BTREE,
89 INDEX `Productcode`(`Productcode`) USING BTREE,
90 CONSTRAINT `melding_ibfk_1` FOREIGN KEY (`Gebruikerscode`) REFERENCES `gebruikersaccount` (`gebruikerscode`) ON DELETE RESTRICT ON UPDATE RESTRICT,
91 CONSTRAINT `melding_ibfk_2` FOREIGN KEY (`Productcode`) REFERENCES `product` (`productcode`) ON DELETE CASCADE ON UPDATE CASCADE
92) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
93
94-- ----------------------------
95-- Records of melding
96-- ----------------------------
97INSERT INTO `melding` VALUES ('GC01', 'PC01');
98
99-- ----------------------------
100-- Table structure for microbit
101-- ----------------------------
102DROP TABLE IF EXISTS `microbit`;
103CREATE TABLE `microbit` (
104 `Microbitcode` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
105 `CO2gehalte` int(11) NOT NULL,
106 `Temperatuurmeting` int(11) NOT NULL,
107 `Productcode` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
108 PRIMARY KEY (`Microbitcode`) USING BTREE,
109 INDEX `Productcode`(`Productcode`) USING BTREE,
110 CONSTRAINT `microbit_ibfk_1` FOREIGN KEY (`Productcode`) REFERENCES `product` (`productcode`) ON DELETE RESTRICT ON UPDATE CASCADE
111) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
112
113-- ----------------------------
114-- Records of microbit
115-- ----------------------------
116INSERT INTO `microbit` VALUES ('MBC01', 2, 24, 'PC01');
117
118-- ----------------------------
119-- Table structure for product
120-- ----------------------------
121DROP TABLE IF EXISTS `product`;
122CREATE TABLE `product` (
123 `Productcode` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
124 `Model` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
125 `MACadres` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
126 `Versie` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
127 `Contactnummer` int(11) NOT NULL,
128 `Email_klantenservice` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
129 `Gebruikerscode` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
130 `Simcode` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
131 PRIMARY KEY (`Productcode`) USING BTREE,
132 INDEX `Gebruikerscode`(`Gebruikerscode`) USING BTREE,
133 INDEX `Simcode`(`Simcode`) USING BTREE,
134 CONSTRAINT `product_ibfk_1` FOREIGN KEY (`Gebruikerscode`) REFERENCES `gebruikersaccount` (`gebruikerscode`) ON DELETE RESTRICT ON UPDATE RESTRICT,
135 CONSTRAINT `product_ibfk_2` FOREIGN KEY (`Simcode`) REFERENCES `simkaart` (`simcode`) ON DELETE RESTRICT ON UPDATE CASCADE
136) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
137
138-- ----------------------------
139-- Records of product
140-- ----------------------------
141INSERT INTO `product` VALUES ('PC01', 'M1', '00:00:00:00:00', 'V1.0', 192837465, 'testk@klant.nl', 'GC01', 'SC01');
142
143-- ----------------------------
144-- Table structure for simkaart
145-- ----------------------------
146DROP TABLE IF EXISTS `simkaart`;
147CREATE TABLE `simkaart` (
148 `Simcode` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
149 `Telefoonnummer` int(11) NOT NULL,
150 `Serienummer` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
151 PRIMARY KEY (`Simcode`) USING BTREE
152) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
153
154-- ----------------------------
155-- Records of simkaart
156-- ----------------------------
157INSERT INTO `simkaart` VALUES ('SC01', 1234567890, '90jk34jk2');
158
159SET FOREIGN_KEY_CHECKS = 1;