src/main/resources/db/migration/V1.19__messages_properties.sql


1
2
3
4
5
6

CREATE TABLE messages_properties (
  message_id int(10) unsigned NOT NULL,
  property_key varchar(255) NOT NULL,
  property_value mediumtext NOT NULL,
  UNIQUE KEY message_key(message_id, property_key)
)