All pastes #920305 Raw Edit

Unnamed

public text v1 · immutable
#920305 ·published 2008-02-27 10:10 UTC
rendered paste body
+-------------------+---------------------+------+-----+---------+----------------+
| Field             | Type                | Null | Key | Default | Extra          |
+-------------------+---------------------+------+-----+---------+----------------+
| guid              | int(11)             | NO   | PRI | NULL    | auto_increment | 
| id                | int(11) unsigned    | NO   | MUL | 0       |                | 
| map               | int(11) unsigned    | NO   | MUL | 0       |                | 
| modelid           | int(11) unsigned    | YES  |     | 0       |                | 
| equipment_id      | int(11)             | NO   |     | 0       |                | 
| position_x        | float               | NO   |     | 0       |                | 
| position_y        | float               | NO   |     | 0       |                | 
| position_z        | float               | NO   |     | 0       |                | 
| orientation       | float               | NO   |     | 0       |                | 
| spawntimesecs     | int(11) unsigned    | NO   |     | 120     |                | 
| spawndist         | float               | NO   |     | 5       |                | 
| currentwaypoint   | int(11) unsigned    | NO   |     | 0       |                | 
| spawn_position_x  | float               | NO   |     | 0       |                | 
| spawn_position_y  | float               | NO   |     | 0       |                | 
| spawn_position_z  | float               | NO   |     | 0       |                | 
| spawn_orientation | float               | NO   |     | 0       |                | 
| curhealth         | int(11) unsigned    | NO   |     | 1       |                | 
| curmana           | int(11) unsigned    | NO   |     | 0       |                | 
| DeathState        | tinyint(3) unsigned | NO   |     | 0       |                | 
| MovementType      | tinyint(3) unsigned | NO   |     | 0       |                | 
| instancemode      | tinyint(1)          | NO   |     | 0       |                | 
+-------------------+---------------------+------+-----+---------+----------------+
21 rows in set (0.00 sec)

+---------------+------------------+------+-----+---------+----------------+
| Field         | Type             | Null | Key | Default | Extra          |
+---------------+------------------+------+-----+---------+----------------+
| guid          | int(11)          | NO   | PRI | NULL    | auto_increment | 
| id            | int(11) unsigned | NO   | MUL | 0       |                | 
| map           | int(11) unsigned | NO   | MUL | 0       |                | 
| position_x    | float            | NO   |     | 0       |                | 
| position_y    | float            | NO   |     | 0       |                | 
| position_z    | float            | NO   |     | 0       |                | 
| orientation   | float            | NO   |     | 0       |                | 
| rotation0     | float            | NO   |     | 0       |                | 
| rotation1     | float            | NO   |     | 0       |                | 
| rotation2     | float            | NO   |     | 0       |                | 
| rotation3     | float            | NO   |     | 0       |                | 
| spawntimesecs | int(11)          | NO   |     | 0       |                | 
| animprogress  | int(11) unsigned | NO   |     | 0       |                | 
| state         | int(11) unsigned | NO   |     | 1       |                | 
| instancemode  | tinyint(1)       | NO   |     | 0       |                | 
+---------------+------------------+------+-----+---------+----------------+
15 rows in set (0.00 sec)