f_voiptariff.sql

来自「gnugk软交换产品」· SQL 代码 · 共 20 行

DELETE FROM voiptariff;
INSERT INTO voiptariff (dstid, price) SELECT id, 15.0 FROM voiptariffdst WHERE active;

CREATE TEMPORARY TABLE voiptariff_temp (
  dstname TEXT NOT NULL,
  dstprice NUMERIC(9,4) NOT NULL,
  dstcurr TEXT NOT NULL,
  dstinitinc INT NOT NULL,
  dstreginc INT NOT NULL,
  dstgraceperiod INT NOT NULL
);
	
\copy voiptariff_temp(dstname, dstprice, dstcurr, dstinitinc, dstreginc, dstgraceperiod) from 'voiptariff.asc' with delimiter '\t'

UPDATE voiptariff SET price = dstprice, currencysym = dstcurr, 
	initialincrement = dstinitinc, regularincrement = dstreginc,
	graceperiod = dstgraceperiod
	FROM voiptariff_temp T, voiptariffdst D
	WHERE dstid = D.id AND D.description LIKE T.dstname;