CREATE TABLE ec_automatic_email_log ( user_identification_id integer NOT NULL, email_template_id integer NOT NULL, order_id integer, shipment_id integer, gift_certificate_id integer, date_sent timestamptz, CONSTRAINT ec_automatic_email_log_email_template_id_fkey REFERENCES ec_email_templates (), CONSTRAINT ec_automatic_email_log_user_identification_id_fkey REFERENCES ec_email_templates (), CONSTRAINT ec_automatic_email_log_gift_certificate_id_fkey REFERENCES ec_email_templates (), CONSTRAINT ec_automatic_email_log_shipment_id_fkey REFERENCES ec_email_templates (), CONSTRAINT ec_automatic_email_log_order_id_fkey REFERENCES ec_email_templates (), CONSTRAINT ec_automatic_email_log_user_identification_id_fkey REFERENCES ec_gift_certificates (), CONSTRAINT ec_automatic_email_log_email_template_id_fkey REFERENCES ec_gift_certificates (), CONSTRAINT ec_automatic_email_log_gift_certificate_id_fkey REFERENCES ec_gift_certificates (), CONSTRAINT ec_automatic_email_log_order_id_fkey REFERENCES ec_gift_certificates (), CONSTRAINT ec_automatic_email_log_shipment_id_fkey REFERENCES ec_gift_certificates (), CONSTRAINT ec_automatic_email_log_order_id_fkey REFERENCES ec_orders (), CONSTRAINT ec_automatic_email_log_user_identification_id_fkey REFERENCES ec_orders (), CONSTRAINT ec_automatic_email_log_shipment_id_fkey REFERENCES ec_orders (), CONSTRAINT ec_automatic_email_log_gift_certificate_id_fkey REFERENCES ec_orders (), CONSTRAINT ec_automatic_email_log_email_template_id_fkey REFERENCES ec_orders (), CONSTRAINT ec_automatic_email_log_user_identification_id_fkey REFERENCES ec_shipments (), CONSTRAINT ec_automatic_email_log_shipment_id_fkey REFERENCES ec_shipments (), CONSTRAINT ec_automatic_email_log_order_id_fkey REFERENCES ec_shipments (), CONSTRAINT ec_automatic_email_log_gift_certificate_id_fkey REFERENCES ec_shipments (), CONSTRAINT ec_automatic_email_log_email_template_id_fkey REFERENCES ec_shipments (), CONSTRAINT ec_automatic_email_log_user_identification_id_fkey REFERENCES ec_user_identification (), CONSTRAINT ec_automatic_email_log_shipment_id_fkey REFERENCES ec_user_identification (), CONSTRAINT ec_automatic_email_log_order_id_fkey REFERENCES ec_user_identification (), CONSTRAINT ec_automatic_email_log_gift_certificate_id_fkey REFERENCES ec_user_identification (), CONSTRAINT ec_automatic_email_log_email_template_id_fkey REFERENCES ec_user_identification () ); CREATE INDEX ec_auto_email_by_gc_idx ON ec_automatic_email_log (gift_certificate_id); CREATE INDEX ec_auto_email_by_order_idx ON ec_automatic_email_log (order_id); CREATE INDEX ec_auto_email_by_shipment_idx ON ec_automatic_email_log (shipment_id); CREATE INDEX ec_auto_email_by_temp_idx ON ec_automatic_email_log (email_template_id); CREATE INDEX ec_auto_email_by_usr_id_idx ON ec_automatic_email_log (user_identification_id); CREATE TRIGGER RI_ConstraintTrigger_c_341694 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341695 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341699 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341700 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341704 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341705 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341709 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341710 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341714 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341715 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 0 bytes -- Table rows: 0
Begin main content
