From 3fce53d61703552c4c5a2c671b8adfee8e0ef966 Mon Sep 17 00:00:00 2001
From: webchick <webchick@24967.no-reply.drupal.org>
Date: Mon, 23 May 2011 16:42:32 -0700
Subject: Issue #1154806 by lyricnz, marcingy, Starminder: Fixed Comment Schema
 mismatch after upgrade D6 to D7.

---
 modules/comment/comment.install | 20 ++++++++++++++++++++
 1 file changed, 20 insertions(+)

(limited to 'modules/comment')

diff --git a/modules/comment/comment.install b/modules/comment/comment.install
index 51bfa7453..d64b3acde 100644
--- a/modules/comment/comment.install
+++ b/modules/comment/comment.install
@@ -343,6 +343,26 @@ function comment_update_7007() {
   db_add_index('comment', 'comment_created', array('created'));
 }
 
+/**
+ * Update database to match Drupal 7 schema.
+ */
+function comment_update_7008() {
+  // Update default status to 1.
+  db_change_field('comment', 'status', 'status', array(
+    'type' => 'int',
+    'unsigned' => TRUE,
+    'not null' => TRUE,
+    'default' => 1,
+    'size' => 'tiny',
+  ));
+
+  // Realign indexes.
+  db_drop_index('comment', 'comment_status_pid');
+  db_add_index('comment', 'comment_status_pid', array('pid', 'status'));
+  db_drop_index('comment', 'comment_pid_status');
+  db_drop_index('comment', 'nid');
+}
+
 /**
  * @} End of "addtogroup updates-6.x-to-7.x"
  */
-- 
cgit v1.2.3