Rex mysql

From OpenSimulator

Jump to: navigation, search


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