CREATE TABLE ec_product_links ( product_a integer NOT NULL, product_b integer NOT NULL, last_modified timestamptz NOT NULL, last_modifying_user integer NOT NULL, modified_ip_address varchar(20) NOT NULL, PRIMARY KEY (product_a,product_b), CONSTRAINT ec_product_links_last_modifying_user_fkey REFERENCES users (), CONSTRAINT ec_product_links_pkey REFERENCES users (), CONSTRAINT ec_product_links_product_a_fkey REFERENCES users (), CONSTRAINT ec_product_links_product_b_fkey REFERENCES users (), CONSTRAINT ec_product_links_product_b_fkey REFERENCES ec_products (), CONSTRAINT ec_product_links_product_a_fkey REFERENCES ec_products (), CONSTRAINT ec_product_links_pkey REFERENCES ec_products (), CONSTRAINT ec_product_links_last_modifying_user_fkey REFERENCES ec_products (), CONSTRAINT ec_product_links_product_b_fkey REFERENCES ec_products (), CONSTRAINT ec_product_links_last_modifying_user_fkey REFERENCES ec_products (), CONSTRAINT ec_product_links_pkey REFERENCES ec_products (), CONSTRAINT ec_product_links_product_a_fkey REFERENCES ec_products () ); CREATE INDEX ec_product_links_idx ON ec_product_links (product_b); CREATE TRIGGER ec_product_links_audit_tr AFTER DELETE OR UPDATE FOR EACH ROW EXECUTE PROCEDURE ec_product_links_audit_tr (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342014 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342015 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342019 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342020 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342024 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342025 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 0 bytes -- Table rows: 0
Begin main content
