Skip to content

Mysqldump php output

Jump to bottom Edit New page
Diego Torres edited this page Jan 24, 2015 · 1 revision 
-- mysqldump-php https://github.com/ifsnop/mysqldump-php
--
-- Host: localhost	Database: test001
-- ------------------------------------------------------
-- Server version 	5.5.31-0+wheezy1-log
-- Date: Thu, 02 Oct 2014 22:14:11 +0000

/*!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 `test000`
--

DROP TABLE IF EXISTS `test000`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `test000` (
  `id` int(11) DEFAULT NULL,
  `col01` bit(6) DEFAULT NULL,
  `col02` tinyint(4) DEFAULT NULL,
  `col03` tinyint(4) unsigned DEFAULT NULL,
  `col10` bigint(20) DEFAULT NULL,
  `col11` bigint(20) unsigned DEFAULT NULL,
  `col15` double DEFAULT NULL,
  `col27` varchar(6) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `test000`
--

LOCK TABLES `test000` WRITE;
/*!40000 ALTER TABLE `test000` DISABLE KEYS */;
SET autocommit=0;
INSERT INTO `test000` VALUES (1,0x21,-128,255,-9223372036854775808,18446744073709551615,-2.2250738585072014e-308,'0abcde');
/*!40000 ALTER TABLE `test000` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;

--
-- Table structure for table `test001`
--

DROP TABLE IF EXISTS `test001`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `test001` (
  `id` int(11) DEFAULT NULL,
  `col` bit(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `test001`
--

LOCK TABLES `test001` WRITE;
/*!40000 ALTER TABLE `test001` DISABLE KEYS */;
SET autocommit=0;
INSERT INTO `test001` VALUES (1,NULL);
INSERT INTO `test001` VALUES (2,0x00);
INSERT INTO `test001` VALUES (3,0x01);
/*!40000 ALTER TABLE `test001` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;

--
-- Table structure for table `test002`
--

DROP TABLE IF EXISTS `test002`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `test002` (
  `id` int(11) DEFAULT NULL,
  `col` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `test002`
--

LOCK TABLES `test002` WRITE;
/*!40000 ALTER TABLE `test002` DISABLE KEYS */;
SET autocommit=0;
INSERT INTO `test002` VALUES (1,NULL);
INSERT INTO `test002` VALUES (2,-128);
INSERT INTO `test002` VALUES (3,0);
INSERT INTO `test002` VALUES (4,127);
/*!40000 ALTER TABLE `test002` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;

--
-- Table structure for table `test003`
--

DROP TABLE IF EXISTS `test003`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `test003` (
  `id` int(11) DEFAULT NULL,
  `col` tinyint(4) unsigned DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `test003`
--

LOCK TABLES `test003` WRITE;
/*!40000 ALTER TABLE `test003` DISABLE KEYS */;
SET autocommit=0;
INSERT INTO `test003` VALUES (1,NULL);
INSERT INTO `test003` VALUES (2,0);
INSERT INTO `test003` VALUES (3,255);
/*!40000 ALTER TABLE `test003` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;

--
-- Table structure for table `test010`
--

DROP TABLE IF EXISTS `test010`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `test010` (
  `id` int(11) DEFAULT NULL,
  `col` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `test010`
--

LOCK TABLES `test010` WRITE;
/*!40000 ALTER TABLE `test010` DISABLE KEYS */;
SET autocommit=0;
INSERT INTO `test010` VALUES (1,NULL);
INSERT INTO `test010` VALUES (2,-9223372036854775808);
INSERT INTO `test010` VALUES (3,0);
INSERT INTO `test010` VALUES (4,9223372036854775807);
/*!40000 ALTER TABLE `test010` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;

--
-- Table structure for table `test011`
--

DROP TABLE IF EXISTS `test011`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `test011` (
  `id` int(11) DEFAULT NULL,
  `col` bigint(20) unsigned DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `test011`
--

LOCK TABLES `test011` WRITE;
/*!40000 ALTER TABLE `test011` DISABLE KEYS */;
SET autocommit=0;
INSERT INTO `test011` VALUES (1,NULL);
INSERT INTO `test011` VALUES (3,0);
INSERT INTO `test011` VALUES (4,18446744073709551615);
/*!40000 ALTER TABLE `test011` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;

--
-- Table structure for table `test015`
--

DROP TABLE IF EXISTS `test015`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `test015` (
  `id` int(11) DEFAULT NULL,
  `col` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `test015`
--

LOCK TABLES `test015` WRITE;
/*!40000 ALTER TABLE `test015` DISABLE KEYS */;
SET autocommit=0;
INSERT INTO `test015` VALUES (1,NULL);
INSERT INTO `test015` VALUES (2,-1.7976931348623157e308);
INSERT INTO `test015` VALUES (3,-2.2250738585072014e-308);
INSERT INTO `test015` VALUES (4,0);
INSERT INTO `test015` VALUES (5,2.2250738585072014e-308);
INSERT INTO `test015` VALUES (6,1.7976931348623157e308);
/*!40000 ALTER TABLE `test015` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;

--
-- Table structure for table `test027`
--

DROP TABLE IF EXISTS `test027`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `test027` (
  `id` int(11) DEFAULT NULL,
  `col` varchar(6) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `test027`
--

LOCK TABLES `test027` WRITE;
/*!40000 ALTER TABLE `test027` DISABLE KEYS */;
SET autocommit=0;
INSERT INTO `test027` VALUES (1,NULL);
INSERT INTO `test027` VALUES (2,'');
INSERT INTO `test027` VALUES (3,'0');
INSERT INTO `test027` VALUES (4,'2e308');
INSERT INTO `test027` VALUES (5,'999.99');
INSERT INTO `test027` VALUES (6,'-2e-30');
INSERT INTO `test027` VALUES (7,'-99.99');
INSERT INTO `test027` VALUES (8,'0');
INSERT INTO `test027` VALUES (9,'0abcde');
INSERT INTO `test027` VALUES (10,'123');
/*!40000 ALTER TABLE `test027` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;

--
-- Table structure for table `test029`
--

DROP TABLE IF EXISTS `test029`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `test029` (
  `id` int(11) DEFAULT NULL,
  `col` blob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `test029`
--

LOCK TABLES `test029` WRITE;
/*!40000 ALTER TABLE `test029` DISABLE KEYS */;
SET autocommit=0;
INSERT INTO `test029` VALUES (1,0x00010203040506070809909192939495969798A9);
INSERT INTO `test029` VALUES (2,'');
/*!40000 ALTER TABLE `test029` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;

--
-- Table structure for table `test033`
--

DROP TABLE IF EXISTS `test033`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `test033` (
  `id` int(11) DEFAULT NULL,
  `col` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `test033`
--

LOCK TABLES `test033` WRITE;
/*!40000 ALTER TABLE `test033` DISABLE KEYS */;
SET autocommit=0;
INSERT INTO `test033` VALUES (1,'test test test');
/*!40000 ALTER TABLE `test033` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;

--
-- Table structure for table `test200`
--

DROP TABLE IF EXISTS `test200`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `test200` (
  `id` int(11) DEFAULT NULL,
  `col` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `test200`
--

LOCK TABLES `test200` WRITE;
/*!40000 ALTER TABLE `test200` DISABLE KEYS */;
SET autocommit=0;
/*!40000 ALTER TABLE `test200` ENABLE KEYS */;
UNLOCK TABLES;
COMMIT;

--
-- Table structure for view `test100`
--

DROP TABLE IF EXISTS `test100`;
/*!50001 DROP VIEW IF EXISTS `test100`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `test100` AS select `test000`.`id` AS `id`,`test000`.`col01` AS `col01`,`test000`.`col02` AS `col02`,`test000`.`col03` AS `col03`,`test000`.`col10` AS `col10`,`test000`.`col11` AS `col11`,`test000`.`col15` AS `col15`,`test000`.`col27` AS `col27` from `test000` */;

--
-- Table structure for view `test127`
--

DROP TABLE IF EXISTS `test127`;
/*!50001 DROP VIEW IF EXISTS `test127`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `test127` AS select `test027`.`id` AS `id`,`test027`.`col` AS `col` from `test027` */;

DROP TRIGGER IF EXISTS `before_test200_insert`;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER before_test200_insert
  BEFORE insert ON `test200`
  FOR EACH ROW set NEW.col = NEW.col + 1*/;;
DELIMITER ;

/*!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: Thu, 02 Oct 2014 22:14:11 +0000
Add a custom footer
Add a custom sidebar
Clone this wiki locally