Rex mysql
From OpenSimulator
-- 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';