spawn2¶
Info
This page was last generated 2023.07.15
Relationship Diagram(s)¶
Relationships¶
Relationship Type | Local Key | Relates to Table | Foreign Key |
---|---|---|---|
One-to-One | content_flags | content_flags | flag_name |
One-to-One | content_flags_disabled | content_flags | flag_name |
One-to-One | pathgrid | grid | id |
One-to-One | spawngroupID | spawngroup | id |
Has-Many | spawngroupID | spawnentry | spawngroupID |
One-to-One | version | zone | version |
One-to-One | zone | zone | short_name |
Schema¶
Column | Data Type | Description |
---|---|---|
id | int | Unique Spawn2 Entry Identifier |
spawngroupID | int | Unique Spawngroup Identifier |
zone | varchar | Zone Short Name |
version | smallint | Version |
x | float | X Coordinate |
y | float | Y Coordinate |
z | float | Z Coordinate |
heading | float | Heading Coordinate |
respawntime | int | Respawn Time in Seconds |
variance | int | Variance in Seconds |
pathgrid | int | Path Grid Identifier |
path_when_zone_idle | tinyint | Path When Zone Idle: 0 = False, 1 = True |
_condition | mediumint | Condition |
cond_value | mediumint | Condition Value |
enabled | tinyint | Enabled: 0 = False, 1 = True |
animation | tinyint | Animation |
min_expansion | tinyint | Minimum Expansion |
max_expansion | tinyint | Maximum Expansion |
content_flags | varchar | Content Flags Required to be Enabled |
content_flags_disabled | varchar | Content Flags Required to be Disabled |