Commit initial vip-only direct messaging

1 files changed, 5 insertions, 5 deletions

diff --git a/db/0-create.psql b/db/0-create.psql
index 4fa8536..762bc3a 100644
--- a/db/0-create.psql
+++ b/db/0-create.psql
@@ -137,11 +137,11 @@ CREATE TABLE invalid_feed_images (
 
 CREATE INDEX invalid_feed_images_idx ON invalid_feed_images (image_url);
 
-CREATE TABLE events (
-  event_id SERIAL PRIMARY KEY,
-  name text NOT NULL,
-  author integer NOT NULL REFERENCES,
-  created_on timestamp NOT NULL DEFAULT now()
+CREATE TABLE direct_messages (
+  dm_id SERIAL PRIMARY KEY,
+  message_id integer NOT NULL REFERENCES messages,
+  author_id integer NOT NULL REFERENCES users,
+  recip_id integer NOT NULL REFERENCES users
 );
 
 -- dont add this yet