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

START TRANSACTION;



--
-- Database: `erp`
--

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

--
-- Table structure for table `accounts`
--

CREATE TABLE `accounts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `parent_id` bigint(20) UNSIGNED DEFAULT NULL,
  `list_account_id` bigint(20) UNSIGNED DEFAULT NULL,
  `debit_opening_balance` double DEFAULT NULL,
  `credit_opening_balance` double DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `level` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `credit` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `debit` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 0,
  `vendor_id` bigint(20) UNSIGNED DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `accounts`
--

INSERT INTO `accounts` (`id`, `code`, `name`, `parent_id`, `list_account_id`, `debit_opening_balance`, `credit_opening_balance`, `created_at`, `updated_at`, `level`, `note`, `credit`, `debit`, `active`, `vendor_id`, `type`) VALUES
(1, '1', 'أصول', NULL, 1, NULL, NULL, '2022-12-19 05:47:31', '2022-12-19 05:47:31', '1', NULL, NULL, NULL, 0, NULL, NULL),
(2, '2', 'إلتزامات', NULL, 1, NULL, NULL, '2022-12-19 05:47:31', '2022-12-19 05:47:31', '1', NULL, NULL, NULL, 0, NULL, NULL),
(3, '3', 'حقوق الملكية', NULL, 1, NULL, NULL, '2022-12-19 05:47:31', '2022-12-19 05:47:31', '1', NULL, NULL, NULL, 0, NULL, NULL),
(4, '4', 'الإيرادات', NULL, 2, NULL, NULL, '2022-12-19 05:47:31', '2022-12-19 05:47:31', '1', NULL, NULL, NULL, 0, NULL, NULL),
(5, '5', 'المصروفات', NULL, 2, NULL, NULL, '2022-12-19 05:47:31', '2022-12-19 05:47:31', '1', NULL, NULL, NULL, 0, NULL, NULL),
(6, '11', 'اصول غير متداولة', 1, 1, NULL, NULL, '2022-12-19 05:47:42', '2022-12-19 05:47:42', '2', NULL, NULL, NULL, 0, NULL, NULL),
(7, '12', 'أصول متداولة', 1, 1, NULL, NULL, '2022-12-19 05:47:42', '2022-12-19 05:47:42', '2', NULL, NULL, NULL, 0, NULL, NULL),
(8, '21', 'إلتزامات غير متداولة', 2, 1, NULL, NULL, '2022-12-19 05:47:42', '2022-12-19 05:47:42', '2', NULL, NULL, NULL, 0, NULL, NULL),
(9, '22', 'إلتزامات متداولة', 2, 1, NULL, NULL, '2022-12-19 05:47:42', '2022-12-19 05:47:42', '2', NULL, NULL, NULL, 0, NULL, NULL),
(10, '41', 'حساب إيرادات النشاط', 4, 2, NULL, NULL, '2022-12-19 05:47:42', '2022-12-19 05:47:42', '2', NULL, NULL, NULL, 0, NULL, NULL),
(11, '42', 'إيرادات أخري', 4, 2, NULL, NULL, '2022-12-19 05:47:42', '2022-12-19 05:47:42', '2', NULL, NULL, NULL, 0, NULL, NULL),
(12, '51', 'حساب تكاليف النشاط', 5, 2, NULL, NULL, '2022-12-19 05:47:42', '2022-12-19 05:47:42', '2', NULL, NULL, NULL, 0, NULL, NULL),
(13, '52', 'حسابات المصروفات الإدارية والعمومية', 5, 2, NULL, NULL, '2022-12-19 05:47:42', '2022-12-19 05:47:42', '2', NULL, NULL, NULL, 0, NULL, NULL),
(14, '53', 'حسابات المصروفات الإدارية والعمومية 1', 5, 2, NULL, NULL, '2022-12-19 05:47:42', '2022-12-19 05:47:42', '2', NULL, NULL, NULL, 0, NULL, NULL),
(15, '54', 'مصروفات نشاط', 5, 2, NULL, NULL, '2022-12-19 05:47:42', '2022-12-19 05:47:42', '2', NULL, NULL, NULL, 0, NULL, NULL),
(16, '31', 'حسابات رأس المال', 3, 1, NULL, NULL, '2022-12-19 05:47:42', '2022-12-19 05:47:42', '2', NULL, NULL, NULL, 0, NULL, NULL),
(17, '32', 'تمويلات وجاري المساهمين', 3, 1, NULL, NULL, '2022-12-19 05:47:42', '2022-12-19 05:47:42', '2', NULL, NULL, NULL, 0, NULL, NULL),
(18, '33', 'الأرباح/الخسائر', 3, 1, NULL, NULL, '2022-12-19 05:47:42', '2022-12-19 05:47:42', '2', NULL, NULL, NULL, 0, NULL, NULL),
(19, '1101', 'الأصول الثابتة', 6, 1, NULL, NULL, '2022-12-19 05:47:54', '2022-12-19 05:47:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(20, '1102', 'أصول غير ملموسة', 6, 1, NULL, NULL, '2022-12-19 05:47:54', '2022-12-19 05:47:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(21, '1103', 'مشروعات تحت التنفيذ - مقاولات', 6, 1, NULL, NULL, '2022-12-19 05:47:54', '2022-12-19 05:47:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(22, '1104', 'الأصول الثابتة - مجمع الاهلاكات', 6, 1, NULL, NULL, '2022-12-19 05:47:54', '2022-12-19 05:47:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(23, '1201', 'مخازن', 7, 1, NULL, NULL, '2022-12-19 05:47:54', '2022-12-19 05:47:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(24, '1202', 'العملاء', 7, 1, NULL, NULL, '2022-12-19 05:47:54', '2022-12-19 05:47:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(25, '1203', 'أوراق القبض', 7, 1, NULL, NULL, '2022-12-19 05:47:54', '2022-12-19 05:47:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(26, '1204', 'مدينة أخرى', 7, 1, NULL, NULL, '2022-12-19 05:47:54', '2022-12-19 05:47:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(27, '1205', 'النقدية في الخزينة والبنوك', 7, 1, NULL, NULL, '2022-12-19 05:47:54', '2022-12-19 05:47:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(28, '2101', 'إلتزامات الضريبية المؤجلة', 8, 1, NULL, NULL, '2022-12-19 05:47:54', '2022-12-19 05:47:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(29, '2201', 'الموردين', 9, 1, NULL, NULL, '2022-12-19 05:47:54', '2022-12-19 05:47:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(30, '2202', 'أوراق الدفع والأوراق التجارية', 9, 1, NULL, NULL, '2022-12-19 05:47:54', '2022-12-19 05:47:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(31, '2203', 'ارصدة دائنة', 9, 1, NULL, NULL, '2022-12-19 05:47:54', '2022-12-19 05:47:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(32, '4101', 'إيرادات النشاط', 10, 2, NULL, NULL, '2022-12-19 05:47:54', '2022-12-19 05:47:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(33, '4201', 'ايرادات اخرى', 11, 2, NULL, NULL, '2022-12-19 05:47:54', '2022-12-19 05:47:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(34, '5101', 'مصروفات تشغيل - خامات', 12, 2, NULL, NULL, '2022-12-19 05:47:54', '2022-12-19 05:47:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(35, '5102', 'مصروفات تشغيل - قطع غيار', 12, 2, NULL, NULL, '2022-12-19 05:47:54', '2022-12-19 05:47:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(36, '5103', 'مصروفات تشغيل - عمولات', 12, 2, NULL, NULL, '2022-12-19 05:47:54', '2022-12-19 05:47:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(37, '5201', 'المصروفات الإدارية والعمومية', 13, 2, NULL, NULL, '2022-12-19 05:47:54', '2022-12-19 05:47:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(38, '5202', 'مصروفات المساهمة التكافلية', 13, 2, NULL, NULL, '2022-12-19 05:47:54', '2022-12-19 05:47:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(39, '5301', 'المصروفات الإدارية والعمومية', 14, 2, NULL, NULL, '2022-12-19 05:47:54', '2022-12-19 05:47:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(40, '5401', 'المصروفات الإدارية والعمومية', 15, 2, NULL, NULL, '2022-12-19 05:47:54', '2022-12-19 05:47:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(41, '3101', 'حساب رأس المال المدفوع', 16, 1, NULL, NULL, '2022-12-19 05:47:54', '2022-12-19 05:47:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(42, '3102', 'المبالغ الغير مؤداة من رأس المال', 16, 1, NULL, NULL, '2022-12-19 05:47:54', '2022-12-19 05:47:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(43, '3103', 'رأس المال المصدر', 16, 1, NULL, NULL, '2022-12-19 05:47:54', '2022-12-19 05:47:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(44, '3201', 'جاري المساهمين', 17, 1, NULL, NULL, '2022-12-19 05:47:54', '2022-12-19 05:47:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(45, '3202', 'جاري شركات شقيقة', 17, 1, NULL, NULL, '2022-12-19 05:47:54', '2022-12-19 05:47:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(46, '3301', 'أرباح / خسائر مرحلة', 18, 1, NULL, NULL, '2022-12-19 05:47:54', '2022-12-19 05:47:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(47, '110101', 'الاراضى', 19, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(48, '110102', 'المبانى', 19, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(49, '110103', 'الآلات والمعدات', 19, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(50, '110104', 'الأثاث والتجهيزات', 19, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(51, '110105', 'التجهيزات والديكورات', 19, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(52, '110106', 'سيارات ووسائل نقل 1', 19, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(53, '110107', 'سيارات ووسائل نقل 2', 19, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(54, '110108', 'سيارات ووسائل نقل 3', 19, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(55, '110109', 'سيارات ووسائل نقل 4', 19, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(56, '110110', 'سيارات ووسائل نقل 5', 19, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(57, '110111', 'سيارات ووسائل نقل 6', 19, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(58, '110112', 'سيارات ووسائل نقل 7', 19, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(59, '110113', 'سياره رينو Stepway Sw', 19, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(60, '110114', 'أجهزة كمبيوترات', 19, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(61, '110115', 'أجهزة وأدوات', 19, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(62, '110116', 'العدد والادوات', 19, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(63, '110201', 'شهرة الشركة', 20, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(64, '110202', 'العلامات التجارية', 20, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(65, '110301', 'مشروعات تحت التنفيذ - العاصمة الإدارية', 21, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(66, '110401', 'مجمع اهلاك - مباني', 22, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(67, '110402', 'مجمع اهلاك - الآلات والمعدات\n', 22, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(68, '110403', 'مجمع اهلاك - الأثاث والتجهيزات', 22, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(69, '110404', 'مجمع اهلاك - التجهيزات والديكورات', 22, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(70, '110405', 'مجمع اهلاك - سيارات 1', 22, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(71, '110406', 'مجمع اهلاك - سيارات 2', 22, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(72, '110407', 'مجمع اهلاك - سيارات 3', 22, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(73, '110408', 'مجمع اهلاك - سيارات 4', 22, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(74, '110409', 'مجمع اهلاك - سيارات 5', 22, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(75, '110410', 'مجمع اهلاك - مينى باص مكيف', 22, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(76, '110411', 'مجمع اهلاك - سيارات 7', 22, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(77, '110412', 'مجمع اهلاك - سيارات رينو stepway sw', 22, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(78, '110413', 'مجمع اهلاك - أجهزة كمبيوترات وبرمجيات', 22, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(79, '110414', 'مجمع اهلاك - أجهزة وأدوات', 22, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(80, '110415', 'مجمع اهلاك - العدد والادوات', 22, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(81, '120101', 'المخزن الرئيسي', 23, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(82, '120201', 'عملاء العاصمة - شركة رامى فارس', 24, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(83, '120202', 'عملاء العاصمة - سند - احمد على', 24, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(84, '120203', 'عملاء العاصمة - سند - امير', 24, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(85, '120204', 'عملاء العاصمة - بورسعيد', 24, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(86, '120205', 'عملاء العاصمة - تبارك', 24, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(87, '120206', 'عملاء العاصمة - سند - عبدالعزيز', 24, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(88, '120207', 'عملاء العاصمة - الكابتن للاستثمار', 24, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(89, '120208', 'عملاء العاصمة - البركة', 24, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(90, '120209', 'عملاء العاصمة - العميد ياسر', 24, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(91, '120210', 'عملاء العاصمة - ايدج', 24, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(92, '120211', 'عملاء العاصمة - سند - محمود اسماعيل', 24, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(93, '120212', 'عملاء العاصمة - ', 24, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(94, '120213', 'عملاء العاصمة - سند - احمد فهمى', 24, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(95, '120301', 'أوراق القبض', 25, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(96, '120401', 'أوراق القبض - مرتدة', 26, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(97, '120402', 'العهد', 26, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(98, '120403', 'السلف', 26, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(99, '120404', 'حسابات المصروفات المدفوعة مقدما', 26, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(100, '120405', 'الحسابات المدينة تحت التسوية', 26, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(101, '120406', 'ضرائب الخصم من المنبع', 26, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(102, '120407', 'حسابات التأمينات لدى الغير', 26, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(103, '120408', 'مراقبة الحسابات المدينة', 26, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(104, '120409', 'مراقبة الحسابات المدينة', 26, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(105, '120410', 'ضريبة القيمة المضافة 14% - مدين', 26, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(106, '120501', 'نقديه بالخزينة جنية مصري - العاصمة', 27, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(107, '120502', 'نقديه بالخزينة جنية مصري - 2', 27, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(108, '120503', 'حساب بنك SAIB ار اف 3027155- جنيه', 27, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(109, '120504', 'حساب بنك 2 ار اف - جنيه', 27, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(110, '210101', 'إلتزامات الضريبية المؤجلة', 28, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(111, '220101', 'موردون خامات', 29, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(112, '220102', 'موردون قطع غيار', 29, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(113, '220103', 'موردون خدمات', 29, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(114, '220104', 'أجهزة كمبيوترات وبرمجيات', 29, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(115, '220201', 'حسابات أوراق الدفع', 30, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(116, '220301', 'ضرائب القيمة المضافة 14 % - دائن', 31, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(117, '220302', 'ضريبة كسب العمل', 31, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(118, '220303', 'ضرائب خصم وإضافة', 31, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(119, '220304', 'الهيئة القومية للتأمينات الاجتماعية', 31, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(120, '220305', 'تأمينات للغير', 31, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(121, '220306', 'المصروفات المستحقة - اجور', 31, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(122, '220307', 'ضريبة الدمغة', 31, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(123, '220308', 'صندوق الجزاءات', 31, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(124, '220309', 'شركة التأمين الطبي', 31, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(125, '220310', 'ضريبة المساهمة التكافلية - الكوارث الطبيعية', 31, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(126, '220311', 'ضرائب الخصم والاضافة - 1%', 31, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(127, '220312', 'ضرائب الخصم والاضافة - 3%', 31, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(128, '220313', 'ضرائب الخصم والاضافة - 5%', 31, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(129, '220314', 'ضرائب الخصم والاضافة - 20%', 31, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(130, '220315', 'حسابات الدائنون المتنوعون', 31, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(131, '410101', 'إيراد بيع خرسانة جاهزة', 32, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(132, '410102', 'إيراد بيع خرسانة جاهزة - 2 ', 32, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(133, '420101', 'ايرادات اخرى - فوائد بنكية', 33, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(134, '420102', 'ايرادات اخرى - بيع خامات', 33, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(135, '510101', 'مصروفات تشغيل - اسمنت', 34, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(136, '510102', 'مصروفات تشغيل - سن 1', 34, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(137, '510103', 'مصروفات تشغيل - سن 2', 34, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(138, '510104', 'مصروفات تشغيل - رمل', 34, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(139, '510105', 'مصروفات تشغيل - مادة', 34, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(140, '510106', 'مصروفات تشغيل - مياة', 34, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(141, '510107', 'مصروفات تشغيل - سولار', 34, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(142, '510108', 'م. ميزان', 34, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(143, '510201', 'مصروفات تشغيل - قطع غيار', 35, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(144, '510202', 'مصروفات تشغيل - خامات', 35, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(145, '510203', 'مصروفات تشغيل - اهلاك سيارات ومعدات', 35, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(146, '510204', 'مصروفات تشغيل - غسيل سيارات', 35, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(147, '510205', 'مصروفات تشغيل  - صيانة', 35, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(148, '510206', 'مصروفات تشغيل - زيوت', 35, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(149, '510207', 'مصروفات تشغيل 2', 35, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(150, '510208', 'مصروفات تشغيل 2', 35, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(151, '510209', 'مصروفات تشغيل 2', 35, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(152, '510210', 'مصروفات تشغيل 2', 35, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(153, '510301', 'عمولات بيع', 36, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(154, '510302', 'عمولات بيع', 36, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(155, '510303', 'الإكراميات والهدايا', 36, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(156, '510304', 'ايجار سيارات ومعدات', 36, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(157, '520101', 'الأجور والمرتبات', 37, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(158, '520102', 'مصروفات أخرى للعاملين', 37, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(159, '520103', 'مصروفات الكهرباء', 37, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(160, '520104', 'مصروفات التليفونات والأنترنت', 37, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(161, '520105', 'مصروفات المياه', 37, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(162, '520106', 'مصروفات الغاز', 37, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(163, '520107', 'مصروفات صيانة وإصلاح', 37, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(164, '520108', 'مصروفات مستلزمات كمبيوتر', 37, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(165, '520109', 'مصروفات سلامة وصحة مهنية', 37, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(166, '520110', 'مصروفات سباكة', 37, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(167, '520111', 'مصروفات ادوات كهربائية', 37, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(168, '520112', 'مصروفات النقل والإنتقالات', 37, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(169, '520113', 'مصروفات الإيجارات', 37, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(170, '520114', 'المصروفات البنكية', 37, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(171, '520115', 'مصروفات أتعاب مهنية', 37, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(172, '520116', 'مصروفات أدوات كتابية ومطبوعات', 37, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(173, '520117', 'مصروفات شحن وبريد', 37, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(174, '520118', 'مصروفات تسويق ودعاية', 37, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(175, '520119', 'مصروفات التأمينات الاجتماعية', 37, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(176, '520120', 'مصروفات التأمين الطبى', 37, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(177, '520121', 'مصروفات البوفيه والضيافة', 37, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(178, '520122', 'مصروفات النظافة', 37, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(179, '520123', 'مصروفات طعام', 37, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(180, '520124', 'مصروفات اتصالات', 37, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(181, '520125', '3', 37, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(182, '520126', '4', 37, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(183, '520127', '5', 37, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(184, '520128', 'رسوم واشتراكات', 37, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(185, '520129', 'مصروفات سيارات', 37, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(186, '520130', 'ديون معدومة', 37, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(187, '520131', 'تعويضات للغير وغرامات', 37, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(188, '520132', 'مصروفات ايجار عدد والات', 37, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(189, '520133', 'مصنعيات - حدادة', 37, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(190, '520134', 'حسابات تكاليف النشاط', 37, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(191, '520201', 'مصروفات المساهمة التكافلية', 38, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(192, '530101', 'مصروفات  - اهلاك عام', 37, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(193, '540101', 'حسابات تكاليف النشاط', 37, 2, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(194, '310101', 'حساب رأس المال المدفوع', 41, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(195, '310201', 'المبالغ الغير مؤداة من حسابات رأس المال', 42, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(196, '310301', 'رأس المال المصدر', 43, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(197, '320101', 'جاري المساهمين', 44, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(198, '320102', 'جاري المساهمين', 44, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(199, '320201', 'جاري شركات شقيقه - رامى فارس', 45, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(200, '330101', 'خسائر سنوات سابقة ', 46, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(201, '330102', 'أرباح العام الحالي', 46, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL),
(202, '330103', 'خسائر العام الحالي', 46, 1, NULL, NULL, '2022-12-25 13:40:54', '2022-12-25 13:40:54', '3', NULL, NULL, NULL, 0, NULL, NULL);

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

--
-- Table structure for table `account_financials`
--

CREATE TABLE `account_financials` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `account_id` bigint(20) UNSIGNED DEFAULT NULL,
  `financial_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `account_invoices`
--

CREATE TABLE `account_invoices` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `vendor_id` bigint(20) UNSIGNED DEFAULT NULL,
  `customer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `cost_center_id` bigint(20) UNSIGNED DEFAULT NULL,
  `payment_type` enum('cache','installments') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `request_type` tinyint(4) DEFAULT NULL,
  `invoice_type` tinyint(4) DEFAULT NULL,
  `general_exchange_id` bigint(20) UNSIGNED DEFAULT NULL,
  `internal_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `amount_befor` double DEFAULT NULL,
  `amount_tax` double DEFAULT NULL,
  `amount_vat` double DEFAULT NULL,
  `amount_discount` double DEFAULT NULL,
  `amount_after` double DEFAULT NULL,
  `check_total` double NOT NULL DEFAULT 0,
  `origin` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `referance` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `referance_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('open','confirmed','draft','canceld','paied') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'draft',
  `supplier_invoice_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` enum('client_invoice','supplier_invoice','client_reffiend','supplier_reffiend') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `number` double DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `account_invoices`
--

INSERT INTO `account_invoices` (`id`, `user_id`, `vendor_id`, `customer_id`, `cost_center_id`, `payment_type`, `request_type`, `invoice_type`, `general_exchange_id`, `internal_number`, `date`, `amount_befor`, `amount_tax`, `amount_vat`, `amount_discount`, `amount_after`, `check_total`, `origin`, `referance`, `referance_type`, `status`, `supplier_invoice_number`, `type`, `name`, `number`, `created_at`, `updated_at`) VALUES
(2, NULL, 1, NULL, 2, 'cache', 1, NULL, NULL, NULL, NULL, 456, 205.2, 205.2, NULL, 456.00000000000006, 0, NULL, NULL, NULL, 'confirmed', NULL, NULL, NULL, NULL, '2023-01-01 08:00:07', '2023-01-01 08:00:10'),
(3, 1, 1, NULL, NULL, NULL, NULL, NULL, 4, NULL, '2023-01-01', 500000, 50000, 70000, NULL, 620000, 0, NULL, NULL, NULL, 'confirmed', '123', 'supplier_invoice', NULL, NULL, '2023-01-01 08:02:11', '2023-01-01 08:02:42'),
(4, 1, NULL, 1, NULL, NULL, 2, NULL, NULL, NULL, '2023-01-01', 500, 50, 70, 50, 570, 0, NULL, NULL, NULL, 'confirmed', NULL, 'client_invoice', NULL, NULL, '2023-01-01 08:05:05', '2023-01-01 11:02:03'),
(5, 1, 1, NULL, NULL, NULL, NULL, NULL, 5, NULL, '2023-01-01', 150000, 15000, 21000, NULL, 186000, 0, NULL, NULL, NULL, 'confirmed', '789', 'supplier_invoice', NULL, NULL, '2023-01-01 12:18:47', '2023-01-01 12:19:16'),
(6, 1, 1, NULL, NULL, NULL, NULL, NULL, 6, NULL, '2023-01-01', 1600000, 160000, 224000, NULL, 1984000, 0, NULL, NULL, NULL, 'confirmed', '456', 'supplier_invoice', NULL, NULL, '2023-01-01 12:21:54', '2023-01-01 12:22:49'),
(7, 1, NULL, 1, NULL, NULL, 2, NULL, NULL, NULL, '2023-01-01', 7500, 750, 1050, 3750, 5550, 0, NULL, NULL, NULL, 'confirmed', NULL, 'client_invoice', NULL, NULL, '2023-01-01 12:23:31', '2023-01-01 12:25:05'),
(8, NULL, 1, NULL, 2, 'cache', 1, NULL, NULL, NULL, NULL, 1000, 100, 100, NULL, 1000, 0, NULL, NULL, NULL, 'confirmed', NULL, NULL, NULL, NULL, '2023-01-01 12:24:29', '2023-01-01 12:24:29');

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

--
-- Table structure for table `account_invoice_product`
--

CREATE TABLE `account_invoice_product` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `final_product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `account_invoice_id` bigint(20) UNSIGNED DEFAULT NULL,
  `account_id` bigint(20) UNSIGNED DEFAULT NULL,
  `price` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `measuring_unit` enum('meter','liter','kilo','unit','ton') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantity` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tax` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vat` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `discount` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `total` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `account_invoice_product`
--

INSERT INTO `account_invoice_product` (`id`, `product_id`, `final_product_id`, `account_invoice_id`, `account_id`, `price`, `measuring_unit`, `quantity`, `tax`, `vat`, `discount`, `total`, `created_at`, `updated_at`, `description`, `date`) VALUES
(3, 2, NULL, 2, NULL, '1500', NULL, '300', '10', '14', NULL, '558000', '2022-12-27 09:14:58', '2022-12-27 09:14:58', NULL, NULL),
(14, NULL, NULL, 2, 1, '456', NULL, NULL, '45', '45', NULL, '866.4', '2023-01-01 08:00:10', '2023-01-01 08:00:10', 'asdsa', '2023-01-01'),
(16, 1, NULL, 3, NULL, '500', NULL, '1000', '10', '14', NULL, '620000', '2023-01-01 08:02:38', '2023-01-01 08:02:38', NULL, NULL),
(18, NULL, 1, 4, NULL, '500', 'meter', '1', '10', '14', '10', '570', '2023-01-01 10:48:22', '2023-01-01 10:48:22', NULL, NULL),
(20, 32, NULL, 5, NULL, '1500', NULL, '100', '10', '14', NULL, '186000', '2023-01-01 12:18:57', '2023-01-01 12:18:57', NULL, NULL),
(22, 31, NULL, 6, NULL, '2000', NULL, '800', '10', '14', NULL, '1984000', '2023-01-01 12:22:45', '2023-01-01 12:22:45', NULL, NULL),
(24, NULL, NULL, 8, 2, '1000', NULL, NULL, '10', '10', NULL, '1200', '2023-01-01 12:24:29', '2023-01-01 12:24:29', 'يبلات', '2023-01-17'),
(26, NULL, 1, 7, NULL, '7500', 'meter', '1', '10', '14', '50', '5550', '2023-01-01 12:25:01', '2023-01-01 12:25:01', NULL, NULL);

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

--
-- Table structure for table `account_invoice_tax`
--

CREATE TABLE `account_invoice_tax` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tax_id` bigint(20) UNSIGNED DEFAULT NULL,
  `account_invoice_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `account_invoice_tax`
--

INSERT INTO `account_invoice_tax` (`id`, `tax_id`, `account_invoice_id`, `created_at`, `updated_at`) VALUES
(1, 1, 4, NULL, NULL),
(2, 2, 4, NULL, NULL),
(4, 1, 7, NULL, NULL),
(5, 2, 7, NULL, NULL);

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

--
-- Table structure for table `account_ledgers`
--

CREATE TABLE `account_ledgers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ledger_id` bigint(20) UNSIGNED NOT NULL,
  `account_id` bigint(20) UNSIGNED DEFAULT NULL,
  `cost_center_id` bigint(20) UNSIGNED DEFAULT NULL,
  `credit` double(8,2) NOT NULL,
  `debit` double(8,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `account_tax`
--

CREATE TABLE `account_tax` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `account_id` bigint(20) UNSIGNED DEFAULT NULL,
  `tax_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `account_tax`
--

INSERT INTO `account_tax` (`id`, `account_id`, `tax_id`, `created_at`, `updated_at`) VALUES
(1, 2, 1, NULL, NULL),
(2, 1, 2, NULL, NULL);

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

--
-- Table structure for table `assets`
--

CREATE TABLE `assets` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` double NOT NULL,
  `date` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cost_center_id` bigint(20) UNSIGNED DEFAULT NULL,
  `asset_category_id` bigint(20) UNSIGNED DEFAULT NULL,
  `vendor_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `asset_categories`
--

CREATE TABLE `asset_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `depreciation_rate` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `depreciation_type` enum('yearly','quarterly') COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `asset_vendors`
--

CREATE TABLE `asset_vendors` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `asset_id` bigint(20) UNSIGNED DEFAULT NULL,
  `vendor_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `name`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Building materials', NULL, '2022-12-19 05:41:08', '2022-12-19 05:41:08'),
(2, 'computer', NULL, '2022-12-19 05:41:08', '2022-12-19 05:41:08'),
(3, 'electric machines', NULL, '2022-12-19 05:41:08', '2022-12-19 05:41:08'),
(4, 'electrical materials', NULL, '2022-12-19 05:41:08', '2022-12-19 05:41:08'),
(5, 'FUEL OIL', NULL, '2022-12-19 05:41:08', '2022-12-19 05:41:08'),
(6, 'GENERAL', NULL, '2022-12-19 05:41:08', '2022-12-19 05:41:08'),
(7, 'NET', NULL, '2022-12-19 05:41:08', '2022-12-19 05:41:08'),
(8, 'PAINT', NULL, '2022-12-19 05:41:08', '2022-12-19 05:41:08'),
(9, 'PLUMPING', NULL, '2022-12-19 05:41:08', '2022-12-19 05:41:08'),
(10, 'PRINTER', NULL, '2022-12-19 05:41:08', '2022-12-19 05:41:08'),
(11, 'RAW MATIRIAL', NULL, '2022-12-19 05:41:08', '2022-12-19 05:41:08'),
(12, 'SAFETY', NULL, '2022-12-19 05:41:08', '2022-12-19 05:41:08'),
(13, 'Services', NULL, '2022-12-19 05:41:08', '2022-12-19 05:41:08'),
(14, 'SPAR PARTS', NULL, '2022-12-19 05:41:08', '2022-12-19 05:41:08'),
(15, 'SPAR PARTS PUP', NULL, '2022-12-19 05:41:08', '2022-12-19 05:41:08'),
(16, 'stationary', NULL, '2022-12-19 05:41:08', '2022-12-19 05:41:08'),
(17, 'TOOLS', NULL, '2022-12-19 05:41:08', '2022-12-19 05:41:08'),
(18, 'WOOD', NULL, '2022-12-19 05:41:08', '2022-12-19 05:41:08');

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

--
-- Table structure for table `cheque_keepers`
--

CREATE TABLE `cheque_keepers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `cheque_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cheque_value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('pending','bank_up','paid') COLLATE utf8mb4_unicode_ci DEFAULT 'pending',
  `exchange_permission_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cost_centers`
--

CREATE TABLE `cost_centers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `parent_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cost_centers`
--

INSERT INTO `cost_centers` (`id`, `name`, `code`, `description`, `deleted_at`, `parent_id`, `created_at`, `updated_at`) VALUES
(2, 'تكاليف غير مباشرة', '1', NULL, NULL, NULL, '2022-12-28 08:06:10', '2022-12-28 08:06:10'),
(3, 'تكاليف مباشرة', '2', NULL, NULL, NULL, '2022-12-28 08:06:10', '2022-12-28 08:06:10'),
(115, 'عبدالسلام خليل أحمد محمد', '11', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(116, 'محمد أحمد عبدالعظيم احمد', '12', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(117, 'طاهر مصطفى زناتى مبروك', '13', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(118, 'ابراهيم محمد ابراهيم القسطاوى', '14', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(119, 'ماجد عوض الله ميخائيل حنا', '15', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(120, 'محمد نبوى عبدالغفار يوسف', '16', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(121, 'أحمد محمد أحمد بدوى', '17', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(122, 'مصطفى محمد اسماعيل محمد', '18', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(123, 'وليد على محمد على', '19', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(124, 'حلمى ادريس امام على', '110', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(125, 'عبدالسلام عبدالتواب عبدالسلام حسن', '111', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(126, 'عصام عبدالفتاح سيد احمد', '112', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(127, 'سعد فضل خليفة عويس', '113', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(128, 'مصطفى محمد مصطفى سليم', '114', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(129, 'عبدة عيد عبدالحكيم عبدة', '115', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(130, 'خلف فؤاد حسيب فتح الباب', '116', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(131, 'أحمد عصام عبدالفتاح سيد', '117', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(132, 'أسامه عبدالنبى عبدالمعطى حمودة', '118', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(133, 'عرفه عيد سلامه ناصر', '119', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(134, 'مصطفى على السيد الساعاتى', '120', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(135, 'سيد احمد السيد حسن', '121', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(136, 'عملاء العاصمة - شركة رامى فارس', '122', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(137, 'عملاء العاصمة - سند - احمد على', '123', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(138, 'عملاء العاصمة - سند - امير', '124', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(139, 'عملاء العاصمة - بورسعيد', '125', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(140, 'عملاء العاصمة - تبارك', '126', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(141, 'عملاء العاصمة - سند - عبدالعزيز', '127', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(142, 'عملاء العاصمة - الكابتن للاستثمار', '128', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(143, 'عملاء العاصمة - البركة', '129', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(144, 'عملاء العاصمة - العميد ياسر', '130', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(145, 'عملاء العاصمة - ايدج', '131', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(146, 'عملاء العاصمة - سند - محمود اسماعيل', '132', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(147, 'عملاء العاصمة - جى اند جى للتشييد والبناء', '133', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(148, 'عملاء العاصمة - سند - احمد فهمى', '134', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(149, 'شركة الريادة', '135', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(150, 'شركة دستينو ( ارتك )', '136', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(151, 'المكاوى للبناء والتنمية', '137', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(152, 'شركة مكة للنقل والتوريدات العمومية - ابو طاقية', '138', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(153, 'شركة الفارس', '139', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(154, 'حسام الفلاح', '140', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(155, 'اراكو لمواد البناء والمقاولات', '141', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(156, 'شركة الشندى لتوريد المياة', '142', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(157, 'شركة اوريجينال بارتس للتجارة', '143', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(158, 'موردون متنوعون', '144', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(159, 'ديزل بارتس للاستيراد وتجارة قطع غيار السيارات', '145', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(160, 'تصميمى للتصميم والطباعة', '146', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(161, 'بست باى لنظم المعلومات', '147', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(162, 'شركة عزوز لتجارة العدد والالات', '148', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(163, 'شركة باتموس للتجارة', '149', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(164, 'مؤسسة الحرية للاستيراد والتصدير والتوكيلات التجارية', '150', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(165, 'القماح - مصطفى محمد عادل ابو الوفا', '151', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(166, 'العارف للتجارة والتوريدات', '152', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(167, 'الحرمين للادوات الكتابية', '153', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(168, 'العدوى ادفانسد سيستم', '154', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(169, 'بست فور برنت', '155', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(170, 'ملك السيور - سيد عبدالجواد مرسى', '156', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(171, 'تكنو تولز للعدد والالات', '157', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(172, 'مؤسسة الاصيل', '158', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(173, 'تراك بارتس سنتر', '159', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(174, 'ترست تريدينج', '160', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(175, 'عماد ديميترى لقطع الغيار', '161', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(176, 'صالح وحجاب للاستشارات الهندسية', '162', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(177, 'شركة مجدى على احمد خلف وشركاه', '163', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(178, 'عامر حدايد - بويات', '164', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(179, 'ايه ام ديزاين', '165', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(180, 'شركة ايجى انترناشيونال مقاولات وايجار معدات - محمد حسن ابراهيم على', '166', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(181, 'الهجان لتاجير المولدات', '167', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(182, 'محمد جابر', '168', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(183, 'شركة طيبة رنين للتجارة والصناعة ', '169', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(184, 'المتحدة للتوريدات العمومية', '170', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(185, 'شركة سوماك', '171', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(186, 'محمد يوسف سراج الدين - لتجارة الكاوتش', '172', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(187, 'شركة كونكريت تك', '173', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(188, 'رمضان ابراهيم المهدى لتجارة ادوات المعمار', '174', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(189, 'اتصالات - مصر', '175', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(190, 'محمد حسن سيد بدوى - ساليوهات', '176', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(191, 'الوجيه لانظمة الهواء', '177', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(192, 'البحيرى لمعدات البناء', '178', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(193, 'مؤسسة ملجراميكال لتجارة الموازين', '179', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(194, 'الشهيد للاستيراد والتصدير والتوكيلات التجارية', '180', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(195, 'النور لتجارة قطع غيار السيارات محمد صبحى سالم', '181', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(196, 'قطع غيار السيارات - الحاج محمد عبدالرازق', '182', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(197, 'الهندسية لتوريد وتجارة قطع غيار السيارات', '183', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(198, 'شركة الفيلوباتير لتجارة الادوات الكهربائية', '184', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(199, 'عبدالله كمال نجم الدين خالد', '185', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(200, 'محمد اسماعيل مبروك رزق', '186', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(201, 'زاد للتجارة والتوريدات العامة', '187', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(202, 'محمد مصطفى عبدالظاهر محمد', '188', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(203, 'صن كريت', '189', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(204, 'شركة السلام محمد خليل وشركاه', '190', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(205, 'محلات الحريرى للادوات الكهربائية', '191', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(206, 'ليوبارد تريد', '192', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(207, 'الشركة المتحدة للاستيراد والتصدير', '193', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(208, 'طيبة للتجارة والتوريدات', '194', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(209, 'التوحيد للتوكيلات التجارية', '195', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(210, 'تكنو تريد للتجارة والتوريدات', '196', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(211, 'مجموعة مودرن سيرفيس خلف باص', '197', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(212, 'جارى مصلحة الضرائب المصرية ( كسب عمل )', '198', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(213, 'مأمورية ضرائب الخصم والاضافة', '199', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(214, 'جارى مصلحة الضرائب المصرية ( القيمة  المضافة )', '100', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(215, 'الشركة المصرية للسيارات محمد ريان وشركاه', '101', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(216, 'شركه مصر رايموند للاساسات', '102', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(217, 'تبارك مصر لتوريد مواد العزل', '103', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(218, 'المركز القومي لبحوث الاسكان والبناء', '104', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(219, 'المصرية العالمية للسيارات', '105', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(220, 'محمود احمد عبدالظاهر عبدالمطلب - ايجى تريدنج', '106', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(221, 'مودرن كونستراكشن سيستمز', '107', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(222, 'الديب للتجارة والتوريدات', '108', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(223, 'على احمد على حلاوه', '109', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(224, 'تيكما ايجيبت', '1010', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(225, 'شركة اكوا بلاست لتجارة المواسير و مستلزمات الرى', '1011', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(226, 'شركة شلباية تكنولوجى', '1012', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(227, 'مكتب الزينة للتوريدات', '1013', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(228, 'سيكا لصناعة مواد البناء', '1014', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(229, 'تكنولوجى لاب', '1015', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(230, 'الشركة المصرية للاستيراد والتصدير مرشا ـ مروه ورشا وشركاه', '1016', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(231, 'الاخوة للتكييف و المقاولات', '1017', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(232, 'اس دى سولوشنز لتكنولوجيا المعلومات', '1018', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(233, 'المتخصصة لمهمات الامن الصناعى و الاطفاء', '1019', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(234, 'طارق حسين وشركاه', '1020', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(235, 'فور تكنولوجى لاب لاختبار مواد البناء', '1021', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(236, 'سيجال لتجاره الحديد و الصاج', '1022', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(237, 'اولاد بسخرون رزق الله', '1023', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(238, 'الوكيل لتجارة رولمان البلى ومستلزمات المصانع', '1024', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(239, 'شركة الانهار للمقاولات و الاستيراد و التصدير و التوريدات العمومية', '1025', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(240, 'انترناشونال للتجاره و التوريدات', '1026', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(241, 'تكنولوجيا الهواء المضغوط - الحجار مصر', '1027', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(242, 'اى جى لتجارة الحديد', '1028', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(243, 'المؤسسة العالمية للمقاولات العمومية', '1029', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(244, 'مورد عام', '1030', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(245, 'مكآفات وحوافز', '1031', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(246, 'مصروفات أخرى للعاملين', '1032', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(247, 'عمولات بيع', '1033', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(248, 'مصروفات علاج', '1034', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(249, 'مصروفات التدريب', '1035', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(250, 'بدل رصيد اجازات', '1036', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(251, 'مصروفات الكهرباء', '1037', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(252, 'مصروفات التليفونات', '1038', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(253, 'مصروفات مياة - ادارى', '1039', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(254, 'مصروفات الغاز', '1040', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(255, 'مصروفات صيانة وإصلاح', '1041', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(256, 'مصروفات مستلزمات حاسب الى', '1042', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(257, 'مصروفات سلامة وصحة مهنية', '1043', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(258, 'مصروفات سباكة', '1044', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(259, 'مصروفات ادوات كهربائية', '1045', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(260, 'نقل وانتقالات', '1046', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(261, 'إيجارات', '1047', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(262, 'مصروفات بنكية', '1048', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(263, 'أتعاب مهنية', '1049', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(264, 'أدوات كتابية ومطبوعات', '1050', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(265, 'م. شحن و بريد ومراسلات', '1051', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(266, 'مصروفات الدعاية والإعلان', '1052', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(267, 'مكافاة وحوافز - بيع وتسويق', '1053', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(268, 'م.تامينات اجتماعية - بيع وتسويق', '1054', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(269, 'م.تأمين طبي', '1055', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(270, 'مصروفات البوفيه والضيافة', '1056', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(271, 'مصروفات النظافة', '1057', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(272, 'مصروفات طعام', '1058', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(273, 'مصروفات اتصالات', '1059', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(274, 'اكراميات', '1060', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(275, 'م. ميزان', '1061', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(276, 'مصروفات التأمينات الاجتماعية', '1062', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(277, 'المساهمة التكافلية', '1063', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(278, 'رسوم واشتراكات', '1064', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(279, 'مصاريف تأمين سيارات', '1065', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(280, 'ديون معدومة', '1066', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(281, 'تعويضات للغير وغرامات', '1067', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(282, 'م.هالك خامات', '1068', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(283, 'مصروفات ايجار عدد والات', '1069', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(284, 'مصروف عام - مركز البحوث - اختبارات دورية', '1070', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(285, 'مصروف خامات حداده ونجارة', '1071', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(286, 'مصروف خامات عزل', '1072', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(287, 'ايجار سيارات ومعدات', '1073', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(288, 'مصنعيات - حدادة', '1074', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(289, 'خلاطة TM 101', '1075', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(290, 'خلاطة TM 102', '1076', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(291, 'خلاطة TM 103', '1077', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(292, 'خلاطة TM 104', '1078', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(293, 'بامب PM 56', '1079', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(294, 'سياره رينو Stepway Sw', '1080', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(295, 'مينى باص مكيف', '1081', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(296, 'سيارة بيك اب ( نصف نقل )', '1082', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(297, 'مصروفات تشغيل - سولار', '1083', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(298, 'مصروفات تشغيل - غسيل سيارات', '1084', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(299, 'مصروفات تشغيل - قطع غيار', '1085', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(300, 'مصروفات تشغيل  - صيانة', '1086', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(301, 'مصروفات تشغيل - زيوت', '1087', NULL, NULL, 2, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(302, 'مصروفات تشغيل - اسمنت', '21', NULL, NULL, 3, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(303, 'مصروفات تشغيل - سن 1', '22', NULL, NULL, 3, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(304, 'مصروفات تشغيل - سن 2', '23', NULL, NULL, 3, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(305, 'مصروفات تشغيل - رمل', '24', NULL, NULL, 3, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(306, 'مصروفات تشغيل - مادة', '25', NULL, NULL, 3, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(307, 'مصروفات تشغيل - مياة', '26', NULL, NULL, 3, '2022-12-28 08:24:39', '2022-12-28 08:24:39'),
(308, 'مصروفات تشغيل - خامات', '27', NULL, NULL, 3, '2022-12-28 08:24:39', '2022-12-28 08:24:39');

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

--
-- Table structure for table `cost_center_product`
--

CREATE TABLE `cost_center_product` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `cost_center_id` bigint(20) UNSIGNED DEFAULT NULL,
  `product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cost_center_product`
--

INSERT INTO `cost_center_product` (`id`, `cost_center_id`, `product_id`, `created_at`, `updated_at`) VALUES
(1, 117, 4, NULL, NULL),
(2, 116, 4, NULL, NULL);

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

--
-- Table structure for table `currencies`
--

CREATE TABLE `currencies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rate` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_rate` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_action` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `currencies`
--

INSERT INTO `currencies` (`id`, `name`, `rate`, `date_rate`, `date_action`, `deleted_at`, `created_at`, `updated_at`) VALUES
(2, 'جنيه مصري', '1', '2022-12-27T14:17', '2022-12-30T14:17', NULL, '2022-12-27 10:17:50', '2022-12-27 10:17:50');

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

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

CREATE TABLE `customers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `type` enum('individual','company') COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `job_position` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `website` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tax_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `account_customer_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `customers` (`id`, `type`, `name`, `email`, `phone`, `job_position`, `address`, `website`, `tax_id`, `deleted_at`, `created_at`, `updated_at`, `account_customer_no`) VALUES
(1, 'individual', 'Customer 1', 'customer@test.com', '12345678910', 'Developer', 'cairo', 'www.customer.com', 'ABC123465', NULL, '2022-12-19 05:41:08', '2022-12-19 05:41:08', NULL);

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

--
-- Table structure for table `driver_product_purchase`
--

CREATE TABLE `driver_product_purchase` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_purchase_id` bigint(20) UNSIGNED DEFAULT NULL,
  `quantity` double NOT NULL,
  `driver_name` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `car_number` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `policy_number` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `exchanges`
--

CREATE TABLE `exchanges` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `from` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `to` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `direction` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` enum('receive','exchange') COLLATE utf8mb4_unicode_ci NOT NULL,
  `purchase_id` bigint(20) UNSIGNED DEFAULT NULL,
  `sales_id` bigint(20) UNSIGNED DEFAULT NULL,
  `inventory_id` bigint(20) UNSIGNED DEFAULT NULL,
  `department_id` bigint(20) UNSIGNED DEFAULT NULL,
  `status` enum('hold','pre-process','delivered','received') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'hold',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `cost_center_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `exchanges`
--

INSERT INTO `exchanges` (`id`, `from`, `to`, `direction`, `type`, `purchase_id`, `sales_id`, `inventory_id`, `department_id`, `status`, `created_at`, `updated_at`, `cost_center_id`) VALUES
(1, '1', '2', 'inventory_to_po', 'exchange', 2, NULL, NULL, 1, 'pre-process', '2022-12-27 09:22:59', '2022-12-27 09:22:59', NULL),
(2, '1', '1', 'inventory_to_po', 'exchange', 1, NULL, NULL, 1, 'pre-process', '2022-12-27 09:23:30', '2022-12-27 09:23:30', NULL),
(3, '1', '4', 'inventory_to_po', 'exchange', 4, NULL, NULL, 3, 'pre-process', '2022-12-27 09:45:13', '2022-12-27 09:45:13', NULL),
(4, '1', '5', 'inventory_to_po', 'exchange', 5, NULL, NULL, 4, 'pre-process', '2022-12-27 10:26:13', '2022-12-27 10:26:13', NULL),
(5, '1', '1', 'inventory_to_customer', 'exchange', NULL, NULL, NULL, NULL, 'delivered', '2022-12-28 08:58:42', '2022-12-28 08:58:42', 117),
(6, '1', '116', 'to_cost_center', 'exchange', NULL, NULL, NULL, NULL, 'delivered', '2022-12-28 10:20:58', '2022-12-28 10:20:58', 116);

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

--
-- Table structure for table `exchange_permissions`
--

CREATE TABLE `exchange_permissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `invoice_id` bigint(20) UNSIGNED DEFAULT NULL,
  `account_id` bigint(20) UNSIGNED DEFAULT NULL,
  `receipt_voucher_id` bigint(20) UNSIGNED DEFAULT NULL,
  `treasury_id` bigint(20) UNSIGNED DEFAULT NULL,
  `status` enum('pending','approved','confirmed') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `amount` double DEFAULT NULL,
  `date` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_type` enum('cache','Cheques','bank_transfer') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bank_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bank_account_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `current_bank_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `current_bank_account_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `operation_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `operation_date` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transfer_bank_account_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transfer_bank_account_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transfer_bank_amount` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `exchange_permissions`
--

INSERT INTO `exchange_permissions` (`id`, `invoice_id`, `account_id`, `receipt_voucher_id`, `treasury_id`, `status`, `amount`, `date`, `payment_type`, `bank_name`, `bank_account_number`, `current_bank_name`, `current_bank_account_number`, `operation_number`, `operation_date`, `transfer_bank_account_number`, `transfer_bank_account_name`, `transfer_bank_amount`, `created_at`, `updated_at`) VALUES
(7, 2, NULL, NULL, 1, 'approved', 456.00000000000006, '2023-01-01', 'cache', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-01-01 08:00:10', '2023-01-01 08:09:00'),
(8, 3, NULL, NULL, 1, 'approved', 620000, '2023-01-01', 'cache', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-01-01 08:02:42', '2023-01-01 08:09:38'),
(9, 4, NULL, NULL, 1, 'approved', 570, '2023-01-01', 'cache', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-01-01 11:02:03', '2023-01-01 11:02:13'),
(10, 5, NULL, NULL, NULL, 'pending', 186000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-01-01 12:19:16', '2023-01-01 12:19:16'),
(11, 6, NULL, NULL, NULL, 'pending', 1984000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-01-01 12:22:49', '2023-01-01 12:22:49'),
(12, 8, NULL, NULL, NULL, 'pending', 1000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-01-01 12:24:29', '2023-01-01 12:24:29'),
(13, 7, NULL, NULL, NULL, 'pending', 5550, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-01-01 12:25:05', '2023-01-01 12:25:05');

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `final_products`
--

CREATE TABLE `final_products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price` double(8,2) DEFAULT NULL,
  `price_type` enum('fixed','percentage') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `per_cubic_meter` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `category_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `final_products`
--

INSERT INTO `final_products` (`id`, `name`, `code`, `description`, `price`, `price_type`, `per_cubic_meter`, `category_id`, `created_at`, `updated_at`) VALUES
(1, 'test', '123', 'test', 1000.00, 'fixed', '1', 1, '2023-01-01 08:03:57', '2023-01-01 08:03:57');

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

--
-- Table structure for table `final_product_receipes`
--

CREATE TABLE `final_product_receipes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `final_product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `measuring_unit` enum('each','kg','litter','littre','m/l','m3','roll','sheet','ton') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantity` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `final_product_receipes`
--

INSERT INTO `final_product_receipes` (`id`, `final_product_id`, `product_id`, `measuring_unit`, `quantity`, `note`, `created_at`, `updated_at`) VALUES
(1, 1, 5, 'm3', '200', NULL, '2023-01-01 08:03:57', '2023-01-01 08:03:57');

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

--
-- Table structure for table `final_product_sales`
--

CREATE TABLE `final_product_sales` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `final_product_id` bigint(20) UNSIGNED NOT NULL,
  `sales_id` bigint(20) UNSIGNED NOT NULL,
  `unit_price` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `measuring_unit` enum('meter','liter','kilo','unit','ton') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantity` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_pefor_tax` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tax` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `discount` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `final_product_sales`
--

INSERT INTO `final_product_sales` (`id`, `final_product_id`, `sales_id`, `unit_price`, `measuring_unit`, `quantity`, `total_pefor_tax`, `tax`, `discount`, `total`, `created_at`, `updated_at`) VALUES
(1, 1, 1, '500', 'meter', '1', '500', '', '10', '450', '2023-01-01 08:04:52', '2023-01-01 08:04:59'),
(2, 1, 2, '7500', 'meter', '1', '7500', '', '50', '3750', '2023-01-01 12:23:15', '2023-01-01 12:23:24');

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

--
-- Table structure for table `financials`
--

CREATE TABLE `financials` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `general_exchanges`
--

CREATE TABLE `general_exchanges` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `vendor_id` bigint(20) UNSIGNED DEFAULT NULL,
  `account_id` bigint(20) UNSIGNED DEFAULT NULL,
  `purchase_id` bigint(20) UNSIGNED DEFAULT NULL,
  `supply_order_id` bigint(20) UNSIGNED DEFAULT NULL,
  `date` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` double NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `constraint_type` enum('0','1') COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('pending','draft','confirmed','canceled') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `general_exchanges`
--

INSERT INTO `general_exchanges` (`id`, `vendor_id`, `account_id`, `purchase_id`, `supply_order_id`, `date`, `amount`, `description`, `constraint_type`, `status`, `created_at`, `updated_at`) VALUES
(4, 1, 1, NULL, NULL, '2023-01-01 10:02:01', 620000, NULL, '0', 'confirmed', '2023-01-01 08:02:03', '2023-01-01 08:02:11'),
(5, 1, 1, NULL, NULL, '2023-01-01 14:18:36', 186000, NULL, '0', 'confirmed', '2023-01-01 12:18:38', '2023-01-01 12:18:47'),
(6, 1, 1, NULL, NULL, '2023-01-01 14:21:39', 1984000, NULL, '0', 'confirmed', '2023-01-01 12:21:42', '2023-01-01 12:21:54');

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

--
-- Table structure for table `general_exchange_supply_orders`
--

CREATE TABLE `general_exchange_supply_orders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `general_exchange_id` bigint(20) UNSIGNED DEFAULT NULL,
  `supply_order_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `general_exchange_supply_orders`
--

INSERT INTO `general_exchange_supply_orders` (`id`, `general_exchange_id`, `supply_order_id`, `created_at`, `updated_at`) VALUES
(6, 4, 10, '2023-01-01 08:02:03', '2023-01-01 08:02:03'),
(7, 5, 11, '2023-01-01 12:18:39', '2023-01-01 12:18:39'),
(8, 6, 12, '2023-01-01 12:21:42', '2023-01-01 12:21:42');

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

--
-- Table structure for table `general_settings`
--

CREATE TABLE `general_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `currency` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `general_settings`
--

INSERT INTO `general_settings` (`id`, `currency`, `created_at`, `updated_at`) VALUES
(1, 2, '2023-01-01 12:17:44', '2023-01-01 12:17:44');

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

--
-- Table structure for table `inventories`
--

CREATE TABLE `inventories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `inventories`
--

INSERT INTO `inventories` (`id`, `name`, `code`, `address`, `description`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Inventory 1', 'INV-1', 'Inventory 1 Address', NULL, NULL, '2022-12-19 05:41:08', '2022-12-19 05:41:08');

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

--
-- Table structure for table `inventory_product`
--

CREATE TABLE `inventory_product` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `inventory_id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `po_id` bigint(20) UNSIGNED DEFAULT NULL,
  `vendor_id` bigint(20) UNSIGNED DEFAULT NULL,
  `note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price` double NOT NULL,
  `quantity` double NOT NULL,
  `left` double NOT NULL,
  `stock` double NOT NULL,
  `is_valid` enum('0','1') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `inventory_product`
--

INSERT INTO `inventory_product` (`id`, `inventory_id`, `product_id`, `po_id`, `vendor_id`, `note`, `price`, `quantity`, `left`, `stock`, `is_valid`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 4, 2, 1, NULL, 5000, 25, 0, 0, '1', '2022-12-25 13:21:25', '2022-12-28 10:20:58', NULL),
(2, 1, 2, 4, 1, NULL, 1500, 300, 0, 300, '1', '2022-12-27 09:13:50', '2022-12-27 09:22:59', NULL),
(3, 1, 18, 10, 1, NULL, 2051, 500, 500, 0, '0', '2022-12-27 09:25:02', '2022-12-27 09:25:02', NULL),
(4, 1, 15, 9, 1, NULL, 258, 300, 300, 0, '0', '2022-12-27 09:25:25', '2022-12-27 09:25:25', NULL),
(5, 1, 19, 8, 1, NULL, 6354, 200, 200, 0, '0', '2022-12-27 09:25:46', '2022-12-27 09:25:46', NULL),
(6, 1, 191, 14, 1, NULL, 250000, 600, 0, 600, '1', '2022-12-27 09:44:32', '2022-12-27 09:45:18', NULL),
(7, 1, 67, 16, 1, NULL, 20, 15, 0, 15, '1', '2022-12-27 09:44:44', '2022-12-27 09:45:16', NULL),
(8, 1, 13, 15, 1, NULL, 15000, 25, 0, 25, '1', '2022-12-27 09:44:56', '2022-12-27 09:45:13', NULL),
(9, 1, 36, 18, 1, NULL, 1500, 350, 0, 350, '1', '2022-12-27 10:07:56', '2022-12-27 10:26:13', NULL),
(10, 1, 1, 20, 1, NULL, 500, 1000, 1000, 0, '0', '2023-01-01 08:01:46', '2023-01-01 08:01:46', NULL),
(11, 1, 32, 22, 1, NULL, 1500, 100, 100, 0, '0', '2023-01-01 12:18:24', '2023-01-01 12:18:24', NULL),
(12, 1, 31, 24, 1, NULL, 2000, 800, 800, 0, '0', '2023-01-01 12:21:33', '2023-01-01 12:21:33', NULL);

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

--
-- Table structure for table `invoices`
--

CREATE TABLE `invoices` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `general_exchange_id` bigint(20) UNSIGNED DEFAULT NULL,
  `total_after_discount` double DEFAULT NULL,
  `total_before_discount` double DEFAULT NULL,
  `tax` double DEFAULT NULL,
  `discount` double DEFAULT NULL,
  `status` enum('pending','approved') COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `vat` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `jourals`
--

CREATE TABLE `jourals` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `ledgers`
--

CREATE TABLE `ledgers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `transactionId` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount_credit` double(8,2) NOT NULL,
  `amount_debit` double(8,2) NOT NULL,
  `is_balance` tinyint(1) NOT NULL DEFAULT 0,
  `transaction_design` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `list_accounts`
--

CREATE TABLE `list_accounts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `list_accounts`
--

INSERT INTO `list_accounts` (`id`, `code`, `name`, `description`, `created_at`, `updated_at`) VALUES
(1, '1', 'المركز المالي', NULL, '2022-12-19 05:41:08', '2022-12-19 05:41:08'),
(2, '2', 'قائمة الدخل', NULL, '2022-12-19 05:41:08', '2022-12-19 05:41:08');

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

--
-- Table structure for table `media`
--

CREATE TABLE `media` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `collection_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mime_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `disk` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `conversions_disk` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `size` bigint(20) UNSIGNED NOT NULL,
  `manipulations` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`manipulations`)),
  `custom_properties` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`custom_properties`)),
  `generated_conversions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`generated_conversions`)),
  `responsive_images` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`responsive_images`)),
  `order_column` int(10) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `media`
--

INSERT INTO `media` (`id`, `model_type`, `model_id`, `uuid`, `collection_name`, `name`, `file_name`, `mime_type`, `disk`, `conversions_disk`, `size`, `manipulations`, `custom_properties`, `generated_conversions`, `responsive_images`, `order_column`, `created_at`, `updated_at`) VALUES
(1, 'App\\Models\\Vendor', 1, 'c4bfbc40-05f3-4285-8253-1b3633e2cbbf', 'files', 'Vendor 1 -السجل التجاري', 'Ahmed-Hassan.pdf', 'application/pdf', 'public', 'public', 42184, '[]', '[]', '[]', '[]', 1, '2022-12-25 13:20:51', '2022-12-25 13:20:51'),
(2, 'App\\Models\\Vendor', 1, '59e755c9-64da-4814-a77a-f88189159f77', 'files', 'Vendor 1 -البطاقة الضريبية', 'Ahmed-Hassan.pdf', 'application/pdf', 'public', 'public', 42184, '[]', '[]', '[]', '[]', 2, '2022-12-25 13:20:52', '2022-12-25 13:20:52'),
(3, 'App\\Models\\SupplyOrder', 1, 'dfe2fb3b-1eb0-4b3e-bb95-599c446af6a5', 'files', 'Ahmed-Hassan', 'Ahmed-Hassan.pdf', 'application/pdf', 'public', 'public', 42184, '[]', '[]', '[]', '[]', 3, '2022-12-25 13:21:25', '2022-12-25 13:21:25'),
(4, 'App\\Models\\AccountInvoice', 1, 'ed663c9f-3fbf-4325-ad9d-755106ccfb4a', 'attachments', 'RFCO ERP (24)', 'RFCO-ERP-(24).xlsx', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', 'public', 'public', 14147, '[]', '[]', '[]', '[]', 4, '2022-12-27 09:13:01', '2022-12-27 09:13:01'),
(5, 'App\\Models\\SupplyOrder', 2, '6c2fcfbc-64b2-4510-8f37-9cf4871e1777', 'files', 'RFCO ERP (24)', 'RFCO-ERP-(24).xlsx', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', 'public', 'public', 14147, '[]', '[]', '[]', '[]', 5, '2022-12-27 09:13:50', '2022-12-27 09:13:50'),
(6, 'App\\Models\\SupplyOrder', 3, '02af5fb8-214e-4e89-8e70-94829dcf712d', 'files', 'RFCO ERP (24)', 'RFCO-ERP-(24).xlsx', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', 'public', 'public', 14147, '[]', '[]', '[]', '[]', 6, '2022-12-27 09:25:02', '2022-12-27 09:25:02'),
(7, 'App\\Models\\SupplyOrder', 4, '276200e3-9555-4f3e-b084-2a73d603f7e3', 'files', 'RFCO ERP (22)', 'RFCO-ERP-(22).xlsx', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', 'public', 'public', 14679, '[]', '[]', '[]', '[]', 7, '2022-12-27 09:25:25', '2022-12-27 09:25:25'),
(8, 'App\\Models\\SupplyOrder', 5, 'aeb55a00-110a-4a1f-ba86-f92441ea21cb', 'files', 'RFCO ERP (23)', 'RFCO-ERP-(23).xlsx', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', 'public', 'public', 13978, '[]', '[]', '[]', '[]', 8, '2022-12-27 09:25:45', '2022-12-27 09:25:45'),
(9, 'App\\Models\\SupplyOrder', 6, '936e7961-b58a-4811-818f-8558ced3e071', 'files', 'RFCO ERP (22)', 'RFCO-ERP-(22).xlsx', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', 'public', 'public', 14679, '[]', '[]', '[]', '[]', 9, '2022-12-27 09:44:32', '2022-12-27 09:44:32'),
(10, 'App\\Models\\SupplyOrder', 7, 'caee8529-7f7d-4970-a0c2-3b3817a7b2b9', 'files', 'RFCO ERP (22)', 'RFCO-ERP-(22).xlsx', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', 'public', 'public', 14679, '[]', '[]', '[]', '[]', 10, '2022-12-27 09:44:44', '2022-12-27 09:44:44'),
(11, 'App\\Models\\SupplyOrder', 8, 'dee329db-63e7-4f1b-a3d4-c15680f853f9', 'files', 'RFCO ERP (22)', 'RFCO-ERP-(22).xlsx', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', 'public', 'public', 14679, '[]', '[]', '[]', '[]', 11, '2022-12-27 09:44:56', '2022-12-27 09:44:56'),
(12, 'App\\Models\\AccountInvoice', 4, '92f8352f-72ae-40f4-a9bb-877400220d90', 'attachments', 'RFCO ERP (23)', 'RFCO-ERP-(23).xlsx', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', 'public', 'public', 13978, '[]', '[]', '[]', '[]', 12, '2022-12-27 10:07:10', '2022-12-27 10:07:10'),
(13, 'App\\Models\\SupplyOrder', 9, 'ac706cb4-c717-4bfb-a63c-4011938cd544', 'files', 'RFCO ERP (23)', 'RFCO-ERP-(23).xlsx', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', 'public', 'public', 13978, '[]', '[]', '[]', '[]', 13, '2022-12-27 10:07:56', '2022-12-27 10:07:56'),
(14, 'App\\Models\\AccountInvoice', 1, '26ab3c80-2c43-4a4c-b984-d1cca729cfbb', 'attachments', 'RFCO ERP (24)', 'RFCO-ERP-(24).xlsx', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', 'public', 'public', 14147, '[]', '[]', '[]', '[]', 14, '2022-12-27 10:40:26', '2022-12-27 10:40:26'),
(15, 'App\\Models\\AccountInvoice', 1, '91f8d50e-ac36-46e7-b775-b85941272712', 'attachments', 'RFCO ERP (23)', 'RFCO-ERP-(23).xlsx', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', 'public', 'public', 13978, '[]', '[]', '[]', '[]', 15, '2022-12-27 10:40:27', '2022-12-27 10:40:27'),
(16, 'App\\Models\\AccountInvoice', 2, 'a3e536ca-4ad2-4572-92d9-b1d54e6a2d1c', 'attachments', 'env', 'env', 'text/plain', 'public', 'public', 1181, '[]', '[]', '[]', '[]', 16, '2023-01-01 08:00:09', '2023-01-01 08:00:09'),
(17, 'App\\Models\\SupplyOrder', 10, 'c130487e-4c7c-418a-b487-e07835e39562', 'files', 'notes', 'notes', 'text/plain', 'public', 'public', 6040, '[]', '[]', '[]', '[]', 17, '2023-01-01 08:01:46', '2023-01-01 08:01:46'),
(18, 'App\\Models\\SupplyOrder', 11, 'e61f5f35-add4-4035-9f88-680c2132037e', 'files', 'SD Emails', 'SD-Emails.txt', 'text/plain', 'public', 'public', 331, '[]', '[]', '[]', '[]', 18, '2023-01-01 12:18:24', '2023-01-01 12:18:24'),
(19, 'App\\Models\\SupplyOrder', 12, '950371e8-ffcf-4d21-887d-e494e4c3c211', 'files', 'SD Emails', 'SD-Emails.txt', 'text/plain', 'public', 'public', 331, '[]', '[]', '[]', '[]', 19, '2023-01-01 12:21:33', '2023-01-01 12:21:33'),
(20, 'App\\Models\\AccountInvoice', 8, '8b06c1d9-1d57-4bcf-862f-52ccb24d1359', 'attachments', 'SD Emails', 'SD-Emails.txt', 'text/plain', 'public', 'public', 331, '[]', '[]', '[]', '[]', 20, '2023-01-01 12:24:29', '2023-01-01 12:24:29');

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2022_03_15_120530_laratrust_setup_tables', 1),
(6, '2022_06_02_074313_create_inventories_table', 1),
(7, '2022_06_02_075235_create_categories_table', 1),
(8, '2022_06_04_103054_create_customers_table', 1),
(9, '2022_06_04_103056_create_vendors_table', 1),
(10, '2022_06_04_103067_create_products_table', 1),
(11, '2022_06_04_105721_create_media_table', 1),
(12, '2022_06_04_111523_create_currencies_table', 1),
(13, '2022_06_04_130818_create_purchases_table', 1),
(14, '2022_06_04_133045_create_product_purchases_table', 1),
(15, '2022_06_22_000325_create_inventory_product_table', 1),
(16, '2022_07_18_120946_add_min_stock_to_products_table', 1),
(17, '2022_07_27_075835_add_status_to_purchases_table', 1),
(18, '2022_08_20_073617_create_list_accounts_table', 1),
(19, '2022_08_20_092224_create_accounts_table', 1),
(20, '2022_08_21_090105_create_settings_table', 1),
(21, '2022_08_21_111927_create_exchanges_table', 1),
(22, '2022_08_21_112315_add_account_customer_no_to_customers', 1),
(23, '2022_08_21_112436_create_transaction_stocks_table', 1),
(24, '2022_08_21_134608_add_account_vendor_no_to_vendors', 1),
(25, '2022_08_21_134639_add_account_employee_no_to_users', 1),
(26, '2022_08_28_075142_create_general_exchanges_table', 1),
(27, '2022_08_28_075143_create_account_invoices_table', 1),
(28, '2022_08_28_075143_create_sales_table', 1),
(29, '2022_08_28_075144_create_product_sales_table', 1),
(30, '2022_08_28_075145_add_status_to_sales_table', 1),
(31, '2022_08_28_075146_edit_status_column_sales_table', 1),
(32, '2022_08_28_080120_create_invoices_table', 1),
(33, '2022_08_28_080652_create_exchange_permissions_table', 1),
(34, '2022_08_30_072433_create_receipt_vouchers_table', 1),
(35, '2022_08_30_072434_create_sales_invoices_table', 1),
(36, '2022_08_30_091206_create_cheque_keepers_table', 1),
(37, '2022_08_30_141931_add_receipt_voucher_id_to_exchange_permissions_table', 1),
(38, '2022_08_31_075636_add_condition_to_sales_invoices', 1),
(39, '2022_08_31_150137_create_assets_table', 1),
(40, '2022_09_01_064159_create_final_products_table', 1),
(41, '2022_09_01_064733_create_final_product_receipes_table', 1),
(42, '2022_09_01_070709_add_commerical_id_to_vendors', 1),
(43, '2022_09_01_073343_add_vat_to_invoices', 1),
(44, '2022_09_01_085847_create_jourals_table', 1),
(45, '2022_09_01_085924_create_taxes_table', 1),
(46, '2022_09_01_123134_create_financials_table', 1),
(47, '2022_09_01_123205_create_account_financials_table', 1),
(48, '2022_09_01_132404_create_account_invoice_product_table', 1),
(49, '2022_09_01_135206_create_account_invoice_tax_table', 1),
(50, '2022_09_01_150652_create_account_taxes_table', 1),
(51, '2022_09_01_151218_add_changes_to_accounts_table', 1),
(52, '2022_09_03_084838_create_final_product_sales_table', 1),
(53, '2022_09_03_105352_drop_column_type_from_accounts_table', 1),
(54, '2022_09_03_105557_add_column_type_from_accounts_table', 1),
(55, '2022_09_08_071903_create_ledgers_table', 1),
(56, '2022_09_08_071923_create_account_ledgers_table', 1),
(57, '2022_09_14_095625_create_cost_centers_table', 1),
(58, '2022_09_14_095922_create_asset_categories_table', 1),
(59, '2022_09_14_102411_create_changes_on_assets_table', 1),
(60, '2022_09_14_105110_create_asset_vendors_table', 1),
(61, '2022_09_22_101914_add_type_to_taxes_table', 1),
(62, '2022_09_22_133039_create_tax_vendors_table', 1),
(63, '2022_09_22_141338_drop_taxes_from_vendors_table', 1),
(64, '2022_09_25_130503_add_sales_id_to_exchanges_table', 1),
(65, '2022_09_25_143640_drop_taxes_type_column', 1),
(66, '2022_09_25_143831_add_taxes_type_column', 1),
(67, '2022_09_27_092434_add_vat_column_into_product_purchase_table', 1),
(68, '2022_09_28_113132_add_softdelete_to_inventory_product_table', 1),
(69, '2022_10_02_105916_add_record_type_to_taxes_table', 1),
(70, '2022_10_02_115921_drop_table_account_taxes_table', 1),
(71, '2022_10_02_120509_create_account_tax_table', 1),
(72, '2022_10_05_112124_add_cost_center_fk_to_exchanges_table', 1),
(73, '2022_10_05_120433_create_cost_center_product_table', 1),
(74, '2022_10_08_165049_add_cost_center_id_to_account_ledgers_table', 1),
(75, '2022_10_12_110552_create_treasuries_table', 1),
(76, '2022_10_13_085239_add_treasury_fk_to_exchange_permiissions_table', 1),
(77, '2022_10_13_150444_edit_status_column_exchange_permission_table', 1),
(78, '2022_10_18_103623_create_driver_product_purchase_table', 1),
(79, '2022_10_20_085708_create_supply_orders_table', 1),
(80, '2022_10_22_110617_add_left_column_to_product_purchase_table', 1),
(81, '2022_10_24_110346_add_supply_order_id_to_general_exchanges_table', 1),
(82, '2022_10_25_103249_create_general_exchange_supply_orders_table', 1),
(83, '2022_10_26_093001_add_vendor_id_to_product_purchases_table', 1),
(84, '2022_10_26_093116_add_vendor_id_to_inventory_product_table', 1),
(85, '2022_10_30_122209_add_custom_columns_to_account_invoice_table', 1),
(86, '2022_10_30_124100_add_custom_columns_to_account_invoice_product_table', 1),
(87, '2022_11_01_074757_create_payment_terms_table', 1),
(88, '2022_11_03_081021_add_status_to_supply_order_table', 1),
(89, '2022_11_13_113312_add_columns_to_treasuries_table', 1),
(90, '2022_11_17_105115_edit_in_vendors_table', 1),
(91, '2022_11_19_091350_edit_in_account_invoice_table', 1),
(92, '2022_11_20_110517_edit_in_accounts_table', 1),
(93, '2022_11_29_103517_add_opening_balance_to_accounts_table', 1),
(94, '2022_12_08_135351_remove_unique_from_accounts_table', 1),
(95, '2022_12_13_104000_add_user_id_to_product_purchase_table', 1),
(96, '2022_12_13_123551_add_created_by_to_users_table', 1),
(97, '2023_01_01_104012_create_general_settings_table', 2);

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

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `payment_terms`
--

CREATE TABLE `payment_terms` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `value` double NOT NULL,
  `date` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `account_invoice_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `name`, `display_name`, `description`, `created_at`, `updated_at`) VALUES
(1, 'users-create', 'Create Users', 'Create Users', '2022-12-19 05:41:06', '2022-12-19 05:41:06'),
(2, 'users-read', 'Read Users', 'Read Users', '2022-12-19 05:41:06', '2022-12-19 05:41:06'),
(3, 'users-update', 'Update Users', 'Update Users', '2022-12-19 05:41:06', '2022-12-19 05:41:06'),
(4, 'users-delete', 'Delete Users', 'Delete Users', '2022-12-19 05:41:06', '2022-12-19 05:41:06'),
(5, 'profile-read', 'Read Profile', 'Read Profile', '2022-12-19 05:41:06', '2022-12-19 05:41:06'),
(6, 'profile-update', 'Update Profile', 'Update Profile', '2022-12-19 05:41:06', '2022-12-19 05:41:06'),
(7, 'roles-create', 'Create Roles', 'Create Roles', '2022-12-19 05:41:06', '2022-12-19 05:41:06'),
(8, 'roles-read', 'Read Roles', 'Read Roles', '2022-12-19 05:41:06', '2022-12-19 05:41:06'),
(9, 'roles-update', 'Update Roles', 'Update Roles', '2022-12-19 05:41:06', '2022-12-19 05:41:06'),
(10, 'roles-delete', 'Delete Roles', 'Delete Roles', '2022-12-19 05:41:06', '2022-12-19 05:41:06'),
(11, 'permissions-read', 'Read Permissions', 'Read Permissions', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(12, 'permissions-delete', 'Delete Permissions', 'Delete Permissions', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(13, 'inventories-create', 'Create Inventories', 'Create Inventories', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(14, 'inventories-read', 'Read Inventories', 'Read Inventories', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(15, 'inventories-update', 'Update Inventories', 'Update Inventories', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(16, 'inventories-delete', 'Delete Inventories', 'Delete Inventories', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(17, 'purchases-create', 'Create Purchases', 'Create Purchases', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(18, 'purchases-read', 'Read Purchases', 'Read Purchases', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(19, 'purchases-update', 'Update Purchases', 'Update Purchases', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(20, 'purchases-delete', 'Delete Purchases', 'Delete Purchases', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(21, 'products-create', 'Create Products', 'Create Products', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(22, 'products-read', 'Read Products', 'Read Products', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(23, 'products-update', 'Update Products', 'Update Products', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(24, 'products-delete', 'Delete Products', 'Delete Products', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(25, 'categories-create', 'Create Categories', 'Create Categories', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(26, 'categories-read', 'Read Categories', 'Read Categories', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(27, 'categories-update', 'Update Categories', 'Update Categories', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(28, 'categories-delete', 'Delete Categories', 'Delete Categories', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(29, 'sales-create', 'Create Sales', 'Create Sales', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(30, 'sales-read', 'Read Sales', 'Read Sales', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(31, 'sales-update', 'Update Sales', 'Update Sales', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(32, 'sales-delete', 'Delete Sales', 'Delete Sales', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(33, 'exchanges-create', 'Create Exchanges', 'Create Exchanges', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(34, 'exchanges-read', 'Read Exchanges', 'Read Exchanges', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(35, 'final_products-create', 'Create Final_products', 'Create Final_products', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(36, 'final_products-read', 'Read Final_products', 'Read Final_products', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(37, 'final_products-update', 'Update Final_products', 'Update Final_products', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(38, 'final_products-delete', 'Delete Final_products', 'Delete Final_products', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(39, 'vendors-create', 'Create Vendors', 'Create Vendors', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(40, 'vendors-read', 'Read Vendors', 'Read Vendors', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(41, 'vendors-update', 'Update Vendors', 'Update Vendors', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(42, 'vendors-delete', 'Delete Vendors', 'Delete Vendors', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(43, 'customers-create', 'Create Customers', 'Create Customers', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(44, 'customers-read', 'Read Customers', 'Read Customers', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(45, 'customers-update', 'Update Customers', 'Update Customers', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(46, 'customers-delete', 'Delete Customers', 'Delete Customers', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(47, 'assets-create', 'Create Assets', 'Create Assets', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(48, 'assets-read', 'Read Assets', 'Read Assets', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(49, 'assets-update', 'Update Assets', 'Update Assets', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(50, 'assets-delete', 'Delete Assets', 'Delete Assets', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(51, 'cost_centers-create', 'Create Cost_centers', 'Create Cost_centers', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(52, 'cost_centers-read', 'Read Cost_centers', 'Read Cost_centers', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(53, 'cost_centers-update', 'Update Cost_centers', 'Update Cost_centers', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(54, 'cost_centers-delete', 'Delete Cost_centers', 'Delete Cost_centers', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(55, 'taxes-create', 'Create Taxes', 'Create Taxes', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(56, 'taxes-read', 'Read Taxes', 'Read Taxes', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(57, 'taxes-update', 'Update Taxes', 'Update Taxes', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(58, 'taxes-delete', 'Delete Taxes', 'Delete Taxes', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(59, 'treasuries-create', 'Create Treasuries', 'Create Treasuries', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(60, 'treasuries-read', 'Read Treasuries', 'Read Treasuries', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(61, 'treasuries-update', 'Update Treasuries', 'Update Treasuries', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(62, 'treasuries-delete', 'Delete Treasuries', 'Delete Treasuries', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(63, 'invoices-create', 'Create Invoices', 'Create Invoices', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(64, 'invoices-read', 'Read Invoices', 'Read Invoices', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(65, 'invoices-update', 'Update Invoices', 'Update Invoices', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(66, 'invoices-delete', 'Delete Invoices', 'Delete Invoices', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(67, 'settings-read', 'Read Settings', 'Read Settings', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(68, 'settings-update', 'Update Settings', 'Update Settings', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(69, 'accounts-create', 'Create Accounts', 'Create Accounts', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(70, 'accounts-read', 'Read Accounts', 'Read Accounts', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(71, 'accounts-update', 'Update Accounts', 'Update Accounts', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(72, 'accounts-delete', 'Delete Accounts', 'Delete Accounts', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(73, 'supply-order-assign-user', 'Assign-user Supply_orders', 'Assign-user Supply_orders', '2022-12-19 05:41:07', '2022-12-19 05:41:07');

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

--
-- Table structure for table `permission_role`
--

CREATE TABLE `permission_role` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permission_role`
--

INSERT INTO `permission_role` (`permission_id`, `role_id`) VALUES
(1, 1),
(2, 1),
(3, 1),
(4, 1),
(5, 1),
(5, 2),
(5, 3),
(5, 4),
(6, 1),
(6, 2),
(6, 3),
(6, 4),
(7, 1),
(8, 1),
(9, 1),
(10, 1),
(11, 1),
(12, 1),
(13, 1),
(13, 2),
(13, 3),
(14, 1),
(14, 2),
(14, 3),
(15, 1),
(15, 2),
(15, 3),
(16, 1),
(16, 2),
(16, 3),
(17, 1),
(17, 2),
(17, 3),
(17, 4),
(18, 1),
(18, 2),
(18, 3),
(18, 4),
(19, 1),
(19, 2),
(19, 3),
(19, 4),
(20, 1),
(20, 2),
(20, 3),
(20, 4),
(21, 1),
(21, 2),
(22, 1),
(22, 2),
(23, 1),
(23, 2),
(24, 1),
(24, 2),
(25, 1),
(25, 2),
(26, 1),
(26, 2),
(27, 1),
(27, 2),
(28, 1),
(28, 2),
(29, 1),
(30, 1),
(31, 1),
(32, 1),
(33, 1),
(33, 2),
(34, 1),
(34, 2),
(35, 1),
(35, 2),
(36, 1),
(36, 2),
(37, 1),
(37, 2),
(38, 1),
(38, 2),
(39, 1),
(39, 3),
(40, 1),
(40, 3),
(41, 1),
(41, 3),
(42, 1),
(42, 3),
(43, 1),
(44, 1),
(45, 1),
(46, 1),
(47, 1),
(47, 4),
(48, 1),
(48, 4),
(49, 1),
(49, 4),
(50, 1),
(50, 4),
(51, 1),
(51, 4),
(52, 1),
(52, 4),
(53, 1),
(53, 4),
(54, 1),
(54, 4),
(55, 1),
(55, 4),
(56, 1),
(56, 4),
(57, 1),
(57, 4),
(58, 1),
(58, 4),
(59, 1),
(59, 4),
(60, 1),
(60, 4),
(61, 1),
(61, 4),
(62, 1),
(62, 4),
(63, 1),
(63, 4),
(64, 1),
(64, 4),
(65, 1),
(65, 4),
(66, 1),
(66, 4),
(67, 1),
(67, 4),
(68, 1),
(68, 4),
(69, 1),
(69, 4),
(70, 1),
(70, 4),
(71, 1),
(71, 4),
(72, 1),
(72, 4),
(73, 1);

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

--
-- Table structure for table `permission_user`
--

CREATE TABLE `permission_user` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `user_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `measuring_unit` enum('each','kg','litter','littre','m/l','m3','roll','sheet','ton') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price` double(8,2) DEFAULT NULL,
  `sales_price` double(8,2) DEFAULT NULL,
  `cost` double(8,2) DEFAULT NULL,
  `vat` double(8,2) DEFAULT NULL,
  `min_stock` int(11) DEFAULT NULL,
  `is_low` tinyint(1) NOT NULL DEFAULT 0,
  `category_id` bigint(20) UNSIGNED DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `products` (`id`, `name`, `measuring_unit`, `price`, `sales_price`, `cost`, `vat`, `min_stock`, `is_low`, `category_id`, `deleted_at`, `code`, `description`, `created_at`, `updated_at`) VALUES
(1, 'اسمنت العريش - رتبة 42.5', 'ton', NULL, NULL, NULL, NULL, NULL, 1, 11, NULL, 'RM2100001', NULL, '2022-12-19 08:21:16', '2023-01-01 08:01:22'),
(2, 'اسمنت مصر بنى سويف - رتبه 42', 'ton', NULL, NULL, NULL, NULL, NULL, 0, 11, NULL, 'RM2100002', NULL, '2022-12-19 08:21:16', '2022-12-27 09:22:59'),
(3, 'سن 1', 'm3', NULL, NULL, NULL, NULL, NULL, 0, 11, NULL, 'RM2100003', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(4, 'سن 2', 'm3', NULL, NULL, NULL, NULL, NULL, 0, 11, NULL, 'RM2100004', NULL, '2022-12-19 08:21:16', '2022-12-27 09:23:30'),
(5, 'رمل', 'm3', NULL, NULL, NULL, NULL, NULL, 0, 11, NULL, 'RM2100005', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(6, 'مادة SP30', 'littre', NULL, NULL, NULL, NULL, NULL, 0, 11, NULL, 'RM2100006', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(7, 'مادة 666', 'littre', NULL, NULL, NULL, NULL, NULL, 0, 11, NULL, 'RM2100007', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(8, 'مادة 3060', 'littre', NULL, NULL, NULL, NULL, NULL, 0, 11, NULL, 'RM2100008', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(9, 'مادة SP20', 'littre', NULL, NULL, NULL, NULL, NULL, 0, 11, NULL, 'RM2100009', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(10, 'مياة', 'm3', NULL, NULL, NULL, NULL, NULL, 0, 11, NULL, 'RM2100010', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(11, 'بنزين', 'littre', NULL, NULL, NULL, NULL, NULL, 0, 5, NULL, 'FO5500001', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(12, 'سولار', 'littre', NULL, NULL, NULL, NULL, NULL, 0, 5, NULL, 'FO5500002', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(13, 'رمل - مهزوز', 'm3', NULL, NULL, NULL, NULL, NULL, 0, 11, NULL, 'RM2100011', NULL, '2022-12-19 08:21:16', '2022-12-27 09:45:13'),
(14, 'اسمنت مصر بنى سويف - رتبة 52.5', 'ton', NULL, NULL, NULL, NULL, NULL, 0, 11, NULL, 'RM2100012', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(15, 'بستلة شحم موبيل 18كجم', 'each', NULL, NULL, NULL, NULL, NULL, 1, 5, NULL, 'FO5500003', NULL, '2022-12-19 08:21:16', '2022-12-27 09:24:44'),
(16, 'بستلة شحم زيرو', 'each', NULL, NULL, NULL, NULL, NULL, 0, 5, NULL, 'FO5500004', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(17, 'جركن زيت موتور ديلو20 لتر', 'each', NULL, NULL, NULL, NULL, NULL, 0, 5, NULL, 'FO5500005', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(18, 'زيت هيدروليك التعاون 16 لتر', 'each', NULL, NULL, NULL, NULL, NULL, 1, 5, NULL, 'FO5500006', NULL, '2022-12-19 08:21:16', '2022-12-27 09:24:44'),
(19, 'جركن زيت تروس 90 ', 'each', NULL, NULL, NULL, NULL, NULL, 1, 5, NULL, 'FO5500007', NULL, '2022-12-19 08:21:16', '2022-12-27 09:24:44'),
(20, 'جركن هيدروليك شيل 46', 'each', NULL, NULL, NULL, NULL, NULL, 0, 5, NULL, 'FO5500008', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(21, 'زيت موتور موبيل 1350/لتر 20', 'each', NULL, NULL, NULL, NULL, NULL, 0, 5, NULL, 'FO5500009', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(22, '16لتر  زيت موبيل هيدروليك DTE26 ', 'each', NULL, NULL, NULL, NULL, NULL, 0, 5, NULL, 'FO5500010', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(23, 'طفايةحريق 6كجم', 'each', NULL, NULL, NULL, NULL, NULL, 0, 12, NULL, 'SF2300001', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(24, 'عداد سولار', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600001', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(25, 'مسدس سولار', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600002', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(26, 'مفتاح بلدى 50/55', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600003', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(27, 'رولة كبيرة', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600004', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(28, 'رولة صغيرة', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600005', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(29, 'فرشاة دهان', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600006', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(30, 'بروة', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600007', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(31, 'جالون لاكيه ابيض', 'each', NULL, NULL, NULL, NULL, NULL, 1, 8, NULL, 'PN8800001', NULL, '2022-12-19 08:21:16', '2023-01-01 12:21:09'),
(32, 'بستلة دهان سكيب', 'each', NULL, NULL, NULL, NULL, NULL, 1, 8, NULL, 'PN8800002', NULL, '2022-12-19 08:21:16', '2023-01-01 12:18:03'),
(33, 'شيكارة فارغه', 'each', NULL, NULL, NULL, NULL, NULL, 0, 6, NULL, 'GN6600001', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(34, '22.5 R315-80  فردة كاوتش', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400001', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(35, 'براويطة مدعمة', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600008', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(36, 'سنجة 20 كيلو زهر', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600009', NULL, '2022-12-19 08:21:16', '2022-12-27 10:26:13'),
(37, 'سنجة 1 كيلو', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600010', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(38, 'سنجة نص كيلو', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600011', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(39, 'سنجة ربع كيلو', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600012', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(40, 'غلاية 10 لتر', 'each', NULL, NULL, NULL, NULL, NULL, 0, 3, NULL, 'EM3300001', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(41, 'مروحة يونيون حائطى 18 بوصة', 'each', NULL, NULL, NULL, NULL, NULL, 0, 3, NULL, 'EM3300002', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(42, 'قلب عادى سلندر', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600013', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(43, 'قلب كمبيوتر', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600014', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(44, 'كلابش انبوبة', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600015', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(45, 'كلابة يد كاوتش', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600016', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(46, 'قفل زهر كبير', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600017', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(47, 'كالون باب', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600018', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(48, 'كوريك صلب باليد', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600019', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(49, 'لوح خشب بلود', 'sheet', NULL, NULL, NULL, NULL, NULL, 0, 18, NULL, 'WD2800001', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(50, 'صابون سائل', 'littre', NULL, NULL, NULL, NULL, NULL, 0, 13, NULL, 'SV2300001', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(51, 'زجاجة فنيك', 'each', NULL, NULL, NULL, NULL, NULL, 0, 13, NULL, 'SV2300002', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(52, 'ملمع اثاث', 'each', NULL, NULL, NULL, NULL, NULL, 0, 13, NULL, 'SV2300003', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(53, 'فوطة مطبخ', 'each', NULL, NULL, NULL, NULL, NULL, 0, 13, NULL, 'SV2300004', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(54, 'معطر جو', 'each', NULL, NULL, NULL, NULL, NULL, 0, 13, NULL, 'SV2300005', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(55, 'جردل كامل', 'each', NULL, NULL, NULL, NULL, NULL, 0, 13, NULL, 'SV2300006', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(56, 'مساحة ', 'each', NULL, NULL, NULL, NULL, NULL, 0, 13, NULL, 'SV2300007', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(57, 'مكنسه', 'each', NULL, NULL, NULL, NULL, NULL, 0, 13, NULL, 'SV2300008', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(58, 'مج شاى زجاج', 'each', NULL, NULL, NULL, NULL, NULL, 0, 13, NULL, 'SV2300009', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(59, 'خلاطة نحلة كهربا', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600020', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(60, 'جاروف خرسانة الومنيوم', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600021', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(61, 'سخان تيرموستات', 'each', NULL, NULL, NULL, NULL, NULL, 0, 3, NULL, 'EM3300003', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(62, 'فيشة خارجى بالغطاء', 'each', NULL, NULL, NULL, NULL, NULL, 0, 4, NULL, 'ELC4400001', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(63, 'بريزة كهرباء', 'each', NULL, NULL, NULL, NULL, NULL, 0, 4, NULL, 'ELC4400002', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(64, 'شاسيه كهربا', 'each', NULL, NULL, NULL, NULL, NULL, 0, 4, NULL, 'ELC4400003', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(65, 'وش كهربا', 'each', NULL, NULL, NULL, NULL, NULL, 0, 4, NULL, 'ELC4400004', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(66, 'لمبة 40 وات', 'each', NULL, NULL, NULL, NULL, NULL, 0, 4, NULL, 'ELC4400005', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(67, 'لوحة 2 خط', 'each', NULL, NULL, NULL, NULL, NULL, 0, 4, NULL, 'ELC4400006', NULL, '2022-12-19 08:21:16', '2022-12-27 09:45:16'),
(68, 'مفتاح احادى 32/20', 'each', NULL, NULL, NULL, NULL, NULL, 0, 4, NULL, 'ELC4400007', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(69, 'كابل كهربا 4*4', 'm/l', NULL, NULL, NULL, NULL, NULL, 0, 4, NULL, 'ELC4400008', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(70, 'دواية ', 'each', NULL, NULL, NULL, NULL, NULL, 0, 4, NULL, 'ELC4400008', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(71, 'لمبة ليد 12', 'each', NULL, NULL, NULL, NULL, NULL, 0, 4, NULL, 'ELC4400009', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(72, 'كشاف 120سم 1لمبة', 'each', NULL, NULL, NULL, NULL, NULL, 0, 4, NULL, 'ELC4400010', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(73, 'مفتاح ماجيك', 'each', NULL, NULL, NULL, NULL, NULL, 0, 4, NULL, 'ELC4400011', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(74, 'افيز 10', 'each', NULL, NULL, NULL, NULL, NULL, 0, 9, NULL, 'PM9900001', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(75, 'كرسى محطة 212', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400002', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(76, 'كرسى محطة 214', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400003', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(77, 'كرسى مهزة الرمل T212', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400004', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(78, 'موتور مياه 15 حصان', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600022', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(79, 'بلية SKF 23218 CC/C3W33', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400005', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(80, 'سير مهزة الرمل B63/1600*17', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400006', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(81, 'سير مهزة رمل B76/1930*17', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400007', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(82, 'سير ميزان الفيدر C79/22*2000L1', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400008', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(83, 'كيس قفيز بلاستيك', 'each', NULL, NULL, NULL, NULL, NULL, 0, 9, NULL, 'PM9900002', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(84, 'كوليه 3/4 بوصة', 'each', NULL, NULL, NULL, NULL, NULL, 0, 9, NULL, 'PM9900003', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(85, 'كوليه 1/2 بوصة', 'each', NULL, NULL, NULL, NULL, NULL, 0, 9, NULL, 'PM9900004', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(86, 'كوليه 1 بوصة', 'each', NULL, NULL, NULL, NULL, NULL, 0, 9, NULL, 'PM9900005', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(87, 'كوليه 2 بوصة', 'each', NULL, NULL, NULL, NULL, NULL, 0, 9, NULL, 'PM9900006', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(88, 'كوليه 12بوصة', 'each', NULL, NULL, NULL, NULL, NULL, 0, 9, NULL, 'PM9900007', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(89, 'سير الميكسر SPB2650', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400009', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(90, 'C85 السير الصاعد', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400010', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(91, 'ماكينة لحام بولى تركى', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600023', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(92, 'بكرة تيفلون', 'each', NULL, NULL, NULL, NULL, NULL, 0, 9, NULL, 'PM9900008', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(93, 'محبس 3/4 بوصة', 'each', NULL, NULL, NULL, NULL, NULL, 0, 9, NULL, 'PM9900009', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(94, 'محبس 1 بوصة', 'each', NULL, NULL, NULL, NULL, NULL, 0, 9, NULL, 'PM9900010', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(95, 'محبس 2 بوصة', 'each', NULL, NULL, NULL, NULL, NULL, 0, 9, NULL, 'PM9900011', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(96, 'جلبة بولى 1 بوصة', 'each', NULL, NULL, NULL, NULL, NULL, 0, 9, NULL, 'PM9900012', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(97, 'خرطوم 2 سلكة بالاكور', 'm/l', NULL, NULL, NULL, NULL, NULL, 0, 9, NULL, 'PM9900013', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(98, 'نبل 1 بوصة حديد', 'each', NULL, NULL, NULL, NULL, NULL, 0, 9, NULL, 'PM9900014', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(99, 'باكو شريط لحام ', 'each', NULL, NULL, NULL, NULL, NULL, 0, 4, NULL, 'ELC4400012', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(100, 'علبة خان ووتر بروف ماجيك', 'each', NULL, NULL, NULL, NULL, NULL, 0, 9, NULL, 'PM9900015', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(101, 'مفتاح ماجيك', 'each', NULL, NULL, NULL, NULL, NULL, 0, 4, NULL, 'ELC4400013', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(102, 'كوسة نحاس 95مم', 'each', NULL, NULL, NULL, NULL, NULL, 0, 4, NULL, 'ELC4400014', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(103, 'كوسة نحاس 50مم', 'each', NULL, NULL, NULL, NULL, NULL, 0, 4, NULL, 'ELC4400015', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(104, 'بوابة اسمنت', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400011', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(105, 'وصلة هواء نص بوصة / 12مم', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400012', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(106, 'بنز تشحيم عدل 6مم', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600024', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(107, 'بنز تشحيم كوع 8مم', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600025', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(108, ' 1لفة خرطوم غسيل 4/3 بوصة 1 تيلة', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600026', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(109, 'كاوتشة ميزان اسمنت', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400013', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(110, 'كاوتشة ميزان مياه', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400014', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(111, 'كاوتشة ميزان مادة', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400015', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(112, 'رجل بنطلون اسمنت', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400016', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(113, 'سليكون حرارى', 'each', NULL, NULL, NULL, NULL, NULL, 0, 6, NULL, 'GN6600002', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(114, 'سليكون شفاف', 'each', NULL, NULL, NULL, NULL, NULL, 0, 6, NULL, 'GN6600003', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(115, 'سلك لحام 2*1', 'kg', NULL, NULL, NULL, NULL, NULL, 0, 6, NULL, 'GN6600004', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(116, 'لودسيل 1 طن', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600027', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(117, 'طقم حشو اكس', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400017', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(118, 'كفة ميكسر', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400018', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(119, 'كرسى جنب', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400019', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(120, 'بلية مجموعة', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400020', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(121, 'بلى موتور', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400021', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(122, 'لودسيل 5 طن', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400022', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(123, 'كلبس كهربائى وسط', 'each', NULL, NULL, NULL, NULL, NULL, 0, 4, NULL, 'ELC4400016', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(124, 'كلبس كهربائى صغير', 'each', NULL, NULL, NULL, NULL, NULL, 0, 4, NULL, 'ELC4400017', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(125, 'كلبس كهربائى عمومى كبير', 'each', NULL, NULL, NULL, NULL, NULL, 0, 4, NULL, 'ELC4400018', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(126, 'ترامل 13', 'each', NULL, NULL, NULL, NULL, NULL, 0, 4, NULL, 'ELC4400019', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(127, 'ترامل 10', 'each', NULL, NULL, NULL, NULL, NULL, 0, 4, NULL, 'ELC4400020', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(128, 'كارت فيوز ايطالى', 'each', NULL, NULL, NULL, NULL, NULL, 0, 4, NULL, 'ELC4400021', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(129, 'كاوتش 3مم', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600028', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(130, 'مفتاح النكيه 7 مم', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600029', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(131, 'سليكون عضم', 'each', NULL, NULL, NULL, NULL, NULL, 0, 6, NULL, 'GN6600005', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(132, 'مسدس سليكون', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600030', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(133, 'كوليه 14 بوصة', 'each', NULL, NULL, NULL, NULL, NULL, 0, 9, NULL, 'PM9900016', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(134, 'كوليه 16 بوصة', 'each', NULL, NULL, NULL, NULL, NULL, 0, 9, NULL, 'PM9900017', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(135, 'وصلة هواء 0.5\" / 12 مم كوعة', 'each', NULL, NULL, NULL, NULL, NULL, 0, 9, NULL, 'PM9900018', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(136, 'وصلة هواء 0.5\" / 10 مم كوعة', 'each', NULL, NULL, NULL, NULL, NULL, 0, 9, NULL, 'PM9900019', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(137, '7*110*90 اولسيه', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400023', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(138, 'ميزان مياه', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600031', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(139, 'مفك تيست', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600032', NULL, '2022-12-19 08:21:16', '2022-12-19 08:21:16'),
(140, 'محبس 1.5\"', 'each', NULL, NULL, NULL, NULL, NULL, 0, 9, NULL, 'PM9900020', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(141, 'بك تشحيم', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600033', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(142, 'فلتر نص بوصة واحد كباية طراز المانى', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400024', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(143, 'وصلة عدلة نص بوصة /10', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400025', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(144, 'افيز فيشر 1 \"', 'each', NULL, NULL, NULL, NULL, NULL, 0, 9, NULL, 'PM9900021', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(145, 'مفتاح اوتوماتيك 380 فولت', 'each', NULL, NULL, NULL, NULL, NULL, 0, 4, NULL, 'ELC4400022', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(146, 'عداد هواء 4/1', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600034', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(147, 'وصلة ميكانيكا تمن *6', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600035', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(148, 'وصلة ميكانيكا داخلى تمن *6', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600036', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(149, 'خرطوم هواء حرارى 6مم', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400026', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(150, 'كاوتش 10مم بدون تيلة', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400027', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(151, 'بلاستيك شفاف 2000 ميكرون', 'kg', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400028', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(152, 'بلف طلمبة هيدروليك', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400029', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(153, 'سير شيفرون 80 سم', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400030', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(154, 'مسمار جاكسون هندى', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400031', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(155, 'مفتاح كلبسات جاكسون', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600037', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(156, 'فلانشة 6\" لحام 8 مللى', 'each', NULL, NULL, NULL, NULL, NULL, 0, 9, NULL, 'PM9900022', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(157, 'كوع 4 \"لحام جدول 20', 'each', NULL, NULL, NULL, NULL, NULL, 0, 9, NULL, 'PM9900023', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(158, 'ماسورة سيملس  5\"جدول 40', 'each', NULL, NULL, NULL, NULL, NULL, 0, 9, NULL, 'PM9900024', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(159, 'كوع 90 دبل كبير', 'each', NULL, NULL, NULL, NULL, NULL, 0, 15, NULL, 'SP2400096', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(160, 'جوان خط مانع تسريب 5.5', 'each', NULL, NULL, NULL, NULL, NULL, 0, 15, NULL, 'SP2400097', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(161, 'فلانشة حديد 5.5', 'each', NULL, NULL, NULL, NULL, NULL, 0, 15, NULL, 'SP2400098', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(162, 'كرة نظافة 5.5', 'each', NULL, NULL, NULL, NULL, NULL, 0, 15, NULL, 'SP2400099', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(163, 'افيز عادة بمقبض 5.5', 'each', NULL, NULL, NULL, NULL, NULL, 0, 15, NULL, 'SP2400100', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(164, 'ماسورة بامب حديد 3م تركى', 'each', NULL, NULL, NULL, NULL, NULL, 0, 15, NULL, 'SP2400101', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(165, 'فلتر سيرماك رقم ( 2091022)', 'each', NULL, NULL, NULL, NULL, NULL, 0, 15, NULL, 'SP2400102', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(166, 'خرطوم 3/8  2سلكة *2جلبة', 'each', NULL, NULL, NULL, NULL, NULL, 0, 15, NULL, 'SP2400103', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(167, 'كوع 90 قصير', 'each', NULL, NULL, NULL, NULL, NULL, 0, 15, NULL, 'SP2400104', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(168, 'كنترول MR اكسور', 'each', NULL, NULL, NULL, NULL, NULL, 0, 15, NULL, 'SP2400105', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(169, 'بنز بوز جاز اكسور', 'each', NULL, NULL, NULL, NULL, NULL, 0, 15, NULL, 'SP2400106', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(170, 'وحدة حقن', 'each', NULL, NULL, NULL, NULL, NULL, 0, 15, NULL, 'SP2400107', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(171, 'ماسورة بامب حديد 3م صينى', 'each', NULL, NULL, NULL, NULL, NULL, 0, 15, NULL, 'SP2400108', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(172, 'سكس بلف اكتروس كامل بالفلتر ', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400032', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(173, 'حشو فلتر زيت اكتروس', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400033', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(174, 'حشو فلتر جاز اكتروس', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400034', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(175, 'حشو فلتر زيت اكسور', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400035', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(176, 'فلتر مجفف هواء اكتروس', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400036', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(177, 'حشو فلتر زيت دريكسيون ( فلتر باور)', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400037', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(178, 'فلتر فاصل مياه بالكوباية', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400038', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(179, 'طقم اصلا جهاز فرامل', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400039', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(180, 'جلبة كرنك خلفى اكتروس', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400040', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(181, 'علبة زيت بانتوسيم', 'each', NULL, NULL, NULL, NULL, NULL, 0, 5, NULL, 'FO5500011', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(182, 'اسطوانة دبرياج 43سم سن ناعم', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400041', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(183, 'مسمار عجل خلفى طويل بالصامولة', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400042', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(184, 'كاركة جاز بالكوباية', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400043', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(185, 'ماكينة باور دريكسيون', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400044', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(186, 'طقم تيل فرامل خلفى اكتروس', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400045', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(187, 'طقم تيل فرامل امامى اكتروس', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400046', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(188, 'طقم اصلاح حشو طلمبة مياه', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400047', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(189, 'مزيل صدا', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400048', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(190, 'سير اكسور 9PK2295', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400049', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(191, '9PK2871   سير دينامو اكسور', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400050', NULL, '2022-12-19 08:21:17', '2022-12-27 09:45:18'),
(192, 'سير دينامو اكتروس 8PK1612', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400051', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(193, 'منظف ادوات كهربائية', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400052', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(194, 'عمة تبخير', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400053', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(195, 'بلية شداد المانى 58813 الخلاطة الاكسور', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400054', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(196, 'واير حلة 6م و 6.5م', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400055', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(197, 'بكرة حلة ', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400056', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(198, 'دراع حلة', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400057', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(199, 'فتيل مزراب', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400058', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(200, 'جنط حديد', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400059', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(201, 'طقم الانكيه عاده', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600038', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(202, 'خرطوم مشحمة ', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400060', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(203, 'علبة فوم', 'each', NULL, NULL, NULL, NULL, NULL, 0, 6, NULL, 'GN6600006', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(204, 'نبل 27/32', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400061', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(205, 'وصلة هواء عدلة 12/10', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400062', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(206, 'وصلة هواء عدلة 10/10', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400063', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(207, 'وصلة متلت 12 مم', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400064', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(208, 'وصلة متلت 10 مم', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400065', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(209, 'وصلة متلت 6 مم', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400066', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(210, 'خرطوم هواء 6 مم', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600039', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(211, 'خرطوم هواء 8 مم', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600040', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(212, 'خرطوم هواء 10 مم', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600041', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(213, 'خرطوم هواء 12 مم', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600042', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(214, 'طقم اوطاش بطارية نحاس', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600043', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(215, 'خرطوم دريكسيون ايطالى', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400067', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(216, 'بطارية 150 امبير', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400068', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(217, 'رولمان بلى عريض', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400069', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(218, 'اويل سيل كرنك خلفى', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400070', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(219, 'سيرفو دبرياج خلفى', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400071', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(220, 'طقم تيل امامى دى مكس', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400072', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(221, 'طقم تيل خلفى دى مكس', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400073', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(222, 'فلتر زيت دى مكس دبابة', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400074', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(223, 'فلتر جاز دى مكس دبابة', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400075', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(224, 'فلتر هواء دى مكس دبابة', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400076', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(225, 'لاكور تزويد كاوتش', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400077', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(226, 'دونجل دريكسيون دوبل مرسيدس', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400078', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(227, 'مروحة 8 ريشة', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400079', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(228, '9PK2835  سير اكتروس', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400080', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(229, 'كاوتشة انتركولر اكتروس ', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400081', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(230, 'بلف فرامل يد مخفض كهربااكسور استيراد', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400082', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(231, 'طلمبة باور دريكسيون اكسور استيراد المانى', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400083', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(232, 'وصلة هواء عدلة 6/6', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400084', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(233, 'وصلة هواء عدلة 10/8', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400085', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(234, 'دراع نور واشارات اكتروس تراك تك المانى', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400086', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(235, 'كنترول GM كونتيننتال', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400087', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(236, 'طقم جوان كمبروسر اكتروس', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400088', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(237, 'قربة مياه اكسور', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400089', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(238, 'ماسورة كمبروسر اكسور', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400090', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(239, 'قفيز حلة 20مم/ 25سم', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400091', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(240, 'مروحة تبريد سربنتينة', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400092', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(241, 'قفيز مرسيدس امامى 25سم', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400093', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(242, 'طلمبة مياه اكسور تركى', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400094', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(243, 'حجر قطعية 9\"', 'each', NULL, NULL, NULL, NULL, NULL, 0, 6, NULL, 'GN6600007', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(244, 'حجر بسكوتة كبير', 'each', NULL, NULL, NULL, NULL, NULL, 0, 6, NULL, 'GN6600008', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(245, 'حجر جلخ', 'each', NULL, NULL, NULL, NULL, NULL, 0, 6, NULL, 'GN6600009', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(246, 'شاكوش 1.5 ك', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600044', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(247, 'زرجينة 60سم اسبانى', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600045', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(248, 'لوح صاج بقلاوة 150*300سم 3مم', 'sheet', NULL, NULL, NULL, NULL, NULL, 0, 6, NULL, 'GN6600010', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(249, 'لوح صاج 3مم', 'sheet', NULL, NULL, NULL, NULL, NULL, 0, 6, NULL, 'GN6600011', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(250, 'باكو سلك لحام 3مم', 'kg', NULL, NULL, NULL, NULL, NULL, 0, 6, NULL, 'GN6600012', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(251, 'مسمار 13 بالصامولة والوردة', 'kg', NULL, NULL, NULL, NULL, NULL, 0, 6, NULL, 'GN6600013', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(252, 'مسمار 17 بالصامولة والوردة', 'kg', NULL, NULL, NULL, NULL, NULL, 0, 6, NULL, 'GN6600014', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(253, 'مسمار 19 بالصامولة والوردة', 'kg', NULL, NULL, NULL, NULL, NULL, 0, 6, NULL, 'GN6600015', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(254, 'بنسة لحام A800', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600046', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(255, 'لقمة 10 مم', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600047', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(256, 'ماكينة لحام 200 امبير', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600048', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(257, 'حجر بسكوتة صغير', 'each', NULL, NULL, NULL, NULL, NULL, 0, 6, NULL, 'GN6600016', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(258, 'حجر قطعية صغير', 'each', NULL, NULL, NULL, NULL, NULL, 0, 6, NULL, 'GN6600017', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(259, 'كاتر بلاستيك', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600049', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(260, 'علبة سلاح كاتر', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600050', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(261, 'ازاز اسود لحام', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600051', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(262, 'علبة طباشير لحام', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600052', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(263, 'سلك شبك', 'roll', NULL, NULL, NULL, NULL, NULL, 0, 6, NULL, 'GN6600018', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(264, 'شيكارة جبس', 'each', NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, 'BM1100001', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(265, 'حنفية 0.5\"', 'each', NULL, NULL, NULL, NULL, NULL, 0, 9, NULL, 'PM9900025', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(266, 'مسمار 24', 'kg', NULL, NULL, NULL, NULL, NULL, 0, 6, NULL, 'GN6600019', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(267, 'مسمار 14*6 سم بالصامولة والوردة', 'kg', NULL, NULL, NULL, NULL, NULL, 0, 6, NULL, 'GN6600020', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(268, 'عود نحاس لحام اكسجين', 'kg', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600053', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(269, 'علبة بودرة', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600054', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(270, 'مسمار صلب 14*50مم', 'kg', NULL, NULL, NULL, NULL, NULL, 0, 6, NULL, 'GN6600021', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(271, 'مسمار تك 5سم', 'kg', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600055', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(272, 'مزراب خلاطة +بلتة 50*50', 'each', NULL, NULL, NULL, NULL, NULL, 0, 14, NULL, 'SP2400095', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(273, 'صاج 1.5*3م*4مم', 'sheet', NULL, NULL, NULL, NULL, NULL, 0, 6, NULL, 'GN6600022', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(274, 'صاج 1.5*3م*3مم', 'sheet', NULL, NULL, NULL, NULL, NULL, 0, 6, NULL, 'GN6600023', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(275, 'مسمار خشابى 6سم', 'kg', NULL, NULL, NULL, NULL, NULL, 0, 6, NULL, 'GN6600024', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(276, 'مادة نظافة خلاطات ( مياه نار )', 'litter', NULL, NULL, NULL, NULL, NULL, 0, 6, NULL, 'GN6600025', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(277, 'ورقة ايه 4', 'each', NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, 'ST2500001', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(278, 'قلم جاف ازرق', 'each', NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, 'ST2500002', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(279, 'مسطرة معدن', 'each', NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, 'ST2500003', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(280, 'قلم كوريكتور', 'each', NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, 'ST2500004', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(281, 'حافظة حرف يو', 'each', NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, 'ST2500005', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(282, 'دبوس مكتب', 'each', NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, 'ST2500006', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(283, 'اكلاسيه كمبيالة', 'each', NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, 'ST2500007', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(284, 'دفتر 12 خانة', 'each', NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, 'ST2500008', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(285, 'اقلام ماركر', 'each', NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, 'ST2500009', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(286, 'كابل طابعة', 'each', NULL, NULL, NULL, NULL, NULL, 0, 10, NULL, 'IT2200003', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(287, 'بلاور', 'each', NULL, NULL, NULL, NULL, NULL, 0, 17, NULL, 'TL2600056', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(288, 'دفتر امر انتاج', 'each', NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, 'ST2500010', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(289, 'دفتر سند استلام خرسانة', 'each', NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, 'ST2500011', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(290, 'دفتر جدول صب', 'each', NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, 'ST2500012', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(291, 'دفتر ايصال استلام نقدية', 'each', NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, 'ST2500013', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(292, 'دفتر ايصال صرف نقدية', 'each', NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, 'ST2500014', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(293, 'دفتر كارتة صنف ', 'each', NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, 'ST2500015', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(294, 'دفتر طلب شراء', 'each', NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, 'ST2500016', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(295, 'دفتر استلام عهدة مخزن', 'each', NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, 'ST2500017', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(296, 'دفتر اذن صرف خامات', 'each', NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, 'ST2500018', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(297, 'دفتر اشعار خصم', 'each', NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, 'ST2500019', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(298, 'دفتر اذن اضافة خرسانة', 'each', NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, 'ST2500020', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(299, 'دفتر اذن مرتجع', 'each', NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, 'ST2500021', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(300, 'دفتر محضر فحص', 'each', NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, 'ST2500022', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(301, 'دفتر محضر تكعيب', 'each', NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, 'ST2500023', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(302, 'اكلاسيه 8 سم', 'each', NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, 'ST2500024', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(303, 'خلاعة دبابيس', 'each', NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, 'ST2500025', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(304, 'بلانشيتة خشب', 'each', NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, 'ST2500026', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(305, 'ختم ضريبى', 'each', NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, 'ST2500027', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(306, 'ختم مالية', 'each', NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, 'ST2500028', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(307, 'ختم عادى', 'each', NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, 'ST2500029', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(308, 'ختم جودة', 'each', NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, 'ST2500030', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(309, 'ختم مخازن', 'each', NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, 'ST2500031', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(310, 'علبة قلم رصاص', 'each', NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, 'ST2500032', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(311, 'علبة قلم ازرق بريمو', 'each', NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, 'ST2500033', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(312, 'دفتر اذن محدد المدة', 'each', NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, 'ST2500034', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(313, 'دفتر تصريح دخول وخروج', 'each', NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, 'ST2500035', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(314, 'دفتر تصريح القيام بمامورية', 'each', NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, 'ST2500036', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(315, 'دفتر طلب اجازة', 'each', NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, 'ST2500037', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(316, 'دفتر اضافة خامات', 'each', NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, 'ST2500038', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(317, 'شاحن Dell', 'each', NULL, NULL, NULL, NULL, NULL, 0, 2, NULL, 'IT2200001', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(318, 'مشترك كهربا 5 عين', 'each', NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, 'ST2500039', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(319, 'ماوس HB', 'each', NULL, NULL, NULL, NULL, NULL, 0, 2, NULL, 'IT2200002', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(320, 'سويتش نت ', 'each', NULL, NULL, NULL, NULL, NULL, 0, 7, NULL, 'NET7700001', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17'),
(321, 'اسمنت معباء', 'each', NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, 'BM1100002', NULL, '2022-12-19 08:21:17', '2022-12-19 08:21:17');

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

--
-- Table structure for table `product_purchase`
--

CREATE TABLE `product_purchase` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `purchase_id` bigint(20) UNSIGNED DEFAULT NULL,
  `vendor_id` bigint(20) UNSIGNED DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `price` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `measuring_unit` enum('each','kg','litter','littre','m/l','m3','roll','sheet','ton') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantity` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `current_quantity` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `left` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `actual_quantity` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tax` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vat` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `total` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_purchase`
--

INSERT INTO `product_purchase` (`id`, `product_id`, `purchase_id`, `vendor_id`, `user_id`, `price`, `measuring_unit`, `quantity`, `current_quantity`, `left`, `actual_quantity`, `tax`, `vat`, `total`, `deleted_at`, `created_at`, `updated_at`) VALUES
(2, 4, 1, 1, 1, NULL, 'm3', '25', '25', '0', NULL, NULL, NULL, NULL, NULL, '2022-12-21 06:19:05', '2022-12-25 13:21:25'),
(4, 2, 2, 1, NULL, NULL, 'ton', '300', '300', '0', '300', NULL, NULL, NULL, NULL, '2022-12-25 14:43:04', '2022-12-27 09:15:04'),
(8, 19, 3, 1, NULL, NULL, 'each', '200', '200', '0', NULL, NULL, NULL, NULL, NULL, '2022-12-27 09:24:44', '2022-12-27 09:25:45'),
(9, 15, 3, 1, NULL, NULL, 'each', '300', '300', '0', NULL, NULL, NULL, NULL, NULL, '2022-12-27 09:24:44', '2022-12-27 09:25:25'),
(10, 18, 3, 1, NULL, NULL, 'each', '500', '500', '0', NULL, NULL, NULL, NULL, NULL, '2022-12-27 09:24:44', '2022-12-27 09:25:02'),
(14, 191, 4, 1, NULL, NULL, 'each', '600', '600', '0', '600', NULL, NULL, NULL, NULL, '2022-12-27 09:40:05', '2022-12-27 09:48:24'),
(15, 13, 4, 1, NULL, NULL, 'm3', '25', '25', '0', '25', NULL, NULL, NULL, NULL, '2022-12-27 09:40:05', '2022-12-27 09:48:24'),
(16, 67, 4, 1, NULL, NULL, 'each', '15', '15', '0', '15', NULL, NULL, NULL, NULL, '2022-12-27 09:40:05', '2022-12-27 09:48:24'),
(18, 36, 5, 1, NULL, NULL, 'each', '350', '350', '0', '350', NULL, NULL, NULL, NULL, '2022-12-27 10:07:41', '2022-12-27 10:09:29'),
(20, 1, 6, 1, NULL, NULL, 'ton', '1000', '1000', '0', '1000', NULL, NULL, NULL, NULL, '2023-01-01 08:01:21', '2023-01-01 08:02:42'),
(22, 32, 7, 1, NULL, NULL, 'each', '100', '100', '0', '100', NULL, NULL, NULL, NULL, '2023-01-01 12:18:03', '2023-01-01 12:19:16'),
(24, 31, 8, 1, NULL, NULL, 'each', '800', '800', '0', '800', NULL, NULL, NULL, NULL, '2023-01-01 12:21:09', '2023-01-01 12:22:49');

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

--
-- Table structure for table `product_sales`
--

CREATE TABLE `product_sales` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `sales_id` bigint(20) UNSIGNED NOT NULL,
  `unit_price` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `measuring_unit` enum('meter','liter','kilo','unit','ton') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantity` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_pefor_tax` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tax` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `discount` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `purchases`
--

CREATE TABLE `purchases` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `department_id` bigint(20) UNSIGNED DEFAULT NULL,
  `inventory_id` bigint(20) UNSIGNED DEFAULT NULL,
  `vendor_id` bigint(20) UNSIGNED DEFAULT NULL,
  `currency_id` bigint(20) UNSIGNED DEFAULT NULL,
  `driver_name` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `car_number` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `policy_number` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('orderd','pending','in-progress','received','in-stock','completed') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'orderd',
  `is_needed` enum('0','1') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `in_inventory` enum('0','1') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `purchases`
--

INSERT INTO `purchases` (`id`, `department_id`, `inventory_id`, `vendor_id`, `currency_id`, `driver_name`, `car_number`, `policy_number`, `date`, `status`, `is_needed`, `in_inventory`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 1, NULL, NULL, NULL, NULL, NULL, NULL, '2022-12-21', 'completed', '1', '0', NULL, '2022-12-21 06:18:55', '2022-12-25 13:21:25'),
(2, 1, NULL, NULL, NULL, NULL, NULL, NULL, '2022-12-25', 'completed', '1', '0', NULL, '2022-12-25 14:43:00', '2022-12-27 09:13:50'),
(3, 4, NULL, NULL, NULL, NULL, NULL, NULL, '2022-12-27', 'completed', '1', '0', NULL, '2022-12-27 09:24:34', '2022-12-27 09:25:46'),
(4, 3, NULL, NULL, NULL, NULL, NULL, NULL, '2022-12-28', 'completed', '1', '0', NULL, '2022-12-27 09:39:59', '2022-12-27 09:44:56'),
(5, 4, NULL, NULL, NULL, NULL, NULL, NULL, '2022-12-29', 'completed', '1', '0', NULL, '2022-12-27 10:07:38', '2022-12-27 10:07:56'),
(6, 3, NULL, NULL, NULL, NULL, NULL, NULL, '2023-01-01', 'completed', '1', '0', NULL, '2023-01-01 08:01:17', '2023-01-01 08:01:46'),
(7, 4, NULL, NULL, NULL, NULL, NULL, NULL, '2023-01-02', 'completed', '1', '0', NULL, '2023-01-01 12:17:59', '2023-01-01 12:18:24'),
(8, 4, NULL, NULL, NULL, NULL, NULL, NULL, '2023-01-02', 'completed', '1', '0', NULL, '2023-01-01 12:21:02', '2023-01-01 12:21:33');

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

--
-- Table structure for table `receipt_vouchers`
--

CREATE TABLE `receipt_vouchers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `customer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `date` date DEFAULT NULL,
  `status` enum('pending','confirmed') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `display_name`, `description`, `created_at`, `updated_at`) VALUES
(1, 'Admin', 'Admin', 'Admin', '2022-12-19 05:41:06', '2022-12-19 05:41:06'),
(2, 'Inventory Management', 'Inventory Management', 'Inventory Management', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(3, 'Purchase Management', 'Purchase Management', 'Purchase Management', '2022-12-19 05:41:07', '2022-12-19 05:41:07'),
(4, 'Account Management', 'Account Management', 'Account Management', '2022-12-19 05:41:07', '2022-12-19 05:41:07');

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

--
-- Table structure for table `role_user`
--

CREATE TABLE `role_user` (
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `user_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_user`
--

INSERT INTO `role_user` (`role_id`, `user_id`, `user_type`) VALUES
(1, 1, 'App\\Models\\User');

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

--
-- Table structure for table `sales`
--

CREATE TABLE `sales` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `customer_id` bigint(20) UNSIGNED NOT NULL,
  `account_invoice_id` bigint(20) UNSIGNED DEFAULT NULL,
  `customer_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('quotation','order','pre-process','delivered','paid','not-paid') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'quotation',
  `is_confirmed` int(11) NOT NULL DEFAULT 0,
  `note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sales`
--

INSERT INTO `sales` (`id`, `customer_id`, `account_invoice_id`, `customer_name`, `customer_phone`, `date`, `status`, `is_confirmed`, `note`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 1, 4, 'Customer 1', '12345678910', '2023-01-01', 'delivered', 1, NULL, NULL, '2023-01-01 08:04:52', '2023-01-01 08:05:05'),
(2, 1, 7, 'Customer 1', '12345678910', '2023-01-02', 'delivered', 1, NULL, NULL, '2023-01-01 12:23:15', '2023-01-01 12:23:31');

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

--
-- Table structure for table `sales_invoices`
--

CREATE TABLE `sales_invoices` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `customer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `sales_id` bigint(20) UNSIGNED DEFAULT NULL,
  `receipt_voucher_id` bigint(20) UNSIGNED DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `date` date DEFAULT NULL,
  `status` enum('paid','unpaid') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'unpaid',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `condition` enum('confirmed','unconfirmed') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'unconfirmed'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `key`, `value`, `created_at`, `updated_at`) VALUES
(1, 'AccountCustomer', '', '2022-12-19 05:41:08', '2022-12-19 05:41:08'),
(2, 'AccountVendor', '', '2022-12-19 05:41:08', '2022-12-19 05:41:08'),
(3, 'AccountPurchase', '', '2022-12-19 05:41:08', '2022-12-19 05:41:08'),
(4, 'AccountInventory', '', '2022-12-19 05:41:08', '2022-12-19 05:41:08'),
(5, 'AccountSales', '', '2022-12-19 05:41:08', '2022-12-19 05:41:08'),
(6, 'DiscountAndExtraTaxesAccount', '', '2022-12-19 05:41:08', '2022-12-19 05:41:08'),
(7, 'ValueAddedTaxesAccount', '', '2022-12-19 05:41:08', '2022-12-19 05:41:08'),
(8, 'AccountTreasury', '', '2022-12-19 05:41:08', '2022-12-19 05:41:08'),
(9, 'AccountChequeVendor', '', '2022-12-19 05:41:08', '2022-12-19 05:41:08'),
(10, 'AccountChequeCustomer', '', '2022-12-19 05:41:08', '2022-12-19 05:41:08'),
(11, 'AccountBank', '', '2022-12-19 05:41:08', '2022-12-19 05:41:08');

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

--
-- Table structure for table `supply_orders`
--

CREATE TABLE `supply_orders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `purchase_id` bigint(20) UNSIGNED DEFAULT NULL,
  `product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `vendor_id` bigint(20) UNSIGNED DEFAULT NULL,
  `inventory_id` bigint(20) UNSIGNED DEFAULT NULL,
  `status` enum('in-progress','completed','rejected') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantity` double DEFAULT NULL,
  `price` double DEFAULT NULL,
  `tax` double DEFAULT NULL,
  `vat` double DEFAULT NULL,
  `total` double DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `supply_orders`
--

INSERT INTO `supply_orders` (`id`, `purchase_id`, `product_id`, `vendor_id`, `inventory_id`, `status`, `quantity`, `price`, `tax`, `vat`, `total`, `created_at`, `updated_at`) VALUES
(1, 1, 4, 1, 1, 'completed', 25, 5000, 10, 14, 155000, '2022-12-25 13:21:24', '2022-12-27 09:23:30'),
(2, 2, 2, 1, 1, 'completed', 300, 1500, 10, 14, 558000, '2022-12-27 09:13:50', '2022-12-27 09:22:59'),
(3, 3, 18, 1, 1, 'in-progress', 500, 2051, 10, 14, 1271620, '2022-12-27 09:25:02', '2022-12-27 09:25:02'),
(4, 3, 15, 1, 1, 'in-progress', 300, 258, 10, 14, 95976, '2022-12-27 09:25:25', '2022-12-27 09:25:25'),
(5, 3, 19, 1, 1, 'in-progress', 200, 6354, 10, 14, 1575792, '2022-12-27 09:25:45', '2022-12-27 09:25:45'),
(6, 4, 191, 1, 1, 'in-progress', 600, 250000, 10, 14, 186000000, '2022-12-27 09:44:32', '2022-12-27 09:44:32'),
(7, 4, 67, 1, 1, 'in-progress', 15, 20, 10, 14, 372, '2022-12-27 09:44:44', '2022-12-27 09:44:44'),
(8, 4, 13, 1, 1, 'completed', 25, 15000, 10, 14, 465000, '2022-12-27 09:44:56', '2022-12-27 09:45:18'),
(9, 5, 36, 1, 1, 'completed', 350, 1500, 10, 14, 651000, '2022-12-27 10:07:56', '2022-12-27 10:26:13'),
(10, 6, 1, 1, 1, 'in-progress', 1000, 500, 10, 14, 620000, '2023-01-01 08:01:46', '2023-01-01 08:01:46'),
(11, 7, 32, 1, 1, 'in-progress', 100, 1500, 10, 14, 186000, '2023-01-01 12:18:23', '2023-01-01 12:18:23'),
(12, 8, 31, 1, 1, 'in-progress', 800, 2000, 10, 14, 1984000, '2023-01-01 12:21:33', '2023-01-01 12:21:33');

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

--
-- Table structure for table `taxes`
--

CREATE TABLE `taxes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` double NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `type` enum('tax','vat') COLLATE utf8mb4_unicode_ci NOT NULL,
  `record_type` enum('credit','debit') COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `taxes`
--

INSERT INTO `taxes` (`id`, `name`, `value`, `description`, `created_at`, `updated_at`, `type`, `record_type`) VALUES
(1, 'TAX 10', 10, 'Tax 10%', '2022-12-25 13:19:45', '2022-12-25 13:19:45', 'tax', 'credit'),
(2, 'VAT 14', 14, 'VAT 14', '2022-12-25 13:20:01', '2022-12-25 13:20:01', 'vat', 'credit');

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

--
-- Table structure for table `tax_vendor`
--

CREATE TABLE `tax_vendor` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tax_id` bigint(20) UNSIGNED DEFAULT NULL,
  `vendor_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tax_vendor`
--

INSERT INTO `tax_vendor` (`id`, `tax_id`, `vendor_id`, `created_at`, `updated_at`) VALUES
(3, 1, 1, NULL, NULL),
(4, 2, 1, NULL, NULL);

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

--
-- Table structure for table `transaction_stocks`
--

CREATE TABLE `transaction_stocks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `exchange_id` bigint(20) UNSIGNED DEFAULT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `quantity` int(11) NOT NULL,
  `measuring_unit` enum('each','kg','litter','littre','m/l','m3','roll','sheet','ton') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_valid` enum('0','1') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `transaction_stocks`
--

INSERT INTO `transaction_stocks` (`id`, `exchange_id`, `product_id`, `quantity`, `measuring_unit`, `is_valid`, `note`, `created_at`, `updated_at`) VALUES
(1, 1, 2, 300, 'ton', '0', NULL, '2022-12-27 09:22:59', '2022-12-27 09:22:59'),
(2, 2, 4, 25, 'm3', '0', NULL, '2022-12-27 09:23:30', '2022-12-27 09:23:30'),
(3, 3, 13, 25, 'm3', '0', NULL, '2022-12-27 09:45:13', '2022-12-27 09:45:13'),
(4, 3, 67, 15, 'each', '0', NULL, '2022-12-27 09:45:16', '2022-12-27 09:45:16'),
(5, 3, 191, 600, 'each', '0', NULL, '2022-12-27 09:45:18', '2022-12-27 09:45:18'),
(6, 4, 36, 350, 'each', '0', NULL, '2022-12-27 10:26:13', '2022-12-27 10:26:13'),
(7, 5, 4, 10, 'kg', '1', NULL, '2022-12-28 08:58:42', '2022-12-28 08:58:42'),
(8, 6, 4, 15, 'kg', '1', NULL, '2022-12-28 10:20:58', '2022-12-28 10:20:58');

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

--
-- Table structure for table `treasuries`
--

CREATE TABLE `treasuries` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` double DEFAULT NULL,
  `serial` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency_id` bigint(20) UNSIGNED DEFAULT NULL,
  `account_id` bigint(20) UNSIGNED DEFAULT NULL,
  `parent_id` bigint(20) UNSIGNED DEFAULT NULL,
  `branch` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `limitation` double NOT NULL,
  `type` enum('vendor','salaries','loans','rewards','taxes','insurances','general') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `treasuries`
--

INSERT INTO `treasuries` (`id`, `name`, `amount`, `serial`, `currency_id`, `account_id`, `parent_id`, `branch`, `limitation`, `type`, `created_at`, `updated_at`) VALUES
(1, 'خزينة 1', 15000, '123', 2, 2, NULL, 'العاصمة', 50000, NULL, '2022-12-27 10:18:12', '2022-12-27 10:18:12');

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

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

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` enum('admin','employee') COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `account_employee_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `type`, `created_by`, `remember_token`, `created_at`, `updated_at`, `account_employee_no`) VALUES
(1, 'superAdmin', 'admin@admin.com', NULL, '$2y$10$AQ56cY7pGS3eDrlB7/TEXeO9ps0bpdCWi9cjYFg6S3dWMe8Ome/Xu', 'admin', NULL, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `vendors`
--

CREATE TABLE `vendors` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `type` enum('individual','company') COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `website` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tax_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `account_vendor_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `commerical_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `company_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_owner` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_activity` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `vendors`
--

INSERT INTO `vendors` (`id`, `type`, `name`, `email`, `phone`, `address`, `website`, `tax_id`, `deleted_at`, `created_at`, `updated_at`, `account_vendor_no`, `commerical_id`, `company_name`, `company_owner`, `company_activity`) VALUES
(1, 'individual', 'Vendor 1', 'email@email.com', '01123254421', 'address 1', 'website.com', '1', NULL, '2022-12-19 05:41:08', '2022-12-25 13:20:49', NULL, '456', NULL, NULL, NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `accounts`
--
ALTER TABLE `accounts`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `accounts_code_unique` (`code`),
  ADD KEY `accounts_parent_id_foreign` (`parent_id`),
  ADD KEY `accounts_list_account_id_foreign` (`list_account_id`),
  ADD KEY `accounts_vendor_id_foreign` (`vendor_id`);

--
-- Indexes for table `account_financials`
--
ALTER TABLE `account_financials`
  ADD PRIMARY KEY (`id`),
  ADD KEY `account_financials_account_id_foreign` (`account_id`),
  ADD KEY `account_financials_financial_id_foreign` (`financial_id`);

--
-- Indexes for table `account_invoices`
--
ALTER TABLE `account_invoices`
  ADD PRIMARY KEY (`id`),
  ADD KEY `account_invoices_user_id_foreign` (`user_id`),
  ADD KEY `account_invoices_vendor_id_foreign` (`vendor_id`),
  ADD KEY `account_invoices_customer_id_foreign` (`customer_id`),
  ADD KEY `account_invoices_general_exchange_id_foreign` (`general_exchange_id`),
  ADD KEY `account_invoices_cost_center_id_foreign` (`cost_center_id`);

--
-- Indexes for table `account_invoice_product`
--
ALTER TABLE `account_invoice_product`
  ADD PRIMARY KEY (`id`),
  ADD KEY `account_invoice_product_product_id_foreign` (`product_id`),
  ADD KEY `account_invoice_product_final_product_id_foreign` (`final_product_id`),
  ADD KEY `account_invoice_product_account_invoice_id_foreign` (`account_invoice_id`),
  ADD KEY `account_invoice_product_account_id_foreign` (`account_id`);

--
-- Indexes for table `account_invoice_tax`
--
ALTER TABLE `account_invoice_tax`
  ADD PRIMARY KEY (`id`),
  ADD KEY `account_invoice_tax_tax_id_foreign` (`tax_id`),
  ADD KEY `account_invoice_tax_account_invoice_id_foreign` (`account_invoice_id`);

--
-- Indexes for table `account_ledgers`
--
ALTER TABLE `account_ledgers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `account_ledgers_ledger_id_foreign` (`ledger_id`),
  ADD KEY `account_ledgers_account_id_foreign` (`account_id`),
  ADD KEY `account_ledgers_cost_center_id_foreign` (`cost_center_id`);

--
-- Indexes for table `account_tax`
--
ALTER TABLE `account_tax`
  ADD PRIMARY KEY (`id`),
  ADD KEY `account_tax_account_id_foreign` (`account_id`),
  ADD KEY `account_tax_tax_id_foreign` (`tax_id`);

--
-- Indexes for table `assets`
--
ALTER TABLE `assets`
  ADD PRIMARY KEY (`id`),
  ADD KEY `assets_cost_center_id_foreign` (`cost_center_id`),
  ADD KEY `assets_asset_category_id_foreign` (`asset_category_id`),
  ADD KEY `assets_vendor_id_foreign` (`vendor_id`);

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

--
-- Indexes for table `asset_vendors`
--
ALTER TABLE `asset_vendors`
  ADD PRIMARY KEY (`id`),
  ADD KEY `asset_vendors_asset_id_foreign` (`asset_id`),
  ADD KEY `asset_vendors_vendor_id_foreign` (`vendor_id`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `categories_name_unique` (`name`);

--
-- Indexes for table `cheque_keepers`
--
ALTER TABLE `cheque_keepers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cheque_keepers_exchange_permission_id_foreign` (`exchange_permission_id`);

--
-- Indexes for table `cost_centers`
--
ALTER TABLE `cost_centers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `cost_centers_name_unique` (`name`),
  ADD UNIQUE KEY `cost_centers_code_unique` (`code`),
  ADD KEY `cost_centers_parent_id_foreign` (`parent_id`);

--
-- Indexes for table `cost_center_product`
--
ALTER TABLE `cost_center_product`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cost_center_product_cost_center_id_foreign` (`cost_center_id`),
  ADD KEY `cost_center_product_product_id_foreign` (`product_id`);

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

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

--
-- Indexes for table `driver_product_purchase`
--
ALTER TABLE `driver_product_purchase`
  ADD PRIMARY KEY (`id`),
  ADD KEY `driver_product_purchase_product_purchase_id_foreign` (`product_purchase_id`);

--
-- Indexes for table `exchanges`
--
ALTER TABLE `exchanges`
  ADD PRIMARY KEY (`id`),
  ADD KEY `exchanges_purchase_id_foreign` (`purchase_id`),
  ADD KEY `exchanges_inventory_id_foreign` (`inventory_id`),
  ADD KEY `exchanges_department_id_foreign` (`department_id`),
  ADD KEY `exchanges_sales_id_foreign` (`sales_id`),
  ADD KEY `exchanges_cost_center_id_foreign` (`cost_center_id`);

--
-- Indexes for table `exchange_permissions`
--
ALTER TABLE `exchange_permissions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `exchange_permissions_invoice_id_foreign` (`invoice_id`),
  ADD KEY `exchange_permissions_account_id_foreign` (`account_id`),
  ADD KEY `exchange_permissions_receipt_voucher_id_foreign` (`receipt_voucher_id`),
  ADD KEY `exchange_permissions_treasury_id_foreign` (`treasury_id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `final_products`
--
ALTER TABLE `final_products`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `final_products_code_unique` (`code`),
  ADD KEY `final_products_category_id_foreign` (`category_id`);

--
-- Indexes for table `final_product_receipes`
--
ALTER TABLE `final_product_receipes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `final_product_receipes_final_product_id_foreign` (`final_product_id`),
  ADD KEY `final_product_receipes_product_id_foreign` (`product_id`);

--
-- Indexes for table `final_product_sales`
--
ALTER TABLE `final_product_sales`
  ADD PRIMARY KEY (`id`),
  ADD KEY `final_product_sales_final_product_id_foreign` (`final_product_id`),
  ADD KEY `final_product_sales_sales_id_foreign` (`sales_id`);

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

--
-- Indexes for table `general_exchanges`
--
ALTER TABLE `general_exchanges`
  ADD PRIMARY KEY (`id`),
  ADD KEY `general_exchanges_vendor_id_foreign` (`vendor_id`),
  ADD KEY `general_exchanges_account_id_foreign` (`account_id`),
  ADD KEY `general_exchanges_purchase_id_foreign` (`purchase_id`),
  ADD KEY `general_exchanges_supply_order_id_foreign` (`supply_order_id`);

--
-- Indexes for table `general_exchange_supply_orders`
--
ALTER TABLE `general_exchange_supply_orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `general_exchange_supply_orders_general_exchange_id_foreign` (`general_exchange_id`),
  ADD KEY `general_exchange_supply_orders_supply_order_id_foreign` (`supply_order_id`);

--
-- Indexes for table `general_settings`
--
ALTER TABLE `general_settings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `general_settings_currency_foreign` (`currency`);

--
-- Indexes for table `inventories`
--
ALTER TABLE `inventories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `inventories_code_unique` (`code`);

--
-- Indexes for table `inventory_product`
--
ALTER TABLE `inventory_product`
  ADD PRIMARY KEY (`id`),
  ADD KEY `inventory_product_inventory_id_foreign` (`inventory_id`),
  ADD KEY `inventory_product_product_id_foreign` (`product_id`),
  ADD KEY `inventory_product_po_id_foreign` (`po_id`),
  ADD KEY `inventory_product_vendor_id_foreign` (`vendor_id`);

--
-- Indexes for table `invoices`
--
ALTER TABLE `invoices`
  ADD PRIMARY KEY (`id`),
  ADD KEY `invoices_general_exchange_id_foreign` (`general_exchange_id`);

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

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

--
-- Indexes for table `list_accounts`
--
ALTER TABLE `list_accounts`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `list_accounts_code_unique` (`code`),
  ADD UNIQUE KEY `list_accounts_name_unique` (`name`);

--
-- Indexes for table `media`
--
ALTER TABLE `media`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `media_uuid_unique` (`uuid`),
  ADD KEY `media_model_type_model_id_index` (`model_type`,`model_id`),
  ADD KEY `media_order_column_index` (`order_column`);

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

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

--
-- Indexes for table `payment_terms`
--
ALTER TABLE `payment_terms`
  ADD PRIMARY KEY (`id`),
  ADD KEY `payment_terms_account_invoice_id_foreign` (`account_invoice_id`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `permissions_name_unique` (`name`);

--
-- Indexes for table `permission_role`
--
ALTER TABLE `permission_role`
  ADD PRIMARY KEY (`permission_id`,`role_id`),
  ADD KEY `permission_role_role_id_foreign` (`role_id`);

--
-- Indexes for table `permission_user`
--
ALTER TABLE `permission_user`
  ADD PRIMARY KEY (`user_id`,`permission_id`,`user_type`),
  ADD KEY `permission_user_permission_id_foreign` (`permission_id`);

--
-- Indexes for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);

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

--
-- Indexes for table `product_purchase`
--
ALTER TABLE `product_purchase`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_purchase_product_id_foreign` (`product_id`),
  ADD KEY `product_purchase_purchase_id_foreign` (`purchase_id`),
  ADD KEY `product_purchase_vendor_id_foreign` (`vendor_id`),
  ADD KEY `product_purchase_user_id_foreign` (`user_id`);

--
-- Indexes for table `product_sales`
--
ALTER TABLE `product_sales`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_sales_product_id_foreign` (`product_id`),
  ADD KEY `product_sales_sales_id_foreign` (`sales_id`);

--
-- Indexes for table `purchases`
--
ALTER TABLE `purchases`
  ADD PRIMARY KEY (`id`),
  ADD KEY `purchases_department_id_foreign` (`department_id`),
  ADD KEY `purchases_inventory_id_foreign` (`inventory_id`),
  ADD KEY `purchases_vendor_id_foreign` (`vendor_id`),
  ADD KEY `purchases_currency_id_foreign` (`currency_id`);

--
-- Indexes for table `receipt_vouchers`
--
ALTER TABLE `receipt_vouchers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `receipt_vouchers_customer_id_foreign` (`customer_id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_name_unique` (`name`);

--
-- Indexes for table `role_user`
--
ALTER TABLE `role_user`
  ADD PRIMARY KEY (`user_id`,`role_id`,`user_type`),
  ADD KEY `role_user_role_id_foreign` (`role_id`);

--
-- Indexes for table `sales`
--
ALTER TABLE `sales`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sales_customer_id_foreign` (`customer_id`),
  ADD KEY `sales_account_invoice_id_foreign` (`account_invoice_id`);

--
-- Indexes for table `sales_invoices`
--
ALTER TABLE `sales_invoices`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sales_invoices_customer_id_foreign` (`customer_id`),
  ADD KEY `sales_invoices_sales_id_foreign` (`sales_id`),
  ADD KEY `sales_invoices_receipt_voucher_id_foreign` (`receipt_voucher_id`);

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

--
-- Indexes for table `supply_orders`
--
ALTER TABLE `supply_orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `supply_orders_purchase_id_foreign` (`purchase_id`),
  ADD KEY `supply_orders_product_id_foreign` (`product_id`),
  ADD KEY `supply_orders_vendor_id_foreign` (`vendor_id`),
  ADD KEY `supply_orders_inventory_id_foreign` (`inventory_id`);

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

--
-- Indexes for table `tax_vendor`
--
ALTER TABLE `tax_vendor`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tax_vendor_tax_id_foreign` (`tax_id`),
  ADD KEY `tax_vendor_vendor_id_foreign` (`vendor_id`);

--
-- Indexes for table `transaction_stocks`
--
ALTER TABLE `transaction_stocks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `transaction_stocks_exchange_id_foreign` (`exchange_id`),
  ADD KEY `transaction_stocks_product_id_foreign` (`product_id`);

--
-- Indexes for table `treasuries`
--
ALTER TABLE `treasuries`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `treasuries_name_unique` (`name`),
  ADD KEY `treasuries_currency_id_foreign` (`currency_id`),
  ADD KEY `treasuries_account_id_foreign` (`account_id`),
  ADD KEY `treasuries_parent_id_foreign` (`parent_id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`),
  ADD KEY `users_created_by_foreign` (`created_by`);

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `accounts`
--
ALTER TABLE `accounts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=379;

--
-- AUTO_INCREMENT for table `account_financials`
--
ALTER TABLE `account_financials`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `account_invoices`
--
ALTER TABLE `account_invoices`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `account_invoice_product`
--
ALTER TABLE `account_invoice_product`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `account_invoice_tax`
--
ALTER TABLE `account_invoice_tax`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `account_ledgers`
--
ALTER TABLE `account_ledgers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `account_tax`
--
ALTER TABLE `account_tax`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `assets`
--
ALTER TABLE `assets`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `asset_categories`
--
ALTER TABLE `asset_categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `asset_vendors`
--
ALTER TABLE `asset_vendors`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `cheque_keepers`
--
ALTER TABLE `cheque_keepers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cost_centers`
--
ALTER TABLE `cost_centers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=309;

--
-- AUTO_INCREMENT for table `cost_center_product`
--
ALTER TABLE `cost_center_product`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `currencies`
--
ALTER TABLE `currencies`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `customers`
--
ALTER TABLE `customers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `driver_product_purchase`
--
ALTER TABLE `driver_product_purchase`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `exchanges`
--
ALTER TABLE `exchanges`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `exchange_permissions`
--
ALTER TABLE `exchange_permissions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `final_products`
--
ALTER TABLE `final_products`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `final_product_receipes`
--
ALTER TABLE `final_product_receipes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `final_product_sales`
--
ALTER TABLE `final_product_sales`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `financials`
--
ALTER TABLE `financials`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `general_exchanges`
--
ALTER TABLE `general_exchanges`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `general_exchange_supply_orders`
--
ALTER TABLE `general_exchange_supply_orders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `general_settings`
--
ALTER TABLE `general_settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `inventories`
--
ALTER TABLE `inventories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `inventory_product`
--
ALTER TABLE `inventory_product`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `invoices`
--
ALTER TABLE `invoices`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `jourals`
--
ALTER TABLE `jourals`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ledgers`
--
ALTER TABLE `ledgers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `list_accounts`
--
ALTER TABLE `list_accounts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `media`
--
ALTER TABLE `media`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=98;

--
-- AUTO_INCREMENT for table `payment_terms`
--
ALTER TABLE `payment_terms`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=74;

--
-- AUTO_INCREMENT for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=322;

--
-- AUTO_INCREMENT for table `product_purchase`
--
ALTER TABLE `product_purchase`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT for table `product_sales`
--
ALTER TABLE `product_sales`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `purchases`
--
ALTER TABLE `purchases`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `receipt_vouchers`
--
ALTER TABLE `receipt_vouchers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `sales`
--
ALTER TABLE `sales`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `sales_invoices`
--
ALTER TABLE `sales_invoices`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `supply_orders`
--
ALTER TABLE `supply_orders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `taxes`
--
ALTER TABLE `taxes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `tax_vendor`
--
ALTER TABLE `tax_vendor`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `transaction_stocks`
--
ALTER TABLE `transaction_stocks`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `treasuries`
--
ALTER TABLE `treasuries`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `vendors`
--
ALTER TABLE `vendors`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `accounts`
--
ALTER TABLE `accounts`
  ADD CONSTRAINT `accounts_list_account_id_foreign` FOREIGN KEY (`list_account_id`) REFERENCES `list_accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `accounts_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `accounts_vendor_id_foreign` FOREIGN KEY (`vendor_id`) REFERENCES `vendors` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `account_financials`
--
ALTER TABLE `account_financials`
  ADD CONSTRAINT `account_financials_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `account_financials_financial_id_foreign` FOREIGN KEY (`financial_id`) REFERENCES `financials` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `account_invoices`
--
ALTER TABLE `account_invoices`
  ADD CONSTRAINT `account_invoices_cost_center_id_foreign` FOREIGN KEY (`cost_center_id`) REFERENCES `cost_centers` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `account_invoices_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `account_invoices_general_exchange_id_foreign` FOREIGN KEY (`general_exchange_id`) REFERENCES `general_exchanges` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `account_invoices_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `account_invoices_vendor_id_foreign` FOREIGN KEY (`vendor_id`) REFERENCES `vendors` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `account_invoice_product`
--
ALTER TABLE `account_invoice_product`
  ADD CONSTRAINT `account_invoice_product_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `account_invoice_product_account_invoice_id_foreign` FOREIGN KEY (`account_invoice_id`) REFERENCES `account_invoices` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `account_invoice_product_final_product_id_foreign` FOREIGN KEY (`final_product_id`) REFERENCES `final_products` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `account_invoice_product_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `account_invoice_tax`
--
ALTER TABLE `account_invoice_tax`
  ADD CONSTRAINT `account_invoice_tax_account_invoice_id_foreign` FOREIGN KEY (`account_invoice_id`) REFERENCES `account_invoices` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `account_invoice_tax_tax_id_foreign` FOREIGN KEY (`tax_id`) REFERENCES `taxes` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `account_ledgers`
--
ALTER TABLE `account_ledgers`
  ADD CONSTRAINT `account_ledgers_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `account_ledgers_cost_center_id_foreign` FOREIGN KEY (`cost_center_id`) REFERENCES `cost_centers` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `account_ledgers_ledger_id_foreign` FOREIGN KEY (`ledger_id`) REFERENCES `ledgers` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `account_tax`
--
ALTER TABLE `account_tax`
  ADD CONSTRAINT `account_tax_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `account_tax_tax_id_foreign` FOREIGN KEY (`tax_id`) REFERENCES `taxes` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `assets`
--
ALTER TABLE `assets`
  ADD CONSTRAINT `assets_asset_category_id_foreign` FOREIGN KEY (`asset_category_id`) REFERENCES `asset_categories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `assets_cost_center_id_foreign` FOREIGN KEY (`cost_center_id`) REFERENCES `cost_centers` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `assets_vendor_id_foreign` FOREIGN KEY (`vendor_id`) REFERENCES `vendors` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `asset_vendors`
--
ALTER TABLE `asset_vendors`
  ADD CONSTRAINT `asset_vendors_asset_id_foreign` FOREIGN KEY (`asset_id`) REFERENCES `assets` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `asset_vendors_vendor_id_foreign` FOREIGN KEY (`vendor_id`) REFERENCES `vendors` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `cheque_keepers`
--
ALTER TABLE `cheque_keepers`
  ADD CONSTRAINT `cheque_keepers_exchange_permission_id_foreign` FOREIGN KEY (`exchange_permission_id`) REFERENCES `exchange_permissions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `cost_centers`
--
ALTER TABLE `cost_centers`
  ADD CONSTRAINT `cost_centers_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `cost_centers` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `cost_center_product`
--
ALTER TABLE `cost_center_product`
  ADD CONSTRAINT `cost_center_product_cost_center_id_foreign` FOREIGN KEY (`cost_center_id`) REFERENCES `cost_centers` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `cost_center_product_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `driver_product_purchase`
--
ALTER TABLE `driver_product_purchase`
  ADD CONSTRAINT `driver_product_purchase_product_purchase_id_foreign` FOREIGN KEY (`product_purchase_id`) REFERENCES `product_purchase` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `exchanges`
--
ALTER TABLE `exchanges`
  ADD CONSTRAINT `exchanges_cost_center_id_foreign` FOREIGN KEY (`cost_center_id`) REFERENCES `cost_centers` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `exchanges_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `exchanges_inventory_id_foreign` FOREIGN KEY (`inventory_id`) REFERENCES `inventories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `exchanges_purchase_id_foreign` FOREIGN KEY (`purchase_id`) REFERENCES `purchases` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `exchanges_sales_id_foreign` FOREIGN KEY (`sales_id`) REFERENCES `sales` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `exchange_permissions`
--
ALTER TABLE `exchange_permissions`
  ADD CONSTRAINT `exchange_permissions_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `exchange_permissions_invoice_id_foreign` FOREIGN KEY (`invoice_id`) REFERENCES `account_invoices` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `exchange_permissions_receipt_voucher_id_foreign` FOREIGN KEY (`receipt_voucher_id`) REFERENCES `receipt_vouchers` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `exchange_permissions_treasury_id_foreign` FOREIGN KEY (`treasury_id`) REFERENCES `treasuries` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `final_products`
--
ALTER TABLE `final_products`
  ADD CONSTRAINT `final_products_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `final_product_receipes`
--
ALTER TABLE `final_product_receipes`
  ADD CONSTRAINT `final_product_receipes_final_product_id_foreign` FOREIGN KEY (`final_product_id`) REFERENCES `final_products` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `final_product_receipes_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `final_product_sales`
--
ALTER TABLE `final_product_sales`
  ADD CONSTRAINT `final_product_sales_final_product_id_foreign` FOREIGN KEY (`final_product_id`) REFERENCES `final_products` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `final_product_sales_sales_id_foreign` FOREIGN KEY (`sales_id`) REFERENCES `sales` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `general_exchanges`
--
ALTER TABLE `general_exchanges`
  ADD CONSTRAINT `general_exchanges_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `general_exchanges_purchase_id_foreign` FOREIGN KEY (`purchase_id`) REFERENCES `purchases` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `general_exchanges_supply_order_id_foreign` FOREIGN KEY (`supply_order_id`) REFERENCES `supply_orders` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `general_exchanges_vendor_id_foreign` FOREIGN KEY (`vendor_id`) REFERENCES `vendors` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `general_exchange_supply_orders`
--
ALTER TABLE `general_exchange_supply_orders`
  ADD CONSTRAINT `general_exchange_supply_orders_general_exchange_id_foreign` FOREIGN KEY (`general_exchange_id`) REFERENCES `general_exchanges` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `general_exchange_supply_orders_supply_order_id_foreign` FOREIGN KEY (`supply_order_id`) REFERENCES `supply_orders` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `general_settings`
--
ALTER TABLE `general_settings`
  ADD CONSTRAINT `general_settings_currency_foreign` FOREIGN KEY (`currency`) REFERENCES `currencies` (`id`);

--
-- Constraints for table `inventory_product`
--
ALTER TABLE `inventory_product`
  ADD CONSTRAINT `inventory_product_inventory_id_foreign` FOREIGN KEY (`inventory_id`) REFERENCES `inventories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `inventory_product_po_id_foreign` FOREIGN KEY (`po_id`) REFERENCES `product_purchase` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `inventory_product_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `inventory_product_vendor_id_foreign` FOREIGN KEY (`vendor_id`) REFERENCES `vendors` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `invoices`
--
ALTER TABLE `invoices`
  ADD CONSTRAINT `invoices_general_exchange_id_foreign` FOREIGN KEY (`general_exchange_id`) REFERENCES `general_exchanges` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `payment_terms`
--
ALTER TABLE `payment_terms`
  ADD CONSTRAINT `payment_terms_account_invoice_id_foreign` FOREIGN KEY (`account_invoice_id`) REFERENCES `account_invoices` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `permission_role`
--
ALTER TABLE `permission_role`
  ADD CONSTRAINT `permission_role_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `permission_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `permission_user`
--
ALTER TABLE `permission_user`
  ADD CONSTRAINT `permission_user_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `products_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `product_purchase`
--
ALTER TABLE `product_purchase`
  ADD CONSTRAINT `product_purchase_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `product_purchase_purchase_id_foreign` FOREIGN KEY (`purchase_id`) REFERENCES `purchases` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `product_purchase_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `product_purchase_vendor_id_foreign` FOREIGN KEY (`vendor_id`) REFERENCES `vendors` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `product_sales`
--
ALTER TABLE `product_sales`
  ADD CONSTRAINT `product_sales_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `product_sales_sales_id_foreign` FOREIGN KEY (`sales_id`) REFERENCES `sales` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `purchases`
--
ALTER TABLE `purchases`
  ADD CONSTRAINT `purchases_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currencies` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `purchases_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `purchases_inventory_id_foreign` FOREIGN KEY (`inventory_id`) REFERENCES `inventories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `purchases_vendor_id_foreign` FOREIGN KEY (`vendor_id`) REFERENCES `vendors` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `receipt_vouchers`
--
ALTER TABLE `receipt_vouchers`
  ADD CONSTRAINT `receipt_vouchers_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `role_user`
--
ALTER TABLE `role_user`
  ADD CONSTRAINT `role_user_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `sales`
--
ALTER TABLE `sales`
  ADD CONSTRAINT `sales_account_invoice_id_foreign` FOREIGN KEY (`account_invoice_id`) REFERENCES `account_invoices` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `sales_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `sales_invoices`
--
ALTER TABLE `sales_invoices`
  ADD CONSTRAINT `sales_invoices_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `sales_invoices_receipt_voucher_id_foreign` FOREIGN KEY (`receipt_voucher_id`) REFERENCES `receipt_vouchers` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `sales_invoices_sales_id_foreign` FOREIGN KEY (`sales_id`) REFERENCES `sales` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `supply_orders`
--
ALTER TABLE `supply_orders`
  ADD CONSTRAINT `supply_orders_inventory_id_foreign` FOREIGN KEY (`inventory_id`) REFERENCES `inventories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `supply_orders_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `supply_orders_purchase_id_foreign` FOREIGN KEY (`purchase_id`) REFERENCES `purchases` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `supply_orders_vendor_id_foreign` FOREIGN KEY (`vendor_id`) REFERENCES `vendors` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `tax_vendor`
--
ALTER TABLE `tax_vendor`
  ADD CONSTRAINT `tax_vendor_tax_id_foreign` FOREIGN KEY (`tax_id`) REFERENCES `taxes` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `tax_vendor_vendor_id_foreign` FOREIGN KEY (`vendor_id`) REFERENCES `vendors` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `transaction_stocks`
--
ALTER TABLE `transaction_stocks`
  ADD CONSTRAINT `transaction_stocks_exchange_id_foreign` FOREIGN KEY (`exchange_id`) REFERENCES `exchanges` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `transaction_stocks_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `treasuries`
--
ALTER TABLE `treasuries`
  ADD CONSTRAINT `treasuries_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `treasuries_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currencies` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `treasuries_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `treasuries` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `users`
--
ALTER TABLE `users`
  ADD CONSTRAINT `users_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

