--
-- Host: localhost    Database: ipcam
-- ------------------------------------------------------


--
-- Table structure for table `camera_log`
--

CREATE TABLE `camera_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `device` int(11) unsigned DEFAULT NULL,
  `event` varchar(255) DEFAULT NULL,
  `status` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `camera_log`
--



