
# This is a fix for InnoDB in MySQL >= 4.1.x
# It "suspends judgement" for fkey relationships until are tables are set.
SET FOREIGN_KEY_CHECKS = 0;

#-----------------------------------------------------------------------------
#-- PMT_REL_CADASTRO_DE_TORRE
#-----------------------------------------------------------------------------

DROP TABLE IF EXISTS `PMT_REL_CADASTRO_DE_TORRE`;


CREATE TABLE `PMT_REL_CADASTRO_DE_TORRE`
(
	`APP_UID` VARCHAR(32)  NOT NULL,
	`APP_NUMBER` INTEGER(11)  NOT NULL,
	`APP_STATUS` VARCHAR(10)  NOT NULL,
	`NOME_DA_TORRE` VARCHAR(32),
	`TORRE_LATITUDE` VARCHAR(32),
	`TORRE_LONGITUDE` VARCHAR(32),
	PRIMARY KEY (`APP_UID`)
)ENGINE=InnoDB  DEFAULT CHARSET='utf8';
# This restores the fkey checks, after having unset them earlier
SET FOREIGN_KEY_CHECKS = 1;
