X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=classes%2FAttention.php;h=c15a118e122f7a6f397b2323a8684c4094f20f14;hb=13c331fa8152f11a811d2ff66210b3298bc21ada;hp=d152ff892aa053878c58d17019822d637732c665;hpb=bed8cc48bc2baa1a295c67f34bbfbcf5344b6ec4;p=quix0rs-gnu-social.git

diff --git a/classes/Attention.php b/classes/Attention.php
index d152ff892a..c15a118e12 100644
--- a/classes/Attention.php
+++ b/classes/Attention.php
@@ -22,7 +22,7 @@ class Attention extends Managed_DataObject
     public $__table = 'attention';  // table name
     public $notice_id;              // int(4) primary_key not_null
     public $profile_id;             // int(4) primary_key not_null
-    public $reason;                 // varchar(255)
+    public $reason;                 // varchar(191)   not 255 because utf8mb4 takes more space
     public $created;                // datetime()   not_null
     public $modified;               // timestamp   not_null default_CURRENT_TIMESTAMP
 
@@ -33,7 +33,7 @@ class Attention extends Managed_DataObject
             'fields' => array(
                 'notice_id' => array('type' => 'int', 'not null' => true, 'description' => 'notice_id to give attention'),
                 'profile_id' => array('type' => 'int', 'not null' => true, 'description' => 'profile_id for feed receiver'),
-                'reason' => array('type' => 'varchar', 'length' => 255, 'description' => 'Optional reason why this was brought to the attention of profile_id'),
+                'reason' => array('type' => 'varchar', 'length' => 191, 'description' => 'Optional reason why this was brought to the attention of profile_id'),
                 'created' => array('type' => 'datetime', 'not null' => true, 'description' => 'date this record was created'),
                 'modified' => array('type' => 'timestamp', 'not null' => true, 'description' => 'date this record was modified'),
             ),
@@ -56,6 +56,7 @@ class Attention extends Managed_DataObject
         $att->notice_id = $notice->getID();
         $att->profile_id = $profile->getID();
         $att->reason = $reason;
+        $att->created = common_sql_now();
         $result = $att->insert();
 
         if ($result === false) {