Ye2Jmzvt

1package com.messaging.chatify.Schema;
2
3public class Messages {
4    public static final String TABLE_MESSAGES = "chats";
5    public static final String MESSAGE_ID = "_id";
6    public static final String MESSAGE_TEXT = "text";
7    public static final String MESSAGE_ATTACHMENT = "attachement";
8    public static final String MESSAGE_SENDER = "msgfrom";
9    public static final String MESSAGE_RECEIVER = "msgto";
10    public static final String MESSAGE_ISREAD = "isRead";
11    public static final String MESSAGE_TIME = "mtime";
12
13    public static final String[] ALL_COLUMNS = { MESSAGE_ID, MESSAGE_TEXT, MESSAGE_ATTACHMENT, MESSAGE_SENDER, MESSAGE_RECEIVER, MESSAGE_ISREAD };
14
15    public static final String CREATE_STATEMENT =
16        "CREATE TABLE IF NOT EXISTS " + TABLE_MESSAGES + "(" +
17                MESSAGE_ID + " TEXT PRIMARY KEY, " +
18                MESSAGE_TIME + " TEXT, " +
19                MESSAGE_TEXT + " TEXT, " +
20                MESSAGE_ATTACHMENT + " TEXT, " +
21                MESSAGE_SENDER + " TEXT, " +
22                MESSAGE_RECEIVER + " TEXT, " +
23                MESSAGE_ISREAD + " INTEGER" + ");";
24
25    public static final String DROP_STATEMENT =
26        "DROP TABLE IF EXISTS " + TABLE_MESSAGES;
27}
28	
29public static final String[] ALL_COLUMNS = { MESSAGE_ID, MESSAGE_TEXT, MESSAGE_ATTACHMENT, MESSAGE_SENDER, MESSAGE_RECEIVER, MESSAGE_ISREAD };
30	
31public static final String[] ALL_COLUMNS = { MESSAGE_ID, MESSAGE_TEXT, MESSAGE_ATTACHMENT, MESSAGE_SENDER, MESSAGE_RECEIVER, MESSAGE_ISREAD, MESSAGE_TIME };