[WG: Sakai QA] SAK-19088/19894 sakai-2.8.0 MySQL conversion scripts (update)

[Anthony Whyte]

Steve Swinsburg (profile2) and I (all others) have added the necessary CREATE TABLE and ADD COLUMN statements that were missing in the MySQL conversion scripts.  Not all the missing scripts have been added to the Oracle conversion scripts however.

I'm now reviewing changed datatypes, missing keys and indexes as well as tickets checked for conversion script changes/additions:

https://jira.sakaiproject.org/secure/IssueNavigator.jspa?mode=hide&requestId=12383

Cheers,

Anthony

________________________________

Luthuli:liquibase-1.9.5 arwhyte$ java -jar ./liquibase-1.9.5.jar --driver=com.mysql.jdbc.Driver --url=jdbc:mysql://127.0.0.1:3306/sakai280convert --username=sakaiuser --password=sushi diff --baseUrl=jdbc:mysql://127.0.0.1:3306/sakai280autogen --baseUsername=sakaiuser --basePassword=sushi

Diff Results:
Base Database: sakaiuser jdbc:mysql://127.0.0.1:3306/sakai280autogen
Target Database: sakaiuser jdbc:mysql://127.0.0.1:3306/sakai280convert
Product Name: EQUAL
Product Version: EQUAL
Missing Tables:  [EXPECTED]
     report_xsl_file
     reports_def_xml
     reports_param
     reports_report
     reports_result
Unexpected Tables: NONE
Missing Views: NONE
Unexpected Views: NONE
Missing Columns: NONE
Unexpected Columns: NONE
Changed Columns: 
     email_template_item.HTMLMESSAGE
           from TEXT to LONGTEXT
     gb_grade_record_t.USER_ENTERED_GRADE
           from VARCHAR(127) to VARCHAR(255)
     poll_poll.POLL_IS_PUBLIC
           now nullable
     profile_gallery_images_t.RESOURCE_MAIN
           from VARCHAR(255) to TEXT
     profile_gallery_images_t.RESOURCE_THUMB
           from VARCHAR(255) to TEXT
     profile_images_t.RESOURCE_MAIN
           from VARCHAR(255) to TEXT
     profile_images_t.RESOURCE_THUMB
           from VARCHAR(255) to TEXT
Missing Foreign Keys: 
     qrtz_trigger_listeners_ibfk_1(qrtz_trigger_listeners.TRIGGER_NAME, TRIGGER_GROUP, TRIGGER_NAME, TRIGGER_GROUP, TRIGGER_NAME, TRIGGER_GROUP, TRIGGER_NAME, TRIGGER_GROUP ->qrtz_triggers.TRIGGER_NAME, TRIGGER_GROUP, TRIGGER_NAME, TRIGGER_GROUP, TRIGGER_NAME, TRIGGER_GROUP, TRIGGER_NAME, TRIGGER_GROUP)
     qrtz_triggers_ibfk_1(qrtz_triggers.JOB_NAME, JOB_GROUP, JOB_NAME, JOB_GROUP ->qrtz_job_details.JOB_NAME, JOB_GROUP, JOB_NAME, JOB_GROUP)
     FK6C32ED588EA2574(report_xsl_file.reportDefId ->reports_def_xml.reportDefId)
     FKA6F2CE9DC896C347(reports_result.reportId, reportId ->reports_report.reportId, reportId)
Unexpected Foreign Keys: 
     qrtz_trigger_listeners_ibfk_1(qrtz_trigger_listeners.TRIGGER_NAME, TRIGGER_GROUP, TRIGGER_NAME, TRIGGER_GROUP, TRIGGER_NAME, TRIGGER_GROUP, TRIGGER_NAME, TRIGGER_GROUP ->qrtz_triggers.TRIGGER_NAME, TRIGGER_GROUP, TRIGGER_NAME, TRIGGER_GROUP, TRIGGER_NAME, TRIGGER_GROUP, TRIGGER_NAME, TRIGGER_GROUP)
     qrtz_triggers_ibfk_1(qrtz_triggers.JOB_NAME, JOB_GROUP, JOB_NAME, JOB_GROUP ->qrtz_job_details.JOB_NAME, JOB_GROUP, JOB_NAME, JOB_GROUP)
Missing Primary Keys: 
     null on report_xsl_file(reportDefId, xslFileHash)
     null on reports_def_xml(reportDefId)
     null on reports_param(paramId)
     null on reports_report(reportId)
     null on reports_result(resultId)
Unexpected Primary Keys: NONE
Missing Unique Constraints: NONE
Unexpected Unique Constraints: NONE
Missing Indexes: 
     ANNOUNCEMENT_MESSAGE_CDD unique  on announcement_message(CHANNEL_ID, MESSAGE_DATE, DRAFT)
     IE_ANNC_MSG_ATTRIB unique  on announcement_message(DRAFT, PUBVIEW, OWNER)
     user_type_context_idx unique  on mfr_pvt_msg_usr_t(USER_ID, TYPE_UUID, CONTEXT_ID, READ_STATUS)
     PROFILE_COMPANY_PROFILES_USER_UUID_I unique  on profile_company_profiles_t(USER_UUID)
     PROFILE_GALLERY_IMAGES_USER_UUID_I unique  on profile_gallery_images_t(USER_UUID)
     PROFILE_MESSAGE_PARTICIPANT_DELETED_I unique  on profile_message_participants_t(MESSAGE_DELETED)
     PROFILE_MESSAGE_PARTICIPANT_MESSAGE_ID_I unique  on profile_message_participants_t(MESSAGE_ID)
     PROFILE_MESSAGE_PARTICIPANT_READ_I unique  on profile_message_participants_t(MESSAGE_READ)
     PROFILE_MESSAGE_PARTICIPANT_UUID_I unique  on profile_message_participants_t(PARTICIPANT_UUID)
     PROFILE_MESSAGES_DATE_POSTED_I unique  on profile_messages_t(DATE_POSTED)
     PROFILE_MESSAGES_FROM_UUID_I unique  on profile_messages_t(FROM_UUID)
     PROFILE_MESSAGES_THREAD_I unique  on profile_messages_t(MESSAGE_THREAD)
     FKD3B8420DC896C347 unique  on reports_param(reportId)
     FKA6F2CE9DC896C347 unique  on reports_result(reportId)
     KEY_INDEX unique  on url_randomised_mappings_t(TINY)
Unexpected Indexes: 
     ANNOUNCEMENT_MESSAGE_CDD unique  on announcement_message(CHANNEL_ID, MESSAGE_DATE, MESSAGE_ORDER, DRAFT)
     IE_ANNC_MSG_ATTRIB unique  on announcement_message(DRAFT, PUBVIEW, OWNER, MESSAGE_ORDER)
     ASSESSMENTGRADINGID on sam_itemgrading_t(ASSESSMENTGRADINGID, PUBLISHEDITEMID, PUBLISHEDITEMTEXTID, AGENTID, PUBLISHEDANSWERID)
Missing Sequences: NONE
Unexpected Sequences: NONE

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 3829 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-qa/attachments/20110202/1d029957/attachment.bin