Zh8v09Lm

1
2
3create database mp_development;
4create database mp_test;
5create database mp_production;
6grant all on mp_development.* to 'root'@'localhost';
7grant all on mp_test.* to 'root'@'localhost';
8grant all on mp_production.* to 'root'@'localhost' identified by 'root';
9
10DROP TABLE IF EXISTS properties;
11CREATE TABLE properties (
12id								int				not null	auto_increment,
13name 							varchar(50)		not null,
14location						varchar(50)		not null,
15sleeps							int(2)			not null,
16description						text			not null,
17shower							tinyint(1)		not null,
18internet						tinyint(1)		not null,
19open_fire						tinyint(1)		not null,
20image_url1						varchar(200)	default NULL,
21image_url2						varchar(200)	default NULL,
22image_url3						varchar(200)	default NULL,
23image_url4						varchar(200)	default NULL,
24price_per_week_peak				decimal(10,2)	not null,
25price_per_week_off_peak			decimal(10,2)	not null,
26owner_id						int(11)			null,
27PRIMARY KEY (id)
28);
29
30
31DROP TABLE IF EXISTS owners;
32CREATE TABLE owners (
33id	int	not null auto_increment,
34firstname 						varchar(50)  not null,
35surname 						varchar(50)  not null,
36phone							varchar(20)		not null,
37mobile							varchar(20)		not null,
38email							varchar(20)		not null,
39address1						varchar(20)		not null,
40address2						varchar(20)		not null,
41address3						varchar(20)		not null,
42address4						varchar(20)		not null,
43postcode						varchar(20)		not null,
44PRIMARY KEY (id)
45);
46
47DROP TABLE IF EXISTS users;
48CREATE TABLE users (
49id								int				not null	auto_increment,
50name							varchar(100)	not null,
51hashed_password					char(40)		null,
52PRIMARY KEY (id)
53);