src/static/dbSchemas/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 CREATE TABLE `ratelimit` (
  26   `id` integer  NOT NULL PRIMARY KEY AUTOINCREMENT
  27 ,  `iphash` char(40) default NULL
  28 ,  `time` integer default NULL
  29 ,  `files` integer default NULL
  30 );
  31 END TRANSACTION;