Primitems - Revision history

JeffKelley: Fixed internal links OpenSim:Permissions -> OpenSimulator:Permissions

2023-05-13T03:17:54Z

Fixed internal links OpenSim:Permissions -> OpenSimulator:Permissions

JeffKelley: typo : prim->primID in structure table

2021-11-29T14:22:26Z

typo : prim->primID in structure table

JeffKelley: Wikified table structure

2014-01-16T20:10:43Z

Wikified table structure

MakoBot: Robot: Cosmetic changes

2012-03-04T03:55:40Z

Robot: Cosmetic changes

MakoBot: Removed 'Template:' prefix from template includings and/or changed external-link into internal-link

2011-06-10T23:34:16Z

Removed 'Template:' prefix from template includings and/or changed external-link into internal-link

Ideia Boa at 00:07, 22 May 2009

2009-05-22T00:07:34Z

Peetr maynard at 18:11, 25 February 2009

2009-02-25T18:11:05Z

Peetr maynard at 17:38, 25 February 2009

2009-02-25T17:38:58Z

Peetr maynard at 17:36, 25 February 2009

2009-02-25T17:36:53Z

Peetr maynard at 17:34, 25 February 2009

2009-02-25T17:34:30Z

@@ Line 84: / Line 84: @@
 '''nextPermissions'''
 <br />
-The permissions to be granted to the next owner of this item. Definitions of the Permissions fields can be found at [[OpenSim:Permissions]]
+The permissions to be granted to the next owner of this item. Definitions of the Permissions fields can be found at [[OpenSimulator:Permissions]]
 <br />
 <br />
 '''currentPermissions'''
 <br />
-The permissions currently in force on thie item. Definitions of the Permissions fields can be found at [[OpenSim:Permissions]]
+The permissions currently in force on thie item. Definitions of the Permissions fields can be found at [[OpenSimulator:Permissions]]
 <br />
@@ Line 100: / Line 100: @@
 '''everyonepermissions'''
 <br />
-The permissions applied to everyone except the owner. Definitions of the Permissions fields can be found at [[OpenSim:Permissions]]
+The permissions applied to everyone except the owner. Definitions of the Permissions fields can be found at [[OpenSimulator:Permissions]]
 <br />
@@ Line 106: / Line 106: @@
 '''grouppermissions'''
 <br />
-Not yet implemented - waiting on groups. Definitions of the Permissions fields can be found at [[OpenSim:Permissions]]
+Not yet implemented - waiting on groups. Definitions of the Permissions fields can be found at [[OpenSimulator:Permissions]]
 <br />
@@ Line 112: / Line 112: @@
 '''flags'''
 <br />
-The use and values of flags are identified here: [[OpenSim:Permissions#ObjectFlags_.28F.29]]
+The use and values of flags are identified here: [[OpenSimulator:Permissions#ObjectFlags_.28F.29]]
 <br />
 <br />

@@ Line 40: / Line 40: @@
 | itemID || char(36) || NO || PRI ||  ||
 |-
-| prim || char(36) || NO || MUL ||  ||
+| primID || char(36) || NO || MUL ||  ||
 |- style="background:#eee;"
 | assetID || char(36) || YES ||  ||  ||

@@ Line 5: / Line 5: @@
 '''Primitems'''	''Describes Prim Items and their relationships with Prims and Users ''&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
 <br /><br />
-The current structure of the Primitems table is as follows:<br />
+The current structure of the Primitems table is as follows:
 <br />
-<table>
+{| style="border:1px solid #ccc;"
-<tr><td>Field<br /></td><td>Type</td><td>Null</td><td>Key</td><td>Default</td><td>Extra</td></tr>
+|- style="background:#cce;"
-<tr><td>&nbsp;</td></tr>
+! Field
-<tr><td>invType</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
+! Type
-<tr><td>assetType</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
+! Null
-<tr><td>Name</td><td>varchar(255)</td><td>YES</td><td></td><td></td><td></td></tr>
+! Key
-<tr><td>Description</td><td>varchar(255)</td><td>YES</td><td></td><td></td><td></td></tr>
+! Default
-<tr><td>CreationDate</td><td>bigint(20)</td><td>YES</td><td></td><td></td><td></td></tr>
+! Extra
-<tr><td>nextPermissions</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
+|-
-<tr><td>currentPermissions</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
+| invType || int(11) || YES ||  ||  ||
-<tr><td>basePermissions</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
+|- style="background:#eee;"
-<tr><td>everyonePermissions</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
+| assetType || int(11) || YES ||  ||  ||
-<tr><td>groupPermissions</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
+|-
-<tr><td>flags</td><td>int(11)</td><td>YES</td><td></td><td>0</td><td></td></tr>
+| Name || varchar(255) || YES ||  ||  ||
-<tr><td>itemID</td><td>char(36)</td><td>NO</td><td>PRI</td><td></td><td></td></tr>
+|- style="background:#eee;"
-<tr><td>prim</td><td>char(36)</td><td>NO</td><td>MUL</td><td></td><td></td></tr>
+| Description || varchar(255) || YES ||  ||  ||
-<tr><td>assetID</td><td>char(36)</td><td>YES</td><td></td><td></td><td></td></tr>
+|-
-<tr><td>parentfolderID</td><td>char(36)</td><td>YES</td><td></td><td></td><td></td></tr>
+| CreationDate || bigint(20) || YES ||  ||  ||
-<tr><td>creatorID</td><td>char(36)</td><td>YES</td><td></td><td></td><td></td></tr>
+|- style="background:#eee;"
-<tr><td>ownerID</td><td>char(36)</td><td>YES</td><td></td><td></td><td></td></tr>
+| nextPermissions || int(11) || YES ||  ||  ||
-<tr><td>groupID</td><td>char(36)</td><td>YES</td><td></td><td></td><td></td></tr>
+|-
-<tr><td>lastownerID</td><td>char(36)</td><td>YES</td><td></td><td></td><td></td></tr>
+| currentPermissions || int(11) || YES ||  ||  ||
-</table>
+|- style="background:#eee;"
 <br />
 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br />

@@ Line 2: / Line 2: @@
 {{Quicklinks}}
 <br />
 '''Primitems'''	''Describes Prim Items and their relationships with Prims and Users ''&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
-<br><br>
+<br /><br />
-The current structure of the Primitems table is as follows:<br>
+The current structure of the Primitems table is as follows:<br />
-<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>Field<br /></td><td>Type</td><td>Null</td><td>Key</td><td>Default</td><td>Extra</td></tr>
 <tr><td>&nbsp;</td></tr>
 <tr><td>invType</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
@@ Line 32: / Line 30: @@
 <tr><td>lastownerID</td><td>char(36)</td><td>YES</td><td></td><td></td><td></td></tr>
 </table>
-<br>
+<br />
-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br>
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br />
-<hr>
+----
 '''invType'''
-<br>
+<br />
 The inventory type of this item. Is this needed with asset type?
-<br>
+<br />
-<br>
+<br />
 '''assetType'''
-<br>
+<br />
 The asset type of this item.
-<br>
+<br />
-<br>
+<br />
 '''name'''
-<br>
+<br />
 The name of this item defined by the creator.
-<br>
+<br />
-<br>
+<br />
 '''description'''
-<br>
+<br />
 A definition of this item.
-<br>
+<br />
-<br>
+<br />
 '''creationDate'''
-<br>
+<br />
 The date the item was created.
-<br>
+<br />
-<br>
+<br />
 '''nextPermissions'''
-<br>
+<br />
 The permissions to be granted to the next owner of this item. Definitions of the Permissions fields can be found at [[OpenSim:Permissions]]
-<br>
+<br />
-<br>
+<br />
 '''currentPermissions'''
-<br>
+<br />
 The permissions currently in force on thie item. Definitions of the Permissions fields can be found at [[OpenSim:Permissions]]
-<br>
+<br />
-<br>
+<br />
 '''basepermissions'''
-<br>
+<br />
 The permissions that the item was created with.
-<br>
+<br />
-<br>
+<br />
 '''everyonepermissions'''
-<br>
+<br />
 The permissions applied to everyone except the owner. Definitions of the Permissions fields can be found at [[OpenSim:Permissions]]
-<br>
+<br />
-<br>
+<br />
 '''grouppermissions'''
-<br>
+<br />
 Not yet implemented - waiting on groups. Definitions of the Permissions fields can be found at [[OpenSim:Permissions]]
-<br>
+<br />
-<br>
+<br />
 '''flags'''
-<br>
+<br />
 The use and values of flags are identified here: [[OpenSim:Permissions#ObjectFlags_.28F.29]]
-<br>
+<br />
-<br>
+<br />
 '''itemID'''
-<br>
+<br />
 The UUID of this item (i.e. the key by which it is accessed).
-<br>
+<br />
-<br>
+<br />
 '''primID'''
-<br>
+<br />
 The UUID of the prim to which this item is attached.
-<br>
+<br />
-<br>
+<br />
 '''assetID'''
-<br>
+<br />
 The UUID of the asset on the asset table created by this item.
-<br>
+<br />
-<br>
+<br />
 '''parentfolderID'''
-<br>
+<br />
 Not certain about the use of this field, but it seems to be the same as the primID.
-<br>
+<br />
-<br>
+<br />
 '''ownerID'''
-<br>
+<br />
 The UUID of the user who currently owns this item.
-<br>
+<br />
-<br>
+<br />
 '''groupID'''
-<br>
+<br />
 Not currently used as groups are not yet implemented.
-<br>
+<br />
-<br>
+<br />
 '''lastownerID'''
-<br>
+<br />
 The UUID of the user who previously owned this item.
-<br>
+<br />
-<br>
+<br />
-<hr>
+----
-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br>
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br />
 [[Category:Database]]

@@ Line 1: / Line 1: @@
 __NOTOC__
-{{Template:Quicklinks}}
+{{Quicklinks}}
 <br />

← Older revision		Revision as of 00:07, 22 May 2009
Line 1:		Line 1:
		+	__NOTOC__
		+	{{Template:Quicklinks}}
		+	<br />
		+
	[[Category:Database]]		[[Category:Database]]

@@ Line 58: / Line 58: @@
 '''nextPermissions'''
 <br>
-The permissions to be granted to the next owner of this item. Definitions of the Permissions field can be found here:<br>
+The permissions to be granted to the next owner of this item. Definitions of the Permissions field can be found at [[OpenSim:Permissions]]
-http://opensimulator.org/wiki/OpenSim:Permissions
 <br>
 <br>