title: Convert SQL CREATE TABLE query to Drupal Content Type
body: <p>I know there is the <a href="http://drupal.org/project/cck" rel="nofollow">Content Construction Kit</a> for Drupal, which provides a useful UI for adding new Content Types in Drupal. However, I find it hideously slow and painful to create large new content types.</p>
  
  <p><strong>reason</strong></p>
  
  <p>I want to create a Content Type so I can convert all data to being a node, and therefore expose it to Views and be able to have a good UI for updating nodes.</p>
  
  <p><strong>possible?</strong></p>
  
  <ol>
  <li>Is there any module that will "convert" an sql query into it's <code>hook_form()</code> equiv?</li>
  <li>Will hook_form() expose it to Views?</li>
  <li>Any others ideas?</li>
  </ol>
  
  <p>Cheers</p>
  
  <p>Gary</p>
  
  <hr>
  
  <p><strong>just one example of 100s of table sql query to be converted</strong>
  <em>imagine the the pain; the sleepless nights, the tripping over the bundles of hair on the floor of creating each field in CCK</em></p>
  
  <pre><code>CREATE TABLE `files` (
    `file_id` int(11) NOT NULL auto_increment,
    `user_id` int(10) NOT NULL default '0',
    `file_author` varchar(255) NOT NULL default '',
    `file_email` varchar(255) NOT NULL default '',
    `file_type` varchar(100) NOT NULL default '',
    `file_name` text NOT NULL,
    `file_file` varchar(255) NOT NULL default '',
    `file_url` varchar(255) NOT NULL default '',
    `file_desc` text NOT NULL,
    `downloads` int(11) NOT NULL default '0',
    `file_date` int(11) NOT NULL default '0',
    `file_review` text NOT NULL,
    `screenshot` text NOT NULL,
    `updated` int(12) NOT NULL default '0',
    `update_notes` text NOT NULL,
    `author_desc` text NOT NULL,
    `sub_author` varchar(50) NOT NULL default '',
    `version` varchar(10) NOT NULL default '',
    `mirc_version` varchar(10) NOT NULL default '',
    `reviewer` varchar(50) NOT NULL default '',
    `posted` int(1) NOT NULL default '1',
    PRIMARY KEY  (`file_id`),
    KEY `user_id` (`user_id`),
    KEY `file_author` (`file_author`),
    KEY `file_type` (`file_type`),
    KEY `downloads` (`downloads`),
    KEY `file_date` (`file_date`),
    KEY `updated` (`updated`)
  ) ENGINE=MyISAM AUTO_INCREMENT=4544 DEFAULT
  </code></pre>