diff options
| author | akpu1 <akpu1@inventati.org> | 2016-06-22 07:58:15 +0200 |
|---|---|---|
| committer | Eliot Whalan <ewhal@pantsu.cat> | 2016-06-22 07:58:15 +0200 |
| commit | 424eea4f630d25158ec033a004666ecd0107f8b8 (patch) | |
| tree | 02e356202117b92c4c9e15a5f147f3598e93561a /schema.sql | |
| parent | 0d539ff4af4bb62d783d1920abb4158655645398 (diff) | |
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
Diffstat (limited to 'schema.sql')
| -rw-r--r-- | schema.sql | 27 |
1 files changed, 0 insertions, 27 deletions
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 |