lemmy/migrations/2021-07-20-102033_actor_name_length/up.sql

29 lines
435 B
MySQL
Raw Permalink Normal View History

DROP VIEW person_alias_1;
DROP VIEW person_alias_2;
ALTER TABLE community
ALTER COLUMN name TYPE varchar(255);
ALTER TABLE community
ALTER COLUMN title TYPE varchar(255);
ALTER TABLE person
ALTER COLUMN name TYPE varchar(255);
ALTER TABLE person
ALTER COLUMN display_name TYPE varchar(255);
CREATE VIEW person_alias_1 AS
SELECT
*
FROM
person;
CREATE VIEW person_alias_2 AS
SELECT
*
FROM
person;