SELECT `BrandID`, `BrandName`, `AffiliateID`, `UserName`, `Password`, 
					       `BrandAPI`, `IsVisible`, `Stars`, `Priority`,  `BrandURL`, `BrandImageUrl`,
						   (SELECT round(SUM(actualBalance),2) FROM `brandaccounts` WHERE brandaccounts.BrandID = brands.BrandID) As `Balance`,	
						   (SELECT round(SUM(Outcome),2) FROM `requests`, `brandaccounts` WHERE requests.AccountID = brandaccounts.AccountID && brandaccounts.BrandsID = brands.BrandID) AS Gain
						   FROM `brands` WHERE `PlatformID` = :PlatformID && `PartnerID` = :PartnerID";

 (SELECT round(SUM(Outcome),2) FROM `requests`, `brandaccounts` WHERE requests.AccountID = brandaccounts.AccountID && brandaccounts.BrandsID = brands.BrandID) AS Gain

CREATE TABLE IF NOT EXISTS `brandaccounts` (
`AccountID` int(11) NOT NULL,
  `UserID` int(11) NOT NULL,
  `BrandID` int(11) NOT NULL,
  `LoginEmail` varchar(50) NOT NULL,
  `LoginID` int(11) NOT NULL,
  `LoginPassword` varchar(50) DEFAULT NULL,
  `initialBalance` double NOT NULL DEFAULT '0',
  `actualBalance` double NOT NULL DEFAULT '0',
  `IsAutoTrade` tinyint(1) NOT NULL DEFAULT '0',
  `MaxBet` int(11) NOT NULL DEFAULT '10',
  `MaxStopLoss` int(11) NOT NULL DEFAULT '0',
  `MaxTakeProfit` int(11) DEFAULT '0',
  `IsTestAccount` bit(1) NOT NULL,
  `VIPGroup` varchar(45) DEFAULT 'Regular'
) ENGINE=InnoDB 

CREATE TABLE IF NOT EXISTS `brands` (
`BrandID` int(11) NOT NULL,
  `PartnerID` int(11) NOT NULL,
  `AffiliateID` int(11) NOT NULL,
  `UserName` varchar(50) NOT NULL,
  `Password` varchar(50) NOT NULL,
  `BrandName` varchar(50) NOT NULL,
  `BrandURL` longtext NOT NULL,
  `BrandAPI` longtext NOT NULL,
  `BrandJSON` longtext,
  `BrandAPIType` int(11) NOT NULL,
  `PlatformID` int(11) DEFAULT NULL,
  `Stars` int(11) DEFAULT '5',
  `Priority` int(11) DEFAULT '0',
  `BrandImageUrl` longtext,
  `AcceptUS` int(11) DEFAULT '0',
  `AcceptEU` int(11) DEFAULT '0',
  `AcceptNONEU` int(11) DEFAULT '0',
  `IsVisible` int(11) DEFAULT '1',
  `Countries` varchar(250) DEFAULT NULL
) ENGINE=InnoDB 

CREATE TABLE IF NOT EXISTS `requests` (
`RequestID` int(11) NOT NULL,
  `SignalID` int(11) NOT NULL,
  `AccountID` int(11) NOT NULL,
  `TradeType` varchar(20) NOT NULL,
  `Volume` double NOT NULL,
  `TicketID` int(11) NOT NULL,
  `Payout` int(11) NOT NULL,
  `Outcome` double DEFAULT NULL,
  `OpenPrice` double NOT NULL DEFAULT '0',
  `ClosePrice` double NOT NULL DEFAULT '0',
  `CloseTime` datetime DEFAULT NULL,
  `CreateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `SendEndTime` datetime NOT NULL,
  `RequestParams` text,
  `ResponseParams` text,
  `AssetsResponse` text,
  `TurboResponse` text,
  `DigitalResponse` text
) ENGINE=InnoDB