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;

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;

 CREATE TABLE dhcphosts_networks_vlans (
  id int(11) default NULL,
  vlan int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8

CREATE TABLE nmslog (
  seq int(10) unsigned NOT NULL auto_increment,
  local_time timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  client_ip varchar(32) default NULL,
  uid int(11) default NULL,
  VLAN int(11) default NULL,
  MODULE int(11) default NULL,
  PORT int(11) default NULL,
  MAC varchar(32) default NULL,
  SWITCH varchar(32) default NULL,
  username varchar(32) default NULL,
  client_net int(11) default NULL,
  msg text,
  log_reason varchar(255) default "info", 
  PRIMARY KEY  (seq)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;