iEgXPDi1

1-- phpMyAdmin SQL Dump
2-- version 3.4.11.1deb2+deb7u6
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Oct 27, 2016 at 02:44 AM
7-- Server version: 5.5.52
8-- PHP Version: 5.6.26-1~dotdeb+zts+7.1
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: `forum`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `xf_yfl_rival_stats`
27--
28
29CREATE TABLE IF NOT EXISTS `xf_yfl_rival_stats` (
30  `match_id` bigint(30) NOT NULL,
31  `player_ea_id` bigint(60) NOT NULL,
32  `persona_name` varchar(50) NOT NULL,
33  `club_id` bigint(20) NOT NULL,
34  `assists` int(2) NOT NULL,
35  `cleansheetsany` int(2) NOT NULL,
36  `cleansheetsdef` int(2) NOT NULL,
37  `cleansheetsgk` int(2) NOT NULL,
38  `goals` int(2) NOT NULL,
39  `goalsconceded` int(2) NOT NULL,
40  `mom` int(1) NOT NULL,
41  `passattempts` int(3) NOT NULL,
42  `passesmade` int(3) NOT NULL,
43  `pos` int(3) NOT NULL,
44  `rating` double(4,2) NOT NULL,
45  `redcards` int(2) NOT NULL,
46  `saves` int(3) NOT NULL,
47  `shots` int(3) NOT NULL,
48  `tackleattempts` int(3) NOT NULL,
49  `tacklesmade` int(3) NOT NULL,
50  `yellowcards` int(2) NOT NULL DEFAULT '0',
51  PRIMARY KEY (`player_ea_id`),
52  UNIQUE KEY `match_id` (`match_id`,`player_ea_id`),
53  KEY `club_id` (`club_id`),
54  KEY `player_ea_id` (`player_ea_id`),
55  KEY `match_id_2` (`match_id`)
56) ENGINE=InnoDB DEFAULT CHARSET=latin1;
57
58/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
59/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
60/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;