-- http://www.phpmyadmin.net
--




--
-- Database: `tmiva_adamsgreen`
--

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

--
-- Table structure for table `funeral_director`
--

CREATE TABLE IF NOT EXISTS `funeral_director` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) NOT NULL DEFAULT '',
  `email` varchar(40) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

--
-- Dumping data for table `funeral_director`
--

INSERT INTO `funeral_director` (`id`, `name`, `email`) VALUES
(1, 'Christopher J. Adams', 'chris@adamsgreen.com'),
(2, 'Carrol Groff', ''),
(3, 'Bill Keatley', ''),
(4, 'Maureen Larsen', 'maureen@adamsgreen.com'),
(5, 'Brian Maxwell', ''),
(8, 'David Zimmerman', ''),
(10, 'Josh', 'joshmaker@gmail.com'),
(11, 'new_director_name', ''),
(12, 'new_director_name', '');

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

--
-- Table structure for table `locations`
--

CREATE TABLE IF NOT EXISTS `locations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) NOT NULL DEFAULT '',
  `address` varchar(40) NOT NULL DEFAULT '',
  `city` varchar(30) NOT NULL DEFAULT '',
  `state` char(2) NOT NULL DEFAULT '',
  `zip` varchar(5) NOT NULL DEFAULT '',
  `type` enum('visitation','funeral','burial') NOT NULL DEFAULT 'visitation',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=30 ;

--
-- Dumping data for table `locations`
--

INSERT INTO `locations` (`id`, `name`, `address`, `city`, `state`, `zip`, `type`) VALUES
(1, 'Adams-Green Funeral Home Chapel', '721 Elden Street', 'Herndon', 'VA', '20170', 'visitation'),
(2, 'Arlington Assembly of God Church', '4501 N. Pershing Drive', 'Arlington', 'VA', '22203', 'visitation'),
(3, 'Adams-Green Funeral Home Chapel', '', '', '', '', 'funeral'),
(4, 'Arlington Assembly of God Church', '', '', '', '', 'funeral'),
(5, 'Andrews Chapel Cemetery', '', '', '', '', 'burial'),
(6, 'Arlington National Cemetery', '', '', '', '', 'burial'),
(13, 'New Visitation Location', 'Address', 'city', '', 'Zip', 'visitation'),
(14, '2nd New Location', 'Addresss', 'City', '', 'Zip', 'visitation'),
(15, 'New Funeral Location', 'Address', 'City', '', 'Zip', 'funeral'),
(16, 'New Burial Location', 'Address', 'City', '', 'ZIP', 'burial'),
(17, 'newest location ever', 'edited', 'edited', 'ed', 'ed', 'visitation'),
(18, 'null', 'null', 'null', 'nu', 'null', 'visitation'),
(19, 'Christ the Redeemer', '123 Harry Byrd Hwy.', 'Sterling', '20', 'VA', 'visitation'),
(20, 'Christ the Redeemer Catholic', '', 'Sterling', '20', 'VA', 'funeral'),
(21, 'Chestnut Grove Cemetery', '', 'Herndon', '20', 'VA', 'burial'),
(22, 'new_visitation_name', 'new_visitation_address', 'new_visitation_city', 'ne', 'ne', 'visitation'),
(23, 'new_next_visitation_name', 'new_next_visitation_address', 'new_next_visitation_city', 'ne', 'ne', 'visitation'),
(24, 'new_funeral_name', 'new_funeral_address', 'new_funeral_city', 'ne', 'ne', 'funeral'),
(25, 'new_burial_name', 'new_burial_address', 'new_burial_city', 'ne', 'ne', 'burial'),
(26, 'new_visitation_name', 'new_visitation_address', 'new_visitation_city', 'ne', 'ne', 'visitation'),
(27, 'new_next_visitation_name', 'new_next_visitation_address', 'new_next_visitation_city', 'ne', 'ne', 'visitation'),
(28, 'new_funeral_name', 'new_funeral_address', 'new_funeral_city', 'ne', 'ne', 'funeral'),
(29, 'new_burial_name', 'new_burial_address', 'new_burial_city', 'ne', 'ne', 'burial');

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

--
-- Table structure for table `messages`
--

CREATE TABLE IF NOT EXISTS `messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `obituary` int(11) NOT NULL DEFAULT '0',
  `from` varchar(30) NOT NULL DEFAULT '',
  `message` text NOT NULL,
  `approved` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ;

--
-- Dumping data for table `messages`
--

INSERT INTO `messages` (`id`, `obituary`, `from`, `message`, `approved`) VALUES
(1, 6, 'Josh', 'I was sad to see him go.', 1),
(2, 6, 'Lorem Ipsom', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.\r\n', 1),
(3, 6, 'Josh', 'This is a sample message that someone could have left online.  Since an administrator has approved it, it will appear online until it is deleted or the associated obituary is taken down.', 1),
(4, 6, 'Jacob', 'Woot', 0),
(5, 6, 'Josh West', 'This message is fine.  Juuuust fine.', 1),
(10, 20, 'John Doe', 'This is a test of the Visitations Condolence Messages.\r\nBest.\r\nJD', 1),
(12, 4, 'Joe Anybody', 'This is a message of condolence.  Thanks', 1),
(14, 24, 'Bob Jenkins', 'This breaks my heart, please accept my condolences', 0),
(15, 28, 'Tester', 'my message', 0),
(16, 28, 'Josh', 'Wait?  what happened to me?', 0),
(20, 28, 'Thrid Message Leaver', 'Message', 0),
(19, 28, 'Thrid Message Leaver', 'Message', 0),
(21, 28, 'Thrid Message Leaver', 'Message', 0),
(22, 28, 'Thrid Message Leaver', 'Message', 0),
(23, 28, 'Thrid Message Leaver', 'Message', 0),
(24, 28, 'Thrid Message Leaver', 'Message', 0),
(25, 28, 'Thrid Message Leaver', 'Message', 0),
(26, 28, 'Thrid Message Leaver', 'Message', 0);

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

--
-- Table structure for table `obituaries`
--

CREATE TABLE IF NOT EXISTS `obituaries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `visitation` int(11) NOT NULL DEFAULT '0',
  `obituary` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

--
-- Dumping data for table `obituaries`
--

INSERT INTO `obituaries` (`id`, `visitation`, `obituary`) VALUES
(1, 2, ' <div align="center"><a href="www.joshmaker.com">Josh West</a> was a man. Who did things. <br />Many things.</div><div align="\\">He asked for a nice obituary -- so here it is....He was a man among men, a pillar of society, and he had nice ties...remember him in your thoughts as taller.</div> '),
(10, 5, 'text goes <a href="www.apple.com">here</a> sdf '),
(2, 4, '<p>   <strong>Shannon Rutherford</strong> was a person who had this obituary written about her.&nbsp; You can log in as an administrator and change this obituary section to be anything that you want it too.</p><p align="center">&nbsp;Just log in with your username and password </p>'),
(11, 24, '<span style="font-size: 14pt"><font face="Times New Roman">Pallotta, Arthur Joseph </font></span><span style="font-size: 14pt"><font face="Times New Roman">On Wednesday, May 30, 2007 at his residence four days shy of his 80<sup>th</sup> birthday. Survived by his wife and was the loving and devoted father of Debbie Miller, Jamie Miller, Karen Bernstein, A.J. Pallotta, Pam Smariga, Tommy Pallotta, Peggy Fauteux. Also survived by two sisters, one brother, twenty three grandchildren and seventeen and a half great-grandchildren. A Mass of Christian Burial at Our Lady of Good Counsel, 8601 Wolftrap Rd., Vienna, VA Saturday, June 2, 2007 at 10am. A reception will follow immediately after the service. The family suggests that memorial contributions may be made to Veterans Hospital in Washington DC. ADAMS-GREEN Funeral Home is in charge of arrangements.</font></span>'),
(7, 6, ' <strong>Public Display of Obitiuaries</strong><br />After you have saved the Obituary, it will show up under current visitations  page of the public section of the website: http://www.tmiva.net/adamsgreen/visitations.php<br /><br />When a user clicks on a person&rsquo;s visitation, they are taken to a page that displays first the date and location of any listed visitations, funerals, or burials.  If the location selected for the visitation, funeral, or burial has address information added to it in the database (Read &ldquo;Managing Locations and Directors&rdquo; for more information), then the user can click on it to see that location in google maps.  Below that will be the deceased individual&rsquo;s photo and obituary if they have been added to the database (Read &ldquo;Adding Obituaries&rdquo; for more information on adding these). <br /><br />Below this personal information, there are five links:<br />-    Leave Message of Condolence, which we will get to in a minute<br />-    View Message of Condolence, which will display any messages left by other visitors<br />-    Read Directions which links to the directions page of the Adams Green website<br />-    Send Flowers which takes the user to a page with address information for, and a form to send an email message to, Herndon florist and a copy to Adams Green <br />-    Print Obituary prints the current page<br /><br />When someone leaves a message of condolence, the message first has to pass through an anti-spam filter that will prevent messages that are blatantly spam.  If it passes the spam test, it goes to Adams Green for approval.  The website sends out a message notifying Adams Green that a message is pending approval.<br /> '),
(12, 28, ' Test   ');

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

--
-- Table structure for table `visitations`
--

CREATE TABLE IF NOT EXISTS `visitations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(20) NOT NULL DEFAULT '',
  `middle_name` varchar(20) NOT NULL DEFAULT '',
  `last_name` varchar(20) NOT NULL DEFAULT '',
  `city` varchar(20) NOT NULL DEFAULT '',
  `state` char(2) NOT NULL DEFAULT '',
  `dob` date NOT NULL DEFAULT '0000-00-00',
  `dod` date NOT NULL DEFAULT '0000-00-00',
  `family_email` varchar(35) NOT NULL DEFAULT '',
  `visitation_date` date NOT NULL DEFAULT '0000-00-00',
  `visitation_start` time DEFAULT NULL,
  `visitation_end` time DEFAULT NULL,
  `visitation_location` int(11) NOT NULL DEFAULT '0',
  `next_visitation_location` int(11) NOT NULL DEFAULT '0',
  `next_visitation_date` date DEFAULT NULL,
  `next_visitation_start` time DEFAULT NULL,
  `next_visitation_end` time DEFAULT NULL,
  `funeral_date` date DEFAULT NULL,
  `funeral_start` time DEFAULT NULL,
  `funeral_location` int(11) NOT NULL DEFAULT '0',
  `burial_date` date DEFAULT NULL,
  `burial_start` time DEFAULT NULL,
  `burial_location` int(11) NOT NULL DEFAULT '0',
  `donations` varchar(255) NOT NULL DEFAULT '',
  `clergy_name` varchar(50) NOT NULL DEFAULT '',
  `clergy_phone` varchar(14) NOT NULL DEFAULT '',
  `director` int(11) NOT NULL DEFAULT '0',
  `comments` varchar(255) NOT NULL DEFAULT '',
  `public` tinyint(1) NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=29 ;

--
-- Dumping data for table `visitations`
--

INSERT INTO `visitations` (`id`, `first_name`, `middle_name`, `last_name`, `city`, `state`, `dob`, `dod`, `family_email`, `visitation_date`, `visitation_start`, `visitation_end`, `visitation_location`, `next_visitation_location`, `next_visitation_date`, `next_visitation_start`, `next_visitation_end`, `funeral_date`, `funeral_start`, `funeral_location`, `burial_date`, `burial_start`, `burial_location`, `donations`, `clergy_name`, `clergy_phone`, `director`, `comments`, `public`, `status`) VALUES
(28, 'Josh', '', 'West', 'a', 'a', '0000-00-00', '2007-07-24', '', '2007-07-24', NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 0, '', '', '', 10, '', 1, 1),
(27, 'first_name', 'middle_name', 'last_name', 'city', 'st', '0000-00-00', '2007-07-24', 'example@example.com', '2007-07-24', NULL, NULL, 26, 27, '2007-01-01', NULL, NULL, '2007-01-01', NULL, 28, '2007-01-01', NULL, 29, 'donations', 'clergy_name', 'clergy_phone', 10, 'comments', 0, 0),
(26, 'first_name', 'middle_name', 'last_name', 'city', 'st', '0000-00-00', '2007-07-24', 'example@example.com', '2007-07-24', NULL, NULL, 22, 23, '2007-01-01', NULL, NULL, '2007-01-01', NULL, 24, '2007-01-01', NULL, 25, 'donations', 'clergy_name', 'clergy_phone', 10, 'comments', 0, 0);

