-- Table structure for table `tbl_item_categories`
--

CREATE TABLE `tbl_item_categories` (
  `id` int(11) NOT NULL,
  `name` varchar(55) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `sort_id` int(55) DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `company_id` int(11) UNSIGNED DEFAULT NULL,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_item_categories`
--

INSERT INTO `tbl_item_categories` (`id`, `name`, `description`, `sort_id`, `added_date`, `user_id`, `company_id`, `del_status`) VALUES
(1, 'Punjabi', '', NULL, '2024-05-21 13:43:41', 1, 1, 'Delete'),
(2, 'T-Shirts', '', NULL, '2024-05-21 13:43:59', 1, 1, 'Delete'),
(3, 'Shirts', '', NULL, '2024-05-21 13:44:08', 1, 1, 'Delete'),
(4, 'Pants', '', NULL, '2024-05-21 13:44:43', 1, 1, 'Delete'),
(5, 'Accessories', '', NULL, '2024-05-21 13:46:32', 1, 1, 'Delete'),
(6, 'Mobile Phones', '', NULL, '2024-05-23 12:21:01', 1, 1, 'Delete'),
(7, 'Tablets', '', NULL, '2024-05-23 12:21:13', 1, 1, 'Delete'),
(8, 'Modems and Routers', '', NULL, '2024-05-23 12:21:22', 1, 1, 'Delete'),
(9, 'Wearable Devices', '', NULL, '2024-05-23 12:21:34', 1, 1, 'Delete'),
(10, 'Laptops and Notebooks', '', NULL, '2024-05-23 12:21:46', 1, 1, 'Delete'),
(12, 'Monitor', '', NULL, '2024-05-25 10:54:42', 1, 1, 'Live'),
(13, 'TV', '', NULL, '2024-05-25 10:55:04', 1, 1, 'Live'),
(14, 'CC Camera', '', NULL, '2024-05-25 10:55:32', 1, 1, 'Delete'),
(15, 'Laptop', '', NULL, '2024-05-25 10:56:06', 1, 1, 'Live'),
(16, 'RAM', '', NULL, '2024-05-25 10:56:50', 1, 1, 'Live'),
(17, 'CPU', '', NULL, '2024-05-25 11:45:44', 1, 1, 'Live');

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

--
-- Table structure for table `tbl_main_modules`
--

CREATE TABLE `tbl_main_modules` (
  `id` int(11) NOT NULL,
  `name` varchar(55) DEFAULT NULL,
  `del_status` varchar(11) NOT NULL DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `tbl_multiple_currencies`
--

CREATE TABLE `tbl_multiple_currencies` (
  `id` int(11) NOT NULL,
  `currency` varchar(11) DEFAULT NULL,
  `conversion_rate` float DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `company_id` int(1) DEFAULT NULL,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `tbl_notifications`
--

CREATE TABLE `tbl_notifications` (
  `id` int(11) NOT NULL,
  `notifications_details` varchar(300) DEFAULT NULL,
  `visible_status` int(11) DEFAULT 1,
  `read_status` int(11) NOT NULL DEFAULT 0,
  `installment_id` int(11) DEFAULT NULL,
  `date` varchar(30) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `tbl_outlets`
--

CREATE TABLE `tbl_outlets` (
  `id` int(11) NOT NULL,
  `outlet_name` varchar(55) DEFAULT NULL,
  `outlet_code` varchar(55) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `phone` varchar(30) DEFAULT NULL,
  `email` varchar(55) DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `active_status` varchar(25) DEFAULT 'active',
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_outlets`
--

INSERT INTO `tbl_outlets` (`id`, `outlet_name`, `outlet_code`, `address`, `phone`, `email`, `added_date`, `user_id`, `active_status`, `company_id`, `del_status`) VALUES
(4, 'Ninja Shop (Mirpur)', '000001', 'House No: 5, Road No: 4, Kazi Para, Mirpur 10, Dhaka.', '+88 01987 654321', '', '2024-05-19 15:01:58', 1, 'active', 1, 'Live'),
(5, 'Ninja Shop (Uttara)', '000002', 'Address: House No: 5, Road No: 4, Nikunja 2, Khilkhet, Dhaka.', '+88 01987 6543211', '', '2024-05-19 16:28:37', 1, 'active', 1, 'Live');

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

--
-- Table structure for table `tbl_payment_methods`
--

CREATE TABLE `tbl_payment_methods` (
  `id` int(11) NOT NULL,
  `name` varchar(55) DEFAULT NULL,
  `account_type` varchar(55) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `current_balance` float DEFAULT NULL,
  `status` varchar(55) NOT NULL DEFAULT 'Enable' COMMENT 'Enable, Disable',
  `added_date` varchar(55) DEFAULT NULL,
  `personalinformation` text DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) NOT NULL DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_payment_methods`
--

INSERT INTO `tbl_payment_methods` (`id`, `name`, `account_type`, `description`, `current_balance`, `status`, `added_date`, `personalinformation`, `user_id`, `company_id`, `del_status`) VALUES
(1, 'Bank', 'Bank_Account', '', 10, 'Enable', '2023-07-30 21:22:42', NULL, 1, 1, 'Live'),
(2, 'Cash', 'Cash', '', 1001, 'Enable', '2023-07-30 21:22:42', NULL, 1, 1, 'Live'),
(6, 'Paypal', 'Paypal', '', 1, 'Disable', '2024-03-09 14:25:04', NULL, 1, 1, 'Live'),
(7, 'Stripe', 'Stripe', '', 1, 'Enable', '2024-03-09 14:25:33', NULL, 1, 1, 'Live'),
(8, 'Loyalty Point', 'Loyalty Point', '', 0, 'Enable', '2024-03-15 19:20:19', NULL, 1, 1, 'Live');

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

--
-- Table structure for table `tbl_printers`
--

CREATE TABLE `tbl_printers` (
  `id` int(11) NOT NULL,
  `path` varchar(300) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `type` varchar(100) DEFAULT NULL,
  `profile_` varchar(100) DEFAULT NULL,
  `characters_per_line` int(11) DEFAULT NULL,
  `printer_ip_address` varchar(55) DEFAULT NULL,
  `printer_port` varchar(55) DEFAULT NULL,
  `print_format_invoice` varchar(25) DEFAULT NULL,
  `print_format` varchar(25) DEFAULT NULL,
  `qr_code_type` varchar(55) DEFAULT NULL,
  `invoice_print` varchar(55) DEFAULT NULL,
  `print_server_url_invoice` varchar(255) DEFAULT NULL,
  `inv_qr_code_status` varchar(25) DEFAULT NULL,
  `open_cash_drawer_when_printing_invoice` varchar(255) DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) NOT NULL DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_printers`
--

INSERT INTO `tbl_printers` (`id`, `path`, `title`, `type`, `profile_`, `characters_per_line`, `printer_ip_address`, `printer_port`, `print_format_invoice`, `print_format`, `qr_code_type`, `invoice_print`, `print_server_url_invoice`, `inv_qr_code_status`, `open_cash_drawer_when_printing_invoice`, `added_date`, `user_id`, `company_id`, `del_status`) VALUES
(2, '', 'General Printer', 'network', 'default', 30, '19.000.000', '90', 'A4 Print', 'A4 Print', 'Invoice Link', 'web_browser', '', 'Enable', '', '2024-05-19 16:54:45', 1, 1, 'Live');

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

--
-- Table structure for table `tbl_promotions`
--

CREATE TABLE `tbl_promotions` (
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `start_date` varchar(55) DEFAULT NULL,
  `end_date` varchar(55) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `food_menu_id` varchar(11) DEFAULT NULL,
  `qty` float DEFAULT NULL,
  `get_food_menu_id` varchar(11) DEFAULT NULL,
  `get_qty` float DEFAULT NULL,
  `discount` varchar(11) DEFAULT NULL,
  `coupon_code` varchar(4) DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) NOT NULL DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `tbl_purchase`
--

CREATE TABLE `tbl_purchase` (
  `id` int(11) NOT NULL,
  `reference_no` varchar(55) DEFAULT NULL,
  `invoice_no` varchar(55) DEFAULT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `date` varchar(30) DEFAULT NULL,
  `other` float DEFAULT NULL,
  `grand_total` float DEFAULT NULL,
  `paid` float DEFAULT NULL,
  `due_amount` float DEFAULT NULL,
  `note` varchar(255) DEFAULT NULL,
  `discount` varchar(11) DEFAULT NULL,
  `attachment` varchar(255) DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_purchase`
--

INSERT INTO `tbl_purchase` (`id`, `reference_no`, `invoice_no`, `supplier_id`, `date`, `other`, `grand_total`, `paid`, `due_amount`, `note`, `discount`, `attachment`, `added_date`, `user_id`, `outlet_id`, `company_id`, `del_status`) VALUES
(1, '000001', '', 19, '2024-05-25', 0, 80487, 80487, 0, '', '', '', '2024-05-25 19:12:25', 1, 4, 1, 'Live');

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

--
-- Table structure for table `tbl_purchase_details`
--

CREATE TABLE `tbl_purchase_details` (
  `id` int(11) NOT NULL,
  `item_id` int(11) DEFAULT NULL,
  `item_type` varchar(55) DEFAULT NULL,
  `expiry_imei_serial` varchar(255) DEFAULT NULL,
  `unit_price` float DEFAULT NULL,
  `divided_price` float DEFAULT NULL,
  `quantity_amount` float DEFAULT NULL,
  `total` float DEFAULT NULL,
  `purchase_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_purchase_details`
--

INSERT INTO `tbl_purchase_details` (`id`, `item_id`, `item_type`, `expiry_imei_serial`, `unit_price`, `divided_price`, `quantity_amount`, `total`, `purchase_id`, `outlet_id`, `company_id`, `del_status`) VALUES
(1, 294, 'Serial_Product', 'DELLU2422HE123470', 26829, 26829, 1, 26829, 1, 4, 1, 'Live'),
(2, 294, 'Serial_Product', 'DELLU2422HE123471', 26829, 26829, 1, 26829, 1, 4, 1, 'Live'),
(3, 294, 'Serial_Product', 'DELLU2422HE123473', 26829, 26829, 1, 26829, 1, 4, 1, 'Live');

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

--
-- Table structure for table `tbl_purchase_payments`
--

CREATE TABLE `tbl_purchase_payments` (
  `id` int(11) NOT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `purchase_id` int(11) DEFAULT NULL,
  `payment_id` int(11) DEFAULT NULL,
  `amount` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `del_status` varchar(11) NOT NULL DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_purchase_payments`
--

INSERT INTO `tbl_purchase_payments` (`id`, `added_date`, `purchase_id`, `payment_id`, `amount`, `outlet_id`, `user_id`, `company_id`, `del_status`) VALUES
(1, '2024-05-25', 1, 1, 80487, 4, 1, 1, 'Live');

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

--
-- Table structure for table `tbl_purchase_return`
--

CREATE TABLE `tbl_purchase_return` (
  `id` int(11) NOT NULL,
  `reference_no` varchar(55) DEFAULT NULL,
  `pur_ref_no` varchar(55) DEFAULT NULL,
  `date` varchar(30) DEFAULT NULL,
  `purchase_date` varchar(55) DEFAULT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `return_status` varchar(100) DEFAULT NULL,
  `total_return_amount` float DEFAULT NULL,
  `payment_method_id` int(11) NOT NULL DEFAULT 1,
  `payment_method_type` varchar(100) DEFAULT NULL,
  `account_type` varchar(55) DEFAULT NULL,
  `note` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=COMPACT;

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

--
-- Table structure for table `tbl_purchase_return_details`
--

CREATE TABLE `tbl_purchase_return_details` (
  `id` int(11) NOT NULL,
  `pur_return_id` int(11) DEFAULT NULL,
  `item_id` int(11) DEFAULT NULL,
  `item_type` varchar(55) DEFAULT NULL,
  `expiry_imei_serial` varchar(255) DEFAULT NULL,
  `expiry_imei_serial_in` varchar(55) DEFAULT NULL,
  `return_note` varchar(255) DEFAULT NULL,
  `return_quantity_amount` varchar(11) DEFAULT NULL,
  `unit_price` float DEFAULT NULL,
  `total` float DEFAULT NULL,
  `return_status` varchar(100) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=COMPACT;

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

--
-- Table structure for table `tbl_quotations`
--

CREATE TABLE `tbl_quotations` (
  `id` int(11) NOT NULL,
  `reference_no` varchar(55) DEFAULT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `date` varchar(30) DEFAULT NULL,
  `other` float DEFAULT NULL,
  `subtotal` float DEFAULT NULL,
  `grand_total` float DEFAULT NULL,
  `discount` varchar(11) DEFAULT NULL,
  `note` varchar(300) DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `tbl_quotation_details`
--

CREATE TABLE `tbl_quotation_details` (
  `id` int(11) NOT NULL,
  `item_id` int(11) DEFAULT NULL,
  `item_type` varchar(55) DEFAULT NULL,
  `expiry_imei_serial` varchar(255) DEFAULT NULL,
  `unit_price` float DEFAULT NULL,
  `quantity_amount` float DEFAULT NULL,
  `total` float DEFAULT NULL,
  `quotation_id` int(11) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `tbl_racks`
--

CREATE TABLE `tbl_racks` (
  `id` int(11) NOT NULL,
  `name` varchar(55) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `company_id` int(11) UNSIGNED DEFAULT NULL,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `tbl_register`
--

CREATE TABLE `tbl_register` (
  `id` int(11) NOT NULL,
  `opening_balance` float DEFAULT NULL,
  `opening_details` text DEFAULT NULL,
  `closing_balance` float DEFAULT NULL,
  `opening_balance_date_time` varchar(55) DEFAULT NULL,
  `closing_balance_date_time` varchar(55) DEFAULT NULL,
  `sale_paid_amount` float DEFAULT NULL,
  `refund_amount` float DEFAULT NULL,
  `customer_due_receive` float DEFAULT NULL,
  `payment_methods_sale` text NOT NULL,
  `register_status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1=open,2=closed',
  `others_currency` text DEFAULT NULL,
  `total_purchase` float DEFAULT NULL,
  `total_downpayment` float DEFAULT NULL,
  `total_installmentcollection` float DEFAULT NULL,
  `total_servicing` float DEFAULT NULL,
  `total_purchase_return` float DEFAULT NULL,
  `total_due_payment` float DEFAULT NULL,
  `total_expense` float DEFAULT NULL,
  `counter_id` varchar(11) DEFAULT NULL,
  `added_date` varchar(30) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_register`
--

INSERT INTO `tbl_register` (`id`, `opening_balance`, `opening_details`, `closing_balance`, `opening_balance_date_time`, `closing_balance_date_time`, `sale_paid_amount`, `refund_amount`, `customer_due_receive`, `payment_methods_sale`, `register_status`, `others_currency`, `total_purchase`, `total_downpayment`, `total_installmentcollection`, `total_servicing`, `total_purchase_return`, `total_due_payment`, `total_expense`, `counter_id`, `added_date`, `user_id`, `outlet_id`, `company_id`, `del_status`) VALUES
(4, 1000, '[\"1||Bank||0\",\"2||Cash||1000\",\"6||Paypal||0\",\"7||Stripe||0\"]', 0, '2024-05-19 16:55:42', NULL, NULL, NULL, NULL, '', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '15', '2024-05-19 16:55:42', 1, 5, 1, 'Live');

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

--
-- Table structure for table `tbl_roles`
--

CREATE TABLE `tbl_roles` (
  `id` int(11) NOT NULL,
  `role_name` varchar(55) DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `del_status` varchar(11) NOT NULL DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_roles`
--

INSERT INTO `tbl_roles` (`id`, `role_name`, `added_date`, `user_id`, `company_id`, `del_status`) VALUES
(1, 'Admin', '2024-04-26 12:36:07', 1, 1, 'Live'),
(2, 'Manager', '2024-04-26 12:36:21', 1, 1, 'Live'),
(3, 'Cashier', '2024-04-26 12:37:06', 1, 1, 'Live'),
(4, 'Test Role', '2024-05-02 16:47:39', 1, 1, 'Live');

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

--
-- Table structure for table `tbl_role_access`
--

CREATE TABLE `tbl_role_access` (
  `id` int(11) NOT NULL,
  `role_id` int(11) DEFAULT NULL,
  `access_parent_id` int(11) DEFAULT NULL,
  `access_child_id` int(11) DEFAULT NULL,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_role_access`
--

INSERT INTO `tbl_role_access` (`id`, `role_id`, `access_parent_id`, `access_child_id`, `del_status`) VALUES
(1, 1, 333, 334, 'Live'),
(2, 1, 331, 332, 'Live'),
(3, 1, 329, 330, 'Live'),
(4, 1, 327, 328, 'Live'),
(5, 1, 325, 326, 'Live'),
(6, 1, 320, 324, 'Live'),
(7, 1, 320, 321, 'Live'),
(8, 1, 320, 323, 'Live'),
(9, 1, 320, 322, 'Live'),
(10, 1, 335, 336, 'Live'),
(11, 1, 311, 312, 'Live'),
(12, 1, 311, 314, 'Live'),
(13, 1, 311, 313, 'Live'),
(14, 1, 311, 315, 'Live'),
(15, 1, 23, 24, 'Live'),
(16, 1, 19, 20, 'Live'),
(17, 1, 14, 15, 'Live'),
(18, 1, 14, 17, 'Live'),
(19, 1, 14, 16, 'Live'),
(20, 1, 14, 18, 'Live'),
(21, 1, 12, 13, 'Live'),
(22, 1, 10, 11, 'Live'),
(23, 1, 8, 9, 'Live'),
(24, 1, 3, 4, 'Live'),
(25, 1, 3, 6, 'Live'),
(26, 1, 3, 5, 'Live'),
(27, 1, 3, 7, 'Live'),
(28, 1, 1, 2, 'Live'),
(29, 1, 21, 22, 'Live'),
(30, 1, 25, 26, 'Live'),
(31, 1, 25, 28, 'Live'),
(32, 1, 25, 27, 'Live'),
(33, 1, 25, 29, 'Live'),
(34, 1, 30, 31, 'Live'),
(35, 1, 32, 33, 'Live'),
(36, 1, 32, 35, 'Live'),
(37, 1, 32, 34, 'Live'),
(38, 1, 32, 36, 'Live'),
(39, 1, 47, 48, 'Live'),
(40, 1, 42, 43, 'Live'),
(41, 1, 42, 45, 'Live'),
(42, 1, 42, 44, 'Live'),
(43, 1, 42, 46, 'Live'),
(44, 1, 37, 38, 'Live'),
(45, 1, 37, 40, 'Live'),
(46, 1, 37, 39, 'Live'),
(47, 1, 37, 41, 'Live'),
(48, 1, 49, 50, 'Live'),
(49, 1, 49, 57, 'Live'),
(50, 1, 49, 55, 'Live'),
(51, 1, 49, 56, 'Live'),
(52, 1, 49, 53, 'Live'),
(53, 1, 49, 51, 'Live'),
(54, 1, 49, 54, 'Live'),
(55, 1, 49, 58, 'Live'),
(56, 1, 49, 59, 'Live'),
(57, 1, 49, 52, 'Live'),
(58, 1, 70, 71, 'Live'),
(59, 1, 70, 73, 'Live'),
(60, 1, 70, 72, 'Live'),
(61, 1, 70, 74, 'Live'),
(62, 1, 304, 305, 'Live'),
(63, 1, 304, 307, 'Live'),
(64, 1, 304, 306, 'Live'),
(65, 1, 304, 308, 'Live'),
(66, 1, 302, 303, 'Live'),
(67, 1, 297, 298, 'Live'),
(68, 1, 297, 300, 'Live'),
(69, 1, 297, 299, 'Live'),
(70, 1, 297, 301, 'Live'),
(71, 1, 60, 61, 'Live'),
(72, 1, 60, 63, 'Live'),
(73, 1, 60, 62, 'Live'),
(74, 1, 60, 64, 'Live'),
(75, 1, 65, 66, 'Live'),
(76, 1, 65, 68, 'Live'),
(77, 1, 65, 67, 'Live'),
(78, 1, 65, 69, 'Live'),
(79, 1, 75, 76, 'Live'),
(80, 1, 75, 78, 'Live'),
(81, 1, 75, 77, 'Live'),
(82, 1, 75, 79, 'Live'),
(83, 1, 75, 310, 'Live'),
(84, 1, 75, 309, 'Live'),
(85, 1, 80, 81, 'Live'),
(86, 1, 80, 83, 'Live'),
(87, 1, 80, 82, 'Live'),
(88, 1, 80, 84, 'Live'),
(89, 1, 85, 86, 'Live'),
(90, 1, 87, 88, 'Live'),
(91, 1, 87, 90, 'Live'),
(92, 1, 87, 89, 'Live'),
(93, 1, 87, 91, 'Live'),
(94, 1, 87, 92, 'Live'),
(95, 1, 93, 94, 'Live'),
(96, 1, 93, 97, 'Live'),
(97, 1, 93, 95, 'Live'),
(98, 1, 93, 98, 'Live'),
(99, 1, 93, 99, 'Live'),
(100, 1, 93, 96, 'Live'),
(101, 1, 100, 101, 'Live'),
(102, 1, 100, 104, 'Live'),
(103, 1, 100, 108, 'Live'),
(104, 1, 100, 102, 'Live'),
(105, 1, 100, 107, 'Live'),
(106, 1, 100, 105, 'Live'),
(107, 1, 100, 106, 'Live'),
(108, 1, 100, 103, 'Live'),
(109, 1, 125, 126, 'Live'),
(110, 1, 125, 132, 'Live'),
(111, 1, 125, 129, 'Live'),
(112, 1, 125, 127, 'Live'),
(113, 1, 125, 130, 'Live'),
(114, 1, 125, 131, 'Live'),
(115, 1, 125, 128, 'Live'),
(116, 1, 117, 118, 'Live'),
(117, 1, 117, 124, 'Live'),
(118, 1, 117, 123, 'Live'),
(119, 1, 117, 121, 'Live'),
(120, 1, 117, 119, 'Live'),
(121, 1, 117, 122, 'Live'),
(122, 1, 117, 120, 'Live'),
(123, 1, 109, 110, 'Live'),
(124, 1, 109, 113, 'Live'),
(125, 1, 109, 111, 'Live'),
(126, 1, 109, 114, 'Live'),
(127, 1, 109, 116, 'Live'),
(128, 1, 109, 115, 'Live'),
(129, 1, 109, 112, 'Live'),
(130, 1, 138, 140, 'Live'),
(131, 1, 138, 142, 'Live'),
(132, 1, 138, 146, 'Live'),
(133, 1, 138, 141, 'Live'),
(134, 1, 138, 143, 'Live'),
(135, 1, 138, 139, 'Live'),
(136, 1, 138, 145, 'Live'),
(137, 1, 138, 144, 'Live'),
(138, 1, 159, 160, 'Live'),
(139, 1, 159, 162, 'Live'),
(140, 1, 159, 161, 'Live'),
(141, 1, 159, 163, 'Live'),
(142, 1, 154, 155, 'Live'),
(143, 1, 154, 157, 'Live'),
(144, 1, 154, 156, 'Live'),
(145, 1, 154, 158, 'Live'),
(146, 1, 147, 148, 'Live'),
(147, 1, 147, 153, 'Live'),
(148, 1, 147, 151, 'Live'),
(149, 1, 147, 149, 'Live'),
(150, 1, 147, 152, 'Live'),
(151, 1, 147, 150, 'Live'),
(152, 1, 133, 134, 'Live'),
(153, 1, 133, 136, 'Live'),
(154, 1, 133, 135, 'Live'),
(155, 1, 133, 137, 'Live'),
(156, 1, 164, 165, 'Live'),
(157, 1, 166, 167, 'Live'),
(158, 1, 166, 170, 'Live'),
(159, 1, 166, 168, 'Live'),
(160, 1, 166, 171, 'Live'),
(161, 1, 166, 169, 'Live'),
(162, 1, 177, 178, 'Live'),
(163, 1, 177, 180, 'Live'),
(164, 1, 177, 179, 'Live'),
(165, 1, 177, 181, 'Live'),
(166, 1, 172, 173, 'Live'),
(167, 1, 172, 175, 'Live'),
(168, 1, 172, 174, 'Live'),
(169, 1, 172, 176, 'Live'),
(170, 1, 182, 183, 'Live'),
(171, 1, 182, 185, 'Live'),
(172, 1, 182, 184, 'Live'),
(173, 1, 182, 186, 'Live'),
(174, 1, 187, 188, 'Live'),
(175, 1, 187, 190, 'Live'),
(176, 1, 187, 189, 'Live'),
(177, 1, 187, 191, 'Live'),
(178, 1, 192, 193, 'Live'),
(179, 1, 192, 195, 'Live'),
(180, 1, 192, 194, 'Live'),
(181, 1, 192, 196, 'Live'),
(182, 1, 192, 197, 'Live'),
(183, 1, 198, 199, 'Live'),
(184, 1, 198, 201, 'Live'),
(185, 1, 198, 200, 'Live'),
(186, 1, 198, 202, 'Live'),
(187, 1, 198, 203, 'Live'),
(188, 1, 204, 205, 'Live'),
(189, 1, 204, 208, 'Live'),
(190, 1, 204, 206, 'Live'),
(191, 1, 204, 209, 'Live'),
(192, 1, 204, 210, 'Live'),
(193, 1, 204, 207, 'Live'),
(194, 1, 211, 212, 'Live'),
(195, 1, 211, 215, 'Live'),
(196, 1, 211, 213, 'Live'),
(197, 1, 211, 216, 'Live'),
(198, 1, 211, 217, 'Live'),
(199, 1, 211, 214, 'Live'),
(200, 1, 230, 231, 'Live'),
(201, 1, 228, 229, 'Live'),
(202, 1, 223, 224, 'Live'),
(203, 1, 223, 226, 'Live'),
(204, 1, 223, 225, 'Live'),
(205, 1, 223, 227, 'Live'),
(206, 1, 232, 233, 'Live'),
(207, 1, 218, 219, 'Live'),
(208, 1, 218, 221, 'Live'),
(209, 1, 218, 220, 'Live'),
(210, 1, 218, 222, 'Live'),
(211, 1, 234, 235, 'Live'),
(212, 1, 234, 237, 'Live'),
(213, 1, 234, 236, 'Live'),
(214, 1, 234, 238, 'Live'),
(215, 1, 239, 240, 'Live'),
(216, 1, 239, 245, 'Live'),
(217, 1, 239, 243, 'Live'),
(218, 1, 239, 241, 'Live'),
(219, 1, 239, 244, 'Live'),
(220, 1, 239, 246, 'Live'),
(221, 1, 239, 242, 'Live'),
(222, 1, 318, 319, 'Live'),
(223, 1, 247, 248, 'Live'),
(224, 1, 249, 262, 'Live'),
(225, 1, 249, 281, 'Live'),
(226, 1, 249, 265, 'Live'),
(227, 1, 249, 266, 'Live'),
(228, 1, 249, 251, 'Live'),
(229, 1, 249, 252, 'Live'),
(230, 1, 249, 274, 'Live'),
(231, 1, 249, 257, 'Live'),
(232, 1, 249, 255, 'Live'),
(233, 1, 249, 269, 'Live'),
(234, 1, 249, 270, 'Live'),
(235, 1, 249, 276, 'Live'),
(236, 1, 249, 275, 'Live'),
(237, 1, 249, 279, 'Live'),
(238, 1, 249, 259, 'Live'),
(239, 1, 249, 280, 'Live'),
(240, 1, 249, 261, 'Live'),
(241, 1, 249, 268, 'Live'),
(242, 1, 249, 256, 'Live'),
(243, 1, 249, 260, 'Live'),
(244, 1, 249, 267, 'Live'),
(245, 1, 249, 272, 'Live'),
(246, 1, 249, 250, 'Live'),
(247, 1, 249, 271, 'Live'),
(248, 1, 249, 253, 'Live'),
(249, 1, 249, 273, 'Live'),
(250, 1, 249, 254, 'Live'),
(251, 1, 249, 278, 'Live'),
(252, 1, 249, 258, 'Live'),
(253, 1, 249, 264, 'Live'),
(254, 1, 249, 263, 'Live'),
(255, 1, 249, 277, 'Live'),
(256, 1, 249, 316, 'Live'),
(257, 1, 287, 295, 'Live'),
(258, 1, 287, 288, 'Live'),
(259, 1, 287, 293, 'Live'),
(260, 1, 287, 292, 'Live'),
(261, 1, 287, 296, 'Live'),
(262, 1, 287, 290, 'Live'),
(263, 1, 287, 317, 'Live'),
(264, 1, 287, 289, 'Live'),
(265, 1, 287, 291, 'Live'),
(266, 1, 287, 294, 'Live'),
(267, 1, 282, 283, 'Live'),
(268, 1, 282, 285, 'Live'),
(269, 1, 282, 284, 'Live'),
(270, 1, 282, 286, 'Live'),
(271, 2, 333, 334, 'Live'),
(272, 2, 331, 332, 'Live'),
(273, 2, 329, 330, 'Live'),
(274, 2, 327, 328, 'Live'),
(275, 2, 325, 326, 'Live'),
(276, 2, 320, 324, 'Live'),
(277, 2, 320, 321, 'Live'),
(278, 2, 320, 323, 'Live'),
(279, 2, 320, 322, 'Live'),
(280, 2, 335, 336, 'Live'),
(281, 2, 311, 312, 'Live'),
(282, 2, 311, 314, 'Live'),
(283, 2, 311, 313, 'Live'),
(284, 2, 311, 315, 'Live'),
(285, 2, 23, 24, 'Live'),
(286, 2, 19, 20, 'Live'),
(287, 2, 14, 15, 'Live'),
(288, 2, 14, 17, 'Live'),
(289, 2, 14, 16, 'Live'),
(290, 2, 14, 18, 'Live'),
(291, 2, 12, 13, 'Live'),
(292, 2, 10, 11, 'Live'),
(293, 2, 8, 9, 'Live'),
(294, 2, 3, 4, 'Live'),
(295, 2, 3, 6, 'Live'),
(296, 2, 3, 5, 'Live'),
(297, 2, 3, 7, 'Live'),
(298, 2, 1, 2, 'Live'),
(299, 2, 21, 22, 'Live'),
(300, 2, 25, 26, 'Live'),
(301, 2, 25, 28, 'Live'),
(302, 2, 25, 27, 'Live'),
(303, 2, 25, 29, 'Live'),
(304, 2, 30, 31, 'Live'),
(305, 2, 32, 33, 'Live'),
(306, 2, 32, 35, 'Live'),
(307, 2, 32, 34, 'Live'),
(308, 2, 32, 36, 'Live'),
(309, 2, 47, 48, 'Live'),
(310, 2, 42, 43, 'Live'),
(311, 2, 42, 45, 'Live'),
(312, 2, 42, 44, 'Live'),
(313, 2, 42, 46, 'Live'),
(314, 2, 37, 38, 'Live'),
(315, 2, 37, 40, 'Live'),
(316, 2, 37, 39, 'Live'),
(317, 2, 37, 41, 'Live'),
(318, 2, 49, 50, 'Live'),
(319, 2, 49, 57, 'Live'),
(320, 2, 49, 55, 'Live'),
(321, 2, 49, 56, 'Live'),
(322, 2, 49, 53, 'Live'),
(323, 2, 49, 51, 'Live'),
(324, 2, 49, 54, 'Live'),
(325, 2, 49, 58, 'Live'),
(326, 2, 49, 59, 'Live'),
(327, 2, 49, 52, 'Live'),
(328, 2, 70, 71, 'Live'),
(329, 2, 70, 73, 'Live'),
(330, 2, 70, 72, 'Live'),
(331, 2, 70, 74, 'Live'),
(332, 2, 304, 305, 'Live'),
(333, 2, 304, 307, 'Live'),
(334, 2, 304, 306, 'Live'),
(335, 2, 304, 308, 'Live'),
(336, 2, 302, 303, 'Live'),
(337, 2, 297, 298, 'Live'),
(338, 2, 297, 300, 'Live'),
(339, 2, 297, 299, 'Live'),
(340, 2, 297, 301, 'Live'),
(341, 2, 60, 61, 'Live'),
(342, 2, 60, 63, 'Live'),
(343, 2, 60, 62, 'Live'),
(344, 2, 60, 64, 'Live'),
(345, 2, 65, 66, 'Live'),
(346, 2, 65, 68, 'Live'),
(347, 2, 65, 67, 'Live'),
(348, 2, 65, 69, 'Live'),
(349, 2, 75, 76, 'Live'),
(350, 2, 75, 78, 'Live'),
(351, 2, 75, 77, 'Live'),
(352, 2, 75, 79, 'Live'),
(353, 2, 75, 310, 'Live'),
(354, 2, 75, 309, 'Live'),
(355, 2, 80, 81, 'Live'),
(356, 2, 80, 83, 'Live'),
(357, 2, 80, 82, 'Live'),
(358, 2, 80, 84, 'Live'),
(359, 2, 85, 86, 'Live'),
(360, 2, 87, 88, 'Live'),
(361, 2, 87, 90, 'Live'),
(362, 2, 87, 89, 'Live'),
(363, 2, 87, 91, 'Live'),
(364, 2, 87, 92, 'Live'),
(365, 2, 93, 94, 'Live'),
(366, 2, 93, 97, 'Live'),
(367, 2, 93, 95, 'Live'),
(368, 2, 93, 98, 'Live'),
(369, 2, 93, 99, 'Live'),
(370, 2, 93, 96, 'Live'),
(371, 2, 100, 101, 'Live'),
(372, 2, 100, 104, 'Live'),
(373, 2, 100, 108, 'Live'),
(374, 2, 100, 102, 'Live'),
(375, 2, 100, 107, 'Live'),
(376, 2, 100, 105, 'Live'),
(377, 2, 100, 106, 'Live'),
(378, 2, 100, 103, 'Live'),
(379, 2, 125, 126, 'Live'),
(380, 2, 125, 132, 'Live'),
(381, 2, 125, 129, 'Live'),
(382, 2, 125, 127, 'Live'),
(383, 2, 125, 130, 'Live'),
(384, 2, 125, 131, 'Live'),
(385, 2, 125, 128, 'Live'),
(386, 2, 117, 118, 'Live'),
(387, 2, 117, 124, 'Live'),
(388, 2, 117, 123, 'Live'),
(389, 2, 117, 121, 'Live'),
(390, 2, 117, 119, 'Live'),
(391, 2, 117, 122, 'Live'),
(392, 2, 117, 120, 'Live'),
(393, 2, 109, 110, 'Live'),
(394, 2, 109, 113, 'Live'),
(395, 2, 109, 111, 'Live'),
(396, 2, 109, 114, 'Live'),
(397, 2, 109, 116, 'Live'),
(398, 2, 109, 115, 'Live'),
(399, 2, 109, 112, 'Live'),
(400, 2, 138, 140, 'Live'),
(401, 2, 138, 142, 'Live'),
(402, 2, 138, 146, 'Live'),
(403, 2, 138, 141, 'Live'),
(404, 2, 138, 143, 'Live'),
(405, 2, 138, 139, 'Live'),
(406, 2, 138, 145, 'Live'),
(407, 2, 138, 144, 'Live'),
(408, 2, 159, 160, 'Live'),
(409, 2, 159, 162, 'Live'),
(410, 2, 159, 161, 'Live'),
(411, 2, 159, 163, 'Live'),
(412, 2, 154, 155, 'Live'),
(413, 2, 154, 157, 'Live'),
(414, 2, 154, 156, 'Live'),
(415, 2, 154, 158, 'Live'),
(416, 2, 147, 148, 'Live'),
(417, 2, 147, 153, 'Live'),
(418, 2, 147, 151, 'Live'),
(419, 2, 147, 149, 'Live'),
(420, 2, 147, 152, 'Live'),
(421, 2, 147, 150, 'Live'),
(422, 2, 133, 134, 'Live'),
(423, 2, 133, 136, 'Live'),
(424, 2, 133, 135, 'Live'),
(425, 2, 133, 137, 'Live'),
(426, 2, 164, 165, 'Live'),
(427, 2, 166, 167, 'Live'),
(428, 2, 166, 170, 'Live'),
(429, 2, 166, 168, 'Live'),
(430, 2, 166, 171, 'Live'),
(431, 2, 166, 169, 'Live'),
(432, 2, 177, 178, 'Live'),
(433, 2, 177, 180, 'Live'),
(434, 2, 177, 179, 'Live'),
(435, 2, 177, 181, 'Live'),
(436, 2, 172, 173, 'Live'),
(437, 2, 172, 175, 'Live'),
(438, 2, 172, 174, 'Live'),
(439, 2, 172, 176, 'Live'),
(440, 2, 182, 183, 'Live'),
(441, 2, 182, 185, 'Live'),
(442, 2, 182, 184, 'Live'),
(443, 2, 182, 186, 'Live'),
(444, 2, 187, 188, 'Live'),
(445, 2, 187, 190, 'Live'),
(446, 2, 187, 189, 'Live'),
(447, 2, 187, 191, 'Live'),
(448, 2, 192, 193, 'Live'),
(449, 2, 192, 195, 'Live'),
(450, 2, 192, 194, 'Live'),
(451, 2, 192, 196, 'Live'),
(452, 2, 192, 197, 'Live'),
(453, 2, 198, 199, 'Live'),
(454, 2, 198, 201, 'Live'),
(455, 2, 198, 200, 'Live'),
(456, 2, 198, 202, 'Live'),
(457, 2, 198, 203, 'Live'),
(458, 2, 204, 205, 'Live'),
(459, 2, 204, 208, 'Live'),
(460, 2, 204, 206, 'Live'),
(461, 2, 204, 209, 'Live'),
(462, 2, 204, 210, 'Live'),
(463, 2, 204, 207, 'Live'),
(464, 2, 211, 212, 'Live'),
(465, 2, 211, 215, 'Live'),
(466, 2, 211, 213, 'Live'),
(467, 2, 211, 216, 'Live'),
(468, 2, 211, 217, 'Live'),
(469, 2, 211, 214, 'Live'),
(470, 2, 230, 231, 'Live'),
(471, 2, 228, 229, 'Live'),
(472, 2, 223, 224, 'Live'),
(473, 2, 223, 226, 'Live'),
(474, 2, 223, 225, 'Live'),
(475, 2, 223, 227, 'Live'),
(476, 2, 232, 233, 'Live'),
(477, 2, 218, 219, 'Live'),
(478, 2, 218, 221, 'Live'),
(479, 2, 218, 220, 'Live'),
(480, 2, 218, 222, 'Live'),
(481, 2, 234, 235, 'Live'),
(482, 2, 234, 237, 'Live'),
(483, 2, 234, 236, 'Live'),
(484, 2, 234, 238, 'Live'),
(485, 2, 239, 240, 'Live'),
(486, 2, 239, 245, 'Live'),
(487, 2, 239, 243, 'Live'),
(488, 2, 239, 241, 'Live'),
(489, 2, 239, 244, 'Live'),
(490, 2, 239, 246, 'Live'),
(491, 2, 239, 242, 'Live'),
(492, 2, 318, 319, 'Live'),
(493, 2, 247, 248, 'Live'),
(494, 2, 249, 262, 'Live'),
(495, 2, 249, 281, 'Live'),
(496, 2, 249, 265, 'Live'),
(497, 2, 249, 266, 'Live'),
(498, 2, 249, 251, 'Live'),
(499, 2, 249, 252, 'Live'),
(500, 2, 249, 274, 'Live'),
(501, 2, 249, 257, 'Live'),
(502, 2, 249, 255, 'Live'),
(503, 2, 249, 269, 'Live'),
(504, 2, 249, 270, 'Live'),
(505, 2, 249, 276, 'Live'),
(506, 2, 249, 275, 'Live'),
(507, 2, 249, 279, 'Live'),
(508, 2, 249, 259, 'Live'),
(509, 2, 249, 280, 'Live'),
(510, 2, 249, 261, 'Live'),
(511, 2, 249, 268, 'Live'),
(512, 2, 249, 256, 'Live'),
(513, 2, 249, 260, 'Live'),
(514, 2, 249, 267, 'Live'),
(515, 2, 249, 272, 'Live'),
(516, 2, 249, 250, 'Live'),
(517, 2, 249, 271, 'Live'),
(518, 2, 249, 253, 'Live'),
(519, 2, 249, 273, 'Live'),
(520, 2, 249, 254, 'Live'),
(521, 2, 249, 278, 'Live'),
(522, 2, 249, 258, 'Live'),
(523, 2, 249, 264, 'Live'),
(524, 2, 249, 263, 'Live'),
(525, 2, 249, 277, 'Live'),
(526, 2, 249, 316, 'Live'),
(527, 2, 287, 295, 'Live'),
(528, 2, 287, 288, 'Live'),
(529, 2, 287, 293, 'Live'),
(530, 2, 287, 292, 'Live'),
(531, 2, 287, 296, 'Live'),
(532, 2, 287, 290, 'Live'),
(533, 2, 287, 317, 'Live'),
(534, 2, 287, 289, 'Live'),
(535, 2, 287, 291, 'Live'),
(536, 2, 287, 294, 'Live'),
(537, 2, 282, 283, 'Live'),
(538, 2, 282, 285, 'Live'),
(539, 2, 282, 284, 'Live'),
(540, 2, 282, 286, 'Live'),
(541, 3, 333, 334, 'Live'),
(542, 3, 331, 332, 'Live'),
(543, 3, 329, 330, 'Live'),
(544, 3, 327, 328, 'Live'),
(545, 3, 325, 326, 'Live'),
(546, 3, 320, 324, 'Live'),
(547, 3, 320, 321, 'Live'),
(548, 3, 320, 323, 'Live'),
(549, 3, 320, 322, 'Live'),
(550, 3, 335, 336, 'Live'),
(551, 3, 311, 312, 'Live'),
(552, 3, 311, 314, 'Live'),
(553, 3, 311, 313, 'Live'),
(554, 3, 311, 315, 'Live'),
(555, 3, 23, 24, 'Live'),
(556, 3, 19, 20, 'Live'),
(557, 3, 14, 15, 'Live'),
(558, 3, 14, 17, 'Live'),
(559, 3, 14, 16, 'Live'),
(560, 3, 14, 18, 'Live'),
(561, 3, 12, 13, 'Live'),
(562, 3, 10, 11, 'Live'),
(563, 3, 8, 9, 'Live'),
(564, 3, 3, 4, 'Live'),
(565, 3, 3, 6, 'Live'),
(566, 3, 3, 5, 'Live'),
(567, 3, 3, 7, 'Live'),
(568, 3, 1, 2, 'Live'),
(569, 3, 21, 22, 'Live'),
(570, 3, 25, 26, 'Live'),
(571, 3, 25, 28, 'Live'),
(572, 3, 25, 27, 'Live'),
(573, 3, 25, 29, 'Live'),
(574, 3, 30, 31, 'Live'),
(575, 3, 32, 33, 'Live'),
(576, 3, 32, 35, 'Live'),
(577, 3, 32, 34, 'Live'),
(578, 3, 32, 36, 'Live'),
(579, 3, 47, 48, 'Live'),
(580, 3, 42, 43, 'Live'),
(581, 3, 42, 45, 'Live'),
(582, 3, 42, 44, 'Live'),
(583, 3, 42, 46, 'Live'),
(584, 3, 37, 38, 'Live'),
(585, 3, 37, 40, 'Live'),
(586, 3, 37, 39, 'Live'),
(587, 3, 37, 41, 'Live'),
(588, 3, 49, 50, 'Live'),
(589, 3, 49, 57, 'Live'),
(590, 3, 49, 55, 'Live'),
(591, 3, 49, 56, 'Live'),
(592, 3, 49, 53, 'Live'),
(593, 3, 49, 51, 'Live'),
(594, 3, 49, 54, 'Live'),
(595, 3, 49, 58, 'Live'),
(596, 3, 49, 59, 'Live'),
(597, 3, 49, 52, 'Live'),
(598, 3, 70, 71, 'Live'),
(599, 3, 70, 73, 'Live'),
(600, 3, 70, 72, 'Live'),
(601, 3, 70, 74, 'Live'),
(602, 3, 304, 305, 'Live'),
(603, 3, 304, 307, 'Live'),
(604, 3, 304, 306, 'Live'),
(605, 3, 304, 308, 'Live'),
(606, 3, 302, 303, 'Live'),
(607, 3, 297, 298, 'Live'),
(608, 3, 297, 300, 'Live'),
(609, 3, 297, 299, 'Live'),
(610, 3, 297, 301, 'Live'),
(611, 3, 60, 61, 'Live'),
(612, 3, 60, 63, 'Live'),
(613, 3, 60, 62, 'Live'),
(614, 3, 60, 64, 'Live'),
(615, 3, 65, 66, 'Live'),
(616, 3, 65, 68, 'Live'),
(617, 3, 65, 67, 'Live'),
(618, 3, 65, 69, 'Live'),
(619, 3, 75, 76, 'Live'),
(620, 3, 75, 78, 'Live'),
(621, 3, 75, 77, 'Live'),
(622, 3, 75, 79, 'Live'),
(623, 3, 75, 310, 'Live'),
(624, 3, 75, 309, 'Live'),
(625, 3, 80, 81, 'Live'),
(626, 3, 80, 83, 'Live'),
(627, 3, 80, 82, 'Live'),
(628, 3, 80, 84, 'Live'),
(629, 3, 85, 86, 'Live'),
(630, 3, 87, 88, 'Live'),
(631, 3, 87, 90, 'Live'),
(632, 3, 87, 89, 'Live'),
(633, 3, 87, 91, 'Live'),
(634, 3, 87, 92, 'Live'),
(635, 3, 93, 94, 'Live'),
(636, 3, 93, 97, 'Live'),
(637, 3, 93, 95, 'Live'),
(638, 3, 93, 98, 'Live'),
(639, 3, 93, 99, 'Live'),
(640, 3, 93, 96, 'Live'),
(641, 3, 100, 101, 'Live'),
(642, 3, 100, 104, 'Live'),
(643, 3, 100, 108, 'Live'),
(644, 3, 100, 102, 'Live'),
(645, 3, 100, 107, 'Live'),
(646, 3, 100, 105, 'Live'),
(647, 3, 100, 106, 'Live'),
(648, 3, 100, 103, 'Live'),
(649, 3, 125, 126, 'Live'),
(650, 3, 125, 132, 'Live'),
(651, 3, 125, 129, 'Live'),
(652, 3, 125, 127, 'Live'),
(653, 3, 125, 130, 'Live'),
(654, 3, 125, 131, 'Live'),
(655, 3, 125, 128, 'Live'),
(656, 3, 117, 118, 'Live'),
(657, 3, 117, 124, 'Live'),
(658, 3, 117, 123, 'Live'),
(659, 3, 117, 121, 'Live'),
(660, 3, 117, 119, 'Live'),
(661, 3, 117, 122, 'Live'),
(662, 3, 117, 120, 'Live'),
(663, 3, 109, 110, 'Live'),
(664, 3, 109, 113, 'Live'),
(665, 3, 109, 111, 'Live'),
(666, 3, 109, 114, 'Live'),
(667, 3, 109, 116, 'Live'),
(668, 3, 109, 115, 'Live'),
(669, 3, 109, 112, 'Live'),
(670, 3, 138, 140, 'Live'),
(671, 3, 138, 142, 'Live'),
(672, 3, 138, 146, 'Live'),
(673, 3, 138, 141, 'Live'),
(674, 3, 138, 143, 'Live'),
(675, 3, 138, 139, 'Live'),
(676, 3, 138, 145, 'Live'),
(677, 3, 138, 144, 'Live'),
(678, 3, 159, 160, 'Live'),
(679, 3, 159, 162, 'Live'),
(680, 3, 159, 161, 'Live'),
(681, 3, 159, 163, 'Live'),
(682, 3, 154, 155, 'Live'),
(683, 3, 154, 157, 'Live'),
(684, 3, 154, 156, 'Live'),
(685, 3, 154, 158, 'Live'),
(686, 3, 147, 148, 'Live'),
(687, 3, 147, 153, 'Live'),
(688, 3, 147, 151, 'Live'),
(689, 3, 147, 149, 'Live'),
(690, 3, 147, 152, 'Live'),
(691, 3, 147, 150, 'Live'),
(692, 3, 133, 134, 'Live'),
(693, 3, 133, 136, 'Live'),
(694, 3, 133, 135, 'Live'),
(695, 3, 133, 137, 'Live'),
(696, 3, 164, 165, 'Live'),
(697, 3, 166, 167, 'Live'),
(698, 3, 166, 170, 'Live'),
(699, 3, 166, 168, 'Live'),
(700, 3, 166, 171, 'Live'),
(701, 3, 166, 169, 'Live'),
(702, 3, 177, 178, 'Live'),
(703, 3, 177, 180, 'Live'),
(704, 3, 177, 179, 'Live'),
(705, 3, 177, 181, 'Live'),
(706, 3, 172, 173, 'Live'),
(707, 3, 172, 175, 'Live'),
(708, 3, 172, 174, 'Live'),
(709, 3, 172, 176, 'Live'),
(710, 3, 182, 183, 'Live'),
(711, 3, 182, 185, 'Live'),
(712, 3, 182, 184, 'Live'),
(713, 3, 182, 186, 'Live'),
(714, 3, 187, 188, 'Live'),
(715, 3, 187, 190, 'Live'),
(716, 3, 187, 189, 'Live'),
(717, 3, 187, 191, 'Live'),
(718, 3, 192, 193, 'Live'),
(719, 3, 192, 195, 'Live'),
(720, 3, 192, 194, 'Live'),
(721, 3, 192, 196, 'Live'),
(722, 3, 192, 197, 'Live'),
(723, 3, 198, 199, 'Live'),
(724, 3, 198, 201, 'Live'),
(725, 3, 198, 200, 'Live'),
(726, 3, 198, 202, 'Live'),
(727, 3, 198, 203, 'Live'),
(728, 3, 204, 205, 'Live'),
(729, 3, 204, 208, 'Live'),
(730, 3, 204, 206, 'Live'),
(731, 3, 204, 209, 'Live'),
(732, 3, 204, 210, 'Live'),
(733, 3, 204, 207, 'Live'),
(734, 3, 211, 212, 'Live'),
(735, 3, 211, 215, 'Live'),
(736, 3, 211, 213, 'Live'),
(737, 3, 211, 216, 'Live'),
(738, 3, 211, 217, 'Live'),
(739, 3, 211, 214, 'Live'),
(740, 3, 230, 231, 'Live'),
(741, 3, 228, 229, 'Live'),
(742, 3, 223, 224, 'Live'),
(743, 3, 223, 226, 'Live'),
(744, 3, 223, 225, 'Live'),
(745, 3, 223, 227, 'Live'),
(746, 3, 232, 233, 'Live'),
(747, 3, 218, 219, 'Live'),
(748, 3, 218, 221, 'Live'),
(749, 3, 218, 220, 'Live'),
(750, 3, 218, 222, 'Live'),
(751, 3, 234, 235, 'Live'),
(752, 3, 234, 237, 'Live'),
(753, 3, 234, 236, 'Live'),
(754, 3, 234, 238, 'Live'),
(755, 3, 239, 240, 'Live'),
(756, 3, 239, 245, 'Live'),
(757, 3, 239, 243, 'Live'),
(758, 3, 239, 241, 'Live'),
(759, 3, 239, 244, 'Live'),
(760, 3, 239, 246, 'Live'),
(761, 3, 239, 242, 'Live'),
(762, 3, 318, 319, 'Live'),
(763, 3, 247, 248, 'Live'),
(764, 3, 249, 262, 'Live'),
(765, 3, 249, 281, 'Live'),
(766, 3, 249, 265, 'Live'),
(767, 3, 249, 266, 'Live'),
(768, 3, 249, 251, 'Live'),
(769, 3, 249, 252, 'Live'),
(770, 3, 249, 274, 'Live'),
(771, 3, 249, 257, 'Live'),
(772, 3, 249, 255, 'Live'),
(773, 3, 249, 269, 'Live'),
(774, 3, 249, 270, 'Live'),
(775, 3, 249, 276, 'Live'),
(776, 3, 249, 275, 'Live'),
(777, 3, 249, 279, 'Live'),
(778, 3, 249, 259, 'Live'),
(779, 3, 249, 280, 'Live'),
(780, 3, 249, 261, 'Live'),
(781, 3, 249, 268, 'Live'),
(782, 3, 249, 256, 'Live'),
(783, 3, 249, 260, 'Live'),
(784, 3, 249, 267, 'Live'),
(785, 3, 249, 272, 'Live'),
(786, 3, 249, 250, 'Live'),
(787, 3, 249, 271, 'Live'),
(788, 3, 249, 253, 'Live'),
(789, 3, 249, 273, 'Live'),
(790, 3, 249, 254, 'Live'),
(791, 3, 249, 278, 'Live'),
(792, 3, 249, 258, 'Live'),
(793, 3, 249, 264, 'Live'),
(794, 3, 249, 263, 'Live'),
(795, 3, 249, 277, 'Live'),
(796, 3, 249, 316, 'Live'),
(797, 3, 287, 295, 'Live'),
(798, 3, 287, 288, 'Live'),
(799, 3, 287, 293, 'Live'),
(800, 3, 287, 292, 'Live'),
(801, 3, 287, 296, 'Live'),
(802, 3, 287, 290, 'Live'),
(803, 3, 287, 317, 'Live'),
(804, 3, 287, 289, 'Live'),
(805, 3, 287, 291, 'Live'),
(806, 3, 287, 294, 'Live'),
(807, 3, 282, 283, 'Live'),
(808, 3, 282, 285, 'Live'),
(809, 3, 282, 284, 'Live'),
(810, 3, 282, 286, 'Live'),
(811, 4, 30, 31, 'Deleted'),
(812, 4, 25, 29, 'Live'),
(813, 4, 30, 31, 'Live');

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

--
-- Table structure for table `tbl_salaries`
--

CREATE TABLE `tbl_salaries` (
  `id` int(11) NOT NULL,
  `month` varchar(11) DEFAULT NULL,
  `month_no` int(11) DEFAULT NULL,
  `year` varchar(11) DEFAULT NULL,
  `date` varchar(30) DEFAULT NULL,
  `total_amount` float DEFAULT NULL,
  `details_info` mediumtext DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `payment_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `tbl_sales`
--

CREATE TABLE `tbl_sales` (
  `id` bigint(55) NOT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `employee_id` int(11) DEFAULT NULL,
  `sale_no` varchar(55) NOT NULL DEFAULT '000000',
  `total_items` int(11) DEFAULT NULL,
  `sub_total` float DEFAULT NULL,
  `paid_amount` float DEFAULT NULL,
  `previous_due` float DEFAULT NULL,
  `due_amount` float DEFAULT NULL,
  `disc` varchar(11) DEFAULT NULL,
  `disc_actual` float DEFAULT NULL,
  `vat` float DEFAULT NULL,
  `rounding` float DEFAULT NULL,
  `total_payable` float DEFAULT NULL,
  `close_time` varchar(30) DEFAULT NULL,
  `total_item_discount_amount` float DEFAULT NULL,
  `sub_total_with_discount` float DEFAULT NULL,
  `sub_total_discount_amount` float DEFAULT NULL,
  `total_discount_amount` float DEFAULT NULL,
  `delivery_charge` float DEFAULT NULL,
  `charge_type` varchar(55) DEFAULT NULL,
  `sub_total_discount_value` varchar(11) NOT NULL,
  `sub_total_discount_type` varchar(20) NOT NULL,
  `sale_date` varchar(20) NOT NULL,
  `date_time` varchar(30) DEFAULT NULL,
  `order_time` varchar(30) DEFAULT NULL,
  `grand_total` float DEFAULT NULL,
  `online_yes_no` tinyint(4) NOT NULL DEFAULT 1 COMMENT '1-POS NO,2-Online Yes',
  `delivery_partner_id` int(11) DEFAULT NULL,
  `delivery_status` varchar(55) DEFAULT NULL COMMENT '1-Sent,2-Returned,3-Cash Received',
  `due_date_time` varchar(55) DEFAULT NULL,
  `account_note` varchar(100) DEFAULT NULL,
  `account_type` varchar(55) DEFAULT NULL,
  `sale_vat_objects` text DEFAULT NULL,
  `random_code` varchar(55) DEFAULT NULL,
  `note` varchar(300) DEFAULT NULL,
  `order_date_time` varchar(30) DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `tbl_sales`
--

INSERT INTO `tbl_sales` (`id`, `customer_id`, `employee_id`, `sale_no`, `total_items`, `sub_total`, `paid_amount`, `previous_due`, `due_amount`, `disc`, `disc_actual`, `vat`, `rounding`, `total_payable`, `close_time`, `total_item_discount_amount`, `sub_total_with_discount`, `sub_total_discount_amount`, `total_discount_amount`, `delivery_charge`, `charge_type`, `sub_total_discount_value`, `sub_total_discount_type`, `sale_date`, `date_time`, `order_time`, `grand_total`, `online_yes_no`, `delivery_partner_id`, `delivery_status`, `due_date_time`, `account_note`, `account_type`, `sale_vat_objects`, `random_code`, `note`, `order_date_time`, `added_date`, `user_id`, `outlet_id`, `company_id`, `del_status`) VALUES
(1, 84, 0, 'INV000001', 1, 44403, 46179, 0, 0, NULL, NULL, 1776, 0, 46179, '19:24:34', 0, 44403, 0, 0, 0, 'delivery', '', 'plain', '2024-05-25', '2024-05-25 19:24:33', '19:24:33', 46179, 1, NULL, 'Cash Received', NULL, '', 'Bank_Account', '[{\"tax_field_id\":\"\",\"tax_field_type\":\"CGST\",\"tax_field_amount\":\"444.0\"},{\"tax_field_id\":\"\",\"tax_field_type\":\"SGST\",\"tax_field_amount\":\"444.0\"},{\"tax_field_id\":\"\",\"tax_field_type\":\"IGST\",\"tax_field_amount\":\"444.0\"},{\"tax_field_id\":\"\",\"tax_field_type\":\"VAT\",\"tax_field_amount\":\"444.0\"}]', 'W9BJNNmMWaKpY4M', '', '2024-05-25 19:24:33', '2024-05-25 19:24:33', 1, 4, 1, 'Live');

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

--
-- Table structure for table `tbl_sales_details`
--

CREATE TABLE `tbl_sales_details` (
  `id` bigint(55) NOT NULL,
  `food_menu_id` int(11) DEFAULT NULL,
  `qty` float DEFAULT NULL,
  `menu_price_without_discount` float DEFAULT NULL,
  `menu_price_with_discount` float DEFAULT NULL,
  `menu_unit_price` float DEFAULT NULL,
  `purchase_price` float DEFAULT NULL,
  `menu_vat_percentage` float DEFAULT NULL,
  `menu_taxes` text DEFAULT NULL,
  `menu_discount_value` varchar(11) DEFAULT NULL,
  `discount_type` varchar(30) DEFAULT NULL,
  `menu_note` varchar(255) DEFAULT NULL,
  `discount_amount` float DEFAULT NULL,
  `item_type` varchar(55) DEFAULT NULL,
  `expiry_imei_serial` varchar(55) DEFAULT NULL,
  `sales_id` int(11) DEFAULT NULL,
  `is_promo_item` varchar(11) DEFAULT NULL,
  `promo_parent_id` int(11) DEFAULT NULL,
  `item_seller_id` int(11) DEFAULT NULL,
  `delivery_status` varchar(55) DEFAULT NULL COMMENT '1-Sent,2-Returned,3-Cash Received',
  `loyalty_point_earn` float DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `tbl_sales_details`
--

INSERT INTO `tbl_sales_details` (`id`, `food_menu_id`, `qty`, `menu_price_without_discount`, `menu_price_with_discount`, `menu_unit_price`, `purchase_price`, `menu_vat_percentage`, `menu_taxes`, `menu_discount_value`, `discount_type`, `menu_note`, `discount_amount`, `item_type`, `expiry_imei_serial`, `sales_id`, `is_promo_item`, `promo_parent_id`, `item_seller_id`, `delivery_status`, `loyalty_point_earn`, `user_id`, `outlet_id`, `company_id`, `del_status`) VALUES
(1, 294, 1, 44403, 44403, 44403, 26829, NULL, '[{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"CGST\",\"tax_field_percentage\":\"1\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"SGST\",\"tax_field_percentage\":\"1\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"IGST\",\"tax_field_percentage\":\"1\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"VAT\",\"tax_field_percentage\":\"1\"}]', '', 'plain', '', 0, 'Serial_Product', 'DELLU2422HE123459', 1, 'No', 0, 0, 'Cash Received', 20, 1, 4, 1, 'Live');

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

--
-- Table structure for table `tbl_sale_payments`
--

CREATE TABLE `tbl_sale_payments` (
  `id` int(11) NOT NULL,
  `date` varchar(30) DEFAULT NULL,
  `payment_id` int(11) DEFAULT NULL,
  `currency_type` int(11) DEFAULT NULL,
  `multi_currency` varchar(10) DEFAULT NULL,
  `multi_currency_rate` float DEFAULT NULL,
  `amount` float DEFAULT NULL,
  `usage_point` float DEFAULT NULL,
  `sale_id` int(11) DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `payment_name` varchar(100) DEFAULT NULL,
  `payment_details` varchar(255) DEFAULT NULL,
  `others_currency` varchar(255) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `del_status` varchar(11) NOT NULL DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_sale_payments`
--

INSERT INTO `tbl_sale_payments` (`id`, `date`, `payment_id`, `currency_type`, `multi_currency`, `multi_currency_rate`, `amount`, `usage_point`, `sale_id`, `added_date`, `payment_name`, `payment_details`, `others_currency`, `outlet_id`, `user_id`, `company_id`, `del_status`) VALUES
(1, '2024-05-25', 1, NULL, NULL, NULL, 46179, NULL, 1, '2024-05-25 19:24:34', 'Bank', ',,', NULL, 4, 1, 1, 'Live');

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

--
-- Table structure for table `tbl_sale_return`
--

CREATE TABLE `tbl_sale_return` (
  `id` int(11) NOT NULL,
  `reference_no` varchar(55) DEFAULT NULL,
  `date` varchar(30) DEFAULT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `total_return_amount` float DEFAULT NULL,
  `paid` float DEFAULT NULL,
  `due` float DEFAULT NULL,
  `payment_method_id` int(11) NOT NULL DEFAULT 1,
  `note` varchar(255) DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=COMPACT;

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

--
-- Table structure for table `tbl_sale_return_details`
--

CREATE TABLE `tbl_sale_return_details` (
  `id` int(11) NOT NULL,
  `sale_return_id` int(11) NOT NULL,
  `sale_id` int(11) DEFAULT NULL,
  `item_id` int(11) DEFAULT NULL,
  `sale_quantity_amount` int(11) DEFAULT 0,
  `return_quantity_amount` int(11) DEFAULT 0,
  `item_type` varchar(55) DEFAULT NULL,
  `expiry_imei_serial` varchar(55) DEFAULT NULL,
  `menu_taxes` varchar(500) DEFAULT NULL,
  `unit_price_in_sale` float DEFAULT NULL,
  `unit_price_in_return` float DEFAULT NULL,
  `user_id` int(11) DEFAULT 0,
  `outlet_id` int(11) DEFAULT 0,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `tbl_servicing`
--

CREATE TABLE `tbl_servicing` (
  `id` int(11) NOT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `date` varchar(30) DEFAULT NULL,
  `product_name` varchar(55) DEFAULT NULL,
  `product_model` varchar(55) DEFAULT NULL,
  `problem_description` text DEFAULT NULL,
  `receiving_date` varchar(55) DEFAULT NULL,
  `delivery_date` varchar(55) DEFAULT NULL,
  `servicing_charge` float DEFAULT NULL,
  `paid_amount` float DEFAULT NULL,
  `due_amount` float DEFAULT NULL,
  `status` varchar(55) DEFAULT NULL,
  `employee_id` int(11) DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `payment_method_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `del_status` varchar(11) NOT NULL DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `tbl_servicing`
--

INSERT INTO `tbl_servicing` (`id`, `customer_id`, `date`, `product_name`, `product_model`, `problem_description`, `receiving_date`, `delivery_date`, `servicing_charge`, `paid_amount`, `due_amount`, `status`, `employee_id`, `added_date`, `payment_method_id`, `outlet_id`, `user_id`, `company_id`, `del_status`) VALUES
(1, 84, '2024-05-23', 'Galaxy S24 Ultra', '458607044466034', 'Chargin cable problem', '2024-05-23', '2024-06-01', 5000, 2500, 2500, 'Delivered', 1, '2024-05-23 19:37:45', 1, 4, 1, 1, 'Live'),
(2, 84, '2024-05-25', 'Dell Ultra Sharp', 'DELLU2422HE123459', 'display  problem', '2024-05-25', '2024-06-01', 3000, 2000, 1000, 'Delivered', 1, '2024-05-25 20:00:52', 1, 4, 1, 1, 'Live');

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

--
-- Table structure for table `tbl_sessions`
--

CREATE TABLE `tbl_sessions` (
  `id` varchar(128) NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `timestamp` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `data` blob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_sessions`
--

INSERT INTO `tbl_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('9hftchncilvuid2g9h1im09htbmidf2l', '103.14.130.185', 1716458928, 0x[encoded data, 20286 characters]),
('d88puoee85l2dsmfdtl3jbmc49k8us1r', '103.14.130.185', 1716459389, 0x[encoded data, 20286 characters]);
INSERT INTO `tbl_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('rmt1mlbhfrc9v52p9o89n2gar3cgkoeo', '103.14.130.185', 1716459772, 0x[encoded data, 20286 characters]),
('4109qtn6lgineh0f53ku0enmiopehcc9', '103.14.130.185', 1716460288, 0x[encoded data, 20286 characters]);
INSERT INTO `tbl_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('0u3qeak8ev9iskal15j4fskhoss565cc', '103.14.130.185', 1716460603, 0x[encoded data, 20286 characters]),
('54bks6k51qv0qmr9f1usrfrfaerkc088', '103.14.130.185', 1716461310, 0x[encoded data, 20286 characters]);
INSERT INTO `tbl_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('j4lboj5mvi5ghu76lcmoplpp8u0ej36e', '103.14.130.185', 1716461678, 0x[encoded data, 20286 characters]),
('kmh3s3p3lc61rcmvv4tf074k86hd73h6', '103.14.130.185', 1716462003, 0x[encoded data, 20286 characters]);
INSERT INTO `tbl_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('p5m9438oqgii4t7bbqtm57fbqrrrfrm2', '103.14.130.185', 1716462516, 0x[encoded data, 20286 characters]),
('vcgsretplngs2daekrq5v1is5bh6st38', '103.14.130.185', 1716462208, 0x5f5f63695f6c6173745f726567656e65726174657c693a313731363436323230383b564945575f5041525345527c623a313b),
('11ue1p1da3u267bhe06jji4uvv3rtfmv', '103.14.130.185', 1716462208, 0x5f5f63695f6c6173745f726567656e65726174657c693a313731363436323230383b564945575f5041525345527c623a313b),
('fqo8bshvjv1ge5pfsl8ocrmi36rs356d', '103.14.130.185', 1716462937, 0x[encoded data, 20286 characters]);
INSERT INTO `tbl_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('ct4uhmdv34ckpm5g37aqt7k5t3eibet4', '103.14.130.185', 1716463393, 0x[encoded data, 20286 characters]),
('ee9e2p71lotnrohuknqibt9ug839j99f', '103.14.130.185', 1716464076, 0x[encoded data, 20286 characters]);
INSERT INTO `tbl_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('jffv7fkie7s7aucdfp5uq45js03jl37p', '103.14.130.185', 1716464812, 0x[encoded data, 20286 characters]),
('5qbf7ad9khv7j7vjrk4ic4l09f2in8j4', '202.134.10.142', 1716465114, 0x[encoded data, 20286 characters]);
INSERT INTO `tbl_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('sjnirnldqspujkt7eoredj3l2et32a3a', '103.14.130.185', 1716465544, 0x[encoded data, 20286 characters]),
('jv0agg2elt92khug0s9au088f0k16v4o', '103.14.130.185', 1716465274, 0x5f5f63695f6c6173745f726567656e65726174657c693a313731363436353237343b564945575f5041525345527c623a313b),
('evglna2qs923mp2j9rh9mkb71b0pk3e2', '103.14.130.185', 1716465274, 0x5f5f63695f6c6173745f726567656e65726174657c693a313731363436353237343b564945575f5041525345527c623a313b),
('5pch0kctcdlsv3nhff4hr6mijriakjsj', '103.14.130.185', 1716465952, 0x[encoded data, 20286 characters]);
INSERT INTO `tbl_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('1vqll8pv2pg8te34j8a0ner9qbsu2s40', '103.14.130.185', 1716466255, 0x[encoded data, 20286 characters]),
('npk48p5gd4u7retf2592ef8pt21qlkf0', '103.14.130.185', 1716466577, 0x[encoded data, 20286 characters]);
