From 9e9d77b4072de4f8c73e8bbade07a8f27734e4bd Mon Sep 17 00:00:00 2001 From: Florian Pritz Date: Sat, 6 Feb 2010 23:14:56 +0100 Subject: Initial commit Signed-off-by: Florian Pritz --- db.sql | 31 +++++++++++++++++++++++++++++++ 1 file changed, 31 insertions(+) create mode 100644 db.sql (limited to 'db.sql') diff --git a/db.sql b/db.sql new file mode 100644 index 000000000..ad95d2967 --- /dev/null +++ b/db.sql @@ -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; -- cgit v1.2.3-24-g4f1b