github.com/bytom/bytom@v1.1.2-0.20221014091027-bbcba3df6075/toolbar/vote_reward/database/dump_reward.sql (about)

     1  # ************************************************************
     2  # Sequel Pro SQL dump
     3  # Version 4541
     4  #
     5  # http://www.sequelpro.com/
     6  # https://github.com/sequelpro/sequelpro
     7  #
     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  # ************************************************************
    12  
    13  
    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 */;
    21  
    22  
    23  # Dump of table chain_statuses
    24  # ------------------------------------------------------------
    25  
    26  DROP TABLE IF EXISTS `chain_statuses`;
    27  
    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;
    32  
    33  
    34  
    35  # Dump of table utxos
    36  # ------------------------------------------------------------
    37  
    38  DROP TABLE IF EXISTS `utxos`;
    39  
    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,
    48    PRIMARY KEY (`id`),
    49    UNIQUE KEY `output_id` (`output_id`),
    50    KEY `xpub` (`xpub`),
    51    KEY `vote_height` (`vote_height`),
    52    KEY `veto_height` (`veto_height`)
    53  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    54  
    55  
    56  
    57  
    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 */;