Code:
mysql> desc doors;
+---------------------+----------------------+------+-----+------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------------+----------------------+------+-----+------------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| doorid | smallint(4) | NO | | 0 | |
| zone | varchar(16) | NO | MUL | | |
| version | smallint(5) unsigned | NO | | 0 | |
| name | varchar(32) | NO | | | |
| pos_y | float | NO | | 0 | |
| pos_x | float | NO | | 0 | |
| pos_z | float | NO | | 0 | |
| heading | float | NO | | 0 | |
| opentype | smallint(4) | NO | | 0 | |
| guild | smallint(4) | NO | | 0 | |
| lockpick | smallint(4) | NO | | 0 | |
| keyitem | int(11) | NO | | 0 | |
| nokeyring | tinyint(3) unsigned | NO | | 0 | |
| triggerdoor | smallint(4) | NO | | 0 | |
| triggertype | smallint(4) | NO | | 0 | |
| doorisopen | smallint(4) | NO | | 0 | |
| door_param | int(4) | NO | | 0 | |
| dest_zone | varchar(16) | YES | | NONE | |
| dest_instance | int(10) unsigned | NO | | 0 | |
| dest_x | float | YES | | 0 | |
| dest_y | float | YES | | 0 | |
| dest_z | float | YES | | 0 | |
| dest_heading | float | YES | | 0 | |
| invert_state | int(11) | YES | | 0 | |
| incline | int(11) | YES | | 0 | |
| size | smallint(5) unsigned | NO | | 100 | |
| buffer | float | YES | | 0 | |
| client_version_mask | int(10) unsigned | NO | | 4294967295 | |
| is_ldon_door | smallint(6) | NO | | 0 | |
+---------------------+----------------------+------+-----+------------+----------------+
30 rows in set (0.01 sec)
Should look like that, also client_version_mask if set incorrectly will keep them from appearing correctly.