-- phpMyAdmin SQL Dump
-- version 2.11.6
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 28, 2008 at 11:26 AM
-- Server version: 5.0.51
-- PHP Version: 5.2.4

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!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 */;

--
-- Database: `segovia`
--

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

--
-- Table structure for table `breakfast`
--

CREATE TABLE IF NOT EXISTS `breakfast` (
  `bid` int(4) NOT NULL auto_increment,
  `id` int(5) NOT NULL,
  PRIMARY KEY  (`bid`),
  UNIQUE KEY `name` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=24 ;

--
-- Dumping data for table `breakfast`
--

INSERT INTO `breakfast` (`bid`, `id`) VALUES
(23, 13),
(22, 7),
(21, 5),
(20, 4),
(19, 3),
(18, 2),
(17, 1);

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

--
-- Table structure for table `menu items`
--

CREATE TABLE IF NOT EXISTS `menu items` (
  `id` int(5) NOT NULL auto_increment,
  `span` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `bdesc` varchar(255) NOT NULL,
  `ldesc` varchar(255) NOT NULL,
  `ddesc` varchar(255) NOT NULL,
  `tdesc` varchar(255) NOT NULL,
  `bprice` decimal(6,2) NOT NULL,
  `lprice` decimal(6,2) NOT NULL,
  `dprice` decimal(6,2) NOT NULL,
  `tprice` decimal(6,2) NOT NULL,
  `recipe` varchar(255) NOT NULL,
  `date` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

--
-- Dumping data for table `menu items`
--

INSERT INTO `menu items` (`id`, `span`, `name`, `bdesc`, `ldesc`, `ddesc`, `tdesc`, `bprice`, `lprice`, `dprice`, `tprice`, `recipe`, `date`) VALUES
(1, 'spanish name', 'regular name', 'breakfast description this meal is for breakfast with breakfasty things', 'lunch description lives here, these are things you get with lunch', 'dinner description, here are things you get for dinner.', 'tapas description, only what you get with tapas', 1.00, 2.00, 3.00, 4.00, 'heres the general recipe for whatever the fuck is being cooked   ', '0000-00-00 00:00:00'),
(2, 'spanish name', 'regular name', 'breakfast lkjasflk lasjkf lksjadf lkjsadf lkjsadfdl kj', 'lunch laskjdflkjsdafdlkjlkj lkj lkj lkj lkj lkkj', 'dinner lkjasfl lkj sadffljk lkskjfl kjljlskjdff lksjddf ', 'tapas lsjdflk lkj lkj df ldf dkdsfkjlsadfoulkjejoijlk', 1.00, 2.00, 3.00, 4.00, 'here is a mother fucking recipe', '0000-00-00 00:00:00'),
(3, 'spanish name', 'regular name', 'breakfast lkjasflk lasjkf lksjadf lkjsadf lkjsadfdl kj', 'lunch laskjdflkjsdafdlkjlkj lkj lkj lkj lkj lkkj', 'dinner lkjasfl lkj sadffljk lkskjfl kjljlskjdff lksjddf ', 'tapas lsjdflk lkj lkj df ldf dkdsfkjlsadfoulkjejoijlk', 1.00, 2.00, 3.00, 4.00, 'here is a mother fucking recipe', '0000-00-00 00:00:00'),
(4, 'spanish name', 'regular name', 'breakfast lkjasflk lasjkf lksjadf lkjsadf lkjsadfdl kj', 'lunch laskjdflkjsdafdlkjlkj lkj lkj lkj lkj lkkj', 'dinner lkjasfl lkj sadffljk lkskjfl kjljlskjdff lksjddf ', 'tapas lsjdflk lkj lkj df ldf dkdsfkjlsadfoulkjejoijlk', 1.00, 2.00, 3.00, 4.00, 'here is a mother fucking recipe', '0000-00-00 00:00:00'),
(5, 'spanish name', 'regular name', 'breakfast lkjasflk lasjkf lksjadf lkjsadf lkjsadfdl kj', 'lunch laskjdflkjsdafdlkjlkj lkj lkj lkj lkj lkkj', 'dinner lkjasfl lkj sadffljk lkskjfl kjljlskjdff lksjddf ', 'tapas lsjdflk lkj lkj df ldf dkdsfkjlsadfoulkjejoijlk', 1.00, 2.00, 3.00, 4.00, 'here is a mother fucking recipe', '0000-00-00 00:00:00'),
(6, 'spanish name', 'regular name', 'breakfast lkjasflk lasjkf lksjadf lkjsadf lkjsadfdl kj', 'lunch laskjdflkjsdafdlkjlkj lkj lkj lkj lkj lkkj', 'dinner lkjasfl lkj sadffljk lkskjfl kjljlskjdff lksjddf ', 'tapas lsjdflk lkj lkj df ldf dkdsfkjlsadfoulkjejoijlk', 1.00, 2.00, 3.00, 4.00, 'here is a mother fucking recipe', '0000-00-00 00:00:00'),
(7, 'spanish name', 'regular name', 'breakfast lkjasflk lasjkf lksjadf lkjsadf lkjsadfdl kj', 'lunch laskjdflkjsdafdlkjlkj lkj lkj lkj lkj lkkj', 'dinner lkjasfl lkj sadffljk lkskjfl kjljlskjdff lksjddf ', 'tapas lsjdflk lkj lkj df ldf dkdsfkjlsadfoulkjejoijlk', 1.00, 2.00, 3.00, 4.00, 'here is a mother fucking recipe', '0000-00-00 00:00:00'),
(8, 'spanish name', 'regular name', 'breakfast lkjasflk lasjkf lksjadf lkjsadf lkjsadfdl kj', 'lunch laskjdflkjsdafdlkjlkj lkj lkj lkj lkj lkkj', 'dinner lkjasfl lkj sadffljk lkskjfl kjljlskjdff lksjddf ', 'tapas lsjdflk lkj lkj df ldf dkdsfkjlsadfoulkjejoijlk', 1.00, 2.00, 3.00, 4.00, 'here is a mother fucking recipe', '2008-05-23 12:12:10'),
(9, '', 'hello', '', '', '', '', 0.00, 0.00, 0.00, 0.00, 'First line of initial text.\r\nSecond line of initial text.\r\n   ', '2008-05-23 12:41:39'),
(10, '', 'hello', '', '', '', '', 0.00, 0.00, 0.00, 0.00, 'First line of initial text.\r\nSecond line of initial text.\r\n   ', '2008-05-23 12:41:43'),
(11, '', 'llkjlkj', '', '', '', '', 0.00, 0.00, 0.00, 0.00, 'First line of initial text.\r\nSecond line of initial text.\r\n   ', '2008-05-23 12:41:50'),
(12, '', 'blah to blah', '', '', '', '', 0.00, 0.00, 0.00, 0.00, 'First line of initial text.\r\nSecond line of initial text.\r\n   ', '2008-05-23 12:43:02'),
(13, 'enter informoation', 'lksjflkj', 'lkjlkkj', ' lkj', ' lkjl', 'kj lkjlkjlk', 7.00, 5.00, 5.00, 5.00, 'k;laskf;lksd;fllk;lksf;lksd;dlfk;lskdf					', '2008-05-23 16:52:36');