This is one way to solve problems with exporting file types, is to ensure that all the information for a file type is contained in our one table. I'm wondering why exactly we'd need three separate tables to store file types, when it might be complicating things.

Related:
#1845516: Custom file types exported through Features are missing mimetype information.
#1979832: Remove schemes from file types

Files: 
CommentFileSizeAuthor
#8 merge-mimetype-information-into-file-type-1977708-5.patch5.51 KBpradeepvenugopal
FAILED: [[SimpleTest]]: [MySQL] Unable to apply patch merge-mimetype-information-into-file-type-1977708-5.patch. Unable to apply patch. See the log in the details link for more information.
[ View ]
#4 merge-mimetype-information-into-file-type-1977708-4.patch5.47 KBDevin Carlson
PASSED: [[SimpleTest]]: [MySQL] 829 pass(es).
[ View ]
#4 exportable_mimetypes.png63.6 KBDevin Carlson

Comments

This would also fix that file_entity_uninstall() needs to use API functions to load the file types.

Note that #1979832: Remove schemes from file types would remove the file_type_streams table.

Title:Merge the file_type_mimetypes and file_type_streams into serialized fields on the file_type tableMerge file_type_mimetypes into a serialized field on the file_type table

Reducing scope now that #1979832: Remove schemes from file types is committed.

Assigned:Dave Reid» Devin Carlson
Status:Active» Needs review
StatusFileSize
new63.6 KB
new5.47 KB
PASSED: [[SimpleTest]]: [MySQL] 829 pass(es).
[ View ]

A patch to store mimetypes in the {file_type} table as a serialized blob.

It includes an update function to migrate existing MIME types from {file_type_mimetypes} into {file_type}.

A screenshot showing that MIME type information is now exportable with Features!

exportable_mimetypes.png

Status:Needs review» Fixed

Tested #4 with a number of existing sites and didn't run into any upgrade path problems (only default file types, additional custom file types, file types with default/additional/no MIME types).

Committed to 7.x-2.x.

Status:Fixed» Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

Status:Closed (fixed)» Fixed
StatusFileSize
new5.51 KB
FAILED: [[SimpleTest]]: [MySQL] Unable to apply patch merge-mimetype-information-into-file-type-1977708-5.patch. Unable to apply patch. See the log in the details link for more information.
[ View ]

With the above patch, it overwrites the default mimetypes.
It should migrate only the customised mimetypes.

Here is the patch for this.

Status:Fixed» Needs review

Status:Needs review» Needs work

@pradeepvenugopal: That patch doesn't look correct. Can you make sure it's rolled against the very latest 7.x-2.x branch in Git?

Status:Needs work» Closed (duplicate)

The fix is already available in the latest branch.

Issue summary:View changes

Adding http://drupal.org/node/1979832 to related issues