17 lines
435 B
SQL
17 lines
435 B
SQL
-- 2023-09-06: Account->blog follows
|
|
|
|
-- +migrate Up
|
|
|
|
create table account_follows (
|
|
account_id text not null references accounts (id) on delete cascade,
|
|
blog_id text not null references blogs (id) on delete cascade,
|
|
|
|
primary key (account_id, blog_id)
|
|
);
|
|
|
|
create index account_follows_account_id_idx on account_follows (account_id);
|
|
|
|
-- +migrate Down
|
|
|
|
drop index account_follows_account_id_idx;
|
|
drop table account_follows;
|