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/ttrss_schema_mysql.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'schema/ttrss_schema_mysql.sql')

diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql
index a3a7b695b..61fcff450 100644
--- a/schema/ttrss_schema_mysql.sql
+++ b/schema/ttrss_schema_mysql.sql
@@ -432,7 +432,7 @@ create table ttrss_linked_instances (id integer not null primary key auto_increm
 	last_connected datetime 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) TYPE=InnoDB DEFAULT CHARSET=UTF8;
 
 create table ttrss_linked_feeds (
-- 
cgit v1.2.3-54-g00ecf

