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 | |
| parent | bcce39e3d85972a89b683182a9ba245d241852ff (diff) | |
schema: add unique constraint on access_key
Diffstat (limited to 'schema')
| -rw-r--r-- | schema/ttrss_schema_mysql.sql | 2 | ||||
| -rw-r--r-- | schema/ttrss_schema_pgsql.sql | 2 | ||||
| -rw-r--r-- | schema/versions/mysql/84.sql | 2 | ||||
| -rw-r--r-- | schema/versions/pgsql/84.sql | 2 |
4 files changed, 4 insertions, 4 deletions
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 ( diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql index 1e60d3a1b..67fe8a8d0 100644 --- 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 ( 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 ( |