
USE `a3ncrr`;

--
-- Table structure for table `clockevent`
--

DROP TABLE IF EXISTS `clockevent`;
CREATE TABLE `clockevent` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `user` int(5) NOT NULL,
  `date` date NOT NULL,
  `time` time default NULL,
  `event` enum('start','end') NOT NULL,
  `type` enum('sick','holiday') default NULL,
  `descr` varchar(255) default NULL,
  PRIMARY KEY  (`id`),
  KEY `user` (`user`),
  KEY `date` (`date`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
