For those of you who are updating from prior to or at SVN 6691 to 6699/6700,
the following SQL commands need to be executed on your Care2x db:
ALTER TABLE `care_person` DROP KEY `pid`;
ALTER TABLE `care_encounter` CHANGE `pid` `pid` INT(11) UNSIGNED DEFAULT '0'
NOT NULL;
ALTER TABLE `care_accesslog` ENGINE=INNODB CHARSET=utf8
COLLATE=utf8_unicode_ci ;
ALTER TABLE `care_encounter` ADD CONSTRAINT `care_encounter_ibfk_2` FOREIGN KEY
(`pid`) REFERENCES `care_person` (`pid`);
If you are using the OPS301 for English, then the table ops301_en should also
be created and populated from the corresponding CSV file.
Regards,
Ap.Muthu
------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
Care2002-developers mailing list
Care2002-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/care2002-developers
