Просмотр файла tennis/komanda/wtagame/sql.sql

Размер файла: 29.77Kb
-- phpMyAdmin SQL Dump
-- version 2.9.0.2
-- http://www.phpmyadmin.net
-- 
-- Хост: localhost
-- Время создания: Фев 10 2007 г., 00:10
-- Версия сервера: 4.1.21
-- Версия PHP: 4.4.2
-- 
-- База данных: `tennismo_wtagame`
-- 

-- --------------------------------------------------------

-- 
-- Структура таблицы `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 DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- 
-- Дамп данных таблицы `all_tour_result`
-- 


-- --------------------------------------------------------

-- 
-- Структура таблицы `clubs`
-- 

CREATE TABLE `clubs` (
  `id_club` int(10) unsigned NOT NULL auto_increment,
  `club_name` varchar(30) 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  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=32 ;

-- 
-- Дамп данных таблицы `clubs`
-- 

INSERT INTO `clubs` VALUES (1, 'MAURESMO', 30, 0);
INSERT INTO `clubs` VALUES (2, 'CLIJSTERS', 35, 0);
INSERT INTO `clubs` VALUES (3, 'HENIN-HARDENNE', 40, 0);
INSERT INTO `clubs` VALUES (4, 'SHARAPOVA', 40, 0);
INSERT INTO `clubs` VALUES (5, 'KUZNETSOVA', 30, 0);
INSERT INTO `clubs` VALUES (6, 'V.WILLIAMS', 35, 0);
INSERT INTO `clubs` VALUES (7, 'DEMENTIEVA', 20, 0);
INSERT INTO `clubs` VALUES (8, 'SCHNYDER', 20, 0);
INSERT INTO `clubs` VALUES (9, 'MYSKINA', 25, 0);
INSERT INTO `clubs` VALUES (10, 'VAIDISOVA', 25, 0);
INSERT INTO `clubs` VALUES (11, 'SCHIAVONE', 15, 0);
INSERT INTO `clubs` VALUES (12, 'HINGIS', 25, 0);
INSERT INTO `clubs` VALUES (13, 'GROENEFELD', 15, 0);
INSERT INTO `clubs` VALUES (14, 'SAFINA', 15, 0);
INSERT INTO `clubs` VALUES (15, 'HANTUCHOVA', 15, 0);
INSERT INTO `clubs` VALUES (16, 'PENNETTA', 10, 0);
INSERT INTO `clubs` VALUES (17, 'KIRILENKO', 12, 0);
INSERT INTO `clubs` VALUES (18, 'SUGIYAMA', 12, 0);
INSERT INTO `clubs` VALUES (19, 'IVANOVIC', 15, 0);
INSERT INTO `clubs` VALUES (20, 'PEER', 15, 0);
INSERT INTO `clubs` VALUES (21, 'SREBOTNIK', 12, 0);
INSERT INTO `clubs` VALUES (22, 'DECHY', 15, 0);
INSERT INTO `clubs` VALUES (23, 'MEDINA GARRIGUES', 7, 0);
INSERT INTO `clubs` VALUES (24, 'BARTOLI', 10, 0);
INSERT INTO `clubs` VALUES (25, 'LIKHOVTSEVA', 15, 0);
INSERT INTO `clubs` VALUES (26, 'JANKOVIC', 12, 0);
INSERT INTO `clubs` VALUES (27, 'LI', 10, 0);
INSERT INTO `clubs` VALUES (28, 'ARVIDSSON', 7, 0);
INSERT INTO `clubs` VALUES (29, 'GOLOVIN', 12, 0);
INSERT INTO `clubs` VALUES (30, 'CHAKVETADZE', 12, 0);
INSERT INTO `clubs` VALUES (31, 'DULKO', 10, 0);

-- --------------------------------------------------------

-- 
-- Структура таблицы `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  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2 ;

-- 
-- Дамп данных таблицы `results_game`
-- 

INSERT INTO `results_game` VALUES (1, 2, 1151444328, 1);
INSERT INTO `results_game` VALUES (1, 3, 1151444328, 1);
INSERT INTO `results_game` VALUES (1, 5, 1151444328, 1);
INSERT INTO `results_game` VALUES (1, 10, 1151444328, 1);
INSERT INTO `results_game` VALUES (1, 12, 1151444328, 1);
INSERT INTO `results_game` VALUES (1, 15, 1151444328, 1);
INSERT INTO `results_game` VALUES (1, 18, 1151444328, 1);
INSERT INTO `results_game` VALUES (1, 21, 1151444328, 1);
INSERT INTO `results_game` VALUES (1, 24, 1151444328, 1);
INSERT INTO `results_game` VALUES (1, 27, 1151444328, 1);
INSERT INTO `results_game` VALUES (1, 30, 1151444328, 1);
INSERT INTO `results_game` VALUES (1, 31, 1151444328, 1);
INSERT INTO `results_game` VALUES (1, 1, 1151524187, 1);
INSERT INTO `results_game` VALUES (1, 2, 1151524187, 1);
INSERT INTO `results_game` VALUES (1, 3, 1151524187, 1);
INSERT INTO `results_game` VALUES (1, 4, 1151524187, 1);
INSERT INTO `results_game` VALUES (1, 5, 1151524187, 1);
INSERT INTO `results_game` VALUES (1, 6, 1151524187, 1);
INSERT INTO `results_game` VALUES (1, 7, 1151524187, 1);
INSERT INTO `results_game` VALUES (1, 8, 1151524187, 1);
INSERT INTO `results_game` VALUES (1, 9, 1151524187, 1);
INSERT INTO `results_game` VALUES (1, 10, 1151524187, 1);
INSERT INTO `results_game` VALUES (1, 12, 1151524187, 1);
INSERT INTO `results_game` VALUES (1, 16, 1151524187, 1);
INSERT INTO `results_game` VALUES (1, 18, 1151524187, 1);
INSERT INTO `results_game` VALUES (1, 19, 1151524187, 1);
INSERT INTO `results_game` VALUES (1, 20, 1151524187, 1);
INSERT INTO `results_game` VALUES (1, 21, 1151524187, 1);
INSERT INTO `results_game` VALUES (1, 23, 1151524187, 1);
INSERT INTO `results_game` VALUES (1, 25, 1151524187, 1);
INSERT INTO `results_game` VALUES (1, 26, 1151524187, 1);
INSERT INTO `results_game` VALUES (1, 27, 1151524187, 1);
INSERT INTO `results_game` VALUES (1, 29, 1151524187, 1);
INSERT INTO `results_game` VALUES (1, 30, 1151524187, 1);
INSERT INTO `results_game` VALUES (1, 31, 1151524187, 1);
INSERT INTO `results_game` VALUES (1, 14, 1151524618, 1);
INSERT INTO `results_game` VALUES (1, 1, 1151616388, 1);
INSERT INTO `results_game` VALUES (1, 4, 1151616388, 1);
INSERT INTO `results_game` VALUES (1, 6, 1151616388, 1);
INSERT INTO `results_game` VALUES (1, 7, 1151616388, 1);
INSERT INTO `results_game` VALUES (1, 9, 1151616388, 1);
INSERT INTO `results_game` VALUES (1, 14, 1151616388, 1);
INSERT INTO `results_game` VALUES (1, 15, 1151616388, 1);
INSERT INTO `results_game` VALUES (1, 16, 1151616388, 1);
INSERT INTO `results_game` VALUES (1, 19, 1151616388, 1);
INSERT INTO `results_game` VALUES (1, 21, 1151616388, 1);
INSERT INTO `results_game` VALUES (1, 23, 1151616388, 1);
INSERT INTO `results_game` VALUES (1, 25, 1151616388, 1);
INSERT INTO `results_game` VALUES (1, 2, 1151699329, 1);
INSERT INTO `results_game` VALUES (1, 3, 1151699329, 1);
INSERT INTO `results_game` VALUES (1, 10, 1151699329, 1);
INSERT INTO `results_game` VALUES (1, 15, 1151699329, 1);
INSERT INTO `results_game` VALUES (1, 18, 1151699329, 1);
INSERT INTO `results_game` VALUES (1, 27, 1151699329, 1);
INSERT INTO `results_game` VALUES (1, 4, 1151776292, 1);
INSERT INTO `results_game` VALUES (1, 7, 1151776292, 1);
INSERT INTO `results_game` VALUES (1, 9, 1151776292, 1);
INSERT INTO `results_game` VALUES (1, 16, 1151776292, 1);
INSERT INTO `results_game` VALUES (1, 19, 1151776292, 1);
INSERT INTO `results_game` VALUES (1, 1, 1151793380, 1);
INSERT INTO `results_game` VALUES (1, 26, 1151793380, 2);
INSERT INTO `results_game` VALUES (1, 1, 1151949789, 1);
INSERT INTO `results_game` VALUES (1, 2, 1151949789, 1);
INSERT INTO `results_game` VALUES (1, 3, 1151949789, 1);
INSERT INTO `results_game` VALUES (1, 4, 1151949789, 1);
INSERT INTO `results_game` VALUES (1, 7, 1151949789, 1);
INSERT INTO `results_game` VALUES (1, 27, 1151949789, 1);
INSERT INTO `results_game` VALUES (1, 1, 1152037443, 1);
INSERT INTO `results_game` VALUES (1, 2, 1152037443, 1);
INSERT INTO `results_game` VALUES (1, 3, 1152037443, 1);
INSERT INTO `results_game` VALUES (1, 4, 1152037443, 1);
INSERT INTO `results_game` VALUES (1, 1, 1152214556, 1);
INSERT INTO `results_game` VALUES (1, 3, 1152214556, 1);
INSERT INTO `results_game` VALUES (1, 1, 1152373161, 1);

-- --------------------------------------------------------

-- 
-- Структура таблицы `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  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2 ;

-- 
-- Дамп данных таблицы `superadmin`
-- 

INSERT INTO `superadmin` VALUES (1, '123', '202cb962ac59075b964b07152d234b70');

-- --------------------------------------------------------

-- 
-- Структура таблицы `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 DEFAULT CHARSET=cp1251;

-- 
-- Дамп данных таблицы `team_in_tour`
-- 

INSERT INTO `team_in_tour` VALUES (2, 1, 1, 1151114763);
INSERT INTO `team_in_tour` VALUES (5, 1, 3, 1151127981);
INSERT INTO `team_in_tour` VALUES (6, 1, 4, 1151128334);
INSERT INTO `team_in_tour` VALUES (7, 1, 5, 1151128657);
INSERT INTO `team_in_tour` VALUES (8, 1, 6, 1151129668);
INSERT INTO `team_in_tour` VALUES (10, 1, 7, 1151131568);
INSERT INTO `team_in_tour` VALUES (12, 1, 9, 1151133729);
INSERT INTO `team_in_tour` VALUES (11, 1, 8, 1151133805);
INSERT INTO `team_in_tour` VALUES (13, 1, 10, 1151142154);
INSERT INTO `team_in_tour` VALUES (14, 1, 11, 1151144270);
INSERT INTO `team_in_tour` VALUES (17, 1, 13, 1151157433);
INSERT INTO `team_in_tour` VALUES (19, 1, 14, 1151157721);
INSERT INTO `team_in_tour` VALUES (20, 1, 15, 1151160579);
INSERT INTO `team_in_tour` VALUES (3, 1, 2, 1151161780);
INSERT INTO `team_in_tour` VALUES (23, 1, 16, 1151176952);
INSERT INTO `team_in_tour` VALUES (24, 1, 17, 1151208551);
INSERT INTO `team_in_tour` VALUES (25, 1, 18, 1151208911);
INSERT INTO `team_in_tour` VALUES (26, 1, 19, 1151212168);
INSERT INTO `team_in_tour` VALUES (27, 1, 20, 1151215272);
INSERT INTO `team_in_tour` VALUES (28, 1, 21, 1151215634);
INSERT INTO `team_in_tour` VALUES (30, 1, 22, 1151215761);
INSERT INTO `team_in_tour` VALUES (32, 1, 23, 1151215951);
INSERT INTO `team_in_tour` VALUES (35, 1, 24, 1151217892);
INSERT INTO `team_in_tour` VALUES (36, 1, 25, 1151221497);
INSERT INTO `team_in_tour` VALUES (39, 1, 26, 1151234576);
INSERT INTO `team_in_tour` VALUES (40, 1, 27, 1151234924);
INSERT INTO `team_in_tour` VALUES (41, 1, 28, 1151235225);
INSERT INTO `team_in_tour` VALUES (42, 1, 29, 1151235835);
INSERT INTO `team_in_tour` VALUES (43, 1, 30, 1151236212);
INSERT INTO `team_in_tour` VALUES (44, 1, 31, 1151236629);
INSERT INTO `team_in_tour` VALUES (46, 1, 32, 1151236962);
INSERT INTO `team_in_tour` VALUES (47, 1, 33, 1151237320);
INSERT INTO `team_in_tour` VALUES (48, 1, 34, 1151237753);
INSERT INTO `team_in_tour` VALUES (50, 1, 36, 1151238304);
INSERT INTO `team_in_tour` VALUES (51, 1, 37, 1151241681);
INSERT INTO `team_in_tour` VALUES (52, 1, 38, 1151246550);
INSERT INTO `team_in_tour` VALUES (53, 1, 39, 1151253326);
INSERT INTO `team_in_tour` VALUES (56, 1, 40, 1151259165);
INSERT INTO `team_in_tour` VALUES (57, 1, 41, 1151265760);
INSERT INTO `team_in_tour` VALUES (58, 1, 42, 1151268135);
INSERT INTO `team_in_tour` VALUES (61, 1, 43, 1151308194);
INSERT INTO `team_in_tour` VALUES (62, 1, 44, 1151314636);
INSERT INTO `team_in_tour` VALUES (63, 1, 45, 1151318142);
INSERT INTO `team_in_tour` VALUES (65, 1, 47, 1151323020);
INSERT INTO `team_in_tour` VALUES (66, 1, 48, 1151323521);
INSERT INTO `team_in_tour` VALUES (67, 1, 49, 1151323822);
INSERT INTO `team_in_tour` VALUES (68, 1, 50, 1151328732);
INSERT INTO `team_in_tour` VALUES (72, 1, 52, 1151416342);
INSERT INTO `team_in_tour` VALUES (76, 1, 54, 1151441627);
INSERT INTO `team_in_tour` VALUES (75, 1, 53, 1151441926);
INSERT INTO `team_in_tour` VALUES (77, 1, 55, 1151443429);
INSERT INTO `team_in_tour` VALUES (78, 1, 56, 1151444014);
INSERT INTO `team_in_tour` VALUES (79, 1, 57, 1151483521);
INSERT INTO `team_in_tour` VALUES (82, 1, 58, 1151512558);
INSERT INTO `team_in_tour` VALUES (85, 1, 59, 1151912062);
INSERT INTO `team_in_tour` VALUES (87, 1, 60, 1152109935);

-- --------------------------------------------------------

-- 
-- Структура таблицы `tournament`
-- 

CREATE TABLE `tournament` (
  `id_tour` int(10) unsigned NOT NULL auto_increment,
  `date` int(10) unsigned NOT NULL default '0',
  `name` varchar(50) NOT NULL default '',
  `period` int(10) unsigned NOT NULL default '7',
  PRIMARY KEY  (`id_tour`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2 ;

-- 
-- Дамп данных таблицы `tournament`
-- 

INSERT INTO `tournament` VALUES (1, 1151102107, 'Wimbledon', 17);

-- --------------------------------------------------------

-- 
-- Структура таблицы `users`
-- 

CREATE TABLE `users` (
  `id_user` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(30) 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  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=127 ;

-- 
-- Дамп данных таблицы `users`
-- 

INSERT INTO `users` VALUES (1, 'Fanat', '777', 3, '202cb962ac59075b964b07152d234b70');
INSERT INTO `users` VALUES (2, 'Россияночка', ':-)', 3, '1bf0c59238dd24a7f09a889483a50e8f');
INSERT INTO `users` VALUES (3, 'RADостная', 'Dream', 3, '0d9095b0d6bbe98ea0c9c02b11b59ee3');
INSERT INTO `users` VALUES (4, 'Гуффыч', '+79202046830', 3, '0d7363894acdee742caf7fe4e97c4d49');
INSERT INTO `users` VALUES (5, 'Абракадабра', '89058564841', 3, '59d972d8c46696f60b0a896dc614ea07');
INSERT INTO `users` VALUES (6, 'Мр.Гуди', '89058564841', 3, '99eae776665f78391048c43328a6f43e');
INSERT INTO `users` VALUES (7, 'Паровоз', '89058564841', 3, '5202b919098b65fabf90585931fad4e5');
INSERT INTO `users` VALUES (8, 'Aido4ka', 'Tennis', 3, '3c5e6a77b69935b74da797ff18428f82');
INSERT INTO `users` VALUES (9, 'Farseer', 'Провидец б/п', 3, '47e7fdb0ab1113aaef1f5029de4792b0');
INSERT INTO `users` VALUES (10, 'Aida', 'Tennis', 3, '77f20779238297b0e964329b9d7b6773');
INSERT INTO `users` VALUES (11, 'McLaren', 'С„1', 3, '28187f5ceb01f0fdf60e873520fc60ed');
INSERT INTO `users` VALUES (12, 'McLaren2', '1', 3, '28187f5ceb01f0fdf60e873520fc60ed');
INSERT INTO `users` VALUES (13, 'МартыС?РєР°', '89058564841', 3, 'ecc22608bae9a147b69c1fd417d7c7c5');
INSERT INTO `users` VALUES (14, 'Кудесник мяча', '89058564841', 3, 'abadfc0b7db233caadda3f0a5c36c6aa');
INSERT INTO `users` VALUES (15, 'Sharapova', 'Prosto Maria', 3, 'eeafbf4d9b3957b139da7b7f2e7f2d4a');
INSERT INTO `users` VALUES (16, 'Marisha', 'Maria', 3, 'eeafbf4d9b3957b139da7b7f2e7f2d4a');
INSERT INTO `users` VALUES (17, 'gruzin', ' 1', 3, 'b8c37e33defde51cf91e1e03e51657da');
INSERT INTO `users` VALUES (18, 'Frog', 'Фрог', 3, 'c81e728d9d4c2f636f067f89cc14862c');
INSERT INTO `users` VALUES (19, 'kokkai', 'gruzin', 3, 'b8c37e33defde51cf91e1e03e51657da');
INSERT INTO `users` VALUES (20, 'Devil', 'I am a king of Evil', 3, '0c493d20a11930e4980725d94b0203ec');
INSERT INTO `users` VALUES (21, 'Р?РіРѕСЂСЊ', 'РљРѕС‚', 3, 'abf033446f36309ded1a703debe807f9');
INSERT INTO `users` VALUES (22, 'Гуффыч1', '+79202046830', 3, 'f679c130bcefdee7ab4007238199b0b8');
INSERT INTO `users` VALUES (23, 'nemec', 'gruzin ya', 3, 'b8c37e33defde51cf91e1e03e51657da');
INSERT INTO `users` VALUES (24, 'Dennis', 'Kras', 3, '96e79218965eb72c92a549dd5a330112');
INSERT INTO `users` VALUES (25, 'Den', 'Gras', 3, '96e79218965eb72c92a549dd5a330112');
INSERT INTO `users` VALUES (26, 'Гуффыч2', '+79202046830', 3, 'f679c130bcefdee7ab4007238199b0b8');
INSERT INTO `users` VALUES (27, 'Frogg', 'Фрог', 3, 'c81e728d9d4c2f636f067f89cc14862c');
INSERT INTO `users` VALUES (28, 'Zverr', 'Зверь', 3, 'c81e728d9d4c2f636f067f89cc14862c');
INSERT INTO `users` VALUES (29, 'Makc', 'Futbolist', 3, '4ceb031dd299313493c0aa61cd28ebd2');
INSERT INTO `users` VALUES (30, 'Ruben', 'Futbolist', 3, '4ceb031dd299313493c0aa61cd28ebd2');
INSERT INTO `users` VALUES (31, 'Goo!', 'Гу', 3, 'c81e728d9d4c2f636f067f89cc14862c');
INSERT INTO `users` VALUES (32, 'raf', 'Futbolist', 3, '4ceb031dd299313493c0aa61cd28ebd2');
INSERT INTO `users` VALUES (33, 'Gooo!', 'Гу', 3, 'c81e728d9d4c2f636f067f89cc14862c');
INSERT INTO `users` VALUES (34, 'Гул', 'Гул', 3, 'c81e728d9d4c2f636f067f89cc14862c');
INSERT INTO `users` VALUES (35, 'Rad', 'No comments', 3, '4a7d1ed414474e4033ac29ccb8653d9b');
INSERT INTO `users` VALUES (36, 'Sparta', 'Gmgmg', 3, '1728d316289a8302c0438a42389e8eb0');
INSERT INTO `users` VALUES (37, 'Dynamo', 'MmM', 3, '90172b5a229214a431a4352c66865e89');
INSERT INTO `users` VALUES (38, 'SLR', '[email protected]', 3, 'e10adc3949ba59abbe56e057f20f883e');
INSERT INTO `users` VALUES (39, 'G!', 'Фан', 3, 'c81e728d9d4c2f636f067f89cc14862c');
INSERT INTO `users` VALUES (40, 'Gorec', 'Р?РіСЂРѕРє', 3, 'c81e728d9d4c2f636f067f89cc14862c');
INSERT INTO `users` VALUES (41, 'GogMan', 'Фанат', 3, 'c81e728d9d4c2f636f067f89cc14862c');
INSERT INTO `users` VALUES (42, '2006', 'Фанат', 3, 'c81e728d9d4c2f636f067f89cc14862c');
INSERT INTO `users` VALUES (43, 'Zmey', 'Фан', 3, 'c81e728d9d4c2f636f067f89cc14862c');
INSERT INTO `users` VALUES (44, 'Demon', 'Фан', 3, 'c81e728d9d4c2f636f067f89cc14862c');
INSERT INTO `users` VALUES (45, 'Николай', 'Ultrаs', 3, 'c03baa828807081e0772395e2b69a2e9');
INSERT INTO `users` VALUES (46, 'Warhan', 'Фан', 3, 'c81e728d9d4c2f636f067f89cc14862c');
INSERT INTO `users` VALUES (47, '2006/2', 'Фан', 3, 'c81e728d9d4c2f636f067f89cc14862c');
INSERT INTO `users` VALUES (48, 'Gogl', 'Фан', 3, 'c81e728d9d4c2f636f067f89cc14862c');
INSERT INTO `users` VALUES (49, 'Gogl2', 'Фан', 3, 'c81e728d9d4c2f636f067f89cc14862c');
INSERT INTO `users` VALUES (50, 'Gogl2!', 'Фан', 3, 'c81e728d9d4c2f636f067f89cc14862c');
INSERT INTO `users` VALUES (51, 'bayern', 'mГјnchen', 3, 'b8c37e33defde51cf91e1e03e51657da');
INSERT INTO `users` VALUES (52, 'Aida4', 'Tf', 3, 'da51812fc31e64a70d65901a93316fcf');
INSERT INTO `users` VALUES (53, 'Winston', '89028346559', 3, 'eccbc87e4b5ce2fe28308fd9f2a7baf3');
INSERT INTO `users` VALUES (54, 'cayenne', 'Люблю спорт!!', 3, 'a591024321c5e2bdbd23ed35f0574dde');
INSERT INTO `users` VALUES (55, 'ТЮНЯ', '89082791347', 3, 'a87ff679a2f3e71d9181a67b7542122c');
INSERT INTO `users` VALUES (56, 'MURATTI', '89082791347', 3, 'a87ff679a2f3e71d9181a67b7542122c');
INSERT INTO `users` VALUES (57, 'Mazda3Sport', '.', 3, '8e24a6a0424e0f906c04afc02cbc629d');
INSERT INTO `users` VALUES (58, 'SLR_McLaren', '[email protected]', 3, 'e10adc3949ba59abbe56e057f20f883e');
INSERT INTO `users` VALUES (59, 'art', '8', 3, 'b53b3a3d6ab90ce0268229151c9bde11');
INSERT INTO `users` VALUES (60, 'Weed', '.', 3, '3cd80d0a6c46d32949bfc10e7d96fffa');
INSERT INTO `users` VALUES (61, 'Джоник', '89065705527', 3, '1205c768d3663a9b1825f2c25b08c6ed');
INSERT INTO `users` VALUES (62, 'РЎРєСЂСѓРґР¶', '89202061644', 3, '6074c6aa3488f3c2dddff2a7ca821aab');
INSERT INTO `users` VALUES (63, 'Черный', '89168452010', 3, 'fae0b27c451c728867a567e8c1bb4e53');
INSERT INTO `users` VALUES (64, 'Robo', '.', 3, '77abd30fcb72e52b91cdfca2b75789d6');
INSERT INTO `users` VALUES (65, 'РћС?РёР±СЃСЏ', '.', 3, '77abd30fcb72e52b91cdfca2b75789d6');
INSERT INTO `users` VALUES (66, 'Imago', '.', 3, '06d86297d6e28d4637d60c86c2a2f5b6');
INSERT INTO `users` VALUES (67, 'Boss', 'Украина ВПЕРЕД!', 3, 'a33f5792b2a9a51ddd0111b3ac6e0e76');
INSERT INTO `users` VALUES (68, 'Санек', 'Спортсмен', 3, 'd921c3c762b1522c475ac8fc0811bb0f');
INSERT INTO `users` VALUES (69, 'Alf', 'qqq', 3, '27ed0fb950b856b06e1273989422e7d3');
INSERT INTO `users` VALUES (70, '11', '11', 3, '1728d316289a8302c0438a42389e8eb0');
INSERT INTO `users` VALUES (71, 'youran', '89056801490', 3, '74b0d3cea40b43c752353bd62928a19d');
INSERT INTO `users` VALUES (72, 'vedma101', '', 3, 'ffc150a160d37e92012c196b6af4160d');
INSERT INTO `users` VALUES (73, 'Никола', 'SS', 3, 'db962922aae4e3a78a7e0cf3f68dcad3');
INSERT INTO `users` VALUES (74, 'FР°nat', '11', 3, '202cb962ac59075b964b07152d234b70');
INSERT INTO `users` VALUES (75, 'Фараон', '1', 3, '202cb962ac59075b964b07152d234b70');
INSERT INTO `users` VALUES (76, 'Faraon', '1', 3, '202cb962ac59075b964b07152d234b70');
INSERT INTO `users` VALUES (77, 'FANAРў', '1', 3, 'c4ca4238a0b923820dcc509a6f75849b');
INSERT INTO `users` VALUES (78, 'Alexey', '1', 3, 'c4ca4238a0b923820dcc509a6f75849b');
INSERT INTO `users` VALUES (79, 'Котик', '89092305438', 3, '49039e538b5cb0e2b8fb90b41fb245df');
INSERT INTO `users` VALUES (80, 'Jazi', 'T', 3, '071642fa72ba780ee90ed36350d82745');
INSERT INTO `users` VALUES (81, 'PSV', 'T', 3, '5058f1af8388633f609cadb75a75dc9d');
INSERT INTO `users` VALUES (82, 'psv.', 'G', 3, '7fc56270e7a70fa81a5935b72eacbe29');
INSERT INTO `users` VALUES (83, 'Ультрас', '@', 3, '8426a3ca7818a899452173f616704da0');
INSERT INTO `users` VALUES (84, 'Sergoli', 'Tenisist', 3, '5da16b711bd0ea1437c3623843fc51ab');
INSERT INTO `users` VALUES (85, 'Az', '.', 3, '5058f1af8388633f609cadb75a75dc9d');
INSERT INTO `users` VALUES (86, 'Stt', 'Stt', 3, '48cb136b65a69e8c2aa22913a0d91b2f');
INSERT INTO `users` VALUES (87, 'kiefer', 'я и в реале в теннис', 3, '2d95666e2649fcfc6e3af75e09f5adb9');
INSERT INTO `users` VALUES (88, 'РќРёРєРёС?РєР°', 'Пермь', 3, '00b7691d86d96aebd21dd9e138f90840');
INSERT INTO `users` VALUES (89, 'carlyle', 'gg', 3, '2d95666e2649fcfc6e3af75e09f5adb9');
INSERT INTO `users` VALUES (90, 'Serega.', 'Yo!', 3, 'f7f9769fb3db921de44de7021bda1779');
INSERT INTO `users` VALUES (91, 'Dina', 'Шарапова супер!', 3, '81059fd3155ea822eb0a23089c76c218');
INSERT INTO `users` VALUES (92, 'Sergey44', '80679509713', 3, '1e021102c9bdce7d032a72de7acdc78d');
INSERT INTO `users` VALUES (93, 'Sharap6630', 'I Love Sharapova', 3, 'd54773de6159de2c877d872e4ffe1a33');
INSERT INTO `users` VALUES (94, 'Sectorr', 'Р›/Р°', 3, 'f38fef4c0e4988792723c29a0bd3ca98');
INSERT INTO `users` VALUES (95, 'Белый 1', '89087344246', 3, 'ff4badcd0242318a31ba1c02a0c2beec');
INSERT INTO `users` VALUES (96, 'Xaac', 'xaac', 3, '885db9a9d0ddc26353d75955ff2b7ee0');
INSERT INTO `users` VALUES (97, 'ГАМЗАТ', '+79285166277', 3, 'bd50a8d205a71429eeaed81e1300e52a');
INSERT INTO `users` VALUES (98, 'DMITRO', 'XXX', 3, 'e0ce58c026a0c0cfbddbf5b65f40cef3');
INSERT INTO `users` VALUES (99, 'Bad', '.', 3, '7ff3e75ce6aca348bc513ed3d5882946');
INSERT INTO `users` VALUES (100, 'Белый', '89087344246', 3, '6d4a54ecd4c54d7e5177879db99699a0');
INSERT INTO `users` VALUES (101, 'Payne', 'Хочу на Кубу!', 3, '0e411e1bbaba90b26c1cf25142cf4457');
INSERT INTO `users` VALUES (102, 'Владик', 'Dexter', 3, 'a33f9f0c903bbf46a238e294ca71756b');
INSERT INTO `users` VALUES (103, 'Martina', 'Best', 3, '4a7d1ed414474e4033ac29ccb8653d9b');
INSERT INTO `users` VALUES (104, 'Alizee', 'Best', 3, '4a7d1ed414474e4033ac29ccb8653d9b');
INSERT INTO `users` VALUES (117, 'РљР?Р Р?ЛЛ', 'ЗАЧЕМ.', 3, '617def4e722614012c497900689cb7db');
INSERT INTO `users` VALUES (111, 'Агаси', 'К700і', 3, '008bd5ad93b754d500338c253d9c1770');
INSERT INTO `users` VALUES (110, 'Андрей', '?', 3, 'fd5c905bcd8c3348ad1b35d7231ee2b1');
INSERT INTO `users` VALUES (105, 'Dex', 'Dexterious', 3, '7c208634b2c9167bb028f5c056a3d5cf');
INSERT INTO `users` VALUES (106, 'X-team', 'X-team', 3, '4594f2061ea516ecbae2e0a74982a6c9');
INSERT INTO `users` VALUES (107, 'Muron', 'Durdom', 3, 'c4ca4238a0b923820dcc509a6f75849b');
INSERT INTO `users` VALUES (108, 'Yurka', 'Cx75', 3, '8408c7979ec8ffd9a81ce43b534a452b');
INSERT INTO `users` VALUES (109, 'frodo', 'Frodo', 3, '9e94b15ed312fa42232fd87a55db0d39');
INSERT INTO `users` VALUES (118, 'РЎРђРЁРђ', 'РќР• РЎРљРђР–РЈ', 3, '6074c6aa3488f3c2dddff2a7ca821aab');
INSERT INTO `users` VALUES (112, 'РАУЛЬ', 'RAUL', 3, '2303ab1d8da34cbdcc140b0e81828307');
INSERT INTO `users` VALUES (113, 'Sharap', '.', 3, 'd54773de6159de2c877d872e4ffe1a33');
INSERT INTO `users` VALUES (114, 'Рђ', 'Рђ', 3, 'c81e728d9d4c2f636f067f89cc14862c');
INSERT INTO `users` VALUES (115, 'baxit', 'jgtmagtmgtma', 3, '700a68914222d6cd4e187cbe67d830d5');
INSERT INTO `users` VALUES (116, 'Серый', 'А', 3, 'b59c67bf196a4758191e42f76670ceba');
INSERT INTO `users` VALUES (119, 'JohnAntoni', 'Cx75', 3, 'c5c71ef59093022c128c68ea485fb243');
INSERT INTO `users` VALUES (120, 'Sergei', '80504257789', 3, '7cd86ecb09aa48c6e620b340f6a74592');
INSERT INTO `users` VALUES (121, 'Vaduc', '[email protected]', 3, '4ebe7c58bc215459085a6bb82be271c0');
INSERT INTO `users` VALUES (122, ' ilya', 'Mne 18let', 3, 'd183d7aafd7115b1d044d0e1bac1ddd4');
INSERT INTO `users` VALUES (123, ' ily', 'Mne 18let', 3, '89259aa609b56f68b14777a538070ae8');
INSERT INTO `users` VALUES (124, 'Fred', 'Mne 18let', 3, '35ce62fb4cb7dca5698950d19648701a');
INSERT INTO `users` VALUES (125, 'евгений', 'mu-the best!', 3, 'f58d6788785b23a81cd60a02d48814b6');
INSERT INTO `users` VALUES (126, 'evgeni', '!go Maria go!', 3, 'f58d6788785b23a81cd60a02d48814b6');

-- --------------------------------------------------------

-- 
-- Структура таблицы `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  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=82 ;

-- 
-- Дамп данных таблицы `users_team`
-- 

INSERT INTO `users_team` VALUES (1, 2, '5;9;14;17;30');
INSERT INTO `users_team` VALUES (2, 3, '8;12;13;14;15');
INSERT INTO `users_team` VALUES (3, 5, '4;7;9;14');
INSERT INTO `users_team` VALUES (4, 6, '2;3;15;24');
INSERT INTO `users_team` VALUES (5, 7, '2;5;12;27');
INSERT INTO `users_team` VALUES (6, 8, '4;10;12;16');
INSERT INTO `users_team` VALUES (7, 10, '13;14;15;16;18;19;29');
INSERT INTO `users_team` VALUES (8, 11, '4;5;10');
INSERT INTO `users_team` VALUES (9, 12, '1;2;8');
INSERT INTO `users_team` VALUES (10, 13, '7;9;12;14;15');
INSERT INTO `users_team` VALUES (11, 14, '14;15;17;22;25;29;30');
INSERT INTO `users_team` VALUES (12, 16, '4;7;9;15');
INSERT INTO `users_team` VALUES (13, 17, '4;9;15;19');
INSERT INTO `users_team` VALUES (14, 19, '7;13;14;15;19;23;30');
INSERT INTO `users_team` VALUES (15, 20, '2;4;10');
INSERT INTO `users_team` VALUES (16, 23, '13;14;16;17;24;27;29;30');
INSERT INTO `users_team` VALUES (17, 24, '1;4;15;17');
INSERT INTO `users_team` VALUES (18, 25, '7;9;14;15;17;31');
INSERT INTO `users_team` VALUES (19, 26, '5;7;9;12');
INSERT INTO `users_team` VALUES (20, 27, '1;14;15;17;25;30');
INSERT INTO `users_team` VALUES (21, 28, '4;7;11;14;31');
INSERT INTO `users_team` VALUES (22, 30, '10;12;19;22;26;28');
INSERT INTO `users_team` VALUES (23, 32, '2;3;12');
INSERT INTO `users_team` VALUES (24, 35, '13;14;15;17;19;21;22');
INSERT INTO `users_team` VALUES (25, 36, '4;9;10;31');
INSERT INTO `users_team` VALUES (26, 39, '9;11;12;25;28;30');
INSERT INTO `users_team` VALUES (27, 40, '5;7;8;14;25');
INSERT INTO `users_team` VALUES (28, 41, '4;11;14;15;25');
INSERT INTO `users_team` VALUES (29, 42, '1;7;9;14;24');
INSERT INTO `users_team` VALUES (30, 43, '2;7;11;14;25');
INSERT INTO `users_team` VALUES (31, 44, '7;9;14;17;18;25');
INSERT INTO `users_team` VALUES (32, 46, '5;14;15');
INSERT INTO `users_team` VALUES (33, 47, '3;14;17;25;30');
INSERT INTO `users_team` VALUES (34, 48, '5;7;10;14;24');
INSERT INTO `users_team` VALUES (35, 49, '7;10;14');
INSERT INTO `users_team` VALUES (36, 50, '3;7;10;14');
INSERT INTO `users_team` VALUES (37, 51, '16;17;18;21;23;24;27;29;30');
INSERT INTO `users_team` VALUES (38, 52, '13;14;15;19;20;29');
INSERT INTO `users_team` VALUES (39, 53, '11;13;14;15;16;19;22');
INSERT INTO `users_team` VALUES (40, 56, '7;9;17;22;29;30');
INSERT INTO `users_team` VALUES (41, 57, '2;3;12');
INSERT INTO `users_team` VALUES (42, 58, '1;12;14;26;27;28');
INSERT INTO `users_team` VALUES (43, 61, '4;9;14;28;29');
INSERT INTO `users_team` VALUES (44, 62, '11;12;13;14;16;27;31');
INSERT INTO `users_team` VALUES (45, 63, '1;5;9;14');
INSERT INTO `users_team` VALUES (46, 64, '5;11;12');
INSERT INTO `users_team` VALUES (47, 65, '8;11;12;15;19;27');
INSERT INTO `users_team` VALUES (48, 66, '5;10;16;23;24;28;31');
INSERT INTO `users_team` VALUES (49, 67, '9;12;15;17;23;25');
INSERT INTO `users_team` VALUES (50, 68, '4;6;12');
INSERT INTO `users_team` VALUES (51, 70, '3;8;12;15');
INSERT INTO `users_team` VALUES (52, 72, '3;5;7;16');
INSERT INTO `users_team` VALUES (53, 75, '8;12;14;17;21;22');
INSERT INTO `users_team` VALUES (54, 76, '16;17;22;23;26;27;28;30;31');
INSERT INTO `users_team` VALUES (55, 77, '18;19;20;23;24;27;28;30;31');
INSERT INTO `users_team` VALUES (56, 78, '10;12;15;16;25;27');
INSERT INTO `users_team` VALUES (57, 79, '4;9;24;27;31');
INSERT INTO `users_team` VALUES (58, 82, '1;4;5');
INSERT INTO `users_team` VALUES (59, 85, '1;3;16;27;31');
INSERT INTO `users_team` VALUES (60, 87, '4;10;17');
INSERT INTO `users_team` VALUES (61, 89, '1;3;5');
INSERT INTO `users_team` VALUES (62, 90, '1;3;12');
INSERT INTO `users_team` VALUES (63, 94, '1;5;7;8');
INSERT INTO `users_team` VALUES (64, 95, '2;4;12');
INSERT INTO `users_team` VALUES (65, 97, '4;7;9;14');
INSERT INTO `users_team` VALUES (66, 100, '1;4;7;16');
INSERT INTO `users_team` VALUES (67, 103, '2;3;12');
INSERT INTO `users_team` VALUES (68, 104, '1;3;12');
INSERT INTO `users_team` VALUES (69, 105, '4;7;14;17;30');
INSERT INTO `users_team` VALUES (70, 106, '4;7;14;17;30');
INSERT INTO `users_team` VALUES (71, 108, '4;7;10;26');
INSERT INTO `users_team` VALUES (72, 109, '4;7;14;25;27');
INSERT INTO `users_team` VALUES (73, 111, '12');
INSERT INTO `users_team` VALUES (74, 115, '8;10;15;19;21;26');
INSERT INTO `users_team` VALUES (75, 116, '4;7;12;15');
INSERT INTO `users_team` VALUES (76, 118, '2;9;12;15');
INSERT INTO `users_team` VALUES (77, 119, '5;7;8;14;20');
INSERT INTO `users_team` VALUES (78, 120, '2;3;12');
INSERT INTO `users_team` VALUES (79, 121, '12');
INSERT INTO `users_team` VALUES (80, 124, '1;4;12');
INSERT INTO `users_team` VALUES (81, 126, '4;7;10;17');