diff options
Diffstat (limited to 'database')
| -rw-r--r-- | database/database.mysql | 16 | ||||
| -rw-r--r-- | database/updates.inc | 31 |
2 files changed, 44 insertions, 3 deletions
diff --git a/database/database.mysql b/database/database.mysql index 9eace7d52..b1e926325 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -534,10 +534,22 @@ CREATE TABLE role ( CREATE TABLE search_index ( word varchar(50) NOT NULL default '', - lno int(10) unsigned NOT NULL default '0', + sid int(10) unsigned NOT NULL default '0', type varchar(16) default NULL, + fromsid int(10) unsigned NOT NULL default '0', + fromtype varchar(16) default NULL, + score int(10) unsigned default NULL, + KEY sid (sid), + KEY word (word) +) TYPE=MyISAM; + +-- +-- Table structure for table 'search_total' +-- + +CREATE TABLE search_total ( + word varchar(50) NOT NULL default '', count int(10) unsigned default NULL, - KEY lno (lno), KEY word (word) ) TYPE=MyISAM; diff --git a/database/updates.inc b/database/updates.inc index d0f3ffc26..894b825b0 100644 --- a/database/updates.inc +++ b/database/updates.inc @@ -85,7 +85,8 @@ $sql_updates = array( "2004-09-15" => "update_106", "2004-09-17" => "update_107", "2004-10-16" => "update_108", - "2004-10-18" => "update_109" + "2004-10-18" => "update_109", + "2004-10-28: first update since Drupal 4.5.0 release" => "update_110" ); function update_32() { @@ -1921,6 +1922,34 @@ function update_109() { return $ret; } +function update_110() { + $ret = array(); + + // TODO: needs PGSQL version + if ($GLOBALS['db_type'] == 'mysql') { + $ret[] = update_sql('DROP TABLE {search_index}'); + $ret[] = update_sql("CREATE TABLE {search_index} ( + word varchar(50) NOT NULL default '', + sid int(10) unsigned NOT NULL default '0', + type varchar(16) default NULL, + fromsid int(10) unsigned NOT NULL default '0', + fromtype varchar(16) default NULL, + score int(10) unsigned default NULL, + KEY sid (sid), + KEY word (word) + ) TYPE=MyISAM"); + + $ret[] = update_sql("CREATE TABLE {search_total} ( + word varchar(50) NOT NULL default '', + count int(10) unsigned default NULL, + KEY word (word) + ) TYPE=MyISAM"); + + $ret[] = update_sql("DELETE FROM {variable} WHERE name = 'node_cron_last'"); + } + + return $ret; +} function update_sql($sql) { $edit = $_POST["edit"]; |