Home › MySite API

mysite_icon_install

Definition

mysite_icon_install()
mysite_icon/mysite_icon.install, line 6

Description

Implementation of hook_install()

Code

function mysite_icon_install() {
  $success = FALSE;
  drupal_set_message(t('Installing the MySite Icons module'));
  switch ($GLOBALS['db_type']) {
    case 'mysqli':
    case 'mysql':
      $sql = "CREATE TABLE {mysite_icon} (
        iid int(11) NOT NULL default '0',
        type varchar(40) NOT NULL default '',
        type_id int(10) NOT NULL default '0',
        icon varchar(80) NOT NULL default '',
        PRIMARY KEY  (iid),
        UNIQUE KEY icon (icon),
        KEY type (type),
        KEY type_id (type_id)
      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ";
      db_query($sql);
      $success = TRUE;
      break;

    case 'pgsql':
      $sql = "CREATE TABLE {mysite_icon} (
        iid integer NOT NULL default '0',
        type varchar(40) NOT NULL default '',
        type_id integer NOT NULL default '0',
        icon varchar(80) NOT NULL default '',
        PRIMARY KEY (iid),
        UNIQUE (icon)
      )";
      db_query($sql);
      db_query("CREATE INDEX {mysite_icon}_type_idx ON {mysite_data} (type)");
      db_query("CREATE INDEX {mysite_icon}_typeid_idx ON {mysite_data} (type_id)");
      $success = TRUE;
      break;
  }
  if ($success) {
    drupal_set_message(t('MySite Icons module installed successfully.'));
  }
  else {
    drupal_set_message(t('The installation of the MySite Icons module was unsuccessful.'), 'error');
  }
}