-
Notifications
You must be signed in to change notification settings - Fork 0
/
database.sql
110 lines (99 loc) · 2.94 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
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
# noinspection SqlNoDataSourceInspectionForFile
CREATE DATABASE IF NOT EXISTS laravel_master;
USE laravel_master;
CREATE TABLE IF NOT EXISTS users(
id int(255) auto_increment NOT NULL,
role varchar(20),
name varchar(100),
surname varchar(200),
nick varchar(100),
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;
INSERT INTO users VALUES(
NULL,
'user',
'Miguel',
'Gozaine',
'GOZAEL',
'hordemzerado@gmail.com',
'pass',
NULL,
CURTIME(),
CURTIME(),
NULL
);
INSERT INTO users VALUES(
NULL,
'user',
'Juan',
'Lopez',
'Juani',
'juan@juan.com',
'juan',
NULL,
CURTIME(),
CURTIME(),
NULL
);
INSERT INTO users VALUES(
NULL,
'user',
'Pedro',
'Perez',
'ppez',
'pedro@pedro.com',
'pedro',
NULL,
CURTIME(),
CURTIME(),
NULL
);
CREATE TABLE IF NOT EXISTS images(
id int(255) auto_increment NOT NULL,
user_id int(255),
image_path varchar(255),
description text,
created_at datetime,
updated_at datetime,
CONSTRAINT pk_images PRIMARY KEY(id),
CONSTRAINT fk_images_users FOREIGN KEY(user_id) REFERENCES users(id)
)Engine=InnoDb;
INSERT INTO images VALUES(NULL, 1, 'test.jpg', 'Test description 1', CURTIME(), CURTIME());
INSERT INTO images VALUES(NULL, 1, 'playa.jpg', 'Test description 2', CURTIME(), CURTIME());
INSERT INTO images VALUES(NULL, 3, 'sol.jpg', 'Test description 4', CURTIME(), CURTIME());
INSERT INTO images VALUES(NULL, 2, 'arena.jpg', 'Test description 3', CURTIME(), CURTIME());
CREATE TABLE IF NOT EXISTS comments(
id int(255) auto_increment NOT NULL,
user_id int(255),
image_id int(255),
content text,
created_at datetime,
updated_at datetime,
CONSTRAINT pk_comments PRIMARY KEY(id),
CONSTRAINT fk_comments_users FOREIGN KEY(user_id) REFERENCES users(id),
CONSTRAINT fk_comments_images FOREIGN KEY(image_id) REFERENCES images(id)
)Engine=InnoDb;
INSERT INTO comments VALUES(NULL, 1, 4, 'Buena foto en familia', CURTIME(), CURTIME());
INSERT INTO comments VALUES(NULL, 1, 2, 'Buena foto de playa', CURTIME(), CURTIME());
INSERT INTO comments VALUES(NULL, 2, 4, 'QUE BUENO!!!!!', CURTIME(), CURTIME());
CREATE TABLE IF NOT EXISTS likes(
id int(255) auto_increment NOT NULL,
user_id int(255),
image_id int(255),
created_at datetime,
updated_at datetime,
CONSTRAINT pk_likes PRIMARY KEY(id),
CONSTRAINT fk_likes_users FOREIGN KEY(user_id) REFERENCES users(id),
CONSTRAINT fk_likes_images FOREIGN KEY(image_id) REFERENCES images(id)
)Engine=InnoDb;
INSERT INTO likes VALUES(NULL, 1, 4, CURTIME(), CURTIME());
INSERT INTO likes VALUES(NULL, 2, 4, CURTIME(), CURTIME());
INSERT INTO likes VALUES(NULL, 3, 1, CURTIME(), CURTIME());
INSERT INTO likes VALUES(NULL, 3, 2, CURTIME(), CURTIME());
INSERT INTO likes VALUES(NULL, 2, 1, CURTIME(), CURTIME());