geshinode.install in GeSHi Filter for syntax highlighting 5.2

File

geshinode.install

<?php

/**
 * Create tables on install
 */
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;
  }
}

/**
 * Remove tables on uninstall.
 */
function geshinode_uninstall() {
  db_query("DROP TABLE {geshinode}");
  drupal_set_message('Removed geshinode database table.');
}

Functions

Name	Description
geshinode_install	Create tables on install
geshinode_uninstall	Remove tables on uninstall.