/*
السجون
*/

INSERT INTO `prisons` (`id`, `name`, `address`, `city`, `max_capacity`, `gender`, `type`, `created_at`, `updated_at`) VALUES
(1, 'سجن بريدة العام', 'القصيم', 'بريدة', 1700, 'male', 'adults', '2023-12-28 05:56:05', '2023-12-28 05:56:05'),
(2, 'سجن الملز', 'الرياض', 'الرياض', 5000, 'male', 'adults', '2023-12-28 05:56:43', '2023-12-28 05:56:43'),
(3, 'سجن ذهبان', 'مكة المكرمة', 'جدة', 13000, 'male', 'adults', '2023-12-28 05:57:23', '2023-12-28 05:57:23'),
(4, 'سجن الدمام العام', 'المنطقة الشرقية', 'الدمام', 6000, 'male', 'adults', '2023-12-28 05:57:56', '2023-12-28 05:57:56'),
(5, 'دار الملاحظة الاجتماعية ببريدة', 'القصيم', 'بريدة', 700, 'male', 'juveniles', '2023-12-28 05:58:31', '2023-12-28 05:58:31'),
(6, 'مؤسسة رعاية الفتايات ببريدة', 'القصيم', 'بريدة', 300, 'female', 'juveniles', '2023-12-28 05:59:26', '2023-12-28 05:59:26');



INSERT INTO `prison_sections` (`id`, `prison_id`, `name`, `created_at`, `updated_at`) VALUES
(1, 1, 'المثالى', '2023-12-28 06:00:49', '2023-12-28 06:00:49'),
(2, 1, 'الشباب', '2023-12-28 06:00:58', '2023-12-28 06:00:58'),
(3, 1, 'الوافدين', '2023-12-28 06:01:06', '2023-12-28 06:01:06'),
(4, 2, 'المثالي', '2023-12-28 06:02:16', '2023-12-28 06:02:16'),
(5, 2, 'الشباب', '2023-12-28 06:03:47', '2023-12-28 06:03:47'),
(6, 2, 'الوافدين', '2023-12-28 06:03:56', '2023-12-28 06:03:56'),
(7, 3, 'المثالي', '2023-12-28 06:04:16', '2023-12-28 06:04:16'),
(8, 3, 'الشباب', '2023-12-28 06:04:25', '2023-12-28 06:04:25'),
(9, 3, 'الوافدين', '2023-12-28 06:04:55', '2023-12-28 06:04:55'),
(10, 4, 'المثالي', '2023-12-28 06:05:20', '2023-12-28 06:05:20'),
(11, 4, 'الشباب', '2023-12-28 06:06:25', '2023-12-28 06:06:25'),
(12, 4, 'الوافدين', '2023-12-28 06:06:45', '2023-12-28 06:06:45'),
(13, 5, 'المثالي', '2023-12-28 06:07:47', '2023-12-28 06:07:47'),
(14, 6, 'المثالي', '2023-12-28 06:08:07', '2023-12-28 06:08:07');



INSERT INTO `prison_rooms` (`id`, `prison_id`, `prison_section_id`, `name`, `created_at`, `updated_at`) VALUES
(1, 1, 1, '1', '2023-12-28 06:09:27', '2023-12-28 06:09:27'),
(2, 1, 1, '2', '2023-12-28 06:09:31', '2023-12-28 06:09:31'),
(3, 1, 1, '3', '2023-12-28 06:09:35', '2023-12-28 06:09:35'),
(4, 1, 1, '4', '2023-12-28 06:09:46', '2023-12-28 06:09:46'),
(5, 1, 1, '5', '2023-12-28 06:09:51', '2023-12-28 06:09:51'),
(6, 1, 2, '1', '2023-12-28 06:10:02', '2023-12-28 06:10:02'),
(7, 1, 2, '2', '2023-12-28 06:10:06', '2023-12-28 06:10:06'),
(8, 1, 2, '3', '2023-12-28 06:10:09', '2023-12-28 06:10:09'),
(9, 1, 3, '1', '2023-12-28 06:10:18', '2023-12-28 06:10:18'),
(10, 1, 3, '2', '2023-12-28 06:10:21', '2023-12-28 06:10:21'),
(11, 1, 3, '3', '2023-12-28 06:10:30', '2023-12-28 06:10:30'),
(12, 2, 4, '1', '2023-12-28 06:12:34', '2023-12-28 06:12:34'),
(13, 2, 4, '2', '2023-12-28 06:12:39', '2023-12-28 06:12:39'),
(14, 2, 4, '3', '2023-12-28 06:12:43', '2023-12-28 06:12:43'),
(15, 2, 5, '1', '2023-12-28 06:12:48', '2023-12-28 06:12:48'),
(16, 2, 5, '2', '2023-12-28 06:12:51', '2023-12-28 06:12:51'),
(17, 2, 5, '3', '2023-12-28 06:12:54', '2023-12-28 06:12:54'),
(18, 2, 6, '1', '2023-12-28 06:13:01', '2023-12-28 06:13:01'),
(19, 2, 6, '2', '2023-12-28 06:13:04', '2023-12-28 06:13:04'),
(20, 2, 6, '3', '2023-12-28 06:13:07', '2023-12-28 06:13:07'),
(21, 3, 7, '1', '2023-12-28 06:13:19', '2023-12-28 06:13:19'),
(22, 3, 7, '2', '2023-12-28 06:13:22', '2023-12-28 06:13:22'),
(23, 3, 7, '3', '2023-12-28 06:13:28', '2023-12-28 06:13:28'),
(24, 4, 10, '1', '2023-12-28 06:13:53', '2023-12-28 06:13:53'),
(25, 4, 10, '2', '2023-12-28 06:14:00', '2023-12-28 06:14:00'),
(26, 4, 10, '3', '2023-12-28 06:14:03', '2023-12-28 06:14:03'),
(27, 4, 11, '1', '2023-12-28 06:14:09', '2023-12-28 06:14:09'),
(28, 4, 11, '2', '2023-12-28 06:14:13', '2023-12-28 06:14:13'),
(29, 4, 11, '3', '2023-12-28 06:14:16', '2023-12-28 06:14:16'),
(30, 4, 12, '1', '2023-12-28 06:14:22', '2023-12-28 06:14:22'),
(31, 4, 12, '2', '2023-12-28 06:14:25', '2023-12-28 06:14:25'),
(32, 4, 12, '3', '2023-12-28 06:14:28', '2023-12-28 06:14:28'),
(33, 5, 13, '1', '2023-12-28 06:14:39', '2023-12-28 06:14:39'),
(34, 5, 13, '2', '2023-12-28 06:14:43', '2023-12-28 06:14:43'),
(35, 5, 13, '3', '2023-12-28 06:14:47', '2023-12-28 06:14:47'),
(36, 6, 14, '1', '2023-12-28 06:14:54', '2023-12-28 06:14:54'),
(37, 6, 14, '2', '2023-12-28 06:14:59', '2023-12-28 06:14:59'),
(38, 6, 14, '3', '2023-12-28 06:15:03', '2023-12-28 06:15:03');



INSERT INTO `prison_guards` (`id`, `prison_id`, `name`, `phone`, `address`, `job`, `created_at`, `updated_at`) VALUES
(1, 5, 'صالح بن حمد', '0554888373', 'سجن بريدة العام', 'مستقبل', '2023-12-28 06:15:48', '2023-12-28 06:15:48'),
(2, 6, 'على احمد', '0554888373', 'سجن بريدة العام', 'مستقبل', '2023-12-28 06:16:06', '2023-12-28 06:16:06');


