commit c2543da57fb6c90de4fa2de90db2df7f539f0483
author Fred Quintana <fredq@google.com> Mon Aug 24 14:13:52 2009 -0700
committer Fred Quintana <fredq@google.com> Mon Aug 24 14:13:52 2009 -0700
tree f33d756212114dbf8eb6e2ffe7499170002d69c2
parent e84f2475ec53a588c8c3461d28d3d8654ee74010

make the data version trigger happen before the update

src/com/android/providers/contacts/OpenHelper.java

diff --git a/src/com/android/providers/contacts/OpenHelper.java b/src/com/android/providers/contacts/OpenHelper.java
index d555aa3..98688ea 100644
--- a/src/com/android/providers/contacts/OpenHelper.java
+++ b/src/com/android/providers/contacts/OpenHelper.java
@@ -58,7 +58,7 @@
 /* package */ class OpenHelper extends SQLiteOpenHelper {
     private static final String TAG = "OpenHelper";
 
-    private static final int DATABASE_VERSION = 73;
+    private static final int DATABASE_VERSION = 74;
 
     private static final String DATABASE_NAME = "contacts2.db";
     private static final String DATABASE_PRESENCE = "presence_db";
@@ -689,7 +689,7 @@
                 + "       AND NEW." + RawContacts.DELETED + "!= OLD." + RawContacts.DELETED + ";"
                 + " END");
 
-        db.execSQL("CREATE TRIGGER " + Tables.DATA + "_updated AFTER UPDATE ON " + Tables.DATA
+        db.execSQL("CREATE TRIGGER " + Tables.DATA + "_updated BEFORE UPDATE ON " + Tables.DATA
                 + " BEGIN "
                 + "   UPDATE " + Tables.DATA
                 + "     SET " + Data.DATA_VERSION + "=OLD." + Data.DATA_VERSION + "+1 "