INSERT INTO `tbl_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('1d9m5hj9fvga0pti2l3mhakdfqmue40e', '::1', 1716869460, 0x[encoded data, 20144 characters]),
('jtuu47toh1uhd7tiqe8824hkgibsjn9k', '::1', 1716869764, 0x[encoded data, 20144 characters]);
INSERT INTO `tbl_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('hdkq5fr6jpbam2b13j5vogggo48b0asc', '::1', 1716870141, 0x[encoded data, 20144 characters]),
('v0qrqprsu0bi3bc0d24phbdshdjois42', '::1', 1716870446, 0x[encoded data, 20228 characters]);
INSERT INTO `tbl_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('2c3pe0756ljmtm6ig07pt598umsulrci', '::1', 1716870818, 0x[encoded data, 20228 characters]),
('ohm6bf5rfn18h3pidmbo8bf6a9c7nl3n', '::1', 1716870862, 0x[encoded data, 20228 characters]);

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

--
-- Table structure for table `tbl_set_opening_stocks`
--

CREATE TABLE `tbl_set_opening_stocks` (
  `id` bigint(255) NOT NULL,
  `item_id` int(11) DEFAULT NULL,
  `item_type` varchar(55) DEFAULT NULL,
  `item_description` varchar(255) DEFAULT NULL,
  `stock_quantity` 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(10) NOT NULL DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_set_opening_stocks`
--

INSERT INTO `tbl_set_opening_stocks` (`id`, `item_id`, `item_type`, `item_description`, `stock_quantity`, `outlet_id`, `user_id`, `company_id`, `del_status`) VALUES
(1, 2, 'Variation_Product', NULL, 90, 4, 1, 1, 'Live'),
(2, 2, 'Variation_Product', NULL, 90, 5, 1, 1, 'Live'),
(3, 3, 'Variation_Product', NULL, 90, 4, 1, 1, 'Live'),
(4, 3, 'Variation_Product', NULL, 90, 5, 1, 1, 'Live'),
(5, 4, 'Variation_Product', NULL, 90, 4, 1, 1, 'Live'),
(6, 4, 'Variation_Product', NULL, 90, 5, 1, 1, 'Live'),
(7, 5, 'Variation_Product', NULL, 90, 4, 1, 1, 'Live'),
(8, 5, 'Variation_Product', NULL, 90, 5, 1, 1, 'Live'),
(9, 6, 'Medicine_Product', '2026-08-14', 4160, 5, 1, 1, 'Live'),
(10, 6, 'Medicine_Product', '2026-10-07', 3120, 5, 1, 1, 'Live'),
(11, 6, 'Medicine_Product', '2027-01-02', 3640, 4, 1, 1, 'Live'),
(12, 6, 'Medicine_Product', '2026-12-17', 3120, 4, 1, 1, 'Live');

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

--
-- Stand-in structure for view `tbl_stock_detail`
-- (See below for the actual view)
--
CREATE TABLE `tbl_stock_detail` (
`id` bigint(255)
,`item_id` int(11)
,`item_type` varchar(55)
,`expiry_imei_serial` varchar(255)
,`stock_quantity` varchar(23)
,`outlet_id` int(11)
,`type` int(1)
,`description` varchar(18)
);

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

--
-- Stand-in structure for view `tbl_stock_detail2`
-- (See below for the actual view)
--
CREATE TABLE `tbl_stock_detail2` (
`item_id` int(11)
,`item_type` varchar(55)
,`expiry_imei_serial` varchar(255)
,`stock_quantity` varchar(34)
,`outlet_id` int(11)
,`type` int(1)
,`description` varchar(18)
);

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

--
-- Table structure for table `tbl_suppliers`
--

CREATE TABLE `tbl_suppliers` (
  `id` int(11) NOT NULL,
  `name` varchar(55) DEFAULT NULL,
  `contact_person` varchar(55) DEFAULT NULL,
  `phone` varchar(30) DEFAULT NULL,
  `email` varchar(55) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `opening_balance` int(11) DEFAULT 0,
  `opening_balance_type` varchar(11) DEFAULT 'Credit',
  `added_date` varchar(55) DEFAULT NULL,
  `user_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_suppliers`
--

INSERT INTO `tbl_suppliers` (`id`, `name`, `contact_person`, `phone`, `email`, `address`, `description`, `opening_balance`, `opening_balance_type`, `added_date`, `user_id`, `company_id`, `del_status`) VALUES
(3, 'Easy', 'Mr.Alex', '9233343471', '', '', '', 0, 'Debit', '2024-05-21 14:38:05', 1, 1, 'Delete'),
(4, 'Gentle Park', 'Mr.Gousif', '0987654743', '', '', '', 0, 'Debit', '2024-05-21 15:04:02', 1, 1, 'Delete'),
(5, 'Le Reve', 'Mr.Lumen', '0978368365', '', '', '', 0, 'Debit', '2024-05-21 15:21:09', 1, 1, 'Delete'),
(6, 'Arong', 'Mr.Adam', '89364234698', '', '', '', 0, 'Debit', '2024-05-21 15:41:44', 1, 1, 'Delete'),
(7, 'Apple', 'Mr.Antoni', '0945847597494', '', '', '', 0, 'Debit', '2024-05-23 12:53:21', 1, 1, 'Delete'),
(8, 'Samsung', 'Mr.Simon', '8473496553459', '', '', '', 0, 'Debit', '2024-05-23 13:08:49', 1, 1, 'Live'),
(9, 'Huawei', 'Mr.Henry', '3456745634452', '', '', '', 0, 'Debit', '2024-05-23 13:16:53', 1, 1, 'Delete'),
(10, 'LG', 'Mr.Leo', '87386387383', '', '', '', 0, 'Debit', '2024-05-23 13:28:11', 1, 1, 'Live'),
(11, 'Sony', 'Mr.Simon', '3242356568756', '', '', '', 0, 'Debit', '2024-05-23 14:20:53', 1, 1, 'Delete'),
(12, 'TP Link', 'Mr.Tom', '0987657987', '', '', '', 0, 'Debit', '2024-05-23 16:07:59', 1, 1, 'Delete'),
(13, 'D Link', 'Mr.Donald', '9787557886545', '', '', '', 0, 'Debit', '2024-05-23 16:15:53', 1, 1, 'Delete'),
(14, 'Tenda', 'Mr.Thomas', '098374834783', '', '', '', 0, 'Debit', '2024-05-23 16:21:43', 1, 1, 'Delete'),
(15, 'Asus', 'Mr.Antony', '456423785674', '', '', '', 0, 'Debit', '2024-05-23 16:30:18', 1, 1, 'Delete'),
(16, 'Mircosoft', 'Mr.Moon', '09757856734', '', '', '', 0, 'Debit', '2024-05-23 16:50:55', 1, 1, 'Delete'),
(17, 'HP', 'Mr.Head', '9878654467', '', '', '', 0, 'Debit', '2024-05-23 17:03:02', 1, 1, 'Delete'),
(18, 'Lenovo', 'Mr.Latham', '0983736483', '', '', '', 0, 'Debit', '2024-05-23 17:13:31', 1, 1, 'Delete'),
(19, 'Dell', 'Mr.Dheman', '09878765467', '', '', '', 0, 'Debit', '2024-05-23 17:22:18', 1, 1, 'Delete'),
(20, 'Penasonic', 'Mr.Petter', '098767577565', '', '', '', 0, 'Debit', '2024-05-25 14:20:28', 1, 1, 'Live'),
(21, 'ACME', 'Mr.Anthon', '87328365493', '', '', '', 0, 'Debit', '2024-05-26 13:41:26', 1, 1, 'Delete'),
(22, 'Beximco', 'Miss.Viva', '0878365284', '', '', '', 0, 'Debit', '2024-05-26 13:52:15', 1, 1, 'Delete'),
(23, 'ACI', 'Miss.Ammy', '97849794673', '', '', '', 0, 'Debit', '2024-05-26 13:59:46', 1, 1, 'Delete'),
(24, 'Biopharma', 'Mr.Benton', '42323567547', '', '', '', 0, 'Debit', '2024-05-26 14:14:52', 1, 1, 'Delete'),
(25, 'Square', 'Miss.Suborna', '90849785', '', '', '', 0, 'Debit', '2024-05-26 14:41:07', 1, 1, 'Delete'),
(26, 'Popular Pharmacitical', 'Mr.Prodif', '342356457453', '', '', '', 0, 'Debit', '2024-05-26 14:49:09', 1, 1, 'Delete'),
(27, 'Walton', 'Mr.Wafraz', '0958678463', '', '', '', 0, 'Debit', '2024-05-26 22:35:27', 1, 1, 'Live'),
(28, 'Singer', 'Miss.Shelly', '098768763563', '', '', '', 0, 'Debit', '2024-05-26 22:36:02', 1, 1, 'Live'),
(29, 'Vision', 'Miss.Viva', '098756893', '', '', '', 0, 'Debit', '2024-05-26 23:40:46', 1, 1, 'Live'),
(30, 'Hike', 'Mr.Himel', '098387763', '', '', '', 0, 'Debit', '2024-05-28 10:19:40', 1, 1, 'Live'),
(31, 'Square', 'Mr.Saimon', '756758', '', '', '', 0, 'Debit', '2024-05-28 10:25:57', 1, 1, 'Live');

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

--
-- Table structure for table `tbl_supplier_payments`
--

CREATE TABLE `tbl_supplier_payments` (
  `id` int(11) NOT NULL,
  `reference_no` varchar(55) DEFAULT NULL,
  `date` varchar(30) DEFAULT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `amount` float DEFAULT NULL,
  `note` varchar(255) DEFAULT NULL,
  `payment_method_id` int(11) NOT NULL 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) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `tbl_time_zone`
--

CREATE TABLE `tbl_time_zone` (
  `id` int(11) NOT NULL,
  `country_code` varchar(25) CHARACTER SET utf32 COLLATE utf32_general_ci DEFAULT NULL,
  `zone_name` varchar(55) CHARACTER SET utf32 COLLATE utf32_general_ci DEFAULT NULL,
  `del_status` varchar(11) CHARACTER SET utf32 COLLATE utf32_general_ci DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_time_zone`
--

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

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

--
-- Table structure for table `tbl_transfer`
--

CREATE TABLE `tbl_transfer` (
  `id` int(11) NOT NULL,
  `transfer_type` int(11) NOT NULL DEFAULT 1,
  `reference_no` varchar(55) DEFAULT NULL,
  `date` varchar(30) DEFAULT NULL,
  `received_date` varchar(30) DEFAULT NULL,
  `note_for_sender` varchar(300) DEFAULT NULL,
  `note_for_receiver` varchar(300) DEFAULT NULL,
  `from_outlet_id` int(11) DEFAULT NULL,
  `to_outlet_id` int(11) DEFAULT NULL,
  `status` int(11) 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_transfer_items`
--

CREATE TABLE `tbl_transfer_items` (
  `id` int(11) NOT NULL,
  `status` int(11) DEFAULT NULL,
  `ingredient_id` int(11) DEFAULT NULL,
  `quantity_amount` float DEFAULT NULL,
  `transfer_id` int(11) DEFAULT NULL,
  `item_type` varchar(55) NOT NULL,
  `expiry_imei_serial` varchar(255) DEFAULT NULL,
  `from_outlet_id` int(11) DEFAULT NULL,
  `to_outlet_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_units`
--

CREATE TABLE `tbl_units` (
  `id` int(11) NOT NULL,
  `unit_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) 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_units`
--

INSERT INTO `tbl_units` (`id`, `unit_name`, `description`, `added_date`, `user_id`, `company_id`, `del_status`) VALUES
(1, 'PCS', '', '2024-05-21 14:34:40', 1, 1, 'Live'),
(2, 'Bundle', '', '2024-05-21 14:34:47', 1, 1, 'Live'),
(3, 'Box', '', '2024-05-26 13:41:42', 1, 1, 'Live'),
(4, 'Bottle', '', '2024-05-26 18:49:19', 1, 1, 'Live');

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

--
-- Table structure for table `tbl_users`
--

CREATE TABLE `tbl_users` (
  `id` int(11) NOT NULL,
  `full_name` varchar(55) NOT NULL,
  `phone` varchar(30) NOT NULL,
  `email_address` varchar(55) NOT NULL,
  `password` varchar(255) NOT NULL,
  `designation` varchar(11) DEFAULT NULL,
  `printer_id` int(11) DEFAULT NULL,
  `open_cash_drawer` varchar(55) NOT NULL DEFAULT 'No',
  `commission` float DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `salary` float DEFAULT NULL,
  `will_login` varchar(20) NOT NULL DEFAULT 'No',
  `role` int(11) DEFAULT NULL,
  `account_creation_date` varchar(3055) DEFAULT NULL,
  `language` varchar(55) NOT NULL DEFAULT 'english',
  `last_login` varchar(55) DEFAULT NULL,
  `active_status` varchar(11) NOT NULL DEFAULT 'Active',
  `question` varchar(250) DEFAULT NULL,
  `answer` varchar(250) DEFAULT NULL,
  `sale_price_modify` varchar(11) NOT NULL DEFAULT 'No',
  `discount_permission_code` varchar(55) DEFAULT NULL,
  `discount_amt` varchar(11) DEFAULT NULL,
  `start_date` varchar(55) DEFAULT NULL,
  `end_date` varchar(55) DEFAULT NULL,
  `outlet_id` varchar(55) 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_users`
--

INSERT INTO `tbl_users` (`id`, `full_name`, `phone`, `email_address`, `password`, `designation`, `printer_id`, `open_cash_drawer`, `commission`, `photo`, `salary`, `will_login`, `role`, `account_creation_date`, `language`, `last_login`, `active_status`, `question`, `answer`, `sale_price_modify`, `discount_permission_code`, `discount_amt`, `start_date`, `end_date`, `outlet_id`, `company_id`, `del_status`) VALUES
(1, 'Demo Admin', '01812391633', 'admin@doorsoft.co', 'e10adc3949ba59abbe56e057f20f883e', NULL, NULL, 'No', 0, NULL, 0, 'Yes', 1, '2018-02-17 07:28:32', 'english', '2024-05-28 06:04:30', 'Active', 'What is the name of your first pet?', 'Micky', 'Yes', 'WA69', '7%', '2024-05-10', '2024-05-30', '1', 1, 'Live'),
(63, 'Nahiyan', '9233343471', 'nahiyan@gmail.com', 'e10adc3949ba59abbe56e057f20f883e', NULL, NULL, 'No', 0, '', 6000, 'Yes', 4, '2024-05-02 16:49:07', 'english', '2024-05-02 13:07:27', 'Active', NULL, NULL, '', '', '', '', '', '1', 1, 'Live'),
(64, 'Mr.John', '123456789', 'Mr-John', '96e79218965eb72c92a549dd5a330112', NULL, NULL, 'No', 2, '', 7000, 'Yes', 3, '2024-05-06 16:36:25', 'english', NULL, 'Active', NULL, NULL, 'Select', '', '', '', '', NULL, 1, 'Live'),
(65, 'Mr.Alex', '09876554321', 'Alex', '96e79218965eb72c92a549dd5a330112', NULL, NULL, 'No', 3, '', 8000, 'Yes', 3, '2024-05-06 19:45:32', 'english', NULL, 'Active', NULL, NULL, 'Select', '', '', '', '', NULL, 1, 'Live');

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

--
-- Table structure for table `tbl_variations`
--

CREATE TABLE `tbl_variations` (
  `id` int(11) NOT NULL,
  `variation_name` varchar(55) DEFAULT NULL,
  `variation_value` varchar(300) DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `user_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_variations`
--

INSERT INTO `tbl_variations` (`id`, `variation_name`, `variation_value`, `added_date`, `user_id`, `company_id`, `del_status`) VALUES
(1, 'Size', '[\"M\",\"L\",\"XL\",\"XXL\"]', '2024-05-21 14:36:14', 1, 1, 'Live'),
(2, 'Color', '[\"Red\",\"Blue\",\"Sky Blue\",\"Yellow\",\"Navy Blue\",\"Lightblue\",\"White \",\"Black\",\"Gray\",\"Green\",\"Light Green\"]', '2024-05-21 14:36:48', 1, 1, 'Live'),
(3, 'Hips Size', '[\"28\",\"30\",\"32\",\"34\",\"36\",\"38\",\"40\"]', '2024-05-21 18:59:11', 1, 1, 'Live'),
(4, 'Shoes Size', '[\"38\",\"40\",\"42\",\"44\"]', '2024-05-21 20:37:44', 1, 1, 'Live');

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

--
-- Table structure for table `tbl_warranties`
--

CREATE TABLE `tbl_warranties` (
  `id` int(11) NOT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `customer_name` varchar(55) DEFAULT NULL,
  `customer_mobile` varchar(30) DEFAULT NULL,
  `product_name` varchar(55) DEFAULT NULL,
  `product_serial_no` varchar(100) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `receiving_date` varchar(30) DEFAULT NULL,
  `delivery_date` varchar(30) DEFAULT NULL,
  `current_status` varchar(25) DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `outlet_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;

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

--
-- Structure for view `tbl_stock_detail`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `tbl_stock_detail`  AS   (select `op`.`id` AS `id`,`op`.`item_id` AS `item_id`,`op`.`item_type` AS `item_type`,`op`.`item_description` AS `expiry_imei_serial`,`op`.`stock_quantity` AS `stock_quantity`,`op`.`outlet_id` AS `outlet_id`,1 AS `type`,'Opening' AS `description` from `tbl_set_opening_stocks` `op` where `op`.`del_status` = 'Live') union (select `pu`.`id` AS `id`,`pu`.`item_id` AS `item_id`,`pu`.`item_type` AS `item_type`,`pu`.`expiry_imei_serial` AS `expiry_imei_serial`,`pu`.`quantity_amount` * `i`.`conversion_rate` AS `stock_quantity`,`pu`.`outlet_id` AS `outlet_id`,1 AS `type`,'Purchase' AS `description` from (`tbl_purchase_details` `pu` join `tbl_items` `i`) where `pu`.`del_status` = 'Live' and `pu`.`item_id` = `i`.`id`) union (select `pr`.`id` AS `id`,`pr`.`item_id` AS `item_id`,`pr`.`item_type` AS `item_type`,`pr`.`expiry_imei_serial` AS `expiry_imei_serial`,`pr`.`return_quantity_amount` AS `stock_quantity`,`pr`.`outlet_id` AS `outlet_id`,2 AS `type`,'Purchase Return' AS `description` from `tbl_purchase_return_details` `pr` where `pr`.`del_status` = 'Live') union (select `pri`.`id` AS `id`,`pri`.`item_id` AS `item_id`,`pri`.`item_type` AS `item_type`,`pri`.`expiry_imei_serial_in` AS `expiry_imei_serial`,`pri`.`return_quantity_amount` AS `stock_quantity`,`pri`.`outlet_id` AS `outlet_id`,1 AS `type`,'Purchase Return In' AS `description` from `tbl_purchase_return_details` `pri` where `pri`.`return_status` = 'taken_by_sup_pro_returned' and `pri`.`del_status` = 'Live') union (select `i_s`.`id` AS `id`,`i_s`.`item_id` AS `item_id`,`i_s`.`item_type` AS `item_type`,`i_s`.`expiry_imei_serial` AS `expiry_imei_serial`,`i_s`.`quantity` AS `stock_quantity`,`i_s`.`outlet_id` AS `outlet_id`,2 AS `type`,'Installment Sale' AS `description` from `tbl_installments` `i_s` where `i_s`.`del_status` = 'Live') union (select `s`.`id` AS `id`,`s`.`food_menu_id` AS `item_id`,`s`.`item_type` AS `item_type`,'' AS `expiry_imei_serial`,`s`.`qty` AS `stock_quantity`,`s`.`outlet_id` AS `outlet_id`,2 AS `type`,'Sale' AS `description` from `tbl_sales_details` `s` where (`s`.`delivery_status` = 'Sent' or `s`.`delivery_status` = 'Cash Received') and `s`.`del_status` = 'Live') union (select `s2`.`id` AS `id`,`s2`.`food_menu_id` AS `item_id`,`s2`.`item_type` AS `item_type`,`s2`.`expiry_imei_serial` AS `expiry_imei_serial`,0 AS `stock_quantity`,`s2`.`outlet_id` AS `outlet_id`,2 AS `type`,'Sale IMEI' AS `description` from `tbl_sales_details` `s2` where !(`s2`.`expiry_imei_serial` in (select `sr2`.`expiry_imei_serial` from `tbl_sale_return_details` `sr2` where `sr2`.`item_id` = `s2`.`food_menu_id` and `s2`.`outlet_id` = `sr2`.`outlet_id`)) and `s2`.`del_status` = 'Live') union (select `sr`.`id` AS `id`,`sr`.`item_id` AS `item_id`,`sr`.`item_type` AS `item_type`,'' AS `expiry_imei_serial`,`sr`.`return_quantity_amount` AS `stock_quantity`,`sr`.`outlet_id` AS `outlet_id`,1 AS `type`,'Sale Return' AS `description` from `tbl_sale_return_details` `sr` where `sr`.`del_status` = 'Live') union (select `d`.`id` AS `id`,`d`.`item_id` AS `item_id`,`d`.`item_type` AS `item_type`,`d`.`expiry_imei_serial` AS `expiry_imei_serial`,`d`.`damage_quantity` AS `stock_quantity`,`d`.`outlet_id` AS `outlet_id`,2 AS `type`,'Damage' AS `description` from `tbl_damage_details` `d` where `d`.`del_status` = 'Live') union (select `tou`.`id` AS `id`,`tou`.`ingredient_id` AS `item_id`,`tou`.`item_type` AS `item_type`,`tou`.`expiry_imei_serial` AS `expiry_imei_serial`,`tou`.`quantity_amount` AS `stock_quantity`,`tou`.`outlet_id` AS `outlet_id`,2 AS `type`,'Transfer Out' AS `description` from `tbl_transfer_items` `tou` where `tou`.`from_outlet_id` = `tou`.`outlet_id` and `tou`.`del_status` = 'Live') union (select `ti`.`id` AS `id`,`ti`.`ingredient_id` AS `item_id`,`ti`.`item_type` AS `item_type`,`ti`.`expiry_imei_serial` AS `expiry_imei_serial`,`ti`.`quantity_amount` AS `stock_quantity`,`ti`.`to_outlet_id` AS `outlet_id`,1 AS `type`,'Transfer In' AS `description` from `tbl_transfer_items` `ti` where `ti`.`to_outlet_id` <> `ti`.`outlet_id` and `ti`.`del_status` = 'Live')  ;

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

--
-- Structure for view `tbl_stock_detail2`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `tbl_stock_detail2`  AS   (select `op`.`item_id` AS `item_id`,`op`.`item_type` AS `item_type`,`op`.`item_description` AS `expiry_imei_serial`,`op`.`stock_quantity` AS `stock_quantity`,`op`.`outlet_id` AS `outlet_id`,1 AS `type`,'Opening' AS `description` from `tbl_set_opening_stocks` `op` where `op`.`del_status` = 'Live') union (select `pu`.`item_id` AS `item_id`,`pu`.`item_type` AS `item_type`,`pu`.`expiry_imei_serial` AS `expiry_imei_serial`,`pu`.`quantity_amount` * `i`.`conversion_rate` AS `stock_quantity`,`pu`.`outlet_id` AS `outlet_id`,1 AS `type`,'Purchase' AS `description` from (`tbl_purchase_details` `pu` join `tbl_items` `i`) where `pu`.`del_status` = 'Live' and `pu`.`item_id` = `i`.`id`) union (select `pr`.`item_id` AS `item_id`,`pr`.`item_type` AS `item_type`,`pr`.`expiry_imei_serial` AS `expiry_imei_serial`,-`pr`.`return_quantity_amount` AS `stock_quantity`,`pr`.`outlet_id` AS `outlet_id`,2 AS `type`,'Purchase Return' AS `description` from `tbl_purchase_return_details` `pr` where `pr`.`del_status` = 'Live') union (select `pri`.`item_id` AS `item_id`,`pri`.`item_type` AS `item_type`,`pri`.`expiry_imei_serial_in` AS `expiry_imei_serial`,`pri`.`return_quantity_amount` AS `stock_quantity`,`pri`.`outlet_id` AS `outlet_id`,1 AS `type`,'Purchase Return In' AS `description` from `tbl_purchase_return_details` `pri` where `pri`.`return_status` = 'taken_by_sup_pro_returned' and `pri`.`del_status` = 'Live') union (select `s`.`food_menu_id` AS `item_id`,`s`.`item_type` AS `item_type`,`s`.`expiry_imei_serial` AS `expiry_imei_serial`,-`s`.`qty` AS `stock_quantity`,`s`.`outlet_id` AS `outlet_id`,2 AS `type`,'Sale' AS `description` from `tbl_sales_details` `s` where (`s`.`delivery_status` = 'Sent' or `s`.`delivery_status` = 'Cash Received') and `s`.`del_status` = 'Live') union (select `sr`.`item_id` AS `item_id`,`sr`.`item_type` AS `item_type`,`sr`.`expiry_imei_serial` AS `expiry_imei_serial`,`sr`.`return_quantity_amount` AS `stock_quantity`,`sr`.`outlet_id` AS `outlet_id`,1 AS `type`,'Sale Return' AS `description` from `tbl_sale_return_details` `sr` where `sr`.`del_status` = 'Live') union (select `d`.`item_id` AS `item_id`,`d`.`item_type` AS `item_type`,`d`.`expiry_imei_serial` AS `expiry_imei_serial`,-`d`.`damage_quantity` AS `stock_quantity`,`d`.`outlet_id` AS `outlet_id`,2 AS `type`,'Damage' AS `description` from `tbl_damage_details` `d` where `d`.`del_status` = 'Live') union (select `tou`.`ingredient_id` AS `item_id`,`tou`.`item_type` AS `item_type`,`tou`.`expiry_imei_serial` AS `expiry_imei_serial`,-`tou`.`quantity_amount` AS `stock_quantity`,`tou`.`outlet_id` AS `outlet_id`,2 AS `type`,'Transfer Out' AS `description` from `tbl_transfer_items` `tou` where `tou`.`from_outlet_id` = `tou`.`outlet_id` and `tou`.`del_status` = 'Live') union (select `ti`.`ingredient_id` AS `item_id`,`ti`.`item_type` AS `item_type`,`ti`.`expiry_imei_serial` AS `expiry_imei_serial`,`ti`.`quantity_amount` AS `stock_quantity`,`ti`.`to_outlet_id` AS `outlet_id`,1 AS `type`,'Transfer In' AS `description` from `tbl_transfer_items` `ti` where `ti`.`to_outlet_id` <> `ti`.`outlet_id` and `ti`.`del_status` = 'Live')  ;

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

--
-- Indexes for table `tbl_customer_due_receives`
--
ALTER TABLE `tbl_customer_due_receives`
  ADD PRIMARY KEY (`id`),
  ADD KEY `outlet_id_slow` (`id`);

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

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

--
-- Indexes for table `tbl_damage_details`
--
ALTER TABLE `tbl_damage_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `slow` (`item_id`,`outlet_id`,`del_status`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `tbl_installments`
--
ALTER TABLE `tbl_installments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `slow` (`item_id`,`outlet_id`,`del_status`);

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

--
-- Indexes for table `tbl_items`
--
ALTER TABLE `tbl_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `brand_id_slow` (`brand_id`);

--
-- Indexes for table `tbl_item_categories`
--
ALTER TABLE `tbl_item_categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `slow` (`del_status`);

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

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

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

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

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

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

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

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

--
-- Indexes for table `tbl_purchase_details`
--
ALTER TABLE `tbl_purchase_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `slow` (`item_id`,`outlet_id`,`del_status`),
  ADD KEY `purchase_id_slow` (`purchase_id`);

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

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

--
-- Indexes for table `tbl_purchase_return_details`
--
ALTER TABLE `tbl_purchase_return_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `slow` (`item_id`,`outlet_id`,`del_status`);

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

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

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

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

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

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

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

--
-- Indexes for table `tbl_sales`
--
ALTER TABLE `tbl_sales`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sale_slow` (`customer_id`,`user_id`,`outlet_id`);

--
-- Indexes for table `tbl_sales_details`
--
ALTER TABLE `tbl_sales_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `slow` (`food_menu_id`,`outlet_id`,`del_status`),
  ADD KEY `slow1` (`sales_id`),
  ADD KEY `user_id_slow` (`user_id`),
  ADD KEY `previous_id_slow` (`sales_id`);

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

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

--
-- Indexes for table `tbl_sale_return_details`
--
ALTER TABLE `tbl_sale_return_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `slow` (`item_id`,`outlet_id`,`del_status`);

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

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

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

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

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

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

--
-- Indexes for table `tbl_transfer`
--
ALTER TABLE `tbl_transfer`
  ADD PRIMARY KEY (`id`) USING BTREE;

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

--
-- Indexes for table `tbl_units`
--
ALTER TABLE `tbl_units`
  ADD PRIMARY KEY (`id`),
  ADD KEY `slow` (`del_status`);

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `tbl_sales`
--
ALTER TABLE `tbl_sales`
  MODIFY `id` bigint(55) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `tbl_sales_details`
--
ALTER TABLE `tbl_sales_details`
  MODIFY `id` bigint(55) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

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

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

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

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

--
-- AUTO_INCREMENT for table `tbl_set_opening_stocks`
--
ALTER TABLE `tbl_set_opening_stocks`
  MODIFY `id` bigint(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

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

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

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

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

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

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

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

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

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

