19 lines
1.2 KiB
SQL
Executable File
19 lines
1.2 KiB
SQL
Executable File
-- ----------------------------
|
||
-- Records of t_exchange_rate
|
||
-- ----------------------------
|
||
UPDATE T_EXCHANGE_RATE SET CURRENCY_SYMBOL = '¥' WHERE UUID='CNY_in';
|
||
UPDATE T_EXCHANGE_RATE SET CURRENCY_SYMBOL = '¥' WHERE UUID='CNY_out';
|
||
UPDATE T_EXCHANGE_RATE SET CURRENCY_SYMBOL = '€' WHERE UUID='EUR_in';
|
||
UPDATE T_EXCHANGE_RATE SET CURRENCY_SYMBOL = '€' WHERE UUID='EUR_out';
|
||
UPDATE T_EXCHANGE_RATE SET CURRENCY_SYMBOL = 'HK＄' WHERE UUID='HKD_in';
|
||
UPDATE T_EXCHANGE_RATE SET CURRENCY_SYMBOL = 'HK＄' WHERE UUID='HKD_out';
|
||
UPDATE T_EXCHANGE_RATE SET CURRENCY_SYMBOL = 'M＄' WHERE UUID='MYR_in';
|
||
UPDATE T_EXCHANGE_RATE SET CURRENCY_SYMBOL = 'M＄' WHERE UUID='MYR_out';
|
||
UPDATE T_EXCHANGE_RATE SET CURRENCY_SYMBOL = 'S$' WHERE UUID='SGD_in';
|
||
UPDATE T_EXCHANGE_RATE SET CURRENCY_SYMBOL = 'S$' WHERE UUID='SGD_out';
|
||
UPDATE T_EXCHANGE_RATE SET CURRENCY_SYMBOL = '฿' WHERE UUID='THB_in';
|
||
UPDATE T_EXCHANGE_RATE SET CURRENCY_SYMBOL = '฿' WHERE UUID='THB_out';
|
||
UPDATE T_EXCHANGE_RATE SET CURRENCY_SYMBOL = 'NT' WHERE UUID='TWD_in';
|
||
UPDATE T_EXCHANGE_RATE SET CURRENCY_SYMBOL = 'NT' WHERE UUID='TWD_out';
|
||
UPDATE T_EXCHANGE_RATE SET CURRENCY_SYMBOL = '$' WHERE UUID='USD_in';
|
||
UPDATE T_EXCHANGE_RATE SET CURRENCY_SYMBOL = '$' WHERE UUID='USD_out'; |