summaryrefslogtreecommitdiff
path: root/schema/versions
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2013-04-26 14:15:57 +0400
committerAndrew Dolgov <[email protected]>2013-04-26 14:16:03 +0400
commit3fbb4d183d6b0cb4b6d9d2d8d62d635eb70ebf13 (patch)
tree45ccba4bb5c141e107d913cc79df1a3cd64483ca /schema/versions
parent96f0cbe30d05ea41bb95fcc1487e2e2d5c55f966 (diff)
set default timezone to automatic (bump schema)
Diffstat (limited to 'schema/versions')
-rw-r--r--schema/versions/mysql/119.sql7
-rw-r--r--schema/versions/pgsql/119.sql7
2 files changed, 14 insertions, 0 deletions
diff --git a/schema/versions/mysql/119.sql b/schema/versions/mysql/119.sql
new file mode 100644
index 000000000..ddb7d64de
--- /dev/null
+++ b/schema/versions/mysql/119.sql
@@ -0,0 +1,7 @@
+begin;
+
+update ttrss_prefs set def_value = 'Automatic' where pref_name = 'USER_TIMEZONE';
+
+update ttrss_version set schema_version = 119;
+
+commit;
diff --git a/schema/versions/pgsql/119.sql b/schema/versions/pgsql/119.sql
new file mode 100644
index 000000000..ddb7d64de
--- /dev/null
+++ b/schema/versions/pgsql/119.sql
@@ -0,0 +1,7 @@
+begin;
+
+update ttrss_prefs set def_value = 'Automatic' where pref_name = 'USER_TIMEZONE';
+
+update ttrss_version set schema_version = 119;
+
+commit;