Restored the MySQL Dump in SVN 6915 with care_person.alt_pid field. Existing users can upgrade with:
ALTER TABLE `care_person` ADD `alt_pid` VARCHAR(20) DEFAULT NULL AFTER `pid` Regards, Ap.Muthu > Hi Robert, > > You've deleted the mysql dump file in SVN 6914 and have not put in the new > one as yet! > > Regards, > Ap.Muthu > >> Hi Robert, >> >> Isn't this more of a legacy issue. >> Once the hospital is entirely on Care2x, it will not be necessary. >> >> This is quite useful if the patient is referred from another hospital. >> >> Rather than hospital_file_number, the field can be generic as alt_pid >> NULL >> This field should be optional and not null and not even unique. >> >> Regards, >> Ap.Muthu >> >> >>> Hi, >>> >>> Just out of experience.. and because I am doing that now again (as >>> always)... >>> >>> ALTER TABLE `care_person` ADD `hospital_file_number` VARCHAR( 20 ) NOT >>> NULL AFTER `pid` >>> >>> What do you think? Is it a major need and all of you have the need to >>> place there somewhere existing and already used hospital file numbers? >>> >>> Then we will add it to the next care2x release. >>> >>> Thanks >>> Robert >>> >>> p.s. Is there any need of having a documentation or example file how to >>> use tools like pentho's PDI to migrate existing datasets to care2x? > > > > ------------------------------------------------------------------------------ > Nokia and AT&T present the 2010 Calling All Innovators-North America > contest > Create new apps & games for the Nokia N8 for consumers in U.S. and Canada > $10 million total in prizes - $4M cash, 500 devices, nearly $6M in > marketing > Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store > http://p.sf.net/sfu/nokia-dev2dev > _______________________________________________ > Care2002-developers mailing list > Care2002-developers@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/care2002-developers > ------------------------------------------------------------------------------ Nokia and AT&T present the 2010 Calling All Innovators-North America contest Create new apps & games for the Nokia N8 for consumers in U.S. and Canada $10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store http://p.sf.net/sfu/nokia-dev2dev _______________________________________________ Care2002-developers mailing list Care2002-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/care2002-developers
