diff options
Diffstat (limited to 'db/0-create.psql')
| -rw-r--r-- | db/0-create.psql | 4 |
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); |