Просмотр архива DCMS S

CREATE TABLE `obmennik_dir` (
  `id` int(11) NOT NULL auto_increment,
 
`num` int(11) default '0',
  `name` varchar(64) NOT NULL,
  `ras`
varchar(128) NOT NULL,
  `maxfilesize` int(11) NOT NULL,
  `dir`
varchar(512) NOT NULL default '/',
  `dir_osn` varchar(512) default '/',
 
`upload` set('1','0') NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY
`num` (`num`),
  KEY `dir` (`dir`(333))
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;

CREATE TABLE `obmennik_files` (
  `id` int(11) NOT NULL
auto_increment,
  `id_user` int(11) NOT NULL,
  `id_dir` int(11) NOT NULL,

 `name` varchar(128) NOT NULL,
  `blok` varchar(1500) default NULL,
 
`parol` varchar(1500) default NULL,
  `ras` varchar(36) NOT NULL,
  `type`
varchar(64) NOT NULL,
  `time` int(11) NOT NULL,
  `time_last` int(11) NOT
NULL,
  `size` int(11) NOT NULL,
  `k_loads` int(11) default '0',
  `opis`
text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;

CREATE TABLE `obmennik_komm` (
  `id` int(11) NOT NULL
auto_increment,
  `id_file` int(11) NOT NULL,
  `id_user` int(11) NOT
NULL,
  `time` int(11) NOT NULL,
  `msg` varchar(1024) NOT NULL,
  PRIMARY
KEY  (`id`),
  KEY `id_file` (`id_file`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;