gitlab.com/SiaPrime/SiaPrime@v1.4.1/doc/index/index.sql (about)

     1  -- MySQL dump 10.13  Distrib 5.7.17, for macos10.12 (x86_64)
     2  --
     3  -- Host: localhost    Database: siablocks
     4  -- ------------------------------------------------------
     5  -- Server version	5.5.39
     6  
     7  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
     8  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
     9  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
    10  /*!40101 SET NAMES utf8 */;
    11  /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
    12  /*!40103 SET TIME_ZONE='+00:00' */;
    13  /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
    14  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
    15  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
    16  /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
    17  
    18  --
    19  -- Table structure for table `airdrop`
    20  --
    21  
    22  DROP TABLE IF EXISTS `airdrop`;
    23  /*!40101 SET @saved_cs_client     = @@character_set_client */;
    24  /*!40101 SET character_set_client = utf8 */;
    25  CREATE TABLE `airdrop` (
    26    `unlockhash` varchar(76) NOT NULL,
    27    `balance` decimal(36,0) NOT NULL,
    28    UNIQUE KEY `airdrop_unlockhash_uindex` (`unlockhash`)
    29  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    30  /*!40101 SET character_set_client = @saved_cs_client */;
    31  
    32  --
    33  -- Table structure for table `block_meta`
    34  --
    35  
    36  DROP TABLE IF EXISTS `block_meta`;
    37  /*!40101 SET @saved_cs_client     = @@character_set_client */;
    38  /*!40101 SET character_set_client = utf8 */;
    39  CREATE TABLE `block_meta` (
    40    `block_id` varchar(64) NOT NULL,
    41    `height` int(11) NOT NULL,
    42    PRIMARY KEY (`block_id`),
    43    UNIQUE KEY `unique_block_id` (`block_id`),
    44    UNIQUE KEY `height_UNIQUE` (`height`)
    45  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    46  /*!40101 SET character_set_client = @saved_cs_client */;
    47  
    48  --
    49  -- Table structure for table `inputs`
    50  --
    51  
    52  DROP TABLE IF EXISTS `inputs`;
    53  /*!40101 SET @saved_cs_client     = @@character_set_client */;
    54  /*!40101 SET character_set_client = utf8 */;
    55  CREATE TABLE `inputs` (
    56    `output_id` varchar(64) NOT NULL,
    57    `height` int(11) NOT NULL,
    58    `txid` varchar(64) NOT NULL,
    59    PRIMARY KEY (`output_id`),
    60    UNIQUE KEY `output_id_UNIQUE` (`output_id`)
    61  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    62  /*!40101 SET character_set_client = @saved_cs_client */;
    63  
    64  --
    65  -- Table structure for table `outputs`
    66  --
    67  
    68  DROP TABLE IF EXISTS `outputs`;
    69  /*!40101 SET @saved_cs_client     = @@character_set_client */;
    70  /*!40101 SET character_set_client = utf8 */;
    71  CREATE TABLE `outputs` (
    72    `id` varchar(64) NOT NULL,
    73    `amount` decimal(36,0) NOT NULL,
    74    `spent` tinyint(1) NOT NULL DEFAULT '0',
    75    `unlockhash` varchar(76) NOT NULL DEFAULT '',
    76    `txid` varchar(64) DEFAULT '',
    77    `height` int(11) NOT NULL,
    78    `type` enum('normal','mined') NOT NULL DEFAULT 'normal',
    79    PRIMARY KEY (`id`),
    80    UNIQUE KEY `unique_id` (`id`),
    81    KEY `unlockhash_index` (`unlockhash`)
    82  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    83  /*!40101 SET character_set_client = @saved_cs_client */;
    84  
    85  --
    86  -- Table structure for table `transactions`
    87  --
    88  
    89  DROP TABLE IF EXISTS `transactions`;
    90  /*!40101 SET @saved_cs_client     = @@character_set_client */;
    91  /*!40101 SET character_set_client = utf8 */;
    92  CREATE TABLE `transactions` (
    93    `id` varchar(64) NOT NULL,
    94    `height` int(11) NOT NULL,
    95    UNIQUE KEY `unique_id` (`id`)
    96  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    97  /*!40101 SET character_set_client = @saved_cs_client */;
    98  /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
    99  
   100  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
   101  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
   102  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
   103  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
   104  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
   105  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
   106  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
   107  
   108  -- Dump completed on 2018-06-23 21:43:06