CREATE TABLE developBBPDBNew.agencies_new (
  `AgencyId` int(11) NOT NULL AUTO_INCREMENT,
  `DeptID` varchar(100) DEFAULT NULL,
  `AgencyType` varchar(500) DEFAULT NULL,
  `AgencyTitle` varchar(255) DEFAULT NULL,
  `AgencyDescription` text,
  `AgencyEstablishmentDate` varchar(255) DEFAULT NULL,
  `AgencyWorkingDays` varchar(255) DEFAULT NULL,
  `AgencyWorkingHours` varchar(255) DEFAULT NULL,
  `AgencyFacebookLink` varchar(255) DEFAULT NULL,
  `AgencyTwitterLink` varchar(255) DEFAULT NULL,
  `AgencyLinkedinLink` varchar(255) DEFAULT NULL,
  `AgencyInstagramLink` varchar(255) DEFAULT NULL,
  `AgencyPhoneNumberExtension` varchar(10) DEFAULT NULL,
  `AgencyPhoneNumber` varchar(20) DEFAULT NULL,
  `AgencyCounty` varchar(100) DEFAULT NULL,
  `AgencyPhysicalState` varchar(50) DEFAULT NULL,
  `AgencyPhysicalCity` varchar(50) DEFAULT NULL,
  `AgencyPhysicalZipCode` varchar(20) DEFAULT NULL,
  `AgencyPhysicalAddress` varchar(511) DEFAULT NULL,
  `AgencyGeoLocation` varchar(511) DEFAULT NULL,
  `AgencyMailingAddress` varchar(511) DEFAULT NULL,
  `AgencyMailingCity` varchar(255) DEFAULT NULL,
  `AgencyMailingState` varchar(255) DEFAULT NULL,
  `AgencyMailingZip` varchar(255) DEFAULT NULL,
  `AgencyPopulationArea` varchar(50) DEFAULT NULL,
  `AgencyProfilePic` varchar(256) DEFAULT NULL,
  `AgencyWebsiteLink` varchar(100) DEFAULT NULL,
  `AgencySpecializations` varchar(500) DEFAULT NULL,
  `AgencyNumberOfOfficers` varchar(50) DEFAULT NULL,
  `AgencyJailCapacity` varchar(50) DEFAULT NULL,
  `AgencyFaxNumberExtension` varchar(50) DEFAULT NULL,
  `AgencyFaxNumber` varchar(50) DEFAULT NULL,
  `AgencyStatus` tinyint(1) DEFAULT '1' COMMENT '1->Active,2->Inactive',
  `CreatedBy` varchar(11) DEFAULT NULL,
  `CreatedDate` datetime DEFAULT CURRENT_TIMESTAMP,
  `UpdatedBy` int(11) DEFAULT NULL,
  `UpdatedDate` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `AgencyUserId` int(11) DEFAULT NULL,
  `AgencyProfileLogo` varchar(225) DEFAULT NULL,
  `MailingLine1` varchar(225) DEFAULT NULL,
  `MailingLine2` varchar(225) DEFAULT NULL,
  `defaultRole` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`AgencyId`)
) ENGINE=InnoDB AUTO_INCREMENT=1055 DEFAULT CHARSET=utf8mb4;