]>
jfr.im git - uguu.git/blob - src/static/dbSchemas/mysql_schema.sql
2 `
id`
int(20) unsigned
NOT NULL auto_increment
,
3 `hash`
char(40) DEFAULT NULL,
4 `originalname`
varchar(255) default NULL,
5 `filename`
varchar(30) default NULL,
6 `
size`
int(15) DEFAULT NULL,
7 `
date`
int(15) DEFAULT NULL,
8 `ip`
char(15) DEFAULT NULL,
12 CREATE TABLE `accounts`
(
13 `
id`
int(20) unsigned
NOT NULL auto_increment
,
14 `email`
varchar(255) default NULL,
15 `pass`
varchar(255) default NULL,
16 `
level`
int(15) DEFAULT NULL,
20 CREATE TABLE `blacklist`
(
21 `
id`
int(20) unsigned
NOT NULL auto_increment
,
22 `hash`
char(40) DEFAULT NULL,
23 `originalname`
varchar(255) default NULL,
24 `
time`
int(15) DEFAULT NULL,
28 CREATE TABLE `ratelimit`
30 `
id`
int(20) unsigned
NOT NULL auto_increment
,
31 `iphash`
char(40) DEFAULT NULL,
32 `files`
int(15) default NULL,
33 `
time`
int(15) DEFAULT NULL,