java

-- phpMyAdmin SQL Dump
-- version 3.2.0.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 30, 2010 at 11:12 AM
-- Server version: 5.1.36
-- PHP Version: 5.3.0

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: `attendence`
--

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

--
-- Table structure for table `developer`
--

CREATE TABLE IF NOT EXISTS `developer` (
`date` date NOT NULL,
`logintime` time NOT NULL,
`logouttime` time NOT NULL,
`Achievements` varchar(255) NOT NULL,
`task` varchar(200) NOT NULL,
`signature` varchar(200) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `developer`
--

INSERT INTO `developer` (`date`, `logintime`, `logouttime`, `Achievements`, `task`, `signature`) VALUES
('2010-04-28', '00:00:00', '00:00:00', '', '', '0'),
('2010-04-28', '00:00:00', '00:00:00', '', '', '0'),
('2010-04-28', '00:00:00', '00:00:02', 'good task', 'maintannce', '33'),
('2010-04-16', '00:00:00', '03:55:56', 'dfdf', '', 'dfdsf'),
('2010-04-28', '11:57:19', '00:00:00', 'good', 'maintenance', '0'),
('2010-04-28', '00:00:00', '00:00:00', '', '', '0'),
('2010-04-28', '12:45:31', '12:12:21', 'completed', 'table design', ''),
('2010-04-28', '01:23:52', '00:00:00', 'not fully completed', 'documentation', ''),
('0000-00-00', '01:28:10', '00:00:00', '', '', ''),
('2010-04-28', '00:00:00', '01:41:30', '', '', ''),
('2010-04-29', '00:00:00', '00:00:00', '', '', ''),
('2010-04-25', '00:00:00', '00:00:00', '', '', ''),
('0000-00-00', '03:24:54', '00:00:00', '', '', ''),
('0000-00-00', '03:33:17', '00:00:00', '', '', ''),
('2010-04-24', '03:34:17', '00:00:00', '', '', ''),
('2010-04-11', '05:12:15', '00:00:00', '', '', ''),
('2010-04-22', '05:21:36', '00:00:00', '', '', ''),
('2010-04-04', '05:22:44', '00:00:00', '', '', ''),
('2010-04-22', '05:23:58', '00:00:00', '', '', ''),
('2010-04-04', '05:26:22', '00:00:00', '', '', ''),
('2010-04-04', '05:27:54', '00:00:00', '', '', ''),
('2010-04-29', '09:50:29', '00:00:00', '', '', ''),
('0000-00-00', '00:00:00', '00:00:00', '', '', ''),
('2010-04-30', '11:21:49', '00:00:00', '', '', ''),
('2010-04-24', '11:24:16', '00:00:00', '', '', ''),
('2010-04-23', '838:59:59', '00:00:00', '', '', ''),
('2010-04-30', '12:12:56', '00:00:00', '', '', ''),
('2010-04-04', '12:14:26', '00:00:00', '', '', ''),
('2010-04-13', '01:54:53', '00:00:00', '', '', ''),
('0000-00-00', '10:30:27', '00:00:00', '', '', ''),
('0000-00-00', '320:00:00', '00:00:00', '', '', ''),
('2010-04-17', '321:00:00', '00:00:00', '', '', ''),
('0000-00-00', '12:34:59', '00:00:00', '', '', ''),
('2010-04-20', '324:00:00', '00:00:00', '', '', '');

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

--
-- Table structure for table `login`
--

CREATE TABLE IF NOT EXISTS `login` (
`username` varchar(200) NOT NULL,
`password` varchar(200) NOT NULL,
`usertype` varchar(200) NOT NULL,
`userid` int(20) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`userid`),
UNIQUE KEY `password` (`password`),
UNIQUE KEY `password_2` (`password`),
UNIQUE KEY `password_3` (`password`),
KEY `password_4` (`password`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

--
-- Dumping data for table `login`
--

INSERT INTO `login` (`username`, `password`, `usertype`, `userid`) VALUES
('remya', 'remya', 'Manager', 9),
('renjini', 'renjini', 'Developer', 5),
('remya', 'sujith', 'Manager', 12),
('a', 'a', 'Developer', 13);

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

--
-- Table structure for table `manager`
--

CREATE TABLE IF NOT EXISTS `manager` (
`taskid` int(20) NOT NULL,
`date` date NOT NULL,
`m_name` varchar(200) NOT NULL,
`name` varchar(200) NOT NULL,
`task` varchar(200) NOT NULL,
`taskdetails` varchar(200) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `manager`
--

INSERT INTO `manager` (`taskid`, `date`, `m_name`, `name`, `task`, `taskdetails`) VALUES
(1, '2010-04-01', 'adsf', 'fda', 'fda', 'dfas'),
(2, '2010-04-02', 'dafs', 'fda', 'dasf', 'dfa');