src/main/resources/db/specific/h2/V1.15__drop unused columns add ts for some tables.sql


1
2
3
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;