mysql_schema.sql

   1 CREATE TABLE `files` (
   2  `id` int(20) unsigned NOT NULL auto_increment,
   3   `hash` char(40) DEFAULT NULL,
   4   `originalname` varchar(255) default NULL,
   5   `filename` varchar(30) default NULL,
   6   `size` int(15) DEFAULT NULL,
   7   `date` int(15) DEFAULT NULL,
   8   `ip` char(15) DEFAULT NULL,
   9   PRIMARY KEY (`id`)
  10 );
  11
  12 CREATE TABLE `accounts` (
  13  `id` int(20) unsigned NOT NULL auto_increment,
  14   `email` varchar(255) default NULL,
  15   `pass` varchar(255) default NULL,
  16   `level` int(15) DEFAULT NULL,
  17   PRIMARY KEY (`id`)
  18 );
  19
  20 CREATE TABLE `blacklist` (
  21  `id` int(20) unsigned NOT NULL auto_increment,
  22   `hash` char(40) DEFAULT NULL,
  23   `originalname` varchar(255) default NULL,
  24   `time` int(15) DEFAULT NULL,
  25   PRIMARY KEY (`id`)
  26 );