CREATE TABLE xowiki_last_visited ( page_id integer, package_id integer, user_id integer, count integer, time timestamp, ON DELETE CASCADE, CONSTRAINT xowiki_last_visited_page_id_fkey REFERENCES cr_items () ); CREATE INDEX xowiki_last_visited_page_id_idx ON xowiki_last_visited (page_id); CREATE INDEX xowiki_last_visited_time_idx ON xowiki_last_visited (time); CREATE INDEX xowiki_last_visited_user_id_package_id_idx ON xowiki_last_visited (user_id, package_id); CREATE UNIQUE INDEX xowiki_last_visited_user_id_page_id_un_idx ON xowiki_last_visited (user_id, page_id); CREATE TRIGGER RI_ConstraintTrigger_c_343699 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343700 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 1,572,864 bytes -- Table rows: 30,081
Begin main content
