04-05-2014, 05:57 PM
CREATE TABLE IF NOT EXISTS `movies` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`description` text,
`year` varchar(255) DEFAULT NULL,
`length` varchar(255) DEFAULT NULL,
`views` bigint(10) DEFAULT '0',
`ratingp` bigint(10) DEFAULT '0',
`votes` bigint(10) DEFAULT '0',
`status` int(1) DEFAULT '1',
`keywords` text,
`stamp` bigint(10) DEFAULT '0',
`uid` bigint(10) DEFAULT '0',
`cat` bigint(10) DEFAULT '0',
`ratingm` bigint(10) DEFAULT '0',
`featured` int(1) DEFAULT '0',
`startwith` varchar(1) DEFAULT NULL,
`imdb` varchar(255) DEFAULT NULL,
`released` int(1) DEFAULT '1',
`releasingon` bigint(10) DEFAULT NULL,
`genre_str` text,
`slug` varchar(255) DEFAULT NULL,
`meta_title` varchar(255) DEFAULT NULL,
`meta_description` varchar(255) DEFAULT NULL,
`extra` text,
`release_date` bigint(10) DEFAULT NULL,
PRIMARY KEY (`id`),
FULLTEXT KEY `NewIndex3` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11617 ;
CREATE TABLE IF NOT EXISTS `movie_genre` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`movie` bigint(10) DEFAULT NULL,
`genre` bigint(10) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `NewIndex1` (`movie`,`genre`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=55061 ;
CREATE TABLE IF NOT EXISTS `movie_group` (
`mgid` bigint(10) NOT NULL AUTO_INCREMENT,
`movie` bigint(10) DEFAULT NULL,
`group` bigint(10) DEFAULT NULL,
`stamp` bigint(10) DEFAULT NULL,
`status` int(1) DEFAULT '1',
`uid` bigint(10) DEFAULT '0',
`votesp` bigint(10) DEFAULT '0',
`votesm` bigint(10) DEFAULT '0',
`ip` varchar(12) DEFAULT NULL,
PRIMARY KEY (`mgid`),
KEY `NewIndex1` (`movie`,`group`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=112626 ;
CREATE TABLE IF NOT EXISTS `movie_group_links` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`mgid` bigint(10) DEFAULT NULL,
`link` text,
`type` int(1) DEFAULT '1',
`status` int(10) DEFAULT '1',
`votesp` bigint(10) DEFAULT '0',
`stamp` bigint(10) DEFAULT NULL,
`uid` bigint(10) DEFAULT NULL,
`ip` varchar(12) DEFAULT NULL,
`votesm` bigint(10) DEFAULT '0',
`downloads` bigint(10) DEFAULT '0',
`views` bigint(10) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `NewIndex1` (`mgid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=183112 ;
CREATE TABLE IF NOT EXISTS `movie_hits` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`uid` bigint(10) DEFAULT NULL,
`mid` bigint(10) DEFAULT NULL,
`ip` varchar(20) DEFAULT NULL,
`stamp` bigint(10) DEFAULT NULL,
`hits` bigint(10) DEFAULT NULL,
`refrer` varchar(255) DEFAULT NULL,
`host` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
CREATE TABLE IF NOT EXISTS `movie_ratings` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`mid` bigint(10) DEFAULT NULL,
`uid` bigint(10) DEFAULT NULL,
`stamp` bigint(10) DEFAULT NULL,
`ip` varchar(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `NewIndex1` (`mid`,`uid`),
KEY `NewIndex2` (`mid`,`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `movie_sources` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`mid` bigint(10) DEFAULT NULL,
`link` varchar(255) DEFAULT NULL,
`plug` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `movie_tags` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`tid` bigint(10) DEFAULT NULL,
`mid` bigint(10) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `NewIndex1` (`tid`,`mid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`description` text,
`year` varchar(255) DEFAULT NULL,
`length` varchar(255) DEFAULT NULL,
`views` bigint(10) DEFAULT '0',
`ratingp` bigint(10) DEFAULT '0',
`votes` bigint(10) DEFAULT '0',
`status` int(1) DEFAULT '1',
`keywords` text,
`stamp` bigint(10) DEFAULT '0',
`uid` bigint(10) DEFAULT '0',
`cat` bigint(10) DEFAULT '0',
`ratingm` bigint(10) DEFAULT '0',
`featured` int(1) DEFAULT '0',
`startwith` varchar(1) DEFAULT NULL,
`imdb` varchar(255) DEFAULT NULL,
`released` int(1) DEFAULT '1',
`releasingon` bigint(10) DEFAULT NULL,
`genre_str` text,
`slug` varchar(255) DEFAULT NULL,
`meta_title` varchar(255) DEFAULT NULL,
`meta_description` varchar(255) DEFAULT NULL,
`extra` text,
`release_date` bigint(10) DEFAULT NULL,
PRIMARY KEY (`id`),
FULLTEXT KEY `NewIndex3` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11617 ;
CREATE TABLE IF NOT EXISTS `movie_genre` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`movie` bigint(10) DEFAULT NULL,
`genre` bigint(10) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `NewIndex1` (`movie`,`genre`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=55061 ;
CREATE TABLE IF NOT EXISTS `movie_group` (
`mgid` bigint(10) NOT NULL AUTO_INCREMENT,
`movie` bigint(10) DEFAULT NULL,
`group` bigint(10) DEFAULT NULL,
`stamp` bigint(10) DEFAULT NULL,
`status` int(1) DEFAULT '1',
`uid` bigint(10) DEFAULT '0',
`votesp` bigint(10) DEFAULT '0',
`votesm` bigint(10) DEFAULT '0',
`ip` varchar(12) DEFAULT NULL,
PRIMARY KEY (`mgid`),
KEY `NewIndex1` (`movie`,`group`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=112626 ;
CREATE TABLE IF NOT EXISTS `movie_group_links` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`mgid` bigint(10) DEFAULT NULL,
`link` text,
`type` int(1) DEFAULT '1',
`status` int(10) DEFAULT '1',
`votesp` bigint(10) DEFAULT '0',
`stamp` bigint(10) DEFAULT NULL,
`uid` bigint(10) DEFAULT NULL,
`ip` varchar(12) DEFAULT NULL,
`votesm` bigint(10) DEFAULT '0',
`downloads` bigint(10) DEFAULT '0',
`views` bigint(10) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `NewIndex1` (`mgid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=183112 ;
CREATE TABLE IF NOT EXISTS `movie_hits` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`uid` bigint(10) DEFAULT NULL,
`mid` bigint(10) DEFAULT NULL,
`ip` varchar(20) DEFAULT NULL,
`stamp` bigint(10) DEFAULT NULL,
`hits` bigint(10) DEFAULT NULL,
`refrer` varchar(255) DEFAULT NULL,
`host` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
CREATE TABLE IF NOT EXISTS `movie_ratings` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`mid` bigint(10) DEFAULT NULL,
`uid` bigint(10) DEFAULT NULL,
`stamp` bigint(10) DEFAULT NULL,
`ip` varchar(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `NewIndex1` (`mid`,`uid`),
KEY `NewIndex2` (`mid`,`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `movie_sources` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`mid` bigint(10) DEFAULT NULL,
`link` varchar(255) DEFAULT NULL,
`plug` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `movie_tags` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`tid` bigint(10) DEFAULT NULL,
`mid` bigint(10) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `NewIndex1` (`tid`,`mid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;