Просмотр архива ВиДеО

CREATE TABLE  `video` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name`
varchar(255) NOT NULL,
  `about` text NOT NULL,
  `filename` varchar(255)
NOT NULL,
  `screen` varchar(255) NOT NULL,
  `timeleft` int(11) NOT
NULL,
  `size_mp4` bigint(20) NOT NULL,
  `size_3gp` bigint(20) NOT
NULL,
  `date_upload` int(11) NOT NULL,
  `last_load` int(11) NOT NULL,

 `view_count` int(11) NOT NULL,
  `load_count` int(11) NOT NULL,
 
`like_count` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM 
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

CREATE TABLE  `category` (
 
`id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  PRIMARY
KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
AUTO_INCREMENT=1;

CREATE TABLE  `contact` (
  `id_video` int(11) NOT
NULL,
  `id_category` int(11) NOT NULL
) ENGINE=MyISAM;