CREATE TABLE xowiki_page (
page_id integer PRIMARY KEY NOT NULL,
page_title text(-5),
creator text(-5),
page_order ltree(-5),
ON DELETE CASCADE ON DELETE CASCADE,
CONSTRAINT xowiki_page_fk REFERENCES cr_revisions (),
CONSTRAINT xowiki_page_pkey REFERENCES cr_revisions ()
);
CREATE INDEX xowiki_page_page_order_idx ON xowiki_page (page_order);
CREATE TRIGGER RI_ConstraintTrigger_a_343657 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343658 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_343714 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_343715 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343717 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343718 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343727 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343728 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343732 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343733 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
-- Tables with foreign keys that refer to xowiki_page:
--xowiki_file(xowiki_page_fk)
--xowiki_file(xowiki_page_pkey)
--xowiki_page_instance(xowiki_page_fk)
--xowiki_page_instance(xowiki_page_pkey)
--xowiki_page_template(xowiki_page_fk)
--xowiki_page_template(xowiki_page_pkey)
--xowiki_plain_page(xowiki_page_fk)
--xowiki_plain_page(xowiki_page_pkey)
-- Table size: 974,848 bytes
-- Table rows: 21,526
Tables: