Skip to:
When comparing a fresh auto-ddl'd 2.8 rc01 database against an upgraded 2.7.1 database, the following inconsistencies were found:
– PROFILE_PREFERENCES_T.EMAIL_MESSAGE_NEW2.8 auto.ddl: not nullable, default NULL2.7.1 converted: nullable, default "0"
– PROFILE_PREFERENCES_T.EMAIL_MESSAGE_REPLY2.8 auto.ddl: not nullable, default NULL2.7.1 converted: nullable, default "0"
– PROFILE_PREFERENCES_T.SHOW_GALLERY_FEED2.8 auto.ddl: not nullable, default NULL2.7.1 converted: nullable, default "1"
– PROFILE_PREFERENCES_T.SHOW_KUDOS2.8 auto.ddl: not nullable, default NULL2.7.1 converted: nullable, default "1"
– PROFILE_PREFERENCES_T.USE_OFFICIAL_IMAGE2.8 auto.ddl: not nullable, default NULL2.7.1 converted: nullable, default "0"
– PROFILE_PRIVACY_T.BUSINESS_INFO2.8 auto.ddl: NUMBER(10,0), not nullable, default NULL2.7.1 converted: NUMBER(1,0), nullable, default "0"
– PROFILE_PRIVACY_T.MESSAGES2.8 auto.ddl: NUMBER(10,0), not nullable, default NULL2.7.1 converted: NUMBER(1,0), nullable, default "0"
– PROFILE_PRIVACY_T.MY_KUDOS2.8 auto.ddl: NUMBER(10,0), not nullable, default NULL2.7.1 converted: NUMBER(1,0), nullable, default "0"
– PROFILE_PRIVACY_T.MY_PICTURES2.8 auto.ddl: NUMBER(10,0), not nullable, default NULL2.7.1 converted: NUMBER(1,0), nullable, default "0"
– PROFILE_PRIVACY_T.SOCIAL_NETWORKING_INFO2.8 auto.ddl: NUMBER(10,0), not nullable, default NULL2.7.1 converted: NUMBER(1,0), nullable, default "0"
– PROFILE_PRIVACY_T.STAFF_INFO2.8 auto.ddl: NUMBER(10,0), not nullable, default NULL2.7.1 converted: NUMBER(1,0), nullable, default "0"
– PROFILE_PRIVACY_T.STUDENT_INFO2.8 auto.ddl: NUMBER(10,0), not nullable, default NULL2.7.1 converted: NUMBER(1,0), nullable, default "0"
Integrated in sakai trunk #467 (See http://builds.sakaiproject.org:8080/job/sakai%20trunk/467/) adjust order of statements to correct Oracle syntax
Patch commited to trunk, r89916 and verified on local instance.Merged to 2.8.x, r89918.
Integrated in profile2 trunk (build and deploy) #414 (See http://builds.sakaiproject.org:8080/job/profile2%20trunk%20(build%20and%20deploy)/414/) adjust sql that adds defaults, order of the statements was incorrect for oracle
1.4.x r89906
r89905
When comparing a fresh auto-ddl'd 2.8 rc01 database against an upgraded 2.7.1 database, the following inconsistencies were found:
– PROFILE_PREFERENCES_T.EMAIL_MESSAGE_NEW
2.8 auto.ddl: not nullable, default NULL
2.7.1 converted: nullable, default "0"
– PROFILE_PREFERENCES_T.EMAIL_MESSAGE_REPLY
2.8 auto.ddl: not nullable, default NULL
2.7.1 converted: nullable, default "0"
– PROFILE_PREFERENCES_T.SHOW_GALLERY_FEED
2.8 auto.ddl: not nullable, default NULL
2.7.1 converted: nullable, default "1"
– PROFILE_PREFERENCES_T.SHOW_KUDOS
2.8 auto.ddl: not nullable, default NULL
2.7.1 converted: nullable, default "1"
– PROFILE_PREFERENCES_T.USE_OFFICIAL_IMAGE
2.8 auto.ddl: not nullable, default NULL
2.7.1 converted: nullable, default "0"
– PROFILE_PRIVACY_T.BUSINESS_INFO
2.8 auto.ddl: NUMBER(10,0), not nullable, default NULL
2.7.1 converted: NUMBER(1,0), nullable, default "0"
– PROFILE_PRIVACY_T.MESSAGES
2.8 auto.ddl: NUMBER(10,0), not nullable, default NULL
2.7.1 converted: NUMBER(1,0), nullable, default "0"
– PROFILE_PRIVACY_T.MY_KUDOS
2.8 auto.ddl: NUMBER(10,0), not nullable, default NULL
2.7.1 converted: NUMBER(1,0), nullable, default "0"
– PROFILE_PRIVACY_T.MY_PICTURES
2.8 auto.ddl: NUMBER(10,0), not nullable, default NULL
2.7.1 converted: NUMBER(1,0), nullable, default "0"
– PROFILE_PRIVACY_T.SOCIAL_NETWORKING_INFO
2.8 auto.ddl: NUMBER(10,0), not nullable, default NULL
2.7.1 converted: NUMBER(1,0), nullable, default "0"
– PROFILE_PRIVACY_T.STAFF_INFO
2.8 auto.ddl: NUMBER(10,0), not nullable, default NULL
2.7.1 converted: NUMBER(1,0), nullable, default "0"
– PROFILE_PRIVACY_T.STUDENT_INFO
2.8 auto.ddl: NUMBER(10,0), not nullable, default NULL
2.7.1 converted: NUMBER(1,0), nullable, default "0"