search

b-b-a / bba-power

1 stars 0 forks source link

DB Changes for V4 #149

Closed ghost closed 12 years ago

ghost commented 12 years ago

A number of DB changes are planned for V4. Some can be made now (the existing system will still work). Some have to be made at or after go live. --DB Changes for V4 - Done Ahead of Go Live. remove: client_docLoa; contract_txtTenderRequest; contract_docAnalysis; contract_docTermination; tender_txtResponce

--DB Changes for V4 - To be done AT Go Live.

--DB Changes for V4 - To be done after Go Live. contract_idTenderSelected & contract_idSupplierContactSelected. Change zero to NULL. Enable the referential integrity (the FOREIGN KEY checking) on these fields. contract_idContractPrevious -- to be removed from contract display . not used.

ghost commented 12 years ago

Approach changed - too many to do here. A separate sheet added to the DB Schema Document that can do everything needed via updates. This allows the production DB to be copied into test environment and updated to the new version.