this is no longer self installing
i will try to make this not the case for new installs only
paste this code in to myphpadmins sql window (new installs only!!!!!)
--
-- Table structure for table `mkp_video`
--
--
-- Table structure for table `mkp_video`
--
CREATE TABLE `mkp_video` (
`vid` int(11) NOT NULL auto_increment,
`name` varchar(32) NOT NULL default '',
`description` text NOT NULL,
`urllocation` varchar(255) NOT NULL default '',
`type` varchar(12) NOT NULL default '',
`file` varchar(45) NOT NULL default '',
`width` smallint(3) NOT NULL default '0',
`height` smallint(3) NOT NULL default '0',
`plays` int(11) default '0',
`rating` varchar(10) NOT NULL default '',
`trating` varchar(10) NOT NULL default '',
`linkonoff` varchar(12) NOT NULL default '',
`cat` varchar(20) NOT NULL default '',
PRIMARY KEY (`vid`)
) TYPE=MyISAM;
--
-- Table structure for table `mkp_video_comm`
--
CREATE TABLE `mkp_video_comm` (
`commid` int(11) NOT NULL auto_increment,
`vid` varchar(12) NOT NULL default '',
`memid` varchar(6) NOT NULL default '',
`memname` varchar(56) NOT NULL default '',
`comment` blob NOT NULL,
PRIMARY KEY (`commid`)
) TYPE=MyISAM;
--
-- Table structure for table `mkp_video_drp`
--
CREATE TABLE `mkp_video_drp` (
`vdrpid` int(11) NOT NULL auto_increment,
`value` varchar(20) NOT NULL default '',
PRIMARY KEY (`vdrpid`)
) TYPE=MyISAM COMMENT='mkvideo drop box' AUTO_INCREMENT=9 ;
--
-- Dumping data for table `mkp_video_drp`
--
INSERT INTO `mkp_video_drp` VALUES ('', 'Video');
INSERT INTO `mkp_video_drp` VALUES ('', 'Radio Stream');
INSERT INTO `mkp_video_drp` VALUES ('', 'Humour');
INSERT INTO `mkp_video_drp` VALUES ('', 'Flash');
INSERT INTO `mkp_video_drp` VALUES ('', 'Audio File');
