]> Untitled Git - lemmy.git/blob - migrations/2021-03-31-105915_add_bot_account/down.sql
fix submodule error
[lemmy.git] / migrations / 2021-03-31-105915_add_bot_account / down.sql
1 DROP VIEW person_alias_1, person_alias_2;
2
3 ALTER TABLE person
4     DROP COLUMN bot_account;
5
6 CREATE VIEW person_alias_1 AS
7 SELECT
8     *
9 FROM
10     person;
11
12 CREATE VIEW person_alias_2 AS
13 SELECT
14     *
15 FROM
16     person;
17
18 ALTER TABLE local_user
19     DROP COLUMN show_bot_accounts;
20