From c1cd3324e3986967d4210e6e36bf068417b7cd13 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Sat, 27 Feb 2021 11:04:25 +0300 Subject: bump schema for ttrss_user_labels2 indexes --- schema/versions/mysql/142.sql | 4 ++++ schema/versions/pgsql/142.sql | 4 ++++ 2 files changed, 8 insertions(+) create mode 100644 schema/versions/mysql/142.sql create mode 100644 schema/versions/pgsql/142.sql (limited to 'schema/versions') diff --git a/schema/versions/mysql/142.sql b/schema/versions/mysql/142.sql new file mode 100644 index 000000000..7a75f3f52 --- /dev/null +++ b/schema/versions/mysql/142.sql @@ -0,0 +1,4 @@ +create index ttrss_user_labels2_article_id_idx on ttrss_user_labels2(article_id); +create index ttrss_user_labels2_label_id_idx on ttrss_user_labels2(label_id); + +update ttrss_version set schema_version = 142; diff --git a/schema/versions/pgsql/142.sql b/schema/versions/pgsql/142.sql new file mode 100644 index 000000000..7a75f3f52 --- /dev/null +++ b/schema/versions/pgsql/142.sql @@ -0,0 +1,4 @@ +create index ttrss_user_labels2_article_id_idx on ttrss_user_labels2(article_id); +create index ttrss_user_labels2_label_id_idx on ttrss_user_labels2(label_id); + +update ttrss_version set schema_version = 142; -- cgit v1.2.3-54-g00ecf