Просмотр архива DCMS-SPECIAL 4.6

CREATE TABLE IF NOT EXISTS `user_dir` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `dir` int(11) NOT NULL,
 
`ras` varchar(150) NOT NULL,
  `upload` int(11) NOT NULL,
  `id_user`
int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=0;

CREATE TABLE IF NOT EXISTS `user_files`
(
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
 
`dir` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `time` int(11)
NOT NULL,
  `k_loads` int(11) NOT NULL,
  `opis` varchar(250) NOT NULL,
 
`size` varchar(20) NOT NULL,
  `ras` varchar(20) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=0 ;

CREATE
TABLE IF NOT EXISTS `user_files_komm` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `id_file` int(11) NOT NULL,
  `id_user` int(11) NOT
NULL,
  `text` varchar(1000) NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY
KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=0;