From 1eb3012f82ada8c2f6c9a7d48aeaf39d9e07cfcc Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@madoka.volgo-balt.ru>
Date: Wed, 20 Apr 2011 16:17:57 +0400
Subject: schema: add unique constraint on access_key

---
 schema/versions/pgsql/84.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'schema/versions/pgsql/84.sql')

diff --git a/schema/versions/pgsql/84.sql b/schema/versions/pgsql/84.sql
index 85b9cf20a..55a7caf71 100644
--- a/schema/versions/pgsql/84.sql
+++ b/schema/versions/pgsql/84.sql
@@ -4,7 +4,7 @@ create table ttrss_linked_instances (id serial not null primary key,
 	last_connected timestamp not null,
 	last_status_in integer not null,
 	last_status_out integer not null,
-	access_key varchar(250) not null,
+	access_key varchar(250) not null unique,
 	access_url text not null);
 
 create table ttrss_linked_feeds (
-- 
cgit v1.2.3

