lcase tname

[quix0rs-gnu-social.git] / classes / Profile.php

diff --git a/classes/Profile.php b/classes/Profile.php
index f41acad4c89aa1d563cf2603f7cf75a791a15788..5f88caf2c41dea018614fd772b9365ff1d31f57c 100644 (file)
--- a/classes/Profile.php
+++ b/classes/Profile.php
@@ -31,12 +31,12 @@ class Profile extends DB_DataObject
 
     public $__table = 'profile';                         // table name
     public $id;                              // int(4)  primary_key not_null
-    public $nickname;                        // varchar(64)   not_null
-    public $fullname;                        // varchar(255)  
+    public $nickname;                        // varchar(64)  multiple_key not_null
+    public $fullname;                        // varchar(255)  multiple_key
     public $profileurl;                      // varchar(255)  
-    public $homepage;                        // varchar(255)  
-    public $bio;                             // varchar(140)  
-    public $location;                        // varchar(255)  
+    public $homepage;                        // varchar(255)  multiple_key
+    public $bio;                             // varchar(140)  multiple_key
+    public $location;                        // varchar(255)  multiple_key
     public $created;                         // datetime()   not_null
     public $modified;                        // timestamp()   not_null default_CURRENT_TIMESTAMP
 
@@ -133,7 +133,7 @@ class Profile extends DB_DataObject
                }
                return true;
        }
-       
+
        function getBestName() {
                return ($this->fullname) ? $this->fullname : $this->nickname;
        }
@@ -145,7 +145,7 @@ class Profile extends DB_DataObject
                if ($dt) {
                        $notice->whereAdd('created < "' . $dt . '"');
                }
-               $notice->orderBy('created DESC');
+               $notice->orderBy('created DESC, notice.id DESC');
                $notice->limit(1);
                if ($notice->find(true)) {
                        return $notice;