--
-- Host: localhost    Database: tawazen
-- ------------------------------------------------------


--
-- Table structure for table `avatars`
--

CREATE TABLE `avatars` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `order_show` int DEFAULT NULL,
  `picture` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT '1',
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'avatar',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `avatars` VALUES (1,1,'gallery/6gynp258TALRvGsMLOcbPOglVKR1BbbeCQAI4qzH.svg',1,'avatar','2024-04-27 09:40:42','2024-04-27 09:40:42'),(2,2,'gallery/3XXUYtzo1mRqlH3yz0EN60rNokKdQFUJBzyrXIQC.svg',1,'avatar','2024-04-27 09:40:53','2024-04-27 09:40:53'),(3,3,'gallery/nZW3iKxPcngA0tScNh18znmmA70A8liZE6d93gKu.svg',1,'avatar','2024-04-27 09:41:04','2024-05-01 08:00:42'),(4,4,'gallery/oKud5HpL25BqwOHT43j852sHkAcOj7Pz5MNJ9d5D.svg',1,'avatar','2024-04-27 09:42:38','2024-04-27 09:42:38'),(5,5,'gallery/bi0Q3i64DwsFFKJ4rxi86Mac1fIGimKwxQ27O57A.svg',1,'avatar','2024-04-27 09:42:51','2024-04-27 09:42:51'),(6,6,'gallery/vAY4dW0rRhdd7a5EULpeO8Kr4lIZDk6pNCJoCnZ0.svg',1,'avatar','2024-04-27 09:43:06','2024-04-27 09:43:06'),(7,7,'gallery/0TeWHVBjKgAfaiSSXL7WPCz2hwSSiQz2qsrSYaCy.svg',1,'avatar','2024-04-27 09:43:24','2024-04-27 09:43:24'),(8,8,'gallery/UMKjAWyo0OI6atprZo0I2vSrGoWlVN6BEieN3lxc.svg',1,'avatar','2024-04-27 09:43:37','2024-04-27 09:43:37');

--
-- Table structure for table `category_quizs`
--

CREATE TABLE `category_quizs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title_ar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title_en` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT '1',
  `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 `category_quizs`
--


--
-- Table structure for table `companies`
--

CREATE TABLE `companies` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tel` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `responsible` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `companies` VALUES (1,'TEST updated',NULL,'uploads/company_logos/yQHYjRbMLldOsLrDDptqSLUkL7Qz4GZmeYG0Dmr4.svg','test@test.co','96650879452','Saleh','2024-03-30 10:01:50','2024-04-27 10:15:30'),(2,'test','test FF','uploads/company_logos/Ql0uB3A90TVyJ6a0qcfdrOheZVFl9oXkDMVH9r80.png',NULL,NULL,NULL,'2024-05-01 09:29:20','2024-05-01 15:29:44');

--
-- Table structure for table `contents`
--

CREATE TABLE `contents` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_content` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `enabled` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `contents` VALUES (1,'User terms & conditions','terms_conditions','Welcome and Acceptance\r\nWelcome to TAWAZON (“Company”, “we”, “our”, “us”)! These Terms of Service (“Terms”) govern your use of our website (https://TAWAZON.com), applications, and in-person services (collectively referred to as the “Service”) provided by TAWAZON Lifestyle Coaching. By using our Service, you agree to abide by these Terms and our Privacy Policy. If you do not agree to these terms, please refrain from using the Service.\r\nCommunication Preferences\r\nBy agreeing to these Terms, you consent to receive newsletters, marketing materials, and updates from us. You can opt out of receiving these communications at any time by following the unsubscribe link or contacting us directly.\r\nContests, Promotions, and Sweepstakes\r\nAny contests, promotions, or sweepstakes (“Promotions”) offered through our Service are subject to specific rules. Please review the applicable rules and our Privacy Policy before participating in any Promotions.\r\nOur Services\r\nTAWAZON provides services to help users assess their physical, mental health and enhance performance. Our goal is to promote awareness of health topics and encourage proactive health management. Recommendations provided within the Service may require separate purchase. If third-party services are utilized, users must adhere to their terms and conditions.\r\nHealth Advisory\r\nOur Services are not a substitute for medical consultation or examination. Users with pre-existing conditions or expectant mothers should consult their doctor before using the Services. Discontinue use and seek medical advice if you experience health issues while using our Service.\r\nProhibited Activities\r\nUsers must use the Service only for lawful purposes and in compliance with these Terms. Prohibited activities include violating laws, harming minors, sending spam, or disrupting the Service\'s operation.\r\nIntellectual Property\r\nAll content and trademarks on the Service belong to TAWAZON Lifestyle Coaching and its licensors. Users are not permitted to use our trademarks or content for commercial purposes without prior consent.\r\nCopyright Policy\r\nWe respect intellectual property rights. If you believe our Service contains infringing content, please contact us at [Contact Email].\r\nLiability Limitation\r\nTAWAZON is not liable for damages arising from the use of our Service, including indirect or consequential damages.\r\nTermination\r\nWe reserve the right to terminate or suspend user accounts without prior notice for any reason. Users can terminate their account by discontinuing use of the Service.\r\nGoverning Law\r\nThese Terms are governed by the laws of the United Arab Emirates. Disputes will be resolved according to these laws.\r\nService Changes\r\nWe may modify or discontinue parts of the Service at our discretion without notice.\r\nTerms Amendments\r\nWe may update these Terms periodically. Continued use of the Service after changes constitutes acceptance of the revised Terms.\r\nContact Information\r\nFor inquiries or feedback, please contact us at [Contact Email].\r\nBy using our Service, you acknowledge and agree to these Terms.',1,'2024-05-01 07:28:18','2024-05-01 07:28:18'),(2,'TAWAZON Cookie Policy','Cookie_Policy','A “cookie” is a small piece of data stored on your computer\'s hard drive. It records your interactions with a website, allowing the site to tailor your experience based on your preferences. Cookies are commonly used for analyzing website traffic and for advertising purposes.\r\nMost websites use cookies without causing harm to your system. You can manage which types of cookies you accept through your browser settings. Blocking cookies may limit your access to certain parts of a site, including essential functions.\r\nCookies help us track your website usage patterns, enabling us to improve our services and products based on your needs.\r\nCookies fall into two main categories:\r\n•	Session cookies: Temporary cookies that are deleted when you close your browser. They allow you to browse a site without logging in on every page.\r\n•	Persistent cookies: Stored on your computer and remain after you close your browser. The website that created them can access them when you revisit the site.\r\nCookies can also be classified as:\r\n•	Strictly necessary cookies: Essential for site functionality, such as making purchases. They do not collect personal information for marketing purposes.\r\n•	Performance cookies: Used to monitor and enhance website performance by analyzing visitor behavior.\r\n•	Functionality cookies: Remember your choices to provide personalized features.\r\nFor more details on the cookies we use and their purposes, refer to the list below.\r\nStrictly Necessary Cookies\r\nThese cookies are essential for website functionality and cannot be disabled. They are activated in response to your actions on the site, such as setting privacy preferences or filling out forms. Disabling these cookies may affect certain features of the site, but they do not store personally identifiable information.\r\nAnalytics Cookies\r\nThese cookies help us analyze website traffic and improve site performance by providing aggregated, anonymous data. If you disable these cookies, we will not be able to monitor site performance and make necessary improvements.\r\nAdvertising Cookies\r\nThese cookies are set by our advertising partners to deliver targeted ads based on your interests. They do not store personal information directly but use browser and device identifiers. Disabling these cookies may result in less targeted advertising.\r\nCookie Settings\r\nYou can manage your cookie preferences through your browser settings. For more information or if you have any questions about our policies, please contact us at [contact email or address].',1,'2024-05-01 07:29:07','2024-05-01 07:29:07'),(3,'TAWAZON Data Protection Policy','protection_policy','At TAWAZON, we prioritize trust and respect your privacy. This privacy statement outlines the types of personal data we collect, how it is collected, and how we use it across our range of products and services. This statement is regularly updated to align with our evolving offerings. TAWAZON is committed to upholding privacy through continuous education, professionalism, and ethical conduct among our employees and partners, ensuring robust protection of your personal data.\r\nWho We Are\r\nThink about a world where every individual has access to tools and resources empowering their best work and well-being daily. This is the vision of TAWAZON. We believe in holistic health as a fundamental right and have created accessible and sustainable solutions for all. TAWAZON is a personalized, proactive digital well-being platform focused on enhancing individual and organizational performance through holistic well-being. We integrate support, recognition, and rewards into a single online well-being solution, engaging 100% of your workforce. By addressing Nutritional, Social, Mental, Professional, Physical, and Financial Well-being, we foster proactive and sustainable well-being globally, placing employee well-being at the core of business strategy.\r\nWhat Personal Data We Collect\r\nTAWAZON collects personal data to deliver our products and services. This may include your name, contact details (email, phone numbers), location, and date of birth. Sensitive information is processed only when explicitly required and within legal constraints. You provide some data directly by subscribing to newsletters, requesting product/service offers, or using our websites with tracking cookies.\r\nHow We Use Personal Data\r\nWe collect only necessary personal data for processing, based on consent, contractual obligations, legal requirements, public interest tasks, or legitimate interests. Personal data is used for customer assessment, product/service development, agreement execution, relationship management, marketing, internal processes, and compliance with laws.\r\nWhere Your Data Is Stored\r\nTAWAZON processes personal data on-site in our data center, online with reputable providers, and through selected third-party applications (cloud). We maintain strict security standards to safeguard your data. Storage duration depends on the processing type; data is retained until it serves its purpose or as required by law.\r\nSharing Personal Data\r\nWe generally do not share personal data for external purposes. Third parties may receive data to provide our products/services; they are bound to confidentiality and specific use obligations.\r\nData Access\r\nAccess to personal data within TAWAZON and by third parties is limited to those who need it for processing purposes, under strict \'need to know\' principles.\r\nYour Rights\r\nUnder the General Data Protection Regulation (GDPR), you have rights including access, rectification, erasure, restriction of processing, objection to processing, and data portability. You also have the right to lodge a complaint with the Data Protection Authority.\r\nPrivacy Statement Updates\r\nThis TAWAZON Privacy Statement was created in [Month, Year]. We update it as needed; significant changes are communicated directly or through our website. In case of conflict with any customer agreements, the terms of those agreements prevail.\r\nQuestions About Privacy at TAWAZON?\r\nFor inquiries about our privacy policy, contact our Corporate Information Security & Privacy Office at privacy@tawazon.com.\r\nConsent\r\nBy using TAWAZON products/services, you acknowledge and accept our Privacy Policy and Privacy Code for Employee Data',1,'2024-05-01 07:29:53','2024-05-01 07:29:53');

--
-- Table structure for table `departments`
--

CREATE TABLE `departments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `departments` VALUES (1,'IT','it','2024-05-05 13:37:48','2024-05-05 13:37:48');

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

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


--
-- Table structure for table `gallery_secteurs`
--

CREATE TABLE `gallery_secteurs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `picture` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT '1',
  `secteur_id` bigint 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 `gallery_secteurs_secteur_id_foreign` (`secteur_id`),
  CONSTRAINT `gallery_secteurs_secteur_id_foreign` FOREIGN KEY (`secteur_id`) REFERENCES `secteurs` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `gallery_secteurs` VALUES (10,'Baseball','gallery/zf7qlOwtXAD1PGXsP6jfNzOJ4iAgEQMr0cHVZ2RP.png',1,3,NULL,'2024-04-14 04:35:08','2024-05-01 07:47:02'),(11,'test','gallery/nu2XlhIDWT9waSeFXzNaA6EhMqtBlnzqCCQFPfWQ.png',1,3,NULL,'2024-04-14 08:46:26','2024-05-01 07:47:20'),(12,'Cycling','gallery/eWOjwDMxH13joDISQ89rbyM60sy8OYuwQKqBNIFr.png',1,3,NULL,'2024-04-14 08:47:10','2024-05-01 07:47:34'),(13,'Golf','gallery/MJ1CW8MprtPYPFivV7HOZOsVb2kEQu4xvgaQA0KX.png',1,3,NULL,'2024-04-14 09:09:53','2024-05-01 07:47:50'),(14,'Handball','gallery/OuAJgsgJWf4wf7UxrBmYsN7Z33BnAIVT4Y97CTPF.png',1,3,NULL,'2024-04-14 09:13:40','2024-05-01 07:48:01'),(15,'Running','gallery/CDGGWQduSDpSr32D7932HJ6D8DmF7U5N1ZpSna0n.png',1,3,NULL,'2024-05-01 07:48:13','2024-05-01 07:48:13'),(16,'Skateboarding','gallery/E48Qx5hlwIDix6sfSwt3QIvsqnZFXaltkEUFwkWk.png',1,3,NULL,'2024-05-01 07:49:52','2024-05-01 07:49:52'),(17,'Soccer','gallery/061e93l0DswUrbUxPQ2CnEuIfX3WzCoUyVXcjHPQ.png',1,3,NULL,'2024-05-01 07:50:02','2024-05-01 07:50:02'),(18,'Surfing','gallery/Ka8HCZiAM5MYY8xv4WdvBH8AwzbCbURP4d4f9WmL.png',1,3,NULL,'2024-05-01 07:50:16','2024-05-01 07:50:16'),(19,'Swimming','gallery/XYON7uDOioN4H3bdZz7oRlRkAFoWvGIqWlfIUvSP.png',1,3,NULL,'2024-05-01 07:50:29','2024-05-01 07:50:29'),(20,'Tennis','gallery/VpKnSIVAHwO8BIYtshmcQG8gMErZiInMKy4BfyoO.png',1,3,NULL,'2024-05-01 07:50:41','2024-05-01 07:50:41'),(21,'Volleyball','gallery/MZVmU0TFXy08r437ESwh1vAl0Jv2TCWbT6PQZHn2.png',1,3,NULL,'2024-05-01 07:50:52','2024-05-01 07:50:52'),(22,'test','gallery/CPUQkQHoFGN4GSoqYKcmqEUh4PXy9ncN9MDORhNP.png',1,5,NULL,'2024-05-01 15:55:46','2024-05-01 15:55:46'),(23,'ccc','gallery/CW1V07a4tiY4NOaCmJUA1kA2Ff3InMXk6IAyksnF.png',1,5,NULL,'2024-05-01 15:56:04','2024-05-01 15:56:04'),(24,'test 3','gallery/SEXtDEUu2FLo89acIRI2aJQk31DO8jyzIpfnsDFO.png',1,6,NULL,'2024-05-01 15:57:01','2024-05-01 15:57:01'),(25,'test 4','gallery/NLeMUeaRY1x5WD5rPkIxYo94Pk50chfMMSAuS5xE.png',1,6,NULL,'2024-05-01 15:57:17','2024-05-01 15:57:17');

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

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_reset_tokens_table',1),(3,'2014_10_12_100000_create_password_resets_table',1),(4,'2019_08_19_000000_create_failed_jobs_table',1),(5,'2019_12_14_000001_create_personal_access_tokens_table',1),(6,'2024_03_24_160620_create_roles_table',1),(7,'2024_03_30_101317_create_companies_table',2),(9,'2024_03_30_160929_add_attributes_users',3),(10,'2024_04_06_135116_add_employee_attributes_to_users_table',4),(11,'2024_04_13_070748_create_secteurs_table',4),(12,'2024_04_13_071020_create_gallery_secteurs_table',4),(13,'2024_04_22_071448_create_avatars_table',5),(14,'2024_04_22_211620_add_background_color_to_secteurs_table',6),(15,'2024_04_23_061104_add_image_to_users',7),(17,'2024_04_24_053848_create_contents_table',8),(19,'2024_04_24_065414_create_user_sectors_table',9),(20,'2024_04_24_071351_create_user_gallery_sectors_table',9),(21,'2024_04_28_091925_add_update_attributes',10),(22,'2024_04_28_092653_add_type_attribute',10),(23,'2024_04_28_092938_create_user_company_table',10),(24,'2024_04_28_100400_add_code_attribute',10),(26,'2024_05_01_080226_create_quizs_table',11),(27,'2024_05_01_080400_create_quiz_answers_table',11),(28,'2024_05_04_202132_create_departments_table',12),(29,'2024_05_04_202633_add_attributes_to_users',13),(30,'2024_05_07_085456_create_category_quizs_table',14);

--
-- Table structure for table `quiz_answers`
--

CREATE TABLE `quiz_answers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `quiz_id` bigint unsigned DEFAULT NULL,
  `answers_en` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `answers_ar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order_show` int DEFAULT NULL,
  `score` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `quiz_answers_quiz_id_foreign` (`quiz_id`),
  CONSTRAINT `quiz_answers_quiz_id_foreign` FOREIGN KEY (`quiz_id`) REFERENCES `quizs` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `quiz_answers` VALUES (1,1,'Never','أبدًا',1,0,NULL,'2024-05-01 07:14:24','2024-05-01 07:14:24'),(2,1,'little','قليلا',2,1,NULL,'2024-05-01 07:14:47','2024-05-01 07:14:47'),(3,1,'Sometimes','أحيانا',3,2,NULL,'2024-05-01 07:15:02','2024-05-01 07:15:02'),(4,1,'Always','دائما',4,3,NULL,'2024-05-01 07:15:18','2024-05-01 07:15:18'),(5,2,'Never','أبدًا',1,0,NULL,'2024-05-01 07:16:16','2024-05-01 07:16:16'),(6,2,'little','قليلا',2,1,NULL,'2024-05-01 07:16:28','2024-05-01 07:16:28'),(7,2,'Sometimes','أحيانا',3,2,NULL,'2024-05-01 07:16:38','2024-05-01 07:16:38'),(8,2,'Always','دائما',4,3,NULL,'2024-05-01 07:16:50','2024-05-01 07:16:50'),(9,3,'Never','أبدًا',1,0,NULL,'2024-05-01 07:17:10','2024-05-01 07:17:10'),(10,3,'Always','دائما',4,3,NULL,'2024-05-01 07:17:37','2024-05-01 07:17:37'),(11,3,'Sometimes','أحيانا',3,2,NULL,'2024-05-01 07:17:42','2024-05-01 07:17:42'),(12,3,'little','قليلا',2,1,NULL,'2024-05-01 07:17:54','2024-05-01 07:17:54'),(13,4,'Always','دائما',4,3,NULL,'2024-05-01 07:18:35','2024-05-01 07:18:35'),(14,4,'Sometimes','أحيانا',3,2,NULL,'2024-05-01 07:18:52','2024-05-01 07:18:52'),(15,4,'little','قليلا',2,1,NULL,'2024-05-01 07:18:57','2024-05-01 07:18:57'),(16,4,'Never','أبدًا',1,0,NULL,'2024-05-01 07:19:01','2024-05-01 07:19:01'),(17,5,'Always','دائما',4,3,NULL,'2024-05-01 07:19:26','2024-05-01 07:19:26'),(18,5,'Never','أبدًا',1,0,NULL,'2024-05-01 07:19:51','2024-05-01 07:19:51'),(19,5,'little','قليلا',2,1,NULL,'2024-05-01 07:19:57','2024-05-01 07:19:57'),(20,5,'Sometimes','أحيانا',3,2,NULL,'2024-05-01 07:20:01','2024-05-01 07:20:01'),(21,6,'Never','أبدًا',1,0,NULL,'2024-05-01 07:20:25','2024-05-01 07:20:25'),(22,6,'Always','دائما',4,3,NULL,'2024-05-01 07:20:48','2024-05-01 07:20:48'),(23,6,'Sometimes','أحيانا',3,2,NULL,'2024-05-01 07:20:57','2024-05-01 07:20:57'),(24,6,'little','قليلا',2,1,NULL,'2024-05-01 07:21:03','2024-05-01 07:21:03');

--
-- Table structure for table `quizs`
--

CREATE TABLE `quizs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `quiz_en` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quiz_ar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `picture` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order_show` int DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT '1',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `category_quiz_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `quizs` VALUES (1,'I encourage my child to freely “speak his/her mind”, even if he/she disagrees with me','أشجع طفلي على التعبير بحرية عن آرائه/آراءها، حتى إذا كانت مخالفة لرأيي','gallery/M2K9OTzEb8yFxZfnZNwKdHQjYZgaqDzn1ceG7SZp.png',1,1,NULL,'2024-05-01 07:04:35','2024-05-01 07:04:35',NULL),(2,'Investment decisions are made independently of how to finance them','يتم اتخاذ قرارات الاستثمار بشكل مستقل عن كيفية تمويلها.','gallery/MFA39gWxyGSZ9uYdktr2UpZw9eUv6LOWsBiVyLgR.png',2,1,NULL,'2024-05-01 07:05:17','2024-05-01 07:05:17',NULL),(3,'I usually Have the habit of avoiding some foods for health reasons','عادةً ما أتجنب بعض الأطعمة لأسباب صحية','gallery/IKk921Lkq9tXyvlxffQIra1KEw3U9E0cmNB0fZlv.png',3,1,NULL,'2024-05-01 07:05:37','2024-05-01 07:05:37',NULL),(4,'Having to cope with stress can make me stronger','التعامل مع الضغوطات يمكن أن يجعلني أقوى.','gallery/EYUvTGfmQsdAsuWNTTgE0jVBvPuh0sAFipmhGXMV.png',4,1,NULL,'2024-05-01 07:06:05','2024-05-01 07:06:05',NULL),(5,'In a typical week, I usually do vigorous-intensity sports, fitness or recreational (leisure) activities?','في الأسبوع النموذجي، هل أمارس الرياضة بشكل مكثف أو الأنشطة الترفيهية؟','gallery/2i0W3nsk4yPfvtL0b8ymj9XAnidOHiuii7MMSLhp.png',5,1,NULL,'2024-05-01 07:06:46','2024-05-01 07:06:46',NULL),(6,'When learning a new skill, I am most comfortable to give it a try myself & work it out as I go','عندما أتعلم مهارة جديدة، أشعر بالراحة عند تجربتها بنفسي وحل المشكلات أثناء التعلم.','gallery/XpBiMDSDFHorqegT22s7gmcHRjgAyOr43ntFlAdA.png',6,1,NULL,'2024-05-01 07:07:31','2024-05-01 07:07:31',NULL);

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

CREATE TABLE `roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `roles` VALUES (1,'Admin','admin','Admin of plateforme updated','2024-03-30 08:44:58','2024-03-30 08:45:07'),(2,'HR Company','hr_company','HR of Company','2024-03-30 09:00:14','2024-03-30 09:23:40'),(3,'Employee','employee','Employee of company','2024-03-30 09:24:44','2024-03-30 09:24:44'),(4,'Collaborator','collaborator','Collaborator of company','2024-05-01 04:02:08','2024-05-01 04:02:08');

--
-- Table structure for table `secteurs`
--

CREATE TABLE `secteurs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order_show` int DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT '1',
  `secteur_id` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `background_color` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `secteurs_secteur_id_foreign` (`secteur_id`),
  CONSTRAINT `secteurs_secteur_id_foreign` FOREIGN KEY (`secteur_id`) REFERENCES `secteurs` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `secteurs` VALUES (1,'test',10000000,0,NULL,NULL,'2024-04-13 11:00:41','2024-05-01 07:46:32',NULL),(2,'ytrd 25555',1,1,1,NULL,'2024-04-13 11:06:59','2024-04-13 11:28:06',NULL),(3,'What Sports get your heart racing',1,1,NULL,NULL,'2024-04-13 11:29:10','2024-05-01 07:46:39',NULL),(4,'new test',2,1,NULL,NULL,'2024-04-27 14:13:05','2024-05-01 15:56:23',NULL),(5,'sub-sector',1,1,4,NULL,'2024-04-27 14:13:52','2024-04-27 14:13:52','#FFFF'),(6,'sub_sector 2',2,1,4,NULL,'2024-05-01 15:56:46','2024-05-01 15:56:46',NULL);

--
-- Table structure for table `user_company`
--

CREATE TABLE `user_company` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `company_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `user_company` VALUES (1,2,1,NULL,NULL),(2,2,2,NULL,NULL);

--
-- Table structure for table `user_gallery_sectors`
--

CREATE TABLE `user_gallery_sectors` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_sector_id` bigint unsigned DEFAULT NULL,
  `gallery_secteur_id` bigint 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 `user_gallery_sectors_user_sector_id_foreign` (`user_sector_id`),
  KEY `user_gallery_sectors_gallery_secteur_id_foreign` (`gallery_secteur_id`),
  CONSTRAINT `user_gallery_sectors_gallery_secteur_id_foreign` FOREIGN KEY (`gallery_secteur_id`) REFERENCES `gallery_secteurs` (`id`),
  CONSTRAINT `user_gallery_sectors_user_sector_id_foreign` FOREIGN KEY (`user_sector_id`) REFERENCES `user_sectors` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=74 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

--
-- Table structure for table `user_sectors`
--

CREATE TABLE `user_sectors` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned DEFAULT NULL,
  `secteur_id` bigint 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 `user_sectors_user_id_foreign` (`user_id`),
  KEY `user_sectors_secteur_id_foreign` (`secteur_id`),
  CONSTRAINT `user_sectors_secteur_id_foreign` FOREIGN KEY (`secteur_id`) REFERENCES `secteurs` (`id`),
  CONSTRAINT `user_sectors_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `user_sectors` VALUES (1,4,3,'2024-05-05 21:58:06','2024-05-05 21:57:00','2024-05-05 21:58:06'),(2,4,3,'2024-05-05 22:09:38','2024-05-05 21:58:46','2024-05-05 22:09:38'),(3,4,3,'2024-05-05 22:22:44','2024-05-05 22:09:38','2024-05-05 22:22:44'),(4,4,3,'2024-05-05 22:50:47','2024-05-05 22:22:44','2024-05-05 22:50:47'),(5,4,3,'2024-05-06 17:49:52','2024-05-05 22:50:47','2024-05-06 17:49:52'),(6,4,3,'2024-05-06 18:15:07','2024-05-06 17:49:52','2024-05-06 18:15:07'),(7,4,3,'2024-05-06 18:23:49','2024-05-06 18:15:07','2024-05-06 18:23:49'),(8,4,3,'2024-05-06 18:24:39','2024-05-06 18:23:49','2024-05-06 18:24:39'),(9,4,3,'2024-05-06 18:26:05','2024-05-06 18:24:39','2024-05-06 18:26:05'),(10,4,3,'2024-05-06 18:38:04','2024-05-06 18:26:05','2024-05-06 18:38:04'),(11,4,3,'2024-05-07 07:45:04','2024-05-06 18:38:04','2024-05-07 07:45:04'),(12,4,3,'2024-05-07 19:31:09','2024-05-07 07:45:04','2024-05-07 19:31:09'),(13,4,3,'2024-05-07 20:28:50','2024-05-07 19:31:09','2024-05-07 20:28:50'),(14,4,3,'2024-05-07 22:26:55','2024-05-07 20:28:50','2024-05-07 22:26:55'),(15,4,3,'2024-05-07 22:45:38','2024-05-07 22:26:55','2024-05-07 22:45:38'),(16,4,3,'2024-05-07 23:26:13','2024-05-07 22:45:38','2024-05-07 23:26:13'),(17,4,3,'2024-05-07 23:31:54','2024-05-07 23:26:13','2024-05-07 23:31:54'),(18,4,3,'2024-05-07 23:48:22','2024-05-07 23:31:54','2024-05-07 23:48:22'),(19,4,3,'2024-05-08 00:03:09','2024-05-07 23:48:22','2024-05-08 00:03:09'),(20,4,2,'2024-05-08 00:03:40','2024-05-08 00:03:09','2024-05-08 00:03:40'),(21,4,3,'2024-05-08 00:04:57','2024-05-08 00:03:40','2024-05-08 00:04:57'),(22,4,5,'2024-05-08 00:05:07','2024-05-08 00:04:57','2024-05-08 00:05:07'),(23,4,3,'2024-05-08 00:20:27','2024-05-08 00:05:07','2024-05-08 00:20:27'),(24,4,3,'2024-05-08 00:20:42','2024-05-08 00:20:27','2024-05-08 00:20:42'),(25,4,3,'2024-05-08 00:35:32','2024-05-08 00:20:43','2024-05-08 00:35:32'),(26,4,3,'2024-05-08 00:39:24','2024-05-08 00:35:32','2024-05-08 00:39:24'),(27,4,3,'2024-05-08 00:40:24','2024-05-08 00:39:24','2024-05-08 00:40:24'),(28,4,3,'2024-05-08 01:07:33','2024-05-08 00:40:24','2024-05-08 01:07:33'),(29,4,3,'2024-05-08 01:08:59','2024-05-08 01:07:33','2024-05-08 01:08:59'),(30,4,5,'2024-05-08 02:19:32','2024-05-08 01:08:59','2024-05-08 02:19:32'),(31,4,3,'2024-05-08 02:23:33','2024-05-08 02:19:32','2024-05-08 02:23:33'),(32,4,3,'2024-05-08 02:23:39','2024-05-08 02:23:33','2024-05-08 02:23:39'),(33,4,5,'2024-05-08 02:24:12','2024-05-08 02:23:39','2024-05-08 02:24:12'),(34,4,3,'2024-05-08 02:27:05','2024-05-08 02:24:12','2024-05-08 02:27:05'),(35,4,3,'2024-05-08 02:27:14','2024-05-08 02:27:05','2024-05-08 02:27:14'),(36,4,5,'2024-05-08 02:27:25','2024-05-08 02:27:14','2024-05-08 02:27:25'),(37,4,5,'2024-05-08 02:28:23','2024-05-08 02:27:25','2024-05-08 02:28:23'),(38,4,5,'2024-05-08 02:30:12','2024-05-08 02:28:23','2024-05-08 02:30:12'),(39,4,3,'2024-05-08 02:30:19','2024-05-08 02:30:12','2024-05-08 02:30:19'),(40,4,5,'2024-05-08 02:37:41','2024-05-08 02:30:19','2024-05-08 02:37:41'),(41,4,3,'2024-05-08 02:37:49','2024-05-08 02:37:41','2024-05-08 02:37:49'),(42,4,5,NULL,'2024-05-08 02:37:49','2024-05-08 02:37:49');


