Index: openacs-4/packages/acs-mail-lite/sql/oracle/upgrade/upgrade-5.8.1d3-5.8.1d4.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-mail-lite/sql/oracle/upgrade/upgrade-5.8.1d3-5.8.1d4.sql,v diff -u -N -r1.2 -r1.2.2.1 --- openacs-4/packages/acs-mail-lite/sql/oracle/upgrade/upgrade-5.8.1d3-5.8.1d4.sql 27 Oct 2014 16:39:40 -0000 1.2 +++ openacs-4/packages/acs-mail-lite/sql/oracle/upgrade/upgrade-5.8.1d3-5.8.1d4.sql 3 Mar 2017 08:55:18 -0000 1.2.2.1 @@ -6,4 +6,6 @@ -- new columns alter table acs_mail_lite_queue add filesystem_files varchar(4000); -alter table acs_mail_lite_queue add delete_filesystem_files_p boolean; \ No newline at end of file +alter table acs_mail_lite_queue add delete_filesystem_files_p char(1) + constraint amlq_del_fs_files_p_ck + check (delete_filesystem_files_p in ('t','f'));