Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Trivial
-
Resolution: Fixed
-
Affects Version/s: Mercury
-
Fix Version/s: Mercury
-
Component/s: Other / Misc.
-
Labels:None
-
Sprint:Sprint 3
Description
Sql queries doesn't have database/table name in it.
Actual result :
CREATE TABLE `bingAdMax` (
`date` date NOT NULL default '0000-00-00',
`campaignid` bigint(20) unsigned NOT NULL DEFAULT '0',
`clicks` int(11) NOT NULL DEFAULT '0',
`cost` double NOT NULL DEFAULT '0',
`averagePosition` double NOT NULL DEFAULT '0',
PRIMARY KEY (`date`, `campaignid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Store performance data for AdMax processes';
– AML-3507 - Update ABU settings to allow distribution-specific values
ALTER TABLE admaxSloshFactors CHANGE elementType elementType ENUM('global','account','admaxCampaign','distribution') NOT NULL DEFAULT 'global';
ALTER TABLE admaxSloshLimits CHANGE elementType elementType ENUM('global','account','admaxCampaign','distribution') NOT NULL DEFAULT 'global';
ALTER TABLE admaxBudgetCapMultipliers CHANGE elementType elementType ENUM('global','account','distribution') NOT NULL DEFAULT 'global';
ALTER TABLE admaxBoosts CHANGE elementType elementType ENUM('global','account','admaxCampaign','distribution') NOT NULL DEFAULT 'global';
Expected:
CREATE TABLE `staging`.`bingAdMax` (
`date` date NOT NULL default '0000-00-00',
`campaignid` bigint(20) unsigned NOT NULL DEFAULT '0',
`clicks` int(11) NOT NULL DEFAULT '0',
`cost` double NOT NULL DEFAULT '0',
`averagePosition` double NOT NULL DEFAULT '0',
PRIMARY KEY (`date`, `campaignid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Store performance data for AdMax processes';
– AML-3507 - Update ABU settings to allow distribution-specific values
ALTER TABLE `st-tracker`.admaxSloshFactors CHANGE elementType elementType ENUM('global','account','admaxCampaign','distribution') NOT NULL DEFAULT 'global';
ALTER TABLE `st-tracker`.admaxSloshLimits CHANGE elementType elementType ENUM('global','account','admaxCampaign','distribution') NOT NULL DEFAULT 'global';
ALTER TABLE `st-tracker`.admaxBudgetCapMultipliers CHANGE elementType elementType ENUM('global','account','distribution') NOT NULL DEFAULT 'global';
ALTER TABLE `st-tracker`.admaxBoosts CHANGE elementType elementType ENUM('global','account','admaxCampaign','distribution') NOT NULL DEFAULT 'global';