--
-- Host: 182.50.131.121    Database: kohitecdb92
-- ------------------------------------------------------


--
-- Table structure for table `career`
--

CREATE TABLE `career` (
  `id` int(20) NOT NULL auto_increment,
  `name` varchar(20) NOT NULL,
  `lastname` varchar(30) NOT NULL,
  `email` varchar(30) NOT NULL,
  `phno` int(15) NOT NULL,
  `country` varchar(20) NOT NULL,
  `yearsofexp` int(20) NOT NULL,
  `file` varchar(30) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `career`
--

INSERT INTO `career` VALUES (1,'','','',0,'',0,'');
INSERT INTO `career` VALUES (2,'','','',0,'',0,'');
INSERT INTO `career` VALUES (3,'','','',0,'',0,'');
INSERT INTO `career` VALUES (4,'','','',0,'',0,'');
INSERT INTO `career` VALUES (5,'','','',0,'',0,'');
INSERT INTO `career` VALUES (6,'','','',0,'',0,'');
INSERT INTO `career` VALUES (7,'','','',0,'',0,'');
INSERT INTO `career` VALUES (8,'','','',0,'',0,'');
INSERT INTO `career` VALUES (9,'','','',0,'',0,'');
INSERT INTO `career` VALUES (10,'','','',0,'',0,'');
INSERT INTO `career` VALUES (11,'','','',0,'',0,'');
INSERT INTO `career` VALUES (12,'','','',0,'',0,'');
INSERT INTO `career` VALUES (13,'test','test','test',9989764,'hfdgx',1,'');
INSERT INTO `career` VALUES (14,'Akmal','Amin','theakmalamin@gmail.com',176635679,'Malaysian',1,'AKMAL AMIN.pdf');
INSERT INTO `career` VALUES (15,'Faizan','Qazi','faizanqazimoi@gmail.com',91,'Indian',2,'Faizan IT Consultant(1).doc');
INSERT INTO `career` VALUES (16,'Furqaan Hassan','MIR','fh.mir@outlook.com',2147483647,'indian',3,'furqaan_cv_sxr.doc');
INSERT INTO `career` VALUES (17,'saravanan ','s','saravananmalikaraj@gmail.com',2147483647,'India',2,'Resume.doc');
INSERT INTO `career` VALUES (18,'tanddori','nan','tandori@yahoo.com',2147483647,'mix india . bangla',3,'');

--
-- Table structure for table `careerintern`
--

CREATE TABLE `careerintern` (
  `id` int(20) NOT NULL,
  `name` varchar(20) NOT NULL,
  `lastname` varchar(30) NOT NULL,
  `email` varchar(40) NOT NULL,
  `phno` int(20) NOT NULL,
  `file` varchar(40) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `careerintern`
--

INSERT INTO `careerintern` VALUES (1,'Aatif','Bandey','aatifbandey2009@gmail.com',2147483647,'ew1.docx');
INSERT INTO `careerintern` VALUES (0,'','','',0,'');
INSERT INTO `careerintern` VALUES (0,'','','',0,'');
INSERT INTO `careerintern` VALUES (0,'','','',0,'');
INSERT INTO `careerintern` VALUES (0,'','','',0,'');
INSERT INTO `careerintern` VALUES (0,'','','',0,'');
INSERT INTO `careerintern` VALUES (0,'','','',0,'');
INSERT INTO `careerintern` VALUES (0,'','','',0,'');
INSERT INTO `careerintern` VALUES (0,'','','',0,'');
INSERT INTO `careerintern` VALUES (0,'','','',0,'');
INSERT INTO `careerintern` VALUES (0,'','','',0,'');
INSERT INTO `careerintern` VALUES (0,'','','',0,'');
INSERT INTO `careerintern` VALUES (0,'','','',0,'');
INSERT INTO `careerintern` VALUES (0,'','','',0,'');
INSERT INTO `careerintern` VALUES (0,'','','',0,'');
INSERT INTO `careerintern` VALUES (0,'Muhamad Faezudin','Hairuddin','faezudin.hairuddin@gmail.com',17,'');

--
-- Table structure for table `gallery`
--

CREATE TABLE `gallery` (
  `pid` int(10) NOT NULL,
  `file` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `gallery`
--

INSERT INTO `gallery` VALUES (1,'Kohitec-website_05.png');
INSERT INTO `gallery` VALUES (2,'Kohitec-website_18.png');

--
-- Table structure for table `servicecontent`
--

CREATE TABLE `servicecontent` (
  `id` int(5) NOT NULL,
  `content` text NOT NULL,
  `file` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `servicecontent`
--

INSERT INTO `servicecontent` VALUES (2,' sdfASDf  ','Kohitec-website_06.png');


