diff options
author | Oguz Kocer <oguz.kocer@automattic.com> | 2016-07-01 14:56:16 +0300 |
---|---|---|
committer | Oguz Kocer <oguz.kocer@automattic.com> | 2016-07-01 14:56:16 +0300 |
commit | c26c4a51370e95b2718c7faa1493eda081580668 (patch) | |
tree | 0eaf418576bc214d09769c9ce672973fc1d6eb6b /WordPress/src/main/java/org/wordpress/android/datasets/PeopleTable.java | |
parent | cdc6782d270bc6c42e6101413ad049d031658508 (diff) | |
download | gradle-perf-android-medium-c26c4a51370e95b2718c7faa1493eda081580668.tar.gz |
Adds a comment explaining primary key decision in PeopleTable
Diffstat (limited to 'WordPress/src/main/java/org/wordpress/android/datasets/PeopleTable.java')
-rw-r--r-- | WordPress/src/main/java/org/wordpress/android/datasets/PeopleTable.java | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/WordPress/src/main/java/org/wordpress/android/datasets/PeopleTable.java b/WordPress/src/main/java/org/wordpress/android/datasets/PeopleTable.java index 65bdec093..769a78d49 100644 --- a/WordPress/src/main/java/org/wordpress/android/datasets/PeopleTable.java +++ b/WordPress/src/main/java/org/wordpress/android/datasets/PeopleTable.java @@ -23,6 +23,11 @@ public class PeopleTable { return WordPress.wpDB.getDatabase(); } + /** + * We use people table to store users, followers, email followers & viewers. A person can belong to multiple sites + * and can be a user, follower and viewer of a site at the same time. So, a combination of `person_id`, + * `local_blog_id`, `is_follower` and `is_viewer` columns is required to identify a record. + */ public static void createTables(SQLiteDatabase db) { db.execSQL("CREATE TABLE " + PEOPLE_TABLE + " (" + "person_id INTEGER DEFAULT 0," |