CREATE TABLE bm_bookmarks ( bookmark_id integer PRIMARY KEY NOT NULL, owner_id integer NOT NULL, url_id integer, local_title varchar(500), folder_p bool DEFAULT false, parent_id integer, last_access_date timestamptz, tree_sortkey varbit(-5), ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT bm_bookmarks_bookmark_id_pk REFERENCES acs_objects (), CONSTRAINT bm_bookmarks_owner_id_fk REFERENCES acs_objects (), CONSTRAINT bm_bookmarks_url_id_fk REFERENCES acs_objects (), CONSTRAINT bm_bookmarks_bookmark_id_fk REFERENCES acs_objects (), CONSTRAINT bm_bookmarks_parent_id_fk REFERENCES acs_objects (), CONSTRAINT bm_bookmarks_owner_id_fk REFERENCES users (), CONSTRAINT bm_bookmarks_bookmark_id_fk REFERENCES users (), CONSTRAINT bm_bookmarks_bookmark_id_pk REFERENCES users (), CONSTRAINT bm_bookmarks_parent_id_fk REFERENCES users (), CONSTRAINT bm_bookmarks_url_id_fk REFERENCES users (), CONSTRAINT bm_bookmarks_url_id_fk REFERENCES acs_objects (), CONSTRAINT bm_bookmarks_parent_id_fk REFERENCES acs_objects (), CONSTRAINT bm_bookmarks_owner_id_fk REFERENCES acs_objects (), CONSTRAINT bm_bookmarks_bookmark_id_pk REFERENCES acs_objects (), CONSTRAINT bm_bookmarks_bookmark_id_fk REFERENCES acs_objects (), CONSTRAINT bm_bookmarks_url_id_fk REFERENCES bm_urls (), CONSTRAINT bm_bookmarks_bookmark_id_fk REFERENCES bm_urls (), CONSTRAINT bm_bookmarks_bookmark_id_pk REFERENCES bm_urls (), CONSTRAINT bm_bookmarks_owner_id_fk REFERENCES bm_urls (), CONSTRAINT bm_bookmarks_parent_id_fk REFERENCES bm_urls () ); CREATE INDEX bm_bookmarks_access_date_idx ON bm_bookmarks (parent_id, last_access_date, bookmark_id); CREATE INDEX bm_bookmarks_idx1 ON bm_bookmarks (tree_sortkey); CREATE INDEX bm_bookmarks_local_title_idx ON bm_bookmarks (); CREATE TRIGGER bm_bookmarks_insert_tr BEFORE INSERT FOR EACH ROW EXECUTE PROCEDURE bm_bookmarks_insert_tr (disabled) CREATE TRIGGER bm_bookmarks_update_tr AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE bm_bookmarks_update_tr (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340839 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340840 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340844 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340845 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340849 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340850 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340854 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340855 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340857 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340858 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to bm_bookmarks: --bm_in_closed_p(bm_bookmarks_bookmark_id_fk) --bm_in_closed_p(bm_bookmarks_bookmark_id_pk) --bm_in_closed_p(bm_bookmarks_owner_id_fk) --bm_in_closed_p(bm_bookmarks_parent_id_fk) --bm_in_closed_p(bm_bookmarks_url_id_fk) -- Table size: 237,568 bytes -- Table rows: 2,238
Begin main content
