diff options
| author |  Alexandre Alapetite <alexandre@alapetite.fr>
| 2013-11-27 22:50:00 +0100 |
|---|---|---|
| committer | Alexandre Alapetite <alexandre@alapetite.fr>
| 2013-11-27 22:50:00 +0100 |
| commit | 4355d8447f8e9073f4d96a35b280bad5ba793e32 (patch) | |
| tree | 8547c01168bb90dafd9d2e619b7b9c65ead44d88 /app/models/Entry.php | |
| parent | 91bf307d49b5494e0257bd9bb064c9369d3df6a5 (diff) | |
SQL : Passe e.id en bigint plutôt que char(6)
Contribue à https://github.com/marienfressinaud/FreshRSS/issues/202
e.id est généré à l'insertion par microtime(true).
Diffstat (limited to 'app/models/Entry.php')
| -rwxr-xr-x | app/models/Entry.php | 12 |
1 files changed, 4 insertions, 8 deletions
diff --git a/app/models/Entry.php b/app/models/Entry.php index abf381a9b..c5ff6ab60 100755 --- a/app/models/Entry.php +++ b/app/models/Entry.php @@ -2,7 +2,7 @@ class Entry extends Model { - private $id = null; + private $id = 0; private $guid; private $title; private $author; @@ -29,11 +29,7 @@ class Entry extends Model { } public function id () { - if(is_null($this->id)) { - return small_hash ($this->guid . Configuration::selApplication ()); - } else { - return $this->id; - } + return $this->id; } public function guid () { return $this->guid; @@ -195,11 +191,11 @@ class Entry extends Model { class EntryDAO extends Model_pdo { public function addEntry ($valuesTmp) { - $sql = 'INSERT INTO ' . $this->prefix . 'entry(id, guid, title, author, content, link, date, is_read, is_favorite, id_feed, tags) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'; + $sql = 'INSERT INTO ' . $this->prefix . 'entry(id, guid, title, author, content, link, date, is_read, is_favorite, id_feed, tags) VALUES(CAST(? * 1000000 AS SIGNED INTEGER), ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'; $stm = $this->bd->prepare ($sql); $values = array ( - $valuesTmp['id'], + microtime(true), substr($valuesTmp['guid'], 0, 760), substr($valuesTmp['title'], 0, 255), substr($valuesTmp['author'], 0, 255), |