[
http://opencast.jira.com/browse/MH-8854?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=30824#comment-30824
]
Stephen Marquard commented on MH-8854:
--------------------------------------
The other mediumtext fields in this table should also be varchars: user_ip,
mediapackage_id, user_id.
+-----------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------+------+-----+---------+-------+
| id | bigint(20) | NO | PRI | NULL | |
| user_ip | mediumtext | YES | | NULL | |
| outpoint | int(11) | YES | | NULL | |
| inpoint | int(11) | YES | | NULL | |
| mediapackage_id | mediumtext | YES | | NULL | |
| session_id | varchar(255) | YES | MUL | NULL | |
| created | datetime | YES | | NULL | |
| user_id | mediumtext | YES | | NULL | |
| length | int(11) | YES | | NULL | |
| type | varchar(255) | YES | MUL | NULL | |
| is_playing | tinyint(1) | YES | | 0 | |
+-----------------+--------------+------+-----+---------+-------+
> user_action table definition leads to ineficient queries on mysql
> -----------------------------------------------------------------
>
> Key: MH-8854
> URL: http://opencast.jira.com/browse/MH-8854
> Project: Matterhorn Project
> Issue Type: Bug
> Components: Architecture & Services
> Affects Versions: 1.2
> Reporter: David Horwitz
> Assignee: Ruediger Rolf
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
http://opencast.jira.com/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
Matterhorn mailing list
[email protected]
http://lists.opencastproject.org/mailman/listinfo/matterhorn
To unsubscribe please email
[email protected]
_______________________________________________
