aboutsummaryrefslogtreecommitdiff
path: root/src/main/resources/db/specific/h2/V1.24__fix_lastmessage.sql
diff options
context:
space:
mode:
authorGravatar Vitaly Takmazov2022-12-22 01:44:15 +0300
committerGravatar Vitaly Takmazov2022-12-22 01:44:32 +0300
commit56afc659e9e8e9b22ece74d5733e718f882da783 (patch)
treef61f201b07fd80642e36751bd59bee184627599d /src/main/resources/db/specific/h2/V1.24__fix_lastmessage.sql
parentc91692786f3688a8b98d34d9ca1f0c7874f9f0d3 (diff)
h2: baseline to 1.22
Diffstat (limited to 'src/main/resources/db/specific/h2/V1.24__fix_lastmessage.sql')
-rw-r--r--src/main/resources/db/specific/h2/V1.24__fix_lastmessage.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/src/main/resources/db/specific/h2/V1.24__fix_lastmessage.sql b/src/main/resources/db/specific/h2/V1.24__fix_lastmessage.sql
index 399abf01..bcca2b50 100644
--- a/src/main/resources/db/specific/h2/V1.24__fix_lastmessage.sql
+++ b/src/main/resources/db/specific/h2/V1.24__fix_lastmessage.sql
@@ -1 +1,2 @@
-ALTER TABLE users MODIFY COLUMN lastmessage TIMESTAMP(6) NULL \ No newline at end of file
+ALTER TABLE users ALTER COLUMN lastmessage SET NULL
+