aboutsummaryrefslogtreecommitdiff
path: root/src/main/resources/db/migration/V1.21__recreate messages_properties with correct index.sql
diff options
context:
space:
mode:
authorGravatar Vitaly Takmazov2022-12-03 15:28:06 +0300
committerGravatar Vitaly Takmazov2022-12-14 12:57:52 +0300
commit0c0ea8897e64461b1cfa9cd86a939b48f0bdd640 (patch)
treef11c73b8246b0724b26ca08529c3c702e1722d79 /src/main/resources/db/migration/V1.21__recreate messages_properties with correct index.sql
parent8344ea3e3e652f5307ffb6115d6fdebf638ba098 (diff)
Initial PostgreSQL schema and profile
Diffstat (limited to 'src/main/resources/db/migration/V1.21__recreate messages_properties with correct index.sql')
-rw-r--r--src/main/resources/db/migration/V1.21__recreate messages_properties with correct index.sql8
1 files changed, 0 insertions, 8 deletions
diff --git a/src/main/resources/db/migration/V1.21__recreate messages_properties with correct index.sql b/src/main/resources/db/migration/V1.21__recreate messages_properties with correct index.sql
deleted file mode 100644
index 685318af..00000000
--- a/src/main/resources/db/migration/V1.21__recreate messages_properties with correct index.sql
+++ /dev/null
@@ -1,8 +0,0 @@
-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)
-) \ No newline at end of file