lamassu-server/packages/server/migrations/1700123461281-customer-email.js
2025-05-12 10:52:54 +01:00

14 lines
266 B
JavaScript

const db = require('./db')
exports.up = function (next) {
let sql = [
'ALTER TABLE customers ADD COLUMN email text unique',
'ALTER TABLE customers ADD COLUMN email_at timestamptz',
]
db.multi(sql, next)
}
exports.down = function (next) {
next()
}