-- MySQL dump 10.11
--
-- Host: 178.1.0.202    Database: analisabahan
-- ------------------------------------------------------
-- Server version	4.1.20-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: `analisabahan`
--

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

USE `analisabahan`;

--
-- Table structure for table `LogHapus`
--

DROP TABLE IF EXISTS `LogHapus`;
CREATE TABLE `LogHapus` (
  `UserIdHapus` varchar(20) NOT NULL default '',
  `DocNoDele` varchar(50) NOT NULL default '',
  `DocNameDele` varchar(100) NOT NULL default '',
  `DateHapus` datetime NOT NULL default '0000-00-00 00:00:00',
  `TableName` longtext NOT NULL,
  PRIMARY KEY  (`DocNoDele`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `LogHapus`
--

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

--
-- Table structure for table `NCheck`
--

DROP TABLE IF EXISTS `NCheck`;
CREATE TABLE `NCheck` (
  `CheckCode` char(1) NOT NULL default '',
  `ChekName` varchar(5) NOT NULL default '',
  `UserIdEntry` varchar(20) NOT NULL default '',
  `DateEntry` datetime NOT NULL default '0000-00-00 00:00:00',
  `UserIdEdit` varchar(20) NOT NULL default '',
  `DateEdit` datetime NOT NULL default '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `NCheck`
--

LOCK TABLES `NCheck` WRITE;
/*!40000 ALTER TABLE `NCheck` DISABLE KEYS */;
INSERT INTO `NCheck` VALUES ('1','Ya','','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('2','Tidak','','0000-00-00 00:00:00','','0000-00-00 00:00:00');
/*!40000 ALTER TABLE `NCheck` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `NCi`
--

DROP TABLE IF EXISTS `NCi`;
CREATE TABLE `NCi` (
  `CiNo` varchar(50) NOT NULL default '',
  `CiName` varchar(100) NOT NULL default '',
  `InnName` varchar(50) default NULL,
  `PhEurName` varchar(50) default NULL,
  `CasNo` varchar(50) default NULL,
  `EinecsNo` varchar(50) default NULL,
  `ChemIupacName` varchar(50) default NULL,
  `Restriction` varchar(50) default NULL,
  `Fungsi` varchar(100) default NULL,
  `Description` varchar(100) default NULL,
  `UserIdEntry` varchar(20) NOT NULL default '',
  `DateEntry` datetime NOT NULL default '0000-00-00 00:00:00',
  `UserIdEdit` varchar(20) NOT NULL default '',
  `DateEdit` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`CiNo`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `NCi`
--

LOCK TABLES `NCi` WRITE;
/*!40000 ALTER TABLE `NCi` DISABLE KEYS */;
INSERT INTO `NCi` VALUES ('aa','aa','aa','aa','aa','aa','aaa','aaa','aa','aaa bb ok','Tuti Ida Halida','2008-09-02 00:00:00','Tuti Ida Halida','2008-09-02 00:00:00');
/*!40000 ALTER TABLE `NCi` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `NCity`
--

DROP TABLE IF EXISTS `NCity`;
CREATE TABLE `NCity` (
  `cityCode` char(3) NOT NULL default '',
  `cityName` varchar(100) NOT NULL default '',
  `UserIdEntry` varchar(20) NOT NULL default '',
  `DateEntry` datetime NOT NULL default '0000-00-00 00:00:00',
  `UserIdEdit` varchar(20) NOT NULL default '',
  `DateEdit` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`cityCode`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `NCity`
--

LOCK TABLES `NCity` WRITE;
/*!40000 ALTER TABLE `NCity` DISABLE KEYS */;
INSERT INTO `NCity` VALUES ('JKT','Jakarta','','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('MDN','Medan','','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('PLB','Palembang','','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('SBY','Surabaya','','0000-00-00 00:00:00','','0000-00-00 00:00:00');
/*!40000 ALTER TABLE `NCity` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `NDocument`
--

DROP TABLE IF EXISTS `NDocument`;
CREATE TABLE `NDocument` (
  `DocCode` char(2) NOT NULL default '',
  `DocName` varchar(100) NOT NULL default '',
  `UserIdEntry` varchar(20) NOT NULL default '',
  `DateEntry` datetime NOT NULL default '0000-00-00 00:00:00',
  `UserIdEdit` varchar(20) NOT NULL default '',
  `DateEdit` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`DocCode`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `NDocument`
--

LOCK TABLES `NDocument` WRITE;
/*!40000 ALTER TABLE `NDocument` DISABLE KEYS */;
INSERT INTO `NDocument` VALUES ('aa','tuti Ida h','Tuti Ida Halida','2008-09-02 00:00:00','Tuti Ida Halida','2008-09-04 00:00:00'),('01','CA','','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('02','MSDS','','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('03','TOKSIKOLOGI','','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('04','PRODUCT KNOWLEDGE','','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('05','IFRA CERTIFICATE','','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('06','LITERATUR','','0000-00-00 00:00:00','','0000-00-00 00:00:00');
/*!40000 ALTER TABLE `NDocument` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `NFBBaku`
--

DROP TABLE IF EXISTS `NFBBaku`;
CREATE TABLE `NFBBaku` (
  `Revisi` varchar(50) NOT NULL default '',
  `RevisiDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `TglBerlaku` datetime default NULL,
  `InciName` varchar(50) default NULL,
  `CasNo` varchar(50) default NULL,
  `EinecsNo` varchar(50) default NULL,
  `Description` longtext,
  `FppNo` varchar(20) NOT NULL default '',
  `UserIdEntry` varchar(20) NOT NULL default '',
  `DateEntry` datetime NOT NULL default '0000-00-00 00:00:00',
  `UserIdEdit` varchar(20) NOT NULL default '',
  `DateEdit` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`Revisi`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `NFBBaku`
--

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

--
-- Table structure for table `NInci`
--

DROP TABLE IF EXISTS `NInci`;
CREATE TABLE `NInci` (
  `InciCode` varchar(20) NOT NULL default '',
  `InciName` varchar(50) default NULL,
  `InnName` varchar(100) default NULL,
  `PhEurName` varchar(100) default NULL,
  `CasNo` varchar(50) default NULL,
  `EinecsNo` varchar(50) default NULL,
  `ChemIupacName` varchar(50) default NULL,
  `Restriction` varchar(50) default NULL,
  `Fungsi` varchar(100) default NULL,
  `Description` varchar(100) default NULL,
  `UserIdEntry` varchar(20) NOT NULL default '',
  `DateEntry` datetime NOT NULL default '0000-00-00 00:00:00',
  `UserIdEdit` varchar(20) NOT NULL default '',
  `DateEdit` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`InciCode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `NInci`
--

LOCK TABLES `NInci` WRITE;
/*!40000 ALTER TABLE `NInci` DISABLE KEYS */;
INSERT INTO `NInci` VALUES ('aa1','aaaaaaaaaa','aaa','aa','aa','aa','aa','aa','aa','aa ok','Tuti Ida Halida','2008-09-02 00:00:00','Tuti Ida Halida','2008-09-02 00:00:00');
/*!40000 ALTER TABLE `NInci` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `NMnf`
--

DROP TABLE IF EXISTS `NMnf`;
CREATE TABLE `NMnf` (
  `mnfCode` varchar(15) NOT NULL default '',
  `mnfName` varchar(100) NOT NULL default '',
  `notes` varchar(100) NOT NULL default '',
  `balance` double(19,6) NOT NULL default '0.000000',
  `dNotesBal` double(19,6) default '0.000000',
  `ordersBal` double(19,6) NOT NULL default '0.000000',
  `goodsissuesBal` double(19,6) default '0.000000',
  `credLimit` double(19,6) NOT NULL default '0.000000',
  `slPrsnCode` char(2) NOT NULL default '',
  `clctrCode` char(2) NOT NULL default '',
  `termCode` char(3) NOT NULL default '',
  `discCode` char(1) NOT NULL default '',
  `whsCode` varchar(8) NOT NULL default '',
  `locked` char(1) NOT NULL default 'N',
  `priceCode` varchar(8) NOT NULL default '',
  `objType` smallint(6) NOT NULL default '13',
  `regDate` date NOT NULL default '0000-00-00',
  `taxInSameMonth` char(1) NOT NULL default 'N',
  `incTax` char(1) NOT NULL default 'N',
  `grpOltTypeCode` char(2) NOT NULL default '',
  `bpCustId` varchar(10) NOT NULL default '',
  `pkpSts` char(1) NOT NULL default 'N',
  `auditDate` timestamp NOT NULL default '0000-00-00 00:00:00',
  `auditUser` varchar(8) NOT NULL default '',
  `backupSts` char(1) NOT NULL default 'N',
  `mnfcodeprn` varchar(15) default NULL,
  `salessts` char(1) default 'Y',
  PRIMARY KEY  (`mnfCode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `NMnf`
--

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

--
-- Table structure for table `NMnfoptinfo`
--

DROP TABLE IF EXISTS `NMnfoptinfo`;
CREATE TABLE `NMnfoptinfo` (
  `optionalCode` varchar(10) NOT NULL default '',
  `optDtlCode` varchar(10) NOT NULL default '',
  `objType` smallint(2) NOT NULL default '0',
  `dscription` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`optionalCode`,`optDtlCode`,`objType`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `NMnfoptinfo`
--

LOCK TABLES `NMnfoptinfo` WRITE;
/*!40000 ALTER TABLE `NMnfoptinfo` DISABLE KEYS */;
INSERT INTO `NMnfoptinfo` VALUES ('50','01',0,'KIMIA'),('50','02',0,'NABATI'),('51','01',0,'WADAH LIQUID'),('51','02',0,'WADAH DRY'),('51','03',0,'CETAK LIQUID'),('51','04',0,'CETAK DRY');
/*!40000 ALTER TABLE `NMnfoptinfo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `NMnfoptsett`
--

DROP TABLE IF EXISTS `NMnfoptsett`;
CREATE TABLE `NMnfoptsett` (
  `optionalCode` varchar(10) NOT NULL default '',
  `dscription` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`optionalCode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `NMnfoptsett`
--

LOCK TABLES `NMnfoptsett` WRITE;
/*!40000 ALTER TABLE `NMnfoptsett` DISABLE KEYS */;
INSERT INTO `NMnfoptsett` VALUES ('50','BAHAN BAKU'),('51','BAHAN KEMAS');
/*!40000 ALTER TABLE `NMnfoptsett` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `NMnfoptsettdetail1`
--

DROP TABLE IF EXISTS `NMnfoptsettdetail1`;
CREATE TABLE `NMnfoptsettdetail1` (
  `optionalCode` char(10) NOT NULL default '',
  `ownerCode` char(20) NOT NULL default '',
  `objType` smallint(2) NOT NULL default '0',
  `optDtlCode` char(10) NOT NULL default '',
  PRIMARY KEY  (`optionalCode`,`ownerCode`,`objType`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `NMnfoptsettdetail1`
--

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

--
-- Table structure for table `NRegulasi`
--

DROP TABLE IF EXISTS `NRegulasi`;
CREATE TABLE `NRegulasi` (
  `RegCode` varchar(10) NOT NULL default '',
  `RegName` longtext NOT NULL,
  `UserIdEntry` varchar(20) NOT NULL default '',
  `DateEntry` datetime NOT NULL default '0000-00-00 00:00:00',
  `UserIdEdit` varchar(20) NOT NULL default '',
  `DateEdit` datetime NOT NULL default '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `NRegulasi`
--

LOCK TABLES `NRegulasi` WRITE;
/*!40000 ALTER TABLE `NRegulasi` DISABLE KEYS */;
INSERT INTO `NRegulasi` VALUES ('aa1','aaa1ok','Tuti Ida Halida','2008-09-03 00:00:00','Tuti Ida Halida','2008-09-10 00:00:00');
/*!40000 ALTER TABLE `NRegulasi` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `NStabilitas`
--

DROP TABLE IF EXISTS `NStabilitas`;
CREATE TABLE `NStabilitas` (
  `StabilitasCode` char(2) NOT NULL default '',
  `Description` varchar(100) default NULL,
  PRIMARY KEY  (`StabilitasCode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `NStabilitas`
--

LOCK TABLES `NStabilitas` WRITE;
/*!40000 ALTER TABLE `NStabilitas` DISABLE KEYS */;
INSERT INTO `NStabilitas` VALUES ('01','Horoskopis'),('02','Warna'),('03','Terdegradasi'),('04','Menguap'),('05','Terkontaminasi');
/*!40000 ALTER TABLE `NStabilitas` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `NState`
--

DROP TABLE IF EXISTS `NState`;
CREATE TABLE `NState` (
  `stateCode` varchar(5) NOT NULL default '',
  `stateName` varchar(100) NOT NULL default '',
  `UserIdEntry` varchar(20) NOT NULL default '',
  `DateEntry` datetime NOT NULL default '0000-00-00 00:00:00',
  `UserIdEdit` varchar(20) NOT NULL default '',
  `DateEdit` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`stateCode`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `NState`
--

LOCK TABLES `NState` WRITE;
/*!40000 ALTER TABLE `NState` DISABLE KEYS */;
INSERT INTO `NState` VALUES ('INA','INDONESIA','','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('MYS','MALAYSIA','','0000-00-00 00:00:00','','0000-00-00 00:00:00');
/*!40000 ALTER TABLE `NState` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `NToksin`
--

DROP TABLE IF EXISTS `NToksin`;
CREATE TABLE `NToksin` (
  `ToksinCode` char(2) NOT NULL default '',
  `ToksinName` varchar(100) default NULL,
  `UserIdEntry` varchar(20) NOT NULL default '',
  `DateEntry` datetime NOT NULL default '0000-00-00 00:00:00',
  `UserIdEdit` varchar(20) NOT NULL default '',
  `DateEdit` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`ToksinCode`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `NToksin`
--

LOCK TABLES `NToksin` WRITE;
/*!40000 ALTER TABLE `NToksin` DISABLE KEYS */;
INSERT INTO `NToksin` VALUES ('01','NOEL','','0000-00-00 00:00:00','Tuti Ida Halida','2008-09-03 00:00:00'),('02','LD50 ORAL DERMAL','','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('03','LC 50 INHALASI','','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('04','IRITASI KULIT/MATA','','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('05','SENSITISASI','','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('06','DATA KLINIS','','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('07','TOKSISITAS CRON','','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('99','LAIN-LAIN','','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('09','NOEL + LC50 INHALASI','','0000-00-00 00:00:00','','0000-00-00 00:00:00');
/*!40000 ALTER TABLE `NToksin` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `TAreaAplikasi`
--

DROP TABLE IF EXISTS `TAreaAplikasi`;
CREATE TABLE `TAreaAplikasi` (
  `FppNo` varchar(15) NOT NULL default '',
  `optionalCode` varchar(10) NOT NULL default '',
  `optDtlCode` varchar(10) NOT NULL default '',
  `UserIdEntry` varchar(20) NOT NULL default '',
  `DateEntry` datetime NOT NULL default '0000-00-00 00:00:00',
  `UserIdEdit` varchar(20) NOT NULL default '',
  `DateEdit` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`FppNo`,`optionalCode`,`optDtlCode`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `TAreaAplikasi`
--

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

--
-- Table structure for table `TCompany`
--

DROP TABLE IF EXISTS `TCompany`;
CREATE TABLE `TCompany` (
  `FppNo` varchar(15) NOT NULL default '',
  `optionalCode` varchar(10) NOT NULL default '',
  `optDtlCode` varchar(10) NOT NULL default '',
  `UserIdEntry` varchar(20) NOT NULL default '',
  `DateEntry` datetime NOT NULL default '0000-00-00 00:00:00',
  `UserIdEdit` varchar(20) NOT NULL default '',
  `DateEdit` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`FppNo`,`optDtlCode`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `TCompany`
--

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

--
-- Table structure for table `TDocument`
--

DROP TABLE IF EXISTS `TDocument`;
CREATE TABLE `TDocument` (
  `FppNo` varchar(15) NOT NULL default '',
  `DocCode` char(2) NOT NULL default '',
  `UserIdEntry` varchar(20) NOT NULL default '',
  `DateEntry` datetime NOT NULL default '0000-00-00 00:00:00',
  `UserIdEdit` varchar(20) NOT NULL default '',
  `DateEdit` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`FppNo`,`DocCode`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `TDocument`
--

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

--
-- Table structure for table `TFppAnalisa`
--

DROP TABLE IF EXISTS `TFppAnalisa`;
CREATE TABLE `TFppAnalisa` (
  `FppDate` datetime default NULL,
  `FppNo` varchar(15) NOT NULL default '',
  `DeliveryDate` datetime default '0000-00-00 00:00:00',
  `itemcode` varchar(25) default '0',
  `suppCode` varchar(15) default NULL,
  `custmrCode` varchar(15) default NULL,
  `TypeCode` char(2) default NULL,
  `UmurSimpan` varchar(100) default NULL,
  `CaraSimpan` longtext,
  `Pustaka` longtext,
  `Sensitifitas` varchar(50) default NULL,
  `Stabilitas` varchar(50) default NULL,
  `Pembanding` longtext,
  `BatchNo` varchar(20) default NULL,
  `ReasonField` longtext,
  `ChemDangerous` varchar(100) default NULL,
  `RSPhrase` varchar(100) default NULL,
  `Note` longtext,
  `ref1` varchar(100) NOT NULL default '',
  `ref2` varchar(100) NOT NULL default '',
  `comments` varchar(100) NOT NULL default '',
  `StatusFpp` char(1) default NULL,
  `Kesimpulan` char(1) NOT NULL default '',
  `RcvDate` varchar(20) default NULL,
  `AnalisaNo` varchar(20) default NULL,
  `AnalisaDate` varchar(10) default NULL,
  `StdNo` varchar(20) NOT NULL default '',
  `StdDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `UserIdEntry` varchar(20) default NULL,
  `DateEntry` datetime default '0000-00-00 00:00:00',
  `UserIdEdit` varchar(20) default NULL,
  `DateEdit` datetime default '0000-00-00 00:00:00',
  `FPRMGRFPP` char(1) default NULL,
  `FPRMGRFPPDate` datetime default '0000-00-00 00:00:00',
  `RESEMGRFPP` char(1) default NULL,
  `RESEMGRFPPDate` datetime default '0000-00-00 00:00:00',
  `RMSTDSPCFPP` char(1) default NULL,
  `RMSTDSPCFPPDate` datetime default '0000-00-00 00:00:00',
  `RMAPPFPP` char(1) default NULL,
  `RMAPPFPPDate` datetime default '0000-00-00 00:00:00',
  `ASSSTDMGR` char(1) default NULL,
  `ASSSTDMGRDate` datetime default '0000-00-00 00:00:00',
  `STDMGR` char(1) default NULL,
  `STDMGRDate` datetime default '0000-00-00 00:00:00',
  `RMSTDSPC` char(1) default NULL,
  `RMSTDSPCDate` datetime default '0000-00-00 00:00:00',
  `RESEMGR` char(1) default NULL,
  `RESEMGRDate` datetime default '0000-00-00 00:00:00',
  `QAQCMGR` char(1) NOT NULL default '',
  `QAQCMGRDate` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`FppNo`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `TFppAnalisa`
--

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

--
-- Table structure for table `TFunction`
--

DROP TABLE IF EXISTS `TFunction`;
CREATE TABLE `TFunction` (
  `FppNo` varchar(15) NOT NULL default '',
  `optionalCode` varchar(10) NOT NULL default '',
  `optDtlCode` varchar(10) NOT NULL default '',
  `UserIdEntry` varchar(20) NOT NULL default '',
  `DateEntry` datetime NOT NULL default '0000-00-00 00:00:00',
  `UserIdEdit` varchar(20) NOT NULL default '',
  `DateEdit` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`FppNo`,`optionalCode`,`optDtlCode`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `TFunction`
--

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

--
-- Table structure for table `TJenisBahan`
--

DROP TABLE IF EXISTS `TJenisBahan`;
CREATE TABLE `TJenisBahan` (
  `FppNo` varchar(15) NOT NULL default '',
  `optionalCode` varchar(10) NOT NULL default '',
  `optDtlCode` varchar(10) NOT NULL default '',
  `UserIdEntry` varchar(20) NOT NULL default '',
  `DateEntry` datetime NOT NULL default '0000-00-00 00:00:00',
  `UserIdEdit` varchar(20) NOT NULL default '',
  `DateEdit` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`FppNo`,`optionalCode`,`optDtlCode`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `TJenisBahan`
--

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

--
-- Table structure for table `TObservation`
--

DROP TABLE IF EXISTS `TObservation`;
CREATE TABLE `TObservation` (
  `LinNo` int(11) NOT NULL auto_increment,
  `FppNo` varchar(15) NOT NULL default '',
  `AnalisaNo` varchar(20) NOT NULL default '',
  `MethodeCode` varchar(20) NOT NULL default '',
  `Specification` varchar(100) NOT NULL default '',
  `ObservResult` longtext NOT NULL,
  `UserIdEntry` varchar(20) NOT NULL default '',
  `DateEntry` datetime NOT NULL default '0000-00-00 00:00:00',
  `UserIdEdit` varchar(20) NOT NULL default '',
  `DateEdit` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`LinNo`,`FppNo`,`AnalisaNo`,`MethodeCode`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `TObservation`
--

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

--
-- Table structure for table `TRegulasi`
--

DROP TABLE IF EXISTS `TRegulasi`;
CREATE TABLE `TRegulasi` (
  `FppNo` varchar(20) NOT NULL default '',
  `RegCode` varchar(20) NOT NULL default '',
  `UserIdEntry` varchar(20) NOT NULL default '',
  `DateEntry` datetime NOT NULL default '0000-00-00 00:00:00',
  `UserIdEdit` varchar(20) NOT NULL default '',
  `DateEdit` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`FppNo`,`RegCode`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `TRegulasi`
--

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

--
-- Table structure for table `TSediaan`
--

DROP TABLE IF EXISTS `TSediaan`;
CREATE TABLE `TSediaan` (
  `FppNo` varchar(15) NOT NULL default '',
  `optionalCode` varchar(10) NOT NULL default '',
  `optDtlCode` varchar(10) NOT NULL default '',
  `UserIdEntry` varchar(20) NOT NULL default '',
  `DateEntry` datetime NOT NULL default '0000-00-00 00:00:00',
  `UserIdEdit` varchar(20) NOT NULL default '',
  `DateEdit` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`FppNo`,`optDtlCode`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `TSediaan`
--

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

--
-- Table structure for table `TSubJnsBahan`
--

DROP TABLE IF EXISTS `TSubJnsBahan`;
CREATE TABLE `TSubJnsBahan` (
  `FppNo` varchar(15) NOT NULL default '',
  `optionalCode` varchar(10) NOT NULL default '',
  `optDtlCode` varchar(10) NOT NULL default '',
  `UserIdEntry` varchar(20) NOT NULL default '',
  `DateEntry` datetime NOT NULL default '0000-00-00 00:00:00',
  `UserIdEdit` varchar(20) NOT NULL default '',
  `DateEdit` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`FppNo`,`optionalCode`,`optDtlCode`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `TSubJnsBahan`
--

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

--
-- Table structure for table `TSumberBahan`
--

DROP TABLE IF EXISTS `TSumberBahan`;
CREATE TABLE `TSumberBahan` (
  `FppNo` varchar(20) NOT NULL default '',
  `optionalCode` varchar(10) NOT NULL default '',
  `optDtlCode` varchar(10) NOT NULL default '',
  `UserIdEntry` varchar(20) NOT NULL default '',
  `DateEntry` datetime NOT NULL default '0000-00-00 00:00:00',
  `UserIdEdit` varchar(20) NOT NULL default '',
  `DateEdit` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`FppNo`,`optionalCode`,`optDtlCode`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `TSumberBahan`
--

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

--
-- Table structure for table `TTechData`
--

DROP TABLE IF EXISTS `TTechData`;
CREATE TABLE `TTechData` (
  `LinNo` int(11) NOT NULL auto_increment,
  `FppNo` varchar(15) NOT NULL default '',
  `AnalisaNo` varchar(20) NOT NULL default '',
  `MethodeCode` varchar(20) NOT NULL default '',
  `Specification` varchar(100) NOT NULL default '',
  `FactorSupp` varchar(100) NOT NULL default '0',
  `InternalReff` decimal(10,0) NOT NULL default '0',
  `Analysa1` decimal(10,0) NOT NULL default '0',
  `Analysa2` decimal(10,0) NOT NULL default '0',
  `Analysa3` decimal(10,0) NOT NULL default '0',
  `Standard` varchar(100) NOT NULL default '0',
  `Unit` varchar(20) NOT NULL default '',
  `UserIdEntry` varchar(20) NOT NULL default '',
  `DateEntry` datetime NOT NULL default '0000-00-00 00:00:00',
  `UserIdEdit` varchar(20) NOT NULL default '',
  `DateEdit` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`LinNo`,`FppNo`,`AnalisaNo`,`MethodeCode`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `TTechData`
--

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

--
-- Table structure for table `TToksin`
--

DROP TABLE IF EXISTS `TToksin`;
CREATE TABLE `TToksin` (
  `FppNo` varchar(20) NOT NULL default '',
  `ToksinCode` varchar(20) NOT NULL default '',
  `UserIdEntry` varchar(20) NOT NULL default '',
  `DateEntry` datetime NOT NULL default '0000-00-00 00:00:00',
  `UserIdEdit` varchar(20) NOT NULL default '',
  `DateEdit` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`FppNo`,`ToksinCode`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `TToksin`
--

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

--
-- Table structure for table `TType`
--

DROP TABLE IF EXISTS `TType`;
CREATE TABLE `TType` (
  `FppNo` varchar(15) NOT NULL default '',
  `optionalCode` varchar(10) NOT NULL default '',
  `optDtlCode` varchar(10) NOT NULL default '',
  `UserIdEntry` varchar(20) NOT NULL default '',
  `DateEntry` datetime NOT NULL default '0000-00-00 00:00:00',
  `UserIdEdit` varchar(20) NOT NULL default '',
  `DateEdit` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`FppNo`,`optionalCode`,`optDtlCode`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `TType`
--

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

--
-- Table structure for table `UserApprove`
--

DROP TABLE IF EXISTS `UserApprove`;
CREATE TABLE `UserApprove` (
  `idapprove` int(15) NOT NULL auto_increment,
  `userid` varchar(50) NOT NULL default '',
  `Kode` varchar(255) NOT NULL default '',
  `atasanid` int(10) NOT NULL default '0',
  `atasan` varchar(50) NOT NULL default '',
  `atasanname` varchar(50) NOT NULL default '',
  `descgol` varchar(50) NOT NULL default '',
  `minapprove` double NOT NULL default '0',
  `maxapprove` double NOT NULL default '0',
  `default1` int(11) NOT NULL default '0',
  `adminku` varchar(50) NOT NULL default '',
  `flagppbsr` int(11) NOT NULL default '0',
  `flagxcc` int(11) NOT NULL default '0',
  PRIMARY KEY  (`idapprove`),
  KEY `idapprove` (`idapprove`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `UserApprove`
--

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

--
-- Table structure for table `address`
--

DROP TABLE IF EXISTS `address`;
CREATE TABLE `address` (
  `ownerCode` varchar(15) NOT NULL default '',
  `addrCode` varchar(10) NOT NULL default '000',
  `addrTypeCode` varchar(10) NOT NULL default '00',
  `dscription` varchar(255) NOT NULL default '',
  `address` varchar(255) NOT NULL default '',
  `city` varchar(100) NOT NULL default '',
  `state` varchar(100) NOT NULL default '',
  `zipcode` varchar(5) NOT NULL default '',
  `cntctPrsn` varchar(100) NOT NULL default '',
  `BpCustld` varchar(15) NOT NULL default '',
  `objType` smallint(6) NOT NULL default '0',
  `UserEntry` varchar(20) NOT NULL default '',
  `DateEntry` datetime NOT NULL default '0000-00-00 00:00:00',
  `UserEdit` varchar(20) NOT NULL default '',
  `DateEdit` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`ownerCode`,`addrCode`,`addrTypeCode`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `address`
--

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

--
-- Table structure for table `addrtype`
--

DROP TABLE IF EXISTS `addrtype`;
CREATE TABLE `addrtype` (
  `addrTypeCode` varchar(10) NOT NULL default '00',
  `dscription` varchar(50) NOT NULL default '',
  `objType` char(2) NOT NULL default '',
  `backupSts` char(1) NOT NULL default '',
  `UserEntry` varchar(20) NOT NULL default '',
  `DateEntry` datetime NOT NULL default '0000-00-00 00:00:00',
  `UserEdit` varchar(20) NOT NULL default '',
  `DateEdit` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`addrTypeCode`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `addrtype`
--

LOCK TABLES `addrtype` WRITE;
/*!40000 ALTER TABLE `addrtype` DISABLE KEYS */;
INSERT INTO `addrtype` VALUES ('01','Alamat Tagihan','','','','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('02','Alamat pengiriman','','','','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('03','Alamat Supplier','','','','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('04','Alamat NPWP','','','','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('05','Alamat Penjual','','','','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('06','Alamat Kolektor','','','','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('07','Alamat Bank','','','','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('08','Alamat Lokasi Gudang','','','','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('00','Alamat','','','','0000-00-00 00:00:00','','0000-00-00 00:00:00');
/*!40000 ALTER TABLE `addrtype` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `employee`
--

DROP TABLE IF EXISTS `employee`;
CREATE TABLE `employee` (
  `EmplCode` varchar(8) NOT NULL default '',
  `EmplName` varchar(100) NOT NULL default '',
  `Pass` varchar(50) NOT NULL default '',
  `address` varchar(254) default NULL,
  `City` varchar(100) default NULL,
  `State` varchar(100) default NULL,
  `ZipCode` varchar(8) default NULL,
  `Phone1` varchar(20) default NULL,
  `Phone2` varchar(20) default NULL,
  `Fax` varchar(20) default NULL,
  `Email` varchar(50) default NULL,
  `Locked` char(1) NOT NULL default '',
  `ObjType` smallint(6) NOT NULL default '0',
  `AuditDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `AuditUser` varchar(8) NOT NULL default '',
  `Admin` char(1) NOT NULL default '',
  PRIMARY KEY  (`EmplCode`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `employee`
--

LOCK TABLES `employee` WRITE;
/*!40000 ALTER TABLE `employee` DISABLE KEYS */;
INSERT INTO `employee` VALUES ('tihalida','Tuti Ida Halida','ef883ab311ab13c37d771e3305f9e2dc','Cibubur','JKT','INA','','','','','','N',2,'2005-11-18 17:12:06','admin','Y'),('nadya','nadya qanita','ef883ab311ab13c37d771e3305f9e2dc','Cipinang','JKT','INA','13418','11111','22222','77777','nadya_q@yahoo.co.id','N',2,'2008-09-01 00:00:00','admin','Y'),('345345','Willy','','Kebayoran Lama','JKT','INA','12220','021-345345','','','blabla@yahoo.com','N',2,'2008-09-10 00:00:00','admin','Y');
/*!40000 ALTER TABLE `employee` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `item`
--

DROP TABLE IF EXISTS `item`;
CREATE TABLE `item` (
  `MbCode` varchar(25) default NULL,
  `CdfCode` varchar(20) default NULL,
  `CbiCode` varchar(20) default NULL,
  `itemCode` varchar(25) NOT NULL default '',
  `dscription` varchar(100) NOT NULL default '',
  `LatinName` varchar(100) NOT NULL default '',
  `SinonimName` longtext,
  `UomName` varchar(20) default NULL,
  `Gambar` longtext NOT NULL,
  `UserIdEntry` varchar(20) NOT NULL default '',
  `DateEntry` datetime NOT NULL default '0000-00-00 00:00:00',
  `UserIdEdit` varchar(20) NOT NULL default '',
  `DateEdit` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`itemCode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `item`
--

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

--
-- Table structure for table `itemoptdetail1`
--

DROP TABLE IF EXISTS `itemoptdetail1`;
CREATE TABLE `itemoptdetail1` (
  `optionalCode` varchar(10) NOT NULL default '',
  `optDtlCode` varchar(10) NOT NULL default '',
  `ownerCode` varchar(25) NOT NULL default '',
  `objType` smallint(2) NOT NULL default '0',
  `UserEntry` varchar(20) NOT NULL default '',
  `DateEntry` datetime NOT NULL default '0000-00-00 00:00:00',
  `UserEdit` varchar(20) NOT NULL default '',
  `DataEdit` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`optionalCode`,`optDtlCode`,`ownerCode`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `itemoptdetail1`
--

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

--
-- Table structure for table `itemoptionalinfo`
--

DROP TABLE IF EXISTS `itemoptionalinfo`;
CREATE TABLE `itemoptionalinfo` (
  `optionalCode` varchar(10) NOT NULL default '',
  `optDtlCode` varchar(10) NOT NULL default '',
  `objType` smallint(2) NOT NULL default '0',
  `dscription` varchar(50) NOT NULL default '',
  `priority` smallint(6) NOT NULL default '0',
  `UserEntry` varchar(20) NOT NULL default '',
  `DateEntry` datetime NOT NULL default '0000-00-00 00:00:00',
  `UserEdit` varchar(20) NOT NULL default '',
  `DateEdit` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`optionalCode`,`optDtlCode`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `itemoptionalinfo`
--

LOCK TABLES `itemoptionalinfo` WRITE;
/*!40000 ALTER TABLE `itemoptionalinfo` DISABLE KEYS */;
INSERT INTO `itemoptionalinfo` VALUES ('11','01',3,'BARU',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('11','02',3,'ALTERNATIF',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('11','03',3,'SUBTITUSI',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('12','01',3,'KEMASAN LO',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('12','02',3,'KEMASAN FA',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('12','03',3,'KEMASAN FILM',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('12','04',3,'KEMASAN BLUEPRINT',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('12','05',3,'NATURAL BERSIH',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('13','000',3,'LAIN-LAIN',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('13','001',3,'MINYAK NABATI',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('13','002',3,'EKSTRAK',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('13','003',3,'MINYAK ATSIRI',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('14','00',3,'LAIN-LAIN',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('14','01',3,'DRY',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('14','02',3,'LIQUID',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('15','000',3,'LAIN-LAIN',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('15','001',3,'ORAL',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('15','002',3,'MATA',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('15','003',3,'BIBIR',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('15','004',3,'MUKA',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('15','005',3,'BADAN',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('15','006',3,'RAMBUT',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('16','00',3,'LAIN-LAIN',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('16','01',3,'NABATI',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('16','02',3,'HEWANI',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('16','03',3,'BIOTEK',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('16','04',3,'KONVENSIONAL',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('17','014',3,'M3',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('17','013',3,'CFU/GR',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('18','000',3,'LAIN-LAIN',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('18','001',3,'SOLVENT',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('18','002',3,'GLOSSY/EFFECT',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('18','003',3,'BASE CREAM/LOTION',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('18','004',1,'COOLING AGENT',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('18','005',1,'CONDITIONER',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('18','006',3,'STABILISATOR',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('18','007',3,'HUMEKTAN',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('18','008',3,'SOLUBILIZER',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('18','009',3,'PASTISIZER',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('18','010',3,'SURFACTAN',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('18','011',3,'ANTI INFLAMASI',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('18','012',3,'ANTI OKSIDANT',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('18','013',3,'ANTI PERSSPIRANT',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('18','014',3,'STIMULANT',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('18','015',3,'ANTI WRINKLE',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('18','016',3,'Filler',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('18','017',3,'Suspending Agent',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('18','018',3,'Anti Septic',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('18','019',3,'Scrubbing Agent',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('18','020',3,'Sweetener',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('18','021',3,'Neutralising Agent',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('18','022',3,'Polymer (hairdener)',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('18','023',3,'Polymer (tightener)',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('18','024',3,'Base Lipstick',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('18','025',3,'Longlasting Effect',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('18','026',3,'Suncreen Agent',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('18','027',3,'Perfume',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('18','028',3,'Flavour',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('18','029',3,'Active Ingredient',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('18','030',3,'Anti Dundruff',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('12','06',3,'NATURAL KOTOR',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('12','07',3,'BULK',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('12','08',3,'KIMIA',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('17','012',3,'NM',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('17','011',3,'MESS',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('17','010',3,'Ph',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('17','009',3,'CENTIPOISE',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('17','008',3,'DEGREE',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('17','007',3,'PERCEN PER MILL',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('17','006',3,'PERCENT',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('17','005',3,'GRAM/MILI LITER',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('17','004',3,'LITER',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('17','003',3,'MILI LITER',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('17','002',3,'KILO GRAM',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('17','001',3,'GRAM',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('17','000',3,'LAIN-LAIN',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('19','02',3,'PT. CEDEFINDO',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('19','01',3,'PT. MARTINA BERTO',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('17','015',3,'KG/M3',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('','222',3,'2222',0,'Tuti Ida Halida','2008-09-09 00:00:00','NULL','0000-00-00 00:00:00'),('15','01',3,'AKTIF',0,'','0000-00-00 00:00:00','Tuti Ida Halida','2008-09-09 00:00:00'),('04','02',3,'NON AKTIF',0,'','0000-00-00 00:00:00','Tuti Ida Halida','2008-09-09 00:00:00'),('05','01',3,'PARETO',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('05','02',3,'NON PARETO',0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('','1111',3,'11111',0,'Tuti Ida Halida','2008-09-09 00:00:00','NULL','0000-00-00 00:00:00');
/*!40000 ALTER TABLE `itemoptionalinfo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `itemoptsett`
--

DROP TABLE IF EXISTS `itemoptsett`;
CREATE TABLE `itemoptsett` (
  `optionalCode` varchar(10) NOT NULL default '',
  `dscription` varchar(50) NOT NULL default '',
  `objType` smallint(2) NOT NULL default '0',
  `priority` smallint(6) NOT NULL default '0',
  `UserEntry` varchar(20) NOT NULL default '',
  `DateEntry` datetime NOT NULL default '0000-00-00 00:00:00',
  `UserEdit` varchar(20) NOT NULL default '',
  `DateEdit` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`optionalCode`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `itemoptsett`
--

LOCK TABLES `itemoptsett` WRITE;
/*!40000 ALTER TABLE `itemoptsett` DISABLE KEYS */;
INSERT INTO `itemoptsett` VALUES ('01','BRAND',2,0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('11','TYPE BAHAN',2,0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('12','JENIS BAHAN',2,0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('13','SUB JENIS BAHAN',2,0,'','0000-00-00 00:00:00','Tuti Ida Halida','2008-09-05 00:00:00'),('14','SEDIAAN PRODUK',2,0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('15','AREA APLIKASI',2,0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('16','SUMBER BAHAN',2,0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('17','UOM (SATUAN)',2,0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('18','FUNGSI',2,0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('19','COMPANY / PERUSAHAAN',2,0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('04','STATUS',2,0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('05','CLASS',2,0,'','0000-00-00 00:00:00','','0000-00-00 00:00:00');
/*!40000 ALTER TABLE `itemoptsett` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `nmethode`
--

DROP TABLE IF EXISTS `nmethode`;
CREATE TABLE `nmethode` (
  `MethodeCode` varchar(20) NOT NULL default '',
  `Specification` varchar(100) default NULL,
  `Alat` longtext,
  `Bahan` longtext,
  `Prosedur` longtext,
  `Literatur` longtext,
  `UserIdInsert` varchar(20) NOT NULL default '',
  `DateInsert` datetime NOT NULL default '0000-00-00 00:00:00',
  `UserIdEdit` varchar(20) NOT NULL default '',
  `DateEdit` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`MethodeCode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `nmethode`
--

LOCK TABLES `nmethode` WRITE;
/*!40000 ALTER TABLE `nmethode` DISABLE KEYS */;
INSERT INTO `nmethode` VALUES ('01','oppp','kk','kk','kk','kkaaaa','tihalida','2008-06-25 00:00:00','Tuti Ida Halida','2008-09-12 00:00:00'),('MAB.301.0','pH','','','','','','0000-00-00 00:00:00','Tuti Ida Halida','2008-10-07 00:00:00'),('MAB.302.0','Density / Bulk Density1',NULL,NULL,NULL,NULL,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('MAB.303.0','Refractive Index','ok','','','','','0000-00-00 00:00:00','Tuti Ida Halida','2008-09-02 00:00:00'),('MAB.304.0','Melting Point',NULL,NULL,NULL,NULL,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('MAB.305.0','Acid Value','ok','','','','','0000-00-00 00:00:00','Tuti Ida Halida','2008-09-01 00:00:00'),('MAB.306.0','Saponification Number',NULL,NULL,NULL,NULL,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('MAB.307.0','Iodine Number',NULL,NULL,NULL,NULL,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('MAB.308.0','Hydroxil Number',NULL,NULL,NULL,NULL,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('MAB.309.0','Ester Number',NULL,NULL,NULL,NULL,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('MAB.310.0','Chloride',NULL,NULL,NULL,NULL,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('MAB.311.0','Sulphate',NULL,NULL,NULL,NULL,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('MAB.312.0','Heavymetal',NULL,NULL,NULL,NULL,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('MAB.314.0','Lost on Drying',NULL,NULL,NULL,NULL,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('MAB.317.0','Assay - UV/Vis',NULL,NULL,NULL,NULL,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('MAB.318.0','Assay - Protolysis',NULL,NULL,NULL,NULL,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('MAB.319.0','Assay - Complexometri',NULL,NULL,NULL,NULL,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('MAB.320.0','Assay - Argentometri',NULL,NULL,NULL,NULL,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('MAB.322.0','Ash Content',NULL,NULL,NULL,NULL,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('MAB.323.0','Water Content - KF',NULL,NULL,NULL,NULL,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('MAB.324.0','Alcohol Content',NULL,NULL,NULL,NULL,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('MAB.325.0','Solubility in Water',NULL,NULL,NULL,NULL,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('MAB.401.0','Viscosity',NULL,NULL,NULL,NULL,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('MAB.402.0','Swelling Power',NULL,NULL,NULL,NULL,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('MAB.403.0','Color Intensity',NULL,NULL,NULL,NULL,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('MAB.404.0','Particel Size',NULL,NULL,NULL,NULL,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('MAB.405.0','Micro - B. Patogen',NULL,NULL,NULL,NULL,'','0000-00-00 00:00:00','','0000-00-00 00:00:00'),('MAB.406.0','Carbonized Content',NULL,NULL,NULL,NULL,'','0000-00-00 00:00:00','','0000-00-00 00:00:00');
/*!40000 ALTER TABLE `nmethode` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `phone`
--

DROP TABLE IF EXISTS `phone`;
CREATE TABLE `phone` (
  `ownerCode` varchar(15) NOT NULL default '',
  `addrCode` varchar(10) NOT NULL default '',
  `addrTypeCode` varchar(10) NOT NULL default '',
  `phoneTypeCode` char(2) NOT NULL default '',
  `phone` varchar(25) NOT NULL default '',
  `statecode` char(3) NOT NULL default '',
  `areacode` char(3) NOT NULL default '',
  `objType` smallint(6) NOT NULL default '0',
  `auditDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `auditUser` varchar(8) NOT NULL default '',
  `backSts` char(1) NOT NULL default '',
  PRIMARY KEY  (`ownerCode`,`addrCode`,`addrTypeCode`,`phoneTypeCode`,`phone`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `phone`
--

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

--
-- Table structure for table `phonetype`
--

DROP TABLE IF EXISTS `phonetype`;
CREATE TABLE `phonetype` (
  `phoneTypeCode` char(2) NOT NULL default '',
  `dscription` varchar(50) NOT NULL default '',
  `objType` char(2) default NULL,
  `auditDate` datetime default NULL,
  `auditUser` varchar(8) default NULL,
  `backupSts` char(1) default NULL,
  PRIMARY KEY  (`phoneTypeCode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `phonetype`
--

LOCK TABLES `phonetype` WRITE;
/*!40000 ALTER TABLE `phonetype` DISABLE KEYS */;
INSERT INTO `phonetype` VALUES ('01','TELPON KANTOR',NULL,NULL,NULL,NULL),('02','TELPON FAX',NULL,NULL,NULL,NULL),('03','CONTACT PERSON',NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `phonetype` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `preference`
--

DROP TABLE IF EXISTS `preference`;
CREATE TABLE `preference` (
  `cmpnyID` varchar(20) NOT NULL default '',
  `cmpnyName` varchar(100) NOT NULL default '',
  `address` varchar(255) NOT NULL default '',
  `city` varchar(100) default NULL,
  `state` varchar(100) default NULL,
  `zipCode` varchar(8) default NULL,
  `statecode` char(3) NOT NULL default '',
  `areacode` char(3) NOT NULL default '',
  `phone1` varchar(20) default NULL,
  `phone2` varchar(20) default NULL,
  `fax` varchar(20) default NULL,
  `email` varchar(50) default NULL,
  `website` varchar(50) NOT NULL default '',
  `manager` varchar(50) default NULL,
  `faSpv` varchar(50) default NULL,
  `edpo` varchar(50) default NULL,
  `npwpNumber` varchar(50) default NULL,
  `pkpDate` date default NULL,
  `ordrDocNum` int(5) NOT NULL default '0',
  `dlvrDocNum` int(5) NOT NULL default '0',
  `rtrnDocNum` int(5) NOT NULL default '0',
  `invDocNum` int(5) NOT NULL default '0',
  `poDocNum` int(5) NOT NULL default '0',
  `pRcvDocNum` int(5) NOT NULL default '0',
  `pRtrDocNum` int(5) NOT NULL default '0',
  `trnfDocNum` int(5) NOT NULL default '0',
  `gIssDocNum` int(5) NOT NULL default '0',
  `gRcvDocNum` int(5) NOT NULL default '0',
  `crmmDocNum` int(5) NOT NULL default '0',
  `pymtDocNum` int(5) NOT NULL default '0',
  `registerNum` int(5) NOT NULL default '0',
  `consignDocNum` int(5) NOT NULL default '0',
  `seri1` varchar(5) default NULL,
  `seri2` char(3) default NULL,
  `lstMnthPrc` date default '0000-00-00',
  `lstMnthPrAR` date default '0000-00-00',
  `auditDate` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `auditUser` varchar(8) NOT NULL default '',
  `backupSts` char(1) NOT NULL default 'N',
  `penetDocNum` int(5) NOT NULL default '0',
  `taxDt1Month` char(1) default 'N',
  `logServices` char(1) default 'N',
  `headOffice` char(1) default NULL,
  `custmrCode` varchar(15) default NULL,
  `backOrder` char(1) NOT NULL default 'N',
  PRIMARY KEY  (`cmpnyID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `preference`
--

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

--
-- Table structure for table `supplier`
--

DROP TABLE IF EXISTS `supplier`;
CREATE TABLE `supplier` (
  `suppCode` varchar(15) NOT NULL default '',
  `suppName` varchar(100) NOT NULL default '',
  `termCode` char(3) NOT NULL default '',
  `priceCode` varchar(8) NOT NULL default '',
  `notes` varchar(100) NOT NULL default '',
  `locked` char(1) NOT NULL default '',
  `destType` char(1) NOT NULL default '',
  `serverNMDest` varchar(35) NOT NULL default '',
  `databaseNMDest` varchar(35) NOT NULL default '',
  `uid` varchar(20) NOT NULL default '',
  `pwd` varchar(20) NOT NULL default '',
  `email` varchar(50) NOT NULL default '',
  `website` varchar(50) NOT NULL default '',
  `balance` double(19,6) NOT NULL default '0.000000',
  `dNotesBal` double(19,6) NOT NULL default '0.000000',
  `ordersBal` double(19,6) NOT NULL default '0.000000',
  `credLimit` double(19,6) NOT NULL default '0.000000',
  `taxInSameMonth` char(1) NOT NULL default '',
  `incTax` char(1) NOT NULL default '',
  `auditDate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `auditUser` varchar(8) NOT NULL default '',
  `objType` char(2) NOT NULL default '',
  `backupSts` char(1) NOT NULL default '',
  `UserEntry` varchar(20) NOT NULL default '',
  `DateEntry` datetime NOT NULL default '0000-00-00 00:00:00',
  `UserEdit` varchar(20) NOT NULL default '',
  `DateEdit` datetime NOT NULL default '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `supplier`
--

LOCK TABLES `supplier` WRITE;
/*!40000 ALTER TABLE `supplier` DISABLE KEYS */;
/*!40000 ALTER TABLE `supplier` 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 2011-03-25 11:15:03