Pop Quiz! Which module created my 'av_playlist' table?
seaneffel - August 19, 2009 - 00:41
Sheesh, I can't figure it out. I've got this lingering database table that contains no rows called "av_playlist" and I have no idea what cracked out module might have generated it. It might be legacy from the Video or Audio modules, or might be from Emfield, but I can't find any trace of it in the foo.install files of any module I currently have.
If you can correctly guess which module made it, I'll give you serious recognition on my blog. If that means anything to you.
Thanks for the help!
Try the media.module
Try the media.module http://drupal.org/project/media. It appears to access that table a few times in it's module file.
.
I haven't used the media.module yet on this instance of Drupal. I have used a near relative, the media_mover.module. What do you think?
Am I right when I assume -most- modules keep their install SQL schema in the .install file? Where else do the cool kids write their starter data?
Media module has a file named
Media module has a file named media.module.mysql.sql where the av_playlist table is created.
#
# Table structure for table `av_playlist`
#
CREATE TABLE `av_playlist` (
`nid` int(10) NOT NULL default '0',
`fid` int(10) NOT NULL default '0',
`next_fid` int(10) NOT NULL default '0',
KEY `nid` (`nid`)
) TYPE=MyISAM;
However, according to the revision information it has been removed as of version 1.2:
Revision 1.2
Fri Jan 9 22:21:28 2009 UTC (7 months, 1 week ago) by arthuregg
Branch: MAIN
CVS Tags: HEAD
Changes since 1.1: +0 -0 lines
FILE REMOVED
removing old files to reclaim the name space
If your mystery table has the same structure as shown above then it most likely was created with an older version of media module.
Media module has a file named
Media module has a file named media.module.mysql.sql where the av_playlist table is created.
#
# Table structure for table `av_playlist`
#
CREATE TABLE `av_playlist` (
`nid` int(10) NOT NULL default '0',
`fid` int(10) NOT NULL default '0',
`next_fid` int(10) NOT NULL default '0',
KEY `nid` (`nid`)
) TYPE=MyISAM;
However, according to the revision information it has been removed as of version 1.2:
Revision 1.2
Fri Jan 9 22:21:28 2009 UTC (7 months, 1 week ago) by arthuregg
Branch: MAIN
CVS Tags: HEAD
Changes since 1.1: +0 -0 lines
FILE REMOVED
removing old files to reclaim the name space
If your mystery table has the same structure as shown above then it most likely was created with an older version of media module.