Adding a few endpoints.

- Adding CreatePost, CreateComment, CreateCommunity

1 files changed, 3 insertions, 1 deletions

diff --git a/server/migrations/2019-03-03-163336_create_post/up.sql b/server/migrations/2019-03-03-163336_create_post/up.sql
index a617ea33..f22192f3 100644
--- a/server/migrations/2019-03-03-163336_create_post/up.sql
+++ b/server/migrations/2019-03-03-163336_create_post/up.sql
@@ -1,8 +1,10 @@
 create table post (
   id serial primary key,
   name varchar(100) not null,
-  url text not null,
+  url text, -- These are both optional, a post can just have a title
+  body text,
   attributed_to text not null,
+  community_id int references community on update cascade on delete cascade not null,
   published timestamp not null default now(),
   updated timestamp
 );