-- phpMyAdmin SQL Dump
-- version 3.5.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 20. Jul 2012 um 18:45
-- Server Version: 5.5.25a-log
-- PHP-Version: 5.4.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Datenbank: `gsep12`
--

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

--
-- Tabellenstruktur für Tabelle `archive_entries`
--

CREATE TABLE IF NOT EXISTS `archive_entries` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `serialized_object` blob NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Tabellenstruktur für Tabelle `distance_matrices`
--

CREATE TABLE IF NOT EXISTS `distance_matrices` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `serialized_object` longblob NOT NULL,
  `rad_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `rad_id` (`rad_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Tabellenstruktur für Tabelle `feedbacks`
--

CREATE TABLE IF NOT EXISTS `feedbacks` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `serialized_object` blob NOT NULL,
  `rad_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `rad_id` (`rad_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Tabellenstruktur für Tabelle `group_registrations`
--

CREATE TABLE IF NOT EXISTS `group_registrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `serialized_object` blob NOT NULL,
  `rad_id` int(10) unsigned NOT NULL DEFAULT '0',
  `validation_token1` char(36) NOT NULL,
  `validation_token2` char(36) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `validation_token1` (`validation_token1`),
  KEY `validation_token2` (`validation_token2`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Tabellenstruktur für Tabelle `mailing_lists`
--

CREATE TABLE IF NOT EXISTS `mailing_lists` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `serialized_object` blob NOT NULL,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Tabellenstruktur für Tabelle `opt_groups`
--

CREATE TABLE IF NOT EXISTS `opt_groups` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `serialized_object` blob NOT NULL,
  `rad_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `rad_id` (`rad_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Tabellenstruktur für Tabelle `run_and_dines`
--

CREATE TABLE IF NOT EXISTS `run_and_dines` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `serialized_object` blob NOT NULL,
  `date` date NOT NULL,
  PRIMARY KEY (`id`),
  KEY `date` (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Tabellenstruktur für Tabelle `single_classes`
--

CREATE TABLE IF NOT EXISTS `single_classes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `class_name` varchar(255) NOT NULL,
  `serialized_object` blob NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`class_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Tabellenstruktur für Tabelle `single_registrations`
--

CREATE TABLE IF NOT EXISTS `single_registrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `serialized_object` blob NOT NULL,
  `rad_id` int(10) NOT NULL DEFAULT '0',
  `validation_token` char(36) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `rad_id` (`rad_id`),
  KEY `validation_token` (`validation_token`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Tabellenstruktur für Tabelle `status`
--

CREATE TABLE IF NOT EXISTS `status` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `serialized_object` blob NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
