From 379d0c29bcaa5755f73eabe2c55081e8ebecafae Mon Sep 17 00:00:00 2001 From: Florian Pritz Date: Sun, 7 Nov 2010 19:16:57 +0100 Subject: update db.sql Signed-off-by: Florian Pritz --- db.sql | 26 ++++---------------------- 1 file 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; -- cgit v1.2.3-24-g4f1b