       
/games

  

  

-- phpMyAdmin SQL Dump
-- version 2.11.4
-- http://www.phpmyadmin.net
--
-- : localhost
--  :  22 2010 ., 15:04
--  : 5.0.51
--  PHP: 5.2.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
--  : `instant`
--

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

--
--   `cms_games`
--

CREATE TABLE IF NOT EXISTS `cms_games` (
  `id` int(11) NOT NULL auto_increment COMMENT '',
  `name` varchar(100) NOT NULL COMMENT ' ',
  `link` varchar(100) NOT NULL COMMENT '  ',
  `desc` text NOT NULL COMMENT ' ',
  `last_winner` int(11) NOT NULL COMMENT ' ',
  `last_winner_score` int(11) NOT NULL COMMENT '  ',
  `best_winner` int(11) NOT NULL COMMENT ' ',
  `best_winner_score` int(11) NOT NULL COMMENT '   ',
  `count_games` int(11) NOT NULL COMMENT '  ',
  `count_score_games` int(11) NOT NULL COMMENT '  ',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=5 ;

--
--    `cms_games`
--

INSERT INTO `cms_games` (`id`, `name`, `link`, `desc`, `last_winner`, `last_winner_score`, `best_winner`, `best_winner_score`, `count_games`, `count_score_games`) VALUES
(1, ' ', 'game/neave_snake.swf', '   .     ,          (Nokia  ).      .  ,      .\r\n     .   ,      .            ..', 0, 0, 0, 0, 0, 0),
(2, '  ', 'game/neave_frogger.swf', '      ,  ,    :).      ,           (Nokia  ).      .  ,       .', 0, 0, 0, 0, 0, 0),
(3, ' ', 'game/invaders.swf', '-   .     ,            (Nokia  ).      .  ,      .', 0, 0, 0, 0, 0, 0),
(4, '  ', 'game/simon.swf', '    .       ,           (Nokia  ).      .  ,       .\r\n\r\n  ,      ', 0, 0, 0, 0, 0, 0);

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

--
--   `cms_games_scores`
--

CREATE TABLE IF NOT EXISTS `cms_games_scores` (
  `id` int(11) NOT NULL auto_increment COMMENT '',
  `id_user` int(11) NOT NULL COMMENT ' ',
  `id_game` int(11) NOT NULL,
  `score` int(11) NOT NULL COMMENT '',
  `time` datetime NOT NULL COMMENT ' ',
  `game_time` int(11) NOT NULL COMMENT '   ',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
--    `cms_games_scores`
--



