202
edits
Browser History: Difference between revisions
Jump to navigation
Jump to search
→Database design
BrettWilson (talk | contribs) |
BrettWilson (talk | contribs) |
||
| Line 89: | Line 89: | ||
=== Database design === | === Database design === | ||
The history will be stored in 2 SQL tables: "moz_history" and " | The history will be stored in 2 SQL tables: "moz_history" and "moz_historyvisit". | ||
The "history" table essentially duplicates the functionality of the current mork history table: It contains: | The "history" table essentially duplicates the functionality of the current mork history table: It contains: | ||
| Line 96: | Line 96: | ||
* URL | * URL | ||
* Title | * Title | ||
* User-defined title | |||
* Visit count | * Visit count | ||
* Last visit date | * Last visit date | ||
| Line 106: | Line 107: | ||
The second table stores transitions between pages, which is information unavailable now. | The second table stores transitions between pages, which is information unavailable now. | ||
* Source | * Source *visit* ID | ||
* Destination page ID | * Destination page ID | ||
* Time | * Time | ||
* Transition type | * Transition type | ||
Transition type will hopefully contain info about whether the link was clicked, opened in new tab/window, typed, etc. | 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 === | === Performance === | ||