From 378ba01ba8a4b67fb5d01dd5adc57fb72e3c86a5 Mon Sep 17 00:00:00 2001 From: Scott Ostler Date: Fri, 11 Jun 2010 15:07:46 -0400 Subject: load testing code --- db/0-create.psql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'db') 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); -- cgit v1.2.3-70-g09d2