index_phash

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

phash

Changed in version 13.0

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

Field
phash
Description

Stores an 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

Changed in version 13.0

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

Field
phash_grouping
Description

Stores an md5 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

Changed in version 13.0

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

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 the language of the page being 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.