schema: add unique constraint on access_key

[tt-rss.git] / schema / ttrss_schema_pgsql.sql

diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql
index 1e60d3a1b257d5a63abe18c61f5210dfd76623d0..67fe8a8d089168731be1a1a541867295afc3ac4f 100644 (file)
--- a/schema/ttrss_schema_pgsql.sql
+++ b/schema/ttrss_schema_pgsql.sql
@@ -392,7 +392,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 (