diff options
| -rw-r--r-- | modules/comment/comment.install | 3 | ||||
| -rw-r--r-- | modules/system/system.install | 22 |
2 files changed, 4 insertions, 21 deletions
diff --git a/modules/comment/comment.install b/modules/comment/comment.install index 7da948b0e..959d63732 100644 --- a/modules/comment/comment.install +++ b/modules/comment/comment.install @@ -62,7 +62,8 @@ function comment_update_6002() { * Add index to parent ID field. */ function comment_update_6003() { - $ret[] = update_sql("ALTER TABLE {comments} ADD KEY pid (pid)"); + $ret = array(); + db_add_index($ret, 'comments', 'pid', array('pid')); return $ret; } diff --git a/modules/system/system.install b/modules/system/system.install index 4e7922b00..cae51cbde 100644 --- a/modules/system/system.install +++ b/modules/system/system.install @@ -1114,16 +1114,7 @@ function system_update_last_removed() { */ function system_update_1022() { $ret = array(); - switch ($GLOBALS['db_type']) { - case 'mysql': - case 'mysqli': - $ret[] = update_sql('ALTER TABLE {users} ADD KEY created (created)'); - break; - - case 'pgsql': - $ret[] = update_sql("CREATE INDEX {users}_created_idx ON {users} (created)"); - break; - } + db_add_index($ret, 'users', 'created', array('created')); // Also appears as system_update_6004(). Ensure we don't update twice. variable_set('system_update_1022', TRUE); return $ret; @@ -1187,16 +1178,7 @@ function system_update_6002() { */ function system_update_6003() { $ret = array(); - switch ($GLOBALS['db_type']) { - case 'mysql': - case 'mysqli': - $ret[] = update_sql('ALTER TABLE {comments} ADD KEY status (status)'); - break; - - case 'pgsql': - $ret[] = update_sql("CREATE INDEX {comments}_status_idx ON {comments} (status)"); - break; - } + db_add_index($ret, 'comments', 'status', array('status')); return $ret; } |