FME9zDMM

1DROP TABLE IF EXISTS users_logs;
2DROP TABLE IF EXISTS users;
3
4
5create table users
6(
7	id INT,
8	email varchar(255) not null,
9	CONSTRAINT PK_users PRIMARY KEY (id)
10);
11
12
13create table users_logs
14(
15	id INT,
16	log TEXT,
17	user_id INT,
18	created_at timestamp,
19  	INDEX IDX_6A994AB8D5A53E04 (`user_id`),
20		CONSTRAINT PK_users_logs PRIMARY KEY (id)
21);
22
23ALTER TABLE users_logs ADD CONSTRAINT FK_6A994AB8D5A53E04 FOREIGN KEY (user_id) REFERENCES users (id);
24
25
26
27INSERT INTO users (id, email) VALUES (1, '1@test.com');
28INSERT INTO users (id, email) VALUES (2, '2@test.com');
29INSERT INTO users (id, email) VALUES (3, '3@test.com');
30-- ...another 1m users
31
32INSERT INTO users_logs (id, log, user_id, created_at) VALUES (1, 'error', 1, '2019-05-20 08:15:30.258000');
33INSERT INTO users_logs (id, log, user_id, created_at) VALUES (2, 'warning', 2, '2019-05-20 08:19:15.300000');
34INSERT INTO users_logs (id, log, user_id, created_at) VALUES (3, 'notice', 3, '2019-05-20 08:19:37.022000');
35INSERT INTO users_logs (id, log, user_id, created_at) VALUES (6, 'error 2', 1, '2019-05-20 08:15:30.258000');
36INSERT INTO users_logs (id, log, user_id, created_at) VALUES (7, 'err', 2, '2019-05-20 08:20:10.021000');
37INSERT INTO users_logs (id, log, user_id, created_at) VALUES (8, 'error 3', 3, '2019-05-20 08:15:30.258000');