migrations/Version20231005123457.php line 1

Open in your IDE?
  1. <?php 
    declare(strict_types=1);
    
    namespace DoctrineMigrations;
    
    use Doctrine\DBAL\Schema\Schema;
    use Doctrine\Migrations\AbstractMigration;
    
    
    final class Version20231005123457 extends AbstractMigration
    {
        public function getDescription(): string
        {
            return 'Create permission_role table';
        }
    
        public function up(Schema $schema): void
        {
            $this->addSql('CREATE TABLE permission_role (
                id INT AUTO_INCREMENT NOT NULL,
                permission_id INT NOT NULL,
                role_id INT NOT NULL,
                created_at DATETIME DEFAULT NULL,
                updated_at DATETIME DEFAULT NULL,
                PRIMARY KEY(id),
                FOREIGN KEY (permission_id) REFERENCES permissions(id),
                FOREIGN KEY (role_id) REFERENCES roles(id)
            ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB');
        }
    
        public function down(Schema $schema): void
        {
            $this->addSql('DROP TABLE permission_role');
        }
    }