View file bclubs/install/demo.sql

-- 
-- Удаляем старые таблы
--
DROP TABLE `game_boi`;
DROP TABLE `game_chop`;
DROP TABLE `game_core`;
DROP TABLE `game_level`;
DROP TABLE `game_soper`;
DROP TABLE `user_game`;

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

CREATE TABLE IF NOT EXISTS `game_boi` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL,
  `id_sopernik` int(11) NOT NULL,
  `soper_zdor` int(11) NOT NULL default '100',
  `soper_sila` int(11) NOT NULL default '100',
  `soper_vynos` int(11) NOT NULL default '100',
  `soper_oruzie` int(11) NOT NULL default '1',
  `koll` int(11) NOT NULL default '2',
  `pobed` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
-- Структура таблицы `game_chop`
--

CREATE TABLE IF NOT EXISTS `game_chop` (
  `id` int(11) NOT NULL auto_increment,
  `name` text NOT NULL,
  `opis` varchar(2555) NOT NULL,
  `type` text NOT NULL,
  `cena` int(11) NOT NULL,
  `prib` int(11) NOT NULL,
  `fail` text NOT NULL,
  `kat_id` int(11) NOT NULL,
  `opyt` int(11) NOT NULL,
  `tip` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

CREATE TABLE IF NOT EXISTS `game_core` (
  `id` int(11) NOT NULL auto_increment,
  `p_time` int(11) NOT NULL default '600',
  `cena_boi` int(11) NOT NULL,
  `time_popol` int(11) NOT NULL default '60',
  `p_cena` int(11) NOT NULL default '200',
  `p_cena_i` int(11) NOT NULL default '400',
  `p_time_i` int(11) NOT NULL default '300',
  `opyt_boi_ower` int(11) NOT NULL default '10',
  `opyt_boi_game` int(11) NOT NULL default '50',
  `test` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2 ;

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

INSERT INTO `game_core` (`id`, `p_time`, `cena_boi`, `time_popol`, `p_cena`, `p_cena_i`, `p_time_i`, `opyt_boi_ower`, `opyt_boi_game`, `test`) VALUES
(1, 600, 500, 60, 200, 400, 300, 10, 50, 0);
--
-- Структура таблицы `game_level`
--

CREATE TABLE IF NOT EXISTS `game_level` (
  `id` int(11) NOT NULL auto_increment,
  `level` int(11) NOT NULL,
  `opyt` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

CREATE TABLE IF NOT EXISTS `game_soper` (
  `id` int(11) NOT NULL auto_increment,
  `name` text NOT NULL,
  `opis` varchar(2555) NOT NULL,
  `level` int(11) NOT NULL,
  `img` int(11) NOT NULL,
  `opyt` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

CREATE TABLE IF NOT EXISTS `user_game` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL,
  `name` text NOT NULL,
  `zdorov` int(11) NOT NULL default '100',
  `vynos` int(11) NOT NULL default '100',
  `sila` int(11) NOT NULL default '100',
  `uroven` int(11) NOT NULL default '1',
  `reiting` int(11) NOT NULL default '0',
  `pobed` int(11) NOT NULL default '0',
  `poraz` int(11) NOT NULL default '0',
  `monet` int(11) NOT NULL default '500',
  `balls` int(11) NOT NULL default '0',
  `time` int(11) NOT NULL,
  `byl` int(11) NOT NULL,
  `img` int(11) NOT NULL,
  `tip` text NOT NULL,
  `prib` int(11) NOT NULL,
  `boik` int(11) NOT NULL default '0',
  `p_zdor` int(11) NOT NULL default '100',
  `p_sily` int(11) NOT NULL default '100',
  `p_energy` int(11) NOT NULL default '100',
  `p_time` int(11) NOT NULL,
  `p_koll` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;