-
Notifications
You must be signed in to change notification settings - Fork 0
/
database.sql
47 lines (39 loc) · 1.16 KB
/
database.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
42
43
44
45
CREATE DATABASE IF NOT EXISTS videoslaravel;
USE videoslaravel;
CREATE TABLE users(
id int(12) AUTO_INCREMENT NOT NULL,
role varchar(20),
name varchar(255),
surname varchar(255),
email varchar(255),
password varchar(255),
image varchar(255),
created_at datetime,
updated_at datetime,
remember_token varchar(255),
CONSTRAINT pk_users PRIMARY KEY(id)
)ENGINE=InnoDb;
CREATE TABLE videos(
id int(12) AUTO_INCREMENT NOT NULL,
user_id int(12) NOT NULL,
title varchar(255),
description text,
status varchar(20),
image varchar(255),
video_path varchar(255),
created_at datetime,
updated_at datetime,
CONSTRAINT pk_videos PRIMARY KEY(id),
CONSTRAINT fk_videos_users FOREIGN KEY(user_id) REFERENCES users(id)
)ENGINE=InnoDb;
CREATE TABLE comments(
id int(12) AUTO_INCREMENT NOT NULL,
user_id int(12),
video_id int(12),
body text,
created_at datetime,
updated_at datetime,
CONSTRAINT pk_comment PRIMARY KEY(id),
CONSTRAINT fk_comment_video FOREIGN KEY(video_id) REFERENCES videos(id),
CONSTRAINT fk_comment_user FOREIGN KEY(user_id) REFERENCES users(id)
)ENGINE=InnoDb;