Файл: install/db_tables/files.sql
Строк: 37
CREATE TABLE IF NOT EXISTS `files` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `id_user` int(11) DEFAULT NULL,
  `name` text,
  `ras`
varchar(32) DEFAULT NULL,
  `time` int(11) DEFAULT NULL,
  `time2` int(11)
DEFAULT NULL,
  `pass` text,
  `cat` enum('files','music') DEFAULT
'files',
  `type` enum('all','only_me','friends','pass','list','dir')
DEFAULT NULL,
  `type2` enum('file','dir') DEFAULT 'dir',
  `sk`
enum('0','1') DEFAULT '0',
  `sk_user` int(11) DEFAULT '0',
  `dl` int(11)
DEFAULT '0',
  `type_dir` int(11) DEFAULT '0',
  `counter` text,
  `desc`
text,
  `id_dir` int(11) DEFAULT '0',
  `+18` enum('0','1') NOT NULL,
 
`komm` enum('1','2','3') DEFAULT '1',
  `rating` int(11) DEFAULT '0',
 
`sk_msg` text,
  `sk_time` int(11) DEFAULT NULL,
  `a_time` int(11) DEFAULT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
CREATE
TABLE IF NOT EXISTS `files_komm` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 `id_file` int(11) DEFAULT NULL,
  `id_user` int(11) DEFAULT NULL,
  `time`
int(11) DEFAULT NULL,
  `msg` varchar(1024) DEFAULT NULL,
  `reply` int(11)
DEFAULT '0',
  `komm_reply` text,
  `sk` enum('0','1') DEFAULT '0',
 
`sk_user` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM 
DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `files_rating` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `id_file` int(11) DEFAULT NULL,
 
`id_user` int(11) DEFAULT NULL,
  `time` int(11) DEFAULT NULL,
  `rating`
enum('1','2') DEFAULT '2',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;