src/main/resources/db/migration/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;