[Building Sakai] Duplicate Unique Keys on mfr_area_t

[Mike Jennings]

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