<?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 Version20220922003005 extends AbstractMigration
{
public function getDescription(): string
{
return '';
}
public function up(Schema $schema): void
{
// this up() migration is auto-generated, please modify it to your needs
$this->addSql('ALTER TABLE `workflow_status_main` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `user_workflow_status_restricted` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `user_prefs` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `user_holidays` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `users_selections` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `timemeister_log` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `template_sel_priority` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `template_sel_library` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `template_sel_in_the_loop` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `template_sel_eta` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `template_sel_date_done` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `template_sel_date_dev` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `template_sel_assigned_to` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `template_sel_assigned_by` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `template_refs` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `template_notes` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `template_description_and_name` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `templates` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `techsupp_request_types` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `techsupp_reqforms_notes` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `techsupp_reqforms` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `techsupp_form_reqtypes_assoc` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `techsupp_forms` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `task_worked_hours_dates` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `task_refs` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `task_notes` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `task_list_table_columns_selections` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `task_list_table_columns` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `task_custom_field_definitions` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `task_custom_fields_picklists_options` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `task_custom_fields` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `tasks_worked_hours` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `tasks` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `states` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `shared_calendar_companies` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `shared_calendar` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `sel_types` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `sel_status` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `sel_projects` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `sel_departments` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `pretask_notes` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `pretask_criteria` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `pretasks` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `log_slowpages` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `inh_sel_types` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `inh_sel_projects` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `inh_sel_departments` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `inh_saved_sels` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `inheritances` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `figment_user_permission` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `figment_refs` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `figment_info` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `figment_groups` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `figments` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `event_tasks` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `event_notify` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `event_notes` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `event_locations` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `event_holiday_types` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `events` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `eTaskBoard_workers_ref` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `eTaskBoard_workers_interest` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `eTaskBoard_workers_experience` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `eTaskBoard_workers_criteria` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `eTaskBoard_workers` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `eTaskBoard_time` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `eTaskBoard_task_interest` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `eTaskBoard_task_criteria` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `eTaskBoard_phone_types` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `eTaskBoard_phones` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `eTaskBoard_payment` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `eTaskBoard_experience_time` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `eTaskBoard_experience` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `eTaskBoard_availability` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `eTaskBoard_address_types` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `eTaskBoard_address_ind` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `description_guide_contents` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `description_guides` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `criteria_duration` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `criteria` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `countries` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `company_prefs` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `bugs` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `attachment_usage` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `attachment_types` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `attachment_downloads` ENGINE=InnoDB;');
$this->addSql('ALTER TABLE `attachments` ENGINE=InnoDB;');
//---------------------------------------------
$this->addSql('DROP INDEX id_2 ON event_notes');
$this->addSql('DROP INDEX id_2 ON events');
$this->addSql('DROP INDEX id_2 ON inh_sel_departments');
$this->addSql('DROP INDEX id_2 ON inh_sel_projects');
$this->addSql('DROP INDEX id_2 ON inh_sel_types');
$this->addSql('ALTER TABLE pdf_files CHANGE main_task_id main_task_id INT DEFAULT NULL, CHANGE ocr_task_id ocr_task_id INT DEFAULT NULL, CHANGE ocr_qa_task_id ocr_qa_task_id INT DEFAULT NULL, CHANGE remediation_task_id remediation_task_id INT DEFAULT NULL, CHANGE final_qa_task_id final_qa_task_id INT DEFAULT NULL, CHANGE filename filename VARCHAR(255) NOT NULL');
$this->addSql('ALTER TABLE pdf_folders CHANGE path path VARCHAR(255) NOT NULL');
$this->addSql('DROP INDEX id_2 ON pretasks');
$this->addSql('DROP INDEX id_2 ON sel_departments');
$this->addSql('DROP INDEX id_2 ON sel_projects');
$this->addSql('DROP INDEX id_2 ON sel_status');
$this->addSql('DROP INDEX id_2 ON sel_types');
$this->addSql('ALTER TABLE shared_calendar CHANGE user_id user_id INT AUTO_INCREMENT NOT NULL');
$this->addSql('ALTER TABLE task_note_security_levels CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE task_note_id task_note_id INT NOT NULL, CHANGE group_id group_id INT NOT NULL');
$this->addSql('CREATE UNIQUE INDEX id ON task_note_security_levels (id)');
$this->addSql('DROP INDEX id_2 ON task_notes');
$this->addSql('ALTER TABLE task_notes CHANGE edit_count edit_count INT UNSIGNED DEFAULT 0');
$this->addSql('ALTER TABLE task_notifications CHANGE notification_name notification_name VARCHAR(191) DEFAULT \'\' NOT NULL, CHANGE notification_value notification_value LONGTEXT NOT NULL');
$this->addSql('DROP INDEX id_2 ON tasks');
$this->addSql('ALTER TABLE techsupp_form_reqtypes_assoc ADD id INT AUTO_INCREMENT NOT NULL, ADD PRIMARY KEY (id)');
$this->addSql('DROP INDEX id_2 ON techsupp_reqforms_notes');
$this->addSql('DROP INDEX id_2 ON template_notes');
$this->addSql('DROP INDEX id_2 ON template_sel_assigned_by');
$this->addSql('DROP INDEX id_2 ON template_sel_assigned_to');
$this->addSql('DROP INDEX id_2 ON template_sel_date_dev');
$this->addSql('DROP INDEX id_2 ON template_sel_date_done');
$this->addSql('DROP INDEX id_2 ON template_sel_eta');
$this->addSql('DROP INDEX id_2 ON template_sel_in_the_loop');
$this->addSql('DROP INDEX id_2 ON template_sel_library');
$this->addSql('DROP INDEX id_2 ON template_sel_priority');
$this->addSql('DROP INDEX id_2 ON templates');
$this->addSql('ALTER TABLE user_log CHANGE user_id user_id INT UNSIGNED AUTO_INCREMENT NOT NULL');
$this->addSql('ALTER TABLE users_events ADD id INT AUTO_INCREMENT NOT NULL, ADD PRIMARY KEY (id)');
$this->addSql('DROP INDEX id_2 ON users_selections');
}
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
$this->addSql('CREATE INDEX id_2 ON taskmeister.event_notes (id)');
$this->addSql('CREATE INDEX id_2 ON taskmeister.events (id)');
$this->addSql('CREATE INDEX id_2 ON taskmeister.inh_sel_departments (id)');
$this->addSql('CREATE INDEX id_2 ON taskmeister.inh_sel_projects (id)');
$this->addSql('CREATE INDEX id_2 ON taskmeister.inh_sel_types (id)');
$this->addSql('ALTER TABLE taskmeister.pdf_files CHANGE main_task_id main_task_id INT UNSIGNED DEFAULT NULL, CHANGE ocr_task_id ocr_task_id INT UNSIGNED DEFAULT NULL, CHANGE ocr_qa_task_id ocr_qa_task_id INT UNSIGNED DEFAULT NULL, CHANGE remediation_task_id remediation_task_id INT UNSIGNED DEFAULT NULL, CHANGE final_qa_task_id final_qa_task_id INT UNSIGNED DEFAULT NULL, CHANGE filename filename VARCHAR(255) CHARACTER SET utf8 NOT NULL COLLATE `utf8_bin`');
$this->addSql('ALTER TABLE taskmeister.pdf_folders CHANGE path path VARCHAR(255) CHARACTER SET utf8 NOT NULL COLLATE `utf8_bin`');
$this->addSql('CREATE INDEX id_2 ON taskmeister.pretasks (id)');
$this->addSql('CREATE INDEX id_2 ON taskmeister.sel_departments (id)');
$this->addSql('CREATE INDEX id_2 ON taskmeister.sel_projects (id)');
$this->addSql('CREATE INDEX id_2 ON taskmeister.sel_status (id)');
$this->addSql('CREATE INDEX id_2 ON taskmeister.sel_types (id)');
$this->addSql('ALTER TABLE taskmeister.shared_calendar CHANGE user_id user_id INT DEFAULT 0 NOT NULL');
$this->addSql('DROP INDEX id ON taskmeister.task_note_security_levels');
$this->addSql('ALTER TABLE taskmeister.task_note_security_levels CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL, CHANGE task_note_id task_note_id INT UNSIGNED NOT NULL, CHANGE group_id group_id INT UNSIGNED NOT NULL');
$this->addSql('ALTER TABLE taskmeister.task_notes CHANGE edit_count edit_count INT DEFAULT 0');
$this->addSql('CREATE INDEX id_2 ON taskmeister.task_notes (id)');
$this->addSql('ALTER TABLE taskmeister.task_notifications CHANGE notification_name notification_name VARCHAR(191) CHARACTER SET utf8mb4 DEFAULT \'\' NOT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE notification_value notification_value LONGTEXT CHARACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_unicode_ci`');
$this->addSql('CREATE INDEX id_2 ON taskmeister.tasks (id)');
$this->addSql('ALTER TABLE taskmeister.techsupp_form_reqtypes_assoc MODIFY id INT NOT NULL');
$this->addSql('DROP INDEX `primary` ON taskmeister.techsupp_form_reqtypes_assoc');
$this->addSql('ALTER TABLE taskmeister.techsupp_form_reqtypes_assoc DROP id');
$this->addSql('CREATE INDEX id_2 ON taskmeister.techsupp_reqforms_notes (id)');
$this->addSql('CREATE INDEX id_2 ON taskmeister.template_notes (id)');
$this->addSql('CREATE INDEX id_2 ON taskmeister.template_sel_assigned_by (id)');
$this->addSql('CREATE INDEX id_2 ON taskmeister.template_sel_assigned_to (id)');
$this->addSql('CREATE INDEX id_2 ON taskmeister.template_sel_date_dev (id)');
$this->addSql('CREATE INDEX id_2 ON taskmeister.template_sel_date_done (id)');
$this->addSql('CREATE INDEX id_2 ON taskmeister.template_sel_eta (id)');
$this->addSql('CREATE INDEX id_2 ON taskmeister.template_sel_in_the_loop (id)');
$this->addSql('CREATE INDEX id_2 ON taskmeister.template_sel_library (id)');
$this->addSql('CREATE INDEX id_2 ON taskmeister.template_sel_priority (id)');
$this->addSql('CREATE INDEX id_2 ON taskmeister.templates (id)');
$this->addSql('ALTER TABLE taskmeister.user_log CHANGE user_id user_id INT UNSIGNED NOT NULL');
$this->addSql('ALTER TABLE taskmeister.users_events MODIFY id INT NOT NULL');
$this->addSql('DROP INDEX `primary` ON taskmeister.users_events');
$this->addSql('ALTER TABLE taskmeister.users_events DROP id');
$this->addSql('CREATE INDEX id_2 ON taskmeister.users_selections (id)');
}
}