firefox - Sqlite command to add history index -

what's sqlite translation add index both moz_historyvisits , moz_places in places.sqlite in mozilla folder? 1 line answer great question =). thanks, dude

the default index definitions these tables this:

create index moz_historyvisits_dateindex on moz_historyvisits (visit_date); create index moz_historyvisits_fromindex on moz_historyvisits (from_visit); create index moz_historyvisits_placedateindex on moz_historyvisits (place_id, visit_date); create index moz_places_faviconindex on moz_places (favicon_id); create index moz_places_frecencyindex on moz_places (frecency); create unique index moz_places_guid_uniqueindex on moz_places (guid); create index moz_places_hostindex on moz_places (rev_host); create index moz_places_lastvisitdateindex on moz_places (last_visit_date); create unique index moz_places_url_uniqueindex on moz_places (url); create index moz_places_visitcount on moz_places (visit_count);