Make entries sorting configurable

3 files changed, 10 insertions, 4 deletions

diff --git a/sql/schema_version_1.sql b/sql/schema_version_1.sql
index e32a38c..05f8f34 100644
--- a/sql/schema_version_1.sql
+++ b/sql/schema_version_1.sql
@@ -53,7 +53,7 @@ create table feeds (
     foreign key (category_id) references categories(id) on delete cascade
 );
 
-create type entry_status as enum ('unread', 'read', 'removed');
+create type entry_status as enum('unread', 'read', 'removed');
 
 create table entries (
     id bigserial not null,
diff --git a/sql/schema_version_4.sql b/sql/schema_version_4.sql
new file mode 100644
index 0000000..988c486
--- /dev/null
+++ b/sql/schema_version_4.sql
@@ -0,0 +1,2 @@
+create type entry_sorting_direction as enum('asc', 'desc');
+alter table users add column entry_direction entry_sorting_direction default 'asc';
diff --git a/sql/sql.go b/sql/sql.go
index 1f6b597..1a0da74 100644
--- a/sql/sql.go
+++ b/sql/sql.go
@@ -1,5 +1,5 @@
 // Code generated by go generate; DO NOT EDIT.
-// 2017-12-01 21:46:13.639273113 -0800 PST m=+0.002204900
+// 2017-12-02 16:12:47.256865279 -0800 PST m=+0.002374595
 
 package sql
 
@@ -59,7 +59,7 @@ create table feeds (
     foreign key (category_id) references categories(id) on delete cascade
 );
 
-create type entry_status as enum ('unread', 'read', 'removed');
+create type entry_status as enum('unread', 'read', 'removed');
 
 create table entries (
     id bigserial not null,
@@ -118,10 +118,14 @@ create index users_extra_idx on users using gin(extra);
     created_at timestamp with time zone not null default now(),
     primary key(id, value)
 );`,
+	"schema_version_4": `create type entry_sorting_direction as enum('asc', 'desc');
+alter table users add column entry_direction entry_sorting_direction default 'asc';
+`,
 }
 
 var SqlMapChecksums = map[string]string{
-	"schema_version_1": "cb85ca7dd97a6e1348e00b65ea004253a7165bed9a772746613276e47ef93213",
+	"schema_version_1": "7be580fc8a93db5da54b2f6e87019803c33b0b0c28482c7af80cef873bdac4e2",
 	"schema_version_2": "e8e9ff32478df04fcddad10a34cba2e8bb1e67e7977b5bd6cdc4c31ec94282b4",
 	"schema_version_3": "a54745dbc1c51c000f74d4e5068f1e2f43e83309f023415b1749a47d5c1e0f12",
+	"schema_version_4": "216ea3a7d3e1704e40c797b5dc47456517c27dbb6ca98bf88812f4f63d74b5d9",
 }