 	preco real,
 	PRIMARY KEY (idTipoQuarto)
 )
--- ALTER TABLE TipoQuarto OWNER TO postgres;
+
+WITH (OIDS = FALSE);
+
+ALTER TABLE TipoQuarto OWNER TO postgres;
 
 
 -- Hotel (#idHotel, nome, endereco, telefone)

	PRIMARY KEY (idHotel)
)

-- Cliente (#idCliente, nome, endereco, telefone)
CREATE TABLE Cliente
(

	FOREIGN KEY (numQuarto, idHotel) REFERENCES Quarto (numQuarto, idHotel)
		MATCH SIMPLE ON UPDATE CASCADE ON DELETE CASCADE
)

WITH (OIDS = FALSE);

ALTER TABLE Reserva OWNER TO postgres;
