function memcache_install in Memcache API and Integration 5.2

Same name and namespace in other branches

1. 5 memcache.install \memcache_install()

Add serialized field to cache tables.

File

./memcache.install, line 6

Code

function memcache_install() {
  switch ($GLOBALS['db_type']) {
    case 'pgsql':

      //db_add_column($ret, 'cache', 'serialized', 'int(1)', array('default' => "'0'", 'not null' => TRUE));

      //db_add_column($ret, 'cache_filter', 'serialized', 'int(1)', array('default' => "'0'", 'not null' => TRUE));

      //db_add_column($ret, 'cache_page', 'serialized', 'int(1)', array('default' => "'0'", 'not null' => TRUE));

      //db_add_column($ret, 'cache_menu', 'serialized', 'int(1)', array('default' => "'0'", 'not null' => TRUE));
      break;
    case 'mysql':
    case 'mysqli':
      db_query("ALTER TABLE {cache} ADD serialized int(1) NOT NULL default '0'");
      db_query("ALTER TABLE {cache_filter} ADD serialized int(1) NOT NULL default '0'");
      db_query("ALTER TABLE {cache_page} ADD serialized int(1) NOT NULL default '0'");
      db_query("ALTER TABLE {cache_menu} ADD serialized int(1) NOT NULL default '0'");
      if (db_table_exists('cache_views')) {
        db_query("ALTER TABLE {cache_views} ADD serialized int(1) NOT NULL default '0'");
      }
      if (db_table_exists('cache_blocks')) {
        db_query("ALTER TABLE {cache_blocks} ADD serialized int(1) NOT NULL default '0'");
      }
      if (db_table_exists('cache_content')) {
        db_query("ALTER TABLE {cache_content} ADD serialized int(1) NOT NULL default '0'");
      }
      if (db_table_exists('cache_reptag')) {
        db_query("ALTER TABLE {cache_reptag} ADD serialized int(1) NOT NULL default '0'");
      }
      break;
  }
}