Index: branches/5.1.x/units/products/products_config.php
===================================================================
diff -u -N -r13938 -r13959
--- branches/5.1.x/units/products/products_config.php	(.../products_config.php)	(revision 13938)
+++ branches/5.1.x/units/products/products_config.php	(.../products_config.php)	(revision 13959)
@@ -1,6 +1,6 @@
 <?php
 /**
-* @version	$Id: products_config.php 13938 2010-09-14 09:12:39Z alex $
+* @version	$Id: products_config.php 13959 2010-09-25 18:36:10Z alex $
 * @package	In-Commerce
 * @copyright	Copyright (C) 1997 - 2009 Intechnic. All rights reserved.
 * @license	Commercial License
@@ -360,7 +360,7 @@
 					),
 
 					'TableName' => TABLE_PREFIX . 'Products',
-					
+
 					'CalculatedFields' => Array (
 						''	=>	Array (
 							'AltName'		=>	'img.AltName',
@@ -492,9 +492,9 @@
 					    'Expire'				=>	Array ('type' => 'int', 'formatter' => 'kDateFormatter', 'default' =>null),
 					    'Type'					=>	Array ('type' => 'int', 'not_null' => 1, 'formatter' => 'kOptionsFormatter', 'use_phrases' => 1, 'options' =>Array (1=> 'la_product_tangible',  2=> 'la_product_subscription', 4=> 'la_product_downloadable', 3=> 'la_product_service'/*, 6=> 'la_gift_certificate', 5=> 'la_product_package'*/), 'not_null' => 1, 'default' => 1 ),
 					    'Modified'				=>	Array ('type' => 'int', 'formatter' => 'kDateFormatter', 'default' => '#NOW#'),
-					    'ModifiedById'			=>	Array ('type' => 'int', 'not_null' => 1, 'default' => 0),
-					    'CreatedById'			=>	Array ('type' => 'int', 'not_null' => 1, 'default' => 0),
-					    'ResourceId'			=>	Array ('type' => 'int', 'default' => 0),
+					    'ModifiedById'			=>	Array ('type' => 'int', 'default' => NULL),
+					    'CreatedById'			=>	Array ('type' => 'int', 'default' => NULL),
+					    'ResourceId'			=>	Array ('type' => 'int', 'default' => null),
 					    'CachedReviewsQty'		=>	Array ('type' => 'int', 'formatter' => 'kFormatter', 'format' => '%d', 'not_null' => 1, 'default' => 0),
 					    'InventoryStatus' => Array ('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (0 => 'la_Disabled', 1 => 'la_by_product', 2 => 'la_by_options'), 'use_phrases' => 1, 'not_null' => 1, 'default' => 0),
 					    'QtyInStock'			=>	Array ('type' => 'int', 'not_null' => 1, 'default' => 0),
@@ -539,13 +539,15 @@
 					),
 
 					'VirtualFields'	=> 	Array (
-						'Qty'					=>	1,
+						'Qty'					=>	Array ('type' => 'int', 'formatter' => 'kFormatter', 'regexp' => '/^[\d]+$/', 'default' => 0),
 						'Price'					=>	Array ('type' => 'float', 'formatter' => 'kFormatter', 'format' => '%.2f', 'default' => NULL),
 						'Cost'					=>	Array ('type' => 'float', 'formatter' => 'kFormatter', 'format' => '%.2f', 'default' => NULL),
-						'IsHot'					=>	Array ('type' => 'int'),
-						'IsNew'					=>	Array ('type' => 'int'),
-						'IsPop'					=>	Array ('type' => 'int'),
-						'Manufacturer'			=>	Array (),
+						'CategoryFilename'		=>	Array ('type' => 'string', 'default' => ''),
+						'PrimaryCat'			=>	Array ('type' => 'int', 'default' => 0),
+						'IsHot'					=>	Array ('type' => 'int', 'default' => 0),
+						'IsNew'					=>	Array ('type' => 'int', 'default' => 0),
+						'IsPop'					=>	Array ('type' => 'int', 'default' => 0),
+						'Manufacturer'			=>	Array ('type' => 'string', 'default' => ''),
 
 						// export related fields: begin
 						'CategoryId'			=>	Array ('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (), 'default' => 0),
@@ -559,24 +561,24 @@
 					    	'type' => 'int',
 					    	'formatter' => 'kOptionsFormatter',
 					    	'options' => Array (0 => 'la_No', 1 => 'la_Yes'),
-					    	'use_phrases' => 1, 'not_null' => 1, 'default' => 1,
+					    	'use_phrases' => 1, 'default' => 1,
 						),
-						'ExportColumns'			=>	Array ('type' => 'string', 'formatter' => 'kOptionsFormatter', 'options' => Array ()),
-						'AvailableColumns'		=>	Array ('type' => 'string', 'formatter' => 'kOptionsFormatter', 'options' => Array ()),
+						'ExportColumns'			=>	Array ('type' => 'string', 'formatter' => 'kOptionsFormatter', 'options' => Array (), 'default' => ''),
+						'AvailableColumns'		=>	Array ('type' => 'string', 'formatter' => 'kOptionsFormatter', 'options' => Array (), 'default' => ''),
 						'CategoryFormat'		=>	Array ('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (1 => 'la_MixedCategoryPath', 2 => 'la_SeparatedCategoryPath'), 'use_phrases' => 1, 'default' => 1),
 						'CategorySeparator'		=>	Array ('type' => 'string', 'default' => ':'),
 						'IsBaseCategory'		=>	Array (
 					    	'type' => 'int',
 					    	'formatter' => 'kOptionsFormatter',
 					    	'options' => Array (0 => 'la_No', 1 => 'la_Yes'),
-					    	'use_phrases' => 1, 'not_null' => 1, 'default' => 0,
+					    	'use_phrases' => 1, 'default' => 0,
 						),
 						// export related fields: end
 
 						// import related fields: begin
 						'FieldTitles'			=>	Array ('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (1 => 'la_Automatic', 2 => 'la_Manual'), 'use_phrases' => 1, 'default' => 1),
 						'ImportSource'			=>	Array ('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (1 => 'la_Upload', 2 => 'la_Local'), 'use_phrases' => 1, 'default' => 2),
-						'ImportFilename'		=>	Array ('type' => 'string', 'formatter' => 'kUploadFormatter', 'max_size' => MAX_UPLOAD_SIZE, 'upload_dir' => EXPORT_BASE_PATH . '/'),
+						'ImportFilename'		=>	Array ('type' => 'string', 'formatter' => 'kUploadFormatter', 'max_size' => MAX_UPLOAD_SIZE, 'upload_dir' => EXPORT_BASE_PATH . '/', 'default' => ''),
 						'ImportLocalFilename'	=>	Array ('type' => 'string', 'formatter' => 'kOptionsFormatter', 'default' => ''),
 						'CheckDuplicatesMethod'	=>	Array ('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (1 => 'la_IDField', 2 => 'la_OtherFields'), 'use_phrases' => 1, 'default' => 1),
 						'ReplaceDuplicates'		=>	Array ('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (0 => 'la_No', 1 => 'la_Yes'), 'use_phrases' => 1, 'default' => 0),
@@ -588,13 +590,13 @@
 						'FullImage'				=>	Array ('type' => 'string', 'default' => ''),
 						'ImageAlt'				=>	Array ('type' => 'string', 'default' => ''),
 
-						'Filename' 				=>	Array ('type' => 'string', 'not_null' => '1', 'default' => ''),
+						'Filename' 				=>	Array ('type' => 'string', 'default' => ''),
 						'CachedNavbar'			=>	Array ('type' => 'string', 'default' => ''),
 						'ParentPath'			=>	Array ('type' => 'string', 'default' => ''),
 
-						'FileSize'				=>	Array ('type' => 'int', 'formatter' => 'kFilesizeFormatter', 'not_null' => 1, 'default' => 0),
-						'FilePath'				=>	Array (),
-						'FileVersion'			=>	Array (),
+						'FileSize'				=>	Array ('type' => 'int', 'formatter' => 'kFilesizeFormatter', 'default' => 0),
+						'FilePath'				=>	Array ('type' => 'string', 'default' => ''),
+						'FileVersion'			=>	Array ('type' => 'string', 'default' => ''),
 
 						// for primary image
 						'AltName'		=>	Array ('type' => 'string', 'default' => ''),