Changeset 1453

Timestamp:

Sep 27, 2010, 2:26:19 AM (10 years ago)

Author:

teymour

Message:

Uniq md5 filter+query

Location:

cpc/trunk/project

Files:

• config/doctrine/schema.yml (modified) (2 diffs)
• lib/model/doctrine/Alerte.class.php (modified) (1 diff)

cpc/trunk/project/config/doctrine/schema.yml

@@ -662 +662 @@
     query: string
     filter: string
+    query_md5: string(32)
     titre: string 
     confirmed: boolean
@@ -677 +678 @@
   indexes:
     index_uniq:
-      fields: [email, citoyen_id, query, filter]
+      fields: [email, citoyen_id, query_md5]
       type: unique
     

cpc/trunk/project/lib/model/doctrine/Alerte.class.php

@@ -38 +38 @@
     if ($this->citoyen_id)
       $this->confirmed = 1;
+    $this->query_md5 = md5($this->query.$this->filter);
     return parent::save($c);
   }