2 files changed, 26 insertions, 6 deletions
diff --git a/db/models/payments.js b/db/models/payments.js
index f5d970bb..388010a0 100644
--- a/db/models/payments.js
+++ b/db/models/payments.js
@@ -145,6 +145,24 @@ const attributes = {
     comment: null,
     field: "tip"
   },
+  redeemed: {
+    type: DataTypes.BOOLEAN,
+    allowNull: false,
+    defaultValue: false,
+    primaryKey: false,
+    autoIncrement: false,
+    comment: null,
+    field: "redeemed"
+  },
+  redeemcode: {
+    type: DataTypes.STRING(255),
+    allowNull: true,
+    defaultValue: null,
+    primaryKey: false,
+    autoIncrement: false,
+    comment: null,
+    field: "redeemcode"
+  },
   confirmed: {
     type: DataTypes.INTEGER(1),
     allowNull: false,
diff --git a/db/schema.sql b/db/schema.sql
index 9d1feaa3..8b11376d 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -59,7 +59,7 @@ CREATE TABLE `accounts` (
   `domain` varchar(255) DEFAULT NULL,
   `contract` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
   PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=3750 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=3767 DEFAULT CHARSET=latin1;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -100,7 +100,7 @@ CREATE TABLE `invoices` (
   `uuid` varchar(255) DEFAULT NULL,
   `memo` text DEFAULT NULL,
   PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=4672 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=4677 DEFAULT CHARSET=latin1;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -117,7 +117,7 @@ CREATE TABLE `linkingkeys` (
   `createdAt` datetime NOT NULL,
   `updatedAt` datetime NOT NULL,
   PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=4498 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=4505 DEFAULT CHARSET=latin1;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -145,8 +145,10 @@ CREATE TABLE `payments` (
   `account_id` int(11) DEFAULT NULL,
   `preimage` varchar(255) DEFAULT NULL,
   `memo` text DEFAULT NULL,
+  `redeemcode` varchar(255) DEFAULT NULL,
+  `redeemed` tinyint(1) NOT NULL DEFAULT 0,
   PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=4572 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=4641 DEFAULT CHARSET=latin1;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -217,7 +219,7 @@ CREATE TABLE `users` (
   `fiat` tinyint(1) NOT NULL DEFAULT 0,
   PRIMARY KEY (`id`),
   KEY `ip` (`ip`)
-) ENGINE=InnoDB AUTO_INCREMENT=634 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=642 DEFAULT CHARSET=latin1;
 /*!40101 SET character_set_client = @saved_cs_client */;
 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
 
@@ -229,4 +231,4 @@ CREATE TABLE `users` (
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2020-07-27 11:35:33
+-- Dump completed on 2020-07-29 16:40:25