new uguu code

[uguu.git] / sqlite_schema.sql

diff --git a/sqlite_schema.sql b/sqlite_schema.sql
new file mode 100644 (file)
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;