-- phpMyAdmin SQL Dump
-- version 3.2.3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Mar 28, 2011 at 01:13 PM
-- Server version: 5.1.40
-- PHP Version: 5.3.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `vuz`
--

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

--
-- Table structure for table `regions`
--

CREATE TABLE IF NOT EXISTS `regions` (
  `id_region` int(2) NOT NULL AUTO_INCREMENT,
  `title` text NOT NULL,
  PRIMARY KEY (`id_region`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `regions`
--


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

--
-- Table structure for table `specialities`
--

CREATE TABLE IF NOT EXISTS `specialities` (
  `id_speciality` int(11) NOT NULL AUTO_INCREMENT,
  `title` text NOT NULL,
  PRIMARY KEY (`id_speciality`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `specialities`
--


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

--
-- Table structure for table `states`
--

CREATE TABLE IF NOT EXISTS `states` (
  `id_state` int(1) NOT NULL AUTO_INCREMENT,
  `title` text NOT NULL,
  PRIMARY KEY (`id_state`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `states`
--

INSERT INTO `states` (`id_state`, `title`) VALUES
(1, 'Центральный федеральный округ'),
(2, 'Южный федеральный округ'),
(3, 'Северо-Западный федеральный округ'),
(4, 'Дальневосточный федеральный округ'),
(5, 'Сибирский федеральный округ'),
(6, 'Уральский федеральный округ'),
(7, 'Приволжский федеральный округ'),
(8, 'Северо-Кавказский федеральный округ');

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

--
-- Table structure for table `towns`
--

CREATE TABLE IF NOT EXISTS `towns` (
  `id_town` int(11) NOT NULL AUTO_INCREMENT,
  `title` text NOT NULL,
  PRIMARY KEY (`id_town`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `towns`
--


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

--
-- Table structure for table `universities`
--

CREATE TABLE IF NOT EXISTS `universities` (
  `id_university` int(11) NOT NULL AUTO_INCREMENT,
  `title` text NOT NULL,
  `id_town` int(11) NOT NULL,
  `id_region` int(11) NOT NULL,
  `id_state` int(11) NOT NULL,
  PRIMARY KEY (`id_university`),
  KEY `id_town` (`id_town`),
  KEY `id_region` (`id_region`),
  KEY `id_state` (`id_state`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `universities`
--


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

--
-- Table structure for table `universities_specialities`
--

CREATE TABLE IF NOT EXISTS `universities_specialities` (
  `id_university` int(4) NOT NULL,
  `id_speciality` int(4) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

--
-- Dumping data for table `universities_specialities`
--