-- MySQL dump 10.13  Distrib 5.1.44-ndb-7.1.3, for unknown-linux-gnu (x86_64)
--
-- Host: localhost    Database: test
-- ------------------------------------------------------
-- Server version	5.1.44-ndb-7.1.3-cluster-com

/*!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 */;

--
-- Current Database: `test`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `test` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `test`;

--
-- Table structure for table `t1`
--

DROP TABLE IF EXISTS `t1`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=ndbcluster AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Current Database: `ndbinfo`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `ndbinfo` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `ndbinfo`;

--
-- 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` (
  `block_number` int(10) unsigned DEFAULT NULL,
  `block_name` varchar(512) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `config_params`
--

DROP TABLE IF EXISTS `config_params`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `config_params` (
  `param_number` int(10) unsigned DEFAULT NULL,
  `param_name` varchar(512) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Temporary table structure for view `counters`
--

DROP TABLE IF EXISTS `counters`;
/*!50001 DROP VIEW IF EXISTS `counters`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `counters` (
  `node_id` int(10) unsigned,
  `block_name` varchar(512),
  `block_instance` int(10) unsigned,
  `counter_id` int(10) unsigned,
  `counter_name` varchar(12),
  `val` bigint(20) unsigned
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `logbuffers`
--

DROP TABLE IF EXISTS `logbuffers`;
/*!50001 DROP VIEW IF EXISTS `logbuffers`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `logbuffers` (
  `node_id` int(10) unsigned,
  `log_type` varchar(9),
  `log_id` int(10) unsigned,
  `log_part` int(10) unsigned,
  `total` bigint(20) unsigned,
  `used` bigint(20) unsigned
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `logspaces`
--

DROP TABLE IF EXISTS `logspaces`;
/*!50001 DROP VIEW IF EXISTS `logspaces`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `logspaces` (
  `node_id` int(10) unsigned,
  `log_type` varchar(7),
  `log_id` int(10) unsigned,
  `log_part` int(10) unsigned,
  `total` bigint(20) unsigned,
  `used` bigint(20) unsigned
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `memoryusage`
--

DROP TABLE IF EXISTS `memoryusage`;
/*!50001 DROP VIEW IF EXISTS `memoryusage`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `memoryusage` (
  `node_id` int(10) unsigned,
  `memory_type` varchar(512),
  `used` decimal(62,0),
  `used_pages` decimal(42,0),
  `total` decimal(62,0),
  `total_pages` decimal(42,0)
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `nodes`
--

DROP TABLE IF EXISTS `nodes`;
/*!50001 DROP VIEW IF EXISTS `nodes`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `nodes` (
  `node_id` int(10) unsigned,
  `uptime` bigint(20) unsigned,
  `status` varchar(10),
  `start_phase` int(10) unsigned
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `pools`
--

DROP TABLE IF EXISTS `pools`;
/*!50001 DROP VIEW IF EXISTS `pools`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `pools` (
  `node_id` int(10) unsigned,
  `block_name` varchar(512),
  `block_instance` int(10) unsigned,
  `pool_name` varchar(512),
  `used` bigint(20) unsigned,
  `total` bigint(20) unsigned,
  `high` bigint(20) unsigned,
  `entry_size` bigint(20) unsigned,
  `param_name1` varchar(512),
  `param_name2` varchar(512),
  `param_name3` varchar(512),
  `param_name4` varchar(512)
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `resources`
--

DROP TABLE IF EXISTS `resources`;
/*!50001 DROP VIEW IF EXISTS `resources`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `resources` (
  `node_id` int(10) unsigned,
  `resource_name` varchar(19),
  `reserved` int(10) unsigned,
  `used` int(10) unsigned,
  `max` int(10) unsigned
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `transporters`
--

DROP TABLE IF EXISTS `transporters`;
/*!50001 DROP VIEW IF EXISTS `transporters`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `transporters` (
  `node_id` int(10) unsigned,
  `remote_node_id` int(10) unsigned,
  `status` varchar(13)
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;

--
-- Current Database: `test`
--

USE `test`;

--
-- Current Database: `ndbinfo`
--

USE `ndbinfo`;

--
-- Final view structure for view `counters`
--

/*!50001 DROP TABLE IF EXISTS `counters`*/;
/*!50001 DROP VIEW IF EXISTS `counters`*/;
/*!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      = latin1 */;
/*!50001 SET character_set_results     = latin1 */;
/*!50001 SET collation_connection      = latin1_swedish_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY INVOKER */
/*!50001 VIEW `counters` AS select `c`.`node_id` AS `node_id`,`b`.`block_name` AS `block_name`,`c`.`block_instance` AS `block_instance`,`c`.`counter_id` AS `counter_id`,(case `c`.`counter_id` when 1 then 'ATTRINFO' when 2 then 'TRANSACTIONS' when 3 then 'COMMITS' when 4 then 'READS' when 5 then 'SIMPLE_READS' when 6 then 'WRITES' when 7 then 'ABORTS' when 8 then 'TABLE_SCANS' when 9 then 'RANGE_SCANS' when 10 then 'OPERATIONS' else '<unknown>' end) AS `counter_name`,`c`.`val` AS `val` from (`ndb$counters` `c` join `blocks` `b`) where (`c`.`block_number` = `b`.`block_number`) */;
/*!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 `logbuffers`
--

/*!50001 DROP TABLE IF EXISTS `logbuffers`*/;
/*!50001 DROP VIEW IF EXISTS `logbuffers`*/;
/*!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      = latin1 */;
/*!50001 SET character_set_results     = latin1 */;
/*!50001 SET collation_connection      = latin1_swedish_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY INVOKER */
/*!50001 VIEW `logbuffers` AS select `ndb$logbuffers`.`node_id` AS `node_id`,(case `ndb$logbuffers`.`log_type` when 0 then 'REDO' when 1 then 'DD-UNDO' else '<unknown>' end) AS `log_type`,`ndb$logbuffers`.`log_id` AS `log_id`,`ndb$logbuffers`.`log_part` AS `log_part`,`ndb$logbuffers`.`total` AS `total`,`ndb$logbuffers`.`used` AS `used` from `ndb$logbuffers` */;
/*!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 `logspaces`
--

/*!50001 DROP TABLE IF EXISTS `logspaces`*/;
/*!50001 DROP VIEW IF EXISTS `logspaces`*/;
/*!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      = latin1 */;
/*!50001 SET character_set_results     = latin1 */;
/*!50001 SET collation_connection      = latin1_swedish_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY INVOKER */
/*!50001 VIEW `logspaces` AS select `ndb$logspaces`.`node_id` AS `node_id`,(case `ndb$logspaces`.`log_type` when 0 then 'REDO' when 1 then 'DD-UNDO' else NULL end) AS `log_type`,`ndb$logspaces`.`log_id` AS `log_id`,`ndb$logspaces`.`log_part` AS `log_part`,`ndb$logspaces`.`total` AS `total`,`ndb$logspaces`.`used` AS `used` from `ndb$logspaces` */;
/*!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 `memoryusage`
--

/*!50001 DROP TABLE IF EXISTS `memoryusage`*/;
/*!50001 DROP VIEW IF EXISTS `memoryusage`*/;
/*!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      = latin1 */;
/*!50001 SET character_set_results     = latin1 */;
/*!50001 SET collation_connection      = latin1_swedish_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY INVOKER */
/*!50001 VIEW `memoryusage` AS select `ndb$pools`.`node_id` AS `node_id`,`ndb$pools`.`pool_name` AS `memory_type`,sum((`ndb$pools`.`used` * `ndb$pools`.`entry_size`)) AS `used`,sum(`ndb$pools`.`used`) AS `used_pages`,sum((`ndb$pools`.`total` * `ndb$pools`.`entry_size`)) AS `total`,sum(`ndb$pools`.`total`) AS `total_pages` from `ndb$pools` where ((`ndb$pools`.`block_number` in (248,254)) and ((`ndb$pools`.`pool_name` = 'Index memory') or (`ndb$pools`.`pool_name` = 'Data memory'))) group by `ndb$pools`.`node_id`,`ndb$pools`.`pool_name` */;
/*!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 `nodes`
--

/*!50001 DROP TABLE IF EXISTS `nodes`*/;
/*!50001 DROP VIEW IF EXISTS `nodes`*/;
/*!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      = latin1 */;
/*!50001 SET character_set_results     = latin1 */;
/*!50001 SET collation_connection      = latin1_swedish_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY INVOKER */
/*!50001 VIEW `nodes` AS select `ndb$nodes`.`node_id` AS `node_id`,`ndb$nodes`.`uptime` AS `uptime`,(case `ndb$nodes`.`status` when 0 then 'NOTHING' when 1 then 'CMVMI' when 2 then 'STARTING' when 3 then 'STARTED' when 4 then 'SINGLEUSER' when 5 then 'STOPPING_1' when 6 then 'STOPPING_2' when 7 then 'STOPPING_3' when 8 then 'STOPPING_4' else '<unknown>' end) AS `status`,`ndb$nodes`.`start_phase` AS `start_phase` from `ndb$nodes` */;
/*!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 `pools`
--

/*!50001 DROP TABLE IF EXISTS `pools`*/;
/*!50001 DROP VIEW IF EXISTS `pools`*/;
/*!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      = latin1 */;
/*!50001 SET character_set_results     = latin1 */;
/*!50001 SET collation_connection      = latin1_swedish_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY INVOKER */
/*!50001 VIEW `pools` AS select `p`.`node_id` AS `node_id`,`b`.`block_name` AS `block_name`,`p`.`block_instance` AS `block_instance`,`p`.`pool_name` AS `pool_name`,`p`.`used` AS `used`,`p`.`total` AS `total`,`p`.`high` AS `high`,`p`.`entry_size` AS `entry_size`,`cp1`.`param_name` AS `param_name1`,`cp2`.`param_name` AS `param_name2`,`cp3`.`param_name` AS `param_name3`,`cp4`.`param_name` AS `param_name4` from (((((`ndb$pools` `p` join `blocks` `b` on((`p`.`block_number` = `b`.`block_number`))) left join `config_params` `cp1` on((`p`.`config_param1` = `cp1`.`param_number`))) left join `config_params` `cp2` on((`p`.`config_param2` = `cp2`.`param_number`))) left join `config_params` `cp3` on((`p`.`config_param3` = `cp3`.`param_number`))) left join `config_params` `cp4` on((`p`.`config_param4` = `cp4`.`param_number`))) */;
/*!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 `resources`
--

/*!50001 DROP TABLE IF EXISTS `resources`*/;
/*!50001 DROP VIEW IF EXISTS `resources`*/;
/*!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      = latin1 */;
/*!50001 SET character_set_results     = latin1 */;
/*!50001 SET collation_connection      = latin1_swedish_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY INVOKER */
/*!50001 VIEW `resources` AS select `ndb$resources`.`node_id` AS `node_id`,(case `ndb$resources`.`resource_id` when 0 then 'RESERVED' when 1 then 'DISK_OPERATIONS' when 2 then 'DISK_RECORDS' when 3 then 'DATA_MEMORY' when 4 then 'JOBBUFFER' when 5 then 'FILE_BUFFERS' when 6 then 'TRANSPORTER_BUFFERS' else '<unknown>' end) AS `resource_name`,`ndb$resources`.`reserved` AS `reserved`,`ndb$resources`.`used` AS `used`,`ndb$resources`.`max` AS `max` from `ndb$resources` */;
/*!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 `transporters`
--

/*!50001 DROP TABLE IF EXISTS `transporters`*/;
/*!50001 DROP VIEW IF EXISTS `transporters`*/;
/*!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      = latin1 */;
/*!50001 SET character_set_results     = latin1 */;
/*!50001 SET collation_connection      = latin1_swedish_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY INVOKER */
/*!50001 VIEW `transporters` AS select `ndb$transporters`.`node_id` AS `node_id`,`ndb$transporters`.`remote_node_id` AS `remote_node_id`,(case `ndb$transporters`.`connection_status` when 0 then 'CONNECTED' when 1 then 'CONNECTING' when 2 then 'DISCONNECTED' when 3 then 'DISCONNECTING' else NULL end) AS `status` from `ndb$transporters` */;
/*!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 2010-06-05 11:25:36