Fix db
added plugins tables again Change-Id: Ieaa2054cff039c06051cc51c04a3cc52108c6612
This commit is contained in:
parent
a0b2874b71
commit
7799c82537
|
@ -133,6 +133,60 @@ ENGINE = InnoDB
|
|||
AUTO_INCREMENT = 10
|
||||
DEFAULT CHARACTER SET = utf8;
|
||||
|
||||
-- -----------------------------------------------------
|
||||
-- Table `iotronic`.`plugins`
|
||||
-- -----------------------------------------------------
|
||||
DROP TABLE IF EXISTS `iotronic`.`plugins` ;
|
||||
|
||||
CREATE TABLE IF NOT EXISTS `iotronic`.`plugins` (
|
||||
`created_at` DATETIME NULL DEFAULT NULL,
|
||||
`updated_at` DATETIME NULL DEFAULT NULL,
|
||||
`id` INT(11) NOT NULL AUTO_INCREMENT,
|
||||
`uuid` VARCHAR(36) NOT NULL,
|
||||
`name` VARCHAR(255) NULL DEFAULT NULL,
|
||||
`public` TINYINT(1) NOT NULL DEFAULT '0',
|
||||
`code` TEXT NULL DEFAULT NULL,
|
||||
`callable` TINYINT(1) NOT NULL,
|
||||
`parameters` TEXT NULL DEFAULT NULL,
|
||||
`extra` TEXT NULL DEFAULT NULL,
|
||||
`owner` VARCHAR(36) NOT NULL,
|
||||
PRIMARY KEY (`id`),
|
||||
UNIQUE INDEX `uuid` (`uuid` ASC))
|
||||
ENGINE = InnoDB
|
||||
AUTO_INCREMENT = 132
|
||||
DEFAULT CHARACTER SET = utf8;
|
||||
|
||||
-- -----------------------------------------------------
|
||||
-- Table `iotronic`.`injected_plugins`
|
||||
-- -----------------------------------------------------
|
||||
DROP TABLE IF EXISTS `iotronic`.`injection_plugins` ;
|
||||
|
||||
CREATE TABLE IF NOT EXISTS `iotronic`.`injection_plugins` (
|
||||
`created_at` DATETIME NULL DEFAULT NULL,
|
||||
`updated_at` DATETIME NULL DEFAULT NULL,
|
||||
`id` INT(11) NOT NULL AUTO_INCREMENT,
|
||||
`board_uuid` VARCHAR(36) NOT NULL,
|
||||
`plugin_uuid` VARCHAR(36) NOT NULL,
|
||||
`status` VARCHAR(15) NOT NULL DEFAULT 'injected',
|
||||
`onboot` TINYINT(1) NOT NULL DEFAULT '0',
|
||||
PRIMARY KEY (`id`),
|
||||
INDEX `board_uuid` (`board_uuid` ASC),
|
||||
CONSTRAINT `board_uuid`
|
||||
FOREIGN KEY (`board_uuid`)
|
||||
REFERENCES `iotronic`.`boards` (`uuid`)
|
||||
ON DELETE CASCADE
|
||||
ON UPDATE CASCADE,
|
||||
INDEX `plugin_uuid` (`plugin_uuid` ASC),
|
||||
CONSTRAINT `plugin_uuid`
|
||||
FOREIGN KEY (`plugin_uuid`)
|
||||
REFERENCES `iotronic`.`plugins` (`uuid`)
|
||||
ON DELETE CASCADE
|
||||
ON UPDATE CASCADE)
|
||||
ENGINE = InnoDB
|
||||
AUTO_INCREMENT = 132
|
||||
DEFAULT CHARACTER SET = utf8;
|
||||
|
||||
|
||||
-- -----------------------------------------------------
|
||||
-- Table `iotronic`.`services`
|
||||
-- -----------------------------------------------------
|
||||
|
|
Loading…
Reference in New Issue