· 9 years ago · Oct 21, 2016, 06:34 PM
1-- MySQL dump 10.13 Distrib 5.7.16, for osx10.12 (x86_64)
2--
3-- Host: localhost Database: abe
4-- ------------------------------------------------------
5-- Server version 5.7.16
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 `abe_lock`
20--
21
22DROP TABLE IF EXISTS `abe_lock`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `abe_lock` (
26 `lock_id` decimal(10,0) NOT NULL,
27 `pid` varchar(255) DEFAULT NULL,
28 PRIMARY KEY (`lock_id`)
29) ENGINE=InnoDB DEFAULT CHARSET=latin1;
30/*!40101 SET character_set_client = @saved_cs_client */;
31
32--
33-- Table structure for table `block`
34--
35
36DROP TABLE IF EXISTS `block`;
37/*!40101 SET @saved_cs_client = @@character_set_client */;
38/*!40101 SET character_set_client = utf8 */;
39CREATE TABLE `block` (
40 `block_id` decimal(14,0) NOT NULL,
41 `block_hash` binary(32) NOT NULL,
42 `block_version` decimal(10,0) DEFAULT NULL,
43 `block_hashMerkleRoot` binary(32) DEFAULT NULL,
44 `block_nTime` decimal(20,0) DEFAULT NULL,
45 `block_nBits` decimal(10,0) DEFAULT NULL,
46 `block_nNonce` decimal(10,0) DEFAULT NULL,
47 `block_height` decimal(14,0) DEFAULT NULL,
48 `prev_block_id` decimal(14,0) DEFAULT NULL,
49 `search_block_id` decimal(14,0) DEFAULT NULL,
50 `block_chain_work` binary(38) DEFAULT NULL,
51 `block_value_in` decimal(30,0) DEFAULT NULL,
52 `block_value_out` decimal(30,0) DEFAULT NULL,
53 `block_total_satoshis` decimal(26,0) DEFAULT NULL,
54 `block_total_seconds` decimal(20,0) DEFAULT NULL,
55 `block_satoshi_seconds` decimal(28,0) DEFAULT NULL,
56 `block_total_ss` decimal(28,0) DEFAULT NULL,
57 `block_num_tx` decimal(10,0) NOT NULL,
58 `block_ss_destroyed` decimal(28,0) DEFAULT NULL,
59 PRIMARY KEY (`block_id`),
60 UNIQUE KEY `block_hash` (`block_hash`),
61 KEY `prev_block_id` (`prev_block_id`),
62 KEY `search_block_id` (`search_block_id`),
63 CONSTRAINT `block_ibfk_1` FOREIGN KEY (`prev_block_id`) REFERENCES `block` (`block_id`),
64 CONSTRAINT `block_ibfk_2` FOREIGN KEY (`search_block_id`) REFERENCES `block` (`block_id`)
65) ENGINE=InnoDB DEFAULT CHARSET=latin1;
66/*!40101 SET character_set_client = @saved_cs_client */;
67
68--
69-- Table structure for table `block_next`
70--
71
72DROP TABLE IF EXISTS `block_next`;
73/*!40101 SET @saved_cs_client = @@character_set_client */;
74/*!40101 SET character_set_client = utf8 */;
75CREATE TABLE `block_next` (
76 `block_id` decimal(14,0) NOT NULL,
77 `next_block_id` decimal(14,0) NOT NULL,
78 PRIMARY KEY (`block_id`,`next_block_id`),
79 KEY `next_block_id` (`next_block_id`),
80 CONSTRAINT `block_next_ibfk_1` FOREIGN KEY (`block_id`) REFERENCES `block` (`block_id`),
81 CONSTRAINT `block_next_ibfk_2` FOREIGN KEY (`next_block_id`) REFERENCES `block` (`block_id`)
82) ENGINE=InnoDB DEFAULT CHARSET=latin1;
83/*!40101 SET character_set_client = @saved_cs_client */;
84
85--
86-- Table structure for table `block_seq`
87--
88
89DROP TABLE IF EXISTS `block_seq`;
90/*!40101 SET @saved_cs_client = @@character_set_client */;
91/*!40101 SET character_set_client = utf8 */;
92CREATE TABLE `block_seq` (
93 `id` bigint(20) NOT NULL AUTO_INCREMENT,
94 PRIMARY KEY (`id`)
95) ENGINE=InnoDB AUTO_INCREMENT=192127 DEFAULT CHARSET=latin1;
96/*!40101 SET character_set_client = @saved_cs_client */;
97
98--
99-- Table structure for table `block_tx`
100--
101
102DROP TABLE IF EXISTS `block_tx`;
103/*!40101 SET @saved_cs_client = @@character_set_client */;
104/*!40101 SET character_set_client = utf8 */;
105CREATE TABLE `block_tx` (
106 `block_id` decimal(14,0) NOT NULL,
107 `tx_id` decimal(26,0) NOT NULL,
108 `tx_pos` decimal(10,0) NOT NULL,
109 PRIMARY KEY (`block_id`,`tx_id`),
110 UNIQUE KEY `block_id` (`block_id`,`tx_pos`),
111 KEY `x_block_tx_tx` (`tx_id`),
112 CONSTRAINT `block_tx_ibfk_1` FOREIGN KEY (`block_id`) REFERENCES `block` (`block_id`),
113 CONSTRAINT `block_tx_ibfk_2` FOREIGN KEY (`tx_id`) REFERENCES `tx` (`tx_id`)
114) ENGINE=InnoDB DEFAULT CHARSET=latin1;
115/*!40101 SET character_set_client = @saved_cs_client */;
116
117--
118-- Table structure for table `block_txin`
119--
120
121DROP TABLE IF EXISTS `block_txin`;
122/*!40101 SET @saved_cs_client = @@character_set_client */;
123/*!40101 SET character_set_client = utf8 */;
124CREATE TABLE `block_txin` (
125 `block_id` decimal(14,0) NOT NULL,
126 `txin_id` decimal(26,0) NOT NULL,
127 `out_block_id` decimal(14,0) NOT NULL,
128 PRIMARY KEY (`block_id`,`txin_id`),
129 KEY `txin_id` (`txin_id`),
130 KEY `out_block_id` (`out_block_id`),
131 CONSTRAINT `block_txin_ibfk_1` FOREIGN KEY (`block_id`) REFERENCES `block` (`block_id`),
132 CONSTRAINT `block_txin_ibfk_2` FOREIGN KEY (`txin_id`) REFERENCES `txin` (`txin_id`),
133 CONSTRAINT `block_txin_ibfk_3` FOREIGN KEY (`out_block_id`) REFERENCES `block` (`block_id`)
134) ENGINE=InnoDB DEFAULT CHARSET=latin1;
135/*!40101 SET character_set_client = @saved_cs_client */;
136
137--
138-- Table structure for table `chain`
139--
140
141DROP TABLE IF EXISTS `chain`;
142/*!40101 SET @saved_cs_client = @@character_set_client */;
143/*!40101 SET character_set_client = utf8 */;
144CREATE TABLE `chain` (
145 `chain_id` decimal(10,0) NOT NULL,
146 `chain_name` varchar(100) NOT NULL,
147 `chain_code3` varchar(5) DEFAULT NULL,
148 `chain_address_version` varbinary(100) NOT NULL,
149 `chain_script_addr_vers` varbinary(100) DEFAULT NULL,
150 `chain_magic` binary(4) DEFAULT NULL,
151 `chain_policy` varchar(255) NOT NULL,
152 `chain_decimals` decimal(2,0) DEFAULT NULL,
153 `chain_last_block_id` decimal(14,0) DEFAULT NULL,
154 PRIMARY KEY (`chain_id`),
155 UNIQUE KEY `chain_name` (`chain_name`),
156 KEY `chain_last_block_id` (`chain_last_block_id`),
157 CONSTRAINT `chain_ibfk_1` FOREIGN KEY (`chain_last_block_id`) REFERENCES `block` (`block_id`)
158) ENGINE=InnoDB DEFAULT CHARSET=latin1;
159/*!40101 SET character_set_client = @saved_cs_client */;
160
161--
162-- Table structure for table `chain_candidate`
163--
164
165DROP TABLE IF EXISTS `chain_candidate`;
166/*!40101 SET @saved_cs_client = @@character_set_client */;
167/*!40101 SET character_set_client = utf8 */;
168CREATE TABLE `chain_candidate` (
169 `chain_id` decimal(10,0) NOT NULL,
170 `block_id` decimal(14,0) NOT NULL,
171 `in_longest` decimal(1,0) DEFAULT NULL,
172 `block_height` decimal(14,0) DEFAULT NULL,
173 PRIMARY KEY (`chain_id`,`block_id`),
174 KEY `x_cc_block` (`block_id`),
175 KEY `x_cc_chain_block_height` (`chain_id`,`block_height`),
176 KEY `x_cc_block_height` (`block_height`),
177 CONSTRAINT `chain_candidate_ibfk_1` FOREIGN KEY (`block_id`) REFERENCES `block` (`block_id`)
178) ENGINE=InnoDB DEFAULT CHARSET=latin1;
179/*!40101 SET character_set_client = @saved_cs_client */;
180
181--
182-- Table structure for table `chain_seq`
183--
184
185DROP TABLE IF EXISTS `chain_seq`;
186/*!40101 SET @saved_cs_client = @@character_set_client */;
187/*!40101 SET character_set_client = utf8 */;
188CREATE TABLE `chain_seq` (
189 `id` bigint(20) NOT NULL AUTO_INCREMENT,
190 PRIMARY KEY (`id`)
191) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;
192/*!40101 SET character_set_client = @saved_cs_client */;
193
194--
195-- Temporary view structure for view `chain_summary`
196--
197
198DROP TABLE IF EXISTS `chain_summary`;
199/*!50001 DROP VIEW IF EXISTS `chain_summary`*/;
200SET @saved_cs_client = @@character_set_client;
201SET character_set_client = utf8;
202/*!50001 CREATE VIEW `chain_summary` AS SELECT
203 1 AS `chain_id`,
204 1 AS `in_longest`,
205 1 AS `block_id`,
206 1 AS `block_hash`,
207 1 AS `block_version`,
208 1 AS `block_hashMerkleRoot`,
209 1 AS `block_nTime`,
210 1 AS `block_nBits`,
211 1 AS `block_nNonce`,
212 1 AS `block_height`,
213 1 AS `prev_block_id`,
214 1 AS `prev_block_hash`,
215 1 AS `block_chain_work`,
216 1 AS `block_num_tx`,
217 1 AS `block_value_in`,
218 1 AS `block_value_out`,
219 1 AS `block_total_satoshis`,
220 1 AS `block_total_seconds`,
221 1 AS `block_satoshi_seconds`,
222 1 AS `block_total_ss`,
223 1 AS `block_ss_destroyed`*/;
224SET character_set_client = @saved_cs_client;
225
226--
227-- Table structure for table `configvar`
228--
229
230DROP TABLE IF EXISTS `configvar`;
231/*!40101 SET @saved_cs_client = @@character_set_client */;
232/*!40101 SET character_set_client = utf8 */;
233CREATE TABLE `configvar` (
234 `configvar_name` varchar(100) NOT NULL,
235 `configvar_value` varchar(255) DEFAULT NULL,
236 PRIMARY KEY (`configvar_name`)
237) ENGINE=InnoDB DEFAULT CHARSET=latin1;
238/*!40101 SET character_set_client = @saved_cs_client */;
239
240--
241-- Table structure for table `datadir`
242--
243
244DROP TABLE IF EXISTS `datadir`;
245/*!40101 SET @saved_cs_client = @@character_set_client */;
246/*!40101 SET character_set_client = utf8 */;
247CREATE TABLE `datadir` (
248 `datadir_id` decimal(10,0) NOT NULL,
249 `dirname` varchar(2000) NOT NULL,
250 `blkfile_number` decimal(8,0) DEFAULT NULL,
251 `blkfile_offset` decimal(20,0) DEFAULT NULL,
252 `chain_id` decimal(10,0) DEFAULT NULL,
253 PRIMARY KEY (`datadir_id`)
254) ENGINE=InnoDB DEFAULT CHARSET=latin1;
255/*!40101 SET character_set_client = @saved_cs_client */;
256
257--
258-- Table structure for table `datadir_seq`
259--
260
261DROP TABLE IF EXISTS `datadir_seq`;
262/*!40101 SET @saved_cs_client = @@character_set_client */;
263/*!40101 SET character_set_client = utf8 */;
264CREATE TABLE `datadir_seq` (
265 `id` bigint(20) NOT NULL AUTO_INCREMENT,
266 PRIMARY KEY (`id`)
267) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
268/*!40101 SET character_set_client = @saved_cs_client */;
269
270--
271-- Table structure for table `multisig_pubkey`
272--
273
274DROP TABLE IF EXISTS `multisig_pubkey`;
275/*!40101 SET @saved_cs_client = @@character_set_client */;
276/*!40101 SET character_set_client = utf8 */;
277CREATE TABLE `multisig_pubkey` (
278 `multisig_id` decimal(26,0) NOT NULL,
279 `pubkey_id` decimal(26,0) NOT NULL,
280 PRIMARY KEY (`multisig_id`,`pubkey_id`),
281 KEY `x_multisig_pubkey_pubkey` (`pubkey_id`),
282 CONSTRAINT `multisig_pubkey_ibfk_1` FOREIGN KEY (`multisig_id`) REFERENCES `pubkey` (`pubkey_id`),
283 CONSTRAINT `multisig_pubkey_ibfk_2` FOREIGN KEY (`pubkey_id`) REFERENCES `pubkey` (`pubkey_id`)
284) ENGINE=InnoDB DEFAULT CHARSET=latin1;
285/*!40101 SET character_set_client = @saved_cs_client */;
286
287--
288-- Table structure for table `orphan_block`
289--
290
291DROP TABLE IF EXISTS `orphan_block`;
292/*!40101 SET @saved_cs_client = @@character_set_client */;
293/*!40101 SET character_set_client = utf8 */;
294CREATE TABLE `orphan_block` (
295 `block_id` decimal(14,0) NOT NULL,
296 `block_hashPrev` binary(32) NOT NULL,
297 PRIMARY KEY (`block_id`),
298 KEY `x_orphan_block_hashPrev` (`block_hashPrev`),
299 CONSTRAINT `orphan_block_ibfk_1` FOREIGN KEY (`block_id`) REFERENCES `block` (`block_id`)
300) ENGINE=InnoDB DEFAULT CHARSET=latin1;
301/*!40101 SET character_set_client = @saved_cs_client */;
302
303--
304-- Table structure for table `pubkey`
305--
306
307DROP TABLE IF EXISTS `pubkey`;
308/*!40101 SET @saved_cs_client = @@character_set_client */;
309/*!40101 SET character_set_client = utf8 */;
310CREATE TABLE `pubkey` (
311 `pubkey_id` decimal(26,0) NOT NULL,
312 `pubkey_hash` binary(20) NOT NULL,
313 `pubkey` blob,
314 PRIMARY KEY (`pubkey_id`),
315 UNIQUE KEY `pubkey_hash` (`pubkey_hash`)
316) ENGINE=InnoDB DEFAULT CHARSET=latin1;
317/*!40101 SET character_set_client = @saved_cs_client */;
318
319--
320-- Table structure for table `pubkey_seq`
321--
322
323DROP TABLE IF EXISTS `pubkey_seq`;
324/*!40101 SET @saved_cs_client = @@character_set_client */;
325/*!40101 SET character_set_client = utf8 */;
326CREATE TABLE `pubkey_seq` (
327 `id` bigint(20) NOT NULL AUTO_INCREMENT,
328 PRIMARY KEY (`id`)
329) ENGINE=InnoDB AUTO_INCREMENT=5363788 DEFAULT CHARSET=latin1;
330/*!40101 SET character_set_client = @saved_cs_client */;
331
332--
333-- Table structure for table `tx`
334--
335
336DROP TABLE IF EXISTS `tx`;
337/*!40101 SET @saved_cs_client = @@character_set_client */;
338/*!40101 SET character_set_client = utf8 */;
339CREATE TABLE `tx` (
340 `tx_id` decimal(26,0) NOT NULL,
341 `tx_hash` binary(32) NOT NULL,
342 `tx_version` decimal(10,0) DEFAULT NULL,
343 `tx_lockTime` decimal(10,0) DEFAULT NULL,
344 `tx_size` decimal(10,0) DEFAULT NULL,
345 PRIMARY KEY (`tx_id`),
346 UNIQUE KEY `tx_hash` (`tx_hash`)
347) ENGINE=InnoDB DEFAULT CHARSET=latin1;
348/*!40101 SET character_set_client = @saved_cs_client */;
349
350--
351-- Table structure for table `tx_seq`
352--
353
354DROP TABLE IF EXISTS `tx_seq`;
355/*!40101 SET @saved_cs_client = @@character_set_client */;
356/*!40101 SET character_set_client = utf8 */;
357CREATE TABLE `tx_seq` (
358 `id` bigint(20) NOT NULL AUTO_INCREMENT,
359 PRIMARY KEY (`id`)
360) ENGINE=InnoDB AUTO_INCREMENT=5580647 DEFAULT CHARSET=latin1;
361/*!40101 SET character_set_client = @saved_cs_client */;
362
363--
364-- Table structure for table `txin`
365--
366
367DROP TABLE IF EXISTS `txin`;
368/*!40101 SET @saved_cs_client = @@character_set_client */;
369/*!40101 SET character_set_client = utf8 */;
370CREATE TABLE `txin` (
371 `txin_id` decimal(26,0) NOT NULL,
372 `tx_id` decimal(26,0) NOT NULL,
373 `txin_pos` decimal(10,0) NOT NULL,
374 `txout_id` decimal(26,0) DEFAULT NULL,
375 `txin_scriptSig` blob,
376 `txin_sequence` decimal(10,0) DEFAULT NULL,
377 PRIMARY KEY (`txin_id`),
378 UNIQUE KEY `tx_id` (`tx_id`,`txin_pos`),
379 KEY `x_txin_txout` (`txout_id`),
380 CONSTRAINT `txin_ibfk_1` FOREIGN KEY (`tx_id`) REFERENCES `tx` (`tx_id`)
381) ENGINE=InnoDB DEFAULT CHARSET=latin1;
382/*!40101 SET character_set_client = @saved_cs_client */;
383
384--
385-- Temporary view structure for view `txin_detail`
386--
387
388DROP TABLE IF EXISTS `txin_detail`;
389/*!50001 DROP VIEW IF EXISTS `txin_detail`*/;
390SET @saved_cs_client = @@character_set_client;
391SET character_set_client = utf8;
392/*!50001 CREATE VIEW `txin_detail` AS SELECT
393 1 AS `chain_id`,
394 1 AS `in_longest`,
395 1 AS `block_id`,
396 1 AS `block_hash`,
397 1 AS `block_height`,
398 1 AS `tx_pos`,
399 1 AS `tx_id`,
400 1 AS `tx_hash`,
401 1 AS `tx_lockTime`,
402 1 AS `tx_version`,
403 1 AS `tx_size`,
404 1 AS `txin_id`,
405 1 AS `txin_pos`,
406 1 AS `prevout_id`,
407 1 AS `txin_scriptSig`,
408 1 AS `txin_sequence`,
409 1 AS `txin_value`,
410 1 AS `txin_scriptPubKey`,
411 1 AS `pubkey_id`,
412 1 AS `pubkey_hash`,
413 1 AS `pubkey`*/;
414SET character_set_client = @saved_cs_client;
415
416--
417-- Table structure for table `txin_seq`
418--
419
420DROP TABLE IF EXISTS `txin_seq`;
421/*!40101 SET @saved_cs_client = @@character_set_client */;
422/*!40101 SET character_set_client = utf8 */;
423CREATE TABLE `txin_seq` (
424 `id` bigint(20) NOT NULL AUTO_INCREMENT,
425 PRIMARY KEY (`id`)
426) ENGINE=InnoDB AUTO_INCREMENT=11048668 DEFAULT CHARSET=latin1;
427/*!40101 SET character_set_client = @saved_cs_client */;
428
429--
430-- Table structure for table `txout`
431--
432
433DROP TABLE IF EXISTS `txout`;
434/*!40101 SET @saved_cs_client = @@character_set_client */;
435/*!40101 SET character_set_client = utf8 */;
436CREATE TABLE `txout` (
437 `txout_id` decimal(26,0) NOT NULL,
438 `tx_id` decimal(26,0) NOT NULL,
439 `txout_pos` decimal(10,0) NOT NULL,
440 `txout_value` decimal(30,0) NOT NULL,
441 `txout_scriptPubKey` blob,
442 `pubkey_id` decimal(26,0) DEFAULT NULL,
443 PRIMARY KEY (`txout_id`),
444 UNIQUE KEY `tx_id` (`tx_id`,`txout_pos`),
445 KEY `x_txout_pubkey` (`pubkey_id`),
446 CONSTRAINT `txout_ibfk_1` FOREIGN KEY (`pubkey_id`) REFERENCES `pubkey` (`pubkey_id`)
447) ENGINE=InnoDB DEFAULT CHARSET=latin1;
448/*!40101 SET character_set_client = @saved_cs_client */;
449
450--
451-- Temporary view structure for view `txout_approx`
452--
453
454DROP TABLE IF EXISTS `txout_approx`;
455/*!50001 DROP VIEW IF EXISTS `txout_approx`*/;
456SET @saved_cs_client = @@character_set_client;
457SET character_set_client = utf8;
458/*!50001 CREATE VIEW `txout_approx` AS SELECT
459 1 AS `txout_id`,
460 1 AS `tx_id`,
461 1 AS `txout_approx_value`*/;
462SET character_set_client = @saved_cs_client;
463
464--
465-- Temporary view structure for view `txout_detail`
466--
467
468DROP TABLE IF EXISTS `txout_detail`;
469/*!50001 DROP VIEW IF EXISTS `txout_detail`*/;
470SET @saved_cs_client = @@character_set_client;
471SET character_set_client = utf8;
472/*!50001 CREATE VIEW `txout_detail` AS SELECT
473 1 AS `chain_id`,
474 1 AS `in_longest`,
475 1 AS `block_id`,
476 1 AS `block_hash`,
477 1 AS `block_height`,
478 1 AS `tx_pos`,
479 1 AS `tx_id`,
480 1 AS `tx_hash`,
481 1 AS `tx_lockTime`,
482 1 AS `tx_version`,
483 1 AS `tx_size`,
484 1 AS `txout_id`,
485 1 AS `txout_pos`,
486 1 AS `txout_value`,
487 1 AS `txout_scriptPubKey`,
488 1 AS `pubkey_id`,
489 1 AS `pubkey_hash`,
490 1 AS `pubkey`*/;
491SET character_set_client = @saved_cs_client;
492
493--
494-- Table structure for table `txout_seq`
495--
496
497DROP TABLE IF EXISTS `txout_seq`;
498/*!40101 SET @saved_cs_client = @@character_set_client */;
499/*!40101 SET character_set_client = utf8 */;
500CREATE TABLE `txout_seq` (
501 `id` bigint(20) NOT NULL AUTO_INCREMENT,
502 PRIMARY KEY (`id`)
503) ENGINE=InnoDB AUTO_INCREMENT=12775840 DEFAULT CHARSET=latin1;
504/*!40101 SET character_set_client = @saved_cs_client */;
505
506--
507-- Table structure for table `unlinked_tx`
508--
509
510DROP TABLE IF EXISTS `unlinked_tx`;
511/*!40101 SET @saved_cs_client = @@character_set_client */;
512/*!40101 SET character_set_client = utf8 */;
513CREATE TABLE `unlinked_tx` (
514 `tx_id` decimal(26,0) NOT NULL,
515 PRIMARY KEY (`tx_id`),
516 CONSTRAINT `unlinked_tx_ibfk_1` FOREIGN KEY (`tx_id`) REFERENCES `tx` (`tx_id`)
517) ENGINE=InnoDB DEFAULT CHARSET=latin1;
518/*!40101 SET character_set_client = @saved_cs_client */;
519
520--
521-- Table structure for table `unlinked_txin`
522--
523
524DROP TABLE IF EXISTS `unlinked_txin`;
525/*!40101 SET @saved_cs_client = @@character_set_client */;
526/*!40101 SET character_set_client = utf8 */;
527CREATE TABLE `unlinked_txin` (
528 `txin_id` decimal(26,0) NOT NULL,
529 `txout_tx_hash` binary(32) NOT NULL,
530 `txout_pos` decimal(10,0) NOT NULL,
531 PRIMARY KEY (`txin_id`),
532 KEY `x_unlinked_txin_outpoint` (`txout_tx_hash`,`txout_pos`),
533 CONSTRAINT `unlinked_txin_ibfk_1` FOREIGN KEY (`txin_id`) REFERENCES `txin` (`txin_id`)
534) ENGINE=InnoDB DEFAULT CHARSET=latin1;
535/*!40101 SET character_set_client = @saved_cs_client */;
536
537--
538-- Final view structure for view `chain_summary`
539--
540
541/*!50001 DROP VIEW IF EXISTS `chain_summary`*/;
542/*!50001 SET @saved_cs_client = @@character_set_client */;
543/*!50001 SET @saved_cs_results = @@character_set_results */;
544/*!50001 SET @saved_col_connection = @@collation_connection */;
545/*!50001 SET character_set_client = utf8 */;
546/*!50001 SET character_set_results = utf8 */;
547/*!50001 SET collation_connection = utf8_general_ci */;
548/*!50001 CREATE ALGORITHM=UNDEFINED */
549/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
550/*!50001 VIEW `chain_summary` AS select `cc`.`chain_id` AS `chain_id`,`cc`.`in_longest` AS `in_longest`,`b`.`block_id` AS `block_id`,`b`.`block_hash` AS `block_hash`,`b`.`block_version` AS `block_version`,`b`.`block_hashMerkleRoot` AS `block_hashMerkleRoot`,`b`.`block_nTime` AS `block_nTime`,`b`.`block_nBits` AS `block_nBits`,`b`.`block_nNonce` AS `block_nNonce`,`cc`.`block_height` AS `block_height`,`b`.`prev_block_id` AS `prev_block_id`,`prev`.`block_hash` AS `prev_block_hash`,`b`.`block_chain_work` AS `block_chain_work`,`b`.`block_num_tx` AS `block_num_tx`,`b`.`block_value_in` AS `block_value_in`,`b`.`block_value_out` AS `block_value_out`,`b`.`block_total_satoshis` AS `block_total_satoshis`,`b`.`block_total_seconds` AS `block_total_seconds`,`b`.`block_satoshi_seconds` AS `block_satoshi_seconds`,`b`.`block_total_ss` AS `block_total_ss`,`b`.`block_ss_destroyed` AS `block_ss_destroyed` from ((`chain_candidate` `cc` join `block` `b` on((`cc`.`block_id` = `b`.`block_id`))) left join `block` `prev` on((`b`.`prev_block_id` = `prev`.`block_id`))) */;
551/*!50001 SET character_set_client = @saved_cs_client */;
552/*!50001 SET character_set_results = @saved_cs_results */;
553/*!50001 SET collation_connection = @saved_col_connection */;
554
555--
556-- Final view structure for view `txin_detail`
557--
558
559/*!50001 DROP VIEW IF EXISTS `txin_detail`*/;
560/*!50001 SET @saved_cs_client = @@character_set_client */;
561/*!50001 SET @saved_cs_results = @@character_set_results */;
562/*!50001 SET @saved_col_connection = @@collation_connection */;
563/*!50001 SET character_set_client = utf8 */;
564/*!50001 SET character_set_results = utf8 */;
565/*!50001 SET collation_connection = utf8_general_ci */;
566/*!50001 CREATE ALGORITHM=UNDEFINED */
567/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
568/*!50001 VIEW `txin_detail` AS select `cc`.`chain_id` AS `chain_id`,`cc`.`in_longest` AS `in_longest`,`cc`.`block_id` AS `block_id`,`b`.`block_hash` AS `block_hash`,`b`.`block_height` AS `block_height`,`block_tx`.`tx_pos` AS `tx_pos`,`tx`.`tx_id` AS `tx_id`,`tx`.`tx_hash` AS `tx_hash`,`tx`.`tx_lockTime` AS `tx_lockTime`,`tx`.`tx_version` AS `tx_version`,`tx`.`tx_size` AS `tx_size`,`txin`.`txin_id` AS `txin_id`,`txin`.`txin_pos` AS `txin_pos`,`txin`.`txout_id` AS `prevout_id`,`txin`.`txin_scriptSig` AS `txin_scriptSig`,`txin`.`txin_sequence` AS `txin_sequence`,`prevout`.`txout_value` AS `txin_value`,`prevout`.`txout_scriptPubKey` AS `txin_scriptPubKey`,`pubkey`.`pubkey_id` AS `pubkey_id`,`pubkey`.`pubkey_hash` AS `pubkey_hash`,`pubkey`.`pubkey` AS `pubkey` from ((((((`chain_candidate` `cc` join `block` `b` on((`cc`.`block_id` = `b`.`block_id`))) join `block_tx` on((`b`.`block_id` = `block_tx`.`block_id`))) join `tx` on((`tx`.`tx_id` = `block_tx`.`tx_id`))) join `txin` on((`tx`.`tx_id` = `txin`.`tx_id`))) left join `txout` `prevout` on((`txin`.`txout_id` = `prevout`.`txout_id`))) left join `pubkey` on((`prevout`.`pubkey_id` = `pubkey`.`pubkey_id`))) */;
569/*!50001 SET character_set_client = @saved_cs_client */;
570/*!50001 SET character_set_results = @saved_cs_results */;
571/*!50001 SET collation_connection = @saved_col_connection */;
572
573--
574-- Final view structure for view `txout_approx`
575--
576
577/*!50001 DROP VIEW IF EXISTS `txout_approx`*/;
578/*!50001 SET @saved_cs_client = @@character_set_client */;
579/*!50001 SET @saved_cs_results = @@character_set_results */;
580/*!50001 SET @saved_col_connection = @@collation_connection */;
581/*!50001 SET character_set_client = utf8 */;
582/*!50001 SET character_set_results = utf8 */;
583/*!50001 SET collation_connection = utf8_general_ci */;
584/*!50001 CREATE ALGORITHM=UNDEFINED */
585/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
586/*!50001 VIEW `txout_approx` AS select `txout`.`txout_id` AS `txout_id`,`txout`.`tx_id` AS `tx_id`,`txout`.`txout_value` AS `txout_approx_value` from `txout` */;
587/*!50001 SET character_set_client = @saved_cs_client */;
588/*!50001 SET character_set_results = @saved_cs_results */;
589/*!50001 SET collation_connection = @saved_col_connection */;
590
591--
592-- Final view structure for view `txout_detail`
593--
594
595/*!50001 DROP VIEW IF EXISTS `txout_detail`*/;
596/*!50001 SET @saved_cs_client = @@character_set_client */;
597/*!50001 SET @saved_cs_results = @@character_set_results */;
598/*!50001 SET @saved_col_connection = @@collation_connection */;
599/*!50001 SET character_set_client = utf8 */;
600/*!50001 SET character_set_results = utf8 */;
601/*!50001 SET collation_connection = utf8_general_ci */;
602/*!50001 CREATE ALGORITHM=UNDEFINED */
603/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
604/*!50001 VIEW `txout_detail` AS select `cc`.`chain_id` AS `chain_id`,`cc`.`in_longest` AS `in_longest`,`cc`.`block_id` AS `block_id`,`b`.`block_hash` AS `block_hash`,`b`.`block_height` AS `block_height`,`block_tx`.`tx_pos` AS `tx_pos`,`tx`.`tx_id` AS `tx_id`,`tx`.`tx_hash` AS `tx_hash`,`tx`.`tx_lockTime` AS `tx_lockTime`,`tx`.`tx_version` AS `tx_version`,`tx`.`tx_size` AS `tx_size`,`txout`.`txout_id` AS `txout_id`,`txout`.`txout_pos` AS `txout_pos`,`txout`.`txout_value` AS `txout_value`,`txout`.`txout_scriptPubKey` AS `txout_scriptPubKey`,`pubkey`.`pubkey_id` AS `pubkey_id`,`pubkey`.`pubkey_hash` AS `pubkey_hash`,`pubkey`.`pubkey` AS `pubkey` from (((((`chain_candidate` `cc` join `block` `b` on((`cc`.`block_id` = `b`.`block_id`))) join `block_tx` on((`b`.`block_id` = `block_tx`.`block_id`))) join `tx` on((`tx`.`tx_id` = `block_tx`.`tx_id`))) join `txout` on((`tx`.`tx_id` = `txout`.`tx_id`))) left join `pubkey` on((`txout`.`pubkey_id` = `pubkey`.`pubkey_id`))) */;
605/*!50001 SET character_set_client = @saved_cs_client */;
606/*!50001 SET character_set_results = @saved_cs_results */;
607/*!50001 SET collation_connection = @saved_col_connection */;
608/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
609
610/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
611/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
612/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
613/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
614/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
615/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
616/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
617
618-- Dump completed on 2016-10-21 11:31:36