From 1db7a0b0a2e897b67617a67fc852f538baecce76 Mon Sep 17 00:00:00 2001
From: Adrien Hopkins <ahopk127@my.yorku.ca>
Date: Tue, 31 May 2022 14:14:06 -0500
Subject: Add fee payment to database

---
 db/index.js           | 5 +++++
 db/models/payments.js | 9 +++++++++
 2 files changed, 14 insertions(+)

(limited to 'db')

diff --git a/db/index.js b/db/index.js
index 57586954..5a10a01a 100644
--- a/db/index.js
+++ b/db/index.js
@@ -162,4 +162,9 @@ Referral.belongsTo(User, {
   foreignKey: "user_id",
 });
 
+Payment.belongsTo(Payment, {
+  as: "fee",
+  foreignKey: "fee_payment_id"
+});
+
 db.Order = Order;
diff --git a/db/models/payments.js b/db/models/payments.js
index c315a5a0..bbf7c436 100644
--- a/db/models/payments.js
+++ b/db/models/payments.js
@@ -189,6 +189,15 @@ const attributes = {
     autoIncrement: false,
     comment: null,
     field: "confirmed"
+  },
+  fee_payment_id: {
+    type: DataTypes.INTEGER(11),
+    allowNull: true,
+    defaultValue: null,
+    primaryKey: false,
+    autoIncrement: false,
+    comment: null,
+    field: "fee_payment_id"
   }
 };
 
-- 
cgit v1.2.3