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

---
 .../specific/h2/V1.15__drop unused columns add ts for some tables.sql | 4 ++++
 1 file changed, 4 insertions(+)
 create mode 100644 src/main/resources/db/specific/h2/V1.15__drop unused columns add ts for some tables.sql

(limited to 'src/main/resources/db/specific/h2/V1.15__drop unused columns add ts for some tables.sql')

diff --git a/src/main/resources/db/specific/h2/V1.15__drop unused columns add ts for some tables.sql b/src/main/resources/db/specific/h2/V1.15__drop unused columns add ts for some tables.sql
new file mode 100644
index 00000000..2350bff2
--- /dev/null
+++ b/src/main/resources/db/specific/h2/V1.15__drop unused columns add ts for some tables.sql	
@@ -0,0 +1,4 @@
+ALTER TABLE subscr_users DROP COLUMN jid;
+ALTER TABLE subscr_users DROP COLUMN active;
+ALTER TABLE auth ADD COLUMN ts timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP;
+ALTER TABLE mail ADD COLUMN ts timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP;
\ No newline at end of file
-- 
cgit v1.2.3

