Database:Regionwindlight
From OpenSimulator
Check if you have the table regionwindlight on your OpenSim database; if not, create it with:
-- MySQL dump 10.13 Distrib 5.1.42, for Win32 (ia32) -- -- Host: localhost Database: opensim -- ------------------------------------------------------ -- Server version 5.1.42-community /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `regionwindlight` -- DROP TABLE IF EXISTS `regionwindlight`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `regionwindlight` -- LOCK TABLES `regionwindlight` WRITE; /*!40000 ALTER TABLE `regionwindlight` DISABLE KEYS */; /*!40000 ALTER TABLE `regionwindlight` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2010-06-17 21:18:04
Thanks to James Stallings/Hiro Protagonist for the database dump.