#208938 by bjaspan, scor: use schema PI for index updates instead of database dependent code

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;
 }