· 8 years ago · Feb 22, 2018, 03:04 PM
1String CREATE_USERS_IN_CONVERSATION_TABLE= " CREATE TABLE IF NOT EXISTS "+ UsersInConversationEntry.TABLE_NAME + "( "
2 + UsersInConversationEntry.CON_ID + " INTEGER NOT NULL, " + " FOREIGN KEY ("+UsersInConversationEntry.CON_ID+") REFERENCES "+ConversationEntry.TABLE_NAME +"("+ConversationEntry.CON_ID+"), "
3 + UsersInConversationEntry.USER_ID + " INTEGER, " + " FOREIGN KEY ("+UsersInConversationEntry.USER_ID+") REFERENCES "+UserEntry.TABLE_NAME +"("+UserEntry.USER_ID+"),"
4 + UsersInConversationEntry.HAS_BLOCKED + " TEXT NOT NULL, "
5 + UsersInConversationEntry.LAST_UPDATED + " TEXT NOT NULL );";
6 db.execSQL(CREATE_USERS_IN_CONVERSATION_TABLE);