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 -N -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';
Index: openacs-4/packages/acs-object-management/sql/postgresql/acs-templating-changes-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-object-management/sql/postgresql/acs-templating-changes-create.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/acs-object-management/sql/postgresql/acs-templating-changes-create.sql	27 Nov 2009 00:38:50 -0000	1.1
+++ openacs-4/packages/acs-object-management/sql/postgresql/acs-templating-changes-create.sql	10 Dec 2009 22:24:27 -0000	1.2
@@ -260,6 +260,10 @@
     (param_id, widget, param, required_p, html_p, default_value)
   values
     (121, 'search', 'result_datatype', 'f', 'f', 'search');
+
+  -- currency widget
+  insert into acs_form_widgets (widget) values ('currency');
+
 end;
 
 -- default widgets for datatypes
@@ -304,7 +308,7 @@
   insert into acs_form_default_widgets
     (datatype, widget)
   values
-    ('money', 'text');
+    ('currency', 'currency');
 
   insert into acs_form_default_widgets
     (datatype, widget)
@@ -340,4 +344,20 @@
     (datatype, widget)
   values
     ('time_of_day', 'timestamp');
+    
+  insert into acs_form_default_widgets
+    (datatype, widget)
+  values
+    ('filename', 'text');
+
+  insert into acs_form_default_widgets
+    (datatype, widget)
+  values
+    ('float', 'text');
+
+  insert into acs_form_default_widgets
+    (datatype, widget)
+  values
+    ('naturalnum', 'text');
+    
 end;