Skip to content

Schema changes from Photos 3 to Photos 4

Jump to bottom Edit New page
Rhet Turnbull edited this page Aug 10, 2020 · 1 revision 
 CREATE TABLE IF NOT EXISTS "RKPlace_RTree_node"(nodeno INTEGER PRIMARY KEY, data BLOB);
 CREATE TABLE IF NOT EXISTS "RKPlace_RTree_parent"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER);
 CREATE TABLE IF NOT EXISTS "RKPlace_RTree_rowid"(rowid INTEGER PRIMARY KEY, nodeno INTEGER);
 CREATE TABLE LiGlobals (
     modelId integer primary key,
     keyPath varchar,
     value varchar,
     blobValue blob
 );
 CREATE TABLE LiLibHistory (
     modelId integer primary key,
     modDate timestamp,
     eventType varchar,
     metaSchemaVersion integer,
     libraryVersion integer,
     comment varchar
 );
 CREATE TABLE LiPropertyDef (
     modelId integer primary key,
     keyPath varchar,
     tableId integer,
     propertyType integer,
     storage integer,
     desiredStorage integer,
     options integer
 );
 CREATE TABLE LiPropertyHistory (
     modelId integer primary key,
     tableId integer,
     modDate timestamp,
     originatingClient integer,
     changeId integer,
     keyPathList blob,
     changeType integer,
     memo varchar,
     reason integer,
     changeIdList blob
 );
 CREATE TABLE LiStringAtom (modelId integer primary key, string varchar);
 CREATE TABLE LiTableDef (
     modelId integer primary key,
     tableName varchar,
     databaseName varchar,
     digest varchar,
     ridIndexField varchar,
     tableOptions integer
 );
 CREATE TABLE RKAdjustmentData (
     modelId integer primary key autoincrement,
     uuid varchar,
     versionId integer,
     data blob,
     originator varchar,
     format varchar,
     formatVersion varchar,
     fingerprint varchar,
     orientation integer,
     editSource integer,
     naturalDuration decimal,
     renderTypes integer
 );
 CREATE TABLE RKAdjustmentData_modelId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKAdminData (
     modelId integer primary key autoincrement,
     propertyArea varchar,
     propertyName varchar,
     propertyValue varchar,
     blobPropertyValue blob,
     storedDataType integer,
     persistAfterRebuild integer
 );
 CREATE TABLE RKAdminData_modelId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKAlbum (
     modelId integer primary key autoincrement,
     uuid varchar,
     albumType integer,
     albumSubclass integer,
     name varchar,
     folderUuid varchar,
     queryFolderUuid varchar,
     posterVersionUuid varchar,
     selectedTrackPathUuid varchar,
     sortKeyPath varchar,
     sortAscending integer,
     customSortAvailable integer,
     createDate timestamp,
     isFavorite integer,
     isInTrash integer,
     inTrashDate timestamp,
     isHidden integer,
     isMagic integer,
     colorLabelIndex integer,
     faceSortKeyPath varchar,
     recentUserChangeDate timestamp,
     filterData blob,
     queryData blob,
     isPinned integer,
     cloudLibraryState integer,
     hasBeenSynced integer,
     cloudIdentifier varchar,
     isCloudQuarantined integer,
     projectExtensionIdentifier varchar,
-    projectDocumentType varchar
+    projectDocumentType varchar,
+    projectExtensionRenderedPreviewUuid varchar
 );
 CREATE TABLE RKAlbumVersion (
     modelId integer primary key autoincrement,
     versionId integer,
     albumId integer
 );
 CREATE TABLE RKAlbumVersion_albumId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKAlbumVersion_modelId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKAlbum_albumSubclass_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKAlbum_albumType_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKAlbum_cloudLibraryState_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKAlbum_dataNote (
     keyPath integer,
     value blob,
     attachedToId integer,
     primary key (attachedToId, keyPath)
 );
 CREATE TABLE RKAlbum_dateNote (
     keyPath integer,
     value timestamp,
     attachedToId integer,
     primary key (attachedToId, keyPath)
 );
 CREATE TABLE RKAlbum_decimalNote (
     keyPath integer,
     value decimal,
     attachedToId integer,
     primary key (attachedToId, keyPath)
 );
 CREATE TABLE RKAlbum_hasBeenSynced_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKAlbum_integerNote (
     keyPath integer,
     value integer,
     attachedToId integer,
     primary key (attachedToId, keyPath)
 );
 CREATE TABLE RKAlbum_isCloudQuarantined_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKAlbum_isHidden_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKAlbum_isInTrash_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKAlbum_isMagic_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKAlbum_modelId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKAlbum_stringNote (
     keyPath integer,
     value varchar,
     attachedToId integer,
     primary key (attachedToId, keyPath)
 );
 CREATE TABLE RKAttachment (
     modelId integer primary key autoincrement,
     uuid varchar,
     isInTrash integer,
     inTrashDate timestamp,
     attachedToClassType integer,
     attachedToUuid varchar,
     propertyKey varchar,
     filename varchar,
     fileIsReference integer,
     isMissing integer,
     duration decimal,
     fileModificationDate timestamp,
     filePath varchar,
     fileAliasData blob,
     propertiesData blob,
     bookmarkId integer,
     volumeId integer
 );
 CREATE TABLE RKAttachment_modelId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKBookmark (
     modelId integer primary key autoincrement,
     data blob
 );
 CREATE TABLE RKBookmark_modelId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKCloudResource (
     modelId integer primary key autoincrement,
     fingerprint varchar,
     associatedModelType integer,
     identifier varchar,
     type integer,
     available integer,
     status integer,
     fileSize integer,
     width integer,
     height integer,
     lastAccessDate timestamp,
     pinnedUntilDate timestamp,
     UTI integer,
     transientFilePath varchar,
     isOnDisk integer,
     adjustmentUuid varchar,
     baseScore integer,
     isFullSizeOutput integer
 );
 CREATE TABLE RKCloudResource_available_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKCloudResource_isFullSizeOutput_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKCloudResource_isOnDisk_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKCloudResource_modelId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKCloudResource_status_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKCloudResource_type_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKCustomSortOrder (
     modelId integer primary key autoincrement,
     containerUuid varchar,
     objectUuid varchar,
     orderNumber integer
 );
 CREATE TABLE RKCustomSortOrder_modelId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKFace (
     modelId integer primary key autoincrement,
     uuid varchar,
     isInTrash integer,
     personId integer,
     hasBeenSynced integer,
     adjustmentUuid varchar,
     imageModelId integer,
     sourceWidth integer,
     sourceHeight integer,
     centerX decimal,
     centerY decimal,
     size decimal,
     leftEyeX decimal,
     leftEyeY decimal,
     rightEyeX decimal,
     rightEyeY decimal,
     mouthX decimal,
     mouthY decimal,
     hidden integer,
     manual integer,
     hasSmile integer,
     blurScore decimal,
     isLeftEyeClosed integer,
     isRightEyeClosed integer,
     nameSource integer,
     poseRoll decimal,
     poseYaw decimal,
     posePitch decimal,
     faceAlgorithmVersion integer,
     expressionConfidence decimal,
     expressionType1 integer,
     expressionType2 integer,
     expressionType3 integer,
     expressionScore1 decimal,
     expressionScore2 decimal,
     expressionScore3 decimal,
     qualityMeasure integer,
     clusterSequenceNumber integer,
     syncPropertyModifiedDate timestamp,
     faceGroupId integer,
     confirmedFaceCropGenerationState integer,
     faceType integer,
     trainingType integer,
     cloudNameSource integer,
     personUuid varchar
 );
 CREATE TABLE RKFaceCrop (
     modelId integer primary key autoincrement,
     uuid varchar,
     personId integer,
     cloudLibraryState integer,
     hasBeenSynced integer,
     cloudIdentifier varchar,
     isCloudQuarantined integer,
     type integer,
     faceId integer,
     resourceData blob,
     faceCropType integer,
     state integer,
     invalidMergeCandidatePersonIdentifier varchar
 );
 CREATE TABLE RKFaceCrop_cloudLibraryState_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKFaceCrop_hasBeenSynced_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKFaceCrop_isCloudQuarantined_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKFaceCrop_modelId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKFaceCrop_state_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKFaceCrop_type_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKFaceGroup (
     modelId integer primary key autoincrement,
     uuid varchar,
     personId integer,
     faceGroupType integer,
     representativeFaceId integer,
     personBuilderState integer
 );
 CREATE TABLE RKFaceGroup_faceGroupType_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKFaceGroup_modelId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKFaceGroup_personBuilderState_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKFacePrint (
     modelId integer primary key autoincrement,
     uuid varchar,
     faceId integer,
     faceprintVersion integer,
     faceprint blob
 );
 CREATE TABLE RKFacePrint_modelId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKFace_confirmedFaceCropGenerationState_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKFace_faceAlgorithmVersion_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKFace_faceType_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKFace_hasBeenSynced_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKFace_hidden_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKFace_isInTrash_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKFace_manual_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKFace_modelId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKFace_nameSource_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKFace_trainingType_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKFolder (
     modelId integer primary key autoincrement,
     uuid varchar,
     name varchar,
     posterVersionUuid varchar,
     sortKeyPath varchar,
     sortAscending integer,
     createDate timestamp,
     isFavorite integer,
     isInTrash integer,
     inTrashDate timestamp,
     isHidden integer,
     isMagic integer,
     colorLabelIndex integer,
     cloudLibraryState integer,
     hasBeenSynced integer,
     cloudIdentifier varchar,
     isCloudQuarantined integer,
     folderType integer,
     parentFolderUuid varchar,
     implicitAlbumUuid varchar,
     automaticallyGenerateFullSizePreviews integer,
     minImageTimeZoneName varchar,
     maxImageTimeZoneName varchar,
     minImageDate timestamp,
     maxImageDate timestamp,
     folderPath varchar,
     isExpanded integer,
     isHiddenWhenEmpty integer
 );
 CREATE TABLE RKFolder_cloudLibraryState_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKFolder_folderType_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKFolder_hasBeenSynced_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKFolder_integerNote (
     keyPath integer,
     value integer,
     attachedToId integer,
     primary key (attachedToId, keyPath)
 );
 CREATE TABLE RKFolder_isCloudQuarantined_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKFolder_modelId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKImageMask (
     modelId integer primary key autoincrement,
     uuid varchar,
     createDate timestamp
 );
 CREATE TABLE RKImageMask_modelId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKImageProxyState (
     modelId integer primary key autoincrement,
     versionId integer,
     thumbnailsCurrent integer,
     miniThumbnailsCurrent integer,
     tinyThumbnailsCurrent integer,
     fullSizePreviewUpToDate integer,
     thumbnailCacheIndex integer,
     thumbnailRendered integer,
     previewRendered integer,
     previewJpegHeight integer,
     previewJpegWidth integer,
     thumbnailHeight integer,
     thumbnailWidth integer,
     miniThumbnailHeight integer,
     miniThumbnailWidth integer,
     tinyThumbnailHeight integer,
     tinyThumbnailWidth integer,
     faceTilesCurrent integer,
     previewGenerationVersion integer,
     microThumbnailOrientation integer,
     previewJpegOrientation integer,
     thumbnailOrientation integer,
     miniThumbnailOrientation integer,
     tinyThumbnailOrientation integer,
     microThumbnailsCurrent integer,
     microThumbnailHeight integer,
     microThumbnailWidth integer,
     segmentColorSpace integer
 );
 CREATE TABLE RKImageProxyState_faceTilesCurrent_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKImageProxyState_fullSizePreviewUpToDate_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKImageProxyState_microThumbnailsCurrent_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKImageProxyState_miniThumbnailsCurrent_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKImageProxyState_modelId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKImageProxyState_previewRendered_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKImageProxyState_thumbnailRendered_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKImageProxyState_thumbnailsCurrent_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKImageProxyState_tinyThumbnailsCurrent_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKImportGroup (
     modelId integer primary key autoincrement,
     uuid varchar,
     name varchar,
     importDate timestamp,
     isSynthesized integer
 );
 CREATE TABLE RKImportGroup_modelId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKImportMoment (
     modelId integer primary key autoincrement,
     uuid varchar,
     importDate timestamp,
     lastModifiedDate timestamp
 );
 CREATE TABLE RKImportMoment_modelId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKKeyword (
     modelId integer primary key autoincrement,
     uuid varchar,
     name varchar,
     searchName varchar,
     hasChildren integer,
     shortcut varchar
 );
 CREATE TABLE RKKeywordForVersion (
     modelId integer primary key autoincrement,
     versionId integer,
     keywordId integer
 );
 CREATE TABLE RKKeywordForVersion_modelId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKKeyword_modelId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKMaster (
     modelId integer primary key autoincrement,
     uuid varchar,
     fingerprint varchar,
     orientation integer,
     name varchar,
     createDate timestamp,
     isInTrash integer,
     inTrashDate timestamp,
     cloudLibraryState integer,
     hasBeenSynced integer,
     isCloudQuarantined integer,
     fileIsReference integer,
     isMissing integer,
     duration decimal,
     fileModificationDate timestamp,
     bookmarkId integer,
     volumeId integer,
     fileSize integer,
     width integer,
     height integer,
     UTI varchar,
     importGroupUuid varchar,
     alternateMasterUuid varchar,
     originalVersionName varchar,
     fileName varchar,
     isExternallyEditable integer,
     isTrulyRaw integer,
     hasAttachments integer,
     hasNotes integer,
     imagePath varchar,
     imageDate timestamp,
     fileCreationDate timestamp,
     originalFileName varchar,
     originalFileSize integer,
     importedBy integer,
     originatingAssetIdentifier varchar,
     burstUuid varchar,
     importComplete integer,
     imageTimeZoneOffsetSeconds integer,
     photoStreamTagId varchar,
     mediaGroupId varchar,
     hasCheckedMediaGroupId integer,
     groupingUuid varchar,
     cloudImportedBy integer
 );
 CREATE TABLE RKMaster_cloudLibraryState_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKMaster_dataNote (
     keyPath integer,
     value blob,
     attachedToId integer,
     primary key (attachedToId, keyPath)
 );
 CREATE TABLE RKMaster_fileIsReference_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKMaster_fingerprint_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKMaster_hasAttachments_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKMaster_hasBeenSynced_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKMaster_hasCheckedMediaGroupId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKMaster_importComplete_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKMaster_importedBy_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKMaster_integerNote (
     keyPath integer,
     value integer,
     attachedToId integer,
     primary key (attachedToId, keyPath)
 );
 CREATE TABLE RKMaster_isCloudQuarantined_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKMaster_isExternallyEditable_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKMaster_isInTrash_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKMaster_isMissing_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKMaster_isTrulyRaw_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKMaster_modelId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKMaster_originatingAssetIdentifier_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKMaster_photoStreamTagId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKMaster_stringNote (
     keyPath integer,
     value varchar,
     attachedToId integer,
     primary key (attachedToId, keyPath)
 );
 CREATE TABLE RKMaster_volumeId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKMemory (
     modelId integer primary key autoincrement,
     uuid varchar,
     createDate timestamp,
     cloudLibraryState integer,
     hasBeenSynced integer,
     cloudIdentifier varchar,
     isCloudQuarantined integer,
     title varchar,
     subTitle varchar,
     keyVersionId integer,
     category integer,
     rejected integer,
     photosGraphVersion integer,
     photosGraphData blob,
     movieData blob,
     movieAssetState blob,
     pending integer,
     subcategory integer,
     score decimal,
     favorite integer,
     userCreated integer,
     queryHintData blob,
     notificationState integer,
     blacklistedFeature blob,
     viewCount integer,
     playCount integer,
     shareCount integer
 );
 CREATE TABLE RKMemoryCuratedVersion (
     modelId integer primary key autoincrement,
     versionId integer,
     memoryId integer
 );
 CREATE TABLE RKMemoryCuratedVersion_memoryId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKMemoryCuratedVersion_modelId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKMemoryExtendedCuratedVersion (
     modelId integer primary key autoincrement,
     versionId integer,
     memoryId integer
 );
 CREATE TABLE RKMemoryExtendedCuratedVersion_memoryId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKMemoryExtendedCuratedVersion_modelId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKMemoryMovieVersion (
     modelId integer primary key autoincrement,
     versionId integer,
     memoryId integer
 );
 CREATE TABLE RKMemoryMovieVersion_memoryId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKMemoryMovieVersion_modelId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKMemoryRepresentativeVersion (
     modelId integer primary key autoincrement,
     versionId integer,
     memoryId integer
 );
 CREATE TABLE RKMemoryRepresentativeVersion_memoryId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKMemoryRepresentativeVersion_modelId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKMemory_cloudLibraryState_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKMemory_favorite_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKMemory_hasBeenSynced_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKMemory_isCloudQuarantined_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKMemory_modelId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKMemory_notificationState_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKMemory_pending_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKMemory_rejected_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKMemory_subcategory_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKModelResource (
     modelId integer primary key autoincrement,
     UTI varchar,
     isOnDisk integer,
     attachedModelId integer,
     attachedModelType integer,
     resourceType integer,
     resourceTag varchar,
     resourceIsReference integer
 );
 CREATE TABLE RKModelResource_attachedModelType_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKModelResource_integerNote (
     keyPath integer,
     value integer,
     attachedToId integer,
     primary key (attachedToId, keyPath)
 );
 CREATE TABLE RKModelResource_isOnDisk_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKModelResource_modelId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKModelResource_resourceType_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKModelResource_stringNote (
     keyPath integer,
     value varchar,
     attachedToId integer,
     primary key (attachedToId, keyPath)
 );
 CREATE TABLE RKMoment (
     modelId integer primary key autoincrement,
     uuid varchar,
     versionCount integer,
     lastModifiedDate timestamp,
     startDate timestamp,
     endDate timestamp,
     representativeDate timestamp,
     yearUuid varchar,
     collectionUuid varchar,
     generationType integer,
     reverseLocationData blob,
     reverseLocationDataIsValid integer,
     needsRebuild integer,
     primaryPlaceData blob,
     secondaryPlaceData blob,
     userTitlesData blob,
     approximateLocationData blob
 );
 CREATE TABLE RKMomentCollection (
     modelId integer primary key autoincrement,
     uuid varchar,
     startDate timestamp,
     endDate timestamp,
     representativeDate timestamp,
     generationType integer,
     reverseLocationData blob,
     reverseLocationDataIsValid integer,
     primaryPlaceData blob,
     secondaryPlaceData blob,
     userTitlesData blob,
     sortIndex integer
 );
 CREATE TABLE RKMomentCollection_modelId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKMomentYear (
     modelId integer primary key autoincrement,
     uuid varchar,
     startDate timestamp,
     endDate timestamp,
     representativeDate timestamp,
     generationType integer,
     reverseLocationData blob,
     reverseLocationDataIsValid integer,
     primaryPlaceData blob,
     secondaryPlaceData blob,
     sortIndex integer
 );
 CREATE TABLE RKMomentYear_modelId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKMoment_modelId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKMoment_reverseLocationDataIsValid_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKPerson (
     modelId integer primary key autoincrement,
     uuid varchar,
     name varchar,
     cloudLibraryState integer,
     hasBeenSynced integer,
     cloudIdentifier varchar,
     isCloudQuarantined integer,
     representativeFaceId integer,
     manualOrder integer,
     personType integer,
     personUri varchar,
     isInPersonNamingModel integer,
     isVerified integer,
     associatedClusterId integer,
     faceCount integer,
     displayName varchar,
     verifiedType integer,
     mergeTargetPersonId integer,
     pendingMergeTargetPersonCloudIdentifier varchar
 );
 CREATE TABLE RKPersonInvalidMergeCandidatePerson (
     modelId integer primary key autoincrement,
     personId integer,
     invalidMergeCandidatePersonId integer
 );
 CREATE TABLE RKPersonInvalidMergeCandidatePerson_modelId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKPersonMergeCandidatePerson (
     modelId integer primary key autoincrement,
     personId integer,
     mergeCandidatePersonId integer
 );
 CREATE TABLE RKPersonMergeCandidatePerson_modelId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKPersonRejectedFace (
     modelId integer primary key autoincrement,
     personId integer,
     faceId integer
 );
 CREATE TABLE RKPersonRejectedFaceNeedingFaceCrop (
     modelId integer primary key autoincrement,
     personId integer,
     faceId integer
 );
 CREATE TABLE RKPersonRejectedFaceNeedingFaceCrop_modelId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKPersonRejectedFaceNeedingFaceCrop_personId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKPersonRejectedFace_modelId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKPerson_cloudLibraryState_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKPerson_dataNote (
     keyPath integer,
     value blob,
     attachedToId integer,
     primary key (attachedToId, keyPath)
 );
 CREATE TABLE RKPerson_hasBeenSynced_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKPerson_isCloudQuarantined_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKPerson_isInPersonNamingModel_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKPerson_isVerified_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKPerson_modelId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKPerson_pendingMergeTargetPersonCloudIdentifier_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKPerson_personType_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKPerson_verifiedType_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKPlace (
     modelId integer primary key autoincrement,
     uuid varchar,
     modDate timestamp,
     createDate timestamp,
     type integer,
     defaultName varchar,
     recordLocator integer,
     userDefined integer,
     providerId varchar,
     providerVersion integer,
     minLongitude decimal,
     maxLongitude decimal,
     minLatitude decimal,
     maxLatitude decimal,
     countryCode varchar,
     centroid varchar,
     area decimal
 );
 CREATE TABLE RKPlaceForVersion (
     modelId integer primary key autoincrement,
     versionId integer,
     placeId integer
 );
 CREATE TABLE RKPlaceForVersion_modelId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKPlace_modelId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKSceneInVersion (
     modelId integer primary key autoincrement,
     versionId integer,
     sceneIdentifier integer,
     confidence decimal
 );
 CREATE TABLE RKSceneInVersion_modelId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKSceneInVersion_versionId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKVersion (
     modelId integer primary key autoincrement,
     uuid varchar,
     orientation integer,
     naturalDuration decimal,
     name varchar,
     createDate timestamp,
     isFavorite integer,
     isInTrash integer,
     inTrashDate timestamp,
     isHidden integer,
     colorLabelIndex integer,
     cloudLibraryState integer,
     hasBeenSynced integer,
     cloudIdentifier varchar,
     isCloudQuarantined integer,
     fileIsReference integer,
     type integer,
     adjustmentUuid varchar,
     lastModifiedDate timestamp,
     fileName varchar,
     hasNotes integer,
     imageDate timestamp,
     burstUuid varchar,
     imageTimeZoneOffsetSeconds integer,
     groupingUuid varchar,
     reverseLocationData blob,
     reverseLocationDataIsValid integer,
     versionNumber integer,
     masterUuid varchar,
     masterId integer,
     rawMasterUuid varchar,
     nonRawMasterUuid varchar,
     imageTimeZoneName varchar,
     mainRating integer,
     isFlagged integer,
     isEditable integer,
     masterHeight integer,
     masterWidth integer,
     processedHeight integer,
     processedWidth integer,
     hasAdjustments integer,
     overridePlaceId integer,
     latitude decimal,
     longitude decimal,
     exifLatitude decimal,
     exifLongitude decimal,
     renderVersion integer,
     supportedStatus integer,
     videoInPoint varchar,
     videoOutPoint varchar,
     videoPosterFramePoint varchar,
     showInLibrary integer,
     editState integer,
     contentVersion integer,
     propertiesVersion integer,
     faceDetectionIsFromPreview integer,
     faceDetectionRotationFromMaster integer,
     hasKeywords integer,
     subType integer,
     specialType integer,
     momentUuid varchar,
     burstPickType integer,
     extendedDescription varchar,
     outputUpToDate integer,
     previewsAdjustmentUuid varchar,
     pendingAdjustmentUuid varchar,
     faceAdjustmentUuid varchar,
     lastSharedDate timestamp,
     videoCpDurationValue integer,
     videoCpDurationTimescale integer,
     videoCpImageDisplayValue integer,
     videoCpImageDisplayTimescale integer,
     videoCpVisibilityState integer,
     colorSpaceValidationState integer,
     momentSortIdx integer,
     sceneAlgorithmVersion integer,
     sceneAdjustmentUuid varchar,
     graphProcessingState integer,
     mediaAnalysisProcessingState integer,
     mediaAnalysisData blob,
     mediaAnalysisVersion integer,
     statViewCount integer,
     statPlayCount integer,
     statShareCount integer,
     curationScore decimal,
     playbackStyle integer,
     playbackVariation integer,
     renderEffect integer,
     groupingState integer,
     cloudGroupingState integer,
     importMomentId integer,
     selfPortrait integer,
     syncFailureHidden integer,
-    searchIndexInvalid integer
+    searchIndexInvalid integer,
+    hdrGain decimal
 );
 CREATE TABLE RKVersionAnalysisState (
     modelId integer primary key autoincrement,
     versionId integer,
     versionUuid varchar,
     workerType integer,
     analysisState integer,
     lastIgnoredDate timestamp,
     ignoreUntilDate timestamp,
     workerFlags integer
 );
 CREATE TABLE RKVersionAnalysisState_analysisState_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKVersionAnalysisState_modelId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKVersionAnalysisState_workerType_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKVersion_burstPickType_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKVersion_cloudLibraryState_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKVersion_colorSpaceValidationState_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKVersion_dataNote (
     keyPath integer,
     value blob,
     attachedToId integer,
     primary key (attachedToId, keyPath)
 );
 CREATE TABLE RKVersion_dateNote (
     keyPath integer,
     value timestamp,
     attachedToId integer,
     primary key (attachedToId, keyPath)
 );
 CREATE TABLE RKVersion_decimalNote (
     keyPath integer,
     value decimal,
     attachedToId integer,
     primary key (attachedToId, keyPath)
 );
 CREATE TABLE RKVersion_faceDetectionIsFromPreview_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKVersion_fileIsReference_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKVersion_graphProcessingState_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKVersion_groupingState_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKVersion_hasBeenSynced_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKVersion_hasKeywords_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKVersion_integerNote (
     keyPath integer,
     value integer,
     attachedToId integer,
     primary key (attachedToId, keyPath)
 );
 CREATE TABLE RKVersion_isCloudQuarantined_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKVersion_isFavorite_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKVersion_isHidden_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKVersion_isInTrash_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKVersion_mediaAnalysisProcessingState_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKVersion_modelId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKVersion_momentUuid_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKVersion_outputUpToDate_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKVersion_playbackStyle_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKVersion_playbackVariation_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKVersion_renderEffect_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKVersion_searchIndexInvalid_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKVersion_selfPortrait_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKVersion_showInLibrary_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKVersion_specialType_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKVersion_stringAtomNote (
     keyPath integer,
     value integer,
     attachedToId integer,
     primary key (attachedToId, keyPath)
 );
 CREATE TABLE RKVersion_stringNote (
     keyPath integer,
     value varchar,
     attachedToId integer,
     primary key (attachedToId, keyPath)
 );
 CREATE TABLE RKVersion_subType_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKVersion_supportedStatus_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKVersion_syncFailureHidden_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKVersion_type_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKVersion_videoCpVisibilityState_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE RKVolume (
     modelId integer primary key autoincrement,
     uuid varchar,
     modDate timestamp,
     name varchar,
     createDate timestamp,
     bookmarkId integer,
     diskUuid varchar,
     label varchar,
     isOffline integer,
     bookmarkSSBId integer
 );
 CREATE TABLE RKVolume_modelId_RidIndex (
     modelId integer primary key,
     value varchar,
     rids blob
 );
 CREATE TABLE sqlite_sequence(name, seq);
Add a custom footer
Add a custom sidebar
Clone this wiki locally