github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/ccl/importccl/testdata/mysqldump/second.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 `SECOND`
    20  --
    21  
    22  DROP TABLE IF EXISTS `SECOND`;
    23  /*!40101 SET @saved_cs_client     = @@character_set_client */;
    24   SET character_set_client = utf8mb4 ;
    25  CREATE TABLE `SECOND` (
    26    `i` int(11) NOT NULL,
    27    `k` int(11) DEFAULT NULL,
    28    PRIMARY KEY (`i`),
    29    UNIQUE KEY `ik` (`i`,`k`),
    30    KEY `ki` (`k`,`i`),
    31    CONSTRAINT `second_ibfk_1` FOREIGN KEY (`k`) REFERENCES `simple` (`i`) ON UPDATE CASCADE
    32  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    33  /*!40101 SET character_set_client = @saved_cs_client */;
    34  
    35  --
    36  -- Dumping data for table `SECOND`
    37  --
    38  
    39  LOCK TABLES `SECOND` WRITE;
    40  /*!40000 ALTER TABLE `SECOND` DISABLE KEYS */;
    41  INSERT INTO `SECOND` VALUES (-7,7),(-6,6),(-5,5),(-4,4),(-3,3),(-2,2),(-1,1);
    42  /*!40000 ALTER TABLE `SECOND` ENABLE KEYS */;
    43  UNLOCK TABLES;
    44  /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
    45  
    46  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
    47  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
    48  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
    49  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
    50  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
    51  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
    52  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
    53  
    54  -- Dump completed on 2018-11-19 20:27:42