Symfony Profiler

<?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 Version20240203165100 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('CREATE TABLE accessories (id INT AUTO_INCREMENT NOT NULL, type VARCHAR(255) NOT NULL, description VARCHAR(255) NOT NULL, price VARCHAR(255) NOT NULL, ek VARCHAR(255) NOT NULL, marge VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE basket (id INT AUTO_INCREMENT NOT NULL, data VARCHAR(900) NOT NULL, text VARCHAR(600) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE device_type (id INT AUTO_INCREMENT NOT NULL, x VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE geraete (id INT AUTO_INCREMENT NOT NULL, marke_id INT DEFAULT NULL, name VARCHAR(255) NOT NULL, bild VARCHAR(255) DEFAULT NULL, device_type VARCHAR(255) NOT NULL, position_table INT DEFAULT NULL, INDEX IDX_B35B30DB3EFDDCD7 (marke_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE marke (id INT AUTO_INCREMENT NOT NULL, marke VARCHAR(255) NOT NULL, bild VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE `order` (id INT AUTO_INCREMENT NOT NULL, basket_id INT DEFAULT NULL, firstname VARCHAR(255) NOT NULL, lastname VARCHAR(255) NOT NULL, street VARCHAR(255) NOT NULL, streetnumber VARCHAR(255) NOT NULL, addressoption VARCHAR(255) NOT NULL, country VARCHAR(255) NOT NULL, zipcode VARCHAR(255) NOT NULL, city VARCHAR(255) NOT NULL, email VARCHAR(255) NOT NULL, tel VARCHAR(255) NOT NULL, shippingtype VARCHAR(255) NOT NULL, paymenttype VARCHAR(255) NOT NULL, paymentstate VARCHAR(255) NOT NULL, order_state VARCHAR(255) NOT NULL, order_number VARCHAR(255) NOT NULL, basket_sum VARCHAR(255) DEFAULT NULL, create_date DATETIME DEFAULT NULL, shipmentnumber VARCHAR(255) DEFAULT NULL, archived TINYINT(1) DEFAULT NULL, UNIQUE INDEX UNIQ_F52993981BE1FB52 (basket_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE preise (id INT AUTO_INCREMENT NOT NULL, geraete_id INT DEFAULT NULL, reparatur_id INT DEFAULT NULL, preis VARCHAR(255) NOT NULL, dauer VARCHAR(255) DEFAULT NULL, ek VARCHAR(255) NOT NULL, marge VARCHAR(255) NOT NULL, ekcopy VARCHAR(255) DEFAULT NULL, margecopy VARCHAR(255) DEFAULT NULL, position_table INT DEFAULT NULL, INDEX IDX_4BC657B1C462A1DD (geraete_id), INDEX IDX_4BC657B1157576E0 (reparatur_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE reparaturen (id INT AUTO_INCREMENT NOT NULL, reparaturen VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE service (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, preis VARCHAR(255) NOT NULL, position_table VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE settings (id INT AUTO_INCREMENT NOT NULL, maintaince TINYINT(1) DEFAULT NULL, pricemaintaince TINYINT(1) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE sort_devices (id INT AUTO_INCREMENT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user (id INT AUTO_INCREMENT NOT NULL, username VARCHAR(180) NOT NULL, roles JSON NOT NULL, password VARCHAR(255) NOT NULL, UNIQUE INDEX UNIQ_8D93D649F85E0677 (username), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('ALTER TABLE geraete ADD CONSTRAINT FK_B35B30DB3EFDDCD7 FOREIGN KEY (marke_id) REFERENCES marke (id)');
$this->addSql('ALTER TABLE `order` ADD CONSTRAINT FK_F52993981BE1FB52 FOREIGN KEY (basket_id) REFERENCES basket (id)');
$this->addSql('ALTER TABLE preise ADD CONSTRAINT FK_4BC657B1C462A1DD FOREIGN KEY (geraete_id) REFERENCES geraete (id)');
$this->addSql('ALTER TABLE preise ADD CONSTRAINT FK_4BC657B1157576E0 FOREIGN KEY (reparatur_id) REFERENCES reparaturen (id)');
}
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
$this->addSql('ALTER TABLE geraete DROP FOREIGN KEY FK_B35B30DB3EFDDCD7');
$this->addSql('ALTER TABLE `order` DROP FOREIGN KEY FK_F52993981BE1FB52');
$this->addSql('ALTER TABLE preise DROP FOREIGN KEY FK_4BC657B1C462A1DD');
$this->addSql('ALTER TABLE preise DROP FOREIGN KEY FK_4BC657B1157576E0');
$this->addSql('DROP TABLE accessories');
$this->addSql('DROP TABLE basket');
$this->addSql('DROP TABLE device_type');
$this->addSql('DROP TABLE geraete');
$this->addSql('DROP TABLE marke');
$this->addSql('DROP TABLE `order`');
$this->addSql('DROP TABLE preise');
$this->addSql('DROP TABLE reparaturen');
$this->addSql('DROP TABLE service');
$this->addSql('DROP TABLE settings');
$this->addSql('DROP TABLE sort_devices');
$this->addSql('DROP TABLE user');
}
}

migrations/Version20240203165100.php line 1