cck uses wrong $var to create table.

On a site, I had all the CCK modules enabled, BUT content_copy.module. I had already created a few content types. I went back to enable that last module, but upon submit, I had plenty of errors like this one:

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group ( vid int unsigned NOT NULL default '0', query: CREATE TABLE content_type_organic group ( vid int unsigned NOT NULL default '0', nid int unsigned NOT NULL default '0', PRIMARY KEY (vid) ) /*!40100 DEFAULT CHARACTER SET utf8 */ in includes/database.mysql.inc on line 172.

Note in the query: CREATE TABLE content_type_organic group: It uses "organic group" instead of "organic_group", i.e. the script uses the node type's human name, instead of its machine name.

I tested on a fresh install of a site. On a fresh install, only 'story' and 'page' exist. I enabled all the cck modules and got a similar problem:

The content fields table node_Page has been created.
The content fields table node_Story has been created.

Note the capitalization: node_Story instead of node_story. The difference is that, because there is only one word, there aren't any space and the query was successfully executed.