You will want to go off of the liquibase changesets. See this wiki page: https://wiki.openmrs.org/display/docs/Finding+Database+Changes+Between+Releases
That mysqldiff.sql file is the old pre-liquibase upgrades. It takes users UP TO 1.4.2 and then liquibase takes users up to the latest release. (Hopefully there aren't many users still pre 1.4.2!!) Long story short: that file won't help you here. We should update those old release notes page with the output from Burke's script... Ben On Fri, Mar 23, 2012 at 10:50 AM, Nimantha Baranasuriya <[email protected] > wrote: > I will start from the mwb file. I opened it with MySQL Workbench and I > noticed that tables can be modified and the SVG can be generated from it > without any issues. > > Ben, can you please point me towards where the sqldifs are stored? I went > through the wiki pages having the release notes for 1.7.0 and 1.8.0 and > couldn't find them on those pages. I also checked inside the openmrs.war > file in the official release in sourceforge but couldn't find it there as > well. > > However I found a sqldiff file in the 1.7.0 branch ( > http://svn.openmrs.org/openmrs/branches/1.7.x/metadata/model/archive/update-to-1.4.2.01-db.mysqldiff.sql). > Is this the correct file? > > Regards, > Nimantha > > On Fri, Mar 23, 2012 at 9:11 PM, Ben Wolfe <[email protected]> wrote: > >> You can start from the mwb file on the wiki page as well. I don't know >> about any svg editors or if that would be easier/harder. >> >> Ben >> >> >> On Fri, Mar 23, 2012 at 12:12 AM, Nimantha Baranasuriya < >> [email protected]> wrote: >> >>> Hi Ben, >>> >>> I'll take up the task :-) >>> >>> Can I please know whether there are any tools that can be used for the >>> purpose of editing the SVG or will I need to open the MySQL workbench file, >>> edit it from there and then render the SVG? >>> >>> Regards, >>> Nimantha >>> >>> On 23 Mar, 2012, at 2:43 AM, Ben Wolfe <[email protected]> wrote: >>> >>> Any developers out there have a love for data model images? >>> Unfortunately, the last one we have done is for 1.6...and 1.9 is soon to be >>> out the door. >>> https://wiki.openmrs.org/display/docs/Data+Model >>> >>> Claim this ticket if you want to make the 1.8 model. We can make more >>> tickets for 1.7 and 1.9 if you feel so inclined. :-) >>> https://tickets.openmrs.org/browse/TRUNK-2808 >>> >>> The model hasn't changed very much, so you could potentially just take >>> the 1.6 svg and modify it instead of starting from scratch. The 1.7.0 and >>> 1.8.0 release notes pages should have the sql diffs on them, or you can >>> look at the new entries in the liquibase-update-to-latest.xml file(s). >>> >>> Ben >>> ------------------------------ >>> Click here to >>> unsubscribe<[email protected]?body=SIGNOFF%20openmrs-devel-l>from >>> OpenMRS Developers' mailing list >>> >>> ------------------------------ >>> Click here to >>> unsubscribe<[email protected]?body=SIGNOFF%20openmrs-devel-l>from >>> OpenMRS Developers' mailing list >> >> >> ------------------------------ >> Click here to >> unsubscribe<[email protected]?body=SIGNOFF%20openmrs-devel-l>from >> OpenMRS Developers' mailing list >> > > > > -- > Nimantha Baranasuriya > Web: http://www.nimantha.info > Blog: http://www.nimantha.info/blog > Photography: http://www.nimantha.info/photoblog; > http://www.flickr.com/photos/nimanthab > > > ------------------------------ > Click here to > unsubscribe<[email protected]?body=SIGNOFF%20openmrs-devel-l>from > OpenMRS Developers' mailing list > _________________________________________ To unsubscribe from OpenMRS Developers' mailing list, send an e-mail to [email protected] with "SIGNOFF openmrs-devel-l" in the body (not the subject) of your e-mail. [mailto:[email protected]?body=SIGNOFF%20openmrs-devel-l]
