-- phpMyAdmin SQL Dump

-- version 3.4.5

-- http://www.phpmyadmin.net

--

-- Host: localhost

-- Generation Time: Dec 09, 2011 at 03:20 PM

-- Server version: 5.1.52

-- PHP Version: 5.2.9

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

SET time_zone = "+00:00";

/*!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 */;

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

--

-- Table structure for table `timecards`

--

CREATE TABLE IF NOT EXISTS `timecards` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`client` varchar(100) NOT NULL,

`punch` datetime NOT NULL,

`comment` longtext NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=245 ;

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

--

-- Table structure for table `users`

--

CREATE TABLE IF NOT EXISTS `users` (

`user_id` int(10) unsigned NOT NULL AUTO_INCREMENT,

`user_full_name` varchar(50) DEFAULT NULL,

`user_email` varchar(255) NOT NULL DEFAULT '',

`username` varchar(45) DEFAULT NULL,

`user_pass` varchar(60) NOT NULL DEFAULT '',

`user_role` varchar(45) DEFAULT NULL,

`user_ver_code` varchar(150) NOT NULL,

`user_verified` tinyint(1) NOT NULL DEFAULT '0',

`created_on` datetime NOT NULL,

`updated_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

`user_last_login` datetime DEFAULT NULL,

PRIMARY KEY (`user_id`),

UNIQUE KEY `user_email` (`user_email`),

UNIQUE KEY `username` (`username`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;