CREATE TABLE `support` (
  `cname` varchar(255) NOT NULL,
  `uname` varchar(255) NOT NULL,
  `lastname` varchar(255) DEFAULT NULL,
  `firstname` varchar(255) DEFAULT NULL,
  `location` varchar(4) DEFAULT NULL,
  `domain` varchar(255) DEFAULT NULL,
  `ipv4` varchar(16) DEFAULT NULL,
  `mac` varchar(18) DEFAULT NULL,
  `type` varchar(3) DEFAULT NULL,
  `dhcp` char(1) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `remote` varchar(255) DEFAULT NULL,
  `comment` text,
  `ipv4s` varchar(16) DEFAULT NULL,
  PRIMARY KEY (`cname`,`uname`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |