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




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

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `id` int(10) NOT NULL,
  `category_title` varchar(50) NOT NULL,
  `category_description` varchar(256) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `costs`
--

CREATE TABLE `costs` (
  `id` smallint(5) UNSIGNED NOT NULL,
  `website_service` varchar(50) NOT NULL,
  `website_service_heading` varchar(60) NOT NULL,
  `website_service_description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `costs`
--

INSERT INTO `costs` (`id`, `website_service`, `website_service_heading`, `website_service_description`) VALUES
(1, 'Domain Name Registration', 'Domain Name Registration Services', '<table class="table table-hover table-condensed">\r\n    <tbody>\r\n        <tr class="">\r\n            <td width="85%">.co.za - registration</td>\r\n            <td>R 150.00</td>\r\n        </tr>    \r\n        <tr class="">\r\n            <td>.com - registration</td>\r\n            <td>R 250.00</td>\r\n        </tr>             \r\n        <tr class="">\r\n            <td>All other domain names starting from</td>\r\n            <td>R 250.00</td>\r\n        </tr>             \r\n    </tbody>                                        \r\n</table>\r\n'),
(2, 'Hosting', 'Domain Hosting', '<table class="table table-hover table-condensed">\r\n    <tbody>\r\n        <tr class="">\r\n            <td width="85%">Parking with only email alias accounts</td>\r\n            <td>R 300.00</td>\r\n        </tr>    \r\n        <tr class="">\r\n            <td>Basic, suitable for the new website not expecting high traffic</td>\r\n            <td>R 600.00</td>\r\n        </tr>             \r\n        <tr class="">\r\n            <td>Commercial, suitable for all aspects of commercial sites from</td>\r\n            <td>R 1 200.00</td>\r\n        </tr>      \r\n        <tr class="">\r\n            <td>Additional POP Email Accounts</td>\r\n            <td>R 250.00 pa</td>\r\n        </tr>             \r\n    </tbody>                                        \r\n</table>\r\n'),
(3, 'SEO', 'Search Engine Optimisation', '<table class="table table-hover table-condensed">\r\n    <tbody>\r\n        <tr class="">\r\n            <td width="85%">5 page search engine optimisation</td>\r\n            <td>R 1 800.00</td>\r\n        </tr>    \r\n        <tr class="">\r\n            <td>1 page search engine optimisation</td>\r\n            <td>R 1 000.00</td>\r\n        </tr>             \r\n        <tr class="">\r\n            <td>New search engine optimised content per paragraph</td>\r\n            <td>R 250.00</td>\r\n        </tr>             \r\n        <tr class="">\r\n            <td>New search engine optimised content per page</td>\r\n            <td>R 500</td>\r\n        </tr>             \r\n    </tbody>                                        \r\n</table>\r\n'),
(4, 'SEO Management', 'SEO Monthly Mangement', '<table class="table table-hover table-condensed">\r\n    <tbody>\r\n        <tr class="">\r\n            <td width="85%">5 Page Static website initial coding restructure and image optimisation</td>\r\n            <td>R 1 300.00</td>\r\n        </tr>    \r\n        <tr class="">\r\n            <td>5 page Dynamic website initial coding restructure and image optimisation</td>\r\n            <td>R 2 000.00</td>\r\n        </tr>             \r\n        <tr class="">\r\n            <td>Plus fine tuning of search engine optimization and detailed traffic feedback reports per month - min 6 sessions</td>\r\n            <td>R 250.00</td>\r\n        </tr>             \r\n    </tbody>                                        \r\n</table>'),
(5, 'Website Traffic Management', 'Website Traffic Objectives', '<table class="table table-hover table-condensed">\r\n    <tbody>\r\n        <tr class="">\r\n            <td width="85%">Initial set up fee for 5 pages from</td>\r\n            <td>R 700.00</td>\r\n        </tr>    \r\n        <tr class="">\r\n            <td>Fine tuning of human interaction and detailed traffic feedback per month, minimum 6 sessions</td>\r\n            <td>R 550.00 per</td>\r\n        </tr>             \r\n    </tbody>                                        \r\n</table>'),
(6, 'Google Adwords', 'Google Adwords Pay Per Click Advertising', '<table class="table table-hover table-condensed">\r\n    <tbody>\r\n        <tr class="">\r\n            <td width="75%">Adwords Campaign setup and creation of advert from</td>\r\n            <td>R 550.00</td>\r\n        </tr>    \r\n        <tr class="">\r\n            <td>Adwords Campaign Management. 5% of monthly Budget spend. Minimum fee per month R 550.00</td>\r\n            <td>R 550.00</td>\r\n        </tr>             \r\n    </tbody>                                        \r\n</table>'),
(7, 'Website Promotion', 'Manual submission', '<table class="table table-hover table-condensed">\r\n    <tbody>\r\n        <tr class="">\r\n            <td width="85%">Manual submission of your website to 10 Free Business Directories</td>\r\n            <td>R 2 499.00</td>\r\n        </tr>    \r\n    </tbody>                                        \r\n</table>');

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

--
-- Table structure for table `faq`
--

CREATE TABLE `faq` (
  `id` int(5) NOT NULL,
  `website_question` varchar(50) NOT NULL,
  `website_answer` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `faq`
--

INSERT INTO `faq` (`id`, `website_question`, `website_answer`) VALUES
(1, 'What is Web-Objectives.com ?', 'Web-Objectives.com is a professional website design, development and hosting service designed to help individuals and small businesses build quality websites. With Web-Objectives.com, will create a website to share your personal thoughts, your hobbies, or even create an online store to showcase your products'),
(2, 'How long does it take to build my website ?', 'With Web-Objectives.com, we can design and publish your website in 48 hours'),
(3, 'Can Web-Objectives Optimize my Website ?', 'Absolutely yes.  One of Web-Objectives website services is is Website Optimization');

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

--
-- Table structure for table `hosting`
--

CREATE TABLE `hosting` (
  `id` int(11) NOT NULL,
  `hosting_type` varchar(50) NOT NULL,
  `hosting_package` varchar(50) NOT NULL,
  `hosting_benefit` varchar(250) NOT NULL,
  `cost` varchar(10) NOT NULL,
  `description` varchar(500) NOT NULL,
  `display` varchar(10) NOT NULL,
  `panel_color` varchar(10) NOT NULL,
  `label_color` varchar(10) NOT NULL,
  `btn_color` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hosting`
--

INSERT INTO `hosting` (`id`, `hosting_type`, `hosting_package`, `hosting_benefit`, `cost`, `description`, `display`, `panel_color`, `label_color`, `btn_color`) VALUES
(1, 'WebsiteStarter', 'Website Starter', 'Great value for those starting a personal blog or a small website showcasing recipes, photos or hobbies', '49', '<ul>\r\n<li><strong>First month FREE</strong></li>\r\n<li>5 X 20MB mailboxes</li>\r\n<li>Tech support 365 days a year</li>\r\n<li>1 Database</li>\r\n<li>R49PM Hosting</li>\r\n<li>Website Hosting <a href="terms-of-usage.php">t''s & c''s</a></li>\r\n</ul>', 'on', 'default', 'default', 'warning'),
(2, 'WebsiteLite', 'Website Lite', 'Ideal for those with a personal blog or small website who need bigger mailboxes', '99', '<ul>\r\n    <li><strong>First month FREE</strong></li>\r\n    <li>5 X 50MB mailboxes</li>\r\n    <li>Tech support 365 days a year</li>\r\n    <li>1 Database</li>\r\n    <li>R99PM Hosting</li>\r\n    <li>Website Hosting <a href="terms-of-usage.php">t''s & c''s</a>\r\n</ul>', 'on', 'default', 'default', 'warning'),
(3, 'WebsitePro', 'Website Pro', 'The solution for new small businesses needing multiple mailboxes, website stats reporting & easy to install applications', '149', '<ul>\r\n<li><strong>First month FREE</strong></li>\r\n<li>10 X 50MB mailboxes</li>\r\n<li>Tech support 365 days a year</li>\r\n<li>1 Database</li>\r\n<li>R149PM Hosting</li>\r\n<li>Website Hosting <a href="terms-of-usage.php">t''s & c''s</a>\r\n</ul>', 'on', 'default', 'default', 'warning'),
(4, 'WebsiteUltra', 'Website Ultra', 'The solution for new small businesses needing multiple mailboxes, website stats reporting & easy to install applicationsFor those small businesses who need tech support 365 days a year, as well as additional mailboxes, databases & tools', '199', '<ul>\r\n<li><strong>First month FREE</strong></li>\r\n<li>20 X 50MB mailboxes</li>\r\n<li>Tech support 365 days a year</li>\r\n<li>1 Database</li>\r\n<li>R149PM Hosting</li>\r\n<li>Website Hosting <a href="terms-of-usage.php">t''s & c''s</a>\r\n</ul>', 'on', 'default', 'default', 'warning');

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

--
-- Table structure for table `portfolio`
--

CREATE TABLE `portfolio` (
  `id` smallint(5) UNSIGNED NOT NULL,
  `website_type` varchar(100) NOT NULL,
  `company_name` varchar(60) NOT NULL,
  `company_description` varchar(250) NOT NULL,
  `alt` varchar(250) NOT NULL,
  `email` varchar(60) NOT NULL,
  `tel` varchar(100) NOT NULL,
  `website_url` varchar(50) NOT NULL,
  `website_link` varchar(50) NOT NULL,
  `image` varchar(60) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `portfolio`
--

INSERT INTO `portfolio` (`id`, `website_type`, `company_name`, `company_description`, `alt`, `email`, `tel`, `website_url`, `website_link`, `image`) VALUES
(1, 'Stainless Steel Manufacturing Website ', 'AMD Engineering', 'Stainless Steel Manufacturers of Plated Mild Steel Shopfitting Rails, Fittings and Fixtures', 'Manufacturer of Plated Mild Steel and Stainless Steel Shopfitting Rails\nManufacturer of Customized Shopfitting Equipment\nInternational Equipment Supplier', 'michael@amdengineering.com', '+27 (021) 511 0088', 'amdengineering.com', '', 'amdengineering.jpg'),
(2, 'Car Rental Website', 'Bizzy Car Hire', 'Cheap Affordable Cash Car Rentals in Cape Town', 'Quality Cheap Car Rentals in Cape Town\r\nCash Car Rentals - Check out our Car Rental Rates...', 'info@bizzycarhire.co.za', '+27 (021) 21 557 7682', 'bizzycarhire.co.za', '', 'bizzycarhire.jpg'),
(3, 'Commercial & Property Realtors Website', 'Aida Witbank', 'Aida Witbank Real Estate Property Website', 'Commercial & Property Realtors in Pretoria North', 'witbank@aidawitbank.co.za', '+27 (012) 13 690 2131', 'aidawitbank.co.za', '', 'aidawitbank.jpg'),
(4, 'Shark Cage Diving Website', 'CapeTown4Less', 'Shark Cage Diving and Shark Breaching Website', 'Shark Cage Diving & Shark Breaching in Cape Town', 'mark@capetown4less.co.za', '+27 082 573 9466', 'capetown4less.co.za', '', 'sharkcagediving.jpg'),
(5, 'Refrigeration & Air-conditioning Website', 'Frigotech - Refrigeration & Air-conditioning ', 'Frigotech Refrigeration & Air-conditioning Supplies, Installs, Services & Repairs all Residential, Commercial & Industrial Air-conditioners', 'Frigotech Refrigeration & Air-conditioning Supplies, Installs, Services & Repairs all Residential, Commercial & Industrial Air-conditioners', 'mario@frigotech.co.za', '+27 (021) 557 6191', 'frigotech.co.za', '', 'frigotech.jpg'),
(6, 'Medical Recruiting Agency Website', 'Glasshouse Recruiting', 'Medical Recruiting Agency for the Medical Industry based in Cape Town South Africa Specialising in Medical Placements', 'medical recruitment agency specialising in medical placements, providing medical representative jobs in the medical field including pharmaceutical, surgical sales, laboratory technicians, nurses, pharmacists, paramedics and physiotherapists', 'info@glass-house.co.za', '+27 (021) 554 5309', 'glasshouserecruiting.co.za', 'http://localhost/glasshouse/index.php', 'glasshouserecruiting.jpg'),
(7, 'Italian Restaurant Website', 'Eden Cafe', 'Eden Cafe Restaurant | Cocktail Bar | Coffee Shop', 'Eden Cafe Restaurant | Cocktail Bar | Coffee Shop', 'leon@edencafe.co.za', '+27 (021) 554 9660', 'edencafe.co.za', '', 'edencafe.jpg'),
(8, 'Indian Restaurant Website', 'The Indian Chapter', 'Indian Restaurant Specializing in Indian Cuisine', 'Indian Restaurant', 'prim@theindianchapter.co.za', '+27 (021) 557 5524', 'theindianchapter.co.za/', '', 'theindianchapter.jpg'),
(9, 'Sales Training & Management Workshop Website', 'Meridian Sales Training', 'Corporate Sales Training | Medical Device Sales Training | Pharmaceutical Sales Training | Sales Management Coaching | General sales Training Enquiries', 'Specialized Sales Training - Sales Training & Management Workshop Website', 'peter@meridiansalestraining.co.za', '+27 076 699 5071', 'meridiansalestraining.co.za', '', 'meridiansalestraining.jpg'),
(10, 'Laboratory Specialist Website', 'Optimascientific', 'Service provider and supplier of laboratory equipment, reagents and consumables. Laboratory Specialists for South Africa & Africa.', 'Service provider and supplier of laboratory equipment, reagents and consumables', 'stuart@optimascientific.co.za', '+27 082 808 2846', 'optimascientific.co.za', '', 'optimascientific.jpg'),
(11, 'Dustless Sanding Sealing & Refurbishing Website', 'Flordek', 'Dustless Sanding, Sealing & Refurbishing of all types of Solid Wood Flooring, Cork, Parquet, \r\nEngineered flooring and decking', 'Dustless Sanding, Sealing & Refurbishing of all types of Solid Wood Flooring, Cork, Parquet, \r\nEngineered flooring and decking', 'sales@flordek.co.za', '+27 082 877 4079', 'flordek.co.za', '', 'flordek.jpg'),
(12, 'Unique Gourmet Panini sandwiches Website', 'Bite Me Cape Town', 'Come join us at Bite Me, our signature store, for some really cool and unique Gourmet Panini sandwiches done with a Touch of class and style', 'Come join us at Bite Me, our signature store, for some really cool and unique Gourmet Panini sandwiches done with a Touch of class and style', 'morne@gourmetpanini-ct.co.za', '+27 (021) 557 7248', 'gourmetpanini-ct.co.za', '', 'biteme.jpg'),
(13, 'Interior Shopfitting Designers Decorators Website', 'De Vries Interiors', 'Commercial and Domestic Interior Shopfitting Manufacturers, Designers & Decorators', 'Commercial and Domestic Interior Shopfitting Manufacturers, Designers & Decorators', 'info@devriesinteriors.co.za', '+27 082 9202056 ', 'devriesinteriors.co.za', '', 'devriesinteriors.jpg'),
(14, 'Moving Packing Storing Website', 'Express Removals', 'Household Removals, Office Removals, Storage, Long-Distance Removals, Packaging Supplies, Packing Service, Courier Distribution', 'Household Removals, Office Removals, Storage, Long-Distance Removals, Packaging Supplies, Packing Service, Courier Distribution', 'removals@mailbox.co.za', '+27 (021) 552 0588', 'expressremovals.co.za', '', 'expressremovals.jpg'),
(15, 'Mediterranean Restaurant Website', 'Cafe Sofia', 'Experience our tradition\r\nWe bring you the Mediterranean taste with a dazzling South African flair', 'Experience our tradition\r\nWe bring you the Mediterranean taste with a dazzling South African flair', 'beachbar@Cafesofia.co.za', '+27 (021) 554 0296', 'cafesofia.co.za', '', 'cafesofia.jpg'),
(16, 'Energy Resource Efficient & Environmentally Responsible Building Website', 'Build Green', 'Energy Efficient Resource Efficient & Environmentally Responsible Building Website', 'Energy Efficient Resource Efficient & Environmentally Responsible Building Website', 'leon@buildgreen.co.za', '+27 082 332-3070', 'buildgreen.co.za', '', 'buildgreen.jpg'),
(17, 'Gourmet Burgers & Panni Sandwiches Website', 'Bite Me - Gourmet Burgers and Panni Sandwiches', 'Gourmet Burgers and Panni Sandwiches', 'Gourmet Burgers and Panni Sandwiches', 'george@biteme.co.za', '+27 084 272 2039', 'biteme.co.za', '', 'gourmetburgersandsandwiches.jpg'),
(18, 'Handyman Services Website', 'Bob The Handyman', 'Let us do all the jobs you don''t have the time to do yourself', 'Let us do all the jobs you don''t have the time to do yourself', 'info@bobthehandyman.co.za', '+27 (021) 556 5918', 'bobthehandyman.co.za', '', 'bobthehandyman.jpg'),
(19, 'Actuarial Recruitment Experts Website', 'Iactuary', 'Actuarial Recruitment Experts', 'Actuarial Recruitment Experts', 'info@iactuary.co.za', '+27 (021) 433 1512', 'iactuary.co.za', '', 'iacturay.jpg'),
(20, 'Printing and Branding Website', 'GKBranding', 'GK Branding provides all your Sourcing, Printing and Branding solutions for your Promotional, Marketing and Corporate needs', 'Printing and Branding solutions for all your Promotional, Marketing and Corporate needs', 'guy@gkbranding.co.za', '+27 082 370 8890', 'gkbranding.co.za', '', 'gkbranding.jpg'),
(21, 'Grower and Supplier of all Lawns Website', 'Le Bois Lawns', 'Grower and Supplier - Buffalo | Kukuyu | Cynodan & Plugs', 'Grower and Supplier - Buffalo | Kukuyu | Cynodan & Plugs', 'stephan@rollonlawns.co.za', '+27 082 756 8241', 'rollonlawns.co.za', '', 'rollonlawns.jpg'),
(22, 'Organic Farm Website', 'Tonys Farm', 'Organically Grown Vegtebles', 'Organically Grown Vegtebles', 'tony@tonysfarm.co.za', '+27 082 557 1525', 'tonysfarm.co.za', '', 'tonysorganicfarm.jpg'),
(23, 'Wildchild Bush / Surf Camp & Adventures Website ', 'Wildchild Bush Camp', 'Outdoor Youth Activities / Adventure Camping Western Cape', 'Outdoor Youth Activities / Adventure Camping Western Cape', 'marlise@wildchildbushcamp.co.za', '+27 082 8666 049', 'wildchildbushcamp.co.za', '', 'wildchildbushcamp.jpg'),
(24, 'Leaders in CNC Engineering Machining Website', 'Speed Precision', 'CNC engineering machining - including CNC milling, CNC lathe work, Capstan parting, CNC drilling, as well as general fitting & turning capabilities', 'CNC engineering machining – including CNC milling, CNC lathe work, Capstan parting, CNC drilling, as well as general fitting & turning capabilities', 'clint@speedprecision.co.za', '+27 (021) 510 2169', 'speedprecision.co.za', '', 'speedprecision.jpg'),
(25, 'Hand Polishing and Automated Polishing Website', 'Polishing Solutions', 'Polishing Solutions Offers Hand Polishing as well as Automated Polishing', 'Polishing Solutions Offers Hand Polishing as well as Automated Polishing', 'paul@polishing-solutions.co.za', '+27 083 261 1297', 'polishing-solutions.co.za', '', 'polishingsolutions.jpg'),
(26, 'Bathroom Shower and Body Products Website', 'Soap - pamper your skin', 'Soaps Lotions &amp; Creams Shampoo &amp; Shower Gel Bubble Bath Gift Baskets Lip Balms &amp; Candle Tarts Bath Teas &amp; Gel Candles Fragrance List Pets Recipes Favorite Links', 'Soaps Lotions &amp; Creams Shampoo &amp; Shower Gel Bubble Bath Gift Baskets Lip Balms &amp; Candle Tarts Bath Teas &amp; Gel Candles Fragrance List Pets Recipes Favorite Links', 'lauren@bathroomproducts.co.za', '+27 (011) 656 7845', 'bathroomproducts.co.za', '', 'bathroomproducts.jpg'),
(27, 'Transport Company Website\r\n', 'Transport Cargo', 'Transport Company - We take care of your Cargo\r\n', 'Mostt Convinient & Reliable Transport Service', 'josha@transportcargo.co.za', '+27 (021) 5597248', 'transportcargo.co.za', '', 'transportcargo.jpg'),
(28, 'Administrative Tasks Website', 'Advisory Support', 'The world we live in is fast-paced. We understand that as an Advisor, there are many facets to your everyday business. Between calling, setting up appointments and servicing the needs of your clients, there aren''t enough hours in the day. And, when a', 'Advisory Support', 'dean@advisorysupport.ca', '074 060 4743', 'http://www.advisorsupport.com/', '', ''),
(29, 'Sound Engineering Website', 'Sound Principles', 'Distributor of quality high definition and high end home theatre systems', 'Distributor of quality high definition and high end home theatre systems', 'samuel@soundprinciples.co.za/', '+27 (0)82 899 4231', 'soundprinciples.co.za', 'web-objectives-portfolio.php', 'soundprinciples.co.za.jpg');

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

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` smallint(5) UNSIGNED NOT NULL,
  `glyphicon` varchar(50) NOT NULL,
  `links` varchar(60) NOT NULL,
  `title` varchar(100) NOT NULL,
  `heading` varchar(50) NOT NULL,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`id`, `glyphicon`, `links`, `title`, `heading`, `description`) VALUES
(1, 'glyphicon-hdd', 'hosting', 'Secure Hosting', 'Website Hosting ', 'A web host, or web hosting service provider, is a business that provides the technologies and services needed for the website or webpage to be viewed in the Internet. Websites are hosted, or stored, on special computers'),
(2, 'glyphicon-blackboard', 'mobile-app-development', 'Mobile Websites', 'Responsive Websites', 'A responsive website automatically changes to fit the device you''re reading it on. Typically there have been four general screen sizes that responsive design has been aimed at: the widescreen desktop monitor, the smaller'),
(3, 'glyphicon-wrench', 'website-rebuilds', 'Website Re-developments', 'Re-Developments', 'When it comes to updating your business website in a timely manner, the one rule is this: There are no rules. Deciding whether to update, redesign or re-engineer your site should depend entirely on your business goals'),
(4, 'glyphicon-shopping-cart', 'e-commerce', 'Ecommerce Websites', 'E-Commerce', 'Transacting or facilitating business on the Internet is called ecommerce. Ecommerce is short for "electronic commerce."? Popular examples of ecommerce revolve around buying and selling online. But the ecommerce'),
(5, 'glyphicon-road', 'search-engine-optimisation', 'Search Engine Optimization', 'SEO', 'Search Engine Optimisation is about employing a Website SEO Developer who is able to drive major volumes of quality, targeted website visitors to your website. The Developer is able to achieve this by using'),
(6, 'glyphicon-th-list', 'adwords-advertising', 'Adword Campaigns', 'AdWord Campaigns', 'Advertising with AdWords starts with creating a campaign. The type of campaign you choose to create should be based on your advertising goals. For example, if you''d like to show ads on Google.com to get more visitors to');

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

--
-- Table structure for table `testimonials`
--

CREATE TABLE `testimonials` (
  `id` smallint(5) UNSIGNED NOT NULL,
  `website_type` varchar(50) NOT NULL,
  `company_name` varchar(60) NOT NULL,
  `company_description` varchar(250) NOT NULL,
  `email` varchar(60) NOT NULL,
  `tel` varchar(100) NOT NULL,
  `website_url` varchar(50) NOT NULL,
  `client_comment` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `testimonials`
--

INSERT INTO `testimonials` (`id`, `website_type`, `company_name`, `company_description`, `email`, `tel`, `website_url`, `client_comment`) VALUES
(1, 'Stainless Steel Manufacturing Website ', 'AMD Engineering', 'Stainless Steel Manufacturers of Plated Mild Steel Shopfitting Rails, Fittings and Fixtures', 'michael@amdengineering.com', '+27 (021) 511 0088', 'amdengineering.com', 'Jan 2011<br><br>\r\nThank you to Web-Objectives.<br>\r\nWe are very happy with the website upgrade Dean has done to our site.<br>\r\nThey are always quick and efficient to respond, and their turn around times, are next to nothing!<br>\r\n We highly recommend their services and have already referred some of our clients to them."<br><br>\r\nRegards<br>\r\nMichael Dike'),
(2, 'Car Rental Website', 'Bizzy Car Hire', 'Cheap Affordable Cash Car Rentals in Cape Town', 'info@bizzycarhire.co.za', '+27 (021) 21 557 7682', 'bizzycarhire.co.za', 'Feb 2010<br><br>\nWe would like to take this opportunity and thank Dean and the Website team for job well done.<br>\nThe website rebuild has firmly positioned our website on Google for Car Rentals in Cape Town.<br>\nWe receive many enquiries on a daily basis.<br> \nKeep up the good work.<br><br>\nKind Regards<br>\nRoy'),
(3, 'Commercial & Property Realtors Website', 'Aida Witbank', 'Aida Witbank Real Estate Property Website', 'witbank@aidawitbank.co.za', '+27 (012) 13 690 2131', 'aidawitbank.co.za', 'Mar 2011<br><br>\r\nHi Dean<br>\r\nThank you for your hard work and effort on our website - it looks great! I have received the bill and gave instruction for it to be paid promptly.<br><br>\r\n\r\nBlessings Hein Strydom<br><br>\r\nPrincipal<br>\r\nAida Witbank'),
(4, 'Shark Cage Diving Website', 'CapeTown4Less', 'Shark Cage Diving and Shark Breaching Website', 'mark@capetown4less.co.za', '+27 082 573 9466', 'capetown4less.co.za', 'Nov 2009<br><br>\r\nHi Dean<br>\r\nHope you had a great festive season.\r\nI wanted to give you a call just before Xmas but just never got around to it, and I was going to call you now and realized it was Thursday.\r\n\r\nI''m not sure what you''ve done to my site but there are a defiantly more shark cage diving bookings and I''d like to thank you for that. With the increase of bookings I''ll take all the pics I can and send them to you soon.<br><br>\r\nCheers<br>\r\nMark'),
(5, 'Refrigeration & Air-conditioning Website', 'Frigotech - Refrigeration & Air-conditioning ', 'Frigotech Refrigeration & Air-conditioning Supplies, Installs, Services & Repairs all Residential, Commercial & Industrial Air-conditioners', 'mario@frigotech.co.za', '+27 (021) 557 6191', 'frigotech.co.za', 'Jan 2011<br><br>\nThanks Dean and the Website team for job well done.<br>\nThe website rebuild has firmly positioned our website on Google for Refrigeration & Air-conditioning in Cape Town.<br>\nWe receive many enquiries on a daily basis.<br> \nExcellent job.<br><br>\nRegards<br>\nMario'),
(6, 'Dustless Sanding Sealing & Refurbishing Website', 'Flordek', 'Dustless Sanding, Sealing & Refurbishing of all types of Solid Wood Flooring, Cork, Parquet, Engineered flooring and decking', 'sales@flordek.co.za', '+27 082 877 4079', 'flordek.co.za', 'Jan 2010<br><br>\r\n\r\nThank you to Web-Objectives.<br>\r\nWe are very happy with the website upgrade Dean has done to our site.<br>\r\nWe highly recommend their services and have already referred some of our clients to them.<br><br>\r\nRegards<br>\r\nMichael Dike'),
(7, 'Laboratory Supplier Website', 'Optimascientific', 'Service provider and supplier of laboratory equipment, reagents and consumables.\nLaboratory Specialists for South Africa & Africa.', 'stuart@optimascientific.co.za', '+27 082 808 2846', 'optimascientific.co.za', 'Jan 2010<br><br>\r\n\r\nThe website rebuild has positioned our website on Google.<br>\r\nWe receive many enquiries on a daily basis.<br>\r\nExcellent work Dean.<br><br>\r\nCheers from<br>\r\nStuart');

--
-- Indexes for table `category`
--
ALTER TABLE `category`
  ADD UNIQUE KEY `id` (`id`);

--
-- Indexes for table `costs`
--
ALTER TABLE `costs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `faq`
--
ALTER TABLE `faq`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `hosting`
--
ALTER TABLE `hosting`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `portfolio`
--
ALTER TABLE `portfolio`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `testimonials`
--
ALTER TABLE `testimonials`
  ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT for table `category`
--
ALTER TABLE `category`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `costs`
--
ALTER TABLE `costs`
  MODIFY `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `faq`
--
ALTER TABLE `faq`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `hosting`
--
ALTER TABLE `hosting`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `portfolio`
--
ALTER TABLE `portfolio`
  MODIFY `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;
--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `testimonials`
--
ALTER TABLE `testimonials`
  MODIFY `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
