CCK only creates content_field_xxxx when that field is shared between two or more content types. Otherwise, it just adds a column to content_type_yyyy.
-----Original Message----- From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Scott Sent: Friday, November 20, 2009 1:07 PM To: support@drupal.org Subject: Re: [support] New CCK field not found in mysql
I found where the data went by exporting the sites database. Rather than create a new table named content_field_street_name, as I would have expected, it created content_type_[content_type_name]. This table has fields: vid, nid and field_street_name_value. I'm about out of time today but I wonder what would've happened had I added two new fields to this CCK type.
On Fri, 2009-11-20 at 12:07 -0800, Scott wrote:
I've created a new field for a CCK type and it works fine in my drupal site. My problem is that it does not show up in mysql command line interface or with phpmyadmin. This is confusing to me. I can modify, add and delete data using the edit node function when viewing a page, so I know the data is somewhere, however, I wish to do a batch load of this field with mysql.