Index: openacs-4/packages/acs-admin/acs-admin.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/acs-admin.info,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/acs-admin/acs-admin.info	27 Apr 2001 17:39:15 -0000	1.4
+++ openacs-4/packages/acs-admin/acs-admin.info	29 Apr 2001 01:16:08 -0000	1.5
@@ -95,6 +95,8 @@
             <file type="content_page" path="www/apm/version-generate-tarball.tcl"/>
             <file type="content_page" path="www/apm/version-parameter-values.tcl"/>
             <file type="query_file" path="www/apm/version-parameter-values.xql"/>
+            <file type="query_file" db_type="oracle" path="www/apm/version-parameters-oracle.xql"/>
+            <file type="query_file" db_type="postgresql" path="www/apm/version-parameters-postgresql.xql"/>
             <file type="content_page" path="www/apm/version-parameters.tcl"/>
             <file type="query_file" path="www/apm/version-parameters.xql"/>
             <file type="content_page" path="www/apm/version-reload.tcl"/>
@@ -112,7 +114,6 @@
             <file type="query_file" db_type="oracle" path="www/index-oracle.xql"/>
             <file type="query_file" db_type="postgresql" path="www/index-postgresql.xql"/>
             <file type="content_page" path="www/index.tcl"/>
-            <file type="query_file" path="www/index.xql"/>
             <file type="content_page" path="www/test/security-test.tcl"/>
             <file type="content_page" path="www/test/signed-cookies-test-2.tcl"/>
             <file type="query_file" path="www/test/signed-cookies-test-2.xql"/>
@@ -138,12 +139,15 @@
             <file type="content_page" path="www/users/member-state-change.adp"/>
             <file type="content_page" path="www/users/member-state-change.tcl"/>
             <file type="query_file" path="www/users/member-state-change.xql"/>
+            <file type="query_file" db_type="oracle" path="www/users/one-oracle.xql"/>
+            <file type="query_file" db_type="postgresql" path="www/users/one-postgresql.xql"/>
             <file type="content_page" path="www/users/one.adp"/>
             <file type="content_page" path="www/users/one.tcl"/>
             <file type="query_file" path="www/users/one.xql"/>
+            <file type="query_file" db_type="oracle" path="www/users/registration-history-oracle.xql"/>
+            <file type="query_file" db_type="postgresql" path="www/users/registration-history-postgresql.xql"/>
             <file type="content_page" path="www/users/registration-history.adp"/>
             <file type="content_page" path="www/users/registration-history.tcl"/>
-            <file type="query_file" path="www/users/registration-history.xql"/>
             <file type="content_page" path="www/users/search.adp"/>
             <file type="content_page" path="www/users/search.tcl"/>
             <file type="query_file" path="www/users/search.xql"/>
Index: openacs-4/packages/acs-subsite/acs-subsite.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/acs-subsite.info,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/acs-subsite/acs-subsite.info	23 Apr 2001 19:43:04 -0000	1.4
+++ openacs-4/packages/acs-subsite/acs-subsite.info	29 Apr 2001 01:16:08 -0000	1.5
@@ -16,7 +16,7 @@
         <owner url="mailto:oumi@arsdigita.com">Oumi Mehrotra</owner>
         <owner url="mailto:mbryzek@arsdigita.com">Michael Bryzek</owner>
         <summary>Provides the ability to create subsite within the ArsDigita Community System.</summary>
-        <release-date>2001-03-06</release-date>
+        <release-date>2001-03-06 00:00:00-08</release-date>
         <vendor url="http://www.arsdigita.com/">ArsDigita Corporation</vendor>
         <description format="text/html">Aware of parties, groups, users, portraits, ...</description>
 
@@ -42,7 +42,6 @@
             <file type="data_model_upgrade" db_type="oracle" path="sql/oracle/upgrade/upgrade-4.1.1-4.2.sql"/>
             <file type="data_model" db_type="oracle" path="sql/oracle/user-profiles-create.sql"/>
             <file type="data_model" db_type="oracle" path="sql/oracle/user-profiles-drop.sql"/>
-
             <file type="data_model_create" db_type="postgresql" path="sql/postgresql/acs-subsite-create.sql"/>
             <file type="data_model_drop" db_type="postgresql" path="sql/postgresql/acs-subsite-drop.sql"/>
             <file type="data_model" db_type="postgresql" path="sql/postgresql/application-groups-create.sql"/>
@@ -53,12 +52,9 @@
             <file type="data_model" db_type="postgresql" path="sql/postgresql/portraits.sql"/>
             <file type="data_model" db_type="postgresql" path="sql/postgresql/subsite-callbacks-create.sql"/>
             <file type="data_model" db_type="postgresql" path="sql/postgresql/subsite-callbacks-drop.sql"/>
-            <file type="data_model" db_type="postgresql" path="sql/postgresql/tests/acs-subsite-test-harness.sql"/>
-            <file type="data_model" db_type="postgresql" path="sql/postgresql/tests/subsite-callbacks-test.sql"/>
             <file type="data_model_upgrade" db_type="postgresql" path="sql/postgresql/upgrade/upgrade-4.1.1-4.2.sql"/>
             <file type="data_model" db_type="postgresql" path="sql/postgresql/user-profiles-create.sql"/>
             <file type="data_model" db_type="postgresql" path="sql/postgresql/user-profiles-drop.sql"/>
-
             <file type="tcl_init" path="tcl/acs-subsite-init.tcl"/>
             <file type="tcl_procs" path="tcl/application-group-procs.tcl"/>
             <file type="tcl_procs" path="tcl/attribute-procs.tcl"/>
@@ -143,6 +139,7 @@
             <file type="content_page" path="www/admin/groups/rel-type-remove-2.tcl"/>
             <file type="content_page" path="www/admin/groups/rel-type-remove.adp"/>
             <file type="content_page" path="www/admin/groups/rel-type-remove.tcl"/>
+            <file type="query_file" db_type="postgresql" path="www/admin/index-postgresql.xql"/>
             <file type="content_page" path="www/admin/index.adp"/>
             <file type="content_page" path="www/admin/index.tcl"/>
             <file type="content_page" path="www/admin/master.adp"/>
@@ -224,17 +221,26 @@
             <file type="content_page" path="www/admin/relations/remove-dependants-exist.adp"/>
             <file type="content_page" path="www/admin/relations/remove.adp"/>
             <file type="content_page" path="www/admin/relations/remove.tcl"/>
+            <file type="query_file" db_type="postgresql" path="www/admin/site-map/auto-mount-postgresql.xql"/>
             <file type="content_page" path="www/admin/site-map/auto-mount.tcl"/>
+            <file type="query_file" db_type="postgresql" path="www/admin/site-map/delete-postgresql.xql"/>
             <file type="content_page" path="www/admin/site-map/delete.tcl"/>
+            <file type="query_file" db_type="postgresql" path="www/admin/site-map/index-postgresql.xql"/>
             <file type="content_page" path="www/admin/site-map/index.tcl"/>
+            <file type="query_file" db_type="postgresql" path="www/admin/site-map/instance-delete-postgresql.xql"/>
             <file type="content_page" path="www/admin/site-map/instance-delete.tcl"/>
             <file type="content_page" path="www/admin/site-map/mount-2.tcl"/>
+            <file type="query_file" db_type="postgresql" path="www/admin/site-map/mount-postgresql.xql"/>
             <file type="content_page" path="www/admin/site-map/mount.tcl"/>
+            <file type="query_file" db_type="postgresql" path="www/admin/site-map/new-postgresql.xql"/>
             <file type="content_page" path="www/admin/site-map/new.tcl"/>
+            <file type="query_file" db_type="postgresql" path="www/admin/site-map/package-new-postgresql.xql"/>
             <file type="content_page" path="www/admin/site-map/package-new.tcl"/>
             <file type="content_page" path="www/admin/site-map/parameter-set-2.tcl"/>
+            <file type="query_file" db_type="postgresql" path="www/admin/site-map/parameter-set-postgresql.xql"/>
             <file type="content_page" path="www/admin/site-map/parameter-set.tcl"/>
             <file type="content_page" path="www/admin/site-map/unmount.tcl"/>
+            <file type="query_file" db_type="postgresql" path="www/admin/site-map/unmounted-postgresql.xql"/>
             <file type="content_page" path="www/admin/site-map/unmounted.tcl"/>
             <file type="content_page" path="www/admin/site-nodes/index.vuh"/>
             <file type="content_page" path="www/admin/users/new.adp"/>
@@ -244,30 +250,42 @@
             <file type="documentation" path="www/doc/group-admin-pages-requirements.html"/>
             <file type="documentation" path="www/doc/index.html"/>
             <file type="documentation" path="www/doc/intranet-company-structure.gif"/>
+            <file type="query_file" db_type="postgresql" path="www/index-postgresql.xql"/>
             <file type="content_page" path="www/index.adp"/>
             <file type="content_page" path="www/index.tcl"/>
             <file type="content_page" path="www/master.adp"/>
             <file type="content_page" path="www/master.tcl"/>
+            <file type="query_file" db_type="postgresql" path="www/permissions/grant-2-postgresql.xql"/>
             <file type="content_page" path="www/permissions/grant-2.tcl"/>
+            <file type="query_file" db_type="postgresql" path="www/permissions/grant-postgresql.xql"/>
             <file type="content_page" path="www/permissions/grant.tcl"/>
+            <file type="query_file" db_type="postgresql" path="www/permissions/index-postgresql.xql"/>
             <file type="content_page" path="www/permissions/index.tcl"/>
+            <file type="query_file" db_type="postgresql" path="www/permissions/one-postgresql.xql"/>
             <file type="content_page" path="www/permissions/one.tcl"/>
+            <file type="query_file" db_type="postgresql" path="www/permissions/revoke-2-postgresql.xql"/>
             <file type="content_page" path="www/permissions/revoke-2.tcl"/>
+            <file type="query_file" db_type="postgresql" path="www/permissions/revoke-postgresql.xql"/>
             <file type="content_page" path="www/permissions/revoke.tcl"/>
+            <file type="query_file" db_type="postgresql" path="www/permissions/toggle-inherit-postgresql.xql"/>
             <file type="content_page" path="www/permissions/toggle-inherit.tcl"/>
+            <file type="query_file" db_type="postgresql" path="www/pvt/alerts-postgresql.xql"/>
             <file type="content_page" path="www/pvt/alerts.adp"/>
             <file type="content_page" path="www/pvt/alerts.tcl"/>
+            <file type="query_file" db_type="postgresql" path="www/pvt/home-postgresql.xql"/>
             <file type="content_page" path="www/pvt/home.adp"/>
             <file type="content_page" path="www/pvt/home.tcl"/>
-            <file type="query_file" db_type="postgresql" path="www/pvt/home-postgresql.xql"/>
             <file type="content_page" path="www/pvt/index.tcl"/>
             <file type="content_page" path="www/pvt/set-on-vacation-to-null.adp"/>
             <file type="content_page" path="www/pvt/set-on-vacation-to-null.tcl"/>
             <file type="content_page" path="www/pvt/set-on-vacation-until.adp"/>
             <file type="content_page" path="www/pvt/set-on-vacation-until.tcl"/>
+            <file type="query_file" db_type="postgresql" path="www/pvt/toggle-dont-spam-me-p-postgresql.xql"/>
             <file type="content_page" path="www/pvt/toggle-dont-spam-me-p.tcl"/>
+            <file type="query_file" db_type="postgresql" path="www/pvt/unsubscribe-2-postgresql.xql"/>
             <file type="content_page" path="www/pvt/unsubscribe-2.adp"/>
             <file type="content_page" path="www/pvt/unsubscribe-2.tcl"/>
+            <file type="query_file" db_type="postgresql" path="www/pvt/unsubscribe-postgresql.xql"/>
             <file type="content_page" path="www/pvt/unsubscribe.adp"/>
             <file type="content_page" path="www/pvt/unsubscribe.tcl"/>
             <file type="content_page" path="www/register/awaiting-approval.adp"/>
@@ -304,6 +322,7 @@
             <file type="content_page" path="www/register/user-new.adp"/>
             <file type="content_page" path="www/register/user-new.tcl"/>
             <file type="content_page" path="www/shared/1pixel.tcl"/>
+            <file type="query_file" db_type="postgresql" path="www/shared/community-member-postgresql.xql"/>
             <file type="content_page" path="www/shared/community-member.adp"/>
             <file type="content_page" path="www/shared/community-member.tcl"/>
             <file type="content_page" path="www/shared/confirm.adp"/>
@@ -318,6 +337,7 @@
             <file type="content_page" path="www/shared/portrait.tcl"/>
             <file type="content_page" path="www/shared/send-email.adp"/>
             <file type="content_page" path="www/shared/send-email.tcl"/>
+            <file type="query_file" db_type="postgresql" path="www/shared/whos-online-postgresql.xql"/>
             <file type="content_page" path="www/shared/whos-online.adp"/>
             <file type="content_page" path="www/shared/whos-online.tcl"/>
             <file type="content_page" path="www/user/basic-info-update-2.tcl"/>
@@ -340,30 +360,30 @@
             <file type="content_page" path="www/user/portrait/upload.tcl"/>
         </files>
         <parameters>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="RestrictToSSL"  default="admin/*" description="URLs we want restricted to SSL. Note that this only takes effect if you have an SSL listener configured on your AOLserver."/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="RestrictEntireServerToRegisteredUsersP"  default="0" description="do we want to restrict the entire server to registered users (unused 09/18/2000)"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="bgcolor"  default="white" description="this setting sets the background color for the default-master template that all HTML content is returned in."/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="textcolor"  default="black" description="This setting sets the textcolor for the default master template that all HTML content is returned through."/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="background"  default="/graphics/bg.gif" description="Sets a default image background for the default master template (unused 09/18/2000)."/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="SomeAmericanReadersP"  default="1" description="is it even worth bothering asking for state and zip code?"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="LastVisitUpdateInterval"  default="600" description="how many seconds old a last visit cookie must be before we update it"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="TmpDir"  default="/tmp" description="What tmp directories are used on this system? Note the leading / character."/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="GlobalURLStub"  default="/global" description="Where is the global directory for such things as file-not-found error messages"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="SolicitPortraitP"  default="1" description="Set this to 1 if you want users to be asked to submit a portrait." section_name="user-info"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="MaxPortraitBytes"  default="200000" description="Maximum portrait size in bytes. Leave empty for no limitation." section_name="user-info"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="AcceptablePortraitMIMETypes"  default="image/gif image/jpeg" description="Enter a set of acceptable MIME types for portrait submissions." section_name="user-info"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="NotifyAdminOfNewRegistrationsP"  default="0" description="Notify someone of new registrations?" section_name="user-login"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="NewRegistrationEmailAddress"  default="admin@yourdomain.com" description="where to send those notes (defaults to SystemOwner)" section_name="user-login"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="EmailRegistrationConfirmationToUserP"  default="0" description="send confirmation email to user after registration" section_name="user-login"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="RegistrationRequiresApprovalP"  default="0" description="set this to 1 if user does not go live immediately" section_name="user-login"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="RegistrationRequiresEmailVerificationP"  default="0" description="set this to 1 if the user has to receive and email and come back to the site" section_name="user-login"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="RegistrationProvidesRandomPasswordP"  default="0" description="have the system generate a random password instead of the user" section_name="user-login"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="EmailRandomPasswordWhenForgottenP"  default="0" description="If so, do you choose a random a password (if you use encrypted password, a random password will always be generated)" section_name="user-login"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="UseCustomQuestionForPasswordReset"  default="1" description="Does the user get to choose their custom password question and answer" section_name="user-login"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="EmailChangedPasswordP"  default="0" description="if the admin changes the password, should it be mailed to the user" section_name="user-login"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="AllowPersistentLoginP"  default="1" description="do we allow persistent logins?" section_name="user-login"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="EmailForgottenPasswordP"  default="1" description="Email users forgotten passwords" section_name="user-login"/>
             <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="DefaultMaster"  default="/www/default-master" description="Path to the default master page (skin) for acs-templating.  Extensions                                             .adp/.tcl are implied."/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="EmailForgottenPasswordP"  default="1" description="Email users forgotten passwords" section_name="user-login"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="AllowPersistentLoginP"  default="1" description="do we allow persistent logins?" section_name="user-login"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="EmailChangedPasswordP"  default="0" description="if the admin changes the password, should it be mailed to the user" section_name="user-login"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="UseCustomQuestionForPasswordReset"  default="1" description="Does the user get to choose their custom password question and answer" section_name="user-login"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="EmailRandomPasswordWhenForgottenP"  default="0" description="If so, do you choose a random a password (if you use encrypted password, a random password will always be generated)" section_name="user-login"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="RegistrationProvidesRandomPasswordP"  default="0" description="have the system generate a random password instead of the user" section_name="user-login"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="RegistrationRequiresEmailVerificationP"  default="0" description="set this to 1 if the user has to receive and email and come back to the site" section_name="user-login"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="RegistrationRequiresApprovalP"  default="0" description="set this to 1 if user does not go live immediately" section_name="user-login"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="EmailRegistrationConfirmationToUserP"  default="0" description="send confirmation email to user after registration" section_name="user-login"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="NewRegistrationEmailAddress"  default="admin@yourdomain.com" description="where to send those notes (defaults to SystemOwner)" section_name="user-login"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="NotifyAdminOfNewRegistrationsP"  default="0" description="Notify someone of new registrations?" section_name="user-login"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="AcceptablePortraitMIMETypes"  default="image/gif image/jpeg" description="Enter a set of acceptable MIME types for portrait submissions." section_name="user-info"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="MaxPortraitBytes"  default="200000" description="Maximum portrait size in bytes. Leave empty for no limitation." section_name="user-info"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="SolicitPortraitP"  default="1" description="Set this to 1 if you want users to be asked to submit a portrait." section_name="user-info"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="GlobalURLStub"  default="/global" description="Where is the global directory for such things as file-not-found error messages"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="TmpDir"  default="/tmp" description="What tmp directories are used on this system? Note the leading / character."/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="LastVisitUpdateInterval"  default="600" description="how many seconds old a last visit cookie must be before we update it"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="SomeAmericanReadersP"  default="1" description="is it even worth bothering asking for state and zip code?"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="background"  default="/graphics/bg.gif" description="Sets a default image background for the default master template (unused 09/18/2000)."/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="textcolor"  default="black" description="This setting sets the textcolor for the default master template that all HTML content is returned through."/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="bgcolor"  default="white" description="this setting sets the background color for the default-master template that all HTML content is returned in."/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="RestrictEntireServerToRegisteredUsersP"  default="0" description="do we want to restrict the entire server to registered users (unused 09/18/2000)"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="RestrictToSSL"  default="admin/*" description="URLs we want restricted to SSL. Note that this only takes effect if you have an SSL listener configured on your AOLserver."/>
         </parameters>
 
     </version>