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




--
-- Database: `webobjec_webobjectives`
--

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

--
-- Table structure for table `access`
--

CREATE TABLE `access` (
  `id` int(10) NOT NULL,
  `User_Email` varchar(100) NOT NULL,
  `User_Password` varchar(32) NOT NULL,
  `User_Level` varchar(10) NOT NULL,
  `Last_Accessed` date NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `access`
--

INSERT INTO `access` (`id`, `User_Email`, `User_Password`, `User_Level`, `Last_Accessed`) VALUES
(1, 'dean@web-objectives.com', 'user1', 'ADMIN', '2017-07-03');

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

--
-- 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 `tbadges`
--

CREATE TABLE `tbadges` (
  `id` int(11) NOT NULL,
  `ProductName` varchar(50) NOT NULL,
  `ProductType` varchar(50) NOT NULL,
  `ShortDescription` varchar(750) NOT NULL,
  `LargeImage` varchar(100) NOT NULL,
  `SmallImage` varchar(100) NOT NULL,
  `listing_date` date NOT NULL,
  `verification_code` varchar(100) NOT NULL,
  `display_status` varchar(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbadges`
--

INSERT INTO `tbadges` (`id`, `ProductName`, `ProductType`, `ShortDescription`, `LargeImage`, `SmallImage`, `listing_date`, `verification_code`, `display_status`) VALUES
(1, 'AutoCAD Design Suites Premium', 'Product Suite', '', 'large-AutoCadDesignSuitePremium2.jpg', 'small-AutoCadDesignSuitePremium2.jpg', '2013-04-11', '82568c7b548629d9a7d8ce8365095105', 'show'),
(2, 'AutoCAD Design Suites Standard', 'Product Suite', '', 'large-AutoCadDesignSuiteStandard2.jpg', 'small-AutoCadDesignSuiteStandard2.jpg', '2013-04-11', 'acc43eb43703116acf8497945df9089a', 'show'),
(3, 'AutoCAD Design Suites Ultimate', 'Product Suite', '', 'large-AutoCadDesignSuiteUltimate2.jpg', 'small-AutoCadDesignSuiteUltimate2.jpg', '2013-04-11', '73604811e2a9f2d917a2f1255fbe353d', 'show'),
(4, 'AutoDesk 3Ds Max', 'Product', '', 'large-Autodesk3DsMax.jpg', 'small-Autodesk3DsMax.jpg', '2013-04-11', 'a727df8ae4606565052391389e4203c5', 'show'),
(5, 'AutoDesk AutoCAD Civil 3D', 'Product', '', 'large-AutoDeskAutoCadCivil3D.jpg', 'small-AutoDeskAutoCadCivil3D.jpg', '2013-04-11', 'dc49b325b2588cf6d9faea5afbaad1bb', 'show'),
(6, 'AutoDesk AutoCAD LT', 'Product', '', 'large-AutoDeskAutoCadLT.jpg', 'small-AutoDeskAutoCadLT.jpg', '2013-04-11', '2009ccaa77e98a2241dbf01e017ef7a7', 'show'),
(7, 'AutoDesk AutoCAD Map 3D', 'Product', '', 'large-AutoDeskAutoCadMap3D.jpg', 'small-AutoDeskAutoCadMap3D.jpg', '2013-04-11', '2d159b8ae0f6719beee077bd62dd2fa7', 'show'),
(8, 'AutoDesk AutoCAD Mechanical', 'Product', '', 'large-AutoDeskAutoCadMechanical.jpg', 'small-AutoDeskAutoCadMechanical.jpg', '2013-04-11', '8c77699333a02f133ab6f25b85572441', 'show'),
(9, 'AutoDesk AutoCAD MEP', 'Product', '', 'large-AutoDeskAutoCadMEP.jpg', 'small-AutoDeskAutoCadMEP.jpg', '2013-04-11', '0f83a2526e49cd20bc564bc133a95fe2', 'show'),
(10, 'AutoDesk AutoCAD OEM', 'Product', '', 'large-AutoDeskAutoCadOEM.jpg', 'small-AutoDeskAutoCadOEM.jpg', '2013-04-11', 'b414b9135f81041818405c79058e474b', 'show'),
(11, 'AutoDesk AutoCAD Revit LT Suite', 'Product Suite', '', 'large-AutoDeskAutoCadRevitLTSuite.jpg', 'small-AutoDeskAutoCadRevitLTSuite.jpg', '2013-04-11', '8383399dde166502584e9651240395a2', 'show'),
(12, 'AutoDesk AutoCAD Design Suite Premium', 'Product Suite', '', 'large-AutoDeskBuildingDesignSuitePremium.jpg', 'small-AutoDeskBuildingDesignSuitePremium.jpg', '2013-04-11', 'd27d144a74c219e8e6a8f5c9e19aa7c0', 'show'),
(13, 'AutoDesk Building Design Suite Standard', 'Product Suite', '', 'large-AutoDeskBuildingDesignSuiteStandard.jpg', 'small-AutoDeskBuildingDesignSuiteStandard.jpg', '2013-04-11', '4ff2e775a4ca0ef65d69dbe547ab8bba', 'show'),
(14, 'AutoDesk Building Design Suite Ultimate', 'Product Suite', '', 'large-AutoDeskBuildingDesignSuiteUltimate.jpg', 'small-AutoDeskBuildingDesignSuiteUltimate.jpg', '2013-04-11', '7a849a5db51caba851794c7fc050c277', 'show'),
(15, 'AutoDesk DWG Trueview', 'Product', '', 'large-AutoDeskDWGTruereview.jpg', 'small-AutoDeskDWGTruereview.jpg', '2013-04-11', '22b0771e687c1e5141990d06150c711a', 'show'),
(16, 'AutoDesk Inventor', 'Product', '', 'large-AutoDeskInventor.jpg', 'large-AutoDeskInventor.jpg', '2013-04-11', '1f0fe158b6c19bd27f3786576a3ae4ca', 'show'),
(17, 'AutoDesk Inventor OEM', 'Product', '', 'large-AutoDeskInventorOEM.jpg', 'small-AutoDeskInventorOEM.jpg', '2013-04-11', 'f616764796d06fe34e65700a4875c132', 'show'),
(18, 'AutoDesk Inventor Professional', 'Product', '', 'large-AutoDeskInventorProfessional.jpg', 'small-AutoDeskInventorProfessional.jpg', '2013-04-11', '287c388e31f5e8ca90129ae44d8cdb34', 'show'),
(19, 'AutoDesk Recap', 'Product', '', 'large-AutoDeskRecap.jpg', 'small-AutoDeskRecap.jpg', '2013-04-11', '9e606c42fcdbea45af6e6140e1242709', 'show'),
(20, 'AutoDesk Revit', 'Product', '', 'large-AutoDeskRevit.jpg', 'small-AutoDeskRevit.jpg', '2013-04-11', '7e15738b85f7149fa41a3b30ed6f0bcd', 'show'),
(21, 'AutoDesk Revit Architecture', 'Product', '', 'large-AutoDeskRevitArchitecture.jpg', 'small-AutoDeskRevitArchitecture.jpg', '2013-04-11', 'a6aadaf89f224b63107ec56080080e6e', 'show'),
(22, 'AutoDesk Revit LT Suite', 'Product Suite', '', 'large-AutoDeskRevitLTSuite.jpg', 'small-AutoDeskRevitLTSuite.jpg', '2013-04-11', '7629e13698b6b2f17f9e6fc2d44148c7', 'show'),
(23, 'AutoDesk Revit MEP', 'Product', '', 'large-AutoDeskRevitMEP.jpg', 'small-AutoDeskRevitMEP.jpg', '2013-04-11', 'd881f5c528d8d9c4f729b1ccbbcb4b45', 'show'),
(24, 'AutoDesk Revit Structure', 'Product', '', 'large-AutoDeskRevitStructure.jpg', 'small-AutoDeskRevitStructure.jpg', '2013-04-11', '0782aa244c7a4758ca2845af80e3da27', 'show'),
(25, 'AutoDesk Showcase', 'Product', '', 'large-AutoDeskShowcase.jpg', 'small-AutoDeskShowcase.jpg', '2013-04-11', '877dd2eff19a9572bdea4b057eaf299e', 'show'),
(26, 'AutoDesk Vault Professional', 'Product', '', 'large-AutoDeskVaultProfessional.jpg', 'small-AutoDeskVaultProfessional.jpg', '2013-04-11', '56bb5d7e8b370eaf8a60f305d251ac5d', 'show');

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

--
-- 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');

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

--
-- Table structure for table `thardware`
--

CREATE TABLE `thardware` (
  `id` int(11) NOT NULL,
  `ProductName` varchar(50) NOT NULL,
  `ProductType` varchar(25) NOT NULL,
  `ShortDescription` varchar(750) NOT NULL,
  `Features` varchar(3000) NOT NULL,
  `Image` varchar(100) NOT NULL,
  `listing_date` date NOT NULL,
  `verification_code` varchar(100) NOT NULL,
  `display_status` varchar(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `thardware`
--

INSERT INTO `thardware` (`id`, `ProductName`, `ProductType`, `ShortDescription`, `Features`, `Image`, `listing_date`, `verification_code`, `display_status`) VALUES
(1, 'Dell Precision T1600 Tower Workstation', 'Tower', 'Great For: Specialists who need workstation performance for the most demanding professional-grade applications in a desktop-replacement mobile platform', '', 'dellPrecisionT1600TowerWorkstation.png', '2013-04-08', '9557e1c6fd355eab55761ff5aa54b1db', 'show'),
(2, 'Dell Precision M6600 Mobile Workstation', 'Laptop', 'Great For: Take the leap from business desktop to performance workstation with Dell Precision&#153; T1600. This cost-effective, entry-level workstation combines professional-grade processors and graphics options with ISV certification and dependability in a compact, toolless chassis.', '', 'dellPrecisionM6600MobileWorkstation.png', '2013-04-09', '7cb9e37b09ba2c7f8387643e03cc5180', 'show'),
(3, 'Canon image PROGRAF iPF825', 'Printer', 'Canon imagePROGRAF iPF825\nDesigned for the CAD, GIS and production print market\nFor the most demanding CAD & GIS work turn to the iPF825. This 44" large format printer delivers exceptional quality, versatility and breathtaking speeds.\nDual Roll for maximum productivity\n"Hot Swap" ink tanks - change whilst printing\nBlistering speeds\nEconomy printing\n5 colour reactive inks\nSharp, thin lines for precise detail\nBuilt-in 160Gb HDD\nEnhanced HP-GL/2 support\nHP-RTL and HDI Driver\nManage cost and track ROI with accounting software', '', 'canonImagePROGRAFiPF825.png', '2013-04-09', '14505d4ed0ee0789b5bbdeb8e5460357', 'show'),
(4, 'HP Pavilion 23xi 23-inch Diagonal IPS LED Backlit ', 'Monitor', 'Share photos, videos, and games with everyone in the room and experience the same great views from almost any angle on the all new HP Pavilion 23xi 58.4 cm (23") IPS LED Backlit Monitor. Incredible performance, vivid colors, and smart HP My Display software sweeten the deal.', 'Features\nLess distortion. Less blurring. Happy spectators\nIn-plane Switching (IPS), the color-rich technology you know and love in tablets, mobile devices, and televisions, is now available in a micro-thin display designed for the home. That means image and color consistency from almost anywhere in the room.\nBeauty and brains\nModernize your home desktop with a contemporary, bezel-less design that delivers maximum views of all your favorite images and on-screen content. Save space in style, too. The unique, micro-thin profile fits virtually anywhere without taking up valuable space. Do more with a dual-monitor setup enabled by the smart, plug-and-play design. Stay connected to current and evolving devices with built-in VGA, DVI, and HDMI inputs (with HDCP).\nJaw-dropping details\nBring your memories to life with eye-popping details. HP Enhance+ delivers super-crisp images and advanced noise reduction. Enjoy a crisp, detailed view with Full HD[k1] 1920 x 1080 resolution and 10,000,000:1 dynamic contrast ratio.[k2] Give your photos, videos, and online games[k3] more depth and see the difference with deeper blacks and whiter whites.\nSoftware that simplifies\nControl power-saving modes and customize screen settings with integrated HP My Display software, which also lets you partition your screen so you can work with multiple open application windows at the same time.\nHP on your side\nHelp reduce your power consumption and cut back on energy costs with an intelligent, energy-efficient design built with the environment in mind. Mercury-free LED backlighting, a BFR/PVC-free design[k4], arsenic-free display[k5] glass, and recyclable packaging are just a few of the responsible details built right into your display.', 'HPPavilion23xi23-inchDiagonalIPSLEDBacklitMonitor.png', '2013-04-09', '323fa0dca1450b1a8f5dca9c13d7bed2', 'show'),
(5, 'Dell Precision T3500 workstation', 'Tower', 'Great For:\r\nAdvanced analysis, engineering and design environments; certified reliable performance on a range of workstation class applications', '', 'dellPrecisionT3500Workstation.png', '2013-04-09', '737d295901ce6f09bda85217543197fe', 'show'),
(6, 'Dell Precision T5500 workstation', 'Tower', 'Great For:\r\nSpace-constrained multi-threaded/multitasking workstation environments, including financial analysis, professional engineering, digital video and content design', '', 'dellPrecisionT5500Workstation.png', '2013-04-09', '0604e98bedb943a4b4232537c7ea2090', 'show'),
(7, 'Dell Precision T7500 workstation', 'Tower', 'Great For:\r\nAdvanced engineering; 3D industrial design; digital content creation; demanding technical and scientific computing; complex multi-threaded/multitasking application environments', '', 'dellPrecisionT7500Workstation.png', '2013-04-09', 'b950029d6a2f274cbec143a9ea4e8b9c', ''),
(8, 'Dell Precision M4600 Mobile Workstation', 'Laptop', 'Great For:\nProfessionals who need workstation power on the go', '', 'dellPrecisionM4600MobileWorkstation.png', '2013-04-09', '8b83a2c38a8f4019e9423c6ecac85337', 'show'),
(9, 'Canon image PROGRAF iPF510', 'Printer', 'Canon imagePROGRAF iPF510\nDesigned for the CAD, GIS, poster, and in-house print market\nThe imagePROGRAF iPF510 uses a 5-colour pigment/dye reactive ink system that delivers exceptional quality A2 (17") prints with vivid colours and precise line rendering at speed.\nSharper, thinner lines and high black density\nEconomy mode\nSuperb graphics, vivid colours and solid image consistency\nBorderless printing\nFast print speeds\nHPGL/2 and HP/RTL compatible\nPosterArtist Lite poster creation software\nPrint plug-in for MS Office', 'Exceptional Print Quality\nProduce head-turning output with 2,400 x 1,200 dpi resolution. The iPF510 incorporates a 5-colour pigment/dye reactive ink system delivering sharper, thinner lines and vivid colour output. The reactive ink system enhances the quality of prints by ensuring that there is less bleeding and solid image consistency, therefore delivering output that retains more accuracy and sharpness – however detailed.\nHighly Productive\nThe iPF510 offers high speed printing producing A2 prints in just 21 seconds (in Fast mode). Canon’s borderless printing technology keeps you more productive as there is no need for offline trimming – saving you time and money. Although very compact in design the iPF510 also incorporates 4 media paths – a roll, cassette and two manual feeds.\nEconomical Printing\nThe iPF510 can help you reduce your costs, with high speed, economical printing using the Economy print mode which reduces ink consumption.\nEasy To Work With\nA host of facilities ensure that the iPF510 is easy to work with. A large, bright and easy to use LCD operation panel gives easy access to sophisticated functions. The printer driver can be tailored to suit your level of expertise and control of the print is from the front of the printer, with simple roll paper and ink tank loading.\nIdeal for specialist CAD applications\nDesigned to provide the quality line rendering and productivity needed for specialist CAD usage, the iPF510 offers full support for specialist CAD file formats HP-GL/2, HP RTL file formats as well as providing an HDI driver for Windows.\nCreate Professional Posters and More\nDesign posters like a pro without any prior experience thanks to Canon’s PosterArtist Lite software, which is included with the iPF510. In just four simple steps, you can create professional looking posters, banners and signs using a variety of templates, hi-resolution royalty-free images and clipart. A Print plug-in is also included for MS Office (Word, Excel and Powerpoint) – making it easy for you to print from your favourite applications. Digital Photo Front Access software allows you to import digital photos and edit them before including in your poster designs.\n', 'canonImagePROGRAFiPF510.png', '2013-04-09', '497ae22c6564699e2d41a34710cdb3a9', 'show'),
(10, 'Canon image PROGRAF iPF605', 'Printer', 'Canon imagePROGRAF iPF605\nDesigned for the CAD, GIS, poster, and in-house print market\nThe iPF605 is a 5 colour dye/pigment ink 24" large format printer, ideal for CAD & GIS applications thanks to its fine line reproduction, vivid colours and detailed images.\nSuperb graphics with vivid colours\n5 colour reactive (dye/pigment) ink\nSharp, thin lines for CAD plan production\nBlistering speeds\nEconomy printing\nHPGL/2, HP RTL & includes HDI Driver\nLarge LCD with graphics', 'For the finest lines and high quality detailed images\r\n\r\nThe image PROGRAF iPF605 is a 5 colour dye/pigment ink 24” large format printer, ideal for printing fine lines, re-creating vivid colours and producing high quality detailed images. With a 2,400 x 1,200 dpi optimal resolution, solid image consistency, high quality text reproduction and, economy printing – makes this printer perfect for the CAD/GIS market.\r\n\r\nOutstanding images\r\n\r\nThe iPF605 features an ink technology developed specifically for printing detailed business documents and engineering applications with fine lines, small text, detailed graphs and tables. This unique formulation improves the ink’s adhesion to the media and minimises colour “bleeding”. Image reproduction is an outstanding 2,400 x 1,200 dpi.\r\n\r\nExceptional speeds at low cost\r\n\r\nExceptional print performance (33 seconds for A1 prints in draft mode) make the iPF605 ideal for producing whatever you need at speed - without needing to send the work to a local print specialist.\r\nCombined with an economy mode you can reduce the ink usage and thereby cut printing costs.\r\n\r\nIdeal for specialist CAD applications\r\n\r\nDesigned for specialist CAD applications the iPF605 is equipped with everything you need for exceptional results. Specialist CAD file formats HP-GL/2 and HP RTL are supported and an HDI driver for Windows is also incorporated. A 256MB memory ensures even the most complex of files can be easily processed and a high performance, high durability cutter is included, bringing a professional finish to all your work.\r\n\r\nCapable and easy to live with\r\n\r\nAn LCD control panel features graphic animations to ensure it’s quick and easy to get to grips with the device – even if you have never handled a large format printer before. Powerful but easy to use software aids the process – so even more complex tasks are easily achieved. Plus, the compact and incredibly low noise output, make the iPF605 the easy to integrate into any environment.', 'canonImagePROGRAFiPF605.png', '2013-04-09', '2314678967beae1fe1636e226c274b6b', 'show'),
(11, 'Canon image PROGRAF iPF650', 'Printer', 'Canon imagePROGRAF iPF650\nDesigned for the CAD, GIS, poster, and in-house print market\nBuilt for high quality production in CAD/GIS environments, the imagePROGRAF iPF650 is a 24"/A1 large format printer that delivers outstanding quality and an impressive return on investment.\nSpace saving, compact design\nManage costs & track ROI with accounting software\nUser friendly front access\nHigh productivity incl. "Hot swap" ink tanks\nExceptional quality & accuracy\nHP GL/2 & HP-RTL compatible', 'Designed for practicality and usability\r\n\r\nThe iPF650 has been designed to fit comfortably into any CAD/GIS environment. A compact, slim-line design and front-access paper system means you can install the printer wherever you like – even flush against a wall. All operation including ink tank changing is carried out from the front, so you never need to disrupt your office no matter where you decide to place the printer.\r\nA large LCD control panel featuring graphic animations ensures it’s quick and easy to get to grips with. Prints are automatically stacked and can be collected from a high capacity basket to prevent damage and there’s even a handy print timer to keep you abreast of how long a job will take to complete.\r\n\r\nHigh productivity\r\n\r\nExpect exceptional productivity with draft A1 prints available in just 24 seconds. Canon’s L-COA image processing technology and Gigabit Ethernet compatibility ensure stunning high-speed reproductions on everything from architectural plans to geographic information.\r\n“Hot-swap” ink tanks allow ink cartridges to be replaced during printing for maximum productivity.\r\n\r\nEconomical and efficient\r\n\r\nA built in accounting function allows accurate tracking of the cost per print and the overall cost of your printer and enables you to view the data through the printer driver, or export it to a CSV file for use in your own files or systems. An Economy mode can be selected which uses less ink - ideal when printing draft documents. Furthermore, Canon’s eMaintenance software automatically detects and manages mechanical problems and low ink levels, linking directly to a Canon service centre for maximum uptime.\r\n\r\nExceptional quality & accuracy\r\n\r\nCanon’s 5-colour dye-and-pigment reactive ink system produces vivid colours and the sharpest, thinnest lines and the new magenta ink makes the red gamut even better. With a range accuracy of +/- 0.1% as well as a minimum line width of 0.02mm, precision is guaranteed. Images are rendered at 2,400 x 1200 dpi for maximum impact, thanks to super-fine print heads using 15,360 nozzles.\r\n\r\nBuilt with demanding workflows\r\n\r\nThe iPF650 is compatible with HP-GL/2 and HP-RTL, including the ability to set palette and pen settings, for the most demanding CAD workflows. As well as an HDI driver for AutoCAD and for Microsoft Office users, there is a plug-in to print in Word, Excel and PowerPoint directly from the application.', 'canonImagePROGRAFiPF650.png', '2013-04-09', 'cd1299d31abb17a135d23e8a6f2cb3e4', 'show'),
(12, 'Canon image PROGRAF iPF655', 'Printer', 'Canon imagePROGRAF iPF655\nDesigned for the CAD, GIS, poster, and in-house print market\nEffortlessly productive and delivering exceptional results in all CAD/GIS environments, the iPF655 is a 24"/A1 large format printer that never fails to impress.\nSpace saving, compact design\nManage costs & track ROI with accounting software\nUser friendly front access\nHigh productivity incl. "Hot swap" ink tanks & Media Mismatch\nExceptional quality & accuracy\nHP GL/2 & HP-RTL compatible\n80Gb HDD for easy print management', '', 'canonImagePROGRAFiPF655.png', '2013-04-09', '52cda1a671361eafa2b11b07d3b19a37', 'show'),
(13, 'Canon image PROGRAF iPF750', 'Printer', 'Canon imagePROGRAF iPF750\nDesigned for the CAD, GIS, poster, and in-house print market\nThe imagePROGRAF iPF750 is a 36"/A0 printer, delivering class leading productivity, exceptional quality, accuracy and an advanced set of features to ensure an excellent return on investment.\nSpace saving, compact design\nManage costs & track ROI with accounting software\nUser friendly front access\nHigh productivity incl. "Hot swap" ink tanks\nExceptional quality & accuracy\nHP GL/2 & HP-RTL compatible', '', 'canonImagePROGRAFiPF750.png', '2013-04-09', 'dfac1fa1491385750a21c369154015fc', 'show'),
(14, 'Canon image PROGRAF iPF760', 'Printer', 'Canon imagePROGRAF iPF760\nDesigned for the CAD, GIS, poster, and in-house print market\nThe imagePROGRAF iPF760 is a 36"/A0 printer, delivering class leading productivity, exceptional quality, accuracy and an advanced set of features to ensure an excellent return on investment\nSpace saving design\nFlat Stacker/Basket\nManage costs and track ROI with accounting software\nUser friendly front access\nHigh productivity "Hot swap" ink tanks\nExceptional Quality & Accuracy\nHP GL/2 & HP-RTL compatible\nPrint Plug-in for Microsoft Office', '', 'canonImagePROGRAFiPF760.png', '2013-04-09', '68412dfac8efcf3ec0a0b76da40cf561', 'show'),
(15, 'Canon image PROGRAF iPF765', 'Printer', 'Canon imagePROGRAF iPF765\nDesigned for exceptional results in all CAD/GIS environments\nDesigned for exceptional results in all CAD/GIS environments, the imagePROGRAF iPF765 is a 36"/A0 printer that delivers quality results and a fast return on investment.\nSpace saving design\nFlat Stacker/Basket\nManage costs and track ROI with accounting software\nUser friendly front access\nHigh productivity - "Hot swap" ink tanks\nExceptional Quality & Accuracy\nHP GL/2 & HP-RTL compatible\n250Gb HDD for easy print management', '', 'canonImagePROGRAFiPF765.png', '2013-04-09', 'a3bd735c714a02f00e0008a7dd299617', 'show'),
(16, 'Canon image PROGRAF iPF815', 'Printer', 'Canon imagePROGRAF iPF815\nDesigned for the CAD, GIS and production print market\nFor the most demanding CAD & GIS work turn to the iPF815. This 44" large format printer delivers exceptional quality, versatility and breathtaking speeds.\n"Hot Swap" ink tanks - change whilst printing\nBlistering speeds\nEconomy printing\n5 colour reactive inks\nSharp, thin lines for precise detail\nBuilt-in 160Gb HDD\nEnhanced HP-GL/2 support\nHP-RTL and HDI Driver\nManage costs and track ROI with accounting software', '', 'canonImagePROGRAFiPF815.png', '2013-04-09', '76e40c03b6ee6bb54b620408cdf5f49a', 'show'),
(17, 'Canon image PROGRAF MFP M40 Solution', 'Printer', 'Canon imagePROGRAF MFP M40 Solution\nDesigned for practicality and usability\nThe imagePROGRAF MFP M40 Solution is a total workflow system for anyone who needs to scan, copy, archive and distribute large format documents quickly and easily with remarkable accuracy and detail.\nComplete Scan-to-Copy / File / E-mail / Cloud Connectivity and Print Solution\nSingleSensor (CIS) for high quality and accurate scanning\nBi-directional LED light system for optimum object illumination and instant-on response\nUp to 13 inches per second scanning\n1200dpi optical resolution\n22" LCD Touch screen interface\nNext generation SmartWorks MFP Software for intuitive and flexible operation\nScan to PDF, JPEG and TIFF\n2,400 x 1,200 dpi fast printing with Flat ', '', 'canonImagePROGRAFMFPM40Solution.png', '2013-04-09', 'cbd814e0150fa61d39ab87e66d772047', 'show'),
(18, 'HP ENVY 27 68.58 cm (27") Diagonal IPS LED Backlit', 'Monitor', 'This is the display you''ve been waiting for. IPS technology, Beats Audio&#153; and a massive 68.58 cm (27") diagonal screen. Your content will never be the same. We don''t stop there. You also get a sleek, solid aluminum design that demands to be front and center and software that thinks like you do.', 'Features\nGreat color and views from almost any seat in the room\nShare videos, photos, games and more through the 178° horizontal and vertical viewing angles of In-plane Switching (IPS), the color-rich technology you know and love in tablets, mobile devices, and televisions, now available in your home display.\nHeadphones optional\nGet a total, immersive audiovisual experience with the world’s first Beats Audio™-integrated display. Enjoy your sound the way it was meant to be heard. Built-in speakers are angled upward to deliver great mid-range and high frequencies with equally rich bass. If you want to add headphones, the jack is within easy reach on the right side of the display.\nDon’t put this baby in a corner\nGet maximum, unobstructed views of your images and content from the edge-to-edge borderless screen. Reclaim your space with an offset base design that takes up less depth and gives you more room to maneuver. Customize settings with backlit capacitive touch controls that don’t just look pretty, they also provide easy access to display properties. Connect to a range of devices with VGA, DisplayPort and HDMI inputs.\nNever miss a thing\nBring your digital content to sparkling life and take movie night to the next level with Full-HD resolution.[k1] Enjoy stunning video and graphics presentation from the impressive 10M:1 dynamic contrast ratio.[k2]\nGet comfortable\nAutomatically reduce the brightness of the display with technology that detects the brightness of the space around you and adjusts to a balance that’s easier on the eyes.\nMulti-task to your heart’s content\nControl power-saving modes, customize screen settings, partition your screen so multiple application windows can be open at the same time and then save preferred settings for an easy startup-all with integrated HP My Display software.', 'HPENVY27DiagonalIPSLEDBacklitMonitor.png', '2013-04-09', '845fc6bb7ceddcef81cf60084bddb98d', 'show'),
(19, 'HP Pavilion 22xi 21.5-inch Diagonal IPS LED Backli', 'Monitor', 'Share photos, videos, and games with everyone in the room and experience the same great views from almost any angle on the all new HP Pavilion 22xi 54.6 cm (21.5") IPS LED Backlit Monitor. Incredible performance, vivid colors, and smart HP My Display software sweeten the deal.', 'Features\nLess distortion. Less blurring. Happy spectators\nIn-plane Switching (IPS), the color-rich technology you know and love in tablets, mobile devices, and televisions, is now available in a micro-thin display designed for the home. That means image and color consistency from almost anywhere in the room.\nBeauty and brains\nModernize your home desktop with a contemporary, bezel-less design that delivers maximum views of all your favorite images and on-screen content. Save space in style, too. The unique, micro-thin profile fits virtually anywhere without taking up valuable space. Do more with a dual-monitor setup enabled by the smart, plug-and-play design. Stay connected to current and evolving devices with built-in VGA, DVI, and HDMI inputs (with HDCP).\nJaw-dropping details\nBring your memories to life with eye-popping details. HP Enhance+ delivers super-crisp images and advanced noise reduction. Enjoy a crisp, detailed view with Full HD[k1] 1920 x 1080 resolution and 10,000,000:1 dynamic contrast ratio.[k2] Give your photos, videos, and online games[k3] more depth and see the difference with deeper blacks and whiter whites.\nSoftware that simplifies\nControl power-saving modes and customize screen settings with integrated HP My Display software, which also lets you partition your screen so you can work with multiple open application windows at the same time.\nHP on your side\nHelp reduce your power consumption and cut back on energy costs with an intelligent, energy-efficient design built with the environment in mind. Mercury-free LED backlighting, a BFR/PVC-free design[k4], arsenic-free display[k5] glass, and recyclable packaging are just a few of the responsible details built right into your display.', 'HPPavilion22xi21inchDiagonalIPSLEDBacklitMonitor.png', '2013-04-09', '030e17e856ccdc41b71bbff1d0fcdf2c', 'show'),
(20, 'HP Pavilion 23xi 58.4 cm (23") Diagonal IPS LED Ba', 'Monitor', 'Share photos, videos, and games with everyone in the room and experience the same great views from almost any angle on the all new HP Pavilion 23xi 58.4 cm (23") IPS LED Backlit Monitor. Incredible performance, vivid colors, and smart HP My Display software sweeten the deal.', 'Features\nLess distortion. Less blurring. Happy spectators\nIn-plane Switching (IPS), the color-rich technology you know and love in tablets, mobile devices, and televisions, is now available in a micro-thin display designed for the home. That means image and color consistency from almost anywhere in the room.\nBeauty and brains\nModernize your home desktop with a contemporary, bezel-less design that delivers maximum views of all your favorite images and on-screen content. Save space in style, too. The unique, micro-thin profile fits virtually anywhere without taking up valuable space. Do more with a dual-monitor setup enabled by the smart, plug-and-play design. Stay connected to current and evolving devices with built-in VGA, DVI, and HDMI inputs (with HDCP).\nJaw-dropping details\nBring your memories to life with eye-popping details. HP Enhance+ delivers super-crisp images and advanced noise reduction. Enjoy a crisp, detailed view with Full HD[k1] 1920 x 1080 resolution and 10,000,000:1 dynamic contrast ratio.[k2] Give your photos, videos, and online games[k3] more depth and see the difference with deeper blacks and whiter whites.\nSoftware that simplifies\nControl power-saving modes and customize screen settings with integrated HP My Display software, which also lets you partition your screen so you can work with multiple open application windows at the same time.\nHP on your side\nHelp reduce your power consumption and cut back on energy costs with an intelligent, energy-efficient design built with the environment in mind. Mercury-free LED backlighting, a BFR/PVC-free design[k4], arsenic-free display[k5] glass, and recyclable packaging are just a few of the responsible details built right into your display.', 'HPPavilion23xi58cmDiagonalIPSLEDBacklitMonitor.png', '2013-04-09', 'be299f864768a575b07a00f3a761bd95', 'show'),
(21, 'HP x2401 61 cm (24") Diagonal LED Backlit Monitor', 'Monitor', 'Simply striking anyway you look at it; the HP x2401 monitor delivers vivid color imagery from almost any angle with MVA panel technology, along with a sophisticated micro-thin design and smart connectivity. It''s perfect for sharing photos and videos with everyone gathered around.', 'Features\r\nSatisfy your sense of style\r\nThere’s thin, and then there’s micro-thin. Revamp your desktop space with the all-new HP x2401 LED-Backlit Monitor. Featuring an 11-mm profile, this ultra-sleek monitor with a piano black bezel and brushed metal case looks spectacular in any setting.\r\nThe unique, adjustable easel stand design lets you free up even more limited space, while adding a touch of modern architecture that’s just as functional as it stunning.\r\nUnleash your viewing experience\r\nExpect image consistency from nearly any seat in the house, far left, far right or way in the back – perfect for screen sharing with everyone gathered around. MVA panel technology provides 178° horizontal and 178° vertical viewing angles.\r\nEnjoy the freedom to show off and spread out across a 61 cm (24") diagonal, Full-HD[k3] LED-backlit display that lets you multi-task in crisp, vibrant detail.\r\nSee the difference a 5,000:1 static contrast ratio[k1] can make--your photos and videos have more depth with deeper blacks and whiter whites. Even text documents and e-mails[k2] are easier to read.\r\nA 10,000,000:1 dynamic contrast ratio[k1] combines with quick on/off switching times to deliver. brilliant screen performance.\r\nForm meets function\r\nQuickly and easily connect the display to your notebook or desktop with integrated DisplayPort or HDMI connectivity (with HDCP support).\r\nSkip the cable clutter and keep it clean with convenient L-connectors that hide power and video cords in the back where they belong.\r\nFold flat, tilt back or remove. A flexible easel stand lets you conveniently adjust your display’s position as needed. The included VESA-compatible 100-mm hole pattern plate allows you to mount the display on a wall or arm (sold separately).\r\nA brighter future\r\nMercury-free LED backlighting saves energy and helps decrease your environmental footprint.\r\nLess toxins and more reusable parts go a long way with BFR/PVC[k4] components, arsenic-free[k5] display glass and recyclable plast', 'HP-x240161cmDiagonalLEDBacklitMonitor.png', '2013-04-09', '50c3eed10d52e5241ff9ca6e38eefea4', 'show'),
(22, 'HP Pavilion 22xi 54.6 cm (21.5") Diagonal IPS LED ', 'Monitor', 'Share photos, videos, and games with everyone in the room and experience the same great views from almost any angle on the all new HP Pavilion 22xi 54.6 cm (21.5") IPS LED Backlit Monitor. Incredible performance, vivid colors, and smart HP My Display software sweeten the deal.', 'Features\r\nLess distortion. Less blurring. Happy spectators\r\nIn-plane Switching (IPS), the color-rich technology you know and love in tablets, mobile devices, and televisions, is now available in a micro-thin display designed for the home. That means image and color consistency from almost anywhere in the room.\r\nBeauty and brains\r\nModernize your home desktop with a contemporary, bezel-less design that delivers maximum views of all your favorite images and on-screen content. Save space in style, too. The unique, micro-thin profile fits virtually anywhere without taking up valuable space. Do more with a dual-monitor setup enabled by the smart, plug-and-play design. Stay connected to current and evolving devices with built-in VGA, DVI, and HDMI inputs (with HDCP).\r\nJaw-dropping details\r\nBring your memories to life with eye-popping details. HP Enhance+ delivers super-crisp images and advanced noise reduction. Enjoy a crisp, detailed view with Full HD[k1] 1920 x 1080 resolution and 10,000,000:1 dynamic contrast ratio.[k2] Give your photos, videos, and online games[k3] more depth and see the difference with deeper blacks and whiter whites.\r\nSoftware that simplifies\r\nControl power-saving modes and customize screen settings with integrated HP My Display software, which also lets you partition your screen so you can work with multiple open application windows at the same time.\r\nHP on your side\r\nHelp reduce your power consumption and cut back on energy costs with an intelligent, energy-efficient design built with the environment in mind. Mercury-free LED backlighting, a BFR/PVC-free design[k4], arsenic-free display[k5] glass, and recyclable packaging are just a few of the responsible details built right into your display.', 'HPPavilion22x54cmDiagonalIPSLEDBacklitMonitor.png', '2013-04-09', '4f872df81699a4a2b099ec6b27ae1a18', 'show');

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

--
-- Table structure for table `tsoftware`
--

CREATE TABLE `tsoftware` (
  `id` int(11) NOT NULL,
  `ProductName` varchar(50) NOT NULL,
  `ProductVersion` varchar(4) NOT NULL,
  `ProductType` varchar(25) NOT NULL,
  `ProductPDF` varchar(50) NOT NULL,
  `Products_Included_1` varchar(50) NOT NULL,
  `Products_Included_2` varchar(50) NOT NULL,
  `Products_Included_3` varchar(50) NOT NULL,
  `Products_Included_4` varchar(50) NOT NULL,
  `Products_Included_5` varchar(50) NOT NULL,
  `Products_Included_6` varchar(50) NOT NULL,
  `Products_Included_7` varchar(50) NOT NULL,
  `Products_Included_8` varchar(50) NOT NULL,
  `Products_Included_9` varchar(50) NOT NULL,
  `Products_Included_10` varchar(50) NOT NULL,
  `Products_Included_11` varchar(50) NOT NULL,
  `Products_Included_12` varchar(50) NOT NULL,
  `Products_Included_13` varchar(50) NOT NULL,
  `Products_Included_14` varchar(50) NOT NULL,
  `Products_Included_15` varchar(50) NOT NULL,
  `ShortDescription` varchar(750) NOT NULL,
  `Features` varchar(3000) NOT NULL,
  `Image` varchar(250) NOT NULL,
  `LargeImage` varchar(50) NOT NULL,
  `SmallImage` varchar(50) NOT NULL,
  `listing_date` date NOT NULL,
  `verification_code` varchar(100) NOT NULL,
  `last_update` date NOT NULL,
  `display_status` varchar(4) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tsoftware`
--

INSERT INTO `tsoftware` (`id`, `ProductName`, `ProductVersion`, `ProductType`, `ProductPDF`, `Products_Included_1`, `Products_Included_2`, `Products_Included_3`, `Products_Included_4`, `Products_Included_5`, `Products_Included_6`, `Products_Included_7`, `Products_Included_8`, `Products_Included_9`, `Products_Included_10`, `Products_Included_11`, `Products_Included_12`, `Products_Included_13`, `Products_Included_14`, `Products_Included_15`, `ShortDescription`, `Features`, `Image`, `LargeImage`, `SmallImage`, `listing_date`, `verification_code`, `last_update`, `display_status`) VALUES
(1, 'AutoCAD 2013', '2013', 'Product', 'AutoCAD2013.pdf', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Design and shape the world around you with the powerful, flexible features found in AutoCAD software, one of the world''s leading design applications', 'With powerful tools for design aggregation, AutoCAD&reg; 2013 software connects and streamlines your design and documentation workflows. New tools to connect with Autodesk&reg; 360 cloud-enabled services help you access and collaborate on designs from almost anywhere. And with a single destination to find and install hundreds of different apps, it''s easier than ever to customize your AutoCAD experience.<br>\n<br>\n<strong>Explore Your Design Ideas</strong><br>\nCreate the previously unimaginable.AutoCAD 2013 software gives you the flexibility you need to explore design ideas in both 2D and 3D. A powerful set of intuitive tools helps you visualize and shape \nyour ideas, bringing innovative concepts to life.<br>\n<br>\n<br>\n<strong>Accelerate Documentation</strong><br>\nSpeed projects from concept to completion with the powerful documentation tools in AutoCAD 2013. Minimize repetitive tasks and accelerate your workflow. Import 3D models directly into AutoCAD 2013 and instantly create intelligent 2D views. No matter your project''s size or scope, AutoCAD software can help you meet the challenge. <br>\n<br>\n<br>\n<strong>Connect Seamlessly</strong><br>\nConnect your entire design workflow by aggregating models from a variety of applications into your AutoCAD workplace. Synchronize files and collaborate on designs with built-in connections to Autodesk&reg; 360 cloud-enabled services. And native support for DWG&trade;, one of the world''s most widely used design data formats, helps keep everyone on the same page.<br>\n<br>\n<br>\n<strong>Customize in Ways You Never Thought Possible</strong><br>\nYour job is unique. Your software should be as well. Customizing AutoCAD to meet your specific needs can be easier than you think. Whether you simply want to arrange tools to match how you work or \ntailor the software for your industry, AutoCAD 2013 software is flexible enough to support your workflow. ', 'autoCAD2013.png', 'large-AutoDeskAutoCad.jpg', '', '2013-04-09', '', '0000-00-00', 'show'),
(2, 'AutoCAD Civil 3D', '', 'Product', 'productsDetailsAutoCADCivil3D.pdf', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'A Powerful Building Information Modeling Solution for Civil Engineering. Use an integrated process built on a coordinated, consistent, digital model for design, analysis, visualization, documentation and construction. ', 'One Model. One Change. Multiple Updates. All Automatic.\r\n  Building information modeling (BIM) is an integrated process for exploring a project''s key physical and functional characteristics digitally-before it''s built. AutoCAD Civil 3D software is Autodesk''s building information modeling solution for civil engineering. The software creates coordinated, data-rich models that enable you to conduct analysis from the earliest stages of design; better visualize and simulate real-world appearance, performance, and cost; and document designs more accurately.<br />\r\n  <br />\r\n  AutoCAD Civil 3D produces a single model, with intelligent and dynamic data, enabling you to more quickly make a design change at any stage of the process. Make better-informed decisions and choose design alternatives based on analytical and performance results. More quickly and efficiently produce visualizations that remain in sync with design changes as they are made. The model automatically reflects any changes to drafting and annotation throughout the project.\r\n  <br />\r\n  <br />\r\n  Deliver More Innovative Project Solutions<br />\r\n  AutoCAD Civil 3D offers a better way of designing, analyzing, and documenting civil engineering projects.<br />\r\n  <br />\r\n  AutoCAD&reg; Civil 3D&reg; software enables you to deliver  higher-quality transportation, land development,  and environmental engineering projects faster.  The software''s purpose-built tools support building  information modeling (BIM) processes and help  reduce the time it takes to design, analyze, and  implement changes. The result is that you can  evaluate more what-if scenarios and optimize  project performance.  Civil 3D software''s tools for surveying and design help  streamline project workflows by automating timeconsuming  tasks. <br />\r\n  <br />\r\n  <strong>Surveying</strong><br />\r\n  Survey functionality is fully integrated in Civil 3D, so you have a more consistent environment for all tasks, including direct import of raw survey data, leastsquares adjustment, editing of survey observations, and automated creation of survey figures and surfaces. You can create and edit survey figure vertices interactively, and identify and edit crossing breaklines to avoid potential issues, resulting in points, survey figures, and surfaces that can be used throughout the project.<br />\r\n  <br />\r\n  <strong>Corridor Modeling</strong><br />\r\n  Corridor modeling combines horizontal and vertical geometry with customizable cross sectional components to create a parametrically defined, dynamic 3D model of roads and other transportation systems. Use the included subassemblies-ranging from travel lanes, sidewalks, and ditches to complex lane components-or create your own based on a design standard. The model can be easily modified via visual interaction or by changing input parameters \r\n  that define the roadway typical section. Unique characteristics of each subassembly allow the 3D model to target known features. ', 'autoCADCivil3D2013.png', 'large-AutoDeskAutoCadCivil3D.jpg', 'small-AutoDeskAutoCadCivil3D.jpg', '2013-04-09', '', '2013-04-14', 'show'),
(4, 'AutoCAD Electrical 2013', '2013', 'Product', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'To succeed in todays global marketplace, electrical controls designers can no longer afford to rely on generic software applications to get the job done. AutoCAD Electrical software delivers the tools to help design control systems quickly and accurately with significant cost savings.', '', 'autoCADElectrical2013.png', 'large-AutoDeskAutoCadElectrical.jpg', '', '2013-04-09', '', '0000-00-00', 'show'),
(5, 'AutoCAD LT 2013', '2013', 'Product', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Capture and communicate your design concepts with AutoCAD LT 2013 drafting and detailing software. Create simple or complex drawings from standard shapes such as lines, arcs, and circles. Modify existing geometry with commands such as stretch, copy, rotate', '', 'autoCADLT2013.png', 'large-AutoDeskAutoCadLT.jpg', 'small-AutoDeskAutoCadLT.jpg', '2013-04-09', '', '0000-00-00', 'show'),
(6, 'AutoCAD Map 3D', '', 'Product', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'AutoCAD&reg; Map 3D software is a model-based infrastructure application that provides broad access to CAD and GIS data, helping GIS,\nplanning, and engineering professionals\naccess, evaluate, and share data to make\ninformed decisions.', '', 'autoCADMap3D.png', 'large-AutoDeskAutoCadMap3D.jpg', 'small-AutoDeskAutoCadMap3D.jpg', '2013-04-09', '', '0000-00-00', 'show'),
(9, 'AutoCAD Mechanical', '', 'Product', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'To compete and win in today''s design marketplace, engineers\r\nneed to create and revise mechanical drawings faster than\r\never before. AutoCAD&reg; Mechanical is AutoCAD&reg; software for\r\nmanufacturing, offering significant productivity gains over\r\nstandard AutoCAD&reg; by simplifying complex mechanical design\r\nwork.', '', 'autoCADMechanical.png', 'large-AutoDeskAutoCadMechanical.jpg', 'small-AutoDeskAutoCadMechanical.jpg', '2013-04-08', '6969d2025e70ecc22436991cb0fb3c97', '0000-00-00', 'show'),
(10, 'AutoCAD Raster Design', '', 'Product', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'When our customers bring in their old drawings that might have been sitting in a drawer for 30 years, it''s safe to say that the quality of the drawings may be degraded from age.  Scans that result from damaged drawings aren''t of the highest quality; however the powerful suite of tools in Raster Design can message the data and make it accurately convey the design intent once again', '', 'autoCADRasterDesign2013.png', 'large-AutoDeskAutoCadMEP.jpg', '', '2013-04-08', '1a690bc0e705383a1657595c374bee8d', '0000-00-00', 'show'),
(11, 'AutoDesk Inventor LT', '', 'Product', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Autodesk Inventor LT allows you to participate in Digital Prototyping workflows. What does that mean? Using Autodesk Inventor software, the foundation of the Autodesk solution for Digital Prototyping, customers and partners can integrate your 3D part designs into digital prototypes of complete assemblies. They can then validate the form, fit, and function of a product-before it is built. By turning to Digital Prototyping with Autodesk Inventor software, you''ll be able to do the same thing.', '', 'autoCADInventorLTSuite2013.png', 'large-AutoDeskAutoCadLT.jpg', '', '2013-04-08', 'de98218829b13923ab6025f882d3f0c8', '0000-00-00', 'show'),
(12, 'AutoDesk Inventor 2013', '2013', 'Product', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'The Autodesk Inventor 3D model is an accurate 3D digital prototype that enables users to validate the form, fit and function of a design, minimise the need for physical prototypes and reduce costly engineering changes that are discovered only after the design is sent to manufacturing.', '', 'autoDeskInventor2013.png', 'large-AutoDeskAutoCadLT.jpg', '', '2013-04-08', '8cffdbb73fde5e7ebb52f3c1e71bf876', '0000-00-00', 'show'),
(13, 'AutoDesk Navisworks', '', 'Product', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Autodesk&reg; Navisworks&reg; Manage software is a comprehensive review solution for analysis, simulation, and coordination of project information. Multidisciplinary design data can be combined into a single integrated project model for interference management and clash detection. Navisworks Manage helps design and construction professionals anticipate and avoid potential problems before construction', '', 'autoDeskNavisworks.png', 'large-AutoDeskNavisworks.jpg', '', '2013-04-08', '2351590b6b61310f3457dc2d702baf69', '0000-00-00', 'show'),
(14, 'AutoDesk Quantity Takeoff', '', 'Product', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Regardless of what phase you are in during a project - from design through preconstruction - Autodesk Quantity Takeoff helps enable cost estimators to more rapidly generate material quantity takeoffs and perform conceptual estimates. Whether you have an image file of a napkin sketch or a fully developed building information model (BIM) developed in Autodesk® Revit-based products, Autodesk Quantity Takeoff helps cost estimators to gain an in-depth understanding of project costs.', '', 'autoDeskQuantityTakeoff.png', 'large-AutoDeskDWGTruereview.jpg', '', '2013-04-09', 'd401656f887f3b9b8dc8b0495609b699', '0000-00-00', 'show'),
(15, 'AutoDesk Showcase 2013', '2013', 'Product', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Showcase is such a powerful visual communication tool. The quality of presentation material I can generate is excellent—not to mention the way I can easily go into the system and change colors, or set up animations, turntables, and flybys. I can spin the designs around, see the play of highlights across surfaces, and communicate exactly how designs will look from all angles.', '', 'autoDeskShowcase2013.png', 'large-AutoDeskShowcase.jpg', 'small-AutoDeskShowcase.jpg', '2013-04-09', '90c12cbb0541a48afd2458d09a31b738', '0000-00-00', 'show'),
(16, 'AutoDesk Sketchbook Designer 2013', '2013', 'Product', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Autodesk® SketchBook® Designer 2013 illustration software helps you to explore concepts quickly and easily, iterate in real time, and produce stunning artwork. With a unique hybrid paint and vector workflow, SketchBook Designer 2013 offers creative professionals tools to transform ideas quickly into compelling visual communications.', '', 'autoDeskSketchbookDesigner2013.png', 'large-AutoDeskSketchbookDesigner.jpg', '', '2013-04-09', '9ecd0c6d2afe2a87eaca0edbe61c96dc', '0000-00-00', 'show'),
(17, 'AutoDesk Vault', '', 'Product', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Vault Family of Products, Manage your entire design.\nStay in control\nImagine finding design data in seconds. Sharing digital prototyping information securely with team members across the world. Knowing who revised designs—and when.', '', 'autoDeskVault.png', 'large-AutoDeskVaultProfessional.jpg', 'small-AutoDeskVaultProfessional.jpg', '2013-04-09', '521b67ccbc1a60cdf55de912a651c667', '0000-00-00', 'show'),
(18, 'AutoCAD Design Suite', '2013', 'Product Suite', 'AutoCADDesignSuite.pdf', 'AutoCAD 2013', 'AutoCAD Raster Design', 'Autodesk Sketchbook Designer 2013', 'Autodesk Showcase 2013', 'Autodesk Mudbox 2013', 'Autodesk 3ds Max Design 2013', 'Autodesk Alias Design 2013', '', '', '', '', '', '', '', '', 'For the people who are shaping and creating the world around us, AutoCAD Design Suite 2013 delivers the power of AutoCAD 2013 software, plus tools to help you create, capture, connect, and showcase your designs with impact.', 'Create - Discover New Possibilities•Discover ideas with freehand drawing techniques, to create conceptual design sketches for AutoCAD® software.•Drive your projects to completion with comprehensive documentation tools.Capture - Bring Your World into AutoCAD•Capture design information from almost any source, and convert it into a DWG™ file.•Accelerate renovation and restoration projects by re-creating the as-built environment, with powerful point cloud tools.•Translate third-party 3D file formats into DWG with model import and aggregation tools.Connect - Plug into the Power of the Cloud•Supercharge your design and collaboration processes with online file exchange and rendering services that directly connects AutoCAD 2013 software to the Autodesk® 360 cloud platform.•Access and download apps to customize your AutoCAD experience.•Enable web and mobile collaboration by publishing directly from AutoCAD 2013.Showcase - Render Them Speechless•Accelerate the feedback loop and avoid costly errors by clearly communicating design intent.•Impress your customers with interactive presentations and Hollywood-quality renderings, with Autodesk 3ds Max Design.•Hold your designs in the palm of your hand by printing physical models directly from AutoCAD. ', 'autocadDesignSuite2013.png', 'large-AutoCadDesignSuiteUltimate2.jpg', 'small-AutoCadDesignSuiteUltimate2.jpg', '2013-04-10', '2302c7446844b7059089267982ec47f7', '0000-00-00', 'show'),
(19, 'AutoDesk Plant Design Suite', '2013', 'Product Suite', 'AutoDeskPlantDesignSuite.pdf', 'AutoCAD 2013', 'AutoCAD and ID 2013', 'Autodesk Showcase 2013', 'Autodesk Sketchbook Designer 2013', 'AutoCAD Plant 3D 2013', 'AutoCAD Structural Detailing 2013', 'Autodesk Revit Structure 2013', 'Autodesk Navisworks Simulate 2013', 'Autodesk Navisworks Manage 2013', 'Autodesk Inventor 2013', '', '', '', '', '', 'Autodesk®  Plant Design Suite provides comprehensive plant design, modeling, and review software in a convenient, cost-effective package that enables customers to design more efficiently, innovate ahead of the competition, and communicate with greater clarity. Use it to help keep projects on schedule and work within your budget. Building on the power and familiarity of AutoCAD®  software, the suite adds plant-specific content and features to help drive greater productivity and better project coordination.', '', 'autoDeskPlantDesignSuite.png', 'large-AutoDeskAutoCadPlant3D.jpg', '', '2013-04-10', 'adbe805673d38f356e22df1dd0be70f7', '2013-04-15', 'show'),
(20, 'AutoDesk Building Design Suite', '2013', 'Product Suite', 'AutoDeskBuildingDesignSuite.pdf', 'AutoCAD 2013', 'AutoCAD Architecture', 'AutoCAD MEP', 'AutoCAD Structural Detailing 2013', 'Autodesk Showcase 2013', 'Autodesk Sketchbook Designer 2013', 'Autodesk 3ds Max Design 2013', 'Autodesk Navisworks Simulate 2013', 'Autodesk Revit Architecture 2013', 'Auotdesk Revit MEP 2013', 'Autodesk Revit Structure 2013', 'Autodesk Inventor 2013', 'Autodesk Navisworks Manage 2013', 'Autodesk Quantity Takeoff 2013', 'Autodesk Robot Structural Analysis Professional', 'Building design software for CAD and BIM. Autodesk&reg; Building Design Suite provides a 3D building design software portfolio that combines Building Information Modeling (BIM) and CAD tools to help you design, visualize, simulate, and build more efficiently. Produce compelling visualizations, use integrated simulation and analysis, create higher-quality construction documentation, and improve control over project outcomes.', '', 'autoDeskBuildingDesignSuite.png', 'large-AutoDeskBuildingDesignSuiteStandard.jpg', 'small-AutoDeskBuildingDesignSuiteStandard.jpg', '2013-04-10', '70bf447653b3aeb77f932f9112b30aba', '0000-00-00', 'show'),
(21, 'AutoDesk Factory Design Suite', '', 'Product Suite', 'AutoDeskFactoryDesignSuite.pdf', 'AutoCAD 2013', 'AutoCAD Architecture', 'AutoCAD Mechanical', 'AutoDesk Vault', 'Autodesk Showcase 2013', 'Autodesk Factory Design Suite Utilities', 'Autodesk 3ds Max Design 2013', 'Autodesk Inventor 2013', 'Autodesk Navisworks Simulate 2013', 'Autodesk Inventor Professional 2013', 'Autodesk Navisworks Manage 2013', '', '', '', '', 'Autodesk&reg; Factory Design Suite helps you design and communicate the most efficient manufacturing layout by creating a digital factory model. Quickly evaluate multiple what-if layout scenarios to determine the best solution before any equipment is installed. Factory-specific visualization and analysis tools help increase innovation, design efficiency, and communication.', '', 'autoDeskFactoryDesignSuite.png', 'large-AutoDeskFactoryDesignSuite.jpg', '', '2013-04-10', '0451f725473590fe786d0f47609a09c4', '0000-00-00', 'show'),
(22, 'AutoDesk Infrastructure Design', '2013', 'Product Suite', 'AutoDeskInfrastructureDesign.pdf', 'AutoCAD 2013', 'AutoCAD Map 3D', 'AutoCAD Raster Design', 'Autodesk Navisworks Simulate 2013', 'AutoCAD Civil 3D', 'Autodesk 3ds Max Design 2013', 'Autodesk Navisworks Manage 2013', 'Autodesk Revit Structure 2013', '', '', '', '', '', '', '', 'Civil engineering tools for infrastructure design<br />\r\nAutodesk® Infrastructure Design Suite is a BIM for Infrastructure design solution that combines intelligent, model-based tools to help you gain more accurate, accessible, and actionable insight. With unique access to the Autodesk infrastructure software portfolio, you can benefit throughout the execution and lifecycle of transportation, land, and water projects.', '', 'autoDeskInfrastructureDesignSuite.png', 'large-AutoDeskInfrastructureDesignSuite.jpg', '', '2013-04-10', '80e6c6235322e10de781746266c5d1e3', '2013-04-14', 'show'),
(23, 'AutoDesk Product Design Suite', '2013', 'Product Suite', 'AutoDeskProductDesignSuite.pdf', 'AutoCAD 2013', 'AutoCAD Mechanical', 'Autodesk Inventor 2013', 'Autodesk Mudbox 2013', 'Autodesk Showcase 2013', 'Autodesk Sketchbook Designer 2013', 'AutoDesk Vault', 'AutoCAD Electrical 2013', 'Autodesk 3ds Max Design 2013', 'Autodesk Navisworks Simulate 2013', 'Autodesk Alias Design 2013', 'Autodesk Inventor Professional 2013', '', '', '', 'Deliver better 3D product designs. Faster.<br />\r\nAutodesk® Product Design Suite is a comprehensive solution delivering 3D design, simulation, collaboration, and visualization tools to complete your entire engineering process. The Digital Prototyping capabilities of the suite can help you design better products, reduce development costs, and get to market faster.', '', 'autoDeskProductDesignSuite.png', 'large-AutoDeskProductDesignSuite.jpg', '', '2013-04-10', 'ba418fb311676220158b0d75a3122ddc', '2013-04-14', 'show'),
(24, 'Autodesk Sketchbook Designer', '2013', 'Product', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2013-04-15', '48bef0dd172d5534157234a91d3e5475', '0000-00-00', 'show'),
(26, 'Autodesk Showcase', '2013', 'Product', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2013-04-15', '2a0262707abd4bce80d0c789599dc612', '0000-00-00', ''),
(27, 'Autodesk Mudbox 2013', '', 'Product', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0000-00-00', '', '2013-04-15', 'show'),
(44, 'Autodesk Quantity Takeoff 2013', '', 'Product', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0000-00-00', '', '0000-00-00', 'show'),
(28, 'Autodesk Alias Design 2013', '', 'Product', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2013-04-15', '388c66b76d9db92ffb98f3c2a3e44aa6', '2013-04-15', 'show'),
(29, 'Autodesk 3ds Max Design 2013', '', 'Product', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2013-04-15', 'b7ba6546b78c35501fc140ecab2229a5', '0000-00-00', 'show'),
(42, 'Auotdesk Revit MEP 2013', '', 'Product', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0000-00-00', '', '0000-00-00', 'show'),
(43, 'Autodesk Revit Architecture 2013', '', 'Product', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0000-00-00', '', '0000-00-00', 'show'),
(30, 'AutoCAD and ID 2013', '', 'Product', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2013-04-15', '5827de18f9ca2c6d0ffa16eeffac066b', '0000-00-00', 'show'),
(41, 'AutoCAD MEP', '', 'Product', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0000-00-00', '', '0000-00-00', 'show'),
(31, 'AutoCAD Plant 3D 2013', '', 'Product', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2013-04-15', 'e1e51525e70bba3b74509b305b1300bd', '0000-00-00', 'show'),
(39, 'Autodesk Robot Structural Analysis Professional', '', 'Product', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0000-00-00', '', '0000-00-00', 'show'),
(40, 'AutoCAD Architecture', '', 'Product', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0000-00-00', '', '0000-00-00', 'show'),
(32, 'AutoCAD Structural Detailing 2013', '', 'Product', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2013-04-15', '800c2dba16d0ecbc9a17a18798c3b5b0', '0000-00-00', 'show'),
(37, 'Autodesk Inventor Professional 2013', '', 'Product', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0000-00-00', '', '0000-00-00', 'show'),
(38, 'Autodesk Factory Design Suite Utilities', '', 'Product', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0000-00-00', '', '0000-00-00', 'show'),
(33, 'Autodesk Revit Structure 2013', '', 'Product', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0000-00-00', '', '0000-00-00', 'show'),
(34, 'Autodesk Navisworks Simulate 2013', '', 'Product', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2013-04-15', '', '0000-00-00', 'show'),
(35, 'Autodesk Navisworks Manage 2013', '', 'Product', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2013-04-15', '', '0000-00-00', 'show'),
(36, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2013-04-15', '', '0000-00-00', '');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `access`
--
ALTER TABLE `access`
  ADD PRIMARY KEY (`User_Email`),
  ADD UNIQUE KEY `id` (`id`);

--
-- 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 `tbadges`
--
ALTER TABLE `tbadges`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `ProductName` (`ProductName`);

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `access`
--
ALTER TABLE `access`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- 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 `tbadges`
--
ALTER TABLE `tbadges`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;
--
-- AUTO_INCREMENT for table `testimonials`
--
ALTER TABLE `testimonials`
  MODIFY `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `thardware`
--
ALTER TABLE `thardware`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;
--
-- AUTO_INCREMENT for table `tsoftware`
--
ALTER TABLE `tsoftware`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45;
