new.sql

CREATE TABLE files
(
  id integer unsigned not null auto_increment,
  hash_sha1 binary(160),
  filename varchar(255),
  size integer unsigned,
  mime varchar(255),
  
  unique index index_files_by_id (id),
  index index_files_by_sha1 (hash_sha1),

  primary key (id)
);

CREATE TABLE links
(
  id integer unsigned not null auto_increment,
  url varchar(31) not null,
  deleted bit default 0,
  deletion_key varchar(63),
  deletion_time timestamp,
  upload_time timestamp,
  file_id integer unsigned,
  owner_id integer unsigned,
  original_filename varchar(255),

  unique index index_links_by_id (id),
  unique index index_links_by_url (url),
  unique index index_links_by_deletion_key (deletion_key),
  
  primary key(id)
);

old.sql

CREATE TABLE files (
   id INTEGER PRIMARY KEY AUTO_INCREMENT,
   hash CHAR(40),            # sha1($file)
   orginalname VARCHAR(255), # YES TYPO I KNOW
   filename VARCHAR(30),
   size INTEGER,
   date DATE,
   expire DATE,
   delid CHAR(40)            # sha1($tempfilename)
);