summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
authorScott Ostler <scottbot9000@gmail.com>2010-12-03 18:00:43 -0500
committerScott Ostler <scottbot9000@gmail.com>2010-12-03 18:00:43 -0500
commit4ccea08b8edbd3440f23cee2730a62d4013dc6e0 (patch)
tree4ec5b32b9719c9fbdc629b06f324f43a1c0a9f62 /db
parent13541b84837c8f360e2ae825d81ae489691b9e14 (diff)
parent59af476f7d0c29319931102f05b7b6da63c5ee54 (diff)
Merge branch 'master' of ssh://dump.fm/pichat/repo
Diffstat (limited to 'db')
-rw-r--r--db/0-create.psql10
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