API tools faq
paste
Guest User

Untitled

a guest
Jan 8th, 2019
648
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 15.99 KB | None | 0 0
raw download clone embed print report
  1. CREATE TABLE ZADDITIONALINFORMATIONMODEL ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZRECIPE INTEGER, Z_FOK_RECIPE INTEGER, ZCONTENT VARCHAR, ZTYPE VARCHAR );
  2. CREATE TABLE ZCALENDARITEMMODEL ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZSORTORDER INTEGER, ZRECIPE INTEGER, ZDATECREATED TIMESTAMP, ZDATEMODIFIED TIMESTAMP, ZDUEDATE TIMESTAMP, ZCALENDARITEMID VARCHAR, ZRECIPEID VARCHAR );
  3. CREATE TABLE ZCATEGORYMODEL ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZHASATLEASTONEVALIDRECIPE INTEGER, ZCATEGORYID VARCHAR, ZCOLORCODE VARCHAR, ZDEFAULTSUBTITLE VARCHAR, ZDEFAULTTITLE VARCHAR, ZASSETS BLOB, ZLOCALIZEDSUBTITLES BLOB, ZLOCALIZEDTITLES BLOB );
  4. CREATE TABLE Z_3COLLECTIONS ( Z_3CATEGORIES INTEGER, Z_4COLLECTIONS INTEGER, PRIMARY KEY (Z_3CATEGORIES, Z_4COLLECTIONS) );
  5. CREATE TABLE Z_3RECIPES ( Z_3CATEGORIES1 INTEGER, Z_14RECIPES INTEGER, PRIMARY KEY (Z_3CATEGORIES1, Z_14RECIPES) );
  6. CREATE TABLE ZCOLLECTIONMODEL ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZBESTSELLINGRANKING INTEGER, ZFAVORITECOUNT INTEGER, ZISFAVORITE INTEGER, ZISNEWCOLLECTION INTEGER, ZISVALID INTEGER, ZLATESTRELEASESORDER INTEGER, ZORDER INTEGER, ZOWNING INTEGER, ZTHERMOMIXVERSIONNUMBER INTEGER, ZLATESTRELEASESCONTAINER INTEGER, ZNOTE INTEGER, Z_FOK_LATESTRELEASESCONTAINER INTEGER, ZPUBLICATIONDATE TIMESTAMP, ZPURCHASEDATE TIMESTAMP, ZBOOKCOLOR VARCHAR, ZCOLLECTIONID VARCHAR, ZDESCRIPTIONTEXT VARCHAR, ZLOCALE VARCHAR, ZPURCHASEITEMID VARCHAR, ZSTATUS VARCHAR, ZSUBTITLE VARCHAR, ZTITLE VARCHAR, ZASSETS BLOB, ZCATEGORYIDS BLOB, ZRECIPEIDS BLOB, ZRECIPEIDSV2 BLOB, ZTAGIDS BLOB );
  7. CREATE TABLE Z_4RECIPES ( Z_4COLLECTIONS1 INTEGER, Z_14RECIPES1 INTEGER, PRIMARY KEY (Z_4COLLECTIONS1, Z_14RECIPES1) );
  8. CREATE TABLE Z_4TAGS ( Z_4COLLECTIONS2 INTEGER, Z_29TAGS INTEGER, PRIMARY KEY (Z_4COLLECTIONS2, Z_29TAGS) );
  9. CREATE TABLE ZCUSTOMLIST ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZSORTKEY INTEGER, ZSYNCSTATE INTEGER, ZDATECREATED TIMESTAMP, ZDATEMODIFIED TIMESTAMP, ZCUSTOMLISTID VARCHAR, ZTITLE VARCHAR, ZRECIPEIDS BLOB );
  10. CREATE TABLE ZEDITORPICKMODEL ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZORDER INTEGER, ZRECIPE INTEGER, ZAUTHOR VARCHAR, ZPICKID VARCHAR, ZQUOTE VARCHAR, ZRECIPEID VARCHAR, ZASSETS BLOB );
  11. CREATE TABLE ZINGREDIENTMODEL ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZSHOPPINGCATEGORY INTEGER, ZDEFAULTTITLE VARCHAR, ZINGREDIENTID VARCHAR, ZSHOPPINGCATEGORYID VARCHAR, ZLOCALIZEDADDITIONALTITLES BLOB, ZLOCALIZEDTITLES BLOB );
  12. CREATE TABLE Z_7RECIPES ( Z_7INGREDIENTS INTEGER, Z_14RECIPES2 INTEGER, Z_FOK_7INGREDIENTS INTEGER, PRIMARY KEY (Z_7INGREDIENTS, Z_14RECIPES2) );
  13. CREATE TABLE ZNEWRELEASESCONTAINERMODEL ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZCOLLECTIONIDS BLOB );
  14. CREATE TABLE ZNOTEMODEL ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZCOLLECTION INTEGER, ZRECIPE INTEGER, ZDATECREATED TIMESTAMP, ZDATEMODIFIED TIMESTAMP, ZDUEDATE TIMESTAMP, ZCONTENT VARCHAR, ZNOTEID VARCHAR, ZTYPE VARCHAR );
  15. CREATE TABLE ZNUTRITIONGROUPMODEL ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZRECIPE INTEGER, Z_FOK_RECIPE INTEGER, ZNAME VARCHAR, ZRECIPENUTRITIONS BLOB );
  16. CREATE TABLE ZOVERLAYMODEL ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZORDER INTEGER, ZASSETS BLOB );
  17. CREATE TABLE ZRECIPEINGREDIENTGROUPMODEL ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZRECIPE INTEGER, Z_FOK_RECIPE INTEGER, ZTITLE VARCHAR );
  18. CREATE TABLE ZRECIPEINGREDIENTMODEL ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZOPTIONAL INTEGER, ZINGREDIENT INTEGER, ZRECIPEINGREDIENTGROUP INTEGER, ZUNIT INTEGER, Z_FOK_RECIPEINGREDIENTGROUP INTEGER, ZINGREDIENTID VARCHAR, ZINGREDIENTNOTATION VARCHAR, ZPREPARATION VARCHAR, ZRECIPEINGREDIENTID VARCHAR, ZRECIPEINGREDIENTIDV2 VARCHAR, ZUNITID VARCHAR, ZUNITNOTATION VARCHAR, ZQUANTITY BLOB );
  19. CREATE TABLE ZRECIPEMODEL ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZACTIVETIME INTEGER, ZCOMPATIBLEVERSION INTEGER, ZFAVORITECOUNT INTEGER, ZISFAVORITE INTEGER, ZISNEWRECIPE INTEGER, ZISVALID INTEGER, ZORDER INTEGER, ZOWNING INTEGER, ZRECIPEINGREDIENTGROUPSCOUNT INTEGER, ZSERVINGSIZECOUNT INTEGER, ZTHERMOMIXVERSION INTEGER, ZTOTALTIME INTEGER, ZEDITORPICK INTEGER, ZNOTE INTEGER, ZSERVINGSIZE INTEGER, ZWEEKLYSUGGESTION INTEGER, ZSTUBLOADEDAT TIMESTAMP, ZDIFFICULTY VARCHAR, ZLOCALE VARCHAR, ZPRICELEVEL VARCHAR, ZRECIPEID VARCHAR, ZRECIPEIDV2 VARCHAR, ZSTATUS VARCHAR, ZTITLE VARCHAR, ZASSETS BLOB, ZCATEGORYIDS BLOB, ZINGREDIENTIDS BLOB, ZTAGIDS BLOB, ZTIMES BLOB );
  20. CREATE TABLE Z_14TAGS ( Z_14RECIPES3 INTEGER, Z_29TAGS1 INTEGER, PRIMARY KEY (Z_14RECIPES3, Z_29TAGS1) );
  21. CREATE TABLE ZRECIPESTEPGROUPMODEL ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZRECIPE INTEGER, Z_FOK_RECIPE INTEGER, ZTITLE VARCHAR );
  22. CREATE TABLE ZRECIPESTEPMODEL ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZRECIPESTEPGROUP INTEGER, Z_FOK_RECIPESTEPGROUP INTEGER, ZFORMATTEDTEXT VARCHAR, ZRECIPESTEPID VARCHAR, ZTITLE VARCHAR, ZASSETS BLOB, ZUTENSILIDS BLOB );
  23. CREATE TABLE Z_16UTENSILS ( Z_16RECIPESTEPS INTEGER, Z_31UTENSILS INTEGER, Z_FOK_31UTENSILS INTEGER, PRIMARY KEY (Z_16RECIPESTEPS, Z_31UTENSILS) );
  24. CREATE TABLE ZRECIPEUTENSILMODEL ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZRECIPE INTEGER, ZUTENSIL INTEGER, Z_FOK_RECIPE INTEGER, ZUTENSILID VARCHAR, ZUTENSILNOTATION VARCHAR, ZQUANTITY BLOB );
  25. CREATE TABLE ZSEARCHHISTORYMODEL ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDATEADDED TIMESTAMP, ZSEARCHITEM VARCHAR );
  26. CREATE TABLE ZSELECTIONITEMMODEL ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDATEADDED TIMESTAMP, ZITEMID VARCHAR, ZITEMTYPE VARCHAR, ZSELECTIONITEMID VARCHAR, ZSELECTIONTYPE VARCHAR );
  27. CREATE TABLE ZSERVINGSIZEMODEL ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZUNIT INTEGER, ZCOMMENT VARCHAR, ZUNITID VARCHAR, ZUNITNOTATION VARCHAR, ZQUANTITY BLOB );
  28. CREATE TABLE ZSHOPPINGCATEGORYMODEL ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZINGREDIENT INTEGER, ZDEFAULTTITLE VARCHAR, ZSHOPPINGCATEGORYID VARCHAR, ZLOCALIZEDTITLES BLOB );
  29. CREATE TABLE ZSHOPPINGLISTITEMMODEL ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZCROSSEDOUT INTEGER, ZMODIFIED INTEGER, ZSHOPPINGLIST INTEGER, ZMULTIPLICATIONVALUE INTEGER, ZCALENDARITEM INTEGER, ZRECIPEINGREDIENT INTEGER, ZSHOPPINGLIST1 INTEGER, ZUNIT INTEGER, ZMULTIPLICATIONVALUE1 INTEGER, ZRECIPEUTENSIL INTEGER, ZSHOPPINGLIST2 INTEGER, ZUTENSIL INTEGER, Z_FOK_SHOPPINGLIST INTEGER, Z_FOK_SHOPPINGLIST1 INTEGER, Z_FOK_SHOPPINGLIST2 INTEGER, ZDATECREATED TIMESTAMP, ZDATEMODIFIED TIMESTAMP, ZDUEDATE TIMESTAMP, ZITEMID VARCHAR, ZDESCRIPTIONTEXT VARCHAR, ZMODIFIEDUNITID VARCHAR, ZRECIPEID VARCHAR, ZRECIPEINGREDIENTID VARCHAR, ZSHOPPINGCATEGORYID VARCHAR, ZRECIPEID1 VARCHAR, ZUTENSILID VARCHAR, ZMODIFIEDQUANTITY BLOB, ZADDITIONALQUANTITY BLOB, ZQUANTITY BLOB );
  30. CREATE TABLE ZSHOPPINGLISTMODEL ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER );
  31. CREATE TABLE ZSTEPINGREDIENTMODEL ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZINGREDIENT INTEGER, ZRECIPEINGREDIENT INTEGER, ZRECIPESTEP INTEGER, Z_FOK_RECIPEINGREDIENT INTEGER, Z_FOK_RECIPESTEP INTEGER, ZINGREDIENTID VARCHAR, ZRECIPEINGREDIENTID VARCHAR, ZQUANTITY BLOB );
  32. CREATE TABLE ZTAGCATEGORYMODEL ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZISVALID INTEGER, ZTAGCATEGORYID VARCHAR, ZTAGCATEGORYNAME VARCHAR );
  33. CREATE TABLE ZTAGMODEL ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZISVALID INTEGER, ZTAGCATEGORY INTEGER, ZTAGID VARCHAR, ZTAGNAME VARCHAR );
  34. CREATE TABLE ZUNITMODEL ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZRECIPEINGREDIENT INTEGER, ZSERVINGSIZE INTEGER, ZDEFAULTTITLE VARCHAR, ZTYPE VARCHAR, ZUNITID VARCHAR, ZLOCALIZEDTITLES BLOB );
  35. CREATE TABLE ZUTENSILMODEL ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZDEFAULTTITLE VARCHAR, ZTYPE VARCHAR, ZUTENSILID VARCHAR, ZLOCALIZEDADDITIONALTITLES BLOB, ZLOCALIZEDTITLES BLOB );
  36. CREATE TABLE ZWEEKLYSUGGESTIONMODEL ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZORDER INTEGER, ZRECIPE INTEGER, ZRECIPEID VARCHAR, ZTITLE VARCHAR, ZWEEKLYSUGGESTIONID VARCHAR, ZASSETS BLOB );
  37. CREATE INDEX ZADDITIONALINFORMATIONMODEL_ZRECIPE_INDEX ON ZADDITIONALINFORMATIONMODEL (ZRECIPE);
  38. CREATE INDEX ZCALENDARITEMMODEL_ZRECIPE_INDEX ON ZCALENDARITEMMODEL (ZRECIPE);
  39. CREATE INDEX Z_CalendarItemModel_calendarItemID ON ZCALENDARITEMMODEL (ZCALENDARITEMID COLLATE BINARY ASC);
  40. CREATE INDEX Z_CalendarItemModel_recipeID ON ZCALENDARITEMMODEL (ZRECIPEID COLLATE BINARY ASC);
  41. CREATE INDEX Z_3COLLECTIONS_Z_4COLLECTIONS_INDEX ON Z_3COLLECTIONS (Z_4COLLECTIONS, Z_3CATEGORIES);
  42. CREATE INDEX Z_3RECIPES_Z_14RECIPES_INDEX ON Z_3RECIPES (Z_14RECIPES, Z_3CATEGORIES1);
  43. CREATE INDEX Z_CategoryModel_categoryID ON ZCATEGORYMODEL (ZCATEGORYID COLLATE BINARY ASC);
  44. CREATE INDEX ZCOLLECTIONMODEL_ZLATESTRELEASESCONTAINER_INDEX ON ZCOLLECTIONMODEL (ZLATESTRELEASESCONTAINER);
  45. CREATE INDEX ZCOLLECTIONMODEL_ZNOTE_INDEX ON ZCOLLECTIONMODEL (ZNOTE);
  46. CREATE INDEX Z_4RECIPES_Z_14RECIPES1_INDEX ON Z_4RECIPES (Z_14RECIPES1, Z_4COLLECTIONS1);
  47. CREATE INDEX Z_4TAGS_Z_29TAGS_INDEX ON Z_4TAGS (Z_29TAGS, Z_4COLLECTIONS2);
  48. CREATE INDEX Z_CollectionModel_collectionID ON ZCOLLECTIONMODEL (ZCOLLECTIONID COLLATE BINARY ASC);
  49. CREATE INDEX Z_CollectionModel_purchaseItemID ON ZCOLLECTIONMODEL (ZPURCHASEITEMID COLLATE BINARY ASC);
  50. CREATE INDEX ZEDITORPICKMODEL_ZRECIPE_INDEX ON ZEDITORPICKMODEL (ZRECIPE);
  51. CREATE INDEX Z_EditorPickModel_pickID ON ZEDITORPICKMODEL (ZPICKID COLLATE BINARY ASC);
  52. CREATE INDEX Z_EditorPickModel_recipeID ON ZEDITORPICKMODEL (ZRECIPEID COLLATE BINARY ASC);
  53. CREATE INDEX ZINGREDIENTMODEL_ZSHOPPINGCATEGORY_INDEX ON ZINGREDIENTMODEL (ZSHOPPINGCATEGORY);
  54. CREATE INDEX Z_7RECIPES_Z_14RECIPES2_INDEX ON Z_7RECIPES (Z_14RECIPES2, Z_7INGREDIENTS);
  55. CREATE INDEX Z_IngredientModel_ingredientID ON ZINGREDIENTMODEL (ZINGREDIENTID COLLATE BINARY ASC);
  56. CREATE INDEX Z_IngredientModel_shoppingCategoryID ON ZINGREDIENTMODEL (ZSHOPPINGCATEGORYID COLLATE BINARY ASC);
  57. CREATE INDEX ZNOTEMODEL_ZCOLLECTION_INDEX ON ZNOTEMODEL (ZCOLLECTION);
  58. CREATE INDEX ZNOTEMODEL_ZRECIPE_INDEX ON ZNOTEMODEL (ZRECIPE);
  59. CREATE INDEX Z_NoteModel_noteID ON ZNOTEMODEL (ZNOTEID COLLATE BINARY ASC);
  60. CREATE INDEX ZNUTRITIONGROUPMODEL_ZRECIPE_INDEX ON ZNUTRITIONGROUPMODEL (ZRECIPE);
  61. CREATE INDEX ZRECIPEINGREDIENTGROUPMODEL_ZRECIPE_INDEX ON ZRECIPEINGREDIENTGROUPMODEL (ZRECIPE);
  62. CREATE INDEX ZRECIPEINGREDIENTMODEL_ZINGREDIENT_INDEX ON ZRECIPEINGREDIENTMODEL (ZINGREDIENT);
  63. CREATE INDEX ZRECIPEINGREDIENTMODEL_ZRECIPEINGREDIENTGROUP_INDEX ON ZRECIPEINGREDIENTMODEL (ZRECIPEINGREDIENTGROUP);
  64. CREATE INDEX ZRECIPEINGREDIENTMODEL_ZUNIT_INDEX ON ZRECIPEINGREDIENTMODEL (ZUNIT);
  65. CREATE INDEX Z_RecipeIngredientModel_ingredientID ON ZRECIPEINGREDIENTMODEL (ZINGREDIENTID COLLATE BINARY ASC);
  66. CREATE INDEX Z_RecipeIngredientModel_recipeIngredientID ON ZRECIPEINGREDIENTMODEL (ZRECIPEINGREDIENTID COLLATE BINARY ASC);
  67. CREATE INDEX Z_RecipeIngredientModel_unitID ON ZRECIPEINGREDIENTMODEL (ZUNITID COLLATE BINARY ASC);
  68. CREATE INDEX ZRECIPEMODEL_ZEDITORPICK_INDEX ON ZRECIPEMODEL (ZEDITORPICK);
  69. CREATE INDEX ZRECIPEMODEL_ZNOTE_INDEX ON ZRECIPEMODEL (ZNOTE);
  70. CREATE INDEX ZRECIPEMODEL_ZSERVINGSIZE_INDEX ON ZRECIPEMODEL (ZSERVINGSIZE);
  71. CREATE INDEX ZRECIPEMODEL_ZWEEKLYSUGGESTION_INDEX ON ZRECIPEMODEL (ZWEEKLYSUGGESTION);
  72. CREATE INDEX Z_14TAGS_Z_29TAGS1_INDEX ON Z_14TAGS (Z_29TAGS1, Z_14RECIPES3);
  73. CREATE INDEX Z_RecipeModel_recipeID ON ZRECIPEMODEL (ZRECIPEID COLLATE BINARY ASC);
  74. CREATE INDEX ZRECIPESTEPGROUPMODEL_ZRECIPE_INDEX ON ZRECIPESTEPGROUPMODEL (ZRECIPE);
  75. CREATE INDEX ZRECIPESTEPMODEL_ZRECIPESTEPGROUP_INDEX ON ZRECIPESTEPMODEL (ZRECIPESTEPGROUP);
  76. CREATE INDEX Z_16UTENSILS_Z_31UTENSILS_INDEX ON Z_16UTENSILS (Z_31UTENSILS, Z_16RECIPESTEPS);
  77. CREATE INDEX ZRECIPEUTENSILMODEL_ZRECIPE_INDEX ON ZRECIPEUTENSILMODEL (ZRECIPE);
  78. CREATE INDEX ZRECIPEUTENSILMODEL_ZUTENSIL_INDEX ON ZRECIPEUTENSILMODEL (ZUTENSIL);
  79. CREATE INDEX Z_RecipeUtensilModel_utensilID ON ZRECIPEUTENSILMODEL (ZUTENSILID COLLATE BINARY ASC);
  80. CREATE INDEX Z_SelectionItemModel_itemID ON ZSELECTIONITEMMODEL (ZITEMID COLLATE BINARY ASC);
  81. CREATE INDEX Z_SelectionItemModel_itemType ON ZSELECTIONITEMMODEL (ZITEMTYPE COLLATE BINARY ASC);
  82. CREATE INDEX Z_SelectionItemModel_selectionItemID ON ZSELECTIONITEMMODEL (ZSELECTIONITEMID COLLATE BINARY ASC);
  83. CREATE INDEX Z_SelectionItemModel_selectionType ON ZSELECTIONITEMMODEL (ZSELECTIONTYPE COLLATE BINARY ASC);
  84. CREATE INDEX ZSERVINGSIZEMODEL_ZUNIT_INDEX ON ZSERVINGSIZEMODEL (ZUNIT);
  85. CREATE INDEX Z_ServingSizeModel_unitID ON ZSERVINGSIZEMODEL (ZUNITID COLLATE BINARY ASC);
  86. CREATE INDEX ZSHOPPINGCATEGORYMODEL_ZINGREDIENT_INDEX ON ZSHOPPINGCATEGORYMODEL (ZINGREDIENT);
  87. CREATE INDEX Z_ShoppingCategoryModel_shoppingCategoryID ON ZSHOPPINGCATEGORYMODEL (ZSHOPPINGCATEGORYID COLLATE BINARY ASC);
  88. CREATE INDEX ZSHOPPINGLISTITEMMODEL_ZSHOPPINGLIST_INDEX ON ZSHOPPINGLISTITEMMODEL (ZSHOPPINGLIST);
  89. CREATE INDEX ZSHOPPINGLISTITEMMODEL_ZCALENDARITEM_INDEX ON ZSHOPPINGLISTITEMMODEL (ZCALENDARITEM);
  90. CREATE INDEX ZSHOPPINGLISTITEMMODEL_ZRECIPEINGREDIENT_INDEX ON ZSHOPPINGLISTITEMMODEL (ZRECIPEINGREDIENT);
  91. CREATE INDEX ZSHOPPINGLISTITEMMODEL_ZSHOPPINGLIST1_INDEX ON ZSHOPPINGLISTITEMMODEL (ZSHOPPINGLIST1);
  92. CREATE INDEX ZSHOPPINGLISTITEMMODEL_ZUNIT_INDEX ON ZSHOPPINGLISTITEMMODEL (ZUNIT);
  93. CREATE INDEX ZSHOPPINGLISTITEMMODEL_ZRECIPEUTENSIL_INDEX ON ZSHOPPINGLISTITEMMODEL (ZRECIPEUTENSIL);
  94. CREATE INDEX ZSHOPPINGLISTITEMMODEL_ZSHOPPINGLIST2_INDEX ON ZSHOPPINGLISTITEMMODEL (ZSHOPPINGLIST2);
  95. CREATE INDEX ZSHOPPINGLISTITEMMODEL_ZUTENSIL_INDEX ON ZSHOPPINGLISTITEMMODEL (ZUTENSIL);
  96. CREATE INDEX ZSHOPPINGLISTITEMMODEL_Z_ENT_INDEX ON ZSHOPPINGLISTITEMMODEL (Z_ENT);
  97. CREATE INDEX Z_ShoppingListItemModel_itemID ON ZSHOPPINGLISTITEMMODEL (ZITEMID COLLATE BINARY ASC);
  98. CREATE INDEX Z_ShoppinglistIngredientItemModel_modifiedUnitID ON ZSHOPPINGLISTITEMMODEL (ZMODIFIEDUNITID COLLATE BINARY ASC);
  99. CREATE INDEX Z_ShoppinglistIngredientItemModel_recipeID ON ZSHOPPINGLISTITEMMODEL (ZRECIPEID COLLATE BINARY ASC);
  100. CREATE INDEX Z_ShoppinglistIngredientItemModel_recipeIngredientID ON ZSHOPPINGLISTITEMMODEL (ZRECIPEINGREDIENTID COLLATE BINARY ASC);
  101. CREATE INDEX Z_ShoppinglistIngredientItemModel_shoppingCategoryID ON ZSHOPPINGLISTITEMMODEL (ZSHOPPINGCATEGORYID COLLATE BINARY ASC);
  102. CREATE INDEX Z_ShoppinglistUtensilItemModel_recipeID ON ZSHOPPINGLISTITEMMODEL (ZRECIPEID1 COLLATE BINARY ASC);
  103. CREATE INDEX Z_ShoppinglistUtensilItemModel_utensilID ON ZSHOPPINGLISTITEMMODEL (ZUTENSILID COLLATE BINARY ASC);
  104. CREATE INDEX ZSTEPINGREDIENTMODEL_ZINGREDIENT_INDEX ON ZSTEPINGREDIENTMODEL (ZINGREDIENT);
  105. CREATE INDEX ZSTEPINGREDIENTMODEL_ZRECIPEINGREDIENT_INDEX ON ZSTEPINGREDIENTMODEL (ZRECIPEINGREDIENT);
  106. CREATE INDEX ZSTEPINGREDIENTMODEL_ZRECIPESTEP_INDEX ON ZSTEPINGREDIENTMODEL (ZRECIPESTEP);
  107. CREATE INDEX Z_StepIngredientModel_ingredientID ON ZSTEPINGREDIENTMODEL (ZINGREDIENTID COLLATE BINARY ASC);
  108. CREATE INDEX Z_StepIngredientModel_recipeIngredientID ON ZSTEPINGREDIENTMODEL (ZRECIPEINGREDIENTID COLLATE BINARY ASC);
  109. CREATE INDEX Z_TagCategoryModel_tagCategoryID ON ZTAGCATEGORYMODEL (ZTAGCATEGORYID COLLATE BINARY ASC);
  110. CREATE INDEX ZTAGMODEL_ZTAGCATEGORY_INDEX ON ZTAGMODEL (ZTAGCATEGORY);
  111. CREATE INDEX Z_TagModel_tagID ON ZTAGMODEL (ZTAGID COLLATE BINARY ASC);
  112. CREATE INDEX ZUNITMODEL_ZRECIPEINGREDIENT_INDEX ON ZUNITMODEL (ZRECIPEINGREDIENT);
  113. CREATE INDEX ZUNITMODEL_ZSERVINGSIZE_INDEX ON ZUNITMODEL (ZSERVINGSIZE);
  114. CREATE INDEX Z_UnitModel_unitID ON ZUNITMODEL (ZUNITID COLLATE BINARY ASC);
  115. CREATE INDEX Z_UtensilModel_utensilID ON ZUTENSILMODEL (ZUTENSILID COLLATE BINARY ASC);
  116. CREATE INDEX ZWEEKLYSUGGESTIONMODEL_ZRECIPE_INDEX ON ZWEEKLYSUGGESTIONMODEL (ZRECIPE);
  117. CREATE INDEX Z_WeeklySuggestionModel_recipeID ON ZWEEKLYSUGGESTIONMODEL (ZRECIPEID COLLATE BINARY ASC);
  118. CREATE INDEX Z_WeeklySuggestionModel_weeklySuggestionID ON ZWEEKLYSUGGESTIONMODEL (ZWEEKLYSUGGESTIONID COLLATE BINARY ASC);
  119. CREATE TABLE Z_PRIMARYKEY (Z_ENT INTEGER PRIMARY KEY, Z_NAME VARCHAR, Z_SUPER INTEGER, Z_MAX INTEGER);
  120. CREATE TABLE Z_METADATA (Z_VERSION INTEGER PRIMARY KEY, Z_UUID VARCHAR(255), Z_PLIST BLOB);
  121. CREATE TABLE Z_MODELCACHE (Z_CONTENT BLOB);
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!