3 files changed, 24 insertions, 4 deletions
diff --git a/db/models/invoices.js b/db/models/invoices.js
index 6fb68c31..231ed6f6 100644
--- a/db/models/invoices.js
+++ b/db/models/invoices.js
@@ -64,6 +64,15 @@ const attributes = {
     comment: null,
     field: "uuid"
   },
+  memo: {
+    type: DataTypes.TEXT,
+    allowNull: true,
+    defaultValue: null,
+    primaryKey: false,
+    autoIncrement: false,
+    comment: null,
+    field: "memo"
+  },
   network: {
     type: DataTypes.STRING(255),
     allowNull: true,
diff --git a/db/models/payments.js b/db/models/payments.js
index 51ef2550..f5d970bb 100644
--- a/db/models/payments.js
+++ b/db/models/payments.js
@@ -28,6 +28,15 @@ const attributes = {
     comment: null,
     field: "user_id"
   },
+  memo: {
+    type: DataTypes.TEXT,
+    allowNull: true,
+    defaultValue: null,
+    primaryKey: false,
+    autoIncrement: false,
+    comment: null,
+    field: "memo"
+  },
   hash: {
     type: DataTypes.TEXT,
     allowNull: true,
diff --git a/db/schema.sql b/db/schema.sql
index e6a3c4b8..940a3490 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -57,7 +57,7 @@ CREATE TABLE `accounts` (
   `ticker` varchar(255) DEFAULT NULL,
   `precision` int(11) DEFAULT NULL,
   PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=3729 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=3730 DEFAULT CHARSET=latin1;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -96,8 +96,9 @@ CREATE TABLE `invoices` (
   `network` varchar(255) DEFAULT NULL,
   `unconfidential` varchar(255) DEFAULT NULL,
   `uuid` varchar(255) DEFAULT NULL,
+  `memo` text DEFAULT NULL,
   PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=4600 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=4626 DEFAULT CHARSET=latin1;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -141,8 +142,9 @@ CREATE TABLE `payments` (
   `network` varchar(255) DEFAULT NULL,
   `account_id` int(11) DEFAULT NULL,
   `preimage` varchar(255) DEFAULT NULL,
+  `memo` text DEFAULT NULL,
   PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=4437 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=4458 DEFAULT CHARSET=latin1;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -202,4 +204,4 @@ CREATE TABLE `users` (
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2020-07-16 13:52:58
+-- Dump completed on 2020-07-17 20:55:55