-- MySQL dump 10.13  Distrib 5.5.5-m3, for unknown-linux-gnu (x86_64)
--
-- Host: localhost    Database: test_nidhi
-- ------------------------------------------------------
-- Server version	5.5.5-m3

/*!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 */;

--
-- Current Database: `test_nidhi`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `test_nidhi` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `test_nidhi`;

--
-- Table structure for table `t4_initial`
--

DROP TABLE IF EXISTS `t4_initial`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t4_initial` (
  `subject` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `p` varchar(255) DEFAULT NULL,
  KEY `subject` (`subject`(250))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t4_initial`
--

LOCK TABLES `t4_initial` WRITE;
/*!40000 ALTER TABLE `t4_initial` DISABLE KEYS */;
INSERT INTO `t4_initial` VALUES ('è°·å·<9d>ä¿<8a>äº<8c>ã<81>¨ç<94>³ã<81><97>ã<81>¾ã<81><99>ã<81><8c>ã<80><81>ã<82>¤ã<83>³ã<82>¿ã<83>¼ã<83><8d>ã<83><833\n>ã<83><88>äº<88>ç´<84>ã<81>®ä¼<9a>å<93>¡ç<99>»é<8c>²ã<82><92>ã<81><97>ã<81>¾ã<81><97>ã<81><9f>ã<81>¨ã<81><93>ã<82><8d>ã<80><81>ã<83>¡ã<83','040312-000057'),('aaa','bbb'),('abc',NULL),('?',NULL),('abc?def',NULL);
/*!40000 ALTER TABLE `t4_initial` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t4_initial1`
--

DROP TABLE IF EXISTS `t4_initial1`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t4_initial1` (
  `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `p` varchar(255) DEFAULT NULL,
  KEY `subject` (`subject`(250))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t4_initial1`
--

LOCK TABLES `t4_initial1` WRITE;
/*!40000 ALTER TABLE `t4_initial1` DISABLE KEYS */;
INSERT INTO `t4_initial1` VALUES ('aaa','bbb'),('abc',NULL),('?',NULL),('abc?def',NULL);
/*!40000 ALTER TABLE `t4_initial1` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Temporary table structure for view `v1_initial`
--

DROP TABLE IF EXISTS `v1_initial`;
/*!50001 DROP VIEW IF EXISTS `v1_initial`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `v1_initial` (
  `subject` varchar(255),
  `p` varchar(255)
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `v2_initial`
--

DROP TABLE IF EXISTS `v2_initial`;
/*!50001 DROP VIEW IF EXISTS `v2_initial`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `v2_initial` (
  `subject` varchar(255),
  `p` varchar(255)
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;

--
-- Current Database: `test_nidhi`
--

USE `test_nidhi`;

--
-- Final view structure for view `v1_initial`
--

/*!50001 DROP TABLE IF EXISTS `v1_initial`*/;
/*!50001 DROP VIEW IF EXISTS `v1_initial`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = utf8 */;
/*!50001 SET character_set_results     = utf8 */;
/*!50001 SET collation_connection      = utf8_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v1_initial` AS select `t4_initial`.`subject` AS `subject`,`t4_initial`.`p` AS `p` from `t4_initial` where (`t4_initial`.`subject` like 'aaa') */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;

--
-- Final view structure for view `v2_initial`
--

/*!50001 DROP TABLE IF EXISTS `v2_initial`*/;
/*!50001 DROP VIEW IF EXISTS `v2_initial`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = utf8 */;
/*!50001 SET character_set_results     = utf8 */;
/*!50001 SET collation_connection      = utf8_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v2_initial` AS select `t4_initial`.`subject` AS `subject`,`t4_initial`.`p` AS `p` from `t4_initial` where (convert(`t4_initial`.`subject` using utf8mb4) like (select `t4_initial1`.`subject` AS `subject` from `t4_initial1` where (`t4_initial1`.`subject` = 'aaa'))) */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;
/*!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 2010-06-07 10:19:37