PHP/MySQL | очистка базы
timeadv_ru 
EagleX OZZY (05.06.2015 в 12:56)
EagleX (05.06.2015 в 12:54)
OZZY (05.06.2015 в 10:44)
EagleX (05.06.2015 в 10:12)
проше через phpAdmin почистить чем сидеть и удалять на нотепаде
Сам то понял что написал? Играть в чай, пить игру?
что такого? чистить таблы не умеем без запросов? ))
В блокноте запросами? Вот это бредятину несёшь
EagleX (05.06.2015 в 12:54)
OZZY (05.06.2015 в 10:44)
EagleX (05.06.2015 в 10:12)
проше через phpAdmin почистить чем сидеть и удалять на нотепаде
Сам то понял что написал? Играть в чай, пить игру?
что такого? чистить таблы не умеем без запросов? ))
В блокноте запросами? Вот это бредятину несёшь
чем читаем? через phpmyadmin говорю, дак нет читаем же только что под носом
IdFox, держи
-- MySQL dump 10.13 Distrib 5.5.40-36.1, for Linux (x86_64)
--
-- Host: localhost Database: uhe789_bt
-- ------------------------------------------------------
-- Server version 5.5.40-36.1-log
/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `arena`
--
DROP TABLE IF EXISTS `arena`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `arena` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL DEFAULT '0',
`opponent` int(11) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=cp1251;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `arena`
--
LOCK TABLES `arena` WRITE;
/*!40000 ALTER TABLE `arena` DISABLE KEYS */;
INSERT INTO `arena` VALUES (1,2,1,1420612959),(2,3,8,1420616747),(3,4,1,1420613889),(4,5,16,1420618643),(5,1,6,0),(6,7,2,0),(7,8,12,1420617419),(8,10,2,0),(9,14,2,1420617072),(10,16,6,1420618903),(11,21,9,1420619790),(12,20,29,1420627461),(13,23,4,1420638050),(14,29,15,0),(15,28,11,1420622841),(16,30,8,1420638971),(17,33,21,0),(18,34,23,1420639506),(19,41,10,1420626001),(20,43,2,1420627555),(21,46,21,1420628674),(22,50,13,0),(23,51,32,1420631297),(24,53,24,1420633384),(25,55,52,0),(26,56,10,1420637023),(27,57,48,1420637898),(28,60,55,1420638745),(29,63,61,0),(30,65,9,1420641493),(31,64,65,1420643439),(32,68,50,0);
/*!40000 ALTER TABLE `arena` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ban`
--
DROP TABLE IF EXISTS `ban`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ban` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL DEFAULT '0',
`ip` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ban`
--
LOCK TABLES `ban` WRITE;
/*!40000 ALTER TABLE `ban` DISABLE KEYS */;
/*!40000 ALTER TABLE `ban` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `block`
--
DROP TABLE IF EXISTS `block`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `block` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL DEFAULT '0',
`ip` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `block`
--
LOCK TABLES `block` WRITE;
/*!40000 ALTER TABLE `block` DISABLE KEYS */;
/*!40000 ALTER TABLE `block` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `boss`
--
DROP TABLE IF EXISTS `boss`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `boss` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`lvl` int(11) NOT NULL,
`sila` int(11) NOT NULL,
`health` int(11) NOT NULL,
`lovk` int(11) NOT NULL,
`zashit` int(11) NOT NULL,
`gold` int(11) NOT NULL,
`exp` int(11) NOT NULL,
`image` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `boss`
--
LOCK TABLES `boss` WRITE;
/*!40000 ALTER TABLE `boss` DISABLE KEYS */;
/*!40000 ALTER TABLE `boss` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `cave`
--
DROP TABLE IF EXISTS `cave`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cave` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL DEFAULT '0',
`dawn` enum('0','1') NOT NULL DEFAULT '0',
`res_1` int(11) NOT NULL DEFAULT '0',
`res_1_chanse` int(11) NOT NULL DEFAULT '0',
`res_2` int(11) NOT NULL DEFAULT '0',
`res_2_chanse` int(11) NOT NULL DEFAULT '0',
`res_3` int(11) NOT NULL DEFAULT '0',
`res_3_chanse` int(11) NOT NULL DEFAULT '0',
`gather` int(11) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=cp1251;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cave`
--
LOCK TABLES `cave` WRITE;
/*!40000 ALTER TABLE `cave` DISABLE KEYS */;
INSERT INTO `cave` VALUES (1,3,'1',5,5,7,7,1,25,1,1420618567),(2,5,'1',0,6,0,3,0,11,0,1420628679),(3,4,'1',0,0,0,0,0,0,0,1420615781),(4,8,'1',7,5,2,2,5,2,1,1420620303),(5,1,'0',0,0,0,0,0,0,0,0),(6,14,'1',0,0,0,0,0,0,0,1420618628),(7,16,'1',0,0,0,0,0,0,0,1420619989),(8,20,'1',7,12,1,1,6,9,1,1420629531),(9,30,'1',1,13,1,1,6,22,1,1420627786),(10,33,'1',0,0,0,0,0,0,0,1420624965),(11,34,'1',5,6,2,2,8,21,1,1420641389),(12,41,'1',0,0,0,0,0,0,0,1420627427),(13,39,'1',0,0,0,0,0,0,0,1420629186),(14,42,'0',0,0,0,0,0,0,0,0),(15,45,'0',0,0,0,0,0,0,0,0),(16,46,'1',0,0,0,0,0,0,0,1420630098),(17,57,'1',0,0,0,0,0,0,0,1420639247),(18,23,'1',0,0,0,0,0,0,0,1420639414),(19,65,'1',0,0,0,0,0,0,0,1420643564);
butter -- MySQL dump 10.13 Distrib 5.5.40-36.1, for Linux (x86_64)
--
-- Host: localhost Database: uhe789_bt
-- ------------------------------------------------------
-- Server version 5.5.40-36.1-log
/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `arena`
--
DROP TABLE IF EXISTS `arena`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `arena` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL DEFAULT '0',
`opponent` int(11) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=cp1251;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `arena`
--
LOCK TABLES `arena` WRITE;
/*!40000 ALTER TABLE `arena` DISABLE KEYS */;
INSERT INTO `arena` VALUES (1,2,1,1420612959),(2,3,8,1420616747),(3,4,1,1420613889),(4,5,16,1420618643),(5,1,6,0),(6,7,2,0),(7,8,12,1420617419),(8,10,2,0),(9,14,2,1420617072),(10,16,6,1420618903),(11,21,9,1420619790),(12,20,29,1420627461),(13,23,4,1420638050),(14,29,15,0),(15,28,11,1420622841),(16,30,8,1420638971),(17,33,21,0),(18,34,23,1420639506),(19,41,10,1420626001),(20,43,2,1420627555),(21,46,21,1420628674),(22,50,13,0),(23,51,32,1420631297),(24,53,24,1420633384),(25,55,52,0),(26,56,10,1420637023),(27,57,48,1420637898),(28,60,55,1420638745),(29,63,61,0),(30,65,9,1420641493),(31,64,65,1420643439),(32,68,50,0);
/*!40000 ALTER TABLE `arena` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ban`
--
DROP TABLE IF EXISTS `ban`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ban` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL DEFAULT '0',
`ip` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ban`
--
LOCK TABLES `ban` WRITE;
/*!40000 ALTER TABLE `ban` DISABLE KEYS */;
/*!40000 ALTER TABLE `ban` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `block`
--
DROP TABLE IF EXISTS `block`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `block` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL DEFAULT '0',
`ip` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `block`
--
LOCK TABLES `block` WRITE;
/*!40000 ALTER TABLE `block` DISABLE KEYS */;
/*!40000 ALTER TABLE `block` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `boss`
--
DROP TABLE IF EXISTS `boss`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `boss` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`lvl` int(11) NOT NULL,
`sila` int(11) NOT NULL,
`health` int(11) NOT NULL,
`lovk` int(11) NOT NULL,
`zashit` int(11) NOT NULL,
`gold` int(11) NOT NULL,
`exp` int(11) NOT NULL,
`image` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `boss`
--
LOCK TABLES `boss` WRITE;
/*!40000 ALTER TABLE `boss` DISABLE KEYS */;
/*!40000 ALTER TABLE `boss` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `cave`
--
DROP TABLE IF EXISTS `cave`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cave` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL DEFAULT '0',
`dawn` enum('0','1') NOT NULL DEFAULT '0',
`res_1` int(11) NOT NULL DEFAULT '0',
`res_1_chanse` int(11) NOT NULL DEFAULT '0',
`res_2` int(11) NOT NULL DEFAULT '0',
`res_2_chanse` int(11) NOT NULL DEFAULT '0',
`res_3` int(11) NOT NULL DEFAULT '0',
`res_3_chanse` int(11) NOT NULL DEFAULT '0',
`gather` int(11) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=cp1251;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cave`
--
LOCK TABLES `cave` WRITE;
/*!40000 ALTER TABLE `cave` DISABLE KEYS */;
INSERT INTO `cave` VALUES (1,3,'1',5,5,7,7,1,25,1,1420618567),(2,5,'1',0,6,0,3,0,11,0,1420628679),(3,4,'1',0,0,0,0,0,0,0,1420615781),(4,8,'1',7,5,2,2,5,2,1,1420620303),(5,1,'0',0,0,0,0,0,0,0,0),(6,14,'1',0,0,0,0,0,0,0,1420618628),(7,16,'1',0,0,0,0,0,0,0,1420619989),(8,20,'1',7,12,1,1,6,9,1,1420629531),(9,30,'1',1,13,1,1,6,22,1,1420627786),(10,33,'1',0,0,0,0,0,0,0,1420624965),(11,34,'1',5,6,2,2,8,21,1,1420641389),(12,41,'1',0,0,0,0,0,0,0,1420627427),(13,39,'1',0,0,0,0,0,0,0,1420629186),(14,42,'0',0,0,0,0,0,0,0,0),(15,45,'0',0,0,0,0,0,0,0,0),(16,46,'1',0,0,0,0,0,0,0,1420630098),(17,57,'1',0,0,0,0,0,0,0,1420639247),(18,23,'1',0,0,0,0,0,0,0,1420639414),(19,65,'1',0,0,0,0,0,0,0,1420643564);
-- MySQL dump 10.13 Distrib 5.5.40-36.1, for Linux (x86_64)
--
-- Host: localhost Database: uhe789_bt
-- ------------------------------------------------------
-- Server version 5.5.40-36.1-log
/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `arena`
--
DROP TABLE IF EXISTS `arena`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `arena` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL DEFAULT '0',
`opponent` int(11) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=cp1251;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `ban`
--
DROP TABLE IF EXISTS `ban`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ban` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL DEFAULT '0',
`ip` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `block`
--
DROP TABLE IF EXISTS `block`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `block` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL DEFAULT '0',
`ip` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `boss`
--
DROP TABLE IF EXISTS `boss`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `boss` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`lvl` int(11) NOT NULL,
`sila` int(11) NOT NULL,
`health` int(11) NOT NULL,
`lovk` int(11) NOT NULL,
`zashit` int(11) NOT NULL,
`gold` int(11) NOT NULL,
`exp` int(11) NOT NULL,
`image` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `cave`
--
DROP TABLE IF EXISTS `cave`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cave` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL DEFAULT '0',
`dawn` enum('0','1') NOT NULL DEFAULT '0',
`res_1` int(11) NOT NULL DEFAULT '0',
`res_1_chanse` int(11) NOT NULL DEFAULT '0',
`res_2` int(11) NOT NULL DEFAULT '0',
`res_2_chanse` int(11) NOT NULL DEFAULT '0',
`res_3` int(11) NOT NULL DEFAULT '0',
`res_3_chanse` int(11) NOT NULL DEFAULT '0',
`gather` int(11) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=cp1251;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Host: localhost Database: uhe789_bt
-- ------------------------------------------------------
-- Server version 5.5.40-36.1-log
/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `arena`
--
DROP TABLE IF EXISTS `arena`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `arena` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL DEFAULT '0',
`opponent` int(11) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=cp1251;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `ban`
--
DROP TABLE IF EXISTS `ban`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ban` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL DEFAULT '0',
`ip` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `block`
--
DROP TABLE IF EXISTS `block`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `block` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL DEFAULT '0',
`ip` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `boss`
--
DROP TABLE IF EXISTS `boss`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `boss` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`lvl` int(11) NOT NULL,
`sila` int(11) NOT NULL,
`health` int(11) NOT NULL,
`lovk` int(11) NOT NULL,
`zashit` int(11) NOT NULL,
`gold` int(11) NOT NULL,
`exp` int(11) NOT NULL,
`image` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `cave`
--
DROP TABLE IF EXISTS `cave`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cave` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL DEFAULT '0',
`dawn` enum('0','1') NOT NULL DEFAULT '0',
`res_1` int(11) NOT NULL DEFAULT '0',
`res_1_chanse` int(11) NOT NULL DEFAULT '0',
`res_2` int(11) NOT NULL DEFAULT '0',
`res_2_chanse` int(11) NOT NULL DEFAULT '0',
`res_3` int(11) NOT NULL DEFAULT '0',
`res_3_chanse` int(11) NOT NULL DEFAULT '0',
`gather` int(11) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=cp1251;
/*!40101 SET character_set_client = @saved_cs_client */;
дампы убивай и нафиг)))
butter, короч файлом бд кинь, посмотрю
butter, вот попробуй
