Файл: 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;