modules/facebook_status/facebook_status.install

<?php
// $Id$
//facebook_status.install
function facebook_status_install() {
  $result = array();
  switch ($GLOBALS['db_type']) {
    case 'mysqli':
    case 'mysql':
      $result[] = db_query("CREATE TABLE {facebook_status} (
        sid int(10) NOT NULL auto_increment,
        status_time int(10) NOT NULL default '0',
        status_fb varchar(255) NOT NULL default '',
        uid int(10) NOT NULL default '0',
        PRIMARY KEY  (sid)
        ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

      break;

    case 'pgsql':
      $result[] = db_query("CREATE TABLE {facebook_status} (
        sid SERIAL,
        status_time integer NOT NULL default '0',
        status_fb varchar(255) NOT NULL default '',
        uid integer NOT NULL default '0',
        PRIMARY KEY  (sid)
        );");
    
      break;

        case 'mssql':
      $result[] = db_query("CREATE TABLE {facebook_status} (
        sid int NOT NULL IDENTITY(1,1),
        status_time int NOT NULL default '0',
        status_fb varchar(255) NOT NULL default '',
        uid int NOT NULL default '0',
        PRIMARY KEY (sid)
        );");

      break;
  }

  if (count($result) != count(array_filter($result))) {
    drupal_set_message(t('The installation of the Facebook Status module was unsuccessful.'), 'error');
  }
}

/**
 * Implementation of hook_uninstall().
 */
function facebook_status_uninstall() {
  db_query('DROP TABLE {facebook_status}');
}
1	<?php
2	// $Id$
3	//facebook_status.install
4	function facebook_status_install() {
5	$result = array();
6	switch ($GLOBALS['db_type']) {
7	case 'mysqli':
8	case 'mysql':
9	$result[] = db_query("CREATE TABLE {facebook_status} (
10	sid int(10) NOT NULL auto_increment,
11	status_time int(10) NOT NULL default '0',
12	status_fb varchar(255) NOT NULL default '',
13	uid int(10) NOT NULL default '0',
14	PRIMARY KEY (sid)
15	) /!40100 DEFAULT CHARACTER SET utf8 /;");
16
17	break;
18
19	case 'pgsql':
20	$result[] = db_query("CREATE TABLE {facebook_status} (
21	sid SERIAL,
22	status_time integer NOT NULL default '0',
23	status_fb varchar(255) NOT NULL default '',
24	uid integer NOT NULL default '0',
25	PRIMARY KEY (sid)
26	);");
27
28	break;
29
30	case 'mssql':
31	$result[] = db_query("CREATE TABLE {facebook_status} (
32	sid int NOT NULL IDENTITY(1,1),
33	status_time int NOT NULL default '0',
34	status_fb varchar(255) NOT NULL default '',
35	uid int NOT NULL default '0',
36	PRIMARY KEY (sid)
37	);");
38
39	break;
40	}
41
42	if (count($result) != count(array_filter($result))) {
43	drupal_set_message(t('The installation of the Facebook Status module was unsuccessful.'), 'error');
44	}
45	}
46
47	/**
48	* Implementation of hook_uninstall().
49	*/
50	function facebook_status_uninstall() {
51	db_query('DROP TABLE {facebook_status}');
52	}