-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathbookcamp.sql
44 lines (35 loc) · 994 Bytes
/
bookcamp.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
USE bookcamp
CREATE TABLE User (
id INT PRIMARY KEY AUTO_INCREMENT,
username VARCHAR(255) NOT NULL,
email VARCHAR(255) UNIQUE NOT NULL,
password VARCHAR(255) NOT NULL
);
CREATE TABLE Campground (
id INT PRIMARY KEY AUTO_INCREMENT,
title VARCHAR(255),
geometry_type ENUM('Point') NOT NULL,
coordinates_x DECIMAL(10, 6) NOT NULL,
coordinates_y DECIMAL(10, 6) NOT NULL,
price DECIMAL(10, 2),
description TEXT,
location VARCHAR(255),
author_id INT,
FOREIGN KEY (author_id) REFERENCES User(id)
);
CREATE TABLE Image (
id INT PRIMARY KEY AUTO_INCREMENT,
campground_id INT,
url VARCHAR(255),
filename VARCHAR(255),
FOREIGN KEY (campground_id) REFERENCES Campground(id)
);
CREATE TABLE Review (
id INT PRIMARY KEY AUTO_INCREMENT,
body TEXT,
rating INT,
author_id INT,
campground_id INT,
FOREIGN KEY (author_id) REFERENCES User(id),
FOREIGN KEY (campground_id) REFERENCES Campground(id)
);