1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
var dbm = require('db-migrate');
var async = require('async');
var type = dbm.dataType;
exports.up = function(db, callback) {
async.series([
db.createTable.bind(db, 'settlements', {
id: { type: 'int', primaryKey: true, autoIncrement: true },
settler_id: { type: 'int' },
merchant_id: { type: 'int' },
amount: { type: 'decimal' },
date: { type: 'datetime' },
method: { type: 'string' }
}),
db.runSql.bind(db, 'ALTER TABLE settlements ALTER COLUMN amount type decimal(10,2);')
], callback);
};
exports.down = function(db, callback) {
db.dropTable('settlements', callback);
};
|
