<?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 Version20231219045847 extends AbstractMigration
{
public function getDescription(): string
{
return '';
}
public function up(Schema $schema): void
{ if (!$schema->getTable('contact_us')->hasColumn('created_by')) {
$this->addSql('ALTER TABLE contact_us ADD created_by INT NULL');
}
$this->addSql('ALTER TABLE contact_us ADD preferences VARCHAR(255) NOT NULL');
$this->addSql('SET foreign_key_checks = 0');
$this->addSql('TRUNCATE contact_us');
$this->addSql('SET foreign_key_checks = 1');
$this->addSql('INSERT INTO `contact_us` ( `first_name`, `last_name`, `email`, `phone`, `message`, `subject`, `is_replied`, `created_at`, `updated_at`, `deleted_at`, `reply`, `created_by`,`preferences`) VALUES
( "John", "Doe", "john.doe@example.com", "9876543210", "Lorem ipsum dolor sit amet, consectetur adipiscing elit.", "General Inquiry", 0, "2023-11-08 10:45:00", NULL, NULL, NULL, 2,"1,2,3"),
( "Jane", "Smith", "jane.smith@example.com", "5551234567", "Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas.", "Product Support", 1, "2023-11-09 12:15:00", "2023-11-09 12:30:00", NULL, "<p>Hello Jane, we received your message.</p>", 1,"1,2"),
("Michael", "Johnson", "michael.johnson@example.com", "1239876543", "Integer quis neque eu felis scelerisque venenatis.", "Account Inquiry", 0, "2023-11-10 14:30:00", NULL, NULL, NULL, 3,"1,2,3,4"),
( "Emily", "Williams", "emily.williams@example.com", "7894561230", "Vivamus euismod nisi nec luctus laoreet.", "Technical Support", 1, "2023-11-11 16:00:00", "2023-11-11 16:20:00", NULL, "<p>Dear Emily, your inquiry is important to us.</p>", 2,"1"),
( "Daniel", "Brown", "daniel.brown@example.com", "3216549870", "Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.", "Feedback", 0, "2023-11-12 09:45:00", NULL, NULL, NULL, 1,"1,2,3"),
( "Olivia", "Davis", "olivia.davis@example.com", "4567890123", "Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.", "General Inquiry", 1, "2023-11-13 11:10:00", "2023-11-13 11:30:00", NULL, "<p>Hi Olivia, we appreciate your feedback!</p>", 3,"1,2,3,4"),
( "William", "Taylor", "william.taylor@example.com", "6543217890", "Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.", "Product Inquiry", 0, "2023-11-14 13:25:00", NULL, NULL, NULL, 1,"1,2"),
( "Emma", "Anderson", "emma.anderson@example.com", "9870123456", "Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium.", "Technical Issue", 1, "2023-11-15 15:50:00", "2023-11-15 16:10:00", NULL, "<p>Hello Emma, we are working on resolving the issue.</p>", 2,"1,2"),
( "James", "Harris", "james.harris@example.com", "1234567890", "At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi.", "Account Support", 0, "2023-11-16 08:15:00", NULL, NULL, NULL, 3,"1,2"),
("Sophia", "Clark", "sophia.clark@example.com", "2345678901", "Nam libero tempore, cum soluta nobis est eligendi optio cumque nihil impedit quo minus id quod maxime placeat facere possimus.", "Feedback", 1, "2023-11-17 10:40:00", "2023-11-17 11:00:00", NULL, "<p>Hi Sophia, thank you for reaching out!</p>", 1,"1"),
("Benjamin", "Walker", "benjamin.walker@example.com", "3456789012", "Omnis voluptas assumenda est, omnis dolor repellendus.", "General Inquiry", 0, "2023-11-18 12:05:00", NULL, NULL, NULL, 2,"1"),
( "Ava", "Lewis", "ava.lewis@example.com", "4567890123", "Temporibus autem quibusdam et aut officiis debitis aut rerum necessitatibus saepe eveniet ut et voluptates repudiandae sint et molestiae non recusandae.", "Technical Support", 1, "2023-11-19 14:30:00", "2023-11-19 15:00:00", NULL, "<p>Dear Ava, your request has been received.</p>", 3,"1,2,3,4"),
( "Ethan", "Wright", "ethan.wright@example.com", "5678901234", "Itaque earum rerum hic tenetur a sapiente delectus, ut aut reiciendis voluptatibus maiores alias consequatur aut perferendis doloribus asperiores repellat.", "Product Inquiry", 0, "2023-11-20 16:55:00", NULL, NULL, NULL, 1,"1,2,3"),
( "Mia", "Evans", "mia.evans@example.com", "6789012345", "Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit.", "Account Inquiry", 1, "2023-11-21 09:20:00", "2023-11-21 09:40:00", NULL, "<p>Hi Mia, we will get back to you shortly.</p>", 2,"1"),
( "Liam", "Hill", "mia.evans@example.com", "6789012345", "Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit.", "Account Inquiry", 1, "2023-11-21 09:20:00", "2023-11-21 09:40:00", NULL, "<p>Hi Mia, we will get back to you shortly.</p>", 2,"1,2,3")');
}
public function down(Schema $schema): void
{
$this->addSql('ALTER TABLE contact_us ADD created_by INT NOT NULL, DROP preferences');
}
}