function uc_quote_update_2 in Ubercart 5

File

shipping/uc_quote/uc_quote.install, line 129

Code

function uc_quote_update_2() {
  $ret = array();
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      $ret[] = update_sql("CREATE TABLE {uc_quote_manufacturer_locations} (\n        `tid` mediumint(9) UNSIGNED NOT NULL,\n        `first_name` varchar(255) NOT NULL,\n        `last_name` varchar(255) NOT NULL,\n        `company` varchar(255) NOT NULL,\n        `address1` varchar(255) NOT NULL,\n        `address2` varchar(255) NOT NULL,\n        `city` varchar(255) NOT NULL,\n        `zone` mediumint(11) UNSIGNED NOT NULL,\n        `postal_code` varchar(255) NOT NULL,\n        `country` mediumint(11) UNSIGNED NOT NULL,\n        PRIMARY KEY (tid)\n      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ;");
      $ret[] = update_sql("CREATE TABLE {uc_quote_product_locations} (\n        `nid` mediumint(9) UNSIGNED NOT NULL,\n        `first_name` varchar(255) NOT NULL,\n        `last_name` varchar(255) NOT NULL,\n        `company` varchar(255) NOT NULL,\n        `address1` varchar(255) NOT NULL,\n        `address2` varchar(255) NOT NULL,\n        `city` varchar(255) NOT NULL,\n        `zone` mediumint(11) UNSIGNED NOT NULL,\n        `postal_code` varchar(255) NOT NULL,\n        `country` mediumint(11) UNSIGNED NOT NULL,\n        PRIMARY KEY (nid)\n      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ;");
      break;
    case 'pgsql':
      $ret[] = update_sql("CREATE TABLE {uc_quote_manufacturer_locations} (\n        tid integer UNSIGNED NOT NULL default 0,\n        first_name varchar(255) NOT NULL default '',\n        last_name varchar(255) NOT NULL default '',\n        company varchar(255) NOT NULL default '',\n        address1 varchar(255) NOT NULL default '',\n        address2 varchar(255) NOT NULL default '',\n        city varchar(255) NOT NULL default '',\n        zone integer UNSIGNED NOT NULL default 0,\n        postal_code varchar(255) NOT NULL default '',\n        country integer UNSIGNED NOT NULL default '',\n        PRIMARY KEY (tid)\n      );");
      $ret[] = update_sql("CREATE TABLE {uc_quote_product_locations} (\n        nid integer UNSIGNED NOT NULL default 0,\n        first_name varchar(255) NOT NULL default '',\n        last_name varchar(255) NOT NULL default '',\n        company varchar(255) NOT NULL default '',\n        address1 varchar(255) NOT NULL default '',\n        address2 varchar(255) NOT NULL default '',\n        city varchar(255) NOT NULL default '',\n        zone integer UNSIGNED NOT NULL default 0,\n        postal_code varchar(255) NOT NULL default '',\n        country integer UNSIGNED NOT NULL default '',\n        PRIMARY KEY (nid)\n      );");
      break;
  }
  return $ret;
}