|
Server IP : 103.53.40.154 / Your IP : 3.129.67.248 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/aviationpestcontrolcorporation.in/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 19, 2017 at 11: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=22 ;
--
-- 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', '', 'resadmin', 'resadmin', 'TradeKeyIndia', 'WebKeyNetwork', 'info@webkeyindia.com', '', '', '', '', '', '', '', '', '', 'http://localhost/WKIRES11_Red', '', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'http://www.tradekeyindia.com/E-Trust/e-trust.php?mi=85142', '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', '', '', '', '', '', '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_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=16 ;
--
-- 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=23 ;
--
-- 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=1 ;
--
-- 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=1 ;
--
-- 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=23 ;
--
-- Dumping data for table `tbl_gallery`
--
INSERT INTO `tbl_gallery` (`gallery_id`, `gallery_image_name`, `gallery_image_title`, `gallery_add_date`, `gallery_status`) VALUES
(22, 'capsicum-6446571839_thumb.jpg', '', '2017-05-12', 'Active');
-- --------------------------------------------------------
--
-- 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`
--
INSERT INTO `tbl_header` (`header_id`, `header_logo`, `header_welcome_image`, `header_add_date`, `header_status`) VALUES
(1, 'logo.png', '', '2017-05-18', 'Active');
-- --------------------------------------------------------
--
-- 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=16 ;
--
-- 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_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=23 ;
--
-- 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_description`, `site_pages_order_by`, `site_pages_add_date`, `site_pages_status`) VALUES
(1, 'Home', 'index', 'Yes', 'Yes', 'index', '', 'Corrugated Boxes Manufacturer | Supplier in Thane Maharashtra India', 'We are an eminent Manufacturer and supplier of high quality Corrugated Boxes in Thane Maharashtra India.', 'Corrugated Boxes Manufacturer in Thane Maharashtra India, Corrugated Shippers And Cartons Supplier in Thane Maharashtra India, File Packing Box Manufacturer in Thane Maharashtra India, Boxes For Food Packaging Supplier in Thane Maharashtra India, Corrugated Boxes Supplier in Thane Maharashtra India, Corrugated Shippers And Cartons Manufacturer in Thane Maharashtra India, File Packing Box Supplier in Thane Maharashtra India, Boxes For Food Packaging Manufacturer in Thane Maharashtra India', '<p>We at <strong>Kedia Paper Industries Pvt Ltd</strong>, introduce ourselves as one of the most reliable and trusted corrugated box manufacturers around Mumbai region. Our management team members are in the said field for the last three decades and associated with units at Mumbai, Vasai, Boisar, Bangalore and Kolkata.</p>\r\n\r\n<p><br />\r\nOur unit in Wada is currently having production capacity of 200 MT per month. The unit is well equipped with complete range of corrugated box manufacturing machineries along with In-house printing and punching units.<br />\r\nOur entire range of Quality Testing facilities within the factory premises ensure that only best quality boxes are supplied to customers. Our endeavor is to deliver quality product as per the customer’s requirement. With ISO 9001-2008 certification, it is now an established fact with all our customers.</p>\r\n\r\n<p><br />\r\nOur company has undergone social and ethical audit conducted by Walmart, USA. This is a major achievement in recent times considering their stringent requirements.</p>\r\n\r\n<p><br />\r\nWe are currently catering to industries in various fields such as Garments, Pharmaceuticals, Engineering, Paint, Fast Food products, Fruits, Vegetables and also to Exporters of various products.</p>\r\n\r\n<p><br />\r\nWe are also members of reputed Industry Associations like Indian Institute of Packaging (IIP) and Western India Corrugated Box Manufacturers Association (WICMA) which helps us in various ways like training of personnel, testing of samples and other benefits.</p>', 1, '0000-00-00', 'Active'),
(2, 'About us', 'about-us', 'Yes', 'Yes', 'about-us', 'about-us.png', 'File Packing Box Manufacturer | Supplier in Thane Maharashtra India', 'Kedia Paper Manufacturer and Supplier of File Packing Box in Thane Maharashtra India.', 'File Packing Box Manufacturer in Thane Maharashtra India, Boxes For Food Packaging Supplier in Thane Maharashtra India, Corrugated Paper Pallets Manufacturer in Thane Maharashtra India, Packing Box For Shifting Supplier in Thane Maharashtra India, File Packing Box Supplier in Thane Maharashtra India, Boxes For Food Packaging Manufacturer in Thane Maharashtra India, Corrugated Paper Pallets Supplier in Thane Maharashtra India, Packing Box For Shifting in Thane Maharashtra India', '<p>We at Kedia Paper Industries Pvt Ltd, introduce ourselves as one of the most reliable and trusted corrugated box manufacturers around Mumbai region. Our management team members are in the said field for the last three decades and associated with units at Mumbai, Vasai, Boisar, Bangalore and Kolkata.</p>\r\n\r\n<p><br />\r\nOur unit in Wada is currently having production capacity of 200 MT per month. The unit is well equipped with complete range of corrugated box manufacturing machineries along with In-house printing and punching units.<br />\r\nOur entire range of Quality Testing facilities within the factory premises ensure that only best quality boxes are supplied to customers. Our endeavor is to deliver quality product as per the customer’s requirement. With ISO 9001-2008 certification, it is now an established fact with all our customers.</p>\r\n\r\n<p><br />\r\nOur company has undergone social and ethical audit conducted by Walmart, USA. This is a major achievement in recent times considering their stringent requirements.</p>\r\n\r\n<p><br />\r\nWe are currently catering to industries in various fields such as Garments, Pharmaceuticals, Engineering, Paint, Fast Food products, Fruits, Vegetables and also to Exporters of various products.</p>\r\n\r\n<p><br />\r\nWe are also members of reputed Industry Associations like Indian Institute of Packaging (IIP) and Western India Corrugated Box Manufacturers Association (WICMA) which helps us in various ways like training of personnel, testing of samples and other benefits.</p>\r\n\r\n<p> </p>\r\n\r\n<p><strong>Brief History</strong></p>\r\n\r\n<p><br />\r\n<strong>Kedia Paper Industries Pvt Ltd</strong> is one of the most reputed and recognised corrugated box manufacturers in western India. Promoters of this company started this activity way back in the year <strong>1970</strong> and never looked back from there. They specialized in Sheet making and became the pioneers and leading manufacturer of sheets in Mumbai for over 2 decades. With growing success, more units were opened in different parts of the country like Bangalore and Kolkata.</p>\r\n\r\n<p><br />\r\nOur Managing Director, <strong>Mr. Bimal Kedia</strong> with his foresight saw a need to make presence outside Mumbai as the trend of major industries hibernating to outskirts has commenced. With this in mind he discovered WADA way back in 1994 and envisioned it to be a major industrial zone in coming years.</p>\r\n\r\n<p><br />\r\nWith help of Wadekar family, Kedia Paper Industries Private Limited was incorporated in 1995. With a small set up initially, it has expanded its facilities and operations every year. </p>\r\n\r\n<p><br />\r\nIt now boasts of a production capacity of over 200 metric tonnes per month and plans to expand its capacity manifolds. The unit is well equipped with complete range of Updated Semi – Auto Corrugated Box process machines to manufacture high quality products and deliver excellent value to our customers. KPI takes it as a challenge to prove its calibre every day and continually raises its standards to ensure high degree of customer satisfaction.</p>\r\n\r\n<p><br />\r\n<strong>FACILITIES</strong></p>\r\n\r\n<ul>\r\n <li>Kedia Paper Industries Pvt Ltd is situated in WADA, located at a distance of 100 kms from Mumbai. It is spread in an area around 15000 sq ft. </li>\r\n <li>Special area is dedicated for systematic storage of reels with help of Stacker and Reel trolleys.</li>\r\n <li>Corrugator units of “B” flute and “E” flute cartons helps in making small as well as large sized boxes.</li>\r\n <li>In-house Offset Printing Press accompanied by Single Colour Flexo machine helps in fulfilling all type of printed box requirements.</li>\r\n <li>Platen Punching and Flat Bed Die Cutting units help us supply tailor made boxes of all sizes and shapes </li>\r\n <li>Regular Slotted Universal boxes are made from RS4, for better cutting and finishing.</li>\r\n <li>Stitching Machines helps the boxes gain maximum strength at its edges.</li>\r\n <li>Our specially imported Side Glueing machine is an excellent alternative to rusted pins and also handy solution to export box needs.</li>\r\n <li>State of the Art Quality Control Laboratory with various testing machines ensures quality consistency.</li>\r\n</ul>\r\n\r\n<p><br />\r\n<strong>LIST OF QUALITY CONTROL EQUIPMENTS:</strong> </p>\r\n\r\n<p><br />\r\n1. BURSTING STRENGTH TESTER <br />\r\n2. GRAMMAGE TESTER FOR GSM TESTING<br />\r\n3. WEIGHING SCALE FOR REELS UPTO 1 ton <br />\r\n4. E.R.M.A FOR SOLID CONTENT OF ADHESIVE <br />\r\n5. VISCOCOTY CUP FOR ADHESIVE <br />\r\n6. BOX WEIGHING SCALE<br />\r\n7. PAPER WEIGHING SCALE<br />\r\n8. STAND & ROLLER FOR COBB TESTING</p>\r\n\r\n<p><br />\r\n<strong>Clientele Profile</strong></p>\r\n\r\n<p><br />\r\nWith almost 2 decades of service, KPI has a vast varied list of esteemed customers representing various industries. Some of the industries catered are as follows: -</p>\r\n\r\n<ul>\r\n <li>Automotive Oil industry </li>\r\n <li>Cotton industry used for Personal hygiene and Medical industry</li>\r\n <li>Food Industry including Packaged and Pizza boxes</li>\r\n <li>Pharmaceutical Industry making herbal and allopathic medicines</li>\r\n <li>Engineering tools used in various industries</li>\r\n <li>Cotton and Polyester Yarn Industry</li>\r\n <li>Construction industry making readymade furniture and house parts.</li>\r\n <li>Agriculture sector including equipment and food grain packing </li>\r\n <li>Many others..</li>\r\n</ul>\r\n\r\n<p><br />\r\n<strong>Associated Organizations</strong></p>\r\n\r\n<p><br />\r\nWe are associated with various industry related associations which help us to remain abreast with latest information on topics like Government Policy Changes, Technological know-how, Educational and training programmes, testing facilities, etc. Associated Organisations are as follows: -</p>\r\n\r\n<ul>\r\n <li>Western India Box Manufacturing Association (WICMA)</li>\r\n <li>Indian Institute of Packaging (IIP)</li>\r\n <li>Bombay Industries Association (BIA)</li>\r\n <li>Papermart India</li>\r\n <li>Small & Medium Enterprise (SME ) World</li>\r\n <li>Wada Industries Association</li>\r\n</ul>\r\n\r\n<p><br />\r\n<strong>TYPE OF PRODUCTS MANUFACTURED</strong></p>\r\n\r\n<p><br />\r\nWith help of our various updated machines, we are able to make a variety of products to satisfy our customer needs. </p>\r\n\r\n<p><br />\r\n1. In house Offset Printed Boxes<br />\r\n2. Flexo Printed Boxes<br />\r\n3. Die Cut boxes with precision<br />\r\n4. Large sized boxes in different shapes<br />\r\n5. E-Flute small boxes<br />\r\n6. B-Flute regular boxes<br />\r\n7. Side Pasted Boxes<br />\r\n8. Stitched Boxes<br />\r\n9. Corrugated Rolls<br />\r\n10. Plates and Partitions </p>\r\n\r\n<p><br />\r\n<strong>Company Highlights</strong></p>\r\n\r\n<ul>\r\n <li>Over 40 Years of Experience</li>\r\n <li>Young Management</li>\r\n <li>Complete range of Updated Machines</li>\r\n <li>In-House Offset Printing Press</li>\r\n <li>State of the art Q.C Laboratory</li>\r\n <li>Follows systems based on ISO 9001 – 2008.</li>\r\n <li>Complies Social audit parameters of Walmart</li>\r\n <li>Varied List of Esteemed Customers</li>\r\n</ul>\r\n\r\n<p> </p>', 3, '0000-00-00', 'Active'),
(10, 'Projects', 'products', 'Yes', 'Yes', 'projects', '', 'Corrugated Sheets Manufacturer | Supplier in Thane Maharashtra India', 'We are Manufacturer and Supplier of Corrugated Sheets in Thane Maharashtra India.', 'Corrugated Paper Pallets Supplier in Thane Maharashtra India, Packing Box For Shifting in Thane Maharashtra India, Corrugated Sheets in Thane Maharashtra India, Corrugated Rolls And Liners in Thane Maharashtra India, Corrugated Paper Pallets Manufacturer in Thane Maharashtra India, Packing Box For Shifting in Thane Maharashtra India, Corrugated Sheets in Thane Maharashtra India, Corrugated Rolls And Liners in Thane Maharashtra India', '<p>In range of our products we offer corrugated boxes, corrugated shippers and cartoons, file packing box, boxes for food packaging, corrugated paper pallets, delivery boxes, corrugated sheets, etc. No matter which product you choose, we offer quality for sure because quality is our hallmark and we do not compromise with such anymore.</p>\r\n\r\n<p> </p>', 2, '0000-00-00', 'Active'),
(11, 'Contact Us', 'contact-us', 'Yes', 'Yes', 'contact-us', '', 'Kedia Paper- Contact us', 'Contact us for Kedia Paper in Maharashtra India, Get all Details about Kedia Paper company contact us by information form and given Number.', 'Kedia Paper Service, customer care Kedia Paper, online support', '', 4, '0000-00-00', 'Active'),
(12, 'Enquiry', 'enquiry', 'Yes', 'Yes', 'enquiry', '', 'Kedia Paper- Ask for free enquiry', 'Kedia Paper for any enquiries and comments, you can contact With Kedia Paper by phone and Enquiry form.', 'Ask for free enquiry- Kedia Paper', '', 5, '0000-00-00', 'Active'),
(13, 'Gallery', 'gallery', 'No', 'Yes', 'gallery', '', 'Gallery', 'Gallery', 'Gallery', '', 7, '0000-00-00', 'Active'),
(14, 'Testimonials', 'testimonial', 'No', 'Yes', 'testimonials', '', 'Testimonials', 'Testimonials', 'Testimonials', '', 8, '0000-00-00', 'Inactive'),
(18, 'Video', 'video', 'No', 'Yes', 'video', '', 'Video', 'Video', 'Video', '', 9, '0000-00-00', 'Inactive'),
(19, 'Certificate', 'certificates', 'No', 'Yes', 'certificate', '', 'Certificate', 'Certificate', 'Certificate', '', 10, '0000-00-00', 'Inactive'),
(20, 'Client Logos', 'client-logos', 'No', 'Yes', 'client-logos', '', 'Client Logos', 'Client Logos', 'Client Logos', '', 11, '0000-00-00', 'Inactive'),
(21, 'Site Map', 'site-map', 'No', 'Yes', 'site-map', '', 'Kedia Paper- Sitemap', 'Sitemap of Kedia Paper', 'Sitemap of Kedia Paper', '', 6, '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=4 ;
--
-- Dumping data for table `tbl_testimonial`
--
INSERT INTO `tbl_testimonial` (`test_id`, `test_given_by`, `test_image_name`, `test_comp_name`, `test_description`, `test_add_date`, `test_status`) VALUES
(3, 'Arif', 'arif.png', 'Tradekeyindia', '<p>This is a testing. This is a testing. This is a testing. This is a testing. This is a testing. This is a testing. This is a testing. This is a testing. This is a testing. This is a testing. This is a testing. This is a testing. This is a testing. This is a testing. This is a testing. This is a testing. </p>', '2017-05-18', 'Active');
-- --------------------------------------------------------
--
-- 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=1 ;
--
-- 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 */;