-
Notifications
You must be signed in to change notification settings - Fork 1
/
beginner_daily_mission.sql
11 lines (11 loc) · 4.09 KB
/
beginner_daily_mission.sql
1
2
3
4
5
6
7
8
9
10
11
CREATE TABLE 'beginner_daily_mission' ('id' INTEGER NOT NULL, 'campaign_id' INTEGER NOT NULL, 'type' INTEGER NOT NULL, 'mission_id' INTEGER NOT NULL, 'description' TEXT NOT NULL, 'description_detail' TEXT NOT NULL, 'disp_order' INTEGER NOT NULL, 'step_group_id' INTEGER NOT NULL, 'step_order' INTEGER NOT NULL, 'condition_type' INTEGER NOT NULL, 'condition_value_1' INTEGER NOT NULL, 'condition_value_2' INTEGER NOT NULL, 'reward_type' INTEGER NOT NULL, 'reward_id' INTEGER NOT NULL, 'reward_num' INTEGER NOT NULL, 'start_date' TEXT NOT NULL, 'end_date' TEXT NOT NULL, PRIMARY KEY('id'));
INSERT INTO `beginner_daily_mission` VALUES (/*id*/1, /*campaign_id*/90001, /*type*/10, /*mission_id*/1, /*description*/"LIVEを1回成功させよう", /*description_detail*/"LIVEを1回成功させよう", /*disp_order*/1, /*step_group_id*/10001, /*step_order*/1, /*condition_type*/500, /*condition_value_1*/1, /*condition_value_2*/0, /*reward_type*/25, /*reward_id*/0, /*reward_num*/500, /*start_date*/"2023/09/03 00:00:00", /*end_date*/"2023/10/06 23:59:59");
INSERT INTO `beginner_daily_mission` VALUES (/*id*/2, /*campaign_id*/90001, /*type*/10, /*mission_id*/2, /*description*/"ルームで1回Likeしよう", /*description_detail*/"ルームで1回Likeしよう", /*disp_order*/2, /*step_group_id*/10002, /*step_order*/1, /*condition_type*/13, /*condition_value_1*/1, /*condition_value_2*/0, /*reward_type*/25, /*reward_id*/0, /*reward_num*/300, /*start_date*/"2023/09/03 00:00:00", /*end_date*/"2023/10/06 23:59:59");
INSERT INTO `beginner_daily_mission` VALUES (/*id*/3, /*campaign_id*/90001, /*type*/10, /*mission_id*/3, /*description*/"営業を1回成功しよう", /*description_detail*/"営業を1回成功しよう", /*disp_order*/3, /*step_group_id*/10003, /*step_order*/1, /*condition_type*/300, /*condition_value_1*/1, /*condition_value_2*/0, /*reward_type*/25, /*reward_id*/0, /*reward_num*/500, /*start_date*/"2023/09/03 00:00:00", /*end_date*/"2023/10/06 23:59:59");
INSERT INTO `beginner_daily_mission` VALUES (/*id*/4, /*campaign_id*/90001, /*type*/10, /*mission_id*/4, /*description*/"ローカルガシャを引こう", /*description_detail*/"ローカルガシャを引こう", /*disp_order*/4, /*step_group_id*/10004, /*step_order*/1, /*condition_type*/6, /*condition_value_1*/1, /*condition_value_2*/0, /*reward_type*/25, /*reward_id*/0, /*reward_num*/500, /*start_date*/"2023/09/03 00:00:00", /*end_date*/"2023/10/06 23:59:59");
INSERT INTO `beginner_daily_mission` VALUES (/*id*/5, /*campaign_id*/90001, /*type*/10, /*mission_id*/5, /*description*/"トレーニングガシャを引こう", /*description_detail*/"トレーニングガシャを引こう", /*disp_order*/5, /*step_group_id*/10005, /*step_order*/1, /*condition_type*/502, /*condition_value_1*/1, /*condition_value_2*/0, /*reward_type*/25, /*reward_id*/0, /*reward_num*/500, /*start_date*/"2023/09/03 00:00:00", /*end_date*/"2023/10/06 23:59:59");
INSERT INTO `beginner_daily_mission` VALUES (/*id*/6, /*campaign_id*/90001, /*type*/10, /*mission_id*/6, /*description*/"無料10連ガシャを引こう", /*description_detail*/"無料10連ガシャを引こう", /*disp_order*/6, /*step_group_id*/10006, /*step_order*/1, /*condition_type*/113, /*condition_value_1*/1, /*condition_value_2*/70477, /*reward_type*/25, /*reward_id*/0, /*reward_num*/2000, /*start_date*/"2023/09/03 00:00:00", /*end_date*/"2023/09/22 23:59:59");
INSERT INTO `beginner_daily_mission` VALUES (/*id*/7, /*campaign_id*/90001, /*type*/10, /*mission_id*/7, /*description*/"無料ガシャを引こう", /*description_detail*/"無料ガシャを引こう", /*disp_order*/7, /*step_group_id*/10007, /*step_order*/1, /*condition_type*/113, /*condition_value_1*/1, /*condition_value_2*/70486, /*reward_type*/25, /*reward_id*/0, /*reward_num*/2000, /*start_date*/"2023/09/23 00:00:00", /*end_date*/"2023/10/06 23:59:59");
CREATE INDEX 'beginner_daily_mission_0_campaign_id' on 'beginner_daily_mission'('campaign_id');
CREATE INDEX 'beginner_daily_mission_0_campaign_id_1_mission_id' on 'beginner_daily_mission'('campaign_id','mission_id');
CREATE INDEX 'beginner_daily_mission_0_mission_id' on 'beginner_daily_mission'('mission_id');