summaryrefslogtreecommitdiffstats
path: root/db.sql
diff options
context:
space:
mode:
authorFlorian Pritz <bluewind@xssn.at>2010-11-07 19:16:57 +0100
committerFlorian Pritz <bluewind@xssn.at>2010-11-07 19:16:57 +0100
commit379d0c29bcaa5755f73eabe2c55081e8ebecafae (patch)
tree99e30a28bd3618e41a98e3846125ed6f127e55aa /db.sql
parentdf26ee52259cfcb66701a072266fd59fe75ef389 (diff)
update db.sql
Signed-off-by: Florian Pritz <bluewind@xssn.at>
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;