Index: openacs-4/packages/curriculum/sql/postgresql/upgrade/upgrade-0.2d-0.3d.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/curriculum/sql/postgresql/upgrade/upgrade-0.2d-0.3d.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/curriculum/sql/postgresql/upgrade/upgrade-0.2d-0.3d.sql	10 Jun 2003 09:43:26 -0000	1.1
@@ -0,0 +1,13 @@
+-- Upgrade script: Add columns external_p and subsite_external_p to cu_elements.
+
+ALTER TABLE cu_elements ADD COLUMN external_p char(1) constraint cu_elements_external_p_ck CHECK (external_p in ('t','f'));
+
+ALTER TABLE cu_elements ALTER COLUMN external_p SET DEFAULT 'f';
+
+UPDATE cu_elements
+SET    external_p = case when substring(url from 1 for 7) = 'http://'
+                    then 't' else 'f' end;
+
+ALTER TABLE cu_elements ALTER COLUMN external_p SET NOT NULL;
+
+\i curriculum-element-package-create.sql