michael@0: /* -*- Mode: C++; tab-width: 2; indent-tabs-mode: nil; c-basic-offset: 2 -*-
michael@0:  * vim: sw=2 ts=2 et lcs=trail\:.,tab\:>~ :
michael@0:  * This Source Code Form is subject to the terms of the Mozilla Public
michael@0:  * License, v. 2.0. If a copy of the MPL was not distributed with this
michael@0:  * file, You can obtain one at http://mozilla.org/MPL/2.0/. */
michael@0: 
michael@0: #ifndef nsPlacesIndexes_h__
michael@0: #define nsPlacesIndexes_h__
michael@0: 
michael@0: #define CREATE_PLACES_IDX(__name, __table, __columns, __type) \
michael@0:   NS_LITERAL_CSTRING( \
michael@0:     "CREATE " __type " INDEX IF NOT EXISTS " __table "_" __name \
michael@0:       " ON " __table " (" __columns ")" \
michael@0:   )
michael@0: 
michael@0: /**
michael@0:  * moz_places
michael@0:  */
michael@0: #define CREATE_IDX_MOZ_PLACES_URL \
michael@0:   CREATE_PLACES_IDX( \
michael@0:     "url_uniqueindex", "moz_places", "url", "UNIQUE" \
michael@0:   )
michael@0: 
michael@0: #define CREATE_IDX_MOZ_PLACES_FAVICON \
michael@0:   CREATE_PLACES_IDX( \
michael@0:     "faviconindex", "moz_places", "favicon_id", "" \
michael@0:   )
michael@0: 
michael@0: #define CREATE_IDX_MOZ_PLACES_REVHOST \
michael@0:   CREATE_PLACES_IDX( \
michael@0:     "hostindex", "moz_places", "rev_host", "" \
michael@0:   )
michael@0: 
michael@0: #define CREATE_IDX_MOZ_PLACES_VISITCOUNT \
michael@0:   CREATE_PLACES_IDX( \
michael@0:     "visitcount", "moz_places", "visit_count", "" \
michael@0:   )
michael@0: 
michael@0: #define CREATE_IDX_MOZ_PLACES_FRECENCY \
michael@0:   CREATE_PLACES_IDX( \
michael@0:     "frecencyindex", "moz_places", "frecency", "" \
michael@0:   )
michael@0: 
michael@0: #define CREATE_IDX_MOZ_PLACES_LASTVISITDATE \
michael@0:   CREATE_PLACES_IDX( \
michael@0:     "lastvisitdateindex", "moz_places", "last_visit_date", "" \
michael@0:   )
michael@0: 
michael@0: #define CREATE_IDX_MOZ_PLACES_GUID \
michael@0:   CREATE_PLACES_IDX( \
michael@0:     "guid_uniqueindex", "moz_places", "guid", "UNIQUE" \
michael@0:   )
michael@0: 
michael@0: /**
michael@0:  * moz_historyvisits
michael@0:  */
michael@0: 
michael@0: #define CREATE_IDX_MOZ_HISTORYVISITS_PLACEDATE \
michael@0:   CREATE_PLACES_IDX( \
michael@0:     "placedateindex", "moz_historyvisits", "place_id, visit_date", "" \
michael@0:   )
michael@0: 
michael@0: #define CREATE_IDX_MOZ_HISTORYVISITS_FROMVISIT \
michael@0:   CREATE_PLACES_IDX( \
michael@0:     "fromindex", "moz_historyvisits", "from_visit", "" \
michael@0:   )
michael@0: 
michael@0: #define CREATE_IDX_MOZ_HISTORYVISITS_VISITDATE \
michael@0:   CREATE_PLACES_IDX( \
michael@0:     "dateindex", "moz_historyvisits", "visit_date", "" \
michael@0:   )
michael@0: 
michael@0: /**
michael@0:  * moz_bookmarks
michael@0:  */
michael@0: 
michael@0: #define CREATE_IDX_MOZ_BOOKMARKS_PLACETYPE \
michael@0:   CREATE_PLACES_IDX( \
michael@0:     "itemindex", "moz_bookmarks", "fk, type", "" \
michael@0:   )
michael@0: 
michael@0: #define CREATE_IDX_MOZ_BOOKMARKS_PARENTPOSITION \
michael@0:   CREATE_PLACES_IDX( \
michael@0:     "parentindex", "moz_bookmarks", "parent, position", "" \
michael@0:   )
michael@0: 
michael@0: #define CREATE_IDX_MOZ_BOOKMARKS_PLACELASTMODIFIED \
michael@0:   CREATE_PLACES_IDX( \
michael@0:     "itemlastmodifiedindex", "moz_bookmarks", "fk, lastModified", "" \
michael@0:   )
michael@0: 
michael@0: #define CREATE_IDX_MOZ_BOOKMARKS_GUID \
michael@0:   CREATE_PLACES_IDX( \
michael@0:     "guid_uniqueindex", "moz_bookmarks", "guid", "UNIQUE" \
michael@0:   )
michael@0: 
michael@0: /**
michael@0:  * moz_annos
michael@0:  */
michael@0: 
michael@0: #define CREATE_IDX_MOZ_ANNOS_PLACEATTRIBUTE \
michael@0:   CREATE_PLACES_IDX( \
michael@0:     "placeattributeindex", "moz_annos", "place_id, anno_attribute_id", "UNIQUE" \
michael@0:   )
michael@0: 
michael@0: /**
michael@0:  * moz_items_annos
michael@0:  */
michael@0: 
michael@0: #define CREATE_IDX_MOZ_ITEMSANNOS_PLACEATTRIBUTE \
michael@0:   CREATE_PLACES_IDX( \
michael@0:     "itemattributeindex", "moz_items_annos", "item_id, anno_attribute_id", "UNIQUE" \
michael@0:   )
michael@0: 
michael@0: /**
michael@0:  * moz_favicons
michael@0:  */
michael@0: 
michael@0: #define CREATE_IDX_MOZ_FAVICONS_GUID \
michael@0:   CREATE_PLACES_IDX( \
michael@0:     "guid_uniqueindex", "moz_favicons", "guid", "UNIQUE" \
michael@0:   )
michael@0: 
michael@0: #endif // nsPlacesIndexes_h__