summaryrefslogtreecommitdiff
path: root/schema/versions
diff options
context:
space:
mode:
authorfoobar <[email protected]>2018-04-14 14:11:29 +0200
committerfoobar <[email protected]>2018-04-14 14:11:29 +0200
commit2008ec4ed77b081388a9807c644c8d08209a2af0 (patch)
tree33efb0b5dafa1d81026c1a5ea14f6a35476815b4 /schema/versions
parent963c22646b3e1bd544bd957bf34175b996bd6e53 (diff)
change filter rule regexp type to text
Diffstat (limited to 'schema/versions')
-rw-r--r--schema/versions/mysql/134.sql7
-rw-r--r--schema/versions/pgsql/134.sql7
2 files changed, 14 insertions, 0 deletions
diff --git a/schema/versions/mysql/134.sql b/schema/versions/mysql/134.sql
new file mode 100644
index 000000000..7bbd7662d
--- /dev/null
+++ b/schema/versions/mysql/134.sql
@@ -0,0 +1,7 @@
+BEGIN;
+
+ALTER TABLE ttrss_filters2_rules MODIFY reg_exp text not null;
+
+UPDATE ttrss_version SET schema_version = 134;
+
+COMMIT;
diff --git a/schema/versions/pgsql/134.sql b/schema/versions/pgsql/134.sql
new file mode 100644
index 000000000..036abb126
--- /dev/null
+++ b/schema/versions/pgsql/134.sql
@@ -0,0 +1,7 @@
+BEGIN;
+
+ALTER TABLE ttrss_filters2_rules ALTER COLUMN reg_exp TYPE text;
+
+UPDATE ttrss_version SET schema_version = 134;
+
+COMMIT;