|
Server IP : 103.53.40.154 / Your IP : 18.216.99.18 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/pccaterers.in/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 19, 2018 at 10:43 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_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_youtube_link` varchar(300) 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=24 ;
--
-- 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_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_youtube_link`, `admin_meta_alexa_id`, `admin_meta_msvalidate_id`, `admin_site_verification_code`, `admin_google_analytic_code`, `admin_add_date`, `admin_status`) VALUES
(1, 'Admin', '', 'admin', 'admin', 'MH Cargo Movers', 'MD Ghouse', 'Mohammedbari46.ab@gmail.com', '', '+91 9849207188', '', '', 'Balkampet', 'Hyderabad', 'Telangana', 'India', '500018', 'http://localhost/WKIRES17', 'http://www.tradekeyindia.com/mh-cargo-movers/', '', 'Yes', 'Yes', '', '', '', 'No', 'No', '', 'https://www.facebook.com/b2b.tradekeyindia', 'https://twitter.com/tradekeyindia', 'https://plus.google.com/+tradekeyindiacom/posts', 'http://in.linkedin.com/in/b2btradekeyindia', 'All Rights Reserved Bharti Packers And Movers', '', '', '', 'No', '', '2018', 'WebKeyIndia.Com', 'Best SEO Company In India', 'http://www.webkeyindia.com', '', '', '', '', '', '', '', '', '', '', '2014-12-19', 'Active'),
(22, 'Sub Admin', '2,3,4,5,14,15', 'tkiseo', 'tkiankush', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'No', 'Yes', 'Yes', 'No', 'No', '', 'No', 'Yes', 'No', '', '', '', '', '', '', 'No', '', 'No', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2017-12-13', 'Active'),
(23, 'Sub Admin', '1,2,3,4,5,6,7,8,9,10,11,12,13,14,20,16,17,18,15,22', 'tkicoard', 'tkiseema', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'No', 'Yes', 'Yes', 'No', 'No', '', 'No', 'Yes', 'No', '', '', '', '', '', '', 'No', '', 'No', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2017-12-13', '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_gallery` enum('Yes','No') NOT NULL DEFAULT 'Yes',
`category_for_falsh` enum('Yes','No') NOT NULL DEFAULT 'No',
`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=33 ;
--
-- 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=36 ;
--
-- 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=1 ;
--
-- 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=5 ;
--
-- 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=9 ;
--
-- 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=32 ;
--
-- 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_brand_name` varchar(300) NOT NULL,
`header_flash_link` varchar(400) NOT NULL,
`header_flash_description` varchar(400) NOT NULL,
`header_flash_type` varchar(50) NOT NULL,
`header_flash_order_by` int(11) 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=25 ;
--
-- 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=1 ;
--
-- Dumping data for table `tbl_job_opening`
--
-- --------------------------------------------------------
--
-- 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=1 ;
--
-- Dumping data for table `tbl_press_realeases`
--
-- --------------------------------------------------------
--
-- 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_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_image_name` varchar(300) 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_short_description` text 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=27 ;
--
-- Dumping data for table `tbl_site_pages`
--
INSERT INTO `tbl_site_pages` (`site_pages_id`, `site_pages_name`, `site_pages_link`, `site_pages_show_in_header`, `site_pages_show_in_footer`, `site_pages_url`, `site_pages_image_name`, `site_pages_meta_title`, `site_pages_meta_description`, `site_pages_meta_keyword`, `site_pages_short_description`, `site_pages_description`, `site_pages_order_by`, `site_pages_add_date`, `site_pages_status`) VALUES
(1, 'Home', 'index', 'Yes', 'Yes', 'index', '', 'index', 'index', 'index', '', '<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, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>\r\n\r\n<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, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>', 1, '0000-00-00', 'Active'),
(2, 'About Us', 'about-us', 'Yes', 'Yes', 'about-us', 'about-us.jpg', 'About Us', 'About Us', 'About Us', '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, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.', '<p>Here we are testing. Here we are testing. Here we are testing. Here we are testing. Here we are testing. Here we are testing. Here we are testing. Here we are testing. Here we are testing. Here we are testing. Here we are testing. Here we are testing. Here we are testing. Here we are testing. Here we are testing. Here we are testing. Here we are testing. Here we are testing. Here we are testing. Here we are testing. Here we are testing. Here we are testing. Here we are testing. Here we are testing. Here we are testing. Here we are testing. Here we are testing. Here we are testing. Here we are testing. Here we are testing. Here we are testing. Here we are testing. Here we are testing. Here we are testing. Here we are testing. Here we are testing. </p>', 2, '0000-00-00', 'Active'),
(23, 'Products', 'products', 'Yes', 'Yes', 'products', '', 'products', 'products', 'products', '', '<p>products</p>', 3, '0000-00-00', 'Inactive'),
(11, 'Contact Us', 'contact-us', 'Yes', 'Yes', 'contact-us', '', 'Contact Us', 'Contact Us', 'Contact Us', '', '', 5, '0000-00-00', 'Active'),
(12, 'Enquiry', 'enquiry', 'Yes', 'Yes', 'enquiry', '', 'Enquiry', 'Enquiry', 'Enquiry', '', '', 6, '0000-00-00', 'Active'),
(13, 'Gallery', 'gallery', 'Yes', 'Yes', 'gallery', '', 'Gallery', 'Gallery', 'Gallery', '', '', 8, '0000-00-00', 'Active'),
(21, 'Site Map', 'site-map', 'Yes', 'Yes', 'site-map', '', 'Site Map', 'Site Map', 'Site Map', '', '', 7, '0000-00-00', 'Active'),
(24, 'Video', 'video', 'Yes', 'Yes', 'video', '', 'Video', 'Video', 'Video', '', '<p>Video</p>', 9, '0000-00-00', 'Active'),
(25, 'Client Logo', 'client-logos', 'Yes', 'Yes', 'client-logo', '', 'Client Logo', 'Client Logo', 'Client Logo', '', '<p>Client Logo</p>', 10, '0000-00-00', 'Active'),
(26, 'Services', 'services', 'Yes', 'Yes', 'services', '', 'Services', 'Services', 'Services', '', '<p>Services</p>', 4, '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_image_name` varchar(300) NOT NULL,
`test_comp_name` varchar(400) 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=7 ;
--
-- 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=2 ;
--
-- 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 */;