]> Untitled Git - lemmy.git/blob - migrations/2021-07-20-102033_actor_name_length/down.sql
Revert "Attempt to fix CI building wrong commits (#3830)"
[lemmy.git] / migrations / 2021-07-20-102033_actor_name_length / down.sql
1 DROP VIEW person_alias_1;
2
3 DROP VIEW person_alias_2;
4
5 ALTER TABLE community
6     ALTER COLUMN name TYPE varchar(20);
7
8 ALTER TABLE community
9     ALTER COLUMN title TYPE varchar(100);
10
11 ALTER TABLE person
12     ALTER COLUMN name TYPE varchar(20);
13
14 ALTER TABLE person
15     ALTER COLUMN display_name TYPE varchar(20);
16
17 CREATE VIEW person_alias_1 AS
18 SELECT
19     *
20 FROM
21     person;
22
23 CREATE VIEW person_alias_2 AS
24 SELECT
25     *
26 FROM
27     person;
28