mirror of
https://github.com/DanielSiepmann/tracking.git
synced 2024-05-02 10:37:44 +02:00
Daniel Siepmann
6cef293298
TYPO3 queries information of translations. The fix adds database indices which are also applied for tt_content by TYPO3 itself. This fixes slow loading times of the list module.
22 lines
658 B
SQL
22 lines
658 B
SQL
CREATE TABLE tx_tracking_pageview (
|
|
url text,
|
|
user_agent text,
|
|
operating_system varchar(255) DEFAULT '' NOT NULL,
|
|
type int(11) unsigned DEFAULT '0' NOT NULL,
|
|
|
|
KEY page_views_per_page (pid,uid,crdate),
|
|
KEY language (l10n_parent,sys_language_uid),
|
|
);
|
|
|
|
CREATE TABLE tx_tracking_recordview (
|
|
url text,
|
|
user_agent text,
|
|
operating_system varchar(255) DEFAULT '' NOT NULL,
|
|
record varchar(255) DEFAULT '' NOT NULL,
|
|
record_uid int(11) unsigned DEFAULT '0' NOT NULL,
|
|
record_table_name varchar(255) DEFAULT '' NOT NULL,
|
|
|
|
KEY record_views_per_page (pid,uid,crdate),
|
|
KEY language (l10n_parent,sys_language_uid),
|
|
);
|