diff options
author | Florian Pritz <bluewind@xssn.at> | 2010-02-06 23:14:56 +0100 |
---|---|---|
committer | Florian Pritz <bluewind@xssn.at> | 2010-02-06 23:31:27 +0100 |
commit | 9e9d77b4072de4f8c73e8bbade07a8f27734e4bd (patch) | |
tree | a5d709254968fed8f3acdb9eec68fde2faa14b94 /db.sql |
Initial commit
Signed-off-by: Florian Pritz <bluewind@xssn.at>
Diffstat (limited to 'db.sql')
-rw-r--r-- | db.sql | 31 |
1 files changed, 31 insertions, 0 deletions
@@ -0,0 +1,31 @@ +-- 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, + PRIMARY KEY (`id`), + KEY `hash` (`hash`), + KEY `date` (`date`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |