--
-- Host: localhost    Database: actmed_hrms
-- ------------------------------------------------------


--
-- Table structure for table `access`
--

CREATE TABLE `access` (
  `AccessID` int(11) NOT NULL,
  `RoleID` int(11) NOT NULL,
  `RoleShortCode` varchar(2) NOT NULL,
  `MenuID` bigint(20) NOT NULL,
  `Access` enum('Y','N') NOT NULL DEFAULT 'Y'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `access`
--


--
-- Table structure for table `approvals`
--

CREATE TABLE `approvals` (
  `Approvals_id` int(11) NOT NULL AUTO_INCREMENT,
  `FormType` varchar(40) NOT NULL,
  `FormID` int(20) NOT NULL,
  `EmployeeCode` varchar(40) NOT NULL,
  `EmployeeName` varchar(40) NOT NULL,
  `ReasonForLeave` varchar(40) NOT NULL,
  `Status` enum('pending','approved','rejected') NOT NULL,
  `ReasonForRejection` varchar(100) NOT NULL,
  `Department` varchar(40) NOT NULL,
  `EmployeeType` varchar(2) NOT NULL,
  `RequestedOn` date NOT NULL,
  `approval_reason` varchar(500) NOT NULL,
  `del_flag` tinyint(1) NOT NULL,
  PRIMARY KEY (`Approvals_id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `approvals`
--

INSERT INTO `approvals` VALUES (1,'Leave',1,'EQC1111460','Ganesan','Personal Leave','pending','','6','Pe','2018-02-22','',1),(2,'Leave',2,'EQC1111460','Ganesan','Test Leave','pending','','6','Pe','2018-02-22','',1),(3,'Leave',3,'EMM0118634','Sankaralingam','sdfsd','pending','','3','Pr','2018-02-22','',0),(4,'Permission',1,'EMM0118634','Sankaralingam','234242','pending','','3','Pr','2018-02-22','',0),(5,'Permission',2,'EMM0118634','Sankaralingam','daedadsdd','pending','','3','Pr','2018-02-22','',0),(6,'Leave',4,'EMM0118634','Sankaralingam','sdfsd','pending','','3','Pr','2018-02-22','',0),(7,'Leave',5,'EMM0118634','Sankaralingam','sf','pending','','3','Pr','2018-02-22','',0),(8,'Permission',3,'EMM0118634','Sankaralingam','sdfdsd','pending','','3','Pr','2018-02-22','',0),(9,'Permission',4,'EMM0118634','Sankaralingam','asdas','pending','','3','Pr','2018-02-22','',0),(10,'Permission',5,'EMM0817623','Pravinraj','qewqwqw','pending','','3','Pr','2018-02-22','',0),(11,'Permission',6,'EMM0817623','Pravinraj','kkkkk','pending','','3','Pr','2018-02-22','',0),(12,'Leave',6,'EQC1111460','Ganesan','work frm home','approved','','6','Pe','2018-02-22','Approved',0),(13,'Permission',7,'EQC1111460','Ganesan','went hospital','pending','','6','Pe','2018-02-22','',0);

--
-- Table structure for table `country`
--

CREATE TABLE `country` (
  `country_id` int(11) NOT NULL AUTO_INCREMENT,
  `country_name` varchar(50) NOT NULL,
  `country_abbrev` varchar(3) NOT NULL,
  PRIMARY KEY (`country_id`)
) ENGINE=InnoDB AUTO_INCREMENT=236 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `country`
--

INSERT INTO `country` VALUES (1,'Afghanistan','AF'),(2,'Albania','AL'),(3,'Algeria','DZ'),(4,'American Somoa','AS'),(5,'Andorra','AD'),(6,'Angola','AO'),(7,'Anguilla','AI'),(8,'Antarctica','AQ'),(9,'Antigua and Barbuda','AG'),(10,'Argentina','AR'),(11,'Armenia','AM'),(12,'Aruba','AW'),(13,'Australia','AU'),(14,'Austria','AT'),(15,'Bahamas','BS'),(16,'Bahrain','BH'),(17,'Bangladesh','BD'),(18,'Barbados','BB'),(19,'Belarus','BY'),(20,'Belgium','BE'),(21,'Belize','BZ'),(22,'Benin','BJ'),(23,'Bermuda','BM'),(24,'Bhutan','BT'),(25,'Bolivia','BO'),(26,'Bosnia and Herzegovina','BA'),(27,'Botswana','BW'),(28,'Bouvet Island','BV'),(29,'Brazil','BR'),(30,'British Indian Ocean Territory','IO'),(31,'Brunei Darussalam','BN'),(32,'Bulgaria','BG'),(33,'Burkina Faso','BF'),(34,'Burundi','BI'),(35,'Cambodia','KH'),(36,'Cameroon','CM'),(37,'Canada','CA'),(38,'Cape Verde','CV'),(39,'Cayman Islands','KY'),(40,'Central African Republic','CF'),(41,'Chad','TD'),(42,'Chile','CL'),(43,'China','CN'),(44,'Christmas Island','CX'),(45,'Cocos (Keeling) Islands','CC'),(46,'Colombia','CO'),(47,'Comoros','KM'),(48,'Congo','CG'),(49,'Cook Islands','CK'),(50,'Costa Rica','CR'),(51,'Croatia','HR'),(52,'Cuba','CU'),(53,'Cyprus','CY'),(54,'Czech Republic','CZ'),(55,'Denmark','DK'),(56,'Djibouti','DJ'),(57,'Dominica','DM'),(58,'Dominican Republic','DO'),(59,'East Timor','TP'),(60,'Ecuador','EC'),(61,'Egypt','EG'),(62,'El Salvador','SV'),(63,'Equatorial Guinea','GQ'),(64,'Eritrea','ER'),(65,'Estonia','EE'),(66,'Ethiopia','ET'),(67,'Faroe Islands','FO'),(68,'Falkland Islands','FK'),(69,'Fiji','FJ'),(70,'Finland','FI'),(71,'France','FR'),(72,'French Guiana','GF'),(73,'French Polynesia','PF'),(74,'French Southern and Antarctic Lands','FQ'),(75,'Gabon','GA'),(76,'Gambia','GM'),(77,'Georgia','GE'),(78,'Germany','DE'),(79,'Ghana','GH'),(80,'Gibraltar','GI'),(81,'Greece','GR'),(82,'Greenland','GL'),(83,'Grenada','GD'),(84,'Guadaloupe','GP'),(85,'Guam','GU'),(86,'Guatemala','GT'),(87,'Guinea','GN'),(88,'Guinea-Bissau','GW'),(89,'Guyana','GY'),(90,'Haiti','HT'),(91,'Heard Island and McDonald Islands','HM'),(92,'Honduras','HN'),(93,'Hong Kong','HK'),(94,'Hungary','HU'),(95,'Iceland','IS'),(96,'India','IN'),(97,'Indonesia','ID'),(98,'Iran','IR'),(99,'Iraq','IQ'),(100,'Ireland','IE'),(101,'Israel','IL'),(102,'Italy','IT'),(103,'Ivory Coast','CI'),(104,'Jamaica','JM'),(105,'Japan','JP'),(106,'Jordan','JO'),(107,'Kazakhstan','KZ'),(108,'Kenya','KE'),(109,'North Korea','KP'),(110,'South Korea','KR'),(111,'Kuwait','KW'),(112,'Kyrgyzstan','KG'),(113,'Laos','LA'),(114,'Latvia','LV'),(115,'Lebanon','LN'),(116,'Lesotho','LS'),(117,'Liberia','LR'),(118,'Libya','LY'),(119,'Liechtenstein','LI'),(120,'Lithuania','LT'),(121,'Luxembourg','LU'),(122,'Macau','MO'),(123,'Macedonia','MK'),(124,'Madagascar','MG'),(125,'Malawi','MW'),(126,'Malaysia','MY'),(127,'Maldives','MV'),(128,'Mali','ML'),(129,'Malta','MT'),(130,'Marshall Islands','MH'),(131,'Martinique','MQ'),(132,'Mauritania','MR'),(133,'Mauritius','MU'),(134,'Mayotte','YT'),(135,'Mexico','MX'),(136,'Micronesia','FM'),(137,'Moldova','MD'),(138,'Monaco','MC'),(139,'Mongolia','MN'),(140,'Montserrat','MS'),(141,'Morocco','MA'),(142,'Mozambique','MZ'),(143,'Myanmar','MM'),(144,'Namibia','NA'),(145,'Nauru','NR'),(146,'Nepal','NP'),(147,'Netherlands','NL'),(148,'Netherlands Antilles','AN'),(149,'New Caledonia','NC'),(150,'New Hebrides','NH'),(151,'New Zealand','NZ'),(152,'Nicaragua','NI'),(153,'Niger','NE'),(154,'Nigeria','NG'),(155,'Niue','NU'),(156,'Norfolk Island','NF'),(157,'Norway','NO'),(158,'Oman','OM'),(159,'Pakistan','PK'),(160,'Palau','PW'),(161,'Panama','PA'),(162,'Papua New Guinea','PG'),(163,'Paraguay','PY'),(164,'Peru','PE'),(165,'Philippines','PH'),(166,'Pitcairn','PN'),(167,'Poland','PL'),(168,'Portugal','PT'),(169,'Puerto Rico','PR'),(170,'Qatar','QA'),(171,'Reunion','RE'),(172,'Romania','RO'),(173,'Russia','RU'),(174,'Rwanda','RW'),(175,'St. Christopher-Nevis-Anguilla','KN'),(176,'St. Helena','SH'),(177,'St. Lucia','LC'),(178,'St. Pierre and Miquelon','PM'),(179,'St. Vincent','VC'),(180,'Samoa','WS'),(181,'San Marino','SM'),(182,'Sao Tome and Principe','ST'),(183,'Saudi Arabia','SA'),(184,'Senegal','SN'),(185,'Seychelles','SC'),(186,'Sierra Leone','SL'),(187,'Singapore','SG'),(188,'Slovakia','SK'),(189,'Slovenia','SI'),(190,'Solomon Islands','SB'),(191,'Somalia','SO'),(192,'South Africa','ZA'),(193,'Spain','ES'),(194,'Sri Lanka','LK'),(195,'Sudan','SD'),(196,'Surinam','SR'),(197,'Svalbard and Jan Mayen','SJ'),(198,'Swaziland','SZ'),(199,'Sweden','SE'),(200,'Switzerland','CH'),(201,'Syria','SY'),(202,'Taiwan','TW'),(203,'Tajikistan','TJ'),(204,'Tanzania','TZ'),(205,'Thailand','TH'),(206,'Togo','TG'),(207,'Tokelau Islands','TK'),(208,'Tonga','TO'),(209,'Trinidad and Tobago','TT'),(210,'Tunisia','TN'),(211,'Turkey','TR'),(212,'Turks and Caicos Islands','TC'),(213,'Tuvalu','TV'),(214,'Uganda','UG'),(215,'Ukraine','UA'),(216,'United Arab Emirates','AE'),(217,'United Kingdom','GB'),(218,'United state','US'),(219,'United state Miscellaneous Pacific Islands','PU'),(220,'Uruguay','UY'),(221,'Uzbekistan','UZ'),(222,'Vatican City','VA'),(223,'Venezuela','VE'),(224,'Vietnam','VN'),(225,'Virgin Islands (U.S.)','VI'),(226,'Wallis and Futana','WF'),(227,'Western Sahara','EH'),(228,'Yemen','YE'),(229,'Yugoslavia','YU'),(230,'Zaire','ZR'),(231,'Zambia','ZM'),(232,'Zimbabwe','ZW'),(233,'Serbia','RS'),(234,'Montenegro','ME'),(235,'Republika Srpska','RS2');

--
-- Table structure for table `defaultsettings`
--

CREATE TABLE `defaultsettings` (
  `SetID` int(11) NOT NULL AUTO_INCREMENT,
  `SetVariable` varchar(200) NOT NULL,
  `SetValue` varchar(200) NOT NULL,
  `SetStatus` enum('Y','N') NOT NULL DEFAULT 'Y',
  PRIMARY KEY (`SetID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `defaultsettings`
--

INSERT INTO `defaultsettings` VALUES (1,'ADMIN_EMAIL','jana@amulya.biz','Y'),(2,'MONITOR_EMAIL','jana@actmedia.net','Y');

--
-- Table structure for table `departments`
--

CREATE TABLE `departments` (
  `DepID` int(11) NOT NULL AUTO_INCREMENT,
  `DepartmentName` varchar(45) DEFAULT NULL,
  `Description` varchar(45) DEFAULT NULL,
  `DepartmentHead` int(11) DEFAULT NULL,
  `DepartmentTeamMail` varchar(100) DEFAULT NULL,
  `OrganizationID` int(11) DEFAULT NULL,
  `DepartmentParentID` int(11) DEFAULT NULL,
  PRIMARY KEY (`DepID`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `departments`
--

INSERT INTO `departments` VALUES (1,'Enterprise Services',NULL,1,'vasanth@amulya.biz ',NULL,NULL),(2,'Amulya IT',NULL,5,'mike@amulya.biz',NULL,NULL),(3,'Amulya Soft',NULL,5,'mike@amulya.biz',NULL,NULL),(4,'Business Development',NULL,0,'sathish@amulya.biz',NULL,NULL),(5,'HR',NULL,43,'hr@amulya.biz',NULL,NULL),(6,'Quality',NULL,43,'shiji.kumaran@amulya.biz',NULL,NULL),(7,'System Admin',NULL,32,'sathishkannan@amulya.biz',NULL,NULL),(8,'General Admin',NULL,42,'sunil@amulya.biz',NULL,NULL);

--
-- Table structure for table `designation`
--

CREATE TABLE `designation` (
  `DesignationID` int(11) NOT NULL AUTO_INCREMENT,
  `DesignationName` varchar(50) DEFAULT NULL,
  `DepartmentID` int(11) DEFAULT NULL,
  PRIMARY KEY (`DesignationID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `designation`
--


--
-- Table structure for table `education`
--

CREATE TABLE `education` (
  `EduID` int(11) NOT NULL AUTO_INCREMENT,
  `EmpID` int(11) DEFAULT NULL,
  `Degree` varchar(150) DEFAULT NULL,
  `Specialization` varchar(150) DEFAULT NULL,
  `GraduationYear` year(4) DEFAULT NULL,
  `Percentage` varchar(45) DEFAULT NULL,
  `College` varchar(45) DEFAULT NULL,
  `University` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`EduID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `education`
--


--
-- Table structure for table `employee`
--

CREATE TABLE `employee` (
  `EmpID` int(11) NOT NULL AUTO_INCREMENT,
  `EmployeeFirstName` varchar(150) DEFAULT NULL,
  `EmployeeLastName` varchar(45) DEFAULT NULL,
  `EmployeeCode` varchar(40) NOT NULL,
  `EmployeeDepartment` varchar(45) DEFAULT NULL,
  `EmployeeEmailID` varchar(150) DEFAULT NULL,
  `EmployeeDesignation` varchar(45) DEFAULT NULL,
  `EmployeePassword` varchar(50) DEFAULT '1q2w3e',
  `EmployeeType` varchar(50) NOT NULL,
  PRIMARY KEY (`EmpID`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `employee`
--

INSERT INTO `employee` VALUES (1,'Vasanthakumar',' D','ETS0104076','2','vasanth@amulya.biz ','Principal Engineer','1q2w3e','Permanent'),(2,'Thousif Ahamed','Ahamed','ECS0709294','2','thousif.ahamed@actsupport.com','Technical Lead','1q2w3e','Permanent'),(3,'Rahul ','Somarajan','ETS0711445','2','rahul.s@amulya.biz','Senior Technical Support Engineer','1q2w3e','Permanent'),(4,'Prosper ','Gnanasekar','ETS0811447','2','prosper.e@amulya.biz ','Team Lead','1q2w3e','Permanent'),(5,'A.Arokianathan','','ECS0806249','2','mike@amulya.biz','Head - Web Hosting Support','1q2w3e','Permanent'),(6,'Subash ','Chandra Bose','ECS1108272','2','subash.c.bose@actsupport.com','Account Manager','1q2w3e','Permanent'),(7,'Vinothkumar','S','ECS0310360','2','vinothkumar.s@amulya.biz','Principal Engineer','1q2w3e','Permanent'),(8,'Rajkumar','K','ETS0311427','2','rajkumar.k@actsupport.com','Senior Systems Engineer','1q2w3e','Permanent'),(9,'Joseph ','Martin','ETS0911448','2','joseph.m@actsupport.com','Senior Systems Engineer','1q2w3e','Permanent'),(10,'Sankara ','Narayanan','ETS1111457','2','shankaranarayanan.r@actsupport.com ','Senior Systems Engineer','1q2w3e','Permanent'),(11,'Vijayaraj ','R','ETS0711442','2','vijayaraj.r@actsupport.com','Senior Systems Engineer','1q2w3e','Permanent'),(12,'Rajesh','S','ETS0912488','2','rajesh.sb@actsupport.com','Senior Systems Engineer','1q2w3e','Permanent'),(13,'Ramkumar','G','ETS0115559','2','ramkumar.g@actsupport.com ','Systems Engineer','1q2w3e','Permanent'),(14,'Dhinakaran','G','ECS0311420','2','dhinakaran.g@actsupport.com','Team Lead','1q2w3e','Permanent'),(15,'S Arun','Karthik','ETS0715581','2','arunkarthik.s@actsupport.com','Systems Engineer','1q2w3e','Permanent'),(16,'Vijayaragavan','S','ETS0416594','2','vijayaragavan.s@actsupport.com','Junior Systems Engineer','1q2w3e','Permanent'),(17,'Balu ','Mahendran','ETS0416595','2','balumahendran.cm@actsupport.com','Systems Engineer','1q2w3e','Permanent'),(18,'Jefferson ','J','ETS0916603','2','jefferson.j@actsupport.com','Junior System Engineer','1q2w3e','Permanent'),(19,'Alex','L','ETS1016605','2','alex.l@actsupport.com','Systems Engineer','1q2w3e','Permanent'),(20,'ShamPrakash','C','ETS1116607','2','shamprakash.c@actsupport.com ','Systems Engineer','1q2w3e','Permanent'),(21,'Arokiaraj Victar Sam tony','','ETS1216608','2','victarsamtony.a@actsupport.com','Systems Engineer','1q2w3e','Probation'),(22,'Nisanth','','ETS1216610','2','nisanth.s@actsupport.com','Junior Systems Engineer','1q2w3e','Permanent'),(23,'Sudarsan','R','ETS0317612','2','sudarsan.r@actsupport.com','Junior Systems Engineer','1q2w3e','Permanent'),(24,'Gokulprasad','T','ETS0317614','2','gokulprasad.t@actsupport.com','Junior System Engineer','1q2w3e','Probation'),(25,'Joseph','Livingstone','ETS0517616','2','joseph.livingstone@actsupport.com ','Senior system engineer','1q2w3e','Probation'),(26,'Kishore','Kumar','ETS0617619','2','kishorekumar.s@actsupport.com','Junior System engineer','1q2w3e','Probation'),(27,'Pradeep','R D','ETS0717621','2','pradeep.rd@actsupport.com','Apprentice','1q2w3e','Apprentice'),(28,'Rajkannan','V','ETS0717622','2','rajkannan.v@actsupport.com','Junior System Engineer','1q2w3e','Probation'),(29,'Ramesh Kumar','N','ETS0817625','2','ramesh.n@actsupport.com','Senior system engineer','Probation',''),(30,'Raghavendiran','Nagarajan','ETS0917626','2','raghavendiran.n@actsupport.com','Systems Engineer','1q2w3e','Probation'),(31,'Rakesh','R','ETS1017631','2','rakesh.r@actsupport.com','Junior system Engineer','1q2w3e','Probation'),(32,'Sathish','Kannan','ETS0705173','7','sathishkannan@amulya.biz','Information Security Manager','1q2w3e','Permanent'),(33,'Sankar','S','ETS1210403','7','sankar.s@actsupport.com','Senior Systems Administrator','1q2w3e','Permanent'),(34,'Vignesh Kumar','K','ETS0716601','7','vigneshkumar.k@actsupport.com','Junior System Administrator','1q2w3e','Permanent'),(35,'Rajkumar ','','EMM1003050','3','raj@amulya.biz','Chief Creative Officer','1q2w3e','Permanent'),(36,'Janarthanan','','EMM0406229','3','jana@amulya.biz','Lead - Developer','1q2w3e','Permanent'),(37,'J.K.Moorthii','','EMM0208243','3','moortthi@actmedia.net','Senior Web Designer','1q2w3e','Permanent'),(38,'Suresh','Abraham','EMM0708245','3','suresh@actmedia.net ','Senior Web Designer','1q2w3e','Permanent'),(39,'Pravinraj','Jayabalan','EMM0817623','3','pravinraj.jayabalan@actmedia.net ','UX Developer','1q2w3e','Probation'),(40,'Shanmugha','Prakash','EMM1217633','3','shanmughaprakash.s@actmedia.net','UX Developer','1q2w3e','Probation'),(41,'Sankaralingam','','EMM0118634','3','sankaralingam.r@actmedia.com','UX Developer','1q2w3e','Probation'),(42,'Sunil','Josh','ECB1010001','4','sunil@amulya.biz ','Chief Sales Officer','1q2w3e','Permanent'),(43,'Shiji','K','EBD0515571','5','shiji.kumaran@amulya.biz','HR Manager & Quality Head','1q2w3e','Permanent'),(44,'Ganesan','','EQC1111460','6','ganesan.k@amulya.biz','Senior Quality Analyst','1q2w3e','Permanent'),(45,'SUMATHI','P','EQC0516596','6','sumathi.p@actsupport.com','Junior Quality Analyst','1q2w3e','Permanent'),(46,'Kasthuri','S M','EQC0716600','6','kasthuri.sm@actsupport.com','Junior Quality Analyst','1q2w3e','Permanent'),(47,'SriLatha','C','EHR0917628','5','srilatha@amulya.biz','HR Executive','1q2w3e','Permanent'),(48,'Srikanth','','ETS0611432','2','srikanth.b@actsupport.com','Senior Systems Engineer','1q2w3e','Permanent');

--
-- Table structure for table `employee_bk`
--

CREATE TABLE `employee_bk` (
  `EmpID` int(11) NOT NULL AUTO_INCREMENT,
  `EmployeeFirstName` varchar(150) DEFAULT NULL,
  `EmployeeLastName` varchar(45) DEFAULT NULL,
  `EmployeeInitials` varchar(45) DEFAULT NULL,
  `EmployeeCode` varchar(50) DEFAULT NULL,
  `EmployeeGender` enum('M','F') DEFAULT NULL,
  `EmployeeCitizenship` varchar(45) DEFAULT NULL,
  `EmployeeDateofbirth` date DEFAULT NULL,
  `EmployeeBloodGroup` varchar(10) DEFAULT NULL,
  `EmployeeMobile` varchar(16) DEFAULT NULL,
  `EmployeeResidencePhone` varchar(45) DEFAULT NULL,
  `EmployeeMaritalStatus` varchar(45) DEFAULT NULL,
  `EmployeeWeddingDay` date DEFAULT NULL,
  `EmployeeEmergencyLandline` varchar(45) DEFAULT NULL,
  `EmployeeRelationship` varchar(45) DEFAULT NULL,
  `EmployeeEmergencyMobile` int(11) DEFAULT NULL,
  `EmployeePassportNumber` varchar(45) DEFAULT NULL,
  `EmployeePassportExpiryDate` date DEFAULT NULL,
  `EmployeeVisaNumber` varchar(45) DEFAULT NULL,
  `EmployeeVisaExpiryDate` varchar(45) DEFAULT NULL,
  `EmployeePermanentAddress` varchar(250) DEFAULT NULL,
  `EmployeePresentAddress` varchar(250) DEFAULT NULL,
  `EmployeeBankAccNumber` varchar(45) DEFAULT NULL,
  `EmployeePhoto` varchar(100) DEFAULT NULL,
  `EmployeeDepartment` varchar(45) DEFAULT NULL,
  `EmployeeEmailID` varchar(150) DEFAULT NULL,
  `EmployeeLocation` varchar(45) DEFAULT NULL,
  `EmployeeDesignation` varchar(45) DEFAULT NULL,
  `EmployeeExtension` varchar(45) DEFAULT NULL,
  `EmployeeSkypeID` varchar(45) DEFAULT NULL,
  `EmployeePassword` varchar(50) DEFAULT NULL,
  `EmployeeType` varchar(2) NOT NULL,
  `EmployeeCreatedDate` datetime NOT NULL,
  `EmployeeLastLogin` datetime NOT NULL,
  `IPAddress` varchar(20) NOT NULL,
  PRIMARY KEY (`EmpID`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `employee_bk`
--

INSERT INTO `employee_bk` VALUES (1,'administrator',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'jana@amulya.biz',NULL,NULL,NULL,NULL,'123123','A','0000-00-00 00:00:00','2013-04-24 17:23:34','127.0.0.1'),(2,'testuser2','testte',NULL,'546565656',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'AmulyaSoft','test@test22.com',NULL,'employee',NULL,NULL,'1234','E','2013-04-14 14:47:26','0000-00-00 00:00:00',''),(3,'testhr','testte',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'HR','testhr@actmedia.net',NULL,NULL,NULL,NULL,'123123','M','2013-04-14 14:47:26','0000-00-00 00:00:00',''),(4,'testhead','testte',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'AmulyaSoft','test@testhead.com',NULL,NULL,NULL,NULL,'123123','M','2013-04-14 14:47:26','0000-00-00 00:00:00',''),(5,'Roopa','Prabhakar',NULL,'E3849384','F',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'roopatest@amulya.biz',NULL,'MD',NULL,NULL,'123456','R','0000-00-00 00:00:00','0000-00-00 00:00:00','');

--
-- Table structure for table `employee_bk2`
--

CREATE TABLE `employee_bk2` (
  `EmpID` int(11) NOT NULL AUTO_INCREMENT,
  `EmployeeFirstName` varchar(150) DEFAULT NULL,
  `EmployeeLastName` varchar(45) DEFAULT NULL,
  `EmployeeCode` varchar(40) NOT NULL,
  `EmployeeDepartment` varchar(45) DEFAULT NULL,
  `EmployeeEmailID` varchar(150) DEFAULT NULL,
  `EmployeeDesignation` varchar(45) DEFAULT NULL,
  `EmployeePassword` varchar(50) DEFAULT '1q2w3e',
  `EmployeeType` varchar(2) NOT NULL,
  PRIMARY KEY (`EmpID`)
) ENGINE=InnoDB AUTO_INCREMENT=99 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `employee_bk2`
--

INSERT INTO `employee_bk2` VALUES (1,'SunilJose','Manikam','ECB1010001','BD','sunil@amulya.biz','Chief Sales Offer','1q2w3e','M'),(2,'Mohan ','Leo Francis','ETS0308276','BD','mleo@amulya.biz','Assistant Business Development Manager','1q2w3e','E'),(3,'Sreenath ','Punakkal','EMM0911450','BD','sreenath@amulya.biz','Senior Online Marketing Manager','1q2w3e','E'),(4,'Rajkumar ','Sivamurthi','EMM1003050','Amulya Soft','raj@amulya.biz','Chief Creative Officer / Head ? Amulya Soft','1q2w3e','M'),(5,'Revathi ','Senthil','EMM0904109','Amulya Soft','revathy@amulya.biz','Project Manager','1q2w3e','E'),(6,'Janarthanan ','Veerasamy','EMM0406228','Amulya Soft','jana@amulya.biz','Lead Developer','1q2w3e','E'),(7,'Kayalvizhi ','Thiruvel','EMM0108242','Amulya Soft','kayal@amulya.biz','Senior PHP Programmer','1q2w3e','E'),(8,'Moorthi ','Jagannathan Krishna','EMM0208243','Amulya Soft','moortthi@actmedia.net','Senior Web Designer','1q2w3e','E'),(9,'Suresh ','Abraham ','EMM0708245','Amulya Soft','suresh@actmedia.net','Senior Web Designer','1q2w3e','E'),(10,'Udayan ','Vasu','EMM0908246','Amulya Soft','uday@amulya.biz','Senior PHP Programmer','1q2w3e','E'),(11,'Kumaresan ','Kandaswamy','EMM1108248','Amulya Soft','kumaresan@actmedia.net','Senior Flash Designer','1q2w3e','E'),(12,'Vani ','Ganesan','EBD1009237','Amulya Soft','vani.g@amulya.biz','Internet Marketing Analyst','1q2w3e','E'),(13,'Mahesh ','Amirthalingam','EMM0310358','Amulya Soft','mahesh@actmedia.net','Web Developer','1q2w3e','E'),(14,'Joseph ','Amaldas','EMM0310367','Amulya Soft','joseph@actmedia.net','Web designer','1q2w3e','E'),(15,'Periyasamy ','Kanagaraj','EMM1210402','Amulya Soft','samy@actmedia.net','Web designer','1q2w3e','E'),(16,'Arun ','Ramasamy','EBD0911449','Amulya Soft','arun.r@amulya.biz','Assistant Client Relations Manager','1q2w3e','E'),(17,'Elvis ','Williams','EMM1208252','Amulya Soft','elvis@actmedia.net','Software Engineer','1q2w3e','E'),(18,'Franklyn ','Stephen Issac','EMM0312473','Amulya Soft','franklyn.sij@amulya.biz','SEO Executive','1q2w3e','E'),(19,'Gowtham ','Kamalakannan','EMM0312474','Amulya Soft','gowtham.k@actmedia.net','XHTML/CSS Coder','1q2w3e','E'),(20,'Vijayakumar ','Arunachalam','EMM0412475','Amulya Soft','vijayakumar@actmedia.net','Junior PHP Programmer','1q2w3e','E'),(21,'Visveshwaran ','Venkateshwaran','EMM0512477','Amulya Soft','visveshwaran.bv@actmedia.ne','Web Developer','1q2w3e','E'),(22,'Chinnaraju ','Rayappachettiar','EMM0712480','Amulya Soft','raju@actmedia.net','Web Developer','1q2w3e','E'),(23,'Shruti ','Menon','EMM0812485','Amulya Soft','smenon@actmedia.net','Junior PHP Programmer','shruti@actmedia','E'),(24,'Vasanthakumar','Doraisamy','ETS0104076','Amulya IT Enterprise Services','vasanth@amulya.biz','Principal Engineer / Head ? Enterprises Servi','1q2w3e','M'),(25,'Jithesh ','Sreedharan Nair','ETS0711444','Amulya IT Enterprise Services','jithesh.p@amulya.biz','Senior Technical Support Engineer','1q2w3e','E'),(26,'Rahul ','Somarajan','ETS0711445','Amulya IT Enterprise Services','rahul.s@amulya.biz','Technical Support Engineer','1q2w3e','E'),(27,'Prosper ','Gnanasekar','ETS0811447','Amulya IT Enterprise Services','prosper.e@amulya.biz','Senior Technical Support Engineer','1q2w3e','E'),(28,'Thousif ','Ahamed','ECS0709294','Amulya IT Enterprise Services','thousif@amulya.biz','Technical Support Engineer','1q2w3e','E'),(29,'Balakrishnan ','Natarajan','ETS0605170','Amulya IT','balakrishnan@actsupport.com, balakrishnan@amulya.biz','Technical Lead / Head ? IT Infrastructure','1q2w3e','M'),(30,'Sathishkannan','Soundarajan','ETS0705173','Amulya IT','sathishkannan@amulya.biz','Technical Lead  ','1q2w3e','E'),(31,'Arokianathan ','Antony','ECS0806249','Amulya IT','mike@amulya.biz','Head ? Web Hosting Support','1q2w3e','M'),(32,'Shiji ','Kumaran','ECS0308256','Amulya IT','shiji.k@amulya.biz','Team Lead','1q2w3e','E'),(33,'Sundareswaran ','Velmurugan','ETS1108292','Amulya IT','sundar@amulya.biz','Senior System administrator','1q2w3e','E'),(34,'Subash ','Chandra Bose','ECS1108272','Amulya IT','subash.c.bose@actsupport.com','Senior Systems Engineer','1q2w3e','E'),(35,'Arvind ','Thiyagarajan','ECS0409285','Amulya IT','arvind@amulya.biz','Assistant Manager ? Support Services','1q2w3e','E'),(36,'Anandaprabhu','Rajendran','ECS0809325','Amulya IT','anandaprabu.r@actsupport.com','Senior Systems Engineer','1q2w3e','E'),(37,'Venkatesh ','Mothinath','ETS1209343','Amulya IT','venkatesh.v@actsupport.com','Senior Systems Engineer','1q2w3e','E'),(38,'Santhanagopalan ','K','ECS0110348','Amulya IT','santhanagopalan.k@actsupport.com','Assistant Team Lead','1q2w3e','E'),(39,'Lingaraj ','Mathan ','ECS0110349','Amulya IT','lingarajd.m@actsupport.com','Senior Systems Engineer','1q2w3e','E'),(40,'Vinothkumar','Surenderan','ECS0310360','Amulya IT','vinothkumar.s@actsupport.com','Assistant Technical Lead','1q2w3e','E'),(41,'Rameshkumar','Nataraj','ETS0410370','Amulya IT','rameshkumar.n@actsupport.com','Senior Systems Engineer','1q2w3e','E'),(42,'Leo ','Simon','ETS0410373','Amulya IT','leosimon.y@actsupport.com','Systems Engineer','1q2w3e','E'),(43,'Selvakumar ','Mani ','ETS1210399','Amulya IT','Selvakumar.m@actsupport.com','Senior Systems Engineer','1q2w3e','E'),(44,'Sankar ','Seerangan','ETS1210403','Amulya IT','sankar.s@actsupport.com','Senior System administrator','1q2w3e','E'),(45,'Naidu ','Prem Kumar ','ECS0111406','Amulya IT','naidu.premkumar@actsupport.com','Systems Engineer','1q2w3e','E'),(46,'Dhinakaran ','Gnanaraj','ECS0311420','Amulya IT','dhinakaran.g@actsupport.com','Systems Engineer','1q2w3e','E'),(47,'KarthikKannan','Viswanathan','ETS0311424','Amulya IT','karthikkannan.v@actsupport.com','Senior Internet Research Analyst','1q2w3e','E'),(48,'Rajkumar ','Krishnan ','ETS0311427','Amulya IT','rajkumar.k@actsupport.com','Systems Engineer','1q2w3e','E'),(49,'Dinesh ','Somasundaram','ETS0611431','Amulya IT','dinesh.s@actsupport.com','Junior Systems Engineer','1q2w3e','E'),(50,'Srikanth ','Balasubramaniam','ETS0611432','Amulya IT','srikanth.b@actsupport.com','Junior Systems Engineer','1q2w3e','E'),(51,'Bharathi ','Uthamasamy','ETS0611437','Amulya IT','bharathi.u@actsupport.com','Systems Engineer','1q2w3e','E'),(52,'Vijayaraj ','Rangasamy','ETS0711442','Amulya IT','vijayaraj.r@actsupport.com','Junior Systems Engineer','1q2w3e','E'),(53,'Shanmugam ','Ramlakshman','ETS0711441','Amulya IT','shanmugam.rl@actsupport.com','Junior Systems Engineer','1q2w3e','E'),(54,'Joseph ','Martin','ETS0911448','Amulya IT','joseph.m@actsupport.com','Systems Engineer','1q2w3e','E'),(55,'Nithya ','Shankari ','ECS0911451','Amulya IT','nithyashankari.n@actsupport.com','Systems Engineer','1q2w3e','E'),(56,'Anand ','Sakthivel','ETS1111456','Amulya IT','anand.sakthivel@actsupport.com','Junior Systems Engineer','1q2w3e','E'),(57,'Shankaranarayanan ','Ramamoorthy','ETS1111457','Amulya IT','shankaranarayanan.r@actsupport.com','Senior Systems Engineer','1q2w3e','E'),(58,'Deepak ','Latcham','ETS1111458','Amulya IT','deepak.l@actsupport.com','Systems Engineer','1q2w3e','E'),(59,'Shamith ','M V','ETS1111459','Amulya IT','shamith.mv@actsupport.com','Senior Systems Engineer','1q2w3e','E'),(60,'Easwaran ','Mohanraj','ETS0312470','Amulya IT','easwaran.m@actsupport.com','Junior System Administrator','1q2w3e','E'),(61,'Jeff ','Antony Paulson','ECS0312471','Amulya IT','j_a_paulson@actsupport.com','Junior Systems Engineer','1q2w3e','E'),(62,'Gnanaraj','Thomas','ETS0812487','Amulya IT','gnanaraj.t@actsupport.com','Systems Engineer ','1q2w3e','E'),(63,'Lavanya ','Sudakkar','ETS0612479','Amulya IT','lavanya.s@actsupport.com','Internet Research Analyst','1q2w3e','E'),(64,'Elvis ','Jordan','ECS0612478','Amulya IT','elvisjordan.s@actsupport.com','Junior Systems Engineer','1q2w3e','E'),(65,'Karthik   ','Krishnamoorthy','ETS0812482','Amulya IT','karthik.k@actsupport.com','Junior Systems Engineer','1q2w3e','E'),(66,'Ronald ','VivianJeffrey','ECS0812483','Amulya IT','ronaldvivian.jeffrey@actsupport.com','Junior Systems Engineer','1q2w3e','E'),(67,'VigneshRam','Sukkarappan','ETS0812484','Amulya IT','vigneshram.s@actsupport.com','Systems Engineer','1q2w3e','E'),(68,'Ambrose ','Rinald ','ECS0812486','Amulya IT','ambroserinald.j@actsupport.com','Senior Systems Engineer','1q2w3e','E'),(69,'Rajesh ','Sitrambalam','ETS0912488','Amulya IT','rajesh.sb@actsupport.com','Junior Systems Engineer','1q2w3e','E'),(70,'Balashankar ','Dharmarajan','ETS0912489','Amulya IT','balashankar.d@actsupport.com','Systems Engineer','1q2w3e','E'),(71,'Mukesh ','Mani ','ETS0912490','Amulya IT','mukesh.m@actsupport.com','Junior Systems Engineer','1q2w3e','E'),(72,'Shyam ','Sri Srinivasan','ETS0213493','Amulya IT','shyamsri.s@actsupport.com','Junior Data Analyst','1q2w3e','E'),(73,'Parthasarathy ','Narasimha Raghavan','ETS0213494','Amulya IT','parthasarathy.pn@actsupport.com  ','Junior Data Analyst','1q2w3e','E'),(74,'Ashok kumar','Muthusamy','ETS0313496','Amulya IT','ashokkumar.m@actsupport.com','Junior Data Analyst','1q2w3e','E'),(75,'Prem ','Balasubramanian','ETS0313498','Amulya IT','prem.b@actsupport.com','Customer Support Executive','1q2w3e','E'),(76,'Vinothkumar','Nageswaran','ETS0313499 ','Amulya IT','vinothkumar.n@actsupport.com','Customer Support Executive','1q2w3e','E'),(77,'Dilip','Indiran','ETS0413500','Amulya IT','dilip.i@actsupport.com','Customer support executive','1q2w3e','E'),(78,'Mohammed ','Ismail','ETS0413501','Amulya IT','mohammedismail.mj@actsupport.com','Junior Data Analyst','1q2w3e','E'),(79,'Praveen ','Mathews','ETS0413503','Amulya IT','praveenmathews.m@actsupport.com','Junior Data Analyst','1q2w3e','E'),(80,'Parthipan ','Kandasamy','ETS0413502','Amulya IT','parthipan.k@actsupport.com','Customer Support Executive','1q2w3e','E'),(81,'SriRam ','Prasad','ETS0413505','Amulya IT','Sriramprasad.S@actsupport.com','Junior Data Analyst','1q2w3e','E'),(82,'Praveen ','Varma','ETS0413506','Amulya IT','Praveen.M.Varma@actsupport.com','Customer Support Executive','1q2w3e','E'),(83,'Gayathri ','Paramasivam','EHR0108222','HR','gayathri.paramasivam@amulya.biz','Assistant Manager ? HR','1q2w3e','M'),(84,'Nimisha ','Francis','EHR1211464','HR','nimisha.f@amulya.biz','Junior HR Executive','1q2w3e','E'),(85,'Manimegalai ','Murugan','EHR0312472','HR','manimegalai.m@amulya.biz','Recruiter','1q2w3e','E'),(86,'Vigram ','Kumar','EQC0611438','Quality','vigram@amulya.biz','Quality Head','1q2w3e','M'),(87,'Bearnadette','Nancy','ECS1108273','Quality','nancy.a@amulya.biz','Assistant Team Lead','1q2w3e','E'),(88,'Ganesan ','K','EQC1111460','Quality','ganesan.k@amulya.biz','Quality Analyst','1q2w3e','E'),(89,'Harish','Raj ','EQC1211465','Quality','harish.r@amulya.biz','Junior Quality Analyst','1q2w3e','E'),(90,'Gowtham ','Sundaram','EQC0112466','Quality','gowtham.s@amulya.biz','Junior Quality Analyst','1q2w3e','E'),(91,'Ravi ','Kumar ','ECS0308258','Amulya CS','ravi@amulya.biz','Support Manager','1q2w3e','E'),(92,'Nithya ','Krishnamurthy','ETS0413509','Amulya CS','nithya.k@actsupport.com','Data Analyst','1q2w3e','E'),(93,'Jasmine','Priscilla','ETS0413508','Amulya CS','jasmine.priscilla@actsupport.com','Data Analyst','1q2w3e','E'),(94,'Mohammed ','Haneef','ETS0413511','Amulya CS','Mohammedhaneef.S@actsupport.com','Data Analyst','1q2w3e','E'),(95,'Suganya ','Kumaresan','ETS0413512','Amulya CS','Suganya.k@actsupport.com','Junior Data Analyst','1q2w3e','E'),(96,'Aishwarya','Sekhar','ETS0413513','Amulya CS','Ayswarya.sekhar@actsupport.com','Customer Support Executive','1q2w3e','E'),(97,'Mohammed ','Yasir','ETS0413514','Amulya CS','mohammadyasir.s@actsupport.com','Junior Data Analyst','1q2w3e','E'),(98,'Sikkander','Basha','ETS0413515','Amulya CS','sikkandarbasha.a@actsupport.com','Junior Data Analyst','1q2w3e','E');

--
-- Table structure for table `latearrival`
--

CREATE TABLE `latearrival` (
  `LateArrivalID` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `EmpID` varchar(20) NOT NULL,
  `LateArrivalDate` date NOT NULL,
  `ReportingTime` varchar(10) NOT NULL,
  `DurationInMinutes` int(10) NOT NULL,
  `Reason` varchar(40) NOT NULL,
  `InformedThrough` varchar(20) DEFAULT NULL,
  `InformedTo` varchar(20) DEFAULT NULL,
  `Status` enum('pending','approved','rejected') NOT NULL,
  PRIMARY KEY (`LateArrivalID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `latearrival`
--

INSERT INTO `latearrival` VALUES (0000000001,'546565656','2013-04-08','11-12',10,'hiii','NA','NA','pending'),(0000000002,'546565656','0000-00-00','',0,'','NA','NA','pending');

--
-- Table structure for table `leave`
--

CREATE TABLE `leave` (
  `LeaveID` int(11) NOT NULL AUTO_INCREMENT,
  `EmpID` varchar(50) DEFAULT NULL,
  `LeaveType` varchar(40) DEFAULT NULL,
  `ReasonForLeave` varchar(250) DEFAULT NULL,
  `LeaveFrom` date DEFAULT NULL,
  `LeaveTill` date DEFAULT NULL,
  `HoursTaken` varchar(45) DEFAULT NULL,
  `Status` enum('pending','approved','rejected') NOT NULL,
  `del_flag` tinyint(1) NOT NULL,
  PRIMARY KEY (`LeaveID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `leave`
--


--
-- Table structure for table `leavetype`
--

CREATE TABLE `leavetype` (
  `LeaveTypeID` int(11) NOT NULL AUTO_INCREMENT,
  `LeaveType` varchar(45) DEFAULT NULL,
  `MaximumLeave` int(11) DEFAULT NULL,
  `Remarks` varchar(45) DEFAULT NULL,
  `OrgID` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`LeaveTypeID`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `leavetype`
--

INSERT INTO `leavetype` VALUES (1,'Casual Leave',NULL,NULL,NULL),(2,'Unpaid Leave (LOP)',NULL,NULL,NULL),(3,'Sick Leave',NULL,NULL,NULL),(4,'Compensatory Leave',NULL,NULL,NULL),(5,'Onduty',NULL,NULL,NULL);

--
-- Table structure for table `menus`
--

CREATE TABLE `menus` (
  `MenuID` bigint(20) NOT NULL AUTO_INCREMENT,
  `MenuName` varchar(200) NOT NULL,
  `MenuLink` varchar(255) NOT NULL,
  `Status` enum('Y','N') NOT NULL DEFAULT 'Y',
  `ParentID` int(10) NOT NULL,
  PRIMARY KEY (`MenuID`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `menus`
--

INSERT INTO `menus` VALUES (1,'logout','logout','Y',0),(2,'main','main','Y',0),(3,'login','login','Y',0),(4,'viewemployees','viewemployees','Y',0),(5,'client','client','Y',0),(6,'alert','alert','Y',0),(7,'report','report','Y',0),(8,'settings','settings','Y',0),(9,'pagination','pagination','Y',0),(10,'Add Employee','employee','Y',4),(11,'viewemployees/employee','viewemployees/employee','Y',0);

--
-- Table structure for table `organization`
--

CREATE TABLE `organization` (
  `OrgID` int(11) NOT NULL AUTO_INCREMENT,
  `OrganizationName` varchar(100) DEFAULT NULL,
  `OrganizationDescription` blob,
  `OrganizationMainUser` int(11) DEFAULT NULL,
  `OrganizationAddress` varchar(250) DEFAULT NULL,
  `OrganizationCity` varchar(55) DEFAULT NULL,
  `OrganizationState` varchar(55) DEFAULT NULL,
  `OrganizationCountry` varchar(55) DEFAULT NULL,
  PRIMARY KEY (`OrgID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `organization`
--


--
-- Table structure for table `permission`
--

CREATE TABLE `permission` (
  `PermissionID` int(11) NOT NULL AUTO_INCREMENT,
  `EmpID` varchar(50) DEFAULT NULL,
  `NoOfHours` varchar(10) DEFAULT NULL,
  `PermissionDate` date DEFAULT NULL,
  `ReasonForPermission` varchar(200) DEFAULT NULL,
  `PermissionTime` varchar(45) DEFAULT NULL,
  `InformedThrough` varchar(45) DEFAULT NULL,
  `InformedTo` varchar(65) DEFAULT NULL,
  `Status` enum('pending','approved','rejected') NOT NULL,
  `del_flag` tinyint(1) NOT NULL,
  PRIMARY KEY (`PermissionID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `permission`
--


--
-- Table structure for table `role`
--

CREATE TABLE `role` (
  `RoleID` int(3) NOT NULL AUTO_INCREMENT,
  `RoleName` varchar(200) NOT NULL,
  `RoleShortCode` varchar(2) NOT NULL,
  `Status` enum('Y','N') NOT NULL DEFAULT 'Y',
  PRIMARY KEY (`RoleID`),
  UNIQUE KEY `RoleShortCode` (`RoleShortCode`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `role`
--

INSERT INTO `role` VALUES (1,'MasterUser','MU','Y'),(2,'Administrator','AM','Y'),(3,'Department Head','DH','Y'),(4,'Human Resource','HR','Y'),(5,'Business Development','BD','Y'),(6,'Employee','EM','Y'),(7,'Trainee','TR','Y');

--
-- Table structure for table `workexperience`
--

CREATE TABLE `workexperience` (
  `WorkExpID` int(11) NOT NULL AUTO_INCREMENT,
  `Employer` varchar(250) DEFAULT NULL,
  `JobTitle` varchar(100) DEFAULT NULL,
  `FromDate` date DEFAULT NULL,
  `ToDate` date DEFAULT NULL,
  `EmpID` int(11) DEFAULT NULL,
  PRIMARY KEY (`WorkExpID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `workexperience`
--



