19 lines
533 B
SQL
19 lines
533 B
SQL
-- 2023-09-06: Some improvements to posts
|
|
|
|
-- +migrate Up
|
|
|
|
alter table config add column post_character_limit integer not null default 5000;
|
|
create index posts_blog_id_idx on posts (blog_id);
|
|
|
|
create table post_recipients (
|
|
post_id TEXT NOT NULL REFERENCES posts (id) ON DELETE CASCADE,
|
|
blog_id TEXT NOT NULL REFERENCES blogs (id) ON DELETE CASCADE,
|
|
|
|
PRIMARY KEY (post_id, blog_id)
|
|
);
|
|
|
|
-- +migrate Down
|
|
|
|
drop table post_recipients;
|
|
drop index posts_blog_id_idx;
|
|
alter table config drop column post_character_limit;
|