X-Git-Url: http://git.osdn.net/view?p=bytom%2Fvapor.git;a=blobdiff_plain;f=toolbar%2Freward%2Fdatabase%2Fdump_reward.sql;fp=toolbar%2Freward%2Fdatabase%2Fdump_reward.sql;h=0000000000000000000000000000000000000000;hp=59938678be844627ccf99f1e1cb6240199fab859;hb=3df751629b0461637eef6d863f5f679c908c7eb4;hpb=4bc8c34936504eb903d2e8b5cf78473d41681b12 diff --git a/toolbar/reward/database/dump_reward.sql b/toolbar/reward/database/dump_reward.sql deleted file mode 100644 index 59938678..00000000 --- a/toolbar/reward/database/dump_reward.sql +++ /dev/null @@ -1,29 +0,0 @@ -SET NAMES utf8mb4; -SET FOREIGN_KEY_CHECKS = 0; - --- ---------------------------- --- Table structure for block_state --- ---------------------------- -DROP TABLE IF EXISTS `block_state`; -CREATE TABLE `block_state` ( - `height` int(11) NOT NULL, - `block_hash` varchar(64) NOT NULL -) ENGINE = InnoDB DEFAULT CHARSET=utf8; - --- ---------------------------- --- Table structure for vote --- ---------------------------- -DROP TABLE IF EXISTS `vote`; -CREATE TABLE `vote` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `xpub` varchar(128) NOT NULL, - `voter_address` varchar(62) NOT NULL, - `vote_height` int(11) NOT NULL, - `vote_num` int(11) NOT NULL, - `veto_height` int(11) NOT NULL, - `output_id` varchar(64) NOT NULL, - PRIMARY KEY (`id`) USING BTREE, - UNIQUE INDEX `xpub`(`xpub`, `vote_height`, `output_id`) USING BTREE -) ENGINE = InnoDB AUTO_INCREMENT = 6 DEFAULT CHARSET=utf8; - -SET FOREIGN_KEY_CHECKS = 1;