CREATE TABLE chat_msgs ( msg_id integer PRIMARY KEY NOT NULL, msg varchar(4000), msg_len integer, html_p bool DEFAULT false, approved_p bool DEFAULT true, creation_user integer NOT NULL, creation_ip varchar(50), creation_date timestamptz, room_id integer, ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT chat_msgs_approve_p_ck REFERENCES parties (), CONSTRAINT chat_msgs_creation_user_fk REFERENCES parties (), CONSTRAINT chat_msgs_html_p_ck REFERENCES parties (), CONSTRAINT chat_msgs_msg_id_pk REFERENCES parties (), CONSTRAINT chat_msgs_msg_len_ck REFERENCES parties (), CONSTRAINT chat_msgs_room_id_fk REFERENCES parties () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT chat_msgs_room_id_fk REFERENCES chat_rooms (), CONSTRAINT chat_msgs_approve_p_ck REFERENCES chat_rooms (), CONSTRAINT chat_msgs_creation_user_fk REFERENCES chat_rooms (), CONSTRAINT chat_msgs_html_p_ck REFERENCES chat_rooms (), CONSTRAINT chat_msgs_msg_id_pk REFERENCES chat_rooms (), CONSTRAINT chat_msgs_msg_len_ck REFERENCES chat_rooms () ); CREATE TRIGGER RI_ConstraintTrigger_c_341184 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341185 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341189 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341190 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 0 bytes -- Table rows: 0
Begin main content
