CREATE TABLE site_nodes ( node_id integer PRIMARY KEY NOT NULL, parent_id integer, name text(-5), directory_p bool NOT NULL, pattern_p bool DEFAULT false NOT NULL, object_id integer, CONSTRAINT site_nodes_name_ck REFERENCES acs_objects (), CONSTRAINT site_nodes_node_id_fk REFERENCES acs_objects (), CONSTRAINT site_nodes_node_id_pk REFERENCES acs_objects (), CONSTRAINT site_nodes_object_id_fk REFERENCES acs_objects (), CONSTRAINT site_nodes_parent_id_ck REFERENCES acs_objects (), CONSTRAINT site_nodes_parent_id_fk REFERENCES acs_objects (), CONSTRAINT site_nodes_name_ck REFERENCES acs_objects (), CONSTRAINT site_nodes_node_id_fk REFERENCES acs_objects (), CONSTRAINT site_nodes_node_id_pk REFERENCES acs_objects (), CONSTRAINT site_nodes_object_id_fk REFERENCES acs_objects (), CONSTRAINT site_nodes_parent_id_ck REFERENCES acs_objects (), CONSTRAINT site_nodes_parent_id_fk REFERENCES acs_objects (), CONSTRAINT site_nodes_parent_id_fk REFERENCES site_nodes (), CONSTRAINT site_nodes_name_ck REFERENCES site_nodes (), CONSTRAINT site_nodes_node_id_fk REFERENCES site_nodes (), CONSTRAINT site_nodes_node_id_pk REFERENCES site_nodes (), CONSTRAINT site_nodes_object_id_fk REFERENCES site_nodes (), CONSTRAINT site_nodes_parent_id_ck REFERENCES site_nodes () ); CREATE INDEX site_nodes_name_idx ON site_nodes (name); CREATE INDEX site_nodes_object_id_idx ON site_nodes (object_id); CREATE INDEX site_nodes_parent_id_idx ON site_nodes (parent_id); CREATE INDEX site_nodes_parent_object_node_id_idx ON site_nodes (parent_id, object_id, node_id); CREATE UNIQUE INDEX site_nodes_un ON site_nodes (parent_id, name); CREATE TRIGGER RI_ConstraintTrigger_a_341572 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341573 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342924 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342925 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342929 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342930 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342932 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342933 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342934 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342935 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342942 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342943 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_upd (disabled) -- Tables with foreign keys that refer to site_nodes: --dav_site_node_folder_map(site_nodes_name_ck) --dav_site_node_folder_map(site_nodes_node_id_fk) --dav_site_node_folder_map(site_nodes_node_id_pk) --dav_site_node_folder_map(site_nodes_object_id_fk) --dav_site_node_folder_map(site_nodes_parent_id_ck) --dav_site_node_folder_map(site_nodes_parent_id_fk) --site_node_object_mappings(site_nodes_name_ck) --site_node_object_mappings(site_nodes_node_id_fk) --site_node_object_mappings(site_nodes_node_id_pk) --site_node_object_mappings(site_nodes_object_id_fk) --site_node_object_mappings(site_nodes_parent_id_ck) --site_node_object_mappings(site_nodes_parent_id_fk) --site_nodes(site_nodes_name_ck) --site_nodes(site_nodes_node_id_fk) --site_nodes(site_nodes_node_id_pk) --site_nodes(site_nodes_object_id_fk) --site_nodes(site_nodes_parent_id_ck) --site_nodes(site_nodes_parent_id_fk) -- Table size: 16,384 bytes -- Table rows: 156
Begin main content
