· 8 years ago · May 16, 2018, 09:30 AM
1-- phpMyAdmin SQL Dump
2-- version 4.7.9
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1:3306
6-- Generation Time: May 16, 2018 at 09:27 AM
7-- Server version: 5.7.21
8-- PHP Version: 5.6.35
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Database: `bestproject2k18`
23--
24
25-- --------------------------------------------------------
26
27--
28-- Table structure for table `country`
29--
30
31DROP TABLE IF EXISTS `country`;
32CREATE TABLE IF NOT EXISTS `country` (
33 `id` int(11) NOT NULL AUTO_INCREMENT,
34 `Nom` varchar(255) COLLATE utf8_bin NOT NULL,
35 `Abbreviation` varchar(255) COLLATE utf8_bin NOT NULL,
36 `Icon` text COLLATE utf8_bin NOT NULL,
37 PRIMARY KEY (`id`)
38) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
39
40--
41-- Dumping data for table `country`
42--
43
44INSERT INTO `country` (`id`, `Nom`, `Abbreviation`, `Icon`) VALUES
45(1, 'TUNISIA', 'tn', 'TN'),
46(2, 'ALGERIA', 'al', 'AL'),
47(3, 'MAROC', 'mr', 'MR'),
48(4, 'FRANCE', 'fr', 'FR'),
49(5, 'EGYPTE', 'eg', 'EG');
50
51-- --------------------------------------------------------
52
53--
54-- Table structure for table `equipe`
55--
56
57DROP TABLE IF EXISTS `equipe`;
58CREATE TABLE IF NOT EXISTS `equipe` (
59 `id` int(11) NOT NULL AUTO_INCREMENT,
60 `nom` varchar(255) COLLATE utf8_bin NOT NULL,
61 `country` int(11) NOT NULL,
62 `sport` int(11) NOT NULL,
63 PRIMARY KEY (`id`)
64) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
65
66--
67-- Dumping data for table `equipe`
68--
69
70INSERT INTO `equipe` (`id`, `nom`, `country`, `sport`) VALUES
71(10, 'css', 1, 1),
72(11, 'est', 1, 1),
73(12, 'ess', 1, 1),
74(13, 'cab', 1, 1),
75(14, 'mse', 1, 1),
76(15, 'vbv', 1, 1),
77(16, 'msc', 1, 1),
78(17, 'cvv', 1, 1),
79(18, 'rnd', 1, 1),
80(19, 'mad', 1, 1),
81(20, 'rip', 2, 0),
82(21, 'rep', 2, 0),
83(22, 'pop', 2, 0),
84(23, 'eas', 2, 0),
85(24, 'eas', 2, 0),
86(25, 'eas', 2, 0),
87(26, 'eas', 2, 0),
88(27, 'eas', 2, 0),
89(28, 'farssxxatf', 3, 2),
90(29, 'farssxxatf', 3, 2),
91(30, 'farssxxatf', 3, 2),
92(31, 'farssxxatf', 3, 2),
93(32, 'farssxxatf', 3, 2),
94(33, 'saras', 4, 1),
95(34, 'saras', 4, 1),
96(35, 'saras', 4, 1),
97(36, 'saras', 4, 1);
98
99-- --------------------------------------------------------
100
101--
102-- Table structure for table `game`
103--
104
105DROP TABLE IF EXISTS `game`;
106CREATE TABLE IF NOT EXISTS `game` (
107 `id` int(11) NOT NULL AUTO_INCREMENT,
108 `equipe1` int(11) NOT NULL,
109 `equipe2` int(11) NOT NULL,
110 `sport` int(11) NOT NULL,
111 PRIMARY KEY (`id`)
112) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
113
114--
115-- Dumping data for table `game`
116--
117
118INSERT INTO `game` (`id`, `equipe1`, `equipe2`, `sport`) VALUES
119(1, 10, 12, 1),
120(2, 12, 13, 1),
121(3, 11, 13, 2),
122(4, 14, 15, 4),
123(5, 19, 14, 3),
124(6, 16, 18, 3),
125(7, 13, 11, 4),
126(8, 10, 19, 1),
127(9, 17, 16, 2),
128(10, 15, 15, 2),
129(11, 13, 14, 4),
130(12, 12, 18, 1),
131(13, 19, 11, 3),
132(14, 14, 17, 4),
133(15, 11, 12, 2);
134
135-- --------------------------------------------------------
136
137--
138-- Table structure for table `score`
139--
140
141DROP TABLE IF EXISTS `score`;
142CREATE TABLE IF NOT EXISTS `score` (
143 `id` int(11) NOT NULL AUTO_INCREMENT,
144 `equipe1` varchar(255) COLLATE utf8_bin NOT NULL,
145 `equipe2` varchar(255) COLLATE utf8_bin NOT NULL,
146 `sport` varchar(255) COLLATE utf8_bin NOT NULL,
147 `score` varchar(255) COLLATE utf8_bin NOT NULL,
148 `won` varchar(255) COLLATE utf8_bin NOT NULL,
149 `dateMatch` bigint(20) NOT NULL,
150 PRIMARY KEY (`id`)
151) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
152
153--
154-- Dumping data for table `score`
155--
156
157INSERT INTO `score` (`id`, `equipe1`, `equipe2`, `sport`, `score`, `won`, `dateMatch`) VALUES
158(1, 'CSS', 'Equipe2', 'Football', '0/3', 'Equipe2', 0),
159(2, 'CSS', 'Equipe2', 'Football', '0/0', 'Null', 0);
160
161-- --------------------------------------------------------
162
163--
164-- Table structure for table `sport`
165--
166
167DROP TABLE IF EXISTS `sport`;
168CREATE TABLE IF NOT EXISTS `sport` (
169 `id` int(11) NOT NULL AUTO_INCREMENT,
170 `nom` varchar(255) COLLATE utf8_bin NOT NULL,
171 PRIMARY KEY (`id`)
172) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
173
174--
175-- Dumping data for table `sport`
176--
177
178INSERT INTO `sport` (`id`, `nom`) VALUES
179(1, 'Football'),
180(2, 'Voleyball'),
181(3, 'Tennis'),
182(4, 'HandBall'),
183(5, 'pingpong');
184COMMIT;
185
186/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
187/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
188/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;