From 424eea4f630d25158ec033a004666ecd0107f8b8 Mon Sep 17 00:00:00 2001
From: akpu1 <akpu1@inventati.org>
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
---
 schema.sql | 27 ---------------------------
 1 file changed, 27 deletions(-)
 delete mode 100644 schema.sql

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
deleted file mode 100644
index 154f095..0000000
--- a/schema.sql
+++ /dev/null
@@ -1,27 +0,0 @@
--- MySQL dump 10.13  Distrib 5.6.21-70.1, for debian-linux-gnu (x86_64)
---
--- Host: localhost    Database: pomf
-
---
--- Table structure for table `files`
---
-
-CREATE TABLE `files` (
-  `id` int(10) unsigned NOT NULL auto_increment,
-  `hash` char(40) default NULL,
-  `originalname` varchar(255) default NULL,
-  `filename` varchar(30) default NULL,
-  `size` int(10) unsigned default NULL,
-  `date` date default NULL,
-  `expire` date default NULL, -- Deprecated since version 2.1.0
-  `delid` char(40) default NULL,
-  `user` int(10) unsigned default '0',
-  `dir` int(2) default '0',
-  PRIMARY KEY (`id`)
-) ENGINE=InnoDB;
--- `filename` length (30) may be a bit excessive, since the average length would be smaller
--- [6 for the name + the file extension length], but since there is no limit for the file
--- extension length (at the moment, at least) let's keep it high in order to avoid problems
-
-
--- Dump completed on 2014-12-07 19:30:13
-- 
cgit v1.2.3