View file lichnyi-kabinyet-v1.1/tabl.sql

CREATE TABLE `category` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(315) default NULL,
  `icon` varchar(64) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE `video` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(100) default NULL,
  `opis` varchar(1024) default NULL,
  `url` varchar(11) default NULL,
  `id_user` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `count` int(11) NOT NULL,
  `id_category` int(11) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `gruppy_video_komm` (
  `id` int(11) NOT NULL auto_increment,
  `msg` varchar(512) default NULL,
  `id_user` int(11) NOT NULL,
  `id_video` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `gruppy_video_like` (
  `id_video` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `like` int(11) DEFAULT '0',
  KEY `id_video` (`id_video`,`id_user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;