migrations/Version20220426095648.php line 1

Open in your IDE?
  1. <?php
  3. /* @noinspection PhpUnused */
  5. declare(strict_types=1);
  7. namespace DoctrineMigrations;
  9. use Doctrine\DBAL\Schema\Schema;
  10. use Doctrine\Migrations\AbstractMigration;
  12. /**
  13.  * Auto-generated Migration: Please modify to your needs!
  14.  *
  15.  * @package API
  16.  * @internal
  17.  */
  18. final class Version20220426095648 extends AbstractMigration
  19. {
  21.     public function down(Schema $schema): void
  22.     {
  23.         // this down() migration is auto-generated, please modify it to your needs
  24.     }
  26.     public function getDescription(): string
  27.     {
  28.         return
  29.             "- Seeding of protective gear and category tables.\n" .
  30.             "- Seeding of protective gear and category localizations with German and English.";
  31.     }
  33.     public function up(Schema $schema): void
  34.     {
  35.         // this up() migration is auto-generated, please modify it to your needs
  36.         $created = time();
  37.         $this->addSql(
  38.             '
  39.                 INSERT INTO protective_gear_category
  40.                     (id, created, active)
  41.                 VALUES
  42.                     (1, :createdTimeStamp, 1),
  43.                     (2, :createdTimeStamp, 1),
  44.                     (3, :createdTimeStamp, 1),
  45.                     (4, :createdTimeStamp, 1),
  46.                     (5, :createdTimeStamp, 1),
  47.                     (6, :createdTimeStamp, 1),
  48.                     (7, :createdTimeStamp, 1),
  49.                     (8, :createdTimeStamp, 1),
  50.                     (9, :createdTimeStamp, 1),
  51.                     (10, :createdTimeStamp, 1)
  52.                 ;
  53.             ',
  54.             ['createdTimeStamp' => $created]
  55.         );
  56.         $this->addSql(
  57.             '
  58.                 INSERT INTO protective_gear_category_l10n
  59.                     (language_id, parent_entity_id, name)
  60.                 VALUES
  61.                     (\'de\', 1, \'Armschutz\'),
  62.                     (\'de\', 2, \'Atemschutz\'),
  63.                     (\'de\', 3, \'Atemschutzhaube\'),
  64.                     (\'de\', 4, \'Augenschutz\'),
  65.                     (\'de\', 5, \'Fuß- und Beinschutz\'),
  66.                     (\'de\', 6, \'Schutzkleidung\'),
  67.                     (\'de\', 7, \'Kopf- und Haarschutz\'),
  68.                     (\'de\', 8, \'Gesichtsschutz\'),
  69.                     (\'de\', 9, \'Handschutz\'),
  70.                     (\'de\', 10, \'Gehörschutz\'),
  71.                     (\'en\', 1, \'arm protection\'),
  72.                     (\'en\', 2, \'respiratory protection\'),
  73.                     (\'en\', 3, \'respirator hood\'),
  74.                     (\'en\', 4, \'eye protection\'),
  75.                     (\'en\', 5, \'foot and leg protection\'),
  76.                     (\'en\', 6, \'protective clothing\'),
  77.                     (\'en\', 7, \'head and hair protection\'),
  78.                     (\'en\', 8, \'face protection\'),
  79.                     (\'en\', 9, \'hand protection\'),
  80.                     (\'en\', 10, \'ear protection\')
  81.                 ;
  82.             '
  83.         );
  84.         $this->addSql(
  85.             '
  86.                 INSERT INTO protective_gear
  87.                     (id, created, category_id, active)
  88.                 VALUES
  89.                     (1, :createdTimeStamp, NULL, 1),
  90.                     (2, :createdTimeStamp, 1, 1),
  91.                     (3, :createdTimeStamp, 1, 1),
  92.                     (4, :createdTimeStamp, 2, 1),
  93.                     (5, :createdTimeStamp, 2, 1),
  94.                     (6, :createdTimeStamp, 2, 1),
  95.                     (7, :createdTimeStamp, 2, 1),
  96.                     (8, :createdTimeStamp, 2, 1),
  97.                     (9, :createdTimeStamp, 2, 1),
  98.                     (10, :createdTimeStamp, 3, 1),
  99.                     (11, :createdTimeStamp, 3, 1),
  100.                     (12, :createdTimeStamp, 4, 1),
  101.                     (13, :createdTimeStamp, 4, 1),
  102.                     (14, :createdTimeStamp, 5, 1),
  103.                     (15, :createdTimeStamp, 5, 1),
  104.                     (16, :createdTimeStamp, 5, 1),
  105.                     (17, :createdTimeStamp, 5, 1),
  106.                     (18, :createdTimeStamp, 5, 1),
  107.                     (19, :createdTimeStamp, 5, 1),
  108.                     (20, :createdTimeStamp, 5, 1),
  109.                     (21, :createdTimeStamp, 5, 1),
  110.                     (22, :createdTimeStamp, 5, 1),
  111.                     (23, :createdTimeStamp, 6, 1),
  112.                     (24, :createdTimeStamp, 6, 1),
  113.                     (25, :createdTimeStamp, 6, 1),
  114.                     (26, :createdTimeStamp, 6, 1),
  115.                     (27, :createdTimeStamp, 6, 1),
  116.                     (28, :createdTimeStamp, 6, 1),
  117.                     (29, :createdTimeStamp, 6, 1),
  118.                     (30, :createdTimeStamp, 6, 1),
  119.                     (31, :createdTimeStamp, 6, 1),
  120.                     (32, :createdTimeStamp, 6, 1),
  121.                     (33, :createdTimeStamp, 6, 1),
  122.                     (34, :createdTimeStamp, 6, 1),
  123.                     (35, :createdTimeStamp, 7, 1),
  124.                     (36, :createdTimeStamp, 7, 1),
  125.                     (37, :createdTimeStamp, 7, 1),
  126.                     (38, :createdTimeStamp, 8, 1),
  127.                     (39, :createdTimeStamp, 8, 1),
  128.                     (40, :createdTimeStamp, 8, 1),
  129.                     (41, :createdTimeStamp, 9, 1),
  130.                     (42, :createdTimeStamp, 9, 1),
  131.                     (43, :createdTimeStamp, 9, 1),
  132.                     (44, :createdTimeStamp, 9, 1),
  133.                     (45, :createdTimeStamp, 9, 1),
  134.                     (46, :createdTimeStamp, 9, 1),
  135.                     (47, :createdTimeStamp, 9, 1),
  136.                     (48, :createdTimeStamp, 9, 1),
  137.                     (49, :createdTimeStamp, 9, 1),
  138.                     (50, :createdTimeStamp, 9, 1),
  139.                     (51, :createdTimeStamp, 10, 1),
  140.                     (52, :createdTimeStamp, 10, 1)
  141.                 ;
  142.             ',
  143.             ['createdTimeStamp' => $created]
  144.         );
  145.         $this->addSql(
  146.             '
  147.                 INSERT INTO protective_gear_l10n
  148.                     (language_id, parent_entity_id, name)
  149.                 VALUES
  150.                     (\'de\', 1, \'keine Schutzausrüstung\'),
  151.                     (\'de\', 2, \'Armschutz\'),
  152.                     (\'de\', 3, \'Unterarmschutz\'),
  153.                     (\'de\', 4, \'Atemschutz mit Filter\'),
  154.                     (\'de\', 5, \'Atemschutz-Halbmaske\'),
  155.                     (\'de\', 6, \'Atemschutzmaske\'),
  156.                     (\'de\', 7, \'Faltmaske\'),
  157.                     (\'de\', 8, \'Feinstaubmaske\'),
  158.                     (\'de\', 9, \'Vollsichtmaske\'),
  159.                     (\'de\', 10, \'Farbspritzerhaube\'),
  160.                     (\'de\', 11, \'Frischlufthaube\'),
  161.                     (\'de\', 12, \'Korrektionsschutzbrille\'),
  162.                     (\'de\', 13, \'Schutzbrille\'),
  163.                     (\'de\', 14, \'Gamasche\'),
  164.                     (\'de\', 15, \'Gummistiefel\'),
  165.                     (\'de\', 16, \'Sicherheitshalbschuhe S1\'),
  166.                     (\'de\', 17, \'Sicherheitshalbschuhe S2\'),
  167.                     (\'de\', 18, \'Sicherheitshalbschuhe S3\'),
  168.                     (\'de\', 19, \'Sicherheitssandale\'),
  169.                     (\'de\', 20, \'Sicherheitsstiefel S2\'),
  170.                     (\'de\', 21, \'Sicherheitsstiefel S3\'),
  171.                     (\'de\', 22, \'Winterstiefel S2\'),
  172.                     (\'de\', 23, \'Schutzanzug\'),
  173.                     (\'de\', 24, \'Schutzhose Montage\'),
  174.                     (\'de\', 25, \'Schutzhose Säure\'),
  175.                     (\'de\', 26, \'Schutzhose Schweißer/Gießer\'),
  176.                     (\'de\', 27, \'Schutzjacke Säure\'),
  177.                     (\'de\', 28, \'Schutzjacke Schweißer/Gießer\'),
  178.                     (\'de\', 29, \'Schutzschürze Baumwolle\'),
  179.                     (\'de\', 30, \'Schutzschürze Kunststoff\'),
  180.                     (\'de\', 31, \'Schutzschürze Leder\'),
  181.                     (\'de\', 32, \'Warnweste\'),
  182.                     (\'de\', 33, \'Wetterschutzhose\'),
  183.                     (\'de\', 34, \'Wetterschutzjacke\'),
  184.                     (\'de\', 35, \'Anstoßkappe\'),
  185.                     (\'de\', 36, \'Schutzhelm\'),
  186.                     (\'de\', 37, \'Schutzmütze\'),
  187.                     (\'de\', 38, \'Gesichtsschutzschirm\'),
  188.                     (\'de\', 39, \'Schweißerschutzschild\'),
  189.                     (\'de\', 40, \'Schweißermaske\'),
  190.                     (\'de\', 41, \'Chemikalienschutzhandschuh\'),
  191.                     (\'de\', 42, \'Hitzeschutzhandschuh\'),
  192.                     (\'de\', 43, \'Lackierhandschuh\'),
  193.                     (\'de\', 44, \'Montagehandschuh\'),
  194.                     (\'de\', 45, \'Nässeschutzhandschuh\'),
  195.                     (\'de\', 46, \'Schnittschutzhandschuh\'),
  196.                     (\'de\', 47, \'Stromschutzhandschuh\'),
  197.                     (\'de\', 48, \'Hautpflegepräparat\'),
  198.                     (\'de\', 49, \'Hautreinigungsmittel\'),
  199.                     (\'de\', 50, \'Hautschutzpräparat\'),
  200.                     (\'de\', 51, \'Gehörschutzkapsel\'),
  201.                     (\'de\', 52, \'Gehörschutzstöpsel\'),
  202.                     (\'en\', 1, \'no protective gear\'),
  203.                     (\'en\', 2, \'arm protection\'),
  204.                     (\'en\', 3, \'forearm protection\'),
  205.                     (\'en\', 4, \'respirator with filter\'),
  206.                     (\'en\', 5, \'respiratory half mask\'),
  207.                     (\'en\', 6, \'respirator\'),
  208.                     (\'en\', 7, \'folding mask\'),
  209.                     (\'en\', 8, \'fine dust mask\'),
  210.                     (\'en\', 9, \'full face mask\'),
  211.                     (\'en\', 10, \'paint spatter hood\'),
  212.                     (\'en\', 11, \'fresh air hood\'),
  213.                     (\'en\', 12, \'prescription safety goggles\'),
  214.                     (\'en\', 13, \'safety goggles\'),
  215.                     (\'en\', 14, \'spat\'),
  216.                     (\'en\', 15, \'rubber boots\'),
  217.                     (\'en\', 16, \'safety shoes S1\'),
  218.                     (\'en\', 17, \'safety shoes S2\'),
  219.                     (\'en\', 18, \'safety shoes S3\'),
  220.                     (\'en\', 19, \'safety sandal\'),
  221.                     (\'en\', 20, \'safety boots S2\'),
  222.                     (\'en\', 21, \'safety boots S3\'),
  223.                     (\'en\', 22, \'winter boots S2\'),
  224.                     (\'en\', 23, \'protective suit\'),
  225.                     (\'en\', 24, \'protective pants assembly\'),
  226.                     (\'en\', 25, \'protective pants acid\'),
  227.                     (\'en\', 26, \'protective pants for welders/casters\'),
  228.                     (\'en\', 27, \'protective jacket acid\'),
  229.                     (\'en\', 28, \'protective jacket for welders/casters\'),
  230.                     (\'en\', 29, \'protective apron cotton\'),
  231.                     (\'en\', 30, \'protective apron plastic\'),
  232.                     (\'en\', 31, \'protective apron leather\'),
  233.                     (\'en\', 32, \'safety west\'),
  234.                     (\'en\', 33, \'weatherproof pants\'),
  235.                     (\'en\', 34, \'weatherproof jacket\'),
  236.                     (\'en\', 35, \'bump cap\'),
  237.                     (\'en\', 36, \'hard hat\'),
  238.                     (\'en\', 37, \'protective cap\'),
  239.                     (\'en\', 38, \'face shield\'),
  240.                     (\'en\', 39, \'welding shield\'),
  241.                     (\'en\', 40, \'welding mask\'),
  242.                     (\'en\', 41, \'chemical protective glove\'),
  243.                     (\'en\', 42, \'heat protection glove\'),
  244.                     (\'en\', 43, \'paint glove\'),
  245.                     (\'en\', 44, \'assembly glove\'),
  246.                     (\'en\', 45, \'wet protection glove\'),
  247.                     (\'en\', 46, \'cut protection glove\'),
  248.                     (\'en\', 47, \'electricity protection glove\'),
  249.                     (\'en\', 48, \'skin care preparation\'),
  250.                     (\'en\', 49, \'skin cleanser\'),
  251.                     (\'en\', 50, \'skin protection preparation\'),
  252.                     (\'en\', 51, \'hearing protection capsule\'),
  253.                     (\'en\', 52, \'earplugs\')
  254.                 ;
  255.             '
  256.         );
  257.     }
  259. }