]> jfr.im git - uguu.git/blob - sqlite_schema.sql
update favicon
[uguu.git] / sqlite_schema.sql
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
11 , `ip` char(15) default NULL
12 );
13 END TRANSACTION;