View file install/db_tables/loads.sql

CREATE TABLE `loads_komm` (
  `id` int(11) NOT NULL auto_increment,
  `file` varchar(64) NOT NULL,
  `path` varchar(1024) NOT NULL,
  `time` int(11) NOT NULL,
  `msg` varchar(512) NOT NULL,
  `id_user` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `file` (`file`),
  KEY `path` (`path`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `loads_list` (
  `name` varchar(256) NOT NULL,
  `id_user` int(11) NOT NULL,
  `size` int(11) NOT NULL,
  `path` varchar(1000) NOT NULL DEFAULT '/',
  `time` int(11) NOT NULL,
  `time_r` int(11) NOT NULL,
  `rating` int(11) NOT NULL DEFAULT '0',
  `kol` int(11) NOT NULL DEFAULT '0',
  `user` varchar(128) NOT NULL,
  `loads` int(11) NOT NULL DEFAULT '0',
  `prosm` int(11) NOT NULL DEFAULT '0',
  `opis` varchar(1024) NOT NULL,
  KEY `time` (`time`),
  KEY `time_r` (`time_r`),
  KEY `size` (`size`),
  KEY `name` (`name`),
  KEY `id_user` (`id_user`),
  KEY `loads` (`loads`),
  KEY `prosm` (`prosm`),
  KEY `rating` (`rating`),
  KEY `kol` (`kol`),
  KEY `user` (`user`),
  FULLTEXT KEY `path_2` (`path`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `loads_rating` (
  `id_user` int(32) NOT NULL,
  `name` varchar(1024) NOT NULL,
  `path` varchar(1000) NOT NULL DEFAULT '/',
  KEY `id_user` (`id_user`),
  KEY `name` (`name`),
  FULLTEXT KEY `path_2` (`path`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;