CREATE TABLE xowiki_tags ( item_id integer, package_id integer, user_id integer, tag text(-5), time timestamp, ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT xowiki_tags_item_id_fkey REFERENCES cr_items (), CONSTRAINT xowiki_tags_user_id_fkey REFERENCES cr_items (), CONSTRAINT xowiki_tags_user_id_fkey REFERENCES users (), CONSTRAINT xowiki_tags_item_id_fkey REFERENCES users () ); CREATE INDEX xowiki_tags_item_id_idx ON xowiki_tags (item_id); CREATE INDEX xowiki_tags_package_id_idx ON xowiki_tags (package_id); CREATE INDEX xowiki_tags_tag ON xowiki_tags (tag); CREATE INDEX xowiki_tags_tag_package_id_idx ON xowiki_tags (tag, package_id); CREATE INDEX xowiki_tags_user_id_idx ON xowiki_tags (user_id); CREATE INDEX xowiki_tags_user_id_item_id_idx ON xowiki_tags (user_id, item_id); CREATE INDEX xowiki_tags_user_id_package_id_idx ON xowiki_tags (user_id, package_id); CREATE TRIGGER RI_ConstraintTrigger_c_343754 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343755 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343759 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343760 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 16,384 bytes -- Table rows: 151
Begin main content
