mysql burstdb schema v01

-- MySQL dump 10.13  Distrib 5.5.43, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: burstdb
-- ------------------------------------------------------
-- Server version	5.5.43-0ubuntu0.14.10.1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `blocks`
--

DROP TABLE IF EXISTS `blocks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `blocks` (
  `idblocks` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `height` bigint(20) NOT NULL,
  `scoop` int(11) NOT NULL,
  `target` varchar(45) NOT NULL,
  `reward` float NOT NULL,
  `miner` varchar(45) NOT NULL,
  `time` varchar(45) NOT NULL,
  `txids` int(11) NOT NULL,
  PRIMARY KEY (`idblocks`),
  UNIQUE KEY `height_UNIQUE` (`height`),
  KEY `reward` (`reward`),
  KEY `miner` (`miner`),
  KEY `height` (`height`),
  KEY `scoop` (`scoop`),
  KEY `target` (`target`),
  KEY `time` (`time`)
) ENGINE=InnoDB AUTO_INCREMENT=99691 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `dbstate`
--

DROP TABLE IF EXISTS `dbstate`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dbstate` (
  `iddbstate` int(10) unsigned NOT NULL,
  `last_block` bigint(20) NOT NULL,
  PRIMARY KEY (`iddbstate`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Temporary table structure for view `my_polo_deposits`
--

DROP TABLE IF EXISTS `my_polo_deposits`;
/*!50001 DROP VIEW IF EXISTS `my_polo_deposits`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `my_polo_deposits` (
  `recieved` tinyint NOT NULL
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `reward_richlist`
--

DROP TABLE IF EXISTS `reward_richlist`;
/*!50001 DROP VIEW IF EXISTS `reward_richlist`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `reward_richlist` (
  `miner` tinyint NOT NULL,
  `mined` tinyint NOT NULL,
  `mined_blocks` tinyint NOT NULL,
  `avg_reward` tinyint NOT NULL
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `tx`
--

DROP TABLE IF EXISTS `tx`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tx` (
  `idtx` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `transaction` varchar(45) DEFAULT NULL,
  `amountNQT` bigint(20) DEFAULT NULL,
  `height` bigint(20) DEFAULT NULL,
  `recipientRS` varchar(45) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `feeNQT` bigint(20) DEFAULT NULL,
  `recipient` bigint(20) DEFAULT NULL,
  `sender` bigint(20) DEFAULT NULL,
  `subtype` int(11) DEFAULT NULL,
  `deadline` bigint(20) DEFAULT NULL,
  `senderRS` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`idtx`),
  KEY `transaction` (`transaction`),
  KEY `amountNQT` (`amountNQT`),
  KEY `height` (`height`),
  KEY `recipientRS` (`recipientRS`),
  KEY `type` (`type`),
  KEY `feeNQT` (`feeNQT`),
  KEY `recipient` (`recipient`),
  KEY `sender` (`sender`),
  KEY `subtype` (`subtype`),
  KEY `deadline` (`deadline`),
  KEY `senderRS` (`senderRS`)
) ENGINE=InnoDB AUTO_INCREMENT=1928903 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;


--
-- Final view structure for view `my_polo_deposits`
--

/*!50001 DROP TABLE IF EXISTS `my_polo_deposits`*/;
/*!50001 DROP VIEW IF EXISTS `my_polo_deposits`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = utf8 */;
/*!50001 SET character_set_results     = utf8 */;
/*!50001 SET collation_connection      = utf8_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `my_polo_deposits` AS select `tx`.`recipientRS` AS `recieved` from `tx` where `tx`.`recipientRS` in (select `tx`.`recipientRS` from `tx` where (`tx`.`recipientRS` = 'BURST-R8SQ-TUEM-DTHQ-7ATA3')) */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;

--
-- Final view structure for view `reward_richlist`
--

/*!50001 DROP TABLE IF EXISTS `reward_richlist`*/;
/*!50001 DROP VIEW IF EXISTS `reward_richlist`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = utf8 */;
/*!50001 SET character_set_results     = utf8 */;
/*!50001 SET collation_connection      = utf8_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `reward_richlist` AS select `blocks`.`miner` AS `miner`,sum(`blocks`.`reward`) AS `mined`,count(`blocks`.`miner`) AS `mined_blocks`,(sum(`blocks`.`reward`) / count(`blocks`.`miner`)) AS `avg_reward` from `blocks` group by `blocks`.`miner` order by sum(`blocks`.`reward`) desc */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2015-05-17  2:03:45