-
Notifications
You must be signed in to change notification settings - Fork 0
/
seed.sql
24 lines (21 loc) · 654 Bytes
/
seed.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
-- Adiciona suporte para caracteres UTF-8 nos comandos abaixo
-- Fonte: https://github.com/docker-library/mysql/issues/131#issuecomment-680802361
SET
NAMES utf8mb4;
DROP TABLE IF EXISTS talkers;
CREATE TABLE
talkers (
name VARCHAR(512),
age INT,
id INT,
talk_watched_at VARCHAR(512),
talk_rate INT
);
INSERT INTO
talkers (id, name, age, talk_watched_at, talk_rate)
VALUES
(1, 'Henrique Albuquerque', 62, '22/10/2020', 5),
(2, 'Heloísa Albuquerque', 67, '22/10/2020', 4),
(3, 'Ricardo Xavier Filho', 33, '22/10/2020', 3),
(4, 'Marcos Costa', 24, '30/10/2020', 5),
(5, 'Henrique dos Santos', 44, '29/10/2020', 5);