CREATE DATABASE agendax;
USE agendax;

CREATE TABLE logs (time timestamp, message VARCHAR(255));
CREATE TABLE agenda (agent VARCHAR(20), day int, hour int);
CREATE TABLE agents (id serial PRIMARY KEY, name VARCHAR(20));

INSERT INTO agents (name) VALUES ('toto');
INSERT INTO agents (name) VALUES ('titi');
INSERT INTO agents (name) VALUES ('tutu');

