Hi Robert, Here are the sql errors / notes on your changes:
File: /installer/db/sql/mysql_dump.sql Line 2407: The table should be care_person and not care_person1. Since Line 10 makes the default charset as UTF8 and the sets the default collation, we can avoid declaring it in every table definition. The ICD10 and OPS301 tables remain ISAM. Line 36 can make the care_accesslog as InnoDB. Line 897 making pid as unsigned should not affect the code. This is a concern where the reverse occurs: where migrating from unsigned field containing more than the first half of pid (Most significant bit set will indicate negative values). Line 946-947: Table care_encounter references table care_person and hence must be declared only after care_person table. Otherwise, this will cause failure of the constraint being accepted. Regards, Ap.Muthu apmu...@usa.net > I made some changes in the db as well, can someone other than me please > test if it is working? Well, here it is working, but a test should not > be done from the one who did the change. > > Changes: > Revision: 6699 > -> fix: Field PID is now unsigned and now a FK to care_person.pid > Revision: 6697 > -> default charset of all tables is now UTF8 > Revision: 6696 > -> care_person tablefix: PID was PK and Index as well! > > And some clean-up's in the files of unsigned variables (not finished) > > Thanks > Robert ------------------------------------------------------------------------------ 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
