utf8mb4 conversion on database with index adjusts

[quix0rs-gnu-social.git] / plugins / Blog / classes / Blog_entry.php

diff --git a/plugins/Blog/classes/Blog_entry.php b/plugins/Blog/classes/Blog_entry.php
index 20bf4da83f6f12bdd98dbd16b4ab7cfecb6ab472..557e50759be04fe4bcc58fcf97132eb508083a03 100644 (file)
--- a/plugins/Blog/classes/Blog_entry.php
+++ b/plugins/Blog/classes/Blog_entry.php
@@ -51,11 +51,11 @@ class Blog_entry extends Managed_DataObject
 
     public $id; // UUID
     public $profile_id; // int
-    public $title; // varchar(255)
+    public $title; // varchar(191)   not 255 because utf8mb4 takes more space
     public $summary; // text
     public $content; // text
-    public $uri; // text
-    public $url; // text
+    public $uri; // varchar(191)   not 255 because utf8mb4 takes more space
+    public $url; // varchar(191)   not 255 because utf8mb4 takes more space
     public $created; // datetime
     public $modified; // datetime
 
@@ -74,17 +74,17 @@ class Blog_entry extends Managed_DataObject
                                       'not null' => true,
                                       'description' => 'Author profile ID'),
                 'title' => array('type' => 'varchar',
-                                 'length' => 255,
+                                 'length' => 191,
                                  'description' => 'title of the entry'),
                 'summary' => array('type' => 'text',
                                    'description' => 'initial summary'),
                 'content' => array('type' => 'text',
                                    'description' => 'HTML content of the entry'),
                 'uri' => array('type' => 'varchar',
-                               'length' => 255,
+                               'length' => 191,
                                'description' => 'URI (probably http://) for this entry'),
                 'url' => array('type' => 'varchar',
-                               'length' => 255,
+                               'length' => 191,
                                'description' => 'URL (probably http://) for this entry'),
                 'created' => array('type' => 'datetime',
                                    'not null' => true,
@@ -97,12 +97,13 @@ class Blog_entry extends Managed_DataObject
             'unique keys' => array(
                 'blog_entry_uri_key' => array('uri'),
             ),
-            'foreign keys' => array(
-                'blog_entry_profile_id_fkey' => array('profile', array('profile_id' => 'id')),
-            ),
             'indexes' => array(
+                'blog_entry_profile_id_idx' => array('profile_id'),
                 'blog_entry_created_idx' => array('created')
             ),
+            'foreign keys' => array(
+                'blog_entry_profile_id_fkey' => array('profile', array('profile_id' => 'id')),
+            ),
         );
     }