<?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 Version20220414110100 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("INSERT INTO `role` (`id`, `name`) VALUES
(1, 'ROLE_ADMIN'),
(2, 'ROLE_USER')");
$this->addSql("INSERT INTO `user` (`id`, `email`, `password`, `name`, `status`, `token`, `date_added`, `date_modified`) VALUES
(1, 'user1@repatriot.ro', '\$argon2id\$v=19\$m=65536,t=4,p=1\$Vy8l7oql0mEIi965appppw\$NqdYtdQ9+fYiBH3TD3NxUoNQSCD8Hvs0AXEky4Wh6Os', 'Repatriot 1', 1, 'a02254dcfc9d02d658c8f97d0fa82d1e', '2019-09-27 05:30:57', '2019-09-27 05:30:57'),
(2, 'user2@repatriot.ro', '\$argon2id\$v=19\$m=65536,t=4,p=1\$NDk+9FgCzgSoepfw3eXGZA\$uSGBKuLED6SU0KgKQy186zYk1bbReyoshnTiLZupbsE', 'Repatriot 2', 1, 'cd31b896edac4e5ea34385f9c14767ec', '2019-09-27 05:31:25', '2019-09-27 05:31:25')");
$this->addSql("INSERT INTO `user_role` (`user_id`, `role_id`) VALUES
(1, 1),
(2, 2)");
$this->addSql('INSERT INTO `setting` (name,value, translation_key) VALUES
("logo","/default_logo.png","settings.logo"),
("printing_active","0","settings.printing"),
("app_name","Aplicatie","settings.app_name"),
("favicon", "/favicon.ico", "settings.favicon")');
$this->addSql("INSERT INTO email_template (id, header_id, footer_id, title, `body`, type, `status`, `email_trigger_id`) VALUES (1, NULL, NULL, 'Default Header', '', 1, 1, NULL);");
$this->addSql("INSERT INTO email_template (id, header_id, footer_id, title, `body`, type, `status`, `email_trigger_id`) VALUES (2, NULL, NULL, 'Default Footer', '', 2, 1, NULL);");
$this->addSql("INSERT INTO email_template (id, header_id, footer_id, title, `body`, type, `status`, `email_trigger_id`) VALUES (3, 1, 2, 'Default Body', '<p>###participantName###</p>
<p>###participantCompany###</p>
<p>###participantQRcode###</p>', 3, 1, NULL);");
$this->addSql("INSERT INTO email_trigger (id, name, `status`) VALUES (1, 'QR', 1);");
$this->addSql("UPDATE `email_template` SET `email_trigger_id` = '1' WHERE `email_template`.`id` = 3;");
}
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
}
}