CREATE TABLE chat_rooms ( room_id integer PRIMARY KEY NOT NULL, pretty_name varchar(100) NOT NULL, description varchar(2000), active_p bool DEFAULT true, archive_p bool DEFAULT true, auto_flush_p bool DEFAULT true, auto_transcript_p bool DEFAULT false, login_messages_p bool DEFAULT true, logout_messages_p bool DEFAULT true, messages_time_window integer DEFAULT 600, avatar_p bool DEFAULT true, ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT chat_rooms_active_p_ck REFERENCES acs_objects (), CONSTRAINT chat_rooms_room_id_pk REFERENCES acs_objects (), CONSTRAINT chat_rooms_room_id_fk REFERENCES acs_objects (), CONSTRAINT chat_rooms_archive_p_ck REFERENCES acs_objects () ); CREATE TRIGGER RI_ConstraintTrigger_a_341187 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341188 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341194 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341195 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341197 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341198 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to chat_rooms: --chat_msgs(chat_rooms_active_p_ck) --chat_msgs(chat_rooms_archive_p_ck) --chat_msgs(chat_rooms_room_id_fk) --chat_msgs(chat_rooms_room_id_pk) --chat_transcripts(chat_rooms_active_p_ck) --chat_transcripts(chat_rooms_archive_p_ck) --chat_transcripts(chat_rooms_room_id_fk) --chat_transcripts(chat_rooms_room_id_pk) -- Table size: 8,192 bytes -- Table rows: 1
Begin main content
