{
  "formatVersion": 1,
  "database": {
    "version": 10,
    "identityHash": "2276aa8171b55b435810d123de73ad97",
    "entities": [
      {
        "tableName": "articles",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`_id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `unread` INTEGER NOT NULL, `transiant_unread` INTEGER NOT NULL, `marked` INTEGER NOT NULL, `published` INTEGER NOT NULL, `score` INTEGER NOT NULL, `last_time_update` INTEGER NOT NULL, `is_updated` INTEGER NOT NULL, `link` TEXT NOT NULL, `feed_id` INTEGER NOT NULL, `flavor_image_uri` TEXT NOT NULL, `content_excerpt` TEXT NOT NULL, `title` TEXT NOT NULL, `tags` TEXT NOT NULL, `content` TEXT NOT NULL, `author` TEXT NOT NULL, FOREIGN KEY(`feed_id`) REFERENCES `feeds`(`_id`) ON UPDATE NO ACTION ON DELETE NO ACTION )",
        "fields": [
          {
            "fieldPath": "id",
            "columnName": "_id",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "isUnread",
            "columnName": "unread",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "isTransientUnread",
            "columnName": "transiant_unread",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "isStarred",
            "columnName": "marked",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "isPublished",
            "columnName": "published",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "score",
            "columnName": "score",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "lastTimeUpdate",
            "columnName": "last_time_update",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "isUpdated",
            "columnName": "is_updated",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "link",
            "columnName": "link",
            "affinity": "TEXT",
            "notNull": true
          },
          {
            "fieldPath": "feedId",
            "columnName": "feed_id",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "flavorImageUri",
            "columnName": "flavor_image_uri",
            "affinity": "TEXT",
            "notNull": true
          },
          {
            "fieldPath": "contentExcerpt",
            "columnName": "content_excerpt",
            "affinity": "TEXT",
            "notNull": true
          },
          {
            "fieldPath": "contentData.title",
            "columnName": "title",
            "affinity": "TEXT",
            "notNull": true
          },
          {
            "fieldPath": "contentData.tags",
            "columnName": "tags",
            "affinity": "TEXT",
            "notNull": true
          },
          {
            "fieldPath": "contentData.content",
            "columnName": "content",
            "affinity": "TEXT",
            "notNull": true
          },
          {
            "fieldPath": "contentData.author",
            "columnName": "author",
            "affinity": "TEXT",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "_id"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_articles_feed_id",
            "unique": false,
            "columnNames": [
              "feed_id"
            ],
            "createSql": "CREATE  INDEX `index_articles_feed_id` ON `${TABLE_NAME}` (`feed_id`)"
          }
        ],
        "foreignKeys": [
          {
            "table": "feeds",
            "onDelete": "NO ACTION",
            "onUpdate": "NO ACTION",
            "columns": [
              "feed_id"
            ],
            "referencedColumns": [
              "_id"
            ]
          }
        ]
      },
      {
        "ftsVersion": "FTS4",
        "ftsOptions": {
          "tokenizer": "simple",
          "tokenizerArgs": [],
          "contentTable": "articles",
          "languageIdColumnName": "",
          "matchInfo": "FTS4",
          "notIndexedColumns": [],
          "prefixSizes": [],
          "preferredOrder": "ASC"
        },
        "contentSyncTriggers": [
          "CREATE TRIGGER IF NOT EXISTS room_fts_content_sync_ArticleFTS_BEFORE_UPDATE BEFORE UPDATE ON `articles` BEGIN DELETE FROM `ArticleFTS` WHERE `docid`=OLD.`rowid`; END",
          "CREATE TRIGGER IF NOT EXISTS room_fts_content_sync_ArticleFTS_BEFORE_DELETE BEFORE DELETE ON `articles` BEGIN DELETE FROM `ArticleFTS` WHERE `docid`=OLD.`rowid`; END",
          "CREATE TRIGGER IF NOT EXISTS room_fts_content_sync_ArticleFTS_AFTER_UPDATE AFTER UPDATE ON `articles` BEGIN INSERT INTO `ArticleFTS`(`docid`, `title`, `tags`, `content`, `author`) VALUES (NEW.`rowid`, NEW.`title`, NEW.`tags`, NEW.`content`, NEW.`author`); END",
          "CREATE TRIGGER IF NOT EXISTS room_fts_content_sync_ArticleFTS_AFTER_INSERT AFTER INSERT ON `articles` BEGIN INSERT INTO `ArticleFTS`(`docid`, `title`, `tags`, `content`, `author`) VALUES (NEW.`rowid`, NEW.`title`, NEW.`tags`, NEW.`content`, NEW.`author`); END"
        ],
        "tableName": "ArticleFTS",
        "createSql": "CREATE VIRTUAL TABLE IF NOT EXISTS `${TABLE_NAME}` USING FTS4(`title` TEXT NOT NULL, `tags` TEXT NOT NULL, `content` TEXT NOT NULL, `author` TEXT NOT NULL, content=`articles`)",
        "fields": [
          {
            "fieldPath": "content.title",
            "columnName": "title",
            "affinity": "TEXT",
            "notNull": true
          },
          {
            "fieldPath": "content.tags",
            "columnName": "tags",
            "affinity": "TEXT",
            "notNull": true
          },
          {
            "fieldPath": "content.content",
            "columnName": "content",
            "affinity": "TEXT",
            "notNull": true
          },
          {
            "fieldPath": "content.author",
            "columnName": "author",
            "affinity": "TEXT",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [],
          "autoGenerate": false
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "categories",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`_id` INTEGER NOT NULL, `title` TEXT NOT NULL, `unread_count` INTEGER NOT NULL, PRIMARY KEY(`_id`))",
        "fields": [
          {
            "fieldPath": "id",
            "columnName": "_id",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "title",
            "columnName": "title",
            "affinity": "TEXT",
            "notNull": true
          },
          {
            "fieldPath": "unreadCount",
            "columnName": "unread_count",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "_id"
          ],
          "autoGenerate": false
        },
        "indices": [],
        "foreignKeys": []
      },
      {
        "tableName": "feeds",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`_id` INTEGER NOT NULL, `url` TEXT NOT NULL, `title` TEXT NOT NULL, `cat_id` INTEGER NOT NULL, `display_title` TEXT NOT NULL, `last_time_update` INTEGER NOT NULL, `unread_count` INTEGER NOT NULL, `is_subscribed` INTEGER NOT NULL, `feed_icon_url` TEXT NOT NULL, PRIMARY KEY(`_id`), FOREIGN KEY(`cat_id`) REFERENCES `categories`(`_id`) ON UPDATE NO ACTION ON DELETE NO ACTION DEFERRABLE INITIALLY DEFERRED)",
        "fields": [
          {
            "fieldPath": "id",
            "columnName": "_id",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "url",
            "columnName": "url",
            "affinity": "TEXT",
            "notNull": true
          },
          {
            "fieldPath": "title",
            "columnName": "title",
            "affinity": "TEXT",
            "notNull": true
          },
          {
            "fieldPath": "catId",
            "columnName": "cat_id",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "displayTitle",
            "columnName": "display_title",
            "affinity": "TEXT",
            "notNull": true
          },
          {
            "fieldPath": "lastTimeUpdate",
            "columnName": "last_time_update",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "unreadCount",
            "columnName": "unread_count",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "isSubscribed",
            "columnName": "is_subscribed",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "feedIconUrl",
            "columnName": "feed_icon_url",
            "affinity": "TEXT",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "_id"
          ],
          "autoGenerate": false
        },
        "indices": [
          {
            "name": "index_feeds_cat_id",
            "unique": false,
            "columnNames": [
              "cat_id"
            ],
            "createSql": "CREATE  INDEX `index_feeds_cat_id` ON `${TABLE_NAME}` (`cat_id`)"
          }
        ],
        "foreignKeys": [
          {
            "table": "categories",
            "onDelete": "NO ACTION",
            "onUpdate": "NO ACTION",
            "columns": [
              "cat_id"
            ],
            "referencedColumns": [
              "_id"
            ]
          }
        ]
      },
      {
        "tableName": "transactions",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`_id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, `article_id` INTEGER NOT NULL, `field` TEXT NOT NULL, `value` INTEGER NOT NULL, FOREIGN KEY(`article_id`) REFERENCES `articles`(`_id`) ON UPDATE NO ACTION ON DELETE CASCADE )",
        "fields": [
          {
            "fieldPath": "id",
            "columnName": "_id",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "articleId",
            "columnName": "article_id",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "field",
            "columnName": "field",
            "affinity": "TEXT",
            "notNull": true
          },
          {
            "fieldPath": "value",
            "columnName": "value",
            "affinity": "INTEGER",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "_id"
          ],
          "autoGenerate": true
        },
        "indices": [
          {
            "name": "index_transactions_article_id",
            "unique": false,
            "columnNames": [
              "article_id"
            ],
            "createSql": "CREATE  INDEX `index_transactions_article_id` ON `${TABLE_NAME}` (`article_id`)"
          }
        ],
        "foreignKeys": [
          {
            "table": "articles",
            "onDelete": "CASCADE",
            "onUpdate": "NO ACTION",
            "columns": [
              "article_id"
            ],
            "referencedColumns": [
              "_id"
            ]
          }
        ]
      },
      {
        "tableName": "account_info",
        "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`server_version` TEXT NOT NULL, `api_level` INTEGER NOT NULL, `account_username` TEXT NOT NULL, `account_url` TEXT NOT NULL, PRIMARY KEY(`account_username`, `account_url`))",
        "fields": [
          {
            "fieldPath": "serverVersion",
            "columnName": "server_version",
            "affinity": "TEXT",
            "notNull": true
          },
          {
            "fieldPath": "apiLevel",
            "columnName": "api_level",
            "affinity": "INTEGER",
            "notNull": true
          },
          {
            "fieldPath": "account.username",
            "columnName": "account_username",
            "affinity": "TEXT",
            "notNull": true
          },
          {
            "fieldPath": "account.url",
            "columnName": "account_url",
            "affinity": "TEXT",
            "notNull": true
          }
        ],
        "primaryKey": {
          "columnNames": [
            "account_username",
            "account_url"
          ],
          "autoGenerate": false
        },
        "indices": [],
        "foreignKeys": []
      }
    ],
    "views": [],
    "setupQueries": [
      "CREATE TABLE IF NOT EXISTS room_master_table (id INTEGER PRIMARY KEY,identity_hash TEXT)",
      "INSERT OR REPLACE INTO room_master_table (id,identity_hash) VALUES(42, '2276aa8171b55b435810d123de73ad97')"
    ]
  }
}