Rex mysql
From OpenSimulator
(Difference between revisions)
(New page: -- 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...) |
Steevithak (Talk | contribs) m (added archive tag) |
||
| (5 intermediate revisions by 3 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"> | ||
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 26: | 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 | + | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1' AUTO_INCREMENT=9 ; |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
CREATE TABLE IF NOT EXISTS `RexObjectProperties` ( | CREATE TABLE IF NOT EXISTS `RexObjectProperties` ( | ||
| Line 58: | Line 42: | ||
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> | ||
Latest revision as of 09:53, 17 September 2020
 |
Languages: |
|
|
|
This article or section is archived information. The information in this page is no longer current, but it is being kept for historical reasons. Do not delete this information, since it may hold historical value. |
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;
