function uc_catalog_update_1 in Ubercart 5

File

uc_catalog/uc_catalog.install, line 68

Code

function uc_catalog_update_1() {
  $ret = array();
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      $ret[] = update_sql("CREATE TABLE IF NOT EXISTS {uc_catalog_images} (\n        `fid` int(10) unsigned NOT NULL default '0',\n        `tid` int(10) unsigned NOT NULL default '0',\n        `filename` varchar(255) NOT NULL default '',\n        `filepath` varchar(255) NOT NULL default '',\n        `filemime` varchar(255) NOT NULL default '',\n        `filesize` int(10) unsigned NOT NULL default '0',\n        PRIMARY KEY  (`fid`)\n      );");
      break;
    case 'pgsql':
      $ret[] = update_sql("CREATE TABLE IF NOT EXISTS {uc_catalog_images} (\n        fid integer unsigned NOT NULL default 0,\n        tid integer unsigned NOT NULL default 0,\n        filename varchar(255) NOT NULL default '',\n        filepath varchar(255) NOT NULL default '',\n        filemime varchar(255) NOT NULL default '',\n        filesize integer unsigned NOT NULL default 0,\n        PRIMARY KEY  (fid)\n      );");
      break;
  }
  return $ret;
}