-- phpMyAdmin SQL Dump
-- version 3.1.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 12, 2009 at 06:11 PM
-- Server version: 5.1.30
-- PHP Version: 5.2.8
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: `ucc_data`
--
CREATE DATABASE `ucc_data` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `ucc_data`;
-- --------------------------------------------------------
--
-- Table structure for table `birthdays`
--
CREATE TABLE IF NOT EXISTS `birthdays` (
`id` int(4) NOT NULL AUTO_INCREMENT,
`birth_month` text NOT NULL,
`birth_date` int(2) NOT NULL,
`birth_name` text NOT NULL,
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
--
-- Dumping data for table `birthdays`
--
INSERT INTO `birthdays` (`id`, `birth_month`, `birth_date`, `birth_name`) VALUES
(1, 'May', 5, 'Nicole Winkel'),
(2, 'May', 8, 'Katie Fricker'),
(3, 'May', 17, 'Elise Fischer'),
(4, 'May', 23, 'Meaghan May'),
(5, 'May', 24, 'Sierra Zuege'),
(6, 'May', 27, 'Vienna Wieland'),
(7, 'May', 28, 'Josie Peck');
-- --------------------------------------------------------
--
-- Table structure for table `chapel`
--
CREATE TABLE IF NOT EXISTS `chapel` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`email` text NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `chapel`
--
INSERT INTO `chapel` (`ID`, `email`) VALUES
(1, 'cordane@gmail.com');
-- --------------------------------------------------------
--
-- Table structure for table `meetings`
--
CREATE TABLE IF NOT EXISTS `meetings` (
`id` int(4) NOT NULL AUTO_INCREMENT,
`event_month` text NOT NULL,
`event_day` int(2) NOT NULL,
`event_name` text NOT NULL,
`event_start` time NOT NULL,
`event_finish` time NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
--
-- Dumping data for table `meetings`
--
INSERT INTO `meetings` (`id`, `event_month`, `event_day`, `event_name`, `event_start`, `event_finish`) VALUES
(1, 'May', 5, 'Bible Study', '00:00:00', '00:00:00'),
(2, 'May', 5, '8th Grade Confirmation Class', '04:00:00', '00:00:00'),
(3, 'May', 6, '7th Grade Confirmation Class', '04:00:00', '00:00:00'),
(4, 'May', 9, 'St. John''s Open House', '01:00:00', '04:00:00'),
(5, 'May', 13, 'Sunday School meeting', '07:00:00', '00:00:00'),
(6, 'May', 14, 'Women''s Guild Meeting', '12:00:00', '00:00:00'),
(7, 'May', 18, 'W.O.W. Meeting', '07:00:00', '00:00:00');
-- --------------------------------------------------------
--
-- Table structure for table `pastor_sermon`
--
CREATE TABLE IF NOT EXISTS `pastor_sermon` (
`id` int(4) NOT NULL AUTO_INCREMENT,
`month` text NOT NULL,
`year` year(4) NOT NULL,
`text` text NOT NULL,
`author` text NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `pastor_sermon`
--
INSERT INTO `pastor_sermon` (`id`, `month`, `year`, `text`, `author`) VALUES
(1, 'May', 2009, 'My head is spinning as I consider all the things going on in St. John’s, as well
\r\nas church – related activities outside St. John’s. By the time you receive this,
\r\nyou may have already missed the MD Road Cleanup and the SE Association
\r\nMeeting of the United Church of Christ, both of which are on April 25.
\r\nMay 9th is going to be a wonderful day, as we open our doors to the
\r\nneighboring communities and invite them to visit our Open House, from 1-4
\r\nPM. There’s still time to sign up to help out during this exciting event, such as
\r\nsimply being around to answer questions or show off part of the church.
\r\nSunday school will finish up on May 17th, when the children take over the
\r\nworship service. The 25th of May is a fun time in Merton, as we have a
\r\nMemorial Day parade and St. John’s sponsors a Brat Fry after the ceremony
\r\nat Village Hall.
\r\nOn June 12-13 we’ll sponsor a Rummage and Bake Sale beginning at 8
\r\nAM each day. It’s a great opportunity to see lots of people you don’t get to see
\r\noften enough, and is another opportunity to get together with other church
\r\npeople. July hosts another MD Road Cleanup on the 25th, and our Locally
\r\nFamous Vacation Bible School will be from July 27-30.
\r\nOur very much appreciated Outdoor Movie Night will happen on August
\r\n2, at dusk. So many families have enjoyed this in the past, we’re delighted to
\r\nbe able to host it again this year.
\r\nAlthough we hope to see many families in church all summer long, Sept.
\r\n13th marks Rally Day, the beginning of Sunday School. We are also planning
\r\nour Outdoor Flea Market on Sept. 19th. We are planning on bringing back our
\r\nfamous AUCTION on Oct. 10th. We all anticipate lots of fun wrapped around
\r\nour auction! Also, there is an MD Road Cleanup on Oct. 24th.
\r\nNovember finds us hosting our Spaghetti Dinner on the 14th, and having
\r\nThanksgiving Eve Worship on the 25th.
\r\nDecember is naturally filled with delights: the 6th is our Advent
\r\nAdventure; the 12th is our locally famous Cookie Walk; the 13th is the
\r\nSunday School Christmas Program; the 19th is Breakfast with Santa; the 24th
\r\nis Christmas Eve Worship.
\r\nWe all look forward to being with each of you all through the
\r\nyear!
\r\nLove,
\r\nPastor Karen', 'Pastor Karen Stefffens');
-- --------------------------------------------------------
--
-- Table structure for table `service_participants`
--
CREATE TABLE IF NOT EXISTS `service_participants` (
`id` int(4) NOT NULL AUTO_INCREMENT,
`date` date NOT NULL,
`greetings` text NOT NULL,
`coffee_conversation` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
--
-- Dumping data for table `service_participants`
--
INSERT INTO `service_participants` (`id`, `date`, `greetings`, `coffee_conversation`) VALUES
(1, '2009-05-10', 'Michals', 'Open'),
(2, '2009-05-17', 'Schlafer', 'Open'),
(3, '2009-05-24', 'Last', 'Open'),
(4, '2009-05-31', 'ZumMallen', 'Open');
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE IF NOT EXISTS `users` (
`userID` int(11) NOT NULL AUTO_INCREMENT,
`firstName` varchar(50) DEFAULT NULL,
`lastName` varchar(50) DEFAULT NULL,
`username` varchar(50) DEFAULT NULL,
`pwd` varchar(50) DEFAULT NULL,
`userGroup` varchar(50) DEFAULT NULL,
`address1` varchar(50) DEFAULT NULL,
`address2` varchar(50) DEFAULT NULL,
`city` varchar(50) DEFAULT NULL,
`state_province` varchar(50) DEFAULT NULL,
`zip_postal` varchar(50) DEFAULT NULL,
`country` varchar(50) DEFAULT NULL,
PRIMARY KEY (`userID`),
KEY `userID` (`userID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`userID`, `firstName`, `lastName`, `username`, `pwd`, `userGroup`, `address1`, `address2`, `city`, `state_province`, `zip_postal`, `country`) VALUES
(8, 'Matt', 'Taylor', 'cordane@gmail.com', 'mzt', 'visitor', '2751 lund ave #3', NULL, 'rockford', 'il', '61109', 'USA');