Untitled

    "CREATE TABLE IF NOT EXISTS `hosts` ("+ _
      "`id` VARCHAR(255) NOT NULL ," +_
      "`address` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL ," +_
      "`port` INT NOT NULL ," +_
      "`available` INT(1) NOT NULL ,"+ _
      "`created` DATETIME NOT NULL ," +_
      "`modified` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ,"+ _
      "PRIMARY KEY ( `id` ) ," +_
      "UNIQUE KEY `host` ( `address`, `port`)"+ _
      ") ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci;"
 
 
        "INSERT INTO hosts (address, port, available, created) VALUES('192.168.1.1' , 5000, 1 , now()) " +_
        "ON DUPLICATE KEY UPDATE available=1"