migrations/Version20251201114029.php line 1

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace DoctrineMigrations;
  7. use Doctrine\DBAL\Schema\Schema;
  8. use Doctrine\Migrations\AbstractMigration;
  10. final class Version20251201114029 extends AbstractMigration
  11. {
  12.     public function getDescription(): string
  13.     {
  14.         return 'Adds boolean fields: accepted_by_deliveryman and is_auto_order to command table; adds auto_accept to restaurant_config table';
  15.     }
  17.     public function up(Schema $schema): void
  18.     {
  19.         // Add fields to command table
  20.         $this->addSql("
  21.             ALTER TABLE `command`
  22.                 ADD `accepted_by_deliveryman` TINYINT(1) DEFAULT NULL
  23.         ");
  24.         $this->addSql("
  25.             ALTER TABLE `command`
  26.                  ADD `is_auto_order` TINYINT(1) DEFAULT NULL
  27.         ");
  29.         // Add field to restaurant_config table
  30.         $this->addSql("
  31.             ALTER TABLE `restaurant_config`
  32.                 ADD `auto_accept` TINYINT(1) DEFAULT NULL
  33.         ");
  34.     }
  36.     public function down(Schema $schema): void
  37.     {
  38.         // Remove fields from command table
  39.         $this->addSql("
  40.             ALTER TABLE `command`
  41.                 DROP COLUMN `accepted_by_deliveryman`,
  42.                 DROP COLUMN `is_auto_order`
  43.         ");
  45.         // Remove field from restaurant_config table
  46.         $this->addSql("
  47.             ALTER TABLE `restaurant_config`
  48.                 DROP COLUMN `auto_accept`
  49.         ");
  50.     }
  51. }