aboutsummaryrefslogtreecommitdiffstats
path: root/db
diff options
context:
space:
mode:
Diffstat (limited to 'db')
-rw-r--r--db/models/accounts.js9
-rw-r--r--db/schema.sql15
2 files changed, 17 insertions, 7 deletions
diff --git a/db/models/accounts.js b/db/models/accounts.js
index 17e03857..12fef548 100644
--- a/db/models/accounts.js
+++ b/db/models/accounts.js
@@ -151,6 +151,15 @@ const attributes = {
comment: null,
field: "index"
},
+ privkey: {
+ type: DataTypes.STRING,
+ allowNull: true,
+ defaultValue: null,
+ primaryKey: false,
+ autoIncrement: false,
+ comment: null,
+ field: "privkey"
+ },
pubkey: {
type: DataTypes.STRING,
allowNull: true,
diff --git a/db/schema.sql b/db/schema.sql
index 2eee5c19..f61482d6 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -64,8 +64,9 @@ CREATE TABLE `accounts` (
`seed` varchar(255) DEFAULT NULL,
`path` varchar(255) DEFAULT NULL,
`network` varchar(255) DEFAULT NULL,
+ `privkey` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=4062 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=4076 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -108,7 +109,7 @@ CREATE TABLE `invoices` (
`account_id` int(11) DEFAULT NULL,
`path` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=6311 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=6422 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -125,7 +126,7 @@ CREATE TABLE `linkingkeys` (
`createdAt` datetime NOT NULL,
`updatedAt` datetime NOT NULL,
PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=4598 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=4605 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -157,7 +158,7 @@ CREATE TABLE `payments` (
`redeemed` tinyint(1) NOT NULL DEFAULT 0,
`path` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=6167 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=6682 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -183,7 +184,7 @@ CREATE TABLE `proposals` (
`a2_id` int(11) DEFAULT NULL,
`fee` double DEFAULT NULL,
PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=918 DEFAULT CHARSET=utf8mb4;
+) ENGINE=InnoDB AUTO_INCREMENT=1023 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -229,7 +230,7 @@ CREATE TABLE `users` (
`index` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
KEY `ip` (`ip`)
-) ENGINE=InnoDB AUTO_INCREMENT=724 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=729 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
@@ -241,4 +242,4 @@ CREATE TABLE `users` (
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2020-09-28 0:55:47
+-- Dump completed on 2020-10-01 0:16:52