From 424eea4f630d25158ec033a004666ecd0107f8b8 Mon Sep 17 00:00:00 2001 From: akpu1 Date: Wed, 22 Jun 2016 15:58:15 +1000 Subject: Added instructions and schema to use or migrate to SQLite (#17) * Added MySQL to SQLite migration instructions; SQLite setup instructions * Renamed schema.sql to mysql_schema.sql * Produced modified schema suitable for SQLite * Added SQLite setup and migration instructions --- sqlite_schema.sql | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) create mode 100644 sqlite_schema.sql (limited to 'sqlite_schema.sql') diff --git a/sqlite_schema.sql b/sqlite_schema.sql new file mode 100644 index 0000000..414719c --- /dev/null +++ b/sqlite_schema.sql @@ -0,0 +1,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; -- cgit v1.2.3