Estate settings - Revision history

MakoBot: Robot: Cosmetic changes

2012-03-04T03:00:20Z

Robot: Cosmetic changes

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

2011-06-10T14:23:30Z

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

Kcozens: Added basic information about structure of estate_settings table

2009-11-28T20:20:22Z

Added basic information about structure of estate_settings table

New page

__NOTOC__
{{Template:Quicklinks}}
 

[[Category:Database]]

'''Estate_settings''' '' Settings for Estates ''      (back to [[Database Documentation]])
 
The current structure of the estate_settings table is as follows: 
 
<table>
<tr>
<td>Field </td>
<td>Type</td>
<td>Null</td>
<td>Key</td>
<td>Default</td>
<td>Extra</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td>EstateID</td>
<td>int(10)</td>
<td>NO</td>
<td>PRI</td>
<td></td>
<td></td>
</tr>
<tr>
<td>EstateName</td>
<td>varchar(64)</td>
<td>YES</td>
<td></td>
<td>NULL</td>
<td></td>
</tr>
<tr>
<td>AbuseEmailToEstateOwner</td>
<td>tinyint(4)</td>
<td>NO</td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>DenyAnonymous</td>
<td>tinyint(4)</td>
<td>NO</td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>ResetHomeOnTeleport</td>
<td>tinyint(4)</td>
<td>NO</td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>FixedSun</td>
<td>tinyint(4)</td>
<td>NO</td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>DenyTransacted</td>
<td>tinyint(4)</td>
<td>NO</td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>BlockDwell</td>
<td>tinyint(4)</td>
<td>NO</td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>DenyIdentified</td>
<td>tinyint(4)</td>
<td>NO</td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>AllowVoice</td>
<td>tinyint(4)</td>
<td>NO</td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>UseGlobalTime</td>
<td>tinyint(4)</td>
<td>NO</td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>PricePerMeter</td>
<td>int(11)</td>
<td>NO</td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>TaxFree</td>
<td>tinyint(4)</td>
<td>NO</td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>AllowDirectTeleport</td>
<td>tinyint(4)</td>
<td>NO</td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>RedirectGridX</td>
<td>int(11)</td>
<td>NO</td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>RedirectGridY</td>
<td>int(11)</td>
<td>NO</td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>ParentEstateID</td>
<td>int(10)</td>
<td>NO</td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>SunPosition</td>
<td>double</td>
<td>NO</td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>EstateSkipScripts</td>
<td>tinyint(4)</td>
<td>NO</td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>BillableFactor</td>
<td>float</td>
<td>NO</td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>PublicAccess</td>
<td>tinyint(4)</td>
<td>NO</td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>AbuseEmail</td>
<td>varchar(255)</td>
<td>NO</td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>EstateOwner</td>
<td>varchar(36)</td>
<td>NO</td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>DenyMinors</td>
<td>tinyint(4)</td>
<td>NO</td>
<td></td>
<td></td>
<td></td>
</tr>
</table>

 
      (back to [[Database Documentation]]) 
<hr>
'''EstateID 
The UUID of the estate. 

'''EstateName 
The name of the estate 

'''AbuseEmailToEstateOwner 
''Additional details are needed'' 

'''DenyAnonymous 
''Additional details are needed'' 

'''ResetHomeOnTeleport 
''Additional details are needed'' 

'''FixedSun 
''Additional details are needed'' 

'''DenyTransacted 
''Additional details are needed'' 

'''BlockDwell 
''Additional details are needed'' 

'''DenyIdentified 
''Additional details are needed'' 

'''AllowVoice 
''Additional details are needed'' 

'''UseGlobalTime 
''Additional details are needed'' 

'''PricePerMeter 
''Additional details are needed'' 

'''TaxFree 
''Additional details are needed'' 

'''AllowDirectTeleport 
''Additional details are needed'' 

'''RedirectGridX 
''Additional details are needed'' 

'''RedirectGridY 
''Additional details are needed'' 

'''ParentEstateID 
''Additional details are needed'' 

'''SunPosition 
''Additional details are needed'' 

'''EstateSkipScripts 
''Additional details are needed'' 

'''BillableFactor 
''Additional details are needed'' 

'''PublicAccess 
''Additional details are needed'' 

'''AbuseEmail 
''Additional details are needed'' 

'''EstateOwner 
''Additional details are needed'' 

'''DenyMinors 
''Additional details are needed'' 
<hr>
      (back to [[Database Documentation]]) 
[[Category:Database]]

@@ Line 2: / Line 2: @@
 {{Quicklinks}}
 <br />
 '''Estate_settings'''	'' Settings for Estates ''&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
-<br><br>
+<br /><br />
-The current structure of the estate_settings table is as follows:<br>
+The current structure of the estate_settings table is as follows:<br />
-<br>
+<br />
 <table>
 <tr>
-  <td>Field<br></td>
+  <td>Field<br /></td>
   <td>Type</td>
   <td>Null</td>
@@ Line 215: / Line 213: @@
 </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>
+----
-'''EstateID<br>
+'''EstateID<br />
-The UUID of the estate.<br><br>
+The UUID of the estate.<br /><br />
-'''EstateName<br>
+'''EstateName<br />
-The name of the estate<br><br>
+The name of the estate<br /><br />
-'''AbuseEmailToEstateOwner<br>
+'''AbuseEmailToEstateOwner<br />
-''Additional details are needed''<br><br>
+''Additional details are needed''<br /><br />
-'''DenyAnonymous<br>
+'''DenyAnonymous<br />
-''Additional details are needed''<br><br>
+''Additional details are needed''<br /><br />
-'''ResetHomeOnTeleport<br>
+'''ResetHomeOnTeleport<br />
-''Additional details are needed''<br><br>
+''Additional details are needed''<br /><br />
-'''FixedSun<br>
+'''FixedSun<br />
-''Additional details are needed''<br><br>
+''Additional details are needed''<br /><br />
-'''DenyTransacted<br>
+'''DenyTransacted<br />
-''Additional details are needed''<br><br>
+''Additional details are needed''<br /><br />
-'''BlockDwell<br>
+'''BlockDwell<br />
-''Additional details are needed''<br><br>
+''Additional details are needed''<br /><br />
-'''DenyIdentified<br>
+'''DenyIdentified<br />
-''Additional details are needed''<br><br>
+''Additional details are needed''<br /><br />
-'''AllowVoice<br>
+'''AllowVoice<br />
-''Additional details are needed''<br><br>
+''Additional details are needed''<br /><br />
-'''UseGlobalTime<br>
+'''UseGlobalTime<br />
-''Additional details are needed''<br><br>
+''Additional details are needed''<br /><br />
-'''PricePerMeter<br>
+'''PricePerMeter<br />
-''Additional details are needed''<br><br>
+''Additional details are needed''<br /><br />
-'''TaxFree<br>
+'''TaxFree<br />
-''Additional details are needed''<br><br>
+''Additional details are needed''<br /><br />
-'''AllowDirectTeleport<br>
+'''AllowDirectTeleport<br />
-''Additional details are needed''<br><br>
+''Additional details are needed''<br /><br />
-'''RedirectGridX<br>
+'''RedirectGridX<br />
-''Additional details are needed''<br><br>
+''Additional details are needed''<br /><br />
-'''RedirectGridY<br>
+'''RedirectGridY<br />
-''Additional details are needed''<br><br>
+''Additional details are needed''<br /><br />
-'''ParentEstateID<br>
+'''ParentEstateID<br />
-''Additional details are needed''<br><br>
+''Additional details are needed''<br /><br />
-'''SunPosition<br>
+'''SunPosition<br />
-''Additional details are needed''<br><br>
+''Additional details are needed''<br /><br />
-'''EstateSkipScripts<br>
+'''EstateSkipScripts<br />
-''Additional details are needed''<br><br>
+''Additional details are needed''<br /><br />
-'''BillableFactor<br>
+'''BillableFactor<br />
-''Additional details are needed''<br><br>
+''Additional details are needed''<br /><br />
-'''PublicAccess<br>
+'''PublicAccess<br />
-''Additional details are needed''<br><br>
+''Additional details are needed''<br /><br />
-'''AbuseEmail<br>
+'''AbuseEmail<br />
-''Additional details are needed''<br><br>
+''Additional details are needed''<br /><br />
-'''EstateOwner<br>
+'''EstateOwner<br />
-''Additional details are needed''<br><br>
+''Additional details are needed''<br /><br />
-'''DenyMinors<br>
+'''DenyMinors<br />
-''Additional details are needed''<br><br>
+''Additional details are needed''<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 />