diff options
| author | Eliot Whalan <ewhal@pantsu.cat> | 2016-06-24 12:08:15 +0200 |
|---|---|---|
| committer | Eliot Whalan <ewhal@pantsu.cat> | 2016-06-24 12:08:15 +0200 |
| commit | c28e5cb54469d514c08b7a44e6abceb4045e7041 (patch) | |
| tree | d4bb88a341d8d3e77504afcd3ef10b3c22b9ac90 /mysql_schema.sql | |
| parent | fe69cdbb29939f99817643f94eb7396c8cfe5285 (diff) | |
| parent | 424eea4f630d25158ec033a004666ecd0107f8b8 (diff) | |
Merge branch 'master' of github.com:pomf/pomf
Diffstat (limited to 'mysql_schema.sql')
| -rw-r--r-- | mysql_schema.sql | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/mysql_schema.sql b/mysql_schema.sql new file mode 100644 index 0000000..154f095 --- /dev/null +++ b/mysql_schema.sql @@ -0,0 +1,27 @@ +-- 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 |