One more question to add to the list. While creating the new data model for 1.7, four new tables were added. Namely; 1. active_list_type 2. active_list 3. active_list_allergy 4. active_list_problem
The existing table groupings are as follows: 1. User 2. Person 3. Patient 4. Groups/Workflows 5. Encounter 6. Observation 7. Concept 8. Business 9. Order 10. Form The question is, to which grouping does the above mentioned 4 new tables belong? If they are better off in a new grouping, what should the grouping be called? Regards, Nimantha On Sat, Mar 24, 2012 at 12:53 PM, Nimantha Baranasuriya <[email protected] > wrote: > 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 > > > -- 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]
