[uguu.git] / 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` integer default NULL
,  `ip` char(15) default NULL
);
END TRANSACTION;
Commit	Line	Data
d8c46ff7 GJ	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
8fa0750d	11	, `ip` char(15) default NULL
d8c46ff7 GJ	12	);
d8c46ff7 GJ	13	END TRANSACTION;