------------------------------------------------------------------------------------------------------------------------------------------------+
| SiteInfoNew | CREATE TABLE `SiteInfoNew` (
  `PSI` varchar(4) NOT NULL,
  `SiteName` varchar(100) NOT NULL,
  `City` varchar(45) NOT NULL,
  `State` varchar(2) NOT NULL,
  `Branch` varchar(10) NOT NULL,
  `NOC` varchar(4) default NULL,
  `SiteType` varchar(45) NOT NULL,
  `PriEMS` varchar(4) character set latin1 collate latin1_bin default NULL,
  `SecEMS` varchar(4) default NULL,
  `LocalSFType` varchar(45) NOT NULL,
  `Redundant` varchar(45) NOT NULL,
  `BaseX` varchar(4) default NULL,
  `ServerFarm` varchar(4) NOT NULL,
  `HostSite` varchar(4) default NULL,
  PRIMARY KEY  USING BTREE (`PSI`),
  KEY `NOC` (`NOC`),
  KEY `PriEMS` (`PriEMS`),
  KEY `SecEMS` (`SecEMS`),
  KEY `BaseX` (`BaseX`),
  KEY `ServerFarm` (`ServerFarm`),
  KEY `HostSite` (`HostSite`),
  CONSTRAINT `FK_SiteInfoNew_1` FOREIGN KEY (`HostSite`) REFERENCES `SiteInfoNew` (`PSI`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |