1 alter table local_user add column matrix_user_id text;
2 alter table local_user add column admin boolean default false not null;
6 matrix_user_id = p.matrix_user_id,
9 where p.id = lu.person_id;
11 drop view person_alias_1, person_alias_2;
12 alter table person drop column matrix_user_id;
13 alter table person drop column admin;
15 -- Regenerate the person_alias views
16 create view person_alias_1 as select * from person;
17 create view person_alias_2 as select * from person;