conversion of BHODS HILIS to LTH application:

1) download BHODS data with "CREATE TABLE IF NOT EXIST" statements, minus _lab_tests_map table

2) run "script/deploy_new_centre.pl bristol" - WITH FINAL DATA SECTION COMMENTED!!

3) run bristol-hilis-convert-part1.sql

4) edit BHODS src data (sql dump):
  * email_contacts - remove entry #26 - uses type 'other' - inactive anyway
  * remove _lab_test_map data at end (if not excluded from data dump)
	
5) run "mysql -uraj -p bristol < <bhods_data>.sql" # NOT DROP TABLES!!

6) run lab-tests-update.sql

7) run bristol-hilis-convert-part2.sql

8) run update-diagnoses-table.pl (needs 2 xl files - current diagnoses table & update file)
	
9) run update-diagnoses-table.sql

10) run results_summary_user.pl (initially in test mode)

11) create views if not already done:
  * authorised_reports_view
  * request_report_view
  * request_status_view

12) adjust users table & config settings:
  * users.id 1 username -> 'raj', user_location_id => <BHODS>
  *	config/settings/.bristol & bristol.txt
  *	templates/resources/menu/local/request_forms.bristol
  *	templates/resources/menu/local/file_uploads.bristol

problems:
* error_code_assignment - bhods uses 'request' hilis4 uses 'request_edit' & 'new_request'
* request_diagnosis_history has some NULLS - assumed 'update'