user_action table definition leads to ineficient queries on mysql

Steps to reproduce

In user_action 2 columns session_id and type are defined as medium text and unidexed

as these are a) limited length fields and b) used in lookups on the table they should be converted to varchar and indexed

Status

Assignee

RĂ¼diger Rolf

Reporter

David Horwitz

Severity

Incorrectly Functioning Without Workaround

Tags (folksonomy)

Components

Fix versions

Affects versions

1.2
1.4.0

Priority

Major
Configure