|
1
|
-- kiwamoto
|
|
2
|
-- 2016-12-07
|
|
3
|
-- AP SIM
|
|
4
|
|
|
5
|
BEGIN;
|
|
6
|
INSERT INTO prepaid.product( product_id, product_code, prepaid_group_id, charge_product, auto_charge_product, prepaid_product, product_name, service_code, default_auto_charge_product_code, price, tax, charge_amount, charge_days, charge_mins, voip_free_money, mon_basic_fee, voip_price_map_id, product_short_name, product_short_name_en, extension_group_id, talking_product, set_auto_charge, chargeable_span, teigaku_product)VALUES(2395,'AP-AM530-240GB',87,FALSE,FALSE,TRUE,'AP GB Prepaid 240GB/750days (Micro SIM) + b-mobile4G AM530','PREPAID_START',NULL,55371,4429,0,0,0,0,0,0,'AP GB Prepaid 240GB/750days (Micro SIM)','AP GB Prepaid 240GB/750days (Micro SIM)',0,FALSE,FALSE,0,FALSE);
|
|
7
|
INSERT INTO prepaid.product( product_id, product_code, prepaid_group_id, charge_product, auto_charge_product, prepaid_product, product_name, service_code, default_auto_charge_product_code, price, tax, charge_amount, charge_days, charge_mins, voip_free_money, mon_basic_fee, voip_price_map_id, product_short_name, product_short_name_en, extension_group_id, talking_product, set_auto_charge, chargeable_span, teigaku_product)VALUES(2394,'AP-AR5210-240GB',87,FALSE,FALSE,TRUE,'AP GB Prepaid 240GB/750days (Micro SIM) + b-mobile4G WiFi3','PREPAID_START',NULL,55371,4429,0,0,0,0,0,0,'AP GB Prepaid 240GB/750days (Micro SIM)','AP GB Prepaid 240GB/750days (Micro SIM)',0,FALSE,FALSE,0,FALSE);
|
|
8
|
INSERT INTO prepaid.product( product_id, product_code, prepaid_group_id, charge_product, auto_charge_product, prepaid_product, product_name, service_code, default_auto_charge_product_code, price, tax, charge_amount, charge_days, charge_mins, voip_free_money, mon_basic_fee, voip_price_map_id, product_short_name, product_short_name_en, extension_group_id, talking_product, set_auto_charge, chargeable_span, teigaku_product)VALUES(2393,'AP-DL-240GBN',87,FALSE,FALSE,TRUE,'AP GB Prepaid 240GB/750days (Nano SIM)','PREPAID_START',NULL,36852,2948,0,0,0,0,0,0,'AP GB Prepaid 240GB/750days (Nano SIM)','AP GB Prepaid 240GB/750days (Nano SIM)',0,FALSE,FALSE,0,FALSE);
|
|
9
|
INSERT INTO prepaid.product( product_id, product_code, prepaid_group_id, charge_product, auto_charge_product, prepaid_product, product_name, service_code, default_auto_charge_product_code, price, tax, charge_amount, charge_days, charge_mins, voip_free_money, mon_basic_fee, voip_price_map_id, product_short_name, product_short_name_en, extension_group_id, talking_product, set_auto_charge, chargeable_span, teigaku_product)VALUES(2392,'AP-DL-240GBM',87,FALSE,FALSE,TRUE,'AP GB Prepaid 240GB/750days (Micro SIM)','PREPAID_START',NULL,36852,2948,0,0,0,0,0,0,'AP GB Prepaid 240GB/750days (Micro SIM)','AP GB Prepaid 240GB/750days (Micro SIM)',0,FALSE,FALSE,0,FALSE);
|
|
10
|
INSERT INTO prepaid.product( product_id, product_code, prepaid_group_id, charge_product, auto_charge_product, prepaid_product, product_name, service_code, default_auto_charge_product_code, price, tax, charge_amount, charge_days, charge_mins, voip_free_money, mon_basic_fee, voip_price_map_id, product_short_name, product_short_name_en, extension_group_id, talking_product, set_auto_charge, chargeable_span, teigaku_product)VALUES(2378,'AP-DL-240GBS',87,FALSE,FALSE,TRUE,'AP GB Prepaid 240GB/750days (Regular SIM)','PREPAID_START',NULL,36852,2948,0,0,0,0,0,0,'AP GB Prepaid 240GB/750days (Regular SIM)','AP GB Prepaid 240GB/750days (Regular SIM)',0,FALSE,FALSE,0,FALSE);
|
|
11
|
ROLLBACK;
|
