diff options
| author | Mario Vavti <mario@mariovavti.com> | 2018-03-02 11:38:21 +0100 |
|---|---|---|
| committer | Mario Vavti <mario@mariovavti.com> | 2018-03-02 13:10:44 +0100 |
| commit | 83365840af63b655ae83f263fbb9bd3d6b5fddd4 (patch) | |
| tree | e0dc79baa728d936cd27a80c22d6478765f96b4d /Zotlabs/Update/_1205.php | |
| parent | b44e46f8be648f4ae1f6015eb4643de70b793b1e (diff) | |
| download | volse-hubzilla-83365840af63b655ae83f263fbb9bd3d6b5fddd4.tar.gz volse-hubzilla-83365840af63b655ae83f263fbb9bd3d6b5fddd4.tar.bz2 volse-hubzilla-83365840af63b655ae83f263fbb9bd3d6b5fddd4.zip | |
update DB update 1205 to mitigate
ERROR 1069 (42000): Too many keys specified; max 64 keys allowed
Diffstat (limited to 'Zotlabs/Update/_1205.php')
| -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), |