Moving admin to person table. Fixes #1515

[lemmy.git] / migrations / 2021-03-20-185321_move_matrix_id_to_person / down.sql

diff --git a/migrations/2021-03-20-185321_move_matrix_id_to_person/down.sql b/migrations/2021-03-20-185321_move_matrix_id_to_person/down.sql
index 70cbe9bfa5f1514674a97a3ec99348c2889773d7..990d8fe97777435a8ed4ae050843d49b875aa66a 100644 (file)
--- a/migrations/2021-03-20-185321_move_matrix_id_to_person/down.sql
+++ b/migrations/2021-03-20-185321_move_matrix_id_to_person/down.sql
@@ -1,12 +1,16 @@
 alter table local_user add column matrix_user_id text;
+alter table local_user add column admin boolean default false not null;
 
 update local_user lu
-set matrix_user_id = p.matrix_user_id 
+set 
+  matrix_user_id = p.matrix_user_id,
+  admin = p.admin
 from person p
 where p.id = lu.person_id;
 
 drop view person_alias_1, person_alias_2;
 alter table person drop column matrix_user_id;
+alter table person drop column admin;
 
 -- Regenerate the person_alias views
 create view person_alias_1 as select * from person;