-- MySQL dump 10.13  Distrib 5.5.10, for Linux (x86_64)
--
-- Host: localhost    Database: cms
-- ------------------------------------------------------
-- Server version	5.5.10-log

/*!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: `cms`
--

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

USE `cms`;

--
-- Table structure for table `A`
--

DROP TABLE IF EXISTS `A`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `A` (
  `col_bigint` bigint(20) DEFAULT NULL,
  `col_enum` enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') DEFAULT NULL,
  `col_char_10` char(10) DEFAULT NULL,
  `col_char_255` char(255) DEFAULT NULL,
  `col_int` int(11) DEFAULT NULL,
  `col_char_10_not_null` char(10) NOT NULL,
  `col_int_not_null_key` int(11) NOT NULL,
  `col_enum_not_null` enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') NOT NULL,
  `col_char_255_not_null_key` char(255) NOT NULL,
  `col_int_key` int(11) DEFAULT NULL,
  `col_char_10_key` char(10) DEFAULT NULL,
  `col_char_255_not_null` char(255) NOT NULL,
  `col_enum_not_null_key` enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') NOT NULL,
  `pk` int(11) NOT NULL AUTO_INCREMENT,
  `col_bigint_key` bigint(20) DEFAULT NULL,
  `col_int_not_null` int(11) NOT NULL,
  `col_bigint_not_null` bigint(20) NOT NULL,
  `col_bigint_not_null_key` bigint(20) NOT NULL,
  `col_char_10_not_null_key` char(10) NOT NULL,
  `col_enum_key` enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') DEFAULT NULL,
  `col_char_255_key` char(255) DEFAULT NULL,
  PRIMARY KEY (`pk`),
  KEY `col_int_not_null_key` (`col_int_not_null_key`),
  KEY `col_char_255_not_null_key` (`col_char_255_not_null_key`),
  KEY `col_int_key` (`col_int_key`),
  KEY `col_char_10_key` (`col_char_10_key`),
  KEY `col_enum_not_null_key` (`col_enum_not_null_key`),
  KEY `col_bigint_key` (`col_bigint_key`),
  KEY `col_bigint_not_null_key` (`col_bigint_not_null_key`),
  KEY `col_char_10_not_null_key` (`col_char_10_not_null_key`),
  KEY `col_enum_key` (`col_enum_key`),
  KEY `col_char_255_key` (`col_char_255_key`)
) ENGINE=InnoDB AUTO_INCREMENT=231 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `A`
--

LOCK TABLES `A` WRITE;
/*!40000 ALTER TABLE `A` DISABLE KEYS */;
/*!40000 ALTER TABLE `A` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `AA`
--

DROP TABLE IF EXISTS `AA`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AA` (
  `col_char_255` char(255) DEFAULT NULL,
  `col_char_10_key` char(10) DEFAULT NULL,
  `pk` int(11) NOT NULL AUTO_INCREMENT,
  `col_int_key` int(11) DEFAULT NULL,
  `col_bigint_key` bigint(20) DEFAULT NULL,
  `col_enum_not_null` enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') NOT NULL,
  `col_char_10` char(10) DEFAULT NULL,
  `col_int_not_null_key` int(11) NOT NULL,
  `col_bigint_not_null` bigint(20) NOT NULL,
  `col_bigint_not_null_key` bigint(20) NOT NULL,
  `col_char_255_not_null_key` char(255) NOT NULL,
  `col_char_10_not_null_key` char(10) NOT NULL,
  `col_enum_key` enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') DEFAULT NULL,
  `col_char_255_not_null` char(255) NOT NULL,
  `col_char_255_key` char(255) DEFAULT NULL,
  `col_enum_not_null_key` enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') NOT NULL,
  `col_enum` enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') DEFAULT NULL,
  `col_char_10_not_null` char(10) NOT NULL,
  `col_bigint` bigint(20) DEFAULT NULL,
  `col_int` int(11) DEFAULT NULL,
  `col_int_not_null` int(11) NOT NULL,
  PRIMARY KEY (`pk`),
  KEY `col_char_10_key` (`col_char_10_key`),
  KEY `col_int_key` (`col_int_key`),
  KEY `col_bigint_key` (`col_bigint_key`),
  KEY `col_int_not_null_key` (`col_int_not_null_key`),
  KEY `col_bigint_not_null_key` (`col_bigint_not_null_key`),
  KEY `col_char_255_not_null_key` (`col_char_255_not_null_key`),
  KEY `col_char_10_not_null_key` (`col_char_10_not_null_key`),
  KEY `col_enum_key` (`col_enum_key`),
  KEY `col_char_255_key` (`col_char_255_key`),
  KEY `col_enum_not_null_key` (`col_enum_not_null_key`)
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `AA`
--

LOCK TABLES `AA` WRITE;
/*!40000 ALTER TABLE `AA` DISABLE KEYS */;
/*!40000 ALTER TABLE `AA` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `B`
--

DROP TABLE IF EXISTS `B`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `B` (
  `col_bigint_not_null_key` bigint(20) NOT NULL,
  `col_char_255_not_null_key` char(255) NOT NULL,
  `col_bigint` bigint(20) DEFAULT NULL,
  `col_int_not_null` int(11) NOT NULL,
  `col_enum_not_null` enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') NOT NULL,
  `col_char_10_not_null_key` char(10) NOT NULL,
  `col_bigint_not_null` bigint(20) NOT NULL,
  `col_enum` enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') DEFAULT NULL,
  `col_int_not_null_key` int(11) NOT NULL,
  `col_bigint_key` bigint(20) DEFAULT NULL,
  `col_char_10_key` char(10) DEFAULT NULL,
  `pk` int(11) NOT NULL AUTO_INCREMENT,
  `col_char_10_not_null` char(10) NOT NULL,
  `col_char_255_not_null` char(255) NOT NULL,
  `col_char_255` char(255) DEFAULT NULL,
  `col_enum_not_null_key` enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') NOT NULL,
  `col_int_key` int(11) DEFAULT NULL,
  `col_char_255_key` char(255) DEFAULT NULL,
  `col_char_10` char(10) DEFAULT NULL,
  `col_enum_key` enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') DEFAULT NULL,
  `col_int` int(11) DEFAULT NULL,
  PRIMARY KEY (`pk`),
  KEY `col_bigint_not_null_key` (`col_bigint_not_null_key`),
  KEY `col_char_255_not_null_key` (`col_char_255_not_null_key`),
  KEY `col_char_10_not_null_key` (`col_char_10_not_null_key`),
  KEY `col_int_not_null_key` (`col_int_not_null_key`),
  KEY `col_bigint_key` (`col_bigint_key`),
  KEY `col_char_10_key` (`col_char_10_key`),
  KEY `col_enum_not_null_key` (`col_enum_not_null_key`),
  KEY `col_int_key` (`col_int_key`),
  KEY `col_char_255_key` (`col_char_255_key`),
  KEY `col_enum_key` (`col_enum_key`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `B`
--

LOCK TABLES `B` WRITE;
/*!40000 ALTER TABLE `B` DISABLE KEYS */;
/*!40000 ALTER TABLE `B` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `BB`
--

DROP TABLE IF EXISTS `BB`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `BB` (
  `col_enum_key` enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') DEFAULT NULL,
  `col_char_255` char(255) DEFAULT NULL,
  `col_char_10_not_null` char(10) NOT NULL,
  `col_int` int(11) DEFAULT NULL,
  `col_bigint_not_null_key` bigint(20) NOT NULL,
  `col_enum_not_null_key` enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') NOT NULL,
  `col_char_10_not_null_key` char(10) NOT NULL,
  `col_enum` enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') DEFAULT NULL,
  `col_bigint` bigint(20) DEFAULT NULL,
  `pk` int(11) NOT NULL AUTO_INCREMENT,
  `col_bigint_key` bigint(20) DEFAULT NULL,
  `col_char_10` char(10) DEFAULT NULL,
  `col_char_255_key` char(255) DEFAULT NULL,
  `col_int_key` int(11) DEFAULT NULL,
  `col_enum_not_null` enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') NOT NULL,
  `col_int_not_null` int(11) NOT NULL,
  `col_char_255_not_null_key` char(255) NOT NULL,
  `col_char_255_not_null` char(255) NOT NULL,
  `col_bigint_not_null` bigint(20) NOT NULL,
  `col_char_10_key` char(10) DEFAULT NULL,
  `col_int_not_null_key` int(11) NOT NULL,
  PRIMARY KEY (`pk`),
  KEY `col_enum_key` (`col_enum_key`),
  KEY `col_bigint_not_null_key` (`col_bigint_not_null_key`),
  KEY `col_enum_not_null_key` (`col_enum_not_null_key`),
  KEY `col_char_10_not_null_key` (`col_char_10_not_null_key`),
  KEY `col_bigint_key` (`col_bigint_key`),
  KEY `col_char_255_key` (`col_char_255_key`),
  KEY `col_int_key` (`col_int_key`),
  KEY `col_char_255_not_null_key` (`col_char_255_not_null_key`),
  KEY `col_char_10_key` (`col_char_10_key`),
  KEY `col_int_not_null_key` (`col_int_not_null_key`)
) ENGINE=InnoDB AUTO_INCREMENT=167 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `BB`
--

LOCK TABLES `BB` WRITE;
/*!40000 ALTER TABLE `BB` DISABLE KEYS */;
/*!40000 ALTER TABLE `BB` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `C`
--

DROP TABLE IF EXISTS `C`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `C` (
  `col_bigint_not_null_key` bigint(20) NOT NULL,
  `col_int` int(11) DEFAULT NULL,
  `col_enum` enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') DEFAULT NULL,
  `col_int_key` int(11) DEFAULT NULL,
  `col_char_255_not_null` char(255) NOT NULL,
  `col_bigint_not_null` bigint(20) NOT NULL,
  `col_char_10_not_null` char(10) NOT NULL,
  `pk` int(11) NOT NULL AUTO_INCREMENT,
  `col_char_10` char(10) DEFAULT NULL,
  `col_char_255_not_null_key` char(255) NOT NULL,
  `col_enum_not_null` enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') NOT NULL,
  `col_bigint_key` bigint(20) DEFAULT NULL,
  `col_char_10_key` char(10) DEFAULT NULL,
  `col_char_10_not_null_key` char(10) NOT NULL,
  `col_bigint` bigint(20) DEFAULT NULL,
  `col_char_255_key` char(255) DEFAULT NULL,
  `col_char_255` char(255) DEFAULT NULL,
  `col_int_not_null` int(11) NOT NULL,
  `col_int_not_null_key` int(11) NOT NULL,
  `col_enum_key` enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') DEFAULT NULL,
  `col_enum_not_null_key` enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') NOT NULL,
  PRIMARY KEY (`pk`),
  KEY `col_bigint_not_null_key` (`col_bigint_not_null_key`),
  KEY `col_int_key` (`col_int_key`),
  KEY `col_char_255_not_null_key` (`col_char_255_not_null_key`),
  KEY `col_bigint_key` (`col_bigint_key`),
  KEY `col_char_10_key` (`col_char_10_key`),
  KEY `col_char_10_not_null_key` (`col_char_10_not_null_key`),
  KEY `col_char_255_key` (`col_char_255_key`),
  KEY `col_int_not_null_key` (`col_int_not_null_key`),
  KEY `col_enum_key` (`col_enum_key`),
  KEY `col_enum_not_null_key` (`col_enum_not_null_key`)
) ENGINE=InnoDB AUTO_INCREMENT=305 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `C`
--

LOCK TABLES `C` WRITE;
/*!40000 ALTER TABLE `C` DISABLE KEYS */;
/*!40000 ALTER TABLE `C` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `CC`
--

DROP TABLE IF EXISTS `CC`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `CC` (
  `col_int_not_null_key` int(11) NOT NULL,
  `col_bigint_not_null_key` bigint(20) NOT NULL,
  `col_enum_key` enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') DEFAULT NULL,
  `col_char_255` char(255) DEFAULT NULL,
  `pk` int(11) NOT NULL AUTO_INCREMENT,
  `col_bigint` bigint(20) DEFAULT NULL,
  `col_char_255_not_null_key` char(255) NOT NULL,
  `col_enum_not_null_key` enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') NOT NULL,
  `col_char_10` char(10) DEFAULT NULL,
  `col_enum` enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') DEFAULT NULL,
  `col_char_255_not_null` char(255) NOT NULL,
  `col_bigint_key` bigint(20) DEFAULT NULL,
  `col_char_10_not_null` char(10) NOT NULL,
  `col_char_10_not_null_key` char(10) NOT NULL,
  `col_int` int(11) DEFAULT NULL,
  `col_char_10_key` char(10) DEFAULT NULL,
  `col_bigint_not_null` bigint(20) NOT NULL,
  `col_int_key` int(11) DEFAULT NULL,
  `col_int_not_null` int(11) NOT NULL,
  `col_enum_not_null` enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') NOT NULL,
  `col_char_255_key` char(255) DEFAULT NULL,
  PRIMARY KEY (`pk`),
  KEY `col_int_not_null_key` (`col_int_not_null_key`),
  KEY `col_bigint_not_null_key` (`col_bigint_not_null_key`),
  KEY `col_enum_key` (`col_enum_key`),
  KEY `col_char_255_not_null_key` (`col_char_255_not_null_key`),
  KEY `col_enum_not_null_key` (`col_enum_not_null_key`),
  KEY `col_bigint_key` (`col_bigint_key`),
  KEY `col_char_10_not_null_key` (`col_char_10_not_null_key`),
  KEY `col_char_10_key` (`col_char_10_key`),
  KEY `col_int_key` (`col_int_key`),
  KEY `col_char_255_key` (`col_char_255_key`)
) ENGINE=InnoDB AUTO_INCREMENT=237 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `CC`
--

LOCK TABLES `CC` WRITE;
/*!40000 ALTER TABLE `CC` DISABLE KEYS */;
/*!40000 ALTER TABLE `CC` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `D`
--

DROP TABLE IF EXISTS `D`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `D` (
  `col_char_255` char(255) DEFAULT NULL,
  `col_enum_key` enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') DEFAULT NULL,
  `col_bigint_not_null_key` bigint(20) NOT NULL,
  `col_char_255_not_null_key` char(255) NOT NULL,
  `col_bigint_key` bigint(20) DEFAULT NULL,
  `col_bigint` bigint(20) DEFAULT NULL,
  `col_enum_not_null_key` enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') NOT NULL,
  `col_enum_not_null` enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') NOT NULL,
  `col_bigint_not_null` bigint(20) NOT NULL,
  `col_char_10_not_null_key` char(10) NOT NULL,
  `col_char_255_key` char(255) DEFAULT NULL,
  `col_enum` enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') DEFAULT NULL,
  `col_char_255_not_null` char(255) NOT NULL,
  `col_char_10_not_null` char(10) NOT NULL,
  `col_int_not_null` int(11) NOT NULL,
  `col_int_key` int(11) DEFAULT NULL,
  `col_char_10_key` char(10) DEFAULT NULL,
  `pk` int(11) NOT NULL AUTO_INCREMENT,
  `col_int` int(11) DEFAULT NULL,
  `col_char_10` char(10) DEFAULT NULL,
  `col_int_not_null_key` int(11) NOT NULL,
  PRIMARY KEY (`pk`),
  KEY `col_enum_key` (`col_enum_key`),
  KEY `col_bigint_not_null_key` (`col_bigint_not_null_key`),
  KEY `col_char_255_not_null_key` (`col_char_255_not_null_key`),
  KEY `col_bigint_key` (`col_bigint_key`),
  KEY `col_enum_not_null_key` (`col_enum_not_null_key`),
  KEY `col_char_10_not_null_key` (`col_char_10_not_null_key`),
  KEY `col_char_255_key` (`col_char_255_key`),
  KEY `col_int_key` (`col_int_key`),
  KEY `col_char_10_key` (`col_char_10_key`),
  KEY `col_int_not_null_key` (`col_int_not_null_key`)
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `D`
--

LOCK TABLES `D` WRITE;
/*!40000 ALTER TABLE `D` DISABLE KEYS */;
/*!40000 ALTER TABLE `D` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `DD`
--

DROP TABLE IF EXISTS `DD`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `DD` (
  `col_char_255` char(255) DEFAULT NULL,
  `col_enum_not_null` enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') NOT NULL,
  `col_enum_key` enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') DEFAULT NULL,
  `col_bigint_not_null` bigint(20) NOT NULL,
  `col_char_255_key` char(255) DEFAULT NULL,
  `col_bigint` bigint(20) DEFAULT NULL,
  `col_char_255_not_null_key` char(255) NOT NULL,
  `col_char_10` char(10) DEFAULT NULL,
  `col_char_255_not_null` char(255) NOT NULL,
  `col_bigint_key` bigint(20) DEFAULT NULL,
  `col_bigint_not_null_key` bigint(20) NOT NULL,
  `col_char_10_not_null` char(10) NOT NULL,
  `col_enum` enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') DEFAULT NULL,
  `col_int_not_null_key` int(11) NOT NULL,
  `col_char_10_key` char(10) DEFAULT NULL,
  `col_enum_not_null_key` enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') NOT NULL,
  `col_int` int(11) DEFAULT NULL,
  `col_int_not_null` int(11) NOT NULL,
  `col_int_key` int(11) DEFAULT NULL,
  `pk` int(11) NOT NULL AUTO_INCREMENT,
  `col_char_10_not_null_key` char(10) NOT NULL,
  PRIMARY KEY (`pk`),
  KEY `col_enum_key` (`col_enum_key`),
  KEY `col_char_255_key` (`col_char_255_key`),
  KEY `col_char_255_not_null_key` (`col_char_255_not_null_key`),
  KEY `col_bigint_key` (`col_bigint_key`),
  KEY `col_bigint_not_null_key` (`col_bigint_not_null_key`),
  KEY `col_int_not_null_key` (`col_int_not_null_key`),
  KEY `col_char_10_key` (`col_char_10_key`),
  KEY `col_enum_not_null_key` (`col_enum_not_null_key`),
  KEY `col_int_key` (`col_int_key`),
  KEY `col_char_10_not_null_key` (`col_char_10_not_null_key`)
) ENGINE=InnoDB AUTO_INCREMENT=201 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `DD`
--

LOCK TABLES `DD` WRITE;
/*!40000 ALTER TABLE `DD` DISABLE KEYS */;
/*!40000 ALTER TABLE `DD` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `comments`
--

DROP TABLE IF EXISTS `comments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `comments` (
  `comment_ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `comment_post_ID` bigint(20) unsigned NOT NULL DEFAULT '0',
  `comment_author` tinytext NOT NULL,
  `comment_author_email` varchar(100) NOT NULL DEFAULT '',
  `comment_author_url` varchar(200) NOT NULL DEFAULT '',
  `comment_author_IP` varchar(100) NOT NULL DEFAULT '',
  `comment_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `comment_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `comment_content` text NOT NULL,
  `comment_karma` int(11) NOT NULL DEFAULT '0',
  `comment_approved` varchar(20) NOT NULL DEFAULT '1',
  `comment_agent` varchar(255) NOT NULL DEFAULT '',
  `comment_type` varchar(20) NOT NULL DEFAULT '',
  `comment_parent` bigint(20) unsigned NOT NULL DEFAULT '0',
  `user_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`comment_ID`),
  KEY `comment_approved` (`comment_approved`),
  KEY `comment_post_ID` (`comment_post_ID`),
  KEY `comment_approved_date_gmt` (`comment_approved`,`comment_date_gmt`),
  KEY `comment_date_gmt` (`comment_date_gmt`),
  KEY `comment_parent` (`comment_parent`)
) ENGINE=InnoDB AUTO_INCREMENT=648922 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `comments`
--

LOCK TABLES `comments` WRITE;
/*!40000 ALTER TABLE `comments` DISABLE KEYS */;
/*!40000 ALTER TABLE `comments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `posts`
--

DROP TABLE IF EXISTS `posts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `posts` (
  `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `post_author` bigint(20) unsigned NOT NULL DEFAULT '0',
  `post_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `post_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `post_content` longtext NOT NULL,
  `post_title` text NOT NULL,
  `post_excerpt` text NOT NULL,
  `post_status` varchar(20) NOT NULL DEFAULT 'publish',
  `comment_status` varchar(20) NOT NULL DEFAULT 'open',
  `ping_status` varchar(20) NOT NULL DEFAULT 'open',
  `post_password` varchar(20) NOT NULL DEFAULT '',
  `post_name` varchar(200) NOT NULL DEFAULT '',
  `to_ping` text NOT NULL,
  `pinged` text NOT NULL,
  `post_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `post_modified_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `post_content_filtered` text NOT NULL,
  `post_parent` bigint(20) unsigned NOT NULL DEFAULT '0',
  `guid` varchar(255) NOT NULL DEFAULT '',
  `menu_order` int(11) NOT NULL DEFAULT '0',
  `post_type` varchar(20) NOT NULL DEFAULT 'post',
  `post_mime_type` varchar(100) NOT NULL DEFAULT '',
  `comment_count` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `post_name` (`post_name`),
  KEY `type_status_date` (`post_type`,`post_status`,`post_date`,`ID`),
  KEY `post_parent` (`post_parent`),
  KEY `post_author` (`post_author`)
) ENGINE=InnoDB AUTO_INCREMENT=710031 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `posts`
--

LOCK TABLES `posts` WRITE;
/*!40000 ALTER TABLE `posts` DISABLE KEYS */;
/*!40000 ALTER TABLE `posts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `table1`
--

DROP TABLE IF EXISTS `table1`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `table1` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `data` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=438423495 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `table1`
--

LOCK TABLES `table1` WRITE;
/*!40000 ALTER TABLE `table1` DISABLE KEYS */;
/*!40000 ALTER TABLE `table1` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `test_table`
--

DROP TABLE IF EXISTS `test_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `test_table` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `blob_data` blob,
  `blob_sha1` char(40) DEFAULT NULL,
  `text_data` text,
  `varchar_data` varchar(2000) DEFAULT NULL,
  `flag` tinyint(4) DEFAULT NULL,
  `datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10069260 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `test_table`
--

LOCK TABLES `test_table` WRITE;
/*!40000 ALTER TABLE `test_table` DISABLE KEYS */;
/*!40000 ALTER TABLE `test_table` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tmp`
--

DROP TABLE IF EXISTS `tmp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tmp` (
  `data` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tmp`
--

LOCK TABLES `tmp` WRITE;
/*!40000 ALTER TABLE `tmp` DISABLE KEYS */;
/*!40000 ALTER TABLE `tmp` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Current Database: `memcache`
--

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

USE `memcache`;

--
-- Table structure for table `MixTest`
--

DROP TABLE IF EXISTS `MixTest`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `MixTest` (
  `field1` int(11) DEFAULT NULL,
  `field2` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 MIN_ROWS=1 MAX_ROWS=2;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `MixTest`
--

LOCK TABLES `MixTest` WRITE;
/*!40000 ALTER TABLE `MixTest` DISABLE KEYS */;
/*!40000 ALTER TABLE `MixTest` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `bf_benchmark`
--

DROP TABLE IF EXISTS `bf_benchmark`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bf_benchmark` (
  `benchmark_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`benchmark_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bf_benchmark`
--

LOCK TABLES `bf_benchmark` WRITE;
/*!40000 ALTER TABLE `bf_benchmark` DISABLE KEYS */;
/*!40000 ALTER TABLE `bf_benchmark` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `bf_benchmark_properties`
--

DROP TABLE IF EXISTS `bf_benchmark_properties`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bf_benchmark_properties` (
  `test_run_id` int(11) NOT NULL,
  `data` mediumtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bf_benchmark_properties`
--

LOCK TABLES `bf_benchmark_properties` WRITE;
/*!40000 ALTER TABLE `bf_benchmark_properties` DISABLE KEYS */;
/*!40000 ALTER TABLE `bf_benchmark_properties` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `bf_drivers`
--

DROP TABLE IF EXISTS `bf_drivers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bf_drivers` (
  `driver_id` int(11) NOT NULL,
  `driver_type_id` int(11) NOT NULL,
  `filename` varchar(255) NOT NULL,
  `bf_comment` varchar(255) DEFAULT NULL,
  `vendor` char(50) NOT NULL,
  `parameter1_title` char(30) DEFAULT NULL,
  `parameter2_title` char(30) DEFAULT NULL,
  `parameter3_title` char(30) DEFAULT NULL,
  `parameter4_title` char(30) DEFAULT NULL,
  `parameter5_title` char(30) DEFAULT NULL,
  `parameter6_title` char(30) DEFAULT NULL,
  `flags` int(11) NOT NULL,
  `driver_version` int(11) DEFAULT NULL,
  PRIMARY KEY (`driver_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bf_drivers`
--

LOCK TABLES `bf_drivers` WRITE;
/*!40000 ALTER TABLE `bf_drivers` DISABLE KEYS */;
/*!40000 ALTER TABLE `bf_drivers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `bf_harddrives`
--

DROP TABLE IF EXISTS `bf_harddrives`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bf_harddrives` (
  `nHarddriveID` int(11) NOT NULL,
  `szDrive` varchar(2048) NOT NULL,
  `szVolume` varchar(2048) DEFAULT NULL,
  `szFileSystem` varchar(255) NOT NULL,
  `nDriveType` int(11) NOT NULL,
  `dwSecPerClus` int(11) NOT NULL,
  `dwBytesPerSec` int(11) NOT NULL,
  `dwFreeClus` int(11) NOT NULL,
  `dwTotalClus` int(11) NOT NULL,
  `dwTotalBytes` bigint(20) NOT NULL,
  `dwFreeBytes` bigint(20) NOT NULL,
  `dwUsedBytes` bigint(20) NOT NULL,
  PRIMARY KEY (`nHarddriveID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bf_harddrives`
--

LOCK TABLES `bf_harddrives` WRITE;
/*!40000 ALTER TABLE `bf_harddrives` DISABLE KEYS */;
/*!40000 ALTER TABLE `bf_harddrives` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `bf_stations`
--

DROP TABLE IF EXISTS `bf_stations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bf_stations` (
  `station_id` int(11) NOT NULL,
  `computer_name` varchar(255) NOT NULL,
  PRIMARY KEY (`station_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bf_stations`
--

LOCK TABLES `bf_stations` WRITE;
/*!40000 ALTER TABLE `bf_stations` DISABLE KEYS */;
/*!40000 ALTER TABLE `bf_stations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ibd`
--

DROP TABLE IF EXISTS `ibd`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ibd` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL DEFAULT '',
  `exchange` varchar(5) NOT NULL DEFAULT '',
  `sector` varchar(50) NOT NULL DEFAULT '',
  `quantity` int(11) unsigned NOT NULL,
  `price` float(9,3) unsigned NOT NULL,
  `datetime` time NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1269330 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ibd`
--

LOCK TABLES `ibd` WRITE;
/*!40000 ALTER TABLE `ibd` DISABLE KEYS */;
/*!40000 ALTER TABLE `ibd` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ibd1`
--

DROP TABLE IF EXISTS `ibd1`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ibd1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL DEFAULT '',
  `exchange` varchar(5) NOT NULL DEFAULT '',
  `sector` varchar(50) NOT NULL DEFAULT '',
  `quantity` int(11) unsigned NOT NULL,
  `price` float(9,3) unsigned NOT NULL,
  `datetime` time NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=512152 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ibd1`
--

LOCK TABLES `ibd1` WRITE;
/*!40000 ALTER TABLE `ibd1` DISABLE KEYS */;
/*!40000 ALTER TABLE `ibd1` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ibd2`
--

DROP TABLE IF EXISTS `ibd2`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ibd2` (
  `cnt` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ibd2`
--

LOCK TABLES `ibd2` WRITE;
/*!40000 ALTER TABLE `ibd2` DISABLE KEYS */;
/*!40000 ALTER TABLE `ibd2` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jumbo2`
--

DROP TABLE IF EXISTS `jumbo2`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jumbo2` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `data` varchar(1024) DEFAULT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `jumbo2`
--

LOCK TABLES `jumbo2` WRITE;
/*!40000 ALTER TABLE `jumbo2` DISABLE KEYS */;
/*!40000 ALTER TABLE `jumbo2` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `lbalancer`
--

DROP TABLE IF EXISTS `lbalancer`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lbalancer` (
  `Variable` varchar(255) DEFAULT NULL,
  `Value` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lbalancer`
--

LOCK TABLES `lbalancer` WRITE;
/*!40000 ALTER TABLE `lbalancer` DISABLE KEYS */;
/*!40000 ALTER TABLE `lbalancer` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sbtest`
--

DROP TABLE IF EXISTS `sbtest`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sbtest` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `k` int(10) unsigned NOT NULL DEFAULT '0',
  `c` char(120) NOT NULL DEFAULT '',
  `pad` char(60) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `k` (`k`)
) ENGINE=InnoDB AUTO_INCREMENT=200000 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sbtest`
--

LOCK TABLES `sbtest` WRITE;
/*!40000 ALTER TABLE `sbtest` DISABLE KEYS */;
/*!40000 ALTER TABLE `sbtest` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t`
--

DROP TABLE IF EXISTS `t`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t` (
  `i` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t`
--

LOCK TABLES `t` WRITE;
/*!40000 ALTER TABLE `t` DISABLE KEYS */;
/*!40000 ALTER TABLE `t` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `table1`
--

DROP TABLE IF EXISTS `table1`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `table1` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `data` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=319702 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `table1`
--

LOCK TABLES `table1` WRITE;
/*!40000 ALTER TABLE `table1` DISABLE KEYS */;
/*!40000 ALTER TABLE `table1` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Current Database: `pms`
--

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

USE `pms`;

--
-- Table structure for table `comments`
--

DROP TABLE IF EXISTS `comments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `comments` (
  `cid` int(11) NOT NULL AUTO_INCREMENT,
  `pid` int(11) NOT NULL DEFAULT '0',
  `nid` int(11) NOT NULL DEFAULT '0',
  `uid` int(11) NOT NULL DEFAULT '0',
  `subject` varchar(64) NOT NULL DEFAULT '',
  `comment` longtext NOT NULL,
  `hostname` varchar(128) NOT NULL DEFAULT '',
  `timestamp` int(11) NOT NULL DEFAULT '0',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `format` smallint(6) NOT NULL DEFAULT '0',
  `thread` varchar(255) NOT NULL,
  `name` varchar(60) DEFAULT NULL,
  `mail` varchar(64) DEFAULT NULL,
  `homepage` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`cid`),
  KEY `pid` (`pid`),
  KEY `nid` (`nid`),
  KEY `status` (`status`),
  FULLTEXT KEY `comment` (`comment`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `comments`
--

LOCK TABLES `comments` WRITE;
/*!40000 ALTER TABLE `comments` DISABLE KEYS */;
/*!40000 ALTER TABLE `comments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `livedata`
--

DROP TABLE IF EXISTS `livedata`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `livedata` (
  `scid` int(11) NOT NULL AUTO_INCREMENT,
  `religarecode` int(11) DEFAULT NULL,
  `shortname` varchar(50) DEFAULT NULL,
  `lttime` datetime DEFAULT NULL,
  `ltprice` double(15,3) DEFAULT NULL,
  `highprice` double(15,3) DEFAULT NULL,
  `lowprice` double(15,3) DEFAULT NULL,
  `openprice` double(15,3) DEFAULT NULL,
  `prevcloseprice` double(15,3) DEFAULT NULL,
  `bidprice` double(15,3) DEFAULT NULL,
  `offerprice` double(15,3) DEFAULT NULL,
  `bidqty` int(11) DEFAULT NULL,
  `offerqty` int(11) DEFAULT NULL,
  `ttqty` int(11) DEFAULT NULL,
  `updatetime` datetime DEFAULT NULL,
  `prevtdate` datetime DEFAULT NULL,
  `yearhigh` double(15,3) DEFAULT NULL,
  `yearlow` double(15,3) DEFAULT NULL,
  `yearhighdate` datetime DEFAULT NULL,
  `yearlowdate` datetime DEFAULT NULL,
  `avgprice` double(15,3) DEFAULT NULL,
  `lasttick` double(15,3) DEFAULT NULL,
  PRIMARY KEY (`scid`),
  UNIQUE KEY `scid` (`scid`)
) ENGINE=InnoDB AUTO_INCREMENT=501 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `livedata`
--

LOCK TABLES `livedata` WRITE;
/*!40000 ALTER TABLE `livedata` DISABLE KEYS */;
/*!40000 ALTER TABLE `livedata` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `portfolio`
--

DROP TABLE IF EXISTS `portfolio`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `portfolio` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) DEFAULT NULL,
  `acountid` int(11) DEFAULT NULL,
  `buyid` int(11) DEFAULT NULL,
  `scid` int(11) DEFAULT NULL,
  `scex` int(11) DEFAULT NULL,
  `buyprice` double(15,3) DEFAULT NULL,
  `buydate` datetime DEFAULT NULL,
  `comments` text,
  `updatetime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=41176 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `portfolio`
--

LOCK TABLES `portfolio` WRITE;
/*!40000 ALTER TABLE `portfolio` DISABLE KEYS */;
/*!40000 ALTER TABLE `portfolio` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `table1`
--

DROP TABLE IF EXISTS `table1`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `table1` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `data` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16090825 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `table1`
--

LOCK TABLES `table1` WRITE;
/*!40000 ALTER TABLE `table1` DISABLE KEYS */;
/*!40000 ALTER TABLE `table1` 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 2012-08-06 18:00:35