--
-- Host: localhost    Database: astricon2015
-- ------------------------------------------------------

CREATE TABLE `doorlogs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) DEFAULT NULL,
  `inserted` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `RESULT` char(4) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `doorlogs`
--

INSERT INTO `doorlogs` VALUES (1,20,'2015-09-16 19:01:25','OK'),(2,20,'2015-09-16 19:02:56','OK'),(3,20,'2015-09-16 19:04:09','OK'),(4,20,'2015-09-16 19:05:28','OK'),(5,20,'2015-09-16 19:07:02','OK'),(6,20,'2015-09-16 19:07:51','OK'),(7,20,'2015-09-16 19:08:46','OK'),(8,20,'2015-09-16 19:11:01','OK'),(9,20,'2015-09-16 19:13:21','OK'),(10,20,'2015-09-16 19:25:38','OK'),(11,111,'2015-09-30 13:47:52',''),(12,111,'2015-09-30 13:50:12','1'),(13,0,'2015-09-30 13:56:29',''),(14,211,'2015-09-30 14:01:45','1'),(15,111,'2015-09-30 14:02:46','88'),(16,7,'2015-09-30 14:24:47','7'),(17,9,'2015-09-30 14:27:28','99'),(18,9,'2015-09-30 14:28:23','9'),(19,0,'2015-09-30 14:28:39','9'),(20,79,'2015-09-30 14:54:56','99'),(21,20,'2015-10-01 13:07:00','OK'),(22,2147483647,'2015-10-08 19:09:25','Open'),(23,2147483647,'2015-10-08 19:10:43','Ok'),(24,2147483647,'2015-10-08 19:11:38',''),(25,2147483647,'2015-10-08 19:11:59','Ok'),(26,2147483647,'2015-10-08 19:12:20','Go a'),(27,20,'2015-10-08 19:20:35','OK');

--
-- Table structure for table `extensions`
--
