Файл: kac.sql
Строк: 47
-- phpMyAdmin SQL Dump
-- version 3.5.2.2
--
http://www.phpmyadmin.net
--
-- Хост: 127.0.0.1:3306
-- Время
создания: Фев 18 2013 г., 21:08
-- Версия сервера:
5.1.63-community-log
-- Версия 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 */;
--
--------------------------------------------------------
--
--
Структура таблицы `chat`
--
CREATE TABLE IF NOT EXISTS
`chat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` varchar(500) NOT
NULL,
`msg` varchar(500) NOT NULL,
`time` int(11) NOT NULL,
KEY `id`
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=18 ;
--
--
Структура таблицы `jurnal`
--
CREATE TABLE IF NOT EXISTS
`jurnal` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT
NULL,
`msg` varchar(500) NOT NULL,
`time` int(11) NOT NULL,
`chek`
int(11) NOT NULL,
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=13 ;
--
-- Структура таблицы
`user`
--
CREATE TABLE IF NOT EXISTS `user` (
`id` int(30) NOT NULL
AUTO_INCREMENT,
`name` varchar(21) NOT NULL,
`password` varchar(255)
NOT NULL,
`email` varchar(30) NOT NULL,
`date` int(20) NOT NULL,
`date_reg` int(20) NOT NULL,
`sila` int(11) NOT NULL,
`moneta` int(11)
NOT NULL,
`kach_time` bigint(20) NOT NULL,
`spat_time` bigint(20) NOT
NULL,
`pit_time` bigint(20) NOT NULL,
`beg_time` bigint(20) NOT NULL,
`atack_time` bigint(20) NOT NULL,
`ip` varchar(30) NOT NULL,
`status`
int(3) NOT NULL,
`likes` int(11) NOT NULL,
`like_time` int(11) NOT
NULL,
`medals` int(11) NOT NULL,
`work_time` int(11) NOT NULL,
`bon24` int(11) NOT NULL,
`energy` int(3) NOT NULL DEFAULT '100',
`energy_t` int(11) NOT NULL,
`msg` varchar(100) NOT NULL,
KEY `id`
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=24 ;
ALTER
TABLE `user` ADD `access` int(1) NOT NULL DEFAULT '2';
ALTER TABLE `user`
ADD `date_bonus` int(11) NOT NULL default '0';
ALTER TABLE `user` ADD
`day_bonus` int(11) NOT NULL default '0';
CREATE TABLE IF NOT EXISTS
`news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`us_id` int(11) NOT
NULL,
`title` varchar(255) NOT NULL,
`msg` text NOT NULL,
`date`
int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 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 */;