Drupal: Create/Recreate the media_filter_usage Table

1/8/2015 12:37:36 AM

SQL

Drupal

After a recent Drupal update, I received an error related to a missing table: media_filter_usage. This caused a lot of unnecessary pain and frustration. Fortunately, I was able to find a script to recreate this table. Hope it helps someone else.

CREATE TABLE `media_filter_usage` (
  `fid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The media file_managed.fid.',
  `timestamp` int(11) NOT NULL DEFAULT '0' COMMENT 'The timestamp the fid was last recorded by media_filter()',
  PRIMARY KEY (`fid`),
  KEY `timestamp` (`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores fids that have been included in the media tag in...';