Skip to content

Instantly share code, notes, and snippets.

@RhetTbull

RhetTbull/Apple Photos database schema 10.12.6

Last active July 21, 2024 06:34
Show Gist options
  • Save RhetTbull/cb9bf274878c852ebdd14eef041841d9 to your computer and use it in GitHub Desktop.
Save RhetTbull/cb9bf274878c852ebdd14eef041841d9 to your computer and use it in GitHub Desktop.
Download ZIP
sqlite3 ".schema" of Photos Library.photoslibrary/database/photos.db on 10.12.6
Raw
Apple Photos database schema 10.12.6
CREATE VIRTUAL TABLE RidList_VirtualReader using RidList_VirtualReaderModule;
CREATE VIRTUAL TABLE Array_VirtualReader using Array_VirtualReaderModule;
CREATE TABLE LiGlobals (modelId integer primary key, keyPath varchar, value varchar, blobValue blob);
CREATE INDEX LiGlobals_keyPath_index on LiGlobals(keyPath);
CREATE VIRTUAL TABLE LiGlobals_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TABLE LiLibHistory (modelId integer primary key, modDate timestamp, eventType varchar, metaSchemaVersion integer, libraryVersion integer, comment varchar);
CREATE INDEX LiLibHistory_eventType_index on LiLibHistory(eventType);
CREATE VIRTUAL TABLE LiLibHistory_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TABLE LiStringAtom (modelId integer primary key, string varchar);
CREATE INDEX LiStringAtom_string_index on LiStringAtom(string);
CREATE VIRTUAL TABLE LiStringAtom_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TABLE LiTableDef (modelId integer primary key, tableName varchar, databaseName varchar, digest varchar, ridIndexField varchar, tableOptions integer);
CREATE INDEX LiTableDef_tableName_index on LiTableDef(tableName);
CREATE VIRTUAL TABLE LiTableDef_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TABLE LiPropertyDef (modelId integer primary key, keyPath varchar, tableId integer, propertyType integer, storage integer, desiredStorage integer, options integer);
CREATE INDEX LiPropertyDef_keyPath_index on LiPropertyDef(keyPath);
CREATE VIRTUAL TABLE LiPropertyDef_VirtualBufferReader using VirtualBufferReaderModule;
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 VIRTUAL TABLE LiPropertyHistory_VirtualBufferReader using VirtualBufferReaderModule;
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);
CREATE TABLE sqlite_sequence(name,seq);
CREATE INDEX RKAdjustmentData_uuid_index on RKAdjustmentData(uuid);
CREATE INDEX RKAdjustmentData_versionId_index on RKAdjustmentData(versionId);
CREATE TABLE RKAdjustmentData_modelId_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE VIRTUAL TABLE RKAdjustmentData_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TRIGGER RKAdjustmentData_ridIndexDeleteTrigger before delete on RKAdjustmentData begin select RKAdjustmentData_notifyRidIndexDelete(old.modelId,old.modelId) from RKAdjustmentData where rowid=old.rowid; end;
CREATE TRIGGER RKAdjustmentData_ridIndexInsertTrigger after insert on RKAdjustmentData begin select RKAdjustmentData_notifyRidIndexInsert(new.modelId,new.modelId) from RKAdjustmentData where rowid=new.rowid; end;
CREATE TRIGGER RKAdjustmentData_ridIndexUpdateTrigger after update of modelId on RKAdjustmentData begin select RKAdjustmentData_notifyRidIndexUpdate(new.modelId,old.modelId,new.modelId) from RKAdjustmentData where rowid=old.rowid; end;
CREATE TABLE RKAdminData (modelId integer primary key autoincrement, propertyArea varchar, propertyName varchar, propertyValue varchar, blobPropertyValue blob, storedDataType integer, persistAfterRebuild integer);
CREATE INDEX RKAdminData_propertyArea_index on RKAdminData(propertyArea);
CREATE INDEX RKAdminData_persistAfterRebuild_index on RKAdminData(persistAfterRebuild);
CREATE TABLE RKAdminData_modelId_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE VIRTUAL TABLE RKAdminData_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TRIGGER RKAdminData_ridIndexDeleteTrigger before delete on RKAdminData begin select RKAdminData_notifyRidIndexDelete(old.modelId,old.modelId) from RKAdminData where rowid=old.rowid; end;
CREATE TRIGGER RKAdminData_ridIndexInsertTrigger after insert on RKAdminData begin select RKAdminData_notifyRidIndexInsert(new.modelId,new.modelId) from RKAdminData where rowid=new.rowid; end;
CREATE TRIGGER RKAdminData_ridIndexUpdateTrigger after update of modelId on RKAdminData begin select RKAdminData_notifyRidIndexUpdate(new.modelId,old.modelId,new.modelId) from RKAdminData where rowid=old.rowid; end;
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);
CREATE INDEX RKAlbum_uuid_index on RKAlbum(uuid);
CREATE INDEX RKAlbum_folderUuid_index on RKAlbum(folderUuid);
CREATE INDEX RKAlbum_createDate_index on RKAlbum(createDate);
CREATE INDEX RKAlbum_inTrashDate_index on RKAlbum(inTrashDate);
CREATE INDEX RKAlbum_recentUserChangeDate_index on RKAlbum(recentUserChangeDate);
CREATE INDEX RKAlbum_cloudIdentifier_index on RKAlbum(cloudIdentifier);
CREATE TABLE RKAlbum_integerNote (keyPath integer, value integer, attachedToId integer, primary key (attachedToId, keyPath));
CREATE INDEX RKAlbum_integerNote_value_index on RKAlbum_integerNote(value);
CREATE VIRTUAL TABLE RKAlbum_integerNote_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TABLE RKAlbum_dataNote (keyPath integer, value blob, attachedToId integer, primary key (attachedToId, keyPath));
CREATE VIRTUAL TABLE RKAlbum_dataNote_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TABLE RKAlbum_stringNote (keyPath integer, value varchar, attachedToId integer, primary key (attachedToId, keyPath));
CREATE INDEX RKAlbum_stringNote_value_index on RKAlbum_stringNote(value);
CREATE VIRTUAL TABLE RKAlbum_stringNote_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TABLE RKAlbum_decimalNote (keyPath integer, value decimal, attachedToId integer, primary key (attachedToId, keyPath));
CREATE INDEX RKAlbum_decimalNote_value_index on RKAlbum_decimalNote(value);
CREATE VIRTUAL TABLE RKAlbum_decimalNote_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TABLE RKAlbum_dateNote (keyPath integer, value timestamp, attachedToId integer, primary key (attachedToId, keyPath));
CREATE INDEX RKAlbum_dateNote_value_index on RKAlbum_dateNote(value);
CREATE VIRTUAL TABLE RKAlbum_dateNote_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TABLE RKAlbum_modelId_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_albumSubclass_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_isHidden_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_hasBeenSynced_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE TABLE RKAlbum_isCloudQuarantined_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE VIRTUAL TABLE RKAlbum_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TRIGGER RKAlbum_ridIndexDeleteTrigger before delete on RKAlbum begin select RKAlbum_notifyRidIndexDelete(old.modelId,old.albumSubclass,old.isHidden,old.isInTrash,old.isCloudQuarantined,old.modelId,old.cloudLibraryState,old.hasBeenSynced,old.albumType) from RKAlbum where rowid=old.rowid; end;
CREATE TRIGGER RKAlbum_ridIndexInsertTrigger after insert on RKAlbum begin select RKAlbum_notifyRidIndexInsert(new.modelId,new.albumSubclass,new.isHidden,new.isInTrash,new.isCloudQuarantined,new.modelId,new.cloudLibraryState,new.hasBeenSynced,new.albumType) from RKAlbum where rowid=new.rowid; end;
CREATE TRIGGER RKAlbum_ridIndexUpdateTrigger after update of albumSubclass,isHidden,isInTrash,isCloudQuarantined,modelId,cloudLibraryState,hasBeenSynced,albumType on RKAlbum begin select RKAlbum_notifyRidIndexUpdate(new.modelId,old.albumSubclass,old.isHidden,old.isInTrash,old.isCloudQuarantined,old.modelId,old.cloudLibraryState,old.hasBeenSynced,old.albumType,new.albumSubclass,new.isHidden,new.isInTrash,new.isCloudQuarantined,new.modelId,new.cloudLibraryState,new.hasBeenSynced,new.albumType) from RKAlbum where rowid=old.rowid; end;
CREATE TABLE RKAlbumVersion (modelId integer primary key autoincrement, versionId integer, albumId integer);
CREATE INDEX RKAlbumVersion_versionId_index on RKAlbumVersion(versionId);
CREATE TABLE RKAlbumVersion_modelId_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE TABLE RKAlbumVersion_albumId_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE VIRTUAL TABLE RKAlbumVersion_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TRIGGER RKAlbumVersion_ridIndexDeleteTrigger before delete on RKAlbumVersion begin select RKAlbumVersion_notifyRidIndexDelete(old.versionId,old.modelId,old.albumId,old.modelId) from RKAlbumVersion where rowid=old.rowid; end;
CREATE TRIGGER RKAlbumVersion_ridIndexInsertTrigger after insert on RKAlbumVersion begin select RKAlbumVersion_notifyRidIndexInsert(new.versionId,new.modelId,new.albumId,new.modelId) from RKAlbumVersion where rowid=new.rowid; end;
CREATE TRIGGER RKAlbumVersion_ridIndexUpdateTrigger after update of albumId,modelId on RKAlbumVersion begin select RKAlbumVersion_notifyRidIndexUpdate(new.versionId,new.modelId,old.albumId,old.modelId,new.albumId,new.modelId) from RKAlbumVersion where rowid=old.rowid; end;
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 INDEX RKAttachment_uuid_index on RKAttachment(uuid);
CREATE INDEX RKAttachment_isInTrash_index on RKAttachment(isInTrash);
CREATE INDEX RKAttachment_inTrashDate_index on RKAttachment(inTrashDate);
CREATE INDEX RKAttachment_attachedToUuid_index on RKAttachment(attachedToUuid);
CREATE INDEX RKAttachment_propertyKey_index on RKAttachment(propertyKey);
CREATE INDEX RKAttachment_filename_index on RKAttachment(filename);
CREATE INDEX RKAttachment_fileIsReference_index on RKAttachment(fileIsReference);
CREATE TABLE RKAttachment_modelId_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE VIRTUAL TABLE RKAttachment_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TRIGGER RKAttachment_ridIndexDeleteTrigger before delete on RKAttachment begin select RKAttachment_notifyRidIndexDelete(old.modelId,old.modelId) from RKAttachment where rowid=old.rowid; end;
CREATE TRIGGER RKAttachment_ridIndexInsertTrigger after insert on RKAttachment begin select RKAttachment_notifyRidIndexInsert(new.modelId,new.modelId) from RKAttachment where rowid=new.rowid; end;
CREATE TRIGGER RKAttachment_ridIndexUpdateTrigger after update of modelId on RKAttachment begin select RKAttachment_notifyRidIndexUpdate(new.modelId,old.modelId,new.modelId) from RKAttachment where rowid=old.rowid; end;
CREATE TABLE RKBookmark (modelId integer primary key autoincrement, data blob);
CREATE TABLE RKBookmark_modelId_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE VIRTUAL TABLE RKBookmark_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TRIGGER RKBookmark_ridIndexDeleteTrigger before delete on RKBookmark begin select RKBookmark_notifyRidIndexDelete(old.modelId,old.modelId) from RKBookmark where rowid=old.rowid; end;
CREATE TRIGGER RKBookmark_ridIndexInsertTrigger after insert on RKBookmark begin select RKBookmark_notifyRidIndexInsert(new.modelId,new.modelId) from RKBookmark where rowid=new.rowid; end;
CREATE TRIGGER RKBookmark_ridIndexUpdateTrigger after update of modelId on RKBookmark begin select RKBookmark_notifyRidIndexUpdate(new.modelId,old.modelId,new.modelId) from RKBookmark where rowid=old.rowid; end;
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 INDEX RKCloudResource_fingerprint_index on RKCloudResource(fingerprint);
CREATE INDEX RKCloudResource_identifier_index on RKCloudResource(identifier);
CREATE TABLE RKCloudResource_modelId_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE TABLE RKCloudResource_type_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE TABLE RKCloudResource_available_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_isOnDisk_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE TABLE RKCloudResource_isFullSizeOutput_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE VIRTUAL TABLE RKCloudResource_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TRIGGER RKCloudResource_ridIndexDeleteTrigger before delete on RKCloudResource begin select RKCloudResource_notifyRidIndexDelete(old.modelId,old.status,old.isOnDisk,old.isFullSizeOutput,old.modelId,old.type,old.available) from RKCloudResource where rowid=old.rowid; end;
CREATE TRIGGER RKCloudResource_ridIndexInsertTrigger after insert on RKCloudResource begin select RKCloudResource_notifyRidIndexInsert(new.modelId,new.status,new.isOnDisk,new.isFullSizeOutput,new.modelId,new.type,new.available) from RKCloudResource where rowid=new.rowid; end;
CREATE TRIGGER RKCloudResource_ridIndexUpdateTrigger after update of status,isOnDisk,isFullSizeOutput,modelId,type,available on RKCloudResource begin select RKCloudResource_notifyRidIndexUpdate(new.modelId,old.status,old.isOnDisk,old.isFullSizeOutput,old.modelId,old.type,old.available,new.status,new.isOnDisk,new.isFullSizeOutput,new.modelId,new.type,new.available) from RKCloudResource where rowid=old.rowid; end;
CREATE TABLE RKCustomSortOrder (modelId integer primary key autoincrement, containerUuid varchar, objectUuid varchar, orderNumber integer);
CREATE INDEX RKCustomSortOrder_containerUuid_index on RKCustomSortOrder(containerUuid);
CREATE INDEX RKCustomSortOrder_objectUuid_index on RKCustomSortOrder(objectUuid);
CREATE TABLE RKCustomSortOrder_modelId_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE VIRTUAL TABLE RKCustomSortOrder_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TRIGGER RKCustomSortOrder_ridIndexDeleteTrigger before delete on RKCustomSortOrder begin select RKCustomSortOrder_notifyRidIndexDelete(old.modelId,old.modelId) from RKCustomSortOrder where rowid=old.rowid; end;
CREATE TRIGGER RKCustomSortOrder_ridIndexInsertTrigger after insert on RKCustomSortOrder begin select RKCustomSortOrder_notifyRidIndexInsert(new.modelId,new.modelId) from RKCustomSortOrder where rowid=new.rowid; end;
CREATE TRIGGER RKCustomSortOrder_ridIndexUpdateTrigger after update of modelId on RKCustomSortOrder begin select RKCustomSortOrder_notifyRidIndexUpdate(new.modelId,old.modelId,new.modelId) from RKCustomSortOrder where rowid=old.rowid; end;
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);
CREATE INDEX RKFace_uuid_index on RKFace(uuid);
CREATE INDEX RKFace_personId_index on RKFace(personId);
CREATE INDEX RKFace_imageModelId_index on RKFace(imageModelId);
CREATE INDEX RKFace_qualityMeasure_index on RKFace(qualityMeasure);
CREATE INDEX RKFace_clusterSequenceNumber_index on RKFace(clusterSequenceNumber);
CREATE INDEX RKFace_faceGroupId_index on RKFace(faceGroupId);
CREATE TABLE RKFace_modelId_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_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_manual_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_faceAlgorithmVersion_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_faceType_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE VIRTUAL TABLE RKFace_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TRIGGER RKFace_ridIndexDeleteTrigger before delete on RKFace begin select RKFace_notifyRidIndexDelete(old.modelId,old.hasBeenSynced,old.isInTrash,old.nameSource,old.modelId,old.faceAlgorithmVersion,old.confirmedFaceCropGenerationState,old.faceType,old.hidden,old.manual) from RKFace where rowid=old.rowid; end;
CREATE TRIGGER RKFace_ridIndexInsertTrigger after insert on RKFace begin select RKFace_notifyRidIndexInsert(new.modelId,new.hasBeenSynced,new.isInTrash,new.nameSource,new.modelId,new.faceAlgorithmVersion,new.confirmedFaceCropGenerationState,new.faceType,new.hidden,new.manual) from RKFace where rowid=new.rowid; end;
CREATE TRIGGER RKFace_ridIndexUpdateTrigger after update of hasBeenSynced,isInTrash,nameSource,modelId,faceAlgorithmVersion,confirmedFaceCropGenerationState,faceType,hidden,manual on RKFace begin select RKFace_notifyRidIndexUpdate(new.modelId,old.hasBeenSynced,old.isInTrash,old.nameSource,old.modelId,old.faceAlgorithmVersion,old.confirmedFaceCropGenerationState,old.faceType,old.hidden,old.manual,new.hasBeenSynced,new.isInTrash,new.nameSource,new.modelId,new.faceAlgorithmVersion,new.confirmedFaceCropGenerationState,new.faceType,new.hidden,new.manual) from RKFace where rowid=old.rowid; end;
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);
CREATE INDEX RKFaceCrop_uuid_index on RKFaceCrop(uuid);
CREATE INDEX RKFaceCrop_personId_index on RKFaceCrop(personId);
CREATE INDEX RKFaceCrop_cloudIdentifier_index on RKFaceCrop(cloudIdentifier);
CREATE INDEX RKFaceCrop_faceId_index on RKFaceCrop(faceId);
CREATE TABLE RKFaceCrop_modelId_RidIndex (modelId integer primary key, value varchar, rids blob);
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_type_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE TABLE RKFaceCrop_state_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE VIRTUAL TABLE RKFaceCrop_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TRIGGER RKFaceCrop_ridIndexDeleteTrigger before delete on RKFaceCrop begin select RKFaceCrop_notifyRidIndexDelete(old.modelId,old.type,old.state,old.cloudLibraryState,old.hasBeenSynced,old.modelId,old.isCloudQuarantined) from RKFaceCrop where rowid=old.rowid; end;
CREATE TRIGGER RKFaceCrop_ridIndexInsertTrigger after insert on RKFaceCrop begin select RKFaceCrop_notifyRidIndexInsert(new.modelId,new.type,new.state,new.cloudLibraryState,new.hasBeenSynced,new.modelId,new.isCloudQuarantined) from RKFaceCrop where rowid=new.rowid; end;
CREATE TRIGGER RKFaceCrop_ridIndexUpdateTrigger after update of type,state,cloudLibraryState,hasBeenSynced,modelId,isCloudQuarantined on RKFaceCrop begin select RKFaceCrop_notifyRidIndexUpdate(new.modelId,old.type,old.state,old.cloudLibraryState,old.hasBeenSynced,old.modelId,old.isCloudQuarantined,new.type,new.state,new.cloudLibraryState,new.hasBeenSynced,new.modelId,new.isCloudQuarantined) from RKFaceCrop where rowid=old.rowid; end;
CREATE TABLE RKFaceGroup (modelId integer primary key autoincrement, uuid varchar, personId integer, faceGroupType integer, representativeFaceId integer, personBuilderState integer);
CREATE INDEX RKFaceGroup_uuid_index on RKFaceGroup(uuid);
CREATE TABLE RKFaceGroup_modelId_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE TABLE RKFaceGroup_faceGroupType_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE TABLE RKFaceGroup_personBuilderState_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE VIRTUAL TABLE RKFaceGroup_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TRIGGER RKFaceGroup_ridIndexDeleteTrigger before delete on RKFaceGroup begin select RKFaceGroup_notifyRidIndexDelete(old.modelId,old.faceGroupType,old.personBuilderState,old.modelId) from RKFaceGroup where rowid=old.rowid; end;
CREATE TRIGGER RKFaceGroup_ridIndexInsertTrigger after insert on RKFaceGroup begin select RKFaceGroup_notifyRidIndexInsert(new.modelId,new.faceGroupType,new.personBuilderState,new.modelId) from RKFaceGroup where rowid=new.rowid; end;
CREATE TRIGGER RKFaceGroup_ridIndexUpdateTrigger after update of faceGroupType,personBuilderState,modelId on RKFaceGroup begin select RKFaceGroup_notifyRidIndexUpdate(new.modelId,old.faceGroupType,old.personBuilderState,old.modelId,new.faceGroupType,new.personBuilderState,new.modelId) from RKFaceGroup where rowid=old.rowid; end;
CREATE TABLE RKFacePrint (modelId integer primary key autoincrement, uuid varchar, faceId integer, faceprintVersion integer, faceprint blob);
CREATE INDEX RKFacePrint_uuid_index on RKFacePrint(uuid);
CREATE INDEX RKFacePrint_faceId_index on RKFacePrint(faceId);
CREATE TABLE RKFacePrint_modelId_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE VIRTUAL TABLE RKFacePrint_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TRIGGER RKFacePrint_ridIndexDeleteTrigger before delete on RKFacePrint begin select RKFacePrint_notifyRidIndexDelete(old.modelId,old.modelId) from RKFacePrint where rowid=old.rowid; end;
CREATE TRIGGER RKFacePrint_ridIndexInsertTrigger after insert on RKFacePrint begin select RKFacePrint_notifyRidIndexInsert(new.modelId,new.modelId) from RKFacePrint where rowid=new.rowid; end;
CREATE TRIGGER RKFacePrint_ridIndexUpdateTrigger after update of modelId on RKFacePrint begin select RKFacePrint_notifyRidIndexUpdate(new.modelId,old.modelId,new.modelId) from RKFacePrint where rowid=old.rowid; end;
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 INDEX RKFolder_uuid_index on RKFolder(uuid);
CREATE INDEX RKFolder_createDate_index on RKFolder(createDate);
CREATE INDEX RKFolder_isInTrash_index on RKFolder(isInTrash);
CREATE INDEX RKFolder_inTrashDate_index on RKFolder(inTrashDate);
CREATE INDEX RKFolder_isMagic_index on RKFolder(isMagic);
CREATE INDEX RKFolder_cloudIdentifier_index on RKFolder(cloudIdentifier);
CREATE INDEX RKFolder_parentFolderUuid_index on RKFolder(parentFolderUuid);
CREATE INDEX RKFolder_folderPath_index on RKFolder(folderPath);
CREATE TABLE RKFolder_integerNote (keyPath integer, value integer, attachedToId integer, primary key (attachedToId, keyPath));
CREATE INDEX RKFolder_integerNote_value_index on RKFolder_integerNote(value);
CREATE VIRTUAL TABLE RKFolder_integerNote_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TABLE RKFolder_modelId_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE TABLE RKFolder_cloudLibraryState_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_isCloudQuarantined_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE TABLE RKFolder_folderType_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE VIRTUAL TABLE RKFolder_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TRIGGER RKFolder_ridIndexDeleteTrigger before delete on RKFolder begin select RKFolder_notifyRidIndexDelete(old.modelId,old.folderType,old.cloudLibraryState,old.hasBeenSynced,old.modelId,old.isCloudQuarantined) from RKFolder where rowid=old.rowid; end;
CREATE TRIGGER RKFolder_ridIndexInsertTrigger after insert on RKFolder begin select RKFolder_notifyRidIndexInsert(new.modelId,new.folderType,new.cloudLibraryState,new.hasBeenSynced,new.modelId,new.isCloudQuarantined) from RKFolder where rowid=new.rowid; end;
CREATE TRIGGER RKFolder_ridIndexUpdateTrigger after update of folderType,cloudLibraryState,hasBeenSynced,modelId,isCloudQuarantined on RKFolder begin select RKFolder_notifyRidIndexUpdate(new.modelId,old.folderType,old.cloudLibraryState,old.hasBeenSynced,old.modelId,old.isCloudQuarantined,new.folderType,new.cloudLibraryState,new.hasBeenSynced,new.modelId,new.isCloudQuarantined) from RKFolder where rowid=old.rowid; end;
CREATE TABLE RKImageMask (modelId integer primary key autoincrement, uuid varchar, createDate timestamp);
CREATE INDEX RKImageMask_uuid_index on RKImageMask(uuid);
CREATE INDEX RKImageMask_createDate_index on RKImageMask(createDate);
CREATE TABLE RKImageMask_modelId_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE VIRTUAL TABLE RKImageMask_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TRIGGER RKImageMask_ridIndexDeleteTrigger before delete on RKImageMask begin select RKImageMask_notifyRidIndexDelete(old.modelId,old.modelId) from RKImageMask where rowid=old.rowid; end;
CREATE TRIGGER RKImageMask_ridIndexInsertTrigger after insert on RKImageMask begin select RKImageMask_notifyRidIndexInsert(new.modelId,new.modelId) from RKImageMask where rowid=new.rowid; end;
CREATE TRIGGER RKImageMask_ridIndexUpdateTrigger after update of modelId on RKImageMask begin select RKImageMask_notifyRidIndexUpdate(new.modelId,old.modelId,new.modelId) from RKImageMask where rowid=old.rowid; end;
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 INDEX RKImageProxyState_versionId_index on RKImageProxyState(versionId);
CREATE TABLE RKImageProxyState_modelId_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_miniThumbnailsCurrent_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE TABLE RKImageProxyState_tinyThumbnailsCurrent_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_thumbnailRendered_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_faceTilesCurrent_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE TABLE RKImageProxyState_microThumbnailsCurrent_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE VIRTUAL TABLE RKImageProxyState_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TRIGGER RKImageProxyState_ridIndexDeleteTrigger before delete on RKImageProxyState begin select RKImageProxyState_notifyRidIndexDelete(old.versionId,old.modelId,old.thumbnailRendered,old.previewRendered,old.faceTilesCurrent,old.modelId,old.thumbnailsCurrent,old.miniThumbnailsCurrent,old.tinyThumbnailsCurrent,old.fullSizePreviewUpToDate,old.microThumbnailsCurrent) from RKImageProxyState where rowid=old.rowid; end;
CREATE TRIGGER RKImageProxyState_ridIndexInsertTrigger after insert on RKImageProxyState begin select RKImageProxyState_notifyRidIndexInsert(new.versionId,new.modelId,new.thumbnailRendered,new.previewRendered,new.faceTilesCurrent,new.modelId,new.thumbnailsCurrent,new.miniThumbnailsCurrent,new.tinyThumbnailsCurrent,new.fullSizePreviewUpToDate,new.microThumbnailsCurrent) from RKImageProxyState where rowid=new.rowid; end;
CREATE TRIGGER RKImageProxyState_ridIndexUpdateTrigger after update of thumbnailRendered,previewRendered,faceTilesCurrent,modelId,thumbnailsCurrent,miniThumbnailsCurrent,tinyThumbnailsCurrent,fullSizePreviewUpToDate,microThumbnailsCurrent on RKImageProxyState begin select RKImageProxyState_notifyRidIndexUpdate(new.versionId,new.modelId,old.thumbnailRendered,old.previewRendered,old.faceTilesCurrent,old.modelId,old.thumbnailsCurrent,old.miniThumbnailsCurrent,old.tinyThumbnailsCurrent,old.fullSizePreviewUpToDate,old.microThumbnailsCurrent,new.thumbnailRendered,new.previewRendered,new.faceTilesCurrent,new.modelId,new.thumbnailsCurrent,new.miniThumbnailsCurrent,new.tinyThumbnailsCurrent,new.fullSizePreviewUpToDate,new.microThumbnailsCurrent) from RKImageProxyState where rowid=old.rowid; end;
CREATE TABLE RKImportGroup (modelId integer primary key autoincrement, uuid varchar, name varchar, importDate timestamp, isSynthesized integer);
CREATE INDEX RKImportGroup_uuid_index on RKImportGroup(uuid);
CREATE INDEX RKImportGroup_name_index on RKImportGroup(name);
CREATE INDEX RKImportGroup_importDate_index on RKImportGroup(importDate);
CREATE INDEX RKImportGroup_isSynthesized_index on RKImportGroup(isSynthesized);
CREATE TABLE RKImportGroup_modelId_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE VIRTUAL TABLE RKImportGroup_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TRIGGER RKImportGroup_ridIndexDeleteTrigger before delete on RKImportGroup begin select RKImportGroup_notifyRidIndexDelete(old.modelId,old.modelId) from RKImportGroup where rowid=old.rowid; end;
CREATE TRIGGER RKImportGroup_ridIndexInsertTrigger after insert on RKImportGroup begin select RKImportGroup_notifyRidIndexInsert(new.modelId,new.modelId) from RKImportGroup where rowid=new.rowid; end;
CREATE TRIGGER RKImportGroup_ridIndexUpdateTrigger after update of modelId on RKImportGroup begin select RKImportGroup_notifyRidIndexUpdate(new.modelId,old.modelId,new.modelId) from RKImportGroup where rowid=old.rowid; end;
CREATE TABLE RKKeyword (modelId integer primary key autoincrement, uuid varchar, name varchar, searchName varchar, parentId integer, hasChildren integer, shortcut varchar);
CREATE INDEX RKKeyword_uuid_index on RKKeyword(uuid);
CREATE INDEX RKKeyword_name_index on RKKeyword(name);
CREATE INDEX RKKeyword_searchName_index on RKKeyword(searchName);
CREATE INDEX RKKeyword_parentId_index on RKKeyword(parentId);
CREATE TABLE RKKeyword_modelId_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE VIRTUAL TABLE RKKeyword_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TRIGGER RKKeyword_ridIndexDeleteTrigger before delete on RKKeyword begin select RKKeyword_notifyRidIndexDelete(old.modelId,old.modelId) from RKKeyword where rowid=old.rowid; end;
CREATE TRIGGER RKKeyword_ridIndexInsertTrigger after insert on RKKeyword begin select RKKeyword_notifyRidIndexInsert(new.modelId,new.modelId) from RKKeyword where rowid=new.rowid; end;
CREATE TRIGGER RKKeyword_ridIndexUpdateTrigger after update of modelId on RKKeyword begin select RKKeyword_notifyRidIndexUpdate(new.modelId,old.modelId,new.modelId) from RKKeyword where rowid=old.rowid; end;
CREATE TABLE RKKeywordForVersion (modelId integer primary key autoincrement, versionId integer, keywordId integer);
CREATE INDEX RKKeywordForVersion_versionId_index on RKKeywordForVersion(versionId);
CREATE TABLE RKKeywordForVersion_modelId_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE VIRTUAL TABLE RKKeywordForVersion_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TRIGGER RKKeywordForVersion_ridIndexDeleteTrigger before delete on RKKeywordForVersion begin select RKKeywordForVersion_notifyRidIndexDelete(old.modelId,old.modelId) from RKKeywordForVersion where rowid=old.rowid; end;
CREATE TRIGGER RKKeywordForVersion_ridIndexInsertTrigger after insert on RKKeywordForVersion begin select RKKeywordForVersion_notifyRidIndexInsert(new.modelId,new.modelId) from RKKeywordForVersion where rowid=new.rowid; end;
CREATE TRIGGER RKKeywordForVersion_ridIndexUpdateTrigger after update of modelId on RKKeywordForVersion begin select RKKeywordForVersion_notifyRidIndexUpdate(new.modelId,old.modelId,new.modelId) from RKKeywordForVersion where rowid=old.rowid; end;
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);
CREATE INDEX RKMaster_uuid_index on RKMaster(uuid);
CREATE INDEX RKMaster_createDate_index on RKMaster(createDate);
CREATE INDEX RKMaster_inTrashDate_index on RKMaster(inTrashDate);
CREATE INDEX RKMaster_fileModificationDate_index on RKMaster(fileModificationDate);
CREATE INDEX RKMaster_fileSize_index on RKMaster(fileSize);
CREATE INDEX RKMaster_importGroupUuid_index on RKMaster(importGroupUuid);
CREATE INDEX RKMaster_alternateMasterUuid_index on RKMaster(alternateMasterUuid);
CREATE INDEX RKMaster_fileName_index on RKMaster(fileName);
CREATE INDEX RKMaster_fileCreationDate_index on RKMaster(fileCreationDate);
CREATE INDEX RKMaster_mediaGroupId_index on RKMaster(mediaGroupId);
CREATE TABLE RKMaster_dataNote (keyPath integer, value blob, attachedToId integer, primary key (attachedToId, keyPath));
CREATE VIRTUAL TABLE RKMaster_dataNote_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TABLE RKMaster_integerNote (keyPath integer, value integer, attachedToId integer, primary key (attachedToId, keyPath));
CREATE INDEX RKMaster_integerNote_value_index on RKMaster_integerNote(value);
CREATE VIRTUAL TABLE RKMaster_integerNote_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TABLE RKMaster_stringNote (keyPath integer, value varchar, attachedToId integer, primary key (attachedToId, keyPath));
CREATE INDEX RKMaster_stringNote_value_index on RKMaster_stringNote(value);
CREATE VIRTUAL TABLE RKMaster_stringNote_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TABLE RKMaster_modelId_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_isInTrash_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE TABLE RKMaster_cloudLibraryState_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_isCloudQuarantined_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE TABLE RKMaster_fileIsReference_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_volumeId_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_isTrulyRaw_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_importedBy_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_importComplete_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_hasCheckedMediaGroupId_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE VIRTUAL TABLE RKMaster_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TRIGGER RKMaster_ridIndexDeleteTrigger before delete on RKMaster begin select RKMaster_notifyRidIndexDelete(old.modelId,old.photoStreamTagId,old.volumeId,old.isInTrash,old.fingerprint,old.isExternallyEditable,old.isTrulyRaw,old.modelId,old.isCloudQuarantined,old.hasAttachments,old.cloudLibraryState,old.hasBeenSynced,old.hasCheckedMediaGroupId,old.importedBy,old.originatingAssetIdentifier,old.fileIsReference,old.isMissing,old.importComplete) from RKMaster where rowid=old.rowid; end;
CREATE TRIGGER RKMaster_ridIndexInsertTrigger after insert on RKMaster begin select RKMaster_notifyRidIndexInsert(new.modelId,new.photoStreamTagId,new.volumeId,new.isInTrash,new.fingerprint,new.isExternallyEditable,new.isTrulyRaw,new.modelId,new.isCloudQuarantined,new.hasAttachments,new.cloudLibraryState,new.hasBeenSynced,new.hasCheckedMediaGroupId,new.importedBy,new.originatingAssetIdentifier,new.fileIsReference,new.isMissing,new.importComplete) from RKMaster where rowid=new.rowid; end;
CREATE TRIGGER RKMaster_ridIndexUpdateTrigger after update of photoStreamTagId,volumeId,isInTrash,fingerprint,isExternallyEditable,isTrulyRaw,modelId,isCloudQuarantined,hasAttachments,cloudLibraryState,hasBeenSynced,hasCheckedMediaGroupId,importedBy,originatingAssetIdentifier,fileIsReference,isMissing,importComplete on RKMaster begin select RKMaster_notifyRidIndexUpdate(new.modelId,old.photoStreamTagId,old.volumeId,old.isInTrash,old.fingerprint,old.isExternallyEditable,old.isTrulyRaw,old.modelId,old.isCloudQuarantined,old.hasAttachments,old.cloudLibraryState,old.hasBeenSynced,old.hasCheckedMediaGroupId,old.importedBy,old.originatingAssetIdentifier,old.fileIsReference,old.isMissing,old.importComplete,new.photoStreamTagId,new.volumeId,new.isInTrash,new.fingerprint,new.isExternallyEditable,new.isTrulyRaw,new.modelId,new.isCloudQuarantined,new.hasAttachments,new.cloudLibraryState,new.hasBeenSynced,new.hasCheckedMediaGroupId,new.importedBy,new.originatingAssetIdentifier,new.fileIsReference,new.isMissing,new.importComplete) from RKMaster where rowid=old.rowid; end;
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);
CREATE INDEX RKMemory_uuid_index on RKMemory(uuid);
CREATE INDEX RKMemory_cloudIdentifier_index on RKMemory(cloudIdentifier);
CREATE TABLE RKMemory_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_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_pending_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE TABLE RKMemory_subcategory_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE TABLE RKMemory_favorite_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE VIRTUAL TABLE RKMemory_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TRIGGER RKMemory_ridIndexDeleteTrigger before delete on RKMemory begin select RKMemory_notifyRidIndexDelete(old.modelId,old.isCloudQuarantined,old.pending,old.subcategory,old.modelId,old.favorite,old.cloudLibraryState,old.hasBeenSynced) from RKMemory where rowid=old.rowid; end;
CREATE TRIGGER RKMemory_ridIndexInsertTrigger after insert on RKMemory begin select RKMemory_notifyRidIndexInsert(new.modelId,new.isCloudQuarantined,new.pending,new.subcategory,new.modelId,new.favorite,new.cloudLibraryState,new.hasBeenSynced) from RKMemory where rowid=new.rowid; end;
CREATE TRIGGER RKMemory_ridIndexUpdateTrigger after update of isCloudQuarantined,pending,subcategory,modelId,favorite,cloudLibraryState,hasBeenSynced on RKMemory begin select RKMemory_notifyRidIndexUpdate(new.modelId,old.isCloudQuarantined,old.pending,old.subcategory,old.modelId,old.favorite,old.cloudLibraryState,old.hasBeenSynced,new.isCloudQuarantined,new.pending,new.subcategory,new.modelId,new.favorite,new.cloudLibraryState,new.hasBeenSynced) from RKMemory where rowid=old.rowid; end;
CREATE TABLE RKMemoryCuratedVersion (modelId integer primary key autoincrement, versionId integer, memoryId integer);
CREATE INDEX RKMemoryCuratedVersion_versionId_index on RKMemoryCuratedVersion(versionId);
CREATE TABLE RKMemoryCuratedVersion_modelId_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE TABLE RKMemoryCuratedVersion_memoryId_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE VIRTUAL TABLE RKMemoryCuratedVersion_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TRIGGER RKMemoryCuratedVersion_ridIndexDeleteTrigger before delete on RKMemoryCuratedVersion begin select RKMemoryCuratedVersion_notifyRidIndexDelete(old.versionId,old.modelId,old.memoryId,old.modelId) from RKMemoryCuratedVersion where rowid=old.rowid; end;
CREATE TRIGGER RKMemoryCuratedVersion_ridIndexInsertTrigger after insert on RKMemoryCuratedVersion begin select RKMemoryCuratedVersion_notifyRidIndexInsert(new.versionId,new.modelId,new.memoryId,new.modelId) from RKMemoryCuratedVersion where rowid=new.rowid; end;
CREATE TRIGGER RKMemoryCuratedVersion_ridIndexUpdateTrigger after update of memoryId,modelId on RKMemoryCuratedVersion begin select RKMemoryCuratedVersion_notifyRidIndexUpdate(new.versionId,new.modelId,old.memoryId,old.modelId,new.memoryId,new.modelId) from RKMemoryCuratedVersion where rowid=old.rowid; end;
CREATE TABLE RKMemoryMovieVersion (modelId integer primary key autoincrement, versionId integer, memoryId integer);
CREATE INDEX RKMemoryMovieVersion_versionId_index on RKMemoryMovieVersion(versionId);
CREATE TABLE RKMemoryMovieVersion_modelId_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE TABLE RKMemoryMovieVersion_memoryId_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE VIRTUAL TABLE RKMemoryMovieVersion_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TRIGGER RKMemoryMovieVersion_ridIndexDeleteTrigger before delete on RKMemoryMovieVersion begin select RKMemoryMovieVersion_notifyRidIndexDelete(old.versionId,old.modelId,old.memoryId,old.modelId) from RKMemoryMovieVersion where rowid=old.rowid; end;
CREATE TRIGGER RKMemoryMovieVersion_ridIndexInsertTrigger after insert on RKMemoryMovieVersion begin select RKMemoryMovieVersion_notifyRidIndexInsert(new.versionId,new.modelId,new.memoryId,new.modelId) from RKMemoryMovieVersion where rowid=new.rowid; end;
CREATE TRIGGER RKMemoryMovieVersion_ridIndexUpdateTrigger after update of memoryId,modelId on RKMemoryMovieVersion begin select RKMemoryMovieVersion_notifyRidIndexUpdate(new.versionId,new.modelId,old.memoryId,old.modelId,new.memoryId,new.modelId) from RKMemoryMovieVersion where rowid=old.rowid; end;
CREATE TABLE RKMemoryRepresentativeVersion (modelId integer primary key autoincrement, versionId integer, memoryId integer);
CREATE INDEX RKMemoryRepresentativeVersion_versionId_index on RKMemoryRepresentativeVersion(versionId);
CREATE TABLE RKMemoryRepresentativeVersion_modelId_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE TABLE RKMemoryRepresentativeVersion_memoryId_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE VIRTUAL TABLE RKMemoryRepresentativeVersion_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TRIGGER RKMemoryRepresentativeVersion_ridIndexDeleteTrigger before delete on RKMemoryRepresentativeVersion begin select RKMemoryRepresentativeVersion_notifyRidIndexDelete(old.versionId,old.modelId,old.memoryId,old.modelId) from RKMemoryRepresentativeVersion where rowid=old.rowid; end;
CREATE TRIGGER RKMemoryRepresentativeVersion_ridIndexInsertTrigger after insert on RKMemoryRepresentativeVersion begin select RKMemoryRepresentativeVersion_notifyRidIndexInsert(new.versionId,new.modelId,new.memoryId,new.modelId) from RKMemoryRepresentativeVersion where rowid=new.rowid; end;
CREATE TRIGGER RKMemoryRepresentativeVersion_ridIndexUpdateTrigger after update of memoryId,modelId on RKMemoryRepresentativeVersion begin select RKMemoryRepresentativeVersion_notifyRidIndexUpdate(new.versionId,new.modelId,old.memoryId,old.modelId,new.memoryId,new.modelId) from RKMemoryRepresentativeVersion where rowid=old.rowid; end;
CREATE TABLE RKModelResource (modelId integer primary key autoincrement, UTI varchar, isOnDisk integer, attachedModelId integer, attachedModelType integer, resourceType integer, resourceTag varchar, resourceIsReference integer);
CREATE INDEX RKModelResource_attachedModelId_index on RKModelResource(attachedModelId);
CREATE INDEX RKModelResource_resourceIsReference_index on RKModelResource(resourceIsReference);
CREATE TABLE RKModelResource_integerNote (keyPath integer, value integer, attachedToId integer, primary key (attachedToId, keyPath));
CREATE INDEX RKModelResource_integerNote_value_index on RKModelResource_integerNote(value);
CREATE VIRTUAL TABLE RKModelResource_integerNote_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TABLE RKModelResource_stringNote (keyPath integer, value varchar, attachedToId integer, primary key (attachedToId, keyPath));
CREATE INDEX RKModelResource_stringNote_value_index on RKModelResource_stringNote(value);
CREATE VIRTUAL TABLE RKModelResource_stringNote_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TABLE RKModelResource_modelId_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE TABLE RKModelResource_isOnDisk_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE TABLE RKModelResource_attachedModelType_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE TABLE RKModelResource_resourceType_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE VIRTUAL TABLE RKModelResource_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TRIGGER RKModelResource_ridIndexDeleteTrigger before delete on RKModelResource begin select RKModelResource_notifyRidIndexDelete(old.modelId,old.isOnDisk,old.attachedModelType,old.modelId,old.resourceType) from RKModelResource where rowid=old.rowid; end;
CREATE TRIGGER RKModelResource_ridIndexInsertTrigger after insert on RKModelResource begin select RKModelResource_notifyRidIndexInsert(new.modelId,new.isOnDisk,new.attachedModelType,new.modelId,new.resourceType) from RKModelResource where rowid=new.rowid; end;
CREATE TRIGGER RKModelResource_ridIndexUpdateTrigger after update of isOnDisk,attachedModelType,modelId,resourceType on RKModelResource begin select RKModelResource_notifyRidIndexUpdate(new.modelId,old.isOnDisk,old.attachedModelType,old.modelId,old.resourceType,new.isOnDisk,new.attachedModelType,new.modelId,new.resourceType) from RKModelResource where rowid=old.rowid; end;
CREATE TABLE RKMoment (modelId integer primary key autoincrement, uuid varchar, versionCount integer, 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, lastModifiedDate timestamp);
CREATE INDEX RKMoment_uuid_index on RKMoment(uuid);
CREATE TABLE RKMoment_modelId_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE VIRTUAL TABLE RKMoment_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TRIGGER RKMoment_ridIndexDeleteTrigger before delete on RKMoment begin select RKMoment_notifyRidIndexDelete(old.modelId,old.modelId) from RKMoment where rowid=old.rowid; end;
CREATE TRIGGER RKMoment_ridIndexInsertTrigger after insert on RKMoment begin select RKMoment_notifyRidIndexInsert(new.modelId,new.modelId) from RKMoment where rowid=new.rowid; end;
CREATE TRIGGER RKMoment_ridIndexUpdateTrigger after update of modelId on RKMoment begin select RKMoment_notifyRidIndexUpdate(new.modelId,old.modelId,new.modelId) from RKMoment where rowid=old.rowid; end;
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 INDEX RKMomentCollection_uuid_index on RKMomentCollection(uuid);
CREATE TABLE RKMomentCollection_modelId_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE VIRTUAL TABLE RKMomentCollection_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TRIGGER RKMomentCollection_ridIndexDeleteTrigger before delete on RKMomentCollection begin select RKMomentCollection_notifyRidIndexDelete(old.modelId,old.modelId) from RKMomentCollection where rowid=old.rowid; end;
CREATE TRIGGER RKMomentCollection_ridIndexInsertTrigger after insert on RKMomentCollection begin select RKMomentCollection_notifyRidIndexInsert(new.modelId,new.modelId) from RKMomentCollection where rowid=new.rowid; end;
CREATE TRIGGER RKMomentCollection_ridIndexUpdateTrigger after update of modelId on RKMomentCollection begin select RKMomentCollection_notifyRidIndexUpdate(new.modelId,old.modelId,new.modelId) from RKMomentCollection where rowid=old.rowid; end;
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 INDEX RKMomentYear_uuid_index on RKMomentYear(uuid);
CREATE TABLE RKMomentYear_modelId_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE VIRTUAL TABLE RKMomentYear_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TRIGGER RKMomentYear_ridIndexDeleteTrigger before delete on RKMomentYear begin select RKMomentYear_notifyRidIndexDelete(old.modelId,old.modelId) from RKMomentYear where rowid=old.rowid; end;
CREATE TRIGGER RKMomentYear_ridIndexInsertTrigger after insert on RKMomentYear begin select RKMomentYear_notifyRidIndexInsert(new.modelId,new.modelId) from RKMomentYear where rowid=new.rowid; end;
CREATE TRIGGER RKMomentYear_ridIndexUpdateTrigger after update of modelId on RKMomentYear begin select RKMomentYear_notifyRidIndexUpdate(new.modelId,old.modelId,new.modelId) from RKMomentYear where rowid=old.rowid; end;
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);
CREATE INDEX RKPerson_uuid_index on RKPerson(uuid);
CREATE INDEX RKPerson_cloudIdentifier_index on RKPerson(cloudIdentifier);
CREATE INDEX RKPerson_associatedClusterId_index on RKPerson(associatedClusterId);
CREATE INDEX RKPerson_faceCount_index on RKPerson(faceCount);
CREATE TABLE RKPerson_dataNote (keyPath integer, value blob, attachedToId integer, primary key (attachedToId, keyPath));
CREATE VIRTUAL TABLE RKPerson_dataNote_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TABLE RKPerson_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_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_personType_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 VIRTUAL TABLE RKPerson_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TRIGGER RKPerson_ridIndexDeleteTrigger before delete on RKPerson begin select RKPerson_notifyRidIndexDelete(old.modelId,old.isCloudQuarantined,old.personType,old.modelId,old.isInPersonNamingModel,old.isVerified,old.cloudLibraryState,old.hasBeenSynced) from RKPerson where rowid=old.rowid; end;
CREATE TRIGGER RKPerson_ridIndexInsertTrigger after insert on RKPerson begin select RKPerson_notifyRidIndexInsert(new.modelId,new.isCloudQuarantined,new.personType,new.modelId,new.isInPersonNamingModel,new.isVerified,new.cloudLibraryState,new.hasBeenSynced) from RKPerson where rowid=new.rowid; end;
CREATE TRIGGER RKPerson_ridIndexUpdateTrigger after update of isCloudQuarantined,personType,modelId,isInPersonNamingModel,isVerified,cloudLibraryState,hasBeenSynced on RKPerson begin select RKPerson_notifyRidIndexUpdate(new.modelId,old.isCloudQuarantined,old.personType,old.modelId,old.isInPersonNamingModel,old.isVerified,old.cloudLibraryState,old.hasBeenSynced,new.isCloudQuarantined,new.personType,new.modelId,new.isInPersonNamingModel,new.isVerified,new.cloudLibraryState,new.hasBeenSynced) from RKPerson where rowid=old.rowid; end;
CREATE TABLE RKPersonRejectedFace (modelId integer primary key autoincrement, personId integer, faceId integer);
CREATE INDEX RKPersonRejectedFace_faceId_index on RKPersonRejectedFace(faceId);
CREATE TABLE RKPersonRejectedFace_modelId_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE TABLE RKPersonRejectedFace_personId_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE VIRTUAL TABLE RKPersonRejectedFace_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TRIGGER RKPersonRejectedFace_ridIndexDeleteTrigger before delete on RKPersonRejectedFace begin select RKPersonRejectedFace_notifyRidIndexDelete(old.personId,old.modelId,old.personId,old.modelId) from RKPersonRejectedFace where rowid=old.rowid; end;
CREATE TRIGGER RKPersonRejectedFace_ridIndexInsertTrigger after insert on RKPersonRejectedFace begin select RKPersonRejectedFace_notifyRidIndexInsert(new.personId,new.modelId,new.personId,new.modelId) from RKPersonRejectedFace where rowid=new.rowid; end;
CREATE TRIGGER RKPersonRejectedFace_ridIndexUpdateTrigger after update of personId,modelId on RKPersonRejectedFace begin select RKPersonRejectedFace_notifyRidIndexUpdate(new.personId,new.modelId,old.personId,old.modelId,new.personId,new.modelId) from RKPersonRejectedFace where rowid=old.rowid; end;
CREATE TABLE RKPersonRejectedFaceNeedingFaceCrop (modelId integer primary key autoincrement, personId integer, faceId integer);
CREATE INDEX RKPersonRejectedFaceNeedingFaceCrop_faceId_index on RKPersonRejectedFaceNeedingFaceCrop(faceId);
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 VIRTUAL TABLE RKPersonRejectedFaceNeedingFaceCrop_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TRIGGER RKPersonRejectedFaceNeedingFaceCrop_ridIndexDeleteTrigger before delete on RKPersonRejectedFaceNeedingFaceCrop begin select RKPersonRejectedFaceNeedingFaceCrop_notifyRidIndexDelete(old.personId,old.modelId,old.personId,old.modelId) from RKPersonRejectedFaceNeedingFaceCrop where rowid=old.rowid; end;
CREATE TRIGGER RKPersonRejectedFaceNeedingFaceCrop_ridIndexInsertTrigger after insert on RKPersonRejectedFaceNeedingFaceCrop begin select RKPersonRejectedFaceNeedingFaceCrop_notifyRidIndexInsert(new.personId,new.modelId,new.personId,new.modelId) from RKPersonRejectedFaceNeedingFaceCrop where rowid=new.rowid; end;
CREATE TRIGGER RKPersonRejectedFaceNeedingFaceCrop_ridIndexUpdateTrigger after update of personId,modelId on RKPersonRejectedFaceNeedingFaceCrop begin select RKPersonRejectedFaceNeedingFaceCrop_notifyRidIndexUpdate(new.personId,new.modelId,old.personId,old.modelId,new.personId,new.modelId) from RKPersonRejectedFaceNeedingFaceCrop where rowid=old.rowid; end;
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 INDEX RKPlace_uuid_index on RKPlace(uuid);
CREATE INDEX RKPlace_modDate_index on RKPlace(modDate);
CREATE INDEX RKPlace_createDate_index on RKPlace(createDate);
CREATE INDEX RKPlace_type_index on RKPlace(type);
CREATE INDEX RKPlace_recordLocator_index on RKPlace(recordLocator);
CREATE INDEX RKPlace_userDefined_index on RKPlace(userDefined);
CREATE TABLE RKPlace_modelId_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE VIRTUAL TABLE RKPlace_RTree using rtree (modelId,minLongitude,maxLongitude,minLatitude,maxLatitude)
/* RKPlace_RTree(modelId,minLongitude,maxLongitude,minLatitude,maxLatitude) */;
CREATE TABLE IF NOT EXISTS "RKPlace_RTree_node"(nodeno INTEGER PRIMARY KEY, data BLOB);
CREATE TABLE IF NOT EXISTS "RKPlace_RTree_rowid"(rowid INTEGER PRIMARY KEY, nodeno INTEGER);
CREATE TABLE IF NOT EXISTS "RKPlace_RTree_parent"(nodeno INTEGER PRIMARY KEY, parentnode INTEGER);
CREATE VIRTUAL TABLE RKPlace_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TRIGGER RKPlace_ridIndexDeleteTrigger before delete on RKPlace begin select RKPlace_notifyRidIndexDelete(old.modelId,old.modelId) from RKPlace where rowid=old.rowid; end;
CREATE TRIGGER RKPlace_ridIndexInsertTrigger after insert on RKPlace begin select RKPlace_notifyRidIndexInsert(new.modelId,new.modelId) from RKPlace where rowid=new.rowid; end;
CREATE TRIGGER RKPlace_ridIndexUpdateTrigger after update of modelId on RKPlace begin select RKPlace_notifyRidIndexUpdate(new.modelId,old.modelId,new.modelId) from RKPlace where rowid=old.rowid; end;
CREATE TABLE RKPlaceForVersion (modelId integer primary key autoincrement, versionId integer, placeId integer);
CREATE INDEX RKPlaceForVersion_versionId_index on RKPlaceForVersion(versionId);
CREATE INDEX RKPlaceForVersion_placeId_index on RKPlaceForVersion(placeId);
CREATE TABLE RKPlaceForVersion_modelId_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE VIRTUAL TABLE RKPlaceForVersion_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TRIGGER RKPlaceForVersion_ridIndexDeleteTrigger before delete on RKPlaceForVersion begin select RKPlaceForVersion_notifyRidIndexDelete(old.modelId,old.modelId) from RKPlaceForVersion where rowid=old.rowid; end;
CREATE TRIGGER RKPlaceForVersion_ridIndexInsertTrigger after insert on RKPlaceForVersion begin select RKPlaceForVersion_notifyRidIndexInsert(new.modelId,new.modelId) from RKPlaceForVersion where rowid=new.rowid; end;
CREATE TRIGGER RKPlaceForVersion_ridIndexUpdateTrigger after update of modelId on RKPlaceForVersion begin select RKPlaceForVersion_notifyRidIndexUpdate(new.modelId,old.modelId,new.modelId) from RKPlaceForVersion where rowid=old.rowid; end;
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 VIRTUAL TABLE RKSceneInVersion_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TRIGGER RKSceneInVersion_ridIndexDeleteTrigger before delete on RKSceneInVersion begin select RKSceneInVersion_notifyRidIndexDelete(old.modelId,old.versionId,old.modelId) from RKSceneInVersion where rowid=old.rowid; end;
CREATE TRIGGER RKSceneInVersion_ridIndexInsertTrigger after insert on RKSceneInVersion begin select RKSceneInVersion_notifyRidIndexInsert(new.modelId,new.versionId,new.modelId) from RKSceneInVersion where rowid=new.rowid; end;
CREATE TRIGGER RKSceneInVersion_ridIndexUpdateTrigger after update of versionId,modelId on RKSceneInVersion begin select RKSceneInVersion_notifyRidIndexUpdate(new.modelId,old.versionId,old.modelId,new.versionId,new.modelId) from RKSceneInVersion where rowid=old.rowid; end;
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, type integer, adjustmentUuid varchar, fileName varchar, hasNotes integer, imageDate timestamp, burstUuid varchar, imageTimeZoneOffsetSeconds integer, reverseLocationData blob, reverseLocationDataIsValid integer, lastModifiedDate timestamp, 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, faceDetectionState 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);
CREATE INDEX RKVersion_uuid_index on RKVersion(uuid);
CREATE INDEX RKVersion_createDate_index on RKVersion(createDate);
CREATE INDEX RKVersion_inTrashDate_index on RKVersion(inTrashDate);
CREATE INDEX RKVersion_cloudIdentifier_index on RKVersion(cloudIdentifier);
CREATE INDEX RKVersion_adjustmentUuid_index on RKVersion(adjustmentUuid);
CREATE INDEX RKVersion_burstUuid_index on RKVersion(burstUuid);
CREATE INDEX RKVersion_masterUuid_index on RKVersion(masterUuid);
CREATE INDEX RKVersion_masterId_index on RKVersion(masterId);
CREATE INDEX RKVersion_rawMasterUuid_index on RKVersion(rawMasterUuid);
CREATE INDEX RKVersion_nonRawMasterUuid_index on RKVersion(nonRawMasterUuid);
CREATE INDEX RKVersion_latitude_index on RKVersion(latitude);
CREATE INDEX RKVersion_longitude_index on RKVersion(longitude);
CREATE INDEX RKVersion_previewsAdjustmentUuid_index on RKVersion(previewsAdjustmentUuid);
CREATE TABLE RKVersion_decimalNote (keyPath integer, value decimal, attachedToId integer, primary key (attachedToId, keyPath));
CREATE INDEX RKVersion_decimalNote_value_index on RKVersion_decimalNote(value);
CREATE VIRTUAL TABLE RKVersion_decimalNote_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TABLE RKVersion_stringNote (keyPath integer, value varchar, attachedToId integer, primary key (attachedToId, keyPath));
CREATE INDEX RKVersion_stringNote_value_index on RKVersion_stringNote(value);
CREATE VIRTUAL TABLE RKVersion_stringNote_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TABLE RKVersion_integerNote (keyPath integer, value integer, attachedToId integer, primary key (attachedToId, keyPath));
CREATE INDEX RKVersion_integerNote_value_index on RKVersion_integerNote(value);
CREATE VIRTUAL TABLE RKVersion_integerNote_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TABLE RKVersion_dataNote (keyPath integer, value blob, attachedToId integer, primary key (attachedToId, keyPath));
CREATE VIRTUAL TABLE RKVersion_dataNote_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TABLE RKVersion_stringAtomNote (keyPath integer, value integer, attachedToId integer, primary key (attachedToId, keyPath));
CREATE INDEX RKVersion_stringAtomNote_value_index on RKVersion_stringAtomNote(value);
CREATE VIRTUAL TABLE RKVersion_stringAtomNote_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TABLE RKVersion_dateNote (keyPath integer, value timestamp, attachedToId integer, primary key (attachedToId, keyPath));
CREATE INDEX RKVersion_dateNote_value_index on RKVersion_dateNote(value);
CREATE VIRTUAL TABLE RKVersion_dateNote_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TABLE RKVersion_modelId_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_isInTrash_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_cloudLibraryState_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_isCloudQuarantined_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_supportedStatus_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_faceDetectionState_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE TABLE RKVersion_faceDetectionIsFromPreview_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_subType_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_momentUuid_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_outputUpToDate_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_graphProcessingState_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE TABLE RKVersion_mediaAnalysisProcessingState_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE VIRTUAL TABLE RKVersion_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TRIGGER RKVersion_ridIndexDeleteTrigger before delete on RKVersion begin select RKVersion_notifyRidIndexDelete(old.modelId,old.subType,old.burstPickType,old.specialType,old.momentUuid,old.outputUpToDate,old.isFavorite,old.isInTrash,old.isHidden,old.type,old.colorSpaceValidationState,old.supportedStatus,old.showInLibrary,old.modelId,old.graphProcessingState,old.mediaAnalysisProcessingState,old.faceDetectionState,old.faceDetectionIsFromPreview,old.cloudLibraryState,old.hasBeenSynced,old.hasKeywords,old.isCloudQuarantined) from RKVersion where rowid=old.rowid; end;
CREATE TRIGGER RKVersion_ridIndexInsertTrigger after insert on RKVersion begin select RKVersion_notifyRidIndexInsert(new.modelId,new.subType,new.burstPickType,new.specialType,new.momentUuid,new.outputUpToDate,new.isFavorite,new.isInTrash,new.isHidden,new.type,new.colorSpaceValidationState,new.supportedStatus,new.showInLibrary,new.modelId,new.graphProcessingState,new.mediaAnalysisProcessingState,new.faceDetectionState,new.faceDetectionIsFromPreview,new.cloudLibraryState,new.hasBeenSynced,new.hasKeywords,new.isCloudQuarantined) from RKVersion where rowid=new.rowid; end;
CREATE TRIGGER RKVersion_ridIndexUpdateTrigger after update of subType,burstPickType,specialType,momentUuid,outputUpToDate,isFavorite,isInTrash,isHidden,type,colorSpaceValidationState,supportedStatus,showInLibrary,modelId,graphProcessingState,mediaAnalysisProcessingState,faceDetectionState,faceDetectionIsFromPreview,cloudLibraryState,hasBeenSynced,hasKeywords,isCloudQuarantined on RKVersion begin select RKVersion_notifyRidIndexUpdate(new.modelId,old.subType,old.burstPickType,old.specialType,old.momentUuid,old.outputUpToDate,old.isFavorite,old.isInTrash,old.isHidden,old.type,old.colorSpaceValidationState,old.supportedStatus,old.showInLibrary,old.modelId,old.graphProcessingState,old.mediaAnalysisProcessingState,old.faceDetectionState,old.faceDetectionIsFromPreview,old.cloudLibraryState,old.hasBeenSynced,old.hasKeywords,old.isCloudQuarantined,new.subType,new.burstPickType,new.specialType,new.momentUuid,new.outputUpToDate,new.isFavorite,new.isInTrash,new.isHidden,new.type,new.colorSpaceValidationState,new.supportedStatus,new.showInLibrary,new.modelId,new.graphProcessingState,new.mediaAnalysisProcessingState,new.faceDetectionState,new.faceDetectionIsFromPreview,new.cloudLibraryState,new.hasBeenSynced,new.hasKeywords,new.isCloudQuarantined) from RKVersion where rowid=old.rowid; end;
CREATE TABLE RKVersionAnalysisState (modelId integer primary key autoincrement, versionId integer, versionUuid varchar, workerType integer, analysisState integer, lastIgnoredDate timestamp, ignoreUntilDate timestamp, workerFlags integer);
CREATE INDEX RKVersionAnalysisState_versionId_index on RKVersionAnalysisState(versionId);
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 RKVersionAnalysisState_analysisState_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE VIRTUAL TABLE RKVersionAnalysisState_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TRIGGER RKVersionAnalysisState_ridIndexDeleteTrigger before delete on RKVersionAnalysisState begin select RKVersionAnalysisState_notifyRidIndexDelete(old.modelId,old.workerType,old.analysisState,old.modelId) from RKVersionAnalysisState where rowid=old.rowid; end;
CREATE TRIGGER RKVersionAnalysisState_ridIndexInsertTrigger after insert on RKVersionAnalysisState begin select RKVersionAnalysisState_notifyRidIndexInsert(new.modelId,new.workerType,new.analysisState,new.modelId) from RKVersionAnalysisState where rowid=new.rowid; end;
CREATE TRIGGER RKVersionAnalysisState_ridIndexUpdateTrigger after update of workerType,analysisState,modelId on RKVersionAnalysisState begin select RKVersionAnalysisState_notifyRidIndexUpdate(new.modelId,old.workerType,old.analysisState,old.modelId,new.workerType,new.analysisState,new.modelId) from RKVersionAnalysisState where rowid=old.rowid; end;
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 INDEX RKVolume_uuid_index on RKVolume(uuid);
CREATE INDEX RKVolume_modDate_index on RKVolume(modDate);
CREATE INDEX RKVolume_name_index on RKVolume(name);
CREATE INDEX RKVolume_createDate_index on RKVolume(createDate);
CREATE INDEX RKVolume_diskUuid_index on RKVolume(diskUuid);
CREATE TABLE RKVolume_modelId_RidIndex (modelId integer primary key, value varchar, rids blob);
CREATE VIRTUAL TABLE RKVolume_VirtualBufferReader using VirtualBufferReaderModule;
CREATE TRIGGER RKVolume_ridIndexDeleteTrigger before delete on RKVolume begin select RKVolume_notifyRidIndexDelete(old.modelId,old.modelId) from RKVolume where rowid=old.rowid; end;
CREATE TRIGGER RKVolume_ridIndexInsertTrigger after insert on RKVolume begin select RKVolume_notifyRidIndexInsert(new.modelId,new.modelId) from RKVolume where rowid=new.rowid; end;
CREATE TRIGGER RKVolume_ridIndexUpdateTrigger after update of modelId on RKVolume begin select RKVolume_notifyRidIndexUpdate(new.modelId,old.modelId,new.modelId) from RKVolume where rowid=old.rowid; end;
CREATE TRIGGER RKAlbum_skIndexDeleteTrigger before delete on RKAlbum begin select RKAlbum_notifySKIndexDelete(modelId) from RKAlbum where rowid = old.rowid; end;
CREATE TRIGGER RKAlbum_skIndexInsertTrigger after insert on RKAlbum begin select RKAlbum_notifySKIndexInsert(modelId,name) from RKAlbum where rowid = new.rowid; end;
CREATE TRIGGER RKAlbum_skIndexUpdateTrigger after update of name on RKAlbum begin select RKAlbum_notifySKIndexUpdate(modelId, old.name, new.name) from RKAlbum where rowid = old.rowid; end;
CREATE TRIGGER RKMemory_skIndexDeleteTrigger before delete on RKMemory begin select RKMemory_notifySKIndexDelete(modelId) from RKMemory where rowid = old.rowid; end;
CREATE TRIGGER RKMemory_skIndexInsertTrigger after insert on RKMemory begin select RKMemory_notifySKIndexInsert(modelId,title) from RKMemory where rowid = new.rowid; end;
CREATE TRIGGER RKMemory_skIndexUpdateTrigger after update of title on RKMemory begin select RKMemory_notifySKIndexUpdate(modelId, old.title, new.title) from RKMemory where rowid = old.rowid; end;
CREATE TRIGGER RKPlace_RTree_update_trigger after update of minLongitude,maxLongitude,minLatitude,maxLatitude on RKPlace begin update RKPlace_RTree set minLongitude=NEW.minLongitude,maxLongitude=NEW.maxLongitude,minLatitude=NEW.minLatitude,maxLatitude=NEW.maxLatitude where modelId=NEW.modelId; end;
CREATE TRIGGER RKPlace_RTree_delete_trigger after delete on RKPlace begin delete from RKPlace_RTree where modelId = OLD.modelId; end;
CREATE TRIGGER RKPlace_RTree_insert_trigger after insert on RKPlace begin insert or replace into RKPlace_RTree (modelId,minLongitude,maxLongitude,minLatitude,maxLatitude) values(NEW.modelId,NEW.minLongitude,NEW.maxLongitude,NEW.minLatitude,NEW.maxLatitude); end;
CREATE TRIGGER RKVersion_stringNote_skIndexDeleteTrigger before delete on RKVersion_stringNote begin select RKVersion_stringNote_notifySKIndexDelete(attachedToId, keyPath) from RKVersion_stringNote where rowid = old.rowid and keyPath in (728); end;
CREATE TRIGGER RKVersion_stringNote_skIndexInsertTrigger after insert on RKVersion_stringNote begin select RKVersion_stringNote_notifySKIndexInsert(attachedToId, value, keyPath) from RKVersion_stringNote where rowid = new.rowid and keyPath in (728); end;
CREATE TRIGGER RKVersion_stringNote_skIndexUpdateTrigger after update of value on RKVersion_stringNote begin select RKVersion_stringNote_notifySKIndexUpdate(attachedToId, keyPath, old.value, new.value) from RKVersion_stringNote where rowid = new.rowid and keyPath in (728); end;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment