You are here

Home » API reference » Asset 5 » asset.install

function asset_update_3 in Asset 5

Same name and namespace in other branches
  1. 5.2 asset.install \asset_update_3()

File

./asset.install, line 96

Code

function asset_update_3() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      $ret[] = update_sql("CREATE TABLE {asset_role} (\n        aid int(10) unsigned NOT NULL,\n        rid int(10) unsigned NOT NULL,\n        status tinyint unsigned NOT NULL default '0',\n        PRIMARY KEY  (aid,rid)\n      ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;");
      break;
    case 'pgsql':
      $ret[] = update_sql("CREATE TABLE {asset_role} (\n        aid integer NOT NULL,\n        rid integer NOT NULL,\n        status smallint NOT NULL default '0',\n        PRIMARY KEY  (aid,rid)\n      )");
      break;
  }
  return $ret;
}