summaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2016-08-17 09:43:22 +0300
committerAndrew Dolgov <[email protected]>2016-08-17 09:43:22 +0300
commit539f6ee6cd09057b779e35fc45c6a3a04f497286 (patch)
tree7d20c88430655041c93df3fad20f5eed373e97f4 /schema
parent5cbd1fe8e4d9a67b002a681ab6bc2bc3ab60c628 (diff)
update schema 128 to properly set ttrss_feeds.last_updated default value to NULL
Diffstat (limited to 'schema')
-rw-r--r--schema/versions/mysql/128.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/schema/versions/mysql/128.sql b/schema/versions/mysql/128.sql
index 0a4d7ab7c..281379bb0 100644
--- a/schema/versions/mysql/128.sql
+++ b/schema/versions/mysql/128.sql
@@ -1,5 +1,8 @@
BEGIN;
+update ttrss_feeds set last_updated = NULL;
+alter table ttrss_feeds modify column last_updated datetime DEFAULT NULL;
+
alter table ttrss_feeds add column feed_language varchar(100);
update ttrss_feeds set feed_language = '';
alter table ttrss_feeds change feed_language feed_language varchar(100) not null;