2 files changed, 8 insertions, 9 deletions
diff --git a/app/src/main/java/SubscribedUserDatabase/SubscribedUserDao.java b/app/src/main/java/SubscribedUserDatabase/SubscribedUserDao.java
index 2b61a666..83bdf6fe 100644
--- a/app/src/main/java/SubscribedUserDatabase/SubscribedUserDao.java
+++ b/app/src/main/java/SubscribedUserDatabase/SubscribedUserDao.java
@@ -16,6 +16,12 @@ public interface SubscribedUserDao {
     @Query("DELETE FROM subscribed_users")
     void deleteAllSubscribedUsers();
 
-    @Query("SELECT * from subscribed_users ORDER BY name COLLATE NOCASE ASC")
+    @Query("SELECT * FROM subscribed_users ORDER BY name COLLATE NOCASE ASC")
     LiveData<List<SubscribedUserData>> getAllSubscribedUsers();
+
+    @Query("SELECT * FROM subscribed_users WHERE name = :userName LIMIT 1")
+    SubscribedUserData getSubscribedUser(String userName);
+
+    @Query("DELETE FROM subscribed_users WHERE name = :userName")
+    void deleteSubscribedUser(String userName);
 }
diff --git a/app/src/main/java/SubscribedUserDatabase/SubscribedUserData.java b/app/src/main/java/SubscribedUserDatabase/SubscribedUserData.java
index 8494e784..41947efe 100644
--- a/app/src/main/java/SubscribedUserDatabase/SubscribedUserData.java
+++ b/app/src/main/java/SubscribedUserDatabase/SubscribedUserData.java
@@ -9,24 +9,17 @@ import android.support.annotation.NonNull;
 public class SubscribedUserData {
     @PrimaryKey
     @NonNull
-    @ColumnInfo(name = "id")
-    private String id;
     @ColumnInfo(name = "name")
     private String name;
     @ColumnInfo(name = "icon")
     private String iconUrl;
 
-    public SubscribedUserData(@NonNull String id, String name, String iconUrl) {
-        this.id = id;
+    public SubscribedUserData(@NonNull String name, String iconUrl) {
         this.name = name;
         this.iconUrl = iconUrl;
     }
 
     @NonNull
-    public String getId() {
-        return id;
-    }
-
     public String getName() {
         return name;
     }