[WG: Sakai QA] 2.7.0 conversion scripts: other SAM variations

[Anthony Whyte]

Karen--can you check these other variations as well.  We can't release rc01 until these mismatches are reviewed and resolved.

Anth


arwhyte-macbookpro-2010: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/sakai262to270convert --username=sakaiuser --password=sushi diff --baseUrl=jdbc:mysql://127.0.0.1:3306/sakai270autogen --baseUsername=sakaiuser --basePassword=sushi
Diff Results:
Base Database: sakaiuser jdbc:mysql://127.0.0.1:3306/sakai270autogen
Target Database: sakaiuser jdbc:mysql://127.0.0.1:3306/sakai262to270convert

Changed Columns (converted db vs auto-gen db): 
  
   sam_publishedassessment_t.LASTNEEDRESUBMITDATE
         from DATE to DATETIME

Missing Foreign Keys: 
   
   FKD4CF5A194D7EA7B3(sam_media_t.ITEMGRADINGID ->sam_itemgrading_t.ITEMGRADINGID)

Unexpected Foreign Keys: 
   
   FKD4CF5A194D7EA7B3(sam_media_t.ITEMGRADINGID, ITEMGRADINGID ->sam_itemgrading_t.ITEMGRADINGID, ITEMGRADINGID)

Unexpected Primary Keys: 
   null on sam_gradingattachment_t(ATTACHMENTID)