X-Git-Url: https://jfr.im/git/uguu.git/blobdiff_plain/b3ca9376cc8cf7c308c07f16b4d5b716f21a56dc..d8c46ff78ae2707a580f7b0446349122297b434f:/sqlite_schema.sql

diff --git a/sqlite_schema.sql b/sqlite_schema.sql
new file mode 100644
index 0000000..6338b51
--- /dev/null
+++ b/sqlite_schema.sql
@@ -0,0 +1,12 @@
+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
+);
+END TRANSACTION;