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');