[Sommaire] [Imprimer]

   1  <?php
   2  // $Id: search.install,v 1.6.2.1 2007/09/30 01:13:23 drumm Exp $
   3  
   4  /**
   5   * Implementation of hook_install().
   6   */
   7  function search_install() {
   8    switch ($GLOBALS['db_type']) {
   9      case 'mysql':
  10      case 'mysqli':
  11        db_query("CREATE TABLE {search_dataset} (
  12          sid int unsigned NOT NULL default '0',
  13          type varchar(16) default NULL,
  14          data longtext NOT NULL,
  15          KEY sid_type (sid, type)
  16        ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
  17  
  18        db_query("CREATE TABLE {search_index} (
  19          word varchar(50) NOT NULL default '',
  20          sid int unsigned NOT NULL default '0',
  21          type varchar(16) default NULL,
  22          fromsid int unsigned NOT NULL default '0',
  23          fromtype varchar(16) default NULL,
  24          score float default NULL,
  25          KEY sid_type (sid, type),
  26          KEY from_sid_type (fromsid, fromtype),
  27          KEY word (word)
  28        ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
  29  
  30        db_query("CREATE TABLE {search_total} (
  31          word varchar(50) NOT NULL default '',
  32          count float default NULL,
  33          PRIMARY KEY (word)
  34        ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
  35        break;
  36      case 'pgsql':
  37        db_query("CREATE TABLE {search_dataset} (
  38          sid int_unsigned NOT NULL default '0',
  39          type varchar(16) default NULL,
  40          data text NOT NULL
  41        )");
  42        db_query("CREATE INDEX {search_dataset}_sid_type_idx ON {search_dataset} (sid, type)");
  43  
  44        db_query("CREATE TABLE {search_index} (
  45          word varchar(50) NOT NULL default '',
  46          sid int_unsigned NOT NULL default '0',
  47          type varchar(16) default NULL,
  48          fromsid int_unsigned NOT NULL default '0',
  49          fromtype varchar(16) default NULL,
  50          score float default NULL
  51        )");
  52        db_query("CREATE INDEX {search_index}_sid_type_idx ON {search_index} (sid, type)");
  53        db_query("CREATE INDEX {search_index}_from_sid_type_idx ON {search_index} (fromsid, fromtype)");
  54        db_query("CREATE INDEX {search_index}_word_idx ON {search_index} (word)");
  55  
  56        db_query("CREATE TABLE {search_total} (
  57          word varchar(50) NOT NULL default '',
  58          count float default NULL,
  59          PRIMARY KEY (word)
  60        )");
  61        break;
  62    }
  63  }
  64  
  65  /**
  66   * Implementation of hook_uninstall().
  67   */
  68  function search_uninstall() {
  69    db_query('DROP TABLE {search_dataset}');
  70    db_query('DROP TABLE {search_index}');
  71    db_query('DROP TABLE {search_total}');
  72    variable_del('minimum_word_size');
  73    variable_del('overlap_cjk');
  74    variable_del('search_cron_limit');
  75  }