芝麻web文件管理V1.00
编辑当前文件:/home/mgatv524/public_html/sommatv/lib/Upgrade/MyIsamToInnoDbStep.php
store = $store; $this->log = $log; $this->config = $config; } /** * @param \Slim\Helper\Set $container * @throws \Xibo\Exception\NotFoundException */ public function doStep($container) { $sql = ' SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = \'' . $this->config->getDatabaseConfig()['name'] . '\' AND ENGINE = \'MyISAM\' '; foreach ($this->store->select($sql, []) as $table) { $this->store->update('ALTER TABLE `' . $table['TABLE_NAME'] . '` ENGINE=INNODB', []); } } }