modules/buddylist/buddylist.install

<?php
// $Id: buddylist.install,v 1.9 2006/11/29 23:15:38 robertDouglass Exp $

/**
 * Install the initial schema.
 */
function buddylist_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      $query1 = db_query("
    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 */;");

      $query2 = db_query("
    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 */;");

      $query3 = db_query("
    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 */;");
    
      $query4 = db_query("
    CREATE TABLE {buddylist_pending_requests} (
      requester_uid int(11) NOT NULL default '0',
      requestee_uid int(11) NOT NULL default '0',
       received tinyint(1),
    PRIMARY KEY (requester_uid, requestee_uid)
    ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

      if ($query1 && $query2 && $query3 && $query4) {
        $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');
  }
}

function buddylist_update_1() {
  return _system_update_utf8(array('buddylist'));
}

function buddylist_update_2() {
  $ret = array();

  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':  
      $result = update_sql("
        CREATE TABLE {buddylist_pending_requests} (
          requester_uid int(11) NOT NULL default '0',
          requestee_uid int(11) NOT NULL default '0',
          received tinyint(1),
          PRIMARY KEY (requester_uid, requestee_uid)
        ) /*!40100 DEFAULT CHARACTER SET utf8 */;
      ");
      
      $ret[] = $result;
    break;
  }
  
  if ($result['success']) {
    drupal_set_message(t('The database schema update for the Buddylist module was successful.'));
  }
  else {
    drupal_set_message(t('Table database schema update for the Buddylist module was unsuccessful. The schema may need to be updated by hand. See the README.txt file for a list of the installation queries.'), 'error');
  }
  
  return $ret;
}
1	<?php
2	// $Id: buddylist.install,v 1.9 2006/11/29 23:15:38 robertDouglass Exp $
3
4	/**
5	* Install the initial schema.
6	*/
7	function buddylist_install() {
8	switch ($GLOBALS['db_type']) {
9	case 'mysql':
10	case 'mysqli':
11	$query1 = db_query("
12	CREATE TABLE {buddylist} (
13	uid int(10) unsigned NOT NULL default '0',
14	buddy int(10) unsigned NOT NULL default '0',
15	timestamp int(11) NOT NULL default '0',
16	received tinyint(1) NOT NULL default '0',
17	PRIMARY KEY (uid,buddy)
18	) /!40100 DEFAULT CHARACTER SET utf8 /;");
19
20	$query2 = db_query("
21	CREATE TABLE {buddylist_buddy_group} (
22	uid int(11) NOT NULL default '0',
23	buddy int(11) NOT NULL default '0',
24	label_id int(11) NOT NULL default '0',
25	PRIMARY KEY (uid, buddy, label_id)
26	) /!40100 DEFAULT CHARACTER SET utf8 /;");
27
28	$query3 = db_query("
29	CREATE TABLE {buddylist_groups} (
30	uid int(11) NOT NULL default '0',
31	label_id int(11) NOT NULL default '0',
32	label varchar(255) NOT NULL default '',
33	visible tinyint(1) NOT NULL default '0',
34	PRIMARY KEY (uid, label_id)
35	) /!40100 DEFAULT CHARACTER SET utf8 /;");
36
37	$query4 = db_query("
38	CREATE TABLE {buddylist_pending_requests} (
39	requester_uid int(11) NOT NULL default '0',
40	requestee_uid int(11) NOT NULL default '0',
41	received tinyint(1),
42	PRIMARY KEY (requester_uid, requestee_uid)
43	) /!40100 DEFAULT CHARACTER SET utf8 /;");
44
45	if ($query1 && $query2 && $query3 && $query4) {
46	$created = TRUE;
47	}
48	break;
49	}
50	if ($created) {
51	drupal_set_message(t('Buddylist module installed successfully.'));
52	}
53	else {
54	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');
55	}
56	}
57
58	function buddylist_update_1() {
59	return _system_update_utf8(array('buddylist'));
60	}
61
62	function buddylist_update_2() {
63	$ret = array();
64
65	switch ($GLOBALS['db_type']) {
66	case 'mysql':
67	case 'mysqli':
68	$result = update_sql("
69	CREATE TABLE {buddylist_pending_requests} (
70	requester_uid int(11) NOT NULL default '0',
71	requestee_uid int(11) NOT NULL default '0',
72	received tinyint(1),
73	PRIMARY KEY (requester_uid, requestee_uid)
74	) /!40100 DEFAULT CHARACTER SET utf8 /;
75	");
76
77	$ret[] = $result;
78	break;
79	}
80
81	if ($result['success']) {
82	drupal_set_message(t('The database schema update for the Buddylist module was successful.'));
83	}
84	else {
85	drupal_set_message(t('Table database schema update for the Buddylist module was unsuccessful. The schema may need to be updated by hand. See the README.txt file for a list of the installation queries.'), 'error');
86	}
87
88	return $ret;
89	}