<?php declare(strict_types=1);
namespace Futi\FaqManagerSW6;
use Doctrine\DBAL\Connection;
use Shopware\Core\Framework\Plugin;
use Shopware\Core\Framework\Plugin\Context\UninstallContext;
class FutiFaqManagerSW6 extends Plugin
{
public function uninstall(UninstallContext $context): void
{
parent::uninstall($context);
if ($context->keepUserData()) {
return;
}
$connection = $this->container->get(Connection::class);
$connection->executeStatement('SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;');
$connection->executeStatement('DROP TABLE IF EXISTS `faq_manager_categories`');
$connection->executeStatement('DROP TABLE IF EXISTS `faq_manager_categories_translation`');
$connection->executeStatement('DROP TABLE IF EXISTS `faq_manager_categories_list`');
$connection->executeStatement('DROP TABLE IF EXISTS `faq_manager_list`');
$connection->executeStatement('DROP TABLE IF EXISTS `faq_manager_list_media`');
$connection->executeStatement('DROP TABLE IF EXISTS `faq_manager_list_category`');
$connection->executeStatement('DROP TABLE IF EXISTS `faq_manager_list_translation`');
$connection->executeStatement('DROP TABLE IF EXISTS `faq_manager_pages`');
$connection->executeStatement('DROP TABLE IF EXISTS `faq_manager_pages_categories`');
$connection->executeStatement('DROP TABLE IF EXISTS `faq_manager_pages_translation`');
$connection->executeStatement('DELETE FROM `seo_url_template` WHERE `route_name`="frontend.faq.page";');
$connection->executeStatement('DELETE FROM `seo_url_template` WHERE `route_name`="frontend.faq.category";');
$connection->executeStatement('DELETE FROM `seo_url_template` WHERE `route_name`="frontend.faq.list";');
$connection->executeStatement('SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;');
}
}