bmBx7E1u

1/*
2Navicat MySQL Data Transfer
3
4Source Server         : localshit
5Source Server Version : 100209
6Source Host           : localhost:3306
7Source Database       : summer
8
9Target Server Type    : MYSQL
10Target Server Version : 100209
11File Encoding         : 65001
12
13Date: 2017-11-14 11:10:33
14*/
15
16SET @FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for houseowner
20-- ----------------------------
21DROP TABLE IF EXISTS [houseowner];
22CREATE TABLE `houseowner` (
23  [id] int NOT NULL IDENTITY,
24  [name] varchar(255) DEFAULT NULL,
25  [email] varchar(255) DEFAULT NULL,
26  PRIMARY KEY ([id])
27) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_danish_ci;
28
29-- ----------------------------
30-- Records of houseowner
31-- ----------------------------
32INSERT INTO `houseowner` VALUES ('1', 'Jens', 'jens@jensmail.jens');
33INSERT INTO `houseowner` VALUES ('2', 'Jacob', 'overlord@panduro.guru');
34INSERT INTO `houseowner` VALUES ('3', null, null);
35INSERT INTO `houseowner` VALUES ('4', 'Peter', 'email@localhost');
36
37-- ----------------------------
38-- Table structure for houses
39-- ----------------------------
40DROP TABLE IF EXISTS [houses];
41CREATE TABLE `houses` (
42  [id] int NOT NULL IDENTITY,
43  [address] varchar(255) DEFAULT NULL,
44  [description] varchar(max) DEFAULT NULL,
45  [photo] varchar(255) DEFAULT NULL,
46  [unitprice] decimal(10,2) DEFAULT NULL,
47  [ownerId] int DEFAULT NULL,
48  PRIMARY KEY ([id])
49) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_danish_ci;
50
51-- ----------------------------
52-- Records of houses
53-- ----------------------------
54INSERT INTO `houses` VALUES ('1', 'Kirbekabben 5', 'Finst sommerhus', 'sommerhus.png', '10.00', '1');
55INSERT INTO `houses` VALUES ('2', 'Sommerhusvej 13', 'Meget fint sommerhus', 'sommerhusvej.jpg', '999.00', '2');
56INSERT INTO `houses` VALUES ('3', 'Boulevarden 25', 'Ikke et sommerhus, men et uddannelsessted', 'lolwot.webm', '292929.00', '1');
57
58-- ----------------------------
59-- Table structure for rent
60-- ----------------------------
61DROP TABLE IF EXISTS [rent];
62CREATE TABLE `rent` (
63  [id] int NOT NULL IDENTITY,
64  [renterid] int DEFAULT NULL,
65  [houseid] int DEFAULT NULL,
66  [price] decimal(10,2) DEFAULT NULL,
67  [weekstart] date DEFAULT NULL,
68  [weekend] date DEFAULT NULL,
69  PRIMARY KEY ([id])
70) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_danish_ci;
71
72-- ----------------------------
73-- Records of rent
74-- ----------------------------
75INSERT INTO `rent` VALUES ('1', '1', '1', '99.00', '2017-11-15', '2017-11-24');
76INSERT INTO `rent` VALUES ('2', '2', '1', '232.00', '1970-10-02', '1971-02-02');
77INSERT INTO `rent` VALUES ('3', '1', '1', '999.00', '1999-02-28', '2000-12-01');
78
79-- ----------------------------
80-- Table structure for renter
81-- ----------------------------
82DROP TABLE IF EXISTS [renter];
83CREATE TABLE `renter` (
84  [id] int NOT NULL IDENTITY,
85  [name] varchar(255) DEFAULT NULL,
86  [phonenumber] int DEFAULT NULL,
87  [email] varchar(255) DEFAULT NULL,
88  PRIMARY KEY ([id])
89) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_danish_ci;
90
91-- ----------------------------
92-- Records of renter
93-- ----------------------------
94INSERT INTO `renter` VALUES ('1', 'Børge', '12345678', 'børg@gmail.email');
95INSERT INTO `renter` VALUES ('2', 'Jack', '98673475', 'me@jack.off');