Windows/MySQL 5 and the ffmpeg_data table

I had a couple problems with the ffmpeg_data table while trying to get the FlashVideo module working. The first problem was that the install script wasn't able to create the table. This is mostly because my combination of Windows and MySQL doesn't allow a text column to have a default value when it can't contain a null value.

My second problem was that ffmpeg wouldn't run after uploading the video. This was because the entry in the ffmpeg_data table wasn't being created since a null value was being passed to the data column. After allowing null values in the data column ffmpeg was able to run and the module was fully functional.

Here is the query that will create a working table with this software setup. As a side note, the MySQL version I use is 5.0.27.

CREATE TABLE {ffmpeg_data} (
		did int(10) unsigned NOT NULL AUTO_INCREMENT,
        fid int(10) unsigned NOT NULL default '0',
        created timestamp NOT NULL,
        input_file text NOT NULL,
        output_file text NOT NULL,
        status tinyint(1) unsigned NOT NULL default '0',
        data text,
        PRIMARY KEY  (did)
      ) ENGINE=MyISAM COMMENT='size is in bytes' /*!40100 DEFAULT CHARACTER SET utf8 */;