Файл: Kulinar/tables.sql
Строк: 44
CREATE TABLE `Kulinar_dir` (
`id` int(11) NOT NULL auto_increment,
`num` int(11) NOT NULL default '0',
`name` varchar(64) NOT NULL,
`stat` int(11) NOT NULL default '0',
`dir` varchar(512) NOT NULL default
'/',
`dir_osn` varchar(512) default '/',
PRIMARY KEY (`id`),
KEY
`num` (`num`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE
`Kulinar_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,
`time_last` int(11) NOT NULL,
`size` int(11) default NULL,
`plus` int(11) NOT NULL default '0',
`minus` int(11) NOT NULL default
'0',
`k_loads` int(11) NOT NULL default '0',
`time` int(11) NOT
NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
CREATE TABLE `Kulinar_files_komm` (
`id` int(11) NOT
NULL auto_increment,
`id_file` int(11) NOT NULL default '0',
`id_user` int(11) NOT NULL default '0',
`msg` varchar(1024) NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
CREATE TABLE `Kulinar_files_rating` (
`id` int(11) NOT
NULL auto_increment,
`id_file` int(11) NOT NULL default '0',
`id_user` int(11) NOT NULL default '0',
`plus` int(11) NOT NULL default
'0',
`minus` int(11) NOT NULL default '0',
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;