19 |
19 |
20 |
20 |
21 #include <e32base.h> |
21 #include <e32base.h> |
22 |
22 |
23 _LIT( KSelectRow, "SELECT * FROM Activities WHERE ApplicationId=%S AND ActivityName='%S'"); |
23 _LIT( KSelectRow, "SELECT * FROM Activities WHERE ApplicationId=%S AND ActivityName='%S'"); |
24 _LIT( KSelectRows, "SELECT * FROM Activities"); |
24 _LIT( KSelectRows, "SELECT * FROM Activities ORDER BY Timestamp DESC"); |
25 _LIT( KSelectAppRows, "SELECT * FROM Activities WHERE ApplicationId=%S"); |
25 _LIT( KSelectAppRows, "SELECT * FROM Activities WHERE ApplicationId=%S"); |
26 _LIT( KDeleteRow, "DELETE FROM Activities WHERE ApplicationId=%S AND ActivityName='%S'"); |
26 _LIT( KDeleteRow, "DELETE FROM Activities WHERE ApplicationId=%S AND ActivityName='%S'"); |
27 _LIT( KDeleteRows, "DELETE FROM Activities WHERE ApplicationId=%S"); |
27 _LIT( KDeleteRows, "DELETE FROM Activities WHERE ApplicationId=%S"); |
28 _LIT( KDeleteNonPersistentActivities, "DELETE FROM Activities WHERE Flags<%S"); |
28 _LIT( KDeleteNonPersistentActivities, "DELETE FROM Activities WHERE Flags<%S"); |
29 |
29 |
30 _LIT(KApplicationColumnName, "ApplicationId"); |
30 _LIT(KApplicationColumnName, "ApplicationId"); |
31 _LIT(KActivityColumnName, "ActivityName"); |
31 _LIT(KActivityColumnName, "ActivityName"); |
|
32 _LIT(KCustomNameColumnName, "CustomName"); |
32 _LIT(KFlagsColumnName, "Flags"); |
33 _LIT(KFlagsColumnName, "Flags"); |
|
34 _LIT(KTimestampColumnName, "Timestamp"); |
33 _LIT(KDataColumnName, "Data"); |
35 _LIT(KDataColumnName, "Data"); |
34 |
36 |
35 _LIT(KActivityTableName, "Activities"); |
37 _LIT(KActivityTableName, "Activities"); |
36 _LIT(KActivityIndexName, "ActivitiesKey"); |
38 _LIT(KActivityIndexName, "ActivitiesKey"); |
37 #endif // AFQUERIES_H |
39 #endif // AFQUERIES_H |