CREATE TABLE PRATIMONIO_AMBIENTAL (ID INT UNSIGNED NOT NULL PRIMARY KEY, NUM_INVETARIO INT , ETNOSITIO TEXT , DESCRICAO TEXT , LINK_FOTOGRAFIA TEXT, INDEX (ID),FOREIGN KEY (ID) REFERENCES PATRIMONIO(ID) ON UPDATE CASCADE ON DELETE CASCADE ) ENGINE=InnoDB;CREATE TABLE PATRIMONIO_BOTANICO (ID INT UNSIGNED PRIMARY KEY, NUM_BIB INT , TAXA TEXT , DESIGNACAO TEXT , FUNCAO TEXT, INDEX (ID), FOREIGN KEY (ID) REFERENCES PATRIMONIO_AMBIENTAL(ID) ON UPDATE CASCADE ON DELETE CASCADE ) ENGINE=InnoDB;