-- https://www.phpmyadmin.net/
--

START TRANSACTION;



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

--
-- Table structure for table `ospos_attribute_definitions`
--

CREATE TABLE `ospos_attribute_definitions` (
  `definition_id` int(10) NOT NULL,
  `definition_name` varchar(255) NOT NULL,
  `definition_type` varchar(45) NOT NULL,
  `definition_unit` varchar(16) DEFAULT NULL,
  `definition_flags` tinyint(4) NOT NULL,
  `definition_fk` int(10) DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `ospos_attribute_links`
--

CREATE TABLE `ospos_attribute_links` (
  `attribute_id` int(11) DEFAULT NULL,
  `definition_id` int(11) NOT NULL,
  `item_id` int(11) DEFAULT NULL,
  `sale_id` int(11) DEFAULT NULL,
  `receiving_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `ospos_attribute_values`
--

CREATE TABLE `ospos_attribute_values` (
  `attribute_id` int(11) NOT NULL,
  `attribute_value` varchar(255) DEFAULT NULL,
  `attribute_date` date DEFAULT NULL,
  `attribute_decimal` decimal(7,3) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `ospos_cash_up`
--

CREATE TABLE `ospos_cash_up` (
  `cashup_id` int(10) NOT NULL,
  `open_date` timestamp NULL DEFAULT current_timestamp(),
  `close_date` timestamp NULL DEFAULT NULL,
  `open_amount_cash` decimal(15,2) NOT NULL,
  `transfer_amount_cash` decimal(15,2) NOT NULL,
  `note` int(1) NOT NULL,
  `closed_amount_cash` decimal(15,2) NOT NULL,
  `closed_amount_card` decimal(15,2) NOT NULL,
  `closed_amount_check` decimal(15,2) NOT NULL,
  `closed_amount_total` decimal(15,2) NOT NULL,
  `description` varchar(255) NOT NULL,
  `open_employee_id` int(10) NOT NULL,
  `close_employee_id` int(10) NOT NULL,
  `deleted` int(1) NOT NULL DEFAULT 0,
  `closed_amount_due` decimal(15,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ospos_cash_up`
--

INSERT INTO `ospos_cash_up` (`cashup_id`, `open_date`, `close_date`, `open_amount_cash`, `transfer_amount_cash`, `note`, `closed_amount_cash`, `closed_amount_card`, `closed_amount_check`, `closed_amount_total`, `description`, `open_employee_id`, `close_employee_id`, `deleted`, `closed_amount_due`) VALUES
(1, '2022-01-07 20:36:33', '2022-01-07 20:36:33', '100000.00', '0.00', 0, '0.00', '0.00', '0.00', '-100000.00', '', 1, 1, 0, '0.00');

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

--
-- Table structure for table `ospos_customers`
--

CREATE TABLE `ospos_customers` (
  `person_id` int(10) NOT NULL,
  `company_name` varchar(255) DEFAULT NULL,
  `account_number` varchar(255) DEFAULT NULL,
  `taxable` int(1) NOT NULL DEFAULT 1,
  `tax_id` varchar(32) NOT NULL DEFAULT '',
  `sales_tax_code_id` int(11) DEFAULT NULL,
  `discount` decimal(15,2) NOT NULL DEFAULT 0.00,
  `discount_type` tinyint(2) NOT NULL DEFAULT 0,
  `package_id` int(11) DEFAULT NULL,
  `points` int(11) DEFAULT NULL,
  `deleted` int(1) NOT NULL DEFAULT 0,
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  `employee_id` int(10) NOT NULL,
  `consent` int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ospos_customers`
--

INSERT INTO `ospos_customers` (`person_id`, `company_name`, `account_number`, `taxable`, `tax_id`, `sales_tax_code_id`, `discount`, `discount_type`, `package_id`, `points`, `deleted`, `date`, `employee_id`, `consent`) VALUES
(2, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(3, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(4, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(5, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(6, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(7, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(8, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(9, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(10, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(11, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(12, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(13, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(14, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(15, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(16, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(17, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(18, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(19, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(20, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(21, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(22, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(23, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(24, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(25, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(26, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(27, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(28, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(29, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(30, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(31, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(32, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(33, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(34, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(35, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(36, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(37, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(38, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(39, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(40, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(41, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(42, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(43, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(44, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(45, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(46, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(47, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(48, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(49, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(50, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(51, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(52, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(53, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(54, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(55, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(56, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(57, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(58, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(59, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(60, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(61, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(62, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(63, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(64, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(65, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(66, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(67, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(68, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(69, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(70, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(71, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(72, '', NULL, 0, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:12:47', 1, 1),
(73, NULL, NULL, 1, '', NULL, '0.00', 0, NULL, NULL, 0, '2021-12-01 04:14:14', 1, 1),
(75, NULL, NULL, 1, '', NULL, '0.00', 0, NULL, NULL, 0, '2022-01-18 12:43:03', 74, 1),
(76, NULL, NULL, 1, '', NULL, '0.00', 0, NULL, NULL, 0, '2022-01-19 06:58:53', 74, 1),
(77, NULL, NULL, 1, '', NULL, '0.00', 0, NULL, NULL, 0, '2022-01-19 07:48:18', 74, 1),
(78, NULL, NULL, 1, '', NULL, '0.00', 0, NULL, NULL, 0, '2022-01-19 11:51:52', 74, 1),
(79, NULL, NULL, 1, '', NULL, '0.00', 0, NULL, NULL, 0, '2022-01-19 13:57:20', 74, 1),
(80, NULL, NULL, 1, '', NULL, '0.00', 0, NULL, NULL, 0, '2022-01-19 16:22:37', 74, 1),
(81, NULL, NULL, 1, '', NULL, '0.00', 0, NULL, NULL, 0, '2022-01-19 18:43:20', 74, 1),
(82, NULL, NULL, 1, '', NULL, '0.00', 0, NULL, NULL, 0, '2022-01-21 08:25:10', 74, 1),
(83, NULL, NULL, 1, '', NULL, '0.00', 0, NULL, NULL, 0, '2022-01-21 10:21:18', 74, 1),
(84, NULL, NULL, 1, '', NULL, '0.00', 0, NULL, NULL, 0, '2022-01-21 12:06:12', 74, 1),
(85, NULL, NULL, 1, '', NULL, '0.00', 0, NULL, NULL, 0, '2022-01-21 14:51:16', 74, 1),
(86, NULL, NULL, 1, '', NULL, '0.00', 0, NULL, NULL, 0, '2022-01-22 12:03:45', 74, 1);

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

--
-- Table structure for table `ospos_customers_packages`
--

CREATE TABLE `ospos_customers_packages` (
  `package_id` int(11) NOT NULL,
  `package_name` varchar(255) DEFAULT NULL,
  `points_percent` float NOT NULL DEFAULT 0,
  `deleted` int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ospos_customers_packages`
--

INSERT INTO `ospos_customers_packages` (`package_id`, `package_name`, `points_percent`, `deleted`) VALUES
(1, 'Default', 0, 0),
(2, 'Bronze', 10, 0),
(3, 'Silver', 20, 0),
(4, 'Gold', 30, 0),
(5, 'Premium', 50, 0);

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

--
-- Table structure for table `ospos_customers_points`
--

CREATE TABLE `ospos_customers_points` (
  `id` int(11) NOT NULL,
  `person_id` int(11) NOT NULL,
  `package_id` int(11) NOT NULL,
  `sale_id` int(11) NOT NULL,
  `points_earned` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `ospos_dinner_tables`
--

CREATE TABLE `ospos_dinner_tables` (
  `dinner_table_id` int(11) NOT NULL,
  `name` varchar(30) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `deleted` int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ospos_dinner_tables`
--

INSERT INTO `ospos_dinner_tables` (`dinner_table_id`, `name`, `status`, `deleted`) VALUES
(1, 'Delivery', 0, 0),
(2, 'Take Away', 0, 0);

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

--
-- Table structure for table `ospos_expenses`
--

CREATE TABLE `ospos_expenses` (
  `expense_id` int(10) NOT NULL,
  `date` timestamp NULL DEFAULT current_timestamp(),
  `amount` decimal(15,2) NOT NULL,
  `payment_type` varchar(40) NOT NULL,
  `expense_category_id` int(11) NOT NULL,
  `description` varchar(255) NOT NULL,
  `employee_id` int(10) NOT NULL,
  `deleted` int(1) NOT NULL DEFAULT 0,
  `supplier_tax_code` varchar(255) DEFAULT NULL,
  `tax_amount` decimal(15,2) DEFAULT NULL,
  `supplier_id` int(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `ospos_expense_categories`
--

CREATE TABLE `ospos_expense_categories` (
  `expense_category_id` int(10) NOT NULL,
  `category_name` varchar(255) DEFAULT NULL,
  `category_description` varchar(255) NOT NULL,
  `deleted` int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ospos_expense_categories`
--

INSERT INTO `ospos_expense_categories` (`expense_category_id`, `category_name`, `category_description`, `deleted`) VALUES
(1, 'Pelunasan Jatuh Tempo', '', 0),
(2, 'Operasional', '', 0),
(3, 'Pengiriman', '', 0);

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

--
-- Table structure for table `ospos_giftcards`
--

CREATE TABLE `ospos_giftcards` (
  `record_time` timestamp NOT NULL DEFAULT current_timestamp(),
  `giftcard_id` int(11) NOT NULL,
  `giftcard_number` varchar(255) DEFAULT NULL,
  `value` decimal(15,2) NOT NULL,
  `deleted` int(1) NOT NULL DEFAULT 0,
  `person_id` int(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `ospos_grants`
--

CREATE TABLE `ospos_grants` (
  `permission_id` varchar(255) NOT NULL,
  `person_id` int(10) NOT NULL,
  `menu_group` varchar(32) DEFAULT 'home'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ospos_grants`
--

INSERT INTO `ospos_grants` (`permission_id`, `person_id`, `menu_group`) VALUES
('attributes', 1, 'office'),
('attributes', 74, 'home'),
('cashups', 1, 'home'),
('cashups', 74, 'home'),
('config', 1, 'office'),
('config', 74, 'home'),
('customers', 1, 'home'),
('customers', 74, 'home'),
('employees', 1, 'office'),
('employees', 74, 'home'),
('expenses', 1, 'home'),
('expenses', 74, 'home'),
('expenses_categories', 1, 'home'),
('expenses_categories', 74, 'home'),
('giftcards', 1, 'home'),
('giftcards', 74, 'home'),
('home', 1, 'office'),
('home', 74, 'home'),
('items', 1, 'home'),
('items', 74, 'home'),
('items_stock', 1, '--'),
('items_stock', 74, '--'),
('item_kits', 1, 'home'),
('item_kits', 74, 'home'),
('messages', 1, 'home'),
('messages', 74, 'home'),
('office', 1, 'home'),
('receivings', 1, 'home'),
('receivings', 74, 'home'),
('receivings_stock', 1, '--'),
('receivings_stock', 74, '--'),
('reports', 1, 'home'),
('reports', 74, 'home'),
('reports_categories', 1, '--'),
('reports_categories', 74, '--'),
('reports_customers', 1, '--'),
('reports_customers', 74, '--'),
('reports_discounts', 1, '--'),
('reports_discounts', 74, '--'),
('reports_employees', 1, '--'),
('reports_employees', 74, '--'),
('reports_expenses_categories', 1, '--'),
('reports_expenses_categories', 74, '--'),
('reports_inventory', 1, '--'),
('reports_inventory', 74, '--'),
('reports_items', 1, '--'),
('reports_items', 74, '--'),
('reports_payments', 1, '--'),
('reports_payments', 74, '--'),
('reports_receivings', 1, '--'),
('reports_receivings', 74, '--'),
('reports_sales', 1, '--'),
('reports_sales', 74, '--'),
('reports_sales_taxes', 1, '--'),
('reports_sales_taxes', 74, '--'),
('reports_suppliers', 1, '--'),
('reports_suppliers', 74, '--'),
('reports_taxes', 1, '--'),
('reports_taxes', 74, '--'),
('sales', 1, 'home'),
('sales', 74, 'home'),
('sales_change_price', 1, '--'),
('sales_change_price', 74, '--'),
('sales_delete', 1, '--'),
('sales_delete', 74, '--'),
('sales_stock', 1, '--'),
('sales_stock', 74, '--'),
('suppliers', 1, 'home'),
('suppliers', 74, 'home'),
('surveillance_cams', 74, 'home'),
('taxes', 1, 'office'),
('taxes', 74, 'home'),
('time_attendances', 74, 'home');

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

--
-- Table structure for table `ospos_inventory`
--

CREATE TABLE `ospos_inventory` (
  `trans_id` int(11) NOT NULL,
  `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 NOT NULL,
  `trans_location` int(11) NOT NULL,
  `trans_inventory` decimal(15,3) NOT NULL DEFAULT 0.000
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ospos_inventory`
--

INSERT INTO `ospos_inventory` (`trans_id`, `trans_items`, `trans_user`, `trans_date`, `trans_comment`, `trans_location`, `trans_inventory`) VALUES
(1, 1, 1, '2021-12-01 05:56:25', 'Perubahan jumlah Stok secara manual', 1, '1000.000'),
(2, 1, 1, '2022-01-07 19:50:43', 'POS 1', 1, '-1.000'),
(3, 1, 1, '2022-01-07 19:59:36', '', 1, '990.000'),
(4, 1, 1, '2022-01-07 19:59:49', '', 1, '-989.000'),
(5, 2, 1, '2022-01-07 20:15:55', 'Perubahan jumlah Stok secara manual', 1, '1000.000'),
(6, 1, 1, '2022-01-07 20:23:20', '', 1, '-200.000'),
(7, 1, 1, '2022-01-07 20:29:25', 'POS 2', 1, '-1.000'),
(8, 1, 1, '2022-01-07 20:37:05', 'POS 3', 1, '-1.000'),
(9, 1, 74, '2022-01-10 16:24:34', 'POS 4', 1, '-5.000'),
(10, 3, 1, '2022-01-10 02:08:54', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(11, 4, 1, '2022-01-10 02:08:54', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(12, 5, 1, '2022-01-10 02:08:54', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(13, 6, 1, '2022-01-10 02:08:54', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(14, 7, 1, '2022-01-10 02:08:54', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(15, 8, 1, '2022-01-10 02:08:54', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(16, 9, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(17, 10, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(18, 11, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(19, 12, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(20, 13, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(21, 14, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(22, 15, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(23, 16, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(24, 17, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(25, 18, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(26, 19, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(27, 20, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(28, 21, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(29, 22, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(30, 23, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(31, 24, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(32, 25, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(33, 26, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(34, 27, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(35, 28, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(36, 29, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(37, 30, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(38, 31, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(39, 32, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(40, 33, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(41, 34, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(42, 35, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(43, 36, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(44, 37, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(45, 38, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(46, 39, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(47, 40, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(48, 41, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(49, 42, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(50, 43, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(51, 44, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(52, 45, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(53, 46, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(54, 47, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(55, 48, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(56, 49, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(57, 50, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(58, 51, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(59, 52, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(60, 53, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(61, 54, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(62, 55, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(63, 56, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(64, 57, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(65, 58, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(66, 59, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(67, 60, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(68, 61, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(69, 62, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(70, 63, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(71, 64, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(72, 65, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(73, 66, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(74, 67, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(75, 68, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(76, 69, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(77, 70, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(78, 71, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(79, 72, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(80, 73, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(81, 74, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(82, 75, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(83, 76, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(84, 77, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(85, 78, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(86, 79, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(87, 80, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(88, 81, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(89, 82, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(90, 83, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(91, 84, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(92, 85, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(93, 86, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(94, 87, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(95, 88, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(96, 89, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(97, 90, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(98, 91, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(99, 92, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(100, 93, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(101, 94, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(102, 95, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(103, 96, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(104, 97, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(105, 98, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(106, 99, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(107, 100, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(108, 101, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(109, 102, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(110, 103, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(111, 104, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(112, 105, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(113, 106, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(114, 107, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(115, 108, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(116, 109, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(117, 110, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(118, 111, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(119, 112, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(120, 113, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(121, 114, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(122, 115, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(123, 116, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(124, 117, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(125, 118, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(126, 119, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(127, 120, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(128, 121, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(129, 122, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(130, 123, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(131, 124, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(132, 125, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(133, 126, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(134, 127, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(135, 128, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(136, 129, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(137, 130, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(138, 131, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(139, 132, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(140, 133, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(141, 134, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(142, 135, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(143, 136, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(144, 137, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(145, 138, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(146, 139, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(147, 140, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(148, 141, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(149, 142, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(150, 143, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(151, 144, 1, '2022-01-10 02:08:55', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(152, 145, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(153, 146, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(154, 147, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(155, 148, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(156, 149, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(157, 150, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(158, 151, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(159, 152, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(160, 153, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(161, 154, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(162, 155, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(163, 156, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(164, 157, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(165, 158, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(166, 159, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(167, 160, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(168, 161, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(169, 162, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(170, 163, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(171, 164, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(172, 165, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(173, 166, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(174, 167, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(175, 168, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(176, 169, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(177, 170, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(178, 171, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(179, 172, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(180, 173, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(181, 174, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(182, 175, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(183, 176, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(184, 177, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(185, 178, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(186, 179, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(187, 180, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(188, 181, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(189, 182, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(190, 183, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(191, 184, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(192, 185, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(193, 186, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(194, 187, 1, '2022-01-10 02:08:56', 'Jumlah telah diimpor dari CSV', 1, '1.000'),
(195, 1, 74, '2022-01-11 09:37:00', 'pengurang stok barang', 1, '-788.000'),
(196, 2, 74, '2022-01-11 09:38:28', 'Perubahan jumlah Stok secara manual', 1, '-997.000'),
(197, 5, 74, '2022-01-16 16:44:23', 'POS 5', 1, '-1.000'),
(198, 20, 74, '2022-01-17 14:12:13', 'POS 6', 1, '-5.000'),
(199, 27, 74, '2022-01-17 14:12:13', 'POS 6', 1, '-7.000'),
(200, 9, 74, '2022-01-17 14:12:13', 'POS 6', 1, '-2.000'),
(201, 1, 74, '2022-01-17 14:17:27', 'Perubahan jumlah Stok secara manual', 1, '-3.000'),
(202, 2, 74, '2022-01-17 14:18:16', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(203, 3, 74, '2022-01-17 14:18:27', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(204, 4, 74, '2022-01-17 14:18:39', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(205, 6, 74, '2022-01-17 14:19:09', 'Perubahan jumlah Stok secara manual', 1, '3.000'),
(206, 182, 74, '2022-01-17 14:21:49', 'RECV 1', 1, '100.000'),
(207, 122, 74, '2022-01-18 12:44:17', 'POS 7', 1, '-4.000'),
(208, 80, 74, '2022-01-18 12:44:17', 'POS 7', 1, '-2.000'),
(209, 94, 74, '2022-01-18 12:44:17', 'POS 7', 1, '-2.000'),
(210, 183, 74, '2022-01-18 12:44:17', 'POS 7', 1, '-1.000'),
(211, 149, 74, '2022-01-18 12:44:17', 'POS 7', 1, '-1.000'),
(212, 62, 74, '2022-01-18 12:44:17', 'POS 7', 1, '-1.000'),
(213, 145, 74, '2022-01-19 06:59:55', 'POS 8', 1, '-1.000'),
(214, 15, 74, '2022-01-19 07:50:11', 'POS 9', 1, '-1.000'),
(215, 62, 74, '2022-01-19 07:50:11', 'POS 9', 1, '-1.000'),
(216, 71, 74, '2022-01-19 07:50:11', 'POS 9', 1, '-1.000'),
(217, 15, 74, '2022-01-19 07:53:04', 'Deleting sale 9', 1, '1.000'),
(218, 62, 74, '2022-01-19 07:53:04', 'Deleting sale 9', 1, '1.000'),
(219, 71, 74, '2022-01-19 07:53:04', 'Deleting sale 9', 1, '1.000'),
(220, 15, 74, '2022-01-19 07:56:04', 'POS 10', 1, '-1.000'),
(221, 62, 74, '2022-01-19 07:56:04', 'POS 10', 1, '-1.000'),
(222, 71, 74, '2022-01-19 07:56:04', 'POS 10', 1, '-1.000'),
(223, 149, 74, '2022-01-19 07:56:04', 'POS 10', 1, '-1.000'),
(224, 6, 1, '2022-01-19 11:46:59', 'Perubahan jumlah Stok secara manual', 1, '-2.000'),
(225, 7, 1, '2022-01-19 11:47:16', 'Perubahan jumlah Stok secara manual', 1, '5.000'),
(226, 8, 1, '2022-01-19 11:47:28', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(227, 10, 1, '2022-01-19 11:47:45', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(228, 9, 1, '2022-01-19 11:47:53', 'Perubahan jumlah Stok secara manual', 1, '1.000'),
(229, 1, 1, '2022-01-19 11:48:32', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(230, 14, 1, '2022-01-19 11:49:21', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(231, 23, 1, '2022-01-19 11:49:57', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(232, 25, 1, '2022-01-19 11:50:41', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(233, 27, 74, '2022-01-19 11:53:05', 'POS 11', 1, '-5.000'),
(234, 26, 1, '2022-01-19 11:53:07', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(235, 28, 1, '2022-01-19 11:53:42', 'Perubahan jumlah Stok secara manual', 1, '2.000'),
(236, 29, 1, '2022-01-19 11:54:02', 'Perubahan jumlah Stok secara manual', 1, '1.000'),
(237, 30, 1, '2022-01-19 11:54:19', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(238, 33, 1, '2022-01-19 11:56:07', 'Perubahan jumlah Stok secara manual', 1, '15.000'),
(239, 35, 1, '2022-01-18 20:56:41', 'Item dihapus', 1, '-1.000'),
(240, 36, 1, '2022-01-19 11:57:52', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(241, 38, 1, '2022-01-19 11:58:38', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(242, 39, 1, '2022-01-19 11:59:59', 'Perubahan jumlah Stok secara manual', 1, '9.000'),
(243, 40, 1, '2022-01-19 12:00:11', 'Perubahan jumlah Stok secara manual', 1, '2.000'),
(244, 41, 1, '2022-01-19 12:01:30', 'Perubahan jumlah Stok secara manual', 1, '27.000'),
(245, 43, 1, '2022-01-19 12:02:05', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(246, 42, 1, '2022-01-19 12:04:02', 'Perubahan jumlah Stok secara manual', 1, '46.000'),
(247, 51, 1, '2022-01-19 12:05:39', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(248, 50, 1, '2022-01-19 12:09:38', 'Perubahan jumlah Stok secara manual', 1, '115.000'),
(249, 54, 1, '2022-01-19 12:11:57', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(250, 55, 1, '2022-01-19 12:12:22', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(251, 94, 1, '2022-01-19 12:14:29', 'Perubahan jumlah Stok secara manual', 1, '210.000'),
(252, 56, 1, '2022-01-19 12:15:14', 'Perubahan jumlah Stok secara manual', 1, '20.000'),
(253, 58, 1, '2022-01-19 12:16:29', 'Perubahan jumlah Stok secara manual', 1, '11.000'),
(254, 59, 1, '2022-01-19 12:17:44', 'Perubahan jumlah Stok secara manual', 1, '25.000'),
(255, 60, 1, '2022-01-19 12:18:27', 'Perubahan jumlah Stok secara manual', 1, '13.000'),
(256, 61, 1, '2022-01-19 12:19:01', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(257, 95, 1, '2022-01-19 12:20:35', 'Perubahan jumlah Stok secara manual', 1, '125.000'),
(258, 131, 74, '2022-01-19 12:22:08', 'POS 12', 1, '-1.000'),
(259, 174, 74, '2022-01-19 12:22:08', 'POS 12', 1, '-1.000'),
(260, 63, 1, '2022-01-19 12:27:58', 'Perubahan jumlah Stok secara manual', 1, '103.000'),
(261, 96, 1, '2022-01-19 12:28:29', 'Perubahan jumlah Stok secara manual', 1, '209.000'),
(262, 59, 1, '2022-01-19 12:28:52', 'Perubahan jumlah Stok secara manual', 1, '3.000'),
(263, 65, 1, '2022-01-19 12:30:00', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(264, 66, 1, '2022-01-19 12:33:00', 'Perubahan jumlah Stok secara manual', 1, '36.000'),
(265, 67, 1, '2022-01-19 12:33:42', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(266, 68, 1, '2022-01-19 12:33:58', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(267, 72, 1, '2022-01-19 12:35:04', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(268, 74, 1, '2022-01-19 12:35:27', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(269, 75, 1, '2022-01-19 12:36:35', 'Perubahan jumlah Stok secara manual', 1, '18.000'),
(270, 123, 74, '2022-01-19 12:37:13', 'POS 13', 1, '-2.000'),
(271, 79, 1, '2022-01-19 12:38:26', 'Perubahan jumlah Stok secara manual', 1, '23.000'),
(272, 81, 1, '2022-01-19 12:40:23', 'Perubahan jumlah Stok secara manual', 1, '39.000'),
(273, 82, 1, '2022-01-19 12:40:40', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(274, 83, 1, '2022-01-19 12:40:53', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(275, 84, 1, '2022-01-19 12:42:41', 'Perubahan jumlah Stok secara manual', 1, '107.000'),
(276, 85, 1, '2022-01-19 12:43:31', 'Perubahan jumlah Stok secara manual', 1, '13.000'),
(277, 97, 1, '2022-01-19 12:44:02', 'Perubahan jumlah Stok secara manual', 1, '179.000'),
(278, 98, 1, '2022-01-19 12:44:17', 'Perubahan jumlah Stok secara manual', 1, '100.000'),
(279, 99, 1, '2022-01-19 12:44:38', 'Perubahan jumlah Stok secara manual', 1, '14.000'),
(280, 86, 1, '2022-01-19 12:45:43', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(281, 87, 1, '2022-01-19 12:46:02', 'Perubahan jumlah Stok secara manual', 1, '3.000'),
(282, 88, 1, '2022-01-19 12:46:51', 'Perubahan jumlah Stok secara manual', 1, '13.000'),
(283, 89, 1, '2022-01-19 12:47:12', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(284, 90, 1, '2022-01-19 12:47:35', 'Perubahan jumlah Stok secara manual', 1, '25.000'),
(285, 91, 1, '2022-01-19 12:48:44', 'Perubahan jumlah Stok secara manual', 1, '21.000'),
(286, 92, 1, '2022-01-19 12:49:02', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(287, 93, 1, '2022-01-19 12:49:17', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(288, 100, 1, '2022-01-19 12:49:43', 'Perubahan jumlah Stok secara manual', 1, '13.000'),
(289, 101, 1, '2022-01-19 12:49:57', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(290, 102, 1, '2022-01-19 12:50:22', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(291, 103, 1, '2022-01-19 12:50:28', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(292, 104, 1, '2022-01-19 12:50:37', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(293, 105, 1, '2022-01-19 12:50:48', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(294, 106, 1, '2022-01-19 12:51:27', 'Perubahan jumlah Stok secara manual', 1, '41.000'),
(295, 107, 1, '2022-01-19 12:51:41', 'Perubahan jumlah Stok secara manual', 1, '999.000'),
(296, 108, 1, '2022-01-19 12:51:54', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(297, 109, 1, '2022-01-19 12:52:08', 'Perubahan jumlah Stok secara manual', 1, '999.000'),
(298, 111, 1, '2022-01-19 12:52:44', 'Perubahan jumlah Stok secara manual', 1, '999.000'),
(299, 112, 1, '2022-01-19 12:52:54', 'Perubahan jumlah Stok secara manual', 1, '999.000'),
(300, 113, 1, '2022-01-19 12:53:02', 'Perubahan jumlah Stok secara manual', 1, '999.000'),
(301, 114, 1, '2022-01-19 12:53:11', 'Perubahan jumlah Stok secara manual', 1, '999.000'),
(302, 115, 1, '2022-01-19 12:53:30', 'Perubahan jumlah Stok secara manual', 1, '999.000'),
(303, 110, 1, '2022-01-19 12:53:48', 'Perubahan jumlah Stok secara manual', 1, '28.000'),
(304, 116, 1, '2022-01-19 12:54:03', 'Perubahan jumlah Stok secara manual', 1, '999.000'),
(305, 117, 1, '2022-01-19 12:54:13', 'Perubahan jumlah Stok secara manual', 1, '999.000'),
(306, 118, 1, '2022-01-19 12:54:23', 'Perubahan jumlah Stok secara manual', 1, '999.000'),
(307, 120, 1, '2022-01-19 12:55:02', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(308, 123, 1, '2022-01-19 12:56:21', 'Perubahan jumlah Stok secara manual', 1, '1001.000'),
(309, 122, 1, '2022-01-19 12:56:44', 'Perubahan jumlah Stok secara manual', 1, '80.000'),
(310, 121, 1, '2022-01-19 12:57:00', 'Perubahan jumlah Stok secara manual', 1, '32.000'),
(311, 124, 1, '2022-01-19 12:58:09', 'Perubahan jumlah Stok secara manual', 1, '149.000'),
(312, 119, 1, '2022-01-19 12:58:28', 'Perubahan jumlah Stok secara manual', 1, '352.000'),
(313, 125, 1, '2022-01-19 12:58:53', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(314, 126, 1, '2022-01-19 12:59:15', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(315, 127, 1, '2022-01-19 12:59:59', 'Perubahan jumlah Stok secara manual', 1, '6.000'),
(316, 129, 1, '2022-01-19 13:00:24', 'Perubahan jumlah Stok secara manual', 1, '999.000'),
(317, 130, 1, '2022-01-19 13:00:38', 'Perubahan jumlah Stok secara manual', 1, '999.000'),
(318, 131, 1, '2022-01-19 13:00:51', 'Perubahan jumlah Stok secara manual', 1, '1000.000'),
(319, 132, 1, '2022-01-19 13:01:11', 'Perubahan jumlah Stok secara manual', 1, '999.000'),
(320, 133, 1, '2022-01-19 13:01:38', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(321, 134, 1, '2022-01-19 13:02:24', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(322, 136, 1, '2022-01-19 13:02:45', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(323, 128, 1, '2022-01-19 13:02:55', 'Perubahan jumlah Stok secara manual', 1, '70.000'),
(324, 137, 1, '2022-01-19 13:03:11', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(325, 138, 1, '2022-01-19 13:03:28', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(326, 139, 1, '2022-01-19 13:03:41', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(327, 141, 1, '2022-01-19 13:04:17', 'Perubahan jumlah Stok secara manual', 1, '999.000'),
(328, 142, 1, '2022-01-19 13:04:42', 'Perubahan jumlah Stok secara manual', 1, '999.000'),
(329, 143, 1, '2022-01-19 13:04:56', 'Perubahan jumlah Stok secara manual', 1, '999.000'),
(330, 140, 1, '2022-01-19 13:05:09', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(331, 144, 1, '2022-01-19 13:05:28', 'Perubahan jumlah Stok secara manual', 1, '999.000'),
(332, 133, 1, '2022-01-19 13:05:41', 'Perubahan jumlah Stok secara manual', 1, '1000.000'),
(333, 133, 1, '2022-01-19 13:05:55', 'Perubahan jumlah Stok secara manual', 1, '-1000.000'),
(334, 150, 1, '2022-01-19 13:06:19', 'Perubahan jumlah Stok secara manual', 1, '999.000'),
(335, 145, 1, '2022-01-19 13:06:37', 'Perubahan jumlah Stok secara manual', 1, '1000.000'),
(336, 151, 1, '2022-01-19 13:06:49', 'Perubahan jumlah Stok secara manual', 1, '10.000'),
(337, 152, 1, '2022-01-19 13:07:01', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(338, 153, 1, '2022-01-19 13:08:59', 'Perubahan jumlah Stok secara manual', 1, '50.000'),
(339, 154, 1, '2022-01-19 13:09:36', 'Perubahan jumlah Stok secara manual', 1, '999.000'),
(340, 155, 1, '2022-01-19 13:10:00', 'Perubahan jumlah Stok secara manual', 1, '999.000'),
(341, 156, 1, '2022-01-19 13:10:16', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(342, 157, 1, '2022-01-19 13:12:40', 'Perubahan jumlah Stok secara manual', 1, '30.000'),
(343, 159, 1, '2022-01-19 13:15:10', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(344, 158, 1, '2022-01-19 13:15:38', 'Perubahan jumlah Stok secara manual', 1, '21.000'),
(345, 165, 1, '2022-01-19 13:18:25', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(346, 167, 1, '2022-01-19 13:19:00', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(347, 168, 1, '2022-01-19 13:19:11', 'Perubahan jumlah Stok secara manual', 1, '9.000'),
(348, 168, 1, '2022-01-19 13:19:22', 'Perubahan jumlah Stok secara manual', 1, '-10.000'),
(349, 169, 1, '2022-01-19 13:19:39', 'Perubahan jumlah Stok secara manual', 1, '999.000'),
(350, 159, 1, '2022-01-19 13:20:01', 'Perubahan jumlah Stok secara manual', 1, '62.000'),
(351, 163, 1, '2022-01-19 13:20:31', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(352, 162, 1, '2022-01-19 13:22:09', 'Perubahan jumlah Stok secara manual', 1, '999.000'),
(353, 161, 1, '2022-01-19 13:23:49', 'Perubahan jumlah Stok secara manual', 1, '87.000'),
(354, 164, 1, '2022-01-19 13:24:42', 'Perubahan jumlah Stok secara manual', 1, '31.000'),
(355, 166, 1, '2022-01-19 13:25:44', 'Perubahan jumlah Stok secara manual', 1, '63.000'),
(356, 170, 1, '2022-01-19 13:26:01', 'Perubahan jumlah Stok secara manual', 1, '999.000'),
(357, 171, 1, '2022-01-19 13:26:18', 'Perubahan jumlah Stok secara manual', 1, '999.000'),
(358, 172, 1, '2022-01-19 13:26:34', 'Perubahan jumlah Stok secara manual', 1, '999.000'),
(359, 173, 1, '2022-01-19 13:26:50', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(360, 175, 1, '2022-01-19 13:28:12', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(361, 44, 74, '2022-01-19 13:28:16', 'POS 14', 1, '-5.000'),
(362, 176, 1, '2022-01-19 13:28:59', 'Perubahan jumlah Stok secara manual', 1, '10.000'),
(363, 177, 1, '2022-01-19 13:33:53', 'Perubahan jumlah Stok secara manual', 1, '22.000'),
(364, 178, 1, '2022-01-19 13:35:33', 'Perubahan jumlah Stok secara manual', 1, '127.000'),
(365, 179, 1, '2022-01-19 13:35:55', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(366, 180, 1, '2022-01-19 13:37:43', 'Perubahan jumlah Stok secara manual', 1, '3.000'),
(367, 181, 1, '2022-01-19 13:38:35', 'Perubahan jumlah Stok secara manual', 1, '3.000'),
(368, 80, 1, '2022-01-19 13:47:53', 'Perubahan jumlah Stok secara manual', 1, '39.000'),
(369, 95, 1, '2022-01-19 13:48:39', 'Perubahan jumlah Stok secara manual', 1, '-10.000'),
(370, 62, 1, '2022-01-19 13:52:23', 'Perubahan jumlah Stok secara manual', 1, '945.000'),
(371, 49, 1, '2022-01-19 13:58:32', 'Perubahan jumlah Stok secara manual', 1, '153.000'),
(372, 52, 1, '2022-01-19 13:59:14', 'Perubahan jumlah Stok secara manual', 1, '52.000'),
(373, 16, 74, '2022-01-19 13:59:19', 'POS 15', 1, '-10.000'),
(374, 53, 1, '2022-01-19 13:59:29', 'Perubahan jumlah Stok secara manual', 1, '769.000'),
(375, 57, 1, '2022-01-19 13:59:59', 'Perubahan jumlah Stok secara manual', 1, '30.000'),
(376, 73, 1, '2022-01-19 14:00:24', 'Perubahan jumlah Stok secara manual', 1, '46.000'),
(377, 70, 1, '2022-01-19 14:00:53', 'Perubahan jumlah Stok secara manual', 1, '60.000'),
(378, 188, 1, '2022-01-19 14:06:13', 'Perubahan jumlah Stok secara manual', 1, '38.000'),
(379, 112, 1, '2022-01-19 14:06:42', 'Perubahan jumlah Stok secara manual', 1, '-885.000'),
(380, 113, 1, '2022-01-19 14:07:01', 'Perubahan jumlah Stok secara manual', 1, '-970.000'),
(381, 111, 1, '2022-01-19 14:07:16', 'Perubahan jumlah Stok secara manual', 1, '-937.000'),
(382, 71, 1, '2022-01-19 14:07:39', 'Perubahan jumlah Stok secara manual', 1, '299.000'),
(383, 37, 1, '2022-01-19 14:08:28', 'Perubahan jumlah Stok secara manual', 1, '10.000'),
(384, 45, 1, '2022-01-19 14:09:03', 'Perubahan jumlah Stok secara manual', 1, '245.000'),
(385, 59, 1, '2022-01-19 14:21:41', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(386, 159, 1, '2022-01-19 14:44:07', 'Perubahan jumlah Stok secara manual', 1, '-1.000'),
(387, 56, 74, '2022-01-19 16:23:11', 'POS 16', 1, '-1.000'),
(388, 159, 74, '2022-01-20 10:02:17', 'POS 17', 1, '-50.000'),
(389, 123, 74, '2022-01-20 10:06:54', 'POS 18', 1, '-10.000'),
(390, 48, 74, '2022-01-20 10:06:54', 'POS 18', 1, '-25.000'),
(391, 122, 1, '2022-01-20 10:25:39', 'POS 19', 1, '-4.000'),
(392, 124, 1, '2022-01-20 10:25:39', 'POS 19', 1, '-4.000'),
(393, 53, 1, '2022-01-20 10:25:39', 'POS 19', 1, '-3.000'),
(394, 159, 74, '2022-01-20 12:28:59', 'POS 20', 1, '-10.000'),
(395, 132, 74, '2022-01-20 12:28:59', 'POS 20', 1, '-5.000'),
(396, 62, 74, '2022-01-20 12:28:59', 'POS 20', 1, '-5.000'),
(397, 71, 74, '2022-01-20 12:28:59', 'POS 20', 1, '-5.000'),
(398, 85, 74, '2022-01-20 12:28:59', 'POS 20', 1, '-5.000'),
(399, 1, 1, '2022-01-20 13:00:02', 'POS 21', 1, '-1.000'),
(400, 91, 74, '2022-01-20 13:06:57', 'POS 22', 1, '-3.000'),
(401, 159, 74, '2022-01-20 13:06:57', 'POS 22', 1, '-1.000'),
(402, 91, 1, '2022-01-20 13:09:20', 'POS 23', 1, '-3.000'),
(403, 159, 1, '2022-01-20 13:09:20', 'POS 23', 1, '-1.000'),
(404, 75, 1, '2022-01-20 13:15:49', 'POS 24', 1, '-4.000'),
(405, 75, 1, '2022-01-20 13:18:06', 'POS 25', 1, '-4.000'),
(406, 24, 1, '2022-01-20 13:25:44', 'Perubahan jumlah Stok secara manual', 1, '196.000'),
(407, 22, 1, '2022-01-20 13:26:30', 'Perubahan jumlah Stok secara manual', 1, '79.000'),
(408, 48, 1, '2022-01-20 13:29:50', 'Perubahan jumlah Stok secara manual', 1, '323.000'),
(409, 27, 1, '2022-01-20 13:32:30', 'Perubahan jumlah Stok secara manual', 1, '227.000'),
(410, 12, 1, '2022-01-20 13:32:55', 'Perubahan jumlah Stok secara manual', 1, '39.000'),
(411, 188, 1, '2022-01-20 16:04:10', 'POS 26', 1, '-1.000'),
(412, 188, 1, '2022-01-20 16:09:29', 'POS 27', 1, '-1.000'),
(413, 189, 1, '2022-01-21 07:16:57', 'Perubahan jumlah Stok secara manual', 1, '85.000'),
(414, 190, 1, '2022-01-21 07:18:48', 'Perubahan jumlah Stok secara manual', 1, '29.000'),
(415, 17, 1, '2022-01-21 08:22:25', 'POS 28', 1, '-5.000'),
(416, 63, 74, '2022-01-21 08:25:50', 'POS 29', 1, '-15.000'),
(417, 71, 74, '2022-01-21 08:25:50', 'POS 29', 1, '-5.000'),
(418, 17, 74, '2022-01-21 10:22:12', 'POS 30', 1, '-1.000'),
(419, 80, 74, '2022-01-21 11:31:58', 'POS 31', 1, '-1.000'),
(420, 191, 74, '2022-01-21 12:05:50', 'Perubahan jumlah Stok secara manual', 1, '50.000'),
(421, 191, 74, '2022-01-21 12:06:33', 'POS 32', 1, '-3.000'),
(422, 16, 1, '2022-01-21 12:31:34', 'Perubahan jumlah Stok secara manual', 1, '188.000'),
(423, 20, 1, '2022-01-21 12:31:59', 'Perubahan jumlah Stok secara manual', 1, '135.000'),
(424, 18, 1, '2022-01-21 12:32:17', 'Perubahan jumlah Stok secara manual', 1, '36.000'),
(425, 17, 1, '2022-01-21 12:32:35', 'Perubahan jumlah Stok secara manual', 1, '61.000'),
(426, 15, 1, '2022-01-21 12:32:50', 'Perubahan jumlah Stok secara manual', 1, '78.000'),
(427, 19, 1, '2022-01-21 12:33:08', 'Perubahan jumlah Stok secara manual', 1, '27.000'),
(428, 21, 1, '2022-01-21 12:33:31', 'Perubahan jumlah Stok secara manual', 1, '100.000'),
(429, 16, 1, '2022-01-21 12:33:59', 'Perubahan jumlah Stok secara manual', 1, '-153.000'),
(430, 154, 1, '2022-01-21 12:34:29', 'Perubahan jumlah Stok secara manual', 1, '-983.000'),
(431, 169, 1, '2022-01-21 12:35:51', 'Perubahan jumlah Stok secara manual', 1, '-914.000'),
(432, 172, 1, '2022-01-21 12:36:39', 'Perubahan jumlah Stok secara manual', 1, '-889.000'),
(433, 170, 1, '2022-01-21 12:37:02', 'Perubahan jumlah Stok secara manual', 1, '-925.000'),
(434, 192, 1, '2022-01-21 12:38:30', 'Perubahan jumlah Stok secara manual', 1, '552.000'),
(435, 182, 1, '2022-01-21 12:39:06', 'Perubahan jumlah Stok secara manual', 1, '66.000'),
(436, 183, 1, '2022-01-21 12:39:17', 'Perubahan jumlah Stok secara manual', 1, '122.000'),
(437, 184, 1, '2022-01-21 12:39:27', 'Perubahan jumlah Stok secara manual', 1, '105.000'),
(438, 185, 1, '2022-01-21 12:39:44', 'Perubahan jumlah Stok secara manual', 1, '155.000'),
(439, 186, 1, '2022-01-21 12:39:53', 'Perubahan jumlah Stok secara manual', 1, '176.000'),
(440, 187, 1, '2022-01-21 12:40:04', 'Perubahan jumlah Stok secara manual', 1, '118.000'),
(441, 47, 1, '2022-01-21 12:40:50', 'Perubahan jumlah Stok secara manual', 1, '324.000'),
(442, 193, 1, '2022-01-21 12:42:41', 'Perubahan jumlah Stok secara manual', 1, '179.000'),
(443, 194, 1, '2022-01-21 12:42:47', 'Perubahan jumlah Stok secara manual', 1, '179.000'),
(444, 195, 1, '2022-01-21 12:42:49', 'Perubahan jumlah Stok secara manual', 1, '179.000'),
(445, 194, 1, '2022-01-20 21:55:19', 'Item dihapus', 1, '-179.000'),
(446, 195, 1, '2022-01-20 21:55:19', 'Item dihapus', 1, '-179.000'),
(447, 196, 1, '2022-01-21 12:56:21', 'Perubahan jumlah Stok secara manual', 1, '160.000'),
(448, 196, 1, '2022-01-21 12:57:16', 'Perubahan jumlah Stok secara manual', 1, '45.000'),
(449, 123, 1, '2022-01-21 12:57:45', 'Perubahan jumlah Stok secara manual', 1, '-941.000'),
(450, 169, 1, '2022-01-21 12:59:05', 'Perubahan jumlah Stok secara manual', 1, '120.000'),
(451, 123, 1, '2022-01-21 12:59:40', 'Perubahan jumlah Stok secara manual', 1, '990.000'),
(452, 197, 74, '2022-01-21 14:48:10', 'Perubahan jumlah Stok secara manual', 1, '50.000'),
(453, 138, 74, '2022-01-21 14:52:20', 'POS 33', 1, '-1.000'),
(454, 197, 74, '2022-01-21 14:52:20', 'POS 33', 1, '-1.000'),
(455, 159, 74, '2022-01-21 14:52:20', 'POS 33', 1, '-1.000'),
(456, 71, 74, '2022-01-21 14:52:20', 'POS 33', 1, '-1.000'),
(457, 166, 74, '2022-01-22 12:06:47', 'POS 34', 1, '-1.000'),
(458, 131, 74, '2022-01-22 12:06:47', 'POS 34', 1, '-1.000'),
(459, 130, 74, '2022-01-22 12:06:47', 'POS 34', 1, '-1.000'),
(460, 193, 74, '2022-01-22 12:06:47', 'POS 34', 1, '-2.000'),
(461, 123, 74, '2022-01-22 12:06:47', 'POS 34', 1, '-1.000'),
(462, 198, 1, '2022-01-22 12:31:02', 'Perubahan jumlah Stok secara manual', 1, '100.000'),
(463, 199, 1, '2022-01-22 12:31:06', 'Perubahan jumlah Stok secara manual', 1, '100.000'),
(464, 197, 1, '2022-01-22 12:31:37', 'Perubahan jumlah Stok secara manual', 1, '81.000'),
(465, 2, 74, '2022-01-22 12:32:28', 'POS 35', 1, '-1.000'),
(466, 81, 74, '2022-01-22 12:32:28', 'POS 35', 1, '-2.000'),
(467, 200, 74, '2022-01-22 15:00:45', 'Perubahan jumlah Stok secara manual', 1, '0.000'),
(468, 201, 74, '2022-01-22 15:01:37', 'Perubahan jumlah Stok secara manual', 1, '4.000'),
(469, 201, 74, '2022-01-22 15:02:03', 'POS 36', 1, '-1.000'),
(470, 202, 74, '2022-01-22 18:37:45', 'Perubahan jumlah Stok secara manual', 1, '0.000'),
(471, 203, 74, '2022-01-22 18:38:17', 'Perubahan jumlah Stok secara manual', 1, '1.000'),
(472, 202, 74, '2022-01-22 18:42:06', 'POS 37', 1, '-1.000'),
(473, 198, 74, '2022-01-22 03:48:54', 'Item dihapus', 1, '-100.000'),
(474, 22, 74, '2022-01-22 18:51:22', 'Perubahan jumlah Stok secara manual', 1, '-50.000'),
(475, 31, 74, '2022-01-22 18:55:14', 'Perubahan jumlah Stok secara manual', 1, '19.000'),
(476, 32, 74, '2022-01-22 18:55:28', 'Perubahan jumlah Stok secara manual', 1, '9.000'),
(477, 44, 74, '2022-01-22 18:56:33', 'Perubahan jumlah Stok secara manual', 1, '5.000'),
(478, 11, 74, '2022-01-22 19:43:08', 'POS 38', 1, '-1.000');

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

--
-- Table structure for table `ospos_items`
--

CREATE TABLE `ospos_items` (
  `name` varchar(255) NOT NULL,
  `category` varchar(255) NOT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `item_number` varchar(255) DEFAULT NULL,
  `description` varchar(255) NOT NULL,
  `cost_price` decimal(15,2) NOT NULL,
  `unit_price` decimal(15,2) NOT NULL,
  `unit_price_guest` decimal(15,2) NOT NULL,
  `unit_price_member_lot` decimal(15,2) NOT NULL,
  `reorder_level` decimal(15,3) NOT NULL DEFAULT 0.000,
  `receiving_quantity` decimal(15,3) NOT NULL DEFAULT 1.000,
  `item_id` int(10) NOT NULL,
  `pic_filename` varchar(255) DEFAULT NULL,
  `allow_alt_description` tinyint(1) NOT NULL,
  `is_serialized` tinyint(1) NOT NULL,
  `stock_type` tinyint(2) NOT NULL DEFAULT 0,
  `item_type` tinyint(2) NOT NULL DEFAULT 0,
  `deleted` int(1) NOT NULL DEFAULT 0,
  `tax_category_id` int(10) DEFAULT NULL,
  `qty_per_pack` decimal(15,3) NOT NULL DEFAULT 1.000,
  `pack_name` varchar(8) DEFAULT 'Each',
  `low_sell_item_id` int(10) DEFAULT 0,
  `hsn_code` varchar(32) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ospos_items`
--

INSERT INTO `ospos_items` (`name`, `category`, `supplier_id`, `item_number`, `description`, `cost_price`, `unit_price`, `unit_price_guest`, `unit_price_member_lot`, `reorder_level`, `receiving_quantity`, `item_id`, `pic_filename`, `allow_alt_description`, `is_serialized`, `stock_type`, `item_type`, `deleted`, `tax_category_id`, `qty_per_pack`, `pack_name`, `low_sell_item_id`, `hsn_code`) VALUES
('Arm Alumunium Import Pnp Gl / Mp MOS', 'Arm', NULL, NULL, '', '540000.00', '570000.00', '590000.00', '560000.00', '1.000', '1.000', 1, NULL, 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 1, ''),
('Arm Alumunium Import Pnp Tiger MOS', 'Arm', NULL, NULL, '', '575000.00', '605000.00', '0.00', '0.00', '1.000', '1.000', 2, NULL, 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 2, ''),
('Ban Luar Corsa R46 Uk 90/80', 'Ban', NULL, NULL, '', '295000.00', '305000.00', '0.00', '0.00', '0.000', '1.000', 3, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 3, ''),
('Ban Luar Corsa Terminator 80/90', 'Ban', NULL, NULL, '', '135000.00', '145000.00', '0.00', '0.00', '0.000', '1.000', 4, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 4, ''),
('Ban Luar Corsa Terminator 90/80', 'Ban', NULL, NULL, '', '157000.00', '170000.00', '0.00', '0.00', '0.000', '1.000', 5, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 5, ''),
('Ban Luar Fasti Pro Uk 90/80', 'Ban', NULL, NULL, '', '385000.00', '395000.00', '0.00', '0.00', '0.000', '1.000', 6, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 6, ''),
('Ban Luar FDR Mp 27 Uk 90/80', 'Ban', NULL, NULL, '', '365000.00', '375000.00', '0.00', '0.00', '0.000', '1.000', 7, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 7, ''),
('Ban Luar Maxis Uk 90/80', 'Ban', NULL, NULL, '', '258000.00', '270000.00', '0.00', '0.00', '0.000', '1.000', 8, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 8, ''),
('Ban Luar Primax Sk 01 Set 80/80 - 90/80', 'Ban', NULL, NULL, '', '285000.00', '305000.00', '0.00', '0.00', '0.000', '1.000', 9, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 9, ''),
('Ban Luar Primax Sk 01 uk 80/80', 'Ban', NULL, NULL, '', '130000.00', '145000.00', '0.00', '0.00', '0.000', '1.000', 10, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 10, ''),
('Ban Luar Primax Sk 01 uk 90/80', 'Ban', NULL, NULL, '', '155000.00', '165000.00', '0.00', '0.00', '0.000', '1.000', 11, '', 0, 0, 0, 0, 0, NULL, '1.000', 'Each', 0, ''),
('Batok Van Van Chrome List Chrome', 'Batok', NULL, NULL, '', '63000.00', '70000.00', '0.00', '0.00', '0.000', '1.000', 12, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 12, ''),
('Batok Van Van Mentah List Chrome', 'Batok', NULL, NULL, '', '58000.00', '65000.00', '0.00', '0.00', '0.000', '1.000', 13, '', 0, 0, 0, 0, 0, NULL, '1.000', 'Each', 0, ''),
('Baut Bak Mesin Set Tiger', 'Baut', NULL, NULL, '', '48000.00', '55000.00', '0.00', '0.00', '0.000', '1.000', 14, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 14, ''),
('Begel Belakang Fiz R Biru', 'Begel', NULL, NULL, '', '35000.00', '40000.00', '0.00', '0.00', '0.000', '1.000', 15, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 15, ''),
('Begel Belakang Fiz R Hitam', 'Begel', NULL, NULL, '', '35000.00', '40000.00', '0.00', '0.00', '0.000', '1.000', 16, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 16, ''),
('Begel Belakang Fiz R Kuning', 'Begel', NULL, NULL, '', '35000.00', '40000.00', '0.00', '0.00', '0.000', '1.000', 17, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 17, ''),
('Begel Belakang Fiz R Merah', 'Begel', NULL, NULL, '', '35000.00', '40000.00', '0.00', '0.00', '0.000', '1.000', 18, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 18, ''),
('Begel Belakang Fiz R Orange', 'Begel', NULL, NULL, '', '35000.00', '40000.00', '0.00', '0.00', '0.000', '1.000', 19, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 19, ''),
('Begel Belakang Fiz R Poles', 'Begel', NULL, NULL, '', '30000.00', '35000.00', '0.00', '0.00', '0.000', '1.000', 20, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 20, ''),
('Begel Belakang Fiz R Silver', 'Begel', NULL, NULL, '', '35000.00', '40000.00', '0.00', '0.00', '0.000', '1.000', 21, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 21, ''),
('Begel Belakang Gl 100', 'Begel', NULL, NULL, '', '25000.00', '30000.00', '0.00', '0.00', '0.000', '1.000', 22, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 22, ''),
('Begel Kartel Pipa', 'Begel', NULL, NULL, '', '38000.00', '42000.00', '0.00', '0.00', '0.000', '1.000', 23, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 23, ''),
('Begel Panjang Pipa Tebal', 'Begel', NULL, NULL, '', '19500.00', '25000.00', '0.00', '0.00', '0.000', '1.000', 24, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 24, ''),
('Begel Panjang Polos Chrome', 'Begel', NULL, NULL, '', '14000.00', '18000.00', '0.00', '0.00', '0.000', '1.000', 25, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 25, ''),
('Begel Panjang Set Pemanis', 'Begel', NULL, NULL, '', '29000.00', '35000.00', '0.00', '0.00', '0.000', '1.000', 26, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 26, ''),
('Begel Tilas Chrome', 'Begel', NULL, NULL, '', '40000.00', '40000.00', '0.00', '0.00', '0.000', '1.000', 27, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 27, ''),
('Body Set Tiger Lawas / Tilas Hijau Botol + Begel', 'Body', NULL, NULL, '', '176000.00', '183000.00', '0.00', '0.00', '0.000', '1.000', 28, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 28, ''),
('Body Set Tiger Lawas / Tilas Kuning + Begel', 'Body', NULL, NULL, '', '176000.00', '183000.00', '0.00', '0.00', '0.000', '1.000', 29, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 29, ''),
('Body Set Tiger Lawas / Tilas Merah Maroon + Begel', 'Body', NULL, NULL, '', '176000.00', '183000.00', '0.00', '0.00', '0.000', '1.000', 30, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 30, ''),
('Bosh Tromol Belakang Rx King Pnp Arm Kaze', 'Bosh', NULL, NULL, '', '14000.00', '17000.00', '0.00', '0.00', '0.000', '1.000', 31, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 31, ''),
('Bosh Tromol Depan Honda Pnp Skok Ninja', 'Bosh', NULL, NULL, '', '20000.00', '23000.00', '0.00', '0.00', '0.000', '1.000', 32, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 32, ''),
('Cover / Tutup Gear Crf 230 Import Gorilla', 'Cover', NULL, NULL, '', '63000.00', '70000.00', '0.00', '0.00', '0.000', '1.000', 33, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 33, ''),
('Cover Baut Probol Flowers Import Gold', 'Cover', NULL, NULL, '', '11500.00', '15000.00', '0.00', '0.00', '0.000', '1.000', 34, '', 0, 0, 0, 0, 0, NULL, '1.000', 'Each', 0, ''),
('Cover Baut Probol Flowers Import Gold', 'Cover', NULL, NULL, '', '11500.00', '15000.00', '0.00', '0.00', '0.000', '1.000', 35, '', 0, 0, 0, 0, 1, NULL, '1.000', 'Each', 0, ''),
('Daymeker 16 LED 5,75 inch Import Gorilla', 'Lampu depan', NULL, NULL, '', '295000.00', '315000.00', '0.00', '0.00', '0.000', '1.000', 36, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 36, ''),
('Disk Cakram Lebar Copy Daytona Mos Tiger New', 'Disk cakram', NULL, NULL, '', '95000.00', '100000.00', '0.00', '0.00', '0.000', '1.000', 37, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 37, ''),
('Disk Cakram Ride it Floating Jupiter 300mm', 'Disk, cakram', NULL, NULL, '', '465000.00', '485000.00', '0.00', '0.00', '0.000', '1.000', 38, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 38, ''),
('Disk Cakram Ride it Floating Supra 300mm', 'Disk, cakram', NULL, NULL, '', '465000.00', '485000.00', '0.00', '0.00', '0.000', '1.000', 39, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 39, ''),
('Disk Cakram Ride it Floating Tiger Old 320mm', 'Disk cakram', NULL, NULL, '', '485000.00', '505000.00', '0.00', '0.00', '0.000', '1.000', 40, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 40, ''),
('Drafgear 21 set Kampas Kopling per 6', 'Drafgear', NULL, NULL, '', '250000.00', '260000.00', '0.00', '0.00', '0.000', '1.000', 41, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 41, ''),
('Dudukan Kontak Cb Cnc Diral Bilet', 'Dudukan', NULL, NULL, '', '18000.00', '22000.00', '0.00', '0.00', '0.000', '1.000', 42, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 42, ''),
('Dudukan Kontak Cb Cnc Import Mos', 'Dudukan', NULL, NULL, '', '47500.00', '51000.00', '0.00', '0.00', '0.000', '1.000', 43, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 43, ''),
('Dudukan Mesin Tiger Chrome', 'Dudukan', NULL, NULL, '', '38000.00', '40000.00', '0.00', '0.00', '0.000', '1.000', 44, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 44, ''),
('Dudukan Plat Nomor Fleksibel', 'Dudukan', NULL, NULL, '', '8000.00', '10000.00', '0.00', '0.00', '0.000', '1.000', 45, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 45, ''),
('Dudukan Slebor Depan Honda Win', 'Dudukan', NULL, NULL, '', '6000.00', '9000.00', '0.00', '0.00', '0.000', '1.000', 46, '', 0, 0, 0, 0, 0, NULL, '1.000', 'Each', 0, ''),
('Dudukan Stoplamp Gl 100', 'Dudukan', NULL, NULL, '', '14000.00', '18000.00', '0.00', '0.00', '0.000', '1.000', 47, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 47, ''),
('Dudukan Stoplamp v80 Diral', 'Dudukan', NULL, NULL, '', '14000.00', '17000.00', '0.00', '0.00', '0.000', '1.000', 48, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 48, ''),
('Dumpeer Skok Cr7', 'Dumper', NULL, NULL, '', '8500.00', '10500.00', '0.00', '0.00', '0.000', '1.000', 49, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 49, ''),
('Emblem Box Aki Gl 100', 'Emblem', NULL, NULL, '', '13000.00', '15000.00', '0.00', '0.00', '0.000', '1.000', 50, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 50, ''),
('Emblem Box Aki Gl Pro', 'Emblem', NULL, NULL, '', '13000.00', '15000.00', '0.00', '0.00', '0.000', '1.000', 51, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 51, ''),
('Emblem Tangki Gelatik Import', 'Emblem', NULL, NULL, '', '25000.00', '30000.00', '0.00', '0.00', '0.000', '1.000', 52, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 52, ''),
('Emblem Tangki Gelatik Lokal (Mt Project)', 'Emblem', NULL, NULL, '', '9000.00', '12000.00', '0.00', '0.00', '0.000', '1.000', 53, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 53, ''),
('Emblem Tangki Gl 100', 'Emblem', NULL, NULL, '', '15000.00', '18000.00', '0.00', '0.00', '0.000', '1.000', 54, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 54, ''),
('Emblem Tangki Gl Pro', 'Emblem', NULL, NULL, '', '15000.00', '18000.00', '0.00', '0.00', '0.000', '1.000', 55, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 55, ''),
('Folmeter x-Case', 'Voltmeter', NULL, NULL, '', '32500.00', '36000.00', '0.00', '0.00', '0.000', '1.000', 56, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 56, ''),
('Gas Ksr Import', 'Gas', NULL, NULL, '', '85000.00', '90000.00', '0.00', '0.00', '0.000', '1.000', 57, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 57, ''),
('Gas KSR Import Ride it', 'Gas', NULL, NULL, '', '105000.00', '113000.00', '0.00', '0.00', '0.000', '1.000', 58, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 58, ''),
('Gas KSR Set Handgrip Kaze Import', 'Gas', NULL, NULL, '', '101500.00', '105000.00', '0.00', '0.00', '0.000', '1.000', 59, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 59, ''),
('Handgrip Domino', 'Handgrip', NULL, NULL, '', '14000.00', '17000.00', '0.00', '0.00', '0.000', '1.000', 60, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 60, ''),
('Handgrip Kaze Import Kawasaki', 'Handgrip', NULL, NULL, '', '23000.00', '25000.00', '0.00', '0.00', '0.000', '1.000', 61, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 61, ''),
('Handgrip Kaze Import Kwsk', 'Handgrip', NULL, NULL, '', '17000.00', '21000.00', '0.00', '0.00', '0.000', '1.000', 62, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 62, ''),
('Handgrip Kaze Import MT PROJECT', 'Handgrip', NULL, NULL, '', '10000.00', '15000.00', '0.00', '0.00', '0.000', '1.000', 63, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 63, ''),
('Handgrip Kaze Original Kawasaki', 'Handgrip', NULL, NULL, '', '36000.00', '41000.00', '0.00', '0.00', '0.000', '1.000', 64, '', 0, 0, 0, 0, 0, NULL, '1.000', 'Each', 0, ''),
('Handle Kopling Kiri Rcb', 'handle', NULL, NULL, '', '160000.00', '165000.00', '0.00', '0.00', '0.000', '1.000', 65, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 65, ''),
('Holder Kiri Astrea Grand', 'Holder', NULL, NULL, '', '45000.00', '48000.00', '0.00', '0.00', '0.000', '1.000', 66, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 66, ''),
('Holder Kiri Crf Import', 'Holder', NULL, NULL, '', '75000.00', '82000.00', '0.00', '0.00', '0.000', '1.000', 67, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 67, ''),
('Holder Kiri Ninja Rr Import Mitsuyo', 'Holder', NULL, NULL, '', '140000.00', '147000.00', '0.00', '0.00', '0.000', '1.000', 68, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 68, ''),
('Jagang Samping Ninja 250 Fi Pnp Honda Chrome', 'Jagang, Standar', NULL, NULL, '', '41000.00', '47000.00', '0.00', '0.00', '0.000', '1.000', 69, '', 0, 0, 0, 0, 0, NULL, '1.000', 'Each', 0, ''),
('Jagang Samping Ninja 250 Fi Pnp Honda Hitam', 'Jagang, Standar', NULL, NULL, '', '41000.00', '47000.00', '0.00', '0.00', '0.000', '1.000', 70, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 70, ''),
('Jalu Stang Pcx Besi', ' Jalu', NULL, NULL, '', '18000.00', '22000.00', '0.00', '0.00', '0.000', '1.000', 71, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 71, ''),
('Jalu Stang Pcx Cnc Import Born Free', 'Jalu', NULL, NULL, '', '47500.00', '52000.00', '0.00', '0.00', '0.000', '1.000', 72, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 72, ''),
('Jalu Stang Satria Fu Cnc Import Born Free', 'Jalu', NULL, NULL, '', '45000.00', '49000.00', '0.00', '0.00', '0.000', '1.000', 73, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 73, ''),
('Jok Cb Polos Carbon Morgan', 'Jok', NULL, NULL, '', '135000.00', '150000.00', '0.00', '0.00', '0.000', '1.000', 74, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 74, ''),
('Jok Cb XX Carbon Morgan', 'Jok', NULL, NULL, '', '135000.00', '150000.00', '0.00', '0.00', '0.000', '1.000', 75, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 75, ''),
('Jok Gl 100 Carbon Morgan', 'Jok', NULL, NULL, '', '155000.00', '170000.00', '0.00', '0.00', '0.000', '1.000', 76, '', 0, 0, 0, 0, 0, NULL, '1.000', 'Each', 0, ''),
('Jok Gl 100 Carbon Pences', 'Jok', NULL, NULL, '', '150000.00', '165000.00', '0.00', '0.00', '0.000', '1.000', 77, '', 0, 0, 0, 0, 0, NULL, '1.000', 'Each', 0, ''),
('Jok Gl 100 Pences', 'Jok', NULL, NULL, '', '150000.00', '165000.00', '0.00', '0.00', '0.000', '1.000', 78, '', 0, 0, 0, 0, 0, NULL, '1.000', 'Each', 0, ''),
('Kaliper Brembo 2 Piston', 'Kaliper', NULL, NULL, '', '145000.00', '150000.00', '0.00', '0.00', '0.000', '1.000', 79, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 79, ''),
('Kick Stater Viar Tipe C Import', 'Kick', NULL, NULL, '', '60000.00', '65000.00', '0.00', '0.00', '0.000', '1.000', 80, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 80, ''),
('Klakson Gl 100 Bakpao Import Heli Bars', 'Klakson', NULL, NULL, '', '250000.00', '260000.00', '0.00', '0.00', '0.000', '1.000', 81, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 81, ''),
('Kran Tirev Import Chetaah', 'Kran', NULL, NULL, '', '33500.00', '38000.00', '0.00', '0.00', '0.000', '1.000', 82, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 82, ''),
('Kran Tirev Import Gorilla', 'Kran', NULL, NULL, '', '25000.00', '30000.00', '0.00', '0.00', '0.000', '1.000', 83, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 83, ''),
('Kunci Kontak Cb 200 Import Chetaah', 'Kunci', NULL, NULL, '', '35000.00', '40000.00', '0.00', '0.00', '0.000', '1.000', 84, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 84, ''),
('Kunci Kontak Cg Import Gorilla', 'Kunci', NULL, NULL, '', '26000.00', '30000.00', '0.00', '0.00', '0.000', '1.000', 85, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 85, ''),
('Kunci Kontak Cg Import Heli Bars', 'Kunci', NULL, NULL, '', '30000.00', '34000.00', '0.00', '0.00', '0.000', '1.000', 86, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 86, ''),
('Kunci Kontak Cg Import Mos', 'Kunci', NULL, NULL, '', '27500.00', '31000.00', '0.00', '0.00', '0.000', '1.000', 87, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 87, ''),
('Kupingan Lampu Cnc Ring As 31 Import MOS', 'Kupingan', NULL, NULL, '', '87000.00', '92000.00', '0.00', '0.00', '0.000', '1.000', 88, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 88, ''),
('Kupingan Lampu Cnc Ring As 31 Motif', 'Kupingan', NULL, NULL, '', '27000.00', '32000.00', '0.00', '0.00', '0.000', '1.000', 89, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 89, ''),
('Kupingan Lampu Cnc Ring As 33 Import DAY', 'Kupingan', NULL, NULL, '', '87000.00', '92000.00', '0.00', '0.00', '0.000', '1.000', 90, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 90, ''),
('Lampu Depan Honda Win Old moz', 'Lampu depan', NULL, NULL, '', '55000.00', '60000.00', '0.00', '0.00', '0.000', '1.000', 91, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 91, ''),
('Lampu Depan Tiger New', 'Lampu depan', NULL, NULL, '', '50000.00', '55000.00', '0.00', '0.00', '0.000', '1.000', 92, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 92, ''),
('Lampu HD Autopal Led Ride it', 'Lampu depan ', NULL, NULL, '', '75000.00', '80000.00', '0.00', '0.00', '0.000', '1.000', 93, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 93, ''),
('Manipol Pwk 28', 'Manipol', NULL, NULL, '', '31000.00', '34000.00', '0.00', '0.00', '0.000', '1.000', 94, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 94, ''),
('Manipol Pwk 30', 'Manipol', NULL, NULL, '', '31000.00', '34000.00', '0.00', '0.00', '0.000', '1.000', 95, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 95, ''),
('Manipol Pwk 32', 'Manipol', NULL, NULL, '', '31000.00', '34000.00', '0.00', '0.00', '0.000', '1.000', 96, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 96, ''),
('Manipol Pwk 34', 'Manipol', NULL, NULL, '', '31000.00', '34000.00', '0.00', '0.00', '0.000', '1.000', 97, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 97, ''),
('Manipol Pwk 35', 'Manipol', NULL, NULL, '', '31000.00', '34000.00', '0.00', '0.00', '0.000', '1.000', 98, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 98, ''),
('Manipol Pwk 38', 'Manipol', NULL, NULL, '', '31000.00', '34000.00', '0.00', '0.00', '0.000', '1.000', 99, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 99, ''),
('Master Rem Kanan Rcb', 'Master Rem', NULL, NULL, '', '336500.00', '345000.00', '0.00', '0.00', '0.000', '1.000', 100, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 100, ''),
('Master Rem Set Brembo Izumi Black', 'Master Rem', NULL, NULL, '', '168000.00', '175000.00', '0.00', '0.00', '0.000', '1.000', 101, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 101, ''),
('Master Rem set Brembo Izumi Gold', 'Master Rem', NULL, NULL, '', '168000.00', '175000.00', '0.00', '0.00', '0.000', '1.000', 102, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 102, ''),
('Master Rem Set Mos Copy Rcb', 'Master Rem', NULL, NULL, '', '185000.00', '200000.00', '0.00', '0.00', '0.000', '1.000', 103, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 103, ''),
('Master Rem Set Tracktion Copy Rcb', 'Master Rem', NULL, NULL, '', '203000.00', '213000.00', '0.00', '0.00', '0.000', '1.000', 104, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 104, ''),
('Nap Gear Scorpio/Rx King ori Baru', 'Nap Gear', NULL, NULL, '', '59000.00', '65000.00', '0.00', '0.00', '0.000', '1.000', 105, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 105, ''),
('Oli Samping 2T Ipone R2000 Strawberry', 'Oli', NULL, NULL, '', '145000.00', '155000.00', '0.00', '0.00', '0.000', '1.000', 106, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 106, ''),
('Palang Stang Day Jumbo', 'Palang', NULL, NULL, '', '70000.00', '75000.00', '0.00', '0.00', '0.000', '1.000', 107, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 107, ''),
('Palang Stang Day Kecil', 'Palang', NULL, NULL, '', '42000.00', '47000.00', '0.00', '0.00', '0.000', '1.000', 108, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 108, ''),
('Palang Stang Jumbo Nrv', 'Palang', NULL, NULL, '', '50000.00', '55000.00', '0.00', '0.00', '0.000', '1.000', 109, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 109, ''),
('Palang Stang Model Daytona Lokal (Mt Project)', 'Palang', NULL, NULL, '', '20000.00', '25000.00', '0.00', '0.00', '0.000', '1.000', 110, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 110, ''),
('Pangkon Knalpot Tipe C Biru', 'Pangkon', NULL, NULL, '', '13500.00', '17000.00', '0.00', '0.00', '0.000', '1.000', 111, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 111, ''),
('Pangkon Knalpot Tipe C Gold', 'Pangkon', NULL, NULL, '', '13500.00', '17000.00', '0.00', '0.00', '0.000', '1.000', 112, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 112, ''),
('Pangkon Knalpot Tipe C Merah', 'Pangkon', NULL, NULL, '', '13500.00', '17000.00', '0.00', '0.00', '0.000', '1.000', 113, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 113, ''),
('Pangkon Knalpot Tipe C Silver', 'Pangkon', NULL, NULL, '', '13500.00', '17000.00', '0.00', '0.00', '0.000', '1.000', 114, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 114, ''),
('Pangkon Knalpot Tipe L Biru', 'Pangkon', NULL, NULL, '', '12500.00', '15000.00', '0.00', '0.00', '0.000', '1.000', 115, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 115, ''),
('Pangkon Knalpot Tipe L Gold', 'Pangkon', NULL, NULL, '', '12500.00', '15000.00', '0.00', '0.00', '0.000', '1.000', 116, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 116, ''),
('Pangkon Knalpot Tipe L Merah', 'Pangkon', NULL, NULL, '', '12500.00', '15000.00', '0.00', '0.00', '0.000', '1.000', 117, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 117, ''),
('Pangkon Knalpot Tipe L Silver', 'Pangkon', NULL, NULL, '', '12500.00', '15000.00', '0.00', '0.00', '0.000', '1.000', 118, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 118, ''),
('Pemanis Sein Cb', 'Pemanis', NULL, NULL, '', '3500.00', '6000.00', '0.00', '0.00', '0.000', '1.000', 119, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 119, ''),
('Postep Belakang Cb 150r', 'Footstep', NULL, NULL, '', '33000.00', '38000.00', '0.00', '0.00', '0.000', '1.000', 120, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 120, ''),
('Postep Belakang Cbr 1000 Import Gorilla', 'Footstep', NULL, NULL, '', '110000.00', '120000.00', '0.00', '0.00', '0.000', '1.000', 121, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 121, ''),
('Postep Belakang Cbr 500 Import Gorilla', 'Footstep', NULL, NULL, '', '107000.00', '117000.00', '0.00', '0.00', '0.000', '1.000', 122, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 122, ''),
('Postep Belakang Ninja Rr', 'Footstep', NULL, NULL, '', '37000.00', '40000.00', '0.00', '0.00', '0.000', '1.000', 123, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 123, ''),
('Postep Cb 650 Import', 'Footstep', NULL, NULL, '', '90000.00', '100000.00', '0.00', '0.00', '0.000', '1.000', 124, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 124, ''),
('Raiser Cnc Ninja Import Gorilla', 'Raiser', NULL, NULL, '', '72000.00', '77000.00', '0.00', '0.00', '0.000', '1.000', 125, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 125, ''),
('Rak Depan Honda Win', 'Rak', NULL, NULL, '', '42500.00', '47000.00', '0.00', '0.00', '0.000', '1.000', 126, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 126, ''),
('Reflektor Depan Yamaha Fiz R', 'Reflektor', NULL, NULL, '', '28000.00', '32000.00', '0.00', '0.00', '0.000', '1.000', 127, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 127, ''),
('Ring Kontak Kuningan', 'Ring', NULL, NULL, '', '12500.00', '14000.00', '0.00', '0.00', '0.000', '1.000', 128, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 128, ''),
('Selang Cakram 90cm Hitam', 'Selang', NULL, NULL, '', '18500.00', '21000.00', '0.00', '0.00', '0.000', '1.000', 129, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 129, ''),
('Selang Cakram 90cm Merah', 'Selang', NULL, NULL, '', '18500.00', '21000.00', '0.00', '0.00', '0.000', '1.000', 130, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 130, ''),
('Selang Rem 90cm Import Grey', 'Selang', NULL, NULL, '', '18500.00', '21000.00', '0.00', '0.00', '0.000', '1.000', 131, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 131, ''),
('Selang Rem 90cm Import Silver', 'Selang', NULL, NULL, '', '18500.00', '21000.00', '0.00', '0.00', '0.000', '1.000', 132, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 132, ''),
('Skok Belakang Copy Ktc 320 Black Series', 'Skok', NULL, NULL, '', '475000.00', '490000.00', '0.00', '0.00', '0.000', '1.000', 133, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 133, ''),
('Skok Belakang Heli Copy Ktc 340 Grey', 'Skok', NULL, NULL, '', '435000.00', '450000.00', '0.00', '0.00', '0.000', '1.000', 134, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 134, ''),
('Skok Belakang Heli Copy Ktc 340 Merah', 'Skok', NULL, NULL, '', '435000.00', '450000.00', '0.00', '0.00', '0.000', '1.000', 135, '', 0, 0, 0, 0, 0, NULL, '1.000', 'Each', 0, ''),
('Skok Belakang TAD Copy Ktc 320 Black As Gold', 'Skok', NULL, NULL, '', '455000.00', '475000.00', '0.00', '0.00', '0.000', '1.000', 136, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 136, ''),
('Skok Belakang TAD Copy Ktc 320 Grey', 'Skok', NULL, NULL, '', '455000.00', '475000.00', '0.00', '0.00', '0.000', '1.000', 137, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 137, ''),
('Skok Depan Ninja R Pnp Honda Import', 'Skok', NULL, NULL, '', '750000.00', '780000.00', '0.00', '0.00', '0.000', '1.000', 138, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 138, ''),
('Skok Depan Ninja Rr Pnp Honda Import Gorilla', 'Skok', NULL, NULL, '', '805000.00', '835000.00', '0.00', '0.00', '0.000', '1.000', 139, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 139, ''),
('Slebor Depan Honda Win Trail Putih', 'Slebor', NULL, NULL, '', '33000.00', '38000.00', '0.00', '0.00', '0.000', '1.000', 140, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 140, ''),
('Slebor Depan Ninja R Biru', 'Slebor', NULL, NULL, '', '26500.00', '31000.00', '0.00', '0.00', '0.000', '1.000', 141, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 141, ''),
('Slebor Depan Ninja R Hijau Botol', 'Slebor', NULL, NULL, '', '26500.00', '31000.00', '0.00', '0.00', '0.000', '1.000', 142, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 142, ''),
('Slebor Depan Ninja R Hijau Metallic', 'Slebor', NULL, NULL, '', '26500.00', '31000.00', '0.00', '0.00', '0.000', '1.000', 143, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 143, ''),
('Slebor Depan Ninja R Hijau Susu', 'Slebor', NULL, NULL, '', '26500.00', '31000.00', '0.00', '0.00', '0.000', '1.000', 144, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 144, ''),
('Slebor Depan Ninja R Hitam', 'Slebor', NULL, NULL, '', '25500.00', '30000.00', '0.00', '0.00', '0.000', '1.000', 145, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 145, ''),
('Slebor Depan Ninja R Kuning', 'Slebor', NULL, NULL, '', '26500.00', '31000.00', '0.00', '0.00', '0.000', '1.000', 146, '', 0, 0, 0, 0, 0, NULL, '1.000', 'Each', 0, ''),
('Slebor Depan Ninja R Merah Ferrari', 'Slebor', NULL, NULL, '', '26500.00', '31000.00', '0.00', '0.00', '0.000', '1.000', 147, '', 0, 0, 0, 0, 0, NULL, '1.000', 'Each', 0, ''),
('Slebor Depan Ninja R Merah Maroon', 'Slebor', NULL, NULL, '', '26500.00', '31000.00', '0.00', '0.00', '0.000', '1.000', 148, '', 0, 0, 0, 0, 0, NULL, '1.000', 'Each', 0, ''),
('Slebor Depan Ninja R Putih', 'Slebor', NULL, NULL, '', '26500.00', '31000.00', '0.00', '0.00', '0.000', '1.000', 149, '', 0, 0, 0, 0, 0, NULL, '1.000', 'Each', 0, ''),
('Spion Astrea Legenda Gagang Chrome', 'Spion', NULL, NULL, '', '18000.00', '22000.00', '0.00', '0.00', '0.000', '1.000', 150, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 150, ''),
('Spion Day Kotak', 'Spion', NULL, NULL, '', '31000.00', '36000.00', '0.00', '0.00', '0.000', '1.000', 151, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 151, ''),
('Spion day Oval', 'Spion', NULL, NULL, '', '34000.00', '39000.00', '0.00', '0.00', '0.000', '1.000', 152, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 152, ''),
('Spion HD Oval Import Born Free', 'Spion', NULL, NULL, '', '27000.00', '32000.00', '0.00', '0.00', '0.000', '1.000', 153, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 153, ''),
('Standart Tengah Scorpio PNP honda bagus hitam', 'Jagang, Standar', NULL, NULL, '', '125000.00', '130000.00', '0.00', '0.00', '0.000', '1.000', 154, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 154, ''),
('Stang Cb 150 Repro Chrome', 'Stang', NULL, NULL, '', '24000.00', '28000.00', '0.00', '0.00', '0.000', '1.000', 155, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 155, ''),
('Stang Cb 150 Repro Hitam', 'Stang', NULL, NULL, '', '24000.00', '28000.00', '0.00', '0.00', '0.000', '1.000', 156, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 156, ''),
('Stang Copy Daytona Tipe low Palang Besar Heli Bars', 'Stang', NULL, NULL, '', '195000.00', '200000.00', '0.00', '0.00', '0.000', '1.000', 157, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 157, ''),
('Stang Copy Daytona Tipe Low Palang Besar Ride it', 'Stang', NULL, NULL, '', '195000.00', '200000.00', '0.00', '0.00', '0.000', '1.000', 158, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 158, ''),
('Stang Copy Daytona Tipe Low domino', 'Stang', NULL, NULL, '', '95000.00', '100000.00', '0.00', '0.00', '0.000', '1.000', 159, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 159, ''),
('Stang Day Copy Daytona Tipe low Palang Besar', 'Stang', NULL, NULL, '', '135000.00', '140000.00', '0.00', '0.00', '0.000', '1.000', 160, '', 0, 0, 0, 0, 0, NULL, '1.000', 'Each', 0, ''),
('Stick Rem Stainless PHS', 'Stick rem', NULL, NULL, '', '85000.00', '92000.00', '0.00', '0.00', '0.000', '1.000', 161, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 161, ''),
('Stoplamp Belakang Yamaha Fiz R', 'Stoplamp', NULL, NULL, '', '47500.00', '53000.00', '0.00', '0.00', '0.000', '1.000', 162, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 162, ''),
('Stoplamp Bsa Bolp Merah', 'Stoplamp', NULL, NULL, '', '28000.00', '33000.00', '0.00', '0.00', '0.000', '1.000', 163, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 163, ''),
('Stoplamp Bsa Bolp Mika Diamond Merah Born Free', 'Stoplamp', NULL, NULL, '', '28000.00', '33000.00', '0.00', '0.00', '0.000', '1.000', 164, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 164, ''),
('Stoplamp Bsa Bolp Smoke', 'Stoplamp', NULL, NULL, '', '28000.00', '33000.00', '0.00', '0.00', '0.000', '1.000', 165, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 165, ''),
('Stoplamp Bsa LED Mika Diamond Born Free', 'Stoplamp', NULL, NULL, '', '38000.00', '43000.00', '0.00', '0.00', '0.000', '1.000', 166, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 166, ''),
('Tangki Press Cb 125 Kingdom', 'Tangki', NULL, NULL, '', '335000.00', '350000.00', '0.00', '0.00', '0.000', '1.000', 167, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 167, ''),
('Tangki Press Gelatik Doraemon', 'Tangki', NULL, NULL, '', '275000.00', '285000.00', '0.00', '0.00', '0.000', '1.000', 168, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 168, ''),
('Tempat Aki Cb Chrome', 'Tempat', NULL, NULL, '', '19000.00', '23000.00', '0.00', '0.00', '0.000', '1.000', 169, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 169, ''),
('Tempat Aki Slim Chrome', 'Tempat', NULL, NULL, '', '20000.00', '25000.00', '0.00', '0.00', '0.000', '1.000', 170, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 170, ''),
('Tempat Koil 3in1', 'Tempat', NULL, NULL, '', '33000.00', '35000.00', '0.00', '0.00', '0.000', '1.000', 171, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 171, ''),
('Tempat Plat Nomor Ori Ahm', 'Tempat', NULL, NULL, '', '13000.00', '17000.00', '0.00', '0.00', '0.000', '1.000', 172, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 172, ''),
('Tralis  Lampu Cnc Gl', 'Tralis', NULL, NULL, '', '35000.00', '40000.00', '0.00', '0.00', '0.000', '1.000', 173, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 173, ''),
('Tralis Lampu Cnc Mp/Tiger', 'Tralis', NULL, NULL, '', '35000.00', '40000.00', '0.00', '0.00', '0.000', '1.000', 174, '', 0, 0, 0, 0, 0, NULL, '1.000', 'Each', 0, ''),
('Tromol Belakang Rx King Ori Baru', 'Tromol', NULL, NULL, '', '207500.00', '215000.00', '0.00', '0.00', '0.000', '1.000', 175, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 175, ''),
('Tromol Depan D Tracker Full Set Pnp Honda Import', 'Tromol', NULL, NULL, '', '585000.00', '605000.00', '0.00', '0.00', '0.000', '1.000', 176, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 176, ''),
('Tutup Tangki Astra S90 Import Born Free', 'Tutup', NULL, NULL, '', '21000.00', '25000.00', '0.00', '0.00', '0.000', '1.000', 177, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 177, ''),
('Tutup Tangki Diesel Import Born free', 'Tutup', NULL, NULL, '', '21000.00', '25000.00', '0.00', '0.00', '0.000', '1.000', 178, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 178, ''),
('Tutup Tromol Belakang Rx King Ori Baru', 'Tutup', NULL, NULL, '', '81500.00', '87000.00', '0.00', '0.00', '0.000', '1.000', 179, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 179, ''),
('Untiran Kran Tirev Kerucut Cnc Import Gorilla', 'Untiran', NULL, NULL, '', '35000.00', '37000.00', '0.00', '0.00', '0.000', '1.000', 180, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 180, ''),
('Untiran Kran Tirev Segitiga Cnc Import Gorilla', 'Untiran', NULL, NULL, '', '35000.00', '37000.00', '0.00', '0.00', '0.000', '1.000', 181, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 181, ''),
('Velocity Donat Uk 28', 'Velocity', NULL, NULL, '', '15500.00', '19000.00', '0.00', '0.00', '0.000', '1.000', 182, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 182, ''),
('Velocity Donat Uk 30', 'Velocity', NULL, NULL, '', '15500.00', '19000.00', '0.00', '0.00', '0.000', '1.000', 183, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 183, ''),
('Velocity Donat Uk 32', 'Velocity', NULL, NULL, '', '15500.00', '19000.00', '0.00', '0.00', '0.000', '1.000', 184, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 184, ''),
('Velocity Donat Uk 34', 'Velocity', NULL, NULL, '', '15500.00', '19000.00', '0.00', '0.00', '0.000', '1.000', 185, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 185, ''),
('Velocity Donat Uk 35', 'Velocity', NULL, NULL, '', '15500.00', '19000.00', '0.00', '0.00', '0.000', '1.000', 186, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 186, ''),
('Velocity Donat Uk 38', 'Velocity', NULL, NULL, '', '15500.00', '19000.00', '0.00', '0.00', '0.000', '1.000', 187, '', 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 187, ''),
('CDI Shogun Kebo', 'cdi', NULL, NULL, '', '55000.00', '75000.00', '0.00', '0.00', '1.000', '1.000', 188, NULL, 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 188, ''),
('Postep Belakang Absolute Revo ', 'postep', NULL, NULL, '', '1.00', '1.00', '0.00', '0.00', '1.000', '1.000', 189, NULL, 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 189, ''),
('Postep Cb 650 ', 'postep', NULL, NULL, '', '1.00', '1.00', '0.00', '0.00', '1.000', '1.000', 190, NULL, 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 190, ''),
('slebor depan ninja RR hitam', 'Stang', NULL, NULL, '', '40000.00', '55000.00', '0.00', '0.00', '1.000', '1.000', 191, NULL, 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 191, ''),
('Emblem panel astrea grand', 'Emblem', NULL, NULL, '', '0.00', '0.00', '0.00', '0.00', '1.000', '1.000', 192, NULL, 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 192, ''),
('Begel Samping Fiz R HiTAM', 'begel', NULL, NULL, '', '0.00', '0.00', '0.00', '0.00', '1.000', '1.000', 193, NULL, 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 193, ''),
('Begel Samping Fiz R HiTAM', 'begel', NULL, NULL, '', '0.00', '0.00', '0.00', '0.00', '1.000', '1.000', 194, NULL, 0, 0, 0, 0, 1, 0, '1.000', 'Setiap', 194, ''),
('Begel Samping Fiz R HiTAM', 'begel', NULL, NULL, '', '0.00', '0.00', '0.00', '0.00', '1.000', '1.000', 195, NULL, 0, 0, 0, 0, 1, 0, '1.000', 'Setiap', 195, ''),
('Begel samping CROME', 'Begel', NULL, NULL, '', '0.00', '0.00', '0.00', '0.00', '1.000', '1.000', 196, NULL, 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 196, ''),
('holder kiri vixion old ', 'Holder', NULL, NULL, '', '35000.00', '50000.00', '0.00', '0.00', '1.000', '1.000', 197, NULL, 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 197, ''),
('wraping blebet knalpot 10m HITAM', 'knalpot', NULL, NULL, '', '0.00', '0.00', '0.00', '0.00', '1.000', '1.000', 198, NULL, 0, 0, 0, 0, 1, 0, '1.000', 'Setiap', 198, ''),
('wraping blebet knalpot 10m HITAM', 'knalpot', NULL, NULL, '', '0.00', '0.00', '0.00', '0.00', '1.000', '1.000', 199, NULL, 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 199, ''),
('velg v rossi copy daytona gp whell gold jupiter 160-185', 'velg', NULL, NULL, '', '0.00', '0.00', '0.00', '0.00', '1.000', '1.000', 200, NULL, 0, 0, 0, 0, 1, 0, '1.000', 'Setiap', 200, ''),
('velg v rossi copy daytona gp whell gold jupiter 160-185', 'velg', NULL, NULL, '', '1310000.00', '1500000.00', '0.00', '0.00', '1.000', '1.000', 201, NULL, 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 201, ''),
('sein ninja rr 1 set original baru', 'sen', NULL, NULL, '', '0.00', '0.00', '0.00', '0.00', '1.000', '1.000', 202, NULL, 0, 0, 0, 0, 1, 0, '1.000', 'Setiap', 202, ''),
('sein ninja rr 1 set original baru', 'sen', NULL, NULL, '', '175000.00', '190000.00', '0.00', '0.00', '1.000', '1.000', 203, NULL, 0, 0, 0, 0, 0, 0, '1.000', 'Setiap', 203, '');

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

--
-- Table structure for table `ospos_items_taxes`
--

CREATE TABLE `ospos_items_taxes` (
  `item_id` int(10) NOT NULL,
  `name` varchar(255) NOT NULL,
  `percent` decimal(15,3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `ospos_item_kits`
--

CREATE TABLE `ospos_item_kits` (
  `item_kit_id` int(11) NOT NULL,
  `item_kit_number` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `item_id` int(10) NOT NULL DEFAULT 0,
  `kit_discount` decimal(15,2) NOT NULL DEFAULT 0.00,
  `kit_discount_type` tinyint(2) NOT NULL DEFAULT 0,
  `price_option` tinyint(2) NOT NULL DEFAULT 0,
  `print_option` tinyint(2) NOT NULL DEFAULT 0,
  `description` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `ospos_item_kit_items`
--

CREATE TABLE `ospos_item_kit_items` (
  `item_kit_id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `quantity` decimal(15,3) NOT NULL,
  `kit_sequence` int(3) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `ospos_item_quantities`
--

CREATE TABLE `ospos_item_quantities` (
  `item_id` int(11) NOT NULL,
  `location_id` int(11) NOT NULL,
  `quantity` decimal(15,3) NOT NULL DEFAULT 0.000
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ospos_item_quantities`
--

INSERT INTO `ospos_item_quantities` (`item_id`, `location_id`, `quantity`) VALUES
(1, 1, '0.000'),
(2, 1, '1.000'),
(3, 1, '0.000'),
(4, 1, '0.000'),
(5, 1, '0.000'),
(6, 1, '2.000'),
(7, 1, '6.000'),
(8, 1, '0.000'),
(9, 1, '0.000'),
(10, 1, '0.000'),
(11, 1, '0.000'),
(12, 1, '40.000'),
(13, 1, '1.000'),
(14, 1, '0.000'),
(15, 1, '78.000'),
(16, 1, '26.000'),
(17, 1, '56.000'),
(18, 1, '37.000'),
(19, 1, '28.000'),
(20, 1, '131.000'),
(21, 1, '101.000'),
(22, 1, '30.000'),
(23, 1, '0.000'),
(24, 1, '197.000'),
(25, 1, '0.000'),
(26, 1, '0.000'),
(27, 1, '216.000'),
(28, 1, '3.000'),
(29, 1, '2.000'),
(30, 1, '0.000'),
(31, 1, '20.000'),
(32, 1, '10.000'),
(33, 1, '16.000'),
(34, 1, '1.000'),
(35, 1, '0.000'),
(36, 1, '0.000'),
(37, 1, '11.000'),
(38, 1, '0.000'),
(39, 1, '10.000'),
(40, 1, '3.000'),
(41, 1, '28.000'),
(42, 1, '47.000'),
(43, 1, '0.000'),
(44, 1, '1.000'),
(45, 1, '246.000'),
(46, 1, '1.000'),
(47, 1, '325.000'),
(48, 1, '299.000'),
(49, 1, '154.000'),
(50, 1, '116.000'),
(51, 1, '0.000'),
(52, 1, '53.000'),
(53, 1, '767.000'),
(54, 1, '0.000'),
(55, 1, '0.000'),
(56, 1, '20.000'),
(57, 1, '31.000'),
(58, 1, '12.000'),
(59, 1, '28.000'),
(60, 1, '14.000'),
(61, 1, '0.000'),
(62, 1, '939.000'),
(63, 1, '89.000'),
(64, 1, '1.000'),
(65, 1, '0.000'),
(66, 1, '37.000'),
(67, 1, '0.000'),
(68, 1, '0.000'),
(69, 1, '1.000'),
(70, 1, '61.000'),
(71, 1, '288.000'),
(72, 1, '0.000'),
(73, 1, '47.000'),
(74, 1, '0.000'),
(75, 1, '11.000'),
(76, 1, '1.000'),
(77, 1, '1.000'),
(78, 1, '1.000'),
(79, 1, '24.000'),
(80, 1, '37.000'),
(81, 1, '38.000'),
(82, 1, '0.000'),
(83, 1, '0.000'),
(84, 1, '108.000'),
(85, 1, '9.000'),
(86, 1, '0.000'),
(87, 1, '4.000'),
(88, 1, '14.000'),
(89, 1, '0.000'),
(90, 1, '26.000'),
(91, 1, '16.000'),
(92, 1, '0.000'),
(93, 1, '0.000'),
(94, 1, '209.000'),
(95, 1, '116.000'),
(96, 1, '210.000'),
(97, 1, '180.000'),
(98, 1, '101.000'),
(99, 1, '15.000'),
(100, 1, '14.000'),
(101, 1, '0.000'),
(102, 1, '0.000'),
(103, 1, '0.000'),
(104, 1, '0.000'),
(105, 1, '0.000'),
(106, 1, '42.000'),
(107, 1, '1000.000'),
(108, 1, '0.000'),
(109, 1, '1000.000'),
(110, 1, '29.000'),
(111, 1, '63.000'),
(112, 1, '115.000'),
(113, 1, '30.000'),
(114, 1, '1000.000'),
(115, 1, '1000.000'),
(116, 1, '1000.000'),
(117, 1, '1000.000'),
(118, 1, '1000.000'),
(119, 1, '353.000'),
(120, 1, '0.000'),
(121, 1, '33.000'),
(122, 1, '73.000'),
(123, 1, '1038.000'),
(124, 1, '146.000'),
(125, 1, '0.000'),
(126, 1, '0.000'),
(127, 1, '7.000'),
(128, 1, '71.000'),
(129, 1, '1000.000'),
(130, 1, '999.000'),
(131, 1, '999.000'),
(132, 1, '995.000'),
(133, 1, '0.000'),
(134, 1, '0.000'),
(135, 1, '1.000'),
(136, 1, '0.000'),
(137, 1, '0.000'),
(138, 1, '-1.000'),
(139, 1, '0.000'),
(140, 1, '0.000'),
(141, 1, '1000.000'),
(142, 1, '1000.000'),
(143, 1, '1000.000'),
(144, 1, '1000.000'),
(145, 1, '1000.000'),
(146, 1, '1.000'),
(147, 1, '1.000'),
(148, 1, '1.000'),
(149, 1, '-1.000'),
(150, 1, '1000.000'),
(151, 1, '11.000'),
(152, 1, '0.000'),
(153, 1, '51.000'),
(154, 1, '17.000'),
(155, 1, '1000.000'),
(156, 1, '0.000'),
(157, 1, '31.000'),
(158, 1, '22.000'),
(159, 1, '-2.000'),
(160, 1, '1.000'),
(161, 1, '88.000'),
(162, 1, '1000.000'),
(163, 1, '0.000'),
(164, 1, '32.000'),
(165, 1, '0.000'),
(166, 1, '63.000'),
(167, 1, '0.000'),
(168, 1, '0.000'),
(169, 1, '206.000'),
(170, 1, '75.000'),
(171, 1, '1000.000'),
(172, 1, '111.000'),
(173, 1, '0.000'),
(174, 1, '0.000'),
(175, 1, '0.000'),
(176, 1, '11.000'),
(177, 1, '23.000'),
(178, 1, '128.000'),
(179, 1, '0.000'),
(180, 1, '4.000'),
(181, 1, '4.000'),
(182, 1, '167.000'),
(183, 1, '122.000'),
(184, 1, '106.000'),
(185, 1, '156.000'),
(186, 1, '177.000'),
(187, 1, '119.000'),
(188, 1, '36.000'),
(189, 1, '85.000'),
(190, 1, '29.000'),
(191, 1, '47.000'),
(192, 1, '552.000'),
(193, 1, '177.000'),
(194, 1, '0.000'),
(195, 1, '0.000'),
(196, 1, '205.000'),
(197, 1, '130.000'),
(198, 1, '0.000'),
(199, 1, '100.000'),
(200, 1, '0.000'),
(201, 1, '3.000'),
(202, 1, '0.000'),
(203, 1, '1.000');

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

--
-- Table structure for table `ospos_migrations`
--

CREATE TABLE `ospos_migrations` (
  `version` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ospos_migrations`
--

INSERT INTO `ospos_migrations` (`version`) VALUES
(20210103000000);

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

--
-- Table structure for table `ospos_modules`
--

CREATE TABLE `ospos_modules` (
  `name_lang_key` varchar(255) NOT NULL,
  `desc_lang_key` varchar(255) NOT NULL,
  `sort` int(10) NOT NULL,
  `module_id` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ospos_modules`
--

INSERT INTO `ospos_modules` (`name_lang_key`, `desc_lang_key`, `sort`, `module_id`) VALUES
('module_attributes', 'module_attributes_desc', 107, 'attributes'),
('module_cashups', 'module_cashups_desc', 110, 'cashups'),
('module_config', 'module_config_desc', 900, 'config'),
('module_customers', 'module_customers_desc', 10, 'customers'),
('module_employees', 'module_employees_desc', 80, 'employees'),
('module_expenses', 'module_expenses_desc', 108, 'expenses'),
('module_expenses_categories', 'module_expenses_categories_desc', 109, 'expenses_categories'),
('module_giftcards', 'module_giftcards_desc', 90, 'giftcards'),
('module_home', 'module_home_desc', 1, 'home'),
('module_items', 'module_items_desc', 20, 'items'),
('module_item_kits', 'module_item_kits_desc', 30, 'item_kits'),
('module_messages', 'module_messages_desc', 98, 'messages'),
('module_office', 'module_office_desc', 999, 'office'),
('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'),
('module_surveillance_cams', 'module_surveillance_cams_desc', 200, 'surveillance_cams'),
('module_taxes', 'module_taxes_desc', 105, 'taxes'),
('module_time_attendances', 'module_time_attendances_desc', 81, 'time_attendances');

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

--
-- Table structure for table `ospos_people`
--

CREATE TABLE `ospos_people` (
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `gender` int(1) DEFAULT NULL,
  `phone_number` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `address_1` varchar(255) NOT NULL,
  `address_2` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `state` varchar(255) NOT NULL,
  `zip` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `comments` text NOT NULL,
  `person_id` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ospos_people`
--

INSERT INTO `ospos_people` (`first_name`, `last_name`, `gender`, `phone_number`, `email`, `address_1`, `address_2`, `city`, `state`, `zip`, `country`, `comments`, `person_id`) VALUES
('Devi', ' ', NULL, '089611564670', 'dnovia62@gmail.com', '', '', '', '', '', '', '', 1),
('3Bintang Jaya Motor', ' ', 0, '6282298191016', '', 'Jl Prabuloro Kel Bakungan Rt01 Rw02 Kec Glagah Banyuwangi Jatim', '', 'Banyuwangi', '', '', '', '', 2),
('Aceng', ' ', 0, '6289602813998', '', 'Jepangpakis', '', '', '', '', '', '', 3),
('Agus CB', ' ', 0, '628989553795', '', 'Dukuh Rejo Rt.002/Rw.008. Desa Sawahan Kec. Ngemplak Solo - 57375', '', 'Solo', '', '', '', '', 4),
('Anam demam classic', ' ', 0, '6285848823178', '', 'Dusun Panembahan, Desa Rawajaya Rt 07/Rw 04, (Patokan   Selatan Pom Bensin Sitinggil), Kec. Bantarsari Kab. Cilacap', '', 'Cilacap', '', '', '', '', 5),
('Andrias Motor', ' ', 0, '6285731738939', '', 'Jl. Supriadi 172, Kecamatan Sukun, Kota Malang (Depan Indogrosir Sukun Kacuk)', '', 'Malang', '', '', '', '', 6),
('Anjik', ' ', 0, '6282137488320', '', 'Jepangpakis', '', '', '', '', '', '', 7),
('Anton', ' ', 0, '6289697260387', '', 'Demak', '', '', '', '', '', '', 8),
('Aphink Part', ' ', 0, '6282226129033', '', 'Jl. Ngepos Raya No.6A, Rt 02 Rw 01 Jrakah, Tugu, Semarang Barat Jawa Tengah 50151', '', 'Semarang', '', '', '', '', 9),
('Ardhana Classic', ' ', 0, '6285649869531', '', 'Jl. Sukowati Gg. Makam No.33  Kecamatan Ngawi, Kabupaten Ngawi - Jawa Tengah', '', 'Ngawi', '', '', '', '', 10),
('Arfan CB', ' ', 0, '6281333257250', '', 'Jl. H. Ikhsan Sumber Bening Kesilir Siliraagung (Google Map), Kabupaten Banyuwangi - Jawa Timur', '', 'Banyuwangi', '', '', '', '', 11),
('Arieal Grage', ' ', 0, '6283173812907', '', 'Lampung', '', '', '', '', '', '', 12),
('AVS Part', ' ', 0, '6281358487171', '', 'Jl. Tempean Rt.09/Rw.03, Kecamatan  Gondang Legi, Kabupaten Malang - Jawa Timur', '', 'Malang', '', '', '', '', 13),
('Basum', ' ', 0, '6281555456916', '', 'Jl. Pandanrejo, Rt.07/Rw.02, Desa Pandanrejo,Pagak, Kab. Malang - Jawa Timur 65168', '', 'Malang', '', '', '', '', 14),
('Bima Part ', ' ', 0, '6283894151085', '', 'Pangotan Rt.11 Rw.06 Ke. Geger Kab Madiun - Jawa Timur (63171)', '', 'Madiun', '', '', '', '', 15),
('Biyung Motoshop', ' ', 0, '6281225097054', '', 'Jl Lkr. Bumiayu Samping Sicepat Expres / Ruko Sate Haji Subali Kec. Bumiayu Kab. Brebes Jawa Tengah  (Lewat Purwokerto)', '', 'Bumiayu', '', '', '', '', 16),
('Choirul Huda', ' ', 0, '628970448392', '', 'Ds. Klangenserut Rt.14,Rw 03 Kecamatan Jiwan, Kabupaten Madiun Jawa Timur', '', 'Madiun', '', '', '', '', 17),
('Ciplon', ' ', 0, '6285602202246', '', 'Jepangpakis', '', '', '', '', '', '', 18),
('Danil', ' ', 0, '6289525678463', '', 'Jepangpakis', '', '', '', '', '', '', 19),
('Dedi', ' ', 0, '6282282634121', '', 'Jl. Karya Jaya No. 1436, Kota Palembang, Sematang Boring Sumatera Selatan (Taman Sako)', '', 'Palembang', '', '', '', '', 20),
('Dholin', ' ', 0, '628985447570', '', 'Jepangpakis', '', '', '', '', '', '', 21),
('Dian menara classic', ' ', 0, '6285800005699', '', 'Terban', '', '', '', '', '', '', 22),
('Dimas', ' ', 0, '6289508666560', '', 'Jepangpakis', '', '', '', '', '', '', 23),
('Dipo', ' ', 0, '6282133870690', '', 'Jepangpakis', '', '', '', '', '', '', 24),
('Dody 92 Classic Shop', ' ', 0, '6282250748221', '', 'Jl. Cilik Riwut Km.29 Kel. Tumbang Tahai Kec. Bukit Batu Kota. Palangkaraya  - Kalteng', '', 'Kalimantan', '', '', '', '', 25),
('Doni ', ' ', 0, '6281226135242', '', 'Ds. Pedak, 01/02. Sulang Kabupaten Rembang (Gor Rembang Kebarat Sekitar 800M)', '', 'Rembang', '', '', '', '', 26),
('DP Shop', ' ', 0, '6281217243173', '', 'Jl. Sonotengah, Rt.65/Rw.13 (Timur Musholla Taman Tin) Kebonagung, Kec Pakisaji, Kab Malang - Jawa Timur', '', 'Malang', '', '', '', '', 27),
('Eka Reborn', ' ', 0, '6281381471283', '', 'Kudus', '', '', '', '', '', '', 28),
('Faisal', ' ', 0, '6285640243184', '', 'Jepangpakis', '', '', '', '', '', '', 29),
('Faizal 23 Dete', ' ', 0, '6289663791586', '', 'Jl. Buntu, Dsn Pedaren, Ds. Munggu Rt.02/Rw.05, Kecamatan Petanahan Kabupaten Kebumen - 54382', '', 'Kebumen', '', '', '', '', 30),
('Fajar Part', ' ', 0, '6285804916855', '', 'Desa Ketanireng Dusun Wilo Rt.03/Rw.03 Kecamatan Prigen, Kabupaten Pasuruan - Jawa Timur', '', 'Pasuruan', '', '', '', '', 31),
('Fauzi', ' ', 0, '6281268282093', '', 'Ds. Beringin Indah Rt.02/Rw.02, Kec Pangkan Kuras, Kab Pelalawan (Sorek), Riau-28382', '', 'Riau', '', '', '', '', 32),
('Fortune 77 ', ' ', 0, '6281233738585', '', 'Mojokerto', '', '', '', '', '', '', 33),
('Hamied Omah Classic', ' ', 0, '6285215334944', '', 'Jl Hm. Rifaddin Dpn No. 70 Rt 14 Kel. Tani Aman Kec. Loajanan Ilir Samarinda - Kaltim', '', 'Samarinda', '', '', '', '', 34),
('Handika', ' ', 0, '6289619098773', '', 'Jalan Ahmad Yani No 12, Desa Sawahan Rt 1 Rw 2, Kab. Rembang, Kec. Rembang Jawa Tengah, 59215', '', 'Rembang', '', '', '', '', 35),
('Hasan', ' ', 0, '6287824189570', '', 'Jepangpakis', '', '', '', '', '', '', 36),
('Heri', ' ', 0, '6281548328005', '', 'Jl. Karya Jaya No. 1436, Kota Palembang, Sematang Boring Sumatera Selatan (Taman Sako)', '', 'Purbalingga', '', '', '', '', 37),
('Heru', ' ', 0, '6283874467277', '', 'Jl Kajem Pusat Desa Randusari Rt03 Rw05 No 17 Kec Pagerbarang, Kab Tegal, Jawa Tengah', '', 'Tegal', '', '', '', '', 38),
('Ibnu', ' ', 0, '6281329427944', '', 'Desa Gabusan Dukuh Ngembang Rt.01/Rw.05 Kecamatan Jati Kabupaten Blora - Jawa Tengah', '', 'Blora', '', '', '', '', 39),
('Irfan ', ' ', 0, '6289505484091', '', 'Desa Pagotan Rt.10/Rw.05 Kec. Geger, Kabupaten Madiun - Jawa Timur', '', 'Madiun', '', '', '', '', 40),
('Jabar', ' ', 0, '6289669060756', '', 'Jepangpakis', '', '', '', '', '', '', 41),
('Jaenal ', ' ', 0, '6285216670033', '', 'Jl. Kh. Ahmad Dahlan, Rt. 002/Rw. 002, Petir, Kecamatan Cipondoh, Kota Tangerang - Banten 15147', '', 'Tangerang', '', '', '', '', 42),
('Jakwir Classic', ' ', 0, '6281542885566', '', 'Jl. Lingkar Langkap, Bumiayu, Kabupaten Brebes - Jawa Tengah (Baraka Cabang Purwokerto)', '', 'Brebes', '', '', '', '', 43),
('Jordan', ' ', 0, '6285856200422', '', 'Dusun Jatiroto Rt.02/Rw.13, Desa Sumbergedang, Kecamatan Pandaan, Kabupaten Pasuruan - Jawa Timur', '', 'Pasuruan', '', '', '', '', 44),
('K4 Motor', ' ', 0, '6285602904060', '', 'Kudus', '', '', '', '', '', '', 45),
('Klutuk Part', ' ', 0, '6285887475078', '', 'Ds. Sukadanau, Rt03/02 Gg Kenanga, Dekat Lap. Bulutangkis, Kontr. Bp Suparno (Aimar), Cikarang Barat Kab. Bekasi - Jawa Barat', '', 'Cikarang', '', '', '', '', 46),
('Lancar Jaya motor', ' ', 0, '6281390759885', '', 'Jalan Raya Kedok Selatan No 425 Rt.11/Rw. 2 Kelurahan Kedok, Kec Turen Kab Malang ( Toko Lancar Jaya Motor)', '', 'Malang', '', '', '', '', 47),
('Lek so', ' ', 0, '6281226950440', '', 'Grobogan', '', '', '', '', '', '', 48),
('Muchlas', ' ', 0, '6285867779437', '', 'Rumah Bp Jumal Setiawan No 463 Ngregunung, Rt02/Rw03, Kelurahan Tegalrejo, Kecamatan Sawit, Boyolali - Jawa Tengah', '', 'Boyolali', '', '', '', '', 49),
('Nanda Garage', ' ', 0, '6288992070531', '', 'Sundan Rt.04 Rw.09 Kec Wonosari, Kabupaten Malang - Jawa Timur.', '', 'Malang', '', '', '', '', 50),
('Nopri', ' ', 0, '6285292981891', '', 'Jepangpakis', '', '', '', '', '', '', 51),
('Noval', ' ', 0, '62895411630676', '', 'Jepangpakis', '', '', '', '', '', '', 52),
('Qirom', ' ', 0, '6287726831275', '', 'Rt.1/Rw.1 , Grumbul Rejo, Bulu Rejo, Gondang Rejo    Karanganyar, 57188', '', 'Solo', '', '', '', '', 53),
('Radit', ' ', 0, '6285742719005', '', 'Ambil Agen Baraka Solo - Solo', '', 'Solo', '', '', '', '', 54),
('Riezal', ' ', 0, '6288228976980', '', 'Dukuh Krandon Rt.03 Rw.03 Desa Donorejo Kecamatan Limpung     Kab. Batang -  Jawa Tengah', '', 'Batang', '', '', '', '', 55),
('Rizal', ' ', 0, '6281295242554', '', 'Usman Motor Komplek Ldii Bor 2 Sungai Lilin Jaya Kec. Sungai Lilin, Kab. Musi Banyuasin Provinsi Sumsel', '', 'Palembang', '', '', '', '', 56),
('Rohman', ' ', 0, '6282133870688', '', 'Jepangpakis', '', '', '', '', '', '', 57),
('Sholeh', ' ', 0, '6281227114190', '', 'Jepangpakis', '', '', '', '', '', '', 58),
('Siska ', ' ', 0, '6285645053897', '', 'Magetan', '', '', '', '', '', '', 59),
('Sohar', ' ', 0, '6287875288798', '', 'Jepangpakis', '', '', '', '', '', '', 60),
('Sony', ' ', 0, '6282210093553', '', 'Jl. H. Mawar, Rt.12 Rw.07 No 33, (Depan Jamu Sugiono), Kel     Sunter Jaya, Tanjung Priok, Jakarta Utara Dki Jakarta.', '', 'Jakarta', '', '', '', '', 61),
('Toni', ' ', 0, '6289530114356', '', 'Jepangpakis', '', '', '', '', '', '', 62),
('Ulul', ' ', 0, '6281297669221', '', 'Jepangpakis', '', '', '', '', '', '', 63),
('Umam', ' ', 0, '6287823923576', '', 'Jepangpakis', '', '', '', '', '', '', 64),
('Wawan  Klaten', ' ', 0, '6281225509111', '', 'Jl. Srowot - Wedi Km 1 Jogonalan, Klaten', '', 'Klaten', '', '', '', '', 65),
('Wawan Bandung', ' ', 0, '6285352212266', '', 'Kopo Permai 2 Blok A 12 No.10 Kec. Margahayu, Kab Bandung - Jawa Barat', '', 'Bandung', '', '', '', '', 66),
('Yoga Godong', ' ', 0, '6289647331331', '', 'Desa Jatilor Rt.03/Rw.01 Kecamatan Godong, Kabupaten Grobogan - Jawa Tengah', '', 'Godong', '', '', '', '', 67),
('Yoga Kudus', ' ', 0, '628990202110', '', 'Kudus', '', '', '', '', '', '', 68),
('Yusworo', ' ', 0, '6283162102209', '', 'Dsn. Jampelan, Rt.02 Rw.02, Ds. Getasan, Kecamatan Getasan Kab, Semarang.', '', 'Salatiga', '', '', '', '', 69),
('Zaenal', ' ', 0, '6289669420493', '', 'Kudus', '', '', '', '', '', '', 70),
('Zaenudin', ' ', 0, '6283838511967', '', 'Desa Winong Rt05 Rw 02 Kec Ngampell, Kab Kendal', '', 'Kendal', '', '', '', '', 71),
('Zipvo Part', ' ', 0, '6282322391901', '', 'Jl. Hos Cokroaminoto No.34 Pasar Klitikan Pakuncen, Blok B1 Los 7, Kios Zipvoarfapart, Wirobrajan - Yogyakarta', '', 'Jogja', '', '', '', '', 72),
('Shopee bmt_part', ' ', NULL, '', '', '', '', '', '', '', '', '', 73),
('Manager', ' ', NULL, '', '', '', '', '', '', '', '', '', 74),
('Alee', ' ', NULL, '', '', 'jepangpakis', '', '', '', '', '', '', 75),
('Nafis', ' ', NULL, '', '', '', '', '', '', '', '', '', 76),
('Boyot', ' ', NULL, '', '', 'jepangpakis', '', '', '', '', '', '', 77),
('Zuly', ' ', NULL, '', '', 'JEPANGPAKIS', '', '', '', '', '', '', 78),
('Pacul ', ' ', NULL, '', '', 'JEPANGPAKIS', '', '', '', '', '', '', 79),
('Benggol', ' ', NULL, '', '', '', '', '', '', '', '', '', 80),
('Customer', ' ', NULL, '', '', '', '', '', '', '', '', '', 81),
('Dul', ' ', NULL, '', '', 'PATI', '', '', '', '', '', '', 82),
('Lilik', ' ', NULL, '', '', 'jepangpakis', '', '', '', '', '', '', 83),
('Nopal ', ' ', NULL, '', '', 'jepangpakis', '', '', '', '', '', '', 84),
('Devi Novianti', ' ', NULL, '', '', 'DEMAK', '', '', '', '', '', '', 85),
('Dimas Bagong', ' ', NULL, '', '', 'JEPANGPAKIS', '', '', '', '', '', '', 86);

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

--
-- Table structure for table `ospos_permissions`
--

CREATE TABLE `ospos_permissions` (
  `permission_id` varchar(255) NOT NULL,
  `module_id` varchar(255) NOT NULL,
  `location_id` int(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ospos_permissions`
--

INSERT INTO `ospos_permissions` (`permission_id`, `module_id`, `location_id`) VALUES
('attributes', 'attributes', NULL),
('cashups', 'cashups', NULL),
('config', 'config', NULL),
('customers', 'customers', NULL),
('employees', 'employees', NULL),
('expenses', 'expenses', NULL),
('expenses_categories', 'expenses_categories', NULL),
('giftcards', 'giftcards', NULL),
('home', 'home', NULL),
('items', 'items', NULL),
('items_stock', 'items', 1),
('item_kits', 'item_kits', NULL),
('messages', 'messages', NULL),
('office', 'office', NULL),
('receivings', 'receivings', NULL),
('receivings_stock', 'receivings', 1),
('reports', 'reports', NULL),
('reports_categories', 'reports', NULL),
('reports_customers', 'reports', NULL),
('reports_discounts', 'reports', NULL),
('reports_employees', 'reports', NULL),
('reports_expenses_categories', 'reports', NULL),
('reports_inventory', 'reports', NULL),
('reports_items', 'reports', NULL),
('reports_payments', 'reports', NULL),
('reports_receivings', 'reports', NULL),
('reports_sales', 'reports', NULL),
('reports_sales_taxes', 'reports', NULL),
('reports_suppliers', 'reports', NULL),
('reports_taxes', 'reports', NULL),
('sales', 'sales', NULL),
('sales_change_price', 'sales', NULL),
('sales_delete', 'sales', NULL),
('sales_stock', 'sales', 1),
('suppliers', 'suppliers', NULL),
('surveillance_cams', 'surveillance_cams', NULL),
('taxes', 'taxes', NULL),
('time_attendances', 'time_attendances', NULL);

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

--
-- Table structure for table `ospos_receivings`
--

CREATE TABLE `ospos_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 DEFAULT NULL,
  `receiving_id` int(10) NOT NULL,
  `payment_type` varchar(20) DEFAULT NULL,
  `reference` varchar(32) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ospos_receivings`
--

INSERT INTO `ospos_receivings` (`receiving_time`, `supplier_id`, `employee_id`, `comment`, `receiving_id`, `payment_type`, `reference`) VALUES
('2022-01-17 14:21:49', NULL, 74, '', 1, 'Tunai', NULL);

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

--
-- Table structure for table `ospos_receivings_items`
--

CREATE TABLE `ospos_receivings_items` (
  `receiving_id` int(10) NOT NULL DEFAULT 0,
  `item_id` int(10) NOT NULL DEFAULT 0,
  `description` varchar(30) DEFAULT NULL,
  `serialnumber` varchar(30) DEFAULT NULL,
  `line` int(3) NOT NULL,
  `quantity_purchased` decimal(15,3) NOT NULL DEFAULT 0.000,
  `item_cost_price` decimal(15,2) NOT NULL,
  `item_unit_price` decimal(15,2) NOT NULL,
  `discount` decimal(15,2) NOT NULL DEFAULT 0.00,
  `discount_type` tinyint(2) NOT NULL DEFAULT 0,
  `item_location` int(11) NOT NULL,
  `receiving_quantity` decimal(15,3) NOT NULL DEFAULT 1.000
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ospos_receivings_items`
--

INSERT INTO `ospos_receivings_items` (`receiving_id`, `item_id`, `description`, `serialnumber`, `line`, `quantity_purchased`, `item_cost_price`, `item_unit_price`, `discount`, `discount_type`, `item_location`, `receiving_quantity`) VALUES
(1, 182, '', NULL, 1, '100.000', '15500.00', '15500.00', '0.00', 0, 1, '1.000');

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

--
-- Table structure for table `ospos_sales`
--

CREATE TABLE `ospos_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 DEFAULT NULL,
  `invoice_number` varchar(32) DEFAULT NULL,
  `quote_number` varchar(32) DEFAULT NULL,
  `sale_id` int(10) NOT NULL,
  `sale_status` tinyint(2) NOT NULL DEFAULT 0,
  `dinner_table_id` int(11) DEFAULT NULL,
  `work_order_number` varchar(32) DEFAULT NULL,
  `sale_type` tinyint(2) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ospos_sales`
--

INSERT INTO `ospos_sales` (`sale_time`, `customer_id`, `employee_id`, `comment`, `invoice_number`, `quote_number`, `sale_id`, `sale_status`, `dinner_table_id`, `work_order_number`, `sale_type`) VALUES
('2022-01-07 19:50:43', 73, 1, '', NULL, NULL, 1, 0, NULL, NULL, 0),
('2022-01-07 20:29:25', 58, 1, '', NULL, NULL, 2, 0, NULL, NULL, 0),
('2022-01-07 20:37:05', 5, 1, '', NULL, NULL, 3, 0, NULL, NULL, 0),
('2022-01-10 16:24:34', 58, 74, '', NULL, NULL, 4, 0, NULL, NULL, 0),
('2022-01-16 16:44:23', 36, 74, '', NULL, NULL, 5, 0, NULL, NULL, 0),
('2022-01-17 14:12:13', 58, 74, '', NULL, NULL, 6, 0, NULL, NULL, 0),
('2022-01-18 12:44:16', 75, 74, '', NULL, NULL, 7, 0, NULL, NULL, 0),
('2022-01-19 06:59:55', 76, 74, '', NULL, NULL, 8, 0, NULL, NULL, 0),
('2022-01-19 07:50:10', 77, 74, '', NULL, NULL, 9, 2, NULL, NULL, 0),
('2022-01-19 07:56:04', 77, 74, '', NULL, NULL, 10, 0, NULL, NULL, 0),
('2022-01-19 11:53:05', 78, 74, '', NULL, NULL, 11, 0, NULL, NULL, 0),
('2022-01-19 12:22:08', 64, 74, '', NULL, NULL, 12, 0, NULL, NULL, 0),
('2022-01-19 12:37:13', 21, 74, '', NULL, NULL, 13, 0, NULL, NULL, 0),
('2022-01-19 13:28:15', 57, 74, '', NULL, NULL, 14, 0, NULL, NULL, 0),
('2022-01-19 13:59:19', 79, 74, '', NULL, NULL, 15, 0, NULL, NULL, 0),
('2022-01-19 16:23:11', 80, 74, '', NULL, NULL, 16, 0, NULL, NULL, 0),
('2022-01-20 10:02:17', 24, 74, '', NULL, NULL, 17, 0, NULL, NULL, 0),
('2022-01-20 10:06:54', 57, 74, '', NULL, NULL, 18, 0, NULL, NULL, 0),
('2022-01-20 10:25:39', 66, 1, '', NULL, NULL, 19, 0, NULL, NULL, 0),
('2022-01-20 12:28:59', 69, 74, '', NULL, NULL, 20, 0, NULL, NULL, 0),
('2022-01-20 13:00:02', 73, 1, '', NULL, NULL, 21, 0, NULL, NULL, 0),
('2022-01-20 13:06:56', 22, 74, '', NULL, NULL, 22, 0, NULL, NULL, 0),
('2022-01-20 13:09:20', 22, 1, '', NULL, NULL, 23, 0, NULL, NULL, 0),
('2022-01-20 13:15:49', 22, 1, '', NULL, NULL, 24, 0, NULL, NULL, 0),
('2022-01-20 13:18:06', 22, 1, '', NULL, NULL, 25, 0, NULL, NULL, 0),
('2022-01-20 16:04:10', 76, 1, '', NULL, NULL, 26, 0, NULL, NULL, 0),
('2022-01-20 16:09:29', 76, 1, '', NULL, NULL, 27, 0, NULL, NULL, 0),
('2022-01-21 08:22:25', 79, 1, '', NULL, NULL, 28, 0, NULL, NULL, 0),
('2022-01-21 08:25:50', 82, 74, '', NULL, NULL, 29, 0, NULL, NULL, 0),
('2022-01-21 10:22:12', 83, 74, '', NULL, NULL, 30, 0, NULL, NULL, 0),
('2022-01-21 11:31:58', 75, 74, '', NULL, NULL, 31, 0, NULL, NULL, 0),
('2022-01-21 12:06:33', 84, 74, '', NULL, NULL, 32, 0, NULL, NULL, 0),
('2022-01-21 14:52:20', 85, 74, '', NULL, NULL, 33, 0, NULL, NULL, 0),
('2022-01-22 12:06:47', 86, 74, '', NULL, NULL, 34, 0, NULL, NULL, 0),
('2022-01-22 12:32:28', 8, 74, '', NULL, NULL, 35, 0, NULL, NULL, 0),
('2022-01-22 15:02:03', 81, 74, '', NULL, NULL, 36, 0, NULL, NULL, 0),
('2022-01-22 18:42:06', 81, 74, '', NULL, NULL, 37, 0, NULL, NULL, 0),
('2022-01-22 19:43:08', 81, 74, '', NULL, NULL, 38, 0, NULL, NULL, 0);

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

--
-- Table structure for table `ospos_sales_items`
--

CREATE TABLE `ospos_sales_items` (
  `sale_id` int(10) NOT NULL DEFAULT 0,
  `item_id` int(10) NOT NULL DEFAULT 0,
  `description` varchar(255) DEFAULT NULL,
  `serialnumber` varchar(30) DEFAULT NULL,
  `line` int(3) NOT NULL DEFAULT 0,
  `quantity_purchased` decimal(15,3) NOT NULL DEFAULT 0.000,
  `item_cost_price` decimal(15,2) NOT NULL,
  `item_unit_price` decimal(15,2) NOT NULL,
  `discount` decimal(15,2) NOT NULL DEFAULT 0.00,
  `discount_type` tinyint(2) NOT NULL DEFAULT 0,
  `item_location` int(11) NOT NULL,
  `print_option` tinyint(2) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ospos_sales_items`
--

INSERT INTO `ospos_sales_items` (`sale_id`, `item_id`, `description`, `serialnumber`, `line`, `quantity_purchased`, `item_cost_price`, `item_unit_price`, `discount`, `discount_type`, `item_location`, `print_option`) VALUES
(1, 1, '', '', 1, '1.000', '540000.00', '590000.00', '0.00', 0, 1, 0),
(2, 1, '', '', 1, '1.000', '540000.00', '590000.00', '0.00', 0, 1, 0),
(3, 1, '', '', 1, '1.000', '540000.00', '590000.00', '0.00', 0, 1, 0),
(4, 1, '', '', 1, '5.000', '540000.00', '590000.00', '0.00', 0, 1, 0),
(5, 5, '', '', 1, '1.000', '157000.00', '165000.00', '0.00', 0, 1, 0),
(6, 9, '', '', 3, '2.000', '285000.00', '335000.00', '0.00', 0, 1, 0),
(6, 20, '', '', 1, '5.000', '30000.00', '55000.00', '0.00', 0, 1, 0),
(6, 27, '', '', 2, '7.000', '40000.00', '50000.00', '0.00', 0, 1, 0),
(7, 62, '', '', 6, '1.000', '17000.00', '21000.00', '0.00', 0, 1, 0),
(7, 80, '', '', 2, '2.000', '60000.00', '50000.00', '0.00', 0, 1, 0),
(7, 94, '', '', 3, '2.000', '31000.00', '34000.00', '0.00', 0, 1, 0),
(7, 122, '', '', 1, '4.000', '107000.00', '117000.00', '0.00', 0, 1, 0),
(7, 149, '', '', 5, '1.000', '26500.00', '31000.00', '0.00', 0, 1, 0),
(7, 183, '', '', 4, '1.000', '15500.00', '19000.00', '0.00', 0, 1, 0),
(8, 145, NULL, NULL, 1, '1.000', '25500.00', '35000.00', '0.00', 0, 1, 0),
(9, 15, NULL, NULL, 1, '1.000', '35000.00', '40000.00', '0.00', 0, 1, 0),
(9, 62, NULL, NULL, 2, '1.000', '17000.00', '21000.00', '0.00', 0, 1, 0),
(9, 71, NULL, NULL, 3, '1.000', '18000.00', '21000.00', '0.00', 0, 1, 0),
(10, 15, NULL, NULL, 1, '1.000', '35000.00', '40000.00', '0.00', 0, 1, 0),
(10, 62, NULL, NULL, 2, '1.000', '17000.00', '21000.00', '0.00', 0, 1, 0),
(10, 71, NULL, NULL, 3, '1.000', '18000.00', '21000.00', '0.00', 0, 1, 0),
(10, 149, NULL, NULL, 4, '1.000', '26500.00', '31000.00', '0.00', 0, 1, 0),
(11, 27, NULL, NULL, 1, '5.000', '40000.00', '40000.00', '0.00', 0, 1, 0),
(12, 131, NULL, NULL, 1, '1.000', '18500.00', '21000.00', '0.00', 0, 1, 0),
(12, 174, NULL, NULL, 2, '1.000', '35000.00', '40000.00', '0.00', 0, 1, 0),
(13, 123, NULL, NULL, 1, '2.000', '37000.00', '40000.00', '0.00', 0, 1, 0),
(14, 44, NULL, NULL, 1, '5.000', '38000.00', '40000.00', '0.00', 0, 1, 0),
(15, 16, NULL, NULL, 1, '10.000', '35000.00', '40000.00', '0.00', 0, 1, 0),
(16, 56, NULL, NULL, 1, '1.000', '32500.00', '37000.00', '0.00', 0, 1, 0),
(17, 159, NULL, NULL, 1, '50.000', '95000.00', '102000.00', '0.00', 0, 1, 0),
(18, 48, NULL, NULL, 2, '25.000', '14000.00', '16000.00', '0.00', 0, 1, 0),
(18, 123, NULL, NULL, 1, '10.000', '37000.00', '40000.00', '0.00', 0, 1, 0),
(19, 53, NULL, NULL, 3, '3.000', '9000.00', '11000.00', '0.00', 0, 1, 0),
(19, 122, NULL, NULL, 1, '4.000', '107000.00', '117000.00', '0.00', 0, 1, 0),
(19, 124, NULL, NULL, 2, '4.000', '90000.00', '105000.00', '0.00', 0, 1, 0),
(20, 62, NULL, NULL, 3, '5.000', '17000.00', '21000.00', '0.00', 0, 1, 0),
(20, 71, NULL, NULL, 4, '5.000', '18000.00', '21000.00', '0.00', 0, 1, 0),
(20, 85, NULL, NULL, 5, '5.000', '26000.00', '30000.00', '0.00', 0, 1, 0),
(20, 132, NULL, NULL, 2, '5.000', '18500.00', '21000.00', '0.00', 0, 1, 0),
(20, 159, NULL, NULL, 1, '10.000', '95000.00', '103000.00', '0.00', 0, 1, 0),
(21, 1, '', '', 1, '1.000', '540000.00', '590000.00', '0.00', 0, 1, 0),
(22, 91, NULL, NULL, 1, '3.000', '55000.00', '46500.00', '0.00', 0, 1, 0),
(22, 159, NULL, NULL, 2, '1.000', '95000.00', '103000.00', '0.00', 0, 1, 0),
(23, 91, NULL, NULL, 1, '3.000', '55000.00', '46500.00', '0.00', 0, 1, 0),
(23, 159, NULL, NULL, 2, '1.000', '95000.00', '103000.00', '0.00', 0, 1, 0),
(24, 75, NULL, NULL, 1, '4.000', '135000.00', '150000.00', '0.00', 0, 1, 0),
(25, 75, NULL, NULL, 1, '4.000', '135000.00', '150000.00', '0.00', 0, 1, 0),
(26, 188, NULL, NULL, 1, '1.000', '55000.00', '60000.00', '0.00', 0, 1, 0),
(27, 188, NULL, NULL, 1, '1.000', '55000.00', '60000.00', '0.00', 0, 1, 0),
(28, 17, NULL, NULL, 1, '5.000', '35000.00', '40000.00', '0.00', 0, 1, 0),
(29, 63, NULL, NULL, 1, '15.000', '10000.00', '13000.00', '0.00', 0, 1, 0),
(29, 71, NULL, NULL, 2, '5.000', '18000.00', '21000.00', '0.00', 0, 1, 0),
(30, 17, NULL, NULL, 1, '1.000', '35000.00', '40000.00', '0.00', 0, 1, 0),
(31, 80, NULL, NULL, 1, '1.000', '60000.00', '50000.00', '0.00', 0, 1, 0),
(32, 191, NULL, NULL, 1, '3.000', '40000.00', '45000.00', '0.00', 0, 1, 0),
(33, 71, NULL, NULL, 5, '1.000', '18000.00', '21000.00', '0.00', 0, 1, 0),
(33, 138, NULL, NULL, 1, '1.000', '750000.00', '830000.00', '4.00', 0, 1, 0),
(33, 159, NULL, NULL, 4, '1.000', '95000.00', '110000.00', '0.00', 0, 1, 0),
(33, 197, NULL, NULL, 3, '1.000', '35000.00', '40000.00', '0.00', 0, 1, 0),
(34, 123, NULL, NULL, 5, '1.000', '37000.00', '40000.00', '0.00', 0, 1, 0),
(34, 130, NULL, NULL, 3, '1.000', '18500.00', '21000.00', '0.00', 0, 1, 0),
(34, 131, NULL, NULL, 2, '1.000', '18500.00', '21000.00', '0.00', 0, 1, 0),
(34, 166, NULL, NULL, 1, '1.000', '38000.00', '43000.00', '0.00', 0, 1, 0),
(34, 193, NULL, NULL, 4, '2.000', '0.00', '21000.00', '0.00', 0, 1, 0),
(35, 2, NULL, NULL, 1, '1.000', '575000.00', '595000.00', '0.00', 0, 1, 0),
(35, 81, NULL, NULL, 2, '2.000', '250000.00', '260000.00', '0.00', 0, 1, 0),
(36, 201, '', '', 2, '1.000', '1310000.00', '1500000.00', '0.00', 0, 1, 0),
(37, 202, NULL, NULL, 1, '1.000', '0.00', '190000.00', '0.00', 0, 1, 0),
(38, 11, NULL, NULL, 1, '1.000', '155000.00', '180000.00', '0.00', 0, 1, 0);

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

--
-- Table structure for table `ospos_sales_items_taxes`
--

CREATE TABLE `ospos_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) NOT NULL,
  `percent` decimal(15,4) NOT NULL DEFAULT 0.0000,
  `tax_type` tinyint(2) NOT NULL DEFAULT 0,
  `rounding_code` tinyint(2) NOT NULL DEFAULT 0,
  `cascade_sequence` tinyint(2) NOT NULL DEFAULT 0,
  `item_tax_amount` decimal(15,4) NOT NULL DEFAULT 0.0000,
  `sales_tax_code_id` int(11) DEFAULT NULL,
  `jurisdiction_id` int(11) DEFAULT NULL,
  `tax_category_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `ospos_sales_payments`
--

CREATE TABLE `ospos_sales_payments` (
  `payment_id` int(11) NOT NULL,
  `sale_id` int(10) NOT NULL,
  `payment_type` varchar(40) NOT NULL,
  `payment_amount` decimal(15,2) NOT NULL,
  `cash_refund` decimal(15,2) NOT NULL DEFAULT 0.00,
  `cash_adjustment` tinyint(4) NOT NULL DEFAULT 0,
  `employee_id` int(11) DEFAULT NULL,
  `payment_time` timestamp NOT NULL DEFAULT current_timestamp(),
  `reference_code` varchar(40) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ospos_sales_payments`
--

INSERT INTO `ospos_sales_payments` (`payment_id`, `sale_id`, `payment_type`, `payment_amount`, `cash_refund`, `cash_adjustment`, `employee_id`, `payment_time`, `reference_code`) VALUES
(1, 1, 'Tunai', '590000.00', '0.00', 0, 1, '2022-01-07 04:50:43', ''),
(3, 2, 'Jatuh tempo', '590000.00', '0.00', 0, 1, '2022-01-07 05:29:25', ''),
(4, 3, 'Tunai', '590000.00', '0.00', 0, 1, '2022-01-07 05:37:05', ''),
(5, 4, 'Tunai', '2950000.00', '0.00', 0, 74, '2022-01-10 01:24:34', ''),
(6, 5, 'Tunai', '165000.00', '0.00', 0, 74, '2022-01-16 01:44:23', ''),
(7, 6, 'Tunai', '1295000.00', '0.00', 0, 74, '2022-01-16 23:12:13', ''),
(8, 7, 'Tunai', '707000.00', '0.00', 0, 74, '2022-01-17 21:44:16', ''),
(9, 8, 'Tunai', '35000.00', '0.00', 0, 74, '2022-01-18 15:59:55', ''),
(10, 9, 'Tunai', '91000.00', '9000.00', 0, 74, '2022-01-18 16:50:10', ''),
(11, 10, 'Tunai', '113000.00', '0.00', 0, 74, '2022-01-18 16:56:04', ''),
(12, 11, 'Tunai', '200000.00', '0.00', 0, 74, '2022-01-18 20:53:05', ''),
(13, 12, 'Tunai', '61000.00', '0.00', 0, 74, '2022-01-18 21:22:08', ''),
(14, 13, 'Jatuh tempo', '80000.00', '0.00', 0, 74, '2022-01-18 21:37:13', ''),
(15, 14, 'Jatuh tempo', '200000.00', '0.00', 0, 74, '2022-01-18 22:28:15', ''),
(16, 15, 'Tunai', '400000.00', '0.00', 0, 74, '2022-01-18 22:59:19', ''),
(17, 16, 'Tunai', '50000.00', '13000.00', 0, 74, '2022-01-19 01:23:11', ''),
(18, 17, 'Tunai', '5100000.00', '0.00', 0, 74, '2022-01-19 19:02:17', ''),
(19, 18, 'Jatuh tempo', '800000.00', '0.00', 0, 74, '2022-01-19 19:06:54', ''),
(20, 19, 'Jatuh tempo', '921000.00', '0.00', 0, 1, '2022-01-19 19:25:39', ''),
(21, 20, 'Jatuh tempo', '1495000.00', '0.00', 0, 74, '2022-01-19 21:28:59', ''),
(22, 21, 'Tunai', '590000.00', '0.00', 0, 1, '2022-01-19 22:00:02', ''),
(23, 22, 'Tunai', '242500.00', '0.00', 0, 74, '2022-01-19 22:06:56', ''),
(24, 23, 'Tunai', '250000.00', '7500.00', 0, 1, '2022-01-19 22:09:20', ''),
(25, 24, 'Tunai', '600000.00', '0.00', 0, 1, '2022-01-19 22:15:49', ''),
(26, 25, 'Tunai', '600000.00', '0.00', 0, 1, '2022-01-19 22:18:06', ''),
(27, 26, 'Tunai', '60000.00', '0.00', 0, 1, '2022-01-20 01:04:10', ''),
(28, 27, 'Tunai', '60000.00', '0.00', 0, 1, '2022-01-20 01:09:29', ''),
(29, 28, 'Tunai', '200000.00', '0.00', 0, 1, '2022-01-20 17:22:25', ''),
(30, 29, 'Tunai', '300000.00', '0.00', 0, 74, '2022-01-20 17:25:50', ''),
(31, 30, 'Tunai', '50000.00', '10000.00', 0, 74, '2022-01-20 19:22:12', ''),
(32, 31, 'Jatuh tempo', '50000.00', '0.00', 0, 74, '2022-01-20 20:31:58', ''),
(33, 32, 'Tunai', '135000.00', '0.00', 0, 74, '2022-01-20 21:06:33', ''),
(34, 33, 'Tunai', '967800.00', '0.00', 0, 74, '2022-01-20 23:52:20', ''),
(35, 34, 'Tunai', '200000.00', '33000.00', 0, 74, '2022-01-21 21:06:47', ''),
(36, 35, 'Tunai', '1115000.00', '0.00', 0, 74, '2022-01-21 21:32:28', ''),
(37, 36, 'Tunai', '1500000.00', '0.00', 0, 74, '2022-01-22 00:02:03', ''),
(38, 37, 'Tunai', '200000.00', '10000.00', 0, 74, '2022-01-22 03:42:06', ''),
(39, 38, 'Tunai', '180000.00', '0.00', 0, 74, '2022-01-22 04:43:08', '');

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

--
-- Table structure for table `ospos_sales_reward_points`
--

CREATE TABLE `ospos_sales_reward_points` (
  `id` int(11) NOT NULL,
  `sale_id` int(11) NOT NULL,
  `earned` float NOT NULL,
  `used` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `ospos_sales_taxes`
--

CREATE TABLE `ospos_sales_taxes` (
  `sales_taxes_id` int(11) NOT NULL,
  `sale_id` int(10) NOT NULL,
  `jurisdiction_id` int(11) DEFAULT NULL,
  `tax_category_id` int(11) DEFAULT NULL,
  `tax_type` smallint(2) NOT NULL,
  `tax_group` varchar(32) NOT NULL,
  `sale_tax_basis` decimal(15,4) NOT NULL,
  `sale_tax_amount` decimal(15,4) NOT NULL,
  `print_sequence` tinyint(2) NOT NULL DEFAULT 0,
  `name` varchar(255) NOT NULL,
  `tax_rate` decimal(15,4) NOT NULL,
  `sales_tax_code_id` int(11) DEFAULT NULL,
  `rounding_code` tinyint(2) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `ospos_sessions`
--

CREATE TABLE `ospos_sessions` (
  `id` varchar(40) NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `timestamp` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `data` mediumblob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ospos_sessions`
--

INSERT INTO `ospos_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('umpsgne7dnrnihh8t0s8utc78chchbid', '::1', 1644183543, 0x5f5f63695f6c6173745f726567656e65726174657c693a313634343138333534333b706572736f6e5f69647c733a323a223734223b6d656e755f67726f75707c733a343a22686f6d65223b),
('f2f7tk1v7nogb2bc835i5pt182oq49k9', '::1', 1644183865, 0x5f5f63695f6c6173745f726567656e65726174657c693a313634343138333836353b706572736f6e5f69647c733a323a223734223b6d656e755f67726f75707c733a343a22686f6d65223b),
('68idija5t4lnunhvgbohodl5oc4scbps', '::1', 1644184238, 0x5f5f63695f6c6173745f726567656e65726174657c693a313634343138343233383b706572736f6e5f69647c733a323a223734223b6d656e755f67726f75707c733a343a22686f6d65223b),
('g3clok267hsrr0rlsqkgflqan6gj35hh', '::1', 1644185678, 0x5f5f63695f6c6173745f726567656e65726174657c693a313634343138353637383b706572736f6e5f69647c733a323a223734223b6d656e755f67726f75707c733a343a22686f6d65223b),
('2fdhdap9f1eolpbf9784tmjjg4sg4bp7', '::1', 1644187717, 0x5f5f63695f6c6173745f726567656e65726174657c693a313634343138373731373b706572736f6e5f69647c733a323a223734223b6d656e755f67726f75707c733a343a22686f6d65223b),
('k34a2h0j67usmfuhk09fdplklkqh1uv5', '::1', 1644188700, 0x[BLOB]),
('ma96eendvrpsh06dng4fql5c0v1an91c', '::1', 1644189440, 0x[BLOB]),
('0otfcosb8ni1o9qnel8a08vbfb43is9o', '::1', 1644189745, 0x[BLOB]),
('j2hs5ufba8kp43evbpb38jp7olo76l4q', '::1', 1644190399, 0x[BLOB]),
('illu2mg2h7hnhl0o8oieq3qtj6kva8na', '::1', 1644191406, 0x[BLOB]),
('u34nt14u8q47m148gnhnu7to2ru6ld27', '::1', 1644191828, 0x[BLOB]),
('r4f6jh70upvkqmpurvv73fbo3s7gcbuo', '::1', 1644192140, 0x[BLOB]),
('q96b6gcr2n8rj0cnrctignfknc2hropj', '::1', 1644192498, 0x[BLOB]),
('2nl9r86rga2p3g6br092m010nir47kh2', '::1', 1644192894, 0x[BLOB]),
('qffscgpo3q1m5qeaivmuptg6pq4maa38', '::1', 1644192946, 0x[BLOB]),
('p7irgqttt5reg98etht00v30jkca02g9', '::1', 1644215147, 0x5f5f63695f6c6173745f726567656e65726174657c693a313634343231353134373b706572736f6e5f69647c733a323a223734223b6d656e755f67726f75707c733a343a22686f6d65223b),
('nibcsnlbv29upvd9el936hm41kmfsmhl', '::1', 1644215690, 0x5f5f63695f6c6173745f726567656e65726174657c693a313634343231353639303b706572736f6e5f69647c733a323a223734223b6d656e755f67726f75707c733a343a22686f6d65223b),
('mkqob2mpet9ovm414g71e8shag52kf8u', '::1', 1644215992, 0x[BLOB]),
('qp00vu2dmppdgi9823c5b8fg7ar13nsn', '::1', 1644216305, 0x[BLOB]),
('kucggqk4h10r9rcocbtu0hq9bh8mjn9o', '::1', 1644216608, 0x[BLOB]),
('98nc3iv58rdus5pna3mrld9erv1gl79m', '::1', 1644216948, 0x[BLOB]),
('a0mn72l1bfifouolcks7tee3tqql0v7q', '::1', 1644217405, 0x[BLOB]),
('2nr8vuefl93bhantr42s435vedfpn5bv', '::1', 1644217844, 0x[BLOB]),
('en7rvngvg8326ihc4jmb0ofnhgt33ho4', '::1', 1644218173, 0x[BLOB]),
('nqrh95ud9gddu4lldtmrik29lf1lctg7', '::1', 1644218685, 0x[BLOB]),
('l8l804d9cm6knimi185g42rpm09ji4vc', '::1', 1644218994, 0x[BLOB]),
('pp7iheorrikai9r534r356nk2sl69ed7', '::1', 1644219391, 0x[BLOB]),
('0bh0ljmpvuln1rok981u1h46ge96v173', '::1', 1644219825, 0x[BLOB]),
('sqe6gcicsgdgpfiaieokioh5pqbjceo2', '::1', 1644221800, 0x[BLOB]),
('c7qal9h90251u6d5bnatmmcdfk564t1p', '::1', 1644225056, 0x[BLOB]),
('d25dv8krm1r54te7dvj5otvdinrt3gam', '::1', 1644226793, 0x[BLOB]),
('vag4r1jjur963f8r7ih6hbftcbeggbmn', '::1', 1644227316, 0x[BLOB]),
('7sasitcqvuhoopm6ld5tpmt22dpobim7', '::1', 1644227621, 0x[BLOB]),
('57vd76bvn389jlrl9ufdvoi9qe8jncja', '::1', 1644227969, 0x[BLOB]),
('v6d1b1gmq2ha8t9vf80iv0ouop42luj1', '::1', 1644227970, 0x[BLOB]),
('112ppiplnvsljoehrkqm8a5pe5oq2c2d', '::1', 1644241141, 0x5f5f63695f6c6173745f726567656e65726174657c693a313634343234313134313b706572736f6e5f69647c733a323a223734223b6d656e755f67726f75707c733a343a22686f6d65223b616c6c6f775f74656d705f6974656d737c693a303b6974656d5f6c6f636174696f6e7c733a313a2231223b),
('g2q6brtmne4nmi3pe0925vb1lo6tjt02', '::1', 1644241182, 0x5f5f63695f6c6173745f726567656e65726174657c693a313634343234313134313b706572736f6e5f69647c733a323a223734223b6d656e755f67726f75707c733a343a22686f6d65223b616c6c6f775f74656d705f6974656d737c693a303b6974656d5f6c6f636174696f6e7c733a313a2231223b),
('mjdjns3ev8vc7bd0adcnoka736cdeibf', '::1', 1644251464, 0x[BLOB]),
('dpvvvpf80e0vguuvk5i0mbchkle73cvj', '::1', 1644320396, 0x[BLOB]),
('1r0pdtmm8frbs76jvb1j0k78m1lom6ma', '::1', 1644509556, 0x[BLOB]),
('01g59jhi35sg8vj0lars1p801dbe13hp', '::1', 1644513258, 0x[BLOB]),
('kflv9dnsc73optbn60puhjklp4ed9nh6', '::1', 1644513639, 0x[BLOB]),
('paddfon21r0seg19lmivjsqflvootai8', '::1', 1644513675, 0x[BLOB]),
('5bid4br2lmvai7j6e3m01mhu5of598nj', '::1', 1644563941, 0x[BLOB]),
('4mcaf0omqtkktggaj06om9e12qmg4lau', '192.168.0.133', 1644564058, 0x[BLOB]),
('as63vh3vqqpvmpvesvb12sblt7vu0u13', '::1', 1644563964, 0x[BLOB]),
('qf08iejpjc7i2nlqan2osipsg7ug0hfs', '::1', 1644687770, 0x5f5f63695f6c6173745f726567656e65726174657c693a313634343638373737303b),
('900oohjs142ed9v9056mlrkv6ahh0dec', '::1', 1644688356, 0x5f5f63695f6c6173745f726567656e65726174657c693a313634343638383335363b706572736f6e5f69647c733a323a223734223b6d656e755f67726f75707c733a343a22686f6d65223b),
('qhis9b8kpsu9u5rbi0qhugd8i1q6lp20', '::1', 1644690112, 0x5f5f63695f6c6173745f726567656e65726174657c693a313634343639303131323b706572736f6e5f69647c733a323a223734223b6d656e755f67726f75707c733a343a22686f6d65223b),
('5hbr5679poqdh3n8vnhal2llaju8o6e4', '::1', 1644690416, 0x5f5f63695f6c6173745f726567656e65726174657c693a313634343639303431363b706572736f6e5f69647c733a323a223734223b6d656e755f67726f75707c733a343a22686f6d65223b616c6c6f775f74656d705f6974656d737c693a303b6974656d5f6c6f636174696f6e7c733a313a2231223b),
('1udaiqrq2724d7ke996fpji3816ihvrp', '::1', 1644690500, 0x5f5f63695f6c6173745f726567656e65726174657c693a313634343639303431363b706572736f6e5f69647c733a323a223734223b6d656e755f67726f75707c733a343a22686f6d65223b616c6c6f775f74656d705f6974656d737c693a303b6974656d5f6c6f636174696f6e7c733a313a2231223b),
('hvltcqpl2bcjhlo7nj619etuk3od5pd6', '::1', 1644726232, 0x5f5f63695f6c6173745f726567656e65726174657c693a313634343732363233323b),
('ah241o64q8o1i2uoeu8006v6kt3t0s19', '::1', 1644729524, 0x5f5f63695f6c6173745f726567656e65726174657c693a313634343732393532343b706572736f6e5f69647c733a323a223734223b6d656e755f67726f75707c733a343a22686f6d65223b),
('lk300k71rn87i7ibmq2robrqddaseutk', '::1', 1644729984, 0x[BLOB]),
('vier0u7vrl39bj34s2frbcrlhge1hnbh', '::1', 1644730412, 0x[BLOB]),
('adkdei9c55ofn8fem9i0giebrho0459b', '::1', 1644730882, 0x[BLOB]),
('eodfbe6tn6irt49ikdgsukdopjfvsc1p', '::1', 1644731178, 0x[BLOB]),
('chlef7dg8d8lj8cfkus1pi2lg5riq6m1', '::1', 1644758327, 0x[BLOB]),
('t3j2gei2kntfhq2s8trpgbtktid2tgoh', '::1', 1644758692, 0x[BLOB]),
('che5af1n657v9uqe140grmpicllf7arl', '::1', 1644759054, 0x[BLOB]),
('unmn84a5llhb0tdrlscvbc54mr9ehpb6', '::1', 1644759386, 0x[BLOB]),
('h41gmgoe61iq404hm6lc28585plj6m26', '::1', 1644759709, 0x[BLOB]),
('de1so93hbc82igr9fo0i00sg9llnjk8d', '::1', 1644760036, 0x[BLOB]),
('hbq1htrcd3vpu75kam1ba43nof819ar7', '::1', 1644760469, 0x[BLOB]),
('1iungha5pm9lok2vl8ugcpfpmk8fbu6c', '::1', 1644760796, 0x[BLOB]),
('fh4mk398a83tisfevkdetbsm06rsm1f9', '::1', 1644761029, 0x[BLOB]);

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

--
-- Table structure for table `ospos_stock_locations`
--

CREATE TABLE `ospos_stock_locations` (
  `location_id` int(11) NOT NULL,
  `location_name` varchar(255) DEFAULT NULL,
  `deleted` int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ospos_stock_locations`
--

INSERT INTO `ospos_stock_locations` (`location_id`, `location_name`, `deleted`) VALUES
(1, 'stock', 0);

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

--
-- Table structure for table `ospos_suppliers`
--

CREATE TABLE `ospos_suppliers` (
  `person_id` int(10) NOT NULL,
  `company_name` varchar(255) NOT NULL,
  `agency_name` varchar(255) NOT NULL,
  `account_number` varchar(255) DEFAULT NULL,
  `tax_id` varchar(32) NOT NULL DEFAULT '',
  `deleted` int(1) NOT NULL DEFAULT 0,
  `category` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `ospos_tax_categories`
--

CREATE TABLE `ospos_tax_categories` (
  `tax_category_id` int(10) NOT NULL,
  `tax_category` varchar(32) NOT NULL,
  `tax_group_sequence` tinyint(2) NOT NULL,
  `deleted` int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `ospos_tax_codes`
--

CREATE TABLE `ospos_tax_codes` (
  `tax_code_id` int(11) NOT NULL,
  `tax_code` varchar(32) NOT NULL,
  `tax_code_name` varchar(255) NOT NULL DEFAULT '',
  `city` varchar(255) NOT NULL DEFAULT '',
  `state` varchar(255) NOT NULL DEFAULT '',
  `deleted` int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `ospos_tax_jurisdictions`
--

CREATE TABLE `ospos_tax_jurisdictions` (
  `jurisdiction_id` int(11) NOT NULL,
  `jurisdiction_name` varchar(255) DEFAULT NULL,
  `tax_group` varchar(32) NOT NULL,
  `tax_type` smallint(2) NOT NULL,
  `reporting_authority` varchar(255) DEFAULT NULL,
  `tax_group_sequence` tinyint(2) NOT NULL DEFAULT 0,
  `cascade_sequence` tinyint(2) NOT NULL DEFAULT 0,
  `deleted` int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `ospos_tax_rates`
--

CREATE TABLE `ospos_tax_rates` (
  `tax_rate_id` int(11) NOT NULL,
  `rate_tax_code_id` int(11) NOT NULL,
  `rate_tax_category_id` int(10) NOT NULL,
  `rate_jurisdiction_id` int(11) NOT NULL,
  `tax_rate` decimal(15,4) NOT NULL DEFAULT 0.0000,
  `tax_rounding_code` tinyint(2) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `ospos_time_attendances`
--

CREATE TABLE `ospos_time_attendances` (
  `id` int(11) NOT NULL,
  `date` date DEFAULT NULL,
  `in` time DEFAULT NULL,
  `out` time DEFAULT NULL,
  `person_id` int(10) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Indexes for table `ospos_attribute_definitions`
--
ALTER TABLE `ospos_attribute_definitions`
  ADD PRIMARY KEY (`definition_id`),
  ADD KEY `definition_fk` (`definition_fk`);

--
-- Indexes for table `ospos_attribute_links`
--
ALTER TABLE `ospos_attribute_links`
  ADD UNIQUE KEY `attribute_links_uq1` (`attribute_id`,`definition_id`,`item_id`,`sale_id`,`receiving_id`),
  ADD KEY `attribute_id` (`attribute_id`),
  ADD KEY `definition_id` (`definition_id`),
  ADD KEY `item_id` (`item_id`),
  ADD KEY `sale_id` (`sale_id`),
  ADD KEY `receiving_id` (`receiving_id`);

--
-- Indexes for table `ospos_attribute_values`
--
ALTER TABLE `ospos_attribute_values`
  ADD PRIMARY KEY (`attribute_id`),
  ADD UNIQUE KEY `attribute_value` (`attribute_value`);

--
-- Indexes for table `ospos_cash_up`
--
ALTER TABLE `ospos_cash_up`
  ADD PRIMARY KEY (`cashup_id`),
  ADD KEY `open_employee_id` (`open_employee_id`),
  ADD KEY `close_employee_id` (`close_employee_id`);

--
-- Indexes for table `ospos_customers`
--
ALTER TABLE `ospos_customers`
  ADD UNIQUE KEY `account_number` (`account_number`),
  ADD KEY `person_id` (`person_id`),
  ADD KEY `package_id` (`package_id`),
  ADD KEY `sales_tax_code_id` (`sales_tax_code_id`);

--
-- Indexes for table `ospos_customers_packages`
--
ALTER TABLE `ospos_customers_packages`
  ADD PRIMARY KEY (`package_id`);

--
-- Indexes for table `ospos_customers_points`
--
ALTER TABLE `ospos_customers_points`
  ADD PRIMARY KEY (`id`),
  ADD KEY `person_id` (`person_id`),
  ADD KEY `package_id` (`package_id`),
  ADD KEY `sale_id` (`sale_id`);

--
-- Indexes for table `ospos_dinner_tables`
--
ALTER TABLE `ospos_dinner_tables`
  ADD PRIMARY KEY (`dinner_table_id`);

--
-- Indexes for table `ospos_expenses`
--
ALTER TABLE `ospos_expenses`
  ADD PRIMARY KEY (`expense_id`),
  ADD KEY `expense_category_id` (`expense_category_id`),
  ADD KEY `employee_id` (`employee_id`),
  ADD KEY `ospos_expenses_ibfk_3` (`supplier_id`),
  ADD KEY `date` (`date`);

--
-- Indexes for table `ospos_expense_categories`
--
ALTER TABLE `ospos_expense_categories`
  ADD PRIMARY KEY (`expense_category_id`),
  ADD UNIQUE KEY `category_name` (`category_name`);

--
-- Indexes for table `ospos_giftcards`
--
ALTER TABLE `ospos_giftcards`
  ADD PRIMARY KEY (`giftcard_id`),
  ADD UNIQUE KEY `giftcard_number` (`giftcard_number`),
  ADD KEY `person_id` (`person_id`);

--
-- Indexes for table `ospos_grants`
--
ALTER TABLE `ospos_grants`
  ADD PRIMARY KEY (`permission_id`,`person_id`),
  ADD KEY `ospos_grants_ibfk_2` (`person_id`);

--
-- Indexes for table `ospos_inventory`
--
ALTER TABLE `ospos_inventory`
  ADD PRIMARY KEY (`trans_id`),
  ADD KEY `trans_items` (`trans_items`),
  ADD KEY `trans_user` (`trans_user`),
  ADD KEY `trans_location` (`trans_location`),
  ADD KEY `trans_date` (`trans_date`);

--
-- Indexes for table `ospos_items`
--
ALTER TABLE `ospos_items`
  ADD PRIMARY KEY (`item_id`),
  ADD KEY `item_number` (`item_number`),
  ADD KEY `supplier_id` (`supplier_id`);

--
-- Indexes for table `ospos_items_taxes`
--
ALTER TABLE `ospos_items_taxes`
  ADD PRIMARY KEY (`item_id`,`name`,`percent`);

--
-- Indexes for table `ospos_item_kits`
--
ALTER TABLE `ospos_item_kits`
  ADD PRIMARY KEY (`item_kit_id`),
  ADD KEY `item_kit_number` (`item_kit_number`);

--
-- Indexes for table `ospos_item_kit_items`
--
ALTER TABLE `ospos_item_kit_items`
  ADD PRIMARY KEY (`item_kit_id`,`item_id`,`quantity`),
  ADD KEY `ospos_item_kit_items_ibfk_2` (`item_id`);

--
-- Indexes for table `ospos_item_quantities`
--
ALTER TABLE `ospos_item_quantities`
  ADD PRIMARY KEY (`item_id`,`location_id`),
  ADD KEY `item_id` (`item_id`),
  ADD KEY `location_id` (`location_id`);

--
-- Indexes for table `ospos_modules`
--
ALTER TABLE `ospos_modules`
  ADD PRIMARY KEY (`module_id`),
  ADD UNIQUE KEY `desc_lang_key` (`desc_lang_key`),
  ADD UNIQUE KEY `name_lang_key` (`name_lang_key`);

--
-- Indexes for table `ospos_people`
--
ALTER TABLE `ospos_people`
  ADD PRIMARY KEY (`person_id`),
  ADD KEY `email` (`email`);

--
-- Indexes for table `ospos_permissions`
--
ALTER TABLE `ospos_permissions`
  ADD PRIMARY KEY (`permission_id`),
  ADD KEY `module_id` (`module_id`),
  ADD KEY `ospos_permissions_ibfk_2` (`location_id`);

--
-- Indexes for table `ospos_receivings`
--
ALTER TABLE `ospos_receivings`
  ADD PRIMARY KEY (`receiving_id`),
  ADD KEY `supplier_id` (`supplier_id`),
  ADD KEY `employee_id` (`employee_id`),
  ADD KEY `reference` (`reference`),
  ADD KEY `receiving_time` (`receiving_time`);

--
-- Indexes for table `ospos_receivings_items`
--
ALTER TABLE `ospos_receivings_items`
  ADD PRIMARY KEY (`receiving_id`,`item_id`,`line`),
  ADD KEY `item_id` (`item_id`);

--
-- Indexes for table `ospos_sales`
--
ALTER TABLE `ospos_sales`
  ADD PRIMARY KEY (`sale_id`),
  ADD UNIQUE KEY `invoice_number` (`invoice_number`),
  ADD KEY `customer_id` (`customer_id`),
  ADD KEY `employee_id` (`employee_id`),
  ADD KEY `sale_time` (`sale_time`),
  ADD KEY `dinner_table_id` (`dinner_table_id`);

--
-- Indexes for table `ospos_sales_items`
--
ALTER TABLE `ospos_sales_items`
  ADD PRIMARY KEY (`sale_id`,`item_id`,`line`),
  ADD KEY `sale_id` (`sale_id`),
  ADD KEY `item_id` (`item_id`),
  ADD KEY `item_location` (`item_location`);

--
-- Indexes for table `ospos_sales_items_taxes`
--
ALTER TABLE `ospos_sales_items_taxes`
  ADD PRIMARY KEY (`sale_id`,`item_id`,`line`,`name`,`percent`),
  ADD KEY `sale_id` (`sale_id`),
  ADD KEY `item_id` (`item_id`);

--
-- Indexes for table `ospos_sales_payments`
--
ALTER TABLE `ospos_sales_payments`
  ADD PRIMARY KEY (`payment_id`),
  ADD KEY `payment_sale` (`sale_id`,`payment_type`),
  ADD KEY `employee_id` (`employee_id`),
  ADD KEY `payment_time` (`payment_time`);

--
-- Indexes for table `ospos_sales_reward_points`
--
ALTER TABLE `ospos_sales_reward_points`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sale_id` (`sale_id`);

--
-- Indexes for table `ospos_sales_taxes`
--
ALTER TABLE `ospos_sales_taxes`
  ADD PRIMARY KEY (`sales_taxes_id`),
  ADD KEY `print_sequence` (`sale_id`,`print_sequence`,`tax_group`);

--
-- Indexes for table `ospos_sessions`
--
ALTER TABLE `ospos_sessions`
  ADD KEY `ci_sessions_timestamp` (`timestamp`);

--
-- Indexes for table `ospos_stock_locations`
--
ALTER TABLE `ospos_stock_locations`
  ADD PRIMARY KEY (`location_id`);

--
-- Indexes for table `ospos_suppliers`
--
ALTER TABLE `ospos_suppliers`
  ADD UNIQUE KEY `account_number` (`account_number`),
  ADD KEY `person_id` (`person_id`);

--
-- Indexes for table `ospos_tax_categories`
--
ALTER TABLE `ospos_tax_categories`
  ADD PRIMARY KEY (`tax_category_id`);

--
-- Indexes for table `ospos_tax_codes`
--
ALTER TABLE `ospos_tax_codes`
  ADD PRIMARY KEY (`tax_code_id`);

--
-- Indexes for table `ospos_tax_jurisdictions`
--
ALTER TABLE `ospos_tax_jurisdictions`
  ADD PRIMARY KEY (`jurisdiction_id`),
  ADD UNIQUE KEY `tax_jurisdictions_uq1` (`tax_group`);

--
-- Indexes for table `ospos_tax_rates`
--
ALTER TABLE `ospos_tax_rates`
  ADD PRIMARY KEY (`tax_rate_id`),
  ADD KEY `rate_tax_category_id` (`rate_tax_category_id`),
  ADD KEY `rate_tax_code_id` (`rate_tax_code_id`),
  ADD KEY `rate_jurisdiction_id` (`rate_jurisdiction_id`);

--
-- Indexes for table `ospos_time_attendances`
--
ALTER TABLE `ospos_time_attendances`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `ospos_attribute_definitions`
--
ALTER TABLE `ospos_attribute_definitions`
  MODIFY `definition_id` int(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ospos_attribute_values`
--
ALTER TABLE `ospos_attribute_values`
  MODIFY `attribute_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ospos_cash_up`
--
ALTER TABLE `ospos_cash_up`
  MODIFY `cashup_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `ospos_customers_packages`
--
ALTER TABLE `ospos_customers_packages`
  MODIFY `package_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `ospos_customers_points`
--
ALTER TABLE `ospos_customers_points`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ospos_dinner_tables`
--
ALTER TABLE `ospos_dinner_tables`
  MODIFY `dinner_table_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `ospos_expenses`
--
ALTER TABLE `ospos_expenses`
  MODIFY `expense_id` int(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ospos_expense_categories`
--
ALTER TABLE `ospos_expense_categories`
  MODIFY `expense_category_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `ospos_giftcards`
--
ALTER TABLE `ospos_giftcards`
  MODIFY `giftcard_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ospos_inventory`
--
ALTER TABLE `ospos_inventory`
  MODIFY `trans_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=479;

--
-- AUTO_INCREMENT for table `ospos_items`
--
ALTER TABLE `ospos_items`
  MODIFY `item_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=204;

--
-- AUTO_INCREMENT for table `ospos_item_kits`
--
ALTER TABLE `ospos_item_kits`
  MODIFY `item_kit_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ospos_people`
--
ALTER TABLE `ospos_people`
  MODIFY `person_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=87;

--
-- AUTO_INCREMENT for table `ospos_receivings`
--
ALTER TABLE `ospos_receivings`
  MODIFY `receiving_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `ospos_sales`
--
ALTER TABLE `ospos_sales`
  MODIFY `sale_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;

--
-- AUTO_INCREMENT for table `ospos_sales_payments`
--
ALTER TABLE `ospos_sales_payments`
  MODIFY `payment_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40;

--
-- AUTO_INCREMENT for table `ospos_sales_reward_points`
--
ALTER TABLE `ospos_sales_reward_points`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ospos_sales_taxes`
--
ALTER TABLE `ospos_sales_taxes`
  MODIFY `sales_taxes_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ospos_stock_locations`
--
ALTER TABLE `ospos_stock_locations`
  MODIFY `location_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `ospos_tax_categories`
--
ALTER TABLE `ospos_tax_categories`
  MODIFY `tax_category_id` int(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ospos_tax_codes`
--
ALTER TABLE `ospos_tax_codes`
  MODIFY `tax_code_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ospos_tax_jurisdictions`
--
ALTER TABLE `ospos_tax_jurisdictions`
  MODIFY `jurisdiction_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ospos_tax_rates`
--
ALTER TABLE `ospos_tax_rates`
  MODIFY `tax_rate_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ospos_time_attendances`
--
ALTER TABLE `ospos_time_attendances`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `ospos_attribute_definitions`
--
ALTER TABLE `ospos_attribute_definitions`
  ADD CONSTRAINT `fk_ospos_attribute_definitions_ibfk_1` FOREIGN KEY (`definition_fk`) REFERENCES `ospos_attribute_definitions` (`definition_id`);

--
-- Constraints for table `ospos_attribute_links`
--
ALTER TABLE `ospos_attribute_links`
  ADD CONSTRAINT `ospos_attribute_links_ibfk_1` FOREIGN KEY (`definition_id`) REFERENCES `ospos_attribute_definitions` (`definition_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `ospos_attribute_links_ibfk_2` FOREIGN KEY (`attribute_id`) REFERENCES `ospos_attribute_values` (`attribute_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `ospos_attribute_links_ibfk_3` FOREIGN KEY (`item_id`) REFERENCES `ospos_items` (`item_id`),
  ADD CONSTRAINT `ospos_attribute_links_ibfk_4` FOREIGN KEY (`receiving_id`) REFERENCES `ospos_receivings` (`receiving_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `ospos_attribute_links_ibfk_5` FOREIGN KEY (`sale_id`) REFERENCES `ospos_sales` (`sale_id`);

--
-- Constraints for table `ospos_cash_up`
--
ALTER TABLE `ospos_cash_up`
  ADD CONSTRAINT `ospos_cash_up_ibfk_1` FOREIGN KEY (`open_employee_id`) REFERENCES `ospos_employees` (`person_id`),
  ADD CONSTRAINT `ospos_cash_up_ibfk_2` FOREIGN KEY (`close_employee_id`) REFERENCES `ospos_employees` (`person_id`);

--
-- Constraints for table `ospos_customers`
--
ALTER TABLE `ospos_customers`
  ADD CONSTRAINT `ospos_customers_ibfk_1` FOREIGN KEY (`person_id`) REFERENCES `ospos_people` (`person_id`),
  ADD CONSTRAINT `ospos_customers_ibfk_2` FOREIGN KEY (`package_id`) REFERENCES `ospos_customers_packages` (`package_id`),
  ADD CONSTRAINT `ospos_customers_ibfk_3` FOREIGN KEY (`sales_tax_code_id`) REFERENCES `ospos_tax_codes` (`tax_code_id`);

--
-- Constraints for table `ospos_customers_points`
--
ALTER TABLE `ospos_customers_points`
  ADD CONSTRAINT `ospos_customers_points_ibfk_1` FOREIGN KEY (`person_id`) REFERENCES `ospos_customers` (`person_id`),
  ADD CONSTRAINT `ospos_customers_points_ibfk_2` FOREIGN KEY (`package_id`) REFERENCES `ospos_customers_packages` (`package_id`),
  ADD CONSTRAINT `ospos_customers_points_ibfk_3` FOREIGN KEY (`sale_id`) REFERENCES `ospos_sales` (`sale_id`);

--
-- Constraints for table `ospos_expenses`
--
ALTER TABLE `ospos_expenses`
  ADD CONSTRAINT `ospos_expenses_ibfk_1` FOREIGN KEY (`expense_category_id`) REFERENCES `ospos_expense_categories` (`expense_category_id`),
  ADD CONSTRAINT `ospos_expenses_ibfk_2` FOREIGN KEY (`employee_id`) REFERENCES `ospos_employees` (`person_id`),
  ADD CONSTRAINT `ospos_expenses_ibfk_3` FOREIGN KEY (`supplier_id`) REFERENCES `ospos_suppliers` (`person_id`);

--
-- Constraints for table `ospos_giftcards`
--
ALTER TABLE `ospos_giftcards`
  ADD CONSTRAINT `ospos_giftcards_ibfk_1` FOREIGN KEY (`person_id`) REFERENCES `ospos_people` (`person_id`);

--
-- Constraints for table `ospos_grants`
--
ALTER TABLE `ospos_grants`
  ADD CONSTRAINT `ospos_grants_ibfk_1` FOREIGN KEY (`permission_id`) REFERENCES `ospos_permissions` (`permission_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `ospos_grants_ibfk_2` FOREIGN KEY (`person_id`) REFERENCES `ospos_employees` (`person_id`) ON DELETE CASCADE;

--
-- Constraints for table `ospos_inventory`
--
ALTER TABLE `ospos_inventory`
  ADD CONSTRAINT `ospos_inventory_ibfk_1` FOREIGN KEY (`trans_items`) REFERENCES `ospos_items` (`item_id`),
  ADD CONSTRAINT `ospos_inventory_ibfk_2` FOREIGN KEY (`trans_user`) REFERENCES `ospos_employees` (`person_id`),
  ADD CONSTRAINT `ospos_inventory_ibfk_3` FOREIGN KEY (`trans_location`) REFERENCES `ospos_stock_locations` (`location_id`);

--
-- Constraints for table `ospos_items`
--
ALTER TABLE `ospos_items`
  ADD CONSTRAINT `ospos_items_ibfk_1` FOREIGN KEY (`supplier_id`) REFERENCES `ospos_suppliers` (`person_id`);

--
-- Constraints for table `ospos_items_taxes`
--
ALTER TABLE `ospos_items_taxes`
  ADD CONSTRAINT `ospos_items_taxes_ibfk_1` FOREIGN KEY (`item_id`) REFERENCES `ospos_items` (`item_id`) ON DELETE CASCADE;

--
-- Constraints for table `ospos_item_kit_items`
--
ALTER TABLE `ospos_item_kit_items`
  ADD CONSTRAINT `ospos_item_kit_items_ibfk_1` FOREIGN KEY (`item_kit_id`) REFERENCES `ospos_item_kits` (`item_kit_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `ospos_item_kit_items_ibfk_2` FOREIGN KEY (`item_id`) REFERENCES `ospos_items` (`item_id`) ON DELETE CASCADE;

--
-- Constraints for table `ospos_item_quantities`
--
ALTER TABLE `ospos_item_quantities`
  ADD CONSTRAINT `ospos_item_quantities_ibfk_1` FOREIGN KEY (`item_id`) REFERENCES `ospos_items` (`item_id`),
  ADD CONSTRAINT `ospos_item_quantities_ibfk_2` FOREIGN KEY (`location_id`) REFERENCES `ospos_stock_locations` (`location_id`);

--
-- Constraints for table `ospos_permissions`
--
ALTER TABLE `ospos_permissions`
  ADD CONSTRAINT `ospos_permissions_ibfk_1` FOREIGN KEY (`module_id`) REFERENCES `ospos_modules` (`module_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `ospos_permissions_ibfk_2` FOREIGN KEY (`location_id`) REFERENCES `ospos_stock_locations` (`location_id`) ON DELETE CASCADE;

--
-- Constraints for table `ospos_receivings`
--
ALTER TABLE `ospos_receivings`
  ADD CONSTRAINT `ospos_receivings_ibfk_1` FOREIGN KEY (`employee_id`) REFERENCES `ospos_employees` (`person_id`),
  ADD CONSTRAINT `ospos_receivings_ibfk_2` FOREIGN KEY (`supplier_id`) REFERENCES `ospos_suppliers` (`person_id`);

--
-- Constraints for table `ospos_receivings_items`
--
ALTER TABLE `ospos_receivings_items`
  ADD CONSTRAINT `ospos_receivings_items_ibfk_1` FOREIGN KEY (`item_id`) REFERENCES `ospos_items` (`item_id`),
  ADD CONSTRAINT `ospos_receivings_items_ibfk_2` FOREIGN KEY (`receiving_id`) REFERENCES `ospos_receivings` (`receiving_id`);

--
-- Constraints for table `ospos_sales`
--
ALTER TABLE `ospos_sales`
  ADD CONSTRAINT `ospos_sales_ibfk_1` FOREIGN KEY (`employee_id`) REFERENCES `ospos_employees` (`person_id`),
  ADD CONSTRAINT `ospos_sales_ibfk_2` FOREIGN KEY (`customer_id`) REFERENCES `ospos_customers` (`person_id`),
  ADD CONSTRAINT `ospos_sales_ibfk_3` FOREIGN KEY (`dinner_table_id`) REFERENCES `ospos_dinner_tables` (`dinner_table_id`);

--
-- Constraints for table `ospos_sales_items`
--
ALTER TABLE `ospos_sales_items`
  ADD CONSTRAINT `ospos_sales_items_ibfk_1` FOREIGN KEY (`item_id`) REFERENCES `ospos_items` (`item_id`),
  ADD CONSTRAINT `ospos_sales_items_ibfk_2` FOREIGN KEY (`sale_id`) REFERENCES `ospos_sales` (`sale_id`),
  ADD CONSTRAINT `ospos_sales_items_ibfk_3` FOREIGN KEY (`item_location`) REFERENCES `ospos_stock_locations` (`location_id`);

--
-- Constraints for table `ospos_sales_items_taxes`
--
ALTER TABLE `ospos_sales_items_taxes`
  ADD CONSTRAINT `ospos_sales_items_taxes_ibfk_1` FOREIGN KEY (`sale_id`) REFERENCES `ospos_sales_items` (`sale_id`),
  ADD CONSTRAINT `ospos_sales_items_taxes_ibfk_2` FOREIGN KEY (`item_id`) REFERENCES `ospos_items` (`item_id`);

--
-- Constraints for table `ospos_sales_payments`
--
ALTER TABLE `ospos_sales_payments`
  ADD CONSTRAINT `ospos_sales_payments_ibfk_1` FOREIGN KEY (`sale_id`) REFERENCES `ospos_sales` (`sale_id`),
  ADD CONSTRAINT `ospos_sales_payments_ibfk_2` FOREIGN KEY (`employee_id`) REFERENCES `ospos_employees` (`person_id`);

--
-- Constraints for table `ospos_sales_reward_points`
--
ALTER TABLE `ospos_sales_reward_points`
  ADD CONSTRAINT `ospos_sales_reward_points_ibfk_1` FOREIGN KEY (`sale_id`) REFERENCES `ospos_sales` (`sale_id`);

--
-- Constraints for table `ospos_suppliers`
--
ALTER TABLE `ospos_suppliers`
  ADD CONSTRAINT `ospos_suppliers_ibfk_1` FOREIGN KEY (`person_id`) REFERENCES `ospos_people` (`person_id`);

--
-- Constraints for table `ospos_tax_rates`
--
ALTER TABLE `ospos_tax_rates`
  ADD CONSTRAINT `ospos_tax_rates_ibfk_1` FOREIGN KEY (`rate_tax_category_id`) REFERENCES `ospos_tax_categories` (`tax_category_id`),
  ADD CONSTRAINT `ospos_tax_rates_ibfk_2` FOREIGN KEY (`rate_tax_code_id`) REFERENCES `ospos_tax_codes` (`tax_code_id`),
  ADD CONSTRAINT `ospos_tax_rates_ibfk_3` FOREIGN KEY (`rate_jurisdiction_id`) REFERENCES `ospos_tax_jurisdictions` (`jurisdiction_id`);
COMMIT;

