R524809
11 lines
578 B
PL/PgSQL
11 lines
578 B
PL/PgSQL
SET search_path TO atlas, public;
|
|
|
|
-- 币种变化影响售价含义；历史快照保留，发布必须重新确认。
|
|
CREATE FUNCTION invalidate_store_currency_pricing() RETURNS trigger LANGUAGE plpgsql SET search_path = atlas, public AS $$
|
|
BEGIN
|
|
UPDATE product_variant_platform_listings SET pricing_valid=false WHERE store_id=NEW.id;
|
|
RETURN NEW;
|
|
END $$;
|
|
CREATE TRIGGER store_currency_pricing_changed AFTER UPDATE OF currency_code ON stores
|
|
FOR EACH ROW WHEN (OLD.currency_code IS DISTINCT FROM NEW.currency_code) EXECUTE FUNCTION invalidate_store_currency_pricing();
|