J3wh1htW

1-- -----------------------------------------------------
2-- Table `alerta`
3-- -----------------------------------------------------
4DROP TABLE IF EXISTS `alerta` ;
5
6CREATE  TABLE IF NOT EXISTS `alerta` (
7  `id_alerta` VARCHAR(38) NOT NULL ,
8  `id_alerta_v` SMALLINT(6) NOT NULL ,
9  `id_tecnico_registo` VARCHAR(38) NOT NULL ,
10  `id_tecnico_registo_v` SMALLINT(6) NOT NULL ,
11  `activo` TINYINT(1) NOT NULL DEFAULT '1' ,
12  `data_registo` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
13  `data_evento` TIMESTAMP NOT NULL DEFAULT NULL ,
14  `observacao` VARCHAR(4000) NOT NULL ,
15  PRIMARY KEY (`id_alerta`, `id_alerta_v`) )
16ENGINE = InnoDB
17DEFAULT CHARACTER SET = latin1;