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