-- MySQL dump 10.4
--
-- Host: localhost    Database: cts
-- ------------------------------------------------------
-- Server version	5.0.0-alpha-debug-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT, CHARACTER_SET_CLIENT=utf8 */;
/*!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 */;

--
-- Table structure for table `BB_tab`
--

DROP TABLE IF EXISTS BB_tab;
CREATE TABLE BB_tab (
  KEY_ID int(11) NOT NULL default '0',
  BRAND_NAME varchar(32) default NULL,
  PRICE float default NULL,
  PRIMARY KEY  (KEY_ID)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `BB_tab`
--


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

--
-- Table structure for table `Bigint_Tab`
--

DROP TABLE IF EXISTS Bigint_Tab;
CREATE TABLE Bigint_Tab (
  MAX_VAL bigint(20) default NULL,
  MIN_VAL bigint(20) default NULL,
  NULL_VAL bigint(20) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Bigint_Tab`
--


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

--
-- Table structure for table `Binary_Tab`
--

DROP TABLE IF EXISTS Binary_Tab;
CREATE TABLE Binary_Tab (
  BINARY_VAL blob
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Binary_Tab`
--


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

--
-- Table structure for table `Bit_Tab`
--

DROP TABLE IF EXISTS Bit_Tab;
CREATE TABLE Bit_Tab (
  MAX_VAL tinyint(1) default NULL,
  MIN_VAL tinyint(1) default NULL,
  NULL_VAL tinyint(1) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Bit_Tab`
--


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

--
-- Table structure for table `Char_Tab`
--

DROP TABLE IF EXISTS Char_Tab;
CREATE TABLE Char_Tab (
  COFFEE_NAME char(30) default NULL,
  NULL_VAL char(30) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Char_Tab`
--


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

--
-- Table structure for table `Connector_Tab`
--

DROP TABLE IF EXISTS Connector_Tab;
CREATE TABLE Connector_Tab (
  KEY_ID int(11) default NULL,
  PRODUCT_NAME varchar(32) default NULL,
  PRICE float default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Connector_Tab`
--


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

--
-- Table structure for table `Date_Tab`
--

DROP TABLE IF EXISTS Date_Tab;
CREATE TABLE Date_Tab (
  MFG_DATE date default NULL,
  NULL_VAL date default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Date_Tab`
--


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

--
-- Table structure for table `Decimal_Tab`
--

DROP TABLE IF EXISTS Decimal_Tab;
CREATE TABLE Decimal_Tab (
  MAX_VAL decimal(30,15) default NULL,
  MIN_VAL decimal(30,15) default NULL,
  NULL_VAL decimal(30,15) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Decimal_Tab`
--


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

--
-- Table structure for table `Deploy_Tab1`
--

DROP TABLE IF EXISTS Deploy_Tab1;
CREATE TABLE Deploy_Tab1 (
  KEY_ID int(11) NOT NULL default '0',
  BRAND_NAME varchar(32) default NULL,
  PRICE float default NULL,
  PRIMARY KEY  (KEY_ID)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Deploy_Tab1`
--


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

--
-- Table structure for table `Deploy_Tab2`
--

DROP TABLE IF EXISTS Deploy_Tab2;
CREATE TABLE Deploy_Tab2 (
  KEY_ID varchar(100) NOT NULL default '',
  BRAND_NAME varchar(32) default NULL,
  PRICE float default NULL,
  PRIMARY KEY  (KEY_ID)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Deploy_Tab2`
--


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

--
-- Table structure for table `Deploy_Tab3`
--

DROP TABLE IF EXISTS Deploy_Tab3;
CREATE TABLE Deploy_Tab3 (
  KEY_ID bigint(20) NOT NULL default '0',
  BRAND_NAME varchar(32) default NULL,
  PRICE float default NULL,
  PRIMARY KEY  (KEY_ID)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Deploy_Tab3`
--


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

--
-- Table structure for table `Deploy_Tab4`
--

DROP TABLE IF EXISTS Deploy_Tab4;
CREATE TABLE Deploy_Tab4 (
  KEY_ID float NOT NULL default '0',
  BRAND_NAME varchar(32) default NULL,
  PRICE float default NULL,
  PRIMARY KEY  (KEY_ID)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Deploy_Tab4`
--


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

--
-- Table structure for table `Deploy_Tab5`
--

DROP TABLE IF EXISTS Deploy_Tab5;
CREATE TABLE Deploy_Tab5 (
  KEY_ID1 int(11) NOT NULL default '0',
  KEY_ID2 varchar(100) NOT NULL default '',
  KEY_ID3 float NOT NULL default '0',
  BRAND_NAME varchar(32) default NULL,
  PRICE float default NULL,
  PRIMARY KEY  (KEY_ID1,KEY_ID2,KEY_ID3)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Deploy_Tab5`
--


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

--
-- Table structure for table `Double_Tab`
--

DROP TABLE IF EXISTS Double_Tab;
CREATE TABLE Double_Tab (
  MAX_VAL double default NULL,
  MIN_VAL double default NULL,
  NULL_VAL double default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Double_Tab`
--


/*!40000 ALTER TABLE Double_Tab DISABLE KEYS */;
LOCK TABLES Double_Tab WRITE;
INSERT INTO Double_Tab VALUES (1e+125,1e-130,NULL);
UNLOCK TABLES;
/*!40000 ALTER TABLE Double_Tab ENABLE KEYS */;

--
-- Table structure for table `Float_Tab`
--

DROP TABLE IF EXISTS Float_Tab;
CREATE TABLE Float_Tab (
  MAX_VAL double default NULL,
  MIN_VAL double default NULL,
  NULL_VAL double default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Float_Tab`
--


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

--
-- Table structure for table `Integer_Tab`
--

DROP TABLE IF EXISTS Integer_Tab;
CREATE TABLE Integer_Tab (
  MAX_VAL int(11) default NULL,
  MIN_VAL int(11) default NULL,
  NULL_VAL int(11) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Integer_Tab`
--


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

--
-- Table structure for table `Integration_Tab`
--

DROP TABLE IF EXISTS Integration_Tab;
CREATE TABLE Integration_Tab (
  ACCOUNT int(11) NOT NULL default '0',
  BALANCE float default NULL,
  PRIMARY KEY  (ACCOUNT)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Integration_Tab`
--


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

--
-- Table structure for table `Integration_sec_Tab`
--

DROP TABLE IF EXISTS Integration_sec_Tab;
CREATE TABLE Integration_sec_Tab (
  LOG_NO int(11) default NULL,
  LINE_NO int(11) default NULL,
  MESSAGE varchar(255) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Integration_sec_Tab`
--


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

--
-- Table structure for table `Jta_Tab1`
--

DROP TABLE IF EXISTS Jta_Tab1;
CREATE TABLE Jta_Tab1 (
  KEY_ID int(11) default NULL,
  COF_NAME varchar(32) default NULL,
  PRICE float default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Jta_Tab1`
--


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

--
-- Table structure for table `Jta_Tab2`
--

DROP TABLE IF EXISTS Jta_Tab2;
CREATE TABLE Jta_Tab2 (
  KEY_ID int(11) default NULL,
  CHOC_NAME varchar(32) default NULL,
  PRICE float default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Jta_Tab2`
--


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

--
-- Table structure for table `Longvarbinary_Tab`
--

DROP TABLE IF EXISTS Longvarbinary_Tab;
CREATE TABLE Longvarbinary_Tab (
  LONGVARBINARY_VAL longblob
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Longvarbinary_Tab`
--


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

--
-- Table structure for table `Longvarchar_Tab`
--

DROP TABLE IF EXISTS Longvarchar_Tab;
CREATE TABLE Longvarchar_Tab (
  COFFEE_NAME mediumtext
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Longvarchar_Tab`
--


/*!40000 ALTER TABLE Longvarchar_Tab DISABLE KEYS */;
LOCK TABLES Longvarchar_Tab WRITE;
INSERT INTO Longvarchar_Tab VALUES ('1999-12-31 12:59:59');
UNLOCK TABLES;
/*!40000 ALTER TABLE Longvarchar_Tab ENABLE KEYS */;

--
-- Table structure for table `Longvarcharnull_Tab`
--

DROP TABLE IF EXISTS Longvarcharnull_Tab;
CREATE TABLE Longvarcharnull_Tab (
  NULL_VAL mediumtext
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Longvarcharnull_Tab`
--


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

--
-- Table structure for table `Numeric_Tab`
--

DROP TABLE IF EXISTS Numeric_Tab;
CREATE TABLE Numeric_Tab (
  MAX_VAL decimal(30,15) default NULL,
  MIN_VAL decimal(30,15) default NULL,
  NULL_VAL decimal(30,15) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Numeric_Tab`
--


/*!40000 ALTER TABLE Numeric_Tab DISABLE KEYS */;
LOCK TABLES Numeric_Tab WRITE;
INSERT INTO Numeric_Tab VALUES ("999999999999999.000000000000000","0.000000000000001",NULL);
UNLOCK TABLES;
/*!40000 ALTER TABLE Numeric_Tab ENABLE KEYS */;

--
-- Table structure for table `Real_Tab`
--

DROP TABLE IF EXISTS Real_Tab;
CREATE TABLE Real_Tab (
  MAX_VAL double default NULL,
  MIN_VAL double default NULL,
  NULL_VAL double default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Real_Tab`
--


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

--
-- Table structure for table `Sec_Tab1`
--

DROP TABLE IF EXISTS Sec_Tab1;
CREATE TABLE Sec_Tab1 (
  KEY_ID int(11) NOT NULL default '0',
  PRICE float default NULL,
  BRAND varchar(32) default NULL,
  PRIMARY KEY  (KEY_ID)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Sec_Tab1`
--


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

--
-- Table structure for table `Smallint_Tab`
--

DROP TABLE IF EXISTS Smallint_Tab;
CREATE TABLE Smallint_Tab (
  MAX_VAL smallint(6) default NULL,
  MIN_VAL smallint(6) default NULL,
  NULL_VAL smallint(6) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Smallint_Tab`
--


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

--
-- Table structure for table `TXBean_Tab1`
--

DROP TABLE IF EXISTS TXBean_Tab1;
CREATE TABLE TXBean_Tab1 (
  KEY_ID int(11) default NULL,
  TABONE_NAME varchar(32) default NULL,
  PRICE float default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `TXBean_Tab1`
--


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

--
-- Table structure for table `TXBean_Tab2`
--

DROP TABLE IF EXISTS TXBean_Tab2;
CREATE TABLE TXBean_Tab2 (
  KEY_ID int(11) default NULL,
  TABTWO_NAME varchar(32) default NULL,
  PRICE float default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `TXBean_Tab2`
--


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

--
-- Table structure for table `TXEBean_Tab`
--

DROP TABLE IF EXISTS TXEBean_Tab;
CREATE TABLE TXEBean_Tab (
  KEY_ID int(11) NOT NULL default '0',
  BRAND_NAME varchar(32) default NULL,
  PRICE float default NULL,
  PRIMARY KEY  (KEY_ID)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `TXEBean_Tab`
--


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

--
-- Table structure for table `Time_Tab`
--

DROP TABLE IF EXISTS Time_Tab;
CREATE TABLE Time_Tab (
  BRK_TIME time default NULL,
  NULL_VAL time default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Time_Tab`
--


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

--
-- Table structure for table `Timestamp_Tab`
--

DROP TABLE IF EXISTS Timestamp_Tab;
CREATE TABLE Timestamp_Tab (
  IN_TIME datetime default NULL,
  NULL_VAL datetime default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Timestamp_Tab`
--


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

--
-- Table structure for table `Tinyint_Tab`
--

DROP TABLE IF EXISTS Tinyint_Tab;
CREATE TABLE Tinyint_Tab (
  MAX_VAL tinyint(4) default NULL,
  MIN_VAL tinyint(4) default NULL,
  NULL_VAL tinyint(4) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Tinyint_Tab`
--


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

--
-- Table structure for table `Varbinary_Tab`
--

DROP TABLE IF EXISTS Varbinary_Tab;
CREATE TABLE Varbinary_Tab (
  VARBINARY_VAL blob
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Varbinary_Tab`
--


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

--
-- Table structure for table `Varchar_Tab`
--

DROP TABLE IF EXISTS Varchar_Tab;
CREATE TABLE Varchar_Tab (
  COFFEE_NAME varchar(30) default NULL,
  NULL_VAL varchar(30) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Varchar_Tab`
--


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

--
-- Table structure for table `XA_Tab1`
--

DROP TABLE IF EXISTS XA_Tab1;
CREATE TABLE XA_Tab1 (
  col1 int(11) NOT NULL default '0',
  col2 varchar(32) default NULL,
  col3 varchar(32) default NULL,
  PRIMARY KEY  (col1)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `XA_Tab1`
--


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

--
-- Table structure for table `XA_Tab2`
--

DROP TABLE IF EXISTS XA_Tab2;
CREATE TABLE XA_Tab2 (
  col1 int(11) NOT NULL default '0',
  col2 varchar(32) default NULL,
  col3 varchar(32) default NULL,
  PRIMARY KEY  (col1)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `XA_Tab2`
--


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

--
-- Table structure for table `ctstable1`
--

DROP TABLE IF EXISTS ctstable1;
CREATE TABLE ctstable1 (
  TYPE_ID int(11) NOT NULL default '0',
  TYPE_DESC varchar(32) default NULL,
  PRIMARY KEY  (TYPE_ID)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ctstable1`
--


/*!40000 ALTER TABLE ctstable1 DISABLE KEYS */;
LOCK TABLES ctstable1 WRITE;
INSERT INTO ctstable1 VALUES (1,NULL),(2,NULL),(3,NULL),(4,NULL),(5,NULL),(6,NULL),(7,NULL),(8,NULL),(9,NULL),(10,NULL);
UNLOCK TABLES;
/*!40000 ALTER TABLE ctstable1 ENABLE KEYS */;

--
-- Table structure for table `ctstable2`
--

DROP TABLE IF EXISTS ctstable2;
CREATE TABLE ctstable2 (
  KEY_ID int(11) NOT NULL default '0',
  COF_NAME varchar(32) default NULL,
  PRICE float default NULL,
  TYPE_ID int(11) default NULL,
  PRIMARY KEY  (KEY_ID),
  KEY TYPE_ID (TYPE_ID),
  CONSTRAINT `0_52` FOREIGN KEY (`TYPE_ID`) REFERENCES `ctstable1` (`TYPE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ctstable2`
--


/*!40000 ALTER TABLE ctstable2 DISABLE KEYS */;
LOCK TABLES ctstable2 WRITE;
INSERT INTO ctstable2 VALUES (2,'Continue-2',2,2),(3,'COFFEE-3',3,2),(4,'COFFEE-4',4,3),(5,'COFFEE-5',5,3),(6,'COFFEE-6',6,3),(7,'COFFEE-7',7,4),(8,'COFFEE-8',8,4),(9,'COFFEE-9',9,4);
UNLOCK TABLES;
/*!40000 ALTER TABLE ctstable2 ENABLE KEYS */;

--
-- Table structure for table `ctstable3`
--

DROP TABLE IF EXISTS ctstable3;
CREATE TABLE ctstable3 (
  STRING1 varchar(20) default NULL,
  STRING2 varchar(20) default NULL,
  STRING3 varchar(20) default NULL,
  NUMCOL decimal(10,0) default NULL,
  FLOATCOL float default NULL,
  DATECOL date default NULL,
  TIMECOL time default NULL,
  TSCOL1 datetime default NULL,
  TSCOL2 datetime default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ctstable3`
--


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

--
-- Table structure for table `ctstable4`
--

DROP TABLE IF EXISTS ctstable4;
CREATE TABLE ctstable4 (
  STRING4 varchar(20) default NULL,
  NUMCOL decimal(10,0) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ctstable4`
--


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

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