-- phpMyAdmin SQL Dump
-- version 4.0.10.7
-- http://www.phpmyadmin.net
--
-- Palvelin: localhost
-- Luontiaika: 13.04.2015 klo 19:29
-- Palvelimen versio: 5.5.34-cll-lve
-- PHP:n versio: 5.4.23

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 */;

--
-- Tietokanta: `c5zsddtr_pikseli`
--

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

--
-- Rakenne taululle `jarjestajat`
--

CREATE TABLE IF NOT EXISTS `jarjestajat` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'järjestäjän id',
  `nimi` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
  `vrl` varchar(12) COLLATE utf8_swedish_ci NOT NULL,
  `mail` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
  `talli` varchar(140) COLLATE utf8_swedish_ci NOT NULL,
  `talli_url` varchar(255) COLLATE utf8_swedish_ci NOT NULL,
  `talli_id` varchar(12) COLLATE utf8_swedish_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci AUTO_INCREMENT=3 ;

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

--
-- Rakenne taululle `kutsut`
--

CREATE TABLE IF NOT EXISTS `kutsut` (
  `id` int(11) NOT NULL COMMENT 'kutsun id',
  `paivitetty_aika` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `rypas_id` int(11) NOT NULL,
  `otsikko` varchar(140) COLLATE utf8_swedish_ci NOT NULL,
  `kilpailu_pvm` date NOT NULL,
  `vip_pvm` date NOT NULL,
  `jarjestaja_id` int(11) NOT NULL,
  `saannot` text COLLATE utf8_swedish_ci NOT NULL,
  `osallistuja_max` int(11) NOT NULL,
  `osallistuminen_mail` varchar(100) COLLATE utf8_swedish_ci NOT NULL,
  `osallistuminen_otsikko` varchar(30) COLLATE utf8_swedish_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;

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

--
-- Rakenne taululle `luokat`
--

CREATE TABLE IF NOT EXISTS `luokat` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'luokan id',
  `kutsu_id` int(11) NOT NULL,
  `rypas_id` int(11) NOT NULL,
  `luokka_indeksi` int(11) NOT NULL,
  `nimi` tinytext COLLATE utf8_swedish_ci NOT NULL,
  `osallistujat` mediumtext COLLATE utf8_swedish_ci NOT NULL,
  `tulokset` mediumtext COLLATE utf8_swedish_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci AUTO_INCREMENT=1933 ;

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