INSERT INTO `cad_settings` (`name`, `value`, `type`, `created_at`, `updated_at`, `deleted_at`) VALUES
	('community_logo', 'https://communitycad.app/images/default_images/communitycad.png', 'text', '2023-04-02 16:09:08', '2023-07-21 20:56:56', NULL),
	('community_name', 'Community CAD', 'text', '2023-04-02 16:09:08', '2023-06-24 16:56:58', NULL),
	('minimum_age', '14', 'number', '2023-04-02 16:09:08', '2023-04-02 16:09:08', NULL),
	('days_until_inactive', '14', 'number', '2023-04-02 16:09:08', '2023-04-02 16:09:08', NULL),
	('days_until_reapply', '7', 'number', '2023-04-02 16:09:08', '2023-04-02 16:09:08', NULL),
	('postal_map_link', NULL, 'text', '2023-04-02 16:09:08', '2023-07-21 21:30:58', NULL),
	('force_discord_link', 'true', 'bool', '2023-04-02 16:09:08', '2023-04-02 16:09:08', NULL),
	('force_steam_link', 'true', 'bool', '2023-04-02 16:09:08', '2023-04-02 16:09:08', NULL),
	('application_terms', 'You understand that you may only submit one application per recruitment cycle and that if you are denied you are required to wait until the next recruitment cycle to reapply.\r\n\r\nYou have read over the Application Rules & Regulations and agree to them?', 'markdown', '2023-04-02 16:09:08', '2023-09-25 22:46:43', NULL),
	('community_intro', 'Community Intro.', 'markdown', '2023-04-02 16:09:08', '2023-09-25 22:50:41', NULL),
	('members_must_apply', 'true', 'bool', '2023-04-02 16:09:08', '2023-04-02 16:09:08', NULL),
	('allow_same_name_civilians', 'false', 'bool', '2023-07-21 21:09:34', '2023-07-21 21:32:36', NULL),
	('state', 'San Andreas', 'text', '2023-09-25 22:35:53', '2023-09-25 22:35:53', NULL),
	('county', 'Blane County', 'text', '2023-09-25 23:06:34', '2023-09-25 23:06:34', NULL),
	('city', 'Los Santos', 'text', '2023-09-25 22:36:34', '2023-09-25 22:36:34', NULL),
	('officer_name_format', 'F. Last', 'text', '2024-01-20 21:46:05', '2024-01-20 21:46:05', NULL);

INSERT INTO `civilian_levels` (`id`, `name`, `civilian_limit`, `firearm_limit`, `vehicle_limit`, `license_types_allowed`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, 'Default', 99, 99, 99, '"{\\"data\\":[\\"1\\",\\"2\\",\\"3\\",\\"4\\",\\"5\\",\\"6\\",\\"7\\",\\"8\\",\\"12\\"]}"', '2023-02-11 00:07:53', '2023-11-04 20:01:31', NULL);

INSERT INTO `civilian_statuses` (`id`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, 'Alive', NULL, NULL, NULL),
	(2, 'Wanted', NULL, NULL, NULL),
	(3, 'Jailed', NULL, NULL, NULL),
	(4, 'Dead', NULL, NULL, NULL),
	(5, 'Hospitalized', NULL, NULL, NULL),
	(6, 'Pending Deleteion', NULL, NULL, NULL),
	(7, 'Deleted', NULL, NULL, NULL);

INSERT INTO `departments` (`id`, `name`, `initials`, `is_open_external`, `is_open_internal`, `slug`, `logo`, `created_at`, `updated_at`, `deleted_at`, `type`) VALUES
	(7, 'Community Wide', 'CW', 0, 0, 'community-wide', NULL, '2023-06-13 22:09:28', '2023-06-13 22:09:29', NULL, 1),
	(1, 'Blane County Sheriffs Office', 'BCSO', 1, 1, 'blane-county-sheriffs-office', 'https://communitycad.app/images/default_images/BCSO-2.png', '2023-05-19 17:34:13', '2023-06-17 17:57:25', NULL, 1),
	(2, 'Los Santos Police Department', 'LSPD', 1, 1, 'los-santos-police-department', 'https://communitycad.app/images/default_images/Police-6.png', '2023-05-19 17:34:14', '2023-10-07 17:40:34', NULL, 1),
	(3, 'San Andreas Highway Patrol', 'SAHP', 1, 1, 'san-andreas-highway-patrol', 'https://static.wikia.nocookie.net/alterlifepolicedepartement/images/b/b5/SAHP_logo.png', '2023-05-19 17:34:16', '2023-08-29 21:17:50', NULL, 1),
	(4, 'Civilian Operations', 'CIV', 1, 1, 'civilian-operations', 'https://content.invisioncic.com/y305077/monthly_2021_03/RCiv_Logo.png.62e84cd49d883db8492dc588c771b8bd.png', '2023-05-19 17:34:17', '2023-07-24 17:32:09', NULL, 3),
	(5, 'Communications', 'DISP', 1, 1, 'communications', 'https://static.wikia.nocookie.net/ultimate-roleplay/images/c/cb/LCPD-GTA4-logo.png', '2023-05-19 17:34:18', '2023-07-24 17:32:18', NULL, 2),
	(6, 'San Andreas Fire Rescue', 'SAFR', 1, 1, 'san-andreas-fire-rescue', 'https://communitycad.app/images/default_images/Fire Department-4.png', '2023-05-19 17:34:19', '2023-10-07 17:39:06', NULL, 4);

UPDATE departments SET id = 0 WHERE id = 7;

INSERT INTO `disciplinary_action_types` (`id`, `name`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, 'Level 1', NULL, '2023-06-12 19:58:57', '2023-06-12 19:58:57', NULL),
	(2, 'Level 2', NULL, '2023-06-12 19:59:02', '2023-06-12 19:59:02', NULL);

INSERT INTO `license_statuses` (`id`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, 'Valid', NULL, NULL, NULL),
	(2, 'Expired', NULL, NULL, NULL),
	(3, 'Suspended', NULL, NULL, NULL),
	(4, 'Revoked', NULL, NULL, NULL),
	(5, 'Pending Approval', NULL, NULL, NULL);

INSERT INTO `license_types` (`id`, `name`, `perm_name`, `prefix`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, 'Drivers License', 'drivers-license', 'DL', NULL, '2023-06-13 10:54:23', NULL),
	(2, 'Commercial Drivers License', 'cdl_license', 'CDL', NULL, NULL, NULL),
	(3, 'CCW License', 'ccw_license', 'CCW', NULL, NULL, NULL),
	(4, 'Security License', 'security_license', 'SC', NULL, NULL, NULL),
	(5, 'Tow License', 'tow_license', 'TW', NULL, NULL, NULL),
	(6, 'Fishing License', 'fishing_license', 'FSH', NULL, NULL, NULL),
	(7, 'Hunting License', 'hunting_license', 'HNT', NULL, NULL, NULL),
	(8, 'Pilot License', 'pilot-license', 'PL', NULL, '2023-09-25 22:07:45', NULL),
	(9, 'Weapons Permit', 'weapons-permit', NULL, '2023-11-04 19:59:57', '2023-11-04 19:59:57', NULL);

INSERT INTO `penal_code_classes` (`id`, `name`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, 'Felony', NULL, '2023-07-23 14:26:24', '2023-08-28 17:21:48', NULL),
	(4, 'Misdemeanor', NULL, '2023-07-23 14:26:55', '2023-08-28 17:21:54', NULL),
	(7, 'Infraction', NULL, '2023-07-23 14:27:15', '2023-07-23 14:27:15', NULL),
	(8, 'Information Only', NULL, '2023-11-03 13:00:27', '2023-11-03 13:00:27', NULL);

INSERT INTO `penal_code_titles` (`id`, `number`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, 1, 'Crimes Against The Person', '2023-07-23 14:09:39', '2023-07-23 14:17:44', NULL),
	(2, 2, 'Crimes Against Property And Criminal Profiteering', '2023-07-23 14:11:26', '2023-08-28 17:30:24', NULL),
	(3, 3, 'Crimes Against Public Decency', '2023-07-23 14:11:40', '2023-07-23 14:11:40', NULL),
	(4, 4, 'Test', '2023-07-23 14:20:20', '2023-07-23 14:20:41', '2023-07-23 14:20:41'),
	(5, 4, 'Test', '2023-07-23 15:45:18', '2023-07-23 15:46:21', '2023-07-23 15:46:21'),
	(6, 4, 'Crimes Against Public Justice', '2023-08-28 17:30:39', '2023-08-28 17:30:39', NULL),
	(7, 5, 'Crimes Against Public Peace', '2023-08-28 17:30:48', '2023-08-28 17:30:48', NULL),
	(8, 6, 'Crimes Against Public Health And Safety', '2023-08-28 17:30:56', '2023-08-28 17:30:56', NULL),
	(9, 7, 'Crimes Against State Dependents', '2023-08-28 17:31:08', '2023-08-28 17:31:08', NULL),
	(10, 8, 'Vehicular Offenses', '2023-08-28 17:31:20', '2023-08-28 17:31:20', NULL),
	(11, 9, 'Control Of Deadly Weapons And Equipment', '2023-08-28 17:31:28', '2023-08-28 17:31:28', NULL),
	(12, 10, 'Sentencing Enhancements', '2023-08-28 17:31:37', '2023-08-28 17:31:37', NULL),
	(13, 11, 'Road Law', '2023-08-28 17:31:45', '2023-08-28 17:31:45', NULL),
	(14, 12, 'Code Policy', '2023-08-28 17:31:53', '2023-08-28 17:31:53', NULL),
	(15, 13, 'State Code Violations', '2023-08-28 17:32:01', '2023-08-28 17:32:01', NULL),
	(16, 14, 'Amendments', '2023-08-28 17:32:09', '2023-08-28 17:32:09', NULL);

INSERT INTO `penal_codes` (`id`, `penal_code_title_id`, `number`, `name`, `section`, `notes`, `penal_code_class_id`, `fine`, `bail`, `in_game_jail_time`, `cad_jail_time`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(6, 1, 1, 'Intimidation', 'A person who communicates to another that they will physically harm or kill such other, placing such other in a reasonable state of fear for their own safety.\r\nA person who communicates that they will physically harm or kill another person’s close friends or relatives.\r\nSuch communication can be not just verbal, but also in writing or transmitted through other media.', 'Intimidation differs from assault in terms of the distance between the acts. Intimidation can occur across the street, while assault is up close, within reach of leading to battery. Intimidation replaces criminal threats.', 4, 0, 0, 60, 120, '2023-08-28 17:33:34', '2023-08-28 17:33:34', NULL),
	(7, 1, 2, 'Assault', 'A person who intentionally puts another in the reasonable belief of imminent physical harm or offensive contact.\r\n\r\nAssault is defined by distance the threats occur. Someone a few feet away threatening to harm or kill you at any moment is assault. Intimidation is less severe as there’s a distance that someone can escape through, or that the perpetrator has more time to reconsider the threat.\r\n*Any unwanted physical contact is considered to be battery, however grabbing someone during a threat may be either assault or battery, depending on intention and interpretation.*', NULL, 4, 750, 0, 30, 60, '2023-08-28 17:34:37', '2023-08-28 17:34:37', NULL),
	(8, 1, 3, 'Assault With A Deadly Weapon', 'A person who attempts to cause or threaten immediate harm to another while using a weapon, tool, or other dangerous item to communicate that threat.\r\n\r\n*NOTES:\r\nAssault With A Deadly Weapon matches the description of Assault, but the perpetrator also has a weapon or tool being used to communicate or facilitate that violence or fear. See Assault for additional notes. Any act of Intimidation with a weapon is considered Assault With a Deadly Weapon, but they must be visibly seen for this to count.*', NULL, 1, 10000, 0, 120, 240, '2023-08-28 17:36:09', '2023-08-28 17:36:09', NULL),
	(9, 1, 4, 'Battery', 'A person who uses intentional and unlawful force or violence to cause physical harm to another person.\r\n\r\nNotes:\r\n\r\n*Battery is defined as the moment aggressive physical contact occurs. The first punch or two would be Battery. To keep punching and fighting extensively afterward is Aggravated Battery.*\r\n\r\n*Grabbing someone may be either assault or battery, depending on the circumstances. Discharging bodily fluids onto another without their consent is considered battery.*', NULL, 4, 1000, 0, 60, 120, '2023-08-28 17:37:39', '2023-08-28 17:42:15', NULL),
	(10, 1, 5, 'Aggravated Battery', 'A person who uses great or continued force or violence against another person.', 'Aggravated Battery is the continued violence or battery against an individual, such as an ongoing fight or brawl, that doesn’t lead to severe bodily harm or life threatening injury.', 4, 0, 0, 120, 240, '2023-08-28 17:38:21', '2023-08-28 17:38:21', NULL),
	(11, 1, 6, 'Attempted Murder', 'A person who deliberately and intentionally attempts to kill or cause life threatening harm to another person through premeditated actions.\r\n\r\nA person who, by criminal accident, negligence, or in the heat of passion, causes severe or life threatening bodily harm to another person.\r\n\r\n* If occurring by accident, negligence, or in the heat of passion, the perpetrator shall receive the minimum sentence.\r\n\r\nNotes:\r\n* *Attempted Murder is a catch-all for any action that leads to severe bodily harm. It\'s range in imprisonment is intended to account for when such severe harm is premeditated or accidental.*\r\n* *For accidents and negligence there must be evidence of foul play, criminality in the instance, or some other factor beyond a truly accidental incident. For example, injuring someone while speeding or intoxicated.*\r\n* *Aggravated Battery is much less severe and would not, for example, leave someone in a coma or brutally wounded. There is however also no guarantee that being brutally wounded means attempted Murder as it depends on how the situation is Roleplayed.*', NULL, 1, 10000, 0, 240, 480, '2023-08-28 17:39:58', '2023-08-28 17:43:17', NULL),
	(12, 1, 7, 'Manslaughter', 'A person who unintentionally kills another, with or without a quarrel or heat of passion.\r\n\r\nA person who, through a criminal accident or negligence, causes someone\'s death.\r\n\r\n- If occurring by accident, negligence, or in the heat of passion, the perpetrator shall receive the minimum sentence.\r\n\r\nNOTES:\r\n* Manslaughter is murder that is not premeditated or proven to have intent or an opportunity to pause and reflect on killing that person. An opportunity to reflect (and therefore possibly change your mind) demonstrates premeditation and is murder. Manslaughter is only charged in the penal code when some sort of criminal negligence or action can be proven. Killing someone while driving drunk is manslaughter. Accidentally killing someone who jaywalks outside of a crosswalk is not criminal.', NULL, 1, 0, 0, 270, 540, '2023-08-28 17:44:42', '2023-08-28 17:44:42', NULL),
	(13, 1, 8, 'Murder', 'A person who unlawfully kills another with malice aforethought\r\n\r\nA person who commits murder while engaging in a felony offense that has been proven to be a premeditated act.\r\n\r\nNotes:\r\n* Murder is defined clearly by a person’s premeditated forethought or plan to commit the murder. Manslaughter happens in a heat of passion, by criminal negligence or accident, or for some other incident that is not expected. The only exception to this is when someone commits a planned felony, such as planning to commit an arson. If someone dies as a result of the premeditated arson, it is no longer manslaughter and instead murder.', NULL, 1, 0, 0, 600, 2880, '2023-08-28 17:46:03', '2023-08-28 17:46:03', NULL),
	(14, 1, 9, 'False Imprisonment', 'A person who detains or arrests another without their consent (or the consent of their guardian) without premeditated intent or ransom for less than one hour.\r\n\r\nA person who performs an unlawful citizen’s arrest.\r\n\r\n\r\nNOTES:\r\n* False Imprisonment is when someone is held against their will for less than one hour, without any premeditated intent (such as a plan to kidnap someone) or when there is no intention to ransom the individual.\r\n* Citizens arrest is a limited tool (defined elsewhere in the penal code) to hold individuals while awaiting police custody. Doing this unlawfully is considered a False Imprisonment.\r\n* If committed against a minor the perpetrator is punishable by the maximum sentence.', NULL, 1, 1000, 0, 60, 120, '2023-08-28 17:47:04', '2023-08-28 17:47:04', NULL),
	(15, 1, 10, 'Kidnapping', 'A person who detains or arrests another without their consent (or the consent of their guardian) with the premeditated intent to do so\r\n\r\nA person who detains or arrests another without their consent (or the consent of their guardian) for more than one hour.\r\n\r\nA person who detains or arrests another without their consent (or the consent of their guardian) with the intent or decision to hold that individual for ransom of any kind.\r\n\r\nNOTES:\r\n* Kidnapping is defined by a more egregious act of False Imprisonment. Kidnapping is when the False Imprisonment is premeditated or planned, done for ransom (any reward or action in return for the person’s safe return,) or for more than one hour, regardless of intent.\r\n* If committed against a minor the perpetrator is punishable by the maximum sentence.', NULL, 1, 0, 0, 210, 420, '2023-08-28 17:48:34', '2023-08-28 17:48:34', NULL),
	(16, 1, 11, 'Torture', 'A person who intentionally causes extreme pain and suffering to someone.\r\n\r\nA person who causes pain and suffering for the purpose of revenge, extortion, persuasion, or for any sadistic purpose.\r\n\r\nNOTES:\r\n* Torture is in many ways a penal code entry to enhance other charges. Torture can be added to any change in an instance where Torture took place while, or along with, the crime being committed. It is not automatically applied to charges that may be considered Torture (such as an Arson that leads to Murder) unless there is the demonstration of the perpetrator torturing someone specifically in that act of Arson. Ultimately it is up to police to use this charge responsibly.', NULL, 1, 0, 0, 600, 2880, '2023-08-28 17:49:31', '2023-08-28 17:49:31', NULL),
	(17, 2, 1, 'Arson', 'A person who intentionally and maliciously sets fire to or burns any structure, forest land, or property without prior authorization.\r\n\r\nA person who intentionally aids, counsels, or helps facilitate the burning of any structure, forest land, or property without proper authorization.\r\n\r\nA person who, through criminal accident or negligence, causes a fire to burn any structure, forest land, or property.\r\n\r\nNOTES:\r\n* Arson’s criminality is when someone intentionally creates or helps create a fire, as it can easily grow out of control and cause death. It is up to the Fire Marshal’s Office and investigating Law Enforcement Agency jointly to prove an arson was malicious and therefore criminal. Negligence or accident can be included if it is proven criminal in nature.\r\n* If occurring by accident or negligence, the perpetrator shall receive the minimum sentence.', NULL, 1, 0, 0, 210, 420, '2023-08-30 12:54:07', '2023-08-30 12:54:07', NULL),
	(18, 2, 2, 'Trespassing', 'A person who enters another’s property while it is closed or not in operation without the expressed or written permission to do so.\r\n\r\nA person who enters the restricted area of an open facility or property as defined and clearly marked by the property manager without the expressed or written permission to do so.\r\n\r\nThis cannot stack with (2)03. Trespassing within a Restricted Facility.\r\n\r\nThis crime cannot stack with any form of Burglary\r\n\r\nNOTES :\r\n* Trespassing refers to anyone who is told to leave and refuses to do so, but lacks any intention of committing a crime or other malice aforethought or action. Burglary is a far more severe act of trespassing as it comes with evidence of criminal intent.\r\n* If police close down a public space it is trespassing to enter that public space without their authorization. The same applies if a typically public space is temporarily closed.', NULL, 4, 1000, 0, 30, 60, '2023-08-30 12:55:20', '2023-08-30 12:55:20', NULL),
	(19, 2, 3, 'Trespassing within a Restricted Facility', 'A person who, without proper authorization, enters any government owned or managed facility that is secured with the intent of keeping ordinary citizens outside.\r\n\r\nSuch facilities include (but are not limited to) correctional institutions, military encampments, and federally restricted spaces.\r\n\r\nThis does not apply to local facilities, such as restricted areas within police stations, hospitals, and courthouses.\r\n\r\nThis charge cannot stack with (2)02. Trespassing\r\n\r\nThis charge cannot stack with any form of Burglary.\r\n\r\nNOTES:\r\n* Trespassing a restricted facility is assumed to have criminal intent akin to burglary, so it cannot stack with burglary even as it is still a severe and appropriate punishment.', NULL, 1, 0, 0, 60, 120, '2023-08-30 12:56:12', '2023-08-30 12:56:12', NULL),
	(20, 2, 4, 'Burglary', 'A person who enters into the locked or restricted property of another without their permission with the intention of committing a crime, typically theft.\r\n\r\nThis crime cannot stack with any form of Trespassing.\r\n\r\nNOTES :\r\n* Burglary can include homes, apartments, offices, vehicles or any locked space with restricted access. Burglary is also committed irrelevant if any theft or other crime takes place. A less severe act of burglary is trespassing, which would account for instances where there is no intent to commit a crime, no locked door or other physical restriction.', NULL, 4, 0, 0, 150, 300, '2023-08-30 12:57:56', '2023-08-30 12:57:56', NULL),
	(21, 2, 5, 'Possession Of Burglary Tools', 'A person who has in their possession the appropriate combination of tools necessary to commit burglary, such as a tension bar along with a screwdriver, shimmy, or other appropriate items.\r\n\r\nNOTES:\r\n* It must be demonstrated that the person has a certain combination of these tools or in an appropriate context that would assume their usage in burglary. Having a screwdriver is not punishable alone, but a screwdriver, along with a tension bar, is punishable.', NULL, 7, 3000, 0, 0, 0, '2023-08-30 12:58:51', '2023-08-30 12:58:51', NULL),
	(22, 2, 6, 'Robbery', 'A person who takes property from the possession of another against their will, by means of force or fear, such as through intimidation, assault or battery.\r\n\r\nThis charge cannot stack with (2)07. Armed Robbery.\r\n\r\nNOTES :\r\n* Robbery stacks with any Title 1 crimes that are attempted during the Robbery. It cannot stack with Armed Robbery, which is when the force, intimidation, or fear involves a dangerous weapon.', NULL, 1, 0, 0, 150, 300, '2023-08-30 13:00:32', '2023-08-30 13:00:32', NULL),
	(23, 2, 7, 'Armed Robbery', 'A person who takes property from the possession of another against their will, by means of force facilitated with a weapon or with an item used as a weapon.\r\n\r\nThis charge cannot stack with (2)06. Robbery.\r\n\r\nNOTES:\r\n* Armed Robbery stacks with any Title 1 crimes that are attempted during the robbery. It cannot stack with Robbery.', NULL, 1, 0, 0, 180, 360, '2023-08-30 13:01:50', '2023-08-30 13:01:50', NULL),
	(24, 2, 8, 'Petty Theft', 'A person who steals or takes the personal property of another worth $3,000 or less.\r\n\r\nA person who fails to pay a contract or invoice within a reasonable amount of time for services totaling less than $3,500 in value.', NULL, 4, 1000, 0, 0, 0, '2023-08-30 13:02:47', '2023-08-30 13:02:47', NULL),
	(25, 2, 9, 'Theft', 'A person who steals or takes the personal property of another worth more than $1,500 but less than $10,000.\r\n\r\nA person who fails to pay a contract or invoice within a reasonable amount of time for services totaling more than $3,500 but less than $20,000 in value.', NULL, 4, 2000, 0, 0, 0, '2023-08-30 13:03:38', '2023-08-30 13:03:38', NULL),
	(26, 2, 10, 'Grand Theft', 'A person who steals or takes the personal property of another worth more than $10,000.\r\n\r\nA person who fails to pay a contract or invoice within a reasonable amount of time for services totaling more than $10,000 in value.', NULL, 1, 0, 0, 90, 180, '2023-08-30 13:05:45', '2023-08-30 13:05:45', NULL),
	(27, 2, 11, 'Grand Theft Auto', 'A person who commits the theft of any motor vehicle, no matter the value.\r\n\r\nA person who illegally enters any parked vehicle’s driver seat.\r\n\r\nA person who a unlawfully enters a vehicle.\r\n\r\nThis charge cannot stack with any form of Trespassing or Burglary.\r\n\r\nNOTES:\r\n* Grand Theft Auto does stack with theft, but not burglary or trespassing.', NULL, 1, 0, 0, 120, 240, '2023-08-30 13:06:33', '2023-08-30 13:06:33', NULL),
	(28, 2, 12, 'Grand Theft Of A Firearm', 'A person who commits theft of any firearm, no matter the value or whether it is registered.\r\n\r\nNOTES :\r\n* Grand Theft Of A Firearm does stack with Theft.', NULL, 1, 0, 0, 120, 240, '2023-08-30 13:07:32', '2023-08-30 13:07:32', NULL),
	(29, 2, 13, 'Receiving Stolen Property', 'A person who knowingly buys or receives any property that has been stolen or that has been obtained in any manner constituting theft or extortion.\r\n\r\nNOTES:\r\n* If an officer can prove that the individual should have known the item was stolen based on outside factors, such as the price or quality, or any sort of common knowledge, then the person can be charged.', NULL, 4, 10000, 0, 90, 180, '2023-08-30 13:08:24', '2023-08-30 13:08:24', NULL),
	(30, 2, 14, 'Extortion', 'A person who intimidates or influences another to provide or hand over properties or services.\r\n\r\nA person who utilizes or threatens their power or authority with demonstrated malice aforethought in order to compel action by another.\r\n\r\nA person who utilizes privileged information to intimidate another for certain property or services.\r\n\r\n\r\nNOTES:\r\n* Extortion depends on a person or organization using its authority, power, or influence to intimidate and threaten someone in return for property or services. Property may be demanding money to keep quiet or demanding a certain personal payment to prevent a strike.\r\n* Extortion may serve in lieu of corruption depending on the circumstances, or if it involves a private organization.\r\n* A union threatening a strike or collective worker action is NOT extortion unless a specific leader or member is being paid to influence union operations.', NULL, 1, 10000, 0, 120, 240, '2023-08-30 13:09:33', '2023-08-30 13:09:33', NULL),
	(31, 2, 15, 'Forgery', 'A person who knowingly alters, creates, or uses a written document with the intent to defraud or deceive another.\r\n\r\nA person who knowingly signs a document or agreement, electronic or otherwise, without the consent or authority of whom they are signing for.', NULL, 4, 0, 0, 60, 120, '2023-08-30 13:10:16', '2023-08-30 13:10:16', NULL),
	(32, 2, 16, 'Fraud', 'A person who intentionally misrepresents a matter of fact - whether by words or by conduct, by false or misleading allegations, or by concealment of what should have been disclosed - that deceives and is intended to deceive another so that such other will act upon it to their disadvantage.', NULL, 1, 0, 0, 90, 180, '2023-08-30 13:10:38', '2023-08-30 13:10:38', NULL),
	(33, 2, 17, 'Vandalism', 'A person that defaces, damages, or destroys property which belongs to another.', NULL, 4, 1000, 0, 90, 180, '2023-08-30 13:11:14', '2023-08-30 13:11:14', NULL),
	(34, 3, 1, 'Lewd Or Dissolute Conduct In Public', '1.	A person who solicits anyone to engage in inappropriate sexual or sexually suggestive conduct in any public place or in any place open to the public or exposed to public view.\r\n2.	A person who engages in inappropriate sexual or sexually suggestive conduct in any public place or in any place open to the public or exposed to public view.\r\n3.	A person who solicits sexual activity in a public place or any place open to public view.\r\n\r\nNOTES:\r\nLewd or Dissolute Conduct refers to actions that are not necessarily Indecent Exposure, but can presumably involve or lead to Indecent Exposure. Suggestive motions or gestures in bathroom stalls or other areas that are considered indecent but not naked or involve genitalia is Lewd Or Dissolute Conduct.\r\nThis also applies for Indecent Exposure in areas like restrooms which involve your genitalia.', NULL, 4, 0, 0, 60, 120, '2023-11-02 23:41:19', '2023-11-02 23:41:19', NULL),
	(35, 3, 2, 'Indecent Exposure', '1. A person who intentionally exposes their naked body or genitalia on public property or in the public area of a privately owned business.\r\n2. A person who intentionally exposes their naked body or genitals to another person without that person\'s consent.\r\n3. A person who intentionally exposes their naked body or genitalia on private property without permission of the property owner.\r\n4. A person who engages in sex or other sexual activity in the view of a minor.\r\n\r\n\r\nNOTES\r\nPrivate parties / reservations in public areas are considered public events that can be restricted and therefore permit naked bodies. It is when it is in a public area or exposed to children that it is indecent exposure.\r\nGenitalia does not include breasts. Assume below the belt exposure.\r\n- If committed knowingly in the presence of a minor, the perpetrator shall receive the maximum sentence.', NULL, 4, 0, 0, 60, 120, '2023-11-02 23:43:30', '2023-11-02 23:43:30', NULL),
	(36, 3, 3, 'Prostitution', '1. A person who knowingly engages in or offers to engage in a sexual act in exchange for payment or other goods and services.\r\n\r\n\r\nNOTES\r\nAnyone who cannot be proven to commit prostitution may charged with Indecent Exposure or Lewd or Dissolute Conduct depending on the circumstances.\r\nProstitution punishes the payee. The payor is charged with Indecent Exposure or Lewd Conduct', NULL, 1, 2000, 0, 60, 120, '2023-11-02 23:44:10', '2023-11-02 23:44:10', NULL),
	(37, 3, 4, 'Pandering / Pimping', '1. A person who solicits or advertises, aids or provides transport or supervises persons involved in prostitution and retains some or all of the money earned.', NULL, 1, 10000, 0, 150, 300, '2023-11-02 23:44:47', '2023-11-02 23:44:47', NULL),
	(38, 3, 5, 'Sexual Assault', '1. A person who commits verbal abuse for the purpose of sexual arousal, gratification, or abuse.\r\n2. A person who threatens imminent harm or nonconsensual sexual contact or puts another under the belief of imminent harm or nonconsensual sexual contact.', NULL, 1, 10000, 0, 120, 240, '2023-11-02 23:45:55', '2023-11-02 23:45:55', NULL),
	(39, 3, 6, 'Sexual Battery', '1. A person who commits unwanted touching or sexual contact.\r\n2. A person who causes battery or similar aggressive physical contact for the purpose of sexual arousal, gratification, or abuse.', NULL, 1, 20000, 0, 120, 240, '2023-11-02 23:46:37', '2023-11-02 23:46:37', NULL),
	(40, 3, 7, 'Rape', '1. A person who forces another to engage in sexual intercourse.\r\n2. A person who performs non consensual sexual intercourse with another.\r\n3. A person who performs sexual intercourse with another who is incapacitated, disabled, or unable to give consent.', NULL, 1, 0, 0, 210, 420, '2023-11-02 23:47:23', '2023-11-02 23:47:23', NULL),
	(41, 3, 8, 'Statutory Rape', '1. A person who engages in mutually-interested sexual intercourse with another who is under the age of 16 and therefore cannot give legal consent.\r\n2. A person who engages in sexually explicit activity with another who is under the age of 16 is subject to to (3)08. Statutory Rape.', NULL, 1, 0, 0, 300, 600, '2023-11-02 23:48:40', '2023-11-02 23:48:40', NULL),
	(42, 3, 9, 'Stalking', '1. A person who intentionally and maliciously follows or harasses another person who has made it known that they do not consent to such following or harassment,\r\n2. A person whose actions cause another person to reasonably fear for their safety, or the safety of their close friends or relatives.\r\n3. A person who violates an official restraining order issued by a court.\r\n\r\nNotes\r\n- If the perpetrator violated a restraining order, they shall receive the maximum sentence', NULL, 1, 0, 0, 120, 240, '2023-11-02 23:49:26', '2023-11-02 23:49:26', NULL),
	(43, 6, 1, 'Bribery', '1. A person who offers or gives a monetary gift, gratuity, valuable goods, or other reward to a public official, government employee, or peace officer in an attempt to influence their duties or actions.\r\n2. A person who gives services or nonmaterial, but valuable actions to a public official, government employee, or peace officer in an attempt to influence their duties or actions.', NULL, 1, 10000, 0, 120, 240, '2023-11-02 23:50:06', '2023-11-02 23:50:06', NULL),
	(44, 6, 2, 'Failure To Pay A Fine', '1. A person who fails to pay a fine or court ordered fee within clearly stated and allotted time period.\r\n2. Typically most fines carry a 3 day payment period unless stated otherwise by the issuer.\r\n3. A person CAN be given the opportunity to pay all fines in lieu of being arrested when being approached.\r\n4. This charge may not be stacked for each fine that is unpaid at the time of arrest.', NULL, 4, 0, 0, 60, 120, '2023-11-02 23:51:28', '2023-11-02 23:51:28', NULL),
	(45, 6, 3, 'Contempt of Court', '1. A person who willfully disobeys the verbal or written order of a court authority, disrespects the decorum of the court, or otherwise infringes upon due process.\r\n2. This charge can only be issued by a judge or agent of a court.\r\n\r\n\r\nNOTES\r\nThe Contempt of Court charge is an imprisonment set by a judge relative to a particular court case and the actions committed by the individual disobeying court orders and activities. This is different from (4)04. Subpoena Violation which has to do with official paperwork or documents.', NULL, 4, 1000, 0, 60, 120, '2023-11-02 23:52:22', '2023-11-02 23:52:22', NULL),
	(46, 6, 4, 'Subpoena Violation', '1. A person who ignores or violates a subpoena order issued by the Courts.\r\n2. A person who ignores or violates a request by the courts to be present at a hearing.\r\n3. A person who ignores or disobeys an official document issuing orders or actions by a court.\r\n4. A person in violation of a court injunction or other government operation.', NULL, 4, 1000, 0, 60, 120, '2023-11-02 23:52:59', '2023-11-02 23:52:59', NULL),
	(47, 6, 5, 'Dissuading A Witness Or Victim', '1. A person who knowingly and maliciously prevents or encourages any witness or victim from attending or giving testimony at any trial, proceeding, or inquiry authorized by law with the use of bribery, fear, or other tactics.\r\n2. A person who prevents the distribution, completion, answering, or due process of an affidavit or other legal statement.', NULL, 1, 20000, 0, 60, 120, '2023-11-02 23:54:25', '2023-11-02 23:54:25', NULL),
	(48, 6, 6, 'False Information To A Government Employee', '1. A person who provides false information or details to a police officer during the course of a criminal investigation or lawful detainment.\r\n2. A person who provides knowingly inaccurate data to a government employee investigating in some official capacity.\r\n3. This charge cannot stack with (4)08. Perjury.', NULL, 4, 5000, 0, 60, 120, '2023-11-02 23:55:03', '2023-11-02 23:55:03', NULL),
	(49, 6, 7, 'Filing A False Complaint', '1. A person who knowingly files a false complaint, statement, document, or representation with any organization regarding the conduct, job performance, or behavior of a public official or employee for the purpose of initiating false administrative action against that official.', NULL, 4, 5000, 0, 60, 120, '2023-11-02 23:55:37', '2023-11-02 23:55:37', NULL),
	(50, 6, 8, 'Perjury', '1. A person who knowingly provides false information while under oath in a court of law\r\n2. A person who knowingly provides false information as part of an affidavit, testimony, court-ordered deposition, or document with a statement signifying its authenticity under penalty of perjury.\r\n3. This charge cannot stack with (4)06. False Information To A Government Employee.', NULL, 1, 0, 0, 200, 400, '2023-11-02 23:56:27', '2023-11-02 23:56:27', NULL),
	(51, 6, 9, 'Failure To Identify To A Peace Officer', '1. A person who, while being detained or under arrest by a peace officer, fails to provide a peace officer or other legal authority their name as it appears on an I.D. card or other identifiable information for MDC purposes.\r\n\r\nNOTES\r\nAs per (12)11. Maximum Imprisonment someone who fails to identify and provide a way to properly charge them, and who can be identified through no other means, will be imprisoned until they identify themselves, after which this charge, plus all applicable charges, can be placed on their record and their sentence adjusted.\r\n\r\n**MUST PUT IN CUSTOM JAIL TIME WHEN WRITING THE TICKET**', NULL, 4, 0, 0, 0, 0, '2023-11-02 23:57:42', '2023-11-02 23:57:42', NULL),
	(52, 6, 10, 'Impersonation Of A Government Employee', '1. A person who pretends or implies the role of a government worker, such as a peace officer, paramedic, tax collector, federal investigator, or other official.\r\n2. A person who wears an official or realistic government employee uniform with an official or realistic badge or identification tag except on an official, legally sanctioned movie or production set.\r\n3. A person who claims to be a government worker in order to deceive or take advantage of another individual or organization.', NULL, 4, 1000, 0, 60, 120, '2023-11-02 23:58:26', '2023-11-02 23:58:26', NULL),
	(53, 6, 11, 'Obstruction Of A Government Employee', '1. A person who shows a clear and motivated attempt to prevent a government employee from conducting their duties.\r\n2. A person who fails to comply with an officer\'s lawful orders.\r\n3. A person who, after being issued a ticket, citation, or infraction, continues to violate such law and ignore an officer’s orders.\r\n\r\nNOTES\r\nA government employee would need to contact a peace officer to get the charge of Obstruction issued.', NULL, 4, 1000, 0, 60, 120, '2023-11-02 23:59:15', '2023-11-02 23:59:15', NULL),
	(54, 6, 12, 'Resisting A Peace Officer', '1. A person who avoids apprehension from an officer by non-vehicular means or resists apprehension by any physical means.\r\n2. This charge does not include the attempt to flee and elude by vehicular means, which is (8)02. Evading a Peace Officer.', NULL, 4, 1000, 0, 60, 120, '2023-11-03 00:00:02', '2023-11-03 00:00:02', NULL),
	(55, 6, 13, 'Escape From Custody', '1. A person who has been physically detained by use of restraints or physical force by a peace officer and escapes from said Peace Officer’s personal custody, resulting in a warrant or APB being needed to apprehend the suspect.\r\n2. Until a warrant or APB is placed, this incident is classified as (4)12. Resisting a Peace Officer.', NULL, 1, 0, 0, 60, 120, '2023-11-03 00:01:03', '2023-11-03 00:01:03', NULL),
	(56, 6, 14, 'Escape', '1. Any person arrested, booked, charged, or convicted of any crime who thereafter escapes from a county or city jail, prison, community service, or custody of a Correctional or Parole Officer.', NULL, 1, 10000, 0, 90, 180, '2023-11-03 00:01:49', '2023-11-03 00:01:49', NULL),
	(57, 6, 15, 'Prisoner Breakout', '1. A person who directly aids or assists an inmate with escaping from the law, including the lawful custody of a peace officer, prisoner transport, parole, community service, or incarceration in a county jail or state prison.\r\n2. A person who provides information or insights that subsequently assist an inmate with escaping from the law.', NULL, 1, 10000, 0, 90, 180, '2023-11-03 00:02:24', '2023-11-03 00:02:24', NULL),
	(58, 6, 16, 'Human Trafficking', '1. A person who intentionally smuggles non-citizens into the state without proper visas and authorization.\r\n2. A person who intentionally restricts another’s liberty with intent for forced labor or sex trafficking, or other forced activities.\r\n3. This charge does not stack with (1)10. Kidnapping', NULL, 1, 50000, 0, 300, 600, '2023-11-03 00:03:14', '2023-11-03 00:03:14', NULL),
	(59, 6, 17, 'Misuse Of A Government Hotline', '1. A person who uses an emergency government hotline for any purpose other than an emergency situation which involves a life-or-death request for assistance or other purposes dictated by the hotline managers.\r\n2. A person who uses any non-emergency or public hotline for purposes irrelevant to that particular government office, department, or agency.\r\n3. A person who performs prank calls, fake calls, or tries to incite mayhem through public government lines\r\n\r\nNOTES\r\n- Upon the third offense Penal Code (4)15) is a misdemeanor punishable by imprisonment. This falls under Officer Discretion.', NULL, 7, 1500, 0, 0, 0, '2023-11-03 00:04:05', '2023-11-03 00:04:05', NULL),
	(60, 6, 18, 'Tampering With Evidence', '1. A person who destroys or attempts to destroy, conceal, or alter any evidence that can later potentially be used in a Criminal investigation or court proceeding.', NULL, 1, 10000, 0, 60, 120, '2023-11-03 00:04:49', '2023-11-03 00:04:49', NULL),
	(61, 6, 19, 'Introduction Of Contraband', '1. A person who provides contraband to an inmate of a correctional facility, or attempts to enter a facility with the intent to illegally transport contraband within it.', NULL, 1, 0, 0, 120, 240, '2023-11-03 00:05:21', '2023-11-03 00:05:21', NULL),
	(62, 6, 20, 'Violation Of Parole Or Probation', '1. A person who willfully violates the terms of a probation or parole agreement.', NULL, 1, 0, 0, 240, 480, '2023-11-03 00:06:29', '2023-11-03 00:06:29', NULL),
	(63, 6, 21, 'Voter Fraud / Voter Pandering', '1. An individual who dissuades or influences official voting outcomes through illicit, illegal, or unethical manners.', NULL, 1, 0, 0, 60, 120, '2023-11-03 00:07:03', '2023-11-03 00:07:03', NULL),
	(64, 6, 22, 'Corruption Of Public Duty', '1. A government employee who acts outside the interests of the public good or public justice.\r\n2. A government employee who demonstrates criminal negligence in their duties.\r\n3. A government employee convicted by the Department of Justice for committing a felony while on duty.\r\n\r\nNOTES\r\n- Must be reported to Internal Affairs', NULL, 1, 0, 0, 60, 120, '2023-11-03 00:08:10', '2023-11-03 00:08:10', NULL),
	(65, 6, 23, 'Corruption Of Public Office', '1. A person who acts outside the interests of the public good, public justice, or duties of those in public office.', NULL, 1, 0, 0, 120, 240, '2023-11-03 00:08:43', '2023-11-03 00:08:43', NULL),
	(66, 7, 1, 'Disturbing The Peace', '1. A person who creates a dangerous or intimidating situation in a public place or in the public area of private property.\r\n2. A person who attempts to provoke, incite, or promote harm to another person through gestures, language, claims, actions, or other methods.\r\n3. A person whose profanity, language, voice, or noise reasonably disturbs nearby civilians or intends to incite violence.', NULL, 4, 1000, 0, 60, 120, '2023-11-03 00:09:19', '2023-11-03 00:09:19', NULL),
	(67, 7, 2, 'Unlawful Assembly', '1. A person, without proper permits or authorization, who refuses to leave public property or clear a street or passageway after being ordered to do so by its state agency property manager or a peace officer.\r\n2. A person who refuses to leave the scene of a crime or other area after being ordered to so whose presence could hinder police operations.\r\n3. A group that fails to protest or demonstrate peacefully in a designated “free speech zone” or without proper permits or authorization from the city.\r\n4. A person who refuses to leave private property they were invited to access after being instructed to do so by the property owner or manager.\r\n5. This charge cannot stack with Trespassing of any kind. This charge also cannot stack with (5)02. Obstruction Of A Government Employee when charged in relation to public property', NULL, 4, 0, 0, 60, 120, '2023-11-03 00:09:59', '2023-11-03 00:09:59', NULL),
	(68, 7, 3, 'Incitement To Riot', '1. A person whose actions deliberately agitates or intends to agitate a crowd or large group of people organized or located peacefully in a public or private area in order to promote acts of violence or civil unrest.\r\n2. A group of people who could be reasonably identified by a peace officer to be gang members whose actions in a public area intend to incite violence, encourage mayhem, or promote civil unrest.', NULL, 4, 1000, 0, 60, 120, '2023-11-03 00:10:29', '2023-11-03 00:10:29', NULL),
	(69, 7, 4, 'Vigilantism', '1. A person who attempts to effect justice according to their own understanding of right and wrong, or an unauthorized person attempts to enforce the law. A citizen\'s arrest may only be effected when a civilian, out of fear for their own safety or the safety of their close friends or relatives, subdues or detains another who is violating the law.\r\n2. A person who attempts a citizen\'s arrest or other vigilante justice in the vicinity of a peace officer or other authority who could otherwise carry out a legal arrest, whether or not a lawful Citizen’s Arrest.\r\n3. A person who violates (12)10. Good Samaritan Clause.\r\n\r\nNOTES\r\nVigilantism does not apply when a law enforcement officer in the vicinity is in need of immediate assistance, and a civilian aids such officer - for example, helping an officer apprehend an unarmed resisting suspect by holding him down.', NULL, 1, 0, 0, 60, 120, '2023-11-03 00:11:24', '2023-11-03 00:11:24', NULL),
	(70, 8, 1, 'Possession Of A Controlled Substance', '1. A person who possesses any controlled substance, except when the substance has been lawfully prescribed to them by a licensed practitioner of medicine or is legally available without a prescription.', NULL, 4, 1000, 0, 60, 120, '2023-11-03 12:47:12', '2023-11-03 12:47:12', NULL),
	(71, 8, 2, 'Possession Of A Controlled Substance With Intent To Sell', '1. A person in possession of a controlled substance or multiple controlled substances in an amount of over one ounce (28 grams)\r\n\r\n\r\nNOTES\r\n- At 28 grams or higher, for every 14 grams in total possession. If the perpetrator has, for example, 60 grams, which is 2 ounces and 4 grams, charge them, which is four half-ounce increments (56 grams) and rounded up for the last half ounce (the next 14 grams or less.)\r\n- Penal Code (6)02 is a felony punishable for every half-ounce (14 grams) of total controlled substances in possession upon arrest. Total possession is rounded up to the nearest half-ounce if the perpetrator has more than 28 grams.', NULL, 1, 20000, 0, 60, 120, '2023-11-03 12:48:22', '2023-11-03 12:48:22', NULL),
	(72, 8, 3, 'Possession Of Drug Paraphernalia', '1. A person who willingly possesses a device or mechanism used exclusively for the processing or consumption of an illegal controlled substance.', NULL, 7, 1500, 0, 0, 0, '2023-11-03 12:48:58', '2023-11-03 12:48:58', NULL),
	(73, 8, 4, 'Maintaining A Place For The Purpose Of Distribution', '1. A person who opens or maintains any property for the purpose of unlawfully selling, giving away, storing, or using any controlled substance, firearm, or other illicit device, good, or service.', NULL, 4, 1000, 0, 90, 180, '2023-11-03 12:49:29', '2023-11-03 12:49:29', NULL),
	(74, 8, 5, 'Manufacture Of A Controlled Substance', '1. A person who, except as otherwise provided by law, manufactures, compounds, converts, produces, or prepares, either directly or indirectly by chemical or natural extraction, any illegal substance.', NULL, 1, 50000, 0, 180, 320, '2023-11-03 12:50:04', '2023-11-03 12:50:04', NULL),
	(75, 8, 6, 'Sale Of A Controlled Substance', '1. A person who sells, or offers to sell, a controlled substance to another person, regardless of whether or not they possess that controlled substance.\r\n\r\nNOTES\r\nSince it’s irrelevant of possession, this charge can indeed stack with whatever the present possession of a drug is on someone if they are in fact also in illegal possession of a controlled substance. This means anyone caught selling a controlled substance is also charged with whatever possession they currently have too.', NULL, 1, 20000, 0, 240, 480, '2023-11-03 12:50:58', '2023-11-03 12:51:22', NULL),
	(76, 8, 7, 'Possession Of An Open Container', '1. A person who possesses an visible and open container of alcohol in a public place or in a motor vehicle.', NULL, 7, 1000, 0, 0, 0, '2023-11-03 12:51:50', '2023-11-03 12:51:50', NULL),
	(77, 8, 8, 'Public Intoxication', '1. A person who is found in any public place under the influence of intoxicating liquor,\r\n2. A person in a condition that they are unable to exercise care for their own safety or the safety of others\r\n3. A person who\'s clearly under the influence of alcohol and causes a disturbance or conflict at a private event and refuses to leave or comply with the owner’s wishes.', NULL, 4, 0, 0, 60, 120, '2023-11-03 12:52:24', '2023-11-03 12:52:24', NULL),
	(78, 8, 9, 'Under The Influence Of A Controlled Substance', '1. A person who uses or is under the influence of a controlled substance or dangerous substance without the proper permits or prescription to use such a substance.', NULL, 4, 0, 0, 60, 120, '2023-11-03 12:52:54', '2023-11-03 12:52:54', NULL),
	(79, 8, 10, 'Facial Obstruction While Committing A Crime', '1. A person who wears any mask, hood, or facial obstruction to conceal their identity in any public place that refuses to remove the obstruction upon order of a peace officer. This does not apply to individuals wearing traditional holiday costumes, or individuals wearing protective facial equipment for professional trades or employment.\r\n2. A person who wears any mask, hood, or facial obstruction while committing a crime, regardless of the purpose of the obstruction.', NULL, 4, 0, 0, 60, 120, '2023-11-03 12:53:32', '2023-11-03 12:53:32', NULL),
	(80, 8, 11, 'Terrorism', '1. A person who, uses systematic threats or actions against the public good to cause fear and intimidation at a grand scale.\r\n2. A person who commits an attack or threatens an attack on a major public or private facility, such as a office complex, stadium, public transportation system, bridge, or other such structure.\r\n3. This charge can only be issued at the order of the Governor, Attorney General or Chief Justice.\r\n\r\n**OOC: Must have a Board Members\' approval before RP**', NULL, 1, 0, 0, 800, 1600, '2023-11-03 12:54:47', '2023-11-03 12:54:47', NULL),
	(81, 9, 1, 'Animal Abuse / Cruelty', '1. A person who intentionally maims, mutilates, tortures, wounds, or kills a living animal.\r\n2. A person whose neglect maims, mutilates, tortures, wounds, or kills a living animal.\r\n3. A person who owns a pet or animal that is not reasonably considered domesticated, safe, or healthy for the animal or the owner, without a proper permit.\r\n\r\nNOTES\r\n- If the act of abuse was due to neglect or the result of an accident caused by neglect or ignorance the offender shall receive the minimum sentence.\r\n- If the animal was a police-trained animal during active duty, whether or not intentional, the offender shall receive the maximum sentence.', NULL, 1, 20000, 0, 90, 180, '2023-11-03 12:56:15', '2023-11-03 12:56:15', NULL),
	(82, 9, 2, 'Child Abuse', '1. A person who willfully inflicts any cruel, excessive, or inhuman corporal punishment upon a child under 18 years of age.\r\n2. A person who willfully inflicts an injury to a child under 18 years of age, resulting in traumatic harm.\r\n3. A person who causes traumatic injury to a child under 18 years of age due to their negligence.\r\n\r\nNOTES\r\n- If the act was caused by negligence the individual shall receive the minimum sentence.', NULL, 1, 20000, 0, 90, 180, '2023-11-03 12:57:13', '2023-11-03 12:57:13', NULL),
	(83, 9, 3, 'Sale of Alcohol To A Minor', '1. A person who willfully and knowingly sells alcohol to a minor under the age of 21.', NULL, 4, 1000, 0, 0, 0, '2023-11-03 12:57:43', '2023-11-03 12:57:43', NULL),
	(84, 9, 4, 'Minor Alcohol Violation', '1. A minor under the age of 21 who is in possession of alcohol for consumption, products for consumption containing alcohol, or appears to be under the influence of alcohol.\r\n\r\nNOTES\r\n- Minor must be transported home by an officer.', NULL, 7, 1500, 0, 0, 0, '2023-11-03 12:58:35', '2023-11-03 12:58:35', NULL),
	(85, 10, 0, 'Limitations', '* All Vehicle Offenses under Title 8 have a policy of being charged once for each vehicle a person uses or effects for each road law incident that takes place. Please see Penal Code (11)00 for details on the definition of a road law incident. Please also note that these charges, while considered an extension of the policies and procedures for Title 11. Road Law, do not adhere to the limitations in times or fines under Title 11. Road Law.\r\n* (8)04. Hit and Run can be charged for each vehicle that a driver or pedestrian commits hit and run upon. All other charges in Title 8 are charged for each vehicle the perpetrator commits the violation within. Changing vehicles during a pursuit for example can lead to two charges of (8)02. Evading a Peace Officer, etc.', NULL, 8, 0, 0, 0, 0, '2023-11-03 13:00:50', '2023-11-03 13:00:50', NULL),
	(86, 10, 1, 'Driving With A Suspended License', 'A person who drives a vehicle, whether on land, sea, or in air, while having a suspended license or authorization.', NULL, 4, 1000, 0, 60, 120, '2023-11-03 13:01:47', '2023-11-03 13:01:47', NULL),
	(87, 10, 2, 'Evading A Peace Officer', '1. A person who, while operating a vehicle on land, sea, or in air, or while operating a bicycle, willfully flees or otherwise attempts to elude or avoid a pursuing peace officer who communicates visually or audibly their request to pull over or stop.\r\n2. This charge does not include the attempt to flee and elude by foot, which is (4)12. Resisting a Peace Officer.', NULL, 1, 10000, 0, 90, 180, '2023-11-03 13:02:32', '2023-11-03 13:02:32', NULL),
	(88, 10, 3, 'Flying Without A Pilot\'s License', '1. A person operating an aircraft without a proper license or authorization.', NULL, 4, 1000, 0, 60, 120, '2023-11-03 13:03:05', '2023-11-03 13:03:05', NULL),
	(89, 10, 4, 'Hit And Run', '1. A person who hits another person or occupied vehicle and leaves the scene of the accident.\r\n\r\nNOTES\r\n- This charge can be applied for each instance of hit and run occurring over the course of a road law incident.', NULL, 1, 50000, 0, 120, 240, '2023-11-03 13:05:06', '2023-11-03 13:05:06', NULL),
	(90, 10, 6, 'Reckless Operation Of An Off-Road Or Naval Vehicle', '1. A person who demonstrates careless or general disregard for the safety of themselves or others while operating a naval vehicle or vehicle intended for off-road travel.\r\n\r\nNOTES\r\n- Officer may at their discretion either revoke the user\'s license or permit, or suspend said license or permit.', NULL, 4, 0, 0, 60, 120, '2023-11-03 13:06:12', '2023-11-03 13:06:12', NULL),
	(91, 10, 7, 'Failure To Adhere To ATC Protocols', '1. A person who failures to respond to identification requests from nearby aircraft or Air Traffic Control.\r\n\r\nNOTES\r\n- Individuals who do not respond to ATC traffic may become a target of the San Andreas National Guard and be shot down.', NULL, 1, 10000, 0, 60, 120, '2023-11-03 13:06:58', '2023-11-03 13:06:58', NULL),
	(92, 10, 8, 'Failure To Adhere To Flight Protocols', '1. A person who failures to follow the flight protocols as detailed in State Aviation Act.\r\n\r\n\r\nNOTES\r\n- Individuals who do not respond to ATC traffic may become a target of the San Andreas National Guard and be shot down.', NULL, 1, 10000, 0, 60, 120, '2023-11-03 13:07:41', '2023-11-03 13:07:41', NULL),
	(93, 10, 9, 'Aerial Evasion', '1. A person who, while operating an aircraft, willfully flees or otherwise attempts to elude pursuing law enforcement who is broadcasting their request to land or halt.\r\n\r\n\r\nNOTES\r\n- Individuals who do not respond to ATC traffic or continually evade may become a target of the San Andreas National Guard and be shot down.', NULL, 1, 20000, 0, 120, 240, '2023-11-03 13:08:22', '2023-11-03 13:08:22', NULL),
	(94, 10, 10, 'Restricted Airspace Violation', '1. A person who enters the restricted airspace as detailed in  State Aviation Act and refuses to leave such airspace after being ordered to leave such airspace.\r\n\r\nNOTES\r\n- Individuals who do not respond to ATC traffic or continually evade may become a target of the San Andreas National Guard and be shot down.', NULL, 1, 0, 0, 300, 600, '2023-11-03 13:08:59', '2023-11-03 13:08:59', NULL),
	(95, 11, 1, 'Possession Of An Illegal Blade', '1. A civilian who possesses a blade or improvised blade over three inches in length that can be used as a cutting, slashing or stabbing weapon, whether or not concealed.\r\n2. ((Any wieldable script-wise knife or katana in your inventory is considered long enough to kill someone and qualify as an illegal blade.))', NULL, 4, 5000, 0, 60, 120, '2023-11-03 13:09:59', '2023-11-03 13:09:59', NULL),
	(96, 11, 2, 'Possession Of An Unlicensed Firearm', '1. A civilian who carries a legal, but unlicensed weapon on their person, in their vehicle, place of business, or other facility without proper permits.\r\n2. A person who knowingly and willingly allows another person to carry a weapon on their person, in their vehicle, place of business, or other facility without proper permits.\r\n\r\n\r\nNOTES\r\n- Unlicensed weapons include the /NAME OF THE WEAPONS WIP/ or any other weapons that someone can obtain a license to use, but owns in this specific instance as unlicensed weapons. Illegal firearms are in contrast weapons that are never legal to own, such as UZIs. Assault weapons are AK-47s, etc.\r\n- If the individual has a felony on record, they shall receive the maximum sentence.', NULL, 4, 1000, 0, 60, 120, '2023-11-03 13:11:16', '2023-11-03 13:11:16', NULL),
	(97, 11, 3, 'Possession Of An Illegal Firearm', '1. A civilian who possesses any firearm that is illegal in possession or not considered part of any legal weapon type.\r\n2. A person who possesses a firearm that contains illegal modifications in its design including, but not limited to, fully automatic firearms, magazine extensions, and silencers.', NULL, 1, 10000, 0, 120, 240, '2023-11-03 13:19:42', '2023-11-03 13:19:42', NULL),
	(98, 11, 4, 'Possession Of An Assault Weapon', '1. A civilian who possesses an illegal firearm which uses high-velocity, high-caliber, or specialized ammunition including, but not limited to, FMJ ammunition or HEIAP bullets.', NULL, 1, 0, 0, 120, 240, '2023-11-03 13:26:26', '2023-11-03 13:26:26', NULL),
	(99, 11, 5, 'Unlicensed Sale Of A Firearm', '1. A civilian who possesses any manufactured or improvised device or equipment which is made from explosive and/or highly flammable liquid, gas or solid materials.', NULL, 1, 0, 0, 360, 720, '2023-11-03 21:52:02', '2023-11-03 21:52:02', NULL),
	(100, 11, 7, 'Manufacture or Possession of an Improvised Device.', '1. Except as otherwise provided by law, A civilian who manufactures, assembles, disassembles, or possesses parts of any dangerous weapon, explosive, trap, firearm, or other destructive device that does not apply or is appropriate to any other penal code entries.\r\n2. This code entry cannot stack with any other Title 9. Control of Deadly Weapons And Equipment charges unless this charges are for a separate item.\r\n\r\nNOTES\r\n- This applies to the possession of disassembled, or packaged firearms. For example, if someone has 10 packaged M4\'s, they are charged with 10 counts of (9)07. Manufacture or Possession of an Improvised Device, not (9)04. Possession Of An Assault Weapon.', NULL, 1, 0, 0, 120, 240, '2023-11-03 21:52:40', '2023-11-03 21:52:40', NULL),
	(101, 11, 8, 'Possession of Weaponry With Intent To Sell', '1. A person who is in possession of more than 5 full weapons or weapon components in any combination or amount with the intent to distribute, deliver, or sell.', NULL, 1, 0, 0, 120, 240, '2023-11-03 21:53:12', '2023-11-03 21:53:12', NULL),
	(102, 11, 9, 'Possession Of Explosive Devices With Intent To Sell', '1. A person who is in possession of more than 3 explosive devices or explosive device materials in any combination with the intent to distribute, deliver, or sell.', NULL, 1, 0, 0, 120, 240, '2023-11-03 21:53:34', '2023-11-03 21:53:34', NULL),
	(103, 11, 10, 'Brandishing A Firearm', '1. A person who is pointing, holding, openly carrying or brandishing a firearm, air or gas operated weapon, or object that appears like a firearm without proper toy and prop identification in an attempt to elicit fear or hysteria.\r\n2. A person holding an object in a manner similar to a firearm who attempts to elicit the same fear or response as brandishing an actual firearm.\r\n\r\nNOTES\r\n- Brandishing explicitly notes that the purpose is to elicit fear or hysteria. A Weapons Discharge violation is irrelevant of the intent to elicit hysteria so the two charges can be stacked if appropriate.', NULL, 4, 1000, 0, 60, 120, '2023-11-03 21:54:19', '2023-11-03 21:54:19', NULL),
	(104, 11, 11, 'Weapons Discharge Violation', '1. A person who fires a firearm without due cause or justifiable motive regardless of registration status or legality.\r\n2. A person committing this offense from a vehicle, whether land, sea, or in air, shall instead be charged with (9)12. Drive-By Shooting.\r\n\r\n\r\nNOTES\r\n- This charge can stack with brandishing a firearm, so you can in fact be charged both. A discharge however is different from brandishing, which requires the perpetrator to be using the brandishing as a way to elicit fear or hysteria.', NULL, 4, 0, 0, 90, 180, '2023-11-03 21:55:05', '2023-11-03 21:55:05', NULL),
	(105, 11, 12, 'Drive-By Shooting', '1. A person who drives a vehicle, whether on land, sea, or in air, and has a passenger who they knowingly and willingly let discharge a firearm from within the vehicle, and the passenger is not an on-duty peace officer.\r\n2. A person who exits a vehicle only to immediately discharge a firearm afterward.\r\n3. A person who discharges a weapon in a vehicle, whether on land, sea, or in air, and is not an on-duty peace officer with proper authorization.', NULL, 1, 10000, 0, 90, 180, '2023-11-03 21:55:42', '2023-11-03 21:55:42', NULL),
	(106, 11, 13, 'CCW / PF Violation', '1. A person who carries concealed a legal, registered firearm that is not authorized as a conceal-carry weapon.\r\n2. A person who carries concealed a legal, registered firearm that they are not authorized to carry concealed.\r\n3. A person who does not carry proper permits or documentation for their weapon or occupational weapon usage.\r\n4. Any other firearms regulatory violations as set by the appropriate licensing agency.\r\n\r\nNOTES\r\n- The LSPD has the authority to regulate all firearms policy. Any violations of their policies apply to (9)13. This includes violations pertaining special weapons usage, such as for a prop as part of a production or as a security guard, etc. See (10)08 for more details.', NULL, 4, 0, 0, 60, 120, '2023-11-03 21:56:17', '2023-11-03 21:56:17', NULL),
	(107, 12, 0, 'Exception', 'Penal code entries, by default, may be modified by Sentencing Enhancements within Title 10. However, should a penal code entry be the exception to a Sentencing Enhancement or contain an exception within its description, then that exception shall be followed instead of the Sentencing Enhancement policy.\r\n\r\nFor example, (1)08. Murder cannot be charged for an attempt as an entire charge, (1)06. Attempted Murder, exists for that purpose.\r\n\r\nPenalties are, as stated, stackable for each occurrence. Committing assault against someone multiple times is worthy of a charge for each time, as long as they are separate police incidents, occur at different time, occur to different people, or are charged for each prohibited object that is possessed. Charges can also be stacked for each person they are committed against. Unless an exception exists explicitly.\r\n\r\nEach stacked charge equals the additional punishment time for that charge. A person who commits two counts of assault will be charged twice the amount of time, so long as it does not violate maximum imprisonment policies.', NULL, 8, 0, 0, 0, 0, '2023-11-03 21:56:57', '2023-11-03 21:57:22', NULL),
	(108, 12, 1, 'Attempt', 'A person who attempts to commit any crime, but fails or is prevented or intercepted in its perpetration, shall be given the same punishment as if the offense was committed.', NULL, 8, 0, 0, 0, 0, '2023-11-03 21:57:48', '2023-11-03 21:57:48', NULL),
	(109, 12, 2, 'Conspiracy', 'If two or more persons conspire to commit any crime, to falsely and maliciously to indict another for any crime, or to procure another to be charged or arrested for any crime, they shall be punished by the same punishment as if the offense was committed.', NULL, 8, 0, 0, 0, 0, '2023-11-03 21:58:08', '2023-11-03 21:58:08', NULL),
	(110, 12, 3, 'Soliciting', 'A person who solicits for the commission or perpetration of any crime shall be punished by the same punishment as if the offense was committed.', NULL, 8, 0, 0, 0, 0, '2023-11-03 21:58:27', '2023-11-03 21:58:27', NULL),
	(111, 12, 4, 'Government Worker Clause', 'Any crime knowingly committed against a government worker or state agency employee, as defined by the State Constitution, shall punish the perpetrator with the maximum possible sentence allowed by that particular code entry, unless a judge orders a reduced sentence. This charge does not apply to property or possessions of a government agency.', NULL, 8, 0, 0, 0, 0, '2023-11-03 21:58:52', '2023-11-03 21:58:52', NULL),
	(112, 12, 5, 'Plea Bargaining / Police Compliance Clause', 'If a person, at the request of the District Attorney’s Office, or by other legal authorities within the State of San Andreas, complies to assistance in other activities sufficient to assist with the apprehension or prevention of criminals or crime in San Andreas, then that individual is permitted to receive bargains or other commutes to sentences and punishments issued.\r\n\r\nThe specific amount of a sentence commute are subject to the circumstances of each situation of Plea Bargain or Police Compliance, at the discretion of the judge reviewing the case.', NULL, 8, 0, 0, 0, 0, '2023-11-03 21:59:09', '2023-11-03 21:59:09', NULL),
	(113, 12, 6, 'Three-strikes Vehicle Policy', 'A person who drives a vehicle and receives three driver warnings shall have their vehicle impounded and their license revoked for twelve (12) weeks.\r\n\r\nAn individual who violates a penal code entry that states a specific punishment, such as a license revocation, shall have their vehicle impounded and licensed revoked for eight hours.\r\n\r\nAll warnings on record are removed upon revocation and the three-strikes vehicle policy resets.', NULL, 8, 0, 0, 0, 0, '2023-11-03 21:59:34', '2023-11-03 21:59:34', NULL),
	(114, 12, 7, 'Weapons Violation', 'A person who commits a felony while in possession of a firearm shall have their firearms permit revoked.\r\n\r\nA person who demonstrates illegal or irresponsible usage of their firearm shall be suspect to firearms permit suspension or revocation depending on the penal code entry of the firearms violation. If no description exists, it shall be up to officer discretion.\r\n\r\nIf a person receives two suspensions of their firearms permit they shall have their permit revoked immediately upon the second incident.\r\n\r\nThese violation policies also apply, where appropriate, to licenses and permits issued to facilities and organizations.\r\n\r\nThese policies also apply to any current and future firearms permits created for purposes determined by the agency responsible for firearms regulation.', NULL, 8, 0, 0, 0, 0, '2023-11-03 22:00:01', '2023-11-03 22:00:01', NULL),
	(115, 12, 8, 'Criminal Accomplice Clause', 'A person who acts as an accomplice, aid, adviser, or other supportive role to another person\'s attempted or successful criminal acts shall receive HALF the punishment allotted to the person who attempted or successful criminal acts.', NULL, 8, 0, 0, 0, 0, '2023-11-03 22:00:19', '2023-11-03 22:00:19', NULL),
	(116, 12, 9, 'Accessory After the Fact', 'A person who knowingly and willingly helps another person who had successfully committed a criminal act shall receive HALF the punishment issued to the person who committed the criminal act.\r\n\r\nExamples include harboring a fugitive, helping destroy or distort evidence, withholding information relating to a crime or assisting the person elude or avoid police custody.', NULL, 8, 0, 0, 0, 0, '2023-11-03 22:00:39', '2023-11-03 22:00:39', NULL),
	(117, 14, 1, 'Mistake of Fact', '1. A person who commits an offense but claims, and can display proof, that they acted on the honestly held belief they were not violating the law or did not understand the law that was violated.\r\n2. This can only negate an offense if the offense requires mens rea, meaning a willful intention, knowing, or understanding that they are committing a crime.\r\n3. In any other cases, it may reduce the punishment for an offense at the discretion of the peace officer, or a judge when in a criminal suit.', NULL, 8, 0, 0, 0, 0, '2023-11-03 22:01:15', '2023-11-03 22:01:15', NULL),
	(118, 14, 2, 'Involuntary Intoxication', 'A person found to be involuntarily intoxicated, meaning they were evidently drugged or had their awareness impaired against their will or knowledge, cannot be found guilty of an offense as they did not have the adequate state of mind to do so.', NULL, 8, 0, 0, 0, 0, '2023-11-03 22:01:30', '2023-11-03 22:01:30', NULL),
	(119, 14, 3, 'Private Defense, Self Defense, Castle Doctrine, And Defense Of Others)', 'A person who has a reasonable belief that they, or another, are in imminent danger of being killed, seriously injured or unlawfully touched and believe that imminent force is needed to prevent that danger and use no more force than is necessary to negate that danger will absolved of criminal liability in Title 1. Crimes Against the Person. ALL these requirements must be met to be completely absolved of criminal liability.\r\n\r\nIf not all requirements are met, charges may instead be reduced to up to half the minimum sentence for relevant offenses at the discretion of the peace officer or a judge.\r\n\r\nThis also applies in the case of a person who is protecting their home from imminent danger or robbery when on private property.\r\n\r\nThis defense cannot be applied in cases of gang on gang violence or in other such instances where the party claiming the defense was put at risk of immediate danger by their own involvement with actionable criminality.', NULL, 8, 0, 0, 0, 0, '2023-11-03 22:01:58', '2023-11-03 22:01:58', NULL),
	(120, 14, 4, 'Necessity', 'A person who commits an offense out of necessity to protect themselves or others from significant bodily harm or emergency, has no adequate legal alternative, did not create a greater danger through their actions and held an actual and reasonable belief that their action was necessary to prevent harm, will be absolved of criminal liability for the offense deemed to be committed as a necessity to prevent greater harm.\r\n\r\nThis defense cannot be applied in cases of gang on gang violence or in other such instances where the party claiming the defense was put at risk of immediate danger by their own involvement with actionable criminality.', NULL, 8, 0, 0, 0, 0, '2023-11-03 22:02:16', '2023-11-03 22:02:16', NULL),
	(121, 14, 5, 'Entrapment', 'A person who would not have committed an offense if not for for the harassment, threats, or coercion to do so by members of law enforcement cannot be found guilty of the offense that they were persuaded to commit.', NULL, 8, 0, 0, 0, 0, '2023-11-03 22:02:38', '2023-11-03 22:02:38', NULL),
	(122, 14, 6, 'Duress', 'A person who commits any offense in response to immediate threats to kill from a third party and does so in order to negate those threats cannot be found to have had the required criminal intent with which to be held liable for an offense.\r\n\r\nThe only exception to this are severe crimes against the person, such as torture, murder, and attempted murder, as it is not justifiable to take or severely harm another life unless in an act of self defense.', NULL, 8, 0, 0, 0, 0, '2023-11-03 22:03:00', '2023-11-03 22:03:00', NULL),
	(123, 14, 7, 'Parole Exclusions', 'A person who is guilty of (1)10. Torture, (1)07. Kidnapping, (1)03. Attempted Murder with the Government Worker Clause, (1)08. Murder, (1)06. Manslaughter and (4)20. Violation of Parole Or Probation shall be always excluded from any opportunity of parole.', NULL, 8, 0, 0, 0, 0, '2023-11-03 22:03:24', '2023-11-03 22:03:24', NULL),
	(124, 14, 8, 'Suspicion Policy', 'A peace officer\'s or court\'s justifiable suspicion of a person to commit or conspire to commit a crime is sufficient to allow that individual to be detained for questioning for no more than 30 minutes in police or court custody, however they cannot be searched beyond a legal \r\n\r\nTerry Frisk for the officer’s safety unless probable cause or concurrent evidence emerges.\r\n\r\nA person who is at the scene of a crime, riot, or major public disturbance may also be classified under the suspicion policy for temporary detainment.\r\n\r\nViolation of this policy, or an act of justifiable suspicion that extends beyond legal bounds, extends beyond Color of Law and is satisfactory for suit.\r\n\r\nA person who fails to identify themselves to a peace officer during arrest or arraignment shall be imprisoned for the maximum time allowed by the law until they can be successfully identified by a peace officer or the courts.', NULL, 8, 0, 0, 0, 0, '2023-11-03 22:03:53', '2023-11-03 22:03:53', NULL),
	(125, 14, 9, 'Officer Discretion', 'Law enforcement officers shall have the authority to use their discretion when issuing infractions or select misdemeanors. This discretion entitles the officer to choose to forego an infraction or misdemeanor penalty based on their personal judgment.\r\n\r\nOfficers must choose to issue Officer Discretion and forego charging, not issue a fine or other punishment in lieu of the typical punishment.\r\n\r\nOfficers cannot elect Officer Discretion if the independent victim, property owner, or affected party chooses to press charges on the perpetrator.\r\n\r\nDouble Jeopardy still applies, meaning a senior officer cannot revoke Officer Discretion once it is issued unless it was issued in disregard for a party wishing to press charges.\r\n\r\nAll misdemeanors that fall under Officer Discretion shall state as such in the sentencing portion of the charge.', NULL, 8, 0, 0, 0, 0, '2023-11-03 22:04:43', '2023-11-03 22:04:43', NULL),
	(126, 14, 10, 'Good Samaritan Clause', 'Citizens may perform a legal Citizen’s Arrest when an individual has committed a misdemeanor or greater offense and the citizen wishes to restrain the individual until proper authorities can arrive to support, assist, or assess the situation.\r\n\r\nCitizens may, at the request of the government worker, may give their assistance with carrying out official government business, so long as it doesn’t extend beyond the powers, duties, responsibilities, and authorities of that government worker.\r\n\r\nCitizens may come to the aid of a government worker who is in duress or incapacitated during official government business to save or protect their life or assist informing official agents.', NULL, 8, 0, 0, 0, 0, '2023-11-03 22:05:06', '2023-11-03 22:05:06', NULL),
	(127, 14, 11, 'Imprisonment & Punishment Criteria', 'Only criminal violations that originate from the San Andreas Penal Code may carry a misdemeanor or felony-level punishment with imprisonment in a county or state penitentiary.\r\n\r\nAll felonies must carry with their punishment imprisonment at the San Andreas State Correctional Facility.\r\n\r\nAll persons convicted of felony will carry their sentence at the San Andreas State Correctional Facility. All persons convicted of misdemeanor will carry their sentence at the appropriate county facility. All persons convicted will be imprisoned at the location of Officer Discretion.\r\n\r\nEach penal code entry may include a range of time for imprisonment. While some entries dictate instances where the maximum or minimum time of imprisonment must be used, in all other instances the peace officer issuing the arrest may use their discretion, based on severity, cooperativeness of the suspect, or other criteria to decide the time within\r\n\r\nThe LSPD may set internal policies to dictate how officers should follow Imprisonment & Punishment Criteria, so long as it does not violate the minimum and maximum punishment policies stated in this Penal Code.\r\n\r\nEach bullet number in a penal code entry refers to an applicable charge for each entry. Violating any one of the descriptions is a violation of the penal code entry.\r\n\r\nSo long as no exceptions are stated in the penal code entry, charges can be stacked for additional imprisonment. See (10)00. Exception for details.\r\n\r\n((Persons who roleplay without a sound mind will still, in any case, be arrested and charged for the crime they commit. Technically they’d be delivered to an appropriate institution in-character but are dropped off to the local county or state jail before being sent there. They may and would not be placed with the regular prison population.))\r\n\r\nNOTES\r\n\r\n- For example, Murder carries a maximum punishment when it is committed against a government employee. PD  cannot tell officers to ignore that maximum punishment policy, but can tell its officers to mandate a minimum sentence otherwise, etc. Anything within the minimum and maximum time ranges stated are fair game otherwise.\r\n\r\n* \\> 45 minutes = SACF\r\n* < 30 minutes = County Jail\r\n* 30-45 minutes = Officer Discretion\r\n\r\nThere may be medical services, mental health centers, etc. but either way there’s no way to get out of your imprisonment because of your character type, even if it seems unethical to meet this expectation of the game experience.', NULL, 8, 0, 0, 0, 0, '2023-11-03 22:06:44', '2023-11-03 22:06:44', NULL),
	(128, 14, 12, 'Maximum Imprisonment', 'A person cannot be imprisoned for longer than 60 minutes despite the number of charges on this individual exceeding a 60 minute penalty, unless said sentence is approved by a Justice of the Courts of San Andreas, or by the Governor of San Andreas.\r\n\r\nA person who cannot be effectively identified shall be imprisoned for 60 minutes until they can be properly identified or they fulfill the 60 minute imprisonment. If they are identified, the total time served will be deducted from the time due, with immediate release if they fulfilled more than the total time. A person released with more time spent in prison than their charges yield is not subject to excessive or wrongful imprisonment\r\n\r\nAt the Governor’s discretion, an individual who commits a felony may qualify for death row status, yielding permanent imprisonment until their execution can be carried out by the Warden of SACF, unless the Governor issues a pardon.', NULL, 8, 0, 0, 0, 0, '2023-11-03 22:07:17', '2023-11-03 22:07:17', NULL),
	(129, 14, 13, 'Wiretapping, CCTV & Videotaping Policy', 'The State of San Andreas shall have a one-party notification policy for wiretapping without appropriate surveillance warrants and authorizations.\r\n\r\nA person who is found to violate these wiretapping laws can be charged with (13)10. Wiretapping Violation\r\n\r\nMoles, bugs, and other illegal surveillance falls under wiretapping laws and violations / policies.\r\n\r\nGovernment Employees may be recorded by civilians at all times when conducting their duties in an official capacity or when on-duty.\r\n\r\n((CCTV is considered reasonably accessible to the courts when sourced from inside and around all public facilities, from police dashcams, or when subpoenaed by a private business that claims to have CCTV cameras installed. Public CCTVs cannot be tampered, modified, stolen, or destroyed.))\r\n\r\n((CCTVs in businesses must be explicitly recorded as existing on paperwork or a license to be used in court or accepted legally.))\r\n\r\nNOTES\r\n - So long as one party (either person on the phone, in a facility, or other location where a conversation or event is being recorded) is aware of the situation it is considered a legal recording. Property owners always have full surveillance rights to their property and facilities, parking lots, etc. they maintain.', NULL, 8, 0, 0, 0, 0, '2023-11-03 22:08:08', '2023-11-03 22:08:08', NULL),
	(130, 14, 14, 'Police Exigency & Hot Pursuit Policy', 'Peace officers have the authority to follow suspects into private property if directly related to an ongoing pursuit. Entry related to investigations or other projects not in a direct pursuit of a suspect require a warrant.\r\n\r\nPeace officers have the authority to enter the public area of a private facility, such as the public area of a club or restaurant, at all times the facility is open to the public. Private areas of the facility require permission of the facility manager or a warrant.\r\n12.15 Probable Cause & Plain View still applies when an officer is entering a facility for hot pursuit or entering the public area of a private facility.\r\n\r\nNOTES\r\n- This includes multiple rooms where a suspect could reasonably have ran to, such as several apartments within an apartment complex.', NULL, 8, 0, 0, 0, 0, '2023-11-03 22:08:32', '2023-11-03 22:08:32', NULL),
	(131, 14, 15, 'Probable Cause & Plain View Policy', 'Peace officers have the power to seize and record evidence upon any event that is in their plain view so long as they have a legal reason to be where they’re located at the time.\r\n\r\nA person who gives a government employee permission to view or access a facility, equipment or other areas is permitting an officer to view a facility for probable cause or plain view evidence.\r\n\r\nProbable Cause does not have a specific definition, but refers to the ongoing premise that an officer’s “gut feeling” supported by plain view evidence (such as the smell of marijuana or other items) that would imply a probable situation of criminality and authorize a search based on that evidence. Probable Cause can be circumstantially contested in a court of law.\r\n\r\nNOTES\r\n- Plain View applies even when an officer is in hot pursuit and enters, for example, an apartment complex and sees a clear criminal act in progress while chasing someone. They can call in other units to seize and handle that situation too.', NULL, 8, 0, 0, 0, 0, '2023-11-03 22:08:56', '2023-11-03 22:08:56', NULL),
	(132, 15, 1, 'Racketeering', '1. The affiliation or association of an individual with a criminal organization, as prescribed by local or national law enforcement entities, with the evidence of the individual\'s attempt to commit extortion, bribery, murder, or other criminal activities while affiliated with said criminal organization.', NULL, 1, 0, 0, 0, 0, '2023-11-03 22:09:32', '2023-11-03 22:09:32', NULL),
	(133, 15, 2, 'Tax Evasion', 'A person, officer, or employee of an organization that fails to pay any appropriate fees or taxes liened against themselves or an agency they are an executive to.\r\n\r\nA person who intentionally avoids or attempts to avoid tax or fee payments to the state.\r\n\r\nThis does not apply for fees that would fall under (4)02. Failure To Pay A Fine.\r\n\r\nThis charge may only be authorized by the Attorney General or a warrant by the Chief Justice.', NULL, 1, 0, 0, 0, 0, '2023-11-03 22:09:58', '2023-11-03 22:09:58', NULL),
	(134, 15, 3, 'Laundering Of Money Instruments', '1. A person who possesses, hides, transfers, receives, or maintains the storage of funds earned through comprehensive criminal activities.\r\n2. A person who intends to transfer, hide, cycle, or deceive funds collected through comprehensive criminal activities.\r\n3. A person who maintains an establishment with a purpose to launder funds collected through comprehensive criminal activities.\r\n4. This charge can only be issued by the Attorney General or a warrant by the Chief Justice.\r\n- Violators are also subject to a fine equal to thirty percent of the money laundered.', NULL, 1, 0, 0, 0, 0, '2023-11-03 22:10:35', '2023-11-03 22:10:35', NULL),
	(135, 15, 4, 'Gambling License Violation', '1. A person who violates the terms of their gambling or gaming license.\r\n2. A person who falsely claims to operate a business with a gambling or gaming license.\r\n3. A person who intentionally operates rigged or unfair games of chance.\r\n4. A person who grossly violates the policies set by the Licensing Code of San Andreas for gaming and games of chance.\r\n5. A person who operates any game of chance without proper permits, licenses, or authorizations.', NULL, 1, 0, 0, 0, 0, '2023-11-03 22:10:57', '2023-11-03 22:10:57', NULL),
	(136, 15, 5, 'Medical Practice Violation', '1. A person who identifies themselves as possessing a license to practice advanced medicine, whether verbally, or through implied means, and who has not received proper training to do so from the Los Santos Fire Department.\r\n2. A person who performs or provides any medical services with criminal negligence, by criminal accident, or with the intent to cause harm to an individual.\r\n3. A person who performs or provides any medical services not licensed or permitted by the Los Santos Fire Department after being explicitly notified by the Los Santos Fire Department to discontinue services in the State of San Andreas.\r\n4. This charge cannot stack with (1).06 Attempted Murder.\r\n\r\nNOTES\r\n* This charge covers any harm that happens as a result of criminal negligence or an intent to cause harm, but Murder stacks with this charge if the person dies as a result of the negligence or intentional harm.\r\n* This does not cover doctors who are forced to act out of threat, by order of a government authority, or in other cases that would put them in harm’s way if they do not act.', NULL, 1, 0, 0, 0, 0, '2023-11-03 22:11:31', '2023-11-03 22:11:31', NULL),
	(137, 15, 6, 'Legal Practice Violation', 'A person who advertises or portrays themselves as practicing or as being entitled to practice law without being an active member of the San Andreas State Bar.', NULL, 4, 0, 0, 0, 0, '2023-11-03 22:11:53', '2023-11-03 22:11:53', NULL),
	(138, 15, 7, 'Construction And Maintenance Code Violation', '1. A person who enters a clearly designated construction or facility maintenance site without the authority or purpose to be there.\r\n2. A person who enters a clearly designated road works site without the authority or purpose to be there.', NULL, 4, 0, 0, 0, 0, '2023-11-03 22:12:14', '2023-11-03 22:12:14', NULL),
	(139, 15, 8, 'Criminal Fire Code Violation', '1. A facility manager or property owner who, through willful ignorance, criminal negligence, or intentional ignorance of a fire marshal violates a provision of the Fire Code and fails to amend that violation in a timely manner.\r\n2. A person who disrupts, removes, defaces, or affects any official postings or notices issued by a fire marshal.', NULL, 4, 0, 0, 0, 0, '2023-11-03 22:12:41', '2023-11-03 22:12:41', NULL),
	(140, 15, 9, 'Failure to Comply with Fire Code Orders', 'A person who fails to comply with a fire marshal’s orders to bring a facility up to the standards of the Fire Code.\r\n- $100 for each day in violation at the fire marshal’s discretion.', NULL, 7, 100, 0, 0, 0, '2023-11-03 22:13:08', '2023-11-03 22:13:08', NULL),
	(141, 15, 10, 'Wiretapping Violation', '1. A person who illegally conducts surveillance or wiretapping in violation of the one-party notification system without a warrant or authorization.\r\n\r\nNOTES\r\n- Cops can charge this but usually a judge is the one who notes or acknowledges what is an illegal wiretapping operation. One-party notification means that at least one party being recorded visually or audibly is aware of that they are being recorded and consents to it.', NULL, 1, 0, 0, 0, 0, '2023-11-03 22:13:54', '2023-11-03 22:13:54', NULL),
	(142, 15, 11, 'Criminal Business Operations', '1. Any person who willfully fails to pay a fine issued and notified by the Bureau of Licensing within seven days without a lawful excuse, even if the fine is paid in full after that time is guilty of a misdemeanor. Those convicted under this section shall be punished by imprisonment and the appropriation of all due fines.\r\n2. This charge is issued in lieu of (4)02. Failure To Pay A Fine when the fine is related to the Bureau of Licensing and exceeds the seven day payment period.', NULL, 4, 0, 0, 0, 0, '2023-11-03 22:14:17', '2023-11-03 22:14:17', NULL),
	(143, 15, 12, 'Corporate Hijacking', '1. A person or group who unlawfully and willfully uses a business premises for trade, corporate or financial gain without license, lease or consent from it\'s registered owner.', NULL, 4, 0, 0, 0, 0, '2023-11-03 22:14:36', '2023-11-03 22:14:36', NULL),
	(144, 13, 0, 'Limitations', 'No individual may be fined more than $10,000 in the course of a single road law incident in charges from Title 11. Road Law\r\n\r\nNo individual may receive more than three driver warnings, amounting to a single license revocation, per road law incident.\r\n\r\nNo more than one of each code entry in Title 11. Road Law may be issued on a driver per road law incident.\r\n\r\nA road law incident is defined as the moment an officer engages a person until the conclusion of that engagement or situation.\r\n\r\nA peace officer is entitled to an exterior inspection of a vehicle, as well as verification of all paperwork, licenses, registrations, and other documentation during a traffic stop. A full vehicle inspection is permitted with a search warrant or appropriate probable cause.\r\n\r\nCheckpoints, border controls, and other police operations on public roads must have a documented purpose, documented record of operations, and exist temporarily in response to (or in preparation to) a particular incident, holiday, etc.\r\n\r\nA peace officer is only entitled to identify the driver of a vehicle when performing a traffic stop or other vehicle checkpoint operation, unless the passenger falls under a reasonable suspicion to be identified, such as matching an APB description.\r\n\r\nEXAMPLE\r\n\r\nIf an officer requests a driver to pull over, and the incident evolves into a pursuit, it is considered part of the same "road law incident" as it is a single, uninterrupted engagement. If the individual escapes or the pursuit is canceled, it is considered a conclusion to a single "road law incident." This means, for example, if a pursuit ends, and the suspect is discovered again, new charges may be issued if they continue to evade police.', NULL, 8, 0, 0, 0, 0, '2023-11-03 22:15:44', '2023-11-03 22:15:44', NULL),
	(145, 13, 1, 'Speeding Violation', '1. A driver who exceeds a speed of 150 KMH or 94 MPH on any state, county, or locally maintained road with four or more lanes.\r\n2. A driver who exceeds a speed of 130 KMH or 81 MPH on any public outsides of the city of Los Santos\r\n3. A driver who exceeds a speed of 110 KMH or 68 MPH on any public roads inside the city of Los Santos.\r\n4. A driver who fails to show a use of fair judgment in their speed when driving in poor conditions, such as poor weather, or on unpaved, slick, or damaged roads.', NULL, 7, 2000, 0, 0, 0, '2023-11-03 22:16:15', '2023-11-03 22:16:15', NULL),
	(146, 13, 2, 'Failure To Abide To A Traffic Control Device', 'A driver who fails to follow the instructions of a traffic control device, including:\r\n\r\n1. Fails to come to a reasonable stop at “Stop Points”, noted as white or yellow lines at the edge of every intersection or with appropriate signage. A reasonable stop can be either a driver slowing down to check for traffic or coming to a complete stop before proceeding. Drivers should come to a full stop on busy roads and avenues where it is dangerous to not come to a complete stop.\r\n2. Crossing a double yellow line when not enter or leaving a parking lot or private driveway. This only applies with roads that are not already divided into different lanes by a physical barrier or divider (such as highways and boulevards).\r\n3. Ignoring clearly visible signage, whether permanent or temporary, used to direct or control traffic in any way.\r\n4. Ignoring the instruction or direction of a peace officer or construction worker at a road works site.\r\n5. A driver who fails to appropriately drive on the right properly with the flow of traffic, except in cases of emergency routes or private paths.\r\n\r\n- Warning on the driver’s license at the peace officer’s discretion.', NULL, 7, 2500, 0, 0, 0, '2023-11-03 22:16:59', '2023-11-03 22:16:59', NULL),
	(147, 13, 3, 'Yield Violation', '1. A person driving a vehicle that fails to yield, giving right of way, at an intersection that has other vehicles passing or waiting to turn.\r\n2. A person driving a vehicle that fails to yield, giving right of way, at any time to pedestrians or cyclist traffic.\r\n3. A person driving a vehicle that is standing, meaning not in motion and the driver is in the vehicle, on a public road or parking lot and refuses to keep moving upon order of a peace officer.\r\n4. Ignoring the emergency lights and sirens of an emergency vehicle requiring clearance.', NULL, 7, 2500, 0, 0, 0, '2023-11-03 22:17:23', '2023-11-03 22:17:23', NULL),
	(148, 13, 4, 'Parking Violation', 'A vehicle parked, with its driver outside the vehicle, in the following ways:\r\n1. In a manner that obstructs a lane of traffic and prevents the flow of traffic.\r\n2. In a manner that completely obstructs an alleyway.\r\n3. In a manner that obstructs a parking lot entrance.\r\n4. Within a marked crosswalk.\r\n5. In a manner that obstructs more than two thirds of a sidewalk or pedestrian path.\r\n6. Facing opposing traffic.\r\n7. Not on any bridges or tunnels.\r\n8. Not on any medians.\r\n9. On any highway or freeway.\r\n10. On railroad tracks or within range of being struck by a railroad car.\r\n11. In the immediate ambulatory parking or bay area of a hospital or clinic.\r\n12. In the immediate vicinity of Rodeo Bank\'s entrance, including the sidewalk adjacent to the metal barriers.\r\n13. In front of or obstructing a private driveway or an entrance or exit to a private road or path.\r\n\r\nA vehicle parked in a manner not permitted by the property owner. Private property may set its own parking rules, so long as they do not obstruct any public roads or sidewalks. Policies may also be set by a property manager authorized by the property owner. State agencies, such as the LSPD and others, may set parking rules for the facilities they maintain.\r\n\r\nA person who sitting in a vehicle, with the engine on or off, in any above location and refuses to move at the request of a peace officer or, if private property, by the property manager.\r\n\r\n- Impoundment at the discretion of the peace officer.', NULL, 7, 2500, 0, 0, 0, '2023-11-03 22:19:14', '2023-11-03 22:19:14', NULL),
	(149, 13, 5, 'Reckless Driving', 'A person who demonstrates careless or general disregard for the safety of themselves or others while operating a vehicle, such as (but not limited to):\r\n1. Driving on a unpopulated sidewalk, pedestrian passageway, or plaza\r\n2. Meandering between lanes of traffic erratically.\r\n3. Demonstrating poor control of the vehicle or driving decisions.\r\n\r\n- Warning on the driver’s license at the peace officer’s discretion\r\n- This cannot stack with (11)06. Vehicular Endangerment.', NULL, 7, 3000, 0, 0, 0, '2023-11-03 22:20:31', '2023-11-03 22:20:31', NULL),
	(150, 13, 6, 'Vehicular Endangerment', '1. A person who demonstrates extreme carelessness while operating a vehicle, such as by nearly striking pedestrians, entering pedestrian passageways or nearly causing the severe harm of other motorists.\r\n2. A person who uses their vehicle in any manner that is dangerous to passengers, pedestrians, or nearby residents.\r\n3. A person who drives upon railroad tracks, busy pedestrian passageways or plazas, or on the opposite lane of travel with vehicles.\r\n4. Any activity that would be considered (11)05. Reckless Driving, but takes place within close proximity to nearby civilians, or in dense traffic.\r\n5. This cannot stack with (11)05. Reckless Driving.\r\n\r\n- Possible impoundment of the individual\'s vehicle by officer discretion \r\n\r\nNOTES\r\n* Vehicular Endangerment cannot stack with reckless driving and is considered a more severe form of reckless driving. It serves as a catch-all for when an officer determines someone’s driving or usage of a vehicle to be beyond safe, reasonable activities.\r\n* Also take note that this charge does stack with hit and run. Someone who commits hit and run (hitting any vehicle or person and driving away) can be charged for each occurrence during the course of a road law incident.\r\n* Per Limitations a driver can only receive either reckless driving or vehicular endangerment ONCE per road law incident.', NULL, 4, 5000, 0, 60, 120, '2023-11-03 22:22:06', '2023-11-03 22:22:06', NULL),
	(151, 13, 7, 'Vehicular Noise Violation', 'A driver whose vehicle emits excessive noise, creating a public nuisance. Examples include modifications to increase the noise pollution of their vehicle, or the excessive use of a vehicle horn or siren without justifiable purpose.', NULL, 7, 1000, 0, 0, 0, '2023-11-03 22:22:29', '2023-11-03 22:22:29', NULL),
	(152, 13, 8, 'Illegal Nitrous Oxide Possession', 'A person who drives a vehicle that contains, possesses, or shows characteristics of nitrous oxide equipment use while not on a official speedway or race track.\r\n\r\n- Vehicle impounded at officer discretion', NULL, 4, 5000, 0, 60, 120, '2023-11-03 22:23:17', '2023-11-03 22:23:17', NULL),
	(153, 13, 9, 'Illegal Usage Of Hydraulics', '1. A person driving a vehicle that uses hydraulic equipment while in motion or on a public street, road, or highway.\r\n2. This excludes vehicles with hydraulic equipment permitted exclusively for business and equipment purposes, such as a forklift in motion.\r\n\r\n- Impoundment of the individual’s vehicle at officer discretion', NULL, 7, 2500, 0, 0, 0, '2023-11-03 22:24:11', '2023-11-03 22:24:11', NULL),
	(154, 13, 10, 'Driving Under The Influence (DUI)', '1. A person who drives a vehicle or operates heavy machinery while under the influence of alcohol at or above the legal limit of 0.08 percent BAV\r\n2. A person who drives a vehicle or operates heavy machinery while under the influence of alcohol at or above the legal limit of 0.08 percent BAV\r\n3. A person who drives or operates heavy machinery under the influence of awareness-altering drugs, regardless of whether those drugs are being used under a prescription.\r\n\r\n- Officer must suspend license and impound the vehicle.\r\n\r\nNOTES\r\n- A person who is at or above the 0.08 percent BAV legal limit shall receive the minimum sentence.\r\n- A person who is a government employee shall receive the maximum sentence and be referred to the HR of their respective State Agency.', NULL, 4, 480, 0, 60, 120, '2023-11-03 22:25:30', '2023-11-03 22:25:30', NULL),
	(155, 13, 11, 'Registration Violation', 'A person driving a vehicle on a state, county, or local road without an official owner’s registration or lease registration on file or in hand, or without a license plate affixed to the rear of the vehicle.\r\n\r\n-  Impoundment of the individual’s vehicle at the peace officer’s discretion.', NULL, 7, 5000, 0, 0, 0, '2023-11-03 22:26:16', '2023-11-03 22:26:16', NULL),
	(156, 13, 12, 'Unsafe Usage Of A Bicycle', 'A person\'s unsafe usage of a bicycle or other non-motor vehicle that obstructs traffic, incites disorder, creates a hazard, or demonstrates the potential for harm.', NULL, 7, 2500, 0, 0, 0, '2023-11-03 22:26:45', '2023-11-03 22:26:45', NULL),
	(157, 13, 13, 'Street Racing', '1. Performing an unlicensed or unauthorized vehicle race, performance, or competition on city, county, or state property\r\n2. Performing a vehicle race on a hazardous private course.\r\n3. Organizing, facilitating, or promoting a street race or other unlicensed or organized vehicle race or competition on city, county, or state property.\r\n\r\n\r\nNOTES\r\n* A “race” or “competition” is any event that reasonably should not be taking place on a road. A hydraulics competition, for example, or a race around the dockyards both apply under street racing.\r\n* Any parking lots not considered owned by a particular business (such as the old bank parking lot in Mulholland) are considered public state property.', NULL, 4, 1000, 0, 30, 60, '2023-11-03 22:27:58', '2023-11-03 22:27:58', NULL),
	(158, 13, 14, 'Driving without a Valid License', '1. A person operating a motor vehicle without carrying a valid driver\'s license.\r\n2. A person who refuses to show or provide a driver\'s license to a peace officer while operating a motor vehicle.\r\n3. A person operating a motor vehicle without a valid, unexpired permit or license.\r\n\r\n- The peace officer may also issue a warning or fine up to $3,000 instead at their discretion.', NULL, 4, 1000, 0, 0, 0, '2023-11-03 22:28:38', '2023-11-03 22:28:38', NULL),
	(159, 13, 15, 'Jaywalking', 'A person who recklessly or intentionally crosses a road in a manner that creates a foreseeable risk of obstructing the flow of traffic, or otherwise creates a hazard to themselves and others.\r\n\r\n- Fine at peace officer\'s discretion. Max $2000', NULL, 7, 2000, 0, 0, 0, '2023-11-03 22:29:22', '2023-11-03 22:29:22', NULL),
	(160, 13, 16, 'Illegal Parking Of An Aircraft', 'A person who failures to follow the flight protocols as detailed in the State Aviation Act\r\n\r\n- Fine at peace officer\'s discretion. Max $20,000', NULL, 7, 10000, 0, 0, 0, '2023-11-03 22:30:06', '2023-11-03 22:30:06', NULL);

INSERT INTO `permissions` (`title`, `category`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES
	('admin_access', 'admin', 'Grants access to Admin Area.', '2023-01-19 20:18:19', '2023-01-19 20:18:19', NULL),
	('announcement_manage', 'staff', 'Grants access to Announcements.', '2023-01-19 20:34:19', '2023-01-19 20:34:19', NULL),
	('application_access', 'staff', 'Grants access to Applications link.', '2023-01-19 21:17:26', '2023-01-19 21:17:27', NULL),
	('role_manage', 'admin', 'Grants access to Roles link', '2023-01-19 21:56:40', '2023-01-19 21:56:40', NULL),
	('application_staff_review', 'staff', 'Grants access to Flagged for Staff Applications', '2023-01-19 22:01:13', '2023-01-19 22:01:13', NULL),
	('application_action', 'staff', 'Grants access to action Applications.', '2023-01-19 22:01:25', '2023-01-19 22:01:25', NULL),
	('user_access', 'admin', NULL, '2023-01-27 17:41:34', '2023-01-27 17:41:34', NULL),
	('user_view', 'admin', NULL, '2023-01-27 17:41:58', '2023-01-27 17:41:58', NULL),
	('user_manage_user_roles', 'admin', 'Grants access to edit User Roles.', '2023-01-29 20:03:03', '2023-01-29 20:03:03', NULL),
	('user_edit_user_status', 'admin', 'Grants access to edit User account Status.', '2023-02-03 23:13:44', '2023-02-03 23:13:44', NULL),
	('user_manage_user_notes', 'admin', 'Grants access to manage User Notes.', '2023-05-16 15:01:48', '2023-05-16 15:01:50', NULL),
	('user_manage_user_accommodations', 'admin', 'Grants access to manage User Accommodations.', '2023-05-16 15:02:05', '2023-05-16 15:02:05', NULL),
	('user_manage_user_disciplinary_actions', 'admin', 'Grants access to manage User Disciplinary Actions.', '2023-05-16 15:02:20', '2023-05-16 15:02:20', NULL),
	('user_advanced_access', 'admin', 'Grants access to manage non-member Users.', '2023-05-16 15:55:13', '2023-05-16 15:55:13', NULL),
	('user_departments_manage', 'staff', 'Grants access to manage Members Departments', '2023-05-16 22:32:37', '2023-05-16 22:32:38', NULL),
	('department_manage', 'admin', 'Grants access to manage departments.', '2023-05-25 17:11:08', '2023-05-25 17:11:08', NULL),
	('disciplinary_action_type_manage', 'admin', 'Grants access to manage Disciplinary Action Types.', '2023-06-12 19:47:59', '2023-06-12 19:47:59', NULL),
	('license_type_manage', 'admin', 'Grants access to manage License Types', '2023-06-12 20:15:40', '2023-06-12 20:15:40', NULL),
	('civilian_level_manage', 'admin', 'Grants access to manage Civilian Levels', '2023-06-13 14:59:27', '2023-06-13 14:59:27', NULL),
	('staff_access', 'staff', 'Grants access to Staff Area.', '2023-07-22 19:30:14', '2023-07-22 19:30:14', NULL),
	('supervisor_access', 'supervisor', 'Grants access to Supervisor Area.', '2023-07-22 19:30:13', '2023-07-22 19:30:13', NULL),
	('cad_settings', 'admin', 'Grants access to CAD Settings. Very dangerous permission to give.', '2023-06-13 18:26:03', '2023-06-13 18:26:03', NULL),
	('report_type_manage', 'admin', 'Grants access to manage report types.', '2023-07-22 19:30:12', '2023-07-22 19:30:12', NULL),
	('penal_code_manage', 'admin', 'Grants access to manage the penal code.', NULL, NULL, NULL),
	('impound_lot_manage', 'courthouse', 'Grans access to impound lot and ability to release vehicles', '2023-10-05 19:46:30', '2023-10-05 19:46:30', NULL),
	('suspended_license_manage', 'courthouse', 'Grants access to suspended licenses and ability to release them.', '2023-10-05 19:48:24', '2023-10-05 19:48:25', NULL),
	('reports_manage', 'supervisor', 'Grants access to reports area in the supervisor screen.', '2023-10-05 19:48:24', '2023-10-05 19:48:25', NULL),
	('business_manage', 'supervisor', 'Grants access to business area in the supervisor screen.', '2023-10-05 19:48:24', '2023-10-05 19:48:25', NULL);


INSERT INTO `report_types` (`id`, `title`, `is_locked`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, 'End Of Watch Report', 1, 'Report for the end of patrol.', '2023-07-09 04:35:13', '2023-07-09 04:35:13', NULL),
	(2, 'Use of Force', 0, 'Report for a use of force event by a LEO officer.', '2023-07-22 21:53:27', '2023-07-23 00:21:59', NULL),
	(3, 'Officer Involved Shooting', 0, 'Fill this out when you are involved in a shooting.', '2024-01-06 04:14:43', '2024-01-06 04:14:43', NULL),
	(4, 'Medical Report', 0, 'Fill this out when you give medical aid to someone.', '2024-01-06 04:14:59', '2024-01-06 04:14:59', NULL),
	(5, 'Supervisor Evidence Collecting Report Form', 0, 'Fill this out if you are a supervisor and collect evidence related to a OIS.', '2024-01-06 04:15:58', '2024-01-06 04:15:58', NULL),
	(6, 'Witness Statement', 0, 'Fill this out after gathering a witness statement', '2024-01-06 04:16:33', '2024-01-06 04:16:33', NULL),
	(7, 'Post-Call Interaction Report', 0, 'Fill this out after each call. You can disregard this **ONLY** if you have filled out another type of report for the call.', '2024-01-06 04:17:50', '2024-01-06 04:17:50', NULL),
	(8, 'Vehicle Accident Report', 0, 'Fill this out for a vehicle accident report.', '2024-01-06 04:18:12', '2024-01-06 04:18:12', NULL),
	(9, 'Sub Division Activation Report', 0, 'Fill this out after the use of a sub division', '2024-01-06 04:19:32', '2024-01-06 04:19:32', NULL);


INSERT INTO `users` (`id`, `discord_name`, `discord_username`, `discriminator`, `avatar`, `steam_hex`, `steam_id`, `steam_name`, `account_status`, `reapply`, `reapply_date`, `denied_reason`, `email`, `real_name`, `birthday`, `display_name`, `ts_name`, `officer_name`, `last_login`, `is_protected_user`, `is_super_user`, `civilian_level_id`, `member_join_date`, `remember_token`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(188790560658685954, 'Ron Swanson', '.ronswanson', '0', 'https://cdn.discordapp.com/avatars/188790560658685954/a_92e9cc29feaeb37cb66418a8d320faf0.gif', '11000010CDE9587', 76561198176179591, 'Loaf Dog', 3, NULL, NULL, NULL, 'test@test.com', 'Ron Swanson', '1776-07-04', NULL, NULL, 'Ron S', '2023-11-25 15:11:26', 1, 1, 1, '2023-06-13 17:13:04', 'ivF292Ty1VPQ8dyaK0JL3aAbT7Uh1YZJiXpcjng5FsZ4uwfXjklQCUjQ4k2f', '2023-05-28 21:18:50', '2023-11-25 15:11:26', NULL);
