diff options
| author | Adam Soltys <[email protected]> | 2020-08-11 14:18:18 -0700 |
|---|---|---|
| committer | Adam Soltys <[email protected]> | 2020-08-11 14:18:18 -0700 |
| commit | b2208797d3c5559c7e8cc7d35b7a020da0c61193 (patch) | |
| tree | 766f8c595efa2a323b8acff89fcb1b73430c5a88 /db | |
| parent | 10bfc37a656e9862051a6a58ea2acdc561092f6b (diff) | |
| download | coinos-server-b2208797d3c5559c7e8cc7d35b7a020da0c61193.tar.gz coinos-server-b2208797d3c5559c7e8cc7d35b7a020da0c61193.zip | |
account archive toggle
Diffstat (limited to 'db')
| -rw-r--r-- | db/models/accounts.js | 9 | ||||
| -rw-r--r-- | db/schema.sql | 18 |
2 files changed, 20 insertions, 7 deletions
diff --git a/db/models/accounts.js b/db/models/accounts.js index e139956d..89c85ef1 100644 --- a/db/models/accounts.js +++ b/db/models/accounts.js @@ -106,6 +106,15 @@ const attributes = { comment: null, field: "pending" }, + hide: { + type: DataTypes.BOOLEAN, + allowNull: true, + defaultValue: null, + primaryKey: false, + autoIncrement: false, + comment: null, + field: "hide" + }, index: { type: DataTypes.INTEGER(11), allowNull: true, diff --git a/db/schema.sql b/db/schema.sql index 8b11376d..731f7ca9 100644 --- a/db/schema.sql +++ b/db/schema.sql @@ -58,8 +58,12 @@ CREATE TABLE `accounts` ( `precision` int(11) DEFAULT NULL, `domain` varchar(255) DEFAULT NULL, `contract` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, + `pubkey` varchar(255) DEFAULT NULL, + `index` int(11) DEFAULT NULL, + `address` varchar(255) DEFAULT NULL, + `hide` tinyint(1) DEFAULT NULL, PRIMARY KEY (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=3767 DEFAULT CHARSET=latin1; +) ENGINE=InnoDB AUTO_INCREMENT=3786 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -100,7 +104,7 @@ CREATE TABLE `invoices` ( `uuid` varchar(255) DEFAULT NULL, `memo` text DEFAULT NULL, PRIMARY KEY (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=4677 DEFAULT CHARSET=latin1; +) ENGINE=InnoDB AUTO_INCREMENT=5068 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -117,7 +121,7 @@ CREATE TABLE `linkingkeys` ( `createdAt` datetime NOT NULL, `updatedAt` datetime NOT NULL, PRIMARY KEY (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=4505 DEFAULT CHARSET=latin1; +) ENGINE=InnoDB AUTO_INCREMENT=4517 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -148,7 +152,7 @@ CREATE TABLE `payments` ( `redeemcode` varchar(255) DEFAULT NULL, `redeemed` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=4641 DEFAULT CHARSET=latin1; +) ENGINE=InnoDB AUTO_INCREMENT=4972 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -171,7 +175,7 @@ CREATE TABLE `proposals` ( `text` text DEFAULT NULL, `public` tinyint(1) DEFAULT NULL, PRIMARY KEY (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -219,7 +223,7 @@ CREATE TABLE `users` ( `fiat` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `ip` (`ip`) -) ENGINE=InnoDB AUTO_INCREMENT=642 DEFAULT CHARSET=latin1; +) ENGINE=InnoDB AUTO_INCREMENT=652 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; @@ -231,4 +235,4 @@ CREATE TABLE `users` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2020-07-29 16:40:25 +-- Dump completed on 2020-08-11 14:18:10 |