From aecc01cdaf848c19b324dc299cb6ece550a01b29 Mon Sep 17 00:00:00 2001 From: Adam Soltys Date: Tue, 20 Feb 2018 22:44:42 -0800 Subject: keep track of users' invoices --- migrations/20180221010609-createInvoices.js | 32 +++++++++++++++++++++++++++++ 1 file changed, 32 insertions(+) create mode 100644 migrations/20180221010609-createInvoices.js (limited to 'migrations') diff --git a/migrations/20180221010609-createInvoices.js b/migrations/20180221010609-createInvoices.js new file mode 100644 index 00000000..3fbcfa21 --- /dev/null +++ b/migrations/20180221010609-createInvoices.js @@ -0,0 +1,32 @@ +'use strict'; + +module.exports = { + up: (queryInterface, Sequelize) => { + return queryInterface.createTable('invoices', { + id: { + allowNull: false, + autoIncrement: true, + primaryKey: true, + type: Sequelize.INTEGER, + }, + user_id: { + type: Sequelize.INTEGER, + }, + payreq: { + type: Sequelize.STRING, + }, + createdAt: { + allowNull: false, + type: Sequelize.DATE + }, + updatedAt: { + allowNull: false, + type: Sequelize.DATE + }, + }) + }, + + down: (queryInterface, Sequelize) => { + return queryInterface.dropTable('invoices') + }, +}; -- cgit v1.2.3