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




--
-- Database: `autosalon`
--

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

--
-- Table structure for table `branch`
--

CREATE TABLE IF NOT EXISTS `branch` (
  `branch_id` int(11) NOT NULL AUTO_INCREMENT,
  `cuntry_id` int(11) NOT NULL,
  `branch_caption` char(255) NOT NULL,
  `branch_caption_ar` char(255) NOT NULL,
  `branch_telphone` char(255) NOT NULL,
  `branch_telphone_ar` char(255) NOT NULL,
  `branch_fax` char(255) NOT NULL,
  `branch_fax_ar` char(255) NOT NULL,
  `branch_desc` blob NOT NULL,
  `branch_desc_ar` blob NOT NULL,
  `branch_hours` char(255) NOT NULL,
  `branch_location` blob NOT NULL,
  `branch_photo` char(255) NOT NULL,
  `branch_manger` char(255) NOT NULL,
  PRIMARY KEY (`branch_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `branch`
--

INSERT INTO `branch` (`branch_id`, `cuntry_id`, `branch_caption`, `branch_caption_ar`, `branch_telphone`, `branch_telphone_ar`, `branch_fax`, `branch_fax_ar`, `branch_desc`, `branch_desc_ar`, `branch_hours`, `branch_location`, `branch_photo`, `branch_manger`) VALUES
(1, 2, 'Jleeb Al Shuyoukh I', '', '24310321', '', '24310322', '', 0x426c64672031322c20426c6f636b2031372c20506f6c6963652053746174696f6e20526f61643c62723e0d0a4a6c65656220416c20536875796f756b680d0a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020, '', '8.00 AM - 9.00 PM ,\r\nFriday: 8.30 AM - 9.00 PM\r\n', 0x20202020202020202020202020202020202020202020202020202020, 'niimg1.jpg', ''),
(2, 2, 'Jleeb Al Shuyoukh II', '', '24312440 , 24341911', '', '24334547', '', 0x20202020202020204275696c64696e672023203137392c20426c6f636b20232031352c2053747265657420232031302c204a6c65656220416c20536875796f756b680d0a0d0a202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020, '', '              9:00 AM - 1:00 PM & 4:30 PM - 9:00 PM ,	\r\nFriday: 9:00 AM-1:00 PM & 4:30 PM-9:00 PM	\r\n', 0x20202020202020202020202020202020202020202020202020202020, 'niimg1.jpg', 'name'),
(3, 2, 'Abu Halifa', '', '23712524', '', '23712524', '', 0x202041627568616c69666120436f2d4f706572617469766520536f63696574790d0a0d0a20202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020, '', '          8.00 AM - 9.00 PM<br>\r\nFriday: 8.30 AM - 9.00 PM\r\n', 0x3c696672616d65206672616d65626f726465723d223022206865696768743d2233353022206d617267696e6865696768743d223022206d617267696e77696474683d223022207363726f6c6c696e673d226e6f22207372633d2268747470733a2f2f6d6170732e676f6f676c652e636f2e696e2f6d6170733f663d7126736f757263653d735f7126686c3d656e2667656f636f64653d26713d4b75776169742b436974792c2b2b4b75776169742661713d26736c6c3d32392e3336393732322c34372e393738333333267373706e3d302e3039313130352c302e3136393038362669653d555446382668713d26686e6561723d4b75776169742b436974792c2b416c2b4173696d61682c2b4b7577616974266c6c3d32392e3336393732322c34372e3937383333332673706e3d302e3138323234332c302e33333831373326743d6d267a3d3132266f75747075743d656d626564222077696474683d22363530223e3c2f696672616d653e202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020, 'niimg1.jpg', 'Test');

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

--
-- Table structure for table `careers`
--

CREATE TABLE IF NOT EXISTS `careers` (
  `careers_id` int(11) NOT NULL AUTO_INCREMENT,
  `careers_caption` char(255) NOT NULL,
  `careers_caption_ar` char(255) NOT NULL,
  `careers_desc` blob NOT NULL,
  `careers_desc_ar` blob NOT NULL,
  `careers_insert` char(100) NOT NULL,
  `careers_status` char(10) NOT NULL,
  `careers_file` char(200) NOT NULL,
  PRIMARY KEY (`careers_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `careers`
--

INSERT INTO `careers` (`careers_id`, `careers_caption`, `careers_caption_ar`, `careers_desc`, `careers_desc_ar`, `careers_insert`, `careers_status`, `careers_file`) VALUES
(1, 'fdsf', 'sdfdsf', 0x3c703e266e6273703b6473666473663c2f703e, 0x3c703e266e6273703b736466643c2f703e, '2014-05-14', 'off', '');

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

--
-- Table structure for table `clinents`
--

CREATE TABLE IF NOT EXISTS `clinents` (
  `c_id` int(11) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(100) NOT NULL,
  `c_email` varchar(100) NOT NULL,
  `c_username` varchar(100) NOT NULL,
  `c_password` varchar(100) NOT NULL,
  `status` varchar(10) NOT NULL DEFAULT 'on',
  PRIMARY KEY (`c_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `clinents`
--

INSERT INTO `clinents` (`c_id`, `company_name`, `c_email`, `c_username`, `c_password`, `status`) VALUES
(1, 'tester', 'tester@gmail.com', 'tester', 'pwd', 'on'),
(2, 'Ajith tech', 'ajith@ensconsultants.com', 'ajith', 'ajith', 'on'),
(3, 'UNITED TECHNICAL INDUSTRIAL SERVICES', 'robert@utis-kw.com', 'robert', 'robert123', 'on');

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

--
-- Table structure for table `currency_rate`
--

CREATE TABLE IF NOT EXISTS `currency_rate` (
  `currency_id` int(11) NOT NULL AUTO_INCREMENT,
  `currency_cntry` varchar(500) NOT NULL,
  `currency_name` char(150) NOT NULL,
  `currency_banktransfer` char(150) NOT NULL,
  `currency_fcbuy` char(150) NOT NULL,
  `currency_rte` varchar(150) NOT NULL,
  `currency_date` varchar(150) NOT NULL,
  `currency_uploadtime` char(150) NOT NULL,
  `currency_uploaddate` char(150) NOT NULL,
  PRIMARY KEY (`currency_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ;

--
-- Dumping data for table `currency_rate`
--

INSERT INTO `currency_rate` (`currency_id`, `currency_cntry`, `currency_name`, `currency_banktransfer`, `currency_fcbuy`, `currency_rte`, `currency_date`, `currency_uploadtime`, `currency_uploaddate`) VALUES
(1, 'AUD', 'Australian Dollars', '3.6874 (0.271193)', '', '', '6/24/2014', '11', 'June 24, 2014, 9:01 am'),
(2, 'BHD', 'Bahraini Dinar', '1.3298 (0.751968)', '', '', '6/24/2014', '11', 'June 24, 2014, 9:01 am'),
(3, 'BDT', 'Bangladeshi Taka', '275.25 (0.003633)', '', '', '6/24/2014', '11', 'June 24, 2014, 9:01 am'),
(4, 'CAD', 'Canadian Dollars', '3.757 (0.2661685)', '', '', '6/24/2014', '11', 'June 24, 2014, 9:01 am'),
(5, 'EGP', 'Egyptian Pound', '25.35 (0.0394477)', '', '', '6/24/2014', '11', 'June 24, 2014, 9:01 am'),
(6, 'EUR', 'Euro', '2.5798 (0.387625)', '', '', '6/24/2014', '11', 'June 24, 2014, 9:01 am'),
(7, 'INR', 'Indian Rupee', '213.01 (0.004695)', '', '', '6/24/2014', '11', 'June 24, 2014, 9:01 am'),
(8, 'JOD', 'Jordanian Dinar', '2.4896 (0.401668)', '', '', '6/24/2014', '11', 'June 24, 2014, 9:01 am'),
(9, 'MAD', 'Morocco Dirham', '28.647 (0.034908)', '', '', '6/24/2014', '11', 'June 24, 2014, 9:01 am'),
(10, 'MYR', 'Malaysian Ringgit', '11.039 (0.090591)', '', '', '6/24/2014', '11', 'June 24, 2014, 9:01 am'),
(11, 'NPR', 'Nepalese Rupee', '340.5 (0.0029369)', '', '', '6/24/2014', '11', 'June 24, 2014, 9:01 am'),
(12, 'OMR', 'Omani Riyal', '1.361 (0.7347721)', '', '', '6/24/2014', '11', 'June 24, 2014, 9:01 am'),
(13, 'PKR', 'Pakistani Rupee', '348.475 (0.00287)', '', '', '6/24/2014', '11', 'June 24, 2014, 9:01 am'),
(14, 'PHP', 'Philippine Pesos', '153.72 (0.006505)', '', '', '6/24/2014', '11', 'June 24, 2014, 9:01 am'),
(15, 'SAR', 'Saudi Riyal', '13.25 (0.0754703)', '', '', '6/24/2014', '11', 'June 24, 2014, 9:01 am'),
(16, 'SGD', 'Singapore Dollars', '4.3364 (0.230606)', '', '', '6/24/2014', '11', 'June 24, 2014, 9:01 am'),
(17, 'LKR', 'Sri Lankan Rupee', '461.77 (0.002166)', '', '', '6/24/2014', '11', 'June 24, 2014, 9:01 am'),
(18, 'CHF', 'Swiss Francs', '3.1229 (0.320216)', '', '', '6/24/2014', '11', 'June 24, 2014, 9:01 am'),
(19, 'THB', 'Thai Baht', '112.51 (0.008888)', '', '', '6/24/2014', '11', 'June 24, 2014, 9:01 am'),
(20, 'AED', 'UAE Dirham', '12.989 (0.076987)', '', '', '6/24/2014', '11', 'June 24, 2014, 9:01 am'),
(21, 'GBP', 'British Pounds Sterling', '2.0665 (0.483916)', '', '', '6/24/2014', '11', 'June 24, 2014, 9:01 am'),
(22, 'USD', 'US Dollars', '3.53419 (0.28295)', '', '', '6/24/2014', '11', 'June 24, 2014, 9:01 am');

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

--
-- Table structure for table `downloads`
--

CREATE TABLE IF NOT EXISTS `downloads` (
  `down_id` int(11) NOT NULL AUTO_INCREMENT,
  `down_cat` varchar(50) DEFAULT NULL,
  `down_year` year(4) DEFAULT NULL,
  `down_caption` varchar(200) DEFAULT NULL,
  `down_file` varchar(200) DEFAULT NULL,
  `down_image` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`down_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `downloads`
--

INSERT INTO `downloads` (`down_id`, `down_cat`, `down_year`, `down_caption`, `down_file`, `down_image`) VALUES
(1, 'Annual Report', 2010, 'test', 'Microsoft_Word_-_ALFA_SUPER_2000_SAE_ENGLISH__SPEC__download.pdf', NULL),
(2, 'Annual Report', 2011, 'test', '___U__a____U_U____U_U__________U_U_U_____U__(1).doc', NULL),
(4, 'Other Details', NULL, 'new', 'BIOTECTOR_profile.docx', NULL),
(5, 'Product Details', NULL, 'test1', 'WIKA_profile.docx', NULL);

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

--
-- Table structure for table `media`
--

CREATE TABLE IF NOT EXISTS `media` (
  `media_id` int(11) NOT NULL AUTO_INCREMENT,
  `media_cat` enum('Audio','Video','Songs') NOT NULL,
  `media_sub` varchar(50) NOT NULL,
  `media_caption` varchar(100) DEFAULT NULL,
  `media_ar_caption` varchar(100) NOT NULL,
  `media_source` enum('YouTube','GoogleVideo','External') NOT NULL,
  `media_file` varchar(200) DEFAULT NULL,
  `media_desc` text,
  `media_size` decimal(5,2) DEFAULT NULL,
  `media_duration` varchar(10) NOT NULL,
  `media_status` enum('ON','OFF','HP') NOT NULL DEFAULT 'ON',
  `media_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `media_order` int(15) NOT NULL,
  PRIMARY KEY (`media_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `media`
--

INSERT INTO `media` (`media_id`, `media_cat`, `media_sub`, `media_caption`, `media_ar_caption`, `media_source`, `media_file`, `media_desc`, `media_size`, `media_duration`, `media_status`, `media_date`, `media_order`) VALUES
(1, 'Video', '', 'test', 'test arabic', 'YouTube', 'bDqQvTI4_Z8', NULL, NULL, '', 'ON', '2013-07-06 10:34:20', 0);

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

--
-- Table structure for table `mediacategory`
--

CREATE TABLE IF NOT EXISTS `mediacategory` (
  `mcat_id` int(15) NOT NULL AUTO_INCREMENT,
  `mcat_name` varchar(200) NOT NULL,
  `mcat_path` varchar(200) NOT NULL,
  `mcat_parent` varchar(100) NOT NULL,
  PRIMARY KEY (`mcat_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `member`
--

CREATE TABLE IF NOT EXISTS `member` (
  `memberid` int(11) NOT NULL AUTO_INCREMENT,
  `companyname` varchar(50) NOT NULL,
  `contactNo` varchar(20) NOT NULL,
  `cust_email` varchar(50) NOT NULL,
  `username` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL,
  `status` varchar(10) NOT NULL DEFAULT 'on',
  PRIMARY KEY (`memberid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=29 ;

--
-- Dumping data for table `member`
--

INSERT INTO `member` (`memberid`, `companyname`, `contactNo`, `cust_email`, `username`, `password`, `status`) VALUES
(27, 'UTIS', '99249366', 'robert@utis-kw.com', 'UTIS0027', 'dK0f', 'on'),
(28, 'test', '343434', 'rcsacheesh@gmail.com', 'test0028', 'UopK', 'on'),
(25, 'equate', '99111121', 'shijo@ensconsultants.com', 'equa0025', '39FVZ1', 'on'),
(26, 'Aruna Tech', '4563', 'ajith@ensconsultants.com', 'Arun0026', 'vll8ZN9VZ0', 'on');

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

--
-- Table structure for table `members`
--

CREATE TABLE IF NOT EXISTS `members` (
  `apln_id` int(15) NOT NULL AUTO_INCREMENT,
  `apln_title` varchar(10) NOT NULL,
  `apln_name` varchar(150) NOT NULL,
  `apln_dob` date DEFAULT NULL,
  `apln_lline` varchar(25) NOT NULL,
  `apln_mobile` varchar(25) NOT NULL,
  `apln_caddress` text NOT NULL,
  `apln_town` varchar(200) NOT NULL,
  `apln_country` varchar(200) NOT NULL,
  `apln_pcode` varchar(30) NOT NULL,
  `apln_iaddress` varchar(225) NOT NULL,
  `apln_iphone` varchar(50) NOT NULL,
  `apln_rname` varchar(225) NOT NULL,
  `apln_raddress` text NOT NULL,
  `apln_rtown` varchar(200) NOT NULL,
  `apln_rcountry` varchar(200) NOT NULL,
  `apln_rpcode` varchar(20) NOT NULL,
  `apln_relation` varchar(100) NOT NULL,
  `apln_sname` varchar(200) NOT NULL,
  `apln_sdob` varchar(50) NOT NULL,
  `apln_smobile` varchar(50) NOT NULL,
  `apln_slline` varchar(50) NOT NULL,
  `apln_children` text NOT NULL,
  `username` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL,
  `apln_status` varchar(30) NOT NULL DEFAULT 'off',
  `apln_type` varchar(30) NOT NULL,
  `apln_email` varchar(150) NOT NULL,
  PRIMARY KEY (`apln_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `menu`
--

CREATE TABLE IF NOT EXISTS `menu` (
  `menu_id` int(11) NOT NULL AUTO_INCREMENT,
  `menu_parent` int(11) NOT NULL,
  `menu_name` varchar(100) NOT NULL,
  `menu_uname` varchar(100) NOT NULL,
  `menu_desc` varchar(255) NOT NULL,
  `menu_link` varchar(50) NOT NULL,
  `menu_ext_link` varchar(50) DEFAULT NULL,
  `menu_status` varchar(50) NOT NULL,
  `menu_order` int(11) NOT NULL,
  `menu_open` varchar(100) NOT NULL,
  `menu_type` varchar(100) NOT NULL,
  PRIMARY KEY (`menu_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `menu`
--

INSERT INTO `menu` (`menu_id`, `menu_parent`, `menu_name`, `menu_uname`, `menu_desc`, `menu_link`, `menu_ext_link`, `menu_status`, `menu_order`, `menu_open`, `menu_type`) VALUES
(1, 0, 'test', 'test', 'test', '', NULL, '', 0, '', '');

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

--
-- Table structure for table `menuorder`
--

CREATE TABLE IF NOT EXISTS `menuorder` (
  `order_id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) NOT NULL,
  `member_firstname` varchar(250) NOT NULL,
  `member_lastname` varchar(250) NOT NULL,
  `member_mailid` varchar(150) NOT NULL,
  `order_menu` varchar(150) NOT NULL,
  `price` varchar(50) NOT NULL,
  `order_qty` int(11) NOT NULL,
  `order_amount` varchar(50) NOT NULL,
  `order_insert` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`order_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;

--
-- Dumping data for table `menuorder`
--

INSERT INTO `menuorder` (`order_id`, `member_id`, `member_firstname`, `member_lastname`, `member_mailid`, `order_menu`, `price`, `order_qty`, `order_amount`, `order_insert`) VALUES
(1, 16, 'sashi', '', 'sashi@gmail.com', 'indian2', '', 1, '1.45KD', '2013-08-27 07:29:07'),
(2, 16, 'sashi', '', 'sashi@gmail.com', 'italian2', '', 1, '1.6KD', '2013-08-27 07:29:07'),
(3, 16, 'sashi', '', 'sashi@gmail.com', 'chinese5', '', 3, '2.85KD', '2013-08-27 07:37:54'),
(4, 14, 'q', '', 'q@gmail.com', 'arabic1', '', 1, '1.2KD', '2013-08-29 12:27:46'),
(5, 14, 'q', '', 'q@gmail.com', 'indian2', '', 1, '1.45KD', '2013-08-29 12:30:22'),
(6, 19, 'd', '', 'zdfdzf@gmail.com', 'indian2', '', 1, '1.45KD', '2013-08-29 12:31:25'),
(7, 18, 'Array', '', 'q@gmail.com', 'indian2', '', 1, '1.45KD', '2013-08-29 12:34:16'),
(8, 18, 'Array', '', 'q@gmail.com', 'chinese2', '', 1, '2.2KD', '2013-08-29 12:34:16'),
(9, 19, 'dfdfz', '', 'zdfdzf@gmail.com', 'continental3', '', 1, '1.45KD', '2013-08-29 12:35:45'),
(10, 16, 'sashi', 's', 'sashi@gmail.com', 'italian2', '', 1, '1.6KD', '2013-08-29 12:40:14'),
(11, 16, 'sashi', 's', 'sashi@gmail.com', 'continental3', '', 1, '1.45KD', '2013-08-29 12:40:14'),
(12, 16, 'sashi', 's', 'sashi@gmail.com', 'indian2', '', 1, '1.45KD', '2013-08-29 13:06:21'),
(13, 16, 'sashi', 's', 'sashi@gmail.com', 'arabic3', '', 3, '4.5KD', '2013-08-29 13:06:21'),
(14, 16, 'sashi', 's', 'sashi@gmail.com', 'continental1', '', 1, '1.5KD', '2013-08-29 13:06:21'),
(15, 16, 'sashi', 's', 'sashi@gmail.com', 'continental3', '', 1, '1.45KD', '2013-08-29 13:06:22'),
(16, 16, 'sashi', 's', 'sashi@gmail.com', 'continental3', '', 1, '1.45KD', '2013-08-29 13:07:30'),
(17, 16, 'sashi', 's', 'sashi@gmail.com', 'chinese5', '', 1, '0.95KD', '2013-08-29 13:07:30');

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

--
-- Table structure for table `news`
--

CREATE TABLE IF NOT EXISTS `news` (
  `news_id` int(15) NOT NULL AUTO_INCREMENT,
  `news_caption` varchar(255) NOT NULL,
  `news_caption_ar` varchar(255) NOT NULL,
  `news_desc` text NOT NULL,
  `news_desc_ar` text NOT NULL,
  `news_insert` varchar(20) NOT NULL,
  `news_status` varchar(15) NOT NULL DEFAULT 'off',
  `news_file` varchar(200) NOT NULL,
  PRIMARY KEY (`news_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `news`
--

INSERT INTO `news` (`news_id`, `news_caption`, `news_caption_ar`, `news_desc`, `news_desc_ar`, `news_insert`, `news_status`, `news_file`) VALUES
(5, 'Lorem Ipsum has been the industry''s standard dummy text', 'Lorem Ipsum has been the industry''s standard dummy text', '<p>Lorem Ipsum is simply dummy text of the printing and typesetting  industry. Lorem Ipsum has been the industry''s standard dummy text ever  since the 1500s, when an unknown printer took a galley of type and  scrambled it to make a type specimen book. It has survived not only five  centuries,</p>', '<p>Lorem Ipsum is simply dummy text of the printing and typesetting  industry. Lorem Ipsum has been the industry''s standard dummy text ever  since the 1500s, when an unknown printer took a galley of type and  scrambled it to make a type specimen book. It has survived not only five  centuries,</p>', '2013-12-24', 'off', '');

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

--
-- Table structure for table `newsleter`
--

CREATE TABLE IF NOT EXISTS `newsleter` (
  `newsleter_id` int(11) NOT NULL AUTO_INCREMENT,
  `Email` varchar(255) NOT NULL,
  `Date` char(255) NOT NULL,
  PRIMARY KEY (`newsleter_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `newsleter`
--

INSERT INTO `newsleter` (`newsleter_id`, `Email`, `Date`) VALUES
(4, 'vivek.nair@uaeexchange.com.kw', ''),
(5, 'rajitha_sp77@yahoo.com', ''),
(6, 'mustafa_khkhr@rediffmail.com', ''),
(7, 'arsenia217@yahoo.com', ''),
(8, 'arsenia217@yahoo.com', ''),
(9, 'arsenia217@yahoo.com', ''),
(10, 'thomas.eetti@gmail.com', '');

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

--
-- Table structure for table `orders`
--

CREATE TABLE IF NOT EXISTS `orders` (
  `order_id` int(11) NOT NULL AUTO_INCREMENT,
  `cust_id` int(11) NOT NULL,
  `cust_name` varchar(100) NOT NULL,
  `cust_address` varchar(500) NOT NULL,
  `cust_email` varchar(100) NOT NULL,
  `contactno` varchar(100) NOT NULL,
  `comment` varchar(750) NOT NULL,
  `comment_admin` varchar(750) NOT NULL,
  `products` varchar(500) NOT NULL,
  `total_amount` varchar(50) NOT NULL,
  `status` varchar(10) NOT NULL DEFAULT 'off',
  `order_status` varchar(20) NOT NULL DEFAULT 'Booking',
  `order_date` date NOT NULL,
  PRIMARY KEY (`order_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `pages`
--

CREATE TABLE IF NOT EXISTS `pages` (
  `page_id` int(11) NOT NULL AUTO_INCREMENT,
  `page_parent` int(11) NOT NULL,
  `page_MId` int(11) NOT NULL,
  `page_lang` varchar(10) NOT NULL,
  `page_type` varchar(100) NOT NULL,
  `page_name` varchar(100) DEFAULT NULL,
  `page_name_ar` char(100) NOT NULL,
  `page_title` varchar(100) DEFAULT NULL,
  `page_ctitle` varchar(100) DEFAULT NULL,
  `page_content` text,
  `page_content_ar` blob NOT NULL,
  `page_contentAbstract` text NOT NULL,
  `page_metakey` varchar(100) DEFAULT NULL,
  `page_metadesc` varchar(100) DEFAULT NULL,
  `page_url` varchar(200) DEFAULT NULL,
  `page_img` varchar(200) DEFAULT NULL,
  `page_imgTop` varchar(100) NOT NULL,
  `page_imgThumb` varchar(100) NOT NULL,
  `page_img1` varchar(100) NOT NULL,
  `page_img2` varchar(100) NOT NULL,
  `page_img3` varchar(100) NOT NULL,
  `page_content1` text NOT NULL,
  `page_content2` text NOT NULL,
  `page_content3` text NOT NULL,
  `page_rImage` text,
  PRIMARY KEY (`page_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=65 ;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` (`page_id`, `page_parent`, `page_MId`, `page_lang`, `page_type`, `page_name`, `page_name_ar`, `page_title`, `page_ctitle`, `page_content`, `page_content_ar`, `page_contentAbstract`, `page_metakey`, `page_metadesc`, `page_url`, `page_img`, `page_imgTop`, `page_imgThumb`, `page_img1`, `page_img2`, `page_img3`, `page_content1`, `page_content2`, `page_content3`, `page_rImage`) VALUES
(51, 0, 0, 'English', '', 'ABOUT US', '', 'ABOUT US', NULL, '<p style="text-align: justify;">\r\n	Autosalon is a master level detailer not only within the automotive detailing industry but also within the exclusive private/corporate jet industry and has worked on some of the finest and rarest automobiles and aircraft in the world.Autosalon has offered his detailing services worldwide for over twenty-five years to a wide range or collectors,business leaders and celebrities alike.<br />\r\n	<br />\r\n	<!--<img alt="" class="cnt_image" height="244" src="images/maruti-suzuki.jpg" width="368" />-->Eleven-years ago after numerous request from others who wished to learn detailing at a proven level that delivered higher then average results and profits,Autosalon started to train,mentor and coach both novice and professionals within the art of professional auto detailing.Since then,Autosalon has trained people from across the globe and shares with YOU over thirty years of detailing experience.<br />\r\n	&nbsp;</p>\r\n', '', '', NULL, NULL, 'about-us', NULL, '', '', '', '', '', '', '', '', NULL),
(52, 0, 0, 'English', '', 'Contact Us', '', 'Contact Us', NULL, '<div style="margin:15px;">\r\n	<table border="0" cellpadding="10" cellspacing="10" width="100%">\r\n		<tbody>\r\n			<tr>\r\n				<td colspan="2" height="22" style="color:#121818; font-size:16px; padding-bottom:3px;">\r\n					Address Details</td>\r\n			</tr>\r\n			<tr>\r\n				<td height="35" style="font-size:12px;" valign="top" width="49%">\r\n					Auto Salon<br />\r\n					P.O. Box 0000, Kuwait.</td>\r\n			</tr>\r\n			<tr>\r\n				<td colspan="2" height="22" style="color:#121818; font-size:16px; padding-bottom:3px;">\r\n					Contact Details</td>\r\n			</tr>\r\n			<tr>\r\n				<td valign="top" width="51%">\r\n					<table border="0" cellpadding="0" cellspacing="3" style="text-align: justify;" width="416">\r\n						<tbody>\r\n							<tr>\r\n								<td valign="top" width="35">\r\n									<img src="images/tele_icon.jpg" style="margin-top:7px;width:18px;height:9px;" /></td>\r\n								<td width="180">\r\n									(+965) 000 000 / 00 / 00</td>\r\n								<td rowspan="4" valign="top" width="189">\r\n									<table border="0" cellpadding="0" cellspacing="3" width="100%">\r\n										<tbody>\r\n											<tr>\r\n												<td>\r\n													<img src="images/mail_icon.jpg" style="width:18px;height:8px;" /></td>\r\n												<td height="15">\r\n													<a href="#" style="text-decoration:none;color:#121818;">info@autosalon.com</a></td>\r\n											</tr>\r\n											<tr>\r\n												<td>\r\n													<img src="images/web_icon.jpg" style="width:18px;height:14px;" /></td>\r\n												<td height="15">\r\n													<a href="#" style="text-decoration:none;color:#121818;">www.autosalon.com</a></td>\r\n											</tr>\r\n										</tbody>\r\n									</table>\r\n								</td>\r\n							</tr>\r\n							<tr>\r\n								<td>\r\n									<img src="images/fax_icon.jpg" style="width:18px;height:14px;" /></td>\r\n								<td height="15">\r\n									(+965) 0000 0000</td>\r\n							</tr>\r\n						</tbody>\r\n					</table>\r\n				</td>\r\n			</tr>\r\n		</tbody>\r\n	</table>\r\n</div>\r\n<div style="margin:15px;">\r\n	<iframe frameborder="0" height="250" marginheight="0" marginwidth="0" scrolling="no" src="https://maps.google.co.in/maps?f=q&amp;source=s_q&amp;hl=en&amp;geocode=&amp;q=Kuwait+City,++Kuwait&amp;aq=&amp;sll=29.369722,47.978333&amp;sspn=0.091105,0.169086&amp;ie=UTF8&amp;hq=&amp;hnear=Kuwait+City,+Al+Asimah,+Kuwait&amp;ll=29.369722,47.978333&amp;spn=0.182243,0.338173&amp;t=m&amp;z=12&amp;output=embed" width="100%"></iframe></div>\r\n', '', '', NULL, NULL, 'contact-us', NULL, '', '', '', '', '', '', '', '', NULL),
(54, 0, 0, '', 'Single Page', 'The Company    ', '', ' The Company    ', NULL, '', '', '', NULL, NULL, 'the-company', NULL, '', '', '', '', '', '', '', '', NULL),
(55, 0, 0, '', 'Single Page', '  Mission and Vision', '', 'Mission and Vision', NULL, '', '', '', NULL, NULL, 'mission-and-vision', NULL, '', '', '', '', '', '', '', '', NULL),
(56, 0, 0, '', '', 'Our Team', '', 'Our Team', NULL, '', '', '', NULL, NULL, 'our-team', NULL, '', '', '', '', '', '', '', '', NULL),
(57, 0, 0, '', '', 'Services', '', 'Services', NULL, '<div class="bnr_btm_srv1">\r\n	<div class="srv_pic1">\r\n		<a href="paint-protection.htm"><img alt="" height="165" src="images/srv_pic1.jpg" width="165" /></a></div>\r\n	<h4>\r\n		<span>Paint </span>Protection</h4>\r\n</div>\r\n<div class="bnr_btm_srv1">\r\n	<div class="srv_pic1">\r\n		<a href="teflon-coating-.htm"><img alt="" height="165" src="images/srv_pic2.jpg" width="165" /></a></div>\r\n	<h4>\r\n		<span>Teflon Coating </span> Tint</h4>\r\n</div>\r\n<div class="bnr_btm_srv1">\r\n	<div class="srv_pic1">\r\n		<a href="exterior-and-interior-detailing.htm"><img alt="" height="165" src="images/srv_pic3.jpg" width="165" /></a></div>\r\n	<h4>\r\n		<span>Exterior &amp; Interior </span> Detailing</h4>\r\n</div>\r\n<div class="bnr_btm_srv1">\r\n	<div class="srv_pic1">\r\n		<a href="solar-window-tint.htm"><img alt="" height="165" src="images/srv_pic4.jpg" width="165" /></a></div>\r\n	<h4>\r\n		<span>Solar Window </span> Tint</h4>\r\n</div><br clear="all">\r\n', '', '', NULL, NULL, 'services', NULL, '', '', '', '', '', '', '', '', NULL),
(58, 0, 0, '', '', 'Silver care Package', '', 'Silver care Package', NULL, '<div style="float:left;width:400px;">\r\n	<div class="pakagediv">\r\n		<div class="pakagediv1">\r\n			Floor</div>\r\n		<div class="pakagediv2">\r\n			:</div>\r\n		<div class="pakagediv3">\r\n			Vacuum</div>\r\n	</div>\r\n	<div class="pakagediv">\r\n		<div class="pakagediv1">\r\n			Seats</div>\r\n		<div class="pakagediv2">\r\n			:</div>\r\n		<div class="pakagediv3">\r\n			Stain Removal</div>\r\n	</div>\r\n	<div class="pakagediv">\r\n		<div class="pakagediv1">\r\n			Dashboard</div>\r\n		<div class="pakagediv2">\r\n			:</div>\r\n		<div class="pakagediv3">\r\n			Wipe &amp; Clean</div>\r\n	</div>\r\n	<div class="pakagediv">\r\n		<div class="pakagediv1">\r\n			Door Trim</div>\r\n		<div class="pakagediv2">\r\n			:</div>\r\n		<div class="pakagediv3">\r\n			Wipe &amp; Clean</div>\r\n	</div>\r\n	<div class="pakagediv">\r\n		<div class="pakagediv1">\r\n			Roof</div>\r\n		<div class="pakagediv2">\r\n			:</div>\r\n		<div class="pakagediv3">\r\n			Stain Removal</div>\r\n	</div>\r\n	<div class="pakagediv">\r\n		<div class="pakagediv1">\r\n			Trunk</div>\r\n		<div class="pakagediv2">\r\n			:</div>\r\n		<div class="pakagediv3">\r\n			Vacuum</div>\r\n	</div>\r\n	<div class="pakagediv">\r\n		<div class="pakagediv1">\r\n			Exterior</div>\r\n		<div class="pakagediv2">\r\n			:</div>\r\n		<div class="pakagediv3">\r\n			Wash &amp; Wax</div>\r\n	</div>\r\n	<div class="pakagediv">\r\n		<div class="pakagediv1">\r\n			Exterior</div>\r\n		<div class="pakagediv2">\r\n			:</div>\r\n		<div class="pakagediv3">\r\n			2 Stage polishing</div>\r\n	</div>\r\n</div>\r\n<div style="float:left;">\r\n	<img src="images/pakagimage1.jpg" style="border:3px solid #CCC;"/></div><br clear="all">\r\n', '', '', NULL, NULL, 'silver-care-package', NULL, '', '', '', '', '', '', '', '', NULL),
(59, 0, 0, '', '', 'Gold care Package', '', 'Gold care Package', NULL, '<div style="float:left;width:600px;">\r\n	<div class="pakagediv">\r\n		<div class="pakagediv1">\r\n			Floor</div>\r\n		<div class="pakagediv2">\r\n			:</div>\r\n		<div class="pakagediv3">\r\n			Vacuum + Dust Extraction + Dry Cleaning</div>\r\n	</div>\r\n	<div class="pakagediv">\r\n		<div class="pakagediv1">\r\n			Seats</div>\r\n		<div class="pakagediv2">\r\n			:</div>\r\n		<div class="pakagediv3">\r\n			Stain Removal +Dust Extraction + Dry Cleaning</div>\r\n	</div>\r\n	<div class="pakagediv">\r\n		<div class="pakagediv1">\r\n			Dashboard</div>\r\n		<div class="pakagediv2">\r\n			:</div>\r\n		<div class="pakagediv3">\r\n			Wipe &amp; Clean + Dressing</div>\r\n	</div>\r\n	<div class="pakagediv">\r\n		<div class="pakagediv1">\r\n			Door Trim</div>\r\n		<div class="pakagediv2">\r\n			:</div>\r\n		<div class="pakagediv3">\r\n			Wipe &amp; Clean + Dressing</div>\r\n	</div>\r\n	<div class="pakagediv">\r\n		<div class="pakagediv1">\r\n			Roof</div>\r\n		<div class="pakagediv2">\r\n			:</div>\r\n		<div class="pakagediv3">\r\n			Stain Removal + Dressing</div>\r\n	</div>\r\n	<div class="pakagediv">\r\n		<div class="pakagediv1">\r\n			Trunk</div>\r\n		<div class="pakagediv2">\r\n			:</div>\r\n		<div class="pakagediv3">\r\n			Vacuum + Dust Extraction + Dry Cleaning</div>\r\n	</div>\r\n	<div class="pakagediv">\r\n		<div class="pakagediv1">\r\n			Exterior</div>\r\n		<div class="pakagediv2">\r\n			:</div>\r\n		<div class="pakagediv3">\r\n			2 Stage Polishing</div>\r\n	</div>\r\n	<div class="pakagediv">\r\n		<div class="pakagediv1">\r\n			Exterior</div>\r\n		<div class="pakagediv2">\r\n			:</div>\r\n		<div class="pakagediv3">\r\n			Wash &amp; Wax</div>\r\n	</div>\r\n	<div class="pakagediv">\r\n		<div class="pakagediv1">\r\n			Exterior</div>\r\n		<div class="pakagediv2">\r\n			:</div>\r\n		<div class="pakagediv3">\r\n			Wheel Rim Shine</div>\r\n	</div>\r\n	<div class="pakagediv">\r\n		<div class="pakagediv1">\r\n			Exterior</div>\r\n		<div class="pakagediv2">\r\n			:</div>\r\n		<div class="pakagediv3">\r\n			Tire + Molding + Roof Rubber + Plastic Dressing</div>\r\n	</div>\r\n</div>\r\n<div style="float:left;">\r\n	<img src="images/pakagimage2.jpg" style="border:3px solid #CCC;" /></div><br clear="all">\r\n', '', '', NULL, NULL, 'gold-care-package', NULL, '', '', '', '', '', '', '', '', NULL),
(60, 0, 0, '', '', 'Ultimate Care Package', '', 'Ultimate Care Package', NULL, '<div style="float:left;width:700px;">\r\n<div class="pakagediv">\r\n	<div class="pakagediv1">\r\n		Floor</div>\r\n	<div class="pakagediv2">\r\n		:</div>\r\n	<div class="pakagediv3">\r\n		Vacuum + Dust Extraction + Dry Cleaning</div>\r\n</div>\r\n<div class="pakagediv">\r\n	<div class="pakagediv1">\r\n		Seats</div>\r\n	<div class="pakagediv2">\r\n		:</div>\r\n	<div class="pakagediv3">\r\n		Stain Removal + Dust Extraction + Dry Cleaning + Fabric Protection / Leather Guard</div>\r\n</div>\r\n<div class="pakagediv">\r\n	<div class="pakagediv1">\r\n		Dashboard</div>\r\n	<div class="pakagediv2">\r\n		:</div>\r\n	<div class="pakagediv3">\r\n		Wipe &amp; Clean + Dressing</div>\r\n</div>\r\n<div class="pakagediv">\r\n	<div class="pakagediv1">\r\n		Door Trim</div>\r\n	<div class="pakagediv2">\r\n		:</div>\r\n	<div class="pakagediv3">\r\n		Wipe &amp; Clean + Dressing</div>\r\n</div>\r\n<div class="pakagediv">\r\n	<div class="pakagediv1">\r\n		Roof</div>\r\n	<div class="pakagediv2">\r\n		:</div>\r\n	<div class="pakagediv3">\r\n		Stain Removal + Dressing</div>\r\n</div>\r\n<div class="pakagediv">\r\n	<div class="pakagediv1">\r\n		Trunk</div>\r\n	<div class="pakagediv2">\r\n		:</div>\r\n	<div class="pakagediv3">\r\n		Vacuum + Dust Extraction + Dry Cleaning +Fabric Protection</div>\r\n</div>\r\n<div class="pakagediv">\r\n	<div class="pakagediv1">\r\n		Exterior</div>\r\n	<div class="pakagediv2">\r\n		:</div>\r\n	<div class="pakagediv3">\r\n		Wash &amp; Wax</div>\r\n</div>\r\n<div class="pakagediv">\r\n	<div class="pakagediv1">\r\n		Exterior</div>\r\n	<div class="pakagediv2">\r\n		:</div>\r\n	<div class="pakagediv3">\r\n		Wheel Rim Shine</div>\r\n</div>\r\n<div class="pakagediv">\r\n	<div class="pakagediv1">\r\n		Exterior</div>\r\n	<div class="pakagediv2">\r\n		:</div>\r\n	<div class="pakagediv3">\r\n		Tire + Molding + Roof Rubber + Plastic Dressing &amp; Protection</div>\r\n</div>\r\n<div class="pakagediv">\r\n	<div class="pakagediv1">\r\n		Exterior</div>\r\n	<div class="pakagediv2">\r\n		:</div>\r\n	<div class="pakagediv3">\r\n		Glass Water Resistant Sealant</div>\r\n</div>\r\n<div class="pakagediv">\r\n	<div class="pakagediv1">\r\n		Exterior</div>\r\n	<div class="pakagediv2">\r\n		:</div>\r\n	<div class="pakagediv3">\r\n		Engine Shine</div>\r\n</div>\r\n<div class="pakagediv">\r\n	<div class="pakagediv1">\r\n		Exterior</div>\r\n	<div class="pakagediv2">\r\n		:</div>\r\n	<div class="pakagediv3">\r\n		Overspray Removal</div>\r\n</div></div>\r\n<div style="float:left;"><img src="images/pakagimage3.jpg" style="border:3px solid #CCC;" />\r\n</div><br clear="all">', '', '', NULL, NULL, 'ultimate-care-package', NULL, '', '', '', '', '', '', '', '', NULL),
(61, 0, 0, '', '', 'Paint Protection', '', 'Paint Protection', NULL, '<p style="text-align: justify;">\r\n	3M Paint Protection Film is the latest and most advanced development in car paint protection. This nearly undetectable, urethane paint protective film is designed to protect against impact damage from everyday road hazards such as gravel, debris, stones, road salt, insects, and even minor collisions. 3M paint protection film is an invisible paint protection film that is 8 Mil thick and applied to any painted surface. Our precut patterns are designed to fit any current vehicles&#39; hoods, fenders, mirrors, and bumpers. Clear shield installation commonly takes between 3-5 hours. A clear shield takes 30 days to fully cure. However, you can drive after installation though we recommend that you not wash it for a week. Al-Mullah proudly offers 3M Paint Protection Film, which is the toughest chip protection film on the market, combining excellent elastic properties and optical clarity with a high shear and tack adhesive.</p>\r\n<p style="text-align: justify;">\r\n	<b>3M paint protection film provides twice the stone resistance than the leading competitor and includes: </b></p>\r\n<ul class="linklist">\r\n	<li style="text-align: justify;">\r\n		5 Year Warranty &ndash; Be sure our clear shield is the clearest, strongest paint protection film on the market</li>\r\n	<li style="text-align: justify;">\r\n		Crystal clear, high gloss, non-yellowing urethane paint protection film</li>\r\n	<li style="text-align: justify;">\r\n		Aggressive weather resistant, ultra transparent, acrylic clear shield adhesive</li>\r\n	<li style="text-align: justify;">\r\n		Clings tenaciously, yet removes cleanly without residue from fully cured paint surfaces</li>\r\n	<li style="text-align: justify;">\r\n		Highly resistant to UV rays, oils and chemicals</li>\r\n	<li style="text-align: justify;">\r\n		3M clear shield is virtually invisible and does not alter the aesthetics of your vehicle or factory finish</li>\r\n	<li style="text-align: justify;">\r\n		Protection film preserve resale value of your vehicle</li>\r\n	<li style="text-align: justify;">\r\n		Easy maintenance, treat paint protection film the same as your existing vehicle finish</li>\r\n</ul>\r\n<p style="text-align: justify;">\r\n	<b>Benefits of Paint protection films</b></p>\r\n<ul class="linklist">\r\n	<li style="text-align: justify;">\r\n		Paint Protection Film Protect your vehicle from costly chips, nicks, scratches and scuffs</li>\r\n	<li style="text-align: justify;">\r\n		5 Year Warranty &ndash; the clearest, strongest paint protection film on the market</li>\r\n	<li style="text-align: justify;">\r\n		Crystal clear, high gloss, non-yellowing urethane film</li>\r\n	<li style="text-align: justify;">\r\n		Aggressive weather resistant, ultra transparent, acrylic adhesive</li>\r\n	<li style="text-align: justify;">\r\n		Clings tenaciously, yet removes cleanly without residue from fully cured paint surfaces</li>\r\n	<li style="text-align: justify;">\r\n		Highly resistant to UV rays, oils and chemicals</li>\r\n	<li style="text-align: justify;">\r\n		3M film is virtually invisible and does not alter the esthetics of your vehicle or its factory finish</li>\r\n	<li style="text-align: justify;">\r\n		3M film preserves resale value of your vehicle</li>\r\n	<li style="text-align: justify;">\r\n		Easy maintenance, treat just the same as your existing vehicle finish</li>\r\n	<li style="text-align: justify;">\r\n		Proven in Europe &amp; USA for years and now available in the Kuwait</li>\r\n</ul>\r\n', '', '', NULL, NULL, 'paint-protection', NULL, '', '', '', '', '', '', '', '', NULL),
(62, 0, 0, '', '', 'Solar Window Tint', '', 'Solar Window Tint', NULL, '<p style="text-align: justify;">\r\n	Automobile front windshields are aerodynamically slanted back, allowing direct sunlight into the vehicle, and exposing the skin and eyes of drivers and passengers. Without solar window tint, unwanted solar rays can lead to interior damage, unsafe glare, and even adverse medical effects for passengers. Thankfully, SunTek&reg; Protective Solar Window Tint and UV Window Film has been specifically designed to solve these problems. Our specialized solar window tint allows crystal clear visibility with over 75% visible light transmittance, but blocks 99% of the sun&#39;s harmful, damaging ultraviolet light rays. Solar window tint also provides over 60% heat reduction of the total solar heat energy that enters through your windshield, but without the traditional dark look of tinted glass.</p>\r\n<p style="text-align: justify;">\r\n	SunTek&reg; Car Window Tinting Features &amp; Benefits</p>\r\n<ul class="linklist">\r\n	<li style="text-align: justify;">\r\n		Blocks UV Radiation Reduces up to 99% of the sun&#39;s harmful UV-A and UV-B cancer-causing rays</li>\r\n	<li style="text-align: justify;">\r\n		Increases skin &amp; eye protection</li>\r\n	<li style="text-align: justify;">\r\n		Reduces interior fading and cracking</li>\r\n	<li style="text-align: justify;">\r\n		Prolongs the life of all rubber, wood, cellular phone, audio and speaker systems</li>\r\n</ul>\r\n<p style="text-align: justify;">\r\n	<b>Reduces Heat </b></p>\r\n<ul class="linklist">\r\n	<li style="text-align: justify;">\r\n		Reduces up to 70% of the heat</li>\r\n	<li style="text-align: justify;">\r\n		Increases air-conditioning efficiency</li>\r\n	<li style="text-align: justify;">\r\n		Improves occupant comfort</li>\r\n	<li style="text-align: justify;">\r\n		Reduces Glare &amp; Fatigue</li>\r\n	<li style="text-align: justify;">\r\n		Lessens eye fatigue</li>\r\n	<li style="text-align: justify;">\r\n		Improves vision and safety</li>\r\n	<li style="text-align: justify;">\r\n		Reduces glare and eyestrain for both driver and passengers</li>\r\n</ul>\r\n<p style="text-align: justify;">\r\n	<b>Increased Safety </b></p>\r\n<ul class="linklist">\r\n	<li style="text-align: justify;">\r\n		Provides an extra barrier of protection for increased safety</li>\r\n	<li style="text-align: justify;">\r\n		Increases shatter resistance of glass</li>\r\n	<li style="text-align: justify;">\r\n		Helps hold shattered glass in place and provides increased safety.</li>\r\n</ul>\r\n<p style="text-align: justify;">\r\n	SunTek&reg; solar window tint is also a protective UV window film, providing you and your family complete ultraviolet protection. Solar window tint reduces infrared heat transmissions, increases interior comfort, enhances glare-free lighting, and adds additional safety from premature skin aging and eye conditions. SunTek&reg; Solar Window Tint and UV Window Film can also come with optional shaded protection to reduce bright light, glare, and reflections while driving. Above all other benefits, UV Window Film and Solar Window Tint Protects you and your loved ones from the harmful effects of the sun&#39;s rays. Solar window tint aids in the prevention of skin cancer, light-sensitive migraine headaches, and cataracts.</p>\r\n<p style="text-align: justify;">\r\n	For further information please visit the following link:</p>\r\n<p style="text-align: justify;">\r\n	<a href="http://www.suntekfilms.com/automotive/suntek-window-films-automotive.aspx"> &quot;http://www.suntekfilms.com/automotive/suntek-window-films-automotive.aspx</a></p>\r\n', '', '', NULL, NULL, 'solar-window-tint', NULL, '', '', '', '', '', '', '', '', NULL),
(63, 0, 0, '', '', 'Teflon Coating	', '', 'Teflon Coating	', NULL, '<p style="text-align: justify;">\r\n	How long do you plan to keep you new car? To keep your car new looking and shining like showroom condition for many years &ldquo;Diamond Gloss is for you&rdquo;. Diamond Gloss is not only for keeping your car shinning but also protecting it from harmful factors like scratches, UV fading, debris and bird dropping. No wax or silicon polishes but a new Nano Technology layers covers the complete car paint with Diamond Gloss protection layer.</p>\r\n', '', '', NULL, NULL, 'teflon-coating-', NULL, '', '', '', '', '', '', '', '', NULL),
(64, 0, 0, '', '', 'Exterior and Interior Detailing', '', 'Exterior and Interior Detailing', NULL, '<p style="text-align: justify;">\r\n	Detailing Exterior Detailing with Liquid Glass Liquid Glass Vehicle Sealant package offers everything you need to protect after exterior detailing by using advanced technology to create a brilliant shine and provide durable, long lasting protection from the elements. When left unprotected; UV Rays, acid rain, hard water, tree sap, and industrial fallout will deteriorate your paint&rsquo;s finish and vehicle&rsquo;s value. Liquid Glass exterior detailing will help create and preserve a high gloss appearance with no need for consumer reapplication. When protected with Liquid Glass, vehicles maintain that &ldquo;Showroom New&rdquo; finish and retain resale value. Get the most out of exterior detailing, and let Al-Mullah&rsquo;s specialists give your vehicle the new car shine with our Liquid Glass Paint Shield!</p>\r\n', '', '', NULL, NULL, 'exterior-and-interior-detailing', NULL, '', '', '', '', '', '', '', '', NULL);

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

--
-- Table structure for table `perrrsons`
--

CREATE TABLE IF NOT EXISTS `perrrsons` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `LastName` varchar(255) NOT NULL,
  `FirstName` varchar(255) DEFAULT NULL,
  `Address` varchar(255) DEFAULT NULL,
  `City` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `persons`
--

CREATE TABLE IF NOT EXISTS `persons` (
  `PersonID` int(11) DEFAULT NULL,
  `LastName` varchar(255) DEFAULT NULL,
  `FirstName` varchar(255) DEFAULT NULL,
  `Address` varchar(255) DEFAULT NULL,
  `City` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `personsee`
--

CREATE TABLE IF NOT EXISTS `personsee` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `LastName` varchar(255) NOT NULL,
  `FirstName` varchar(255) DEFAULT NULL,
  `Address` varchar(255) DEFAULT NULL,
  `City` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `photos`
--

CREATE TABLE IF NOT EXISTS `photos` (
  `photo_id` int(11) NOT NULL AUTO_INCREMENT,
  `photo_cat_id` int(11) NOT NULL,
  `photo_caption` varchar(50) NOT NULL,
  `photo_ar_caption` varchar(50) NOT NULL,
  `photo_file` varchar(255) NOT NULL,
  `photo_desc` blob NOT NULL,
  PRIMARY KEY (`photo_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;

--
-- Dumping data for table `photos`
--

INSERT INTO `photos` (`photo_id`, `photo_cat_id`, `photo_caption`, `photo_ar_caption`, `photo_file`, `photo_desc`) VALUES
(14, 6, '', '', 'images.jpg', ''),
(15, 6, '', '', 'images1.jpg', '');

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

--
-- Table structure for table `photo_cat`
--

CREATE TABLE IF NOT EXISTS `photo_cat` (
  `photo_cat_id` int(11) NOT NULL AUTO_INCREMENT,
  `photo_cat_name` varchar(255) NOT NULL,
  `photo_cat_ar_name` varchar(255) NOT NULL,
  `photo_cat_img` varchar(255) NOT NULL,
  PRIMARY KEY (`photo_cat_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `photo_cat`
--

INSERT INTO `photo_cat` (`photo_cat_id`, `photo_cat_name`, `photo_cat_ar_name`, `photo_cat_img`) VALUES
(6, 'test', 'dfdsf', 'images.jpg');

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

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

CREATE TABLE IF NOT EXISTS `products` (
  `product_id` int(11) NOT NULL AUTO_INCREMENT,
  `cat_id` int(11) NOT NULL,
  `product_name` varchar(150) NOT NULL,
  `product_ar_name` varchar(150) NOT NULL,
  `product_description` blob NOT NULL,
  `product_ar_description` blob NOT NULL,
  `price` float NOT NULL,
  `image` varchar(150) NOT NULL,
  `status` varchar(10) NOT NULL DEFAULT 'on',
  PRIMARY KEY (`product_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=284 ;

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

INSERT INTO `products` (`product_id`, `cat_id`, `product_name`, `product_ar_name`, `product_description`, `product_ar_description`, `price`, `image`, `status`) VALUES
(266, 50, 'continental1', '', '', '', 1.5, 'conti1.jpg', 'on'),
(260, 46, 'arabic1', '', '', '', 1.2, 'arabia14.jpg', 'on'),
(259, 46, 'arabic2', '', '', '', 1.6, 'arab2.jpg', 'on'),
(258, 46, 'arabic3', '', '', '', 1.5, 'arab.jpg', 'on'),
(257, 46, 'arabic4', '', '', '', 1.3, 'arab4.jpg', 'on'),
(262, 47, 'italian1', '', '', '', 0.05, 'italia.jpg', 'on'),
(263, 47, 'italian2', '', '', '', 1.6, 'italy2.jpg', 'on'),
(264, 47, 'italian3', '', '', '', 1.25, 'italian.jpg', 'on'),
(265, 47, 'italian4', '', '', '', 1.5, '18870_2_deal.jpg', 'on'),
(281, 50, 'continental3', '', '', '', 1.45, 'conti3.jpg', 'on'),
(267, 50, 'continental2', '', '', '', 1.95, 'conti2.jpg', 'on'),
(268, 51, 'pinoy1', '', '', '', 1.5, 'tumblr_m84vzj0Iky1rceknso1_500.jpg', 'on'),
(269, 51, 'pinoy2', '', '', '', 1.9, 'hqdefault.jpg', 'on'),
(270, 51, 'pinoy3', '', '', '', 1.65, 'tumblr_m84w9j45Yv1rceknso1_500.jpg', 'on'),
(271, 51, 'pinoy4', '', '', '', 1.456, 'pinoy.jpg', 'on'),
(272, 51, 'pinoy5', '', '', '', 1.25, 'chicken-adobo.jpg', 'on'),
(273, 48, 'indian1', '', '', '', 1.35, 'C_f28f24b4954d27b0ad95fc842e840145.jpg', 'on'),
(274, 48, 'indian2', '', '', '', 1.45, 'south-indian-food.jpg', 'on'),
(275, 48, 'indian3', '', '', '', 1.56, 'indian-food2.jpg', 'on'),
(276, 49, 'chinese1', '', '', '', 1.89, 'thumb.jpg', 'on'),
(277, 49, 'chinese2', '', '', '', 2.2, 'indo3.jpg', 'on'),
(278, 49, 'chinese3', '', '', '', 1.56, '3550984_370.jpg', 'on'),
(279, 49, 'chinese4', '', '', '', 1.6, 'chinese-food-street.jpg', 'on'),
(280, 49, 'chinese5', '', '', '', 0.95, 'chinese1.jpg', 'on'),
(283, 46, 'arabic5', 'arabic5arabic', '', '', 1.3, 'arab4.jpg', 'on');

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

--
-- Table structure for table `product_cat`
--

CREATE TABLE IF NOT EXISTS `product_cat` (
  `product_cat_id` int(11) NOT NULL AUTO_INCREMENT,
  `product_cat_name` varchar(255) NOT NULL,
  `product_ar_cat_name` varchar(255) NOT NULL,
  `product_cat_img` varchar(240) NOT NULL,
  `product_description` blob NOT NULL,
  `product_ar_description` blob NOT NULL,
  `status` varchar(20) NOT NULL DEFAULT 'on',
  PRIMARY KEY (`product_cat_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=53 ;

--
-- Dumping data for table `product_cat`
--

INSERT INTO `product_cat` (`product_cat_id`, `product_cat_name`, `product_ar_cat_name`, `product_cat_img`, `product_description`, `product_ar_description`, `status`) VALUES
(49, 'Chinese', 'الصينية', 'chow_mein.jpg', '', '', 'on'),
(50, 'Continental', 'قاري', '209117_600_430.jpg', '', '', 'on'),
(48, 'Indian', 'هندي', 'ghee_recipes.jpg', '', '', 'on'),
(47, 'Italian', 'الإيطالي', 'Italian-Pizza.jpg', '', '', 'on'),
(46, 'Arabic', 'العربية', '3.jpg', '', '', 'on'),
(51, 'Pinoy', 'بينوي', 'tumblr_mbmy58og0s1rceknso1_500.jpg', '', '', 'on');

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

--
-- Table structure for table `purchaseorder`
--

CREATE TABLE IF NOT EXISTS `purchaseorder` (
  `order_id` int(11) NOT NULL AUTO_INCREMENT,
  `memberid` int(11) NOT NULL,
  `memberName` varchar(50) NOT NULL,
  `emailId` varchar(200) NOT NULL,
  `order_no` int(11) NOT NULL,
  `order_staus` varchar(10) NOT NULL,
  `order_desc` varchar(500) NOT NULL,
  `order_date` date NOT NULL,
  `order_completion` date NOT NULL,
  `remark` varchar(500) NOT NULL,
  `status` varchar(10) NOT NULL DEFAULT 'on',
  PRIMARY KEY (`order_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `purchaseorder`
--

INSERT INTO `purchaseorder` (`order_id`, `memberid`, `memberName`, `emailId`, `order_no`, `order_staus`, `order_desc`, `order_date`, `order_completion`, `remark`, `status`) VALUES
(5, 27, 'Robert', 'robert@utis-kw.com,shibu@utis-kw.com', 101010, 'deliverd', 'wait klll', '2011-02-14', '2011-10-25', 'jkjsaajjajssjajs', 'off');

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

--
-- Table structure for table `settings`
--

CREATE TABLE IF NOT EXISTS `settings` (
  `set_id` int(11) NOT NULL AUTO_INCREMENT,
  `set_title` varchar(100) DEFAULT NULL COMMENT 'site name, common title etc',
  `set_key` varchar(100) NOT NULL COMMENT 'meta key',
  `set_desc` varchar(100) NOT NULL COMMENT 'meta description',
  `set_username` varchar(10) DEFAULT 'admin' COMMENT 'admin side login name',
  `set_password` varchar(100) DEFAULT NULL COMMENT 'admin side password',
  `set_email` varchar(30) DEFAULT NULL COMMENT 'email id for mail transfer',
  `set_phone` varchar(100) DEFAULT NULL COMMENT 'phone no.',
  `set_logo` varchar(100) DEFAULT NULL COMMENT 'logo pic file name',
  PRIMARY KEY (`set_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`set_id`, `set_title`, `set_key`, `set_desc`, `set_username`, `set_password`, `set_email`, `set_phone`, `set_logo`) VALUES
(1, 'CMS', 'keys', 'descriptions', 'admin', '123', '', NULL, NULL);

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

--
-- Table structure for table `userregister`
--

CREATE TABLE IF NOT EXISTS `userregister` (
  `reg_id` int(11) NOT NULL AUTO_INCREMENT,
  `reg_firstname` varchar(250) NOT NULL,
  `reg_lastname` varchar(250) NOT NULL,
  `reg_address` blob NOT NULL,
  `reg_mail` varchar(100) NOT NULL,
  `reg_pwd` varchar(100) NOT NULL,
  `reg_mobile` int(11) NOT NULL,
  `reg_land` int(11) NOT NULL,
  PRIMARY KEY (`reg_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;

--
-- Dumping data for table `userregister`
--

INSERT INTO `userregister` (`reg_id`, `reg_firstname`, `reg_lastname`, `reg_address`, `reg_mail`, `reg_pwd`, `reg_mobile`, `reg_land`) VALUES
(14, 'q', '', '', 'q@gmail.com', 'q', 23232, 22),
(15, 'q', '', '', 'q@gmail.com', '1', 1, 2),
(16, 'sashi', 's', '', 'sashi@gmail.com', 'sashi', 3523525, 43343),
(17, 'saju', '', 0x776573742065617374207361756469, 'saju@gmail.com', 'saju123', 2147483647, 3454534),
(18, 'ravi', 'kumar', 0x723474726567646667646173, 'q@gmail.com', 'qwerty', 343434, 43443),
(19, 'dfdfz', 'dzfdsf', 0x73646667647666676476, 'zdfdzf@gmail.com', 'sfsdfs', 34345, 345345),
(20, 'ameenulla', 'qw', 0x6566, 'q@gmail.com', 'q', 35, 342);

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

--
-- Table structure for table `video`
--

CREATE TABLE IF NOT EXISTS `video` (
  `video_id` int(11) NOT NULL AUTO_INCREMENT,
  `video_cat` varchar(20) NOT NULL,
  `video_sub` varchar(50) NOT NULL,
  `video_status` varchar(50) NOT NULL,
  `video_caption` varchar(100) CHARACTER SET latin1 COLLATE latin1_spanish_ci NOT NULL,
  `video_file` varchar(200) NOT NULL,
  `video_desc` text NOT NULL,
  `video_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`video_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

