Merge pull request #2 from pomf/master

e;

1 files changed, 16 insertions, 0 deletions

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;