View file john2.sql

File size: 1.95Kb
-- phpMyAdmin SQL Dump
-- version 3.2.3
-- http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время создания: Апр 17 2011 г., 15:34
-- Версия сервера: 5.1.40
-- Версия PHP: 5.3.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


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

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

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

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

CREATE TABLE IF NOT EXISTS `vivod` (
  `id` int(9) NOT NULL AUTO_INCREMENT,
  `who` int(9) NOT NULL,
  `sum` float(9,2) NOT NULL,
  `status` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

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

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

CREATE TABLE IF NOT EXISTS `vopr` (
  `id` int(9) NOT NULL AUTO_INCREMENT,
  `zag` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `user` int(9) NOT NULL,
  `text` varchar(512) COLLATE utf8_unicode_ci NOT NULL,
  `vopid` int(9) NOT NULL,
  `type` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `time` int(40) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=62 ;

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

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

CREATE TABLE IF NOT EXISTS `voprset` (
  `id` int(1) NOT NULL AUTO_INCREMENT,
  `otv` float(4,2) NOT NULL,
  `vopr` float(4,2) NOT NULL,
  `lu` float(4,2) NOT NULL,
  `maxvopr` int(9) NOT NULL,
  `min` float(9,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

ALTER TABLE `users` ADD `money` FLOAT( 9, 2 ) NOT NULL