-- 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', 1, '2023-12-11 19:27:31', '2023-12-12 19:17:17'),
(2, 'Drug Enforcement Administration (DEA)', 'DEA', 1, '2023-12-11 19:27:31', '2023-12-11 19:27:31'),
(3, 'Bureau of Alcohol, Tobacco, Firearms and Explosives (ATF)', 'ATF', 1, '2023-12-11 19:29:16', '2023-12-11 19:29:16'),
(4, 'United States Marshals Service (USMS)', 'USMS', 1, '2023-12-11 19:29:16', '2023-12-11 19:29:16'),
(5, 'Bureau of Prisons (BOP)\r\n', 'BOP', 1, '2023-12-11 19:31:20', '2023-12-11 19:31:20'),
(6, 'Immigration and Customs Enforcement (ICE)', 'ICE', 1, '2023-12-11 19:31:20', '2023-12-11 19:31:20'),
(7, 'U.S. Secret Service', 'SecretService', 1, '2023-12-11 19:32:04', '2023-12-11 19:32:04'),
(8, 'Department of Homeland Security (DHS)', 'DHS', 1, '2023-12-11 19:32:04', '2023-12-11 19:32:04'),
(9, 'Department of the Treasury', 'Treasury', 1, '2023-12-11 19:32:53', '2023-12-12 19:38:12'),
(10, 'Department of State-Diplomatic Security Service (DSS)', 'StateDSS', 1, '2023-12-11 19:32:53', '2023-12-11 19:32:53'),
(15, 'Federal Bureau of Investigation (FBI)', NULL, 1, '2023-12-12 18:52:24', '2023-12-12 18:52:24'),
(16, 'Federal Bureau of Investigation  (FBI)', NULL, 1, '2023-12-12 18:53:59', '2023-12-12 19:42:43');

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

--
-- Table structure for table `dirty_cop_us_featured_pages`
--

CREATE TABLE `dirty_cop_us_featured_pages` (
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `banner` varchar(300) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `dirty_cop_us_featured_pages`
--

INSERT INTO `dirty_cop_us_featured_pages` (`id`, `title`, `banner`, `created_at`, `updated_at`) VALUES
(1, 'Featured Reports\n', '1702684407.jpg', '2023-12-15 23:20:21', '2023-12-15 18:53:27');

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

--
-- Table structure for table `dirty_cop_us_featured_reports`
--

CREATE TABLE `dirty_cop_us_featured_reports` (
  `id` int(11) NOT NULL,
  `heading` text DEFAULT NULL,
  `victime` varchar(244) DEFAULT NULL,
  `officer` varchar(255) DEFAULT NULL,
  `location_id` int(11) DEFAULT NULL,
  `department_id` int(11) DEFAULT NULL,
  `image` varchar(300) DEFAULT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  `description` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `dirty_cop_us_featured_reports`
--

INSERT INTO `dirty_cop_us_featured_reports` (`id`, `heading`, `victime`, `officer`, `location_id`, `department_id`, `image`, `date`, `description`, `created_at`, `updated_at`) VALUES
(1, 'California’s criminal cops: Investigation finds 630 officers convicted of misdemeanors. Many are still working', 'Robert', 'Lewis', 20, 7, '1702667136.webp', '2023-12-15 22:51:14', '<p class=\"main-content side-txt\">More than 80 law enforcement officers working today in\r\n                                California are convicted\r\n                                criminals, with rap sheets that include everything from animal cruelty to\r\n                                manslaughter.\r\n                                They drove drunk, cheated on timecards, brutalized family\r\n                                members, even killed others\r\n                                with their recklessness on the road. But thanks to some of the weakest laws in the\r\n                                country for punishing police misconduct, the Golden State does nothing to stop these\r\n                                officers from enforcing the law.\r\n                                Those are among the findings of <a href=\"https://www.desertsun.com/story/news/2019/11/10/california-criminal-cops-project-origins-and-participating-newsrooms/2543809001/\">an\r\n                                    unprecedented collaboration of\r\n                                    newsrooms</a>—including\r\n                                USA TODAY Network publications The Desert Sun, Ventura County Star, Redding Record\r\n                                Searchlight, Salinas Californian and Visalia Times Delta—which spent six months\r\n                                examining how California deals with cops who break the law.\r\n\r\n                            </p>\r\n\r\n                            <br>\r\n                            <p class=\"main-content-show\">The review found 630 officers convicted of a crime in the last\r\n                                decade—an average of more\r\n                                than one a week. After DUI and other serious driving offenses, domestic violence was the\r\n                                most common charge. More than a quarter of the cases appear never to have been reported\r\n                                in the media until now. And nearly one out of five officers in the review are still\r\n                                working or kept their jobs for more than a year after sentencing.</p>\r\n                          \r\n                            <br>\r\n                           \r\n                            <p class=\"main-content-show\">(It’s a small percentage of the 79,000 sworn officers across\r\n                                the\r\n                                state. But exactly how many cops with convictions are still on the beat today—or even\r\n                                the number of officers convicted over the last decade—is far from clear. Hindered by\r\n                                some of the strictest secrecy laws in the country, California residents don’t really\r\n                                know who is carrying a gun and patrolling their streets.)</p>', '2023-12-15 17:58:02', '2023-12-15 17:51:14'),
(10, 'Searchable records show more than 300 allegations of police misconduct reported by fellow officers', 'Gina Barton', 'Brett Murphy', 8, 9, '1702681002.png', '2023-12-15 22:57:02', '<p class=\"main-content side-txt\">From a tiny department in the mountains of Idaho to the New\r\n                                York Police Department, USA TODAY found more than 300 cases of officers who bucked law\r\n                                enforcement’s blue wall of silence by reporting or testifying against co-workers accused\r\n                                of misconduct over the past decade. In Colorado, an internal affairs investigator leaked\r\n                                a video of an officer punching a handcuffed man in a wheelchair in the head. In Texas,\r\n                                an officer reported a sergeant who had planted drugs in his ex-wife’s car. In Louisiana,\r\n                                a state trooper refused to participate in what he says was a cover-up in the case of\r\n                                Ronald Greene, who died in state custody after being beaten and stunned with a Taser.\r\n                                After speaking out, all of them were forced out of their departments and branded\r\n                                traitors by fellow officers.\r\n                            </p>\r\n                            <br>\r\n                            <strong class=\"frst-big extramar\">What the data means</strong>\r\n                            <br>\r\n                            <p class=\"main-content-show\">In our searchable database, the bold title for each entry and\r\n                                the sortable categories describe the nature of the allegation; they do not indicate\r\n                                whether the misconduct was proven to have occurred. The year column indicates when the\r\n                                purported wrongdoing happened. In some cases, it was reported later. Unless otherwise\r\n                                indicated, the accused officers and/or department leaders have denied wrongdoing.</p>\r\n                            <br>\r\n                            <strong class=\"frst-big extramar\">Where the data comes from</strong>\r\n                            <br>\r\n                            <p class=\"main-content-show\">USA TODAY spent more than a year unearthing the cases from\r\n                                thousands of documents from police and sheriff’s departments, prosecutors, oversight\r\n                                groups and labor regulators around the country, including federal files provided by\r\n                                confidential sources.</p>\r\n                            <br>\r\n                            <strong class=\"frst-big extramar\">More to this story</strong>\r\n                            <br>\r\n                            <p class=\"main-content-show\"><a target=\"_blank\" href=\"https://www.usatoday.com/in-depth/news/investigations/2021/12/09/blue-wall-police-misconduct-whistleblower-retaliation/8836387002/\"><u>Speaking\r\n                                        out against police misconduct brings trouble for officers</u></a></p>', '2023-12-15 17:56:42', '2023-12-15 17:57:02'),
(11, 'S.C. officer fired and arrested after stomping man in head, authorities say', 'Gina Barton', 'Gina Barton', 51, 10, '1702681228.webp', '2023-12-15 23:04:24', '<p class=\"main-content side-txt\">ORANGEBURG, S.C. — A police officer in Orangeburg has been\r\n                                fired and arrested after stomping the head of a man who was on his hands and knees\r\n                                causing his head to hit concrete, South Carolina authorities said.\r\n                            </p>\r\n                            <br>\r\n                            <p class=\"main-content-show\">Orangeburg Department of Public Safety Officer David Lance\r\n                                Dukes is charged with first-degree assault and battery in the attack on July 26,\r\n                                according to a warrant from the State Law Enforcement Division.</p>\r\n                            <br>\r\n                            <p class=\"main-content-show\">Dukes ordered a 58-year-old man who walks with a stick to the\r\n                                ground, but he moves carefully because he has pins and rods in his leg from a previous\r\n                                injury, attorney Justin Bamberg told <a href=\"https://thetandd.com/news/local/crime-and-courts/former-orangeburg-officer-charged-sled-warrant-alleges-he-forcibly-stomped-man-with-boot/article_d02ee8b8-bbd3-5c44-8f36-52f99c85701c.html#tracking-source=home-trending\">\r\n                                The Times and Democrat of Orangeburg.\r\n                                </a></p>\r\n                          \r\n                            <br>\r\n                            <p class=\"main-content-show\">“Because of my client’s disability, he’s relatively slow,” Bamberg said.\r\n\r\n                                    The man suffered a bruise to his forehead and was taken to the hospital by paramedics, according to the arrest warrant.\r\n\r\n                                    Dukes’ lawyer said he fully cooperated with state police and is taking the case seriously.\r\n\r\n                                    <br>\r\n                                    “This is a difficult situation and an unfortunate situation,” Jack Furse said. “He has absolutely no violent history and he’s not a proclivity to violence.”\r\n\r\n                                    Orangeburg Public Safety officials said Dukes, 38, was fired after their own review of the incident, which was captured on a body camera.\r\n\r\n                                    Bamberg said he hopes the city will release that footage.\r\n\r\n\r\n                                \r\n                            </p>', '2023-12-15 18:00:28', '2023-12-15 18:04:24');

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

--
-- Table structure for table `dirty_cop_us_home_pages`
--

CREATE TABLE `dirty_cop_us_home_pages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `home_banner` varchar(255) DEFAULT NULL,
  `quote_section` varchar(255) DEFAULT NULL,
  `mission_statement` text DEFAULT NULL,
  `one_line_section` text DEFAULT NULL,
  `contact_section` text DEFAULT NULL,
  `statement_image` varchar(300) DEFAULT NULL,
  `copy_badge_image` varchar(300) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `dirty_cop_us_home_pages`
--

INSERT INTO `dirty_cop_us_home_pages` (`id`, `home_banner`, `quote_section`, `mission_statement`, `one_line_section`, `contact_section`, `statement_image`, `copy_badge_image`, `created_at`, `updated_at`) VALUES
(1, '1702657243.png', '<p>“When the people fear their government, there is tyranny;\r\n                                when the government fears the people, there is liberty.” </p>\r\n                            <h6> - Thomas Jefferson</h6>', '<h3 class=\"stroke\">Mission Statement/ Background</h3>\r\n                    <p class=\"para\">\r\n\r\n                        The operators of the Website <strong><i>DirtyCop.US</i></strong> have witnessed and/or have\r\n                        personally been subjected to\r\n                        numerous <strong><i>Federal Crimes</i></strong> and other dishonorable and <strong><i>Criminal\r\n                                Acts</i></strong>, at the hands of those\r\n                        representing the absolute worst and most dangerous criminal in our society;</p><br>\r\n\r\n                    <h4 class=\"headings h4 mb-2\">A Criminal with a Badge</h4>\r\n\r\n\r\n                    <p class=\"para\">\r\n                        It is most evident throughout <strong><i>The United States, </i></strong> a country founded on\r\n                        certain principles of\r\n                        <strong><i>Freedom and Justice, </i></strong> and bound by very clear and distinct\r\n                        <strong><i>Constitutional Restrictions AND\r\n                                Guarantees, </i></strong> that <strong><i>Law Enforcement</i></strong> has free reign to\r\n                        commit crimes with impunity. Because they are\r\n                        almost never held accountable for their misdeeds and that it has never appeared to be in the\r\n                        interests of the <strong><i>Justice Department</i></strong> as a whole, nor certainly not any\r\n                        local level <strong><i>Law\r\n                                Enforcement</i></strong> entity, to <strong><i>Police</i></strong> their own, we feel it\r\n                        is <strong><i>far</i></strong> past time to expose that criminal\r\n                        conduct. As so many of <strong><i>the Criminal Acts</i></strong> to be described herein have\r\n                        resulted in substantial\r\n                        harm and loss to <strong><i>Innocent Citizens</i></strong>, including loss of life, we also,\r\n                        therefore, seek to assist\r\n                        anyone so harmed and affected by those heinous <strong><i>Criminal Acts</i></strong>. <br> <br>\r\n\r\n                        We have the utmost respect for <strong><i>Honest Law Enforcement</i></strong>. We feel that\r\n                        whether in the inner cities,\r\n                        or in rural areas, the job provides distinct challenges and potential for undue stress and\r\n                        obvious dangers. <strong><i>Law Enforcement Officers</i></strong> are sworn to\r\n                        <strong><i>Protect and Serve</i></strong> the public and to\r\n                        <strong><i>Support and Defend their State and Federal Constitution</i></strong> and it takes a\r\n                        special individual to\r\n                        honestly accept and honorably adhere to such ideals. The very real and harsh reality, however,\r\n                        is that far too many Officers ignore such creeds and promises and, moreover, were somehow able\r\n                        to slide through whatever limited psychological profiling they were in most cases not even\r\n                        forced to endure. The evident result has been a broad encompassing, far reaching, unaccountable\r\n                        faction of oft boldly <strong><i>Racist, Criminal Law Enforcers</i></strong>, operating freely\r\n                        throughout our society,\r\n                        committing nearly every crime imaginable.\r\n\r\n\r\n                    </p>', '<h3 style=\"margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 8px 0px; scroll-behavior: smooth; font-size: 16px; font-family: Poppins, sans-serif; text-align: center; line-height: 32px !important;\"><i style=\"margin: 0px; padding: 0px; scroll-behavior: smooth;\">And only a&nbsp;<span style=\"margin: 0px; padding: 0px; scroll-behavior: smooth; font-weight: bolder;\">DIRTY COP</span>&nbsp;would have a problem with our helping to expose&nbsp;<span style=\"margin: 0px; padding: 0px; scroll-behavior: smooth; font-weight: bolder;\">DIRTY COPS</span></i></h3>', '<h4 class=\"h4 text-center mt-3\" style=\"margin-right: 0px; margin-bottom: 13px; margin-left: 0px; padding: 8px 0px; scroll-behavior: smooth; font-weight: 600; line-height: 32px; color: rgb(37, 37, 37); font-size: 23px; font-family: Poppins, sans-serif; position: relative;\">We welcome any contact, opinions, observations, suggestions and any related matter and will respond where and when able and appropriate.</h4><p class=\"para text-center\" style=\"margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 8px 0px; scroll-behavior: smooth; text-align: justify; font-size: 16px; font-family: Poppins, sans-serif; line-height: 31px !important;\">If you wish to provide your history and incidents involving Crimes Committed by Law Enforcement and to have the Criminal’s Name(s) placed herein, please view the Submissions Criteria and provide the $10 fee. (You can also choose to remain anonymous.)</p>', '1702657251.png', '1702657258.png', '2023-12-15 00:20:41', '2023-12-15 11:20:58');

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

--
-- 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
(2, 'alaska', 1, '2023-12-11 21:07:10', '2023-12-12 20:01:25'),
(3, 'arizona', 1, '2023-12-12 19:55:47', '2023-12-12 20:01:18'),
(5, 'arkansas', 1, '2023-12-12 20:53:42', '2023-12-12 20:53:42'),
(6, 'Alabama', 1, '2023-12-12 21:12:43', '2023-12-12 21:12:43'),
(7, 'Arkansas', 1, '2023-12-12 21:12:59', '2023-12-12 21:12:59'),
(8, 'California', 1, '2023-12-12 21:13:12', '2023-12-12 21:13:12'),
(9, 'Colorado', 1, '2023-12-12 21:13:17', '2023-12-12 21:13:17'),
(10, 'Connecticut', 1, '2023-12-12 21:13:20', '2023-12-12 21:13:20'),
(11, 'Delaware', 1, '2023-12-12 21:13:24', '2023-12-12 21:13:24'),
(12, 'District Of Columbia', 1, '2023-12-12 21:13:30', '2023-12-12 21:13:30'),
(13, 'Florida', 1, '2023-12-12 21:13:33', '2023-12-12 21:13:33'),
(14, 'Georgia', 1, '2023-12-12 21:13:37', '2023-12-12 21:13:37'),
(15, 'Hawaii', 1, '2023-12-12 21:13:40', '2023-12-12 21:13:40'),
(16, 'Idaho', 1, '2023-12-12 21:13:44', '2023-12-12 21:13:44'),
(17, 'Illinois', 1, '2023-12-12 21:13:47', '2023-12-12 21:13:47'),
(18, 'Indiana', 1, '2023-12-12 21:13:50', '2023-12-12 21:13:50'),
(19, 'Iowa', 1, '2023-12-12 21:13:54', '2023-12-12 21:13:54'),
(20, 'Kansas', 1, '2023-12-12 21:13:58', '2023-12-12 21:13:58'),
(21, 'Kentucky', 1, '2023-12-12 21:14:03', '2023-12-12 21:14:03'),
(22, 'Louisiana', 1, '2023-12-12 21:14:06', '2023-12-12 21:14:06'),
(23, 'Maine', 1, '2023-12-12 21:14:10', '2023-12-12 21:14:10'),
(24, 'Maryland', 1, '2023-12-12 21:14:13', '2023-12-12 21:14:13'),
(25, 'Massachusetts', 1, '2023-12-12 21:14:16', '2023-12-12 21:14:16'),
(26, 'Michigan', 1, '2023-12-12 21:14:20', '2023-12-12 21:14:20'),
(27, 'Minnesota', 1, '2023-12-12 21:14:23', '2023-12-12 21:14:23'),
(28, 'Mississippi', 1, '2023-12-12 21:14:26', '2023-12-12 21:14:26'),
(29, 'Missouri', 1, '2023-12-12 21:14:29', '2023-12-12 21:14:29'),
(30, 'Montana', 1, '2023-12-12 21:14:32', '2023-12-12 21:14:32'),
(31, 'Nebraska', 1, '2023-12-12 21:14:36', '2023-12-12 21:14:36'),
(32, 'Nevada', 1, '2023-12-12 21:14:39', '2023-12-12 21:14:39'),
(33, 'New Hampshire', 1, '2023-12-12 21:14:44', '2023-12-12 21:14:44'),
(34, 'New Jersey', 1, '2023-12-12 21:14:50', '2023-12-12 21:14:50'),
(35, 'New Mexico', 1, '2023-12-12 21:14:55', '2023-12-12 21:14:55'),
(36, 'New York', 1, '2023-12-12 21:14:59', '2023-12-12 21:14:59'),
(37, 'North Carolina', 1, '2023-12-12 21:15:04', '2023-12-12 21:15:04'),
(38, 'North Dakota', 1, '2023-12-12 21:15:10', '2023-12-12 21:15:10'),
(39, 'Ohio', 1, '2023-12-12 21:15:13', '2023-12-12 21:15:13'),
(40, 'Oklahoma', 1, '2023-12-12 21:15:16', '2023-12-12 21:15:16'),
(41, 'Oregon', 1, '2023-12-12 21:15:19', '2023-12-12 21:15:19'),
(42, 'Pennsylvania', 1, '2023-12-12 21:15:24', '2023-12-12 21:15:24'),
(43, 'Rhode Island', 1, '2023-12-12 21:15:37', '2023-12-12 21:15:37'),
(44, 'South Carolina', 1, '2023-12-12 21:15:41', '2023-12-12 21:15:41'),
(45, 'South Dakota', 1, '2023-12-12 21:15:46', '2023-12-12 21:15:46'),
(46, 'Tennessee', 1, '2023-12-12 21:15:50', '2023-12-12 21:15:50'),
(47, 'Texas', 1, '2023-12-12 21:15:54', '2023-12-12 21:15:54'),
(48, 'Utah', 1, '2023-12-12 21:15:57', '2023-12-12 21:15:57'),
(49, 'Virginia', 1, '2023-12-12 21:16:05', '2023-12-12 21:16:05'),
(50, 'Washington', 1, '2023-12-12 21:16:09', '2023-12-12 21:16:09'),
(51, 'West Virginia', 1, '2023-12-12 21:16:14', '2023-12-12 21:16:14'),
(52, 'Wisconsin', 1, '2023-12-12 21:16:19', '2023-12-12 21:16:19'),
(53, 'Wyoming', 1, '2023-12-12 21:16:22', '2023-12-12 21:16:22');

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

--
-- Table structure for table `dirty_cop_us_objective_pages`
--

CREATE TABLE `dirty_cop_us_objective_pages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `objective_banner` varchar(255) DEFAULT NULL,
  `objective_section` text DEFAULT NULL,
  `objective_image` varchar(300) DEFAULT NULL,
  `principle_section` text DEFAULT NULL,
  `objective_text` text DEFAULT NULL,
  `remember_section_image` varchar(300) DEFAULT NULL,
  `welcome_content_section` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `dirty_cop_us_objective_pages`
--

INSERT INTO `dirty_cop_us_objective_pages` (`id`, `objective_banner`, `objective_section`, `objective_image`, `principle_section`, `objective_text`, `remember_section_image`, `welcome_content_section`, `created_at`, `updated_at`) VALUES
(1, '1702660712.png', '<h4 class=\"h4 m-0\">The Objectives of this Website are:</h4>\r\n                            <ul>\r\n                                <li class=\"para\">To provide <strong><i>Honest Citizens</i></strong> who have had their\r\n                                    <strong><i>Rights Violated</i></strong> an avenue\r\n                                    through which to publicize those <strong><i>Violations</i></strong> and to expose the\r\n                                    <strong><i>Criminal(s)</i></strong> responsible;\r\n                                </li>\r\n                                <li class=\"para\">To encourage more citizens to come forward and seek positive change;\r\n                                </li>\r\n                                <li class=\"para\">To gain support for legislation in <strong><i><u>all</u></i>\r\n                                    </strong> <strong><i>US States</i></strong> requiring <strong><i>INDEPENDENT REVIEW OF <u>ALL INCIDENTS OF\r\n                                        POLICE MISCONDUCT; </u></i></strong></li>\r\n                                <li class=\"para\">To hopefully discourage the next random, <strong><i>Criminal Act of the Dirty Cop;</i></strong>\r\n                                </li>\r\n                                <li class=\"para\">TO HELP ENABLE THE <strong>GOOD COP</strong> TO HELP EXPOSE THE <strong>DIRTY COP</strong>, WITHOUT FEAR\r\n                                    OF\r\n                                    REPRISAL.</li>\r\n                            </ul>', '1702659733.jpg', '<h4 class=\"h4 mt-3 mb-4 marb-head difclas\">We are guided by the following principles:</h4>\r\n                    <ul class=\"syn\">\r\n                        <li><strong>Integrity:</strong> We are committed to presenting only verified cases of misconduct\r\n                            and ensuring that our content is factual, accurate, and devoid of sensationalism. Our goal\r\n                            is to foster an informed citizenry, not to incite baseless distrust.</li>\r\n\r\n                        <li> <strong>Justice:</strong> We believe in the legal principle that no one is above the law.\r\n                            As such, we support and demand fair and thorough investigations into allegations of police\r\n                            misconduct, followed by appropriate actions based on the findings.</li>\r\n\r\n                        <li> <strong>Community:</strong> We aim to build a community of advocates, experts, and affected\r\n                            individuals to create a collaborative environment for change. By uniting voices from diverse\r\n                            backgrounds, we increase our capacity to instigate meaningful reform.</li>\r\n\r\n                        <li> <strong>Education:</strong> Through our platform, we will provide educational resources and\r\n                            training materials to inform the public of their rights when interacting with law\r\n                            enforcement, as well as to guide law enforcement agencies in implementing best practices\r\n                            that prevent abuses of power.</li>\r\n\r\n                        <li> <strong>Reform:</strong> We are proactive in our approach, seeking to work with legislative\r\n                            bodies, oversight agencies, and reform-minded law enforcement officials to develop and\r\n                            promote policies that enhance the accountability and transparency of police actions.</li>\r\n                    </ul>\r\n                    <p class=\"mt-3 mb-5 pb-3 para\">To these ends, we invite whistleblowers, journalists, civil rights\r\n                        activists,\r\n                        legal experts, and citizens to contribute to our cause. DirtyCop.US pledges to be a beacon of\r\n                        hope for those who feel marginalized and a bulwark against the erosion of civil liberties.\r\n                        Together, we can forge a path to a future where the rule of law is upheld and justice prevails\r\n                        for every American, regardless of their walk of life or the uniform worn by those who transgress\r\n                        against them.</p>', '<h3 class=\"stroke\">Remember:</h3>\r\n                    <p class=\"para rem\">While many <strong><i>US States </i></strong>have laws requiring <strong><i>Law\r\n                                Enforcement </i></strong>entities to have in\r\n                        place a\r\n                        written procedure for dealing with complaints against their <strong><i>\r\n                                Officers, </i><u>AND</u></strong> to provide a copy of\r\n                        that procedure to whomever requests it, they <strong> ARE NOT</strong> required to ever release\r\n                        any of their\r\n                        findings, nor confirm any disciplinary action concerning any Officer; <br><br>\r\n                        Most <strong><i>Counties</i></strong> and other local <strong><i>Government</i></strong> bodies\r\n                        deny all claims against them, regardless of\r\n                        merit. Even if there exists over-riding evidence, video tape, witness testimony, documentation,\r\n                        etc., proving those claims, the <strong><i>Counties</i></strong>/other deny any responsibility\r\n                        and, knowing how\r\n                        difficult, long and costly the prospect of fighting an action against a\r\n                        <strong><i>Government</i></strong> entity is and\r\n                        could be, they basically and coldly say to their trusting public,<i style=\"font-size: 15px;\">\r\n                            “Go ahead and try to sue us,\r\n                            we don’t care how badly our Employee harmed you.”</i><br><br>\r\n                        Whenever a Citizen attempts to file a <i>Grievance</i> against a <strong><i> Dirty\r\n                                Cop</i></strong>, they are forced to deal\r\n                        with a Superior who is also often a <strong><i>Dirty Cop</i></strong> and who does everything he\r\n                        can to “discourage”\r\n                        that Citizen from filing that Complaint. They make lame excuse after excuse, question the\r\n                        validity of the Complaint, insulting the Complainant as to their memory and awareness, and even\r\n                        resort to threatening measures, questioning whether or not it would be in the best interests of\r\n                        the Complainant to go through with their Complaint.<br><br>\r\n                        There exists one of the most archaic, hypocritical and irresponsible of all concepts/practices\r\n                        related to <strong><i>Law Enforcement</i></strong> throughout the <strong><i>US</i></strong>,\r\n                        referred to as,<strong><i> ‘The Blue Code’</i></strong>. Also known as <strong><i>The Blue Code\r\n                                of Silence, Blue Shield, Blue Wall, Curtain,</i></strong>\r\n                        or <strong><i>Veil</i></strong>, is an unwritten rule among\r\n                        <strong><i>Police Officers </i></strong>in the <strong><i>United States</i></strong> not to\r\n                        report on a colleague\'s crimes or mistakes. If\r\n                        questioned about an incident of misconduct involving another officer, while following the code,\r\n                        the officer being questioned would claim ignorance of another officer\'s wrongdoing. <u>Any</u>\r\n                        <strong><i>Officer</i></strong>\r\n                        who adheres to this <strong><i>‘Code’ </i></strong>is also a <strong><i>Criminal</i></strong>; a\r\n                        <strong><i>Dirty Cop</i></strong>, who should be charged and prosecuted\r\n                        for their attempted cover-ups. Upholding the law means not only when it is convenient for them\r\n                        to do so, nor in any fashion allows for them to decide which laws are acceptable to ignore.\r\n                        <br><br>\r\n                        <i style=\"font-size: 15px;\">(We nevertheless encourage all Victims to do whatever they can to\r\n                            expose the Criminal conduct of\r\n                            the Dirty Cop in any manner possible. We therefore suggest the filing of Grievances against\r\n                            individual Officers, insisting that the filing be made a matter of the Officer’s permanent\r\n                            record. We also recommend the filing of Claims against the responsible Departments and their\r\n                            respective Cities or Counties. We realize it is a difficult proposition to locate a viable\r\n                            Civil\r\n                            Rights Attorney to accept your case and prepare and file the matter in Federal Court,\r\n                            especially\r\n                            attempting to do so with no, or severely limited, financial resources. Still, certain of our\r\n                            submitters have indeed been able to prepare and file a Case in Federal Court with the help\r\n                            of a\r\n                            Paralegal for only a few hundred dollars.)</i>\r\n                    </p>', '1702659810.png', '<h4 class=\"h4 marb-end text-center mt-3\">We welcome any contact, opinions, observations, suggestions and\r\n                            any related matter and will respond where and when able and appropriate.</h4>\r\n                        <p class=\"para text-center\">If you wish to provide your history and incidents involving Crimes\r\n                            Committed by Law Enforcement and to have the Criminal’s Name(s) placed herein, please view\r\n                            the Submissions Criteria and provide the $10 fee. (You can also choose to\r\n                            remain anonymous.)</p>', '2023-12-15 00:20:41', '2023-12-15 12:18:32');

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

--
-- 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` enum('approve','disapprove') NOT NULL DEFAULT 'disapprove',
  `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', '3', '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>', 'approve', '2023-12-12 00:17:28', '2023-12-12 21:35:18'),
(3, 'Bribery trial of ex-Palm Springs mayor and developer delayed to 2024', '2023-12-13', '01:16', '7', '2', 'Nullam dictum', '1702412167.webp', 'Homicide', 'Albert Thompson', '<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>', 'approve', '2023-12-12 20:16:07', '2023-12-12 21:41:58');

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

--
-- Table structure for table `dirty_cop_us_review_pages`
--

CREATE TABLE `dirty_cop_us_review_pages` (
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `banner` varchar(300) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `dirty_cop_us_review_pages`
--

INSERT INTO `dirty_cop_us_review_pages` (`id`, `title`, `banner`, `created_at`, `updated_at`) VALUES
(1, 'Serch Reviews', '1702684400.png', '2023-12-15 23:49:04', '2023-12-15 18:53:20');

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

--
-- 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),
(6, '2023_12_14_212635_create_dirty_cop_us_home_pages_table', 3);

--
-- 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_featured_pages`
--
ALTER TABLE `dirty_cop_us_featured_pages`
  ADD PRIMARY KEY (`id`);

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

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

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

--
-- Indexes for table `dirty_cop_us_review_pages`
--
ALTER TABLE `dirty_cop_us_review_pages`
  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=23;

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

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

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

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

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

--
-- 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=7;

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

--
-- 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=7;
COMMIT;

