Remove mat views, no fast tables or caching added yet.

2 files changed, 18 insertions, 0 deletions

diff --git a/server/migrations/2020-06-29-222617_remove_mat_views/down.sql b/server/migrations/2020-06-29-222617_remove_mat_views/down.sql
new file mode 100644
index 00000000..7c490863
--- /dev/null
+++ b/server/migrations/2020-06-29-222617_remove_mat_views/down.sql
@@ -0,0 +1,9 @@
+alter table comment enable trigger refresh_comment;
+alter table user_ enable trigger refresh_user;
+alter table post enable trigger refresh_post;
+alter table community enable trigger refresh_community;
+alter table private_message enable trigger refresh_private_message;
+alter table post_like enable trigger refresh_post_like;
+alter table community_follower enable trigger refresh_community_follower;
+alter table community_user_ban enable trigger refresh_community_user_ban;
+alter table comment_like enable trigger refresh_comment_like;
diff --git a/server/migrations/2020-06-29-222617_remove_mat_views/up.sql b/server/migrations/2020-06-29-222617_remove_mat_views/up.sql
new file mode 100644
index 00000000..eb0fb938
--- /dev/null
+++ b/server/migrations/2020-06-29-222617_remove_mat_views/up.sql
@@ -0,0 +1,9 @@
+alter table comment disable trigger refresh_comment;
+alter table user_ disable trigger refresh_user;
+alter table post disable trigger refresh_post;
+alter table community disable trigger refresh_community;
+alter table private_message disable trigger refresh_private_message;
+alter table post_like disable trigger refresh_post_like;
+alter table community_follower disable trigger refresh_community_follower;
+alter table community_user_ban disable trigger refresh_community_user_ban;
+alter table comment_like disable trigger refresh_comment_like;