Rex mysql

From OpenSimulator

(Difference between revisions)
Jump to: navigation, search
m (added archive tag)
 
(3 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 +
__NOTOC__
 +
{{Quicklinks}}
 +
 +
{{archive}}
 +
'''Purpose:''' The information on this page is out of date. However, it may still hold value to some people (examples are chat logs, version history, or OpenSimulator 0.6x specific info) or needs to be preserved for other reasons. It should be marked as archived information to prevent confusion.
 +
 +
'''Tag:''' <nowiki>{{archive}}</nowiki>
 +
 +
<br />
 +
 
<source lang="bash">
 
<source lang="bash">
 
CREATE TABLE IF NOT EXISTS `RexMaterialsDictionaryItems` (
 
CREATE TABLE IF NOT EXISTS `RexMaterialsDictionaryItems` (
Line 6: Line 16:
 
   `RexObjectUUID` varchar(50) character set latin1 collate latin1_general_ci NOT NULL,
 
   `RexObjectUUID` varchar(50) character set latin1 collate latin1_general_ci NOT NULL,
 
   PRIMARY KEY  (`ID`)
 
   PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1' AUTO_INCREMENT=9 ;
+
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1' AUTO_INCREMENT=9 ;
  
 
CREATE TABLE IF NOT EXISTS `RexObjectProperties` (
 
CREATE TABLE IF NOT EXISTS `RexObjectProperties` (

Latest revision as of 09:53, 17 September 2020

Purpose: The information on this page is out of date. However, it may still hold value to some people (examples are chat logs, version history, or OpenSimulator 0.6x specific info) or needs to be preserved for other reasons. It should be marked as archived information to prevent confusion.

Tag: {{archive}}


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 ;
 
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';
 
CREATE TABLE IF NOT EXISTS `RexAssetData` (
  `ID` varchar(255) collate latin1_general_ci default NULL,
  `MediaURL` varchar(64) character set utf8 default NULL,
  `RefreshRate` tinyint(4) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
Personal tools
General
About This Wiki