diff options
| author | Mario Vavti <mario@mariovavti.com> | 2018-03-02 11:38:21 +0100 |
|---|---|---|
| committer | Mario Vavti <mario@mariovavti.com> | 2018-03-02 11:38:21 +0100 |
| commit | 5c46e66694ecab4e986cada35527ae4bf599b630 (patch) | |
| tree | 7a373ab0c7b27085dd3a2155df640786c3ccb5aa /Zotlabs/Update | |
| parent | bca05dc89f2e44c937f6a1bf4e8a6136060c5db8 (diff) | |
| download | volse-hubzilla-5c46e66694ecab4e986cada35527ae4bf599b630.tar.gz volse-hubzilla-5c46e66694ecab4e986cada35527ae4bf599b630.tar.bz2 volse-hubzilla-5c46e66694ecab4e986cada35527ae4bf599b630.zip | |
update DB update 1205 to mitigate
ERROR 1069 (42000): Too many keys specified; max 64 keys allowed
Diffstat (limited to 'Zotlabs/Update')
| -rw-r--r-- | Zotlabs/Update/_1205.php | 11 |
1 files changed, 11 insertions, 0 deletions
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), |