diff options
| author | Andrew Dolgov <[email protected]> | 2011-04-20 16:17:57 +0400 |
|---|---|---|
| committer | Andrew Dolgov <[email protected]> | 2011-04-20 16:17:57 +0400 |
| commit | 1eb3012f82ada8c2f6c9a7d48aeaf39d9e07cfcc (patch) | |
| tree | 7990e2ddb1c2fc7b8683ba43e34eae058801a289 /schema/versions | |
| parent | bcce39e3d85972a89b683182a9ba245d241852ff (diff) | |
schema: add unique constraint on access_key
Diffstat (limited to 'schema/versions')
| -rw-r--r-- | schema/versions/mysql/84.sql | 2 | ||||
| -rw-r--r-- | schema/versions/pgsql/84.sql | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/schema/versions/mysql/84.sql b/schema/versions/mysql/84.sql index 3255d6f56..5fe530c94 100644 --- a/schema/versions/mysql/84.sql +++ b/schema/versions/mysql/84.sql @@ -4,7 +4,7 @@ create table ttrss_linked_instances (id integer not null primary key auto_increm 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) TYPE=InnoDB DEFAULT CHARSET=UTF8; create table ttrss_linked_feeds ( 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 ( |