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

DROP TABLE IF EXISTS `clockevent`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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','in','out') 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=52 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `clockperiod`
--

DROP TABLE IF EXISTS `clockperiod`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `clockperiod` (
  `start` date NOT NULL,
  `end` date NOT NULL,
  PRIMARY KEY (`start`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `clockuser`
--

DROP TABLE IF EXISTS `clockuser`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `clockuser` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `login` varchar(9) NOT NULL,
  `Firstnames` varchar(64) DEFAULT NULL,
  `Surname` varchar(64) NOT NULL,
  `Title` varchar(10) DEFAULT NULL,
  `Hours` int(3) unsigned NOT NULL,
  `EarliestArrive` time NOT NULL,
  `LatestArrive` time NOT NULL,
  `LunchStart` time NOT NULL,
  `LunchEnd` time NOT NULL,
  `EarliestDepart` time NOT NULL,
  `LatestDepart` time NOT NULL,
  PRIMARY KEY (`id`),
  KEY `login` (`login`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `clockuser`
--

LOCK TABLES `clockuser` WRITE;
/*!40000 ALTER TABLE `clockuser` DISABLE KEYS */;
INSERT INTO `clockuser` VALUES (1,'ncrr','Chris','Ritson','Mr',40,'08:50:00','10:00:00','12:00:00','14:30:00','16:00:00','18:00:00'),
(2,'namb10','Alex','Barfield','Mrs',37,'08:00:00','10:00:00','12:00:00','14:30:00','15:00:00','18:00:00');
/*!40000 ALTER TABLE `clockuser` ENABLE KEYS */;
UNLOCK TABLES;

