CREATE TABLE ec_gift_certificate_usage ( gift_certificate_id integer NOT NULL, order_id integer, amount_used numeric(65535, 65531), used_date timestamptz, amount_reinstated numeric(65535, 65531), reinstated_date timestamptz, CONSTRAINT ec_gift_certificate_usage_gift_certificate_id_fkey REFERENCES ec_gift_certificates (), CONSTRAINT ec_gift_certificate_usage_order_id_fkey REFERENCES ec_gift_certificates (), CONSTRAINT ec_gift_certificate_usage_order_id_fkey REFERENCES ec_orders (), CONSTRAINT ec_gift_certificate_usage_gift_certificate_id_fkey REFERENCES ec_orders () ); CREATE INDEX ec_gift_cert_by_id ON ec_gift_certificate_usage (gift_certificate_id); CREATE TRIGGER ec_cert_amount_remains AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE trig_ec_cert_amount_remains (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341879 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341880 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341884 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341885 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 0 bytes -- Table rows: 0
Begin main content
