--- a/activityfw/storage/server/inc/afqueries.h	Wed Aug 18 10:39:24 2010 +0300
+++ b/activityfw/storage/server/inc/afqueries.h	Mon Sep 13 13:26:33 2010 +0300
@@ -21,7 +21,7 @@
 #include <e32base.h>
 
 _LIT( KSelectRow, "SELECT * FROM Activities WHERE ApplicationId=%S AND ActivityName='%S'");
-_LIT( KSelectRows, "SELECT * FROM Activities");
+_LIT( KSelectRows, "SELECT * FROM Activities ORDER BY Timestamp DESC");
 _LIT( KSelectAppRows, "SELECT * FROM Activities WHERE ApplicationId=%S");
 _LIT( KDeleteRow, "DELETE FROM Activities WHERE ApplicationId=%S AND ActivityName='%S'");
 _LIT( KDeleteRows, "DELETE FROM Activities WHERE ApplicationId=%S");
@@ -29,7 +29,9 @@
 
 _LIT(KApplicationColumnName, "ApplicationId");
 _LIT(KActivityColumnName, "ActivityName");
+_LIT(KCustomNameColumnName, "CustomName");
 _LIT(KFlagsColumnName, "Flags");
+_LIT(KTimestampColumnName, "Timestamp");
 _LIT(KDataColumnName, "Data");
 
 _LIT(KActivityTableName, "Activities");