-----------__ENALQUILER__--------------------

ALTER TABLE tbl_viviendas ADD (
 fk_id_tbl_uso_edificio INT NULL,
 fk_id_tbl_climatizacion INT NULL,
 fks_id_tbl_voz_datos INT NULL,
 fks_id_tbl_instalacion_electrica INT NULL,
 fk_id_tbl_estructura INT NULL,
 fk_id_tbl_cerramiento INT NULL,
 fk_id_tbl_cubierta INT NULL,
 fk_id_tbl_carpinteria INT NULL,
 fk_id_tbl_suelo INT NULL,
 fk_id_tbl_caracteristicas_zona INT NULL,
 fks_id_tbl_suministros INT NULL,
 alarma INT NULL);
ALTER TABLE tbl_viviendas
  ADD (`foto_plano` int(11) unsigned NOT NULL DEFAULT '0',
       `num_escaparates` int(10) unsigned DEFAULT NULL,
       `luz_natural` tinyint(1) unsigned NOT NULL DEFAULT '0',
       `parking_incluido` tinyint(1) unsigned NOT NULL DEFAULT '0',
       `num_plazas_parking` int(11) unsigned NOT NULL DEFAULT '0',
       `suelo_tecnico` tinyint(1) unsigned NOT NULL DEFAULT '0',
       `cable_optico` tinyint(1) unsigned NOT NULL DEFAULT '0',
       `antena_parabolica` tinyint(1) unsigned NOT NULL DEFAULT '0',
       `antena_tradicional` tinyint(1) unsigned NOT NULL DEFAULT '0',
       `hilo_musical` tinyint(1) unsigned NOT NULL DEFAULT '0',
       `circuito_television` tinyint(1) unsigned NOT NULL DEFAULT '0',
       `grupo_electrogeno` tinyint(1) unsigned NOT NULL DEFAULT '0',
       `interfonia` tinyint(1) unsigned NOT NULL DEFAULT '0',
       `sala_reuniones` tinyint(1) unsigned NOT NULL DEFAULT '0',
       `sala_proyecciones` tinyint(1) unsigned NOT NULL DEFAULT '0',
       `zona_ajardinada` tinyint(1) unsigned NOT NULL DEFAULT '0',
       `fks_id_tbl_tipo_operacion` int(11) unsigned NOT NULL DEFAULT '0',
       `num_muelles_carga` int(10) unsigned DEFAULT NULL,
       `facha` int(10) unsigned DEFAULT NULL,
       `patio_maniobras` tinyint(1) unsigned NOT NULL DEFAULT '0',
       `acceso_trailers` tinyint(1) unsigned NOT NULL DEFAULT '0',
       `acceso_furgoneta` tinyint(1) unsigned NOT NULL DEFAULT '0',
       `puente_grua` tinyint(1) unsigned NOT NULL DEFAULT '0',
       `duchas` tinyint(1) unsigned NOT NULL DEFAULT '0',
       `aseos` tinyint(1) unsigned NOT NULL DEFAULT '0',
       `montacargas` tinyint(1) unsigned NOT NULL DEFAULT '0'
       );