Rex mysql

From OpenSimulator

(Difference between revisions)
Jump to: navigation, search
m (Robot: Cosmetic changes)
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 +
__NOTOC__
 +
{{Quicklinks}}
 +
<br />
 +
 
<source lang="bash">
 
<source lang="bash">
 
CREATE TABLE IF NOT EXISTS `RexMaterialsDictionaryItems` (
 
CREATE TABLE IF NOT EXISTS `RexMaterialsDictionaryItems` (
Line 6: Line 10:
 
   `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` (

Revision as of 21:09, 3 March 2012


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