-- phpMyAdmin SQL Dump -- version 4.0.10.14 -- http://www.phpmyadmin.net -- -- Host: localhost:3306 -- Generation Time: Sep 19, 2016 at 12:25 PM -- Server version: 5.6.31 -- PHP Version: 5.6.20 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!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: `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, '
Josh West was a man. Who did things.
Many things.
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.
'), (10, 5, 'text goes here sdf '), (2, 4, '

Shannon Rutherford was a person who had this obituary written about her.  You can log in as an administrator and change this obituary section to be anything that you want it too.

 Just log in with your username and password

'), (11, 24, 'Pallotta, Arthur Joseph On Wednesday, May 30, 2007 at his residence four days shy of his 80th 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.'), (7, 6, ' Public Display of Obitiuaries
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

When a user clicks on a person’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 “Managing Locations and Directors” for more information), then the user can click on it to see that location in google maps. Below that will be the deceased individual’s photo and obituary if they have been added to the database (Read “Adding Obituaries” for more information on adding these).

Below this personal information, there are five links:
- Leave Message of Condolence, which we will get to in a minute
- View Message of Condolence, which will display any messages left by other visitors
- Read Directions which links to the directions page of the Adams Green website
- 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
- Print Obituary prints the current page

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.
'), (12, 28, ' Test '); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE IF NOT EXISTS `users` ( `id` int(11) NOT NULL DEFAULT '0', `username` varchar(20) NOT NULL DEFAULT '', `password` varchar(20) NOT NULL DEFAULT '', PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `username`, `password`) VALUES (0, 'admin', 'cemetery1'); -- -------------------------------------------------------- -- -- 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); /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;