D:\dump>mysqldump wbs tblSessionWork02 -u root -p --no-data
Enter password: *********
-- MySQL dump 10.13  Distrib 5.1.32, for Win32 (ia32)
--
-- Host: localhost    Database: wbs
-- ------------------------------------------------------
-- Server version       5.1.32-community-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 */;

--
-- Table structure for table `tblsessionwork02`
--

DROP TABLE IF EXISTS `tblsessionwork02`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tblsessionwork02` (
  `flngSessionWork02Id` bigint(10) NOT NULL AUTO_INCREMENT,
  `fblnglobalsearchdataisdirty` int(5) NOT NULL DEFAULT '-1',
  `fcurprocessnumber` decimal(19,4) NOT NULL DEFAULT '0.0000',
  `fblnfield01` int(5) NOT NULL DEFAULT '0',
  `fblnfield02` int(5) NOT NULL DEFAULT '0',
  `fblnfield03` int(5) NOT NULL DEFAULT '0',
  `fblnfield04` int(5) NOT NULL DEFAULT '0',
  `fblnfield05` int(5) NOT NULL DEFAULT '0',
  `fblnfield06` int(5) NOT NULL DEFAULT '0',
  `fblnfield07` int(5) NOT NULL DEFAULT '0',
  `fblnfield08` int(5) NOT NULL DEFAULT '0',
  `fblnfield09` int(5) NOT NULL DEFAULT '0',
  `fblnfield10` int(5) NOT NULL DEFAULT '0',
  `flngfield01` bigint(10) NOT NULL DEFAULT '0',
  `flngfield02` bigint(10) NOT NULL DEFAULT '0',
  `flngfield03` bigint(10) NOT NULL DEFAULT '0',
  `flngfield04` bigint(10) NOT NULL DEFAULT '0',
  `flngfield05` bigint(10) NOT NULL DEFAULT '0',
  `fcurfield01` decimal(19,4) NOT NULL DEFAULT '0.0000',
  `fcurfield02` decimal(19,4) NOT NULL DEFAULT '0.0000',
  `fcurfield03` decimal(19,4) NOT NULL DEFAULT '0.0000',
  `fcurfield04` decimal(19,4) NOT NULL DEFAULT '0.0000',
  `fcurfield05` decimal(19,4) NOT NULL DEFAULT '0.0000',
  `fstrfield01` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NU
LL,
  `fstrfield02` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NU
LL,
  `fstrfield03` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NU
LL,
  `fstrfield04` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NU
LL,
  `fstrfield05` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NU
LL,
  `fstrfield06` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NU
LL,
  `fstrfield07` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NU
LL,
  `fstrfield08` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NU
LL,
  `fstrfield09` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NU
LL,
  `fstrfield10` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NU
LL,
  `fdatfield01` char(14) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `fdatfield02` char(14) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `fdatfield03` char(14) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `fdatfield04` char(14) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `fdatfield05` char(14) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `fstrfield11` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NU
LL,
  `fstrfield12` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NU
LL,
  `fstrfield13` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NU
LL,
  `fstrfield14` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NU
LL,
  `fstrfield15` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NU
LL,
  `fdatfield06` char(14) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `fdatfield07` char(14) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `fdatfield08` char(14) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `fdatfield09` char(14) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `fdatfield10` char(14) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
  `fdatrecordcreateddatetime` varchar(14) CHARACTER SET latin1 COLLATE latin1_bi
n DEFAULT NULL,
  PRIMARY KEY (`flngSessionWork02Id`),
  UNIQUE KEY `p_flngsessionwork02id` (`flngSessionWork02Id`),
  KEY `i_sessionwork02_flngfield01` (`flngfield01`),
  KEY `i_sessionwork02_flngfield02` (`flngfield02`),
  KEY `i_sessionwork02_flngfield03` (`flngfield03`),
  KEY `i_sessionwork02_flngfield04` (`flngfield04`),
  KEY `i_sessionwork02_flngfield05` (`flngfield05`),
  KEY `i_sessionwork02_process_number` (`fcurprocessnumber`),
  KEY `I_sw2_process_number` (`fcurprocessnumber`)
) ENGINE=InnoDB AUTO_INCREMENT=91681173 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
/*!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-05-19 19:51:03

D:\dump>