From 6ee6285670be27bbcf8565dd63af57a93673972b Mon Sep 17 00:00:00 2001 From: Mario Vavti Date: Fri, 2 Mar 2018 10:10:29 +0100 Subject: db update to drop index resource_type. we have uid_resource_type now. --- Zotlabs/Update/_1207.php | 24 ++++++++++++++++++++++++ 1 file changed, 24 insertions(+) create mode 100644 Zotlabs/Update/_1207.php (limited to 'Zotlabs/Update') diff --git a/Zotlabs/Update/_1207.php b/Zotlabs/Update/_1207.php new file mode 100644 index 000000000..f53bc46ae --- /dev/null +++ b/Zotlabs/Update/_1207.php @@ -0,0 +1,24 @@ + Date: Fri, 2 Mar 2018 11:38:21 +0100 Subject: update DB update 1205 to mitigate ERROR 1069 (42000): Too many keys specified; max 64 keys allowed --- Zotlabs/Update/_1205.php | 11 +++++++++++ 1 file changed, 11 insertions(+) (limited to 'Zotlabs/Update') diff --git a/Zotlabs/Update/_1205.php b/Zotlabs/Update/_1205.php index 5384f183e..968833726 100644 --- a/Zotlabs/Update/_1205.php +++ b/Zotlabs/Update/_1205.php @@ -7,6 +7,17 @@ class _1205 { function run() { if(ACTIVE_DBTYPE == DBTYPE_MYSQL) { + + q("ALTER TABLE item DROP INDEX title"); + q("ALTER TABLE item DROP INDEX body"); + q("ALTER TABLE item DROP INDEX allow_cid"); + q("ALTER TABLE item DROP INDEX allow_gid"); + q("ALTER TABLE item DROP INDEX deny_cid"); + q("ALTER TABLE item DROP INDEX deny_gid"); + q("ALTER TABLE item DROP INDEX item_flags"); + q("ALTER TABLE item DROP INDEX item_restrict"); + q("ALTER TABLE item DROP INDEX aid"); + $r = q("ALTER TABLE item DROP INDEX item_private, ADD INDEX uid_item_private (uid, item_private), -- cgit v1.2.3