Просмотр архива Фото, видео, аудио альбомы


CREATE TABLE IF NOT EXISTS `audio_album` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `name` varchar(64) NOT
NULL,
  `opis` varchar(260) NOT NULL,
  `time` int(11) NOT NULL,
 
`pass` varchar(32) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 ;


CREATE TABLE IF NOT EXISTS `audio_komm` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `msg`
varchar(1024) NOT NULL,
  `time` int(11) NOT NULL,
  `id_album` int(11)
NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
;

CREATE TABLE IF NOT EXISTS `audio_rating` (
  `id_user` int(11) NOT
NULL,
  `id_audio` int(11) NOT NULL,
  `rating` int(11) NOT NULL DEFAULT
'0',
  KEY `id_user` (`id_user`,`id_audio`),
  KEY `rating` (`rating`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS
`audio_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_album`
int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `ras` varchar(64) NOT
NULL,
  `name` varchar(64) NOT NULL,
  `opis` varchar(260) NOT NULL,
 
`time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 ;

CREATE TABLE IF NOT EXISTS `audio_zapret` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `zapret`
set('1','0') NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `id_user`
(`id_user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT
EXISTS `photo_album` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`id_user` int(11) NOT NULL,
  `name` varchar(64) NOT NULL,
  `opis`
varchar(260) NOT NULL,
  `time` int(11) NOT NULL,
  `pass` varchar(32)
NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `photo_komm` (
  `id` int(11)
NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `msg`
varchar(1024) NOT NULL,
  `time` int(11) NOT NULL,
  `id_album` int(11)
NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
;


CREATE TABLE IF NOT EXISTS `photo_rating` (
  `id_user` int(11) NOT
NULL,
  `id_photo` int(11) NOT NULL,
  `rating` int(11) NOT NULL DEFAULT
'0',
  KEY `id_user` (`id_user`,`id_photo`),
  KEY `rating` (`rating`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS
`photo_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_album`
int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `ras` varchar(64) NOT
NULL,
  `name` varchar(64) NOT NULL,
  `opis` varchar(260) NOT NULL,
 
`time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 ;


CREATE TABLE IF NOT EXISTS `photo_zapret` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `zapret`
set('1','0') NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `id_user`
(`id_user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;

CREATE TABLE IF NOT
EXISTS `video_album` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`id_user` int(11) NOT NULL,
  `name` varchar(64) NOT NULL,
  `opis`
varchar(260) NOT NULL,
  `time` int(11) NOT NULL,
  `pass` varchar(32)
NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `video_komm` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `msg`
varchar(1024) NOT NULL,
  `time` int(11) NOT NULL,
  `id_album` int(11)
NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;



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


CREATE
TABLE IF NOT EXISTS `video_user` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `id_album` int(11) NOT NULL,
  `id_user` int(11) NOT
NULL,
  `ras` varchar(64) NOT NULL,
  `name` varchar(64) NOT NULL,
 
`opis` varchar(260) NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT
EXISTS `video_zapret` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`id_user` int(11) NOT NULL,
  `zapret` set('1','0') NOT NULL DEFAULT
'0',
  PRIMARY KEY (`id`),
  KEY `id_user` (`id_user`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 ;