src/main/resources/db/specific/h2/V1.21__recreate messages_properties with correct index.sql


1
2
3
4
5
6
7
8

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