CREATE TABLE ec_user_classes ( user_class_id integer PRIMARY KEY NOT NULL, user_class_name varchar(200), last_modified timestamptz NOT NULL, last_modifying_user integer NOT NULL, modified_ip_address varchar(20) NOT NULL, CONSTRAINT ec_user_classes_last_modifying_user_fkey REFERENCES users (), CONSTRAINT ec_user_classes_pkey REFERENCES users () ); CREATE TRIGGER ec_user_classes_audit_tr AFTER DELETE OR UPDATE FOR EACH ROW EXECUTE PROCEDURE ec_user_classes_audit_tr (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342082 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342083 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342122 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342123 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342237 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342238 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342302 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342303 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342314 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342315 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Tables with foreign keys that refer to ec_user_classes: --ec_product_recommendations(ec_user_classes_last_modifying_user_fkey) --ec_product_recommendations(ec_user_classes_pkey) --ec_product_user_class_prices(ec_user_classes_last_modifying_user_fkey) --ec_product_user_class_prices(ec_user_classes_pkey) --ec_spam_log(ec_user_classes_last_modifying_user_fkey) --ec_spam_log(ec_user_classes_pkey) --ec_user_class_user_map(ec_user_classes_last_modifying_user_fkey) --ec_user_class_user_map(ec_user_classes_pkey) -- Table size: 0 bytes -- Table rows: 0
Begin main content
