-- phpMyAdmin SQL Dump
-- version 2.6.0-beta2
-- http://www.phpmyadmin.net
-- 
-- Serveur: localhost
-- Généré le : Lundi 18 Octobre 2004 à 15:45
-- Version du serveur: 4.0.21
-- Version de PHP: 4.3.9-1
-- 
-- Base de données: `test`
-- 

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

-- 
-- Structure de la table `customer`
-- 

-- 
-- Structure de la table `timeentry`
-- 

CREATE TABLE `punch` (
  `id` int(11) NOT NULL auto_increment,
  `start` datetime NOT NULL default '0000-00-00 00:00:00',
  `end` datetime NOT NULL default '0000-00-00 00:00:00',
  `uid` int(100) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

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

-- 
-- Structure de la table `user`
-- 

CREATE TABLE IF NOT EXISTS `user` (
  `id` int(11) NOT NULL auto_increment,
  `email` varchar(255) NOT NULL default '',
  `password` varchar(32) NOT NULL default '',
  `longname` varchar(100) NOT NULL default '',
  `address` mediumtext NOT NULL,
  `prefs` text NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `email` (`email`)
) TYPE=MyISAM;

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

CREATE TABLE `password_ticket` (
`ticket` CHAR( 32 ) NOT NULL ,
`user` VARCHAR( 255 ) NOT NULL ,
`expires` INT NOT NULL ,
PRIMARY KEY ( `ticket` ) ,
INDEX ( `expires` )
) COMMENT = 'password reset table';
