Просмотр архива Фото битва юзеров

-- phpMyAdmin SQL Dump
-- version 4.0.6
-- http://www.phpmyadmin.net
--
--
Хост: p110476.mysql.ihc.ru
-- Время создания: Сен 12
2013 г., 13:58
-- Версия сервера: 5.5.30-30.2-log
--
Версия PHP: 5.3.23

SET SQL_MODE =
"NO_AUTO_VALUE_ON_ZERO";
SET time_zone =
"+00:00";


/*!40101 SET
@OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET
@OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET
@OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES
utf8 */;

--
-- База данных: `p110476_facet`
--

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

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

CREATE TABLE IF NOT EXISTS
`battles` (
  `battle_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 
`winner` bigint(20) unsigned NOT NULL,
  `loser` bigint(20) unsigned NOT
NULL,
  PRIMARY KEY (`battle_id`),
  KEY `winner` (`winner`)
)
ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;

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

INSERT INTO `battles`
(`battle_id`, `winner`, `loser`) VALUES
(20, 9, 10),
(19, 9, 10),
(18, 9,
10);

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

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

CREATE TABLE IF NOT EXISTS
`images` (
  `image_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 
`filename` varchar(255) NOT NULL,
  `score` int(10) unsigned NOT NULL
DEFAULT '1500',
  `wins` int(10) unsigned NOT NULL DEFAULT '0',
  `losses`
int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`image_id`)
)
ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;

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

INSERT INTO `images` (`image_id`,
`filename`, `score`, `wins`, `losses`) VALUES
(10, 'smallgetImage.jpeg',
1467, 0, 3),
(9, 'smallgetImage2.jpeg', 1533, 3, 0);

/*!40101 SET
CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET
CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET
COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;