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




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

--
-- Table structure for table `tbl_content`
--

CREATE TABLE IF NOT EXISTS `tbl_content` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `status` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `tbl_content`
--

INSERT INTO `tbl_content` (`id`, `title`, `content`, `status`) VALUES
(1, 'About Us', '<p style=\\"margin-left:80px; text-align:center\\">&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p style=\\"text-align:center\\"><img alt=\\"\\" src=\\"http://iproperty.org.uk/upload_images/1397764252_Screenshot_20140417_193940.png\\" style=\\"height:270px; width:1184px\\" /></p>\r\n\r\n<p><br />\r\n<span style=\\"color:rgb(85, 85, 85); font-family:lato,helvetica,sans-serif; font-size:14px\\">The Property Organisation is an Innovative and Progressive Property Portal - providing great Products &amp; Services in the</span>&nbsp;UK &amp; Overseas<span style=\\"color:rgb(85, 85, 85); font-family:lato,helvetica,sans-serif; font-size:14px\\"> - boldly going where no one has gone before!</span><br />\r\n<br />\r\n<span style=\\"color:rgb(85, 85, 85); font-family:lato,helvetica,sans-serif; font-size:14px\\">The aim of this site is to empower you, the individual, with a wide variety of products and services&nbsp;- whether you are looking to own your own home, homeowner, newbie Property Investor, Property Investor,&nbsp;Commercial Investor or Entrepreneur.&nbsp;</span><br />\r\n<span style=\\"color:rgb(85, 85, 85); font-family:lato,helvetica,sans-serif; font-size:14px\\">It is for you, the individual,&nbsp;wanting to own your own home, here in the UK or Overseas, or to make more money, invest or create a better life for freedom, choice and profit. We believe that:</span></p>\r\n\r\n<p><span style=\\"color:#FF0000\\"><span style=\\"font-family:lato,helvetica,sans-serif; font-size:14px\\">&ldquo;Most People Today Are Really Too&nbsp;Busy Earning a Living To Make Any Money... or To Work, Rest &amp; Play?&quot;</span></span></p>\r\n\r\n<p><span style=\\"font-size:14px\\">Among the many features is&nbsp;the Unique Property site: <em><span style=\\"color:#FF0000\\">Unusual property for sale; unusual homes for sale; unique homes. This is the home of unique property, or unusual real estate </span>-&nbsp;</em> one of the most popular &amp; successful sites on the web.: <a href=\\"http://www.property.org.uk/unique/ad.html\\">http://www.property.org.uk/unique/ad.html</a><br />\r\nWhat about?: <a href=\\"http://www.property.org.uk/house-swaps/index.html\\">http://www.property.org.uk/house-swaps/index.html</a><br />\r\nWhat about?: <a href=\\"http://theuniquepropertysite.wordpress.com\\">http://theuniquepropertysite.wordpress.com</a></span></p>\r\n\r\n<p><span style=\\"font-size:14px\\"><span style=\\"background-color:rgb(204, 204, 255); color:rgb(0, 0, 0); font-family:verdana\\">Did you know that Homes on the Unique Property Site are regularly featured by most of the tv channels, the FT, The Times, The Daily Mail, Southern Cross t.v. in Australia, Toro Magazine in Canada, in Dubai and Tokyo?&nbsp;We get to the customers few other sites can hope to reach. We have clients in over 70 countries.</span></span></p>\r\n\r\n<p><span style=\\"color:rgb(85, 85, 85); font-family:lato,helvetica,sans-serif; font-size:14px\\">The Property Organisation is the Property&nbsp;Portal providing great Products &amp; Services Including:&nbsp;</span></p>\r\n\r\n<p><span style=\\"font-size:14px\\"><strong>ALLPRODUCTSDIRECT</strong>: Where you choose from the&nbsp;Best Brands,&nbsp;Best Prices,&nbsp;Best Service, of&nbsp;everyday household appliances, Where&nbsp;Next Day Delivery is available on orders booked before midnight!</span></p>\r\n\r\n<p><span style=\\"color:rgb(85, 85, 85); font-family:lato,helvetica,sans-serif; font-size:14px\\">&quot;We have harnessed the combined buying power of Estate agents &amp; Letting agentsthroughout the Country, enabling them to become a supply source for both essential household appliances and &nbsp;home improvement products.</span><br />\r\n<span style=\\"color:rgb(85, 85, 85); font-family:lato,helvetica,sans-serif; font-size:14px\\">Through us Estate Agents &amp; Letting Agents can now supply house Sellers, house Buyers, Landlords, Property Developers and house Builders a comprehensive range of household appliances, kitchens and bathrooms. We intend to maximise the collective buying power of estate agents in the UK to provide quality services nationwide.</span><br />\r\n<span style=\\"color:rgb(85, 85, 85); font-family:lato,helvetica,sans-serif; font-size:14px\\">Estate Agents &amp; Letting Agents can now offer over 3500 different household appliances to their customer base at extremely competitive prices, with an optional next day delivery service. In most cases we will publish a daily price check on the individual items, comparing alternative suppliers and potential savings. Through us these Agents will also have access to over 100 KITCHEN and BATHROOM representatives.&quot;</span></p>\r\n\r\n<p>&nbsp;</p>\r\n', 1);

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

--
-- Table structure for table `tbl_gallery`
--

CREATE TABLE IF NOT EXISTS `tbl_gallery` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `photo` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `status` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `tbl_gallery`
--

INSERT INTO `tbl_gallery` (`id`, `photo`, `description`, `status`) VALUES
(1, '1397722247s.png', 'Service Apartments', 1),
(2, '1397722222l.jpg', 'Hotel', 1),
(3, '13977221721.jpg', 'Bathroom', 1),
(4, '1397722148n.jpg', 'Kitchen', 1),
(5, '1397722275t.jpg', 'Property', 1);

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

--
-- Table structure for table `tbl_news`
--

CREATE TABLE IF NOT EXISTS `tbl_news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `headlines` varchar(255) NOT NULL,
  `photo` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `posted_date` datetime NOT NULL,
  `status` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `tbl_news`
--

INSERT INTO `tbl_news` (`id`, `headlines`, `photo`, `description`, `posted_date`, `status`) VALUES
(2, 'Test News', '13962620531.jpg', '<p><span style="color: rgb(116, 116, 116); font-family: ''Open Sans'', sans-serif;">V.I.P Concierge works closely with you to customize the perfect option for you during your visit to the Washington metropolitan area .All customers will have access to the same benefits through our integrated 5 star services: relief that comes from relying on dependable professionals to get the job done.</span></p>\r\n', '2014-03-31 03:33:49', 1);

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

--
-- Table structure for table `tbl_newsletter_template`
--

CREATE TABLE IF NOT EXISTS `tbl_newsletter_template` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `posted_date` datetime NOT NULL,
  `status` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `tbl_newsletter_template`
--

INSERT INTO `tbl_newsletter_template` (`id`, `title`, `description`, `posted_date`, `status`) VALUES
(2, 'Testing', '<p>This is testing..</p>\r\n', '2014-04-01 11:26:48', 1);

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

--
-- Table structure for table `tbl_service`
--

CREATE TABLE IF NOT EXISTS `tbl_service` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `service_name` varchar(255) NOT NULL,
  `photo` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `status` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;

--
-- Dumping data for table `tbl_service`
--

INSERT INTO `tbl_service` (`id`, `service_name`, `photo`, `description`, `status`) VALUES
(7, 'SERVICED APARTMENTS', '1397562459s.png', '<p style=\\"margin-left:.5in\\"><a href=\\"http://westlondonapartments.co.uk/\\"><span style=\\"color:rgb(85, 85, 85); font-family:lato,helvetica,sans-serif; font-size:14px\\">Click here to View &amp; Book on-line now</span></a></p>\r\n\r\n<p style=\\"margin-left:.5in\\"><strong><span style=\\"color:rgb(85, 85, 85); font-family:lato,helvetica,sans-serif; font-size:14px\\">What is a Serviced Apartment?</span></strong></p>\r\n\r\n<p style=\\"margin-left:.5in\\"><br />\r\n<span style=\\"color:rgb(85, 85, 85); font-family:lato,helvetica,sans-serif; font-size:14px\\">Serviced Apartments offer the comfort and convenience of home with greater space and at a lower price than a hotel of comparable standard. Serviced accommodation of this sort is offered across the world, but because the market is still relatively young, global models and global operators are not common. In fact the accommodation varies quite considerably from country to country and even city to city. You will find similar accommodation listed under many different categories: aparthotels, residences, boardinghaus, short-lets, short-term accommodation, extended-stay hotels, corporate housing, executive housing and in the leisure market short-term holiday lets and holiday rentals. You will usually receive your key through a Reception Desk or Meet and Greet service. </span><span style=\\"font-size:14px\\">It is also common is to receive access information by courier or a coded collection box. Facilities in serviced apartments are more extensive that a hotel room. You will usually have a smaller public area, with facilities such as swimming pool or restaurant less common. The serviced apartments sector in the UK does in fact embrace several accommodation types from a building which includes several self-contained flats through to the extended stay aparthotel model which is very close to traditional hotel accommodation. For longer term housing requirements, please contact us via the <a href=\\"http://iproperty.org.uk/contact-us.php\\">CONTACT US form</a> or else by email:&nbsp; info (a) property.org.uk.</span></p>\r\n', 1),
(12, 'INSTANT HOTEL SEARCH', '13976363023.jpg', '<p><span style=\\"color:rgb(85, 85, 85); font-family:lato,helvetica,sans-serif; font-size:14px\\"><a href=\\"http://www.latebookings.info/\\">Click here to begin your Instant Hotel Search</a>:&nbsp;</span></p>\r\n', 1),
(13, 'TAX & ACCOUNTS', '1397636385t.jpg', '<p><span style=\\"color:rgb(85, 85, 85); font-family:lato,helvetica,sans-serif; font-size:14px\\"><a href=\\"http://www.nunn-hayward.com/about.htm\\">For further details or&nbsp;to arrange an appointment (Click on this link)</a>:</span></p>\r\n', 1),
(10, 'UNIQUE PROPERTY SITE', '1397561361y.jpg', '<h4><span style=\\"color:#ff0000\\">For Unusual property for sale; unusual homes for sale; unique homes. This is the home of unique property, or unusual real estate.</span></h4>\r\n\r\n<p>Click on this link for the Unique Property site HOME PAGE and <strong>for the full index to properties for sale</strong>:</p>\r\n\r\n<p><a href=\\"http://www.property.org.uk/unique/\\">www.property.org.uk/unique/</a></p>\r\n\r\n<h3><em>The Birth of the Unique property site</em>:</h3>\r\n\r\n<p>I suppose I first went online in the seventies when I purchased, at great cost, a mobile phone. It was the size of a suitcase, weighed a ton, and was erratic to say the least. One day I lost my temper with it and threw it in the Mediterranian Sea. The experience put me off mobile phones, and I still dont own one. One day, maybe, when they do what I need I&#39;ll buy another.<br />\r\n<br />\r\nI then got online by a different route, getting my phone plugged into what was called in the UK the public data network. I joined a couple of bulletin boards back in the early eighties. I had a router, and a cradle to set the handset into so it could receive the noise which sounded like high speed morse code.<br />\r\n<br />\r\nIn those days those of us who lived in West London had two exchanges we could use for data transfer, one in Central London, and one in Slough.<br />\r\n<br />\r\nOne day I heard about an invention that would make the data network more efficient. It was called the world wide web. At the time I was working for an adult training network in West London. It&#39;s a long time ago (1991) but as far as I recall after a few false starts I opened an account with an American online presence called <em>The Well</em> which operated out of San Francisco.<br />\r\n<br />\r\nWe later (1992 I think) obtained an account in the UK through an educational establishment. Towards the end of the year a public service provider went public in the UK (Demon), and we opened an account with them as well. This gave me two email accounts, which, for 1992, was pretty unusual.<br />\r\n<br />\r\nAt the time it struck me that this was a great way to sell houses, and I noted a dummy US property site, which I emulated for the UK. I used this for normal houses for a year, and access was free. That was the big point of it all.<br />\r\n<br />\r\nTowards the end of the year I thought about putting unusual properties on the market. I had been a subscriber to a quarterly mailout from the <em>Historic Buildings Bureau</em>, which sent out a massive list of listed buildings for sale, including mills, castles, and all kinds of unusual properties.<br />\r\n<br />\r\nLater I discovered a privately operated monthly magazine which I believe was called <em>Alternative Househunter</em>, which advertised itself as providing unique homes for unique people, which I thought was a fine concept.<br />\r\n<br />\r\nA couple of years later I suggested to Russ, who ran this magazine, that he put it online. He was not keen, so I said I&#39;d do it for him, and so my own site morphed into <strong>The Unique Property Site</strong> with a different url and a different provider. He still wasn&#39;t keen, and after a couple more years we lost contact with each other, but the <strong>Unique Property Site</strong> kept going, and has been going ever since.<br />\r\n<br />\r\nThe site has been going in one form or another since 1992, which was the year the world wide web came to Britain. We are, therefore, the oldest continuously running property website on the web.<br />\r\n<br />\r\nWe were the first property website in the UK; the first property site to run animated gifs (back in 1994) when most of the existing browsers couldn&#39;t even show pictures; the first to list properties for free (which we did for two years while newer sites were charging hefty rates); the first to run affiliate programs; the first to implement RSS channels; the first to set up a bulletin board; the first to run podcasts; and probably the first property site to drop rather a lot of these things later on.<br />\r\n<br />\r\nMore importantly we are in the top ten listings for all our categories. In fact, almost all the listings are in the top three places in Google and Yahoo.<br />\r\n<br />\r\nOn the <strong>Unique</strong> home page there are links to some of the praise that we&#39;ve garnered. Not all of it of course, we haven&#39;t got the room. And there is a page showing screen prints of searches in the top search engines showing how well we appear. <strong>The Unique Property Site</strong> is a great place to advertise if you are trying to sell an unusual property.</p>\r\n', 1),
(8, 'BATHROOM', '13975623001.jpg', '<p><span style=\\"color:rgb(85, 85, 85); font-family:lato,helvetica,sans-serif; font-size:14px\\"><a href=\\"http://www.allproductsdirect.com/bathrooms\\">Click here to Book your free home design visit today to plan your dream bathroom</a>.</span></p>\r\n', 1),
(14, 'ALL PRODUCTS DIRECT', '1397636486e.jpg', '<p><span style=\\"color:rgb(85, 85, 85); font-family:lato,helvetica,sans-serif; font-size:14px\\">Click over here for: <a href=\\"http://www.allproductsdirectappliances.com/\\">The Best Brands. Best Prices. Best Service</a></span><br />\r\n<a href=\\"http://www.allproductsdirectappliances.com/\\"><span style=\\"color:rgb(85, 85, 85); font-family:lato,helvetica,sans-serif; font-size:14px\\">Choose &amp; Order all your household appliances here, with&nbsp;</span><br />\r\n<span style=\\"color:rgb(85, 85, 85); font-family:lato,helvetica,sans-serif; font-size:14px\\">Next Day Delivery available on orders before midnight &amp; so much mores</span></a></p>\r\n', 1),
(15, 'UK PROPERTY', '1397637649t.jpg', '<p><span style=\\"color:rgb(85, 85, 85); font-family:lato,helvetica,sans-serif; font-size:14px\\">Please use the <a href=\\"http://iproperty.org.uk/contact-us.php\\">Contact us form</a> or else email&nbsp;us at:</span><br />\r\n<br />\r\n<span style=\\"color:rgb(85, 85, 85); font-family:lato,helvetica,sans-serif; font-size:14px\\">Email :&nbsp;info@property.org.uk</span></p>\r\n', 1),
(16, 'OVERSEAS PROPERTY', '1397637711b.jpg', '<p><span style=\\"color:rgb(85, 85, 85); font-family:lato,helvetica,sans-serif; font-size:14px\\">Please use the <a href=\\"http://iproperty.org.uk/contact-us.php\\">Contact us form</a> or else email&nbsp;us at:</span><br />\r\n<br />\r\n<span style=\\"color:rgb(85, 85, 85); font-family:lato,helvetica,sans-serif; font-size:14px\\">Email :&nbsp;info@property.org.uk</span></p>\r\n', 1),
(17, 'INTERIOR DESIGN', '1397637814r.jpg', '<p><span style=\\"color:rgb(85, 85, 85); font-family:lato,helvetica,sans-serif; font-size:14px\\">Please use the <a href=\\"http://iproperty.org.uk/contact-us.php\\">Contact us form</a> or else email&nbsp;us at:</span><br />\r\n<br />\r\n<span style=\\"color:rgb(85, 85, 85); font-family:lato,helvetica,sans-serif; font-size:14px\\">Email :&nbsp;info@property.org.uk</span></p>\r\n', 1),
(9, 'KITCHENS', '1397562108n.jpg', '<p style=\\"margin-left:.5in\\"><a href=\\"http://www.allproductsdirect.com/kitchens\\"><span style=\\"color:rgb(85, 85, 85); font-family:lato,helvetica,sans-serif; font-size:14px\\">Click here to Book your free home design visit today to plan your dream kitchen</span></a></p>\r\n', 1),
(18, 'FINDERS/SEEKERS SERVICES', '1397637898s.jpg', '<p><span style=\\"color:rgb(85, 85, 85); font-family:lato,helvetica,sans-serif; font-size:14px\\">Please use the <a href=\\"http://iproperty.org.uk/contact-us.php\\">Contact us form</a> or else email&nbsp;us at:</span><br />\r\n<br />\r\n<span style=\\"color:rgb(85, 85, 85); font-family:lato,helvetica,sans-serif; font-size:14px\\">Email :&nbsp;info@property.org.uk</span></p>\r\n', 1),
(19, 'RESOURCES', '13976379573.jpg', '<p><span style=\\"color:rgb(85, 85, 85); font-family:lato,helvetica,sans-serif; font-size:14px\\">Please use the <a href=\\"http://iproperty.org.uk/contact-us.php\\">Contact us form</a> or else email&nbsp;us at:</span><br />\r\n<br />\r\n<span style=\\"color:rgb(85, 85, 85); font-family:lato,helvetica,sans-serif; font-size:14px\\">Email :&nbsp;info@property.org.uk</span></p>\r\n', 1),
(11, 'LATE HOTEL BOOKINGS', '1397636208l.jpg', '<p><span style=\\"color:rgb(85, 85, 85); font-family:lato,helvetica,sans-serif; font-size:14px\\"><a href=\\"http://www.latebookings.info/\\">Click here to make your Worldwide Late Hotel Bookings</a>:&nbsp;</span></p>\r\n', 1),
(20, 'PORTFOLIO BUILDING ', '1398237538o.jpg', '<p>We can provide a wide variety of Strategies &amp; help, including our</p>\r\n\r\n<p><strong>Hands-Free Property Portfolio Building Service</strong>:&nbsp;</p>\r\n\r\n<p>We can build you a fully managed Property Portfolio of 5 properties 22-40% Below Market Value</p>\r\n\r\n<p>Please use the <a href=\\"http://iproperty.org.uk/contact-us.php\\">Contact Us form</a> to find out more or else email&nbsp;us at: Email :&nbsp;info (a) property.org.uk&nbsp;</p>\r\n\r\n<p>You could well be very busy, with other aspects of your life, including running your own business, and don&rsquo;t necessarily want to do all the work yourself. You may well have the money to invest but you&rsquo;re concerned about risk, the economy, low interest rates or by poor performing pensions. We are here for you.<br />\r\nWe can save you a lot of time (and more) whilst making you money by building and managing a handsfree property portfolio that you could retire on. We can help you create, build, maintain and enjoy more long term financial returns. This service is available by <a href=\\"http://iproperty.org.uk/contact-us.php\\">Application &amp; Qualification Only</a>. We can provide the complete solution: a Handsfree Portfolio of Properties with a minimum of &pound;80,000 equity [fully managed, maintained, let &amp; sourced], and monthly income.</p>\r\n\r\n<div style=\\"font-family: sans-serif, Arial, Verdana, \\''Trebuchet MS\\''; font-size: 13px; color: rgb(51, 51, 51); background-color: rgb(255, 255, 255); margin-top: 20px; margin-right: 20px; margin-bottom: 20px; margin-left: 20px; line-height: 1.6em; cursor: text; \\">\r\n<div style=\\"font-family: sans-serif, Arial, Verdana, \\''Trebuchet MS\\''; font-size: 13px; color: rgb(51, 51, 51); background-color: rgb(255, 255, 255); margin-top: 20px; margin-right: 20px; margin-bottom: 20px; margin-left: 20px; line-height: 1.6em; cursor: text; \\">\r\n<p>&nbsp;</p>\r\n</div>\r\n</div>\r\n', 1);

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

--
-- Table structure for table `tbl_social`
--

CREATE TABLE IF NOT EXISTS `tbl_social` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `social_url` text NOT NULL,
  `status` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `tbl_social`
--

INSERT INTO `tbl_social` (`id`, `title`, `social_url`, `status`) VALUES
(1, 'Facebook', 'https://www.facebook.com/', 1),
(2, 'Twitter', '', 1),
(3, 'LinkedIn', '', 1),
(4, 'Google+', '', 1),
(5, 'Pinterest', '', 1);

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

--
-- Table structure for table `tbl_subscriber`
--

CREATE TABLE IF NOT EXISTS `tbl_subscriber` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subscribd_date` datetime NOT NULL,
  `email` varchar(255) NOT NULL,
  `status` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

--
-- Dumping data for table `tbl_subscriber`
--

INSERT INTO `tbl_subscriber` (`id`, `subscribd_date`, `email`, `status`) VALUES
(8, '2014-04-07 17:15:51', 'sunil.verma@sntinfotech.com', 1),
(7, '2014-04-01 13:18:49', 'dasda@dsds.com', 1),
(9, '2014-04-18 00:41:07', 'michael@property.org.uk', 1),
(10, '2014-04-18 17:59:48', 'kiyoko24@hotmail.co.uk', 1),
(11, '2014-04-29 22:34:40', 'trudiavila@gmail.com', 1);

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

--
-- Table structure for table `tbl_testimonial`
--

CREATE TABLE IF NOT EXISTS `tbl_testimonial` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `testimonial` text NOT NULL,
  `posted_by` varchar(255) NOT NULL,
  `photo` varchar(255) NOT NULL,
  `posted_date` datetime NOT NULL,
  `status` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `tbl_testimonial`
--

INSERT INTO `tbl_testimonial` (`id`, `testimonial`, `posted_by`, `photo`, `posted_date`, `status`) VALUES
(3, '\\"What an amazing website, I just love coming here to browse again & again.\\"', 'James', '1397722578simon_gill.jpg', '2014-04-11 03:40:43', 1),
(4, '\\"we have seen a significant rise in the number of inquires and viewings this year from people that have seen our home on your excellent website (Our estate agent has been useless...)\\"', 'Unique Property member', '', '2014-04-22 19:53:22', 1),
(5, '\\"we accepted an offer yesterday! ... it was your site got the buyer, not the agent. Thanks. Jim\\"', 'Jim', '', '2014-04-22 19:55:42', 1),
(6, 'Lots more can be found & you can read them here by visiting:\r\n\r\nUnsolicited testimonials.....\r\nhttp://www.property.org.uk/unique/thanks.html', 'Linda Williams', '', '2014-04-22 20:08:23', 1),
(7, '\\"I thought that I would just drop you a line to say how much I enjoy your words of wisdom. Based on your considerable property experience, you do certainly make a great deal of sense, and it is quite', 'Stephen Wright, Gainsborough', '', '2014-04-22 20:14:00', 1);

