202
edits
Changes
→Database design
=== Database design ===
The history will be stored in 2 SQL tables: "moz_history" and "moz_historyviewmoz_historyvisit".
The "history" table essentially duplicates the functionality of the current mork history table: It contains:
* URL
* Title
* User-defined title
* Visit count
* Last visit date
The second table stores transitions between pages, which is information unavailable now.
* Source page *visit* ID
* Destination page ID
* Time
* Transition type
Transition type will hopefully contain info about whether the link was a redirect clicked, opened in new tab/window, typed, just an image on the page, etc. Because the source for each visit is another visit, not just a URL, we can track transitions between specific viewings of pages.
=== Performance ===
