summaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2006-07-25 09:12:17 +0100
committerAndrew Dolgov <[email protected]>2006-07-25 09:12:17 +0100
commit52c61bf8666e83f6be708b343e957ba6fb54933b (patch)
tree61720efd346551c0547c734c0d6ffc82a538a6f3 /schema
parent4919fb42c91c41baf5cdd07da5cfcf900b22fa6d (diff)
add schema update scripts for 1.2.2
Diffstat (limited to 'schema')
-rw-r--r--schema/upgrade-1.1.7-1.2.2-mysql.sql4
-rw-r--r--schema/upgrade-1.1.7-1.2.2-pgsql.sql8
2 files changed, 12 insertions, 0 deletions
diff --git a/schema/upgrade-1.1.7-1.2.2-mysql.sql b/schema/upgrade-1.1.7-1.2.2-mysql.sql
new file mode 100644
index 000000000..5f0611295
--- /dev/null
+++ b/schema/upgrade-1.1.7-1.2.2-mysql.sql
@@ -0,0 +1,4 @@
+insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('MARK_UNREAD_ON_UPDATE', 1, 'false', 'Set articles as unread on update',3);
+
+update ttrss_version set schema_version = 9;
+
diff --git a/schema/upgrade-1.1.7-1.2.2-pgsql.sql b/schema/upgrade-1.1.7-1.2.2-pgsql.sql
new file mode 100644
index 000000000..d934e293b
--- /dev/null
+++ b/schema/upgrade-1.1.7-1.2.2-pgsql.sql
@@ -0,0 +1,8 @@
+begin;
+
+insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('MARK_UNREAD_ON_UPDATE', 1, 'false', 'Set articles as unread on update',3);
+
+update ttrss_version set schema_version = 9;
+
+commit;
+