summaryrefslogtreecommitdiffstats
path: root/server/migrations
diff options
context:
space:
mode:
authorDessalines <tyhou13@gmx.com>2019-10-20 21:21:54 -0700
committerDessalines <tyhou13@gmx.com>2019-10-20 21:21:54 -0700
commit90ce1f1a3fca5c8d8a13e91f991b23ecb77f1faf (patch)
treecd851bbdb333f3b16cfd0f5aaeed97e6f46af143 /server/migrations
parenta7dedaf273b6fd2ebd9c9b8b9d6a7d227f376797 (diff)
Adding default sort / filter into user settings.
- Fixes #295
Diffstat (limited to 'server/migrations')
-rw-r--r--server/migrations/2019-10-21-011237_add_default_sorts/down.sql2
-rw-r--r--server/migrations/2019-10-21-011237_add_default_sorts/up.sql2
2 files changed, 4 insertions, 0 deletions
diff --git a/server/migrations/2019-10-21-011237_add_default_sorts/down.sql b/server/migrations/2019-10-21-011237_add_default_sorts/down.sql
new file mode 100644
index 00000000..238c9e79
--- /dev/null
+++ b/server/migrations/2019-10-21-011237_add_default_sorts/down.sql
@@ -0,0 +1,2 @@
+alter table user_ drop column default_sort_type;
+alter table user_ drop column default_listing_type;
diff --git a/server/migrations/2019-10-21-011237_add_default_sorts/up.sql b/server/migrations/2019-10-21-011237_add_default_sorts/up.sql
new file mode 100644
index 00000000..4bb96009
--- /dev/null
+++ b/server/migrations/2019-10-21-011237_add_default_sorts/up.sql
@@ -0,0 +1,2 @@
+alter table user_ add column default_sort_type smallint default 0 not null;
+alter table user_ add column default_listing_type smallint default 1 not null;