-- phpMyAdmin SQL Dump
-- version 2.6.1
-- http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время создания: Апр 23 2006 г., 00:06
-- Версия сервера: 4.1.8
-- Версия PHP: 5.0.4
--
-- БД: `football_game`
--
-- --------------------------------------------------------
--
-- Структура таблицы `all_tour_result`
--
CREATE TABLE `all_tour_result` (
`id` int(10) unsigned NOT NULL auto_increment,
`date` int(10) unsigned NOT NULL default '0',
`id_tour` int(10) unsigned NOT NULL default '0',
`id_user` int(10) unsigned NOT NULL default '0',
`id_clubs` varchar(255) NOT NULL default '',
`points` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
-- --------------------------------------------------------
--
-- Структура таблицы `clubs`
--
CREATE TABLE `clubs` (
`id_club` int(10) unsigned NOT NULL auto_increment,
`club_name` varchar(30) character set latin1 NOT NULL default '',
`club_price` int(10) unsigned NOT NULL default '0',
`club_points` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id_club`)
) ENGINE=MyISAM;
-- --------------------------------------------------------
--
-- Структура таблицы `results_game`
--
CREATE TABLE `results_game` (
`id_tour` int(10) unsigned NOT NULL auto_increment,
`id_club` int(10) unsigned NOT NULL default '0',
`date` int(10) unsigned NOT NULL default '0',
`points` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id_tour`,`id_club`,`date`)
) ENGINE=MyISAM;
-- --------------------------------------------------------
--
-- Структура таблицы `superadmin`
--
CREATE TABLE `superadmin` (
`id_admin` int(10) unsigned NOT NULL auto_increment,
`login` varchar(30) NOT NULL default '',
`pass` varchar(50) NOT NULL default '',
PRIMARY KEY (`id_admin`)
) ENGINE=MyISAM;
-- --------------------------------------------------------
--
-- Структура таблицы `team_in_tour`
--
CREATE TABLE `team_in_tour` (
`id_user` int(10) unsigned NOT NULL default '0',
`id_tour` int(10) unsigned NOT NULL default '0',
`id_team` int(10) unsigned NOT NULL default '0',
`date` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id_user`,`id_tour`)
) ENGINE=MyISAM;
-- --------------------------------------------------------
--
-- Структура таблицы `tournament`
--
CREATE TABLE `tournament` (
`id_tour` int(10) unsigned NOT NULL auto_increment,
`date` int(10) unsigned NOT NULL default '0',
`name` varchar(50) character set latin1 NOT NULL default '',
`period` int(10) unsigned NOT NULL default '7',
PRIMARY KEY (`id_tour`)
) ENGINE=MyISAM;
-- --------------------------------------------------------
--
-- Структура таблицы `users`
--
CREATE TABLE `users` (
`id_user` int(10) unsigned NOT NULL auto_increment,
`name` varchar(30) character set latin1 NOT NULL default '',
`email` varchar(35) NOT NULL default '',
`money` int(10) unsigned NOT NULL default '100',
`pass` varchar(50) NOT NULL default '',
PRIMARY KEY (`id_user`)
) ENGINE=MyISAM;
-- --------------------------------------------------------
--
-- Структура таблицы `users_team`
--
CREATE TABLE `users_team` (
`id_team` int(10) unsigned NOT NULL auto_increment,
`id_user` int(10) unsigned NOT NULL default '0',
`id_club` varchar(255) NOT NULL default '',
PRIMARY KEY (`id_team`)
) ENGINE=MyISAM;