CREATE TABEL exp_channel_fields

CREATE TABLE `exp_channel_fields` ( `field_id` int(6) unsigned NOT NULL AUTO_INCREMENT, `site_id` int(4) unsigned NOT NULL DEFAULT '1', `group_id` int(4) unsigned NOT NULL, `field_name` varchar(32) NOT NULL, `field_label` varchar(50) NOT NULL, `field_instructions` text, `field_type` varchar(50) NOT NULL DEFAULT 'text', `field_list_items` text NOT NULL, `field_pre_populate` char(1) NOT NULL DEFAULT 'n', `field_pre_channel_id` int(6) unsigned DEFAULT NULL, `field_pre_field_id` int(6) unsigned DEFAULT NULL, `field_related_to` varchar(12) NOT NULL DEFAULT 'channel', `field_related_id` int(6) unsigned NOT NULL DEFAULT '0', `field_related_orderby` varchar(12) NOT NULL DEFAULT 'date', `field_related_sort` varchar(4) NOT NULL DEFAULT 'desc', `field_related_max` smallint(4) NOT NULL DEFAULT '0', `field_ta_rows` tinyint(2) DEFAULT '8', `field_maxl` smallint(3) DEFAULT NULL, `field_required` char(1) NOT NULL DEFAULT 'n', `field_text_direction` char(3) NOT NULL DEFAULT 'ltr', `field_search` char(1) NOT NULL DEFAULT 'n', `field_is_hidden` char(1) NOT NULL DEFAULT 'n', `field_fmt` varchar(40) NOT NULL DEFAULT 'xhtml', `field_show_fmt` char(1) NOT NULL DEFAULT 'y', `field_order` int(3) unsigned NOT NULL, `field_content_type` varchar(20) NOT NULL DEFAULT 'any', `field_settings` text, PRIMARY KEY (`field_id`), KEY `group_id` (`group_id`), KEY `field_type` (`field_type`), KEY `site_id` (`site_id`) ) ENGINE=MyISAM AUTO_INCREMENT=247 DEFAULT CHARSET=utf8