Doesn't use anymore Article::summary - it will be used by weekmail - see #34

Signed-off-by: Emilien Kenler <hello@emilienkenler.com>
Doesn't use anymore Article::summary - it will be used by weekmail - see #34

Signed-off-by: Emilien Kenler <hello@emilienkenler.com>
Possibilité de soumesttre un article au weekmail + visualisation par le bde - see #40

Signed-off-by: Emilien Kenler <hello@emilienkenler.com>
Add weekmail module for bde app - see #40

Migration doesn't work, please use the sql below:
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), created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX asso_id_idx (asso_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = INNODB;
ALTER TABLE weekmail_article ADD CONSTRAINT weekmail_article_asso_id_asso_id FOREIGN KEY (asso_id) REFERENCES asso(id);

Signed-off-by: Emilien Kenler <hello@emilienkenler.com>
Add actions for weekmail

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, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX asso_id_idx (asso_id), INDEX weekmail_id_idx (weekmail_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);

Signed-off-by: Emilien Kenler <hello@emilienkenler.com>
BDE can now accept and refuse article

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, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX asso_id_idx (asso_id), INDEX weekmail_id_idx (weekmail_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);

Signed-off-by: Emilien Kenler <hello@emilienkenler.com>
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>
GUI weekmail - see #42

Signed-off-by: Emilien Kenler <hello@emilienkenler.com>
btn size - see #42

Signed-off-by: Emilien Kenler <hello@emilienkenler.com>
Merge pull request #42 from MiLk/weekmail

Weekmail - issue #40
Réparation des migrations

Reprise des migration depuis le début, afin que l'on puisse créer la structure de la base directement avec les migrations.

J'ai aussi mis à jour la page Bien commencer du wiki pour que ça corresponde, n'hésitez pas à jeter un coup d'oeil car les commandes pour la manipulation de la base changent !

J'ai aussi passé le champ date de charte_info de datetime en timestamp, car apparemment datetime n'existe pas.

Si vous avez déjà utilisé les migrations, la version actuelle est la 35, il faut mettre à jour manuellement la table migration_version.

This fixes #44
Tables pour le Weekmail by @MiLk

Elles n'étaient pas dans le modèle que j'ai généré mais le PR Weekmail a été merge, donc il faut les inclure avec ce PR.
Merge pull request #46 from apuyou/migrations

Réparation des migrations