-
Notifications
You must be signed in to change notification settings - Fork 1
/
atapon_point_reward.sql
81 lines (81 loc) · 15.9 KB
/
atapon_point_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
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
CREATE TABLE 'atapon_point_reward' ('id' INTEGER NOT NULL, 'event_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, PRIMARY KEY('id'));
INSERT INTO `atapon_point_reward` VALUES (/*id*/1, /*event_id*/1093, /*need_point*/10, /*reward_type*/1, /*reward_id*/0, /*reward_value*/5000, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/2, /*event_id*/1093, /*need_point*/60, /*reward_type*/4, /*reward_id*/0, /*reward_value*/50, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/3, /*event_id*/1093, /*need_point*/100, /*reward_type*/5, /*reward_id*/3, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/4, /*event_id*/1093, /*need_point*/200, /*reward_type*/2, /*reward_id*/0, /*reward_value*/300, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/5, /*event_id*/1093, /*need_point*/500, /*reward_type*/4, /*reward_id*/0, /*reward_value*/50, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/6, /*event_id*/1093, /*need_point*/500, /*reward_type*/9, /*reward_id*/6931, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/7, /*event_id*/1093, /*need_point*/1000, /*reward_type*/5, /*reward_id*/10032, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/8, /*event_id*/1093, /*need_point*/1000, /*reward_type*/9, /*reward_id*/6932, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/9, /*event_id*/1093, /*need_point*/1500, /*reward_type*/5, /*reward_id*/30003, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/10, /*event_id*/1093, /*need_point*/2000, /*reward_type*/4, /*reward_id*/0, /*reward_value*/50, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/11, /*event_id*/1093, /*need_point*/2000, /*reward_type*/9, /*reward_id*/6933, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/12, /*event_id*/1093, /*need_point*/2500, /*reward_type*/5, /*reward_id*/1005, /*reward_value*/3, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/13, /*event_id*/1093, /*need_point*/3000, /*reward_type*/5, /*reward_id*/3, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/14, /*event_id*/1093, /*need_point*/3000, /*reward_type*/9, /*reward_id*/6934, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/15, /*event_id*/1093, /*need_point*/3500, /*reward_type*/4, /*reward_id*/0, /*reward_value*/50, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/16, /*event_id*/1093, /*need_point*/4000, /*reward_type*/2, /*reward_id*/0, /*reward_value*/1000, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/17, /*event_id*/1093, /*need_point*/4500, /*reward_type*/5, /*reward_id*/1001, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/18, /*event_id*/1093, /*need_point*/5000, /*reward_type*/7, /*reward_id*/6800, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/19, /*event_id*/1093, /*need_point*/5000, /*reward_type*/9, /*reward_id*/6935, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/20, /*event_id*/1093, /*need_point*/5500, /*reward_type*/5, /*reward_id*/30003, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/21, /*event_id*/1093, /*need_point*/6000, /*reward_type*/5, /*reward_id*/10032, /*reward_value*/2, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/22, /*event_id*/1093, /*need_point*/6500, /*reward_type*/1, /*reward_id*/0, /*reward_value*/10000, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/23, /*event_id*/1093, /*need_point*/7000, /*reward_type*/5, /*reward_id*/2, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/24, /*event_id*/1093, /*need_point*/7500, /*reward_type*/4, /*reward_id*/0, /*reward_value*/50, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/25, /*event_id*/1093, /*need_point*/8000, /*reward_type*/5, /*reward_id*/1001, /*reward_value*/2, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/26, /*event_id*/1093, /*need_point*/8500, /*reward_type*/5, /*reward_id*/1005, /*reward_value*/3, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/27, /*event_id*/1093, /*need_point*/9000, /*reward_type*/5, /*reward_id*/30003, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/28, /*event_id*/1093, /*need_point*/9500, /*reward_type*/5, /*reward_id*/10013, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/29, /*event_id*/1093, /*need_point*/10000, /*reward_type*/6, /*reward_id*/201409, /*reward_value*/1, /*add_value_1*/1, /*add_value_2*/0, /*add_value_3*/1);
INSERT INTO `atapon_point_reward` VALUES (/*id*/30, /*event_id*/1093, /*need_point*/10500, /*reward_type*/5, /*reward_id*/2, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/31, /*event_id*/1093, /*need_point*/11000, /*reward_type*/2, /*reward_id*/0, /*reward_value*/1500, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/32, /*event_id*/1093, /*need_point*/11500, /*reward_type*/5, /*reward_id*/1001, /*reward_value*/2, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/33, /*event_id*/1093, /*need_point*/12000, /*reward_type*/4, /*reward_id*/0, /*reward_value*/50, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/34, /*event_id*/1093, /*need_point*/12500, /*reward_type*/5, /*reward_id*/1005, /*reward_value*/3, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/35, /*event_id*/1093, /*need_point*/13000, /*reward_type*/5, /*reward_id*/86001, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/36, /*event_id*/1093, /*need_point*/13500, /*reward_type*/5, /*reward_id*/10023, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/37, /*event_id*/1093, /*need_point*/14000, /*reward_type*/1, /*reward_id*/0, /*reward_value*/30000, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/38, /*event_id*/1093, /*need_point*/14500, /*reward_type*/5, /*reward_id*/2, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/39, /*event_id*/1093, /*need_point*/15000, /*reward_type*/6, /*reward_id*/301315, /*reward_value*/1, /*add_value_1*/1, /*add_value_2*/0, /*add_value_3*/1);
INSERT INTO `atapon_point_reward` VALUES (/*id*/40, /*event_id*/1093, /*need_point*/15500, /*reward_type*/2, /*reward_id*/0, /*reward_value*/1500, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/41, /*event_id*/1093, /*need_point*/16000, /*reward_type*/5, /*reward_id*/30003, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/42, /*event_id*/1093, /*need_point*/16500, /*reward_type*/5, /*reward_id*/10003, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/43, /*event_id*/1093, /*need_point*/17000, /*reward_type*/1, /*reward_id*/0, /*reward_value*/30000, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/44, /*event_id*/1093, /*need_point*/17500, /*reward_type*/5, /*reward_id*/2, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/45, /*event_id*/1093, /*need_point*/18000, /*reward_type*/2, /*reward_id*/0, /*reward_value*/2000, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/46, /*event_id*/1093, /*need_point*/18500, /*reward_type*/5, /*reward_id*/30004, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/47, /*event_id*/1093, /*need_point*/19000, /*reward_type*/4, /*reward_id*/0, /*reward_value*/50, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/48, /*event_id*/1093, /*need_point*/19500, /*reward_type*/5, /*reward_id*/10013, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/49, /*event_id*/1093, /*need_point*/20000, /*reward_type*/6, /*reward_id*/201409, /*reward_value*/1, /*add_value_1*/1, /*add_value_2*/0, /*add_value_3*/1);
INSERT INTO `atapon_point_reward` VALUES (/*id*/50, /*event_id*/1093, /*need_point*/21000, /*reward_type*/5, /*reward_id*/2, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/51, /*event_id*/1093, /*need_point*/22000, /*reward_type*/4, /*reward_id*/0, /*reward_value*/100, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/52, /*event_id*/1093, /*need_point*/23000, /*reward_type*/5, /*reward_id*/1002, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/53, /*event_id*/1093, /*need_point*/24000, /*reward_type*/5, /*reward_id*/82001, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/54, /*event_id*/1093, /*need_point*/25000, /*reward_type*/6, /*reward_id*/301315, /*reward_value*/1, /*add_value_1*/1, /*add_value_2*/0, /*add_value_3*/1);
INSERT INTO `atapon_point_reward` VALUES (/*id*/55, /*event_id*/1093, /*need_point*/26000, /*reward_type*/5, /*reward_id*/30003, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/56, /*event_id*/1093, /*need_point*/27000, /*reward_type*/5, /*reward_id*/10023, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/57, /*event_id*/1093, /*need_point*/28000, /*reward_type*/1, /*reward_id*/0, /*reward_value*/50000, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/58, /*event_id*/1093, /*need_point*/29000, /*reward_type*/5, /*reward_id*/2, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/59, /*event_id*/1093, /*need_point*/30000, /*reward_type*/6, /*reward_id*/201409, /*reward_value*/1, /*add_value_1*/1, /*add_value_2*/0, /*add_value_3*/1);
INSERT INTO `atapon_point_reward` VALUES (/*id*/60, /*event_id*/1093, /*need_point*/31000, /*reward_type*/2, /*reward_id*/0, /*reward_value*/2000, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/61, /*event_id*/1093, /*need_point*/32000, /*reward_type*/5, /*reward_id*/30003, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/62, /*event_id*/1093, /*need_point*/33000, /*reward_type*/5, /*reward_id*/10003, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/63, /*event_id*/1093, /*need_point*/34000, /*reward_type*/4, /*reward_id*/0, /*reward_value*/100, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/64, /*event_id*/1093, /*need_point*/35000, /*reward_type*/6, /*reward_id*/301315, /*reward_value*/1, /*add_value_1*/1, /*add_value_2*/0, /*add_value_3*/1);
INSERT INTO `atapon_point_reward` VALUES (/*id*/65, /*event_id*/1093, /*need_point*/36000, /*reward_type*/5, /*reward_id*/1, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/66, /*event_id*/1093, /*need_point*/37000, /*reward_type*/2, /*reward_id*/0, /*reward_value*/2000, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/67, /*event_id*/1093, /*need_point*/38000, /*reward_type*/5, /*reward_id*/30003, /*reward_value*/2, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/68, /*event_id*/1093, /*need_point*/39000, /*reward_type*/1, /*reward_id*/0, /*reward_value*/50000, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/69, /*event_id*/1093, /*need_point*/40000, /*reward_type*/6, /*reward_id*/201409, /*reward_value*/1, /*add_value_1*/1, /*add_value_2*/0, /*add_value_3*/1);
INSERT INTO `atapon_point_reward` VALUES (/*id*/70, /*event_id*/1093, /*need_point*/41000, /*reward_type*/5, /*reward_id*/1, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/71, /*event_id*/1093, /*need_point*/42000, /*reward_type*/2, /*reward_id*/0, /*reward_value*/2000, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/72, /*event_id*/1093, /*need_point*/43000, /*reward_type*/5, /*reward_id*/30003, /*reward_value*/2, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/73, /*event_id*/1093, /*need_point*/44000, /*reward_type*/4, /*reward_id*/0, /*reward_value*/100, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/74, /*event_id*/1093, /*need_point*/45000, /*reward_type*/6, /*reward_id*/301315, /*reward_value*/1, /*add_value_1*/1, /*add_value_2*/0, /*add_value_3*/1);
INSERT INTO `atapon_point_reward` VALUES (/*id*/75, /*event_id*/1093, /*need_point*/46000, /*reward_type*/5, /*reward_id*/1, /*reward_value*/1, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/76, /*event_id*/1093, /*need_point*/47000, /*reward_type*/2, /*reward_id*/0, /*reward_value*/2000, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/77, /*event_id*/1093, /*need_point*/48000, /*reward_type*/5, /*reward_id*/30004, /*reward_value*/2, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/78, /*event_id*/1093, /*need_point*/49000, /*reward_type*/1, /*reward_id*/0, /*reward_value*/50000, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
INSERT INTO `atapon_point_reward` VALUES (/*id*/79, /*event_id*/1093, /*need_point*/50000, /*reward_type*/4, /*reward_id*/0, /*reward_value*/100, /*add_value_1*/0, /*add_value_2*/0, /*add_value_3*/0);
CREATE INDEX 'atapon_point_reward_0_event_id' on 'atapon_point_reward'('event_id');