aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authorGravatar Vitaly Takmazov2019-04-07 04:24:04 +0300
committerGravatar Vitaly Takmazov2019-04-07 04:25:49 +0300
commitab4745d3ac3a67b4f18d6df1e876a788a707dba5 (patch)
tree9b4cc2969917c2f76aee7eafe4db3d0cc8a0c8c2 /src
parent618e320e952ba292a13cbe80981807c866baf7c6 (diff)
Increase updated_at precision
Diffstat (limited to 'src')
-rw-r--r--src/main/resources/db/migration/V1.22__increase updated_at precision.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/src/main/resources/db/migration/V1.22__increase updated_at precision.sql b/src/main/resources/db/migration/V1.22__increase updated_at precision.sql
new file mode 100644
index 00000000..22034ea2
--- /dev/null
+++ b/src/main/resources/db/migration/V1.22__increase updated_at precision.sql
@@ -0,0 +1,2 @@
+ALTER TABLE replies MODIFY COLUMN updated_at timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP;
+ALTER TABLE messages_txt MODIFY COLUMN updated_at timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP; \ No newline at end of file