-
Notifications
You must be signed in to change notification settings - Fork 1
/
atapon_point_reward_cenere.sql
12 lines (12 loc) · 2.44 KB
/
atapon_point_reward_cenere.sql
1
2
3
4
5
6
7
8
9
10
11
12
CREATE TABLE 'atapon_point_reward_cenere' ('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_cenere` VALUES (/*id*/1, /*event_id*/1093, /*need_point*/1000, /*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_cenere` VALUES (/*id*/2, /*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_cenere` VALUES (/*id*/3, /*event_id*/1093, /*need_point*/3000, /*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_cenere` VALUES (/*id*/4, /*event_id*/1093, /*need_point*/4000, /*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_cenere` VALUES (/*id*/5, /*event_id*/1093, /*need_point*/5000, /*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_cenere` VALUES (/*id*/6, /*event_id*/1093, /*need_point*/6000, /*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_cenere` VALUES (/*id*/7, /*event_id*/1093, /*need_point*/7000, /*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_cenere` VALUES (/*id*/8, /*event_id*/1093, /*need_point*/8000, /*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_cenere` VALUES (/*id*/9, /*event_id*/1093, /*need_point*/9000, /*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_cenere` VALUES (/*id*/10, /*event_id*/1093, /*need_point*/10000, /*reward_type*/6, /*reward_id*/301315, /*reward_value*/1, /*add_value_1*/1, /*add_value_2*/0, /*add_value_3*/1);
CREATE INDEX 'atapon_point_reward_cenere_0_event_id' on 'atapon_point_reward_cenere'('event_id');