index_section

Points out the section where an entry in index_phash belongs.

phash

Changed in version 13.0

The field has been transformed to a varchar field, full md5 hashes are stored.

Field
phash
Description
The md5 hash of the indexed document.

phash_t3

Changed in version 13.0

The field has been transformed to a varchar field, full md5 hashes are stored.

Field
phash_t3
Description

The md5 hash of the "parent" TYPO3 page of the indexed document.

If the "document" being indexed is a TYPO3 page, then phash and phash_t3 are the same.

But if the document is an external file (PDF, Word etc) which are found as a LINK on a TYPO3 page, then this phash_t3 points to the phash of that TYPO3 page. Normally it goes like this when indexing: 1) The TYPO3 document is indexed (this has a phash-value of course), then 2) if any external files are found on the page, they are indexed as well AND their phash_t3 will become the phash of the TYPO3 page they were on.

The significance of this value is that indexed external files may have more than one record in "index_section" (with the same phash), a record for each parent page where a link to the document was found! There are details about this in the section of this document that describes the complexities of indexing pages.

rl0

Field
rl0
Description
The id of the root-page of the site.

rl1

Field
rl1
Description
The id of the level-1 page (if any) of the indexed page.

rl2

Field
rl2
Description
The id of the level-2 page (if any) of the indexed page.

page_id

Field
page_id
Description
The page id of the indexed page.

uniqid

Field
uniqid
Description
This is just an autoincremented unique, primary key. Generally not used (i think)