-- Table structure for table `crime_stopper_municodes`
--

CREATE TABLE `crime_stopper_municodes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bussinessGroupId` int(100) NOT NULL DEFAULT '0',
  `municode` varchar(500) DEFAULT NULL,
  `AgencyId` int(100) NOT NULL,
  `PrecintId` int(100) NOT NULL,
  `Type` varchar(100) DEFAULT NULL,
  `Name` varchar(100) DEFAULT NULL,
  `Year` varchar(100) DEFAULT NULL,
  `Title` varchar(500) DEFAULT NULL,
  `TitleName` varchar(100) DEFAULT NULL,
  `Chapter` varchar(100) DEFAULT NULL,
  `ChapterName` varchar(100) DEFAULT NULL,
  `Section` varchar(100) DEFAULT NULL,
  `SectionName` varchar(100) DEFAULT NULL,
  `Paragraph` varchar(500) DEFAULT NULL,
  `ShortDesc` varchar(500) DEFAULT NULL,
  `FullLegalDescription` text,
  `status` varchar(100) NOT NULL DEFAULT 'active',
  `createdAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `createdBy` int(100) DEFAULT NULL,
  `updatedAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updatedBy` int(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=83 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `crime_stopper_municodes`
--

INSERT INTO `crime_stopper_municodes` VALUES (15,0,'1-1a-3a-pg1 (2000)',528190,527232,'business','Peachtree Corners','2000','1','tn1','1a','Chapter1','3a','section 1','pg1','sd1','aaaaaa','active','2023-01-17 13:37:57',540969,'2023-03-04 12:53:59',540969),(16,0,'2-1b-3b-pg2 (1999)',528190,527232,'business','Peachtree Corners','1999','2','tn2','1b','Chapter2','3b','section 2','pg2','sd2','dddd','active','2023-01-17 13:37:57',540969,'2023-03-04 12:54:14',540969),(17,0,'3-1c-3c-pg3 (1890)',528190,527232,'news firm','Peachtree Corners','1890','3','tn3','1c','Chapter3','3c','section 3','pg3','sd3','bbbbb','active','2023-01-17 13:37:57',540969,'2023-03-04 12:54:00',540969),(18,0,'4-1d-3d-pg4 (1998)',528190,527232,'news firm','Peachtree Corners','1998','4','tn4','1d','Chapter4','3d','section 4','pg4','sd4','cccccc','active','2023-01-17 13:37:57',540969,'2023-03-04 12:54:15',540969),(19,0,'5-2d-2d-pg5 (1998)',528190,527232,'news firm','Peachtree Corners','1998','5','tn5','2d','Chapter5','2d','section 5','pg5','sd5','Full egal description is here','active','2023-01-17 13:37:57',540969,'2023-03-04 12:54:16',540969),(20,0,'5-123-2d-pg5 (1998)',528190,527232,'news firm','Peachtree Corners','1998','5','tn5','123','Chapter5','2d','section 5','pg5','sd5','Full egal description is here','active','2023-01-17 13:37:57',540969,'2023-03-04 12:54:01',540969),(51,0,'40-6-9-(b) (2010)',500438,499480,'State','Georgia','2010','40','Motor Vehicles and Traffice','6','Uniform Rules of the Road','9','Speed Restrictions','(b)','Maximum limits','Consistent with the provision of engineering and traffic investigations regarding maximum speed limits as provided in Code Section 40-6-182, no person shall drive a vehicle at a speed in excess of the following maximum limits:','active','2023-01-17 13:53:30',540969,'2023-02-08 13:20:20',513217),(52,0,'40-6-9-(b)(1) (2010)',500438,499480,'State','Georgia','2010','40','Motor Vehicles and Traffice','6','Uniform Rules of the Road','9','Speed Restrictions','(b)?(1)','Maximum limits',' Thirty miles per hour in any urban or residential district;','active','2023-01-17 13:53:30',540969,'2023-02-08 13:20:21',513217),(53,0,'40-6-9-(b)(1.1) (2010)',500438,499480,'State','Georgia','2010','40','Motor Vehicles and Traffice','6','Uniform Rules of the Road','9','Speed Restrictions','(b)?(1.1)','Maximum limits','Thirty-five miles per hour on an unpaved county road unless designated otherwise by appropriate signs;','active','2023-01-17 13:53:30',540969,'2023-02-08 13:20:22',513217),(54,0,'40-6-9-(b)(2) (2010)',500438,499480,'State','Georgia','2010','40','Motor Vehicles and Traffice','6','Uniform Rules of the Road','9','Speed Restrictions','(b)(2)','Maximum limits','Seventy miles per hour on a highway on the federal interstate system and on physically divided highways with full control of access which are outside of an urbanized area of 50,000 population or more, provided that such speed limit is designated by appropriate signs;','active','2023-01-17 13:53:30',540969,'2023-02-08 13:20:23',513217),(55,0,'40-6-9-(b)(3) (2010)',500438,499480,'State','Georgia','2010','40','Motor Vehicles and Traffice','6','Uniform Rules of the Road','9','asdasd','(b)(3)','Maximum limits','Sixty-five miles per hour on a highway on the federal interstate system which is inside of an urbanized area of 50,000 population or more, provided that such speed limit is designated by appropriate signs;','active','2023-01-17 13:53:30',540969,'2023-02-08 13:20:24',513217),(56,0,'40-6-9-(b)(4)  (2010)',500438,499480,'State','Georgia','2010','40','Motor Vehicles and Traffice','6','Uniform Rules of the Road','9','Speed Restrictions','(b)(4) ','Maximum limits','Sixty-five miles per hour on those sections of physically divided highways without full access control on the state highway system, provided that such speed limit is designated by appropriate signs; and','active','2023-01-17 13:53:30',540969,'2023-02-08 13:20:25',513217),(57,0,'40-6-9-(b)(5)  (2010)',500438,499480,'State','Georgia','2010','40','Motor Vehicles and Traffice','6','Uniform Rules of the Road','9','Speed Restrictions','(b)(5) ','Maximum limits',' Fifty-five miles per hour in other locations.','active','2023-01-17 13:53:30',540969,'2023-02-08 13:20:26',513217),(58,0,'40-6-9-(c)  (2010)',500438,499480,'State','Georgia','2010','40','Motor Vehicles and Traffice','6','Uniform Rules of the Road','9','Speed Restrictions','(c) ','Maximum limits','The maximum speed limits set forth in this Code section may be altered as authorized in Code Sections 40-6-182, 40-6-183, and 40-6-188.','active','2023-01-17 13:53:30',540969,'2023-02-08 13:20:27',513217),(59,0,'3a-2e-das-r3 (2022)',528190,527232,'State','Peachtree Corners','2022','3a','ehloo','2e','','das','das','r3','adasds','oiuytre','active','2023-01-23 14:15:22',540969,'2023-03-04 12:54:17',NULL),(60,0,'2a-4f-ads-e3 (2022)',528190,527232,'City','Peachtree Corners','2022','2a','echi','4f','','ads','asdasd','e3','qweqwe','lkjhgf','active','2023-01-23 14:15:22',540969,'2023-03-04 12:54:18',NULL),(61,0,'1b-5r-asdad-w2 (2022)',528190,527232,'State','Peachtree Corners','2022','1b','asdsd','5r','','asdad','asdsd','w2','XzX','ksdfg','active','2023-01-23 14:15:22',540969,'2023-03-04 12:54:19',NULL),(62,0,'3c-d-asdad-r5 (2022)',528190,527232,'City','Peachtree Corners','2022','3c','console','d','','asdad','asddd','r5','xbnbnbvnb','mnvcxzssdx','active','2023-01-23 14:15:22',540969,'2023-03-04 12:54:20',NULL),(63,0,'40-6-9-(b)(4) (2055)',500438,499480,'State','Georgia','2055','40','Motor Vehicles and Traffice','6','Uniform Rules of the Road','9','Speed Restrictions','(b)(4)','Maximum limits','Sixty-five miles per hour on those sections of physically divided highways without full access control on the state highway system, provided that such speed limit is designated by appropriate signs; and','active','2023-01-23 15:04:08',513217,'2023-02-08 13:20:31',NULL),(64,0,'40-6-9-(b)(5) (2010)',500438,499480,'State','Georgia','2010','40','Motor Vehicles and Traffice','6','Uniform Rules of the Road','9','Speed Restrictions','(b)(5)','Maximum limits','Fifty-five miles per hour in other locations.','active','2023-01-23 15:04:08',513217,'2023-02-08 13:20:32',NULL),(65,0,'40-6-9-(c) (2023)',500438,499480,'State','Georgia','2023','40','Motor Vehicles and Traffice','6','Uniform Rules of the Road','9','Speed Restrictions','(c)','Maximum limits','The maximum speed limits set forth in this Code section may be altered as authorized in Code Sections 40-6-182, 40-6-183, and 40-6-188.','active','2023-01-23 15:04:08',513217,'2023-02-08 13:20:33',NULL),(66,0,'9-aa-aa-(b)(2) (2010)',528279,527341,'State','Georgia','2010','9','','aa','a1','aa','df','(b)(2)','Maximum limits',' Fifty-five miles per hour in other locations.','active','2024-01-10 11:23:16',541177,'2024-01-10 11:23:16',NULL),(67,0,'8-bb-bb-(b)(2) (2011)',528279,527341,'State','Peachtree Corners','2011','8','','bb','b1','bb','gre','(b)(2)','adasds','asdf','active','2024-01-10 11:23:16',541177,'2024-01-10 11:23:16',NULL),(68,0,'71-cc11-cc234-pg41-2011',528279,527341,'Federal','USC','2011','71','zxcfvgbnm','cc11','ca1','cc234','gfe','pg41','adasds111111111111','gfdsasdfghgfdsasdfghhgfhjjhnbd111111111111','active','2024-01-10 11:23:16',541177,'2024-01-10 11:24:48',541177),(69,0,'6-dd-dd-pg4 (2010)',528279,527341,'City','Peachtree Corners','2010','6','','dd','d1','dd','gfd','pg4','adasds','ndfgbnnbvds','active','2024-01-10 11:23:16',541177,'2024-01-10 11:23:16',NULL),(70,0,'51-ee1-ee1-(b)(2)1-2012',528279,527341,'County','Fayette County','2012','51','welcome1','ee1','e1','ee1','fdsd1','(b)(2)1','Maximum limits11','asdfghjkjhgfdsadfghmnhgfds11','active','2024-01-10 11:23:16',541177,'2024-01-10 11:24:04',541177),(71,0,'4-ff-ff-(b)(2) (2010)',528279,527341,'City','Peachtree Corners','2010','4','','ff','f1','ff','ffdeghgrghg','(b)(2)','Maximum limits','fdsasdfg','active','2024-01-10 11:23:16',541177,'2024-01-10 11:23:16',NULL),(72,0,'3-gg-gg-pg4-2011',528279,527341,'State','Delaware','2011','3','testing','gg','g1','gg','fd','pg4','Maximum limits','fgnffghj,jhtrerhjh','active','2024-01-10 11:23:16',541177,'2024-01-11 10:26:17',541177),(73,0,'21-hh-hh-(b)(2)-2012',528279,527341,'City','Lexington','2012','21','dasdasdas','hh','h1','hh','fvfdf','(b)(2)','adasds','sdfgfdsa','inactive','2024-01-10 11:23:16',541177,'2024-02-15 16:02:32',541177),(74,0,'22-ii-ii-(b)(2)-2010',528279,527341,'County','Fayette County','2010','22','','ii','e1','ii','bfdff','(b)(2)','Maximum limits',' Fifty-five miles per hour in other locations.','active','2024-01-10 11:23:16',541177,'2024-01-11 10:32:22',541177),(76,0,'red-test-2A-21-2024',0,0,'State','Delaware','2024','red','red hood','test','red hood test chapter','2A','red hood ','21','sadadas','asdasdsddd','active','2024-01-11 09:43:24',541177,'2024-01-11 09:43:24',NULL),(77,0,'asdasds-asdasd-3a-2a-202',0,0,'City','Lexington','202','asdasds','asdsd','asdasd','asdasd','3a','dasd','2a','dasd','asdasdsaasda','active','2024-01-11 09:48:44',541177,'2024-01-11 09:48:44',NULL),(78,0,'asdas-ada-asdasd-adasdd-2020',0,0,'State','Delaware','2020','asdas','asdaa','ada','asdasd','asdasd','adasd','adasdd','asdas','asdsadasdads','active','2024-01-11 09:54:44',541177,'2024-01-11 09:54:44',NULL),(79,0,'Decade code-Decade code-Decade code-Decade code-10',528279,527341,'City','Lexington','10','Decade code','Decade code','Decade code','Decade code','Decade code','Decade code','Decade code','Decade cod','Decade code','active','2024-02-15 15:50:17',541177,'2024-02-27 19:46:49',650),(80,0,'testing-red-3a-3-2024',528190,527232,'Federal','USC','2024','testing','new munidcpde','red','asdas','3a','test','3','adasd','adasdsdssadasd','active','2024-03-26 10:29:53',540969,'2024-03-26 10:29:53',NULL),(81,0,'5-2D-2D-PG 5 (2024)',528190,527232,'state','Alaska','2024','5','TN5','2D','Chapter 5','2D','Section 5','PG 5','TEST','TEST','active','2024-03-26 10:41:58',540969,'2024-03-26 10:41:58',NULL),(82,0,'new code-1-3a-34-2024',528349,527435,'County','New York County','2024','new code','test','1','rr','3a','3s','34','test','asads','active','2025-01-15 10:44:02',541555,'2025-01-15 10:44:02',NULL);

--
-- Table structure for table `crime_stopper_offense`
--

CREATE TABLE `crime_stopper_offense` (
  `id` int(11) NOT NULL,
  `offName` varchar(100) DEFAULT NULL,
  `offDescription` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `crime_stopper_offense`
--

INSERT INTO `crime_stopper_offense` VALUES (1,'Aggravated Assualt','Attempt to murder/rape/rob with a deadly weapon resulting in serious bodily injury'),(2,'Aggravated Battery','Maliciously cause harm resulting in disfigurement or uselessness of a body part'),(3,'Aggravated Sexual Battery','Intentionally penetrates person\'s sexual parts with an object without consent'),(4,'Aggravated Stalking','Violate court order by contacting person without consent to harass or intimidate'),(5,'Arson','1st, 2nd, or 3rd degree criminal act of deliberately setting fire to property.'),(6,'Battery','Intentionally causes substantial physical harm or visible bodily harm to another'),(7,'Burglary','Entry into a building illegally with intent to commit a crime, especially theft.'),(8,'Child Molestation','Child abuse in which an adult or older adolescent uses a child for sexual stimulation.'),(9,'Cruelty to Children','1st, 2nd, or 3rd degree child under the age of 18 willfully deprivided of necessay sustenance jepardizing the child\'s well being '),(10,'Demestic Terrorism','Act to kill people/ruin critical infrastructure to scare people/sway government'),(11,'Enticing a Child','Enticing a child for indecent purposes '),(12,'False Imprisonment','Arrests, fonfines, or detains another without legal authority'),(13,'Forgery','Felony or Misemeanor action of producing a copy of a document, sgnature, banknote or work of art.'),(14,'Gambling','To unlawfully stake money or something else of value on the happening of an uncertain event or on the ascertainment of a fact in dispute.'),(15,'Hijacking a Motor Vehicle','Crime of seizing possession or control of a vehicle from another by force or threat of force. '),(16,'Hit and Run','Felony or Misemeanor car crash failing to stop at the scene, provide identification or offer assistance to injured as a result of the accident'),(17,'Home Invasion','1st or 2nd degree entering a dwelling and committing or with intent to commit a crime (as assault) while armed and while another is lawfully present.'),(18,'Involuntary Manslaughter','Cause Death of another without intent through commission of an unlawful act'),(19,'Keeping a Place of Prostitution','Keeping a place of prostitution '),(20,'Kidnapping','The action of abducting someone and holding them captive. '),(21,'False Identification Document','Attempt to murder/rape/rob with a deadly weapon resulting in serious bodily injuryManufacturing, Selling, or Distributing false indentification document - Felony or Misdemeanor\n'),(41,'Murder','The unlawful premeditated killing of one human being by another. '),(42,'Chop Shop','Owning, Operating, or Conducting a Chop Shop or doing transactions or working with stolen vehicles/parts '),(43,'Gang Activity','Participation in Criminal Gang Activity Proohibited '),(44,'Peeping Toms','Be on the site of another to spy on / invade privacy of them by peeping into places'),(45,'Illegal Firearms Possession ','Unlawful Possession of Firearms or Weapons by Person,  Convicted Felons or First Offender Probationers '),(46,'Underage Fireams Possession ','Possession of Handgun by Person Under the Age of 18 Years '),(47,'Prostitution','The practice or occupation of engaging in sexual activity with someone for payment.'),(48,'Rape','Unlawful sexual activity and usually sexual intercourse carried out forcibly or under threat of injury against a person\'s will or with a person who is beneath a certain age or incapable of valid consent because of mental illness, mental deficiency, intoxication, unconsciousness, or deception '),(49,'Reckless Abandonment','Caretaker\'s willful physical abandonment of a child <1 yr resulting in death'),(50,'Robbery','The action of taking property unlawfully from a person or place by force or threat of force.'),(51,'Drug Dealings','Sale, Distribution, or Possession of Dangerous Drugs '),(52,'Sexual Battery','Makes intention physical contact with intimate body parts of another without consent '),(53,'Simple Assault','Commiting assault with intent to inflict violent injury '),(54,'Stalking','Unlawful pursue, follow, trail, shadow or approach stealthily '),(55,'Street Racing','Unsanctioned and illegal form of auto racing that occurs on a public road. '),(56,'Terroristic Acts','Do violence / release hazardous matter / hurt property to terrorize people / property '),(57,'Terroristic Threats','Threat of violence / hazardous matter / hurt property to terrorize people / property '),(58,'Theft','The action or crime of stealing - Felony or Misdemeanor '),(59,'Human Trafficking','Trafficking of Persons for Labor or Sexual Servitude '),(60,'Voluntary Manslaughter','Cause Death of another immediately following sudden provocation '),(61,'Suspicious Person','Person who is exhibiting suspicious behavior, or who is in an area or doing something that is not normal. '),(62,'Custody Order Violation','Willful disobedience of custody terms outlined in a court order. '),(63,'Damage to property','The act of changing, modifying or defacing public or private property. '),(64,'Dine and Dash','A dine and dash is a form of theft by fraud, in which a patron orders and consumes food and beverages from a restaurant or similar establishment with the intent not to pay. '),(65,'Fraud/Swindle','The intentional perversion of the truth for the purpose of inducing another person or other entity in reliance upon it to part with something of value or surrender a legal right. This can occur either electronically or in person. '),(66,'Fraudulent Use of Credit Card','Fraudulent use of debit/credit card number to obtain credit, goods or services  '),(67,'Harassing Communication','Repeated communication with a person, anonymously or otherwise, by telephone, telegraph, mail, email or text messaging or any other form of electronic or written communication in a manner which causes annoyance or alarm without threats of violence to persons or property. Unwanted phone calls of an annoying, harassing, vulgar or obscene nature. '),(68,'Identity Theft','Obtaining someone else\'s personal identifying information and using it to obtain credit, goods or services.  Tax return fraud. '),(69,'Information Only','Use this report for documenting a nuisance or non-criminal incident. '),(70,'Lost Property','Property that is missing, misplaced, or lost. Property is lost when the owner has lost the possession or custody of it, by accident or forgetfulness, and the propertys location is unknown and can reasonably be assumed to have been abandoned.'),(71,'Supplemental Report','Reporting additional information to an approved police report '),(72,'Theft of Services','A person obtains services, accommodations, entertainment, or the use of personal property which is available only for compensation without paying for them. '),(73,'Vehicle Impound','For official use for reporting vehicle impound by authorized person. '),(74,'Vehicle Repossession','For official use for reporting vehicle repossession by authorized person. '),(75,'Porch Piracy','The act of stealing packages from another home or business '),(76,'School Bullying','Student seeking to harm, intimidate, or coerce (someone perceived as vulnerable) another student '),(77,'Missing Person','Person whose whereabouts are unknown.');

--
-- Table structure for table `crime_stopper_people_involved`
--

CREATE TABLE `crime_stopper_people_involved` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `crimeId` int(11) NOT NULL DEFAULT '0',
  `peopleInvolvedType` varchar(100) DEFAULT NULL,
  `fullName` varchar(100) DEFAULT NULL,
  `homeaddress` varchar(100) DEFAULT NULL,
  `homeState` varchar(100) DEFAULT NULL,
  `homeCity` varchar(100) DEFAULT NULL,
  `workAddress` varchar(100) DEFAULT NULL,
  `workState` varchar(100) DEFAULT NULL,
  `workCity` varchar(100) DEFAULT NULL,
  `phone` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `employer` varchar(100) DEFAULT NULL,
  `race` varchar(100) DEFAULT NULL,
  `dob` varchar(100) DEFAULT NULL,
  `ethnicity` varchar(100) DEFAULT NULL,
  `sex` varchar(100) DEFAULT NULL,
  `driverLicenseNo` varchar(100) DEFAULT NULL,
  `age` varchar(100) DEFAULT NULL,
  `height` varchar(100) DEFAULT NULL,
  `weight` varchar(100) DEFAULT NULL,
  `eyeColor` varchar(100) DEFAULT NULL,
  `hariColor` varchar(100) DEFAULT NULL,
  `picture` varchar(1000) DEFAULT NULL,
  `homeLat` varchar(100) DEFAULT NULL,
  `homeLong` varchar(100) DEFAULT NULL,
  `workLat` varchar(100) DEFAULT NULL,
  `workLong` varchar(100) DEFAULT NULL,
  `createdBy` int(11) NOT NULL DEFAULT '0',
  `createdAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedBy` int(11) NOT NULL DEFAULT '0',
  `updatedAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `crime_stopper_people_involved`
--

INSERT INTO `crime_stopper_people_involved` VALUES (1,1,'a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','https://bbpimagesandvideos.s3.amazonaws.com/a6-a1790ca001c01462df03714e3797464e.jpg','11','12','123','1234',540969,'2022-11-30 12:31:49',0,'2022-11-30 12:31:52'),(2,2,'a1','b1','c1','d1','e1','f1','g1','h1','i1','j1','k1','l1','m1','n1','o1','p1','q1','r1','s1','t1','u1','https://bbpimagesandvideos.s3.amazonaws.com/2-fddad961ab2d309a84a86df8deefb5be.jpg','111','121','1231','12341',540969,'2022-11-30 12:33:52',540969,'2022-11-30 12:51:16'),(3,6,'a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','https://bbpimagesandvideos.s3.amazonaws.com/a6-8a72922745862db2854ee9536ae4b4bc.jpg','11','12','123','1234',540969,'2022-11-30 12:33:53',0,'2022-11-30 12:51:17'),(4,1,'a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u',NULL,'11','12','123','1234',540969,'2022-12-01 10:55:05',0,'2022-12-01 10:55:05'),(5,1,'a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u',NULL,'11','12',NULL,NULL,540969,'2022-12-02 10:29:13',0,'2022-12-02 10:29:13'),(6,38,'a1','b1','c1','d1','e1','f1','g1','h1','i1','j1','k1','l1','m1','n1','o1','p1','q1','r1','s1','t1','u1','https://bbpimagesandvideos.s3.amazonaws.com/policeforce-old.png','111','121','1231','12341',540969,'2022-12-02 11:20:57',540969,'2022-12-19 13:15:30'),(7,38,'Suspect','suspectKhan','St Pancras Station, Euston Road, London, UK','west bengal',NULL,'Waterloo Station, London, UK',NULL,NULL,'(333) 333-3333','han@gmail.com','test',NULL,'2022-12-25','sed','female','er456','23','511','123','Brown','Blond Hair','https://bbpimagesandvideos.s3.amazonaws.com/policeforce-old.png',NULL,NULL,NULL,NULL,540969,'2022-12-02 13:22:05',0,'2022-12-19 13:15:32'),(8,38,'Witness','witnedd','India Gate, Kartavya Path, India Gate, New Delhi, Delhi, India','bangalore',NULL,'Panvel, Navi Mumbai, Maharashtra, India',NULL,NULL,'(222) 222-2222','test@gmail.com','swer',NULL,'2022-12-18','sed','male','23wer','23','511','23','Brown','Gray and White Hair','https://bbpimagesandvideos.s3.amazonaws.com/download2-b580926cb6ecbd7075c1e5e64e3bc778.jpg',NULL,NULL,NULL,NULL,540969,'2022-12-03 06:10:51',0,'2022-12-05 13:17:03'),(13,33,'Victim','test','St Pancras Station, Euston Road, London, UK','ses',NULL,'Eiffel Tower, Avenue Anatole France, Paris, France',NULL,NULL,'(222) 222-2222','aa@gmail.com','sed',NULL,'2022-12-18','sed','male','23aaeds','22','47','23','Brown','Black Hair','https://bbpimagesandvideos.s3.amazonaws.com/policeforce-old.png',NULL,NULL,NULL,NULL,540969,'2022-12-05 13:21:01',540969,'2022-12-19 13:15:35'),(14,41,'Witness','harish kadli','220 West 31st Street, New York, NY, USA','Karnataka',NULL,'180 Water Street, New York, NY, USA',NULL,NULL,'(918) 095-1292','harishkadli@gmail.com','wertyj',NULL,'2022-12-14','Bangalore East','male','asdf','','','12','Blue','Brown Hair','https://bbpimagesandvideos.s3.amazonaws.com/a8-e5c057f4c2ca419477de685fea6a2ccc.jpg',NULL,NULL,NULL,NULL,359,'2022-12-05 15:21:22',0,'2022-12-05 15:21:22'),(15,42,'Witness','PRIYA KATTIMANI','180 Russell Street, Melbourne VIC, Australia','Karnataka',NULL,'180 Greenwich Street, New York, NY, USA',NULL,NULL,'(824) 269-8542','a@gmail.com','asdfg',NULL,'2022-12-15','GOKAK','male','asdfg','32','22','123','Blue','Auburn Hair','https://bbpimagesandvideos.s3.amazonaws.com/a9-a54e6be84676079f57287c0bbff39326.jpg',NULL,NULL,NULL,NULL,359,'2022-12-05 15:24:44',0,'2022-12-05 15:24:44'),(16,42,'Victim','sed','Sydney NSW, Australia','',NULL,'210 Quai de Bercy, Paris, France',NULL,NULL,'(234) 234-2342','asdasd','asdasd',NULL,'2022-12-17','sasdasd','male','','','','','','',NULL,NULL,NULL,NULL,NULL,540969,'2022-12-05 15:49:50',0,'2022-12-05 15:49:50'),(17,43,'Suspect','new test','Waterloo Station, London, UK','uhed',NULL,'Quito, Ecuador',NULL,NULL,'(222) 222-2222','a@gmail.com','test',NULL,'2022-12-25','ses','male','we134','24','15','123','Amber','Red Hair','https://bbpimagesandvideos.s3.amazonaws.com/policeforce-old.png',NULL,NULL,NULL,NULL,359,'2022-12-05 15:54:00',0,'2022-12-19 13:15:37'),(18,47,'Suspect','sasd','St Pancras Station, Euston Road, London, UK','asds',NULL,'Seattle, WA, USA',NULL,NULL,'(222) 222-2222','mansi@gamil.comom','asdsd',NULL,'2022-12-18','sed','male','asd234','23','310','123','Amber','Black Hair','https://bbpimagesandvideos.s3.amazonaws.com/policeforce-old.png',NULL,NULL,NULL,NULL,359,'2022-12-06 10:24:56',0,'2022-12-19 13:15:40'),(19,52,'Suspect','manikandan','St Pancras Station, Euston Road, London, UK','ss',NULL,'San Diego, CA, USA',NULL,NULL,'(222) 222-2222','test@gmail.com','sed',NULL,'2022-12-18','assdasd','male','dss','12','44','22','Gray','Red Hair','https://bbpimagesandvideos.s3.amazonaws.com/policeforce-old.png',NULL,NULL,NULL,NULL,540969,'2022-12-07 11:34:52',0,'2022-12-19 13:15:44'),(20,56,'Victim','ss','St Pancras Station, Euston Road, London, UK','ujh',NULL,'Waterloo Station, London, UK',NULL,NULL,'(222) 222-2222','tes@gmail.com','asd',NULL,'2022-12-11','sw','male','tyu','22','26','22','Amber','Blond Hair','https://bbpimagesandvideos.s3.amazonaws.com/policeforce-old.png',NULL,NULL,NULL,NULL,359,'2022-12-12 09:31:25',0,'2022-12-19 13:15:45'),(21,57,'Victim','asdasd','St Pancras Station, Euston Road, London, UK','seer',NULL,'Waterloo Station, London, UK',NULL,NULL,'(222) 222-2222','ma@gmail.com','errr',NULL,'2022-12-18','ad','male','ser21321','23','11','23','Brown','Blond Hair','https://bbpimagesandvideos.s3.amazonaws.com/policeforce-old.png',NULL,NULL,NULL,NULL,359,'2022-12-12 10:22:22',0,'2022-12-19 13:15:46'),(22,58,'Suspect','a','1800 Orleans Street, Baltimore, MD, USA','',NULL,'1201 Congress Street, Houston, TX, USA',NULL,NULL,'(999) 999-9999','aa@mgail.com','asdfg',NULL,'2022-12-16','asdfgh','','swdfgawsdfgsdfg','7','22','45','Hazel','Red Hair','https://bbpimagesandvideos.s3.amazonaws.com/a10-cdffe80ff3c89fe87f34cecbc6a92b04.jpg',NULL,NULL,NULL,NULL,359,'2022-12-12 14:39:24',0,'2022-12-12 14:39:25'),(23,58,'Victim','sdfg','120-55 Queens Boulevard, Queens, NY, USA','sdfg',NULL,'180 Strand, London, UK',NULL,NULL,'(444) 444-4444','aw@fmail.com','asdfg',NULL,'2022-12-28','asdfg','female','sdf','45','26','45','Red','Red Hair','https://bbpimagesandvideos.s3.amazonaws.com/a9-4d44c625f228bf9c8155fa6bacd62a70.jpg',NULL,NULL,NULL,NULL,359,'2022-12-12 14:39:59',0,'2022-12-12 14:39:59'),(24,59,'Unknown','Unknown','','',NULL,'',NULL,NULL,'','','',NULL,'','','female','','','57','165','Brown','Blond Hair','https://bbpimagesandvideos.s3.amazonaws.com/1560046718049-c3f1bc55c1d72302e392c5c014386465.jpeg',NULL,NULL,NULL,NULL,369,'2022-12-12 15:42:47',0,'2022-12-12 15:42:48'),(25,59,'Suspect','Carl Brown','5213 Peachtree Industrial Boulevard, Chamblee, GA, USA','',NULL,'',NULL,NULL,'','','',NULL,'','','male','','','510','180','Blue','Blond Hair',NULL,NULL,NULL,NULL,NULL,369,'2022-12-12 15:44:33',0,'2022-12-12 15:44:33'),(26,54,'Suspect','dfg','','',NULL,'',NULL,NULL,'','dfg','',NULL,'','','','','','','','','',NULL,NULL,NULL,NULL,NULL,540969,'2022-12-15 11:26:04',0,'2022-12-15 11:26:04'),(27,61,'Suspect','manu mathapathi','60 Feet Road, Muslim Nagar, Matunga Labour Camp, Dharavi, Mumbai, Maharashtra, India','Karnataka',NULL,'Dubai - United Arab Emirates',NULL,NULL,'(918) 123-4161','manus@gmail.com',' Employer',NULL,'2022-12-22','Bellary','male','License Number','23','611','453','Gray','Red Hair','https://bbpimagesandvideos.s3.amazonaws.com/policeforce-old.png',NULL,NULL,NULL,NULL,540969,'2022-12-15 13:04:00',0,'2022-12-19 13:15:47'),(28,61,'Witness',' Full Name','Quito, Ecuador','dedsv',NULL,'Wroc?aw, Poland',NULL,NULL,'(918) 123-4161','manus@gmail.com',' Employer',NULL,'2022-12-21','Bellary','male','License Number','33','711','655','Gray','Red Hair','https://bbpimagesandvideos.s3.amazonaws.com/policeforce-old.png',NULL,NULL,NULL,NULL,540969,'2022-12-15 13:05:06',0,'2022-12-19 13:15:48'),(29,62,'Victim','t134','Waterloo Station, London, UK','sss',NULL,'Rotterdam, Netherlands',NULL,NULL,'(888) 888-8888','t@gmail.com','r123',NULL,'2022-12-25','Black or African American','male','345','23','14','23','Red','Brown Hair','https://bbpimagesandvideos.s3.amazonaws.com/chekk-371728c186d8dd979218766564762eec.png',NULL,NULL,NULL,NULL,359,'2022-12-19 12:20:01',359,'2022-12-19 12:20:28'),(30,63,'Victim','Test Tester','5200 Peachtree Industrial Boulevard, Norcross, GA, USA','',NULL,'',NULL,NULL,'(555) 555-5555','test@gmail.com','',NULL,'','Black or African American','female','','','','','','',NULL,NULL,NULL,NULL,NULL,369,'2022-12-19 15:21:58',0,'2022-12-19 15:21:58'),(31,50,'Witness','tesst','St Pancras Station, Euston Road, London, UK','ssss',NULL,'Eiffel Tower, Avenue Anatole France, Paris, France',NULL,NULL,'(222) 222-2222','saadasd','eeterwe',NULL,'2022-12-24','Black or African American','male','24234234','23','25','23','Amber','Black Hair','https://bbpimagesandvideos.s3.amazonaws.com/pexels-photo-2379004-e9e46f2a7272ea5a5e86141c455a8ab0.jpeg',NULL,NULL,NULL,NULL,540969,'2022-12-20 08:20:06',0,'2022-12-20 08:20:06'),(32,63,'Witness','df','DSF, Dhaka, Bangladesh','sdf',NULL,'SDF Building, GP Block, Sector V, Bidhannagar, Kolkata, West Bengal, India',NULL,NULL,'(918) 123-4161','sdf','sdf',NULL,'','White','male','sdf','32','','34','Red','Red Hair',NULL,NULL,NULL,NULL,NULL,540969,'2022-12-20 09:10:16',0,'2022-12-20 09:10:16'),(33,50,'Suspect','mandorty','SSE Arena, Queens Quay, Belfast, UK','ssds',NULL,'Eiffel Tower, Avenue Anatole France, Paris, France',NULL,NULL,'(222) 222-2222','test@gmail.com','asdd',NULL,'2022-12-31','American Indian or Alaska Native','female','sd','23','36','23','Brown','Gray and White Hair',NULL,NULL,NULL,NULL,NULL,540969,'2022-12-20 11:20:15',0,'2022-12-20 11:20:15'),(34,50,'Wanted/Fugitive','test','Essen, Germany','seee',NULL,'St Pancras Station, Euston Road, London, UK',NULL,NULL,'(222) 222-2222','sed@gmail.com','aw23sas',NULL,'2022-12-24','Black or African American','male','2222','45','21','23','Amber','Brown Hair','https://bbpimagesandvideos.s3.amazonaws.com/Manikandan-98da68aded448faac1d22b98d734aa04.jpg',NULL,NULL,NULL,NULL,540969,'2022-12-20 12:04:32',540969,'2022-12-20 12:06:51'),(35,50,'Wanted/Fugitive','checking','Wroc?aw, Poland','asd',NULL,'Victoria Station, London, UK',NULL,NULL,'(444) 444-4444','te@gmail.com','sssd',NULL,'2022-12-31','Black or African American','male','333dd','21','25','23','Red','Gray and White Hair','https://bbpimagesandvideos.s3.amazonaws.com/download2-ed410072d9f029c7948e994e6e40e176.jpg',NULL,NULL,NULL,NULL,540969,'2022-12-20 12:19:08',0,'2022-12-20 12:19:08'),(36,52,'Suspect','sdfgdfg','Golden Gate Bridge, Golden Gate Bridge, San Francisco, CA, USA','ygbbcvbcvb',NULL,'GHJ Suite, Jalan Tanah Abang III, RT.2/RW.3, South Petojo, Central Jakarta City, Jakarta, Indonesia',NULL,NULL,'(918) 123-4161','manu@gmail.com','hjkjffd',NULL,'2022-12-13','Black or African American','male','hjkhjk','43','511','43','Blue','Auburn Hair','https://bbpimagesandvideos.s3.amazonaws.com/download-cb9f355123501080e9e0100a12195a32.jfif',NULL,NULL,NULL,NULL,540969,'2022-12-26 14:22:20',0,'2022-12-26 14:22:21'),(37,64,'Suspect','John Doe','','',NULL,'',NULL,NULL,'(777) 777-9876','','',NULL,'','White','male','','30','54','160','Hazel','Blond Hair',NULL,NULL,NULL,NULL,NULL,369,'2023-01-02 15:42:21',0,'2023-01-02 15:42:21'),(38,67,'Suspect','','','',NULL,'',NULL,NULL,'','','',NULL,'','','male','','30','62','215','Blue','Blond Hair',NULL,NULL,NULL,NULL,NULL,365,'2023-01-09 16:37:45',0,'2023-01-09 16:37:45'),(39,71,'Victim','asdsa','123 William Street, New York, NY, USA','sadas',NULL,'123 William Street, New York, NY, USA',NULL,NULL,'(123) 123-1231','masdni@gmail.com','asdasa',NULL,'2023-03-12','White','male','dasdasqw','23','13','23','Amber','Black Hair',NULL,NULL,NULL,NULL,NULL,682,'2023-03-10 12:32:28',0,'2023-03-10 12:32:28'),(40,74,'Suspect','asda','1 Utama Shopping Centre, Lebuh Bandar Utama, Bandar Utama, Petaling Jaya, Selangor, Malaysia','sad',NULL,'1 Utama Shopping Centre, Lebuh Bandar Utama, Bandar Utama, Petaling Jaya, Selangor, Malaysia',NULL,NULL,'(123) 123-1231','asdad','sdasd',NULL,'2023-04-23','White','other','aadasd','23','22','23','Amber','Black Hair','https://bbpimagesandvideos.s3.amazonaws.com/1560046718049-3f0d9d30ea3a83e0364726bc34e30f3e-bdab077839a840b6016309306207eb01.jpeg',NULL,NULL,NULL,NULL,789,'2023-04-25 10:43:56',0,'2023-04-25 10:43:56'),(41,96,'Suspect','ten vic','150 East 42nd Street, New York, NY, USA','Karnataka',NULL,'150 55th Street, Brooklyn, NY, USA',NULL,NULL,'(809) 512-9206','ten@gmail.com','asdfg',NULL,'2023-05-10','Black or African American','male','asdf','25','21','33','Blue','Auburn Hair','https://bbpimagesandvideos.s3.amazonaws.com/a6-48704758a227734261f07e56c88fab6d.jpg',NULL,NULL,NULL,NULL,446,'2023-05-01 12:07:10',0,'2023-05-01 12:07:11'),(42,98,'Suspect','Richard D. Bryant','709 Feldwood Ln, McDonough, GA, USA','',NULL,'',NULL,NULL,'(678) 629-4416','richardbryant6811@yahoo.com','',NULL,'','','male','','','','','','',NULL,NULL,NULL,NULL,NULL,743,'2023-05-01 14:15:06',0,'2023-05-01 14:15:06'),(43,179,'Suspect','Richard D. Bryant','709 Feldwood Lane, McDonough, GA, USA','',NULL,'',NULL,NULL,'(678) 629-4416','','',NULL,'','','male','','','','','','',NULL,NULL,NULL,NULL,NULL,743,'2023-05-08 14:16:22',0,'2023-05-08 14:16:22'),(44,194,'Suspect','','','',NULL,'',NULL,NULL,'','','',NULL,'','Black or African American','male','','20','6','180','','',NULL,NULL,NULL,NULL,NULL,743,'2023-05-19 13:57:17',0,'2023-05-19 13:57:17'),(45,210,'Victim','asdasd','12 Apostles, Victoria, Australia','adsa',NULL,'Australia',NULL,NULL,'(123) 123-1231','asdasd','asdasd',NULL,'2023-07-02','White','male','1123123','12','13','12','Hazel','Black Hair','https://bbpimagesandvideos.s3.amazonaws.com/test%20%282%29-4706ccfc804a9f3f665ebbdc9d6ea752.jpeg',NULL,NULL,NULL,NULL,789,'2023-06-14 06:56:38',0,'2023-06-14 06:56:38'),(46,210,'Suspect','assdsad','Asadas Grill, West Canyon Ridge Drive, Austin, TX, USA','sasdasdaa',NULL,'asdasd, Narang Rd, Ayyappa Nagar, Jafar Nagar, Gorewada, Nagpur, Maharashtra, India',NULL,NULL,'(123) 121-2123','adasd','adasdas',NULL,'2023-06-25','White','female','asdas','21','4','-1213','Amber','',NULL,NULL,NULL,NULL,NULL,789,'2023-06-14 09:16:05',0,'2023-06-14 09:16:05'),(47,210,'Victim','asdasdas','1 Utama Shopping Centre, Lebuh Bandar Utama, Bandar Utama, Petaling Jaya, Selangor, Malaysia','asdas21',NULL,'1 Utama Shopping Centre, Lebuh Bandar Utama, Bandar Utama, Petaling Jaya, Selangor, Malaysia',NULL,NULL,'(123) 231-2312','sdasdas@gad.com','123123sad',NULL,'2023-06-10','White','male','asd123','21','12','21','Red','Blond Hair','https://bbpimagesandvideos.s3.amazonaws.com/test-1c97ec0053081cf7b374d46ea4bc5d8e.jpeg',NULL,NULL,NULL,NULL,789,'2023-06-15 15:16:42',0,'2023-06-15 15:16:42'),(48,300,'Victim','zxc','123 Farm, Highland Springs Avenue, Beaumont, CA, USA','scxz',NULL,'123 Farm, Highland Springs Avenue, Beaumont, CA, USA',NULL,NULL,'(234) 234-2342','mani.zni2','zxcxc',NULL,'','Black or African American','female','czxzccx','23','','23','Blue','Black Hair','https://bbpimagesandvideos.s3.amazonaws.com/test%20%282%29-439db338040e550069e21d32addbadbb.jpeg',NULL,NULL,NULL,NULL,540969,'2023-07-26 10:45:23',0,'2023-07-26 10:45:24'),(49,336,'Victim','Business qqq','','New York',NULL,'11 Howard, Howard Street, New York, NY, USA',NULL,NULL,'(011) 111-1111','manmathayya.m@ittstar.com','asdsf',NULL,'2023-08-24','Black or African American','male','fsdfsdfsdf','12','611','23','Red','Red Hair','https://bbpimagesandvideos.s3.amazonaws.com/saikumar-162725818a695f4d109cbd6c64f5117f.png',NULL,NULL,NULL,NULL,540969,'2023-08-17 06:54:19',0,'2023-08-17 06:54:19'),(50,340,'Victim','aaaa','150 East 42nd Street, New York, NY, USA','Karnataka',NULL,'1600 Amphitheatre Parkway, Mountain View, CA, USA',NULL,NULL,'(918) 095-1292','harishkadli@gmail.com','33333',NULL,'2023-08-10','Black or African American','male','444444','55','14','44','Hazel','Blond Hair','https://bbpimagesandvideos.s3.amazonaws.com/a9-b901825a851238187c781507b4db0c83.jpg',NULL,NULL,NULL,NULL,789,'2023-08-17 10:03:59',0,'2023-08-17 10:03:59'),(51,406,'Victim','sdasd','12 Bedarra Crescent, Burpengary East QLD, Australia','ssss',NULL,'12 Bedarra Crescent, Burpengary East QLD, Australia',NULL,NULL,'(234) 234-3424','test@gmail.com','asdasdas',NULL,'2024-01-07','White','male','1231232','23','21','23','Amber','Brown Hair','https://bbpimagesandvideos.s3.amazonaws.com/Fleetronix-Images-62078c668a4a91325ec3d4d4019ac0c5.png',NULL,NULL,NULL,NULL,968,'2024-01-03 13:34:34',968,'2024-01-03 13:34:50'),(52,408,'Witness','sdf','150 Nexus Avenue, Brampton, ON, Canada','edf',NULL,'',NULL,NULL,'','','sdf',NULL,'','','','ef','','','','','',NULL,NULL,NULL,NULL,NULL,968,'2024-01-04 08:25:28',0,'2024-01-04 08:25:28'),(53,409,'Wanted/Fugitive','aaa','150 East 58th Street, New York, NY, USA','43234r',NULL,'1707 Blairs Bridge Road, Lithia Springs, GA, USA',NULL,NULL,'(555) 555-5555','gm@.vom','bb',NULL,'2024-01-02','Black or African American','male','4','55','','34','Amber','Blond Hair','https://bbpimagesandvideos.s3.amazonaws.com/a3-496266f4d24b9b549006e8411bdbe336.jpg',NULL,NULL,NULL,NULL,968,'2024-01-04 10:27:43',0,'2024-01-04 10:27:44'),(54,411,'Suspect','Manu','Indianapolis, IN, USA','Indiana',NULL,'Indianapolis, IN, USA',NULL,NULL,'(816) 206-9746','','Cococola',NULL,'','','male','293993939','22','','','','',NULL,NULL,NULL,NULL,NULL,789,'2024-01-19 11:30:49',0,'2024-01-19 11:30:49'),(55,424,'Victim','Test 2','Street, UK','alaska',NULL,'Streetsboro, OH, USA',NULL,NULL,'','','Test',NULL,'2020-08-20','Asian','male','223232323','','','','Blue','','https://bbpimagesandvideos.s3.amazonaws.com/bbp-c793841797e619079cea80e0c868c28e.avif',NULL,NULL,NULL,NULL,680,'2024-02-28 11:09:12',0,'2024-02-28 11:09:13'),(56,435,'Suspect','test','','',NULL,'',NULL,NULL,'','','',NULL,'','','','','','','','','',NULL,NULL,NULL,NULL,NULL,682,'2024-03-01 15:03:45',0,'2024-03-01 15:03:45'),(57,72,'Suspect','','','',NULL,'',NULL,NULL,'','','',NULL,'','','','','','','','','',NULL,NULL,NULL,NULL,NULL,682,'2024-03-01 15:09:39',0,'2024-03-01 15:09:39'),(58,450,'Victim','','','',NULL,'',NULL,NULL,'','','',NULL,'','','','','','','','','',NULL,NULL,NULL,NULL,NULL,789,'2024-03-25 10:40:33',0,'2024-03-25 10:40:33'),(59,451,'Witness','a','150 55th Street, Brooklyn, NY, USA','q',NULL,'1902 Nightclub, East Commerce Street, San Antonio, TX, USA',NULL,NULL,'(999) 999-9999','a@gmail.com','b',NULL,'2024-02-27','Black or African American','male','c','31','5','55','Blue','Auburn Hair',NULL,NULL,NULL,NULL,NULL,607,'2024-03-25 11:34:46',0,'2024-03-25 11:34:46'),(60,452,'Wanted/Fugitive','aa','1601 East 6th Street, Los Angeles, CA, USA','sds',NULL,'1801 West Taylor Street, Chicago, IL, USA',NULL,NULL,'(333) 333-3333','ddd@gmail.com','bsdf',NULL,'2024-03-06','','male','23123453','44','5','55','Red','Gray and White Hair',NULL,NULL,NULL,NULL,NULL,607,'2024-03-25 11:44:08',0,'2024-03-25 11:44:08'),(61,453,'Wanted/Fugitive','','','',NULL,'',NULL,NULL,'','','',NULL,'','','','','','','','','',NULL,NULL,NULL,NULL,NULL,789,'2024-03-25 11:48:27',0,'2024-03-25 11:48:27'),(62,454,'Witness','admin admin','MG Road, Yellappa Chetty Layout, Jogupalya, Bengaluru, Karnataka, India','Karnataka',NULL,'',NULL,NULL,'(012) 345-6789','admin@gmail.com','',NULL,'','','male','','','NaN','','','',NULL,NULL,NULL,NULL,NULL,650,'2024-03-25 15:20:33',650,'2024-03-25 15:21:24'),(63,535,'Suspect','Srinivasa YR','Yelagalavadi, Karnataka, India','Karnataka',NULL,'Kunigal Taluk Office, Kunigal, Karnataka, India',NULL,NULL,'(093) 532-9183','srinivasyr2000@gmail.com','33341121',NULL,'2024-10-15','','male','23123123','21','22','21','Amber','Black Hair','https://bbpimagesandvideos.s3.amazonaws.com/close-up-man-trying-break-into-car_23-2149133092-30408cb0086032b71916602e5f5bc727.jpg',NULL,NULL,NULL,NULL,789,'2024-10-15 07:27:29',0,'2024-10-15 07:27:29');

--
-- Table structure for table `crime_stopper_property`
--

CREATE TABLE `crime_stopper_property` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `crimeId` int(11) NOT NULL DEFAULT '0',
  `propertyType` varchar(100) DEFAULT NULL,
  `brand` varchar(100) DEFAULT NULL,
  `howMany` varchar(100) DEFAULT NULL,
  `marketValue` varchar(100) DEFAULT NULL,
  `propertyDescription` text,
  `image1` varchar(500) DEFAULT NULL,
  `image2` varchar(500) DEFAULT NULL,
  `image3` varchar(500) DEFAULT NULL,
  `image4` varchar(500) DEFAULT NULL,
  `image5` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `crime_stopper_property`
--

INSERT INTO `crime_stopper_property` VALUES (1,2,'a','b','c','d','e','https://bbpimagesandvideos.s3.amazonaws.com/2-54853f3cb88c8b6e5650575226a1c5ea.jpg','https://bbpimagesandvideos.s3.amazonaws.com/a1-98749738bf79746425c4d0e770fae264.jpg','https://bbpimagesandvideos.s3.amazonaws.com/a2-9f6fd66b02bed74fecccbf5905520d85.jpg','https://bbpimagesandvideos.s3.amazonaws.com/a3-554e40ba3ad463f22280084005e9b128.jpg','https://bbpimagesandvideos.s3.amazonaws.com/a4-9033093dd4e8a4f41704daaa9fda98d4.jpg'),(2,3,'a111','b111','c111','d111','e111','https://bbpimagesandvideos.s3.amazonaws.com/a5-bf78ad27d9833d786d8257f84dba4eb1.jpg','https://bbpimagesandvideos.s3.amazonaws.com/a6-f2285a750fee3de14262be99ca37f90e.jpg','https://bbpimagesandvideos.s3.amazonaws.com/a2-68c019c23258ae21350fd408904dc385.jpg',NULL,NULL),(3,4,'a','b','c','d','e','https://bbpimagesandvideos.s3.amazonaws.com/2-a72dd765087b62b39bb682655c513133.jpg','https://bbpimagesandvideos.s3.amazonaws.com/a1-6cd64b2af643b46034af5a3feb5a4200.jpg','https://bbpimagesandvideos.s3.amazonaws.com/a2-cd247e1f714cbc0e6ea29c47be77e244.jpg','https://bbpimagesandvideos.s3.amazonaws.com/a10-1183b92b2a54f8853131b13936e4c224.jpg',NULL),(4,2,'a','b','c','d','e',NULL,NULL,NULL,NULL,NULL),(5,8,'other','33','33','33','property description','https://bbpimagesandvideos.s3.amazonaws.com/aadhar-e3a4545c67ec8df93aff8379d50fadb4.jpg','https://bbpimagesandvideos.s3.amazonaws.com/download-d8c2b30f2bdb00f82294edc154b0f080.jfif',NULL,NULL,NULL),(6,8,'other','33','33','33','334',NULL,NULL,NULL,NULL,NULL),(7,8,'other','33','33','33','334',NULL,NULL,NULL,NULL,NULL),(8,8,'other','33','33','33','property description',NULL,NULL,NULL,NULL,NULL),(9,42,'merchandise','sdf','3','34','sdfsdf','https://bbpimagesandvideos.s3.amazonaws.com/84770626861e18422c4fbc-14bad3cb83cfbdcb0fdd12be18ac85d2.jpg','https://bbpimagesandvideos.s3.amazonaws.com/download-1764781297cdc25b642d11f7c7a1ed9b.jfif',NULL,NULL,NULL),(10,42,'merchandise','sdf','3','34','sdfsdf','https://bbpimagesandvideos.s3.amazonaws.com/84770626861e18422c4fbc-3d4fb88a03e689f5bad859b2fdb3b8ea.jpg','https://bbpimagesandvideos.s3.amazonaws.com/download-d511c26151ca6a5204517ac59f5fdd05.jfif',NULL,NULL,NULL),(11,45,'merchandise','Samsung Watch','1','400.00','Order a Samsung Watch from Amazon.','https://bbpimagesandvideos.s3.amazonaws.com/icomfor%20wi-fi-798127daa3281cfcf60e0003d4856793.png',NULL,NULL,NULL,NULL),(12,45,'merchandise','Samsung Watch','1','400.00','Order a Samsung Watch from Amazon.','https://bbpimagesandvideos.s3.amazonaws.com/icomfor%20wi-fi-0b56c45a196982dafaadd8638ca8bfdf.png',NULL,NULL,NULL,NULL),(13,45,'merchandise','Samsung Watch','1','400.00','Order a Samsung Watch from Amazon.','https://bbpimagesandvideos.s3.amazonaws.com/icomfor%20wi-fi-0933caabea4e038c86cf8f74143e99ec.png',NULL,NULL,NULL,NULL),(14,45,'merchandise','Samsung Watch','1','400.00','Order a Samsung Watch from Amazon.','https://bbpimagesandvideos.s3.amazonaws.com/icomfor%20wi-fi-9b9688d4faf49d0176c3f41bb852ae76.png',NULL,NULL,NULL,NULL),(15,45,'merchandise','Samsung Watch','1','400.00','Order a Samsung Watch from Amazon.','https://bbpimagesandvideos.s3.amazonaws.com/icomfor%20wi-fi-36625c5d06986f28d3cb85ac69c4d2ab.png',NULL,NULL,NULL,NULL),(16,45,'merchandise','Samsung Watch','1','400.00','Order a Samsung Watch from Amazon.','https://bbpimagesandvideos.s3.amazonaws.com/icomfor%20wi-fi-cd9959335daf1e3ffeba32a806fb6e3c.png',NULL,NULL,NULL,NULL),(17,46,'consumable goods','dfgh','3','554','dgdfg','https://bbpimagesandvideos.s3.amazonaws.com/84770626861e18422c4fbc-06c2b2aa0727656b7f8703f471e13a60.jpg',NULL,NULL,NULL,NULL),(18,46,'consumable goods','dfgh','3','554','dgdfg','https://bbpimagesandvideos.s3.amazonaws.com/84770626861e18422c4fbc-20fc2cc0356bf9df6624ee73daf89eca.jpg',NULL,NULL,NULL,NULL),(19,47,'consumable goods','qqq','1','333','sfsdfsd','https://bbpimagesandvideos.s3.amazonaws.com/84770626861e18422c4fbc-9a0c3d4c8cc0fda240842c6543b5f6f5.jpg',NULL,NULL,NULL,NULL),(20,47,'consumable goods','qqq','1','333','sfsdfsd','https://bbpimagesandvideos.s3.amazonaws.com/84770626861e18422c4fbc-7e0489a656636f495f07d1930580a153.jpg',NULL,NULL,NULL,NULL),(21,48,'consumable goods','sdf','2','34','sdfsdf','https://bbpimagesandvideos.s3.amazonaws.com/84770626861e18422c4fbc-0b66f9e3ad26ee5ba3e0b12932e0ca39.jpg',NULL,NULL,NULL,NULL),(22,21,'merchandise','sdf','3','33','sdf','https://bbpimagesandvideos.s3.amazonaws.com/84770626861e18422c4fbc-c7fb4bb44e3f952e6501ea5f20d1188d.jpg',NULL,NULL,NULL,NULL),(23,20,'miscellaneous','gda','43','33','sdf','https://bbpimagesandvideos.s3.amazonaws.com/84770626861e18422c4fbc-1c241408d362d83824f4b38b5afb4a88.jpg',NULL,NULL,NULL,NULL),(24,19,'consumable goods','adasd','3','43','sdf','https://bbpimagesandvideos.s3.amazonaws.com/84770626861e18422c4fbc-0b881f08dcab3a4e27ef467d716eadea.jpg',NULL,NULL,NULL,NULL),(25,18,'merchandise','sdf','34','43','sdf','https://bbpimagesandvideos.s3.amazonaws.com/84770626861e18422c4fbc-7cbeec4cb27c3abbf4724ca562404a5c.jpg','https://bbpimagesandvideos.s3.amazonaws.com/84770626861e18422c4fbc-c889ce332b8e0ddd9c110e8db6db817d.jpg',NULL,NULL,NULL),(26,18,'merchandise','sdf','34','43','sdf','https://bbpimagesandvideos.s3.amazonaws.com/84770626861e18422c4fbc-12277459551f9f5f1e4cc7ddd1a554d5.jpg',NULL,NULL,NULL,NULL),(27,99,'a','b','c','d','e',NULL,NULL,NULL,NULL,NULL),(28,99,'a','b','c','d','e','https://bbpimagesandvideos.s3.amazonaws.com/2-b12abd850c8a773c220e19f9f6e9c2d9.jpg','https://bbpimagesandvideos.s3.amazonaws.com/a1-90f3633841cafaf7201a2b299a205f0e.jpg',NULL,NULL,NULL),(29,99,'a','b','c','d','e','https://bbpimagesandvideos.s3.amazonaws.com/2-ac3c49e2fd029dd3422b0072c32aa870.jpg','https://bbpimagesandvideos.s3.amazonaws.com/a1-db077eb0ef16fcd9a702da1240e279f3.jpg','https://bbpimagesandvideos.s3.amazonaws.com/a4-b18a4ef8ab9b6883b7a34a579378a4ca.jpg',NULL,NULL),(30,99,'a111','b111','c111','d111','e111','https://bbpimagesandvideos.s3.amazonaws.com/a10-74cb13eb29f04462978bc39f20f04faa.jpg','https://bbpimagesandvideos.s3.amazonaws.com/a10-ad2e5032232c35d78a0803c1b6986388.jpg','https://bbpimagesandvideos.s3.amazonaws.com/2-0f87e8e3fa9a1887c5837484c6864651.jpg','https://bbpimagesandvideos.s3.amazonaws.com/a3-f5846dafd989b9bf82f0f197027278d9.jpg','https://bbpimagesandvideos.s3.amazonaws.com/a10-775a85b4b3deaa47af8d6900f837a440.jpg'),(31,41,'merchandise','sdfsd','34','43','sddfdsf','https://bbpimagesandvideos.s3.amazonaws.com/84770626861e18422c4fbc-68ef981d7599682a76903070edf4aab7.jpg',NULL,NULL,NULL,NULL),(32,14,'consumable goods','sdf','32','23','asda','https://bbpimagesandvideos.s3.amazonaws.com/download-fc8d89bbe37fa2467a637de2820b7ed7.jfif',NULL,NULL,NULL,NULL),(33,57,'merchandise','asees234','2','3344444','asdadasd','https://bbpimagesandvideos.s3.amazonaws.com/MicrosoftTeams-image-576cceee953b031ca2fc5f9e8389caf8.png','https://bbpimagesandvideos.s3.amazonaws.com/pexels-photo-1516680-2d21dabea4fa7a9e81f59c60be6b4c66.jpeg',NULL,NULL,NULL),(34,58,'consumable goods','sdfgn','2','56','dfghjkjhgfdsdfghjkjhgfdsdfghjk','https://bbpimagesandvideos.s3.amazonaws.com/a8-0c49c3de28e561325d9841210203239e.jpg','https://bbpimagesandvideos.s3.amazonaws.com/a9-b3d98d2d759feaeb528f0fed0318e97b.jpg',NULL,NULL,NULL),(35,59,'merchandise','Galaxy 5 Watch, Computer','1','1099.00','Samsung Galaxy 5 watch, Dell Computer','https://bbpimagesandvideos.s3.amazonaws.com/61396fe0-2493-11ed-9ffd-254410c436db-d99b032dfd7aec0e6d971df803f9b1fc.jpeg','https://bbpimagesandvideos.s3.amazonaws.com/Weed-f2ddc07dc55cce117feff6ab344e3954.jpg',NULL,NULL,NULL),(36,56,'merchandise','tecss','23222','233234','testing','https://bbpimagesandvideos.s3.amazonaws.com/Manikandan-ef07363cecd9b2efb7aa67fd41cca99a.jpg','https://bbpimagesandvideos.s3.amazonaws.com/download3-b4ce718bfac482aec3ff525b90d072ec.jpg','https://bbpimagesandvideos.s3.amazonaws.com/download2-adca0dd9716c2bc26dd18fd125b61385.jpg','https://bbpimagesandvideos.s3.amazonaws.com/pexels-photo-2379004-0929f3f2439f26c109be0e874a4da68b.jpeg','https://bbpimagesandvideos.s3.amazonaws.com/download1-5df9f8bc94762cc628808eec5d7968aa.jpg'),(37,56,'merchandise','sd','2','22332','adsad','https://bbpimagesandvideos.s3.amazonaws.com/MicrosoftTeams-image-6be44357f229d98adee61db71c271b49.png','https://bbpimagesandvideos.s3.amazonaws.com/chekk-005f93a7f7dd4ddc8b21ed5e9d7604a3.png',NULL,NULL,NULL),(38,54,'consumable goods','adasd','2','$22,2222','adasdsads',NULL,NULL,NULL,NULL,NULL),(39,61,'merchandise','Brand','34','333','Property Description\r\n','https://bbpimagesandvideos.s3.amazonaws.com/84770626861e18422c4fbc-66891aa6669eab051fff5d1383efe555.jpg','https://bbpimagesandvideos.s3.amazonaws.com/download-0042ed3f4ef5da0b7db1db68311d4291.jfif','https://bbpimagesandvideos.s3.amazonaws.com/84770626861e18422c4fbc-15b67027256f33efb1f4564bf68f0797.jpg','https://bbpimagesandvideos.s3.amazonaws.com/84770626861e18422c4fbc-9a992a43de06f37486abc390efc3d313.jpg',NULL),(40,52,'merchandise','wer','2','$2,3423','asasdsd','https://bbpimagesandvideos.s3.amazonaws.com/MicrosoftTeams-image-2705b81fb99b732f51681d643daba70e.png','https://bbpimagesandvideos.s3.amazonaws.com/chekk-8413524ee335bc2b1df29cb2e1d1d957.png','https://bbpimagesandvideos.s3.amazonaws.com/pexels-photo-1516680-a5f36e42637bf479a9850116efb69b46.jpeg','https://bbpimagesandvideos.s3.amazonaws.com/pexels-photo-2379004-9cee92a23cb05909dc857242782825d8.jpeg','https://bbpimagesandvideos.s3.amazonaws.com/download1-4157a2518a27679357777f01442ef929.jpg'),(41,52,'merchandise','asd','23','$2323','asdsd','https://bbpimagesandvideos.s3.amazonaws.com/checsss-b1379a374e0be33e9e351fb7433bac2c.png','https://bbpimagesandvideos.s3.amazonaws.com/MicrosoftTeams-image-f50c7a0a80f857e065efcee812bbddb2.png','https://bbpimagesandvideos.s3.amazonaws.com/download2-3a2759d033a01fc942014425b710a09a.jpg','https://bbpimagesandvideos.s3.amazonaws.com/pexels-photo-1516680-06d722c31cf1fc4f556fb2ee3d40eda9.jpeg','https://bbpimagesandvideos.s3.amazonaws.com/pexels-photo-2379004-8940e9997fd790a67b1eb35712b7818b.jpeg'),(42,57,'consumable goods','erwer','2','$2,223,3432','adasdsadad','https://bbpimagesandvideos.s3.amazonaws.com/chekk-02d34cf86efae46653afa0a3e1705bc5.png','https://bbpimagesandvideos.s3.amazonaws.com/MicrosoftTeams-image-3379f76a6fc182a30ef271c1ef47765a.png','https://bbpimagesandvideos.s3.amazonaws.com/checsss-5b15f88a239a7f4484bd282682ac8d86.png','https://bbpimagesandvideos.s3.amazonaws.com/download3-fa103c207a21e6456cb7bbe11bf0a765.jpg','https://bbpimagesandvideos.s3.amazonaws.com/checsss-bc5fbc901fbf616a7067468c975e58ac.png'),(43,52,'merchandise','sdd','23','$23','asd',NULL,NULL,NULL,NULL,NULL),(44,52,'miscellaneous','sds','2','$232','asdas',NULL,NULL,NULL,NULL,NULL),(45,52,'consumable goods','as','2','$2323','asdasd','https://bbpimagesandvideos.s3.amazonaws.com/MicrosoftTeams-image-b7d5295fa1bb2dbca9f7d9ca2703a9a3.png','https://bbpimagesandvideos.s3.amazonaws.com/checsss-dfc2369172bd668654c1e101bfaed02e.png',NULL,NULL,NULL),(46,63,'merchandise','Samsung Watch','1','$400.00','Samsung Smart Watch',NULL,NULL,NULL,NULL,NULL),(47,63,'merchandise','Nike Shoes','1','$125.00','Nike Shoes',NULL,NULL,NULL,NULL,NULL),(48,63,'merchandise','Tools - Tire Pressure pump','1','$50.00','Tire Pressure pump',NULL,NULL,NULL,NULL,NULL),(49,50,'consumable goods','22','','$234','dfs',NULL,NULL,NULL,NULL,NULL),(50,50,'merchandise','asds','2','$23','adsed',NULL,NULL,NULL,NULL,NULL),(51,50,'other','2344','23','$2343','asdasd',NULL,NULL,NULL,NULL,NULL),(52,50,'miscellaneous','nwe ','2','$2,3444','adasdd','https://bbpimagesandvideos.s3.amazonaws.com/checked-8c477c3ea1b0ce461c26e8cc456e11f8.png','https://bbpimagesandvideos.s3.amazonaws.com/MicrosoftTeams-image-55c8b18e40ed2fdadb7f262a390956b9.png','https://bbpimagesandvideos.s3.amazonaws.com/uncheck-a2327f88a43ec5a1a972df45972716d1.png','https://bbpimagesandvideos.s3.amazonaws.com/download1-cc2852d9309b8f8fb6217cb14d0016d8.jpg','https://bbpimagesandvideos.s3.amazonaws.com/un-checked-f9406c6e12d6215970a3c48f72990045.png'),(53,50,'other','benx','23','$32,343,4234','adasdasdsa','https://bbpimagesandvideos.s3.amazonaws.com/MicrosoftTeams-image-a69458b201b7246cbb84712db7835153.png','https://bbpimagesandvideos.s3.amazonaws.com/download2-c3c842e1e4bd480f82c63496a7e94061.jpg',NULL,NULL,NULL),(54,50,'consumable goods','12Asss','2','$1,312,312,3213','SA',NULL,NULL,NULL,NULL,NULL),(55,52,'merchandise','dfgfhfg','23','$454','fdgdfgfdg','https://bbpimagesandvideos.s3.amazonaws.com/84770626861e18422c4fbc-7da37e03f378c984f81a292933f595cc.jpg','https://bbpimagesandvideos.s3.amazonaws.com/84770626861e18422c4fbc-52929cd050a770c3c76c5e233dd89a34.jpg',NULL,NULL,NULL),(56,64,'miscellaneous','Necklas','1','$500','Gucci Necklas','https://bbpimagesandvideos.s3.amazonaws.com/Weed-6f84a23d70a42cf2d4d007b04bd6f73c.jpg',NULL,NULL,NULL,NULL),(57,71,'consumable goods','asdasd','2','$222','dasdadd','https://bbpimagesandvideos.s3.amazonaws.com/banner-fe3c3aa324a67f5b0dd9fe3872d0f16d.png',NULL,NULL,NULL,NULL),(58,93,'other','Checking Account','12','$1,133.05','Stolen funds from my account',NULL,NULL,NULL,NULL,NULL),(59,96,'merchandise','asdf','25','$24','123','https://bbpimagesandvideos.s3.amazonaws.com/a1-49a203ee1f208237f9dc6549eaef8888.jpg','https://bbpimagesandvideos.s3.amazonaws.com/a2-93a82700cebe1263436694745a12c515.jpg','https://bbpimagesandvideos.s3.amazonaws.com/a3-ade49791c36a9f0ec3edb5c325f22f1f.jpg','https://bbpimagesandvideos.s3.amazonaws.com/a4-4a39a8a4705ae3cc4141193ebd68f709.jpg','https://bbpimagesandvideos.s3.amazonaws.com/a5-2a8f878f5317c36b89776b965104cb46.jpg'),(60,339,'consumable goods','asdasdasd','12','$1000','zxczxczxc','https://bbpimagesandvideos.s3.amazonaws.com/84770626861e18422c4fbc-514db0839243b0671b4b2b5c508d5bfc.jpg','https://bbpimagesandvideos.s3.amazonaws.com/84770626861e18422c4fbc-1023cf51e34cbd56c305bdbb9dbbae4b.jpg',NULL,NULL,NULL),(61,340,'consumable goods','qwedfgh','5','$500','sdfg','https://bbpimagesandvideos.s3.amazonaws.com/bbp-7c945f6429846a578e2b58512dae797e.png','https://bbpimagesandvideos.s3.amazonaws.com/a3-eee5fb47bc957e0cedbc9aff1fd3cc32.jpg',NULL,NULL,NULL),(62,387,'other','sdfgbn','55','$3,456,7890','sdfghnm','https://bbpimagesandvideos.s3.amazonaws.com/a8-474193758ff4d0ba78ef88ddc5105b21.jpg','https://bbpimagesandvideos.s3.amazonaws.com/a9-83746333d371ed6785318474aa77e695.jpg',NULL,NULL,NULL),(63,340,'consumable goods','qwedfgh','5','$500','sdfg','https://bbpimagesandvideos.s3.amazonaws.com/bbp-7c945f6429846a578e2b58512dae797e.png','https://bbpimagesandvideos.s3.amazonaws.com/a3-eee5fb47bc957e0cedbc9aff1fd3cc32.jpg',NULL,NULL,NULL),(64,392,'consumable goods','adasd','2','$22,2222','adasdsads',NULL,NULL,NULL,NULL,NULL),(65,406,'consumable goods','asdad','0','$0','test','https://bbpimagesandvideos.s3.amazonaws.com/blog2-Cyber-Hygiene_Banner-bd972f630515cd9112ae8c6945e75287.png','https://bbpimagesandvideos.s3.amazonaws.com/blog5-Rise-of-Ransomware_banner-869e984b1ebc79e35220b725a1d547c4.png',NULL,NULL,NULL),(66,409,'miscellaneous','htrew','5','$55','werg','https://bbpimagesandvideos.s3.amazonaws.com/a9-50f98b2bf2911bcb24bd0db3c3b2b5e3.jpg','https://bbpimagesandvideos.s3.amazonaws.com/bbp-aac0ca267dbf1b2311dcbfc9558f461e.png',NULL,NULL,NULL),(67,424,'miscellaneous','','','','','https://bbpimagesandvideos.s3.amazonaws.com/bbp-45ccf762922e3d7c14170c69a15fc79e.avif','https://bbpimagesandvideos.s3.amazonaws.com/images-f40983f9e95d7251a4d69125cc10baa7.jpg',NULL,NULL,NULL),(68,452,'merchandise','asdfv','32','$3454','dfvbfdsdf','https://bbpimagesandvideos.s3.amazonaws.com/QWERGH-faaeddb104151fc212bae891fdd92fff.jpg','https://bbpimagesandvideos.s3.amazonaws.com/abd0288-f1-44db0209cd455ec990147ad6f414c160.jpeg',NULL,NULL,NULL),(69,453,'consumable goods','','','','',NULL,NULL,NULL,NULL,NULL),(70,454,'consumable goods','','9','','',NULL,NULL,NULL,NULL,NULL),(71,535,'consumable goods','asdasd','21','$100','asdasd','https://bbpimagesandvideos.s3.amazonaws.com/house-flat-design_1145-33-68dc4d5dca04a5a7bf6231bca63e66b2.jpg','https://bbpimagesandvideos.s3.amazonaws.com/house-sale-with-sign_23-2148658969-f04807eaf7215d8c61e05fbe96178f1a.avif',NULL,NULL,NULL);

--
-- Table structure for table `crime_stopper_school_related_bullying`
--

CREATE TABLE `crime_stopper_school_related_bullying` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `crimeId` int(11) NOT NULL DEFAULT '0',
  `typeOfbulling` varchar(100) DEFAULT NULL,
  `schoolName` varchar(100) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `state` varchar(100) DEFAULT NULL,
  `whereHappen` varchar(500) DEFAULT NULL,
  `whenHappen` varchar(500) DEFAULT NULL,
  `howManyTimesHappen` varchar(500) DEFAULT NULL,
  `howAware` varchar(500) DEFAULT NULL,
  `involvedPeople` varchar(500) DEFAULT NULL,
  `other` varchar(500) DEFAULT NULL,
  `additionalDetails` varchar(500) DEFAULT NULL,
  `describeWhatHappen` varchar(500) DEFAULT NULL,
  `media` varchar(500) DEFAULT NULL,
  `mediaLink` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `crime_stopper_school_related_bullying`
--

INSERT INTO `crime_stopper_school_related_bullying` VALUES (5,2,'a','b','c','d','e','f','g','h','i','k','l','m','https://bbpimagesandvideos.s3.amazonaws.com/a5-c975652b5cd53c0460184ed2bc317bb3.jpg',NULL),(6,4,'a1','b1','c1','d1','e1','f1','g1','h1','i1','k1','l1','m1','https://bbpimagesandvideos.s3.amazonaws.com/a3-4a9ef72763aeaefc352532802527cafb.jpg',NULL),(7,3,'a1','b1','c1','d1','e1','f1','g1','h1','i1','k1','l1','m1','https://bbpimagesandvideos.s3.amazonaws.com/a6-a173aef1189f3ff1b4a66c4392587d33.jpg',NULL),(8,9,'2','sdf','','Thành ph? H? Chí Minh','school','2022-12-08T10:02','2','sdf','2','sdf','dfsg','dsf',NULL,'sdfsdf'),(9,10,'2','sdf','','','school','2022-12-08T10:02','2','sdf','2','sdf','dfsg','dsf',NULL,NULL),(10,12,'2','sdf','','','school','2022-12-08T10:02','2','sdf','2','sdf','dfsg','dsf',NULL,'sdf'),(17,8,'2','sdfsdf','New Delhi','Delhi','road','2022-12-13T10:12','2','incident','2','other','sdfgsdfsdfsdf','mmmmm','https://bbpimagesandvideos.s3.amazonaws.com/download-80a6aad3e3baf12c14017beafc0d25e6.jfif','bbbbbn'),(18,42,'2','sdf','Frankfurt','Hessen','school','2022-12-15T11:09','3','dfg','4','sdf','fghfgh','fghfgh','https://bbpimagesandvideos.s3.amazonaws.com/84770626861e18422c4fbc-493e4adb2ecc551ee17da331a485d87d.jpg','fghfgh'),(19,18,'2','sdfsdf','Louisville','Kentucky','road','2022-12-14T06:46','3','sdf','4','fsdf','sdf','sdf','https://bbpimagesandvideos.s3.amazonaws.com/download-27b1f56a67f93af904d72fa2d906f490.jfif','sdf'),(20,41,'1','sdf','Warszawa','Mazowieckie','road','2022-12-27T09:08','33','sdf',NULL,'sdf',NULL,'sfsd','https://bbpimagesandvideos.s3.amazonaws.com/84770626861e18422c4fbc-00c76baa581bd4a6c694bdd2ec7dc3fc.jpg','dsf'),(21,52,'school','sdfsdf','Dehradun','Uttarakhand','lockerroom','2022-12-15T10:05','55','student','null','gjhgjhgh','null','kjhkjhkjhkj','https://bbpimagesandvideos.s3.amazonaws.com/84770626861e18422c4fbc-631b4dbd29e1bc870f911299c126040a.jpg','hjkjhjhkjh'),(23,57,'school','vhsss','','England','building','2022-12-12T04:02','2','observed','null','ed','null','adas','https://bbpimagesandvideos.s3.amazonaws.com/pexels-photo-2379004-38364a512e30f1e74e90c621de8e4a4e.jpeg','www.google.com'),(24,58,'online','asdfghj','Mountain View','California','lockerroom','2022-12-16T23:12','3','observed',NULL,NULL,NULL,'aaaaaaaaaaaaaaaaaaaaaaaaaaaaa','https://bbpimagesandvideos.s3.amazonaws.com/a8-9fcb4e67cd3096fa4f3e5d930210d0fb.jpg','aabbbb.com'),(25,59,'school','Central Gwinnett','Lawrenceville','Georgia','afterschool','2022-12-09T14:55','5','directly',NULL,'During Band Practice',NULL,'Kimberly Childs keeps pouring water on my head.',NULL,NULL),(26,61,'other','assdf','Essen','North Rhine-Westphalia','lockerroom','2022-12-09T18:39','33','observed',NULL,'Other',NULL,'Describe what happened, Give as much detail as possible\r\n',NULL,'URL (if applicable)'),(27,68,'school','Peachtree Elementary','Peachtree Corners','Georgia','class','2023-01-09T11:41','2','directly',NULL,'safds',NULL,'adsfsadf',NULL,'asdfsdf'),(28,71,'school','asdasd','Petaling Jaya','Selangor','busstop','2023-03-10T20:48','11','observed','null','asds','null','asdasdad','https://bbpimagesandvideos.s3.amazonaws.com/Event%20Landing%20page-413e4ca1bf8c2f774d2d01615227c045.jpg','asdasd');

--
-- Table structure for table `crime_stopper_school_related_bullying_details`
--

CREATE TABLE `crime_stopper_school_related_bullying_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `crimeId` int(11) NOT NULL DEFAULT '0',
  `name` varchar(100) DEFAULT NULL,
  `grade` varchar(100) DEFAULT NULL,
  `involvement` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `crime_stopper_school_related_bullying_details`
--

INSERT INTO `crime_stopper_school_related_bullying_details` VALUES (1,4,'BBB','B','DONT BBBBB'),(2,4,'dddddd','Aaaaaa','DONTaaaaaaaaaaaaaaaaaaaa KNOW'),(3,4,'DDDD','A+','DONTaaaaaaaaaaaaaaaaaaaabbbbb BBBBB'),(4,4,'AAA','A','DONT KNOW'),(5,2,'BBB','B','DONT BBBBB'),(6,2,'AAA','A','DONT KNOW'),(7,3,'dddddd','Aaaaaa','DONTaaaaaaaaaaaaaaaaaaaa KNOW'),(8,3,'DDDD','A+','DONTaaaaaaaaaaaaaaaaaaaabbbbb BBBBB'),(9,2,'AAA','A','DONT KNOW'),(10,2,'BBB','B','DONT BBBBB'),(16,8,'name2','c','c'),(17,8,'name1','b','a'),(18,42,'sdf','a','b'),(19,42,'sdf','b','d'),(20,42,'fghj','c','c'),(21,42,'j;','b','b'),(22,18,'sdf','d','b'),(23,18,'sdf','c','a'),(24,18,'sdf','d','c'),(25,18,'sdf','a','a');

--
-- Table structure for table `crime_stopper_status_code`
--

CREATE TABLE `crime_stopper_status_code` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `codes` varchar(200) NOT NULL,
  `description` varchar(200) DEFAULT NULL,
  `status` varchar(200) DEFAULT NULL,
  `action` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `crime_stopper_status_code`
--

INSERT INTO `crime_stopper_status_code` VALUES (1,'New',NULL,'Open',NULL),(2,'No Crime','No Crime Committed','Closed',NULL),(3,'Information Only\r\n','No violation, but good information\r\n','Closed\r\n',NULL),(4,'In Custody','All suspects are in custody','Closed',NULL),(5,'Partial Custody','1 or more, but not all suspects in custody','Open',NULL),(6,'Resolved','The case has reached a resolution and resolved','Closed',NULL),(7,'Fowarded','Cases forwarded to another department or agency','Closed','List where forwarded'),(8,'Out of Jurisdiction','Reported to wrong agency','Closed',NULL),(9,'Active','Case is open and being worked','Open',NULL),(10,'Suspect Identified','Suspect matches the description and identified','Open',NULL),(11,'Warrant Issued','Suspect identified and Warrant Issued','Open','Enter Warrant# and upload a copy of the warrant'),(12,'Unidentified Suspect','Suspect has a description, but unidentified','Open',NULL),(13,'Cold Case','Case is stalled and have no leads','Closed',NULL),(14,'Falsified Case','Untruthful case submitted','Closed',NULL);

--
-- Table structure for table `crime_stopper_subcategory`
--

CREATE TABLE `crime_stopper_subcategory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `categoryId` int(11) NOT NULL DEFAULT '0',
  `title` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `crime_stopper_subcategory`
--

INSERT INTO `crime_stopper_subcategory` VALUES (1,1,'Does the suspect sell or use drugs? Or both?'),(2,1,'Type of Drug(s) Involved?'),(3,1,'How are drugs sold? (packaging, quantities, joints, baggies, etc.)'),(4,1,'Where is it being sold? (from vehicle, residence, etc.)'),(5,1,'Give specific details of the drug operation (cooking, producing, growing, packaging, hours of operation,\r\ndescription of how they sell, who they sell to)'),(6,1,'Where does the supply come from? Where are the drugs kept?'),(7,1,'Give details about any weapons, animals, children, prior c1'),(8,2,'What type and quantity'),(9,2,'Describe the weaport(s)'),(10,2,'When and where did you last see the weapon(s)?'),(11,2,'Where exactly is the weapon located?'),(12,2,'Isitloaded? Where is the ammunition kept?'),(13,2,'Are the weapon(s) secured or locked?'),(14,2,'How do you know that the firearms are not registered?'),(15,2,'Does the suspect carry or transport the weapon around?'),(16,2,'Where did the suspect purchase the weapon?'),(17,2,'Does the suspect have any plans to use this weapon?'),(18,2,'Are you aware of any criminal activity this weapon has been used for?'),(19,2,'Does the suspect have any firearm/military training?'),(20,2,'Any other comments?');

--
-- Table structure for table `crime_stopper_vehicle`
--

CREATE TABLE `crime_stopper_vehicle` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `crimeId` int(11) NOT NULL DEFAULT '0',
  `type` varchar(100) DEFAULT NULL,
  `registerOwner` varchar(100) DEFAULT NULL,
  `registerOwnerDescribe` varchar(100) DEFAULT NULL,
  `color` varchar(100) DEFAULT NULL,
  `make` varchar(100) DEFAULT NULL,
  `model` varchar(100) DEFAULT NULL,
  `bodyStyle` varchar(100) DEFAULT NULL,
  `vehicleYear` varchar(100) DEFAULT NULL,
  `licenseNum` varchar(100) DEFAULT NULL,
  `location` varchar(100) DEFAULT NULL,
  `registerYear` varchar(100) DEFAULT NULL,
  `operator` varchar(100) DEFAULT NULL,
  `descriptions` text,
  `damage` varchar(100) DEFAULT NULL,
  `vinNum` varchar(100) DEFAULT NULL,
  `hulNum` varchar(100) DEFAULT NULL,
  `registerExpYear` varchar(100) DEFAULT NULL,
  `picture` varchar(500) DEFAULT NULL,
  `createdBy` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedBy` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `crime_stopper_vehicle`
--

INSERT INTO `crime_stopper_vehicle` VALUES (1,2,'a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','https://bbpimagesandvideos.s3.amazonaws.com/a2-cdabc4a6833198b3815bb41c29fe4aa2.jpg','2022-12-02 10:38:32','2022-12-02 10:38:34'),(3,2,'aaaaaa','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','https://bbpimagesandvideos.s3.amazonaws.com/a2-90ff506e3690f4a1c494ea671ea96e43.jpg','2022-12-02 11:07:51','2022-12-02 11:07:53'),(4,2,'aaaaaa','b','c','d','e','f','g','h','i','j','k','l',NULL,'n',NULL,NULL,NULL,NULL,'2022-12-02 11:25:55','2022-12-02 11:25:55'),(5,2,'aa','baaaa','caaaa','daa','eaa','fa','ga','h','i','j','k','l','m','n','o','p','q',NULL,'2022-12-05 07:40:20','2022-12-05 09:02:32'),(7,33,'Off Road Vehicle','missingperson','reasd','asd','sed','ded','asdds','1222','123Sess','St Pancras Station, Euston Road, London, UK','1233','missingperson',NULL,'asdasd','we2343','undefined','undefined',NULL,'2022-12-05 13:05:57','2022-12-05 13:05:57'),(8,33,'Off Road Vehicle','missingperson','reasd','asd','sed','ded','asdds','1222','w345','St Pancras Station, Euston Road, London, UK','1233','missingperson',NULL,'asdasd','we2343','undefined','undefined',NULL,'2022-12-05 13:08:37','2022-12-05 13:12:35'),(9,42,'Motorcycle/Moped ','missingperson','sdfgbhn','erty','serfg','sdefrgh','sdfgh','2015','werf','USAA Corporate Office, Fredericksburg Road, San Antonio, TX, USA','2006','suspect',NULL,'asdfghjklkjhgfdsasdfghjhwertghjhgfwertghjhgrewq','sdfghj','undefined','undefined',NULL,'2022-12-05 15:25:22','2022-12-05 15:25:22'),(10,59,'Buses','suspect','Sdasdad','black','www45','sed234','sim','2022','se23455','St Pancras Station, Euston Road, London, UK','2001','suspect',NULL,'adasdasdasdasd','12asds','undefined','undefined',NULL,'2022-12-12 10:23:21','2022-12-13 10:52:01'),(11,57,'Watercraft/Boat','suspect','sdas','red','benx','bmu','large','222','undefined','Wroc?aw, Poland','undefined','other',NULL,'ghjhjhjggh','undefined','2343','2022-12-09',NULL,'2022-12-12 10:26:43','2022-12-12 10:26:43'),(12,58,'Motorhome/Camper/RV(Recreational vehicles)','suspect','bbbbb','ertyu','sedrtg','wserf','sdfrgh','2014','ertyu','sdfgh, Block A, Industrial Area, Sector 62, Noida, Uttar Pradesh, India','2022','suspect',NULL,'','sdfghj','undefined','undefined',NULL,'2022-12-12 14:41:03','2022-12-12 14:41:03'),(13,58,'Watercraft/Boat','suspect','asdfgh','dfghjytr','dfghjkjhgf','ghjkl','erftghyjh','2011','undefined','Dubai - United Arab Emirates','undefined','other',NULL,'sdfghjhgfdsdfghjhdsdfghjhgfdsdfghjhgre','undefined','asdfgh','2022-12-08',NULL,'2022-12-12 14:41:25','2022-12-12 14:41:25'),(14,59,'Passenger Car/Automobile Pickup','suspect','','Silver','Accord','Honda','4-door','2007','UGA123','Gwinnett County, GA, USA','','suspect',NULL,'None','','undefined','undefined',NULL,'2022-12-12 15:51:11','2022-12-12 15:51:11'),(15,61,'Buses','missingperson','Register Owner Name','Color(s)','Make','Model','Body Style','2011',' License Number','Venice, Metropolitan City of Venice, Italy','2011','suspect',NULL,'Damage to Vechile\r\n','VIN','undefined','undefined',NULL,'2022-12-15 13:06:24','2022-12-15 13:06:24'),(16,61,'Passenger Car/Automobile Pickup','suspect','Register Owner Name','Color(s)','Make','Model','Body Style','233','License Number','Ewwe longt\'s - Linkes Zentrum Mannheim, Kobellstraße, Mannheim, Germany','233','missingperson',NULL,'Damage to Vechile\r\n','VIN','undefined','undefined',NULL,'2022-12-15 13:07:32','2022-12-15 13:07:32'),(17,62,'Motorcycle/Moped ','suspect','asd','bhgf','rty','benx','ertop','444','23','St Pancras Station, Euston Road, London, UK','232','unknown',NULL,'dasfghfddsda','as33','undefined','undefined',NULL,'2022-12-19 12:21:19','2022-12-19 12:21:32'),(18,63,'Passenger Car/Automobile Pickup','suspect','Unknown','Black','Ram','Dodge','4 door truck','2015','UGA 123','Gwinnett County, GA, USA','2022','suspect',NULL,'Front Right Light is busted','askdfdkjfdslfjd','undefined','undefined',NULL,'2022-12-19 15:24:28','2022-12-19 15:27:31'),(19,64,'Passenger Car/Automobile Pickup','suspect','John Doe','Silver','Accord','Honda','4 Door','2007','UGA 123','Gwinnett County, GA, USA','2022','suspect',NULL,'None','','undefined','undefined',NULL,'2023-01-02 15:43:34','2023-01-02 15:43:34'),(20,67,'Passenger Car/Automobile Pickup','suspect','Unknown','Silver','Accord','Honda','4 Door','2007','AFD 123','Gwinnett County, GA, USA','','suspect',NULL,'Had black rims and smoked front and back lights','','undefined','undefined',NULL,'2023-01-09 16:38:56','2023-01-09 16:38:56'),(21,71,'Buses','suspect','asdas','asdasd','asd','2asdasd','asdad','23','asdasda','122 West Garvey Avenue, Monterey Park, CA, USA','23','suspect',NULL,'asdasdasd','asdsad','undefined','undefined',NULL,'2023-03-10 12:45:35','2023-03-10 12:45:35'),(22,71,'Watercraft/Boat','suspect','dasda','asdasd','adsd','asdsaas','asdasd','234','undefined','1 Utama Shopping Centre, Lebuh Bandar Utama, Bandar Utama, Petaling Jaya, Selangor, Malaysia','undefined','other',NULL,'adasdas','undefined','asdas','2023-03-12',NULL,'2023-03-10 12:46:01','2023-03-10 12:46:01'),(23,96,'Off Road Vehicle','suspect','asdf','wedrf','sdfg','wserf','wer','250','1234','1650 Grand Concourse, The Bronx, NY, USA','453','suspect',NULL,'asddddddddd','asdf','undefined','undefined',NULL,'2023-05-01 12:08:15','2023-05-01 12:08:15'),(24,194,'Passenger Car/Automobile Pickup','suspect','','','Liberty','Jeep','','','','','2015','suspect',NULL,'The vehicle had distinctive decals on the back windshield that read “Cars $500 Down www.GreatCityCar','','undefined','undefined',NULL,'2023-05-19 13:58:48','2023-05-19 13:58:48'),(25,340,'Aircraft','victim','wedfghn','werfgh','fdfg','er','qwefgh','250','asdf','150 East 42nd Street, New York, NY, USA','203','unknown',NULL,'sdfghnjm','55','undefined','undefined',NULL,'2023-08-17 10:04:30','2023-08-17 10:04:30'),(26,406,'Off Road Vehicle','suspect','asdada','asdada','222222','222222','22222','1233','2342343','1123 272 Street, Langley Township, BC, Canada','1213','unknown',NULL,'asdasdasdasd','222222','undefined','undefined',NULL,'2024-01-03 13:41:08','2024-01-03 13:41:26'),(27,409,'Motorhome/Camper/RV(Recreational vehicles)','suspect','grew','dfggfd','sdfghg','ertgredcv','gfwe','2022','sdf','1707 Blairs Bridge Road, Lithia Springs, GA, USA','2011','victim',NULL,'asdfghjhrewertgh','sdfg','undefined','undefined',NULL,'2024-01-04 10:28:09','2024-01-04 10:28:09'),(28,420,'Passenger Car/Automobile Pickup','unknown','','Silver','Rogue','Nissan','','2019','CEC 123','Gwinnett County, GA, USA','','unknown',NULL,'None','','undefined','undefined',NULL,'2024-02-19 14:51:16','2024-02-19 14:51:16'),(29,424,'Motorcycle/Moped ','victim','','','','','','','7889697','','','',NULL,'','','undefined','undefined',NULL,'2024-02-28 11:09:51','2024-02-28 11:09:51'),(30,435,'Motorhome/Camper/RV(Recreational vehicles)','','','','','','','','','','','',NULL,'','','undefined','undefined',NULL,'2024-03-01 15:04:13','2024-03-01 15:04:13'),(31,445,'Motorcycle/Moped ','','','','','','','2008','8787','Vietnam','1998','',NULL,'','','undefined','undefined',NULL,'2024-03-22 10:58:32','2024-03-22 10:59:42'),(32,450,'Motorhome/Camper/RV(Recreational vehicles)','','','','','','','','','','','',NULL,'','','undefined','undefined',NULL,'2024-03-25 10:42:25','2024-03-25 10:42:25'),(33,452,'Passenger Car/Automobile Pickup','suspect','aaaaaaaa','fdsasdf','gggfdsssssss','sdfg','gfdsdf','1987','dfgnfdg','1801 West Taylor Street, Chicago, IL, USA','1985','unknown',NULL,'cccccccc','sdfgvb','undefined','undefined',NULL,'2024-03-25 11:45:01','2024-03-25 11:45:01'),(34,453,'Motorcycle/Moped ','','','','','','','','','','','',NULL,'','','undefined','undefined',NULL,'2024-03-25 11:49:35','2024-03-25 11:49:35'),(35,454,'Off Road Vehicle','','','','','','','','7889697','','','',NULL,'','','undefined','undefined',NULL,'2024-03-25 15:21:52','2024-03-25 15:21:52'),(36,535,'Motorhome/Camper/RV(Recreational vehicles)','unknown','asd','asdasd','asdsa','123123','add','222','123123','11 Howard, Howard Street, New York, NY, USA','1221','unknown',NULL,'asdasd','123123','undefined','undefined',NULL,'2024-10-15 07:28:03','2024-10-15 07:28:03');

--
-- Table structure for table `document_category`
--

CREATE TABLE `document_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `document_category`
--

INSERT INTO `document_category` VALUES (1,'test'),(2,'test1'),(3,'test11'),(4,'welcome'),(5,'demo'),(6,'abc'),(7,'mjhgfk'),(13,'check'),(14,'new Category'),(15,'check other'),(16,'werwerwer'),(17,'Agency owner'),(18,'SignIn/SignUp'),(19,'Getting started'),(20,'Manage profile'),(21,'Roster'),(22,'Community Relationship'),(23,'Account creation/Registration'),(24,'Sign-In');

--
-- Table structure for table `documentation`
--

CREATE TABLE `documentation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `organization` text,
  `categoryId` varchar(11) DEFAULT NULL,
  `topic` longtext,
  `description` longtext,
  `createdAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `documentation`
--

INSERT INTO `documentation` VALUES (9,'supervisor, admin, lawfirm_attorney, news_media, research_firm, business, watchdog_group, police_union','4','System Admin','<h1>Title: The Unsung Heroes of IT: Understanding System Administration</h1>\n<p>In today\'s digital age, the smooth operation of computer systems and networks is essential for the functioning of businesses, organizations, and even our daily lives. Behind the scenes, there is a group of individuals who ensure that these systems run seamlessly, preventing chaos and ensuring data security. These individuals are system administrators, and their role is indispensable in the realm of Information Technology.</p>\n<p></p>\n<h3>System Administration Defined</h3>\n<p>System administration, often abbreviated as SA, is the practice of managing and maintaining computer systems and networks to ensure their availability, reliability, and security. System administrators, commonly known as sysadmins, are the unsung heroes of the IT world. Their work involves the management of hardware, software, and the intricate balance between them.</p>\n<p></p>\n<h3>The Role of a System Administrator</h3>\n<p>The responsibilities of a system administrator are multifaceted. They manage user accounts and permissions, ensuring that authorized personnel have access to necessary resources while keeping unauthorized users at bay. User management may seem straightforward, but it\'s a complex task when dealing with large organizations or complex networks.</p>\n<p></p>\n<p>Sysadmins are also the gatekeepers of security. They are responsible for safeguarding systems and networks from threats like viruses, malware, and cyberattacks. They implement security measures, such as firewalls and intrusion detection systems, and regularly update and patch software to fix vulnerabilities.</p>\n<p></p>\n<p>Routine maintenance is another critical aspect of their role. Sysadmins perform regular maintenance tasks to keep systems running efficiently. This includes updates to operating systems and software, hardware maintenance, and backup and recovery procedures. Their ability to minimize downtime is vital for businesses, as downtime can translate into significant financial losses.</p>\n<p></p>\n<h3>The Challenges and Complexities</h3>\n<p>System administrators face a myriad of challenges. One of the most significant challenges is staying ahead of the ever-evolving landscape of technology. As new hardware and software are developed, sysadmins must adapt and incorporate these changes into their existing systems.</p>\n<p></p>\n<p>Moreover, the threat landscape is constantly changing. The battle against cyber threats is ongoing, and sysadmins must be vigilant in identifying and mitigating security risks. They must be well-versed in best practices and employ an array of tools to protect their systems.</p>\n<p></p>\n<h3>The Unsung Heroes</h3>\n<p>System administrators are often the silent architects of an organization\'s IT infrastructure. Their work largely goes unnoticed when systems are functioning seamlessly. However, their impact becomes profoundly evident when issues arise. They are the ones who work tirelessly, often during off-hours, to restore systems and services, ensuring that businesses continue to operate.</p>\n<p></p>\n<p>Their dedication to documentation is crucial. In a world where knowledge is power, sysadmins maintain logs, document configurations, and record procedures. This ensures that others can pick up where they left off in case of an emergency or a changing of the guard.</p>\n<p></p>\n<h3>Conclusion</h3>\n<p>System administration is a field that requires a unique blend of technical expertise, problem-solving skills, and an unwavering commitment to ensuring the smooth operation of systems and networks. Sysadmins are the backbone of the digital world, and their role is indispensable in the modern IT landscape. As technology continues to advance and threats persist, their significance will only grow. System administrators are indeed the unsung heroes of the IT world, quietly working to keep our digital lives in order. Their dedication and expertise are worthy of our recognition and appreciation.</p>\n','2023-10-26 10:51:07'),(11,'business','4','Overview','<h1>The World of Business: A Dynamic Landscape</h1>\n<h3>Introduction</h3>\n<p>Business, in its myriad forms, is the lifeblood of the global economy. It encompasses an array of activities, from small local enterprises to large multinational corporations. Business plays a fundamental role in shaping society, driving innovation, and providing opportunities for individuals to prosper. This essay explores the dynamic landscape of business, its importance, challenges, and the ever-evolving nature of the corporate world.</p>\n<p></p>\n<h3>I. The Foundations of Business</h3>\n<p>At its core, business is about the exchange of goods and services for value. It is a multifaceted concept that encompasses various functions such as production, marketing, sales, finance, and management. Business activities are conducted by individuals, organizations, and governments to meet the needs and desires of consumers.</p>\n<p></p>\n<h3>II. The Importance of Business</h3>\n<ol>\n<li>Economic Engine: Business is the engine that drives economic growth. It creates jobs, generates income, and contributes to the Gross Domestic Product (GDP) of a country. Without businesses, economies would stagnate.</li>\n<li>Innovation: Businesses are hubs of innovation. They develop new products, services, and technologies that improve our quality of life and solve complex problems. From smartphones to medical advancements, businesses are at the forefront of innovation.</li>\n<li>Wealth Creation: Business provides opportunities for wealth creation. Entrepreneurs and investors can build wealth by taking calculated risks and pursuing opportunities in the market.</li>\n<li>Globalization: The business landscape is increasingly global. Multinational corporations operate across borders, fostering international trade and cultural exchange. This globalization has led to greater interconnectedness and interdependence among nations.</li>\n</ol>\n<p></p>\n<h3>III. The Challenges in Business</h3>\n<ol>\n<li>Competition: Intense competition is a hallmark of the business world. Companies must continually innovate and differentiate themselves to stay ahead.</li>\n<li>Regulation and Compliance: Businesses must navigate complex regulatory environments. Compliance with laws and regulations, from labor laws to environmental standards, is crucial but can be onerous.</li>\n<li>Ethical Dilemmas: Ethical considerations in business are ever-present. Companies must balance profitability with ethical conduct, which can be challenging in a competitive environment.</li>\n<li>Technological Disruption: Rapid technological advancements can disrupt industries and business models. Companies must adapt to stay relevant.</li>\n</ol>\n<p></p>\n<h3>IV. Entrepreneurship</h3>\n<p>Entrepreneurship is a driving force in the business world. Entrepreneurs are individuals who identify opportunities and take calculated risks to create and grow businesses. They are the innovators and problem-solvers of the corporate landscape.</p>\n<p></p>\n<h3>V. The Future of Business</h3>\n<ol>\n<li>The business landscape is continually evolving. Future trends include:</li>\n<li>Sustainability: Businesses are increasingly focusing on sustainable practices to reduce their environmental impact and meet the demands of socially conscious consumers.</li>\n<li>Digital Transformation: The digital revolution continues to transform business operations, from e-commerce to data analytics and automation.</li>\n<li>Remote Work: The COVID-19 pandemic accelerated the adoption of remote work, changing the way businesses operate and structure their workforce.</li>\n</ol>\n<p></p>\n<h3>Conclusion</h3>\n<p>Business is a dynamic and multifaceted field with a profound impact on society. It is a driver of economic growth, innovation, and wealth creation. However, it also faces challenges related to competition, regulation, ethics, and technological disruption. As the business landscape continues to evolve, adaptability and innovation will be key to success. Business is not just about profits; it\'s about shaping the future and making a positive impact on the world.&nbsp;&nbsp;</p>\n','2023-10-26 11:26:24'),(30,'supervisor, lawfirm_attorney','4','new checking','<p></p>\n<img src=\"data:image/jpeg;base64,[encoded data, 100960 characters]\" alt=\"undefined\" style=\"height: auto;width: auto\"/>\n<p></p>\n','2024-01-25 09:28:50'),(31,'watchdog_group,police_union,citizen_review_board','4','checking other','<p></p>\\n<img src=\\\"data:image/jpeg;base64,[encoded data, 100960 characters]\\\" alt=\\\"undefined\\\" style=\\\"height: auto;width: auto\\\"/>\\n<p></p>\\n','2024-01-25 09:29:54'),(34,'watchdog_group','2','DEMO DOC','<p></p>\n<div style=\"text-align:left;\"><img src=\"data:image/jpeg;base64,[encoded data, 8972 characters]\" alt=\"undefined\" style=\"height: auto;width: auto\"/></div>\n<p></p>\n<div style=\"text-align:right;\"><img src=\"data:image/jpeg;base64,[encoded data, 6268 characters]\" alt=\"undefined\" style=\"height: auto;width: auto\"/></div>\n<p></p>\n<div style=\"text-align:left;\"><img src=\"data:image/jpeg;base64,[encoded data, 10972 characters]\" alt=\"undefined\" style=\"height: auto;width: auto\"/></div>\n<p></p>\n\n<p></p>\n<div style=\"text-align:left;\"><img src=\"data:image/jpeg;base64,[encoded data, 8972 characters]\" alt=\"undefined\" style=\"height: auto;width: auto\"/></div>\n<p></p>\n<div style=\"text-align:right;\"><img src=\"data:image/jpeg;base64,[encoded data, 6268 characters]\" alt=\"undefined\" style=\"height: auto;width: auto\"/></div>\n<p></p>\n<div style=\"text-align:left;\"><img src=\"data:image/jpeg;base64,[encoded data, 10972 characters]\" alt=\"undefined\" style=\"height: auto;width: auto\"/></div>\n<p></p>\n\n<p></p>\n<div style=\"text-align:left;\"><img src=\"data:image/jpeg;base64,[encoded data, 8972 characters]\" alt=\"undefined\" style=\"height: auto;width: auto\"/></div>\n<p></p>\n<div style=\"text-align:right;\"><img src=\"data:image/jpeg;base64,[encoded data, 6268 characters]\" alt=\"undefined\" style=\"height: auto;width: auto\"/></div>\n<p></p>\n<div style=\"text-align:left;\"><img src=\"data:image/jpeg;base64,[encoded data, 10972 characters]\" alt=\"undefined\" style=\"height: auto;width: auto\"/></div>\n<p></p>\n<p></p>\n<div style=\"text-align:left;\"><img src=\"data:image/jpeg;base64,[encoded data, 8972 characters]\" alt=\"undefined\" style=\"height: auto;width: auto\"/></div>\n<p></p>\n<div style=\"text-align:right;\"><img src=\"data:image/jpeg;base64,[encoded data, 6268 characters]\" alt=\"undefined\" style=\"height: auto;width: auto\"/></div>\n<p></p>\n<div style=\"text-align:left;\"><img src=\"data:image/jpeg;base64,[encoded data, 10972 characters]\" alt=\"undefined\" style=\"height: auto;width: auto\"/></div>\n<p></p>\n\n<p></p>\n<div style=\"text-align:left;\"><img src=\"data:image/jpeg;base64,[encoded data, 8972 characters]\" alt=\"undefined\" style=\"height: auto;width: auto\"/></div>\n<p></p>\n<div style=\"text-align:right;\"><img src=\"data:image/jpeg;base64,[encoded data, 6268 characters]\" alt=\"undefined\" style=\"height: auto;width: auto\"/></div>\n<p></p>\n<div style=\"text-align:left;\"><img src=\"data:image/jpeg;base64,[encoded data, 10972 characters]\" alt=\"undefined\" style=\"height: auto;width: auto\"/></div>\n<p></p>\n<p></p>\n<div style=\"text-align:left;\"><img src=\"data:image/jpeg;base64,[encoded data, 8972 characters]\" alt=\"undefined\" style=\"height: auto;width: auto\"/></div>\n<p></p>\n<div style=\"text-align:right;\"><img src=\"data:image/jpeg;base64,[encoded data, 6268 characters]\" alt=\"undefined\" style=\"height: auto;width: auto\"/></div>\n<p></p>\n<div style=\"text-align:left;\"><img src=\"data:image/jpeg;base64,[encoded data, 10972 characters]\" alt=\"undefined\" style=\"height: auto;width: auto\"/></div>\n<p></p>\n','2024-01-29 06:54:20'),(35,'supervisor, admin, lawfirm_attorney, news_media, research_firm, business, watchdog_group, police_union, citizen_review_board','4','About better blue performance','<p><span style=\"font-size: 24px;\"><strong>Overview</strong></span></p>\n<p></p>\n<p><span style=\"color: rgb(89,89,89);font-size: 14pt;\">Welcome to Better Blue Performance, a community-driven crime reporting platform designed to empower citizens in contributing to public safety. This application serves as a vital tool to facilitate the reporting of incidents and concerns within your community,</span><br><span style=\"color: rgb(89,89,89);font-size: 14pt;\">fostering collaboration between citizens and law enforcement.</span>&nbsp;</p>\n<p>&nbsp;</p>\n<p><span style=\"color: rgb(89,89,89);font-size: 14pt;\"><strong>1.2 Key Features</strong></span>&nbsp;</p>\n<p>&nbsp;</p>\n<p><span style=\"color: rgb(89,89,89);font-size: 14pt;font-family: Symbol;\"><strong>·</strong></span> <span style=\"color: rgb(89,89,89);font-size: 14pt;\"><strong>1.2.1 Quick Reporting</strong></span>&nbsp;</p>\n<p>&nbsp;</p>\n<p><span style=\"color: rgb(89,89,89);font-size: 14pt;\">Effortlessly report incidents with just a few taps, providing essential details to law enforcement</span><br><span style=\"color: rgb(89,89,89);font-size: 14pt;\">for prompt action.</span>&nbsp;</p>\n<p>&nbsp;</p>\n<p><span style=\"color: rgb(89,89,89);font-size: 14pt;font-family: Symbol;\"><strong>·</strong></span> <span style=\"color: rgb(89,89,89);font-size: 14pt;\"><strong>1.2.2 Anonymity</strong></span>&nbsp;</p>\n<p>&nbsp;</p>\n<p><span style=\"color: rgb(89,89,89);font-size: 14pt;\">Prioritize your safety by choosing to submit reports anonymously, ensuring that your identity remains confidential.</span>&nbsp;</p>\n<p>&nbsp;</p>\n<p><span style=\"color: rgb(89,89,89);font-size: 14pt;font-family: Symbol;\"><strong>·</strong></span> <span style=\"color: rgb(89,89,89);font-size: 14pt;\"><strong>1.2.3 Community Engagement</strong></span>&nbsp;</p>\n<p>&nbsp;</p>\n<p><span style=\"color: rgb(89,89,89);font-size: 14pt;\">Stay informed about incidents in your area such as missing persons, recent crimes or anonymously contribute by provide timely tips, fostering a sense of community awareness and collaboration.</span>&nbsp;</p>\n<p>&nbsp;</p>\n<p><span style=\"color: rgb(89,89,89);font-size: 14pt;font-family: Symbol;\"><strong>·</strong></span> <span style=\"color: rgb(89,89,89);font-size: 14pt;\"><strong>1.2.4 User-Friendly Interface</strong></span>&nbsp;</p>\n<p>&nbsp;</p>\n<p><span style=\"color: rgb(89,89,89);font-size: 14pt;\">Navigate the application effortlessly with an intuitive design, making crime reporting and information retrieval simple for all users.</span>&nbsp;</p>\n<p>&nbsp;</p>\n<p>&nbsp;</p>\n<p>&nbsp;</p>\n<p><span style=\"color: rgb(89,89,89);font-size: 14pt;\"><strong>1.3 How Better Blue Performance works</strong></span>&nbsp;</p>\n<p>&nbsp;</p>\n<p><span style=\"color: rgb(89,89,89);font-size: 14pt;\"><strong>Reporting Incidents:</strong></span>&nbsp;</p>\n<ul>\n<li><span style=\"color: rgb(89,89,89);font-size: 14pt;\">Select the type of incident.</span>&nbsp;</li>\n<li><span style=\"color: rgb(89,89,89);font-size: 14pt;\">Provide details and upload media if available.</span>&nbsp;</li>\n<li><span style=\"color: rgb(89,89,89);font-size: 14pt;\">Choose to report anonymously if desired.</span>&nbsp;</li>\n</ul>\n<p></p>\n','2024-01-29 10:39:16'),(36,'supervisor, admin, lawfirm_attorney, research_firm, news_media, business, watchdog_group, police_union, citizen_review_board','19','Unregistered Users','<p><span style=\"color: rgb(89,89,89);font-size: 16pt;font-family: Calibri Light\", sans-serif;\"><strong>2.1 Unregistered Users</strong></span>&nbsp;</p>\n<p></p>\n<p><span style=\"color: rgb(89,89,89);font-size: 14pt;font-family: Calibri Light\", sans-serif;\">Unregistered users/Guest users can only</span> <span style=\"color: rgb(89,89,89);font-size: 14pt;font-family: Calibri Light\", sans-serif;\">view and browse through public Information such as Articles, missing person information and Jobs posted. But cannot access the core featues such as reporting crime, reporting a missing person, Advertisement, access case related Information etc.</span>&nbsp;&nbsp;</p>\n<p></p>\n<p><span style=\"color: rgb(235,107,86);font-size: 14px;\">*<strong>Note:  </strong>To<strong> </strong>get the best out of Better blue performance and to use all its features signing up is necessary.</span>&nbsp;</p>\n','2024-01-29 10:47:10'),(48,'business, news_media, research_firm, watchdog_group, police_union, citizen_review_board, lawfirm_attorney','20','Manage Profile','<p></p>\n','2024-03-27 13:20:29'),(49,'supervisor, admin','17','Overview ','<p><span style=\"color: rgb(89,89,89);background-color: rgb(255,255,255);font-size: 14pt;font-family: Calibri Light;\"><strong>Agency owner</strong> has the <strong>overall control</strong> of the agency like Managing the agency information, Adding or managing precints, adding or managing officers, view/manage cases and information.</span>&nbsp;</p>\n<p></p>\n<p></p>\n<img src=\"data:image/png;base64,[encoded data, 66596 characters]\" alt=\"undefined\" style=\"height: auto;width: auto\"/>\n<p><span style=\"color: rgb(89,89,89);background-color: rgb(255,255,255);font-size: 14pt;font-family: Calibri Light;\"><strong>3.2 Agency owner Dashboard</strong></span>&nbsp;</p>\n<p></p>\n<p></p>\n<img src=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAA3oAAAJECAYAAABAVFYRAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAP+lSURBVHhe7J0FgBzHlf6/Yd6Z3VlmBvGKGczMGDvgMF7gkjvf+XLJJblL/uE4vpyT2Iljx46ZmWRZzMwrrZaZhnn+7/XMWCtZsndXK1uW309u73Q1VVdXV72vX4EqTkAQBEEQBEEQBEE4a1An/wqCIAiCIAiCIAhnCSL0BEEQBEEQBEEQzjJE6AmCIAiCIAiCIJxliNATBEEQBEEQBEE4yxChJwiCIAiCIAiCcJYhQk8QBEEQBEEQBOEsY9ynVwiHw/B6vQgEAvD5fMq6IAiCIAiCIAjCxwm1Wg2j0agsFosFJpMJKpUqufX0c8pCz+VyYcuWLXj++eexevVqBIPB5BZBEARBEARBEASBYeFXWFiICy64QFnKy8uVsNPFmIQei7u33noL99xzD1pbW5OhgiAIgiAIgiAIwkhgT9/SpUtxww03YMqUKeMu+kYl9Lgp5l133YWHH344GSIIgiAIgiAIgiCcCk6nEz/4wQ+wYMGCcWveOSKhx/3sHnroIfz+979HLBZLhgqCIAiCIAiCIAjjRWlpKX7yk59gwoQJyZCx875Cb+3atfj2t7+NUCiUDBEEQRAEQRAEQRBOF9OnT8fvfvc7ZRCXsXJSocfBf/7zn3H33XcnQwRBEARBEARBEIQPAofDgfvuuw/FxcXJkNFxQqEXiUTwve99DytWrEiGCIIgCIIgCIIgCB8kWq0Wv/rVr7Bo0aJkyMh5l9DjOfA+8YlPoKWlJRkiCIIgCIIgCIIgfFh89atfxec///nk2sg4ZgxPHnTlpptuEpEnCIIgCIIgCIJwhvCHP/wBf//735NrI+MdoceOPR50pa2tLR