github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/ccl/importccl/testdata/mysqldump/everything.sql (about)

     1  -- MySQL dump 10.13  Distrib 8.0.12, for osx10.14 (x86_64)
     2  --
     3  -- Host: localhost    Database: cockroachtestdata
     4  -- ------------------------------------------------------
     5  -- Server version	8.0.12
     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   SET NAMES utf8mb4 ;
    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 `everything`
    20  --
    21  
    22  DROP TABLE IF EXISTS `everything`;
    23  /*!40101 SET @saved_cs_client     = @@character_set_client */;
    24   SET character_set_client = utf8mb4 ;
    25  CREATE TABLE `everything` (
    26    `i` int(11) NOT NULL,
    27    `c` char(10) NOT NULL,
    28    `s` varchar(100) DEFAULT 'this is s''s default value',
    29    `tx` text,
    30    `e` enum('Small','Medium','Large') DEFAULT NULL,
    31    `bin` binary(100) NOT NULL,
    32    `vbin` varbinary(100) DEFAULT NULL,
    33    `bl` blob,
    34    `dt` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
    35    `d` date DEFAULT NULL,
    36    `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    37    `t` time DEFAULT NULL,
    38    `de` decimal(10,0) DEFAULT NULL,
    39    `nu` decimal(10,0) DEFAULT NULL,
    40    `d53` decimal(5,3) DEFAULT NULL,
    41    `iw` int(5) NOT NULL,
    42    `iz` int(10) unsigned zerofill DEFAULT NULL,
    43    `ti` tinyint(4) DEFAULT '5',
    44    `si` smallint(6) DEFAULT NULL,
    45    `mi` mediumint(9) DEFAULT NULL,
    46    `bi` bigint(20) DEFAULT NULL,
    47    `fl` float NOT NULL,
    48    `rl` double DEFAULT NULL,
    49    `db` double DEFAULT NULL,
    50    `f17` float DEFAULT NULL,
    51    `f47` double DEFAULT NULL,
    52    `f75` float(7,5) DEFAULT NULL,
    53    `j` json DEFAULT NULL,
    54    PRIMARY KEY (`i`)
    55  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    56  /*!40101 SET character_set_client = @saved_cs_client */;
    57  
    58  --
    59  -- Dumping data for table `everything`
    60  --
    61  
    62  LOCK TABLES `everything` WRITE;
    63  /*!40000 ALTER TABLE `everything` DISABLE KEYS */;
    64  INSERT INTO `everything` VALUES (1,'c','this is s\'s default value',NULL,'Small',_binary 'bin\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',NULL,NULL,'2000-01-01 00:00:00',NULL,'2018-11-19 20:27:42',NULL,NULL,NULL,-12.345,-2,0000000001,5,NULL,NULL,NULL,-1.5,NULL,NULL,NULL,NULL,NULL,'{\"a\": \"b\", \"c\": {\"d\": [\"e\", 11, null]}}'),(2,'c2','this is s\'s default value',NULL,'Large',_binary 'bin2\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',NULL,NULL,'2000-01-01 00:00:00',NULL,'2018-11-19 20:27:42',NULL,NULL,NULL,12.345,3,3525343334,5,NULL,NULL,NULL,1.2,NULL,NULL,NULL,NULL,NULL,'{}');
    65  /*!40000 ALTER TABLE `everything` ENABLE KEYS */;
    66  UNLOCK TABLES;
    67  /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
    68  
    69  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
    70  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
    71  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
    72  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
    73  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
    74  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
    75  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
    76  
    77  -- Dump completed on 2018-11-19 20:27:42