View file upload/tables.sql

CREATE TABLE `comments` (
  `id` int(6) NOT NULL auto_increment,
  `fid` int(1) NOT NULL,
  `who` int(1) NOT NULL,
  `time` int(11) NOT NULL,
  `text` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `fid` (`fid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


CREATE TABLE `files` (
  `id` int(11) NOT NULL auto_increment,
  `type` text,
  `url` text NOT NULL,
  `title` text NOT NULL,
  `info` text NOT NULL,
  `time` int(11) NOT NULL,
  `clicks` int(6) NOT NULL default '0',
  `ltime` int(11) NOT NULL,
  `author` int(6) NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


CREATE TABLE `users` (
  `id` int(6) NOT NULL auto_increment,
  `login` char(25) NOT NULL,
  `nick` varchar(50) NOT NULL,
  `ps` text NOT NULL,
  `rtime` int(11) NOT NULL,
  `ltime` int(11) NOT NULL,
  `allfiles` int(6) NOT NULL default '0',
  `allsize` int(11) NOT NULL default '0',
  `inpage` int(3) NOT NULL default '8',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;