-- phpMyAdmin SQL Dump -- version 3.2.4 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jul 03, 2012 at 10:37 PM -- Server version: 5.1.41 -- PHP Version: 5.3.1 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `cacarparts` -- -- -------------------------------------------------------- -- -- Table structure for table `tbl_admin` -- CREATE TABLE IF NOT EXISTS `tbl_admin` ( `User_Name` char(25) DEFAULT NULL, `Password` char(25) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_admin` -- INSERT INTO `tbl_admin` (`User_Name`, `Password`) VALUES ('admin', 'admin123'); -- -------------------------------------------------------- -- -- 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', '
\r\n

Company Profile

\r\n

C & A International Limited is an ISO 9001:2008 company providing high quality Auto Lamp, Bearing, Belt, Brake Pad, Clutch, Engine Mounting, Filter, Fuel Pump, Gasket, Horn, Steering System, Suspension, Water Pump etc worldwide. Our head office is located in Shenzhen, China 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.
\r\n
\r\nAfter experiencing more than four decades in the world of auto parts industry, today we are having nationwide dealer network as well as large industrial client network.

\r\n
\r\n
\r\n

History & Development

\r\n

C & A International Limited has a golden history with silver words in the world of Auto Parts Industry. C & A International Limited has started its journey from domestic market to global market in such a small time.
\r\n
\r\nWe have maintained time by time changes in Auto Parts by observing it on Car Manufacturer''s unit.
\r\n
\r\nThe firm was established as a registered company. The main promoter of the company is Mr. Bassam when they started the company with the initial investment of $1 million. C & A International Limited entered into production of Auto Parts in 1990 for domestic market.
\r\n
\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.
\r\n
\r\nThe new feather which company has added is to become considerable player of international market and become 100% domestic unit. C & A International Limited is catering almost 22 provinces plus two special administrative regions (Hong Kong and Macau) in China and more than 24 countries worldwide.

\r\n
', 'About Us', '', '', ''), (10, 'home.php', '\r\n \r\n \r\n \r\n \r\n \r\n
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.
\r\n
\r\n xyz furniture has the perfect, cost effective solutions for your home, villa, office, store, hotel, laboratory or institution. We’ve been specializing in this industry for almost 10 years and we know everything there is to know about custom furniture.
\r\n
\r\n Our highly skilled experts have one working purpose – to use their passion for quality design to give you the best available products.
\r\n
\r\n Regardless of whether you’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.
\r\n
\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 ‘outside of the box’ has been responsible for some truly delightful and surprising results.
\r\n
\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.
\r\n
\r\n we are able to export quality products world wide, currently we have our sales offices in India, France, UK, and China.
', 'Home', '', '', ''), (11, 'contact.php', '

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.

\r\n

Address: Street Address nr 100, 4536534, Your Town, United States

\r\n
 
\r\n

Phone: (212) 555 55 00

\r\n
 
\r\n

Email: office@yourwebsite.com
\r\nWeb: www.yourwebsite.com

', 'Contact Us', '', '', ''), (12, 'services.php', '', 'Services', '', '', ''), (13, 'faq.php', 'content coming soon
', '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_site_settings` -- CREATE TABLE IF NOT EXISTS `tbl_site_settings` ( `id` int(11) NOT NULL AUTO_INCREMENT, `admin_name` char(255) DEFAULT NULL, `admin_email` char(255) DEFAULT NULL, `sign_up_charge` char(255) DEFAULT NULL, `business_phone_number` char(255) DEFAULT NULL, `paypal_username` char(255) DEFAULT NULL, `paypal_password` char(255) DEFAULT NULL, `paypal_signature` char(255) DEFAULT NULL, `payment_mode` char(7) DEFAULT NULL, `site_on_off` char(255) DEFAULT NULL, `logo_name` char(255) DEFAULT NULL, `logo_system_name` char(255) DEFAULT NULL, `payment_switch` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; -- -- Dumping data for table `tbl_site_settings` -- INSERT INTO `tbl_site_settings` (`id`, `admin_name`, `admin_email`, `sign_up_charge`, `business_phone_number`, `paypal_username`, `paypal_password`, `paypal_signature`, `payment_mode`, `site_on_off`, `logo_name`, `logo_system_name`, `payment_switch`) VALUES (3, 'CA Car Parts', 'vishalpatel7287@gmail.com', '', '989889899889', 'seates_1269963840_biz_api1.yahoo.com', 'AKY68QKF4E5HGLPC', 'AFcWxV21C7fd0v3bYYYRCpSSRl31AQGnbp6xjVv56k64gbVZpJkITc5O', 'Sandbox', 'On', 'Winter.jpg', 'admin_logo.jpg', 'Yes'); -- -------------------------------------------------------- -- -- 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` -- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;