mLLTZbRw

1SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
2SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
3SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';
4
5
6-- -----------------------------------------------------
7-- Table `alerta`
8-- -----------------------------------------------------
9DROP TABLE IF EXISTS `alerta` ;
10
11CREATE  TABLE IF NOT EXISTS `alerta` (
12  `id_alerta` VARCHAR(38) NOT NULL ,
13  `id_alerta_v` SMALLINT(6) NOT NULL ,
14  `id_tecnico_registo` VARCHAR(38) NOT NULL ,
15  `id_tecnico_registo_v` SMALLINT(6) NOT NULL ,
16  `activo` TINYINT(1) NOT NULL DEFAULT '1' ,
17  `data_registo` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
18  `data_evento` TIMESTAMP NOT NULL ,
19  `observacao` VARCHAR(4000) NOT NULL ,
20  PRIMARY KEY (`id_alerta`, `id_alerta_v`) )
21ENGINE = InnoDB
22DEFAULT CHARACTER SET = latin1;
23
24
25
26SET SQL_MODE=@OLD_SQL_MODE;
27SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
28SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;