Index: openacs-4/packages/attachments/sql/postgresql/upgrade/upgrade-0.11d2-0.11d3.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/attachments/sql/postgresql/upgrade/upgrade-0.11d2-0.11d3.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/attachments/sql/postgresql/upgrade/upgrade-0.11d2-0.11d3.sql	14 May 2016 18:10:52 -0000	1.1.2.1
@@ -0,0 +1,11 @@
+--
+-- Alter caveman style booleans (type character(1)) to real SQL boolean types.
+--
+
+ALTER TABLE attachments
+      DROP constraint IF EXISTS attachments_approved_p_ck,
+      ALTER COLUMN approved_p DROP DEFAULT,
+      ALTER COLUMN approved_p TYPE boolean
+      USING approved_p::boolean,
+      ALTER COLUMN approved_p SET DEFAULT true;
+