Просмотр архива DCMS Special v 7.0.2 beta

CREATE TABLE `gallery` (
  `id` int(11) NOT NULL auto_increment,
 
`id_user` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `time_create`
int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `opis` varchar(256) NOT
NULL,
  `access` enum('all','only_me','friends','pass','auth') DEFAULT
'all',
  `password` mediumtext,
  PRIMARY KEY  (`id`),
  KEY `id_user`
(`id_user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE
`gallery_rating` (
  `id_foto` int(11) NOT NULL,
  `id_user` int(11) NOT
NULL,
  KEY `id_foto` (`id_foto`,`id_user`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;

CREATE TABLE `gallery_foto` (
  `id` int(11) NOT NULL
auto_increment,
  `id_gallery` int(11) NOT NULL,
  `id_user` int(11) NOT
NULL,
  `name` varchar(100) NOT NULL,
  `ras` varchar(4) NOT NULL,
  `type`
varchar(64) NOT NULL,
  `adult` enum('0','1') DEFAULT '0',
  `opis`
varchar(10024) NOT NULL,
  `rating` int(11) NOT NULL default '0',
  `komm`
enum('all','only_me','friends') DEFAULT 'all',
  PRIMARY KEY  (`id`),
  KEY
`id_gallery` (`id_gallery`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE
TABLE `gallery_komm` (
  `id` int(11) NOT NULL auto_increment,
  `id_foto`
int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `time` int(11) NOT NULL,

 `msg` varchar(10024) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `id_foto`
(`id_foto`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;