-- MySQL dump 10.11
--
-- Host: localhost
-- ------------------------------------------------------
-- Server version	5.0.91mm-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 `adminmail`
--

DROP TABLE IF EXISTS `adminmail`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `adminmail` (
  `mail` varchar(70) default NULL,
  `id` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1251;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `adminmail`
--

LOCK TABLES `adminmail` WRITE;
/*!40000 ALTER TABLE `adminmail` DISABLE KEYS */;
/*!40000 ALTER TABLE `adminmail` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ausers`
--

DROP TABLE IF EXISTS `ausers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ausers` (
  `id` int(11) NOT NULL auto_increment,
  `user` varchar(20) character set latin1 NOT NULL default '',
  `pass` varchar(15) character set latin1 NOT NULL default '',
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `user` (`user`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=koi8r COMMENT='InnoDB free: 10240 kB';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ausers`
--

LOCK TABLES `ausers` WRITE;
/*!40000 ALTER TABLE `ausers` DISABLE KEYS */;
INSERT INTO `ausers` (`id`, `user`, `pass`) VALUES (2,'admin','xxxx');
/*!40000 ALTER TABLE `ausers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `categories`
--

DROP TABLE IF EXISTS `categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `categories` (
  `id` int(11) NOT NULL auto_increment,
  `name1` varchar(20) character set latin1 NOT NULL default '',
  `name2` varchar(20) character set latin1 NOT NULL default '',
  `name3` varchar(20) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `rname` (`name1`),
  UNIQUE KEY `name1` (`name2`),
  UNIQUE KEY `name2` (`name2`),
  UNIQUE KEY `name1_2` (`name1`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=koi8r COMMENT='InnoDB free: 10240 kB';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `categories`
--

LOCK TABLES `categories` WRITE;
/*!40000 ALTER TABLE `categories` DISABLE KEYS */;
INSERT INTO `categories` (`id`, `name1`, `name2`, `name3`) VALUES (16,'Квартиры','Pisos - Estudios','Apartments - Flats'),(17,'Шале','Chalets','Townhouses'),(18,'Виллы','Villas','Villas'),(19,'Земля','Terrenos - Parcelas','Land - Plots'),(21,'Коммер.нед','Locales - Oficinas','Commercials'),(22,'Отели','Hoteles','Hotels'),(23,'Новостройк','Nueva construccion','New Constructions'),(24,'Элит.недв.','Viviendas de Lujo','Luxury Houses');
/*!40000 ALTER TABLE `categories` ENABLE KEYS */;
UNLOCK TABLES;