[WG: Sakai QA] SAM-676: missing sam_gradingattachment_t in 2.7.0 conversion scripts

Anthony Whyte arwhyte at umich.edu
Thu May 13 14:35:54 PDT 2010


I'm using Liquibase to compare a MySQL 2.6.2->2.7.0 db updated via the 2.7.0 conversion scripts against an auto-generated 2.7.0 database.  The table sam_gradingattachment_t is in the auto-generated 2.7.0 db (courtesy of hibernate) but missing in the 2.6.2->2.7.0 db updated with the conversion script.

A CREATE TABLE statement needs to be added to the conversion scripts (trunk and 2.7.x).

http://jira.sakaiproject.org/browse/SAM-676



Dump of the missing table via Navicat:

DROP TABLE IF EXISTS `sam_gradingattachment_t`;
CREATE TABLE `sam_gradingattachment_t` (
  `ATTACHMENTID` bigint(20) NOT NULL AUTO_INCREMENT,
  `ATTACHMENTTYPE` varchar(255) COLLATE utf8_bin NOT NULL,
  `RESOURCEID` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `FILENAME` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `MIMETYPE` varchar(80) COLLATE utf8_bin DEFAULT NULL,
  `FILESIZE` bigint(20) DEFAULT NULL,
  `DESCRIPTION` text COLLATE utf8_bin,
  `LOCATION` text COLLATE utf8_bin,
  `ISLINK` bit(1) DEFAULT NULL,
  `STATUS` int(11) NOT NULL,
  `CREATEDBY` varchar(255) COLLATE utf8_bin NOT NULL,
  `CREATEDDATE` datetime NOT NULL,
  `LASTMODIFIEDBY` varchar(255) COLLATE utf8_bin NOT NULL,
  `LASTMODIFIEDDATE` datetime NOT NULL,
  `ITEMGRADINGID` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`ATTACHMENTID`),
  KEY `FK28156C6C4D7EA7B3` (`ITEMGRADINGID`),
  CONSTRAINT `FK28156C6C4D7EA7B3` FOREIGN KEY (`ITEMGRADINGID`) REFERENCES `sam_itemgrading_t` (`ITEMGRADINGID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;



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
Product Name: EQUAL
Product Version: EQUAL
Missing Tables: NONE
Unexpected Tables: 
    sam_gradingattachment_t
Missing Views: NONE
Unexpected Views: NONE
Missing Columns: NONE
Unexpected Columns: 
    poll_option.DELETED
Changed Columns: 
    gb_category_t.ENFORCE_POINT_WEIGHTING
          from BIT to BIT
    gb_category_t.IS_EQUAL_WEIGHT_ASSNS
          from BIT to BIT
    gb_category_t.IS_UNWEIGHTED
          from BIT to BIT
    gb_gradable_object_t.IS_NULL_ZERO
          from BIT to BIT
    gb_gradebook_t.DO_SHOW_ITEM_STATS
          from BIT to BIT
    gb_gradebook_t.DO_SHOW_MEAN
          from BIT to BIT
    gb_gradebook_t.DO_SHOW_MEDIAN
          from BIT to BIT
    gb_gradebook_t.DO_SHOW_MODE
          from BIT to BIT
    gb_gradebook_t.DO_SHOW_RANK
          from BIT to BIT
    gb_gradebook_t.IS_EQUAL_WEIGHT_CATS
          from BIT to BIT
    gb_gradebook_t.IS_SCALED_EXTRA_CREDIT
          from BIT to BIT
    osp_presentation.isCollab
          from TINYINT to BIT
          now nullable
    osp_wizard_page_def.type
          now not null
    qrtz_fired_triggers.PRIORITY
          from INT to SMALLINT
    qrtz_triggers.PRIORITY
          from INT to SMALLINT
    sam_publishedassessment_t.LASTNEEDRESUBMITDATE
          from DATE to DATETIME
Missing Foreign Keys: 
    FK4EBCD0F5A6286438(osp_scaffolding_levels.scaffolding_id, scaffolding_id, scaffolding_id, scaffolding_id ->osp_scaffolding.id, id, id, id)
    FK2065879242A62872(osp_workflow.id, id, parent_id ->osp_workflow_parent.id, id, id)
    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)
    FKD4CF5A194D7EA7B3(sam_media_t.ITEMGRADINGID ->sam_itemgrading_t.ITEMGRADINGID)
Unexpected Foreign Keys: 
    FK4EBCD0F5A6286438(osp_scaffolding_levels.scaffolding_id, id, scaffolding_id, scaffolding_id, id, scaffolding_id ->osp_scaffolding.id, id, id, id, id, id)
    FK2065879242A62872(osp_workflow.id, id, id, parent_id ->osp_workflow_parent.id, id, id, id)
    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)
    FKD4CF5A194D7EA7B3(sam_media_t.ITEMGRADINGID, ITEMGRADINGID ->sam_itemgrading_t.ITEMGRADINGID, ITEMGRADINGID)
Missing Primary Keys: NONE
Unexpected Primary Keys: 
    null on sam_gradingattachment_t(ATTACHMENTID)
Missing Unique Constraints: NONE
Unexpected Unique Constraints: NONE
Missing Indexes: 
    MFR_EMAIL_CONTEXT_ID_I unique  on mfr_email_notification_t(CONTEXT_ID)
    MFR_EMAIL_USER_ID_I unique  on mfr_email_notification_t(USER_ID)
    PROFILE_FRIENDS_FRIEND_UUID_I unique  on profile_friends_t(FRIEND_UUID)
    PROFILE_FRIENDS_USER_UUID_I unique  on profile_friends_t(USER_UUID)
    PROFILE_IMAGES_IS_CURRENT_I unique  on profile_images_t(IS_CURRENT)
    PROFILE_IMAGES_USER_UUID_I unique  on profile_images_t(USER_UUID)
    SAKAI_PERSON_META_PROPERTY_I unique  on sakai_person_meta_t(PROPERTY)
    SAKAI_PERSON_META_USER_UUID_I unique  on sakai_person_meta_t(USER_UUID)
    SST_EVENTS_DATE_IX unique  on sst_events(EVENT_DATE)
    SST_EVENTS_EVENT_ID_IX unique  on sst_events(EVENT_ID)
    SST_EVENTS_SITEEVENTUSER_ID_IX unique  on sst_events(SITE_ID, EVENT_ID, USER_ID)
    SST_EVENTS_SITE_ID_IX unique  on sst_events(SITE_ID)
    SST_EVENTS_USER_ID_IX unique  on sst_events(USER_ID)
    SST_PREFERENCES_SITE_ID_IX unique  on sst_preferences(SITE_ID)
    SST_REPORTS_SITE_ID_IX unique  on sst_reports(SITE_ID)
    SST_RESOURCES_DATE_IX unique  on sst_resources(RESOURCE_DATE)
    SST_RESOURCES_RES_ACT_IDX unique  on sst_resources(RESOURCE_ACTION)
    SST_RESOURCES_SITE_ID_IX unique  on sst_resources(SITE_ID)
    SST_RESOURCES_USER_ID_IX unique  on sst_resources(USER_ID)
    SST_SITEACTIVITY_DATE_IX unique  on sst_siteactivity(ACTIVITY_DATE)
    SST_SITEACTIVITY_EVENT_ID_IX unique  on sst_siteactivity(EVENT_ID)
    SST_SITEACTIVITY_SITE_ID_IX unique  on sst_siteactivity(SITE_ID)
    SST_SITEVISITS_DATE_IX unique  on sst_sitevisits(VISITS_DATE)
    SST_SITEVISITS_SITE_ID_IX unique  on sst_sitevisits(SITE_ID)
Unexpected Indexes: 
    FK529713EAE023FB45 unique  on osp_scaffolding_attachments(id)
    FK95431263E023FB45 unique  on osp_scaffolding_form_defs(id)
    FK28156C6C4D7EA7B3 unique  on sam_gradingattachment_t(ITEMGRADINGID)
    FKD4CF5A194D7EA7B3 unique  on sam_media_t(ITEMGRADINGID)
    SITE_ID on sst_preferences(SITE_ID)
Missing Sequences: NONE
Unexpected Sequences: NONE


More information about the sakai-qa mailing list