Database:Regionwindlight

From OpenSimulator

(Difference between revisions)
Jump to: navigation, search
m (Robot: Cosmetic changes)
Line 2: Line 2:
  
 
<source lang="sql">
 
<source lang="sql">
-- MySQL dump 10.13 Distrib 5.1.42, for Win32 (ia32)
+
-- MySQL dump 10.13 Distrib 5.1.42, for Win32 (ia32)
 
--
 
--
-- Host: localhost   Database: opensim
+
-- Host: localhost Database: opensim
 
-- ------------------------------------------------------
 
-- ------------------------------------------------------
-- Server version       5.1.42-community
+
-- Server version 5.1.42-community
  
 
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
Line 24: Line 24:
  
 
DROP TABLE IF EXISTS `regionwindlight`;
 
DROP TABLE IF EXISTS `regionwindlight`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
+
/*!40101 SET @saved_cs_client = @@character_set_client */;
 
/*!40101 SET character_set_client = utf8 */;
 
/*!40101 SET character_set_client = utf8 */;
 
CREATE TABLE `regionwindlight` (
 
CREATE TABLE `regionwindlight` (

Revision as of 18:56, 3 March 2012

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.


Back to the LightShare main page

Personal tools
General
About This Wiki