summaryrefslogtreecommitdiff
path: root/schema/versions
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2015-11-18 14:33:47 +0300
committerAndrew Dolgov <[email protected]>2015-11-18 14:33:47 +0300
commit6497fb65b439f02cf145c2d0eb4e40803641fbb4 (patch)
tree46d7da0b02152b615f411da6b4ded924e8f22f0c /schema/versions
parentee4c4602726a1d1064c96414a8e4df0308f3be62 (diff)
fix ttrss_feeds.last_update defaulting to 0 on mysql, set to null instead
bump schema
Diffstat (limited to 'schema/versions')
-rw-r--r--schema/versions/mysql/130.sql7
-rw-r--r--schema/versions/pgsql/130.sql5
2 files changed, 12 insertions, 0 deletions
diff --git a/schema/versions/mysql/130.sql b/schema/versions/mysql/130.sql
new file mode 100644
index 000000000..7b90d4d2c
--- /dev/null
+++ b/schema/versions/mysql/130.sql
@@ -0,0 +1,7 @@
+BEGIN;
+
+alter table ttrss_feeds alter column last_updated set default null;
+
+UPDATE ttrss_version SET schema_version = 130;
+
+COMMIT;
diff --git a/schema/versions/pgsql/130.sql b/schema/versions/pgsql/130.sql
new file mode 100644
index 000000000..820f0b6a8
--- /dev/null
+++ b/schema/versions/pgsql/130.sql
@@ -0,0 +1,5 @@
+BEGIN;
+
+UPDATE ttrss_version SET schema_version = 130;
+
+COMMIT;