haddock.sql

-- phpMyAdmin SQL Dump
-- version 4.8.3
-- https://www.phpmyadmin.net/
--
-- Hôte : localhost:8889
-- Généré le :  Dim 16 juin 2019 à 09:48
-- Version du serveur :  5.7.23
-- Version de PHP :  7.2.8

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

--
-- Base de données :  `haddock_base`
--
DROP DATABASE IF EXISTS `haddock_base`;
CREATE DATABASE IF NOT EXISTS `haddock_base` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `haddock_base`;

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

--
-- Structure de la table `album`
--

DROP TABLE IF EXISTS `album`;
CREATE TABLE `album` (
  `album_ref` varchar(5) NOT NULL,
  `album_titre` varchar(100) NOT NULL,
  `album_parution` int(11) NOT NULL,
  `album_tome` int(11) NOT NULL,
  `album_image` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `album`
--

INSERT INTO `album` (`album_ref`, `album_titre`, `album_parution`, `album_tome`, `album_image`) VALUES
('714', 'Vol 714 pour Sydney', 1968, 22, 'Tintin_22'),
('7BC', 'Les 7 Boules de Cristal', 1948, 13, 'Tintin_13'),
('ATS', 'L\'affaire Tournesol', 1956, 18, 'Tintin_18'),
('BCF', 'Les Bijoux de la Castafiore', 1963, 21, 'Tintin_21'),
('CES', 'Coke en stock', 1958, 19, 'Tintin_19'),
('CPH', 'Les cigares du Pharaon', 1934, 4, 'Tintin_4'),
('CPO', 'Le crabe aux pinces d\'or', 1941, 9, 'Tintin_9'),
('EMY', 'L\'étoile mystérieuse', 1942, 10, 'Tintin_10'),
('INO', 'L\'île noire', 1938, 7, 'Tintin_7'),
('LBL', 'Le Lotus bleu', 1936, 5, 'Tintin_5'),
('OCA', 'L\'oreille cassée', 1937, 6, 'Tintin_6'),
('OLU', 'Objectif Lune', 1953, 16, 'Tintin_16'),
('OML', 'On a marché sur la Lune', 1954, 17, 'Tintin_17'),
('PIC', 'Tintin et les Picaros', 1976, 23, 'Tintin_23'),
('PON', 'Tintin au pays de l\'or noir', 1950, 15, 'Tintin_15'),
('SLI', 'Le Secret de la licorne', 1943, 11, 'Tintin_11'),
('SOT', 'Le Sceptre d’Ottokar', 1939, 8, 'Tintin_8'),
('TAA', 'Tintin et l’Alph-Art', 1986, 24, 'Tintin_24'),
('TAM', 'Tintin En Amérique', 1932, 3, 'Tintin_3'),
('TAT', 'Tintin au Tibet', 1960, 20, 'Tintin_20'),
('TPS', 'Tintin au pays des Soviets', 1930, 1, 'Tintin_1'),
('TRR', 'Le Trésor de Rackham le Rouge', 1944, 12, 'Tintin_12'),
('TSO', 'Le Temple du Soleil', 1949, 14, 'Tintin_14');

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

--
-- Structure de la table `bande`
--

DROP TABLE IF EXISTS `bande`;
CREATE TABLE `bande` (
  `bande_place` varchar(1) NOT NULL,
  `num_page` int(11) NOT NULL,
  `ref_album` varchar(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `bande`
--

INSERT INTO `bande` (`bande_place`, `num_page`, `ref_album`) VALUES
('B', 1, '714'),
('C', 1, 'BCF'),
('D', 1, 'CES'),
('C', 1, 'OLU'),
('D', 1, 'PIC'),
('B', 1, 'TAT'),
('D', 2, '714'),
('B', 2, 'BCF'),
('C', 2, 'BCF'),
('C', 2, 'OLU'),
('D', 2, 'OLU'),
('B', 2, 'OML'),
('D', 2, 'OML'),
('A', 2, 'PIC'),
('B', 2, 'TRR'),
('D', 2, 'TSO'),
('A', 3, '714'),
('A', 3, 'OLU'),
('C', 3, 'OLU'),
('C', 3, 'OML'),
('D', 3, 'OML'),
('A', 3, 'TAT'),
('C', 3, 'TRR'),
('A', 3, 'TSO'),
('D', 3, 'TSO'),
('B', 4, 'ATS'),
('C', 4, 'ATS'),
('D', 4, 'CES'),
('A', 4, 'OLU'),
('C', 4, 'OLU'),
('C', 4, 'OML'),
('A', 4, 'TAT'),
('B', 4, 'TRR'),
('D', 4, 'TRR'),
('A', 4, 'TSO'),
('A', 5, 'BCF'),
('B', 5, 'BCF'),
('D', 5, 'CES'),
('A', 5, 'OLU'),
('B', 5, 'OLU'),
('C', 5, 'OLU'),
('D', 5, 'OLU'),
('C', 5, 'SLI'),
('D', 5, 'SLI'),
('C', 5, 'TAT'),
('D', 5, 'TAT'),
('A', 5, 'TRR'),
('A', 5, 'TSO'),
('C', 5, 'TSO'),
('D', 6, '7BC'),
('A', 6, 'BCF'),
('C', 6, 'BCF'),
('B', 6, 'CES'),
('C', 6, 'CES'),
('C', 6, 'OLU'),
('D', 6, 'OLU'),
('A', 6, 'OML'),
('B', 6, 'PIC'),
('A', 6, 'TAT'),
('D', 6, 'TAT'),
('C', 7, '714'),
('A', 7, '7BC'),
('B', 7, '7BC'),
('B', 7, 'BCF'),
('C', 7, 'BCF'),
('D', 7, 'BCF'),
('B', 7, 'CES'),
('A', 7, 'OLU'),
('B', 7, 'OLU'),
('B', 7, 'TRR'),
('C', 7, 'TRR'),
('D', 7, 'TRR'),
('A', 8, 'BCF'),
('B', 8, 'OLU'),
('C', 8, 'OML'),
('D', 8, 'PIC'),
('A', 8, 'TRR'),
('A', 9, 'CES'),
('D', 9, 'EMY'),
('B', 9, 'OLU'),
('C', 9, 'OLU'),
('D', 9, 'OLU'),
('A', 9, 'PIC'),
('C', 9, 'PIC'),
('A', 9, 'TAT'),
('D', 9, 'TRR'),
('C', 10, '714'),
('B', 10, 'BCF'),
('A', 10, 'OLU'),
('B', 10, 'OLU'),
('C', 10, 'OML'),
('C', 10, 'PIC'),
('D', 10, 'PIC'),
('C', 11, '714'),
('D', 11, 'ATS'),
('D', 11, 'OLU'),
('B', 11, 'OML'),
('C', 11, 'OML'),
('A', 11, 'PIC'),
('B', 11, 'PIC'),
('A', 11, 'TAT'),
('B', 11, 'TRR'),
('B', 12, '714'),
('D', 12, 'BCF'),
('A', 12, 'OLU'),
('B', 12, 'OLU'),
('B', 12, 'OML'),
('A', 12, 'TRR'),
('B', 13, 'BCF'),
('A', 13, 'OML'),
('D', 13, 'TAT'),
('A', 14, '714'),
('B', 14, '7BC'),
('D', 14, '7BC'),
('A', 14, 'ATS'),
('B', 14, 'BCF'),
('B', 14, 'CES'),
('A', 14, 'SLI'),
('A', 14, 'TAT'),
('B', 14, 'TAT'),
('D', 14, 'TAT'),
('D', 15, 'ATS'),
('B', 15, 'OML'),
('A', 15, 'PIC'),
('A', 15, 'TAT'),
('B', 15, 'TAT'),
('F', 15, 'TAT'),
('A', 16, 'CES'),
('B', 16, 'CES'),
('B', 16, 'EMY'),
('C', 16, 'EMY'),
('D', 16, 'TAT'),
('D', 16, 'TRR'),
('A', 17, 'EMY'),
('B', 17, 'PIC'),
('C', 17, 'PIC'),
('A', 17, 'TAT'),
('B', 17, 'TAT'),
('A', 17, 'TRR'),
('C', 17, 'TRR'),
('B', 18, '714'),
('B', 18, 'BCF'),
('C', 18, 'OLU'),
('C', 18, 'OML'),
('C', 18, 'PIC'),
('B', 18, 'TAT'),
('C', 18, 'TRR'),
('D', 18, 'TRR'),
('B', 19, 'ATS'),
('C', 19, 'ATS'),
('D', 19, 'ATS'),
('B', 19, 'BCF'),
('C', 19, 'BCF'),
('D', 19, 'EMY'),
('A', 19, 'PIC'),
('C', 19, 'PIC'),
('B', 19, 'SLI'),
('C', 19, 'TRR'),
('D', 19, 'TRR'),
('A', 20, 'ATS'),
('A', 20, 'CPO'),
('B', 20, 'CPO'),
('A', 20, 'EMY'),
('C', 20, 'OML'),
('B', 20, 'SLI'),
('C', 20, 'SLI'),
('A', 20, 'TRR'),
('B', 20, 'TRR'),
('C', 20, 'TRR'),
('D', 20, 'TRR'),
('C', 21, '714'),
('D', 21, '714'),
('B', 21, 'BCF'),
('B', 21, 'EMY'),
('A', 22, '714'),
('C', 22, '714'),
('D', 22, '714'),
('A', 22, 'ATS'),
('A', 22, 'BCF'),
('A', 22, 'CPO'),
('A', 22, 'PIC'),
('A', 23, '714'),
('B', 23, '714'),
('C', 23, '714'),
('A', 23, 'PIC'),
('C', 23, 'PIC'),
('A', 23, 'TRR'),
('D', 23, 'TRR'),
('B', 24, 'BCF'),
('B', 24, 'TAT'),
('C', 24, 'TAT'),
('D', 24, 'TAT'),
('C', 25, 'BCF'),
('C', 25, 'CPO'),
('D', 25, 'CPO'),
('D', 25, 'EMY'),
('A', 25, 'TAT'),
('A', 26, 'BCF'),
('C', 26, 'BCF'),
('D', 26, 'BCF'),
('A', 26, 'CES'),
('A', 26, 'EMY'),
('B', 26, 'EMY'),
('A', 26, 'OLU'),
('B', 26, 'OML'),
('A', 26, 'TAT'),
('B', 26, 'TAT'),
('C', 26, 'TAT'),
('D', 26, 'TAT'),
('C', 27, '714'),
('D', 27, '7BC'),
('A', 27, 'BCF'),
('C', 27, 'BCF'),
('D', 27, 'EMY'),
('A', 27, 'OML'),
('C', 27, 'OML'),
('A', 27, 'TAT'),
('C', 27, 'TAT'),
('D', 28, 'ATS'),
('C', 28, 'BCF'),
('A', 28, 'OML'),
('C', 28, 'TAT'),
('B', 28, 'TRR'),
('D', 28, 'TRR'),
('A', 29, '714'),
('B', 29, '7BC'),
('C', 29, '7BC'),
('B', 29, 'OML'),
('A', 29, 'SLI'),
('B', 29, 'SLI'),
('A', 29, 'TRR'),
('B', 29, 'TRR'),
('C', 29, 'TRR'),
('C', 30, 'BCF'),
('D', 30, 'CPO'),
('A', 30, 'EMY'),
('B', 30, 'OLU'),
('D', 30, 'TRR'),
('A', 30, 'TSO'),
('B', 31, 'OLU'),
('C', 31, 'OML'),
('C', 31, 'PIC'),
('C', 31, 'SLI'),
('D', 31, 'TRR'),
('C', 32, 'ATS'),
('D', 32, 'EMY'),
('C', 32, 'OLU'),
('A', 32, 'SLI'),
('A', 32, 'TAT'),
('D', 32, 'TAT'),
('B', 32, 'TRR'),
('C', 32, 'TRR'),
('C', 32, 'TSO'),
('B', 33, 'ATS'),
('B', 33, 'CES'),
('A', 33, 'OML'),
('B', 33, 'OML'),
('A', 33, 'TSO'),
('B', 34, '714'),
('D', 34, '714'),
('D', 34, '7BC'),
('B', 34, 'ATS'),
('C', 34, 'ATS'),
('B', 34, 'EMY'),
('C', 34, 'EMY'),
('C', 34, 'OLU'),
('A', 34, 'OML'),
('C', 34, 'OML'),
('B', 34, 'TAT'),
('D', 35, '714'),
('A', 35, '7BC'),
('C', 35, 'CES'),
('D', 35, 'CES'),
('A', 35, 'EMY'),
('B', 35, 'TAT'),
('D', 35, 'TRR'),
('B', 36, '714'),
('B', 36, 'ATS'),
('C', 36, 'ATS'),
('C', 36, 'BCF'),
('D', 36, 'BCF'),
('B', 36, 'CPO'),
('B', 36, 'EMY'),
('B', 36, 'OLU'),
('C', 36, 'OML'),
('C', 36, 'TAT'),
('D', 36, 'TAT'),
('A', 36, 'TSO'),
('D', 37, 'CPO'),
('C', 37, 'EMY'),
('D', 37, 'EMY'),
('A', 37, 'TAT'),
('B', 37, 'TRR'),
('C', 37, 'TRR'),
('A', 38, 'BCF'),
('A', 38, 'CES'),
('A', 38, 'CPO'),
('C', 38, 'CPO'),
('B', 38, 'EMY'),
('C', 38, 'OLU'),
('A', 38, 'OML'),
('D', 38, 'OML'),
('C', 38, 'TAT'),
('D', 38, 'TAT'),
('A', 38, 'TSO'),
('B', 39, '714'),
('C', 39, '714'),
('A', 39, 'OLU'),
('B', 39, 'OLU'),
('D', 40, '7BC'),
('B', 40, 'BCF'),
('D', 40, 'EMY'),
('A', 40, 'OLU'),
('A', 40, 'TAT'),
('B', 40, 'TAT'),
('C', 40, 'TAT'),
('D', 40, 'TAT'),
('A', 41, 'BCF'),
('C', 41, 'CES'),
('C', 41, 'CPO'),
('A', 41, 'EMY'),
('C', 41, 'EMY'),
('A', 41, 'TAT'),
('D', 41, 'TAT'),
('A', 41, 'TRR'),
('D', 42, '714'),
('B', 42, '7BC'),
('A', 42, 'ATS'),
('B', 42, 'ATS'),
('D', 42, 'ATS'),
('C', 42, 'OML'),
('B', 42, 'PIC'),
('A', 42, 'TAT'),
('A', 43, '7BC'),
('C', 43, 'EMY'),
('A', 43, 'OLU'),
('C', 43, 'OLU'),
('B', 43, 'OML'),
('C', 43, 'TRR'),
('B', 44, '714'),
('B', 44, 'ATS'),
('D', 44, 'BCF'),
('A', 44, 'CES'),
('D', 44, 'OLU'),
('A', 44, 'OML'),
('C', 45, '714'),
('A', 45, '7BC'),
('B', 45, '7BC'),
('A', 45, 'OML'),
('D', 45, 'OML'),
('D', 45, 'SLI'),
('A', 45, 'TRR'),
('A', 46, 'ATS'),
('A', 46, 'CES'),
('B', 46, 'CES'),
('C', 46, 'CES'),
('D', 46, 'CES'),
('A', 46, 'OLU'),
('C', 46, 'OLU'),
('B', 46, 'OML'),
('C', 46, 'OML'),
('C', 46, 'TSO'),
('C', 47, '7BC'),
('D', 47, '7BC'),
('B', 47, 'CES'),
('D', 47, 'OLU'),
('A', 47, 'OML'),
('B', 47, 'OML'),
('C', 47, 'OML'),
('D', 47, 'OML'),
('C', 47, 'TAT'),
('B', 47, 'TSO'),
('C', 47, 'TSO'),
('B', 48, '7BC'),
('C', 48, 'ATS'),
('D', 48, 'OLU'),
('B', 48, 'OML'),
('D', 48, 'OML'),
('B', 48, 'TAT'),
('A', 48, 'TSO'),
('B', 49, '714'),
('A', 49, 'CES'),
('B', 49, 'CES'),
('C', 49, 'CES'),
('A', 49, 'OLU'),
('B', 49, 'OLU'),
('C', 49, 'OLU'),
('D', 49, 'OML'),
('B', 49, 'TAT'),
('B', 49, 'TRR'),
('A', 49, 'TSO'),
('C', 50, '7BC'),
('D', 50, 'CES'),
('A', 50, 'OLU'),
('A', 50, 'OML'),
('A', 50, 'TAT'),
('C', 50, 'TSO'),
('A', 51, '714'),
('A', 51, '7BC'),
('B', 51, '7BC'),
('D', 51, 'OML'),
('A', 51, 'TAT'),
('B', 51, 'TAT'),
('D', 52, 'CES'),
('A', 52, 'OLU'),
('B', 52, 'OLU'),
('C', 52, 'OLU'),
('D', 52, 'OML'),
('A', 52, 'TAT'),
('C', 52, 'TRR'),
('A', 53, 'CPO'),
('B', 53, 'CPO'),
('C', 53, 'OLU'),
('D', 53, 'OLU'),
('B', 53, 'OML'),
('D', 53, 'SLI'),
('A', 53, 'TAT'),
('B', 54, '714'),
('A', 54, '7BC'),
('B', 54, '7BC'),
('C', 54, '7BC'),
('A', 54, 'OLU'),
('B', 54, 'OML'),
('C', 54, 'OML'),
('D', 54, 'OML'),
('A', 54, 'SLI'),
('C', 54, 'SLI'),
('A', 54, 'TAT'),
('B', 54, 'TAT'),
('C', 54, 'TAT'),
('D', 54, 'TAT'),
('D', 55, '714'),
('A', 55, '7BC'),
('B', 55, '7BC'),
('D', 55, 'CPO'),
('A', 55, 'OLU'),
('A', 55, 'OML'),
('B', 55, 'OML'),
('C', 55, 'OML'),
('D', 55, 'OML'),
('B', 56, '714'),
('D', 56, '7BC'),
('D', 56, 'CES'),
('A', 56, 'CPO'),
('B', 56, 'CPO'),
('A', 56, 'OLU'),
('A', 56, 'OML'),
('B', 56, 'OML'),
('A', 56, 'SLI'),
('D', 56, 'TSO'),
('B', 57, 'BCF'),
('B', 57, 'CPO'),
('D', 57, 'PON'),
('A', 58, '7BC'),
('B', 58, '7BC'),
('C', 58, 'PON'),
('A', 58, 'TAT'),
('B', 59, '7BC'),
('C', 59, '7BC'),
('D', 59, '7BC'),
('B', 59, 'BCF'),
('B', 59, 'OLU'),
('A', 59, 'PON'),
('D', 60, '714'),
('A', 60, 'OLU'),
('A', 60, 'PON'),
('A', 60, 'TAT'),
('B', 60, 'TAT'),
('A', 61, '7BC'),
('D', 61, 'BCF'),
('B', 61, 'PON'),
('D', 61, 'PON'),
('A', 61, 'SLI'),
('B', 61, 'SLI'),
('A', 61, 'TSO'),
('A', 62, '7BC'),
('D', 62, 'EMY'),
('A', 62, 'OML'),
('C', 62, 'OML'),
('A', 62, 'PON'),
('D', 62, 'PON'),
('B', 62, 'TAT');

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

--
-- Structure de la table `case_bulle`
--

DROP TABLE IF EXISTS `case_bulle`;
CREATE TABLE `case_bulle` (
  `case_num` int(11) NOT NULL,
  `place_bande` varchar(1) NOT NULL,
  `num_page` int(11) NOT NULL,
  `ref_album` varchar(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `case_bulle`
--

INSERT INTO `case_bulle` (`case_num`, `place_bande`, `num_page`, `ref_album`) VALUES
(2, 'B', 1, '714'),
(3, 'B', 1, '714'),
(1, 'C', 1, 'BCF'),
(3, 'D', 1, 'CES'),
(1, 'C', 1, 'OLU'),
(2, 'B', 1, 'TAT'),
(3, 'D', 2, '714'),
(3, 'B', 2, 'BCF'),
(1, 'C', 2, 'BCF'),
(2, 'C', 2, 'BCF'),
(3, 'C', 2, 'BCF'),
(1, 'C', 2, 'OLU'),
(1, 'D', 2, 'OLU'),
(3, 'D', 2, 'OLU'),
(4, 'B', 2, 'OML'),
(1, 'D', 2, 'OML'),
(1, 'A', 2, 'PIC'),
(2, 'A', 2, 'PIC'),
(1, 'B', 2, 'TRR'),
(2, 'B', 2, 'TRR'),
(2, 'D', 2, 'TSO'),
(3, 'A', 3, '714'),
(2, 'A', 3, 'OLU'),
(3, 'C', 3, 'OLU'),
(4, 'C', 3, 'OML'),
(2, 'D', 3, 'OML'),
(1, 'A', 3, 'TAT'),
(1, 'C', 3, 'TRR'),
(1, 'A', 3, 'TSO'),
(3, 'D', 3, 'TSO'),
(0, 'B', 4, 'ATS'),
(1, 'C', 4, 'ATS'),
(1, 'D', 4, 'CES'),
(1, 'A', 4, 'OLU'),
(1, 'C', 4, 'OLU'),
(3, 'C', 4, 'OLU'),
(1, 'C', 4, 'OML'),
(4, 'C', 4, 'OML'),
(1, 'A', 4, 'TAT'),
(2, 'B', 4, 'TRR'),
(2, 'D', 4, 'TRR'),
(1, 'A', 4, 'TSO'),
(1, 'A', 5, 'BCF'),
(4, 'B', 5, 'BCF'),
(2, 'D', 5, 'CES'),
(1, 'A', 5, 'OLU'),
(3, 'A', 5, 'OLU'),
(1, 'B', 5, 'OLU'),
(1, 'C', 5, 'OLU'),
(3, 'C', 5, 'OLU'),
(1, 'D', 5, 'OLU'),
(2, 'C', 5, 'SLI'),
(1, 'D', 5, 'SLI'),
(1, 'C', 5, 'TAT'),
(2, 'D', 5, 'TAT'),
(1, 'A', 5, 'TRR'),
(2, 'A', 5, 'TSO'),
(3, 'A', 5, 'TSO'),
(2, 'C', 5, 'TSO'),
(3, 'D', 6, '7BC'),
(1, 'A', 6, 'BCF'),
(3, 'C', 6, 'BCF'),
(3, 'B', 6, 'CES'),
(2, 'C', 6, 'CES'),
(3, 'C', 6, 'CES'),
(1, 'C', 6, 'OLU'),
(2, 'C', 6, 'OLU'),
(3, 'C', 6, 'OLU'),
(2, 'D', 6, 'OLU'),
(1, 'A', 6, 'OML'),
(2, 'B', 6, 'PIC'),
(2, 'A', 6, 'TAT'),
(1, 'D', 6, 'TAT'),
(1, 'C', 7, '714'),
(1, 'A', 7, '7BC'),
(3, 'A', 7, '7BC'),
(2, 'B', 7, '7BC'),
(1, 'B', 7, 'BCF'),
(3, 'C', 7, 'BCF'),
(3, 'D', 7, 'BCF'),
(1, 'B', 7, 'CES'),
(3, 'A', 7, 'OLU'),
(2, 'B', 7, 'OLU'),
(3, 'B', 7, 'OLU'),
(2, 'B', 7, 'TRR'),
(1, 'C', 7, 'TRR'),
(2, 'D', 7, 'TRR'),
(1, 'A', 8, 'BCF'),
(2, 'B', 8, 'OLU'),
(4, 'C', 8, 'OML'),
(2, 'D', 8, 'PIC'),
(3, 'D', 8, 'PIC'),
(1, 'A', 8, 'TRR'),
(2, 'A', 9, 'CES'),
(3, 'D', 9, 'EMY'),
(1, 'B', 9, 'OLU'),
(3, 'C', 9, 'OLU'),
(2, 'D', 9, 'OLU'),
(2, 'A', 9, 'PIC'),
(1, 'C', 9, 'PIC'),
(2, 'A', 9, 'TAT'),
(3, 'A', 9, 'TAT'),
(3, 'D', 9, 'TRR'),
(1, 'C', 10, '714'),
(2, 'B', 10, 'BCF'),
(1, 'A', 10, 'OLU'),
(2, 'A', 10, 'OLU'),
(1, 'B', 10, 'OLU'),
(2, 'B', 10, 'OLU'),
(3, 'C', 10, 'OML'),
(1, 'C', 10, 'PIC'),
(3, 'C', 10, 'PIC'),
(3, 'D', 10, 'PIC'),
(1, 'C', 11, '714'),
(2, 'D', 11, 'ATS'),
(3, 'D', 11, 'OLU'),
(3, 'B', 11, 'OML'),
(1, 'C', 11, 'OML'),
(2, 'A', 11, 'PIC'),
(1, 'B', 11, 'PIC'),
(1, 'A', 11, 'TAT'),
(3, 'A', 11, 'TAT'),
(3, 'B', 11, 'TRR'),
(3, 'B', 12, '714'),
(2, 'D', 12, 'BCF'),
(1, 'A', 12, 'OLU'),
(2, 'B', 12, 'OLU'),
(2, 'B', 12, 'OML'),
(3, 'A', 12, 'TRR'),
(1, 'B', 13, 'BCF'),
(2, 'A', 13, 'OML'),
(2, 'D', 13, 'TAT'),
(1, 'A', 14, '714'),
(2, 'B', 14, '7BC'),
(2, 'D', 14, '7BC'),
(4, 'D', 14, '7BC'),
(1, 'A', 14, 'ATS'),
(4, 'B', 14, 'BCF'),
(2, 'B', 14, 'CES'),
(1, 'A', 14, 'SLI'),
(2, 'A', 14, 'SLI'),
(3, 'A', 14, 'SLI'),
(3, 'A', 14, 'TAT'),
(2, 'B', 14, 'TAT'),
(1, 'D', 14, 'TAT'),
(1, 'D', 15, 'ATS'),
(3, 'B', 15, 'OML'),
(1, 'A', 15, 'PIC'),
(1, 'A', 15, 'TAT'),
(2, 'B', 15, 'TAT'),
(1, 'F', 15, 'TAT'),
(2, 'F', 15, 'TAT'),
(3, 'A', 16, 'CES'),
(3, 'B', 16, 'CES'),
(3, 'B', 16, 'EMY'),
(1, 'C', 16, 'EMY'),
(2, 'C', 16, 'EMY'),
(4, 'C', 16, 'EMY'),
(2, 'D', 16, 'TAT'),
(3, 'D', 16, 'TRR'),
(3, 'A', 17, 'EMY'),
(1, 'B', 17, 'PIC'),
(2, 'C', 17, 'PIC'),
(1, 'A', 17, 'TAT'),
(1, 'B', 17, 'TAT'),
(2, 'B', 17, 'TAT'),
(4, 'B', 17, 'TAT'),
(1, 'A', 17, 'TRR'),
(3, 'A', 17, 'TRR'),
(2, 'C', 17, 'TRR'),
(1, 'B', 18, '714'),
(2, 'B', 18, 'BCF'),
(3, 'C', 18, 'OLU'),
(2, 'C', 18, 'OML'),
(1, 'C', 18, 'PIC'),
(1, 'B', 18, 'TAT'),
(2, 'C', 18, 'TRR'),
(1, 'D', 18, 'TRR'),
(1, 'B', 19, 'ATS'),
(1, 'C', 19, 'ATS'),
(1, 'D', 19, 'ATS'),
(4, 'B', 19, 'BCF'),
(2, 'C', 19, 'BCF'),
(3, 'C', 19, 'BCF'),
(3, 'D', 19, 'EMY'),
(1, 'A', 19, 'PIC'),
(1, 'C', 19, 'PIC'),
(2, 'B', 19, 'SLI'),
(2, 'C', 19, 'TRR'),
(3, 'D', 19, 'TRR'),
(1, 'A', 20, 'ATS'),
(3, 'A', 20, 'CPO'),
(2, 'B', 20, 'CPO'),
(1, 'A', 20, 'EMY'),
(3, 'A', 20, 'EMY'),
(1, 'C', 20, 'OML'),
(2, 'C', 20, 'OML'),
(2, 'B', 20, 'SLI'),
(3, 'B', 20, 'SLI'),
(1, 'C', 20, 'SLI'),
(1, 'A', 20, 'TRR'),
(3, 'A', 20, 'TRR'),
(2, 'B', 20, 'TRR'),
(1, 'C', 20, 'TRR'),
(3, 'D', 20, 'TRR'),
(2, 'C', 21, '714'),
(2, 'D', 21, '714'),
(3, 'D', 21, '714'),
(1, 'B', 21, 'BCF'),
(2, 'B', 21, 'BCF'),
(2, 'B', 21, 'EMY'),
(1, 'A', 22, '714'),
(1, 'C', 22, '714'),
(3, 'D', 22, '714'),
(1, 'A', 22, 'ATS'),
(3, 'A', 22, 'ATS'),
(2, 'A', 22, 'BCF'),
(1, 'A', 22, 'CPO'),
(2, 'A', 22, 'PIC'),
(1, 'A', 23, '714'),
(2, 'A', 23, '714'),
(4, 'A', 23, '714'),
(5, 'A', 23, '714'),
(2, 'B', 23, '714'),
(3, 'C', 23, '714'),
(1, 'A', 23, 'PIC'),
(1, 'C', 23, 'PIC'),
(3, 'A', 23, 'TRR'),
(3, 'D', 23, 'TRR'),
(4, 'B', 24, 'BCF'),
(2, 'B', 24, 'TAT'),
(1, 'C', 24, 'TAT'),
(1, 'D', 24, 'TAT'),
(2, 'D', 24, 'TAT'),
(2, 'C', 25, 'BCF'),
(4, 'C', 25, 'CPO'),
(2, 'D', 25, 'CPO'),
(3, 'D', 25, 'EMY'),
(1, 'A', 25, 'TAT'),
(3, 'A', 25, 'TAT'),
(4, 'A', 26, 'BCF'),
(2, 'C', 26, 'BCF'),
(3, 'D', 26, 'BCF'),
(1, 'A', 26, 'CES'),
(3, 'A', 26, 'EMY'),
(1, 'B', 26, 'EMY'),
(3, 'B', 26, 'EMY'),
(3, 'A', 26, 'OLU'),
(2, 'B', 26, 'OML'),
(2, 'A', 26, 'TAT'),
(1, 'B', 26, 'TAT'),
(3, 'B', 26, 'TAT'),
(1, 'C', 26, 'TAT'),
(2, 'C', 26, 'TAT'),
(1, 'D', 26, 'TAT'),
(2, 'D', 26, 'TAT'),
(3, 'D', 26, 'TAT'),
(5, 'D', 26, 'TAT'),
(6, 'D', 26, 'TAT'),
(2, 'C', 27, '714'),
(1, 'D', 27, '7BC'),
(1, 'A', 27, 'BCF'),
(2, 'C', 27, 'BCF'),
(4, 'D', 27, 'EMY'),
(2, 'A', 27, 'OML'),
(3, 'C', 27, 'OML'),
(1, 'A', 27, 'TAT'),
(2, 'A', 27, 'TAT'),
(1, 'C', 27, 'TAT'),
(3, 'D', 28, 'ATS'),
(1, 'C', 28, 'BCF'),
(2, 'A', 28, 'OML'),
(3, 'C', 28, 'TAT'),
(3, 'B', 28, 'TRR'),
(3, 'D', 28, 'TRR'),
(1, 'A', 29, '714'),
(3, 'B', 29, '7BC'),
(2, 'C', 29, '7BC'),
(1, 'B', 29, 'OML'),
(1, 'A', 29, 'SLI'),
(2, 'A', 29, 'SLI'),
(3, 'A', 29, 'SLI'),
(1, 'B', 29, 'SLI'),
(2, 'B', 29, 'SLI'),
(1, 'A', 29, 'TRR'),
(2, 'B', 29, 'TRR'),
(3, 'C', 29, 'TRR'),
(3, 'C', 30, 'BCF'),
(1, 'D', 30, 'CPO'),
(1, 'A', 30, 'EMY'),
(2, 'A', 30, 'EMY'),
(1, 'B', 30, 'OLU'),
(1, 'D', 30, 'TRR'),
(2, 'A', 30, 'TSO'),
(1, 'B', 31, 'OLU'),
(2, 'C', 31, 'OML'),
(3, 'C', 31, 'PIC'),
(1, 'C', 31, 'SLI'),
(2, 'D', 31, 'TRR'),
(4, 'C', 32, 'ATS'),
(4, 'D', 32, 'EMY'),
(5, 'C', 32, 'OLU'),
(2, 'A', 32, 'SLI'),
(3, 'A', 32, 'TAT'),
(2, 'D', 32, 'TAT'),
(2, 'B', 32, 'TRR'),
(2, 'C', 32, 'TRR'),
(2, 'C', 32, 'TSO'),
(3, 'B', 33, 'ATS'),
(3, 'B', 33, 'CES'),
(1, 'A', 33, 'OML'),
(1, 'B', 33, 'OML'),
(3, 'A', 33, 'TSO'),
(1, 'B', 34, '714'),
(3, 'D', 34, '714'),
(3, 'D', 34, '7BC'),
(4, 'B', 34, 'ATS'),
(3, 'C', 34, 'ATS'),
(3, 'B', 34, 'EMY'),
(2, 'C', 34, 'EMY'),
(1, 'C', 34, 'OLU'),
(2, 'C', 34, 'OLU'),
(4, 'C', 34, 'OLU'),
(3, 'A', 34, 'OML'),
(1, 'C', 34, 'OML'),
(2, 'B', 34, 'TAT'),
(0, 'D', 35, '714'),
(3, 'A', 35, '7BC'),
(2, 'C', 35, 'CES'),
(3, 'D', 35, 'CES'),
(1, 'A', 35, 'EMY'),
(2, 'B', 35, 'TAT'),
(3, 'B', 35, 'TAT'),
(2, 'D', 35, 'TRR'),
(3, 'D', 35, 'TRR'),
(1, 'B', 36, '714'),
(3, 'B', 36, 'ATS'),
(7, 'B', 36, 'ATS'),
(1, 'C', 36, 'ATS'),
(3, 'C', 36, 'BCF'),
(2, 'D', 36, 'BCF'),
(1, 'B', 36, 'CPO'),
(2, 'B', 36, 'EMY'),
(2, 'B', 36, 'OLU'),
(1, 'C', 36, 'OML'),
(3, 'C', 36, 'OML'),
(3, 'C', 36, 'TAT'),
(3, 'D', 36, 'TAT'),
(2, 'A', 36, 'TSO'),
(1, 'D', 37, 'CPO'),
(3, 'D', 37, 'CPO'),
(2, 'C', 37, 'EMY'),
(1, 'D', 37, 'EMY'),
(3, 'A', 37, 'TAT'),
(1, 'B', 37, 'TRR'),
(3, 'C', 37, 'TRR'),
(4, 'A', 38, 'BCF'),
(1, 'A', 38, 'CES'),
(2, 'A', 38, 'CPO'),
(3, 'A', 38, 'CPO'),
(2, 'C', 38, 'CPO'),
(3, 'B', 38, 'EMY'),
(3, 'C', 38, 'OLU'),
(1, 'A', 38, 'OML'),
(3, 'D', 38, 'OML'),
(2, 'C', 38, 'TAT'),
(2, 'D', 38, 'TAT'),
(1, 'A', 38, 'TSO'),
(3, 'A', 38, 'TSO'),
(3, 'B', 39, '714'),
(1, 'C', 39, '714'),
(3, 'A', 39, 'OLU'),
(4, 'B', 39, 'OLU'),
(2, 'D', 40, '7BC'),
(2, 'B', 40, 'BCF'),
(2, 'D', 40, 'EMY'),
(3, 'D', 40, 'EMY'),
(1, 'A', 40, 'OLU'),
(3, 'A', 40, 'TAT'),
(2, 'B', 40, 'TAT'),
(1, 'C', 40, 'TAT'),
(5, 'C', 40, 'TAT'),
(3, 'D', 40, 'TAT'),
(4, 'A', 41, 'BCF'),
(3, 'C', 41, 'CES'),
(1, 'C', 41, 'CPO'),
(1, 'A', 41, 'EMY'),
(1, 'C', 41, 'EMY'),
(1, 'A', 41, 'TAT'),
(2, 'A', 41, 'TAT'),
(3, 'D', 41, 'TAT'),
(3, 'A', 41, 'TRR'),
(4, 'A', 41, 'TRR'),
(3, 'D', 42, '714'),
(1, 'B', 42, '7BC'),
(3, 'A', 42, 'ATS'),
(4, 'A', 42, 'ATS'),
(4, 'B', 42, 'ATS'),
(1, 'D', 42, 'ATS'),
(1, 'C', 42, 'OML'),
(3, 'B', 42, 'PIC'),
(8, 'B', 42, 'PIC'),
(3, 'A', 42, 'TAT'),
(1, 'A', 43, '7BC'),
(4, 'A', 43, '7BC'),
(2, 'C', 43, 'EMY'),
(2, 'A', 43, 'OLU'),
(1, 'C', 43, 'OLU'),
(4, 'C', 43, 'OLU'),
(3, 'B', 43, 'OML'),
(3, 'C', 43, 'TRR'),
(4, 'C', 43, 'TRR'),
(2, 'B', 44, '714'),
(4, 'B', 44, 'ATS'),
(3, 'D', 44, 'BCF'),
(1, 'A', 44, 'CES'),
(3, 'D', 44, 'OLU'),
(2, 'A', 44, 'OML'),
(3, 'C', 45, '714'),
(1, 'A', 45, '7BC'),
(2, 'A', 45, '7BC'),
(2, 'B', 45, '7BC'),
(4, 'A', 45, 'OML'),
(3, 'D', 45, 'OML'),
(4, 'D', 45, 'SLI'),
(1, 'A', 45, 'TRR'),
(4, 'A', 46, 'ATS'),
(3, 'A', 46, 'CES'),
(2, 'B', 46, 'CES'),
(1, 'C', 46, 'CES'),
(1, 'D', 46, 'CES'),
(2, 'D', 46, 'CES'),
(3, 'A', 46, 'OLU'),
(1, 'C', 46, 'OLU'),
(1, 'B', 46, 'OML'),
(3, 'B', 46, 'OML'),
(1, 'C', 46, 'OML'),
(3, 'C', 46, 'TSO'),
(1, 'C', 47, '7BC'),
(1, 'D', 47, '7BC'),
(1, 'B', 47, 'CES'),
(3, 'B', 47, 'CES'),
(1, 'D', 47, 'OLU'),
(2, 'D', 47, 'OLU'),
(3, 'A', 47, 'OML'),
(2, 'B', 47, 'OML'),
(1, 'C', 47, 'OML'),
(3, 'C', 47, 'OML'),
(5, 'C', 47, 'OML'),
(1, 'D', 47, 'OML'),
(3, 'C', 47, 'TAT'),
(2, 'B', 47, 'TSO'),
(1, 'C', 47, 'TSO'),
(3, 'B', 48, '7BC'),
(4, 'C', 48, 'ATS'),
(2, 'D', 48, 'OLU'),
(2, 'B', 48, 'OML'),
(1, 'D', 48, 'OML'),
(3, 'B', 48, 'TAT'),
(1, 'A', 48, 'TSO'),
(2, 'B', 49, '714'),
(4, 'A', 49, 'CES'),
(3, 'B', 49, 'CES'),
(2, 'C', 49, 'CES'),
(3, 'C', 49, 'CES'),
(4, 'C', 49, 'CES'),
(1, 'A', 49, 'OLU'),
(2, 'B', 49, 'OLU'),
(3, 'B', 49, 'OLU'),
(1, 'C', 49, 'OLU'),
(2, 'C', 49, 'OLU'),
(3, 'C', 49, 'OLU'),
(1, 'D', 49, 'OML'),
(3, 'B', 49, 'TAT'),
(2, 'B', 49, 'TRR'),
(1, 'A', 49, 'TSO'),
(3, 'C', 50, '7BC'),
(1, 'D', 50, 'CES'),
(2, 'A', 50, 'OLU'),
(2, 'A', 50, 'OML'),
(1, 'A', 50, 'TAT'),
(4, 'C', 50, 'TSO'),
(2, 'A', 51, '714'),
(1, 'A', 51, '7BC'),
(1, 'B', 51, '7BC'),
(2, 'D', 51, 'OML'),
(1, 'A', 51, 'TAT'),
(2, 'B', 51, 'TAT'),
(3, 'B', 51, 'TAT'),
(2, 'D', 52, 'CES'),
(1, 'A', 52, 'OLU'),
(4, 'B', 52, 'OLU'),
(2, 'C', 52, 'OLU'),
(5, 'C', 52, 'OLU'),
(3, 'D', 52, 'OML'),
(3, 'A', 52, 'TAT'),
(1, 'C', 52, 'TRR'),
(4, 'C', 52, 'TRR'),
(1, 'A', 53, 'CPO'),
(2, 'B', 53, 'CPO'),
(2, 'C', 53, 'OLU'),
(2, 'D', 53, 'OLU'),
(2, 'B', 53, 'OML'),
(2, 'D', 53, 'SLI'),
(1, 'A', 53, 'TAT'),
(2, 'A', 53, 'TAT'),
(3, 'A', 53, 'TAT'),
(2, 'B', 54, '714'),
(3, 'A', 54, '7BC'),
(2, 'B', 54, '7BC'),
(4, 'B', 54, '7BC'),
(3, 'C', 54, '7BC'),
(3, 'A', 54, 'OLU'),
(2, 'B', 54, 'OML'),
(1, 'C', 54, 'OML'),
(2, 'C', 54, 'OML'),
(2, 'D', 54, 'OML'),
(3, 'D', 54, 'OML'),
(1, 'A', 54, 'SLI'),
(3, 'A', 54, 'SLI'),
(1, 'C', 54, 'SLI'),
(3, 'A', 54, 'TAT'),
(1, 'B', 54, 'TAT'),
(3, 'C', 54, 'TAT'),
(2, 'D', 54, 'TAT'),
(3, 'D', 55, '714'),
(1, 'A', 55, '7BC'),
(2, 'B', 55, '7BC'),
(3, 'B', 55, '7BC'),
(3, 'D', 55, 'CPO'),
(3, 'A', 55, 'OLU'),
(1, 'A', 55, 'OML'),
(4, 'A', 55, 'OML'),
(3, 'B', 55, 'OML'),
(2, 'C', 55, 'OML'),
(3, 'D', 55, 'OML'),
(2, 'B', 56, '714'),
(1, 'D', 56, '7BC'),
(1, 'D', 56, 'CES'),
(1, 'A', 56, 'CPO'),
(2, 'A', 56, 'CPO'),
(3, 'A', 56, 'CPO'),
(2, 'B', 56, 'CPO'),
(3, 'B', 56, 'CPO'),
(3, 'A', 56, 'OLU'),
(1, 'A', 56, 'OML'),
(1, 'B', 56, 'OML'),
(3, 'B', 56, 'OML'),
(2, 'A', 56, 'SLI'),
(1, 'D', 56, 'TSO'),
(1, 'B', 57, 'BCF'),
(2, 'B', 57, 'CPO'),
(3, 'D', 57, 'PON'),
(9, 'A', 58, '7BC'),
(1, 'B', 58, '7BC'),
(2, 'B', 58, '7BC'),
(1, 'C', 58, 'PON'),
(3, 'C', 58, 'PON'),
(1, 'A', 58, 'TAT'),
(2, 'A', 58, 'TAT'),
(2, 'B', 59, '7BC'),
(3, 'C', 59, '7BC'),
(2, 'D', 59, '7BC'),
(3, 'B', 59, 'BCF'),
(3, 'B', 59, 'OLU'),
(2, 'A', 59, 'PON'),
(3, 'A', 59, 'PON'),
(1, 'D', 60, '714'),
(4, 'A', 60, 'OLU'),
(1, 'A', 60, 'PON'),
(1, 'A', 60, 'TAT'),
(2, 'B', 60, 'TAT'),
(3, 'B', 60, 'TAT'),
(4, 'A', 61, '7BC'),
(4, 'D', 61, 'BCF'),
(1, 'B', 61, 'PON'),
(4, 'D', 61, 'PON'),
(2, 'A', 61, 'SLI'),
(2, 'B', 61, 'SLI'),
(3, 'A', 61, 'TSO'),
(2, 'A', 62, '7BC'),
(2, 'D', 62, 'EMY'),
(3, 'A', 62, 'OML'),
(3, 'C', 62, 'OML'),
(1, 'A', 62, 'PON'),
(2, 'A', 62, 'PON'),
(2, 'D', 62, 'PON'),
(3, 'B', 62, 'TAT');

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

--
-- Structure de la table `jurons`
--

DROP TABLE IF EXISTS `jurons`;
CREATE TABLE `jurons` (
  `jurons_num` int(11) NOT NULL,
  `jurons_texte` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `jurons`
--

INSERT INTO `jurons` (`jurons_num`, `jurons_texte`) VALUES
(1, 'accapareur'),
(2, ' amiral de bateau-lavoir'),
(3, 'amphitryon'),
(4, 'anacoluthe'),
(9, 'analphabète'),
(12, 'analphabète diplômé'),
(13, 'animal'),
(15, 'anthracite'),
(16, 'anthropophage'),
(19, 'anthropopithèque'),
(23, 'apache'),
(24, 'apophtegme'),
(25, 'apprenti-dictateur à la noix de coco'),
(26, 'arlequin'),
(27, 'ascenseur'),
(28, 'astronaute d\'eau douce'),
(29, 'athlète complet'),
(30, 'Au large !'),
(31, 'autocrate'),
(32, 'autodidacte'),
(33, 'Aztèques'),
(34, 'babouin'),
(35, 'bachi-bouzouk'),
(49, 'bachi-bouzouk de tonnerre de Brest'),
(52, 'bachi-bouzouk des Carpathes'),
(53, 'bande de jeunes effrontés'),
(54, 'bande de joyeux drilles'),
(55, 'bande d\'ectoplasmes de tonnerre de Brest'),
(56, 'bande d\'emplâtres'),
(57, 'bande d\'enragés'),
(58, 'bande d\'escrocs'),
(59, 'bande d\'hurluberlus'),
(60, 'bande de bachi-bouzouks'),
(61, 'bande de brutes'),
(62, 'bande de canaques'),
(64, 'bande de Ku-Klux-Klans'),
(65, 'bande de pirates'),
(66, 'bande de sauvages'),
(67, 'bande de voleurs'),
(68, 'bande de zapotèques de tonnerre de Brest'),
(69, 'bandit'),
(84, 'bayadère de carnaval'),
(85, 'bibelot'),
(86, 'bibendum'),
(87, 'bidule'),
(88, 'blague, fumisterie et compagnie'),
(89, 'boit-sans-soif'),
(93, 'bombe atomique'),
(95, 'bon sang'),
(96, 'bonhomme'),
(97, 'bougre (de...)'),
(99, 'bougre d\'ectoplasme à roulettes'),
(100, 'bougre d\'ectoplasme de moule à gaufres'),
(101, 'bougre d\'amiral de bateau-lavoir'),
(102, 'bougre de crème d\'emplâtre à la graisse de hérisson'),
(103, 'bougre d\'extrait de cornichon'),
(104, 'bougre d\'extrait de crétin des Alpes'),
(105, 'bougre d\'extrait d\'hydrocarbure'),
(106, 'bougre de faux jeton à la sauce tartare'),
(107, 'bougre de méchant Blanc'),
(108, 'bougre de mouchard'),
(109, 'bougre d\'olibrius'),
(111, 'bougre d\'ostrogoth'),
(112, 'bougre de papou des Carpathes'),
(113, 'bougre de petit cornichon'),
(114, 'bougre de phénomène de tonnerre de Brest'),
(115, 'bougre de phénomène de moule à gaufres de tonnerre de Brest'),
(116, 'bougre de sauvage d\'aérolithe de tonnerre de Brest'),
(117, 'bougre de zouave'),
(118, 'bougres de zouaves d\'anthropopithèques'),
(119, 'brigand'),
(121, 'brontosaure'),
(122, 'brute'),
(130, 'bulldozer à réaction'),
(131, 'cachalot'),
(132, 'cake-walk'),
(133, 'calembredaine'),
(134, 'canaille'),
(139, 'Canaque'),
(142, 'cannibale'),
(148, 'cannibale emplumé'),
(149, 'capitaine de bateau lavoir'),
(150, 'casse-pieds'),
(153, 'catachrèse'),
(156, 'cataplasme'),
(157, 'cercopithèque'),
(158, 'cercueil volant'),
(160, 'chauffard'),
(164, 'chenapan'),
(166, 'cher petit ami'),
(167, 'choléra'),
(168, 'chouette mal empaillée'),
(169, 'chrysanthème'),
(170, 'cigare volant'),
(172, 'cloche à fromage'),
(173, 'cloporte'),
(176, 'clown'),
(178, 'clysopompe'),
(179, 'coléoptère'),
(182, 'coloquinte'),
(185, 'coloquinte à la graisse de hérisson'),
(186, 'concentré de moule à gaufres'),
(187, 'coquin'),
(188, 'cornemuse'),
(189, 'cornichon'),
(200, 'cornichon de zouave de tonnerre de Brest'),
(201, 'cornichon diplômé'),
(202, 'corsaire'),
(203, 'coup de Trafalgar'),
(204, 'coupe-jarret'),
(205, 'cow-boy de la route'),
(206, 'crème d\'emplâtre à la graisse de hérisson'),
(207, 'crétin de l\'Himalaya'),
(208, 'crétin des Alpes'),
(210, 'crétin des Balkans'),
(211, 'commerce noir'),
(212, 'cromagnon'),
(213, 'cuistre'),
(214, 'cyanure'),
(215, 'cyclone'),
(216, 'cyclone ambulant'),
(217, 'cyclotron'),
(218, 'Cyrano à quatre pattes'),
(219, 'diable'),
(221, 'diable de —'),
(222, 'diable de zouave'),
(223, 'diable les emporte (le -)'),
(224, 'diable vous étripatouille (que le -)'),
(225, 'diablesse'),
(226, 'Dieu soit loué'),
(227, 'diplodocus'),
(229, 'doryphore'),
(233, 'doux agneaux'),
(234, 'dynamiteur'),
(235, 'écornifleur'),
(236, 'écraseur'),
(241, 'Ectoplasme'),
(257, 'ectoplasme à roulettes'),
(258, 'égoïste'),
(259, 'électron (travailler de l\'—)'),
(260, 'emplâtre'),
(265, 'emplâtré à la graisse de hérisson'),
(266, 'empoisonneur'),
(267, 'encordé vous-même'),
(268, 'énergumène'),
(269, 'enfer et damnation'),
(270, 'enfonceur de porte ouverte'),
(271, 'enragé'),
(272, 'épouvantail'),
(273, 'équilibriste'),
(274, 'esclavagiste'),
(275, 'escogriffe'),
(276, 'escroc'),
(277, 'espèce de...'),
(278, 'espèce de loup-garou à la graisse de renoncule de mille sabords'),
(279, 'espèce de porc-épic mal embouché'),
(280, 'espèce de mitrailleur à bavette'),
(281, 'entêté'),
(282, 'extrait d\'emplâtre'),
(283, 'extrait d\'hydrocarbure'),
(284, 'extrait de cornichon'),
(285, 'face de brute'),
(286, 'farceur'),
(287, 'fatma de prisunic'),
(288, 'faux frère'),
(289, 'faux jeton'),
(290, 'faux jeton à la sauce tartare '),
(291, 'fichu –'),
(292, 'fieffé menteur'),
(293, 'fiston'),
(296, 'flibustier'),
(302, 'flibustier de carnaval'),
(303, 'flûte'),
(304, 'forban'),
(310, 'fourbe'),
(311, 'Frère de la côte'),
(312, 'froussard'),
(313, 'gaillard'),
(318, 'galopin'),
(319, 'gamin'),
(320, 'gangster'),
(322, 'garde-côtes à la mie de pain'),
(323, 'gargarisme'),
(324, 'garnement'),
(325, 'gibier de potence'),
(326, 'goujat'),
(327, 'graine de vaurien'),
(328, 'graisse de hérisson (à la – )'),
(329, 'graisse de trombone à coulisse (à la – )'),
(330, 'grand escogriffe'),
(332, 'grand lâche'),
(334, 'gredin'),
(341, 'grenouille'),
(342, 'gros-plein-de-soupe'),
(343, 'grotesque polichinelle'),
(344, 'gyroscope'),
(345, 'hérétique'),
(346, 'hors-la-loi'),
(347, 'hurluberlu'),
(348, 'hydrocarbure'),
(349, 'iconoclaste'),
(357, 'Inca de carnaval'),
(358, 'individou16 de général de tonnerre de Brest'),
(359, 'invertébré'),
(360, 'isotope'),
(361, 'ivrogne'),
(362, 'jet d\'eau ambulant'),
(363, 'jeune chenapan'),
(364, 'jeune impertinent'),
(365, 'jocrisse'),
(366, 'judas'),
(369, 'jus de réglisse'),
(370, 'Khroumir'),
(371, 'KRRTCHMVRTZ'),
(372, 'Ku Klux Klan'),
(373, 'Kanak'),
(374, 'lâche'),
(375, 'lascar'),
(376, 'lépidoptère'),
(377, 'logarithme'),
(378, 'loup-garou à la graisse de renoncule de mille tonnerres de Brest'),
(379, 'maboul'),
(380, 'macaque'),
(381, 'macrocéphale'),
(382, 'malappris'),
(383, 'malheur (– de –)'),
(384, 'malheureux, -se'),
(386, 'malotru'),
(387, 'Mamelouk'),
(388, 'marchand de guano'),
(389, 'marchand de tapis'),
(390, 'marin d\'eau douce'),
(394, 'marmotte mal réveillée'),
(395, 'maudit(e) —'),
(396, 'mazette'),
(397, 'mégacycle'),
(398, 'mégalomane'),
(399, 'mercanti	'),
(400, 'mercenaire'),
(401, 'mérinos'),
(402, 'mérinos mal peignés'),
(403, 'migou de malheur'),
(404, 'mille milliards de...'),
(405, 'mille milliards de mille millions de mille sabords'),
(408, 'mille milliards de mille sabords'),
(418, 'mille milliards de mille sabords de tonnerre de Brest'),
(421, 'mille milliards de tonnerre de Brest'),
(422, 'mille millions de mille milliards de mille sabords'),
(427, 'mille millions de mille milliards de mille sabords de tonnerre de Brest'),
(428, 'mille millions de mille sabords'),
(460, 'mille millions de mille sabords de tonnerre de Brest'),
(462, 'mille millions de sabords'),
(463, 'mille millions de tonnerres de Brest'),
(466, 'mille sabords'),
(559, 'mille tonnerres'),
(568, 'mille tonnerres de Brest'),
(571, 'milliards de...'),
(572, 'misérable'),
(578, 'misérable ectoplasme'),
(579, 'misérable ver de terre'),
(580, 'mitrailleur à bavette'),
(581, 'moratorium'),
(582, 'moricaud'),
(583, 'morues dans un carton à chapeau'),
(584, 'mouchard'),
(585, 'moujik'),
(586, 'moule à gaufres '),
(596, 'moussaillon'),
(606, 'moussaillon de malheur'),
(607, 'moussaillon du diable'),
(608, 'mufle'),
(609, 'MRKRPXZKRMTFRZ'),
(610, 'Mussolini de carnaval'),
(611, 'naufrageur'),
(614, 'négrier'),
(616, 'noix de coco'),
(617, 'nom d\'une pipe'),
(618, 'nyctalope'),
(619, 'olibrius '),
(624, 'ophicléide'),
(626, 'ornithorynque '),
(627, 'oryctérope'),
(629, 'ostrogoth'),
(631, 'ours mal léché'),
(632, 'Pachyderme'),
(633, 'pacte à quatre'),
(634, 'paltoquet'),
(635, 'pantoufle'),
(636, 'papou'),
(637, 'papou des Carpathes '),
(638, 'paranoïaque'),
(639, 'parasites'),
(641, 'Patagon'),
(642, 'patagon de zoulou'),
(643, 'patapouf'),
(644, 'patate'),
(645, 'pauvre bougre'),
(646, 'pauvre type'),
(647, 'peau-rouge'),
(648, 'pénultième'),
(649, 'père volant'),
(650, 'péronnelle'),
(651, 'perruche bavarde (vieille –)'),
(652, 'perroquet déplumé'),
(653, 'petit choléra'),
(654, 'petit délicat'),
(655, 'petit ornithorynque'),
(656, 'petite tigresse'),
(657, 'petit vaurien'),
(658, 'phénomène'),
(662, 'phlébotome'),
(663, 'phylactère'),
(664, 'phylloxéra'),
(666, 'pignouf'),
(667, 'pirate'),
(682, 'pirate d\'eau douce'),
(683, 'pirate du ciel'),
(684, 'plein le dos'),
(685, 'pleurnichard'),
(686, 'polichinelle'),
(687, 'polygraphe'),
(688, 'porc-épic mal embouché'),
(689, 'potentat'),
(690, 'poussière'),
(691, 'profiteur'),
(692, 'projectile guidé'),
(693, 'protozoaire'),
(694, 'pyromane'),
(695, 'pyrophore'),
(696, 'que diable'),
(697, 'que le grand cric me croque et me fasse avaler ma barbe'),
(698, 'rapace'),
(699, 'rat'),
(700, 'ravachol'),
(702, 'renégat'),
(703, 'rhizopode'),
(704, 'rocaille de tonnerre de Brest'),
(705, 'rocambole'),
(706, 'sacr... fichue —'),
(707, 'sacré mitrailleur à bavette'),
(709, 'sacripant'),
(710, 'sajou'),
(711, 'sale bête'),
(712, 'saleté d\'appareil à sous'),
(713, 'sale vilaine bête de tonnerre de Brest'),
(714, 'saltimbanque'),
(715, 'sapajou'),
(719, 'sapristi'),
(720, 'satané'),
(723, 'satrape'),
(725, 'sauvage'),
(728, 'sauvage d\'aérolithe'),
(729, 'scélérat'),
(731, 'schizophrène'),
(732, 'scolopendre'),
(733, 'scorpion'),
(734, 'serpent'),
(735, 'simili-Martien à la graisse de cabestan'),
(736, 'sinapisme'),
(737, 'sinistre farceur'),
(738, 'sombre brute'),
(739, 'sombre oryctérope'),
(740, 'soulographe'),
(741, 'sous-produit d\'ectoplasme'),
(742, 'tas de cornichons'),
(743, 'tas de sauvages'),
(746, 'tchouk-tchouk-nougat'),
(748, 'technocrate'),
(749, 'terroriste'),
(750, 'tête de lard'),
(751, 'tête de mule'),
(754, 'têtu comme une mule'),
(755, 'tigresse'),
(756, 'tonnerre'),
(763, 'tonnerre de Brest'),
(835, 'tonnerre de tonnerre de Brest'),
(846, 'topinambour'),
(847, 'tortionnaire'),
(849, 'trafiquant de chair humaine'),
(850, 'traîne-potence'),
(851, 'traître'),
(853, 'tricheur'),
(854, 'troglodyte'),
(857, 'trompe-la-mort'),
(859, 'troufignol'),
(860, 'vampire'),
(864, 'vandale'),
(865, 'va-nu-pieds'),
(871, 'vaurien'),
(872, 'végétarien'),
(873, 'ver de terre'),
(874, 'Vercingétorix de carnaval'),
(875, 'vermicelles'),
(876, 'vermine'),
(877, 'vieille baderne'),
(878, 'vieille branche'),
(879, 'vieille coque rouillée'),
(880, 'vieille marmotte'),
(881, 'vieille perruche bavarde'),
(882, 'vieux farceur'),
(883, 'vieux frère'),
(884, 'vieux rafiot que je suis'),
(885, 'vipère'),
(887, 'vivisectionniste'),
(888, 'volatile de malheur'),
(889, 'voleur'),
(890, 'voleur d\'enfants'),
(891, 'Wisigoths'),
(892, 'Zapotèques'),
(893, 'zèbre'),
(895, 'zigomar'),
(896, 'zouave'),
(909, 'zouave interplanétaire'),
(910, 'zouave à la noix de coco'),
(911, 'Zoulou');

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

--
-- Structure de la table `page`
--

DROP TABLE IF EXISTS `page`;
CREATE TABLE `page` (
  `page_num` int(11) NOT NULL,
  `ref_album` varchar(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `page`
--

INSERT INTO `page` (`page_num`, `ref_album`) VALUES
(1, '714'),
(2, '714'),
(3, '714'),
(7, '714'),
(10, '714'),
(11, '714'),
(12, '714'),
(14, '714'),
(18, '714'),
(21, '714'),
(22, '714'),
(23, '714'),
(27, '714'),
(29, '714'),
(34, '714'),
(35, '714'),
(36, '714'),
(39, '714'),
(42, '714'),
(44, '714'),
(45, '714'),
(49, '714'),
(51, '714'),
(54, '714'),
(55, '714'),
(56, '714'),
(60, '714'),
(6, '7BC'),
(7, '7BC'),
(14, '7BC'),
(27, '7BC'),
(29, '7BC'),
(34, '7BC'),
(35, '7BC'),
(40, '7BC'),
(42, '7BC'),
(43, '7BC'),
(45, '7BC'),
(47, '7BC'),
(48, '7BC'),
(50, '7BC'),
(51, '7BC'),
(54, '7BC'),
(55, '7BC'),
(56, '7BC'),
(58, '7BC'),
(59, '7BC'),
(61, '7BC'),
(62, '7BC'),
(3, 'ATS'),
(4, 'ATS'),
(11, 'ATS'),
(14, 'ATS'),
(15, 'ATS'),
(19, 'ATS'),
(20, 'ATS'),
(22, 'ATS'),
(28, 'ATS'),
(32, 'ATS'),
(33, 'ATS'),
(34, 'ATS'),
(36, 'ATS'),
(42, 'ATS'),
(44, 'ATS'),
(46, 'ATS'),
(48, 'ATS'),
(1, 'BCF'),
(2, 'BCF'),
(5, 'BCF'),
(6, 'BCF'),
(7, 'BCF'),
(8, 'BCF'),
(10, 'BCF'),
(12, 'BCF'),
(13, 'BCF'),
(14, 'BCF'),
(18, 'BCF'),
(19, 'BCF'),
(21, 'BCF'),
(22, 'BCF'),
(24, 'BCF'),
(25, 'BCF'),
(26, 'BCF'),
(27, 'BCF'),
(28, 'BCF'),
(30, 'BCF'),
(36, 'BCF'),
(38, 'BCF'),
(40, 'BCF'),
(41, 'BCF'),
(44, 'BCF'),
(57, 'BCF'),
(59, 'BCF'),
(61, 'BCF'),
(1, 'CES'),
(4, 'CES'),
(5, 'CES'),
(6, 'CES'),
(7, 'CES'),
(9, 'CES'),
(14, 'CES'),
(16, 'CES'),
(26, 'CES'),
(33, 'CES'),
(35, 'CES'),
(38, 'CES'),
(41, 'CES'),
(44, 'CES'),
(46, 'CES'),
(47, 'CES'),
(49, 'CES'),
(50, 'CES'),
(52, 'CES'),
(56, 'CES'),
(20, 'CPO'),
(22, 'CPO'),
(25, 'CPO'),
(30, 'CPO'),
(36, 'CPO'),
(37, 'CPO'),
(38, 'CPO'),
(41, 'CPO'),
(53, 'CPO'),
(55, 'CPO'),
(56, 'CPO'),
(57, 'CPO'),
(9, 'EMY'),
(16, 'EMY'),
(17, 'EMY'),
(19, 'EMY'),
(20, 'EMY'),
(21, 'EMY'),
(25, 'EMY'),
(26, 'EMY'),
(27, 'EMY'),
(30, 'EMY'),
(32, 'EMY'),
(34, 'EMY'),
(35, 'EMY'),
(36, 'EMY'),
(37, 'EMY'),
(38, 'EMY'),
(40, 'EMY'),
(41, 'EMY'),
(43, 'EMY'),
(62, 'EMY'),
(1, 'OLU'),
(2, 'OLU'),
(3, 'OLU'),
(4, 'OLU'),
(5, 'OLU'),
(6, 'OLU'),
(7, 'OLU'),
(8, 'OLU'),
(9, 'OLU'),
(10, 'OLU'),
(11, 'OLU'),
(12, 'OLU'),
(18, 'OLU'),
(26, 'OLU'),
(30, 'OLU'),
(31, 'OLU'),
(32, 'OLU'),
(34, 'OLU'),
(36, 'OLU'),
(38, 'OLU'),
(39, 'OLU'),
(40, 'OLU'),
(43, 'OLU'),
(44, 'OLU'),
(46, 'OLU'),
(47, 'OLU'),
(48, 'OLU'),
(49, 'OLU'),
(50, 'OLU'),
(52, 'OLU'),
(53, 'OLU'),
(54, 'OLU'),
(55, 'OLU'),
(56, 'OLU'),
(59, 'OLU'),
(60, 'OLU'),
(2, 'OML'),
(3, 'OML'),
(4, 'OML'),
(6, 'OML'),
(8, 'OML'),
(10, 'OML'),
(11, 'OML'),
(12, 'OML'),
(13, 'OML'),
(15, 'OML'),
(18, 'OML'),
(20, 'OML'),
(26, 'OML'),
(27, 'OML'),
(28, 'OML'),
(29, 'OML'),
(31, 'OML'),
(33, 'OML'),
(34, 'OML'),
(36, 'OML'),
(38, 'OML'),
(42, 'OML'),
(43, 'OML'),
(44, 'OML'),
(45, 'OML'),
(46, 'OML'),
(47, 'OML'),
(48, 'OML'),
(49, 'OML'),
(50, 'OML'),
(51, 'OML'),
(52, 'OML'),
(53, 'OML'),
(54, 'OML'),
(55, 'OML'),
(56, 'OML'),
(62, 'OML'),
(1, 'PIC'),
(2, 'PIC'),
(6, 'PIC'),
(8, 'PIC'),
(9, 'PIC'),
(10, 'PIC'),
(11, 'PIC'),
(15, 'PIC'),
(17, 'PIC'),
(18, 'PIC'),
(19, 'PIC'),
(22, 'PIC'),
(23, 'PIC'),
(31, 'PIC'),
(42, 'PIC'),
(57, 'PON'),
(58, 'PON'),
(59, 'PON'),
(60, 'PON'),
(61, 'PON'),
(62, 'PON'),
(5, 'SLI'),
(14, 'SLI'),
(19, 'SLI'),
(20, 'SLI'),
(29, 'SLI'),
(31, 'SLI'),
(32, 'SLI'),
(45, 'SLI'),
(53, 'SLI'),
(54, 'SLI'),
(56, 'SLI'),
(61, 'SLI'),
(1, 'TAT'),
(3, 'TAT'),
(4, 'TAT'),
(5, 'TAT'),
(6, 'TAT'),
(9, 'TAT'),
(11, 'TAT'),
(13, 'TAT'),
(14, 'TAT'),
(15, 'TAT'),
(16, 'TAT'),
(17, 'TAT'),
(18, 'TAT'),
(24, 'TAT'),
(25, 'TAT'),
(26, 'TAT'),
(27, 'TAT'),
(28, 'TAT'),
(32, 'TAT'),
(34, 'TAT'),
(35, 'TAT'),
(36, 'TAT'),
(37, 'TAT'),
(38, 'TAT'),
(40, 'TAT'),
(41, 'TAT'),
(42, 'TAT'),
(47, 'TAT'),
(48, 'TAT'),
(49, 'TAT'),
(50, 'TAT'),
(51, 'TAT'),
(52, 'TAT'),
(53, 'TAT'),
(54, 'TAT'),
(58, 'TAT'),
(60, 'TAT'),
(62, 'TAT'),
(2, 'TRR'),
(3, 'TRR'),
(4, 'TRR'),
(5, 'TRR'),
(7, 'TRR'),
(8, 'TRR'),
(9, 'TRR'),
(11, 'TRR'),
(12, 'TRR'),
(16, 'TRR'),
(17, 'TRR'),
(18, 'TRR'),
(19, 'TRR'),
(20, 'TRR'),
(23, 'TRR'),
(28, 'TRR'),
(29, 'TRR'),
(30, 'TRR'),
(31, 'TRR'),
(32, 'TRR'),
(35, 'TRR'),
(37, 'TRR'),
(41, 'TRR'),
(43, 'TRR'),
(45, 'TRR'),
(49, 'TRR'),
(52, 'TRR'),
(2, 'TSO'),
(3, 'TSO'),
(4, 'TSO'),
(5, 'TSO'),
(30, 'TSO'),
(32, 'TSO'),
(33, 'TSO'),
(36, 'TSO'),
(38, 'TSO'),
(46, 'TSO'),
(47, 'TSO'),
(48, 'TSO'),
(49, 'TSO'),
(50, 'TSO'),
(56, 'TSO'),
(61, 'TSO');

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

--
-- Structure de la table `se_trouver_bulle`
--

DROP TABLE IF EXISTS `se_trouver_bulle`;
CREATE TABLE `se_trouver_bulle` (
  `num_case` int(11) NOT NULL,
  `num_page` int(11) NOT NULL,
  `place_bande` varchar(1) NOT NULL,
  `ref_album` varchar(5) NOT NULL,
  `jurons_num` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `se_trouver_bulle`
--

INSERT INTO `se_trouver_bulle` (`num_case`, `num_page`, `place_bande`, `ref_album`, `jurons_num`) VALUES
(1, 30, 'A', 'EMY', 1),
(1, 38, 'A', 'CES', 2),
(2, 26, 'C', 'TAT', 3),
(1, 46, 'B', 'OML', 4),
(1, 46, 'C', 'OLU', 4),
(2, 46, 'D', 'CES', 4),
(2, 57, 'B', 'CPO', 4),
(3, 57, 'D', 'PON', 4),
(1, 43, 'A', '7BC', 9),
(1, 58, 'B', '7BC', 9),
(3, 20, 'D', 'TRR', 9),
(1, 52, 'C', 'TRR', 12),
(2, 11, 'D', 'ATS', 13),
(2, 52, 'D', 'CES', 13),
(3, 36, 'B', 'ATS', 16),
(3, 37, 'A', 'TAT', 16),
(4, 45, 'A', 'OML', 16),
(1, 47, 'C', 'TSO', 19),
(2, 56, 'B', 'CPO', 19),
(3, 47, 'A', 'OML', 19),
(6, 26, 'D', 'TAT', 19),
(2, 23, 'A', '714', 23),
(1, 10, 'C', 'PIC', 25),
(2, 56, 'A', 'CPO', 26),
(2, 51, 'B', 'TAT', 27),
(3, 52, 'D', 'OML', 28),
(4, 52, 'C', 'TRR', 29),
(3, 38, 'A', 'TSO', 30),
(3, 34, 'C', 'ATS', 31),
(3, 22, 'A', 'ATS', 32),
(3, 37, 'D', 'CPO', 33),
(1, 30, 'D', 'TRR', 34),
(1, 4, 'C', 'OLU', 35),
(1, 36, 'C', 'ATS', 35),
(1, 47, 'C', '7BC', 35),
(2, 7, 'D', 'TRR', 35),
(2, 10, 'B', 'BCF', 35),
(2, 38, 'A', 'CPO', 35),
(2, 56, 'A', 'SLI', 35),
(3, 16, 'A', 'CES', 35),
(3, 25, 'A', 'TAT', 35),
(3, 49, 'B', 'CES', 35),
(3, 54, 'A', 'OLU', 35),
(3, 57, 'D', 'PON', 35),
(4, 43, 'C', 'TRR', 35),
(5, 23, 'A', '714', 35),
(2, 31, 'C', 'OML', 49),
(4, 4, 'C', 'OML', 49),
(5, 47, 'C', 'OML', 49),
(1, 42, 'D', 'ATS', 52),
(3, 53, 'A', 'TAT', 53),
(3, 47, 'C', 'TAT', 54),
(2, 21, 'C', '714', 55),
(1, 27, 'C', 'TAT', 56),
(1, 56, 'D', 'TSO', 57),
(1, 5, 'A', 'TRR', 58),
(1, 14, 'A', 'ATS', 59),
(3, 11, 'A', 'TAT', 60),
(1, 18, 'B', '714', 61),
(1, 5, 'D', 'OLU', 62),
(1, 47, 'C', '7BC', 62),
(1, 12, 'A', 'OLU', 64),
(3, 3, 'C', 'OLU', 65),
(1, 47, 'C', 'TSO', 66),
(1, 30, 'A', 'EMY', 67),
(1, 11, 'B', 'PIC', 68),
(1, 31, 'C', 'SLI', 69),
(1, 34, 'B', '714', 69),
(1, 53, 'A', 'CPO', 69),
(1, 54, 'C', 'SLI', 69),
(2, 22, 'A', 'PIC', 69),
(2, 23, 'A', '714', 69),
(2, 55, 'B', '7BC', 69),
(2, 62, 'A', '7BC', 69),
(3, 16, 'B', 'EMY', 69),
(3, 26, 'A', 'OLU', 69),
(3, 36, 'B', 'ATS', 69),
(3, 40, 'D', 'EMY', 69),
(3, 46, 'B', 'OML', 69),
(3, 59, 'A', 'PON', 69),
(3, 59, 'C', '7BC', 69),
(1, 26, 'A', 'CES', 84),
(2, 43, 'A', 'OLU', 85),
(3, 35, 'D', 'CES', 86),
(3, 45, 'C', '714', 87),
(1, 2, 'D', 'OML', 88),
(2, 26, 'D', 'TAT', 89),
(2, 53, 'D', 'SLI', 89),
(3, 32, 'A', 'TAT', 89),
(3, 49, 'B', 'CES', 89),
(1, 58, 'A', 'TAT', 93),
(2, 58, 'A', 'TAT', 93),
(3, 55, 'A', 'OLU', 95),
(4, 41, 'A', 'BCF', 96),
(1, 19, 'C', 'PIC', 97),
(1, 23, 'A', 'PIC', 97),
(1, 50, 'D', 'CES', 99),
(2, 54, 'B', '714', 100),
(1, 38, 'A', 'CES', 101),
(3, 33, 'B', 'ATS', 102),
(1, 4, 'D', 'CES', 103),
(3, 41, 'A', 'TRR', 104),
(2, 27, 'C', 'BCF', 105),
(1, 42, 'D', 'ATS', 106),
(3, 47, 'B', 'CES', 107),
(2, 52, 'D', 'CES', 108),
(1, 8, 'A', 'TRR', 109),
(2, 49, 'B', 'TRR', 109),
(3, 36, 'C', 'BCF', 111),
(1, 19, 'D', 'ATS', 112),
(1, 58, 'C', 'PON', 113),
(2, 9, 'A', 'CES', 115),
(3, 36, 'B', 'ATS', 116),
(2, 27, 'C', '714', 117),
(2, 36, 'A', 'TSO', 118),
(2, 30, 'A', 'EMY', 119),
(3, 42, 'D', '714', 119),
(4, 3, 'C', 'OML', 121),
(1, 22, 'A', 'ATS', 122),
(1, 22, 'A', 'CPO', 122),
(1, 43, 'C', 'OLU', 122),
(1, 45, 'A', '7BC', 122),
(2, 32, 'C', 'TRR', 122),
(2, 53, 'B', 'CPO', 122),
(2, 55, 'B', '7BC', 122),
(3, 57, 'D', 'PON', 122),
(2, 60, 'B', 'TAT', 130),
(1, 11, 'C', 'OML', 132),
(2, 44, 'B', '714', 133),
(1, 22, 'A', 'CPO', 134),
(1, 37, 'D', 'CPO', 134),
(2, 45, 'A', '7BC', 134),
(2, 45, 'B', '7BC', 134),
(5, 23, 'A', '714', 134),
(1, 12, 'A', 'OLU', 139),
(1, 29, 'A', 'TRR', 139),
(3, 56, 'A', 'CPO', 139),
(1, 29, 'A', 'TRR', 142),
(1, 55, 'A', 'OML', 142),
(2, 10, 'B', 'BCF', 142),
(2, 26, 'C', 'TAT', 142),
(2, 56, 'B', 'CPO', 142),
(8, 42, 'B', 'PIC', 142),
(1, 49, 'A', 'TSO', 148),
(1, 27, 'A', 'BCF', 150),
(2, 26, 'C', 'BCF', 150),
(4, 61, 'D', 'BCF', 150),
(2, 19, 'C', 'BCF', 153),
(3, 40, 'D', 'EMY', 153),
(4, 23, 'A', '714', 153),
(1, 54, 'A', 'SLI', 156),
(3, 49, 'B', 'CES', 157),
(3, 16, 'B', 'CES', 158),
(3, 62, 'C', 'OML', 158),
(2, 55, 'B', '7BC', 160),
(2, 56, 'A', 'SLI', 160),
(3, 26, 'A', 'EMY', 160),
(4, 43, 'C', 'OLU', 160),
(2, 19, 'B', 'SLI', 164),
(2, 38, 'A', 'CPO', 164),
(1, 36, 'B', '714', 166),
(2, 14, 'B', 'CES', 167),
(2, 30, 'A', 'TSO', 168),
(2, 53, 'C', 'OLU', 170),
(4, 8, 'C', 'OML', 170),
(1, 34, 'C', 'OML', 172),
(2, 19, 'B', 'SLI', 173),
(2, 29, 'A', 'SLI', 173),
(3, 40, 'D', 'EMY', 173),
(2, 18, 'C', 'OML', 176),
(3, 56, 'B', 'OML', 176),
(1, 47, 'D', 'OML', 179),
(2, 29, 'A', 'SLI', 179),
(4, 48, 'C', 'ATS', 179),
(1, 29, 'B', 'SLI', 182),
(1, 30, 'A', 'EMY', 182),
(5, 26, 'D', 'TAT', 182),
(1, 47, 'B', 'CES', 185),
(3, 43, 'B', 'OML', 186),
(3, 14, 'A', 'SLI', 188),
(1, 8, 'A', 'BCF', 189),
(1, 29, 'A', 'SLI', 189),
(1, 43, 'A', '7BC', 189),
(1, 46, 'D', 'CES', 189),
(2, 14, 'A', 'SLI', 189),
(3, 5, 'C', 'OLU', 189),
(3, 39, 'A', 'OLU', 189),
(3, 46, 'A', 'OLU', 189),
(3, 55, 'B', '7BC', 189),
(3, 59, 'B', 'OLU', 189),
(4, 43, 'C', 'TRR', 189),
(3, 11, 'D', 'OLU', 200),
(3, 28, 'D', 'ATS', 201),
(1, 56, 'A', 'CPO', 202),
(1, 40, 'A', 'OLU', 203),
(4, 49, 'A', 'CES', 204),
(2, 11, 'D', 'ATS', 205),
(1, 20, 'C', 'OML', 206),
(2, 24, 'D', 'TAT', 207),
(1, 58, 'B', '7BC', 208),
(3, 20, 'D', 'TRR', 208),
(1, 20, 'A', 'ATS', 210),
(1, 26, 'C', 'TAT', 212),
(3, 26, 'D', 'TAT', 214),
(2, 56, 'A', 'SLI', 215),
(3, 7, 'C', 'BCF', 216),
(1, 43, 'C', 'OLU', 217),
(1, 38, 'A', 'TSO', 218),
(1, 31, 'B', 'OLU', 219),
(4, 34, 'C', 'OLU', 219),
(1, 30, 'D', 'CPO', 221),
(1, 28, 'C', 'BCF', 223),
(1, 44, 'A', 'CES', 224),
(3, 2, 'C', 'BCF', 225),
(1, 20, 'C', 'TRR', 226),
(0, 35, 'D', '714', 227),
(1, 26, 'D', 'TAT', 227),
(1, 48, 'A', 'TSO', 229),
(2, 30, 'A', 'TSO', 229),
(2, 38, 'A', 'CPO', 229),
(2, 56, 'B', 'CPO', 229),
(1, 47, 'C', 'OML', 233),
(2, 16, 'C', 'EMY', 234),
(1, 54, 'C', 'SLI', 235),
(1, 43, 'C', 'OLU', 236),
(2, 55, 'B', '7BC', 236),
(2, 56, 'A', 'SLI', 236),
(3, 22, 'A', 'ATS', 236),
(7, 36, 'B', 'ATS', 236),
(1, 27, 'A', 'TAT', 241),
(1, 36, 'C', 'ATS', 241),
(1, 41, 'A', 'EMY', 241),
(1, 43, 'A', '7BC', 241),
(1, 48, 'A', 'TSO', 241),
(2, 26, 'C', 'TAT', 241),
(2, 38, 'A', 'CPO', 241),
(2, 58, 'B', '7BC', 241),
(3, 4, 'C', 'OLU', 241),
(3, 5, 'C', 'OLU', 241),
(3, 28, 'D', 'TRR', 241),
(3, 35, 'D', 'CES', 241),
(3, 56, 'B', 'OML', 241),
(3, 57, 'D', 'PON', 241),
(4, 32, 'C', 'ATS', 241),
(4, 43, 'C', 'TRR', 241),
(4, 34, 'B', 'ATS', 258),
(2, 10, 'A', 'OLU', 259),
(1, 29, 'B', 'SLI', 260),
(1, 37, 'D', 'CPO', 260),
(2, 12, 'B', 'OML', 260),
(2, 56, 'B', 'CPO', 260),
(3, 43, 'C', 'TRR', 260),
(1, 2, 'D', 'OLU', 266),
(2, 38, 'D', 'TAT', 267),
(1, 26, 'B', 'EMY', 268),
(1, 18, 'D', 'TRR', 269),
(1, 11, 'A', 'TAT', 273),
(3, 54, 'A', 'SLI', 275),
(1, 13, 'B', 'BCF', 277),
(2, 25, 'D', 'CPO', 281),
(1, 49, 'C', 'OLU', 282),
(1, 15, 'A', 'PIC', 285),
(2, 51, 'D', 'OML', 288),
(1, 46, 'B', 'OML', 289),
(5, 32, 'C', 'OLU', 291),
(1, 9, 'C', 'PIC', 292),
(1, 24, 'C', 'TAT', 293),
(2, 13, 'D', 'TAT', 293),
(5, 40, 'C', 'TAT', 293),
(1, 44, 'A', 'CES', 296),
(3, 14, 'A', 'SLI', 296),
(3, 22, 'A', 'ATS', 296),
(3, 26, 'A', 'EMY', 296),
(3, 55, 'D', 'CPO', 296),
(6, 26, 'D', 'TAT', 296),
(2, 4, 'D', 'TRR', 302),
(2, 54, 'B', 'OML', 303),
(1, 14, 'A', 'SLI', 304),
(1, 41, 'C', 'EMY', 304),
(2, 11, 'A', 'PIC', 304),
(2, 19, 'B', 'SLI', 304),
(3, 42, 'A', 'ATS', 304),
(4, 27, 'D', 'EMY', 304),
(2, 8, 'D', 'PIC', 310),
(1, 44, 'A', 'CES', 311),
(3, 38, 'A', 'CPO', 312),
(1, 15, 'A', 'TAT', 313),
(1, 17, 'B', 'TAT', 313),
(1, 57, 'B', 'BCF', 313),
(2, 21, 'B', 'BCF', 313),
(4, 43, 'A', '7BC', 313),
(1, 14, 'D', 'TAT', 318),
(3, 49, 'B', 'TAT', 319),
(1, 31, 'C', 'SLI', 320),
(3, 7, 'B', 'OLU', 320),
(3, 33, 'B', 'CES', 322),
(1, 29, 'B', 'SLI', 323),
(3, 59, 'C', '7BC', 324),
(3, 6, 'B', 'CES', 327),
(3, 43, 'B', 'OML', 328),
(2, 6, 'B', 'PIC', 329),
(2, 60, 'B', 'TAT', 330),
(3, 3, 'A', '714', 330),
(1, 20, 'C', 'SLI', 332),
(1, 48, 'A', 'TSO', 332),
(1, 31, 'C', 'SLI', 334),
(1, 36, 'B', 'CPO', 334),
(1, 43, 'A', '7BC', 334),
(2, 14, 'B', 'CES', 334),
(2, 54, 'D', 'OML', 334),
(3, 26, 'A', 'OLU', 334),
(4, 16, 'C', 'EMY', 334),
(3, 37, 'D', 'CPO', 341),
(3, 34, 'C', 'ATS', 342),
(3, 10, 'D', 'PIC', 343),
(3, 56, 'A', 'CPO', 344),
(3, 26, 'A', 'EMY', 346),
(3, 56, 'A', 'OLU', 347),
(2, 56, 'A', 'CPO', 348),
(1, 29, 'A', 'TRR', 349),
(2, 46, 'B', 'CES', 349),
(2, 55, 'C', 'OML', 349),
(3, 29, 'C', 'TRR', 349),
(3, 37, 'D', 'CPO', 349),
(3, 54, 'A', '7BC', 349),
(3, 56, 'B', 'CPO', 349),
(3, 59, 'C', '7BC', 349),
(2, 47, 'B', 'TSO', 357),
(4, 14, 'D', '7BC', 358),
(2, 57, 'B', 'CPO', 359),
(3, 6, 'C', 'CES', 363),
(3, 54, 'A', 'TAT', 364),
(3, 49, 'B', 'CES', 365),
(1, 30, 'A', 'EMY', 366),
(1, 46, 'C', 'OML', 366),
(3, 40, 'D', 'EMY', 366),
(2, 57, 'B', 'CPO', 369),
(1, 45, 'A', 'TRR', 370),
(4, 14, 'B', 'BCF', 371),
(1, 22, 'A', 'CPO', 374),
(4, 61, 'A', '7BC', 375),
(4, 48, 'C', 'ATS', 376),
(3, 5, 'C', 'OLU', 377),
(2, 35, 'B', 'TAT', 378),
(3, 51, 'B', 'TAT', 379),
(3, 38, 'A', 'CPO', 380),
(2, 26, 'C', 'TAT', 381),
(2, 53, 'A', 'TAT', 382),
(2, 12, 'B', 'OLU', 383),
(2, 3, 'A', 'OLU', 384),
(3, 35, 'D', 'TRR', 384),
(1, 19, 'B', 'ATS', 386),
(1, 26, 'C', 'TAT', 387),
(2, 8, 'D', 'PIC', 388),
(3, 37, 'D', 'CPO', 389),
(2, 38, 'A', 'CPO', 390),
(3, 5, 'A', 'TSO', 390),
(3, 26, 'A', 'EMY', 390),
(4, 43, 'C', 'TRR', 390),
(4, 32, 'D', 'EMY', 395),
(1, 4, 'A', 'OLU', 396),
(3, 60, 'B', 'TAT', 397),
(1, 26, 'D', 'TAT', 398),
(1, 30, 'A', 'EMY', 399),
(2, 14, 'A', 'SLI', 400),
(2, 13, 'A', 'OML', 401),
(2, 32, 'C', 'TSO', 402),
(3, 54, 'C', 'TAT', 403),
(2, 21, 'D', '714', 404),
(2, 1, 'B', '714', 405),
(3, 7, 'D', 'BCF', 405),
(3, 11, 'B', 'TRR', 405),
(1, 2, 'C', 'BCF', 408),
(1, 4, 'A', 'TAT', 408),
(1, 22, 'C', '714', 408),
(1, 23, 'C', 'PIC', 408),
(1, 29, 'A', '714', 408),
(1, 40, 'A', 'OLU', 408),
(1, 52, 'A', 'OLU', 408),
(2, 23, 'B', '714', 408),
(3, 19, 'C', 'BCF', 408),
(5, 52, 'C', 'OLU', 408),
(1, 7, 'B', 'CES', 418),
(2, 29, 'C', '7BC', 418),
(3, 11, 'A', 'TAT', 418),
(2, 5, 'D', 'TAT', 421),
(2, 5, 'A', 'TSO', 422),
(2, 10, 'B', 'BCF', 422),
(2, 14, 'B', 'TAT', 422),
(2, 14, 'D', '7BC', 422),
(3, 20, 'A', 'TRR', 422),
(3, 6, 'D', '7BC', 427),
(1, 3, 'A', 'TAT', 428),
(1, 5, 'C', 'OLU', 428),
(1, 6, 'A', 'BCF', 428),
(1, 10, 'C', '714', 428),
(1, 18, 'B', 'TAT', 428),
(1, 19, 'A', 'PIC', 428),
(1, 26, 'B', 'TAT', 428),
(1, 29, 'B', 'OML', 428),
(1, 33, 'A', 'OML', 428),
(1, 40, 'C', 'TAT', 428),
(1, 46, 'C', 'OLU', 428),
(1, 61, 'B', 'PON', 428),
(2, 2, 'B', 'TRR', 428),
(2, 9, 'A', 'PIC', 428),
(2, 9, 'A', 'TAT', 428),
(2, 24, 'B', 'TAT', 428),
(2, 27, 'C', 'BCF', 428),
(2, 40, 'D', 'EMY', 428),
(2, 44, 'A', 'OML', 428),
(3, 4, 'C', 'OLU', 428),
(3, 11, 'B', 'OML', 428),
(3, 15, 'B', 'OML', 428),
(3, 26, 'D', 'BCF', 428),
(3, 37, 'C', 'TRR', 428),
(3, 40, 'D', 'EMY', 428),
(3, 44, 'D', 'BCF', 428),
(3, 52, 'A', 'TAT', 428),
(3, 54, 'C', '7BC', 428),
(4, 17, 'B', 'TAT', 428),
(4, 24, 'B', 'BCF', 428),
(4, 32, 'D', 'EMY', 428),
(4, 52, 'B', 'OLU', 428),
(2, 7, 'B', 'TRR', 460),
(3, 34, 'D', '7BC', 460),
(3, 16, 'D', 'TRR', 462),
(3, 42, 'D', '714', 462),
(2, 5, 'D', 'CES', 463),
(2, 49, 'B', 'OLU', 463),
(1, 3, 'C', 'TRR', 466),
(1, 4, 'A', 'TSO', 466),
(1, 4, 'C', 'OML', 466),
(1, 5, 'A', 'OLU', 466),
(1, 5, 'B', 'OLU', 466),
(1, 6, 'A', 'OML', 466),
(1, 6, 'C', 'OLU', 466),
(1, 10, 'B', 'OLU', 466),
(1, 15, 'A', 'TAT', 466),
(1, 17, 'A', 'TRR', 466),
(1, 18, 'C', 'PIC', 466),
(1, 25, 'A', 'TAT', 466),
(1, 30, 'B', 'OLU', 466),
(1, 31, 'B', 'OLU', 466),
(1, 38, 'A', 'OML', 466),
(1, 41, 'A', 'TAT', 466),
(1, 42, 'B', '7BC', 466),
(1, 46, 'B', 'OML', 466),
(1, 47, 'C', 'OML', 466),
(1, 47, 'D', 'OLU', 466),
(1, 49, 'A', 'OLU', 466),
(1, 49, 'D', 'OML', 466),
(1, 51, 'B', '7BC', 466),
(1, 60, 'A', 'PON', 466),
(1, 60, 'A', 'TAT', 466),
(1, 62, 'A', 'PON', 466),
(2, 3, 'D', 'OML', 466),
(2, 5, 'C', 'TSO', 466),
(2, 6, 'A', 'TAT', 466),
(2, 6, 'D', 'OLU', 466),
(2, 7, 'B', '7BC', 466),
(2, 7, 'B', 'OLU', 466),
(2, 8, 'B', 'OLU', 466),
(2, 12, 'D', 'BCF', 466),
(2, 18, 'B', 'BCF', 466),
(2, 18, 'C', 'TRR', 466),
(2, 19, 'C', 'TRR', 466),
(2, 22, 'A', 'BCF', 466),
(2, 25, 'C', 'BCF', 466),
(2, 28, 'A', 'OML', 466),
(2, 29, 'B', 'TRR', 466),
(2, 34, 'B', 'TAT', 466),
(2, 36, 'B', 'OLU', 466),
(2, 37, 'C', 'EMY', 466),
(2, 38, 'C', 'TAT', 466),
(2, 44, 'B', '714', 466),
(2, 47, 'B', 'OML', 466),
(2, 50, 'A', 'OML', 466),
(2, 53, 'D', 'OLU', 466),
(2, 54, 'B', '7BC', 466),
(2, 56, 'B', '714', 466),
(2, 62, 'D', 'PON', 466),
(3, 2, 'D', 'OLU', 466),
(3, 7, 'A', '7BC', 466),
(3, 9, 'D', 'TRR', 466),
(3, 10, 'C', 'OML', 466),
(3, 12, 'A', 'TRR', 466),
(3, 18, 'C', 'OLU', 466),
(3, 19, 'D', 'EMY', 466),
(3, 19, 'D', 'TRR', 466),
(3, 20, 'A', 'EMY', 466),
(3, 23, 'D', 'TRR', 466),
(3, 26, 'A', 'OLU', 466),
(3, 27, 'C', 'OML', 466),
(3, 28, 'C', 'TAT', 466),
(3, 29, 'B', '7BC', 466),
(3, 34, 'A', 'OML', 466),
(3, 34, 'B', 'EMY', 466),
(3, 36, 'D', 'TAT', 466),
(3, 38, 'B', 'EMY', 466),
(3, 38, 'C', 'OLU', 466),
(3, 40, 'A', 'TAT', 466),
(3, 41, 'D', 'TAT', 466),
(3, 44, 'D', 'OLU', 466),
(3, 45, 'D', 'OML', 466),
(3, 47, 'C', 'OML', 466),
(3, 48, 'B', '7BC', 466),
(3, 49, 'B', 'OLU', 466),
(3, 49, 'C', 'OLU', 466),
(3, 52, 'D', 'OML', 466),
(3, 54, 'A', '7BC', 466),
(3, 55, 'D', 'OML', 466),
(4, 2, 'B', 'OML', 466),
(4, 38, 'A', 'BCF', 466),
(4, 41, 'A', 'BCF', 466),
(4, 41, 'A', 'TRR', 466),
(4, 42, 'A', 'ATS', 466),
(4, 42, 'B', 'ATS', 466),
(4, 55, 'A', 'OML', 466),
(4, 60, 'A', 'OLU', 466),
(9, 58, 'A', '7BC', 466),
(1, 7, 'A', '7BC', 559),
(1, 20, 'A', 'TRR', 559),
(1, 37, 'D', 'EMY', 559),
(1, 48, 'D', 'OML', 559),
(2, 7, 'B', '7BC', 559),
(2, 38, 'D', 'TAT', 559),
(2, 61, 'B', 'SLI', 559),
(3, 6, 'C', 'OLU', 559),
(4, 46, 'A', 'ATS', 559),
(1, 11, 'C', '714', 568),
(1, 50, 'A', 'TAT', 568),
(2, 15, 'B', 'TAT', 568),
(3, 2, 'D', '714', 571),
(1, 16, 'C', 'EMY', 572),
(1, 18, 'D', 'TRR', 572),
(1, 47, 'D', '7BC', 572),
(2, 20, 'B', 'TRR', 572),
(3, 17, 'A', 'TRR', 572),
(3, 20, 'D', 'TRR', 572),
(2, 54, 'C', 'OML', 578),
(1, 29, 'B', 'SLI', 579),
(2, 35, 'C', 'CES', 580),
(1, 56, 'B', 'OML', 583),
(3, 40, 'D', 'EMY', 585),
(1, 22, 'A', '714', 586),
(1, 47, 'C', 'TSO', 586),
(1, 54, 'C', 'OML', 586),
(2, 58, 'B', '7BC', 586),
(3, 22, 'A', 'ATS', 586),
(3, 28, 'D', 'TRR', 586),
(3, 35, 'B', 'TAT', 586),
(3, 38, 'A', 'CPO', 586),
(3, 55, 'B', '7BC', 586),
(4, 34, 'B', 'ATS', 586),
(1, 5, 'C', 'TAT', 596),
(1, 46, 'C', 'CES', 596),
(2, 1, 'B', 'TAT', 596),
(2, 36, 'D', 'BCF', 596),
(2, 38, 'C', 'TAT', 596),
(2, 40, 'B', 'BCF', 596),
(3, 31, 'C', 'PIC', 596),
(3, 49, 'B', 'TAT', 596),
(3, 55, 'D', '714', 596),
(4, 25, 'C', 'CPO', 596),
(3, 20, 'A', 'CPO', 606),
(2, 20, 'B', 'CPO', 607),
(3, 26, 'B', 'TAT', 609),
(3, 8, 'D', 'PIC', 610),
(1, 44, 'A', 'CES', 611),
(2, 16, 'C', 'EMY', 611),
(3, 40, 'D', 'EMY', 611),
(2, 29, 'B', 'SLI', 614),
(4, 49, 'C', 'CES', 614),
(2, 56, 'B', 'CPO', 616),
(1, 20, 'A', 'EMY', 617),
(2, 55, 'B', '7BC', 618),
(1, 1, 'C', 'OLU', 619),
(1, 3, 'A', 'TSO', 619),
(2, 36, 'B', 'OLU', 619),
(2, 59, 'D', '7BC', 619),
(2, 62, 'A', 'PON', 619),
(1, 23, 'A', '714', 624),
(1, 30, 'A', 'EMY', 624),
(3, 49, 'B', 'CES', 626),
(2, 2, 'A', 'PIC', 627),
(3, 57, 'D', 'PON', 627),
(3, 10, 'C', 'PIC', 629),
(3, 49, 'C', 'CES', 629),
(1, 54, 'B', 'TAT', 631),
(3, 55, 'D', 'CPO', 633),
(3, 26, 'A', 'EMY', 635),
(3, 40, 'D', 'EMY', 636),
(2, 55, 'B', '7BC', 639),
(3, 38, 'A', 'CPO', 639),
(1, 1, 'C', 'OLU', 641),
(4, 44, 'B', 'ATS', 642),
(3, 40, 'D', 'EMY', 643),
(2, 8, 'D', 'PIC', 644),
(2, 21, 'C', '714', 645),
(2, 32, 'A', 'SLI', 646),
(2, 37, 'C', 'EMY', 647),
(1, 51, 'A', 'TAT', 649),
(1, 4, 'C', 'ATS', 650),
(2, 6, 'C', 'CES', 653),
(2, 54, 'D', 'TAT', 654),
(3, 58, 'C', 'PON', 655),
(2, 2, 'C', 'BCF', 656),
(1, 53, 'A', 'TAT', 657),
(1, 7, 'C', 'TRR', 658),
(1, 52, 'A', 'OLU', 658),
(3, 2, 'D', 'OLU', 658),
(3, 9, 'C', 'OLU', 658),
(3, 21, 'D', '714', 662),
(2, 26, 'C', 'TAT', 664),
(3, 29, 'A', 'SLI', 664),
(4, 34, 'B', 'ATS', 666),
(1, 40, 'A', 'OLU', 667),
(1, 44, 'A', 'CES', 667),
(1, 47, 'C', '7BC', 667),
(1, 56, 'A', 'CPO', 667),
(2, 38, 'C', 'CPO', 667),
(2, 47, 'B', 'OML', 667),
(2, 49, 'C', 'CES', 667),
(2, 53, 'D', 'SLI', 667),
(3, 5, 'C', 'OLU', 667),
(3, 14, 'A', 'SLI', 667),
(3, 23, 'C', '714', 667),
(3, 26, 'A', 'EMY', 667),
(3, 26, 'A', 'OLU', 667),
(3, 57, 'D', 'PON', 667),
(4, 32, 'D', 'EMY', 667),
(2, 4, 'B', 'TRR', 682),
(3, 52, 'D', 'OML', 683),
(1, 34, 'C', 'OLU', 684),
(1, 48, 'D', 'OML', 685),
(4, 34, 'B', 'ATS', 687),
(3, 41, 'C', 'CES', 688),
(2, 47, 'B', 'TSO', 690),
(3, 1, 'D', 'CES', 692),
(1, 45, 'A', '7BC', 693),
(3, 60, 'B', 'TAT', 694),
(3, 29, 'A', 'SLI', 695),
(4, 5, 'B', 'BCF', 696),
(3, 61, 'A', 'TSO', 697),
(3, 46, 'A', 'CES', 699),
(2, 10, 'B', 'BCF', 700),
(3, 21, 'D', '714', 700),
(3, 40, 'D', 'EMY', 702),
(1, 41, 'A', 'EMY', 703),
(2, 40, 'B', 'TAT', 704),
(2, 26, 'C', 'TAT', 705),
(1, 17, 'B', 'PIC', 706),
(2, 51, 'A', '714', 707),
(3, 3, 'A', '714', 707),
(2, 53, 'D', 'SLI', 709),
(3, 39, 'B', '714', 711),
(1, 56, 'D', 'CES', 712),
(2, 2, 'D', 'TSO', 713),
(2, 55, 'B', '7BC', 714),
(1, 54, 'C', 'SLI', 715),
(2, 14, 'A', 'SLI', 715),
(2, 29, 'A', 'SLI', 715),
(3, 5, 'C', 'OLU', 715),
(1, 56, 'D', '7BC', 719),
(1, 5, 'A', 'BCF', 720),
(2, 10, 'B', 'OLU', 720),
(2, 17, 'C', 'PIC', 720),
(2, 27, 'A', 'TAT', 723),
(3, 21, 'D', '714', 723),
(1, 43, 'A', '7BC', 725),
(1, 55, 'A', 'OML', 725),
(3, 37, 'D', 'CPO', 725),
(2, 11, 'A', 'PIC', 729),
(2, 40, 'D', 'EMY', 729),
(3, 20, 'B', 'SLI', 732),
(2, 53, 'B', 'OML', 733),
(3, 52, 'D', 'OML', 734),
(2, 49, 'B', '714', 735),
(3, 42, 'B', 'PIC', 737),
(4, 45, 'A', 'OML', 738),
(1, 2, 'A', 'PIC', 739),
(1, 26, 'C', 'TAT', 740),
(1, 19, 'C', 'ATS', 741),
(1, 48, 'A', 'TSO', 742),
(1, 41, 'C', 'CPO', 743),
(1, 45, 'A', '7BC', 743),
(4, 50, 'C', 'TSO', 743),
(1, 37, 'D', 'CPO', 746),
(3, 33, 'A', 'TSO', 746),
(1, 48, 'A', 'TSO', 749),
(2, 48, 'B', 'OML', 750),
(1, 6, 'D', 'TAT', 751),
(1, 11, 'B', 'PIC', 751),
(1, 36, 'C', 'OML', 751),
(3, 49, 'B', 'TAT', 754),
(1, 17, 'A', 'TAT', 756),
(1, 24, 'D', 'TAT', 756),
(1, 27, 'D', '7BC', 756),
(2, 15, 'F', 'TAT', 756),
(2, 41, 'A', 'TAT', 756),
(2, 48, 'D', 'OLU', 756),
(3, 38, 'D', 'OML', 756),
(1, 2, 'B', 'TRR', 763),
(1, 8, 'A', 'BCF', 763),
(1, 10, 'A', 'OLU', 763),
(1, 19, 'C', 'PIC', 763),
(1, 33, 'B', 'OML', 763),
(1, 35, 'A', 'EMY', 763),
(1, 37, 'B', 'TRR', 763),
(1, 42, 'C', 'OML', 763),
(1, 47, 'D', '7BC', 763),
(1, 52, 'A', 'OLU', 763),
(1, 55, 'A', '7BC', 763),
(1, 56, 'A', 'OML', 763),
(1, 60, 'D', '714', 763),
(2, 5, 'C', 'SLI', 763),
(2, 6, 'C', 'OLU', 763),
(2, 7, 'B', '7BC', 763),
(2, 12, 'B', 'OLU', 763),
(2, 16, 'D', 'TAT', 763),
(2, 17, 'B', 'TAT', 763),
(2, 17, 'C', 'TRR', 763),
(2, 20, 'B', 'TRR', 763),
(2, 21, 'B', 'EMY', 763),
(2, 26, 'A', 'TAT', 763),
(2, 26, 'B', 'OML', 763),
(2, 27, 'A', 'OML', 763),
(2, 28, 'A', 'OML', 763),
(2, 31, 'D', 'TRR', 763),
(2, 32, 'B', 'TRR', 763),
(2, 32, 'D', 'TAT', 763),
(2, 34, 'C', 'EMY', 763),
(2, 35, 'D', 'TRR', 763),
(2, 36, 'B', 'EMY', 763),
(2, 37, 'C', 'EMY', 763),
(2, 43, 'C', 'EMY', 763),
(2, 47, 'D', 'OLU', 763),
(2, 50, 'A', 'OLU', 763),
(2, 52, 'C', 'OLU', 763),
(2, 59, 'B', '7BC', 763),
(2, 61, 'A', 'SLI', 763),
(2, 62, 'A', '7BC', 763),
(2, 62, 'A', 'PON', 763),
(2, 62, 'D', 'EMY', 763),
(3, 1, 'B', '714', 763),
(3, 2, 'B', 'BCF', 763),
(3, 3, 'D', 'TSO', 763),
(3, 5, 'A', 'OLU', 763),
(3, 6, 'C', 'BCF', 763),
(3, 7, 'A', 'OLU', 763),
(3, 9, 'A', 'TAT', 763),
(3, 9, 'D', 'EMY', 763),
(3, 12, 'B', '714', 763),
(3, 14, 'A', 'TAT', 763),
(3, 17, 'A', 'EMY', 763),
(3, 25, 'D', 'EMY', 763),
(3, 26, 'B', 'EMY', 763),
(3, 27, 'C', 'OML', 763),
(3, 28, 'B', 'TRR', 763),
(3, 34, 'D', '714', 763),
(3, 35, 'A', '7BC', 763),
(3, 36, 'C', 'OML', 763),
(3, 40, 'D', 'TAT', 763),
(3, 48, 'B', 'TAT', 763),
(3, 50, 'C', '7BC', 763),
(3, 52, 'A', 'TAT', 763),
(3, 55, 'A', 'OLU', 763),
(3, 59, 'B', 'BCF', 763),
(4, 26, 'A', 'BCF', 763),
(4, 39, 'B', 'OLU', 763),
(4, 45, 'D', 'SLI', 763),
(4, 54, 'B', '7BC', 763),
(4, 61, 'D', 'PON', 763),
(5, 32, 'C', 'OLU', 763),
(1, 5, 'D', 'SLI', 835),
(1, 51, 'A', '7BC', 835),
(2, 14, 'B', '7BC', 835),
(2, 44, 'B', '714', 835),
(2, 59, 'A', 'PON', 835),
(3, 23, 'A', 'TRR', 835),
(3, 30, 'C', 'BCF', 835),
(3, 54, 'D', 'OML', 835),
(3, 55, 'B', 'OML', 835),
(4, 14, 'D', '7BC', 835),
(4, 27, 'D', 'EMY', 835),
(3, 29, 'A', 'SLI', 846),
(3, 42, 'B', 'PIC', 847),
(4, 45, 'A', 'OML', 847),
(3, 14, 'A', 'SLI', 850),
(2, 30, 'A', 'EMY', 851),
(3, 40, 'D', 'EMY', 851),
(1, 14, 'A', '714', 853),
(1, 37, 'D', 'CPO', 854),
(1, 46, 'D', 'CES', 854),
(4, 34, 'B', 'ATS', 854),
(1, 26, 'C', 'TAT', 857),
(3, 46, 'C', 'TSO', 857),
(1, 26, 'C', 'TAT', 860),
(1, 45, 'A', '7BC', 860),
(2, 23, 'A', '714', 860),
(3, 54, 'A', '7BC', 860),
(3, 49, 'C', 'CES', 864),
(1, 37, 'D', 'CPO', 865),
(1, 43, 'A', '7BC', 865),
(1, 46, 'D', 'CES', 865),
(2, 20, 'B', 'SLI', 865),
(3, 21, 'D', '714', 865),
(3, 34, 'C', 'ATS', 865),
(3, 55, 'D', 'CPO', 872),
(2, 20, 'C', 'OML', 874),
(3, 29, 'A', 'SLI', 875),
(2, 19, 'B', 'SLI', 876),
(3, 62, 'A', 'OML', 878),
(3, 54, 'A', 'OLU', 879),
(1, 49, 'C', 'OLU', 880),
(4, 19, 'B', 'BCF', 881),
(2, 9, 'D', 'OLU', 882),
(1, 7, 'B', 'BCF', 883),
(3, 49, 'B', 'TAT', 884),
(3, 22, 'D', '714', 885),
(4, 49, 'A', 'CES', 885),
(4, 45, 'A', 'OML', 887),
(1, 39, 'C', '714', 888),
(3, 57, 'D', 'PON', 890),
(2, 46, 'D', 'CES', 891),
(1, 47, 'C', 'TSO', 892),
(1, 21, 'B', 'BCF', 893),
(2, 40, 'D', '7BC', 893),
(1, 29, 'B', 'SLI', 895),
(1, 1, 'C', 'BCF', 896),
(1, 2, 'C', 'OLU', 896),
(1, 7, 'C', '714', 896),
(1, 15, 'D', 'ATS', 896),
(1, 15, 'F', 'TAT', 896),
(1, 31, 'B', 'OLU', 896),
(2, 34, 'C', 'OLU', 896),
(2, 49, 'C', 'OLU', 896),
(2, 56, 'B', 'CPO', 896),
(3, 36, 'C', 'TAT', 896),
(3, 42, 'A', 'TAT', 896),
(3, 62, 'B', 'TAT', 896),
(4, 39, 'B', 'OLU', 896),
(3, 62, 'C', 'OML', 909),
(1, 9, 'B', 'OLU', 911),
(2, 38, 'A', 'CPO', 911),
(2, 56, 'A', 'CPO', 911),
(3, 55, 'B', '7BC', 911);

--
-- Index pour les tables déchargées
--

--
-- Index pour la table `album`
--
ALTER TABLE `album`
  ADD PRIMARY KEY (`album_ref`);

--
-- Index pour la table `bande`
--
ALTER TABLE `bande`
  ADD PRIMARY KEY (`bande_place`,`num_page`,`ref_album`),
  ADD KEY `page_album` (`num_page`,`ref_album`);

--
-- Index pour la table `case_bulle`
--
ALTER TABLE `case_bulle`
  ADD PRIMARY KEY (`case_num`,`place_bande`,`num_page`,`ref_album`),
  ADD UNIQUE KEY `case_num` (`case_num`,`place_bande`,`num_page`,`ref_album`),
  ADD KEY `bulle_ibfk_1` (`num_page`,`ref_album`,`place_bande`);

--
-- Index pour la table `jurons`
--
ALTER TABLE `jurons`
  ADD PRIMARY KEY (`jurons_num`);

--
-- Index pour la table `page`
--
ALTER TABLE `page`
  ADD PRIMARY KEY (`page_num`,`ref_album`),
  ADD KEY `ref_album` (`ref_album`);

--
-- Index pour la table `se_trouver_bulle`
--
ALTER TABLE `se_trouver_bulle`
  ADD PRIMARY KEY (`num_case`,`num_page`,`place_bande`,`ref_album`,`jurons_num`),
  ADD KEY `stb_jurons_num` (`jurons_num`),
  ADD KEY `stb_ibfk` (`num_case`,`place_bande`,`num_page`,`ref_album`);

--
-- AUTO_INCREMENT pour les tables déchargées
--

--
-- AUTO_INCREMENT pour la table `jurons`
--
ALTER TABLE `jurons`
  MODIFY `jurons_num` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=912;

--
-- Contraintes pour les tables déchargées
--

--
-- Contraintes pour la table `bande`
--
ALTER TABLE `bande`
  ADD CONSTRAINT `bande_ibfk_1` FOREIGN KEY (`num_page`,`ref_album`) REFERENCES `page` (`page_num`, `ref_album`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Contraintes pour la table `case_bulle`
--
ALTER TABLE `case_bulle`
  ADD CONSTRAINT `bulle_ibfk_1` FOREIGN KEY (`num_page`,`ref_album`,`place_bande`) REFERENCES `bande` (`num_page`, `ref_album`, `bande_place`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Contraintes pour la table `page`
--
ALTER TABLE `page`
  ADD CONSTRAINT `page_ibfk_1` FOREIGN KEY (`ref_album`) REFERENCES `album` (`album_ref`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Contraintes pour la table `se_trouver_bulle`
--
ALTER TABLE `se_trouver_bulle`
  ADD CONSTRAINT `stb_ibfk` FOREIGN KEY (`num_case`,`place_bande`,`num_page`,`ref_album`) REFERENCES `case_bulle` (`case_num`, `place_bande`, `num_page`, `ref_album`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `stb_ibfk_1` FOREIGN KEY (`jurons_num`) REFERENCES `jurons` (`jurons_num`) ON DELETE CASCADE ON UPDATE CASCADE;

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