[TYPO3-commerce] FYI96: #28312 - Increase length of title & subtitle fields in commerce base entities

[Ingo Schmitt]

+1 by reading. Go Ahead!

Ingo

> Hi!
> 
> 
> This is an SVN patch request.
> 
> 
> Type:
> (tiny) feature
> 
> 
> References:
> http://forge.typo3.org/issues/28312
> 
> 
> Problem:
> For a client I need to increase the title/subtitle length of some
> commerce base tables. Especially in a multilanguage setup 80 chars seem
> to be pretty low.
> 
> 
> Solution:
> This patch is about increasing the maximum input length for
> title/subtitle to varchar 255 for tables
> 
>    * articles
>    * order_articles
>    * categories
>    * products
> 
> 
> Notes:
> This issue has been created after having consulted Volker Graubaum in
> the first place.
> 
> 
> Regards,
> Marcus.
> Index: ext_tables.sql
> ===================================================================
> --- ext_tables.sql	(Revision 49921)
> +++ ext_tables.sql	(Arbeitskopie)
> @@ -87,8 +87,8 @@
> 	starttime int(11) DEFAULT '0' NOT NULL,
> 	endtime int(11) DEFAULT '0' NOT NULL,
> 	fe_group varchar(100) DEFAULT '0' NOT NULL,
> -	title varchar(80) DEFAULT '' NOT NULL,
> -	subtitle varchar(80) DEFAULT '' NOT NULL,
> +	title varchar(255) DEFAULT '' NOT NULL,
> +	subtitle varchar(255) DEFAULT '' NOT NULL,
> 	navtitle varchar(80) DEFAULT '' NOT NULL,
> 	images blob NOT NULL,
> 	ordernumber varchar(80) DEFAULT '' NOT NULL,
> @@ -315,7 +315,7 @@
> 	endtime int(11) DEFAULT '0' NOT NULL,
> 	fe_group varchar(100) DEFAULT '0' NOT NULL,
> 	extendToSubpages tinyint(3) DEFAULT '0' NOT NULL,
> -	title varchar(80) DEFAULT '' NOT NULL,
> +	title varchar(255) DEFAULT '' NOT NULL,
> 	subtitle varchar(255) DEFAULT '' NOT NULL,
> 	description text NOT NULL,
> 	images blob NOT NULL,
> @@ -490,8 +490,8 @@
> 	article_type_uid int(11) NOT NULL DEFAULT '0',
> 	article_uid int(11) NOT NULL DEFAULT '0',
> 	article_number varchar(80) DEFAULT '' NOT NULL,
> -	title varchar(80) DEFAULT '' NOT NULL,
> -	subtitle varchar(80) DEFAULT '' NOT NULL,
> +	title varchar(255) DEFAULT '' NOT NULL,
> +	subtitle varchar(255) DEFAULT '' NOT NULL,
> 	price_net int(10) DEFAULT '0' NOT NULL,
> 	price_gross int(10) DEFAULT '0' NOT NULL,
> 	tax double(4,2) DEFAULT '0.00' NOT NULL,
> @@ -550,8 +550,8 @@
> 	starttime int(11) DEFAULT '0' NOT NULL,
> 	endtime int(11) DEFAULT '0' NOT NULL,
> 	fe_group varchar(100) DEFAULT '0' NOT NULL,
> -	title varchar(80) DEFAULT '' NOT NULL,
> -	subtitle varchar(80) DEFAULT '' NOT NULL,
> +	title varchar(255) DEFAULT '' NOT NULL,
> +	subtitle varchar(255) DEFAULT '' NOT NULL,
> 	navtitle varchar(80) DEFAULT '' NOT NULL,
> 	keywords text NOT NULL,
> 	description text NOT NULL,
> Index: tcafiles/tx_commerce_order_articles.tca.php
> ===================================================================
> --- tcafiles/tx_commerce_order_articles.tca.php	(Revision 49921)
> +++ tcafiles/tx_commerce_order_articles.tca.php	(Arbeitskopie)
> @@ -84,7 +84,7 @@
> 			'config' => Array (
> 				'type' => 'input',
> 				'size' => '40',
> -				'max' => '80',
> +				'max' => '255',
> 				'eval' => 'required,trim',
> 			)
> 		),
> @@ -94,7 +94,7 @@
> 			'config' => Array (
> 				'type' => 'input',
> 				'size' => '40',
> -				'max' => '80',
> +				'max' => '255',
> 				'eval' => 'trim',
> 			)
> 		),
> Index: tcafiles/tx_commerce_products.tca.php
> ===================================================================
> --- tcafiles/tx_commerce_products.tca.php	(Revision 49921)
> +++ tcafiles/tx_commerce_products.tca.php	(Arbeitskopie)
> @@ -131,7 +131,7 @@
> 			'config' => Array (
> 				'type' => 'input',
> 				'size' => '40',
> -				'max' => '80',
> +				'max' => '255',
> 				'eval' => 'required,trim',
> 			)
> 		),
> @@ -141,7 +141,7 @@
> 			'config' => Array (
> 				'type' => 'input',
> 				'size' => '40',
> -				'max' => '80',
> +				'max' => '255',
> 				'eval' => 'trim',
> 			)
> 		),
> Index: tcafiles/tx_commerce_articles.tca.php
> ===================================================================
> --- tcafiles/tx_commerce_articles.tca.php	(Revision 49921)
> +++ tcafiles/tx_commerce_articles.tca.php	(Arbeitskopie)
> @@ -201,7 +201,7 @@
> 			'config' => Array (
> 				'type' => 'input',
> 				'size' => '40',
> -				'max' => '80',
> +				'max' => '255',
> 				'eval' => 'required,trim',
> 			)
> 		),
> @@ -211,7 +211,7 @@
> 			'config' => Array (
> 				'type' => 'input',
> 				'size' => '40',
> -				'max' => '80',
> +				'max' => '255',
> 				'eval' => 'trim',
> 			)
> 		),
> Index: tcafiles/tx_commerce_categories.tca.php
> ===================================================================
> --- tcafiles/tx_commerce_categories.tca.php	(Revision 49921)
> +++ tcafiles/tx_commerce_categories.tca.php	(Arbeitskopie)
> @@ -142,7 +142,7 @@
> 			'config' => Array (
> 				'type' => 'input',
> 				'size' => '40',
> -				'max' => '80',
> +				'max' => '255',
> 				'eval' => 'required,trim',
> 			)
> 		),
> @@ -152,7 +152,7 @@
> 			'config' => Array (
> 				'type' => 'input',
> 				'size' => '40',
> -				'max' => '80',
> +				'max' => '255',
> 				'eval' => 'trim',
> 			)
> 		),
> _______________________________________________
> TYPO3-team-commerce mailing list
> TYPO3-team-commerce at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-team-commerce


Mit freundlichen Gruessen
Ingo Schmitt

-- 
Marketing Factory Consulting GmbH  *   mailto:is at marketing-factory.de
Marienstrasse 14                   *          Tel.: +49 211-361176-63
D-40212 Duesseldorf, Germany       *          Fax:  +49 211-361176-64
Amtsgericht Duesseldorf HRB 53971  * http://www.marketing-factory.de/

Geschaeftsfuehrer:    Peter Faisst   |   Katja Faisst
Karoline Steinfatt   |   Christoph Allefeld   |   Markus M. Kimmel