Hi Michael and Ben, Michael, I got the file you sent. Thanks! However I tried out the script in the wiki page Ben has sent and it seems it is much easier to modify the 1.6 data model than rendering a new model from scratch. There were 40 changes from 1.6 to 1.7 which I have almost completed adding to the 1.6 model. I will complete it and send it back to you so that you can compare it with the model you created from Toad. That will help to verify the diagram.
Ben, thanks for the pointing me towards the wiki page having Burke's script. It was very useful as I mentioned earlier. I will also modify the release notes pages of 1.7 and 1.8 with the output from the script. Also, in which wiki page should the new data model files be attached? Should I modify the page https://wiki.openmrs.org/display/docs/Data+Model or else create two new pages for 1.7 and 1.8 and attach the new files there? Regards, Nimantha On Sat, Mar 24, 2012 at 12:38 AM, Michael Aro <[email protected]>wrote: > I'll investigate and work with Nimantha. > > M. > > > On Fri, Mar 23, 2012 at 6:21 PM, Ben Wolfe <[email protected]> wrote: > >> 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 >>> >> >> ------------------------------ >> 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 _________________________________________ 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]
