[
http://opencast.jira.com/browse/MH-8854?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=32296#comment-32296
]
David Horwitz commented on MH-8854:
-----------------------------------
Updated ddls:
mysql> describe user_action
-> ;
+-----------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------+------+-----+---------+-------+
| id | bigint(20) | NO | PRI | NULL | |
| user_ip | varchar(255) | YES | | NULL | |
| outpoint | int(11) | YES | | NULL | |
| inpoint | int(11) | YES | | NULL | |
| mediapackage_id | varchar(255) | YES | | NULL | |
| session_id | varchar(255) | YES | MUL | NULL | |
| created | datetime | YES | | NULL | |
| user_id | varchar(255) | YES | | NULL | |
| length | int(11) | YES | | NULL | |
| type | varchar(255) | YES | | NULL | |
| is_playing | tinyint(1) | YES | | 0 | |
+-----------------+--------------+------+-----+---------+-------+
11 rows in set (0.00 sec)
> 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.4, 1.2
> Reporter: David Horwitz
> Assignee: David Horwitz
> Fix For: 1.4
>
>
--
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]
_______________________________________________
