View file library/tables.sql

CREATE TABLE `lib_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 `lib_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 `lib_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 `lib_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;