I would say we have two distinct issues with the DB structure. 1 We need to ensure that we have a structure that works with the code base that we are using. This needs to be put under the installer/ directory (which I notice had been omitted from github but I have now uploaded).
2 Then we need a method for adding database updates for any new features so that users can safely update to newer versions. One technique I have used in the past is to have a directory with sequentially numbered update files in, and then when an admin user logs in the latest numbered applied is compared with the highest number in that directory and then any new updates can be applied. Tim ps I have reviewed and merged your pull request. On 28 March 2016 at 05:17, Sovello Hildebrand Mgani <sovellohpmg...@gmail.com> wrote: > Thanks all for the pointers! > I have been working in a place with very limited internet access. > I will make use of the suggestions and send feedback of what I'll have done > then. > > Am thinking this will be one of the functionalities we may need in Care2x so > it's easy to edit the database schema as we are developing. [It will serve > us hours of making comparisons :)] > > Thank you all. > > Cheers > > 2016-03-25 20:05 GMT+03:00 Ap.Muthu <apmu...@usa.net>: >> >> Install a new Care2x and then compare the schema between the new and old >> one can check for differences in a Schema compare tool like SQLyog and make >> changes in the database manually. >> >> ----- Original Message ----- >> From: Sovello Hildebrand Mgani >> To: care2002-developers@lists.sourceforge.net >> Sent: Thursday, March 24, 2016 11:28 AM >> Subject: [Care2002-developers] Updating Care2x database tables >> >> Hi everyone! >> How do we update a Care2x database table when the system is already >> installed. >> I came to realize that some of the fields though available in the module >> class (e.g. class_lab.php) but are missing in the actual tables associated >> with the class. >> I want to be able to update the tables after the instance has been >> installed. >> Any pointers will be highly appreciated! >> >> Cheers >> >> ________________________________ >> >> >> ------------------------------------------------------------------------------ >> Transform Data into Opportunity. >> Accelerate data analysis in your applications with >> Intel Data Analytics Acceleration Library. >> Click to learn more. >> http://pubads.g.doubleclick.net/gampad/clk?id=278785351&iu=/4140 >> >> ________________________________ >> >> _______________________________________________ >> Care2002-developers mailing list >> Care2002-developers@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/care2002-developers >> >> >> >> ------------------------------------------------------------------------------ >> Transform Data into Opportunity. >> Accelerate data analysis in your applications with >> Intel Data Analytics Acceleration Library. >> Click to learn more. >> http://pubads.g.doubleclick.net/gampad/clk?id=278785351&iu=/4140 >> _______________________________________________ >> Care2002-developers mailing list >> Care2002-developers@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/care2002-developers >> > > > > -- > :: Sovello Hildebrand Mgani :: > > > > --If you teach man to fish, you'll feed him a lifetime-- > > ------------------------------------------------------------------------------ > Transform Data into Opportunity. > Accelerate data analysis in your applications with > Intel Data Analytics Acceleration Library. > Click to learn more. > http://pubads.g.doubleclick.net/gampad/clk?id=278785471&iu=/4140 > _______________________________________________ > Care2002-developers mailing list > Care2002-developers@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/care2002-developers > -- Course View Towers, Plot 21 Yusuf Lule Road, Kampala T +256 (0) 312 314 418 M +256 (0) 752 963 325 www.weberpafrica.com Twitter: @TimSchofield2 Blog: http://weberpafrica.blogspot.co.uk/ ------------------------------------------------------------------------------ Transform Data into Opportunity. Accelerate data analysis in your applications with Intel Data Analytics Acceleration Library. Click to learn more. http://pubads.g.doubleclick.net/gampad/clk?id=278785471&iu=/4140 _______________________________________________ Care2002-developers mailing list Care2002-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/care2002-developers
