CREATE TABLE xowiki_form_instance_item_index ( item_id integer, name varchar(400), package_id integer, parent_id integer, publish_status text(-5), page_template integer, assignee integer, state text(-5), ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT xowiki_form_instance_item_index_item_id_fkey REFERENCES parties (), CONSTRAINT xowiki_form_instance_item_index_page_template_fkey REFERENCES parties (), CONSTRAINT xowiki_form_instance_item_index_parent_id_fkey REFERENCES parties (), CONSTRAINT xowiki_form_instance_item_index_assignee_fkey REFERENCES parties () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT xowiki_form_instance_item_index_page_template_fkey REFERENCES cr_items (), CONSTRAINT xowiki_form_instance_item_index_assignee_fkey REFERENCES cr_items (), CONSTRAINT xowiki_form_instance_item_index_item_id_fkey REFERENCES cr_items (), CONSTRAINT xowiki_form_instance_item_index_parent_id_fkey REFERENCES cr_items () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT xowiki_form_instance_item_index_parent_id_fkey REFERENCES cr_items (), CONSTRAINT xowiki_form_instance_item_index_page_template_fkey REFERENCES cr_items (), CONSTRAINT xowiki_form_instance_item_index_item_id_fkey REFERENCES cr_items (), CONSTRAINT xowiki_form_instance_item_index_assignee_fkey REFERENCES cr_items () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT xowiki_form_instance_item_index_parent_id_fkey REFERENCES cr_items (), CONSTRAINT xowiki_form_instance_item_index_assignee_fkey REFERENCES cr_items (), CONSTRAINT xowiki_form_instance_item_index_item_id_fkey REFERENCES cr_items (), CONSTRAINT xowiki_form_instance_item_index_page_template_fkey REFERENCES cr_items () ); CREATE INDEX xowiki_form_instance_item_index_assignee_idx ON xowiki_form_instance_item_index (assignee); CREATE UNIQUE INDEX xowiki_form_instance_item_index_item_id_un_idx ON xowiki_form_instance_item_index (item_id); CREATE INDEX xowiki_form_instance_item_index_page_template_idx ON xowiki_form_instance_item_index (page_template); CREATE INDEX xowiki_form_instance_item_index_page_template_package_id_idx ON xowiki_form_instance_item_index (page_template, package_id); CREATE INDEX xowiki_form_instance_item_index_parent_id_idx ON xowiki_form_instance_item_index (parent_id); CREATE UNIQUE INDEX xowiki_form_instance_item_index_parent_id_name_un_idx ON xowiki_form_instance_item_index (parent_id, name); CREATE INDEX xowiki_form_instance_item_index_parent_id_page_template_idx ON xowiki_form_instance_item_index (parent_id, page_template); CREATE TRIGGER RI_ConstraintTrigger_c_343669 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343670 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343674 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343675 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343679 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343680 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343684 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343685 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 40,960 bytes -- Table rows: 361
OpenACS – The Toolkit for Online Communities : Schema Browser : Table: xowiki_form_instance_item_index
Begin main content
