]>
jfr.im git - uguu.git/blob - src/static/dbSchemas/sqlite_schema.sql
1 PRAGMA synchronous
= OFF;
2 PRAGMA journal_mode
= MEMORY
;
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
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
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
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