Структуры таблиц примерно такие:
Спойлер (Отобразить)
CODE (SQL):
скопировать код в буфер обмена
скопировать код в буфер обмена
- CREATE TABLE `movies` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `movie_name` varchar(255) NOT NULL DEFAULT '',
- `movie_name_intl` varchar(255) NOT NULL DEFAULT '',
- `movie_name_alias` varchar(255) NOT NULL DEFAULT '',
- `countries` text NOT NULL,
- `genres` text NOT NULL,
- `budget` varchar(32) NOT NULL,
- `year` varchar(32) NOT NULL,
- `time` int(6) NOT NULL,
- `directors` text NOT NULL,
- `producers` text NOT NULL,
- `operators` text NOT NULL,
- `composers` text NOT NULL,
- `screenwriters` text NOT NULL,
- `actors` text NOT NULL,
- `dubs` text NOT NULL,
- `distr_ids` varchar(255) NOT NULL DEFAULT '',
- `plot` text NOT NULL,
- `slogan` text NOT NULL,
- `known` text NOT NULL,
- `review` text NOT NULL,
- `premiere_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `premiere_date_intl` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `releases_id` int(11) NOT NULL,
- `rate_id` int(11) NOT NULL,
- `rate_value` varchar(6) NOT NULL,
- `imdb_rate` varchar(6) NOT NULL,
- `kp_rate` varchar(6) NOT NULL,
- `offsite` text NOT NULL,
- `url_cover` varchar(255) NOT NULL DEFAULT 'no_cover.png',
- `url_torrent` text NOT NULL,
- `url_magnet` text NOT NULL,
- `url_ftp` text NOT NULL,
- `url_http` text NOT NULL,
- `soundtracks_id` int(11) NOT NULL,
- `trailers_id` int(11) NOT NULL,
- `tech_params` text NOT NULL,
- `tech_format` varchar(64) NOT NULL DEFAULT '',
- `archived` tinyint(1) NOT NULL,
- `date_published` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `published` tinyint(1) NOT NULL,
- `author` varchar(64) NOT NULL,
- `metatags` text NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- CREATE TABLE `countries` (
- `c_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
- `c_name` varchar(64) NOT NULL DEFAULT '',
- `c_name_intl` varchar(64) NOT NULL DEFAULT '',
- `c_flag` varchar(6) NOT NULL,
- PRIMARY KEY (`c_id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- CREATE TABLE `genres` (
- `g_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
- `g_genre` text NOT NULL,
- `g_access` smallint(1) NOT NULL DEFAULT '0',
- `g_stats` int(6) NOT NULL DEFAULT '0',
- `g_published` smallint(1) NOT NULL DEFAULT '0',
- PRIMARY KEY (`g_id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;