itemexport 20080310 1944.sql

this is sample for traders

-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	5.0.45-community-nt-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 */;

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


--
-- Create schema `lw-tsm@pd100`
--

CREATE DATABASE IF NOT EXISTS `lw-tsm@pd100`;
USE `lw-tsm@pd100`;

--
-- Definition of table `item`
--

DROP TABLE IF EXISTS `item`;
CREATE TABLE `item` (
  `ITEMCODE` varchar(20) NOT NULL default '',
  `CODEBAR` varchar(14) NOT NULL default '',
  `SERIAL` tinyint(1) unsigned default '0',
  `GRUPCODE` int(3) default '0',
  `BRANDCODE` varchar(6) default 'NONE',
  `ITEMNAME` varchar(30) default 'BLANK',
  `SIZENAME` varchar(10) default 'NONE',
  `UNITID` int(3) NOT NULL default '0',
  `OPBAL` double(15,2) default '0.00',
  `ONHAND` double(15,2) default '0.00',
  `QTYSALES` double(15,2) default '0.00',
  `LASTCOST` double(15,2) default '0.00',
  `QTYRETSALES` double(15,2) default '0.00',
  `QTYPURC` double(15,2) default '0.00',
  `QTYRETPURC` double(15,2) default '0.00',
  `QTYADJ` double(15,2) default '0.00',
  `AVGCOST` double(15,2) default '0.00',
  `RELEVEL` double(15,2) default '1.00',
  `FOTO` longblob,
  `LASTUPDATE` date default '0000-00-00',
  PRIMARY KEY  (`ITEMCODE`),
  KEY `CODEBAR` (`CODEBAR`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 PACK_KEYS=1;

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

/*!40000 ALTER TABLE `item` DISABLE KEYS */;
INSERT INTO `item` (`ITEMCODE`,`CODEBAR`,`SERIAL`,`GRUPCODE`,`BRANDCODE`,`ITEMNAME`,`SIZENAME`,`UNITID`,`OPBAL`,`ONHAND`,`QTYSALES`,`LASTCOST`,`QTYRETSALES`,`QTYPURC`,`QTYRETPURC`,`QTYADJ`,`AVGCOST`,`RELEVEL`,`FOTO`,`LASTUPDATE`) VALUES 
 ('ABB-SUR-T','0920070000001',0,0,'ABB-','SURBEX-T 25\'S.  BOTOL','NONE',0,0.00,61.00,6.00,24447.50,0.00,67.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('ABB-SUR-T2','0920070000002',0,0,'ABB-','SURBEX-T TABLET 1BX=10\'S.','NONE',0,0.00,12.00,10.50,94365.00,0.50,22.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('AFI-AFIT','0920070000004',0,0,'AFI-','AFITSON NO.4 1X12','NONE',0,0.00,19.00,181.00,6069.00,0.00,200.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('AFI-AFIT01','0920070000005',0,0,'AFI-','AFITSON KECIL 13 GR/N0.2','NONE',0,0.00,181.00,11.00,1572.50,0.00,192.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('AFI-AFIT1','0920070000007',0,0,'AFI-','AFITSON CENGKEH 20 GR','NONE',0,0.00,0.00,0.00,3146.00,0.00,0.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('AFI-AFITSO','0920070000009',0,0,'AFI-','AFITSON 18 GR/BESAR/N.1','NONE',0,0.00,116.00,28.00,2090.15,0.00,144.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('AFI-CITC','0920070000010',0,0,'AFI-','CITROEN C AFIAT 50MG','NONE',0,0.00,13.00,11.00,22185.00,0.00,24.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('AFI-PAGODA','0920070000011',0,0,'AFI-','PERMEN PAGODA KECIL 10GR','NONE',0,0.00,468.00,708.00,1254.06,12.00,1164.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('AFI-PAGSA1','0920070000012',0,0,'AFI-','PAGODA SALEP BESAR/10GR','NONE',0,0.00,64.00,554.00,2054.45,4.00,614.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('AFI-PAGSY1','0920070000013',0,0,'AFI-','PAGODA SYRUP 36 ML.','NONE',0,0.00,97.00,69.00,2791.40,6.00,160.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('AFI-PAGSY3','0920070000014',0,0,'AFI-','PAGODA SYRUP 100 ML.','NONE',0,0.00,0.00,100.00,5828.00,6.00,94.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('AFI-PERPAG','0920070000015',0,0,'AFI-','PERMEN PAGODA BESAR 20GR','NONE',0,0.00,628.00,1239.00,2345.15,34.00,1833.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('AFI-SACC','0920070000016',0,0,'AFI-','SACCHARIN AFIAT','NONE',0,0.00,12.00,36.00,7945.80,0.00,48.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('APE-DECON','0920070000023',0,0,'APE-','','',0,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('APE-STOP-X','0920070000026',0,0,'APE-','STOP-X CREAM 30 GR','NONE',0,0.00,86.00,32.00,0.00,0.00,118.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('ART-BALPI1','0920070000028',0,0,'ART-','BALPIRIK BIASA 20 GR.','NONE',0,0.00,161.00,181.00,2178.35,0.00,342.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('ART-BALPI2','0920070000029',0,0,'ART-','BALPIRIK KUNING 20 GR.','NONE',0,0.00,162.00,297.00,2368.35,0.00,459.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('ART-BALPI3','0920070000030',0,0,'ART-','BALPIRIK HIJAU 20 GR.','NONE',0,0.00,174.00,323.00,2178.35,0.00,497.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('ART-BALPI4','0920070000031',0,0,'ART-','BALPIRIK MERAH 20 GR.','NONE',0,0.00,521.00,1157.00,2508.00,32.00,1646.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('ART-BALPI6','0920070000032',0,0,'ART-','BALPIRIK X.W LAVENDER 20G','NONE',0,0.00,290.00,231.00,2612.50,0.00,521.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('ART-BALPI7','0920070000033',0,0,'ART-','BALPIRIK X.W JASMINE 20G','NONE',0,0.00,150.00,65.00,2596.00,0.00,215.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('ART-BALPI8','0920070000034',0,0,'ART-','BALPIRIK X.W ROSE 20G','NONE',0,0.00,93.00,112.00,2950.00,1.00,204.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('BAY-ASPI','0920070000036',0,0,'BAY-','ASPIRIN TABLET 1 BOX=\'15','NONE',0,0.00,15.00,10.00,32401.20,2.00,23.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('BAY-CAN','0920070000037',0,0,'BAY-','CANESTEN 3 GR.','NONE',0,0.00,209.00,124.00,8349.00,3.00,330.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('BAY-CAN01','0920070000038',0,0,'BAY-','CANESTEN 5 GR.','NONE',0,0.00,311.00,583.00,10620.60,3.00,891.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('BAY-CAN02','0920070000039',0,0,'BAY-','CANESTEN 10 GR.','NONE',0,0.00,99.00,113.00,19009.20,0.00,212.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('BAY-CAN04','0920070000040',0,0,'BAY-','','',0,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('BAY-REFTB','0920070000043',0,0,'BAY-','REFAGAN NEW 30\'SX40TAB','NONE',0,0.00,65.00,73.00,43710.00,0.50,137.50,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('BAY-TONI01','0920070000044',0,0,'BAY-','TONIKUM BAYER 100 ML.','NONE',0,0.00,250.00,213.00,5912.94,3.00,460.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('BAY-TONI02','0920070000045',0,0,'BAY-','TONIKUM BAYER 330 ML.','NONE',0,0.00,71.00,209.00,0.00,0.00,280.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('BAY-UPIXON','1220070002566',0,0,'BAY-','UPIXON 15 ML.','NONE',0,0.00,3456.00,1052.00,3594.45,0.00,4508.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('BER-BIOTA1','1220070002375',0,0,'BER-','BIOLYSIN KID BLACKCURANT 30S','NONE',0,0.00,164.00,31.00,0.00,3.00,192.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('BER-BIOTA2','1220070002376',0,0,'BER-','BIOLYSIN KID STRAWBERY 30S','NONE',0,0.00,134.00,41.00,0.00,2.00,173.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('BER-BIOTA3','1220070002377',0,0,'BER-','BIOLYSIN KID ORANGE 30S','NONE',0,0.00,165.00,26.00,0.00,0.00,191.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('BER-KONTR','0920070000057',0,0,'BER-','KONTRABAT SYRUP 60 ML','NONE',0,0.00,270.00,60.00,0.00,0.00,330.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('BER-KONTRA','0920070000058',0,0,'BER-','KONTRABAT SYRUP 100 ML','NONE',0,0.00,132.00,50.00,6314.00,12.00,170.00,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),
 ('BER-VITA','0920070000061',0,0,'BER-','VITALONG C STRIP 1 BOX=\'25','NONE',0,0.00,23.08,30.08,0.00,0.00,53.16,0.00,0.00,0.00,1.00,NULL,'0000-00-00'),