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




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

--
-- Table structure for table `tbl_categories`
--

CREATE TABLE IF NOT EXISTS `tbl_categories` (
  `User_Level_Id` int(11) NOT NULL AUTO_INCREMENT,
  `User_Level` char(250) DEFAULT NULL,
  `Image_one` varchar(255) NOT NULL DEFAULT 'none.gif',
  PRIMARY KEY (`User_Level_Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

--
-- Dumping data for table `tbl_categories`
--

INSERT INTO `tbl_categories` (`User_Level_Id`, `User_Level`, `Image_one`) VALUES
(1, 'Auto Lamp', 'cacparts-cat-1.jpg'),
(2, 'Bearing', 'cacparts-cat-2.jpg'),
(3, 'Belt', 'cacparts-cat-3.jpg'),
(4, 'Brake Pad', 'cacparts-cat-4.jpg'),
(5, 'Clutch', 'cacparts-cat-5.jpg'),
(6, 'Engine Mounting', 'cacparts-cat-6.jpg'),
(7, 'Filter', 'cacparts-cat-7.jpg'),
(8, 'Fuel Pump', 'cacparts-cat-8.jpg'),
(9, 'Gasket', 'cacparts-cat-9.jpg'),
(10, 'Horn', 'cacparts-cat-10.jpg'),
(11, 'Steering System', 'cacparts-cat-11.jpg'),
(12, 'Suspension', 'cacparts-cat-12.jpg'),
(13, 'Water Pump', 'cacparts-cat-13.jpg');

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

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

CREATE TABLE IF NOT EXISTS `tbl_content` (
  `Page_Id` int(11) NOT NULL AUTO_INCREMENT,
  `File_Name` char(255) DEFAULT NULL,
  `Content` text,
  `Page_Title` char(50) DEFAULT NULL,
  `Meta_Title` text,
  `Meta_Keyword` text,
  `Meta_Desc` text,
  PRIMARY KEY (`Page_Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

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

INSERT INTO `tbl_content` (`Page_Id`, `File_Name`, `Content`, `Page_Title`, `Meta_Title`, `Meta_Keyword`, `Meta_Desc`) VALUES
(4, 'about_us.php', '<div id="maintext">\r\n<h1>Company Profile</h1>\r\n<p class="style1"><strong>C &amp; A  									International Limited</strong> is an <strong> 									ISO 9001:2008</strong> company providing  									high quality <strong>Auto Lamp, Bearing,  									Belt, Brake Pad, Clutch, Engine Mounting,  									Filter, Fuel Pump, Gasket, Horn, Steering  									System, Suspension, Water Pump</strong> etc  									worldwide. Our head office is located in 									<strong>Shenzhen, China</strong> and we have  									well skilled staff of dedicated and  									innovative professionals providing prompt  									after sales support to the customers with  									professional attitude which has helped our  									company in achieving ultimate customer  									satisfaction. <br/>\r\n<br/>\r\nAfter experiencing more than four decades in  									the world of <strong>auto parts industry</strong>,  									today we are having nationwide dealer  									network as well as large industrial client  									network.</p>\r\n<hr/>\r\n<br/>\r\n<h1>History &amp; Development</h1>\r\n<p class="style1"><strong>C &amp; A  									International Limited</strong> has a golden  									history with silver words in the world of 									<strong>Auto Parts Industry</strong>. 									<strong>C &amp; A International Limited</strong>  									has started its journey from domestic market  									to global market in such a small time.<br/>\r\n<br/>\r\nWe have maintained time by time changes in 									<strong>Auto Parts</strong> by observing it  									on <strong>Car Manufacturer</strong>''s unit.<br/>\r\n<br/>\r\nThe firm was established as a registered  									company. The main promoter of the company is 									<strong>Mr. Bassam</strong> when they  									started the company with the initial  									investment of $1 million. <strong>C &amp; A  									International Limited</strong> entered into  									production of <strong>Auto Parts in 1990</strong>  									for domestic market.<br/>\r\n<br/>\r\nTo fulfill the need for continuous quality  									improvement and to ensure continued customer  									satisfaction, company is certified with  									emerging standards of globe i.e. ISO  									9001-2008.<br/>\r\n<br/>\r\nThe new feather which company has added is  									to become considerable player of  									international market and become 100%  									domestic unit. <strong>C &amp; A International  									Limited</strong> is catering almost 22  									provinces plus two special administrative  									regions (Hong Kong and Macau) in China and  									more than 24 countries worldwide.</p>\r\n</div>', 'About Us', '', '', ''),
(10, 'home.php', '<table style="width: 100%;">\r\n    <tbody>\r\n        <tr>\r\n            <td>At xyz furniture, you receive wide range quality of  					materials, along with expert, professional craftsmanship.  					Our reputation for being one of the top manufacturers in the  					furniture industry is recognized on a global scale.<br/>\r\n            <br/>\r\n            xyz furniture has the perfect, cost effective solutions for  					your home, villa, office, store, hotel, laboratory or  					institution. We&rsquo;ve been specializing in this industry for  					almost 10 years and we know everything there is to know  					about custom furniture.<br/>\r\n            <br/>\r\n            Our highly skilled experts have one working purpose &ndash; to use  					their passion for quality design to give you the best  					available products.<br/>\r\n            <br/>\r\n            Regardless of whether you&rsquo;re furnishing 1 bed room house or  					a villa, our team is there for you to answer your questions  					or give you fresh, innovative ideas. Above all, your project  					is their singular focus.<br/>\r\n            <br/>\r\n            xyz furniture provides only unique, customized furniture  					products such as sofa, beds, wardrobes, modular kitchen,  					chairs, tables, office furniture, and lighitings. Each item  					is constructed according to your needs, wishes and budget  					but we hope that you dream a little, too. Thinking &lsquo;outside  					of the box&rsquo; has been responsible for some truly delightful  					and surprising results.<br/>\r\n            <br/>\r\n            we have our own factories in Shunde - China, We have well  					equipped machineries and well experienced quality testing  					team. we have martial purchase department with large  					experience in this industry.<br/>\r\n            <br/>\r\n            we are able to export quality products world wide, currently  					we have our sales offices in India, France, UK, and China. 					</td>\r\n        </tr>\r\n    </tbody>\r\n</table>', 'Home', '', '', ''),
(11, 'contact.php', '<p>Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Vestibulum tortor quam, feugiat vitae, ultricies eget, tempor sit amet, ante. Donec eu libero sit amet quam egestas semper. Aenean ultricies mi vitae est. Mauris placerat eleifend leo.</p>\r\n<p><strong>Address:</strong> Street Address nr 100, 4536534, Your Town, United States </p>\r\n<div class="separator">&nbsp;</div>\r\n<p><strong>Phone:</strong>  (212) 555 55 00 </p>\r\n<div class="separator">&nbsp;</div>\r\n<p><strong>Email:</strong>  office@yourwebsite.com <br/>\r\n<strong>Web:</strong>  www.yourwebsite.com </p>', 'Contact Us', '', '', ''),
(12, 'services.php', '', 'Services', '', '', ''),
(13, 'faq.php', 'content coming soon<br/>', 'FAQ''s', '', '', '');

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

--
-- Table structure for table `tbl_products`
--

CREATE TABLE IF NOT EXISTS `tbl_products` (
  `User_Level_Id` int(11) NOT NULL AUTO_INCREMENT,
  `category_id` int(11) DEFAULT NULL,
  `User_Level` char(250) DEFAULT NULL,
  `Product_Usage` varchar(255) NOT NULL,
  `Image_one` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`User_Level_Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `tbl_products`
--

INSERT INTO `tbl_products` (`User_Level_Id`, `category_id`, `User_Level`, `Product_Usage`, `Image_one`) VALUES
(1, 1, 'MG 3002', 'Benz/Audi', 'cacparts-1.jpg');

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

--
-- Table structure for table `tbl_slider_images`
--

CREATE TABLE IF NOT EXISTS `tbl_slider_images` (
  `Image_Id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Largeimage` char(255) DEFAULT NULL,
  `Display_Order` int(11) DEFAULT NULL,
  PRIMARY KEY (`Image_Id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tbl_slider_images`
--


