-- phpMyAdmin SQL Dump
-- version 4.1.14.2
-- http://www.phpmyadmin.net
--
-- Host: db505508567.db.1and1.com
-- Generation Time: Aug 07, 2014 at 08:37 PM
-- Server version: 5.1.73-log
-- PHP Version: 5.4.4-14+deb7u12

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: `db505508567`
--

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

--
-- Table structure for table `Reviews`
--

CREATE TABLE IF NOT EXISTS `Reviews` (
  `Date` datetime NOT NULL,
  `FirstName` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `LastName` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `Rating` enum('1','2','3','4','5') COLLATE latin1_general_ci NOT NULL,
  `Review` longtext COLLATE latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `Reviews`
--

INSERT INTO `Reviews` (`Date`, `FirstName`, `LastName`, `Rating`, `Review`) VALUES
('2013-12-06 13:44:50', 'Nige', 'Gilbert', '5', 'We found Paul by chance, so glad we did. If you want prompt service, expert advice and super quality workmanship, look no further. We have other projects that need this type of service. I will definitely be using Paul again and I fully recommend <i>Eastfield Joinery</i> to anyone that needs good honest, old school work. Thanks Paul.'),
('2013-11-04 08:36:30', 'Stephanie ', 'Rojas', '5', '<p>Paul thanks for all the work you did on our property over the weekend, which ranged from supplying and fitting a stainless steel panel for the front of our oven unit, taking out our old hob and oven, fitting the new hob and fitting the stainless steel panel to the front of the oven unit and also fitting the oven.</p>\r\n\r\n<p>Additionally, you fixed the water damaged floor in our conservatory by removing and replacing it with new plywood. And you cut down the wall leading to our kitchen to just above the sockets which we believe has completely transformed our kitchen.</p>\r\n\r\n<p>We were very impressed with your efficient, professional and cost effective service. We highly recommend Paul from <i>Eastfield Joinery</i> and we will definitely continue to use him for many projects we have in mind in the future!</p>'),
('2013-07-21 14:08:55', 'Ray and Julie ', 'Pitch', '5', 'A true craftsman. Painstaking attention to detail and excellent workmanship.'),
('2013-07-13 19:00:24', 'Dave and Jackie', 'Cox', '5', 'Paul at <i>Eastfield Joinery</i> has just completed our kitchen renovation for us. We are completely happy with the end result and have absolutely no problem recommending Paul. We found him to be reliable, down to earth, hard working and a pleasure to work with. He did an amazing job, we have had many comments on the high standard of work and finishes on the cabinetry. He made a beautiful bench/breakfast bar out of kauri we had stored for years, wonderful craftsmanship! Thanks again Paul!'),
('2013-05-05 14:36:00', 'Ian', '', '5', 'Well made bookcase, built and installed by a competent trades person.'),
('2013-05-11 05:02:00', 'Russel', '', '5', '<i>Eastfield Joinery</i> provided all carpentry and joinery for my barn conversion to an artist''s studio and guest suite. As a retired architect, my requirements were exacting. All were executed on time, to a high standard, co-ordinating well with other trades and delivered with a smile. I would happily use <i>Eastfield Joinery</i> again, but not at this distance.'),
('2013-05-15 21:01:00', 'Tony', '', '5', 'Big thumbs up to Paul from <i>Eastfield Joinery</i>. Paul worked on two projects for me. One was a renovation and the other an external addition. Both jobs were completed to a high level of workmanship and detail. I found Paul to be honest, trustworthy, reliable and very hard working. I would have absolutely no hesitation in recommending Paul to anyone looking for a genuine 5 Star tradesman.'),
('2013-05-14 21:42:00', 'Sheridan', 'Booth', '5', 'I just wanted to thank you for the excellent job you did for us on the coffee table. We get many comments on it and we were impressed you were able to do not only the woodwork but also managed to tile it. Also the bespoke contemporary bathroom cabinet. You understood the brief and executed it to a high standard. Your wood workmanship is very good and we appreciated the care you took with it.'),
('2013-08-26 09:48:00', 'John', '', '5', 'First rate job. Quick to respond to an enquiry, offered suggestions, and did exactly what we asked for. Left everything nice and tidy. Highly recommended.'),
('2013-10-20 12:43:00', 'Nick', '', '5', 'Paul at <i>Eastfield Joinery</i> did a fantastic job on our damaged door frame. His price was competitive and service was professional. And most importantly, the door frame looked brand new when he was done working his magic. We were very pleased. Paul was also very accommodating when we had to reschedule last minute due to issues with the tenants. Thank you very much Paul. We will most certainly recommend you to others.'),
('2013-11-25 18:42:00', 'Peter', '', '5', 'Thanks Paul! Great job, you are a true craftsman, thanks for your help in resolving a difficult problem. Your response to our request for urgent assistance was greatly appreciated and your quote was very competitive. I would not hesitate in recommending you to anyone else.'),
('2014-01-20 11:10:00', 'Winston', '', '5', 'The job was delayed substantially by suppliers that could not supply a part needed for the job. However Paul kept us well informed and the end product has been amazing and great for what we needed. Paul spent alot of time and tried really hard to sort out the supplier. And then when the job was complete he billed us less than his original quote! Amazing... I cant say that has ever happened for us before. So an honest guy that did a great job. HIGHLY RECOMMEND!!'),
('2014-04-22 01:26:54', 'Yael', 'Cameron', '5', 'The job that Paul did was efficient, well-priced and looks wonderful. We are thrilled with result and look forward to working with Paul again. Thank you so much.'),
('2014-04-15 13:23:54', 'Bronwyn', '', '5', 'Work exceeded expectations and I highly recommend <i>Eastfield Joinery</i>.\r\nNew windows were made and fitted all ahead of time and Paul was a pleasure to deal with.'),
('2014-04-25 18:40:00', 'Campbell', '', '5', 'Excellent job, done on time and to budget. Thanks Paul.');

/*!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 */;
