From e13c2e7e970fdfb30186edbb58d2982551f1607f Mon Sep 17 00:00:00 2001 From: Vitaly Takmazov Date: Thu, 15 Dec 2022 16:03:23 +0300 Subject: postgres: baseline full schema to 1.22 --- src/main/resources/db/specific/mariadb/V1.1__Add updated_at field.sql | 2 ++ 1 file changed, 2 insertions(+) create mode 100644 src/main/resources/db/specific/mariadb/V1.1__Add updated_at field.sql (limited to 'src/main/resources/db/specific/mariadb/V1.1__Add updated_at field.sql') diff --git a/src/main/resources/db/specific/mariadb/V1.1__Add updated_at field.sql b/src/main/resources/db/specific/mariadb/V1.1__Add updated_at field.sql new file mode 100644 index 00000000..dac179b1 --- /dev/null +++ b/src/main/resources/db/specific/mariadb/V1.1__Add updated_at field.sql @@ -0,0 +1,2 @@ +ALTER TABLE messages_txt ADD COLUMN updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP; +ALTER TABLE replies ADD COLUMN updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP; -- cgit v1.2.3