]>
Commit | Line | Data |
---|---|---|
d0b9cbdc GJ |
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`) | |
76816232 | 10 | ); |
d0b9cbdc GJ |
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`) | |
76816232 | 18 | ); |
d0b9cbdc GJ |
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`) | |
76816232 | 26 | ); |