CREATE TABLE `ExtCasinoAPILog` (
  `LogID` bigint(20) NOT NULL,
  `CasinoID` char(3) DEFAULT NULL,
  `ReqType` varchar(10) DEFAULT NULL,
  `LogDateTime` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `ExtCasinoAPISetting` (
  `AccessID` int(11) NOT NULL AUTO_INCREMENT,
  `CasinoID` char(5) NOT NULL,
  `CurrencyCode` char(3) DEFAULT NULL,
  `APIURL` varchar(150) DEFAULT NULL,
  `APIID` varchar(50) DEFAULT NULL,
  `APIKey` varchar(50) DEFAULT NULL,
  `APIData1` varchar(100) DEFAULT NULL,
  `APIData2` varchar(100) DEFAULT NULL,
  `GameURL` varchar(100) DEFAULT NULL,
  `LastUpdateDate` datetime DEFAULT NULL,
  `LastUpdateUser` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`AccessID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

CREATE TABLE `Casino` (
  `CasinoID` char(3) NOT NULL,
  `CasinoName` varchar(50) DEFAULT NULL,
  `Status` char(1) DEFAULT NULL,
  PRIMARY KEY (`CasinoID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `CasinoGame` (
  `GameID` int(11) NOT NULL,
  `GameName` varchar(100) DEFAULT NULL,
  `GameType` varchar(20) DEFAULT NULL,
  `CasinoID` char(3) DEFAULT NULL,
  `ExtGameID` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`GameID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `LicenseeExtCasino` (
  `LicenseID` int(11) NOT NULL,
  `CasinoID` char(3) DEFAULT NULL,
  `CasinoAccessID` int(11) DEFAULT NULL,
  PRIMARY KEY (`LicenseID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `panther`.`RealPlay` 
ADD COLUMN `CasinoID` CHAR(3) NULL DEFAULT NULL AFTER `RoundID`,
ADD COLUMN `3rdpSessionID` VARCHAR(50) NULL DEFAULT NULL AFTER `FSTotalLine`;

ALTER TABLE `panther`.`PlayerBetLog` 
ADD COLUMN `CasinoID` CHAR(3) NULL DEFAULT NULL AFTER `ContestID`;