схема базы данных

users
id_user int(11)  {PK}, auto_inc         
  a text                  
  b text                
  c text                
  id_status int(11) 

passwords
id_user int(11) {PK}
  l text             
  p text           
  e text

statuses
id_status int(11) {PK}, auto_inc          
  s text

-- Версия сервера: 4.1.16
-- Версия PHP: 5.1.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- База данных: `users_db`
--

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

--
-- Структура таблицы `passwords`
--

CREATE TABLE `passwords` (
  `id_user` int(11) NOT NULL default '0',
  `l` text NOT NULL,
  `p` text NOT NULL,
  `e` text NOT NULL,
  PRIMARY KEY  (`id_user`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1251;

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

--
-- Структура таблицы `statuses`
--

CREATE TABLE `statuses` (
  `id_status` int(11) NOT NULL auto_increment,
  `s` text NOT NULL,
  PRIMARY KEY  (`id_status`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1251 AUTO_INCREMENT=3 ;

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

--
-- Структура таблицы `users`
--

CREATE TABLE `users` (
  `id_user` int(11) NOT NULL auto_increment,
  `a` text NOT NULL,
  `b` text NOT NULL,
  `c` text NOT NULL,
  `id_status` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id_user`),
  KEY `id_status` (`id_status`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2 ;

--
-- Ограничения внешнего ключа сохраненных таблиц
--

--
-- Ограничения внешнего ключа таблицы `passwords`
--
ALTER TABLE `passwords`
  ADD CONSTRAINT `passwords_ibfk_1` FOREIGN KEY (`id_user`) REFERENCES `users` (`id_user`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Ограничения внешнего ключа таблицы `users`
--
ALTER TABLE `users`
  ADD CONSTRAINT `users_ibfk_1` FOREIGN KEY (`id_status`) REFERENCES `statuses` (`id_status`);

-- phpMyAdmin SQL Dump
-- version 3.2.3
--
-- Host: localhost
-- Generation Time: Jun 09, 2011 at 12:02 AM
-- Server version: 5.1.40
-- PHP Version: 5.3.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `voute`
--

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

--
-- Table structure for table `gorod`
--

CREATE TABLE IF NOT EXISTS `gorod` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `gorod` varchar(255) COLLATE cp1251_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 COLLATE=cp1251_bin AUTO_INCREMENT=57 ;

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

--
-- Table structure for table `izbir`
--

CREATE TABLE IF NOT EXISTS `izbir` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fio` varchar(255) CHARACTER SET cp1251 COLLATE cp1251_bin NOT NULL,
  `propiska` varchar(255) CHARACTER SET cp1251 COLLATE cp1251_bin NOT NULL,
  `seria_number` varchar(255) CHARACTER SET cp1251 COLLATE cp1251_bin NOT NULL,
  `data_rogdenia` date NOT NULL,
  `login` varchar(255) CHARACTER SET cp1251 COLLATE cp1251_bin NOT NULL,
  `pass` varchar(255) CHARACTER SET cp1251 COLLATE cp1251_bin NOT NULL,
  `id_gorod` int(11) NOT NULL,
  `id_oblast` int(11) NOT NULL,
  `email` text NOT NULL,
  `golos` tinyint(1) NOT NULL,
  `reg` int(11) NOT NULL,
  `gen_code` varchar(32) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=137 ;

--
-- Table structure for table `kandidatu`
--

CREATE TABLE IF NOT EXISTS `kandidatu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `images` varchar(40) DEFAULT NULL,
  `part` text NOT NULL,
  `result` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=6 ;

--
-- Table structure for table `oblast`
--

CREATE TABLE IF NOT EXISTS `oblast` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `oblast` varchar(255) COLLATE cp1251_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 COLLATE=cp1251_bin AUTO_INCREMENT=26 ;

--
-- Table structure for table `rsa`
--

CREATE TABLE IF NOT EXISTS `rsa` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` text NOT NULL,
  `i` varchar(32) NOT NULL,
  `v` int(11) NOT NULL,
  `d` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=46 ;