Index: openacs-4/packages/ams/sql/postgresql/populate.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ams/sql/postgresql/populate.sql,v
diff -u -N -r1.3 -r1.4
--- openacs-4/packages/ams/sql/postgresql/populate.sql	18 May 2005 17:11:48 -0000	1.3
+++ openacs-4/packages/ams/sql/postgresql/populate.sql	28 May 2005 15:37:27 -0000	1.4
@@ -1,430 +1,430 @@
---
--- packages/ams/sql/postgresql/populate.sql
---
--- @author Matthew Geddert openacs@geddert.com
--- @creation-date 2004-09-07
--- @cvs-id $Id$
---
---
-
-insert into ams_storage_types ( storage_type ) values ( 'telecom_number' );
-insert into ams_storage_types ( storage_type ) values ( 'postal_address' );
-insert into ams_storage_types ( storage_type ) values ( 'ams_options' );
-insert into ams_storage_types ( storage_type ) values ( 'time' );
-insert into ams_storage_types ( storage_type ) values ( 'value' );
-insert into ams_storage_types ( storage_type ) values ( 'value_with_mime_type' );
-
--- 
--- Note, I am very open to adding new unique widgets.
--- I am simply adding those I personally could imagine
--- needing in the near future for my projects. I am sure
--- that there will be others that other programmers need.
--- So, If you would like a new widget and possibly a new
--- storage type added to the default configuration of
--- this package please contact me.
---                                    -- Matthew
---
-
-insert into ams_widgets (
-        widget_name,
-        pretty_name,
-        pretty_plural,
-        storage_type,
-        acs_datatype,
-        widget,
-        datatype,
-        parameters
-) values (
-        'postal_address',
-        '#ams.Address#',
-        '#ams.Addresses#',
-        'postal_address',
-        'string',
-        'address',
-        'address',
-        null
-);
-
-insert into ams_widgets (
-        widget_name,
-        pretty_name,
-        pretty_plural,
-        storage_type,
-        acs_datatype,
-        widget,
-        datatype,
-        parameters
-) values (
-        'telecom_number',
-        '#ams.Telecom_Number#',
-        '#ams.Telecom_Numbers#',
-        'telecom_number',
-        'string',
-        'telecom_number',
-        'telecom_number',
-        '{html {size 12 maxlenth 50}}'
-);
-
-insert into ams_widgets (
-        widget_name,
-        pretty_name,
-        pretty_plural,
-        storage_type,
-        acs_datatype,
-        widget,
-        datatype,
-        parameters
-) values (
-        'date',
-        '#ams.Date#',
-        '#ams.Date#',
-        'time',
-        'date',
-        'date',
-        'date',
-        '{help}'
-);
-
-insert into ams_widgets (
-        widget_name,
-        pretty_name,
-        pretty_plural,
-        storage_type,
-        acs_datatype,
-        widget,
-        datatype,
-        parameters
-) values (
-        'select',
-        '#ams.Select# - #ams.One_Option_Allowed#',
-        '#ams.Selects# - #ams.One_Option_Allowed#',
-        'ams_options',
-        'string',
-        'select',
-        'integer',
-        null
-);
-
-insert into ams_widgets (
-        widget_name,
-        pretty_name,
-        pretty_plural,
-        storage_type,
-        acs_datatype,
-        widget,
-        datatype,
-        parameters
-) values (
-        'radio',
-        '#ams.Radio# - #ams.One_Option_Allowed#',
-        '#ams.Radios# - #ams.One_Option_Allowed#',
-        'ams_options',
-        'string',
-        'radio',
-        'integer',
-        null
-);
-
-insert into ams_widgets (
-        widget_name,
-        pretty_name,
-        pretty_plural,
-        storage_type,
-        acs_datatype,
-        widget,
-        datatype,
-        parameters
-) values (
-        'checkbox',
-        '#ams.Checkboxes# - #ams.Multiple_Options_Allowed#',
-        '#ams.Checkboxes# - #ams.Multiple_Options_Allowed#',
-        'ams_options',
-        'string',
-        'checkbox',
-        'integer',
-        '{multiple}'
-);
-
-insert into ams_widgets (
-        widget_name,
-        pretty_name,
-        pretty_plural,
-        storage_type,
-        acs_datatype,
-        widget,
-        datatype,
-        parameters
-) values (
-        'multiselect',
-        '#ams.Multiselect# - #ams.Multiple_Options_Allowed#',
-        '#ams.Multiselects# - #ams.Multiple_Options_Allowed#',
-        'ams_options',
-        'string',
-        'multiselect',
-        'integer',
-        '{multiple}'
-);
-
-insert into ams_widgets (
-        widget_name,
-        pretty_name,
-        pretty_plural,
-        storage_type,
-        acs_datatype,
-        widget,
-        datatype,
-        parameters
-) values (
-        'multiselect_single',
-        '#ams.Multiselect# - #ams.One_Option_Allowed#',
-        '#ams.Multiselects# - #ams.One_Option_Allowed#',
-        'ams_options',
-        'string',
-        'multiselect',
-        'integer',
-        null
-);
-
-insert into ams_widgets (
-        widget_name,
-        pretty_name,
-        pretty_plural,
-        storage_type,
-        acs_datatype,
-        widget,
-        datatype,
-        parameters
-) values (
-        'integer',
-        '#ams.Integer#',
-        '#ams.Integers#',
-        'value',
-        'integer',
-        'text',
-        'integer',
-        '{html {size 6}}'
-);
-
-insert into ams_widgets (
-        widget_name,
-        pretty_name,
-        pretty_plural,
-        storage_type,
-        acs_datatype,
-        widget,
-        datatype,
-        parameters
-) values (
-        'textbox_small',
-        '#ams.Textbox# - #ams.Small#',
-        '#ams.Textboxes# - #ams.Small#',
-        'value',
-        'string',
-        'text',
-        'text',
-        '{html {size 18}}'
-);
-
-insert into ams_widgets (
-        widget_name,
-        pretty_name,
-        pretty_plural,
-        storage_type,
-        acs_datatype,
-        widget,
-        datatype,
-        parameters
-) values (
-        'textbox_medium',
-        '#ams.Textbox# - #ams.Medium#',
-        '#ams.Textboxes# - #ams.Medium#',
-        'value',
-        'string',
-        'text',
-        'text',
-        '{html {size 30}}'
-);
-
-insert into ams_widgets (
-        widget_name,
-        pretty_name,
-        pretty_plural,
-        storage_type,
-        acs_datatype,
-        widget,
-        datatype,
-        parameters
-) values (
-        'textbox_large',
-        '#ams.Textbox# - #ams.Large#',
-        '#ams.Textboxes# - #ams.Large#',
-        'value',
-        'string',
-        'text',
-        'text',
-        '{html {size 50}}'
-);
-
-insert into ams_widgets (
-        widget_name,
-        pretty_name,
-        pretty_plural,
-        storage_type,
-        acs_datatype,
-        widget,
-        datatype,
-        parameters
-) values (
-        'textarea_small',
-        '#ams.Textarea# - #ams.Small#',
-        '#ams.Textareas# - #ams.Small#',
-        'value',
-        'text',
-        'textarea',
-        'text',
-        '{html {cols 60 rows 6}}'
-);
-
-insert into ams_widgets (
-        widget_name,
-        pretty_name,
-        pretty_plural,
-        storage_type,
-        acs_datatype,
-        widget,
-        datatype,
-        parameters
-) values (
-        'textarea_small_nospell',
-        '#ams.Textarea# - #ams.Small# - #ams.No_Spellcheck#',
-        '#ams.Textareas# - #ams.Small# - #ams.No_Spellcheck#',
-        'value',
-        'text',
-        'textarea',
-        'text',
-        '{html {cols 60 rows 6}} {nospell}'
-);
-
-insert into ams_widgets (
-        widget_name,
-        pretty_name,
-        pretty_plural,
-        storage_type,
-        acs_datatype,
-        widget,
-        datatype,
-        parameters
-) values (
-        'textarea_medium',
-        '#ams.Textarea# - #ams.Medium#',
-        '#ams.Textareas# - #ams.Medium#',
-        'value',
-        'text',
-        'textarea',
-        'text',
-        '{html {cols 80 rows 10}}'
-);
-
-insert into ams_widgets (
-        widget_name,
-        pretty_name,
-        pretty_plural,
-        storage_type,
-        acs_datatype,
-        widget,
-        datatype,
-        parameters
-) values (
-        'textarea_large',
-        '#ams.Textarea# - #ams.Large#',
-        '#ams.Textareas# - #ams.Large#',
-        'value',
-        'text',
-        'textarea',
-        'text',
-        '{html {cols 80 rows 24}}'
-);
-
-insert into ams_widgets (
-        widget_name,
-        pretty_name,
-        pretty_plural,
-        storage_type,
-        acs_datatype,
-        widget,
-        datatype,
-        parameters
-) values (
-        'richtext_medium',
-        '#ams.Richtext# - #ams.Medium#',
-        '#ams.Richtexts# - #ams.Medium#',
-        'value_with_mime_type',
-        'text',
-        'richtext',
-        'richtext',
-        '{html {cols 80 rows 10}}'
-);
-
-insert into ams_widgets (
-        widget_name,
-        pretty_name,
-        pretty_plural,
-        storage_type,
-        acs_datatype,
-        widget,
-        datatype,
-        parameters
-) values (
-        'richtext_large',
-        '#ams.Richtext# - #ams.Large#',
-        '#ams.Richtexts# - #ams.Large#',
-        'value_with_mime_type',
-        'text',
-        'richtext',
-        'richtext',
-        '{html {cols 80 rows 24}}'
-);
-
-
-insert into ams_widgets (
-        widget_name,
-        pretty_name,
-        pretty_plural,
-        storage_type,
-        acs_datatype,
-        widget,
-        datatype,
-        parameters
-) values (
-        'email',
-        '#ams.Email_Address#',
-        '#ams.Email_Addresses#',
-        'value',
-        'email',
-        'text',
-        'email',
-        '{html {size 30}}'
-);
-
-insert into ams_widgets (
-        widget_name,
-        pretty_name,
-        pretty_plural,
-        storage_type,
-        acs_datatype,
-        widget,
-        datatype,
-        parameters
-) values (
-        'url',
-        '#ams.Url#',
-        '#ams.Urls#',
-        'value',
-        'url',
-        'text',
-        'url',
-        '{html {size 30}}'
-);
-
-
-
+--
+-- packages/ams/sql/postgresql/populate.sql
+--
+-- @author Matthew Geddert openacs@geddert.com
+-- @creation-date 2004-09-07
+-- @cvs-id $Id$
+--
+--
+
+insert into ams_storage_types ( storage_type ) values ( 'telecom_number' );
+insert into ams_storage_types ( storage_type ) values ( 'postal_address' );
+insert into ams_storage_types ( storage_type ) values ( 'ams_options' );
+insert into ams_storage_types ( storage_type ) values ( 'time' );
+insert into ams_storage_types ( storage_type ) values ( 'value' );
+insert into ams_storage_types ( storage_type ) values ( 'value_with_mime_type' );
+
+-- 
+-- Note, I am very open to adding new unique widgets.
+-- I am simply adding those I personally could imagine
+-- needing in the near future for my projects. I am sure
+-- that there will be others that other programmers need.
+-- So, If you would like a new widget and possibly a new
+-- storage type added to the default configuration of
+-- this package please contact me.
+--                                    -- Matthew
+--
+
+insert into ams_widgets (
+        widget_name,
+        pretty_name,
+        pretty_plural,
+        storage_type,
+        acs_datatype,
+        widget,
+        datatype,
+        parameters
+) values (
+        'postal_address',
+        '#ams.Address#',
+        '#ams.Addresses#',
+        'postal_address',
+        'string',
+        'address',
+        'address',
+        null
+);
+
+insert into ams_widgets (
+        widget_name,
+        pretty_name,
+        pretty_plural,
+        storage_type,
+        acs_datatype,
+        widget,
+        datatype,
+        parameters
+) values (
+        'telecom_number',
+        '#ams.Telecom_Number#',
+        '#ams.Telecom_Numbers#',
+        'telecom_number',
+        'string',
+        'telecom_number',
+        'telecom_number',
+        '{html {size 12 maxlenth 50}}'
+);
+
+insert into ams_widgets (
+        widget_name,
+        pretty_name,
+        pretty_plural,
+        storage_type,
+        acs_datatype,
+        widget,
+        datatype,
+        parameters
+) values (
+        'date',
+        '#ams.Date#',
+        '#ams.Date#',
+        'time',
+        'date',
+        'date',
+        'date',
+        '{help}'
+);
+
+insert into ams_widgets (
+        widget_name,
+        pretty_name,
+        pretty_plural,
+        storage_type,
+        acs_datatype,
+        widget,
+        datatype,
+        parameters
+) values (
+        'select',
+        '#ams.Select# - #ams.One_Option_Allowed#',
+        '#ams.Selects# - #ams.One_Option_Allowed#',
+        'ams_options',
+        'string',
+        'select',
+        'integer',
+        null
+);
+
+insert into ams_widgets (
+        widget_name,
+        pretty_name,
+        pretty_plural,
+        storage_type,
+        acs_datatype,
+        widget,
+        datatype,
+        parameters
+) values (
+        'radio',
+        '#ams.Radio# - #ams.One_Option_Allowed#',
+        '#ams.Radios# - #ams.One_Option_Allowed#',
+        'ams_options',
+        'string',
+        'radio',
+        'integer',
+        null
+);
+
+insert into ams_widgets (
+        widget_name,
+        pretty_name,
+        pretty_plural,
+        storage_type,
+        acs_datatype,
+        widget,
+        datatype,
+        parameters
+) values (
+        'checkbox',
+        '#ams.Checkboxes# - #ams.Multiple_Options_Allowed#',
+        '#ams.Checkboxes# - #ams.Multiple_Options_Allowed#',
+        'ams_options',
+        'string',
+        'checkbox',
+        'integer',
+        '{multiple}'
+);
+
+insert into ams_widgets (
+        widget_name,
+        pretty_name,
+        pretty_plural,
+        storage_type,
+        acs_datatype,
+        widget,
+        datatype,
+        parameters
+) values (
+        'multiselect',
+        '#ams.Multiselect# - #ams.Multiple_Options_Allowed#',
+        '#ams.Multiselects# - #ams.Multiple_Options_Allowed#',
+        'ams_options',
+        'string',
+        'multiselect',
+        'integer',
+        '{multiple}'
+);
+
+insert into ams_widgets (
+        widget_name,
+        pretty_name,
+        pretty_plural,
+        storage_type,
+        acs_datatype,
+        widget,
+        datatype,
+        parameters
+) values (
+        'multiselect_single',
+        '#ams.Multiselect# - #ams.One_Option_Allowed#',
+        '#ams.Multiselects# - #ams.One_Option_Allowed#',
+        'ams_options',
+        'string',
+        'multiselect',
+        'integer',
+        null
+);
+
+insert into ams_widgets (
+        widget_name,
+        pretty_name,
+        pretty_plural,
+        storage_type,
+        acs_datatype,
+        widget,
+        datatype,
+        parameters
+) values (
+        'integer',
+        '#ams.Integer#',
+        '#ams.Integers#',
+        'value',
+        'integer',
+        'text',
+        'integer',
+        '{html {size 6}}'
+);
+
+insert into ams_widgets (
+        widget_name,
+        pretty_name,
+        pretty_plural,
+        storage_type,
+        acs_datatype,
+        widget,
+        datatype,
+        parameters
+) values (
+        'textbox_small',
+        '#ams.Textbox# - #ams.Small#',
+        '#ams.Textboxes# - #ams.Small#',
+        'value',
+        'string',
+        'text',
+        'text',
+        '{html {size 18}}'
+);
+
+insert into ams_widgets (
+        widget_name,
+        pretty_name,
+        pretty_plural,
+        storage_type,
+        acs_datatype,
+        widget,
+        datatype,
+        parameters
+) values (
+        'textbox_medium',
+        '#ams.Textbox# - #ams.Medium#',
+        '#ams.Textboxes# - #ams.Medium#',
+        'value',
+        'string',
+        'text',
+        'text',
+        '{html {size 30}}'
+);
+
+insert into ams_widgets (
+        widget_name,
+        pretty_name,
+        pretty_plural,
+        storage_type,
+        acs_datatype,
+        widget,
+        datatype,
+        parameters
+) values (
+        'textbox_large',
+        '#ams.Textbox# - #ams.Large#',
+        '#ams.Textboxes# - #ams.Large#',
+        'value',
+        'string',
+        'text',
+        'text',
+        '{html {size 50}}'
+);
+
+insert into ams_widgets (
+        widget_name,
+        pretty_name,
+        pretty_plural,
+        storage_type,
+        acs_datatype,
+        widget,
+        datatype,
+        parameters
+) values (
+        'textarea_small',
+        '#ams.Textarea# - #ams.Small#',
+        '#ams.Textareas# - #ams.Small#',
+        'value',
+        'text',
+        'textarea',
+        'text',
+        '{html {cols 60 rows 6}}'
+);
+
+insert into ams_widgets (
+        widget_name,
+        pretty_name,
+        pretty_plural,
+        storage_type,
+        acs_datatype,
+        widget,
+        datatype,
+        parameters
+) values (
+        'textarea_small_nospell',
+        '#ams.Textarea# - #ams.Small# - #ams.No_Spellcheck#',
+        '#ams.Textareas# - #ams.Small# - #ams.No_Spellcheck#',
+        'value',
+        'text',
+        'textarea',
+        'text',
+        '{html {cols 60 rows 6}} {nospell}'
+);
+
+insert into ams_widgets (
+        widget_name,
+        pretty_name,
+        pretty_plural,
+        storage_type,
+        acs_datatype,
+        widget,
+        datatype,
+        parameters
+) values (
+        'textarea_medium',
+        '#ams.Textarea# - #ams.Medium#',
+        '#ams.Textareas# - #ams.Medium#',
+        'value',
+        'text',
+        'textarea',
+        'text',
+        '{html {cols 80 rows 10}}'
+);
+
+insert into ams_widgets (
+        widget_name,
+        pretty_name,
+        pretty_plural,
+        storage_type,
+        acs_datatype,
+        widget,
+        datatype,
+        parameters
+) values (
+        'textarea_large',
+        '#ams.Textarea# - #ams.Large#',
+        '#ams.Textareas# - #ams.Large#',
+        'value',
+        'text',
+        'textarea',
+        'text',
+        '{html {cols 80 rows 24}}'
+);
+
+insert into ams_widgets (
+        widget_name,
+        pretty_name,
+        pretty_plural,
+        storage_type,
+        acs_datatype,
+        widget,
+        datatype,
+        parameters
+) values (
+        'richtext_medium',
+        '#ams.Richtext# - #ams.Medium#',
+        '#ams.Richtexts# - #ams.Medium#',
+        'value_with_mime_type',
+        'text',
+        'richtext',
+        'richtext',
+        '{html {cols 80 rows 10}}'
+);
+
+insert into ams_widgets (
+        widget_name,
+        pretty_name,
+        pretty_plural,
+        storage_type,
+        acs_datatype,
+        widget,
+        datatype,
+        parameters
+) values (
+        'richtext_large',
+        '#ams.Richtext# - #ams.Large#',
+        '#ams.Richtexts# - #ams.Large#',
+        'value_with_mime_type',
+        'text',
+        'richtext',
+        'richtext',
+        '{html {cols 80 rows 24}}'
+);
+
+
+insert into ams_widgets (
+        widget_name,
+        pretty_name,
+        pretty_plural,
+        storage_type,
+        acs_datatype,
+        widget,
+        datatype,
+        parameters
+) values (
+        'email',
+        '#ams.Email_Address#',
+        '#ams.Email_Addresses#',
+        'value',
+        'email',
+        'text',
+        'email',
+        '{html {size 30}}'
+);
+
+insert into ams_widgets (
+        widget_name,
+        pretty_name,
+        pretty_plural,
+        storage_type,
+        acs_datatype,
+        widget,
+        datatype,
+        parameters
+) values (
+        'url',
+        '#ams.Url#',
+        '#ams.Urls#',
+        'value',
+        'url',
+        'text',
+        'url',
+        '{html {size 30}}'
+);
+
+
+