summaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2019-03-06 19:42:27 +0300
committerAndrew Dolgov <[email protected]>2019-03-06 19:42:27 +0300
commit0881d0a00d8941a245b9541a880b5d408ad769f4 (patch)
treea6568474e2afe19b8b10e5cd1a98794b948b4ece /schema
parent0d04e21006a3b7bb5c52a927c24a960aa6d347a4 (diff)
some dbupdater improvements; fix schema 136 syntax for mysql
Diffstat (limited to 'schema')
-rw-r--r--schema/versions/mysql/136.sql6
1 files changed, 3 insertions, 3 deletions
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;