1 # ************************************************************
5 # http://www.sequelpro.com/
6 # https://github.com/sequelpro/sequelpro
8 # Host: 127.0.0.1 (MySQL 5.7.24)
9 # Database: vote_reward
10 # Generation Time: 2019-07-22 13:41:50 +0000
11 # ************************************************************
14 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17 /*!40101 SET NAMES utf8 */;
18 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
19 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
20 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
23 # Dump of table chain_statuses
24 # ------------------------------------------------------------
26 DROP TABLE IF EXISTS `chain_statuses`;
28 CREATE TABLE `chain_statuses` (
29 `block_height` int(11) NOT NULL,
30 `block_hash` varchar(64) NOT NULL
31 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
36 # ------------------------------------------------------------
38 DROP TABLE IF EXISTS `utxos`;
40 CREATE TABLE `utxos` (
41 `id` int(11) NOT NULL AUTO_INCREMENT,
42 `output_id` varchar(64) NOT NULL,
43 `xpub` varchar(128) NOT NULL,
44 `vote_address` varchar(62) NOT NULL,
45 `vote_num` bigint(21) NOT NULL,
46 `vote_height` int(11) NOT NULL,
47 `veto_height` int(11) NOT NULL,
49 UNIQUE KEY `output_id` (`output_id`),
51 KEY `vote_height` (`vote_height`),
52 KEY `veto_height` (`veto_height`)
53 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
58 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
59 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
60 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
61 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
62 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
63 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;