-- phpMyAdmin SQL Dump
-- version 4.0.6
-- http://www.phpmyadmin.net
--
-- Servidor: 127.0.0.1
-- Tiempo de generación: 04-04-2017 a las 09:05:11
-- Versión del servidor: 5.6.14
-- Versión de PHP: 5.6.19

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

--
-- Base de datos: `ceremonias`
--

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

--
-- Estructura de tabla para la tabla `delegations`
--

CREATE TABLE IF NOT EXISTS `delegations` (
  `id_delegation` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(24) NOT NULL,
  `country` varchar(100) NOT NULL,
  PRIMARY KEY (`id_delegation`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Volcado de datos para la tabla `delegations`
--

INSERT INTO `delegations` (`id_delegation`, `code`, `country`) VALUES
(1, 'KAZ', 'KAZAKHSTAN');

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

--
-- Estructura de tabla para la tabla `games`
--

CREATE TABLE IF NOT EXISTS `games` (
  `id_game` int(11) NOT NULL AUTO_INCREMENT,
  `game` varchar(100) NOT NULL,
  `city` varchar(100) NOT NULL,
  PRIMARY KEY (`id_game`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Volcado de datos para la tabla `games`
--

INSERT INTO `games` (`id_game`, `game`, `city`) VALUES
(1, 'V Asian Indoor and Martial Arts Games', 'Ashgabat 2017');

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

--
-- Estructura de tabla para la tabla `performances`
--

CREATE TABLE IF NOT EXISTS `performances` (
  `id_performance` int(11) NOT NULL AUTO_INCREMENT,
  `text1` varchar(255) NOT NULL,
  `text2` varchar(255) NOT NULL,
  PRIMARY KEY (`id_performance`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Volcado de datos para la tabla `performances`
--

INSERT INTO `performances` (`id_performance`, `text1`, `text2`) VALUES
(1, 'CHAPTER TITLE', ''),
(2, 'CHAPTER TITLE', 'ACTOR, GROUP, ATHLETE, ...');

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

--
-- Estructura de tabla para la tabla `speeches_a`
--

CREATE TABLE IF NOT EXISTS `speeches_a` (
  `id_speech` int(11) NOT NULL AUTO_INCREMENT,
  `text1` varchar(255) NOT NULL,
  `text2` varchar(255) NOT NULL,
  PRIMARY KEY (`id_speech`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Volcado de datos para la tabla `speeches_a`
--

INSERT INTO `speeches_a` (`id_speech`, `text1`, `text2`) VALUES
(1, 'SEIKH Ahmad AL-FAHAD AL-SABAH', 'OCA PRESIDENT');

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

--
-- Estructura de tabla para la tabla `speeches_b`
--

CREATE TABLE IF NOT EXISTS `speeches_b` (
  `id_speech` int(11) NOT NULL AUTO_INCREMENT,
  `code1` varchar(10) NOT NULL,
  `country1` varchar(100) NOT NULL,
  `code2` varchar(10) NOT NULL,
  `country2` varchar(100) NOT NULL,
  PRIMARY KEY (`id_speech`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Volcado de datos para la tabla `speeches_b`
--

INSERT INTO `speeches_b` (`id_speech`, `code1`, `country1`, `code2`, `country2`) VALUES
(1, 'JPN', 'Yoshiyuki SEKI', 'KAZ', 'Sergei CHAADAEV');

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

--
-- Estructura de tabla para la tabla `tourch_a`
--

CREATE TABLE IF NOT EXISTS `tourch_a` (
  `id_tourch` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(10) NOT NULL,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id_tourch`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Volcado de datos para la tabla `tourch_a`
--

INSERT INTO `tourch_a` (`id_tourch`, `code`, `name`) VALUES
(1, 'KAZ', 'Aleksey EVSTAFEEV');

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

--
-- Estructura de tabla para la tabla `tourch_b`
--

CREATE TABLE IF NOT EXISTS `tourch_b` (
  `id_tourch` int(11) NOT NULL AUTO_INCREMENT,
  `code1` varchar(10) NOT NULL,
  `name1` varchar(255) NOT NULL,
  `code2` varchar(10) NOT NULL,
  `name2` varchar(255) NOT NULL,
  PRIMARY KEY (`id_tourch`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Volcado de datos para la tabla `tourch_b`
--

INSERT INTO `tourch_b` (`id_tourch`, `code1`, `name1`, `code2`, `name2`) VALUES
(1, 'JPN', 'Yoshiyuki SEKI', 'KAZ', 'Sergey CHAADAEV');

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

--
-- Estructura de tabla para la tabla `tourch_c`
--

CREATE TABLE IF NOT EXISTS `tourch_c` (
  `id_tourch` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(10) NOT NULL,
  `name` varchar(255) NOT NULL,
  `text` varchar(255) NOT NULL,
  PRIMARY KEY (`id_tourch`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Volcado de datos para la tabla `tourch_c`
--

INSERT INTO `tourch_c` (`id_tourch`, `code`, `name`, `text`) VALUES
(1, 'JPN', 'Yoshiyuki SEKI', 'JAPAN ALPINE SKIING TEAM MEMBER');

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

--
-- Estructura de tabla para la tabla `types`
--

CREATE TABLE IF NOT EXISTS `types` (
  `id_type` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY (`id_type`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

--
-- Volcado de datos para la tabla `types`
--

INSERT INTO `types` (`id_type`, `name`) VALUES
(1, 'CE001 - GAME PRESENTATION'),
(2, 'CE002 - VENUE'),
(3, 'CE003 - DELEGATION'),
(4, 'CE004 - PERFORMANCE 1'),
(5, 'CE004 - PERFORMANCE 2'),
(6, 'CE006A - SPEECHES & VIP PRESENTATION'),
(7, 'CE006B - SPEECHES & VIP PRESENTATION'),
(8, 'CE007A - FLAG/TOURCH BEERER (1 LINE)'),
(9, 'CE007A - FLAG/TOURCH BEERER (1 LINE)'),
(10, 'CE007B - FLAG/TOURCH BEERER (2 BEERERS)'),
(11, 'CE008 - FLAG/TOURCH BEERER (2 LINES)'),
(12, 'CE009 - 2 VIP´S ');

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

--
-- Estructura de tabla para la tabla `venues`
--

CREATE TABLE IF NOT EXISTS `venues` (
  `id_venue` int(11) NOT NULL AUTO_INCREMENT,
  `venue` varchar(100) NOT NULL,
  `city` varchar(100) NOT NULL,
  PRIMARY KEY (`id_venue`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Volcado de datos para la tabla `venues`
--

INSERT INTO `venues` (`id_venue`, `venue`, `city`) VALUES
(1, 'TEINE SKI AREA', 'SAPPORO');

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

--
-- Estructura de tabla para la tabla `vips`
--

CREATE TABLE IF NOT EXISTS `vips` (
  `id_vip` int(11) NOT NULL AUTO_INCREMENT,
  `name1` varchar(255) NOT NULL,
  `name2` varchar(255) NOT NULL,
  PRIMARY KEY (`id_vip`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Volcado de datos para la tabla `vips`
--

INSERT INTO `vips` (`id_vip`, `name1`, `name2`) VALUES
(1, 'Thomas BACH', 'SHEIKH A. AL-FAHAD AL-SABAH');

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