CREATE TABLE forums_forums ( forum_id integer PRIMARY KEY NOT NULL, name varchar(200) NOT NULL, presentation_type varchar(100) NOT NULL, posting_policy varchar(100) NOT NULL, max_child_sortkey varbit(-5), enabled_p bool DEFAULT true NOT NULL, package_id integer NOT NULL, last_post timestamptz, thread_count integer DEFAULT 0, approved_thread_count integer DEFAULT 0, charter text(-5), new_questions_allowed_p bool DEFAULT true NOT NULL, anonymous_allowed_p bool DEFAULT false NOT NULL, attachments_allowed_p bool DEFAULT true NOT NULL, CONSTRAINT forums_forum_id_fk REFERENCES acs_objects (), CONSTRAINT forums_presentation_type_ck REFERENCES acs_objects (), CONSTRAINT forums_posting_policy_ck REFERENCES acs_objects (), CONSTRAINT forums_forum_id_pk REFERENCES acs_objects () ); CREATE INDEX forums_forums_pkg_enable_idx ON forums_forums (package_id, enabled_p); CREATE TRIGGER RI_ConstraintTrigger_a_342382 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342383 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342394 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342395 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342397 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342398 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to forums_forums: --forums_messages(forums_forum_id_fk) --forums_messages(forums_forum_id_pk) --forums_messages(forums_posting_policy_ck) --forums_messages(forums_presentation_type_ck) --forums_reading_info(forums_forum_id_fk) --forums_reading_info(forums_forum_id_pk) --forums_reading_info(forums_posting_policy_ck) --forums_reading_info(forums_presentation_type_ck) -- Table size: 8,192 bytes -- Table rows: 23
Begin main content
