migrations/2021-12-14-181537_add_temporary_bans/up.sql

   1 -- Add ban_expires to person, community_person_ban
   2 ALTER TABLE person
   3     ADD COLUMN ban_expires timestamp;
   4
   5 ALTER TABLE community_person_ban
   6     ADD COLUMN expires timestamp;
   7
   8 DROP VIEW person_alias_1, person_alias_2;
   9
  10 CREATE VIEW person_alias_1 AS
  11 SELECT
  12     *
  13 FROM
  14     person;
  15
  16 CREATE VIEW person_alias_2 AS
  17 SELECT
  18     *
  19 FROM
  20     person;
  21