]> Untitled Git - lemmy.git/blob - migrations/2021-04-01-173552_rename_preferred_username_to_display_name/down.sql
fix submodule error
[lemmy.git] / migrations / 2021-04-01-173552_rename_preferred_username_to_display_name / down.sql
1 ALTER TABLE person RENAME display_name TO preferred_username;
2
3 -- Regenerate the person_alias views
4 DROP VIEW person_alias_1, person_alias_2;
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