Rex mysql

From OpenSimulator

Revision as of 02:56, 3 February 2009 by Phrearch (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

-- phpMyAdmin SQL Dump -- version 3.1.2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Feb 03, 2009 at 11:32 AM -- Server version: 5.0.75 -- PHP Version: 5.2.7

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- -- Database: `opensim` --

-- --------------------------------------------------------

-- -- Table structure for table `RexMaterialsDictionaryItems` --

CREATE TABLE IF NOT EXISTS `RexMaterialsDictionaryItems` (

 `ID` int(6) NOT NULL auto_increment,
 `AssetID` varchar(50) character set latin1 collate latin1_general_ci NOT NULL,
 `Num` int(7) NOT NULL,
 `RexObjectUUID` varchar(50) character set latin1 collate latin1_general_ci NOT NULL,
 PRIMARY KEY  (`ID`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1' AUTO_INCREMENT=9 ;

-- --------------------------------------------------------

-- -- Table structure for table `RexObjectProperties` --

CREATE TABLE IF NOT EXISTS `RexObjectProperties` (

 `ID` varchar(50) character set latin1 collate latin1_general_ci NOT NULL,
 `RexDrawType` tinyint(50) NOT NULL,
 `RexIsVisible` int(1) NOT NULL,
 `RexCastShadows` int(1) NOT NULL,
 `RexLightCreatesShadows` int(1) NOT NULL,
 `RexDescriptionTexture` int(1) NOT NULL,
 `RexScaleToPrim` int(1) NOT NULL,
 `RexDrawDistance` int(1) NOT NULL,
 `RexLOD` float NOT NULL,
 `RexMeshUUID` varchar(50) character set latin1 collate latin1_general_ci NOT NULL,
 `RexCollisionMeshUUID` varchar(50) character set latin1 collate latin1_general_ci NOT NULL,
 `RexParticleScriptUUID` varchar(50) character set latin1 collate latin1_general_ci NOT NULL,
 `RexAnimationPackageUUID` varchar(50) NOT NULL,
 `RexAnimationName` varchar(64) character set latin1 collate latin1_general_ci NOT NULL,
 `RexAnimationRate` float NOT NULL,
 `RexClassName` varchar(64) character set latin1 collate latin1_general_ci NOT NULL,
 `RexSoundUUID` varchar(50) character set latin1 collate latin1_general_ci NOT NULL,
 `RexSoundVolume` float NOT NULL,
 `RexSoundRadius` float NOT NULL,
 `RexData` varchar(3000) character set latin1 collate latin1_general_ci NOT NULL,
 `RexSelectPriority` int(9) NOT NULL,
 PRIMARY KEY  (`ID`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1';

Personal tools
General
About This Wiki