X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=classes%2FDeleted_notice.php;h=a9167f19a48ee2c5069123567562dfcc13d1e70f;hb=2f86cd860231f92213950d439e9a109b7a5f11c4;hp=4c17be185a0ff438fe34004dc0fb28d0c7d9f9cd;hpb=f5bb0431da4d3e62d1ddf76da9651e57f2f5c6dd;p=quix0rs-gnu-social.git

diff --git a/classes/Deleted_notice.php b/classes/Deleted_notice.php
index 4c17be185a..a9167f19a4 100644
--- a/classes/Deleted_notice.php
+++ b/classes/Deleted_notice.php
@@ -34,7 +34,7 @@ class Deleted_notice extends Managed_DataObject
     public $__table = 'deleted_notice';                  // table name
     public $id;                              // int(4)  primary_key not_null
     public $profile_id;                      // int(4)   not_null
-    public $uri;                             // varchar(255)  unique_key
+    public $uri;                             // varchar(191)  unique_key   not 255 because utf8mb4 takes more space
     public $created;                         // datetime()   not_null
     public $deleted;                         // datetime()   not_null
 
@@ -47,7 +47,7 @@ class Deleted_notice extends Managed_DataObject
             'fields' => array(
                 'id' => array('type' => 'int', 'not null' => true, 'description' => 'identity of notice'),
                 'profile_id' => array('type' => 'int', 'not null' => true, 'description' => 'author of the notice'),
-                'uri' => array('type' => 'varchar', 'length' => 255, 'description' => 'universally unique identifier, usually a tag URI'),
+                'uri' => array('type' => 'varchar', 'length' => 191, 'description' => 'universally unique identifier, usually a tag URI'),
                 'created' => array('type' => 'datetime', 'not null' => true, 'description' => 'date the notice record was created'),
                 'deleted' => array('type' => 'datetime', 'not null' => true, 'description' => 'date the notice record was created'),
             ),