-- phpMyAdmin SQL Dump
-- version 2.11.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 15, 2008 at 07:52 AM
-- Server version: 5.0.45
-- PHP Version: 5.2.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `malan_bar`
--

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

--
-- Table structure for table `friends`
--

CREATE TABLE `friends` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) default NULL,
  `city` varchar(255) default NULL,
  `state` varchar(255) default NULL,
  `zip` varchar(9) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `special` (`name`,`email`),
  KEY `name` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

--
-- Dumping data for table `friends`
--

INSERT INTO `friends` VALUES(1, 'Mike Smith', 'mike_smith@harvard.edu', 'Cambridge', 'MA', '02138');
INSERT INTO `friends` VALUES(12, 'Chris Smith', 'mike_smith@harvard.edu', 'Cambridge', 'MA', '02138');