modules/resultcache/resultcache.install

<?php
/* $Id: resultcache.install,v 1.1 2006/12/15 22:46:15 alexb Exp $ */

function resultcache_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysqli':
    case 'mysql':
      db_query("DROP TABLE {cache_result}");
      db_query("CREATE TABLE {cache_result} (
        `crid` int(10) NOT NULL AUTO_INCREMENT,
        `lastused` int(11) NOT NULL default '0',
        `lastupdated` int(11) NOT NULL default '0',
        `function` varchar(255) NOT NULL default '',
        `arguments` LONGTEXT NOT NULL,
        `result` longtext,
        `createlapse` FLOAT,
        `retrievelapse` FLOAT,
        INDEX `function` (`function`),
        INDEX `arguments` (`arguments`(255)),
        PRIMARY KEY `crid` (`crid`)
      )DEFAULT CHARACTER SET utf8");

      $success = TRUE;
      break;
    case 'pgsql':

      break;
    default:
      break;
  } // End case

  if ($success) {
    drupal_set_message(t('Result Cache module installed tables successfully.'));
  }
  else {
    drupal_set_message(t('The installation of Result Cache module was unsuccessful.'), 'error');
  }
}
?>
1	<?php
2	/* $Id: resultcache.install,v 1.1 2006/12/15 22:46:15 alexb Exp $ */
3
4	function resultcache_install() {
5	switch ($GLOBALS['db_type']) {
6	case 'mysqli':
7	case 'mysql':
8	db_query("DROP TABLE {cache_result}");
9	db_query("CREATE TABLE {cache_result} (
10	`crid` int(10) NOT NULL AUTO_INCREMENT,
11	`lastused` int(11) NOT NULL default '0',
12	`lastupdated` int(11) NOT NULL default '0',
13	`function` varchar(255) NOT NULL default '',
14	`arguments` LONGTEXT NOT NULL,
15	`result` longtext,
16	`createlapse` FLOAT,
17	`retrievelapse` FLOAT,
18	INDEX `function` (`function`),
19	INDEX `arguments` (`arguments`(255)),
20	PRIMARY KEY `crid` (`crid`)
21	)DEFAULT CHARACTER SET utf8");
22
23	$success = TRUE;
24	break;
25	case 'pgsql':
26
27	break;
28	default:
29	break;
30	} // End case
31
32	if ($success) {
33	drupal_set_message(t('Result Cache module installed tables successfully.'));
34	}
35	else {
36	drupal_set_message(t('The installation of Result Cache module was unsuccessful.'), 'error');
37	}
38	}
39	?>