buddylist.install

<?php// $Id: buddylist.install,v 1.1.2.6 2006/08/22 21:26:33 robertDouglass Exp $/** * Install the initial schema. */function buddylist_install() {  switch ($GLOBALS['db_type']) {    case 'mysql':    case 'mysqli':      $query1 = db_query(  <<<MYSQL_UPDATE    CREATE TABLE {buddylist} (      uid int(10) unsigned NOT NULL default '0',      buddy int(10) unsigned NOT NULL default '0',      timestamp int(11) NOT NULL default '0',      received tinyint(1) NOT NULL default '0',      PRIMARY KEY  (uid,buddy)    ) /*!40100 DEFAULT CHARACTER SET utf8 */;MYSQL_UPDATE      );      $query2 = db_query(  <<<MYSQL_UPDATE    CREATE TABLE {buddylist_buddy_group} (      uid int(11) NOT NULL default '0',      buddy int(11) NOT NULL default '0',      label_id int(11) NOT NULL default '0',  PRIMARY KEY  (uid, buddy, label_id)) /*!40100 DEFAULT CHARACTER SET utf8 */;MYSQL_UPDATE      );      $query3 = db_query(  <<<MYSQL_UPDATE    CREATE TABLE {buddylist_groups} (      uid int(11) NOT NULL default '0',      label_id int(11) NOT NULL default '0',      label varchar(255) NOT NULL default '',      visible tinyint(1) NOT NULL default '0',    PRIMARY KEY  (uid, label_id)    ) /*!40100 DEFAULT CHARACTER SET utf8 */;MYSQL_UPDATE      );      if ($query1 && $query2 && $query3) { 	      $created = TRUE; 	    }      break;  }  if ($created) {    drupal_set_message(t('Buddylist module installed successfully.'));  }  else {    drupal_set_message(t('Table installation for the Buddylist module was unsuccessful. The tables may need to be installed by hand. See the README.txt file for a list of the installation queries.'), 'error');  }  if (!module_exists('profile')) {    drupal_set_message(t("The Buddylist module isn't fully functional without the profile module enabled."), 'error');  }}function buddylist_update_1() {  return _system_update_utf8(array('buddylist'));}