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

START TRANSACTION;



--
-- Database: `custom_dirtycops`
--

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

--
-- Table structure for table `dirty_cop_us_departments`
--

CREATE TABLE `dirty_cop_us_departments` (
  `id` int(11) NOT NULL,
  `department` varchar(255) NOT NULL,
  `department_code` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `dirty_cop_us_departments` (`id`, `department`, `department_code`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Federal Bureau of Investigation (FBI)', 'FBI', 0, '2023-12-11 19:27:31', '2023-12-11 19:27:31'),
(2, 'Drug Enforcement Administration (DEA)', 'DEA', 0, '2023-12-11 19:27:31', '2023-12-11 19:27:31'),
(3, 'Bureau of Alcohol, Tobacco, Firearms and Explosives (ATF)', 'ATF', 0, '2023-12-11 19:29:16', '2023-12-11 19:29:16'),
(4, 'United States Marshals Service (USMS)', 'USMS', 0, '2023-12-11 19:29:16', '2023-12-11 19:29:16'),
(5, 'Bureau of Prisons (BOP)\r\n', 'BOP', 0, '2023-12-11 19:31:20', '2023-12-11 19:31:20'),
(6, 'Immigration and Customs Enforcement (ICE)', 'ICE', 0, '2023-12-11 19:31:20', '2023-12-11 19:31:20'),
(7, 'U.S. Secret Service', 'SecretService', 0, '2023-12-11 19:32:04', '2023-12-11 19:32:04'),
(8, 'Department of Homeland Security (DHS)', 'DHS', 0, '2023-12-11 19:32:04', '2023-12-11 19:32:04'),
(9, 'Department of the Treasury', 'Treasury', 0, '2023-12-11 19:32:53', '2023-12-11 19:32:53'),
(10, 'Department of State-Diplomatic Security Service (DSS)', 'StateDSS', 0, '2023-12-11 19:32:53', '2023-12-11 19:32:53');

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

--
-- Table structure for table `dirty_cop_us_locations`
--

CREATE TABLE `dirty_cop_us_locations` (
  `id` int(11) NOT NULL,
  `location` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `dirty_cop_us_locations` (`id`, `location`, `status`, `created_at`, `updated_at`) VALUES
(1, 'alabama', 0, '2023-12-11 21:07:10', '2023-12-11 21:07:10'),
(2, 'alaska', 0, '2023-12-11 21:07:10', '2023-12-11 21:07:10');

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

--
-- Table structure for table `dirty_cop_us_reviews`
--

CREATE TABLE `dirty_cop_us_reviews` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title_name` text DEFAULT NULL,
  `date_of_incident` varchar(255) DEFAULT NULL,
  `time_of_incident` varchar(255) DEFAULT NULL,
  `department_id` varchar(255) DEFAULT NULL,
  `location_id` varchar(255) DEFAULT NULL,
  `officer_name` varchar(255) DEFAULT NULL,
  `file` varchar(255) DEFAULT NULL,
  `victim_or_confidential` varchar(255) DEFAULT NULL,
  `incident_crime` varchar(255) DEFAULT NULL,
  `describtion` text DEFAULT NULL,
  `status` int(11) 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 `dirty_cop_us_reviews`
--

INSERT INTO `dirty_cop_us_reviews` (`id`, `title_name`, `date_of_incident`, `time_of_incident`, `department_id`, `location_id`, `officer_name`, `file`, `victim_or_confidential`, `incident_crime`, `describtion`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Bribery trial of ex-Palm Springs mayor and developer delayed to 2024', '2023-12-12', '05:16', '9', '1', 'Nullam dictum', '1702340248.webp', 'Albert Thompson', 'Homicide', '<span style=\"color: rgb(33, 37, 41); font-family: Poppins, sans-serif; font-size: 17px;\">In the small town of Fairview, an unsettling incident unfolded that would challenge the community\'s trust in its protectors. It began on a rain-slicked evening when a young software developer, Jordan, was stopped by local police while walking home. The officers were responding to a burglary alarm from a nearby store, and in their haste to find the suspect, they made a critical error.</span><br style=\"color: rgb(33, 37, 41); font-family: Poppins, sans-serif; font-size: 17px;\"><br style=\"color: rgb(33, 37, 41); font-family: Poppins, sans-serif; font-size: 17px;\"><span style=\"color: rgb(33, 37, 41); font-family: Poppins, sans-serif; font-size: 17px;\">Jordan, who was wearing a black hoodie similar to the vague description provided by a witness, was mistakenly identified as the perpetrator. Despite Jordan’s calm and cooperative demeanor, offering to show identification and explain their presence in the neighborhood, the situation quickly escalated.</span><br style=\"color: rgb(33, 37, 41); font-family: Poppins, sans-serif; font-size: 17px;\"><br style=\"color: rgb(33, 37, 41); font-family: Poppins, sans-serif; font-size: 17px;\"><span style=\"color: rgb(33, 37, 41); font-family: Poppins, sans-serif; font-size: 17px;\">The officers, fueled by adrenaline and the pressure to quickly resolve the case, disregarded Jordan\'s rights and detained them without proper cause. Passersby filmed the encounter, capturing the officers\' overreach and Jordan\'s composed arguments for their innocence.</span><br style=\"color: rgb(33, 37, 41); font-family: Poppins, sans-serif; font-size: 17px;\"><br style=\"color: rgb(33, 37, 41); font-family: Poppins, sans-serif; font-size: 17px;\"><span style=\"color: rgb(33, 37, 41); font-family: Poppins, sans-serif; font-size: 17px;\">As the footage went viral, the true perpetrator was apprehended, caught red-handed with stolen goods. The evidence was irrefutable, and it became clear that Jordan was not only innocent but had been wronged by those sworn to uphold justice.</span><br style=\"color: rgb(33, 37, 41); font-family: Poppins, sans-serif; font-size: 17px;\"><br style=\"color: rgb(33, 37, 41); font-family: Poppins, sans-serif; font-size: 17px;\"><span style=\"color: rgb(33, 37, 41); font-family: Poppins, sans-serif; font-size: 17px;\">The aftermath saw the community rallying around Jordan, demanding accountability and transparency from the police department. The officers involved faced a thorough investigation, and the incident sparked conversations about the importance of due process and the safeguards against the misuse of power.</span><br style=\"color: rgb(33, 37, 41); font-family: Poppins, sans-serif; font-size: 17px;\"><br style=\"color: rgb(33, 37, 41); font-family: Poppins, sans-serif; font-size: 17px;\"><span style=\"color: rgb(33, 37, 41); font-family: Poppins, sans-serif; font-size: 17px;\">The town of Fairview learned a crucial lesson about the fallibility of its guardians and the strength of its community in seeking rectitude and reform. In the end, justice prevailed not just for Jordan, but for the town\'s collective conscience.</span>', 0, '2023-12-12 00:17:28', '2023-12-12 00:17:28'),
(2, 'Bribery trial of ex-Palm Springs mayor and developer delayed to 2024', '2023-12-13', '18:19', '6', '2', 'John Dines', '1702340363.png', 'Albert Thompson', 'Homicide', '<span style=\"color: rgb(33, 37, 41); font-family: Poppins, sans-serif; font-size: 17px;\">In the small town of Fairview, an unsettling incident unfolded that would challenge the community\'s trust in its protectors. It began on a rain-slicked evening when a young software developer, Jordan, was stopped by local police while walking home. The officers were responding to a burglary alarm from a nearby store, and in their haste to find the suspect, they made a critical error.</span><br style=\"color: rgb(33, 37, 41); font-family: Poppins, sans-serif; font-size: 17px;\"><br style=\"color: rgb(33, 37, 41); font-family: Poppins, sans-serif; font-size: 17px;\"><span style=\"color: rgb(33, 37, 41); font-family: Poppins, sans-serif; font-size: 17px;\">Jordan, who was wearing a black hoodie similar to the vague description provided by a witness, was mistakenly identified as the perpetrator. Despite Jordan’s calm and cooperative demeanor, offering to show identification and explain their presence in the neighborhood, the situation quickly escalated.</span><br style=\"color: rgb(33, 37, 41); font-family: Poppins, sans-serif; font-size: 17px;\"><br style=\"color: rgb(33, 37, 41); font-family: Poppins, sans-serif; font-size: 17px;\"><span style=\"color: rgb(33, 37, 41); font-family: Poppins, sans-serif; font-size: 17px;\">The officers, fueled by adrenaline and the pressure to quickly resolve the case, disregarded Jordan\'s rights and detained them without proper cause. Passersby filmed the encounter, capturing the officers\' overreach and Jordan\'s composed arguments for their innocence.</span><br style=\"color: rgb(33, 37, 41); font-family: Poppins, sans-serif; font-size: 17px;\"><br style=\"color: rgb(33, 37, 41); font-family: Poppins, sans-serif; font-size: 17px;\"><span style=\"color: rgb(33, 37, 41); font-family: Poppins, sans-serif; font-size: 17px;\">As the footage went viral, the true perpetrator was apprehended, caught red-handed with stolen goods. The evidence was irrefutable, and it became clear that Jordan was not only innocent but had been wronged by those sworn to uphold justice.</span><br style=\"color: rgb(33, 37, 41); font-family: Poppins, sans-serif; font-size: 17px;\"><br style=\"color: rgb(33, 37, 41); font-family: Poppins, sans-serif; font-size: 17px;\"><span style=\"color: rgb(33, 37, 41); font-family: Poppins, sans-serif; font-size: 17px;\">The aftermath saw the community rallying around Jordan, demanding accountability and transparency from the police department. The officers involved faced a thorough investigation, and the incident sparked conversations about the importance of due process and the safeguards against the misuse of power.</span><br style=\"color: rgb(33, 37, 41); font-family: Poppins, sans-serif; font-size: 17px;\"><br style=\"color: rgb(33, 37, 41); font-family: Poppins, sans-serif; font-size: 17px;\"><span style=\"color: rgb(33, 37, 41); font-family: Poppins, sans-serif; font-size: 17px;\">The town of Fairview learned a crucial lesson about the fallibility of its guardians and the strength of its community in seeking rectitude and reform. In the end, justice prevailed not just for Jordan, but for the town\'s collective conscience.</span>', 0, '2023-12-12 00:19:23', '2023-12-12 00:19:23');

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

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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `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()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2023_12_11_164531_create_dirtycopsus_reviews_table', 2);

--
-- Indexes for dumped tables
--

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

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

--
-- Indexes for table `dirty_cop_us_reviews`
--
ALTER TABLE `dirty_cop_us_reviews`
  ADD PRIMARY KEY (`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`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `dirty_cop_us_departments`
--
ALTER TABLE `dirty_cop_us_departments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `dirty_cop_us_locations`
--
ALTER TABLE `dirty_cop_us_locations`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `dirty_cop_us_reviews`
--
ALTER TABLE `dirty_cop_us_reviews`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

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

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
COMMIT;

