migrations/Version20230530124751.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 Version20230530124751 extends AbstractMigration
  11. {
  12.     public function getDescription(): string
  13.     {
  14.         return 'Announcements table';
  15.     }
  17.     public function up(Schema $schema): void
  18.     {
  19.         $this->addSql("
  20.             CREATE TABLE `announcement`  (
  21.               `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  22.               `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  23.               `user_id` bigint UNSIGNED NULL DEFAULT NULL,
  24.               `status` smallint UNSIGNED NOT NULL DEFAULT 0,
  25.               `type` smallint UNSIGNED NOT NULL,
  26.               `additional_data` json NULL,
  27.               `min_views_per_video` int UNSIGNED NULL DEFAULT NULL,
  28.               `max_views_per_video` int UNSIGNED NULL DEFAULT NULL,
  29.               `min_follower_count` int UNSIGNED NULL DEFAULT NULL,
  30.               `max_follower_count` int UNSIGNED NULL DEFAULT NULL,
  31.               `min_video_count` int UNSIGNED NULL DEFAULT NULL,
  32.               `max_video_count` int UNSIGNED NULL DEFAULT NULL,
  33.               `min_like_count` int UNSIGNED NULL DEFAULT NULL,
  34.               `max_like_count` int UNSIGNED NULL DEFAULT NULL,
  35.               `gender` smallint UNSIGNED NOT NULL DEFAULT 3,
  36.               `vip_creator` tinyint(1) NULL DEFAULT NULL,
  37.               `verified_creator` tinyint(1) NULL DEFAULT NULL,
  38.               `unverified_creator` tinyint(1) NULL DEFAULT NULL,
  39.               `creator_geolocation_enabled` tinyint(1) NULL DEFAULT NULL,
  40.               `creator_geolocation_disabled` tinyint(1) NULL DEFAULT NULL,
  41.               `created_at` datetime NOT NULL,
  42.               `updated_at` datetime NULL DEFAULT NULL,
  43.               `end_date` date NULL DEFAULT NULL,
  44.               PRIMARY KEY (`id`) USING BTREE,
  45.               INDEX `user_id`(`user_id`) USING BTREE,
  46.               CONSTRAINT `announcement_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
  47.             ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic
  48.         ");
  49.     }
  51.     public function down(Schema $schema): void
  52.     {
  53.         $this->addSql("DROP TABLE IF EXISTS `announcement`");
  54.     }
  55. }