2 SET FOREIGN_KEY_CHECKS = 0;
4 -- ----------------------------
5 -- Table structure for block_state
6 -- ----------------------------
7 DROP TABLE IF EXISTS `block_state`;
8 CREATE TABLE `block_state` (
9 `height` int(11) NOT NULL,
10 `block_hash` varchar(64) NOT NULL
11 ) ENGINE = InnoDB DEFAULT CHARSET=utf8;
13 -- ----------------------------
14 -- Table structure for vote
15 -- ----------------------------
16 DROP TABLE IF EXISTS `vote`;
18 `id` int(11) NOT NULL AUTO_INCREMENT,
19 `xpub` varchar(128) NOT NULL,
20 `voter_address` varchar(62) NOT NULL,
21 `vote_height` int(11) NOT NULL,
22 `vote_num` int(11) NOT NULL,
23 `veto_height` int(11) NOT NULL,
24 `output_id` varchar(64) NOT NULL,
25 PRIMARY KEY (`id`) USING BTREE,
26 UNIQUE INDEX `xpub`(`xpub`, `vote_height`, `output_id`) USING BTREE
27 ) ENGINE = InnoDB AUTO_INCREMENT = 6 DEFAULT CHARSET=utf8;
29 SET FOREIGN_KEY_CHECKS = 1;