CREATE TABLE forums_reading_info ( root_message_id integer NOT NULL, user_id integer NOT NULL, reading_date timestamp DEFAULT now() NOT NULL, forum_id integer NOT NULL, PRIMARY KEY (root_message_id,user_id), ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT forum_read_forum_id_fk REFERENCES forums_forums (), CONSTRAINT forum_read_parent_id_fk REFERENCES forums_forums (), CONSTRAINT forums_read_user_id_fk REFERENCES forums_forums (), CONSTRAINT forums_reading_info_pk REFERENCES forums_forums () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT forums_reading_info_pk REFERENCES forums_messages (), CONSTRAINT forums_read_user_id_fk REFERENCES forums_messages (), CONSTRAINT forum_read_parent_id_fk REFERENCES forums_messages (), CONSTRAINT forum_read_forum_id_fk REFERENCES forums_messages (), CONSTRAINT forums_reading_info_pk REFERENCES users (), CONSTRAINT forum_read_forum_id_fk REFERENCES users (), CONSTRAINT forum_read_parent_id_fk REFERENCES users (), CONSTRAINT forums_read_user_id_fk REFERENCES users () ); CREATE INDEX forums_reading_info_forum_forum_index ON forums_reading_info (forum_id); CREATE INDEX forums_reading_info_forum_message_index ON forums_reading_info (root_message_id); CREATE INDEX forums_reading_info_user_id_root_message_id_idx ON forums_reading_info (user_id, root_message_id); CREATE INDEX forums_reading_info_user_index ON forums_reading_info (user_id); CREATE TRIGGER RI_ConstraintTrigger_c_342384 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342385 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342389 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342390 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342419 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342420 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 8,192 bytes -- Table rows: 13
Begin main content
