text: -- phpMyAdmin SQL Dump
  -- version 4.1.12
  -- http://www.phpmyadmin.net
  --
  -- Host: 127.0.0.1
  -- Generation Time: Nov 17, 2017 at 05:19 AM
  -- Server version: 5.6.16
  -- PHP Version: 5.5.11
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  SET time_zone = "+00:00";
  
  
  /*!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: `db_camapppos_2`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `phppos_app_config`
  --
  
  CREATE TABLE IF NOT EXISTS `phppos_app_config` (
    `key` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `value` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    PRIMARY KEY (`key`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `phppos_app_config`
  --
  
  INSERT INTO `phppos_app_config` (`key`, `value`) VALUES
  ('additional_payment_types', '100'),
  ('address', '123 Nowhere street '),
  ('company', 'PHP Point Of Sale, Inc'),
  ('company_logo', '0'),
  ('currency_symbol', '$'),
  ('date_format', 'middle_endian'),
  ('default_tax_1_name', 'Sales Tax'),
  ('default_tax_1_rate', ''),
  ('default_tax_2_cumulative', '0'),
  ('default_tax_2_name', 'Sales Tax 2'),
  ('default_tax_2_rate', ''),
  ('default_tax_rate', '8'),
  ('email', 'bunthoeun@gmail.com'),
  ('email_host', 'ssl://smtp.gmail.com'),
  ('email_port', '465'),
  ('email_send', 'makejonh4@gmail.com'),
  ('fax', '555-555-5555'),
  ('hide_suspended_sales_in_reports', '0'),
  ('language', 'khmer'),
  ('mailchimp_api_key', '0'),
  ('number_of_items_per_page', '20'),
  ('password_send', '14111993ABC'),
  ('phone', '555-555-5555'),
  ('print_after_sale', '1'),
  ('return_policy', 'Thanks You!'),
  ('speed_up_search_queries', '0'),
  ('time_format', '12_hour'),
  ('timezone', 'Asia/Bangkok'),
  ('track_cash', '0'),
  ('website', 'www.pos.com.kh');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `phppos_app_files`
  --
  
  CREATE TABLE IF NOT EXISTS `phppos_app_files` (
    `file_id` int(10) NOT NULL AUTO_INCREMENT,
    `file_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `file_data` longblob NOT NULL,
    PRIMARY KEY (`file_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `phppos_customers`
  --
  
  CREATE TABLE IF NOT EXISTS `phppos_customers` (
    `person_id` int(10) NOT NULL,
    `account_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `company_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `taxable` int(1) NOT NULL DEFAULT '1',
    `deleted` int(1) NOT NULL DEFAULT '0',
    UNIQUE KEY `account_number` (`account_number`),
    KEY `person_id` (`person_id`),
    KEY `deleted` (`deleted`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `phppos_customers`
  --
  
  INSERT INTO `phppos_customers` (`person_id`, `account_number`, `company_name`, `taxable`, `deleted`) VALUES
  (27, NULL, '', 1, 0),
  (29, NULL, '', 1, 0);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `phppos_employees`
  --
  
  CREATE TABLE IF NOT EXISTS `phppos_employees` (
    `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `person_id` int(10) NOT NULL,
    `deleted` int(1) NOT NULL DEFAULT '0',
    UNIQUE KEY `username` (`username`),
    KEY `person_id` (`person_id`),
    KEY `deleted` (`deleted`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `phppos_employees`
  --
  
  INSERT INTO `phppos_employees` (`username`, `password`, `person_id`, `deleted`) VALUES
  ('admin', '21232f297a57a5a743894a0e4a801fc3', 1, 0),
  ('dollariya', 'e10adc3949ba59abbe56e057f20f883e', 30, 0);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `phppos_exchange_rate`
  --
  
  CREATE TABLE IF NOT EXISTS `phppos_exchange_rate` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `reil` decimal(18,2) NOT NULL DEFAULT '4000.00',
    `dollar` decimal(18,2) NOT NULL DEFAULT '1.00',
    `deleted` int(1) NOT NULL DEFAULT '0',
    `date` date DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=10 ;
  
  --
  -- Dumping data for table `phppos_exchange_rate`
  --
  
  INSERT INTO `phppos_exchange_rate` (`id`, `reil`, `dollar`, `deleted`, `date`) VALUES
  (1, '4000.00', '1.00', 1, '2017-10-30'),
  (9, '4000.00', '1.00', 0, '2017-11-13');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `phppos_expense`
  --
  
  CREATE TABLE IF NOT EXISTS `phppos_expense` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `expense_type` varchar(255) DEFAULT NULL,
    `expense_date` date NOT NULL,
    `expense_status` varchar(100) NOT NULL,
    `customer_id` int(11) NOT NULL,
    `expense_title` varchar(255) NOT NULL,
    `check_paper` varchar(255) NOT NULL,
    `type_money` varchar(200) NOT NULL,
    `payment_id` varchar(100) NOT NULL,
    `total_expense` decimal(18,2) NOT NULL,
    `note` text NOT NULL,
    `status` int(1) NOT NULL DEFAULT '1',
    `employee_id` int(11) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `deleted` int(1) DEFAULT '0',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
  
  --
  -- Dumping data for table `phppos_expense`
  --
  
  INSERT INTO `phppos_expense` (`id`, `expense_type`, `expense_date`, `expense_status`, `customer_id`, `expense_title`, `check_paper`, `type_money`, `payment_id`, `total_expense`, `note`, `status`, `employee_id`, `created_at`, `updated_at`, `deleted`) VALUES
  (9, 'Spend Money', '2017-11-13', '', 0, 'chay leng', '', 'Cash', 'exp000000001', '300.00', '', 1, 1, NULL, NULL, 0);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `phppos_giftcards`
  --
  
  CREATE TABLE IF NOT EXISTS `phppos_giftcards` (
    `giftcard_id` int(11) NOT NULL AUTO_INCREMENT,
    `giftcard_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `value` decimal(15,2) NOT NULL,
    `customer_id` int(10) DEFAULT NULL,
    `deleted` int(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`giftcard_id`),
    UNIQUE KEY `giftcard_number` (`giftcard_number`),
    KEY `deleted` (`deleted`),
    KEY `phppos_giftcards_ibfk_1` (`customer_id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
  
  --
  -- Dumping data for table `phppos_giftcards`
  --
  
  INSERT INTO `phppos_giftcards` (`giftcard_id`, `giftcard_number`, `value`, `customer_id`, `deleted`) VALUES
  (4, '09877655432', '7.00', 27, 0);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `phppos_income`
  --
  
  CREATE TABLE IF NOT EXISTS `phppos_income` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `income_type` varchar(255) DEFAULT NULL,
    `income_date` date DEFAULT NULL,
    `income_status` varchar(100) DEFAULT NULL,
    `customer_id` int(11) DEFAULT NULL,
    `income_title` varchar(255) DEFAULT NULL,
    `check_paper` varchar(255) DEFAULT NULL,
    `type_money` varchar(200) DEFAULT NULL,
    `payment_id` varchar(100) DEFAULT NULL,
    `total_income` decimal(18,2) DEFAULT NULL,
    `note` text,
    `status` int(1) DEFAULT '1',
    `employee_id` int(11) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `deleted` int(1) DEFAULT '0',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
  
  --
  -- Dumping data for table `phppos_income`
  --
  
  INSERT INTO `phppos_income` (`id`, `income_type`, `income_date`, `income_status`, `customer_id`, `income_title`, `check_paper`, `type_money`, `payment_id`, `total_income`, `note`, `status`, `employee_id`, `created_at`, `updated_at`, `deleted`) VALUES
  (8, 'collect money', '2017-11-13', NULL, NULL, 'Leng ', '', 'Cash', 'inc000000001', '100.00', '', 1, 1, NULL, NULL, 0);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `phppos_inventory`
  --
  
  CREATE TABLE IF NOT EXISTS `phppos_inventory` (
    `trans_id` int(11) NOT NULL AUTO_INCREMENT,
    `trans_items` int(11) NOT NULL DEFAULT '0',
    `trans_user` int(11) NOT NULL DEFAULT '0',
    `trans_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `trans_comment` text COLLATE utf8_unicode_ci NOT NULL,
    `trans_inventory` decimal(15,2) NOT NULL DEFAULT '0.00',
    PRIMARY KEY (`trans_id`),
    KEY `phppos_inventory_ibfk_1` (`trans_items`),
    KEY `phppos_inventory_ibfk_2` (`trans_user`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=473 ;
  
  --
  -- Dumping data for table `phppos_inventory`
  --
  
  INSERT INTO `phppos_inventory` (`trans_id`, `trans_items`, `trans_user`, `trans_date`, `trans_comment`, `trans_inventory`) VALUES
  (1, 1, 1, '2013-03-21 02:12:47', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '1477.50'),
  (2, 1, 1, '2013-03-21 02:14:27', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '-1477.50'),
  (3, 1, 1, '2013-03-21 02:17:21', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (4, 1, 1, '2013-03-27 06:50:17', 'Manual Edit of Quantity', '0.00'),
  (5, 1, 1, '2013-03-27 06:50:32', 'Manual Edit of Quantity', '10.00'),
  (6, 1, 1, '2013-03-27 06:50:42', 'Manual Edit of Quantity', '-10.00'),
  (7, 2, 1, '2013-03-28 02:25:50', 'Manual Edit of Quantity', '1370.20'),
  (8, 1, 1, '2013-03-28 02:26:28', 'Manual Edit of Quantity', '1477.50'),
  (9, 1, 1, '2013-03-28 02:27:08', 'Manual Edit of Quantity', '0.00'),
  (10, 2, 1, '2013-03-28 02:27:27', 'Manual Edit of Quantity', '0.00'),
  (11, 3, 1, '2013-03-28 02:28:37', 'Manual Edit of Quantity', '5213.10'),
  (12, 1, 1, '2013-03-28 02:29:08', 'Manual Edit of Quantity', '0.00'),
  (13, 4, 1, '2013-03-28 02:57:00', 'Manual Edit of Quantity', '12873.00'),
  (14, 5, 1, '2013-03-28 02:58:25', 'Manual Edit of Quantity', '12873.00'),
  (15, 6, 1, '2013-03-28 03:04:19', 'Manual Edit of Quantity', '3515.50'),
  (16, 7, 1, '2013-03-28 03:05:52', 'Manual Edit of Quantity', '7491.00'),
  (17, 8, 1, '2013-03-28 03:07:44', 'Manual Edit of Quantity', '2771.80'),
  (18, 7, 1, '2013-03-28 03:08:32', 'Manual Edit of Quantity', '0.00'),
  (19, 6, 1, '2013-03-28 03:08:48', 'Manual Edit of Quantity', '0.00'),
  (20, 9, 1, '2013-03-28 03:13:40', 'Manual Edit of Quantity', '819.00'),
  (21, 10, 1, '2013-03-28 03:24:31', 'Manual Edit of Quantity', '2541.80'),
  (22, 11, 1, '2013-03-28 03:27:07', 'Manual Edit of Quantity', '27.00'),
  (23, 12, 1, '2013-03-28 03:32:52', 'Manual Edit of Quantity', '9804.70'),
  (24, 13, 1, '2013-03-28 03:40:54', 'Manual Edit of Quantity', '8567.70'),
  (25, 14, 1, '2013-03-28 03:45:15', 'Manual Edit of Quantity', '910.30'),
  (26, 15, 1, '2013-03-28 03:47:23', 'Manual Edit of Quantity', '31.00'),
  (27, 15, 1, '2013-03-28 03:47:45', 'Manual Edit of Quantity', '3102.40'),
  (28, 16, 1, '2013-03-28 03:49:22', 'Manual Edit of Quantity', '4.00'),
  (29, 16, 1, '2013-03-28 03:49:46', 'Manual Edit of Quantity', '4374.20'),
  (30, 17, 1, '2013-03-28 03:52:08', 'Manual Edit of Quantity', '4270.63'),
  (31, 18, 1, '2013-03-28 03:54:40', 'Manual Edit of Quantity', '2942.70'),
  (32, 19, 1, '2013-03-28 03:55:55', 'Manual Edit of Quantity', '3972.10'),
  (33, 20, 1, '2013-03-28 03:57:39', 'Manual Edit of Quantity', '715.10'),
  (34, 21, 1, '2013-03-28 03:59:52', 'Manual Edit of Quantity', '1688.00'),
  (35, 21, 1, '2013-03-28 04:00:23', 'Manual Edit of Quantity', '0.00'),
  (36, 22, 1, '2013-03-28 04:01:33', 'Manual Edit of Quantity', '194.00'),
  (37, 23, 1, '2013-03-28 04:02:45', 'Manual Edit of Quantity', '666.90'),
  (38, 24, 1, '2013-03-28 04:04:16', 'Manual Edit of Quantity', '92.00'),
  (39, 25, 1, '2013-03-28 04:05:42', 'Manual Edit of Quantity', '1300.90'),
  (40, 26, 1, '2013-03-28 04:06:25', 'Manual Edit of Quantity', '173.50'),
  (41, 27, 1, '2013-03-28 04:07:21', 'Manual Edit of Quantity', '231.00'),
  (42, 28, 1, '2013-03-28 04:08:10', 'Manual Edit of Quantity', '105.50'),
  (43, 29, 1, '2013-03-28 04:09:36', 'Manual Edit of Quantity', '813.40'),
  (44, 30, 1, '2013-03-28 04:10:36', 'Manual Edit of Quantity', '207.70'),
  (45, 31, 1, '2013-03-28 04:12:05', 'Manual Edit of Quantity', '334.40'),
  (46, 32, 1, '2013-03-28 04:12:46', 'Manual Edit of Quantity', '227.00'),
  (47, 33, 1, '2013-03-28 04:13:55', 'Manual Edit of Quantity', '308.50'),
  (48, 34, 1, '2013-03-28 04:14:48', 'Manual Edit of Quantity', '3069.00'),
  (49, 35, 1, '2013-03-28 04:15:29', 'Manual Edit of Quantity', '417.00'),
  (50, 36, 1, '2013-03-28 04:17:03', 'Manual Edit of Quantity', '4845.50'),
  (51, 37, 1, '2013-03-28 04:17:52', 'Manual Edit of Quantity', '1849.70'),
  (52, 38, 1, '2013-03-28 04:18:46', 'Manual Edit of Quantity', '2486.30'),
  (53, 37, 1, '2013-03-28 04:19:24', 'Manual Edit of Quantity', '0.00'),
  (54, 39, 1, '2013-03-28 04:20:04', 'Manual Edit of Quantity', '556.00'),
  (55, 40, 1, '2013-03-28 04:21:13', 'Manual Edit of Quantity', '5010.60'),
  (56, 41, 1, '2013-03-28 04:23:01', 'Manual Edit of Quantity', '798.50'),
  (57, 42, 1, '2013-03-28 04:24:03', 'Manual Edit of Quantity', '388.30'),
  (58, 43, 1, '2013-03-28 04:26:10', 'Manual Edit of Quantity', '3739.50'),
  (59, 44, 1, '2013-03-28 04:27:11', 'Manual Edit of Quantity', '608.00'),
  (60, 45, 1, '2013-03-28 04:28:23', 'Manual Edit of Quantity', '474.50'),
  (61, 46, 1, '2013-03-28 04:29:00', 'Manual Edit of Quantity', '2925.00'),
  (62, 47, 1, '2013-03-28 04:33:21', 'Manual Edit of Quantity', '1893.40'),
  (63, 48, 1, '2013-03-28 04:34:00', 'Manual Edit of Quantity', '9748.00'),
  (64, 49, 1, '2013-03-28 04:34:55', 'Manual Edit of Quantity', '2894.70'),
  (65, 50, 1, '2013-03-28 04:36:24', 'Manual Edit of Quantity', '267.80'),
  (66, 51, 1, '2013-03-28 04:36:56', 'Manual Edit of Quantity', '329.00'),
  (67, 52, 1, '2013-03-28 04:37:38', 'Manual Edit of Quantity', '2429.00'),
  (68, 53, 1, '2013-03-28 04:38:46', 'Manual Edit of Quantity', '5242.00'),
  (69, 54, 1, '2013-03-28 04:39:28', 'Manual Edit of Quantity', '244.50'),
  (70, 55, 1, '2013-03-28 04:40:08', 'Manual Edit of Quantity', '378.00'),
  (71, 56, 1, '2013-03-28 04:41:04', 'Manual Edit of Quantity', '1267.80'),
  (72, 57, 1, '2013-03-28 04:43:21', 'Manual Edit of Quantity', '2416.30'),
  (73, 58, 1, '2013-03-28 04:45:27', 'Manual Edit of Quantity', '9724.60'),
  (74, 59, 1, '2013-03-28 04:46:20', 'Manual Edit of Quantity', '242.60'),
  (75, 60, 1, '2013-03-28 04:48:25', 'Manual Edit of Quantity', '2037.40'),
  (76, 61, 1, '2013-03-28 04:50:42', 'Manual Edit of Quantity', '12105.30'),
  (77, 62, 1, '2013-03-28 04:52:58', 'Manual Edit of Quantity', '1270.36'),
  (78, 63, 1, '2013-03-28 04:56:26', 'Manual Edit of Quantity', '567.00'),
  (79, 64, 1, '2013-03-28 04:59:30', 'Manual Edit of Quantity', '6653.00'),
  (80, 65, 1, '2013-03-28 05:02:00', 'Manual Edit of Quantity', '11430.00'),
  (81, 66, 1, '2013-03-28 05:03:30', 'Manual Edit of Quantity', '2414.00'),
  (82, 67, 1, '2013-03-28 05:05:58', 'Manual Edit of Quantity', '2894.50'),
  (83, 68, 1, '2013-03-28 05:08:41', 'Manual Edit of Quantity', '365.60'),
  (84, 69, 1, '2013-03-28 05:10:06', 'Manual Edit of Quantity', '2081.20'),
  (85, 70, 1, '2013-03-28 05:11:25', 'Manual Edit of Quantity', '6449.50'),
  (86, 71, 1, '2013-03-28 05:12:31', 'Manual Edit of Quantity', '566.50'),
  (87, 72, 1, '2013-03-28 05:13:40', 'Manual Edit of Quantity', '644.28'),
  (88, 73, 1, '2013-03-28 05:16:58', 'Manual Edit of Quantity', '10240.20'),
  (89, 74, 1, '2013-03-28 05:18:56', 'Manual Edit of Quantity', '1976.40'),
  (90, 75, 1, '2013-03-28 05:20:27', 'Manual Edit of Quantity', '2569.90'),
  (91, 76, 1, '2013-03-28 05:21:32', 'Manual Edit of Quantity', '13203.10'),
  (92, 77, 1, '2013-03-28 05:24:25', 'Manual Edit of Quantity', '4551.50'),
  (93, 78, 1, '2013-03-28 05:25:33', 'Manual Edit of Quantity', '4010.90'),
  (94, 79, 1, '2013-03-28 05:27:23', 'Manual Edit of Quantity', '6154.50'),
  (95, 80, 1, '2013-03-28 05:29:41', 'Manual Edit of Quantity', '8302.08'),
  (96, 81, 1, '2013-03-28 05:31:15', 'Manual Edit of Quantity', '1741.40'),
  (97, 81, 1, '2013-03-28 09:45:55', 'Manual Edit of Quantity', '0.00'),
  (98, 81, 1, '2013-03-28 09:46:39', 'POS 1', '-53.00'),
  (99, 45, 1, '2013-03-29 03:46:51', 'POS 2', '-100.00'),
  (100, 45, 1, '2013-03-29 03:48:24', 'POS 2', '100.00'),
  (101, 45, 1, '2013-03-29 03:48:25', 'POS 2', '-100.00'),
  (102, 81, 1, '2013-03-29 04:12:17', 'POS 1', '53.00'),
  (103, 81, 1, '2013-03-29 04:12:17', 'POS 1', '-53.00'),
  (104, 14, 1, '2013-03-29 04:47:54', 'POS 3', '-100.00'),
  (105, 14, 1, '2013-03-29 04:57:16', 'POS 3', '100.00'),
  (106, 14, 1, '2013-03-29 04:57:16', 'POS 3', '-100.00'),
  (107, 45, 1, '2013-03-29 06:31:50', 'POS 2', '100.00'),
  (108, 45, 1, '2013-03-29 06:31:50', 'POS 2', '-100.00'),
  (109, 45, 3, '2013-03-29 07:57:45', 'POS 2', '100.00'),
  (110, 45, 3, '2013-03-29 07:57:46', 'POS 2', '-100.00'),
  (111, 45, 3, '2013-03-29 07:58:52', 'POS 2', '100.00'),
  (112, 45, 3, '2013-03-29 07:58:52', 'POS 2', '-100.00'),
  (113, 45, 3, '2013-03-29 08:11:18', 'POS 2', '100.00'),
  (114, 45, 3, '2013-03-29 08:11:18', 'POS 2', '-100.00'),
  (115, 45, 3, '2013-03-29 08:12:41', 'POS 2', '100.00'),
  (116, 45, 3, '2013-03-29 08:12:41', 'POS 2', '-100.00'),
  (117, 45, 3, '2013-03-29 08:32:48', 'POS 2', '100.00'),
  (118, 45, 3, '2013-03-29 08:32:48', 'POS 2', '-100.00'),
  (119, 45, 3, '2013-03-29 08:56:13', 'POS 2', '100.00'),
  (120, 45, 3, '2013-03-29 08:56:14', 'POS 2', '-100.00'),
  (121, 14, 3, '2013-03-29 08:57:45', 'POS 3', '100.00'),
  (122, 14, 3, '2013-03-29 08:57:45', 'POS 3', '-100.00'),
  (123, 14, 3, '2013-03-29 08:58:39', 'POS 3', '100.00'),
  (124, 14, 3, '2013-03-29 08:58:39', 'POS 3', '-100.00'),
  (125, 45, 3, '2013-03-29 09:04:27', 'POS 4', '-1.00'),
  (126, 16, 3, '2013-03-29 09:53:23', 'POS 5', '-1.00'),
  (127, 42, 3, '2013-04-01 04:03:03', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (128, 42, 3, '2013-04-01 04:03:35', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (129, 42, 3, '2013-04-01 04:07:10', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (130, 39, 3, '2013-04-01 04:07:43', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (131, 39, 3, '2013-04-01 04:08:51', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (132, 39, 3, '2013-04-01 04:13:38', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (133, 42, 3, '2013-04-01 04:15:11', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (134, 42, 3, '2013-04-01 04:23:55', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (135, 42, 3, '2013-04-01 04:31:00', 'Manual Edit of Quantity', '0.00'),
  (136, 42, 3, '2013-04-01 04:31:09', 'Manual Edit of Quantity', '0.00'),
  (137, 42, 3, '2013-04-01 04:31:20', 'Manual Edit of Quantity', '0.00'),
  (138, 42, 3, '2013-04-01 04:31:39', 'Manual Edit of Quantity', '0.00'),
  (139, 42, 3, '2013-04-01 04:32:25', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (140, 42, 3, '2013-04-01 04:35:02', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (141, 42, 3, '2013-04-01 04:37:19', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (142, 42, 3, '2013-04-01 04:39:41', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (143, 42, 3, '2013-04-01 04:40:42', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (144, 42, 3, '2013-04-01 04:41:38', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (145, 42, 3, '2013-04-01 04:42:28', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (146, 42, 3, '2013-04-01 04:42:57', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (147, 42, 3, '2013-04-01 04:48:47', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (148, 42, 3, '2013-04-01 04:54:51', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (149, 42, 3, '2013-04-01 05:01:40', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (150, 42, 3, '2013-04-01 05:04:27', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (151, 39, 3, '2013-04-01 05:04:37', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (152, 73, 3, '2013-04-01 05:04:43', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (153, 14, 3, '2013-04-01 05:04:49', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (154, 42, 3, '2013-04-01 05:05:12', 'Manual Edit of Quantity', '0.00'),
  (155, 39, 3, '2013-04-01 05:05:17', 'Manual Edit of Quantity', '0.00'),
  (156, 42, 3, '2013-04-01 05:11:16', 'Manual Edit of Quantity', '0.00'),
  (157, 42, 3, '2013-04-01 05:11:41', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (158, 42, 3, '2013-04-01 05:15:12', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (159, 42, 3, '2013-04-01 05:15:37', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (160, 42, 3, '2013-04-01 05:17:27', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (161, 42, 3, '2013-04-01 05:18:23', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (162, 42, 3, '2013-04-01 05:19:37', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (163, 42, 3, '2013-04-01 06:06:37', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (164, 42, 3, '2013-04-01 06:19:12', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (165, 42, 3, '2013-04-01 06:29:39', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (166, 42, 3, '2013-04-01 06:30:15', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (167, 42, 3, '2013-04-01 06:30:37', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (168, 42, 3, '2013-04-01 06:35:06', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (169, 42, 3, '2013-04-01 06:35:36', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (170, 42, 3, '2013-04-01 06:36:19', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (171, 42, 3, '2013-04-01 06:42:49', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (172, 42, 3, '2013-04-01 06:47:13', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (173, 42, 3, '2013-04-01 06:47:27', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (174, 39, 3, '2013-04-01 06:47:35', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (175, 45, 3, '2013-04-01 06:47:41', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (176, 73, 3, '2013-04-01 06:47:48', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (177, 42, 3, '2013-04-01 06:48:26', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (178, 42, 3, '2013-04-01 06:52:44', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (179, 39, 3, '2013-04-01 06:52:54', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (180, 6, 3, '2013-04-01 06:53:00', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (181, 39, 3, '2013-04-01 06:54:18', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (182, 42, 3, '2013-04-01 06:55:08', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (183, 42, 3, '2013-04-01 06:57:02', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (184, 42, 3, '2013-04-01 06:57:24', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (185, 42, 3, '2013-04-01 06:58:59', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (186, 42, 3, '2013-04-01 06:59:45', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (187, 42, 3, '2013-04-01 07:00:25', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (188, 42, 3, '2013-04-01 07:01:37', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (189, 45, 3, '2013-04-01 07:01:46', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (190, 42, 3, '2013-04-01 07:02:02', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (191, 39, 3, '2013-04-01 07:02:36', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (192, 6, 3, '2013-04-01 07:03:07', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (193, 42, 3, '2013-04-01 07:03:33', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (194, 42, 3, '2013-04-01 07:04:28', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (195, 42, 3, '2013-04-01 07:05:33', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (196, 42, 3, '2013-04-01 07:08:04', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (197, 42, 3, '2013-04-01 07:08:35', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (198, 42, 3, '2013-04-01 07:11:00', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (199, 42, 3, '2013-04-01 07:26:30', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (200, 42, 3, '2013-04-01 07:38:36', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (201, 42, 3, '2013-04-01 07:39:18', 'Manual Edit of Quantity', '0.00'),
  (202, 39, 3, '2013-04-01 07:39:24', 'Manual Edit of Quantity', '0.00'),
  (203, 42, 3, '2013-04-01 07:39:32', 'Manual Edit of Quantity', '0.00'),
  (204, 42, 3, '2013-04-01 07:39:48', 'Manual Edit of Quantity', '0.00'),
  (205, 42, 3, '2013-04-01 07:40:26', 'Manual Edit of Quantity', '0.00'),
  (206, 42, 3, '2013-04-01 07:40:52', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (207, 42, 3, '2013-04-01 07:42:15', 'Edición Manual de Cantidad', '0.00'),
  (208, 39, 3, '2013-04-01 07:42:20', 'Edición Manual de Cantidad', '0.00'),
  (209, 42, 3, '2013-04-01 07:42:40', 'Panduan Edit Jumlah', '0.00'),
  (210, 42, 3, '2013-04-01 07:43:00', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (211, 42, 3, '2013-04-01 07:46:13', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (212, 42, 3, '2013-04-01 07:46:25', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (213, 42, 3, '2013-04-01 07:50:15', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (214, 42, 3, '2013-04-01 07:50:34', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (215, 42, 3, '2013-04-01 07:52:00', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (216, 42, 3, '2013-04-01 07:52:54', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (217, 45, 3, '2013-04-01 07:53:04', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (218, 39, 3, '2013-04-01 07:53:10', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (219, 42, 3, '2013-04-01 07:54:02', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (220, 45, 3, '2013-04-01 07:54:28', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (221, 42, 3, '2013-04-01 07:55:19', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (222, 42, 3, '2013-04-01 07:55:46', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (223, 42, 3, '2013-04-01 08:00:24', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (224, 39, 3, '2013-04-01 08:00:38', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (225, 39, 3, '2013-04-01 08:01:00', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (226, 42, 3, '2013-04-01 08:01:44', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (227, 42, 3, '2013-04-01 08:09:10', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (228, 39, 3, '2013-04-01 08:10:02', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (229, 42, 3, '2013-04-01 08:10:40', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (230, 42, 3, '2013-04-01 08:14:27', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (231, 42, 3, '2013-04-01 08:15:08', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (232, 42, 3, '2013-04-01 08:17:25', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (233, 42, 3, '2013-04-01 08:20:54', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (234, 42, 3, '2013-04-01 08:21:35', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (235, 42, 3, '2013-04-01 08:25:01', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (236, 45, 3, '2013-04-01 08:25:10', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (237, 6, 3, '2013-04-01 08:25:20', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (238, 42, 3, '2013-04-01 08:25:41', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (239, 42, 3, '2013-04-01 08:27:20', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (240, 39, 3, '2013-04-01 08:27:30', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (241, 39, 3, '2013-04-01 08:27:46', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (242, 42, 3, '2013-04-01 08:30:38', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (243, 39, 3, '2013-04-01 08:30:47', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (244, 45, 3, '2013-04-01 08:30:52', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (245, 73, 3, '2013-04-01 08:30:56', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (246, 6, 3, '2013-04-01 08:30:59', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (247, 53, 3, '2013-04-01 08:31:02', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (248, 14, 3, '2013-04-01 08:31:04', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (249, 7, 3, '2013-04-01 08:31:08', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (250, 15, 3, '2013-04-01 08:31:14', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (251, 16, 3, '2013-04-01 08:31:20', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (252, 50, 3, '2013-04-01 08:31:27', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (253, 12, 3, '2013-04-01 08:31:30', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (254, 80, 3, '2013-04-01 08:31:32', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (255, 76, 3, '2013-04-01 08:31:35', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (256, 70, 3, '2013-04-01 08:31:38', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (257, 65, 3, '2013-04-01 08:31:41', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (258, 66, 3, '2013-04-01 08:31:44', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (259, 68, 3, '2013-04-01 08:31:47', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (260, 69, 3, '2013-04-01 08:31:50', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (261, 71, 3, '2013-04-01 08:31:54', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (262, 42, 3, '2013-04-01 08:32:49', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (263, 42, 3, '2013-04-01 08:35:25', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (264, 42, 3, '2013-04-01 08:36:16', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (265, 42, 3, '2013-04-01 08:37:28', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (266, 42, 3, '2013-04-01 08:47:54', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (267, 42, 3, '2013-04-01 08:48:20', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (268, 42, 3, '2013-04-01 08:51:00', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (269, 42, 3, '2013-04-01 08:52:05', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (270, 39, 3, '2013-04-01 08:52:13', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (271, 42, 3, '2013-04-01 08:52:26', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (272, 42, 3, '2013-04-01 08:53:48', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (273, 42, 3, '2013-04-01 08:54:36', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (274, 42, 3, '2013-04-01 08:55:59', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (275, 42, 3, '2013-04-01 08:56:51', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (276, 42, 3, '2013-04-01 08:57:26', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (277, 42, 3, '2013-04-01 08:59:35', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (278, 39, 3, '2013-04-01 09:00:06', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (279, 39, 3, '2013-04-01 09:02:50', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (280, 42, 1, '2013-04-02 03:30:53', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (281, 76, 1, '2013-04-02 04:18:10', 'POS 6', '-100.00'),
  (282, 14, 1, '2013-04-02 08:10:06', 'RECV 1', '10000.00'),
  (283, 45, 1, '2013-04-02 09:33:24', 'RECV 2', '100.00'),
  (288, 42, 1, '2013-04-02 09:37:48', 'RECV 7', '1000.00'),
  (291, 39, 1, '2013-04-02 09:50:47', 'RECV 12', '1000.00'),
  (292, 39, 1, '2013-04-02 10:00:57', 'RECV 13', '100.00'),
  (293, 73, 1, '2013-04-10 04:09:47', 'POS 7', '-100.54'),
  (294, 73, 1, '2013-04-10 04:10:07', 'POS 7', '100.54'),
  (295, 73, 1, '2013-04-10 04:10:07', 'POS 7', '-100.54'),
  (296, 82, 1, '2013-04-23 06:40:51', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '1.00'),
  (297, 83, 1, '2013-04-23 06:48:16', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '1.00'),
  (298, 45, 1, '2013-04-23 07:10:19', 'POS 2', '100.00'),
  (299, 84, 1, '2013-04-23 07:39:23', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '500.00'),
  (300, 85, 1, '2013-09-03 07:14:35', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (301, 14, 1, '2014-06-04 01:42:19', 'POS 3', '100.00'),
  (302, 12, 1, '2014-06-04 01:42:19', 'POS 3', '-1.00'),
  (303, 72, 1, '2017-10-23 03:08:40', 'POS 8', '-1.00'),
  (304, 6, 1, '2017-10-23 03:08:41', 'POS 8', '-1.00'),
  (305, 10, 1, '2017-10-23 03:08:41', 'POS 8', '-1.00'),
  (306, 72, 1, '2017-10-23 03:46:11', 'POS 9', '-1.00'),
  (307, 10, 1, '2017-10-23 03:46:11', 'POS 9', '-1.00'),
  (308, 10, 1, '2017-10-23 03:47:23', 'POS 10', '-1.00'),
  (309, 66, 1, '2017-10-23 03:47:23', 'POS 10', '-1.00'),
  (310, 76, 1, '2017-10-23 04:11:22', 'POS 6', '100.00'),
  (311, 73, 1, '2017-10-23 04:25:36', 'POS 7', '100.54'),
  (312, 73, 1, '2017-10-23 04:25:37', 'POS 7', '-100.54'),
  (313, 41, 1, '2017-10-23 04:25:38', 'POS 7', '-1.00'),
  (314, 10, 1, '2017-10-23 04:25:39', 'POS 7', '-1.00'),
  (315, 71, 1, '2017-10-23 04:27:18', 'POS 11', '-2.00'),
  (316, 47, 1, '2017-10-23 04:27:18', 'POS 11', '-1.00'),
  (317, 69, 1, '2017-10-23 04:27:18', 'POS 11', '-1.00'),
  (318, 10, 1, '2017-10-23 04:34:23', 'POS 7', '1.00'),
  (319, 41, 1, '2017-10-23 04:34:23', 'POS 7', '1.00'),
  (320, 73, 1, '2017-10-23 04:34:23', 'POS 7', '100.54'),
  (321, 10, 1, '2017-10-23 04:34:25', 'POS 7', '-1.00'),
  (322, 41, 1, '2017-10-23 04:34:25', 'POS 7', '-1.00'),
  (323, 73, 1, '2017-10-23 04:34:26', 'POS 7', '-100.54'),
  (324, 71, 1, '2017-10-23 04:34:27', 'POS 7', '-2.00'),
  (325, 47, 1, '2017-10-23 04:46:45', 'POS 12', '-1.00'),
  (326, 16, 1, '2017-10-23 04:46:45', 'POS 12', '-1.00'),
  (327, 10, 1, '2017-10-23 07:14:50', 'POS 7', '1.00'),
  (328, 41, 1, '2017-10-23 07:14:50', 'POS 7', '1.00'),
  (329, 71, 1, '2017-10-23 07:14:50', 'POS 7', '2.00'),
  (330, 73, 1, '2017-10-23 07:14:50', 'POS 7', '100.54'),
  (331, 10, 1, '2017-10-23 07:14:51', 'POS 7', '-1.00'),
  (332, 41, 1, '2017-10-23 07:14:51', 'POS 7', '-1.00'),
  (333, 71, 1, '2017-10-23 07:14:51', 'POS 7', '-2.00'),
  (334, 73, 1, '2017-10-23 07:14:51', 'POS 7', '-100.54'),
  (335, 47, 1, '2017-10-23 07:55:20', 'POS 11', '1.00'),
  (336, 69, 1, '2017-10-23 07:55:20', 'POS 11', '1.00'),
  (337, 71, 1, '2017-10-23 07:55:20', 'POS 11', '2.00'),
  (338, 47, 1, '2017-10-23 07:55:21', 'POS 11', '-1.00'),
  (339, 69, 1, '2017-10-23 07:55:21', 'POS 11', '-1.00'),
  (340, 71, 1, '2017-10-23 07:55:22', 'POS 11', '-2.00'),
  (341, 2, 1, '2017-10-23 07:55:22', 'POS 11', '-1.00'),
  (342, 10, 1, '2017-10-23 08:37:23', 'POS 7', '1.00'),
  (343, 41, 1, '2017-10-23 08:37:23', 'POS 7', '1.00'),
  (344, 71, 1, '2017-10-23 08:37:23', 'POS 7', '2.00'),
  (345, 73, 1, '2017-10-23 08:37:23', 'POS 7', '100.54'),
  (346, 10, 1, '2017-10-23 08:37:24', 'POS 7', '-1.00'),
  (347, 41, 1, '2017-10-23 08:37:24', 'POS 7', '-1.00'),
  (348, 71, 1, '2017-10-23 08:37:25', 'POS 7', '-2.00'),
  (349, 73, 1, '2017-10-23 08:37:25', 'POS 7', '-100.54'),
  (350, 72, 1, '2017-10-23 09:54:36', 'POS 13', '-1.00'),
  (351, 72, 1, '2017-10-24 02:30:56', 'POS 14', '-1.00'),
  (352, 13, 1, '2017-10-24 02:30:56', 'POS 14', '-1.00'),
  (353, 18, 1, '2017-10-24 02:30:56', 'POS 14', '-6.00'),
  (354, 83, 1, '2017-10-24 02:30:56', 'POS 14', '-1.00'),
  (355, 40, 1, '2017-10-24 02:30:56', 'POS 14', '-6.00'),
  (356, 3, 1, '2017-10-24 02:30:56', 'POS 14', '-7.00'),
  (357, 86, 1, '2017-10-24 03:00:06', 'Manual Edit of Quantity', '100.00'),
  (358, 86, 1, '2017-10-24 03:01:14', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (359, 84, 1, '2017-10-24 04:19:17', 'Manual Edit of Quantity', '0.00'),
  (360, 84, 1, '2017-10-24 04:19:57', 'Manual Edit of Quantity', '0.00'),
  (361, 84, 1, '2017-10-24 04:24:47', 'Manual Edit of Quantity', '0.00'),
  (362, 72, 1, '2017-10-24 04:32:11', 'RECV 14', '1.00'),
  (363, 47, 1, '2017-10-24 04:32:11', 'RECV 14', '2.00'),
  (364, 78, 1, '2017-10-24 04:32:11', 'RECV 14', '1.00'),
  (365, 72, 1, '2017-10-24 04:33:50', 'RECV 15', '1.00'),
  (366, 69, 1, '2017-10-24 04:33:50', 'RECV 15', '1.00'),
  (367, 71, 1, '2017-10-24 04:33:50', 'RECV 15', '1.00'),
  (368, 10, 1, '2017-10-24 04:35:46', 'RECV 16', '1.00'),
  (369, 47, 1, '2017-10-24 04:37:21', 'RECV 17', '1.00'),
  (370, 17, 1, '2017-10-24 04:37:21', 'RECV 17', '1.00'),
  (371, 67, 1, '2017-10-24 04:44:24', 'RECV 18', '-1.00'),
  (372, 67, 1, '2017-10-24 04:44:25', 'RECV 19', '-1.00'),
  (373, 86, 1, '2017-10-24 04:48:28', 'RECV 20', '1.00'),
  (374, 86, 1, '2017-10-24 04:50:22', 'RECV 21', '-1.00'),
  (375, 72, 1, '2017-10-25 01:16:03', 'POS 15', '-1.00'),
  (376, 78, 1, '2017-10-25 01:16:03', 'POS 15', '-1.00'),
  (377, 67, 1, '2017-10-25 01:18:52', 'POS 16', '-1.00'),
  (378, 78, 1, '2017-10-25 01:18:52', 'POS 16', '-1.00'),
  (379, 86, 1, '2017-10-25 01:25:30', 'Manual Edit of Quantity', '0.00'),
  (380, 86, 1, '2017-10-25 01:26:06', 'Manual Edit of Quantity', '0.00'),
  (381, 86, 1, '2017-10-25 01:26:35', 'POS 17', '-1.00'),
  (382, 86, 1, '2017-10-25 01:26:35', 'POS 17', '-1.00'),
  (383, 86, 1, '2017-10-25 01:26:35', 'POS 17', '-3.00'),
  (384, 86, 1, '2017-10-25 01:32:54', '', '-5.00'),
  (385, 86, 1, '2017-10-25 01:33:12', 'add new', '5.00'),
  (386, 86, 1, '2017-10-25 02:21:54', 'POS 18', '5.00'),
  (387, 86, 1, '2017-10-25 02:33:36', 'POS 19', '1.00'),
  (388, 86, 1, '2017-10-25 02:34:58', 'RECV 22', '5.00'),
  (389, 86, 1, '2017-10-25 03:09:07', 'RECV 23', '6.00'),
  (390, 86, 1, '2017-10-25 03:24:48', 'RECV 24', '-2.00'),
  (391, 84, 1, '2017-10-25 03:34:13', 'Manual Edit of Quantity', '0.00'),
  (392, 85, 1, '2017-10-25 03:34:32', 'Manual Edit of Quantity', '0.00'),
  (393, 86, 1, '2017-10-25 03:35:32', 'Manual Edit of Quantity', '0.00'),
  (394, 72, 1, '2017-10-25 07:13:19', 'POS 20', '-2.00'),
  (395, 86, 1, '2017-10-25 07:13:19', 'POS 20', '-1.00'),
  (396, 69, 1, '2017-10-25 07:13:19', 'POS 20', '-1.00'),
  (397, 78, 1, '2017-10-25 07:13:19', 'POS 20', '-1.00'),
  (398, 67, 1, '2017-10-25 07:13:19', 'POS 20', '-1.00'),
  (399, 72, 1, '2017-10-26 08:38:23', 'RECV 25', '1.00'),
  (400, 4, 1, '2017-10-26 08:38:23', 'RECV 25', '2.00'),
  (401, 2, 1, '2017-10-26 08:38:23', 'RECV 25', '2.00'),
  (402, 5, 1, '2017-10-26 08:38:23', 'RECV 25', '3.00'),
  (403, 1, 1, '2017-10-26 08:38:23', 'RECV 25', '1.00'),
  (404, 56, 1, '2017-10-26 08:38:23', 'RECV 25', '2.00'),
  (405, 7, 1, '2017-10-26 08:38:23', 'RECV 25', '1.00'),
  (406, 3, 1, '2017-10-26 08:38:23', 'RECV 25', '1.00'),
  (407, 72, 1, '2017-10-26 08:39:39', 'RECV 26', '-1.00'),
  (408, 71, 1, '2017-10-26 08:39:39', 'RECV 26', '-1.00'),
  (409, 78, 1, '2017-10-26 08:41:10', 'POS 21', '-1.00'),
  (410, 68, 1, '2017-10-26 08:41:10', 'POS 21', '-1.00'),
  (411, 67, 1, '2017-10-26 08:41:10', 'POS 21', '-10.00'),
  (412, 72, 1, '2017-10-26 08:41:10', 'POS 21', '-10.00'),
  (413, 72, 1, '2017-10-26 08:45:46', 'POS 22', '1.00'),
  (414, 72, 1, '2017-10-31 04:02:12', 'POS 23', '-1.00'),
  (415, 63, 1, '2017-10-31 04:02:12', 'POS 23', '-1.00'),
  (416, 67, 1, '2017-10-31 04:06:48', 'POS 24', '-1.00'),
  (417, 47, 1, '2017-10-31 04:08:12', 'POS 25', '-1.00'),
  (418, 67, 1, '2017-10-31 04:19:24', 'POS 26', '1.00'),
  (419, 41, 1, '2017-10-31 04:22:20', 'POS 27', '-1.00'),
  (420, 47, 1, '2017-10-31 06:29:38', 'POS 28', '-1.00'),
  (421, 67, 1, '2017-10-31 06:56:45', 'POS 29', '-1.00'),
  (422, 86, 1, '2017-10-31 07:03:53', 'POS 30', '-1.00'),
  (423, 64, 1, '2017-10-31 07:03:53', 'POS 30', '-1.00'),
  (424, 77, 1, '2017-10-31 07:12:44', 'POS 31', '-1.00'),
  (425, 72, 1, '2017-11-06 09:29:52', 'RECV 27', '10.00'),
  (426, 72, 1, '2017-11-06 09:31:24', 'POS 32', '-1.00'),
  (427, 71, 1, '2017-11-06 09:39:16', 'POS 33', '-1.00'),
  (428, 7, 1, '2017-11-06 09:39:16', 'POS 33', '-1.00'),
  (429, 72, 1, '2017-11-07 01:18:10', 'Manual Edit of Quantity', '0.00'),
  (430, 72, 1, '2017-11-07 01:19:27', 'Manual Edit of Quantity', '0.00'),
  (431, 72, 1, '2017-11-07 01:20:49', 'Manual Edit of Quantity', '0.00'),
  (432, 2, 1, '2017-11-13 07:58:35', 'POS 11', '1.00'),
  (433, 47, 1, '2017-11-13 07:58:36', 'POS 11', '1.00'),
  (434, 69, 1, '2017-11-13 07:58:36', 'POS 11', '1.00'),
  (435, 71, 1, '2017-11-13 07:58:36', 'POS 11', '2.00'),
  (436, 16, 1, '2017-11-13 07:58:48', 'POS 12', '1.00'),
  (437, 47, 1, '2017-11-13 07:58:48', 'POS 12', '1.00'),
  (438, 87, 1, '2017-11-13 08:27:30', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (439, 88, 1, '2017-11-13 08:28:38', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (440, 87, 1, '2017-11-13 08:32:06', 'RECV 28', '100.00'),
  (441, 87, 1, '2017-11-13 08:32:56', 'RECV 29', '-50.00'),
  (442, 88, 1, '2017-11-13 08:37:19', 'POS 34', '-1.00'),
  (443, 87, 1, '2017-11-13 08:37:19', 'POS 34', '-1.00'),
  (444, 87, 1, '2017-11-13 08:44:58', 'RECV 30', '100.00'),
  (445, 88, 1, '2017-11-13 08:44:58', 'RECV 30', '100.00'),
  (446, 87, 1, '2017-11-13 08:47:14', 'POS 35', '-1.00'),
  (447, 88, 1, '2017-11-13 08:47:14', 'POS 35', '-1.00'),
  (448, 87, 1, '2017-11-13 08:51:17', 'POS 36', '-2.00'),
  (449, 89, 1, '2017-11-14 01:15:21', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (450, 90, 1, '2017-11-14 01:18:10', 'កែសម្រួលបរិមាណទំនិញតាមចិត្តខ្លួនឯង', '0.00'),
  (451, 89, 1, '2017-11-14 02:16:57', 'POS 37', '-1.00'),
  (452, 90, 1, '2017-11-14 02:47:37', 'POS 38', '-1.00'),
  (453, 89, 1, '2017-11-15 02:46:25', 'POS 39', '-1.00'),
  (454, 89, 1, '2017-11-15 02:47:35', 'POS 40', '-1.00'),
  (455, 89, 1, '2017-11-15 02:52:48', 'POS 41', '-1.00'),
  (456, 87, 1, '2017-11-15 02:52:48', 'POS 41', '-1.00'),
  (457, 87, 1, '2017-11-15 03:03:35', 'POS 42', '-1.00'),
  (458, 87, 1, '2017-11-15 03:06:32', 'POS 43', '-1.00'),
  (459, 89, 1, '2017-11-15 03:08:24', 'POS 44', '-1.00'),
  (460, 90, 1, '2017-11-15 03:09:34', 'POS 45', '-1.00'),
  (461, 87, 1, '2017-11-15 03:11:08', 'POS 46', '-1.00'),
  (462, 88, 1, '2017-11-15 03:11:08', 'POS 46', '-1.00'),
  (463, 87, 1, '2017-11-15 03:49:59', 'POS 47', '-1.00'),
  (464, 88, 1, '2017-11-15 03:49:59', 'POS 47', '-1.00'),
  (465, 90, 1, '2017-11-15 03:53:14', 'POS 48', '-1.00'),
  (466, 87, 1, '2017-11-15 04:46:17', 'POS 49', '-1.00'),
  (467, 88, 1, '2017-11-15 04:51:08', 'POS 50', '-1.00'),
  (468, 88, 1, '2017-11-15 04:54:56', 'POS 51', '-1.00'),
  (469, 89, 1, '2017-11-15 04:54:56', 'POS 51', '1.00'),
  (470, 90, 1, '2017-11-15 06:19:20', 'POS 52', '-1.00'),
  (471, 89, 1, '2017-11-17 02:43:11', 'POS 53', '-2.00'),
  (472, 90, 1, '2017-11-17 03:34:13', 'POS 54', '-1.00');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `phppos_items`
  --
  
  CREATE TABLE IF NOT EXISTS `phppos_items` (
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `category` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `supplier_id` int(11) DEFAULT NULL,
    `item_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `cost_price` decimal(15,2) NOT NULL,
    `unit_price` decimal(15,2) NOT NULL,
    `promo_price` decimal(15,2) NOT NULL DEFAULT '0.00',
    `start_date` date NOT NULL DEFAULT '1969-01-01',
    `end_date` date NOT NULL DEFAULT '1969-01-01',
    `quantity` decimal(15,2) NOT NULL DEFAULT '0.00',
    `measure` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
    `reorder_level` decimal(15,2) NOT NULL DEFAULT '0.00',
    `location` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `item_id` int(10) NOT NULL AUTO_INCREMENT,
    `allow_alt_description` tinyint(1) NOT NULL,
    `is_serialized` tinyint(1) NOT NULL,
    `deleted` int(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`item_id`),
    UNIQUE KEY `item_number` (`item_number`),
    KEY `phppos_items_ibfk_1` (`supplier_id`),
    KEY `name` (`name`),
    KEY `category` (`category`),
    KEY `deleted` (`deleted`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=91 ;
  
  --
  -- Dumping data for table `phppos_items`
  --
  
  INSERT INTO `phppos_items` (`name`, `category`, `supplier_id`, `item_number`, `description`, `cost_price`, `unit_price`, `promo_price`, `start_date`, `end_date`, `quantity`, `measure`, `reorder_level`, `location`, `item_id`, `allow_alt_description`, `is_serialized`, `deleted`) VALUES
  ('banana', 'fruit', NULL, NULL, '', '1.00', '1.50', '0.00', '1969-01-01', '1969-01-01', '140.00', 'items_measure_unit', '10.00', '', 87, 0, 0, 0),
  ('coca-cola', 'soft drink', NULL, NULL, '', '1.00', '1.50', '0.00', '1969-01-01', '1969-01-01', '94.00', 'items_measure_unit', '1.00', '', 88, 0, 0, 0),
  ('jelly bean', 'fast food', NULL, NULL, '', '0.20', '0.50', '0.00', '1969-01-01', '1969-01-01', '-6.00', 'items_measure_unit', '10.00', '', 89, 0, 0, 0),
  ('chili', 'dry vegetable', NULL, NULL, '', '0.10', '0.20', '0.00', '1969-01-01', '1969-01-01', '-5.00', 'items_measure_unit', '10.00', '', 90, 0, 0, 0);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `phppos_items_taxes`
  --
  
  CREATE TABLE IF NOT EXISTS `phppos_items_taxes` (
    `item_id` int(10) NOT NULL,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `percent` decimal(15,3) NOT NULL,
    `cumulative` int(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`item_id`,`name`,`percent`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `phppos_item_kits`
  --
  
  CREATE TABLE IF NOT EXISTS `phppos_item_kits` (
    `item_kit_id` int(11) NOT NULL AUTO_INCREMENT,
    `item_kit_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `category` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `unit_price` decimal(15,2) DEFAULT NULL,
    `cost_price` decimal(15,2) DEFAULT NULL,
    `deleted` int(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`item_kit_id`),
    UNIQUE KEY `item_kit_number` (`item_kit_number`),
    KEY `name` (`name`),
    KEY `deleted` (`deleted`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;
  
  --
  -- Dumping data for table `phppos_item_kits`
  --
  
  INSERT INTO `phppos_item_kits` (`item_kit_id`, `item_kit_number`, `name`, `description`, `category`, `unit_price`, `cost_price`, `deleted`) VALUES
  (1, NULL, 'kit', '', 'D11', '32.40', '12.00', 1),
  (2, NULL, 'na soku', '', 'D11', '1.50', '1.20', 1),
  (3, NULL, 'pro mix banana and coca-cola', '', 'mix', '3.00', '2.00', 0);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `phppos_item_kits_taxes`
  --
  
  CREATE TABLE IF NOT EXISTS `phppos_item_kits_taxes` (
    `item_kit_id` int(10) NOT NULL,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `percent` decimal(15,3) NOT NULL,
    `cumulative` int(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`item_kit_id`,`name`,`percent`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `phppos_item_kit_items`
  --
  
  CREATE TABLE IF NOT EXISTS `phppos_item_kit_items` (
    `item_kit_id` int(11) NOT NULL,
    `item_id` int(11) NOT NULL,
    `quantity` decimal(15,2) NOT NULL,
    PRIMARY KEY (`item_kit_id`,`item_id`,`quantity`),
    KEY `phppos_item_kit_items_ibfk_2` (`item_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `phppos_item_kit_items`
  --
  
  INSERT INTO `phppos_item_kit_items` (`item_kit_id`, `item_id`, `quantity`) VALUES
  (2, 71, '1.00'),
  (1, 72, '2.00'),
  (1, 86, '1.00'),
  (3, 87, '1.00'),
  (3, 88, '1.00');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `phppos_modules`
  --
  
  CREATE TABLE IF NOT EXISTS `phppos_modules` (
    `name_lang_key` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `desc_lang_key` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `sort` int(10) NOT NULL,
    `module_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    PRIMARY KEY (`module_id`),
    UNIQUE KEY `desc_lang_key` (`desc_lang_key`),
    UNIQUE KEY `name_lang_key` (`name_lang_key`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `phppos_modules`
  --
  
  INSERT INTO `phppos_modules` (`name_lang_key`, `desc_lang_key`, `sort`, `module_id`) VALUES
  ('module_config', 'module_config_desc', 130, 'config'),
  ('module_customers', 'module_customers_desc', 10, 'customers'),
  ('module_employees', 'module_employees_desc', 80, 'employees'),
  ('module_exchanges', 'module_exchanges_desc', 100, 'exchanges'),
  ('module_expenses', 'module_expenses_desc', 120, 'expenses'),
  ('module_giftcards', 'module_giftcards_desc', 90, 'giftcards'),
  ('module_incomes', 'module_incomes_desc', 110, 'incomes'),
  ('module_item_kits', 'module_item_kits_desc', 30, 'item_kits'),
  ('module_items', 'module_items_desc', 20, 'items'),
  ('mudule_payoweds', 'mudule_payoweds_desc', 125, 'payoweds'),
  ('module_receivings', 'module_receivings_desc', 60, 'receivings'),
  ('module_reports', 'module_reports_desc', 50, 'reports'),
  ('module_sales', 'module_sales_desc', 70, 'sales'),
  ('module_suppliers', 'module_suppliers_desc', 40, 'suppliers');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `phppos_modules_actions`
  --
  
  CREATE TABLE IF NOT EXISTS `phppos_modules_actions` (
    `action_id` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
    `module_id` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
    `action_name_key` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
    `sort` int(11) NOT NULL,
    PRIMARY KEY (`action_id`,`module_id`),
    KEY `phppos_modules_actions_ibfk_1` (`module_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `phppos_modules_actions`
  --
  
  INSERT INTO `phppos_modules_actions` (`action_id`, `module_id`, `action_name_key`, `sort`) VALUES
  ('add_update', 'customers', 'module_action_add_update', 1),
  ('add_update', 'employees', 'module_action_add_update', 130),
  ('add_update', 'exchanges', 'module_action_add_update', 95),
  ('add_update', 'expenses', 'module_action_add_update', 180),
  ('add_update', 'incomes', 'module_action_add_update', 155),
  ('add_update', 'item_kits', 'module_action_add_update', 70),
  ('add_update', 'items', 'module_action_add_update', 40),
  ('add_update', 'suppliers', 'module_action_add_update', 100),
  ('delete', 'customers', 'module_action_delete', 20),
  ('delete', 'employees', 'module_action_delete', 140),
  ('delete', 'exchanges', 'module_action_delete', 96),
  ('delete', 'expenses', 'module_action_delete', 190),
  ('delete', 'incomes', 'module_action_delete', 160),
  ('delete', 'item_kits', 'module_action_delete', 80),
  ('delete', 'items', 'module_action_delete', 50),
  ('delete', 'suppliers', 'module_action_delete', 110),
  ('edit_sale_price', 'sales', 'module_edit_sale_price', 170),
  ('search', 'customers', 'module_action_search_customers', 30),
  ('search', 'employees', 'module_action_search_employees', 150),
  ('search', 'item_kits', 'module_action_search_item_kits', 90),
  ('search', 'items', 'module_action_search_items', 60),
  ('search', 'suppliers', 'module_action_search_suppliers', 120),
  ('see_cost_price', 'items', 'module_see_cost_price', 61);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `phppos_payment_owed_tbl`
  --
  
  CREATE TABLE IF NOT EXISTS `phppos_payment_owed_tbl` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `employee_id` int(11) DEFAULT NULL,
    `customer_id` int(11) DEFAULT NULL,
    `payment_date` datetime DEFAULT NULL,
    `total_amount` decimal(18,2) DEFAULT NULL,
    `payment_amount` decimal(18,2) DEFAULT NULL,
    `sale_id` int(11) DEFAULT NULL,
    `remain_balance` decimal(18,2) DEFAULT '0.00',
    `deleted` int(1) DEFAULT '0',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=37 ;
  
  --
  -- Dumping data for table `phppos_payment_owed_tbl`
  --
  
  INSERT INTO `phppos_payment_owed_tbl` (`id`, `employee_id`, `customer_id`, `payment_date`, `total_amount`, `payment_amount`, `sale_id`, `remain_balance`, `deleted`) VALUES
  (1, 0, 29, '2017-11-14 00:00:00', '100.00', '50.00', 1, '50.00', 1),
  (2, NULL, 29, '2017-11-15 00:00:00', '0.50', '0.00', 39, '0.50', 1),
  (3, NULL, 29, '2017-11-15 00:00:00', '0.50', '0.00', 40, '0.50', 1),
  (4, NULL, 29, '2017-11-15 00:00:00', '2.00', '2.00', 41, '0.00', 0),
  (5, NULL, 29, '2017-11-15 00:00:00', '1.50', '0.00', 42, '1.50', 1),
  (6, NULL, 29, '2017-11-15 00:00:00', '1.50', '1.00', 43, '0.50', 1),
  (7, NULL, 27, '2017-11-15 00:00:00', '0.50', '0.00', 44, '0.50', 1),
  (8, NULL, 27, '2017-11-15 00:00:00', '0.20', '0.00', 45, '0.20', 1),
  (9, NULL, 29, '2017-11-15 00:00:00', '3.00', '0.00', 46, '3.00', 1),
  (10, NULL, 29, '2017-11-15 00:00:00', '3.00', '0.00', 47, '3.00', 1),
  (11, NULL, 29, '2017-11-15 00:00:00', '0.20', '0.00', 48, '0.20', 1),
  (12, NULL, 29, '2017-11-15 00:00:00', '1.50', '1.00', 49, '0.50', 1),
  (13, NULL, 29, '2017-11-15 00:00:00', '1.35', '1.00', 50, '0.35', 1),
  (14, NULL, 29, '2017-11-15 00:00:00', '1.00', '1.00', 51, '0.00', 0),
  (15, NULL, 29, '2017-11-15 00:00:00', '0.20', '0.20', 52, '0.00', 0),
  (16, NULL, 29, '2017-11-16 00:00:00', '1.35', '1.35', 50, '0.00', 1),
  (17, NULL, 29, '2017-11-16 00:00:00', '0.50', '0.50', 49, '0.00', 0),
  (18, 1, 29, '2017-11-16 00:00:00', '50.00', '25.00', 1, '25.00', 1),
  (19, 1, 29, '2017-11-16 00:00:00', '0.20', '0.10', 48, '0.10', 1),
  (20, 1, 29, '2017-11-16 00:00:00', '0.20', '0.10', 48, '0.10', 1),
  (21, 1, 29, '2017-11-16 00:00:00', '0.20', '0.15', 48, '0.05', 1),
  (22, 1, 29, '2017-11-16 00:00:00', '3.00', '2.00', 47, '1.00', 1),
  (23, 1, 29, '2017-11-16 10:36:20', '3.00', '3.00', 47, '0.00', 0),
  (24, 1, 27, '2017-11-16 10:48:44', '0.50', '0.50', 44, '0.00', 0),
  (25, 1, 29, '2017-11-16 10:50:27', '0.50', '0.50', 40, '0.00', 0),
  (26, 1, 29, '2017-11-16 13:05:52', '0.20', '0.20', 48, '0.00', 0),
  (27, 1, 29, '2017-11-16 13:07:42', '3.00', '3.00', 46, '0.00', 0),
  (28, 1, 29, '2017-11-16 13:09:57', '50.00', '50.00', 1, '0.00', 0),
  (29, 1, 29, '2017-11-16 13:12:09', '1.50', '1.50', 42, '0.00', 0),
  (30, 1, 29, '2017-11-16 13:16:57', '0.50', '0.30', 39, '0.20', 0),
  (31, 1, 29, '2017-11-16 13:18:00', '1.50', '1.20', 43, '0.30', 1),
  (32, 1, 29, '2017-11-17 09:43:11', '1.00', '0.50', 53, '0.50', 1),
  (33, 1, 29, '2017-11-17 10:34:13', '0.20', '0.20', 54, '0.00', 0),
  (34, 1, 29, '2017-11-17 11:14:46', '1.00', '1.00', 53, '0.00', 0),
  (35, 1, 27, '2017-11-17 11:16:45', '0.20', '0.20', 45, '0.00', 0),
  (36, 1, 29, '2017-11-17 11:18:03', '1.50', '1.50', 43, '0.00', 0);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `phppos_people`
  --
  
  CREATE TABLE IF NOT EXISTS `phppos_people` (
    `first_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `last_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `phone_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `address_1` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `address_2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `city` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `state` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `zip` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `country` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `comments` text COLLATE utf8_unicode_ci NOT NULL,
    `person_id` int(10) NOT NULL AUTO_INCREMENT,
    `test` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`person_id`),
    KEY `first_name` (`first_name`),
    KEY `last_name` (`last_name`),
    KEY `email` (`email`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=31 ;
  
  --
  -- Dumping data for table `phppos_people`
  --
  
  INSERT INTO `phppos_people` (`first_name`, `last_name`, `phone_number`, `email`, `address_1`, `address_2`, `city`, `state`, `zip`, `country`, `comments`, `person_id`, `test`) VALUES
  ('bunthoeun', 'single', '078 987 170', 'bunthoeunmake@gmail.com', 'Address 1', '', '', '', '', '', '', 1, NULL),
  ('bunthoeun', 'sing', '', '', '', '', '', '', '', '', '', 27, NULL),
  ('ma', 'ski', '', '', '', '', '', '', '', '', '', 28, NULL),
  ('ដា', 'រាវិរះសិទ្ធិ', '098 384 384', 'bunthoeun@gmail.com', '', '', '', '', '', '', '', 29, NULL),
  ('visika', 'dollar riya', '', '', '', '', '', '', '', '', '', 30, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `phppos_permissions`
  --
  
  CREATE TABLE IF NOT EXISTS `phppos_permissions` (
    `module_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `person_id` int(10) NOT NULL,
    PRIMARY KEY (`module_id`,`person_id`),
    KEY `person_id` (`person_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `phppos_permissions`
  --
  
  INSERT INTO `phppos_permissions` (`module_id`, `person_id`) VALUES
  ('config', 1),
  ('customers', 1),
  ('employees', 1),
  ('exchanges', 1),
  ('expenses', 1),
  ('giftcards', 1),
  ('incomes', 1),
  ('item_kits', 1),
  ('items', 1),
  ('payoweds', 1),
  ('receivings', 1),
  ('reports', 1),
  ('sales', 1),
  ('suppliers', 1);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `phppos_permissions_actions`
  --
  
  CREATE TABLE IF NOT EXISTS `phppos_permissions_actions` (
    `module_id` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
    `person_id` int(11) NOT NULL,
    `action_id` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
    PRIMARY KEY (`module_id`,`person_id`,`action_id`),
    KEY `phppos_permissions_actions_ibfk_2` (`person_id`),
    KEY `phppos_permissions_actions_ibfk_3` (`action_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `phppos_permissions_actions`
  --
  
  INSERT INTO `phppos_permissions_actions` (`module_id`, `person_id`, `action_id`) VALUES
  ('customers', 1, 'add_update'),
  ('customers', 1, 'delete'),
  ('customers', 1, 'search'),
  ('employees', 1, 'add_update'),
  ('employees', 1, 'delete'),
  ('employees', 1, 'search'),
  ('exchanges', 1, 'add_update'),
  ('exchanges', 1, 'delete'),
  ('expenses', 1, 'add_update'),
  ('expenses', 1, 'delete'),
  ('incomes', 1, 'add_update'),
  ('incomes', 1, 'delete'),
  ('item_kits', 1, 'add_update'),
  ('item_kits', 1, 'delete'),
  ('item_kits', 1, 'search'),
  ('items', 1, 'add_update'),
  ('items', 1, 'delete'),
  ('items', 1, 'search'),
  ('items', 1, 'see_cost_price'),
  ('sales', 1, 'edit_sale_price'),
  ('suppliers', 1, 'add_update'),
  ('suppliers', 1, 'delete'),
  ('suppliers', 1, 'search'),
  ('customers', 2, 'add_update'),
  ('customers', 2, 'search'),
  ('customers', 3, 'add_update'),
  ('customers', 3, 'delete'),
  ('customers', 3, 'search'),
  ('employees', 3, 'add_update'),
  ('employees', 3, 'delete'),
  ('employees', 3, 'search'),
  ('items', 3, 'add_update'),
  ('items', 3, 'delete'),
  ('items', 3, 'search'),
  ('items', 3, 'see_cost_price'),
  ('sales', 3, 'edit_sale_price'),
  ('suppliers', 3, 'add_update'),
  ('suppliers', 3, 'delete'),
  ('suppliers', 3, 'search');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `phppos_receivings`
  --
  
  CREATE TABLE IF NOT EXISTS `phppos_receivings` (
    `receiving_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `supplier_id` int(10) DEFAULT NULL,
    `employee_id` int(10) NOT NULL DEFAULT '0',
    `comment` text COLLATE utf8_unicode_ci NOT NULL,
    `receiving_id` int(10) NOT NULL AUTO_INCREMENT,
    `payment_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `deleted` int(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`receiving_id`),
    KEY `supplier_id` (`supplier_id`),
    KEY `employee_id` (`employee_id`),
    KEY `deleted` (`deleted`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=31 ;
  
  --
  -- Dumping data for table `phppos_receivings`
  --
  
  INSERT INTO `phppos_receivings` (`receiving_time`, `supplier_id`, `employee_id`, `comment`, `receiving_id`, `payment_type`, `deleted`) VALUES
  ('2017-11-13 08:32:06', 28, 1, '', 28, 'កត់​ចូល​បញ្ជី', 0),
  ('2017-11-13 08:32:56', 28, 1, '', 29, 'កត់​ចូល​បញ្ជី', 0),
  ('2017-11-13 08:44:58', 28, 1, '', 30, 'កត់​ចូល​បញ្ជី', 0);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `phppos_receivings_items`
  --
  
  CREATE TABLE IF NOT EXISTS `phppos_receivings_items` (
    `receiving_id` int(10) NOT NULL DEFAULT '0',
    `item_id` int(10) NOT NULL DEFAULT '0',
    `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `serialnumber` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `line` int(3) NOT NULL,
    `quantity_purchased` int(10) NOT NULL DEFAULT '0',
    `item_cost_price` decimal(15,2) NOT NULL,
    `item_unit_price` decimal(15,2) NOT NULL,
    `discount_percent` int(11) NOT NULL DEFAULT '0',
    PRIMARY KEY (`receiving_id`,`item_id`,`line`),
    KEY `item_id` (`item_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `phppos_receivings_items`
  --
  
  INSERT INTO `phppos_receivings_items` (`receiving_id`, `item_id`, `description`, `serialnumber`, `line`, `quantity_purchased`, `item_cost_price`, `item_unit_price`, `discount_percent`) VALUES
  (28, 87, '', '0', 1, 100, '1.00', '1.00', 0),
  (29, 87, '', '0', 1, -50, '1.00', '1.00', 0),
  (30, 87, '', '0', 1, 100, '1.00', '1.00', 0),
  (30, 88, '', '0', 2, 100, '1.00', '1.00', 0);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `phppos_register_log`
  --
  
  CREATE TABLE IF NOT EXISTS `phppos_register_log` (
    `register_log_id` int(10) NOT NULL AUTO_INCREMENT,
    `employee_id` int(10) NOT NULL,
    `shift_start` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `shift_end` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `open_amount` double(15,2) NOT NULL,
    `close_amount` double(15,2) NOT NULL,
    `cash_sales_amount` double(15,2) NOT NULL,
    PRIMARY KEY (`register_log_id`),
    KEY `phppos_register_log_ibfk_1` (`employee_id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
  
  --
  -- Dumping data for table `phppos_register_log`
  --
  
  INSERT INTO `phppos_register_log` (`register_log_id`, `employee_id`, `shift_start`, `shift_end`, `open_amount`, `close_amount`, `cash_sales_amount`) VALUES
  (1, 1, '2013-03-29 04:32:50', '0000-00-00 00:00:00', 200.00, 0.00, 0.00);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `phppos_sales`
  --
  
  CREATE TABLE IF NOT EXISTS `phppos_sales` (
    `sale_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `customer_id` int(10) DEFAULT NULL,
    `employee_id` int(10) NOT NULL DEFAULT '0',
    `comment` text COLLATE utf8_unicode_ci NOT NULL,
    `sale_id` int(10) NOT NULL AUTO_INCREMENT,
    `payment_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `deleted` int(1) NOT NULL DEFAULT '0',
    `suspended` int(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`sale_id`),
    KEY `customer_id` (`customer_id`),
    KEY `employee_id` (`employee_id`),
    KEY `deleted` (`deleted`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=55 ;
  
  --
  -- Dumping data for table `phppos_sales`
  --
  
  INSERT INTO `phppos_sales` (`sale_time`, `customer_id`, `employee_id`, `comment`, `sale_id`, `payment_type`, `deleted`, `suspended`) VALUES
  ('2017-11-13 08:37:18', 27, 1, '', 34, '2017-11-13 15:37:14 សាច់ប្រាក់: $ 3.00<br />', 0, 0),
  ('2017-11-13 08:47:13', 27, 1, '', 35, '2017-11-13 15:47:09 សាច់ប្រាក់: $ 3.00<br />', 0, 0),
  ('2017-11-13 08:51:16', 27, 1, '', 36, '2017-11-13 15:51:03 ប័ណ្ណបញ្ចុះតំលៃ:09877655432: $ 3.00<br />', 0, 0),
  ('2017-11-14 02:16:57', 29, 1, '', 37, '2017-11-14 09:16:51 សាច់ប្រាក់: $ 0.50<br />', 0, 0),
  ('2017-11-14 02:47:37', NULL, 1, '', 38, '2017-11-14 09:47:24 សាច់ប្រាក់: $ 1.00<br />', 0, 0),
  ('2017-11-15 02:46:24', 29, 1, '', 39, '2017-11-15 09:06:22 សាច់ប្រាក់: $ 0.50<br />', 0, 0),
  ('2017-11-15 02:47:35', 29, 1, '', 40, '2017-11-15 09:06:22 សាច់ប្រាក់: $ 0.50<br />', 0, 0),
  ('2017-11-15 02:52:48', 29, 1, '', 41, '2017-11-15 09:52:29 សាច់ប្រាក់: $ 2.00<br />', 0, 0),
  ('2017-11-15 03:03:35', 29, 1, '', 42, '2017-11-15 09:54:15 សាច់ប្រាក់: $ 1.50<br />', 0, 0),
  ('2017-11-15 03:06:32', 29, 1, '', 43, '2017-11-15 10:06:08 សាច់ប្រាក់: $ 1.50<br />', 0, 0),
  ('2017-11-15 03:08:24', 27, 1, '', 44, '2017-11-15 10:08:07 សាច់ប្រាក់: $ 0.50<br />', 0, 0),
  ('2017-11-15 03:09:34', 27, 1, '', 45, '2017-11-15 10:09:16 សាច់ប្រាក់: $ 0.20<br />', 0, 0),
  ('2017-11-15 03:11:08', 29, 1, '', 46, '2017-11-15 10:10:56 សាច់ប្រាក់: $ 3.00<br />', 0, 0),
  ('2017-11-15 03:49:58', 29, 1, '', 47, '2017-11-15 10:23:00 សាច់ប្រាក់: $ 3.00<br />', 0, 0),
  ('2017-11-15 03:53:14', 29, 1, '', 48, '2017-11-15 10:53:05 សាច់ប្រាក់: $ 0.20<br />', 0, 0),
  ('2017-11-15 04:46:16', 29, 1, '', 49, '2017-11-15 11:45:43 សាច់ប្រាក់: $ 1.50<br />', 0, 0),
  ('2017-11-15 04:51:07', 29, 1, '', 50, '2017-11-15 11:50:37 សាច់ប្រាក់: $ 1.35<br />', 0, 0),
  ('2017-11-15 04:54:56', 29, 1, '', 51, '2017-11-15 11:53:32 សាច់ប្រាក់: $ 1.50<br />', 0, 0),
  ('2017-11-15 06:19:19', 29, 1, '', 52, '2017-11-15 13:17:10 សាច់ប្រាក់: $ 0.20<br />', 0, 0),
  ('2017-11-17 02:43:10', 29, 1, '', 53, '2017-11-17 09:38:25 សាច់ប្រាក់: $ 1.00<br />', 0, 0),
  ('2017-11-17 03:34:13', 29, 1, '', 54, '2017-11-17 10:22:20 សាច់ប្រាក់: $ 0.20<br />', 0, 0);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `phppos_sales_items`
  --
  
  CREATE TABLE IF NOT EXISTS `phppos_sales_items` (
    `sale_id` int(10) NOT NULL DEFAULT '0',
    `item_id` int(10) NOT NULL DEFAULT '0',
    `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `serialnumber` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `line` int(3) NOT NULL DEFAULT '0',
    `quantity_purchased` decimal(15,2) NOT NULL DEFAULT '0.00',
    `item_cost_price` decimal(15,2) NOT NULL,
    `item_unit_price` decimal(15,2) NOT NULL,
    `discount_percent` int(11) NOT NULL DEFAULT '0',
    PRIMARY KEY (`sale_id`,`item_id`,`line`),
    KEY `item_id` (`item_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `phppos_sales_items`
  --
  
  INSERT INTO `phppos_sales_items` (`sale_id`, `item_id`, `description`, `serialnumber`, `line`, `quantity_purchased`, `item_cost_price`, `item_unit_price`, `discount_percent`) VALUES
  (34, 87, '', '', 2, '1.00', '1.00', '1.50', 0),
  (34, 88, '', '', 1, '1.00', '1.00', '1.50', 0),
  (36, 87, '', '', 1, '2.00', '1.00', '1.50', 0),
  (37, 89, '', '', 1, '1.00', '0.20', '0.50', 0),
  (38, 90, '', '', 1, '1.00', '0.10', '0.20', 0),
  (39, 89, '', '', 1, '1.00', '0.20', '0.50', 0),
  (40, 89, '', '', 1, '1.00', '0.20', '0.50', 0),
  (41, 87, '', '', 2, '1.00', '1.00', '1.50', 0),
  (41, 89, '', '', 1, '1.00', '0.20', '0.50', 0),
  (42, 87, '', '', 1, '1.00', '1.00', '1.50', 0),
  (43, 87, '', '', 1, '1.00', '1.00', '1.50', 0),
  (44, 89, '', '', 1, '1.00', '0.20', '0.50', 0),
  (45, 90, '', '', 1, '1.00', '0.10', '0.20', 0),
  (48, 90, '', '', 1, '1.00', '0.10', '0.20', 0),
  (49, 87, '', '', 1, '1.00', '1.00', '1.50', 0),
  (50, 88, '', '', 1, '1.00', '1.00', '1.50', 10),
  (51, 88, '', '', 1, '1.00', '1.00', '1.50', 0),
  (51, 89, '', '', 2, '-1.00', '0.20', '0.50', 0),
  (52, 90, '', '', 1, '1.00', '0.10', '0.20', 0),
  (53, 89, '', '', 1, '2.00', '0.20', '0.50', 0),
  (54, 90, '', '', 1, '1.00', '0.10', '0.20', 0);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `phppos_sales_items_taxes`
  --
  
  CREATE TABLE IF NOT EXISTS `phppos_sales_items_taxes` (
    `sale_id` int(10) NOT NULL,
    `item_id` int(10) NOT NULL,
    `line` int(3) NOT NULL DEFAULT '0',
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `percent` decimal(15,3) NOT NULL,
    `cumulative` int(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`sale_id`,`item_id`,`line`,`name`,`percent`),
    KEY `item_id` (`item_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `phppos_sales_item_kits`
  --
  
  CREATE TABLE IF NOT EXISTS `phppos_sales_item_kits` (
    `sale_id` int(10) NOT NULL DEFAULT '0',
    `item_kit_id` int(10) NOT NULL DEFAULT '0',
    `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `line` int(3) NOT NULL DEFAULT '0',
    `quantity_purchased` decimal(15,2) NOT NULL DEFAULT '0.00',
    `item_kit_cost_price` decimal(15,2) NOT NULL,
    `item_kit_unit_price` decimal(15,2) NOT NULL,
    `discount_percent` int(11) NOT NULL DEFAULT '0',
    PRIMARY KEY (`sale_id`,`item_kit_id`,`line`),
    KEY `item_kit_id` (`item_kit_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `phppos_sales_item_kits`
  --
  
  INSERT INTO `phppos_sales_item_kits` (`sale_id`, `item_kit_id`, `description`, `line`, `quantity_purchased`, `item_kit_cost_price`, `item_kit_unit_price`, `discount_percent`) VALUES
  (35, 3, '', 1, '1.00', '2.00', '3.00', 0),
  (46, 3, '', 1, '1.00', '2.00', '3.00', 0),
  (47, 3, '', 1, '1.00', '2.00', '3.00', 0);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `phppos_sales_item_kits_taxes`
  --
  
  CREATE TABLE IF NOT EXISTS `phppos_sales_item_kits_taxes` (
    `sale_id` int(10) NOT NULL,
    `item_kit_id` int(10) NOT NULL,
    `line` int(3) NOT NULL DEFAULT '0',
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `percent` decimal(15,3) NOT NULL,
    `cumulative` int(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`sale_id`,`item_kit_id`,`line`,`name`,`percent`),
    KEY `item_id` (`item_kit_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `phppos_sales_payments`
  --
  
  CREATE TABLE IF NOT EXISTS `phppos_sales_payments` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `sale_id` int(10) DEFAULT NULL,
    `payment_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `payment_amount` decimal(15,2) DEFAULT NULL,
    `payment_date` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `sale_id` (`sale_id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=84 ;
  
  --
  -- Dumping data for table `phppos_sales_payments`
  --
  
  INSERT INTO `phppos_sales_payments` (`id`, `sale_id`, `payment_type`, `payment_amount`, `payment_date`) VALUES
  (63, 34, 'សាច់ប្រាក់', '3.00', '2017-11-13 15:37:14'),
  (64, 35, 'សាច់ប្រាក់', '3.00', '2017-11-13 15:47:09'),
  (65, 36, 'ប័ណ្ណបញ្ចុះតំលៃ:09877655432', '3.00', '2017-11-13 15:51:03'),
  (66, 37, 'សាច់ប្រាក់', '0.50', '2017-11-14 09:16:51'),
  (67, 38, 'សាច់ប្រាក់', '1.00', '2017-11-14 09:47:24'),
  (68, 39, 'សាច់ប្រាក់', '0.50', '2017-11-15 09:06:22'),
  (69, 40, 'សាច់ប្រាក់', '0.50', '2017-11-15 09:06:22'),
  (70, 41, 'សាច់ប្រាក់', '2.00', '2017-11-15 09:52:29'),
  (71, 42, 'សាច់ប្រាក់', '1.50', '2017-11-15 09:54:15'),
  (72, 43, 'សាច់ប្រាក់', '1.50', '2017-11-15 10:06:08'),
  (73, 44, 'សាច់ប្រាក់', '0.50', '2017-11-15 10:08:07'),
  (74, 45, 'សាច់ប្រាក់', '0.20', '2017-11-15 10:09:16'),
  (75, 46, 'សាច់ប្រាក់', '3.00', '2017-11-15 10:10:56'),
  (76, 47, 'សាច់ប្រាក់', '3.00', '2017-11-15 10:23:00'),
  (77, 48, 'សាច់ប្រាក់', '0.20', '2017-11-15 10:53:05'),
  (78, 49, 'សាច់ប្រាក់', '1.50', '2017-11-15 11:45:43'),
  (79, 50, 'សាច់ប្រាក់', '1.35', '2017-11-15 11:50:37'),
  (80, 51, 'សាច់ប្រាក់', '1.50', '2017-11-15 11:53:32'),
  (81, 52, 'សាច់ប្រាក់', '0.20', '2017-11-15 13:17:10'),
  (82, 53, 'សាច់ប្រាក់', '1.00', '2017-11-17 09:38:25'),
  (83, 54, 'សាច់ប្រាក់', '0.20', '2017-11-17 10:22:20');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `phppos_sessions`
  --
  
  CREATE TABLE IF NOT EXISTS `phppos_sessions` (
    `session_id` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
    `ip_address` varchar(45) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
    `user_agent` varchar(120) COLLATE utf8_unicode_ci NOT NULL,
    `last_activity` int(10) unsigned NOT NULL DEFAULT '0',
    `user_data` text COLLATE utf8_unicode_ci,
    PRIMARY KEY (`session_id`),
    KEY `last_activity_idx` (`last_activity`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `phppos_sessions`
  --
  
  INSERT INTO `phppos_sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`, `user_data`) VALUES
  ('0af03bfcaa73cf84603fbee96ff73b56', '::1', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.94 Safari/537.36', 1510881278, ''),
  ('266943bec1782c20873e6bc0bee53ff0', '::1', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.94 Safari/537.36', 1510881282, ''),
  ('4812354c2acab2796b9cf1bdf56f01d4', '::1', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.94 Safari/537.36', 1510881280, ''),
  ('579de063e6de82d37390ba85ded570de', '::1', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.94 Safari/537.36', 1510881281, ''),
  ('71e991b264d02d985242c2f84dcb8bbb', '::1', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.94 Safari/537.36', 1510881282, 'a:9:{s:9:"user_data";s:0:"";s:9:"person_id";s:1:"1";s:8:"cartRecv";a:0:{}s:9:"recv_mode";s:7:"receive";s:8:"supplier";i:-1;s:8:"customer";s:0:"";s:7:"comment";N;s:4:"cart";a:0:{}s:8:"payments";a:0:{}}'),
  ('b147fe3173a525b1df4d52d25dd53c7b', '::1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.9 Safari/537.36', 1510892011, 'a:2:{s:9:"user_data";s:0:"";s:9:"person_id";s:1:"1";}'),
  ('e068ac78c7fbb65d6c140f0edb253e0a', '::1', 'Mozilla/5.0 (Windows NT 6.3; WOW64; rv:33.0) Gecko/20100101 Firefox/33.0', 1510890818, 'a:7:{s:9:"user_data";s:0:"";s:9:"person_id";s:1:"1";s:20:"receive_payment_sale";i:0;s:4:"cart";a:0:{}s:9:"sale_mode";s:4:"sale";s:8:"customer";i:-1;s:8:"payments";a:0:{}}'),
  ('f229575f6ca3f394393782d07653e7d1', '::1', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.94 Safari/537.36', 1510881281, '');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `phppos_store_accounts`
  --
  
  CREATE TABLE IF NOT EXISTS `phppos_store_accounts` (
    `sno` int(11) NOT NULL AUTO_INCREMENT,
    `supplier_id` int(11) NOT NULL,
    `receiving_id` int(11) DEFAULT NULL,
    `transaction_amount` decimal(15,2) NOT NULL DEFAULT '0.00',
    `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `balance` decimal(15,2) NOT NULL DEFAULT '0.00',
    `comment` text COLLATE utf8_unicode_ci NOT NULL,
    `deleted` int(11) NOT NULL DEFAULT '0',
    PRIMARY KEY (`sno`),
    KEY `phppos_store_accounts_ibfk_1` (`receiving_id`),
    KEY `phppos_store_accounts_ibfk_2` (`supplier_id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=27 ;
  
  --
  -- Dumping data for table `phppos_store_accounts`
  --
  
  INSERT INTO `phppos_store_accounts` (`sno`, `supplier_id`, `receiving_id`, `transaction_amount`, `date`, `balance`, `comment`, `deleted`) VALUES
  (24, 28, 28, '100.00', '2017-11-13 08:32:06', '100.00', '', 0),
  (25, 28, 29, '-50.00', '2017-11-13 08:32:56', '50.00', '', 0),
  (26, 28, 30, '200.00', '2017-11-13 08:44:58', '250.00', '', 0);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `phppos_suppliers`
  --
  
  CREATE TABLE IF NOT EXISTS `phppos_suppliers` (
    `person_id` int(10) NOT NULL,
    `company_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `account_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `deleted` int(1) NOT NULL DEFAULT '0',
    UNIQUE KEY `account_number` (`account_number`),
    KEY `person_id` (`person_id`),
    KEY `deleted` (`deleted`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data for table `phppos_suppliers`
  --
  
  INSERT INTO `phppos_suppliers` (`person_id`, `company_name`, `account_number`, `deleted`) VALUES
  (28, 'MIS', NULL, 0);
  
  --
  -- Constraints for dumped tables
  --
  
  --
  -- Constraints for table `phppos_customers`
  --
  ALTER TABLE `phppos_customers`
    ADD CONSTRAINT `phppos_customers_ibfk_1` FOREIGN KEY (`person_id`) REFERENCES `phppos_people` (`person_id`);
  
  --
  -- Constraints for table `phppos_employees`
  --
  ALTER TABLE `phppos_employees`
    ADD CONSTRAINT `phppos_employees_ibfk_1` FOREIGN KEY (`person_id`) REFERENCES `phppos_people` (`person_id`);
  
  --
  -- Constraints for table `phppos_giftcards`
  --
  ALTER TABLE `phppos_giftcards`
    ADD CONSTRAINT `phppos_giftcards_ibfk_1` FOREIGN KEY (`customer_id`) REFERENCES `phppos_customers` (`person_id`);
  
  /*!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 */;
  