<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16608" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>OK, I found the answer in the second half of this
article on the db aspects of CCK:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2><A
href="http://www.lullabot.com/articles/an_introduction_to_the_content_construction_kit">http://www.lullabot.com/articles/an_introduction_to_the_content_construction_kit</A></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>the two fields (which were actually hobbies and
favourite music genres now I recall...) both accepted multiple values so it
seems that is the crucial factor in deciding whether a CCK field gets added to
the db as a separate table or part of a content type table: that - and whether
the field is shared between content types.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Neil</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=neil@esl-lounge.com href="mailto:neil@esl-lounge.com">Neil:
esl-lounge.com</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=support@drupal.org
href="mailto:support@drupal.org">support@drupal.org</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, March 21, 2008 10:16
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [support] CCK fields being
created as separate tables in the db</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>
<P>I've been pulling my hair out about this for two hours. I have made a
nodeprofile content type and am using cck fields to build it.</P>
<P>All the fields I created were added as columns to the
content_type_nodeprofile table....except the last two which were added to my
db as separate tables:</P>
<P>content_field_hobbies<BR>content_field_age</P>
<P>these were the last two I added and, also, I had a few problems with the
"group" they sat in, so I ended up changing the name and deleting and
recreating the groups at least once...may this have caused the issue? </P>
<P>I've tried totally deleting the relevant fields and groups and starting
again, but they keep getting created as separate tables. Aagh!!</P>
<P>Basically, what is it that makes CCK create a field as a separate table
instead of putting it as a column inside the content type table?</P>
<P>Neil</P></FONT></DIV>
<P>
<HR>
<P></P>-- <BR>[ Drupal support list | http://lists.drupal.org/
]</BLOCKQUOTE></BODY></HTML>