load testing code

1 files changed, 2 insertions, 2 deletions

diff --git a/db/0-create.psql b/db/0-create.psql
index 01831e5..4725c08 100644
--- a/db/0-create.psql
+++ b/db/0-create.psql
@@ -91,7 +91,7 @@ CREATE TABLE feed_images (
   room text NOT NULL,
   message_id integer REFERENCES messages,
   queued_on timestamp NOT NULL DEFAULT now(),
-  UNIQUE (room, image_url)
+  PRIMARY KEY (room, image_url)
 );
 
 CREATE INDEX feed_images_url_room_idx ON feed_images (image_url, room);
@@ -101,7 +101,7 @@ CREATE TABLE invalid_feed_images (
   image_url text NOT NULL,
   reason text NOT NULL,
   added_on timestamp NOT NULL DEFAULT now(),
-  UNIQUE (image_url)
+  PRIMARY KEY (image_url)
 );
 
 CREATE INDEX invalid_feed_images_idx ON invalid_feed_images (image_url);