[Gnumed-update] - make delete/update on identity cascade to names table

[ihaywood]

Commit from ncq (2004-11-28 09:30 EST)
---------------

- make delete/update on identity cascade to names table

  gnumed  gnumed/server/sql/gmDemographics.sql  1.36


Commit from ncq (2004-11-28 09:35 EST)
---------------

- I first thought putting is_episode_name into clin_narrative would solve
  more issues that putting fk_clin_narrative into clin_episode, it turned
  out to be the other way round, however
- still missing:
  - trigger to ensure cyclic consistency between clin_narrative
    and clin_episode
  - a (deferred) constraint forcing standalon episodes to have a narrative FK

  gnumed  gnumed/server/sql/gmclinical.sql  1.141


Commit from ncq (2004-11-28 09:37 EST)
---------------

- adjust to clin_episode.fk_clin_narrative instead of 
clin_narrative.is_episode_name

  gnumed  gnumed/server/sql/gmClinicalViews.sql  1.117


Commit from ncq (2004-11-28 09:38 EST)
---------------

- some more deletes
- use new method of episode naming
- this actually bootstraps again

  gnumed  gnumed/server/sql/test-data/test_data-James_Kirk.sql      1.43
  gnumed  gnumed/server/sql/test-data/test_data-Leonard_McCoy.sql   1.11
  gnumed  gnumed/server/sql/test-data/test_data-lab_regression.sql  1.10