Rex mysql
From OpenSimulator
(Difference between revisions)
m |
|||
| Line 1: | Line 1: | ||
<source lang="bash"> | <source lang="bash"> | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
CREATE TABLE IF NOT EXISTS `RexMaterialsDictionaryItems` ( | CREATE TABLE IF NOT EXISTS `RexMaterialsDictionaryItems` ( | ||
`ID` int(6) NOT NULL auto_increment, | `ID` int(6) NOT NULL auto_increment, | ||
| Line 28: | Line 7: | ||
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` ( | ||
| Line 59: | Line 32: | ||
PRIMARY KEY (`ID`) | PRIMARY KEY (`ID`) | ||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1'; | ) 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; | ||
</source> | </source> | ||
Revision as of 10:02, 20 February 2009
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;
