Index: openacs-4/contrib/packages/simulation/sql/postgresql/upgrade/upgrade-1.0.0b1-1.0.0b2.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/simulation/sql/postgresql/upgrade/Attic/upgrade-1.0.0b1-1.0.0b2.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/contrib/packages/simulation/sql/postgresql/upgrade/upgrade-1.0.0b1-1.0.0b2.sql 12 Mar 2004 09:28:23 -0000 1.1 @@ -0,0 +1,15 @@ +alter table sim_simulations add + show_contacts_p boolean + constraint sim_show_contacts_p_ck + check(show_contacts_p in ('t','f')) +; + +alter table sim_simulations + alter column show_contacts_p + set default 't' +; + +update sim_simulations + set show_contacts_p = 't' +where show_contacts_p is null +; Index: openacs-4/packages/simulation/sql/postgresql/upgrade/upgrade-1.0.0b1-1.0.0b2.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/simulation/sql/postgresql/upgrade/upgrade-1.0.0b1-1.0.0b2.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/simulation/sql/postgresql/upgrade/upgrade-1.0.0b1-1.0.0b2.sql 12 Mar 2004 09:28:23 -0000 1.1 @@ -0,0 +1,15 @@ +alter table sim_simulations add + show_contacts_p boolean + constraint sim_show_contacts_p_ck + check(show_contacts_p in ('t','f')) +; + +alter table sim_simulations + alter column show_contacts_p + set default 't' +; + +update sim_simulations + set show_contacts_p = 't' +where show_contacts_p is null +;