apmuthu wrote on Thursday, September 02, 2010:
Data persistence from previous records into blank current record of facilities.php and removal of redundant css lines besides enabling edit and add of new facility in the git version of OpenEMR v4.0.0-dev has been solved in bug report (30569220) and attachment in it.
Database sql correction removing all AUTO_INCREMENT=xx lines removed addressed in bug report (3056976) and attachment there at.
bradymiller wrote on Thursday, September 02, 2010:
hi,
Thanks for doing this. I’ll look over it and integrate into the codebase (if tests well) in the next couple days (gonna wait until Rod finishes committing an extensive patch). Is the auto_increment line optional (ie. does it default to zero if not stated)?
thanks,
brady
apmuthu wrote on Thursday, September 02, 2010:
When there is an AUTO_INCREMENT=xx and the sql file has INSERTs thereafter, the new inserts (if without primary key or with NULL primary key) will possess IDs beyond xx. AUTO_INCREMENT value is generally one more than the current max ID.
If there are no AUTO_INCREMENT=xx clauses in the CREATE TABLE constructs it will default to 1. Subsequent INSERTs will automatically increment it accordingly. I have put in the INSERT statements in proper order by ID in the database.sql.