summaryrefslogtreecommitdiffstats
path: root/db.sql
diff options
context:
space:
mode:
Diffstat (limited to 'db.sql')
-rw-r--r--db.sql26
1 files changed, 4 insertions, 22 deletions
diff --git a/db.sql b/db.sql
index ad95d2967..10cc76607 100644
--- a/db.sql
+++ b/db.sql
@@ -1,31 +1,13 @@
--- phpMyAdmin SQL Dump
--- version 3.2.4
--- http://www.phpmyadmin.net
---
--- Host: localhost
--- Erstellungszeit: 05. Januar 2010 um 17:40
--- Server Version: 5.1.41
--- PHP-Version: 5.3.1
-
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
---
--- Datenbank: `filebin`
---
-
--- --------------------------------------------------------
-
---
--- Tabellenstruktur für Tabelle `files`
---
-
CREATE TABLE IF NOT EXISTS `files` (
`hash` varchar(32) COLLATE utf8_bin NOT NULL,
`id` varchar(8) COLLATE utf8_bin NOT NULL,
`filename` varchar(256) COLLATE utf8_bin NOT NULL,
`password` varchar(40) COLLATE utf8_bin DEFAULT NULL,
- `date` int(11) unsigned NOT NULL,
+ `date` int(11) NOT NULL,
+ `mimetype` varchar(255) COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`id`),
- KEY `hash` (`hash`),
- KEY `date` (`date`)
+ KEY `date` (`date`),
+ KEY `hash` (`hash`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;