// Path: WaniKani/src/tr/xip/wanikani/database/table/NotificationsTable.java
// public class NotificationsTable implements BaseColumns {
//     public static final String TABLE_NAME = "notifications";
//     public static final String COLUMN_NAME_ID = "_id";
//     public static final String COLUMN_NAME_TITLE = "title";
//     public static final String COLUMN_NAME_SHORT_TEXT = "short_text";
//     public static final String COLUMN_NAME_TEXT = "text";
//     public static final String COLUMN_NAME_IMAGE = "image";
//     public static final String COLUMN_NAME_ACTION_URL = "action_url";
//     public static final String COLUMN_NAME_ACTION_TEXT = "action_text";
//     public static final String COLUMN_NAME_READ = "read";
//     public static final String COLUMN_NAME_NULLABLE = "nullable";
// 
//     public static final String[] COLUMNS = {
//             COLUMN_NAME_ID,
//             COLUMN_NAME_TITLE,
//             COLUMN_NAME_SHORT_TEXT,
//             COLUMN_NAME_TEXT,
//             COLUMN_NAME_IMAGE,
//             COLUMN_NAME_ACTION_URL,
//             COLUMN_NAME_ACTION_TEXT,
//             COLUMN_NAME_READ,
//             COLUMN_NAME_NULLABLE
//     };
// }


import tr.xip.wanikani.database.table.CriticalItemsTable;
import tr.xip.wanikani.database.table.ItemsTable;
import tr.xip.wanikani.database.table.LevelProgressionTable;
import tr.xip.wanikani.database.table.NotificationsTable;
import tr.xip.wanikani.database.table.RecentUnlocksTable;
import tr.xip.wanikani.database.table.SRSDistributionTable;
import tr.xip.wanikani.database.table.StudyQueueTable;
import tr.xip.wanikani.database.table.UsersTable;
            + SRSDistributionTable.COLUMN_NAME_ENLIGHTENED_KANJI + INTEGER_TYPE + COMMA_SEP
            + SRSDistributionTable.COLUMN_NAME_ENLIGHTENED_VOCABULARY + INTEGER_TYPE + COMMA_SEP
            + SRSDistributionTable.COLUMN_NAME_BURNED_RADICALS + INTEGER_TYPE + COMMA_SEP
            + SRSDistributionTable.COLUMN_NAME_BURNED_KANJI + INTEGER_TYPE + COMMA_SEP
            + SRSDistributionTable.COLUMN_NAME_BURNED_VOCABULARY + INTEGER_TYPE + COMMA_SEP
            + SRSDistributionTable.COLUMN_NAME_NULLABLE + TEXT_TYPE + ")";

    public static final String DELETE_TABLE_SRS = "DROP TABLE IF EXISTS "
            + SRSDistributionTable.TABLE_NAME;

    public static final String CREATE_TABLE_USERS = "CREATE TABLE "
            + UsersTable.TABLE_NAME + " ("
            + UsersTable.COLUMN_NAME_ID + INTEGER_PRIMARY_KEY_AUTOINCREMENT + COMMA_SEP
            + UsersTable.COLUMN_NAME_USERNAME + TEXT_TYPE + COMMA_SEP
            + UsersTable.COLUMN_NAME_GRAVATAR + TEXT_TYPE + COMMA_SEP
            + UsersTable.COLUMN_NAME_LEVEL + INTEGER_TYPE + COMMA_SEP
            + UsersTable.COLUMN_NAME_TITLE + TEXT_TYPE + COMMA_SEP
            + UsersTable.COLUMN_NAME_ABOUT + TEXT_TYPE + COMMA_SEP
            + UsersTable.COLUMN_NAME_WEBSITE + TEXT_TYPE + COMMA_SEP
            + UsersTable.COLUMN_NAME_TWITTER + TEXT_TYPE + COMMA_SEP
            + UsersTable.COLUMN_NAME_TOPICS_COUNT + INTEGER_TYPE + COMMA_SEP
            + UsersTable.COLUMN_NAME_POSTS_COUNT + INTEGER_TYPE + COMMA_SEP
            + UsersTable.COLUMN_NAME_CREATION_DATE + INTEGER_TYPE + COMMA_SEP
            + UsersTable.COLUMN_NAME_VACATION_DATE + INTEGER_TYPE + COMMA_SEP
            + UsersTable.COLUMN_NAME_NULLABLE + TEXT_TYPE  + ")";

    public static final String DELETE_TABLE_USERS = "DROP TABLE IF EXISTS "
            + UsersTable.TABLE_NAME;

    public static final String CREATE_TABLE_NOTIFICATIONS = "CREATE TABLE "
// Path: WaniKani/src/tr/xip/wanikani/database/table/NotificationsTable.java
// public class NotificationsTable implements BaseColumns {
//     public static final String TABLE_NAME = "notifications";
//     public static final String COLUMN_NAME_ID = "_id";
//     public static final String COLUMN_NAME_TITLE = "title";
//     public static final String COLUMN_NAME_SHORT_TEXT = "short_text";
//     public static final String COLUMN_NAME_TEXT = "text";
//     public static final String COLUMN_NAME_IMAGE = "image";
//     public static final String COLUMN_NAME_ACTION_URL = "action_url";
//     public static final String COLUMN_NAME_ACTION_TEXT = "action_text";
//     public static final String COLUMN_NAME_READ = "read";
//     public static final String COLUMN_NAME_NULLABLE = "nullable";
// 
//     public static final String[] COLUMNS = {
//             COLUMN_NAME_ID,
//             COLUMN_NAME_TITLE,
//             COLUMN_NAME_SHORT_TEXT,
//             COLUMN_NAME_TEXT,
//             COLUMN_NAME_IMAGE,
//             COLUMN_NAME_ACTION_URL,
//             COLUMN_NAME_ACTION_TEXT,
//             COLUMN_NAME_READ,
//             COLUMN_NAME_NULLABLE
//     };
// }


// Path: WaniKani/src/tr/xip/wanikani/database/SQL.java
import tr.xip.wanikani.database.table.CriticalItemsTable;
import tr.xip.wanikani.database.table.ItemsTable;
import tr.xip.wanikani.database.table.LevelProgressionTable;
import tr.xip.wanikani.database.table.NotificationsTable;
import tr.xip.wanikani.database.table.RecentUnlocksTable;
import tr.xip.wanikani.database.table.SRSDistributionTable;
import tr.xip.wanikani.database.table.StudyQueueTable;
import tr.xip.wanikani.database.table.UsersTable;

            + SRSDistributionTable.COLUMN_NAME_ENLIGHTENED_KANJI + INTEGER_TYPE + COMMA_SEP
            + SRSDistributionTable.COLUMN_NAME_ENLIGHTENED_VOCABULARY + INTEGER_TYPE + COMMA_SEP
            + SRSDistributionTable.COLUMN_NAME_BURNED_RADICALS + INTEGER_TYPE + COMMA_SEP
            + SRSDistributionTable.COLUMN_NAME_BURNED_KANJI + INTEGER_TYPE + COMMA_SEP
            + SRSDistributionTable.COLUMN_NAME_BURNED_VOCABULARY + INTEGER_TYPE + COMMA_SEP
            + SRSDistributionTable.COLUMN_NAME_NULLABLE + TEXT_TYPE + ")";

    public static final String DELETE_TABLE_SRS = "DROP TABLE IF EXISTS "
            + SRSDistributionTable.TABLE_NAME;

    public static final String CREATE_TABLE_USERS = "CREATE TABLE "
            + UsersTable.TABLE_NAME + " ("
            + UsersTable.COLUMN_NAME_ID + INTEGER_PRIMARY_KEY_AUTOINCREMENT + COMMA_SEP
            + UsersTable.COLUMN_NAME_USERNAME + TEXT_TYPE + COMMA_SEP
            + UsersTable.COLUMN_NAME_GRAVATAR + TEXT_TYPE + COMMA_SEP
            + UsersTable.COLUMN_NAME_LEVEL + INTEGER_TYPE + COMMA_SEP
            + UsersTable.COLUMN_NAME_TITLE + TEXT_TYPE + COMMA_SEP
            + UsersTable.COLUMN_NAME_ABOUT + TEXT_TYPE + COMMA_SEP
            + UsersTable.COLUMN_NAME_WEBSITE + TEXT_TYPE + COMMA_SEP
            + UsersTable.COLUMN_NAME_TWITTER + TEXT_TYPE + COMMA_SEP
            + UsersTable.COLUMN_NAME_TOPICS_COUNT + INTEGER_TYPE + COMMA_SEP
            + UsersTable.COLUMN_NAME_POSTS_COUNT + INTEGER_TYPE + COMMA_SEP
            + UsersTable.COLUMN_NAME_CREATION_DATE + INTEGER_TYPE + COMMA_SEP
            + UsersTable.COLUMN_NAME_VACATION_DATE + INTEGER_TYPE + COMMA_SEP
            + UsersTable.COLUMN_NAME_NULLABLE + TEXT_TYPE  + ")";

    public static final String DELETE_TABLE_USERS = "DROP TABLE IF EXISTS "
            + UsersTable.TABLE_NAME;

    public static final String CREATE_TABLE_NOTIFICATIONS = "CREATE TABLE "
            + NotificationsTable.TABLE_NAME + " ("