кто может почистить эту базу?а то чет у меня не вышло
------
73957_kolhoz.zip (1.5 Mb)
Скачиваний: 98

почищу так что нить не то чищу

Сейчас почищу

Toruz , благодарочка

-- Adminer 4.3.1 MySQL dump

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

CREATE DATABASE `kolhoz` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `kolhoz`;

DROP TABLE IF EXISTS `avatar_rating`;
CREATE TABLE `avatar_rating` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) NOT NULL,
`id_ank` int(11) NOT NULL,
`rating` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

DROP TABLE IF EXISTS `collective`;
CREATE TABLE `collective` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(24) DEFAULT NULL,
`rating` bigint(255) DEFAULT '0',
`serebro` bigint(255) DEFAULT '0',
`zolota` bigint(255) DEFAULT '2500',
`level` int(11) DEFAULT '1',
`tehnika` int(11) DEFAULT '0',
`time` int(11) DEFAULT NULL,
`time_obmen` int(11) DEFAULT '0',
`titleText` varchar(64) DEFAULT NULL,
`titleText_user` int(11) DEFAULT NULL,
`titleText_time` int(11) DEFAULT NULL,
`soil` int(11) DEFAULT '0',
`irrigate` int(11) DEFAULT '0',
`scholl` int(11) DEFAULT '0',
`vet` int(11) DEFAULT '0',
`greenhouse` int(11) DEFAULT '0',
`school` int(11) DEFAULT '0',
`rass` varchar(32) DEFAULT '0',
`treb` varchar(1024) DEFAULT 'Пусто',
`trebText_time` varchar(64) DEFAULT 'не менялись',
`clantour` int(11) DEFAULT '0',
`fishki` int(11) DEFAULT '3',
`soil_level` int(11) DEFAULT '0',
`irrigate_level` int(11) DEFAULT '0',
`scholl_level` int(11) DEFAULT '0',
`vet_level` int(11) DEFAULT '0',
`scholl_times` int(11) DEFAULT '1',
`vet_times` int(11) DEFAULT '1',
UNIQUE KEY `id` (`id`),
KEY `level` (`level`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `collective_cash`;
CREATE TABLE `collective_cash` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) DEFAULT NULL,
`id_collective` int(11) DEFAULT NULL,
`type` enum('zolota','serebro') DEFAULT 'zolota',
`time` int(11) DEFAULT '0',
`count` bigint(255) DEFAULT '0',
UNIQUE KEY `id` (`id`),
KEY `id_collective` (`id_collective`),
KEY `id_user` (`id_user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `collective_chat`;
CREATE TABLE `collective_chat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) DEFAULT NULL,
`id_collective` int(11) DEFAULT NULL,
`time` int(11) DEFAULT NULL,
`msg` varchar(10000) DEFAULT NULL,
`otvet` int(11) DEFAULT '0',
UNIQUE KEY `id` (`id`),
KEY `id_collective` (`id_collective`),
KEY `id_user` (`id_user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `collective_invite`;
CREATE TABLE `collective_invite` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) DEFAULT NULL,
`id_collective` int(11) DEFAULT NULL,
`id_who` int(11) DEFAULT NULL,
`time` int(11) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `id_user` (`id_user`),
KEY `id_collective` (`id_collective`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;