modules/blockcache/blockcache.install

<?php

function blockcache_install(){
    switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {bc_blocks} (
        my_delta int(10) NOT NULL,
        module varchar(40) NOT NULL,
        mod_delta varchar(40) NOT NULL,
        PRIMARY KEY  (my_delta)
      ) /*!40100 DEFAULT CHARACTER SET utf8 */;");
      break;
    }
  drupal_set_message(t('Database table for Block Cache module has been installed.'));
}

/*
CREATE TABLE bc_blocks (
  my_delta int(10) NOT NULL,
  module varchar(40) NOT NULL,
  mod_delta int(10) NOT NULL,
  PRIMARY KEY  (my_delta)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
*/
1	<?php
2
3	function blockcache_install(){
4	switch ($GLOBALS['db_type']) {
5	case 'mysql':
6	case 'mysqli':
7	db_query("CREATE TABLE {bc_blocks} (
8	my_delta int(10) NOT NULL,
9	module varchar(40) NOT NULL,
10	mod_delta varchar(40) NOT NULL,
11	PRIMARY KEY (my_delta)
12	) /!40100 DEFAULT CHARACTER SET utf8 /;");
13	break;
14	}
15	drupal_set_message(t('Database table for Block Cache module has been installed.'));
16	}
17
18	/*
19	CREATE TABLE bc_blocks (
20	my_delta int(10) NOT NULL,
21	module varchar(40) NOT NULL,
22	mod_delta int(10) NOT NULL,
23	PRIMARY KEY (my_delta)
24	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
25	*/