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

[Bryan Holladay]

Just make sure you have *ONLY* the following indexes/contraints:

CREATE INDEX MFR_UNREAD_STATUS_I2 USING BTREE
    ON MFR_UNREAD_STATUS_T(MESSAGE_C, USER_C, READ_C);

CREATE INDEX MFR_UNREAD_STATUS_I1 USING BTREE
    ON MFR_UNREAD_STATUS_T(TOPIC_C, MESSAGE_C, USER_C, READ_C);

CREATE UNIQUE INDEX PRIMARY USING BTREE
    ON MFR_UNREAD_STATUS_T(ID);

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

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

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

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

ALTER TABLE MFR_AREA_T
    ADD CONSTRAINT MFR_AREA_CONTEXT_UUID_UNIQUE
    UNIQUE (CONTEXT_ID, TYPE_UUID);





On Wed, Aug 31, 2011 at 4:28 PM, George Pipkin <gpp8p at virginia.edu> wrote:
> 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);
>
>
> _______________________________________________
> sakai-dev mailing list
> 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 with a subject of "unsubscribe"
>