aboutsummaryrefslogtreecommitdiff
path: root/juick-server/src/main/resources/db/migration/V1.15__drop unused columns add ts for some tables.sql
blob: 6b3ab3880cff52795c122d6f071c7ebf64d4753e (plain) (blame)
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;