<?php
declare(strict_types=1);
namespace DoctrineMigrations;
use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;
/**
* Auto-generated Migration: Please modify to your needs!
*/
final class Version20240927061039 extends AbstractMigration
{
public function getDescription(): string
{
return '';
}
public function up(Schema $schema): void
{
$this->addSql("UPDATE `user` SET `roles` = '[\"ROLE_USER_MANAGEMENT_ADMIN\",\"ROLE_USER_PRIVILEGE_ADMIN\",\"ROLE_ACCOUNT_SETTINGS_ADMIN\",\"ROLE_PRODUCT_MANAGEMENT_ADMIN\",\"ROLE_PRODUCT_VARIANT_MANAGEMENT_ADMIN\",\"ROLE_CUSTOMER_MANAGEMENT_ADMIN\",\"ROLE_BOARD_SETTINGS_ADMIN\",\"ROLE_ASSY_STOCK_MANAGEMENT_ADMIN\",\"ROLE_SMT_STOCK_MANAGEMENT_ADMIN\",\"ROLE_DAILY_PLAN_ADMIN\",\"ROLE_WORKORDER_DETAILS_ADMIN\",\"ROLE_DOWNTIME_PLANNING_ADMIN\",\"ROLE_IMPORT_HISTORY_ADMIN\",\"ROLE_RUNNING_ORDER_ADMIN\",\"ROLE_MASTER_PRODUCTION_SCHEDLE_REPORT_ADMIN\",\"ROLE_ACTIVITY_LOG_ADMIN\",\"ROLE_MANAGE_SHIFT_ADMIN\",\"ROLE_OEE_DAILY_TARGET_ADMIN\"]' WHERE `user`.`roles` = '[\"ROLE_ADMIN\"]';
");
$this->addSql("UPDATE `user` SET `roles` = '[\"ROLE_USER_MANAGEMENT_VIEW\",\"ROLE_USER_PRIVILEGE_VIEW\",\"ROLE_ACCOUNT_SETTINGS_VIEW\",\"ROLE_PRODUCT_MANAGEMENT_VIEW\",\"ROLE_PRODUCT_VARIANT_MANAGEMENT_VIEW\",\"ROLE_CUSTOMER_MANAGEMENT_VIEW\",\"ROLE_BOARD_SETTINGS_VIEW\",\"ROLE_ASSY_STOCK_MANAGEMENT_VIEW\",\"ROLE_SMT_STOCK_MANAGEMENT_VIEW\",\"ROLE_DAILY_PLAN_VIEW\",\"ROLE_WORKORDER_DETAILS_VIEW\",\"ROLE_DOWNTIME_PLANNING_VIEW\",\"ROLE_IMPORT_HISTORY_VIEW\",\"ROLE_RUNNING_ORDER_VIEW\",\"ROLE_MASTER_PRODUCTION_SCHEDLE_REPORT_VIEW\",\"ROLE_ACTIVITY_LOG_VIEW\",\"ROLE_MANAGE_SHIFT_VIEW\",\"ROLE_OEE_DAILY_TARGET_VIEW\"]' WHERE `user`.`roles` = '[\"ROLE_USER\"]';
");
$this->addSql("UPDATE `tc_user_type` SET `roles` = '[\"ROLE_USER_MANAGEMENT_ADMIN\",\"ROLE_USER_PRIVILEGE_ADMIN\",\"ROLE_ACCOUNT_SETTINGS_ADMIN\",\"ROLE_PRODUCT_MANAGEMENT_ADMIN\",\"ROLE_PRODUCT_VARIANT_MANAGEMENT_ADMIN\",\"ROLE_CUSTOMER_MANAGEMENT_ADMIN\",\"ROLE_BOARD_SETTINGS_ADMIN\",\"ROLE_ASSY_STOCK_MANAGEMENT_ADMIN\",\"ROLE_SMT_STOCK_MANAGEMENT_ADMIN\",\"ROLE_DAILY_PLAN_ADMIN\",\"ROLE_WORKORDER_DETAILS_ADMIN\",\"ROLE_DOWNTIME_PLANNING_ADMIN\",\"ROLE_IMPORT_HISTORY_ADMIN\",\"ROLE_RUNNING_ORDER_ADMIN\",\"ROLE_MASTER_PRODUCTION_SCHEDLE_REPORT_ADMIN\",\"ROLE_ACTIVITY_LOG_ADMIN\",\"ROLE_MANAGE_SHIFT_ADMIN\",\"ROLE_OEE_DAILY_TARGET_ADMIN\"]' WHERE `tc_user_type`.`roles` = '[\"ROLE_ADMIN\"]';
");
$this->addSql("UPDATE `tc_user_type` SET `roles` = '[\"ROLE_USER_MANAGEMENT_VIEW\",\"ROLE_USER_PRIVILEGE_VIEW\",\"ROLE_ACCOUNT_SETTINGS_VIEW\",\"ROLE_PRODUCT_MANAGEMENT_VIEW\",\"ROLE_PRODUCT_VARIANT_MANAGEMENT_VIEW\",\"ROLE_CUSTOMER_MANAGEMENT_VIEW\",\"ROLE_BOARD_SETTINGS_VIEW\",\"ROLE_ASSY_STOCK_MANAGEMENT_VIEW\",\"ROLE_SMT_STOCK_MANAGEMENT_VIEW\",\"ROLE_DAILY_PLAN_VIEW\",\"ROLE_WORKORDER_DETAILS_VIEW\",\"ROLE_DOWNTIME_PLANNING_VIEW\",\"ROLE_IMPORT_HISTORY_VIEW\",\"ROLE_RUNNING_ORDER_VIEW\",\"ROLE_MASTER_PRODUCTION_SCHEDLE_REPORT_VIEW\",\"ROLE_ACTIVITY_LOG_VIEW\",\"ROLE_MANAGE_SHIFT_VIEW\",\"ROLE_OEE_DAILY_TARGET_VIEW\"]' WHERE `tc_user_type`.`roles` = '[\"ROLE_USER\"]';
");
}
public function down(Schema $schema): void
{
$this->addSql("UPDATE `user` SET `roles` = '[\"ROLE_ADMIN\"]' WHERE `roles` = '[\"ROLE_USER_MANAGEMENT_ADMIN\",\"ROLE_USER_PRIVILEGE_ADMIN\",\"ROLE_ACCOUNT_SETTINGS_ADMIN\",\"ROLE_PRODUCT_MANAGEMENT_ADMIN\",\"ROLE_PRODUCT_VARIANT_MANAGEMENT_ADMIN\",\"ROLE_CUSTOMER_MANAGEMENT_ADMIN\",\"ROLE_BOARD_SETTINGS_ADMIN\",\"ROLE_ASSY_STOCK_MANAGEMENT_ADMIN\",\"ROLE_SMT_STOCK_MANAGEMENT_ADMIN\",\"ROLE_DAILY_PLAN_ADMIN\",\"ROLE_WORKORDER_DETAILS_ADMIN\",\"ROLE_DOWNTIME_PLANNING_ADMIN\",\"ROLE_IMPORT_HISTORY_ADMIN\",\"ROLE_RUNNING_ORDER_ADMIN\",\"ROLE_MASTER_PRODUCTION_SCHEDLE_REPORT_ADMIN\",\"ROLE_ACTIVITY_LOG_ADMIN\",\"ROLE_MANAGE_SHIFT_ADMIN\",\"ROLE_OEE_DAILY_TARGET_ADMIN\"]';
");
$this->addSql("UPDATE `user` SET `roles` = '[\"ROLE_USER\"]' WHERE `roles` = '[\"ROLE_USER_MANAGEMENT_VIEW\",\"ROLE_USER_PRIVILEGE_VIEW\",\"ROLE_ACCOUNT_SETTINGS_VIEW\",\"ROLE_PRODUCT_MANAGEMENT_VIEW\",\"ROLE_PRODUCT_VARIANT_MANAGEMENT_VIEW\",\"ROLE_CUSTOMER_MANAGEMENT_VIEW\",\"ROLE_BOARD_SETTINGS_VIEW\",\"ROLE_ASSY_STOCK_MANAGEMENT_VIEW\",\"ROLE_SMT_STOCK_MANAGEMENT_VIEW\",\"ROLE_DAILY_PLAN_VIEW\",\"ROLE_WORKORDER_DETAILS_VIEW\",\"ROLE_DOWNTIME_PLANNING_VIEW\",\"ROLE_IMPORT_HISTORY_VIEW\",\"ROLE_RUNNING_ORDER_VIEW\",\"ROLE_MASTER_PRODUCTION_SCHEDLE_REPORT_VIEW\",\"ROLE_ACTIVITY_LOG_VIEW\",\"ROLE_MANAGE_SHIFT_VIEW\",\"ROLE_OEE_DAILY_TARGET_VIEW\"]';
");
$this->addSql("UPDATE `tc_user_type` SET `roles` = '[\"ROLE_ADMIN\"]' WHERE `roles` = '[\"ROLE_USER_MANAGEMENT_ADMIN\",\"ROLE_USER_PRIVILEGE_ADMIN\",\"ROLE_ACCOUNT_SETTINGS_ADMIN\",\"ROLE_PRODUCT_MANAGEMENT_ADMIN\",\"ROLE_PRODUCT_VARIANT_MANAGEMENT_ADMIN\",\"ROLE_CUSTOMER_MANAGEMENT_ADMIN\",\"ROLE_BOARD_SETTINGS_ADMIN\",\"ROLE_ASSY_STOCK_MANAGEMENT_ADMIN\",\"ROLE_SMT_STOCK_MANAGEMENT_ADMIN\",\"ROLE_DAILY_PLAN_ADMIN\",\"ROLE_WORKORDER_DETAILS_ADMIN\",\"ROLE_DOWNTIME_PLANNING_ADMIN\",\"ROLE_IMPORT_HISTORY_ADMIN\",\"ROLE_RUNNING_ORDER_ADMIN\",\"ROLE_MASTER_PRODUCTION_SCHEDLE_REPORT_ADMIN\",\"ROLE_ACTIVITY_LOG_ADMIN\",\"ROLE_MANAGE_SHIFT_ADMIN\",\"ROLE_OEE_DAILY_TARGET_ADMIN\"]';
");
$this->addSql("UPDATE `tc_user_type` SET `roles` = '[\"ROLE_USER\"]' WHERE `roles` = '[\"ROLE_USER_MANAGEMENT_VIEW\",\"ROLE_USER_PRIVILEGE_VIEW\",\"ROLE_ACCOUNT_SETTINGS_VIEW\",\"ROLE_PRODUCT_MANAGEMENT_VIEW\",\"ROLE_PRODUCT_VARIANT_MANAGEMENT_VIEW\",\"ROLE_CUSTOMER_MANAGEMENT_VIEW\",\"ROLE_BOARD_SETTINGS_VIEW\",\"ROLE_ASSY_STOCK_MANAGEMENT_VIEW\",\"ROLE_SMT_STOCK_MANAGEMENT_VIEW\",\"ROLE_DAILY_PLAN_VIEW\",\"ROLE_WORKORDER_DETAILS_VIEW\",\"ROLE_DOWNTIME_PLANNING_VIEW\",\"ROLE_IMPORT_HISTORY_VIEW\",\"ROLE_RUNNING_ORDER_VIEW\",\"ROLE_MASTER_PRODUCTION_SCHEDLE_REPORT_VIEW\",\"ROLE_ACTIVITY_LOG_VIEW\",\"ROLE_MANAGE_SHIFT_VIEW\",\"ROLE_OEE_DAILY_TARGET_VIEW\"]';
");
}
}