POMF/sqlite_schema.sql

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;