[Building Sakai] Duplicate Unique Keys on mfr_area_t

[Mike Jennings]

Sam,

Thanks so much for the quick response.  I will file a jira on this.

Mike

On 1/30/2012 7:38 PM, Sam Ottenhoff wrote:
> Duplicate unique keys will slow database inserts in the table. Please
> file a JIRA!
>
> --Sam
>
> On Mon, Jan 30, 2012 at 7:35 PM, Mike Jennings <mike_jennings at unc.edu
> <mailto:mike_jennings at unc.edu>> wrote:
>
>     I was looking at the primary keys that UNC currently has running on the
>     MFR_AREA_T table and found that it seems to have two unique keys on the
>     table.
>
>     CREATE UNIQUE INDEX CONTEXT_ID
>     ON MFR_AREA_T(CONTEXT_ID, TYPE_UUID);
>
>     CREATE UNIQUE INDEX MFR_AREA_CONTEXT_UUID_UNIQUE
>     ON MFR_AREA_T(CONTEXT_ID, TYPE_UUID);
>
>     Does this seem to be valid?
>
>     We are currently running Sakai 2.7 with MSGCNTR 2.7.5.
>
>     Based on the information here
>
>     https://source.sakaiproject.org/svn/msgcntr/trunk/messageforums-hbm/src/sql/mysql/msgcntr_indexes_only.sql
>
>     This does seem to be valid, but I just wanted to make sure that is
>     correct.
>
>     Mike Jennings
>     --
>     ==============================================================================
>     Mike Jennings
>     Teaching and Learning Developer
>     University of North Carolina at Chapel Hill
>
>     Office: (919) 843-5013
>     Cell: (919) 698-3746
>     E-mail: mike_jennings at unc.edu <mailto:mike_jennings at unc.edu>
>     _______________________________________________
>     sakai-dev mailing list
>     sakai-dev at collab.sakaiproject.org
>     <mailto:sakai-dev at collab.sakaiproject.org>
>     http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
>     TO UNSUBSCRIBE: send email to
>     sakai-dev-unsubscribe at collab.sakaiproject.org
>     <mailto:sakai-dev-unsubscribe at collab.sakaiproject.org> with a
>     subject of "unsubscribe"
>
>

-- 
==============================================================================
Mike Jennings
Teaching and Learning Developer
University of North Carolina at Chapel Hill

Office: (919) 843-5013
Cell: (919) 698-3746
E-mail: mike_jennings at unc.edu