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

START TRANSACTION;



--
-- Database: `hola`
--

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

--
-- Table structure for table `activity_logs`
--

CREATE TABLE `activity_logs` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `action` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `model_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `model_id` bigint UNSIGNED DEFAULT NULL,
  `properties` json DEFAULT NULL,
  `ip_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `activity_logs` (`id`, `user_id`, `action`, `description`, `model_type`, `model_id`, `properties`, `ip_address`, `created_at`, `updated_at`) VALUES
(1, 1, 'update', 'تم تعديل إعدادات الإشعارات', NULL, NULL, '[]', '127.0.0.1', '2026-04-11 16:33:12', '2026-04-11 16:33:12'),
(2, 1, 'update', 'تم تعديل إعدادات الإشعارات', NULL, NULL, '[]', '127.0.0.1', '2026-04-11 17:24:02', '2026-04-11 17:24:02'),
(3, 1, 'update', 'تم تعديل إعدادات الإشعارات', NULL, NULL, '[]', '127.0.0.1', '2026-04-11 17:25:00', '2026-04-11 17:25:00'),
(4, 1, 'update', 'تم تعديل إعدادات الإشعارات', NULL, NULL, '[]', '127.0.0.1', '2026-04-11 17:38:31', '2026-04-11 17:38:31'),
(5, 1, 'create', 'تم إنشاء جلسة جديدة: 1/2026', 'App\\Models\\CouncilSession', 1, '[]', '127.0.0.1', '2026-04-11 17:40:35', '2026-04-11 17:40:35'),
(6, 1, 'create', 'تم إنشاء قرار جديد: الاعين', 'App\\Models\\Decision', 1, '[]', '127.0.0.1', '2026-04-11 17:41:42', '2026-04-11 17:41:42'),
(7, 1, 'update', 'تم تعديل بيانات الموظف: مدير النظام', 'App\\Models\\User', 1, '[]', '127.0.0.1', '2026-04-11 17:42:25', '2026-04-11 17:42:25'),
(8, 1, 'start', 'تم بدء تنفيذ القرار: الاعين', 'App\\Models\\Decision', 1, '[]', '127.0.0.1', '2026-04-11 17:42:46', '2026-04-11 17:42:46'),
(9, 1, 'create', 'تم إنشاء قرار جديد: شارع وادي الشرق', 'App\\Models\\Decision', 2, '[]', '127.0.0.1', '2026-04-11 17:43:45', '2026-04-11 17:43:45'),
(10, 1, 'create', 'تم إنشاء قرار جديد: e', 'App\\Models\\Decision', 3, '[]', '127.0.0.1', '2026-04-11 17:51:09', '2026-04-11 17:51:09'),
(11, 1, 'start', 'تم بدء تنفيذ القرار: شارع وادي الشرق', 'App\\Models\\Decision', 2, '[]', '127.0.0.1', '2026-04-11 18:02:50', '2026-04-11 18:02:50'),
(12, 1, 'create', 'تم إنشاء قرار جديد: ssssss', 'App\\Models\\Decision', 4, '[]', '127.0.0.1', '2026-04-11 18:03:25', '2026-04-11 18:03:25'),
(13, 1, 'create', 'تم إنشاء قرار جديد: ثثثثثثثث', 'App\\Models\\Decision', 5, '[]', '127.0.0.1', '2026-04-11 18:06:13', '2026-04-11 18:06:13'),
(14, 1, 'create', 'تم إضافة موظف جديد: tamer', 'App\\Models\\User', 2, '[]', '127.0.0.1', '2026-04-11 18:07:20', '2026-04-11 18:07:20'),
(15, 1, 'create', 'تم إنشاء قرار جديد: qqqqqqq', 'App\\Models\\Decision', 6, '[]', '127.0.0.1', '2026-04-11 18:08:08', '2026-04-11 18:08:08'),
(16, 1, 'create', 'تم إنشاء قرار جديد: ddd', 'App\\Models\\Decision', 7, '[]', '127.0.0.1', '2026-04-11 18:12:43', '2026-04-11 18:12:43'),
(17, 1, 'start', 'تم بدء تنفيذ القرار: ثثثثثثثث', 'App\\Models\\Decision', 5, '[]', '127.0.0.1', '2026-04-11 18:15:29', '2026-04-11 18:15:29'),
(18, 1, 'complete', 'تم إكمال القرار: ثثثثثثثث', 'App\\Models\\Decision', 5, '[]', '127.0.0.1', '2026-04-11 18:15:34', '2026-04-11 18:15:34'),
(19, 1, 'approve', 'تم اعتماد القرار: ثثثثثثثث', 'App\\Models\\Decision', 5, '[]', '127.0.0.1', '2026-04-11 18:15:38', '2026-04-11 18:15:38'),
(20, 1, 'create', 'تم إنشاء جلسة جديدة: جلسة 1-2026', 'App\\Models\\CouncilSession', 2, '[]', '127.0.0.1', '2026-04-11 18:37:07', '2026-04-11 18:37:07'),
(21, 1, 'create', 'تم إنشاء قرار جديد: حفريات', 'App\\Models\\Decision', 8, '[]', '127.0.0.1', '2026-04-11 18:37:53', '2026-04-11 18:37:53'),
(22, 1, 'delete', 'تم حذف الجلسة: 1/2026', 'App\\Models\\CouncilSession', 1, '[]', '127.0.0.1', '2026-04-11 18:42:13', '2026-04-11 18:42:13'),
(23, 1, 'start', 'تم بدء تنفيذ القرار: حفريات', 'App\\Models\\Decision', 8, '[]', '127.0.0.1', '2026-04-11 18:51:44', '2026-04-11 18:51:44'),
(24, 1, 'complete', 'تم إكمال القرار: حفريات', 'App\\Models\\Decision', 8, '[]', '127.0.0.1', '2026-04-11 18:51:48', '2026-04-11 18:51:48'),
(25, 1, 'complete', 'تم إكمال القرار: حفريات', 'App\\Models\\Decision', 8, '[]', '127.0.0.1', '2026-04-11 18:51:55', '2026-04-11 18:51:55'),
(26, 1, 'complete', 'تم إكمال القرار: حفريات', 'App\\Models\\Decision', 8, '[]', '127.0.0.1', '2026-04-11 18:52:01', '2026-04-11 18:52:01'),
(27, 1, 'transfer', 'تم ترحيل القرار من tamer إلى مدير النظام', 'App\\Models\\Decision', 8, '[]', '127.0.0.1', '2026-04-11 18:52:10', '2026-04-11 18:52:10'),
(28, 1, 'complete', 'تم إكمال القرار: حفريات', 'App\\Models\\Decision', 8, '[]', '127.0.0.1', '2026-04-11 18:52:21', '2026-04-11 18:52:21'),
(29, 1, 'approve', 'تم اعتماد القرار: حفريات', 'App\\Models\\Decision', 8, '[]', '127.0.0.1', '2026-04-11 18:52:25', '2026-04-11 18:52:25'),
(30, 1, 'create', 'تم إنشاء قرار جديد: ققققق', 'App\\Models\\Decision', 9, '[]', '127.0.0.1', '2026-04-11 20:40:42', '2026-04-11 20:40:42'),
(31, 1, 'comment', 'تم إضافة تعليق على: ققققق', 'App\\Models\\Decision', 9, '[]', '127.0.0.1', '2026-04-11 20:40:58', '2026-04-11 20:40:58'),
(32, 1, 'comment', 'تم إضافة تعليق على: ققققق', 'App\\Models\\Decision', 9, '[]', '127.0.0.1', '2026-04-11 20:41:03', '2026-04-11 20:41:03'),
(33, 1, 'create', 'تم إنشاء قرار جديد: تامر', 'App\\Models\\Decision', 10, '[]', '192.168.1.106', '2026-04-11 21:54:08', '2026-04-11 21:54:08'),
(34, 1, 'create', 'تم إنشاء قرار جديد: اااا', 'App\\Models\\Decision', 11, '[]', '192.168.1.103', '2026-04-11 21:56:44', '2026-04-11 21:56:44'),
(35, 1, 'start', 'تم بدء تنفيذ القرار: اااا', 'App\\Models\\Decision', 11, '[]', '192.168.1.103', '2026-04-11 21:56:53', '2026-04-11 21:56:53'),
(36, 1, 'complete', 'تم إكمال القرار: اااا', 'App\\Models\\Decision', 11, '[]', '192.168.1.103', '2026-04-11 21:57:01', '2026-04-11 21:57:01'),
(37, 1, 'comment', 'تم إضافة تعليق على: اااا', 'App\\Models\\Decision', 11, '[]', '192.168.1.103', '2026-04-11 21:57:09', '2026-04-11 21:57:09'),
(38, 1, 'complete', 'تم إكمال القرار: اااا', 'App\\Models\\Decision', 11, '[]', '192.168.1.103', '2026-04-11 21:57:21', '2026-04-11 21:57:21'),
(39, 1, 'update', 'تم تعديل بيانات الموظف: tamer', 'App\\Models\\User', 2, '[]', '192.168.1.106', '2026-04-11 21:59:16', '2026-04-11 21:59:16'),
(40, 1, 'create', 'تم إنشاء قرار جديد: هههههههههه', 'App\\Models\\Decision', 12, '[]', '192.168.1.106', '2026-04-11 22:00:35', '2026-04-11 22:00:35'),
(41, 1, 'update', 'تم تعديل القرار: هههههههههه', 'App\\Models\\Decision', 12, '[]', '192.168.1.106', '2026-04-11 22:00:50', '2026-04-11 22:00:50'),
(42, 1, 'create', 'تم إنشاء قرار جديد: ii', 'App\\Models\\Decision', 13, '[]', '192.168.1.106', '2026-04-11 22:07:20', '2026-04-11 22:07:20'),
(43, 1, 'update', 'تم تعديل القرار: ii', 'App\\Models\\Decision', 13, '[]', '192.168.1.106', '2026-04-11 22:08:07', '2026-04-11 22:08:07'),
(44, 1, 'create', 'تم إنشاء قرار جديد: jjjjjjjjjjj', 'App\\Models\\Decision', 14, '[]', '85.184.61.190', '2026-04-12 12:10:39', '2026-04-12 12:10:39'),
(45, 1, 'create', 'تم إنشاء قرار جديد: gg', 'App\\Models\\Decision', 15, '[]', '85.184.61.190', '2026-04-12 12:11:58', '2026-04-12 12:11:58'),
(46, 1, 'start', 'تم بدء تنفيذ القرار: gg', 'App\\Models\\Decision', 15, '[]', '85.184.61.190', '2026-04-12 12:13:22', '2026-04-12 12:13:22'),
(47, 1, 'complete', 'تم إكمال القرار: gg', 'App\\Models\\Decision', 15, '[]', '85.184.61.190', '2026-04-12 12:13:55', '2026-04-12 12:13:55'),
(48, 1, 'complete', 'تم إكمال القرار: gg', 'App\\Models\\Decision', 15, '[]', '85.184.61.190', '2026-04-12 12:14:04', '2026-04-12 12:14:04'),
(49, 1, 'create', 'تم إنشاء قرار جديد: rrrrrrrrrrrr', 'App\\Models\\Decision', 16, '[]', '85.184.61.190', '2026-04-12 12:14:44', '2026-04-12 12:14:44'),
(50, 1, 'start', 'تم بدء تنفيذ القرار: rrrrrrrrrrrr', 'App\\Models\\Decision', 16, '[]', '85.184.61.190', '2026-04-12 12:18:22', '2026-04-12 12:18:22'),
(51, 1, 'create', 'تم إنشاء قرار جديد: test', 'App\\Models\\Decision', 17, '[]', '85.184.61.190', '2026-04-12 12:24:50', '2026-04-12 12:24:50'),
(52, 1, 'start', 'تم بدء تنفيذ القرار: test', 'App\\Models\\Decision', 17, '[]', '85.184.61.190', '2026-04-12 12:26:11', '2026-04-12 12:26:11'),
(53, 1, 'create', 'تم إنشاء قرار جديد: 1111111', 'App\\Models\\Decision', 18, '[]', '85.184.61.190', '2026-04-12 12:27:29', '2026-04-12 12:27:29'),
(54, 1, 'start', 'تم بدء تنفيذ القرار: 1111111', 'App\\Models\\Decision', 18, '[]', '85.184.61.190', '2026-04-12 12:30:42', '2026-04-12 12:30:42'),
(55, 2, 'complete', 'تم إكمال القرار: 1111111', 'App\\Models\\Decision', 18, '[]', '95.130.92.197', '2026-04-12 12:32:14', '2026-04-12 12:32:14'),
(56, 1, 'approve', 'تم اعتماد القرار: 1111111', 'App\\Models\\Decision', 18, '[]', '85.184.61.190', '2026-04-12 12:32:30', '2026-04-12 12:32:30'),
(57, 1, 'delete', 'تم حذف الجلسة: جلسة 1-2026', 'App\\Models\\CouncilSession', 2, '[]', '127.0.0.1', '2026-04-14 06:03:03', '2026-04-14 06:03:03'),
(58, 1, 'create', 'تم إنشاء جلسة جديدة: 2026', 'App\\Models\\CouncilSession', 3, '[]', '127.0.0.1', '2026-04-14 06:19:54', '2026-04-14 06:19:54'),
(59, 1, 'create', 'تم إنشاء قرار جديد: العين', 'App\\Models\\Decision', 19, '[]', '127.0.0.1', '2026-04-14 06:22:29', '2026-04-14 06:22:29'),
(60, 1, 'start', 'تم بدء تنفيذ القرار: العين', 'App\\Models\\Decision', 19, '[]', '127.0.0.1', '2026-04-14 06:23:20', '2026-04-14 06:23:20'),
(61, 1, 'comment', 'تم إضافة تعليق على: العين', 'App\\Models\\Decision', 19, '[]', '127.0.0.1', '2026-04-14 06:23:46', '2026-04-14 06:23:46'),
(62, 1, 'complete', 'تم إكمال القرار: العين', 'App\\Models\\Decision', 19, '[]', '127.0.0.1', '2026-04-14 06:24:00', '2026-04-14 06:24:00'),
(63, 2, 'complete', 'تم إكمال القرار: العين', 'App\\Models\\Decision', 19, '[]', '127.0.0.1', '2026-04-14 06:25:00', '2026-04-14 06:25:00'),
(64, 1, 'comment', 'تم إضافة تعليق على: العين', 'App\\Models\\Decision', 19, '[]', '127.0.0.1', '2026-04-14 06:25:34', '2026-04-14 06:25:34'),
(65, 1, 'approve', 'تم اعتماد القرار: العين', 'App\\Models\\Decision', 19, '[]', '127.0.0.1', '2026-04-14 06:25:39', '2026-04-14 06:25:39'),
(66, 1, 'update', 'تم تعديل الجلسة: 2026', 'App\\Models\\CouncilSession', 3, '[]', '127.0.0.1', '2026-04-14 06:28:23', '2026-04-14 06:28:23'),
(67, 1, 'update', 'تم تعديل القرار: العين', 'App\\Models\\Decision', 19, '[]', '127.0.0.1', '2026-04-14 06:28:35', '2026-04-14 06:28:35');

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

--
-- Table structure for table `attachments`
--

CREATE TABLE `attachments` (
  `id` bigint UNSIGNED NOT NULL,
  `attachable_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `attachable_id` bigint UNSIGNED NOT NULL,
  `file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_size` bigint UNSIGNED NOT NULL DEFAULT '0',
  `uploaded_by` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `attachments` (`id`, `attachable_type`, `attachable_id`, `file_name`, `file_path`, `file_type`, `file_size`, `uploaded_by`, `created_at`, `updated_at`) VALUES
(1, 'App\\Models\\CouncilSession', 3, '.env', 'sessions/3/reZwaFv5q2OgpPHwvIXYVwfaufiPW04ty5XCPjQz.txt', 'application/octet-stream', 1441, 1, '2026-04-14 06:28:23', '2026-04-14 06:28:23'),
(2, 'App\\Models\\Decision', 19, '.editorconfig', 'decisions/19/BfQIizgwoT2xDdmYVXicKN36RGUhTQn14cqPN93r.txt', 'application/octet-stream', 258, 1, '2026-04-14 06:28:35', '2026-04-14 06:28:35');

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

--
-- Table structure for table `comments`
--

CREATE TABLE `comments` (
  `id` bigint UNSIGNED NOT NULL,
  `commentable_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `commentable_id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `comments` (`id`, `commentable_type`, `commentable_id`, `user_id`, `body`, `created_at`, `updated_at`) VALUES
(1, 'App\\Models\\Decision', 9, 1, 'ي', '2026-04-11 20:40:58', '2026-04-11 20:40:58'),
(2, 'App\\Models\\Decision', 9, 1, 'ييي', '2026-04-11 20:41:03', '2026-04-11 20:41:03'),
(3, 'App\\Models\\Decision', 11, 1, 'شو', '2026-04-11 21:57:09', '2026-04-11 21:57:09'),
(4, 'App\\Models\\Decision', 19, 1, 'سيتم التواصل مع الشركات', '2026-04-14 06:23:46', '2026-04-14 06:23:46'),
(5, 'App\\Models\\Decision', 19, 1, 'يعطيك العافيه', '2026-04-14 06:25:34', '2026-04-14 06:25:34');

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

--
-- Table structure for table `committees`
--

CREATE TABLE `committees` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `committees` (`id`, `name`, `description`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'المالية', NULL, 1, '2026-04-11 19:30:06', '2026-04-11 19:30:06');

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

--
-- Table structure for table `committee_meetings`
--

CREATE TABLE `committee_meetings` (
  `id` bigint UNSIGNED NOT NULL,
  `committee_id` bigint UNSIGNED NOT NULL,
  `council_id` bigint UNSIGNED NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `meeting_date` date NOT NULL,
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `file_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `external_attendees` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_by` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `committee_meetings` (`id`, `committee_id`, `council_id`, `title`, `meeting_date`, `content`, `file_path`, `external_attendees`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 1, 2, 'الموازنة2026', '2026-04-11', NULL, 'committee_meetings/ldFyY54eBX5g6SyRnDC6jVRIde5KDIGCSDTD5BWB.png', 'نضال جبارين', 1, '2026-04-11 19:31:07', '2026-04-13 07:54:23');

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

--
-- Table structure for table `committee_meeting_council_member`
--

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

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

INSERT INTO `committee_meeting_council_member` (`id`, `committee_meeting_id`, `council_member_id`, `created_at`, `updated_at`) VALUES
(1, 1, 2, NULL, NULL),
(2, 1, 1, NULL, NULL);

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

--
-- Table structure for table `committee_meeting_user`
--

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

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

INSERT INTO `committee_meeting_user` (`id`, `committee_meeting_id`, `user_id`, `created_at`, `updated_at`) VALUES
(1, 1, 2, NULL, NULL),
(2, 1, 1, NULL, NULL);

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

--
-- Table structure for table `councils`
--

CREATE TABLE `councils` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `councils` (`id`, `name`, `start_date`, `end_date`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'المجلس الحالي', '2026-04-10', '2026-04-11', 0, '2026-04-11 18:29:06', '2026-04-11 18:44:41'),
(2, '2026-2029', '2026-04-12', NULL, 1, '2026-04-11 18:49:06', '2026-04-11 18:49:06');

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

--
-- Table structure for table `council_members`
--

CREATE TABLE `council_members` (
  `id` bigint UNSIGNED NOT NULL,
  `council_id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `position` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `council_members` (`id`, `council_id`, `name`, `position`, `created_at`, `updated_at`) VALUES
(1, 2, 'م.سعد ادريس شلالدة', 'رئيس المجلس', '2026-04-11 19:29:33', '2026-04-11 19:29:33'),
(2, 2, 'جهاد خالد طروة', 'عضو', '2026-04-11 19:29:42', '2026-04-11 19:29:42');

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

--
-- Table structure for table `council_sessions`
--

CREATE TABLE `council_sessions` (
  `id` bigint UNSIGNED NOT NULL,
  `council_id` bigint UNSIGNED NOT NULL,
  `session_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `session_date` date NOT NULL,
  `location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` enum('scheduled','completed','cancelled') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'scheduled',
  `created_by` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `council_sessions` (`id`, `council_id`, `session_number`, `title`, `session_date`, `location`, `description`, `status`, `created_by`, `created_at`, `updated_at`) VALUES
(3, 2, '1', '2026', '2026-04-14', NULL, NULL, 'scheduled', 1, '2026-04-14 06:19:54', '2026-04-14 06:19:54');

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

--
-- Table structure for table `decision_user`
--

CREATE TABLE `decision_user` (
  `id` bigint UNSIGNED NOT NULL,
  `decision_id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `status` enum('assigned','started','completed') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'assigned',
  `started_at` timestamp NULL DEFAULT NULL,
  `completed_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `decision_user` (`id`, `decision_id`, `user_id`, `status`, `started_at`, `completed_at`, `created_at`, `updated_at`) VALUES
(22, 19, 1, 'completed', '2026-04-14 06:23:16', '2026-04-14 06:23:55', '2026-04-14 06:22:09', '2026-04-14 06:23:55'),
(23, 19, 2, 'completed', NULL, '2026-04-14 06:24:57', '2026-04-14 06:22:09', '2026-04-14 06:24:57');

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

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

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

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(2, '2024_01_01_000001_create_roles_table', 1),
(3, '2024_01_01_000002_create_permissions_table', 1),
(4, '2024_01_01_000003_create_users_table', 1),
(5, '2024_01_01_000004_create_council_sessions_table', 1),
(6, '2024_01_01_000005_create_decisions_table', 1),
(7, '2024_01_01_000006_create_decision_user_table', 1),
(8, '2024_01_01_000007_create_tasks_table', 1),
(9, '2024_01_01_000008_create_comments_table', 1),
(10, '2024_01_01_000009_create_attachments_table', 1),
(11, '2024_01_01_000010_create_activity_logs_table', 1),
(12, '2024_01_01_000011_create_notifications_table', 1),
(13, '2024_01_01_000012_create_settings_table', 1),
(14, '2024_01_01_000013_create_password_resets_table', 1),
(15, '2024_01_01_000014_expand_permissions_system', 1),
(16, '2024_01_01_000015_expand_granular_permissions', 1),
(17, '2026_04_11_212152_add_term_number_to_council_sessions_table', 2),
(18, '2026_04_11_212814_create_councils_table', 3),
(19, '2026_04_11_212824_replace_term_number_with_council_id_in_council_sessions_table', 3),
(20, '2026_04_11_221810_create_council_members_table', 4),
(21, '2026_04_11_221820_create_committees_table', 4),
(22, '2026_04_11_221824_create_committee_meetings_table', 4),
(23, '2026_04_11_221848_create_committee_meeting_attendees_tables', 4),
(24, '2026_04_12_000001_create_fcm_tokens_table', 5),
(25, '2026_04_12_000002_add_missing_module_permissions', 6);

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

--
-- Table structure for table `municipality_profiles`
--

CREATE TABLE `municipality_profiles` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fax` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mayor_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `website` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `municipality_profiles` (`id`, `name`, `address`, `phone`, `email`, `fax`, `mayor_name`, `logo_path`, `description`, `website`, `created_at`, `updated_at`) VALUES
(1, 'البلدية', 'العنوان', '0599000000', 'info@municipality.gov', NULL, 'رئيس البلدية', NULL, NULL, NULL, '2026-04-11 16:25:48', '2026-04-11 16:25:48');

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

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `notifiable_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `notifiable_id` bigint UNSIGNED NOT NULL,
  `data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `sent_whatsapp` tinyint(1) NOT NULL DEFAULT '0',
  `sent_email` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `notifications` (`id`, `type`, `notifiable_type`, `notifiable_id`, `data`, `read_at`, `sent_whatsapp`, `sent_email`, `created_at`, `updated_at`) VALUES
('04fd320a-158b-49ee-a6ce-b959b5ea1105', 'App\\Notifications\\DecisionStarted', 'App\\Models\\User', 1, '{\"type\":\"decision_started\",\"decision_id\":11,\"decision_number\":\"DEC-00011\",\"title\":\"\\u0627\\u0627\\u0627\\u0627\",\"message\":\"\\u062a\\u0645 \\u0628\\u062f\\u0621 \\u062a\\u0646\\u0641\\u064a\\u0630 \\u0627\\u0644\\u0642\\u0631\\u0627\\u0631: \\u0627\\u0627\\u0627\\u0627\",\"url\":\"\\/decisions\\/11\"}', '2026-04-12 12:14:16', 0, 0, '2026-04-11 21:56:52', '2026-04-12 12:14:16'),
('0b96f562-f3eb-4eaa-8c23-8da2a1be265d', 'App\\Notifications\\DecisionCompleted', 'App\\Models\\User', 1, '{\"type\":\"decision_completed\",\"decision_id\":11,\"decision_number\":\"DEC-00011\",\"title\":\"\\u0627\\u0627\\u0627\\u0627\",\"message\":\"\\u062a\\u0645 \\u0625\\u0643\\u0645\\u0627\\u0644 \\u062a\\u0646\\u0641\\u064a\\u0630 \\u0627\\u0644\\u0642\\u0631\\u0627\\u0631: \\u0627\\u0627\\u0627\\u0627\",\"url\":\"\\/decisions\\/11\"}', '2026-04-12 12:14:16', 0, 0, '2026-04-11 21:56:59', '2026-04-12 12:14:16'),
('0e85abac-de14-4210-bb0d-2a23eaeef7a0', 'App\\Notifications\\DecisionCompleted', 'App\\Models\\User', 1, '{\"type\":\"decision_completed\",\"decision_id\":5,\"decision_number\":\"DEC-00005\",\"title\":\"\\u062b\\u062b\\u062b\\u062b\\u062b\\u062b\\u062b\\u062b\",\"message\":\"\\u062a\\u0645 \\u0625\\u0643\\u0645\\u0627\\u0644 \\u062a\\u0646\\u0641\\u064a\\u0630 \\u0627\\u0644\\u0642\\u0631\\u0627\\u0631: \\u062b\\u062b\\u062b\\u062b\\u062b\\u062b\\u062b\\u062b\",\"url\":\"\\/decisions\\/5\"}', '2026-04-11 18:16:05', 0, 0, '2026-04-11 18:15:31', '2026-04-11 18:16:05'),
('0fb5a12a-0739-458e-9f83-eeca312da96a', 'App\\Notifications\\DecisionCompleted', 'App\\Models\\User', 1, '{\"type\":\"decision_completed\",\"decision_id\":15,\"decision_number\":\"DEC-00015\",\"title\":\"gg\",\"message\":\"\\u062a\\u0645 \\u0625\\u0643\\u0645\\u0627\\u0644 \\u062a\\u0646\\u0641\\u064a\\u0630 \\u0627\\u0644\\u0642\\u0631\\u0627\\u0631: gg\",\"url\":\"\\/decisions\\/15\"}', '2026-04-12 12:14:16', 0, 0, '2026-04-12 12:14:03', '2026-04-12 12:14:16'),
('10abe6bc-1c3c-4ed0-91dc-9634c7f5b925', 'App\\Notifications\\DecisionCompleted', 'App\\Models\\User', 1, '{\"type\":\"decision_completed\",\"decision_id\":19,\"decision_number\":\"DEC-00001\",\"title\":\"\\u0627\\u0644\\u0639\\u064a\\u0646\",\"message\":\"\\u062a\\u0645 \\u0625\\u0643\\u0645\\u0627\\u0644 \\u062a\\u0646\\u0641\\u064a\\u0630 \\u0627\\u0644\\u0642\\u0631\\u0627\\u0631: \\u0627\\u0644\\u0639\\u064a\\u0646\",\"url\":\"\\/decisions\\/19\"}', NULL, 0, 0, '2026-04-14 06:24:57', '2026-04-14 06:24:57'),
('170d05ce-48bc-4eea-b193-37e15299836b', 'App\\Notifications\\DecisionCompleted', 'App\\Models\\User', 1, '{\"type\":\"decision_completed\",\"decision_id\":15,\"decision_number\":\"DEC-00015\",\"title\":\"gg\",\"message\":\"\\u062a\\u0645 \\u0625\\u0643\\u0645\\u0627\\u0644 \\u062a\\u0646\\u0641\\u064a\\u0630 \\u0627\\u0644\\u0642\\u0631\\u0627\\u0631: gg\",\"url\":\"\\/decisions\\/15\"}', '2026-04-12 12:14:16', 0, 0, '2026-04-12 12:13:54', '2026-04-12 12:14:16'),
('1e5376d2-55fd-40aa-b71b-8fae4021b61e', 'App\\Notifications\\DecisionStarted', 'App\\Models\\User', 1, '{\"type\":\"decision_started\",\"decision_id\":17,\"decision_number\":\"DEC-00017\",\"title\":\"test\",\"message\":\"\\u062a\\u0645 \\u0628\\u062f\\u0621 \\u062a\\u0646\\u0641\\u064a\\u0630 \\u0627\\u0644\\u0642\\u0631\\u0627\\u0631: test\",\"url\":\"\\/decisions\\/17\"}', NULL, 0, 0, '2026-04-12 12:26:10', '2026-04-12 12:26:10'),
('21667b2d-8fb4-459f-818c-d7acf8fafa4b', 'App\\Notifications\\DecisionStarted', 'App\\Models\\User', 1, '{\"type\":\"decision_started\",\"decision_id\":1,\"decision_number\":\"DEC-00001\",\"title\":\"\\u0627\\u0644\\u0627\\u0639\\u064a\\u0646\",\"message\":\"\\u062a\\u0645 \\u0628\\u062f\\u0621 \\u062a\\u0646\\u0641\\u064a\\u0630 \\u0627\\u0644\\u0642\\u0631\\u0627\\u0631: \\u0627\\u0644\\u0627\\u0639\\u064a\\u0646\",\"url\":\"\\/decisions\\/1\"}', '2026-04-11 17:50:42', 0, 0, '2026-04-11 17:42:43', '2026-04-11 17:50:42'),
('27368a53-edd5-4ed1-b8c9-7326ac0d225d', 'App\\Notifications\\DecisionApproved', 'App\\Models\\User', 1, '{\"type\":\"decision_approved\",\"decision_id\":18,\"decision_number\":\"DEC-00018\",\"title\":\"1111111\",\"message\":\"\\u062a\\u0645 \\u0627\\u0639\\u062a\\u0645\\u0627\\u062f \\u0627\\u0644\\u0642\\u0631\\u0627\\u0631: 1111111\",\"url\":\"\\/decisions\\/18\"}', NULL, 0, 0, '2026-04-12 12:32:29', '2026-04-12 12:32:29'),
('29ad57e9-d6dd-401a-88cf-edb73094cc97', 'App\\Notifications\\DecisionCompleted', 'App\\Models\\User', 2, '{\"type\":\"decision_completed\",\"decision_id\":8,\"decision_number\":\"DEC-00008\",\"title\":\"\\u062d\\u0641\\u0631\\u064a\\u0627\\u062a\",\"message\":\"\\u062a\\u0645 \\u0625\\u0643\\u0645\\u0627\\u0644 \\u062a\\u0646\\u0641\\u064a\\u0630 \\u0627\\u0644\\u0642\\u0631\\u0627\\u0631: \\u062d\\u0641\\u0631\\u064a\\u0627\\u062a\",\"url\":\"\\/decisions\\/8\"}', '2026-04-11 22:01:15', 0, 0, '2026-04-11 18:51:52', '2026-04-11 22:01:15'),
('2ac6f769-e90a-4bf6-a3e9-c499f04d480f', 'App\\Notifications\\DecisionAssigned', 'App\\Models\\User', 2, '{\"type\":\"decision_assigned\",\"decision_id\":19,\"decision_number\":\"DEC-00001\",\"title\":\"\\u0627\\u0644\\u0639\\u064a\\u0646\",\"message\":\"\\u062a\\u0645 \\u0625\\u0633\\u0646\\u0627\\u062f \\u0642\\u0631\\u0627\\u0631 \\u062c\\u062f\\u064a\\u062f \\u0625\\u0644\\u064a\\u0643: \\u0627\\u0644\\u0639\\u064a\\u0646\",\"url\":\"\\/decisions\\/19\"}', NULL, 0, 0, '2026-04-14 06:22:28', '2026-04-14 06:22:28'),
('2eedf9f6-9aed-419b-b8b4-15225d5fb0a5', 'App\\Notifications\\DecisionStarted', 'App\\Models\\User', 1, '{\"type\":\"decision_started\",\"decision_id\":2,\"decision_number\":\"DEC-00002\",\"title\":\"\\u0634\\u0627\\u0631\\u0639 \\u0648\\u0627\\u062f\\u064a \\u0627\\u0644\\u0634\\u0631\\u0642\",\"message\":\"\\u062a\\u0645 \\u0628\\u062f\\u0621 \\u062a\\u0646\\u0641\\u064a\\u0630 \\u0627\\u0644\\u0642\\u0631\\u0627\\u0631: \\u0634\\u0627\\u0631\\u0639 \\u0648\\u0627\\u062f\\u064a \\u0627\\u0644\\u0634\\u0631\\u0642\",\"url\":\"\\/decisions\\/2\"}', '2026-04-11 18:03:37', 0, 0, '2026-04-11 18:02:47', '2026-04-11 18:03:37'),
('3342bc49-52b8-4df9-8da7-484d8c71d653', 'App\\Notifications\\DecisionStarted', 'App\\Models\\User', 2, '{\"type\":\"decision_started\",\"decision_id\":16,\"decision_number\":\"DEC-00016\",\"title\":\"rrrrrrrrrrrr\",\"message\":\"\\u062a\\u0645 \\u0628\\u062f\\u0621 \\u062a\\u0646\\u0641\\u064a\\u0630 \\u0627\\u0644\\u0642\\u0631\\u0627\\u0631: rrrrrrrrrrrr\",\"url\":\"\\/decisions\\/16\"}', '2026-04-12 12:27:02', 0, 0, '2026-04-12 12:18:19', '2026-04-12 12:27:02'),
('36b9f8ff-02e5-46d0-b915-16c7d8a15e2c', 'App\\Notifications\\DecisionAssigned', 'App\\Models\\User', 2, '{\"type\":\"decision_assigned\",\"decision_id\":12,\"decision_number\":\"DEC-00012\",\"title\":\"\\u0647\\u0647\\u0647\\u0647\\u0647\\u0647\\u0647\\u0647\\u0647\\u0647\",\"message\":\"\\u062a\\u0645 \\u0625\\u0633\\u0646\\u0627\\u062f \\u0642\\u0631\\u0627\\u0631 \\u062c\\u062f\\u064a\\u062f \\u0625\\u0644\\u064a\\u0643: \\u0647\\u0647\\u0647\\u0647\\u0647\\u0647\\u0647\\u0647\\u0647\\u0647\",\"url\":\"\\/decisions\\/12\"}', '2026-04-11 22:01:15', 0, 0, '2026-04-11 22:00:47', '2026-04-11 22:01:15'),
('36bdf057-f164-435d-87b7-51f689344d40', 'App\\Notifications\\DecisionApproved', 'App\\Models\\User', 2, '{\"type\":\"decision_approved\",\"decision_id\":18,\"decision_number\":\"DEC-00018\",\"title\":\"1111111\",\"message\":\"\\u062a\\u0645 \\u0627\\u0639\\u062a\\u0645\\u0627\\u062f \\u0627\\u0644\\u0642\\u0631\\u0627\\u0631: 1111111\",\"url\":\"\\/decisions\\/18\"}', NULL, 0, 0, '2026-04-12 12:32:27', '2026-04-12 12:32:27'),
('3dd06507-a6de-4a10-8f21-bc71fb1effb0', 'App\\Notifications\\DecisionCompleted', 'App\\Models\\User', 2, '{\"type\":\"decision_completed\",\"decision_id\":19,\"decision_number\":\"DEC-00001\",\"title\":\"\\u0627\\u0644\\u0639\\u064a\\u0646\",\"message\":\"\\u062a\\u0645 \\u0625\\u0643\\u0645\\u0627\\u0644 \\u062a\\u0646\\u0641\\u064a\\u0630 \\u0627\\u0644\\u0642\\u0631\\u0627\\u0631: \\u0627\\u0644\\u0639\\u064a\\u0646\",\"url\":\"\\/decisions\\/19\"}', NULL, 0, 0, '2026-04-14 06:24:59', '2026-04-14 06:24:59'),
('3fb30a53-0e26-4b25-9c28-f60d897f83dc', 'App\\Notifications\\DecisionStarted', 'App\\Models\\User', 2, '{\"type\":\"decision_started\",\"decision_id\":11,\"decision_number\":\"DEC-00011\",\"title\":\"\\u0627\\u0627\\u0627\\u0627\",\"message\":\"\\u062a\\u0645 \\u0628\\u062f\\u0621 \\u062a\\u0646\\u0641\\u064a\\u0630 \\u0627\\u0644\\u0642\\u0631\\u0627\\u0631: \\u0627\\u0627\\u0627\\u0627\",\"url\":\"\\/decisions\\/11\"}', '2026-04-11 22:01:15', 0, 0, '2026-04-11 21:56:49', '2026-04-11 22:01:15'),
('4140e4b3-ea8a-42f7-bccf-e0c59e47c253', 'App\\Notifications\\DecisionAssigned', 'App\\Models\\User', 2, '{\"type\":\"decision_assigned\",\"decision_id\":7,\"decision_number\":\"DEC-00007\",\"title\":\"ddd\",\"message\":\"\\u062a\\u0645 \\u0625\\u0633\\u0646\\u0627\\u062f \\u0642\\u0631\\u0627\\u0631 \\u062c\\u062f\\u064a\\u062f \\u0625\\u0644\\u064a\\u0643: ddd\",\"url\":\"\\/decisions\\/7\"}', '2026-04-11 22:01:15', 0, 0, '2026-04-11 18:12:41', '2026-04-11 22:01:15'),
('41a91864-b60f-411c-9f14-479cd3b527ed', 'App\\Notifications\\DecisionAssigned', 'App\\Models\\User', 1, '{\"type\":\"decision_assigned\",\"decision_id\":4,\"decision_number\":\"DEC-00004\",\"title\":\"ssssss\",\"message\":\"\\u062a\\u0645 \\u0625\\u0633\\u0646\\u0627\\u062f \\u0642\\u0631\\u0627\\u0631 \\u062c\\u062f\\u064a\\u062f \\u0625\\u0644\\u064a\\u0643: ssssss\",\"url\":\"\\/decisions\\/4\"}', '2026-04-11 18:03:37', 0, 0, '2026-04-11 18:03:22', '2026-04-11 18:03:37'),
('49c600aa-2243-4690-abde-e605cc07e540', 'App\\Notifications\\DecisionStarted', 'App\\Models\\User', 2, '{\"type\":\"decision_started\",\"decision_id\":8,\"decision_number\":\"DEC-00008\",\"title\":\"\\u062d\\u0641\\u0631\\u064a\\u0627\\u062a\",\"message\":\"\\u062a\\u0645 \\u0628\\u062f\\u0621 \\u062a\\u0646\\u0641\\u064a\\u0630 \\u0627\\u0644\\u0642\\u0631\\u0627\\u0631: \\u062d\\u0641\\u0631\\u064a\\u0627\\u062a\",\"url\":\"\\/decisions\\/8\"}', '2026-04-11 22:01:15', 0, 0, '2026-04-11 18:51:41', '2026-04-11 22:01:15'),
('49c82664-615c-4811-a70d-400026c0df14', 'App\\Notifications\\DecisionStarted', 'App\\Models\\User', 1, '{\"type\":\"decision_started\",\"decision_id\":5,\"decision_number\":\"DEC-00005\",\"title\":\"\\u062b\\u062b\\u062b\\u062b\\u062b\\u062b\\u062b\\u062b\",\"message\":\"\\u062a\\u0645 \\u0628\\u062f\\u0621 \\u062a\\u0646\\u0641\\u064a\\u0630 \\u0627\\u0644\\u0642\\u0631\\u0627\\u0631: \\u062b\\u062b\\u062b\\u062b\\u062b\\u062b\\u062b\\u062b\",\"url\":\"\\/decisions\\/5\"}', '2026-04-11 18:16:05', 0, 0, '2026-04-11 18:15:26', '2026-04-11 18:16:05'),
('514f9479-1037-4361-ace0-daa60071ea3d', 'App\\Notifications\\DecisionCompleted', 'App\\Models\\User', 2, '{\"type\":\"decision_completed\",\"decision_id\":18,\"decision_number\":\"DEC-00018\",\"title\":\"1111111\",\"message\":\"\\u062a\\u0645 \\u0625\\u0643\\u0645\\u0627\\u0644 \\u062a\\u0646\\u0641\\u064a\\u0630 \\u0627\\u0644\\u0642\\u0631\\u0627\\u0631: 1111111\",\"url\":\"\\/decisions\\/18\"}', NULL, 0, 0, '2026-04-12 12:32:11', '2026-04-12 12:32:11'),
('52aadc5a-6eef-4c01-a9fc-949b37405020', 'App\\Notifications\\DecisionAssigned', 'App\\Models\\User', 2, '{\"type\":\"decision_assigned\",\"decision_id\":8,\"decision_number\":\"DEC-00008\",\"title\":\"\\u062d\\u0641\\u0631\\u064a\\u0627\\u062a\",\"message\":\"\\u062a\\u0645 \\u0625\\u0633\\u0646\\u0627\\u062f \\u0642\\u0631\\u0627\\u0631 \\u062c\\u062f\\u064a\\u062f \\u0625\\u0644\\u064a\\u0643: \\u062d\\u0641\\u0631\\u064a\\u0627\\u062a\",\"url\":\"\\/decisions\\/8\"}', '2026-04-11 22:01:15', 0, 0, '2026-04-11 18:37:51', '2026-04-11 22:01:15'),
('551f3765-ba19-4117-961d-0cdbe9477e04', 'App\\Notifications\\DecisionCompleted', 'App\\Models\\User', 1, '{\"type\":\"decision_completed\",\"decision_id\":18,\"decision_number\":\"DEC-00018\",\"title\":\"1111111\",\"message\":\"\\u062a\\u0645 \\u0625\\u0643\\u0645\\u0627\\u0644 \\u062a\\u0646\\u0641\\u064a\\u0630 \\u0627\\u0644\\u0642\\u0631\\u0627\\u0631: 1111111\",\"url\":\"\\/decisions\\/18\"}', NULL, 0, 0, '2026-04-12 12:32:13', '2026-04-12 12:32:13'),
('57cae341-0946-4d44-87dc-d49f9d4a93a7', 'App\\Notifications\\DecisionStarted', 'App\\Models\\User', 2, '{\"type\":\"decision_started\",\"decision_id\":17,\"decision_number\":\"DEC-00017\",\"title\":\"test\",\"message\":\"\\u062a\\u0645 \\u0628\\u062f\\u0621 \\u062a\\u0646\\u0641\\u064a\\u0630 \\u0627\\u0644\\u0642\\u0631\\u0627\\u0631: test\",\"url\":\"\\/decisions\\/17\"}', '2026-04-12 12:27:02', 0, 0, '2026-04-12 12:26:07', '2026-04-12 12:27:02'),
('588cdb62-283b-408b-8b38-868e1eb44ee9', 'App\\Notifications\\DecisionCompleted', 'App\\Models\\User', 2, '{\"type\":\"decision_completed\",\"decision_id\":11,\"decision_number\":\"DEC-00011\",\"title\":\"\\u0627\\u0627\\u0627\\u0627\",\"message\":\"\\u062a\\u0645 \\u0625\\u0643\\u0645\\u0627\\u0644 \\u062a\\u0646\\u0641\\u064a\\u0630 \\u0627\\u0644\\u0642\\u0631\\u0627\\u0631: \\u0627\\u0627\\u0627\\u0627\",\"url\":\"\\/decisions\\/11\"}', '2026-04-11 22:01:15', 0, 0, '2026-04-11 21:57:16', '2026-04-11 22:01:15'),
('58f79b19-b47f-498c-a961-4b30f841d038', 'App\\Notifications\\DecisionCompleted', 'App\\Models\\User', 2, '{\"type\":\"decision_completed\",\"decision_id\":15,\"decision_number\":\"DEC-00015\",\"title\":\"gg\",\"message\":\"\\u062a\\u0645 \\u0625\\u0643\\u0645\\u0627\\u0644 \\u062a\\u0646\\u0641\\u064a\\u0630 \\u0627\\u0644\\u0642\\u0631\\u0627\\u0631: gg\",\"url\":\"\\/decisions\\/15\"}', '2026-04-12 12:27:02', 0, 0, '2026-04-12 12:13:52', '2026-04-12 12:27:02'),
('5b60d500-6a3a-467d-9754-708f99892573', 'App\\Notifications\\DecisionCompleted', 'App\\Models\\User', 1, '{\"type\":\"decision_completed\",\"decision_id\":11,\"decision_number\":\"DEC-00011\",\"title\":\"\\u0627\\u0627\\u0627\\u0627\",\"message\":\"\\u062a\\u0645 \\u0625\\u0643\\u0645\\u0627\\u0644 \\u062a\\u0646\\u0641\\u064a\\u0630 \\u0627\\u0644\\u0642\\u0631\\u0627\\u0631: \\u0627\\u0627\\u0627\\u0627\",\"url\":\"\\/decisions\\/11\"}', '2026-04-12 12:14:16', 0, 0, '2026-04-11 21:57:19', '2026-04-12 12:14:16'),
('5bd42260-e832-41d5-914e-6e902386f5a2', 'App\\Notifications\\DecisionStarted', 'App\\Models\\User', 1, '{\"type\":\"decision_started\",\"decision_id\":18,\"decision_number\":\"DEC-00018\",\"title\":\"1111111\",\"message\":\"\\u062a\\u0645 \\u0628\\u062f\\u0621 \\u062a\\u0646\\u0641\\u064a\\u0630 \\u0627\\u0644\\u0642\\u0631\\u0627\\u0631: 1111111\",\"url\":\"\\/decisions\\/18\"}', NULL, 0, 0, '2026-04-12 12:30:41', '2026-04-12 12:30:41'),
('5c6e68f4-0a00-4e18-a6a4-d4ff9de2e149', 'App\\Notifications\\DecisionApproved', 'App\\Models\\User', 1, '{\"type\":\"decision_approved\",\"decision_id\":5,\"decision_number\":\"DEC-00005\",\"title\":\"\\u062b\\u062b\\u062b\\u062b\\u062b\\u062b\\u062b\\u062b\",\"message\":\"\\u062a\\u0645 \\u0627\\u0639\\u062a\\u0645\\u0627\\u062f \\u0627\\u0644\\u0642\\u0631\\u0627\\u0631: \\u062b\\u062b\\u062b\\u062b\\u062b\\u062b\\u062b\\u062b\",\"url\":\"\\/decisions\\/5\"}', '2026-04-11 18:16:05', 0, 0, '2026-04-11 18:15:36', '2026-04-11 18:16:05'),
('62b26f15-3f21-40db-b608-6a7e1f347231', 'App\\Notifications\\DecisionApproved', 'App\\Models\\User', 1, '{\"type\":\"decision_approved\",\"decision_id\":19,\"decision_number\":\"DEC-00001\",\"title\":\"\\u0627\\u0644\\u0639\\u064a\\u0646\",\"message\":\"\\u062a\\u0645 \\u0627\\u0639\\u062a\\u0645\\u0627\\u062f \\u0627\\u0644\\u0642\\u0631\\u0627\\u0631: \\u0627\\u0644\\u0639\\u064a\\u0646\",\"url\":\"\\/decisions\\/19\"}', NULL, 0, 0, '2026-04-14 06:25:36', '2026-04-14 06:25:36'),
('6a7df2a5-2ec7-40fd-b52b-e17b1535167b', 'App\\Notifications\\DecisionAssigned', 'App\\Models\\User', 2, '{\"type\":\"decision_assigned\",\"decision_id\":16,\"decision_number\":\"DEC-00016\",\"title\":\"rrrrrrrrrrrr\",\"message\":\"\\u062a\\u0645 \\u0625\\u0633\\u0646\\u0627\\u062f \\u0642\\u0631\\u0627\\u0631 \\u062c\\u062f\\u064a\\u062f \\u0625\\u0644\\u064a\\u0643: rrrrrrrrrrrr\",\"url\":\"\\/decisions\\/16\"}', '2026-04-12 12:27:02', 0, 0, '2026-04-12 12:14:42', '2026-04-12 12:27:02'),
('6b8947c0-7caf-48c9-b710-afe652a325a2', 'App\\Notifications\\DecisionCompleted', 'App\\Models\\User', 2, '{\"type\":\"decision_completed\",\"decision_id\":15,\"decision_number\":\"DEC-00015\",\"title\":\"gg\",\"message\":\"\\u062a\\u0645 \\u0625\\u0643\\u0645\\u0627\\u0644 \\u062a\\u0646\\u0641\\u064a\\u0630 \\u0627\\u0644\\u0642\\u0631\\u0627\\u0631: gg\",\"url\":\"\\/decisions\\/15\"}', '2026-04-12 12:27:02', 0, 0, '2026-04-12 12:14:01', '2026-04-12 12:27:02'),
('6e770ff0-50ba-4959-b6a2-ab5b3a1b05cc', 'App\\Notifications\\DecisionStarted', 'App\\Models\\User', 1, '{\"type\":\"decision_started\",\"decision_id\":15,\"decision_number\":\"DEC-00015\",\"title\":\"gg\",\"message\":\"\\u062a\\u0645 \\u0628\\u062f\\u0621 \\u062a\\u0646\\u0641\\u064a\\u0630 \\u0627\\u0644\\u0642\\u0631\\u0627\\u0631: gg\",\"url\":\"\\/decisions\\/15\"}', '2026-04-12 12:14:16', 0, 0, '2026-04-12 12:13:21', '2026-04-12 12:14:16'),
('7b29cec6-58d5-470a-b0ee-b728c19c05a2', 'App\\Notifications\\DecisionCompleted', 'App\\Models\\User', 2, '{\"type\":\"decision_completed\",\"decision_id\":11,\"decision_number\":\"DEC-00011\",\"title\":\"\\u0627\\u0627\\u0627\\u0627\",\"message\":\"\\u062a\\u0645 \\u0625\\u0643\\u0645\\u0627\\u0644 \\u062a\\u0646\\u0641\\u064a\\u0630 \\u0627\\u0644\\u0642\\u0631\\u0627\\u0631: \\u0627\\u0627\\u0627\\u0627\",\"url\":\"\\/decisions\\/11\"}', '2026-04-11 22:01:15', 0, 0, '2026-04-11 21:56:57', '2026-04-11 22:01:15'),
('8878f3bb-1adb-44de-9525-bcd81e34a67a', 'App\\Notifications\\DecisionCompleted', 'App\\Models\\User', 1, '{\"type\":\"decision_completed\",\"decision_id\":8,\"decision_number\":\"DEC-00008\",\"title\":\"\\u062d\\u0641\\u0631\\u064a\\u0627\\u062a\",\"message\":\"\\u062a\\u0645 \\u0625\\u0643\\u0645\\u0627\\u0644 \\u062a\\u0646\\u0641\\u064a\\u0630 \\u0627\\u0644\\u0642\\u0631\\u0627\\u0631: \\u062d\\u0641\\u0631\\u064a\\u0627\\u062a\",\"url\":\"\\/decisions\\/8\"}', '2026-04-12 12:14:16', 0, 0, '2026-04-11 18:52:19', '2026-04-12 12:14:16'),
('8dfc028d-def0-4c6a-b855-1f25fa98c8d1', 'App\\Notifications\\DecisionStarted', 'App\\Models\\User', 2, '{\"type\":\"decision_started\",\"decision_id\":18,\"decision_number\":\"DEC-00018\",\"title\":\"1111111\",\"message\":\"\\u062a\\u0645 \\u0628\\u062f\\u0621 \\u062a\\u0646\\u0641\\u064a\\u0630 \\u0627\\u0644\\u0642\\u0631\\u0627\\u0631: 1111111\",\"url\":\"\\/decisions\\/18\"}', NULL, 0, 0, '2026-04-12 12:30:38', '2026-04-12 12:30:38'),
('909455db-a5b9-48f6-9fde-2b74351e5d77', 'App\\Notifications\\DecisionAssigned', 'App\\Models\\User', 1, '{\"type\":\"decision_assigned\",\"decision_id\":5,\"decision_number\":\"DEC-00005\",\"title\":\"\\u062b\\u062b\\u062b\\u062b\\u062b\\u062b\\u062b\\u062b\",\"message\":\"\\u062a\\u0645 \\u0625\\u0633\\u0646\\u0627\\u062f \\u0642\\u0631\\u0627\\u0631 \\u062c\\u062f\\u064a\\u062f \\u0625\\u0644\\u064a\\u0643: \\u062b\\u062b\\u062b\\u062b\\u062b\\u062b\\u062b\\u062b\",\"url\":\"\\/decisions\\/5\"}', '2026-04-11 18:16:05', 0, 0, '2026-04-11 18:06:11', '2026-04-11 18:16:05'),
('95df791a-381a-4d6a-9ad4-8225180870f5', 'App\\Notifications\\DecisionAssigned', 'App\\Models\\User', 1, '{\"type\":\"decision_assigned\",\"decision_id\":10,\"decision_number\":\"DEC-00010\",\"title\":\"\\u062a\\u0627\\u0645\\u0631\",\"message\":\"\\u062a\\u0645 \\u0625\\u0633\\u0646\\u0627\\u062f \\u0642\\u0631\\u0627\\u0631 \\u062c\\u062f\\u064a\\u062f \\u0625\\u0644\\u064a\\u0643: \\u062a\\u0627\\u0645\\u0631\",\"url\":\"\\/decisions\\/10\"}', '2026-04-12 12:14:16', 0, 0, '2026-04-11 21:54:01', '2026-04-12 12:14:16'),
('9d576b57-65d5-406b-a471-18b68ad0389e', 'App\\Notifications\\DecisionStarted', 'App\\Models\\User', 2, '{\"type\":\"decision_started\",\"decision_id\":15,\"decision_number\":\"DEC-00015\",\"title\":\"gg\",\"message\":\"\\u062a\\u0645 \\u0628\\u062f\\u0621 \\u062a\\u0646\\u0641\\u064a\\u0630 \\u0627\\u0644\\u0642\\u0631\\u0627\\u0631: gg\",\"url\":\"\\/decisions\\/15\"}', '2026-04-12 12:27:02', 0, 0, '2026-04-12 12:13:19', '2026-04-12 12:27:02'),
('a0df9bc8-ff63-48cb-b3fa-6a9a1c7bd03c', 'App\\Notifications\\DecisionCompleted', 'App\\Models\\User', 1, '{\"type\":\"decision_completed\",\"decision_id\":19,\"decision_number\":\"DEC-00001\",\"title\":\"\\u0627\\u0644\\u0639\\u064a\\u0646\",\"message\":\"\\u062a\\u0645 \\u0625\\u0643\\u0645\\u0627\\u0644 \\u062a\\u0646\\u0641\\u064a\\u0630 \\u0627\\u0644\\u0642\\u0631\\u0627\\u0631: \\u0627\\u0644\\u0639\\u064a\\u0646\",\"url\":\"\\/decisions\\/19\"}', NULL, 0, 0, '2026-04-14 06:23:55', '2026-04-14 06:23:55'),
('a6fc68b3-26a3-4ecc-a63a-ebf84c501ee7', 'App\\Notifications\\DecisionAssigned', 'App\\Models\\User', 1, '{\"type\":\"decision_assigned\",\"decision_id\":19,\"decision_number\":\"DEC-00001\",\"title\":\"\\u0627\\u0644\\u0639\\u064a\\u0646\",\"message\":\"\\u062a\\u0645 \\u0625\\u0633\\u0646\\u0627\\u062f \\u0642\\u0631\\u0627\\u0631 \\u062c\\u062f\\u064a\\u062f \\u0625\\u0644\\u064a\\u0643: \\u0627\\u0644\\u0639\\u064a\\u0646\",\"url\":\"\\/decisions\\/19\"}', NULL, 0, 0, '2026-04-14 06:22:12', '2026-04-14 06:22:12'),
('a89e38a0-c42f-4e7a-975c-faa3366651dc', 'App\\Notifications\\DecisionAssigned', 'App\\Models\\User', 2, '{\"type\":\"decision_assigned\",\"decision_id\":17,\"decision_number\":\"DEC-00017\",\"title\":\"test\",\"message\":\"\\u062a\\u0645 \\u0625\\u0633\\u0646\\u0627\\u062f \\u0642\\u0631\\u0627\\u0631 \\u062c\\u062f\\u064a\\u062f \\u0625\\u0644\\u064a\\u0643: test\",\"url\":\"\\/decisions\\/17\"}', '2026-04-12 12:27:02', 0, 0, '2026-04-12 12:24:48', '2026-04-12 12:27:02'),
('b188aae5-41ff-4a4d-894b-d51c25829951', 'App\\Notifications\\DecisionAssigned', 'App\\Models\\User', 2, '{\"type\":\"decision_assigned\",\"decision_id\":14,\"decision_number\":\"DEC-00014\",\"title\":\"jjjjjjjjjjj\",\"message\":\"\\u062a\\u0645 \\u0625\\u0633\\u0646\\u0627\\u062f \\u0642\\u0631\\u0627\\u0631 \\u062c\\u062f\\u064a\\u062f \\u0625\\u0644\\u064a\\u0643: jjjjjjjjjjj\",\"url\":\"\\/decisions\\/14\"}', '2026-04-12 12:27:02', 0, 0, '2026-04-12 12:10:36', '2026-04-12 12:27:02'),
('b2191ee2-5397-49f2-8a10-86b62b6c8fc9', 'App\\Notifications\\DecisionAssigned', 'App\\Models\\User', 2, '{\"type\":\"decision_assigned\",\"decision_id\":18,\"decision_number\":\"DEC-00018\",\"title\":\"1111111\",\"message\":\"\\u062a\\u0645 \\u0625\\u0633\\u0646\\u0627\\u062f \\u0642\\u0631\\u0627\\u0631 \\u062c\\u062f\\u064a\\u062f \\u0625\\u0644\\u064a\\u0643: 1111111\",\"url\":\"\\/decisions\\/18\"}', NULL, 0, 0, '2026-04-12 12:27:27', '2026-04-12 12:27:27'),
('b8d44af0-7f07-4cda-adb3-3a5e8273fd58', 'App\\Notifications\\DecisionApproved', 'App\\Models\\User', 1, '{\"type\":\"decision_approved\",\"decision_id\":8,\"decision_number\":\"DEC-00008\",\"title\":\"\\u062d\\u0641\\u0631\\u064a\\u0627\\u062a\",\"message\":\"\\u062a\\u0645 \\u0627\\u0639\\u062a\\u0645\\u0627\\u062f \\u0627\\u0644\\u0642\\u0631\\u0627\\u0631: \\u062d\\u0641\\u0631\\u064a\\u0627\\u062a\",\"url\":\"\\/decisions\\/8\"}', '2026-04-12 12:14:16', 0, 0, '2026-04-11 18:52:23', '2026-04-12 12:14:16'),
('c252e72f-92ea-4abc-ab26-91e191aeec45', 'App\\Notifications\\DecisionStarted', 'App\\Models\\User', 1, '{\"type\":\"decision_started\",\"decision_id\":16,\"decision_number\":\"DEC-00016\",\"title\":\"rrrrrrrrrrrr\",\"message\":\"\\u062a\\u0645 \\u0628\\u062f\\u0621 \\u062a\\u0646\\u0641\\u064a\\u0630 \\u0627\\u0644\\u0642\\u0631\\u0627\\u0631: rrrrrrrrrrrr\",\"url\":\"\\/decisions\\/16\"}', NULL, 0, 0, '2026-04-12 12:18:21', '2026-04-12 12:18:21'),
('c5f47a8c-4849-44ac-8db8-30c975964a8e', 'App\\Notifications\\DecisionAssigned', 'App\\Models\\User', 1, '{\"type\":\"decision_assigned\",\"decision_id\":3,\"decision_number\":\"DEC-00003\",\"title\":\"e\",\"message\":\"\\u062a\\u0645 \\u0625\\u0633\\u0646\\u0627\\u062f \\u0642\\u0631\\u0627\\u0631 \\u062c\\u062f\\u064a\\u062f \\u0625\\u0644\\u064a\\u0643: e\",\"url\":\"\\/decisions\\/3\"}', '2026-04-11 17:53:20', 0, 0, '2026-04-11 17:51:07', '2026-04-11 17:53:20'),
('ca6573a0-f120-43aa-9bf4-e84c5f5c22b4', 'App\\Notifications\\DecisionAssigned', 'App\\Models\\User', 1, '{\"type\":\"decision_assigned\",\"decision_id\":1,\"decision_number\":\"DEC-00001\",\"title\":\"\\u0627\\u0644\\u0627\\u0639\\u064a\\u0646\",\"message\":\"\\u062a\\u0645 \\u0625\\u0633\\u0646\\u0627\\u062f \\u0642\\u0631\\u0627\\u0631 \\u062c\\u062f\\u064a\\u062f \\u0625\\u0644\\u064a\\u0643: \\u0627\\u0644\\u0627\\u0639\\u064a\\u0646\",\"url\":\"\\/decisions\\/1\"}', '2026-04-11 17:50:42', 0, 0, '2026-04-11 17:41:34', '2026-04-11 17:50:42'),
('ce7be5ac-4c1b-47ef-95b5-fc1809bd7c3e', 'App\\Notifications\\DecisionAssigned', 'App\\Models\\User', 2, '{\"type\":\"decision_assigned\",\"decision_id\":10,\"decision_number\":\"DEC-00010\",\"title\":\"\\u062a\\u0627\\u0645\\u0631\",\"message\":\"\\u062a\\u0645 \\u0625\\u0633\\u0646\\u0627\\u062f \\u0642\\u0631\\u0627\\u0631 \\u062c\\u062f\\u064a\\u062f \\u0625\\u0644\\u064a\\u0643: \\u062a\\u0627\\u0645\\u0631\",\"url\":\"\\/decisions\\/10\"}', '2026-04-11 22:01:15', 0, 0, '2026-04-11 21:54:05', '2026-04-11 22:01:15'),
('d18be84b-85c2-402d-a657-18b79c2ebeb5', 'App\\Notifications\\DecisionAssigned', 'App\\Models\\User', 1, '{\"type\":\"decision_assigned\",\"decision_id\":2,\"decision_number\":\"DEC-00002\",\"title\":\"\\u0634\\u0627\\u0631\\u0639 \\u0648\\u0627\\u062f\\u064a \\u0627\\u0644\\u0634\\u0631\\u0642\",\"message\":\"\\u062a\\u0645 \\u0625\\u0633\\u0646\\u0627\\u062f \\u0642\\u0631\\u0627\\u0631 \\u062c\\u062f\\u064a\\u062f \\u0625\\u0644\\u064a\\u0643: \\u0634\\u0627\\u0631\\u0639 \\u0648\\u0627\\u062f\\u064a \\u0627\\u0644\\u0634\\u0631\\u0642\",\"url\":\"\\/decisions\\/2\"}', '2026-04-11 17:50:42', 0, 0, '2026-04-11 17:43:43', '2026-04-11 17:50:42'),
('dba3ff01-2b36-4162-858b-41e9cbd171aa', 'App\\Notifications\\DecisionCompleted', 'App\\Models\\User', 2, '{\"type\":\"decision_completed\",\"decision_id\":8,\"decision_number\":\"DEC-00008\",\"title\":\"\\u062d\\u0641\\u0631\\u064a\\u0627\\u062a\",\"message\":\"\\u062a\\u0645 \\u0625\\u0643\\u0645\\u0627\\u0644 \\u062a\\u0646\\u0641\\u064a\\u0630 \\u0627\\u0644\\u0642\\u0631\\u0627\\u0631: \\u062d\\u0641\\u0631\\u064a\\u0627\\u062a\",\"url\":\"\\/decisions\\/8\"}', '2026-04-11 22:01:15', 0, 0, '2026-04-11 18:51:45', '2026-04-11 22:01:15'),
('decec281-586b-4c81-9dd4-08f4a87adc40', 'App\\Notifications\\DecisionStarted', 'App\\Models\\User', 1, '{\"type\":\"decision_started\",\"decision_id\":19,\"decision_number\":\"DEC-00001\",\"title\":\"\\u0627\\u0644\\u0639\\u064a\\u0646\",\"message\":\"\\u062a\\u0645 \\u0628\\u062f\\u0621 \\u062a\\u0646\\u0641\\u064a\\u0630 \\u0627\\u0644\\u0642\\u0631\\u0627\\u0631: \\u0627\\u0644\\u0639\\u064a\\u0646\",\"url\":\"\\/decisions\\/19\"}', NULL, 0, 0, '2026-04-14 06:23:16', '2026-04-14 06:23:16'),
('e1eed3b1-fb4d-4889-adb9-fc6f4caeae8e', 'App\\Notifications\\DecisionAssigned', 'App\\Models\\User', 1, '{\"type\":\"decision_assigned\",\"decision_id\":9,\"decision_number\":\"DEC-00009\",\"title\":\"\\u0642\\u0642\\u0642\\u0642\\u0642\",\"message\":\"\\u062a\\u0645 \\u0625\\u0633\\u0646\\u0627\\u062f \\u0642\\u0631\\u0627\\u0631 \\u062c\\u062f\\u064a\\u062f \\u0625\\u0644\\u064a\\u0643: \\u0642\\u0642\\u0642\\u0642\\u0642\",\"url\":\"\\/decisions\\/9\"}', '2026-04-12 12:14:16', 0, 0, '2026-04-11 20:40:20', '2026-04-12 12:14:16'),
('ec4a34ad-c3d5-40d6-b86c-a18a636325c8', 'App\\Notifications\\DecisionAssigned', 'App\\Models\\User', 2, '{\"type\":\"decision_assigned\",\"decision_id\":15,\"decision_number\":\"DEC-00015\",\"title\":\"gg\",\"message\":\"\\u062a\\u0645 \\u0625\\u0633\\u0646\\u0627\\u062f \\u0642\\u0631\\u0627\\u0631 \\u062c\\u062f\\u064a\\u062f \\u0625\\u0644\\u064a\\u0643: gg\",\"url\":\"\\/decisions\\/15\"}', '2026-04-12 12:27:02', 0, 0, '2026-04-12 12:11:56', '2026-04-12 12:27:02'),
('f147ef06-6eef-4469-a75f-10c9753d84b6', 'App\\Notifications\\DecisionStarted', 'App\\Models\\User', 2, '{\"type\":\"decision_started\",\"decision_id\":19,\"decision_number\":\"DEC-00001\",\"title\":\"\\u0627\\u0644\\u0639\\u064a\\u0646\",\"message\":\"\\u062a\\u0645 \\u0628\\u062f\\u0621 \\u062a\\u0646\\u0641\\u064a\\u0630 \\u0627\\u0644\\u0642\\u0631\\u0627\\u0631: \\u0627\\u0644\\u0639\\u064a\\u0646\",\"url\":\"\\/decisions\\/19\"}', NULL, 0, 0, '2026-04-14 06:23:19', '2026-04-14 06:23:19'),
('f2d1a98c-1d71-46ce-9390-97a2e0e4ed0c', 'App\\Notifications\\DecisionApproved', 'App\\Models\\User', 2, '{\"type\":\"decision_approved\",\"decision_id\":19,\"decision_number\":\"DEC-00001\",\"title\":\"\\u0627\\u0644\\u0639\\u064a\\u0646\",\"message\":\"\\u062a\\u0645 \\u0627\\u0639\\u062a\\u0645\\u0627\\u062f \\u0627\\u0644\\u0642\\u0631\\u0627\\u0631: \\u0627\\u0644\\u0639\\u064a\\u0646\",\"url\":\"\\/decisions\\/19\"}', NULL, 0, 0, '2026-04-14 06:25:38', '2026-04-14 06:25:38'),
('f4680dad-e5d3-4bde-b49c-74205489df42', 'App\\Notifications\\DecisionAssigned', 'App\\Models\\User', 2, '{\"type\":\"decision_assigned\",\"decision_id\":13,\"decision_number\":\"DEC-00013\",\"title\":\"ii\",\"message\":\"\\u062a\\u0645 \\u0625\\u0633\\u0646\\u0627\\u062f \\u0642\\u0631\\u0627\\u0631 \\u062c\\u062f\\u064a\\u062f \\u0625\\u0644\\u064a\\u0643: ii\",\"url\":\"\\/decisions\\/13\"}', '2026-04-12 12:27:02', 0, 0, '2026-04-11 22:08:04', '2026-04-12 12:27:02'),
('f6c4b90c-2901-482f-b355-fc5cc8c55e29', 'App\\Notifications\\DecisionCompleted', 'App\\Models\\User', 2, '{\"type\":\"decision_completed\",\"decision_id\":8,\"decision_number\":\"DEC-00008\",\"title\":\"\\u062d\\u0641\\u0631\\u064a\\u0627\\u062a\",\"message\":\"\\u062a\\u0645 \\u0625\\u0643\\u0645\\u0627\\u0644 \\u062a\\u0646\\u0641\\u064a\\u0630 \\u0627\\u0644\\u0642\\u0631\\u0627\\u0631: \\u062d\\u0641\\u0631\\u064a\\u0627\\u062a\",\"url\":\"\\/decisions\\/8\"}', '2026-04-11 22:01:15', 0, 0, '2026-04-11 18:51:59', '2026-04-11 22:01:15'),
('f7c213c6-021d-4c47-a2bf-1b4d27e922b3', 'App\\Notifications\\DecisionAssigned', 'App\\Models\\User', 2, '{\"type\":\"decision_assigned\",\"decision_id\":11,\"decision_number\":\"DEC-00011\",\"title\":\"\\u0627\\u0627\\u0627\\u0627\",\"message\":\"\\u062a\\u0645 \\u0625\\u0633\\u0646\\u0627\\u062f \\u0642\\u0631\\u0627\\u0631 \\u062c\\u062f\\u064a\\u062f \\u0625\\u0644\\u064a\\u0643: \\u0627\\u0627\\u0627\\u0627\",\"url\":\"\\/decisions\\/11\"}', '2026-04-11 22:01:15', 0, 0, '2026-04-11 21:56:41', '2026-04-11 22:01:15'),
('f9902b30-8cb6-4798-bb89-4495fc05e9c9', 'App\\Notifications\\DecisionCompleted', 'App\\Models\\User', 2, '{\"type\":\"decision_completed\",\"decision_id\":19,\"decision_number\":\"DEC-00001\",\"title\":\"\\u0627\\u0644\\u0639\\u064a\\u0646\",\"message\":\"\\u062a\\u0645 \\u0625\\u0643\\u0645\\u0627\\u0644 \\u062a\\u0646\\u0641\\u064a\\u0630 \\u0627\\u0644\\u0642\\u0631\\u0627\\u0631: \\u0627\\u0644\\u0639\\u064a\\u0646\",\"url\":\"\\/decisions\\/19\"}', NULL, 0, 0, '2026-04-14 06:23:58', '2026-04-14 06:23:58'),
('fab977c9-25d8-4733-9227-5bd6d5f2cc85', 'App\\Notifications\\DecisionAssigned', 'App\\Models\\User', 2, '{\"type\":\"decision_assigned\",\"decision_id\":9,\"decision_number\":\"DEC-00009\",\"title\":\"\\u0642\\u0642\\u0642\\u0642\\u0642\",\"message\":\"\\u062a\\u0645 \\u0625\\u0633\\u0646\\u0627\\u062f \\u0642\\u0631\\u0627\\u0631 \\u062c\\u062f\\u064a\\u062f \\u0625\\u0644\\u064a\\u0643: \\u0642\\u0642\\u0642\\u0642\\u0642\",\"url\":\"\\/decisions\\/9\"}', '2026-04-11 22:01:15', 0, 0, '2026-04-11 20:40:41', '2026-04-11 22:01:15'),
('fadfc26e-5882-4a24-930d-d88d9f8ca60a', 'App\\Notifications\\DecisionAssigned', 'App\\Models\\User', 2, '{\"type\":\"decision_assigned\",\"decision_id\":6,\"decision_number\":\"DEC-00006\",\"title\":\"qqqqqqq\",\"message\":\"\\u062a\\u0645 \\u0625\\u0633\\u0646\\u0627\\u062f \\u0642\\u0631\\u0627\\u0631 \\u062c\\u062f\\u064a\\u062f \\u0625\\u0644\\u064a\\u0643: qqqqqqq\",\"url\":\"\\/decisions\\/6\"}', '2026-04-11 22:01:15', 0, 0, '2026-04-11 18:08:06', '2026-04-11 22:01:15');

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

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

CREATE TABLE `permissions` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `group_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'view',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `permissions` (`id`, `name`, `slug`, `group_name`, `type`, `description`, `created_at`, `updated_at`) VALUES
(1, 'إضافة جلسة', 'sessions.create', 'الجلسات', 'action', NULL, '2026-04-11 16:24:59', '2026-04-11 16:24:59'),
(2, 'تعديل جلسة', 'sessions.edit', 'الجلسات', 'action', NULL, '2026-04-11 16:24:59', '2026-04-11 16:24:59'),
(3, 'حذف جلسة', 'sessions.delete', 'الجلسات', 'action', NULL, '2026-04-11 16:24:59', '2026-04-11 16:24:59'),
(4, 'إضافة قرار', 'decisions.create', 'القرارات', 'action', NULL, '2026-04-11 16:24:59', '2026-04-11 16:24:59'),
(5, 'تعديل قرار', 'decisions.edit', 'القرارات', 'action', NULL, '2026-04-11 16:24:59', '2026-04-11 16:24:59'),
(6, 'حذف قرار', 'decisions.delete', 'القرارات', 'action', NULL, '2026-04-11 16:24:59', '2026-04-11 16:24:59'),
(7, 'بدء تنفيذ القرار', 'decisions.start', 'القرارات', 'action', NULL, '2026-04-11 16:24:59', '2026-04-11 16:24:59'),
(8, 'إكمال القرار', 'decisions.complete', 'القرارات', 'action', NULL, '2026-04-11 16:24:59', '2026-04-11 16:24:59'),
(9, 'اعتماد القرار', 'decisions.approve', 'القرارات', 'action', NULL, '2026-04-11 16:24:59', '2026-04-11 16:24:59'),
(10, 'إلغاء القرار', 'decisions.cancel', 'القرارات', 'action', NULL, '2026-04-11 16:24:59', '2026-04-11 16:24:59'),
(11, 'ترحيل القرار', 'decisions.transfer', 'القرارات', 'action', NULL, '2026-04-11 16:24:59', '2026-04-11 16:24:59'),
(12, 'إضافة مهمة', 'tasks.create', 'المهام', 'action', NULL, '2026-04-11 16:24:59', '2026-04-11 16:24:59'),
(13, 'تعديل مهمة', 'tasks.edit', 'المهام', 'action', NULL, '2026-04-11 16:24:59', '2026-04-11 16:24:59'),
(14, 'حذف مهمة', 'tasks.delete', 'المهام', 'action', NULL, '2026-04-11 16:24:59', '2026-04-11 16:24:59'),
(15, 'بدء تنفيذ المهمة', 'tasks.start', 'المهام', 'action', NULL, '2026-04-11 16:24:59', '2026-04-11 16:24:59'),
(16, 'إكمال المهمة', 'tasks.complete', 'المهام', 'action', NULL, '2026-04-11 16:24:59', '2026-04-11 16:24:59'),
(17, 'اعتماد المهمة', 'tasks.approve', 'المهام', 'action', NULL, '2026-04-11 16:24:59', '2026-04-11 16:24:59'),
(18, 'إلغاء المهمة', 'tasks.cancel', 'المهام', 'action', NULL, '2026-04-11 16:24:59', '2026-04-11 16:24:59'),
(19, 'ترحيل المهمة', 'tasks.transfer', 'المهام', 'action', NULL, '2026-04-11 16:24:59', '2026-04-11 16:24:59'),
(20, 'إضافة موظف', 'employees.create', 'الموظفين', 'action', NULL, '2026-04-11 16:24:59', '2026-04-11 16:24:59'),
(21, 'تعديل موظف', 'employees.edit', 'الموظفين', 'action', NULL, '2026-04-11 16:24:59', '2026-04-11 16:24:59'),
(22, 'حذف موظف', 'employees.delete', 'الموظفين', 'action', NULL, '2026-04-11 16:24:59', '2026-04-11 16:24:59'),
(23, 'ترحيل مهام موظف', 'employees.resign', 'الموظفين', 'action', NULL, '2026-04-11 16:24:59', '2026-04-11 16:24:59'),
(24, 'إضافة دور', 'roles.create', 'الصلاحيات', 'action', NULL, '2026-04-11 16:24:59', '2026-04-11 16:24:59'),
(25, 'تعديل دور', 'roles.edit', 'الصلاحيات', 'action', NULL, '2026-04-11 16:24:59', '2026-04-11 16:24:59'),
(26, 'حذف دور', 'roles.delete', 'الصلاحيات', 'action', NULL, '2026-04-11 16:24:59', '2026-04-11 16:24:59'),
(27, 'تعديل الإعدادات', 'settings.edit', 'الإعدادات', 'action', NULL, '2026-04-11 16:24:59', '2026-04-11 16:24:59'),
(28, 'تصدير التقارير', 'reports.export', 'التقارير', 'action', NULL, '2026-04-11 16:24:59', '2026-04-11 16:24:59'),
(29, 'إدارة الإشعارات', 'notifications.manage', 'الإشعارات', 'action', NULL, '2026-04-11 16:24:59', '2026-04-11 16:24:59'),
(30, 'إضافة تعليق', 'comments.create', 'التعليقات', 'action', NULL, '2026-04-11 16:24:59', '2026-04-11 16:24:59'),
(31, 'حذف تعليق', 'comments.delete', 'التعليقات', 'action', NULL, '2026-04-11 16:24:59', '2026-04-11 16:24:59'),
(32, 'عرض لوحة التحكم', 'dashboard.view', 'لوحة التحكم', 'view', NULL, '2026-04-11 16:25:47', '2026-04-11 16:25:47'),
(33, 'استعراض الجلسات', 'sessions.view', 'الجلسات', 'view', NULL, '2026-04-11 16:25:47', '2026-04-11 16:25:47'),
(34, 'استعراض القرارات', 'decisions.view', 'القرارات', 'view', NULL, '2026-04-11 16:25:47', '2026-04-11 16:25:47'),
(35, 'عرض قراراتي', 'my_decisions.view', 'قراراتي', 'view', NULL, '2026-04-11 16:25:47', '2026-04-11 16:25:47'),
(36, 'عرض القرارات المنجزة', 'my_completed_decisions.view', 'القرارات المنجزة', 'view', NULL, '2026-04-11 16:25:47', '2026-04-11 16:25:47'),
(37, 'استعراض المهام', 'tasks.view', 'المهام', 'view', NULL, '2026-04-11 16:25:47', '2026-04-11 16:25:47'),
(38, 'عرض مهامي', 'my_tasks.view', 'مهامي', 'view', NULL, '2026-04-11 16:25:47', '2026-04-11 16:25:47'),
(39, 'عرض المهام المنجزة', 'my_completed_tasks.view', 'المهام المنجزة', 'view', NULL, '2026-04-11 16:25:47', '2026-04-11 16:25:47'),
(40, 'عرض المنجزات', 'achievements.view', 'المنجزات', 'view', NULL, '2026-04-11 16:25:47', '2026-04-11 16:25:47'),
(41, 'استعراض الموظفين', 'employees.view', 'الموظفين', 'view', NULL, '2026-04-11 16:25:47', '2026-04-11 16:25:47'),
(42, 'استعراض الأدوار', 'roles.view', 'الصلاحيات', 'view', NULL, '2026-04-11 16:25:47', '2026-04-11 16:25:47'),
(43, 'استعراض التقارير', 'reports.view', 'التقارير', 'view', NULL, '2026-04-11 16:25:47', '2026-04-11 16:25:47'),
(44, 'استعراض الإعدادات', 'settings.view', 'الإعدادات', 'view', NULL, '2026-04-11 16:25:47', '2026-04-11 16:25:47'),
(45, 'استعراض الإشعارات', 'notifications.view', 'الإشعارات', 'view', NULL, '2026-04-11 16:25:47', '2026-04-11 16:25:47'),
(46, 'استعراض سجل الحركات', 'activity_logs.view', 'السجل', 'view', NULL, '2026-04-11 16:25:47', '2026-04-11 16:25:47'),
(47, 'عرض بروفايل البلدية', 'municipality.view', 'البروفايل', 'view', NULL, '2026-04-11 16:25:47', '2026-04-11 16:25:47'),
(48, 'استعراض المجالس', 'councils.view', 'المجالس', 'action', NULL, '2026-04-11 20:50:37', '2026-04-11 20:50:37'),
(49, 'إضافة مجلس', 'councils.create', 'المجالس', 'action', NULL, '2026-04-11 20:50:37', '2026-04-11 20:50:37'),
(50, 'تعديل مجلس', 'councils.edit', 'المجالس', 'action', NULL, '2026-04-11 20:50:37', '2026-04-11 20:50:37'),
(51, 'حذف مجلس', 'councils.delete', 'المجالس', 'action', NULL, '2026-04-11 20:50:37', '2026-04-11 20:50:37'),
(52, 'استعراض اللجان', 'committees.view', 'اللجان', 'action', NULL, '2026-04-11 20:50:37', '2026-04-11 20:50:37'),
(53, 'إضافة لجنة', 'committees.create', 'اللجان', 'action', NULL, '2026-04-11 20:50:37', '2026-04-11 20:50:37'),
(54, 'تعديل لجنة', 'committees.edit', 'اللجان', 'action', NULL, '2026-04-11 20:50:37', '2026-04-11 20:50:37'),
(55, 'حذف لجنة', 'committees.delete', 'اللجان', 'action', NULL, '2026-04-11 20:50:37', '2026-04-11 20:50:37'),
(56, 'استعراض محاضر الاجتماعات', 'committee_meetings.view', 'محاضر الاجتماعات', 'action', NULL, '2026-04-11 20:50:37', '2026-04-11 20:50:37'),
(57, 'إضافة محضر اجتماع', 'committee_meetings.create', 'محاضر الاجتماعات', 'action', NULL, '2026-04-11 20:50:37', '2026-04-11 20:50:37'),
(58, 'تعديل محضر اجتماع', 'committee_meetings.edit', 'محاضر الاجتماعات', 'action', NULL, '2026-04-11 20:50:37', '2026-04-11 20:50:37'),
(59, 'حذف محضر اجتماع', 'committee_meetings.delete', 'محاضر الاجتماعات', 'action', NULL, '2026-04-11 20:50:37', '2026-04-11 20:50:37');

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

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

CREATE TABLE `roles` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `is_system` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `roles` (`id`, `name`, `slug`, `description`, `is_system`, `created_at`, `updated_at`) VALUES
(1, 'مدير الموقع', 'admin', 'مدير النظام بكامل الصلاحيات', 1, '2026-04-11 16:25:47', '2026-04-11 16:25:47'),
(2, 'مشرف', 'supervisor', 'مشرف على القرارات والمهام', 1, '2026-04-11 16:25:47', '2026-04-11 16:25:47'),
(3, 'موظف', 'employee', 'موظف منفذ للقرارات والمهام', 1, '2026-04-11 16:25:47', '2026-04-11 16:25:47'),
(4, 'رئيس البلدية', 'mayor', 'رئيس البلدية', 1, '2026-04-11 16:25:47', '2026-04-11 16:25:47');

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

--
-- Table structure for table `role_permission`
--

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

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

INSERT INTO `role_permission` (`id`, `role_id`, `permission_id`) VALUES
(3, 1, 1),
(4, 1, 2),
(5, 1, 3),
(7, 1, 4),
(8, 1, 5),
(9, 1, 6),
(10, 1, 7),
(11, 1, 8),
(12, 1, 9),
(13, 1, 10),
(14, 1, 11),
(18, 1, 12),
(19, 1, 13),
(20, 1, 14),
(21, 1, 15),
(22, 1, 16),
(23, 1, 17),
(24, 1, 18),
(25, 1, 19),
(30, 1, 20),
(31, 1, 21),
(32, 1, 22),
(33, 1, 23),
(35, 1, 24),
(36, 1, 25),
(37, 1, 26),
(41, 1, 27),
(39, 1, 28),
(43, 1, 29),
(46, 1, 30),
(47, 1, 31),
(1, 1, 32),
(2, 1, 33),
(6, 1, 34),
(15, 1, 35),
(16, 1, 36),
(17, 1, 37),
(26, 1, 38),
(27, 1, 39),
(28, 1, 40),
(29, 1, 41),
(34, 1, 42),
(38, 1, 43),
(40, 1, 44),
(42, 1, 45),
(44, 1, 46),
(45, 1, 47),
(144, 1, 48),
(145, 1, 49),
(146, 1, 50),
(147, 1, 51),
(148, 1, 52),
(149, 1, 53),
(150, 1, 54),
(151, 1, 55),
(152, 1, 56),
(153, 1, 57),
(154, 1, 58),
(155, 1, 59),
(51, 2, 4),
(52, 2, 5),
(53, 2, 6),
(54, 2, 7),
(55, 2, 8),
(56, 2, 9),
(57, 2, 10),
(58, 2, 11),
(62, 2, 12),
(63, 2, 13),
(64, 2, 14),
(65, 2, 15),
(66, 2, 16),
(67, 2, 17),
(68, 2, 18),
(69, 2, 19),
(75, 2, 28),
(77, 2, 29),
(80, 2, 30),
(81, 2, 31),
(48, 2, 32),
(49, 2, 33),
(50, 2, 34),
(59, 2, 35),
(60, 2, 36),
(61, 2, 37),
(70, 2, 38),
(71, 2, 39),
(72, 2, 40),
(73, 2, 41),
(74, 2, 43),
(76, 2, 45),
(78, 2, 46),
(79, 2, 47),
(168, 2, 48),
(169, 2, 52),
(170, 2, 56),
(84, 3, 7),
(85, 3, 8),
(89, 3, 15),
(90, 3, 16),
(95, 3, 29),
(96, 3, 30),
(82, 3, 32),
(83, 3, 34),
(86, 3, 35),
(87, 3, 36),
(88, 3, 37),
(91, 3, 38),
(92, 3, 39),
(93, 3, 40),
(94, 3, 45),
(99, 4, 1),
(100, 4, 2),
(101, 4, 3),
(103, 4, 4),
(104, 4, 5),
(105, 4, 6),
(106, 4, 7),
(107, 4, 8),
(108, 4, 9),
(109, 4, 10),
(110, 4, 11),
(114, 4, 12),
(115, 4, 13),
(116, 4, 14),
(117, 4, 15),
(118, 4, 16),
(119, 4, 17),
(120, 4, 18),
(121, 4, 19),
(126, 4, 20),
(127, 4, 21),
(128, 4, 22),
(129, 4, 23),
(131, 4, 24),
(132, 4, 25),
(133, 4, 26),
(137, 4, 27),
(135, 4, 28),
(139, 4, 29),
(142, 4, 30),
(143, 4, 31),
(97, 4, 32),
(98, 4, 33),
(102, 4, 34),
(111, 4, 35),
(112, 4, 36),
(113, 4, 37),
(122, 4, 38),
(123, 4, 39),
(124, 4, 40),
(125, 4, 41),
(130, 4, 42),
(134, 4, 43),
(136, 4, 44),
(138, 4, 45),
(140, 4, 46),
(141, 4, 47),
(156, 4, 48),
(157, 4, 49),
(158, 4, 50),
(159, 4, 51),
(160, 4, 52),
(161, 4, 53),
(162, 4, 54),
(163, 4, 55),
(164, 4, 56),
(165, 4, 57),
(166, 4, 58),
(167, 4, 59);

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

--
-- Table structure for table `tasks`
--

CREATE TABLE `tasks` (
  `id` bigint UNSIGNED NOT NULL,
  `task_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` enum('new','in_progress','completed','approved','cancelled') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'new',
  `priority` enum('low','medium','high','urgent') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'medium',
  `deadline` date DEFAULT NULL,
  `supervisor_id` bigint UNSIGNED DEFAULT NULL,
  `created_by` bigint UNSIGNED NOT NULL,
  `is_cancelled` tinyint(1) NOT NULL DEFAULT '0',
  `cancellation_reason` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `started_at` timestamp NULL DEFAULT NULL,
  `completed_at` timestamp NULL DEFAULT NULL,
  `approved_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `task_user`
--

CREATE TABLE `task_user` (
  `id` bigint UNSIGNED NOT NULL,
  `task_id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `status` enum('assigned','started','completed') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'assigned',
  `started_at` timestamp NULL DEFAULT NULL,
  `completed_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `activity_logs`
--
ALTER TABLE `activity_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `activity_logs_user_id_foreign` (`user_id`);

--
-- Indexes for table `attachments`
--
ALTER TABLE `attachments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `attachments_attachable_type_attachable_id_index` (`attachable_type`,`attachable_id`),
  ADD KEY `attachments_uploaded_by_foreign` (`uploaded_by`);

--
-- Indexes for table `comments`
--
ALTER TABLE `comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `comments_commentable_type_commentable_id_index` (`commentable_type`,`commentable_id`),
  ADD KEY `comments_user_id_foreign` (`user_id`);

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

--
-- Indexes for table `committee_meetings`
--
ALTER TABLE `committee_meetings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `committee_meetings_committee_id_foreign` (`committee_id`),
  ADD KEY `committee_meetings_council_id_foreign` (`council_id`),
  ADD KEY `committee_meetings_created_by_foreign` (`created_by`);

--
-- Indexes for table `committee_meeting_council_member`
--
ALTER TABLE `committee_meeting_council_member`
  ADD PRIMARY KEY (`id`),
  ADD KEY `committee_meeting_council_member_committee_meeting_id_foreign` (`committee_meeting_id`),
  ADD KEY `committee_meeting_council_member_council_member_id_foreign` (`council_member_id`);

--
-- Indexes for table `committee_meeting_user`
--
ALTER TABLE `committee_meeting_user`
  ADD PRIMARY KEY (`id`),
  ADD KEY `committee_meeting_user_committee_meeting_id_foreign` (`committee_meeting_id`),
  ADD KEY `committee_meeting_user_user_id_foreign` (`user_id`);

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

--
-- Indexes for table `council_members`
--
ALTER TABLE `council_members`
  ADD PRIMARY KEY (`id`),
  ADD KEY `council_members_council_id_foreign` (`council_id`);

--
-- Indexes for table `council_sessions`
--
ALTER TABLE `council_sessions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `council_session_unique` (`council_id`,`session_number`),
  ADD KEY `council_sessions_created_by_foreign` (`created_by`);

--
-- Indexes for table `decision_user`
--
ALTER TABLE `decision_user`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `decision_user_decision_id_user_id_unique` (`decision_id`,`user_id`),
  ADD KEY `decision_user_user_id_foreign` (`user_id`);

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

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

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

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`);

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

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

--
-- Indexes for table `role_permission`
--
ALTER TABLE `role_permission`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `role_permission_role_id_permission_id_unique` (`role_id`,`permission_id`),
  ADD KEY `role_permission_permission_id_foreign` (`permission_id`);

--
-- Indexes for table `tasks`
--
ALTER TABLE `tasks`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `tasks_task_number_unique` (`task_number`),
  ADD KEY `tasks_supervisor_id_foreign` (`supervisor_id`),
  ADD KEY `tasks_created_by_foreign` (`created_by`);

--
-- Indexes for table `task_user`
--
ALTER TABLE `task_user`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `task_user_task_id_user_id_unique` (`task_id`,`user_id`),
  ADD KEY `task_user_user_id_foreign` (`user_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `activity_logs`
--
ALTER TABLE `activity_logs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=68;

--
-- AUTO_INCREMENT for table `attachments`
--
ALTER TABLE `attachments`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `comments`
--
ALTER TABLE `comments`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `committees`
--
ALTER TABLE `committees`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `committee_meetings`
--
ALTER TABLE `committee_meetings`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `committee_meeting_council_member`
--
ALTER TABLE `committee_meeting_council_member`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `committee_meeting_user`
--
ALTER TABLE `committee_meeting_user`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `councils`
--
ALTER TABLE `councils`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `council_members`
--
ALTER TABLE `council_members`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `council_sessions`
--
ALTER TABLE `council_sessions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `decision_user`
--
ALTER TABLE `decision_user`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

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

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT for table `municipality_profiles`
--
ALTER TABLE `municipality_profiles`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=60;

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

--
-- AUTO_INCREMENT for table `role_permission`
--
ALTER TABLE `role_permission`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=171;

--
-- AUTO_INCREMENT for table `tasks`
--
ALTER TABLE `tasks`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `task_user`
--
ALTER TABLE `task_user`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `activity_logs`
--
ALTER TABLE `activity_logs`
  ADD CONSTRAINT `activity_logs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `attachments`
--
ALTER TABLE `attachments`
  ADD CONSTRAINT `attachments_uploaded_by_foreign` FOREIGN KEY (`uploaded_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `comments`
--
ALTER TABLE `comments`
  ADD CONSTRAINT `comments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `committee_meetings`
--
ALTER TABLE `committee_meetings`
  ADD CONSTRAINT `committee_meetings_committee_id_foreign` FOREIGN KEY (`committee_id`) REFERENCES `committees` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `committee_meetings_council_id_foreign` FOREIGN KEY (`council_id`) REFERENCES `councils` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `committee_meetings_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `committee_meeting_council_member`
--
ALTER TABLE `committee_meeting_council_member`
  ADD CONSTRAINT `committee_meeting_council_member_committee_meeting_id_foreign` FOREIGN KEY (`committee_meeting_id`) REFERENCES `committee_meetings` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `committee_meeting_council_member_council_member_id_foreign` FOREIGN KEY (`council_member_id`) REFERENCES `council_members` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `committee_meeting_user`
--
ALTER TABLE `committee_meeting_user`
  ADD CONSTRAINT `committee_meeting_user_committee_meeting_id_foreign` FOREIGN KEY (`committee_meeting_id`) REFERENCES `committee_meetings` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `committee_meeting_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `council_members`
--
ALTER TABLE `council_members`
  ADD CONSTRAINT `council_members_council_id_foreign` FOREIGN KEY (`council_id`) REFERENCES `councils` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `council_sessions`
--
ALTER TABLE `council_sessions`
  ADD CONSTRAINT `council_sessions_council_id_foreign` FOREIGN KEY (`council_id`) REFERENCES `councils` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `council_sessions_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `decision_user`
--
ALTER TABLE `decision_user`
  ADD CONSTRAINT `decision_user_decision_id_foreign` FOREIGN KEY (`decision_id`) REFERENCES `decisions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `decision_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `role_permission`
--
ALTER TABLE `role_permission`
  ADD CONSTRAINT `role_permission_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_permission_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `tasks`
--
ALTER TABLE `tasks`
  ADD CONSTRAINT `tasks_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `tasks_supervisor_id_foreign` FOREIGN KEY (`supervisor_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `task_user`
--
ALTER TABLE `task_user`
  ADD CONSTRAINT `task_user_task_id_foreign` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `task_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

