CREATE TABLE `regionwindlight` ( `region_id` varchar(36) NOT NULL DEFAULT '000000-0000-0000-000000000000', `water_color_r` float(9,6) UNSIGNED NOT NULL DEFAULT '4.000000', `water_color_g` float(9,6) UNSIGNED NOT NULL DEFAULT '38.000000', `water_color_b` float(9,6) UNSIGNED NOT NULL DEFAULT '64.000000', `water_fog_density_exponent` float(3,1) UNSIGNED NOT NULL DEFAULT '4.0', `underwater_fog_modifier` float(3,2) UNSIGNED NOT NULL DEFAULT '0.25', `reflection_wavelet_scale_1` float(3,1) UNSIGNED NOT NULL DEFAULT '2.0', `reflection_wavelet_scale_2` float(3,1) UNSIGNED NOT NULL DEFAULT '2.0', `reflection_wavelet_scale_3` float(3,1) UNSIGNED NOT NULL DEFAULT '2.0', `fresnel_scale` float(3,2) UNSIGNED NOT NULL DEFAULT '0.40', `fresnel_offset` float(3,2) UNSIGNED NOT NULL DEFAULT '0.50', `refract_scale_above` float(3,2) UNSIGNED NOT NULL DEFAULT '0.03', `refract_scale_below` float(3,2) UNSIGNED NOT NULL DEFAULT '0.20', `blur_multiplier` float(4,3) UNSIGNED NOT NULL DEFAULT '0.040', `big_wave_direction_x` float(3,2) NOT NULL DEFAULT '1.05', `big_wave_direction_y` float(3,2) NOT NULL DEFAULT '-0.42', `little_wave_direction_x` float(3,2) NOT NULL DEFAULT '1.11', `little_wave_direction_y` float(3,2) NOT NULL DEFAULT '-1.16', `normal_map_texture` varchar(36) NOT NULL DEFAULT '822ded49-9a6c-f61c-cb89-6df54f42cdf4', `horizon_r` float(3,2) UNSIGNED NOT NULL DEFAULT '0.25', `horizon_g` float(3,2) UNSIGNED NOT NULL DEFAULT '0.25', `horizon_b` float(3,2) UNSIGNED NOT NULL DEFAULT '0.32', `horizon_i` float(3,2) UNSIGNED NOT NULL DEFAULT '0.32', `haze_horizon` float(3,2) UNSIGNED NOT NULL DEFAULT '0.19', `blue_density_r` float(3,2) UNSIGNED NOT NULL DEFAULT '0.12', `blue_density_g` float(3,2) UNSIGNED NOT NULL DEFAULT '0.22', `blue_density_b` float(3,2) UNSIGNED NOT NULL DEFAULT '0.38', `blue_density_i` float(3,2) UNSIGNED NOT NULL DEFAULT '0.38', `haze_density` float(3,2) UNSIGNED NOT NULL DEFAULT '0.70', `density_multiplier` float(3,2) UNSIGNED NOT NULL DEFAULT '0.18', `distance_multiplier` float(4,1) UNSIGNED NOT NULL DEFAULT '0.8', `max_altitude` int(4) UNSIGNED NOT NULL DEFAULT '1605', `sun_moon_color_r` float(3,2) UNSIGNED NOT NULL DEFAULT '0.24', `sun_moon_color_g` float(3,2) UNSIGNED NOT NULL DEFAULT '0.26', `sun_moon_color_b` float(3,2) UNSIGNED NOT NULL DEFAULT '0.30', `sun_moon_color_i` float(3,2) UNSIGNED NOT NULL DEFAULT '0.30', `sun_moon_position` float(4,3) UNSIGNED NOT NULL DEFAULT '0.317', `ambient_r` float(3,2) UNSIGNED NOT NULL DEFAULT '0.35', `ambient_g` float(3,2) UNSIGNED NOT NULL DEFAULT '0.35', `ambient_b` float(3,2) UNSIGNED NOT NULL DEFAULT '0.35', `ambient_i` float(3,2) UNSIGNED NOT NULL DEFAULT '0.35', `east_angle` float(3,2) UNSIGNED NOT NULL DEFAULT '0.00', `sun_glow_focus` float(3,2) UNSIGNED NOT NULL DEFAULT '0.10', `sun_glow_size` float(3,2) UNSIGNED NOT NULL DEFAULT '1.75', `scene_gamma` float(4,2) UNSIGNED NOT NULL DEFAULT '1.00', `star_brightness` float(3,2) UNSIGNED NOT NULL DEFAULT '0.00', `cloud_color_r` float(3,2) UNSIGNED NOT NULL DEFAULT '0.41', `cloud_color_g` float(3,2) UNSIGNED NOT NULL DEFAULT '0.41', `cloud_color_b` float(3,2) UNSIGNED NOT NULL DEFAULT '0.41', `cloud_color_i` float(3,2) UNSIGNED NOT NULL DEFAULT '0.41', `cloud_x` float(3,2) UNSIGNED NOT NULL DEFAULT '1.00', `cloud_y` float(3,2) UNSIGNED NOT NULL DEFAULT '0.53', `cloud_density` float(3,2) UNSIGNED NOT NULL DEFAULT '1.00', `cloud_coverage` float(3,2) UNSIGNED NOT NULL DEFAULT '0.27', `cloud_scale` float(3,2) UNSIGNED NOT NULL DEFAULT '0.42', `cloud_detail_x` float(3,2) UNSIGNED NOT NULL DEFAULT '1.00', `cloud_detail_y` float(3,2) UNSIGNED NOT NULL DEFAULT '0.53', `cloud_detail_density` float(3,2) UNSIGNED NOT NULL DEFAULT '0.12', `cloud_scroll_x` float(4,2) NOT NULL DEFAULT '0.20', `cloud_scroll_x_lock` tinyint(1) UNSIGNED NOT NULL DEFAULT '0', `cloud_scroll_y` float(4,2) NOT NULL DEFAULT '0.01', `cloud_scroll_y_lock` tinyint(1) UNSIGNED NOT NULL DEFAULT '0', `draw_classic_clouds` tinyint(1) UNSIGNED NOT NULL DEFAULT '1', PRIMARY KEY (`region_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;