Adding forum / community pages

- Adding main forum page. Fixes #11
- Adding view version for posts. #21
- Got rid of fedi user ids. Fixes #22
- Post sorting working. Fixes #24

1 files changed, 7 insertions, 3 deletions

diff --git a/server/migrations/2019-02-26-002946_create_user/up.sql b/server/migrations/2019-02-26-002946_create_user/up.sql
index d4edb370..80e6e92a 100644
--- a/server/migrations/2019-02-26-002946_create_user/up.sql
+++ b/server/migrations/2019-02-26-002946_create_user/up.sql
@@ -1,10 +1,14 @@
 create table user_ (
   id serial primary key,
-  name varchar(20) not null unique,
+  name varchar(20) not null,
+  fedi_name varchar(40) not null,
   preferred_username varchar(20),
   password_encrypted text not null,
   email text unique,
   icon bytea,
   published timestamp not null default now(),
-  updated timestamp
-)
+  updated timestamp,
+  unique(name, fedi_name)
+);
+
+insert into user_ (name, fedi_name, password_encrypted) values ('admin', 'TBD', 'TBD');