station.sql

File: station.sql - Tab length: 1 2 4 8 - Lines: on off - No wrap: on off

01: -- phpMyAdmin SQL Dump
02: -- version 3.4.10.1deb1
03: -- http://www.phpmyadmin.net
04: --
05: -- Client: 195.83.142.10:3306
06: -- Gï¿½nï¿½rï¿½ le : Jeu 05 Dï¿½cembre 2013 ï¿½ 15:41
07: -- Version du serveur: 5.5.34
08: -- Version de PHP: 5.3.10-1ubuntu3.8
09:
10: SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11: SET time_zone = "+00:00";
12:
13:
14: /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15: /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16: /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17: /*!40101 SET NAMES utf8 */;
18:
19: --
20: -- Base de donnï¿½es: `feller4u_mettis`
21: --
22:
23: -- --------------------------------------------------------
24:
25: --
26: -- Structure de la table `station`
27: --
28:
29: CREATE TABLE IF NOT EXISTS `station` (
30:   `no_station` varchar(5) NOT NULL,
31:   `nom_station` varchar(25) NOT NULL,
32:   PRIMARY KEY (`no_station`)
33: ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
34:
35: --
36: -- Contenu de la table `station`
37: --
38:
39: INSERT INTO `station` (`no_station`, `nom_station`) VALUES
40: ('S01', 'Citï¿½ U'),
41: ('S02', 'Maternitï¿½'),
42: ('S03', 'Woippy'),
43: ('S04', 'Jules Michelet'),
44: ('S05', 'Guyenne'),
45: ('S08', 'Gare'),
46: ('S09', 'Metz Expo'),
47: ('S10', 'Rochambeau'),
48: ('S11', 'Deux Fontaines'),
49: ('S12', 'Docteur Charcot'),
50: ('S13', 'Emile Roux'),
51: ('S14', 'Intendants Joba'),
52: ('S15', 'Renï¿½ Cassin'),
53: ('S16', 'Georges Bernanos'),
54: ('S17', 'Pontoffroy'),
55: ('S18', 'Saint Vincent'),
56: ('S19', 'Square du Luxembourg'),
57: ('S20', 'Rï¿½publique'),
58: ('S21', 'Roi George'),
59: ('S22', 'Centre Pompidou-Metz'),
60: ('S23', 'Frï¿½res Lacretelle'),
61: ('S24', 'Hï¿½pital Legouest'),
62: ('S25', 'Felix Alcan'),
63: ('S26', 'Cimitiï¿½re de l''est'),
64: ('S27', 'Belletanche'),
65: ('S28', 'Provence'),
66: ('S29', 'Les bordes'),
67: ('S30', 'Hauts de blï¿½mont'),
68: ('S31', 'Cloutiers'),
69: ('S32', 'Colombey'),
70: ('S33', 'Jules Michelet');
71:
72: /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
73: /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
74: /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;