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

START TRANSACTION;



--
-- Database: `erbilsystem_show`
--

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

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

CREATE TABLE `category` (
  `category_id` int(11) NOT NULL,
  `category` varchar(100) DEFAULT NULL,
  `category_description` varchar(150) DEFAULT NULL,
  `is_hidden` int(1) NOT NULL DEFAULT 0 COMMENT '0:Show; 1:Hide;',
  `is_deleted` int(1) DEFAULT 0,
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `last_action` varchar(100) DEFAULT NULL,
  `last_action_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `category` (`category_id`, `category`, `category_description`, `is_hidden`, `is_deleted`, `created_at`, `updated_at`, `deleted_at`, `created_by`, `last_action`, `last_action_by`) VALUES
(1, 'test', '', 0, 1, '2022-03-02 10:15:18', '2022-03-03 09:41:04', '2022-03-03 09:41:04', 1, 'Delete Category', 1),
(2, 'Zebra', 'Zebra', 0, 0, '2022-03-03 09:41:28', '2022-03-03 09:41:28', NULL, 1, 'Create New Category', 1),
(3, 'Tull', 'Tull', 0, 0, '2022-03-03 09:41:52', '2022-03-03 09:41:52', NULL, 1, 'Create New Category', 1),
(4, 'Qumash', 'Qumash', 0, 0, '2022-03-03 09:42:11', '2022-03-03 09:42:11', NULL, 1, 'Create New Category', 1),
(5, 'Dekae', 'Dekae', 0, 0, '2022-03-03 09:43:25', '2022-03-03 09:43:25', NULL, 1, 'Create New Category', 1),
(6, 'DOUBLE SROTE', 'DOUBLE SROTE', 0, 0, '2022-03-05 10:31:33', '2022-03-05 10:31:33', NULL, 1, 'Create New Category', 1),
(7, 'بطانة', 'بطانة', 0, 0, '2022-03-05 12:14:19', '2022-03-05 12:14:19', NULL, 1, 'Create New Category', 1);

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

--
-- Table structure for table `keywords`
--

CREATE TABLE `keywords` (
  `keyword_id` int(11) NOT NULL,
  `keyword` varchar(500) DEFAULT NULL,
  `is_deleted` int(1) DEFAULT 0,
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `last_action` varchar(100) DEFAULT NULL,
  `last_action_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `keywords` (`keyword_id`, `keyword`, `is_deleted`, `created_at`, `updated_at`, `deleted_at`, `created_by`, `last_action`, `last_action_by`) VALUES
(474, 'Access Assets', 0, '2018-10-27 10:51:01', '2018-10-27 10:51:01', NULL, 1, 'Define New Keyword', 1),
(475, 'Access Invoice', 0, '2018-10-27 10:51:01', '2018-10-27 10:51:01', NULL, 1, 'Define New Keyword', 1),
(476, 'Access Price Profiles', 0, '2018-10-27 10:51:01', '2018-10-27 10:51:01', NULL, 1, 'Define New Keyword', 1),
(477, 'Access Account Statements', 0, '2018-10-27 10:51:01', '2018-10-27 10:51:01', NULL, 1, 'Define New Keyword', 1),
(478, 'Access Payments', 0, '2018-10-27 10:51:01', '2018-10-27 10:51:01', NULL, 1, 'Define New Keyword', 1),
(479, 'Access Capital', 0, '2018-10-27 10:51:01', '2018-10-27 10:51:01', NULL, 1, 'Define New Keyword', 1),
(480, 'Access Salesman', 0, '2018-10-27 10:51:01', '2018-10-27 10:51:01', NULL, 1, 'Define New Keyword', 1),
(481, 'Access Staff', 0, '2018-10-27 10:51:01', '2018-10-27 10:51:01', NULL, 1, 'Define New Keyword', 1),
(482, 'Access System Setting', 0, '2018-10-27 10:51:01', '2018-10-27 10:51:01', NULL, 1, 'Define New Keyword', 1),
(483, 'Access Supplier', 0, '2018-10-27 10:51:01', '2018-10-27 10:51:01', NULL, 1, 'Define New Keyword', 1),
(484, 'Access Safe', 0, '2018-10-27 10:51:01', '2018-10-27 10:51:01', NULL, 1, 'Define New Keyword', 1),
(485, 'Access Loaners', 0, '2018-10-27 10:51:01', '2018-10-27 10:51:01', NULL, 1, 'Define New Keyword', 1),
(486, 'Access Loan', 0, '2018-10-27 10:51:01', '2018-10-27 10:51:01', NULL, 1, 'Define New Keyword', 1),
(487, 'Access Language', 0, '2018-10-27 10:51:01', '2018-10-27 10:51:01', NULL, 1, 'Define New Keyword', 1),
(488, 'Access Translation', 0, '2018-10-27 10:51:01', '2018-10-27 10:51:01', NULL, 1, 'Define New Keyword', 1),
(489, 'Access Orders', 0, '2018-10-27 10:51:01', '2018-10-27 10:51:01', NULL, 1, 'Define New Keyword', 1),
(490, 'Access Tasks', 0, '2018-10-27 10:51:01', '2018-10-27 10:51:01', NULL, 1, 'Define New Keyword', 1),
(491, 'اعدادت النظام', 0, '2018-10-27 10:51:12', '2018-10-27 10:51:12', NULL, 1, 'Define New Keyword', 1),
(492, 'معلومات الشركة', 0, '2018-10-27 10:51:12', '2018-10-27 10:51:12', NULL, 1, 'Define New Keyword', 1),
(493, 'اعدادات عامة', 0, '2018-10-27 10:51:12', '2018-10-27 10:51:12', NULL, 1, 'Define New Keyword', 1),
(494, 'اسم النظام', 0, '2018-10-27 10:51:12', '2018-10-27 10:51:12', NULL, 1, 'Define New Keyword', 1),
(495, 'الاصدار', 0, '2018-10-27 10:51:12', '2018-10-27 10:51:12', NULL, 1, 'Define New Keyword', 1),
(496, 'تاريخ التثبيت', 0, '2018-10-27 10:51:12', '2018-10-27 10:51:12', NULL, 1, 'Define New Keyword', 1),
(497, 'سعر صرف الدولار بالعملة المحلية (1$)', 0, '2018-10-27 10:51:12', '2018-10-27 10:51:12', NULL, 1, 'Define New Keyword', 1),
(498, 'التوقيت الزمني', 0, '2018-10-27 10:51:12', '2018-10-27 10:51:12', NULL, 1, 'Define New Keyword', 1),
(499, 'تحديث', 0, '2018-10-27 10:51:12', '2018-10-27 10:51:12', NULL, 1, 'Define New Keyword', 1),
(500, 'اسم مدير الشركة باللغة الانكليزية', 0, '2018-10-27 10:51:12', '2018-10-27 10:51:12', NULL, 1, 'Define New Keyword', 1),
(501, 'اسم مدير الشركة باللغة العربية', 0, '2018-10-27 10:51:12', '2018-10-27 10:51:12', NULL, 1, 'Define New Keyword', 1),
(502, 'اسم مدير الشركة باللغة الكوردية', 0, '2018-10-27 10:51:12', '2018-10-27 10:51:12', NULL, 1, 'Define New Keyword', 1),
(503, 'عنوان الشركة', 0, '2018-10-27 10:51:12', '2018-10-27 10:51:12', NULL, 1, 'Define New Keyword', 1),
(504, 'البريد الالكتروني للشركة', 0, '2018-10-27 10:51:12', '2018-10-27 10:51:12', NULL, 1, 'Define New Keyword', 1),
(505, 'البريد الالكتروني للتنبيه', 0, '2018-10-27 10:51:12', '2018-10-27 10:51:12', NULL, 1, 'Define New Keyword', 1),
(506, 'تحديث المعلومات', 0, '2018-10-27 10:51:12', '2018-10-27 10:51:12', NULL, 1, 'Define New Keyword', 1),
(507, 'المبالغ المصروفة', 0, '2018-10-27 10:51:28', '2018-10-27 10:51:28', NULL, 1, 'Define New Keyword', 1),
(508, 'المبلغ المتوفر في الخزنة', 0, '2018-10-27 10:51:28', '2018-10-27 10:51:28', NULL, 1, 'Define New Keyword', 1),
(509, 'Transaction Type', 0, '2018-10-27 10:51:28', '2018-10-27 10:51:28', NULL, 1, 'Define New Keyword', 1),
(510, 'فلتر حسب النوع', 0, '2018-10-27 10:51:28', '2018-10-27 10:51:28', NULL, 1, 'Define New Keyword', 1),
(511, 'سحب', 0, '2018-10-27 10:51:28', '2018-10-27 10:51:28', NULL, 1, 'Define New Keyword', 1),
(512, 'فلتر حسب الاسم', 0, '2018-10-27 10:51:28', '2018-10-27 10:51:28', NULL, 1, 'Define New Keyword', 1),
(513, 'اضافة', 0, '2018-10-27 10:51:28', '2018-10-27 10:51:28', NULL, 1, 'Define New Keyword', 1),
(514, 'Loaner Name', 0, '2018-10-27 10:51:38', '2018-10-27 10:51:38', NULL, 1, 'Define New Keyword', 1),
(515, 'Phone', 0, '2018-10-27 10:51:38', '2018-10-27 10:51:38', NULL, 1, 'Define New Keyword', 1),
(516, 'تحرير معلومات', 0, '2018-10-27 10:51:38', '2018-10-27 10:51:38', NULL, 1, 'Define New Keyword', 1),
(517, 'Add New Loaner', 0, '2018-10-27 10:51:38', '2018-10-27 10:51:38', NULL, 1, 'Define New Keyword', 1),
(518, 'القروض والديون', 0, '2018-10-27 10:51:48', '2018-10-27 10:51:48', NULL, 1, 'Define New Keyword', 1),
(519, 'Total Loans :', 0, '2018-10-27 10:51:48', '2018-10-27 10:51:48', NULL, 1, 'Define New Keyword', 1),
(520, 'Total Refund :', 0, '2018-10-27 10:51:48', '2018-10-27 10:51:48', NULL, 1, 'Define New Keyword', 1),
(521, 'Total Remained :', 0, '2018-10-27 10:51:48', '2018-10-27 10:51:48', NULL, 1, 'Define New Keyword', 1),
(522, 'Loan Amount', 0, '2018-10-27 10:51:48', '2018-10-27 10:51:48', NULL, 1, 'Define New Keyword', 1),
(523, 'Refunding', 0, '2018-10-27 10:51:48', '2018-10-27 10:51:48', NULL, 1, 'Define New Keyword', 1),
(524, 'Total Refunds :', 0, '2018-10-27 10:51:48', '2018-10-27 10:51:48', NULL, 1, 'Define New Keyword', 1),
(525, 'Refund Amount', 0, '2018-10-27 10:51:48', '2018-10-27 10:51:48', NULL, 1, 'Define New Keyword', 1),
(526, 'Total Loans', 0, '2018-10-27 10:51:48', '2018-10-27 10:51:48', NULL, 1, 'Define New Keyword', 1),
(527, 'Total Refund', 0, '2018-10-27 10:51:48', '2018-10-27 10:51:48', NULL, 1, 'Define New Keyword', 1),
(528, 'تسجيل قرض جديد', 0, '2018-10-27 10:51:49', '2018-10-27 10:51:49', NULL, 1, 'Define New Keyword', 1),
(529, 'اسم اللغة', 0, '2018-10-27 10:51:59', '2018-10-27 10:51:59', NULL, 1, 'Define New Keyword', 1),
(530, 'اسم اللغة\n									аҧсуаAfarafAfrikaansAkanShqipአማርኛالعربيةAragonésՀայերենঅসমীয়াавар мацӀ, магӀарул мацӀavestaaymar aruazərbaycan dilibamanankanбашҡорт телеeuskara, euskeraБеларускаяবাংলাभोजपुरीBislamabosanski jezikbrezhonegбългарски езикဗမာစာCatalàChamoruнохчийн моттchiCheŵa, chinyanja中文 (Zhōngwén), 汉语, 漢語чӑваш чӗлхиKernewekcorsu, lingua corsaᓀᐦᐃᔭᐍᐏᐣhrvatskičesky, češtinadanskދިވެހިNederlands, VlaamsEnglishEsperantoeesti, eesti keelEʋegbeføroysktvosa Vakavitisuomi, suomen kielifrançais, langue', 1, '2018-10-27 10:51:59', '2018-10-27 10:58:18', NULL, 1, 'Delete Keywords', 1),
(531, 'اتجاه اللغة\n									من اليسار الى اليمين\n									من اليمين الى اليسار', 1, '2018-10-27 10:51:59', '2018-10-27 10:58:15', NULL, 1, 'Delete Keywords', 1),
(532, 'كلا\n									نعم', 1, '2018-10-27 10:51:59', '2018-10-27 10:58:11', NULL, 1, 'Delete Keywords', 1),
(533, 'نعم', 0, '2018-10-27 10:51:59', '2018-10-27 10:51:59', NULL, 1, 'Define New Keyword', 1),
(534, 'اسم اللغة\n												аҧсуаAfarafAfrikaansAkanShqipአማርኛالعربيةAragonésՀայերենঅসমীয়াавар мацӀ, магӀарул мацӀavestaaymar aruazərbaycan dilibamanankanбашҡорт телеeuskara, euskeraБеларускаяবাংলাभोजपुरीBislamabosanski jezikbrezhonegбългарски езикဗမာစာCatalàChamoruнохчийн моттchiCheŵa, chinyanja中文 (Zhōngwén), 汉语, 漢語чӑваш чӗлхиKernewekcorsu, lingua corsaᓀᐦᐃᔭᐍᐏᐣhrvatskičesky, češtinadanskދިވެހިNederlands, VlaamsEnglishEsperantoeesti, eesti keelEʋegbeføroysktvosa Vakavitisuomi, suomen kielifrançais, lan', 1, '2018-10-27 10:51:59', '2018-10-27 10:58:04', NULL, 1, 'Delete Keywords', 1),
(535, 'لغة افتراضية؟', 0, '2018-10-27 10:51:59', '2018-10-27 10:51:59', NULL, 1, 'Define New Keyword', 1),
(536, 'كلا', 0, '2018-10-27 10:51:59', '2018-10-27 10:51:59', NULL, 1, 'Define New Keyword', 1),
(537, 'تحرير اللغة', 0, '2018-10-27 10:51:59', '2018-10-27 10:51:59', NULL, 1, 'Define New Keyword', 1),
(538, 'اتجاه اللغة\n												من اليسار الى اليمين\n												من اليمين الى اليسار', 1, '2018-10-27 10:51:59', '2018-10-27 10:57:29', NULL, 1, 'Delete Keywords', 1),
(539, 'كلا\n												نعم', 1, '2018-10-27 10:51:59', '2018-10-27 10:57:24', NULL, 1, 'Delete Keywords', 1),
(540, 'اسم اللغة المحلي', 0, '2018-10-27 10:51:59', '2018-10-27 10:51:59', NULL, 1, 'Define New Keyword', 1),
(541, 'الاسم العالمي', 0, '2018-10-27 10:51:59', '2018-10-27 10:51:59', NULL, 1, 'Define New Keyword', 1),
(542, 'عرض وترجمة كلمات هذه اللغة', 0, '2018-10-27 10:51:59', '2018-10-27 10:51:59', NULL, 1, 'Define New Keyword', 1),
(543, 'غير افتراضية', 0, '2018-10-27 10:51:59', '2018-10-27 10:51:59', NULL, 1, 'Define New Keyword', 1),
(544, 'اللغة الافتراضية', 0, '2018-10-27 10:51:59', '2018-10-27 10:51:59', NULL, 1, 'Define New Keyword', 1),
(545, 'اضافة لغة جديدة', 0, '2018-10-27 10:51:59', '2018-10-27 10:51:59', NULL, 1, 'Define New Keyword', 1),
(546, 'اسم اللغة\n									аҧсуаAfarafAfrikaansAkanShqipአማርኛالعربيةAragonésՀայերենঅসমীয়াавар мацӀ, магӀарул мацӀavestaaymar aruazərbaycan dilibamanankanбашҡорт телеeuskara, euskeraБеларускаяবাংলাभोजपुरीBislamabosanski jezikbrezhonegбългарски езикဗမာစာCatalàChamoruнохчийн моттchiCheŵa, chinyanja中文 (Zhōngwén), 汉语, 漢語чӑваш чӗлхиKernewekcorsu, lingua corsaᓀᐦᐃᔭᐍᐏᐣhrvatskičesky, češtinadanskދިވެހިNederlands, VlaamsEnglishEsperantoeesti, eesti keelEʋegbeføroysktvosa Vakavitisuomi, suomen kielifrançais, langue', 1, '2018-10-27 10:52:01', '2018-10-27 10:55:49', NULL, 1, 'Delete Keywords', 1),
(547, 'اسم اللغة\n												аҧсуаAfarafAfrikaansAkanShqipአማርኛالعربيةAragonésՀայերենঅসমীয়াавар мацӀ, магӀарул мацӀavestaaymar aruazərbaycan dilibamanankanбашҡорт телеeuskara, euskeraБеларускаяবাংলাभोजपुरीBislamabosanski jezikbrezhonegбългарски езикဗမာစာCatalàChamoruнохчийн моттchiCheŵa, chinyanja中文 (Zhōngwén), 汉语, 漢語чӑваш чӗлхиKernewekcorsu, lingua corsaᓀᐦᐃᔭᐍᐏᐣhrvatskičesky, češtinadanskދިވެހިNederlands, VlaamsEnglishEsperantoeesti, eesti keelEʋegbeføroysktvosa Vakavitisuomi, suomen kielifrançais, lan', 1, '2018-10-27 10:52:01', '2018-10-27 10:55:46', NULL, 1, 'Delete Keywords', 1),
(548, 'تاريخ التسليم', 0, '2018-10-27 10:52:24', '2018-10-27 10:52:24', NULL, 1, 'Define New Keyword', 1),
(549, 'ملف الاسعار', 0, '2018-10-27 10:52:24', '2018-10-27 10:52:24', NULL, 1, 'Define New Keyword', 1),
(550, 'Model', 1, '2018-10-27 10:52:24', '2018-10-27 10:55:16', NULL, 1, 'Delete Keywords', 1),
(551, 'الارتفاع (ملم)', 1, '2018-10-27 10:52:24', '2018-10-27 10:55:12', NULL, 1, 'Delete Keywords', 1),
(552, 'العرض (ملم)', 1, '2018-10-27 10:52:24', '2018-10-27 10:55:08', NULL, 1, 'Delete Keywords', 1),
(553, 'اللون', 0, '2018-10-27 10:52:24', '2018-10-27 10:52:24', NULL, 1, 'Define New Keyword', 1),
(554, 'Comment', 1, '2018-10-27 10:52:24', '2018-10-27 10:54:59', NULL, 1, 'Delete Keywords', 1),
(555, 'المساحة (م2)', 1, '2018-10-27 10:52:24', '2018-10-27 10:54:54', NULL, 1, 'Delete Keywords', 1),
(556, 'اخر سعر بيع', 0, '2018-10-27 10:52:24', '2018-10-27 10:52:24', NULL, 1, 'Define New Keyword', 1),
(557, 'العدد', 0, '2018-10-27 10:52:24', '2018-10-27 10:52:24', NULL, 1, 'Define New Keyword', 1),
(558, 'الارتفاع', 1, '2018-10-27 10:52:24', '2018-10-27 10:54:33', NULL, 1, 'Delete Keywords', 1),
(559, 'العرض', 1, '2018-10-27 10:52:24', '2018-10-27 10:54:29', NULL, 1, 'Delete Keywords', 1),
(560, 'مجموع', 0, '2018-10-27 10:52:24', '2018-10-27 10:52:24', NULL, 1, 'Define New Keyword', 1),
(561, 'تنزيلات', 0, '2018-10-27 10:52:24', '2018-10-27 10:52:24', NULL, 1, 'Define New Keyword', 1),
(562, 'سعر نهائي', 0, '2018-10-27 10:52:24', '2018-10-27 10:52:24', NULL, 1, 'Define New Keyword', 1),
(563, 'معاينة الطلبات قبل البدء بعملية الانتاج', 1, '2018-10-27 10:52:24', '2018-10-27 10:53:19', NULL, 1, 'Delete Keywords', 1),
(564, 'البدء بمرحلة الانتاج', 1, '2018-10-27 10:52:24', '2018-10-27 10:53:16', NULL, 1, 'Delete Keywords', 1),
(565, 'المشتري', 1, '2018-10-27 10:52:24', '2018-10-27 10:53:11', NULL, 1, 'Delete Keywords', 1),
(566, 'C. Company', 1, '2018-10-27 10:52:24', '2018-10-27 10:53:03', NULL, 1, 'Delete Keywords', 1),
(567, 'سوف تقوم بحذف الكلمة الدلالية وسوف تحذف هذه الكلمة من جميع اللغات !! هل انت متأكد من رغبتك بحذف هذه الكلمة الدلالية', 0, '2018-10-27 10:53:01', '2018-10-27 10:53:01', NULL, 1, 'Define New Keyword', 1);

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

--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
  `language_id` int(11) NOT NULL,
  `language_name` varchar(200) DEFAULT NULL,
  `language_symbol` varchar(30) DEFAULT NULL,
  `language_icon` varchar(300) DEFAULT NULL,
  `language_dir` varchar(4) DEFAULT NULL COMMENT 'ltr : rtl',
  `language_localazation` varchar(300) DEFAULT NULL,
  `is_defualt` int(1) DEFAULT 0 COMMENT '0:Not_defualt; 1:Defualt',
  `is_deleted` int(1) DEFAULT 0,
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `last_action` varchar(100) DEFAULT NULL,
  `last_action_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `languages`
--

INSERT INTO `languages` (`language_id`, `language_name`, `language_symbol`, `language_icon`, `language_dir`, `language_localazation`, `is_defualt`, `is_deleted`, `created_at`, `updated_at`, `deleted_at`, `created_by`, `last_action`, `last_action_by`) VALUES
(1, 'العربية', 'ar', '', 'rtl', 'Arabic', 1, 0, '2018-02-09 17:03:38', '2018-02-09 17:24:33', '2018-02-09 03:24:14', 1, 'Delete language', 1),
(2, 'English', 'en', '', 'ltr', 'English', 0, 0, '2018-02-10 11:09:04', '2018-02-10 11:09:04', NULL, 1, 'Create New language', 1),
(3, 'كوردی‎', 'ku', '', 'rtl', 'Kurdish', 0, 0, '2018-02-10 13:57:18', '2018-02-10 13:57:18', NULL, 1, 'Create New language', 1),
(4, 'አማርኛ', 'am', '', 'rtl', 'Amharic', 0, 1, '2018-02-12 12:43:42', '2018-02-12 13:10:59', '2018-02-12 11:10:59', 1, 'Delete language', 1),
(5, 'Afrikaans', 'af', '', 'rtl', 'Afrikaans', 0, 1, '2018-02-13 12:12:51', '2018-02-13 12:13:05', '2018-02-13 10:13:05', 1, 'Delete language', 1);

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

--
-- Table structure for table `languages_keywords`
--

CREATE TABLE `languages_keywords` (
  `language_keyword_id` int(11) NOT NULL,
  `language_id_fk` int(11) DEFAULT NULL,
  `keyword_id_fk` int(11) DEFAULT NULL,
  `translated_keyword` varchar(500) DEFAULT NULL,
  `is_deleted` int(1) DEFAULT 0,
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `last_action` varchar(100) DEFAULT NULL,
  `last_action_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



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

--
-- Table structure for table `product`
--

CREATE TABLE `product` (
  `product_id` int(11) NOT NULL,
  `product_name` varchar(300) DEFAULT NULL,
  `product_code` varchar(150) DEFAULT NULL,
  `barcode` varchar(150) DEFAULT NULL,
  `made_in` varchar(150) DEFAULT NULL,
  `company_code` varchar(100) DEFAULT NULL,
  `image_path` varchar(300) DEFAULT NULL,
  `color` varchar(20) DEFAULT NULL,
  `product_type` varchar(30) DEFAULT NULL,
  `product_property` text DEFAULT NULL,
  `sell_price` decimal(10,2) DEFAULT NULL COMMENT 'LIFO from purchase update too and can set from here',
  `cost_price` decimal(10,2) NOT NULL,
  `product_sequence` int(11) DEFAULT NULL,
  `product_note` text DEFAULT NULL,
  `product_min_notification` int(11) DEFAULT NULL,
  `category_id_fk` int(11) DEFAULT NULL,
  `is_hidden` int(1) NOT NULL DEFAULT 0 COMMENT '0:Show; 1:hide;',
  `is_deleted` int(1) DEFAULT 0,
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `last_action` varchar(100) DEFAULT NULL,
  `last_action_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `product`
--

INSERT INTO `product` (`product_id`, `product_name`, `product_code`, `barcode`, `made_in`, `company_code`, `image_path`, `color`, `product_type`, `product_property`, `sell_price`, `cost_price`, `product_sequence`, `product_note`, `product_min_notification`, `category_id_fk`, `is_hidden`, `is_deleted`, `created_at`, `updated_at`, `deleted_at`, `created_by`, `last_action`, `last_action_by`) VALUES
(1, 'Test Products', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 50.00, 40.00, NULL, 'Note 1\r\nNote 2', NULL, 1, 0, 1, '2022-03-02 22:16:37', '2022-03-02 23:29:13', '2022-03-03 09:40:51', 1, 'Delete Product', 1),
(2, 'F5260', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 20.00, 8.50, NULL, '', NULL, 4, 0, 0, '2022-03-03 09:49:48', '2022-03-03 10:22:25', NULL, 1, 'Update Product', 1),
(3, 'F4491U', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 22.00, 10.00, NULL, '', NULL, 4, 0, 0, '2022-03-03 09:54:09', '2022-03-03 09:54:09', NULL, 1, 'Create New Product', 1),
(4, 'F5095', NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, 25.00, 10.00, NULL, '', NULL, 4, 0, 0, '2022-03-03 09:54:51', '2022-03-03 09:54:51', NULL, 1, 'Delete Image', 1),
(5, 'DF5359', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 28.00, 10.00, NULL, '', NULL, 4, 0, 0, '2022-03-03 09:57:23', '2022-03-03 10:07:30', NULL, 1, 'Update Product', 1),
(6, 'F5250', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 20.00, 8.50, NULL, '', NULL, 4, 0, 0, '2022-03-03 10:01:05', '2022-03-03 10:07:39', NULL, 1, 'Update Product', 1),
(7, 'F4520', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 22.00, 10.00, NULL, '', NULL, 4, 0, 0, '2022-03-03 10:01:32', '2022-03-03 10:07:48', NULL, 1, 'Update Product', 1),
(8, 'F4307U', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 24.00, 8.50, NULL, '', NULL, 4, 0, 0, '2022-03-03 10:02:13', '2022-03-03 10:04:02', NULL, 1, 'Update Product', 1),
(9, 'DF4776', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 24.00, 10.00, NULL, '', NULL, 4, 0, 0, '2022-03-03 10:02:41', '2022-03-03 10:04:10', NULL, 1, 'Update Product', 1),
(10, 'DONER402', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 6.00, NULL, '', NULL, 3, 0, 0, '2022-03-03 10:02:58', '2022-03-03 10:04:42', NULL, 1, 'Update Product', 1),
(11, '5500', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10.00, 6.00, NULL, '', NULL, 3, 0, 0, '2022-03-03 10:03:09', '2022-03-03 10:07:12', NULL, 1, 'Show Product', 1),
(12, '24F3220B', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 6.00, NULL, '', NULL, 3, 0, 0, '2022-03-03 10:08:14', '2022-03-03 10:08:14', NULL, 1, 'Create New Product', 1),
(13, '8135', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 13.00, 6.50, NULL, '', NULL, 3, 0, 0, '2022-03-03 10:08:35', '2022-03-03 10:08:35', NULL, 1, 'Create New Product', 1),
(14, '8138', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 6.00, NULL, '', NULL, 3, 0, 0, '2022-03-03 10:08:51', '2022-03-03 10:08:51', NULL, 1, 'Create New Product', 1),
(15, '8141', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 6.50, NULL, '', NULL, 3, 0, 0, '2022-03-03 10:09:04', '2022-03-03 10:09:04', NULL, 1, 'Create New Product', 1),
(16, '8145', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10.00, 6.50, NULL, '', NULL, 3, 0, 0, '2022-03-03 10:09:19', '2022-03-03 10:09:19', NULL, 1, 'Create New Product', 1),
(17, '464187', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10.00, 6.50, NULL, '', NULL, 3, 0, 0, '2022-03-03 10:10:05', '2022-03-03 10:10:05', NULL, 1, 'Create New Product', 1),
(18, 'LENO208', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 6.50, NULL, '', NULL, 3, 0, 0, '2022-03-03 10:11:56', '2022-03-03 10:11:56', NULL, 1, 'Create New Product', 1),
(19, 'DONER292C', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 7.50, NULL, '', NULL, 3, 0, 0, '2022-03-03 10:12:13', '2022-03-03 10:12:13', NULL, 1, 'Create New Product', 1),
(20, 'LENO353', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 7.00, NULL, '', NULL, 3, 0, 0, '2022-03-03 10:12:28', '2022-03-03 10:12:28', NULL, 1, 'Create New Product', 1),
(21, 'DONER113T', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 13.00, 7.50, NULL, '', NULL, 3, 0, 0, '2022-03-03 10:12:52', '2022-03-03 10:12:52', NULL, 1, 'Create New Product', 1),
(22, '4017', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 28.00, 18.00, NULL, '', NULL, 3, 0, 0, '2022-03-03 10:13:23', '2022-03-03 10:13:23', NULL, 1, 'Create New Product', 1),
(23, 'GREKTUL+1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 18.00, 9.00, NULL, '', NULL, 3, 0, 0, '2022-03-03 10:13:49', '2022-03-03 10:13:49', NULL, 1, 'Create New Product', 1),
(24, '13412145', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 19.00, 9.00, NULL, '', NULL, 3, 0, 0, '2022-03-03 10:14:03', '2022-03-03 10:14:03', NULL, 1, 'Create New Product', 1),
(25, '214312145', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 18.00, 9.00, NULL, '', NULL, 3, 0, 0, '2022-03-03 10:14:19', '2022-03-03 10:14:19', NULL, 1, 'Create New Product', 1),
(26, '229112145', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 19.00, 9.00, NULL, '', NULL, 3, 0, 0, '2022-03-03 10:14:35', '2022-03-03 10:14:35', NULL, 1, 'Create New Product', 1),
(27, '48FK3237B', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 20.00, 11.00, NULL, '', NULL, 3, 0, 0, '2022-03-03 10:14:57', '2022-03-03 10:14:57', NULL, 1, 'Create New Product', 1),
(28, 'PANAMA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8.00, 4.00, NULL, '', NULL, 4, 0, 0, '2022-03-03 10:17:08', '2022-03-03 10:17:08', NULL, 1, 'Create New Product', 1),
(29, 'SOFT-IPEK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 7.00, 4.00, NULL, '', NULL, 4, 0, 0, '2022-03-03 10:19:53', '2022-03-03 10:19:53', NULL, 1, 'Create New Product', 1),
(30, 'VALVET-QADIFA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 6.00, NULL, '', NULL, 4, 0, 0, '2022-03-03 10:20:16', '2022-03-03 10:20:16', NULL, 1, 'Create New Product', 1),
(31, 'SHANEL', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 14.00, 7.00, NULL, '', NULL, 4, 0, 0, '2022-03-03 10:20:35', '2022-03-03 10:20:35', NULL, 1, 'Create New Product', 1),
(32, '100-101-102-103-104-105-106-107-108-109', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 9.00, 7.00, NULL, '', NULL, 2, 0, 1, '2022-03-03 10:53:48', '2022-03-03 10:59:00', '2022-03-03 11:07:05', 1, 'Delete Product', 1),
(33, '140-141-142-143-144-145-146', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10.00, 7.00, NULL, '', NULL, 2, 0, 1, '2022-03-03 11:00:13', '2022-03-03 11:00:13', '2022-03-03 11:06:59', 1, 'Delete Product', 1),
(34, '100-109', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 9.00, 7.00, NULL, '', NULL, 2, 0, 1, '2022-03-03 11:06:54', '2022-03-03 11:07:39', '2022-03-03 11:11:00', 1, 'Delete Product', 1),
(35, '100', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 9.00, 7.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 11:58:29', '2022-03-03 11:58:29', NULL, 1, 'Create New Product', 1),
(36, '101', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 9.00, 7.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 11:59:12', '2022-03-03 11:59:12', NULL, 1, 'Create New Product', 1),
(37, '102', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 9.00, 7.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:02:14', '2022-03-03 12:02:14', NULL, 1, 'Create New Product', 1),
(38, '103', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 9.00, 7.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:02:36', '2022-03-03 12:02:36', NULL, 1, 'Create New Product', 1),
(39, '104', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 9.00, 7.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:02:56', '2022-03-03 12:02:56', NULL, 1, 'Create New Product', 1),
(40, '105', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 9.00, 7.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:03:09', '2022-03-03 12:03:09', NULL, 1, 'Create New Product', 1),
(41, '106', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 9.00, 7.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:03:25', '2022-03-03 12:03:25', NULL, 1, 'Create New Product', 1),
(42, '106', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 9.00, 7.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:03:39', '2022-03-03 12:03:39', NULL, 1, 'Create New Product', 1),
(43, '107', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 9.00, 7.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:03:55', '2022-03-03 12:03:55', NULL, 1, 'Create New Product', 1),
(44, '108', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 9.00, 7.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:04:12', '2022-03-03 12:04:12', NULL, 1, 'Create New Product', 1),
(45, '109', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 9.00, 7.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:04:31', '2022-03-03 12:04:31', NULL, 1, 'Create New Product', 1),
(46, '140', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10.00, 7.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:04:56', '2022-03-03 12:04:56', NULL, 1, 'Create New Product', 1),
(47, '141', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10.00, 7.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:05:10', '2022-03-03 12:05:10', NULL, 1, 'Create New Product', 1),
(48, '142', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10.00, 7.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:05:29', '2022-03-03 12:05:29', NULL, 1, 'Create New Product', 1),
(49, '143', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10.00, 7.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:05:45', '2022-03-03 12:05:45', NULL, 1, 'Create New Product', 1),
(50, '144', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10.00, 7.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:05:59', '2022-03-03 12:05:59', NULL, 1, 'Create New Product', 1),
(51, '145', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10.00, 7.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:06:22', '2022-03-03 12:06:22', NULL, 1, 'Create New Product', 1),
(52, '146', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10.00, 7.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:06:41', '2022-03-03 12:06:41', NULL, 1, 'Create New Product', 1),
(53, '110', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:07:30', '2022-03-03 12:07:30', NULL, 1, 'Create New Product', 1),
(54, '111', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:07:48', '2022-03-03 12:07:48', NULL, 1, 'Create New Product', 1),
(55, '112', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:08:11', '2022-03-03 12:08:11', NULL, 1, 'Create New Product', 1),
(56, '113', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:08:28', '2022-03-03 12:08:28', NULL, 1, 'Create New Product', 1),
(57, '114', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:08:45', '2022-03-03 12:08:45', NULL, 1, 'Create New Product', 1),
(58, '115', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:09:01', '2022-03-03 12:09:01', NULL, 1, 'Create New Product', 1),
(59, '116', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:09:29', '2022-03-03 12:09:29', NULL, 1, 'Create New Product', 1),
(60, '117', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:09:43', '2022-03-03 12:09:43', NULL, 1, 'Create New Product', 1),
(61, '118', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:10:15', '2022-03-03 12:10:15', NULL, 1, 'Create New Product', 1),
(62, '119', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:10:33', '2022-03-03 12:10:33', NULL, 1, 'Create New Product', 1),
(63, '120', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:11:21', '2022-03-03 12:11:21', NULL, 1, 'Create New Product', 1),
(64, '121', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:13:19', '2022-03-03 12:13:19', NULL, 1, 'Create New Product', 1),
(65, '122', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:13:32', '2022-03-03 12:13:32', NULL, 1, 'Create New Product', 1),
(66, '123', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:13:49', '2022-03-03 12:13:49', NULL, 1, 'Create New Product', 1),
(67, '126', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:14:06', '2022-03-03 12:14:06', NULL, 1, 'Create New Product', 1),
(68, '127', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:14:20', '2022-03-03 12:14:20', NULL, 1, 'Create New Product', 1),
(69, '440', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 11.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:14:39', '2022-03-03 12:14:39', NULL, 1, 'Create New Product', 1),
(70, '441', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 11.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:14:56', '2022-03-03 12:14:56', NULL, 1, 'Create New Product', 1),
(71, '442', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 11.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:15:15', '2022-03-03 12:15:15', NULL, 1, 'Create New Product', 1),
(72, '443', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 11.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:15:30', '2022-03-03 12:15:30', NULL, 1, 'Create New Product', 1),
(73, '444', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 11.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:15:46', '2022-03-03 12:15:46', NULL, 1, 'Create New Product', 1),
(74, '445', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 11.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:16:11', '2022-03-03 12:16:11', NULL, 1, 'Create New Product', 1),
(75, '446', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 11.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:16:26', '2022-03-03 12:16:26', NULL, 1, 'Create New Product', 1),
(76, '447', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 11.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:16:45', '2022-03-03 12:16:45', NULL, 1, 'Create New Product', 1),
(77, '448', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 11.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:16:59', '2022-03-03 12:16:59', NULL, 1, 'Create New Product', 1),
(78, '449', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 11.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:17:15', '2022-03-03 12:17:15', NULL, 1, 'Create New Product', 1),
(79, '450', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 11.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:17:30', '2022-03-03 12:17:30', NULL, 1, 'Create New Product', 1),
(80, '451', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 11.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:17:46', '2022-03-03 12:17:46', NULL, 1, 'Create New Product', 1),
(81, '135', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:18:10', '2022-03-03 12:18:10', NULL, 1, 'Create New Product', 1),
(82, '136', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:18:26', '2022-03-03 12:18:26', NULL, 1, 'Create New Product', 1),
(83, '137', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:18:41', '2022-03-03 12:18:41', NULL, 1, 'Create New Product', 1),
(84, '138', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:18:56', '2022-03-03 12:18:56', NULL, 1, 'Create New Product', 1),
(85, '139', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:19:11', '2022-03-03 12:19:11', NULL, 1, 'Create New Product', 1),
(86, '147', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:19:39', '2022-03-03 12:19:39', NULL, 1, 'Create New Product', 1),
(87, '148', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:19:52', '2022-03-03 12:19:52', NULL, 1, 'Create New Product', 1),
(88, '149', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:20:09', '2022-03-03 12:20:09', NULL, 1, 'Create New Product', 1),
(89, '150', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:20:24', '2022-03-03 12:20:24', NULL, 1, 'Create New Product', 1),
(90, '151', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:20:43', '2022-03-03 12:20:43', NULL, 1, 'Create New Product', 1),
(91, '152', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:20:55', '2022-03-03 12:20:55', NULL, 1, 'Create New Product', 1),
(92, '162', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:21:16', '2022-03-03 12:21:16', NULL, 1, 'Create New Product', 1),
(93, '163', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:21:31', '2022-03-03 12:21:31', NULL, 1, 'Create New Product', 1),
(94, '164', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:21:46', '2022-03-03 12:21:46', NULL, 1, 'Create New Product', 1),
(95, '165', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:22:03', '2022-03-03 12:22:03', NULL, 1, 'Create New Product', 1),
(96, '166', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:22:20', '2022-03-03 12:22:20', NULL, 1, 'Create New Product', 1),
(97, '167', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:22:38', '2022-03-03 12:22:38', NULL, 1, 'Create New Product', 1),
(98, '168', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:22:53', '2022-03-03 12:22:53', NULL, 1, 'Create New Product', 1),
(99, '515', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:23:08', '2022-03-03 12:23:08', NULL, 1, 'Create New Product', 1),
(100, '516', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:23:22', '2022-03-03 12:23:22', NULL, 1, 'Create New Product', 1),
(101, '517', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:23:38', '2022-03-03 12:23:38', NULL, 1, 'Create New Product', 1),
(102, '518', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:23:56', '2022-03-03 12:23:56', NULL, 1, 'Create New Product', 1),
(103, '304', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:24:18', '2022-03-03 12:24:18', NULL, 1, 'Create New Product', 1),
(104, '305', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:24:31', '2022-03-03 12:24:31', NULL, 1, 'Create New Product', 1),
(105, '306', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:24:46', '2022-03-03 12:24:46', NULL, 1, 'Create New Product', 1),
(106, '307', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:25:00', '2022-03-03 12:25:00', NULL, 1, 'Create New Product', 1),
(107, '308', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:25:16', '2022-03-03 12:25:16', NULL, 1, 'Create New Product', 1),
(108, '309', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 0, 0, 0, '2022-03-03 12:25:30', '2022-03-03 12:25:30', NULL, 1, 'Create New Product', 1),
(109, '865', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:25:46', '2022-03-03 12:25:46', NULL, 1, 'Create New Product', 1),
(110, '866', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:26:00', '2022-03-03 12:26:00', NULL, 1, 'Create New Product', 1),
(111, '867', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:26:18', '2022-03-03 12:26:18', NULL, 1, 'Create New Product', 1),
(112, '868', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:26:37', '2022-03-03 12:26:37', NULL, 1, 'Create New Product', 1),
(113, '869', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:26:55', '2022-03-03 12:26:55', NULL, 1, 'Create New Product', 1),
(114, '870', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:27:14', '2022-03-03 12:27:14', NULL, 1, 'Create New Product', 1),
(115, '880', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:27:30', '2022-03-03 12:27:30', NULL, 1, 'Create New Product', 1),
(116, '881', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:27:44', '2022-03-03 12:27:44', NULL, 1, 'Create New Product', 1),
(117, '882', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:27:55', '2022-03-03 12:27:55', NULL, 1, 'Create New Product', 1),
(118, '883', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:28:07', '2022-03-03 12:28:07', NULL, 1, 'Create New Product', 1),
(119, '884', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:28:24', '2022-03-03 12:28:24', NULL, 1, 'Create New Product', 1),
(120, '885', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:28:48', '2022-03-03 12:28:48', NULL, 1, 'Create New Product', 1),
(121, '886', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:29:01', '2022-03-03 12:29:01', NULL, 1, 'Create New Product', 1),
(122, '889', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 1, '2022-03-03 12:29:19', '2022-03-03 12:29:19', '2022-03-03 12:30:55', 1, 'Delete Product', 1),
(123, '892', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:31:14', '2022-03-03 12:31:14', NULL, 1, 'Create New Product', 1),
(124, '893', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:31:32', '2022-03-03 12:31:32', NULL, 1, 'Create New Product', 1),
(125, '894', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:31:44', '2022-03-03 12:31:44', NULL, 1, 'Create New Product', 1),
(126, '895', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:31:57', '2022-03-03 12:31:57', NULL, 1, 'Create New Product', 1),
(127, '896', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:32:13', '2022-03-03 12:32:13', NULL, 1, 'Create New Product', 1),
(128, '897', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:32:28', '2022-03-03 12:32:28', NULL, 1, 'Create New Product', 1),
(129, '898', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:32:46', '2022-03-03 12:32:46', NULL, 1, 'Create New Product', 1),
(130, '899', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12.00, 8.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:33:04', '2022-03-03 12:33:04', NULL, 1, 'Create New Product', 1),
(131, '832', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 13.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:34:32', '2022-03-03 12:34:32', NULL, 1, 'Create New Product', 1),
(132, '833', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 13.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:34:53', '2022-03-03 12:34:53', NULL, 1, 'Create New Product', 1),
(133, '835', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 13.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:35:09', '2022-03-03 12:35:09', NULL, 1, 'Create New Product', 1),
(134, '836', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 13.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:35:27', '2022-03-03 12:35:27', NULL, 1, 'Create New Product', 1),
(135, '837', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 13.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:35:53', '2022-03-03 12:35:53', NULL, 1, 'Create New Product', 1),
(136, '834', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 13.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:36:12', '2022-03-03 12:36:12', NULL, 1, 'Create New Product', 1),
(137, '320', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 14.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:36:57', '2022-03-03 12:36:57', NULL, 1, 'Create New Product', 1),
(138, '321', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 14.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:37:12', '2022-03-03 12:37:12', NULL, 1, 'Create New Product', 1),
(139, '322', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 14.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:37:28', '2022-03-03 12:37:28', NULL, 1, 'Create New Product', 1),
(140, '323', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 14.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:37:44', '2022-03-03 12:37:44', NULL, 1, 'Create New Product', 1),
(141, '324', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 14.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:38:22', '2022-03-03 12:38:22', NULL, 1, 'Create New Product', 1),
(142, '325', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 14.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 12:38:35', '2022-03-03 12:38:35', NULL, 1, 'Create New Product', 1),
(143, '326', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 14.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 13:21:24', '2022-03-03 13:21:24', NULL, 1, 'Create New Product', 1),
(144, '327', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 14.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 13:21:41', '2022-03-03 13:21:41', NULL, 1, 'Create New Product', 1),
(145, '328', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 14.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 13:21:57', '2022-03-03 13:21:57', NULL, 1, 'Create New Product', 1),
(146, '329', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 14.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 13:22:20', '2022-03-03 13:22:20', NULL, 1, 'Create New Product', 1),
(147, '330', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 14.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 13:22:37', '2022-03-03 13:22:37', NULL, 1, 'Create New Product', 1),
(148, '331', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 14.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 13:22:54', '2022-03-03 13:22:54', NULL, 1, 'Create New Product', 1),
(149, '332', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 14.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 13:23:10', '2022-03-03 13:23:10', NULL, 1, 'Create New Product', 1),
(150, '333', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 14.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 13:23:24', '2022-03-03 13:23:24', NULL, 1, 'Create New Product', 1),
(151, '339', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 14.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 13:23:46', '2022-03-03 13:23:46', NULL, 1, 'Create New Product', 1),
(152, '340', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 14.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 13:24:03', '2022-03-03 13:24:03', NULL, 1, 'Create New Product', 1),
(153, '341', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 14.00, 10.00, NULL, '', NULL, 0, 0, 0, '2022-03-03 13:24:28', '2022-03-03 13:24:28', NULL, 1, 'Create New Product', 1),
(154, '342', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 14.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 13:24:46', '2022-03-03 13:24:46', NULL, 1, 'Create New Product', 1),
(155, '400', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 13:56:14', '2022-03-03 13:56:14', NULL, 1, 'Create New Product', 1),
(156, '401', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 13:56:47', '2022-03-03 13:56:47', NULL, 1, 'Create New Product', 1),
(157, '402', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 13:57:21', '2022-03-03 13:57:21', NULL, 1, 'Create New Product', 1),
(158, '403', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 13:57:37', '2022-03-03 13:57:37', NULL, 1, 'Create New Product', 1),
(159, '404', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 13:57:55', '2022-03-03 13:57:55', NULL, 1, 'Create New Product', 1),
(160, '405', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 13:58:21', '2022-03-03 13:58:21', NULL, 1, 'Create New Product', 1),
(161, '406', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 13:58:35', '2022-03-03 13:58:35', NULL, 1, 'Create New Product', 1),
(162, '407', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 13:58:51', '2022-03-03 13:58:51', NULL, 1, 'Create New Product', 1),
(163, '408', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 13:59:05', '2022-03-03 13:59:05', NULL, 1, 'Create New Product', 1),
(164, '221', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 13:59:29', '2022-03-03 13:59:29', NULL, 1, 'Create New Product', 1),
(165, '222', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 13:59:54', '2022-03-03 13:59:54', NULL, 1, 'Create New Product', 1),
(166, '223', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:00:13', '2022-03-03 14:00:13', NULL, 1, 'Create New Product', 1),
(167, '224', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:00:33', '2022-03-03 14:00:33', NULL, 1, 'Create New Product', 1),
(168, '225', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:00:48', '2022-03-03 14:00:48', NULL, 1, 'Create New Product', 1),
(169, '226', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:01:06', '2022-03-03 14:01:06', NULL, 1, 'Create New Product', 1),
(170, '227', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:05:58', '2022-03-03 14:05:58', NULL, 1, 'Create New Product', 1),
(171, '229', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:06:12', '2022-03-03 14:06:12', NULL, 1, 'Create New Product', 1),
(172, '231', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:06:26', '2022-03-03 14:06:26', NULL, 1, 'Create New Product', 1),
(173, '356', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:06:49', '2022-03-03 14:06:49', NULL, 1, 'Create New Product', 1),
(174, '357', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:07:01', '2022-03-03 14:07:01', NULL, 1, 'Create New Product', 1),
(175, '361', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:07:11', '2022-03-03 14:07:11', NULL, 1, 'Create New Product', 1),
(176, '740', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:07:22', '2022-03-03 14:07:34', NULL, 1, 'Update Product', 1),
(177, '741', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:08:06', '2022-03-03 14:08:06', NULL, 1, 'Create New Product', 1),
(178, '742', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:08:19', '2022-03-03 14:08:19', NULL, 1, 'Create New Product', 1),
(179, '743', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:08:33', '2022-03-03 14:08:33', NULL, 1, 'Create New Product', 1),
(180, '744', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:08:43', '2022-03-03 14:08:43', NULL, 1, 'Create New Product', 1),
(181, '745', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:08:55', '2022-03-03 14:08:55', NULL, 1, 'Create New Product', 1),
(182, '750', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:09:15', '2022-03-03 14:09:15', NULL, 1, 'Create New Product', 1),
(183, '751', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:09:28', '2022-03-03 14:09:28', NULL, 1, 'Create New Product', 1),
(184, '752', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:09:38', '2022-03-03 14:09:38', NULL, 1, 'Create New Product', 1),
(185, '753', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:09:49', '2022-03-03 14:09:49', NULL, 1, 'Create New Product', 1),
(186, '754', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:09:59', '2022-03-03 14:09:59', NULL, 1, 'Create New Product', 1),
(187, '755', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:10:11', '2022-03-03 14:10:11', NULL, 1, 'Create New Product', 1),
(188, '380', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:10:28', '2022-03-03 14:10:28', NULL, 1, 'Create New Product', 1),
(189, '381', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:10:38', '2022-03-03 14:10:38', NULL, 1, 'Create New Product', 1),
(190, '382', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:10:54', '2022-03-03 14:10:54', NULL, 1, 'Create New Product', 1),
(191, '383', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:11:04', '2022-03-03 14:11:04', NULL, 1, 'Create New Product', 1),
(192, '384', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:11:17', '2022-03-03 14:11:17', NULL, 1, 'Create New Product', 1),
(193, '385', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:11:28', '2022-03-03 14:11:28', NULL, 1, 'Create New Product', 1),
(194, '386', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:11:41', '2022-03-03 14:11:41', NULL, 1, 'Create New Product', 1),
(195, '362', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:11:59', '2022-03-03 14:11:59', NULL, 1, 'Create New Product', 1),
(196, '363', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:12:11', '2022-03-03 14:12:11', NULL, 1, 'Create New Product', 1),
(197, '364', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:12:25', '2022-03-03 14:12:25', NULL, 1, 'Create New Product', 1),
(198, '365', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:12:43', '2022-03-03 14:12:43', NULL, 1, 'Create New Product', 1),
(199, '366', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:12:55', '2022-03-03 14:12:55', NULL, 1, 'Create New Product', 1),
(200, '367', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:13:09', '2022-03-03 14:13:09', NULL, 1, 'Create New Product', 1),
(201, '369', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:13:18', '2022-03-03 14:13:18', NULL, 1, 'Create New Product', 1),
(202, '370', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:13:30', '2022-03-03 14:13:30', NULL, 1, 'Create New Product', 1),
(203, '372', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:13:43', '2022-03-03 14:13:43', NULL, 1, 'Create New Product', 1),
(204, '155', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:13:55', '2022-03-03 14:13:55', NULL, 1, 'Create New Product', 1),
(205, '156', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:14:05', '2022-03-03 14:14:05', NULL, 1, 'Create New Product', 1),
(206, '376', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:14:16', '2022-03-03 14:14:16', NULL, 1, 'Create New Product', 1),
(207, '377', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:14:26', '2022-03-03 14:14:26', NULL, 1, 'Create New Product', 1),
(208, '378', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:14:37', '2022-03-03 14:14:37', NULL, 1, 'Create New Product', 1),
(209, '379', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 10.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:14:50', '2022-03-03 14:14:50', NULL, 1, 'Create New Product', 1),
(210, '350', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 17.00, 12.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:15:04', '2022-03-03 14:15:04', NULL, 1, 'Create New Product', 1),
(211, '351', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 17.00, 12.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:15:26', '2022-03-03 14:15:26', NULL, 1, 'Create New Product', 1),
(212, '352', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 17.00, 12.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:15:47', '2022-03-03 14:15:47', NULL, 1, 'Create New Product', 1),
(213, '353', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 17.00, 12.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:16:01', '2022-03-03 14:16:01', NULL, 1, 'Create New Product', 1),
(214, '354', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 17.00, 12.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:16:15', '2022-03-03 14:16:15', NULL, 1, 'Create New Product', 1),
(215, '355', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 17.00, 12.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:16:26', '2022-03-03 14:16:26', NULL, 1, 'Create New Product', 1),
(216, '311', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 12.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:16:39', '2022-03-03 14:16:39', NULL, 1, 'Create New Product', 1),
(217, '312', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 12.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:16:50', '2022-03-03 14:16:50', NULL, 1, 'Create New Product', 1),
(218, '313', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 12.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:17:03', '2022-03-03 14:17:03', NULL, 1, 'Create New Product', 1),
(219, '315', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 12.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:17:14', '2022-03-03 14:17:14', NULL, 1, 'Create New Product', 1),
(220, '316', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 12.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:17:25', '2022-03-03 14:17:25', NULL, 1, 'Create New Product', 1),
(221, '317', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 12.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:17:39', '2022-03-03 14:17:39', NULL, 1, 'Create New Product', 1),
(222, '382', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 12.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:17:49', '2022-03-03 14:17:49', NULL, 1, 'Create New Product', 1),
(223, '393', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 12.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:18:01', '2022-03-03 14:18:01', NULL, 1, 'Create New Product', 1),
(224, '394', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 12.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:18:12', '2022-03-03 14:18:12', NULL, 1, 'Create New Product', 1),
(225, '397', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 12.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:18:23', '2022-03-03 14:18:23', NULL, 1, 'Create New Product', 1),
(226, '398', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 12.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:18:33', '2022-03-03 14:18:33', NULL, 1, 'Create New Product', 1),
(227, '399', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 12.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:18:44', '2022-03-03 14:18:44', NULL, 1, 'Create New Product', 1),
(228, '720', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 19.00, 14.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:18:57', '2022-03-03 14:18:57', NULL, 1, 'Create New Product', 1),
(229, '721', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 19.00, 14.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:19:07', '2022-03-03 14:19:07', NULL, 1, 'Create New Product', 1),
(230, '722', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 19.00, 14.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:19:18', '2022-03-03 14:19:18', NULL, 1, 'Create New Product', 1),
(231, '723', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 19.00, 14.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:19:43', '2022-03-03 14:19:43', NULL, 1, 'Create New Product', 1),
(232, '730', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 19.00, 14.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:19:56', '2022-03-03 14:19:56', NULL, 1, 'Create New Product', 1),
(233, '731', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 19.00, 14.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:20:10', '2022-03-03 14:20:10', NULL, 1, 'Create New Product', 1),
(234, '732', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 19.00, 14.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:20:21', '2022-03-03 14:20:21', NULL, 1, 'Create New Product', 1),
(235, '734', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 19.00, 14.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:20:32', '2022-03-03 14:20:32', NULL, 1, 'Create New Product', 1),
(236, '208', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:20:48', '2022-03-03 14:20:48', NULL, 1, 'Create New Product', 1),
(237, '207', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 161.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:21:15', '2022-03-03 14:21:15', NULL, 1, 'Create New Product', 1),
(238, '206', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:21:26', '2022-03-03 14:21:26', NULL, 1, 'Create New Product', 1),
(239, '205', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:21:41', '2022-03-03 14:21:41', NULL, 1, 'Create New Product', 1),
(240, '204', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:21:51', '2022-03-03 14:21:51', NULL, 1, 'Create New Product', 1),
(241, '203', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:22:02', '2022-03-03 14:22:02', NULL, 1, 'Create New Product', 1),
(242, '202', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:22:14', '2022-03-03 14:22:14', NULL, 1, 'Create New Product', 1),
(243, '201', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:22:29', '2022-03-03 14:22:29', NULL, 1, 'Create New Product', 1),
(244, '537', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:22:41', '2022-03-03 14:22:41', NULL, 1, 'Create New Product', 1),
(245, '536', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:23:02', '2022-03-03 14:23:02', NULL, 1, 'Create New Product', 1),
(246, '535', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:23:13', '2022-03-03 14:23:13', NULL, 1, 'Create New Product', 1),
(247, '534', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:23:25', '2022-03-03 14:23:25', NULL, 1, 'Create New Product', 1),
(248, '533', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:23:40', '2022-03-03 14:23:40', NULL, 1, 'Create New Product', 1),
(249, '532', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:23:52', '2022-03-03 14:23:52', NULL, 1, 'Create New Product', 1),
(250, '531', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:24:02', '2022-03-03 14:24:02', NULL, 1, 'Create New Product', 1),
(251, '524', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:24:12', '2022-03-03 14:24:12', NULL, 1, 'Create New Product', 1),
(252, '523', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:24:23', '2022-03-03 14:24:23', NULL, 1, 'Create New Product', 1),
(253, '522', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:24:38', '2022-03-03 14:24:38', NULL, 1, 'Create New Product', 1),
(254, '521', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:24:51', '2022-03-03 14:24:51', NULL, 1, 'Create New Product', 1),
(255, '520', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:25:04', '2022-03-03 14:25:04', NULL, 1, 'Create New Product', 1),
(256, '558', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:25:31', '2022-03-03 14:25:31', NULL, 1, 'Create New Product', 1),
(257, '557', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:25:42', '2022-03-03 14:25:42', NULL, 1, 'Create New Product', 1),
(258, '556', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:25:53', '2022-03-03 14:25:53', NULL, 1, 'Create New Product', 1),
(259, '555', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:26:03', '2022-03-03 14:26:03', NULL, 1, 'Create New Product', 1),
(260, '554', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:26:13', '2022-03-03 14:26:13', NULL, 1, 'Create New Product', 1),
(261, '553', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:26:24', '2022-03-03 14:26:24', NULL, 1, 'Create New Product', 1),
(262, '552', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:26:39', '2022-03-03 14:26:39', NULL, 1, 'Create New Product', 1),
(263, '514', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:26:51', '2022-03-03 14:26:51', NULL, 1, 'Create New Product', 1),
(264, '513', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:27:03', '2022-03-03 14:27:03', NULL, 1, 'Create New Product', 1),
(265, '512', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:27:16', '2022-03-03 14:27:16', NULL, 1, 'Create New Product', 1),
(266, '511', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:27:33', '2022-03-03 14:27:33', NULL, 1, 'Create New Product', 1),
(267, '510', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:27:47', '2022-03-03 14:27:47', NULL, 1, 'Create New Product', 1),
(268, '506', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:27:59', '2022-03-03 14:27:59', NULL, 1, 'Create New Product', 1),
(269, '505', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:28:10', '2022-03-03 14:28:10', NULL, 1, 'Create New Product', 1),
(270, '550', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:28:23', '2022-03-03 14:28:23', NULL, 1, 'Create New Product', 1),
(271, '549', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:28:33', '2022-03-03 14:28:33', NULL, 1, 'Create New Product', 1),
(272, '548', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:28:43', '2022-03-03 14:28:43', NULL, 1, 'Create New Product', 1),
(273, '547', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:28:56', '2022-03-03 14:28:56', NULL, 1, 'Create New Product', 1),
(274, '546', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:29:06', '2022-03-03 14:29:06', NULL, 1, 'Create New Product', 1),
(275, '545', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:29:43', '2022-03-03 14:29:43', NULL, 1, 'Create New Product', 1),
(276, '705', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:30:01', '2022-03-03 14:30:01', NULL, 1, 'Create New Product', 1),
(277, '704', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:30:14', '2022-03-03 14:30:14', NULL, 1, 'Create New Product', 1);
INSERT INTO `product` (`product_id`, `product_name`, `product_code`, `barcode`, `made_in`, `company_code`, `image_path`, `color`, `product_type`, `product_property`, `sell_price`, `cost_price`, `product_sequence`, `product_note`, `product_min_notification`, `category_id_fk`, `is_hidden`, `is_deleted`, `created_at`, `updated_at`, `deleted_at`, `created_by`, `last_action`, `last_action_by`) VALUES
(278, '703', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:30:29', '2022-03-03 14:30:29', NULL, 1, 'Create New Product', 1),
(279, '702', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:30:48', '2022-03-03 14:30:48', NULL, 1, 'Create New Product', 1),
(280, '701', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:31:02', '2022-03-03 14:31:02', NULL, 1, 'Create New Product', 1),
(281, '700', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:31:15', '2022-03-03 14:31:15', NULL, 1, 'Create New Product', 1),
(282, '564', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:31:27', '2022-03-03 14:31:27', NULL, 1, 'Create New Product', 1),
(283, '573', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:31:42', '2022-03-03 14:31:42', NULL, 1, 'Create New Product', 1),
(284, '562', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:31:52', '2022-03-03 14:31:52', NULL, 1, 'Create New Product', 1),
(285, '561', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:32:04', '2022-03-03 14:32:04', NULL, 1, 'Create New Product', 1),
(286, '560', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:32:19', '2022-03-03 14:32:19', NULL, 1, 'Create New Product', 1),
(287, '568', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:32:29', '2022-03-03 14:32:29', NULL, 1, 'Create New Product', 1),
(288, '567', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:32:39', '2022-03-03 14:32:39', NULL, 1, 'Create New Product', 1),
(289, '566', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:32:49', '2022-03-03 14:32:49', NULL, 1, 'Create New Product', 1),
(290, '573', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:33:01', '2022-03-03 14:33:01', NULL, 1, 'Create New Product', 1),
(291, '572', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:33:18', '2022-03-03 14:33:18', NULL, 1, 'Create New Product', 1),
(292, '571', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:33:29', '2022-03-03 14:33:29', NULL, 1, 'Create New Product', 1),
(293, '570', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:33:40', '2022-03-03 14:33:40', NULL, 1, 'Create New Product', 1),
(294, '578', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:33:52', '2022-03-03 14:33:52', NULL, 1, 'Create New Product', 1),
(295, '577', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:34:04', '2022-03-03 14:34:04', NULL, 1, 'Create New Product', 1),
(296, '576', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:34:15', '2022-03-03 14:34:15', NULL, 1, 'Create New Product', 1),
(297, '575', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:34:26', '2022-03-03 14:34:26', NULL, 1, 'Create New Product', 1),
(298, '598', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:34:38', '2022-03-03 14:34:38', NULL, 1, 'Create New Product', 1),
(299, '597', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:34:50', '2022-03-03 14:34:50', NULL, 1, 'Create New Product', 1),
(300, '596', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:35:07', '2022-03-03 14:35:07', NULL, 1, 'Create New Product', 1),
(301, '595', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:35:20', '2022-03-03 14:35:20', NULL, 1, 'Create New Product', 1),
(302, '154', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:35:35', '2022-03-03 14:35:35', NULL, 1, 'Create New Product', 1),
(303, '157', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:35:47', '2022-03-03 14:35:47', NULL, 1, 'Create New Product', 1),
(304, '258', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:35:58', '2022-03-03 14:35:58', NULL, 1, 'Create New Product', 1),
(305, '259', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:36:08', '2022-03-03 14:36:08', NULL, 1, 'Create New Product', 1),
(306, '228', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:36:19', '2022-03-03 14:36:19', NULL, 1, 'Create New Product', 1),
(307, '230', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:36:27', '2022-03-03 14:36:27', NULL, 1, 'Create New Product', 1),
(308, '388', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:36:38', '2022-03-03 14:36:38', NULL, 1, 'Create New Product', 1),
(309, '387', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:36:48', '2022-03-03 14:36:48', NULL, 1, 'Create New Product', 1),
(310, '688', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:37:01', '2022-03-03 14:37:01', NULL, 1, 'Create New Product', 1),
(311, '687', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:37:54', '2022-03-03 14:37:54', NULL, 1, 'Create New Product', 1),
(312, '689', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:38:05', '2022-03-03 14:38:05', NULL, 1, 'Create New Product', 1),
(313, '581', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:38:17', '2022-03-03 14:38:17', NULL, 1, 'Create New Product', 1),
(314, '583', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:38:28', '2022-03-03 14:38:28', NULL, 1, 'Create New Product', 1),
(315, '674', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:38:38', '2022-03-03 14:38:38', NULL, 1, 'Create New Product', 1),
(316, '675', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:38:49', '2022-03-03 14:38:49', NULL, 1, 'Create New Product', 1),
(317, '663', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:39:00', '2022-03-03 14:39:00', NULL, 1, 'Create New Product', 1),
(318, '664', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:39:13', '2022-03-03 14:39:13', NULL, 1, 'Create New Product', 1),
(319, '665', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:39:23', '2022-03-03 14:39:23', NULL, 1, 'Create New Product', 1),
(320, '374', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:39:33', '2022-03-03 14:39:33', NULL, 1, 'Create New Product', 1),
(321, '507', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 11.00, NULL, '', NULL, 2, 0, 0, '2022-03-03 14:39:46', '2022-03-03 14:39:46', NULL, 1, 'Create New Product', 1),
(322, 'MESTAN+STORE', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 27.00, 17.00, NULL, '', NULL, 6, 0, 0, '2022-03-05 10:33:22', '2022-03-05 10:33:22', NULL, 1, 'Create New Product', 1),
(323, 'MESTAN+B.OUT', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 30.00, 19.00, NULL, '', NULL, 6, 0, 0, '2022-03-05 10:34:16', '2022-03-05 10:34:16', NULL, 1, 'Create New Product', 1),
(324, 'SEYMEN+STORE', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 27.00, 17.00, NULL, '', NULL, 6, 0, 0, '2022-03-05 10:41:43', '2022-03-05 10:44:07', NULL, 1, 'Update Product', 1),
(325, 'SEYMEN+B.OUT', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 30.00, 19.00, NULL, '', NULL, 6, 0, 0, '2022-03-05 10:43:25', '2022-03-05 10:43:25', NULL, 1, 'Create New Product', 1),
(326, 'KERAMI+STORE', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 27.00, 17.00, NULL, '', NULL, 6, 0, 0, '2022-03-05 10:44:46', '2022-03-05 10:44:46', NULL, 1, 'Create New Product', 1),
(327, 'KERAMI+B.OUT', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 30.00, 19.00, NULL, '', NULL, 6, 0, 0, '2022-03-05 10:45:23', '2022-03-05 10:45:23', NULL, 1, 'Create New Product', 1),
(328, 'BEKTAS+STORE', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 27.00, 17.00, NULL, '', NULL, 6, 0, 0, '2022-03-05 10:46:30', '2022-03-05 10:46:30', NULL, 1, 'Create New Product', 1),
(329, 'BEKTAS+B.OUT', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 30.00, 19.00, NULL, '', NULL, 6, 0, 0, '2022-03-05 10:46:58', '2022-03-05 10:46:58', NULL, 1, 'Create New Product', 1),
(330, 'FASIH+STORE', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 27.00, 17.00, NULL, '', NULL, 6, 0, 0, '2022-03-05 10:47:34', '2022-03-05 10:47:34', NULL, 1, 'Create New Product', 1),
(331, 'FASIH+B.OUT', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 30.00, 19.00, NULL, '', NULL, 6, 0, 0, '2022-03-05 10:48:06', '2022-03-05 10:48:06', NULL, 1, 'Create New Product', 1),
(332, 'ECVET+STORE', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 27.00, 17.00, NULL, '', NULL, 6, 0, 0, '2022-03-05 10:49:04', '2022-03-05 10:49:04', NULL, 1, 'Create New Product', 1),
(333, 'ECVET+B.OUT', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 30.00, 19.00, NULL, '', NULL, 6, 0, 0, '2022-03-05 10:49:34', '2022-03-05 10:49:34', NULL, 1, 'Create New Product', 1),
(334, 'YAVER+STORE', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 27.00, 17.00, NULL, '', NULL, 6, 0, 0, '2022-03-05 10:50:04', '2022-03-05 10:50:04', NULL, 1, 'Create New Product', 1),
(335, 'YAVER+B.OUT', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 30.00, 19.00, NULL, '', NULL, 6, 0, 0, '2022-03-05 10:50:55', '2022-03-05 10:50:55', NULL, 1, 'Create New Product', 1),
(336, 'BLACK OUT', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 7.00, NULL, '', NULL, 7, 0, 0, '2022-03-05 12:16:52', '2022-03-05 12:16:52', NULL, 1, 'Create New Product', 1);

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

--
-- Table structure for table `role`
--

CREATE TABLE `role` (
  `role_id` int(11) NOT NULL,
  `role` varchar(100) DEFAULT NULL,
  `role_desc` varchar(300) DEFAULT NULL,
  `is_deleted` int(1) DEFAULT 0,
  `id_fk` int(11) DEFAULT NULL,
  `table_name` varchar(100) DEFAULT NULL,
  `action` varchar(150) DEFAULT NULL COMMENT 'used it in case we want to add more than action on that table, e.g. when create store we add two roles one for displaying and the other for transfer.. so when need the action when updating the two roles when updating the stock so this column will make us can select the specified record and update it individually ',
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `last_action` varchar(100) DEFAULT NULL,
  `last_action_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `role`
--

INSERT INTO `role` (`role_id`, `role`, `role_desc`, `is_deleted`, `id_fk`, `table_name`, `action`, `created_at`, `updated_at`, `deleted_at`, `created_by`, `last_action`, `last_action_by`) VALUES
(1, 'Full Access', 'Every Things is Allowed', 0, 0, '', '', '2017-09-28 23:14:17', '2018-02-20 20:52:15', NULL, 1, 'created', 1),
(2, 'Access Show Room', '', 0, 0, '', '', '2017-09-28 23:16:03', '2018-10-26 00:36:31', NULL, 1, 'created', 1),
(4, 'Access Category', '', 0, 0, '', '', '2017-09-28 23:16:03', '2018-02-20 16:05:29', NULL, 1, 'Created Role', 1),
(5, 'Access Products', '', 0, 0, '', '', '2017-09-28 23:16:03', '2018-10-26 00:42:03', NULL, 1, 'Created Role', 1),
(22, 'Access Staff', '', 0, 0, '', '', '2017-09-28 23:16:03', '2018-10-26 01:05:33', NULL, 1, 'Created Role', 1),
(23, 'Access System Setting', '', 0, 0, '', '', '2017-09-28 23:16:03', '2018-10-26 01:07:02', NULL, 1, 'Created Role', 1),
(27, 'Access Language', '', 0, 0, '', '', '2018-02-21 11:48:16', '2018-10-26 01:18:31', NULL, 1, 'Create New Role', 1),
(28, 'Access Translation', '', 0, 0, '', '', '2018-02-21 11:48:16', '2018-10-26 01:21:06', NULL, 1, 'Create New Role', 1);

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

--
-- Table structure for table `staff_role`
--

CREATE TABLE `staff_role` (
  `staff_role_id` int(11) NOT NULL,
  `staff_id_fk` int(11) DEFAULT NULL,
  `role_id_fk` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `is_deleted` int(1) DEFAULT 0 COMMENT '0: active, 1:deleted',
  `created_by` int(11) DEFAULT NULL,
  `last_action` varchar(100) DEFAULT NULL,
  `last_action_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `staff_role`
--

INSERT INTO `staff_role` (`staff_role_id`, `staff_id_fk`, `role_id_fk`, `created_at`, `updated_at`, `deleted_at`, `is_deleted`, `created_by`, `last_action`, `last_action_by`) VALUES
(1, 1, 1, '2022-03-02 17:14:42', '2022-03-02 17:14:42', NULL, 0, 1, 'Update User Roles', 1),
(2, 1, 2, '2022-03-02 17:14:42', '2022-03-02 17:14:42', NULL, 0, 1, 'Update User Roles', 1),
(3, 1, 4, '2022-03-02 17:14:42', '2022-03-02 17:14:42', NULL, 0, 1, 'Update User Roles', 1),
(4, 1, 5, '2022-03-02 17:14:42', '2022-03-02 17:14:42', NULL, 0, 1, 'Update User Roles', 1),
(5, 1, 22, '2022-03-02 17:14:42', '2022-03-02 17:14:42', NULL, 0, 1, 'Update User Roles', 1),
(6, 1, 23, '2022-03-02 17:14:42', '2022-03-02 17:14:42', NULL, 0, 1, 'Update User Roles', 1),
(7, 1, 27, '2022-03-02 17:14:42', '2022-03-02 17:14:42', NULL, 0, 1, 'Update User Roles', 1),
(8, 1, 28, '2022-03-02 17:14:42', '2022-03-02 17:14:42', NULL, 0, 1, 'Update User Roles', 1);

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

--
-- Table structure for table `staff_sub_role`
--

CREATE TABLE `staff_sub_role` (
  `staff_sub_role_id` int(11) NOT NULL,
  `staff_id_fk` int(11) DEFAULT NULL,
  `role_id_fk` int(11) DEFAULT NULL,
  `sub_role_id_fk` varchar(300) DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `is_deleted` int(1) DEFAULT 0 COMMENT '0: active, 1:deleted',
  `created_by` int(11) DEFAULT NULL,
  `last_action` varchar(100) DEFAULT NULL,
  `last_action_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `staff_sub_role`
--

INSERT INTO `staff_sub_role` (`staff_sub_role_id`, `staff_id_fk`, `role_id_fk`, `sub_role_id_fk`, `created_at`, `updated_at`, `deleted_at`, `is_deleted`, `created_by`, `last_action`, `last_action_by`) VALUES
(1, 1, 3, '1', '2020-06-29 21:54:42', '2020-06-29 21:54:42', NULL, 0, 1, 'Update User Sub Roles', 1),
(2, 1, 3, '2', '2020-06-29 21:54:42', '2020-06-29 21:54:42', NULL, 0, 1, 'Update User Sub Roles', 1),
(3, 1, 3, '3', '2020-06-29 21:54:42', '2020-06-29 21:54:42', NULL, 0, 1, 'Update User Sub Roles', 1),
(4, 1, 3, '4', '2020-06-29 21:54:42', '2020-06-29 21:54:42', NULL, 0, 1, 'Update User Sub Roles', 1),
(5, 1, 3, '5', '2020-06-29 21:54:42', '2020-06-29 21:54:42', NULL, 0, 1, 'Update User Sub Roles', 1),
(6, 1, 3, '6', '2020-06-29 21:54:42', '2020-06-29 21:54:42', NULL, 0, 1, 'Update User Sub Roles', 1),
(7, 1, 3, '7', '2020-06-29 21:54:42', '2020-06-29 21:54:42', NULL, 0, 1, 'Update User Sub Roles', 1),
(8, 1, 3, '8', '2020-06-29 21:54:42', '2020-06-29 21:54:42', NULL, 0, 1, 'Update User Sub Roles', 1),
(9, 1, 3, '9', '2020-06-29 21:54:42', '2020-06-29 21:54:42', NULL, 0, 1, 'Update User Sub Roles', 1),
(10, 1, 3, '10', '2020-06-29 21:54:42', '2020-06-29 21:54:42', NULL, 0, 1, 'Update User Sub Roles', 1),
(11, 1, 3, '11', '2020-06-29 21:54:42', '2020-06-29 21:54:42', NULL, 0, 1, 'Update User Sub Roles', 1),
(12, 1, 3, '12', '2020-06-29 21:54:42', '2020-06-29 21:54:42', NULL, 0, 1, 'Update User Sub Roles', 1),
(13, 1, 3, '13', '2020-06-29 21:54:42', '2020-06-29 21:54:42', NULL, 0, 1, 'Update User Sub Roles', 1),
(14, 1, 3, '14', '2020-06-29 21:54:42', '2020-06-29 21:54:42', NULL, 0, 1, 'Update User Sub Roles', 1),
(15, 1, 3, '15', '2020-06-29 21:54:42', '2020-06-29 21:54:42', NULL, 0, 1, 'Update User Sub Roles', 1),
(16, 8, 3, '1', '2020-06-29 21:55:56', '2020-07-06 07:58:25', '2020-07-06 02:58:25', 1, 1, 'Update User Sub Roles', 1),
(17, 9, 3, '1', '2020-06-29 21:56:07', '2020-06-29 21:56:07', NULL, 0, 1, 'Update User Sub Roles', 1),
(18, 10, 3, '1', '2020-06-29 21:56:17', '2020-06-29 17:39:56', '2020-06-30 12:39:56', 1, 1, 'Update User Sub Roles', 1),
(19, 8, 3, '1', '2020-06-29 17:39:47', '2020-07-06 07:58:25', '2020-07-06 02:58:25', 1, 1, 'Update User Sub Roles', 1),
(20, 10, 3, '1', '2020-06-29 17:39:56', '2020-06-29 17:39:56', NULL, 0, 1, 'Update User Sub Roles', 1),
(21, 8, 3, '1', '2020-07-06 07:58:25', '2020-07-06 07:58:25', NULL, 0, 1, 'Update User Sub Roles', 1),
(22, 6, 3, '7', '2020-07-14 10:26:34', '2020-07-14 10:26:34', NULL, 0, 1, 'Update User Sub Roles', 1),
(23, 7, 3, '7', '2020-07-14 10:32:50', '2020-07-14 10:32:50', NULL, 0, 1, 'Update User Sub Roles', 1),
(24, 13, 3, '1', '2021-08-18 13:57:56', '2021-08-18 13:57:56', NULL, 0, 1, 'Update User Sub Roles', 1);

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

--
-- Table structure for table `system_settings`
--

CREATE TABLE `system_settings` (
  `SYSID` int(11) NOT NULL,
  `SYSName` varchar(200) DEFAULT NULL,
  `SYSCompanyManager_en` varchar(40) DEFAULT NULL,
  `SYSCompanyManager_ku` varchar(40) DEFAULT NULL,
  `SYSCompanyManager_ar` varchar(100) DEFAULT NULL,
  `SYSCompanyLogo` varchar(200) DEFAULT NULL,
  `SYSCompanyName` varchar(200) DEFAULT NULL,
  `SYSCompanyAddress` varchar(200) DEFAULT NULL,
  `SYSCompanyPhone` varchar(50) DEFAULT NULL,
  `SYSCompanyEmail` varchar(300) DEFAULT NULL,
  `notify_email` varchar(600) DEFAULT NULL,
  `SYSTimezone` varchar(60) DEFAULT NULL,
  `SYSUSDRATE` decimal(10,2) DEFAULT NULL,
  `SYSSetupDate` datetime DEFAULT NULL,
  `SYSVersion` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `system_settings`
--

INSERT INTO `system_settings` (`SYSID`, `SYSName`, `SYSCompanyManager_en`, `SYSCompanyManager_ku`, `SYSCompanyManager_ar`, `SYSCompanyLogo`, `SYSCompanyName`, `SYSCompanyAddress`, `SYSCompanyPhone`, `SYSCompanyEmail`, `notify_email`, `SYSTimezone`, `SYSUSDRATE`, `SYSSetupDate`, `SYSVersion`) VALUES
(1, 'Accountant', 'Dana Dorghamchi', 'دانا دورغمجي', 'دانا درغمجي', 'image/sys/3391-l6.png', 'Professional Dent ', 'Erbil-brayati - 20 meter street opposite to pharma medical complex', ' 0750 661 3700 - 0750 661 8700', 'info@profdent-co.com', 'aia_aia1984@yahoo.com, ahmed@keentech.co', 'Asia/Baghdad', 1250.00, '2018-03-10 00:00:00', '1.0');

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

--
-- Table structure for table `years`
--

CREATE TABLE `years` (
  `year_id` int(11) NOT NULL,
  `year_no` varchar(30) DEFAULT NULL,
  `is_deleted` int(1) DEFAULT 0 COMMENT '0:active; 1:de-active; 2:deleted',
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp(),
  `deleted_at` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `last_action` varchar(100) DEFAULT NULL,
  `last_action_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `years`
--

INSERT INTO `years` (`year_id`, `year_no`, `is_deleted`, `created_at`, `updated_at`, `deleted_at`, `created_by`, `last_action`, `last_action_by`) VALUES
(1, '2015', 0, '2018-04-03 15:16:20', '2018-04-03 15:16:20', NULL, 1, 'Create New Year', 1),
(2, '2016', 0, '2018-04-03 15:16:20', '2018-04-03 15:16:20', NULL, 1, 'Create New Year', 1),
(3, '2017', 0, '2018-04-03 15:16:20', '2018-04-03 15:16:20', NULL, 1, 'Create New Year', 1),
(4, '2018', 0, '2018-04-03 15:16:20', '2018-04-03 15:16:20', NULL, 1, 'Create New Year', 1),
(5, '2019', 0, '2018-04-03 15:16:20', '2018-04-03 15:16:20', NULL, 1, 'Create New Year', 1),
(6, '2020', 0, '2018-04-03 15:16:20', '2018-04-03 15:16:20', NULL, 1, 'Create New Year', 1),
(7, '2021', 0, '2018-04-03 15:16:20', '2018-04-03 15:16:20', NULL, 1, 'Create New Year', 1),
(8, '2022', 0, '2018-04-03 15:16:20', '2018-04-03 15:16:20', NULL, 1, 'Create New Year', 1),
(9, '2023', 0, '2018-04-03 15:16:20', '2018-04-03 15:16:20', NULL, 1, 'Create New Year', 1),
(10, '2024', 0, '2018-04-03 15:16:20', '2018-04-03 15:16:20', NULL, 1, 'Create New Year', 1),
(11, '2025', 0, '2018-04-03 15:16:20', '2018-04-03 15:16:20', NULL, 1, 'Create New Year', 1),
(12, '2026', 0, '2018-04-03 15:16:20', '2018-04-03 15:16:20', NULL, 1, 'Create New Year', 1),
(13, '2027', 0, '2018-04-03 15:16:20', '2018-04-03 15:16:20', NULL, 1, 'Create New Year', 1),
(14, '2028', 0, '2018-04-03 15:16:20', '2018-04-03 15:16:20', NULL, 1, 'Create New Year', 1),
(15, '2029', 0, '2018-04-03 15:16:20', '2018-04-03 15:16:20', NULL, 1, 'Create New Year', 1),
(16, '2030', 0, '2018-04-03 15:16:20', '2018-04-03 15:16:20', NULL, 1, 'Create New Year', 1);

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `keywords`
--
ALTER TABLE `keywords`
  ADD PRIMARY KEY (`keyword_id`);

--
-- Indexes for table `languages`
--
ALTER TABLE `languages`
  ADD PRIMARY KEY (`language_id`);

--
-- Indexes for table `languages_keywords`
--
ALTER TABLE `languages_keywords`
  ADD PRIMARY KEY (`language_keyword_id`);

--
-- Indexes for table `product`
--
ALTER TABLE `product`
  ADD PRIMARY KEY (`product_id`);

--
-- Indexes for table `role`
--
ALTER TABLE `role`
  ADD PRIMARY KEY (`role_id`);

--
-- Indexes for table `staff_role`
--
ALTER TABLE `staff_role`
  ADD PRIMARY KEY (`staff_role_id`);

--
-- Indexes for table `staff_sub_role`
--
ALTER TABLE `staff_sub_role`
  ADD PRIMARY KEY (`staff_sub_role_id`);

--
-- Indexes for table `system_settings`
--
ALTER TABLE `system_settings`
  ADD PRIMARY KEY (`SYSID`);

--
-- Indexes for table `years`
--
ALTER TABLE `years`
  ADD PRIMARY KEY (`year_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

--
-- AUTO_INCREMENT for table `keywords`
--
ALTER TABLE `keywords`
  MODIFY `keyword_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=568;

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

--
-- AUTO_INCREMENT for table `languages_keywords`
--
ALTER TABLE `languages_keywords`
  MODIFY `language_keyword_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=376;

--
-- AUTO_INCREMENT for table `product`
--
ALTER TABLE `product`
  MODIFY `product_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=337;

--
-- AUTO_INCREMENT for table `role`
--
ALTER TABLE `role`
  MODIFY `role_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45;

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

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

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

--
-- AUTO_INCREMENT for table `years`
--
ALTER TABLE `years`
  MODIFY `year_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
COMMIT;

