DROP TABLE activity_log;

CREATE TABLE `activity_log` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `log_name` varchar(191) DEFAULT NULL,
  `description` text NOT NULL,
  `subject_type` varchar(191) DEFAULT NULL,
  `event` varchar(191) DEFAULT NULL,
  `subject_id` bigint(20) unsigned DEFAULT NULL,
  `causer_type` varchar(191) DEFAULT NULL,
  `causer_id` bigint(20) unsigned DEFAULT NULL,
  `properties` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`properties`)),
  `batch_uuid` char(36) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `subject` (`subject_type`,`subject_id`),
  KEY `causer` (`causer_type`,`causer_id`),
  KEY `activity_log_log_name_index` (`log_name`)
) ENGINE=MyISAM AUTO_INCREMENT=136 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO activity_log VALUES("1","default","updated","App\\Models\\Project","updated","2","App\\Models\\User","2","{\"attributes\":{\"name\":\"\\u0641\\u064a\\u0644\\u0627 \\u0627\\u0644\\u0633\\u0644\\u0627\\u0645\\u0629 445 \\u0637\\u0631\\u064a\\u0642 \\u0627\\u0644\\u062d\\u062c\\u0627\\u0632 -1\",\"end_date\":\"2025-05-24\",\"updated_at\":\"2025-02-01T13:51:32.000000Z\",\"supervisor_id\":1},\"old\":{\"name\":\"\\u0641\\u064a\\u0644\\u0627 \\u0627\\u0644\\u0633\\u0644\\u0627\\u0645\\u0629 445 \\u0637\\u0631\\u064a\\u0642 \\u0627\\u0644\\u062d\\u062c\\u0627\\u0632\",\"end_date\":null,\"updated_at\":\"2025-01-15T10:31:34.000000Z\",\"supervisor_id\":null}}","","2025-02-01 13:51:32","2025-02-01 13:51:32");
INSERT INTO activity_log VALUES("2","default","updated","App\\Models\\Project","updated","4","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-06T08:19:39.000000Z\",\"current_procedure_id\":2},\"old\":{\"updated_at\":\"2025-01-19T22:37:10.000000Z\",\"current_procedure_id\":null}}","","2025-05-06 08:19:39","2025-05-06 08:19:39");
INSERT INTO activity_log VALUES("3","default","updated","App\\Models\\Project","updated","2","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-08T07:46:26.000000Z\",\"current_procedure_id\":9},\"old\":{\"updated_at\":\"2025-02-01T13:51:32.000000Z\",\"current_procedure_id\":null}}","","2025-05-08 07:46:26","2025-05-08 07:46:26");
INSERT INTO activity_log VALUES("4","default","updated","App\\Models\\Project","updated","2","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-08T07:48:30.000000Z\",\"current_procedure_id\":4},\"old\":{\"updated_at\":\"2025-05-08T07:46:26.000000Z\",\"current_procedure_id\":9}}","","2025-05-08 07:48:30","2025-05-08 07:48:30");
INSERT INTO activity_log VALUES("5","default","updated","App\\Models\\Project","updated","2","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-11T12:11:48.000000Z\",\"current_procedure_id\":2},\"old\":{\"updated_at\":\"2025-05-08T07:48:30.000000Z\",\"current_procedure_id\":4}}","","2025-05-11 12:11:48","2025-05-11 12:11:48");
INSERT INTO activity_log VALUES("6","default","updated","App\\Models\\Project","updated","2","App\\Models\\User","2","{\"attributes\":{\"available_procedures\":[\"1\",\"2\",\"3\",\"6\"],\"updated_at\":\"2025-05-12T08:24:55.000000Z\"},\"old\":{\"available_procedures\":[\"2\"],\"updated_at\":\"2025-05-11T12:11:48.000000Z\"}}","","2025-05-12 08:24:55","2025-05-12 08:24:55");
INSERT INTO activity_log VALUES("7","default","updated","App\\Models\\Project","updated","2","App\\Models\\User","2","{\"attributes\":{\"available_procedures\":[\"3\"],\"updated_at\":\"2025-05-12T08:25:47.000000Z\"},\"old\":{\"available_procedures\":[\"1\",\"2\",\"3\",\"6\"],\"updated_at\":\"2025-05-12T08:24:55.000000Z\"}}","","2025-05-12 08:25:47","2025-05-12 08:25:47");
INSERT INTO activity_log VALUES("8","default","updated","App\\Models\\Project","updated","5","App\\Models\\User","2","{\"attributes\":{\"end_date\":\"2025-03-21\",\"updated_at\":\"2025-05-12T21:48:55.000000Z\"},\"old\":{\"end_date\":null,\"updated_at\":\"2025-01-26T22:26:35.000000Z\"}}","","2025-05-12 21:48:55","2025-05-12 21:48:55");
INSERT INTO activity_log VALUES("9","default","updated","App\\Models\\Project","updated","5","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-12T22:03:33.000000Z\",\"current_procedure_id\":5},\"old\":{\"updated_at\":\"2025-05-12T21:48:55.000000Z\",\"current_procedure_id\":4}}","","2025-05-12 22:03:33","2025-05-12 22:03:33");
INSERT INTO activity_log VALUES("10","default","created","App\\Models\\Project","created","6","App\\Models\\User","2","{\"attributes\":{\"id\":6,\"name\":\"\\u0645\\u062d\\u0645\\u0648\\u062f\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"2025-12-05\",\"end_date\":\"2026-10-01\",\"period\":300,\"manager_id\":6,\"deleted_at\":null,\"created_at\":\"2025-05-13T00:38:47.000000Z\",\"updated_at\":\"2025-05-13T00:38:47.000000Z\",\"supervisor_id\":1,\"consultant_id\":8,\"cost\":20000000,\"customer\":\"\\u0633\\u0644\\u0645\\u0627\\u0646\",\"email\":\"mohamedhashem2001111@gmail.com\",\"number1\":null,\"number2\":null,\"number3\":null,\"current_procedure_id\":null,\"status\":1}}","","2025-05-13 00:38:47","2025-05-13 00:38:47");
INSERT INTO activity_log VALUES("11","default","created","App\\Models\\Project","created","7","App\\Models\\User","2","{\"attributes\":{\"id\":7,\"name\":\"Test\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"0033-02-04\",\"end_date\":\"0033-05-15\",\"period\":100,\"manager_id\":2,\"deleted_at\":null,\"created_at\":\"2025-05-13T07:16:34.000000Z\",\"updated_at\":\"2025-05-13T07:16:34.000000Z\",\"supervisor_id\":1,\"consultant_id\":8,\"cost\":400000,\"customer\":\"nk.knk\",\"email\":\"8880565a9f6b@drmail.in\",\"number1\":\"1234567890\",\"number2\":\"24334434334\",\"number3\":\"34435444341\",\"current_procedure_id\":null,\"status\":1}}","","2025-05-13 07:16:34","2025-05-13 07:16:34");
INSERT INTO activity_log VALUES("12","default","updated","App\\Models\\Project","updated","7","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-13T07:17:24.000000Z\"},\"old\":{\"updated_at\":\"2025-05-13T07:16:34.000000Z\"}}","","2025-05-13 07:17:24","2025-05-13 07:17:24");
INSERT INTO activity_log VALUES("13","default","created","App\\Models\\Project","created","8","App\\Models\\User","2","{\"attributes\":{\"id\":8,\"name\":\"\\u0645\\u0634\\u0631\\u0639\\u064a\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"2025-05-01\",\"end_date\":\"2025-08-09\",\"period\":100,\"manager_id\":2,\"deleted_at\":null,\"created_at\":\"2025-05-13T07:17:59.000000Z\",\"updated_at\":\"2025-05-13T07:17:59.000000Z\",\"supervisor_id\":1,\"consultant_id\":8,\"cost\":2147483647,\"customer\":\"\\u0627\\u0644\\u0639\\u0645\\u064a\\u0644\",\"email\":\"xyz@gamil.com\",\"number1\":\"29\",\"number2\":\"12\",\"number3\":\"50\",\"current_procedure_id\":null,\"status\":1}}","","2025-05-13 07:17:59","2025-05-13 07:17:59");
INSERT INTO activity_log VALUES("14","default","updated","App\\Models\\Project","updated","8","App\\Models\\User","2","{\"attributes\":{\"name\":\"\\u0645\\u0634\\u0631\\u0648\\u0639\\u064a\",\"updated_at\":\"2025-05-13T07:18:19.000000Z\"},\"old\":{\"name\":\"\\u0645\\u0634\\u0631\\u0639\\u064a\",\"updated_at\":\"2025-05-13T07:17:59.000000Z\"}}","","2025-05-13 07:18:19","2025-05-13 07:18:19");
INSERT INTO activity_log VALUES("15","default","updated","App\\Models\\Project","updated","7","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-13T07:29:22.000000Z\",\"current_procedure_id\":1},\"old\":{\"updated_at\":\"2025-05-13T07:17:24.000000Z\",\"current_procedure_id\":null}}","","2025-05-13 07:29:22","2025-05-13 07:29:22");
INSERT INTO activity_log VALUES("16","default","updated","App\\Models\\Project","updated","7","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-13T07:50:58.000000Z\",\"current_procedure_id\":15},\"old\":{\"updated_at\":\"2025-05-13T07:29:22.000000Z\",\"current_procedure_id\":1}}","","2025-05-13 07:50:58","2025-05-13 07:50:58");
INSERT INTO activity_log VALUES("17","default","updated","App\\Models\\Project","updated","2","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-13T08:17:42.000000Z\",\"current_procedure_id\":5},\"old\":{\"updated_at\":\"2025-05-12T08:25:47.000000Z\",\"current_procedure_id\":2}}","","2025-05-13 08:17:42","2025-05-13 08:17:42");
INSERT INTO activity_log VALUES("18","default","deleted","App\\Models\\Project","deleted","8","App\\Models\\User","2","{\"old\":{\"id\":8,\"name\":\"\\u0645\\u0634\\u0631\\u0648\\u0639\\u064a\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"2025-05-01\",\"end_date\":\"2025-08-09\",\"period\":100,\"manager_id\":2,\"deleted_at\":\"2025-05-13T09:11:34.000000Z\",\"created_at\":\"2025-05-13T07:17:59.000000Z\",\"updated_at\":\"2025-05-13T09:11:34.000000Z\",\"supervisor_id\":1,\"consultant_id\":8,\"cost\":2147483647,\"customer\":\"\\u0627\\u0644\\u0639\\u0645\\u064a\\u0644\",\"email\":\"xyz@gamil.com\",\"number1\":\"29\",\"number2\":\"12\",\"number3\":\"50\",\"current_procedure_id\":null,\"status\":1}}","","2025-05-13 09:11:34","2025-05-13 09:11:34");
INSERT INTO activity_log VALUES("19","default","updated","App\\Models\\Project","updated","8","App\\Models\\User","2","{\"attributes\":{\"deleted_at\":null,\"updated_at\":\"2025-05-13T09:15:19.000000Z\"},\"old\":{\"deleted_at\":\"2025-05-13T09:11:34.000000Z\",\"updated_at\":\"2025-05-13T09:11:34.000000Z\"}}","","2025-05-13 09:15:19","2025-05-13 09:15:19");
INSERT INTO activity_log VALUES("20","default","restored","App\\Models\\Project","restored","8","App\\Models\\User","2","{\"attributes\":{\"id\":8,\"name\":\"\\u0645\\u0634\\u0631\\u0648\\u0639\\u064a\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"2025-05-01\",\"end_date\":\"2025-08-09\",\"period\":100,\"manager_id\":2,\"deleted_at\":null,\"created_at\":\"2025-05-13T07:17:59.000000Z\",\"updated_at\":\"2025-05-13T09:15:19.000000Z\",\"supervisor_id\":1,\"consultant_id\":8,\"cost\":2147483647,\"customer\":\"\\u0627\\u0644\\u0639\\u0645\\u064a\\u0644\",\"email\":\"xyz@gamil.com\",\"number1\":\"29\",\"number2\":\"12\",\"number3\":\"50\",\"current_procedure_id\":null,\"status\":1}}","","2025-05-13 09:15:19","2025-05-13 09:15:19");
INSERT INTO activity_log VALUES("21","default","updated","App\\Models\\Project","updated","8","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-13T09:15:55.000000Z\",\"supervisor_id\":11,\"status\":3},\"old\":{\"updated_at\":\"2025-05-13T09:15:19.000000Z\",\"supervisor_id\":1,\"status\":1}}","","2025-05-13 09:15:55","2025-05-13 09:15:55");
INSERT INTO activity_log VALUES("22","default","updated","App\\Models\\Project","updated","8","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-13T09:16:12.000000Z\"},\"old\":{\"updated_at\":\"2025-05-13T09:15:55.000000Z\"}}","","2025-05-13 09:16:12","2025-05-13 09:16:12");
INSERT INTO activity_log VALUES("23","default","updated","App\\Models\\Project","updated","8","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-13T09:16:22.000000Z\",\"status\":2},\"old\":{\"updated_at\":\"2025-05-13T09:16:12.000000Z\",\"status\":3}}","","2025-05-13 09:16:22","2025-05-13 09:16:22");
INSERT INTO activity_log VALUES("24","default","updated","App\\Models\\Project","updated","7","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-13T09:23:39.000000Z\",\"current_procedure_id\":2},\"old\":{\"updated_at\":\"2025-05-13T07:50:58.000000Z\",\"current_procedure_id\":15}}","","2025-05-13 09:23:39","2025-05-13 09:23:39");
INSERT INTO activity_log VALUES("25","default","updated","App\\Models\\Project","updated","8","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-13T10:05:06.000000Z\",\"current_procedure_id\":2},\"old\":{\"updated_at\":\"2025-05-13T09:16:22.000000Z\",\"current_procedure_id\":null}}","","2025-05-13 10:05:06","2025-05-13 10:05:06");
INSERT INTO activity_log VALUES("26","default","updated","App\\Models\\Project","updated","8","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-13T10:17:44.000000Z\",\"status\":4},\"old\":{\"updated_at\":\"2025-05-13T10:05:06.000000Z\",\"status\":2}}","","2025-05-13 10:17:44","2025-05-13 10:17:44");
INSERT INTO activity_log VALUES("27","default","updated","App\\Models\\Project","updated","8","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-13T10:17:56.000000Z\"},\"old\":{\"updated_at\":\"2025-05-13T10:17:44.000000Z\"}}","","2025-05-13 10:17:56","2025-05-13 10:17:56");
INSERT INTO activity_log VALUES("28","default","deleted","App\\Models\\Project","deleted","8","App\\Models\\User","2","{\"old\":{\"id\":8,\"name\":\"\\u0645\\u0634\\u0631\\u0648\\u0639\\u064a\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"2025-05-01\",\"end_date\":\"2025-08-09\",\"period\":100,\"manager_id\":2,\"deleted_at\":\"2025-05-13T10:32:30.000000Z\",\"created_at\":\"2025-05-13T07:17:59.000000Z\",\"updated_at\":\"2025-05-13T10:32:30.000000Z\",\"supervisor_id\":11,\"consultant_id\":8,\"cost\":2147483647,\"customer\":\"\\u0627\\u0644\\u0639\\u0645\\u064a\\u0644\",\"email\":\"xyz@gamil.com\",\"number1\":\"29\",\"number2\":\"12\",\"number3\":\"50\",\"current_procedure_id\":2,\"status\":4}}","","2025-05-13 10:32:30","2025-05-13 10:32:30");
INSERT INTO activity_log VALUES("29","default","updated","App\\Models\\Project","updated","8","App\\Models\\User","2","{\"attributes\":{\"deleted_at\":null,\"updated_at\":\"2025-05-13T10:32:38.000000Z\"},\"old\":{\"deleted_at\":\"2025-05-13T10:32:30.000000Z\",\"updated_at\":\"2025-05-13T10:32:30.000000Z\"}}","","2025-05-13 10:32:38","2025-05-13 10:32:38");
INSERT INTO activity_log VALUES("30","default","restored","App\\Models\\Project","restored","8","App\\Models\\User","2","{\"attributes\":{\"id\":8,\"name\":\"\\u0645\\u0634\\u0631\\u0648\\u0639\\u064a\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"2025-05-01\",\"end_date\":\"2025-08-09\",\"period\":100,\"manager_id\":2,\"deleted_at\":null,\"created_at\":\"2025-05-13T07:17:59.000000Z\",\"updated_at\":\"2025-05-13T10:32:38.000000Z\",\"supervisor_id\":11,\"consultant_id\":8,\"cost\":2147483647,\"customer\":\"\\u0627\\u0644\\u0639\\u0645\\u064a\\u0644\",\"email\":\"xyz@gamil.com\",\"number1\":\"29\",\"number2\":\"12\",\"number3\":\"50\",\"current_procedure_id\":2,\"status\":4}}","","2025-05-13 10:32:38","2025-05-13 10:32:38");
INSERT INTO activity_log VALUES("31","default","deleted","App\\Models\\Project","deleted","8","App\\Models\\User","2","{\"old\":{\"id\":8,\"name\":\"\\u0645\\u0634\\u0631\\u0648\\u0639\\u064a\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"2025-05-01\",\"end_date\":\"2025-08-09\",\"period\":100,\"manager_id\":2,\"deleted_at\":\"2025-05-13T10:32:42.000000Z\",\"created_at\":\"2025-05-13T07:17:59.000000Z\",\"updated_at\":\"2025-05-13T10:32:42.000000Z\",\"supervisor_id\":11,\"consultant_id\":8,\"cost\":2147483647,\"customer\":\"\\u0627\\u0644\\u0639\\u0645\\u064a\\u0644\",\"email\":\"xyz@gamil.com\",\"number1\":\"29\",\"number2\":\"12\",\"number3\":\"50\",\"current_procedure_id\":2,\"status\":4}}","","2025-05-13 10:32:42","2025-05-13 10:32:42");
INSERT INTO activity_log VALUES("32","default","updated","App\\Models\\Project","updated","7","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-13T10:33:17.000000Z\",\"status\":2},\"old\":{\"updated_at\":\"2025-05-13T09:23:39.000000Z\",\"status\":1}}","","2025-05-13 10:33:17","2025-05-13 10:33:17");
INSERT INTO activity_log VALUES("33","default","updated","App\\Models\\Project","updated","8","App\\Models\\User","2","{\"attributes\":{\"deleted_at\":null,\"updated_at\":\"2025-05-13T10:33:23.000000Z\"},\"old\":{\"deleted_at\":\"2025-05-13T10:32:42.000000Z\",\"updated_at\":\"2025-05-13T10:32:42.000000Z\"}}","","2025-05-13 10:33:23","2025-05-13 10:33:23");
INSERT INTO activity_log VALUES("34","default","restored","App\\Models\\Project","restored","8","App\\Models\\User","2","{\"attributes\":{\"id\":8,\"name\":\"\\u0645\\u0634\\u0631\\u0648\\u0639\\u064a\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"2025-05-01\",\"end_date\":\"2025-08-09\",\"period\":100,\"manager_id\":2,\"deleted_at\":null,\"created_at\":\"2025-05-13T07:17:59.000000Z\",\"updated_at\":\"2025-05-13T10:33:23.000000Z\",\"supervisor_id\":11,\"consultant_id\":8,\"cost\":2147483647,\"customer\":\"\\u0627\\u0644\\u0639\\u0645\\u064a\\u0644\",\"email\":\"xyz@gamil.com\",\"number1\":\"29\",\"number2\":\"12\",\"number3\":\"50\",\"current_procedure_id\":2,\"status\":4}}","","2025-05-13 10:33:23","2025-05-13 10:33:23");
INSERT INTO activity_log VALUES("35","default","updated","App\\Models\\Project","updated","8","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-13T10:33:44.000000Z\",\"status\":3},\"old\":{\"updated_at\":\"2025-05-13T10:33:23.000000Z\",\"status\":4}}","","2025-05-13 10:33:44","2025-05-13 10:33:44");
INSERT INTO activity_log VALUES("36","default","updated","App\\Models\\Project","updated","8","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-13T10:33:58.000000Z\",\"status\":2},\"old\":{\"updated_at\":\"2025-05-13T10:33:44.000000Z\",\"status\":3}}","","2025-05-13 10:33:58","2025-05-13 10:33:58");
INSERT INTO activity_log VALUES("37","default","updated","App\\Models\\Project","updated","8","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-13T10:34:20.000000Z\",\"status\":3},\"old\":{\"updated_at\":\"2025-05-13T10:33:58.000000Z\",\"status\":2}}","","2025-05-13 10:34:20","2025-05-13 10:34:20");
INSERT INTO activity_log VALUES("38","default","updated","App\\Models\\Project","updated","8","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-13T10:34:28.000000Z\",\"status\":4},\"old\":{\"updated_at\":\"2025-05-13T10:34:20.000000Z\",\"status\":3}}","","2025-05-13 10:34:28","2025-05-13 10:34:28");
INSERT INTO activity_log VALUES("39","default","updated","App\\Models\\Project","updated","8","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-13T10:34:42.000000Z\",\"status\":2},\"old\":{\"updated_at\":\"2025-05-13T10:34:28.000000Z\",\"status\":4}}","","2025-05-13 10:34:42","2025-05-13 10:34:42");
INSERT INTO activity_log VALUES("40","default","updated","App\\Models\\Project","updated","8","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-13T10:34:51.000000Z\",\"status\":1},\"old\":{\"updated_at\":\"2025-05-13T10:34:42.000000Z\",\"status\":2}}","","2025-05-13 10:34:51","2025-05-13 10:34:51");
INSERT INTO activity_log VALUES("41","default","updated","App\\Models\\Project","updated","8","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-13T10:35:04.000000Z\",\"status\":2},\"old\":{\"updated_at\":\"2025-05-13T10:34:51.000000Z\",\"status\":1}}","","2025-05-13 10:35:04","2025-05-13 10:35:04");
INSERT INTO activity_log VALUES("42","default","updated","App\\Models\\Project","updated","8","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-13T11:12:40.000000Z\"},\"old\":{\"updated_at\":\"2025-05-13T10:35:04.000000Z\"}}","","2025-05-13 11:12:40","2025-05-13 11:12:40");
INSERT INTO activity_log VALUES("43","default","deleted","App\\Models\\Project","deleted","8","App\\Models\\User","2","{\"old\":{\"id\":8,\"name\":\"\\u0645\\u0634\\u0631\\u0648\\u0639\\u064a\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"2025-05-01\",\"end_date\":\"2025-08-09\",\"period\":100,\"manager_id\":2,\"deleted_at\":\"2025-05-13T11:12:56.000000Z\",\"created_at\":\"2025-05-13T07:17:59.000000Z\",\"updated_at\":\"2025-05-13T11:12:56.000000Z\",\"supervisor_id\":11,\"consultant_id\":8,\"cost\":2147483647,\"customer\":\"\\u0627\\u0644\\u0639\\u0645\\u064a\\u0644\",\"email\":\"xyz@gamil.com\",\"number1\":\"29\",\"number2\":\"12\",\"number3\":\"50\",\"current_procedure_id\":2,\"status\":2}}","","2025-05-13 11:12:56","2025-05-13 11:12:56");
INSERT INTO activity_log VALUES("44","default","updated","App\\Models\\Project","updated","8","App\\Models\\User","2","{\"attributes\":{\"deleted_at\":null,\"updated_at\":\"2025-05-13T11:23:30.000000Z\"},\"old\":{\"deleted_at\":\"2025-05-13T11:12:56.000000Z\",\"updated_at\":\"2025-05-13T11:12:56.000000Z\"}}","","2025-05-13 11:23:30","2025-05-13 11:23:30");
INSERT INTO activity_log VALUES("45","default","restored","App\\Models\\Project","restored","8","App\\Models\\User","2","{\"attributes\":{\"id\":8,\"name\":\"\\u0645\\u0634\\u0631\\u0648\\u0639\\u064a\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"2025-05-01\",\"end_date\":\"2025-08-09\",\"period\":100,\"manager_id\":2,\"deleted_at\":null,\"created_at\":\"2025-05-13T07:17:59.000000Z\",\"updated_at\":\"2025-05-13T11:23:30.000000Z\",\"supervisor_id\":11,\"consultant_id\":8,\"cost\":2147483647,\"customer\":\"\\u0627\\u0644\\u0639\\u0645\\u064a\\u0644\",\"email\":\"xyz@gamil.com\",\"number1\":\"29\",\"number2\":\"12\",\"number3\":\"50\",\"current_procedure_id\":2,\"status\":2}}","","2025-05-13 11:23:30","2025-05-13 11:23:30");
INSERT INTO activity_log VALUES("46","default","updated","App\\Models\\Project","updated","8","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-13T11:24:57.000000Z\",\"current_procedure_id\":1},\"old\":{\"updated_at\":\"2025-05-13T11:23:30.000000Z\",\"current_procedure_id\":2}}","","2025-05-13 11:24:57","2025-05-13 11:24:57");
INSERT INTO activity_log VALUES("47","default","updated","App\\Models\\Project","updated","8","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-14T09:54:05.000000Z\",\"status\":1},\"old\":{\"updated_at\":\"2025-05-13T11:24:57.000000Z\",\"status\":2}}","","2025-05-14 09:54:05","2025-05-14 09:54:05");
INSERT INTO activity_log VALUES("48","default","updated","App\\Models\\Project","updated","8","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-14T09:54:24.000000Z\",\"status\":3},\"old\":{\"updated_at\":\"2025-05-14T09:54:05.000000Z\",\"status\":1}}","","2025-05-14 09:54:24","2025-05-14 09:54:24");
INSERT INTO activity_log VALUES("49","default","created","App\\Models\\Project","created","9","App\\Models\\User","2","{\"attributes\":{\"id\":9,\"name\":\"\\u062a\\u0633\\u062a \\u0627\\u0645\\u0631 \\u0627\\u0644\\u0635\\u0631\\u0641\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"2024-10-09\",\"end_date\":\"2025-01-17\",\"period\":100,\"manager_id\":2,\"deleted_at\":null,\"created_at\":\"2025-05-14T13:44:09.000000Z\",\"updated_at\":\"2025-05-14T13:44:09.000000Z\",\"supervisor_id\":1,\"consultant_id\":8,\"cost\":123123123,\"customer\":\"123\",\"email\":\"s@s\",\"number1\":null,\"number2\":null,\"number3\":null,\"current_procedure_id\":null,\"status\":1}}","","2025-05-14 13:44:09","2025-05-14 13:44:09");
INSERT INTO activity_log VALUES("50","default","updated","App\\Models\\Project","updated","9","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-14T14:36:59.000000Z\",\"current_procedure_id\":2},\"old\":{\"updated_at\":\"2025-05-14T13:44:09.000000Z\",\"current_procedure_id\":null}}","","2025-05-14 14:36:59","2025-05-14 14:36:59");
INSERT INTO activity_log VALUES("51","default","updated","App\\Models\\Project","updated","1","App\\Models\\User","2","{\"attributes\":{\"end_date\":\"2024-08-12\",\"manager_id\":2,\"updated_at\":\"2025-05-15T09:24:47.000000Z\"},\"old\":{\"end_date\":null,\"manager_id\":13,\"updated_at\":\"2025-01-27T07:05:55.000000Z\"}}","","2025-05-15 09:24:47","2025-05-15 09:24:47");
INSERT INTO activity_log VALUES("52","default","updated","App\\Models\\Project","updated","1","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-15T09:25:05.000000Z\",\"supervisor_id\":11,\"consultant_id\":27},\"old\":{\"updated_at\":\"2025-05-15T09:24:47.000000Z\",\"supervisor_id\":1,\"consultant_id\":8}}","","2025-05-15 09:25:05","2025-05-15 09:25:05");
INSERT INTO activity_log VALUES("53","default","updated","App\\Models\\Project","updated","3","App\\Models\\User","2","{\"attributes\":{\"end_date\":\"2025-05-21\",\"manager_id\":2,\"updated_at\":\"2025-05-15T09:27:11.000000Z\"},\"old\":{\"end_date\":null,\"manager_id\":13,\"updated_at\":\"2025-01-16T10:58:03.000000Z\"}}","","2025-05-15 09:27:11","2025-05-15 09:27:11");
INSERT INTO activity_log VALUES("54","default","created","App\\Models\\Project","created","10","App\\Models\\User","2","{\"attributes\":{\"id\":10,\"name\":\"q\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"0023-12-31\",\"end_date\":\"0024-05-02\",\"period\":123,\"manager_id\":2,\"deleted_at\":null,\"created_at\":\"2025-05-15T09:27:54.000000Z\",\"updated_at\":\"2025-05-15T09:27:54.000000Z\",\"supervisor_id\":1,\"consultant_id\":8,\"cost\":123,\"customer\":\"123\",\"email\":\"1a@q\",\"number1\":\"1\",\"number2\":null,\"number3\":null,\"current_procedure_id\":null,\"status\":1}}","","2025-05-15 09:27:54","2025-05-15 09:27:54");
INSERT INTO activity_log VALUES("55","default","deleted","App\\Models\\Project","deleted","10","App\\Models\\User","2","{\"old\":{\"id\":10,\"name\":\"q\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"0023-12-31\",\"end_date\":\"0024-05-02\",\"period\":123,\"manager_id\":2,\"deleted_at\":\"2025-05-15T09:27:59.000000Z\",\"created_at\":\"2025-05-15T09:27:54.000000Z\",\"updated_at\":\"2025-05-15T09:27:59.000000Z\",\"supervisor_id\":1,\"consultant_id\":8,\"cost\":123,\"customer\":\"123\",\"email\":\"1a@q\",\"number1\":\"1\",\"number2\":null,\"number3\":null,\"current_procedure_id\":null,\"status\":1}}","","2025-05-15 09:27:59","2025-05-15 09:27:59");
INSERT INTO activity_log VALUES("56","default","updated","App\\Models\\Project","updated","10","App\\Models\\User","2","{\"attributes\":{\"deleted_at\":null,\"updated_at\":\"2025-05-15T09:28:03.000000Z\"},\"old\":{\"deleted_at\":\"2025-05-15T09:27:59.000000Z\",\"updated_at\":\"2025-05-15T09:27:59.000000Z\"}}","","2025-05-15 09:28:03","2025-05-15 09:28:03");
INSERT INTO activity_log VALUES("57","default","restored","App\\Models\\Project","restored","10","App\\Models\\User","2","{\"attributes\":{\"id\":10,\"name\":\"q\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"0023-12-31\",\"end_date\":\"0024-05-02\",\"period\":123,\"manager_id\":2,\"deleted_at\":null,\"created_at\":\"2025-05-15T09:27:54.000000Z\",\"updated_at\":\"2025-05-15T09:28:03.000000Z\",\"supervisor_id\":1,\"consultant_id\":8,\"cost\":123,\"customer\":\"123\",\"email\":\"1a@q\",\"number1\":\"1\",\"number2\":null,\"number3\":null,\"current_procedure_id\":null,\"status\":1}}","","2025-05-15 09:28:04","2025-05-15 09:28:04");
INSERT INTO activity_log VALUES("58","default","deleted","App\\Models\\Project","deleted","10","App\\Models\\User","2","{\"old\":{\"id\":10,\"name\":\"q\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"0023-12-31\",\"end_date\":\"0024-05-02\",\"period\":123,\"manager_id\":2,\"deleted_at\":\"2025-05-15T09:28:22.000000Z\",\"created_at\":\"2025-05-15T09:27:54.000000Z\",\"updated_at\":\"2025-05-15T09:28:22.000000Z\",\"supervisor_id\":1,\"consultant_id\":8,\"cost\":123,\"customer\":\"123\",\"email\":\"1a@q\",\"number1\":\"1\",\"number2\":null,\"number3\":null,\"current_procedure_id\":null,\"status\":1}}","","2025-05-15 09:28:22","2025-05-15 09:28:22");
INSERT INTO activity_log VALUES("59","default","created","App\\Models\\Project","created","11","App\\Models\\User","2","{\"attributes\":{\"id\":11,\"name\":\"advadd\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"2025-05-18\",\"end_date\":\"2025-08-26\",\"period\":100,\"manager_id\":2,\"deleted_at\":null,\"created_at\":\"2025-05-18T10:08:28.000000Z\",\"updated_at\":\"2025-05-18T10:08:28.000000Z\",\"supervisor_id\":1,\"consultant_id\":8,\"cost\":499999,\"customer\":\"lnli\",\"email\":\"bxfcttb@gmail.com\",\"number1\":\".22\",\"number2\":\"-1112\",\"number3\":\"426\",\"current_procedure_id\":null,\"status\":1}}","","2025-05-18 10:08:28","2025-05-18 10:08:28");
INSERT INTO activity_log VALUES("60","default","updated","App\\Models\\Project","updated","11","App\\Models\\User","2","{\"attributes\":{\"name\":\".\",\"updated_at\":\"2025-05-18T10:11:49.000000Z\"},\"old\":{\"name\":\"advadd\",\"updated_at\":\"2025-05-18T10:08:28.000000Z\"}}","","2025-05-18 10:11:49","2025-05-18 10:11:49");
INSERT INTO activity_log VALUES("61","default","updated","App\\Models\\Project","updated","10","App\\Models\\User","2","{\"attributes\":{\"deleted_at\":null,\"updated_at\":\"2025-05-19T11:03:48.000000Z\"},\"old\":{\"deleted_at\":\"2025-05-15T09:28:22.000000Z\",\"updated_at\":\"2025-05-15T09:28:22.000000Z\"}}","","2025-05-19 11:03:48","2025-05-19 11:03:48");
INSERT INTO activity_log VALUES("62","default","restored","App\\Models\\Project","restored","10","App\\Models\\User","2","{\"attributes\":{\"id\":10,\"name\":\"q\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"0023-12-31\",\"end_date\":\"0024-05-02\",\"period\":123,\"manager_id\":2,\"deleted_at\":null,\"created_at\":\"2025-05-15T09:27:54.000000Z\",\"updated_at\":\"2025-05-19T11:03:48.000000Z\",\"supervisor_id\":1,\"consultant_id\":8,\"cost\":123,\"customer\":\"123\",\"email\":\"1a@q\",\"number1\":\"1\",\"number2\":null,\"number3\":null,\"current_procedure_id\":null,\"status\":1}}","","2025-05-19 11:03:48","2025-05-19 11:03:48");
INSERT INTO activity_log VALUES("63","default","deleted","App\\Models\\Project","deleted","11","App\\Models\\User","2","{\"old\":{\"id\":11,\"name\":\".\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"2025-05-18\",\"end_date\":\"2025-08-26\",\"period\":100,\"manager_id\":2,\"deleted_at\":\"2025-05-19T11:04:09.000000Z\",\"created_at\":\"2025-05-18T10:08:28.000000Z\",\"updated_at\":\"2025-05-19T11:04:09.000000Z\",\"supervisor_id\":1,\"consultant_id\":8,\"cost\":499999,\"customer\":\"lnli\",\"email\":\"bxfcttb@gmail.com\",\"number1\":\".22\",\"number2\":\"-1112\",\"number3\":\"426\",\"current_procedure_id\":null,\"status\":1}}","","2025-05-19 11:04:09","2025-05-19 11:04:09");
INSERT INTO activity_log VALUES("64","default","created","App\\Models\\Project","created","12","App\\Models\\User","2","{\"attributes\":{\"id\":12,\"name\":\"test11\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"2025-05-20\",\"end_date\":\"0000-00-00\",\"period\":2147483647,\"manager_id\":2,\"deleted_at\":null,\"created_at\":\"2025-05-19T21:18:37.000000Z\",\"updated_at\":\"2025-05-19T21:18:37.000000Z\",\"supervisor_id\":1,\"consultant_id\":8,\"cost\":4000000,\"customer\":\"\\u0623\\u062d\\u0645\\u062f \\u0623\\u0645\\u064a\\u0646\",\"email\":\"mohabhegazy839@gmail.com\",\"number1\":\"01012345616\",\"number2\":\"-2\",\"number3\":null,\"current_procedure_id\":null,\"status\":1}}","","2025-05-19 21:18:37","2025-05-19 21:18:37");
INSERT INTO activity_log VALUES("65","default","updated","App\\Models\\Project","updated","12","App\\Models\\User","2","{\"attributes\":{\"end_date\":\"2025-05-19\",\"updated_at\":\"2025-05-19T21:21:18.000000Z\"},\"old\":{\"end_date\":\"0000-00-00\",\"updated_at\":\"2025-05-19T21:18:37.000000Z\"}}","","2025-05-19 21:21:18","2025-05-19 21:21:18");
INSERT INTO activity_log VALUES("66","default","deleted","App\\Models\\Project","deleted","12","App\\Models\\User","2","{\"old\":{\"id\":12,\"name\":\"test11\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"2025-05-20\",\"end_date\":\"2025-05-19\",\"period\":2147483647,\"manager_id\":2,\"deleted_at\":\"2025-05-19T21:21:49.000000Z\",\"created_at\":\"2025-05-19T21:18:37.000000Z\",\"updated_at\":\"2025-05-19T21:21:49.000000Z\",\"supervisor_id\":1,\"consultant_id\":8,\"cost\":4000000,\"customer\":\"\\u0623\\u062d\\u0645\\u062f \\u0623\\u0645\\u064a\\u0646\",\"email\":\"mohabhegazy839@gmail.com\",\"number1\":\"01012345616\",\"number2\":\"-2\",\"number3\":null,\"current_procedure_id\":null,\"status\":1}}","","2025-05-19 21:21:49","2025-05-19 21:21:49");
INSERT INTO activity_log VALUES("67","default","created","App\\Models\\Project","created","13","App\\Models\\User","2","{\"attributes\":{\"id\":13,\"name\":\"test 12\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"2025-05-20\",\"end_date\":\"2025-05-19\",\"period\":2147483647,\"manager_id\":2,\"deleted_at\":null,\"created_at\":\"2025-05-19T21:22:52.000000Z\",\"updated_at\":\"2025-05-19T21:22:52.000000Z\",\"supervisor_id\":1,\"consultant_id\":8,\"cost\":40000000,\"customer\":\"\\u0623\\u062d\\u0645\\u062f \\u0623\\u0645\\u064a\\u0646\",\"email\":\"mohabhegazy839@gmail.com\",\"number1\":\"01061588881\",\"number2\":null,\"number3\":null,\"current_procedure_id\":null,\"status\":1}}","","2025-05-19 21:22:52","2025-05-19 21:22:52");
INSERT INTO activity_log VALUES("68","default","updated","App\\Models\\Project","updated","12","App\\Models\\User","2","{\"attributes\":{\"deleted_at\":null,\"updated_at\":\"2025-05-19T21:41:30.000000Z\"},\"old\":{\"deleted_at\":\"2025-05-19T21:21:49.000000Z\",\"updated_at\":\"2025-05-19T21:21:49.000000Z\"}}","","2025-05-19 21:41:30","2025-05-19 21:41:30");
INSERT INTO activity_log VALUES("69","default","restored","App\\Models\\Project","restored","12","App\\Models\\User","2","{\"attributes\":{\"id\":12,\"name\":\"test11\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"2025-05-20\",\"end_date\":\"2025-05-19\",\"period\":2147483647,\"manager_id\":2,\"deleted_at\":null,\"created_at\":\"2025-05-19T21:18:37.000000Z\",\"updated_at\":\"2025-05-19T21:41:30.000000Z\",\"supervisor_id\":1,\"consultant_id\":8,\"cost\":4000000,\"customer\":\"\\u0623\\u062d\\u0645\\u062f \\u0623\\u0645\\u064a\\u0646\",\"email\":\"mohabhegazy839@gmail.com\",\"number1\":\"01012345616\",\"number2\":\"-2\",\"number3\":null,\"current_procedure_id\":null,\"status\":1}}","","2025-05-19 21:41:30","2025-05-19 21:41:30");
INSERT INTO activity_log VALUES("70","default","deleted","App\\Models\\Project","deleted","12","App\\Models\\User","2","{\"old\":{\"id\":12,\"name\":\"test11\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"2025-05-20\",\"end_date\":\"2025-05-19\",\"period\":2147483647,\"manager_id\":2,\"deleted_at\":\"2025-05-19T21:41:34.000000Z\",\"created_at\":\"2025-05-19T21:18:37.000000Z\",\"updated_at\":\"2025-05-19T21:41:34.000000Z\",\"supervisor_id\":1,\"consultant_id\":8,\"cost\":4000000,\"customer\":\"\\u0623\\u062d\\u0645\\u062f \\u0623\\u0645\\u064a\\u0646\",\"email\":\"mohabhegazy839@gmail.com\",\"number1\":\"01012345616\",\"number2\":\"-2\",\"number3\":null,\"current_procedure_id\":null,\"status\":1}}","","2025-05-19 21:41:34","2025-05-19 21:41:34");
INSERT INTO activity_log VALUES("71","default","updated","App\\Models\\Project","updated","12","App\\Models\\User","2","{\"attributes\":{\"deleted_at\":null,\"updated_at\":\"2025-05-19T21:41:45.000000Z\"},\"old\":{\"deleted_at\":\"2025-05-19T21:41:34.000000Z\",\"updated_at\":\"2025-05-19T21:41:34.000000Z\"}}","","2025-05-19 21:41:45","2025-05-19 21:41:45");
INSERT INTO activity_log VALUES("72","default","restored","App\\Models\\Project","restored","12","App\\Models\\User","2","{\"attributes\":{\"id\":12,\"name\":\"test11\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"2025-05-20\",\"end_date\":\"2025-05-19\",\"period\":2147483647,\"manager_id\":2,\"deleted_at\":null,\"created_at\":\"2025-05-19T21:18:37.000000Z\",\"updated_at\":\"2025-05-19T21:41:45.000000Z\",\"supervisor_id\":1,\"consultant_id\":8,\"cost\":4000000,\"customer\":\"\\u0623\\u062d\\u0645\\u062f \\u0623\\u0645\\u064a\\u0646\",\"email\":\"mohabhegazy839@gmail.com\",\"number1\":\"01012345616\",\"number2\":\"-2\",\"number3\":null,\"current_procedure_id\":null,\"status\":1}}","","2025-05-19 21:41:45","2025-05-19 21:41:45");
INSERT INTO activity_log VALUES("73","default","deleted","App\\Models\\Project","deleted","12","App\\Models\\User","2","{\"old\":{\"id\":12,\"name\":\"test11\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"2025-05-20\",\"end_date\":\"2025-05-19\",\"period\":2147483647,\"manager_id\":2,\"deleted_at\":\"2025-05-19T21:41:57.000000Z\",\"created_at\":\"2025-05-19T21:18:37.000000Z\",\"updated_at\":\"2025-05-19T21:41:57.000000Z\",\"supervisor_id\":1,\"consultant_id\":8,\"cost\":4000000,\"customer\":\"\\u0623\\u062d\\u0645\\u062f \\u0623\\u0645\\u064a\\u0646\",\"email\":\"mohabhegazy839@gmail.com\",\"number1\":\"01012345616\",\"number2\":\"-2\",\"number3\":null,\"current_procedure_id\":null,\"status\":1}}","","2025-05-19 21:41:57","2025-05-19 21:41:57");
INSERT INTO activity_log VALUES("74","default","updated","App\\Models\\Project","updated","13","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-19T21:47:03.000000Z\",\"current_procedure_id\":4},\"old\":{\"updated_at\":\"2025-05-19T21:22:52.000000Z\",\"current_procedure_id\":null}}","","2025-05-19 21:47:03","2025-05-19 21:47:03");
INSERT INTO activity_log VALUES("75","default","updated","App\\Models\\Project","updated","1","App\\Models\\User","2","{\"attributes\":{\"name\":\"\\u0641\\u064a\\u0644\\u0627 \\u0627\\u0644\\u0639\\u062b\\u064a\",\"updated_at\":\"2025-05-20T06:20:45.000000Z\"},\"old\":{\"name\":\"\\u0641\\u064a\\u0644\\u0627 \\u0627\\u0644\\u0639\\u062b\\u064a\\u0645\",\"updated_at\":\"2025-05-15T09:25:05.000000Z\"}}","","2025-05-20 06:20:45","2025-05-20 06:20:45");
INSERT INTO activity_log VALUES("76","default","updated","App\\Models\\Project","updated","1","App\\Models\\User","2","{\"attributes\":{\"name\":\"\\u0641\\u064a\\u0644\\u0627 \\u0627\\u0644\\u0639\\u062b\\u064a\\u0645\",\"updated_at\":\"2025-05-20T06:20:54.000000Z\"},\"old\":{\"name\":\"\\u0641\\u064a\\u0644\\u0627 \\u0627\\u0644\\u0639\\u062b\\u064a\",\"updated_at\":\"2025-05-20T06:20:45.000000Z\"}}","","2025-05-20 06:20:54","2025-05-20 06:20:54");
INSERT INTO activity_log VALUES("77","default","created","App\\Models\\Project","created","14","App\\Models\\User","2","{\"attributes\":{\"id\":14,\"name\":\"\\u0628\\u0647\\u0627\\u0621 \\u0633\\u0644\\u0637\\u0627\\u0646\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"2024-12-12\",\"end_date\":\"2026-04-26\",\"period\":500,\"manager_id\":2,\"deleted_at\":null,\"created_at\":\"2025-05-20T06:22:33.000000Z\",\"updated_at\":\"2025-05-20T06:22:33.000000Z\",\"supervisor_id\":1,\"consultant_id\":8,\"cost\":1000000,\"customer\":\"\\u064a\\u0627\\u0633\\u0631 \\u0627\\u0644\\u062f\\u0648\\u0633\\u0631\\u064a\",\"email\":\"mohamedhashem2001111@gmail.com\",\"number1\":\"2\",\"number2\":\"2\",\"number3\":\"2\",\"current_procedure_id\":null,\"status\":1}}","","2025-05-20 06:22:33","2025-05-20 06:22:33");
INSERT INTO activity_log VALUES("78","default","created","App\\Models\\Project","created","15","App\\Models\\User","2","{\"attributes\":{\"id\":15,\"name\":\"\\u0645\\u062d\\u0645\\u062f \\u0627\\u0628\\u0648\\u062a\\u0631\\u064a\\u0643\\u0629\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"2024-11-11\",\"end_date\":\"2025-11-11\",\"period\":365,\"manager_id\":2,\"deleted_at\":null,\"created_at\":\"2025-05-20T06:23:34.000000Z\",\"updated_at\":\"2025-05-20T06:23:34.000000Z\",\"supervisor_id\":1,\"consultant_id\":8,\"cost\":10000000,\"customer\":\"\\u0627\\u0644\\u0627\\u0647\\u0644\\u064a\",\"email\":\"mohamedhashem2001111@gmail.com\",\"number1\":\"22\",\"number2\":\"22\",\"number3\":\"22\",\"current_procedure_id\":null,\"status\":1}}","","2025-05-20 06:23:34","2025-05-20 06:23:34");
INSERT INTO activity_log VALUES("79","default","created","App\\Models\\Project","created","16","App\\Models\\User","2","{\"attributes\":{\"id\":16,\"name\":\"frimpong\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"2024-11-11\",\"end_date\":\"2025-02-19\",\"period\":100,\"manager_id\":2,\"deleted_at\":null,\"created_at\":\"2025-05-20T06:25:29.000000Z\",\"updated_at\":\"2025-05-20T06:25:29.000000Z\",\"supervisor_id\":1,\"consultant_id\":8,\"cost\":350000,\"customer\":\"liverpool\",\"email\":\"mohamedhashem2001111@gmail.com\",\"number1\":\"2\",\"number2\":\"2\",\"number3\":\"2\",\"current_procedure_id\":null,\"status\":1}}","","2025-05-20 06:25:29","2025-05-20 06:25:29");
INSERT INTO activity_log VALUES("80","default","created","App\\Models\\Project","created","17","App\\Models\\User","2","{\"attributes\":{\"id\":17,\"name\":\"kerkez\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"-0001-11-30\",\"end_date\":\"2025-05-20\",\"period\":0,\"manager_id\":2,\"deleted_at\":null,\"created_at\":\"2025-05-20T06:31:31.000000Z\",\"updated_at\":\"2025-05-20T06:31:31.000000Z\",\"supervisor_id\":1,\"consultant_id\":8,\"cost\":0,\"customer\":\"liverpool\",\"email\":\"mohamedhashem2001111@gmail.com\",\"number1\":\"1\",\"number2\":\"2\",\"number3\":\"3\",\"current_procedure_id\":null,\"status\":1}}","","2025-05-20 06:31:31","2025-05-20 06:31:31");
INSERT INTO activity_log VALUES("81","default","deleted","App\\Models\\Project","deleted","17","App\\Models\\User","2","{\"old\":{\"id\":17,\"name\":\"kerkez\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"-0001-11-30\",\"end_date\":\"2025-05-20\",\"period\":0,\"manager_id\":2,\"deleted_at\":\"2025-05-20T06:36:46.000000Z\",\"created_at\":\"2025-05-20T06:31:31.000000Z\",\"updated_at\":\"2025-05-20T06:36:46.000000Z\",\"supervisor_id\":1,\"consultant_id\":8,\"cost\":0,\"customer\":\"liverpool\",\"email\":\"mohamedhashem2001111@gmail.com\",\"number1\":\"1\",\"number2\":\"2\",\"number3\":\"3\",\"current_procedure_id\":null,\"status\":1}}","","2025-05-20 06:36:46","2025-05-20 06:36:46");
INSERT INTO activity_log VALUES("82","default","updated","App\\Models\\Project","updated","17","App\\Models\\User","2","{\"attributes\":{\"deleted_at\":null,\"updated_at\":\"2025-05-20T06:36:57.000000Z\"},\"old\":{\"deleted_at\":\"2025-05-20T06:36:46.000000Z\",\"updated_at\":\"2025-05-20T06:36:46.000000Z\"}}","","2025-05-20 06:36:57","2025-05-20 06:36:57");
INSERT INTO activity_log VALUES("83","default","restored","App\\Models\\Project","restored","17","App\\Models\\User","2","{\"attributes\":{\"id\":17,\"name\":\"kerkez\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"-0001-11-30\",\"end_date\":\"2025-05-20\",\"period\":0,\"manager_id\":2,\"deleted_at\":null,\"created_at\":\"2025-05-20T06:31:31.000000Z\",\"updated_at\":\"2025-05-20T06:36:57.000000Z\",\"supervisor_id\":1,\"consultant_id\":8,\"cost\":0,\"customer\":\"liverpool\",\"email\":\"mohamedhashem2001111@gmail.com\",\"number1\":\"1\",\"number2\":\"2\",\"number3\":\"3\",\"current_procedure_id\":null,\"status\":1}}","","2025-05-20 06:36:57","2025-05-20 06:36:57");
INSERT INTO activity_log VALUES("84","default","updated","App\\Models\\Project","updated","17","App\\Models\\User","2","{\"attributes\":{\"start_date\":\"2005-11-11\",\"end_date\":\"2005-11-11\",\"updated_at\":\"2025-05-20T06:37:19.000000Z\",\"cost\":3000000},\"old\":{\"start_date\":\"-0001-11-30\",\"end_date\":\"2025-05-20\",\"updated_at\":\"2025-05-20T06:36:57.000000Z\",\"cost\":0}}","","2025-05-20 06:37:19","2025-05-20 06:37:19");
INSERT INTO activity_log VALUES("85","default","deleted","App\\Models\\Project","deleted","17","App\\Models\\User","2","{\"old\":{\"id\":17,\"name\":\"kerkez\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"2005-11-11\",\"end_date\":\"2005-11-11\",\"period\":0,\"manager_id\":2,\"deleted_at\":\"2025-05-20T06:37:39.000000Z\",\"created_at\":\"2025-05-20T06:31:31.000000Z\",\"updated_at\":\"2025-05-20T06:37:39.000000Z\",\"supervisor_id\":1,\"consultant_id\":8,\"cost\":3000000,\"customer\":\"liverpool\",\"email\":\"mohamedhashem2001111@gmail.com\",\"number1\":\"1\",\"number2\":\"2\",\"number3\":\"3\",\"current_procedure_id\":null,\"status\":1}}","","2025-05-20 06:37:39","2025-05-20 06:37:39");
INSERT INTO activity_log VALUES("86","default","updated","App\\Models\\Project","updated","17","App\\Models\\User","2","{\"attributes\":{\"end_date\":\"2006-12-16\",\"period\":400,\"deleted_at\":null,\"updated_at\":\"2025-05-20T06:38:14.000000Z\",\"cost\":0},\"old\":{\"end_date\":\"2005-11-11\",\"period\":0,\"deleted_at\":\"2025-05-20T06:37:39.000000Z\",\"updated_at\":\"2025-05-20T06:37:39.000000Z\",\"cost\":3000000}}","","2025-05-20 06:38:14","2025-05-20 06:38:14");
INSERT INTO activity_log VALUES("87","default","updated","App\\Models\\Project","updated","17","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-20T06:38:33.000000Z\",\"cost\":300000},\"old\":{\"updated_at\":\"2025-05-20T06:38:14.000000Z\",\"cost\":0}}","","2025-05-20 06:38:33","2025-05-20 06:38:33");
INSERT INTO activity_log VALUES("88","default","updated","App\\Models\\Project","updated","17","App\\Models\\User","2","{\"attributes\":{\"end_date\":\"2005-11-11\",\"period\":0,\"updated_at\":\"2025-05-20T06:46:16.000000Z\"},\"old\":{\"end_date\":\"2006-12-16\",\"period\":400,\"updated_at\":\"2025-05-20T06:38:33.000000Z\"}}","","2025-05-20 06:46:16","2025-05-20 06:46:16");
INSERT INTO activity_log VALUES("89","default","updated","App\\Models\\Project","updated","17","App\\Models\\User","2","{\"attributes\":{\"end_date\":\"2006-12-16\",\"period\":400,\"updated_at\":\"2025-05-20T06:50:41.000000Z\"},\"old\":{\"end_date\":\"2005-11-11\",\"period\":0,\"updated_at\":\"2025-05-20T06:46:16.000000Z\"}}","","2025-05-20 06:50:41","2025-05-20 06:50:41");
INSERT INTO activity_log VALUES("90","default","created","App\\Models\\Project","created","18","App\\Models\\User","2","{\"attributes\":{\"id\":18,\"name\":\"konate\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"2024-11-11\",\"end_date\":\"2024-11-11\",\"period\":0,\"manager_id\":2,\"deleted_at\":null,\"created_at\":\"2025-05-20T06:53:26.000000Z\",\"updated_at\":\"2025-05-20T06:53:26.000000Z\",\"supervisor_id\":1,\"consultant_id\":8,\"cost\":400000,\"customer\":\"liverpool\",\"email\":\"mohamedhashem2001111@gmail.com\",\"number1\":\"5\",\"number2\":\"5\",\"number3\":\"5\",\"current_procedure_id\":null,\"status\":1}}","","2025-05-20 06:53:26","2025-05-20 06:53:26");
INSERT INTO activity_log VALUES("91","default","updated","App\\Models\\Project","updated","18","App\\Models\\User","2","{\"attributes\":{\"end_date\":\"2025-09-07\",\"period\":300,\"updated_at\":\"2025-05-20T06:53:57.000000Z\"},\"old\":{\"end_date\":\"2024-11-11\",\"period\":0,\"updated_at\":\"2025-05-20T06:53:26.000000Z\"}}","","2025-05-20 06:53:57","2025-05-20 06:53:57");
INSERT INTO activity_log VALUES("92","default","updated","App\\Models\\Project","updated","18","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-20T06:54:16.000000Z\",\"cost\":0},\"old\":{\"updated_at\":\"2025-05-20T06:53:57.000000Z\",\"cost\":400000}}","","2025-05-20 06:54:16","2025-05-20 06:54:16");
INSERT INTO activity_log VALUES("93","default","updated","App\\Models\\Project","updated","18","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-20T06:54:32.000000Z\",\"cost\":400000},\"old\":{\"updated_at\":\"2025-05-20T06:54:16.000000Z\",\"cost\":0}}","","2025-05-20 06:54:32","2025-05-20 06:54:32");
INSERT INTO activity_log VALUES("94","default","updated","App\\Models\\Project","updated","18","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-20T06:56:40.000000Z\",\"number1\":\"0\",\"number2\":\"0\",\"number3\":\"0\"},\"old\":{\"updated_at\":\"2025-05-20T06:54:32.000000Z\",\"number1\":\"5\",\"number2\":\"5\",\"number3\":\"5\"}}","","2025-05-20 06:56:40","2025-05-20 06:56:40");
INSERT INTO activity_log VALUES("95","default","updated","App\\Models\\Project","updated","18","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-20T06:57:02.000000Z\",\"customer\":\"0\"},\"old\":{\"updated_at\":\"2025-05-20T06:56:40.000000Z\",\"customer\":\"liverpool\"}}","","2025-05-20 06:57:02","2025-05-20 06:57:02");
INSERT INTO activity_log VALUES("96","default","updated","App\\Models\\Project","updated","18","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-20T06:57:14.000000Z\",\"customer\":\"l\"},\"old\":{\"updated_at\":\"2025-05-20T06:57:02.000000Z\",\"customer\":\"0\"}}","","2025-05-20 06:57:14","2025-05-20 06:57:14");
INSERT INTO activity_log VALUES("97","default","updated","App\\Models\\Project","updated","18","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-20T06:57:33.000000Z\",\"customer\":\"liverpool\"},\"old\":{\"updated_at\":\"2025-05-20T06:57:14.000000Z\",\"customer\":\"l\"}}","","2025-05-20 06:57:33","2025-05-20 06:57:33");
INSERT INTO activity_log VALUES("98","default","updated","App\\Models\\Project","updated","13","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-20T07:33:03.000000Z\",\"current_procedure_id\":2},\"old\":{\"updated_at\":\"2025-05-19T21:47:03.000000Z\",\"current_procedure_id\":4}}","","2025-05-20 07:33:03","2025-05-20 07:33:03");
INSERT INTO activity_log VALUES("99","default","updated","App\\Models\\Project","updated","18","App\\Models\\User","2","{\"attributes\":{\"end_date\":\"2024-11-11\",\"period\":0,\"updated_at\":\"2025-05-20T08:07:02.000000Z\"},\"old\":{\"end_date\":\"2025-09-07\",\"period\":300,\"updated_at\":\"2025-05-20T06:57:33.000000Z\"}}","","2025-05-20 08:07:02","2025-05-20 08:07:02");
INSERT INTO activity_log VALUES("100","default","updated","App\\Models\\Project","updated","18","App\\Models\\User","2","{\"attributes\":{\"end_date\":\"2025-12-16\",\"period\":400,\"updated_at\":\"2025-05-20T08:07:37.000000Z\"},\"old\":{\"end_date\":\"2024-11-11\",\"period\":0,\"updated_at\":\"2025-05-20T08:07:02.000000Z\"}}","","2025-05-20 08:07:37","2025-05-20 08:07:37");
INSERT INTO activity_log VALUES("101","default","updated","App\\Models\\Project","updated","11","App\\Models\\User","2","{\"attributes\":{\"deleted_at\":null,\"updated_at\":\"2025-05-21T08:16:31.000000Z\"},\"old\":{\"deleted_at\":\"2025-05-19T11:04:09.000000Z\",\"updated_at\":\"2025-05-19T11:04:09.000000Z\"}}","","2025-05-21 08:16:31","2025-05-21 08:16:31");
INSERT INTO activity_log VALUES("102","default","restored","App\\Models\\Project","restored","11","App\\Models\\User","2","{\"attributes\":{\"id\":11,\"name\":\".\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"2025-05-18\",\"end_date\":\"2025-08-26\",\"period\":100,\"manager_id\":2,\"deleted_at\":null,\"created_at\":\"2025-05-18T10:08:28.000000Z\",\"updated_at\":\"2025-05-21T08:16:31.000000Z\",\"supervisor_id\":1,\"consultant_id\":8,\"cost\":499999,\"customer\":\"lnli\",\"email\":\"bxfcttb@gmail.com\",\"number1\":\".22\",\"number2\":\"-1112\",\"number3\":\"426\",\"current_procedure_id\":null,\"status\":1}}","","2025-05-21 08:16:31","2025-05-21 08:16:31");
INSERT INTO activity_log VALUES("103","default","deleted","App\\Models\\Project","deleted","8","App\\Models\\User","2","{\"old\":{\"id\":8,\"name\":\"\\u0645\\u0634\\u0631\\u0648\\u0639\\u064a\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"2025-05-01\",\"end_date\":\"2025-08-09\",\"period\":100,\"manager_id\":2,\"deleted_at\":\"2025-05-21T13:07:17.000000Z\",\"created_at\":\"2025-05-13T07:17:59.000000Z\",\"updated_at\":\"2025-05-21T13:07:17.000000Z\",\"supervisor_id\":11,\"consultant_id\":8,\"cost\":2147483647,\"customer\":\"\\u0627\\u0644\\u0639\\u0645\\u064a\\u0644\",\"email\":\"xyz@gamil.com\",\"number1\":\"29\",\"number2\":\"12\",\"number3\":\"50\",\"current_procedure_id\":1,\"status\":3}}","","2025-05-21 13:07:17","2025-05-21 13:07:17");
INSERT INTO activity_log VALUES("104","default","updated","App\\Models\\Project","updated","1","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-22T05:20:42.000000Z\",\"current_procedure_id\":12},\"old\":{\"updated_at\":\"2025-05-20T06:20:54.000000Z\",\"current_procedure_id\":2}}","","2025-05-22 05:20:42","2025-05-22 05:20:42");
INSERT INTO activity_log VALUES("105","default","updated","App\\Models\\Project","updated","8","App\\Models\\User","2","{\"attributes\":{\"deleted_at\":null,\"updated_at\":\"2025-05-22T12:20:15.000000Z\"},\"old\":{\"deleted_at\":\"2025-05-21T13:07:17.000000Z\",\"updated_at\":\"2025-05-21T13:07:17.000000Z\"}}","","2025-05-22 12:20:15","2025-05-22 12:20:15");
INSERT INTO activity_log VALUES("106","default","restored","App\\Models\\Project","restored","8","App\\Models\\User","2","{\"attributes\":{\"id\":8,\"name\":\"\\u0645\\u0634\\u0631\\u0648\\u0639\\u064a\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"2025-05-01\",\"end_date\":\"2025-08-09\",\"period\":100,\"manager_id\":2,\"deleted_at\":null,\"created_at\":\"2025-05-13T07:17:59.000000Z\",\"updated_at\":\"2025-05-22T12:20:15.000000Z\",\"supervisor_id\":11,\"consultant_id\":8,\"cost\":2147483647,\"customer\":\"\\u0627\\u0644\\u0639\\u0645\\u064a\\u0644\",\"email\":\"xyz@gamil.com\",\"number1\":\"29\",\"number2\":\"12\",\"number3\":\"50\",\"current_procedure_id\":1,\"status\":3}}","","2025-05-22 12:20:15","2025-05-22 12:20:15");
INSERT INTO activity_log VALUES("107","default","deleted","App\\Models\\Project","deleted","8","App\\Models\\User","2","{\"old\":{\"id\":8,\"name\":\"\\u0645\\u0634\\u0631\\u0648\\u0639\\u064a\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"2025-05-01\",\"end_date\":\"2025-08-09\",\"period\":100,\"manager_id\":2,\"deleted_at\":\"2025-05-22T12:20:23.000000Z\",\"created_at\":\"2025-05-13T07:17:59.000000Z\",\"updated_at\":\"2025-05-22T12:20:23.000000Z\",\"supervisor_id\":11,\"consultant_id\":8,\"cost\":2147483647,\"customer\":\"\\u0627\\u0644\\u0639\\u0645\\u064a\\u0644\",\"email\":\"xyz@gamil.com\",\"number1\":\"29\",\"number2\":\"12\",\"number3\":\"50\",\"current_procedure_id\":1,\"status\":3}}","","2025-05-22 12:20:23","2025-05-22 12:20:23");
INSERT INTO activity_log VALUES("108","default","updated","App\\Models\\Project","updated","18","App\\Models\\User","2","{\"attributes\":{\"manager_id\":20,\"updated_at\":\"2025-05-22T17:31:06.000000Z\"},\"old\":{\"manager_id\":2,\"updated_at\":\"2025-05-20T08:07:37.000000Z\"}}","","2025-05-22 17:31:06","2025-05-22 17:31:06");
INSERT INTO activity_log VALUES("109","default","updated","App\\Models\\Project","updated","1","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-22T17:52:46.000000Z\",\"status\":2},\"old\":{\"updated_at\":\"2025-05-22T05:20:42.000000Z\",\"status\":1}}","","2025-05-22 17:52:46","2025-05-22 17:52:46");
INSERT INTO activity_log VALUES("110","default","updated","App\\Models\\Project","updated","1","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-22T17:52:57.000000Z\",\"status\":4},\"old\":{\"updated_at\":\"2025-05-22T17:52:46.000000Z\",\"status\":2}}","","2025-05-22 17:52:57","2025-05-22 17:52:57");
INSERT INTO activity_log VALUES("111","default","updated","App\\Models\\Project","updated","8","App\\Models\\User","2","{\"attributes\":{\"deleted_at\":null,\"updated_at\":\"2025-05-24T16:41:38.000000Z\"},\"old\":{\"deleted_at\":\"2025-05-22T09:20:23.000000Z\",\"updated_at\":\"2025-05-22T09:20:23.000000Z\"}}","","2025-05-24 19:41:38","2025-05-24 19:41:38");
INSERT INTO activity_log VALUES("112","default","restored","App\\Models\\Project","restored","8","App\\Models\\User","2","{\"attributes\":{\"id\":8,\"name\":\"\\u0645\\u0634\\u0631\\u0648\\u0639\\u064a\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"2025-05-01\",\"end_date\":\"2025-08-09\",\"period\":100,\"manager_id\":2,\"deleted_at\":null,\"created_at\":\"2025-05-13T04:17:59.000000Z\",\"updated_at\":\"2025-05-24T16:41:38.000000Z\",\"supervisor_id\":11,\"consultant_id\":8,\"cost\":2147483647,\"customer\":\"\\u0627\\u0644\\u0639\\u0645\\u064a\\u0644\",\"email\":\"xyz@gamil.com\",\"number1\":\"29\",\"number2\":\"12\",\"number3\":\"50\",\"current_procedure_id\":1,\"status\":3}}","","2025-05-24 19:41:38","2025-05-24 19:41:38");
INSERT INTO activity_log VALUES("113","default","updated","App\\Models\\Project","updated","8","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-24T16:46:03.000000Z\",\"status\":1},\"old\":{\"updated_at\":\"2025-05-24T16:41:38.000000Z\",\"status\":3}}","","2025-05-24 19:46:03","2025-05-24 19:46:03");
INSERT INTO activity_log VALUES("114","default","updated","App\\Models\\Project","updated","8","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-24T16:46:14.000000Z\",\"status\":2},\"old\":{\"updated_at\":\"2025-05-24T16:46:03.000000Z\",\"status\":1}}","","2025-05-24 19:46:14","2025-05-24 19:46:14");
INSERT INTO activity_log VALUES("115","default","updated","App\\Models\\Project","updated","8","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-24T16:46:21.000000Z\",\"status\":3},\"old\":{\"updated_at\":\"2025-05-24T16:46:14.000000Z\",\"status\":2}}","","2025-05-24 19:46:21","2025-05-24 19:46:21");
INSERT INTO activity_log VALUES("116","default","updated","App\\Models\\Project","updated","8","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-24T16:46:30.000000Z\",\"status\":4},\"old\":{\"updated_at\":\"2025-05-24T16:46:21.000000Z\",\"status\":3}}","","2025-05-24 19:46:30","2025-05-24 19:46:30");
INSERT INTO activity_log VALUES("117","default","created","App\\Models\\Project","created","19","App\\Models\\User","2","{\"attributes\":{\"id\":19,\"name\":\"qwe\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"2025-05-31\",\"end_date\":\"2025-10-01\",\"period\":123,\"manager_id\":2,\"deleted_at\":null,\"created_at\":\"2025-05-24T16:47:25.000000Z\",\"updated_at\":\"2025-05-24T16:47:25.000000Z\",\"supervisor_id\":1,\"consultant_id\":8,\"cost\":3132,\"customer\":\"123\",\"email\":\"x@y.z\",\"number1\":\"123\",\"number2\":\"123\",\"number3\":\"1233\",\"current_procedure_id\":null,\"status\":2}}","","2025-05-24 19:47:25","2025-05-24 19:47:25");
INSERT INTO activity_log VALUES("118","default","deleted","App\\Models\\Project","deleted","8","App\\Models\\User","2","{\"old\":{\"id\":8,\"name\":\"\\u0645\\u0634\\u0631\\u0648\\u0639\\u064a\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"2025-05-01\",\"end_date\":\"2025-08-09\",\"period\":100,\"manager_id\":2,\"deleted_at\":\"2025-05-24T19:25:00.000000Z\",\"created_at\":\"2025-05-13T04:17:59.000000Z\",\"updated_at\":\"2025-05-24T19:25:00.000000Z\",\"supervisor_id\":11,\"consultant_id\":8,\"cost\":2147483647,\"customer\":\"\\u0627\\u0644\\u0639\\u0645\\u064a\\u0644\",\"email\":\"xyz@gamil.com\",\"number1\":\"29\",\"number2\":\"12\",\"number3\":\"50\",\"current_procedure_id\":1,\"status\":4}}","","2025-05-24 22:25:00","2025-05-24 22:25:00");
INSERT INTO activity_log VALUES("119","default","updated","App\\Models\\Project","updated","8","App\\Models\\User","2","{\"attributes\":{\"deleted_at\":null,\"updated_at\":\"2025-05-24T19:33:43.000000Z\"},\"old\":{\"deleted_at\":\"2025-05-24T19:25:00.000000Z\",\"updated_at\":\"2025-05-24T19:25:00.000000Z\"}}","","2025-05-24 22:33:43","2025-05-24 22:33:43");
INSERT INTO activity_log VALUES("120","default","restored","App\\Models\\Project","restored","8","App\\Models\\User","2","{\"attributes\":{\"id\":8,\"name\":\"\\u0645\\u0634\\u0631\\u0648\\u0639\\u064a\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"2025-05-01\",\"end_date\":\"2025-08-09\",\"period\":100,\"manager_id\":2,\"deleted_at\":null,\"created_at\":\"2025-05-13T04:17:59.000000Z\",\"updated_at\":\"2025-05-24T19:33:43.000000Z\",\"supervisor_id\":11,\"consultant_id\":8,\"cost\":2147483647,\"customer\":\"\\u0627\\u0644\\u0639\\u0645\\u064a\\u0644\",\"email\":\"xyz@gamil.com\",\"number1\":\"29\",\"number2\":\"12\",\"number3\":\"50\",\"current_procedure_id\":1,\"status\":4}}","","2025-05-24 22:33:43","2025-05-24 22:33:43");
INSERT INTO activity_log VALUES("121","default","created","App\\Models\\Project","created","20","App\\Models\\User","2","{\"attributes\":{\"id\":20,\"name\":\"Project 1\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"2026-12-30\",\"end_date\":\"2027-01-04\",\"period\":5,\"manager_id\":2,\"deleted_at\":null,\"created_at\":\"2025-05-25T07:22:36.000000Z\",\"updated_at\":\"2025-05-25T07:22:36.000000Z\",\"supervisor_id\":1,\"consultant_id\":8,\"cost\":5000,\"customer\":\"Tarek\",\"email\":\"tarek@outlook.com\",\"number1\":\"010493483434\",\"number2\":null,\"number3\":null,\"current_procedure_id\":null,\"status\":1}}","","2025-05-25 10:22:36","2025-05-25 10:22:36");
INSERT INTO activity_log VALUES("122","default","created","App\\Models\\Project","created","21","App\\Models\\User","2","{\"attributes\":{\"id\":21,\"name\":\"t1\",\"available_procedures\":[\"5\",\"6\"],\"start_date\":\"2025-05-28\",\"end_date\":\"2025-09-25\",\"period\":120,\"manager_id\":2,\"deleted_at\":null,\"created_at\":\"2025-05-28T07:31:56.000000Z\",\"updated_at\":\"2025-05-28T07:31:56.000000Z\",\"supervisor_id\":1,\"consultant_id\":8,\"cost\":140000,\"customer\":\"lk\",\"email\":\"7981b26cc621@drmail.in\",\"number1\":null,\"number2\":null,\"number3\":null,\"current_procedure_id\":null,\"status\":1}}","","2025-05-28 10:31:56","2025-05-28 10:31:56");
INSERT INTO activity_log VALUES("123","default","updated","App\\Models\\Project","updated","12","App\\Models\\User","2","{\"attributes\":{\"deleted_at\":null,\"updated_at\":\"2025-05-28T09:10:08.000000Z\"},\"old\":{\"deleted_at\":\"2025-05-19T18:41:57.000000Z\",\"updated_at\":\"2025-05-19T18:41:57.000000Z\"}}","","2025-05-28 12:10:08","2025-05-28 12:10:08");
INSERT INTO activity_log VALUES("124","default","restored","App\\Models\\Project","restored","12","App\\Models\\User","2","{\"attributes\":{\"id\":12,\"name\":\"test11\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"2025-05-20\",\"end_date\":\"2025-05-19\",\"period\":2147483647,\"manager_id\":2,\"deleted_at\":null,\"created_at\":\"2025-05-19T18:18:37.000000Z\",\"updated_at\":\"2025-05-28T09:10:08.000000Z\",\"supervisor_id\":1,\"consultant_id\":8,\"cost\":4000000,\"customer\":\"\\u0623\\u062d\\u0645\\u062f \\u0623\\u0645\\u064a\\u0646\",\"email\":\"mohabhegazy839@gmail.com\",\"number1\":\"01012345616\",\"number2\":\"-2\",\"number3\":null,\"current_procedure_id\":null,\"status\":1}}","","2025-05-28 12:10:08","2025-05-28 12:10:08");
INSERT INTO activity_log VALUES("125","default","updated","App\\Models\\Project","updated","19","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-28T09:13:48.000000Z\",\"current_procedure_id\":2},\"old\":{\"updated_at\":\"2025-05-24T16:47:25.000000Z\",\"current_procedure_id\":null}}","","2025-05-28 12:13:48","2025-05-28 12:13:48");
INSERT INTO activity_log VALUES("126","default","deleted","App\\Models\\Project","deleted","1","App\\Models\\User","2","{\"old\":{\"id\":1,\"name\":\"\\u0641\\u064a\\u0644\\u0627 \\u0627\\u0644\\u0639\\u062b\\u064a\\u0645\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\"],\"start_date\":\"2024-07-13\",\"end_date\":\"2024-08-12\",\"period\":30,\"manager_id\":2,\"deleted_at\":\"2025-05-28T10:19:53.000000Z\",\"created_at\":\"2024-12-27T04:10:49.000000Z\",\"updated_at\":\"2025-05-28T10:19:53.000000Z\",\"supervisor_id\":11,\"consultant_id\":27,\"cost\":900000,\"customer\":\"Molestias doloremque\",\"email\":\"luvosaforu@mailinator.com\",\"number1\":\"712\",\"number2\":\"206\",\"number3\":\"189\",\"current_procedure_id\":12,\"status\":4}}","","2025-05-28 13:19:53","2025-05-28 13:19:53");
INSERT INTO activity_log VALUES("127","default","updated","App\\Models\\Project","updated","2","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-28T12:08:06.000000Z\",\"current_procedure_id\":10},\"old\":{\"updated_at\":\"2025-05-13T05:17:42.000000Z\",\"current_procedure_id\":5}}","","2025-05-28 15:08:06","2025-05-28 15:08:06");
INSERT INTO activity_log VALUES("128","default","created","App\\Models\\Project","created","22","App\\Models\\User","2","{\"attributes\":{\"id\":22,\"name\":\"t2\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"0025-05-28\",\"end_date\":\"0025-07-04\",\"period\":37,\"manager_id\":2,\"deleted_at\":null,\"created_at\":\"2025-05-28T12:11:02.000000Z\",\"updated_at\":\"2025-05-28T12:11:02.000000Z\",\"supervisor_id\":1,\"consultant_id\":8,\"cost\":0,\"customer\":\"jg\",\"email\":\"7981b26cc621@drmail.in\",\"number1\":null,\"number2\":null,\"number3\":null,\"current_procedure_id\":null,\"status\":1}}","","2025-05-28 15:11:02","2025-05-28 15:11:02");
INSERT INTO activity_log VALUES("129","default","updated","App\\Models\\Project","updated","22","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-28T12:12:54.000000Z\",\"cost\":3},\"old\":{\"updated_at\":\"2025-05-28T12:11:02.000000Z\",\"cost\":0}}","","2025-05-28 15:12:54","2025-05-28 15:12:54");
INSERT INTO activity_log VALUES("130","default","updated","App\\Models\\Project","updated","22","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-28T12:13:10.000000Z\",\"cost\":0},\"old\":{\"updated_at\":\"2025-05-28T12:12:54.000000Z\",\"cost\":3}}","","2025-05-28 15:13:10","2025-05-28 15:13:10");
INSERT INTO activity_log VALUES("131","default","created","App\\Models\\Project","created","23","App\\Models\\User","2","{\"attributes\":{\"id\":23,\"name\":\"t3\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"2025-05-28\",\"end_date\":\"2025-10-15\",\"period\":140,\"manager_id\":2,\"deleted_at\":null,\"created_at\":\"2025-05-28T12:14:41.000000Z\",\"updated_at\":\"2025-05-28T12:14:41.000000Z\",\"supervisor_id\":1,\"consultant_id\":8,\"cost\":150000,\"customer\":\"vm\",\"email\":\"7981b26cc621@drmail.in\",\"number1\":null,\"number2\":null,\"number3\":null,\"current_procedure_id\":null,\"status\":1}}","","2025-05-28 15:14:41","2025-05-28 15:14:41");
INSERT INTO activity_log VALUES("132","default","updated","App\\Models\\Project","updated","23","App\\Models\\User","2","{\"attributes\":{\"updated_at\":\"2025-05-28T12:20:51.000000Z\",\"current_procedure_id\":10},\"old\":{\"updated_at\":\"2025-05-28T12:14:41.000000Z\",\"current_procedure_id\":null}}","","2025-05-28 15:20:51","2025-05-28 15:20:51");
INSERT INTO activity_log VALUES("133","default","updated","App\\Models\\Project","updated","23","App\\Models\\User","4","{\"attributes\":{\"updated_at\":\"2025-05-28T13:14:28.000000Z\",\"current_procedure_id\":9},\"old\":{\"updated_at\":\"2025-05-28T12:20:51.000000Z\",\"current_procedure_id\":10}}","","2025-05-28 16:14:28","2025-05-28 16:14:28");
INSERT INTO activity_log VALUES("134","default","created","App\\Models\\Project","created","24","App\\Models\\User","2","{\"attributes\":{\"id\":24,\"name\":\"t4\",\"available_procedures\":[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"],\"start_date\":\"2025-05-28\",\"end_date\":\"2025-09-25\",\"period\":120,\"manager_id\":2,\"deleted_at\":null,\"created_at\":\"2025-05-28T13:17:14.000000Z\",\"updated_at\":\"2025-05-28T13:17:14.000000Z\",\"supervisor_id\":1,\"consultant_id\":8,\"cost\":-1,\"customer\":\"k.k.k\",\"email\":\"7981b26cc621@drmail.in\",\"number1\":null,\"number2\":null,\"number3\":null,\"current_procedure_id\":null,\"status\":1}}","","2025-05-28 16:17:14","2025-05-28 16:17:14");
INSERT INTO activity_log VALUES("135","default","updated","App\\Models\\Project","updated","24","App\\Models\\User","4","{\"attributes\":{\"updated_at\":\"2025-05-28T13:22:47.000000Z\",\"current_procedure_id\":21},\"old\":{\"updated_at\":\"2025-05-28T13:17:14.000000Z\",\"current_procedure_id\":null}}","","2025-05-28 16:22:47","2025-05-28 16:22:47");



DROP TABLE approvals;

CREATE TABLE `approvals` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `description` varchar(255) NOT NULL,
  `supervisor` tinyint(4) NOT NULL DEFAULT 0,
  `consultant` tinyint(4) NOT NULL DEFAULT 0,
  `customer` tinyint(4) NOT NULL DEFAULT 0,
  `supervisor_by` int(11) DEFAULT NULL,
  `consultant_by` int(11) DEFAULT NULL,
  `customer_by` int(11) DEFAULT NULL,
  `supervisor_status` int(11) DEFAULT NULL,
  `consultant_status` int(11) DEFAULT NULL,
  `customer_status` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `supervisor_rejection` text DEFAULT NULL,
  `consultant_rejection` text DEFAULT NULL,
  `customer_rejection` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO approvals VALUES("1","طلب موافقه","1","0","0","2","","","0","","","2025-01-26 22:26:35","2025-01-26 22:26:37","","","");
INSERT INTO approvals VALUES("2","انتهينا ونحتاج موافقة على الانتهاء","1","0","0","4","","","0","","","2025-01-27 06:47:47","2025-01-27 06:49:41","الأشياء غير واضحة","","");
INSERT INTO approvals VALUES("3","تاني معلش","1","0","0","4","","","1","","","2025-01-27 06:49:54","2025-01-27 06:50:03","","","");
INSERT INTO approvals VALUES("4","vaavaddvvv","1","1","0","2","2","","0","1","","2025-05-12 07:36:35","2025-05-12 07:37:02","vdzdzvz","","");
INSERT INTO approvals VALUES("5","fdsfds","1","0","0","2","","","1","","","2025-05-19 21:47:53","2025-05-19 21:48:01","","","");
INSERT INTO approvals VALUES("6","creatine mono hydrate","0","1","0","","2","","","0","","2025-05-22 05:06:20","2025-05-22 05:14:49","","","");
INSERT INTO approvals VALUES("7","يشسبيشسب","1","1","1","","","","","","","2025-05-24 21:34:59","2025-05-24 21:34:59","","","");
INSERT INTO approvals VALUES("8","صصص","0","1","0","","","","","","","2025-05-24 21:35:45","2025-05-24 21:35:45","","","");
INSERT INTO approvals VALUES("9","11111111111","1","1","1","","","","","","","2025-05-28 15:07:28","2025-05-28 15:07:28","","","");
INSERT INTO approvals VALUES("10","112222222","1","1","1","2","2","","1","0","","2025-05-28 15:08:06","2025-05-28 15:08:31","","mpkm.m...\n                     ,\'\n.","");
INSERT INTO approvals VALUES("11","nfnfn","1","1","1","","","","","","","2025-05-28 16:10:06","2025-05-28 16:10:06","","","");
INSERT INTO approvals VALUES("12","nfdnnfnf","1","1","1","","","","","","","2025-05-28 16:10:33","2025-05-28 16:10:33","","","");
INSERT INTO approvals VALUES("13","jmh mhmhm","1","1","1","","","","","","","2025-05-28 16:11:25","2025-05-28 16:11:25","","","");
INSERT INTO approvals VALUES("14","test","1","0","0","","","","","","","2025-05-28 16:14:28","2025-05-28 16:14:28","","","");



DROP TABLE attendances;

CREATE TABLE `attendances` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `org` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `meeting_id` int(10) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT 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;




DROP TABLE cache;

CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` int(11) NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;




DROP TABLE cache_locks;

CREATE TABLE `cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` int(11) NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;




DROP TABLE charts;

CREATE TABLE `charts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `project_id` int(10) unsigned NOT NULL,
  `file` varchar(255) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO charts VALUES("1","مخطط 1 في مشروع الأميرة - سي في بدوي","4","3","GsEBxVFFaXFgFA34sAFwWFsmKnWTtnwhWNwuHNkN.pdf","","2025-01-19 18:27:55","2025-01-19 18:27:55");
INSERT INTO charts VALUES("2","tesssssstttt1","2","2","O5XVawMykruI2xf2D3HEHB7XYjzJCMiXa5ffsJ2A.png","","2025-05-12 11:55:47","2025-05-24 22:40:00");
INSERT INTO charts VALUES("3","123","2","4","LXq1DtqiO6AdJyucNIzDKwNtvpMvfLzfsIpXwSG7.png","","2025-05-13 12:20:06","2025-05-13 12:20:06");
INSERT INTO charts VALUES("4","123","2","8","LtkXH9yWyrRdHNCzrdWRrZihanjoOksVMU3mI0KX.png","2025-05-24 22:37:13","2025-05-13 12:21:02","2025-05-24 22:37:13");
INSERT INTO charts VALUES("5","qwe","2","8","vmA7yjhq5NGChMHvWuyh6JlKkTb8ovwSPxXoTQWZ.mp4","2025-05-24 22:33:55","2025-05-22 09:42:36","2025-05-24 22:33:55");
INSERT INTO charts VALUES("6","d","2","1","VdO2cbaWLur2QGjiD0a9LstTV7VbKFhOGV8Z0eMs.png","","2025-05-27 11:39:46","2025-05-27 11:39:46");



DROP TABLE charts_files;

CREATE TABLE `charts_files` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `file` varchar(255) NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `chart_id` int(10) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO charts_files VALUES("1","سي في عبده على نفس سي في بدوي","ACmnMnNPbfEUP3XCMxTda6pBqlWuap7iNMaoVN0g.pdf","4","1","","2025-01-19 18:28:38","2025-01-19 18:28:38");
INSERT INTO charts_files VALUES("2","تحديث ثاني على المخطط 1 - عقد اتفاق الشركاء","Ecj9PksKizEWJaYOJ22cg267NdNS5nPnqOfbvzKl.pdf","4","1","","2025-01-19 18:29:15","2025-01-19 18:29:15");
INSERT INTO charts_files VALUES("3","update","tRUdu7xEQNX7zn92Adqcb76n40l2GguTU3OXwVV7.png","2","1","","2025-05-12 11:57:10","2025-05-12 11:57:10");
INSERT INTO charts_files VALUES("4","testing","s1JWbX5iaAbehiIB2HcllRxmFAe0ZWyQ8olKappy.pdf","2","1","","2025-05-12 23:10:53","2025-05-12 23:10:53");
INSERT INTO charts_files VALUES("5","testing 1","9Wc5ykwpFMuD4L2LhoUrOeEvZkkgkyBTvlbZ3hqU.pdf","2","1","","2025-05-12 23:14:24","2025-05-12 23:14:24");
INSERT INTO charts_files VALUES("6","testing2","gF7bWz7utjX8W9pHpJ2mRiGeG5bl3Ybv11aV9T5q.pdf","2","1","","2025-05-12 23:18:48","2025-05-12 23:18:48");
INSERT INTO charts_files VALUES("7","test time","sn5MgFvyF4qJ5kUnauvnDFKkhvtcfiEoVAz4cqGG.pdf","2","1","","2025-05-12 23:25:31","2025-05-12 23:25:31");
INSERT INTO charts_files VALUES("8","ddd","B5DfUA3J83dUlaXWYhjTKzXEhce0LismzyBk4QlW.txt","2","2","","2025-05-22 21:52:46","2025-05-22 21:52:46");
INSERT INTO charts_files VALUES("9","fffff","yJ5MHJJ8ONv9U6hZnF4EAw87nAL8hCIe8uha9nbT.txt","2","2","","2025-05-22 21:53:29","2025-05-22 21:53:29");
INSERT INTO charts_files VALUES("10","qwe","MGgIz8s9dvdSrqff8VDtKeqBoIEtIAphSSXfiWLY.png","2","4","","2025-05-24 22:36:58","2025-05-24 22:36:58");



DROP TABLE comments;

CREATE TABLE `comments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `content` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO comments VALUES("1","Add Update To The Project","2024-11-14 01:30:45","2024-11-14 01:30:45");
INSERT INTO comments VALUES("2","Add Update To The Project","2024-11-14 02:24:34","2024-11-14 02:24:34");
INSERT INTO comments VALUES("3","Add Update To The Project","2024-11-14 02:25:03","2024-11-14 02:25:03");
INSERT INTO comments VALUES("4","Add Update To The Project","2024-11-14 02:25:25","2024-11-14 02:25:25");
INSERT INTO comments VALUES("5","comment add by mohammed hossam","2024-11-14 04:31:52","2024-11-14 04:31:52");
INSERT INTO comments VALUES("6","ة، لذا تُعتمد نسب يتم التوصّل إليها من قِبل مصانع إنتاج الخرسانة، ثمّ يجري فحص دقيق لأدائها عن طريق مصمّمين مختصّين في هذا المجال، مع الحرص على أن يتم تقليل نسب الإسمنت","2024-11-15 04:28:04","2024-11-15 04:28:04");
INSERT INTO comments VALUES("7","ة، لذا تُعتمد نسب يتم التوصّل إليها من قِبل مصانع إنتاج الخرسانة، ثمّ يجري فحص دقيق لأدائها عن طريق مصمّمين مختصّين في هذا المجال، مع الحرص على أن يتم تقليل نسب الإسمنت","2024-11-15 04:28:23","2024-11-15 04:28:23");
INSERT INTO comments VALUES("8","أعمال الحفر. يجب فحص الموقع قبل بدء فى تنفيذ الأساس وتقرير أنسب الطرق للحفر والوقت المناسب واتخاذ الأحتياطات اللازمة لتغلب على الصعوبات لتسرب المياة وتفكيك التربة إلى غير ذلك من عقبات .","2024-11-17 06:50:52","2024-11-17 06:50:52");
INSERT INTO comments VALUES("9","أعمال الحفر. يجب فحص الموقع قبل بدء فى تنفيذ الأساس وتقرير أنسب الطرق للحفر والوقت المناسب واتخاذ الأحتياطات اللازمة لتغلب على الصعوبات لتسرب المياة وتفكيك التربة إلى غير ذلك من عقبات .","2024-11-17 06:52:05","2024-11-17 06:52:05");
INSERT INTO comments VALUES("10","اضافة تحديث جديد","2024-11-19 08:07:59","2024-11-19 08:07:59");
INSERT INTO comments VALUES("11","اضافة ملفات","2024-11-19 08:08:22","2024-11-19 08:08:22");
INSERT INTO comments VALUES("12","تحديث على المشروع XXXXXXX","2024-11-20 11:12:23","2024-11-20 11:12:23");
INSERT INTO comments VALUES("13","اضافة تحديث","2024-11-20 11:13:35","2024-11-20 11:13:35");
INSERT INTO comments VALUES("14","اضافه تحديث","2024-11-21 05:05:12","2024-11-21 05:05:12");
INSERT INTO comments VALUES("15","اضافة تحديث","2024-11-25 13:51:27","2024-11-25 13:51:27");
INSERT INTO comments VALUES("16","أضف تحديث للمشروع","2024-12-16 12:23:35","2024-12-16 12:23:35");
INSERT INTO comments VALUES("17","أضف تحديث للمشروع","2024-12-16 12:24:20","2024-12-16 12:24:20");
INSERT INTO comments VALUES("18","أضف تحديث للمشروع","2024-12-16 16:51:40","2024-12-16 16:51:40");
INSERT INTO comments VALUES("19","اضافة تحديث جديد","2024-12-18 05:48:55","2024-12-18 05:48:55");
INSERT INTO comments VALUES("20","لماذا فعلت كذا يا مدير الموقع؟","2024-12-18 09:09:21","2024-12-18 09:09:21");
INSERT INTO comments VALUES("21","والله محتاجين مساعدة حد يكون بيفهم في المخططات","2024-12-18 10:04:33","2024-12-18 10:04:33");
INSERT INTO comments VALUES("22","أبشر يا بو فهد","2024-12-18 10:05:07","2024-12-18 10:05:07");
INSERT INTO comments VALUES("23","وضع حواجز شريطية حول مكان العمل","2025-01-15 15:58:07","2025-01-15 15:58:07");
INSERT INTO comments VALUES("24","تحديث سسس\nسشب سيب","2025-01-16 09:58:25","2025-01-16 09:58:25");
INSERT INTO comments VALUES("25","تجربة جديدة حد","2025-01-16 10:10:23","2025-01-16 10:10:23");
INSERT INTO comments VALUES("26","تجربة جديدة حد تاني","2025-01-16 10:11:44","2025-01-16 10:11:44");
INSERT INTO comments VALUES("27","وضع حواجز شريطية حول مكان العمل","2025-01-16 10:13:15","2025-01-16 10:13:15");
INSERT INTO comments VALUES("28","أول رسالة في الإجراء بتاع التنظيف","2025-01-16 10:55:43","2025-01-16 10:55:43");
INSERT INTO comments VALUES("29","رسالة في إجراء تنظيف المكان","2025-01-16 10:58:03","2025-01-16 10:58:03");
INSERT INTO comments VALUES("30","التخلص من كذا كذا","2025-01-27 06:46:44","2025-01-27 06:46:44");
INSERT INTO comments VALUES("31","رسالة جديدة في الإجراء الأول","2025-05-06 08:19:39","2025-05-06 08:19:39");
INSERT INTO comments VALUES("32","cvjbn","2025-05-08 07:46:26","2025-05-08 07:46:26");
INSERT INTO comments VALUES("33","cvnnv","2025-05-08 07:48:30","2025-05-08 07:48:30");
INSERT INTO comments VALUES("34","sbbsgsbbgbg","2025-05-11 14:30:05","2025-05-11 14:30:05");
INSERT INTO comments VALUES("35","ملف الاجراءات","2025-05-12 22:03:33","2025-05-12 22:03:33");
INSERT INTO comments VALUES("36","dbbdbbfbbg","2025-05-13 07:29:22","2025-05-13 07:29:22");
INSERT INTO comments VALUES("37","عايز حاجات","2025-05-13 11:25:23","2025-05-13 11:25:23");
INSERT INTO comments VALUES("38","Test 112","2025-05-19 21:47:03","2025-05-19 21:47:03");
INSERT INTO comments VALUES("39","Vete adormer ahore","2025-05-22 05:21:20","2025-05-22 05:21:20");
INSERT INTO comments VALUES("40","qe","2025-05-22 12:13:55","2025-05-22 12:13:55");
INSERT INTO comments VALUES("41","فاتورة","2025-05-25 10:39:11","2025-05-25 10:39:11");
INSERT INTO comments VALUES("42","ngfgnfn","2025-05-28 16:12:22","2025-05-28 16:12:22");
INSERT INTO comments VALUES("43","kn,k,nk","2025-05-28 16:22:47","2025-05-28 16:22:47");



DROP TABLE companies;

CREATE TABLE `companies` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `spacial` varchar(255) DEFAULT NULL,
  `number1` varchar(255) DEFAULT NULL,
  `number2` varchar(255) DEFAULT NULL,
  `number3` varchar(255) DEFAULT NULL,
  `details` text DEFAULT NULL,
  `address` text DEFAULT NULL,
  `responsible` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO companies VALUES("1","شركة عبدالرحمن الغزوانى للمقاولات","","2024-11-10 15:27:48","2024-12-17 20:14:38","عام","058888888","","","","","");
INSERT INTO companies VALUES("2","شركة الحسام الفضي لتوريد العمالة","","2024-12-17 18:35:55","2024-12-17 18:35:55","مقاول أنفار","05598989898","055322222222","","مقاول انفار كبير","العليا","");
INSERT INTO companies VALUES("3","سما الخليج للأخشاب","","2024-12-18 04:07:35","2024-12-18 04:07:35","مورد خامات","0566666666","","","","","محمود");



DROP TABLE concretes;

CREATE TABLE `concretes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `content` text DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `car_number` varchar(191) DEFAULT NULL,
  `amount` varchar(191) DEFAULT NULL,
  `dep_time` time DEFAULT NULL,
  `arrival_time` time DEFAULT NULL,
  `height` double DEFAULT NULL,
  `down` double DEFAULT NULL,
  `temperature` double DEFAULT NULL,
  `accepted` tinyint(1) NOT NULL DEFAULT 0,
  `video` varchar(191) NOT NULL DEFAULT '0',
  `tech_name` varchar(191) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO concretes VALUES("1","كويس جدا","","2025-05-25 10:51:13","2025-05-25 10:51:13","5","5000","13:01:00","02:22:00","5","50","20","1","media/concretes/Rw9iLfLBg9hNdhGNmchaELjWo1aYZRXieUzWa4hi.mp4","");
INSERT INTO concretes VALUES("2","","","2025-05-25 10:53:56","2025-05-25 10:53:56","6","6000","09:59:00","07:08:00","19","2491234","20","1","media/concretes/aKWM413UpmVYDFlPY2EUKu4RAHcf6XlXqWVXHZ1R.mp4","");
INSERT INTO concretes VALUES("3","123","","2025-05-27 21:52:31","2025-05-27 21:52:31","123","200","12:51:00","12:51:00","122","12","122","0","","");
INSERT INTO concretes VALUES("4","123","","2025-05-27 21:52:59","2025-05-27 21:52:59","123","200","21:55:00","13:52:00","122","12","122","1","","");
INSERT INTO concretes VALUES("5","test","","2025-05-27 22:00:51","2025-05-27 22:00:51","123","123","14:00:00","15:00:00","122","12","122","1","","امين");
INSERT INTO concretes VALUES("6","122","","2025-05-27 22:03:13","2025-05-27 22:03:13","123","123","13:02:00","14:02:00","122","12","122","1","","امين");
INSERT INTO concretes VALUES("7","","","2025-05-27 22:05:40","2025-05-27 22:05:40","123","123","14:04:00","13:04:00","122","12","122","1","","امين");
INSERT INTO concretes VALUES("8","qwe","","2025-05-28 12:12:14","2025-05-28 12:12:14","123","123","12:14:00","12:16:00","123","123","123","0","","qwe");



DROP TABLE contracts;

CREATE TABLE `contracts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `company_id` int(10) unsigned NOT NULL,
  `responsible_id` int(10) unsigned NOT NULL,
  `project_id` int(10) unsigned NOT NULL,
  `confirmation_date` date NOT NULL,
  `details` text DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `files` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO contracts VALUES("1","عقد الكهرباء والسباكة عمل سعد صالح","1","2","1","2024-11-13","رقم الملف ١٣\nاسم الملف: العقود وعروض الأسعار\n    • هذا الملف يتضمن ثلاث ملفات رئيسية:\nالأول: العقود المعتمدة والموقعة.\n    • كل يعقد يتم توقيعه واعتماده، يتم رفعه هنا لإمكانية الرجوع له والاطلاع عند الحاجة.\n    • قائمة توضح أسم كل عقد + اسم الجهة + تاريخ اعتماده + اسم من رفعه\n\nالثاني: عروض الأسعار الواصلة من المقاولين والموردين.\n    • عروض الأسعار اللي تصل من المقاولين والموردين يتم حفظها بهذا الملف لإمكانية الرجوع لها عند الحاجة.\n    • قائمة توضح اسم كل عرض سعر وصل + اسم الجهة + تاريخ العرض + اسم من رفعه\n\nالثالث: عروض الأسعار اللي يتم إعدادها من قبل مدير الموقع وترسل للعميل.\n    • بعض الأعمال يتم رفع عرض السعر الخاص بها من قبل مدير الموقع إلى العميل مباشرة.\n    • قائمة توضح كل عرض سعر تم إرساله للعميل + اسم العمل + اسم المقاول او الجهة + تاريخه + اسم من رفعه\n    • بعض الأحيان العرض الواحد يتضمن عدة أعمال، مهم مراعاة ذلك عند تصميم قالب عرض السعر اللي يتم إعداده من قبل مدير الموقع.","","2024-11-10 15:38:14","2025-05-21 13:20:27","");
INSERT INTO contracts VALUES("2","توريد أخشاب","3","9","2","2024-12-17","","","2024-12-18 04:08:16","2024-12-18 04:08:16","[\"contracts\\/ecOnTQfamAnaE3q4jqTcoL2kILakieV2pGk5DRPH.jpg\",\"contracts\\/fcMdG2XeIXMkL7lWIzPybedSNDkp72VcGQ04fL03.pdf\"]");
INSERT INTO contracts VALUES("3","عقد","1","2","2","4045-05-22","Հայերեն Shqip ‫العربية Български Català 中文简体 Hrvatski Česky Dansk Nederlands English Eesti Filipino Suomi Français ქართული Deutsch Ελληνικά ‫עברית हिन्दी Magyar Indonesia Italiano Latviski Lietuviškai македонски Melayu Norsk Polski Português Româna Pyccкий Српски Slovenčina Slovenščina Español Svenska ไทย Türkçe Українська Tiếng Việt\nLorem Ipsum\n\"Neque porro quisquam est qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit...\"\n\"There is no one who loves pain itself, who seeks after it and wants to have it, simply because it is pain...\"\nLorem ipsum dolor sit amet, consectetur adipiscing elit. Integer eu volutpat lacus. Aenean vestibulum finibus tellus et tincidunt. Pellentesque viverra enim ut neque sodales sagittis. Nam vehicula purus sit amet cursus tincidunt. Nullam malesuada nunc a congue malesuada. Aliquam hendrerit mauris urna, eget aliquet est congue eget. Donec mattis mauris a ligula aliquet, et hendrerit tortor dignissim. Sed aliquet metus et accumsan venenatis. Nullam eget ligula ac felis rhoncus fringilla vitae in nulla. Nunc in aliquam dolor, ac accumsan erat.\n\nProin sed gravida mauris. Proin viverra posuere nunc in varius. Sed at lobortis urna, eget aliquet urna. Pellentesque consectetur nulla neque, sed cursus lectus auctor nec. Maecenas dapibus dui vel mattis aliquam. Nullam purus dolor, accumsan tincidunt sodales vitae, scelerisque a libero. Phasellus at egestas quam. Suspendisse eget vestibulum mi. Mauris id tellus aliquam, consectetur odio ut, vehicula sapien. Curabitur ligula risus, tempor nec ultricies in, sollicitudin id urna. Donec non aliquet ante, in elementum augue. Mauris consectetur quam id magna ullamcorper, eu facilisis risus interdum. Maecenas mattis eleifend velit, tempus malesuada quam scelerisque in. Curabitur nec consectetur ipsum. Nulla facilisi.\n\nPellentesque justo lacus, bibendum in maximus vitae, bibendum non enim. Morbi libero enim, fermentum sed lobortis vitae, sodales nec mauris. Mauris porta magna sit amet erat tincidunt, id lacinia libero consequat. Vivamus eu interdum dolor. Morbi ut ex quam. Vivamus vel interdum lorem, eget venenatis sapien. Maecenas auctor diam vitae mi dignissim consectetur. Donec tempus at quam sit amet iaculis. Sed aliquam purus vel ante gravida, id laoreet mauris faucibus. Maecenas pharetra sapien sem, ac euismod nibh porttitor sit amet. Ut ut sem nec purus cursus fermentum sit amet et nulla. Integer efficitur justo ligula, a efficitur lacus viverra vitae.\n\nQuisque venenatis, risus vitae faucibus sodales, leo eros viverra arcu, a finibus mauris massa et quam. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia curae; Vivamus facilisis fringilla lacus vel consectetur. Ut vitae lectus ante. Cras a orci pretium lacus suscipit pellentesque a at nisi. Praesent molestie ex at venenatis pellentesque. Etiam arcu diam, mollis sit amet turpis nec, tempus accumsan eros. Vestibulum augue nunc, mollis mattis posuere nec, sodales id quam. Proin eget lorem id lorem fringilla luctus a quis ante. Sed tempus sit amet quam sit amet luctus. Etiam a tincidunt enim. In sem ex, euismod et sollicitudin nec, pretium eget ante. Vestibulum eget gravida velit. Proin nisl lectus, pretium vel pulvinar vitae, posuere cursus urna.\n\nSed condimentum mauris in erat dapibus, eget tempus risus ultrices. In felis nibh, hendrerit eget pharetra at, porta gravida magna. Maecenas mollis neque orci, id tincidunt mi molestie nec. Suspendisse vestibulum nulla a diam commodo, ut viverra orci eleifend. Nullam vel laoreet orci. Duis ante dolor, feugiat volutpat tincidunt nec, faucibus ut lectus. Aliquam ultricies dapibus malesuada. Vivamus nec iaculis augue. Morbi ac fringilla sapien. Sed sit amet lectus felis. Fusce interdum ipsum sed odio pharetra, eget dictum nisl ultrices. Ut rhoncus pellentesque nunc, sed scelerisque mi ornare non. Integer porttitor vulputate mauris, rutrum rhoncus eros efficitur vitae. Aliquam sed sapien porta, facilisis ligula non, tempus dolor.\n\nPellentesque egestas fermentum luctus. Nam vitae nunc libero. Aliquam elementum lectus eu velit bibendum posuere. Quisque lacus odio, fermentum at pulvinar in, feugiat sed ex. Etiam commodo felis ac enim condimentum auctor. In dapibus at turpis eu pellentesque. Proin eleifend, risus id imperdiet condimentum, ipsum purus aliquet enim, eu auctor ante urna sed tortor. Fusce quis egestas eros. Vivamus eget dapibus orci, eget tristique lectus. Nulla hendrerit diam sed magna hendrerit, eu iaculis mi porta. Sed vel faucibus erat.\n\nIn hac habitasse platea dictumst. Duis hendrerit erat a magna semper pulvinar. In molestie urna sit amet nibh aliquet mollis. Vestibulum in lacus accumsan, elementum arcu sed, viverra dolor. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Nam rhoncus dictum semper. Ut vitae sapien commodo, elementum dui ac, consectetur nibh. Duis in dui convallis, faucibus diam ac, tristique neque. Aliquam vestibulum lorem metus, in venenatis quam tristique non. Etiam feugiat magna eget sodales pretium. Quisque vitae turpis non purus porta posuere vitae in tortor. Duis bibendum, velit quis tincidunt pulvinar, augue felis vulputate elit, vel ornare quam metus nec leo. Praesent consectetur, nunc sed consequat iaculis, libero neque pulvinar ipsum, a imperdiet augue elit ut orci. Pellentesque vitae rutrum lorem, a elementum massa. Vivamus sed neque lorem.\n\nAenean risus diam, ultrices sit amet feugiat ac, posuere at enim. Etiam aliquam orci maximus pharetra aliquam. Integer in risus pretium, accumsan turpis nec, porta enim. Cras tellus libero, aliquet vel tortor eu, sodales pharetra quam. Duis et risus finibus, lobortis quam quis, consequat nisl. Sed lobortis ex orci, id porta erat volutpat at. Aliquam a eleifend eros, at sollicitudin neque. Nullam sit amet vestibulum orci. Nunc sollicitudin viverra pretium. Curabitur euismod pulvinar felis. Sed accumsan diam et nulla viverra, scelerisque dapibus urna fermentum.\n\nUt lobortis eget ipsum vel volutpat. Ut mattis augue ac pulvinar imperdiet. Duis vel ipsum quis enim pretium pellentesque. Integer vel arcu nec leo dignissim rhoncus. Pellentesque felis justo, sodales sed tristique tempor, fringilla a libero. Curabitur at nulla odio. Morbi odio sem, eleifend sed consequat non, bibendum eu ligula.\n\nDonec ante sapien, malesuada sit amet massa dictum, cursus sollicitudin lectus. Ut eu finibus velit. Phasellus placerat congue nisi id vestibulum. Etiam aliquet lorem eget lacus congue, at pellentesque nibh porttitor. Mauris convallis convallis tellus vel euismod. Ut fermentum urna nulla, at bibendum ante ullamcorper vitae. Praesent et vulputate justo. Duis condimentum purus et urna congue, sit amet blandit sem facilisis. Aenean pharetra libero ut luctus egestas. Proin at turpis ut risus accumsan suscipit quis hendrerit ante.\n\nVivamus mauris urna, congue a ante a, convallis consectetur dolor. Vivamus bibendum, ligula ut cursus iaculis, eros elit tincidunt sapien, a posuere nunc quam non est. Vivamus et sollicitudin justo. Sed feugiat erat sem, ut consectetur leo tincidunt sit amet. In lacus purus, vehicula at libero ut, rutrum sagittis urna. Praesent sed odio ac urna porta bibendum. Duis vehicula auctor mi quis feugiat. Integer nulla nulla, facilisis sollicitudin fermentum non, imperdiet eget nisi. Praesent blandit, mi a imperdiet tristique, turpis est porta arcu, quis iaculis orci lacus vel mauris. Maecenas ex tortor, scelerisque eu volutpat quis, commodo non dolor. Donec mollis euismod neque. Fusce ultricies dui ut fringilla tristique.\n\nClass aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Fusce pellentesque pharetra mi vitae rhoncus. Duis tincidunt vestibulum malesuada. Quisque et eleifend sapien. Pellentesque ultricies justo fringilla orci bibendum lobortis. Etiam auctor nec enim in porta. Quisque et finibus ipsum. Donec dignissim interdum dolor non efficitur. Nullam aliquam risus ut dapibus congue. In hac habitasse platea dictumst. Vivamus vehicula mauris in nisi fringilla efficitur. Vestibulum molestie ipsum enim, id mollis lectus tristique vitae. Quisque aliquam pulvinar orci, nec tempor dolor. Integer eget lacinia orci, ac aliquet enim.\n\nAenean posuere lacus nec libero efficitur vestibulum. Nulla facilisi. Ut tempus aliquam dui, at tempor lorem congue quis. Phasellus mattis malesuada erat a rutrum. Pellentesque venenatis ultrices accumsan. Quisque tristique sapien non mauris tincidunt, quis blandit urna egestas. Mauris sit amet imperdiet diam. Cras diam justo, mattis quis justo viverra, sagittis pharetra magna. Curabitur malesuada massa ex, vel pulvinar diam porta eget. Pellentesque mollis neque eget ex fringilla, a egestas ligula egestas. Nulla vel maximus enim. Integer lobortis elit mauris, sit amet hendrerit mi sodales a. Nam suscipit eros vitae laoreet dignissim. Nulla placerat bibendum dui, nec aliquam risus faucibus et. Donec lobortis consequat tellus, rutrum tincidunt est convallis ullamcorper. Duis elementum dignissim massa, vel laoreet tellus dignissim vel.\n\nProin quis turpis fringilla, ornare enim ac, mollis nisi. Etiam varius arcu ut dui varius, nec sagittis neque tincidunt. Cras vitae blandit ante. Sed eu lacus lorem. Aliquam ac finibus urna. Vestibulum vel molestie tellus. Quisque ultricies dolor eget pellentesque finibus. Sed eu semper sem, quis dapibus ante. Nulla facilisi. Duis enim justo, rhoncus non congue eget, tempor in erat. Nunc maximus ut enim non consequat. Vestibulum tempor odio felis. In vestibulum eros in semper tristique. Nunc a sodales massa. Curabitur et faucibus nulla, sit amet ultricies augue. Suspendisse at mi in lorem vestibulum posuere at nec justo.\n\nNulla in ante in dolor tempor ornare at sollicitudin nibh. Cras a est neque. Nam non tortor dignissim, lobortis metus non, tempus mi. Aliquam id luctus odio. Etiam ac dolor pellentesque, euismod nunc sit amet, consequat odio. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Suspendisse sit amet tincidunt justo, ut placerat nunc.\n\nIn congue sem et dapibus blandit. Quisque sit amet nunc mollis, elementum lacus finibus, vehicula enim. Nam lacinia consectetur mauris, a tincidunt nibh malesuada quis. Duis ut consequat odio. Nulla laoreet metus nec nulla ultrices aliquet. Sed eu mollis nibh. Sed ullamcorper felis vel est iaculis gravida.\n\nNulla lectus orci, luctus quis convallis vitae, finibus sit amet sem. Nam condimentum eros dui, nec pretium augue viverra ut. Integer lorem risus, euismod eu rutrum vel, lobortis et nulla. Ut bibendum ante ornare nibh tempor condimentum. Donec lacus metus, ullamcorper eu enim rhoncus, sollicitudin rhoncus metus. Nunc sagittis ante non ipsum cursus, sed rhoncus urna tempor. Aenean sed nibh venenatis, luctus risus non, rutrum dui. Quisque laoreet lorem at convallis sollicitudin.\n\nPraesent sit amet pulvinar tortor. Curabitur eros nulla, molestie ut nulla non, posuere varius nisi. Curabitur sit amet tellus ornare, posuere lacus id, bibendum felis. Phasellus fermentum tempor consectetur. Duis gravida enim a augue auctor varius. Suspendisse potenti. Etiam turpis magna, bibendum a lacus vitae, aliquet posuere tellus. Duis tincidunt sed arcu et sagittis. Donec a pretium libero, sed condimentum elit. Aenean ac est dui. Cras at risus sed odio viverra imperdiet at ut purus.\n\nCras leo elit, rutrum vel ipsum vel, gravida pretium nunc. Etiam vitae erat odio. Donec molestie, neque vel ullamcorper sollicitudin, nisi erat posuere quam, non tincidunt ipsum dui eget ligula. Nunc dui augue, sollicitudin sit amet dictum et, tincidunt in ex. Maecenas eros ex, fermentum eget ante sed, lobortis porta nibh. Etiam at cursus dolor, et ultricies ligula. Fusce vestibulum sagittis felis, a scelerisque lectus aliquet eu. Pellentesque vel blandit risus, ac hendrerit nulla. Cras a libero vitae felis tempus porttitor volutpat ac enim. Maecenas tristique rutrum euismod. Mauris elementum commodo tortor id auctor. Aliquam ullamcorper quam velit, vehicula faucibus mi tincidunt vel.\n\nQuisque blandit nunc et arcu gravida mollis. Aliquam erat volutpat. Nulla blandit hendrerit justo, eu interdum lorem. Morbi hendrerit tincidunt mattis. Donec tristique vulputate lobortis. In mattis porttitor vulputate. Vestibulum pretium erat augue, nec congue orci dictum quis. Sed luctus tortor sed purus pharetra, molestie vulputate velit ornare. Ut egestas ut dolor eu tincidunt. Nunc ut nunc gravida, placerat est a, venenatis lacus. Curabitur id risus non erat viverra pellentesque ac quis lorem.\n\nVivamus mollis consequat quam non placerat. Etiam eget nulla dui. Fusce tempor nibh in purus varius, at feugiat metus semper. Phasellus ultrices ultrices purus in feugiat. Interdum et malesuada fames ac ante ipsum primis in faucibus. Praesent vitae viverra diam. Nulla facilisi. Orci varius natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Maecenas ut ligula sit amet risus semper molestie. Morbi eu massa elit. Phasellus vel nibh quis sapien volutpat consectetur.\n\nSed luctus, tellus varius commodo semper, magna augue ultricies nunc, et pretium diam ex vitae ligula. Sed eget leo purus. Donec varius nibh ut ligula finibus, ut consequat ex tincidunt. Donec ut sapien lacinia, auctor orci in, accumsan urna. Aenean turpis dui, scelerisque sit amet sodales et, malesuada sit amet mauris. Proin lacinia diam quis vulputate rhoncus. Maecenas ultricies fringilla feugiat. Sed eget ex sit amet est efficitur euismod eget in enim. Integer fringilla ultrices nibh non pharetra. Vestibulum nec lacus nunc. Mauris accumsan velit dolor, ut aliquet dui ultricies quis. Ut sit amet sagittis turpis.\n\nProin et sapien leo. Nullam et auctor tortor, tempus dapibus eros. Nulla laoreet erat massa, a maximus nulla consequat vitae. Fusce fermentum sem euismod sagittis luctus. Duis feugiat orci sit amet sapien consequat hendrerit. Morbi vel enim mi. Duis vestibulum, eros non placerat lobortis, diam dolor molestie leo, non facilisis justo nisi et arcu. Morbi a efficitur erat. Nullam venenatis eget arcu gravida placerat. Sed vestibulum vitae lectus ut tempus.\n\nAliquam dignissim laoreet lectus, at consectetur nibh fringilla eu. Nullam ultricies, orci ac pellentesque aliquet, nulla libero iaculis erat, ut aliquam augue nisl in arcu. Ut ultricies aliquet lacus rhoncus vulputate. Sed sit amet odio nec enim vulputate malesuada ac ac leo. Nunc dictum nunc ut varius sodales. Nunc vel nisl vitae quam facilisis euismod. Vivamus ut lacus eget erat commodo vehicula. Morbi id felis eget urna fringilla porta. Proin porttitor magna nunc, nec vehicula magna semper non. Mauris euismod leo sit amet nibh aliquet, ac consequat justo tincidunt. In hac habitasse platea dictumst.\n\nNullam facilisis, nisl eget venenatis faucibus, libero ipsum rutrum arcu, eu iaculis sem turpis pellentesque elit. Praesent sit amet ornare quam, vel sollicitudin tortor. Sed congue magna a eros scelerisque rhoncus. Sed interdum eleifend sem, ac egestas ante fringilla non. Aliquam ornare at risus vel gravida. Vestibulum venenatis ut felis lacinia porttitor. Curabitur posuere ac urna eget venenatis. Nunc tincidunt enim id ultricies sagittis.\n\nMauris lacinia vestibulum pretium. Proin nec ultricies felis. Sed accumsan, diam quis fermentum condimentum, sem lorem hendrerit arcu, a ultrices ipsum felis vulputate nunc. Nam aliquam risus et dolor dapibus sollicitudin. Ut at dolor sit amet augue molestie pharetra. Nullam tortor tortor, tempus ac ante quis, aliquet accumsan tellus. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla facilisi. Curabitur congue arcu eu fringilla ullamcorper. Integer id enim ultrices, vulputate eros in, aliquam felis. Curabitur vel egestas ex. Suspendisse cursus molestie vestibulum. Nulla non lacus eu mi tincidunt pretium. Vestibulum congue condimentum erat id dictum. Vivamus vel lorem nec est pharetra semper. Vestibulum vestibulum nisl at diam consequat, dignissim luctus quam maximus.\n\nNullam dictum aliquet est vel tincidunt. Donec vel elit mi. Nam at tristique tellus, eu dictum quam. In libero tellus, vehicula sollicitudin ultricies non, tincidunt ut risus. Quisque nec convallis purus, sit amet tincidunt massa. Vestibulum eu velit felis. Nunc ut porta nulla. Pellentesque nisi ligula, tempus non ipsum sit amet, porttitor pellentesque nunc. Cras vel accumsan nisl. Orci varius natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Suspendisse aliquet at lectus quis posuere. Mauris iaculis in tortor et viverra.\n\nMauris quis efficitur leo. Nulla ac tincidunt mi, id ullamcorper libero. Nullam bibendum lacus non urna elementum egestas. Donec et risus orci. Donec orci risus, venenatis convallis libero in, vestibulum faucibus nisi. Suspendisse potenti. Aliquam facilisis justo sit amet eros ullamcorper, vitae semper mi iaculis. Donec at finibus ex. Etiam id dolor consequat, luctus lacus ut, consectetur orci. Duis orci erat, suscipit sed libero eu, vehicula mollis orci. In aliquet enim nec purus rhoncus vestibulum. Fusce et luctus nisl.\n\nFusce efficitur libero vitae ligula eleifend, sed pretium massa ultricies. Praesent mollis arcu in tellus iaculis, laoreet faucibus nulla suscipit. Praesent placerat lacus sed nibh vehicula luctus. Vestibulum euismod enim justo, nec fringilla dui lobortis vitae. Morbi tincidunt a lorem quis imperdiet. Etiam aliquet, dolor nec efficitur facilisis, quam velit euismod sapien, eu varius elit neque quis orci. Integer consequat ac lectus vitae venenatis. Curabitur euismod nulla enim, eget mattis libero porta id. Mauris et ultricies ante. Sed auctor justo nibh, ac porttitor sapien porttitor at. Cras volutpat arcu at ante egestas, sit amet volutpat odio faucibus. Mauris a augue sodales, dignissim metus vel, posuere erat. Sed pulvinar nec est sit amet mattis.\n\nPellentesque sodales eget nulla ut pharetra. Vestibulum eu varius ipsum, lacinia dapibus velit. Phasellus non libero tincidunt dui egestas facilisis. In finibus nisi et laoreet sodales. Phasellus felis mi, auctor nec tellus in, semper rhoncus ante. Curabitur elementum ex at risus faucibus, quis porta ex efficitur. Aliquam vel mattis turpis. Integer eu turpis accumsan, dignissim nisi ac, laoreet magna.\n\nMorbi felis orci, faucibus ut tempus ac, euismod ac risus. Quisque ornare neque sed velit congue efficitur. Nunc nec metus nec quam convallis venenatis sollicitudin at ex. Pellentesque placerat iaculis eros, vel scelerisque dolor ullamcorper eu. Praesent porta justo at sapien pharetra auctor. Aliquam volutpat scelerisque vehicula. Donec commodo finibus facilisis. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Aenean convallis finibus nisi. Sed eget malesuada purus, id eleifend augue. Aenean malesuada libero eget enim fringilla efficitur. In tristique facilisis diam dignissim dapibus. Phasellus pellentesque, purus non suscipit elementum, nisi dui imperdiet tortor, ut tincidunt neque quam sit amet magna.\n\nSed in faucibus nisl, cursus faucibus elit. Etiam porta tortor sem, a lacinia neque mollis sed. Fusce vel mollis ipsum. Aliquam fringilla tortor non ornare dictum. Vivamus ac massa nec neque consectetur tristique. Vivamus vestibulum posuere porttitor. Aliquam porttitor pulvinar ipsum at posuere. Maecenas placerat, metus fermentum cursus aliquam, ante ex dictum neque, sit amet laoreet elit eros id erat. Integer venenatis sem vel ligula auctor facilisis. Vivamus eget nunc ut nulla accumsan semper a in leo. Phasellus a enim quis dolor efficitur ullamcorper. Suspendisse tellus tellus, facilisis ac tincidunt eu, blandit quis nisi.\n\nMorbi venenatis lacinia erat, vitae condimentum libero mattis vitae. Curabitur sed dapibus lectus. Vestibulum orci dui, sollicitudin quis enim et, tempus consequat nisl. Maecenas scelerisque ante quis aliquet lacinia. Vivamus sapien ante, fermentum et viverra tincidunt, blandit ut diam. Sed sodales nibh a nisi porttitor, vitae malesuada est faucibus. Nam placerat nec lectus a sollicitudin. Duis vel cursus turpis. Fusce dapibus molestie lacus vel lobortis. Donec id elit vel justo ultrices aliquam at eu ligula. Duis vehicula ullamcorper odio non maximus.\n\nPhasellus dui lorem, lobortis ut ultrices sit amet, consequat ut tellus. Etiam sit amet pharetra tortor. Donec pulvinar, eros id pretium feugiat, tortor ipsum dapibus mauris, et venenatis dolor dolor at dui. Pellentesque ac nibh eu justo venenatis hendrerit at sit amet enim. Mauris pretium turpis sed egestas aliquam. Donec nec lacus at est placerat commodo at sed nibh. Sed egestas mauris sit amet felis convallis lobortis.\n\nAenean quam purus, eleifend in pharetra id, sodales quis tortor. Nullam convallis enim vel ornare faucibus. In ex mauris, lacinia ac euismod a, consectetur aliquam arcu. Donec egestas hendrerit dolor at molestie. In id gravida metus, nec ultrices ex. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras dictum sapien quis tellus ullamcorper, eu faucibus ante interdum.\n\nNam eu eros a purus dictum pretium. Mauris faucibus nisi quis sapien maximus mattis. Curabitur tristique mollis dui vel semper. Etiam sollicitudin eros vitae posuere vestibulum. Nam erat neque, feugiat sed lorem ac, iaculis iaculis odio. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Sed in accumsan nulla, at tristique nulla. Cras id accumsan justo. In hac habitasse platea dictumst. Proin condimentum ligula ac molestie tempus. Phasellus lectus ex, condimentum quis suscipit in, tempus ac est. Interdum et malesuada fames ac ante ipsum primis in faucibus.\n\nSuspendisse ac nibh ac eros dignissim rutrum. Ut fringilla turpis dolor, gravida auctor metus euismod vitae. Quisque faucibus nisi non velit tempor condimentum faucibus sit amet justo. Proin aliquet pellentesque dictum. Suspendisse non condimentum ligula. Mauris varius ut neque non molestie. Duis et varius dui. Morbi mattis orci sit amet neque tincidunt, vitae pellentesque ex porta. Vestibulum ullamcorper ut elit eu placerat. Nulla in ullamcorper sem. Morbi sagittis egestas nisl eu molestie. Nunc pharetra laoreet mauris, vitae tristique arcu placerat eget. Orci varius natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.\n\nSed scelerisque augue id purus dignissim, quis euismod quam dignissim. Morbi ut dictum nunc. Suspendisse porttitor ante sit amet metus imperdiet, ut ultrices dui tristique. Praesent mattis odio arcu, sed maximus arcu viverra nec. Nullam non laoreet turpis. Aenean fringilla, quam non imperdiet pulvinar, nibh nisl efficitur eros, a interdum metus lacus vel turpis. Aliquam accumsan hendrerit finibus. Curabitur metus dui, fermentum eu interdum feugiat, mollis in nisl. Pellentesque mi odio, vehicula vel aliquet sed, faucibus eu elit. Fusce vitae finibus justo, ac iaculis turpis. Nam vel metus pellentesque, maximus nunc malesuada, consectetur lectus. In hac habitasse platea dictumst. Donec non lacus at dui congue rutrum. Mauris tristique turpis eros, ut placerat orci egestas non. Sed non libero vel nisi congue auctor.\n\nMauris orci ex, accumsan sit amet nunc in, facilisis lobortis lacus. Morbi tincidunt, nulla et placerat tempor, ante augue porta nunc, sit amet scelerisque sem augue fringilla leo. Sed at accumsan arcu, vitae sollicitudin augue. Aenean porta nisl sit amet tempor cursus. Donec in lobortis sapien, nec scelerisque risus. Aenean placerat ultrices metus, at maximus odio faucibus vehicula. Fusce commodo, justo sed vehicula posuere, sem mauris mollis tortor, a semper sapien ipsum vitae dolor. Donec eleifend velit eget pretium finibus. Nullam congue neque eu nunc congue, ut eleifend lectus tristique. Phasellus pretium diam tellus, porttitor finibus ipsum efficitur a.\n\nSuspendisse eu urna id sapien volutpat pharetra non id libero. Maecenas ac sapien purus. Integer a condimentum libero, at posuere sapien. Nunc in massa quis quam mollis tempor sit amet non nisl. Cras sagittis dapibus volutpat. Cras quis aliquet leo, aliquet pharetra risus. Vivamus viverra sem sagittis ex feugiat congue a blandit purus. Aliquam ullamcorper leo ut lectus porttitor, nec varius felis consectetur. Ut vestibulum tellus id sem sagittis rutrum. Orci varius natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Pellentesque eleifend fermentum lacinia. Pellentesque ut hendrerit augue.\n\nVivamus vulputate sagittis magna, et feugiat purus interdum at. Nulla tempus tempus dolor eget semper. Maecenas sit amet nisi ut felis lacinia luctus. Donec sed ipsum erat. Maecenas vitae laoreet orci. Cras sed dui lorem. Aenean luctus gravida condimentum. Etiam vitae ligula elit. Nulla id aliquet neque, vitae molestie sapien. Cras vulputate dapibus enim, eget sagittis metus faucibus in. Vestibulum eu nisl ipsum. Proin eget dolor vehicula, gravida metus id, viverra nunc. Quisque ut tortor id risus iaculis mattis nec id metus. Etiam viverra ultrices magna, et mollis lorem posuere vel. Aenean nec quam tempus, suscipit nisi a, fringilla ex. Praesent egestas, sem id posuere accumsan, mi enim interdum eros, et vulputate lacus ipsum quis nisl.\n\nSed eget egestas mi. Mauris elit tellus, accumsan non augue vitae, suscipit malesuada libero. Maecenas auctor pulvinar eros id posuere. Proin nisl sem, vestibulum at aliquet eget, rutrum blandit velit. Donec sit amet sem lacinia libero vehicula lacinia. Nulla id ultricies urna, varius ullamcorper quam. In placerat, eros sed maximus feugiat, neque neque mollis nisl, sed ultricies erat lectus et nisi. Cras venenatis quam et urna tincidunt hendrerit. Donec interdum, risus quis tincidunt tempus, augue felis porttitor lacus, in consectetur libero turpis tempor est. Pellentesque ut elit nibh. Etiam justo nunc, elementum vitae fermentum a, dapibus ut massa. Sed accumsan elementum orci, at volutpat purus vulputate a. Sed vitae dignissim nisl. Interdum et malesuada fames ac ante ipsum primis in faucibus.\n\nAliquam velit turpis, ullamcorper non imperdiet non, sollicitudin in orci. Orci varius natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Cras eros justo, pharetra non ultrices vel, volutpat vitae neque. Donec ultricies aliquam metus, ut aliquet risus. Curabitur et ex blandit, laoreet enim vel, iaculis arcu. Curabitur auctor ante felis, a vulputate quam viverra at. Maecenas imperdiet blandit lacinia. Praesent mi ex, vestibulum sed orci quis, pharetra porta eros. Ut id est a risus finibus laoreet. Etiam tempus orci nisl, non viverra libero cursus sed.\n\nPraesent vehicula molestie diam sed placerat. Nunc at eros diam. Nam neque nibh, laoreet sit amet velit eu, semper ultrices felis. Aliquam erat volutpat. Proin ac ullamcorper est. Quisque eget ligula id neque tempus dignissim non eget turpis. Aliquam ullamcorper augue ut lectus laoreet lobortis sed vitae lacus. Etiam ac lorem ipsum. Mauris vitae tempor libero. Curabitur varius ornare enim, nec vestibulum lectus vulputate sed. Vivamus venenatis purus quis nibh hendrerit bibendum. Maecenas vestibulum lacinia consectetur. Proin posuere tempor ante nec dignissim. Vivamus egestas tempor ante. Interdum et malesuada fames ac ante ipsum primis in faucibus.\n\nProin fermentum id enim in fermentum. Donec ut tellus vitae sem vulputate posuere. Sed vestibulum consectetur ex eget vestibulum. Maecenas vel dapibus risus. Quisque pulvinar pharetra eros vel vestibulum. Sed id sem molestie, accumsan sem at, venenatis massa. Proin elementum eu dui ac mollis.\n\nMauris odio ligula, tempus id dui in, viverra maximus sem. Suspendisse tempor congue sapien, eu malesuada dolor porttitor rhoncus. Morbi maximus risus nec odio laoreet tincidunt. In hac habitasse platea dictumst. Integer nisl magna, bibendum vel ex non, congue consequat elit. Proin sodales lectus tellus, vel viverra magna ultrices ac. Nunc quis urna elit. Etiam posuere mattis eros ut volutpat. Aliquam erat volutpat.\n\nPhasellus fringilla nunc ut nulla fermentum cursus. Fusce convallis diam vel magna imperdiet consequat. Sed blandit lobortis quam at fermentum. Nunc odio velit, scelerisque non vehicula sit amet, fermentum convallis justo. Cras in risus vel nibh ultricies molestie id quis arcu. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia curae; Vestibulum feugiat, eros sit amet iaculis sodales, elit orci dignissim purus, vel blandit risus velit ac lectus. Quisque commodo metus vel ligula consectetur, rhoncus maximus eros interdum. Phasellus aliquam imperdiet vehicula.\n\nInterdum et malesuada fames ac ante ipsum primis in faucibus. Etiam faucibus nisi eget porttitor egestas. Phasellus ullamcorper, metus non finibus eleifend, sapien nibh malesuada nunc, quis pulvinar diam ligula ut odio. Integer in nulla mollis, suscipit enim at, rutrum sem. Suspendisse eget convallis ex. Mauris non odio eu erat venenatis suscipit vel et turpis. Sed id auctor elit, eu molestie justo. Nam convallis fermentum odio sed egestas. Pellentesque ut augue id ex volutpat elementum. Aliquam scelerisque tellus vitae lectus pretium aliquet. Aenean sit amet lorem ac erat ornare luctus sit amet a massa. Sed a viverra ante, non pharetra massa. Integer imperdiet, mi id tincidunt posuere, nisi tortor laoreet felis, sed venenatis magna sapien non tellus. Nunc malesuada lacus vitae odio laoreet, ut venenatis nunc lacinia. Nunc mattis facilisis metus, eu laoreet lectus molestie non.\n\nMaecenas eget feugiat felis. Suspendisse ac metus ultrices, semper eros nec, maximus nibh. Proin euismod leo vitae tincidunt iaculis. Vestibulum risus sapien, tempor in ante eu, aliquam tristique risus. Etiam sed turpis sollicitudin, sagittis augue vitae, rhoncus arcu. Ut non semper nisl. Integer malesuada ultricies sagittis. Donec eget lorem molestie lorem sollicitudin vulputate sed vel nunc. Donec malesuada, arcu id tempus fringilla, eros ligula mollis mauris, fermentum consectetur augue odio ut tellus. Fusce vitae erat non felis tristique laoreet. Suspendisse vehicula sapien id ullamcorper efficitur. Nam elementum gravida diam nec lobortis. Aenean vehicula ante a tempus tristique. Sed aliquet convallis tellus nec faucibus. Praesent dictum tortor eu neque convallis venenatis. Proin auctor gravida sem, nec porttitor tellus luctus ut.\n\nNulla rutrum, ex vel tempor vulputate, nunc risus malesuada elit, ac efficitur nunc leo eget diam. Suspendisse sit amet odio posuere, volutpat enim ut, rhoncus augue. Proin congue elementum dolor, luctus placerat quam. Sed purus ligula, varius a viverra ut, maximus et magna. Donec enim dui, laoreet at rhoncus ac, venenatis ut nunc. Nulla facilisi. Aliquam vestibulum viverra elit. Aliquam imperdiet dui vel vestibulum elementum. In scelerisque maximus posuere. Suspendisse vel tellus elit. Proin eget mauris id lectus euismod cursus. Proin elementum tempor tellus, nec ullamcorper dui dapibus sed.\n\nMauris iaculis interdum dapibus. Vestibulum quis nunc in libero hendrerit tincidunt vel in augue. Praesent rhoncus massa nec turpis efficitur eleifend. Vestibulum cursus lacinia tellus at viverra. Vivamus egestas cursus lacus a congue. Aenean bibendum lacus tincidunt ultricies vehicula. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec eget neque in eros ultrices fringilla nec ut lacus. In non finibus metus. Praesent nec nulla sodales, tempus odio et, dignissim nibh.\n\nPellentesque ac consectetur arcu. Curabitur porta egestas posuere. Maecenas tristique enim ut faucibus luctus. Nulla vestibulum ante lectus. Nulla gravida accumsan odio, eget fermentum enim vestibulum at. In ante urna, fringilla vel consequat eget, dapibus ac nibh. Aliquam porttitor luctus fermentum. Suspendisse eu arcu a metus euismod vestibulum ut vitae leo. Ut at tincidunt est, eu blandit risus. Praesent ullamcorper dignissim purus vitae varius. Quisque sollicitudin felis nec lectus vulputate porttitor. Curabitur vestibulum nunc vitae posuere varius. Quisque libero lorem, suscipit id ante id, consequat finibus nunc. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Vivamus semper arcu at ultrices consectetur.\n\nNunc ornare viverra mi bibendum varius. Nunc ultricies mi a nibh blandit lobortis. Morbi nec sem molestie, interdum erat vel, efficitur nisl. In eros enim, posuere a libero eu, cursus ultrices mauris. Nulla dolor enim, semper eget diam ornare, dapibus fermentum nibh. Interdum et malesuada fames ac ante ipsum primis in faucibus. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Donec at sagittis neque, sit amet malesuada sapien. Nulla facilisi. Donec sit amet tincidunt mauris.\n\nPraesent at euismod ante. Morbi in vehicula ipsum, ac fermentum purus. Quisque non egestas nibh, non iaculis ligula. Vivamus gravida mauris tellus, vel sodales ligula congue ut. Etiam tempor congue velit condimentum tristique. Sed molestie finibus ex, eu pharetra orci lacinia vitae. Mauris vitae augue in mauris pulvinar mollis sed at velit. Etiam pharetra hendrerit ligula, in luctus sem sollicitudin et. Maecenas pellentesque ipsum sed ligula dapibus pellentesque et nec urna. Praesent aliquet metus est. Morbi turpis justo, convallis nec rutrum id, condimentum vel erat. Nulla iaculis mattis velit, eu ornare velit accumsan commodo. Ut dapibus orci ullamcorper magna dictum, sed tempus libero congue. Proin vel nisi turpis. Aliquam sit amet sem ac diam laoreet cursus ut id dui.\n\nVivamus ultrices est in ante lacinia euismod. Aliquam finibus lacinia imperdiet. Praesent eu pretium dolor, malesuada varius quam. Aenean vitae urna dui. Donec sed bibendum massa. Integer quis aliquet est. In hac habitasse platea dictumst.\n\nQuisque hendrerit tellus libero, eget convallis nibh efficitur in. In et libero suscipit, tempus justo et, condimentum arcu. Nunc ultricies cursus erat vitae lacinia. Suspendisse cursus, dui vel imperdiet egestas, mauris odio mollis ex, et eleifend nulla diam sit amet tellus. Fusce commodo magna ut odio rhoncus, id ultrices leo tempor. Sed a risus felis. Orci varius natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.\n\nNam ullamcorper erat ut aliquam vulputate. Nulla at erat neque. Suspendisse porttitor vulputate ligula vel rutrum. Donec et nunc a sem vehicula accumsan id condimentum orci. Orci varius natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Ut elementum lectus diam, in porttitor odio congue ut. Aenean libero sapien, vehicula quis vestibulum quis, vestibulum mattis risus. Phasellus porta tellus non rhoncus luctus. Sed pharetra luctus sem et tristique.\n\nPellentesque ornare ultricies dolor ut luctus. Quisque id congue nisi. Donec vitae elementum nulla. Vestibulum sed varius urna, ut ultricies nisl. Mauris sodales tellus eget ligula hendrerit facilisis. Mauris rutrum vestibulum dignissim. Vestibulum finibus egestas congue. Donec ac vestibulum leo, non condimentum libero. Sed augue eros, pharetra vulputate consectetur non, egestas et enim. Integer mattis orci consectetur facilisis dictum.\n\nCurabitur pellentesque lacus ut maximus mollis. Nam fermentum quam sollicitudin lacus gravida, non gravida metus venenatis. Donec pulvinar, lacus non ultrices consequat, velit dolor convallis orci, ut volutpat mi ex id mi. Praesent egestas augue vitae nisi tempor, vitae mollis ipsum blandit. Nam laoreet scelerisque arcu, at dignissim ante imperdiet ut. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Praesent sit amet urna bibendum, pretium eros vel, tristique sapien. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia curae; Cras at posuere tellus, nec ullamcorper lorem. Etiam sollicitudin eros luctus magna congue, quis laoreet lectus vulputate. Ut imperdiet cursus tortor eget sodales. Integer cursus nunc in vestibulum auctor. Phasellus congue sit amet dui sit amet gravida. Sed ultrices velit enim, ut blandit quam luctus a. In vitae gravida ante, non rhoncus diam.\n\nNulla facilisi. Cras auctor lacus tortor, a facilisis tortor porttitor ut. Nam nec augue vestibulum, scelerisque augue vitae, dignissim urna. Maecenas eget semper magna, nec ornare leo. Proin turpis enim, commodo ut ornare vitae, aliquam nec diam. Proin a turpis enim. Mauris volutpat purus quis magna bibendum aliquet non vitae ipsum. Maecenas at rutrum metus. Ut porta rutrum aliquet. Fusce sapien leo, ullamcorper vel pretium in, ornare vel dolor. In hac habitasse platea dictumst. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos.\n\nQuisque at varius purus, quis porttitor eros. In hac habitasse platea dictumst. Etiam mollis eu quam sit amet porttitor. Fusce vel elit faucibus, lacinia turpis vitae, dictum lacus. Sed posuere massa nec erat lobortis, in scelerisque orci pulvinar. Etiam ut egestas lectus, eget accumsan quam. Curabitur est dui, consectetur a rutrum a, pretium quis orci. Quisque fermentum sodales feugiat.\n\nFusce imperdiet dolor id urna congue lacinia. Nam eu erat enim. Praesent id lacinia mauris. Nullam eu quam ultricies, ultrices lacus eget, sagittis dolor. Morbi sed sagittis velit, eu porta erat. Fusce imperdiet enim eu aliquam iaculis. Integer sed vulputate dui, volutpat blandit eros. Morbi dapibus eros non euismod porttitor. Curabitur hendrerit, elit a tincidunt dapibus, dolor enim feugiat sapien, a maximus tortor eros ac tortor. Etiam vulputate eros sit amet ultricies viverra. In eu dapibus ex. Praesent sagittis eu lacus nec volutpat.\n\nNam sit amet pellentesque enim. Donec vel gravida augue. Nulla iaculis luctus neque, id iaculis nisl varius at. Morbi cursus elit sit amet leo commodo, et lobortis magna sagittis. Praesent convallis, dui sed accumsan porta, nibh augue bibendum mauris, vel posuere nulla elit a metus. Proin facilisis efficitur egestas. Etiam bibendum est elit, vel pretium turpis lobortis a. Aliquam rhoncus tortor orci, sed auctor lorem commodo quis. Integer condimentum ligula sed maximus venenatis. Maecenas et ornare massa. Suspendisse dictum eleifend fermentum. Sed eget lacus at dui aliquet porttitor eu a diam. Sed quis odio in felis facilisis luctus.\n\nDonec elementum luctus arcu id tempus. In a eros convallis, porta sapien vitae, faucibus velit. Nullam luctus tortor eget odio porta, sit amet laoreet libero dapibus. Ut scelerisque efficitur ante, sed auctor purus blandit in. Integer in tellus rutrum mi suscipit dapibus. Nullam blandit eleifend velit quis ornare. Vestibulum viverra nibh diam, facilisis faucibus tellus rutrum eget. Fusce a purus elementum, euismod lectus id, pellentesque libero.\n\nNam nec quam faucibus, vehicula sapien id, pellentesque arcu. Donec fermentum enim id odio accumsan ultrices. Maecenas venenatis sodales ex et efficitur. Sed non enim et turpis scelerisque hendrerit. Fusce ligula velit, faucibus eu turpis quis, commodo tempus velit. Maecenas auctor semper dolor, et placerat odio luctus sit amet. Sed dictum leo erat, in pretium dui convallis eget. Curabitur tempus aliquet velit eget vulputate. Nam interdum rhoncus tortor, sed vestibulum leo sollicitudin nec. Praesent id venenatis ligula, mattis ultricies tortor. Sed et tortor vitae lectus tincidunt rutrum vestibulum scelerisque quam. Mauris leo dui, gravida at ex non, mattis aliquet ex. Ut consequat convallis commodo. Aenean molestie feugiat augue sit amet tristique.\n\nVestibulum condimentum vitae neque quis faucibus. Ut nec pretium felis, a vestibulum purus. Phasellus vitae velit erat. Fusce dignissim aliquam interdum. Suspendisse ac sem enim. Quisque ultrices erat a velit sagittis, in euismod quam mattis. Orci varius natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Aliquam eu vehicula lectus. Phasellus imperdiet justo enim, sagittis venenatis sem cursus id. Aliquam erat volutpat. Nam rhoncus rhoncus consequat. Praesent sed mollis augue, at vestibulum erat.\n\nAenean vel erat orci. Quisque tincidunt erat quis placerat varius. Donec fringilla scelerisque sem, id placerat nulla rhoncus at. Nullam ut enim et mauris facilisis suscipit. Duis porta congue quam, congue rhoncus lorem ullamcorper vel. Fusce eget euismod quam, quis faucibus est. In hac habitasse platea dictumst. Sed sit amet ultricies mi. Integer ut ex quis nunc pulvinar pulvinar.\n\nMorbi sed lorem aliquam orci pretium sagittis. Nullam tincidunt magna non neque eleifend sollicitudin. Vestibulum ullamcorper justo non enim ultricies, ac sollicitudin turpis elementum. Morbi aliquam elit nec mi dictum, vehicula ultricies lorem egestas. In ultrices at ligula et pulvinar. Suspendisse euismod dolor metus, ut semper urna blandit vitae. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. In molestie nisl et lacus dignissim, vitae ultricies enim accumsan. Aenean eu dui magna. Nullam pulvinar placerat blandit. Sed ipsum risus, consectetur et risus in, ullamcorper porttitor ligula.\n\nDonec volutpat urna vel mi cursus, in dictum nulla consequat. Quisque commodo fringilla sapien quis pharetra. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin dignissim sollicitudin lorem, quis tristique arcu facilisis a. Suspendisse hendrerit nunc eu metus fermentum tincidunt. Nunc tincidunt ante ac quam finibus, non tempor massa auctor. Mauris facilisis condimentum suscipit. Nunc nulla tellus, accumsan in vehicula sodales, scelerisque vehicula ex. Proin ut nunc sed orci condimentum maximus et eu urna. Sed at bibendum velit, sit amet dapibus magna.\n\nNam sed neque sodales, laoreet metus vitae, convallis ex. Curabitur pulvinar convallis convallis. In rhoncus sapien mi, vitae mollis libero aliquam quis. Interdum et malesuada fames ac ante ipsum primis in faucibus. Proin ac lectus a justo viverra efficitur nec in ante. Maecenas purus mi, tincidunt et tortor vel, posuere facilisis ex. Ut et neque sit amet risus commodo finibus. Maecenas feugiat, magna sed efficitur condimentum, velit odio iaculis lorem, a pretium ante erat pulvinar lectus. Ut sit amet consectetur risus, ut cursus est. Nunc malesuada interdum molestie. Vivamus tempor diam et ante rutrum, a sagittis dui tristique. In nec cursus ante, at ultricies mi. Sed commodo volutpat pellentesque. Proin mauris lacus, convallis in imperdiet vitae, aliquam in ex. Duis metus lacus, porttitor ut orci sit amet, congue sodales neque. Vivamus gravida ut leo et aliquam.\n\nVestibulum auctor nibh ut mi vestibulum iaculis. Donec ac auctor libero. Fusce a dictum nisi. Cras a nunc eget diam elementum molestie. Nulla eget erat ut mi dapibus venenatis vel sed turpis. Donec finibus blandit ipsum a auctor. Lorem ipsum dolor sit amet, consectetur adipiscing elit.\n\nCurabitur lobortis quam eu interdum dignissim. In fringilla pretium ante, ut maximus est consequat nec. Etiam eget nulla ut tortor auctor luctus. Integer ultricies metus in arcu vulputate egestas. Cras scelerisque tempus tortor tempor viverra. Vivamus id consectetur lacus. Donec vehicula pharetra ligula in scelerisque. Vivamus diam urna, hendrerit id turpis non, venenatis porttitor massa. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent tempor hendrerit lorem. Ut nunc eros, consectetur in tortor sed, hendrerit volutpat neque. Donec nec ipsum luctus, pretium dui ac, imperdiet urna. Curabitur sed laoreet nulla, ac vehicula quam. Vestibulum tempus convallis ligula, rutrum porta quam eleifend eget. Interdum et malesuada fames ac ante ipsum primis in faucibus. Donec orci diam, cursus in euismod non, euismod at ligula.\n\nNam elit purus, pharetra id dapibus sit amet, imperdiet a nisl. Vivamus ut urna lobortis, gravida eros vel, rutrum mauris. Vestibulum pulvinar velit mauris, vel euismod tortor pulvinar a. Aliquam scelerisque mi sed sapien ultrices, in auctor lectus tincidunt. Praesent id cursus elit. Praesent metus felis, venenatis in blandit vel, varius in tortor. Vivamus sit amet leo luctus, pretium diam vitae, ultrices mi. Curabitur consectetur ullamcorper ligula, ac vestibulum sem iaculis ac. Integer ornare diam id hendrerit elementum. Aliquam consequat justo eget leo posuere ultricies. Praesent sit amet facilisis sapien. Pellentesque pellentesque condimentum nunc, et viverra purus blandit id. Nullam viverra fringilla imperdiet.\n\nPhasellus non arcu ut metus convallis tempor. Duis sed hendrerit orci, sed consectetur mi. Etiam consequat rhoncus placerat. Curabitur a est in nulla laoreet tempus. Curabitur sed sagittis nisi. Maecenas interdum urna magna, at pellentesque nisi aliquam id. Praesent sed volutpat arcu. Nulla dapibus nisl at mi accumsan porttitor. Pellentesque accumsan, velit sit amet facilisis consectetur, urna neque feugiat sapien, sed ultrices erat tellus iaculis ipsum. Duis volutpat libero vulputate ante malesuada finibus. Pellentesque luctus dictum malesuada. Praesent dapibus sapien sed quam ultrices pharetra. Duis nibh magna, tristique a congue in, aliquet et tellus. Nulla facilisi.\n\nProin eleifend gravida tristique. Vivamus tempus vel quam vulputate aliquam. Fusce venenatis mi vel lobortis pulvinar. Integer mollis eu nisl sit amet finibus. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia curae; Suspendisse sodales euismod pretium. Nulla luctus vestibulum ipsum, hendrerit vehicula odio laoreet vel. Aenean eleifend justo id nisl gravida vehicula. Duis imperdiet feugiat nisi. Suspendisse ac laoreet enim, eu euismod est. Proin at neque id ante convallis vehicula.\n\nIn non tortor ut ipsum vulputate cursus at quis felis. Aliquam ex urna, consequat ultrices elementum in, semper in orci. Quisque sit amet enim et enim vehicula ultricies eget nec ligula. Nulla sit amet rhoncus est, sed scelerisque nisl. Phasellus at dui at nibh tempor viverra eu convallis elit. Duis scelerisque dapibus arcu at mollis. Donec mollis id dolor ut ornare. Quisque euismod elit accumsan, interdum felis ac, mattis dui. Integer faucibus tincidunt est, id condimentum nunc tincidunt eu. Vestibulum nec neque sit amet lorem vehicula accumsan. Nunc ex massa, posuere eu urna a, hendrerit tempus nibh. Suspendisse blandit ante a dolor vestibulum, at placerat magna sagittis. Vivamus tristique, nisl quis ultrices congue, arcu tellus semper metus, at lacinia felis sapien id ipsum. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia curae; Pellentesque ac ornare elit, sit amet tempus nisi.\n\nAenean sit amet enim quis sem varius sodales. Sed eu consequat libero. Fusce vitae feugiat sem. Donec mauris eros, aliquet quis mi sed, vulputate suscipit diam. Duis sed porta lacus. Etiam in neque tellus. Nulla pretium, quam vel aliquam convallis, risus ex fermentum massa, sed aliquet quam sapien et lorem. Integer lobortis, arcu ut vestibulum cursus, lacus lacus dapibus justo, in vestibulum magna tellus sed mauris. Aliquam convallis lectus sed ligula semper maximus non sit amet leo. Vestibulum molestie id turpis vitae tempor. Suspendisse vitae hendrerit felis. Ut tincidunt aliquam nunc ac porttitor. In ac mauris sit amet ligula pellentesque efficitur ut sit amet dolor.\n\nNam vestibulum ut odio feugiat aliquet. Phasellus mollis egestas mollis. Ut vestibulum interdum arcu nec dictum. In sit amet tempus urna, non accumsan justo. Donec iaculis placerat urna at dictum. Praesent suscipit dui quis sem vulputate, sit amet accumsan quam feugiat. Nam non justo sapien.\n\nNam cursus odio sed felis auctor, a cursus nisl venenatis. Praesent ut sapien tempus, ornare arcu eget, sagittis ipsum. Vestibulum efficitur dignissim lorem. Nam dapibus, elit quis tincidunt commodo, justo turpis sodales nunc, sed ullamcorper ligula mauris ac lacus. Nullam tristique pulvinar convallis. Sed eget nulla eu massa tincidunt rhoncus. Sed lobortis gravida ipsum dictum scelerisque.\n\nCurabitur accumsan varius sem, id porta arcu finibus nec. Fusce ultricies luctus risus, a pellentesque purus porttitor eu. Maecenas ac egestas eros, ut pulvinar turpis. Aliquam commodo a nibh ac condimentum. Nunc vitae dictum erat. Nulla auctor, orci non blandit blandit, felis odio tristique felis, eu auctor diam odio nec felis. Proin et faucibus ante, sit amet imperdiet mi. Nullam at lacus et mauris auctor egestas eget at leo. Mauris placerat magna eu arcu tincidunt viverra. Nunc tincidunt consectetur nisl, sit amet fringilla dui volutpat ac. Praesent vestibulum, quam a fermentum facilisis, sapien turpis posuere ipsum, suscipit laoreet orci est quis nisl. Nullam at nunc mollis, mattis magna et, viverra est.\n\nAenean bibendum arcu vitae congue aliquet. Aenean ultricies non lorem at dignissim. Donec dignissim mi est, vitae tristique magna blandit gravida. Pellentesque sit amet rhoncus risus. Quisque rutrum scelerisque sapien non ullamcorper. Aliquam in mauris elit. Vivamus sit amet sollicitudin risus. In fringilla sapien at nunc volutpat sollicitudin. Praesent elit diam, porttitor ac tempor et, faucibus in diam. Phasellus vulputate nulla ut erat porta, et blandit lorem aliquet. Pellentesque auctor, risus at porta tristique, libero nisl maximus lorem, sit amet lacinia est dolor non ante. Sed pretium magna eget est hendrerit ultrices.\n\nInteger sit amet rutrum augue, id laoreet dui. Duis tempor, quam ut varius sodales, mi risus faucibus arcu, eget ornare elit lacus a mauris. Curabitur molestie non ligula non pellentesque. Integer finibus felis et sem congue, nec porttitor nisi vulputate. Maecenas viverra orci nunc, sit amet eleifend nunc hendrerit in. Mauris non dui non ipsum iaculis egestas in et lacus. Duis odio magna, elementum non rhoncus ut, lobortis auctor ipsum. Suspendisse congue ac quam a porttitor. Cras mollis euismod pellentesque. Nunc mollis, dui sit amet fermentum vehicula, nulla diam feugiat dolor, quis porta tellus magna in orci. Integer tincidunt feugiat nunc a euismod. Phasellus ultrices est sit amet semper sagittis.\n\nNullam scelerisque vehicula eros ut tristique. Cras euismod velit eu leo dictum dapibus. Proin pharetra elit augue, et aliquam erat fringilla pretium. Cras sed dictum ipsum. Suspendisse fermentum vestibulum mi eu hendrerit. Proin nisl ante, dapibus bibendum libero sed, egestas sagittis sapien. Quisque sem lacus, sagittis et nibh eu, faucibus consequat felis. Aenean laoreet ultricies viverra. In eu pellentesque lectus, eget tristique felis. Quisque egestas ultricies tincidunt. Sed tellus tortor, gravida nec ante sodales, efficitur sollicitudin nibh. Aenean vehicula convallis lacus. Integer hendrerit nisi dolor, ut lacinia erat fringilla ut.\n\nNunc eget eros viverra, feugiat mauris sit amet, tincidunt lectus. Nam mollis luctus ante, et elementum ante aliquet vitae. In quis venenatis magna. Fusce ac consectetur mi. Phasellus bibendum rhoncus risus id finibus. Proin vel efficitur magna. Praesent varius ex vitae dolor imperdiet, nec dignissim massa viverra. Quisque mattis pulvinar mi, sed interdum odio elementum a. Vestibulum semper lobortis justo. Cras eros dolor, mattis ut fringilla in, vulputate sit amet metus.\n\nSed maximus id quam consequat blandit. Vestibulum porttitor elit a varius semper. Quisque convallis semper nisl a tristique. Nam porttitor lobortis scelerisque. Etiam finibus aliquam arcu, sed aliquam nisl hendrerit in. Etiam lacinia blandit interdum. Sed pellentesque nisl id turpis tempus, in tincidunt elit convallis. Morbi nec leo eget tortor ultricies fermentum et a enim. In vestibulum nunc magna, ac consectetur diam sagittis in. Vivamus suscipit sapien quis luctus euismod. Cras vel fermentum libero.\n\nMorbi mauris lacus, egestas eu purus sit amet, gravida lobortis mauris. Donec molestie sagittis aliquam. Ut quis urna nunc. Quisque luctus sem enim, finibus pharetra urna vulputate a. Nulla pretium faucibus cursus. Quisque finibus interdum enim sodales venenatis. Duis eget rutrum elit, et imperdiet sapien. Duis ac elit a sem viverra rhoncus. Nulla egestas vulputate maximus. Praesent et facilisis enim. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Cras fermentum viverra orci, vel consectetur dolor pulvinar vitae. Mauris consectetur ullamcorper urna, quis dictum nunc lacinia ut. Vivamus non lectus ut augue pellentesque ornare at ut ligula. Praesent elementum augue quis erat pretium, eget vestibulum lectus cursus. Donec ultrices dapibus tempus.\n\nDonec sodales imperdiet tortor, non molestie odio facilisis et. Suspendisse potenti. Integer porta ligula at urna volutpat bibendum. Curabitur ac sapien quis risus tincidunt laoreet. Praesent vulputate, nibh vitae feugiat volutpat, enim urna ultricies purus, vitae mollis augue diam vitae mauris. Fusce condimentum ornare molestie. Mauris tempor vel quam pretium finibus. Suspendisse feugiat turpis quam, non interdum urna pellentesque vel. Morbi consectetur erat eros, non tempus sapien laoreet vitae. Mauris convallis nulla suscipit lectus vestibulum laoreet.\n\nQuisque consectetur sit amet mauris gravida luctus. Duis ultricies aliquam ipsum, sit amet sollicitudin turpis semper a. Phasellus nisi massa, egestas sed sollicitudin quis, elementum vel nisl. Donec consectetur, augue ut hendrerit imperdiet, quam mi aliquam felis, at laoreet ante magna eu nisl. Maecenas ullamcorper, ante at iaculis sodales, libero elit efficitur nulla, ac tincidunt purus elit ac dui. Cras sit amet sagittis eros. Nulla vestibulum maximus lacus, in cursus augue fringilla quis. Vestibulum fermentum mollis dui, vel posuere tortor porttitor at. Suspendisse id purus tincidunt, vestibulum sapien non, imperdiet est. Proin consectetur nulla eget cursus facilisis. Vivamus a auctor mi, sit amet tempor velit. Maecenas sed viverra sapien. Nulla et nibh sodales, egestas mauris vitae, dapibus libero. Duis faucibus mauris eu nisi vulputate, nec vehicula enim maximus. In tempus erat quis nunc dapibus pharetra. Suspendisse vitae tortor ac lorem lobortis iaculis sit amet a est.\n\nQuisque at ex ex. Curabitur sapien est, finibus eu urna quis, laoreet convallis libero. Donec tincidunt vestibulum erat. Mauris a est lorem. Vivamus pharetra nibh eget ipsum semper, ut consequat turpis interdum. Nulla congue enim ut lacinia sodales. Praesent vehicula hendrerit tempus. Suspendisse sagittis arcu urna, eget tempor lectus tincidunt id. Proin ut ultrices nisl. Pellentesque ultrices posuere libero, in venenatis diam congue quis.\n\nMorbi at sodales diam. In pretium nisl vel est interdum interdum. Cras eu mattis ante. Ut maximus pharetra eros ac commodo. In elit nisi, consectetur a venenatis non, varius id ante. Nulla elementum lectus vel dignissim laoreet. Nam volutpat finibus tempor. Integer a dolor vehicula ex consectetur volutpat non ut mi. Praesent non vehicula nisi. Proin nec magna ullamcorper, egestas ante eget, porttitor tortor. Sed odio ligula, viverra sit amet malesuada nec, rhoncus ac ligula. Vivamus luctus nibh efficitur erat consequat, in vestibulum magna pharetra. Etiam tincidunt nisl nec sapien iaculis facilisis. Phasellus vulputate fermentum quam, non faucibus massa tristique ac.\n\nProin nibh ex, sagittis et sapien in, cursus varius tortor. Phasellus gravida, eros nec hendrerit dictum, libero nisl consequat odio, aliquam sodales velit magna vitae enim. Suspendisse quam tellus, sollicitudin id elit vitae, sodales volutpat enim. Aliquam erat volutpat. Nullam auctor sed leo et posuere. Curabitur cursus enim mollis mauris ullamcorper, nec volutpat augue dictum. Aenean non eros velit. Quisque luctus nisi sed sodales feugiat. Cras cursus ipsum eget libero faucibus, pellentesque porta erat viverra. Maecenas fringilla, tellus id varius eleifend, tortor eros efficitur mi, id aliquet mauris quam id urna. Quisque ex lectus, molestie in orci vitae, pulvinar viverra magna. Morbi dictum ut orci vel fermentum. Sed venenatis turpis nisi, vitae tristique velit ornare sed.\n\nAliquam auctor maximus elit nec semper. Mauris tincidunt purus mi, non consequat magna mollis in. Aenean fringilla risus dignissim sagittis accumsan. Morbi scelerisque id quam quis ultrices. Fusce eu ligula pulvinar lorem aliquam venenatis. Curabitur vitae elit eget mi auctor cursus. Suspendisse in sollicitudin sem, sed suscipit urna. Donec ut imperdiet quam, ac mattis nibh. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Nunc et neque a nisl molestie volutpat. Duis porta erat eget luctus vulputate. Etiam sed interdum nulla, vel aliquet felis. Pellentesque molestie et enim eget lacinia. Maecenas sagittis sed erat ut lobortis.\n\nNunc eget euismod lorem. Quisque molestie turpis ac odio finibus dapibus. Integer placerat varius nunc, eu vestibulum ex accumsan id. Nulla convallis vel lacus ac viverra. Praesent gravida ultricies dolor, quis cursus lectus accumsan et. Nullam posuere quam vitae dolor feugiat, elementum viverra est pretium. Aliquam erat volutpat. Integer ut arcu at leo tempor pulvinar. Suspendisse semper, ligula at aliquam porttitor, diam arcu rutrum lacus, eu cursus odio ligula cursus diam. Interdum et malesuada fames ac ante ipsum primis in faucibus. Duis pharetra, lectus at pretium egestas, urna libero faucibus ex, ut viverra sem ipsum eu ante. Nunc vel consequat erat. Morbi turpis metus, gravida ac nisi non, fermentum dapibus nisi. Curabitur gravida dignissim odio, eget viverra lectus cursus quis. Sed at nibh laoreet, gravida tellus id, viverra libero. Cras dignissim porttitor mauris, vel posuere lectus laoreet at.\n\nMauris sed felis faucibus, bibendum diam vel, laoreet lacus. Duis commodo rhoncus libero ut placerat. Curabitur auctor, elit vitae eleifend pharetra, lorem neque auctor nulla, non hendrerit libero mauris sit amet lectus. Nam mattis semper diam, eu ullamcorper justo sollicitudin sed. Ut tristique finibus eros, quis mattis elit tempor a. Vivamus massa sem, rutrum id purus nec, aliquam vulputate arcu. Nunc maximus quis ligula vitae cursus. Vestibulum ut pulvinar erat. Morbi risus dui, tempus sit amet lorem vitae, luctus porttitor ipsum. Vivamus egestas velit neque, in molestie elit placerat in. Vestibulum nec nunc ac nulla volutpat scelerisque. Donec at consequat sem, ac pharetra lorem. Nulla nec lacinia diam, at dignissim magna. Donec non enim in nulla congue condimentum. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia curae;\n\nDuis luctus leo augue, at tincidunt nibh lobortis vel. Cras iaculis, metus euismod lacinia semper, purus sem dictum mauris, nec condimentum leo purus nec magna. Vestibulum a purus sed nulla imperdiet pretium. Nunc eleifend semper facilisis. Quisque sed ipsum imperdiet, molestie nibh at, laoreet turpis. Aenean enim erat, ultricies et aliquet eu, finibus et risus. Aliquam erat volutpat. Quisque malesuada enim lorem, non consequat nisi sagittis quis.\n\nAenean aliquam, augue quis fermentum efficitur, nisl dolor mollis ipsum, eget gravida ipsum sem in nulla. Nullam varius, ante in ullamcorper rhoncus, ligula augue auctor lectus, in laoreet ex tortor nec ante. Sed ac imperdiet mi, nec commodo mi. Donec ullamcorper viverra purus, vitae vehicula elit lobortis ac. Aliquam imperdiet ex et eros auctor, quis aliquet neque pharetra. Suspendisse ullamcorper nibh quis orci pharetra ultrices. Quisque convallis risus sed mollis malesuada. Duis ut elementum sapien. Nunc et ipsum porttitor, molestie nisi non, interdum mauris. Praesent tincidunt dolor sit amet condimentum euismod. Sed euismod aliquam lacus. Suspendisse maximus ligula quis sapien scelerisque, eu vulputate libero euismod.\n\nVivamus quis lorem ut tortor tristique tristique. Etiam a suscipit odio. Donec sit amet nulla malesuada, rhoncus metus quis, condimentum lacus. Phasellus ut velit nibh. Donec vel odio fermentum sem consequat viverra. Integer tincidunt eleifend nulla, non elementum turpis viverra vel. Mauris eu mi ut nibh sollicitudin dictum. Phasellus viverra rutrum arcu sed suscipit. Morbi nec congue dolor, in fringilla sem. Nam vitae finibus augue, eget dapibus leo. Suspendisse sit amet efficitur nisi. Aenean nec purus fringilla, porttitor dolor tincidunt, pulvinar nisl. Donec at rhoncus sem, non facilisis elit. Proin odio arcu, fringilla at sem viverra, malesuada maximus enim. Nullam cursus faucibus elit, dignissim laoreet nisl. Donec vitae tellus massa.\n\nInteger eu ex ac mi efficitur venenatis. Maecenas nec nisl et neque dictum convallis nec id velit. Donec ultricies ut elit venenatis dictum. Aenean eget porttitor tortor, vitae venenatis ipsum. Fusce sed leo consectetur, pellentesque nisl et, laoreet ipsum. Pellentesque sed ligula accumsan, imperdiet libero a, lacinia felis. Quisque eget neque non odio sagittis lobortis eget a nunc.\n\nNunc maximus risus mauris, a faucibus velit varius quis. Orci varius natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Ut finibus magna sed dui accumsan, ut facilisis magna convallis. In tempus ante a justo placerat iaculis. Donec efficitur mauris est, non mattis dui ullamcorper at. Suspendisse mi mauris, iaculis non nibh non, consequat aliquam justo. Donec ac tortor turpis.\n\nMorbi viverra tempus augue, hendrerit mollis lorem vulputate sed. Interdum et malesuada fames ac ante ipsum primis in faucibus. Aenean volutpat aliquet libero ut tempus. Donec facilisis efficitur mi, a pellentesque nisi faucibus at. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia curae; Pellentesque placerat nisi vel dui iaculis, in euismod lorem lacinia. Aliquam tempor turpis velit, in scelerisque ante vulputate in. Fusce ultrices dui enim, nec lacinia elit ornare vel. Nullam dignissim lobortis blandit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. In aliquet, nunc non molestie aliquet, orci nisi luctus urna, quis tristique urna diam ut enim. Pellentesque vitae urna ac erat mattis sodales.\n\nPellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Quisque varius convallis felis eget lacinia. Suspendisse potenti. Pellentesque in pulvinar ipsum, molestie volutpat nulla. Aliquam ut leo arcu. In sit amet vehicula nulla, vel vulputate orci. Vestibulum ligula orci, dictum at ipsum ut, luctus varius metus. Orci varius natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Phasellus pulvinar neque at scelerisque viverra. Quisque consectetur risus vel augue tincidunt aliquam.\n\nNam augue sem, eleifend sit amet nibh non, condimentum hendrerit ligula. Quisque pretium congue libero, id cursus nisi finibus tempor. Sed venenatis fermentum mauris, non sodales nisi fermentum sed. Duis sagittis posuere tempus. Pellentesque justo diam, convallis eget pharetra id, commodo ac tellus. Ut ipsum nulla, vulputate eu urna eu, mattis pellentesque neque. Ut lobortis faucibus diam et rhoncus. Suspendisse dignissim vulputate nunc vitae maximus. Nam orci ex, tincidunt in semper vel, tempus sit amet nisl. Morbi accumsan posuere turpis id vestibulum.\n\nVivamus magna felis, faucibus a posuere in, bibendum eu est. Donec pretium velit magna, id viverra magna malesuada at. Vivamus aliquam enim ante, eget fermentum nibh elementum id. In hac habitasse platea dictumst. In aliquam vel odio id mollis. Curabitur elementum, justo ac auctor scelerisque, nisi risus tincidunt lectus, vitae porttitor nisl mi ut libero. Fusce sodales, tortor et tincidunt pellentesque, enim nisl pulvinar tellus, sed aliquam enim tortor sit amet ex. Praesent leo quam, mollis non nibh eu, scelerisque molestie nibh. Aliquam erat volutpat. Mauris vehicula, dolor non mattis fringilla, neque orci porta turpis, a sagittis lacus massa sed quam. Donec eget ullamcorper urna.\n\nDonec nulla eros, consequat eu ultricies at, cursus quis nulla. Donec nec tortor nisi. Donec lacus justo, placerat id magna dictum, lacinia eleifend justo. Suspendisse congue urna a dui viverra, et pellentesque neque sagittis. Morbi vitae lorem eget felis laoreet suscipit ac fringilla nisi. Donec consequat facilisis bibendum. Interdum et malesuada fames ac ante ipsum primis in faucibus. Aenean bibendum arcu felis, nec faucibus nulla viverra non.\n\nNulla ac tellus nibh. Phasellus ut purus id nisi pretium facilisis non quis nunc. Suspendisse lobortis lorem libero, et iaculis urna sodales congue. Aenean vulputate nulla ut neque ultrices, non faucibus massa dictum. Duis ac augue in dolor blandit posuere ac at neque. Mauris ac varius nisi, sed pellentesque purus. Integer vel eleifend nibh, eu lobortis turpis. Donec quis mauris molestie, sagittis lacus eget, semper neque. Fusce eu augue non nulla pellentesque dictum bibendum in ligula. Praesent eget ligula mi. Curabitur eget feugiat est. Fusce in massa et tortor convallis consequat id vitae dui. Vestibulum ac purus ipsum. Vestibulum vehicula, mauris sit amet volutpat condimentum, ipsum neque dictum libero, ac commodo ex est a erat. Morbi sed metus et risus accumsan maximus.\n\nDonec ex nunc, pharetra eu erat eu, laoreet bibendum augue. Integer vel enim tristique, mollis metus at, laoreet quam. Orci varius natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Sed semper dui sit amet diam interdum aliquet. Duis a ante vel nisl aliquet sodales id ac diam. Cras ut semper quam. Donec condimentum, ante in aliquam hendrerit, urna neque hendrerit urna, eu consectetur ipsum mauris ac eros. Maecenas scelerisque gravida nunc, vitae pellentesque neque lacinia non. Vestibulum in lacus vel metus pellentesque finibus a vita","","2025-05-12 09:06:13","2025-05-12 14:10:47","");
INSERT INTO contracts VALUES("4","ca caccacacc","1","2","2","2025-05-12","cAAC CACAC","","2025-05-12 13:11:19","2025-05-12 13:11:19","[\"contracts\\/Fyki4iqmsVAQeL6jtBwfvQqEqDLZOfPNLNWFHfQM.pdf\"]");
INSERT INTO contracts VALUES("5","dbbdbb","1","2","2","0000-00-00","","","2025-05-12 13:27:57","2025-05-12 13:27:57","");
INSERT INTO contracts VALUES("6","test11","1","2","13","2025-05-20","","","2025-05-20 07:14:27","2025-05-22 12:20:49","[\"contracts\\/OBBlbLm0k5GBqfuR1LiWMyoSbW1XObELHLswIHNH.pdf\"]");
INSERT INTO contracts VALUES("7","ء ء","1","2","1","2025-05-21","ء ؤللل","","2025-05-21 08:17:09","2025-05-21 08:17:09","");
INSERT INTO contracts VALUES("8","عقد مشروعي","1","2","8","2025-05-12","","2025-05-21 09:49:05","2025-05-21 09:48:34","2025-05-21 09:49:05","");
INSERT INTO contracts VALUES("9","qwe","1","2","1","2025-05-16","","","2025-05-22 12:59:44","2025-05-22 12:59:44","");
INSERT INTO contracts VALUES("10","qwe","1","2","1","2025-05-30","","","2025-05-22 13:00:00","2025-05-22 13:00:00","");



DROP TABLE customer_calls;

CREATE TABLE `customer_calls` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `subject` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `files` varchar(255) DEFAULT NULL,
  `stop_project` tinyint(4) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `project_id` int(10) unsigned DEFAULT NULL,
  `customer` varchar(255) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `date_of_call` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO customer_calls VALUES("1","مخاطبة العميل رقم 1 لفيلا العثيم","مخاطبة العميل رقم 1 لفيلا العثيم \nمخاطبة العميل رقم 1 لفيلا العثيم","","0","4","1","","2025-05-19 15:55:02","2025-01-27 09:30:36","2025-05-19 15:55:02","");
INSERT INTO customer_calls VALUES("2","خترحتتح. كت ك","متؤخااؤغؤ","[\"customercalls\\/nZztwMlY0iG8ITjrWZm8wDGhyMraHBJZWOx5B28H.jpg\"]","0","2","1","","","2025-05-07 10:51:35","2025-05-07 10:51:35","");
INSERT INTO customer_calls VALUES("3","تمرتكر كت","حنرتكتوكركتركترىتكىطرطنىىطنىطىنىطنىنج","[\"customercalls\\/ByXIKyokRcwx5F9SvsXZG1vaqeAsfhvY3LRHpEwW.jpg\"]","0","2","1","","","2025-05-07 10:52:43","2025-05-07 10:52:43","");
INSERT INTO customer_calls VALUES("4","qwe","qwe","","0","2","1","","","2025-05-11 10:03:31","2025-05-11 10:03:31","");
INSERT INTO customer_calls VALUES("5","qwe","qwe","","0","2","2","","","2025-05-12 07:34:36","2025-05-12 07:34:36","");
INSERT INTO customer_calls VALUES("6","qwe","qwe","","1","2","8","","","2025-05-13 09:11:34","2025-05-13 22:20:41","");
INSERT INTO customer_calls VALUES("7","فثسف","ببيش","","0","2","2","","","2025-05-13 10:36:03","2025-05-13 10:36:25","");
INSERT INTO customer_calls VALUES("8","hghghghgh","ghhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh","[\"customercalls\\/4iLMFpF6QIhlH5AekSFmYkDOdlcQjdWjIVc5YiEo.pdf\"]","0","2","13","","","2025-05-20 07:19:36","2025-05-20 07:21:47","2025-05-20 02:19:00");
INSERT INTO customer_calls VALUES("9","123","123","","1","2","1","","","2025-05-28 13:19:53","2025-05-28 13:19:53","2025-05-28 13:19:00");



DROP TABLE customer_contracts;

CREATE TABLE `customer_contracts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `customer_name` varchar(255) NOT NULL,
  `date` date NOT NULL,
  `cost` int(11) NOT NULL,
  `description` text NOT NULL,
  `project` int(10) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `files` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO customer_contracts VALUES("1","qwe","2025-05-06","2147483647","qwe","1","","2025-05-11 09:18:49","2025-05-11 09:20:27","");
INSERT INTO customer_contracts VALUES("2","Bora3y","2025-05-31","123","123","1","","2025-05-11 09:19:47","2025-05-11 09:19:47","");
INSERT INTO customer_contracts VALUES("3","qwe","2025-06-06","132","qwe","1","","2025-05-11 09:23:01","2025-05-11 09:23:01","");
INSERT INTO customer_contracts VALUES("4","qwe","2025-05-31","132","qwe","1","","2025-05-11 10:07:29","2025-05-11 10:08:01","[\"customercontracts\\/REQLFTFtwZwQylhLMv6UEcZ91UBuWa3eMofa8CiL.png\"]");
INSERT INTO customer_contracts VALUES("5","down","2025-05-10","123465","qwe","1","","2025-05-11 10:22:24","2025-05-11 10:22:24","[\"customercontracts\\/OlnTNchZ08mIFe702ESdTCtBo5Uu46TYI8YZPZaq.mp4\"]");
INSERT INTO customer_contracts VALUES("6","الامير امير","0023-12-31","123","123","0","","2025-05-12 10:14:12","2025-05-12 10:14:12","");
INSERT INTO customer_contracts VALUES("7","ضصث","2025-05-15","123","123","2","2025-05-19 06:53:39","2025-05-13 07:24:48","2025-05-19 06:53:39","");



DROP TABLE customers;

CREATE TABLE `customers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `image` varchar(255) 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=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO customers VALUES("1","ahmed amin","rbn8YIbXnyHnB0ISoqHZWlPaicSxJPeiw4GqVpYq.png","","2024-11-02 23:52:32","2024-11-02 23:59:26");



DROP TABLE evaluations;

CREATE TABLE `evaluations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `description` text NOT NULL,
  `project_id` int(10) unsigned NOT NULL,
  `user_id` int(11) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO evaluations VALUES("1","أول تقييم\nلفيلا\nالعثيم","1","4","","2025-01-27 09:26:04","2025-01-27 09:26:04");
INSERT INTO evaluations VALUES("2","غرعررعرىع","1","2","","2025-05-07 08:31:09","2025-05-07 08:31:09");
INSERT INTO evaluations VALUES("3","qwe","1","2","","2025-05-11 09:54:40","2025-05-11 09:54:40");
INSERT INTO evaluations VALUES("4","qwe","1","2","","2025-05-11 09:54:45","2025-05-11 09:54:45");
INSERT INTO evaluations VALUES("5","qweqwe","1","2","","2025-05-11 10:06:13","2025-05-11 10:06:13");
INSERT INTO evaluations VALUES("6","szvvvzfvdvf","2","2","","2025-05-12 09:30:49","2025-05-12 09:30:49");
INSERT INTO evaluations VALUES("7","شؤ}}}ؤ","2","2","","2025-05-12 10:38:05","2025-05-19 11:05:00");
INSERT INTO evaluations VALUES("8","صرصرف","7","2","2025-05-19 06:01:27","2025-05-13 10:37:28","2025-05-19 06:01:27");
INSERT INTO evaluations VALUES("9","s","1","2","","2025-05-19 09:34:44","2025-05-19 09:34:44");
INSERT INTO evaluations VALUES("10","sadasd","1","2","","2025-05-19 09:34:59","2025-05-19 09:34:59");
INSERT INTO evaluations VALUES("11","hfdgdfgdgdgdfgdfgdf","13","2","","2025-05-20 07:23:22","2025-05-20 07:23:22");



DROP TABLE exchanges;

CREATE TABLE `exchanges` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `user_id` int(11) NOT NULL,
  `cost` int(11) NOT NULL,
  `contract_id` varchar(255) NOT NULL,
  `project_id` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `step_id` bigint(20) unsigned DEFAULT NULL,
  `procedure_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO exchanges VALUES("1","الذهبية لحلول التنظيف","4","4500","0","1","تنظيف","","2025-05-11 23:56:26","2025-01-27 07:00:23","2025-05-11 23:56:26","2","1");
INSERT INTO exchanges VALUES("2","عثمان","2","300000","1","2","","","2025-05-12 07:33:54","2025-05-12 00:21:54","2025-05-12 07:33:54","8","2");
INSERT INTO exchanges VALUES("3","0","2","1","0","4","","","","2025-05-12 00:25:48","2025-05-12 00:25:48","2","1");
INSERT INTO exchanges VALUES("4","تست 1053","2","10123","1","2","سبااااااك","","2025-05-12 08:18:20","2025-05-12 07:53:44","2025-05-12 08:18:20","11","4");
INSERT INTO exchanges VALUES("5","test111","2","20000","0","2","nfcxfxncfxfcnfcnfcccn","","2025-05-28 14:50:34","2025-05-12 08:28:09","2025-05-28 14:50:34","4","2");
INSERT INTO exchanges VALUES("6","vzdvdv","2","10000","0","2","","","2025-05-13 10:34:37","2025-05-12 08:30:43","2025-05-13 10:34:37","10","4");
INSERT INTO exchanges VALUES("7","فثسف1","2","10000","3","2","الاالااعلاالااةاةاةلالااة","q1Dgjay6nfHuN7mQopLZhuN1GunPvnvIy7RHXAY9.png","2025-05-28 15:23:45","2025-05-12 11:28:35","2025-05-28 15:23:45","4","2");
INSERT INTO exchanges VALUES("8","هعمJ CJKCN JKBK","2","10000","3","2","X Z Z X.KNZ XJZNX","mLhn6IUSXl3o08nOhR4IFL6Wwhmd43rE76dvu7QI.png","","2025-05-12 11:29:42","2025-05-12 11:29:42","4","2");
INSERT INTO exchanges VALUES("9","عثمان","2","300000","2","2","","","2025-05-12 14:05:10","2025-05-12 14:04:57","2025-05-12 14:05:10","11","4");
INSERT INTO exchanges VALUES("10","عثمان","2","400000","1","2","","","","2025-05-13 08:29:40","2025-05-13 08:29:40","5","2");
INSERT INTO exchanges VALUES("11","سررققررسسر","2","30000","3","7","لاسيلاسقفقسففققسل","B7U9rP6K4eTpfKCBXveBREy9ALAvpdLUOhTqK2f1.png","","2025-05-13 10:50:42","2025-05-13 10:50:42","2","1");
INSERT INTO exchanges VALUES("12","123","2","123","1","8","","","2025-05-19 09:01:23","2025-05-13 12:12:17","2025-05-19 09:01:23","2","1");
INSERT INTO exchanges VALUES("13","امر صرف","2","2147483647","2","8","123","","","2025-05-14 13:30:29","2025-05-14 13:30:29","2","1");
INSERT INTO exchanges VALUES("14","qwe","2","12","0","1","qwe","","","2025-05-19 08:04:11","2025-05-19 08:04:11","2","1");
INSERT INTO exchanges VALUES("15","qe","2","13","0","8","123","","","2025-05-19 09:08:18","2025-05-19 09:08:18","2","1");
INSERT INTO exchanges VALUES("16","qwe","2","123","0","8","qwe","","2025-05-19 09:16:19","2025-05-19 09:16:07","2025-05-19 09:16:19","2","1");
INSERT INTO exchanges VALUES("17","testing","2","10","4","13","hghgg","THy6bLzfjY7kUVd4d1EBcMnZtS79TmJ3dQ2tWcRM.pdf","2025-05-20 07:18:35","2025-05-20 07:15:50","2025-05-20 07:18:35","2","1");
INSERT INTO exchanges VALUES("18","testing","2","11","3","13","dfsfsdfdsfdsfsfdsfdsfsdfdsfdsfdsfdsfdsfdsf","OefvU9V1Yqxf9T4oFZ9x4XjdyHpvKAIMTK30GknB.pdf","2025-05-20 07:18:32","2025-05-20 07:17:41","2025-05-20 07:18:32","2","1");
INSERT INTO exchanges VALUES("19","123","2","123","0","19","123","","","2025-05-28 12:14:31","2025-05-28 12:14:31","2","1");



DROP TABLE failed_jobs;

CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) 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;




DROP TABLE job_batches;

CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;




DROP TABLE jobs;

CREATE TABLE `jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) unsigned NOT NULL,
  `reserved_at` int(10) unsigned DEFAULT NULL,
  `available_at` int(10) unsigned NOT NULL,
  `created_at` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;




DROP TABLE material_returns;

CREATE TABLE `material_returns` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_of` varchar(255) DEFAULT NULL,
  `place_of_use` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `quantity` decimal(8,2) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO material_returns VALUES("1","أسمنت","الخرسانات","طلب ارجاع الخامات","3000.00","2025-01-29 06:50:02","2025-01-29 06:50:02","");
INSERT INTO material_returns VALUES("2","test1","1",".csnjk","10.00","2025-05-12 07:26:15","2025-05-12 07:26:15","");
INSERT INTO material_returns VALUES("3","dffsdf","dsfdsf","dfsfsdf","1.00","2025-05-19 21:47:39","2025-05-19 21:47:39","");
INSERT INTO material_returns VALUES("4","whey","anfield","whey isolate ON","3.00","2025-05-22 05:05:11","2025-05-22 05:05:11","");
INSERT INTO material_returns VALUES("5","","","","-20.00","2025-05-22 08:09:01","2025-05-22 08:09:01","");
INSERT INTO material_returns VALUES("6","","","","","2025-05-22 12:14:41","2025-05-22 12:14:41","");
INSERT INTO material_returns VALUES("7","","","","","2025-05-22 12:14:53","2025-05-22 12:14:53","");
INSERT INTO material_returns VALUES("8","whey","anfield","","5.00","2025-05-24 21:34:38","2025-05-24 21:34:38","");



DROP TABLE media;

CREATE TABLE `media` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `file` varchar(255) NOT NULL,
  `history_id` int(10) unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` int(10) unsigned DEFAULT NULL,
  `project_id` int(10) unsigned DEFAULT NULL,
  `description` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO media VALUES("1","media/3/biWlIRQGgsuDM72QiFBTTBS9299WR3BE4kBnSu8s.jpg","6","","","","","","");
INSERT INTO media VALUES("2","media/2/C4nhQKstGTceZqqkvQHfwHJVtQqhVMFfmAQ2Dt6z.pdf","","","2025-05-12 11:46:22","2025-05-12 11:46:22","2","2","رسسئررسئرئرر");
INSERT INTO media VALUES("3","media/5/aPmd2CkCNlw4ODVXEVVaAX5guD5BZUST6oVciChd.pdf","24","","2025-05-12 22:03:33","2025-05-12 22:03:33","2","5","أضف رسالة");
INSERT INTO media VALUES("4","media/1/W0ORMpuKPNV9zvaM8ImseREpjt1qe2f5m0VRlmx0.png","61","","2025-05-25 10:39:11","2025-05-25 10:39:11","2","1","أضف رسالة");
INSERT INTO media VALUES("5","media/1/jkopyl8zsqK7iZDppt9BdwZgmGBOvSgNJOkZ4utw.png","62","","2025-05-25 10:51:13","2025-05-25 10:51:13","2","1","");
INSERT INTO media VALUES("6","media/1/CjQAmIQi3E0ilo0auxv8CqM2yAxrK9d00CKjcJVd.jpg","63","","2025-05-25 10:53:56","2025-05-25 10:53:56","2","1","");



DROP TABLE meetings;

CREATE TABLE `meetings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `project_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `lat` varchar(255) NOT NULL,
  `longit` varchar(255) NOT NULL,
  `details` text NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO meetings VALUES("1","2025-05-12","2","2","","","dCsefCSEFFSFSFffs vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv","","2025-05-12 12:56:10","2025-05-12 13:01:38");
INSERT INTO meetings VALUES("2","2025-05-19","1","2","","","ndndtynndnnynfn","","2025-05-19 07:09:04","2025-05-19 07:09:04");
INSERT INTO meetings VALUES("3","2025-05-19","12","2","","","213","2025-05-21 08:35:51","2025-05-21 08:35:37","2025-05-21 08:35:51");



DROP TABLE migrations;

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

INSERT INTO migrations VALUES("1","0001_01_01_000000_create_users_table","1");
INSERT INTO migrations VALUES("2","0001_01_01_000001_create_cache_table","1");
INSERT INTO migrations VALUES("3","0001_01_01_000002_create_jobs_table","1");
INSERT INTO migrations VALUES("4","2024_10_26_093558_add_phone_to_users","2");
INSERT INTO migrations VALUES("5","2024_11_03_044415_create_permission_tables","3");
INSERT INTO migrations VALUES("8","2024_11_03_063159_create_tests_table","5");
INSERT INTO migrations VALUES("9","2024_11_03_063239_create_tests_table","6");
INSERT INTO migrations VALUES("10","2024_11_03_063315_create_tests_table","7");
INSERT INTO migrations VALUES("11","2024_11_03_061959_create_procedures_table","8");
INSERT INTO migrations VALUES("12","2024_11_03_065212_create_customers_table","9");
INSERT INTO migrations VALUES("13","2024_11_03_071714_create_test2s_table","10");
INSERT INTO migrations VALUES("14","2024_11_04_041822_create_procedures_table","11");
INSERT INTO migrations VALUES("15","2024_11_09_084421_add_data_users","1");
INSERT INTO migrations VALUES("16","2024_11_10_151756_create_projects_table","12");
INSERT INTO migrations VALUES("17","2024_11_10_232304_create_companies_table","13");
INSERT INTO migrations VALUES("19","2024_11_10_232545_create_contracts_table","14");
INSERT INTO migrations VALUES("21","2024_11_11_064210_create_media_table","15");
INSERT INTO migrations VALUES("22","2024_11_11_064034_create_project_histories_table","16");
INSERT INTO migrations VALUES("23","2024_11_14_072759_add_data_to_history","17");
INSERT INTO migrations VALUES("24","2024_11_14_083912_add_data_to_history","18");
INSERT INTO migrations VALUES("25","2024_11_15_114550_create_project_requestes_table","18");
INSERT INTO migrations VALUES("26","2024_11_17_134627_add_data_to_history","19");
INSERT INTO migrations VALUES("27","2024_11_17_145302_create_users_projects_table","20");
INSERT INTO migrations VALUES("28","2024_11_25_202340_create_project_procedure_table","21");
INSERT INTO migrations VALUES("29","2024_11_26_193711_create_procedure_categories_table","22");
INSERT INTO migrations VALUES("30","2024_11_26_193818_create_sub_categories_table","22");
INSERT INTO migrations VALUES("32","2024_12_02_173612_create_aprovals_table","23");
INSERT INTO migrations VALUES("33","2024_12_05_101050_create_violations_table","24");
INSERT INTO migrations VALUES("34","2024_12_05_105403_create_evaluations_table","24");
INSERT INTO migrations VALUES("35","2024_12_05_113846_create_customer_calls_table","24");
INSERT INTO migrations VALUES("36","2024_12_05_125906_create_exchanges_table","24");
INSERT INTO migrations VALUES("37","2024_12_17_140939_add_data_to_projects","25");
INSERT INTO migrations VALUES("38","2024_12_17_174106_add_data_to_violations","26");
INSERT INTO migrations VALUES("39","2024_12_17_181109_add_data_to_company","27");
INSERT INTO migrations VALUES("40","2024_12_17_181913_add_data_to_companies","28");
INSERT INTO migrations VALUES("41","2024_12_17_190534_add_data_to_exchanges","28");
INSERT INTO migrations VALUES("42","2024_12_17_191202_add_data_to_projects","29");
INSERT INTO migrations VALUES("43","2024_12_17_193213_create_customer_contracts_table","30");
INSERT INTO migrations VALUES("44","2024_12_17_223328_add_data_to_projects","31");
INSERT INTO migrations VALUES("45","2024_12_18_005239_add_data_to_contracts","32");
INSERT INTO migrations VALUES("46","2024_12_18_015755_create_reports_table","33");
INSERT INTO migrations VALUES("47","2024_12_25_043904_add_data_to_project","34");
INSERT INTO migrations VALUES("48","2024_12_26_035855_add_data_to_projects","34");
INSERT INTO migrations VALUES("49","2024_12_27_032500_add_data_to_subs","34");
INSERT INTO migrations VALUES("50","2024_12_27_035927_add_data_to_steps","34");
INSERT INTO migrations VALUES("51","2024_12_27_051710_add_data_to_project_procedure","34");
INSERT INTO migrations VALUES("52","2024_12_27_052837_create_concretes_table","34");
INSERT INTO migrations VALUES("53","2024_12_31_111754_create_meetings_table","35");
INSERT INTO migrations VALUES("54","2024_12_31_112039_create_attendances_table","35");
INSERT INTO migrations VALUES("55","2025_01_02_014906_add_groupe_to_permissions","36");
INSERT INTO migrations VALUES("56","2025_01_02_131003_add_data_to_draft__orders","37");
INSERT INTO migrations VALUES("57","2025_01_04_012023_create_charts_table","37");
INSERT INTO migrations VALUES("58","2025_01_04_013815_create_charts_files_table","37");
INSERT INTO migrations VALUES("59","2025_01_19_211155_add_data_to_exchanges","38");
INSERT INTO migrations VALUES("60","2025_01_27_034558_add_data_to_approvals","39");
INSERT INTO migrations VALUES("61","2025_01_28_042401_add_data_to_media","40");
INSERT INTO migrations VALUES("62","2025_01_29_061417_create_project_returns_table","41");
INSERT INTO migrations VALUES("63","2025_01_30_184738_add_data_to_projects","42");
INSERT INTO migrations VALUES("64","2025_02_01_125454_create_activity_log_table","43");
INSERT INTO migrations VALUES("65","2025_02_01_125455_add_event_column_to_activity_log_table","43");
INSERT INTO migrations VALUES("66","2025_02_01_125456_add_batch_uuid_column_to_activity_log_table","43");
INSERT INTO migrations VALUES("67","2025_02_10_094316_add_data_to_concretes","44");
INSERT INTO migrations VALUES("68","2025_05_17_121122_add_data_to_violations","45");
INSERT INTO migrations VALUES("69","2025_05_17_121920_add_data_to_customer_calls","46");
INSERT INTO migrations VALUES("70","2025_05_27_185654_add_data_to_concrets","47");



DROP TABLE model_has_permissions;

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;




DROP TABLE model_has_roles;

CREATE TABLE `model_has_roles` (
  `role_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO model_has_roles VALUES("2","App\\Models\\User","4");
INSERT INTO model_has_roles VALUES("2","App\\Models\\User","12");
INSERT INTO model_has_roles VALUES("3","App\\Models\\User","1");
INSERT INTO model_has_roles VALUES("3","App\\Models\\User","11");
INSERT INTO model_has_roles VALUES("4","App\\Models\\User","8");
INSERT INTO model_has_roles VALUES("4","App\\Models\\User","14");
INSERT INTO model_has_roles VALUES("4","App\\Models\\User","15");
INSERT INTO model_has_roles VALUES("4","App\\Models\\User","16");
INSERT INTO model_has_roles VALUES("4","App\\Models\\User","17");
INSERT INTO model_has_roles VALUES("4","App\\Models\\User","18");
INSERT INTO model_has_roles VALUES("4","App\\Models\\User","22");
INSERT INTO model_has_roles VALUES("4","App\\Models\\User","23");
INSERT INTO model_has_roles VALUES("4","App\\Models\\User","24");
INSERT INTO model_has_roles VALUES("4","App\\Models\\User","25");
INSERT INTO model_has_roles VALUES("4","App\\Models\\User","26");
INSERT INTO model_has_roles VALUES("4","App\\Models\\User","27");
INSERT INTO model_has_roles VALUES("4","App\\Models\\User","28");
INSERT INTO model_has_roles VALUES("5","App\\Models\\User","2");
INSERT INTO model_has_roles VALUES("5","App\\Models\\User","6");
INSERT INTO model_has_roles VALUES("5","App\\Models\\User","9");
INSERT INTO model_has_roles VALUES("5","App\\Models\\User","10");
INSERT INTO model_has_roles VALUES("5","App\\Models\\User","13");
INSERT INTO model_has_roles VALUES("5","App\\Models\\User","19");
INSERT INTO model_has_roles VALUES("5","App\\Models\\User","20");
INSERT INTO model_has_roles VALUES("5","App\\Models\\User","21");
INSERT INTO model_has_roles VALUES("5","App\\Models\\User","29");



DROP TABLE password_reset_tokens;

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

INSERT INTO password_reset_tokens VALUES("callmenow@gmail.com","$2y$12$PeoUt66eZAVpGGm76h8gj.elIb9ehzdtKdxBYwrBYpQ3ZAywpNK9K","2025-01-27 06:39:42");



DROP TABLE permissions;

CREATE TABLE `permissions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `group` varchar(255) NOT NULL DEFAULT 'المشروع',
  `guard_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO permissions VALUES("1","اضافة مشروع","المشروع","web","2024-11-09 01:18:06","2024-11-09 01:18:06");
INSERT INTO permissions VALUES("2","تعديل مشروع","المشروع","web","2024-11-09 01:18:06","2024-11-09 01:18:06");
INSERT INTO permissions VALUES("3","توقيف المشروع","المشروع","web","2024-11-09 01:18:06","2024-11-09 01:18:06");
INSERT INTO permissions VALUES("4","اضافة طلب موافقه","المشروع","web","2024-12-03 08:20:22","2024-12-03 08:20:22");



DROP TABLE procedure_categories;

CREATE TABLE `procedure_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `procedure_id` int(10) unsigned NOT NULL,
  `details` text 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=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO procedure_categories VALUES("1","مرحلة التجهيز","1","نظام إدارة المشاريع","","2024-11-26 12:07:53","2024-12-18 05:31:28");
INSERT INTO procedure_categories VALUES("2","مرحلة الحفر","1","تست","","2024-12-18 05:31:47","2024-12-18 05:31:47");
INSERT INTO procedure_categories VALUES("3","مرحلة الأساسات","1","سؤش","","2024-12-18 05:32:02","2024-12-18 05:32:02");
INSERT INTO procedure_categories VALUES("4","مرحلة السباكة","2","مرحلة السباكة","","2024-12-18 05:33:11","2024-12-18 05:33:11");
INSERT INTO procedure_categories VALUES("5","مرحلة الكهرباء","2","ضي","","2024-12-18 05:34:19","2024-12-18 05:34:19");
INSERT INTO procedure_categories VALUES("6","aaaaaa","6","hffhhfcfcttf","","2025-05-11 11:26:37","2025-05-11 11:26:37");



DROP TABLE procedures;

CREATE TABLE `procedures` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `details` text DEFAULT 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=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO procedures VALUES("1","العظم","","","2024-11-08 23:11:23","2024-11-26 12:08:16");
INSERT INTO procedures VALUES("2","التشطيب","","","2024-11-08 23:12:21","2024-12-18 05:29:33");
INSERT INTO procedures VALUES("3","الديكور","","","","2024-12-18 05:29:44");
INSERT INTO procedures VALUES("4","أعمال الطرق","","","","2024-12-18 05:29:52");
INSERT INTO procedures VALUES("5","asd","","","2025-05-11 08:04:48","2025-05-11 11:07:17");
INSERT INTO procedures VALUES("6","الاستلام","ظمناىن ما ىءا ءتلاء","","2025-05-11 11:07:00","2025-05-11 11:07:00");
INSERT INTO procedures VALUES("7","23132132","ء ءؤ ءرء ء","2025-05-11 11:16:48","2025-05-11 11:07:44","2025-05-11 11:16:48");
INSERT INTO procedures VALUES("8",".............",".hkkkl","2025-05-11 00:00:00","2025-05-11 11:17:11","2025-05-11 11:17:11");



DROP TABLE project_history;

CREATE TABLE `project_history` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `project_id` int(11) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `historyable_type` varchar(255) NOT NULL,
  `user_id` int(11) NOT NULL,
  `historyable_id` int(11) NOT NULL,
  `procedure_id` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=83 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO project_history VALUES("1","1","","2025-01-15 15:58:07","2025-01-15 15:58:07","App\\Models\\Comment","2","23","3");
INSERT INTO project_history VALUES("2","1","","2025-01-16 09:58:25","2025-01-16 09:58:25","App\\Models\\Comment","4","24","1");
INSERT INTO project_history VALUES("3","1","","2025-01-16 10:10:23","2025-01-16 10:10:23","App\\Models\\Comment","4","25","3");
INSERT INTO project_history VALUES("4","1","","2025-01-16 10:11:44","2025-01-16 10:11:44","App\\Models\\Comment","4","26","3");
INSERT INTO project_history VALUES("5","1","","2025-01-16 10:13:15","2025-01-16 10:13:15","App\\Models\\Comment","2","27","3");
INSERT INTO project_history VALUES("6","3","","2025-01-16 10:55:43","2025-01-16 10:55:43","App\\Models\\Comment","4","28","1");
INSERT INTO project_history VALUES("7","3","","2025-01-16 10:58:03","2025-01-16 10:58:03","App\\Models\\Comment","4","29","2");
INSERT INTO project_history VALUES("8","5","","2025-01-26 22:26:35","2025-01-26 22:26:35","App\\Models\\Approval","2","1","4");
INSERT INTO project_history VALUES("9","1","","2025-01-27 06:46:44","2025-01-27 06:46:44","App\\Models\\Comment","4","30","2");
INSERT INTO project_history VALUES("10","1","","2025-01-27 06:47:47","2025-01-27 06:47:47","App\\Models\\Approval","4","2","1");
INSERT INTO project_history VALUES("11","1","","2025-01-27 06:49:54","2025-01-27 06:49:54","App\\Models\\Approval","4","3","1");
INSERT INTO project_history VALUES("12","1","","2025-01-27 06:53:07","2025-01-27 06:53:07","App\\Models\\MaterialRequest","4","1","1");
INSERT INTO project_history VALUES("13","3","","2025-01-29 06:50:02","2025-01-29 06:50:02","App\\Models\\MaterialReturns","2","1","1");
INSERT INTO project_history VALUES("14","4","","2025-05-06 08:19:39","2025-05-06 08:19:39","App\\Models\\Comment","2","31","2");
INSERT INTO project_history VALUES("15","2","","2025-05-08 07:46:26","2025-05-08 07:46:26","App\\Models\\Comment","2","32","9");
INSERT INTO project_history VALUES("16","2","","2025-05-08 07:48:30","2025-05-08 07:48:30","App\\Models\\Comment","2","33","4");
INSERT INTO project_history VALUES("17","2","","2025-05-11 12:11:48","2025-05-11 12:11:48","App\\Models\\MaterialRequest","2","2","2");
INSERT INTO project_history VALUES("18","2","","2025-05-11 14:30:05","2025-05-11 14:30:05","App\\Models\\Comment","2","34","4");
INSERT INTO project_history VALUES("19","2","","2025-05-12 07:25:41","2025-05-12 07:25:41","App\\Models\\MaterialRequest","2","3","4");
INSERT INTO project_history VALUES("20","2","","2025-05-12 07:26:15","2025-05-12 07:26:15","App\\Models\\MaterialReturns","2","2","4");
INSERT INTO project_history VALUES("21","2","","2025-05-12 07:27:09","2025-05-12 07:27:09","App\\Models\\MaterialRequest","2","4","4");
INSERT INTO project_history VALUES("22","2","","2025-05-12 07:36:35","2025-05-12 07:36:35","App\\Models\\Approval","2","4","4");
INSERT INTO project_history VALUES("23","2","","2025-05-12 09:07:56","2025-05-12 09:07:56","App\\Models\\MaterialRequest","2","5","9");
INSERT INTO project_history VALUES("24","5","","2025-05-12 22:03:33","2025-05-12 22:03:33","App\\Models\\Comment","2","35","5");
INSERT INTO project_history VALUES("25","7","","2025-05-13 07:29:22","2025-05-13 07:29:22","App\\Models\\Comment","2","36","1");
INSERT INTO project_history VALUES("26","7","","2025-05-13 07:50:58","2025-05-13 07:50:58","App\\Models\\MaterialRequest","2","6","15");
INSERT INTO project_history VALUES("27","2","","2025-05-13 08:17:42","2025-05-13 08:17:42","App\\Models\\MaterialRequest","2","7","5");
INSERT INTO project_history VALUES("28","7","","2025-05-13 09:23:39","2025-05-13 09:23:39","App\\Models\\MaterialRequest","2","8","2");
INSERT INTO project_history VALUES("29","8","","2025-05-13 10:05:06","2025-05-13 10:05:06","App\\Models\\MaterialRequest","2","9","2");
INSERT INTO project_history VALUES("30","8","","2025-05-13 11:24:57","2025-05-13 11:24:57","App\\Models\\MaterialRequest","2","10","1");
INSERT INTO project_history VALUES("31","8","","2025-05-13 11:25:23","2025-05-13 11:25:23","App\\Models\\Comment","2","37","1");
INSERT INTO project_history VALUES("32","7","","2025-05-13 21:51:02","2025-05-13 21:51:02","App\\Models\\MaterialRequest","2","11","1");
INSERT INTO project_history VALUES("33","8","","2025-05-14 10:56:53","2025-05-14 10:56:53","App\\Models\\MaterialRequest","2","12","1");
INSERT INTO project_history VALUES("34","9","","2025-05-14 14:36:59","2025-05-14 14:36:59","App\\Models\\MaterialRequest","2","13","2");
INSERT INTO project_history VALUES("35","3","","2025-05-19 09:51:23","2025-05-19 09:51:23","App\\Models\\MaterialRequest","2","14","1");
INSERT INTO project_history VALUES("36","8","","2025-05-19 10:48:32","2025-05-19 10:48:32","App\\Models\\MaterialRequest","2","15","1");
INSERT INTO project_history VALUES("37","8","","2025-05-19 11:05:26","2025-05-19 11:05:26","App\\Models\\MaterialRequest","2","16","1");
INSERT INTO project_history VALUES("38","13","","2025-05-19 21:47:03","2025-05-19 21:47:03","App\\Models\\Comment","2","38","4");
INSERT INTO project_history VALUES("39","13","","2025-05-19 21:47:21","2025-05-19 21:47:21","App\\Models\\MaterialRequest","2","17","4");
INSERT INTO project_history VALUES("40","13","","2025-05-19 21:47:39","2025-05-19 21:47:39","App\\Models\\MaterialReturns","2","3","4");
INSERT INTO project_history VALUES("41","13","","2025-05-19 21:47:53","2025-05-19 21:47:53","App\\Models\\Approval","2","5","4");
INSERT INTO project_history VALUES("42","13","","2025-05-20 07:33:03","2025-05-20 07:33:03","App\\Models\\MaterialRequest","2","18","2");
INSERT INTO project_history VALUES("43","1","","2025-05-22 05:05:11","2025-05-22 05:05:11","App\\Models\\MaterialReturns","2","4","1");
INSERT INTO project_history VALUES("44","1","","2025-05-22 05:06:20","2025-05-22 05:06:20","App\\Models\\Approval","2","6","1");
INSERT INTO project_history VALUES("45","1","","2025-05-22 05:19:53","2025-05-22 05:19:53","App\\Models\\MaterialRequest","2","19","1");
INSERT INTO project_history VALUES("46","1","","2025-05-22 05:20:42","2025-05-22 05:20:42","App\\Models\\MaterialRequest","2","20","12");
INSERT INTO project_history VALUES("47","1","","2025-05-22 05:21:20","2025-05-22 05:21:20","App\\Models\\Comment","2","39","12");
INSERT INTO project_history VALUES("48","1","","2025-05-22 05:24:11","2025-05-22 05:24:11","App\\Models\\MaterialRequest","2","21","12");
INSERT INTO project_history VALUES("49","1","","2025-05-22 05:25:47","2025-05-22 05:25:47","App\\Models\\MaterialRequest","2","22","12");
INSERT INTO project_history VALUES("50","1","","2025-05-22 08:09:01","2025-05-22 08:09:01","App\\Models\\MaterialReturns","2","5","1");
INSERT INTO project_history VALUES("51","1","","2025-05-22 12:13:55","2025-05-22 12:13:55","App\\Models\\Comment","2","40","1");
INSERT INTO project_history VALUES("52","1","","2025-05-22 12:14:12","2025-05-22 12:14:12","","2","0","1");
INSERT INTO project_history VALUES("53","1","","2025-05-22 12:14:16","2025-05-22 12:14:16","App\\Models\\MaterialRequest","2","23","1");
INSERT INTO project_history VALUES("54","1","","2025-05-22 12:14:35","2025-05-22 12:14:35","App\\Models\\MaterialRequest","2","24","1");
INSERT INTO project_history VALUES("55","1","","2025-05-22 12:14:41","2025-05-22 12:14:41","App\\Models\\MaterialReturns","2","6","1");
INSERT INTO project_history VALUES("56","1","","2025-05-22 12:14:53","2025-05-22 12:14:53","App\\Models\\MaterialReturns","2","7","1");
INSERT INTO project_history VALUES("57","1","","2025-05-22 12:14:59","2025-05-22 12:14:59","App\\Models\\MaterialRequest","2","25","1");
INSERT INTO project_history VALUES("58","2","","2025-05-24 21:34:38","2025-05-24 21:34:38","App\\Models\\MaterialReturns","2","8","5");
INSERT INTO project_history VALUES("59","2","","2025-05-24 21:34:59","2025-05-24 21:34:59","App\\Models\\Approval","2","7","5");
INSERT INTO project_history VALUES("60","2","","2025-05-24 21:35:45","2025-05-24 21:35:45","App\\Models\\Approval","2","8","5");
INSERT INTO project_history VALUES("61","1","","2025-05-25 10:39:11","2025-05-25 10:39:11","App\\Models\\Comment","2","41","12");
INSERT INTO project_history VALUES("62","1","","2025-05-25 10:51:13","2025-05-25 10:51:13","App\\Models\\Concrete","2","1","12");
INSERT INTO project_history VALUES("63","1","","2025-05-25 10:53:56","2025-05-25 10:53:56","App\\Models\\Concrete","2","2","12");
INSERT INTO project_history VALUES("64","8","","2025-05-27 21:52:31","2025-05-27 21:52:31","App\\Models\\Concrete","4","3","1");
INSERT INTO project_history VALUES("65","8","","2025-05-27 21:52:59","2025-05-27 21:52:59","App\\Models\\Concrete","4","4","1");
INSERT INTO project_history VALUES("66","8","","2025-05-27 22:00:51","2025-05-27 22:00:51","App\\Models\\Concrete","4","5","1");
INSERT INTO project_history VALUES("67","8","","2025-05-27 22:03:13","2025-05-27 22:03:13","App\\Models\\Concrete","4","6","1");
INSERT INTO project_history VALUES("68","8","","2025-05-27 22:05:40","2025-05-27 22:05:40","App\\Models\\Concrete","4","7","1");
INSERT INTO project_history VALUES("69","8","","2025-05-28 12:12:14","2025-05-28 12:12:14","App\\Models\\Concrete","2","8","1");
INSERT INTO project_history VALUES("70","19","","2025-05-28 12:13:48","2025-05-28 12:13:48","App\\Models\\MaterialRequest","2","26","2");
INSERT INTO project_history VALUES("71","2","","2025-05-28 15:06:50","2025-05-28 15:06:50","App\\Models\\MaterialRequest","2","27","5");
INSERT INTO project_history VALUES("72","2","","2025-05-28 15:07:28","2025-05-28 15:07:28","App\\Models\\Approval","2","9","5");
INSERT INTO project_history VALUES("73","2","","2025-05-28 15:08:06","2025-05-28 15:08:06","App\\Models\\Approval","2","10","10");
INSERT INTO project_history VALUES("74","23","","2025-05-28 15:20:51","2025-05-28 15:20:51","App\\Models\\MaterialRequest","2","28","10");
INSERT INTO project_history VALUES("75","23","","2025-05-28 16:06:21","2025-05-28 16:06:21","App\\Models\\MaterialRequest","2","29","10");
INSERT INTO project_history VALUES("76","23","","2025-05-28 16:10:06","2025-05-28 16:10:06","App\\Models\\Approval","2","11","10");
INSERT INTO project_history VALUES("77","23","","2025-05-28 16:10:33","2025-05-28 16:10:33","App\\Models\\Approval","2","12","10");
INSERT INTO project_history VALUES("78","23","","2025-05-28 16:11:25","2025-05-28 16:11:25","App\\Models\\Approval","2","13","10");
INSERT INTO project_history VALUES("79","23","","2025-05-28 16:12:12","2025-05-28 16:12:12","App\\Models\\MaterialRequest","2","30","10");
INSERT INTO project_history VALUES("80","23","","2025-05-28 16:12:22","2025-05-28 16:12:22","App\\Models\\Comment","2","42","10");
INSERT INTO project_history VALUES("81","23","","2025-05-28 16:14:28","2025-05-28 16:14:28","App\\Models\\Approval","4","14","9");
INSERT INTO project_history VALUES("82","24","","2025-05-28 16:22:47","2025-05-28 16:22:47","App\\Models\\Comment","4","43","21");



DROP TABLE project_procedure;

CREATE TABLE `project_procedure` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `project_id` int(11) NOT NULL,
  `procedure_id` int(11) NOT NULL,
  `cost` double NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `closed_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO project_procedure VALUES("1","2","2","40000","2025-01-16","2025-01-21","2025-01-15 11:46:45","2025-05-24 21:45:31","4","2");
INSERT INTO project_procedure VALUES("2","1","1","200000","2025-01-29","2025-02-27","2025-01-15 15:50:16","2025-01-27 06:46:14","2","4");
INSERT INTO project_procedure VALUES("3","3","1","35000","2025-01-06","2025-01-18","2025-01-16 10:37:53","2025-01-16 10:56:44","4","4");
INSERT INTO project_procedure VALUES("4","5","2","3000","2025-01-28","2025-01-30","2025-01-26 22:26:11","2025-05-12 22:04:35","2","2");
INSERT INTO project_procedure VALUES("5","4","1","100000","2025-05-09","2025-06-07","2025-05-06 08:16:49","2025-05-06 08:16:49","2","");
INSERT INTO project_procedure VALUES("6","2","4","10000","2025-12-02","2025-12-07","2025-05-08 07:39:33","2025-05-08 07:39:33","2","");
INSERT INTO project_procedure VALUES("7","8","1","123","2025-05-16","2025-05-29","2025-05-13 07:23:54","2025-05-13 11:23:41","2","2");
INSERT INTO project_procedure VALUES("8","7","1","20000","2025-05-12","2025-05-14","2025-05-13 07:26:13","2025-05-13 09:22:36","2","2");
INSERT INTO project_procedure VALUES("9","7","2","30000","2025-05-13","2025-05-13","2025-05-13 09:28:37","2025-05-13 09:28:37","2","");
INSERT INTO project_procedure VALUES("10","9","6","646444","2025-05-14","2025-05-10","2025-05-14 14:24:49","2025-05-14 14:24:49","2","");
INSERT INTO project_procedure VALUES("11","9","1","123123123","2025-05-14","0000-00-00","2025-05-14 14:36:42","2025-05-14 14:36:42","2","");
INSERT INTO project_procedure VALUES("12","8","2","123","2025-05-07","2025-05-19","2025-05-17 11:34:40","2025-05-17 11:34:40","2","");
INSERT INTO project_procedure VALUES("13","13","1","-5","2025-05-20","2025-05-19","2025-05-19 21:43:00","2025-05-19 21:45:33","2","2");
INSERT INTO project_procedure VALUES("14","13","2","-5","2025-05-20","2025-05-18","2025-05-19 21:46:13","2025-05-19 21:48:11","2","2");
INSERT INTO project_procedure VALUES("15","13","3","4","2025-05-04","2025-05-20","2025-05-19 21:57:48","2025-05-19 21:57:48","2","");
INSERT INTO project_procedure VALUES("16","1","2","234","2025-06-07","2025-04-30","2025-05-20 17:57:00","2025-05-20 17:57:00","2","");
INSERT INTO project_procedure VALUES("17","1","4","2522","2025-05-27","2025-05-28","2025-05-27 10:21:35","2025-05-27 10:21:35","2","");
INSERT INTO project_procedure VALUES("18","21","6","5000","2025-05-28","2025-06-28","2025-05-28 10:33:02","2025-05-28 10:33:02","2","");
INSERT INTO project_procedure VALUES("19","19","1","1231231231","2025-05-15","2025-05-20","2025-05-28 12:13:30","2025-05-28 12:13:30","2","");
INSERT INTO project_procedure VALUES("20","8","5","123","2025-05-23","2025-05-24","2025-05-28 13:16:50","2025-05-28 13:16:50","2","");
INSERT INTO project_procedure VALUES("21","23","6","20000","2025-05-28","2030-11-28","2025-05-28 15:15:33","2025-05-28 15:15:33","2","");
INSERT INTO project_procedure VALUES("22","23","4","20000","2025-05-28","2025-05-27","2025-05-28 15:16:54","2025-05-28 15:16:54","2","");
INSERT INTO project_procedure VALUES("23","12","1","1","2025-05-28","2025-05-29","2025-05-28 15:22:17","2025-05-28 15:22:17","2","");
INSERT INTO project_procedure VALUES("24","24","6","40000","2025-05-28","2027-06-28","2025-05-28 16:18:01","2025-05-28 16:18:01","2","");
INSERT INTO project_procedure VALUES("25","24","2","2000","2025-05-21","2025-05-30","2025-05-28 16:19:24","2025-05-28 16:19:24","4","");



DROP TABLE project_requests;

CREATE TABLE `project_requests` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_of` varchar(255) DEFAULT NULL,
  `place_of_use` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `quantity` decimal(8,2) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO project_requests VALUES("1","رمل","المشروع","رمل كتير","20.00","2025-01-27 06:53:07","2025-01-27 06:53:07");
INSERT INTO project_requests VALUES("2","لاءلاءؤلاءؤ","لابءلاب","ءلاءلالاءلاءلا","1000.00","2025-05-11 12:11:48","2025-05-11 12:11:48");
INSERT INTO project_requests VALUES("3","test 1","1","jklcjcs","1001.00","2025-05-12 07:25:41","2025-05-12 07:25:41");
INSERT INTO project_requests VALUES("4","tesssssst","2","dhdhrrggdtgd","100.00","2025-05-12 07:27:09","2025-05-12 07:27:09");
INSERT INTO project_requests VALUES("5","ddddddd","vddvvvdvdvd","vdsssvdvvsvvs","10000.00","2025-05-12 09:07:56","2025-05-12 09:07:56");
INSERT INTO project_requests VALUES("6","لاءلاءؤلاءؤ","cbcb","cbbccbbcb","10000.00","2025-05-13 07:50:58","2025-05-13 07:50:58");
INSERT INTO project_requests VALUES("7","","","","","2025-05-13 08:17:42","2025-05-13 08:17:42");
INSERT INTO project_requests VALUES("8","ؤ ؤ ؤ ب","ب ىبىغبىلى","ىلىبىللىبببىبلىبلىلبلب","1000.00","2025-05-13 09:23:39","2025-05-13 09:23:39");
INSERT INTO project_requests VALUES("9","qwe","","","","2025-05-13 10:05:06","2025-05-13 10:05:06");
INSERT INTO project_requests VALUES("10","اوقية","المشروع","اوقيه حماية","123.00","2025-05-13 11:24:57","2025-05-13 11:24:57");
INSERT INTO project_requests VALUES("11","","","","","2025-05-13 21:51:02","2025-05-13 21:51:02");
INSERT INTO project_requests VALUES("12","qwe","البيت","عايز qwe","12.00","2025-05-14 10:56:53","2025-05-14 10:56:53");
INSERT INTO project_requests VALUES("13","123","123","123","123.00","2025-05-14 14:36:59","2025-05-14 14:36:59");
INSERT INTO project_requests VALUES("14","123","w13","","999999.99","2025-05-19 09:51:23","2025-05-19 09:51:23");
INSERT INTO project_requests VALUES("15","مين","123123123","","","2025-05-19 10:48:32","2025-05-19 10:48:32");
INSERT INTO project_requests VALUES("16","","","","","2025-05-19 11:05:26","2025-05-19 11:05:26");
INSERT INTO project_requests VALUES("17","dffsdf","dsfdsf","sdfsfsdf","-3.00","2025-05-19 21:47:21","2025-05-19 21:47:21");
INSERT INTO project_requests VALUES("18","dffsdf","dsfdsf","xtdtu","-1.00","2025-05-20 07:33:03","2025-05-20 07:33:03");
INSERT INTO project_requests VALUES("19","ps5","home","Fifa","1.00","2025-05-22 05:19:53","2025-05-22 05:19:53");
INSERT INTO project_requests VALUES("20","","","","","2025-05-22 05:20:42","2025-05-22 05:20:42");
INSERT INTO project_requests VALUES("21","","","","-5.00","2025-05-22 05:24:11","2025-05-22 05:24:11");
INSERT INTO project_requests VALUES("22","","","","-36.00","2025-05-22 05:25:47","2025-05-22 05:25:47");
INSERT INTO project_requests VALUES("23","","","","","2025-05-22 12:14:16","2025-05-22 12:14:16");
INSERT INTO project_requests VALUES("24","","","","","2025-05-22 12:14:35","2025-05-22 12:14:35");
INSERT INTO project_requests VALUES("25","","","","","2025-05-22 12:14:59","2025-05-22 12:14:59");
INSERT INTO project_requests VALUES("26","123","123","123","123.00","2025-05-28 12:13:48","2025-05-28 12:13:48");
INSERT INTO project_requests VALUES("27","yhy","nnffn","nffnnfnfn","120.00","2025-05-28 15:06:50","2025-05-28 15:06:50");
INSERT INTO project_requests VALUES("28","bfdb","bdbdf","bdbfbf","12.00","2025-05-28 15:20:51","2025-05-28 15:20:51");
INSERT INTO project_requests VALUES("29","ndyb","ngfgyngnf","ngfgnfngf","120.00","2025-05-28 16:06:21","2025-05-28 16:06:21");
INSERT INTO project_requests VALUES("30","eg666","heheh","heeh","120.00","2025-05-28 16:12:12","2025-05-28 16:12:12");



DROP TABLE projects;

CREATE TABLE `projects` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `available_procedures` text DEFAULT NULL,
  `start_date` date NOT NULL,
  `end_date` date DEFAULT NULL,
  `period` int(11) NOT NULL,
  `manager_id` int(10) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `supervisor_id` int(11) DEFAULT NULL,
  `consultant_id` int(11) DEFAULT NULL,
  `cost` int(11) DEFAULT NULL,
  `customer` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `number1` varchar(255) DEFAULT NULL,
  `number2` varchar(255) DEFAULT NULL,
  `number3` varchar(255) DEFAULT NULL,
  `current_procedure_id` int(11) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO projects VALUES("1","فيلا العثيم","[\"1\",\"2\",\"3\",\"4\"]","2024-07-13","2024-08-12","30","2","2025-05-28 13:19:53","2024-12-27 06:10:49","2025-05-28 13:19:53","11","27","900000","Molestias doloremque","luvosaforu@mailinator.com","712","206","189","12","4");
INSERT INTO projects VALUES("2","فيلا السلامة 445 طريق الحجاز -1","[\"3\"]","2025-01-14","2025-05-24","130","9","","2025-01-15 10:31:34","2025-05-28 15:08:06","1","8","400000","سمحان البدراوي","callmenow@gmail.com","01006680030","","","10","1");
INSERT INTO projects VALUES("3","فيلا الأميرة حسناء العوامري بالدرعية","[\"1\",\"2\"]","2025-01-01","2025-05-21","140","2","","2025-01-16 10:20:03","2025-05-15 09:27:11","1","8","250000","الأميرة حسناء","hasnaa02902928@gmail.com","010006680032","","","2","1");
INSERT INTO projects VALUES("4","فيلا الأميرة حسناء العوامري بالحسينية","[\"1\",\"2\",\"3\",\"4\"]","2025-01-01","","2000","6","","2025-01-19 22:37:10","2025-05-06 08:19:39","1","8","10000000","أحمد أمين","ahmedaminrashad@gmail.com","1","1","1","2","1");
INSERT INTO projects VALUES("5","فيلا السلامة 444 طريق الحجاز","[\"1\",\"2\",\"3\",\"4\"]","2025-01-30","2025-03-21","50","6","","2025-01-26 22:25:30","2025-05-12 22:03:33","1","8","50000000","أحمد أمين","ahmedaminrashad@gmail.com","01017213866","101017213867","0101017213865","5","1");
INSERT INTO projects VALUES("6","محمود","[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"]","2025-12-05","2026-10-01","300","6","","2025-05-13 00:38:47","2025-05-13 00:38:47","1","8","20000000","سلمان","mohamedhashem2001111@gmail.com","","","","","1");
INSERT INTO projects VALUES("7","Test","[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"]","0033-02-04","0033-05-15","100","2","","2025-05-13 07:16:34","2025-05-13 10:33:17","1","8","400000","nk.knk","8880565a9f6b@drmail.in","1234567890","24334434334","34435444341","2","2");
INSERT INTO projects VALUES("8","مشروعي","[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"]","2025-05-01","2025-08-09","100","2","","2025-05-13 07:17:59","2025-05-24 22:33:43","11","8","2147483647","العميل","xyz@gamil.com","29","12","50","1","4");
INSERT INTO projects VALUES("9","تست امر الصرف","[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"]","2024-10-09","2025-01-17","100","2","","2025-05-14 13:44:09","2025-05-14 14:36:59","1","8","123123123","123","s@s","","","","2","1");
INSERT INTO projects VALUES("10","q","[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"]","0023-12-31","0024-05-02","123","2","","2025-05-15 09:27:54","2025-05-19 11:03:48","1","8","123","123","1a@q","1","","","","1");
INSERT INTO projects VALUES("11",".","[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"]","2025-05-18","2025-08-26","100","2","","2025-05-18 10:08:28","2025-05-21 08:16:31","1","8","499999","lnli","bxfcttb@gmail.com",".22","-1112","426","","1");
INSERT INTO projects VALUES("12","test11","[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"]","2025-05-20","2025-05-19","2147483647","2","","2025-05-19 21:18:37","2025-05-28 12:10:08","1","8","4000000","أحمد أمين","mohabhegazy839@gmail.com","01012345616","-2","","","1");
INSERT INTO projects VALUES("13","test 12","[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"]","2025-05-20","2025-05-19","2147483647","2","","2025-05-19 21:22:52","2025-05-20 07:33:03","1","8","40000000","أحمد أمين","mohabhegazy839@gmail.com","01061588881","","","2","1");
INSERT INTO projects VALUES("14","بهاء سلطان","[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"]","2024-12-12","2026-04-26","500","2","","2025-05-20 06:22:33","2025-05-20 06:22:33","1","8","1000000","ياسر الدوسري","mohamedhashem2001111@gmail.com","2","2","2","","1");
INSERT INTO projects VALUES("15","محمد ابوتريكة","[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"]","2024-11-11","2025-11-11","365","2","","2025-05-20 06:23:34","2025-05-20 06:23:34","1","8","10000000","الاهلي","mohamedhashem2001111@gmail.com","22","22","22","","1");
INSERT INTO projects VALUES("16","frimpong","[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"]","2024-11-11","2025-02-19","100","2","","2025-05-20 06:25:29","2025-05-20 06:25:29","1","8","350000","liverpool","mohamedhashem2001111@gmail.com","2","2","2","","1");
INSERT INTO projects VALUES("17","kerkez","[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"]","2005-11-11","2006-12-16","400","2","","2025-05-20 06:31:31","2025-05-20 06:50:41","1","8","300000","liverpool","mohamedhashem2001111@gmail.com","1","2","3","","1");
INSERT INTO projects VALUES("18","konate","[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"]","2024-11-11","2025-12-16","400","20","","2025-05-20 06:53:26","2025-05-22 17:31:06","1","8","400000","liverpool","mohamedhashem2001111@gmail.com","0","0","0","","1");
INSERT INTO projects VALUES("19","qwe","[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"]","2025-05-31","2025-10-01","123","2","","2025-05-24 19:47:25","2025-05-28 12:13:48","1","8","3132","123","x@y.z","123","123","1233","2","2");
INSERT INTO projects VALUES("20","Project 1","[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"]","2026-12-30","2027-01-04","5","2","","2025-05-25 10:22:36","2025-05-25 10:22:36","1","8","5000","Tarek","tarek@outlook.com","010493483434","","","","1");
INSERT INTO projects VALUES("21","t1","[\"5\",\"6\"]","2025-05-28","2025-09-25","120","2","","2025-05-28 10:31:56","2025-05-28 10:31:56","1","8","140000","lk","7981b26cc621@drmail.in","","","","","1");
INSERT INTO projects VALUES("22","t2","[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"]","0025-05-28","0025-07-04","37","2","","2025-05-28 15:11:02","2025-05-28 15:13:10","1","8","0","jg","7981b26cc621@drmail.in","","","","","1");
INSERT INTO projects VALUES("23","t3","[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"]","2025-05-28","2025-10-15","140","2","","2025-05-28 15:14:41","2025-05-28 16:14:28","1","8","150000","vm","7981b26cc621@drmail.in","","","","9","1");
INSERT INTO projects VALUES("24","t4","[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\"]","2025-05-28","2025-09-25","120","2","","2025-05-28 16:17:14","2025-05-28 16:22:47","1","8","-1","k.k.k","7981b26cc621@drmail.in","","","","21","1");



DROP TABLE reports;

CREATE TABLE `reports` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `details` text NOT NULL,
  `request_to_end` tinyint(4) NOT NULL DEFAULT 0,
  `user_id` int(11) NOT NULL,
  `approved_by` int(11) DEFAULT NULL,
  `project_id` int(11) NOT NULL,
  `procedure_id` int(11) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO reports VALUES("1","تم إضافة إجراء استثنائي جديد تم إضافة إجراء استثنائي جديد تم إضافة إجراء استثنائي جديد تم إضافة إجراء استثنائي جديد تم إضافة إجراء استثنائي جديد تم إضافة إجراء استثنائي جديد تم إضافة إجراء استثنائي جديد تم إضافة إجراء استثنائي جديد تم إضافة إجراء استثنائي جديد تم إضافة إجراء استثنائي جديد تم إضافة إجراء استثنائي جديد تم إضافة إجراء استثنائي جديد تم إضافة إجراء استثنائي جديد تم إضافة إجراء استثنائي جديد تم إضافة إجراء استثنائي جديد تم إضافة إجراء استثنائي جديد تم إضافة إجراء استثنائي جديد تم إضافة إجراء استثنائي جديد","0","4","","1","2","","2025-01-27 07:08:14","2025-01-27 07:08:14");
INSERT INTO reports VALUES("2","mmmhmvmvmv   jtjnjftnfnm","0","2","","2","4","","2025-05-11 12:06:43","2025-05-11 12:06:43");
INSERT INTO reports VALUES("3","vmvmvvmmv        vvmv                           vmmvmvm   vmvmv","1","2","","2","4","","2025-05-11 12:07:16","2025-05-11 12:07:16");
INSERT INTO reports VALUES("4","تم الانتهاء من استجئار اللوادر","0","2","","5","4","","2025-05-12 22:23:34","2025-05-12 22:23:34");
INSERT INTO reports VALUES("5","fdfd","1","2","","5","8","","2025-05-12 23:05:50","2025-05-12 23:05:50");
INSERT INTO reports VALUES("6","123","1","2","","8","1","","2025-05-13 12:13:05","2025-05-13 12:13:05");
INSERT INTO reports VALUES("7","qwe","1","2","","8","1","","2025-05-19 07:38:11","2025-05-19 07:38:11");
INSERT INTO reports VALUES("8","ttrtrtrt","1","2","","13","4","","2025-05-20 07:12:31","2025-05-20 07:12:31");
INSERT INTO reports VALUES("9","yiktimiiimm","0","2","","1","12","","2025-05-27 11:40:52","2025-05-27 11:40:52");
INSERT INTO reports VALUES("10","muiuiiuuuiuiuuuuuu","1","2","","1","12","","2025-05-27 11:41:07","2025-05-27 11:41:07");



DROP TABLE role_has_permissions;

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `role_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO role_has_permissions VALUES("1","3");
INSERT INTO role_has_permissions VALUES("1","4");
INSERT INTO role_has_permissions VALUES("1","7");
INSERT INTO role_has_permissions VALUES("2","3");
INSERT INTO role_has_permissions VALUES("2","4");
INSERT INTO role_has_permissions VALUES("2","7");
INSERT INTO role_has_permissions VALUES("3","3");
INSERT INTO role_has_permissions VALUES("3","4");
INSERT INTO role_has_permissions VALUES("3","7");



DROP TABLE roles;

CREATE TABLE `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO roles VALUES("1","مدير المشروع","web","2024-11-09 01:02:42","2024-11-09 01:02:42");
INSERT INTO roles VALUES("2","مدير النظام","web","2024-11-09 01:02:49","2024-11-09 01:02:49");
INSERT INTO roles VALUES("3","مشرف الموقع","web","2024-12-02 22:44:28","2024-12-18 09:12:39");
INSERT INTO roles VALUES("4","الاستشارى","web","2024-12-02 22:58:49","2024-12-02 22:58:49");
INSERT INTO roles VALUES("5","مدير الموقع","web","2024-12-03 08:18:16","2024-12-03 08:18:16");
INSERT INTO roles VALUES("7","مستخدمين","web","2024-12-03 08:19:55","2024-12-03 08:19:55");



DROP TABLE sessions;

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO sessions VALUES("3RHwMykZ8lQbDdHfqAGN18K493uopC8asJfrHdJ7","4","156.213.136.57","Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36","YTo0OntzOjY6Il90b2tlbiI7czo0MDoibFc0ckpiV1RMdEo1MzR5WlNtdkZtTHZhZUY2QzFwcmY2T0YwOVF1YyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDE6Imh0dHBzOi8vbGxiZnAuY29tL2Rhc2hib2FyZC9hY3Rpdml0eS1sb2dzIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6NDt9","1748439139");
INSERT INTO sessions VALUES("7DylWQwcSUz6NSCzEVdCF6MCHQjdR9LFDCLvM2Bo","","40.77.167.4","Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) Chrome/116.0.1938.76 Safari/537.36","YTozOntzOjY6Il90b2tlbiI7czo0MDoiRUhqWW1ENGNranNYWTVDUVladFM4dzcwRE5XQkxRTkpmSUE2aDZnNyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjM6Imh0dHBzOi8vbGxiZnAuY29tL2xvZ2luIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==","1748437578");
INSERT INTO sessions VALUES("8XZRpNsYkHK7pYvySII8UYv0hzrZeMb3cg6KmKOR","","182.44.12.37","Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1","YTozOntzOjY6Il90b2tlbiI7czo0MDoiZXBieEdmZlg0TDhqeVpNdjlSR203bVJ5NnZ1N3g1bXV2OXk5ZzhJZiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vd3d3LmxsYmZwLmNvbS9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=","1748435540");
INSERT INTO sessions VALUES("DPeZ3S2OHcy4CZxSo9PNolQNMxolJl2t2Y2nyr1L","","182.44.12.37","Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1","YTozOntzOjY6Il90b2tlbiI7czo0MDoidWcyVzNFOFNEN3F3d1R4TXpxOGpjQlhPUGVoYUh0cHJFM0VFWVpsZiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHBzOi8vd3d3LmxsYmZwLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=","1748435531");
INSERT INTO sessions VALUES("F3BlCK1B5dgg1uCPlUB5bzWnL8V9Vn8xiQxDuMzY","2","102.43.135.250","Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36","YTo1OntzOjY6Il90b2tlbiI7czo0MDoiVDBVM2ZQc0xJbGhCelRPNkxKYW5tamFjblRpamNsWVA0WFk5MnZIcyI7czozOiJ1cmwiO2E6MDp7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjI3OiJodHRwczovL2xsYmZwLmNvbS9kYXNoYm9hcmQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aToyO30=","1748437017");
INSERT INTO sessions VALUES("Fx2WpsSsDCTgZHOZyEADvBBABRCwUmDuvXdP4nKb","4","41.42.129.36","Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36 Edg/136.0.0.0","YTo0OntzOjY6Il90b2tlbiI7czo0MDoieWxoRDBOUTJ2QXVUQnF4R092NWZqZ092emNPOURrcWpKMlZVck5sTiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzk6Imh0dHBzOi8vbGxiZnAuY29tL2Rhc2hib2FyZC9zdWJjYXRlZ29yeSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjQ7fQ==","1748438433");
INSERT INTO sessions VALUES("IdK64n8lsDK5Ly0E94aLahzeuspaxGctERu1L8w8","2","156.199.72.194","Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36","YTo1OntzOjY6Il90b2tlbiI7czo0MDoiTk1uTGRpYzg3YTZhaU53Q2N5elU4Z2FFcVE4dVg4UDI5SXpVaTR3NSI7czozOiJ1cmwiO2E6MDp7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzY6Imh0dHBzOi8vbGxiZnAuY29tL2Rhc2hib2FyZC9leGNoYW5nZSI7fX0=","1748438075");
INSERT INTO sessions VALUES("SO5ENMtzqzoaLniMCWAipBP4Bpaki8EojxuPiEUW","","105.203.250.5","Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36","YTozOntzOjY6Il90b2tlbiI7czo0MDoiZ1dTZVZiNFljNXJtTG1jTmIydEx2bkVsSzZqd2d3OFpCajVSN2xYTCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjM6Imh0dHBzOi8vbGxiZnAuY29tL2xvZ2luIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==","1748438438");
INSERT INTO sessions VALUES("Sq4mvvwzN3RewifWdtGDpPRrsBb7QPra1dpMsz3d","4","104.28.162.138","Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36 Edg/136.0.0.0","YTo0OntzOjY6Il90b2tlbiI7czo0MDoidnQ2a1FzclcyT1pyTkRlamwzYWRGdUQ2MW5hQzJxdDRRVHhFVGFhVCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHBzOi8vbGxiZnAuY29tL2Rhc2hib2FyZC9hZG1pbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjQ7fQ==","1748437449");



DROP TABLE sub_categories;

CREATE TABLE `sub_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `project_id` int(11) DEFAULT NULL,
  `files` text DEFAULT NULL,
  `youtube_url` varchar(255) DEFAULT NULL,
  `category_id` int(10) unsigned NOT NULL,
  `details` text NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `sorting` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO sub_categories VALUES("1","تنظيف المكان","","[\"projects\\/64pzvs2oh4umPj4bZBB9cwq1urMbTE77vvJyUDhy.jpg\"]","https://www.youtube.com/@khedrwb","1","يرجى العمل على التنظيف","","2024-11-26 12:27:36","2025-01-16 10:42:53","1");
INSERT INTO sub_categories VALUES("2","التخلص من مخلفات التنظيف","","","","1","التخلص من كذا كذا","","2024-11-26 12:28:01","2024-12-18 05:36:41","0");
INSERT INTO sub_categories VALUES("3","وضع حواجز شريطية حول مكان العمل","","","","1","وضع حواجز شريطية حول مكان العمل","","2024-12-18 05:37:05","2024-12-18 05:37:05","0");
INSERT INTO sub_categories VALUES("4","استئجار اللودر","","","","2","استئجار اللودر","","2024-12-18 05:37:27","2024-12-18 05:37:27","0");
INSERT INTO sub_categories VALUES("5","استئجار سيارات النقل","","","","2","استئجار سيارات النقل","","2024-12-18 05:37:44","2024-12-18 05:37:44","0");
INSERT INTO sub_categories VALUES("6","الحفر حسب المخطط","","","","2","الحفر حسب المخطط","","2024-12-18 05:37:57","2024-12-18 05:37:57","0");
INSERT INTO sub_categories VALUES("7","التخلص من مخلفات الحفر","","","","2","التخلص من مخلفات الحفر","","2024-12-18 05:38:22","2024-12-18 05:38:22","0");
INSERT INTO sub_categories VALUES("8","جس التربة وإرسال العينة إلى المعمل","","","","2","جس التربة وإرسال العينة إلى المعمل","","2024-12-18 05:38:37","2024-12-18 05:38:37","0");
INSERT INTO sub_categories VALUES("9","الحصول على المخطط التشغيلي","","","","4","الحصول على المخطط التشغيلي","","2024-12-18 05:39:39","2024-12-18 05:40:34","0");
INSERT INTO sub_categories VALUES("10","عمل المقايسة","","","","4","عمل المقايسة","","2024-12-18 05:39:56","2024-12-18 05:40:48","0");
INSERT INTO sub_categories VALUES("11","شراء الخامات المطلوبة","","","","4","شراء الخامات المطلوبة","","2024-12-18 05:41:00","2024-12-18 05:41:00","0");
INSERT INTO sub_categories VALUES("12","قبل تنظيف المكان","1","","https://www.youtube.com/@khedrwb","1","قبل تنظيف المكان إجراء استثنائي","","2025-01-27 06:57:11","2025-01-27 06:57:11","1");
INSERT INTO sub_categories VALUES("13","ffsfssf","","","https://youtu.be/wQ9UHnFh8lc?si=BYIZSPP5FoaXoOiW","6","zffzzsff","2025-05-11 11:31:11","2025-05-11 11:30:11","2025-05-11 11:31:11","2");
INSERT INTO sub_categories VALUES("14","ر سيزن رسرسسرريررسسر","2","[\"projects\\/D9WVtz6H7Ta8L4u6WJIh6UNtfE0ljoNL2ihOeZ7V.png\"]","https://youtu.be/wQ9UHnFh8lc?si=BYIZSPP5FoaXoOiW","1","رسيريسر ةوةى وى وز ت ى ت 2121212112123","","2025-05-11 12:21:46","2025-05-11 12:21:46","2");
INSERT INTO sub_categories VALUES("15","testss","7","","https://youtu.be/wQ9UHnFh8lc?si=1SZD8D0FThD3p4CP","1","freggevrvrvvevvvvvt","","2025-05-13 07:41:18","2025-05-13 07:41:18","3");
INSERT INTO sub_categories VALUES("16","qwe","8","","https://www.youtube.com/","1","qwe","","2025-05-13 10:05:18","2025-05-13 10:05:18","4");
INSERT INTO sub_categories VALUES("17","qwe","8","","https://www.youtube.com","1","qwe","2025-05-13 00:00:00","2025-05-13 10:05:58","2025-05-13 10:05:58","5");
INSERT INTO sub_categories VALUES("18","qwe","8","","https://www.youtube.com","1","qwe","","2025-05-13 10:06:08","2025-05-13 10:06:08","5");
INSERT INTO sub_categories VALUES("19","123","8","","www.google.com","1","123","","2025-05-13 11:28:25","2025-05-13 11:28:25","2");
INSERT INTO sub_categories VALUES("20","qwe","8","","https://youtu.be/cImzebO-mXg?si=B9cw-0c4DH4UT4Xu","1","qwe","","2025-05-13 11:29:37","2025-05-13 11:29:37","6");
INSERT INTO sub_categories VALUES("21","yyjyjjy","","","https://youtu.be/wQ9UHnFh8lc?si=BYIZSPP5FoaXoOiW","6","gyjfjgyjj","","2025-05-28 16:21:48","2025-05-28 16:21:48","7");



DROP TABLE tests;

CREATE TABLE `tests` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `date` date NOT NULL,
  `email` varchar(255) NOT NULL,
  `gender` int(10) unsigned 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=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO tests VALUES("1","ahmed amin","OzHYsYuBUX1812JPJFoyA8i1Jl98fWUcz6Ym4ChG.pdf","2024-11-13","ahmedaminrashad@gmail.com","2","","2024-11-02 23:36:10","2024-11-02 23:36:10");
INSERT INTO tests VALUES("2","ahmed amin","mDA0AQymDcTpUnFDwrdXf45IZUNB0r1tzLccOTG0.pdf","2024-11-03","ahmedaminrashad@gmail.com","1","","2024-11-02 23:48:25","2024-11-02 23:48:25");



DROP TABLE users;

CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `phone` varchar(255) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `role_id` int(255) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO users VALUES("1","سمير المشرفي","test@example.com","2024-10-25 16:26:45","$2y$12$Ose5HAPol4hqaWqC7nOS.ebkcdhrajYHRsQv0/Hg6vjZ3cu/4dvj6","Rmy7H8jKVUpbY527QfUL3ywPAHOmyhADFaeHDRQtLZWA15zvMMVgsKffJFnm","2024-10-25 16:26:45","2024-12-17 16:12:12","05444444444","","3","");
INSERT INTO users VALUES("2","أحمد أمين","ahmedaminrashad@gmail.com","","$2y$12$W686FPUf1lhciTrycoi.LO4r9drcJ/fASuPDc9re8qRXC5jFXZOmu","OGLfeUcvYxNnANiLE9T8acf997Q8Cd3XfD5XVpBkegqJPVzBIJeLHMP02pWL","2024-11-09 01:08:22","2025-05-12 00:33:40","05000000000","vJsk0lE5yR9zDd61mkEi28B1IQ4k7qMBqgSPeOAE.jpg","5","");
INSERT INTO users VALUES("4","محمد حسام","callmenow@gmail.com","","$2y$12$T21fq0OofFaTlta39Y3ur.JiUdZ5Be9a8TwGCGbbJ0vaUjliZRwBa","9x4Ivv5EBEu7WRzwijH8yApCdlgue2uj3NR8J42q1O3PuAtakmSfR4f2jyOk","2024-11-14 04:28:22","2024-12-17 15:34:00","05000000003","i4jmQRp3Xlw8tHEMIKDOLJVUvSND60tJGmg07Ocg.png","2","");
INSERT INTO users VALUES("6","علي الجوباني","ahmedaminrashad2@gmail.com","","$2y$12$ELBSy66HWn9nsWSXQCFoIOJ3GN7XV/5KBV8Oc6Oqt8GpztQIT17Wu","","2024-11-19 07:44:29","2024-12-18 09:13:28","05000000002","wyDGD8VsdCGxm4VmcQgHLpIc7tS3rdJrZ5ZuIsAG.png","5","");
INSERT INTO users VALUES("7","ahmed amin","ahmedaminrashad3@gmail.com","","$2y$12$ZPSlEwKOHXL2p8ZZN61QY.B8IfdXQ1w9vfvVudwSs9Gex9c4/Gbee","","2024-12-04 17:21:07","2024-12-04 17:21:07","05000000001","","4","");
INSERT INTO users VALUES("8","حسن المستشار","ahmedaminrashad4@gmail.com","","$2y$12$nxn9PbgI1H9l4vb1XiUge.nfSSGRuqxGIYQ.r.2Gt5YGkhNyV.PPK","","2024-12-17 15:25:55","2024-12-18 09:20:39","05111111111","bvXH4oj96WVB1V7CEvP61qcCCeqnUrpFF7sByl3N.jpg","4","");
INSERT INTO users VALUES("9","محمد المدير الموقعي","ahmedaminrashad6@gmail.com","","$2y$12$j9VPyM4i1Ph6Xl8K8v9Q2.xXM.sqrHCTbApaUZAUGc8.177DvG3tC","lv5uqRmFs1n5d7qw6dvPeKa28NQcrHmPObM5PFeOGtJGy4ew08jmDG58pjNF","2024-12-17 15:27:06","2024-12-17 18:12:20","05777777777","SotcKsELmQfpXew8PdBu0CIbu7mJxKZ2R8P33b7B.jpg","5","");
INSERT INTO users VALUES("10","مدير المشروع","ahmedaminrashad7@gmail.com","","$2y$12$zhDBly9df0sH8G1trLKXy.WDsLiFSeIWUysujLaKWwWO4fkl9UcrS","","2024-12-17 15:28:16","2024-12-17 15:42:25","0588888888","rCUwVPBkHDXCK4AqV69mLeueSQGXM6NeZhqAYlcd.jpg","5","2024-12-17 15:42:25");
INSERT INTO users VALUES("11","المشرف","ahmedaminrashad8@gmail.com","","$2y$12$Hddox9Vec2eqNAqKjKGXs.19GhDyA1.SnYXc37sSoDW..5dY/Wf3W","","2024-12-17 15:29:10","2024-12-17 15:29:10","05555555555","xaqVt3AaAgP2a2svNjrD8kt3pXyrtLjjhBNV40ty.jpg","3","");
INSERT INTO users VALUES("12","محمود السلهوبي","lklk@lklk.com","","$2y$12$cwK2PLF7VR9MLXLPe5/p0Okt1xLxrtYT6T1/JRduBwQ2i9RVvBzIm","","2024-12-18 06:14:34","2024-12-18 09:23:21","05888888888","","2","");
INSERT INTO users VALUES("13","إسماعيل النمساوي","test@gmail.com","","$2y$12$cN5aAtllscB3JMUb4Dbdze6nA8z.wHB6hAV5OzawyBmwSSMT2dghW","","2024-12-18 09:53:55","2025-05-07 10:27:32","0568988988","CgHTK7lXKMQuWWjacXP3vgVbVK4GJs81wcUqQa4M.jpg","5","2025-05-07 10:27:32");
INSERT INTO users VALUES("14","123","123","","$2y$12$iweha09Yf5CkqKATTmTbC.WTdnIVymB4F7fJ3MumpNgFsiBzHSi86","","2025-05-07 10:26:28","2025-05-07 15:49:57","qwe","","4","2025-05-07 15:49:57");
INSERT INTO users VALUES("15","qwe","qew","","$2y$12$gVAD1qm/YObUPMmAU4ODtebm2y1SwR3/MfaOBb8CMEE5ba1ZvQiya","","2025-05-07 15:22:04","2025-05-07 15:50:40","qw","","4","2025-05-07 15:50:40");
INSERT INTO users VALUES("16","1","شتنؤتؤشاشش","","$2y$12$pEMXvRMie5Yl/r4GcxWHLeUvmRJCEvrtgCqbUTBGLShBzmp4a94hK","","2025-05-11 07:41:23","2025-05-11 09:09:06","mcdmcsdlkmc///....","","4","");
INSERT INTO users VALUES("17","c n","..30/","","$2y$12$WwH2HpOY01AUDPPgkTAXw.gXf5zBFIJ/kME6Ih49sPe9gSBqREaZO","","2025-05-11 09:12:36","2025-05-11 09:21:19","nfcn","","4","2025-05-11 09:21:19");
INSERT INTO users VALUES("18","ncfhnf","xbbx","","$2y$12$V09X/oXCt7bV59hZtp98CON.H8RgNQ5VTUB2bPvFYqDeFbBELj.Dq","","2025-05-11 09:21:42","2025-05-11 09:21:42","xbxf","","4","");
INSERT INTO users VALUES("19","aaaaaaaaaaaaaaaaaa","bv","","$2y$12$KH8C4hF76fUrW0.pCYBJxOh7Crxpov/YJoBVr34HBF57gd369Jnoa","","2025-05-11 09:26:09","2025-05-11 09:26:09","b","","5","2025-05-11 00:00:00");
INSERT INTO users VALUES("20","vzzvzzz","zvzzx","","$2y$12$6IQmZcGacLv1yCSLm/X.IeiVHCG92/cF4a.0CXHtkNcwQnJIrgjje","","2025-05-11 09:27:04","2025-05-11 09:27:04","zv","","5","");
INSERT INTO users VALUES("21","zvzfsd","zvvzxvxz","","$2y$12$O0dHLwTTWQqRWlkwF6z4x.ubmki2oLxzq/dKNCx/EfLG1CStdeRFy","","2025-05-11 09:27:35","2025-05-11 10:49:53","vzzv","","5","");
INSERT INTO users VALUES("22","aaaaaaaaa","vxz","","$2y$12$iUl0wwlE4Y1aJTmreL7KuOND3cTghkz4VfaBso3qbIzL1UxDq9BXy","","2025-05-11 09:28:47","2025-05-11 10:49:30","dzc","","4","");
INSERT INTO users VALUES("23","zafwfwwwwwwwww","faaw","","$2y$12$HJO0jcJsMtyhXARIAKeAFumL7LjSeqOZ6kQYRvkPAsFkk7X6ae3YG","","2025-05-11 09:39:37","2025-05-11 09:39:37","ww","ivi41MSseyVlYjiqc9mWf2sA11uJJU3avHpjmJ0y.png","4","");
INSERT INTO users VALUES("24","bbbbb","cfcfbcxcb","","$2y$12$hqByC5JMNxGg0fvlQVp7be8E.KDHQ8/A23msdDlYRm0Q9WbnDnkue","","2025-05-11 10:41:03","2025-05-11 10:49:21","bzz","","4","");
INSERT INTO users VALUES("25","faefrzz","tdf","","$2y$12$DGkLeJ/St0O8gDKea6kZhuCN.ARHSqQx27xcU1IntbskY9KzUxeOm","","2025-05-11 10:50:44","2025-05-11 10:51:02","tgrrd","","4","");
INSERT INTO users VALUES("26","kkkkkkkkkkkkkkkkk","cn","","$2y$12$6Rjzx8cTS/YkOHMFYUqa6.QetPhkqY4khHOiLnR8I0vYQeLmLmQse","","2025-05-11 10:51:39","2025-05-11 10:51:51","cvn","","4","");
INSERT INTO users VALUES("27",".......................................................","bhbh","","$2y$12$NEeL3zDmy176UkQVsfuaKuUfpcw3Pr4c3BPnRBOlAX/WltPxWTbgG","","2025-05-11 11:17:56","2025-05-11 12:40:21","hbk","","4","");
INSERT INTO users VALUES("28",".ىوى","02","","$2y$12$9MrRUK73YY78K9lEGBLwVejVhxnw7q.8pYhEWLOJOWJ/9ALr2qun2","","2025-05-11 12:32:24","2025-05-11 12:37:36","ىلا ىلا","CyJG406qL1O7M8SzGE2T2KWkmiTb3aEXCMcwQBhh.png","4","");
INSERT INTO users VALUES("29","3","mohabhegazy839@gmail.com","","$2y$12$mTMQpONp9qrgPHhtEbKKzOL1HO2kHSk0I3s4YAljSkiUgqC1/wJeS","","2025-05-11 19:31:22","2025-05-11 21:11:19","w","jesIcHmEBzUcMJZ8AKZR6QZmpEPNGVP0LAoVz9NA.jpg","5","");



DROP TABLE users_projects;

CREATE TABLE `users_projects` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `project_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=273 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO users_projects VALUES("4","2","2","","");
INSERT INTO users_projects VALUES("27","9","1","","");
INSERT INTO users_projects VALUES("29","9","3","","");
INSERT INTO users_projects VALUES("44","13","3","","");
INSERT INTO users_projects VALUES("45","1","4","","");
INSERT INTO users_projects VALUES("46","8","4","","");
INSERT INTO users_projects VALUES("47","6","4","","");
INSERT INTO users_projects VALUES("56","13","1","","");
INSERT INTO users_projects VALUES("61","23","3","","");
INSERT INTO users_projects VALUES("62","29","5","","");
INSERT INTO users_projects VALUES("66","1","2","","");
INSERT INTO users_projects VALUES("67","8","2","","");
INSERT INTO users_projects VALUES("68","9","2","","");
INSERT INTO users_projects VALUES("69","1","5","","");
INSERT INTO users_projects VALUES("70","8","5","","");
INSERT INTO users_projects VALUES("71","6","5","","");
INSERT INTO users_projects VALUES("72","1","6","","");
INSERT INTO users_projects VALUES("73","8","6","","");
INSERT INTO users_projects VALUES("74","6","6","","");
INSERT INTO users_projects VALUES("102","1","7","","");
INSERT INTO users_projects VALUES("103","8","7","","");
INSERT INTO users_projects VALUES("104","2","7","","");
INSERT INTO users_projects VALUES("135","1","9","","");
INSERT INTO users_projects VALUES("136","8","9","","");
INSERT INTO users_projects VALUES("137","2","9","","");
INSERT INTO users_projects VALUES("144","1","3","","");
INSERT INTO users_projects VALUES("145","8","3","","");
INSERT INTO users_projects VALUES("146","2","3","","");
INSERT INTO users_projects VALUES("147","1","10","","");
INSERT INTO users_projects VALUES("148","8","10","","");
INSERT INTO users_projects VALUES("149","2","10","","");
INSERT INTO users_projects VALUES("153","1","11","","");
INSERT INTO users_projects VALUES("154","8","11","","");
INSERT INTO users_projects VALUES("155","2","11","","");
INSERT INTO users_projects VALUES("159","1","12","","");
INSERT INTO users_projects VALUES("160","8","12","","");
INSERT INTO users_projects VALUES("161","2","12","","");
INSERT INTO users_projects VALUES("162","1","13","","");
INSERT INTO users_projects VALUES("163","8","13","","");
INSERT INTO users_projects VALUES("164","2","13","","");
INSERT INTO users_projects VALUES("171","1","14","","");
INSERT INTO users_projects VALUES("172","8","14","","");
INSERT INTO users_projects VALUES("173","2","14","","");
INSERT INTO users_projects VALUES("174","1","15","","");
INSERT INTO users_projects VALUES("175","8","15","","");
INSERT INTO users_projects VALUES("176","2","15","","");
INSERT INTO users_projects VALUES("177","1","16","","");
INSERT INTO users_projects VALUES("178","8","16","","");
INSERT INTO users_projects VALUES("179","2","16","","");
INSERT INTO users_projects VALUES("195","1","17","","");
INSERT INTO users_projects VALUES("196","8","17","","");
INSERT INTO users_projects VALUES("197","2","17","","");
INSERT INTO users_projects VALUES("228","1","18","","");
INSERT INTO users_projects VALUES("229","8","18","","");
INSERT INTO users_projects VALUES("230","20","18","","");
INSERT INTO users_projects VALUES("234","11","1","","");
INSERT INTO users_projects VALUES("235","27","1","","");
INSERT INTO users_projects VALUES("236","2","1","","");
INSERT INTO users_projects VALUES("246","11","8","","");
INSERT INTO users_projects VALUES("247","8","8","","");
INSERT INTO users_projects VALUES("248","2","8","","");
INSERT INTO users_projects VALUES("249","1","19","","");
INSERT INTO users_projects VALUES("250","8","19","","");
INSERT INTO users_projects VALUES("251","2","19","","");
INSERT INTO users_projects VALUES("252","1","20","","");
INSERT INTO users_projects VALUES("253","8","20","","");
INSERT INTO users_projects VALUES("254","2","20","","");
INSERT INTO users_projects VALUES("255","1","21","","");
INSERT INTO users_projects VALUES("256","8","21","","");
INSERT INTO users_projects VALUES("257","2","21","","");
INSERT INTO users_projects VALUES("264","1","22","","");
INSERT INTO users_projects VALUES("265","8","22","","");
INSERT INTO users_projects VALUES("266","2","22","","");
INSERT INTO users_projects VALUES("267","1","23","","");
INSERT INTO users_projects VALUES("268","8","23","","");
INSERT INTO users_projects VALUES("269","2","23","","");
INSERT INTO users_projects VALUES("270","1","24","","");
INSERT INTO users_projects VALUES("271","8","24","","");
INSERT INTO users_projects VALUES("272","2","24","","");



DROP TABLE violations;

CREATE TABLE `violations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `project_id` int(10) unsigned NOT NULL,
  `causer` varchar(255) NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `files` text DEFAULT NULL,
  `date_of_violation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO violations VALUES("1","مدير المشروع","مدير المشروع","1","مدير المشروع","2","","2024-12-17 18:17:12","2024-12-17 18:17:12","","");
INSERT INTO violations VALUES("2","مخالفة رقم 2","تفاصيل مخالفة 2","2","أحمد العمال","4","2025-05-13 09:10:00","2024-12-17 18:31:25","2025-05-13 09:10:00","[\"violations\\/WKZjSv5luJV5ie9zKKrp3PfudAaVSZIQ5VxMOCce.jpg\",\"violations\\/awB27WlIPpTx9dkjyJNHmT5U9MFu830awIxpkLoK.jpg\"]","");
INSERT INTO violations VALUES("3","ةه ن ة","ن. ن ن","1","م هى ه ن","2","2025-05-07 08:37:30","2025-05-07 08:37:10","2025-05-07 08:37:30","","");
INSERT INTO violations VALUES("4","حعىحتىتحرحعر","مررتترركترترك","1","تحرتكركرتركت","2","2025-05-07 08:38:03","2025-05-07 08:37:47","2025-05-07 08:38:03","","");
INSERT INTO violations VALUES("5","خاؤامؤاؤختؤ","مترامامكتؤ","1","عحرحترتحرحتركرتىن","2","","2025-05-07 08:38:26","2025-05-11 12:51:17","","");
INSERT INTO violations VALUES("6","تست","تست","3","تست","2","2025-05-11 12:51:13","2025-05-07 09:05:29","2025-05-11 12:51:13","","");
INSERT INTO violations VALUES("7","تست","تست","1","تست","2","","2025-05-11 09:11:08","2025-05-11 09:11:08","","");
INSERT INTO violations VALUES("8","شسي","شسي","1","شسي","2","","2025-05-11 09:11:16","2025-05-11 09:11:16","","");
INSERT INTO violations VALUES("9","ضصث","ضصث","1","ضصث","2","","2025-05-11 09:11:40","2025-05-11 09:11:40","","");
INSERT INTO violations VALUES("10","qwe","qwe","1","qwe","2","","2025-05-11 09:14:03","2025-05-11 09:14:03","","");
INSERT INTO violations VALUES("11","qwe","qe","1","qwe","2","","2025-05-11 09:29:48","2025-05-11 09:29:48","","");
INSERT INTO violations VALUES("12","qwe","qwe","1","qwe","2","","2025-05-11 10:08:35","2025-05-11 10:08:35","[\"violations\\/kPWx10NwZSyUQ9OPPp8zb1n2aIbNR3KSjg39qIRd.png\"]","");
INSERT INTO violations VALUES("13","الاسم","التوصيف","2","تست","2","2025-05-12 09:04:30","2025-05-12 08:41:21","2025-05-12 09:04:30","","");
INSERT INTO violations VALUES("14","ضصث","ضصث","2","ضصثضصثضصثض","2","2025-05-13 09:09:58","2025-05-12 09:58:49","2025-05-13 09:09:58","","");
INSERT INTO violations VALUES("15","123","123","8","123","2","2025-05-13 08:54:48","2025-05-13 08:54:37","2025-05-13 08:54:48","","");
INSERT INTO violations VALUES("16","qwe","qwe","8","qwe","2","2025-05-13 09:09:55","2025-05-13 09:08:44","2025-05-13 09:09:55","","");
INSERT INTO violations VALUES("17","ئ ؤئؤؤئ","ئؤئؤئيي","2","ئؤؤئريئئئرئرئر","2","","2025-05-13 10:44:42","2025-05-13 10:44:42","[\"violations\\/Q3CH2cxQigMmcB0N24P9Tbbr4oDudCVhOZSAdeE0.pdf\"]","");
INSERT INTO violations VALUES("18","qwe","qwe","1","qwe","2","","2025-05-18 18:24:46","2025-05-18 18:24:46","","2025-05-14 21:24:00");
INSERT INTO violations VALUES("19","qwe","qwe","8","qwe","2","","2025-05-18 20:29:04","2025-05-18 20:29:04","","2025-05-29 23:29:00");
INSERT INTO violations VALUES("20","x","xxxxxx","7","xxx","2","","2025-05-18 20:29:46","2025-05-18 20:29:46","","2025-05-02 23:29:00");
INSERT INTO violations VALUES("21","qwe","qwe","1","qwe","2","","2025-05-27 11:06:47","2025-05-27 11:06:47","","2025-05-30 11:06:00");



