Photos 9 to Photos 10 changes

  CREATE INDEX ATRANSACTION_ZPROCESSIDTS_INDEX ON ATRANSACTION (ZPROCESSIDTS);

-CREATE INDEX RADAR_10322662_INDEX ON "Z_28ASSETS" (Z_28ALBUMS, Z_3ASSETS, Z_FOK_3ASSETS);
+CREATE INDEX RADAR_10322662_INDEX ON "Z_31ASSETS" (Z_31ALBUMS, Z_3ASSETS, Z_FOK_3ASSETS);

-CREATE INDEX RADAR_22158684_INDEX ON "Z_28ASSETS" (Z_28ALBUMS, Z_FOK_3ASSETS, Z_3ASSETS);
+CREATE INDEX RADAR_22158684_INDEX ON "Z_31ASSETS" (Z_31ALBUMS, Z_FOK_3ASSETS, Z_3ASSETS);

  CREATE INDEX ZADDITIONALASSETATTRIBUTES_ZASSETDESCRIPTION_INDEX ON ZADDITIONALASSETATTRIBUTES (ZASSETDESCRIPTION);



  CREATE INDEX ZASSET_ZCOMPUTEDATTRIBUTES_INDEX ON ZASSET (ZCOMPUTEDATTRIBUTES);

+CREATE INDEX ZASSET_ZCOMPUTESYNCATTRIBUTES_INDEX ON ZASSET (ZCOMPUTESYNCATTRIBUTES);
+
  CREATE INDEX ZASSET_ZCONVERSATION_INDEX ON ZASSET (ZCONVERSATION);

  CREATE INDEX ZASSET_ZDAYGROUPHIGHLIGHTBEINGASSETS_INDEX ON ZASSET (ZDAYGROUPHIGHLIGHTBEINGASSETS);


  CREATE INDEX ZASSET_ZDAYGROUPHIGHLIGHTBEINGSUMMARYASSETS_INDEX ON ZASSET (ZDAYGROUPHIGHLIGHTBEINGSUMMARYASSETS);

+CREATE INDEX ZASSET_ZDAYHIGHLIGHTBEINGCOLLAGEASSETSMIXED_INDEX ON ZASSET (ZDAYHIGHLIGHTBEINGCOLLAGEASSETSMIXED);
+
+CREATE INDEX ZASSET_ZDAYHIGHLIGHTBEINGCOLLAGEASSETSPRIVATE_INDEX ON ZASSET (ZDAYHIGHLIGHTBEINGCOLLAGEASSETSPRIVATE);
+
+CREATE INDEX ZASSET_ZDAYHIGHLIGHTBEINGCOLLAGEASSETSSHARED_INDEX ON ZASSET (ZDAYHIGHLIGHTBEINGCOLLAGEASSETSSHARED);
+
  CREATE INDEX ZASSET_ZDUPLICATEMETADATAMATCHINGALBUM_INDEX ON ZASSET (ZDUPLICATEMETADATAMATCHINGALBUM);

  CREATE INDEX ZASSET_ZDUPLICATEPERCEPTUALMATCHINGALBUM_INDEX ON ZASSET (ZDUPLICATEPERCEPTUALMATCHINGALBUM);

  CREATE INDEX ZASSET_ZEXTENDEDATTRIBUTES_INDEX ON ZASSET (ZEXTENDEDATTRIBUTES);

+CREATE INDEX ZASSET_ZGENERATEDASSETDESCRIPTION_INDEX ON ZASSET (ZGENERATEDASSETDESCRIPTION);
+
  CREATE INDEX ZASSET_ZHIGHLIGHTBEINGASSETS_INDEX ON ZASSET (ZHIGHLIGHTBEINGASSETS);

  CREATE INDEX ZASSET_ZHIGHLIGHTBEINGEXTENDEDASSETS_INDEX ON ZASSET (ZHIGHLIGHTBEINGEXTENDEDASSETS);


  CREATE INDEX ZCOMPUTEDASSETATTRIBUTES_ZASSET_INDEX ON ZCOMPUTEDASSETATTRIBUTES (ZASSET);

+CREATE INDEX ZCOMPUTESYNCATTRIBUTES_ZASSET_INDEX ON ZCOMPUTESYNCATTRIBUTES (ZASSET);
+
  CREATE INDEX ZDETECTEDFACEGROUP_ZASSOCIATEDPERSON_INDEX ON ZDETECTEDFACEGROUP (ZASSOCIATEDPERSON);

  CREATE INDEX ZDETECTEDFACEGROUP_ZKEYFACE_INDEX ON ZDETECTEDFACEGROUP (ZKEYFACE);


  CREATE INDEX ZFILESYSTEMBOOKMARK_ZRESOURCE_INDEX ON ZFILESYSTEMBOOKMARK (ZRESOURCE);

+CREATE INDEX ZGENERATEDASSETDESCRIPTION_ZASSET_INDEX ON ZGENERATEDASSETDESCRIPTION (ZASSET);
+
  CREATE INDEX ZGENERICALBUM_ZCUSTOMKEYASSET_INDEX ON ZGENERICALBUM (ZCUSTOMKEYASSET);

-CREATE INDEX ZGENERICALBUM_ZKEYASSET_INDEX ON ZGENERICALBUM (ZKEYASSET);
-
  CREATE INDEX ZGENERICALBUM_ZPARENTFOLDER_INDEX ON ZGENERICALBUM (ZPARENTFOLDER);

-CREATE INDEX ZGENERICALBUM_ZSECONDARYKEYASSET_INDEX ON ZGENERICALBUM (ZSECONDARYKEYASSET);
+CREATE INDEX ZGENERICALBUM_Z_ENT_INDEX ON ZGENERICALBUM (Z_ENT);

-CREATE INDEX ZGENERICALBUM_ZTERTIARYKEYASSET_INDEX ON ZGENERICALBUM (ZTERTIARYKEYASSET);
+CREATE INDEX ZGRAPHEDGEVALUE_ZEDGE_INDEX ON ZGRAPHEDGEVALUE (ZEDGE);

-CREATE INDEX ZGENERICALBUM_Z_ENT_INDEX ON ZGENERICALBUM (Z_ENT);
+CREATE INDEX ZGRAPHEDGE_ZPRIMARYLABEL_INDEX ON ZGRAPHEDGE (ZPRIMARYLABEL);

+CREATE INDEX ZGRAPHEDGE_ZSOURCEASSET_INDEX ON ZGRAPHEDGE (ZSOURCEASSET);
+
+CREATE INDEX ZGRAPHEDGE_ZSOURCEMOMENT_INDEX ON ZGRAPHEDGE (ZSOURCEMOMENT);
+
+CREATE INDEX ZGRAPHEDGE_ZSOURCENODE_INDEX ON ZGRAPHEDGE (ZSOURCENODE);
+
+CREATE INDEX ZGRAPHEDGE_ZSOURCEPERSON_INDEX ON ZGRAPHEDGE (ZSOURCEPERSON);
+
+CREATE INDEX ZGRAPHEDGE_ZTARGETASSET_INDEX ON ZGRAPHEDGE (ZTARGETASSET);
+
+CREATE INDEX ZGRAPHEDGE_ZTARGETMOMENT_INDEX ON ZGRAPHEDGE (ZTARGETMOMENT);
+
+CREATE INDEX ZGRAPHEDGE_ZTARGETNODE_INDEX ON ZGRAPHEDGE (ZTARGETNODE);
+
+CREATE INDEX ZGRAPHEDGE_ZTARGETPERSON_INDEX ON ZGRAPHEDGE (ZTARGETPERSON);
+
+CREATE INDEX ZGRAPHNODEVALUE_ZNODE_INDEX ON ZGRAPHNODEVALUE (ZNODE);
+
+CREATE INDEX ZGRAPHNODE_ZPRIMARYLABEL_INDEX ON ZGRAPHNODE (ZPRIMARYLABEL);
+
  CREATE INDEX ZINTERNALRESOURCE_ZASSET_INDEX ON ZINTERNALRESOURCE (ZASSET);

  CREATE INDEX ZINTERNALRESOURCE_ZFILESYSTEMBOOKMARK_INDEX ON ZINTERNALRESOURCE (ZFILESYSTEMBOOKMARK);


  CREATE INDEX ZMEMORY_ZKEYASSET_INDEX ON ZMEMORY (ZKEYASSET);

+CREATE INDEX ZMEMORY_ZSOURCEGENERATEDMEMORY_INDEX ON ZMEMORY (ZSOURCEGENERATEDMEMORY);
+
+CREATE INDEX ZMEMORY_ZTARGETUSEREDITEDMEMORY_INDEX ON ZMEMORY (ZTARGETUSEREDITEDMEMORY);
+
  CREATE INDEX ZMOMENT_ZHIGHLIGHT_INDEX ON ZMOMENT (ZHIGHLIGHT);

  CREATE INDEX ZPERSONREFERENCE_ZASSETATTRIBUTES_INDEX ON ZPERSONREFERENCE (ZASSETATTRIBUTES);


  CREATE INDEX ZPHOTOANALYSISASSETATTRIBUTES_ZASSET_INDEX ON ZPHOTOANALYSISASSETATTRIBUTES (ZASSET);

-CREATE INDEX ZPHOTOSHIGHLIGHT_ZADAPTIVEKEYASSETPRIVATEUSEREDITED_INDEX ON ZPHOTOSHIGHLIGHT (ZADAPTIVEKEYASSETPRIVATEUSEREDITED);
-
-CREATE INDEX ZPHOTOSHIGHLIGHT_ZADAPTIVEKEYASSETPRIVATE_INDEX ON ZPHOTOSHIGHLIGHT (ZADAPTIVEKEYASSETPRIVATE);
-
-CREATE INDEX ZPHOTOSHIGHLIGHT_ZADAPTIVEKEYASSETSHAREDUSEREDITED_INDEX ON ZPHOTOSHIGHLIGHT (ZADAPTIVEKEYASSETSHAREDUSEREDITED);
-
-CREATE INDEX ZPHOTOSHIGHLIGHT_ZADAPTIVEKEYASSETSHARED_INDEX ON ZPHOTOSHIGHLIGHT (ZADAPTIVEKEYASSETSHARED);
-
  CREATE INDEX ZPHOTOSHIGHLIGHT_ZDAYGROUPKEYASSETPRIVATE_INDEX ON ZPHOTOSHIGHLIGHT (ZDAYGROUPKEYASSETPRIVATE);

  CREATE INDEX ZPHOTOSHIGHLIGHT_ZDAYGROUPKEYASSETSHARED_INDEX ON ZPHOTOSHIGHLIGHT (ZDAYGROUPKEYASSETSHARED);


  CREATE INDEX ZVISUALSEARCHATTRIBUTES_ZMEDIAANALYSISASSETATTRIBUTES_INDEX ON ZVISUALSEARCHATTRIBUTES (ZMEDIAANALYSISASSETATTRIBUTES);

-CREATE INDEX Z_17CLUSTERREJECTEDPERSONS_Z_44CLUSTERREJECTEDPERSONS_INDEX ON "Z_18CLUSTERREJECTEDPERSONS" (
-    Z_47CLUSTERREJECTEDPERSONS,
-    Z_18CLUSTERREJECTEDFACES
+CREATE INDEX Z_18CLUSTERREJECTEDPERSONS_Z_47CLUSTERREJECTEDPERSONS_INDEX ON "Z_20CLUSTERREJECTEDPERSONS" (
+    Z_55CLUSTERREJECTEDPERSONS,
+    Z_20CLUSTERREJECTEDFACES
  );

-CREATE INDEX Z_17CLUSTERREJECTEDPERSONS_Z_45CLUSTERREJECTEDPERSONS_INDEX ON "Z_18CLUSTERREJECTEDPERSONS" (
-    Z_47CLUSTERREJECTEDPERSONS,
-    Z_18CLUSTERREJECTEDFACES
+CREATE INDEX Z_18REJECTEDPERSONSNEEDINGFACECROPS_Z_47REJECTEDPERSONSNEEDINGFACECROPS_INDEX ON "Z_20REJECTEDPERSONSNEEDINGFACECROPS" (
+    Z_55REJECTEDPERSONSNEEDINGFACECROPS,
+    Z_20REJECTEDFACESNEEDINGFACECROPS
  );

-CREATE INDEX Z_17REJECTEDPERSONSNEEDINGFACECROPS_Z_44REJECTEDPERSONSNEEDINGFACECROPS_INDEX ON "Z_18REJECTEDPERSONSNEEDINGFACECROPS" (
-    Z_47REJECTEDPERSONSNEEDINGFACECROPS,
-    Z_18REJECTEDFACESNEEDINGFACECROPS
-);
+CREATE INDEX Z_18REJECTEDPERSONS_Z_47REJECTEDPERSONS_INDEX ON "Z_20REJECTEDPERSONS" (Z_55REJECTEDPERSONS, Z_20REJECTEDFACES);

-CREATE INDEX Z_17REJECTEDPERSONSNEEDINGFACECROPS_Z_45REJECTEDPERSONSNEEDINGFACECROPS_INDEX ON "Z_18REJECTEDPERSONSNEEDINGFACECROPS" (
-    Z_47REJECTEDPERSONSNEEDINGFACECROPS,
-    Z_18REJECTEDFACESNEEDINGFACECROPS
-);
+CREATE INDEX Z_1KEYWORDS_Z_40KEYWORDS_INDEX ON Z_1KEYWORDS (Z_48KEYWORDS, Z_1ASSETATTRIBUTES);

-CREATE INDEX Z_17REJECTEDPERSONS_Z_44REJECTEDPERSONS_INDEX ON "Z_18REJECTEDPERSONS" (Z_47REJECTEDPERSONS, Z_18REJECTEDFACES);
+CREATE INDEX Z_1KEYWORDS_Z_48KEYWORDS_INDEX ON Z_1KEYWORDS (Z_48KEYWORDS, Z_1ASSETATTRIBUTES);

-CREATE INDEX Z_17REJECTEDPERSONS_Z_45REJECTEDPERSONS_INDEX ON "Z_18REJECTEDPERSONS" (Z_47REJECTEDPERSONS, Z_18REJECTEDFACES);
-
-CREATE INDEX Z_18CLUSTERREJECTEDPERSONS_Z_47CLUSTERREJECTEDPERSONS_INDEX ON Z_18CLUSTERREJECTEDPERSONS (
-    Z_47CLUSTERREJECTEDPERSONS,
-    Z_18CLUSTERREJECTEDFACES
-);
-
-CREATE INDEX Z_18REJECTEDPERSONSNEEDINGFACECROPS_Z_47REJECTEDPERSONSNEEDINGFACECROPS_INDEX ON Z_18REJECTEDPERSONSNEEDINGFACECROPS (
-    Z_47REJECTEDPERSONSNEEDINGFACECROPS,
-    Z_18REJECTEDFACESNEEDINGFACECROPS
-);
-
-CREATE INDEX Z_18REJECTEDPERSONS_Z_47REJECTEDPERSONS_INDEX ON Z_18REJECTEDPERSONS (Z_47REJECTEDPERSONS, Z_18REJECTEDFACES);
-
-CREATE INDEX Z_1KEYWORDS_Z_36KEYWORDS_INDEX ON Z_1KEYWORDS (Z_40KEYWORDS, Z_1ASSETATTRIBUTES);
-
-CREATE INDEX Z_1KEYWORDS_Z_37KEYWORDS_INDEX ON Z_1KEYWORDS (Z_40KEYWORDS, Z_1ASSETATTRIBUTES);
-
-CREATE INDEX Z_1KEYWORDS_Z_38KEYWORDS_INDEX ON Z_1KEYWORDS (Z_40KEYWORDS, Z_1ASSETATTRIBUTES);
-
-CREATE INDEX Z_1KEYWORDS_Z_40KEYWORDS_INDEX ON Z_1KEYWORDS (Z_40KEYWORDS, Z_1ASSETATTRIBUTES);
-
-CREATE INDEX Z_25ALBUMLISTS_Z_2ALBUMLISTS_INDEX ON "Z_27ALBUMLISTS" (Z_2ALBUMLISTS, Z_27ALBUMS);
-
-CREATE INDEX Z_25ALBUMLISTS_Z_3ALBUMLISTS_INDEX ON "Z_27ALBUMLISTS" (Z_2ALBUMLISTS, Z_27ALBUMS);
-
-CREATE INDEX Z_26ALBUMLISTS_Z_2ALBUMLISTS_INDEX ON "Z_27ALBUMLISTS" (Z_2ALBUMLISTS, Z_27ALBUMS);
-
-CREATE INDEX Z_26ASSETS_Z_34ASSETS_INDEX ON "Z_28ASSETS" (Z_3ASSETS, Z_28ALBUMS);
-
-CREATE INDEX Z_26ASSETS_Z_3ASSETS_INDEX ON "Z_28ASSETS" (Z_3ASSETS, Z_28ALBUMS);
-
-CREATE INDEX Z_27ALBUMLISTS_Z_2ALBUMLISTS_INDEX ON Z_27ALBUMLISTS (Z_2ALBUMLISTS, Z_27ALBUMS);
-
-CREATE INDEX Z_27ASSETS_Z_3ASSETS_INDEX ON "Z_28ASSETS" (Z_3ASSETS, Z_28ALBUMS);
-
-CREATE INDEX Z_28ASSETS_Z_3ASSETS_INDEX ON Z_28ASSETS (Z_3ASSETS, Z_28ALBUMS);
-
-CREATE INDEX Z_34MEMORIESBEINGCURATEDASSETS_Z_40MEMORIESBEINGCURATEDASSETS_INDEX ON "Z_3MEMORIESBEINGCURATEDASSETS" (Z_44MEMORIESBEINGCURATEDASSETS, Z_3CURATEDASSETS);
-
-CREATE INDEX Z_34MEMORIESBEINGEXTENDEDCURATEDASSETS_Z_40MEMORIESBEINGEXTENDEDCURATEDASSETS_INDEX ON "Z_3MEMORIESBEINGEXTENDEDCURATEDASSETS" (
-    Z_44MEMORIESBEINGEXTENDEDCURATEDASSETS,
-    Z_3EXTENDEDCURATEDASSETS
+CREATE INDEX Z_20CLUSTERREJECTEDPERSONS_Z_55CLUSTERREJECTEDPERSONS_INDEX ON Z_20CLUSTERREJECTEDPERSONS (
+    Z_55CLUSTERREJECTEDPERSONS,
+    Z_20CLUSTERREJECTEDFACES
  );

-CREATE INDEX Z_34MEMORIESBEINGMOVIECURATEDASSETS_Z_40MEMORIESBEINGMOVIECURATEDASSETS_INDEX ON "Z_3MEMORIESBEINGMOVIECURATEDASSETS" (
-    Z_44MEMORIESBEINGMOVIECURATEDASSETS,
-    Z_3MOVIECURATEDASSETS
+CREATE INDEX Z_20REJECTEDPERSONSNEEDINGFACECROPS_Z_55REJECTEDPERSONSNEEDINGFACECROPS_INDEX ON Z_20REJECTEDPERSONSNEEDINGFACECROPS (
+    Z_55REJECTEDPERSONSNEEDINGFACECROPS,
+    Z_20REJECTEDFACESNEEDINGFACECROPS
  );

-CREATE INDEX Z_34MEMORIESBEINGREPRESENTATIVEASSETS_Z_40MEMORIESBEINGREPRESENTATIVEASSETS_INDEX ON "Z_3MEMORIESBEINGREPRESENTATIVEASSETS" (
-    Z_44MEMORIESBEINGREPRESENTATIVEASSETS,
-    Z_3REPRESENTATIVEASSETS
-);
+CREATE INDEX Z_20REJECTEDPERSONS_Z_55REJECTEDPERSONS_INDEX ON Z_20REJECTEDPERSONS (Z_55REJECTEDPERSONS, Z_20REJECTEDFACES);

-CREATE INDEX Z_34SUGGESTIONSBEINGKEYASSETS_Z_51SUGGESTIONSBEINGKEYASSETS_INDEX ON "Z_3SUGGESTIONSBEINGKEYASSETS" (Z_58SUGGESTIONSBEINGKEYASSETS, Z_3KEYASSETS);
+CREATE INDEX Z_27ALBUMLISTS_Z_2ALBUMLISTS_INDEX ON "Z_30ALBUMLISTS" (Z_2ALBUMLISTS, Z_30ALBUMS);

-CREATE INDEX Z_34SUGGESTIONSBEINGKEYASSETS_Z_52SUGGESTIONSBEINGKEYASSETS_INDEX ON "Z_3SUGGESTIONSBEINGKEYASSETS" (Z_58SUGGESTIONSBEINGKEYASSETS, Z_3KEYASSETS);
+CREATE INDEX Z_28ASSETS_Z_3ASSETS_INDEX ON "Z_31ASSETS" (Z_3ASSETS, Z_31ALBUMS);

-CREATE INDEX Z_34SUGGESTIONSBEINGREPRESENTATIVEASSETS_Z_51SUGGESTIONSBEINGREPRESENTATIVEASSETS_INDEX ON "Z_3SUGGESTIONSBEINGREPRESENTATIVEASSETS" (
-    Z_58SUGGESTIONSBEINGREPRESENTATIVEASSETS,
-    Z_3REPRESENTATIVEASSETS1
-);
+CREATE INDEX Z_30ALBUMLISTS_Z_2ALBUMLISTS_INDEX ON Z_30ALBUMLISTS (Z_2ALBUMLISTS, Z_30ALBUMS);

-CREATE INDEX Z_34SUGGESTIONSBEINGREPRESENTATIVEASSETS_Z_52SUGGESTIONSBEINGREPRESENTATIVEASSETS_INDEX ON "Z_3SUGGESTIONSBEINGREPRESENTATIVEASSETS" (
-    Z_58SUGGESTIONSBEINGREPRESENTATIVEASSETS,
-    Z_3REPRESENTATIVEASSETS1
-);
+CREATE INDEX Z_30KEYASSETS_Z_3KEYASSETS_INDEX ON Z_30KEYASSETS (Z_3KEYASSETS, Z_30ALBUMSBEINGKEYASSETS);

-CREATE INDEX Z_3HIGHLIGHTSBEINGADAPTIVEASSETS_Z_50HIGHLIGHTSBEINGADAPTIVEASSETS_INDEX ON Z_3HIGHLIGHTSBEINGADAPTIVEASSETS (
-    Z_50HIGHLIGHTSBEINGADAPTIVEASSETS,
-    Z_3ADAPTIVEASSETS
-);
+CREATE INDEX Z_31ASSETS_Z_3ASSETS_INDEX ON Z_31ASSETS (Z_3ASSETS, Z_31ALBUMS);

-CREATE INDEX Z_3HIGHLIGHTSBEINGADAPTIVEEXPLICITLYADDEDASSETS_Z_50HIGHLIGHTSBEINGADAPTIVEEXPLICITLYADDEDASSETS_INDEX ON Z_3HIGHLIGHTSBEINGADAPTIVEEXPLICITLYADDEDASSETS (
-    Z_50HIGHLIGHTSBEINGADAPTIVEEXPLICITLYADDEDASSETS,
-    Z_3ADAPTIVEEXPLICITLYADDEDASSETS
-);
+CREATE INDEX Z_3MEMORIESBEINGCURATEDASSETS_Z_44MEMORIESBEINGCURATEDASSETS_INDEX ON Z_3MEMORIESBEINGCURATEDASSETS (Z_52MEMORIESBEINGCURATEDASSETS, Z_3CURATEDASSETS);

-CREATE INDEX Z_3HIGHLIGHTSBEINGADAPTIVEEXPLICITLYREMOVEDASSETS_Z_50HIGHLIGHTSBEINGADAPTIVEEXPLICITLYREMOVEDASSETS_INDEX ON Z_3HIGHLIGHTSBEINGADAPTIVEEXPLICITLYREMOVEDASSETS (
-    Z_50HIGHLIGHTSBEINGADAPTIVEEXPLICITLYREMOVEDASSETS,
-    Z_3ADAPTIVEEXPLICITLYREMOVEDASSETS
-);
-
-CREATE INDEX Z_3HIGHLIGHTSBEINGADAPTIVEEXTENDEDASSETS_Z_50HIGHLIGHTSBEINGADAPTIVEEXTENDEDASSETS_INDEX ON Z_3HIGHLIGHTSBEINGADAPTIVEEXTENDEDASSETS (
-    Z_50HIGHLIGHTSBEINGADAPTIVEEXTENDEDASSETS,
-    Z_3ADAPTIVEEXTENDEDASSETS
-);
-
-CREATE INDEX Z_3HIGHLIGHTSBEINGADAPTIVESUMMARYASSETS_Z_50HIGHLIGHTSBEINGADAPTIVESUMMARYASSETS_INDEX ON Z_3HIGHLIGHTSBEINGADAPTIVESUMMARYASSETS (
-    Z_50HIGHLIGHTSBEINGADAPTIVESUMMARYASSETS,
-    Z_3ADAPTIVESUMMARYASSETS
-);
+CREATE INDEX Z_3MEMORIESBEINGCURATEDASSETS_Z_52MEMORIESBEINGCURATEDASSETS_INDEX ON Z_3MEMORIESBEINGCURATEDASSETS (Z_52MEMORIESBEINGCURATEDASSETS, Z_3CURATEDASSETS);

-CREATE INDEX Z_3MEMORIESBEINGCURATEDASSETS_Z_40MEMORIESBEINGCURATEDASSETS_INDEX ON Z_3MEMORIESBEINGCURATEDASSETS (Z_44MEMORIESBEINGCURATEDASSETS, Z_3CURATEDASSETS);
-
-CREATE INDEX Z_3MEMORIESBEINGCURATEDASSETS_Z_42MEMORIESBEINGCURATEDASSETS_INDEX ON Z_3MEMORIESBEINGCURATEDASSETS (Z_44MEMORIESBEINGCURATEDASSETS, Z_3CURATEDASSETS);
-
-CREATE INDEX Z_3MEMORIESBEINGCURATEDASSETS_Z_44MEMORIESBEINGCURATEDASSETS_INDEX ON Z_3MEMORIESBEINGCURATEDASSETS (Z_44MEMORIESBEINGCURATEDASSETS, Z_3CURATEDASSETS);
-
  CREATE INDEX Z_3MEMORIESBEINGCUSTOMUSERASSETS_Z_44MEMORIESBEINGCUSTOMUSERASSETS_INDEX ON Z_3MEMORIESBEINGCUSTOMUSERASSETS (
-    Z_44MEMORIESBEINGCUSTOMUSERASSETS,
+    Z_52MEMORIESBEINGCUSTOMUSERASSETS,
      Z_3CUSTOMUSERASSETS
  );

-CREATE INDEX Z_3MEMORIESBEINGEXTENDEDCURATEDASSETS_Z_40MEMORIESBEINGEXTENDEDCURATEDASSETS_INDEX ON Z_3MEMORIESBEINGEXTENDEDCURATEDASSETS (
-    Z_44MEMORIESBEINGEXTENDEDCURATEDASSETS,
-    Z_3EXTENDEDCURATEDASSETS
+CREATE INDEX Z_3MEMORIESBEINGCUSTOMUSERASSETS_Z_52MEMORIESBEINGCUSTOMUSERASSETS_INDEX ON Z_3MEMORIESBEINGCUSTOMUSERASSETS (
+    Z_52MEMORIESBEINGCUSTOMUSERASSETS,
+    Z_3CUSTOMUSERASSETS
  );

-CREATE INDEX Z_3MEMORIESBEINGEXTENDEDCURATEDASSETS_Z_42MEMORIESBEINGEXTENDEDCURATEDASSETS_INDEX ON Z_3MEMORIESBEINGEXTENDEDCURATEDASSETS (
-    Z_44MEMORIESBEINGEXTENDEDCURATEDASSETS,
+CREATE INDEX Z_3MEMORIESBEINGEXTENDEDCURATEDASSETS_Z_44MEMORIESBEINGEXTENDEDCURATEDASSETS_INDEX ON Z_3MEMORIESBEINGEXTENDEDCURATEDASSETS (
+    Z_52MEMORIESBEINGEXTENDEDCURATEDASSETS,
      Z_3EXTENDEDCURATEDASSETS
  );

-CREATE INDEX Z_3MEMORIESBEINGEXTENDEDCURATEDASSETS_Z_44MEMORIESBEINGEXTENDEDCURATEDASSETS_INDEX ON Z_3MEMORIESBEINGEXTENDEDCURATEDASSETS (
-    Z_44MEMORIESBEINGEXTENDEDCURATEDASSETS,
+CREATE INDEX Z_3MEMORIESBEINGEXTENDEDCURATEDASSETS_Z_52MEMORIESBEINGEXTENDEDCURATEDASSETS_INDEX ON Z_3MEMORIESBEINGEXTENDEDCURATEDASSETS (
+    Z_52MEMORIESBEINGEXTENDEDCURATEDASSETS,
      Z_3EXTENDEDCURATEDASSETS
  );

-CREATE INDEX Z_3MEMORIESBEINGMOVIECURATEDASSETS_Z_40MEMORIESBEINGMOVIECURATEDASSETS_INDEX ON Z_3MEMORIESBEINGMOVIECURATEDASSETS (
-    Z_44MEMORIESBEINGMOVIECURATEDASSETS,
+CREATE INDEX Z_3MEMORIESBEINGMOVIECURATEDASSETS_Z_44MEMORIESBEINGMOVIECURATEDASSETS_INDEX ON Z_3MEMORIESBEINGMOVIECURATEDASSETS (
+    Z_52MEMORIESBEINGMOVIECURATEDASSETS,
      Z_3MOVIECURATEDASSETS
  );

-CREATE INDEX Z_3MEMORIESBEINGMOVIECURATEDASSETS_Z_42MEMORIESBEINGMOVIECURATEDASSETS_INDEX ON Z_3MEMORIESBEINGMOVIECURATEDASSETS (
-    Z_44MEMORIESBEINGMOVIECURATEDASSETS,
+CREATE INDEX Z_3MEMORIESBEINGMOVIECURATEDASSETS_Z_52MEMORIESBEINGMOVIECURATEDASSETS_INDEX ON Z_3MEMORIESBEINGMOVIECURATEDASSETS (
+    Z_52MEMORIESBEINGMOVIECURATEDASSETS,
      Z_3MOVIECURATEDASSETS
  );

-CREATE INDEX Z_3MEMORIESBEINGMOVIECURATEDASSETS_Z_44MEMORIESBEINGMOVIECURATEDASSETS_INDEX ON Z_3MEMORIESBEINGMOVIECURATEDASSETS (
-    Z_44MEMORIESBEINGMOVIECURATEDASSETS,
-    Z_3MOVIECURATEDASSETS
+CREATE INDEX Z_3MEMORIESBEINGREPRESENTATIVEASSETS_Z_44MEMORIESBEINGREPRESENTATIVEASSETS_INDEX ON Z_3MEMORIESBEINGREPRESENTATIVEASSETS (
+    Z_52MEMORIESBEINGREPRESENTATIVEASSETS,
+    Z_3REPRESENTATIVEASSETS1
  );

-CREATE INDEX Z_3MEMORIESBEINGREPRESENTATIVEASSETS_Z_40MEMORIESBEINGREPRESENTATIVEASSETS_INDEX ON Z_3MEMORIESBEINGREPRESENTATIVEASSETS (
-    Z_44MEMORIESBEINGREPRESENTATIVEASSETS,
-    Z_3REPRESENTATIVEASSETS
+CREATE INDEX Z_3MEMORIESBEINGREPRESENTATIVEASSETS_Z_52MEMORIESBEINGREPRESENTATIVEASSETS_INDEX ON Z_3MEMORIESBEINGREPRESENTATIVEASSETS (
+    Z_52MEMORIESBEINGREPRESENTATIVEASSETS,
+    Z_3REPRESENTATIVEASSETS1
  );

-CREATE INDEX Z_3MEMORIESBEINGREPRESENTATIVEASSETS_Z_42MEMORIESBEINGREPRESENTATIVEASSETS_INDEX ON Z_3MEMORIESBEINGREPRESENTATIVEASSETS (
-    Z_44MEMORIESBEINGREPRESENTATIVEASSETS,
-    Z_3REPRESENTATIVEASSETS
+CREATE INDEX Z_3MEMORIESBEINGUSERCURATEDASSETS_Z_44MEMORIESBEINGUSERCURATEDASSETS_INDEX ON Z_3MEMORIESBEINGUSERCURATEDASSETS (
+    Z_52MEMORIESBEINGUSERCURATEDASSETS,
+    Z_3USERCURATEDASSETS
  );

-CREATE INDEX Z_3MEMORIESBEINGREPRESENTATIVEASSETS_Z_44MEMORIESBEINGREPRESENTATIVEASSETS_INDEX ON Z_3MEMORIESBEINGREPRESENTATIVEASSETS (
-    Z_44MEMORIESBEINGREPRESENTATIVEASSETS,
-    Z_3REPRESENTATIVEASSETS
-);
-
-CREATE INDEX Z_3MEMORIESBEINGUSERCURATEDASSETS_Z_42MEMORIESBEINGUSERCURATEDASSETS_INDEX ON Z_3MEMORIESBEINGUSERCURATEDASSETS (
-    Z_44MEMORIESBEINGUSERCURATEDASSETS,
+CREATE INDEX Z_3MEMORIESBEINGUSERCURATEDASSETS_Z_52MEMORIESBEINGUSERCURATEDASSETS_INDEX ON Z_3MEMORIESBEINGUSERCURATEDASSETS (
+    Z_52MEMORIESBEINGUSERCURATEDASSETS,
      Z_3USERCURATEDASSETS
  );

-CREATE INDEX Z_3MEMORIESBEINGUSERCURATEDASSETS_Z_44MEMORIESBEINGUSERCURATEDASSETS_INDEX ON Z_3MEMORIESBEINGUSERCURATEDASSETS (
-    Z_44MEMORIESBEINGUSERCURATEDASSETS,
-    Z_3USERCURATEDASSETS
+CREATE INDEX Z_3MEMORIESBEINGUSERREMOVEDASSETS_Z_52MEMORIESBEINGUSERREMOVEDASSETS_INDEX ON Z_3MEMORIESBEINGUSERREMOVEDASSETS (
+    Z_52MEMORIESBEINGUSERREMOVEDASSETS,
+    Z_3USERREMOVEDASSETS
  );

-CREATE INDEX Z_3SUGGESTIONSBEINGKEYASSETS_Z_54SUGGESTIONSBEINGKEYASSETS_INDEX ON Z_3SUGGESTIONSBEINGKEYASSETS (Z_58SUGGESTIONSBEINGKEYASSETS, Z_3KEYASSETS);
+CREATE INDEX Z_3SUGGESTIONSBEINGKEYASSETS_Z_58SUGGESTIONSBEINGKEYASSETS_INDEX ON Z_3SUGGESTIONSBEINGKEYASSETS (Z_66SUGGESTIONSBEINGKEYASSETS, Z_3KEYASSETS1);

-CREATE INDEX Z_3SUGGESTIONSBEINGKEYASSETS_Z_55SUGGESTIONSBEINGKEYASSETS_INDEX ON Z_3SUGGESTIONSBEINGKEYASSETS (Z_58SUGGESTIONSBEINGKEYASSETS, Z_3KEYASSETS);
+CREATE INDEX Z_3SUGGESTIONSBEINGKEYASSETS_Z_66SUGGESTIONSBEINGKEYASSETS_INDEX ON Z_3SUGGESTIONSBEINGKEYASSETS (Z_66SUGGESTIONSBEINGKEYASSETS, Z_3KEYASSETS1);

-CREATE INDEX Z_3SUGGESTIONSBEINGKEYASSETS_Z_58SUGGESTIONSBEINGKEYASSETS_INDEX ON Z_3SUGGESTIONSBEINGKEYASSETS (Z_58SUGGESTIONSBEINGKEYASSETS, Z_3KEYASSETS);
-
-CREATE INDEX Z_3SUGGESTIONSBEINGREPRESENTATIVEASSETS_Z_54SUGGESTIONSBEINGREPRESENTATIVEASSETS_INDEX ON Z_3SUGGESTIONSBEINGREPRESENTATIVEASSETS (
-    Z_58SUGGESTIONSBEINGREPRESENTATIVEASSETS,
-    Z_3REPRESENTATIVEASSETS1
+CREATE INDEX Z_3SUGGESTIONSBEINGREPRESENTATIVEASSETS_Z_58SUGGESTIONSBEINGREPRESENTATIVEASSETS_INDEX ON Z_3SUGGESTIONSBEINGREPRESENTATIVEASSETS (
+    Z_66SUGGESTIONSBEINGREPRESENTATIVEASSETS,
+    Z_3REPRESENTATIVEASSETS
  );

-CREATE INDEX Z_3SUGGESTIONSBEINGREPRESENTATIVEASSETS_Z_55SUGGESTIONSBEINGREPRESENTATIVEASSETS_INDEX ON Z_3SUGGESTIONSBEINGREPRESENTATIVEASSETS (
-    Z_58SUGGESTIONSBEINGREPRESENTATIVEASSETS,
-    Z_3REPRESENTATIVEASSETS1
+CREATE INDEX Z_3SUGGESTIONSBEINGREPRESENTATIVEASSETS_Z_66SUGGESTIONSBEINGREPRESENTATIVEASSETS_INDEX ON Z_3SUGGESTIONSBEINGREPRESENTATIVEASSETS (
+    Z_66SUGGESTIONSBEINGREPRESENTATIVEASSETS,
+    Z_3REPRESENTATIVEASSETS
  );

-CREATE INDEX Z_3SUGGESTIONSBEINGREPRESENTATIVEASSETS_Z_58SUGGESTIONSBEINGREPRESENTATIVEASSETS_INDEX ON Z_3SUGGESTIONSBEINGREPRESENTATIVEASSETS (
-    Z_58SUGGESTIONSBEINGREPRESENTATIVEASSETS,
-    Z_3REPRESENTATIVEASSETS1
+CREATE INDEX Z_42LABELS_Z_44LABELS_INDEX ON Z_42LABELS (Z_44LABELS, Z_42EDGES);
+
+CREATE INDEX Z_44NODESBEINGADDITIONALLABEL_Z_45NODESBEINGADDITIONALLABEL_INDEX ON Z_44NODESBEINGADDITIONALLABEL (
+    Z_45NODESBEINGADDITIONALLABEL,
+    Z_44ADDITIONALLABELS
  );

-CREATE INDEX Z_44INVALIDMERGECANDIDATES_REFLEXIVE_INDEX ON "Z_47INVALIDMERGECANDIDATES" (REFLEXIVE, Z_47INVALIDMERGECANDIDATES);
+CREATE INDEX Z_47INVALIDMERGECANDIDATES_REFLEXIVE_INDEX ON "Z_55INVALIDMERGECANDIDATES" (REFLEXIVE, Z_55INVALIDMERGECANDIDATES);

-CREATE INDEX Z_44MERGECANDIDATES_REFLEXIVE_INDEX ON "Z_47MERGECANDIDATES" (REFLEXIVE, Z_47MERGECANDIDATES);
+CREATE INDEX Z_47MERGECANDIDATESWITHCONFIDENCE_REFLEXIVE_INDEX ON "Z_55MERGECANDIDATESWITHCONFIDENCE" (REFLEXIVE, Z_55MERGECANDIDATESWITHCONFIDENCE);

-CREATE INDEX Z_45INVALIDMERGECANDIDATES_REFLEXIVE_INDEX ON "Z_47INVALIDMERGECANDIDATES" (REFLEXIVE, Z_47INVALIDMERGECANDIDATES);
+CREATE INDEX Z_47MERGECANDIDATES_REFLEXIVE_INDEX ON "Z_55MERGECANDIDATES" (REFLEXIVE, Z_55MERGECANDIDATES);

-CREATE INDEX Z_45MERGECANDIDATES_REFLEXIVE_INDEX ON "Z_47MERGECANDIDATES" (REFLEXIVE, Z_47MERGECANDIDATES);
+CREATE INDEX Z_55INVALIDMERGECANDIDATES_REFLEXIVE_INDEX ON Z_55INVALIDMERGECANDIDATES (REFLEXIVE, Z_55INVALIDMERGECANDIDATES);

-CREATE INDEX Z_47INVALIDMERGECANDIDATES_REFLEXIVE_INDEX ON Z_47INVALIDMERGECANDIDATES (REFLEXIVE, Z_47INVALIDMERGECANDIDATES);
+CREATE INDEX Z_55MERGECANDIDATESWITHCONFIDENCE_REFLEXIVE_INDEX ON Z_55MERGECANDIDATESWITHCONFIDENCE (REFLEXIVE, Z_55MERGECANDIDATESWITHCONFIDENCE);

-CREATE INDEX Z_47MERGECANDIDATESWITHCONFIDENCE_REFLEXIVE_INDEX ON Z_47MERGECANDIDATESWITHCONFIDENCE (REFLEXIVE, Z_47MERGECANDIDATESWITHCONFIDENCE);
-
-CREATE INDEX Z_47MERGECANDIDATES_REFLEXIVE_INDEX ON Z_47MERGECANDIDATES (REFLEXIVE, Z_47MERGECANDIDATES);
+CREATE INDEX Z_55MERGECANDIDATES_REFLEXIVE_INDEX ON Z_55MERGECANDIDATES (REFLEXIVE, Z_55MERGECANDIDATES);

-CREATE INDEX Z_AdditionalAssetAttributes_byAdjustedFingerPrintIndex ON ZADDITIONALASSETATTRIBUTES (ZADJUSTEDFINGERPRINT COLLATE BINARY ASC);
+CREATE INDEX Z_AdditionalAssetAttributes_byAdjustedFingerPrintIndex ON ZADDITIONALASSETATTRIBUTES (ZADJUSTEDSTABLEHASH COLLATE BINARY ASC);

  CREATE INDEX Z_AdditionalAssetAttributes_byAllowedForAnalysisIndex ON ZADDITIONALASSETATTRIBUTES (ZALLOWEDFORANALYSIS COLLATE BINARY ASC);



  CREATE INDEX Z_AdditionalAssetAttributes_byLocationHashIndex ON ZADDITIONALASSETATTRIBUTES (ZLOCATIONHASH COLLATE BINARY ASC);

-CREATE INDEX Z_AdditionalAssetAttributes_byMasterFingerPrintIndex ON ZADDITIONALASSETATTRIBUTES (ZMASTERFINGERPRINT COLLATE BINARY ASC);
+CREATE INDEX Z_AdditionalAssetAttributes_byMasterFingerPrintIndex ON ZADDITIONALASSETATTRIBUTES (ZORIGINALSTABLEHASH COLLATE BINARY ASC);

  CREATE INDEX Z_AdditionalAssetAttributes_byOriginalAssetsUUIDIndex ON ZADDITIONALASSETATTRIBUTES (ZORIGINALASSETSUUID COLLATE BINARY ASC);



  CREATE INDEX Z_AlbumList_byUuidIndex ON ZALBUMLIST (ZUUID COLLATE BINARY ASC);

-CREATE INDEX Z_AlbumList_identifier ON ZALBUMLIST (ZIDENTIFIER COLLATE BINARY ASC);
-
-CREATE INDEX Z_AlbumList_uuid ON ZALBUMLIST (ZUUID COLLATE BINARY ASC);
-
  CREATE INDEX Z_Album_bySearchIndexRebuildState ON ZGENERICALBUM (ZSEARCHINDEXREBUILDSTATE COLLATE BINARY ASC)
  WHERE
      ZSEARCHINDEXREBUILDSTATE = 1;

-CREATE INDEX Z_Album_searchIndexRebuildState ON ZGENERICALBUM (ZSEARCHINDEXREBUILDSTATE COLLATE BINARY ASC);
-
  CREATE INDEX Z_AssetAnalysisState_bySortTokenIndex ON ZASSETANALYSISSTATE (ZSORTTOKEN COLLATE BINARY ASC);

  CREATE INDEX Z_AssetAnalysisState_byWorkerTypeIndex ON ZASSETANALYSISSTATE (ZWORKERTYPE COLLATE BINARY ASC);

      ZASSET COLLATE BINARY ASC
  );

-CREATE INDEX Z_AssetAnalysisState_sortToken ON ZASSETANALYSISSTATE (ZSORTTOKEN COLLATE BINARY ASC);
-
-CREATE INDEX Z_AssetAnalysisState_workerType ON ZASSETANALYSISSTATE (ZWORKERTYPE COLLATE BINARY ASC);
-
  CREATE INDEX Z_Asset_byActiveLibraryScopeParticipationAndShareState ON ZASSET (
      ZACTIVELIBRARYSCOPEPARTICIPATIONSTATE COLLATE BINARY ASC,
      ZLIBRARYSCOPESHARESTATE COLLATE BINARY ASC,

      ZHIGHLIGHTBEINGEXTENDEDASSETS IS NOT NULL;

  CREATE INDEX Z_Asset_forAllPhotosFilteredByHasAdjustments ON ZASSET (
-    ZHASADJUSTMENTS COLLATE BINARY ASC,
+    ZADJUSTMENTSSTATE COLLATE BINARY ASC,
      ZKIND COLLATE BINARY ASC,
      ZFAVORITE COLLATE BINARY ASC,
      ZDATECREATED COLLATE BINARY ASC,

      ZPLAYBACKSTYLE COLLATE BINARY ASC,
      ZFAVORITE COLLATE BINARY ASC,
      ZCOMPLETE COLLATE BINARY ASC,
-    ZDUPLICATEASSETVISIBILITYSTATE COLLATE BINARY ASC
+    ZDUPLICATEASSETVISIBILITYSTATE COLLATE BINARY ASC,
+    ZISDETECTEDSCREENSHOT COLLATE BINARY ASC
  );

+CREATE INDEX Z_Asset_forAllPhotosHavingCaptureSession ON ZASSET (
+    ZDATECREATED COLLATE BINARY ASC,
+    ZADDEDDATE COLLATE BINARY ASC,
+    Z_PK COLLATE BINARY ASC,
+    ZCAPTURESESSIONIDENTIFIER COLLATE BINARY ASC,
+    ZSAVEDASSETTYPE COLLATE BINARY ASC,
+    ZVISIBILITYSTATE COLLATE BINARY ASC,
+    ZTRASHEDSTATE COLLATE BINARY ASC,
+    ZHIDDEN COLLATE BINARY ASC,
+    ZAVALANCHEPICKTYPE COLLATE BINARY ASC,
+    ZKIND COLLATE BINARY ASC,
+    ZKINDSUBTYPE COLLATE BINARY ASC,
+    ZPLAYBACKSTYLE COLLATE BINARY ASC,
+    ZDUPLICATEASSETVISIBILITYSTATE COLLATE BINARY ASC
+)
+WHERE
+    ZCAPTURESESSIONIDENTIFIER IS NOT NULL;
+
  CREATE INDEX Z_Asset_forAllPhotosHavingImportSession ON ZASSET (
      ZIMPORTSESSION COLLATE BINARY ASC,
      ZDATECREATED COLLATE BINARY ASC,

      ZTHUMBNAILINDEX COLLATE BINARY DESC,
      ZCLOUDLOCALSTATE COLLATE BINARY ASC,
      ZDATECREATED COLLATE BINARY DESC,
-    ZHASADJUSTMENTS COLLATE BINARY ASC
+    ZADJUSTMENTSSTATE COLLATE BINARY ASC
  )
  WHERE
      (

  WHERE
      ZISMAGICCARPET = 1;

-CREATE INDEX Z_Asset_forMonoskiAlbum ON ZASSET (
-    ZDATECREATED COLLATE BINARY ASC,
-    ZADDEDDATE COLLATE BINARY ASC,
-    Z_PK COLLATE BINARY ASC,
-    ZSAVEDASSETTYPE COLLATE BINARY ASC,
-    ZVISIBILITYSTATE COLLATE BINARY ASC,
-    ZTRASHEDSTATE COLLATE BINARY ASC,
-    ZHIDDEN COLLATE BINARY ASC,
-    ZAVALANCHEPICKTYPE COLLATE BINARY ASC,
-    ZKIND COLLATE BINARY ASC,
-    ZKINDSUBTYPE COLLATE BINARY ASC,
-    ZPLAYBACKSTYLE COLLATE BINARY ASC,
-    ZDUPLICATEASSETVISIBILITYSTATE COLLATE BINARY ASC
-)
-WHERE
-    ZMONOSKITYPE <> 0;
-
  CREATE INDEX Z_Asset_forPHThumbnailAsset ON ZASSET (
      ZTHUMBNAILINDEX COLLATE BINARY ASC,
      ZCOMPLETE COLLATE BINARY ASC,

  );

  CREATE INDEX Z_Asset_forPlacesAlbum ON ZASSET (
-    ZLATITUDE COLLATE BINARY ASC,
-    ZLONGITUDE COLLATE BINARY ASC,
+    ZDATECREATED COLLATE BINARY ASC,
+    ZSAVEDASSETTYPE COLLATE BINARY ASC,
+    ZVISIBILITYSTATE COLLATE BINARY ASC,
      ZTRASHEDSTATE COLLATE BINARY ASC,
      ZHIDDEN COLLATE BINARY ASC,
      ZAVALANCHEPICKTYPE COLLATE BINARY ASC,
-    ZSAVEDASSETTYPE COLLATE BINARY ASC,
-    ZVISIBILITYSTATE COLLATE BINARY ASC
+    ZCOMPLETE COLLATE BINARY ASC,
+    ZLATITUDE COLLATE BINARY ASC,
+    ZLONGITUDE COLLATE BINARY ASC
  );

  CREATE INDEX Z_Asset_forPortraitAlbum ON ZASSET (

          OR ZLIBRARYSCOPESHARESTATE = 65552
      );

+CREATE INDEX Z_Asset_forSpatialAlbum ON ZASSET (
+    ZDATECREATED COLLATE BINARY ASC,
+    ZADDEDDATE COLLATE BINARY ASC,
+    Z_PK COLLATE BINARY ASC,
+    ZSAVEDASSETTYPE COLLATE BINARY ASC,
+    ZVISIBILITYSTATE COLLATE BINARY ASC,
+    ZTRASHEDSTATE COLLATE BINARY ASC,
+    ZHIDDEN COLLATE BINARY ASC,
+    ZAVALANCHEPICKTYPE COLLATE BINARY ASC,
+    ZKIND COLLATE BINARY ASC,
+    ZKINDSUBTYPE COLLATE BINARY ASC,
+    ZPLAYBACKSTYLE COLLATE BINARY ASC,
+    ZDUPLICATEASSETVISIBILITYSTATE COLLATE BINARY ASC
+)
+WHERE
+    ZSPATIALTYPE <> 0;
+
  CREATE INDEX Z_Asset_forUnableToUploadAlbum ON ZASSET (
      ZCLOUDLOCALSTATE COLLATE BINARY ASC,
      ZDATECREATED COLLATE BINARY ASC,

      ZADDEDDATE COLLATE BINARY ASC,
      ZSORTTOKEN COLLATE BINARY ASC,
      ZACTIVELIBRARYSCOPEPARTICIPATIONSTATE COLLATE BINARY ASC,
+    ZISRECENTLYSAVED COLLATE BINARY ASC,
      ZKIND COLLATE BINARY ASC,
+    ZKINDSUBTYPE COLLATE BINARY ASC,
      ZSAVEDASSETTYPE COLLATE BINARY ASC,
      ZVISIBILITYSTATE COLLATE BINARY ASC,
      ZTRASHEDSTATE COLLATE BINARY ASC,

      ZCOMPLETE COLLATE BINARY ASC,
      ZFAVORITE COLLATE BINARY ASC,
      ZPLAYBACKSTYLE COLLATE BINARY ASC,
-    ZDUPLICATEASSETVISIBILITYSTATE COLLATE BINARY ASC
+    ZDUPLICATEASSETVISIBILITYSTATE COLLATE BINARY ASC,
+    ZSTICKERCONFIDENCESCORE COLLATE BINARY ASC
  );

  CREATE INDEX Z_Asset_forVideosAlbum ON ZASSET (

  WHERE
      ZPLAYBACKSTYLE = 4;

+CREATE INDEX Z_BackgroundJobWorkItem_byIdentifierIndex ON ZBACKGROUNDJOBWORKITEM (ZIDENTIFIER COLLATE BINARY ASC);
+
  CREATE INDEX Z_CloudFeedEntry_byEntryDateIndex ON ZCLOUDFEEDENTRY (ZENTRYDATE COLLATE BINARY ASC);

-CREATE INDEX Z_CloudFeedEntry_byEntryTypeNumberIndex ON ZCLOUDFEEDENTRY (ZENTRYTYPENUMBER COLLATE BINARY ASC);
-
  CREATE INDEX Z_CloudFeedEntry_compoundIndex ON ZCLOUDFEEDENTRY (
      ZENTRYDATE COLLATE BINARY ASC,
      ZENTRYPRIORITYNUMBER COLLATE BINARY ASC,

      ZENTRYDATE COLLATE BINARY ASC
  );

-CREATE INDEX Z_CloudFeedEntry_entryDate ON ZCLOUDFEEDENTRY (ZENTRYDATE COLLATE BINARY ASC);
+CREATE INDEX Z_CloudFeedEntry_forMineVsTheirsIndex ON ZCLOUDFEEDENTRY (
+    ZENTRYTYPENUMBER COLLATE BINARY ASC,
+    ZENTRYISMINE COLLATE BINARY ASC,
+    ZENTRYPRIORITYNUMBER COLLATE BINARY DESC,
+    ZENTRYDATE COLLATE BINARY DESC
+);

-CREATE INDEX Z_CloudFeedEntry_entryTypeNumber ON ZCLOUDFEEDENTRY (ZENTRYTYPENUMBER COLLATE BINARY ASC);
+CREATE INDEX Z_CloudMasterMediaMetadata_byDataNULLIndex ON ZCLOUDMASTERMEDIAMETADATA (
+    ZDATA COLLATE BINARY ASC,
+    ZCLOUDMASTER COLLATE BINARY ASC
+)
+WHERE
+    ZDATA IS NULL;

  CREATE INDEX Z_CloudMaster_byCloudLocalStateIndex ON ZCLOUDMASTER (ZCLOUDLOCALSTATE COLLATE BINARY ASC);

  CREATE INDEX Z_CloudMaster_byCloudMasterGUIDIndex ON ZCLOUDMASTER (ZCLOUDMASTERGUID COLLATE BINARY ASC);

-CREATE INDEX Z_CloudMaster_cloudLocalState ON ZCLOUDMASTER (ZCLOUDLOCALSTATE COLLATE BINARY ASC);
-
-CREATE INDEX Z_CloudMaster_cloudMasterGUID ON ZCLOUDMASTER (ZCLOUDMASTERGUID COLLATE BINARY ASC);
-
-CREATE INDEX Z_CloudResource_assetUuid ON ZCLOUDRESOURCE (ZASSETUUID COLLATE BINARY ASC);
-
  CREATE INDEX Z_CloudResource_byAssetUuidIndex ON ZCLOUDRESOURCE (ZASSETUUID COLLATE BINARY ASC);

  CREATE INDEX Z_CloudResource_byDateCreatedIndex ON ZCLOUDRESOURCE (ZDATECREATED COLLATE BINARY ASC);

      ZLASTPREFETCHDATE COLLATE BINARY ASC
  );

-CREATE INDEX Z_CloudResource_dateCreated ON ZCLOUDRESOURCE (ZDATECREATED COLLATE BINARY ASC);
-
-CREATE INDEX Z_CloudResource_isAvailable ON ZCLOUDRESOURCE (ZISAVAILABLE COLLATE BINARY ASC);
-
-CREATE INDEX Z_CloudResource_isLocallyAvailable ON ZCLOUDRESOURCE (ZISLOCALLYAVAILABLE COLLATE BINARY ASC);
-
-CREATE INDEX Z_CloudResource_type ON ZCLOUDRESOURCE (ZTYPE COLLATE BINARY ASC);
-
  CREATE INDEX Z_CloudSharedComment_byCloudGUIDIndex ON ZCLOUDSHAREDCOMMENT (ZCLOUDGUID COLLATE BINARY ASC);

  CREATE INDEX Z_CloudSharedComment_byCommentDateIndex ON ZCLOUDSHAREDCOMMENT (ZCOMMENTDATE COLLATE BINARY ASC);

-CREATE INDEX Z_CloudSharedComment_cloudGUID ON ZCLOUDSHAREDCOMMENT (ZCLOUDGUID COLLATE BINARY ASC);
-
-CREATE INDEX Z_CloudSharedComment_commentDate ON ZCLOUDSHAREDCOMMENT (ZCOMMENTDATE COLLATE BINARY ASC);
-
-CREATE INDEX Z_DeferredRebuildFace_assetCloudGUID ON ZDEFERREDREBUILDFACE (ZASSETCLOUDGUID COLLATE BINARY ASC);
-
  CREATE INDEX Z_DeferredRebuildFace_byAssetCloudGUIDIndex ON ZDEFERREDREBUILDFACE (ZASSETCLOUDGUID COLLATE BINARY ASC);

  CREATE INDEX Z_DetectedFaceGroup_byPersonBuilderStateIndex ON ZDETECTEDFACEGROUP (ZPERSONBUILDERSTATE COLLATE BINARY ASC);

-CREATE INDEX Z_DetectedFaceGroup_personBuilderState ON ZDETECTEDFACEGROUP (ZPERSONBUILDERSTATE COLLATE BINARY ASC);
-
  CREATE INDEX Z_DetectedFace_byCloudLocalStateIndex ON ZDETECTEDFACE (ZCLOUDLOCALSTATE COLLATE BINARY ASC);

  CREATE INDEX Z_DetectedFace_byClusterSequenceNumberIndex ON ZDETECTEDFACE (ZCLUSTERSEQUENCENUMBER COLLATE BINARY ASC);

+CREATE INDEX Z_DetectedFace_byPersonAssetIndex ON ZDETECTEDFACE (
+    ZPERSONFORFACE COLLATE BINARY ASC,
+    ZASSETFORFACE COLLATE BINARY ASC
+);
+
  CREATE INDEX Z_DetectedFace_byUuidIndex ON ZDETECTEDFACE (ZUUID COLLATE BINARY ASC);

  CREATE INDEX Z_DetectedFace_byVuObservationIDIndex ON ZDETECTEDFACE (ZVUOBSERVATIONID COLLATE BINARY ASC);

+CREATE INDEX Z_DetectedFace_forCountOfFaceCropsToBeGenerated ON ZDETECTEDFACE (
+    ZFACECROP COLLATE BINARY ASC,
+    ZDURATION COLLATE BINARY ASC,
+    ZMANUAL COLLATE BINARY ASC,
+    ZCENTERX COLLATE BINARY ASC,
+    ZBODYCENTERX COLLATE BINARY ASC,
+    ZCONFIRMEDFACECROPGENERATIONSTATE COLLATE BINARY ASC
+)
+WHERE
+    (
+        ZFACECROP IS NULL
+        AND ZDURATION = 0
+        AND ZMANUAL = 0
+        AND (
+            ZCENTERX <> 0
+            OR ZBODYCENTERX = 0
+        )
+    );
+
  CREATE INDEX Z_FaceCrop_byCloudLocalStateIndex ON ZFACECROP (ZCLOUDLOCALSTATE COLLATE BINARY ASC);

  CREATE INDEX Z_FaceCrop_byStateIndex ON ZFACECROP (ZSTATE COLLATE BINARY ASC);

  CREATE INDEX Z_FaceCrop_byUuidIndex ON ZFACECROP (ZUUID COLLATE BINARY ASC);

-CREATE INDEX Z_FaceCrop_cloudLocalState ON ZFACECROP (ZCLOUDLOCALSTATE COLLATE BINARY ASC);
-
-CREATE INDEX Z_FaceCrop_state ON ZFACECROP (ZSTATE COLLATE BINARY ASC);
-
-CREATE INDEX Z_FaceCrop_uuid ON ZFACECROP (ZUUID COLLATE BINARY ASC);
-
  CREATE INDEX Z_FetchingAlbum_bySearchIndexRebuildState ON ZGENERICALBUM (ZSEARCHINDEXREBUILDSTATE1 COLLATE BINARY ASC)
  WHERE
      ZSEARCHINDEXREBUILDSTATE1 = 1;

-CREATE INDEX Z_FetchingAlbum_searchIndexRebuildState ON ZGENERICALBUM (ZSEARCHINDEXREBUILDSTATE1 COLLATE BINARY ASC);
-
  CREATE INDEX Z_FileSystemVolume_byUuidIndex ON ZFILESYSTEMVOLUME (ZUUID COLLATE BINARY ASC);

  CREATE INDEX Z_FileSystemVolume_byVolumeUuidStringIndex ON ZFILESYSTEMVOLUME (ZVOLUMEUUIDSTRING COLLATE BINARY ASC);

-CREATE INDEX Z_FileSystemVolume_uuid ON ZFILESYSTEMVOLUME (ZUUID COLLATE BINARY ASC);
-
-CREATE INDEX Z_FileSystemVolume_volumeUuidString ON ZFILESYSTEMVOLUME (ZVOLUMEUUIDSTRING COLLATE BINARY ASC);
-
  CREATE INDEX Z_GenericAlbum_byCloudGUIDIndex ON ZGENERICALBUM (ZCLOUDGUID COLLATE BINARY ASC);

  CREATE INDEX Z_GenericAlbum_byCloudLocalStateIndex ON ZGENERICALBUM (ZCLOUDLOCALSTATE COLLATE BINARY ASC);


  CREATE INDEX Z_GenericAlbum_byUuidIndex ON ZGENERICALBUM (ZUUID COLLATE BINARY ASC);

-CREATE INDEX Z_GenericAlbum_cloudGUID ON ZGENERICALBUM (ZCLOUDGUID COLLATE BINARY ASC);
-
-CREATE INDEX Z_GenericAlbum_cloudLocalState ON ZGENERICALBUM (ZCLOUDLOCALSTATE COLLATE BINARY ASC);
-
-CREATE INDEX Z_GenericAlbum_importSessionID ON ZGENERICALBUM (ZIMPORTSESSIONID COLLATE BINARY ASC);
-
-CREATE INDEX Z_GenericAlbum_syncEventOrderKey ON ZGENERICALBUM (ZSYNCEVENTORDERKEY COLLATE BINARY ASC);
-
-CREATE INDEX Z_GenericAlbum_uuid ON ZGENERICALBUM (ZUUID COLLATE BINARY ASC);
-
  CREATE INDEX Z_GlobalKeyValue_byKeyIndex ON ZGLOBALKEYVALUE (ZKEY COLLATE BINARY ASC);

-CREATE INDEX Z_GlobalKeyValue_key ON ZGLOBALKEYVALUE (ZKEY COLLATE BINARY ASC);
+CREATE INDEX Z_GraphNodeValue_byValueNameIndex ON ZGRAPHNODEVALUE (ZVALUENAME COLLATE BINARY ASC);

+CREATE INDEX Z_GraphNode_byPrimaryLabelAndUuidIndex ON ZGRAPHNODE (
+    ZPRIMARYLABEL COLLATE BINARY ASC,
+    ZUUID COLLATE BINARY ASC
+);
+
  CREATE INDEX Z_InternalResource_byCloudMasterDateCreatedIndex ON ZINTERNALRESOURCE (ZCLOUDMASTERDATECREATED COLLATE BINARY ASC);

  CREATE INDEX Z_InternalResource_byFileIDIndex ON ZINTERNALRESOURCE (ZFILEID COLLATE BINARY ASC);

          AND ZLOCALAVAILABILITY = -1
      );

+CREATE INDEX Z_InternalResource_forCloudPrefetchCompute ON ZINTERNALRESOURCE (
+    ZDATASTORECLASSID COLLATE BINARY ASC,
+    ZREMOTEAVAILABILITY COLLATE BINARY ASC,
+    ZLOCALAVAILABILITY COLLATE BINARY ASC,
+    ZDATASTORESUBTYPE COLLATE BINARY ASC,
+    ZVERSION COLLATE BINARY ASC,
+    ZCLOUDMASTERDATECREATED COLLATE BINARY DESC
+)
+WHERE
+    (
+        ZDATASTORECLASSID = 0
+        AND ZRESOURCETYPE = 14
+        AND ZREMOTEAVAILABILITY = 1
+        AND ZLOCALAVAILABILITY = -1
+    );
+
  CREATE INDEX Z_InternalResource_forCloudPrefetchThumbs ON ZINTERNALRESOURCE (
      ZASSET COLLATE BINARY ASC,
      ZDATASTORECLASSID COLLATE BINARY ASC,


  CREATE INDEX Z_Keyword_byUuidIndex ON ZKEYWORD (ZUUID COLLATE BINARY ASC);

-CREATE INDEX Z_Keyword_title ON ZKEYWORD (ZTITLE COLLATE BINARY ASC);
-
-CREATE INDEX Z_Keyword_uuid ON ZKEYWORD (ZUUID COLLATE BINARY ASC);
-
-CREATE INDEX Z_LegacyFace_albumUUID ON ZLEGACYFACE (ZALBUMUUID COLLATE BINARY ASC);
-
  CREATE INDEX Z_LegacyFace_byAlbumUUIDIndex ON ZLEGACYFACE (ZALBUMUUID COLLATE BINARY ASC);

  CREATE INDEX Z_LegacyFace_byIdentifierIndex ON ZLEGACYFACE (ZIDENTIFIER COLLATE BINARY ASC);

-CREATE INDEX Z_LegacyFace_identifier ON ZLEGACYFACE (ZIDENTIFIER COLLATE BINARY ASC);
-
  CREATE INDEX Z_Memory_byCloudLocalStateIndex ON ZMEMORY (ZCLOUDLOCALSTATE COLLATE BINARY ASC);

  CREATE INDEX Z_Memory_byFeaturedState ON ZMEMORY (ZFEATUREDSTATE COLLATE BINARY ASC);


  CREATE INDEX Z_Memory_byUuidIndex ON ZMEMORY (ZUUID COLLATE BINARY ASC);

-CREATE INDEX Z_Memory_compoundIndex ON ZMEMORY (
+CREATE INDEX Z_Memory_forFeatured ON ZMEMORY (
      ZCREATIONDATE COLLATE BINARY DESC,
+    ZSCORE COLLATE BINARY DESC,
+    Z_PK COLLATE BINARY ASC,
      ZREJECTED COLLATE BINARY DESC,
      ZFEATUREDSTATE COLLATE BINARY ASC,
      ZPENDINGSTATE COLLATE BINARY ASC
  );

+CREATE INDEX Z_Memory_forUpload ON ZMEMORY (
+    ZPENDINGSTATE COLLATE BINARY ASC,
+    ZCLOUDLOCALSTATE COLLATE BINARY ASC,
+    ZSYNDICATEDCONTENTSTATE COLLATE BINARY ASC,
+    ZCREATIONDATE COLLATE BINARY DESC
+);
+
  CREATE INDEX Z_MigrationHistory_byIndexIndex ON ZMIGRATIONHISTORY (ZINDEX COLLATE BINARY ASC);

  CREATE INDEX Z_MigrationHistory_byMigrationDateIndex ON ZMIGRATIONHISTORY (ZMIGRATIONDATE COLLATE BINARY ASC);

      ZENDDATE COLLATE BINARY ASC
  );

-CREATE INDEX Z_Moment_endDate ON ZMOMENT (ZENDDATE COLLATE BINARY ASC);
-
-CREATE INDEX Z_Moment_representativeDate ON ZMOMENT (ZREPRESENTATIVEDATE COLLATE BINARY ASC);
-
-CREATE INDEX Z_Moment_startDate ON ZMOMENT (ZSTARTDATE COLLATE BINARY ASC);
-
-CREATE INDEX Z_Moment_trashedState ON ZMOMENT (ZTRASHEDSTATE COLLATE BINARY ASC);
-
-CREATE INDEX Z_Moment_uuid ON ZMOMENT (ZUUID COLLATE BINARY ASC);
-
  CREATE INDEX Z_Person_byCloudLocalStateAndVerifiedType ON ZPERSON (
      ZCLOUDLOCALSTATE COLLATE BINARY ASC,
      ZVERIFIEDTYPE COLLATE BINARY ASC


  CREATE INDEX Z_PhotosHighlight_byDateRangeAndKind ON ZPHOTOSHIGHLIGHT (
      ZKIND COLLATE BINARY ASC,
-    ZSTARTDATE COLLATE BINARY ASC,
-    ZENDDATE COLLATE BINARY ASC
+    ZSTARTDATE COLLATE BINARY DESC,
+    ZENDDATE COLLATE BINARY DESC,
+    Z_PK COLLATE BINARY ASC,
+    ZTYPE COLLATE BINARY ASC,
+    ZVISIBILITYSTATE COLLATE BINARY ASC,
+    ZVISIBILITYSTATEMIXED COLLATE BINARY ASC,
+    ZVISIBILITYSTATESHARED COLLATE BINARY ASC,
+    ZEXTENDEDCOUNT COLLATE BINARY ASC,
+    ZEXTENDEDCOUNTSHARED COLLATE BINARY ASC
  );

  CREATE INDEX Z_PhotosHighlight_byKindIndex ON ZPHOTOSHIGHLIGHT (ZKIND COLLATE BINARY ASC);

+CREATE INDEX Z_PhotosHighlight_byParentAndKind ON ZPHOTOSHIGHLIGHT (
+    ZPARENTPHOTOSHIGHLIGHT COLLATE BINARY ASC,
+    ZKIND COLLATE BINARY ASC,
+    ZSTARTDATE COLLATE BINARY ASC,
+    Z_PK COLLATE BINARY ASC
+);
+
  CREATE INDEX Z_PhotosHighlight_bySearchIndexRebuildState ON ZPHOTOSHIGHLIGHT (ZSEARCHINDEXREBUILDSTATE COLLATE BINARY ASC)
  WHERE
      ZSEARCHINDEXREBUILDSTATE = 1;

  CREATE INDEX Z_PhotosHighlight_byUuidIndex ON ZPHOTOSHIGHLIGHT (ZUUID COLLATE BINARY ASC);

-CREATE INDEX Z_Question_byUuidIndex ON ZQUESTION (ZUUID COLLATE BINARY ASC);
+CREATE INDEX Z_PhotosHighlight_forHighlightsVisibilityState ON ZPHOTOSHIGHLIGHT (
+    ZKIND COLLATE BINARY ASC,
+    ZVISIBILITYSTATE COLLATE BINARY ASC,
+    ZPROMOTIONSCORE COLLATE BINARY ASC,
+    ZSHARINGCOMPOSITION COLLATE BINARY ASC,
+    ZTYPE COLLATE BINARY ASC,
+    ZSTARTDATE COLLATE BINARY ASC,
+    Z_PK COLLATE BINARY ASC
+);

-CREATE INDEX Z_Question_uuid ON ZQUESTION (ZUUID COLLATE BINARY ASC);
+CREATE INDEX Z_PhotosHighlight_forHighlightsVisibilityStateMixed ON ZPHOTOSHIGHLIGHT (
+    ZKIND COLLATE BINARY ASC,
+    ZVISIBILITYSTATEMIXED COLLATE BINARY ASC,
+    ZPROMOTIONSCORE COLLATE BINARY ASC,
+    ZTYPE COLLATE BINARY ASC,
+    ZSTARTDATE COLLATE BINARY ASC,
+    Z_PK COLLATE BINARY ASC
+);

+CREATE INDEX Z_PhotosHighlight_forHighlightsVisibilityStateShared ON ZPHOTOSHIGHLIGHT (
+    ZKIND COLLATE BINARY ASC,
+    ZVISIBILITYSTATESHARED COLLATE BINARY ASC,
+    ZPROMOTIONSCORE COLLATE BINARY ASC,
+    ZSHARINGCOMPOSITION COLLATE BINARY ASC,
+    ZTYPE COLLATE BINARY ASC,
+    ZSTARTDATE COLLATE BINARY ASC,
+    Z_PK COLLATE BINARY ASC
+);
+
+CREATE INDEX Z_Question_byUuidIndex ON ZQUESTION (ZUUID COLLATE BINARY ASC);
+
  CREATE INDEX Z_SceneClassification_bySceneIdentifierAndConfidence ON ZSCENECLASSIFICATION (
      ZSCENEIDENTIFIER COLLATE BINARY ASC,
      ZCONFIDENCE COLLATE BINARY ASC


  CREATE INDEX Z_Share_byUuidIndex ON ZSHARE (ZUUID COLLATE BINARY ASC);

-CREATE INDEX Z_Share_shareURL ON ZSHARE (ZSHAREURL COLLATE BINARY ASC);
-
-CREATE INDEX Z_Share_uuid ON ZSHARE (ZUUID COLLATE BINARY ASC);
-
  CREATE INDEX Z_Suggestion_byCreationDate ON ZSUGGESTION (ZCREATIONDATE COLLATE BINARY DESC);

  CREATE INDEX Z_Suggestion_byFeaturedState ON ZSUGGESTION (ZFEATUREDSTATE COLLATE BINARY ASC);

      ZNAME VARCHAR
  );

-CREATE TABLE IF NOT EXISTS "Z_18CLUSTERREJECTEDPERSONS" (
-    Z_18CLUSTERREJECTEDFACES INTEGER,
-    Z_47CLUSTERREJECTEDPERSONS INTEGER,
+CREATE TABLE IF NOT EXISTS "Z_20CLUSTERREJECTEDPERSONS" (
+    Z_20CLUSTERREJECTEDFACES INTEGER,
+    Z_55CLUSTERREJECTEDPERSONS INTEGER,
      PRIMARY KEY (
-        Z_18CLUSTERREJECTEDFACES,
-        Z_47CLUSTERREJECTEDPERSONS
+        Z_20CLUSTERREJECTEDFACES,
+        Z_55CLUSTERREJECTEDPERSONS
      )
  );

-CREATE TABLE IF NOT EXISTS "Z_18REJECTEDPERSONS" (
-    Z_18REJECTEDFACES INTEGER,
-    Z_47REJECTEDPERSONS INTEGER,
-    PRIMARY KEY (Z_18REJECTEDFACES, Z_47REJECTEDPERSONS)
+CREATE TABLE IF NOT EXISTS "Z_20REJECTEDPERSONS" (
+    Z_20REJECTEDFACES INTEGER,
+    Z_55REJECTEDPERSONS INTEGER,
+    PRIMARY KEY (Z_20REJECTEDFACES, Z_55REJECTEDPERSONS)
  );

-CREATE TABLE IF NOT EXISTS "Z_18REJECTEDPERSONSNEEDINGFACECROPS" (
-    Z_18REJECTEDFACESNEEDINGFACECROPS INTEGER,
-    Z_47REJECTEDPERSONSNEEDINGFACECROPS INTEGER,
+CREATE TABLE IF NOT EXISTS "Z_20REJECTEDPERSONSNEEDINGFACECROPS" (
+    Z_20REJECTEDFACESNEEDINGFACECROPS INTEGER,
+    Z_55REJECTEDPERSONSNEEDINGFACECROPS INTEGER,
      PRIMARY KEY (
-        Z_18REJECTEDFACESNEEDINGFACECROPS,
-        Z_47REJECTEDPERSONSNEEDINGFACECROPS
+        Z_20REJECTEDFACESNEEDINGFACECROPS,
+        Z_55REJECTEDPERSONSNEEDINGFACECROPS
      )
  );

-CREATE TABLE IF NOT EXISTS "Z_27ALBUMLISTS" (
-    Z_27ALBUMS INTEGER,
+CREATE TABLE IF NOT EXISTS "Z_30ALBUMLISTS" (
+    Z_30ALBUMS INTEGER,
      Z_2ALBUMLISTS INTEGER,
-    Z_FOK_27ALBUMS INTEGER,
-    PRIMARY KEY (Z_27ALBUMS, Z_2ALBUMLISTS)
+    Z_FOK_30ALBUMS INTEGER,
+    PRIMARY KEY (Z_30ALBUMS, Z_2ALBUMLISTS)
  );

-CREATE TABLE IF NOT EXISTS "Z_28ASSETS" (
-    Z_28ALBUMS INTEGER,
+CREATE TABLE IF NOT EXISTS "Z_31ASSETS" (
+    Z_31ALBUMS INTEGER,
      Z_3ASSETS INTEGER,
      Z_FOK_3ASSETS INTEGER,
-    PRIMARY KEY (Z_28ALBUMS, Z_3ASSETS)
+    PRIMARY KEY (Z_31ALBUMS, Z_3ASSETS)
  );

-CREATE TABLE IF NOT EXISTS "Z_3MEMORIESBEINGCURATEDASSETS" (
-    Z_3CURATEDASSETS INTEGER,
-    Z_44MEMORIESBEINGCURATEDASSETS INTEGER,
-    PRIMARY KEY (Z_3CURATEDASSETS, Z_44MEMORIESBEINGCURATEDASSETS)
+CREATE TABLE IF NOT EXISTS "Z_55INVALIDMERGECANDIDATES" (
+    Z_55INVALIDMERGECANDIDATES INTEGER,
+    REFLEXIVE INTEGER,
+    PRIMARY KEY (Z_55INVALIDMERGECANDIDATES, REFLEXIVE)
  );

-CREATE TABLE IF NOT EXISTS "Z_3MEMORIESBEINGEXTENDEDCURATEDASSETS" (
-    Z_3EXTENDEDCURATEDASSETS INTEGER,
-    Z_44MEMORIESBEINGEXTENDEDCURATEDASSETS INTEGER,
-    PRIMARY KEY (
-        Z_3EXTENDEDCURATEDASSETS,
-        Z_44MEMORIESBEINGEXTENDEDCURATEDASSETS
-    )
-);
-
-CREATE TABLE IF NOT EXISTS "Z_3MEMORIESBEINGMOVIECURATEDASSETS" (
-    Z_3MOVIECURATEDASSETS INTEGER,
-    Z_44MEMORIESBEINGMOVIECURATEDASSETS INTEGER,
-    PRIMARY KEY (
-        Z_3MOVIECURATEDASSETS,
-        Z_44MEMORIESBEINGMOVIECURATEDASSETS
-    )
-);
-
-CREATE TABLE IF NOT EXISTS "Z_3MEMORIESBEINGREPRESENTATIVEASSETS" (
-    Z_3REPRESENTATIVEASSETS INTEGER,
-    Z_44MEMORIESBEINGREPRESENTATIVEASSETS INTEGER,
-    PRIMARY KEY (
-        Z_3REPRESENTATIVEASSETS,
-        Z_44MEMORIESBEINGREPRESENTATIVEASSETS
-    )
-);
-
-CREATE TABLE IF NOT EXISTS "Z_3SUGGESTIONSBEINGKEYASSETS" (
-    Z_3KEYASSETS INTEGER,
-    Z_58SUGGESTIONSBEINGKEYASSETS INTEGER,
-    PRIMARY KEY (Z_3KEYASSETS, Z_58SUGGESTIONSBEINGKEYASSETS)
-);
-
-CREATE TABLE IF NOT EXISTS "Z_3SUGGESTIONSBEINGREPRESENTATIVEASSETS" (
-    Z_3REPRESENTATIVEASSETS1 INTEGER,
-    Z_58SUGGESTIONSBEINGREPRESENTATIVEASSETS INTEGER,
-    PRIMARY KEY (
-        Z_3REPRESENTATIVEASSETS1,
-        Z_58SUGGESTIONSBEINGREPRESENTATIVEASSETS
-    )
-);
-
-CREATE TABLE IF NOT EXISTS "Z_47INVALIDMERGECANDIDATES" (
-    Z_47INVALIDMERGECANDIDATES INTEGER,
+CREATE TABLE IF NOT EXISTS "Z_55MERGECANDIDATES" (
+    Z_55MERGECANDIDATES INTEGER,
      REFLEXIVE INTEGER,
-    PRIMARY KEY (Z_47INVALIDMERGECANDIDATES, REFLEXIVE)
+    PRIMARY KEY (Z_55MERGECANDIDATES, REFLEXIVE)
  );

-CREATE TABLE IF NOT EXISTS "Z_47MERGECANDIDATES" (
-    Z_47MERGECANDIDATES INTEGER,
+CREATE TABLE IF NOT EXISTS "Z_55MERGECANDIDATESWITHCONFIDENCE" (
+    Z_55MERGECANDIDATESWITHCONFIDENCE INTEGER,
      REFLEXIVE INTEGER,
-    PRIMARY KEY (Z_47MERGECANDIDATES, REFLEXIVE)
+    PRIMARY KEY (Z_55MERGECANDIDATESWITHCONFIDENCE, REFLEXIVE)
  );

  CREATE TABLE IF NOT EXISTS "Z_RT_Asset_boundedByRect_node"(nodeno INTEGER PRIMARY KEY, data);

      ZLASTVIEWEDDATE TIMESTAMP,
      ZSCENEANALYSISTIMESTAMP TIMESTAMP,
      ZACCESSIBILITYDESCRIPTION VARCHAR,
-    ZADJUSTEDFINGERPRINT VARCHAR,
+    ZADJUSTEDSTABLEHASH VARCHAR,
      ZDEFERREDPHOTOIDENTIFIER VARCHAR,
      ZEDITORBUNDLEID VARCHAR,
      ZEXIFTIMESTAMPSTRING VARCHAR,
      ZIMPORTSESSIONID VARCHAR,
      ZIMPORTEDBYBUNDLEIDENTIFIER VARCHAR,
      ZIMPORTEDBYDISPLAYNAME VARCHAR,
-    ZMASTERFINGERPRINT VARCHAR,
+    ZORIGINALSTABLEHASH VARCHAR,
      ZMEDIAMETADATATYPE VARCHAR,
      ZMONTAGE VARCHAR,
      ZORIGINALASSETSUUID VARCHAR,

      ZORIGINALHASH BLOB,
      ZPLACEANNOTATIONDATA BLOB,
      ZREVERSELOCATIONDATA BLOB,
-    ZSHIFTEDLOCATIONDATA BLOB
+    ZSHIFTEDLOCATIONDATA BLOB,
+    ZVIEWPRESENTATION INTEGER,
+    ZIMAGEEMBEDDINGVERSION INTEGER,
+    ZHASPEOPLESCENEMIDORGREATERCONFIDENCE INTEGER,
+    ZSLEETISREVERSIBLE INTEGER
  );

  CREATE TABLE ZALBUMLIST (

      Z_ENT INTEGER,
      Z_OPT INTEGER,
      ZACTIVELIBRARYSCOPEPARTICIPATIONSTATE INTEGER,
+    ZADJUSTMENTSSTATE INTEGER,
+    ZAVALANCHEKIND INTEGER,
      ZAVALANCHEPICKTYPE INTEGER,
      ZBUNDLESCOPE INTEGER,
      ZCAMERAPROCESSINGADJUSTMENTSTATE INTEGER,

      ZCLOUDLOCALSTATE INTEGER,
      ZCLOUDPLACEHOLDERKIND INTEGER,
      ZCOMPLETE INTEGER,
+    ZCURRENTSLEETCAST INTEGER,
      ZDEFERREDPROCESSINGNEEDED INTEGER,
      ZDEPTHTYPE INTEGER,
      ZDERIVEDCAMERACAPTUREDEVICE INTEGER,
      ZDUPLICATEASSETVISIBILITYSTATE INTEGER,
      ZFACEAREAPOINTS INTEGER,
      ZFAVORITE INTEGER,
-    ZHASADJUSTMENTS INTEGER,
      ZHDRTYPE INTEGER,
      ZHEIGHT INTEGER,
      ZHIDDEN INTEGER,
      ZHIGHFRAMERATESTATE INTEGER,
+    ZISDETECTEDSCREENSHOT INTEGER,
      ZISMAGICCARPET INTEGER,
+    ZISRECENTLYSAVED INTEGER,
      ZKIND INTEGER,
      ZKINDSUBTYPE INTEGER,
      ZLIBRARYSCOPESHARESTATE INTEGER,
-    ZMONOSKITYPE INTEGER,
      ZORIENTATION INTEGER,
      ZPACKEDACCEPTABLECROPRECT INTEGER,
      ZPACKEDBADGEATTRIBUTES INTEGER,

      ZPLAYBACKVARIATION INTEGER,
      ZSAVEDASSETTYPE INTEGER,
      ZSEARCHINDEXREBUILDSTATE INTEGER,
+    ZSPATIALTYPE INTEGER,
      ZSYNDICATIONSTATE INTEGER,
      ZTHUMBNAILINDEX INTEGER,
+    ZTRASHEDREASON INTEGER,
      ZTRASHEDSTATE INTEGER,
      ZVIDEOCPDURATIONVALUE INTEGER,
      ZVIDEOCPVISIBILITYSTATE INTEGER,

      ZWIDTH INTEGER,
      ZADDITIONALATTRIBUTES INTEGER,
      ZCLOUDFEEDASSETSENTRY INTEGER,
+    ZCOMPUTESYNCATTRIBUTES INTEGER,
      ZCOMPUTEDATTRIBUTES INTEGER,
      ZCONVERSATION INTEGER,
      ZDAYGROUPHIGHLIGHTBEINGASSETS INTEGER,

      ZDAYGROUPHIGHLIGHTBEINGKEYASSETPRIVATE INTEGER,
      ZDAYGROUPHIGHLIGHTBEINGKEYASSETSHARED INTEGER,
      ZDAYGROUPHIGHLIGHTBEINGSUMMARYASSETS INTEGER,
+    ZDAYHIGHLIGHTBEINGCOLLAGEASSETSMIXED INTEGER,
+    ZDAYHIGHLIGHTBEINGCOLLAGEASSETSPRIVATE INTEGER,
+    ZDAYHIGHLIGHTBEINGCOLLAGEASSETSSHARED INTEGER,
      ZDUPLICATEMETADATAMATCHINGALBUM INTEGER,
      ZDUPLICATEPERCEPTUALMATCHINGALBUM INTEGER,
      ZEXTENDEDATTRIBUTES INTEGER,
+    ZGENERATEDASSETDESCRIPTION INTEGER,
      ZHIGHLIGHTBEINGASSETS INTEGER,
      ZHIGHLIGHTBEINGEXTENDEDASSETS INTEGER,
      ZHIGHLIGHTBEINGKEYASSETPRIVATE INTEGER,

      ZYEARHIGHLIGHTBEINGKEYASSETPRIVATE INTEGER,
      ZYEARHIGHLIGHTBEINGKEYASSETSHARED INTEGER,
      Z_FOK_CLOUDFEEDASSETSENTRY INTEGER,
+    Z_FOK_DAYHIGHLIGHTBEINGCOLLAGEASSETSPRIVATE INTEGER,
+    Z_FOK_DAYHIGHLIGHTBEINGCOLLAGEASSETSMIXED INTEGER,
+    Z_FOK_DAYHIGHLIGHTBEINGCOLLAGEASSETSSHARED INTEGER,
      ZADDEDDATE TIMESTAMP,
      ZADJUSTMENTTIMESTAMP TIMESTAMP,
      ZANALYSISSTATEMODIFICATIONDATE TIMESTAMP,

      ZFACEADJUSTMENTVERSION TIMESTAMP,
      ZHDRGAIN FLOAT,
      ZHIGHLIGHTVISIBILITYSCORE FLOAT,
+    ZICONICSCORE FLOAT,
      ZLASTSHAREDDATE TIMESTAMP,
      ZLATITUDE FLOAT,
      ZLONGITUDE FLOAT,

      ZOVERALLAESTHETICSCORE FLOAT,
      ZPROMOTIONSCORE FLOAT,
      ZSORTTOKEN FLOAT,
+    ZSTICKERCONFIDENCESCORE FLOAT,
      ZTRASHEDDATE TIMESTAMP,
      ZAVALANCHEUUID VARCHAR,
+    ZCAPTURESESSIONIDENTIFIER VARCHAR,
      ZCLOUDASSETGUID VARCHAR,
      ZCLOUDBATCHID VARCHAR,
      ZCLOUDCOLLECTIONGUID VARCHAR,

      ZUNIFORMTYPEIDENTIFIER VARCHAR,
      ZUUID VARCHAR,
      ZIMAGEREQUESTHINTS BLOB,
-    ZLOCATIONDATA BLOB,
-    ZICONICSCORE FLOAT,
-    ZTRASHEDREASON INTEGER
+    ZLOCATIONDATA BLOB
  );

  CREATE TABLE ZASSETANALYSISSTATE (

      Z_OPT INTEGER,
      ZASSETATTRIBUTES INTEGER,
      ZLONGDESCRIPTION VARCHAR
+);
+
+CREATE TABLE ZBACKGROUNDJOBWORKITEM (
+    Z_PK INTEGER PRIMARY KEY,
+    Z_ENT INTEGER,
+    Z_OPT INTEGER,
+    ZJOBFLAGS INTEGER,
+    ZJOBTYPE INTEGER,
+    ZDELAYUNTILDATE TIMESTAMP,
+    ZTIMESTAMP TIMESTAMP,
+    ZIDENTIFIER VARCHAR
  );

  CREATE TABLE ZCHARACTERRECOGNITIONATTRIBUTES (

      ZENTRYDATE TIMESTAMP,
      ZENTRYALBUMGUID VARCHAR,
      ZENTRYINVITATIONRECORDGUID VARCHAR,
-    ZENTRYCLOUDASSETGUID VARCHAR
+    ZENTRYCLOUDASSETGUID VARCHAR,
+    ZENTRYISMINE INTEGER
  );

  CREATE TABLE ZCLOUDMASTER (

      ZCLOUDMASTERGUID VARCHAR,
      ZCODECNAME VARCHAR,
      ZIMPORTSESSIONID VARCHAR,
+    ZIMPORTEDBYBUNDLEIDENTIFIER VARCHAR,
+    ZIMPORTEDBYDISPLAYNAME VARCHAR,
      ZMEDIAMETADATATYPE VARCHAR,
      ZORIGINALFILENAME VARCHAR,
      ZORIGINATINGASSETIDENTIFIER VARCHAR,
-    ZUNIFORMTYPEIDENTIFIER VARCHAR,
-    ZIMPORTEDBYDISPLAYNAME VARCHAR,
-    ZIMPORTEDBYBUNDLEIDENTIFIER VARCHAR,
+    ZSOURCEMASTERFORDUPLICATIONIDENTIFIER VARCHAR,
      ZSOURCEMASTERFORDUPLICATIONSCOPEIDENTIFIER VARCHAR,
-    ZSOURCEMASTERFORDUPLICATIONIDENTIFIER VARCHAR
+    ZUNIFORMTYPEIDENTIFIER VARCHAR
  );

  CREATE TABLE ZCLOUDMASTERMEDIAMETADATA (

      ZWELLCHOSENSUBJECTSCORE FLOAT,
      ZWELLFRAMEDSUBJECTSCORE FLOAT,
      ZWELLTIMEDSHOTSCORE FLOAT
+);
+
+CREATE TABLE ZCOMPUTESYNCATTRIBUTES (
+    Z_PK INTEGER PRIMARY KEY,
+    Z_ENT INTEGER,
+    Z_OPT INTEGER,
+    ZLOCALANALYSISMAJORVERSION INTEGER,
+    ZLOCALANALYSISSTAGE INTEGER,
+    ZASSET INTEGER,
+    ZCLOUDCOMPUTESTATELASTUPDATEDDATE TIMESTAMP,
+    ZCLOUDCOMPUTESTATEADJUSTMENTFINGERPRINT VARCHAR,
+    ZCLOUDCOMPUTESTATEVERSION VARCHAR
  );

  CREATE TABLE ZDEFERREDREBUILDFACE (

      ZSOURCEWIDTH INTEGER,
      ZTRAININGTYPE INTEGER,
      ZVIPMODELTYPE INTEGER,
+    ZVUOBSERVATIONID INTEGER,
      ZASSETFORFACE INTEGER,
+    ZASSETFORTEMPORALDETECTEDFACES INTEGER,
+    ZASSETFORTORSO INTEGER,
      ZFACECROP INTEGER,
      ZFACEGROUP INTEGER,
      ZFACEGROUPBEINGKEYFACE INTEGER,
      ZFACEPRINT INTEGER,
-    ZPERSONFORFACE INTEGER,
      ZPERSONBEINGKEYFACE INTEGER,
+    ZPERSONFORFACE INTEGER,
+    ZPERSONFORTEMPORALDETECTEDFACES INTEGER,
+    ZPERSONFORTORSO INTEGER,
      ZADJUSTMENTVERSION TIMESTAMP,
      ZBLURSCORE FLOAT,
      ZBODYCENTERX FLOAT,

      ZBODYWIDTH FLOAT,
      ZCENTERX FLOAT,
      ZCENTERY FLOAT,
+    ZDURATION FLOAT,
+    ZGAZEANGLE FLOAT,
      ZGAZECENTERX FLOAT,
      ZGAZECENTERY FLOAT,
+    ZGAZECONFIDENCE FLOAT,
      ZPOSEYAW FLOAT,
      ZQUALITY FLOAT,
      ZROLL FLOAT,
      ZSIZE FLOAT,
+    ZSTARTTIME FLOAT,
+    ZGAZERECTSTRING VARCHAR,
      ZGROUPINGIDENTIFIER VARCHAR,
      ZMASTERIDENTIFIER VARCHAR,
-    ZUUID VARCHAR,
-    ZASSETFORTEMPORALDETECTEDFACES INTEGER,
-    ZSTARTTIME FLOAT,
-    ZGAZEANGLE FLOAT,
-    ZVUOBSERVATIONID INTEGER,
-    ZGAZECONFIDENCE FLOAT,
-    ZASSETFORTORSO INTEGER,
-    ZGAZERECTSTRING VARCHAR,
-    ZPERSONFORTORSO INTEGER,
-    ZPERSONFORTEMPORALDETECTEDFACES INTEGER,
-    ZDURATION FLOAT
+    ZUUID VARCHAR
  );

  CREATE TABLE ZDETECTEDFACEGROUP (

      ZURGENCY VARCHAR,
      ZUSAGETERMS VARCHAR,
      ZWRITEREDITOR VARCHAR,
-    ZDATA BLOB
+    ZDATA BLOB,
+    ZDIGITALSOURCETYPE VARCHAR
  );

  CREATE TABLE ZEXTENDEDATTRIBUTES (

      Z_ENT INTEGER,
      Z_OPT INTEGER,
      ZFLASHFIRED INTEGER,
+    ZFOCALLENGTHIN35MM INTEGER,
      ZISO INTEGER,
      ZMETERINGMODE INTEGER,
+    ZORIENTATION INTEGER,
      ZSAMPLERATE INTEGER,
+    ZSLUSHPRESET INTEGER,
+    ZSLUSHVERSION INTEGER,
+    ZTIMEZONEOFFSET INTEGER,
      ZTRACKFORMAT INTEGER,
      ZWHITEBALANCE INTEGER,
      ZASSET INTEGER,
      ZAPERTURE FLOAT,
      ZBITRATE FLOAT,
+    ZDATECREATED TIMESTAMP,
+    ZDIGITALZOOMRATIO FLOAT,
      ZDURATION FLOAT,
      ZEXPOSUREBIAS FLOAT,
      ZFOCALLENGTH FLOAT,

      ZLATITUDE FLOAT,
      ZLONGITUDE FLOAT,
      ZSHUTTERSPEED FLOAT,
+    ZSLUSHSCENEBIAS FLOAT,
+    ZSLUSHWARMTHBIAS FLOAT,
      ZCAMERAMAKE VARCHAR,
      ZCAMERAMODEL VARCHAR,
      ZCODEC VARCHAR,
      ZLENSMODEL VARCHAR,
-    ZSLUSHVERSION INTEGER,
-    ZSLUSHSCENEBIAS FLOAT,
-    ZSLUSHWARMTHBIAS FLOAT,
-    ZFOCALLENGTHIN35MM INTEGER,
-    ZDIGITALZOOMRATIO FLOAT,
-    ZSLUSHPRESET INTEGER,
-    ZTIMEZONEOFFSET INTEGER,
      ZTIMEZONENAME VARCHAR,
-    ZDATECREATED TIMESTAMP,
-    ZORIENTATION INTEGER
+    ZSLEETTONEBIAS FLOAT,
+    ZSLEETINTENSITY FLOAT,
+    ZSLEETCOLORBIAS FLOAT,
+    ZSLEETRENDERINGVERSION INTEGER,
+    ZGENERATIVEAITYPE INTEGER,
+    ZSLEETCAST INTEGER,
+    ZCREDIT VARCHAR
  );

  CREATE TABLE ZFACECROP (

      ZNAME VARCHAR,
      ZUUID VARCHAR,
      ZVOLUMEUUIDSTRING VARCHAR
+);
+
+CREATE TABLE ZGENERATEDASSETDESCRIPTION (
+    Z_PK INTEGER PRIMARY KEY,
+    Z_ENT INTEGER,
+    Z_OPT INTEGER,
+    ZANALYSISSOURCETYPE INTEGER,
+    ZANALYSISVERSION INTEGER,
+    ZASSET INTEGER,
+    ZANALYSISTIMESTAMP TIMESTAMP,
+    ZDESCRIPTIONTEXT VARCHAR
  );

  CREATE TABLE ZGENERICALBUM (

      ZKIND INTEGER,
      ZPENDINGITEMSCOUNT INTEGER,
      ZPENDINGITEMSTYPE INTEGER,
+    ZPRIVACYSTATE INTEGER,
      ZSYNCEVENTORDERKEY INTEGER,
      ZTRASHEDSTATE INTEGER,
      ZCUSTOMKEYASSET INTEGER,
-    ZKEYASSET INTEGER,
      ZPARENTFOLDER INTEGER,
-    ZSECONDARYKEYASSET INTEGER,
-    ZTERTIARYKEYASSET INTEGER,
+    ZSEARCHINDEXREBUILDSTATE INTEGER,
      ZCLOUDALBUMSUBTYPE INTEGER,
      ZCLOUDMULTIPLECONTRIBUTORSENABLED INTEGER,
      ZCLOUDMULTIPLECONTRIBUTORSENABLEDLOCAL INTEGER,

      ZHASUNSEENCONTENT INTEGER,
      ZISOWNED INTEGER,
      ZUNSEENASSETSCOUNT INTEGER,
+    ZDUPLICATETYPE INTEGER,
+    ZPROCESSINGVERSION INTEGER,
      ZKEYASSETFACEIDENTIFIER INTEGER,
      ZKEYASSETFACETHUMBNAILINDEX INTEGER,
      ZSYNDICATE INTEGER,
+    ZSEARCHINDEXREBUILDSTATE1 INTEGER,
      Z_FOK_PARENTFOLDER INTEGER,
      ZCREATIONDATE TIMESTAMP,
      ZENDDATE TIMESTAMP,

      ZCLOUDMETADATA BLOB,
      ZUSERQUERYDATA BLOB,
      ZPROJECTDATA BLOB,
-    ZCUSTOMQUERYPARAMETERS BLOB,
-    ZPRIVACYSTATE INTEGER,
-    ZDUPLICATETYPE INTEGER,
-    ZSEARCHINDEXREBUILDSTATE INTEGER,
-    ZSEARCHINDEXREBUILDSTATE1 INTEGER,
-    ZPROCESSINGVERSION INTEGER
+    ZCUSTOMQUERYPARAMETERS BLOB
  );

  CREATE TABLE ZGLOBALKEYVALUE (

      ZKEY VARCHAR,
      ZSTRINGVALUE VARCHAR,
      ZANYVALUE BLOB
+);
+
+CREATE TABLE ZGRAPHEDGE (
+    Z_PK INTEGER PRIMARY KEY,
+    Z_ENT INTEGER,
+    Z_OPT INTEGER,
+    ZPRIMARYLABEL INTEGER,
+    ZSOURCEASSET INTEGER,
+    ZSOURCEMOMENT INTEGER,
+    ZSOURCENODE INTEGER,
+    ZSOURCEPERSON INTEGER,
+    ZTARGETASSET INTEGER,
+    ZTARGETMOMENT INTEGER,
+    ZTARGETNODE INTEGER,
+    ZTARGETPERSON INTEGER
  );

+CREATE TABLE ZGRAPHEDGEVALUE (
+    Z_PK INTEGER PRIMARY KEY,
+    Z_ENT INTEGER,
+    Z_OPT INTEGER,
+    ZBOOLEANVALUE INTEGER,
+    ZINTVALUE INTEGER,
+    ZEDGE INTEGER,
+    ZDATEVALUE TIMESTAMP,
+    ZFLOATVALUE FLOAT,
+    ZSTRINGVALUE VARCHAR,
+    ZVALUENAME VARCHAR
+);
+
+CREATE TABLE ZGRAPHLABEL (
+    Z_PK INTEGER PRIMARY KEY,
+    Z_ENT INTEGER,
+    Z_OPT INTEGER,
+    ZCODE INTEGER
+);
+
+CREATE TABLE ZGRAPHNODE (
+    Z_PK INTEGER PRIMARY KEY,
+    Z_ENT INTEGER,
+    Z_OPT INTEGER,
+    ZCHANGEFLAG0 INTEGER,
+    ZCHANGEFLAG1 INTEGER,
+    ZCHANGEFLAG2 INTEGER,
+    ZCHANGEFLAG3 INTEGER,
+    ZCHANGEFLAG4 INTEGER,
+    ZCHANGEFLAG5 INTEGER,
+    ZCLOUDDELETESTATE INTEGER,
+    ZCLOUDLOCALSTATE INTEGER,
+    ZCPLCHANGEFLAG INTEGER,
+    ZPRIMARYLABELCODE INTEGER,
+    ZPRIMARYLABEL INTEGER,
+    ZUUID VARCHAR
+);
+
+CREATE TABLE ZGRAPHNODEVALUE (
+    Z_PK INTEGER PRIMARY KEY,
+    Z_ENT INTEGER,
+    Z_OPT INTEGER,
+    ZBOOLEANVALUE INTEGER,
+    ZINTVALUE INTEGER,
+    ZNODE INTEGER,
+    ZDATEVALUE TIMESTAMP,
+    ZFLOATVALUE FLOAT,
+    ZSTRINGVALUE VARCHAR,
+    ZVALUENAME VARCHAR
+);
+
  CREATE TABLE ZINTERNALRESOURCE (
      Z_PK INTEGER PRIMARY KEY,
      Z_ENT INTEGER,

      ZCODECFOURCHARCODENAME VARCHAR,
      ZCOMPACTUTI VARCHAR,
      ZFINGERPRINT VARCHAR,
-    ZDATASTOREKEYDATA BLOB
+    ZDATASTOREKEYDATA BLOB,
+    ZSTABLEHASH VARCHAR
  );

  CREATE TABLE ZKEYWORD (

      Z_PK INTEGER PRIMARY KEY,
      Z_ENT INTEGER,
      Z_OPT INTEGER,
+    ZANIMATEDSTICKERRANGEDURATIONTIMESCALE INTEGER,
+    ZANIMATEDSTICKERRANGEDURATIONVALUE INTEGER,
+    ZANIMATEDSTICKERRANGESTARTTIMESCALE INTEGER,
+    ZANIMATEDSTICKERRANGESTARTVALUE INTEGER,
      ZAUDIOCLASSIFICATION INTEGER,
      ZBESTVIDEORANGEDURATIONTIMESCALE INTEGER,
      ZBESTVIDEORANGEDURATIONVALUE INTEGER,

      ZFACECOUNT INTEGER,
      ZMEDIAANALYSISVERSION INTEGER,
      ZPACKEDBESTPLAYBACKRECT INTEGER,
+    ZPROBABLEROTATIONDIRECTION INTEGER,
+    ZSCREENTIMEDEVICEIMAGESENSITIVITY INTEGER,
+    ZSYNDICATIONPROCESSINGVALUE INTEGER,
+    ZSYNDICATIONPROCESSINGVERSION INTEGER,
+    ZVAANALYSISVERSION INTEGER,
      ZASSET INTEGER,
+    ZCHARACTERRECOGNITIONATTRIBUTES INTEGER,
+    ZVISUALSEARCHATTRIBUTES INTEGER,
      ZACTIVITYSCORE FLOAT,
+    ZAUDIOSCORE FLOAT,
      ZAUTOPLAYSUGGESTIONSCORE FLOAT,
      ZBLURRINESSSCORE FLOAT,
      ZEXPOSURESCORE FLOAT,
      ZMEDIAANALYSISTIMESTAMP TIMESTAMP,
-    ZVIDEOSCORE FLOAT,
-    ZSYNDICATIONPROCESSINGVALUE INTEGER,
-    ZSCREENTIMEDEVICEIMAGESENSITIVITY INTEGER,
-    ZCHARACTERRECOGNITIONATTRIBUTES INTEGER,
      ZPROBABLEROTATIONDIRECTIONCONFIDENCE FLOAT,
-    ZSYNDICATIONPROCESSINGVERSION INTEGER,
-    ZPROBABLEROTATIONDIRECTION INTEGER,
-    ZCOLORNORMALIZATIONDATA BLOB,
-    ZVISUALSEARCHATTRIBUTES INTEGER,
-    ZAUDIOSCORE FLOAT,
-    ZWALLPAPERSCORE FLOAT,
-    ZANIMATEDSTICKERRANGESTARTVALUE INTEGER,
-    ZANIMATEDSTICKERRANGEDURATIONVALUE INTEGER,
-    ZVAANALYSISVERSION INTEGER,
+    ZSETTLINGEFFECTSCORE FLOAT,
+    ZVAANALYSISTIMESTAMP TIMESTAMP,
+    ZVIDEOSCORE FLOAT,
      ZVIDEOSTICKERSUGGESTIONSCORE FLOAT,
-    ZANIMATEDSTICKERRANGEDURATIONTIMESCALE INTEGER,
-    ZANIMATEDSTICKERRANGESTARTTIMESCALE INTEGER,
-    ZSETTLINGEFFECTSCORE FLOAT,
-    ZVAANALYSISTIMESTAMP TIMESTAMP
+    ZWALLPAPERSCORE FLOAT,
+    ZCOLORNORMALIZATIONDATA BLOB,
+    ZMEDIAANALYSISIMAGEVERSION INTEGER,
+    ZIMAGECAPTIONVERSION INTEGER,
+    ZVIDEOCAPTIONVERSION INTEGER,
+    ZVALOCATIONANALYSISVERSION INTEGER
  );

  CREATE TABLE ZMEMORY (

      ZPHOTOSGRAPHVERSION INTEGER,
      ZPLAYCOUNT INTEGER,
      ZREJECTED INTEGER,
+    ZSEARCHINDEXREBUILDSTATE INTEGER,
      ZSHARECOUNT INTEGER,
+    ZSHARINGCOMPOSITION INTEGER,
      ZSTORYCOLORGRADEKIND INTEGER,
      ZSTORYSERIALIZEDTITLECATEGORY INTEGER,
      ZSUBCATEGORY INTEGER,

      ZBLACKLISTEDFEATURE BLOB,
      ZMOVIEDATA BLOB,
      ZPHOTOSGRAPHDATA BLOB,
-    ZSEARCHINDEXREBUILDSTATE INTEGER,
-    ZSHARINGCOMPOSITION INTEGER
+    ZSOURCEGENERATEDMEMORY INTEGER,
+    ZTARGETUSEREDITEDMEMORY INTEGER,
+    ZSTARTDATE TIMESTAMP,
+    ZENDDATE TIMESTAMP,
+    ZCREATIONTYPE INTEGER
  );

  CREATE TABLE ZMIGRATIONHISTORY (
      Z_PK INTEGER PRIMARY KEY,
      Z_ENT INTEGER,
      Z_OPT INTEGER,
+    ZCPLENABLED INTEGER,
      ZFORCEREBUILDREASON INTEGER,
      ZINDEX INTEGER,
      ZMIGRATIONTYPE INTEGER,
      ZMODELVERSION INTEGER,
      ZORIGIN INTEGER,
      ZSOURCEMODELVERSION INTEGER,
+    ZINITIALSYNCDATE TIMESTAMP,
      ZMIGRATIONDATE TIMESTAMP,
+    ZDEVICEUNIQUEID VARCHAR,
+    ZFRAMEWORKUUID VARCHAR,
+    ZHARDWAREMODEL VARCHAR,
      ZOSVERSION VARCHAR,
      ZSTOREUUID VARCHAR,
-    ZGLOBALKEYVALUES BLOB,
-    ZFRAMEWORKUUID VARCHAR
+    ZGLOBALKEYVALUES BLOB
  );

  CREATE TABLE ZMOMENT (

      Z_ENT INTEGER,
      Z_OPT INTEGER,
      ZCACHEDCOUNT INTEGER,
+    ZCACHEDCOUNTSHARED INTEGER,
      ZCACHEDPHOTOSCOUNT INTEGER,
      ZCACHEDVIDEOSCOUNT INTEGER,
      ZORIGINATORSTATE INTEGER,
      ZPROCESSEDLOCATION INTEGER,
+    ZSHARINGCOMPOSITION INTEGER,
      ZTIMEZONEOFFSET INTEGER,
      ZTRASHEDSTATE INTEGER,
      ZHIGHLIGHT INTEGER,

      ZSUBTITLE VARCHAR,
      ZTITLE VARCHAR,
      ZUUID VARCHAR,
-    ZLOCALIZEDLOCATIONNAMES BLOB,
-    ZCACHEDCOUNTSHARED INTEGER,
-    ZSHARINGCOMPOSITION INTEGER
+    ZLOCALIZEDLOCATIONNAMES BLOB
  );

  CREATE TABLE ZPERSON (

      Z_ENT INTEGER,
      Z_OPT INTEGER,
      ZAGETYPE INTEGER,
+    ZASSETSORTORDER INTEGER,
      ZCLOUDDELETESTATE INTEGER,
+    ZCLOUDDETECTIONTYPE INTEGER,
      ZCLOUDLOCALSTATE INTEGER,
      ZCLOUDVERIFIEDTYPE INTEGER,
      ZDETECTIONTYPE INTEGER,

      ZASSOCIATEDFACEGROUP INTEGER,
      ZKEYFACE INTEGER,
      ZMERGETARGETPERSON INTEGER,
+    ZSHAREPARTICIPANT INTEGER,
+    ZMERGECANDIDATECONFIDENCE FLOAT,
      ZDISPLAYNAME VARCHAR,
      ZFULLNAME VARCHAR,
+    ZMDID VARCHAR,
      ZPERSONUUID VARCHAR,
      ZPERSONURI VARCHAR,
      ZCONTACTMATCHINGDICTIONARY BLOB,
-    ZSHAREPARTICIPANT INTEGER,
-    ZMERGECANDIDATECONFIDENCE FLOAT,
-    ZMDID VARCHAR,
-    ZASSETSORTORDER INTEGER
+    ZISMECONFIDENCE FLOAT
  );

  CREATE TABLE ZPERSONREFERENCE (

      ZYEARKEYASSETPRIVATE INTEGER,
      ZYEARKEYASSETSHARED INTEGER,
      ZENDDATE TIMESTAMP,
+    ZLASTENRICHMENTDATE TIMESTAMP,
      ZPROMOTIONSCORE FLOAT,
      ZSTARTDATE TIMESTAMP,
      ZSUBTITLE VARCHAR,

      ZUUID VARCHAR,
      ZVERBOSESMARTDESCRIPTION VARCHAR,
      ZVERBOSESMARTDESCRIPTIONMIXED VARCHAR,
-    ZVERBOSESMARTDESCRIPTIONSHARED VARCHAR,
-    ZVERBOSESMARTDESCRIPTIONUSEREDITED VARCHAR,
-    ZCLOUDLOCALSTATE INTEGER,
-    ZADAPTIVEVISIBILITYSTATE INTEGER,
-    ZFAVORITE INTEGER,
-    ZADAPTIVEMERGEPOLICY INTEGER,
-    ZLASTENRICHMENTDATE TIMESTAMP,
-    ZADAPTIVEKEYASSETSHARED INTEGER,
-    ZADAPTIVEKEYASSETSHAREDUSEREDITED INTEGER,
-    ZADAPTIVEKEYASSETPRIVATE INTEGER,
-    ZCLOUDDELETESTATE INTEGER,
-    ZADAPTIVEKEYASSETPRIVATEUSEREDITED INTEGER
+    ZVERBOSESMARTDESCRIPTIONSHARED VARCHAR
  );

  CREATE TABLE ZQUESTION (

      Z_OPT INTEGER,
      ZDISPLAYTYPE INTEGER,
      ZENTITYTYPE INTEGER,
+    ZQUESTIONVERSION INTEGER,
      ZSTATE INTEGER,
      ZTYPE INTEGER,
      ZCREATIONDATE TIMESTAMP,
      ZSCORE FLOAT,
      ZENTITYIDENTIFIER VARCHAR,
      ZUUID VARCHAR,
-    ZADDITIONALINFO BLOB,
-    ZQUESTIONVERSION INTEGER
+    ZADDITIONALINFO BLOB
  );

  CREATE TABLE ZSCENECLASSIFICATION (
      Z_PK INTEGER PRIMARY KEY,
      Z_ENT INTEGER,
      Z_OPT INTEGER,
+    ZCLASSIFICATIONTYPE INTEGER,
+    ZPACKEDBOUNDINGBOXRECT INTEGER,
      ZSCENEIDENTIFIER INTEGER,
      ZASSETATTRIBUTES INTEGER,
+    ZASSETATTRIBUTESFORTEMPORALSCENECLASSIFICATIONS INTEGER,
      ZCONFIDENCE FLOAT,
-    ZPACKEDBOUNDINGBOXRECT INTEGER,
      ZDURATION FLOAT,
-    ZASSETATTRIBUTESFORTEMPORALSCENECLASSIFICATIONS INTEGER,
-    ZSTARTTIME FLOAT,
-    ZCLASSIFICATIONTYPE INTEGER
+    ZSTARTTIME FLOAT
  );

  CREATE TABLE ZSCENEPRINT (

      ZCLOUDLOCALSTATE INTEGER,
      ZCLOUDPHOTOCOUNT INTEGER,
      ZCLOUDVIDEOCOUNT INTEGER,
+    ZCOUNTOFASSETSADDEDBYCAMERASMARTSHARING INTEGER,
+    ZEXITSOURCE INTEGER,
      ZEXITSTATE INTEGER,
+    ZEXITTYPE INTEGER,
      ZPARTICIPANTCLOUDUPDATESTATE INTEGER,
      ZPREVIEWSTATE INTEGER,
      ZSCOPESYNCINGSTATE INTEGER,

      ZSHAREURL VARCHAR,
      ZRULESDATA BLOB,
      ZPREVIEWDATA BLOB,
-    ZTHUMBNAILIMAGEDATA BLOB,
-    ZEXITSOURCE INTEGER,
-    ZCOUNTOFASSETSADDEDBYCAMERASMARTSHARING INTEGER,
-    ZEXITTYPE INTEGER
+    ZTHUMBNAILIMAGEDATA BLOB
  );

  CREATE TABLE ZSHAREPARTICIPANT (

      ZROLE INTEGER,
      ZPERSON INTEGER,
      ZSHARE INTEGER,
-    Z54_SHARE INTEGER,
+    Z62_SHARE INTEGER,
      ZEMAILADDRESS VARCHAR,
      ZPARTICIPANTID VARCHAR,
      ZPHONENUMBER VARCHAR,

      Z_PK INTEGER PRIMARY KEY,
      Z_ENT INTEGER,
      Z_OPT INTEGER,
+    ZAVAILABLEFEATURES INTEGER,
      ZCACHEDCOUNT INTEGER,
      ZCACHEDPHOTOSCOUNT INTEGER,
      ZCACHEDVIDEOSCOUNT INTEGER,
      ZCLOUDDELETESTATE INTEGER,
      ZCLOUDLOCALSTATE INTEGER,
+    ZFEATUREDSTATE INTEGER,
      ZNOTIFICATIONSTATE INTEGER,
+    ZSHARINGCOMPOSITION INTEGER,
      ZSTATE INTEGER,
      ZSUBTYPE INTEGER,
      ZTYPE INTEGER,

      ZRELEVANTUNTILDATE TIMESTAMP,
      ZSTARTDATE TIMESTAMP,
      ZSUBTITLE VARCHAR,
+    ZSUGGESTIONCONTEXT VARCHAR,
      ZTITLE VARCHAR,
      ZUUID VARCHAR,
      ZACTIONDATA BLOB,
      ZFEATURESDATA BLOB,
-    ZFEATUREDSTATE INTEGER,
-    ZSUGGESTIONCONTEXT VARCHAR,
-    ZSHARINGCOMPOSITION INTEGER,
-    ZAVAILABLEFEATURES INTEGER
+    ZRELATEDCOLLECTIONUUID VARCHAR,
+    ZRESTORETYPE INTEGER
  );

  CREATE TABLE ZUNMANAGEDADJUSTMENT (

      Z_PK INTEGER PRIMARY KEY,
      Z_ENT INTEGER,
      Z_OPT INTEGER,
+    ZCLOUDDELETESTATE INTEGER,
+    ZCLOUDLOCALSTATE INTEGER,
+    ZCREATIONTYPE INTEGER,
      ZFEATURE INTEGER,
      ZTYPE INTEGER,
      ZMEMORY INTEGER,
      ZPERSON INTEGER,
      ZLASTMODIFIEDDATE TIMESTAMP,
      ZCONTEXT VARCHAR,
-    ZCLOUDDELETESTATE INTEGER,
-    ZCLOUDLOCALSTATE INTEGER,
-    ZUUID VARCHAR,
-    ZCREATIONTYPE INTEGER
+    ZUUID VARCHAR
  );

  CREATE TABLE ZVISUALSEARCHATTRIBUTES (

      Z_ENT INTEGER,
      Z_OPT INTEGER,
      ZALGORITHMVERSION INTEGER,
+    ZSTICKERCONFIDENCEALGORITHMVERSION INTEGER,
      ZMEDIAANALYSISASSETATTRIBUTES INTEGER,
      ZADJUSTMENTVERSION TIMESTAMP,
-    ZVISUALSEARCHDATA BLOB,
      ZSTICKERCONFIDENCESCORE FLOAT,
-    ZSTICKERCONFIDENCEALGORITHMVERSION INTEGER
+    ZVISUALSEARCHDATA BLOB
  );

  CREATE TABLE Z_1KEYWORDS (
      Z_1ASSETATTRIBUTES INTEGER,
-    Z_40KEYWORDS INTEGER,
-    PRIMARY KEY (Z_1ASSETATTRIBUTES, Z_40KEYWORDS)
+    Z_48KEYWORDS INTEGER,
+    PRIMARY KEY (Z_1ASSETATTRIBUTES, Z_48KEYWORDS)
  );

-CREATE TABLE Z_3HIGHLIGHTSBEINGADAPTIVEASSETS (
-    Z_3ADAPTIVEASSETS INTEGER,
-    Z_50HIGHLIGHTSBEINGADAPTIVEASSETS INTEGER,
-    PRIMARY KEY (
-        Z_3ADAPTIVEASSETS,
-        Z_50HIGHLIGHTSBEINGADAPTIVEASSETS
-    )
+CREATE TABLE Z_30KEYASSETS (
+    Z_30ALBUMSBEINGKEYASSETS INTEGER,
+    Z_3KEYASSETS INTEGER,
+    Z_FOK_3KEYASSETS INTEGER,
+    PRIMARY KEY (Z_30ALBUMSBEINGKEYASSETS, Z_3KEYASSETS)
  );

-CREATE TABLE Z_3HIGHLIGHTSBEINGADAPTIVEEXPLICITLYADDEDASSETS (
-    Z_3ADAPTIVEEXPLICITLYADDEDASSETS INTEGER,
-    Z_50HIGHLIGHTSBEINGADAPTIVEEXPLICITLYADDEDASSETS INTEGER,
-    PRIMARY KEY (
-        Z_3ADAPTIVEEXPLICITLYADDEDASSETS,
-        Z_50HIGHLIGHTSBEINGADAPTIVEEXPLICITLYADDEDASSETS
-    )
+CREATE TABLE Z_3MEMORIESBEINGCURATEDASSETS (
+    Z_3CURATEDASSETS INTEGER,
+    Z_52MEMORIESBEINGCURATEDASSETS INTEGER,
+    PRIMARY KEY (Z_3CURATEDASSETS, Z_52MEMORIESBEINGCURATEDASSETS)
  );

-CREATE TABLE Z_3HIGHLIGHTSBEINGADAPTIVEEXPLICITLYREMOVEDASSETS (
-    Z_3ADAPTIVEEXPLICITLYREMOVEDASSETS INTEGER,
-    Z_50HIGHLIGHTSBEINGADAPTIVEEXPLICITLYREMOVEDASSETS INTEGER,
+CREATE TABLE Z_3MEMORIESBEINGCUSTOMUSERASSETS (
+    Z_3CUSTOMUSERASSETS INTEGER,
+    Z_52MEMORIESBEINGCUSTOMUSERASSETS INTEGER,
+    Z_FOK_3CUSTOMUSERASSETS INTEGER,
      PRIMARY KEY (
-        Z_3ADAPTIVEEXPLICITLYREMOVEDASSETS,
-        Z_50HIGHLIGHTSBEINGADAPTIVEEXPLICITLYREMOVEDASSETS
+        Z_3CUSTOMUSERASSETS,
+        Z_52MEMORIESBEINGCUSTOMUSERASSETS
      )
  );

-CREATE TABLE Z_3HIGHLIGHTSBEINGADAPTIVEEXTENDEDASSETS (
-    Z_3ADAPTIVEEXTENDEDASSETS INTEGER,
-    Z_50HIGHLIGHTSBEINGADAPTIVEEXTENDEDASSETS INTEGER,
+CREATE TABLE Z_3MEMORIESBEINGEXTENDEDCURATEDASSETS (
+    Z_3EXTENDEDCURATEDASSETS INTEGER,
+    Z_52MEMORIESBEINGEXTENDEDCURATEDASSETS INTEGER,
      PRIMARY KEY (
-        Z_3ADAPTIVEEXTENDEDASSETS,
-        Z_50HIGHLIGHTSBEINGADAPTIVEEXTENDEDASSETS
+        Z_3EXTENDEDCURATEDASSETS,
+        Z_52MEMORIESBEINGEXTENDEDCURATEDASSETS
      )
  );

-CREATE TABLE Z_3HIGHLIGHTSBEINGADAPTIVESUMMARYASSETS (
-    Z_3ADAPTIVESUMMARYASSETS INTEGER,
-    Z_50HIGHLIGHTSBEINGADAPTIVESUMMARYASSETS INTEGER,
+CREATE TABLE Z_3MEMORIESBEINGMOVIECURATEDASSETS (
+    Z_3MOVIECURATEDASSETS INTEGER,
+    Z_52MEMORIESBEINGMOVIECURATEDASSETS INTEGER,
      PRIMARY KEY (
-        Z_3ADAPTIVESUMMARYASSETS,
-        Z_50HIGHLIGHTSBEINGADAPTIVESUMMARYASSETS
+        Z_3MOVIECURATEDASSETS,
+        Z_52MEMORIESBEINGMOVIECURATEDASSETS
      )
  );

-CREATE TABLE Z_3MEMORIESBEINGCUSTOMUSERASSETS (
-    Z_3CUSTOMUSERASSETS INTEGER,
-    Z_44MEMORIESBEINGCUSTOMUSERASSETS INTEGER,
-    Z_FOK_3CUSTOMUSERASSETS INTEGER,
+CREATE TABLE Z_3MEMORIESBEINGREPRESENTATIVEASSETS (
+    Z_3REPRESENTATIVEASSETS1 INTEGER,
+    Z_52MEMORIESBEINGREPRESENTATIVEASSETS INTEGER,
      PRIMARY KEY (
-        Z_3CUSTOMUSERASSETS,
-        Z_44MEMORIESBEINGCUSTOMUSERASSETS
+        Z_3REPRESENTATIVEASSETS1,
+        Z_52MEMORIESBEINGREPRESENTATIVEASSETS
      )
  );

  CREATE TABLE Z_3MEMORIESBEINGUSERCURATEDASSETS (
      Z_3USERCURATEDASSETS INTEGER,
-    Z_44MEMORIESBEINGUSERCURATEDASSETS INTEGER,
+    Z_52MEMORIESBEINGUSERCURATEDASSETS INTEGER,
      PRIMARY KEY (
          Z_3USERCURATEDASSETS,
-        Z_44MEMORIESBEINGUSERCURATEDASSETS
+        Z_52MEMORIESBEINGUSERCURATEDASSETS
      )
  );

-CREATE TABLE Z_47MERGECANDIDATESWITHCONFIDENCE (
-    Z_47MERGECANDIDATESWITHCONFIDENCE INTEGER,
-    REFLEXIVE INTEGER,
-    PRIMARY KEY (Z_47MERGECANDIDATESWITHCONFIDENCE, REFLEXIVE)
+CREATE TABLE Z_3MEMORIESBEINGUSERREMOVEDASSETS (
+    Z_3USERREMOVEDASSETS INTEGER,
+    Z_52MEMORIESBEINGUSERREMOVEDASSETS INTEGER,
+    PRIMARY KEY (
+        Z_3USERREMOVEDASSETS,
+        Z_52MEMORIESBEINGUSERREMOVEDASSETS
+    )
  );

+CREATE TABLE Z_3SUGGESTIONSBEINGKEYASSETS (
+    Z_3KEYASSETS1 INTEGER,
+    Z_66SUGGESTIONSBEINGKEYASSETS INTEGER,
+    PRIMARY KEY (Z_3KEYASSETS1, Z_66SUGGESTIONSBEINGKEYASSETS)
+);
+
+CREATE TABLE Z_3SUGGESTIONSBEINGREPRESENTATIVEASSETS (
+    Z_3REPRESENTATIVEASSETS INTEGER,
+    Z_66SUGGESTIONSBEINGREPRESENTATIVEASSETS INTEGER,
+    PRIMARY KEY (
+        Z_3REPRESENTATIVEASSETS,
+        Z_66SUGGESTIONSBEINGREPRESENTATIVEASSETS
+    )
+);
+
+CREATE TABLE Z_42LABELS (
+    Z_42EDGES INTEGER,
+    Z_44LABELS INTEGER,
+    PRIMARY KEY (Z_42EDGES, Z_44LABELS)
+);
+
+CREATE TABLE Z_44NODESBEINGADDITIONALLABEL (
+    Z_44ADDITIONALLABELS INTEGER,
+    Z_45NODESBEINGADDITIONALLABEL INTEGER,
+    PRIMARY KEY (
+        Z_44ADDITIONALLABELS,
+        Z_45NODESBEINGADDITIONALLABEL
+    )
+);
+
  CREATE TABLE Z_METADATA (
      Z_VERSION INTEGER PRIMARY KEY,
      Z_UUID VARCHAR(255),


  END;

-CREATE TRIGGER Z_RT_Asset_boundedByRect_DELETE
+CREATE TRIGGER Z_DA_ZGRAPHLABEL_GraphNode_primaryLabelCode_PARAMETER_INSERT
  AFTER
-    DELETE ON ZASSET FOR EACH ROW BEGIN
-DELETE FROM
-    Z_RT_Asset_boundedByRect
+INSERT
+    ON ZGRAPHLABEL FOR EACH ROW BEGIN
+UPDATE
+    ZGRAPHNODE
+SET
+    ZPRIMARYLABELCODE = NEW.ZCODE
+WHERE
+    ZPRIMARYLABEL = NEW.Z_PK;
+
+SELECT
+    NSCoreDataDATriggerInsertUpdatedAffectedObjectValue(
+        'ZGRAPHNODE',
+        Z_ENT,
+        Z_PK,
+        'primaryLabelCode',
+        ZPRIMARYLABELCODE
+    )
+FROM
+    ZGRAPHNODE
  WHERE
-    Z_PK = OLD.Z_PK;
+    ZPRIMARYLABEL = NEW.Z_PK;

  END;

-CREATE TRIGGER Z_RT_Asset_boundedByRect_INSERT
+CREATE TRIGGER Z_DA_ZGRAPHLABEL_GraphNode_primaryLabelCode_PARAMETER_UPDATE
  AFTER
+UPDATE
+    OF ZCODE ON ZGRAPHLABEL FOR EACH ROW BEGIN
+UPDATE
+    ZGRAPHNODE
+SET
+    ZPRIMARYLABELCODE = NEW.ZCODE
+WHERE
+    ZPRIMARYLABEL = NEW.Z_PK;
+
+SELECT
+    NSCoreDataDATriggerUpdatedAffectedObjectValue(
+        'ZGRAPHNODE',
+        Z_ENT,
+        Z_PK,
+        'primaryLabelCode',
+        ZPRIMARYLABELCODE
+    )
+FROM
+    ZGRAPHNODE
+WHERE
+    ZPRIMARYLABEL = NEW.Z_PK;
+
+END;
+
+CREATE TRIGGER Z_DA_ZGRAPHNODE_GraphNode_primaryLabelCode_SOURCE_INSERT
+AFTER
  INSERT
-    ON ZASSET FOR EACH ROW BEGIN
-INSERT
-    OR REPLACE INTO Z_RT_Asset_boundedByRect (
+    ON ZGRAPHNODE FOR EACH ROW BEGIN
+UPDATE
+    ZGRAPHNODE
+SET
+    ZPRIMARYLABELCODE = (
+        SELECT
+            ZCODE
+        FROM
+            ZGRAPHLABEL
+        WHERE
+            Z_PK = NEW.ZPRIMARYLABEL
+    )
+WHERE
+    Z_PK = NEW.Z_PK;
+
+SELECT
+    NSCoreDataDATriggerInsertUpdatedAffectedObjectValue(
+        'ZGRAPHNODE',
+        Z_ENT,
          Z_PK,
-        ZLATITUDE_MIN,
-        ZLATITUDE_MAX,
-        ZLONGITUDE_MIN,
-        ZLONGITUDE_MAX
+        'primaryLabelCode',
+        ZPRIMARYLABELCODE
      )
-VALUES
-    (
-        NEW.Z_PK,
-        NEW.ZLATITUDE,
-        NEW.ZLATITUDE,
-        NEW.ZLONGITUDE,
-        NEW.ZLONGITUDE
-    );
+FROM
+    ZGRAPHNODE
+WHERE
+    Z_PK = NEW.Z_PK;

  END;

-CREATE TRIGGER Z_RT_Asset_boundedByRect_UPDATE
+CREATE TRIGGER Z_DA_ZGRAPHNODE_GraphNode_primaryLabelCode_SOURCE_UPDATE
  AFTER
  UPDATE
-    ON ZASSET FOR EACH ROW BEGIN
-DELETE FROM
-    Z_RT_Asset_boundedByRect
+    OF ZPRIMARYLABEL ON ZGRAPHNODE FOR EACH ROW BEGIN
+UPDATE
+    ZGRAPHNODE
+SET
+    ZPRIMARYLABELCODE = (
+        SELECT
+            ZCODE
+        FROM
+            ZGRAPHLABEL
+        WHERE
+            Z_PK = NEW.ZPRIMARYLABEL
+    )
  WHERE
      Z_PK = NEW.Z_PK;

-INSERT INTO
-    Z_RT_Asset_boundedByRect (
+SELECT
+    NSCoreDataDATriggerUpdatedAffectedObjectValue(
+        'ZGRAPHNODE',
+        Z_ENT,
          Z_PK,
-        ZLATITUDE_MIN,
-        ZLATITUDE_MAX,
-        ZLONGITUDE_MIN,
-        ZLONGITUDE_MAX
+        'primaryLabelCode',
+        ZPRIMARYLABELCODE
      )
-VALUES
-    (
-        NEW.Z_PK,
-        NEW.ZLATITUDE,
-        NEW.ZLATITUDE,
-        NEW.ZLONGITUDE,
-        NEW.ZLONGITUDE
-    );
+FROM
+    ZGRAPHNODE
+WHERE
+    Z_PK = NEW.Z_PK;

  END;

  CREATE UNIQUE INDEX Z_GlobalKeyValue_UNIQUE_key ON ZGLOBALKEYVALUE (ZKEY COLLATE BINARY ASC);

+CREATE UNIQUE INDEX Z_GraphEdgeValue_UNIQUE_edge_valueName ON ZGRAPHEDGEVALUE (
+    ZEDGE COLLATE BINARY ASC,
+    ZVALUENAME COLLATE BINARY ASC
+);
+
+CREATE UNIQUE INDEX Z_GraphLabel_UNIQUE_code ON ZGRAPHLABEL (ZCODE COLLATE BINARY ASC);
+
+CREATE UNIQUE INDEX Z_GraphNodeValue_UNIQUE_node_valueName ON ZGRAPHNODEVALUE (
+    ZNODE COLLATE BINARY ASC,
+    ZVALUENAME COLLATE BINARY ASC
+);
+
  CREATE UNIQUE INDEX Z_InternalResource_UNIQUE_asset_resourceType_version_recipeID_compactUTI ON ZINTERNALRESOURCE (
      ZASSET COLLATE BINARY ASC,
      ZRESOURCETYPE COLLATE BINARY ASC,