-- phpMyAdmin SQL Dump
-- version 2.11.0
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 22, 2009 at 12:14 PM
-- Server version: 5.0.45
-- PHP Version: 5.1.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

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

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

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` mediumint(9) NOT NULL auto_increment,
  `empnum` varchar(5) NOT NULL,
  `lastin` time NOT NULL,
  `lastout` time NOT NULL,
  `comments` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `empnum` (`empnum`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `empnum`, `lastin`, `lastout`, `comments`) VALUES
(1, '12345', '00:00:00', '00:00:00', 'Uncle Ward'),
(2, '23456', '00:00:00', '00:00:00', 'Miss Mary');