Permalink
Newer
Older
100644 109 lines (84 sloc) 2.53 KB
1
-- phpMyAdmin SQL Dump
2
-- version 3.3.8
3
-- http://www.phpmyadmin.net
4
--
5
-- Host: localhost
6
-- Generation Time: Dec 07, 2010 at 10:20 PM
7
-- Server version: 5.1.41
8
-- PHP Version: 5.3.2-1ubuntu4.5
9
10
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11
12
13
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
14
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
15
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
16
/*!40101 SET NAMES utf8 */;
17
18
--
19
-- Database: `fifa`
20
--
21
22
-- --------------------------------------------------------
23
24
--
25
-- Table structure for table `admins`
26
--
27
28
CREATE TABLE IF NOT EXISTS `admins` (
29
`id` int(11) NOT NULL AUTO_INCREMENT,
30
`name` varchar(50) NOT NULL,
31
`pass` varchar(50) NOT NULL,
32
PRIMARY KEY (`id`)
33
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
34
35
--
36
-- Dumping data for table `admins`
37
--
38
39
INSERT INTO `admins` (`id`, `name`, `pass`) VALUES
40
(1, 'john', 'password'),
41
(2, 'mario', 'password');
42
43
-- --------------------------------------------------------
44
45
--
46
-- Table structure for table `matches`
47
--
48
49
CREATE TABLE IF NOT EXISTS `matches` (
50
`mid` int(11) NOT NULL AUTO_INCREMENT,
51
`stadium` varchar(50) NOT NULL,
52
`datetime` datetime NOT NULL,
53
`team1` int(11) NOT NULL,
54
`team2` int(11) NOT NULL,
55
PRIMARY KEY (`mid`)
56
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
57
58
--
59
-- Dumping data for table `matches`
60
--
61
62
INSERT INTO `matches` (`mid`, `stadium`, `datetime`, `team1`, `team2`) VALUES
63
(1, 'Portsmouth FC', '2010-12-09 19:08:22', 1, 2);
64
65
-- --------------------------------------------------------
66
67
--
68
-- Table structure for table `players`
69
--
70
71
CREATE TABLE IF NOT EXISTS `players` (
72
`pid` int(11) NOT NULL AUTO_INCREMENT,
73
`pname` varchar(45) NOT NULL,
74
`dob` date NOT NULL,
75
`tid` int(11) NOT NULL,
76
PRIMARY KEY (`pid`)
77
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
78
79
--
80
-- Dumping data for table `players`
81
--
82
83
INSERT INTO `players` (`pid`, `pname`, `dob`, `tid`) VALUES
84
(1, 'Mario', '2010-12-07', 1),
85
(2, 'Jorge', '2010-12-07', 1),
86
(3, 'Martin', '2000-01-01', 2),
87
(4, 'Waqar', '2000-01-01', 2);
88
89
-- --------------------------------------------------------
90
91
--
92
-- Table structure for table `teams`
93
--
94
95
CREATE TABLE IF NOT EXISTS `teams` (
96
`tid` int(11) NOT NULL AUTO_INCREMENT,
97
`tname` varchar(50) NOT NULL,
98
`city` varchar(50) NOT NULL,
99
PRIMARY KEY (`tid`)
100
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
101
102
--
103
-- Dumping data for table `teams`
104
--
105
106
INSERT INTO `teams` (`tid`, `tname`, `city`) VALUES
107
(1, 'Pompey', 'Portsmouth'),
108
(2, 'Forest', 'Nottingham');