function geshinode_install in GeSHi Filter for syntax highlighting 5.2

Same name and namespace in other branches

1. 6 geshinode.install \geshinode_install()

Create tables on install

File

./geshinode.install, line 6

Code

function geshinode_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {geshinode} (\n        vid int unsigned NOT NULL default '0',\n        nid int unsigned NOT NULL default '0',\n        language VARCHAR(64) NOT NULL default '',\n        PRIMARY KEY (nid, vid),\n        UNIQUE KEY vid (vid),\n        KEY nid (nid)\n        ) /*!40100 DEFAULT CHARACTER SET utf8 */;");
      drupal_set_message('Installed geshinode database table.');
      break;
    case 'pgsql':
      db_query("CREATE TABLE {geshinode} (\n        vid int unsigned NOT NULL default '0',\n        nid int unsigned NOT NULL default '0',\n        language VARCHAR(64) NOT NULL default '',\n        PRIMARY KEY (nid, vid),\n        UNIQUE (vid)\n        );");
      db_query("CREATE INDEX {geshinode}_nid_idx ON {geshinode} (nid)");
      drupal_set_message('Installed geshinode database table.');
      break;
    default:
      drupal_set_message(t('Unsupported database.'), 'error');
      break;
  }
}