github.com/oinume/lekcije@v0.0.0-20231017100347-5b4c5eb6ab24/backend/db/migrations/20170731050000_organize_m_plan.sql (about)

     1  -- +goose Up
     2  -- SQL in section 'Up' is executed when this migration is applied
     3  DROP TABLE IF EXISTS plan;
     4  
     5  BEGIN;
     6  UPDATE m_plan SET name='フリー', notification_interval=10, updated_at='2017-07-30 13:43:31' WHERE id = 1;
     7  UPDATE m_plan SET name='プラス', internal_name='Plus', price=400, notification_interval=1, updated_at='2017-07-30 13:43:31' WHERE id = 2;
     8  UPDATE m_plan SET name='プロ', internal_name='Pro', price=900, notification_interval=1, updated_at='2017-07-30 13:43:31' WHERE id = 3;
     9  UPDATE m_plan SET name='プラス', internal_name='Plus Beta', price=0, updated_at='2017-07-30 13:43:31' WHERE id = 5;
    10  COMMIT;
    11  
    12  UPDATE user SET plan_id=1 WHERE plan_id = 4;
    13  
    14  
    15  -- +goose Down
    16  -- SQL section 'Down' is executed when this migration is rolled back
    17  CREATE TABLE IF NOT EXISTS `plan` (
    18    `id` tinyint(3) unsigned NOT NULL,
    19    `name` varchar(255) COLLATE utf8mb4_bin NOT NULL,
    20    `internal_name` varchar(255) COLLATE utf8mb4_bin NOT NULL,
    21    `price` mediumint(9) NOT NULL,
    22    `notification_interval` tinyint(3) unsigned NOT NULL,
    23    `show_ad` tinyint(1) unsigned NOT NULL,
    24    `created_at` datetime NOT NULL,
    25    `updated_at` datetime NOT NULL,
    26    PRIMARY KEY (`id`)
    27  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
    28  
    29  DROP TABLE IF EXISTS m_plan;
    30  CREATE TABLE `m_plan` (
    31    `id` tinyint(3) unsigned NOT NULL,
    32    `name` varchar(255) COLLATE utf8mb4_bin NOT NULL,
    33    `internal_name` varchar(255) COLLATE utf8mb4_bin NOT NULL,
    34    `price` mediumint(9) NOT NULL,
    35    `notification_interval` tinyint(3) unsigned NOT NULL,
    36    `show_ad` tinyint(1) unsigned NOT NULL,
    37    `created_at` datetime NOT NULL,
    38    `updated_at` datetime NOT NULL,
    39    PRIMARY KEY (`id`)
    40  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
    41  INSERT INTO `m_plan` VALUES (1,'Free','Free',0,20,1,'2016-10-16 00:00:00','2016-10-16 00:00:00'),(2,'Standard','Standard',300,10,0,'2016-10-16 00:00:00','2016-10-16 00:00:00'),(3,'Plus','Plus',500,5,0,'2016-10-16 00:00:00','2016-10-16 00:00:00'),(4,'Free','Free Beta',0,10,1,'2016-10-16 00:00:00','2016-10-16 00:00:00'),(5,'Plus','Plus Beta',0,1,0,'2017-06-04 00:00:00','2017-06-04 00:00:00');