Video Table Structure:
CREATE TABLE IF NOT EXISTS `videos` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`video_title` varchar(255) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`video_description` varchar(255) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`video_keywords` varchar(255) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`video_thumbnail` varchar(255) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`video_file` varchar(255) COLLATE latin1_general_ci NOT NULL,
`video_url` text COLLATE latin1_general_ci NOT NULL,
`category_id` int(11) NOT NULL DEFAULT '0',
`final_rating` float NOT NULL DEFAULT '0',
`video_date` date NOT NULL DEFAULT '0000-00-00',
`video_status` int(11) NOT NULL DEFAULT '0',
`hit` int(11) NOT NULL,
`activate_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`mem_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT ;
*****************************************************
Articles Table.........
CREATE TABLE IF NOT EXISTS `article` (
`art_id` int(11) NOT NULL AUTO_INCREMENT,
`category_id` int(11) NOT NULL,
`art_title` varchar(255) NOT NULL,
`art_desc` text NOT NULL,
`art_thumbnail` varchar(100) NOT NULL,
`art_url` varchar(255) NOT NULL,
`final_rating` float NOT NULL,
`art_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`art_status` int(4) NOT NULL,
`hit` int(11) NOT NULL,
`mem_id` int(11) NOT NULL,
PRIMARY KEY (`art_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT ;
******************************************************
Picture Gallery Table---
CREATE TABLE IF NOT EXISTS `picture_gallery` (
`g_id` int(11) NOT NULL AUTO_INCREMENT,
`category_id` int(11) NOT NULL,
`gallery_title` varchar(255) NOT NULL,
`gallery_desc` varchar(255) NOT NULL,
`gallery_thumbnail` varchar(100) NOT NULL,
`picture_url` varchar(255) NOT NULL,
`final_rating` float NOT NULL,
`gallery_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`gallery_status` int(4) NOT NULL,
`hit` int(11) NOT NULL,
`activate_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`mem_id` int(11) NOT NULL,
PRIMARY KEY (`g_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMEN;
***********************************************************
Games Table Structure---------
CREATE TABLE IF NOT EXISTS `games` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`game_title` varchar(255) NOT NULL,
`game_desc` text NOT NULL,
`game_keywords` varchar(255) NOT NULL,
`game_thumbs` varchar(100) NOT NULL,
`game_file` varchar(255) NOT NULL,
`game_url` varchar(255) NOT NULL,
`category_id` int(11) NOT NULL,
`final_rating` float NOT NULL,
`game_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`game_status` int(4) NOT NULL,
`hit` varchar(40) NOT NULL,
`activated_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`mem_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT;
These are the All Table Structures in which have to get join and retrieve all data