mysql> show tables; +--------------------+ | Tables_in_smsstore | +--------------------+ | inbox | | outbox | | schema | +--------------------+ 3 rows in set (0.00 sec) mysql> describe inbox; +-----------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | | PRI | NULL | auto_increment | | stored | timestamp(14) | YES | | NULL | | | device | varchar(10) | YES | | NULL | | | fromgsm | varchar(80) | YES | | NULL | | | msgdate | varchar(9) | YES | | NULL | | | msgtime | varchar(10) | YES | | NULL | | | msgtext | text | YES | | NULL | | | processed | enum('y','n') | | | n | | +-----------+------------------+------+-----+---------+----------------+ 8 rows in set (0.00 sec) mysql> describe outbox; +----------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | | PRI | NULL | auto_increment | | stored | timestamp(14) | YES | | NULL | | | smsc | varchar(80) | | | default | | | togsm | varchar(80) | | | | | | userid | varchar(12) | | | | | | mode | char(3) | | | -1 | | | flash | char(1) | YES | | NULL | | | status | int(10) unsigned | | | 0 | | | qruns | int(10) unsigned | | | 0 | | | priority | int(10) unsigned | | | 3 | | | sent | datetime | YES | | NULL | | | msgtext | text | YES | | NULL | | | pdu | text | YES | | NULL | | +----------+------------------+------+-----+---------+----------------+ 13 rows in set (0.00 sec) mysql> describe schema; +----------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+------------------+------+-----+---------+-------+ | client_app | varchar(20) | | PRI | | | | schema_version | int(10) unsigned | YES | | NULL | | +----------------+------------------+------+-----+---------+-------+ 2 rows in set (0.00 sec) mysql>