OpenSimulator - User contributions [en]

Database:Assets

2014-01-02T22:44:31Z

CiderJack: /* Asset Table Structure */ highlighted alternate lines in the table & moved the 'deprecated' table underneath

__NOTOC__
{{Quicklinks}}
<br />

The '''assets''' table records all assets including textures, notecards, scripts, and avatar parts       (back to [[Database Documentation]])
<br /><br />

== Asset Table Structure ==

The structure of the assets table as of v0.7.1.1 is as follows:
<br />
{| style="border:1px solid #ccc;"
|- style="background:#cce;"
! Field
! Type
! Collation
! Attributes
! Null
! Default
! Extra
|-
| '''[[#name|name]]''' || varchar(64) || utf8_general_ci || || No || ''None'' ||
|- style="background:#eee;"
| '''[[#description|description]]''' || varchar(64) || utf8_general_ci || || No || ''None'' ||
|-
| '''[[#assetType|assetType]]''' || tinyint(4) || || || No || ''None'' ||
|- style="background:#eee;"
| '''[[#local|local]]''' || tinyint(1) || || || No || ''None'' ||
|-
| '''[[#temporary|temporary]]''' || tinyint(1) || || || No || ''None'' ||
|- style="background:#eee;"
| '''[[#data|data]]''' || longblob || || <code>BINARY</code> || No || ''None'' ||
|-
| '''[[#id|<u>id</u>]]''' || char(36) || utf8_general_ci || || No || 000000-0000-0000-0000-000000000000 ||
|- style="background:#eee;"
| '''[[#create_time|create_time]]''' || int(11) || || || Yes || 0 ||
|-
| '''[[#access_time|access_time]]''' || int(11) || || || Yes || 0 ||
|- style="background:#eee"
| '''[[#asset_flags|asset_flags]]''' || int(11) || || || No || 0 ||
|-
| '''[[#CreatorID|CreatorID]]''' || varchar(128) || utf8_general_ci || || No || ||
|}

<br />
<br />

The structure of the assets table in some deprecated versions is as follows:
<br />
<table>
<tr><td>Field<br /></td><td>Type</td><td>Null</td><td>Key</td><td>Default</td><td>Extra</td></tr>
<tr><td> </td></tr>
<tr><td>Name</td><td>varchar(64)</td><td>NO</td><td></td><td>NULL</td><td> </td></tr>
<tr><td>description</td><td>varchar(64)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
<tr><td>Type</td><td>tinyint(4)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
<tr><td>local</td><td>tinyint(1)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td><tr>
<tr><td>temporary</td><td>tinyint(1)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td></tr>
<tr><td>data</td><td>longblob</td><td>NO</td><td></td><td>NULL</td><td></td><td></td></tr>
<tr><td>id</td><td>char(36)</td><td>NO</td><td>PRI</td><td>00000000-0000-0000-0000-000000000000</td><td></td><td></td></tr>
<tr><td>create_time</td><td>int(11)</td><td>YES</td><td></td><td>0</td><td></td></tr>
<tr><td>access_time</td><td>int(11)</td><td>YES</td><td></td><td>0</td><td></td></tr>
</table>
<br /><br />

== Asset Fields ==

;<div id="name">'''name'''</div>
:Name of the asset as it would appear in inventory
<br />

;<div id="description">'''description'''</div>
:Asset's description field, as it appears in various client-side editing widgets
<br />

;<div id="assetType">'''assetType'''</div>
:Integer which designates the asset's type
:* Valid values are (need help checking and filling these in):
:** 0 - Texture in JPEG2000 J2C stream format
:** 1 - Sound
:** 2 - Calling Card
:** 3 - Landmark
:** 4 - Script  [Obsolete]
:** 5 - Clothing
:** 6 - Primitive that can contain textures, sounds, and more
:** 7 - Notecard
:** 8 - Folder
:** 9 - Root Inventory Folder
:** 10 - LSLText (aka a script)
:** 11 - LSL bytecode for a script
:** 12 - Texture in uncompressed TGA format
:** 13 - Body Part
:** 14 - Trash Folder
:** 15 - Snapshot Folder
:** 16 - Lost and Found Folder
:** 17 - Sound file in uncompressed format
:** 18 - Uncompressed TGA non-square image (not to be used as a texture)
:** 19 - Compressed JPEG non-square image (not to be used as a texture)
:** 20 - Animation
:** 21 - Gesture
:** 22 - Sim state file
<br />

;<div id="local">'''local'''</div>
:For Future Use
<br />

;<div id="temporary">'''temporary'''</div>
:For Future Use
<br />

;<div id="data">'''data'''</div>
:This is the blob which contains the actual script, notecard text, binary image (texture) or other data characterized by the "Type" column
<br />

;<div id="id">'''id'''</div>
:UUID which uniquely identifies the asset within the system
<br />

;<div id="create_time">'''create_time'''</div>
:Date and time the asset was created in standard UNIX format
<br />

;<div id="access_time">'''access_time'''</div>
:Date and time the asset was last used in standard UNIX format
<br />

;<div id="asset_flags">'''asset_flags'''</div>
:Asset flags.
<br />

;<div id="CreatorID">'''CreatorID'''</div>
:Creator avatar UUID
<br />
----
(back to [[Database Documentation]])
<br />

[[Category:Database]]

Userlevel

2011-11-28T00:12:22Z

CiderJack: added _UserLevel values as applied to OpenSim_ borrowing text from user:Justincc's email to the OpenSim-users group

On the table [[useraccounts]] in the database ''opensim'' there are 2 fields:
*''UserLevel'' integer used to attribute the God powers for each individual user
*''UserTitle'' string used for Administrator; you can set here the particularities of each user (possibly SL only; might not be in use in core OpenSim?)

== UserLevel values as applied to OpenSim ==
The only UserLevel used is 200 (to indicate god). Also presumably level 0 for non-god, basic user level.

A [[IRegionModule|region module]] could get these values via the UserAccount class from the UserAccountService. They can be set either by directly writing to the database, via the "set user level" command on the [[ROBUST]] console (there is no command for setting user title) or via the StoreAccount call on the robust service if it has been explicitly allowed (security risk in open grids).

== God Mode Values ==
The Viewer source code shows that there are several levels of "God Mode" (each level has all the previous levels' powers):

'''GOD_NOT'''

Value: 0 ''(Presumably the default "God Mode" status given to every logged-in user)''

'''GOD_LIKE'''

Value: 1
*rename objects without modify permission

'''GOD_CUSTOMER_SERVICE'''

Value: 100
*Toggle character geometry
*Take copy
*Owner To Me
*Set To Linden Content
*Claim Public Land

'''GOD_LIAISON'''

Value: 150
*Enable land auction

'''GOD_FULL'''

Value: 200 ''(Difference from GOD_LIAISON not apparent)''

'''GOD_MAINTENANCE'''

Value: 250 ''(Difference from GOD_FULL not apparent)''

''Note: text in "God Mode Values" section was borrowed from [http://wiki.secondlife.com/wiki/God_mode SLwiki], shared under a [https://creativecommons.org/licenses/by-sa/3.0/ CC BY-SA 3.0] license''

Developer Documentation

2011-11-27T23:40:21Z

CiderJack: /* Developer Documentation */ added "Users" subsection with link to _Userlevel_ page

{{Quicklinks}}

== Source Code Repository Access ==

OpenSimulator uses git as its source code repository. Checkout

git clone git://opensimulator.org/git/opensim

See [[Source Code Repository]] for more details.

See [[Using Git]] for more Details on installing and using GIT with OpenSimulator.org

You can also browse the source code for OpenSim [http://opensimulator.org/viewgit/?a=shortlog&p=opensim using a web browser].

We have [http://www.ohloh.net/projects/4753?p=OpenSim Ohloh page], which takes various statistics of the OpenSimulator code base.

This is also an [[opensim-libs git repository]] which contains the source code to some of the 3rd party libraries built and included in OpenSim.

==Submitting Patches==
Please review [[Submitting code to OpenSim]]

== Developer Documentation ==
Please be aware that some of this documentation may be out of date. If this appears to be the case then please ask for more information on the mailing lists or IRC channels (details are on the [[Main Page]]). If you can't find what you want here you might want to try looking in the [[User Documentation]].

==== General ====
* [[Development Team]] — OpenSim is brought to you by...
* [[Release Cycle]] — How to create an OpenSimulator release.
* [[Automated Release Building]]
* [[On revisions, tags and branches]]
* [[Hacking OpenSim for fun and profit]] — A starters guide for programming OpenSim.
* [[Coding standards]] — Coding conventions for developers.
* [[Automated Testing]] — How to write tests for OpenSim.
* [[Debugging Unit Tests]] — How to debug the automated tests.
* [[Branches]] — An overview of the repository branches and what they are for.
* [[Monodevelop]] — How to use the [[monodevelop]] IDE for editing C# solutions.
* [[Creating New Solution]] — How to create new solution according to OpenSim conventions.
* [[Performance]] — Information about performance in OpenSim, including studies on where the bottlenecks are.
* [[Mono]] — The tips for implementing with Mono.

==== Development Services ====
* [http://opensimulator.org/mantis Mantis Bug Tracking] — Mantis is the issue tracking tool of OpenSimulator.
* [http://panda.opensimulator.org/ Panda Building] — Panda builds the source base continuously and runs unit tests.
* [http://forge.opensimulator.org/gf/ OpenSimulator GForge] — Project hosting for OpenSimulator related projects.

==== Architecture ====
* [[OpenSim:Introduction_and_Definitions | OpenSim: Introduction and Definitions]] — A work in progress describing the high level components of OpenSim
* [[:Category:Tech Reference|Technical Reference]] — A technical description of the simulator operation.
* [[Grid Architecture Diagram]]
* [[Connectors]] — A description of OpenSim's connector architecture, used for linking region code with services (asset, inventory, etc.) in both local (standalone) and distributed (grid) configurations.
* [[Plugins]] — The types of plugins used in OpenSim.

==== Client Stacks ====
* [[Sim Throttles]] — Information on how OpenSim handles throttling of packets to the client.

==== Communication Protocols ====
* [[Communication Protocols]] - Introduction to the various communication protocols used by OpenSimulator.

==== Database ====
* [[Database Documentation]] — Information on the database schemas used in OpenSim
* [[MonoSqlite]] — How the database model currently works.
* [[LSL:PrimitiveParams]] — Notes on converting SL Edit GUI values and LSL PrimitiveParams to OpenSim PrimitiveBaseShape fields

==== File formats ====
* [[OpenSim Archives]] - Opensim Region Archive (OAR) file format.
* [[Inventory Archives]] - OpenSim Inventory Archive (IAR) file format

==== Grid ====
* [[Asset Server problems]] - list of known problems with the asset server
* [[Teleports]] - some diagrams about OGP and Hypergrid teleport sequences
* [[Agent Domain / Service]] - Details about the GridForge hosted Agent Domain/Service code

==== Map ====
* [[Warp3DImageModule]] — This is an improved map image module.

==== Modules ====
* [[IRegionModule|Region module basics]] - The basics of how to create a region module, and where example code can be found in the OpenSim source tree.

==== Permissions ====
* [[Permissions (Server)]] — Permissions system as implemented on the region server.
* [[OpenSim: Permissions]] — Notes on how object permissions are handled on the client.

==== Physics ====
* [[PhysicsEngines]] — Options for physics engines in OpenSim.
* [[Physics Engine Interface]] — what methods and such exist in a Physics module

==== Regions ====
* [[Overview of How Regions Work]] - notes from ter_afk to rknop in #opensim-dev, cleaned up a bit
* [[OpenSim: Permissions]] — Notes on object permissions & definition of the ObjectFlags variable.
* [[OpenSim Load Balancing and Region Splitting]] - Instructions for using load balancing and region splitting features.

==== Scripting ====
* [[Scripting_Documentation]] — How to use scripts and what limitations apply.
* [[LSL_Status]] — A list of LSL-functions that are available in OpenSim.
* [[OSSL]] — Some information about the OpenSimulator Scripting Language, and how to implement an OSSL function
* [[OpenSim.Region.ScriptEngine]] — How the ScriptEngine looks internally.

==== Search ====
* [[OpenSim.Region.DataSnapshot]] - Shiny new data gathering/search system
* [[ImageService]] - Shiny new region module for serving search-related images

==== Statistics ====
* [[Web Statistics Module]] - The web statistics module documentation and counter wish list.

==== Testing ====
* [[Automated_Testing]] — Writing Automated tests for OpenSim.
* [[Debugging Unit Tests]] — Debugging unit tests.
* [[Prim_Linking_Testing]] — Test cases for in world link/unlinking of prims.

==== Threading ====
* [[OpenSim: Threading strategy]] — How threading is implemented and handled.

==== Users ====
* [[Userlevel]] — Explanation of permissions granted via "God Mode"/Admin Status.

==== Web Integration ====
* [[Webinterface]] — How to mashup with the web.
* [[RemoteAdmin]] — How to use the remote admin plug-in.
* [[RestConsole]] - Description how to use the REST remote console
* [[REST]] — Information about the REST interface to assets, inventory, etc.
* [[Known Web Interfaces within OpenSim]] — The set of CAPS, XMLRPC, or REST entry points in the project.

==Feature Proposals==

Please see the [[Feature Proposals]] page.

==Communication==
A good first point of contact is the OpenSim IRC, on irc.freenode.net channels #opensim / #opensim-dev / #osgrid / #opensim-scripting. The OpenSim developers hold [[office hours]] once a week in-world on Tuesdays at "Wright Plaza" on OSGrid. There is a "Test Hour" on Saturdays, also generally on "Wright Plaza". Both these weekly events are held at 1900UTC in summer time and 2000UTC in winter. Check on the #opensim IRC channel on Freenode just before each of these events if there is any confusion.

There is also a mailman email distribution list available at https://lists.berlios.de/mailman/listinfo/opensim-dev

==Recent Git Commits==
<rss>http://opensimulator.org/viewgit?a=rss-log&p=opensim|max=5|title=none</rss>

[[Category:Support]]
[[Category:Tech Reference]]
[[Category:Help]]
[[Category:Configuration]]
[[Category:Getting_Started]]
[[Category:Development]]

Permissions (Server)

2011-11-27T23:34:06Z

CiderJack: /* God */

__NOTOC__
{{Quicklinks}}
<br />

This page aims to explain the server side permissions as implemented by the default PermissionsModule.

{{content}}

On this page, each permission group is defined as a 'Set' - that is, who is within that set. A Set can contain other Sets.

==Region Master==
Due to historical reasons, The Region Master is called Master Avatar, Region Master or Region Owner interchangeably.

===Set===
1/Region, specified in the region xml.

===Permissions===

==Administrator==
Somebody set to administrate the content of a set of regions within an estate.

===Set===
* if (Region Owner is God) Region Owner
* if (Grid Gods Allowed) GodLevel > 200
* Estate Owner

===Permissions===

==Estate Owner==
===Set===
Specified in estate_settings
===Permissions===

==God==
A 'God' has a 'god level' - this concept is under development. The 'god' concept is a way to assign users trust levels, rather than incorporating them into a policy group like 'administrators' or 'estate managers'. See also [[Userlevel]]
===Set===
Administrators
===Permissions===

==Estate Manager==
===Set===
* Estate Owner
* Listed in estate_managers

===Permissions===

==Parcel Owner==
===Set===
Specified in land

===Permissions===

==Parcels Managers==
===Set===
* Parcel Owner
* Estate Managers
* Administrators
===Permissions===

==Object Manager==
Has permissions to manage content on an object level.

Comments taken from the code:
* The default is to deny.
* People shouldn't be able to do anything with locked objects, except the Administrator. The 'set permissions' runs through a different permission check, so when an object owner sets an object locked, the only thing that they can do is unlock it. Nobody but the object owner can set permissions on an object.
* Object owners should be able to edit their own content
* Users should be able to edit what is over their land.
* Estate users should be able to edit anything in the sim
* Admin objects should not be editable by estate managers or parcel owners
* Admin should be able to edit anything in the sim (including admin objects)

===Set===
* if locked only Administrators
* if not locked,
** Object Owner
** if(Owner not Administrator) Parcel Owner
** if(Owner not Administrator) Estate Manager
** Administrator

===Permissions===

Userlevel

2011-11-27T23:26:12Z

CiderJack: added parenthetical caveat to 'UserTitle' description

2011-07-29T04:22:59Z

CiderJack:

__NOTOC__
{{Quicklinks}}

'''assets''' ''Records all assets''      (back to [[Database Documentation]])<br>
          ''including textures, notecards, scripts, and avatar parts''
<br><br>
The current structure (Rev. 1) of the assets table is as follows:<br>
<br>
<table>
<tr><td>Field<br></td><td>Type</td><td>Null</td><td>Key</td><td>Default</td><td>Extra</td></tr>
<tr><td> </td></tr>
<tr><td>Name</td><td>varchar(64)</td><td>NO</td><td></td><td>NULL</td><td> </td></tr>
<tr><td>description</td><td>varchar(64)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
<tr><td>Type</td><td>tinyint(4)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
<tr><td>local</td><td>tinyint(1)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td><tr>
<tr><td>temporary</td><td>tinyint(1)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td></tr>
<tr><td>data</td><td>longblob</td><td>NO</td><td></td><td>NULL</td><td></td><td></td></tr>
<tr><td>id</td><td>char(36)</td><td>NO</td><td>PRI</td><td>00000000-0000-0000-0000-000000000000</td><td></td><td></td></tr>
<tr><td>create_time</td><td>int(11)</td><td>YES</td><td></td><td>0</td><td></td></tr>
<tr><td>access_time</td><td>int(11)</td><td>YES</td><td></td><td>0</td><td></td></tr>
</table>
<br>
<br>
      (back to [[Database Documentation]])<br>
<hr>
'''name'''
<br>
Name of the asset as it would appear in inventory<br>
<br>
'''description'''
<br>
Asset's description field, as it appears in various client-side editing widgets
<br>
<br>
'''Type'''
<br>
Integer which designates the asset's type
* Valid values are (need help checking and filling these in):
** 0 - Textures
** 1 - Sound
** 2 - Calling Card
** 3 - Landmark
** 4 - ??
** 5 - Clothing
** 6 - Primitive
** 7 - Note
** 8 - ??
** 9 - ??
** 10 - Script
** 11 - ??
** 12 - ??
** 13 - Body Part
** 14 - ??
** 15 - ??
** 16 - ??
** 17 - ??
** 18 - ??
** 19 - ??
** 20 - Animation
** 21 - Gesture
<br>
'''local'''
<br>
For Future Use
<br>
<br>
'''temporary'''
<br>
For Future Use
<br>
<br>
'''data'''
<br>
This is the blob which contains the actual script, notecard text,<br>
binary image (texture) or other data characterized by the "Type" column
<br>
<br>
'''id'''
<br>
UUID which uniquely identifies the asset within the system
<br>
<br>
'''create_time'''
<br>
Date and time the asset was created in standard UNIX format
<br>
<br>
'''access_time'''
<br>
Date and time the asset was last used in standard UNIX format
<br>
<br>
<br>
<hr>
      (back to [[Database Documentation]])<br>
[[Category:Database]]