gistfile1.txt

-- phpMyAdmin SQL Dump
-- version 2.11.8.1deb5+lenny8
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 25. Februar 2011 um 14:24
-- Server Version: 5.0.51
-- PHP-Version: 5.2.6-1+lenny9

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Datenbank: `eightyone`
--

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `files`
--

CREATE TABLE IF NOT EXISTS `files` (
  `id` bigint(20) unsigned NOT NULL,
  `filename` varchar(200) collate utf8_unicode_ci NOT NULL,
  `filesize` bigint(20) NOT NULL,
  `otrkey` tinyint(1) NOT NULL default '0',
  `hq` tinyint(1) NOT NULL default '0',
  `hd` tinyint(1) NOT NULL default '0',
  `mp4` tinyint(1) NOT NULL default '0',
  `cut` tinyint(1) NOT NULL default '0',
  `avi` tinyint(1) NOT NULL default '0',
  `ac3` tinyint(1) NOT NULL default '0',
  `start` datetime NOT NULL,
  `duration` int(11) NOT NULL,
  `title` varchar(100) collate utf8_unicode_ci NOT NULL,
  `present` tinyint(1) NOT NULL default '1' COMMENT 'marks wether a file is available on the download server',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `filename` (`filename`),
  KEY `start` (`start`),
  KEY `title` (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Daten für Tabelle `files`
--

INSERT INTO `files` (`id`, `filename`, `filesize`, `otrkey`, `hq`, `hd`, `mp4`, `cut`, `avi`, `ac3`, `start`, `duration`, `title`, `present`) VALUES
(0, 'blablub.otrkey', 12345, 1, 0, 0, 0, 0, 0, 0, '2011-02-25 14:17:28', 120, 'blablub', 1);

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `tickets`
--

CREATE TABLE IF NOT EXISTS `tickets` (
  `id` bigint(20) NOT NULL auto_increment,
  `hash` binary(40) NOT NULL,
  `created` datetime NOT NULL,
  `active` tinyint(1) default '0',
  `file` int(11) NOT NULL COMMENT 'relation to file',
  PRIMARY KEY  (`id`),
  KEY `file` (`file`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Daten für Tabelle `tickets`
--

INSERT INTO `tickets` (`id`, `hash`, `created`, `active`, `file`) VALUES
(1, '7110eda4d09e062aa5e4a390b0a572ac0d2c0220', '2011-02-10 13:35:30', 0, 0);