Uploaded image for project: 'AdMaxLocal'
  1. AdMaxLocal
  2. AML-3569

Mercury DB changes "sql queries" need to update

    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

      https://bitbucket.org/tsa/aml-core/src/7d41175ba7ab0130590f1e767d49818946ad1e87/releases/Mercury/db_changes.sql?at=feature/mercury

      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';

        Attachments

          Activity

            People

            • Assignee:
              atul.sanagar Atul Sanagar (Inactive)
              Reporter:
              atul.sanagar Atul Sanagar (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: