 CREATE TABLE IF NOT EXISTS `s4t-iotronic`.`socat_connections` (
   `id` INT NOT NULL AUTO_INCREMENT,
   `id_board` VARCHAR(36) NOT NULL,
-  `port` INT(6) NOT NULL,
-  `ip_board` VARCHAR(45) NOT NULL,
-  `ip_server` VARCHAR(45) NOT NULL,
+  `port` INT(6) NULL,
+  `ip_board` VARCHAR(45) NULL,
+  `ip_server` VARCHAR(45) NULL,
   `status` VARCHAR(45) NOT NULL,
   PRIMARY KEY (`id`, `id_board`),
   INDEX `fk_socat_connections_board_codes1_idx` (`id_board` ASC),

DROP TABLE IF EXISTS `s4t-iotronic`.`reverse_cloud_services` ;

CREATE TABLE IF NOT EXISTS `s4t-iotronic`.`reverse_cloud_services` (
  `board_id` INT(8) NOT NULL,
  `service` VARCHAR(50) NOT NULL,
  `public_ip` VARCHAR(16) NOT NULL,
  `public_port` VARCHAR(5) NOT NULL,



-- -----------------------------------------------------
-- Table `s4t-iotronic`.`plugins`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `s4t-iotronic`.`plugins` ;
