Schema changes from Photos 5 to Photos 6
Rhet Turnbull edited this page Aug 10, 2020
·
1 revision
Following data from Photos Version 6.0 (300.8.140) on Big Sur version 11.0 Beta (20A5343j)
The biggest change appears to be that ZGENERICASSET renamed ZASSET. Some of the primary keys changed (e.g. ZASSET = 3 instead ZGENERICASSET = 34) which means some of the mappings for foreign key lookups need to change. The main tables used by osxphotos though don't have a lot of changes beyond renaming ZGENERICASSET which means porting the code to work with the new database won't be terribly hard.
Primary Key Changes from Photos 5 to Photos 6 (read as a diff: - == row deleted, + == row added)
| Z_ENT | Z_NAME |
|---|---|
| 1 | AdditionalAssetAttributes |
| -2 | Adjustment |
| -3 | AlbumList |
| +2 | AlbumList |
| +3 | Asset |
| 4 | AssetAnalysisState |
| 5 | AssetDescription |
| 6 | CloudFeedEntry |
| 7 | CloudFeedAssetsEntry |
| 8 | CloudFeedCommentsEntry |
| 9 | CloudMaster |
| 10 | CloudMasterMediaMetadata |
| 11 | CloudResource |
| 12 | CloudSharedAlbumInvitationRecord |
| 13 | CloudSharedComment |
| 14 | Codec |
| 15 | ComputedAssetAttributes |
| 16 | DeferredRebuildFace |
| 17 | DetectedFace |
| 18 | DetectedFaceGroup |
| 19 | DetectedFaceprint |
| 20 | EditedIPTCAttributes |
| 21 | ExtendedAttributes |
| 22 | FaceCrop |
| 23 | FileSystemBookmark |
| 24 | FileSystemVolume |
| 25 | GenericAlbum |
| 26 | Album |
| 27 | CloudSharedAlbum |
| 28 | LegacyFaceAlbum |
| 29 | PhotoStreamAlbum |
| 30 | ProjectAlbum |
| 31 | FetchingAlbum |
| 32 | Folder |
| 33 | ImportSession |
| -34 | GenericAsset |
| -35 | Asset |
| -36 | InternalResource |
| -37 | Keyword |
| -38 | LegacyFace |
| +34 | GlobalKeyValue |
| +35 | InternalResource |
| +36 | Keyword |
| +37 | LegacyFace |
| +38 | LimitedLibraryFetchFilter |
| 39 | MediaAnalysisAssetAttributes |
| 40 | Memory |
| -41 | Moment |
| -42 | MomentList |
| -43 | MomentShare |
| -44 | MomentShareParticipant |
| -45 | Person |
| -46 | PersonReference |
| -47 | PhotosHighlight |
| -48 | Question |
| -49 | SceneClassification |
| -50 | Sceneprint |
| -51 | SearchData |
| -52 | Suggestion |
| -53 | UniformTypeIdentifier |
| -54 | UnmanagedAdjustment |
| +41 | MigrationHistory |
| +42 | Moment |
| +43 | MomentList |
| +44 | Person |
| +45 | PersonReference |
| +46 | PhotosHighlight |
| +47 | Question |
| +48 | SceneClassification |
| +49 | Sceneprint |
| +50 | SearchData |
| +51 | Share |
| +52 | LibraryScope |
| +53 | MomentShare |
| +54 | ShareParticipant |
| +55 | Suggestion |
| +56 | UniformTypeIdentifier |
| +57 | UnmanagedAdjustment |
| 16001 | CHANGE |
| 16002 | TRANSACTION |
| 16003 | TRANSACTIONSTRING |
Schema Changes from Photos 5 to Photos 6
CREATE TABLE ACHANGE (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZCHANGETYPE INTEGER,
ZENTITY INTEGER,
ZENTITYPK INTEGER,
ZTRANSACTIONID INTEGER,
ZCOLUMNS BLOB,
ZTOMBSTONE0 BLOB,
ZTOMBSTONE1 BLOB,
ZTOMBSTONE2 BLOB,
ZTOMBSTONE3 BLOB
);
CREATE TABLE ATRANSACTION (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZAUTHORTS INTEGER,
ZBUNDLEIDTS INTEGER,
ZCONTEXTNAMETS INTEGER,
ZPROCESSIDTS INTEGER,
ZTIMESTAMP FLOAT,
ZAUTHOR VARCHAR,
ZBUNDLEID VARCHAR,
ZCONTEXTNAME VARCHAR,
ZPROCESSID VARCHAR,
ZQUERYGEN BLOB
);
CREATE TABLE ATRANSACTIONSTRING (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZNAME VARCHAR
);
-CREATE TABLE IF NOT EXISTS "Z_RT_GenericAsset_boundedByRect_node"(nodeno INTEGER PRIMARY KEY, data);
-
-CREATE TABLE IF NOT EXISTS "Z_RT_GenericAsset_boundedByRect_parent"(nodeno INTEGER PRIMARY KEY, parentnode);
-
-CREATE TABLE IF NOT EXISTS "Z_RT_GenericAsset_boundedByRect_rowid"(rowid INTEGER PRIMARY KEY, nodeno);
+CREATE TABLE IF NOT EXISTS "Z_3MEMORIESBEINGCURATEDASSETS" (
+ Z_3CURATEDASSETS INTEGER,
+ Z_40MEMORIESBEINGCURATEDASSETS INTEGER,
+ PRIMARY KEY (Z_3CURATEDASSETS, Z_40MEMORIESBEINGCURATEDASSETS)
+);
-CREATE TABLE Z_17CLUSTERREJECTEDPERSONS (
- Z_17CLUSTERREJECTEDFACES INTEGER,
- Z_45CLUSTERREJECTEDPERSONS INTEGER,
+CREATE TABLE IF NOT EXISTS "Z_3MEMORIESBEINGEXTENDEDCURATEDASSETS" (
+ Z_3EXTENDEDCURATEDASSETS INTEGER,
+ Z_40MEMORIESBEINGEXTENDEDCURATEDASSETS INTEGER,
PRIMARY KEY (
- Z_17CLUSTERREJECTEDFACES,
- Z_45CLUSTERREJECTEDPERSONS
+ Z_3EXTENDEDCURATEDASSETS,
+ Z_40MEMORIESBEINGEXTENDEDCURATEDASSETS
)
);
-CREATE TABLE Z_17REJECTEDPERSONS (
- Z_17REJECTEDFACES INTEGER,
- Z_45REJECTEDPERSONS INTEGER,
- PRIMARY KEY (Z_17REJECTEDFACES, Z_45REJECTEDPERSONS)
+CREATE TABLE IF NOT EXISTS "Z_3MEMORIESBEINGMOVIECURATEDASSETS" (
+ Z_3MOVIECURATEDASSETS INTEGER,
+ Z_40MEMORIESBEINGMOVIECURATEDASSETS INTEGER,
+ PRIMARY KEY (
+ Z_3MOVIECURATEDASSETS,
+ Z_40MEMORIESBEINGMOVIECURATEDASSETS
+ )
);
-CREATE TABLE Z_17REJECTEDPERSONSNEEDINGFACECROPS (
- Z_17REJECTEDFACESNEEDINGFACECROPS INTEGER,
- Z_45REJECTEDPERSONSNEEDINGFACECROPS INTEGER,
+CREATE TABLE IF NOT EXISTS "Z_3MEMORIESBEINGREPRESENTATIVEASSETS" (
+ Z_3REPRESENTATIVEASSETS INTEGER,
+ Z_40MEMORIESBEINGREPRESENTATIVEASSETS INTEGER,
PRIMARY KEY (
- Z_17REJECTEDFACESNEEDINGFACECROPS,
- Z_45REJECTEDPERSONSNEEDINGFACECROPS
+ Z_3REPRESENTATIVEASSETS,
+ Z_40MEMORIESBEINGREPRESENTATIVEASSETS
)
);
-CREATE TABLE Z_1KEYWORDS (
- Z_1ASSETATTRIBUTES INTEGER,
- Z_37KEYWORDS INTEGER,
- PRIMARY KEY (Z_1ASSETATTRIBUTES, Z_37KEYWORDS)
+CREATE TABLE IF NOT EXISTS "Z_3SUGGESTIONSBEINGKEYASSETS" (
+ Z_3KEYASSETS INTEGER,
+ Z_55SUGGESTIONSBEINGKEYASSETS INTEGER,
+ PRIMARY KEY (Z_3KEYASSETS, Z_55SUGGESTIONSBEINGKEYASSETS)
);
-CREATE TABLE Z_25ALBUMLISTS (
- Z_25ALBUMS INTEGER,
- Z_3ALBUMLISTS INTEGER,
- Z_FOK_25ALBUMS INTEGER,
- PRIMARY KEY (Z_25ALBUMS, Z_3ALBUMLISTS)
+CREATE TABLE IF NOT EXISTS "Z_3SUGGESTIONSBEINGREPRESENTATIVEASSETS" (
+ Z_3REPRESENTATIVEASSETS1 INTEGER,
+ Z_55SUGGESTIONSBEINGREPRESENTATIVEASSETS INTEGER,
+ PRIMARY KEY (
+ Z_3REPRESENTATIVEASSETS1,
+ Z_55SUGGESTIONSBEINGREPRESENTATIVEASSETS
+ )
);
-CREATE TABLE Z_26ASSETS (
- Z_26ALBUMS INTEGER,
- Z_34ASSETS INTEGER,
- Z_FOK_34ASSETS INTEGER,
- PRIMARY KEY (Z_26ALBUMS, Z_34ASSETS)
+CREATE TABLE IF NOT EXISTS "Z_44INVALIDMERGECANDIDATES" (
+ Z_44INVALIDMERGECANDIDATES INTEGER,
+ REFLEXIVE INTEGER,
+ PRIMARY KEY (Z_44INVALIDMERGECANDIDATES, REFLEXIVE)
);
-CREATE TABLE Z_34MEMORIESBEINGCURATEDASSETS (
- Z_34CURATEDASSETS INTEGER,
- Z_40MEMORIESBEINGCURATEDASSETS INTEGER,
- PRIMARY KEY (
- Z_34CURATEDASSETS,
- Z_40MEMORIESBEINGCURATEDASSETS
- )
+CREATE TABLE IF NOT EXISTS "Z_44MERGECANDIDATES" (
+ Z_44MERGECANDIDATES INTEGER,
+ REFLEXIVE INTEGER,
+ PRIMARY KEY (Z_44MERGECANDIDATES, REFLEXIVE)
);
-CREATE TABLE Z_34MEMORIESBEINGEXTENDEDCURATEDASSETS (
- Z_34EXTENDEDCURATEDASSETS INTEGER,
- Z_40MEMORIESBEINGEXTENDEDCURATEDASSETS INTEGER,
- PRIMARY KEY (
- Z_34EXTENDEDCURATEDASSETS,
- Z_40MEMORIESBEINGEXTENDEDCURATEDASSETS
- )
-);
+CREATE TABLE IF NOT EXISTS "Z_RT_Asset_boundedByRect_node"(nodeno INTEGER PRIMARY KEY, data);
-CREATE TABLE Z_34MEMORIESBEINGMOVIECURATEDASSETS (
- Z_34MOVIECURATEDASSETS INTEGER,
- Z_40MEMORIESBEINGMOVIECURATEDASSETS INTEGER,
- PRIMARY KEY (
- Z_34MOVIECURATEDASSETS,
- Z_40MEMORIESBEINGMOVIECURATEDASSETS
- )
+CREATE TABLE IF NOT EXISTS "Z_RT_Asset_boundedByRect_parent"(nodeno INTEGER PRIMARY KEY, parentnode);
+
+CREATE TABLE IF NOT EXISTS "Z_RT_Asset_boundedByRect_rowid"(rowid INTEGER PRIMARY KEY, nodeno);
+
+CREATE TABLE IF NOT EXISTS "ZSHAREPARTICIPANT" (
+ Z_PK INTEGER PRIMARY KEY,
+ Z_ENT INTEGER,
+ Z_OPT INTEGER,
+ ZACCEPTANCESTATUS INTEGER,
+ ZROLE INTEGER,
+ ZSHARE INTEGER,
+ ZEMAILADDRESS VARCHAR,
+ ZPHONENUMBER VARCHAR,
+ ZUSERIDENTIFIER VARCHAR,
+ ZUUID VARCHAR,
+ ZNAMECOMPONENTS BLOB,
+ Z51_SHARE INTEGER,
+ ZPERMISSION INTEGER,
+ ZISCURRENTUSER INTEGER
);
-CREATE TABLE Z_34MEMORIESBEINGREPRESENTATIVEASSETS (
- Z_34REPRESENTATIVEASSETS INTEGER,
- Z_40MEMORIESBEINGREPRESENTATIVEASSETS INTEGER,
+CREATE TABLE Z_17CLUSTERREJECTEDPERSONS (
+ Z_17CLUSTERREJECTEDFACES INTEGER,
+ Z_44CLUSTERREJECTEDPERSONS INTEGER,
PRIMARY KEY (
- Z_34REPRESENTATIVEASSETS,
- Z_40MEMORIESBEINGREPRESENTATIVEASSETS
+ Z_17CLUSTERREJECTEDFACES,
+ Z_44CLUSTERREJECTEDPERSONS
)
);
-CREATE TABLE Z_34SUGGESTIONSBEINGKEYASSETS (
- Z_34KEYASSETS INTEGER,
- Z_52SUGGESTIONSBEINGKEYASSETS INTEGER,
- PRIMARY KEY (Z_34KEYASSETS, Z_52SUGGESTIONSBEINGKEYASSETS)
+CREATE TABLE Z_17REJECTEDPERSONS (
+ Z_17REJECTEDFACES INTEGER,
+ Z_44REJECTEDPERSONS INTEGER,
+ PRIMARY KEY (Z_17REJECTEDFACES, Z_44REJECTEDPERSONS)
);
-CREATE TABLE Z_34SUGGESTIONSBEINGREPRESENTATIVEASSETS (
- Z_34REPRESENTATIVEASSETS1 INTEGER,
- Z_52SUGGESTIONSBEINGREPRESENTATIVEASSETS INTEGER,
+CREATE TABLE Z_17REJECTEDPERSONSNEEDINGFACECROPS (
+ Z_17REJECTEDFACESNEEDINGFACECROPS INTEGER,
+ Z_44REJECTEDPERSONSNEEDINGFACECROPS INTEGER,
PRIMARY KEY (
- Z_34REPRESENTATIVEASSETS1,
- Z_52SUGGESTIONSBEINGREPRESENTATIVEASSETS
+ Z_17REJECTEDFACESNEEDINGFACECROPS,
+ Z_44REJECTEDPERSONSNEEDINGFACECROPS
)
);
-CREATE TABLE Z_45INVALIDMERGECANDIDATES (
- Z_45INVALIDMERGECANDIDATES INTEGER,
- REFLEXIVE INTEGER,
- PRIMARY KEY (Z_45INVALIDMERGECANDIDATES, REFLEXIVE)
+CREATE TABLE Z_1KEYWORDS (
+ Z_1ASSETATTRIBUTES INTEGER,
+ Z_36KEYWORDS INTEGER,
+ PRIMARY KEY (Z_1ASSETATTRIBUTES, Z_36KEYWORDS)
);
-CREATE TABLE Z_45MERGECANDIDATES (
- Z_45MERGECANDIDATES INTEGER,
- REFLEXIVE INTEGER,
- PRIMARY KEY (Z_45MERGECANDIDATES, REFLEXIVE)
+CREATE TABLE Z_25ALBUMLISTS (
+ Z_25ALBUMS INTEGER,
+ Z_2ALBUMLISTS INTEGER,
+ Z_FOK_25ALBUMS INTEGER,
+ PRIMARY KEY (Z_25ALBUMS, Z_2ALBUMLISTS)
+);
+
+CREATE TABLE Z_26ASSETS (
+ Z_26ALBUMS INTEGER,
+ Z_3ASSETS INTEGER,
+ Z_FOK_3ASSETS INTEGER,
+ PRIMARY KEY (Z_26ALBUMS, Z_3ASSETS)
);
CREATE TABLE Z_METADATA (
Z_VERSION INTEGER PRIMARY KEY,
Z_UUID VARCHAR(255),
Z_PLIST BLOB
);
CREATE TABLE Z_MODELCACHE (Z_CONTENT BLOB);
CREATE TABLE Z_PRIMARYKEY (
Z_ENT INTEGER PRIMARY KEY,
Z_NAME VARCHAR,
Z_SUPER INTEGER,
Z_MAX INTEGER
);
CREATE TABLE ZADDITIONALASSETATTRIBUTES (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZALLOWEDFORANALYSIS INTEGER,
ZCAMERACAPTUREDEVICE INTEGER,
ZCLOUDAVALANCHEPICKTYPE INTEGER,
- ZCLOUDGROUPINGSTATE INTEGER,
ZCLOUDKINDSUBTYPE INTEGER,
ZCLOUDRECOVERYSTATE INTEGER,
ZCLOUDSTATERECOVERYATTEMPTSCOUNT INTEGER,
+ ZDEFERREDPROCESSINGCANDIDATEOPTIONS INTEGER,
ZDESTINATIONASSETCOPYSTATE INTEGER,
ZEMBEDDEDTHUMBNAILHEIGHT INTEGER,
ZEMBEDDEDTHUMBNAILLENGTH INTEGER,
ZEMBEDDEDTHUMBNAILOFFSET INTEGER,
ZEMBEDDEDTHUMBNAILWIDTH INTEGER,
ZIMPORTEDBY INTEGER,
ZINFERREDTIMEZONEOFFSET INTEGER,
ZLOCATIONHASH INTEGER,
ZORIGINALFILESIZE INTEGER,
ZORIGINALHEIGHT INTEGER,
ZORIGINALORIENTATION INTEGER,
ZORIGINALRESOURCECHOICE INTEGER,
ZORIGINALWIDTH INTEGER,
ZPENDINGPLAYCOUNT INTEGER,
ZPENDINGSHARECOUNT INTEGER,
ZPENDINGVIEWCOUNT INTEGER,
ZPLAYCOUNT INTEGER,
ZPTPTRASHEDSTATE INTEGER,
ZREVERSELOCATIONDATAISVALID INTEGER,
ZSCENEANALYSISVERSION INTEGER,
ZSHARECOUNT INTEGER,
ZSHARETYPE INTEGER,
ZSHIFTEDLOCATIONISVALID INTEGER,
ZTIMEZONEOFFSET INTEGER,
ZUPLOADATTEMPTS INTEGER,
ZVARIATIONSUGGESTIONSTATES INTEGER,
ZVIDEOCPDISPLAYTIMESCALE INTEGER,
ZVIDEOCPDISPLAYVALUE INTEGER,
ZVIDEOCPDURATIONTIMESCALE INTEGER,
ZVIEWCOUNT INTEGER,
ZASSET INTEGER,
- Z34_ASSET INTEGER,
ZASSETDESCRIPTION INTEGER,
ZEDITEDIPTCATTRIBUTES INTEGER,
ZMEDIAMETADATA INTEGER,
ZSCENEPRINT INTEGER,
ZUNMANAGEDADJUSTMENT INTEGER,
ZALTERNATEIMPORTIMAGEDATE TIMESTAMP,
+ ZGPSHORIZONTALACCURACY FLOAT,
ZLASTUPLOADATTEMPTDATE TIMESTAMP,
ZSCENEANALYSISTIMESTAMP TIMESTAMP,
+ ZACCESSIBILITYDESCRIPTION VARCHAR,
ZADJUSTEDFINGERPRINT VARCHAR,
ZCREATORBUNDLEID VARCHAR,
+ ZDEFERREDPHOTOIDENTIFIER VARCHAR,
ZEDITORBUNDLEID VARCHAR,
ZEXIFTIMESTAMPSTRING VARCHAR,
ZIMPORTSESSIONID VARCHAR,
ZMASTERFINGERPRINT VARCHAR,
ZMEDIAMETADATATYPE VARCHAR,
ZMONTAGE VARCHAR,
ZORIGINALASSETSUUID VARCHAR,
ZORIGINALFILENAME VARCHAR,
ZORIGINATINGASSETIDENTIFIER VARCHAR,
ZPHOTOSTREAMTAGID VARCHAR,
ZPUBLICGLOBALUUID VARCHAR,
ZSHAREORIGINATOR VARCHAR,
- ZSNOWDAYIDENTIFIER VARCHAR,
ZSNOWDAYSNOWPLOWIDENTIFIER VARCHAR,
- ZSNOWPLOWGROUPUUID VARCHAR,
+ ZSPATIALOVERCAPTUREGROUPIDENTIFIER VARCHAR,
ZTIMEZONENAME VARCHAR,
ZTITLE VARCHAR,
ZDISTANCEIDENTITY BLOB,
ZFACEREGIONS BLOB,
+ ZOBJECTSALIENCYRECTSDATA BLOB,
ZORIGINALHASH BLOB,
ZPLACEANNOTATIONDATA BLOB,
ZREVERSELOCATIONDATA BLOB,
ZSHIFTEDLOCATIONDATA BLOB
);
-CREATE TABLE ZADJUSTMENT (
- Z_PK INTEGER PRIMARY KEY,
- Z_ENT INTEGER,
- Z_OPT INTEGER,
- ZIDENTIFIER INTEGER,
- ZASSET INTEGER,
- Z34_ASSET INTEGER,
- Z_FOK_ASSET INTEGER,
- ZFILTERNAME VARCHAR,
- ZFILTERSETTINGS BLOB
-);
-
CREATE TABLE ZALBUMLIST (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZIDENTIFIER INTEGER,
ZNEEDSREORDERINGNUMBER INTEGER,
ZUUID VARCHAR
);
CREATE TABLE ZASSETANALYSISSTATE (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZANALYSISSTATE INTEGER,
ZWORKERFLAGS INTEGER,
ZWORKERTYPE INTEGER,
ZASSET INTEGER,
- Z34_ASSET INTEGER,
ZIGNOREUNTILDATE TIMESTAMP,
ZLASTIGNOREDDATE TIMESTAMP,
ZSORTTOKEN FLOAT,
ZASSETUUID VARCHAR
);
CREATE TABLE ZASSETDESCRIPTION (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZASSETATTRIBUTES INTEGER,
ZLONGDESCRIPTION VARCHAR
);
CREATE TABLE ZCLOUDFEEDENTRY (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZENTRYPRIORITYNUMBER INTEGER,
ZENTRYTYPENUMBER INTEGER,
ZENTRYDATE TIMESTAMP,
ZENTRYALBUMGUID VARCHAR,
ZENTRYINVITATIONRECORDGUID VARCHAR,
ZENTRYCLOUDASSETGUID VARCHAR
);
CREATE TABLE ZCLOUDMASTER (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZCLOUDLOCALSTATE INTEGER,
ZFULLSIZEJPEGSOURCE INTEGER,
ZIMPORTEDBY INTEGER,
ZORIGINALORIENTATION INTEGER,
ZPLACEHOLDERSTATE INTEGER,
ZVIDEOFRAMERATE INTEGER,
ZMEDIAMETADATA INTEGER,
ZMOMENTSHARE INTEGER,
ZCREATIONDATE TIMESTAMP,
ZIMPORTDATE TIMESTAMP,
ZCLOUDMASTERGUID VARCHAR,
ZCODECNAME VARCHAR,
ZIMPORTSESSIONID VARCHAR,
ZMEDIAMETADATATYPE VARCHAR,
ZORIGINALFILENAME VARCHAR,
ZORIGINATINGASSETIDENTIFIER VARCHAR,
ZUNIFORMTYPEIDENTIFIER VARCHAR
);
CREATE TABLE ZCLOUDMASTERMEDIAMETADATA (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZADDITIONALASSETATTRIBUTES INTEGER,
ZCLOUDMASTER INTEGER,
ZDATA BLOB
);
CREATE TABLE ZCLOUDRESOURCE (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZCLOUDLOCALSTATE INTEGER,
ZFILESIZE INTEGER,
ZHEIGHT INTEGER,
ZISAVAILABLE INTEGER,
ZISLOCALLYAVAILABLE INTEGER,
ZPREFETCHCOUNT INTEGER,
ZSOURCETYPE INTEGER,
ZTYPE INTEGER,
ZWIDTH INTEGER,
ZASSET INTEGER,
- Z34_ASSET INTEGER,
ZCLOUDMASTER INTEGER,
ZDATECREATED TIMESTAMP,
ZLASTONDEMANDDOWNLOADDATE TIMESTAMP,
ZLASTPREFETCHDATE TIMESTAMP,
ZPRUNEDAT TIMESTAMP,
ZASSETUUID VARCHAR,
ZFILEPATH VARCHAR,
ZFINGERPRINT VARCHAR,
ZITEMIDENTIFIER VARCHAR,
ZUNIFORMTYPEIDENTIFIER VARCHAR
);
CREATE TABLE ZCLOUDSHAREDALBUMINVITATIONRECORD (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZINVITATIONSTATE INTEGER,
ZINVITATIONSTATELOCAL INTEGER,
ZINVITEEEMAILKEY INTEGER,
ZISMINE INTEGER,
ZALBUM INTEGER,
Z_FOK_ALBUM INTEGER,
ZINVITEESUBSCRIPTIONDATE TIMESTAMP,
ZALBUMGUID VARCHAR,
ZCLOUDGUID VARCHAR,
ZINVITEEFIRSTNAME VARCHAR,
ZINVITEEFULLNAME VARCHAR,
ZINVITEEHASHEDPERSONID VARCHAR,
ZINVITEELASTNAME VARCHAR
);
CREATE TABLE ZCLOUDSHAREDCOMMENT (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZISBATCHCOMMENT INTEGER,
ZISCAPTION INTEGER,
ZISDELETABLE INTEGER,
ZISLIKE INTEGER,
ZISMYCOMMENT INTEGER,
ZCLOUDFEEDCOMMENTENTRY INTEGER,
ZCLOUDFEEDLIKECOMMENTENTRY INTEGER,
ZCOMMENTEDASSET INTEGER,
- Z34_COMMENTEDASSET INTEGER,
ZLIKEDASSET INTEGER,
- Z34_LIKEDASSET INTEGER,
- Z_FOK_LIKEDASSET INTEGER,
Z_FOK_CLOUDFEEDCOMMENTENTRY INTEGER,
- Z_FOK_COMMENTEDASSET INTEGER,
Z_FOK_CLOUDFEEDLIKECOMMENTENTRY INTEGER,
ZCOMMENTCLIENTDATE TIMESTAMP,
ZCOMMENTDATE TIMESTAMP,
ZCLOUDGUID VARCHAR,
ZCOMMENTTEXT VARCHAR,
ZCOMMENTTYPE VARCHAR,
ZCOMMENTERHASHEDPERSONID VARCHAR
);
CREATE TABLE ZCODEC (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZFOURCHARCODENAME VARCHAR
);
CREATE TABLE ZCOMPUTEDASSETATTRIBUTES (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZASSET INTEGER,
- Z34_ASSET INTEGER,
ZBEHAVIORALSCORE FLOAT,
ZFAILURESCORE FLOAT,
ZHARMONIOUSCOLORSCORE FLOAT,
ZIMMERSIVENESSSCORE FLOAT,
ZINTERACTIONSCORE FLOAT,
ZINTERESTINGSUBJECTSCORE FLOAT,
ZINTRUSIVEOBJECTPRESENCESCORE FLOAT,
ZLIVELYCOLORSCORE FLOAT,
ZLOWLIGHT FLOAT,
ZNOISESCORE FLOAT,
ZPLEASANTCAMERATILTSCORE FLOAT,
ZPLEASANTCOMPOSITIONSCORE FLOAT,
ZPLEASANTLIGHTINGSCORE FLOAT,
ZPLEASANTPATTERNSCORE FLOAT,
ZPLEASANTPERSPECTIVESCORE FLOAT,
ZPLEASANTPOSTPROCESSINGSCORE FLOAT,
ZPLEASANTREFLECTIONSSCORE FLOAT,
ZPLEASANTSYMMETRYSCORE FLOAT,
ZSHARPLYFOCUSEDSUBJECTSCORE FLOAT,
ZTASTEFULLYBLURREDSCORE FLOAT,
ZWELLCHOSENSUBJECTSCORE FLOAT,
ZWELLFRAMEDSUBJECTSCORE FLOAT,
ZWELLTIMEDSHOTSCORE FLOAT
);
CREATE TABLE ZDEFERREDREBUILDFACE (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZCLOUDNAMESOURCE INTEGER,
ZCLUSTERREJECTED INTEGER,
ZFACEALGORITHMVERSION INTEGER,
ZHIDDEN INTEGER,
ZMANUAL INTEGER,
ZNAMESOURCE INTEGER,
ZREJECTED INTEGER,
ZREPRESENTATIVE INTEGER,
ZCENTERX FLOAT,
ZCENTERY FLOAT,
ZSIZE FLOAT,
ZASSETCLOUDGUID VARCHAR,
ZASSETUUID VARCHAR,
ZFACEUUID VARCHAR,
ZPERSONUUID VARCHAR,
ZUUID VARCHAR
);
CREATE TABLE ZDETECTEDFACE (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZAGETYPE INTEGER,
ZASSETVISIBLE INTEGER,
ZBALDTYPE INTEGER,
ZCLOUDLOCALSTATE INTEGER,
ZCLOUDNAMESOURCE INTEGER,
ZCLUSTERSEQUENCENUMBER INTEGER,
ZCONFIRMEDFACECROPGENERATIONSTATE INTEGER,
ZEYEMAKEUPTYPE INTEGER,
ZEYESSTATE INTEGER,
ZFACEALGORITHMVERSION INTEGER,
ZFACIALHAIRTYPE INTEGER,
ZGENDERTYPE INTEGER,
ZGLASSESTYPE INTEGER,
ZHAIRCOLORTYPE INTEGER,
ZHASSMILE INTEGER,
ZHIDDEN INTEGER,
ZISINTRASH INTEGER,
ZISLEFTEYECLOSED INTEGER,
ZISRIGHTEYECLOSED INTEGER,
ZLIPMAKEUPTYPE INTEGER,
ZMANUAL INTEGER,
ZNAMESOURCE INTEGER,
ZQUALITYMEASURE INTEGER,
ZSMILETYPE INTEGER,
ZSOURCEHEIGHT INTEGER,
ZSOURCEWIDTH INTEGER,
ZTRAININGTYPE INTEGER,
+ ZVIPMODELTYPE INTEGER,
ZASSET INTEGER,
- Z34_ASSET INTEGER,
ZFACECROP INTEGER,
ZFACEGROUP INTEGER,
ZFACEGROUPBEINGKEYFACE INTEGER,
ZFACEPRINT INTEGER,
ZPERSON INTEGER,
ZPERSONBEINGKEYFACE INTEGER,
ZADJUSTMENTVERSION TIMESTAMP,
ZBLURSCORE FLOAT,
ZCENTERX FLOAT,
ZCENTERY FLOAT,
ZLEFTEYEX FLOAT,
ZLEFTEYEY FLOAT,
ZMOUTHX FLOAT,
ZMOUTHY FLOAT,
ZPOSEYAW FLOAT,
ZQUALITY FLOAT,
ZRIGHTEYEX FLOAT,
ZRIGHTEYEY FLOAT,
ZROLL FLOAT,
ZSIZE FLOAT,
ZYAW FLOAT,
ZGROUPINGIDENTIFIER VARCHAR,
ZMASTERIDENTIFIER VARCHAR,
ZUUID VARCHAR
);
CREATE TABLE ZDETECTEDFACEGROUP (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZPERSONBUILDERSTATE INTEGER,
ZUNNAMEDFACECOUNT INTEGER,
ZASSOCIATEDPERSON INTEGER,
ZKEYFACE INTEGER,
ZUUID VARCHAR
);
CREATE TABLE ZDETECTEDFACEPRINT (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZFACEPRINTVERSION INTEGER,
ZFACE INTEGER,
ZDATA BLOB
);
CREATE TABLE ZEDITEDIPTCATTRIBUTES (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZASSETATTRIBUTES INTEGER,
ZACTIONADVISED VARCHAR,
ZAUDIODURATION VARCHAR,
ZAUDIOOUTCUE VARCHAR,
ZAUDIOSAMPLINGRATE VARCHAR,
ZAUDIOSAMPLINGRES VARCHAR,
ZAUDIOTYPE VARCHAR,
ZBYLINE VARCHAR,
ZBYLINETITLE VARCHAR,
ZCAPTION VARCHAR,
ZCATEGORY VARCHAR,
ZCIADRCITY VARCHAR,
ZCIADRCTRY VARCHAR,
ZCIADREXTADR VARCHAR,
ZCIADRPCODE VARCHAR,
ZCIADRREGION VARCHAR,
ZCIEMAILWORK VARCHAR,
ZCITELWORK VARCHAR,
ZCIURLWORK VARCHAR,
ZCITY VARCHAR,
ZCONTACT VARCHAR,
ZCONTENTLOCATIONCODE VARCHAR,
ZCONTENTLOCATIONNAME VARCHAR,
ZCOPYRIGHTNOTICE VARCHAR,
ZCOUNTRYPRIMARYLOCATIONCODE VARCHAR,
ZCOUNTRYPRIMARYLOCATIONNAME VARCHAR,
ZCREATORCONTACTINFO VARCHAR,
ZCREDIT VARCHAR,
ZDATECREATED VARCHAR,
ZDIGITALCREATIONDATE VARCHAR,
ZDIGITALCREATIONTIME VARCHAR,
ZEDITSTATUS VARCHAR,
ZEDITORIALUPDATE VARCHAR,
ZEXPIRATIONDATE VARCHAR,
ZEXPIRATIONTIME VARCHAR,
ZFIXTUREIDENTIFIER VARCHAR,
ZHEADLINE VARCHAR,
ZIMAGEORIENTATION VARCHAR,
ZIMAGETYPE VARCHAR,
ZKEYWORDS VARCHAR,
ZLANGUAGEIDENTIFIER VARCHAR,
ZOBJECTATTRIBUTEREFERENCE VARCHAR,
ZOBJECTCYCLE VARCHAR,
ZOBJECTNAME VARCHAR,
ZOBJECTTYPEREFERENCE VARCHAR,
ZORIGINALTRANSMISSIONREFERENCE VARCHAR,
ZORIGINATINGPROGRAM VARCHAR,
ZPROGRAMVERSION VARCHAR,
ZPROVINCESTATE VARCHAR,
ZREFERENCEDATE VARCHAR,
ZREFERENCENUMBER VARCHAR,
ZREFERENCESERVICE VARCHAR,
ZRELEASEDATE VARCHAR,
ZRELEASETIME VARCHAR,
ZSCENE VARCHAR,
ZSOURCE VARCHAR,
ZSPECIALINSTRUCTIONS VARCHAR,
ZSTARRATING VARCHAR,
ZSUBLOCATION VARCHAR,
ZSUBJECTREFERENCE VARCHAR,
ZSUPPLEMENTALCATEGORY VARCHAR,
ZTIMECREATED VARCHAR,
ZURGENCY VARCHAR,
ZUSAGETERMS VARCHAR,
ZWRITEREDITOR VARCHAR,
ZDATA BLOB
);
CREATE TABLE ZEXTENDEDATTRIBUTES (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZFLASHFIRED INTEGER,
ZISO INTEGER,
ZMETERINGMODE INTEGER,
ZSAMPLERATE INTEGER,
ZTRACKFORMAT INTEGER,
ZWHITEBALANCE INTEGER,
ZASSET INTEGER,
ZAPERTURE FLOAT,
ZBITRATE FLOAT,
ZDURATION FLOAT,
ZEXPOSUREBIAS FLOAT,
ZFOCALLENGTH FLOAT,
ZFPS FLOAT,
ZLATITUDE FLOAT,
ZLONGITUDE FLOAT,
ZSHUTTERSPEED FLOAT,
ZCAMERAMAKE VARCHAR,
ZCAMERAMODEL VARCHAR,
ZCODEC VARCHAR,
ZLENSMODEL VARCHAR
);
CREATE TABLE ZFACECROP (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZCLOUDDELETESTATE INTEGER,
ZCLOUDLOCALSTATE INTEGER,
ZCLOUDTYPE INTEGER,
ZSTATE INTEGER,
ZTYPE INTEGER,
ZASSET INTEGER,
- Z34_ASSET INTEGER,
ZFACE INTEGER,
ZPERSON INTEGER,
ZINVALIDMERGECANDIDATEPERSONUUID VARCHAR,
ZUUID VARCHAR,
ZRESOURCEDATA BLOB
);
CREATE TABLE ZFILESYSTEMBOOKMARK (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZRESOURCE INTEGER,
ZPATHRELATIVETOVOLUME VARCHAR,
ZBOOKMARKDATA BLOB
);
CREATE TABLE ZFILESYSTEMVOLUME (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZNAME VARCHAR,
ZUUID VARCHAR,
ZVOLUMEUUIDSTRING VARCHAR
);
CREATE TABLE ZGENERICALBUM (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZCACHEDCOUNT INTEGER,
ZCACHEDPHOTOSCOUNT INTEGER,
ZCACHEDVIDEOSCOUNT INTEGER,
ZCLOUDDELETESTATE INTEGER,
ZCLOUDLOCALSTATE INTEGER,
ZCUSTOMSORTASCENDING INTEGER,
ZCUSTOMSORTKEY INTEGER,
ZISPINNED INTEGER,
+ ZISPROTOTYPE INTEGER,
ZKIND INTEGER,
ZPENDINGITEMSCOUNT INTEGER,
ZPENDINGITEMSTYPE INTEGER,
ZSYNCEVENTORDERKEY INTEGER,
ZTRASHEDSTATE INTEGER,
ZCUSTOMKEYASSET INTEGER,
- Z34_CUSTOMKEYASSET INTEGER,
ZKEYASSET INTEGER,
- Z34_KEYASSET INTEGER,
ZPARENTFOLDER INTEGER,
ZSECONDARYKEYASSET INTEGER,
- Z34_SECONDARYKEYASSET INTEGER,
ZTERTIARYKEYASSET INTEGER,
- Z34_TERTIARYKEYASSET INTEGER,
ZCLOUDALBUMSUBTYPE INTEGER,
ZCLOUDMULTIPLECONTRIBUTORSENABLED INTEGER,
ZCLOUDMULTIPLECONTRIBUTORSENABLEDLOCAL INTEGER,
ZCLOUDNOTIFICATIONSENABLED INTEGER,
ZCLOUDOWNEREMAILKEY INTEGER,
ZCLOUDOWNERISWHITELISTED INTEGER,
ZCLOUDPUBLICURLENABLED INTEGER,
ZCLOUDPUBLICURLENABLEDLOCAL INTEGER,
ZCLOUDRELATIONSHIPSTATE INTEGER,
ZCLOUDRELATIONSHIPSTATELOCAL INTEGER,
ZHASUNSEENCONTENT INTEGER,
ZISOWNED INTEGER,
ZUNSEENASSETSCOUNT INTEGER,
ZKEYASSETFACEIDENTIFIER INTEGER,
ZKEYASSETFACETHUMBNAILINDEX INTEGER,
Z_FOK_PARENTFOLDER INTEGER,
ZCREATIONDATE TIMESTAMP,
ZENDDATE TIMESTAMP,
ZSTARTDATE TIMESTAMP,
ZTRASHEDDATE TIMESTAMP,
ZCLOUDCREATIONDATE TIMESTAMP,
ZCLOUDLASTCONTRIBUTIONDATE TIMESTAMP,
ZCLOUDLASTINTERESTINGCHANGEDATE TIMESTAMP,
ZCLOUDSUBSCRIPTIONDATE TIMESTAMP,
ZCLOUDGUID VARCHAR,
ZIMPORTSESSIONID VARCHAR,
ZTITLE VARCHAR,
ZUUID VARCHAR,
ZCLOUDOWNERFIRSTNAME VARCHAR,
ZCLOUDOWNERFULLNAME VARCHAR,
ZCLOUDOWNERHASHEDPERSONID VARCHAR,
ZCLOUDOWNERLASTNAME VARCHAR,
ZCLOUDPERSONID VARCHAR,
ZPUBLICURL VARCHAR,
ZPROJECTDOCUMENTTYPE VARCHAR,
ZPROJECTEXTENSIONIDENTIFIER VARCHAR,
ZPROJECTRENDERUUID VARCHAR,
ZCUSTOMQUERYTYPE VARCHAR,
ZCLOUDMETADATA BLOB,
ZUSERQUERYDATA BLOB,
ZPROJECTDATA BLOB,
ZCUSTOMQUERYPARAMETERS BLOB
);
-CREATE TABLE ZGENERICASSET (
+CREATE TABLE ZASSET (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZAVALANCHEPICKTYPE INTEGER,
+ ZCAMERAPROCESSINGADJUSTMENTSTATE INTEGER,
ZCLOUDDELETESTATE INTEGER,
ZCLOUDDOWNLOADREQUESTS INTEGER,
ZCLOUDHASCOMMENTSBYME INTEGER,
ZCLOUDHASCOMMENTSCONVERSATION INTEGER,
ZCLOUDHASUNSEENCOMMENTS INTEGER,
ZCLOUDISDELETABLE INTEGER,
ZCLOUDISMYASSET INTEGER,
ZCLOUDLOCALSTATE INTEGER,
ZCLOUDPLACEHOLDERKIND INTEGER,
ZCOMPLETE INTEGER,
ZCUSTOMRENDEREDVALUE INTEGER,
ZDEFERREDPROCESSINGNEEDED INTEGER,
- ZDEPTHSTATES INTEGER,
+ ZDEPTHTYPE INTEGER,
+ ZDERIVEDCAMERACAPTUREDEVICE INTEGER,
ZFACEAREAPOINTS INTEGER,
ZFAVORITE INTEGER,
ZGROUPINGSTATE INTEGER,
ZHASADJUSTMENTS INTEGER,
ZHEIGHT INTEGER,
ZHIDDEN INTEGER,
+ ZHIGHFRAMERATESTATE INTEGER,
ZKIND INTEGER,
ZKINDSUBTYPE INTEGER,
ZLOCALRESOURCESSTATE INTEGER,
ZORIENTATION INTEGER,
ZPACKEDACCEPTABLECROPRECT INTEGER,
ZPACKEDBADGEATTRIBUTES INTEGER,
ZPACKEDPREFERREDCROPRECT INTEGER,
ZPLAYBACKSTYLE INTEGER,
ZPLAYBACKVARIATION INTEGER,
ZSAVEDASSETTYPE INTEGER,
- ZSNOWPLOWSTATE INTEGER,
ZTHUMBNAILINDEX INTEGER,
ZTRASHEDSTATE INTEGER,
ZVIDEOCPDURATIONVALUE INTEGER,
ZVIDEOCPVISIBILITYSTATE INTEGER,
ZVISIBILITYSTATE INTEGER,
ZWIDTH INTEGER,
ZADDITIONALATTRIBUTES INTEGER,
ZCLOUDFEEDASSETSENTRY INTEGER,
ZCOMPUTEDATTRIBUTES INTEGER,
ZDAYGROUPHIGHLIGHTBEINGASSETS INTEGER,
ZDAYGROUPHIGHLIGHTBEINGEXTENDEDASSETS INTEGER,
ZDAYGROUPHIGHLIGHTBEINGKEYASSET INTEGER,
ZDAYGROUPHIGHLIGHTBEINGSUMMARYASSETS INTEGER,
ZEXTENDEDATTRIBUTES INTEGER,
ZHIGHLIGHTBEINGASSETS INTEGER,
ZHIGHLIGHTBEINGEXTENDEDASSETS INTEGER,
ZHIGHLIGHTBEINGKEYASSET INTEGER,
ZHIGHLIGHTBEINGSUMMARYASSETS INTEGER,
ZIMPORTSESSION INTEGER,
+ ZLIBRARYSCOPE INTEGER,
+ ZLIBRARYSCOPEORIGINATOR INTEGER,
ZMASTER INTEGER,
ZMEDIAANALYSISATTRIBUTES INTEGER,
ZMOMENT INTEGER,
ZMOMENTSHARE INTEGER,
ZMONTHHIGHLIGHTBEINGFIRSTASSET INTEGER,
ZMONTHHIGHLIGHTBEINGKEYASSET INTEGER,
ZSEARCHDATA INTEGER,
ZSOURCEASSETFORDUPLICATION INTEGER,
- Z34_SOURCEASSETFORDUPLICATION INTEGER,
ZYEARHIGHLIGHTBEINGKEYASSET INTEGER,
- Z_FOK_IMPORTSESSION INTEGER,
Z_FOK_CLOUDFEEDASSETSENTRY INTEGER,
ZADDEDDATE TIMESTAMP,
ZADJUSTMENTTIMESTAMP TIMESTAMP,
ZANALYSISSTATEMODIFICATIONDATE TIMESTAMP,
ZCLOUDBATCHPUBLISHDATE TIMESTAMP,
ZCLOUDLASTVIEWEDCOMMENTDATE TIMESTAMP,
ZCLOUDSERVERPUBLISHDATE TIMESTAMP,
ZCURATIONSCORE FLOAT,
ZDATECREATED TIMESTAMP,
ZDURATION FLOAT,
ZFACEADJUSTMENTVERSION TIMESTAMP,
ZHDRGAIN FLOAT,
ZHIGHLIGHTVISIBILITYSCORE FLOAT,
ZLASTSHAREDDATE TIMESTAMP,
ZLATITUDE FLOAT,
ZLONGITUDE FLOAT,
ZMODIFICATIONDATE TIMESTAMP,
ZOVERALLAESTHETICSCORE FLOAT,
ZPROMOTIONSCORE FLOAT,
ZSORTTOKEN FLOAT,
ZTRASHEDDATE TIMESTAMP,
ZAVALANCHEUUID VARCHAR,
ZCLOUDASSETGUID VARCHAR,
ZCLOUDBATCHID VARCHAR,
ZCLOUDCOLLECTIONGUID VARCHAR,
ZCLOUDOWNERHASHEDPERSONID VARCHAR,
ZDIRECTORY VARCHAR,
ZFILENAME VARCHAR,
ZGROUPINGUUID VARCHAR,
ZMEDIAGROUPUUID VARCHAR,
ZORIGINALCOLORSPACE VARCHAR,
ZUNIFORMTYPEIDENTIFIER VARCHAR,
ZUUID VARCHAR,
ZIMAGEREQUESTHINTS BLOB,
ZLOCATIONDATA BLOB
);
+
+CREATE TABLE ZGLOBALKEYVALUE (
+ Z_PK INTEGER PRIMARY KEY,
+ Z_ENT INTEGER,
+ Z_OPT INTEGER,
+ ZBOOLVALUE INTEGER,
+ ZINTEGERVALUE INTEGER,
+ ZTYPE INTEGER,
+ ZDATEVALUE TIMESTAMP,
+ ZDOUBLEVALUE FLOAT,
+ ZKEY VARCHAR,
+ ZSTRINGVALUE VARCHAR,
+ ZANYVALUE BLOB
+);
+
CREATE TABLE ZINTERNALRESOURCE (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZCLOUDDELETESTATE INTEGER,
ZCLOUDLOCALSTATE INTEGER,
ZCLOUDPREFETCHCOUNT INTEGER,
ZCLOUDSOURCETYPE INTEGER,
ZDATALENGTH INTEGER,
ZDATASTORECLASSID INTEGER,
ZDATASTORESUBTYPE INTEGER,
ZFILEID INTEGER,
ZLOCALAVAILABILITY INTEGER,
ZLOCALAVAILABILITYTARGET INTEGER,
ZORIENTATION INTEGER,
ZPTPTRASHEDSTATE INTEGER,
ZQUALITYSORTVALUE INTEGER,
ZRECIPEID INTEGER,
ZREMOTEAVAILABILITY INTEGER,
ZREMOTEAVAILABILITYTARGET INTEGER,
ZRESOURCETYPE INTEGER,
ZSIDECARINDEX INTEGER,
ZTRASHEDSTATE INTEGER,
ZUNORIENTEDHEIGHT INTEGER,
ZUNORIENTEDWIDTH INTEGER,
ZVERSION INTEGER,
ZASSET INTEGER,
- Z34_ASSET INTEGER,
ZCODEC INTEGER,
ZFILESYSTEMBOOKMARK INTEGER,
ZFILESYSTEMVOLUME INTEGER,
ZTRANSIENTCLOUDMASTER INTEGER,
ZUNIFORMTYPEIDENTIFIER INTEGER,
ZCLOUDLASTONDEMANDDOWNLOADDATE TIMESTAMP,
ZCLOUDLASTPREFETCHDATE TIMESTAMP,
ZCLOUDMASTERDATECREATED TIMESTAMP,
ZCLOUDPRUNEDAT TIMESTAMP,
ZTRASHEDDATE TIMESTAMP,
ZCLOUDDELETEASSETUUIDWITHRESOURCETYPE VARCHAR,
ZFINGERPRINT VARCHAR,
ZDATASTOREKEYDATA BLOB
);
CREATE TABLE ZKEYWORD (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZSHORTCUT VARCHAR,
ZTITLE VARCHAR,
ZUUID VARCHAR
);
CREATE TABLE ZLEGACYFACE (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZIDENTIFIER INTEGER,
ZASSET INTEGER,
- Z34_ASSET INTEGER,
ZALBUMUUID VARCHAR,
ZRELATIVERECTVALUE BLOB
);
+CREATE TABLE ZLIMITEDLIBRARYFETCHFILTER (
+ Z_PK INTEGER PRIMARY KEY,
+ Z_ENT INTEGER,
+ Z_OPT INTEGER,
+ ZLASTKNOWNPROCESSIDENTIFIER INTEGER,
+ ZSTATE INTEGER,
+ ZAPPLICATIONIDENTIFIER VARCHAR,
+ ZFETCHFILTERDATA BLOB
+);
+
CREATE TABLE ZMEDIAANALYSISASSETATTRIBUTES (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZAUDIOCLASSIFICATION INTEGER,
ZBESTKEYFRAMETIMESCALE INTEGER,
ZBESTKEYFRAMEVALUE INTEGER,
ZBESTVIDEORANGEDURATIONTIMESCALE INTEGER,
ZBESTVIDEORANGEDURATIONVALUE INTEGER,
ZBESTVIDEORANGESTARTTIMESCALE INTEGER,
ZBESTVIDEORANGESTARTVALUE INTEGER,
ZFACECOUNT INTEGER,
ZMEDIAANALYSISVERSION INTEGER,
ZPACKEDBESTPLAYBACKRECT INTEGER,
ZASSET INTEGER,
- Z34_ASSET INTEGER,
ZACTIVITYSCORE FLOAT,
ZAUTOPLAYSUGGESTIONSCORE FLOAT,
ZBLURRINESSSCORE FLOAT,
ZEXPOSURESCORE FLOAT,
ZMEDIAANALYSISTIMESTAMP TIMESTAMP,
ZVIDEOSCORE FLOAT
);
CREATE TABLE ZMEMORY (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZCATEGORY INTEGER,
ZCLOUDDELETESTATE INTEGER,
ZCLOUDLOCALSTATE INTEGER,
ZFAVORITE INTEGER,
+ ZFEATUREDSTATE INTEGER,
ZNOTIFICATIONSTATE INTEGER,
ZPENDING INTEGER,
ZPENDINGPLAYCOUNT INTEGER,
ZPENDINGSHARECOUNT INTEGER,
ZPENDINGVIEWCOUNT INTEGER,
ZPHOTOSGRAPHVERSION INTEGER,
ZPLAYCOUNT INTEGER,
ZREJECTED INTEGER,
ZSHARECOUNT INTEGER,
ZSUBCATEGORY INTEGER,
ZUSERCREATED INTEGER,
ZVIEWCOUNT INTEGER,
ZKEYASSET INTEGER,
- Z34_KEYASSET INTEGER,
ZCREATIONDATE TIMESTAMP,
ZLASTMOVIEPLAYEDDATE TIMESTAMP,
ZLASTVIEWEDDATE TIMESTAMP,
ZSCORE FLOAT,
ZSUBTITLE VARCHAR,
ZTITLE VARCHAR,
ZUUID VARCHAR,
ZMOVIEASSETSTATE BLOB,
ZASSETLISTPREDICATE BLOB,
ZBLACKLISTEDFEATURE BLOB,
ZMOVIEDATA BLOB,
ZPHOTOSGRAPHDATA BLOB
);
+CREATE TABLE ZMIGRATIONHISTORY (
+ Z_PK INTEGER PRIMARY KEY,
+ Z_ENT INTEGER,
+ Z_OPT INTEGER,
+ ZFORCEREBUILDREASON INTEGER,
+ ZINDEX INTEGER,
+ ZMIGRATIONTYPE INTEGER,
+ ZMODELVERSION INTEGER,
+ ZORIGIN INTEGER,
+ ZSOURCEMODELVERSION INTEGER,
+ ZMIGRATIONDATE TIMESTAMP,
+ ZOSVERSION VARCHAR,
+ ZSTOREUUID VARCHAR,
+ ZGLOBALKEYVALUES BLOB
+);
+
CREATE TABLE ZMOMENT (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZCACHEDCOUNT INTEGER,
ZCACHEDPHOTOSCOUNT INTEGER,
ZCACHEDVIDEOSCOUNT INTEGER,
ZPROCESSEDLOCATION INTEGER,
ZTIMEZONEOFFSET INTEGER,
ZTRASHEDSTATE INTEGER,
ZHIGHLIGHT INTEGER,
ZMEGAMOMENTLIST INTEGER,
ZYEARMOMENTLIST INTEGER,
ZAGGREGATIONSCORE FLOAT,
ZAPPROXIMATELATITUDE FLOAT,
ZAPPROXIMATELONGITUDE FLOAT,
ZENDDATE TIMESTAMP,
ZMODIFICATIONDATE TIMESTAMP,
ZREPRESENTATIVEDATE TIMESTAMP,
ZSTARTDATE TIMESTAMP,
ZSUBTITLE VARCHAR,
ZTITLE VARCHAR,
ZUUID VARCHAR,
- ZLOCALIZEDLOCATIONNAMES BLOB
+ ZLOCALIZEDLOCATIONNAMES BLOB,
+ ZGPSHORIZONTALACCURACY FLOAT
);
CREATE TABLE ZMOMENTLIST (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZGRANULARITYLEVEL INTEGER,
ZSORTINDEX INTEGER,
ZTRASHEDSTATE INTEGER,
ZENDDATE TIMESTAMP,
ZREPRESENTATIVEDATE TIMESTAMP,
ZSTARTDATE TIMESTAMP,
ZUUID VARCHAR
);
-CREATE TABLE ZMOMENTSHARE (
- Z_PK INTEGER PRIMARY KEY,
- Z_ENT INTEGER,
- Z_OPT INTEGER,
- ZASSETCOUNT INTEGER,
- ZCLOUDDELETESTATE INTEGER,
- ZLOCALPUBLISHSTATE INTEGER,
- ZMODE INTEGER,
- ZPHOTOSCOUNT INTEGER,
- ZSHOULDIGNOREBUDGETS INTEGER,
- ZSHOULDNOTIFYONUPLOADCOMPLETION INTEGER,
- ZSTATUS INTEGER,
- ZTRASHEDSTATE INTEGER,
- ZUPLOADEDPHOTOSCOUNT INTEGER,
- ZUPLOADEDVIDEOSCOUNT INTEGER,
- ZVIDEOSCOUNT INTEGER,
- ZCREATIONDATE TIMESTAMP,
- ZENDDATE TIMESTAMP,
- ZEXPIRYDATE TIMESTAMP,
- ZSTARTDATE TIMESTAMP,
- ZORIGINATINGSCOPEIDENTIFIER VARCHAR,
- ZSCOPEIDENTIFIER VARCHAR,
- ZTITLE VARCHAR,
- ZUUID VARCHAR,
- ZSHAREURL VARCHAR,
- ZPREVIEWDATA BLOB,
- ZTHUMBNAILIMAGEDATA BLOB
-);
-
-CREATE TABLE ZMOMENTSHAREPARTICIPANT (
- Z_PK INTEGER PRIMARY KEY,
- Z_ENT INTEGER,
- Z_OPT INTEGER,
- ZSTATUS INTEGER,
- ZTYPE INTEGER,
- ZMOMENTSHARE INTEGER,
- ZEMAILADDRESS VARCHAR,
- ZPHONENUMBER VARCHAR,
- ZUSERIDENTIFIER VARCHAR,
- ZUUID VARCHAR,
- ZNAMECOMPONENTS BLOB
-);
-
CREATE TABLE ZPERSON (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZAGETYPE INTEGER,
ZCLOUDDELETESTATE INTEGER,
ZCLOUDLOCALSTATE INTEGER,
ZCLOUDVERIFIEDTYPE INTEGER,
ZFACECOUNT INTEGER,
ZGENDERTYPE INTEGER,
ZINPERSONNAMINGMODEL INTEGER,
ZKEYFACEPICKSOURCE INTEGER,
ZMANUALORDER INTEGER,
ZQUESTIONTYPE INTEGER,
ZTYPE INTEGER,
ZVERIFIEDTYPE INTEGER,
ZASSOCIATEDFACEGROUP INTEGER,
ZKEYFACE INTEGER,
ZMERGETARGETPERSON INTEGER,
ZDISPLAYNAME VARCHAR,
ZFULLNAME VARCHAR,
ZPERSONUUID VARCHAR,
ZPERSONURI VARCHAR,
- ZCONTACTMATCHINGDICTIONARY BLOB
+ ZCONTACTMATCHINGDICTIONARY BLOB,
+ ZSUGGESTEDFORCLIENTTYPE INTEGER
);
CREATE TABLE ZPERSONREFERENCE (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZASSETATTRIBUTES INTEGER,
ZPERSON INTEGER,
ZPERSONUUID VARCHAR,
ZPERSONDATA BLOB
);
CREATE TABLE ZPHOTOSHIGHLIGHT (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZASSETSCOUNT INTEGER,
ZCATEGORY INTEGER,
ZDAYGROUPASSETSCOUNT INTEGER,
ZDAYGROUPEXTENDEDASSETSCOUNT INTEGER,
ZDAYGROUPSUMMARYASSETSCOUNT INTEGER,
ZENDTIMEZONEOFFSET INTEGER,
ZENRICHMENTSTATE INTEGER,
ZENRICHMENTVERSION INTEGER,
ZEXTENDEDCOUNT INTEGER,
ZHIGHLIGHTVERSION INTEGER,
ZISCURATED INTEGER,
ZKIND INTEGER,
ZMOOD INTEGER,
ZSTARTTIMEZONEOFFSET INTEGER,
ZSUMMARYCOUNT INTEGER,
ZTYPE INTEGER,
ZVISIBILITYSTATE INTEGER,
ZDAYGROUPKEYASSET INTEGER,
- Z34_DAYGROUPKEYASSET INTEGER,
ZKEYASSET INTEGER,
- Z34_KEYASSET INTEGER,
ZMONTHFIRSTASSET INTEGER,
- Z34_MONTHFIRSTASSET INTEGER,
ZMONTHKEYASSET INTEGER,
- Z34_MONTHKEYASSET INTEGER,
ZPARENTDAYGROUPPHOTOSHIGHLIGHT INTEGER,
ZPARENTPHOTOSHIGHLIGHT INTEGER,
ZYEARKEYASSET INTEGER,
- Z34_YEARKEYASSET INTEGER,
ZENDDATE TIMESTAMP,
ZPROMOTIONSCORE FLOAT,
ZSTARTDATE TIMESTAMP,
ZSUBTITLE VARCHAR,
ZTITLE VARCHAR,
ZUUID VARCHAR,
ZVERBOSESMARTDESCRIPTION VARCHAR
);
CREATE TABLE ZQUESTION (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZDISPLAYTYPE INTEGER,
ZENTITYTYPE INTEGER,
ZSTATE INTEGER,
ZTYPE INTEGER,
ZCREATIONDATE TIMESTAMP,
ZSCORE FLOAT,
ZENTITYIDENTIFIER VARCHAR,
ZUUID VARCHAR,
ZADDITIONALINFO BLOB
);
CREATE TABLE ZSCENECLASSIFICATION (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZSCENEIDENTIFIER INTEGER,
ZASSETATTRIBUTES INTEGER,
- ZCONFIDENCE FLOAT
+ ZCONFIDENCE FLOAT,
+ ZPACKEDBOUNDINGBOXRECT INTEGER
);
CREATE TABLE ZSCENEPRINT (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZADDITIONALASSETATTRIBUTES INTEGER,
ZDATA BLOB
);
CREATE TABLE ZSEARCHDATA (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZVALID INTEGER,
ZASSET INTEGER,
- Z34_ASSET INTEGER,
ZDATA BLOB
);
+CREATE TABLE ZSHARE (
+ Z_PK INTEGER PRIMARY KEY,
+ Z_ENT INTEGER,
+ Z_OPT INTEGER,
+ ZCLOUDDELETESTATE INTEGER,
+ ZLOCALPUBLISHSTATE INTEGER,
+ ZPUBLICPERMISSION INTEGER,
+ ZSCOPETYPE INTEGER,
+ ZSTATUS INTEGER,
+ ZTRASHEDSTATE INTEGER,
+ ZASSETCOUNT INTEGER,
+ ZFORCESYNCATTEMPTED INTEGER,
+ ZPHOTOSCOUNT INTEGER,
+ ZSHOULDIGNOREBUDGETS INTEGER,
+ ZSHOULDNOTIFYONUPLOADCOMPLETION INTEGER,
+ ZUPLOADEDPHOTOSCOUNT INTEGER,
+ ZUPLOADEDVIDEOSCOUNT INTEGER,
+ ZVIDEOSCOUNT INTEGER,
+ ZCREATIONDATE TIMESTAMP,
+ ZEXPIRYDATE TIMESTAMP,
+ ZENDDATE TIMESTAMP,
+ ZSTARTDATE TIMESTAMP,
+ ZSCOPEIDENTIFIER VARCHAR,
+ ZTITLE VARCHAR,
+ ZUUID VARCHAR,
+ ZORIGINATINGSCOPEIDENTIFIER VARCHAR,
+ ZSHAREURL VARCHAR,
+ ZPREVIEWDATA BLOB,
+ ZTHUMBNAILIMAGEDATA BLOB
+);
+
CREATE TABLE ZSUGGESTION (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZCACHEDCOUNT INTEGER,
ZCACHEDPHOTOSCOUNT INTEGER,
ZCACHEDVIDEOSCOUNT INTEGER,
ZCLOUDDELETESTATE INTEGER,
ZCLOUDLOCALSTATE INTEGER,
ZNOTIFICATIONSTATE INTEGER,
ZSTATE INTEGER,
ZSUBTYPE INTEGER,
ZTYPE INTEGER,
ZVERSION INTEGER,
ZACTIVATIONDATE TIMESTAMP,
ZCREATIONDATE TIMESTAMP,
ZENDDATE TIMESTAMP,
ZEXPUNGEDATE TIMESTAMP,
ZRELEVANTUNTILDATE TIMESTAMP,
ZSTARTDATE TIMESTAMP,
ZSUBTITLE VARCHAR,
ZTITLE VARCHAR,
ZUUID VARCHAR,
ZACTIONDATA BLOB,
- ZFEATURESDATA BLOB
+ ZFEATURESDATA BLOB,
+ ZFEATUREDSTATE INTEGER
);
CREATE TABLE ZUNIFORMTYPEIDENTIFIER (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZCONFORMSTOIMAGE INTEGER,
ZCONFORMSTOMOVIE INTEGER,
ZCONFORMSTORAWIMAGE INTEGER,
ZIDENTIFIER VARCHAR
);
CREATE TABLE ZUNMANAGEDADJUSTMENT (
Z_PK INTEGER PRIMARY KEY,
Z_ENT INTEGER,
Z_OPT INTEGER,
ZADJUSTMENTBASEIMAGEFORMAT INTEGER,
ZADJUSTMENTRENDERTYPES INTEGER,
ZASSETATTRIBUTES INTEGER,
ZADJUSTMENTTIMESTAMP TIMESTAMP,
ZADJUSTMENTFORMATIDENTIFIER VARCHAR,
ZADJUSTMENTFORMATVERSION VARCHAR,
ZEDITORLOCALIZEDNAME VARCHAR,
ZOTHERADJUSTMENTSFINGERPRINT VARCHAR,
ZSIMILARTOORIGINALADJUSTMENTSFINGERPRINT VARCHAR,
ZUUID VARCHAR
);