CREATE TABLE IF NOT EXISTS `board_favourites` (
`fid` int(11) NOT NULL auto_increment,
`f_user_id` int(11) default '0',
`f_adid` int(11) default '0',
PRIMARY KEY (`fid`),
KEY `f_user_id` (`f_user_id`),
KEY `f_adid` (`f_adid`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=100 ;
CREATE TABLE IF NOT EXISTS `board_picture` (
`id` int(4) NOT NULL auto_increment,
`pic_ad_id` int(11) default '0',
`filename` varchar(50) default '0',
`main` int(11) default '0',
PRIMARY KEY (`id`),
KEY `pic_ad_id` (`pic_ad_id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=12370 ;
CREATE TABLE IF NOT EXISTS `board_upload_files` (
`f_id` int(11) NOT NULL auto_increment,
`f_file` varchar(155) default '0',
`f_adid` int(11) default '0',
PRIMARY KEY (`f_id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=28 ;
CREATE TABLE IF NOT EXISTS `board_video` (
`video_id` int(11) NOT NULL auto_increment,
`video_file` varchar(155) default '0',
`video_adid` int(11) default '0',
PRIMARY KEY (`video_id`),
KEY `video_adid` (`video_adid`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;