From 53ea383b4e139ebbe8c81ea9b1a4acd6faa47f9d Mon Sep 17 00:00:00 2001
From: Dessalines <tyhou13@gmx.com>
Date: Sat, 20 Mar 2021 16:32:52 -0400
Subject: [PATCH] Forgot to regenerate person_alias views

---
 .../2021-03-20-185321_move_matrix_id_to_person/down.sql      | 5 +++++
 migrations/2021-03-20-185321_move_matrix_id_to_person/up.sql | 5 +++++
 2 files changed, 10 insertions(+)

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 ce4eb4ad..70cbe9bf 100644
--- 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
@@ -5,4 +5,9 @@ set matrix_user_id = p.matrix_user_id
 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;
+
+-- Regenerate the person_alias views
+create view person_alias_1 as select * from person;
+create view person_alias_2 as select * from person;
diff --git a/migrations/2021-03-20-185321_move_matrix_id_to_person/up.sql b/migrations/2021-03-20-185321_move_matrix_id_to_person/up.sql
index f8c577c9..92f20c6c 100644
--- a/migrations/2021-03-20-185321_move_matrix_id_to_person/up.sql
+++ b/migrations/2021-03-20-185321_move_matrix_id_to_person/up.sql
@@ -6,3 +6,8 @@ from local_user lu
 where p.id = lu.person_id;
 
 alter table local_user drop column matrix_user_id;
+
+-- Regenerate the person_alias views
+drop view person_alias_1, person_alias_2;
+create view person_alias_1 as select * from person;
+create view person_alias_2 as select * from person;
-- 
2.44.1