CREATE TABLE ec_user_sessions ( user_session_id integer PRIMARY KEY NOT NULL, user_id integer, ip_address varchar(20) NOT NULL, start_time timestamptz, http_user_agent varchar(4000), CONSTRAINT ec_session_id_pk REFERENCES users (), CONSTRAINT ec_user_sessions_user_id_fkey REFERENCES users () ); CREATE INDEX ec_user_sessions_idx ON ec_user_sessions (user_id); CREATE TRIGGER RI_ConstraintTrigger_a_341967 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341968 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342332 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342333 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342342 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342343 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342349 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342350 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Tables with foreign keys that refer to ec_user_sessions: --ec_orders(ec_session_id_pk) --ec_orders(ec_user_sessions_user_id_fkey) --ec_user_session_info(ec_session_id_pk) --ec_user_session_info(ec_user_sessions_user_id_fkey) --ec_user_session_offer_codes(ec_session_id_pk) --ec_user_session_offer_codes(ec_user_sessions_user_id_fkey) -- Table size: 0 bytes -- Table rows: 0
Begin main content
