]>
Commit | Line | Data |
---|---|---|
d8c46ff7 GJ |
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 | |
8fa0750d | 11 | , `ip` char(15) default NULL |
d8c46ff7 | 12 | ); |
d0b9cbdc GJ |
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 | ); | |
e480c0e5 GJ |
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 | ); | |
d8c46ff7 | 31 | END TRANSACTION; |