src/static/dbSchemas/postgres_schema.sql

   1 CREATE TABLE files
   2 (
   3     id           serial PRIMARY KEY,
   4     hash         text    NOT NULL,
   5     originalname text    NOT NULL,
   6     filename     text    NOT NULL,
   7     size         integer not null,
   8     date         integer not null,
   9     ip           text    null
  10 );
  11
  12 CREATE TABLE blacklist
  13 (
  14     id           serial PRIMARY KEY,
  15     hash         text    NOT NULL,
  16     originalname text    NOT NULL,
  17     time         integer not null,
  18     ip           text    null
  19 );
  20
  21 CREATE TABLE ratelimit
  22 (
  23     id     serial PRIMARY KEY,
  24     iphash text    NOT NULL,
  25     files  integer not null,
  26     time   integer not null
  27 );