Abills NMS

CREATE TABLE user_switch (
    uid int default NULL,
    switch_ip int default NULL,
    port int default NULL,
    vlan int default NULL
) TYPE=InnoDB;

dhcplog | CREATE TABLE `dhcplog` (
  `host` varchar(32) default NULL,
  `facility` varchar(10) default NULL,
  `priority` varchar(10) default NULL,
  `level` varchar(10) default NULL,
  `tag` varchar(10) default NULL,
  `date` date default NULL,
  `time` time default NULL,
  `program` varchar(15) default NULL,
  `msg` text,
  `seq` int(10) unsigned NOT NULL auto_increment,
  `local_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`seq`),
  KEY `host` (`host`),
  KEY `seq` (`seq`),
  KEY `program` (`program`),
  KEY `time` (`time`),
  KEY `date` (`date`),
  KEY `priority` (`priority`),
  KEY `facility` (`facility`)
) ENGINE=MyISAM AUTO_INCREMENT=72 DEFAULT CHARSET=latin1