5wsd0+wrc/W5wWvHZE3GUAERwvPNNiVyFm+DFfpAwxrUcPj6bSBTDcJWa0CGhhL6dQAaTncDO8BZmsezC32xHtrUa+DIcRXAaCPouAdlfBt2XFrp/gWBxlFzJY8Q5tiOBhTzQqVFMTDfRJiEfpAqH2gDSGNjmXFHeiQ7IQ3pWScS7s2ytEkGDAzG8d/ouWLrIdOT9sxrcbUGjz8fip6e2Ko4HxH4K1X2cM05bReDAG6dfEyFWrbOLQZgX7Jm2u87vyXQpnG0WaXSAj3qfkY+KsN27SdZzTu1AIQbE4JzdxNp00VIOkwm2sBqA/CP3U7xuyG3faFINkUHjskifqum3ATKyc7k4HgsY07ejrRYVDrNwD4aQnv2TUAGUgxwMWjQSFnaWPqt0qP8AOfirlLpBWbqQ7xA+6FqRgn7DX+qf5qf4pKh/aSr9Vvkf/ZdQpGN5isW58A9lu5szHfxJI3qLrB88bKsNoN+rzsZ43srdWth8gLXCYGZuUtM2ENIHfrI0SPgca3tGARzsN1yTuvp396e1wkNIeBeYsXGDBINiLWbumZkWq4rFQzM1pdAu1kHKPrE6u11i07rofjscwCi7RlQsOoeaZkEkhpgk3MTN7wUk3wBugnkyghpcIs4HcW6kXv4kblythCabXEAtfMa3B/G9laxT2vNNtNo60yC+4a/OYcC2TBzO17vBQ43bVSkOphriGMa1wnM1zgc0Om/0YgXtMkGeGPkTdUJuYzH4Q0ajqbt2lwbHSY0PcjXRzaGUwSoNr4So9uZwPWAuLtAYaAXNy6iBB4WKBUa5aZBXbGSyxLY8lOze4/DgOzD3X38Hb/PXzVak7KYKg2NtEPYWO+d6uPozv8CunBlr6ZdoObHf1R6HGCrWBxBa4G9j3KDBBxcGluY/UOp+w7iilDAzcNa7i0y17eINwD4hdjaOaj1Xo9tNmIpAGM0QRbdaUQOAbIIXnuzcK+mQ5tJ14ILHPuN24g+a1WC226wc108CDPmuRpexVBbEYUFhFtDEiYJ0K8v2xsssc4OBkevNelPxxykkACCZcY8+C876RbeqVwG5WsaOF3Hd7x3clbx7snk6M/hcTUo1JY7K5wLABrDrEc1S/SPSqNxQ60BrzRoucBESGlk2tqwqvj9oig6R2qg7QHAg2Lue5V+me03Yiv1rnZs7GkaCGEuygRbT4pfJ7Gwhfoe39nPBVcXiIqPINi64M/RsBBEK50WEUfFChU950h0kyb6EyfD0vyXnRVyZ25ftROwtPvRAF9bjhcbyN+k9yEU8MwznmHuJa0HK1jXaQO+0cIV6s6OyHTIJqA8NwnjeB4n6qZScSYaNJMDWQZ4ds66yIKdxs57IxsykQHNcQTa5ZItAtz9EIx2xSZjLpAac8iGyIMEHf3SjbGtHHNbKbDdF5M2+dyc2Gnte6QC4xmINoAce0LQe6/BaKa9zOmYzE7Hr0rlgLWx2gWuHa0mDMJYrCGM2RzZiCWuAJ1NyI04LXYgA5aV4ccz7izJkiRP0QLi3b0V6lVIyxu11s3iTB523d6MpyXSAoJmAotaYkA7jB8LjzU7sAwjUg3tI/ArZ1cNTI7dNpMdnssFjBEyJGnn4pp2VRfpDd/vxFp0J36aXjuWeRr2Asf5MV+rh9Y+iS2H6nw/1qn8w/BJL638jekyuPxSGnNJJdMuhUMqfPoqmM913jR/zWrqSnk/6LI0dH+8Uvtv/AM1qHbO/vtL/AKf+SEkl5UPf+CJe2179T7FT+tqwAXUl2eH0/wDRdBbYvvjktY7RJJUyfcjrx/ay3g/39D/mU/6gtjtj++u5f0pJL0pHAuzUdHP3Q8Hf1uVWh++b4n+lJJQKk/SP+71OX9bV53itUkl0+N0yOXs8+xfv1ftP/qK5j9Kf/KZ/XUSSUMvbHxGx6PfuB4fchuC9w/aSSXDDtnZm6RXr/vH/AOH4ldqfh9ySSoc5Zw/u1P8AD8WqsNT9k/8A0SSWCMxP74/YH/5q3gdf8Q/oC6kgwoIUtMT4H4OQir7nM/Fy6klRkdSSSRHP/9k=\" 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'),(37,'lawfirm_attorney, news_media, research_firm, business, watchdog_group, police_union, citizen_review_board','19','Sign Up','<p><span style=\"color: rgb(89,89,89);font-size: 14pt;font-family: Calibri Light\", sans-serif;\">BBP provides a simple and an easy way to create an account to access the underlying system. It provides 2 methods for easy access.</span>&nbsp;</p>\n<p>&nbsp;&nbsp;</p>\n<p><span style=\"color: rgb(89,89,89);font-size: 18pt;font-family: Calibri Light\", sans-serif;\">1)</span> <span style=\"color: rgb(89,89,89);font-size: 16pt;font-family: Calibri Light\", sans-serif;\">Using social credentials: </span>&nbsp;</p>\n<p><span style=\"color: rgb(89,89,89);font-size: 14pt;font-family: Calibri Light\", sans-serif;\">User can Sign-up into BBP using the popular social networking credentials such as Facebook, X, Google. Basic information like email and user name will be auto fetched once the authentication is successful and the same information will be used to setup </span></p>\n<p></p>\n<p></p>\n<img src=\"data:image/jpeg;base64,[encoded data, 102456 characters]\" alt=\"undefined\" style=\"height: auto;width: auto\"/>\n<p><span style=\"color: rgb(89,89,89);font-size: 14pt;font-family: Calibri Light\", sans-serif;\">your profile.</span>&nbsp;&nbsp;</p>\n','2024-01-29 10:50:09'),(47,'supervisor, admin, lawfirm_attorney, news_media, research_firm, business, watchdog_group, police_union, citizen_review_board','19','Better blue performance','<p></p>\n<img src=\"data:image/png;base64,[encoded data, 60812 characters]\" alt=\"undefined\" style=\"height: auto;width: auto\"/>\n<p></p>\n','2024-03-15 11:16:41');

--
-- Table structure for table `event`
--

CREATE TABLE `event` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `precintId` varchar(1000) DEFAULT NULL,
  `ownerId` int(100) NOT NULL DEFAULT '0' COMMENT 'created by',
  `title` varchar(250) DEFAULT NULL,
  `startDate` varchar(250) DEFAULT NULL,
  `endDate` varchar(250) DEFAULT NULL,
  `duration` varchar(250) DEFAULT NULL,
  `location` varchar(250) DEFAULT NULL,
  `description` text,
  `contactInfo` varchar(250) DEFAULT NULL,
  `eventType` varchar(250) DEFAULT NULL COMMENT 'private or public',
  `attendiesRequired` varchar(250) DEFAULT NULL COMMENT 'yes or no',
  `status` int(100) NOT NULL DEFAULT '0' COMMENT '0 - not app, 1 - approve',
  `createdBy` int(100) NOT NULL DEFAULT '0',
  `updatedBy` int(100) NOT NULL DEFAULT '0',
  `createdDate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedDate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `event`
--


--
-- Table structure for table `files`
--

CREATE TABLE `files` (
  `FileId` int(11) NOT NULL AUTO_INCREMENT,
  `ComplaintsId` int(11) DEFAULT NULL,
  `FileType` tinyint(4) DEFAULT '1' COMMENT '1->Images,2->Videos',
  `S3Bucket` varchar(256) DEFAULT NULL,
  `FilePath` varchar(511) DEFAULT NULL,
  `FileName` varchar(255) DEFAULT NULL,
  `FileExtension` varchar(30) DEFAULT NULL,
  `FileSize` int(11) DEFAULT NULL,
  PRIMARY KEY (`FileId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `files`
--


--
-- Table structure for table `lawfirm_complaints`
--

CREATE TABLE `lawfirm_complaints` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NOT NULL DEFAULT '0',
  `officerId` int(11) NOT NULL DEFAULT '0',
  `lawfirmAdminId` int(11) NOT NULL DEFAULT '0',
  `compliantId` int(11) NOT NULL DEFAULT '0',
  `status` varchar(100) DEFAULT NULL,
  `reason` text,
  `createdAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `lawfirm_complaints`
--


--
-- Table structure for table `legal_reviews`
--

CREATE TABLE `legal_reviews` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `reviewType` varchar(100) NOT NULL,
  `reviewTypeId` varchar(100) NOT NULL,
  `bussinessGroupId` int(100) NOT NULL DEFAULT '0',
  `userId` int(11) NOT NULL DEFAULT '0',
  `muniCode` varchar(100) DEFAULT NULL,
  `muniCodedate` varchar(100) DEFAULT NULL,
  `quickSummary` text,
  `legalDesc` text,
  `recommendation` text,
  `resCode` varchar(100) DEFAULT NULL,
  `orgType` varchar(111) DEFAULT NULL,
  `createdBy` int(100) NOT NULL DEFAULT '0',
  `createdAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedBy` int(100) NOT NULL DEFAULT '0',
  `updatedAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `legal_reviews`
--


--
-- Table structure for table `likes_count_history`
--

CREATE TABLE `likes_count_history` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type_id` int(11) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `likes` int(11) DEFAULT NULL,
  `disLikes` int(11) DEFAULT NULL,
  `comments_count` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `likes_count_history`
--


--
-- Table structure for table `likes_history`
--

CREATE TABLE `likes_history` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `user_type` varchar(50) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `type_id` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `likes_history`
--


--
-- Table structure for table `missing_person`
--

CREATE TABLE `missing_person` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NOT NULL DEFAULT '0',
  `officerId` int(11) NOT NULL DEFAULT '0',
  `agencyId` varchar(100) DEFAULT NULL,
  `precintId` varchar(100) DEFAULT NULL,
  `fullName` varchar(100) DEFAULT NULL,
  `nickName` varchar(100) DEFAULT NULL,
  `gender` varchar(500) DEFAULT NULL,
  `dob` varchar(100) DEFAULT NULL,
  `birthPlace` varchar(100) DEFAULT NULL,
  `dateOfMissing` varchar(100) DEFAULT NULL,
  `currentAddress` varchar(100) DEFAULT NULL,
  `faceImage` varchar(1000) DEFAULT NULL,
  `fullImage` varchar(900) DEFAULT NULL,
  `OtherImg3` varchar(900) DEFAULT NULL,
  `OtherImg4` varchar(900) DEFAULT NULL,
  `OtherImg5` varchar(900) DEFAULT NULL,
  `height` varchar(100) DEFAULT NULL,
  `weignt` varchar(100) DEFAULT NULL,
  `age` varchar(100) DEFAULT NULL,
  `build` varchar(100) DEFAULT NULL,
  `hairColor` varchar(100) DEFAULT NULL,
  `eyeColor` varchar(100) DEFAULT NULL,
  `distinguishMark` varchar(100) DEFAULT NULL,
  `beard` varchar(100) DEFAULT NULL,
  `latitude` varchar(100) DEFAULT NULL,
  `longitude` varchar(100) DEFAULT NULL,
  `tellUs` varchar(500) DEFAULT NULL,
  `city` varchar(500) DEFAULT NULL,
  `state` varchar(500) DEFAULT NULL,
  `statusCode` varchar(100) DEFAULT 'open',
  `resolutionCode` varchar(500) DEFAULT NULL,
  `reward` varchar(100) DEFAULT NULL,
  `totalReward` int(100) NOT NULL DEFAULT '0',
  `donation` varchar(100) DEFAULT NULL,
  `donationPrice` int(100) NOT NULL DEFAULT '0',
  `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,
  `video` varchar(300) DEFAULT NULL,
  `zipcode` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `missing_person`
--

INSERT INTO `missing_person` VALUES (1,11,0,'537416','536491','Victor Ernesto Mendez Mendez','Vic','male','2017-05-21','Norcross, GA','2024-08-08','5200 Peachtree Industrial Boulevard, Norcross, GA, USA','https://bbpimagesandvideos.s3.amazonaws.com/Norcross%201-f589845c7f713fbb72a7b203f6341758.jpg','https://bbpimagesandvideos.s3.amazonaws.com/Norcross%201-209a7163955f1978711b88b9ae955d2a.1-209a7163955f1978711b88b9ae955d2a.jpg',NULL,NULL,NULL,'57','150','17','Atheltic','Black','Brown','','','33.9610914','-84.20700099999999','Victor went to the store and didn\'t return home.','Norcross','Georgia','working','','yes',700,NULL,0,11,'2024-10-07 14:14:44',0,'2024-10-23 22:35:46',NULL,'30091'),(2,11,0,'537416','536491','Marisa Velasco','','female','2005-08-17','At their apartment','2005-12-17','5200 Peachtree Industrial Boulevard, Norcross, GA, USA','https://bbpimagesandvideos.s3.amazonaws.com/Norcross%202-700ffb542f5e8f97605fc73cca8f1b45.jpg','https://bbpimagesandvideos.s3.amazonaws.com/Norcross%202-419b744d6536e68f2e7e16042669410a.1-419b744d6536e68f2e7e16042669410a.jpg',NULL,NULL,NULL,'','14','1','Triangle \"Pear\"','Black','Brown','','','33.9610914','-84.20700099999999','The baby was taken.  ','Norcross','Georgia','working','','yes',0,NULL,0,11,'2024-10-07 14:26:30',0,'2024-10-22 10:07:50',NULL,'30091');

--
-- Table structure for table `missing_person_agency_responce`
--

CREATE TABLE `missing_person_agency_responce` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `reportNumber` varchar(100) DEFAULT NULL,
  `agencyReport` varchar(100) DEFAULT NULL,
  `fcnNumber` varchar(100) DEFAULT NULL,
  `nicNumber` varchar(100) DEFAULT NULL,
  `assignOfficer` int(100) DEFAULT '0',
  `assignDateTime` varchar(100) DEFAULT NULL,
  `internalRouteNo` varchar(100) DEFAULT NULL,
  `forwardCopyReportTo` varchar(100) DEFAULT NULL,
  `reasonCode` varchar(100) DEFAULT NULL,
  `alerts` varchar(100) DEFAULT NULL,
  `remark` varchar(100) DEFAULT NULL,
  `publicNarative` text,
  `privateNarative` text,
  `createdBy` int(10) NOT NULL DEFAULT '0',
  `createdAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedBy` int(10) NOT NULL DEFAULT '0',
  `updatedAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=latin1;

--
