 
 
 -- -----------------------------------------------------
--- Table `s4t-iotronic`.`measures`
--- -----------------------------------------------------
-DROP TABLE IF EXISTS `s4t-iotronic`.`measures` ;
-
-CREATE TABLE IF NOT EXISTS `s4t-iotronic`.`measures` (
-  `id` INT(11) NOT NULL AUTO_INCREMENT,
-  `name` VARCHAR(20) NOT NULL,
-  `read_plugin` VARCHAR(20) NOT NULL,
-  `elaborate_plugin` VARCHAR(20) NULL DEFAULT NULL,
-  PRIMARY KEY (`id`))
-ENGINE = InnoDB
-AUTO_INCREMENT = 9
-DEFAULT CHARACTER SET = utf8;
-
-
--- -----------------------------------------------------
--- Table `s4t-iotronic`.`measures_injected`
--- -----------------------------------------------------
-DROP TABLE IF EXISTS `s4t-iotronic`.`measures_injected` ;
-
-CREATE TABLE IF NOT EXISTS `s4t-iotronic`.`measures_injected` (
-  `board_id` INT(11) NOT NULL,
-  `measure_id` INT(11) NOT NULL,
-  `pin` VARCHAR(20) NOT NULL,
-  `period` DOUBLE NULL DEFAULT NULL,
-  `state` VARCHAR(20) NULL DEFAULT NULL)
-ENGINE = InnoDB
-DEFAULT CHARACTER SET = utf8;
-
-
--- -----------------------------------------------------
 -- Table `s4t-iotronic`.`plugins`
 -- -----------------------------------------------------
 DROP TABLE IF EXISTS `s4t-iotronic`.`plugins` ;

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,
  `status` VARCHAR(45) NOT NULL,
  PRIMARY KEY (`id`, `id_board`),
  INDEX `fk_socat_connections_board_codes1_idx` (`id_board` ASC),

-- MySQL Script generated by MySQL Workbench
-- ven 10 mar 2017 15:47:03 CET
-- Model: New Model    Version: 1.0
-- MySQL Workbench Forward Engineering

