|
Server IP : 103.53.40.154 / Your IP : 18.118.119.77 Web Server : Apache System : Linux md-in-35.webhostbox.net 4.19.286-203.ELK.el7.x86_64 #1 SMP Wed Jun 14 04:33:55 CDT 2023 x86_64 User : ppcad7no ( 715) PHP Version : 8.2.25 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0750) : /home2/ppcad7no/brmarketingindia.com/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 14, 2017 at 11:53 AM
-- 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: `tki_supertemplate`
--
-- --------------------------------------------------------
--
-- Table structure for table `tbl_admin`
--
CREATE TABLE IF NOT EXISTS `tbl_admin` (
`admin_id` int(11) NOT NULL AUTO_INCREMENT,
`admin_user_type` varchar(50) NOT NULL,
`admin_access` varchar(500) NOT NULL,
`admin_userid` varchar(70) NOT NULL,
`admin_password` varchar(70) NOT NULL,
`admin_company_name` varchar(150) NOT NULL,
`admin_name` varchar(100) NOT NULL,
`admin_email` varchar(100) NOT NULL,
`admin_alt_email` varchar(100) NOT NULL,
`admin_mobile` varchar(50) NOT NULL,
`admin_phone` varchar(50) NOT NULL,
`admin_fax` varchar(50) NOT NULL,
`admin_address` varchar(200) NOT NULL,
`admin_city` varchar(70) NOT NULL,
`admin_state` varchar(50) NOT NULL,
`admin_country` varchar(50) NOT NULL,
`admin_zip_code` varchar(20) NOT NULL,
`admin_website_url` varchar(200) NOT NULL,
`admin_catalog_url` varchar(100) NOT NULL,
`admin_language_option` enum('Yes','No') NOT NULL DEFAULT 'No',
`admin_visitor_counter_option` enum('Yes','No') NOT NULL,
`admin_search_option` enum('Yes','No') NOT NULL,
`admin_video_option` enum('Yes','No') NOT NULL DEFAULT 'No',
`admin_etrust_option` enum('Yes','No') NOT NULL DEFAULT 'No',
`admin_etrust_link` varchar(300) NOT NULL,
`admin_quick_enq_option` enum('Yes','No') NOT NULL DEFAULT 'No',
`admin_product_option` enum('Yes','No') NOT NULL DEFAULT 'Yes',
`admin_flipbook_option` enum('Yes','No') NOT NULL DEFAULT 'No',
`admin_facebook_link` varchar(150) NOT NULL,
`admin_twitter_link` varchar(150) NOT NULL,
`admin_gplus_link` varchar(150) NOT NULL,
`admin_linkedin_link` varchar(150) NOT NULL,
`admin_youtube_link` varchar(500) NOT NULL,
`admin_all_right_reserved` varchar(100) NOT NULL,
`admin_website_design_by` varchar(100) NOT NULL,
`admin_contactus_map` enum('Yes','No') NOT NULL DEFAULT 'No',
`admin_contactus_map_link` text NOT NULL,
`admin_site_down` enum('Yes','No') NOT NULL DEFAULT 'No',
`admin_site_down_message` varchar(200) NOT NULL,
`admin_copyright` varchar(20) NOT NULL,
`admin_member_of` varchar(100) NOT NULL,
`admin_keyword` varchar(50) NOT NULL,
`admin_keyword_link` varchar(150) NOT NULL,
`admin_is_meta_fb_id` varchar(10) NOT NULL,
`admin_is_meta_alexa_id` varchar(10) NOT NULL,
`admin_is_meta_msvalidate_id` varchar(10) NOT NULL,
`admin_index_follow` varchar(20) NOT NULL,
`admin_meta_fb_id` varchar(100) NOT NULL,
`admin_meta_alexa_id` varchar(100) NOT NULL,
`admin_meta_msvalidate_id` varchar(100) NOT NULL,
`admin_site_verification_code` varchar(200) NOT NULL,
`admin_google_analytic_code` varchar(1000) NOT NULL,
`admin_add_date` date NOT NULL,
`admin_status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
PRIMARY KEY (`admin_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;
--
-- Dumping data for table `tbl_admin`
--
INSERT INTO `tbl_admin` (`admin_id`, `admin_user_type`, `admin_access`, `admin_userid`, `admin_password`, `admin_company_name`, `admin_name`, `admin_email`, `admin_alt_email`, `admin_mobile`, `admin_phone`, `admin_fax`, `admin_address`, `admin_city`, `admin_state`, `admin_country`, `admin_zip_code`, `admin_website_url`, `admin_catalog_url`, `admin_language_option`, `admin_visitor_counter_option`, `admin_search_option`, `admin_video_option`, `admin_etrust_option`, `admin_etrust_link`, `admin_quick_enq_option`, `admin_product_option`, `admin_flipbook_option`, `admin_facebook_link`, `admin_twitter_link`, `admin_gplus_link`, `admin_linkedin_link`, `admin_youtube_link`, `admin_all_right_reserved`, `admin_website_design_by`, `admin_contactus_map`, `admin_contactus_map_link`, `admin_site_down`, `admin_site_down_message`, `admin_copyright`, `admin_member_of`, `admin_keyword`, `admin_keyword_link`, `admin_is_meta_fb_id`, `admin_is_meta_alexa_id`, `admin_is_meta_msvalidate_id`, `admin_index_follow`, `admin_meta_fb_id`, `admin_meta_alexa_id`, `admin_meta_msvalidate_id`, `admin_site_verification_code`, `admin_google_analytic_code`, `admin_add_date`, `admin_status`) VALUES
(1, 'Admin', '', 'resadmin', 'resadmin', 'TradeKeyIndia', 'TradeKeyIndia', 'TradeKeyIndia@gmail.com', 'TradeKeyIndia2@gmail.com', '+91- 9096896763, 9096896763', '11111111', '', 'WebKeyNetwork', 'New Delhi', 'Delhi', 'India', '111111', 'http://localhost/wkIRES14_yellow/', 'http://www.tradekeyindia.com/race-elevator/', '', '', '', '', '', '', 'No', 'Yes', '', 'https://www.facebook.com/b2b.tradekeyindia', 'https://twitter.com/tradekeyindia', 'https://plus.google.com/+tradekeyindiacom/posts', 'http://in.linkedin.com/in/b2btradekeyindia', '', 'WebKeyIndia', '', 'No', '', 'No', '', '2016-2017', 'Tradekeyindia.com', 'B2B Portal in india', 'http://www.tradekeyindia.com', '', '', '', '', '', '', '', '', '', '2014-12-19', 'Active');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_category`
--
CREATE TABLE IF NOT EXISTS `tbl_category` (
`category_id` int(11) NOT NULL AUTO_INCREMENT,
`category_parent_id` int(11) NOT NULL,
`category_name` varchar(100) NOT NULL,
`category_image_name` varchar(100) NOT NULL,
`category_description` text NOT NULL,
`category_is_hot` enum('Yes','No') NOT NULL DEFAULT 'No',
`category_is_featured` enum('Yes','No') NOT NULL DEFAULT 'No',
`category_for_falsh` enum('Yes','No') NOT NULL DEFAULT 'No',
`category_for_gallery` enum('Yes','No') NOT NULL DEFAULT 'Yes',
`category_meta_title` varchar(200) NOT NULL,
`category_meta_description` varchar(300) NOT NULL,
`category_meta_keywords` varchar(500) NOT NULL,
`category_is_product` enum('Yes','No') NOT NULL DEFAULT 'No',
`category_url` varchar(100) NOT NULL,
`category_order_by` varchar(10) NOT NULL,
`category_add_date` date NOT NULL,
`category_status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
PRIMARY KEY (`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ;
--
-- Dumping data for table `tbl_category`
--
-- --------------------------------------------------------
--
-- Table structure for table `tbl_category_image`
--
CREATE TABLE IF NOT EXISTS `tbl_category_image` (
`category_image_id` int(11) NOT NULL AUTO_INCREMENT,
`category_image_cat_id` int(11) NOT NULL,
`category_image_name` varchar(150) NOT NULL,
`category_image_title` varchar(100) NOT NULL,
`category_image_add_date` date NOT NULL,
`category_image_status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
PRIMARY KEY (`category_image_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=89 ;
--
-- Dumping data for table `tbl_category_image`
--
-- --------------------------------------------------------
--
-- Table structure for table `tbl_certificate`
--
CREATE TABLE IF NOT EXISTS `tbl_certificate` (
`certificate_id` int(11) NOT NULL AUTO_INCREMENT,
`certificate_image_name` varchar(100) NOT NULL,
`certificate_add_date` date NOT NULL,
`certificate_status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
PRIMARY KEY (`certificate_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=33 ;
--
-- Dumping data for table `tbl_certificate`
--
-- --------------------------------------------------------
--
-- Table structure for table `tbl_client_logo`
--
CREATE TABLE IF NOT EXISTS `tbl_client_logo` (
`client_logo_id` int(11) NOT NULL AUTO_INCREMENT,
`client_logo_image_name` varchar(100) NOT NULL,
`client_logo_add_date` date NOT NULL,
`client_logo_status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
PRIMARY KEY (`client_logo_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;
--
-- Dumping data for table `tbl_client_logo`
--
-- --------------------------------------------------------
--
-- Table structure for table `tbl_country`
--
CREATE TABLE IF NOT EXISTS `tbl_country` (
`country_id` int(11) NOT NULL AUTO_INCREMENT,
`country_code` varchar(10) DEFAULT NULL,
`country_name` varchar(100) DEFAULT NULL,
`country_status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
PRIMARY KEY (`country_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=236 ;
--
-- Dumping data for table `tbl_country`
--
INSERT INTO `tbl_country` (`country_id`, `country_code`, `country_name`, `country_status`) VALUES
(1, '+93', 'Afghanistan', 'Active'),
(2, '+355', 'Albania', 'Active'),
(3, '+213', 'Algeria', 'Active'),
(4, '+684', 'American Samoa', 'Active'),
(5, '+376', 'Andorra', 'Active'),
(6, '+244', 'Angola', 'Active'),
(7, '+264', 'Anguilla', 'Active'),
(8, 'AQ', 'Antarctica', 'Active'),
(9, '+268', 'Antigua and Barbuda', 'Active'),
(10, '+54', 'Argentina', 'Active'),
(11, '+374', 'Armenia', 'Active'),
(12, '+297', 'Aruba', 'Active'),
(13, '+61', 'Australia', 'Active'),
(14, '+43', 'Austria', 'Active'),
(15, '+994', 'Azerbaijan', 'Active'),
(16, '+242', 'Bahamas', 'Active'),
(17, '+973', 'Bahrain', 'Active'),
(18, '+880', 'Bangladesh', 'Active'),
(19, '+246', 'Barbados', 'Active'),
(20, '+375', 'Belarus', 'Active'),
(21, '+32', 'Belgium', 'Active'),
(22, '+501', 'Belize', 'Active'),
(23, '+229', 'Benin', 'Active'),
(24, '+441', 'Bermuda', 'Active'),
(25, '+975', 'Bhutan', 'Active'),
(26, '+591', 'Bolivia', 'Active'),
(27, '+387', 'Bosnia and Herzegowina', 'Active'),
(28, '+267', 'Botswana', 'Active'),
(29, 'BV', 'Bouvet Island', 'Active'),
(30, '+55', 'Brazil', 'Active'),
(31, '+246', 'British Indian Ocean Territory', 'Active'),
(32, '+673', 'Brunei Darussalam', 'Active'),
(33, '+359', 'Bulgaria', 'Active'),
(34, '+226', 'Burkina Faso', 'Active'),
(35, '+257', 'Burundi', 'Active'),
(36, '+855', 'Cambodia', 'Active'),
(37, '+237', 'Cameroon', 'Active'),
(38, '+1', 'Canada', 'Active'),
(39, '+238', 'Cape Verde', 'Active'),
(40, '+238', 'Cayman Islands', 'Active'),
(41, '+236', 'Central African Republic', 'Active'),
(42, '+235', 'Chad', 'Active'),
(43, '+56', 'Chile', 'Active'),
(44, '+86', 'China', 'Active'),
(45, '+61', 'Christmas Island', 'Active'),
(46, '+891', 'Cocos (Keeling) Islands', 'Active'),
(47, '+57', 'Colombia', 'Active'),
(48, '+269', 'Comoros', 'Active'),
(49, '+242', 'Congo', 'Active'),
(50, '+682', 'Cook Islands', 'Active'),
(51, '+506', 'Costa Rica', 'Active'),
(52, '+385', 'Croatia (local name: Hrvatska)', 'Active'),
(53, '+53', 'Cuba', 'Active'),
(54, '+357', 'Cyprus', 'Active'),
(55, '+420', 'Czech Republic', 'Active'),
(56, '+45', 'Denmark', 'Active'),
(57, '+253', 'Djibouti', 'Active'),
(58, '+767', 'Dominica', 'Active'),
(59, '+849', 'Dominican Republic', 'Active'),
(60, '+670', 'East Timor', 'Active'),
(61, '+593', 'Ecuador', 'Active'),
(62, '+20', 'Egypt', 'Active'),
(63, '+503', 'El Salvador', 'Active'),
(64, '+240', 'Equatorial Guinea', 'Active'),
(65, '+291', 'Eritrea', 'Active'),
(66, '+372', 'Estonia', 'Active'),
(67, '+251', 'Ethiopia', 'Active'),
(68, 'FK', 'Falkland Islands (Malvinas)', 'Active'),
(69, '+298', 'Faroe Islands', 'Active'),
(70, '+679', 'Fiji', 'Active'),
(71, '+358', 'Finland', 'Active'),
(72, '+33', 'France', 'Active'),
(73, '+3166', 'France Metropolitan', 'Active'),
(74, 'GF', 'French Guiana', 'Active'),
(75, '+689', 'French Polynesia', 'Active'),
(76, 'TF', 'French Southern Territories', 'Active'),
(77, '+241', 'Gabon', 'Active'),
(78, '+220', 'Gambia', 'Active'),
(79, '+995', 'Georgia', 'Active'),
(80, '+49', 'Germany', 'Active'),
(81, '+233', 'Ghana', 'Active'),
(82, '+350', 'Gibraltar', 'Active'),
(83, '+30', 'Greece', 'Active'),
(84, '+299', 'Greenland', 'Active'),
(85, '+473', 'Grenada', 'Active'),
(86, 'GP', 'Guadeloupe', 'Active'),
(87, '+671', 'Guam', 'Active'),
(88, '+502', 'Guatemala', 'Active'),
(89, '+224', 'Guinea', 'Active'),
(90, '+245', 'Guinea-Bissau', 'Active'),
(91, '+592', 'Guyana', 'Active'),
(92, '+509', 'Haiti', 'Active'),
(93, 'HM', 'Heard and Mc Donald Islands', 'Active'),
(94, '+504', 'Honduras', 'Active'),
(95, '+852', 'Hong Kong', 'Active'),
(96, '+36', 'Hungary', 'Active'),
(97, '+354', 'Iceland', 'Active'),
(98, '+91', 'India', 'Active'),
(99, '+62', 'Indonesia', 'Active'),
(100, 'IR', 'Iran (Islamic Republic of)', 'Active'),
(101, '+964', 'Iraq', 'Active'),
(102, '+353', 'Ireland', 'Active'),
(103, '+972', 'Israel', 'Active'),
(104, '+39', 'Italy', 'Active'),
(105, '+876', 'Jamaica', 'Active'),
(106, '+81', 'Japan', 'Active'),
(107, '+962', 'Jordan', 'Active'),
(108, '+7', 'Kazakhstan', 'Active'),
(109, '+254', 'Kenya', 'Active'),
(110, '+686', 'Kiribati', 'Active'),
(111, '+965', 'Kuwait', 'Active'),
(112, '+996', 'Kyrgyzstan', 'Active'),
(113, '+371', 'Latvia', 'Active'),
(114, '+961', 'Lebanon', 'Active'),
(115, '+266', 'Lesotho', 'Active'),
(116, '+231', 'Liberia', 'Active'),
(117, '+218', 'Libyan Arab Jamahiriya', 'Active'),
(118, '+423', 'Liechtenstein', 'Active'),
(119, '+370', 'Lithuania', 'Active'),
(120, '+352', 'Luxembourg', 'Active'),
(121, '+853', 'Macao', 'Active'),
(122, '+389', 'Macedonia', 'Active'),
(123, '+261', 'Madagascar', 'Active'),
(124, '+265', 'Malawi', 'Active'),
(125, '+60', 'Malaysia', 'Active'),
(126, '+960', 'Maldives', 'Active'),
(127, '+223', 'Mali', 'Active'),
(128, '+356', 'Malta', 'Active'),
(129, '+692', 'Marshall Islands', 'Active'),
(130, '+596', 'Martinique', 'Active'),
(131, '+222', 'Mauritania', 'Active'),
(132, '+230', 'Mauritius', 'Active'),
(133, '+262', 'Mayotte', 'Active'),
(134, '+52', 'Mexico', 'Active'),
(135, '+691', 'Micronesia', 'Active'),
(136, '+373', 'Moldova', 'Active'),
(137, '+377', 'Monaco', 'Active'),
(138, '+976', 'Mongolia', 'Active'),
(139, '+664', 'Montserrat', 'Active'),
(140, '+212', 'Morocco', 'Active'),
(141, '+258', 'Mozambique', 'Active'),
(142, '+95', 'Myanmar', 'Active'),
(143, '+264', 'Namibia', 'Active'),
(144, '+674', 'Nauru', 'Active'),
(145, '+977', 'Nepal', 'Active'),
(146, 'NL', 'Netherlands', 'Active'),
(147, '+599', 'Netherlands Antilles', 'Active'),
(148, '+687', 'New Caledonia', 'Active'),
(149, '+64', 'New Zealand', 'Active'),
(150, '+505', 'Nicaragua', 'Active'),
(151, '+227', 'Niger', 'Active'),
(152, '+234', 'Nigeria', 'Active'),
(153, '+683', 'Niue', 'Active'),
(154, '+672', 'Norfolk Island', 'Active'),
(155, '+850', 'North Korea', 'Active'),
(156, '+670', 'Northern Mariana Islands', 'Active'),
(157, '+47', 'Norway', 'Active'),
(158, '+968', 'Oman', 'Active'),
(159, '+92', 'Pakistan', 'Active'),
(160, '+680', 'Palau', 'Active'),
(161, '+507', 'Panama', 'Active'),
(162, '+675', 'Papua New Guinea', 'Active'),
(163, '+595', 'Paraguay', 'Active'),
(164, '+51', 'Peru', 'Active'),
(165, '+63', 'Philippines', 'Active'),
(166, '+870', 'Pitcairn', 'Active'),
(167, '+48', 'Poland', 'Active'),
(168, '+351', 'Portugal', 'Active'),
(169, 'PR', 'Puerto Rico', 'Active'),
(170, '+974', 'Qatar', 'Active'),
(171, 'RE', 'Reunion', 'Active'),
(172, '+40', 'Romania', 'Active'),
(173, '+7', 'Russian Federation', 'Active'),
(174, '+250', 'Rwanda', 'Active'),
(175, '+869', 'Saint Kitts and Nevis', 'Active'),
(176, '+758', 'Saint Lucia', 'Active'),
(177, '+784', 'Saint Vincent and the Grenadines', 'Active'),
(178, '+685', 'Samoa', 'Active'),
(179, '+378', 'San Marino', 'Active'),
(180, '+239', 'Sao Tome and Principe', 'Active'),
(181, '+966', 'Saudi Arabia', 'Active'),
(182, '+221', 'Senegal', 'Active'),
(183, '+248', 'Seychelles', 'Active'),
(184, '+232', 'Sierra Leone', 'Active'),
(185, '+65', 'Singapore', 'Active'),
(186, '+421', 'Slovakia (Slovak Republic)', 'Active'),
(187, '+386', 'Slovenia', 'Active'),
(188, '+677', 'Solomon Islands', 'Active'),
(189, '+252', 'Somalia', 'Active'),
(190, '+27', 'South Africa', 'Active'),
(191, '+82', 'South Korea', 'Active'),
(192, '+34', 'Spain', 'Active'),
(193, '+94', 'Sri Lanka', 'Active'),
(194, '+290', 'St. Helena', 'Active'),
(195, '+508', 'St. Pierre and Miquelon', 'Active'),
(196, '+249', 'Sudan', 'Active'),
(197, '+597', 'Suriname', 'Active'),
(198, 'SJ', 'Svalbard and Jan Mayen Islands', 'Active'),
(199, '+268', 'Swaziland', 'Active'),
(200, '+46', 'Sweden', 'Active'),
(201, '+41', 'Switzerland', 'Active'),
(202, '+963', 'Syrian Arab Republic', 'Active'),
(203, '+886', 'Taiwan', 'Active'),
(204, '+992', 'Tajikistan', 'Active'),
(205, '+255', 'Tanzania', 'Active'),
(206, '+66', 'Thailand', 'Active'),
(207, '+228', 'Togo', 'Active'),
(208, '+690', 'Tokelau', 'Active'),
(209, '+676', 'Tonga', 'Active'),
(210, '+868', 'Trinidad and Tobago', 'Active'),
(211, '+216', 'Tunisia', 'Active'),
(212, '+90', 'Turkey', 'Active'),
(213, '+993', 'Turkmenistan', 'Active'),
(214, '+649', 'Turks and Caicos Islands', 'Active'),
(215, '+688', 'Tuvalu', 'Active'),
(216, '+256', 'Uganda', 'Active'),
(217, '+380', 'Ukraine', 'Active'),
(218, '+971', 'United Arab Emirates', 'Active'),
(219, '+44', 'United Kingdom', 'Active'),
(220, '+1', 'United States', 'Active'),
(221, '+598', 'Uruguay', 'Active'),
(222, '+998', 'Uzbekistan', 'Active'),
(223, '+678', 'Vanuatu', 'Active'),
(224, 'VA', 'Vatican City State (Holy See)', 'Active'),
(225, '+58', 'Venezuela', 'Active'),
(226, '+84', 'Vietnam', 'Active'),
(227, '+284', 'Virgin Islands (British)', 'Active'),
(228, '+340', 'Virgin Islands (U.S.)', 'Active'),
(229, '+681', 'Wallis And Futuna Islands', 'Active'),
(230, '+212', 'Western Sahara', 'Active'),
(231, '+967', 'Yemen', 'Active'),
(232, '+38', 'Yugoslavia', 'Active'),
(233, '+260', 'Zambia', 'Active'),
(234, '+263', 'Zimbabwe', 'Active'),
(235, 'OT', 'Other Country', 'Active');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_enquiry`
--
CREATE TABLE IF NOT EXISTS `tbl_enquiry` (
`enquiry_id` int(11) NOT NULL AUTO_INCREMENT,
`enquiry_name` varchar(100) NOT NULL,
`enquiry_comp_name` varchar(100) NOT NULL,
`enquiry_mobile` varchar(50) NOT NULL,
`enquiry_email` varchar(100) NOT NULL,
`enquiry_address` varchar(200) NOT NULL,
`enquiry_subject` varchar(100) NOT NULL,
`enquiry_detail` varchar(400) NOT NULL,
`enquiry_source` varchar(50) NOT NULL,
`enquiry_add_date` date NOT NULL,
`enquiry_status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
PRIMARY KEY (`enquiry_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=49 ;
--
-- Dumping data for table `tbl_enquiry`
--
-- --------------------------------------------------------
--
-- Table structure for table `tbl_gallery`
--
CREATE TABLE IF NOT EXISTS `tbl_gallery` (
`gallery_id` int(11) NOT NULL AUTO_INCREMENT,
`gallery_image_name` varchar(100) NOT NULL,
`gallery_image_title` varchar(150) NOT NULL,
`gallery_add_date` date NOT NULL,
`gallery_status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
PRIMARY KEY (`gallery_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=81 ;
--
-- Dumping data for table `tbl_gallery`
--
-- --------------------------------------------------------
--
-- Table structure for table `tbl_header`
--
CREATE TABLE IF NOT EXISTS `tbl_header` (
`header_id` int(11) NOT NULL AUTO_INCREMENT,
`header_logo` varchar(100) NOT NULL,
`header_welcome_image` varchar(100) NOT NULL,
`header_add_date` date NOT NULL,
`header_status` enum('Active','Inactive') NOT NULL,
PRIMARY KEY (`header_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `tbl_header`
--
-- --------------------------------------------------------
--
-- Table structure for table `tbl_header_flash`
--
CREATE TABLE IF NOT EXISTS `tbl_header_flash` (
`header_flash_id` int(11) NOT NULL AUTO_INCREMENT,
`header_flash_image_name` varchar(100) NOT NULL,
`header_flash_title` varchar(100) NOT NULL,
`header_flash_type` varchar(50) NOT NULL,
`header_flash_add_date` date NOT NULL,
`header_flash_status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
PRIMARY KEY (`header_flash_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=77 ;
--
-- Dumping data for table `tbl_header_flash`
--
-- --------------------------------------------------------
--
-- Table structure for table `tbl_job_opening`
--
CREATE TABLE IF NOT EXISTS `tbl_job_opening` (
`job_opening_id` int(11) NOT NULL AUTO_INCREMENT,
`job_opening_title` varchar(300) COLLATE utf8_unicode_ci NOT NULL,
`job_opening_description` text COLLATE utf8_unicode_ci NOT NULL,
`job_opening_status` enum('Active','Inactive') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Inactive',
`job_opening_add_date` date NOT NULL,
PRIMARY KEY (`job_opening_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
--
-- Dumping data for table `tbl_job_opening`
--
-- --------------------------------------------------------
--
-- Table structure for table `tbl_pdf`
--
CREATE TABLE IF NOT EXISTS `tbl_pdf` (
`pdf_id` int(11) NOT NULL AUTO_INCREMENT,
`pdf_name` varchar(100) NOT NULL,
`pdf_add_date` date NOT NULL,
`pdf_status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
PRIMARY KEY (`pdf_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `tbl_pdf`
--
-- --------------------------------------------------------
--
-- Table structure for table `tbl_press_realeases`
--
CREATE TABLE IF NOT EXISTS `tbl_press_realeases` (
`press_rel_id` int(11) NOT NULL AUTO_INCREMENT,
`press_rel_date` date NOT NULL,
`press_rel_name` varchar(100) NOT NULL,
`press_rel_type` varchar(100) NOT NULL,
`press_rel_url` varchar(100) NOT NULL,
`press_headline_url` varchar(100) NOT NULL,
`press_rel_desc` text NOT NULL,
`press_rel_image` varchar(100) NOT NULL,
`press_rel_add_date` date NOT NULL,
`press_rel_status` enum('Active','Inactive') NOT NULL DEFAULT 'Inactive',
PRIMARY KEY (`press_rel_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `tbl_press_realeases`
--
-- --------------------------------------------------------
--
-- Table structure for table `tbl_site_color`
--
CREATE TABLE IF NOT EXISTS `tbl_site_color` (
`site_color_id` int(11) NOT NULL AUTO_INCREMENT,
`site_color_admin_id` int(11) NOT NULL,
`site_color_bg_image` varchar(200) NOT NULL,
`site_color_bg_color` varchar(20) NOT NULL,
`site_color_gallery_bg_color` varchar(20) NOT NULL,
`site_color_menu_color` varchar(20) NOT NULL,
`site_color_menu_hover_color` varchar(20) NOT NULL,
`site_color_menu_font_color` varchar(20) NOT NULL,
`site_color_menu_font_hover_color` varchar(20) NOT NULL,
`site_color_left_menu_color` varchar(20) NOT NULL,
`site_color_left_menu_font_color` varchar(20) NOT NULL,
`site_color_left_menu_hover_color` varchar(20) NOT NULL,
`site_color_footer_color` varchar(20) NOT NULL,
`site_color_footer_font_color` varchar(20) NOT NULL,
`site_color_footer_font_hover_color` varchar(20) NOT NULL,
`site_color_quick_enquiry_color` varchar(20) NOT NULL,
`site_color_quick_enquiry_border_color` varchar(20) NOT NULL,
`site_color_quick_enquiry_font_color` varchar(20) NOT NULL,
`site_color_quick_enquiry_button_color` varchar(20) NOT NULL,
`site_color_quick_enquiry_buttonhover_color` varchar(20) NOT NULL,
`site_color_inner_button_color` varchar(20) NOT NULL,
`site_color_inner_buttonhover_color` varchar(20) NOT NULL,
`site_color_inner_button_font_color` varchar(20) NOT NULL,
`site_color_font_size` varchar(20) NOT NULL,
`site_color_font_style` varchar(100) NOT NULL,
`site_color_font_color` varchar(20) NOT NULL,
PRIMARY KEY (`site_color_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `tbl_site_color`
--
-- --------------------------------------------------------
--
-- Table structure for table `tbl_site_pages`
--
CREATE TABLE IF NOT EXISTS `tbl_site_pages` (
`site_pages_id` int(11) NOT NULL AUTO_INCREMENT,
`site_pages_name` varchar(100) NOT NULL,
`site_pages_image_name` varchar(300) NOT NULL,
`site_pages_link` varchar(80) NOT NULL,
`site_pages_show_in_header` enum('Yes','No') NOT NULL DEFAULT 'No',
`site_pages_show_in_footer` enum('Yes','No') NOT NULL DEFAULT 'No',
`site_pages_url` varchar(100) NOT NULL,
`site_pages_meta_title` varchar(200) NOT NULL,
`site_pages_meta_description` varchar(200) NOT NULL,
`site_pages_meta_keyword` varchar(500) NOT NULL,
`site_pages_description` text NOT NULL,
`site_pages_order_by` int(11) NOT NULL,
`site_pages_add_date` date NOT NULL,
`site_pages_status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
PRIMARY KEY (`site_pages_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ;
--
-- Dumping data for table `tbl_site_pages`
--
INSERT INTO `tbl_site_pages` (`site_pages_id`, `site_pages_name`, `site_pages_image_name`, `site_pages_link`, `site_pages_show_in_header`, `site_pages_show_in_footer`, `site_pages_url`, `site_pages_meta_title`, `site_pages_meta_description`, `site_pages_meta_keyword`, `site_pages_description`, `site_pages_order_by`, `site_pages_add_date`, `site_pages_status`) VALUES
(1, 'Home', '', 'index', 'Yes', 'Yes', 'index', 'Elevator Repair & Services in India', 'We are considered as one of the leading Service provider of Elevator Repair & Services in Telangana Hyderabad India.', 'Elevator Repair & Services in Telangana, Elevator Goods Repair & Services in Hyderabad, Bucket Elevator Repair & Services in India, Company Lifts Maintenance & Repairing in Hyderabad', '<p>Set up as a Sole Proprietorship firm in the year 2016 at Telangana (Hyderabad, India), We " <strong>Race Elevators</strong> " are included in assembling brilliant quality. We are considered as one of the leading Service provider of Elevator Repair & Services in Telangana, Hyderabad India we are additionally occupied with offering Elevator Repair Service, Elevator Maintenance Service and Elevator Modernization Service. The gave items are generally refreshing to their components like predominant usefulness, long working life and least support. Under the course of " <strong>Mr. Muzaffer Hussain </strong>" (Proprietor), we have possessed the capacity to cook customer's fluctuated needs in brief way.</p>\r\n\r\n<p><br />\r\nMoreover, to save their flawlessness at our benefactors' premises, we test these on fluctuated grounds before conclusive conveyance of the request. Too, these exhibited items are exceedingly recognized and acknowledged in the midst of our benefactors for their more drawn out administration life, fine complete, elite, rough outlines and operational familiarity. Additionally, we guarantee conveying an impeccable relegation to our benefactors to maintain the confidence we have worked throughout the years.</p>\r\n\r\n<p><br />\r\nKeeping in mind the end goal to complete every one of our procedures in a bad position freeway, we have chosen with ourselves a gifted and qualified group of workers who are well acquainted with the learning of this domain and are completing every one of the undertakings inside the hypothesized time. Not just this, we have contracted them after stern examination of their ability and aptitudes. More to this, we have developed for ourselves a colossal creation unit where all the development undertakings happen. Our infrastructural office is isolated into various subdivisions with a specific end goal to complete every one of the assignments in a bother freeway.</p>\r\n\r\n<p><br />\r\nWorking under the administration and bearing of <strong>Mr. Muzaffer Hussain</strong>, we have procured a gigantic notoriety and remaining in the business. His wide learning and solid business intuition have helped us on various stages to finish most abnormal amount of supporter fulfillment. </p>\r\n\r\n<p> </p>', 1, '0000-00-00', 'Active'),
(2, 'About Us', 'about-us.jpg', 'about-us', 'Yes', 'Yes', 'about-us', 'Elevator Goods Repair & Services in Hyderabad', 'Race Elevators is one of the leading Service provider of Elevator Goods Repair & Services in Telangana Hyderabad India.', 'Elevator Repair & Services in Telangana, Elevator Goods Repair & Services in India, Bucket Elevator Repair & Services in Hyderabad, Company Lifts Maintenance & Repairing in Telangana', '<p>Set up as a Sole Proprietorship firm in the year 2016 at Telangana (Hyderabad, India), We " <strong>Race Elevators</strong> " are included in assembling brilliant quality. We are considered as one of the leading Service provider of Elevator Repair & Services in Telangana Hyderabad India we are additionally occupied with offering Elevator Repair Service, Elevator Maintenance Service and Elevator Modernization Service. The gave items are generally refreshing to their components like predominant usefulness, long working life and least support. Under the course of " <strong>Mr. Muzaffer Hussain</strong> " (Proprietor), we have possessed the capacity to cook customer's fluctuated needs in brief way.</p>\r\n\r\n<p><br />\r\nMoreover, to save their flawlessness at our benefactors' premises, we test these on fluctuated grounds before conclusive conveyance of the request. Too, these exhibited items are exceedingly recognized and acknowledged in the midst of our benefactors for their more drawn out administration life, fine complete, elite, rough outlines and operational familiarity. Additionally, we guarantee conveying an impeccable relegation to our benefactors to maintain the confidence we have worked throughout the years.</p>\r\n\r\n<p><br />\r\nKeeping in mind the end goal to complete every one of our procedures in a bad position freeway, we have chosen with ourselves a gifted and qualified group of workers who are well acquainted with the learning of this domain and are completing every one of the undertakings inside the hypothesized time. Not just this, we have contracted them after stern examination of their ability and aptitudes. More to this, we have developed for ourselves a colossal creation unit where all the development undertakings happen. Our infrastructural office is isolated into various subdivisions with a specific end goal to complete every one of the assignments in a bother freeway.</p>\r\n\r\n<p><br />\r\nWorking under the administration and bearing of <strong>Mr. Muzaffer Hussain</strong>, we have procured a gigantic notoriety and remaining in the business. His wide learning and solid business intuition have helped us on various stages to finish most abnormal amount of supporter fulfillment.</p>\r\n\r\n<p><br />\r\nWe offer redid answers for our customers, subsequently guaranteeing their most elevated fulfillment other than making utilization of present day innovation and top evaluation segments while doing the assembling procedure.</p>\r\n\r\n<p><strong>Different elements which give us characteristic in the business are:</strong> </p>\r\n\r\n<ul>\r\n <li>Ultra-current creation base </li>\r\n <li>Deft group of experts </li>\r\n <li>High quality item exhibit </li>\r\n <li>Easy installment modes </li>\r\n <li>Reasonable valuing </li>\r\n <li>Prompt conveyance </li>\r\n <li>Wide conveyance system </li>\r\n</ul>\r\n\r\n<p><br />\r\n<strong>OUR MISSION </strong></p>\r\n\r\n<p><br />\r\n<strong>Our famous guiding projects will permit you to: </strong></p>\r\n\r\n<ul>\r\n <li>Work less hours and profit </li>\r\n <li>Attract and hold quality, lucrative clients </li>\r\n <li>Manage your time so you'll accomplish more in less time </li>\r\n <li>Hone sharp authority abilities to deal with your group </li>\r\n <li>Cut costs without yielding quality </li>\r\n <li>Automate your business, so you can leave for a considerable length of time, weeks, or even months on end.</li>\r\n</ul>\r\n\r\n<p> </p>', 2, '0000-00-00', 'Active'),
(10, 'Product', '', 'products', 'Yes', 'Yes', 'product', 'Product', 'Product', 'Product', '', 3, '0000-00-00', 'Active'),
(11, 'Contact', '', 'contact-us', 'Yes', 'Yes', 'contact', 'Contact us Race Elevators', 'Contact Race Elevators for any information suggestions and engineers products related query feel free to contact us.', 'live customer support, contact us, live support, feedback, Race Elevators customer care, live help desk, live support.', '<p>Everyday is a new day for us and we work really hard to satisfy our customers everywhere.</p>', 5, '0000-00-00', 'Active'),
(12, 'Enquiry', '', 'enquiry', 'Yes', 'Yes', 'enquiry', 'Ask For free Enquiry- Race Elevators', 'Race Elevators: For any enquiries and comments, you can contact us by phone and Enquiry Form.', 'Free Enquiry, Feedback, contact us- Race Elevators', '<p>We offer the best service to make your work easy</p>', 4, '0000-00-00', 'Active'),
(13, 'Gallery', '', 'gallery', 'Yes', 'Yes', 'gallery', 'Gallery', 'Gallery', 'Gallery', '', 6, '0000-00-00', 'Active'),
(21, 'Site Map', '', 'site-map', 'Yes', 'Yes', 'site-map', 'Sitemap - Race Elevators', 'Sitemap - Race Elevators.', 'Sitemap - Race Elevators', '', 13, '0000-00-00', 'Active'),
(31, 'Testimonial', '', 'testimonial', 'Yes', 'Yes', 'testimonial', 'Testimonial', 'Testimonial', 'Testimonial', '<p>Testimonial</p>', 22, '0000-00-00', 'Active'),
(30, 'Certificates', '', 'certificates', 'Yes', 'Yes', 'certificates', 'certificates', 'certificates', 'certificates', '<p>certificates</p>', 21, '0000-00-00', 'Active'),
(34, 'Video', '', 'video', 'Yes', 'Yes', 'video', 'Video', 'Video', 'Video', '<p>Video</p>', 25, '0000-00-00', 'Active'),
(32, 'Client Logo', '', 'client-logos', 'Yes', 'Yes', 'client-logo', 'Client Logo', 'Client Logoq', 'Client Logo', '<p>Client Logo</p>', 23, '0000-00-00', 'Active'),
(33, 'Thanks', '', 'thanks', 'Yes', 'No', 'thanks', 'Thanks', 'Thanks', 'Thanks', '<p>Thanks</p>', 24, '0000-00-00', 'Active');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_testimonial`
--
CREATE TABLE IF NOT EXISTS `tbl_testimonial` (
`test_id` int(11) NOT NULL AUTO_INCREMENT,
`test_given_by` varchar(100) NOT NULL,
`test_country` varchar(100) NOT NULL,
`test_comp_name` varchar(300) NOT NULL,
`test_phone` varchar(100) NOT NULL,
`test_title` varchar(100) NOT NULL,
`test_image_name` varchar(300) NOT NULL,
`test_description` text NOT NULL,
`test_add_date` date NOT NULL,
`test_status` enum('Active','Inactive') NOT NULL DEFAULT 'Inactive',
PRIMARY KEY (`test_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
--
-- Dumping data for table `tbl_testimonial`
--
-- --------------------------------------------------------
--
-- Table structure for table `tbl_video`
--
CREATE TABLE IF NOT EXISTS `tbl_video` (
`video_id` int(11) NOT NULL AUTO_INCREMENT,
`video_title` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
`video_clip` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`video_link` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'www.google.com',
`video_add_date` date NOT NULL,
`video_status` enum('Active','Inactive') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Active',
PRIMARY KEY (`video_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7 ;
--
-- Dumping data for table `tbl_video`
--
/*!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 */;