add webhooks to invoices

5 files changed, 21 insertions, 89 deletions

diff --git a/db/migrations/20210612181508_init_referrals.js b/db/migrations/20210612181508_init_referrals.js
deleted file mode 100644
index 260a2c8f..00000000
--- a/db/migrations/20210612181508_init_referrals.js
+++ /dev/null
@@ -1,19 +0,0 @@
-
-exports.up = function(knex) {
-    return knex.schema.createTable('referrals', function(t) {
-        t.increments('id').unsigned().primary();
-
-        t.string('token').notNull();
-        t.string('expiry').nullable();
-        t.enum('status', ['pending', 'active', 'expired', 'cancelled')).notNull().defaultTo('pending');
-        t.int('sponsor_id').notNull();
-	t.foreign('sponsor_id').references('users.user_id')
-        t.int('user_id').nullable();
-	t.foreign('user_id').references('users.user_id')
-
-        t.timestamps();
-};
-
-exports.down = function(knex) {
-  return knex.schema.dropTable('referrals');
-};
diff --git a/db/migrations/20210612192804_init_waiting_list.js.js b/db/migrations/20210612192804_init_waiting_list.js.js
deleted file mode 100644
index 5322cf6d..00000000
--- a/db/migrations/20210612192804_init_waiting_list.js.js
+++ /dev/null
@@ -1,17 +0,0 @@
-
-exports.up = function(knex) {
-    return knex.schema.createTable('waiting_list', function(t) {
-        t.increments('id').unsigned().primary();
-
-        t.string('email').nullable();
-        t.string('sms').nullable();
-        t.enum('status', ['pending', 'contacted', 'registered', 'cancelled')).notNull().defaultTo('pending');
-        t.int('user_id').notNull();
-	t.foreign('user_id').references('users.user_id');
-
-	t.timestamps();  
-};
-
-exports.down = function(knex) {
-    return knex.schema.dropTable('waiting_list');
-};
diff --git a/db/migrations/20210625232223_add_invoice_id_to_payments.js b/db/migrations/20210625232223_add_invoice_id_to_payments.js
new file mode 100644
index 00000000..46e2a82e
--- /dev/null
+++ b/db/migrations/20210625232223_add_invoice_id_to_payments.js
@@ -0,0 +1,10 @@
+exports.up = async knex =>
+  knex.schema.table("payments", function(table) {
+    table.integer("invoice_id");
+    table.foreign("invoice_id").references("invoices.id");
+  });
+
+exports.down = async knex =>
+  knex.schema.table("payments", function(table) {
+    table.dropColumn("invoice_id");
+  });
diff --git a/db/migrations/20210628221727_add_webhook_to_invoices.js b/db/migrations/20210628221727_add_webhook_to_invoices.js
new file mode 100644
index 00000000..073b8d01
--- /dev/null
+++ b/db/migrations/20210628221727_add_webhook_to_invoices.js
@@ -0,0 +1,11 @@
+exports.up = async function(knex) {
+  return knex.schema.table("invoices", function(table) {
+    table.text("webhook");
+  });
+};
+
+exports.down = async function(knex) {
+  return knex.schema.table("invoices", function(table) {
+    table.dropColumn("webhook");
+  });
+};
diff --git a/db/migrations/user_adjustments.js b/db/migrations/user_adjustments.js
deleted file mode 100644
index b4273848..00000000
--- a/db/migrations/user_adjustments.js
+++ /dev/null
@@ -1,53 +0,0 @@
-
-exports.up = function(knex) {
-  return Promise.all([
-
-    // move security fields to separate t (potentially different access permissions)
-    
-    knex.schema.createTable('user_security', function (t) {
-      t.increments('id').unsigned().primary();
-      t.int('user_id').notNull();
-      t.foreign('user_id').references('users.user_id');
-
-      t.boolean('twofa').notNull().defaultTo(false);
-      t.string('pin').notNull();
-      t.string('otp_secret').nullable();
-      t.string('seed').nullable();
-    },
-
-    knex.raw("INSERT INTO user_security (user_id, twofa, pin, otp_secret, seed) SELECT users.id, twofa, pin, otpsecret, seed FROM users"),
-
-    // move user-customizeable fields to separate t (potentially different access permissions)
-
-    knex.schema.createTable('user_preferences', function (t) {
-      t.increments('id').unsigned().primary();
-      t.int('user_id').notNull();
-      t.foreign('user_id').references('users.user_id');
-
-      t.enum('default_unit', ['SAT', 'BTC', 'CAD']).notNull().defaultTo('SAT');
-      t.enum('default_currency', ['CAD', 'USD']).notNull().defaultTo('CAD');
-      t.enum('default_fiat', ['CAD', 'USD']).notNull().defaultTo('CAD');
-      t.set('show_currencies', ['CAD', 'USD']).notNull().defaultTo('CAD');
-    }
-    
-    knex.raw("INSERT INTO user_preferences (user_id, default_unit, default_currency, default_fiat, show_currencies) SELECT users.id, unit, currency, fiat, currencies FROM users"),
-    
-    // remove deprecated fields
-    
-    knex.schema.table('users', function (t) {
-      t.string('uuid');
-      t.enum('access', ['Anonymous', 'Member', 'Admin']).defaultTo('Anonymous');
-
-      t.dropColumn('account_id');
-      t.dropColumn('unit');
-      t.dropColumn('fiat');
-      t.dropColumn('currency');
-      t.dropColumn('currencies');
-    },
-  ])
-  
-};
-
-exports.down = function(knex) {
-  
-};