[Building Sakai] Upgrading msgcntr to v2.7.5 conversion scripts

[George Pipkin]

Hi -

    I'm trying to upgrade msgcntr to v2.7.5 from v2.7.4, and I see a 
whole bunch
of conversion scripts down in messageforums-hbm, but I don't which ones
need to be run.  I also got this from a collegue at UNC:

ALTER TABLE MFR_UNREAD_STATUS_T
     DROP INDEX TOPIC_C;
ALTER TABLE MFR_UNREAD_STATUS_T
     ADD CONSTRAINT TOPIC_C
     UNIQUE (TOPIC_C, MESSAGE_C, USER_C);


ALTER TABLE MFR_MESSAGE_T
     DROP FOREIGN KEY FK80C1A316A2D0BE7B; ALTER TABLE MFR_MESSAGE_T
     ADD CONSTRAINT FK80C1A316A2D0BE7B
     FOREIGN KEY(surrogateKey)
     REFERENCES MFR_TOPIC_T(ID);

ALTER TABLE MFR_TOPIC_T
     DROP FOREIGN KEY FK863DC0BE74C7E92B; ALTER TABLE MFR_TOPIC_T
     ADD CONSTRAINT FK863DC0BE74C7E92B
     FOREIGN KEY(of_surrogateKey)
     REFERENCES MFR_OPEN_FORUM_T(ID);

ALTER TABLE MFR_OPEN_FORUM_T
     DROP FOREIGN KEY FKC17608478B5E2A2F; ALTER TABLE MFR_OPEN_FORUM_T
     ADD CONSTRAINT FKC17608478B5E2A2F
     FOREIGN KEY(surrogateKey)
     REFERENCES MFR_AREA_T(ID);



ALTER TABLE MFR_AREA_T
     DROP INDEX MFR_AREA_CONTEXT_UUID_UNIQUE; ALTER TABLE MFR_AREA_T
     ADD CONSTRAINT MFR_AREA_CONTEXT_UUID_UNIQUE




but it bombs out with an error:

ERROR 1091 (42000) at line 30: Can't DROP 'MFR_AREA_CONTEXT_UUID_UNIQUE'; check that column/key exists


The tool apparently runs fine.  I'm wonder which scripts I really need to run.


				- George Pipkin
				U.Va.
     UNIQUE (CONTEXT_ID, TYPE_UUID);