CREATE TABLE forums_messages ( message_id integer PRIMARY KEY NOT NULL, forum_id integer, subject varchar(200), content text(-5), user_id integer NOT NULL, posting_date timestamptz DEFAULT now() NOT NULL, state varchar(100), parent_id integer, open_p bool DEFAULT true NOT NULL, tree_sortkey varbit(-5), max_child_sortkey varbit(-5), last_child_post timestamptz, format varchar(30) DEFAULT 'text/plain'::character varying, reply_count integer DEFAULT 0, approved_reply_count integer DEFAULT 0, last_poster integer, CONSTRAINT forum_mess_parent_id_fk REFERENCES forums_messages (), CONSTRAINT forums_messages_pk REFERENCES forums_messages (), CONSTRAINT forums_message_id_fk REFERENCES forums_messages (), CONSTRAINT forums_mess_user_id_fk REFERENCES forums_messages (), CONSTRAINT forum_mess_state_ck REFERENCES forums_messages (), CONSTRAINT forums_mess_last_poster_fk REFERENCES forums_messages (), CONSTRAINT forums_mess_forum_id_fk REFERENCES forums_messages (), CONSTRAINT forums_mess_format_ck REFERENCES forums_messages (), CONSTRAINT forums_messages_pk REFERENCES forums_forums (), CONSTRAINT forum_mess_parent_id_fk REFERENCES forums_forums (), CONSTRAINT forum_mess_state_ck REFERENCES forums_forums (), CONSTRAINT forums_mess_format_ck REFERENCES forums_forums (), CONSTRAINT forums_mess_forum_id_fk REFERENCES forums_forums (), CONSTRAINT forums_mess_last_poster_fk REFERENCES forums_forums (), CONSTRAINT forums_mess_user_id_fk REFERENCES forums_forums (), CONSTRAINT forums_message_id_fk REFERENCES forums_forums (), CONSTRAINT forums_mess_forum_id_fk REFERENCES users (), CONSTRAINT forums_messages_pk REFERENCES users (), CONSTRAINT forums_message_id_fk REFERENCES users (), CONSTRAINT forums_mess_user_id_fk REFERENCES users (), CONSTRAINT forums_mess_last_poster_fk REFERENCES users (), CONSTRAINT forums_mess_format_ck REFERENCES users (), CONSTRAINT forum_mess_state_ck REFERENCES users (), CONSTRAINT forum_mess_parent_id_fk REFERENCES users (), CONSTRAINT forums_message_id_fk REFERENCES users (), CONSTRAINT forums_messages_pk REFERENCES users (), CONSTRAINT forums_mess_user_id_fk REFERENCES users (), CONSTRAINT forums_mess_last_poster_fk REFERENCES users (), CONSTRAINT forums_mess_forum_id_fk REFERENCES users (), CONSTRAINT forums_mess_format_ck REFERENCES users (), CONSTRAINT forum_mess_state_ck REFERENCES users (), CONSTRAINT forum_mess_parent_id_fk REFERENCES users (), CONSTRAINT forums_messages_pk REFERENCES acs_objects (), CONSTRAINT forums_message_id_fk REFERENCES acs_objects (), CONSTRAINT forums_mess_user_id_fk REFERENCES acs_objects (), CONSTRAINT forums_mess_last_poster_fk REFERENCES acs_objects (), CONSTRAINT forums_mess_forum_id_fk REFERENCES acs_objects (), CONSTRAINT forums_mess_format_ck REFERENCES acs_objects (), CONSTRAINT forum_mess_state_ck REFERENCES acs_objects (), CONSTRAINT forum_mess_parent_id_fk REFERENCES acs_objects () ); CREATE INDEX forum_messages_date_idx ON forums_messages (forum_id, posting_date); CREATE INDEX forum_messages_sk ON forums_messages (tree_sortkey); CREATE INDEX forum_messages_state_idx ON forums_messages (state); CREATE INDEX forums_mess_forum_sk_idx ON forums_messages (forum_id, tree_sortkey); CREATE INDEX forums_mess_sk_forum_idx ON forums_messages (tree_sortkey, forum_id); CREATE INDEX forums_messages_parent_id_idx ON forums_messages (parent_id); CREATE INDEX forums_messages_user_id_idx ON forums_messages (user_id); CREATE INDEX forums_msg_lcp_idx ON forums_messages (last_child_post); CREATE TRIGGER forums_mess_insert_tr BEFORE INSERT FOR EACH ROW EXECUTE PROCEDURE forums_mess_insert_tr (disabled) CREATE TRIGGER forums_message_search__dtrg AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE forums_message_search__dtrg (disabled) CREATE TRIGGER forums_message_search__itrg AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE forums_message_search__itrg (disabled) CREATE TRIGGER forums_message_search__utrg AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE forums_message_search__utrg (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342377 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342378 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342379 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342380 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342387 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342388 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342399 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342400 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342404 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342405 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342409 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342410 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342414 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342415 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Tables with foreign keys that refer to forums_messages: --forums_messages(forum_mess_parent_id_fk) --forums_messages(forum_mess_state_ck) --forums_messages(forums_mess_format_ck) --forums_messages(forums_mess_forum_id_fk) --forums_messages(forums_mess_last_poster_fk) --forums_messages(forums_mess_user_id_fk) --forums_messages(forums_message_id_fk) --forums_messages(forums_messages_pk) --forums_reading_info(forum_mess_parent_id_fk) --forums_reading_info(forum_mess_state_ck) --forums_reading_info(forums_mess_format_ck) --forums_reading_info(forums_mess_forum_id_fk) --forums_reading_info(forums_mess_last_poster_fk) --forums_reading_info(forums_mess_user_id_fk) --forums_reading_info(forums_message_id_fk) --forums_reading_info(forums_messages_pk) -- Table size: 57,876,480 bytes -- Table rows: 85,681
Begin main content
