-- MySQL dump 10.13 Distrib 5.7.26, for Linux (x86_64) -- -- Host: tbd-aur-mrr.cluster-crrjyawcklye.us-east-1.rds.amazonaws.com Database: test -- ------------------------------------------------------ -- Server version 5.7.12 /*!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 */; #SET @MYSQLDUMP_TEMP_LOG_BIN = @@SESSION.SQL_LOG_BIN; #SET @@SESSION.SQL_LOG_BIN= 0; -- -- GTID state at the beginning of the backup -- #SET @@GLOBAL.GTID_PURGED=''; -- -- 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, `calendar` date DEFAULT NULL, `num` int(11) DEFAULT NULL, `num_2` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_calendar` (`calendar`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `t1` -- LOCK TABLES `t1` WRITE; /*!40000 ALTER TABLE `t1` DISABLE KEYS */; INSERT INTO `t1` VALUES (1,'2021-08-20',18,118),(2,'2021-08-08',47,81),(3,'2021-08-23',99,66),(4,'2021-08-10',83,30),(5,'2021-08-25',161,129),(6,'2021-08-15',40,113),(7,'2021-08-19',169,81),(8,'2021-08-19',154,8),(9,'2021-08-12',105,108),(10,'2021-08-12',123,186),(11,'2021-08-28',15,148),(12,'2021-08-21',182,115),(13,'2021-08-01',130,48),(14,'2021-08-22',16,57),(15,'2021-08-01',131,43),(16,'2021-08-09',191,184),(17,'2021-08-27',150,38),(18,'2021-08-13',99,54),(19,'2021-08-23',2,182),(20,'2021-08-22',185,102),(21,'2021-08-07',82,82),(22,'2021-08-13',75,130),(23,'2021-08-14',101,40),(24,'2021-08-28',158,49),(25,'2021-08-23',171,23),(26,'2021-08-05',10,152),(27,'2021-08-25',31,83),(28,'2021-08-31',28,141),(29,'2021-08-17',151,40),(30,'2021-08-31',195,191),(31,'2021-08-20',47,54),(32,'2021-08-20',27,164),(33,'2021-08-05',164,121),(34,'2021-08-25',182,36),(35,'2021-08-10',104,131),(36,'2021-08-04',90,187),(37,'2021-08-05',115,90),(38,'2021-08-23',108,100),(39,'2021-08-17',103,193),(40,'2021-08-07',178,161),(41,'2021-08-17',86,110),(42,'2021-08-06',143,197),(43,'2021-08-25',127,166),(44,'2021-08-17',74,47),(45,'2021-08-20',172,73),(46,'2021-08-07',127,117),(47,'2021-08-04',32,92),(48,'2021-08-25',103,41),(49,'2021-08-07',110,28),(50,'2021-08-05',34,88),(51,'2021-08-02',146,97),(52,'2021-08-19',73,13),(53,'2021-08-26',119,92),(54,'2021-08-03',163,161),(55,'2021-08-08',108,198),(56,'2021-08-06',36,77),(57,'2021-08-14',93,3),(58,'2021-08-02',100,73),(59,'2021-08-13',42,175),(60,'2021-08-24',194,116),(61,'2021-08-05',187,42),(62,'2021-08-19',33,1),(63,'2021-08-13',38,143),(64,'2021-08-23',149,108),(65,'2021-08-13',20,54),(66,'2021-08-31',187,148),(67,'2021-08-08',40,55),(68,'2021-08-20',19,118),(69,'2021-08-04',105,53),(70,'2021-08-01',4,6),(71,'2021-08-10',80,16),(72,'2021-08-26',177,200),(73,'2021-08-01',182,97),(74,'2021-08-29',70,199),(75,'2021-08-30',113,186),(76,'2021-08-02',183,93),(77,'2021-08-29',65,169),(78,'2021-08-11',84,8),(79,'2021-08-15',199,110),(80,'2021-08-06',104,11),(81,'2021-08-15',188,54),(82,'2021-08-27',166,114),(83,'2021-08-23',44,176),(84,'2021-08-07',99,172),(85,'2021-08-04',20,21),(86,'2021-08-01',103,102),(87,'2021-08-02',137,47),(88,'2021-08-26',114,66),(89,'2021-08-10',178,102),(90,'2021-08-09',123,58),(91,'2021-08-16',152,61),(92,'2021-08-12',15,52),(93,'2021-08-21',103,118),(94,'2021-08-18',8,98),(95,'2021-08-23',163,176),(96,'2021-08-01',31,148),(97,'2021-08-18',193,20),(98,'2021-08-21',81,4),(99,'2021-08-25',190,79),(100,'2021-08-20',41,19); /*!40000 ALTER TABLE `t1` ENABLE KEYS */; UNLOCK TABLES; #SET @@SESSION.SQL_LOG_BIN = @MYSQLDUMP_TEMP_LOG_BIN; /*!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 2021-09-10 8:10:52