Index: openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.10d10-0.10d11.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.10d10-0.10d11.sql,v diff -u -N --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.10d10-0.10d11.sql 15 Apr 2005 01:37:22 -0000 1.2 @@ -0,0 +1,12 @@ +-- +-- +-- +-- @author Victor Guerra (guerra@galileo.edu) +-- @creation-date 2005-04-14 +-- @arch-tag: 2d974b78-55b8-4f2a-bb8b-759b518700a3 +-- @cvs-id $Id: upgrade-0.10d10-0.10d11.sql,v 1.2 2005/04/15 01:37:22 victorg Exp $ +-- + +alter table as_assessments add column random_p char(1); +alter table as_assessments alter random_p set default 't'; +alter table as_assessments add constraint as_assessments_random__ck check (random_p in ('t','f'));