一、demo脚本
UPDATE ld_currency_info SET currency_name='USA, Dollars',currency_code='USD',currency_symbol='$' WHERE id=1;
UPDATE ld_currency_info SET currency_name='China, Yuan Renminbi',currency_code='CNY',currency_symbol='¥' WHERE currency_name='USA, Dollars' AND defaultid=0;ALTER TABLE ld_cashbill ALTER COLUMN currency_symbol SET DEFAULT '$';
ALTER TABLE ld_commission ALTER COLUMN currency_symbol SET DEFAULT '$';
ALTER TABLE ld_customform11 ALTER COLUMN currency_symbol SET DEFAULT '$';
ALTER TABLE ld_customform12 ALTER COLUMN currency_symbol SET DEFAULT '$';
ALTER TABLE ld_customform13 ALTER COLUMN currency_symbol SET DEFAULT '$';
ALTER TABLE ld_customform14 ALTER COLUMN currency_symbol SET DEFAULT '$';
ALTER TABLE ld_customform15 ALTER COLUMN currency_symbol SET DEFAULT '$';
ALTER TABLE ld_customform16 ALTER COLUMN currency_symbol SET DEFAULT '$';
ALTER TABLE ld_customform17 ALTER COLUMN currency_symbol SET DEFAULT '$';
ALTER TABLE ld_customform18 ALTER COLUMN currency_symbol SET DEFAULT '$';
ALTER TABLE ld_customform19 ALTER COLUMN currency_symbol SET DEFAULT '$';
ALTER TABLE ld_customform20 ALTER COLUMN currency_symbol SET DEFAULT '$';
ALTER TABLE ld_customform36 ALTER COLUMN currency_symbol SET DEFAULT '$';
ALTER TABLE ld_customform37 ALTER COLUMN currency_symbol SET DEFAULT '$';
ALTER TABLE ld_customform38 ALTER COLUMN currency_symbol SET DEFAULT '$';
ALTER TABLE ld_customform39 ALTER COLUMN currency_symbol SET DEFAULT '$';
ALTER TABLE ld_customform40 ALTER COLUMN currency_symbol SET DEFAULT '$';
ALTER TABLE ld_customform41 ALTER COLUMN currency_symbol SET DEFAULT '$';
ALTER TABLE ld_customform42 ALTER COLUMN currency_symbol SET DEFAULT '$';
ALTER TABLE ld_customform43 ALTER COLUMN currency_symbol SET DEFAULT '$';
ALTER TABLE ld_customform44 ALTER COLUMN currency_symbol SET DEFAULT '$';
ALTER TABLE ld_customform45 ALTER COLUMN currency_symbol SET DEFAULT '$';
ALTER TABLE ld_expense ALTER COLUMN currency_symbol SET DEFAULT '$';
ALTER TABLE ld_potential ALTER COLUMN currency_symbol SET DEFAULT '$';
ALTER TABLE ld_productbom ALTER COLUMN currency_symbol SET DEFAULT '$';
ALTER TABLE ld_salesorder ALTER COLUMN currency_symbol SET DEFAULT '$';
ALTER TABLE ld_sendcashbill ALTER COLUMN currency_symbol SET DEFAULT '$';
ALTER TABLE ld_servicecontracts ALTER COLUMN currency_symbol SET DEFAULT '$';