[drupal-devel] [task] Lengthen type field in node table

[killes]

Issue status update for 
http://drupal.org/node/27985
Post a follow up: 
http://drupal.org/project/comments/add/27985

 Project:      Drupal
 Version:      cvs
 Component:    node system
 Category:     tasks
 Priority:     normal
 Assigned to:  jvandyk
 Reported by:  jvandyk
 Updated by:   killes at www.drop.org
 Status:       patch (ready to be committed)

Ber: I'd really like to have some proof or even evidence for this
claim...


I don't think it is a problem.




killes at www.drop.org



Previous comments:
------------------------------------------------------------------------

Mon, 01 Aug 2005 21:14:43 +0000 : jvandyk

Attachment: http://drupal.org/files/issues/type32chars.diff (2.48 KB)

The type column of the node table is VARCHAR(16).


CCK prepends 'content-' onto its content types, leaving only 8 chars
for a descriptive "short name" of the content type. For example,
"content-shoe-size" already exceeds the limit.


This patch changes the column width to 32 characters.




------------------------------------------------------------------------

Mon, 01 Aug 2005 21:31:08 +0000 : chx

I read the code and looks fine with me. jvandyk says the pgsql way is
necessary unless we want to support only 8.0




------------------------------------------------------------------------

Tue, 02 Aug 2005 11:26:04 +0000 : Bèr Kessels

I am no SQL guru, but AFAIK this will greatly affect the memory usage of
mysql. At least that is why i refraind from this solution and renamed
node_aggregator to naggregator when that module bumbed into this 8 char
limit.