aboutsummaryrefslogtreecommitdiff
path: root/src/main/resources/db/specific/mariadb/V1.15__drop unused columns add ts for some tables.sql
blob: 2350bff2a0329c33ce28b7527f9f145b652f0840 (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;