forked from openfoodfacts/openfoodfacts-server
-
Notifications
You must be signed in to change notification settings - Fork 1
/
mongodb_indexes.txt
67 lines (65 loc) · 5.64 KB
/
mongodb_indexes.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
db.products.createIndex({"last_modified_t": -1}, { background: true });
db.products.createIndex({"created_t": -1}, { background: true });
db.products.createIndex({countries_tags:1,"popularity_key": -1}, { background: true });
db.products.createIndex({_keywords:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({creator:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({countries_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({brands_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({categories_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({labels_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({packaging_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({origins_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({manufacturing_places_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({emb_codes_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({ingredients_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({additives_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({vitamins_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({minerals_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({amino_acids_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({nucleotides_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({allergens_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({traces_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({nova_groups_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({nutrition_grades_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({languages_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({creator_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({editors_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({states_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({entry_dates_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({last_edit_dates_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({codes_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({nutrient_levels_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({stores_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({informers_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({photographers_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({checkers_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({correctors_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({ingredients_from_palm_oil_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({ingredients_that_may_be_from_palm_oil_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({purchase_places_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({ingredients_n_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({pnns_groups_1_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({pnns_groups_2_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({misc_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({quality_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({unknown_nutrients_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({last_image_dates_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({cities_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({ingredients_analysis_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({popularity_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({data_sources_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({data_quality_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({data_quality_bugs_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({data_quality_info_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({data_quality_warnings_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({data_quality_errors_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({teams_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({categories_properties_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({owners_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({ecoscore_tags:1,"last_modified_t": -1}, { background: true });
db.products.createIndex({nutriscore_score_opposite: -1}, { background: true });
db.products.createIndex({ecoscore_score: -1}, { background: true });
db.products.createIndex({popularity_key: -1}, { background: true });
db.products.createIndex({countries_tags:1,"last_modified_t": -1}, { background: true });
# for off-pro only:
db.products.createIndex({owner:1, countries_tags:1, "last_modified_t": -1}, { background: true });