<reponame>PrographyCo/Prography-Website
-- MySQL dump 10.19  Distrib 10.3.28-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: progwlfo_prography.co
-- ------------------------------------------------------
-- Server version	10.3.28-MariaDB-log-cll-lve

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `about_us`
--

DROP TABLE IF EXISTS `about_us`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `about_us` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `hometext_ar` varchar(1500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `hometext_en` varchar(1500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fulltext_ar` varchar(2500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fulltext_en` varchar(2500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `about_us`
--

LOCK TABLES `about_us` WRITE;
/*!40000 ALTER TABLE `about_us` DISABLE KEYS */;
INSERT INTO `about_us` VALUES (1,'بروجرفي هي شركة فلسطينية تقدم مجموعة واسعة من الخدمات والحلول في مجال تكنولوجيا المعلومات ، كما يقدم فريق بروجرفي  خدمات استشارية احترافية في مختلف المجالات. بالإضافة إلى تخصصنا الأساسي في مجالات البرمجة والتطوير. الويب والجوال الذي تميزنا به دائمًا ، نقدم حزمة خدمات واسعة جدًا تحتاجها كل مؤسسة أو شركة بغض النظر عن حجمها أو نطاق عملها ، اعتمادًا على خبرة فريق العمل الواسعة لدينا في السوق المحلية والعالمية ، مما يجعل الأمر أسهل لكي يعاني عملاؤنا من البحث عن المصدر الصحيح ، واختصر الوقت والتكلفة الإضافية.','Prography is a Palestinian company offering a wide range of services And solutions In the IT field, the team additionally offers  Prography professional consulting services in various fields. In addition to our core specialization in the fields of programming and development. The web and mobile that we have always distinguished, we offer a package Wide Very services that every organization or company needs regardless Consider Based on their size or scope of work, depending on our extensive staff experience in a Local and global market, making it easier for our customers to suffer search For the right source, shorten the time and cost Add-on.','<div class=\"text1\">\n\n            <p class=\"mb-4\">\n                Prography is a Palestinian company that offers a wide range of services and solutions in the field of information technology\n                Professionalism in multiple fields\n            </p>\n\n                <p class=\"mb-4\">\n                    In addition to our core specialization in the areas of design, programming, web and mobile development that we have always distinguished, we offer a wide range of services.\n                    What every organization or company needs, regardless of its size or field of work, also distinguishes us from the availability of experts modern design and professional design, designers\n                    Social Media and Motion Professional films based on our extensive experience in the local and international market, making it easier for our customers to find the right source.\n                    They are shortened by additional time and cost.\n                </p>\n\n                <p class=\"mb-4\">\n                    As a specialized Palestinian company, we aspire to meet the needs of a wide range of Arab and international institutions and companies, by providing the latest tools and technologies in the fields of\n                    Our specialty, as we seek to make a qualitative leap in the quality of services, and thus achieve the greatest benefit to their owners.</p>\n\n                <p class=\"mb-4\">\n                    Through the outstanding service and high efficiency of our staff, we have been able in a record period to prove the company in the global market and bring many companies and institutions\n                    That we deal with and provide our services directly.\n                </p>\n                <p class=\"mb-4\">\n                    At Prography, we value the trust that our accreditors have given us, so we continuously work to improve the quality of our services by keeping up with the latest global technologies.\n                    In our areas of work, in addition to our attention to the efficiency of our employees.\n                </p>\n\n\n        </div>','<div class=\"text1\">\n\n            <p class=\"mb-4\">\n                Prography is a Palestinian company that offers a wide range of services and solutions in the field of information technology\n                Professionalism in multiple fields\n            </p>\n\n                <p class=\"mb-4\">\n                    In addition to our core specialization in the areas of design, programming, web and mobile development that we have always distinguished, we offer a wide range of services.\n                    What every organization or company needs, regardless of its size or field of work, also distinguishes us from the availability of experts modern design and professional design, designers\n                    Social Media and Motion Professional films based on our extensive experience in the local and international market, making it easier for our customers to find the right source.\n                    They are shortened by additional time and cost.\n                </p>\n\n                <p class=\"mb-4\">\n                    As a specialized Palestinian company, we aspire to meet the needs of a wide range of Arab and international institutions and companies, by providing the latest tools and technologies in the fields of\n                    Our specialty, as we seek to make a qualitative leap in the quality of services, and thus achieve the greatest benefit to their owners.</p>\n\n                <p class=\"mb-4\">\n                    Through the outstanding service and high efficiency of our staff, we have been able in a record period to prove the company in the global market and bring many companies and institutions\n                    That we deal with and provide our services directly.\n                </p>\n                <p class=\"mb-4\">\n                    At Prography, we value the trust that our accreditors have given us, so we continuously work to improve the quality of our services by keeping up with the latest global technologies.\n                    In our areas of work, in addition to our attention to the efficiency of our employees.\n                </p>\n\n\n        </div>','2021-07-14 16:17:42','2021-07-15 13:33:10');
/*!40000 ALTER TABLE `about_us` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `admins`
--

DROP TABLE IF EXISTS `admins`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admins` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `admins_email_unique` (`email`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `admins`
--

LOCK TABLES `admins` WRITE;
/*!40000 ALTER TABLE `admins` DISABLE KEYS */;
INSERT INTO `admins` VALUES (1,'Prography.Co','<EMAIL>','$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi','2021-07-14 16:17:42','2021-07-14 16:17:42');
/*!40000 ALTER TABLE `admins` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `calls`
--

DROP TABLE IF EXISTS `calls`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `calls` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `subject` enum('complaint','inquiry','technical support','your opinion about us') COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` varchar(2500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `calls_user_id_foreign` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `calls`
--

LOCK TABLES `calls` WRITE;
/*!40000 ALTER TABLE `calls` DISABLE KEYS */;
/*!40000 ALTER TABLE `calls` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `clients`
--

DROP TABLE IF EXISTS `clients`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `clients` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name_ar` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_en` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `img` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `clients`
--

LOCK TABLES `clients` WRITE;
/*!40000 ALTER TABLE `clients` DISABLE KEYS */;
INSERT INTO `clients` VALUES (9,'آكتفيشن','Activision','CLIENTS_60eeebb970be25.64645720.png','2021-07-14 17:50:25','2021-07-14 17:50:49'),(2,'رملك','Ramlak','default.png','2021-07-14 16:17:42','2021-07-14 16:17:42'),(7,'جوجل','google','CLIENTS_60eee868de55e7.79880320.png','2021-07-14 17:34:14','2021-07-14 17:36:40'),(8,'ميرسي كور','MERCY  CORPS','CLIENTS_60eeeb88105d58.90452248.png','2021-07-14 17:39:42','2021-07-14 17:50:00'),(10,'مهوسو سماء غزة','Gaza Sky Geeks','CLIENTS_60eeec171d9f23.40700003.webp','2021-07-14 17:51:27','2021-07-14 17:52:23'),(11,'برنامج منح الفاخورة','Al Fakhoora Scholarship and Empowerment Programme','CLIENTS_60eeec6856bf74.50875899.png','2021-07-14 17:53:05','2021-07-14 17:53:44'),(12,'UNDP','UNDP','CLIENTS_60eeece280d1a7.47734367.png','2021-07-14 17:55:31','2021-07-14 17:55:46'),(13,'UCAS','UCAS','CLIENTS_60eeed8ddcb5e5.65197930.png','2021-07-14 17:58:14','2021-07-14 17:58:37'),(14,'الجمارك السعودية','Saudi Customs','CLIENTS_60eeedfba53495.31547890.jpg','2021-07-14 17:59:25','2021-07-14 18:00:27'),(15,'الهيئة العامة للزكاة والدخل','General Authority for Zakat and Tax','CLIENTS_60eeeed74edc22.38706400.jpg','2021-07-14 18:03:26','2021-07-14 18:04:07'),(16,'كوبونس','coupons','CLIENTS_60eeef71d2a425.37640007.png','2021-07-14 18:06:23','2021-07-14 18:06:53'),(17,'fitwishes','fitwishes','CLIENTS_60eeefe96f6361.29176733.png','2021-07-14 18:08:26','2021-07-14 18:08:41'),(18,'قيمة','qeema','CLIENTS_60eef0685cd9e0.15257027.png','2021-07-14 18:10:30','2021-07-14 18:10:48'),(19,'فهمني','fahemni','CLIENTS_60eef0e5f1f489.49105610.png','2021-07-14 18:12:24','2021-07-14 18:12:53');
/*!40000 ALTER TABLE `clients` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `data`
--

DROP TABLE IF EXISTS `data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `data` (
  `id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `link` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `data` WRITE;
/*!40000 ALTER TABLE `data` DISABLE KEYS */;
INSERT INTO `data` VALUES ('linkedin','https://google.com','2021-07-14 16:17:42','2021-07-14 16:17:42'),('twitter','https://google.com','2021-07-14 16:17:42','2021-07-14 16:17:42'),('instagram','https://google.com','2021-07-14 16:17:42','2021-07-14 16:17:42'),('behance','https://google.com','2021-07-14 16:17:42','2021-07-14 16:17:42'),('facebook','https://google.com','2021-07-14 16:17:42','2021-07-14 16:17:42'),('email','<EMAIL>','2021-07-14 16:17:42','2021-07-14 16:17:42'),('whatsapp','+970567731107','2021-07-14 16:17:42','2021-07-14 16:17:42');
/*!40000 ALTER TABLE `data` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `discount_for`
--

DROP TABLE IF EXISTS `discount_for`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discount_for` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `discount_id` bigint(20) unsigned NOT NULL,
  `user` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `discount_for_discount_id_foreign` (`discount_id`),
  KEY `discount_for_user_foreign` (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `discount_for`
--

LOCK TABLES `discount_for` WRITE;
/*!40000 ALTER TABLE `discount_for` DISABLE KEYS */;
/*!40000 ALTER TABLE `discount_for` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `discounts`
--

DROP TABLE IF EXISTS `discounts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discounts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `amount` double(8,2) NOT NULL,
  `type` enum('%','$') COLLATE utf8mb4_unicode_ci NOT NULL,
  `enabled` enum('y','n') COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `discounts`
--

LOCK TABLES `discounts` WRITE;
/*!40000 ALTER TABLE `discounts` DISABLE KEYS */;
INSERT INTO `discounts` VALUES (1,30.00,'%','y','2021-07-14 16:17:42','2021-07-14 16:17:42');
/*!40000 ALTER TABLE `discounts` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `failed_jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `failed_jobs`
--

LOCK TABLES `failed_jobs` WRITE;
/*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `language_table_fields`
--

DROP TABLE IF EXISTS `language_table_fields`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `language_table_fields` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tableName` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tableCols` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `language_table_fields`
--

LOCK TABLES `language_table_fields` WRITE;
/*!40000 ALTER TABLE `language_table_fields` DISABLE KEYS */;
INSERT INTO `language_table_fields` VALUES (1,'services','[\"name\",\"briefDetails\",\"details\"]','2021-07-14 16:17:42','2021-07-14 16:17:42');
/*!40000 ALTER TABLE `language_table_fields` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `languages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `languages` (
  `languageCode` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `dir` enum('rtl','ltr') COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`languageCode`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `languages` WRITE;
/*!40000 ALTER TABLE `languages` DISABLE KEYS */;
INSERT INTO `languages` VALUES ('en','ltr','2021-07-14 16:17:42','2021-07-14 16:17:42'),('ar','rtl','2021-07-14 16:17:42','2021-07-14 16:17:42');
/*!40000 ALTER TABLE `languages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `links`
--

DROP TABLE IF EXISTS `links`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `links` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `linkName_ar` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `linkName_en` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `links`
--

LOCK TABLES `links` WRITE;
/*!40000 ALTER TABLE `links` DISABLE KEYS */;
INSERT INTO `links` VALUES (1,'اندرويد','Android','2021-07-14 16:17:42','2021-07-14 16:17:42'),(2,'اي او اس','Ios','2021-07-14 16:17:42','2021-07-14 16:17:42'),(3,'بيهانس','Behance','2021-07-14 16:17:42','2021-07-14 16:17:42'),(4,'موقع الكتروني','website','2021-07-14 16:17:42','2021-07-14 16:17:42');
/*!40000 ALTER TABLE `links` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_resets_table',1),(3,'2019_08_19_000000_create_failed_jobs_table',1),(4,'2021_06_30_052140_create_languages_table',1),(5,'2021_07_01_155243_create_services_table',1),(6,'2021_07_01_174557_create_language_table_fields_table',1),(7,'2021_07_01_181427_create_orders_table',1),(8,'2021_07_01_183428_create_projects_table',1),(9,'2021_07_01_184353_create_about_us_table',1),(10,'2021_07_01_202625_create_links_table',1),(11,'2021_07_01_202816_create_project_links_table',1),(12,'2021_07_01_204100_create_calls_table',1),(13,'2021_07_01_204922_create_data_table',1),(14,'2021_07_01_205107_create_terms_of_uses_table',1),(15,'2021_07_01_205350_create_discounts_table',1),(16,'2021_07_01_205616_create_discount_fors_table',1),(17,'2021_07_05_124246_create_clients_table',1),(18,'2021_07_08_091704_admins_table',1);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `orders`
--

DROP TABLE IF EXISTS `orders`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `orders` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `service_id` bigint(20) unsigned NOT NULL,
  `budget` enum('100-1000','1000-2500','2500-5000','5000-7500','7500-10000','10000-50000') COLLATE utf8mb4_unicode_ci NOT NULL,
  `details` varchar(2500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `orders_user_id_foreign` (`user_id`),
  KEY `orders_service_id_foreign` (`service_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `orders`
--

LOCK TABLES `orders` WRITE;
/*!40000 ALTER TABLE `orders` DISABLE KEYS */;
/*!40000 ALTER TABLE `orders` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `password_resets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `password_resets` (
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `password_resets`
--

LOCK TABLES `password_resets` WRITE;
/*!40000 ALTER TABLE `password_resets` DISABLE KEYS */;
/*!40000 ALTER TABLE `password_resets` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `project_links`
--

DROP TABLE IF EXISTS `project_links`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `project_links` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `project_id` bigint(20) unsigned NOT NULL,
  `link_id` bigint(20) unsigned NOT NULL,
  `linkAddress` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `project_links_project_id_foreign` (`project_id`),
  KEY `project_links_link_id_foreign` (`link_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `project_links`
--

LOCK TABLES `project_links` WRITE;
/*!40000 ALTER TABLE `project_links` DISABLE KEYS */;
INSERT INTO `project_links` VALUES (5,7,3,'https://www.behance.net/gallery/90113641/UXUI-E-commerce-sweet-app','2021-07-14 18:35:14','2021-07-14 18:35:14');
/*!40000 ALTER TABLE `project_links` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `projects`
--

DROP TABLE IF EXISTS `projects`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `projects` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name_ar` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_en` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `service_id` bigint(20) unsigned NOT NULL,
  `img1` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `img2` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `details_ar` varchar(2500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `details_en` varchar(2500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `star` enum('y','n') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'n',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `projects_service_id_foreign` (`service_id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `projects`
--

LOCK TABLES `projects` WRITE;
/*!40000 ALTER TABLE `projects` DISABLE KEYS */;
INSERT INTO `projects` VALUES (7,'UX/UI Designer E-commerce sweet app Ios .','UX/UI Designer E-commerce sweet app',7,'PROJECT_60eef622c4d1e5.53905293.png','PROJECT_60eef622c583c1.11856940.png','<p dir=\"rtl\" style=\"margin: 0px 0px 15px; padding: 0px; text-align: justify; font-family: \'Open Sans\', Arial, sans-serif; font-size: 14px; background-color: #ffffff;\">لوريم إيبسوم(Lorem Ipsum) هو ببساطة نص شكلي (بمعنى أن الغاية هي الشكل وليس المحتوى) ويُستخدم في صناعات المطابع ودور النشر. كان لوريم إيبسوم ولايزال المعيار للنص الشكلي منذ القرن الخامس عشر عندما قامت مطبعة مجهولة برص مجموعة من الأحرف بشكل عشوائي أخذتها من نص، لتكوّن كتيّب بمثابة دليل أو مرجع شكلي لهذه الأحرف. خمسة قرون من الزمن لم تقضي على هذا النص، بل انه حتى صار مستخدماً وبشكله الأصلي في الطباعة والتنضيد الإلكتروني. انتشر بشكل كبير في ستينيّات هذا القرن مع إصدار رقائق \"ليتراسيت\" (Letraset) البلاستيكية تحوي مقاطع من هذا النص، وعاد لينتشر مرة أخرى مؤخراَ مع ظهور برامج النشر الإلكتروني مثل \"ألدوس بايج مايكر\" (Aldus PageMaker) والتي حوت أيضاً على نسخ من نص لوريم إيبسوم.</p>\r\n<p>&nbsp;</p>','<p style=\"margin: 0px 0px 15px; padding: 0px; text-align: justify; font-family: \'Open Sans\', Arial, sans-serif; font-size: 14px; background-color: #ffffff;\">\"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.\"</p>\r\n<p>&nbsp;</p>','n','2021-07-14 18:28:43','2021-07-14 18:35:14');
/*!40000 ALTER TABLE `projects` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `services`
--

DROP TABLE IF EXISTS `services`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `services` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `img` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_ar` varchar(130) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_en` varchar(130) COLLATE utf8mb4_unicode_ci NOT NULL,
  `briefDetails_ar` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `briefDetails_en` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `details_ar` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `details_en` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `services`
--

LOCK TABLES `services` WRITE;
/*!40000 ALTER TABLE `services` DISABLE KEYS */;
INSERT INTO `services` VALUES (7,'SERVICES_60eef365ec3d56.77707089.png','تطوير تطبيقات الهواتف المحمول','Mobile Application  Development','Designing application interfaces\r\nAnd developed on iPhone and Android','Designing application interfaces\r\nAnd developed on iPhone and Android','<h5><strong>تصميم وتطوير واجهات التطبيقات على iPhone و Android</strong></h5>\r\n<p>من الواضح أن التطور السريع لتكنولوجيا المعلومات وانتشار تطبيقات الهواتف الذكية كان عددًا من</p>\r\n<p>&nbsp;</p>\r\n<p>أصبحت أنظمة Android و IOS عددًا كبيرًا من التطبيقات وأصبحت عددًا كبيرًا من التطبيقات</p>\r\n<p>&nbsp;</p>\r\n<p>أصحاب المواقع والشركات والشركة العربية الرائدة في مجال برمجة تطبيقات Android و iOS من</p>\r\n<p>&nbsp;</p>\r\n<p>من خلال التصميمات التي تسهل على المستخدمين استخدامها.</p>','<h5><strong>Designing and developing application interfaces on iPhone and Android</strong></h5>\r\n<p>Obviously, the rapid development of information technology And the proliferation of smartphone applications were a number of&nbsp;</p>\r\n<p>Android and IOS systems have become a large number of applications and have become a large number of applications</p>\r\n<p>The owners of sites and companies and the Arab company leading service programming applications android &amp; ios from</p>\r\n<p>&nbsp;</p>\r\n<p>Through designs that make it easy for users to use.</p>','2021-07-14 18:17:53','2021-07-14 18:25:26');
/*!40000 ALTER TABLE `services` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `terms_of_use`
--

DROP TABLE IF EXISTS `terms_of_use`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `terms_of_use` (
  `id` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL,
  `term_ar` varchar(2500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `term_en` varchar(2500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `terms_of_use`
--

LOCK TABLES `terms_of_use` WRITE;
/*!40000 ALTER TABLE `terms_of_use` DISABLE KEYS */;
/*!40000 ALTER TABLE `terms_of_use` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `city` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`),
  UNIQUE KEY `users_phone_unique` (`phone`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2021-07-27  5:21:58
