Skip to content

Instantly share code, notes, and snippets.

@KonradIT
Last active January 8, 2022 11:50
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save KonradIT/d18d1b618a92ebb354ce54b27f620240 to your computer and use it in GitHub Desktop.
Save KonradIT/d18d1b618a92ebb354ce54b27f620240 to your computer and use it in GitHub Desktop.
// Copyright 2004-present Facebook. All Rights Reserved.
// Generated by com.facebook.crudolib.sqliteproc.codegenerator.generators.schemavalidation
// Learn more: https://fburl.com/sqlite-build-time-checks
// @generated
// This is generated code -- do not modify manually.
{
"filename" : "com/facebook/stella/database/model/StellaDatabase_SerializedDb.json",
"tables" : {
"media_item_global_id" : {
"table_name" : "media_item_global_id",
"indices" : [ ],
"unique_indices" : [ ],
"columns" : {
"global_id" : {
"name" : "global_id",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : true,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"media_item_id" : {
"name" : "media_item_id",
"type" : "LONG",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
}
},
"deleted" : false
},
"user_profile" : {
"table_name" : "user_profile",
"indices" : [ ],
"unique_indices" : [ ],
"columns" : {
"user_id" : {
"name" : "user_id",
"type" : "LONG",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : true,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"user_name" : {
"name" : "user_name",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"short_name" : {
"name" : "short_name",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : true,
"foreignKey" : null,
"bufferFriendly" : null
},
"profile_picture_uri" : {
"name" : "profile_picture_uri",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : true,
"foreignKey" : null,
"bufferFriendly" : null
}
},
"deleted" : false
},
"music_track" : {
"table_name" : "music_track",
"indices" : [ ],
"unique_indices" : [ ],
"columns" : {
"music_track_id" : {
"name" : "music_track_id",
"type" : "LONG",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : true,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"artist_name" : {
"name" : "artist_name",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"track_name" : {
"name" : "track_name",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"uri" : {
"name" : "uri",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"download_id" : {
"name" : "download_id",
"type" : "LONG",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"track_length_ms" : {
"name" : "track_length_ms",
"type" : "LONG",
"defaultValue" : "0",
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : true,
"foreignKey" : null,
"bufferFriendly" : null
},
"is_hardcoded" : {
"name" : "is_hardcoded",
"type" : "BOOL",
"defaultValue" : "1",
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : true,
"foreignKey" : null,
"bufferFriendly" : null
}
},
"deleted" : false
},
"capture" : {
"table_name" : "capture",
"indices" : [ {
"columns" : [ "source", "source_capture_id" ]
} ],
"unique_indices" : [ ],
"columns" : {
"capture_id" : {
"name" : "capture_id",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : true,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"source" : {
"name" : "source",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"source_capture_id" : {
"name" : "source_capture_id",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"type" : {
"name" : "type",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"capture_timestamp_ms" : {
"name" : "capture_timestamp_ms",
"type" : "LONG",
"defaultValue" : "0",
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"attributes_json" : {
"name" : "attributes_json",
"type" : "TEXT",
"defaultValue" : "{}",
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"has_processed" : {
"name" : "has_processed",
"type" : "BOOL",
"defaultValue" : "0",
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
}
},
"deleted" : false
},
"capture_asset" : {
"table_name" : "capture_asset",
"indices" : [ ],
"unique_indices" : [ ],
"columns" : {
"source_id" : {
"name" : "source_id",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : true,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"capture_id" : {
"name" : "capture_id",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : {
"referencesTable" : "capture",
"referencesColumn" : "capture_id",
"onUpdate" : "NO ACTION",
"onDelete" : "NO ACTION"
},
"bufferFriendly" : null
},
"type" : {
"name" : "type",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"attributes_json" : {
"name" : "attributes_json",
"type" : "TEXT",
"defaultValue" : "{}",
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"media_file_id" : {
"name" : "media_file_id",
"type" : "LONG",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"fetch_state" : {
"name" : "fetch_state",
"type" : "TEXT",
"defaultValue" : "fetch_not_enqueued",
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : true,
"added" : true,
"foreignKey" : null,
"bufferFriendly" : null
},
"fetch_channels" : {
"name" : "fetch_channels",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : true,
"foreignKey" : null,
"bufferFriendly" : null
},
"headers_json" : {
"name" : "headers_json",
"type" : "TEXT",
"defaultValue" : "{}",
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : true,
"foreignKey" : null,
"bufferFriendly" : null
}
},
"deleted" : false
},
"media_file" : {
"table_name" : "media_file",
"indices" : [ ],
"unique_indices" : [ ],
"columns" : {
"media_file_id" : {
"name" : "media_file_id",
"type" : "LONG",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : true,
"autoIncrement" : true,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"type" : {
"name" : "type",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"attributes_json" : {
"name" : "attributes_json",
"type" : "TEXT",
"defaultValue" : "{}",
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"headers_json" : {
"name" : "headers_json",
"type" : "TEXT",
"defaultValue" : "{}",
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"uri" : {
"name" : "uri",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"frame_width" : {
"name" : "frame_width",
"type" : "INTEGER",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"frame_height" : {
"name" : "frame_height",
"type" : "INTEGER",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"target_file_size" : {
"name" : "target_file_size",
"type" : "LONG",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"current_file_size" : {
"name" : "current_file_size",
"type" : "LONG",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"is_ready" : {
"name" : "is_ready",
"type" : "BOOL",
"defaultValue" : "0",
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
}
},
"deleted" : false
},
"media_item" : {
"table_name" : "media_item",
"indices" : [ {
"columns" : [ "originally_created_timestamp_ms" ]
} ],
"unique_indices" : [ ],
"columns" : {
"media_item_id" : {
"name" : "media_item_id",
"type" : "LONG",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : true,
"autoIncrement" : true,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"type" : {
"name" : "type",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"capture_id" : {
"name" : "capture_id",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : {
"referencesTable" : "capture",
"referencesColumn" : "capture_id",
"onUpdate" : "NO ACTION",
"onDelete" : "NO ACTION"
},
"bufferFriendly" : null
},
"originally_created_timestamp_ms" : {
"name" : "originally_created_timestamp_ms",
"type" : "LONG",
"defaultValue" : "0",
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"import_state" : {
"name" : "import_state",
"type" : "TEXT",
"defaultValue" : "import_unknown",
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : true,
"added" : true,
"foreignKey" : null,
"bufferFriendly" : null
},
"processing_states_json" : {
"name" : "processing_states_json",
"type" : "TEXT",
"defaultValue" : "{}",
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : true,
"foreignKey" : null,
"bufferFriendly" : null
},
"is_deleted" : {
"name" : "is_deleted",
"type" : "BOOL",
"defaultValue" : "0",
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : true,
"foreignKey" : null,
"bufferFriendly" : null
},
"is_corrupted" : {
"name" : "is_corrupted",
"type" : "BOOL",
"defaultValue" : "0",
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : true,
"foreignKey" : null,
"bufferFriendly" : null
}
},
"deleted" : false
},
"media_item_to_fwa_gallery_item" : {
"table_name" : "media_item_to_fwa_gallery_item",
"indices" : [ ],
"unique_indices" : [ ],
"columns" : {
"media_item_id" : {
"name" : "media_item_id",
"type" : "LONG",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : {
"referencesTable" : "media_item",
"referencesColumn" : "media_item_id",
"onUpdate" : "NO ACTION",
"onDelete" : "CASCADE"
},
"bufferFriendly" : null
},
"fwa_gallery_id" : {
"name" : "fwa_gallery_id",
"type" : "LONG",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
}
},
"deleted" : false
},
"media_item_display" : {
"table_name" : "media_item_display",
"indices" : [ {
"columns" : [ "media_item_id", "is_current_version" ]
}, {
"columns" : [ "is_current_version" ]
}, {
"columns" : [ "version_created_timestamp_ms" ]
}, {
"columns" : [ "display_thumbnail_media_file_id" ]
}, {
"columns" : [ "display_full_media_file_id" ]
} ],
"unique_indices" : [ {
"columns" : [ "media_item_id", "version" ]
} ],
"columns" : {
"media_item_id" : {
"name" : "media_item_id",
"type" : "LONG",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : {
"referencesTable" : "media_item",
"referencesColumn" : "media_item_id",
"onUpdate" : "NO ACTION",
"onDelete" : "CASCADE"
},
"bufferFriendly" : null
},
"version" : {
"name" : "version",
"type" : "INTEGER",
"defaultValue" : "0",
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"is_current_version" : {
"name" : "is_current_version",
"type" : "BOOL",
"defaultValue" : "0",
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"display_thumbnail_media_file_id" : {
"name" : "display_thumbnail_media_file_id",
"type" : "LONG",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : {
"referencesTable" : "media_file",
"referencesColumn" : "media_file_id",
"onUpdate" : "NO ACTION",
"onDelete" : "NO ACTION"
},
"bufferFriendly" : null
},
"display_full_media_file_id" : {
"name" : "display_full_media_file_id",
"type" : "LONG",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : {
"referencesTable" : "media_file",
"referencesColumn" : "media_file_id",
"onUpdate" : "NO ACTION",
"onDelete" : "NO ACTION"
},
"bufferFriendly" : null
},
"processed_full_media_file_id" : {
"name" : "processed_full_media_file_id",
"type" : "LONG",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : {
"referencesTable" : "media_file",
"referencesColumn" : "media_file_id",
"onUpdate" : "NO ACTION",
"onDelete" : "NO ACTION"
},
"bufferFriendly" : null
},
"version_created_timestamp_ms" : {
"name" : "version_created_timestamp_ms",
"type" : "LONG",
"defaultValue" : "0",
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"originally_created_timestamp_ms" : {
"name" : "originally_created_timestamp_ms",
"type" : "LONG",
"defaultValue" : "0",
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"duration_ms" : {
"name" : "duration_ms",
"type" : "LONG",
"defaultValue" : "0",
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : true,
"foreignKey" : null,
"bufferFriendly" : null
}
},
"deleted" : false
},
"media_item_to_media_file" : {
"table_name" : "media_item_to_media_file",
"indices" : [ {
"columns" : [ "media_item_id" ]
}, {
"columns" : [ "media_file_id" ]
} ],
"unique_indices" : [ {
"columns" : [ "media_item_id", "media_file_id" ]
} ],
"columns" : {
"media_item_id" : {
"name" : "media_item_id",
"type" : "LONG",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : {
"referencesTable" : "media_item",
"referencesColumn" : "media_item_id",
"onUpdate" : "NO ACTION",
"onDelete" : "CASCADE"
},
"bufferFriendly" : null
},
"media_file_id" : {
"name" : "media_file_id",
"type" : "LONG",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : {
"referencesTable" : "media_file",
"referencesColumn" : "media_file_id",
"onUpdate" : "NO ACTION",
"onDelete" : "CASCADE"
},
"bufferFriendly" : null
}
},
"deleted" : false
},
"media_source_to_media_file" : {
"table_name" : "media_source_to_media_file",
"indices" : [ {
"columns" : [ "media_file_id" ]
}, {
"columns" : [ "media_source" ]
} ],
"unique_indices" : [ {
"columns" : [ "media_source", "media_file_id" ]
} ],
"columns" : {
"media_source" : {
"name" : "media_source",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"media_file_id" : {
"name" : "media_file_id",
"type" : "LONG",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : {
"referencesTable" : "media_file",
"referencesColumn" : "media_file_id",
"onUpdate" : "NO ACTION",
"onDelete" : "CASCADE"
},
"bufferFriendly" : null
}
},
"deleted" : false
},
"album" : {
"table_name" : "album",
"indices" : [ ],
"unique_indices" : [ ],
"columns" : {
"album_id" : {
"name" : "album_id",
"type" : "INTEGER",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : true,
"autoIncrement" : true,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"folder_type" : {
"name" : "folder_type",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"title" : {
"name" : "title",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"cover_media_file_id" : {
"name" : "cover_media_file_id",
"type" : "LONG",
"defaultValue" : "0",
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"item_source" : {
"name" : "item_source",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"is_reorderable" : {
"name" : "is_reorderable",
"type" : "BOOL",
"defaultValue" : "0",
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"is_deleteable" : {
"name" : "is_deleteable",
"type" : "BOOL",
"defaultValue" : "0",
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
}
},
"deleted" : false
},
"album_item" : {
"table_name" : "album_item",
"indices" : [ ],
"unique_indices" : [ {
"columns" : [ "media_item_id", "position" ]
} ],
"columns" : {
"media_item_id" : {
"name" : "media_item_id",
"type" : "LONG",
"defaultValue" : "0",
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : {
"referencesTable" : "media_item",
"referencesColumn" : "media_item_id",
"onUpdate" : "NO ACTION",
"onDelete" : "CASCADE"
},
"bufferFriendly" : null
},
"album_id" : {
"name" : "album_id",
"type" : "INTEGER",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : {
"referencesTable" : "album",
"referencesColumn" : "album_id",
"onUpdate" : "NO ACTION",
"onDelete" : "NO ACTION"
},
"bufferFriendly" : null
},
"position" : {
"name" : "position",
"type" : "INTEGER",
"defaultValue" : "0",
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
}
},
"deleted" : false
},
"tags" : {
"table_name" : "tags",
"indices" : [ {
"columns" : [ "reference_table", "tag_name" ]
} ],
"unique_indices" : [ {
"columns" : [ "reference_table", "reference_table_id", "tag_name" ]
} ],
"columns" : {
"reference_table" : {
"name" : "reference_table",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"reference_table_id" : {
"name" : "reference_table_id",
"type" : "LONG",
"defaultValue" : "0",
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"tag_name" : {
"name" : "tag_name",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
}
},
"deleted" : false
},
"favorites" : {
"table_name" : "favorites",
"indices" : [ ],
"unique_indices" : [ ],
"columns" : {
"media_item_id" : {
"name" : "media_item_id",
"type" : "LONG",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : true,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : {
"referencesTable" : "media_item",
"referencesColumn" : "media_item_id",
"onUpdate" : "NO ACTION",
"onDelete" : "CASCADE"
},
"bufferFriendly" : null
}
},
"deleted" : false
},
"location" : {
"table_name" : "location",
"indices" : [ ],
"unique_indices" : [ ],
"columns" : {
"media_item_id" : {
"name" : "media_item_id",
"type" : "LONG",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : true,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : {
"referencesTable" : "media_item",
"referencesColumn" : "media_item_id",
"onUpdate" : "NO ACTION",
"onDelete" : "CASCADE"
},
"bufferFriendly" : null
},
"latitude" : {
"name" : "latitude",
"type" : "REAL",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"longitude" : {
"name" : "longitude",
"type" : "REAL",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"area_of_interest" : {
"name" : "area_of_interest",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"locality" : {
"name" : "locality",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"sub_locality" : {
"name" : "sub_locality",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"admin_area" : {
"name" : "admin_area",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"sub_admin_area" : {
"name" : "sub_admin_area",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"country_name" : {
"name" : "country_name",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"country_code" : {
"name" : "country_code",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"postal_code" : {
"name" : "postal_code",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
}
},
"deleted" : true
},
"face" : {
"table_name" : "face",
"indices" : [ ],
"unique_indices" : [ ],
"columns" : {
"face_id" : {
"name" : "face_id",
"type" : "INTEGER",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : true,
"autoIncrement" : true,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"face_location_top_left_x" : {
"name" : "face_location_top_left_x",
"type" : "REAL",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"face_location_top_left_y" : {
"name" : "face_location_top_left_y",
"type" : "REAL",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"face_location_bottom_right_x" : {
"name" : "face_location_bottom_right_x",
"type" : "REAL",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"face_location_bottom_right_y" : {
"name" : "face_location_bottom_right_y",
"type" : "REAL",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"media_file_id" : {
"name" : "media_file_id",
"type" : "LONG",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : {
"referencesTable" : "media_file",
"referencesColumn" : "media_file_id",
"onUpdate" : "NO ACTION",
"onDelete" : "CASCADE"
},
"bufferFriendly" : null
},
"model_version" : {
"name" : "model_version",
"type" : "INTEGER",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"embedded_data" : {
"name" : "embedded_data",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
}
},
"deleted" : false
},
"face_low_confidence_pair" : {
"table_name" : "face_low_confidence_pair",
"indices" : [ ],
"unique_indices" : [ {
"columns" : [ "face_id_one", "face_id_two" ]
} ],
"columns" : {
"face_id_one" : {
"name" : "face_id_one",
"type" : "INTEGER",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : {
"referencesTable" : "face",
"referencesColumn" : "face_id",
"onUpdate" : "NO ACTION",
"onDelete" : "NO ACTION"
},
"bufferFriendly" : null
},
"face_id_two" : {
"name" : "face_id_two",
"type" : "INTEGER",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : {
"referencesTable" : "face",
"referencesColumn" : "face_id",
"onUpdate" : "NO ACTION",
"onDelete" : "NO ACTION"
},
"bufferFriendly" : null
},
"cosine_similarity" : {
"name" : "cosine_similarity",
"type" : "REAL",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
}
},
"deleted" : false
},
"face_group" : {
"table_name" : "face_group",
"indices" : [ ],
"unique_indices" : [ ],
"columns" : {
"face_group_id" : {
"name" : "face_group_id",
"type" : "INTEGER",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : true,
"autoIncrement" : true,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"cosine_similarity_avg" : {
"name" : "cosine_similarity_avg",
"type" : "REAL",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"group_cluster_avg" : {
"name" : "group_cluster_avg",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
}
},
"deleted" : false
},
"face_to_face_group" : {
"table_name" : "face_to_face_group",
"indices" : [ ],
"unique_indices" : [ {
"columns" : [ "face_id", "face_group_id" ]
} ],
"columns" : {
"face_id" : {
"name" : "face_id",
"type" : "INTEGER",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : {
"referencesTable" : "face",
"referencesColumn" : "face_id",
"onUpdate" : "NO ACTION",
"onDelete" : "NO ACTION"
},
"bufferFriendly" : null
},
"face_group_id" : {
"name" : "face_group_id",
"type" : "INTEGER",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : {
"referencesTable" : "face_group",
"referencesColumn" : "face_group_id",
"onUpdate" : "NO ACTION",
"onDelete" : "NO ACTION"
},
"bufferFriendly" : null
}
},
"deleted" : false
},
"media_calibration" : {
"table_name" : "media_calibration",
"indices" : [ ],
"unique_indices" : [ ],
"columns" : {
"media_calibration_id" : {
"name" : "media_calibration_id",
"type" : "LONG",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : true,
"autoIncrement" : true,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"source" : {
"name" : "source",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"type" : {
"name" : "type",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"media_file_id" : {
"name" : "media_file_id",
"type" : "LONG",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : {
"referencesTable" : "media_file",
"referencesColumn" : "media_file_id",
"onUpdate" : "NO ACTION",
"onDelete" : "CASCADE"
},
"bufferFriendly" : null
}
},
"deleted" : true
},
"cloud_backup" : {
"table_name" : "cloud_backup",
"indices" : [ ],
"unique_indices" : [ ],
"columns" : {
"cloud_backup_id" : {
"name" : "cloud_backup_id",
"type" : "LONG",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : true,
"autoIncrement" : true,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"media_item_id" : {
"name" : "media_item_id",
"type" : "LONG",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : {
"referencesTable" : "media_item",
"referencesColumn" : "media_item_id",
"onUpdate" : "NO ACTION",
"onDelete" : "SET NULL"
},
"bufferFriendly" : null
},
"media_item_fbid" : {
"name" : "media_item_fbid",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"last_sync_timestamp_ms" : {
"name" : "last_sync_timestamp_ms",
"type" : "LONG",
"defaultValue" : "0",
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"backup_status" : {
"name" : "backup_status",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
}
},
"deleted" : true
},
"update_log" : {
"table_name" : "update_log",
"indices" : [ ],
"unique_indices" : [ ],
"columns" : {
"global_id" : {
"name" : "global_id",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : true,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"update_type" : {
"name" : "update_type",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"timestamp_ms" : {
"name" : "timestamp_ms",
"type" : "LONG",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"client_commit_id" : {
"name" : "client_commit_id",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : true,
"foreignKey" : null,
"bufferFriendly" : null
}
},
"deleted" : false
},
"device_assets" : {
"table_name" : "device_assets",
"indices" : [ ],
"unique_indices" : [ {
"columns" : [ "device_asset_id", "source" ]
} ],
"columns" : {
"device_asset_id" : {
"name" : "device_asset_id",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"source" : {
"name" : "source",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"type" : {
"name" : "type",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"attributes_json" : {
"name" : "attributes_json",
"type" : "TEXT",
"defaultValue" : "{}",
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"fetch_state" : {
"name" : "fetch_state",
"type" : "TEXT",
"defaultValue" : "fetch_not_enqueued",
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : true,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"fetch_channels" : {
"name" : "fetch_channels",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"media_file_id" : {
"name" : "media_file_id",
"type" : "LONG",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : {
"referencesTable" : "media_file",
"referencesColumn" : "media_file_id",
"onUpdate" : "NO ACTION",
"onDelete" : "CASCADE"
},
"bufferFriendly" : null
},
"headers_json" : {
"name" : "headers_json",
"type" : "TEXT",
"defaultValue" : "{}",
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : true,
"foreignKey" : null,
"bufferFriendly" : null
},
"is_stale" : {
"name" : "is_stale",
"type" : "BOOL",
"defaultValue" : "0",
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : true,
"foreignKey" : null,
"bufferFriendly" : null
}
},
"deleted" : false
},
"fwa_gallery" : {
"table_name" : "fwa_gallery",
"indices" : [ ],
"unique_indices" : [ ],
"columns" : {
"id" : {
"name" : "id",
"type" : "LONG",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : true,
"autoIncrement" : true,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"type" : {
"name" : "type",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"is_favorite" : {
"name" : "is_favorite",
"type" : "BOOL",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"create_ts" : {
"name" : "create_ts",
"type" : "LONG",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"update_ts" : {
"name" : "update_ts",
"type" : "LONG",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"capture_source" : {
"name" : "capture_source",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"file_size_type" : {
"name" : "file_size_type",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"state" : {
"name" : "state",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"uri" : {
"name" : "uri",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"thumbnail_uri" : {
"name" : "thumbnail_uri",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"global_id" : {
"name" : "global_id",
"type" : "TEXT",
"defaultValue" : "",
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : true,
"foreignKey" : null,
"bufferFriendly" : null
}
},
"deleted" : false
},
"bug_report" : {
"table_name" : "bug_report",
"indices" : [ ],
"unique_indices" : [ ],
"columns" : {
"client_id" : {
"name" : "client_id",
"type" : "LONG",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : true,
"autoIncrement" : true,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"flytrap_id" : {
"name" : "flytrap_id",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"has_media_attached" : {
"name" : "has_media_attached",
"type" : "BOOL",
"defaultValue" : "0",
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
}
},
"deleted" : false
},
"firmware_ota_update" : {
"table_name" : "firmware_ota_update",
"indices" : [ ],
"unique_indices" : [ ],
"columns" : {
"session_id" : {
"name" : "session_id",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : true,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"release_id" : {
"name" : "release_id",
"type" : "LONG",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"download_uri" : {
"name" : "download_uri",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"base_version" : {
"name" : "base_version",
"type" : "LONG",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"target_version" : {
"name" : "target_version",
"type" : "LONG",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"version_name" : {
"name" : "version_name",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"headers" : {
"name" : "headers",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"payload_size" : {
"name" : "payload_size",
"type" : "LONG",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"payload_offset" : {
"name" : "payload_offset",
"type" : "LONG",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"file_size" : {
"name" : "file_size",
"type" : "LONG",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"release_channel_id" : {
"name" : "release_channel_id",
"type" : "LONG",
"defaultValue" : "0",
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"release_notes" : {
"name" : "release_notes",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"file_checksum" : {
"name" : "file_checksum",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"download_id" : {
"name" : "download_id",
"type" : "LONG",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"local_uri" : {
"name" : "local_uri",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"last_checked_timestamp_ms" : {
"name" : "last_checked_timestamp_ms",
"type" : "LONG",
"defaultValue" : null,
"nullable" : false,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"trigger_source" : {
"name" : "trigger_source",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"waiting_for_device_reboot" : {
"name" : "waiting_for_device_reboot",
"type" : "BOOL",
"defaultValue" : "0",
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : false,
"foreignKey" : null,
"bufferFriendly" : null
},
"download_allow_metered" : {
"name" : "download_allow_metered",
"type" : "BOOL",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : true,
"foreignKey" : null,
"bufferFriendly" : null
},
"download_allow_roaming" : {
"name" : "download_allow_roaming",
"type" : "BOOL",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : true,
"added" : true,
"foreignKey" : null,
"bufferFriendly" : null
},
"release_tag" : {
"name" : "release_tag",
"type" : "TEXT",
"defaultValue" : null,
"nullable" : true,
"primaryKey" : false,
"autoIncrement" : false,
"renameTo" : null,
"deleted" : false,
"added" : true,
"foreignKey" : null,
"bufferFriendly" : null
}
},
"deleted" : false
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment