blob: 414719c628acfde25fa5f6f0ec18d8a164f142c4 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
PRAGMA synchronous = OFF;
PRAGMA journal_mode = MEMORY;
BEGIN TRANSACTION;
CREATE TABLE `files` (
`id` integer NOT NULL PRIMARY KEY AUTOINCREMENT
, `hash` char(40) default NULL
, `originalname` varchar(255) default NULL
, `filename` varchar(30) default NULL
, `size` integer default NULL
, `date` date default NULL
, `expire` date default NULL
, `delid` char(40) default NULL
, `user` integer default '0'
, `dir` integer default '0'
);
END TRANSACTION;
|
