lamassu-server/packages/server/migrations/1627563019030-add-customer-tc-photo-path.js
2025-12-31 19:04:13 +01:00

13 lines
380 B
JavaScript

const db = require('./db')
exports.up = function (next) {
const sql = [
'ALTER TABLE cash_in_txs ADD COLUMN tx_customer_photo_at TIMESTAMPTZ, ADD COLUMN tx_customer_photo_path TEXT',
'ALTER TABLE cash_out_txs ADD COLUMN tx_customer_photo_at TIMESTAMPTZ, ADD COLUMN tx_customer_photo_path TEXT',
]
db.runAll(sql, next)
}
exports.down = function (next) {
next()
}