Index: openacs-4/packages/acs-object-management/sql/postgresql/acs-kernel-changes-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-object-management/sql/postgresql/Attic/acs-kernel-changes-create.sql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/acs-object-management/sql/postgresql/acs-kernel-changes-create.sql	27 Nov 2009 00:38:50 -0000	1.2
+++ openacs-4/packages/acs-object-management/sql/postgresql/acs-kernel-changes-create.sql	10 Dec 2009 22:24:27 -0000	1.3
@@ -8,6 +8,23 @@
 values
   ('richtext', 'text');
 
+insert into acs_datatypes
+  (datatype, database_type, column_size)
+values
+  ('filename', 'varchar', '100');
+
+insert into acs_datatypes
+  (datatype, database_type)
+values
+  ('float', 'float8');
+
+-- PG 8.x has no unsigned integer datatype
+insert into acs_datatypes
+  (datatype, database_type)
+values
+  ('naturalnum', 'integer');
+
+
 -- Making user and person dynamic can lead to a broken web site, so
 -- for now at least I won't do it.  Code using these types have assumptions
 -- about the existence of certain attributes, and of course deleting them
@@ -87,10 +104,14 @@
   set database_type = 'integer'
   where datatype = 'integer';
 
-  update acs_datatypes
-  set database_type = 'money'
+  update acs_datatypes 
+  set datatype = 'currency'
   where datatype = 'money';
 
+  update acs_datatypes 
+  set database_type = 'money'
+  where datatype = 'currency';
+
   update acs_datatypes
   set database_type = 'timestamp'
   where datatype = 'date';