From 0881d0a00d8941a245b9541a880b5d408ad769f4 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Wed, 6 Mar 2019 19:42:27 +0300 Subject: some dbupdater improvements; fix schema 136 syntax for mysql --- schema/versions/mysql/136.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'schema') diff --git a/schema/versions/mysql/136.sql b/schema/versions/mysql/136.sql index b4dd70d9b..36539537b 100644 --- a/schema/versions/mysql/136.sql +++ b/schema/versions/mysql/136.sql @@ -1,9 +1,9 @@ begin; alter table ttrss_archived_feeds add column created datetime; -update ttrss_version set schema_version = 136; -alter table ttrss_archived_feeds alter column created set not null; - update ttrss_archived_feeds set created = NOW(); +alter table ttrss_archived_feeds change created created bool not null; + +update ttrss_version set schema_version = 136; commit; -- cgit v1.2.3