add ttrss_feed_categories.parent_cat, bump schema

2 files changed, 20 insertions, 0 deletions

diff --git a/schema/versions/mysql/93.sql b/schema/versions/mysql/93.sql
new file mode 100644
index 000000000..56b96e3b5
--- /dev/null
+++ b/schema/versions/mysql/93.sql
@@ -0,0 +1,10 @@
+begin;
+
+alter table ttrss_feed_categories add column parent_cat integer;
+update ttrss_feed_categories set parent_cat = NULL;
+
+alter table ttrss_feed_categories add FOREIGN KEY (parent_cat) REFERENCES ttrss_feed_categories(id) ON DELETE SET NULL;
+
+update ttrss_version set schema_version = 93;
+
+commit;
diff --git a/schema/versions/pgsql/93.sql b/schema/versions/pgsql/93.sql
new file mode 100644
index 000000000..0374c0b0a
--- /dev/null
+++ b/schema/versions/pgsql/93.sql
@@ -0,0 +1,10 @@
+begin;
+
+alter table ttrss_feed_categories add column parent_cat integer;
+update ttrss_feed_categories set parent_cat = NULL;
+
+alter table ttrss_feed_categories add constraint "$2" FOREIGN KEY (parent_cat) REFERENCES ttrss_feed_categories(id) ON DELETE SET NULL;
+
+update ttrss_version set schema_version = 93;
+
+commit;