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

START TRANSACTION;



--
-- Database: `anugerah`
--

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

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `id` int(11) NOT NULL,
  `name` varchar(499) COLLATE utf8_unicode_ci NOT NULL,
  `created_user_id` int(11) NOT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_user_id` int(11) NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `status` int(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`id`, `name`, `created_user_id`, `created_datetime`, `updated_user_id`, `updated_datetime`, `status`) VALUES
(1, 'Umum', 1, '2016-09-11 19:15:34', 1, '2023-12-28 23:30:29', 1),
(3, 'Minuman', 1, '2016-09-11 19:15:52', 1, '2023-12-28 23:30:35', 0),
(4, 'Rokok', 1, '2016-09-11 19:30:02', 1, '2023-12-28 23:30:40', 0),
(5, 'Makanan', 1, '2016-09-11 19:31:08', 1, '2023-12-28 23:30:45', 0),
(6, 'Mie Instan', 1, '2016-09-11 19:31:12', 1, '2023-12-28 23:30:49', 0),
(7, 'Sayuran', 1, '2016-09-11 19:31:18', 1, '2023-12-28 23:30:54', 0),
(8, 'Bahan Masak', 1, '2016-09-11 19:31:27', 1, '2023-12-28 23:30:58', 0);

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

--
-- Table structure for table `ci_sessions`
--

CREATE TABLE `ci_sessions` (
  `id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `ip_address` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `timestamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `data` blob NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ci_sessions`
--

INSERT INTO `ci_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('0ncpg75g6n43acrc8n52ck3osku7bk13', '112.215.220.197', 1703824430, 0x5f5f63695f6c6173745f726567656e65726174657c693a313730333832343433303b),
('jamvtqd3ek2aqmnap70c5dqauebl67e1', '182.253.163.58', 1703814170, 0x5f5f63695f6c6173745f726567656e65726174657c693a313730333831343131393b73657373696f6e69647c733a333a22706f73223b757365725f69647c733a313a2231223b757365725f656d61696c7c733a32313a22616775737075727769746140676d61696c2e636f6d223b757365725f726f6c657c733a313a2231223b757365725f6f75746c65747c733a313a2230223b),
('hm4g7b5cq8eq2qfbnge115kk4bhaeai0', '112.215.220.197', 1703829197, 0x5f5f63695f6c6173745f726567656e65726174657c693a313730333832383933393b73657373696f6e69647c733a333a22706f73223b757365725f69647c733a313a2231223b757365725f656d61696c7c733a32313a22616775737075727769746140676d61696c2e636f6d223b757365725f726f6c657c733a313a2231223b757365725f6f75746c65747c733a313a2230223b),
('4r6pr9evqesbbodpt2e3gm94817lliek', '112.215.220.197', 1703829481, 0x5f5f63695f6c6173745f726567656e65726174657c693a313730333832393337313b73657373696f6e69647c733a333a22706f73223b757365725f69647c733a313a2231223b757365725f656d61696c7c733a32313a22616775737075727769746140676d61696c2e636f6d223b757365725f726f6c657c733a313a2231223b757365725f6f75746c65747c733a313a2230223b),
('8g2qe0rti798n48tqp55ipbkonr5uen0', '180.254.224.192', 1703832396, 0x5f5f63695f6c6173745f726567656e65726174657c693a313730333833323339353b),
('19u80qm1jrt0mia9qc8ti85oah8rh6g6', '180.254.224.192', 1703833043, 0x5f5f63695f6c6173745f726567656e65726174657c693a313730333833323937333b73657373696f6e69647c733a333a22706f73223b757365725f69647c733a313a2231223b757365725f656d61696c7c733a32313a22616775737075727769746140676d61696c2e636f6d223b757365725f726f6c657c733a313a2231223b757365725f6f75746c65747c733a313a2230223b),
('lmjcrblbmrv5fdv3ffq4td1cb2rormbo', '180.254.224.192', 1703835925, 0x5f5f63695f6c6173745f726567656e65726174657c693a313730333833333534353b73657373696f6e69647c733a333a22706f73223b757365725f69647c733a313a2231223b757365725f656d61696c7c733a32313a22616775737075727769746140676d61696c2e636f6d223b757365725f726f6c657c733a313a2231223b757365725f6f75746c65747c733a313a2230223b736974655f6c616e677c733a393a22696e646f6e65736961223b),
('7tbqceec03u7urtp4cjtae7jc4q4ed0u', '180.254.224.192', 1703836526, 0x5f5f63695f6c6173745f726567656e65726174657c693a313730333833363236393b73657373696f6e69647c733a333a22706f73223b757365725f69647c733a313a2231223b757365725f656d61696c7c733a32313a22616775737075727769746140676d61696c2e636f6d223b757365725f726f6c657c733a313a2231223b757365725f6f75746c65747c733a313a2230223b736974655f6c616e677c733a393a22696e646f6e65736961223b),
('hvu2ke20moakiapgtb7u5lfqvjgscop4', '180.254.224.192', 1703837611, 0x5f5f63695f6c6173745f726567656e65726174657c693a313730333833363636323b73657373696f6e69647c733a333a22706f73223b757365725f69647c733a313a2231223b757365725f656d61696c7c733a32313a22616775737075727769746140676d61696c2e636f6d223b757365725f726f6c657c733a313a2231223b757365725f6f75746c65747c733a313a2230223b736974655f6c616e677c733a393a22696e646f6e65736961223b),
('jsovn8867frmn9pv1jl2932ch5ohrk3s', '180.254.224.192', 1703837911, 0x5f5f63695f6c6173745f726567656e65726174657c693a313730333833373635323b73657373696f6e69647c733a333a22706f73223b757365725f69647c733a313a2231223b757365725f656d61696c7c733a32313a22616775737075727769746140676d61696c2e636f6d223b757365725f726f6c657c733a313a2231223b757365725f6f75746c65747c733a313a2230223b736974655f6c616e677c733a393a22696e646f6e65736961223b),
('61ekh8alm4153pagdrdj9ktf0uvpvkvc', '180.254.224.192', 1703838292, 0x5f5f63695f6c6173745f726567656e65726174657c693a313730333833373937373b73657373696f6e69647c733a333a22706f73223b757365725f69647c733a313a2231223b757365725f656d61696c7c733a32313a22616775737075727769746140676d61696c2e636f6d223b757365725f726f6c657c733a313a2231223b757365725f6f75746c65747c733a313a2230223b736974655f6c616e677c733a393a22696e646f6e65736961223b),
('r87c3s1jq7crsi6midv1gd55l6vhja2f', '180.254.224.192', 1703838297, 0x5f5f63695f6c6173745f726567656e65726174657c693a313730333833383239363b73657373696f6e69647c733a333a22706f73223b757365725f69647c733a313a2231223b757365725f656d61696c7c733a32313a22616775737075727769746140676d61696c2e636f6d223b757365725f726f6c657c733a313a2231223b757365725f6f75746c65747c733a313a2230223b736974655f6c616e677c733a393a22696e646f6e65736961223b),
('tvh2fohkigi84ifbunce1fihc2nkjo89', '180.254.224.192', 1703838797, 0x5f5f63695f6c6173745f726567656e65726174657c693a313730333833383630373b73657373696f6e69647c733a333a22706f73223b757365725f69647c733a313a2231223b757365725f656d61696c7c733a32313a22616775737075727769746140676d61696c2e636f6d223b757365725f726f6c657c733a313a2231223b757365725f6f75746c65747c733a313a2230223b736974655f6c616e677c733a393a22696e646f6e65736961223b);

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

--
-- Table structure for table `currency`
--

CREATE TABLE `currency` (
  `iso` char(3) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `name` varchar(200) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `currency`
--

INSERT INTO `currency` (`iso`, `name`) VALUES
('KRW', '(South) Korean Won'),
('AFA', 'Afghanistan Afghani'),
('ALL', 'Albanian Lek'),
('DZD', 'Algerian Dinar'),
('ADP', 'Andorran Peseta'),
('AOK', 'Angolan Kwanza'),
('ARS', 'Argentine Peso'),
('AMD', 'Armenian Dram'),
('AWG', 'Aruban Florin'),
('AUD', 'Australian Dollar'),
('BSD', 'Bahamian Dollar'),
('BHD', 'Bahraini Dinar'),
('BDT', 'Bangladeshi Taka'),
('BBD', 'Barbados Dollar'),
('BZD', 'Belize Dollar'),
('BMD', 'Bermudian Dollar'),
('BTN', 'Bhutan Ngultrum'),
('BOB', 'Bolivian Boliviano'),
('BWP', 'Botswanian Pula'),
('BRL', 'Brazilian Real'),
('GBP', 'British Pound'),
('BND', 'Brunei Dollar'),
('BGN', 'Bulgarian Lev'),
('BUK', 'Burma Kyat'),
('BIF', 'Burundi Franc'),
('CAD', 'Canadian Dollar'),
('CVE', 'Cape Verde Escudo'),
('KYD', 'Cayman Islands Dollar'),
('CLP', 'Chilean Peso'),
('CLF', 'Chilean Unidades de Fomento'),
('COP', 'Colombian Peso'),
('XOF', 'Communauté Financière Africaine BCEAO - Francs'),
('XAF', 'Communauté Financière Africaine BEAC, Francs'),
('KMF', 'Comoros Franc'),
('XPF', 'Comptoirs Français du Pacifique Francs'),
('CRC', 'Costa Rican Colon'),
('CUP', 'Cuban Peso'),
('CYP', 'Cyprus Pound'),
('CZK', 'Czech Republic Koruna'),
('DKK', 'Danish Krone'),
('YDD', 'Democratic Yemeni Dinar'),
('DOP', 'Dominican Peso'),
('XCD', 'East Caribbean Dollar'),
('TPE', 'East Timor Escudo'),
('ECS', 'Ecuador Sucre'),
('EGP', 'Egyptian Pound'),
('SVC', 'El Salvador Colon'),
('EEK', 'Estonian Kroon (EEK)'),
('ETB', 'Ethiopian Birr'),
('EUR', 'Euro'),
('FKP', 'Falkland Islands Pound'),
('FJD', 'Fiji Dollar'),
('GMD', 'Gambian Dalasi'),
('GHC', 'Ghanaian Cedi'),
('GIP', 'Gibraltar Pound'),
('XAU', 'Gold, Ounces'),
('GTQ', 'Guatemalan Quetzal'),
('GNF', 'Guinea Franc'),
('GWP', 'Guinea-Bissau Peso'),
('GYD', 'Guyanan Dollar'),
('HTG', 'Haitian Gourde'),
('HNL', 'Honduran Lempira'),
('HKD', 'Hong Kong Dollar'),
('HUF', 'Hungarian Forint'),
('INR', 'Indian Rupee'),
('IDR', 'Indonesian Rupiah'),
('XDR', 'International Monetary Fund (IMF) Special Drawing Rights'),
('IRR', 'Iranian Rial'),
('IQD', 'Iraqi Dinar'),
('IEP', 'Irish Punt'),
('ILS', 'Israeli Shekel'),
('JMD', 'Jamaican Dollar'),
('JPY', 'Japanese Yen'),
('JOD', 'Jordanian Dinar'),
('KHR', 'Kampuchean (Cambodian) Riel'),
('KES', 'Kenyan Schilling'),
('KWD', 'Kuwaiti Dinar'),
('LAK', 'Lao Kip'),
('LBP', 'Lebanese Pound'),
('LSL', 'Lesotho Loti'),
('LRD', 'Liberian Dollar'),
('LYD', 'Libyan Dinar'),
('MOP', 'Macau Pataca'),
('MGF', 'Malagasy Franc'),
('MWK', 'Malawi Kwacha'),
('MYR', 'Malaysian Ringgit'),
('MVR', 'Maldive Rufiyaa'),
('MTL', 'Maltese Lira'),
('MRO', 'Mauritanian Ouguiya'),
('MUR', 'Mauritius Rupee'),
('MXP', 'Mexican Peso'),
('MNT', 'Mongolian Tugrik'),
('MAD', 'Moroccan Dirham'),
('MZM', 'Mozambique Metical'),
('NAD', 'Namibian Dollar'),
('NPR', 'Nepalese Rupee'),
('ANG', 'Netherlands Antillian Guilder'),
('YUD', 'New Yugoslavia Dinar'),
('NZD', 'New Zealand Dollar'),
('NIO', 'Nicaraguan Cordoba'),
('NGN', 'Nigerian Naira'),
('KPW', 'North Korean Won'),
('NOK', 'Norwegian Kroner'),
('OMR', 'Omani Rial'),
('PKR', 'Pakistan Rupee'),
('XPD', 'Palladium Ounces'),
('PAB', 'Panamanian Balboa'),
('PGK', 'Papua New Guinea Kina'),
('PYG', 'Paraguay Guarani'),
('PEN', 'Peruvian Nuevo Sol'),
('PHP', 'Philippine Peso'),
('XPT', 'Platinum, Ounces'),
('PLN', 'Polish Zloty'),
('QAR', 'Qatari Rial'),
('RON', 'Romanian Leu'),
('RUB', 'Russian Ruble'),
('RWF', 'Rwanda Franc'),
('WST', 'Samoan Tala'),
('STD', 'Sao Tome and Principe Dobra'),
('SAR', 'Saudi Arabian Riyal'),
('SCR', 'Seychelles Rupee'),
('SLL', 'Sierra Leone Leone'),
('XAG', 'Silver, Ounces'),
('SGD', 'Singapore Dollar'),
('SKK', 'Slovak Koruna'),
('SBD', 'Solomon Islands Dollar'),
('SOS', 'Somali Schilling'),
('ZAR', 'South African Rand'),
('LKR', 'Sri Lanka Rupee'),
('SHP', 'St. Helena Pound'),
('SDP', 'Sudanese Pound'),
('SRG', 'Suriname Guilder'),
('SZL', 'Swaziland Lilangeni'),
('SEK', 'Swedish Krona'),
('CHF', 'Swiss Franc'),
('SYP', 'Syrian Potmd'),
('TWD', 'Taiwan Dollar'),
('TZS', 'Tanzanian Schilling'),
('THB', 'Thai Baht'),
('TOP', 'Tongan Paanga'),
('TTD', 'Trinidad and Tobago Dollar'),
('TND', 'Tunisian Dinar'),
('TRY', 'Turkish Lira'),
('UGX', 'Uganda Shilling'),
('AED', 'United Arab Emirates Dirham'),
('UYU', 'Uruguayan Peso'),
('USD', 'US Dollar'),
('VUV', 'Vanuatu Vatu'),
('VEF', 'Venezualan Bolivar'),
('VND', 'Vietnamese Dong'),
('YER', 'Yemeni Rial'),
('CNY', 'Yuan (Chinese) Renminbi'),
('ZRZ', 'Zaire Zaire'),
('ZMK', 'Zambian Kwacha'),
('ZWD', 'Zimbabwe Dollar');

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

--
-- Table structure for table `customers`
--

CREATE TABLE `customers` (
  `id` int(11) NOT NULL,
  `fullname` varchar(499) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(499) COLLATE utf8_unicode_ci NOT NULL,
  `mobile` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_user_id` int(11) NOT NULL,
  `created_datetime` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `customers`
--

INSERT INTO `customers` (`id`, `fullname`, `email`, `mobile`, `created_user_id`, `created_datetime`) VALUES
(1, 'Umum', '', '', 1, '2016-10-18 00:00:00');

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

--
-- Table structure for table `expenses`
--

CREATE TABLE `expenses` (
  `id` int(11) NOT NULL,
  `expenses_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `expense_category` int(11) NOT NULL,
  `outlet_id` int(11) NOT NULL,
  `outlet_name` varchar(4999) COLLATE utf8_unicode_ci NOT NULL,
  `date` date NOT NULL,
  `amount` double(11,2) NOT NULL,
  `reason` longtext COLLATE utf8_unicode_ci NOT NULL,
  `file_name` varchar(499) COLLATE utf8_unicode_ci NOT NULL,
  `created_user_id` int(11) NOT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_user_id` int(11) NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `status` int(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `expenses`
--

INSERT INTO `expenses` (`id`, `expenses_number`, `expense_category`, `outlet_id`, `outlet_name`, `date`, `amount`, `reason`, `file_name`, `created_user_id`, `created_datetime`, `updated_user_id`, `updated_datetime`, `status`) VALUES
(2, '01', 1, 6, '', '2018-10-01', 1.00, 'Gajih September', '1540122042.png', 1, '2018-10-21 18:40:11', 1, '2018-10-21 18:40:42', 1);

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

--
-- Table structure for table `expense_categories`
--

CREATE TABLE `expense_categories` (
  `id` int(11) NOT NULL,
  `name` varchar(499) COLLATE utf8_unicode_ci NOT NULL,
  `created_user_id` int(11) NOT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_user_id` int(11) NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `status` int(11) NOT NULL COMMENT '0: Inactive, 1: Active'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `expense_categories`
--

INSERT INTO `expense_categories` (`id`, `name`, `created_user_id`, `created_datetime`, `updated_user_id`, `updated_datetime`, `status`) VALUES
(1, 'Gaji', 1, '2018-10-19 00:14:05', 0, '0000-00-00 00:00:00', 1);

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

--
-- Table structure for table `gift_card`
--

CREATE TABLE `gift_card` (
  `id` int(11) NOT NULL,
  `card_number` varchar(90) COLLATE utf8_unicode_ci NOT NULL,
  `value` double(11,2) NOT NULL,
  `expiry_date` date NOT NULL,
  `created_user_id` int(11) NOT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_user_id` int(11) NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `status` int(1) NOT NULL COMMENT '0: haven''t use, 1: used'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `gift_card`
--

INSERT INTO `gift_card` (`id`, `card_number`, `value`, `expiry_date`, `created_user_id`, `created_datetime`, `updated_user_id`, `updated_datetime`, `status`) VALUES
(1, '7105 7512 7506 0228', 50000.00, '2018-10-31', 1, '2018-10-18 23:19:37', 0, '0000-00-00 00:00:00', 0),
(2, '4591 5434 6057 6509', 100000.00, '2018-10-30', 1, '2018-10-18 23:22:39', 0, '0000-00-00 00:00:00', 0),
(3, '1162 3298 5667 8690', 10000.00, '2018-10-10', 1, '2018-10-19 15:50:42', 0, '0000-00-00 00:00:00', 0);

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

--
-- Table structure for table `inventory`
--

CREATE TABLE `inventory` (
  `id` int(11) NOT NULL,
  `product_code` varchar(499) COLLATE utf8_unicode_ci NOT NULL,
  `outlet_id` int(11) NOT NULL,
  `qty` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `inventory`
--

INSERT INTO `inventory` (`id`, `product_code`, `outlet_id`, `qty`) VALUES
(1, 'idm007', 3, 150),
(2, 'idm006', 3, 150),
(3, 'idm005', 3, 50),
(4, 'idm004', 3, 30),
(5, 'idm003', 3, 49),
(6, 'idm002', 3, 28),
(7, 'idm001', 3, 27),
(8, 'mnm010', 3, 100),
(9, 'mnm009', 3, 100),
(10, 'mnm008', 3, 100),
(11, 'mnm007', 3, 99),
(12, 'mnm006', 3, 94),
(13, 'mnm004', 3, 99),
(14, 'mnm003', 3, 99),
(15, 'mnm002', 3, 97),
(16, 'bhm003', 3, 1),
(17, 'bhm002', 6, 0),
(18, 'bhm001', 6, 0),
(19, 'dtg004', 6, 0),
(20, 'dtg003', 6, 50),
(21, 'dtg002', 6, 50),
(22, 'dtg001', 6, 50),
(23, 'mnm010', 6, 50),
(24, 'mnm009', 6, 50),
(25, 'mnm008', 6, 50),
(26, 'mnm007', 6, 60),
(27, 'mnm006', 6, 50),
(28, 'mnm005', 6, 50),
(29, 'mnm004', 6, 50),
(30, 'mnm003', 6, 50),
(31, 'mnm002', 6, 50),
(32, 'mnm001', 6, 50),
(33, 'mk008', 6, 50),
(34, 'mkn007', 6, 49),
(35, 'mkn006', 6, 49),
(36, 'mkn005', 6, 50),
(37, 'mkn004', 6, 50),
(38, 'mkn003', 6, 50),
(39, 'mkn002', 6, 50),
(40, 'mkn001', 6, 50),
(41, 'idm007', 6, 50),
(42, 'idm006', 6, 48),
(43, 'idm005', 6, 49),
(44, 'idm004', 6, 49),
(45, 'idm003', 6, 49),
(46, 'idm002', 6, 49),
(47, 'idm001', 6, 49),
(48, 'bhm002', 3, 1),
(49, 'bhm001', 3, 1),
(50, 'dtg004', 3, 1);

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

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `customer_name` varchar(499) COLLATE utf8_unicode_ci NOT NULL,
  `customer_email` varchar(499) COLLATE utf8_unicode_ci NOT NULL,
  `customer_mobile` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ordered_datetime` datetime NOT NULL,
  `outlet_id` int(11) NOT NULL,
  `outlet_name` varchar(499) COLLATE utf8_unicode_ci NOT NULL,
  `outlet_address` longtext COLLATE utf8_unicode_ci NOT NULL,
  `outlet_contact` varchar(499) COLLATE utf8_unicode_ci NOT NULL,
  `outlet_receipt_footer` longtext COLLATE utf8_unicode_ci NOT NULL,
  `gift_card` varchar(90) COLLATE utf8_unicode_ci NOT NULL,
  `subtotal` double(11,2) NOT NULL,
  `discount_total` double(11,2) NOT NULL,
  `discount_percentage` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `tax` double(11,2) NOT NULL,
  `grandtotal` double(11,2) NOT NULL,
  `total_items` int(11) NOT NULL,
  `payment_method` int(11) NOT NULL,
  `payment_method_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cheque_number` varchar(499) COLLATE utf8_unicode_ci NOT NULL,
  `paid_amt` double(11,2) NOT NULL,
  `return_change` double(11,2) NOT NULL,
  `created_user_id` int(11) NOT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_user_id` int(11) NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `vt_status` int(11) NOT NULL COMMENT '0: Debit Payment, 1: Completed',
  `status` int(11) NOT NULL COMMENT '1: Sales, 2: Return',
  `refund_status` int(11) NOT NULL COMMENT '1: Full Refund, 2: Partial Refund',
  `remark` longtext COLLATE utf8_unicode_ci NOT NULL,
  `card_number` varchar(499) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` (`id`, `customer_id`, `customer_name`, `customer_email`, `customer_mobile`, `ordered_datetime`, `outlet_id`, `outlet_name`, `outlet_address`, `outlet_contact`, `outlet_receipt_footer`, `gift_card`, `subtotal`, `discount_total`, `discount_percentage`, `tax`, `grandtotal`, `total_items`, `payment_method`, `payment_method_name`, `cheque_number`, `paid_amt`, `return_change`, `created_user_id`, `created_datetime`, `updated_user_id`, `updated_datetime`, `vt_status`, `status`, `refund_status`, `remark`, `card_number`) VALUES
(1, 1, 'Walk In Customer', '', '', '2018-10-18 23:23:12', 3, 'Suka Mart', 'Sukabumi Mall Lt.3', '089529303412', '<p>Thank you for Shopping with Us!</p>', '', 2500.00, 0.00, '', 125.00, 2625.00, 1, 4, 'Master Card', '', 2625.00, 0.00, 1, '2018-10-18 23:23:12', 1, '2018-10-18 23:35:20', 1, 1, 0, '', '5522479780791129'),
(2, 1, 'Walk In Customer', '', '', '2018-10-18 23:43:02', 3, 'Suka Mart', 'Sukabumi Mall Lt.3', '089529303412', '<p>Thank you for Shopping with Us!</p>', '', 150000.00, 0.00, '', 7500.00, 157500.00, 60, 1, 'Cash', '', 157500.00, 0.00, 1, '2018-10-18 23:43:02', 0, '0000-00-00 00:00:00', 1, 1, 0, '', ''),
(3, 1, 'Walk In Customer', '', '', '2018-10-19 00:29:07', 3, 'Suka Mart', 'Sukabumi Mall Lt.3', '089529303412', '<p>Thank you for Shopping with Us!</p>', '', 0.00, 0.00, '', -131.25, -2756.25, 1, 1, 'Cash', '', 0.00, 0.00, 1, '2018-10-19 00:29:07', 0, '0000-00-00 00:00:00', 1, 2, 1, '', ''),
(4, 1, 'Walk In Customer', '', '', '2018-10-19 01:28:28', 3, 'Suka Mart', 'Sukabumi Mall Lt.3', '089529303412', '<p>Thank you for Shopping with Us!</p>', '', 73600.00, 0.00, '', 3680.00, 77280.00, 9, 1, 'Cash', '', 77280.00, 0.00, 1, '2018-10-19 01:28:28', 0, '0000-00-00 00:00:00', 1, 1, 0, '', ''),
(5, 1, 'Walk In Customer', '', '', '2018-10-19 01:28:54', 3, 'Suka Mart', 'Sukabumi Mall Lt.3', '089529303412', '<p>Thank you for Shopping with Us!</p>', '', 10500.00, 0.00, '', 525.00, 11025.00, 3, 1, 'Cash', '', 12000.00, 975.00, 1, '2018-10-19 01:28:54', 0, '0000-00-00 00:00:00', 1, 1, 0, '', ''),
(6, 1, 'Walk In Customer', '', '', '2018-10-19 16:20:57', 3, 'Suka Mart', 'Sukabumi Mall Lt.3', '089529303412', '<p>Thank you for Shopping with Us!</p>', '', 2500.00, 0.00, '', 125.00, 2625.00, 1, 1, 'Cash', '', 2625.00, 0.00, 1, '2018-10-19 16:20:57', 0, '0000-00-00 00:00:00', 1, 1, 0, '', ''),
(7, 1, 'Walk In Customer', '', '', '2018-10-21 16:55:30', 6, 'Suka Mall', 'Sukabumi Mall', '080123456789', '<p>Terimakasih atas kunjungan anda</p>', '', 12500.00, 0.00, '', 625.00, 13125.00, 5, 1, 'Cash', '', 14000.00, 875.00, 15, '2018-10-21 16:55:30', 0, '0000-00-00 00:00:00', 1, 1, 0, '', ''),
(8, 1, 'Walk In Customer', '', '', '2018-10-21 16:59:50', 6, 'Suka Mall', 'Sukabumi Mall', '080123456789', '<p>Terimakasih atas kunjungan anda</p>', '', 18000.00, 0.00, '', 900.00, 18900.00, 4, 1, 'Cash', '', 19000.00, 100.00, 15, '2018-10-21 16:59:50', 0, '0000-00-00 00:00:00', 1, 1, 0, '', ''),
(9, 1, 'Walk In Customer', '', '', '2018-10-21 17:05:57', 3, 'Suka Mart', 'Jl, Samsi, Ciaul, Sukabumi', '089529303412', '<p>Terimakasih sudah berbelanja</p>', '', 32000.00, 0.00, '', 1600.00, 33600.00, 5, 1, 'Cash', '', 34000.00, 400.00, 1, '2018-10-21 17:05:57', 0, '0000-00-00 00:00:00', 1, 1, 0, '', '');

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

--
-- Table structure for table `order_items`
--

CREATE TABLE `order_items` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `product_code` varchar(499) COLLATE utf8_unicode_ci NOT NULL,
  `product_name` varchar(499) COLLATE utf8_unicode_ci NOT NULL,
  `product_category` int(11) NOT NULL,
  `cost` double(11,2) NOT NULL,
  `price` double(11,2) NOT NULL,
  `qty` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `order_items`
--

INSERT INTO `order_items` (`id`, `order_id`, `product_code`, `product_name`, `product_category`, `cost`, `price`, `qty`) VALUES
(1, 1, 'idm001', 'Indomie Ayam Bawang', 6, 2150.00, 2500.00, 1),
(2, 2, 'idm002', 'Indomie Goreng', 6, 2150.00, 2500.00, 20),
(3, 2, 'idm001', 'Indomie Ayam Bawang', 6, 2150.00, 2500.00, 20),
(4, 2, 'idm004', 'Indomie Empal Gentong', 6, 2150.00, 2500.00, 20),
(5, 4, 'mnm006', 'Club Air Mineral Galon', 3, 10500.00, 12500.00, 5),
(6, 4, 'mnm002', 'Cafela Expresso 200 ml', 3, 2650.00, 3200.00, 3),
(7, 4, 'mnm003', 'Calpico Mini Rasa Anggur Blueberry 70 ml', 3, 1125.00, 1500.00, 1),
(8, 5, 'idm001', 'Indomie Ayam Bawang', 6, 2150.00, 2500.00, 2),
(9, 5, 'mnm004', 'Calpico Frezz Original 350 ml', 3, 5150.00, 5500.00, 1),
(10, 6, 'idm002', 'Indomie Goreng', 6, 2150.00, 2500.00, 1),
(11, 7, 'idm001', 'Indomie Ayam Bawang', 6, 2150.00, 2500.00, 1),
(12, 7, 'idm002', 'Indomie Goreng', 6, 2150.00, 2500.00, 1),
(13, 7, 'idm003', 'Indomie Soto Banjar', 6, 2150.00, 2500.00, 1),
(14, 7, 'idm004', 'Indomie Empal Gentong', 6, 2150.00, 2500.00, 1),
(15, 7, 'idm006', 'Indomie Ayam Panggang', 6, 2150.00, 2500.00, 1),
(16, 8, 'idm005', 'Indomie Ayam Spesial', 6, 2150.00, 2500.00, 1),
(17, 8, 'idm006', 'Indomie Ayam Panggang', 6, 2150.00, 2500.00, 1),
(18, 8, 'mkn007', 'Chitato Kepiting Goreng Telur Asin 55 gr', 5, 6000.00, 6500.00, 1),
(19, 8, 'mkn006', 'Chitato Foodie Rasa Sapi Panggang Madu 55 gr', 5, 6000.00, 6500.00, 1),
(20, 9, 'idm001', 'Indomie Ayam Bawang', 6, 2150.00, 2500.00, 1),
(21, 9, 'idm002', 'Indomie Goreng', 6, 2150.00, 2500.00, 1),
(22, 9, 'idm003', 'Indomie Soto Banjar', 6, 2150.00, 2500.00, 1),
(23, 9, 'mnm006', 'Club Air Mineral Galon', 3, 10500.00, 12500.00, 1),
(24, 9, 'mnm007', 'Freiss Squash Rasa Jeruk 520 ml', 3, 10000.00, 12000.00, 1);

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

--
-- Table structure for table `outlets`
--

CREATE TABLE `outlets` (
  `id` int(11) NOT NULL,
  `name` varchar(499) COLLATE utf8_unicode_ci NOT NULL,
  `address` longtext COLLATE utf8_unicode_ci NOT NULL,
  `contact_number` varchar(499) COLLATE utf8_unicode_ci NOT NULL,
  `receipt_header` longtext COLLATE utf8_unicode_ci NOT NULL,
  `receipt_footer` longtext COLLATE utf8_unicode_ci NOT NULL,
  `created_user_id` int(11) NOT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_user_id` int(11) NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `status` int(11) NOT NULL COMMENT '1: Active, 0: Inactive'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `outlets`
--

INSERT INTO `outlets` (`id`, `name`, `address`, `contact_number`, `receipt_header`, `receipt_footer`, `created_user_id`, `created_datetime`, `updated_user_id`, `updated_datetime`, `status`) VALUES
(3, 'Anugerah', 'Jalan Gunung Tangkuban Perahu No 35X Padangsambian', '081238346238', '', '<p>Terimakasih sudah berbelanja</p>', 1, '2016-09-11 19:25:52', 1, '2023-12-26 21:39:32', 1),
(6, 'Toko Agus', 'Pasar Kreneng Lantai 2', '081999983716', '', '<p>Terimakasih atas kunjungan anda</p>', 1, '2018-10-21 16:28:05', 1, '2023-12-26 22:40:58', 1);

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

--
-- Table structure for table `payment_method`
--

CREATE TABLE `payment_method` (
  `id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_user_id` int(11) NOT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_user_id` int(11) NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `status` int(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `payment_method`
--

INSERT INTO `payment_method` (`id`, `name`, `created_user_id`, `created_datetime`, `updated_user_id`, `updated_datetime`, `status`) VALUES
(1, 'Cash', 1, '2016-09-25 01:43:41', 0, '0000-00-00 00:00:00', 1),
(3, 'VISA', 1, '2016-09-25 01:43:50', 1, '2023-12-26 21:35:11', 0),
(4, 'Master Card', 1, '2016-09-25 01:43:58', 1, '2023-12-26 21:35:05', 0),
(6, 'Debit', 1, '2016-09-25 01:44:05', 1, '2023-12-26 21:34:59', 0),
(7, 'Gift Card', 1, '2016-10-16 01:23:05', 1, '2023-12-26 21:34:53', 0);

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

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` int(11) NOT NULL,
  `code` varchar(499) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(499) COLLATE utf8_unicode_ci NOT NULL,
  `category` int(11) NOT NULL,
  `purchase_price` double(11,2) NOT NULL,
  `retail_price` double(11,2) NOT NULL,
  `thumbnail` varchar(499) COLLATE utf8_unicode_ci NOT NULL,
  `created_user_id` int(11) NOT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_user_id` int(11) NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`id`, `code`, `name`, `category`, `purchase_price`, `retail_price`, `thumbnail`, `created_user_id`, `created_datetime`, `updated_user_id`, `updated_datetime`, `status`) VALUES
(11, 'idm001', 'Indomie Ayam Bawang', 1, 2150.00, 2500.00, 'idm001.jpg', 1, '2018-10-18 22:39:07', 1, '2023-12-28 23:36:09', 1),
(12, 'idm002', 'Indomie Goreng', 1, 2150.00, 2500.00, 'idm002.jpg', 1, '2018-10-18 22:39:33', 1, '2023-12-28 23:36:02', 1),
(13, 'idm003', 'Indomie Soto Banjar', 1, 2150.00, 2500.00, 'idm003.jpg', 1, '2018-10-18 22:40:05', 1, '2023-12-28 23:35:55', 1),
(14, 'idm004', 'Indomie Empal Gentong', 1, 2150.00, 2500.00, 'idm004.jpg', 1, '2018-10-18 22:40:31', 1, '2023-12-28 23:35:47', 1),
(15, 'idm005', 'Indomie Ayam Spesial', 1, 2150.00, 2500.00, 'idm005.jpg', 1, '2018-10-18 22:40:53', 1, '2023-12-28 23:35:40', 1),
(16, 'idm006', 'Indomie Ayam Panggang', 1, 2150.00, 2500.00, 'idm006.jpg', 1, '2018-10-18 22:41:26', 1, '2023-12-28 23:35:30', 1),
(17, 'idm007', 'Indomie Goreng Spesial', 1, 2150.00, 2500.00, 'idm007.jpg', 1, '2018-10-18 22:41:54', 1, '2023-12-28 23:35:20', 1),
(18, 'mkn001', 'Pop Mie Mini Soto Regular', 1, 2250.00, 2500.00, 'mkn001.jpg', 1, '2018-10-18 22:47:22', 1, '2023-12-28 23:35:12', 1),
(19, 'mkn002', 'Buburia Ayam Kampung Cup 70 gr', 1, 4100.00, 4500.00, 'mkn002.jpg', 1, '2018-10-18 22:47:53', 1, '2023-12-28 23:35:05', 1),
(20, 'mkn003', 'Cheetos Net Rasa BBQ 10 gr', 1, 850.00, 1000.00, 'mkn003.jpg', 1, '2018-10-18 22:48:57', 1, '2023-12-28 23:34:57', 1),
(21, 'mkn004', 'Cheetos Net Rasa Rumput Laut 30 gr + 15%', 1, 1550.00, 2000.00, 'mkn004.jpg', 1, '2018-10-18 22:49:42', 1, '2023-12-28 23:34:49', 1),
(22, 'mkn005', 'Chiki Ball Rasa Ayam Renceng 10 gr', 1, 800.00, 1000.00, 'mkn005.jpg', 1, '2018-10-18 22:50:17', 1, '2023-12-28 23:33:44', 1),
(23, 'mkn006', 'Chitato Foodie Rasa Sapi Panggang Madu 55 gr', 1, 6000.00, 6500.00, 'mkn006.jpg', 1, '2018-10-18 22:50:41', 1, '2023-12-28 23:33:27', 1),
(24, 'mkn007', 'Chitato Kepiting Goreng Telur Asin 55 gr', 1, 6000.00, 6500.00, 'mkn007.jpg', 1, '2018-10-18 22:51:22', 1, '2023-12-28 23:33:20', 1),
(25, 'mk008', 'Chitato Ketan Mangga 55 gr', 1, 6000.00, 6500.00, 'mk008.jpg', 1, '2018-10-18 22:51:49', 1, '2023-12-28 23:33:13', 1),
(26, 'mnm001', 'Indomilk Susu Bubuk Cokelat 800 gr', 1, 61250.00, 65000.00, 'mnm001.jpg', 1, '2018-10-18 22:54:10', 1, '2023-12-28 23:33:06', 1),
(27, 'mnm002', 'Cafela Expresso 200 ml', 1, 2650.00, 3200.00, 'mnm002.jpg', 1, '2018-10-18 22:54:44', 1, '2023-12-28 23:33:00', 1),
(28, 'mnm003', 'Calpico Mini Rasa Anggur Blueberry 70 ml', 1, 1125.00, 1500.00, 'mnm003.jpg', 1, '2018-10-18 22:55:23', 1, '2023-12-28 23:32:53', 1),
(29, 'mnm004', 'Calpico Frezz Original 350 ml', 1, 5150.00, 5500.00, 'mnm004.jpg', 1, '2018-10-18 22:56:02', 1, '2023-12-28 23:32:46', 1),
(30, 'mnm005', 'Cap Enaak Krimer Kental Manis Cokelat Sachet 37 gr', 1, 800.00, 1000.00, 'mnm005.jpg', 1, '2018-10-18 22:56:24', 1, '2023-12-28 23:32:40', 1),
(31, 'mnm006', 'Club Air Mineral Galon', 1, 10500.00, 12500.00, 'mnm006.jpg', 1, '2018-10-18 22:56:52', 1, '2023-12-28 23:32:33', 1),
(32, 'mnm007', 'Freiss Squash Rasa Jeruk 520 ml', 1, 10000.00, 12000.00, 'mnm007.jpg', 1, '2018-10-18 22:57:30', 1, '2023-12-28 23:32:27', 1),
(33, 'mnm008', 'Fruitamin Rasa Stroberi 180 ml', 1, 825.00, 1000.00, 'mnm008.jpg', 1, '2018-10-18 22:57:59', 1, '2023-12-28 23:32:21', 1),
(34, 'mnm009', 'Milkuat Freshy Rasa Jeruk Mandarin 130 ml', 1, 220.00, 2500.00, 'mnm009.jpg', 1, '2018-10-18 22:58:20', 1, '2023-12-28 23:32:10', 1),
(35, 'mnm010', 'Pepsi Blue Botol 1750 ml', 1, 9800.00, 11000.00, 'mnm010.jpg', 1, '2018-10-18 22:58:39', 1, '2023-12-28 23:32:03', 1),
(36, 'dtg001', 'Bukrim Gel Jeruk Nipis 750 gr', 1, 9400.00, 10000.00, 'dtg001.jpg', 1, '2018-10-18 23:03:01', 0, '0000-00-00 00:00:00', 1),
(37, 'dtg002', 'Bukrim Superklin Detergen Bubuk 750 gr', 1, 8500.00, 9000.00, 'dtg002.jpg', 1, '2018-10-18 23:03:36', 0, '0000-00-00 00:00:00', 1),
(38, 'dtg003', 'Total Lemon Softener Rejuvinasi Detergen Bubuk 700 gr', 1, 12500.00, 13500.00, 'dtg003.jpg', 1, '2018-10-18 23:03:59', 0, '0000-00-00 00:00:00', 1),
(39, 'dtg004', 'Total Violet Softener Rejuvinasi Detergen Bubuk 700 gr', 1, 11000.00, 12000.00, 'dtg004.jpg', 1, '2018-10-18 23:04:24', 0, '0000-00-00 00:00:00', 1),
(40, 'bhm001', 'Orchid Butter Salted Margarin 340 gr', 1, 1250.00, 1550.00, 'bhm001.jpg', 1, '2018-10-18 23:12:56', 1, '2023-12-28 23:31:53', 1),
(41, 'bhm002', 'Amanda Margarin Dapur 200 gr', 1, 3345.00, 3500.00, 'bhm002.jpg', 1, '2018-10-18 23:13:37', 1, '2023-12-28 23:31:46', 1),
(42, 'bhm003', 'Bimoli Minyak Goreng 1 Liter Pouch', 1, 13500.00, 15500.00, 'bhm003.jpg', 1, '2018-10-18 23:17:14', 1, '2023-12-28 23:31:31', 1);

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

--
-- Table structure for table `purchase_order`
--

CREATE TABLE `purchase_order` (
  `id` int(11) NOT NULL,
  `po_number` varchar(499) COLLATE utf8_unicode_ci NOT NULL,
  `discount_amount` double(11,2) NOT NULL,
  `discount_percentage` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `subTotal` double(11,2) NOT NULL,
  `tax` double(11,2) NOT NULL,
  `grandTotal` double(11,2) NOT NULL,
  `supplier_id` int(11) NOT NULL,
  `supplier_tax` double(11,2) NOT NULL,
  `supplier_name` varchar(499) COLLATE utf8_unicode_ci NOT NULL,
  `supplier_email` varchar(499) COLLATE utf8_unicode_ci NOT NULL,
  `supplier_address` longtext COLLATE utf8_unicode_ci NOT NULL,
  `supplier_tel` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `supplier_fax` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `outlet_id` int(11) NOT NULL,
  `outlet_name` varchar(499) COLLATE utf8_unicode_ci NOT NULL,
  `outlet_address` longtext COLLATE utf8_unicode_ci NOT NULL,
  `outlet_contact` varchar(499) COLLATE utf8_unicode_ci NOT NULL,
  `po_date` date NOT NULL,
  `attachment_file` varchar(499) COLLATE utf8_unicode_ci NOT NULL,
  `note` longtext COLLATE utf8_unicode_ci NOT NULL,
  `created_user_id` int(11) NOT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_user_id` int(11) NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `received_user_id` int(11) NOT NULL,
  `received_datetime` datetime NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `purchase_order`
--

INSERT INTO `purchase_order` (`id`, `po_number`, `discount_amount`, `discount_percentage`, `subTotal`, `tax`, `grandTotal`, `supplier_id`, `supplier_tax`, `supplier_name`, `supplier_email`, `supplier_address`, `supplier_tel`, `supplier_fax`, `outlet_id`, `outlet_name`, `outlet_address`, `outlet_contact`, `po_date`, `attachment_file`, `note`, `created_user_id`, `created_datetime`, `updated_user_id`, `updated_datetime`, `received_user_id`, `received_datetime`, `status`) VALUES
(1, '123', 0.00, '', 430000.00, 0.00, 430000.00, 4, 0.00, 'Suplier Indomie', '', 'Sukabumi', '080000000000', '', 3, 'Suka Mart', 'Sukabumi Mall Lt.3', '089529303412', '2018-10-19', '', '', 1, '2018-10-19 00:36:48', 1, '2018-10-19 00:37:11', 1, '2018-10-19 00:41:26', 3),
(2, '2', 0.00, '', 4027000.00, 0.00, 4027000.00, 5, 0.00, 'PT Minuman', '', 'Sukabumi', '080000000123', '', 3, 'Suka Mart', 'Sukabumi Mall Lt.3', '089529303412', '2018-10-19', '', '', 1, '2018-10-19 01:24:56', 1, '2018-10-19 01:25:07', 1, '2018-10-19 01:27:00', 3);

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

--
-- Table structure for table `purchase_order_items`
--

CREATE TABLE `purchase_order_items` (
  `id` int(11) NOT NULL,
  `po_id` int(11) NOT NULL,
  `product_code` varchar(499) COLLATE utf8_unicode_ci NOT NULL,
  `ordered_qty` int(11) NOT NULL,
  `received_qty` int(11) NOT NULL,
  `cost` double(11,2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `purchase_order_items`
--

INSERT INTO `purchase_order_items` (`id`, `po_id`, `product_code`, `ordered_qty`, `received_qty`, `cost`) VALUES
(1, 1, 'idm006', 100, 100, 2150.00),
(2, 1, 'idm007', 100, 100, 2150.00),
(3, 2, 'mnm010', 100, 100, 9800.00),
(4, 2, 'mnm009', 100, 100, 220.00),
(5, 2, 'mnm008', 100, 100, 825.00),
(6, 2, 'mnm007', 100, 100, 10000.00),
(7, 2, 'mnm006', 100, 100, 10500.00),
(8, 2, 'mnm004', 100, 100, 5150.00),
(9, 2, 'mnm003', 100, 100, 1125.00),
(10, 2, 'mnm002', 100, 100, 2650.00);

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

--
-- Table structure for table `purchase_order_status`
--

CREATE TABLE `purchase_order_status` (
  `id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_user_id` int(11) NOT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_user_id` int(11) NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `purchase_order_status`
--

INSERT INTO `purchase_order_status` (`id`, `name`, `created_user_id`, `created_datetime`, `updated_user_id`, `updated_datetime`, `status`) VALUES
(1, 'Created', 1, '2016-09-10 00:00:00', 0, '0000-00-00 00:00:00', 1),
(2, 'Sent To Supplier', 1, '2016-09-10 00:00:00', 0, '0000-00-00 00:00:00', 1),
(3, 'Received From Supplier', 1, '2016-09-10 00:00:00', 0, '0000-00-00 00:00:00', 1);

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

--
-- Table structure for table `return_items`
--

CREATE TABLE `return_items` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `product_code` varchar(499) COLLATE utf8_unicode_ci NOT NULL,
  `price` double(11,2) NOT NULL,
  `qty` int(11) NOT NULL,
  `item_condition` int(11) NOT NULL COMMENT '1: Good, 2: Not Good'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `return_items`
--

INSERT INTO `return_items` (`id`, `order_id`, `product_code`, `price`, `qty`, `item_condition`) VALUES
(1, 3, 'idm001', 2500.00, 1, 1);

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

--
-- Table structure for table `site_setting`
--

CREATE TABLE `site_setting` (
  `id` int(11) NOT NULL,
  `site_name` varchar(499) COLLATE utf8_unicode_ci NOT NULL,
  `site_logo` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `timezone` varchar(499) COLLATE utf8_unicode_ci NOT NULL,
  `pagination` int(11) NOT NULL,
  `tax` double(11,2) NOT NULL,
  `currency` char(3) COLLATE utf8_unicode_ci NOT NULL,
  `datetime_format` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `display_product` int(11) NOT NULL,
  `display_keyboard` int(11) NOT NULL,
  `default_customer_id` int(11) NOT NULL,
  `updated_user_id` int(11) NOT NULL,
  `updated_datetime` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `site_setting`
--

INSERT INTO `site_setting` (`id`, `site_name`, `site_logo`, `timezone`, `pagination`, `tax`, `currency`, `datetime_format`, `display_product`, `display_keyboard`, `default_customer_id`, `updated_user_id`, `updated_datetime`) VALUES
(1, 'Anugerah', 'logo.jpg', 'Asia/Makassar', 100, 0.00, 'IDR', 'd-m-Y', 1, 0, 1, 1, '2023-12-29 15:51:44');

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

--
-- Table structure for table `suppliers`
--

CREATE TABLE `suppliers` (
  `id` int(11) NOT NULL,
  `name` varchar(4999) COLLATE utf8_unicode_ci NOT NULL,
  `tax` double(11,2) NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `address` longtext COLLATE utf8_unicode_ci NOT NULL,
  `tel` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fax` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_user_id` int(11) NOT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_user_id` int(11) NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `status` int(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `suppliers`
--

INSERT INTO `suppliers` (`id`, `name`, `tax`, `email`, `address`, `tel`, `fax`, `created_user_id`, `created_datetime`, `updated_user_id`, `updated_datetime`, `status`) VALUES
(4, 'Suplier Indomie', 0.00, '', 'Sukabumi', '080000000000', '', 1, '2018-10-18 22:20:45', 1, '2023-12-26 21:36:45', 0),
(5, 'Umum', 0.00, '', '-', '-', '', 1, '2018-10-18 22:21:17', 1, '2023-12-26 21:37:25', 1),
(3, 'PT Sayur Sukabumi', 0.00, '', 'Sukabumi', '080000000000', '', 1, '2016-11-19 17:42:18', 1, '2023-12-26 21:37:00', 0);

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

--
-- Table structure for table `suspend`
--

CREATE TABLE `suspend` (
  `id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `fullname` varchar(499) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(499) COLLATE utf8_unicode_ci NOT NULL,
  `mobile` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ref_number` varchar(499) COLLATE utf8_unicode_ci NOT NULL,
  `outlet_id` int(11) NOT NULL,
  `subtotal` double(11,2) NOT NULL,
  `discount_total` double(11,2) NOT NULL,
  `tax` double(11,2) NOT NULL,
  `grandtotal` double(11,2) NOT NULL,
  `total_items` int(11) NOT NULL,
  `created_user_id` int(11) NOT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_user_id` int(11) NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `suspend`
--

INSERT INTO `suspend` (`id`, `customer_id`, `fullname`, `email`, `mobile`, `ref_number`, `outlet_id`, `subtotal`, `discount_total`, `tax`, `grandtotal`, `total_items`, `created_user_id`, `created_datetime`, `updated_user_id`, `updated_datetime`, `status`) VALUES
(1, 1, 'Walk In Customer', '', '', '18102336', 3, 150000.00, 0.00, 7500.00, 157500.00, 60, 1, '2018-10-18 23:37:02', 1, '2018-10-18 23:43:02', 1);

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

--
-- Table structure for table `suspend_items`
--

CREATE TABLE `suspend_items` (
  `id` int(11) NOT NULL,
  `suspend_id` int(11) NOT NULL,
  `product_code` varchar(499) COLLATE utf8_unicode_ci NOT NULL,
  `product_name` varchar(499) COLLATE utf8_unicode_ci NOT NULL,
  `product_category` int(11) NOT NULL,
  `product_cost` double(11,2) NOT NULL,
  `qty` int(11) NOT NULL,
  `product_price` varchar(499) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `suspend_items`
--

INSERT INTO `suspend_items` (`id`, `suspend_id`, `product_code`, `product_name`, `product_category`, `product_cost`, `qty`, `product_price`) VALUES
(1, 1, 'idm002', 'Indomie Goreng', 6, 2150.00, 20, '2500.00'),
(2, 1, 'idm001', 'Indomie Ayam Bawang', 6, 2150.00, 20, '2500.00'),
(3, 1, 'idm004', 'Indomie Empal Gentong', 6, 2150.00, 20, '2500.00');

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

--
-- Table structure for table `timezones`
--

CREATE TABLE `timezones` (
  `id` int(11) NOT NULL,
  `code` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `timezone` varchar(499) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `timezones`
--

INSERT INTO `timezones` (`id`, `code`, `timezone`) VALUES
(1, 'AD', 'Europe/Andorra'),
(2, 'AE', 'Asia/Dubai'),
(3, 'AF', 'Asia/Kabul'),
(4, 'AG', 'America/Antigua'),
(5, 'AI', 'America/Anguilla'),
(6, 'AL', 'Europe/Tirane'),
(7, 'AM', 'Asia/Yerevan'),
(8, 'AO', 'Africa/Luanda'),
(9, 'AQ', 'Antarctica/McMurdo'),
(10, 'AQ', 'Antarctica/Casey'),
(11, 'AQ', 'Antarctica/Davis'),
(12, 'AQ', 'Antarctica/DumontDUrville'),
(13, 'AQ', 'Antarctica/Mawson'),
(14, 'AQ', 'Antarctica/Palmer'),
(15, 'AQ', 'Antarctica/Rothera'),
(16, 'AQ', 'Antarctica/Syowa'),
(17, 'AQ', 'Antarctica/Troll'),
(18, 'AQ', 'Antarctica/Vostok'),
(19, 'AR', 'America/Argentina/Buenos_Aires'),
(20, 'AR', 'America/Argentina/Cordoba'),
(21, 'AR', 'America/Argentina/Salta'),
(22, 'AR', 'America/Argentina/Jujuy'),
(23, 'AR', 'America/Argentina/Tucuman'),
(24, 'AR', 'America/Argentina/Catamarca'),
(25, 'AR', 'America/Argentina/La_Rioja'),
(26, 'AR', 'America/Argentina/San_Juan'),
(27, 'AR', 'America/Argentina/Mendoza'),
(28, 'AR', 'America/Argentina/San_Luis'),
(29, 'AR', 'America/Argentina/Rio_Gallegos'),
(30, 'AR', 'America/Argentina/Ushuaia'),
(31, 'AS', 'Pacific/Pago_Pago'),
(32, 'AT', 'Europe/Vienna'),
(33, 'AU', 'Australia/Lord_Howe'),
(34, 'AU', 'Antarctica/Macquarie'),
(35, 'AU', 'Australia/Hobart'),
(36, 'AU', 'Australia/Currie'),
(37, 'AU', 'Australia/Melbourne'),
(38, 'AU', 'Australia/Sydney'),
(39, 'AU', 'Australia/Broken_Hill'),
(40, 'AU', 'Australia/Brisbane'),
(41, 'AU', 'Australia/Lindeman'),
(42, 'AU', 'Australia/Adelaide'),
(43, 'AU', 'Australia/Darwin'),
(44, 'AU', 'Australia/Perth'),
(45, 'AU', 'Australia/Eucla'),
(46, 'AW', 'America/Aruba'),
(47, 'AX', 'Europe/Mariehamn'),
(48, 'AZ', 'Asia/Baku'),
(49, 'BA', 'Europe/Sarajevo'),
(50, 'BB', 'America/Barbados'),
(51, 'BD', 'Asia/Dhaka'),
(52, 'BE', 'Europe/Brussels'),
(53, 'BF', 'Africa/Ouagadougou'),
(54, 'BG', 'Europe/Sofia'),
(55, 'BH', 'Asia/Bahrain'),
(56, 'BI', 'Africa/Bujumbura'),
(57, 'BJ', 'Africa/Porto-Novo'),
(58, 'BL', 'America/St_Barthelemy'),
(59, 'BM', 'Atlantic/Bermuda'),
(60, 'BN', 'Asia/Brunei'),
(61, 'BO', 'America/La_Paz'),
(62, 'BQ', 'America/Kralendijk'),
(63, 'BR', 'America/Noronha'),
(64, 'BR', 'America/Belem'),
(65, 'BR', 'America/Fortaleza'),
(66, 'BR', 'America/Recife'),
(67, 'BR', 'America/Araguaina'),
(68, 'BR', 'America/Maceio'),
(69, 'BR', 'America/Bahia'),
(70, 'BR', 'America/Sao_Paulo'),
(71, 'BR', 'America/Campo_Grande'),
(72, 'BR', 'America/Cuiaba'),
(73, 'BR', 'America/Santarem'),
(74, 'BR', 'America/Porto_Velho'),
(75, 'BR', 'America/Boa_Vista'),
(76, 'BR', 'America/Manaus'),
(77, 'BR', 'America/Eirunepe'),
(78, 'BR', 'America/Rio_Branco'),
(79, 'BS', 'America/Nassau'),
(80, 'BT', 'Asia/Thimphu'),
(81, 'BW', 'Africa/Gaborone'),
(82, 'BY', 'Europe/Minsk'),
(83, 'BZ', 'America/Belize'),
(84, 'CA', 'America/St_Johns'),
(85, 'CA', 'America/Halifax'),
(86, 'CA', 'America/Glace_Bay'),
(87, 'CA', 'America/Moncton'),
(88, 'CA', 'America/Goose_Bay'),
(89, 'CA', 'America/Blanc-Sablon'),
(90, 'CA', 'America/Toronto'),
(91, 'CA', 'America/Nipigon'),
(92, 'CA', 'America/Thunder_Bay'),
(93, 'CA', 'America/Iqaluit'),
(94, 'CA', 'America/Pangnirtung'),
(95, 'CA', 'America/Atikokan'),
(96, 'CA', 'America/Winnipeg'),
(97, 'CA', 'America/Rainy_River'),
(98, 'CA', 'America/Resolute'),
(99, 'CA', 'America/Rankin_Inlet'),
(100, 'CA', 'America/Regina'),
(101, 'CA', 'America/Swift_Current'),
(102, 'CA', 'America/Edmonton'),
(103, 'CA', 'America/Cambridge_Bay'),
(104, 'CA', 'America/Yellowknife'),
(105, 'CA', 'America/Inuvik'),
(106, 'CA', 'America/Creston'),
(107, 'CA', 'America/Dawson_Creek'),
(108, 'CA', 'America/Fort_Nelson'),
(109, 'CA', 'America/Vancouver'),
(110, 'CA', 'America/Whitehorse'),
(111, 'CA', 'America/Dawson'),
(112, 'CC', 'Indian/Cocos'),
(113, 'CD', 'Africa/Kinshasa'),
(114, 'CD', 'Africa/Lubumbashi'),
(115, 'CF', 'Africa/Bangui'),
(116, 'CG', 'Africa/Brazzaville'),
(117, 'CH', 'Europe/Zurich'),
(118, 'CI', 'Africa/Abidjan'),
(119, 'CK', 'Pacific/Rarotonga'),
(120, 'CL', 'America/Santiago'),
(121, 'CL', 'Pacific/Easter'),
(122, 'CM', 'Africa/Douala'),
(123, 'CN', 'Asia/Shanghai'),
(124, 'CN', 'Asia/Urumqi'),
(125, 'CO', 'America/Bogota'),
(126, 'CR', 'America/Costa_Rica'),
(127, 'CU', 'America/Havana'),
(128, 'CV', 'Atlantic/Cape_Verde'),
(129, 'CW', 'America/Curacao'),
(130, 'CX', 'Indian/Christmas'),
(131, 'CY', 'Asia/Nicosia'),
(132, 'CZ', 'Europe/Prague'),
(133, 'DE', 'Europe/Berlin'),
(134, 'DE', 'Europe/Busingen'),
(135, 'DJ', 'Africa/Djibouti'),
(136, 'DK', 'Europe/Copenhagen'),
(137, 'DM', 'America/Dominica'),
(138, 'DO', 'America/Santo_Domingo'),
(139, 'DZ', 'Africa/Algiers'),
(140, 'EC', 'America/Guayaquil'),
(141, 'EC', 'Pacific/Galapagos'),
(142, 'EE', 'Europe/Tallinn'),
(143, 'EG', 'Africa/Cairo'),
(144, 'EH', 'Africa/El_Aaiun'),
(145, 'ER', 'Africa/Asmara'),
(146, 'ES', 'Europe/Madrid'),
(147, 'ES', 'Africa/Ceuta'),
(148, 'ES', 'Atlantic/Canary'),
(149, 'ET', 'Africa/Addis_Ababa'),
(150, 'FI', 'Europe/Helsinki'),
(151, 'FJ', 'Pacific/Fiji'),
(152, 'FK', 'Atlantic/Stanley'),
(153, 'FM', 'Pacific/Chuuk'),
(154, 'FM', 'Pacific/Pohnpei'),
(155, 'FM', 'Pacific/Kosrae'),
(156, 'FO', 'Atlantic/Faroe'),
(157, 'FR', 'Europe/Paris'),
(158, 'GA', 'Africa/Libreville'),
(159, 'GB', 'Europe/London'),
(160, 'GD', 'America/Grenada'),
(161, 'GE', 'Asia/Tbilisi'),
(162, 'GF', 'America/Cayenne'),
(163, 'GG', 'Europe/Guernsey'),
(164, 'GH', 'Africa/Accra'),
(165, 'GI', 'Europe/Gibraltar'),
(166, 'GL', 'America/Godthab'),
(167, 'GL', 'America/Danmarkshavn'),
(168, 'GL', 'America/Scoresbysund'),
(169, 'GL', 'America/Thule'),
(170, 'GM', 'Africa/Banjul'),
(171, 'GN', 'Africa/Conakry'),
(172, 'GP', 'America/Guadeloupe'),
(173, 'GQ', 'Africa/Malabo'),
(174, 'GR', 'Europe/Athens'),
(175, 'GS', 'Atlantic/South_Georgia'),
(176, 'GT', 'America/Guatemala'),
(177, 'GU', 'Pacific/Guam'),
(178, 'GW', 'Africa/Bissau'),
(179, 'GY', 'America/Guyana'),
(180, 'HK', 'Asia/Hong_Kong'),
(181, 'HN', 'America/Tegucigalpa'),
(182, 'HR', 'Europe/Zagreb'),
(183, 'HT', 'America/Port-au-Prince'),
(184, 'HU', 'Europe/Budapest'),
(185, 'ID', 'Asia/Jakarta'),
(186, 'ID', 'Asia/Pontianak'),
(187, 'ID', 'Asia/Makassar'),
(188, 'ID', 'Asia/Jayapura'),
(189, 'IE', 'Europe/Dublin'),
(190, 'IL', 'Asia/Jerusalem'),
(191, 'IM', 'Europe/Isle_of_Man'),
(192, 'IN', 'Asia/Kolkata'),
(193, 'IO', 'Indian/Chagos'),
(194, 'IQ', 'Asia/Baghdad'),
(195, 'IR', 'Asia/Tehran'),
(196, 'IS', 'Atlantic/Reykjavik'),
(197, 'IT', 'Europe/Rome'),
(198, 'JE', 'Europe/Jersey'),
(199, 'JM', 'America/Jamaica'),
(200, 'JO', 'Asia/Amman'),
(201, 'JP', 'Asia/Tokyo'),
(202, 'KE', 'Africa/Nairobi'),
(203, 'KG', 'Asia/Bishkek'),
(204, 'KH', 'Asia/Phnom_Penh'),
(205, 'KI', 'Pacific/Tarawa'),
(206, 'KI', 'Pacific/Enderbury'),
(207, 'KI', 'Pacific/Kiritimati'),
(208, 'KM', 'Indian/Comoro'),
(209, 'KN', 'America/St_Kitts'),
(210, 'KP', 'Asia/Pyongyang'),
(211, 'KR', 'Asia/Seoul'),
(212, 'KW', 'Asia/Kuwait'),
(213, 'KY', 'America/Cayman'),
(214, 'KZ', 'Asia/Almaty'),
(215, 'KZ', 'Asia/Qyzylorda'),
(216, 'KZ', 'Asia/Aqtobe'),
(217, 'KZ', 'Asia/Aqtau'),
(218, 'KZ', 'Asia/Oral'),
(219, 'LA', 'Asia/Vientiane'),
(220, 'LB', 'Asia/Beirut'),
(221, 'LC', 'America/St_Lucia'),
(222, 'LI', 'Europe/Vaduz'),
(223, 'LK', 'Asia/Colombo'),
(224, 'LR', 'Africa/Monrovia'),
(225, 'LS', 'Africa/Maseru'),
(226, 'LT', 'Europe/Vilnius'),
(227, 'LU', 'Europe/Luxembourg'),
(228, 'LV', 'Europe/Riga'),
(229, 'LY', 'Africa/Tripoli'),
(230, 'MA', 'Africa/Casablanca'),
(231, 'MC', 'Europe/Monaco'),
(232, 'MD', 'Europe/Chisinau'),
(233, 'ME', 'Europe/Podgorica'),
(234, 'MF', 'America/Marigot'),
(235, 'MG', 'Indian/Antananarivo'),
(236, 'MH', 'Pacific/Majuro'),
(237, 'MH', 'Pacific/Kwajalein'),
(238, 'MK', 'Europe/Skopje'),
(239, 'ML', 'Africa/Bamako'),
(240, 'MM', 'Asia/Rangoon'),
(241, 'MN', 'Asia/Ulaanbaatar'),
(242, 'MN', 'Asia/Hovd'),
(243, 'MN', 'Asia/Choibalsan'),
(244, 'MO', 'Asia/Macau'),
(245, 'MP', 'Pacific/Saipan'),
(246, 'MQ', 'America/Martinique'),
(247, 'MR', 'Africa/Nouakchott'),
(248, 'MS', 'America/Montserrat'),
(249, 'MT', 'Europe/Malta'),
(250, 'MU', 'Indian/Mauritius'),
(251, 'MV', 'Indian/Maldives'),
(252, 'MW', 'Africa/Blantyre'),
(253, 'MX', 'America/Mexico_City'),
(254, 'MX', 'America/Cancun'),
(255, 'MX', 'America/Merida'),
(256, 'MX', 'America/Monterrey'),
(257, 'MX', 'America/Matamoros'),
(258, 'MX', 'America/Mazatlan'),
(259, 'MX', 'America/Chihuahua'),
(260, 'MX', 'America/Ojinaga'),
(261, 'MX', 'America/Hermosillo'),
(262, 'MX', 'America/Tijuana'),
(263, 'MX', 'America/Bahia_Banderas'),
(264, 'MY', 'Asia/Kuala_Lumpur'),
(265, 'MY', 'Asia/Kuching'),
(266, 'MZ', 'Africa/Maputo'),
(267, 'NA', 'Africa/Windhoek'),
(268, 'NC', 'Pacific/Noumea'),
(269, 'NE', 'Africa/Niamey'),
(270, 'NF', 'Pacific/Norfolk'),
(271, 'NG', 'Africa/Lagos'),
(272, 'NI', 'America/Managua'),
(273, 'NL', 'Europe/Amsterdam'),
(274, 'NO', 'Europe/Oslo'),
(275, 'NP', 'Asia/Kathmandu'),
(276, 'NR', 'Pacific/Nauru'),
(277, 'NU', 'Pacific/Niue'),
(278, 'NZ', 'Pacific/Auckland'),
(279, 'NZ', 'Pacific/Chatham'),
(280, 'OM', 'Asia/Muscat'),
(281, 'PA', 'America/Panama'),
(282, 'PE', 'America/Lima'),
(283, 'PF', 'Pacific/Tahiti'),
(284, 'PF', 'Pacific/Marquesas'),
(285, 'PF', 'Pacific/Gambier'),
(286, 'PG', 'Pacific/Port_Moresby'),
(287, 'PG', 'Pacific/Bougainville'),
(288, 'PH', 'Asia/Manila'),
(289, 'PK', 'Asia/Karachi'),
(290, 'PL', 'Europe/Warsaw'),
(291, 'PM', 'America/Miquelon'),
(292, 'PN', 'Pacific/Pitcairn'),
(293, 'PR', 'America/Puerto_Rico'),
(294, 'PS', 'Asia/Gaza'),
(295, 'PS', 'Asia/Hebron'),
(296, 'PT', 'Europe/Lisbon'),
(297, 'PT', 'Atlantic/Madeira'),
(298, 'PT', 'Atlantic/Azores'),
(299, 'PW', 'Pacific/Palau'),
(300, 'PY', 'America/Asuncion'),
(301, 'QA', 'Asia/Qatar'),
(302, 'RE', 'Indian/Reunion'),
(303, 'RO', 'Europe/Bucharest'),
(304, 'RS', 'Europe/Belgrade'),
(305, 'RU', 'Europe/Kaliningrad'),
(306, 'RU', 'Europe/Moscow'),
(307, 'RU', 'Europe/Simferopol'),
(308, 'RU', 'Europe/Volgograd'),
(309, 'RU', 'Europe/Kirov'),
(310, 'RU', 'Europe/Astrakhan'),
(311, 'RU', 'Europe/Samara'),
(312, 'RU', 'Europe/Ulyanovsk'),
(313, 'RU', 'Asia/Yekaterinburg'),
(314, 'RU', 'Asia/Omsk'),
(315, 'RU', 'Asia/Novosibirsk'),
(316, 'RU', 'Asia/Barnaul'),
(317, 'RU', 'Asia/Tomsk'),
(318, 'RU', 'Asia/Novokuznetsk'),
(319, 'RU', 'Asia/Krasnoyarsk'),
(320, 'RU', 'Asia/Irkutsk'),
(321, 'RU', 'Asia/Chita'),
(322, 'RU', 'Asia/Yakutsk'),
(323, 'RU', 'Asia/Khandyga'),
(324, 'RU', 'Asia/Vladivostok'),
(325, 'RU', 'Asia/Ust-Nera'),
(326, 'RU', 'Asia/Magadan'),
(327, 'RU', 'Asia/Sakhalin'),
(328, 'RU', 'Asia/Srednekolymsk'),
(329, 'RU', 'Asia/Kamchatka'),
(330, 'RU', 'Asia/Anadyr'),
(331, 'RW', 'Africa/Kigali'),
(332, 'SA', 'Asia/Riyadh'),
(333, 'SB', 'Pacific/Guadalcanal'),
(334, 'SC', 'Indian/Mahe'),
(335, 'SD', 'Africa/Khartoum'),
(336, 'SE', 'Europe/Stockholm'),
(337, 'SG', 'Asia/Singapore'),
(338, 'SH', 'Atlantic/St_Helena'),
(339, 'SI', 'Europe/Ljubljana'),
(340, 'SJ', 'Arctic/Longyearbyen'),
(341, 'SK', 'Europe/Bratislava'),
(342, 'SL', 'Africa/Freetown'),
(343, 'SM', 'Europe/San_Marino'),
(344, 'SN', 'Africa/Dakar'),
(345, 'SO', 'Africa/Mogadishu'),
(346, 'SR', 'America/Paramaribo'),
(347, 'SS', 'Africa/Juba'),
(348, 'ST', 'Africa/Sao_Tome'),
(349, 'SV', 'America/El_Salvador'),
(350, 'SX', 'America/Lower_Princes'),
(351, 'SY', 'Asia/Damascus'),
(352, 'SZ', 'Africa/Mbabane'),
(353, 'TC', 'America/Grand_Turk'),
(354, 'TD', 'Africa/Ndjamena'),
(355, 'TF', 'Indian/Kerguelen'),
(356, 'TG', 'Africa/Lome'),
(357, 'TH', 'Asia/Bangkok'),
(358, 'TJ', 'Asia/Dushanbe'),
(359, 'TK', 'Pacific/Fakaofo'),
(360, 'TL', 'Asia/Dili'),
(361, 'TM', 'Asia/Ashgabat'),
(362, 'TN', 'Africa/Tunis'),
(363, 'TO', 'Pacific/Tongatapu'),
(364, 'TR', 'Europe/Istanbul'),
(365, 'TT', 'America/Port_of_Spain'),
(366, 'TV', 'Pacific/Funafuti'),
(367, 'TW', 'Asia/Taipei'),
(368, 'TZ', 'Africa/Dar_es_Salaam'),
(369, 'UA', 'Europe/Kiev'),
(370, 'UA', 'Europe/Uzhgorod'),
(371, 'UA', 'Europe/Zaporozhye'),
(372, 'UG', 'Africa/Kampala'),
(373, 'UM', 'Pacific/Johnston'),
(374, 'UM', 'Pacific/Midway'),
(375, 'UM', 'Pacific/Wake'),
(376, 'US', 'America/New_York'),
(377, 'US', 'America/Detroit'),
(378, 'US', 'America/Kentucky/Louisville'),
(379, 'US', 'America/Kentucky/Monticello'),
(380, 'US', 'America/Indiana/Indianapolis'),
(381, 'US', 'America/Indiana/Vincennes'),
(382, 'US', 'America/Indiana/Winamac'),
(383, 'US', 'America/Indiana/Marengo'),
(384, 'US', 'America/Indiana/Petersburg'),
(385, 'US', 'America/Indiana/Vevay'),
(386, 'US', 'America/Chicago'),
(387, 'US', 'America/Indiana/Tell_City'),
(388, 'US', 'America/Indiana/Knox'),
(389, 'US', 'America/Menominee'),
(390, 'US', 'America/North_Dakota/Center'),
(391, 'US', 'America/North_Dakota/New_Salem'),
(392, 'US', 'America/North_Dakota/Beulah'),
(393, 'US', 'America/Denver'),
(394, 'US', 'America/Boise'),
(395, 'US', 'America/Phoenix'),
(396, 'US', 'America/Los_Angeles'),
(397, 'US', 'America/Anchorage'),
(398, 'US', 'America/Juneau'),
(399, 'US', 'America/Sitka'),
(400, 'US', 'America/Metlakatla'),
(401, 'US', 'America/Yakutat'),
(402, 'US', 'America/Nome'),
(403, 'US', 'America/Adak'),
(404, 'US', 'Pacific/Honolulu'),
(405, 'UY', 'America/Montevideo'),
(406, 'UZ', 'Asia/Samarkand'),
(407, 'UZ', 'Asia/Tashkent'),
(408, 'VA', 'Europe/Vatican'),
(409, 'VC', 'America/St_Vincent'),
(410, 'VE', 'America/Caracas'),
(411, 'VG', 'America/Tortola'),
(412, 'VI', 'America/St_Thomas'),
(413, 'VN', 'Asia/Ho_Chi_Minh'),
(414, 'VU', 'Pacific/Efate'),
(415, 'WF', 'Pacific/Wallis'),
(416, 'WS', 'Pacific/Apia'),
(417, 'YE', 'Asia/Aden'),
(418, 'YT', 'Indian/Mayotte'),
(419, 'ZA', 'Africa/Johannesburg'),
(420, 'ZM', 'Africa/Lusaka'),
(421, 'ZW', 'Africa/Harare');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `fullname` varchar(499) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(499) COLLATE utf8_unicode_ci NOT NULL,
  `role_id` int(11) NOT NULL,
  `outlet_id` int(11) NOT NULL,
  `created_user_id` int(11) NOT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_user_id` int(11) NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `status` int(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `fullname`, `email`, `password`, `role_id`, `outlet_id`, `created_user_id`, `created_datetime`, `updated_user_id`, `updated_datetime`, `status`) VALUES
(1, 'Agus Purwita', 'aguspurwita@gmail.com', '119dfcab41db0a03b574f9921f373cfc', 1, 0, 1, '2016-08-27 00:00:00', 1, '2023-12-28 23:27:32', 1),
(4, 'Suka Mart Manager', 'manager1@sukapos.com', 'c240642ddef994358c96da82c0361a58', 2, 3, 1, '2016-08-27 12:35:03', 1, '2018-10-21 16:33:23', 1),
(5, 'Suka Mart Kasir', 'kasir1@sukapos.com', '29c748d4d8f4bd5cbc0f3f60cb7ed3d0', 3, 3, 1, '2016-08-27 12:35:32', 1, '2018-10-21 16:31:45', 1),
(14, 'Suka Mart Kasir', 'kasir2@sukapos.com', '8c86013d8ba23d9b5ade4d6463f81c45', 3, 6, 1, '2018-10-21 16:32:22', 1, '2018-10-21 16:34:28', 1),
(15, 'Suka Mall Manager', 'manager2@sukapos.com', '8df5127cd164b5bc2d2b78410a7eea0c', 2, 6, 1, '2018-10-21 16:32:56', 1, '2018-10-21 16:33:51', 1);

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

--
-- Table structure for table `user_roles`
--

CREATE TABLE `user_roles` (
  `id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_user_id` int(11) NOT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_user_id` int(11) NOT NULL,
  `updated_datetime` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `user_roles`
--

INSERT INTO `user_roles` (`id`, `name`, `created_user_id`, `created_datetime`, `updated_user_id`, `updated_datetime`) VALUES
(1, 'Administrator', 1, '2016-08-16 00:00:00', 0, '0000-00-00 00:00:00'),
(2, 'Manager', 1, '2016-08-16 00:00:00', 0, '0000-00-00 00:00:00'),
(3, 'Cashier', 1, '2016-08-16 00:00:00', 0, '0000-00-00 00:00:00');

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `ci_sessions`
--
ALTER TABLE `ci_sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ci_sessions_timestamp` (`timestamp`);

--
-- Indexes for table `currency`
--
ALTER TABLE `currency`
  ADD PRIMARY KEY (`iso`),
  ADD UNIQUE KEY `name` (`name`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

