diff options
Diffstat (limited to 'database/updates.inc')
| -rw-r--r-- | database/updates.inc | 16 |
1 files changed, 15 insertions, 1 deletions
diff --git a/database/updates.inc b/database/updates.inc index ef53af326..1f200ed55 100644 --- a/database/updates.inc +++ b/database/updates.inc @@ -61,7 +61,8 @@ $sql_updates = array( "2004-05-18" => "update_87", "2004-06-11" => "update_88", "2004-06-18" => "update_89", - "2004-06-27" => "update_90" + "2004-06-27" => "update_90", + "2004-06-30" => "update_91" ); function update_32() { @@ -1128,6 +1129,19 @@ function update_90() { return $ret; } +function update_91() { + $ret = array(); + if ($GLOBALS["db_type"] == "pgsql") { + $ret[] = update_sql("CREATE INDEX node_created ON {node} (created)"); + $ret[] = update_sql("CREATE INDEX node_changed ON {node} (changed)"); + } + else { + $ret[] = update_sql("ALTER TABLE {node} ADD INDEX node_created (created)"); + $ret[] = update_sql("ALTER TABLE {node} ADD INDEX node_changed (changed)"); + } + return $ret; +} + function update_sql($sql) { $edit = $_POST["edit"]; $result = db_query($sql); |