-- phpMyAdmin SQL Dump
-- version 3.2.0.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 11, 2014 at 01:07 AM
-- Server version: 5.1.37
-- PHP Version: 5.3.0

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


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

--
-- Database: `jak_sumatra`
--

-- --------------------------------------------------------

--
-- Table structure for table `barcode`
--

DROP TABLE IF EXISTS `barcode`;
CREATE TABLE IF NOT EXISTS `barcode` (
  `id_barcode` bigint(20) NOT NULL AUTO_INCREMENT,
  `kode_stock` varchar(50) NOT NULL,
  PRIMARY KEY (`id_barcode`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `barcode`
--


-- --------------------------------------------------------

--
-- Table structure for table `bucket_print`
--

DROP TABLE IF EXISTS `bucket_print`;
CREATE TABLE IF NOT EXISTS `bucket_print` (
  `kode_stock` varchar(50) NOT NULL,
  `user_print` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bucket_print`
--


-- --------------------------------------------------------

--
-- Table structure for table `bucket_stock`
--

DROP TABLE IF EXISTS `bucket_stock`;
CREATE TABLE IF NOT EXISTS `bucket_stock` (
  `barcode` varchar(50) NOT NULL,
  `user_stock` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bucket_stock`
--


-- --------------------------------------------------------

--
-- Table structure for table `inventory_cincin`
--

DROP TABLE IF EXISTS `inventory_cincin`;
CREATE TABLE IF NOT EXISTS `inventory_cincin` (
  `id_stock` bigint(20) NOT NULL AUTO_INCREMENT,
  `kode_stock` varchar(50) NOT NULL,
  `id_supplier` bigint(20) NOT NULL,
  `cbprice` bigint(20) NOT NULL,
  `lbprice` bigint(20) NOT NULL,
  `msprice` bigint(20) NOT NULL,
  `weight` float NOT NULL,
  `barcodeno` varchar(100) NOT NULL,
  `combineitem` varchar(100) NOT NULL,
  `supplieritem` varchar(100) NOT NULL,
  `picture` varchar(100) NOT NULL,
  `description` varchar(100) NOT NULL,
  `id_status` int(11) NOT NULL DEFAULT '3',
  `id_branch` bigint(20) DEFAULT '1',
  `reasondelete` varchar(100) NOT NULL,
  `idr` int(11) NOT NULL,
  `notes` text NOT NULL,
  `internaldescription` text NOT NULL,
  `date_stock` date DEFAULT NULL,
  `status_stock` int(11) NOT NULL DEFAULT '1',
  `user_update` varchar(50) NOT NULL,
  `date_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_stock`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `inventory_cincin`
--

INSERT INTO `inventory_cincin` (`id_stock`, `kode_stock`, `id_supplier`, `cbprice`, `lbprice`, `msprice`, `weight`, `barcodeno`, `combineitem`, `supplieritem`, `picture`, `description`, `id_status`, `id_branch`, `reasondelete`, `idr`, `notes`, `internaldescription`, `date_stock`, `status_stock`, `user_update`, `date_update`) VALUES
(1, 'C1', 1, 0, 0, 0, 0, '000004', 'sds', 'sds', '', '', 4, 1, '', 0, '0', '', NULL, 1, 'admin', '2014-04-28 21:17:37'),
(2, 'C2', 1, 8252, 8252, 8252, 50.56, '000006', '3333', 'ABCD852', 'Penguins.jpg', 'aaa', 3, 1, '', 44444, '<p>cccc</p>', 'bbb', NULL, 1, 'admin', '2014-05-21 04:28:36'),
(3, 'C3', 1, 222, 44, 333, 4444, '000019', '5555', 'aaa', '', '<p>45425</p>', 3, 1, '', 44444, '0', '', NULL, 1, 'admin', '2014-05-18 22:02:38'),
(4, 'C4', 1, 1111, 33333, 2222, 4444, '000022', '55555', '11111', '', '6666', 3, 1, '', 44444, '0', '7777', NULL, 1, 'admin', '2014-05-21 04:20:33'),
(5, 'C5', 1, 333, 555, 444, 666, '000023', '777', '222', '', '8888', 3, 1, '', 44444, '<p>111111</p>', '9999', NULL, 1, 'admin', '2014-05-21 04:29:11');

-- --------------------------------------------------------

--
-- Table structure for table `inventory_consigment`
--

DROP TABLE IF EXISTS `inventory_consigment`;
CREATE TABLE IF NOT EXISTS `inventory_consigment` (
  `id_consigment` bigint(20) NOT NULL AUTO_INCREMENT,
  `kode_consigment` varchar(50) NOT NULL,
  `tgl_consigment` date NOT NULL,
  `id_branchfrom` bigint(20) DEFAULT NULL,
  `id_branchto` bigint(20) NOT NULL,
  `receive_date` date NOT NULL,
  `user_receive` varchar(50) NOT NULL,
  `status_consigment` int(11) NOT NULL DEFAULT '1',
  `user_update` varchar(50) NOT NULL,
  `date_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_consigment`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `inventory_consigment`
--

INSERT INTO `inventory_consigment` (`id_consigment`, `kode_consigment`, `tgl_consigment`, `id_branchfrom`, `id_branchto`, `receive_date`, `user_receive`, `status_consigment`, `user_update`, `date_update`) VALUES
(1, 'CONSIG1', '2014-05-01', 0, 0, '0000-00-00', '', 1, 'admin', '2014-05-01 18:02:02');

-- --------------------------------------------------------

--
-- Table structure for table `inventory_custom`
--

DROP TABLE IF EXISTS `inventory_custom`;
CREATE TABLE IF NOT EXISTS `inventory_custom` (
  `id_custom` bigint(20) NOT NULL AUTO_INCREMENT,
  `kode_stock` varchar(50) NOT NULL,
  `id_diamonds` bigint(20) NOT NULL,
  `gold` float(32,4) NOT NULL,
  `weight` float(32,4) NOT NULL,
  `cost` bigint(20) NOT NULL,
  `logistic` bigint(20) NOT NULL,
  `workmanship` bigint(20) NOT NULL,
  `user_update` varchar(50) NOT NULL,
  `date_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_custom`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `inventory_custom`
--

INSERT INTO `inventory_custom` (`id_custom`, `kode_stock`, `id_diamonds`, `gold`, `weight`, `cost`, `logistic`, `workmanship`, `user_update`, `date_update`) VALUES
(1, 'C2', 4, 23.5400, 2.5000, 100, 100, 500, 'admin', '2014-04-28 21:30:53'),
(2, 'C2', 2, 0.0000, 2.0000, 0, 0, 0, 'admin', '2014-04-28 21:31:19'),
(3, 'C2', 3, 0.0000, 3.5000, 0, 0, 0, 'admin', '2014-04-28 21:31:49'),
(4, 'STOCK2', 4, 20.2300, 2.0000, 100, 100, 100, 'admin', '2014-04-29 17:29:26'),
(5, 'STOCK2', 4, 0.0000, 2.5000, 0, 0, 0, 'admin', '2014-04-29 17:30:06');

-- --------------------------------------------------------

--
-- Table structure for table `inventory_detailsconsigment`
--

DROP TABLE IF EXISTS `inventory_detailsconsigment`;
CREATE TABLE IF NOT EXISTS `inventory_detailsconsigment` (
  `id_consigment` bigint(20) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  `user_update` varchar(50) NOT NULL,
  `date_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `id_detailsconsigment` bigint(20) NOT NULL AUTO_INCREMENT,
  `id_branchfrom` bigint(20) NOT NULL,
  `kode_stock` varchar(50) NOT NULL,
  PRIMARY KEY (`id_detailsconsigment`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `inventory_detailsconsigment`
--

INSERT INTO `inventory_detailsconsigment` (`id_consigment`, `status`, `user_update`, `date_update`, `id_detailsconsigment`, `id_branchfrom`, `kode_stock`) VALUES
(1, 1, 'admin', '2014-05-01 18:03:06', 1, 0, '');

-- --------------------------------------------------------

--
-- Table structure for table `inventory_diamond`
--

DROP TABLE IF EXISTS `inventory_diamond`;
CREATE TABLE IF NOT EXISTS `inventory_diamond` (
  `id_stock` bigint(20) NOT NULL AUTO_INCREMENT,
  `kode_stock` varchar(50) NOT NULL,
  `id_supplier` bigint(20) NOT NULL,
  `lbprice` bigint(20) NOT NULL,
  `msprice` bigint(20) NOT NULL,
  `rapprice` bigint(20) NOT NULL,
  `weight` float NOT NULL,
  `barcodeno` varchar(100) NOT NULL,
  `id_type` bigint(20) NOT NULL,
  `id_shape` bigint(20) NOT NULL,
  `certificateno` varchar(100) NOT NULL,
  `color` varchar(50) NOT NULL,
  `clarity` varchar(50) NOT NULL,
  `cut` varchar(50) NOT NULL,
  `foolish` varchar(50) NOT NULL,
  `symetry` varchar(50) NOT NULL,
  `fluo` varchar(50) NOT NULL,
  `discount` float NOT NULL,
  `id_status` int(11) NOT NULL DEFAULT '3',
  `id_branch` bigint(20) DEFAULT '1',
  `reasondelete` varchar(100) NOT NULL,
  `idr` int(11) NOT NULL,
  `notes` text NOT NULL,
  `internaldescription` text NOT NULL,
  `date_stock` date DEFAULT NULL,
  `certificate_name` varchar(100) NOT NULL,
  `description` varchar(100) NOT NULL,
  `status_stock` int(11) NOT NULL DEFAULT '1',
  `user_update` varchar(50) NOT NULL,
  `date_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_stock`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `inventory_diamond`
--

INSERT INTO `inventory_diamond` (`id_stock`, `kode_stock`, `id_supplier`, `lbprice`, `msprice`, `rapprice`, `weight`, `barcodeno`, `id_type`, `id_shape`, `certificateno`, `color`, `clarity`, `cut`, `foolish`, `symetry`, `fluo`, `discount`, `id_status`, `id_branch`, `reasondelete`, `idr`, `notes`, `internaldescription`, `date_stock`, `certificate_name`, `description`, `status_stock`, `user_update`, `date_update`) VALUES
(1, 'DIAMOND1', 1, 23423, 23423, 32423, 4324, '000017', 2, 7, '34234', '434', '424', '324', '34234', '32423', '4324', 324234, 3, 1, 'sadasd34234', 0, '', '', NULL, '', '', 2, 'admin', '2014-05-18 15:44:52'),
(2, 'DIAMOND2', 1, 33, 44, 55, 66, '000027', 2, 7, 'ddd', '777', '88', '99', '10', '10', '12', 13, 4, 1, '', 44444, '<p>16777</p>', '15666', NULL, '', '14555', 1, 'admin', '2014-05-22 08:22:37');

-- --------------------------------------------------------

--
-- Table structure for table `inventory_gkgr`
--

DROP TABLE IF EXISTS `inventory_gkgr`;
CREATE TABLE IF NOT EXISTS `inventory_gkgr` (
  `id_stock` bigint(20) NOT NULL AUTO_INCREMENT,
  `kode_stock` varchar(50) NOT NULL,
  `id_supplier` bigint(20) NOT NULL,
  `cbprice` bigint(20) NOT NULL,
  `lbprice` bigint(20) NOT NULL,
  `msprice` bigint(20) NOT NULL,
  `weight` float NOT NULL,
  `barcodeno` varchar(100) NOT NULL,
  `combineitem` varchar(100) NOT NULL,
  `supplieritem` varchar(100) NOT NULL,
  `picture` varchar(100) NOT NULL,
  `description` varchar(100) NOT NULL,
  `id_status` int(11) NOT NULL DEFAULT '3',
  `id_branch` bigint(20) DEFAULT '1',
  `reasondelete` varchar(100) NOT NULL,
  `idr` int(11) NOT NULL,
  `notes` text NOT NULL,
  `internaldescription` text NOT NULL,
  `date_stock` date DEFAULT NULL,
  `status_stock` int(11) NOT NULL DEFAULT '1',
  `user_update` varchar(50) NOT NULL,
  `date_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_stock`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `inventory_gkgr`
--

INSERT INTO `inventory_gkgr` (`id_stock`, `kode_stock`, `id_supplier`, `cbprice`, `lbprice`, `msprice`, `weight`, `barcodeno`, `combineitem`, `supplieritem`, `picture`, `description`, `id_status`, `id_branch`, `reasondelete`, `idr`, `notes`, `internaldescription`, `date_stock`, `status_stock`, `user_update`, `date_update`) VALUES
(1, 'GKGR1', 1, 444, 44, 444, 44, '000012', '444', 'aaaa', '', '<p>444</p>', 3, 1, 'vvvv', 0, '', '', NULL, 2, 'admin', '2014-05-18 15:29:25'),
(2, 'GKGR2', 1, 111, 111, 111, 11, '000013', '111', '111', 'Tulips.jpg', '', 3, 1, '', 0, '', '', NULL, 1, 'admin', '2014-05-18 15:28:08'),
(3, 'GKGR3', 1, 7, 8, 6, 9, '000028', '10', '777', 'Tulips.jpg', '12444', 3, 1, '', 44444, '<p>14444</p>', '13444', NULL, 1, 'admin', '2014-05-21 05:12:34');

-- --------------------------------------------------------

--
-- Table structure for table `inventory_gold`
--

DROP TABLE IF EXISTS `inventory_gold`;
CREATE TABLE IF NOT EXISTS `inventory_gold` (
  `id_stock` bigint(20) NOT NULL AUTO_INCREMENT,
  `kode_stock` varchar(50) NOT NULL,
  `id_supplier` bigint(20) NOT NULL,
  `cbprice` bigint(20) NOT NULL,
  `weight` float NOT NULL,
  `barcodeno` varchar(100) NOT NULL,
  `combineitem` varchar(100) NOT NULL,
  `kadar` float NOT NULL,
  `picture` varchar(100) NOT NULL,
  `description` varchar(100) NOT NULL,
  `id_status` int(11) NOT NULL DEFAULT '3',
  `id_branch` bigint(20) DEFAULT '1',
  `reasondelete` varchar(100) NOT NULL,
  `idr` int(11) NOT NULL,
  `notes` text NOT NULL,
  `internaldescription` text NOT NULL,
  `date_stock` date DEFAULT NULL,
  `status_stock` int(11) NOT NULL DEFAULT '1',
  `user_update` varchar(50) NOT NULL,
  `date_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_stock`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `inventory_gold`
--

INSERT INTO `inventory_gold` (`id_stock`, `kode_stock`, `id_supplier`, `cbprice`, `weight`, `barcodeno`, `combineitem`, `kadar`, `picture`, `description`, `id_status`, `id_branch`, `reasondelete`, `idr`, `notes`, `internaldescription`, `date_stock`, `status_stock`, `user_update`, `date_update`) VALUES
(1, 'GOLD1', 1, 333, 333, '000010', '33', 0, '', '<p>3333</p>', 4, 1, '', 44444, '0', '', NULL, 1, 'admin', '2014-05-22 08:55:57'),
(2, 'GOLD2', 1, 5555, 5555, '000011', '555', 55555, 'Hydrangeas.jpg', '<p>5555</p>', 3, 1, 'ffffff', 0, '0', '', NULL, 2, 'admin', '2014-05-18 15:32:52'),
(3, 'GOLD3', 1, 0, 66, '000029', '777', 0, 'Chrysanthemum.jpg', 'rrr', 4, 1, '', 44444, '0', 'ttt', NULL, 1, 'admin', '2014-05-23 12:47:50'),
(4, 'GOLD4', 1, 333, 444, '000030', '555', 0, 'Desert.jpg', '666', 3, 1, '', 44444, '<p>999</p>', '777', NULL, 1, 'admin', '2014-05-21 05:21:12');

-- --------------------------------------------------------

--
-- Table structure for table `inventory_kerabu`
--

DROP TABLE IF EXISTS `inventory_kerabu`;
CREATE TABLE IF NOT EXISTS `inventory_kerabu` (
  `id_stock` bigint(20) NOT NULL AUTO_INCREMENT,
  `kode_stock` varchar(50) NOT NULL,
  `id_supplier` bigint(20) NOT NULL,
  `cbprice` bigint(20) NOT NULL,
  `lbprice` bigint(20) NOT NULL,
  `msprice` bigint(20) NOT NULL,
  `weight` float NOT NULL,
  `barcodeno` varchar(100) NOT NULL,
  `combineitem` varchar(100) NOT NULL,
  `supplieritem` varchar(100) NOT NULL,
  `picture` varchar(100) NOT NULL,
  `description` varchar(100) NOT NULL,
  `id_status` int(11) NOT NULL DEFAULT '3',
  `id_branch` bigint(20) DEFAULT '1',
  `reasondelete` varchar(100) NOT NULL,
  `idr` int(11) NOT NULL,
  `notes` text NOT NULL,
  `internaldescription` text NOT NULL,
  `date_stock` date DEFAULT NULL,
  `status_stock` int(11) NOT NULL DEFAULT '1',
  `user_update` varchar(50) NOT NULL,
  `date_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_stock`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `inventory_kerabu`
--

INSERT INTO `inventory_kerabu` (`id_stock`, `kode_stock`, `id_supplier`, `cbprice`, `lbprice`, `msprice`, `weight`, `barcodeno`, `combineitem`, `supplieritem`, `picture`, `description`, `id_status`, `id_branch`, `reasondelete`, `idr`, `notes`, `internaldescription`, `date_stock`, `status_stock`, `user_update`, `date_update`) VALUES
(1, 'K1', 1, 555, 55, 555, 555, '000014', '555', 'wwwww', 'Lighthouse.jpg', '<p>55555</p>', 3, 1, 'fgfddfg', 0, '', '', NULL, 2, 'admin', '2014-05-18 15:35:23'),
(2, 'K2', 1, 11, 33, 22, 44, '000021', '111111', '11111', 'Hydrangeas.jpg', '<p>111111</p>', 3, 1, '', 44444, '', '', NULL, 1, 'admin', '2014-05-21 03:57:51'),
(3, 'K3', 1, 4, 5, 3, 6, '000031', '6', 'gggg', 'Desert.jpg', '222', 3, 1, '', 44444, '<p>333</p>', '111', NULL, 1, 'admin', '2014-05-21 05:24:52');

-- --------------------------------------------------------

--
-- Table structure for table `inventory_liontin`
--

DROP TABLE IF EXISTS `inventory_liontin`;
CREATE TABLE IF NOT EXISTS `inventory_liontin` (
  `id_stock` bigint(20) NOT NULL AUTO_INCREMENT,
  `kode_stock` varchar(50) NOT NULL,
  `id_supplier` bigint(20) NOT NULL,
  `cbprice` bigint(20) NOT NULL,
  `lbprice` bigint(20) NOT NULL,
  `msprice` bigint(20) NOT NULL,
  `weight` float NOT NULL,
  `barcodeno` varchar(100) NOT NULL,
  `combineitem` varchar(100) NOT NULL,
  `supplieritem` varchar(100) NOT NULL,
  `picture` varchar(100) NOT NULL,
  `description` varchar(100) NOT NULL,
  `id_status` int(11) NOT NULL DEFAULT '3',
  `id_branch` bigint(20) DEFAULT '1',
  `reasondelete` varchar(100) NOT NULL,
  `idr` int(11) NOT NULL,
  `notes` text NOT NULL,
  `internaldescription` text NOT NULL,
  `date_stock` date DEFAULT NULL,
  `status_stock` int(11) NOT NULL DEFAULT '1',
  `user_update` varchar(50) NOT NULL,
  `date_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_stock`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `inventory_liontin`
--

INSERT INTO `inventory_liontin` (`id_stock`, `kode_stock`, `id_supplier`, `cbprice`, `lbprice`, `msprice`, `weight`, `barcodeno`, `combineitem`, `supplieritem`, `picture`, `description`, `id_status`, `id_branch`, `reasondelete`, `idr`, `notes`, `internaldescription`, `date_stock`, `status_stock`, `user_update`, `date_update`) VALUES
(1, 'L1', 1, 45435, 534534, 5435345, 5345, '000015', '45345', 'aaaaa', 'Koala.jpg', '<p>34234</p>', 4, 1, '', 0, '', '', NULL, 1, 'admin', '2014-06-10 23:07:47'),
(2, 'L2', 1, 444, 666, 555, 777, '000016', '888', '4444', '', '<p>67567657</p>', 3, 1, 'bbbbbbbbb', 0, '', '', NULL, 2, 'admin', '2014-05-18 15:39:49'),
(3, 'L3', 1, 222, 333, 1111, 4444, '000032', '555', '555', '', 'ccc', 3, 1, '', 44444, '<p>aaa</p>', 'bbb', NULL, 1, 'admin', '2014-05-21 05:28:29');

-- --------------------------------------------------------

--
-- Table structure for table `inventory_logam`
--

DROP TABLE IF EXISTS `inventory_logam`;
CREATE TABLE IF NOT EXISTS `inventory_logam` (
  `id_stock` bigint(20) NOT NULL AUTO_INCREMENT,
  `kode_stock` varchar(50) NOT NULL,
  `id_supplier` bigint(20) NOT NULL,
  `cbprice` bigint(20) NOT NULL,
  `weight` float NOT NULL,
  `barcodeno` varchar(100) NOT NULL,
  `id_status` int(11) NOT NULL DEFAULT '3',
  `id_branch` bigint(20) DEFAULT '1',
  `reasondelete` varchar(100) NOT NULL,
  `idr` int(11) NOT NULL,
  `notes` text NOT NULL,
  `internaldescription` text NOT NULL,
  `date_stock` date DEFAULT NULL,
  `description` varchar(100) NOT NULL,
  `status_stock` int(11) NOT NULL DEFAULT '1',
  `user_update` varchar(50) NOT NULL,
  `date_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_stock`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `inventory_logam`
--

INSERT INTO `inventory_logam` (`id_stock`, `kode_stock`, `id_supplier`, `cbprice`, `weight`, `barcodeno`, `id_status`, `id_branch`, `reasondelete`, `idr`, `notes`, `internaldescription`, `date_stock`, `description`, `status_stock`, `user_update`, `date_update`) VALUES
(1, 'LOGAM1', 1, 3333, 444, '000033', 3, 1, '', 44444, '<p>777</p>', '555', NULL, '444', 1, 'admin', '2014-05-21 05:33:39');

-- --------------------------------------------------------

--
-- Table structure for table `inventory_mastura`
--

DROP TABLE IF EXISTS `inventory_mastura`;
CREATE TABLE IF NOT EXISTS `inventory_mastura` (
  `id_stock` bigint(20) NOT NULL AUTO_INCREMENT,
  `kode_stock` varchar(50) NOT NULL,
  `id_supplier` bigint(20) NOT NULL,
  `cbprice` bigint(20) NOT NULL,
  `lbprice` bigint(20) NOT NULL,
  `msprice` bigint(20) NOT NULL,
  `weight` float NOT NULL,
  `barcodeno` varchar(100) NOT NULL,
  `combineitem` varchar(100) NOT NULL,
  `supplieritem` varchar(100) NOT NULL,
  `picture` varchar(100) NOT NULL,
  `description` varchar(100) NOT NULL,
  `id_status` int(11) NOT NULL DEFAULT '3',
  `id_branch` bigint(20) DEFAULT '1',
  `reasondelete` varchar(100) NOT NULL,
  `idr` int(11) NOT NULL,
  `notes` text NOT NULL,
  `internaldescription` text NOT NULL,
  `date_stock` date DEFAULT NULL,
  `status_stock` int(11) NOT NULL DEFAULT '1',
  `user_update` varchar(50) NOT NULL,
  `date_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_stock`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `inventory_mastura`
--

INSERT INTO `inventory_mastura` (`id_stock`, `kode_stock`, `id_supplier`, `cbprice`, `lbprice`, `msprice`, `weight`, `barcodeno`, `combineitem`, `supplieritem`, `picture`, `description`, `id_status`, `id_branch`, `reasondelete`, `idr`, `notes`, `internaldescription`, `date_stock`, `status_stock`, `user_update`, `date_update`) VALUES
(1, 'M1', 1, 333, 444, 222, 555, '000024', '666', '111', '', '111', 3, 1, '', 44444, '<p>444</p>', '2222', NULL, 1, 'admin', '2014-05-21 04:48:04'),
(2, 'M2', 1, 999, 777, 888, 666, '000025', '555', 'bbbbb', '', '3432423', 3, 1, '', 44444, '<p>4234234234</p>', '423423423', NULL, 1, 'admin', '2014-05-21 04:48:34');

-- --------------------------------------------------------

--
-- Table structure for table `inventory_rangka`
--

DROP TABLE IF EXISTS `inventory_rangka`;
CREATE TABLE IF NOT EXISTS `inventory_rangka` (
  `id_stock` bigint(20) NOT NULL AUTO_INCREMENT,
  `kode_stock` varchar(50) NOT NULL,
  `id_supplier` bigint(20) NOT NULL,
  `cbprice` bigint(20) NOT NULL,
  `lbprice` bigint(20) NOT NULL,
  `msprice` bigint(20) NOT NULL,
  `weight` float NOT NULL,
  `barcodeno` varchar(100) NOT NULL,
  `combineitem` varchar(100) NOT NULL,
  `supplieritem` varchar(100) NOT NULL,
  `picture` varchar(100) NOT NULL,
  `description` varchar(100) NOT NULL,
  `id_status` int(11) NOT NULL DEFAULT '3',
  `id_branch` bigint(20) DEFAULT '1',
  `reasondelete` varchar(100) NOT NULL,
  `idr` int(11) NOT NULL,
  `notes` text NOT NULL,
  `internaldescription` text NOT NULL,
  `date_stock` date DEFAULT NULL,
  `status_stock` int(11) NOT NULL DEFAULT '1',
  `user_update` varchar(50) NOT NULL,
  `date_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_stock`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `inventory_rangka`
--

INSERT INTO `inventory_rangka` (`id_stock`, `kode_stock`, `id_supplier`, `cbprice`, `lbprice`, `msprice`, `weight`, `barcodeno`, `combineitem`, `supplieritem`, `picture`, `description`, `id_status`, `id_branch`, `reasondelete`, `idr`, `notes`, `internaldescription`, `date_stock`, `status_stock`, `user_update`, `date_update`) VALUES
(1, 'R1', 1, 100, 300, 200, 400, '000008', '500', '111', 'Lighthouse.jpg', '<p>gfhgfjhff</p>\r\n<p>ghkfkghkfg</p>\r\n<p>jhgkjgjkg</p>', 3, 1, '', 0, '', '', NULL, 1, 'admin', '2014-05-18 14:50:53'),
(2, 'R2', 1, 66, 66, 66, 66, '000009', '666', '666', '', '<p>6666</p>', 3, 1, 'asdasdasd', 0, '', '', NULL, 2, 'admin', '2014-05-18 15:07:07'),
(3, 'R3', 1, 77, 66, 88, 555, '000026', '444', '9999', 'Hydrangeas.jpg', 'tttt', 3, 1, '', 44444, '<p>www</p>', 'yyy', NULL, 1, 'admin', '2014-05-21 04:55:44');

-- --------------------------------------------------------

--
-- Table structure for table `inventory_readyitem`
--

DROP TABLE IF EXISTS `inventory_readyitem`;
CREATE TABLE IF NOT EXISTS `inventory_readyitem` (
  `id_stock` bigint(20) NOT NULL AUTO_INCREMENT,
  `kode_stock` varchar(50) NOT NULL,
  `id_supplier` bigint(20) NOT NULL,
  `cbprice` bigint(20) NOT NULL,
  `lbprice` bigint(20) NOT NULL,
  `msprice` bigint(20) NOT NULL,
  `weight` float NOT NULL,
  `barcodeno` varchar(100) NOT NULL,
  `combineitem` varchar(100) NOT NULL,
  `supplieritem` varchar(100) NOT NULL,
  `picture` varchar(100) NOT NULL,
  `description` varchar(100) NOT NULL,
  `id_status` int(11) NOT NULL DEFAULT '3',
  `id_branch` bigint(20) DEFAULT '1',
  `reasondelete` varchar(100) NOT NULL,
  `idr` int(11) NOT NULL,
  `notes` text NOT NULL,
  `internaldescription` text NOT NULL,
  `date_stock` date DEFAULT NULL,
  `status_stock` int(11) NOT NULL DEFAULT '1',
  `user_update` varchar(50) NOT NULL,
  `date_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_stock`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `inventory_readyitem`
--

INSERT INTO `inventory_readyitem` (`id_stock`, `kode_stock`, `id_supplier`, `cbprice`, `lbprice`, `msprice`, `weight`, `barcodeno`, `combineitem`, `supplieritem`, `picture`, `description`, `id_status`, `id_branch`, `reasondelete`, `idr`, `notes`, `internaldescription`, `date_stock`, `status_stock`, `user_update`, `date_update`) VALUES
(1, 'STOCK1', 1, 333, 3333, 3333, 333, '000005', '333', 'aaaa', 'Desert.jpg', '<p>33333</p>', 3, 1, 'qqqqq', 0, '', '', NULL, 2, 'admin', '2014-05-18 15:26:09'),
(2, 'STOCK2', 1, 1400, 1600, 1500, 20.23, '000007', '', 'sdsdss', '', '', 4, 1, '', 0, '', '', NULL, 1, 'admin', '2014-06-07 17:36:35'),
(3, 'STOCK3', 1, 444, 4, 444, 444, '000018', '4444', '444', 'Penguins.jpg', '<p>4444</p>', 3, 1, '', 44444, '', '', NULL, 1, 'admin', '2014-05-18 22:19:01'),
(4, 'STOCK4', 1, 77, 88, 66, 999, '000034', '1212', 'bbb', '', 'rrrr', 4, 1, '', 44444, '<p>wwww</p>', 'tttt', NULL, 1, 'admin', '2014-06-07 17:36:51');

-- --------------------------------------------------------

--
-- Table structure for table `log_diamonds`
--

DROP TABLE IF EXISTS `log_diamonds`;
CREATE TABLE IF NOT EXISTS `log_diamonds` (
  `id_diamonds` bigint(20) NOT NULL AUTO_INCREMENT,
  `diamonds` varchar(100) NOT NULL,
  `keterangan` varchar(100) NOT NULL,
  `price` bigint(20) NOT NULL,
  `price_before` bigint(20) NOT NULL,
  `user_update` varchar(50) NOT NULL,
  `date_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_diamonds`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `log_diamonds`
--

INSERT INTO `log_diamonds` (`id_diamonds`, `diamonds`, `keterangan`, `price`, `price_before`, `user_update`, `date_update`) VALUES
(1, 'Minus 2', '0.001 - 0.008ct', 22222, 22222, 'test', '2014-05-11 14:41:51'),
(2, 'Minus 2', '0.001 - 0.008ct', 100000, 22222, 'test', '2014-05-11 14:44:11');

-- --------------------------------------------------------

--
-- Table structure for table `orderform`
--

DROP TABLE IF EXISTS `orderform`;
CREATE TABLE IF NOT EXISTS `orderform` (
  `id_orderform` bigint(20) NOT NULL AUTO_INCREMENT,
  `kode_orderform` varchar(50) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `manufacture` varchar(10) NOT NULL,
  `details` text NOT NULL,
  `description` text NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'Parent',
  `id_branch` bigint(20) NOT NULL,
  `orderform_date` date NOT NULL,
  `picture` varchar(100) NOT NULL,
  `others_gold` varchar(100) NOT NULL,
  `others_choice` varchar(100) NOT NULL,
  `status_orderform` int(11) NOT NULL DEFAULT '1',
  `user_update` varchar(50) NOT NULL,
  `date_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_orderform`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `orderform`
--

INSERT INTO `orderform` (`id_orderform`, `kode_orderform`, `nama`, `manufacture`, `details`, `description`, `status`, `id_branch`, `orderform_date`, `picture`, `others_gold`, `others_choice`, `status_orderform`, `user_update`, `date_update`) VALUES
(1, 'ORF1', 'sdsds', 'overseas', 'sdsd', 'sds', 'done', 0, '2014-03-22', '', '', '16', 1, 'admin', '2014-03-22 16:39:17'),
(2, 'ORF2', 'dfdfd', 'overseas', 'ssds', 'dsds', 'done', 0, '2014-03-22', '', '', '', 1, 'admin', '2014-03-22 16:41:10');

-- --------------------------------------------------------

--
-- Table structure for table `orderform_choice`
--

DROP TABLE IF EXISTS `orderform_choice`;
CREATE TABLE IF NOT EXISTS `orderform_choice` (
  `kode_orderform` varchar(50) NOT NULL,
  `choice` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `orderform_choice`
--

INSERT INTO `orderform_choice` (`kode_orderform`, `choice`) VALUES
('ORF1', 'Ring'),
('ORF2', 'Ring');

-- --------------------------------------------------------

--
-- Table structure for table `orderform_gold`
--

DROP TABLE IF EXISTS `orderform_gold`;
CREATE TABLE IF NOT EXISTS `orderform_gold` (
  `kode_orderform` varchar(50) NOT NULL,
  `gold` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `orderform_gold`
--

INSERT INTO `orderform_gold` (`kode_orderform`, `gold`) VALUES
('ORF1', '750 White Gold'),
('ORF2', '750 White Gold');

-- --------------------------------------------------------

--
-- Table structure for table `presales`
--

DROP TABLE IF EXISTS `presales`;
CREATE TABLE IF NOT EXISTS `presales` (
  `id_presales` bigint(20) NOT NULL AUTO_INCREMENT,
  `kode_presales` varchar(50) NOT NULL,
  `id_customer` bigint(20) NOT NULL,
  `kode_stock` varchar(50) NOT NULL,
  `description` varchar(50) NOT NULL,
  `closed` int(11) NOT NULL DEFAULT '0',
  `status` varchar(50) NOT NULL DEFAULT 'Parent',
  `presales_date` date NOT NULL,
  `status_presales` int(11) NOT NULL DEFAULT '1',
  `user_update` varchar(50) NOT NULL,
  `date_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_presales`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `presales`
--


-- --------------------------------------------------------

--
-- Table structure for table `print_barcode`
--

DROP TABLE IF EXISTS `print_barcode`;
CREATE TABLE IF NOT EXISTS `print_barcode` (
  `id_print` bigint(20) NOT NULL AUTO_INCREMENT,
  `barcodeno` varchar(50) NOT NULL,
  `date_print` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `user_print` varchar(50) NOT NULL,
  PRIMARY KEY (`id_print`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `print_barcode`
--

INSERT INTO `print_barcode` (`id_print`, `barcodeno`, `date_print`, `user_print`) VALUES
(1, '000005', '2014-04-21 23:07:09', 'admin');

-- --------------------------------------------------------

--
-- Table structure for table `reprint_invoice`
--

DROP TABLE IF EXISTS `reprint_invoice`;
CREATE TABLE IF NOT EXISTS `reprint_invoice` (
  `invoice` varchar(100) NOT NULL,
  `user_update` varchar(50) NOT NULL,
  `invoice_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `reprint_invoice`
--


-- --------------------------------------------------------

--
-- Table structure for table `return_sales`
--

DROP TABLE IF EXISTS `return_sales`;
CREATE TABLE IF NOT EXISTS `return_sales` (
  `id_returnsales` bigint(20) NOT NULL AUTO_INCREMENT,
  `kode_returnsales` varchar(50) NOT NULL,
  `date_returnsales` date NOT NULL,
  `inventory` varchar(50) NOT NULL,
  `id_customer` bigint(20) NOT NULL,
  `kode_stock` varchar(50) NOT NULL,
  `hargaterima` bigint(20) NOT NULL,
  `status_returnsales` int(11) NOT NULL DEFAULT '1',
  `user_update` varchar(50) NOT NULL,
  `date_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_returnsales`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `return_sales`
--

INSERT INTO `return_sales` (`id_returnsales`, `kode_returnsales`, `date_returnsales`, `inventory`, `id_customer`, `kode_stock`, `hargaterima`, `status_returnsales`, `user_update`, `date_update`) VALUES
(1, 'RETURN/052014/1', '2014-05-04', 'Diamond', 0, 'Lama', 10000, 1, 'admin', '2014-05-04 19:05:45'),
(2, 'RETURN/052014/2', '2014-05-04', 'Diamond', 0, '', 0, 1, 'admin', '2014-05-04 19:10:40'),
(3, 'RETURN/052014/2', '2014-05-04', 'Diamond', 0, '', 0, 1, 'admin', '2014-05-04 19:10:40');

-- --------------------------------------------------------

--
-- Table structure for table `sales`
--

DROP TABLE IF EXISTS `sales`;
CREATE TABLE IF NOT EXISTS `sales` (
  `id_sales` bigint(20) NOT NULL AUTO_INCREMENT,
  `invoice` varchar(50) NOT NULL,
  `invoice_date` date NOT NULL,
  `id_customer` bigint(20) NOT NULL,
  `inventory` varchar(50) NOT NULL COMMENT '1 diamond, 2 gold, 3 logam mulia, 4 services',
  `notes` text NOT NULL,
  `status_sales` int(11) NOT NULL DEFAULT '1',
  `user_update` varchar(50) NOT NULL,
  `date_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_sales`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `sales`
--

INSERT INTO `sales` (`id_sales`, `invoice`, `invoice_date`, `id_customer`, `inventory`, `notes`, `status_sales`, `user_update`, `date_update`) VALUES
(1, 'BRANCH1G/05/1', '2014-05-23', 2, 'Gold', '', 1, 'admin', '2014-05-23 12:47:44'),
(3, 'BRANCH1D/06/1', '2014-06-07', 1, 'Diamond', '', 2, 'admin', '2014-06-07 17:34:44'),
(4, 'BRANCH1RI/06/1', '2014-06-07', 1, 'ReadyItem', '', 1, 'admin', '2014-06-07 17:34:58'),
(5, 'BRANCH1L/06/1', '2014-06-10', 1, 'Liontin', '', 1, 'admin', '2014-06-10 23:07:36');

-- --------------------------------------------------------

--
-- Table structure for table `salesdetails`
--

DROP TABLE IF EXISTS `salesdetails`;
CREATE TABLE IF NOT EXISTS `salesdetails` (
  `id_salesdetails` bigint(20) NOT NULL AUTO_INCREMENT,
  `id_sales` bigint(20) NOT NULL,
  `qty` bigint(20) NOT NULL,
  `tanggal` date NOT NULL,
  `barcode` varchar(50) NOT NULL,
  `kode_stock` varchar(50) NOT NULL,
  `inventory` varchar(50) NOT NULL,
  `idr` int(11) NOT NULL,
  `currency` varchar(10) NOT NULL,
  `price` bigint(20) NOT NULL,
  `cbprice` bigint(20) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  `user_update` varchar(50) NOT NULL,
  `date_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_salesdetails`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `salesdetails`
--

INSERT INTO `salesdetails` (`id_salesdetails`, `id_sales`, `qty`, `tanggal`, `barcode`, `kode_stock`, `inventory`, `idr`, `currency`, `price`, `cbprice`, `status`, `user_update`, `date_update`) VALUES
(1, 1, 1, '2014-05-23', '000029', 'GOLD3', 'Gold', 44444, 'USD', 20, 10, 1, 'admin', '2014-06-10 23:08:29'),
(2, 4, 1, '2014-06-07', '000007', 'STOCK2', 'ReadyItem', 44444, 'USD', 100, 10, 1, 'admin', '2014-06-10 23:08:29'),
(3, 4, 1, '2014-06-07', '000034', 'STOCK4', 'ReadyItem', 44444, 'USD', 400, 10, 1, 'admin', '2014-06-10 23:08:29'),
(4, 5, 1, '2014-06-10', '000015', 'L1', 'Liontin', 44444, 'USD', 20, 20, 1, 'admin', '2014-06-10 23:08:29');

-- --------------------------------------------------------

--
-- Table structure for table `salesservice`
--

DROP TABLE IF EXISTS `salesservice`;
CREATE TABLE IF NOT EXISTS `salesservice` (
  `id_servicesales` bigint(20) NOT NULL AUTO_INCREMENT,
  `id_sales` bigint(20) NOT NULL,
  `description` text NOT NULL,
  `tanggal` date NOT NULL,
  `price` bigint(20) NOT NULL,
  `idr` bigint(20) NOT NULL,
  `currency` varchar(10) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  `user_update` varchar(50) NOT NULL,
  `date_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_servicesales`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `salesservice`
--

INSERT INTO `salesservice` (`id_servicesales`, `id_sales`, `description`, `tanggal`, `price`, `idr`, `currency`, `status`, `user_update`, `date_update`) VALUES
(1, 2, 'aaaaa', '2014-05-23', 1111, 44444, 'IDR', 1, 'admin', '2014-05-23 12:49:46');

-- --------------------------------------------------------

--
-- Table structure for table `sales_payment`
--

DROP TABLE IF EXISTS `sales_payment`;
CREATE TABLE IF NOT EXISTS `sales_payment` (
  `id_salespayment` bigint(20) NOT NULL AUTO_INCREMENT,
  `id_sales` bigint(20) NOT NULL,
  `nominal` bigint(20) NOT NULL,
  `paymentdate` date NOT NULL,
  `user_update` varchar(50) NOT NULL,
  `date_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_salespayment`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `sales_payment`
--

INSERT INTO `sales_payment` (`id_salespayment`, `id_sales`, `nominal`, `paymentdate`, `user_update`, `date_update`) VALUES
(1, 1, 10, '2014-06-07', 'admin', '2014-06-07 16:47:47'),
(2, 1, 12, '2014-06-14', 'admin', '2014-06-07 16:50:14'),
(3, 1, 22, '2014-06-07', 'admin', '2014-06-07 17:04:04'),
(4, 1, 22178, '2014-06-07', 'admin', '2014-06-07 17:04:39'),
(5, 4, 10, '2014-06-07', 'admin', '2014-06-07 17:38:14'),
(6, 4, 40, '2014-06-07', 'admin', '2014-06-07 18:06:51');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_admin`
--

DROP TABLE IF EXISTS `tbl_admin`;
CREATE TABLE IF NOT EXISTS `tbl_admin` (
  `idid` int(100) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(50) NOT NULL,
  `password` varchar(200) NOT NULL,
  `status` tinyint(2) NOT NULL DEFAULT '2',
  `id_branch` bigint(20) NOT NULL,
  `lastlogin` datetime NOT NULL,
  PRIMARY KEY (`idid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `tbl_admin`
--

INSERT INTO `tbl_admin` (`idid`, `user_id`, `password`, `status`, `id_branch`, `lastlogin`) VALUES
(5, 'admin', '8ead19ac784929f84da7a71f30de2049', 2, 1, '2014-06-10 22:31:35'),
(9, 'Yaya', 'e10adc3949ba59abbe56e057f20f883e', 2, 2, '0000-00-00 00:00:00');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_application`
--

DROP TABLE IF EXISTS `tbl_application`;
CREATE TABLE IF NOT EXISTS `tbl_application` (
  `id_application` bigint(20) NOT NULL AUTO_INCREMENT,
  `application` varchar(50) NOT NULL,
  PRIMARY KEY (`id_application`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=46 ;

--
-- Dumping data for table `tbl_application`
--

INSERT INTO `tbl_application` (`id_application`, `application`) VALUES
(1, 'User'),
(2, 'Priviledge'),
(3, 'Supplier'),
(4, 'Customer'),
(5, 'Branch'),
(6, 'Country'),
(7, 'Kota'),
(8, 'Payment Method'),
(9, 'Certificate Type'),
(10, 'Shape'),
(11, 'Ready Item'),
(12, 'Gold'),
(13, 'Logam Mulia'),
(14, 'Diamond'),
(15, 'Status Monitoring'),
(16, 'Consigment'),
(17, 'Input PreSales'),
(18, 'Searching PreSales'),
(19, 'Sales'),
(20, 'Reprint Invoice'),
(21, 'Reminder Payment'),
(22, 'Consigment Receive'),
(23, 'Consigment History'),
(24, 'Indicator'),
(25, 'Return Sales'),
(26, 'Diamonds Categorization in Types'),
(27, 'CB and LB Price'),
(28, 'Gold'),
(29, 'Reprint Barcode'),
(30, 'Stock Of Numb'),
(31, 'Order Form Input'),
(32, 'Order Form Progress'),
(33, 'Order Form History'),
(34, 'Cincin'),
(35, 'Mastura'),
(36, 'Liontin'),
(37, 'Kerabu'),
(38, 'Gelang Kaku Gelang Rantai'),
(39, 'Rangka'),
(40, 'Report Inventory'),
(41, 'Report Sales'),
(42, 'Report Payment'),
(43, 'Delete Inventory'),
(44, 'Photo Album'),
(45, 'Payment Sales');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_branch`
--

DROP TABLE IF EXISTS `tbl_branch`;
CREATE TABLE IF NOT EXISTS `tbl_branch` (
  `id_branch` bigint(20) NOT NULL AUTO_INCREMENT,
  `kode_branch` varchar(50) NOT NULL,
  `nama_branch` varchar(100) NOT NULL,
  `id_kota` bigint(20) NOT NULL,
  `status_branch` int(11) NOT NULL DEFAULT '1',
  `date_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `user_update` varchar(50) NOT NULL,
  PRIMARY KEY (`id_branch`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `tbl_branch`
--

INSERT INTO `tbl_branch` (`id_branch`, `kode_branch`, `nama_branch`, `id_kota`, `status_branch`, `date_update`, `user_update`) VALUES
(1, 'BRANCH1', 'JKT', 1, 1, '2014-05-22 08:46:13', 'admin'),
(2, 'BRANCH2', 'BANDUNG', 2, 1, '2014-05-22 08:47:22', 'admin');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_cblb`
--

DROP TABLE IF EXISTS `tbl_cblb`;
CREATE TABLE IF NOT EXISTS `tbl_cblb` (
  `cbprice` float NOT NULL,
  `lbprice` float NOT NULL,
  `user_update` varchar(50) NOT NULL,
  `date_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_cblb`
--

INSERT INTO `tbl_cblb` (`cbprice`, `lbprice`, `user_update`, `date_update`) VALUES
(20, 30, 'admin', '2014-05-22 08:18:24');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_customer`
--

DROP TABLE IF EXISTS `tbl_customer`;
CREATE TABLE IF NOT EXISTS `tbl_customer` (
  `id_customer` bigint(20) NOT NULL AUTO_INCREMENT,
  `kode_customer` varchar(50) NOT NULL,
  `nama_customer` varchar(100) NOT NULL,
  `alamat_customer` varchar(100) NOT NULL,
  `id_kota` bigint(20) NOT NULL,
  `kodepos` varchar(50) NOT NULL,
  `telepon` varchar(50) NOT NULL,
  `handphone` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL,
  `nomorrekening` varchar(50) NOT NULL,
  `namabank` varchar(50) NOT NULL,
  `alamatbank` varchar(100) NOT NULL,
  `status_customer` int(11) NOT NULL DEFAULT '1',
  `user_update` varchar(50) NOT NULL,
  `date_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_customer`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `tbl_customer`
--

INSERT INTO `tbl_customer` (`id_customer`, `kode_customer`, `nama_customer`, `alamat_customer`, `id_kota`, `kodepos`, `telepon`, `handphone`, `email`, `nomorrekening`, `namabank`, `alamatbank`, `status_customer`, `user_update`, `date_update`) VALUES
(1, 'CUST1', 'aaa', 'aaa', 1, '1111', '2222', '333', '3333', '333', '3333', '333', 1, 'admin', '2014-05-22 08:20:45'),
(2, 'CUST2', 'bbb', 'bbbb', 1, '4444', '555', '6666', '7777', '888', '999', '0000', 1, 'admin', '2014-05-22 08:20:58');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_diamonds`
--

DROP TABLE IF EXISTS `tbl_diamonds`;
CREATE TABLE IF NOT EXISTS `tbl_diamonds` (
  `id_diamonds` bigint(20) NOT NULL AUTO_INCREMENT,
  `diamonds` varchar(100) NOT NULL,
  `keterangan` varchar(100) NOT NULL,
  `price` bigint(20) NOT NULL,
  `user_update` varchar(50) NOT NULL,
  `date_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_diamonds`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `tbl_diamonds`
--

INSERT INTO `tbl_diamonds` (`id_diamonds`, `diamonds`, `keterangan`, `price`, `user_update`, `date_update`) VALUES
(1, 'Minus 2', '0.001 - 0.008ct', 680, 'admin', '2014-03-10 23:00:11'),
(2, 'Stars', '0.01 - 0.02ct', 750, 'admin', '2014-03-10 23:00:27'),
(3, 'Melee', '0.025 - 0.075ct', 750, 'admin', '2014-03-10 22:59:58'),
(4, '10pointers', '0.08 - 0.13ct', 900, 'admin', '2014-03-10 22:58:05'),
(5, '15pointers', '0.14 - 0.17ct', 1100, 'admin', '2014-03-10 22:58:25'),
(6, '20pointers', '0.18 - 0.23ct', 1250, 'admin', '2014-03-10 22:58:41'),
(7, '25pointers', '0.24 - 0.27ct', 1400, 'admin', '2014-03-10 22:58:50'),
(8, '30pointers', '0.28 - 0.39ct', 1900, 'admin', '2014-03-10 22:59:00'),
(9, '40pointers', '0.40 - 0.49ct', 2400, 'admin', '2014-03-10 22:59:28'),
(10, '50pointers', '0.50 - 0.59ct', 3200, 'admin', '2014-03-10 22:59:45');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_gold`
--

DROP TABLE IF EXISTS `tbl_gold`;
CREATE TABLE IF NOT EXISTS `tbl_gold` (
  `id_gold` bigint(20) NOT NULL AUTO_INCREMENT,
  `usd` float(32,2) NOT NULL,
  `user_update` varchar(50) NOT NULL,
  `date_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_gold`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `tbl_gold`
--

INSERT INTO `tbl_gold` (`id_gold`, `usd`, `user_update`, `date_update`) VALUES
(1, 50.00, 'admin', '2014-05-04 16:35:08');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_indicator`
--

DROP TABLE IF EXISTS `tbl_indicator`;
CREATE TABLE IF NOT EXISTS `tbl_indicator` (
  `green` int(11) NOT NULL,
  `red` int(11) NOT NULL,
  `user_update` varchar(50) NOT NULL,
  `date_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_indicator`
--


-- --------------------------------------------------------

--
-- Table structure for table `tbl_kota`
--

DROP TABLE IF EXISTS `tbl_kota`;
CREATE TABLE IF NOT EXISTS `tbl_kota` (
  `id_kota` bigint(20) NOT NULL AUTO_INCREMENT,
  `kode_kota` varchar(50) NOT NULL,
  `nama_kota` varchar(100) NOT NULL,
  `id_provinsi` bigint(20) NOT NULL,
  `status_kota` int(11) NOT NULL DEFAULT '1',
  `user_update` varchar(50) NOT NULL,
  `date_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_kota`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `tbl_kota`
--

INSERT INTO `tbl_kota` (`id_kota`, `kode_kota`, `nama_kota`, `id_provinsi`, `status_kota`, `user_update`, `date_update`) VALUES
(1, 'KOTA1', 'JKT', 1, 1, 'admin', '2014-03-22 17:02:53'),
(2, 'KOTA2', 'BANDUNG', 1, 1, 'admin', '2014-05-22 08:46:41');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_payment`
--

DROP TABLE IF EXISTS `tbl_payment`;
CREATE TABLE IF NOT EXISTS `tbl_payment` (
  `id_payment` bigint(20) NOT NULL AUTO_INCREMENT,
  `kode_payment` varchar(50) NOT NULL,
  `nama_payment` varchar(50) NOT NULL,
  `id_term` int(11) NOT NULL,
  `user_update` varchar(50) NOT NULL,
  `date_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_payment`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tbl_payment`
--


-- --------------------------------------------------------

--
-- Table structure for table `tbl_priviledge`
--

DROP TABLE IF EXISTS `tbl_priviledge`;
CREATE TABLE IF NOT EXISTS `tbl_priviledge` (
  `user_id` varchar(50) NOT NULL,
  `id_application` int(11) NOT NULL,
  `ubah` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_priviledge`
--

INSERT INTO `tbl_priviledge` (`user_id`, `id_application`, `ubah`) VALUES
('admin', 44, 0),
('admin', 43, 0),
('admin', 42, 0),
('admin', 41, 0),
('admin', 40, 0),
('admin', 39, 0),
('admin', 38, 0),
('admin', 37, 0),
('admin', 36, 0),
('admin', 35, 0),
('admin', 34, 0),
('admin', 33, 0),
('admin', 32, 0),
('admin', 31, 0),
('admin', 30, 0),
('admin', 29, 0),
('admin', 28, 0),
('admin', 27, 0),
('admin', 26, 0),
('admin', 25, 0),
('admin', 24, 0),
('admin', 23, 0),
('admin', 22, 0),
('admin', 21, 0),
('admin', 20, 0),
('admin', 19, 0),
('admin', 18, 0),
('admin', 17, 0),
('admin', 16, 0),
('admin', 15, 0),
('admin', 14, 0),
('admin', 13, 0),
('admin', 12, 0),
('admin', 11, 0),
('admin', 10, 0),
('admin', 9, 0),
('admin', 8, 0),
('admin', 7, 0),
('admin', 6, 0),
('admin', 5, 0),
('admin', 4, 0),
('admin', 3, 0),
('admin', 2, 0),
('admin', 1, 0),
('admin', 45, 0);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_provinsi`
--

DROP TABLE IF EXISTS `tbl_provinsi`;
CREATE TABLE IF NOT EXISTS `tbl_provinsi` (
  `id_provinsi` bigint(20) NOT NULL AUTO_INCREMENT,
  `kode_provinsi` varchar(50) NOT NULL,
  `nama_provinsi` varchar(100) NOT NULL,
  `status_provinsi` int(11) NOT NULL DEFAULT '1',
  `user_update` varchar(50) NOT NULL,
  `date_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_provinsi`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `tbl_provinsi`
--

INSERT INTO `tbl_provinsi` (`id_provinsi`, `kode_provinsi`, `nama_provinsi`, `status_provinsi`, `user_update`, `date_update`) VALUES
(1, 'COUNTRY1', 'IDN', 1, 'admin', '2014-03-22 17:02:30');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_shape`
--

DROP TABLE IF EXISTS `tbl_shape`;
CREATE TABLE IF NOT EXISTS `tbl_shape` (
  `id_shape` int(11) NOT NULL AUTO_INCREMENT,
  `kode_shape` varchar(50) NOT NULL,
  `nama_shape` varchar(50) NOT NULL,
  `user_update` varchar(50) NOT NULL,
  `date_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_shape`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `tbl_shape`
--

INSERT INTO `tbl_shape` (`id_shape`, `kode_shape`, `nama_shape`, `user_update`, `date_update`) VALUES
(1, 'SHAPE1', 'Round', 'admin', '2012-12-29 21:02:58'),
(2, 'SHAPE2', 'Princess', 'admin', '2012-12-29 21:03:19'),
(3, 'SHAPE3', 'Marquise', 'admin', '2012-12-29 21:03:30'),
(4, 'SHAPE4', 'Heart', 'admin', '2012-12-29 21:03:39'),
(5, 'SHAPE5', 'Oval', 'admin', '2012-12-29 21:03:49'),
(6, 'SHAPE6', 'Pear', 'admin', '2012-12-29 21:03:58'),
(7, 'SHAPE7', 'Ashl', 'admin', '2012-12-29 21:04:06'),
(8, 'SHAPE8', 'Cushion', 'admin', '2012-12-29 21:23:50');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_status`
--

DROP TABLE IF EXISTS `tbl_status`;
CREATE TABLE IF NOT EXISTS `tbl_status` (
  `id_status` int(11) NOT NULL AUTO_INCREMENT,
  `status` varchar(50) NOT NULL,
  PRIMARY KEY (`id_status`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `tbl_status`
--

INSERT INTO `tbl_status` (`id_status`, `status`) VALUES
(1, 'Titipan'),
(2, 'Consigment'),
(3, 'In Stock'),
(4, 'Sold'),
(5, 'On Hold'),
(6, 'Cancel');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_supplier`
--

DROP TABLE IF EXISTS `tbl_supplier`;
CREATE TABLE IF NOT EXISTS `tbl_supplier` (
  `id_supplier` bigint(20) NOT NULL AUTO_INCREMENT,
  `kode_supplier` varchar(50) NOT NULL,
  `nama_supplier` varchar(100) NOT NULL,
  `alamat_supplier` varchar(100) NOT NULL,
  `id_kota` bigint(20) NOT NULL,
  `kodepos` varchar(50) NOT NULL,
  `telepon` varchar(50) NOT NULL,
  `handphone` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL,
  `nomorrekening` varchar(50) NOT NULL,
  `namabank` varchar(50) NOT NULL,
  `alamatbank` varchar(100) NOT NULL,
  `status_supplier` int(11) NOT NULL DEFAULT '1',
  `user_update` varchar(50) NOT NULL,
  `date_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_supplier`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `tbl_supplier`
--

INSERT INTO `tbl_supplier` (`id_supplier`, `kode_supplier`, `nama_supplier`, `alamat_supplier`, `id_kota`, `kodepos`, `telepon`, `handphone`, `email`, `nomorrekening`, `namabank`, `alamatbank`, `status_supplier`, `user_update`, `date_update`) VALUES
(1, 'SUP1', 'ASDF', 'ASD', 1, 'sds', 'sds', 'sds', 'sds', 'sds', '', '', 1, 'admin', '2014-03-22 17:03:33');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_term`
--

DROP TABLE IF EXISTS `tbl_term`;
CREATE TABLE IF NOT EXISTS `tbl_term` (
  `id_term` int(11) NOT NULL AUTO_INCREMENT,
  `term` varchar(100) NOT NULL,
  PRIMARY KEY (`id_term`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `tbl_term`
--

INSERT INTO `tbl_term` (`id_term`, `term`) VALUES
(1, 'Payment Method Transfer'),
(2, 'Cicilan Sumatra'),
(3, 'Retur');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_time`
--

DROP TABLE IF EXISTS `tbl_time`;
CREATE TABLE IF NOT EXISTS `tbl_time` (
  `time` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_time`
--

INSERT INTO `tbl_time` (`time`) VALUES
(0),
(1),
(2),
(3),
(4),
(5),
(6),
(7),
(8),
(9),
(10),
(11),
(12),
(13),
(14),
(15),
(16),
(17),
(18),
(19),
(20),
(21),
(22),
(23);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_type`
--

DROP TABLE IF EXISTS `tbl_type`;
CREATE TABLE IF NOT EXISTS `tbl_type` (
  `id_type` bigint(20) NOT NULL AUTO_INCREMENT,
  `kode_type` varchar(50) NOT NULL,
  `nama_type` varchar(50) NOT NULL,
  `user_update` varchar(50) NOT NULL,
  `date_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_type`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `tbl_type`
--

INSERT INTO `tbl_type` (`id_type`, `kode_type`, `nama_type`, `user_update`, `date_update`) VALUES
(1, 'CTYPE1', 'None', 'admin', '2012-12-29 21:45:59'),
(2, 'CTYPE2', 'GIA', 'admin', '2012-12-29 21:46:06'),
(3, 'CTYPE3', 'HRD', 'admin', '2012-12-29 21:46:12'),
(4, 'CTYPE4', 'IGI', 'admin', '2012-12-29 21:48:27');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_usd`
--

DROP TABLE IF EXISTS `tbl_usd`;
CREATE TABLE IF NOT EXISTS `tbl_usd` (
  `id_usd` bigint(20) NOT NULL AUTO_INCREMENT,
  `usd` float(32,2) NOT NULL,
  `user_update` varchar(50) NOT NULL,
  `date_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_usd`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `tbl_usd`
--

INSERT INTO `tbl_usd` (`id_usd`, `usd`, `user_update`, `date_update`) VALUES
(1, 100000.00, 'test', '2014-05-11 15:21:30'),
(2, 199999.00, 'test', '2014-05-11 15:21:45'),
(3, 44444.00, 'test', '2014-05-11 15:22:03');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_workingtime`
--

DROP TABLE IF EXISTS `tbl_workingtime`;
CREATE TABLE IF NOT EXISTS `tbl_workingtime` (
  `id_branch` bigint(20) NOT NULL,
  `timestart` int(11) NOT NULL,
  `timefinish` int(11) NOT NULL,
  `user_update` varchar(50) NOT NULL,
  `date_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_workingtime`
--

INSERT INTO `tbl_workingtime` (`id_branch`, `timestart`, `timefinish`, `user_update`, `date_update`) VALUES
(1, 2, 24, 'test', '2014-05-23 12:47:09');

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