-- http://www.phpmyadmin.net
--


--
-- Database: `employee`
--
CREATE DATABASE `employee` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `employee`;

-- --------------------------------------------------------

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

CREATE TABLE IF NOT EXISTS `departments` (
  `department_id` int(12) unsigned NOT NULL auto_increment,
  `department_name` varchar(300) NOT NULL,
  `department_enabled` char(1) NOT NULL default 'Y',
  `department_posted_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`department_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

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

INSERT INTO `departments` (`department_id`, `department_name`, `department_enabled`, `department_posted_time`) VALUES
(1, 'Admin', 'Y', '2009-07-14 16:51:07');

-- --------------------------------------------------------

--
-- Table structure for table `employees`
--

CREATE TABLE IF NOT EXISTS `employees` (
  `emp_id` int(12) unsigned NOT NULL auto_increment,
  `department_id` int(12) NOT NULL,
  `emp_username` varchar(300) NOT NULL,
  `emp_password` varchar(300) NOT NULL,
  `emp_firstname` varchar(300) NOT NULL,
  `emp_lastname` varchar(300) NOT NULL,
  `emp_emailid` varchar(300) NOT NULL,
  `emp_dob` date NOT NULL,
  `emp_gender` char(1) NOT NULL default 'M',
  `emp_salary` int(10) NOT NULL,
  `emp_enabled` char(1) NOT NULL default 'Y',
  `emp_posted_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`emp_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `employees`
--

INSERT INTO `employees` (`emp_id`, `department_id`, `emp_username`, `emp_password`, `emp_firstname`, `emp_lastname`, `emp_emailid`, `emp_dob`, `emp_gender`, `emp_salary`, `emp_enabled`, `emp_posted_time`) VALUES
(1, 1, 'admin', '21232f297a57a5a743894a0e4a801fc3 ', 'admin', 'admin', 'admin@admin.com', '2009-07-18', 'M', 12345, 'Y', '2009-07-18 13:00:13'),
(2, 1, 'chaitanya', '1eaf7c068a250a38e3bab770053c14c3', 'chaitanya', 'lakshmi', 'chaitanya@jiva.com', '0000-00-00', 'F', 234123121, 'Y', '2009-07-18 13:03:20');
