Weekmail frontend - see #40

CREATE TABLE weekmail (id BIGINT AUTO_INCREMENT, published_at DATE NOT NULL, edito TEXT, editar TEXT, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = INNODB;
CREATE TABLE weekmail_article (id BIGINT AUTO_INCREMENT, asso_id BIGINT NOT NULL, name VARCHAR(200) NOT NULL, text TEXT NOT NULL, image TEXT, summary VARCHAR(150), weekmail_id BIGINT, article_id BIGINT, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX asso_id_idx (asso_id), INDEX weekmail_id_idx (weekmail_id), INDEX article_id_idx (article_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = INNODB;
ALTER TABLE weekmail_article ADD CONSTRAINT weekmail_article_weekmail_id_weekmail_id FOREIGN KEY (weekmail_id) REFERENCES weekmail(id);
ALTER TABLE weekmail_article ADD CONSTRAINT weekmail_article_asso_id_asso_id FOREIGN KEY (asso_id) REFERENCES asso(id);
ALTER TABLE weekmail_article ADD CONSTRAINT weekmail_article_article_id_article_id FOREIGN KEY (article_id) REFERENCES article(id);

Signed-off-by: Emilien Kenler <hello@emilienkenler.com>