/** * Copyright © Magento, Inc. All rights reserved. * See COPYING.txt for license details. */ /*!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 `common_table` -- DROP TABLE IF EXISTS `common_table`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `common_table` ( `key` int(11) NOT NULL AUTO_INCREMENT, `dest_field_ignored` int(11) NOT NULL DEFAULT '0', `common_field` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `common_table` -- LOCK TABLES `common_table` WRITE; /*!40000 ALTER TABLE `common_table` DISABLE KEYS */; /*!40000 ALTER TABLE `common_table` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `common_table_extra_field` -- DROP TABLE IF EXISTS `common_table_extra_field`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `common_table_extra_field` ( `key` int(11) NOT NULL AUTO_INCREMENT, `common_field` int(11) DEFAULT NULL, PRIMARY KEY (`key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `common_table_extra_field` -- LOCK TABLES `common_table_extra_field` WRITE; /*!40000 ALTER TABLE `common_table_extra_field` DISABLE KEYS */; /*!40000 ALTER TABLE `common_table_extra_field` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `dest_table_ignored` -- DROP TABLE IF EXISTS `dest_table_ignored`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dest_table_ignored` ( `key` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `dest_table_ignored` -- LOCK TABLES `dest_table_ignored` WRITE; /*!40000 ALTER TABLE `dest_table_ignored` DISABLE KEYS */; /*!40000 ALTER TABLE `dest_table_ignored` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `dest_table_renamed` -- DROP TABLE IF EXISTS `dest_table_renamed`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dest_table_renamed` ( `key` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `dest_table_renamed` -- LOCK TABLES `dest_table_renamed` WRITE; /*!40000 ALTER TABLE `dest_table_renamed` DISABLE KEYS */; /*!40000 ALTER TABLE `dest_table_renamed` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `table_without_data` -- DROP TABLE IF EXISTS `table_without_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `table_without_data` ( `key` int(11) NOT NULL AUTO_INCREMENT, `field1` int(11) DEFAULT NULL, `field2` int(11) DEFAULT NULL, `field3` int(11) DEFAULT NULL, PRIMARY KEY (`key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `table_without_data` -- LOCK TABLES `table_without_data` WRITE; /*!40000 ALTER TABLE `table_without_data` DISABLE KEYS */; /*!40000 ALTER TABLE `table_without_data` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `table_ignored` -- DROP TABLE IF EXISTS `table_ignored`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `table_ignored` ( `field1` int(11) NOT NULL AUTO_INCREMENT, `field2` int(11) DEFAULT NULL, PRIMARY KEY (`field1`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `source_table_ignored` -- LOCK TABLES `table_ignored` WRITE; /*!40000 ALTER TABLE `table_ignored` DISABLE KEYS */; /*!40000 ALTER TABLE `table_ignored` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `dest_table_1` -- DROP TABLE IF EXISTS `dest_table_1`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dest_table_1` ( `key` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `dest_table_1` -- LOCK TABLES `dest_table_1` WRITE; /*!40000 ALTER TABLE `dest_table_1` DISABLE KEYS */; /*!40000 ALTER TABLE `dest_table_1` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `dest_table_2` -- DROP TABLE IF EXISTS `dest_table_2`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dest_table_2` ( `key` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `dest_table_2` -- LOCK TABLES `dest_table_2` WRITE; /*!40000 ALTER TABLE `dest_table_2` DISABLE KEYS */; /*!40000 ALTER TABLE `dest_table_2` ENABLE KEYS */; UNLOCK TABLES; -- Dumping structure for table magento2mainlinece.core_config_data DROP TABLE IF EXISTS `core_config_data`; CREATE TABLE IF NOT EXISTS `core_config_data` ( `config_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Config Id', `scope` varchar(8) NOT NULL DEFAULT 'default' COMMENT 'Config Scope', `scope_id` int(11) NOT NULL DEFAULT '0' COMMENT 'Config Scope Id', `path` varchar(255) NOT NULL DEFAULT 'general' COMMENT 'Config Path', `value` text COMMENT 'Config Value', PRIMARY KEY (`config_id`), UNIQUE KEY `UNQ_CORE_CONFIG_DATA_SCOPE_SCOPE_ID_PATH` (`scope`,`scope_id`,`path`) ) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8 COMMENT='Config Data'; LOCK TABLES `core_config_data` WRITE; -- Dumping data for table magento2mainlinece.core_config_data: ~58 rows (approximately) DELETE FROM `core_config_data`; /*!40000 ALTER TABLE `core_config_data` DISABLE KEYS */; INSERT INTO `core_config_data` (`config_id`, `scope`, `scope_id`, `path`, `value`) VALUES (1, 'default', 0, 'web/seo/use_rewrites', '0'), (2, 'default', 0, 'web/unsecure/base_url', 'http://magento2.dev/'), (3, 'default', 0, 'admin/security/session_lifetime', '60'), (4, 'default', 0, 'catalog/seo/product_url_suffix', '.html'); /*!40000 ALTER TABLE `core_config_data` ENABLE KEYS */; UNLOCK TABLES; /*!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 2015-01-29 19:44:27