-- 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');
