photos_9.3.5.sql 23 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563
  1. CREATE TABLE Z_METADATA (Z_VERSION INTEGER PRIMARY KEY,
  2. Z_UUID VARCHAR(255),
  3. Z_PLIST BLOB);
  4. CREATE TABLE ZCLOUDSHAREDALBUMINVITATIONRECORD ( Z_PK INTEGER PRIMARY KEY,
  5. Z_ENT INTEGER,
  6. Z_OPT INTEGER,
  7. ZINVITATIONSTATE INTEGER,
  8. ZINVITATIONSTATELOCAL INTEGER,
  9. ZINVITEEEMAILKEY INTEGER,
  10. ZISMINE INTEGER,
  11. ZALBUM INTEGER,
  12. Z_FOK_ALBUM INTEGER,
  13. ZINVITEESUBSCRIPTIONDATE TIMESTAMP,
  14. ZALBUMGUID VARCHAR,
  15. ZCLOUDGUID VARCHAR,
  16. ZINVITEEFIRSTNAME VARCHAR,
  17. ZINVITEEFULLNAME VARCHAR,
  18. ZINVITEEHASHEDPERSONID VARCHAR,
  19. ZINVITEELASTNAME VARCHAR );
  20. CREATE TABLE ZCLOUDFEEDENTRY ( Z_PK INTEGER PRIMARY KEY,
  21. Z_ENT INTEGER,
  22. Z_OPT INTEGER,
  23. ZENTRYPRIORITYNUMBER INTEGER,
  24. ZENTRYTYPENUMBER INTEGER,
  25. ZENTRYDATE TIMESTAMP,
  26. ZENTRYALBUMGUID VARCHAR,
  27. ZENTRYINVITATIONRECORDGUID VARCHAR,
  28. ZENTRYCLOUDASSETGUID VARCHAR );
  29. CREATE TABLE ZMOMENTLIBRARY ( Z_PK INTEGER PRIMARY KEY,
  30. Z_ENT INTEGER,
  31. Z_OPT INTEGER );
  32. CREATE INDEX ZCLOUDSHAREDALBUMINVITATIONRECORD_ZALBUM_INDEX ON ZCLOUDSHAREDALBUMINVITATIONRECORD (ZALBUM);
  33. CREATE INDEX ZCLOUDFEEDENTRY_ZENTRYDATE_INDEX ON ZCLOUDFEEDENTRY (ZENTRYDATE);
  34. CREATE INDEX ZCLOUDFEEDENTRY_ZENTRYTYPENUMBER_INDEX ON ZCLOUDFEEDENTRY (ZENTRYTYPENUMBER);
  35. CREATE INDEX ZCLOUDFEEDENTRY_Z_ENT_INDEX ON ZCLOUDFEEDENTRY (Z_ENT);
  36. CREATE INDEX ZCLOUDFEEDENTRY_ZENTRYDATE_ZENTRYPRIORITYNUMBER_ZENTRYTYPENUMBER ON ZCLOUDFEEDENTRY (ZENTRYDATE,
  37. ZENTRYPRIORITYNUMBER,
  38. ZENTRYTYPENUMBER);
  39. CREATE INDEX ZCLOUDFEEDENTRY_Z_ENT_ZENTRYDATE ON ZCLOUDFEEDENTRY (Z_ENT,
  40. ZENTRYDATE);
  41. CREATE INDEX ZCLOUDFEEDENTRY_Z_PK_ZENTRYDATE ON ZCLOUDFEEDENTRY (Z_PK,
  42. ZENTRYDATE);
  43. CREATE TABLE Z_MODELCACHE (Z_CONTENT BLOB);
  44. CREATE TABLE ZASSETDESCRIPTION ( Z_PK INTEGER PRIMARY KEY,
  45. Z_ENT INTEGER,
  46. Z_OPT INTEGER,
  47. ZASSETATTRIBUTES INTEGER,
  48. ZLONGDESCRIPTION VARCHAR );
  49. CREATE INDEX ZASSETDESCRIPTION_ZASSETATTRIBUTES_INDEX ON ZASSETDESCRIPTION (ZASSETATTRIBUTES);
  50. CREATE TABLE ZMOMENT ( Z_PK INTEGER PRIMARY KEY,
  51. Z_ENT INTEGER,
  52. Z_OPT INTEGER,
  53. ZCACHEDCOUNT INTEGER,
  54. ZCACHEDPHOTOSCOUNT INTEGER,
  55. ZCACHEDVIDEOSCOUNT INTEGER,
  56. ZGENERATIONTYPE INTEGER,
  57. ZREVERSELOCATIONDATAISVALID INTEGER,
  58. ZTRASHEDSTATE INTEGER,
  59. ZMEGAMOMENTLIST INTEGER,
  60. ZMOMENTLIBRARY INTEGER,
  61. ZYEARMOMENTLIST INTEGER,
  62. Z_FOK_MOMENTLIBRARY INTEGER,
  63. Z_FOK_MEGAMOMENTLIST INTEGER,
  64. Z_FOK_YEARMOMENTLIST INTEGER,
  65. ZENDDATE TIMESTAMP,
  66. ZREPRESENTATIVEDATE TIMESTAMP,
  67. ZSTARTDATE TIMESTAMP,
  68. ZTITLE VARCHAR,
  69. ZTITLE2 VARCHAR,
  70. ZTITLE3 VARCHAR,
  71. ZUUID VARCHAR,
  72. ZAPPROXIMATELOCATIONDATA BLOB,
  73. ZREVERSELOCATIONDATA BLOB );
  74. CREATE TABLE ZMOMENTLIST ( Z_PK INTEGER PRIMARY KEY,
  75. Z_ENT INTEGER,
  76. Z_OPT INTEGER,
  77. ZGENERATIONTYPE INTEGER,
  78. ZGRANULARITYLEVEL INTEGER,
  79. ZREVERSELOCATIONDATAISVALID INTEGER,
  80. ZSORTINDEX INTEGER,
  81. ZTRASHEDSTATE INTEGER,
  82. ZENDDATE TIMESTAMP,
  83. ZREPRESENTATIVEDATE TIMESTAMP,
  84. ZSTARTDATE TIMESTAMP,
  85. ZTITLE VARCHAR,
  86. ZTITLE2 VARCHAR,
  87. ZTITLE3 VARCHAR,
  88. ZUUID VARCHAR,
  89. ZREVERSELOCATIONDATA BLOB );
  90. CREATE TABLE ZPERSONREFERENCE ( Z_PK INTEGER PRIMARY KEY,
  91. Z_ENT INTEGER,
  92. Z_OPT INTEGER,
  93. ZASSETATTRIBUTES INTEGER,
  94. ZPERSON INTEGER,
  95. ZPERSONUUID VARCHAR,
  96. ZPERSONDATA BLOB );
  97. CREATE TABLE ZUNMANAGEDADJUSTMENT ( Z_PK INTEGER PRIMARY KEY,
  98. Z_ENT INTEGER,
  99. Z_OPT INTEGER,
  100. ZADJUSTMENTBASEIMAGEFORMAT INTEGER,
  101. ZASSETATTRIBUTES INTEGER,
  102. ZADJUSTMENTTIMESTAMP TIMESTAMP,
  103. ZADJUSTMENTFORMATIDENTIFIER VARCHAR,
  104. ZADJUSTMENTFORMATVERSION VARCHAR,
  105. ZEDITORLOCALIZEDNAME VARCHAR,
  106. ZOTHERADJUSTMENTSFINGERPRINT VARCHAR,
  107. ZSIMILARTOORIGINALADJUSTMENTSFINGERPRINT VARCHAR,
  108. ZUUID VARCHAR );
  109. CREATE TABLE ZCLOUDMASTERMEDIAMETADATA ( Z_PK INTEGER PRIMARY KEY,
  110. Z_ENT INTEGER,
  111. Z_OPT INTEGER,
  112. ZCLOUDMASTER INTEGER,
  113. ZDATA BLOB );
  114. CREATE TABLE ZKEYWORD ( Z_PK INTEGER PRIMARY KEY,
  115. Z_ENT INTEGER,
  116. Z_OPT INTEGER,
  117. ZTITLE VARCHAR,
  118. ZUUID VARCHAR );
  119. CREATE TABLE ZPERSON ( Z_PK INTEGER PRIMARY KEY,
  120. Z_ENT INTEGER,
  121. Z_OPT INTEGER,
  122. ZFULLNAME VARCHAR,
  123. ZPERSONUUID VARCHAR );
  124. CREATE INDEX ZCLOUDMASTERMEDIAMETADATA_ZCLOUDMASTER_INDEX ON ZCLOUDMASTERMEDIAMETADATA (ZCLOUDMASTER);
  125. CREATE INDEX ZKEYWORD_ZTITLE_INDEX ON ZKEYWORD (ZTITLE);
  126. CREATE INDEX ZKEYWORD_ZUUID_INDEX ON ZKEYWORD (ZUUID);
  127. CREATE INDEX ZMOMENT_ZENDDATE_INDEX ON ZMOMENT (ZENDDATE);
  128. CREATE INDEX ZMOMENT_ZREPRESENTATIVEDATE_INDEX ON ZMOMENT (ZREPRESENTATIVEDATE);
  129. CREATE INDEX ZMOMENT_ZREVERSELOCATIONDATAISVALID_INDEX ON ZMOMENT (ZREVERSELOCATIONDATAISVALID);
  130. CREATE INDEX ZMOMENT_ZSTARTDATE_INDEX ON ZMOMENT (ZSTARTDATE);
  131. CREATE INDEX ZMOMENT_ZTRASHEDSTATE_INDEX ON ZMOMENT (ZTRASHEDSTATE);
  132. CREATE INDEX ZMOMENT_ZUUID_INDEX ON ZMOMENT (ZUUID);
  133. CREATE INDEX ZMOMENT_ZMEGAMOMENTLIST_INDEX ON ZMOMENT (ZMEGAMOMENTLIST);
  134. CREATE INDEX ZMOMENT_ZMOMENTLIBRARY_INDEX ON ZMOMENT (ZMOMENTLIBRARY);
  135. CREATE INDEX ZMOMENT_ZYEARMOMENTLIST_INDEX ON ZMOMENT (ZYEARMOMENTLIST);
  136. CREATE INDEX ZMOMENT_ZSTARTDATE_ZENDDATE ON ZMOMENT (ZSTARTDATE,
  137. ZENDDATE);
  138. CREATE INDEX ZMOMENTLIST_ZGRANULARITYLEVEL_INDEX ON ZMOMENTLIST (ZGRANULARITYLEVEL);
  139. CREATE INDEX ZMOMENTLIST_ZREPRESENTATIVEDATE_INDEX ON ZMOMENTLIST (ZREPRESENTATIVEDATE);
  140. CREATE INDEX ZMOMENTLIST_ZREVERSELOCATIONDATAISVALID_INDEX ON ZMOMENTLIST (ZREVERSELOCATIONDATAISVALID);
  141. CREATE INDEX ZMOMENTLIST_ZSORTINDEX_INDEX ON ZMOMENTLIST (ZSORTINDEX);
  142. CREATE INDEX ZMOMENTLIST_ZTRASHEDSTATE_INDEX ON ZMOMENTLIST (ZTRASHEDSTATE);
  143. CREATE INDEX ZMOMENTLIST_ZUUID_INDEX ON ZMOMENTLIST (ZUUID);
  144. CREATE INDEX ZMOMENTLIST_ZGRANULARITYLEVEL_ZSORTINDEX ON ZMOMENTLIST (ZGRANULARITYLEVEL,
  145. ZSORTINDEX);
  146. CREATE INDEX ZMOMENTLIST_ZREVERSELOCATIONDATAISVALID_ZGRANULARITYLEVEL ON ZMOMENTLIST (ZREVERSELOCATIONDATAISVALID,
  147. ZGRANULARITYLEVEL);
  148. CREATE INDEX ZPERSONREFERENCE_ZASSETATTRIBUTES_INDEX ON ZPERSONREFERENCE (ZASSETATTRIBUTES);
  149. CREATE INDEX ZPERSONREFERENCE_ZPERSON_INDEX ON ZPERSONREFERENCE (ZPERSON);
  150. CREATE INDEX ZUNMANAGEDADJUSTMENT_ZASSETATTRIBUTES_INDEX ON ZUNMANAGEDADJUSTMENT (ZASSETATTRIBUTES);
  151. CREATE TABLE Z_1KEYWORDS ( Z_1ASSETATTRIBUTES INTEGER,
  152. Z_25KEYWORDS INTEGER,
  153. PRIMARY KEY (Z_1ASSETATTRIBUTES,
  154. Z_25KEYWORDS) );
  155. CREATE TABLE ZGENERICALBUM ( Z_PK INTEGER PRIMARY KEY,
  156. Z_ENT INTEGER,
  157. Z_OPT INTEGER,
  158. ZCACHEDCOUNT INTEGER,
  159. ZCACHEDPHOTOSCOUNT INTEGER,
  160. ZCACHEDVIDEOSCOUNT INTEGER,
  161. ZCLOUDLOCALSTATE INTEGER,
  162. ZCLOUDSERVERSTATE INTEGER,
  163. ZCUSTOMSORTASCENDING INTEGER,
  164. ZCUSTOMSORTKEY INTEGER,
  165. ZISPINNED INTEGER,
  166. ZKIND INTEGER,
  167. ZPENDINGITEMSCOUNT INTEGER,
  168. ZPENDINGITEMSTYPE INTEGER,
  169. ZSYNCEVENTORDERKEY INTEGER,
  170. ZTRASHEDSTATE INTEGER,
  171. ZCUSTOMKEYASSET INTEGER,
  172. Z22_CUSTOMKEYASSET INTEGER,
  173. ZKEYASSET INTEGER,
  174. Z22_KEYASSET INTEGER,
  175. ZPARENTFOLDER INTEGER,
  176. ZSECONDARYKEYASSET INTEGER,
  177. Z22_SECONDARYKEYASSET INTEGER,
  178. ZTERTIARYKEYASSET INTEGER,
  179. Z22_TERTIARYKEYASSET INTEGER,
  180. ZCLOUDALBUMSUBTYPE INTEGER,
  181. ZCLOUDMULTIPLECONTRIBUTORSENABLED INTEGER,
  182. ZCLOUDMULTIPLECONTRIBUTORSENABLEDLOCAL INTEGER,
  183. ZCLOUDNOTIFICATIONSENABLED INTEGER,
  184. ZCLOUDOWNEREMAILKEY INTEGER,
  185. ZCLOUDPUBLICURLENABLED INTEGER,
  186. ZCLOUDPUBLICURLENABLEDLOCAL INTEGER,
  187. ZCLOUDRELATIONSHIPSTATE INTEGER,
  188. ZCLOUDRELATIONSHIPSTATELOCAL INTEGER,
  189. ZHASUNSEENCONTENT INTEGER,
  190. ZISOWNED INTEGER,
  191. ZUNSEENASSETSCOUNT INTEGER,
  192. ZKEYASSETFACEIDENTIFIER INTEGER,
  193. ZKEYASSETFACETHUMBNAILINDEX INTEGER,
  194. ZWALLPAPERALBUMTYPE INTEGER,
  195. Z_FOK_PARENTFOLDER INTEGER,
  196. ZENDDATE TIMESTAMP,
  197. ZSTARTDATE TIMESTAMP,
  198. ZTRASHEDDATE TIMESTAMP,
  199. ZCLOUDCREATIONDATE TIMESTAMP,
  200. ZCLOUDLASTCONTRIBUTIONDATE TIMESTAMP,
  201. ZCLOUDLASTINTERESTINGCHANGEDATE TIMESTAMP,
  202. ZCLOUDSUBSCRIPTIONDATE TIMESTAMP,
  203. ZCLOUDGUID VARCHAR,
  204. ZIMPORTSESSIONID VARCHAR,
  205. ZTITLE VARCHAR,
  206. ZUUID VARCHAR,
  207. ZCLOUDOWNERFIRSTNAME VARCHAR,
  208. ZCLOUDOWNERFULLNAME VARCHAR,
  209. ZCLOUDOWNERHASHEDPERSONID VARCHAR,
  210. ZCLOUDOWNERLASTNAME VARCHAR,
  211. ZCLOUDPERSONID VARCHAR,
  212. ZPUBLICURL VARCHAR,
  213. ZCUSTOMQUERYTYPE VARCHAR,
  214. ZCLOUDMETADATA BLOB,
  215. ZCUSTOMQUERYPARAMETERS BLOB );
  216. CREATE TABLE Z_14ALBUMLISTS ( Z_14ALBUMS INTEGER,
  217. Z_3ALBUMLISTS INTEGER,
  218. Z_FOK_14ALBUMS INTEGER,
  219. PRIMARY KEY (Z_14ALBUMS,
  220. Z_3ALBUMLISTS) );
  221. CREATE TABLE Z_15ASSETS ( Z_15ALBUMS INTEGER,
  222. Z_22ASSETS INTEGER,
  223. Z_FOK_22ASSETS INTEGER,
  224. PRIMARY KEY (Z_15ALBUMS,
  225. Z_22ASSETS) );
  226. CREATE TABLE ZFACE ( Z_PK INTEGER PRIMARY KEY,
  227. Z_ENT INTEGER,
  228. Z_OPT INTEGER,
  229. ZIDENTIFIER INTEGER,
  230. ZASSET INTEGER,
  231. Z22_ASSET INTEGER,
  232. ZALBUMUUID VARCHAR,
  233. ZRELATIVERECTVALUE BLOB );
  234. CREATE TABLE ZCLOUDSHAREDCOMMENT ( Z_PK INTEGER PRIMARY KEY,
  235. Z_ENT INTEGER,
  236. Z_OPT INTEGER,
  237. ZISBATCHCOMMENT INTEGER,
  238. ZISCAPTION INTEGER,
  239. ZISDELETABLE INTEGER,
  240. ZISLIKE INTEGER,
  241. ZISMYCOMMENT INTEGER,
  242. ZCLOUDFEEDCOMMENTENTRY INTEGER,
  243. ZCLOUDFEEDLIKECOMMENTENTRY INTEGER,
  244. ZCOMMENTEDASSET INTEGER,
  245. Z22_COMMENTEDASSET INTEGER,
  246. ZLIKEDASSET INTEGER,
  247. Z22_LIKEDASSET INTEGER,
  248. Z_FOK_LIKEDASSET INTEGER,
  249. Z_FOK_CLOUDFEEDCOMMENTENTRY INTEGER,
  250. Z_FOK_COMMENTEDASSET INTEGER,
  251. Z_FOK_CLOUDFEEDLIKECOMMENTENTRY INTEGER,
  252. ZCOMMENTCLIENTDATE TIMESTAMP,
  253. ZCOMMENTDATE TIMESTAMP,
  254. ZCLOUDGUID VARCHAR,
  255. ZCOMMENTTEXT VARCHAR,
  256. ZCOMMENTTYPE VARCHAR,
  257. ZCOMMENTERHASHEDPERSONID VARCHAR );
  258. CREATE TABLE ZSEARCHDATA ( Z_PK INTEGER PRIMARY KEY,
  259. Z_ENT INTEGER,
  260. Z_OPT INTEGER,
  261. ZVALID INTEGER,
  262. ZASSET INTEGER,
  263. Z22_ASSET INTEGER,
  264. ZDATA BLOB );
  265. CREATE TABLE ZADJUSTMENT ( Z_PK INTEGER PRIMARY KEY,
  266. Z_ENT INTEGER,
  267. Z_OPT INTEGER,
  268. ZIDENTIFIER INTEGER,
  269. ZASSET INTEGER,
  270. Z22_ASSET INTEGER,
  271. Z_FOK_ASSET INTEGER,
  272. ZFILTERNAME VARCHAR,
  273. ZFILTERSETTINGS BLOB );
  274. CREATE TABLE ZALBUMLIST ( Z_PK INTEGER PRIMARY KEY,
  275. Z_ENT INTEGER,
  276. Z_OPT INTEGER,
  277. ZIDENTIFIER INTEGER,
  278. ZNEEDSREORDERINGNUMBER INTEGER,
  279. ZUUID VARCHAR );
  280. CREATE TABLE ZSIDECARFILE ( Z_PK INTEGER PRIMARY KEY,
  281. Z_ENT INTEGER,
  282. Z_OPT INTEGER,
  283. ZCOMPRESSEDSIZE INTEGER,
  284. ZINDEX INTEGER,
  285. ZASSET INTEGER,
  286. Z22_ASSET INTEGER,
  287. ZCAPTUREDATE TIMESTAMP,
  288. ZMODIFICATIONDATE TIMESTAMP,
  289. ZFILENAME VARCHAR,
  290. ZORIGINALFILENAME VARCHAR,
  291. ZUNIFORMTYPEIDENTIFIER VARCHAR );
  292. CREATE INDEX Z_1KEYWORDS_Z_25KEYWORDS_INDEX ON Z_1KEYWORDS (Z_25KEYWORDS,
  293. Z_1ASSETATTRIBUTES);
  294. CREATE INDEX ZADJUSTMENT_ZASSET_INDEX ON ZADJUSTMENT (ZASSET);
  295. CREATE INDEX ZALBUMLIST_ZIDENTIFIER_INDEX ON ZALBUMLIST (ZIDENTIFIER);
  296. CREATE INDEX ZALBUMLIST_ZUUID_INDEX ON ZALBUMLIST (ZUUID);
  297. CREATE INDEX ZCLOUDSHAREDCOMMENT_ZCLOUDGUID_INDEX ON ZCLOUDSHAREDCOMMENT (ZCLOUDGUID);
  298. CREATE INDEX ZCLOUDSHAREDCOMMENT_ZCLOUDFEEDCOMMENTENTRY_INDEX ON ZCLOUDSHAREDCOMMENT (ZCLOUDFEEDCOMMENTENTRY);
  299. CREATE INDEX ZCLOUDSHAREDCOMMENT_ZCLOUDFEEDLIKECOMMENTENTRY_INDEX ON ZCLOUDSHAREDCOMMENT (ZCLOUDFEEDLIKECOMMENTENTRY);
  300. CREATE INDEX ZCLOUDSHAREDCOMMENT_ZCOMMENTEDASSET_INDEX ON ZCLOUDSHAREDCOMMENT (ZCOMMENTEDASSET);
  301. CREATE INDEX ZCLOUDSHAREDCOMMENT_ZLIKEDASSET_INDEX ON ZCLOUDSHAREDCOMMENT (ZLIKEDASSET);
  302. CREATE INDEX ZFACE_ZALBUMUUID_INDEX ON ZFACE (ZALBUMUUID);
  303. CREATE INDEX ZFACE_ZIDENTIFIER_INDEX ON ZFACE (ZIDENTIFIER);
  304. CREATE INDEX ZFACE_ZASSET_INDEX ON ZFACE (ZASSET);
  305. CREATE INDEX ZGENERICALBUM_ZCLOUDGUID_INDEX ON ZGENERICALBUM (ZCLOUDGUID);
  306. CREATE INDEX ZGENERICALBUM_ZCLOUDSERVERSTATE_INDEX ON ZGENERICALBUM (ZCLOUDSERVERSTATE);
  307. CREATE INDEX ZGENERICALBUM_ZKIND_INDEX ON ZGENERICALBUM (ZKIND);
  308. CREATE INDEX ZGENERICALBUM_ZSYNCEVENTORDERKEY_INDEX ON ZGENERICALBUM (ZSYNCEVENTORDERKEY);
  309. CREATE INDEX ZGENERICALBUM_ZUUID_INDEX ON ZGENERICALBUM (ZUUID);
  310. CREATE INDEX ZGENERICALBUM_ZCUSTOMKEYASSET_INDEX ON ZGENERICALBUM (ZCUSTOMKEYASSET);
  311. CREATE INDEX ZGENERICALBUM_ZKEYASSET_INDEX ON ZGENERICALBUM (ZKEYASSET);
  312. CREATE INDEX ZGENERICALBUM_ZPARENTFOLDER_INDEX ON ZGENERICALBUM (ZPARENTFOLDER);
  313. CREATE INDEX ZGENERICALBUM_ZSECONDARYKEYASSET_INDEX ON ZGENERICALBUM (ZSECONDARYKEYASSET);
  314. CREATE INDEX ZGENERICALBUM_ZTERTIARYKEYASSET_INDEX ON ZGENERICALBUM (ZTERTIARYKEYASSET);
  315. CREATE INDEX ZGENERICALBUM_ZWALLPAPERALBUMTYPE_INDEX ON ZGENERICALBUM (ZWALLPAPERALBUMTYPE);
  316. CREATE INDEX Z_14ALBUMLISTS_Z_3ALBUMLISTS_INDEX ON Z_14ALBUMLISTS (Z_3ALBUMLISTS,
  317. Z_14ALBUMS);
  318. CREATE INDEX ZGENERICALBUM_Z_ENT_INDEX ON ZGENERICALBUM (Z_ENT);
  319. CREATE INDEX ZGENERICALBUM_ZCLOUDLOCALSTATE_ZCLOUDSERVERSTATE ON ZGENERICALBUM (ZCLOUDLOCALSTATE,
  320. ZCLOUDSERVERSTATE);
  321. CREATE INDEX Z_15ASSETS_Z_22ASSETS_INDEX ON Z_15ASSETS (Z_22ASSETS,
  322. Z_15ALBUMS);
  323. CREATE INDEX ZSEARCHDATA_ZVALID_INDEX ON ZSEARCHDATA (ZVALID);
  324. CREATE INDEX ZSEARCHDATA_ZASSET_INDEX ON ZSEARCHDATA (ZASSET);
  325. CREATE INDEX ZSIDECARFILE_ZASSET_INDEX ON ZSIDECARFILE (ZASSET);
  326. CREATE TABLE Z_PRIMARYKEY (Z_ENT INTEGER PRIMARY KEY,
  327. Z_NAME VARCHAR,
  328. Z_SUPER INTEGER,
  329. Z_MAX INTEGER);
  330. CREATE TABLE ZGENERICASSET ( Z_PK INTEGER PRIMARY KEY,
  331. Z_ENT INTEGER,
  332. Z_OPT INTEGER,
  333. ZAVALANCHEPICKTYPE INTEGER,
  334. ZCLOUDDOWNLOADREQUESTS INTEGER,
  335. ZCLOUDHASCOMMENTSBYME INTEGER,
  336. ZCLOUDHASCOMMENTSCONVERSATION INTEGER,
  337. ZCLOUDHASUNSEENCOMMENTS INTEGER,
  338. ZCLOUDISDELETABLE INTEGER,
  339. ZCLOUDISMYASSET INTEGER,
  340. ZCLOUDLOCALSTATE INTEGER,
  341. ZCLOUDPLACEHOLDERKIND INTEGER,
  342. ZCOMPLETE INTEGER,
  343. ZFAVORITE INTEGER,
  344. ZHASADJUSTMENTS INTEGER,
  345. ZHEIGHT INTEGER,
  346. ZHIDDEN INTEGER,
  347. ZHIGHDYNAMICRANGETYPE INTEGER,
  348. ZKIND INTEGER,
  349. ZKINDSUBTYPE INTEGER,
  350. ZORIENTATION INTEGER,
  351. ZSAVEDASSETTYPE INTEGER,
  352. ZTHUMBNAILINDEX INTEGER,
  353. ZTRASHEDSTATE INTEGER,
  354. ZVIDEOCPDURATIONVALUE INTEGER,
  355. ZVIDEOCPVISIBILITYSTATE INTEGER,
  356. ZVISIBILITYSTATE INTEGER,
  357. ZWIDTH INTEGER,
  358. ZADDITIONALATTRIBUTES INTEGER,
  359. ZCLOUDFEEDASSETSENTRY INTEGER,
  360. ZMASTER INTEGER,
  361. ZMOMENT INTEGER,
  362. ZSEARCHDATA INTEGER,
  363. Z_FOK_MOMENT INTEGER,
  364. Z_FOK_CLOUDFEEDASSETSENTRY INTEGER,
  365. ZADDEDDATE TIMESTAMP,
  366. ZADJUSTMENTTIMESTAMP TIMESTAMP,
  367. ZCLOUDBATCHPUBLISHDATE TIMESTAMP,
  368. ZCLOUDLASTVIEWEDCOMMENTDATE TIMESTAMP,
  369. ZCLOUDSERVERPUBLISHDATE TIMESTAMP,
  370. ZDATECREATED TIMESTAMP,
  371. ZDURATION FLOAT,
  372. ZLASTSHAREDDATE TIMESTAMP,
  373. ZMODIFICATIONDATE TIMESTAMP,
  374. ZSORTTOKEN FLOAT,
  375. ZTRASHEDDATE TIMESTAMP,
  376. ZAVALANCHEUUID VARCHAR,
  377. ZCLOUDASSETGUID VARCHAR,
  378. ZCLOUDBATCHID VARCHAR,
  379. ZCLOUDCOLLECTIONGUID VARCHAR,
  380. ZCLOUDOWNERHASHEDPERSONID VARCHAR,
  381. ZDIRECTORY VARCHAR,
  382. ZFILENAME VARCHAR,
  383. ZMEDIAGROUPUUID VARCHAR,
  384. ZUNIFORMTYPEIDENTIFIER VARCHAR,
  385. ZUUID VARCHAR,
  386. ZLOCATIONDATA BLOB,
  387. ZIMAGEURLDATA BLOB,
  388. ZTHUMBNAILURLDATA BLOB,
  389. ZWALLPAPEROPTIONSDATA BLOB );
  390. CREATE INDEX ZGENERICASSET_ZADDEDDATE_INDEX ON ZGENERICASSET (ZADDEDDATE);
  391. CREATE INDEX ZGENERICASSET_ZAVALANCHEPICKTYPE_INDEX ON ZGENERICASSET (ZAVALANCHEPICKTYPE);
  392. CREATE INDEX ZGENERICASSET_ZAVALANCHEUUID_INDEX ON ZGENERICASSET (ZAVALANCHEUUID);
  393. CREATE INDEX ZGENERICASSET_ZCLOUDASSETGUID_INDEX ON ZGENERICASSET (ZCLOUDASSETGUID);
  394. CREATE INDEX ZGENERICASSET_ZCLOUDLOCALSTATE_INDEX ON ZGENERICASSET (ZCLOUDLOCALSTATE);
  395. CREATE INDEX ZGENERICASSET_ZCLOUDPLACEHOLDERKIND_INDEX ON ZGENERICASSET (ZCLOUDPLACEHOLDERKIND);
  396. CREATE INDEX ZGENERICASSET_ZCOMPLETE_INDEX ON ZGENERICASSET (ZCOMPLETE);
  397. CREATE INDEX ZGENERICASSET_ZDATECREATED_INDEX ON ZGENERICASSET (ZDATECREATED);
  398. CREATE INDEX ZGENERICASSET_ZFAVORITE_INDEX ON ZGENERICASSET (ZFAVORITE);
  399. CREATE INDEX ZGENERICASSET_ZKIND_INDEX ON ZGENERICASSET (ZKIND);
  400. CREATE INDEX ZGENERICASSET_ZKINDSUBTYPE_INDEX ON ZGENERICASSET (ZKINDSUBTYPE);
  401. CREATE INDEX ZGENERICASSET_ZLASTSHAREDDATE_INDEX ON ZGENERICASSET (ZLASTSHAREDDATE);
  402. CREATE INDEX ZGENERICASSET_ZMEDIAGROUPUUID_INDEX ON ZGENERICASSET (ZMEDIAGROUPUUID);
  403. CREATE INDEX ZGENERICASSET_ZSAVEDASSETTYPE_INDEX ON ZGENERICASSET (ZSAVEDASSETTYPE);
  404. CREATE INDEX ZGENERICASSET_ZSORTTOKEN_INDEX ON ZGENERICASSET (ZSORTTOKEN);
  405. CREATE INDEX ZGENERICASSET_ZUUID_INDEX ON ZGENERICASSET (ZUUID);
  406. CREATE INDEX ZGENERICASSET_ZVISIBILITYSTATE_INDEX ON ZGENERICASSET (ZVISIBILITYSTATE);
  407. CREATE INDEX ZGENERICASSET_ZADDITIONALATTRIBUTES_INDEX ON ZGENERICASSET (ZADDITIONALATTRIBUTES);
  408. CREATE INDEX ZGENERICASSET_ZCLOUDFEEDASSETSENTRY_INDEX ON ZGENERICASSET (ZCLOUDFEEDASSETSENTRY);
  409. CREATE INDEX ZGENERICASSET_ZMASTER_INDEX ON ZGENERICASSET (ZMASTER);
  410. CREATE INDEX ZGENERICASSET_ZMOMENT_INDEX ON ZGENERICASSET (ZMOMENT);
  411. CREATE INDEX ZGENERICASSET_ZSEARCHDATA_INDEX ON ZGENERICASSET (ZSEARCHDATA);
  412. CREATE INDEX ZGENERICASSET_Z_ENT_INDEX ON ZGENERICASSET (Z_ENT);
  413. CREATE INDEX ZGENERICASSET_ZKIND_Z_ENT ON ZGENERICASSET (ZKIND,
  414. Z_ENT);
  415. CREATE INDEX ZGENERICASSET_ZCLOUDASSETGUID_ZSAVEDASSETTYPE ON ZGENERICASSET (ZCLOUDASSETGUID,
  416. ZSAVEDASSETTYPE);
  417. CREATE INDEX ZGENERICASSET_ZDIRECTORY_ZFILENAME ON ZGENERICASSET (ZDIRECTORY,
  418. ZFILENAME);
  419. CREATE INDEX ZGENERICASSET_ZCLOUDLOCALSTATE ON ZGENERICASSET (ZCLOUDLOCALSTATE);
  420. CREATE INDEX ZGENERICASSET_ZHIDDEN_ZVISIBILITYSTATE ON ZGENERICASSET (ZHIDDEN,
  421. ZVISIBILITYSTATE);
  422. CREATE INDEX ZGENERICASSET_ZTRASHEDSTATE_ZTRASHEDDATE ON ZGENERICASSET (ZTRASHEDSTATE,
  423. ZTRASHEDDATE);
  424. CREATE INDEX ZGENERICASSET_ZADDEDDATE_ZSORTTOKEN ON ZGENERICASSET (ZADDEDDATE,
  425. ZSORTTOKEN);
  426. CREATE INDEX ZGENERICASSET_ZADDEDDATE_ZSORTTOKEN_ZKIND_ZSAVEDASSETTYPE_ZVISIBILITYSTATE_ZTRASHEDSTATE_ZHIDDEN_ZAVALANCHEPICKTYPE_ZCOMPLETE_Z_ENT ON ZGENERICASSET (ZADDEDDATE,
  427. ZSORTTOKEN,
  428. ZKIND,
  429. ZSAVEDASSETTYPE,
  430. ZVISIBILITYSTATE,
  431. ZTRASHEDSTATE,
  432. ZHIDDEN,
  433. ZAVALANCHEPICKTYPE,
  434. ZCOMPLETE,
  435. Z_ENT);
  436. CREATE TABLE ZADDITIONALASSETATTRIBUTES ( Z_PK INTEGER PRIMARY KEY,
  437. Z_ENT INTEGER,
  438. Z_OPT INTEGER,
  439. ZCAMERACAPTUREDEVICE INTEGER,
  440. ZCLOUDAVALANCHEPICKTYPE INTEGER,
  441. ZCLOUDKINDSUBTYPE INTEGER,
  442. ZEMBEDDEDTHUMBNAILHEIGHT INTEGER,
  443. ZEMBEDDEDTHUMBNAILLENGTH INTEGER,
  444. ZEMBEDDEDTHUMBNAILOFFSET INTEGER,
  445. ZEMBEDDEDTHUMBNAILWIDTH INTEGER,
  446. ZEXTERNALUSAGEINTENT INTEGER,
  447. ZLOCATIONHASH INTEGER,
  448. ZORIGINALFILESIZE INTEGER,
  449. ZORIGINALHEIGHT INTEGER,
  450. ZORIGINALORIENTATION INTEGER,
  451. ZORIGINALRESOURCECHOICE INTEGER,
  452. ZORIGINALWIDTH INTEGER,
  453. ZREVERSELOCATIONDATAISVALID INTEGER,
  454. ZSHIFTEDLOCATIONISVALID INTEGER,
  455. ZTIMEZONEOFFSET INTEGER,
  456. ZUPLOADATTEMPTS INTEGER,
  457. ZVIDEOCPDISPLAYTIMESCALE INTEGER,
  458. ZVIDEOCPDISPLAYVALUE INTEGER,
  459. ZVIDEOCPDURATIONTIMESCALE INTEGER,
  460. ZASSET INTEGER,
  461. Z22_ASSET INTEGER,
  462. ZASSETDESCRIPTION INTEGER,
  463. ZUNMANAGEDADJUSTMENT INTEGER,
  464. ZLASTUPLOADATTEMPTDATE TIMESTAMP,
  465. ZADJUSTEDFINGERPRINT VARCHAR,
  466. ZCREATORBUNDLEID VARCHAR,
  467. ZCUSTOMCOLLECTIONNAME VARCHAR,
  468. ZCUSTOMCOLLECTIONUUID VARCHAR,
  469. ZCUSTOMMOMENTNAME VARCHAR,
  470. ZCUSTOMMOMENTUUID VARCHAR,
  471. ZEDITORBUNDLEID VARCHAR,
  472. ZEXIFTIMESTAMPSTRING VARCHAR,
  473. ZIMPORTSESSIONID VARCHAR,
  474. ZMASTERFINGERPRINT VARCHAR,
  475. ZORIGINALASSETSUUID VARCHAR,
  476. ZORIGINALCOLORSPACE VARCHAR,
  477. ZORIGINALFILENAME VARCHAR,
  478. ZORIGINALPATH VARCHAR,
  479. ZPUBLICGLOBALUUID VARCHAR,
  480. ZTIMEZONENAME VARCHAR,
  481. ZTITLE VARCHAR,
  482. ZFACEREGIONS BLOB,
  483. ZORIGINALHASH BLOB,
  484. ZPLACEANNOTATIONDATA BLOB,
  485. ZREVERSELOCATIONDATA BLOB,
  486. ZSHIFTEDLOCATIONDATA BLOB );
  487. CREATE TABLE ZCLOUDMASTER ( Z_PK INTEGER PRIMARY KEY,
  488. Z_ENT INTEGER,
  489. Z_OPT INTEGER,
  490. ZCLOUDLOCALSTATE INTEGER,
  491. ZCLOUDSERVERSTATE INTEGER,
  492. ZFULLSIZEJPEGSOURCE INTEGER,
  493. ZORIGINALORIENTATION INTEGER,
  494. ZMEDIAMETADATA INTEGER,
  495. ZCREATIONDATE TIMESTAMP,
  496. ZIMPORTDATE TIMESTAMP,
  497. ZASSETUUID VARCHAR,
  498. ZCLOUDMASTERGUID VARCHAR,
  499. ZIMPORTSESSIONID VARCHAR,
  500. ZMEDIAMETADATATYPE VARCHAR,
  501. ZORIGINALFILENAME VARCHAR,
  502. ZUNIFORMTYPEIDENTIFIER VARCHAR );
  503. CREATE TABLE ZCLOUDRESOURCE ( Z_PK INTEGER PRIMARY KEY,
  504. Z_ENT INTEGER,
  505. Z_OPT INTEGER,
  506. ZFILESIZE INTEGER,
  507. ZHEIGHT INTEGER,
  508. ZISAVAILABLE INTEGER,
  509. ZISLOCALLYAVAILABLE INTEGER,
  510. ZPREFETCHCOUNT INTEGER,
  511. ZTYPE INTEGER,
  512. ZWIDTH INTEGER,
  513. ZASSET INTEGER,
  514. Z22_ASSET INTEGER,
  515. ZCLOUDMASTER INTEGER,
  516. ZDATECREATED TIMESTAMP,
  517. ZLASTONDEMANDDOWNLOADDATE TIMESTAMP,
  518. ZLASTPREFETCHDATE TIMESTAMP,
  519. ZPRUNEDAT TIMESTAMP,
  520. ZASSETUUID VARCHAR,
  521. ZFILEPATH VARCHAR,
  522. ZFINGERPRINT VARCHAR,
  523. ZITEMIDENTIFIER VARCHAR,
  524. ZUNIFORMTYPEIDENTIFIER VARCHAR );
  525. CREATE INDEX ZADDITIONALASSETATTRIBUTES_ZADJUSTEDFINGERPRINT_INDEX ON ZADDITIONALASSETATTRIBUTES (ZADJUSTEDFINGERPRINT);
  526. CREATE INDEX ZADDITIONALASSETATTRIBUTES_ZCAMERACAPTUREDEVICE_INDEX ON ZADDITIONALASSETATTRIBUTES (ZCAMERACAPTUREDEVICE);
  527. CREATE INDEX ZADDITIONALASSETATTRIBUTES_ZCREATORBUNDLEID_INDEX ON ZADDITIONALASSETATTRIBUTES (ZCREATORBUNDLEID);
  528. CREATE INDEX ZADDITIONALASSETATTRIBUTES_ZLOCATIONHASH_INDEX ON ZADDITIONALASSETATTRIBUTES (ZLOCATIONHASH);
  529. CREATE INDEX ZADDITIONALASSETATTRIBUTES_ZMASTERFINGERPRINT_INDEX ON ZADDITIONALASSETATTRIBUTES (ZMASTERFINGERPRINT);
  530. CREATE INDEX ZADDITIONALASSETATTRIBUTES_ZORIGINALASSETSUUID_INDEX ON ZADDITIONALASSETATTRIBUTES (ZORIGINALASSETSUUID);
  531. CREATE INDEX ZADDITIONALASSETATTRIBUTES_ZORIGINALHASH_INDEX ON ZADDITIONALASSETATTRIBUTES (ZORIGINALHASH);
  532. CREATE INDEX ZADDITIONALASSETATTRIBUTES_ZPUBLICGLOBALUUID_INDEX ON ZADDITIONALASSETATTRIBUTES (ZPUBLICGLOBALUUID);
  533. CREATE INDEX ZADDITIONALASSETATTRIBUTES_ZREVERSELOCATIONDATAISVALID_INDEX ON ZADDITIONALASSETATTRIBUTES (ZREVERSELOCATIONDATAISVALID);
  534. CREATE INDEX ZADDITIONALASSETATTRIBUTES_ZSHIFTEDLOCATIONISVALID_INDEX ON ZADDITIONALASSETATTRIBUTES (ZSHIFTEDLOCATIONISVALID);
  535. CREATE INDEX ZADDITIONALASSETATTRIBUTES_ZUPLOADATTEMPTS_INDEX ON ZADDITIONALASSETATTRIBUTES (ZUPLOADATTEMPTS);
  536. CREATE INDEX ZADDITIONALASSETATTRIBUTES_ZASSET_INDEX ON ZADDITIONALASSETATTRIBUTES (ZASSET);
  537. CREATE INDEX ZADDITIONALASSETATTRIBUTES_ZASSETDESCRIPTION_INDEX ON ZADDITIONALASSETATTRIBUTES (ZASSETDESCRIPTION);
  538. CREATE INDEX ZADDITIONALASSETATTRIBUTES_ZUNMANAGEDADJUSTMENT_INDEX ON ZADDITIONALASSETATTRIBUTES (ZUNMANAGEDADJUSTMENT);
  539. CREATE INDEX ZCLOUDMASTER_ZCLOUDLOCALSTATE_INDEX ON ZCLOUDMASTER (ZCLOUDLOCALSTATE);
  540. CREATE INDEX ZCLOUDMASTER_ZCLOUDMASTERGUID_INDEX ON ZCLOUDMASTER (ZCLOUDMASTERGUID);
  541. CREATE INDEX ZCLOUDMASTER_ZCLOUDSERVERSTATE_INDEX ON ZCLOUDMASTER (ZCLOUDSERVERSTATE);
  542. CREATE INDEX ZCLOUDMASTER_ZMEDIAMETADATA_INDEX ON ZCLOUDMASTER (ZMEDIAMETADATA);
  543. CREATE INDEX ZCLOUDRESOURCE_ZASSETUUID_INDEX ON ZCLOUDRESOURCE (ZASSETUUID);
  544. CREATE INDEX ZCLOUDRESOURCE_ZDATECREATED_INDEX ON ZCLOUDRESOURCE (ZDATECREATED);
  545. CREATE INDEX ZCLOUDRESOURCE_ZFINGERPRINT_INDEX ON ZCLOUDRESOURCE (ZFINGERPRINT);
  546. CREATE INDEX ZCLOUDRESOURCE_ZISAVAILABLE_INDEX ON ZCLOUDRESOURCE (ZISAVAILABLE);
  547. CREATE INDEX ZCLOUDRESOURCE_ZISLOCALLYAVAILABLE_INDEX ON ZCLOUDRESOURCE (ZISLOCALLYAVAILABLE);
  548. CREATE INDEX ZCLOUDRESOURCE_ZLASTONDEMANDDOWNLOADDATE_INDEX ON ZCLOUDRESOURCE (ZLASTONDEMANDDOWNLOADDATE);
  549. CREATE INDEX ZCLOUDRESOURCE_ZLASTPREFETCHDATE_INDEX ON ZCLOUDRESOURCE (ZLASTPREFETCHDATE);
  550. CREATE INDEX ZCLOUDRESOURCE_ZPREFETCHCOUNT_INDEX ON ZCLOUDRESOURCE (ZPREFETCHCOUNT);
  551. CREATE INDEX ZCLOUDRESOURCE_ZTYPE_INDEX ON ZCLOUDRESOURCE (ZTYPE);
  552. CREATE INDEX ZCLOUDRESOURCE_ZASSET_INDEX ON ZCLOUDRESOURCE (ZASSET);
  553. CREATE INDEX ZCLOUDRESOURCE_ZCLOUDMASTER_INDEX ON ZCLOUDRESOURCE (ZCLOUDMASTER);
  554. CREATE INDEX RADAR_22158684_INDEX ON Z_15ASSETS (Z_15ALBUMS,
  555. Z_FOK_22ASSETS,
  556. Z_22ASSETS);
  557. CREATE INDEX RADAR_10322662_INDEX ON Z_15ASSETS (Z_15ALBUMS,
  558. Z_22ASSETS,
  559. Z_FOK_22ASSETS);
  560. CREATE INDEX RADAR_16835859_INDEX ON ZGENERICASSET (ZMOMENT,
  561. Z_FOK_MOMENT);
  562. CREATE INDEX RADAR_16788878_INDEX ON ZMOMENT (ZMOMENTLIBRARY,
  563. Z_FOK_MOMENTLIBRARY);