diff options
| -rw-r--r-- | Zotlabs/Update/_1213.php | 28 | ||||
| -rwxr-xr-x | boot.php | 2 | ||||
| -rw-r--r-- | install/schema_mysql.sql | 3 |
3 files changed, 30 insertions, 3 deletions
diff --git a/Zotlabs/Update/_1213.php b/Zotlabs/Update/_1213.php new file mode 100644 index 000000000..d396829a6 --- /dev/null +++ b/Zotlabs/Update/_1213.php @@ -0,0 +1,28 @@ +<?php + +namespace Zotlabs\Update; + +class _1213 { + + function run() { + if(ACTIVE_DBTYPE == DBTYPE_MYSQL) { + q("START TRANSACTION"); + + $r = q("ALTER TABLE abconfig + DROP INDEX chan, + DROP INDEX xchan, + ADD INDEX chan_xchan (chan, xchan) + "); + + if($r) { + q("COMMIT"); + return UPDATE_SUCCESS; + } + else { + q("ROLLBACK"); + return UPDATE_FAILED; + } + } + } + +} @@ -54,7 +54,7 @@ define ( 'STD_VERSION', '3.4' ); define ( 'ZOT_REVISION', '6.0a' ); -define ( 'DB_UPDATE_VERSION', 1212 ); +define ( 'DB_UPDATE_VERSION', 1213 ); define ( 'PROJECT_BASE', __DIR__ ); diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql index 1e91619e3..9bf91fc51 100644 --- a/install/schema_mysql.sql +++ b/install/schema_mysql.sql @@ -7,8 +7,7 @@ CREATE TABLE IF NOT EXISTS `abconfig` ( `k` char(191) NOT NULL DEFAULT '', `v` mediumtext NOT NULL, PRIMARY KEY (`id`), - KEY `chan` (`chan`), - KEY `xchan` (`xchan`), + KEY `chan_xchan` (`chan`, `xchan`), KEY `cat` (`cat`), KEY `k` (`k`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; |