diff options
Diffstat (limited to 'schema/versions')
-rw-r--r-- | schema/versions/mysql/137.sql | 7 | ||||
-rw-r--r-- | schema/versions/pgsql/137.sql | 7 |
2 files changed, 14 insertions, 0 deletions
diff --git a/schema/versions/mysql/137.sql b/schema/versions/mysql/137.sql new file mode 100644 index 000000000..35dc769b6 --- /dev/null +++ b/schema/versions/mysql/137.sql @@ -0,0 +1,7 @@ +begin; + +alter table ttrss_feeds add constraint ttrss_feeds_feed_url_owner_uid_key unique (feed_url(254), owner_uid); + +update ttrss_version set schema_version = 137; + +commit; diff --git a/schema/versions/pgsql/137.sql b/schema/versions/pgsql/137.sql new file mode 100644 index 000000000..71b67327e --- /dev/null +++ b/schema/versions/pgsql/137.sql @@ -0,0 +1,7 @@ +begin; + +alter table ttrss_feeds add constraint ttrss_feeds_feed_url_owner_uid_key unique (feed_url, owner_uid); + +update ttrss_version set schema_version = 137; + +commit; |