CREATE TABLE `ipcamera` (
  `sn` varchar(80) NOT NULL,
  `ip` varchar(20) DEFAULT NULL,
  `name` varchar(20) DEFAULT NULL,
  `lastupdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`sn`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8