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?
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.
–
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.