USE `income_db`;

-- Dumping structure for table income_db.articles
CREATE TABLE IF NOT EXISTS `articles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` bigint(20) unsigned DEFAULT NULL,
  `services_ids` text CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `lat` double DEFAULT NULL,
  `lng` double DEFAULT NULL,
  `facilities` bigint(20) DEFAULT NULL,
  `visit_counts` bigint(20) DEFAULT NULL,
  `open_date` date DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `articles_category_id_article_id_index` (`category_id`),
  CONSTRAINT `articles_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table income_db.articles: ~0 rows (approximately)

-- Dumping structure for table income_db.article_descriptions
CREATE TABLE IF NOT EXISTS `article_descriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `address` longtext DEFAULT NULL,
  `slug` varchar(100) DEFAULT NULL,
  `meta_description` text DEFAULT NULL,
  `keywords` varchar(400) DEFAULT NULL,
  `article_id` bigint(20) unsigned DEFAULT NULL,
  `language_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `article_descriptions_language_id_index` (`language_id`),
  KEY `article_descriptions_article_id_language_id_index` (`article_id`,`language_id`),
  CONSTRAINT `article_descriptions_article_id_foreign` FOREIGN KEY (`article_id`) REFERENCES `articles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `article_descriptions_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table income_db.article_descriptions: ~0 rows (approximately)

-- Dumping structure for table income_db.banners
CREATE TABLE IF NOT EXISTS `banners` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(191) DEFAULT NULL,
  `video` varchar(191) DEFAULT NULL,
  `page_url` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `banners_page_url_index` (`page_url`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table income_db.banners: ~1 rows (approximately)
INSERT INTO `banners` (`id`, `image`, `video`, `page_url`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, 'storage/photos/shares/header-1.svg', NULL, 'http://localhost/tabweeb/public/ar', '2024-07-30 12:07:28', '2024-07-30 12:07:28', NULL);

-- Dumping structure for table income_db.banner_descriptions
CREATE TABLE IF NOT EXISTS `banner_descriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(200) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `btn_name` text DEFAULT NULL,
  `banner_id` bigint(20) unsigned DEFAULT NULL,
  `language_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `banner_descriptions_banner_id_index` (`banner_id`),
  KEY `banner_descriptions_language_id_index` (`language_id`),
  CONSTRAINT `banner_descriptions_banner_id_foreign` FOREIGN KEY (`banner_id`) REFERENCES `banners` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `banner_descriptions_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table income_db.banner_descriptions: ~2 rows (approximately)
INSERT INTO `banner_descriptions` (`id`, `title`, `description`, `btn_name`, `banner_id`, `language_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(5, 'شركة تبويب لتقنية المعلومات', '<div class="p my-4 ">تبويب مؤسسة سعودية متخصصة في مجال تصميم البرمجيات الخاصة وحلول الفوترة الإلكترونية ونظم المال والأعمال وتصميم مواقع الويب وتطبيقات الهواتف الذكية.2</div>', 'اتصل بنا', 1, 1, NULL, NULL, NULL),
	(6, 'Tabweeb for information Technology', '<p>Taboo is a Saudi institution specialized in designing special software, electronic billing solutions, financial and business systems, designing websites, and smart phone applications2.</p>', 'Contact us', 1, 2, NULL, NULL, NULL);

-- Dumping structure for table income_db.careers
CREATE TABLE IF NOT EXISTS `careers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table income_db.careers: ~3 rows (approximately)
INSERT INTO `careers` (`id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, '2024-07-27 13:47:13', '2024-07-27 13:47:13', NULL),
	(2, '2024-07-27 13:47:38', '2024-07-27 13:47:38', NULL),
	(3, '2024-07-27 13:48:05', '2024-07-27 13:48:05', NULL);

-- Dumping structure for table income_db.career_descriptions
CREATE TABLE IF NOT EXISTS `career_descriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(200) DEFAULT NULL,
  `career_id` bigint(20) unsigned DEFAULT NULL,
  `language_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table income_db.career_descriptions: ~6 rows (approximately)
INSERT INTO `career_descriptions` (`id`, `title`, `career_id`, `language_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, 'مبرمج', 1, 1, NULL, NULL, NULL),
	(2, 'programmer', 1, 2, NULL, NULL, NULL),
	(3, 'مطور', 2, 1, NULL, NULL, NULL),
	(4, 'Developer', 2, 2, NULL, NULL, NULL),
	(5, 'مهندس', 3, 1, NULL, NULL, NULL),
	(6, 'Engineer', 3, 2, NULL, NULL, NULL);

-- Dumping structure for table income_db.categories
CREATE TABLE IF NOT EXISTS `categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `categories_id_index` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table income_db.categories: ~0 rows (approximately)

-- Dumping structure for table income_db.category_descriptions
CREATE TABLE IF NOT EXISTS `category_descriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `category_id` bigint(20) unsigned DEFAULT NULL,
  `language_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `category_descriptions_category_id_foreign` (`category_id`),
  KEY `category_descriptions_language_id_foreign` (`language_id`),
  CONSTRAINT `category_descriptions_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
  CONSTRAINT `category_descriptions_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table income_db.category_descriptions: ~0 rows (approximately)

-- Dumping structure for table income_db.clients
CREATE TABLE IF NOT EXISTS `clients` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table income_db.clients: ~6 rows (approximately)
INSERT INTO `clients` (`id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, '2024-07-26 18:31:17', '2024-07-26 18:31:17', NULL),
	(2, '2024-07-26 18:38:39', '2024-07-26 18:38:39', NULL),
	(3, '2024-07-26 18:39:06', '2024-07-26 18:39:06', NULL),
	(4, '2024-07-26 18:39:32', '2024-07-26 18:39:32', NULL),
	(5, '2024-07-26 18:40:04', '2024-07-26 18:40:04', NULL),
	(6, '2024-07-26 19:46:17', '2024-07-26 19:46:17', NULL),
	(7, '2024-07-29 20:13:17', '2024-07-29 20:13:17', NULL);

-- Dumping structure for table income_db.client_descriptions
CREATE TABLE IF NOT EXISTS `client_descriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `language_id` bigint(20) unsigned DEFAULT NULL,
  `client_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `client_descriptions_language_id_foreign` (`language_id`),
  KEY `client_descriptions_client_id_foreign` (`client_id`),
  CONSTRAINT `client_descriptions_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `client_descriptions_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table income_db.client_descriptions: ~12 rows (approximately)
INSERT INTO `client_descriptions` (`id`, `title`, `description`, `language_id`, `client_id`, `created_at`, `updated_at`) VALUES
	(7, 'باشا', ' علي قدر المسئولية ونفذ العمل بجودة واتقان فريق عمل مميز جدا كان علي قدر المسئولية ونفذ العمل بجودة واتقان', 1, 3, NULL, NULL),
	(8, 'basha', '<p>basha</p>', 2, 3, NULL, NULL),
	(9, 'موقع', ' علي قدر المسئولية ونفذ العمل بجودة واتقان فريق عمل مميز جدا كان علي قدر المسئولية ونفذ العمل بجودة واتقان', 1, 4, NULL, NULL),
	(10, 'location', '<p>location</p>', 2, 4, NULL, NULL),
	(11, 'امازون', ' علي قدر المسئولية ونفذ العمل بجودة واتقان فريق عمل مميز جدا كان علي قدر المسئولية ونفذ العمل بجودة واتقان', 1, 5, NULL, NULL),
	(12, 'amazon', '<p>amazon</p>', 2, 5, NULL, NULL),
	(13, 'عميل', 'علي قدر المسئولية ونفذ العمل بجودة واتقان فريق عمل مميز جدا كان علي قدر المسئولية ونفذ العمل بجودة واتقان2</', 1, 2, NULL, NULL),
	(14, 'client', '<p>client</p>', 2, 2, NULL, NULL),
	(15, 'تطبيق جوال', '<p>علي قدر المسئولية ونفذ العمل بجودة واتقان فريق عمل مميز جدا كان علي قدر المسئولية ونفذ العمل بجودة واتقان</p>', 1, 6, NULL, NULL),
	(16, 'mobileApp', '<p>علي قدر المسئولية ونفذ العمل بجودة واتقان فريق عمل مميز جدا كان علي قدر المسئولية ونفذ العمل بجودة واتقان</p>', 2, 6, NULL, NULL),
	(17, 'محمد أحمد', '<p style="text-align: right;"><strong>علي قدر المسئولية ونفذ العمل بجودة واتقان فريق عمل مميز جدا كان علي قدر المسئولية ونفذ العمل بجودة واتقان</strong></p>', 1, 1, NULL, NULL),
	(18, 'Mohamed Ahmed', '<p>good team</p>', 2, 1, NULL, NULL),
	(21, 'تست2', '<p>يسب</p>', 1, 7, NULL, NULL),
	(22, 'تست', '<p>سي</p>', 2, 7, NULL, NULL);

-- Dumping structure for table income_db.failed_jobs
CREATE TABLE IF NOT EXISTS `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table income_db.failed_jobs: ~0 rows (approximately)

-- Dumping structure for table income_db.languages
CREATE TABLE IF NOT EXISTS `languages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `local` char(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT 'whether the language is active in the website or not, 1-> is active',
  `admin_status` tinyint(4) NOT NULL DEFAULT 1 COMMENT 'whether the language is active in the dashboard or not, 1-> is active',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `languages_local_unique` (`local`),
  KEY `languages_status_index` (`status`),
  KEY `languages_admin_status_index` (`admin_status`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table income_db.languages: ~2 rows (approximately)
INSERT INTO `languages` (`id`, `local`, `name`, `status`, `admin_status`, `deleted_at`, `created_at`, `updated_at`) VALUES
	(1, 'ar', 'Arabic', 1, 1, NULL, NULL, NULL),
	(2, 'en', 'English', 1, 1, NULL, NULL, NULL);

-- Dumping structure for table income_db.mail_lists
CREATE TABLE IF NOT EXISTS `mail_lists` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `send_to` varchar(191) DEFAULT NULL,
  `subject` varchar(191) DEFAULT NULL,
  `message` text DEFAULT NULL,
  `categories` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mail_lists_id_index` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table income_db.mail_lists: ~0 rows (approximately)

-- Dumping structure for table income_db.migrations
CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table income_db.migrations: ~36 rows (approximately)
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(1, '2014_10_12_100000_create_password_reset_tokens_table', 1),
	(2, '2019_08_19_000000_create_failed_jobs_table', 1),
	(3, '2019_12_14_000001_create_personal_access_tokens_table', 1),
	(4, '2024_07_02_130330_create_users_table', 1),
	(5, '2024_07_02_132852_create_modules_table', 1),
	(6, '2024_07_02_132945_create_user_modules_table', 1),
	(7, '2024_07_02_144431_create_settings_table', 1),
	(8, '2024_07_02_150704_create_languages_table', 1),
	(9, '2024_07_02_165131_create_categories_table', 1),
	(10, '2024_07_02_165304_create_articles_table', 1),
	(11, '2024_07_02_170030_create_article_descriptions_table', 1),
	(12, '2024_07_02_170334_create_website_visitors_table', 1),
	(13, '2024_07_03_231744_create_careers_table', 1),
	(14, '2024_07_03_231903_create_career_descriptions_table', 1),
	(15, '2024_07_03_235803_create_visitor_jobs_table', 1),
	(16, '2024_07_10_212553_create_category_descriptions_table', 1),
	(17, '2024_07_10_213318_create_pages_table', 1),
	(18, '2024_07_10_214901_create_partners_table', 1),
	(19, '2024_07_10_220642_create_services_table', 1),
	(20, '2024_07_10_220821_create_service_descriptions_table', 1),
	(21, '2024_07_10_221157_create_photo_categories_table', 1),
	(22, '2024_07_10_221319_create_photo_category_descriptions_table', 1),
	(23, '2024_07_11_145037_create_partner_descriptions_table', 1),
	(24, '2024_07_11_145646_create_newsletters_table', 1),
	(25, '2024_07_12_111219_create_clients_table', 1),
	(26, '2024_07_12_111440_create_client_descriptions_table', 1),
	(27, '2024_07_12_144054_create_website_disabled_table', 1),
	(28, '2024_07_13_100901_create_partner_photos_table', 1),
	(29, '2024_07_14_091333_add_title_to_visitor_jobs', 1),
	(30, '2024_07_14_152345_create_photos_table', 1),
	(31, '2024_07_14_153005_create_photo_descriptions_table', 1),
	(32, '2024_07_15_161932_create_visitor_messages_table', 1),
	(33, '2024_07_15_162302_create_visitor_emails_table', 1),
	(34, '2024_07_15_165727_create_mail_lists_table', 1),
	(35, '2024_07_17_005642_add_youtube_url_to_photo_table', 1),
	(36, '2024_07_17_150917_create_page_descriptions_table', 1),
	(37, '2024_07_17_151442_create_banners_table', 1),
	(38, '2024_07_17_152152_create_banner_descriptions_table', 1),
	(39, '2024_07_18_093954_create_numbers_table', 1),
	(40, '2024_07_18_094250_create_number_descriptions_table', 1);

-- Dumping structure for table income_db.modules
CREATE TABLE IF NOT EXISTS `modules` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `path` varchar(50) NOT NULL,
  `meta` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table income_db.modules: ~13 rows (approximately)
INSERT INTO `modules` (`id`, `name`, `path`, `meta`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(29, 'Settings', 'settings', '{"module_name":{"ar":"\\u0627\\u0644\\u0625\\u0639\\u062f\\u0627\\u062f\\u062a","en":"Settings"},"fields":{"ar":{"add_new":"\\u0625\\u0636\\u0627\\u0641\\u0629 \\u0623\\u0639\\u062f\\u0627\\u062f\\u062a","edit":"\\u062a\\u0639\\u062f\\u064a\\u0644 \\u0627\\u0644\\u0625\\u0639\\u062f\\u0627\\u062f\\u062a","website_disable":"\\u062a\\u0639\\u0637\\u064a\\u0644 \\u0627\\u0644\\u0645\\u0648\\u0642\\u0639","dashboard_disable":"\\u062a\\u0639\\u0637\\u064a\\u0644 \\u0644\\u0648\\u062d\\u0629 \\u0627\\u0644\\u062a\\u062d\\u0643\\u0645","website_name":"\\u0627\\u0633\\u0645 \\u0627\\u0644\\u0645\\u0648\\u0642\\u0639","Keywords":"\\u0627\\u0644\\u0643\\u0644\\u0645\\u0627\\u062a \\u0627\\u0644\\u062f\\u0644\\u064a\\u0644\\u064a\\u0629","meta_description":"\\u0627\\u0644\\u0643\\u0644\\u0645\\u0627\\u062a \\u0627\\u0644\\u0648\\u0635\\u0641\\u064a\\u0629","site_email":"\\u0628\\u0631\\u064a\\u062f \\u0627\\u0644\\u0645\\u0648\\u0642\\u0639","site_address":"\\u0639\\u0646\\u0648\\u0627\\u0646 \\u0627\\u0644\\u0645\\u0648\\u0642\\u0639","site_phone":"\\u062c\\u0648\\u0627\\u0644 \\u0627\\u0644\\u0645\\u0648\\u0642\\u0639","mail_driver":"Mail Driver(SMTP)","mail_host":"Mail Host (smtp.example.com)","mail_port":"Mail Port (2525)","mail_username":"Mail Username(username@example.cm)","mail_password":"Mail password","mail_encryption":"Mail Encryption(tls)","mail_from_address":"Mail From address(info@example.com)","mail_from_name":"Mail From Name(Example)","website_logo":"\\u0644\\u0648\\u062c\\u0648 \\u0627\\u0644\\u0645\\u0648\\u0642\\u0639"},"en":{"add_new":"Add Settings","edit":"Edit Settings","website_disable":"Website Disabled","dashboard_disable":"Dashboard Disabled","website_name":"Website Name","Keywords":"Keywords","meta_description":"Meta Description","site_email":"Website Email","site_address":"Website Address","site_phone":"Website Phone","mail_driver":"Mail Driver(SMTP)","mail_host":"Mail Host (smtp.example.com)","mail_port":"Mail Port (2525)","mail_username":"Mail Username(username@example.cm)","mail_password":"Mail password","mail_encryption":"Mail Encryption(tls)","mail_from_address":"Mail From address(info@example.com)","mail_from_name":"Mail From Name(Example)","website_logo":"Website Logo"}}}', NULL, NULL, NULL),
	(30, 'Users', 'users', '{"module_name":{"ar":"\\u0627\\u0644\\u0645\\u0634\\u0631\\u0641\\u064a\\u0646","en":"Users"},"fields":{"ar":{"add_new":"\\u0625\\u0636\\u0627\\u0641\\u0629 \\u0645\\u0634\\u0631\\u0641 \\u062c\\u062f\\u064a\\u062f","edit":"\\u062a\\u0639\\u062f\\u064a\\u0644 \\u0645\\u0634\\u0631\\u0641","name":"\\u0627\\u0644\\u0625\\u0633\\u0645","email":"\\u0627\\u0644\\u0628\\u0631\\u064a\\u062f \\u0627\\u0644\\u0625\\u0644\\u0643\\u062a\\u0631\\u0648\\u0646\\u064a","phone":"\\u0631\\u0642\\u0645 \\u0627\\u0644\\u062c\\u0648\\u0627\\u0644","photo":"\\u0635\\u0648\\u0631\\u0629 \\u0627\\u0644\\u0628\\u0631\\u0648\\u0641\\u0627\\u064a\\u0644","password":"\\u0643\\u0644\\u0645\\u0629 \\u0627\\u0644\\u0645\\u0631\\u0648\\u0631","password_confirmation":"\\u062a\\u0623\\u0643\\u064a\\u062f \\u0643\\u0644\\u0645\\u0629 \\u0627\\u0644\\u0645\\u0631\\u0648\\u0631","modules":"\\u0627\\u0644\\u0645\\u0648\\u062f\\u064a\\u0648\\u0644\\u0627\\u062a"},"en":{"add_new":"Add New User","edit":"Edit User","name":"The name","email":"The email","phone":"The Phone","photo":"The Photo","password":"Password","password_confirmation":"Password Confirmation","modules":"Modules"}}}', NULL, NULL, NULL),
	(31, 'Partners', 'partners', '{"module_name":{"ar":"\\u0634\\u0631\\u0643\\u0627\\u0621 \\u0627\\u0644\\u0646\\u062c\\u0627\\u062d","en":"partners"},"fields":{"ar":{"add_new":"\\u0625\\u0636\\u0627\\u0641\\u0629 \\u062c\\u062f\\u064a\\u062f","edit":"\\u062a\\u0639\\u062f\\u064a\\u0644","title":"\\u0627\\u0633\\u0645 \\u0627\\u0644\\u0634\\u0631\\u064a\\u0643","description":"\\u0627\\u0644\\u062a\\u0641\\u0627\\u0635\\u064a\\u0644","image":"\\u0627\\u0644\\u0635\\u0648\\u0631\\u0629"},"en":{"add_new":"Add new","edit":"Edit","title":"Title","description":"Description","image":"Image"}}}', NULL, NULL, NULL),
	(32, 'Clients', 'clients', '{"module_name":{"ar":"\\u0627\\u0631\\u0627\\u0621 \\u0627\\u0644\\u0639\\u0645\\u0644\\u0627\\u0621","en":"Clients"},"fields":{"ar":{"head":"\\u0627\\u0631\\u0627\\u0621 \\u0627\\u0644\\u0639\\u0645\\u0644\\u0627\\u0621","menuIcon":"fas fa-camera","new":"\\u0625\\u0636\\u0627\\u0641\\u0629 \\u0631\\u0627\\u064a \\u0639\\u0645\\u064a\\u0644 \\u062c\\u062f\\u064a\\u062f","edit":"\\u062a\\u062d\\u0631\\u064a\\u0631 \\u0639\\u0645\\u064a\\u0644","image":"\\u0627\\u0644\\u0635\\u0648\\u0631\\u0629","title":"\\u0627\\u0633\\u0645 \\u0627\\u0644\\u0639\\u0645\\u064a\\u0644","description":"\\u0627\\u0644\\u0648\\u0635\\u0641 "},"en":{"add_new":"Add New Client","edit":"Edit Client","image":"Image","title":"title","description":"description "}}}', NULL, NULL, NULL),
	(33, 'Pages', 'pages', '{"module_name":{"ar":"\\u0627\\u0644\\u0635\\u0641\\u062d\\u0627\\u062a","en":"Pages"},"fields":{"ar":{"add_new":"\\u0627\\u0636\\u0627\\u0641\\u0629 \\u0635\\u0641\\u062d\\u0629 \\u062c\\u062f\\u064a\\u062f","edit":"\\u062a\\u0639\\u062f\\u064a\\u0644 \\u0635\\u0641\\u062d\\u0629"},"en":{"add_new":"Add New Page","edit":"Edit Page"}}}', NULL, NULL, NULL),
	(34, 'Numbers', 'numbers', '{"module_name":{"ar":"\\u0627\\u0631\\u0642\\u0627\\u0645\\u0646\\u0627","en":"numbers"},"fields":{"ar":{"head":"\\u0627\\u0631\\u0642\\u0627\\u0645\\u0646\\u0627","menuIcon":"fas fa-pager","title":"\\u0639\\u0646\\u0648\\u0627\\u0646","new":"\\u0625\\u0636\\u0627\\u0641 \\u062c\\u062f\\u064a\\u062f","edit":"\\u062a\\u0639\\u062f\\u064a\\u0644 ","image":"\\u0635\\u0648\\u0631\\u0629 ","counter":"\\u0627\\u0644\\u0631\\u0642\\u0645"},"en":{"head":"Numbers","menuIcon":"fas fa-pager","title":"Title","new":"Add new","edit":"Edit","image":"Image","counter":"Number"}}}', NULL, NULL, NULL),
	(35, 'banners', 'banners', '{"module_name":{"ar":"\\u0627\\u0644\\u0628\\u0646\\u0631","en":"banners"},"fields":{"ar":{"head":"\\u0627\\u0644\\u0628\\u0646\\u0631","menuIcon":"fas fa-pager","title":"\\u0639\\u0646\\u0648\\u0627\\u0646","description":"\\u0627\\u0644\\u062a\\u0641\\u0627\\u0635\\u064a\\u0644","new":"\\u0625\\u0636\\u0627\\u0641 \\u062c\\u062f\\u064a\\u062f","edit":"\\u062a\\u0639\\u062f\\u064a\\u0644 ","image":"\\u0635\\u0648\\u0631\\u0629 ","video":"\\u0641\\u064a\\u062f\\u064a\\u0648"},"en":{"head":"Banner","menuIcon":"fas fa-pager","title":"Title","description":"Description","new":"Add new","edit":"Edit","image":"Image","video":"Video"}}}', NULL, NULL, NULL),
	(36, 'photoCategories', 'photoCategories', '{"module_name":{"ar":"\\u0627\\u0644\\u0645\\u0639\\u0631\\u0636","en":"Photos Galleries"},"fields":{"ar":{"edit":"\\u062a\\u0639\\u062f\\u064a\\u0644 \\u0627\\u0644\\u0623\\u0644\\u0628\\u0648\\u0645","name":"\\u0627\\u0644\\u0625\\u0633\\u0645","slug":"The Url Slug","images":"\\u0635\\u0648\\u0631 \\u0627\\u0644\\u0623\\u0644\\u0628\\u0648\\u0645","add_new":"\\u0625\\u0636\\u0627\\u0641\\u0629 \\u0627\\u0644\\u0628\\u0648\\u0645 \\u062c\\u062f\\u064a\\u062f","image_title":"\\u0639\\u0646\\u0648\\u0627\\u0646 \\u0627\\u0644\\u0635\\u0648\\u0631\\u0629","add_new_item":"\\u0625\\u0636\\u0627\\u0641\\u0629 \\u0635\\u0648\\u0631\\u0629","gallery_title":"\\u0639\\u0646\\u0648\\u0627\\u0646 \\u0627\\u0644\\u0623\\u0644\\u0628\\u0648\\u0645"},"en":{"edit":"Edit Photo Gallery","name":"The Name","slug":"The Url Slug","images":"Album Photos","add_new":"Add New Gallery","image_title":"Image Title","add_new_item":"Add New Item","gallery_title":"Gallery Title"}}}', NULL, NULL, NULL),
	(37, 'Newsletters', 'newsletters', '{"module_name":{"ar":"\\u0627\\u0644\\u0628\\u0631\\u064a\\u062f\\u064a\\u0629","en":"newsletters"},"fields":{"ar":{"head":"\\u0627\\u0644\\u0646\\u0634\\u0631\\u0627\\u062a \\u0627\\u0644\\u0625\\u062e\\u0628\\u0627\\u0631\\u064a\\u0629","menuIcon":"fas fa-newspaper","new":"\\u0625\\u0631\\u0633\\u0627\\u0644 \\u0631\\u0633\\u0627\\u0644\\u0629 \\u062c\\u062f\\u064a\\u062f\\u0629","email":"\\u0627\\u0644\\u0628\\u0631\\u064a\\u062f \\u0627\\u0644\\u0625\\u0644\\u0643\\u062a\\u0631\\u0648\\u0646\\u064a","send_to":"\\u0625\\u0631\\u0633\\u0627\\u0644 \\u0625\\u0644\\u0649 ","all":"\\u0627\\u0644\\u0643\\u0644","select":"\\u0627\\u062e\\u062a\\u0631","subject":"\\u0645\\u0648\\u0636\\u0648\\u0639 \\u0627\\u0644\\u0646\\u0634\\u0631\\u0629 \\u0627\\u0644\\u0625\\u062e\\u0628\\u0627\\u0631\\u064a\\u0629","message":"\\u0631\\u0633\\u0627\\u0644\\u0629 \\u0627\\u0644\\u0646\\u0634\\u0631\\u0629 \\u0627\\u0644\\u0625\\u062e\\u0628\\u0627\\u0631\\u064a\\u0629","categories":"\\u0627\\u0644\\u062a\\u0636\\u0646\\u064a\\u0641\\u0627\\u062a","email_success":"\\u062a\\u0645 \\u0625\\u0631\\u0633\\u0627\\u0644 \\u0627\\u0644\\u0646\\u0634\\u0631\\u0629 \\u0627\\u0644\\u0625\\u062e\\u0628\\u0627\\u0631\\u064a\\u0629 \\u0628\\u0646\\u062c\\u0627\\u062d","newsletter_subscribe_success":"\\u062a\\u0645 \\u0627\\u0644\\u0625\\u0634\\u062a\\u0631\\u0627\\u0643 \\u0628\\u0646\\u062c\\u0627\\u062d","subscribe_newsletter_before":"\\u0627\\u0644\\u0628\\u0631\\u064a\\u062f \\u0627\\u0644\\u0625\\u0644\\u0643\\u062a\\u0631\\u0648\\u0646\\u064a \\u0645\\u0634\\u062a\\u0631\\u0643 \\u0628\\u0627\\u0644\\u0641\\u0639\\u0644!","mail_list":"\\u0642\\u0627\\u0626\\u0645\\u0629 \\u0627\\u0644\\u0628\\u0631\\u064a\\u062f","mail_list_more":"\\u0645\\u0639\\u0644\\u0648\\u0645\\u0627\\u062a \\u0642\\u0627\\u0626\\u0645\\u0629 \\u0627\\u0644\\u0628\\u0631\\u064a\\u062f","more":"\\u0627\\u0642\\u0631\\u0623 \\u0623\\u0643\\u062b\\u0631","no_message":"\\u0644\\u0627 \\u062a\\u0648\\u062c\\u062f \\u0631\\u0633\\u0627\\u0644\\u0629 \\u062a\\u0631\\u0633\\u0644!"},"en":{"head":"News Letters","menuIcon":"fas fa-newspaper","new":"Send new Message","email":"The email","send_to":"Send to","all":"All","select":"Select","subject":"Subject of Newsletters","message":"Message of Newsletters","categories":"Select Categories","email_success":"Newsletter send successfully","newsletter_subscribe_success":"Subscribe in newsletter successfully","subscribe_newsletter_before":"Email subscribed already!","mail_list":"Mail list","mail_list_more":"Mail list Information","more":"Read more","no_message":"No message send !"}}}', NULL, NULL, NULL),
	(38, 'visitorMessages', 'visitorMessages', '{"module_name":{"ar":" \\u0627\\u062a\\u0635\\u0644 \\u0628\\u0646\\u0627 ","en":"visitorMessages"},"fields":{"ar":{"head":"\\u0631\\u0633\\u0627\\u0626\\u0644 \\u0627\\u0644\\u0632\\u0648\\u0627\\u0631","menuIcon":"fas fa-envelope","new":"\\u0627\\u0644\\u0631\\u062f \\u0639\\u0644\\u0649 \\u0631\\u0633\\u0627\\u0644\\u0629 \\u062c\\u062f\\u064a\\u062f\\u0629","name":"\\u0627\\u0644\\u0625\\u0633\\u0645","email":"\\u0627\\u0644\\u0628\\u0631\\u064a\\u062f \\u0627\\u0644\\u0625\\u0644\\u0643\\u062a\\u0631\\u0648\\u0646\\u064a","send_to":"\\u0625\\u0631\\u0633\\u0627\\u0644 \\u0625\\u0644\\u0649","from":"\\u0645\\u0646","select":"\\u0625\\u062e\\u062a\\u0631","subject":"\\u0645\\u0648\\u0636\\u0648\\u0639 \\u0627\\u0644\\u0631\\u0633\\u0627\\u0644\\u0629","message":"\\u0627\\u0644\\u0631\\u0633\\u0627\\u0644\\u0629","email_success":"\\u062a\\u0645 \\u0625\\u0631\\u0633\\u0627\\u0644 \\u0627\\u0644\\u0631\\u062f \\u0628\\u0646\\u062c\\u0627\\u062d","phone":"\\u0631\\u0642\\u0645 \\u0627\\u0644\\u062c\\u0648\\u0627\\u0644","message_subject":"\\u0631\\u0633\\u0627\\u0644\\u0629 \\u062c\\u062f\\u064a\\u062f\\u0629 \\u0645\\u0646 \\u0627\\u062d\\u062f \\u0632\\u0648\\u0627\\u0631 \\u0645\\u0648\\u0642\\u0639 :website_name :"},"en":{"head":"Visitor Messages","menuIcon":"fas fa-envelope","new":"Reply new message","name":"The name","email":"The email","send_to":"Send to","from":"From","select":"Select","subject":"Subject of message","message":"The message","email_success":"Reply send successfully","message_subject":"New Message from a visitor of :website_name website: "}}}', NULL, NULL, NULL),
	(39, 'Services', 'services', '{"module_name":{"ar":"\\u0627\\u0644\\u062e\\u062f\\u0645\\u0627\\u062a","en":"services"},"fields":{"ar":{"add_new":"\\u0627\\u0636\\u0627\\u0641\\u0629 \\u062e\\u062f\\u0645\\u0629 \\u062c\\u062f\\u064a\\u062f","edit":"\\u062a\\u0639\\u062f\\u064a\\u0644 \\u062e\\u062f\\u0645\\u0629","name":"\\u0627\\u0644\\u0627\\u0633\\u0645"},"en":{"add_new":"Add New Service","edit":"Edit Service","name":"The Name"}}}', NULL, NULL, NULL),
	(40, 'careers', 'careers', '{"module_name":{"ar":"\\u0627\\u0644\\u0648\\u0638\\u0627\\u0626\\u0641","en":"works"},"fields":{"ar":{"add_new":"\\u0627\\u0636\\u0627\\u0641\\u0629 \\u0648\\u0638\\u064a\\u0641\\u0629  \\u062c\\u062f\\u064a\\u062f","edit":"\\u062a\\u0639\\u062f\\u064a\\u0644 \\u0648\\u0638\\u064a\\u0641\\u0629 ","name":"2\\u0625\\u0633\\u0645 \\u0627\\u0644\\u0648\\u0638\\u064a\\u0641\\u0629"},"en":{"add_new":"Add New Job","edit":"Edit Job","name":"Job Title2"}}}', NULL, NULL, NULL),
	(41, 'VisitorJobs', 'visitorJobs', '{"module_name":{"ar":"\\u0637\\u0644\\u0628\\u0627\\u062a \\u0627\\u0644\\u0648\\u0638\\u0627\\u0626\\u0641","en":"visitorJobs"},"fields":{"ar":{"new":"\\u0625\\u0636\\u0627\\u0641\\u0629 \\u0648\\u0638\\u064a\\u0641\\u0629 \\u062c\\u062f\\u064a\\u062f\\u0629","edit":"\\u062a\\u0639\\u062f\\u064a\\u0644 \\u0648\\u0638\\u064a\\u0641\\u0629","title":"\\u0627\\u0633\\u0645 \\u0627\\u0644\\u0648\\u0638\\u064a\\u0641\\u0629","apply":"\\u0627\\u0644\\u062a\\u0642\\u062f\\u064a\\u0645 \\u0639\\u0644\\u0649 \\u0627\\u0644\\u0648\\u0638\\u064a\\u0641\\u0629","show_available":"\\u062a\\u0635\\u0641\\u062d \\u0627\\u0644\\u0648\\u0638\\u0627\\u0626\\u0641 \\u0627\\u0644\\u0645\\u062a\\u0627\\u062d\\u0629","name":"\\u0627\\u0633\\u0645 \\u0645\\u0642\\u062f\\u0645 \\u0627\\u0644\\u0637\\u0644\\u0628","email":"\\u0627\\u0644\\u0628\\u0631\\u064a\\u062f \\u0627\\u0644\\u0625\\u0644\\u0643\\u062a\\u0631\\u0648\\u0646\\u064a","phone":"\\u0631\\u0642\\u0645 \\u0627\\u0644\\u062a\\u0648\\u0627\\u0635\\u0644","notes":"\\u0627\\u0644\\u0645\\u0644\\u0627\\u062d\\u0638\\u0627\\u062a","cv":"\\u0627\\u0644\\u0633\\u064a\\u0631\\u0629 \\u0627\\u0644\\u0630\\u0627\\u062a\\u064a\\u0629","career_id":"\\u0627\\u0644\\u0648\\u0638\\u064a\\u0641\\u0629","allowed_files":"\\u0627\\u0644\\u0645\\u0644\\u0641\\u0627\\u062a \\u0627\\u0644\\u0645\\u062f\\u0639\\u0648\\u0645\\u0629 => PDF \\u0648\\u0644\\u0627 \\u064a\\u062a\\u0639\\u062f\\u0649 \\u062d\\u062c\\u0645\\u0647\\u0627 2 MB","form_title":"\\u0646\\u0645\\u0648\\u0630\\u062c \\u0637\\u0644\\u0628 \\u062a\\u0648\\u0638\\u064a\\u0641","form":"\\u0627\\u0633\\u062a\\u0645\\u0627\\u0631\\u0629"},"en":{"new":"Add New Job","edit":"Edit Job","title":"Job Title","apply":"Apply for Job","show_available":"Browse Available Jobs","name":"Applicant Name","email":"Email Address","phone":"Phone Number","notes":"Notes","cv":"CV","career_id":"Job","allowed_files":"Supported files => PDF, max size 2 MB","form_title":"Employment Application Form","form":"Form"}}}', NULL, NULL, NULL);

-- Dumping structure for table income_db.newsletters
CREATE TABLE IF NOT EXISTS `newsletters` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table income_db.newsletters: ~9 rows (approximately)
INSERT INTO `newsletters` (`id`, `email`, `deleted_at`, `created_at`, `updated_at`) VALUES
	(12, 'yomna@yahoo.com', NULL, '2024-07-26 21:13:54', '2024-07-26 21:13:54'),
	(13, 'ahmed@gghh.com', NULL, '2024-07-28 08:08:41', '2024-07-28 08:08:41'),
	(14, 'yomn2a@yahoo.com', NULL, '2024-07-28 08:16:10', '2024-07-28 08:16:10'),
	(15, 'aboro2a83@gmail.com', NULL, '2024-07-28 08:26:31', '2024-07-28 08:26:31'),
	(16, 'yomna3@yahoo.com', NULL, '2024-07-28 08:27:36', '2024-07-28 08:27:36'),
	(17, 'abo888ro2a83@gmail.com', NULL, '2024-07-28 08:31:23', '2024-07-28 08:31:23'),
	(18, 'mah_zanaty@yahoo.com', NULL, '2024-07-28 08:32:15', '2024-07-28 08:32:15'),
	(19, 'test@testt.com', NULL, '2024-07-28 18:33:16', '2024-07-28 18:33:16'),
	(20, 'mah@yahoo.com', NULL, '2024-07-28 18:35:33', '2024-07-28 18:35:33');

-- Dumping structure for table income_db.numbers
CREATE TABLE IF NOT EXISTS `numbers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `counter` bigint(20) DEFAULT NULL,
  `image` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table income_db.numbers: ~3 rows (approximately)
INSERT INTO `numbers` (`id`, `counter`, `image`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, 15, 'storage/photos/shares/statics-2.svg', '2024-07-18 07:53:12', '2024-07-25 17:04:42', NULL),
	(2, 500, 'storage/photos/shares/statics-1.svg', '2024-07-21 08:28:38', '2024-07-25 17:04:03', NULL),
	(3, 20, 'storage/photos/shares/statics-3.svg', '2024-07-25 13:08:12', '2024-07-29 20:45:51', NULL);

-- Dumping structure for table income_db.number_descriptions
CREATE TABLE IF NOT EXISTS `number_descriptions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(150) DEFAULT NULL,
  `number_id` bigint(20) unsigned DEFAULT NULL,
  `language_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `number_descriptions_number_id_index` (`number_id`),
  KEY `number_descriptions_language_id_index` (`language_id`),
  CONSTRAINT `number_descriptions_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `number_descriptions_number_id_foreign` FOREIGN KEY (`number_id`) REFERENCES `numbers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table income_db.number_descriptions: ~6 rows (approximately)
INSERT INTO `number_descriptions` (`id`, `title`, `number_id`, `language_id`) VALUES
	(13, 'عميل', 2, 1),
	(14, 'client', 2, 2),
	(25, 'موقع', 1, 1),
	(26, 'location', 1, 2),
	(27, 'تطبيق جوال', 3, 1),
	(28, 'mobileApp', 3, 2);

-- Dumping structure for table income_db.pages
CREATE TABLE IF NOT EXISTS `pages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(200) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `image_2` varchar(150) DEFAULT NULL,
  `image_3` varchar(150) DEFAULT NULL,
  `image_4` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table income_db.pages: ~7 rows (approximately)
INSERT INTO `pages` (`id`, `image`, `status`, `deleted_at`, `created_at`, `updated_at`, `image_2`, `image_3`, `image_4`) VALUES
	(2, 'storage/photos/shares/c.jpg', 1, NULL, '2024-04-14 10:02:46', '2024-05-20 08:53:48', NULL, NULL, NULL),
	(3, NULL, 1, NULL, '2024-04-14 10:03:22', '2024-05-22 06:02:19', NULL, NULL, NULL),
	(5, NULL, 1, NULL, '2024-04-14 10:04:15', '2024-04-14 10:04:15', NULL, NULL, NULL),
	(6, NULL, 1, NULL, '2024-04-14 10:04:54', '2024-04-14 10:04:54', NULL, NULL, NULL),
	(7, NULL, 1, NULL, '2024-04-14 10:05:13', '2024-04-14 10:05:13', NULL, NULL, NULL),
	(9, NULL, 1, NULL, '2024-04-14 10:05:49', '2024-07-29 20:43:41', NULL, NULL, NULL),
	(10, 'storage/photos/shares/6.jpg', 1, '2024-07-29 20:29:02', '2024-04-14 10:05:49', '2024-05-22 09:16:12', 'storage/photos/shares/test.PNG', 'storage/photos/shares/test2.PNG', NULL);

-- Dumping structure for table income_db.page_descriptions
CREATE TABLE IF NOT EXISTS `page_descriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `slug` varchar(100) DEFAULT NULL,
  `meta_description` text NOT NULL,
  `keywords` varchar(400) NOT NULL,
  `description` longtext NOT NULL,
  `page_id` bigint(20) unsigned DEFAULT NULL,
  `language_id` bigint(20) unsigned DEFAULT NULL,
  `vision` longtext DEFAULT NULL,
  `message` longtext DEFAULT NULL,
  `value` longtext DEFAULT NULL,
  `goal` text DEFAULT NULL,
  `brief` longtext DEFAULT NULL,
  `no1` text DEFAULT NULL,
  `no2` text DEFAULT NULL,
  `no3` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `page_descriptions_page_id_foreign` (`page_id`),
  KEY `page_descriptions_language_id_foreign` (`language_id`),
  CONSTRAINT `page_descriptions_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE,
  CONSTRAINT `page_descriptions_page_id_foreign` FOREIGN KEY (`page_id`) REFERENCES `pages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=497 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table income_db.page_descriptions: ~12 rows (approximately)
INSERT INTO `page_descriptions` (`id`, `title`, `slug`, `meta_description`, `keywords`, `description`, `page_id`, `language_id`, `vision`, `message`, `value`, `goal`, `brief`, `no1`, `no2`, `no3`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(357, 'ارقامنا', 'ارقامنا', 'ارقامنا', 'ارقامنا', '', 10, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(358, 'our Numbers', 'our Numbers', 'our Numbers', 'our Numbers', '', 10, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(483, 'رئيس مجلس الادارة', 'رئيس مجلس الادارة', 'رئيس مجلس الادارة', 'رئيس مجلس الادارة', '<div>\r\n<section>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<h5>أكبر من حصولك على تصميم موقع أو انشاء متجر الكتروني لا يعرفه أحد !!. نحن نعمل على إدارة العلامة التجارية لشركتك باحترافية. من تصميم الهوية، تبويب مؤسسة سعودية متخصصة في مجال تصميم البرمجيات الخاصة وحلول الفوترة الإلكترونية ونظم المال والأعمال وتصميم مواقع الويب وتطبيقات الهواتف الذكية.</h5>\r\n<h5>هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز على الشكل الخارجي للنص أو شكل توضع الفقرات في الصفحة التي يقرأها. ولذلك يتم استخدام طريقة لوريم إيبسوم لأنها تعطي توزيعاَ طبيعياَ -إلى حد ما- للأحرف عوضاً عن استخدام "هنا يوجد محتوى نصي، هنا يوجد محتوى نصي" فتجعلها تبدو (أي الأحرف) وكأنها نص مقروء. العديد من برامح النشر المكتبي وبرامح تحرير صفحات الويب تستخدم لوريم إيبسوم بشكل إفتراضي كنموذج عن النص، وإذا قمت بإدخال "lorem ipsum" في أي محرك بحث ستظهر العديد من المواقع الحديثة العهد في نتائج البحث. على مدى السنين ظهرت نسخ جديدة ومختلفة من نص لوريم إيبسوم، أحياناً عن طريق الصدفة، وأحياناً عن عمد كإدخال بعض العبارات الفكاهية إليها.</h5>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</section>\r\n<footer>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<h5>&nbsp;</h5>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</footer></div>', 6, 1, '', '', '', '', '', '', '', '', NULL, NULL, NULL),
	(484, 'Chairman of the Board of directors', 'Chairman of the Board of directors', 'Chairman of the Board of directors', 'Chairman of the Board of directors', '<div class="sec_head mb-4">\r\n<h6 class="color-primary">Greater than getting a website design or creating an online store that no one knows!! We work on managing your company\'s brand professionally. From identity design, Taboo is a Saudi institution specialized in designing special software, electronic billing solutions, financial and business systems, designing websites and smart phone applications. There is a long-established fact that the readable content of a page will distract the reader from focusing on the external appearance of the text or the form of the paragraphs placed on the page he is reading. Therefore, the Lorem Ipsum method is used because it gives a natural distribution - to some extent - of letters instead of using "Here is text content, here is text content", making it look (i.e. the letters) like readable text. Many desktop publishing programs and web page editing programs use Lorem Ipsum by default as a model text, and if you enter "lorem ipsum" into any search engine, many modern websites will appear in the search results. Various versions of Lorem Ipsum have appeared over the years, sometimes by accident, sometimes on purpose (such as injected humour and the like).</h6>\r\n</div>', 6, 2, '', '', '', '', '', '', '', '', NULL, NULL, NULL),
	(485, 'من نحن', 'من نحن', 'من نحن', 'من نحن', '<h5 style="text-align: right;">تبويب مؤسسة سعودية متخصصة في مجال تصميم البرمجيات الخاصة وحلول الفوترة الإلكترونية ونظم المال والأعمال وتصميم مواقع الويب وتطبيقات الهواتف الذكية.</h5>\r\n<h5 style="text-align: right;">أكبر من حصولك على تصميم موقع أو انشاء متجر الكتروني لا يعرفه أحد !!. نحن نعمل على إدارة العلامة التجارية لشركتك باحترافية. من تصميم الهوية، أكبر من حصولك على تصميم موقع أو انشاء متجر الكتروني لا يعرفه أحد !!. نحن نعمل على إدارة العلامة التجارية لشركتك باحترافية. من تصميم الهوية،</h5>\r\n<h5 style="text-align: right;">تبويب مؤسسة سعودية متخصصة في مجال تصميم البرمجيات الخاصة وحلول الفوترة الإلكترونية ونظم المال والأعمال وتصميم مواقع الويب وتطبيقات الهواتف الذكية.</h5>', 2, 1, '', '', '', '', '<p style="text-align: right;"><strong>تبويب مؤسسة سعودية متخصصة في مجال تصميم البرمجيات الخاصة وحلول الفوترة الإلكترونية ونظم المال والأعمال وتصميم مواقع الويب وتطبيقات الهواتف الذكية.</strong></p>', '', '', '', NULL, NULL, NULL),
	(486, 'About Us', 'About Us', 'About Us', 'About Us', '<p>Tabweeb is a Saudi institution specialized in the field of designing special software, electronic billing solutions, financial and business systems, designing websites and smart phone applications.<br />Better than getting a website design or creating an online store that no one knows!!. We work on managing your company\'s brand professionally. From identity design, Better than getting a website design or creating an online store that no one knows!!. We work on managing your company\'s brand professionally. From identity design,<br />Tabweeb is a Saudi institution specialized in the field of designing special software, electronic billing solutions, financial and business systems, designing websites and smart phone applications.</p>', 2, 2, '', '', '', '', '<p>Taboo is a Saudi institution specialized in designing special software, electronic billing solutions, financial and business systems, designing websites, and smart phone applications.</p>', '', '', '', NULL, NULL, NULL),
	(487, 'بطاقات الرؤية والرسالة والاهداف والقيم', 'بطاقات الرؤية والرسالة والاهداف والقيم', 'بطاقات الرؤية والرسالة والاهداف والقيم', 'بطاقات الرؤية والرسالة والاهداف والقيم', '', 3, 1, '<div class="col-lg-4">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="p" style="text-align: center;">\r\n<div class="col-lg-4">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="p">\r\n<div class="col-lg-4">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="p">\r\n<p style="text-align: right;">أكبر من حصولك على تصميم موقع أو انشاء متجر</p>\r\n<p style="text-align: right;">الكتروني لا يعرفه أحد !!. نحن نعمل على إدارة العلامة</p>\r\n<p style="text-align: right;">التجارية لشركتك باحترافية. من تصميم الهوية، أكبر من حصولك</p>\r\n<p style="text-align: right;">العلامة التجارية لشركتك باحترافية. من تصميم الهوية،</p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n<div class="col-lg-4" style="text-align: right;">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="d-flex align-items-center mb-4">\r\n<div class="icon_box">&nbsp;</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n<h5 style="text-align: right;">&nbsp;</h5>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n<div class="col-lg-4">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="d-flex align-items-center mb-4">\r\n<h5 class="icon_box" style="text-align: right;">&nbsp;</h5>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>', '<div class="col-lg-4">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="p" style="text-align: right;">\r\n<div class="col-lg-4">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="p">\r\n<div class="col-lg-4">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="p" style="text-align: center;">\r\n<div class="col-lg-4">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="p">\r\n<div class="col-lg-4">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="p">\r\n<p style="text-align: right;">أكبر من حصولك على تصميم موقع أو انشاء متجر</p>\r\n<p style="text-align: right;">الكتروني لا يعرفه أحد !!. نحن نعمل على إدارة العلامة</p>\r\n<p style="text-align: right;">التجارية لشركتك باحترافية. من تصميم الهوية، أكبر من حصولك</p>\r\n<p style="text-align: right;">العلامة التجارية لشركتك باحترافية. من تصميم الهوية،</p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n<div class="col-lg-4" style="text-align: right;">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="d-flex align-items-center mb-4">\r\n<div class="icon_box">&nbsp;</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n<h5 style="text-align: right;">&nbsp;</h5>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n<div class="col-lg-4">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="d-flex align-items-center mb-4">\r\n<h5 class="icon_box" style="text-align: right;">&nbsp;</h5>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n<div class="col-lg-4">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="d-flex align-items-center mb-4">\r\n<div class="icon_box">&nbsp;</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n<div class="col-lg-4">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="d-flex align-items-center mb-4">\r\n<div class="icon_box" style="text-align: right;">&nbsp;</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>', '', '<section class="about_cards section">\r\n<div class="container">\r\n<div class="row">\r\n<div class="col-lg-4">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="p" style="text-align: right;">\r\n<div class="col-lg-4">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="p">\r\n<div class="col-lg-4">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="p" style="text-align: center;">\r\n<div class="col-lg-4">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="p">\r\n<div class="col-lg-4">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="p">\r\n<p style="text-align: right;">أكبر من حصولك على تصميم موقع أو انشاء متجر</p>\r\n<p style="text-align: right;">الكتروني لا يعرفه أحد !!. نحن نعمل على إدارة العلامة</p>\r\n<p style="text-align: right;">التجارية لشركتك باحترافية. من تصميم الهوية، أكبر من حصولك</p>\r\n<p style="text-align: right;">العلامة التجارية لشركتك باحترافية. من تصميم الهوية،</p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n<div class="col-lg-4" style="text-align: right;">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="d-flex align-items-center mb-4">\r\n<div class="icon_box">&nbsp;</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n<h5 style="text-align: right;">&nbsp;</h5>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n<div class="col-lg-4">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="d-flex align-items-center mb-4">\r\n<h5 class="icon_box" style="text-align: right;">&nbsp;</h5>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</section>', '', '', '', '', NULL, NULL, NULL),
	(488, 'Vision Cards, Message, Goals and Values', 'Vision Cards, Message, Goals and Values', 'Vision Cards, Message, Goals and Values', 'Vision Cards, Message, Goals and Values', '', 3, 2, '<p>It is more than getting a website design or creating an online store that no one knows about!! We work on managing your company\'s brand professionally. From identity design, it is more than getting your company\'s brand professionally. From identity design,</p>', '<p>It is more than getting a website design or creating an online store that no one knows about!! We work on managing your company\'s brand professionally. From identity design, it is more than getting your company\'s brand professionally. From identity design,</p>', '', '<p>It is more than getting a website design or creating an online store that no one knows about!! We work on managing your company\'s brand professionally. From identity design, it is more than getting your company\'s brand professionally. From identity design,</p>', '', '', '', '', NULL, NULL, NULL),
	(491, 'الشروط والاحكام', 'الشروط والاحكام', 'الشروط والاحكام', 'الشروط والاحكام', '<p style="text-align: right;">هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز على الشكل الخارجي للنص أو شكل توضع الفقرات في الصفحة التي يقرأها. ولذلك يتم استخدام طريقة لوريم إيبسوم لأنها تعطي توزيعاَ طبيعياَ -إلى حد ما- للأحرف عوضاً عن استخدام "هنا يوجد محتوى نصي، هنا يوجد محتوى نصي" فتجعلها تبدو (أي الأحرف) وكأنها نص مقروء. العديد من برامح النشر المكتبي وبرامح تحرير صفحات الويب تستخدم لوريم إيبسوم بشكل إفتراضي كنموذج عن النص، وإذا قمت بإدخال "lorem ipsum" في أي محرك بحث ستظهر العديد من المواقع الحديثة العهد في نتائج البحث. على مدى السنين ظهرت نسخ جديدة ومختلفة من نص لوريم إيبسوم، أحياناً عن طريق الصدفة، وأحياناً عن عمد كإدخال بعض العبارات الفكاهية إليها.</p>\r\n<p style="text-align: right;">هنالك العديد من الأنواع المتوفرة لنصوص لوريم إيبسوم، ولكن الغالبية تم تعديلها بشكل ما بعض النوادر أو الكلمات العشوائية إلى النص. إن</p>\r\n<p style="text-align: right;">&nbsp;كنت تريد أن تستخدم نص لوريم إيبسوم ما، عليك أن تتحقق أولاً أن ليس هناك أي كلمات أو عبارات محرجة أو غير لائقة مخبأة في هذا النص. بينما تعمل</p>\r\n<p style="text-align: right;">جميع مولّدات نصوص لوريم إيبسوم على الإنترنت على إعادة تكرار مقاطع من نص لوريم إيبسوم نفسه عدة مرات بما تتطلبه الحاجة، يقوم مولّدنا هذا</p>\r\n<p style="text-align: right;">&nbsp;باستخدام كلمات من قاموس يحوي على أكثر من 200 كلمة لا تينية، مضاف إليها مجموعة من الجمل النموذجية، لتكوين نص لوريم إيبسوم ذو شكل</p>\r\n<p style="text-align: right;">&nbsp;منطقي قريب إلى النص الحقيقي. وبالتالي يكون النص الناتح خالي من التكرار، أو أي كلمات أو عبارات غير لائقة أو ما شابه. وهذا ما يجعله أول مولّد نص</p>\r\n<p style="text-align: right;">&nbsp;لوريم إيبسوم حقيقي على الإنترنت .اكبر من حصولك على تصميم موقع أو انشاء متجر الكتروني لا يعرفه أحد !!.&nbsp; نحن نعمل على إدارة العلامة التجارية</p>\r\n<p style="text-align: right;">&nbsp;لشركتك باحترافية. من تصميم الهوية،تبويب مؤسسة سعودية متخصصة في مجال تصميم البرمجيات الخاصة وحلول الفوترة الإلكترونية ونظم المال</p>\r\n<p style="text-align: right;">والأعمال وتصميم مواقع الويب وتطبيقات الهواتف الذكية.</p>', 5, 1, '', '', '', '', '', '', '', '', NULL, NULL, NULL),
	(492, 'Terms And Conditions', 'Terms And Conditions', 'Terms And Conditions', 'Terms And Conditions', '<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many new web sites in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like). There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, injected humour, or randomised words which don\'t look even slightly believable. If</p>\r\n<p>you want to use a Lorem Ipsum text, you need to first check that there aren\'t any embarrassing or inappropriate words or phrases hidden in the middle of text. While</p>\r\n<p>all the Lorem Ipsum generators on the Internet re-create chunks of the same Lorem Ipsum text as necessary, this one</p>\r\n<p>uses words from a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum text that looks</p>\r\n<p>logically close to the real text. The resulting text is therefore free of repetition, inappropriate words or phrases, etc. This makes it the first real</p>\r\n<p>Lorem Ipsum generator on the Internet. Greater than getting a website design or creating an online store that no one knows!! We work on managing the brand</p>\r\n<p>of your company professionally. From identity design, Tabweb is a Saudi company specialized in designing special software, electronic billing solutions, financial systems, business, and designing websites and smart phone applications.</p>', 5, 2, '', '', '', '', '', '', '', '', NULL, NULL, NULL),
	(493, 'سياسة الخصوصية2', 'سياسة الخصوصية', 'سياسة الخصوصية', 'سياسة الخصوصية', '<p style="text-align: right;">2هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز على الشكل الخارجي للنص أو شكل توضع الفقرات في الصفحة التي يقرأها. ولذلك يتم استخدام طريقة لوريم إيبسوم لأنها تعطي توزيعاَ طبيعياَ -إلى حد ما- للأحرف عوضاً عن استخدام "هنا يوجد محتوى نصي، هنا يوجد محتوى نصي" فتجعلها تبدو (أي الأحرف) وكأنها نص مقروء. العديد من برامح النشر المكتبي وبرامح تحرير صفحات الويب تستخدم لوريم إيبسوم بشكل إفتراضي كنموذج عن النص، وإذا قمت بإدخال "lorem ipsum" في أي محرك بحث ستظهر العديد من المواقع الحديثة العهد في نتائج البحث. على مدى السنين ظهرت نسخ جديدة ومختلفة من نص لوريم إيبسوم، أحياناً عن طريق الصدفة، وأحياناً عن عمد كإدخال بعض العبارات الفكاهية إليها.</p>\r\n<p style="text-align: right;">هنالك العديد من الأنواع المتوفرة لنصوص لوريم إيبسوم، ولكن الغالبية تم تعديلها بشكل ما بعض النوادر أو الكلمات العشوائية إلى النص. إن</p>\r\n<p style="text-align: right;">&nbsp;كنت تريد أن تستخدم نص لوريم إيبسوم ما، عليك أن تتحقق أولاً أن ليس هناك أي كلمات أو عبارات محرجة أو غير لائقة مخبأة في هذا النص. بينما تعمل</p>\r\n<p style="text-align: right;">جميع مولّدات نصوص لوريم إيبسوم على الإنترنت على إعادة تكرار مقاطع من نص لوريم إيبسوم نفسه عدة مرات بما تتطلبه الحاجة، يقوم مولّدنا هذا</p>\r\n<p style="text-align: right;">&nbsp;باستخدام كلمات من قاموس يحوي على أكثر من 200 كلمة لا تينية، مضاف إليها مجموعة من الجمل النموذجية، لتكوين نص لوريم إيبسوم ذو شكل</p>\r\n<p style="text-align: right;">&nbsp;منطقي قريب إلى النص الحقيقي. وبالتالي يكون النص الناتح خالي من التكرار، أو أي كلمات أو عبارات غير لائقة أو ما شابه. وهذا ما يجعله أول مولّد نص</p>\r\n<p style="text-align: right;">&nbsp;لوريم إيبسوم حقيقي على الإنترنت .اكبر من حصولك على تصميم موقع أو انشاء متجر الكتروني لا يعرفه أحد !!.&nbsp; نحن نعمل على إدارة العلامة التجارية</p>\r\n<p style="text-align: right;">&nbsp;لشركتك باحترافية. من تصميم الهوية،تبويب مؤسسة سعودية متخصصة في مجال تصميم البرمجيات الخاصة وحلول الفوترة الإلكترونية ونظم المال</p>\r\n<p style="text-align: right;">والأعمال وتصميم مواقع الويب وتطبيقات الهواتف الذكية.</p>', 7, 1, '', '', '', '', '', '', '', '', NULL, NULL, NULL),
	(494, 'Privacy Policy', 'Privacy Policy', 'Privacy Policy', 'Privacy Policy', '<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many new web sites in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like). There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, injected humour, or randomised words which don\'t look even slightly believable. If</p>\r\n<p>you want to use a Lorem Ipsum text, you need to first check that there aren\'t any embarrassing or inappropriate words or phrases hidden in the middle of text. While</p>\r\n<p>all the Lorem Ipsum generators on the Internet re-create chunks of the same Lorem Ipsum text as necessary, this one</p>\r\n<p>uses words from a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum text that looks</p>\r\n<p>logically close to the real text. The resulting text is therefore free of repetition, inappropriate words or phrases, etc. This makes it the first real</p>\r\n<p>Lorem Ipsum generator on the Internet. Greater than getting a website design or creating an online store that no one knows!! We work on managing the brand</p>\r\n<p>of your company professionally. From identity design, Tabweb is a Saudi company specialized in designing special software, electronic billing solutions, financial systems, business, and designing websites and smart phone applications.</p>', 7, 2, '', '', '', '', '', '', '', '', NULL, NULL, NULL),
	(495, 'النبذة الخاصة بالفوتر', 'https://ahg.omar.alyomhost.org/', 'النبذة الخاصة بالفوتر', 'النبذة الخاصة بالفوتر', '<p><!-- pagebreak -->جعلت إدارتنا القوية من أولوياتنا القصوى جذب المواهب والاحتفاظ بها بمهارات مهنية عالية في مختلف المجالات.</p>', 9, 1, '', '', '', '', '', '', '', '', NULL, NULL, NULL),
	(496, 'Profile of footer', 'https://ahg.omar.alyomhost.org/', 'Profile of footer', 'Profile of footer', '<p>Our strong management is our top priority Attracting professional talents High retention of skills Various fields.<br /><br /></p>', 9, 2, '', '', '', '', '', '', '', '', NULL, NULL, NULL);

-- Dumping structure for table income_db.partners
CREATE TABLE IF NOT EXISTS `partners` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table income_db.partners: ~6 rows (approximately)
INSERT INTO `partners` (`id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, '2024-07-26 07:21:53', '2024-07-26 07:21:53', NULL),
	(2, '2024-07-26 07:23:12', '2024-07-26 07:23:12', NULL),
	(3, '2024-07-26 07:23:57', '2024-07-26 07:23:57', NULL),
	(4, '2024-07-26 07:24:31', '2024-07-26 07:24:31', NULL),
	(5, '2024-07-26 08:10:41', '2024-07-28 09:52:49', NULL),
	(6, '2024-07-26 08:15:58', '2024-07-28 09:46:33', NULL);

-- Dumping structure for table income_db.partner_descriptions
CREATE TABLE IF NOT EXISTS `partner_descriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(150) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `partner_id` bigint(20) unsigned DEFAULT NULL,
  `language_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `partner_descriptions_partner_id_foreign` (`partner_id`),
  KEY `partner_descriptions_language_id_foreign` (`language_id`),
  CONSTRAINT `partner_descriptions_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `partner_descriptions_partner_id_foreign` FOREIGN KEY (`partner_id`) REFERENCES `partners` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table income_db.partner_descriptions: ~6 rows (approximately)
INSERT INTO `partner_descriptions` (`id`, `title`, `description`, `partner_id`, `language_id`, `created_at`, `updated_at`) VALUES
	(1, 'مؤسسة ينابع الحلول لتقنية المعلومات', NULL, 1, 1, NULL, NULL),
	(2, 'امازون', NULL, 2, 1, NULL, NULL),
	(3, 'جوجل كلود', NULL, 3, 1, NULL, NULL),
	(4, 'ليزر', NULL, 4, 1, NULL, NULL),
	(5, 'مؤسسة ينابع الحلول لتقنية المعلومات 2', NULL, 5, 1, NULL, NULL),
	(6, 'امازون', NULL, 6, 1, NULL, NULL);

-- Dumping structure for table income_db.partner_photos
CREATE TABLE IF NOT EXISTS `partner_photos` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(250) DEFAULT NULL,
  `partner_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `partner_photos_partner_id_foreign` (`partner_id`),
  CONSTRAINT `partner_photos_partner_id_foreign` FOREIGN KEY (`partner_id`) REFERENCES `partners` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table income_db.partner_photos: ~6 rows (approximately)
INSERT INTO `partner_photos` (`id`, `image`, `partner_id`, `created_at`, `updated_at`) VALUES
	(1, 'storage/photos/shares/partner-1.svg', 1, NULL, NULL),
	(2, 'storage/photos/shares/partner-2.svg', 2, NULL, NULL),
	(3, 'storage/photos/shares/partner-3.svg', 3, NULL, NULL),
	(4, 'storage/photos/shares/partner-4.svg', 4, NULL, NULL),
	(5, 'storage/photos/shares/partner-1.svg', 5, NULL, NULL),
	(6, 'storage/photos/shares/partner-2.svg', 6, NULL, NULL);

-- Dumping structure for table income_db.password_reset_tokens
CREATE TABLE IF NOT EXISTS `password_reset_tokens` (
  `email` varchar(191) NOT NULL,
  `token` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table income_db.password_reset_tokens: ~0 rows (approximately)

-- Dumping structure for table income_db.personal_access_tokens
CREATE TABLE IF NOT EXISTS `personal_access_tokens` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(191) NOT NULL,
  `tokenable_id` bigint(20) unsigned NOT NULL,
  `name` varchar(191) NOT NULL,
  `token` varchar(64) NOT NULL,
  `abilities` text DEFAULT NULL,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table income_db.personal_access_tokens: ~0 rows (approximately)

-- Dumping structure for table income_db.photos
CREATE TABLE IF NOT EXISTS `photos` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `youtube_url` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `photo_category_id` bigint(20) unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `photos_photo_category_id_index` (`photo_category_id`),
  CONSTRAINT `photos_photo_category_id_foreign` FOREIGN KEY (`photo_category_id`) REFERENCES `photo_categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table income_db.photos: ~13 rows (approximately)
INSERT INTO `photos` (`id`, `image`, `youtube_url`, `photo_category_id`, `deleted_at`, `created_at`, `updated_at`) VALUES
	(9, 'storage/photos/shares/service_det.jpg', '0', 7, NULL, '2024-07-26 09:01:38', '2024-07-27 09:01:38'),
	(11, 'storage/photos/shares/ceo-1.jpg', '0', 9, NULL, '2024-07-26 09:19:41', '2024-07-27 09:19:41'),
	(12, 'storage/photos/shares/3.jpg', '0', 10, NULL, '2024-07-27 10:20:32', '2024-07-27 10:20:32'),
	(13, 'storage/photos/shares/800px-Sunflower_from_Silesia2.jpg', '0', 11, NULL, '2024-07-27 10:22:03', '2024-07-27 10:22:03'),
	(14, 'storage/photos/shares/photo_2024-07-14_16-47-11.jpg', 'https://www.youtube.com/watch?v=mkggXE5e2yk', 12, NULL, '2024-07-27 10:24:30', '2024-07-27 10:24:30'),
	(16, 'storage/photos/shares/about-1.png', 'https://www.youtube.com/watch?v=mkggXE5e2yk', 16, NULL, '2024-07-27 12:36:49', '2024-07-27 12:36:49'),
	(17, 'storage/photos/shares/about-1.png', 'https://www.youtube.com/watch?v=mkggXE5e2yk', 17, NULL, '2024-07-27 12:38:01', '2024-07-27 12:38:01'),
	(18, 'storage/photos/shares/about-1.png', 'https://www.youtube.com/watch?v=mkggXE5e2yk', 18, NULL, '2024-07-27 12:39:04', '2024-07-27 12:39:04'),
	(20, 'storage/photos/shares/about-1.png', 'https://www.youtube.com/watch?v=mkggXE5e2yk', 20, NULL, '2024-07-27 12:40:55', '2024-07-27 12:40:55'),
	(21, 'storage/photos/shares/4.jpg', 'https://www.youtube.com/watch?v=mkggXE5e2yk', NULL, NULL, '2024-07-27 12:43:57', '2024-07-27 12:43:57'),
	(23, 'storage/photos/shares/370632485_122126490164002835_7814470262877211187_n.jpg', 'https://www.youtube.com/watch?v=mkggXE5e2yk', 13, NULL, '2024-07-27 12:48:00', '2024-07-27 12:48:00'),
	(25, 'storage/photos/shares/22222.jpg', 'https://www.youtube.com/watch?v=mkggXE5e2yk', 14, NULL, '2024-07-27 12:56:50', '2024-07-27 12:56:50'),
	(26, 'storage/photos/shares/27503686_150287739101270_9041139970018360027_o.jpg', 'https://www.youtube.com/watch?v=mkggXE5e2yk', 15, NULL, '2024-07-27 12:58:43', '2024-07-27 12:58:43'),
	(27, 'storage/photos/shares/6.jpg', 'https://www.youtube.com/watch?v=mkggXE5e2yk', 19, NULL, '2024-07-30 11:55:44', '2024-07-30 11:55:44');

-- Dumping structure for table income_db.photo_categories
CREATE TABLE IF NOT EXISTS `photo_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `show_in` tinyint(4) DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table income_db.photo_categories: ~13 rows (approximately)
INSERT INTO `photo_categories` (`id`, `show_in`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(7, 1, '2024-07-27 09:01:38', '2024-07-27 09:01:38', NULL),
	(9, 1, '2024-07-27 09:19:40', '2024-07-27 09:19:40', NULL),
	(10, 1, '2024-07-27 10:20:32', '2024-07-27 10:20:32', NULL),
	(11, 1, '2024-07-27 10:22:03', '2024-07-27 10:22:03', NULL),
	(12, 2, '2024-07-27 10:24:29', '2024-07-28 10:24:29', NULL),
	(13, 2, '2024-07-27 12:34:31', '2024-07-27 12:34:31', NULL),
	(14, 2, '2024-07-27 12:35:49', '2024-07-27 12:35:49', NULL),
	(15, 2, '2024-07-27 12:36:22', '2024-07-27 12:36:22', NULL),
	(16, 2, '2024-07-27 12:36:49', '2024-07-27 12:36:49', NULL),
	(17, 2, '2024-07-27 12:38:01', '2024-07-27 12:38:01', NULL),
	(18, 2, '2024-07-27 12:39:03', '2024-07-27 12:39:03', NULL),
	(19, 2, '2024-07-27 12:39:48', '2024-07-30 11:18:07', NULL),
	(20, 2, '2024-07-27 12:40:55', '2024-07-30 11:18:02', NULL);

-- Dumping structure for table income_db.photo_category_descriptions
CREATE TABLE IF NOT EXISTS `photo_category_descriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `slug` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `photo_category_id` bigint(20) unsigned DEFAULT NULL,
  `language_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `photo_category_descriptions_language_id_foreign` (`language_id`),
  KEY `photo_category_descriptions_photo_category_id_language_id_index` (`photo_category_id`,`language_id`),
  CONSTRAINT `photo_category_descriptions_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `photo_category_descriptions_photo_category_id_foreign` FOREIGN KEY (`photo_category_id`) REFERENCES `photo_categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table income_db.photo_category_descriptions: ~24 rows (approximately)
INSERT INTO `photo_category_descriptions` (`id`, `name`, `slug`, `photo_category_id`, `language_id`, `created_at`, `updated_at`) VALUES
	(17, 'اول صوره', NULL, 7, 1, NULL, NULL),
	(18, 'First Image', NULL, 7, 2, NULL, NULL),
	(21, 'ثاني صوره', NULL, 9, 1, NULL, NULL),
	(22, 'Second Image', NULL, 9, 2, NULL, NULL),
	(23, 'ثالث صوره', NULL, 10, 1, NULL, NULL),
	(24, 'third pic', NULL, 10, 2, NULL, NULL),
	(25, 'رابع صوره', NULL, 11, 1, NULL, NULL),
	(26, 'First Image', NULL, 11, 2, NULL, NULL),
	(27, 'الفيديو الاول', NULL, 12, 1, NULL, NULL),
	(28, 'first vedio', NULL, 12, 2, NULL, NULL),
	(33, 'ثالث فيديو', NULL, 16, 1, NULL, NULL),
	(34, 'Application Development', NULL, 16, 2, NULL, NULL),
	(35, 'رابع فيديو', NULL, 17, 1, NULL, NULL),
	(36, 'fourth vedio', NULL, 17, 2, NULL, NULL),
	(37, 'خامس فيديو', NULL, 18, 1, NULL, NULL),
	(38, '5th vedio', NULL, 18, 2, NULL, NULL),
	(41, 'سابع فيديو', NULL, 20, 1, NULL, NULL),
	(42, '7th vedio', NULL, 20, 2, NULL, NULL),
	(47, 'ثاني فيديو', NULL, 13, 1, NULL, NULL),
	(48, 'second vedio', NULL, 13, 2, NULL, NULL),
	(53, 'ثالث فيديو', NULL, 14, 1, NULL, NULL),
	(54, 'web design', NULL, 14, 2, NULL, NULL),
	(55, 'ثالث فيديو', NULL, 15, 1, NULL, NULL),
	(56, 'Application Development', NULL, 15, 2, NULL, NULL),
	(57, 'سادس فيديو', NULL, 19, 1, NULL, NULL),
	(58, '6th vedio', NULL, 19, 2, NULL, NULL);

-- Dumping structure for table income_db.photo_descriptions
CREATE TABLE IF NOT EXISTS `photo_descriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `photo_id` bigint(20) unsigned DEFAULT NULL,
  `language_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `photo_descriptions_language_id_index` (`language_id`),
  KEY `photo_descriptions_photo_id_language_id_index` (`photo_id`,`language_id`),
  CONSTRAINT `photo_descriptions_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE,
  CONSTRAINT `photo_descriptions_photo_id_foreign` FOREIGN KEY (`photo_id`) REFERENCES `photos` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table income_db.photo_descriptions: ~28 rows (approximately)
INSERT INTO `photo_descriptions` (`id`, `title`, `photo_id`, `language_id`) VALUES
	(17, 'عنوان اول صوره', 9, 1),
	(18, 'First Image title', 9, 2),
	(21, 'عنوان ثاني صوره', 11, 1),
	(22, 'ٍSecond Image title', 11, 2),
	(23, 'عنوان ثاني صوره', 12, 1),
	(24, 'ٍSecond Image title', 12, 2),
	(25, 'عنوان ثاني صوره', 13, 1),
	(26, 'ٍSecond Image title', 13, 2),
	(27, 'عنوان اول فيديو', 14, 1),
	(28, 'First vedio title', 14, 2),
	(31, 'عنوان اول صوره', 16, 1),
	(32, 'ٍSecond Image title', 16, 2),
	(33, '11111111111', 17, 1),
	(34, '111111111111', 17, 2),
	(35, '2222222222222', 18, 1),
	(36, '22222222222222', 18, 2),
	(39, '7777777777', 20, 1),
	(40, '7777777777777', 20, 2),
	(41, '8888', 21, 1),
	(42, '8888', 21, 2),
	(45, '2222222222222', 23, 1),
	(46, '22222222222222', 23, 2),
	(49, '3333', 25, 1),
	(50, '3333', 25, 2),
	(51, '33333333', 26, 1),
	(52, '333333333', 26, 2),
	(53, '6666666', 27, 1),
	(54, '6666666666', 27, 2);

-- Dumping structure for table income_db.services
CREATE TABLE IF NOT EXISTS `services` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `icon` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table income_db.services: ~5 rows (approximately)
INSERT INTO `services` (`id`, `image`, `icon`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, 'storage/photos/shares/services-1.svg', 'storage/photos/shares/services-1.svg', '2024-07-26 08:38:05', '2024-07-26 08:38:05', NULL),
	(2, 'storage/photos/shares/service_det.jpg', 'storage/photos/shares/services-2.svg', '2024-07-26 08:43:42', '2024-07-30 21:57:13', NULL),
	(3, 'storage/photos/shares/services-3.svg', 'storage/photos/shares/services-3.svg', '2024-07-26 08:45:26', '2024-07-26 08:45:26', NULL),
	(4, 'storage/photos/shares/services-1.svg', 'storage/photos/shares/services-1.svg', '2024-07-26 08:47:13', '2024-07-29 22:25:51', '2024-07-29 22:25:51'),
	(5, 'storage/photos/shares/services-2.svg', 'storage/photos/shares/services-2.svg', '2024-07-26 08:48:11', '2024-07-29 22:25:43', '2024-07-29 22:25:43');

-- Dumping structure for table income_db.service_descriptions
CREATE TABLE IF NOT EXISTS `service_descriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `description` longtext CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `description_2` text CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `service_id` bigint(20) unsigned NOT NULL,
  `language_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `service_descriptions_language_id_foreign` (`language_id`),
  KEY `service_descriptions_service_id_foreign` (`service_id`),
  CONSTRAINT `service_descriptions_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE,
  CONSTRAINT `service_descriptions_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table income_db.service_descriptions: ~10 rows (approximately)
INSERT INTO `service_descriptions` (`id`, `name`, `description`, `description_2`, `service_id`, `language_id`, `created_at`, `updated_at`) VALUES
	(9, 'تصميم المواقع', '<p>تصميم المواقع</p>', NULL, 4, 1, NULL, NULL),
	(10, 'web design', '<p>web design</p>', NULL, 4, 2, NULL, NULL),
	(11, 'تطوير التطبيقات', '<p>تطوير التطبيقات</p>', NULL, 5, 1, NULL, NULL),
	(12, 'Application Development', '<p>Application Development</p>', NULL, 5, 2, NULL, NULL),
	(13, 'تصميم المواقع', '<p>في عالم رقمي متسارع، أصبح وجود موقع إلكتروني احترافي ضرورة لكل الأعمال. في تبويب، نقدم خدمات تصميم مواقع متكاملة تساهم في تعزيز وجودك الرقمي وجذب العملاء بطريقة فعّالة ومبتكرة.</p>\r\n<p>خدماتنا في تصميم المواقع<br />تصميم مخصص<br />نحن ندرك أن كل عمل له احتياجاته الفريدة، ولذلك نقدم تصميمات مخصصة تلبي احتياجاتك الخاصة وتعكس هوية علامتك التجارية. سواء كنت تحتاج إلى موقع بسيط لعرض خدماتك أو موقع تجارة إلكترونية متكامل، نحن هنا لنحقق رؤيتك.</p>\r\n<p>تجربة مستخدم ممتازة<br />نسعى لتقديم تجربة مستخدم سلسة وممتعة من خلال تصميم مواقع بواجهة مستخدم بسيطة وسهلة الاستخدام. نحن نركز على تحسين التجربة العامة للزوار لضمان تحقيق أهدافك من الموقع.</p>\r\n<p>متجاوبة مع جميع الأجهزة<br />تصميم المواقع لدينا يتميز بالتجاوب الكامل مع جميع الأجهزة، سواء كانت أجهزة كمبيوتر، هواتف ذكية، أو أجهزة لوحية. نحن نضمن أن يظهر موقعك بشكل رائع ويعمل بشكل مثالي على جميع الشاشات.</p>\r\n<p>تحسين محركات البحث (SEO)<br />نعمل على تحسين مواقعنا لمحركات البحث لضمان ظهورها في نتائج البحث الأولى، مما يساهم في زيادة عدد الزوار وتعزيز وجودك الرقمي. نحن نتبع أحدث تقنيات السيو لضمان تحقيق أفضل النتائج.</p>\r\n<p>أمان وحماية<br />نضع أمان موقعك على رأس أولوياتنا. نستخدم أحدث تقنيات الأمان والحماية لضمان سلامة بياناتك وبيانات عملائك، ولحماية موقعك من أي تهديدات أمنية محتملة.</p>\r\n<p>مراحل تصميم المواقع<br />التخطيط والاستشارة: نبدأ بفهم احتياجاتك وأهدافك، ونجري استشارة مفصلة لتحديد متطلبات المشروع.<br />التصميم الأولي: نقدم تصميمات أولية تتناسب مع رؤيتك وهوية علامتك التجارية.<br />التطوير: بعد الموافقة على التصميم، نبدأ بتطوير الموقع باستخدام أحدث التقنيات لضمان الأداء الأمثل.<br />الاختبار والتقييم: نقوم بإجراء اختبارات شاملة لضمان خلو الموقع من الأخطاء وعمله بشكل ممتاز.<br />الإطلاق والمتابعة: بعد الانتهاء من جميع الاختبارات، نقوم بإطلاق الموقع ونقدم دعم فني مستمر لضمان استمرارية عمل الموقع بشكل مثالي.</p>', NULL, 1, 1, NULL, NULL),
	(14, 'web design', '<p>In an accelerated digital world, having a professional website has become a necessity for all businesses. At Tabweeb, we offer integrated website design services that contribute to enhancing your digital presence and attracting customers in an effective and innovative manner.</p>\r\n<p>Our web design services<br />Custom Design<br />We recognize that every business has its unique needs, so we offer customized designs that meet your specific needs and reflect your brand identity. Whether you need a simple website to display your services or an integrated e-commerce website, we are here to achieve your vision.</p>\r\n<p>Excellent user experience<br />We strive to provide a seamless and fun user experience by designing websites with a simple and easy-to-use user interface. We focus on improving the general experience of visitors to ensure that your goals are achieved from the site.</p>\r\n<p>Responsive to all devices<br />Our website design features full responsiveness to all devices, whether it be computers, smartphones, or tablets. We ensure that your site appears great and works perfectly on all screens.</p>\r\n<p>Search Engine Optimization (SEO)<br />We improve our search engine sites to ensure they appear in the first search results, contributing to increasing the number of visitors and enhancing your digital presence. We follow the latest SEO technology to ensure the best results.</p>\r\n<p>Safety and Protection<br />We place the security of your site at the top of our priorities. We use the latest security and protection technologies to ensure the integrity of your data and customers\' data, and to protect your site from any potential security threats.</p>\r\n<p>Web Design Stages<br />Planning and consulting: We begin by understanding your needs and objectives, and conduct a detailed consultation to determine the requirements of the project.<br />Initial design: We offer initial designs that suit your vision and brand identity.<br />Development: After design approval, we begin to develop the site using the latest technology to ensure optimal performance.<br />Testing and Evaluation: We conduct comprehensive testing to ensure that the site is free of errors and works excellent.<br />Launch and follow-up: After all the tests are completed, we launch the site and provide ongoing technical support to ensure the continuity of the site\'s work perfectly.</p>', NULL, 1, 2, NULL, NULL),
	(17, 'برامج الحسابات', '<p>برامج الحسابات</p>\r\n<p>في تبويب ، نقدم حلولاً متكاملة لإدارة حساباتك بكل سهولة وفعالية. برامج الحسابات لدينا مصممة خصيصاً لتلبية احتياجات الشركات الصغيرة والمتوسطة والكبيرة، مما يساعدك على إدارة عملياتك المالية بكفاءة وشفافية.</p>\r\n<p>ميزات برامج الحسابات لدينا<br />إدارة الفواتير والمبيعات<br />إنشاء الفواتير بسهولة: صمم وأرسل الفواتير إلى عملائك بسرعة وسهولة.<br />متابعة المبيعات: تتبع جميع عمليات البيع بدقة واحصل على تقارير مفصلة لتحليل الأداء.<br />إدارة المصاريف والمشتريات<br />تتبع المصاريف: سجل جميع مصاريفك اليومية والشهرية واحصل على نظرة شاملة لمصاريفك.<br />إدارة المشتريات: تابع مشترياتك واحصل على تقارير مفصلة حول الموردين والمنتجات.<br />إدارة الحسابات المدينة والدائنة<br />الحسابات المدينة: تتبع المدفوعات المستحقة من العملاء وأرسل تذكيرات للدفع.<br />الحسابات الدائنة: إدارة المدفوعات للموردين وتتبع المبالغ المستحقة عليهم.<br />التقارير المالية<br />تقارير مالية مفصلة: احصل على تقارير مالية شاملة تساعدك على اتخاذ قرارات مستنيرة.<br />تحليل الأداء المالي: تابع الأداء المالي لشركتك وقارن بين الفترات الزمنية المختلفة.<br />التكامل مع الأنظمة الأخرى<br />تكامل سلس: تكامل برامج الحسابات لدينا مع الأنظمة الأخرى التي تستخدمها في شركتك مثل أنظمة إدارة الموارد البشرية والمخزون.<br />واجهة برمجة التطبيقات (API): استخدم واجهة برمجة التطبيقات لتكامل برامج الحسابات مع الأنظمة المخصصة لشركتك.<br />الأمان والحماية<br />تشفير البيانات: نستخدم تقنيات التشفير الحديثة لضمان حماية بياناتك المالية.<br />النسخ الاحتياطي: حلول النسخ الاحتياطي التلقائي لضمان استعادة البيانات في حالة حدوث أي مشكلة.<br />حلول متكاملة للشركات<br />نحن نقدم برامج حسابات مخصصة لاحتياجات مختلف القطاعات، بما في ذلك:</p>\r\n<p>الشركات الصغيرة والمتوسطة: حلول مرنة وبأسعار معقولة لمساعدتك على إدارة حساباتك بفعالية.<br />الشركات الكبيرة: حلول متقدمة تلبي احتياجات الشركات الكبيرة والمعقدة مع تقارير وتحليلات مالية متطورة.</p>', NULL, 3, 1, NULL, NULL),
	(18, 'Account Program', '<p>In Tabweeb, we offer integrated solutions to manage your accounts with ease and effectiveness. Our account programs are tailored to the needs of small, medium and large businesses, helping you manage your financial operations efficiently and transparently.</p>\r\n<p>Features of our account software<br />Invoice and Sales Management<br />Create invoices easily: Design and send invoices to your customers quickly and easily.<br />Follow-up sales: Track all sales accurately and get detailed performance analysis reports.<br />Expenditure and Procurement Management<br />Track expenses: Record all your daily and monthly expenses and get a comprehensive view of your expenses.<br />Procurement Management: Follow your purchases and get detailed reports about suppliers and products.<br />Management of Debit and Credit Accounts<br />Debit accounts: Track outstanding payments from customers and send payment reminders.<br />Accounts payable: management of payments to suppliers and tracking of amounts owed.<br />Financial reports<br />Detailed financial reports: Get comprehensive financial reports that help you make informed decisions.<br />Financial Performance Analysis: Follow your company\'s financial performance and compare different time periods.<br />Integration with other systems<br />Seamless Integration: Integrate our account software with other systems you use in your company such as HRM and inventory systems.<br />API: Use the API to integrate account software with your company\'s custom systems.<br />Safety and Protection<br />Data encryption: We use modern encryption techniques to ensure the protection of your financial data.<br />Backup: Automatic backup solutions to ensure data recovery in case of any problem.<br />Integrated Corporate Solutions<br />We offer custom account programs for the needs of different sectors, including:</p>\r\n<p>SMEs: Flexible and affordable solutions to help you manage your accounts effectively.<br />Large companies: Advanced solutions that meet the needs of large and complex companies with sophisticated financial reports and analysis.</p>', NULL, 3, 2, NULL, NULL),
	(19, 'تطوير التطبيقات', '<p>تطوير التطبيقات</p>\r\n<p>في تبويب، نقدم خدمات تطوير تطبيقات الجوال المتكاملة التي تساعدك على الوصول إلى عملائك بسهولة وفعالية. نحن نفهم أهمية التطبيقات في عالم اليوم الرقمي، ونعمل بجد لتقديم حلول مبتكرة وذات جودة عالية تلبي احتياجات عملك.</p>\r\n<p>خدماتنا في تطوير التطبيقات<br />تطوير تطبيقات مخصصة<br />نحن نؤمن بأن كل عمل له احتياجاته الخاصة، لذلك نقدم حلولاً مخصصة لتطوير تطبيقات الجوال تتناسب مع متطلباتك الفردية وتساهم في تحقيق أهدافك. سواء كنت تحتاج إلى تطبيق للأندرويد أو iOS، فريقنا المتخصص جاهز لتقديم أفضل الحلول.</p>\r\n<p>تجربة مستخدم ممتازة<br />تصميم تجربة مستخدم سلسة وجذابة هو جزء أساسي من خدماتنا. نحرص على أن تكون تطبيقاتنا سهلة الاستخدام وتوفر تجربة مستخدم ممتازة لضمان رضا المستخدمين وزيادة تفاعلهم مع التطبيق.</p>\r\n<p>تطبيقات متجاوبة وعالية الأداء<br />نحن نضمن أن تطبيقاتنا تعمل بشكل ممتاز على جميع الأجهزة والشاشات، سواء كانت هواتف ذكية أو أجهزة لوحية. تطبيقاتنا مصممة لتكون سريعة الاستجابة وذات أداء عالي لتلبية توقعات المستخدمين.</p>\r\n<p>تكامل مع الأنظمة الأخرى<br />نقدم حلولاً متكاملة تتيح لتطبيقات الجوال التكامل مع الأنظمة الأخرى التي تستخدمها في عملك، مثل أنظمة إدارة الموارد البشرية، برامج الحسابات، وأنظمة إدارة العلاقات مع العملاء (CRM).</p>\r\n<p>الأمان والحماية<br />نضع أمان تطبيقاتك على رأس أولوياتنا. نستخدم أحدث تقنيات الأمان والحماية لضمان سلامة بياناتك وبيانات مستخدمي التطبيق، وحمايتها من أي تهديدات أمنية محتملة.</p>\r\n<p>مراحل تطوير التطبيقات<br />التحليل والتخطيط: نبدأ بفهم احتياجاتك وأهدافك من التطبيق، ونجري تحليل متعمق لتحديد متطلبات المشروع.<br />التصميم الأولي: نقدم تصميمات أولية لشاشات التطبيق للحصول على موافقتك وضمان توافق التصميم مع رؤيتك.<br />التطوير: بعد الموافقة على التصميم، نبدأ بتطوير التطبيق باستخدام أحدث التقنيات لضمان الأداء الأمثل.<br />الاختبار والتقييم: نقوم بإجراء اختبارات شاملة للتأكد من خلو التطبيق من الأخطاء وعمله بشكل ممتاز.<br />الإطلاق والمتابعة: بعد الانتهاء من جميع الاختبارات، نقوم بإطلاق التطبيق ونقدم دعم فني مستمر لضمان استمرارية عمله بشكل مثالي.</p>', NULL, 2, 1, NULL, NULL),
	(20, 'Application Development', '<p>In Tabweeb, we offer integrated mobile app development services that help you reach your customers easily and effectively. We understand the importance of applications in today\'s digital world, and we work hard to deliver innovative and high-quality solutions that meet your business needs.</p>\r\n<p>Our Services in App Development<br />Development of customized applications<br />We believe that every business has its own needs, so we offer customized solutions to develop mobile apps that fit your individual requirements and contribute to the achievement of your goals. Whether you need an app for Android or iOS, our dedicated team is ready to offer the best solutions.</p>\r\n<p>Excellent user experience<br />Designing a seamless and attractive user experience is an essential part of our services. We ensure that our apps are user friendly and provide an excellent user experience to ensure users\' satisfaction and increase their interaction with the app.</p>\r\n<p>Responsive and high performance applications<br />We ensure that our apps work excellent on all devices and screens, whether they be smartphones or tablets. Our apps are designed to be responsive and high performance to meet users\' expectations.</p>\r\n<p>Integration with other systems<br />We offer integrated solutions that allow mobile applications to integrate with other systems you use in your business, such as human resources management systems, account software, and customer relationship management systems (CRM).</p>\r\n<p>Safety and Protection<br />We place the security of your apps at the top of our priorities. We use state-of-the-art security and protection technologies to ensure the integrity of your data and users\' data, and protect them from any potential security threats.</p>\r\n<p>Phases of application development<br />Analysis and Planning: We begin by understanding your needs and objectives from the app, and conduct in-depth analysis to determine the requirements of the project.<br />Initial design: We offer initial designs for app screens to get your approval and ensure the design is compatible with your vision.<br />Development: After design approval, we begin to develop the application using the latest technology to ensure optimal performance.<br />Testing &amp; Evaluation: We perform comprehensive testing to make sure the application is error-free and works excellent.<br />Launch and follow-up: After all the tests are completed, we launch the app and provide continuous technical support to ensure the continuity of its work perfectly.</p>', NULL, 2, 2, NULL, NULL);

-- Dumping structure for table income_db.settings
CREATE TABLE IF NOT EXISTS `settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `value` text CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `settings_key_index` (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=137 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table income_db.settings: ~27 rows (approximately)
INSERT INTO `settings` (`id`, `key`, `value`, `created_at`, `updated_at`) VALUES
	(110, 'website_name_ar', 'CMS', '2024-07-26 18:08:37', '2024-07-29 11:31:59'),
	(111, 'keywords_ar', 'aJT0EXGFy6TBjhr3', '2024-07-26 18:08:37', '2024-07-29 11:31:59'),
	(112, 'meta_description_ar', '97tIeBVPO1RgkGZR', '2024-07-26 18:08:37', '2024-07-29 11:31:59'),
	(113, 'site_email', 'info@neomsoft-sa.com', '2024-07-26 18:08:37', '2024-07-29 11:31:59'),
	(114, 'site_address_ar', 'الطائف, المملكة العربية السعودية', '2024-07-26 18:08:37', '2024-07-29 11:31:59'),
	(115, 'site_phone', '+966126671538', '2024-07-26 18:08:37', '2024-07-29 11:31:59'),
	(116, 'mail_driver', 'smtp', '2024-07-26 18:08:37', '2024-07-29 11:31:59'),
	(117, 'mail_host', 'smtp.mailtrap.io', '2024-07-26 18:08:37', '2024-07-29 11:31:59'),
	(118, 'mail_port', '2525', '2024-07-26 18:08:37', '2024-07-29 11:31:59'),
	(119, 'mail_username', '759b99df94f0be', '2024-07-26 18:08:37', '2024-07-29 11:31:59'),
	(120, 'mail_password', 'e4c5c123acd614', '2024-07-26 18:08:37', '2024-07-29 11:31:59'),
	(121, 'mail_encryption', 'tls', '2024-07-26 18:08:37', '2024-07-29 11:32:00'),
	(122, 'mail_from_address', 'info@cms.com', '2024-07-26 18:08:37', '2024-07-29 11:32:00'),
	(123, 'mail_from_name', 'CMS', '2024-07-26 18:08:37', '2024-07-29 11:32:00'),
	(124, 'website_logo', 'logo.png', '2024-07-26 18:08:37', '2024-07-29 11:32:00'),
	(125, 'website_disable', '0', '2024-07-26 18:08:37', NULL),
	(126, 'dashboard_disable', '0', '2024-07-26 18:08:37', NULL),
	(127, 'website_name_en', 'Tabweeb', '2024-07-26 18:08:37', '2024-07-29 11:31:59'),
	(128, 'keywords_en', 'test', '2024-07-26 18:08:37', '2024-07-29 11:31:59'),
	(129, 'meta_description_en', 'test', '2024-07-26 18:08:37', '2024-07-29 11:31:59'),
	(130, 'site_address_en', 'Taif, Saudi Arabia', '2024-07-26 18:08:37', '2024-07-29 11:31:59'),
	(131, 'facebook', 'https://www.facebook.com', '2024-07-26 18:08:37', '2024-07-29 11:32:00'),
	(132, 'twitter', 'https://twitter.com', '2024-07-26 18:08:37', '2024-07-29 11:32:00'),
	(133, 'instagram', 'https://www.instagram.com', '2024-07-26 18:08:37', '2024-07-29 11:32:00'),
	(134, 'whats', 'https://whatsapp.com', '2024-07-26 18:08:37', NULL),
	(135, 'snapchat', 'https://www.snapchat.com', '2024-07-26 18:08:37', '2024-07-29 11:32:00'),
	(136, 'map', 'https://maps.google.com/maps?width=100%25&amp;height=600&amp;hl=en&amp;q=saudi+(My%20Business%20Name)&amp;t=&amp;z=4&amp;ie=UTF8&amp;iwloc=B&amp;output=embed"', '2024-07-26 18:08:37', '2024-07-29 11:32:00');

-- Dumping structure for table income_db.users
CREATE TABLE IF NOT EXISTS `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(300) NOT NULL,
  `email` varchar(250) NOT NULL,
  `phone` varchar(14) DEFAULT NULL,
  `photo` varchar(300) DEFAULT NULL,
  `admin_token` varchar(100) DEFAULT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(100) NOT NULL,
  `role` enum('super_admin','admin','sub_admin') NOT NULL DEFAULT 'sub_admin',
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`),
  UNIQUE KEY `users_phone_unique` (`phone`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table income_db.users: ~3 rows (approximately)
INSERT INTO `users` (`id`, `name`, `email`, `phone`, `photo`, `admin_token`, `email_verified_at`, `password`, `role`, `remember_token`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, 'Super Admin', 'super@admin.com', NULL, NULL, NULL, '2024-07-18 07:50:20', '$2y$10$Da2.6YQHXARyRGXx0IXGdutwlWXiEcXBcWNfm1duwKy7QqOYEiPnm', 'super_admin', 'zjcJGS5Gqs', NULL, NULL, NULL),
	(2, 'Admin', 'admin@admin.com', NULL, NULL, NULL, '2024-07-18 07:50:20', '$2y$10$UuahnTx9je8XC.zpQsPZBuHwIdiDOof8Pz7C5wfPOcw8YirBEnJGi', 'admin', 'EbRRcGSBnIszYgMU6EzgBBFKKWaaHaMIISLDhZGQbqhAQDO4ImLiDe7QK0aL', NULL, NULL, NULL),
	(3, 'Sub Admin', 'sub@admin.com', NULL, NULL, NULL, '2024-07-18 07:50:20', '$2y$10$lbUhLB42HupAcemw92alkendOAXy3Q8myz8CrhHZqmXAduw18GC3y', 'sub_admin', 'i6gVl0MTO5', NULL, NULL, NULL);

-- Dumping structure for table income_db.user_modules
CREATE TABLE IF NOT EXISTS `user_modules` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `module_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_modules_module_id_foreign` (`module_id`),
  KEY `user_modules_user_id_module_id_index` (`user_id`,`module_id`),
  CONSTRAINT `user_modules_module_id_foreign` FOREIGN KEY (`module_id`) REFERENCES `modules` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_modules_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table income_db.user_modules: ~0 rows (approximately)

-- Dumping structure for table income_db.videos
CREATE TABLE IF NOT EXISTS `videos` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `video` varchar(300) DEFAULT NULL,
  `image` varchar(200) DEFAULT NULL,
  `type` enum('1','2') DEFAULT NULL COMMENT '1-> Youtube video file, 2-> localfile',
  `video_category_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `videos_video_category_id_foreign` (`video_category_id`) USING BTREE,
  CONSTRAINT `videos_video_category_id_foreign` FOREIGN KEY (`video_category_id`) REFERENCES `video_categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table income_db.videos: ~3 rows (approximately)
INSERT INTO `videos` (`id`, `video`, `image`, `type`, `video_category_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(19, NULL, NULL, '1', NULL, '2024-07-18 09:24:34', '2024-07-18 09:24:53', NULL),
	(20, 'wwww.ddd', NULL, '1', NULL, '2024-07-18 10:22:06', '2024-07-18 10:26:06', NULL),
	(21, 'يالابينا', NULL, '1', NULL, '2024-07-18 10:28:19', '2024-07-18 10:28:19', NULL);

-- Dumping structure for table income_db.video_categories
CREATE TABLE IF NOT EXISTS `video_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(200) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table income_db.video_categories: ~0 rows (approximately)

-- Dumping structure for table income_db.video_category_descriptions
CREATE TABLE IF NOT EXISTS `video_category_descriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `slug` varchar(100) NOT NULL,
  `keywords` varchar(400) NOT NULL,
  `meta_description` text NOT NULL,
  `video_category_id` bigint(20) unsigned DEFAULT NULL,
  `language_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `video_category_descriptions_language_id_foreign` (`language_id`) USING BTREE,
  KEY `video_category_descriptions_video_category_id_language_id_index` (`video_category_id`,`language_id`) USING BTREE,
  CONSTRAINT `video_category_descriptions_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE,
  CONSTRAINT `video_category_descriptions_video_category_id_foreign` FOREIGN KEY (`video_category_id`) REFERENCES `video_categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table income_db.video_category_descriptions: ~0 rows (approximately)

-- Dumping structure for table income_db.video_descriptions
CREATE TABLE IF NOT EXISTS `video_descriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(200) NOT NULL,
  `video_id` bigint(20) unsigned NOT NULL,
  `language_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `video_descriptions_language_id_foreign` (`language_id`) USING BTREE,
  KEY `video_descriptions_video_id_language_id_index` (`video_id`,`language_id`) USING BTREE,
  CONSTRAINT `video_descriptions_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE,
  CONSTRAINT `video_descriptions_video_id_foreign` FOREIGN KEY (`video_id`) REFERENCES `videos` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=233 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table income_db.video_descriptions: ~6 rows (approximately)
INSERT INTO `video_descriptions` (`id`, `title`, `video_id`, `language_id`) VALUES
	(225, 'ساره2', 19, 1),
	(226, 'sara2', 19, 2),
	(229, 'تست', 20, 1),
	(230, 'test', 20, 2),
	(231, 'مدحت', 21, 1),
	(232, 'medht', 21, 2);

-- Dumping structure for table income_db.visitor_emails
CREATE TABLE IF NOT EXISTS `visitor_emails` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(191) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `posts_id_index` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table income_db.visitor_emails: ~0 rows (approximately)

-- Dumping structure for table income_db.visitor_jobs
CREATE TABLE IF NOT EXISTS `visitor_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `name` varchar(190) DEFAULT NULL,
  `email` varchar(190) DEFAULT NULL,
  `phone` varchar(15) DEFAULT NULL,
  `cv` varchar(200) DEFAULT NULL,
  `notes` longtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=119 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table income_db.visitor_jobs: ~9 rows (approximately)
INSERT INTO `visitor_jobs` (`id`, `title`, `name`, `email`, `phone`, `cv`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(108, 'مبرمج', 'mahmoud', 'mah@yahoo.com', '+2001551129666', '/storage/files/1722160544.pdf', NULL, '2024-07-28 09:55:44', '2024-07-28 09:55:44', NULL),
	(109, 'مبرمج', 'mahmoud', 'mah@yahoo.com', '+2001011800592', '/storage/files/1722160563.pdf', NULL, '2024-07-28 09:56:03', '2024-07-28 09:56:40', '2024-07-28 09:56:40'),
	(110, 'مهندس', 'محمود', 'mah@zanaty.com', '0122555555', '/storage/files/1722163674.pdf', NULL, '2024-07-28 10:47:53', '2024-07-28 10:47:54', NULL),
	(111, 'programmer', 'mahmoud', 'mah@yahoo.com', '+2001551129666', '/storage/files/1722188143.pdf', NULL, '2024-07-28 17:35:43', '2024-07-28 17:35:43', NULL),
	(112, 'programmer', 'محمد عبدالله', 'mah@yahoo.com', '015522565959', '/storage/files/1722197872.pdf', NULL, '2024-07-28 20:17:52', '2024-07-28 20:17:52', NULL),
	(113, 'مبرمج', 'ahmed', 'mah@yahoo.com', '+2001551129666', '/storage/files/1722288097.pdf', NULL, '2024-07-29 21:21:37', '2024-07-29 21:21:37', NULL),
	(117, 'مبرمج', 'mahmoud', 'FBA_ITALY@LIBERO.IT', '0100', '/storage/files/1722335091.pdf', NULL, '2024-07-30 10:24:51', '2024-07-30 10:24:51', NULL),
	(118, 'Developer', 'mahmoud', 'admin@admin.com', '0100', '/storage/files/1722335213.pdf', NULL, '2024-07-30 10:26:53', '2024-07-30 10:26:53', NULL);

-- Dumping structure for table income_db.visitor_messages
CREATE TABLE IF NOT EXISTS `visitor_messages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `email` varchar(191) NOT NULL,
  `phone` varchar(15) DEFAULT NULL,
  `subject` varchar(191) NOT NULL,
  `message` longtext NOT NULL,
  `read` tinyint(1) NOT NULL DEFAULT 0,
  `reply` tinyint(1) NOT NULL DEFAULT 0,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `visitor_messages_id_index` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table income_db.visitor_messages: ~5 rows (approximately)
INSERT INTO `visitor_messages` (`id`, `name`, `email`, `phone`, `subject`, `message`, `read`, `reply`, `deleted_at`, `created_at`, `updated_at`) VALUES
	(2, 'mahmoud', 'admin@admin.com', '0100', 'تست', 'تستت 123', 0, 0, NULL, '2024-07-28 10:51:47', '2024-07-28 22:50:46'),
	(3, 'mahmoud', 'mah@yahoo.com', '01011800592', 'تست', 'تببب', 0, 0, NULL, '2024-07-28 22:20:06', '2024-07-28 22:50:46'),
	(4, 'mahmoud', 'mah@yahoo.com', '01011800592', 'تست', 'basha2', 0, 0, NULL, '2024-07-28 22:25:50', '2024-07-28 22:50:46'),
	(5, 'احمد', 'mah@yahoo.com', '01011800592', 'تست', 'تست22', 0, 0, NULL, '2024-07-28 22:28:09', '2024-07-28 22:50:46'),
	(6, 'احمد', 'mah@yahoo.com', '01011800592', 'تست', 'aagaa', 0, 0, NULL, '2024-07-28 22:29:01', '2024-07-28 22:50:46'),
	(7, 'Mahmoud Elzanaty Ahmed Ali AMISH', 'mah_zanaty@yahoo.com', '01011800592', 'sg', 'ga', 0, 0, NULL, '2024-07-28 22:48:36', '2024-07-28 22:50:46'),
	(8, 'Mahmoud Elzanaty Ahmed Ali AMISH', 'mah_zanaty@yahoo.com', '01011800592', 'تست2', 'dszfg', 0, 0, NULL, '2024-07-31 00:18:21', '2024-07-31 00:18:21');

-- Dumping structure for table income_db.website_disabled
CREATE TABLE IF NOT EXISTS `website_disabled` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `link` text CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table income_db.website_disabled: ~0 rows (approximately)

-- Dumping structure for table income_db.website_visitors
CREATE TABLE IF NOT EXISTS `website_visitors` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ip` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `website_visitors_id_index` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table income_db.website_visitors: ~47 rows (approximately)
INSERT INTO `website_visitors` (`id`, `ip`, `created_at`, `updated_at`) VALUES
	(1, '::1', '2024-07-18 07:52:56', '2024-07-18 07:52:56'),
	(2, '::1', '2024-07-20 11:36:47', '2024-07-20 11:36:47'),
	(3, '::1', '2024-07-20 12:20:10', '2024-07-20 12:20:10'),
	(4, '::1', '2024-07-21 08:27:45', '2024-07-21 08:27:45'),
	(5, '::1', '2024-07-22 17:56:28', '2024-07-22 17:56:28'),
	(6, '::1', '2024-07-24 07:26:58', '2024-07-24 07:26:58'),
	(7, '::1', '2024-07-24 18:46:22', '2024-07-24 18:46:22'),
	(8, '::1', '2024-07-24 19:50:41', '2024-07-24 19:50:41'),
	(9, '::1', '2024-07-24 19:55:47', '2024-07-24 19:55:47'),
	(10, '::1', '2024-07-24 21:00:36', '2024-07-24 21:00:36'),
	(11, '::1', '2024-07-25 05:22:48', '2024-07-25 05:22:48'),
	(12, '::1', '2024-07-25 05:34:34', '2024-07-25 05:34:34'),
	(13, '::1', '2024-07-25 09:21:20', '2024-07-25 09:21:20'),
	(14, '::1', '2024-07-25 09:44:52', '2024-07-25 09:44:52'),
	(15, '::1', '2024-07-25 09:47:46', '2024-07-25 09:47:46'),
	(16, '::1', '2024-07-25 10:26:13', '2024-07-25 10:26:13'),
	(17, '::1', '2024-07-25 11:08:51', '2024-07-25 11:08:51'),
	(18, '::1', '2024-07-25 15:15:42', '2024-07-25 15:15:42'),
	(19, '::1', '2024-07-25 16:10:55', '2024-07-25 16:10:55'),
	(20, '::1', '2024-07-25 17:04:33', '2024-07-25 17:04:33'),
	(21, '::1', '2024-07-26 05:37:24', '2024-07-26 05:37:24'),
	(22, '::1', '2024-07-26 06:40:53', '2024-07-26 06:40:53'),
	(23, '::1', '2024-07-26 06:51:54', '2024-07-26 06:51:54'),
	(24, '::1', '2024-07-26 06:53:51', '2024-07-26 06:53:51'),
	(25, '::1', '2024-07-26 08:33:16', '2024-07-26 08:33:16'),
	(26, '::1', '2024-07-26 15:11:20', '2024-07-26 15:11:20'),
	(27, '::1', '2024-07-26 18:17:16', '2024-07-26 18:17:16'),
	(28, '::1', '2024-07-26 20:16:27', '2024-07-26 20:16:27'),
	(29, '::1', '2024-07-26 21:00:11', '2024-07-26 21:00:11'),
	(30, '::1', '2024-07-27 05:08:25', '2024-07-27 05:08:25'),
	(31, '::1', '2024-07-27 05:09:39', '2024-07-27 05:09:39'),
	(32, '::1', '2024-07-27 14:46:58', '2024-07-27 14:46:58'),
	(33, '::1', '2024-07-27 19:26:59', '2024-07-27 19:26:59'),
	(34, '::1', '2024-07-27 19:27:41', '2024-07-27 19:27:41'),
	(35, '::1', '2024-07-27 21:09:29', '2024-07-27 21:09:29'),
	(36, '::1', '2024-07-27 22:55:26', '2024-07-27 22:55:26'),
	(37, '::1', '2024-07-28 06:26:23', '2024-07-28 06:26:23'),
	(38, '::1', '2024-07-28 06:26:23', '2024-07-28 06:26:23'),
	(39, '::1', '2024-07-28 07:16:00', '2024-07-28 07:16:00'),
	(40, '::1', '2024-07-28 10:00:03', '2024-07-28 10:00:03'),
	(41, '::1', '2024-07-28 17:33:55', '2024-07-28 17:33:55'),
	(42, '::1', '2024-07-28 17:38:47', '2024-07-28 17:38:47'),
	(43, '::1', '2024-07-28 17:45:26', '2024-07-28 17:45:26'),
	(44, '::1', '2024-07-28 19:56:05', '2024-07-28 19:56:05'),
	(45, '::1', '2024-07-28 21:00:17', '2024-07-28 21:00:17'),
	(46, '::1', '2024-07-28 22:45:04', '2024-07-28 22:45:04'),
	(47, '::1', '2024-07-28 22:46:12', '2024-07-28 22:46:12'),
	(48, '::1', '2024-07-29 09:22:22', '2024-07-29 09:22:22'),
	(49, '::1', '2024-07-29 18:29:01', '2024-07-29 18:29:01'),
	(50, '::1', '2024-07-29 20:20:04', '2024-07-29 20:20:04'),
	(51, '::1', '2024-07-29 21:21:05', '2024-07-29 21:21:05'),
	(52, '::1', '2024-07-30 07:27:38', '2024-07-30 07:27:38'),
	(53, '::1', '2024-07-30 12:33:18', '2024-07-30 12:33:18'),
	(54, '::1', '2024-07-30 12:33:32', '2024-07-30 12:33:32'),
	(55, '::1', '2024-07-30 18:20:26', '2024-07-30 18:20:26'),
	(56, '::1', '2024-07-30 20:10:16', '2024-07-30 20:10:16'),
	(57, '::1', '2024-07-30 21:00:27', '2024-07-30 21:00:27'),
	(58, '::1', '2024-07-30 21:55:27', '2024-07-30 21:55:27'),
	(59, '::1', '2024-07-30 23:57:11', '2024-07-30 23:57:11');

/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;
