CREATE TABLE bm_in_closed_p ( bookmark_id integer NOT NULL, -- -- This is the user_id for registered users and the session_id in sec_sessions -- for non-registered users. -- in_closed_p_id int8 NOT NULL, in_closed_p bool DEFAULT true, closed_p bool DEFAULT false, creation_date timestamptz, PRIMARY KEY (bookmark_id,in_closed_p_id), CONSTRAINT bm_in_closed_p_bookmark_id_fk REFERENCES bm_bookmarks (), CONSTRAINT bm_in_closed_p_pk REFERENCES bm_bookmarks () ); CREATE UNIQUE INDEX bm_in_closed_p_idx ON bm_in_closed_p (bookmark_id, in_closed_p_id, in_closed_p); CREATE TRIGGER RI_ConstraintTrigger_c_340859 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340860 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 7,913,472 bytes -- Table rows: 62,539
Begin main content
