-- MySQL dump 10.13 Distrib 6.0.10-alpha, for pc-linux-gnu (i686) -- -- Host: localhost Database: test -- ------------------------------------------------------ -- Server version 6.0.10-alpha-debug /*!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 `innodb_42580` -- DROP TABLE IF EXISTS `innodb_42580`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `innodb_42580` ( `c1` date NOT NULL, `c2` date DEFAULT NULL, `c3` datetime DEFAULT NULL, `c4` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`c1`), UNIQUE KEY `c2` (`c2`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `innodb_42580` -- LOCK TABLES `innodb_42580` WRITE; /*!40000 ALTER TABLE `innodb_42580` DISABLE KEYS */; INSERT INTO `innodb_42580` VALUES ('0000-00-00','0000-00-00','2008-01-04 00:00:00','2008-01-04 18:30:00'),('1983-09-05','1983-09-05','1983-09-06 13:28:00','1983-09-06 07:58:00'),('1983-09-07','1983-09-07','1983-09-08 00:00:00','1983-09-07 18:30:00'),('1998-12-28','1998-12-28','1998-12-28 00:00:00','1998-12-27 18:30:00'),('1998-12-29','1998-12-29','1998-12-29 00:00:00','1998-12-28 18:30:00'),('1998-12-30','1998-12-30','1998-12-30 11:30:45','1998-12-30 06:00:45'),('1998-12-31','1998-12-31','1998-12-31 11:30:45','1998-12-31 06:00:45'),('2007-05-23','2007-05-23','2007-05-24 09:15:28','2007-05-24 03:45:28'),('2007-05-25','2007-05-25','2007-05-26 00:00:00','2007-05-25 18:30:00'),('2008-01-01',NULL,'2008-01-02 00:00:00','2008-01-02 18:30:00'),('2008-01-17',NULL,NULL,'2009-01-29 05:41:27'),('2009-01-29','2009-01-29','2009-01-29 11:11:27','2009-01-28 18:30:00'); /*!40000 ALTER TABLE `innodb_42580` 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 2009-02-06 11:49:55