function uc_discounts_update_2 in Ubercart Discounts (Alternative) 6.2

File

uc_discounts/uc_discounts.install, line 516

Install hooks for uc_discounts.module.

Code

function uc_discounts_update_2() {
  $queries = array();
  switch ($GLOBALS["db_type"]) {
    case "mysql":
    case "mysqli":
      $queries[] = update_sql("ALTER TABLE {uc_discounts} ADD has_qualifying_amount_max tinyint NOT NULL default 0 AFTER qualifying_amount");
      $queries[] = update_sql("ALTER TABLE {uc_discounts} ADD qualifying_amount_max float NOT NULL default 0 AFTER has_qualifying_amount_max");

      //Fixes update bug that existed in uc_discounts_update_1 (but is fixed now)
      $queries[] = update_sql("ALTER TABLE {uc_discounts} MODIFY has_role_filter tinyint NOT NULL");
      break;
    case "pgsql":
      db_add_column($queries, "uc_discounts", "has_qualifying_amount_max", "tinyint", array(
        "not null" => TRUE,
        "default" => 0,
      ));
      db_add_column($queries, "uc_discounts", "qualifying_amount_max", "float", array(
        "not null" => TRUE,
        "default" => 0,
      ));
      break;
  }
  return $queries;
}