g2cyBCfK

1mysqldump -d -uroot -p <dbname> field_data_body > ./foo.sql 
2     
3DROP TABLE IF EXISTS `field_data_body`;
4CREATE TABLE `field_data_body` (
5  `entity_type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The entity type this data is attached to',
6  `bundle` varchar(128) NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
7  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
8  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
9  `revision_id` int(10) unsigned DEFAULT NULL COMMENT 'The entity revision id this data is attached to, or NULL if the entity type is not versioned',
10  `language` varchar(32) NOT NULL DEFAULT '' COMMENT 'The language for this data item.',
11  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
12  `body_value` longtext DEFAULT NULL,
13  `body_summary` longtext DEFAULT NULL,
14  `body_format` varchar(255) DEFAULT NULL,
15  PRIMARY KEY (`entity_type`,`entity_id`,`deleted`,`delta`,`language`),
16  KEY `entity_type` (`entity_type`),
17  KEY `bundle` (`bundle`),
18  KEY `deleted` (`deleted`),
19  KEY `entity_id` (`entity_id`),
20  KEY `revision_id` (`revision_id`),
21  KEY `language` (`language`),
22  KEY `body_format` (`body_format`)
23) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Data storage for field 7 (body)'; 
24     
25`field_files_fid` INT(10) unsigned NOT NULL,
26`field_files_display` TINYINT(3) unsigned NOT NULL DEFAULT 1,
27`field_files_description` text DEFAULT NULL 
28     
29KEY `field_files_fid` (`field_files_fid`)