-- phpMyAdmin SQL Dump
-- version 3.0.1.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 16, 2008 at 08:43 AM
-- Server version: 5.0.51
-- PHP Version: 5.2.4-2ubuntu5.4

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `cda`
--
CREATE DATABASE `cda` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
USE `cda`;

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

--
-- Table structure for table `parishes`
--

CREATE TABLE IF NOT EXISTS `parishes` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(30) collate utf8_unicode_ci NOT NULL,
  `street_address` varchar(150) collate utf8_unicode_ci NOT NULL,
  `mailing_address` varchar(150) collate utf8_unicode_ci NOT NULL,
  `special_instructions` text collate utf8_unicode_ci,
  `city` varchar(20) collate utf8_unicode_ci NOT NULL,
  `state` varchar(20) collate utf8_unicode_ci NOT NULL,
  `zip` varchar(10) collate utf8_unicode_ci NOT NULL,
  `notes` text collate utf8_unicode_ci NOT NULL,
  `mission_church` varchar(150) collate utf8_unicode_ci default NULL,
  `outside_mission_church` varchar(150) collate utf8_unicode_ci default NULL,
  `eastern_church` varchar(150) collate utf8_unicode_ci default NULL,
  `website` varchar(150) collate utf8_unicode_ci default NULL,
  `phone` varchar(25) collate utf8_unicode_ci default NULL,
  `mass_times` text collate utf8_unicode_ci NOT NULL,
  `longitude` varchar(50) collate utf8_unicode_ci default NULL,
  `latitude` varchar(50) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Dumping data for table `parishes`
--

INSERT INTO `parishes` (`id`, `name`, `street_address`, `mailing_address`, `special_instructions`, `city`, `state`, `zip`, `notes`, `mission_church`, `outside_mission_church`, `eastern_church`, `website`, `phone`, `mass_times`, `longitude`, `latitude`) VALUES
(1, 'Blue Atlas Interactive', '19508 Amaranth Dr., Suite D,', '19508 Amaranth Dr., Suite D,', 'None', 'Germantown', 'Maryland', '20874', 'None', NULL, NULL, NULL, 'http://www.blueatlas.com', '301-555-5555', 'Sunday: 1-5\r\nMonday: 2-6\r\nTuesday: 3-7', '-77.2524283', '39.1750724'),
(2, 'Quince Orchard High School', '15800 Quince Orchard Road', '15800 Quince Orchard Road', 'None', 'Gaithersburg', 'Marlyand', '20878', 'None', NULL, NULL, NULL, 'http://www.qohs.org', '301-555-5555', 'Sunday: 9-5\r\nMonday: 9-5\r\nTuesday: 9-5', '-77.2529493', '39.1145320');