Change id of patient_data table?

simpleone81 wrote on Wednesday, March 19, 2014:

This is similar to the thread here but still some how different: http://sourceforge.net/p/openemr/discussion/202505/thread/f2b86dcf/

Changing $pid and $pubid seems to be no problem.

My problem is with changing of column “id”.
When I tried to change “id” and “pid” to 8000, it worked well.

Then I decided to change both of them back to 6000 in myphpadmin. It appears to be fine BUT then the next patient I created has an “id” value of 8001 and “pid” has a value of 6001.

It would be nice to have the same value of id and pid (although it is not necessarily required).

Any idea on how I could change id back to a LOWER value?

thanks!

tmccormi wrote on Thursday, March 20, 2014:

the id is auto incremented by mysql. you have no control over that. the
PID is incremented by OpenEMR based on the highest PID it can find + 1.

Tony McCormick


Please be aware that e-mail communication can be intercepted in
transmission or misdirected. Please consider communicating any sensitive
information by telephone. The information contained in this message may be
privileged and confidential. If you are NOT the intended recipient, please
notify the sender immediately with a copy to hipaa-security@mrsb-ltd.com and
destroy this message.

tmccormi wrote on Thursday, March 20, 2014:

note: Id is internal and you should not even look at it. It’s there to
keep patient records unique and is not used otherwise.

Tony McCormick

On Mar 19, 2014 8:52 PM, “Tony McCormick” tony@mi-squared.com wrote:

the id is auto incremented by mysql. you have no control over that. the
PID is incremented by OpenEMR based on the highest PID it can find + 1.

Tony McCormick
www.mi-squared.com


Please be aware that e-mail communication can be intercepted in
transmission or misdirected. Please consider communicating any sensitive
information by telephone. The information contained in this message may be
privileged and confidential. If you are NOT the intended recipient, please
notify the sender immediately with a copy to hipaa-security@mrsb-ltd.com and
destroy this message.

simpleone81 wrote on Thursday, March 20, 2014:

I see - I was thinking that it would be ‘nice’ to have them (id and pid) aligned. But your comments make sense. thanks Tony.