CREATE TABLE ec_user_session_info ( user_session_id integer NOT NULL, product_id integer, category_id integer, search_text varchar(200), CONSTRAINT ec_user_session_info_category_id_fkey REFERENCES ec_categories (), CONSTRAINT ec_user_session_info_product_id_fkey REFERENCES ec_categories (), CONSTRAINT ec_user_session_info_user_session_id_fkey REFERENCES ec_categories (), CONSTRAINT ec_user_session_info_user_session_id_fkey REFERENCES ec_products (), CONSTRAINT ec_user_session_info_product_id_fkey REFERENCES ec_products (), CONSTRAINT ec_user_session_info_category_id_fkey REFERENCES ec_products (), CONSTRAINT ec_user_session_info_user_session_id_fkey REFERENCES ec_user_sessions (), CONSTRAINT ec_user_session_info_category_id_fkey REFERENCES ec_user_sessions (), CONSTRAINT ec_user_session_info_product_id_fkey REFERENCES ec_user_sessions () ); CREATE INDEX ec_user_session_info_idx ON ec_user_session_info (user_session_id); CREATE INDEX ec_user_session_info_idx2 ON ec_user_session_info (product_id); CREATE INDEX ec_user_session_info_idx3 ON ec_user_session_info (category_id); CREATE TRIGGER RI_ConstraintTrigger_c_342324 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342325 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342329 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342330 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342334 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342335 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 0 bytes -- Table rows: 0
Begin main content
