From 43398b8e436a01b921562609a08336fc53f71b79 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Thu, 13 Mar 2008 09:18:21 +0100 Subject: remove limit on ttrss_feeds.feed_url length (closes #199) --- schema/versions/mysql/34.sql | 3 +++ schema/versions/pgsql/34.sql | 7 +++++++ 2 files changed, 10 insertions(+) create mode 100644 schema/versions/mysql/34.sql create mode 100644 schema/versions/pgsql/34.sql (limited to 'schema/versions') diff --git a/schema/versions/mysql/34.sql b/schema/versions/mysql/34.sql new file mode 100644 index 000000000..e591a7a96 --- /dev/null +++ b/schema/versions/mysql/34.sql @@ -0,0 +1,3 @@ +alter table ttrss_feeds change feed_url feed_url text not null; + +update ttrss_version set schema_version = 34; diff --git a/schema/versions/pgsql/34.sql b/schema/versions/pgsql/34.sql new file mode 100644 index 000000000..c8733d430 --- /dev/null +++ b/schema/versions/pgsql/34.sql @@ -0,0 +1,7 @@ +alter table ttrss_feeds rename column feed_url to feed_url_old; +alter table ttrss_feeds add column feed_url text; +update ttrss_feeds set feed_url = feed_url_old; +alter table ttrss_feeds alter column feed_url set not null; +alter table ttrss_feeds drop column feed_url_old; + +update ttrss_version set schema_version = 34; -- cgit v1.2.3