CREATE TABLE ec_spam_log ( spam_id integer PRIMARY KEY NOT NULL, spam_date timestamptz, spam_text varchar(4000), mailing_list_category_id integer, mailing_list_subcategory_id integer, mailing_list_subsubcategory_id integer, user_class_id integer, product_id integer, last_visit_start_date timestamptz, last_visit_end_date timestamptz, CONSTRAINT ec_spam_log_mailing_list_category_id_fkey REFERENCES ec_categories (), CONSTRAINT ec_spam_log_user_class_id_fkey REFERENCES ec_categories (), CONSTRAINT ec_spam_log_product_id_fkey REFERENCES ec_categories (), CONSTRAINT ec_spam_log_mailing_list_subcategory_id_fkey REFERENCES ec_categories (), CONSTRAINT ec_spam_log_pkey REFERENCES ec_categories (), CONSTRAINT ec_spam_log_mailing_list_subsubcategory_id_fkey REFERENCES ec_categories (), CONSTRAINT ec_spam_log_user_class_id_fkey REFERENCES ec_subcategories (), CONSTRAINT ec_spam_log_mailing_list_category_id_fkey REFERENCES ec_subcategories (), CONSTRAINT ec_spam_log_mailing_list_subcategory_id_fkey REFERENCES ec_subcategories (), CONSTRAINT ec_spam_log_mailing_list_subsubcategory_id_fkey REFERENCES ec_subcategories (), CONSTRAINT ec_spam_log_pkey REFERENCES ec_subcategories (), CONSTRAINT ec_spam_log_product_id_fkey REFERENCES ec_subcategories (), CONSTRAINT ec_spam_log_mailing_list_subsubcategory_id_fkey REFERENCES ec_subsubcategories (), CONSTRAINT ec_spam_log_user_class_id_fkey REFERENCES ec_subsubcategories (), CONSTRAINT ec_spam_log_product_id_fkey REFERENCES ec_subsubcategories (), CONSTRAINT ec_spam_log_pkey REFERENCES ec_subsubcategories (), CONSTRAINT ec_spam_log_mailing_list_subcategory_id_fkey REFERENCES ec_subsubcategories (), CONSTRAINT ec_spam_log_mailing_list_category_id_fkey REFERENCES ec_subsubcategories (), CONSTRAINT ec_spam_log_user_class_id_fkey REFERENCES ec_products (), CONSTRAINT ec_spam_log_product_id_fkey REFERENCES ec_products (), CONSTRAINT ec_spam_log_pkey REFERENCES ec_products (), CONSTRAINT ec_spam_log_mailing_list_subsubcategory_id_fkey REFERENCES ec_products (), CONSTRAINT ec_spam_log_mailing_list_subcategory_id_fkey REFERENCES ec_products (), CONSTRAINT ec_spam_log_mailing_list_category_id_fkey REFERENCES ec_products (), CONSTRAINT ec_spam_log_user_class_id_fkey REFERENCES ec_user_classes (), CONSTRAINT ec_spam_log_product_id_fkey REFERENCES ec_user_classes (), CONSTRAINT ec_spam_log_pkey REFERENCES ec_user_classes (), CONSTRAINT ec_spam_log_mailing_list_subsubcategory_id_fkey REFERENCES ec_user_classes (), CONSTRAINT ec_spam_log_mailing_list_subcategory_id_fkey REFERENCES ec_user_classes (), CONSTRAINT ec_spam_log_mailing_list_category_id_fkey REFERENCES ec_user_classes () ); CREATE INDEX ec_spam_log_by_cat_mail_idx ON ec_spam_log (mailing_list_category_id); CREATE INDEX ec_spam_log_by_cat_mail_idx2 ON ec_spam_log (mailing_list_subcategory_id); CREATE INDEX ec_spam_log_by_cat_mail_idx3 ON ec_spam_log (mailing_list_subsubcategory_id); CREATE INDEX ec_spam_log_by_product_idx ON ec_spam_log (product_id); CREATE INDEX ec_spam_log_by_user_cls_idx ON ec_spam_log (user_class_id); CREATE TRIGGER RI_ConstraintTrigger_c_342219 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342220 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342224 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342225 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342229 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342230 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342234 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342235 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342239 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342240 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 0 bytes -- Table rows: 0
Begin main content
