src/main/resources/db/specific/postgresql/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 bigint NOT NULL,
  reply_id smallint NOT NULL,
  property_key character varying(255) NOT NULL,
  property_value text NOT NULL,
  CONSTRAINT message_properties_key UNIQUE(message_id, reply_id, property_key)
)