From 0372029e8da038795db9cce25c8639950ac9cc1d Mon Sep 17 00:00:00 2001
From: Dessalines <tyhou13@gmx.com>
Date: Tue, 12 Apr 2022 14:55:47 -0400
Subject: [PATCH] Changing default listing type to Local from Subscribed.

---
 .../down.sql                                                   | 3 +++
 .../up.sql                                                     | 3 +++
 2 files changed, 6 insertions(+)
 create mode 100644 migrations/2022-04-12-185205_change_default_listing_type_to_local/down.sql
 create mode 100644 migrations/2022-04-12-185205_change_default_listing_type_to_local/up.sql

diff --git a/migrations/2022-04-12-185205_change_default_listing_type_to_local/down.sql b/migrations/2022-04-12-185205_change_default_listing_type_to_local/down.sql
new file mode 100644
index 00000000..d1d35659
--- /dev/null
+++ b/migrations/2022-04-12-185205_change_default_listing_type_to_local/down.sql
@@ -0,0 +1,3 @@
+-- 0 is All, 1 is Local, 2 is Subscribed
+
+alter table only local_user alter column default_listing_type set default 2;
diff --git a/migrations/2022-04-12-185205_change_default_listing_type_to_local/up.sql b/migrations/2022-04-12-185205_change_default_listing_type_to_local/up.sql
new file mode 100644
index 00000000..15f0509e
--- /dev/null
+++ b/migrations/2022-04-12-185205_change_default_listing_type_to_local/up.sql
@@ -0,0 +1,3 @@
+-- 0 is All, 1 is Local, 2 is Subscribed
+
+alter table only local_user alter column default_listing_type set default 1;
-- 
2.44.1