Lines Matching defs:MessageColumns
208 public static class MessageColumns implements BaseColumns {
272 + MessageColumns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT, "
273 + MessageColumns.CONVERSATION_ID + " INT, "
274 + MessageColumns.SENDER_PARTICIPANT_ID + " INT, "
275 + MessageColumns.SENT_TIMESTAMP + " INT DEFAULT(0), "
276 + MessageColumns.RECEIVED_TIMESTAMP + " INT DEFAULT(0), "
277 + MessageColumns.PROTOCOL + " INT DEFAULT(0), "
278 + MessageColumns.STATUS + " INT DEFAULT(0), "
279 + MessageColumns.SEEN + " INT DEFAULT(0), "
280 + MessageColumns.READ + " INT DEFAULT(0), "
281 + MessageColumns.SMS_MESSAGE_URI + " TEXT, "
282 + MessageColumns.SMS_PRIORITY + " INT DEFAULT(0), "
283 + MessageColumns.SMS_MESSAGE_SIZE + " INT DEFAULT(0), "
284 + MessageColumns.MMS_SUBJECT + " TEXT, "
285 + MessageColumns.MMS_TRANSACTION_ID + " TEXT, "
286 + MessageColumns.MMS_CONTENT_LOCATION + " TEXT, "
287 + MessageColumns.MMS_EXPIRY + " INT DEFAULT(0), "
288 + MessageColumns.RAW_TELEPHONY_STATUS + " INT DEFAULT(0), "
289 + MessageColumns.SELF_PARTICIPANT_ID + " INT, "
290 + MessageColumns.RETRY_START_TIMESTAMP + " INT DEFAULT(0), "
291 + "FOREIGN KEY (" + MessageColumns.CONVERSATION_ID + ") REFERENCES "
293 + "FOREIGN KEY (" + MessageColumns.SENDER_PARTICIPANT_ID + ") REFERENCES "
295 + "FOREIGN KEY (" + MessageColumns.SELF_PARTICIPANT_ID + ") REFERENCES "
302 + MessageColumns.CONVERSATION_ID + ", "
303 + MessageColumns.STATUS + ", "
304 + MessageColumns.RECEIVED_TIMESTAMP + ")";
308 + MessageColumns.STATUS + ", "
309 + MessageColumns.SEEN + ")";
356 + MESSAGES_TABLE + "(" + MessageColumns._ID + ") ON DELETE CASCADE "
367 + "." + MessageColumns._ID + "=" + "NEW." + PartColumns.MESSAGE_ID + ")"
373 + MessageColumns.RECEIVED_TIMESTAMP + " ON " + MESSAGES_TABLE
375 + " = NEW." + MessageColumns.RECEIVED_TIMESTAMP + " WHERE " + PARTS_TABLE + "."
376 + PartColumns.MESSAGE_ID + " = NEW." + MessageColumns._ID
522 + MESSAGES_TABLE + '.' + MessageColumns.CONVERSATION_ID
523 + " as " + MessageColumns.CONVERSATION_ID + " "
525 + MESSAGES_TABLE + "." + MessageColumns._ID
528 + " WHERE " + MESSAGES_TABLE + "." + MessageColumns.STATUS
