Changeset 2000

Timestamp:

06/22/10 15:23:02 (3 years ago)

Author:

shibuya246

Message:

[Branch 1.4] change post_title column from navchar to text

Location:

branches/1.4/install

Files:

• install-upgrade.php (modified) (1 diff)
• install_tables.php (modified) (1 diff)

branches/1.4/install/install-upgrade.php

@@ -685 +685 @@
             // Add index for siteid on pluginhooks table
             $sql = "SHOW INDEX FROM `" . TABLE_PLUGINHOOKS . "` WHERE KEY_NAME = 'pluginhooks_siteid'";
-                    $result = $h->db->query($sql);
-                    if (!$result) {
-                            $sql = "ALTER TABLE `" . TABLE_PLUGINHOOKS . "` ADD INDEX (pluginhooks_siteid)";
-                            $h->db->query($sql);
-                    }
+            $result = $h->db->query($sql);
+            if (!$result) {
+                    $sql = "ALTER TABLE `" . TABLE_PLUGINHOOKS . "` ADD INDEX (pluginhooks_siteid)";
+                    $h->db->query($sql);
+            }
+
+            // Change post_title column from `post_title` varchar(255) NULL, to `post_title` text NULL,
+            $exists = $h->db->column_exists('posts', 'post_title');
+            if (!$exists) {
+                    $sql = "ALTER TABLE " . TABLE_POSTS . " MODIFY post_title text NUL";
+                    $h->db->query($h->db->prepare($sql));
+            }
 
         }

branches/1.4/install/install_tables.php

@@ -300 +300 @@
                         `post_category` int(20) NOT NULL DEFAULT 1,
                         `post_tags` text NULL,
-                        `post_title` varchar(255) NULL, 
+                        `post_title` text NULL,
                         `post_orig_url` varchar(255) NULL, 
                         `post_domain` varchar(255) NULL,