Create merchants_settlers join table

3 files changed, 23 insertions, 6 deletions

diff --git a/migrations/20131110070704-add-merchants.js b/migrations/20131110070704-add-merchants.js
index 61e718f4..a4f3f7dd 100644
--- a/migrations/20131110070704-add-merchants.js
+++ b/migrations/20131110070704-add-merchants.js
@@ -1,14 +1,16 @@
 var dbm = require('db-migrate');
+var async = require('async');
 var type = dbm.dataType;
 
 exports.up = function(db, callback) {
-  db.createTable('merchants', {
+  async.series([db.bind.createTable('merchants', {
       user_id: { type: 'int', primaryKey: true },
       formula: { type: 'string' },
       limit: { type: 'decimal' }
-    }, callback);
+    }),
+    db.runSql('ALTER TABLE merchants ALTER COLUMN "limit" type decimal(10,2);')
+    ], callback);
 
-  db.runSql('ALTER TABLE merchants ALTER COLUMN "limit" type decimal(10,2);');
 };
 
 exports.down = function(db, callback) {
diff --git a/migrations/20131110070850-add-orders.js b/migrations/20131110070850-add-orders.js
index 39b31139..b0a7d474 100644
--- a/migrations/20131110070850-add-orders.js
+++ b/migrations/20131110070850-add-orders.js
@@ -13,9 +13,9 @@ exports.up = function(db, callback) {
       creation_time: { type: 'datetime' },
       expiration_time: { type: 'datetime' }
     }),
-    db.runSql('ALTER TABLE orders ALTER COLUMN amount type decimal(10,2);', callback),
-    db.runSql('ALTER TABLE orders ALTER COLUMN rate type decimal(10,2);', callback)
-  ]);
+    db.runSql('ALTER TABLE orders ALTER COLUMN amount type decimal(10,2);'),
+    db.runSql('ALTER TABLE orders ALTER COLUMN rate type decimal(10,2);')
+  ], callback);
 };
 
 exports.down = function(db, callback) {
diff --git a/migrations/20131114144958-add-merchants_settlers.js b/migrations/20131114144958-add-merchants_settlers.js
new file mode 100644
index 00000000..28e8b136
--- /dev/null
+++ b/migrations/20131114144958-add-merchants_settlers.js
@@ -0,0 +1,15 @@
+var dbm = require('db-migrate');
+var type = dbm.dataType;
+
+exports.up = function(db, callback) {
+  db.createTable('merchants_settlers', {
+      merchant_id: { type: 'int' },
+      settler_id: { type: 'int' },
+      schedule: { type: 'int' },
+      method_id: { type: 'int' }
+    }, callback);
+};
+
+exports.down = function(db, callback) {
+  db.dropTable('merchants_settlers', callback);
+};