Index: openacs-4/contrib/packages/simulation/sql/postgresql/upgrade/upgrade-1.0.0b3-1.0.0b4.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/simulation/sql/postgresql/upgrade/Attic/upgrade-1.0.0b3-1.0.0b4.sql,v diff -u -N --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/packages/simulation/sql/postgresql/upgrade/upgrade-1.0.0b3-1.0.0b4.sql 23 Mar 2004 17:01:35 -0000 1.1.2.1 @@ -0,0 +1,12 @@ +-- add column sim_party_sim_map.multiple_cases_p + +alter table sim_party_sim_map add + multiple_cases_p boolean; + +alter table sim_party_sim_map + alter column multiple_cases_p + set default 'f'; + +update sim_party_sim_map + set multiple_cases_p = 'f' +where multiple_cases_p is null;