modules/smsgateway/smsgateway.install

<?php

function smsgateway_install()
{
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      $ret1 = db_query('
         CREATE TABLE {smslog} (
         sid int(10) NOT NULL auto_increment,
         direction varchar(3) NOT NULL,
         number varchar(20) NOT NULL,
         message text default NULL,
         response varchar(128) default NULL,
         `timestamp` int(11) unsigned NOT NULL default 0,
         KEY smslog_timestamp (timestamp),
         PRIMARY KEY (sid)) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;
      ');
      $ret2 = $ret1;
      break;

    case 'pgsql':
      $ret1 = db_query('
        CREATE TABLE {smslog} (
        sid serial NOT NULL,
        direction varchar(3) NOT NULL,
        number varchar(20) NOT NULL,
        message text default NULL,
        response varchar(128) default NULL,
        timestamp integer NOT NULL default 0,
        PRIMARY KEY (sid));
      ');
      $ret2 = db_query('CREATE INDEX smslog_timestamp ON {smslog} (timestamp);');
      break;
  }

  if ($ret1 && $ret2) {
    drupal_set_message(t('SMS Gateway module installed succesfully.'));
  } else {
    drupal_set_message(t('SMS Gateway module installation was unsuccesfull. Necessary database tables should be created by hand.', 'error'));
  }
}

function smsgateway_update_1() {
  return _system_update_utf8( array('smslog'));
}

?>
1	<?php
2
3	function smsgateway_install()
4	{
5	switch ($GLOBALS['db_type']) {
6	case 'mysql':
7	case 'mysqli':
8	$ret1 = db_query('
9	CREATE TABLE {smslog} (
10	sid int(10) NOT NULL auto_increment,
11	direction varchar(3) NOT NULL,
12	number varchar(20) NOT NULL,
13	message text default NULL,
14	response varchar(128) default NULL,
15	`timestamp` int(11) unsigned NOT NULL default 0,
16	KEY smslog_timestamp (timestamp),
17	PRIMARY KEY (sid)) TYPE=MyISAM /!40100 DEFAULT CHARACTER SET utf8 /;
18	');
19	$ret2 = $ret1;
20	break;
21
22	case 'pgsql':
23	$ret1 = db_query('
24	CREATE TABLE {smslog} (
25	sid serial NOT NULL,
26	direction varchar(3) NOT NULL,
27	number varchar(20) NOT NULL,
28	message text default NULL,
29	response varchar(128) default NULL,
30	timestamp integer NOT NULL default 0,
31	PRIMARY KEY (sid));
32	');
33	$ret2 = db_query('CREATE INDEX smslog_timestamp ON {smslog} (timestamp);');
34	break;
35	}
36
37	if ($ret1 && $ret2) {
38	drupal_set_message(t('SMS Gateway module installed succesfully.'));
39	} else {
40	drupal_set_message(t('SMS Gateway module installation was unsuccesfull. Necessary database tables should be created by hand.', 'error'));
41	}
42	}
43
44	function smsgateway_update_1() {
45	return _system_update_utf8( array('smslog'));
46	}
47
48	?>