2 CREATE TABLE IF NOT EXISTS `upnp` (
3 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
4 `name` varchar(128) NOT NULL,
5 `class` varchar(64) NOT NULL,
6 `protocol` varchar(3) NOT NULL,
7 `port` int(10) unsigned NOT NULL,
8 `mandatory` tinyint(3) unsigned NOT NULL,
9 `enabled` tinyint(3) unsigned NOT NULL,
10 `lastcheck` datetime NOT NULL,
11 `lastupdate` datetime NOT NULL,
12 `action` enum('CREATE','OK','DISABLE','ENABLE','DELETE','DELETING') NOT NULL DEFAULT 'CREATE',
13 `result` varchar(128) NOT NULL,
15 ) ENGINE=MyISAM COMMENT='UPnP port forwards and their status.';