TD5ixCg0

1-- phpMyAdmin SQL Dump
2-- version 4.3.11
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Mar 27, 2019 at 05:19 AM
7-- Server version: 5.6.24
8-- PHP Version: 5.6.8
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET 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-- Database: `171159265`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `matchinfo`
27--
28
29CREATE TABLE IF NOT EXISTS `matchinfo` (
30  `MatchId` int(11) NOT NULL,
31  `TeamId` int(11) NOT NULL,
32  `Score` decimal(10,2) NOT NULL,
33  `MatchDate` date NOT NULL
34) ENGINE=InnoDB DEFAULT CHARSET=latin1;
35
36--
37-- Dumping data for table `matchinfo`
38--
39
40INSERT INTO `matchinfo` (`MatchId`, `TeamId`, `Score`, `MatchDate`) VALUES
41(2001, 1004, '58.00', '2018-12-04'),
42(2002, 1003, '34.00', '2015-11-12'),
43(2003, 1002, '120.00', '2016-06-05'),
44(2004, 1002, '25.00', '2009-03-08'),
45(2005, 1005, '38.00', '2010-06-15'),
46(2006, 1001, '45.00', '2011-08-17'),
47(2007, 1004, '100.00', '2017-10-21'),
48(2008, 1007, '120.00', '2018-01-06');
49
50/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
51/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
52/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;