[WG: Sakai QA] SAK-17206: missing field poll_options.deleted in 2.7.0 conversion scripts
Anthony Whyte
arwhyte at umich.edu
Thu May 13 16:52:45 PDT 2010
I've committed a fix for this issue to the 2.7.0 conversion scripts (trunk, 2.7.x).
Anth
On May 13, 2010, at 6:05 PM, Anthony Whyte wrote:
> 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 poll_options includes the hibernate-generated field
>
> `DELETED` bit(1) DEFAULT NULL
>
> in the auto-generated 2.7.0 db but the field is missing in the 2.6.2->2.7.0 db updated with the conversion script. The field was added to trunk as of r68504, 3 Nov 2009 and was merged to polls-1.3.x and included in subsequent polls-1.3 releases.
>
> The field needs to be added to the 2.7.0 MySQL and Oracle conversion scripts in trunk and 2.7.x. Adam should add it to the Db2 script.
>
> Anth
>
> auto-generated db
>
> CREATE TABLE `poll_option` (
> `OPTION_ID` bigint(20) NOT NULL AUTO_INCREMENT,
> `OPTION_POLL_ID` bigint(20) DEFAULT NULL,
> `OPTION_TEXT` text COLLATE utf8_bin,
> `OPTION_UUID` varchar(255) COLLATE utf8_bin DEFAULT NULL,
> `DELETED` bit(1) DEFAULT NULL,
> PRIMARY KEY (`OPTION_ID`)
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
>
> conversion script updated db
>
> CREATE TABLE `poll_option` (
> `OPTION_ID` bigint(20) NOT NULL AUTO_INCREMENT,
> `OPTION_POLL_ID` bigint(20) DEFAULT NULL,
> `OPTION_TEXT` text COLLATE utf8_bin,
> `OPTION_UUID` varchar(255) COLLATE utf8_bin DEFAULT NULL,
> PRIMARY KEY (`OPTION_ID`)
> ) 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
> _______________________________________________
> sakai-qa mailing list
> sakai-qa at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-qa
>
> TO UNSUBSCRIBE: send email to sakai-qa-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
>
>
More information about the sakai-qa
mailing list