Просмотр архива BetCMS v.1.0.Beta Fix- Движок БК

-- phpMyAdmin SQL Dump
-- version 3.5.8.2
--
http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время
создания: Июл 23 2014 г., 04:07
-- Версия сервера:
5.1.72-rel14.10
-- Версия PHP: 5.2.17

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 */;

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

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

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

CREATE TABLE IF NOT EXISTS
`betting` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idsob` int(11) NOT
NULL,
  `onwhom` int(11) NOT NULL,
  `who` int(11) NOT NULL,
  `how` float
NOT NULL,
  `howwin` float NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY
KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`events` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `section` int(11) NOT
NULL,
  `team1` varchar(120) NOT NULL,
  `team2` varchar(120) NOT NULL,
 
`timestart` int(11) NOT NULL,
  `factor1` float NOT NULL,
  `factor0` float
NOT NULL,
  `factor2` float NOT NULL,
  `result` int(11) NOT NULL,
  `old`
int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `input_means` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `who`
int(11) NOT NULL,
  `how` int(11) NOT NULL,
  `type` varchar(20) NOT NULL,

 `time` int(11) NOT NULL,
  `confirm` int(11) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `output_means` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `who`
int(11) NOT NULL,
  `how` int(11) NOT NULL,
  `type` varchar(20) NOT NULL,

 `time` int(11) NOT NULL,
  `confirm` int(11) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`sections` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(120)
NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251
AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` varchar(50) NOT
NULL,
  `password` varchar(120) NOT NULL,
  `email` varchar(100) NOT NULL,

 `admin` int(1) NOT NULL,
  `full_name` varchar(120) NOT NULL,
  `wmr`
varchar(12) NOT NULL,
  `qiwi` varchar(11) NOT NULL,
  `balance` float NOT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251
AUTO_INCREMENT=1 ;

/*!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 */;