]>
Commit | Line | Data |
---|---|---|
1 | CREATE TABLE `files` ( | |
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, | |
9 | PRIMARY KEY (`id`) | |
10 | ); | |
11 | ||
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, | |
17 | PRIMARY KEY (`id`) | |
18 | ); | |
19 | ||
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, | |
25 | PRIMARY KEY (`id`) | |
26 | ); |