Index: openacs-4/packages/ecommerce/ecommerce.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/ecommerce.info,v
diff -u -r1.11 -r1.12
--- openacs-4/packages/ecommerce/ecommerce.info	24 Nov 2001 03:45:00 -0000	1.11
+++ openacs-4/packages/ecommerce/ecommerce.info	6 Jan 2002 07:32:18 -0000	1.12
@@ -43,6 +43,8 @@
             <file type="data_model" db_type="postgresql" path="sql/postgresql/ec-product-package-drop.sql"/>
             <file type="data_model" db_type="postgresql" path="sql/postgresql/ec-product-sws-drop.sql"/>
             <file type="data_model" db_type="postgresql" path="sql/postgresql/ec-product-sws-setup.sql"/>
+            <file type="data_model" db_type="postgresql" path="sql/postgresql/ec-products-sc-create.sql"/>
+            <file type="data_model" db_type="postgresql" path="sql/postgresql/ec-products-sc-drop.sql"/>
             <file type="data_model_create" db_type="postgresql" path="sql/postgresql/ecommerce-create.sql"/>
             <file type="data_model" db_type="postgresql" path="sql/postgresql/ecommerce-defaults.sql"/>
             <file type="data_model_drop" db_type="postgresql" path="sql/postgresql/ecommerce-drop.sql"/>
@@ -53,6 +55,7 @@
             <file type="query_file" db_type="postgresql" path="tcl/ec-audit-trail-procs-postgresql.xql"/>
             <file type="tcl_procs" path="tcl/ec-audit-trail-procs.tcl"/>
             <file type="query_file" path="tcl/ec-audit-trail-procs.xql"/>
+            <file type="tcl_procs" path="tcl/ec-products-sc-procs.tcl"/>
             <file type="tcl_procs" path="tcl/ec-style-procs.tcl"/>
             <file type="query_file" path="tcl/ec-style-procs.xql"/>
             <file type="query_file" db_type="oracle" path="tcl/ecommerce-credit-procs-oracle.xql"/>
@@ -972,56 +975,56 @@
             <file type="query_file" path="www/update-user-classes.xql"/>
         </files>
         <parameters>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="TemplateRoot"  default="templates/store" description="A filesystem location of style templates, typically [ad_conn package_url]/templates.  Note the lack of a trailing slash.  If TemplateRoot starts with a leading / or with a ../, the TemplateRoot is interpreted relative to your server's pageroot (/web/yourservername/www, otherwise it is interpreted relative to the pageroot of your ecommerce instance.  Templates are first looked in a directory underneath the templateroot that matches the name  of the directory the url was served from, and then if nothing is found, templates are looked for in the templateroot." section_name="style"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="ECTemplatesMayContainTclFunctionsP"  default="1" description="If yes, administrators editing an ecommerce template can use a tcl function, which may cause security problems." section_name="style"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="ImageMagickPath"  default="/usr/local/bin/convert" description="ImageMagick's Convert utility is required to make thumbnails of products.  This parameter points to the path of convert" section_name="technical"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="httpsModule"  default="nsopenssl" description="The preferred AOLserver module that implements SSL.  Typical behavior favors nsopenssl over nsssl.  This parameter is only important if your site, for some unusual reason supports both nsopenssl as well as nsssl and you prefer nsssl." section_name="SSL"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="PlainFancyCookieP"  default="1" description="Offer visitors a graphics choice without logging in?" section_name="style"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="PlainFancyP"  default="1" description="do we look for plain, and fancy templates, e.g., foobar.plain.adp? (and do we offer a user interface to allow the user to choose?)" section_name="style"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="LanguageCookieP"  default="1" description="Offer visitors a language choice without logging in?" section_name="style"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="LanguageSiteDefault"  default="en" description="The default site language.  See /doc/ecommerce/style#languagerepresentation for details." section_name="style"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="MultiLingualP"  default="0" description="do we look for language-specific templates. e.g., foobar.en.adp? (and do we offer a user interface to help user choose?)" section_name="style"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="HeaderAttributes"  default="size='+2' face='arial' color='990000'" description="font tags used in system headers" section_name="style"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="SystemName"  default="Store" description="name of ecommerce system"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="SystemOwner"  description="email address of owner of shop" section_name="technical"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="CacheRefresh"  default="600" description="Seconds between cache (util_memoize) updates" section_name="technical"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="OfferTaxExemptStatusP"  default="0" description="Should we ask people if their organization is tax exempt?" section_name="associated charges"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="MultipleRetailersPerProductP"  default="0" description="Set to 1 if you have a comparison shopping service -- Note: support for multiple retailers does not work yet in Version 1.0 of the Ecommerce Module, so leave it as 0" section_name="technical"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="ProductDataDirectory"  default="product/" description="This path goes on the end of the EcommerceDataDirectory. IF YOU DON'T SET THIS CORRECTLY, YOUR SYSTEM WON'T WORK!  Make sure to replace yourservername with the correct name.  You also have to create the directories you specify in the file-system.  See technical setup document." section_name="technical"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="EcommerceDataDirectory"  default="/web/yourservername/data/ecommerce/" description="path to Product data directories (where product files like images are kept).  It is useful to keep this away from the normal pageroot so that uploaded .tcl or .adp files cannot be executed with a URL. IF YOU DON'T SET THIS CORRECTLY, YOUR SYSTEM WON'T WORK!  Make sure to replace yourservername with the correct name.  You also have to create the directories you specify in the file-system.  See technical setup document." section_name="technical"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="GiftCertificateMonths"  default="12" description="number of months until user-purchased gift certificates expire" section_name="gift certificates"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="MaxGiftCertificateAmount"  default="300" description="maximum gift certificate amount they can buy" section_name="gift certificates"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="MinGiftCertificateAmount"  default="5" description="minimum gift certificate amount they can buy (this does not impose minimum amount for administrators giving users gift certificates)" section_name="gift certificates"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="SellGiftCertificatesP"  default="1" description="whether to allow users to buy gift certificates" section_name="gift certificates"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="DisplayTransactionMessagesDuringFulfillmentP"  default="1" description="you may or may not wish to have the people recording shipments receive messages like 'unable to authorize payment for shipment' -- depending on whether they they're in a position to do anything about the problem (e.g. abort shipment)" section_name="fulfillment"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="CustomerServiceEmailAddress"  default="service@yourdomain.com" description="all outgoing email is sent from this address" section_name="technical"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="AllowPreOrdersP"  default="1" description="whether customers will be able to place orders for items whose available_date has not yet come" section_name="shopping cart"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="CartDuration"  default="30" description="# of days an 'in_basket' order will remain in the system before a cron job expires it" section_name="shopping cart"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="StockMessageI"  default="In Stock" description="in stock" section_name="messages"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="StockMessageS"  default="Usually Ships Within 2-4 Weeks" description="text of ships slowly message" section_name="messages"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="StockMessageM"  default="Usually Ships Within 2-3 Days" description="text of hips moderately quickly message" section_name="messages"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="StockMessageQ"  default="Usually Ships Within 24 Hours" description="text of ships quickly message" section_name="messages"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="StockMessageO"  default="Out of Stock" description="text of out of stock message" section_name="messages"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="ThumbnailHeight"  default="100" description="for thumbnails of products, specify either width or height (whichever is more important, and then the other will be determined based on the original image size, keeping aspect ratio constant) -- if both are specified, the width setting will take precedence, and if neither is specified, the thumbnail will be width default=100" section_name="display"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="ThumbnailWidth"  default="100" description="for thumbnails of products, specify either width or height (whichever is more important, and then the other will be determined based on the original image size, keeping aspect ratio constant) -- if both are specified, the width setting will take precedence, and if neither is specified, the thumbnail will be width default=100" section_name="display"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="EnabledP"  default="1" description="set this to 1 if you're using the ecommerce module"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="UseCyberCashP"  default="1" description="whether to use cybercash or not (if cyber cash is off, remember to save credit cards otherwise they may be lost before you actually bill customers)" section_name="payment information"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="SaveCreditCardDataP"  default="1" description="whether to save credit card data (you have to save it if you're going to do manual billing) -- if you save it, then your users can reuse their credit card with one click" section_name="payment information"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="ExpressShippingP"  default="1" description="whether to allow express shipping" section_name="shipping"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="ShippingRefundPercent"  default="0" description="percentage refunded if an item is returned" section_name="associated charges"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="UserClassApproveP"  default="1" description="if a user requests to be in a user class, is approval required before that user becomes a member of the user class" section_name="display"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="UserClassAllowSelfPlacement"  default="1" description="whether a user can request to be a member of a user class" section_name="display"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="UserClassUserViewP"  default="1" description="whether users can see what user classes they are in" section_name="display"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="CalcProductRelationshipsP"  default="0" description="whether the system should calculate additional product relationships" section_name="display"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="ProductCommentsNeedApprovalP"  default="1" description="whether user comments on products (if allowed) need approval before becoming live" section_name="display"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="ProductCommentsAllowP"  default="1" description="whether to allow user comments on products" section_name="display"/>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="ProductsToDisplayPerPage"  default="10" description="this is used on the category browse page (and for subcategories/subsubcategories)" section_name="display"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="Currency"  default="USD" description="currency units, USD, dollars, lira, etc." section_name="units"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="WeightUnits"  default="lbs" description="weight units such as pounds, carats, ounces, etc." section_name="units"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="SecureLocation"  description="A URL fragment (protocol, hostname, and port) appended before transactions URLs.  Defaults to &quot;&quot;.  If the value is &quot;&quot; ecommerce will examine the values of httpModule and httpsModule to determine the secure location." section_name="SSL"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="InsecureLocation"  description="A URL fragment (protocol, hostname, and port) appended before &quot;insecure&quot; transactions URLs. Defaults to &quot;&quot;" section_name="SSL"/>
-            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="PlainFancySiteDefault"  default="fancy" description="Most publishers will want &quot;fancy&quot; to be preferred (if available)" section_name="style"/>
             <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="httpModule"  description="The AOLserver module that implements &quot;normal&quot; communications (usually nsunix or nssock) Typical behavior favors nsunix over nssock, if both are present.  You only need to set this parameter if your site supports both nsunix and nssock, but you prefer nssock." section_name="SSL"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="PlainFancySiteDefault"  default="fancy" description="Most publishers will want &quot;fancy&quot; to be preferred (if available)" section_name="style"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="InsecureLocation"  description="A URL fragment (protocol, hostname, and port) appended before &quot;insecure&quot; transactions URLs. Defaults to &quot;&quot;" section_name="SSL"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="SecureLocation"  description="A URL fragment (protocol, hostname, and port) appended before transactions URLs.  Defaults to &quot;&quot;.  If the value is &quot;&quot; ecommerce will examine the values of httpModule and httpsModule to determine the secure location." section_name="SSL"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="WeightUnits"  default="lbs" description="weight units such as pounds, carats, ounces, etc." section_name="units"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="Currency"  default="USD" description="currency units, USD, dollars, lira, etc." section_name="units"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="ProductsToDisplayPerPage"  default="10" description="this is used on the category browse page (and for subcategories/subsubcategories)" section_name="display"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="ProductCommentsAllowP"  default="1" description="whether to allow user comments on products" section_name="display"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="ProductCommentsNeedApprovalP"  default="1" description="whether user comments on products (if allowed) need approval before becoming live" section_name="display"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="CalcProductRelationshipsP"  default="0" description="whether the system should calculate additional product relationships" section_name="display"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="UserClassUserViewP"  default="1" description="whether users can see what user classes they are in" section_name="display"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="UserClassAllowSelfPlacement"  default="1" description="whether a user can request to be a member of a user class" section_name="display"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="UserClassApproveP"  default="1" description="if a user requests to be in a user class, is approval required before that user becomes a member of the user class" section_name="display"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="ShippingRefundPercent"  default="0" description="percentage refunded if an item is returned" section_name="associated charges"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="ExpressShippingP"  default="1" description="whether to allow express shipping" section_name="shipping"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="SaveCreditCardDataP"  default="1" description="whether to save credit card data (you have to save it if you're going to do manual billing) -- if you save it, then your users can reuse their credit card with one click" section_name="payment information"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="UseCyberCashP"  default="1" description="whether to use cybercash or not (if cyber cash is off, remember to save credit cards otherwise they may be lost before you actually bill customers)" section_name="payment information"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="EnabledP"  default="1" description="set this to 1 if you're using the ecommerce module"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="ThumbnailWidth"  default="100" description="for thumbnails of products, specify either width or height (whichever is more important, and then the other will be determined based on the original image size, keeping aspect ratio constant) -- if both are specified, the width setting will take precedence, and if neither is specified, the thumbnail will be width default=100" section_name="display"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="ThumbnailHeight"  default="100" description="for thumbnails of products, specify either width or height (whichever is more important, and then the other will be determined based on the original image size, keeping aspect ratio constant) -- if both are specified, the width setting will take precedence, and if neither is specified, the thumbnail will be width default=100" section_name="display"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="StockMessageO"  default="Out of Stock" description="text of out of stock message" section_name="messages"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="StockMessageQ"  default="Usually Ships Within 24 Hours" description="text of ships quickly message" section_name="messages"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="StockMessageM"  default="Usually Ships Within 2-3 Days" description="text of hips moderately quickly message" section_name="messages"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="StockMessageS"  default="Usually Ships Within 2-4 Weeks" description="text of ships slowly message" section_name="messages"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="StockMessageI"  default="In Stock" description="in stock" section_name="messages"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="CartDuration"  default="30" description="# of days an 'in_basket' order will remain in the system before a cron job expires it" section_name="shopping cart"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="AllowPreOrdersP"  default="1" description="whether customers will be able to place orders for items whose available_date has not yet come" section_name="shopping cart"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="CustomerServiceEmailAddress"  default="service@yourdomain.com" description="all outgoing email is sent from this address" section_name="technical"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="DisplayTransactionMessagesDuringFulfillmentP"  default="1" description="you may or may not wish to have the people recording shipments receive messages like 'unable to authorize payment for shipment' -- depending on whether they they're in a position to do anything about the problem (e.g. abort shipment)" section_name="fulfillment"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="SellGiftCertificatesP"  default="1" description="whether to allow users to buy gift certificates" section_name="gift certificates"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="MinGiftCertificateAmount"  default="5" description="minimum gift certificate amount they can buy (this does not impose minimum amount for administrators giving users gift certificates)" section_name="gift certificates"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="MaxGiftCertificateAmount"  default="300" description="maximum gift certificate amount they can buy" section_name="gift certificates"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="GiftCertificateMonths"  default="12" description="number of months until user-purchased gift certificates expire" section_name="gift certificates"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="EcommerceDataDirectory"  default="/web/yourservername/data/ecommerce/" description="path to Product data directories (where product files like images are kept).  It is useful to keep this away from the normal pageroot so that uploaded .tcl or .adp files cannot be executed with a URL. IF YOU DON'T SET THIS CORRECTLY, YOUR SYSTEM WON'T WORK!  Make sure to replace yourservername with the correct name.  You also have to create the directories you specify in the file-system.  See technical setup document." section_name="technical"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="ProductDataDirectory"  default="product/" description="This path goes on the end of the EcommerceDataDirectory. IF YOU DON'T SET THIS CORRECTLY, YOUR SYSTEM WON'T WORK!  Make sure to replace yourservername with the correct name.  You also have to create the directories you specify in the file-system.  See technical setup document." section_name="technical"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="MultipleRetailersPerProductP"  default="0" description="Set to 1 if you have a comparison shopping service -- Note: support for multiple retailers does not work yet in Version 1.0 of the Ecommerce Module, so leave it as 0" section_name="technical"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="OfferTaxExemptStatusP"  default="0" description="Should we ask people if their organization is tax exempt?" section_name="associated charges"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="CacheRefresh"  default="600" description="Seconds between cache (util_memoize) updates" section_name="technical"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="SystemOwner"  description="email address of owner of shop" section_name="technical"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="SystemName"  default="Store" description="name of ecommerce system"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="HeaderAttributes"  default="size='+2' face='arial' color='990000'" description="font tags used in system headers" section_name="style"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="MultiLingualP"  default="0" description="do we look for language-specific templates. e.g., foobar.en.adp? (and do we offer a user interface to help user choose?)" section_name="style"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="LanguageSiteDefault"  default="en" description="The default site language.  See /doc/ecommerce/style#languagerepresentation for details." section_name="style"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="LanguageCookieP"  default="1" description="Offer visitors a language choice without logging in?" section_name="style"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="PlainFancyP"  default="1" description="do we look for plain, and fancy templates, e.g., foobar.plain.adp? (and do we offer a user interface to allow the user to choose?)" section_name="style"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="PlainFancyCookieP"  default="1" description="Offer visitors a graphics choice without logging in?" section_name="style"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="httpsModule"  default="nsopenssl" description="The preferred AOLserver module that implements SSL.  Typical behavior favors nsopenssl over nsssl.  This parameter is only important if your site, for some unusual reason supports both nsopenssl as well as nsssl and you prefer nsssl." section_name="SSL"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="ImageMagickPath"  default="/usr/local/bin/convert" description="ImageMagick's Convert utility is required to make thumbnails of products.  This parameter points to the path of convert" section_name="technical"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="ECTemplatesMayContainTclFunctionsP"  default="1" description="If yes, administrators editing an ecommerce template can use a tcl function, which may cause security problems." section_name="style"/>
+            <parameter datatype="string"  min_n_values="1"  max_n_values="1"  name="TemplateRoot"  default="templates/store" description="A filesystem location of style templates, typically [ad_conn package_url]/templates.  Note the lack of a trailing slash.  If TemplateRoot starts with a leading / or with a ../, the TemplateRoot is interpreted relative to your server's pageroot (/web/yourservername/www, otherwise it is interpreted relative to the pageroot of your ecommerce instance.  Templates are first looked in a directory underneath the templateroot that matches the name  of the directory the url was served from, and then if nothing is found, templates are looked for in the templateroot." section_name="style"/>
         </parameters>
 
     </version>
Index: openacs-4/packages/ecommerce/sql/postgresql/ecommerce-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/sql/postgresql/ecommerce-create.sql,v
diff -u -r1.12 -r1.13
--- openacs-4/packages/ecommerce/sql/postgresql/ecommerce-create.sql	22 Oct 2001 06:40:53 -0000	1.12
+++ openacs-4/packages/ecommerce/sql/postgresql/ecommerce-create.sql	6 Jan 2002 07:31:04 -0000	1.13
@@ -7,7 +7,8 @@
 --
 -- ported to OpenACS by Gilbert wong (gwong@orchardlabs.com)
 -- July 2001
-
+-- OpenFTS Search added by Bart Teeuwisse (bart.teeuwisse@7-sisters.com
+--
 -- Besides the tables defined here, you also need to import
 -- zip_codes, which contains the following columns:
 --  ZIP_CODE                               NOT NULL VARCHAR2(10)
@@ -3360,3 +3361,4 @@
 \i pl-sql-utilities.sql
 \i ec-product-package-create.sql
 \i ecommerce-defaults.sql
+\i ec-products-sc-create.sql
Index: openacs-4/packages/ecommerce/sql/postgresql/ecommerce-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/sql/postgresql/ecommerce-drop.sql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/ecommerce/sql/postgresql/ecommerce-drop.sql	20 Aug 2001 04:04:09 -0000	1.4
+++ openacs-4/packages/ecommerce/sql/postgresql/ecommerce-drop.sql	6 Jan 2002 07:31:04 -0000	1.5
@@ -267,3 +267,4 @@
 \i pl-sql-utilities-drop.sql
 \i ec-product-package-drop.sql
 \i acs-geo-tables-drop.sql
+\i ec-products-sc-drop.sql