support receiving liquid assets

2 files changed, 23 insertions, 3 deletions

diff --git a/db/index.js b/db/index.js
index b411a8ef..bb94fb98 100644
--- a/db/index.js
+++ b/db/index.js
@@ -8,12 +8,13 @@ db = new Sequelize(conf.database, conf.username, conf.password, {
   dialectOptions: { multipleStatements: true }
 });
 
+require("./models/accounts.js");
 require("./models/invoices.js");
 require("./models/payments.js");
 require("./models/users.js");
 
-db["User"].hasMany(db["Payment"], {
-  as: "payments",
+db["User"].hasMany(db["Account"], {
+  as: "accounts",
   foreignKey: "user_id"
 });
 
@@ -22,7 +23,12 @@ db["User"].hasMany(db["Invoice"], {
   foreignKey: "user_id"
 });
 
-db["Payment"].belongsTo(db["User"], {
+db["User"].hasMany(db["Payment"], {
+  as: "payments",
+  foreignKey: "user_id"
+});
+
+db["Account"].belongsTo(db["User"], {
   as: "user",
   foreignKey: "user_id"
 });
@@ -31,3 +37,8 @@ db["Invoice"].belongsTo(db["User"], {
   as: "user",
   foreignKey: "user_id"
 });
+
+db["Payment"].belongsTo(db["User"], {
+  as: "user",
+  foreignKey: "user_id"
+});
diff --git a/db/models/accounts.js b/db/models/accounts.js
index 57c9e82a..aeaf8d5e 100644
--- a/db/models/accounts.js
+++ b/db/models/accounts.js
@@ -55,6 +55,15 @@ const attributes = {
     comment: null,
     field: "balance"
   },
+  pending: {
+    type: DataTypes.DOUBLE,
+    allowNull: true,
+    defaultValue: null,
+    primaryKey: false,
+    autoIncrement: false,
+    comment: null,
+    field: "pending"
+  },
 };
 
 const options = {