sqlite_schema.sql

   1 PRAGMA synchronous = OFF;
   2 PRAGMA journal_mode = MEMORY;
   3 BEGIN TRANSACTION;
   4 CREATE TABLE `files` (
   5   `id` integer  NOT NULL PRIMARY KEY AUTOINCREMENT
   6 ,  `hash` char(40) default NULL
   7 ,  `originalname` varchar(255) default NULL
   8 ,  `filename` varchar(30) default NULL
   9 ,  `size` integer  default NULL
  10 ,  `date` integer default NULL
  11 ,  `ip` char(15) default NULL
  12 );
  13 CREATE TABLE `accounts` (
  14   `id` integer  NOT NULL PRIMARY KEY AUTOINCREMENT
  15 ,  `email` varchar(255) default NULL
  16 ,  `pass` varchar(255) default NULL
  17 ,  `level` integer  default NULL
  18 );
  19 CREATE TABLE `blacklist` (
  20   `id` integer  NOT NULL PRIMARY KEY AUTOINCREMENT
  21 ,  `hash` char(40) default NULL
  22 ,  `originalname` varchar(255) default NULL
  23 ,  `time` integer default NULL
  24 );
  25 END TRANSACTION;