-- phpMyAdmin SQL Dump
-- version 3.4.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 24. Apr 2012 um 18:40
-- Server Version: 5.5.16
-- PHP-Version: 5.3.8

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

--
-- Datenbank: `astaf`
--


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

--
-- Tabellenstruktur für Tabelle `angebot`
--

DROP TABLE IF EXISTS `angebot`;
CREATE TABLE IF NOT EXISTS `angebot` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kategorie_id` int(11) DEFAULT NULL,
  `name` varchar(80) CHARACTER SET latin1 DEFAULT NULL,
  `beschreibung` text CHARACTER SET latin1,
  `published` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `angebot_FI_1` (`kategorie_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=247 ;

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

--
-- Tabellenstruktur für Tabelle `angebot_verein`
--

DROP TABLE IF EXISTS `angebot_verein`;
CREATE TABLE IF NOT EXISTS `angebot_verein` (
  `angebot_id` int(11) NOT NULL,
  `verein_id` int(11) NOT NULL,
  `menge` double NOT NULL,
  `einheit` varchar(20) NOT NULL,
  `preis` float NOT NULL,
  `published` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`angebot_id`,`verein_id`,`menge`,`einheit`),
  KEY `angebot_verein_FI_2` (`verein_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Tabellenstruktur für Tabelle `astaf_user`
--

DROP TABLE IF EXISTS `astaf_user`;
CREATE TABLE IF NOT EXISTS `astaf_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(128) CHARACTER SET latin1 NOT NULL,
  `algorithm` varchar(128) CHARACTER SET latin1 NOT NULL DEFAULT 'sha1',
  `salt` varchar(128) CHARACTER SET latin1 NOT NULL,
  `password` varchar(128) CHARACTER SET latin1 NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `last_login` datetime DEFAULT NULL,
  `is_active` int(11) NOT NULL DEFAULT '1',
  `is_super_admin` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `sf_guard_user_username_unique` (`username`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=56 ;

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

--
-- Tabellenstruktur für Tabelle `kategorie`
--

DROP TABLE IF EXISTS `kategorie`;
CREATE TABLE IF NOT EXISTS `kategorie` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `einheiten` varchar(100) NOT NULL,
  `default_menge` double DEFAULT NULL,
  `default_einheit` varchar(20) NOT NULL,
  `published` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

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

--
-- Tabellenstruktur für Tabelle `standort`
--

DROP TABLE IF EXISTS `standort`;
CREATE TABLE IF NOT EXISTS `standort` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` enum('Bühne','Stand') NOT NULL DEFAULT 'Stand',
  `name` varchar(80) DEFAULT NULL,
  `pos_lat` double DEFAULT NULL,
  `pos_long` double DEFAULT NULL,
  `published` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=56 ;

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

--
-- Tabellenstruktur für Tabelle `termin`
--

DROP TABLE IF EXISTS `termin`;
CREATE TABLE IF NOT EXISTS `termin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `verein_id` int(11) DEFAULT NULL,
  `titel` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `startzeit` datetime DEFAULT NULL,
  `endzeit` datetime DEFAULT NULL,
  `beschreibung` text CHARACTER SET latin1,
  `published` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `termin_FI_1` (`verein_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=222 ;

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

--
-- Tabellenstruktur für Tabelle `verein`
--

DROP TABLE IF EXISTS `verein`;
CREATE TABLE IF NOT EXISTS `verein` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `url` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
  `bild` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `email` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `slug` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `kontaktdaten` text CHARACTER SET latin1,
  `beschreibung` text CHARACTER SET latin1,
  `standort_id` int(11) DEFAULT NULL,
  `published` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `verein_FI_1` (`standort_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=57 ;