-
Notifications
You must be signed in to change notification settings - Fork 1
/
beginner_reward.sql
23 lines (23 loc) · 5.87 KB
/
beginner_reward.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
CREATE TABLE 'beginner_reward' ('id' INTEGER NOT NULL, 'campaign_id' INTEGER NOT NULL, 'need_point' INTEGER NOT NULL, 'reward_type' INTEGER NOT NULL, 'reward_id' INTEGER NOT NULL, 'reward_value' INTEGER NOT NULL, 'add_value_1' INTEGER NOT NULL, 'add_value_2' INTEGER NOT NULL, 'add_value_3' INTEGER NOT NULL, 'step' INTEGER NOT NULL, 'step_group' INTEGER NOT NULL, 'recieve_type' INTEGER NOT NULL, 'message_id' INTEGER NOT NULL, PRIMARY KEY('id'));
INSERT INTO `beginner_reward` VALUES (/*id*/1, /*campaign_id*/90001, /*need_point*/500, /*reward_type*/5, /*reward_id*/4000, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0, /*step*/1, /*step_group*/1, /*recieve_type*/1, /*message_id*/109);
INSERT INTO `beginner_reward` VALUES (/*id*/2, /*campaign_id*/90001, /*need_point*/1000, /*reward_type*/5, /*reward_id*/23002, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0, /*step*/2, /*step_group*/1, /*recieve_type*/1, /*message_id*/109);
INSERT INTO `beginner_reward` VALUES (/*id*/3, /*campaign_id*/90001, /*need_point*/1500, /*reward_type*/5, /*reward_id*/4002, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0, /*step*/3, /*step_group*/1, /*recieve_type*/1, /*message_id*/109);
INSERT INTO `beginner_reward` VALUES (/*id*/4, /*campaign_id*/90001, /*need_point*/2000, /*reward_type*/5, /*reward_id*/23001, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0, /*step*/4, /*step_group*/1, /*recieve_type*/1, /*message_id*/109);
INSERT INTO `beginner_reward` VALUES (/*id*/5, /*campaign_id*/90001, /*need_point*/6500, /*reward_type*/5, /*reward_id*/4103, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0, /*step*/5, /*step_group*/2, /*recieve_type*/1, /*message_id*/109);
INSERT INTO `beginner_reward` VALUES (/*id*/6, /*campaign_id*/90001, /*need_point*/11000, /*reward_type*/5, /*reward_id*/23002, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0, /*step*/6, /*step_group*/2, /*recieve_type*/1, /*message_id*/109);
INSERT INTO `beginner_reward` VALUES (/*id*/7, /*campaign_id*/90001, /*need_point*/15500, /*reward_type*/5, /*reward_id*/4203, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0, /*step*/7, /*step_group*/2, /*recieve_type*/1, /*message_id*/109);
INSERT INTO `beginner_reward` VALUES (/*id*/8, /*campaign_id*/90001, /*need_point*/20000, /*reward_type*/5, /*reward_id*/23001, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0, /*step*/8, /*step_group*/2, /*recieve_type*/1, /*message_id*/109);
INSERT INTO `beginner_reward` VALUES (/*id*/9, /*campaign_id*/90001, /*need_point*/27500, /*reward_type*/5, /*reward_id*/4303, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0, /*step*/9, /*step_group*/3, /*recieve_type*/1, /*message_id*/109);
INSERT INTO `beginner_reward` VALUES (/*id*/10, /*campaign_id*/90001, /*need_point*/35000, /*reward_type*/5, /*reward_id*/23002, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0, /*step*/10, /*step_group*/3, /*recieve_type*/1, /*message_id*/109);
INSERT INTO `beginner_reward` VALUES (/*id*/11, /*campaign_id*/90001, /*need_point*/42500, /*reward_type*/5, /*reward_id*/4104, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0, /*step*/11, /*step_group*/3, /*recieve_type*/1, /*message_id*/109);
INSERT INTO `beginner_reward` VALUES (/*id*/12, /*campaign_id*/90001, /*need_point*/50000, /*reward_type*/5, /*reward_id*/23001, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0, /*step*/12, /*step_group*/3, /*recieve_type*/1, /*message_id*/109);
INSERT INTO `beginner_reward` VALUES (/*id*/13, /*campaign_id*/90001, /*need_point*/62500, /*reward_type*/5, /*reward_id*/4204, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0, /*step*/13, /*step_group*/4, /*recieve_type*/1, /*message_id*/109);
INSERT INTO `beginner_reward` VALUES (/*id*/14, /*campaign_id*/90001, /*need_point*/75000, /*reward_type*/5, /*reward_id*/23002, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0, /*step*/14, /*step_group*/4, /*recieve_type*/1, /*message_id*/109);
INSERT INTO `beginner_reward` VALUES (/*id*/15, /*campaign_id*/90001, /*need_point*/87500, /*reward_type*/5, /*reward_id*/4304, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0, /*step*/15, /*step_group*/4, /*recieve_type*/1, /*message_id*/109);
INSERT INTO `beginner_reward` VALUES (/*id*/16, /*campaign_id*/90001, /*need_point*/100000, /*reward_type*/5, /*reward_id*/23001, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0, /*step*/16, /*step_group*/4, /*recieve_type*/1, /*message_id*/109);
INSERT INTO `beginner_reward` VALUES (/*id*/17, /*campaign_id*/90001, /*need_point*/115000, /*reward_type*/5, /*reward_id*/1001, /*reward_value*/25, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0, /*step*/17, /*step_group*/5, /*recieve_type*/1, /*message_id*/109);
INSERT INTO `beginner_reward` VALUES (/*id*/18, /*campaign_id*/90001, /*need_point*/130000, /*reward_type*/5, /*reward_id*/1003, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0, /*step*/18, /*step_group*/5, /*recieve_type*/1, /*message_id*/109);
INSERT INTO `beginner_reward` VALUES (/*id*/19, /*campaign_id*/90001, /*need_point*/145000, /*reward_type*/5, /*reward_id*/30007, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0, /*step*/19, /*step_group*/5, /*recieve_type*/1, /*message_id*/109);
INSERT INTO `beginner_reward` VALUES (/*id*/20, /*campaign_id*/90001, /*need_point*/160000, /*reward_type*/5, /*reward_id*/23003, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0, /*step*/20, /*step_group*/5, /*recieve_type*/1, /*message_id*/109);
CREATE INDEX 'beginner_reward_0_campaign_id' on 'beginner_reward'('campaign_id');
CREATE INDEX 'beginner_reward_0_campaign_id_1_step_group' on 'beginner_reward'('campaign_id','step_group');