Index: openacs-4/packages/dynamic-types/sql/postgresql/metadata-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dynamic-types/sql/postgresql/metadata-create.sql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/dynamic-types/sql/postgresql/metadata-create.sql	15 Feb 2005 13:55:34 -0000	1.2
+++ openacs-4/packages/dynamic-types/sql/postgresql/metadata-create.sql	26 May 2005 10:27:58 -0000	1.3
@@ -15,7 +15,7 @@
   insert into dtype_db_datatypes (datatype, db_type)
   values (''integer'', ''integer'');
   insert into dtype_db_datatypes (datatype, db_type)
-  values (''money'', ''text'');
+  values (''money'', ''varchar(30)'');
   insert into dtype_db_datatypes (datatype, db_type)
   values (''date'', ''timestamp'');
   insert into dtype_db_datatypes (datatype, db_type)
@@ -25,11 +25,13 @@
   insert into dtype_db_datatypes (datatype, db_type)
   values (''enumeration'', ''text'');
   insert into dtype_db_datatypes (datatype, db_type)
-  values (''url'', ''text'');
+  values (''url'', ''varchar(1000)'');
   insert into dtype_db_datatypes (datatype, db_type)
-  values (''email'', ''text'');
+  values (''email'', ''varchar(100)'');
   insert into dtype_db_datatypes (datatype, db_type)
   values (''text'', ''text'');
+  insert into dtype_db_datatypes (datatype, db_type)
+  values (''string'', ''varchar(1000)'');
 
   raise notice ''Inserting standard widget metadata...'';
 
@@ -209,6 +211,21 @@
   insert into dtype_default_widgets (template_id, datatype)
   values (v_template_id, ''text'');
   
+  -- Text (single line) (default ''string'' widget)
+  v_template_id := dtype_wdgt_tmpl__new (
+      null,
+      null,
+      ''string'',
+      ''String'',
+      ''text'',
+      ''string'',
+      null,
+      null
+  );
+
+  insert into dtype_default_widgets (template_id, datatype)
+  values (v_template_id, ''string'');
+  
   -- Email Address
   v_template_id := dtype_wdgt_tmpl__new (
       null,
