function uc_shipping_update_3 in Ubercart 5

File

shipping/uc_shipping/uc_shipping.install, line 142

Code

function uc_shipping_update_3() {
  $ret = array();
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      $ret[] = update_sql("ALTER TABLE {uc_shipments} CHANGE `order_id` order_id mediumint(9) UNSIGNED NOT NULL default 0");
      $ret[] = update_sql("ALTER TABLE {uc_shipments} CHANGE `o_first_name` o_first_name varchar(255) NOT NULL default ''");
      $ret[] = update_sql("ALTER TABLE {uc_shipments} CHANGE `o_last_name` o_last_name varchar(255) NOT NULL default ''");
      $ret[] = update_sql("ALTER TABLE {uc_shipments} CHANGE `o_company` o_company varchar(255) NOT NULL default ''");
      $ret[] = update_sql("ALTER TABLE {uc_shipments} CHANGE `o_street1` o_street1 varchar(255) NOT NULL default ''");
      $ret[] = update_sql("ALTER TABLE {uc_shipments} CHANGE `o_street2` o_street2 varchar(255) NOT NULL default ''");
      $ret[] = update_sql("ALTER TABLE {uc_shipments} CHANGE `o_city` o_city varchar(255) NOT NULL default ''");
      $ret[] = update_sql("ALTER TABLE {uc_shipments} CHANGE `o_zone` o_zone mediumint(11) UNSIGNED NOT NULL default 0");
      $ret[] = update_sql("ALTER TABLE {uc_shipments} CHANGE `o_postal_code` o_postal_code varchar(255) NOT NULL default ''");
      $ret[] = update_sql("ALTER TABLE {uc_shipments} CHANGE `o_country` o_country mediumint(11) UNSIGNED NOT NULL default 0");
      $ret[] = update_sql("ALTER TABLE {uc_shipments} CHANGE `d_first_name` d_first_name varchar(255) NOT NULL default ''");
      $ret[] = update_sql("ALTER TABLE {uc_shipments} CHANGE `d_last_name` d_last_name varchar(255) NOT NULL default ''");
      $ret[] = update_sql("ALTER TABLE {uc_shipments} CHANGE `d_company` d_company varchar(255) NOT NULL default ''");
      $ret[] = update_sql("ALTER TABLE {uc_shipments} CHANGE `d_street1` d_street1 varchar(255) NOT NULL default ''");
      $ret[] = update_sql("ALTER TABLE {uc_shipments} CHANGE `d_street2` d_street2 varchar(255) NOT NULL default ''");
      $ret[] = update_sql("ALTER TABLE {uc_shipments} CHANGE `d_city` d_city varchar(255) NOT NULL default ''");
      $ret[] = update_sql("ALTER TABLE {uc_shipments} CHANGE `d_zone` d_zone mediumint(11) UNSIGNED NOT NULL default 0");
      $ret[] = update_sql("ALTER TABLE {uc_shipments} CHANGE `d_postal_code` d_postal_code varchar(255) NOT NULL default ''");
      $ret[] = update_sql("ALTER TABLE {uc_shipments} CHANGE `d_country` d_country mediumint(11) UNSIGNED NOT NULL default 0");
      $ret[] = update_sql("ALTER TABLE {uc_shipments} CHANGE `shipping_method` shipping_method varchar(255) NOT NULL default ''");
      $ret[] = update_sql("ALTER TABLE {uc_shipments} CHANGE `accessorials` accessorials varchar(255) NOT NULL default '' default ''");
      $ret[] = update_sql("ALTER TABLE {uc_shipments} CHANGE `carrier` carrier varchar(255) NOT NULL default ''");
      $ret[] = update_sql("ALTER TABLE {uc_shipments} CHANGE `transaction_id` transaction_id varchar(255) NOT NULL default ''");
      $ret[] = update_sql("ALTER TABLE {uc_shipments} CHANGE `tracking_number` tracking_number varchar(255) NOT NULL default ''");
      $ret[] = update_sql("ALTER TABLE {uc_shipments} CHANGE `ship_date` ship_date int(11) NOT NULL default 0");
      $ret[] = update_sql("ALTER TABLE {uc_shipments} CHANGE `expected_delivery` expected_delivery int(11) NOT NULL default 0");
      $ret[] = update_sql("ALTER TABLE {uc_shipments} CHANGE `cost` cost decimal(10,2) NOT NULL default 0.0");
      break;
  }
  return $ret;
}