conversion of BHODS HILIS to LTH application:

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

2) run: "perl script/deploy_new_centre.pl -c bristol --no-data"

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

4) edit BHODS src data (sql dump):
  * email_contacts - remove entry #26 - uses type 'other' - inactive anyway
  * error_code_assignment data - change request -> request_edit and add (new_request,1)
  * remove _lab_test_map data at end (if not excluded from data dump)

5) run "mysql -uraj -p bristol < <bhods_data>.sql" # ENSURE NO DROP TABLES STATEMENTS!!

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 MANUALLY update-diagnoses-table.sql (1st query is a check on diagnoses)

10) run results_summary_user.pl

11) run MANUALLY results_summary_user.sql (has a check query)

12) run bristol-practices.pl & update GP's manually in HILIS

13) run update-referral-sources.sql

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

15) 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

check:
	new/relapsed diagnoses loads for external users

problems:
* request_diagnosis_history has some NULLS - assumed 'update'
