| { |
| "formatVersion": 1, |
| "database": { |
| "version": 3, |
| "identityHash": "7a7934a196e6d6eb3055b9957c91490c", |
| "entities": [ |
| { |
| "tableName": "Entity1", |
| "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER NOT NULL, `name` TEXT NOT NULL, `addedInV1` INTEGER NOT NULL DEFAULT 1, PRIMARY KEY(`id`))", |
| "fields": [ |
| { |
| "fieldPath": "id", |
| "columnName": "id", |
| "affinity": "INTEGER", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "name", |
| "columnName": "name", |
| "affinity": "TEXT", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "addedInV1", |
| "columnName": "addedInV1", |
| "affinity": "INTEGER", |
| "notNull": true, |
| "defaultValue": "1" |
| } |
| ], |
| "primaryKey": { |
| "autoGenerate": false, |
| "columnNames": [ |
| "id" |
| ] |
| }, |
| "indices": [], |
| "foreignKeys": [] |
| }, |
| { |
| "tableName": "Entity2", |
| "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER NOT NULL, `name` TEXT NOT NULL, `addedInV1` INTEGER NOT NULL DEFAULT 1, `addedInV2` INTEGER NOT NULL DEFAULT 2, PRIMARY KEY(`id`))", |
| "fields": [ |
| { |
| "fieldPath": "id", |
| "columnName": "id", |
| "affinity": "INTEGER", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "name", |
| "columnName": "name", |
| "affinity": "TEXT", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "addedInV1", |
| "columnName": "addedInV1", |
| "affinity": "INTEGER", |
| "notNull": true, |
| "defaultValue": "1" |
| }, |
| { |
| "fieldPath": "addedInV2", |
| "columnName": "addedInV2", |
| "affinity": "INTEGER", |
| "notNull": true, |
| "defaultValue": "2" |
| } |
| ], |
| "primaryKey": { |
| "autoGenerate": false, |
| "columnNames": [ |
| "id" |
| ] |
| }, |
| "indices": [], |
| "foreignKeys": [] |
| }, |
| { |
| "tableName": "Entity3", |
| "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER NOT NULL, `name` TEXT NOT NULL, PRIMARY KEY(`id`))", |
| "fields": [ |
| { |
| "fieldPath": "id", |
| "columnName": "id", |
| "affinity": "INTEGER", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "name", |
| "columnName": "name", |
| "affinity": "TEXT", |
| "notNull": true |
| } |
| ], |
| "primaryKey": { |
| "autoGenerate": false, |
| "columnNames": [ |
| "id" |
| ] |
| }, |
| "indices": [], |
| "foreignKeys": [] |
| }, |
| { |
| "tableName": "Entity4", |
| "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER NOT NULL, `name` TEXT NOT NULL, `addedInV1` INTEGER NOT NULL DEFAULT 2, PRIMARY KEY(`id`))", |
| "fields": [ |
| { |
| "fieldPath": "id", |
| "columnName": "id", |
| "affinity": "INTEGER", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "name", |
| "columnName": "name", |
| "affinity": "TEXT", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "addedInV1", |
| "columnName": "addedInV1", |
| "affinity": "INTEGER", |
| "notNull": true, |
| "defaultValue": "2" |
| } |
| ], |
| "primaryKey": { |
| "autoGenerate": false, |
| "columnNames": [ |
| "id" |
| ] |
| }, |
| "indices": [], |
| "foreignKeys": [] |
| }, |
| { |
| "tableName": "Entity5", |
| "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER NOT NULL, `name` TEXT NOT NULL, `addedInV1` TEXT NOT NULL DEFAULT '1', PRIMARY KEY(`id`))", |
| "fields": [ |
| { |
| "fieldPath": "id", |
| "columnName": "id", |
| "affinity": "INTEGER", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "name", |
| "columnName": "name", |
| "affinity": "TEXT", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "addedInV1", |
| "columnName": "addedInV1", |
| "affinity": "TEXT", |
| "notNull": true, |
| "defaultValue": "'1'" |
| } |
| ], |
| "primaryKey": { |
| "autoGenerate": false, |
| "columnNames": [ |
| "id" |
| ] |
| }, |
| "indices": [], |
| "foreignKeys": [] |
| }, |
| { |
| "tableName": "Entity6", |
| "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER NOT NULL, `name` TEXT NOT NULL, `addedInV1` INTEGER NOT NULL, PRIMARY KEY(`id`))", |
| "fields": [ |
| { |
| "fieldPath": "id", |
| "columnName": "id", |
| "affinity": "INTEGER", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "name", |
| "columnName": "name", |
| "affinity": "TEXT", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "addedInV1", |
| "columnName": "addedInV1", |
| "affinity": "INTEGER", |
| "notNull": true |
| } |
| ], |
| "primaryKey": { |
| "autoGenerate": false, |
| "columnNames": [ |
| "id" |
| ] |
| }, |
| "indices": [], |
| "foreignKeys": [] |
| }, |
| { |
| "tableName": "Entity7", |
| "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER NOT NULL, `name` TEXT NOT NULL, `addedInV1` INTEGER NOT NULL DEFAULT 1, PRIMARY KEY(`id`))", |
| "fields": [ |
| { |
| "fieldPath": "id", |
| "columnName": "id", |
| "affinity": "INTEGER", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "name", |
| "columnName": "name", |
| "affinity": "TEXT", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "addedInV1", |
| "columnName": "addedInV1", |
| "affinity": "INTEGER", |
| "notNull": true, |
| "defaultValue": "1" |
| } |
| ], |
| "primaryKey": { |
| "autoGenerate": false, |
| "columnNames": [ |
| "id" |
| ] |
| }, |
| "indices": [], |
| "foreignKeys": [] |
| }, |
| { |
| "tableName": "Entity8", |
| "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER NOT NULL, `name` TEXT NOT NULL, `addedInV1` INTEGER NOT NULL DEFAULT 1, PRIMARY KEY(`name`))", |
| "fields": [ |
| { |
| "fieldPath": "id", |
| "columnName": "id", |
| "affinity": "INTEGER", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "name", |
| "columnName": "name", |
| "affinity": "TEXT", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "addedInV1", |
| "columnName": "addedInV1", |
| "affinity": "INTEGER", |
| "notNull": true, |
| "defaultValue": "1" |
| } |
| ], |
| "primaryKey": { |
| "autoGenerate": false, |
| "columnNames": [ |
| "name" |
| ] |
| }, |
| "indices": [], |
| "foreignKeys": [] |
| }, |
| { |
| "tableName": "Entity9", |
| "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER NOT NULL, `name` TEXT NOT NULL, `addedInV1` INTEGER NOT NULL DEFAULT 1, PRIMARY KEY(`id`), FOREIGN KEY(`id`) REFERENCES `Entity27`(`id27`) ON UPDATE NO ACTION ON DELETE NO ACTION )", |
| "fields": [ |
| { |
| "fieldPath": "id", |
| "columnName": "id", |
| "affinity": "INTEGER", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "name", |
| "columnName": "name", |
| "affinity": "TEXT", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "addedInV1", |
| "columnName": "addedInV1", |
| "affinity": "INTEGER", |
| "notNull": true, |
| "defaultValue": "1" |
| } |
| ], |
| "primaryKey": { |
| "autoGenerate": false, |
| "columnNames": [ |
| "id" |
| ] |
| }, |
| "indices": [], |
| "foreignKeys": [ |
| { |
| "table": "Entity27", |
| "onDelete": "NO ACTION", |
| "onUpdate": "NO ACTION", |
| "columns": [ |
| "id" |
| ], |
| "referencedColumns": [ |
| "id27" |
| ] |
| } |
| ] |
| }, |
| { |
| "tableName": "Entity10", |
| "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER NOT NULL, `name` TEXT NOT NULL, `addedInV1` INTEGER NOT NULL DEFAULT 1, PRIMARY KEY(`id`), FOREIGN KEY(`addedInV1`) REFERENCES `Entity13_V2`(`addedInV1`) ON UPDATE NO ACTION ON DELETE NO ACTION DEFERRABLE INITIALLY DEFERRED)", |
| "fields": [ |
| { |
| "fieldPath": "id", |
| "columnName": "id", |
| "affinity": "INTEGER", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "name", |
| "columnName": "name", |
| "affinity": "TEXT", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "addedInV1", |
| "columnName": "addedInV1", |
| "affinity": "INTEGER", |
| "notNull": true, |
| "defaultValue": "1" |
| } |
| ], |
| "primaryKey": { |
| "autoGenerate": false, |
| "columnNames": [ |
| "id" |
| ] |
| }, |
| "indices": [ |
| { |
| "name": "index_Entity10_addedInV1", |
| "unique": true, |
| "columnNames": [ |
| "addedInV1" |
| ], |
| "orders": [], |
| "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_Entity10_addedInV1` ON `${TABLE_NAME}` (`addedInV1`)" |
| } |
| ], |
| "foreignKeys": [ |
| { |
| "table": "Entity13_V2", |
| "onDelete": "NO ACTION", |
| "onUpdate": "NO ACTION", |
| "columns": [ |
| "addedInV1" |
| ], |
| "referencedColumns": [ |
| "addedInV1" |
| ] |
| } |
| ] |
| }, |
| { |
| "tableName": "Entity11", |
| "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER NOT NULL, `name` TEXT NOT NULL, `addedInV1` INTEGER NOT NULL DEFAULT 1, PRIMARY KEY(`id`))", |
| "fields": [ |
| { |
| "fieldPath": "id", |
| "columnName": "id", |
| "affinity": "INTEGER", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "name", |
| "columnName": "name", |
| "affinity": "TEXT", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "addedInV1", |
| "columnName": "addedInV1", |
| "affinity": "INTEGER", |
| "notNull": true, |
| "defaultValue": "1" |
| } |
| ], |
| "primaryKey": { |
| "autoGenerate": false, |
| "columnNames": [ |
| "id" |
| ] |
| }, |
| "indices": [], |
| "foreignKeys": [] |
| }, |
| { |
| "tableName": "Entity12", |
| "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER NOT NULL, `name` TEXT NOT NULL, `addedInV1` INTEGER NOT NULL DEFAULT 1, PRIMARY KEY(`id`))", |
| "fields": [ |
| { |
| "fieldPath": "id", |
| "columnName": "id", |
| "affinity": "INTEGER", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "name", |
| "columnName": "name", |
| "affinity": "TEXT", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "addedInV1", |
| "columnName": "addedInV1", |
| "affinity": "INTEGER", |
| "notNull": true, |
| "defaultValue": "1" |
| } |
| ], |
| "primaryKey": { |
| "autoGenerate": false, |
| "columnNames": [ |
| "id" |
| ] |
| }, |
| "indices": [ |
| { |
| "name": "index_Entity12_name", |
| "unique": true, |
| "columnNames": [ |
| "name" |
| ], |
| "orders": [], |
| "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_Entity12_name` ON `${TABLE_NAME}` (`name`)" |
| } |
| ], |
| "foreignKeys": [] |
| }, |
| { |
| "tableName": "Entity13_V2", |
| "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER NOT NULL, `name` TEXT NOT NULL, `addedInV1` INTEGER NOT NULL DEFAULT 1, PRIMARY KEY(`id`))", |
| "fields": [ |
| { |
| "fieldPath": "id", |
| "columnName": "id", |
| "affinity": "INTEGER", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "name", |
| "columnName": "name", |
| "affinity": "TEXT", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "addedInV1", |
| "columnName": "addedInV1", |
| "affinity": "INTEGER", |
| "notNull": true, |
| "defaultValue": "1" |
| } |
| ], |
| "primaryKey": { |
| "autoGenerate": false, |
| "columnNames": [ |
| "id" |
| ] |
| }, |
| "indices": [ |
| { |
| "name": "index_Entity13_V2_addedInV1", |
| "unique": true, |
| "columnNames": [ |
| "addedInV1" |
| ], |
| "orders": [], |
| "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_Entity13_V2_addedInV1` ON `${TABLE_NAME}` (`addedInV1`)" |
| } |
| ], |
| "foreignKeys": [] |
| }, |
| { |
| "tableName": "Entity14", |
| "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER NOT NULL, `name` TEXT NOT NULL, PRIMARY KEY(`id`))", |
| "fields": [ |
| { |
| "fieldPath": "id", |
| "columnName": "id", |
| "affinity": "INTEGER", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "name", |
| "columnName": "name", |
| "affinity": "TEXT", |
| "notNull": true |
| } |
| ], |
| "primaryKey": { |
| "autoGenerate": false, |
| "columnNames": [ |
| "id" |
| ] |
| }, |
| "indices": [], |
| "foreignKeys": [] |
| }, |
| { |
| "tableName": "Entity15", |
| "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER NOT NULL, `name` TEXT NOT NULL, PRIMARY KEY(`id`))", |
| "fields": [ |
| { |
| "fieldPath": "id", |
| "columnName": "id", |
| "affinity": "INTEGER", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "name", |
| "columnName": "name", |
| "affinity": "TEXT", |
| "notNull": true |
| } |
| ], |
| "primaryKey": { |
| "autoGenerate": false, |
| "columnNames": [ |
| "id" |
| ] |
| }, |
| "indices": [], |
| "foreignKeys": [] |
| }, |
| { |
| "tableName": "Entity16", |
| "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER NOT NULL, `name` TEXT NOT NULL, `renamedInV2` INTEGER NOT NULL DEFAULT 1, PRIMARY KEY(`id`))", |
| "fields": [ |
| { |
| "fieldPath": "id", |
| "columnName": "id", |
| "affinity": "INTEGER", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "name", |
| "columnName": "name", |
| "affinity": "TEXT", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "renamedInV2", |
| "columnName": "renamedInV2", |
| "affinity": "INTEGER", |
| "notNull": true, |
| "defaultValue": "1" |
| } |
| ], |
| "primaryKey": { |
| "autoGenerate": false, |
| "columnNames": [ |
| "id" |
| ] |
| }, |
| "indices": [], |
| "foreignKeys": [] |
| }, |
| { |
| "tableName": "Entity17", |
| "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER NOT NULL, `name` TEXT NOT NULL, `renamedInV2` TEXT NOT NULL DEFAULT '1', PRIMARY KEY(`id`))", |
| "fields": [ |
| { |
| "fieldPath": "id", |
| "columnName": "id", |
| "affinity": "INTEGER", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "name", |
| "columnName": "name", |
| "affinity": "TEXT", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "renamedInV2", |
| "columnName": "renamedInV2", |
| "affinity": "TEXT", |
| "notNull": true, |
| "defaultValue": "'1'" |
| } |
| ], |
| "primaryKey": { |
| "autoGenerate": false, |
| "columnNames": [ |
| "id" |
| ] |
| }, |
| "indices": [], |
| "foreignKeys": [] |
| }, |
| { |
| "tableName": "Entity19_V2", |
| "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER NOT NULL, `name` TEXT NOT NULL, `addedInV1` INTEGER NOT NULL DEFAULT 1, PRIMARY KEY(`id`))", |
| "fields": [ |
| { |
| "fieldPath": "id", |
| "columnName": "id", |
| "affinity": "INTEGER", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "name", |
| "columnName": "name", |
| "affinity": "TEXT", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "addedInV1", |
| "columnName": "addedInV1", |
| "affinity": "INTEGER", |
| "notNull": true, |
| "defaultValue": "1" |
| } |
| ], |
| "primaryKey": { |
| "autoGenerate": false, |
| "columnNames": [ |
| "id" |
| ] |
| }, |
| "indices": [], |
| "foreignKeys": [] |
| }, |
| { |
| "tableName": "Entity20_V2", |
| "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER NOT NULL, `name` TEXT NOT NULL, `renamedInV2` TEXT NOT NULL DEFAULT '1', `addedInV2` INTEGER NOT NULL DEFAULT 2, PRIMARY KEY(`name`))", |
| "fields": [ |
| { |
| "fieldPath": "id", |
| "columnName": "id", |
| "affinity": "INTEGER", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "name", |
| "columnName": "name", |
| "affinity": "TEXT", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "renamedInV2", |
| "columnName": "renamedInV2", |
| "affinity": "TEXT", |
| "notNull": true, |
| "defaultValue": "'1'" |
| }, |
| { |
| "fieldPath": "addedInV2", |
| "columnName": "addedInV2", |
| "affinity": "INTEGER", |
| "notNull": true, |
| "defaultValue": "2" |
| } |
| ], |
| "primaryKey": { |
| "autoGenerate": false, |
| "columnNames": [ |
| "name" |
| ] |
| }, |
| "indices": [], |
| "foreignKeys": [] |
| }, |
| { |
| "ftsVersion": "FTS4", |
| "ftsOptions": { |
| "tokenizer": "simple", |
| "tokenizerArgs": [], |
| "contentTable": "Entity13_V2", |
| "languageIdColumnName": "", |
| "matchInfo": "FTS4", |
| "notIndexedColumns": [], |
| "prefixSizes": [], |
| "preferredOrder": "ASC" |
| }, |
| "contentSyncTriggers": [ |
| "CREATE TRIGGER IF NOT EXISTS room_fts_content_sync_Entity21_BEFORE_UPDATE BEFORE UPDATE ON `Entity13_V2` BEGIN DELETE FROM `Entity21` WHERE `docid`=OLD.`rowid`; END", |
| "CREATE TRIGGER IF NOT EXISTS room_fts_content_sync_Entity21_BEFORE_DELETE BEFORE DELETE ON `Entity13_V2` BEGIN DELETE FROM `Entity21` WHERE `docid`=OLD.`rowid`; END", |
| "CREATE TRIGGER IF NOT EXISTS room_fts_content_sync_Entity21_AFTER_UPDATE AFTER UPDATE ON `Entity13_V2` BEGIN INSERT INTO `Entity21`(`docid`, `name`, `addedInV1`) VALUES (NEW.`rowid`, NEW.`name`, NEW.`addedInV1`); END", |
| "CREATE TRIGGER IF NOT EXISTS room_fts_content_sync_Entity21_AFTER_INSERT AFTER INSERT ON `Entity13_V2` BEGIN INSERT INTO `Entity21`(`docid`, `name`, `addedInV1`) VALUES (NEW.`rowid`, NEW.`name`, NEW.`addedInV1`); END" |
| ], |
| "tableName": "Entity21", |
| "createSql": "CREATE VIRTUAL TABLE IF NOT EXISTS `${TABLE_NAME}` USING FTS4(`name` TEXT NOT NULL, `addedInV1` INTEGER NOT NULL DEFAULT 1, content=`Entity13_V2`)", |
| "fields": [ |
| { |
| "fieldPath": "name", |
| "columnName": "name", |
| "affinity": "TEXT", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "addedInV1", |
| "columnName": "addedInV1", |
| "affinity": "INTEGER", |
| "notNull": true, |
| "defaultValue": "1" |
| } |
| ], |
| "primaryKey": { |
| "autoGenerate": true, |
| "columnNames": [ |
| "rowid" |
| ] |
| }, |
| "indices": [], |
| "foreignKeys": [] |
| }, |
| { |
| "ftsVersion": "FTS4", |
| "ftsOptions": { |
| "tokenizer": "simple", |
| "tokenizerArgs": [], |
| "contentTable": "", |
| "languageIdColumnName": "", |
| "matchInfo": "FTS4", |
| "notIndexedColumns": [], |
| "prefixSizes": [], |
| "preferredOrder": "ASC" |
| }, |
| "contentSyncTriggers": [], |
| "tableName": "Entity22", |
| "createSql": "CREATE VIRTUAL TABLE IF NOT EXISTS `${TABLE_NAME}` USING FTS4(`name` TEXT NOT NULL, `addedInV1` INTEGER NOT NULL DEFAULT 1)", |
| "fields": [ |
| { |
| "fieldPath": "name", |
| "columnName": "name", |
| "affinity": "TEXT", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "addedInV1", |
| "columnName": "addedInV1", |
| "affinity": "INTEGER", |
| "notNull": true, |
| "defaultValue": "1" |
| } |
| ], |
| "primaryKey": { |
| "autoGenerate": true, |
| "columnNames": [ |
| "rowid" |
| ] |
| }, |
| "indices": [], |
| "foreignKeys": [] |
| }, |
| { |
| "ftsVersion": "FTS3", |
| "ftsOptions": { |
| "tokenizer": "simple", |
| "tokenizerArgs": [], |
| "contentTable": "", |
| "languageIdColumnName": "", |
| "matchInfo": "FTS4", |
| "notIndexedColumns": [], |
| "prefixSizes": [], |
| "preferredOrder": "ASC" |
| }, |
| "contentSyncTriggers": [], |
| "tableName": "Entity23", |
| "createSql": "CREATE VIRTUAL TABLE IF NOT EXISTS `${TABLE_NAME}` USING FTS3(`name` TEXT NOT NULL, `addedInV1` INTEGER NOT NULL DEFAULT 1, `addedInV2` INTEGER NOT NULL DEFAULT 2)", |
| "fields": [ |
| { |
| "fieldPath": "name", |
| "columnName": "name", |
| "affinity": "TEXT", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "addedInV1", |
| "columnName": "addedInV1", |
| "affinity": "INTEGER", |
| "notNull": true, |
| "defaultValue": "1" |
| }, |
| { |
| "fieldPath": "addedInV2", |
| "columnName": "addedInV2", |
| "affinity": "INTEGER", |
| "notNull": true, |
| "defaultValue": "2" |
| } |
| ], |
| "primaryKey": { |
| "autoGenerate": true, |
| "columnNames": [ |
| "rowid" |
| ] |
| }, |
| "indices": [], |
| "foreignKeys": [] |
| }, |
| { |
| "ftsVersion": "FTS3", |
| "ftsOptions": { |
| "tokenizer": "simple", |
| "tokenizerArgs": [], |
| "contentTable": "", |
| "languageIdColumnName": "", |
| "matchInfo": "FTS4", |
| "notIndexedColumns": [], |
| "prefixSizes": [], |
| "preferredOrder": "ASC" |
| }, |
| "contentSyncTriggers": [], |
| "tableName": "Entity24", |
| "createSql": "CREATE VIRTUAL TABLE IF NOT EXISTS `${TABLE_NAME}` USING FTS3(`name` TEXT NOT NULL, `addedInV1` INTEGER NOT NULL DEFAULT 1)", |
| "fields": [ |
| { |
| "fieldPath": "name", |
| "columnName": "name", |
| "affinity": "TEXT", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "addedInV1", |
| "columnName": "addedInV1", |
| "affinity": "INTEGER", |
| "notNull": true, |
| "defaultValue": "1" |
| } |
| ], |
| "primaryKey": { |
| "autoGenerate": true, |
| "columnNames": [ |
| "rowid" |
| ] |
| }, |
| "indices": [], |
| "foreignKeys": [] |
| }, |
| { |
| "tableName": "Entity25", |
| "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER NOT NULL, `name` TEXT NOT NULL, `entity1Id` INTEGER NOT NULL DEFAULT 1, PRIMARY KEY(`id`))", |
| "fields": [ |
| { |
| "fieldPath": "id", |
| "columnName": "id", |
| "affinity": "INTEGER", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "name", |
| "columnName": "name", |
| "affinity": "TEXT", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "entity1Id", |
| "columnName": "entity1Id", |
| "affinity": "INTEGER", |
| "notNull": true, |
| "defaultValue": "1" |
| } |
| ], |
| "primaryKey": { |
| "autoGenerate": false, |
| "columnNames": [ |
| "id" |
| ] |
| }, |
| "indices": [], |
| "foreignKeys": [] |
| }, |
| { |
| "tableName": "Entity26", |
| "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id` INTEGER NOT NULL, `name` TEXT NOT NULL, `addedInV2` INTEGER NOT NULL DEFAULT 1, PRIMARY KEY(`id`))", |
| "fields": [ |
| { |
| "fieldPath": "id", |
| "columnName": "id", |
| "affinity": "INTEGER", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "name", |
| "columnName": "name", |
| "affinity": "TEXT", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "addedInV2", |
| "columnName": "addedInV2", |
| "affinity": "INTEGER", |
| "notNull": true, |
| "defaultValue": "1" |
| } |
| ], |
| "primaryKey": { |
| "autoGenerate": false, |
| "columnNames": [ |
| "id" |
| ] |
| }, |
| "indices": [ |
| { |
| "name": "index_Entity26_addedInV2", |
| "unique": true, |
| "columnNames": [ |
| "addedInV2" |
| ], |
| "orders": [], |
| "createSql": "CREATE UNIQUE INDEX IF NOT EXISTS `index_Entity26_addedInV2` ON `${TABLE_NAME}` (`addedInV2`)" |
| } |
| ], |
| "foreignKeys": [] |
| }, |
| { |
| "tableName": "Entity27", |
| "createSql": "CREATE TABLE IF NOT EXISTS `${TABLE_NAME}` (`id27` INTEGER NOT NULL, `addedInV1` INTEGER NOT NULL DEFAULT 1, PRIMARY KEY(`id27`))", |
| "fields": [ |
| { |
| "fieldPath": "id27", |
| "columnName": "id27", |
| "affinity": "INTEGER", |
| "notNull": true |
| }, |
| { |
| "fieldPath": "addedInV1", |
| "columnName": "addedInV1", |
| "affinity": "INTEGER", |
| "notNull": true, |
| "defaultValue": "1" |
| } |
| ], |
| "primaryKey": { |
| "autoGenerate": false, |
| "columnNames": [ |
| "id27" |
| ] |
| }, |
| "indices": [], |
| "foreignKeys": [] |
| } |
| ], |
| "views": [ |
| { |
| "viewName": "Entity25Detail", |
| "createSql": "CREATE VIEW `${VIEW_NAME}` AS SELECT Entity25.id, Entity25.name, Entity25.entity1Id, Entity1.name AS userNameAndId FROM Entity25 INNER JOIN Entity1 ON Entity25.entity1Id = Entity1.id" |
| } |
| ], |
| "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, '7a7934a196e6d6eb3055b9957c91490c')" |
| ] |
| } |
| } |