index_phash

This table contains references to TYPO3 pages or external documents. The fields are like this:

phash

Field

phash

Description

7md5/int hash. It’s an integer based on a 7-char md5-hash.

This is a unique representation of the ‘page’ indexed.

For TYPO3 pages this is a serialization of id,type,gr_list (see later), MP and additional query parameters (which enables ‘subcaching’ with extra parameters). This concept is also used for TYPO3 caching (although the caching hash includes the all-array and thus takes the template into account, which this hash does not! It’s expected that template changes through conditions would not seriously alter the page content)

For external media this is a serialization of 1) unique filename id, 2) any subpage indication (parallel to query parameters). gr_list is NOT taken into consideration here!

phash_grouping

Field

phash_grouping

Description

7md5/int hash.

This is a non-unique hash exactly like phash, but WITHOUT the gr_list and (in addition) for external media without subpage indication. Thus this field will indicate a ‘unique’ page (or file) while this page may exist twice or more due to gr_list. Use this field to GROUP BY the search so you get only one hit per page when selecting with gr_list in mind.

Currently a search result does not either group or limit by this, but rather the result display may group the result into logical units.

item_mtime

Field

item_mtime

Description

Modification time:

For TYPO3 pages: the SYS_LASTCHANGED value

For external media: The filemtime() value.

Depending on config, if mtime hasn’t changed compared to this value the file/page is not indexed again.

tstamp

Field

tstamp

Description

time stamp of the indexing operation. You can configure min/max ages which are checked with this timestamp.

A min-age defines how long an indexed page must be indexed before it’s reconsidered to index it again.

A max-age defines an absolute point at which re-indexing will occur (unless the content has not changed according to an md5-hash)

static_page_arguments

Field

static_page_arguments

Description

The Static Page Arguments - URL parameter that are used for caching.

For TYPO3 pages: These are used to re-generate the actual url of the TYPO3 page in question

For files this is an empty array. Not used.

item_type

Field

item_type

Description

An integer indicating the content type,

0 is TYPO3 pages

1- external files like pdf (2), doc (3), html (1), txt (4) and so on. See the class.indexer.php file

item_title

Field

item_title

Description

Title:

For TYPO3 pages, the page title

For files, the basename of the file (no path)

item_description

Field

item_description

Description

Short description of the item. Top information on the page. Used in search result.

data_page_id

Field

data_page_id

Description

For TYPO3 pages: The id

data_page_type

Field

data_page_type

Description

For TYPO3 pages: The type

data_filename

Field

data_filename

Description

For external files: The filepath (relative) or URL (not used yet)

contentHash

Field

contentHash

Description

md5 hash of the content indexed. Before reindexing this is compared with the content to be indexed and if it matches there is obviously no need for reindexing.

crdate

Field

crdate

Description

The creation date of the INDEXING - not the page/file! (see item_crdate)

parsetime

Field

parsetime

Description

The parsetime of the indexing operation.

sys_language_uid

Field

sys_language_uid

Description

Will contain the value of GLOBALS[“TSFE”]->sys_language_uid, which tells us the language of the page indexed.

item_crdate

Field

item_crdate

Description

The creation date. For files only the modification date can be read from the files, so here it will be the filemtime().

gr_list

Field

gr_list

Description

Contains the gr_list of the user initiating the indexing of the document.