-- 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, '
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