Change charte order

Signed-off-by: Emilien Kenler <hello@emilienkenler.com>
Merge pull request #39 from MiLk/bde-charte-order

Change charte order
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